1 PACKAGE ast_grp_camp_PVT AUTHID CURRENT_USER as
2 /* $Header: astvgcas.pls 115.4 2002/02/05 17:28:58 pkm ship $ */
3 -- Start of Comments
4 -- Package name : ast_grp_camp_PVT
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 -- Default number of records fetch per call
11 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
12 -- *******************************************************
13 -- Start of Comments
14 -- -------------------------------------------------------
15 -- Record name:grp_camp_Rec_Type
16 -- -------------------------------------------------------
17 -- Parameters:
18 -- GROUP_CAMPAIGN_ID
19 -- GROUP_ID
20 -- CAMPAIGN_ID
21 -- START_DATE
22 -- END_DATE
23 -- ENABLED_FLAG
24 -- LAST_UPDATE_DATE
25 -- LAST_UPDATED_BY
26 -- LAST_UPDATE_LOGIN
27 -- CREATED_BY
28 -- CREATION_DATE
29 --
30 -- Required:
31 -- Defaults:
32 -- Note: This is automatic generated record definition, it includes all columns
33 -- defined in the table, developer must manually add or delete some of the attributes.
34 --
35 -- End of Comments
36
37 TYPE grp_camp_Rec_Type IS RECORD
38 (
39 GROUP_CAMPAIGN_ID NUMBER := FND_API.G_MISS_NUM,
40 GROUP_ID NUMBER := FND_API.G_MISS_NUM,
41 CAMPAIGN_ID NUMBER := FND_API.G_MISS_NUM,
42 START_DATE DATE := FND_API.G_MISS_DATE,
43 END_DATE DATE := FND_API.G_MISS_DATE,
44 ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
45 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
46 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
47 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
48 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
49 CREATION_DATE DATE := FND_API.G_MISS_DATE
50 );
51
52 G_MISS_grp_camp_REC grp_camp_Rec_Type;
53 TYPE grp_camp_Tbl_Type IS TABLE OF grp_camp_Rec_Type
54 INDEX BY BINARY_INTEGER;
55 G_MISS_grp_camp_TBL grp_camp_Tbl_Type;
56
57 -- *******************************************************
58 -- Start of Comments
59 -- *******************************************************
60 -- API Name: Create_grp_camp
61 -- Type : Private
62 -- Pre-Req :
63 -- Parameters:
64 -- IN
65 -- p_api_version_number IN NUMBER Required
66 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
67 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
68 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
69 -- P_grp_camp_Rec IN grp_camp_Rec_Type Required
70 --
71 -- OUT:
72 -- x_return_status OUT VARCHAR2
73 -- x_msg_count OUT NUMBER
74 -- x_msg_data OUT VARCHAR2
75 -- Version : Current version 2.0
76 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
77 -- and basic operation, developer must manually add parameters and business logic as necessary.
78 --
79 -- End of Comments
80 --
81
82
83 FUNCTION get_grp_Campaign_rec RETURN ast_grp_camp_pvt.grp_camp_rec_type ;
84
85
86 PROCEDURE Create_grp_camp(
87 P_Api_Version_Number IN NUMBER,
88 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
89 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
90 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
91 P_grp_camp_Rec IN grp_camp_Rec_Type := G_MISS_grp_camp_REC,
92 --Hint: Add detail tables as parameter lists if it's master-detail relationship.
93 X_GROUP_CAMPAIGN_ID OUT NUMBER,
94 X_Return_Status OUT VARCHAR2,
95 X_Msg_Count OUT NUMBER,
96 X_Msg_Data OUT VARCHAR2
97 );
98
99 -- *******************************************************
100 -- Start of Comments
101 -- *******************************************************
102 -- API Name: Update_grp_camp
103 -- Type : Private
104 -- Pre-Req :
105 -- Parameters:
106 -- IN
107 -- p_api_version_number IN NUMBER Required
108 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
109 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
110 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
111 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
112 -- P_grp_camp_Rec IN grp_camp_Rec_Type Required
113 --
114 -- OUT:
115 -- x_return_status OUT VARCHAR2
116 -- x_msg_count OUT NUMBER
117 -- x_msg_data OUT VARCHAR2
118 -- Version : Current version 2.0
119 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
120 -- and basic operation, developer must manually add parameters and business logic as necessary.
121 --
122 -- End of Comments
123 --
124 -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
125 PROCEDURE Update_grp_camp(
126 P_Api_Version_Number IN NUMBER,
127 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
128 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
129 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
130 P_Identity_Salesforce_Id IN NUMBER := NULL,
131 P_grp_camp_Rec IN grp_camp_Rec_Type,
132 X_Return_Status OUT VARCHAR2,
133 X_Msg_Count OUT NUMBER,
134 X_Msg_Data OUT VARCHAR2
135 );
136
137 -- *******************************************************
138 -- Start of Comments
139 -- *******************************************************
140 -- API Name: Delete_grp_camp
141 -- Type : Private
142 -- Pre-Req :
143 -- Parameters:
144 -- IN
145 -- p_api_version_number IN NUMBER Required
146 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
147 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
148 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
149 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
150 -- P_grp_camp_Rec IN grp_camp_Rec_Type Required
151 --
152 -- OUT:
153 -- x_return_status OUT VARCHAR2
154 -- x_msg_count OUT NUMBER
155 -- x_msg_data OUT VARCHAR2
156 -- Version : Current version 2.0
157 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
158 -- and basic operation, developer must manually add parameters and business logic as necessary.
159 --
160 -- End of Comments
161 --
162 -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
163 -- The Master delete procedure may not be needed depends on different business requirements.
164 PROCEDURE Delete_grp_camp(
165 P_Api_Version_Number IN NUMBER,
166 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
167 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
168 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
169 P_identity_salesforce_id IN NUMBER := NULL,
170 P_grp_camp_Rec IN grp_camp_Rec_Type,
171 X_Return_Status OUT VARCHAR2,
172 X_Msg_Count OUT NUMBER,
173 X_Msg_Data OUT VARCHAR2
174 );
175
176 -- *******************************************************
177 -- Start of Comments
178 -- *******************************************************
179 -- API Name: Get_grp_camp
180 -- Type : Private
181 -- Pre-Req :
182 -- Parameters:
183 -- IN
184 -- p_api_version_number IN NUMBER Required
185 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
186 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
187 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
188 -- P_grp_camp_Rec IN grp_camp_Rec_Type Required
189 -- Hint: Add List of bind variables here
190 -- p_rec_requested IN NUMBER Optional Default = 30
191 -- p_start_rec_ptr IN NUMBER Optional Default = 1
192 --
193 -- Return Total Records Count Flag. This flag controls whether the total record count
194 -- and total record amount is returned.
195 --
196 -- p_return_tot_count IN VARCHAR2 Optional Default = FND_API.G_FALSE
197 -- Hint: User defined record type
198 -- p_order_by_tbl IN JTF_PLSQL_API.UTIL_ORDER_BY_TBL_TYPE;
199 --
200 -- OUT:
201 -- x_return_status OUT VARCHAR2
202 -- x_msg_count OUT NUMBER
203 -- x_msg_data OUT VARCHAR2
204 -- X_grp_camp_Tbl OUT grp_camp_Rec_Type
205 -- x_returned_rec_count OUT NUMBER
206 -- x_next_rec_ptr OUT NUMBER
207 -- x_tot_rec_count OUT NUMBER
208 -- other optional out parameters
209 -- x_tot_rec_amount OUT NUMBER
210 -- Version : Current version 2.0
211 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
212 -- and basic operation, developer must manually add parameters and business logic as necessary.
213 --
214 -- End of Comments
215 --
216 PROCEDURE Get_grp_camp(
217 P_Api_Version_Number IN NUMBER,
218 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
219 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
220 P_identity_salesforce_id IN NUMBER := NULL,
221 P_grp_camp_Rec IN ast_grp_camp_PUB.grp_camp_Rec_Type,
222 -- Hint: Add list of bind variables here
223 p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
224 p_start_rec_prt IN NUMBER := 1,
225 p_return_tot_count IN NUMBER := FND_API.G_FALSE,
226 -- Hint: user defined record type
227 p_order_by_rec IN ast_grp_camp_PUB.grp_camp_sort_rec_type,
228 x_return_status OUT VARCHAR2,
229 x_msg_count OUT NUMBER,
230 x_msg_data OUT VARCHAR2,
231 X_grp_camp_Tbl OUT ast_grp_camp_PUB.grp_camp_Tbl_Type,
232 x_returned_rec_count OUT NUMBER,
233 x_next_rec_ptr OUT NUMBER,
234 x_tot_rec_count OUT NUMBER
235 -- other optional parameters
236 -- x_tot_rec_amount OUT NUMBER
237 );
238
239
240 -- Start of Comments
241 --
242 -- Item level validation procedures
243 --
244 -- p_validation_mode is a constant defined in package
245 -- For create: G_CREATE, for update: G_UPDATE
246 -- Note: 1. This is automated generated item level validation procedure.
247 -- The actual validation detail is needed to be added.
248 --
249 -- End of Comments
250
251 PROCEDURE Validate_GROUP_CAMPAIGN_ID (
252 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
253 P_Validation_mode IN VARCHAR2,
254 P_GROUP_CAMPAIGN_ID IN NUMBER,
255 -- Hint: You may add 'X_Item_Property_Rec OUT JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
256
257 X_Return_Status OUT VARCHAR2,
258 X_Msg_Count OUT NUMBER,
259 X_Msg_Data OUT VARCHAR2
260 );
261
262 -- Start of Comments
263 --
264 -- Item level validation procedures
265 --
266 -- p_validation_mode is a constant defined in package
267 -- For create: G_CREATE, for update: G_UPDATE
268 -- Note: 1. This is automated generated item level validation procedure.
269 -- The actual validation detail is needed to be added.
270 --
271 -- End of Comments
272
273 PROCEDURE Validate_GROUP_ID (
274 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
275 P_Validation_mode IN VARCHAR2,
276 P_GROUP_ID IN NUMBER,
277 -- Hint: You may add 'X_Item_Property_Rec OUT JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
278
279 X_Return_Status OUT VARCHAR2,
280 X_Msg_Count OUT NUMBER,
281 X_Msg_Data OUT VARCHAR2
282 );
283
284 -- Start of Comments
285 --
286 -- Item level validation procedures
287 --
288 -- p_validation_mode is a constant defined in package
289 -- For create: G_CREATE, for update: G_UPDATE
290 -- Note: 1. This is automated generated item level validation procedure.
291 -- The actual validation detail is needed to be added.
292 --
293 -- End of Comments
294
295 PROCEDURE Validate_CAMPAIGN_ID (
296 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
297 P_Validation_mode IN VARCHAR2,
298 P_CAMPAIGN_ID IN NUMBER,
299 -- Hint: You may add 'X_Item_Property_Rec OUT JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
300
301 X_Return_Status OUT VARCHAR2,
302 X_Msg_Count OUT NUMBER,
303 X_Msg_Data OUT VARCHAR2
304 );
305
306 -- Start of Comments
307 --
308 -- Item level validation procedures
309 --
310 -- p_validation_mode is a constant defined in package
311 -- For create: G_CREATE, for update: G_UPDATE
312 -- Note: 1. This is automated generated item level validation procedure.
313 -- The actual validation detail is needed to be added.
314 --
315 -- End of Comments
316
317 PROCEDURE Validate_START_DATE (
318 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
319 P_Validation_mode IN VARCHAR2,
320 P_START_DATE IN DATE,
321 -- Hint: You may add 'X_Item_Property_Rec OUT JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
322
323 X_Return_Status OUT VARCHAR2,
324 X_Msg_Count OUT NUMBER,
325 X_Msg_Data OUT VARCHAR2
326 );
327
328 -- Start of Comments
329 --
330 -- Item level validation procedures
331 --
332 -- p_validation_mode is a constant defined in package
333 -- For create: G_CREATE, for update: G_UPDATE
334 -- Note: 1. This is automated generated item level validation procedure.
335 -- The actual validation detail is needed to be added.
336 --
337 -- End of Comments
338
339 PROCEDURE Validate_END_DATE (
340 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
341 P_Validation_mode IN VARCHAR2,
342 P_END_DATE IN DATE,
343 -- Hint: You may add 'X_Item_Property_Rec OUT JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
344
345 X_Return_Status OUT VARCHAR2,
346 X_Msg_Count OUT NUMBER,
347 X_Msg_Data OUT VARCHAR2
348 );
349
350 -- Start of Comments
351 --
352 -- Item level validation procedures
353 --
354 -- p_validation_mode is a constant defined in package
355 -- For create: G_CREATE, for update: G_UPDATE
356 -- Note: 1. This is automated generated item level validation procedure.
357 -- The actual validation detail is needed to be added.
358 --
359 -- End of Comments
360
361 PROCEDURE Validate_ENABLED_FLAG (
362 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
363 P_Validation_mode IN VARCHAR2,
364 P_ENABLED_FLAG IN VARCHAR2,
365 -- Hint: You may add 'X_Item_Property_Rec OUT JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
366
367 X_Return_Status OUT VARCHAR2,
368 X_Msg_Count OUT NUMBER,
369 X_Msg_Data OUT VARCHAR2
370 );
371
372 -- Start of Comments
373 --
374 -- Record level validation procedures
375 --
376 -- p_validation_mode is a constant defined in package
377 -- For create: G_CREATE, for update: G_UPDATE
378 -- Note: 1. This is automated generated item level validation procedure.
379 -- The actual validation detail is needed to be added.
380 -- 2. Developer can manually added inter-field level validation.
381 -- End of Comments
382
383 PROCEDURE Validate_grp_camp_rec(
384 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
385 P_Validation_mode IN VARCHAR2,
386 P_grp_camp_Rec IN grp_camp_Rec_Type,
387 X_Return_Status OUT VARCHAR2,
388 X_Msg_Count OUT NUMBER,
389 X_Msg_Data OUT VARCHAR2
390 );
391
392 -- Start of Comments
393 --
394 -- validation procedures
395 --
396 -- p_validation_mode is a constant defined in package
397 -- For create: G_CREATE, for update: G_UPDATE
398 -- Note: 1. This is automated generated item level validation procedure.
399 -- The actual validation detail is needed to be added.
400 -- 2. We can also validate table instead of record. There will be an option for user to choose.
401 -- End of Comments
402
403 PROCEDURE Validate_grp_camp(
404 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
405 P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
406 P_Validation_mode IN VARCHAR2,
407 P_grp_camp_Rec IN grp_camp_Rec_Type,
408 X_Return_Status OUT VARCHAR2,
409 X_Msg_Count OUT NUMBER,
410 X_Msg_Data OUT VARCHAR2
411 );
412 End ast_grp_camp_PVT;