1 PACKAGE AS_OPP_CONTACT_PVT AUTHID CURRENT_USER as
2 /* $Header: asxvlcns.pls 120.1 2006/08/10 11:18:32 mohali noship $ */
3 -- Start of Comments
4 -- Package name : AS_OPP_CONTACT_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 -- Start of Comments
15 -- *******************************************************
16 -- API Name: Create_opp_contacts
17 -- Type : Private
18 -- Pre-Req :
19 -- Parameters:
20 -- IN
21 -- p_api_version_number IN NUMBER Required
22 -- p_init_msg_list IN VARCHAR2 Optional
23 -- Default = FND_API_G_FALSE
24 -- p_commit IN VARCHAR2 Optional
25 -- Default = FND_API.G_FALSE
26 -- p_validation_level IN NUMBER Optional
27 -- Default = FND_API.G_VALID_LEVEL_FULL
28 -- P_Contact_Tbl IN AS_OPPORTUNITY_PUB.Contact_Tbl_Type Required
29 --
30 -- OUT NOCOPY:
31 -- X_contact_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.contact_out_tbl_type,
32 -- x_return_status OUT NOCOPY VARCHAR2
33 -- x_msg_count OUT NOCOPY NUMBER
34 -- x_msg_data OUT NOCOPY VARCHAR2
35 -- Version : Current version 2.0
36 --
37 -- End of Comments
38 --
39 PROCEDURE Create_opp_contacts(
40 P_Api_Version_Number IN NUMBER,
41 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
42 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
43 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
44 P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
45 P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
46 P_Admin_Group_Id IN NUMBER,
47 P_Identity_Salesforce_Id IN VARCHAR2 := FND_API.G_FALSE,
48 P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
49 P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
50 P_Contact_Tbl IN AS_OPPORTUNITY_PUB.Contact_Tbl_Type :=
51 AS_OPPORTUNITY_PUB.G_MISS_Contact_Tbl,
52 X_contact_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.contact_out_tbl_type,
53 X_Return_Status OUT NOCOPY VARCHAR2,
54 X_Msg_Count OUT NOCOPY NUMBER,
55 X_Msg_Data OUT NOCOPY VARCHAR2
56 );
57
58 -- *******************************************************
59 -- Start of Comments
60 -- *******************************************************
61 -- API Name: Update_opp_contacts
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
68 -- Default = FND_API_G_FALSE
69 -- p_commit IN VARCHAR2 Optional
70 -- Default = FND_API.G_FALSE
71 -- p_validation_level IN NUMBER Optional Default =
72 -- FND_API.G_VALID_LEVEL_FULL
73 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
74 -- P_Contact_Tbl IN AS_OPPORTUNITY_PUB.Contact_Tbl_Type Required
75 --
76 -- OUT:
77 -- X_contact_out_tbl OUT AS_OPPORTUNITY_PUB.contact_out_tbl_type,
78 -- x_return_status OUT VARCHAR2
79 -- x_msg_count OUT NUMBER
80 -- x_msg_data OUT VARCHAR2
81 -- Version : Current version 2.0
82 --
83 -- End of Comments
84 --
85 PROCEDURE Update_opp_contacts(
86 P_Api_Version_Number IN NUMBER,
87 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
88 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
89 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
90 P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
91 P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
92 P_Admin_Group_Id IN NUMBER,
93 P_Identity_Salesforce_Id IN NUMBER,
94 P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
95 P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
96 P_Contact_Tbl IN AS_OPPORTUNITY_PUB.Contact_Tbl_Type,
97 X_contact_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.contact_out_tbl_type,
98 X_Return_Status OUT NOCOPY VARCHAR2,
99 X_Msg_Count OUT NOCOPY NUMBER,
100 X_Msg_Data OUT NOCOPY VARCHAR2
101 );
102
103 -- *******************************************************
104 -- Start of Comments
105 -- *******************************************************
106 -- API Name: Delete_opp_contacts
107 -- Type : Private
108 -- Pre-Req :
109 -- Parameters:
110 -- IN
111 -- p_api_version_number IN NUMBER Required
112 -- p_init_msg_list IN VARCHAR2 Optional
113 -- Default = FND_API_G_FALSE
114 -- p_commit IN VARCHAR2 Optional
115 -- Default = FND_API.G_FALSE
116 -- p_validation_level IN NUMBER Optional
117 -- Default = FND_API.G_VALID_LEVEL_FULL
118 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
119 -- P_Contact_Tbl IN AS_OPPORTUNITY_PUB.Contact_Tbl_Type Required
120 --
121 -- OUT:
122 -- X_contact_out_tbl OUT AS_OPPORTUNITY_PUB.contact_out_tbl_type,
123 -- x_return_status OUT VARCHAR2
124 -- x_msg_count OUT NUMBER
125 -- x_msg_data OUT VARCHAR2
126 -- Version : Current version 2.0
127 --
128 -- End of Comments
129 --
130 PROCEDURE Delete_opp_contacts(
131 P_Api_Version_Number IN NUMBER,
132 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
133 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
134 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
135 P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
136 P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
137 P_Admin_Group_Id IN NUMBER,
138 P_identity_salesforce_id IN NUMBER := NULL,
139 P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
140 P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
141 P_Contact_Tbl IN AS_OPPORTUNITY_PUB.Contact_Tbl_Type,
142 X_contact_out_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.contact_out_tbl_type,
143 X_Return_Status OUT NOCOPY VARCHAR2,
144 X_Msg_Count OUT NOCOPY NUMBER,
145 X_Msg_Data OUT NOCOPY VARCHAR2
146 );
147
148
149 -- Start of Comments
150 --
151 -- Item level validation procedures
152 --
153 -- p_validation_mode is a constant defined in AS_UTILITY_PUB package
154 -- For create: G_CREATE, for update: G_UPDATE
155 -- Note: 1. This is automated generated item level validation procedure.
156 -- The actual validation detail is needed to be added.
157 --
158 -- End of Comments
159
160 PROCEDURE Validate_LEAD_CONTACT_ID (
161 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
162 P_Validation_mode IN VARCHAR2,
163 P_LEAD_CONTACT_ID IN NUMBER,
164 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
165 X_Return_Status OUT NOCOPY VARCHAR2,
166 X_Msg_Count OUT NOCOPY NUMBER,
167 X_Msg_Data OUT NOCOPY VARCHAR2
168 );
169
170 -- Start of Comments
171 --
172 -- Item level validation procedures
173 --
174 -- p_validation_mode is a constant defined in AS_UTILITY_PUB package
175 -- For create: G_CREATE, for update: G_UPDATE
176 -- Note: 1. This is automated generated item level validation procedure.
177 -- The actual validation detail is needed to be added.
178 --
179 -- End of Comments
180
181 PROCEDURE Validate_LEAD_ID (
182 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
183 P_Validation_mode IN VARCHAR2,
184 P_LEAD_ID IN NUMBER,
185 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
186 X_Return_Status OUT NOCOPY VARCHAR2,
187 X_Msg_Count OUT NOCOPY NUMBER,
188 X_Msg_Data OUT NOCOPY VARCHAR2
189 );
190
191 -- Start of Comments
192 --
193 -- Item level validation procedures
194 --
195 -- p_validation_mode is a constant defined in AS_UTILITY_PUB package
196 -- For create: G_CREATE, for update: G_UPDATE
197 -- Note: 1. This is automated generated item level validation procedure.
198 -- The actual validation detail is needed to be added.
199 --
200 -- End of Comments
201
202 PROCEDURE Validate_CONTACT_ID (
203 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
204 P_Validation_mode IN VARCHAR2,
205 P_CUSTOMER_ID IN NUMBER,
206 P_CONTACT_ID IN NUMBER,
207 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
208 X_Return_Status OUT NOCOPY VARCHAR2,
209 X_Msg_Count OUT NOCOPY NUMBER,
210 X_Msg_Data OUT NOCOPY VARCHAR2
211 );
212
213 -- Start of Comments
214 --
215 -- Item level validation procedures
216 --
217 -- p_validation_mode is a constant defined in AS_UTILITY_PUB package
218 -- For create: G_CREATE, for update: G_UPDATE
219 -- Note: 1. This is automated generated item level validation procedure.
220 -- The actual validation detail is needed to be added.
221 --
222 -- End of Comments
223
224 PROCEDURE Validate_ENABLED_FLAG (
225 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
226 P_Validation_mode IN VARCHAR2,
227 P_ENABLED_FLAG IN VARCHAR2,
228 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
229 X_Return_Status OUT NOCOPY VARCHAR2,
230 X_Msg_Count OUT NOCOPY NUMBER,
231 X_Msg_Data OUT NOCOPY VARCHAR2
232 );
233
234 -- Start of Comments
235 --
236 -- Item level validation procedures
237 --
238 -- p_validation_mode is a constant defined in AS_UTILITY_PUB package
239 -- For create: G_CREATE, for update: G_UPDATE
240 -- Note: 1. This is automated generated item level validation procedure.
241 -- The actual validation detail is needed to be added.
242 --
243 -- End of Comments
244
245 PROCEDURE Validate_CUSTOMER_ID (
246 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
247 P_Validation_mode IN VARCHAR2,
248 P_CUSTOMER_ID IN NUMBER,
249 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
250 X_Return_Status OUT NOCOPY VARCHAR2,
251 X_Msg_Count OUT NOCOPY NUMBER,
252 X_Msg_Data OUT NOCOPY VARCHAR2
253 );
254
255 -- Start of Comments
256 --
257 -- Item level validation procedures
258 --
259 -- p_validation_mode is a constant defined in AS_UTILITY_PUB package
260 -- For create: G_CREATE, for update: G_UPDATE
261 -- Note: 1. This is automated generated item level validation procedure.
262 -- The actual validation detail is needed to be added.
263 --
264 -- End of Comments
265
266 PROCEDURE Validate_ADDRESS_ID (
267 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
268 P_Validation_mode IN VARCHAR2,
269 P_CUSTOMER_ID IN NUMBER,
270 P_ADDRESS_ID IN NUMBER,
271 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
272 X_Return_Status OUT NOCOPY VARCHAR2,
273 X_Msg_Count OUT NOCOPY NUMBER,
274 X_Msg_Data OUT NOCOPY VARCHAR2
275 );
276
277
278 -- Start of Comments
279 --
280 -- Item level validation procedures
281 --
282 -- p_validation_mode is a constant defined in AS_UTILITY_PUB package
283 -- For create: G_CREATE, for update: G_UPDATE
284 -- Note: 1. This is automated generated item level validation procedure.
285 -- The actual validation detail is needed to be added.
286 --
287 -- End of Comments
288
289 PROCEDURE Validate_RANK (
290 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
291 P_Validation_mode IN VARCHAR2,
292 P_RANK IN VARCHAR2,
293 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
294 X_Return_Status OUT NOCOPY VARCHAR2,
295 X_Msg_Count OUT NOCOPY NUMBER,
296 X_Msg_Data OUT NOCOPY VARCHAR2
297 );
298
299 -- Start of Comments
300 --
301 -- Item level validation procedures
302 --
303 -- p_validation_mode is a constant defined in AS_UTILITY_PUB package
304 -- For create: G_CREATE, for update: G_UPDATE
305 -- Note: 1. This is automated generated item level validation procedure.
306 -- The actual validation detail is needed to be added.
307 --
308 -- End of Comments
309
310 PROCEDURE Validate_PHONE_ID (
311 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
312 P_Validation_mode IN VARCHAR2,
313 P_CONTACT_ID IN NUMBER,
314 P_CONTACT_PARTY_ID IN NUMBER,
315 P_PHONE_ID IN NUMBER,
316 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
317 X_Return_Status OUT NOCOPY VARCHAR2,
318 X_Msg_Count OUT NOCOPY NUMBER,
319 X_Msg_Data OUT NOCOPY VARCHAR2
320 );
321
322
323 -- Start of Comments
324 --
325 -- Item level validation procedures
326 --
327 -- p_validation_mode is a constant defined in AS_UTILITY_PUB package
328 -- For create: G_CREATE, for update: G_UPDATE
329 -- Note: 1. This is automated generated item level validation procedure.
330 -- The actual validation detail is needed to be added.
331 --
332 -- End of Comments
333
334 PROCEDURE Validate_PRIMARY_CONTACT_FLAG (
335 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
336 P_Validation_mode IN VARCHAR2,
337 P_PRIMARY_CONTACT_FLAG IN VARCHAR2,
338 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
339 X_Return_Status OUT NOCOPY VARCHAR2,
340 X_Msg_Count OUT NOCOPY NUMBER,
341 X_Msg_Data OUT NOCOPY VARCHAR2
342 );
343
344
345 -- Start of Comments
346 --
347 -- Item level validation procedures
348 --
349 -- p_validation_mode is a constant defined in AS_UTILITY_PUB package
350 -- For create: G_CREATE, for update: G_UPDATE
351 -- Note: 1. This is automated generated item level validation procedure.
352 -- The actual validation detail is needed to be added.
353 --
354 -- End of Comments
355
356 PROCEDURE Validate_CONTACT_PARTY_ID (
357 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
358 P_Validation_mode IN VARCHAR2,
359 P_CUSTOMER_ID IN NUMBER,
360 p_LEAD_ID IN NUMBER, --change for 5285071
361 P_CONTACT_PARTY_ID IN NUMBER,
362 X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
363 X_Return_Status OUT NOCOPY VARCHAR2,
364 X_Msg_Count OUT NOCOPY NUMBER,
365 X_Msg_Data OUT NOCOPY VARCHAR2
366 );
367
368 -- Start of Comments
369 --
370 -- Record level validation procedures
371 --
372 -- p_validation_mode is a constant defined in AS_UTILITY_PUB package
373 -- For create: G_CREATE, for update: G_UPDATE
374 -- Note: 1. This is automated generated item level validation procedure.
375 -- The actual validation detail is needed to be added.
376 -- 2. Developer can manually added inter-field level validation.
377 -- End of Comments
378
379 PROCEDURE Validate_Contact_rec(
380 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
381 P_Validation_mode IN VARCHAR2,
382 P_Contact_Rec IN AS_OPPORTUNITY_PUB.Contact_Rec_Type,
383 X_Return_Status OUT NOCOPY VARCHAR2,
384 X_Msg_Count OUT NOCOPY NUMBER,
385 X_Msg_Data OUT NOCOPY VARCHAR2
386 );
387
388 -- Start of Comments
389 --
390 -- validation procedures
391 --
392 -- p_validation_mode is a constant defined in AS_UTILITY_PUB package
393 -- For create: G_CREATE, for update: G_UPDATE
394 -- Note: 1. This is automated generated item level validation procedure.
395 -- The actual validation detail is needed to be added.
396 -- 2. We can also validate table instead of record. There will be an option for user to choose.
397 -- End of Comments
398
399 PROCEDURE Validate_opp_contact(
400 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
401 P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
402 P_Validation_mode IN VARCHAR2,
403 P_Contact_Rec IN AS_OPPORTUNITY_PUB.Contact_Rec_Type,
404 X_Return_Status OUT NOCOPY VARCHAR2,
405 X_Msg_Count OUT NOCOPY NUMBER,
406 X_Msg_Data OUT NOCOPY VARCHAR2
407 );
408
409 End AS_OPP_CONTACT_PVT;