1 PACKAGE CSD_PARTIES_PVT AS
2 /* $Header: csdvptys.pls 120.1 2005/08/17 15:09:22 swai noship $ */
3
4
5 /*----------------------------------------------------------------*/
6 /* procedure name: Create_Customer */
7 /* description : procedure used to create a Depot Repair */
8 /* customer in TCA. Also creates account, */
9 /* contact points, bill-to and ship-to addresses */
10 /* */
11 /* */
12 /* p_api_version Standard IN param */
13 /* p_commit Standard IN param */
14 /* p_init_msg_list Standard IN param */
15 /* p_validation_level Standard IN param */
16 /* p_person_rec Person Information */
17 /* p_org_rec Organization Info */
18 /* Required fields for org rec are: */
19 /* Organization name */
20 /* p_party_type 'PERSON' or 'ORGANIZATION' */
21 /* p_account_rec Account Info */
22 /* p_cust_profile_rec Profile Info */
23 /* p_phone_rec Phone Info */
24 /* p_email_rec Email Info */
25 /* p_web_rec Web Info */
26 /* p_create_phone_flag 'Y' to create phone contact point */
27 /* p_create_email_flag 'Y' to create email contact point */
28 /* p_create_url_flag 'Y' to create url contact point */
29 /* p_bill_loc_rec Bill-to location */
30 /* p_bill_party_site_rec Bill-to site */
31 /* p_bill_party_site_use_rec Bill-to site use */
32 /* p_ship_loc_rec Ship-to location */
33 /* p_ship_party_site_rec Ship-to site */
34 /* p_ship_party_site_use_rec Ship-to site use */
35 /* x_party_id Party ID generated */
36 /* x_party_number Party Number gnerated */
37 /* x_cust_account_id Account ID generated */
38 /* x_cust_account_number Account Number generated */
39 /* x_phone_id Phone contact point ID */
40 /* x_email_id Email contact point ID */
41 /* x_url_id URL contact point ID */
42 /* x_bill_party_site_rec Bill-to site */
43 /* x_bill_party_site_use_rec Bill-to site use */
44 /* x_bill_location_id Bill-to location ID */
45 /* x_bill_party_site_id Bill-to site id */
46 /* x_bill_party_site_number Bill-to site number */
47 /* x_bill_party_site_use_id Bill-to site use id */
48 /* x_ship_party_site_rec Ship-to site */
49 /* x_ship_party_site_use_rec Ship-to site use */
50 /* x_ship_location_id Ship-to location ID */
51 /* x_ship_party_site_id Ship-to site id */
52 /* x_ship_party_site_number Ship-to site number */
53 /* x_ship_party_site_use_id Ship-to site use id */
54 /* x_return_status Standard OUT param */
55 /* x_msg_count Standard OUT param */
56 /* x_msg_data Standard OUT param */
57 /* */
58 /*----------------------------------------------------------------*/
59 PROCEDURE Create_Customer
60 ( p_api_version IN NUMBER,
61 p_commit IN VARCHAR2 := fnd_api.g_false,
62 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
63 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
64 p_person_rec IN HZ_PARTY_V2PUB.person_rec_type,
65 p_org_rec IN HZ_PARTY_V2PUB.organization_rec_type,
66 p_party_type IN VARCHAR2,
67 p_account_rec IN HZ_CUST_ACCOUNT_V2PUB.cust_account_rec_type,
68 p_cust_profile_rec IN HZ_CUSTOMER_PROFILE_V2PUB.customer_profile_rec_type,
69 p_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
70 p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
71 p_web_rec IN HZ_CONTACT_POINT_V2PUB.web_rec_type,
72 p_create_phone_flag IN VARCHAR2,
73 p_create_email_flag IN VARCHAR2,
74 p_create_url_flag IN VARCHAR2,
75 p_bill_loc_rec IN CSD_PROCESS_PVT.address_rec_type,
76 p_bill_location_id IN NUMBER default null,
77 p_ship_loc_rec IN CSD_PROCESS_PVT.address_rec_type,
78 p_ship_location_id IN NUMBER default null,
79 x_party_id OUT NOCOPY NUMBER,
80 x_party_number OUT NOCOPY VARCHAR2,
81 x_cust_account_id OUT NOCOPY NUMBER,
82 x_cust_account_number OUT NOCOPY VARCHAR2,
83 x_phone_id OUT NOCOPY NUMBER,
84 x_email_id OUT NOCOPY NUMBER,
85 x_url_id OUT NOCOPY NUMBER,
86 x_bill_party_site_rec IN OUT NOCOPY HZ_PARTY_SITE_V2PUB.party_site_rec_type,
87 x_bill_party_site_use_rec IN OUT NOCOPY HZ_PARTY_SITE_V2PUB.party_site_use_rec_type,
88 x_bill_location_id OUT NOCOPY NUMBER,
89 x_bill_party_site_id OUT NOCOPY NUMBER,
90 x_bill_party_site_number OUT NOCOPY NUMBER,
91 x_bill_party_site_use_id OUT NOCOPY NUMBER,
92 x_ship_party_site_rec IN OUT NOCOPY HZ_PARTY_SITE_V2PUB.party_site_rec_type,
93 x_ship_party_site_use_rec IN OUT NOCOPY HZ_PARTY_SITE_V2PUB.party_site_use_rec_type,
94 x_ship_location_id OUT NOCOPY NUMBER,
95 x_ship_party_site_id OUT NOCOPY NUMBER,
96 x_ship_party_site_number OUT NOCOPY NUMBER,
97 x_ship_party_site_use_id OUT NOCOPY NUMBER,
98 x_return_status OUT NOCOPY VARCHAR2,
99 x_msg_count OUT NOCOPY NUMBER,
100 x_msg_data OUT NOCOPY VARCHAR2 );
101
102 /*----------------------------------------------------------------*/
103 /* procedure name: Create_Contact */
104 /* description : procedure used to create a person contact */
105 /* in TCA. Also creates contact points. */
106 /* */
107 /* p_api_version Standard IN param */
108 /* p_commit Standard IN param */
109 /* p_init_msg_list Standard IN param */
110 /* p_validation_level Standard IN param */
111 /* p_person_rec Person Information */
112 /* p_phone_rec Phone Info */
113 /* p_email_rec Email Info */
114 /* p_web_rec Web Info */
115 /* p_create_phone_flag 'Y' to create phone contact point */
116 /* p_create_email_flag 'Y' to create email contact point */
117 /* p_create_url_flag 'Y' to create url contact point */
118 /* x_party_id Party ID generated */
119 /* x_party_number Party Number gnerated */
120 /* x_phone_id Phone contact point ID */
121 /* x_email_id Email contact point ID */
122 /* x_url_id URL contact point ID */
123 /* x_return_status Standard OUT param */
124 /* x_msg_count Standard OUT param */
125 /* x_msg_data Standard OUT param */
126 /* */
127 /*----------------------------------------------------------------*/
128 PROCEDURE Create_Contact
129 ( p_api_version IN NUMBER,
130 p_commit IN VARCHAR2 := fnd_api.g_false,
131 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
132 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
133 p_person_rec IN HZ_PARTY_V2PUB.person_rec_type,
134 p_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
135 p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
136 p_web_rec IN HZ_CONTACT_POINT_V2PUB.web_rec_type,
137 p_create_phone_flag IN VARCHAR2,
138 p_create_email_flag IN VARCHAR2,
139 p_create_url_flag IN VARCHAR2,
140 x_party_id OUT NOCOPY NUMBER,
141 x_party_number OUT NOCOPY VARCHAR2,
142 x_phone_id OUT NOCOPY NUMBER,
143 x_email_id OUT NOCOPY NUMBER,
144 x_url_id OUT NOCOPY NUMBER,
145 x_return_status OUT NOCOPY VARCHAR2,
146 x_msg_count OUT NOCOPY NUMBER,
147 x_msg_data OUT NOCOPY VARCHAR2 );
148
149
150 /*----------------------------------------------------------------*/
151 /* procedure name: Create_Person */
152 /* description : procedure used to create */
153 /* a person in TCA */
154 /* */
155 /* p_api_version Standard IN param */
156 /* p_commit Standard IN param */
157 /* p_init_msg_list Standard IN param */
158 /* p_validation_level Standard IN param */
159 /* p_person_rec Person Information */
160 /* x_party_id Party ID generated */
161 /* x_party_number Party Number gnerated */
162 /* x_return_status Standard OUT param */
163 /* x_msg_count Standard OUT param */
164 /* x_msg_data Standard OUT param */
165 /* */
166 /*----------------------------------------------------------------*/
167 PROCEDURE Create_Person
168 ( p_api_version IN NUMBER,
169 p_commit IN VARCHAR2 := fnd_api.g_false,
170 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
171 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
172 p_person_rec IN HZ_PARTY_V2PUB.person_rec_type,
173 x_party_id OUT NOCOPY NUMBER,
174 x_party_number OUT NOCOPY VARCHAR2,
175 x_return_status OUT NOCOPY VARCHAR2,
176 x_msg_count OUT NOCOPY NUMBER,
177 x_msg_data OUT NOCOPY VARCHAR2 );
178
179
180 /*----------------------------------------------------------------*/
181 /* procedure name: Create_Organization */
182 /* description : procedure used to create an organization */
183 /* in TCA */
184 /* */
185 /* p_api_version Standard IN param */
186 /* p_commit Standard IN param */
187 /* p_init_msg_list Standard IN param */
188 /* p_validation_level Standard IN param */
189 /* p_org_rec Organization Info */
190 /* x_party_id Party ID generated */
191 /* x_party_number Party Number gnerated */
192 /* x_return_status Standard OUT param */
193 /* x_msg_count Standard OUT param */
194 /* x_msg_data Standard OUT param */
195 /* */
196 /*----------------------------------------------------------------*/
197 PROCEDURE Create_Organization
198 ( p_api_version IN NUMBER,
199 p_commit IN VARCHAR2 := fnd_api.g_false,
200 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
201 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
202 p_org_rec IN HZ_PARTY_V2PUB.organization_rec_type,
203 x_party_id OUT NOCOPY NUMBER,
204 x_party_number OUT NOCOPY VARCHAR2,
205 x_return_status OUT NOCOPY VARCHAR2,
206 x_msg_count OUT NOCOPY NUMBER,
207 x_msg_data OUT NOCOPY VARCHAR2 );
208
209
210 /*----------------------------------------------------------------*/
211 /* procedure name: Create_Account */
212 /* description : procedure used to create */
213 /* an account for a person */
214 /* */
215 /* p_api_version Standard IN param */
216 /* p_commit Standard IN param */
217 /* p_init_msg_list Standard IN param */
218 /* p_validation_level Standard IN param */
219 /* p_account_rec Account Info */
220 /* p_person_rec Person Information */
221 /* p_cust_profile_rec Profile Info */
222 /* x_cust_account_id Account ID generated */
223 /* x_cust_account_number Account Number generated */
224 /* x_return_status Standard OUT param */
225 /* x_msg_count Standard OUT param */
226 /* x_msg_data Standard OUT param */
227 /* */
228 /*----------------------------------------------------------------*/
229 PROCEDURE Create_Account
230 ( p_api_version IN NUMBER,
231 p_commit IN VARCHAR2 := fnd_api.g_false,
232 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
233 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
234 p_account_rec IN HZ_CUST_ACCOUNT_V2PUB.cust_account_rec_type,
235 p_person_rec IN HZ_PARTY_V2PUB.person_rec_type,
236 p_cust_profile_rec IN HZ_CUSTOMER_PROFILE_V2PUB.customer_profile_rec_type,
237 x_cust_account_id OUT NOCOPY NUMBER,
238 x_cust_account_number OUT NOCOPY VARCHAR2,
239 x_return_status OUT NOCOPY VARCHAR2,
240 x_msg_count OUT NOCOPY NUMBER,
241 x_msg_data OUT NOCOPY VARCHAR2 );
242
243
244 /*----------------------------------------------------------------*/
245 /* procedure name: Create_Account */
246 /* description : procedure used to create */
247 /* an account for an organization */
248 /* */
249 /* p_api_version Standard IN param */
250 /* p_commit Standard IN param */
251 /* p_init_msg_list Standard IN param */
252 /* p_validation_level Standard IN param */
253 /* p_account_rec Account Info */
254 /* p_org_rec Organization Info */
255 /* p_cust_profile_rec Profile Info */
256 /* x_cust_account_id Account ID generated */
257 /* x_cust_account_number Account Number generated */
258 /* x_return_status Standard OUT param */
259 /* x_msg_count Standard OUT param */
260 /* x_msg_data Standard OUT param */
261 /* */
262 /*----------------------------------------------------------------*/
263 PROCEDURE Create_Account
264 ( p_api_version IN NUMBER,
265 p_commit IN VARCHAR2 := fnd_api.g_false,
266 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
267 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
268 p_account_rec IN HZ_CUST_ACCOUNT_V2PUB.cust_account_rec_type,
269 p_org_rec IN HZ_PARTY_V2PUB.organization_rec_type,
270 p_cust_profile_rec IN HZ_CUSTOMER_PROFILE_V2PUB.customer_profile_rec_type,
271 x_cust_account_id OUT NOCOPY NUMBER,
272 x_cust_account_number OUT NOCOPY VARCHAR2,
273 x_return_status OUT NOCOPY VARCHAR2,
274 x_msg_count OUT NOCOPY NUMBER,
275 x_msg_data OUT NOCOPY VARCHAR2 );
279 /* procedure name: Create_ContactPoints */
276
277
278 /*----------------------------------------------------------------*/
280 /* description : procedure used to create */
281 /* contact points for a party */
282 /* */
283 /* p_api_version Standard IN param */
284 /* p_commit Standard IN param */
285 /* p_init_msg_list Standard IN param */
286 /* p_validation_level Standard IN param */
287 /* p_phone_rec Phone Info */
288 /* p_email_rec Email Info */
289 /* p_web_rec Web Info */
290 /* p_create_phone_flag 'Y' to create phone contact point */
291 /* p_create_email_flag 'Y' to create email contact point */
292 /* p_create_url_flag 'Y' to create url contact point */
293 /* p_party_id Party ID for these contact points */
294 /* x_phone_id Phone contact point ID */
295 /* x_email_id Email contact point ID */
296 /* x_url_id URL contact point ID */
297 /* x_return_status Standard OUT param */
298 /* x_msg_count Standard OUT param */
299 /* x_msg_data Standard OUT param */
300 /* */
301 /*----------------------------------------------------------------*/
302 PROCEDURE Create_ContactPoints
303 ( p_api_version IN NUMBER,
304 p_commit IN VARCHAR2 := fnd_api.g_false,
305 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
306 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
307 p_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
308 p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
309 p_web_rec IN HZ_CONTACT_POINT_V2PUB.web_rec_type,
310 p_create_phone_flag IN VARCHAR2,
311 p_create_email_flag IN VARCHAR2,
312 p_create_url_flag IN VARCHAR2,
313 p_party_id IN NUMBER,
314 x_phone_id OUT NOCOPY NUMBER,
315 x_email_id OUT NOCOPY NUMBER,
316 x_url_id OUT NOCOPY NUMBER,
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 /* procedure name: Create_AddressRecords */
324 /* description : procedure used to create */
325 /* address records in TCA */
326 /* This includes creating a location, site, */
327 /* and site use. */
328 /* */
329 /* p_api_version Standard IN param */
330 /* p_commit Standard IN param */
331 /* p_init_msg_list Standard IN param */
332 /* p_validation_level Standard IN param */
333 /* p_loc_rec Location */
334 /* p_location_id Location ID, if it already exists */
335 /* x_party_site_rec Site */
336 /* x_party_site_use_rec Site use */
337 /* x_location_id Location ID created/used */
338 /* x_party_site_id Site id */
339 /* x_party_site_number Site number */
343 /* x_msg_data Standard OUT param */
340 /* x_party_site_use_id Site use id */
341 /* x_return_status Standard OUT param */
342 /* x_msg_count Standard OUT param */
344 /* */
345 /*----------------------------------------------------------------*/
346 PROCEDURE Create_AddressRecords
347 ( p_api_version IN NUMBER,
348 p_commit IN VARCHAR2 := fnd_api.g_false,
349 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
350 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
351 p_loc_rec IN CSD_PROCESS_PVT.address_rec_type,
352 p_location_id IN NUMBER DEFAULT NULL,
353 x_party_site_rec IN OUT NOCOPY HZ_PARTY_SITE_V2PUB.party_site_rec_type,
354 x_party_site_use_rec IN OUT NOCOPY HZ_PARTY_SITE_V2PUB.party_site_use_rec_type,
355 x_location_id OUT NOCOPY NUMBER,
356 x_party_site_id OUT NOCOPY NUMBER,
357 x_party_site_number OUT NOCOPY NUMBER,
358 x_party_site_use_id OUT NOCOPY NUMBER,
359 x_return_status OUT NOCOPY VARCHAR2,
360 x_msg_count OUT NOCOPY NUMBER,
361 x_msg_data OUT NOCOPY VARCHAR2 );
362
363
364 /*----------------------------------------------------------------*/
365 /* procedure name: Create_Address */
366 /* description : procedure used to create */
367 /* a location in TCA */
368 /* */
369 /* p_api_version Standard IN param */
370 /* p_commit Standard IN param */
371 /* p_init_msg_list Standard IN param */
372 /* p_validation_level Standard IN param */
373 /* p_address_rec Location to create */
374 /* x_location_id Location ID created */
375 /* x_return_status Standard OUT param */
376 /* x_msg_count Standard OUT param */
377 /* x_msg_data Standard OUT param */
378 /* */
379 /*----------------------------------------------------------------*/
380 PROCEDURE Create_Address
381 ( p_api_version IN NUMBER,
382 p_commit IN VARCHAR2 := fnd_api.g_false,
383 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
384 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
385 p_address_rec IN CSD_PROCESS_PVT.address_rec_type,
386 x_location_id OUT NOCOPY NUMBER,
387 x_return_status OUT NOCOPY VARCHAR2,
388 x_msg_count OUT NOCOPY NUMBER,
389 x_msg_data OUT NOCOPY VARCHAR2 );
390
391
392 /*----------------------------------------------------------------*/
393 /* procedure name: Create_Relationship */
394 /* description : procedure used to create */
395 /* a relationship between parties */
396 /* */
397 /* p_api_version Standard IN param */
398 /* p_commit Standard IN param */
399 /* p_init_msg_list Standard IN param */
400 /* p_validation_level Standard IN param */
401 /* p_party_rel_rec Party relationship to create */
402 /* x_party_rel_id Relationship ID generated */
403 /* x_return_status Standard OUT param */
404 /* x_msg_count Standard OUT param */
405 /* x_msg_data Standard OUT param */
406 /* */
407 /*----------------------------------------------------------------*/
408 PROCEDURE Create_Relationship
409 ( p_api_version IN NUMBER,
410 p_commit IN VARCHAR2 := fnd_api.g_false,
411 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
412 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
413 p_party_rel_rec IN HZ_RELATIONSHIP_V2PUB.relationship_rec_type,
414 x_party_rel_id OUT NOCOPY NUMBER,
415 x_return_status OUT NOCOPY VARCHAR2,
416 x_msg_count OUT NOCOPY NUMBER,
417 x_msg_data OUT NOCOPY VARCHAR2 );
418
419
420 /*----------------------------------------------------------------*/
421 /* procedure name: Update_Party */
422 /* description : procedure used to update */
423 /* a party in TCA */
424 /* */
425 /* p_api_version Standard IN param */
426 /* p_commit Standard IN param */
427 /* p_init_msg_list Standard IN param */
428 /* p_validation_level Standard IN param */
429 /* p_person_rec Person Information */
430 /* p_org_rec Organization Info */
431 /* p_party_type 'PERSON' or 'ORGANIZATION' */
432 /* p_obj_ver_num Last version for party */
433 /* x_obj_ver_num New Last version for party */
434 /* x_return_status Standard OUT param */
435 /* x_msg_count Standard OUT param */
436 /* x_msg_data Standard OUT param */
437 /* */
438 /*----------------------------------------------------------------*/
439 PROCEDURE Update_Party
440 ( p_api_version IN NUMBER,
441 p_commit IN VARCHAR2 := fnd_api.g_false,
442 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
443 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
444 p_person_rec IN HZ_PARTY_V2PUB.person_rec_type,
445 p_org_rec IN HZ_PARTY_V2PUB.organization_rec_type,
446 p_party_type IN VARCHAR2,
447 p_obj_ver_num IN NUMBER,
448 x_obj_ver_num OUT NOCOPY NUMBER,
449 x_return_status OUT NOCOPY VARCHAR2,
450 x_msg_count OUT NOCOPY NUMBER,
451 x_msg_data OUT NOCOPY VARCHAR2 );
452
453
454 /*----------------------------------------------------------------*/
455 /* procedure name: Update_Person */
456 /* description : procedure used to update */
457 /* a person in TCA */
458 /* */
459 /* p_api_version Standard IN param */
460 /* p_commit Standard IN param */
461 /* p_init_msg_list Standard IN param */
462 /* p_validation_level Standard IN param */
463 /* p_person_rec Person Information */
464 /* p_obj_ver_num Last version for person */
465 /* x_obj_ver_num New Last version for person */
466 /* x_return_status Standard OUT param */
467 /* x_msg_count Standard OUT param */
468 /* x_msg_data Standard OUT param */
469 /* */
470 /*----------------------------------------------------------------*/
471 PROCEDURE Update_Person
472 ( p_api_version IN NUMBER,
473 p_commit IN VARCHAR2 := fnd_api.g_false,
474 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
475 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
476 p_person_rec IN HZ_PARTY_V2PUB.person_rec_type,
477 p_obj_ver_num IN NUMBER,
478 x_obj_ver_num OUT NOCOPY NUMBER,
479 x_return_status OUT NOCOPY VARCHAR2,
480 x_msg_count OUT NOCOPY NUMBER,
481 x_msg_data OUT NOCOPY VARCHAR2 );
482
483
484 /*----------------------------------------------------------------*/
485 /* procedure name: Update_Organization */
486 /* description : procedure used to update */
487 /* an organization in TCA */
488 /* */
489 /* p_api_version Standard IN param */
490 /* p_commit Standard IN param */
491 /* p_init_msg_list Standard IN param */
492 /* p_validation_level Standard IN param */
493 /* p_org_rec Organization Info */
494 /* The following fields must be set */
495 /* and are non-updatable: */
496 /* party_rec.party_id */
497 /* party_rec.party_number */
498 /* party_rec.status */
499 /* party_rec.orig_system_reference */
500 /* p_obj_ver_num Last version num for org */
501 /* x_obj_ver_num New Last version num for org */
502 /* x_return_status Standard OUT param */
503 /* x_msg_count Standard OUT param */
504 /* x_msg_data Standard OUT param */
505 /* */
506 /*----------------------------------------------------------------*/
507 PROCEDURE Update_Organization
508 ( p_api_version IN NUMBER,
509 p_commit IN VARCHAR2 := fnd_api.g_false,
510 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
511 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
512 p_org_rec IN HZ_PARTY_V2PUB.organization_rec_type,
513 p_obj_ver_num IN NUMBER,
514 x_obj_ver_num OUT NOCOPY NUMBER,
515 x_return_status OUT NOCOPY VARCHAR2,
516 x_msg_count OUT NOCOPY NUMBER,
517 x_msg_data OUT NOCOPY VARCHAR2 );
518
519 /*----------------------------------------------------------------*/
520 /* procedure name: Update_Account */
521 /* description : procedure used to update */
522 /* an account for a party */
523 /* */
524 /* p_api_version Standard IN param */
525 /* p_commit Standard IN param */
526 /* p_init_msg_list Standard IN param */
527 /* p_validation_level Standard IN param */
528 /* p_cust_acct_rec Account Info */
529 /* p_obj_ver_num Last version num for account */
530 /* x_obj_ver_num New Last version num for account */
531 /* x_return_status Standard OUT param */
532 /* x_msg_count Standard OUT param */
533 /* x_msg_data Standard OUT param */
534 /* */
535 /*----------------------------------------------------------------*/
536 PROCEDURE Update_Account
537 ( p_api_version IN NUMBER,
538 p_commit IN VARCHAR2 := fnd_api.g_false,
539 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
540 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
541 p_cust_acct_rec IN HZ_CUST_ACCOUNT_V2PUB.cust_account_rec_type,
542 p_obj_ver_num IN NUMBER,
543 x_obj_ver_num OUT NOCOPY NUMBER,
544 x_return_status OUT NOCOPY VARCHAR2,
545 x_msg_count OUT NOCOPY NUMBER,
546 x_msg_data OUT NOCOPY VARCHAR2 );
547
548 /*----------------------------------------------------------------*/
549 /* procedure name: Update_ContactPoints */
550 /* description : procedure used to update */
551 /* contact points for a party */
552 /* */
553 /* p_api_version Standard IN param */
554 /* p_commit Standard IN param */
555 /* p_init_msg_list Standard IN param */
556 /* p_validation_level Standard IN param */
557 /* p_phone_rec Phone Info */
558 /* p_email_rec Email Info */
559 /* p_web_rec Web Info */
560 /* p_phone_cnt_point_id ID of phone contact point */
561 /* p_email_cnt_point_id ID of email contact point */
562 /* p_url_cnt_point_id ID of url contact point */
563 /* p_phone_obj_ver_num Last version num for phone */
564 /* p_email_obj_ver_num Last version num for email */
565 /* p_url_obj_ver_num Last version num for url */
569 /* x_phone_obj_ver_num New Last version num for phone */
566 /* p_update_phone_flag 'Y' to update phone contact point */
567 /* p_update_email_flag 'Y' to update email contact point */
568 /* p_update_url_flag 'Y' to update url contact point */
570 /* x_email_obj_ver_num New Last version num for email */
571 /* x_url_obj_ver_num New Last version num for url */
572 /* x_return_status Standard OUT param */
573 /* x_msg_count Standard OUT param */
574 /* x_msg_data Standard OUT param */
575 /* */
576 /*----------------------------------------------------------------*/
577 PROCEDURE Update_ContactPoints
578 (
579 p_api_version IN NUMBER,
580 p_commit IN VARCHAR2 := fnd_api.g_false,
581 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
582 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
583 p_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
584 p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
585 p_web_rec IN HZ_CONTACT_POINT_V2PUB.web_rec_type,
586 p_phone_cnt_point_id IN NUMBER,
587 p_email_cnt_point_id IN NUMBER,
588 p_url_cnt_point_id IN NUMBER,
589 p_phone_obj_ver_num IN NUMBER,
590 p_email_obj_ver_num IN NUMBER,
591 p_url_obj_ver_num IN NUMBER,
592 p_update_phone_flag IN VARCHAR2,
593 p_update_email_flag IN VARCHAR2,
594 p_update_url_flag IN VARCHAR2,
595 x_phone_obj_ver_num OUT NOCOPY NUMBER,
596 x_email_obj_ver_num OUT NOCOPY NUMBER,
597 x_url_obj_ver_num OUT NOCOPY NUMBER,
598 x_return_status OUT NOCOPY VARCHAR2,
599 x_msg_count OUT NOCOPY NUMBER,
600 x_msg_data OUT NOCOPY VARCHAR2 );
601
602
603 /*----------------------------------------------------------------*/
604 /* procedure name: Update_AddressRecords */
605 /* description : procedure used to update */
606 /* an address record in TCA */
607 /* */
608 /* p_api_version Standard IN param */
609 /* p_commit Standard IN param */
610 /* p_init_msg_list Standard IN param */
611 /* p_validation_level Standard IN param */
612 /* p_location_id Location ID, if it already exists */
613 /* p_loc_rec Location */
614 /* p_addr_obj_ver_num Last version of the location */
615 /* p_site_obj_ver_num Last version of the site */
616 /* x_party_site_rec Site */
617 /* x_addr_obj_ver_num New Last version of the location */
618 /* x_site_obj_ver_num New Last version of the site */
619 /* x_return_status Standard OUT param */
620 /* x_msg_count Standard OUT param */
621 /* x_msg_data Standard OUT param */
622 /* */
623 /*----------------------------------------------------------------*/
624 PROCEDURE Update_AddressRecords
625 (
626 p_api_version IN NUMBER,
627 p_commit IN VARCHAR2 := fnd_api.g_false,
628 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
629 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
630 p_location_id IN NUMBER default null,
631 p_loc_rec IN CSD_PROCESS_PVT.address_rec_type,
632 p_addr_obj_ver_num IN NUMBER,
633 p_site_obj_ver_num IN NUMBER,
634 x_party_site_rec IN OUT NOCOPY HZ_PARTY_SITE_V2PUB.party_site_rec_type,
635 x_addr_obj_ver_num OUT NOCOPY NUMBER,
636 x_site_obj_ver_num OUT NOCOPY NUMBER,
637 x_return_status OUT NOCOPY VARCHAR2,
638 x_msg_count OUT NOCOPY NUMBER,
639 x_msg_data OUT NOCOPY VARCHAR2 );
640
641 /*----------------------------------------------------------------*/
642 /* procedure name: Update_Address */
643 /* description : procedure used to update */
644 /* a location in TCA */
645 /* */
646 /* p_api_version Standard IN param */
647 /* p_commit Standard IN param */
648 /* p_init_msg_list Standard IN param */
649 /* p_validation_level Standard IN param */
650 /* p_address_rec Location to create */
651 /* p_obj_ver_num Last version num of the location */
652 /* prior to calling this procedure */
653 /* x_obj_ver_num Last version num of the location */
654 /* after completing this procedure */
655 /* x_return_status Standard OUT param */
656 /* x_msg_count Standard OUT param */
657 /* x_msg_data Standard OUT param */
658 /* */
659 /*----------------------------------------------------------------*/
660 PROCEDURE Update_Address
661 (
662 p_api_version IN NUMBER,
663 p_commit IN VARCHAR2 := fnd_api.g_false,
667 p_obj_ver_num IN NUMBER,
664 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
665 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
666 p_address_rec IN CSD_PROCESS_PVT.address_rec_type,
668 x_obj_ver_num OUT NOCOPY NUMBER,
669 x_return_status OUT NOCOPY VARCHAR2,
670 x_msg_count OUT NOCOPY NUMBER,
671 x_msg_data OUT NOCOPY VARCHAR2);
672
673
674 END CSD_PARTIES_PVT ;
[Home] [Help]