Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE TYPE REVELATION."OBJ$CAMPAIGN" AS OBJECT (
- id NUMBER,
- clientID NUMBER,
- objectID NUMBER,
- scriptID NUMBER,
- scriptCode VARCHAR2(255),
- channelID NUMBER,
- TYPE VARCHAR2(255),
- status NUMBER,
- code VARCHAR2(255),
- startdate DATE,
- enddate DATE,
- nextdate DATE,
- state VARCHAR2(20),
- name VARCHAR2(255),
- itemCode VARCHAR2(255),
- itemName VARCHAR2(255),
- itemNodeID NUMBER,
- itemID NUMBER,
- CONSTRUCTOR FUNCTION Obj$Campaign(id NUMBER DEFAULT NULL) RETURN SELF AS RESULT,
- MEMBER PROCEDURE save,
- MEMBER PROCEDURE STOP,
- MEMBER PROCEDURE finish,
- MEMBER PROCEDURE addCall (ProductID NUMBER,
- Subject VARCHAR2 DEFAULT 'S300.01',
- ChannelID NUMBER DEFAULT -1,
- SaleID NUMBER DEFAULT NULL,
- Price NUMBER DEFAULT NULL,
- Discount NUMBER DEFAULT NULL,
- ProductMode NUMBER DEFAULT 1),
- MEMBER PROCEDURE CallComplete (Subject VARCHAR2 DEFAULT 'S300.01'),
- MEMBER PROCEDURE CallRelease,
- MEMBER FUNCTION existsCall (OnlyActive BOOLEAN DEFAULT FALSE) RETURN BOOLEAN,
- MEMBER FUNCTION getOrderedItems (categoryCode VARCHAR2 DEFAULT NULL) RETURN NUMBER,
- MEMBER FUNCTION getMaxSentDate (categoryCode VARCHAR2 DEFAULT NULL) RETURN DATE,
- MEMBER FUNCTION getSubject (subjectCode VARCHAR2 DEFAULT NULL) RETURN NUMBER,
- MEMBER FUNCTION ObjectBelongsToOffer (code VARCHAR2, fl NUMBER DEFAULT 0) RETURN BOOLEAN,
- MEMBER FUNCTION getSkipREM_1 RETURN BOOLEAN,
- MEMBER FUNCTION getMaxSubjDate (subjCode VARCHAR2) RETURN DATE,
- MEMBER FUNCTION getAddTMCall RETURN NUMBER,
- MEMBER FUNCTION getSkipREM_1_2 RETURN BOOLEAN
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement