1 PACKAGE AST_rs_camp_PVT as
2 /* $Header: astvrcas.pls 120.1 2005/06/01 04:29:25 appldev $ */
3 -- Start of Comments
4 -- Package name : AST_rs_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:rs_camp_Rec_Type
16 -- -------------------------------------------------------
17 -- Parameters:
18 -- RS_CAMPAIGN_ID
19 -- RESOURCE_ID
20 -- CAMPAIGN_ID
21 -- START_DATE
22 -- END_DATE
23 -- STATUS
24 -- ENABLED_FLAG
25 -- CREATED_BY
26 -- CREATION_DATE
27 -- LAST_UPDATED_BY
28 -- LAST_UPDATE_DATE
29 -- LAST_UPDATE_LOGIN
30 --
31 -- Required:
32 -- Defaults:
33 -- Note: This is automatic generated record definition, it includes all columns
34 -- defined in the table, developer must manually add or delete some of the attributes.
35 --
36 -- End of Comments
37
38 TYPE rs_camp_Rec_Type IS RECORD
39 (
40 RS_CAMPAIGN_ID NUMBER := FND_API.G_MISS_NUM,
41 RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
42 CAMPAIGN_ID NUMBER := FND_API.G_MISS_NUM,
43 START_DATE DATE := FND_API.G_MISS_DATE,
44 END_DATE DATE := FND_API.G_MISS_DATE,
45 STATUS VARCHAR2(1) := FND_API.G_MISS_CHAR,
46 ENABLED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
47 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
48 CREATION_DATE DATE := FND_API.G_MISS_DATE,
49 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
50 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
51 LAST_UPDATE_LOGIN VARCHAR2(240) := FND_API.G_MISS_CHAR
52 );
53
54 G_MISS_rs_camp_REC rs_camp_Rec_Type;
55 TYPE rs_camp_Tbl_Type IS TABLE OF rs_camp_Rec_Type
56 INDEX BY BINARY_INTEGER;
57 G_MISS_rs_camp_TBL rs_camp_Tbl_Type;
58
59 -- *******************************************************
60 -- Start of Comments
61 -- *******************************************************
62 -- API Name: Create_rs_camp
63 -- Type : Private
64 -- Pre-Req :
65 -- Parameters:
66 -- IN
67 -- p_api_version_number IN NUMBER Required
68 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
69 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
70 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
71 -- P_rs_camp_Rec IN rs_camp_Rec_Type Required
72 --
73 -- OUT:
74 -- x_return_status OUT VARCHAR2
75 -- x_msg_count OUT NUMBER
76 -- x_msg_data OUT VARCHAR2
77 -- Version : Current version 2.0
78 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
79 -- and basic operation, developer must manually add parameters and business logic as necessary.
80
81 --
82 -- End of Comments
83 --
84 FUNCTION get_CAMPAIGN_REC RETURN AST_RS_CAMP_PVT.rs_camp_rec_type;
85
86 PROCEDURE Create_rs_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_rs_camp_Rec IN rs_camp_Rec_Type := G_MISS_rs_camp_REC,
92 --Hint: Add detail tables as parameter lists if it's master-detail relationship.
93 X_RS_CAMPAIGN_ID OUT NOCOPY /* file.sql.39 change */ NUMBER,
94 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
95 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
96 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
97 );
98
99 -- *******************************************************
100 -- Start of Comments
101 -- *******************************************************
102 -- API Name: Update_rs_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_rs_camp_Rec IN rs_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 --
123 -- End of Comments
124 --
125 -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
126 PROCEDURE Update_rs_camp(
127 P_Api_Version_Number IN NUMBER,
128 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
129 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
130 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
131 P_Identity_Salesforce_Id IN NUMBER := NULL,
132 P_rs_camp_Rec IN rs_camp_Rec_Type,
133 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
134 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
135 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
136 );
137
138 -- *******************************************************
139 -- Start of Comments
140 -- *******************************************************
141 -- API Name: Delete_rs_camp
142 -- Type : Private
143 -- Pre-Req :
144 -- Parameters:
145 -- IN
146 -- p_api_version_number IN NUMBER Required
147 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
148 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
149 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
150 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
151 -- P_rs_camp_Rec IN rs_camp_Rec_Type Required
152 --
153 -- OUT:
154 -- x_return_status OUT VARCHAR2
155 -- x_msg_count OUT NUMBER
156 -- x_msg_data OUT VARCHAR2
157 -- Version : Current version 2.0
158 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
159 -- and basic operation, developer must manually add parameters and business logic as necessary.
160
161 --
162 -- End of Comments
163 --
164 -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
165 -- The Master delete procedure may not be needed depends on different business requirements.
166 PROCEDURE Delete_rs_camp(
167 P_Api_Version_Number IN NUMBER,
168 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
169 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
170 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
171 P_identity_salesforce_id IN NUMBER := NULL,
172 P_rs_camp_Rec IN rs_camp_Rec_Type,
173 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
174 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
175 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
176 );
177
178 -- *******************************************************
179 -- Start of Comments
180 -- *******************************************************
181 -- API Name: Get_rs_camp
182 -- Type : Private
183 -- Pre-Req :
184 -- Parameters:
185 -- IN
186 -- p_api_version_number IN NUMBER Required
187 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
188 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
189 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
190 -- P_rs_camp_Rec IN rs_camp_Rec_Type Required
191 -- Hint: Add List of bind variables here
192 -- p_rec_requested IN NUMBER Optional Default = 30
193 -- p_start_rec_ptr IN NUMBER Optional Default = 1
194 --
195 -- Return Total Records Count Flag. This flag controls whether the total record count
196 -- and total record amount is returned.
197 --
198 -- p_return_tot_count IN VARCHAR2 Optional Default = FND_API.G_FALSE
199 -- Hint: User defined record type
200 -- p_order_by_tbl IN JTF_PLSQL_API.UTIL_ORDER_BY_TBL_TYPE;
201 --
202 -- OUT:
203 -- x_return_status OUT VARCHAR2
204 -- x_msg_count OUT NUMBER
205 -- x_msg_data OUT VARCHAR2
206 -- X_rs_camp_Tbl OUT rs_camp_Rec_Type
207 -- x_returned_rec_count OUT NUMBER
208 -- x_next_rec_ptr OUT NUMBER
209 -- x_tot_rec_count OUT NUMBER
210 -- other optional OUT parameters
211 -- x_tot_rec_amount OUT NUMBER
212 -- Version : Current version 2.0
213 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
214 -- and basic operation, developer must manually add parameters and business logic as necessary.
215
216 --
217 -- End of Comments
218 --
219 PROCEDURE Get_rs_camp(
220 P_Api_Version_Number IN NUMBER,
221 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
222 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
223 P_identity_salesforce_id IN NUMBER := NULL,
224 P_rs_camp_Rec IN AST_rs_camp_PUB.rs_camp_Rec_Type,
225 -- Hint: Add list of bind variables here
226 p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
227 p_start_rec_prt IN NUMBER := 1,
228 p_return_tot_count IN NUMBER := FND_API.G_FALSE,
229 -- Hint: user defined record type
230 p_order_by_rec IN AST_rs_camp_PUB.rs_camp_sort_rec_type,
231 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
232 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
233 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
234 X_rs_camp_Tbl OUT NOCOPY /* file.sql.39 change */ AST_rs_camp_PUB.rs_camp_Tbl_Type,
235 x_returned_rec_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
236 x_next_rec_ptr OUT NOCOPY /* file.sql.39 change */ NUMBER,
237 x_tot_rec_count OUT NOCOPY /* file.sql.39 change */ NUMBER
238 -- other optional parameters
239 -- x_tot_rec_amount OUT NOCOPY /* file.sql.39 change */ NUMBER
240 );
241
242 -- Start of Comments
243 --
244 -- Item level validation procedures
245 --
246 -- p_validation_mode is a constant defined in package
247 -- For create: G_CREATE, for update: G_UPDATE
248 -- Note: 1. This is automated generated item level validation procedure.
249 -- The actual validation detail is needed to be added.
250 --
251 -- End of Comments
252
253 PROCEDURE Validate_RS_CAMPAIGN_ID (
254 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
255 P_Validation_mode IN VARCHAR2,
256 P_RS_CAMPAIGN_ID IN NUMBER,
257 -- 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.
258
259 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
260 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
261 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
262 );
263
264 -- Start of Comments
265 --
266 -- Item level validation procedures
267 --
268 -- p_validation_mode is a constant defined in package
269 -- For create: G_CREATE, for update: G_UPDATE
270 -- Note: 1. This is automated generated item level validation procedure.
271 -- The actual validation detail is needed to be added.
272 --
273 -- End of Comments
274
275 PROCEDURE Validate_RESOURCE_ID (
276 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
277 P_Validation_mode IN VARCHAR2,
278 P_RESOURCE_ID IN NUMBER,
279 -- 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.
280
281 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
282 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
283 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
284 );
285
286 -- Start of Comments
287 --
288 -- Item level validation procedures
289 --
290 -- p_validation_mode is a constant defined in package
291 -- For create: G_CREATE, for update: G_UPDATE
292 -- Note: 1. This is automated generated item level validation procedure.
293 -- The actual validation detail is needed to be added.
294 --
295 -- End of Comments
296
297 PROCEDURE Validate_CAMPAIGN_ID (
298 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
299 P_Validation_mode IN VARCHAR2,
300 P_CAMPAIGN_ID IN NUMBER,
301 -- 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.
302
303 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
304 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
305 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
306 );
307
308 -- Start of Comments
309 --
310 -- Item level validation procedures
311 --
312 -- p_validation_mode is a constant defined in package
313 -- For create: G_CREATE, for update: G_UPDATE
314 -- Note: 1. This is automated generated item level validation procedure.
315 -- The actual validation detail is needed to be added.
316 --
317 -- End of Comments
318
319 PROCEDURE Validate_START_DATE (
320 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
321 P_Validation_mode IN VARCHAR2,
322 P_START_DATE IN DATE,
323 -- 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.
324
325 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
326 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
327 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
328 );
329
330 -- Start of Comments
331 --
332 -- Item level validation procedures
333 --
334 -- p_validation_mode is a constant defined in package
335 -- For create: G_CREATE, for update: G_UPDATE
336 -- Note: 1. This is automated generated item level validation procedure.
337 -- The actual validation detail is needed to be added.
338 --
339 -- End of Comments
340
341 PROCEDURE Validate_END_DATE (
342 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
343 P_Validation_mode IN VARCHAR2,
344 P_END_DATE IN DATE,
345 -- 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.
346
347 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
348 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
349 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
350 );
351
352 -- Start of Comments
353 --
354 -- Item level validation procedures
355 --
356 -- p_validation_mode is a constant defined in package
357 -- For create: G_CREATE, for update: G_UPDATE
358 -- Note: 1. This is automated generated item level validation procedure.
359 -- The actual validation detail is needed to be added.
360 --
361 -- End of Comments
362
363 PROCEDURE Validate_STATUS (
364 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
365 P_Validation_mode IN VARCHAR2,
366 P_STATUS IN VARCHAR2,
367 -- 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.
368
369 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
370 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
371 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
372 );
373
374 -- Start of Comments
375 --
376 -- Item level validation procedures
377 --
378 -- p_validation_mode is a constant defined in package
379 -- For create: G_CREATE, for update: G_UPDATE
380 -- Note: 1. This is automated generated item level validation procedure.
381 -- The actual validation detail is needed to be added.
382 --
383 -- End of Comments
384
385 PROCEDURE Validate_ENABLED_FLAG (
386 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
387 P_Validation_mode IN VARCHAR2,
388 P_ENABLED_FLAG IN VARCHAR2,
389 -- 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.
390
391 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
392 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
393 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
394 );
395
396 -- Start of Comments
397 --
398 -- Record level validation procedures
399 --
400 -- p_validation_mode is a constant defined in package
401 -- For create: G_CREATE, for update: G_UPDATE
402 -- Note: 1. This is automated generated item level validation procedure.
403 -- The actual validation detail is needed to be added.
404 -- 2. Developer can manually added inter-field level validation.
405 -- End of Comments
406
407 PROCEDURE Validate_rs_camp_rec(
408 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
409 P_Validation_mode IN VARCHAR2,
410 P_rs_camp_Rec IN rs_camp_Rec_Type,
411 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
412 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
413 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
414 );
415
416 -- Start of Comments
417 --
418 -- validation procedures
419 --
420 -- p_validation_mode is a constant defined in package
421 -- For create: G_CREATE, for update: G_UPDATE
422 -- Note: 1. This is automated generated item level validation procedure.
423 -- The actual validation detail is needed to be added.
424 -- 2. We can also validate table instead of record. There will be an option for user to choose.
425
426 -- End of Comments
427
428 PROCEDURE Validate_rs_camp(
429 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
430 P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
431 P_Validation_mode IN VARCHAR2,
432 P_rs_camp_Rec IN rs_camp_Rec_Type,
433 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
434 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
435 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
436 );
437 End AST_rs_camp_PVT;