1 PACKAGE IEC_CPN_RLSE_STTGY_PVT AUTHID CURRENT_USER AS
2 /* $Header: IECVCRLS.pls 115.20 2004/05/18 19:38:16 minwang ship $ */
3
4
5 ---------------------------------------------------------
6 -- Individual subset attributes.
7 ---------------------------------------------------------
8 TYPE WORKING_QUANTUM is TABLE of IEC_G_SUBSET_RT_INFO.WORKING_QUANTUM%TYPE index by binary_integer;
9 TYPE WORKING_QUOTA is TABLE of IEC_G_SUBSET_RT_INFO.WORKING_QUOTA%TYPE index by binary_integer;
10 TYPE QUANTUM is TABLE of IEC_G_LIST_SUBSETS.QUANTUM%TYPE index by binary_integer;
11 TYPE QUOTA is TABLE of IEC_G_LIST_SUBSETS.QUOTA%TYPE index by binary_integer;
12 TYPE QUOTA_RESET is TABLE of IEC_G_LIST_SUBSETS.QUOTA_RESET%TYPE index by binary_integer;
13 TYPE QUOTA_RESET_TIME is TABLE of IEC_G_SUBSET_RT_INFO.QUOTA_RESET_TIME%TYPE index by binary_integer;
14 TYPE RELEASE_STRATEGY is TABLE of IEC_G_LIST_SUBSETS.RELEASE_STRATEGY%TYPE index by binary_integer;
15 TYPE USE_FLAG is TABLE of IEC_G_SUBSET_RT_INFO.USE_FLAG%TYPE index by binary_integer;
16 TYPE SUBSET_PRIORITY is TABLE of IEC_G_LIST_SUBSETS.PRIORITY%TYPE;
17 TYPE SUBSET_ID is TABLE of IEC_G_LIST_SUBSETS.LIST_SUBSET_ID%TYPE;
18 TYPE FLAG_COLLECTION is TABLE of VARCHAR2(1) index by binary_integer;
19
20 ---------------------------------------------------------
21 -- Individual Entry attributes.
22 ---------------------------------------------------------
23 TYPE LIST_ENTRY_ID is TABLE of IEC_G_RETURN_ENTRIES.LIST_ENTRY_ID%TYPE index by binary_integer;
24
25 ---------------------------------------------------------
26 -- Subset Release Strategies Constants
27 ---------------------------------------------------------
28 QUANTUM_RLSE_STTGY CONSTANT VARCHAR2( 3 ) := 'QUA';
29 QUOTA_RLSE_STTGY CONSTANT VARCHAR2( 3 ) := 'QUO';
30
31 ---------------------------------------------------------
32 -- Return Code Constants.
33 ---------------------------------------------------------
34 SCHEDULE_IS_NOT_ACTIVE CONSTANT VARCHAR2(1) := 'A';
35 SCHEDULE_IS_LOCKED CONSTANT VARCHAR2(1) := 'L';
36 SCHEDULE_INTERNAL_ERROR CONSTANT VARCHAR2(1) := 'I';
37 SCHEDULE_ALL_CHECKED_OUT CONSTANT VARCHAR2(1) := 'C';
38 SCHEDULE_CALLBACK_EXPIRATION CONSTANT VARCHAR2(1) := 'X';
39 SCHEDULE_CALENDAR_RESTRICTION CONSTANT VARCHAR2(1) := 'R';
40 SCHEDULE_CALENDAR_OUT CONSTANT VARCHAR2(1) := 'F';
41 SCHEDULE_CALLBACK_OUT CONSTANT VARCHAR2(1) := 'D';
42 SCHEDULE_CALENDAR_CALLBACK CONSTANT VARCHAR2(1) := 'B';
43 SCHEDULE_CALENDAR_CALLBACK_OUT CONSTANT VARCHAR2(1) := 'Z';
44 SCHEDULE_IS_EMPTY CONSTANT VARCHAR2(1) := 'E';
45
46 ---------------------------------------------------------
47 -- Sub-Program Unit Declarations
48 -- Check if a cpn is active..
49 ---------------------------------------------------------
50 PROCEDURE IS_SCHEDULE_ACTIVE
51 (P_SCHEDULE_ID IN NUMBER
52 ,X_ACTIVE IN OUT NOCOPY VARCHAR2
53 );
54
55 -- Update RT info
56
57 PROCEDURE UPDATE_SUBSET_RT_INFO
58 (P_CAMPAIGN_ID IN NUMBER
59 ,P_LIST_HEADER_ID IN NUMBER
60 ,P_SUBSET_ID IN NUMBER
61 ,P_QUANTUM IN NUMBER
62 ,P_QUOTA IN NUMBER
63 ,P_QUOTA_RESET IN DATE
64 ,P_USE_FLAG IN VARCHAR2
65 ,X_RESULT IN OUT NOCOPY VARCHAR2
66 );
67
68 PROCEDURE GET_CALLBACKS
69 (P_SERVER_ID IN NUMBER
70 ,P_CAMPAIGN_ID IN NUMBER
71 ,P_SCHEDULE_ID IN NUMBER
72 ,P_LIST_ID IN NUMBER
73 ,P_COUNT IN NUMBER
74 ,P_VIEW_NAME IN VARCHAR2
75 ,P_RLSE_CTRL_ALG_ID IN NUMBER
76 ,X_RETURNS_ID_TAB OUT NOCOPY SYSTEM.NUMBER_TBL_TYPE
77 ,X_RETURN_CODE IN OUT NOCOPY VARCHAR2
78 );
79
80 PROCEDURE GET_CUST_CALLBACKS
81 (P_SERVER_ID IN NUMBER
82 ,P_CAMPAIGN_ID IN NUMBER
83 ,P_SCHEDULE_ID IN NUMBER
84 ,P_LIST_ID IN NUMBER
85 ,P_VIEW_NAME IN VARCHAR2
86 ,P_RLSE_CTRL_ALG_ID IN NUMBER
87 ,X_RETURNS_ID_TAB OUT NOCOPY SYSTEM.NUMBER_TBL_TYPE
88 ,X_RETURN_CODE IN OUT NOCOPY VARCHAR2
89 );
90
91 PROCEDURE GET_SUBSET_ENTRIES
92 (P_CAMPAIGN_ID IN NUMBER
93 ,P_LIST_HEADER_ID IN NUMBER
94 ,P_SUBSET_ID IN NUMBER
95 ,P_COUNT IN NUMBER
96 ,P_RLSE_CTRL_ALG_ID IN IEC_G_EXECUTING_LISTS_V.RELEASE_CONTROL_ALG_ID%TYPE
97 ,P_VIEW_NAME IN VARCHAR2
98 ,X_RETURN_CODE IN OUT NOCOPY VARCHAR2
99 ,X_RETURNS_ID_TAB IN OUT NOCOPY SYSTEM.NUMBER_TBL_TYPE
100 );
101
102
103 PROCEDURE GET_SCHED_ENTRIES
104 (P_CAMPAIGN_ID IN NUMBER
105 ,P_SCHED_ID IN NUMBER
106 ,P_LIST_HEADER_ID IN NUMBER
107 ,P_COUNT IN NUMBER
108 ,P_VIEW_NAME IN VARCHAR2
109 ,P_RLSE_CTRL_ALG_ID IN NUMBER
110 ,X_RETURN_CODE IN OUT NOCOPY VARCHAR2
111 ,X_RETURNS_ID_TAB IN OUT NOCOPY SYSTEM.NUMBER_TBL_TYPE
112 );
113
114 -- Get the records.
115
116 PROCEDURE GET_RECORDS
117 (P_SERVER_ID IN NUMBER
118 ,P_CAMPAIGN_ID IN NUMBER
119 ,P_SCHED_ID IN NUMBER
120 ,P_TARGET_GROUP_ID IN NUMBER
121 ,P_COUNT IN NUMBER
122 ,P_VIEW_NAME IN VARCHAR2
123 ,P_RLSE_CTRL_ALG_ID IN NUMBER
124 ,X_CACHE_RECORDS OUT NOCOPY SYSTEM.NUMBER_TBL_TYPE
125 ,X_RETURN_CODE OUT NOCOPY VARCHAR2
126 );
127
128
129 END IEC_CPN_RLSE_STTGY_PVT;