Advertisement
VoronVU

OBJ_CAMPAIGN_CODE_V1

Apr 8th, 2015
1,129
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE OR REPLACE TYPE REVELATION."OBJ$CAMPAIGN" AS OBJECT (
  2.   id         NUMBER,
  3.   clientID   NUMBER,
  4.   objectID   NUMBER,
  5.   scriptID   NUMBER,
  6.   scriptCode VARCHAR2(255),
  7.   channelID  NUMBER,
  8.   TYPE       VARCHAR2(255),
  9.   status     NUMBER,
  10.   code       VARCHAR2(255),
  11.   startdate  DATE,
  12.   enddate    DATE,
  13.   nextdate   DATE,
  14.   state      VARCHAR2(20),
  15.   name       VARCHAR2(255),
  16.   itemCode   VARCHAR2(255),
  17.   itemName   VARCHAR2(255),
  18.   itemNodeID NUMBER,
  19.   itemID     NUMBER,
  20.  
  21.   CONSTRUCTOR FUNCTION Obj$Campaign(id NUMBER DEFAULT NULL) RETURN SELF AS RESULT,
  22.   MEMBER PROCEDURE save,
  23.   MEMBER PROCEDURE STOP,
  24.   MEMBER PROCEDURE finish,
  25.   MEMBER PROCEDURE addCall (ProductID   NUMBER,
  26.                             Subject     VARCHAR2 DEFAULT 'S300.01',
  27.                             ChannelID   NUMBER   DEFAULT -1,
  28.                             SaleID      NUMBER   DEFAULT NULL,
  29.                             Price       NUMBER   DEFAULT NULL,
  30.                             Discount    NUMBER   DEFAULT NULL,
  31.                             ProductMode NUMBER   DEFAULT 1),
  32.   MEMBER PROCEDURE CallComplete (Subject     VARCHAR2 DEFAULT 'S300.01'),                
  33.   MEMBER PROCEDURE CallRelease,                
  34.   MEMBER FUNCTION  existsCall (OnlyActive BOOLEAN DEFAULT FALSE)  RETURN BOOLEAN,
  35.   MEMBER FUNCTION  getOrderedItems (categoryCode VARCHAR2 DEFAULT NULL) RETURN NUMBER,
  36.   MEMBER FUNCTION  getMaxSentDate  (categoryCode VARCHAR2 DEFAULT NULL) RETURN DATE,  
  37.   MEMBER FUNCTION  getSubject (subjectCode VARCHAR2 DEFAULT NULL) RETURN NUMBER,
  38.   MEMBER FUNCTION  ObjectBelongsToOffer (code VARCHAR2, fl NUMBER DEFAULT 0) RETURN BOOLEAN,
  39.   MEMBER FUNCTION  getSkipREM_1  RETURN BOOLEAN,
  40.   MEMBER FUNCTION  getMaxSubjDate (subjCode VARCHAR2) RETURN DATE,
  41.   MEMBER FUNCTION  getAddTMCall RETURN NUMBER,
  42.   MEMBER FUNCTION  getSkipREM_1_2 RETURN BOOLEAN
Advertisement
RAW Paste Data Copied
Advertisement