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_Tbl IN AS_OPPORTUNITY_PUB.Competitor_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_Tbl IN AS_OPPORTUNITY_PUB.Competitor_Tbl_Type
30: -- Required
31: --
32: -- OUT:
39: -- End of Comments
40: --
41: PROCEDURE Create_competitors(
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_competitors(
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_Tbl IN AS_OPPORTUNITY_PUB.Competitor_Tbl_Type :=
41: PROCEDURE Create_competitors(
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_Tbl IN AS_OPPORTUNITY_PUB.Competitor_Tbl_Type :=
49: AS_OPPORTUNITY_PUB.G_MISS_Competitor_Tbl,
47: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
48: P_Competitor_Tbl IN AS_OPPORTUNITY_PUB.Competitor_Tbl_Type :=
49: AS_OPPORTUNITY_PUB.G_MISS_Competitor_Tbl,
50: X_competitor_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.competitor_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_Tbl IN AS_OPPORTUNITY_PUB.Competitor_Tbl_Type :=
49: AS_OPPORTUNITY_PUB.G_MISS_Competitor_Tbl,
50: X_competitor_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.competitor_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_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.competitor_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_Tbl IN AS_OPPORTUNITY_PUB.Competitor_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_Tbl IN AS_OPPORTUNITY_PUB.Competitor_Tbl_Type
77: -- Required
78: --
86: -- End of Comments
87: --
88: PROCEDURE Update_competitors(
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_competitors(
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_competitors(
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_Tbl IN AS_OPPORTUNITY_PUB.Competitor_Tbl_Type,
100: X_competitor_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.competitor_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_Tbl IN AS_OPPORTUNITY_PUB.Competitor_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_Tbl IN AS_OPPORTUNITY_PUB.Competitor_Tbl_Type
123: -- Required
124: --
132: -- End of Comments
133: --
134: PROCEDURE Delete_competitors(
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_competitors(
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_competitors(
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_Tbl IN AS_OPPORTUNITY_PUB.Competitor_Tbl_Type,
146: X_competitor_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.competitor_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_LEAD_COMPETITOR_ID (
164: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
165: P_Validation_mode IN VARCHAR2,
166: P_LEAD_COMPETITOR_ID IN NUMBER,
167: X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
168: X_Return_Status OUT NOCOPY VARCHAR2,
181: --
182: -- End of Comments
183:
184: PROCEDURE Validate_LEAD_ID (
185: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
186: P_Validation_mode IN VARCHAR2,
187: P_LEAD_ID IN NUMBER,
188: X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
189: X_Return_Status OUT NOCOPY VARCHAR2,
203: -- End of Comments
204:
205: /*
206: PROCEDURE Validate_COMPETITOR (
207: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
208: P_Validation_mode IN VARCHAR2,
209: P_COMPETITOR IN VARCHAR2,
210: X_Item_Property_Rec OUT AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
211: X_Return_Status OUT VARCHAR2,
225: --
226: -- End of Comments
227:
228: PROCEDURE Validate_COMPETITOR_ID (
229: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
230: P_Validation_mode IN VARCHAR2,
231: P_COMPETITOR_ID IN NUMBER,
232: X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
233: X_Return_Status OUT NOCOPY VARCHAR2,
246: -- 2. Developer can manually added inter-field level validation.
247: -- End of Comments
248:
249: PROCEDURE Validate_Competitor_rec(
250: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
251: P_Validation_mode IN VARCHAR2,
252: P_Competitor_Rec IN AS_OPPORTUNITY_PUB.Competitor_Rec_Type,
253: X_Return_Status OUT NOCOPY VARCHAR2,
254: X_Msg_Count OUT NOCOPY NUMBER,
267: -- option for user to choose.
268: -- End of Comments
269:
270: PROCEDURE Validate_competitor(
271: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
272: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
273: P_Validation_mode IN VARCHAR2,
274: P_Competitor_Rec IN AS_OPPORTUNITY_PUB.Competitor_Rec_Type,
275: X_Return_Status OUT NOCOPY VARCHAR2,
268: -- End of Comments
269:
270: PROCEDURE Validate_competitor(
271: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
272: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
273: P_Validation_mode IN VARCHAR2,
274: P_Competitor_Rec IN AS_OPPORTUNITY_PUB.Competitor_Rec_Type,
275: X_Return_Status OUT NOCOPY VARCHAR2,
276: X_Msg_Count OUT NOCOPY NUMBER,