1 PACKAGE IEC_SUBSET_PVT AUTHID CURRENT_USER AS
2 /* $Header: IECOCSBS.pls 115.13 2003/09/09 23:14:57 alromero noship $ */
3
4 -----------------------------++++++-------------------------------
5 --
6 -- Start of comments
7 --
8 -- API name : DROP_TARGET_GROUP_VIEWS
9 -- Type : Public
10 -- Pre-reqs : None
11 -- Function : For each subset in the specified target group,
12 -- drop the subset view.
13 --
14 -- Parameters : P_SOURCE_ID IN NUMBER Required
15 -- P_TARGET_GROUP_ID IN NUMBER Required
16 -- X_RETURN_CODE OUT VARCHAR2 Required
17 --
18 -- Version : Initial version 1.0
19 --
20 -- End of comments
21 --
22 -----------------------------++++++-------------------------------
23 PROCEDURE DROP_TARGET_GROUP_VIEWS
24 ( P_SOURCE_ID IN NUMBER
25 , P_TARGET_GROUP_ID IN NUMBER
26 , X_RETURN_CODE OUT NOCOPY VARCHAR2
27 );
28
29 -----------------------------++++++-------------------------------
30 -- Start of comments
31 --
32 -- API name : GET_SUBSET_VIEW
33 -- Type : Public
34 -- Pre-reqs : None
35 -- Function : Returns the subset view name after verifying that the view
36 -- exists, creating the view if necessary.
37 --
38 -- Parameters : P_SOURCE_ID IN NUMBER Required
39 -- P_TARGET_GROUP_ID IN NUMBER Required
40 -- P_SUBSET_ID IN NUMBER Required
41 -- P_DEFAULT_SUBSET_FLAG IN VARCHAR2 Required
42 -- P_SOURCE_TYPE_VIEW_NAME IN VARCHAR2 Required
43 -- X_RETURN_CODE OUT VARCHAR2 Required
44 --
45 -- Version : Initial version 1.0
46 --
47 -- End of comments
48 --
49 -----------------------------++++++-------------------------------
50 FUNCTION GET_SUBSET_VIEW
51 ( P_SOURCE_ID IN NUMBER
52 , P_TARGET_GROUP_ID IN NUMBER
53 , P_SUBSET_ID IN NUMBER
54 , P_DEFAULT_SUBSET_FLAG IN VARCHAR2
55 , P_SOURCE_TYPE_VIEW_NAME IN VARCHAR2
56 , X_RETURN_CODE OUT NOCOPY VARCHAR2
57 )
58 RETURN VARCHAR2;
59
60 -----------------------------++++++-------------------------------
61 -- Start of comments
62 --
63 -- API name : CREATE_SUBSET_VIEW
64 -- Type : Public
65 -- Pre-reqs : None
66 -- Function : Creates a view for the specified subset using
67 -- the view name provided.
68 --
69 -- Parameters : P_SOURCE_ID IN NUMBER Required
70 -- P_SUBSET_ID IN NUMBER Required
71 -- P_VIEW_NAME IN VARCHAR2 Required
72 -- P_TARGET_GROUP_ID IN NUMBER Required
73 -- P_SOURCE_TYPE_VIEW_NAME IN VARCHAR2 Required
74 -- P_DEFAULT_SUBSET_FLAG IN VARCHAR2 Required
75 -- X_RETURN_CODE OUT VARCHAR2 Required
76 --
77 -- Version : Initial version 1.0
78 --
79 -- End of comments
80 --
81 -----------------------------++++++-------------------------------
82 PROCEDURE CREATE_SUBSET_VIEW
83 ( P_SOURCE_ID IN NUMBER
84 , P_SUBSET_ID IN NUMBER
85 , P_VIEW_NAME IN VARCHAR2
86 , P_TARGET_GROUP_ID IN NUMBER
87 , P_SOURCE_TYPE_VIEW_NAME IN VARCHAR2
88 , P_DEFAULT_SUBSET_FLAG IN VARCHAR2
89 , X_RETURN_CODE OUT NOCOPY VARCHAR2
90 );
91
92 -----------------------------++++++-------------------------------
93 -- Start of comments
94 --
95 -- API name : DROP_SUBSET_VIEW
96 -- Type : Public
97 -- Pre-reqs : None
98 -- Function : Drops the view defined for the specified subset.
99 --
100 -- Parameters : P_SOURCE_ID IN NUMBER Required
101 -- P_SUBSET_ID IN NUMBER Required
102 -- X_RETURN_CODE OUT VARCHAR2 Required
103 --
104 -- Version : Initial version 1.0
105 --
106 -- End of comments
107 --
108 -----------------------------++++++-------------------------------
109 PROCEDURE DROP_SUBSET_VIEW
110 ( P_SOURCE_ID IN NUMBER
111 , P_SUBSET_ID IN NUMBER
112 , X_RETURN_CODE OUT NOCOPY VARCHAR2
113 );
114
115 -----------------------------++++++-------------------------------
116 --
117 -- Start of comments
118 --
119 -- API name : RECREATE_SUBSET_VIEW
120 -- Type : Public
121 -- Pre-reqs : None
122 -- Procedure : Recreates the subset view, deleting it first if necessary.
123 --
124 -- Parameters : P_SOURCE_ID IN NUMBER Required
125 -- P_TARGET_GROUP_ID IN NUMBER Required
126 -- P_SUBSET_ID IN NUMBER Required
127 -- X_SUBSET_VIEW_NAME OUT NOCOPY VARCHAR2 Required
128 --
129 -- Version : Initial version 1.0
130 --
131 -- End of comments
132 --
133 -----------------------------++++++-------------------------------
134 PROCEDURE RECREATE_SUBSET_VIEW
135 ( P_SOURCE_ID IN NUMBER
136 , P_TARGET_GROUP_ID IN NUMBER
137 , P_SUBSET_ID IN NUMBER
138 , X_SUBSET_VIEW_NAME OUT NOCOPY VARCHAR2
139 );
140
141 -----------------------------++++++-------------------------------
142 --
143 -- Start of comments
144 --
145 -- API name : CREATE_SUBSET_RT_INFO
146 -- Type : Public
147 -- Pre-reqs : None
148 -- Function : If the subset runtime information entries do not
149 -- already exist, create them.
150 --
151 -- Parameters : P_SUBSET_ID IN NUMBER Required
152 --
153 -- Version : Initial version 1.0
154 --
155 -- End of comments
156 --
157 -----------------------------++++++-------------------------------
158 PROCEDURE CREATE_SUBSET_RT_INFO
159 ( P_SUBSET_ID IN NUMBER
160 );
161
162 -----------------------------++++++-------------------------------
163 --
164 -- Start of comments
165 --
166 -- API name : SUBSET_TRANSITION
167 -- Type : Public
168 -- Pre-reqs : None
169 -- Function :
170 -- Parameters : P_SOURCE_ID IN NUMBER Required
171 -- P_SERVER_ID IN NUMBER Required
172 -- P_TARGET_GROUP_ID IN NUMBER Required
173 -- P_FROM_SUBSETS IN NUMBER_TBL_TYPE Required
174 -- P_INTO_SUBSETS IN NUMBER_TBL_TYPE Required
175 -- P_ACTION_TYPE IN VARCHAR2 Required
176 -- X_NUM_PENDING OUT NUMBER Required
177 -- X_ACTION_ID OUT NUMBER Required
178 --
179 -- Version : Initial version 1.0
180 --
181 -- End of comments
182 --
183 -----------------------------++++++-------------------------------
184 PROCEDURE SUBSET_TRANSITION
185 ( P_SOURCE_ID IN NUMBER
186 , P_SERVER_ID IN NUMBER
187 , P_CAMPAIGN_ID IN NUMBER
188 , P_SCHEDULE_ID IN NUMBER
189 , P_TARGET_GROUP_ID IN NUMBER
190 , P_FROM_SUBSETS IN SYSTEM.NUMBER_TBL_TYPE
191 , P_INTO_SUBSETS IN SYSTEM.NUMBER_TBL_TYPE
192 , P_ACTION_TYPE IN VARCHAR2
193 , X_NUM_PENDING OUT NOCOPY NUMBER
194 , X_ACTION_ID OUT NOCOPY NUMBER
195 );
196
197 -----------------------------++++++-------------------------------
198 --
199 -- Start of comments
200 --
201 -- API name : CONTINUAL_TRANSITION
202 -- Type : Public
203 -- Pre-reqs : None
204 -- Function :
205 -- Parameters : P_SOURCE_ID IN NUMBER Required
206 -- P_TARGET_GROUP_ID IN NUMBER Required
207 -- X_NUM_REMAINING OUT NUMBER Required
208 -- X_ACTION_ID OUT NUMBER Required
209 --
210 -- Version : Initial version 1.0
211 --
212 -- End of comments
213 --
214 -----------------------------++++++-------------------------------
215 PROCEDURE CONTINUAL_TRANSITION
216 ( P_SOURCE_ID IN NUMBER
217 , P_CAMPAIGN_ID IN NUMBER
218 , P_SCHEDULE_ID IN NUMBER
219 , P_TARGET_GROUP_ID IN NUMBER
220 , X_NUM_REMAINING OUT NOCOPY NUMBER
221 , X_ACTION_ID OUT NOCOPY NUMBER
222 );
223
224 END IEC_SUBSET_PVT;