1 PACKAGE AS_OPP_HEADER_PVT AUTHID CURRENT_USER as
2 /* $Header: asxvldhs.pls 115.21 2003/09/03 08:56:55 nkamble ship $ */
3 -- Start of Comments
4 -- Package name : AS_OPP_HEADER_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
14 -- *******************************************************
15 -- Start of Comments
16 -- *******************************************************
17 -- API Name: Create_opp_header
18 -- Type : Private
19 -- Pre-Req :
20 -- Parameters:
21 -- IN:
22 -- p_api_version_number IN NUMBER Required
23 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
24 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
25 -- p_validation_level IN NUMBER Optional Default =
26 -- FND_API.G_VALID_LEVEL_FULL
27 -- P_Header_Rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type Required
28 --
29 -- OUT:
30 -- x_return_status OUT VARCHAR2
31 -- x_msg_count OUT NUMBER
32 -- x_msg_data OUT VARCHAR2
33 -- Version : Current version 2.0
34 --
35 -- End of Comments
36
37 PROCEDURE Create_opp_header(
38 P_Api_Version_Number IN NUMBER,
39 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
40 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
41 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
42 P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
43 P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
44 P_Admin_Group_Id IN NUMBER,
45 P_Identity_Salesforce_Id IN NUMBER := NULL,
46 P_salesgroup_id IN NUMBER := NULL,
47 P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
48 P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
49 P_Header_Rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type
50 := AS_OPPORTUNITY_PUB.G_MISS_Header_REC,
51 X_LEAD_ID OUT NOCOPY NUMBER,
52 X_Return_Status OUT NOCOPY VARCHAR2,
53 X_Msg_Count OUT NOCOPY NUMBER,
54 X_Msg_Data OUT NOCOPY VARCHAR2
55 );
56
57
58 -- *******************************************************
59 -- Start of Comments
60 -- *******************************************************
61 -- API Name: Update_opp_header
62 -- Type : Private
63 -- Pre-Req :
64 -- Parameters:
65 -- IN
66 -- p_api_version_number IN NUMBER Required
67 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
68 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
69 -- p_validation_level IN NUMBER Optional Default =
70 -- FND_API.G_VALID_LEVEL_FULL
71 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
72 -- P_Header_Rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type
73 -- Required
74 --
75 -- OUT:
76 -- x_return_status OUT VARCHAR2
77 -- x_msg_count OUT NUMBER
78 -- x_msg_data OUT VARCHAR2
79 -- Version : Current version 2.0
80 --
81 -- End of Comments
82
83 PROCEDURE Update_opp_header(
84 P_Api_Version_Number IN NUMBER,
85 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
86 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
87 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
88 P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
89 P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
90 P_Admin_Group_Id IN NUMBER,
91 P_Identity_Salesforce_Id IN NUMBER := NULL,
92 P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
93 P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
94 P_Header_Rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type,
95 X_Return_Status OUT NOCOPY VARCHAR2,
96 X_Msg_Count OUT NOCOPY NUMBER,
97 X_Msg_Data OUT NOCOPY VARCHAR2
98 );
99
100
101 -- *******************************************************
102 -- Start of Comments
103 -- *******************************************************
104 -- API Name: Delete_opp_header
105 -- Type : Private
106 -- Pre-Req :
107 -- Parameters:
108 -- IN
109 -- p_api_version_number IN NUMBER Required
110 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
111 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
112 -- p_validation_level IN NUMBER Optional Default =
113 -- FND_API.G_VALID_LEVEL_FULL
114 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
115 -- P_lead_id IN NUMBER Required
116 --
117 -- OUT:
118 -- x_return_status OUT VARCHAR2
119 -- x_msg_count OUT NUMBER
120 -- x_msg_data OUT VARCHAR2
121 -- Version : Current version 2.0
122 --
123 -- End of Comments
124
125 PROCEDURE Delete_opp_header(
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_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
131 P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
132 P_Admin_Group_Id IN NUMBER,
133 P_Identity_Salesforce_Id IN NUMBER := NULL,
134 P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
135 P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
136 P_lead_id IN NUMBER,
137 X_Return_Status OUT NOCOPY VARCHAR2,
138 X_Msg_Count OUT NOCOPY NUMBER,
139 X_Msg_Data OUT NOCOPY VARCHAR2
140 );
141
142
143
144 -- Start of Comments
145 --
146 -- Item level validation procedures
147 --
148 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
149 -- For create: G_CREATE, for update: G_UPDATE
150 -- Note: 1. This is automated generated item level validation procedure.
151 -- The actual validation detail is needed to be added.
152 --
153 -- End of Comments
154
155 PROCEDURE Validate_LEAD_ID (
156 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
157 P_Validation_mode IN VARCHAR2,
158 P_LEAD_ID IN NUMBER,
159 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
160 X_Return_Status OUT NOCOPY VARCHAR2,
161 X_Msg_Count OUT NOCOPY NUMBER,
162 X_Msg_Data OUT NOCOPY VARCHAR2
163 );
164
165
166 /*
167 -- Start of Comments
168 --
169 -- Item level validation procedures
170 --
171 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
172 -- For create: G_CREATE, for update: G_UPDATE
173 -- Note: 1. This is automated generated item level validation procedure.
174 -- The actual validation detail is needed to be added.
175 --
176 -- End of Comments
177
178 PROCEDURE Validate_LEAD_NUMBER (
179 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
180 P_Validation_mode IN VARCHAR2,
181 P_LEAD_NUMBER IN VARCHAR2,
182 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
183 X_Return_Status OUT NOCOPY VARCHAR2,
184 X_Msg_Count OUT NOCOPY NUMBER,
185 X_Msg_Data OUT NOCOPY VARCHAR2
186 );
187 */
188
189 -- Start of Comments
190 --
191 -- Item level validation procedures
192 --
193 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
194 -- For create: G_CREATE, for update: G_UPDATE
195 -- Note: 1. This is automated generated item level validation procedure.
196 -- The actual validation detail is needed to be added.
197 --
198 -- End of Comments
199
200 PROCEDURE Validate_STATUS (
201 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
202 P_Validation_mode IN VARCHAR2,
203 P_STATUS IN VARCHAR2,
204 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
205 X_Return_Status OUT NOCOPY VARCHAR2,
206 X_Msg_Count OUT NOCOPY NUMBER,
207 X_Msg_Data OUT NOCOPY VARCHAR2
208 );
209
210 -- Start of Comments
211 --
212 -- Item level validation procedures
213 --
214 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
215 -- For create: G_CREATE, for update: G_UPDATE
216 -- Note: 1. This is automated generated item level validation procedure.
217 -- The actual validation detail is needed to be added.
218 --
219 -- End of Comments
220
221 PROCEDURE Validate_SALES_STAGE_ID (
222 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
223 P_Validation_mode IN VARCHAR2,
224 P_SALES_STAGE_ID IN NUMBER,
225 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
226 X_Return_Status OUT NOCOPY VARCHAR2,
227 X_Msg_Count OUT NOCOPY NUMBER,
228 X_Msg_Data OUT NOCOPY VARCHAR2
229 );
230
231 -- Start of Comments
232 --
233 -- Item level validation procedures
234 --
235 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
236 -- For create: G_CREATE, for update: G_UPDATE
237 -- Note: 1. This is automated generated item level validation procedure.
238 -- The actual validation detail is needed to be added.
239 --
240 -- End of Comments
241
242 PROCEDURE Validate_CHANNEL_CODE (
243 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
244 P_Validation_mode IN VARCHAR2,
245 P_CHANNEL_CODE IN VARCHAR2,
246 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
247 X_Return_Status OUT NOCOPY VARCHAR2,
248 X_Msg_Count OUT NOCOPY NUMBER,
249 X_Msg_Data OUT NOCOPY VARCHAR2
250 );
251
252 -- Start of Comments
253 --
254 -- Item level validation procedures
255 --
256 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
257 -- For create: G_CREATE, for update: G_UPDATE
258 -- Note: 1. This is automated generated item level validation procedure.
259 -- The actual validation detail is needed to be added.
260 --
261 -- End of Comments
262
263 PROCEDURE Validate_CURRENCY_CODE (
264 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
265 P_Validation_mode IN VARCHAR2,
266 P_CURRENCY_CODE IN VARCHAR2,
267 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
268 X_Return_Status OUT NOCOPY VARCHAR2,
269 X_Msg_Count OUT NOCOPY NUMBER,
270 X_Msg_Data OUT NOCOPY VARCHAR2
271 );
272
273 -- Start of Comments
274 --
275 -- Item level validation procedures
276 --
277 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
278 -- For create: G_CREATE, for update: G_UPDATE
279 -- Note: 1. This is automated generated item level validation procedure.
280 -- The actual validation detail is needed to be added.
281 --
282 -- End of Comments
283
284 PROCEDURE Validate_WIN_PROBABILITY (
285 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
286 P_Validation_mode IN VARCHAR2,
287 P_WIN_PROBABILITY IN NUMBER,
288 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
289 X_Return_Status OUT NOCOPY VARCHAR2,
290 X_Msg_Count OUT NOCOPY NUMBER,
291 X_Msg_Data OUT NOCOPY VARCHAR2
292 );
293
294 -- Start of Comments
295 --
296 -- Item level validation procedures
297 --
298 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
299 -- For create: G_CREATE, for update: G_UPDATE
300 -- Note: 1. This is automated generated item level validation procedure.
301 -- The actual validation detail is needed to be added.
302 --
303 -- End of Comments
304
305 PROCEDURE Validate_CLOSE_REASON (
306 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
307 P_Validation_mode IN VARCHAR2,
308 P_CLOSE_REASON IN VARCHAR2,
309 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
310 X_Return_Status OUT NOCOPY VARCHAR2,
311 X_Msg_Count OUT NOCOPY NUMBER,
312 X_Msg_Data OUT NOCOPY VARCHAR2
313 );
314
315 -- Start of Comments
316 --
317 -- Item level validation procedures
318 --
319 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
320 -- For create: G_CREATE, for update: G_UPDATE
321 -- Note: 1. This is automated generated item level validation procedure.
322 -- The actual validation detail is needed to be added.
323 --
324 -- End of Comments
325
326 PROCEDURE Validate_SOURCE_PROMOTION_ID (
327 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
328 P_Validation_mode IN VARCHAR2,
329 P_SOURCE_PROMOTION_ID IN NUMBER,
330 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
331 X_Return_Status OUT NOCOPY VARCHAR2,
332 X_Msg_Count OUT NOCOPY NUMBER,
333 X_Msg_Data OUT NOCOPY VARCHAR2
334 );
335
336 -- Start of Comments
337 --
338 -- Item level validation procedures
339 --
340 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
341 -- For create: G_CREATE, for update: G_UPDATE
342 -- Note: 1. This is automated generated item level validation procedure.
343 -- The actual validation detail is needed to be added.
344 --
345 -- End of Comments
346
347 PROCEDURE Validate_NO_OPP_ALLOWED_FLAG (
348 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
349 P_Validation_mode IN VARCHAR2,
350 P_NO_OPP_ALLOWED_FLAG IN VARCHAR2,
351 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
352 X_Return_Status OUT NOCOPY VARCHAR2,
353 X_Msg_Count OUT NOCOPY NUMBER,
354 X_Msg_Data OUT NOCOPY VARCHAR2
355 );
356
357 -- Start of Comments
358 --
359 -- Item level validation procedures
360 --
361 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
362 -- For create: G_CREATE, for update: G_UPDATE
363 -- Note: 1. This is automated generated item level validation procedure.
364 -- The actual validation detail is needed to be added.
365 --
366 -- End of Comments
367
368 PROCEDURE Validate_DELETE_ALLOWED_FLAG (
369 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
370 P_Validation_mode IN VARCHAR2,
371 P_DELETE_ALLOWED_FLAG IN VARCHAR2,
372 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
373 X_Return_Status OUT NOCOPY VARCHAR2,
377
374 X_Msg_Count OUT NOCOPY NUMBER,
375 X_Msg_Data OUT NOCOPY VARCHAR2
376 );
378 -- Start of Comments
379 --
380 -- Item level validation procedures
381 --
382 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
383 -- For create: G_CREATE, for update: G_UPDATE
384 -- Note: 1. This is automated generated item level validation procedure.
385 -- The actual validation detail is needed to be added.
386 --
387 -- End of Comments
388
389 PROCEDURE Validate_LEAD_SOURCE_CODE (
390 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
391 P_Validation_mode IN VARCHAR2,
392 P_LEAD_SOURCE_CODE IN VARCHAR2,
393 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
394 X_Return_Status OUT NOCOPY VARCHAR2,
395 X_Msg_Count OUT NOCOPY NUMBER,
396 X_Msg_Data OUT NOCOPY VARCHAR2
397 );
398
399 -- Start of Comments
400 --
401 -- Item level validation procedures
402 --
403 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
404 -- For create: G_CREATE, for update: G_UPDATE
405 -- Note: 1. This is automated generated item level validation procedure.
406 -- The actual validation detail is needed to be added.
407 --
408 -- End of Comments
409
410 PROCEDURE Validate_PRICE_LIST_ID (
411 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
412 P_Validation_mode IN VARCHAR2,
413 P_PRICE_LIST_ID IN NUMBER,
414 P_CURRENCY_CODE IN VARCHAR2,
415 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
416 X_Return_Status OUT NOCOPY VARCHAR2,
417 X_Msg_Count OUT NOCOPY NUMBER,
418 X_Msg_Data OUT NOCOPY VARCHAR2
419 );
420
421 -- Start of Comments
422 --
423 -- Item level validation procedures
424 --
425 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
426 -- For create: G_CREATE, for update: G_UPDATE
427 -- Note: 1. This is automated generated item level validation procedure.
428 -- The actual validation detail is needed to be added.
429 --
430 -- End of Comments
431
432 PROCEDURE Validate_DELETED_FLAG (
433 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
434 P_Validation_mode IN VARCHAR2,
435 P_DELETED_FLAG IN VARCHAR2,
436 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
437 X_Return_Status OUT NOCOPY VARCHAR2,
438 X_Msg_Count OUT NOCOPY NUMBER,
439 X_Msg_Data OUT NOCOPY VARCHAR2
440 );
441
442 -- Start of Comments
443 --
444 -- Item level validation procedures
445 --
446 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
447 -- For create: G_CREATE, for update: G_UPDATE
448 -- Note: 1. This is automated generated item level validation procedure.
449 -- The actual validation detail is needed to be added.
450 --
451 -- End of Comments
452
453 PROCEDURE Validate_METHODOLOGY_CODE (
454 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
455 P_Validation_mode IN VARCHAR2,
456 P_METHODOLOGY_CODE IN VARCHAR2,
457 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
458 X_Return_Status OUT NOCOPY VARCHAR2,
459 X_Msg_Count OUT NOCOPY NUMBER,
460 X_Msg_Data OUT NOCOPY VARCHAR2
461 );
462
463 -- Start of Comments
464 --
465 -- Item level validation procedures
466 --
467 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
468 -- For create: G_CREATE, for update: G_UPDATE
469 -- Note: 1. This is automated generated item level validation procedure.
470 -- The actual validation detail is needed to be added.
471 --
472 -- End of Comments
473
474 PROCEDURE Validate_ORIGINAL_LEAD_ID (
475 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
476 P_Validation_mode IN VARCHAR2,
477 P_ORIGINAL_LEAD_ID IN NUMBER,
478 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
479 X_Return_Status OUT NOCOPY VARCHAR2,
480 X_Msg_Count OUT NOCOPY NUMBER,
481 X_Msg_Data OUT NOCOPY VARCHAR2
482 );
483
484 -- Start of Comments
485 --
486 -- Item level validation procedures
487 --
488 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
489 -- For create: G_CREATE, for update: G_UPDATE
490 -- Note: 1. This is automated generated item level validation procedure.
491 -- The actual validation detail is needed to be added.
492 --
493 -- End of Comments
494
495 PROCEDURE Validate_DECN_TIMEFRAME_CODE (
496 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
497 P_Validation_mode IN VARCHAR2,
498 P_DECISION_TIMEFRAME_CODE IN VARCHAR2,
499 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
500 X_Return_Status OUT NOCOPY VARCHAR2,
501 X_Msg_Count OUT NOCOPY NUMBER,
505 -- Start of Comments
502 X_Msg_Data OUT NOCOPY VARCHAR2
503 );
504
506 --
507 -- Item level validation procedures
508 --
509 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
510 -- For create: G_CREATE, for update: G_UPDATE
511 -- Note: 1. This is automated generated item level validation procedure.
512 -- The actual validation detail is needed to be added.
513 --
514 -- End of Comments
515
516 PROCEDURE Validate_OFFER_ID (
517 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
518 P_Validation_mode IN VARCHAR2,
519 P_SOURCE_PROMOTION_ID IN NUMBER,
520 P_OFFER_ID IN NUMBER,
521 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
522 X_Return_Status OUT NOCOPY VARCHAR2,
523 X_Msg_Count OUT NOCOPY NUMBER,
524 X_Msg_Data OUT NOCOPY VARCHAR2
525 );
526
527 -- Start of Comments
528 --
529 -- Item level validation procedures
530 --
531 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
532 -- For create: G_CREATE, for update: G_UPDATE
533 -- Note: 1. This is automated generated item level validation procedure.
534 -- The actual validation detail is needed to be added.
535 --
536 -- End of Comments
537
538 PROCEDURE Validate_VEHICLE_RESPONSE_CODE (
539 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
540 P_Validation_mode IN VARCHAR2,
541 P_VEHICLE_RESPONSE_CODE IN VARCHAR2,
542 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
543 X_Return_Status OUT NOCOPY VARCHAR2,
544 X_Msg_Count OUT NOCOPY NUMBER,
545 X_Msg_Data OUT NOCOPY VARCHAR2
546 );
547
548 -- Start of Comments
549 --
550 -- Item level validation procedures
551 --
552 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
553 -- For create: G_CREATE, for update: G_UPDATE
554 -- Note: 1. This is automated generated item level validation procedure.
555 -- The actual validation detail is needed to be added.
556 --
557 -- End of Comments
558
559 PROCEDURE Validate_BUDGET_STATUS_CODE (
560 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
561 P_Validation_mode IN VARCHAR2,
562 P_BUDGET_STATUS_CODE IN VARCHAR2,
563 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
564 X_Return_Status OUT NOCOPY VARCHAR2,
565 X_Msg_Count OUT NOCOPY NUMBER,
566 X_Msg_Data OUT NOCOPY VARCHAR2
567 );
568
569 -- Start of Comments
570 --
571 -- Item level validation procedures
572 --
573 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
574 -- For create: G_CREATE, for update: G_UPDATE
575 -- Note: 1. This is automated generated item level validation procedure.
576 -- The actual validation detail is needed to be added.
577 --
578 -- End of Comments
579
580 PROCEDURE Validate_PRM_LEAD_TYPE (
581 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
582 P_Validation_mode IN VARCHAR2,
583 P_PRM_LEAD_TYPE IN VARCHAR2,
584 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
585 X_Return_Status OUT NOCOPY VARCHAR2,
586 X_Msg_Count OUT NOCOPY NUMBER,
587 X_Msg_Data OUT NOCOPY VARCHAR2
588 );
589
590 -- Start of Comments
591 --
592 -- Item level validation procedures
593 --
594 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
595 -- For create: G_CREATE, for update: G_UPDATE
596 -- Note: 1. This is automated generated item level validation procedure.
597 -- The actual validation detail is needed to be added.
598 --
599 -- End of Comments
600
601 PROCEDURE Validate_CUSTOMER_ID (
602 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
603 P_Validation_mode IN VARCHAR2,
604 P_CUSTOMER_ID IN NUMBER,
605 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
606 X_Return_Status OUT NOCOPY VARCHAR2,
607 X_Msg_Count OUT NOCOPY NUMBER,
608 X_Msg_Data OUT NOCOPY VARCHAR2
609 );
610
611 -- Start of Comments
612 --
613 -- Item level validation procedures
614 --
615 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
616 -- For create: G_CREATE, for update: G_UPDATE
617 -- Note: 1. This is automated generated item level validation procedure.
618 -- The actual validation detail is needed to be added.
619 --
620 -- End of Comments
621
622 PROCEDURE Validate_INC_PARTNER_PARTY_ID (
623 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
624 P_Validation_mode IN VARCHAR2,
625 P_INC_PARTNER_PARTY_ID IN NUMBER,
626 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
627 X_Return_Status OUT NOCOPY VARCHAR2,
628 X_Msg_Count OUT NOCOPY NUMBER,
629 X_Msg_Data OUT NOCOPY VARCHAR2
630 );
631
635 --
632 -- Start of Comments
633 --
634 -- Item level validation procedures
636 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
637 -- For create: G_CREATE, for update: G_UPDATE
638 -- Note: 1. This is automated generated item level validation procedure.
639 -- The actual validation detail is needed to be added.
640 --
641 -- End of Comments
642
643 PROCEDURE Validate_CLOSE_COMPETITOR_ID (
644 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
645 P_Validation_mode IN VARCHAR2,
646 P_CLOSE_COMPETITOR_ID IN NUMBER,
647 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
648 X_Return_Status OUT NOCOPY VARCHAR2,
649 X_Msg_Count OUT NOCOPY NUMBER,
650 X_Msg_Data OUT NOCOPY VARCHAR2
651 );
652
653 -- Start of Comments
654 --
655 -- Item level validation procedures
656 --
657 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
658 -- For create: G_CREATE, for update: G_UPDATE
659 -- Note: 1. This is automated generated item level validation procedure.
660 -- The actual validation detail is needed to be added.
661 --
662 -- End of Comments
663
664 PROCEDURE Validate_END_USER_CUSTOMER_ID (
665 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
666 P_Validation_mode IN VARCHAR2,
667 P_END_USER_CUSTOMER_ID IN NUMBER,
668 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
669 X_Return_Status OUT NOCOPY VARCHAR2,
670 X_Msg_Count OUT NOCOPY NUMBER,
671 X_Msg_Data OUT NOCOPY VARCHAR2
672 );
673
674 -- Start of Comments
675 --
676 -- Item level validation procedures
677 --
678 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
679 -- For create: G_CREATE, for update: G_UPDATE
680 -- Note: 1. This is automated generated item level validation procedure.
681 -- The actual validation detail is needed to be added.
682 --
683 -- End of Comments
684
685 PROCEDURE Validate_OPP_OWNER (
686 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
687 P_Validation_mode IN VARCHAR2,
688 P_OWNER_SALESFORCE_ID IN NUMBER,
689 P_OWNER_SALES_GROUP_ID IN NUMBER,
690 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
691 X_Return_Status OUT NOCOPY VARCHAR2,
692 X_Msg_Count OUT NOCOPY NUMBER,
693 X_Msg_Data OUT NOCOPY VARCHAR2
694 );
695
696 -- Start of Comments
697 --
698 -- Item level validation procedures
699 --
700 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
701 -- For create: G_CREATE, for update: G_UPDATE
702 -- Note: 1. This is automated generated item level validation procedure.
703 -- The actual validation detail is needed to be added.
704 --
705 -- End of Comments
706
707 PROCEDURE Validate_ADDRESS_ID (
708 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
709 P_Validation_mode IN VARCHAR2,
710 P_ADDRESS_ID IN NUMBER,
711 P_CUSTOMER_ID IN NUMBER,
712 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
713 X_Return_Status OUT NOCOPY VARCHAR2,
714 X_Msg_Count OUT NOCOPY NUMBER,
715 X_Msg_Data OUT NOCOPY VARCHAR2
716 );
717
718 -- Start of Comments
719 --
720 -- Item level validation procedures
721 --
722 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
723 -- For create: G_CREATE, for update: G_UPDATE
724 -- Note: 1. This is automated generated item level validation procedure.
725 -- The actual validation detail is needed to be added.
726 --
727 -- End of Comments
728
729 PROCEDURE Validate_END_USER_ADDRESS_ID (
730 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
731 P_Validation_mode IN VARCHAR2,
732 P_END_USER_ADDRESS_ID IN NUMBER,
733 P_END_USER_CUSTOMER_ID IN NUMBER,
734 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
735 X_Return_Status OUT NOCOPY VARCHAR2,
736 X_Msg_Count OUT NOCOPY NUMBER,
737 X_Msg_Data OUT NOCOPY VARCHAR2
738 );
739
740 -- Start of Comments
741 --
742 -- Item level validation procedures
743 --
744 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
745 -- For create: G_CREATE, for update: G_UPDATE
746 -- Note: 1. This is automated generated item level validation procedure.
747 -- The actual validation detail is needed to be added.
748 --
749 -- End of Comments
750
751 PROCEDURE Validate_AUTO_ASGN_TYPE (
752 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
753 P_Validation_mode IN VARCHAR2,
754 P_AUTO_ASSIGNMENT_TYPE IN VARCHAR2,
755 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
756 X_Return_Status OUT NOCOPY VARCHAR2,
757 X_Msg_Count OUT NOCOPY NUMBER,
758 X_Msg_Data OUT NOCOPY VARCHAR2
759 );
760
764 --
761 -- Start of Comments
762 --
763 -- Item level validation procedures
765 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
766 -- For create: G_CREATE, for update: G_UPDATE
767 -- Note: 1. This is automated generated item level validation procedure.
768 -- The actual validation detail is needed to be added.
769 --
770 -- End of Comments
771
772 PROCEDURE Validate_PRM_ASGN_TYPE (
773 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
774 P_Validation_mode IN VARCHAR2,
775 P_PRM_ASSIGNMENT_TYPE IN VARCHAR2,
776 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
777 X_Return_Status OUT NOCOPY VARCHAR2,
778 X_Msg_Count OUT NOCOPY NUMBER,
779 X_Msg_Data OUT NOCOPY VARCHAR2
780 );
781
782 -- Start of Comments
783 --
784 -- Item level validation procedures
785 --
786 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
787 -- For create: G_CREATE, for update: G_UPDATE
788 -- Note: 1. This is automated generated item level validation procedure.
789 -- The actual validation detail is needed to be added.
790 --
791 -- End of Comments
792
793
794 PROCEDURE Validate_INC_PRTNR_RESOURCE_ID (
795 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
796 P_Validation_mode IN VARCHAR2,
797 P_INC_PARTNER_RESOURCE_ID IN NUMBER,
798 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
799 X_Return_Status OUT NOCOPY VARCHAR2,
800 X_Msg_Count OUT NOCOPY NUMBER,
801 X_Msg_Data OUT NOCOPY VARCHAR2
802 );
803
804
805 -- Start of Comments
806 --
807 -- Item level validation procedures
808 --
809 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
810 -- For create: G_CREATE, for update: G_UPDATE
811 -- Note: 1. This is automated generated item level validation procedure.
812 -- The actual validation detail is needed to be added.
813 --
814 -- End of Comments
815
816 PROCEDURE Validate_PRM_IND_CLS_CODE (
817 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
818 P_Validation_mode IN VARCHAR2,
819 P_PRM_IND_CLASSIFICATION_CODE IN VARCHAR2,
820 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
821 X_Return_Status OUT NOCOPY VARCHAR2,
822 X_Msg_Count OUT NOCOPY NUMBER,
823 X_Msg_Data OUT NOCOPY VARCHAR2
824 );
825
826 -- Start of Comments
827 --
828 -- Item level validation procedures
829 --
830 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
831 -- For create: G_CREATE, for update: G_UPDATE
832 -- Note: 1. This is automated generated item level validation procedure.
833 -- The actual validation detail is needed to be added.
834 --
835 -- End of Comments
836
837 PROCEDURE Validate_PRM_EXEC_SPONSOR_FLAG (
838 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
839 P_Validation_mode IN VARCHAR2,
840 P_PRM_EXEC_SPONSOR_FLAG IN VARCHAR2,
841 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
842 X_Return_Status OUT NOCOPY VARCHAR2,
843 X_Msg_Count OUT NOCOPY NUMBER,
844 X_Msg_Data OUT NOCOPY VARCHAR2
845 );
846
847 -- Start of Comments
848 --
849 -- Item level validation procedures
850 --
851 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
852 -- For create: G_CREATE, for update: G_UPDATE
853 -- Note: 1. This is automated generated item level validation procedure.
854 -- The actual validation detail is needed to be added.
855 --
856 -- End of Comments
857
858 PROCEDURE Validate_PRM_PRJ_LDINPLE_FLAG (
859 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
860 P_Validation_mode IN VARCHAR2,
861 P_PRM_PRJ_LEAD_IN_PLACE_FLAG IN VARCHAR2,
862 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
863 X_Return_Status OUT NOCOPY VARCHAR2,
864 X_Msg_Count OUT NOCOPY NUMBER,
865 X_Msg_Data OUT NOCOPY VARCHAR2
866 );
867
868 -- Start of Comments
869 --
870 -- Item level validation procedures
871 --
872 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
873 -- For create: G_CREATE, for update: G_UPDATE
874 --
875 -- 091200 ffang, for bug , description is a mandatory column
876 -- End of Comments
877 PROCEDURE Validate_Description (
878 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
879 P_Validation_mode IN VARCHAR2,
880 P_Description IN VARCHAR2,
881 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
882 X_Return_Status OUT NOCOPY VARCHAR2,
883 X_Msg_Count OUT NOCOPY NUMBER,
884 X_Msg_Data OUT NOCOPY VARCHAR2 );
885
886
887
888 -- Start of Comments
889 --
890 -- Record level validation procedure
891 --
895 -- End of Comments
892 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
893 -- For create: G_CREATE, for update: G_UPDATE
894 --
896
897 PROCEDURE Validate_WinPorb_StageID (
898 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
899 P_Validation_mode IN VARCHAR2,
900 P_SALES_METHODOLOGY_ID IN NUMBER,
901 P_SALES_STAGE_ID IN NUMBER,
902 P_WIN_PROBABILITY IN NUMBER,
903 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
904 X_Return_Status OUT NOCOPY VARCHAR2,
905 X_Msg_Count OUT NOCOPY NUMBER,
906 X_Msg_Data OUT NOCOPY VARCHAR2
907 );
908
909 -- Start of Comments
910 --
911 -- Record level validation procedure
912 --
913 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
914 -- For create: G_CREATE, for update: G_UPDATE
915 --
916 -- End of Comments
917
918 PROCEDURE Validate_Status_CloseReason (
919 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
920 P_Validation_mode IN VARCHAR2,
921 P_STATUS IN VARCHAR2,
922 P_CLOSE_REASON IN VARCHAR2,
923 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
924 X_Return_Status OUT NOCOPY VARCHAR2,
925 X_Msg_Count OUT NOCOPY NUMBER,
926 X_Msg_Data OUT NOCOPY VARCHAR2
927 );
928
929 /*
930 -- Start of Comments
931 --
932 -- Record level validation procedure
933 --
934 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
935 -- For create: G_CREATE, for update: G_UPDATE
936 --
937 -- End of Comments
938
939 PROCEDURE Validate_Status_DecisionDate (
940 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
941 P_Validation_mode IN VARCHAR2,
942 P_STATUS IN VARCHAR2,
943 P_DECISION_DATE IN DATE,
944 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
945 X_Return_Status OUT NOCOPY VARCHAR2,
946 X_Msg_Count OUT NOCOPY NUMBER,
947 X_Msg_Data OUT NOCOPY VARCHAR2
948 );
949 */
950
951
952 -- Start of Comments
953 --
954 -- Record level validation procedure
955 --
956 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
957 -- For create: G_CREATE, for update: G_UPDATE
958 --
959 -- End of Comments
960
961 PROCEDURE Validate_DecisionDate (
962 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
963 P_Validation_mode IN VARCHAR2,
964 P_DECISION_DATE IN DATE,
965 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
966 X_Return_Status OUT NOCOPY VARCHAR2,
967 X_Msg_Count OUT NOCOPY NUMBER,
968 X_Msg_Data OUT NOCOPY VARCHAR2
969 );
970
971
972
973 -- Start of Comments
974 --
975 -- Record level validation procedure
976 --
977 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
978 -- For create: G_CREATE, for update: G_UPDATE
979 --
980 -- End of Comments
981
982 PROCEDURE Validate_BudgetAmt_Currency (
983 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
984 P_Validation_mode IN VARCHAR2,
985 P_TOTAL_AMOUNT IN NUMBER,
986 P_CURRENCY_CODE IN VARCHAR2,
987 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
988 X_Return_Status OUT NOCOPY VARCHAR2,
989 X_Msg_Count OUT NOCOPY NUMBER,
990 X_Msg_Data OUT NOCOPY VARCHAR2
991 );
992
993 -- Start of Comments
994 --
995 -- validation procedures
996 --
997 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
998 -- For create: G_CREATE, for update: G_UPDATE
999 -- Note: 1. This is automated generated item level validation procedure.
1000 -- The actual validation detail is needed to be added.
1001 -- 2. We can also validate table instead of record. There will be an option for user to choose.
1002 -- End of Comments
1003
1004 PROCEDURE Validate_opp_header(
1005 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1006 P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1007 P_Validation_mode IN VARCHAR2,
1008 P_Header_Rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type,
1009 X_Return_Status OUT NOCOPY VARCHAR2,
1010 X_Msg_Count OUT NOCOPY NUMBER,
1011 X_Msg_Data OUT NOCOPY VARCHAR2
1012 );
1013
1014
1015
1016 End AS_OPP_HEADER_PVT;