1 PACKAGE hz_contact_point_v2pub AUTHID CURRENT_USER AS
2 /*$Header: ARH2CPSS.pls 120.9 2006/08/17 10:14:51 idali ship $ */
3 /*#
4 * This package contains the public APIs for contact points.
5 * @rep:scope public
6 * @rep:product HZ
7 * @rep:displayname Contact Point
8 * @rep:category BUSINESS_ENTITY HZ_CONTACT_POINT
9 * @rep:lifecycle active
10 * @rep:doccd 120hztig.pdf Contact Point APIs, Oracle Trading Community Architecture Technical Implementation Guide
11 */
12
13 G_MISS_CONTENT_SOURCE_TYPE CONSTANT VARCHAR2(30) := 'USER_ENTERED';
14
15 --------------------------------------
16 -- declaration of record type
17 --------------------------------------
18
19 TYPE contact_point_rec_type IS RECORD (
20 contact_point_id NUMBER,
21 contact_point_type VARCHAR2(30),
22 status VARCHAR2(30),
23 owner_table_name VARCHAR2(30),
24 owner_table_id NUMBER,
25 primary_flag VARCHAR2(1),
26 orig_system_reference VARCHAR2(240),
27 orig_system VARCHAR2(30),
28 content_source_type VARCHAR2(30) := G_MISS_CONTENT_SOURCE_TYPE,
29 attribute_category VARCHAR2(30),
30 attribute1 VARCHAR2(150),
31 attribute2 VARCHAR2(150),
32 attribute3 VARCHAR2(150),
33 attribute4 VARCHAR2(150),
34 attribute5 VARCHAR2(150),
35 attribute6 VARCHAR2(150),
36 attribute7 VARCHAR2(150),
37 attribute8 VARCHAR2(150),
38 attribute9 VARCHAR2(150),
39 attribute10 VARCHAR2(150),
40 attribute11 VARCHAR2(150),
41 attribute12 VARCHAR2(150),
42 attribute13 VARCHAR2(150),
43 attribute14 VARCHAR2(150),
44 attribute15 VARCHAR2(150),
45 attribute16 VARCHAR2(150),
46 attribute17 VARCHAR2(150),
47 attribute18 VARCHAR2(150),
48 attribute19 VARCHAR2(150),
49 attribute20 VARCHAR2(150),
50 contact_point_purpose VARCHAR2(30),
51 primary_by_purpose VARCHAR2(30),
52 created_by_module VARCHAR2(150),
53 application_id NUMBER,
54 actual_content_source VARCHAR2(30)
55 );
56
57 TYPE edi_rec_type IS RECORD (
58 edi_transaction_handling VARCHAR2(25),
59 edi_id_number VARCHAR2(30),
60 edi_payment_method VARCHAR2(30),
61 edi_payment_format VARCHAR2(30),
62 edi_remittance_method VARCHAR2(30),
63 edi_remittance_instruction VARCHAR2(30),
64 edi_tp_header_id NUMBER,
65 edi_ece_tp_location_code VARCHAR2(40)
66 );
67
68 g_miss_edi_rec edi_rec_type;
69
70 TYPE eft_rec_type IS RECORD (
71 eft_transmission_program_id NUMBER,
72 eft_printing_program_id NUMBER,
73 eft_user_number VARCHAR2(30),
74 eft_swift_code VARCHAR2(30)
75 );
76
77 G_MISS_EFT_REC eft_rec_type;
78
79 TYPE email_rec_type IS RECORD (
80 email_format VARCHAR2(30),
81 email_address VARCHAR2(2000)
82 );
83
84 g_miss_email_rec email_rec_type;
85
86 TYPE phone_rec_type IS RECORD (
87 phone_calling_calendar VARCHAR2(30),
88 last_contact_dt_time DATE,
89 timezone_id NUMBER,
90 phone_area_code VARCHAR2(10),
91 phone_country_code VARCHAR2(10),
92 phone_number VARCHAR2(40),
93 phone_extension VARCHAR2(20),
94 phone_line_type VARCHAR2(30),
95 raw_phone_number VARCHAR2(60)
96 );
97
98 g_miss_phone_rec phone_rec_type;
99
100 TYPE telex_rec_type IS RECORD (
101 telex_number VARCHAR2(50)
102 );
103
104 g_miss_telex_rec telex_rec_type;
105
106 TYPE web_rec_type IS RECORD (
107 web_type VARCHAR2(60),
108 url VARCHAR2(2000)
109 );
110
111 g_miss_web_rec web_rec_type;
112
113 --------------------------------------
114 -- declaration of public procedures and functions
115 --------------------------------------
116
117 --
118 -- PROCEDURE create_contact_point
119 --
120 -- DESCRIPTION
121 -- Creates a contact point. Still here for backward compatibility.
122 --
123 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
124 --
125 -- ARGUMENTS
126 -- IN:
127 -- p_init_msg_list Initialize message stack if it is set to
128 -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
129 -- p_contact_point_rec Contact point record.
130 -- p_edi_rec EDI record.
131 -- p_email_rec Email record.
132 -- p_phone_rec Phone record.
133 -- p_telex_rec Telex record.
134 -- p_web_rec Web record.
135 -- IN/OUT:
136 -- OUT:
137 -- x_contact_point_id Contact point ID.
138 -- x_return_status Return status after the call. The status can
139 -- be fnd_api.g_ret_sts_success (success),
140 -- fnd_api.g_ret_sts_error (error),
141 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
142 -- x_msg_count Number of messages in message stack.
143 -- x_msg_data Message text if x_msg_count is 1.
144 --
145 -- NOTES
146 --
147 -- MODIFICATION HISTORY
148 --
149 -- 07-23-2001 Jianying Huang Created.
150 -- 04-DEC-2001 Joe del Callar Bug 2136283: Added support for
151 -- enhanced backward compatibility.
152 --
153
154 /*#
155 * Use this routine to create a contact point for a party or a party site. The supported
156 * types of contact points are PHONE, PAGER, EMAIL, TELEX, WEB, EFT, and EDI. This routine
157 * creates a record in the HZ_CONTACT_POINTS table. Each contact point type has a
158 * corresponding API. You must call the relevant interface and pass the corresponding
159 * record, which depends on the type of contact point that you create. You should use the
160 * contact type-dependent APIs. The Create Contact Point API, a generic API, is available,
161 * but the generic API does not handle EFT contact points or any future contact point
162 * types. The Create Contact Point API requires that you pass the appropriate record along
163 * with the proper contact point type for the contact point that you need to create. If
164 * orig_system is passed in, then the API also creates a record in the
165 * HZ_ORIG_SYS_REFERENCES table to store the mapping between the source system
166 * reference and the TCA primary key. If timezone_id is not passed in, then the API
167 * generates a time zone value based on the phone components and time zone setup. However,
168 * if the user passes in the time zone, then the API retains that time zone value.
169 * @rep:scope public
170 * @rep:lifecycle active
171 * @rep:displayname Create Contact Point
172 * @rep:businessevent oracle.apps.ar.hz.ContactPoint.create
173 * @rep:doccd 120hztig.pdf Contact Point APIs, Oracle Trading Community Architecture Technical Implementation Guide
174 */
175 PROCEDURE create_contact_point (
176 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
177 p_contact_point_rec IN contact_point_rec_type,
178 p_edi_rec IN edi_rec_type := g_miss_edi_rec,
179 p_email_rec IN email_rec_type := g_miss_email_rec,
180 p_phone_rec IN phone_rec_type := g_miss_phone_rec,
181 p_telex_rec IN telex_rec_type := g_miss_telex_rec,
182 p_web_rec IN web_rec_type := g_miss_web_rec,
183 x_contact_point_id OUT NOCOPY NUMBER,
184 x_return_status OUT NOCOPY VARCHAR2,
185 x_msg_count OUT NOCOPY NUMBER,
186 x_msg_data OUT NOCOPY VARCHAR2
187 );
188
189 --
190 -- PROCEDURE create_edi_contact_point
191 --
192 -- DESCRIPTION
193 -- Creates an EDI contact point.
194 --
195 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
196 --
197 -- ARGUMENTS
198 -- IN:
199 -- p_init_msg_list Initialize message stack if it is set to
200 -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
201 -- p_contact_point_rec Contact point record.
202 -- p_edi_rec EDI record.
203 -- IN/OUT:
204 -- OUT:
205 -- x_contact_point_id Contact point ID.
206 -- x_return_status Return status after the call. The status can
207 -- be fnd_api.g_ret_sts_success (success),
208 -- fnd_api.g_ret_sts_error (error),
209 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
210 -- x_msg_count Number of messages in message stack.
211 -- x_msg_data Message text if x_msg_count is 1.
212 --
213 -- NOTES
214 --
215 -- MODIFICATION HISTORY
216 --
217 -- 04-DEC-2001 Joe del Callar Bug 2136283: Added to support
218 -- enhanced backward compatibility.
219 --
220
221 PROCEDURE create_edi_contact_point (
222 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
223 p_contact_point_rec IN contact_point_rec_type,
224 p_edi_rec IN edi_rec_type := g_miss_edi_rec,
225 x_contact_point_id OUT NOCOPY NUMBER,
226 x_return_status OUT NOCOPY VARCHAR2,
227 x_msg_count OUT NOCOPY NUMBER,
228 x_msg_data OUT NOCOPY VARCHAR2
229 );
230
231 --
232 -- PROCEDURE create_web_contact_point
233 --
234 -- DESCRIPTION
235 -- Creates a Web contact point.
236 --
237 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
238 --
239 -- ARGUMENTS
240 -- IN:
241 -- p_init_msg_list Initialize message stack if it is set to
242 -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
243 -- p_contact_point_rec Contact point record.
244 -- p_web_rec Web record.
245 -- IN/OUT:
246 -- OUT:
247 -- x_contact_point_id Contact point ID.
248 -- x_return_status Return status after the call. The status can
249 -- be fnd_api.g_ret_sts_success (success),
250 -- fnd_api.g_ret_sts_error (error),
251 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
252 -- x_msg_count Number of messages in message stack.
253 -- x_msg_data Message text if x_msg_count is 1.
254 --
255 -- NOTES
256 --
257 -- MODIFICATION HISTORY
258 --
259 -- 04-DEC-2001 Joe del Callar Bug 2136283: Added support for
260 -- enhanced backward compatibility.
261 --
262
263 PROCEDURE create_web_contact_point (
264 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
265 p_contact_point_rec IN contact_point_rec_type,
266 p_web_rec IN web_rec_type := g_miss_web_rec,
267 x_contact_point_id OUT NOCOPY NUMBER,
268 x_return_status OUT NOCOPY VARCHAR2,
269 x_msg_count OUT NOCOPY NUMBER,
270 x_msg_data OUT NOCOPY VARCHAR2
271 );
272
273 --
274 -- PROCEDURE create_eft_contact_point
275 --
276 -- DESCRIPTION
277 -- Creates an EFT contact point.
278 --
279 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
280 --
281 -- ARGUMENTS
282 -- IN:
283 -- p_init_msg_list Initialize message stack if it is set to
284 -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
285 -- p_contact_point_rec Contact point record.
286 -- p_eft_rec EFT record.
287 -- IN/OUT:
288 -- OUT:
289 -- x_contact_point_id Contact point ID.
290 -- x_return_status Return status after the call. The status can
291 -- be fnd_api.g_ret_sts_success (success),
292 -- fnd_api.g_ret_sts_error (error),
293 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
294 -- x_msg_count Number of messages in message stack.
295 -- x_msg_data Message text if x_msg_count is 1.
296 --
297 -- NOTES
298 --
299 -- MODIFICATION HISTORY
300 --
301 -- 04-DEC-2001 Joe del Callar Bug 2136283: Added support for
302 -- enhanced backward compatibility.
303 -- Bug 2100992: Added for bank
304 -- consolidation support.
305 --
306
307 PROCEDURE create_eft_contact_point (
311 x_contact_point_id OUT NOCOPY NUMBER,
308 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
309 p_contact_point_rec IN contact_point_rec_type,
310 p_eft_rec IN eft_rec_type := g_miss_eft_rec,
312 x_return_status OUT NOCOPY VARCHAR2,
313 x_msg_count OUT NOCOPY NUMBER,
314 x_msg_data OUT NOCOPY VARCHAR2
315 );
316
317 --
318 -- PROCEDURE create_phone_contact_point
319 --
320 -- DESCRIPTION
321 -- Creates a phone contact point.
322 --
323 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
324 --
325 -- ARGUMENTS
326 -- IN:
327 -- p_init_msg_list Initialize message stack if it is set to
328 -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
329 -- p_contact_point_rec Contact point record.
330 -- p_phone_rec Phone record.
331 -- IN/OUT:
332 -- OUT:
333 -- x_contact_point_id Contact point ID.
334 -- x_return_status Return status after the call. The status can
335 -- be fnd_api.g_ret_sts_success (success),
336 -- fnd_api.g_ret_sts_error (error),
337 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
338 -- x_msg_count Number of messages in message stack.
339 -- x_msg_data Message text if x_msg_count is 1.
340 --
341 -- NOTES
342 --
343 -- MODIFICATION HISTORY
344 --
345 -- 04-DEC-2001 Joe del Callar Bug 2136283: Added support for
346 -- enhanced backward compatibility.
347 --
348
349 PROCEDURE create_phone_contact_point (
350 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
351 p_contact_point_rec IN contact_point_rec_type,
352 p_phone_rec IN phone_rec_type := g_miss_phone_rec,
353 x_contact_point_id OUT NOCOPY NUMBER,
354 x_return_status OUT NOCOPY VARCHAR2,
355 x_msg_count OUT NOCOPY NUMBER,
356 x_msg_data OUT NOCOPY VARCHAR2
357 );
358
359 --
360 -- PROCEDURE create_telex_contact_point
361 --
362 -- DESCRIPTION
363 -- Creates a telex contact point.
364 --
365 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
366 --
367 -- ARGUMENTS
368 -- IN:
369 -- p_init_msg_list Initialize message stack if it is set to
370 -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
371 -- p_contact_point_rec Contact point record.
372 -- p_telex_rec Telex record.
373 -- IN/OUT:
374 -- OUT:
375 -- x_contact_point_id Contact point ID.
376 -- x_return_status Return status after the call. The status can
377 -- be fnd_api.g_ret_sts_success (success),
378 -- fnd_api.g_ret_sts_error (error),
379 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
380 -- x_msg_count Number of messages in message stack.
381 -- x_msg_data Message text if x_msg_count is 1.
382 --
383 -- NOTES
384 --
385 -- MODIFICATION HISTORY
386 --
387 -- 04-DEC-2001 Joe del Callar Bug 2136283: Added support for
388 -- enhanced backward compatibility.
389 --
390
391 PROCEDURE create_telex_contact_point (
392 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
393 p_contact_point_rec IN contact_point_rec_type,
394 p_telex_rec IN telex_rec_type := g_miss_telex_rec,
395 x_contact_point_id OUT NOCOPY NUMBER,
396 x_return_status OUT NOCOPY VARCHAR2,
397 x_msg_count OUT NOCOPY NUMBER,
398 x_msg_data OUT NOCOPY VARCHAR2
399 );
400
401 --
402 -- PROCEDURE create_email_contact_point
403 --
404 -- DESCRIPTION
405 -- Creates a email contact point.
406 --
407 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
408 --
409 -- ARGUMENTS
410 -- IN:
411 -- p_init_msg_list Initialize message stack if it is set to
412 -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
413 -- p_contact_point_rec Contact point record.
414 -- p_email_rec Email record.
415 -- IN/OUT:
416 -- OUT:
417 -- x_contact_point_id Contact point ID.
418 -- x_return_status Return status after the call. The status can
419 -- be fnd_api.g_ret_sts_success (success),
420 -- fnd_api.g_ret_sts_error (error),
421 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
422 -- x_msg_count Number of messages in message stack.
423 -- x_msg_data Message text if x_msg_count is 1.
424 --
425 -- NOTES
426 --
427 -- MODIFICATION HISTORY
428 --
429 -- 04-DEC-2001 Joe del Callar Bug 2136283: Added support for
430 -- enhanced backward compatibility.
431 --
432
433 PROCEDURE create_email_contact_point (
434 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
438 x_return_status OUT NOCOPY VARCHAR2,
435 p_contact_point_rec IN contact_point_rec_type,
436 p_email_rec IN email_rec_type := g_miss_email_rec,
437 x_contact_point_id OUT NOCOPY NUMBER,
439 x_msg_count OUT NOCOPY NUMBER,
440 x_msg_data OUT NOCOPY VARCHAR2
441 );
442
443 --
444 -- PRIVATE PROCEDURE update_contact_point
445 --
446 -- DESCRIPTION
447 -- Updates the given contact point.
448 --
449 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
450 --
451 -- ARGUMENTS
452 -- IN:
453 -- p_init_msg_list Initialize message stack if it is set to
454 -- FND_API.G_TRUE. Default is fnd_api.g_false.
455 -- p_contact_point_rec Contact point record.
456 -- p_edi_rec EDI record.
457 -- p_email_rec Email record.
458 -- p_phone_rec Phone record.
459 -- p_telex_rec Telex record.
460 -- p_web_rec Web record.
461 -- IN/OUT:
462 -- p_object_version_number Used for locking the being updated record.
463 -- OUT:
464 -- x_return_status Return status after the call. The status can
465 -- be fnd_api.g_ret_sts_success (success),
466 -- fnd_api.g_ret_sts_error (error),
467 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
468 -- x_msg_count Number of messages in message stack.
469 -- x_msg_data Message text if x_msg_count is 1.
470 --
471 -- NOTES
472 --
473 -- MODIFICATION HISTORY
474 --
475 -- 07-23-2001 Jianying Huang Created.
476 -- 04-DEC-2001 Joe del Callar Bug 2136283: Added support for
477 -- enhanced backward compatibility.
478 --
479
480 /*#
481 * Use this routine to update a contact point for a party or a party site. The supported
482 * types of contact points are PHONE, PAGER, EMAIL, TELEX, WEB, EFT, and EDI. This API
483 * updates records in the HZ_CONTACT_POINTS table. Each contact point type has a
484 * corresponding API. You must call the relevant interface and pass the corresponding
485 * record, which depends on the type of contact point you create.You should use the
486 * contact type-dependent APIs. The Update Contact Point, a generic API, is available, but
487 * the generic API does not handle EFT contact points or any future contact point types.
488 * The Update Contact Point API requires that you pass the appropriate record along with
489 * the proper contact point type for the contact point that you need to create.If the
490 * primary key is not passed in, get the primary key from the HZ_ORIG_SYS_REFERENCES table
491 * based on orig_system and orig_system_reference if they are not null and unique. If
492 * timezone_id is not passed in, then the API generates a time zone value based on the
493 * changes of the phone components and time zone setup, even if a time zone already exists
494 * in the database. However, if the user passes in the time zone, then the API retains
495 * that time zone value.
496 * @rep:scope public
497 * @rep:lifecycle active
498 * @rep:displayname Update Contact Point
499 * @rep:businessevent oracle.apps.ar.hz.ContactPoint.update
500 * @rep:doccd 120hztig.pdf Contact Point APIs, Oracle Trading Community Architecture Technical Implementation Guide
501 */
502 PROCEDURE update_contact_point (
503 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
504 p_contact_point_rec IN contact_point_rec_type,
505 p_edi_rec IN edi_rec_type := g_miss_edi_rec,
506 p_email_rec IN email_rec_type := g_miss_email_rec,
507 p_phone_rec IN phone_rec_type := g_miss_phone_rec,
508 p_telex_rec IN telex_rec_type := g_miss_telex_rec,
509 p_web_rec IN web_rec_type := g_miss_web_rec,
510 p_object_version_number IN OUT NOCOPY NUMBER,
511 x_return_status OUT NOCOPY VARCHAR2,
512 x_msg_count OUT NOCOPY NUMBER,
513 x_msg_data OUT NOCOPY VARCHAR2
514 );
515
516 --
517 -- PROCEDURE update_edi_contact_point
518 --
519 -- DESCRIPTION
520 -- Updates the given EDI contact point.
521 --
522 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
523 --
524 -- ARGUMENTS
525 -- IN:
526 -- p_init_msg_list Initialize message stack if it is set to
527 -- FND_API.G_TRUE. Default is fnd_api.g_false.
528 -- p_contact_point_rec Contact point record.
529 -- p_edi_rec EDI record.
530 -- IN/OUT:
531 -- p_object_version_number Used for locking the being updated record.
532 -- OUT:
533 -- x_return_status Return status after the call. The status can
534 -- be fnd_api.g_ret_sts_success (success),
535 -- fnd_api.g_ret_sts_error (error),
536 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
537 -- x_msg_count Number of messages in message stack.
538 -- x_msg_data Message text if x_msg_count is 1.
539 --
540 -- NOTES
541 --
542 -- MODIFICATION HISTORY
546 --
543 --
544 -- 04-DEC-2001 Joe del Callar Bug 2136283: Added to support
545 -- enhanced backward compatibility.
547
548 PROCEDURE update_edi_contact_point (
549 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
550 p_contact_point_rec IN contact_point_rec_type,
551 p_edi_rec IN edi_rec_type := g_miss_edi_rec,
552 p_object_version_number IN OUT NOCOPY NUMBER,
553 x_return_status OUT NOCOPY VARCHAR2,
554 x_msg_count OUT NOCOPY NUMBER,
555 x_msg_data OUT NOCOPY VARCHAR2
556 );
557
558 --
559 -- PROCEDURE update_web_contact_point
560 --
561 -- DESCRIPTION
562 -- Updates the given Web contact point.
563 --
564 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
565 --
566 -- ARGUMENTS
567 -- IN:
568 -- p_init_msg_list Initialize message stack if it is set to
569 -- FND_API.G_TRUE. Default is fnd_api.g_false.
570 -- p_contact_point_rec Contact point record.
571 -- p_web_rec WEB record.
572 -- IN/OUT:
573 -- p_object_version_number Used for locking the being updated record.
574 -- OUT:
575 -- x_return_status Return status after the call. The status can
576 -- be fnd_api.g_ret_sts_success (success),
577 -- fnd_api.g_ret_sts_error (error),
578 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
579 -- x_msg_count Number of messages in message stack.
580 -- x_msg_data Message text if x_msg_count is 1.
581 --
582 -- NOTES
583 --
584 -- MODIFICATION HISTORY
585 --
586 -- 04-DEC-2001 Joe del Callar Bug 2136283: Added to support
587 -- enhanced backward compatibility.
588 --
589
590 PROCEDURE update_web_contact_point (
591 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
592 p_contact_point_rec IN contact_point_rec_type,
593 p_web_rec IN web_rec_type := g_miss_web_rec,
594 p_object_version_number IN OUT NOCOPY NUMBER,
595 x_return_status OUT NOCOPY VARCHAR2,
596 x_msg_count OUT NOCOPY NUMBER,
597 x_msg_data OUT NOCOPY VARCHAR2
598 );
599
600 --
601 -- PROCEDURE update_eft_contact_point
602 --
603 -- DESCRIPTION
604 -- Updates the given EFT contact point.
605 --
606 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
607 --
608 -- ARGUMENTS
609 -- IN:
610 -- p_init_msg_list Initialize message stack if it is set to
611 -- FND_API.G_TRUE. Default is fnd_api.g_false.
612 -- p_contact_point_rec Contact point record.
613 -- p_eft_rec EFT record.
614 -- IN/OUT:
615 -- p_object_version_number Used for locking the being updated record.
616 -- OUT:
617 -- x_return_status Return status after the call. The status can
618 -- be fnd_api.g_ret_sts_success (success),
619 -- fnd_api.g_ret_sts_error (error),
620 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
621 -- x_msg_count Number of messages in message stack.
622 -- x_msg_data Message text if x_msg_count is 1.
623 --
624 -- NOTES
625 --
626 -- MODIFICATION HISTORY
627 --
628 -- 19-NOV-2001 Joe del Callar Bug 2116225: Added to support
629 -- Bank Consolidation.
630 -- 04-DEC-2001 Joe del Callar Bug 2136283: Added to support
631 -- enhanced backward compatibility.
632 --
633
634 PROCEDURE update_eft_contact_point (
635 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
636 p_contact_point_rec IN contact_point_rec_type,
637 p_eft_rec IN eft_rec_type := g_miss_eft_rec,
638 p_object_version_number IN OUT NOCOPY NUMBER,
639 x_return_status OUT NOCOPY VARCHAR2,
640 x_msg_count OUT NOCOPY NUMBER,
641 x_msg_data OUT NOCOPY VARCHAR2
642 );
643
644 --
645 -- PROCEDURE update_phone_contact_point
646 --
647 -- DESCRIPTION
648 -- Updates the given phone contact point.
649 --
650 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
651 --
652 -- ARGUMENTS
653 -- IN:
654 -- p_init_msg_list Initialize message stack if it is set to
655 -- FND_API.G_TRUE. Default is fnd_api.g_false.
656 -- p_contact_point_rec Contact point record.
657 -- p_phone_rec Phone record.
658 -- IN/OUT:
659 -- p_object_version_number Used for locking the being updated record.
660 -- OUT:
661 -- x_return_status Return status after the call. The status can
662 -- be fnd_api.g_ret_sts_success (success),
663 -- fnd_api.g_ret_sts_error (error),
664 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
668 -- NOTES
665 -- x_msg_count Number of messages in message stack.
666 -- x_msg_data Message text if x_msg_count is 1.
667 --
669 --
670 -- MODIFICATION HISTORY
671 --
672 -- 04-DEC-2001 Joe del Callar Bug 2136283: Added to support
673 -- enhanced backward compatibility.
674 --
675
676 PROCEDURE update_phone_contact_point (
677 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
678 p_contact_point_rec IN contact_point_rec_type,
679 p_phone_rec IN phone_rec_type := g_miss_phone_rec,
680 p_object_version_number IN OUT NOCOPY NUMBER,
681 x_return_status OUT NOCOPY VARCHAR2,
682 x_msg_count OUT NOCOPY NUMBER,
683 x_msg_data OUT NOCOPY VARCHAR2
684 );
685
686 --
687 -- PROCEDURE update_telex_contact_point
688 --
689 -- DESCRIPTION
690 -- Updates the given telex contact point.
691 --
692 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
693 --
694 -- ARGUMENTS
695 -- IN:
696 -- p_init_msg_list Initialize message stack if it is set to
697 -- FND_API.G_TRUE. Default is fnd_api.g_false.
698 -- p_contact_point_rec Contact point record.
699 -- p_telex_rec Telex record.
700 -- IN/OUT:
701 -- p_object_version_number Used for locking the being updated record.
702 -- OUT:
703 -- x_return_status Return status after the call. The status can
704 -- be fnd_api.g_ret_sts_success (success),
705 -- fnd_api.g_ret_sts_error (error),
706 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
707 -- x_msg_count Number of messages in message stack.
708 -- x_msg_data Message text if x_msg_count is 1.
709 --
710 -- NOTES
711 --
712 -- MODIFICATION HISTORY
713 --
714 -- 04-DEC-2001 Joe del Callar Bug 2136283: Added to support
715 -- enhanced backward compatibility.
716 --
717
718 PROCEDURE update_telex_contact_point (
719 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
720 p_contact_point_rec IN contact_point_rec_type,
721 p_telex_rec IN telex_rec_type := g_miss_telex_rec,
722 p_object_version_number IN OUT NOCOPY NUMBER,
723 x_return_status OUT NOCOPY VARCHAR2,
724 x_msg_count OUT NOCOPY NUMBER,
725 x_msg_data OUT NOCOPY VARCHAR2
726 );
727
728 --
729 -- PROCEDURE update_email_contact_point
730 --
731 -- DESCRIPTION
732 -- Updates the given email contact point.
733 --
734 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
735 --
736 -- ARGUMENTS
737 -- IN:
738 -- p_init_msg_list Initialize message stack if it is set to
739 -- FND_API.G_TRUE. Default is fnd_api.g_false.
740 -- p_contact_point_rec Contact point record.
741 -- p_email_rec Email record.
742 -- IN/OUT:
743 -- p_object_version_number Used for locking the being updated record.
744 -- OUT:
745 -- x_return_status Return status after the call. The status can
746 -- be fnd_api.g_ret_sts_success (success),
747 -- fnd_api.g_ret_sts_error (error),
748 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
749 -- x_msg_count Number of messages in message stack.
750 -- x_msg_data Message text if x_msg_count is 1.
751 --
752 -- NOTES
753 --
754 -- MODIFICATION HISTORY
755 --
756 -- 04-DEC-2001 Joe del Callar Bug 2136283: Added to support
757 -- enhanced backward compatibility.
758 --
759
760 PROCEDURE update_email_contact_point (
761 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
762 p_contact_point_rec IN contact_point_rec_type,
763 p_email_rec IN email_rec_type := g_miss_email_rec,
764 p_object_version_number IN OUT NOCOPY NUMBER,
765 x_return_status OUT NOCOPY VARCHAR2,
766 x_msg_count OUT NOCOPY NUMBER,
767 x_msg_data OUT NOCOPY VARCHAR2
768 );
769
770 --
771 -- PROCEDURE get_contact_point_rec
772 --
773 -- DESCRIPTION
774 -- Cets contact point record.
775 --
776 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
777 --
778 -- ARGUMENTS
779 -- IN:
780 -- p_init_msg_list Initialize message stack if it is set to
781 -- fnd_api.g_true. Default is fnd_api.g_false.
782 -- p_contact_point_id Contact point ID.
783 -- IN/OUT:
784 -- OUT:
785 -- x_contact_point_rec Returned contact point record.
786 -- x_edi_rec Returned EDI record.
787 -- x_email_rec Returned email record.
788 -- x_phone_rec Returned phone record.
789 -- x_telex_rec Returned telex record.
793 -- FND_API.G_RET_STS_ERROR (error),
790 -- x_web_rec Returned web record.
791 -- x_return_status Return status after the call. The status can
792 -- be FND_API.G_RET_STS_SUCCESS (success),
794 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected
795 -- error).
796 -- x_msg_count Number of messages in message stack.
797 -- x_msg_data Message text if x_msg_count is 1.
798 --
799 -- NOTES
800 --
801 -- MODIFICATION HISTORY
802 --
803 -- 07-23-2001 Jianying Huang o Created.
804 -- 19-NOV-2001 Joe del Callar Bug 2116225: Added support for
805 -- Bank Consolidation.
806 --
807 --
808
809 PROCEDURE get_contact_point_rec (
810 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
811 p_contact_point_id IN NUMBER,
812 x_contact_point_rec OUT NOCOPY contact_point_rec_type,
813 x_edi_rec OUT NOCOPY edi_rec_type,
814 x_email_rec OUT NOCOPY email_rec_type,
815 x_phone_rec OUT NOCOPY phone_rec_type,
816 x_telex_rec OUT NOCOPY telex_rec_type,
817 x_web_rec OUT NOCOPY web_rec_type,
818 x_return_status OUT NOCOPY VARCHAR2,
819 x_msg_count OUT NOCOPY NUMBER,
820 x_msg_data OUT NOCOPY VARCHAR2
821 );
822
823 --
824 -- PROCEDURE get_edi_contact_point
825 --
826 -- DESCRIPTION
827 -- Gets EDI contact point record.
828 --
829 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
830 --
831 -- ARGUMENTS
832 -- IN:
833 -- p_init_msg_list Initialize message stack if it is set to
834 -- FND_API.G_TRUE. Default is fnd_api.g_false.
835 -- p_contact_point_id Contact point ID.
836 -- IN/OUT:
837 -- OUT:
838 -- x_contact_point_rec Returned contact point record.
839 -- x_edi_rec Returned EDI record.
840 -- x_return_status Return status after the call. The status can
841 -- be fnd_api.g_ret_sts_success (success),
842 -- fnd_api.g_ret_sts_error (error),
843 -- fnd_api.g_ret_sts_unexp_error (unexpected error).
844 -- x_msg_count Number of messages in message stack.
845 -- x_msg_data Message text if x_msg_count is 1.
846 --
847 -- NOTES
848 --
849 -- MODIFICATION HISTORY
850 --
851 -- 07-23-2001 Jianying Huang o Created.
852 -- 04-DEC-2001 Joe del Callar Bug 2136283: Added support for
853 -- enhanced backward compatibility.
854 --
855
856 PROCEDURE get_edi_contact_point (
857 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
858 p_contact_point_id IN NUMBER,
859 x_contact_point_rec OUT NOCOPY contact_point_rec_type,
860 x_edi_rec OUT NOCOPY edi_rec_type,
861 x_return_status OUT NOCOPY VARCHAR2,
862 x_msg_count OUT NOCOPY NUMBER,
863 x_msg_data OUT NOCOPY VARCHAR2
864 );
865
866 --
867 -- PROCEDURE get_eft_contact_point
868 --
869 -- DESCRIPTION
870 -- Gets EFT contact point record.
871 --
872 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
873 --
874 -- ARGUMENTS
875 -- IN:
876 -- p_init_msg_list Initialize message stack if it is set to
877 -- FND_API.G_TRUE. Default is fnd_api.g_false.
878 -- p_contact_point_id Contact point ID.
879 -- IN/OUT:
880 -- OUT:
881 -- x_contact_point_rec Returned contact point record.
882 -- x_eft_rec Returned EFT record.
883 -- x_return_status Return status after the call. The status can
884 -- be fnd_api.g_ret_sts_success (success),
885 -- fnd_api.g_ret_sts_error (error),
886 -- fnd_api.g_ret_sts_unexp_error (unexpected error).
887 -- x_msg_count Number of messages in message stack.
888 -- x_msg_data Message text if x_msg_count is 1.
889 --
890 -- NOTES
891 --
892 -- MODIFICATION HISTORY
893 --
894 -- 07-23-2001 Jianying Huang o Created.
895 -- 04-DEC-2001 Joe del Callar Bug 2136283: Added support for
896 -- enhanced backward compatibility.
897 --
898
899 PROCEDURE get_eft_contact_point (
900 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
901 p_contact_point_id IN NUMBER,
902 x_contact_point_rec OUT NOCOPY contact_point_rec_type,
903 x_eft_rec OUT NOCOPY eft_rec_type,
904 x_return_status OUT NOCOPY VARCHAR2,
905 x_msg_count OUT NOCOPY NUMBER,
906 x_msg_data OUT NOCOPY VARCHAR2
907 );
908
909 --
910 -- PROCEDURE get_web_contact_point
911 --
912 -- DESCRIPTION
913 -- Gets Web contact point record.
914 --
918 -- IN:
915 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
916 --
917 -- ARGUMENTS
919 -- p_init_msg_list Initialize message stack if it is set to
920 -- FND_API.G_TRUE. Default is fnd_api.g_false.
921 -- p_contact_point_id Contact point ID.
922 -- IN/OUT:
923 -- OUT:
924 -- x_contact_point_rec Returned contact point record.
925 -- x_web_rec Returned Web record.
926 -- x_return_status Return status after the call. The status can
927 -- be fnd_api.g_ret_sts_success (success),
928 -- fnd_api.g_ret_sts_error (error),
929 -- fnd_api.g_ret_sts_unexp_error (unexpected error).
930 -- x_msg_count Number of messages in message stack.
931 -- x_msg_data Message text if x_msg_count is 1.
932 --
933 -- NOTES
934 --
935 -- MODIFICATION HISTORY
936 --
937 -- 07-23-2001 Jianying Huang o Created.
938 -- 04-DEC-2001 Joe del Callar Bug 2136283: Added support for
939 -- enhanced backward compatibility.
940 --
941
942 PROCEDURE get_web_contact_point (
943 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
944 p_contact_point_id IN NUMBER,
945 x_contact_point_rec OUT NOCOPY contact_point_rec_type,
946 x_web_rec OUT NOCOPY web_rec_type,
947 x_return_status OUT NOCOPY VARCHAR2,
948 x_msg_count OUT NOCOPY NUMBER,
949 x_msg_data OUT NOCOPY VARCHAR2
950 );
951
952 --
953 -- PROCEDURE get_phone_contact_point
954 --
955 -- DESCRIPTION
956 -- Gets phone contact point record.
957 --
958 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
959 --
960 -- ARGUMENTS
961 -- IN:
962 -- p_init_msg_list Initialize message stack if it is set to
963 -- FND_API.G_TRUE. Default is fnd_api.g_false.
964 -- p_contact_point_id Contact point ID.
965 -- IN/OUT:
966 -- OUT:
967 -- x_contact_point_rec Returned contact point record.
968 -- x_phone_rec Returned phone record.
969 -- x_return_status Return status after the call. The status can
970 -- be fnd_api.g_ret_sts_success (success),
971 -- fnd_api.g_ret_sts_error (error),
972 -- fnd_api.g_ret_sts_unexp_error (unexpected error).
973 -- x_msg_count Number of messages in message stack.
974 -- x_msg_data Message text if x_msg_count is 1.
975 --
976 -- NOTES
977 --
978 -- MODIFICATION HISTORY
979 --
980 -- 07-23-2001 Jianying Huang o Created.
981 -- 04-DEC-2001 Joe del Callar Bug 2136283: Added support for
982 -- enhanced backward compatibility.
983 --
984
985 PROCEDURE get_phone_contact_point (
986 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
987 p_contact_point_id IN NUMBER,
988 x_contact_point_rec OUT NOCOPY contact_point_rec_type,
989 x_phone_rec OUT NOCOPY phone_rec_type,
990 x_return_status OUT NOCOPY VARCHAR2,
991 x_msg_count OUT NOCOPY NUMBER,
992 x_msg_data OUT NOCOPY VARCHAR2
993 );
994
995 --
996 -- PROCEDURE get_telex_contact_point
997 --
998 -- DESCRIPTION
999 -- Gets telex contact point record.
1000 --
1001 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1002 --
1003 -- ARGUMENTS
1004 -- IN:
1005 -- p_init_msg_list Initialize message stack if it is set to
1006 -- FND_API.G_TRUE. Default is fnd_api.g_false.
1007 -- p_contact_point_id Contact point ID.
1008 -- IN/OUT:
1009 -- OUT:
1010 -- x_contact_point_rec Returned contact point record.
1011 -- x_telex_rec Returned telex record.
1012 -- x_return_status Return status after the call. The status can
1013 -- be fnd_api.g_ret_sts_success (success),
1014 -- fnd_api.g_ret_sts_error (error),
1015 -- fnd_api.g_ret_sts_unexp_error (unexpected error).
1016 -- x_msg_count Number of messages in message stack.
1017 -- x_msg_data Message text if x_msg_count is 1.
1018 --
1019 -- NOTES
1020 --
1021 -- MODIFICATION HISTORY
1022 --
1023 -- 07-23-2001 Jianying Huang o Created.
1024 -- 04-DEC-2001 Joe del Callar Bug 2136283: Added support for
1025 -- enhanced backward compatibility.
1026 --
1027
1028 PROCEDURE get_telex_contact_point (
1029 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1030 p_contact_point_id IN NUMBER,
1031 x_contact_point_rec OUT NOCOPY contact_point_rec_type,
1032 x_telex_rec OUT NOCOPY telex_rec_type,
1033 x_return_status OUT NOCOPY VARCHAR2,
1034 x_msg_count OUT NOCOPY NUMBER,
1035 x_msg_data OUT NOCOPY VARCHAR2
1036 );
1037
1038 --
1039 -- PROCEDURE get_email_contact_point
1040 --
1041 -- DESCRIPTION
1042 -- Gets email contact point record.
1043 --
1044 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1045 --
1046 -- ARGUMENTS
1047 -- IN:
1048 -- p_init_msg_list Initialize message stack if it is set to
1049 -- FND_API.G_TRUE. Default is fnd_api.g_false.
1050 -- p_contact_point_id Contact point ID.
1051 -- IN/OUT:
1052 -- OUT:
1053 -- x_contact_point_rec Returned contact point record.
1054 -- x_email_rec Returned email record.
1055 -- x_return_status Return status after the call. The status can
1056 -- be fnd_api.g_ret_sts_success (success),
1057 -- fnd_api.g_ret_sts_error (error),
1058 -- fnd_api.g_ret_sts_unexp_error (unexpected error).
1059 -- x_msg_count Number of messages in message stack.
1060 -- x_msg_data Message text if x_msg_count is 1.
1061 --
1062 -- NOTES
1063 --
1064 -- MODIFICATION HISTORY
1065 --
1066 -- 07-23-2001 Jianying Huang o Created.
1067 -- 04-DEC-2001 Joe del Callar Bug 2136283: Added support for
1068 -- enhanced backward compatibility.
1069 --
1070
1071 PROCEDURE get_email_contact_point (
1072 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1073 p_contact_point_id IN NUMBER,
1074 x_contact_point_rec OUT NOCOPY contact_point_rec_type,
1075 x_email_rec OUT NOCOPY email_rec_type,
1076 x_return_status OUT NOCOPY VARCHAR2,
1077 x_msg_count OUT NOCOPY NUMBER,
1078 x_msg_data OUT NOCOPY VARCHAR2
1079 );
1080
1081 --
1082 -- PROCEDURE phone_format
1083 --
1084 -- DESCRIPTION
1085 -- formats a phone number
1086 --
1087 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1088 --
1089 -- ARGUMENTS
1090 -- IN:
1091 -- p_init_msg_list Initialize message stack if it is set to
1092 -- fnd_api.g_true. Default is fnd_api.g_false.
1093 -- p_raw_phone_number Raw phone number.
1094 -- p_territory_code Territory code.
1095 -- IN/OUT:
1096 -- x_phone_country_code Phone country code.
1097 -- x_phone_area_code Phone area code.
1098 -- x_phone_number Phone number.
1099 -- OUT:
1100 -- x_formatted_phone_number Formatted phone number.
1101 -- x_return_status Return status after the call. The status can
1102 -- be FND_API.G_RET_STS_SUCCESS (success),
1103 -- FND_API.G_RET_STS_ERROR (error),
1104 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected
1105 -- error).
1106 -- x_msg_count Number of messages in message stack.
1107 -- x_msg_data Message text if x_msg_count is 1.
1108 --
1109 -- NOTES
1110 --
1111 -- MODIFICATION HISTORY
1112 --
1113 -- 07-23-2001 Jianying Huang o Created.
1114 --
1115
1116 PROCEDURE phone_format (
1117 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1118 p_raw_phone_number IN VARCHAR2 := fnd_api.g_miss_char,
1119 p_territory_code IN VARCHAR2 := fnd_api.g_miss_char,
1120 x_formatted_phone_number OUT NOCOPY VARCHAR2,
1121 x_phone_country_code IN OUT NOCOPY VARCHAR2,
1122 x_phone_area_code IN OUT NOCOPY VARCHAR2,
1123 x_phone_number IN OUT NOCOPY VARCHAR2,
1124 x_return_status OUT NOCOPY VARCHAR2,
1125 x_msg_count OUT NOCOPY NUMBER,
1126 x_msg_data OUT NOCOPY VARCHAR2
1127 );
1128
1129 END hz_contact_point_v2pub;