20: -- Parameters:
21: -- IN
22: -- p_api_version_number IN NUMBER Required
23: -- p_init_msg_list IN VARCHAR2 Optional
24: -- Default = FND_API_G_FALSE
25: -- p_commit IN VARCHAR2 Optional
26: -- Default = FND_API.G_FALSE
27: -- p_validation_level IN NUMBER Optional
28: -- Default = FND_API.G_VALID_LEVEL_FULL
22: -- p_api_version_number IN NUMBER Required
23: -- p_init_msg_list IN VARCHAR2 Optional
24: -- Default = FND_API_G_FALSE
25: -- p_commit IN VARCHAR2 Optional
26: -- Default = FND_API.G_FALSE
27: -- p_validation_level IN NUMBER Optional
28: -- Default = FND_API.G_VALID_LEVEL_FULL
29: -- P_competitor_prod_Tbl IN As_Opportunity_Pub.Competitor_Prod_Tbl_Type
30: -- Required
24: -- Default = FND_API_G_FALSE
25: -- p_commit IN VARCHAR2 Optional
26: -- Default = FND_API.G_FALSE
27: -- p_validation_level IN NUMBER Optional
28: -- Default = FND_API.G_VALID_LEVEL_FULL
29: -- P_competitor_prod_Tbl IN As_Opportunity_Pub.Competitor_Prod_Tbl_Type
30: -- Required
31: --
32: -- OUT:
39: -- End of Comments
40: --
41: PROCEDURE Create_competitor_prods(
42: P_Api_Version_Number IN NUMBER,
43: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
44: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
45: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
46: P_Admin_Group_Id IN NUMBER,
47: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
40: --
41: PROCEDURE Create_competitor_prods(
42: P_Api_Version_Number IN NUMBER,
43: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
44: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
45: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
46: P_Admin_Group_Id IN NUMBER,
47: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
48: P_competitor_prod_Tbl IN As_Opportunity_Pub.Competitor_Prod_Tbl_Type :=
41: PROCEDURE Create_competitor_prods(
42: P_Api_Version_Number IN NUMBER,
43: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
44: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
45: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
46: P_Admin_Group_Id IN NUMBER,
47: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
48: P_competitor_prod_Tbl IN As_Opportunity_Pub.Competitor_Prod_Tbl_Type :=
49: AS_OPPORTUNITY_PUB.G_MISS_competitor_prod_Tbl,
47: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
48: P_competitor_prod_Tbl IN As_Opportunity_Pub.Competitor_Prod_Tbl_Type :=
49: AS_OPPORTUNITY_PUB.G_MISS_competitor_prod_Tbl,
50: X_competitor_prod_out_tbl OUT NOCOPY as_opportunity_pub.competitor_prod_out_tbl_type,
51: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
52: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
53: P_Identity_Salesforce_Id IN NUMBER := NULL,
54: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
55: X_Return_Status OUT NOCOPY VARCHAR2,
48: P_competitor_prod_Tbl IN As_Opportunity_Pub.Competitor_Prod_Tbl_Type :=
49: AS_OPPORTUNITY_PUB.G_MISS_competitor_prod_Tbl,
50: X_competitor_prod_out_tbl OUT NOCOPY as_opportunity_pub.competitor_prod_out_tbl_type,
51: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
52: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
53: P_Identity_Salesforce_Id IN NUMBER := NULL,
54: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
55: X_Return_Status OUT NOCOPY VARCHAR2,
56: X_Msg_Count OUT NOCOPY NUMBER,
50: X_competitor_prod_out_tbl OUT NOCOPY as_opportunity_pub.competitor_prod_out_tbl_type,
51: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
52: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
53: P_Identity_Salesforce_Id IN NUMBER := NULL,
54: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
55: X_Return_Status OUT NOCOPY VARCHAR2,
56: X_Msg_Count OUT NOCOPY NUMBER,
57: X_Msg_Data OUT NOCOPY VARCHAR2
58: );
66: -- Parameters:
67: -- IN
68: -- p_api_version_number IN NUMBER Required
69: -- p_init_msg_list IN VARCHAR2 Optional
70: -- Default = FND_API_G_FALSE
71: -- p_commit IN VARCHAR2 Optional
72: -- Default = FND_API.G_FALSE
73: -- p_validation_level IN NUMBER Optional
74: -- Default = FND_API.G_VALID_LEVEL_FULL
68: -- p_api_version_number IN NUMBER Required
69: -- p_init_msg_list IN VARCHAR2 Optional
70: -- Default = FND_API_G_FALSE
71: -- p_commit IN VARCHAR2 Optional
72: -- Default = FND_API.G_FALSE
73: -- p_validation_level IN NUMBER Optional
74: -- Default = FND_API.G_VALID_LEVEL_FULL
75: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
76: -- P_competitor_prod_Tbl IN As_Opportunity_Pub.Competitor_Prod_Tbl_Type
70: -- Default = FND_API_G_FALSE
71: -- p_commit IN VARCHAR2 Optional
72: -- Default = FND_API.G_FALSE
73: -- p_validation_level IN NUMBER Optional
74: -- Default = FND_API.G_VALID_LEVEL_FULL
75: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
76: -- P_competitor_prod_Tbl IN As_Opportunity_Pub.Competitor_Prod_Tbl_Type
77: -- Required
78: --
86: -- End of Comments
87: --
88: PROCEDURE Update_competitor_prods(
89: P_Api_Version_Number IN NUMBER,
90: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
91: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
92: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
93: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
94: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
87: --
88: PROCEDURE Update_competitor_prods(
89: P_Api_Version_Number IN NUMBER,
90: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
91: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
92: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
93: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
94: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
95: P_Admin_Group_Id IN NUMBER,
88: PROCEDURE Update_competitor_prods(
89: P_Api_Version_Number IN NUMBER,
90: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
91: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
92: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
93: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
94: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
95: P_Admin_Group_Id IN NUMBER,
96: P_Identity_Salesforce_Id IN NUMBER,
89: P_Api_Version_Number IN NUMBER,
90: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
91: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
92: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
93: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
94: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
95: P_Admin_Group_Id IN NUMBER,
96: P_Identity_Salesforce_Id IN NUMBER,
97: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
90: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
91: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
92: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
93: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
94: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
95: P_Admin_Group_Id IN NUMBER,
96: P_Identity_Salesforce_Id IN NUMBER,
97: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
98: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
94: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
95: P_Admin_Group_Id IN NUMBER,
96: P_Identity_Salesforce_Id IN NUMBER,
97: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
98: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
99: P_competitor_prod_Tbl IN As_Opportunity_Pub.Competitor_Prod_Tbl_Type,
100: X_competitor_prod_out_tbl OUT NOCOPY as_opportunity_pub.competitor_prod_out_tbl_type,
101: X_Return_Status OUT NOCOPY VARCHAR2,
102: X_Msg_Count OUT NOCOPY NUMBER,
112: -- Parameters:
113: -- IN
114: -- p_api_version_number IN NUMBER Required
115: -- p_init_msg_list IN VARCHAR2 Optional
116: -- Default = FND_API_G_FALSE
117: -- p_commit IN VARCHAR2 Optional
118: -- Default = FND_API.G_FALSE
119: -- p_validation_level IN NUMBER Optional
120: -- Default = FND_API.G_VALID_LEVEL_FULL
114: -- p_api_version_number IN NUMBER Required
115: -- p_init_msg_list IN VARCHAR2 Optional
116: -- Default = FND_API_G_FALSE
117: -- p_commit IN VARCHAR2 Optional
118: -- Default = FND_API.G_FALSE
119: -- p_validation_level IN NUMBER Optional
120: -- Default = FND_API.G_VALID_LEVEL_FULL
121: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
122: -- P_competitor_prod_Tbl IN As_Opportunity_Pub.Competitor_Prod_Tbl_Type
116: -- Default = FND_API_G_FALSE
117: -- p_commit IN VARCHAR2 Optional
118: -- Default = FND_API.G_FALSE
119: -- p_validation_level IN NUMBER Optional
120: -- Default = FND_API.G_VALID_LEVEL_FULL
121: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
122: -- P_competitor_prod_Tbl IN As_Opportunity_Pub.Competitor_Prod_Tbl_Type
123: -- Required
124: --
132: -- End of Comments
133: --
134: PROCEDURE Delete_competitor_prods(
135: P_Api_Version_Number IN NUMBER,
136: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
137: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
138: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
139: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
140: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
133: --
134: PROCEDURE Delete_competitor_prods(
135: P_Api_Version_Number IN NUMBER,
136: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
137: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
138: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
139: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
140: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
141: P_Admin_Group_Id IN NUMBER,
134: PROCEDURE Delete_competitor_prods(
135: P_Api_Version_Number IN NUMBER,
136: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
137: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
138: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
139: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
140: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
141: P_Admin_Group_Id IN NUMBER,
142: P_identity_salesforce_id IN NUMBER := NULL,
135: P_Api_Version_Number IN NUMBER,
136: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
137: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
138: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
139: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
140: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
141: P_Admin_Group_Id IN NUMBER,
142: P_identity_salesforce_id IN NUMBER := NULL,
143: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
136: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
137: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
138: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
139: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
140: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
141: P_Admin_Group_Id IN NUMBER,
142: P_identity_salesforce_id IN NUMBER := NULL,
143: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
144: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
140: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
141: P_Admin_Group_Id IN NUMBER,
142: P_identity_salesforce_id IN NUMBER := NULL,
143: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
144: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
145: P_competitor_prod_Tbl IN As_Opportunity_Pub.Competitor_Prod_Tbl_Type,
146: X_competitor_prod_out_tbl OUT NOCOPY as_opportunity_pub.competitor_prod_out_tbl_type,
147: X_Return_Status OUT NOCOPY VARCHAR2,
148: X_Msg_Count OUT NOCOPY NUMBER,
160: --
161: -- End of Comments
162:
163: PROCEDURE Validate_REQUEST_ID (
164: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
165: P_Validation_mode IN VARCHAR2,
166: P_REQUEST_ID IN NUMBER,
167: X_Return_Status OUT NOCOPY VARCHAR2,
168: X_Msg_Count OUT NOCOPY NUMBER,
180: --
181: -- End of Comments
182:
183: PROCEDURE Validate_WIN_LOSS_STATUS (
184: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
185: P_Validation_mode IN VARCHAR2,
186: P_WIN_LOSS_STATUS IN VARCHAR2,
187: X_Return_Status OUT NOCOPY VARCHAR2,
188: X_Msg_Count OUT NOCOPY NUMBER,
190: );
191:
192:
193: PROCEDURE Validate_COMPETITOR_PRODUCT_ID (
194: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
195: P_Validation_mode IN VARCHAR2,
196: P_COMPETITOR_PRODUCT_ID IN NUMBER,
197: X_Return_Status OUT NOCOPY VARCHAR2,
198: X_Msg_Count OUT NOCOPY NUMBER,
210: --
211: -- End of Comments
212:
213: PROCEDURE Validate_LEAD_LINE_ID (
214: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
215: P_Validation_mode IN VARCHAR2,
216: P_LEAD_LINE_ID IN NUMBER,
217: X_Return_Status OUT NOCOPY VARCHAR2,
218: X_Msg_Count OUT NOCOPY NUMBER,
230: --
231: -- End of Comments
232:
233: PROCEDURE Validate_LEAD_ID (
234: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
235: P_Validation_mode IN VARCHAR2,
236: P_LEAD_ID IN NUMBER,
237: X_Return_Status OUT NOCOPY VARCHAR2,
238: X_Msg_Count OUT NOCOPY NUMBER,
250: --
251: -- End of Comments
252:
253: PROCEDURE Validate_L_COMPETITOR_PROD_ID (
254: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
255: P_Validation_mode IN VARCHAR2,
256: P_LEAD_COMPETITOR_PROD_ID IN NUMBER,
257: X_Return_Status OUT NOCOPY VARCHAR2,
258: X_Msg_Count OUT NOCOPY NUMBER,
270: -- 2. Developer can manually added inter-field level validation.
271: -- End of Comments
272:
273: PROCEDURE Validate_Competitor_Prod_rec(
274: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
275: P_Validation_mode IN VARCHAR2,
276: P_Competitor_Prod_Rec IN As_Opportunity_Pub.Competitor_Prod_Rec_Type,
277: X_Return_Status OUT NOCOPY VARCHAR2,
278: X_Msg_Count OUT NOCOPY NUMBER,
290: -- 2. We can also validate table instead of record. There will be an option for user to choose.
291: -- End of Comments
292:
293: PROCEDURE Validate_competitor_prod(
294: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
295: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
296: P_Validation_mode IN VARCHAR2,
297: P_Competitor_Prod_Rec IN As_Opportunity_Pub.Competitor_Prod_Rec_Type,
298: X_Return_Status OUT NOCOPY VARCHAR2,
291: -- End of Comments
292:
293: PROCEDURE Validate_competitor_prod(
294: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
295: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
296: P_Validation_mode IN VARCHAR2,
297: P_Competitor_Prod_Rec IN As_Opportunity_Pub.Competitor_Prod_Rec_Type,
298: X_Return_Status OUT NOCOPY VARCHAR2,
299: X_Msg_Count OUT NOCOPY NUMBER,