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
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: --
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
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,
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,
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,
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,
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,
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,
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
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
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: --
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,
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,
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,
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,
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,
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
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
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
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:
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,
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,
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,
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,
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,
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
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
894: --
895: -- End of Comments
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,
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,
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,
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,
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,
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,
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,