[Home] [Help]
PACKAGE: APPS.HZ_REGISTRY_VALIDATE_V2PUB
Source
1 PACKAGE hz_registry_validate_v2pub AS
2 /*$Header: ARH2RGVS.pls 120.9 2005/10/30 03:50:04 appldev noship $ */
3
4 --------------------------------------
5 -- declaration of public procedures and functions
6 --------------------------------------
7
8 --
9 -- PROCEDURE validate_party
10 --
11 -- DESCRIPTION
12 -- Validates party record. Checks for
13 -- uniqueness
14 -- lookup types
15 -- mandatory columns
16 -- non-updateable fields
17 -- foreign key validations
18 -- other validations
19 --
20 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
21 --
22 -- ARGUMENTS
23 -- IN:
24 -- p_create_update_flag Create update flag. 'C' = create. 'U' = update.
25 -- p_party_rec Party record.
26 -- p_old_party_rec Old party record.
27 -- p_db_created_by_module Current created by module
28 -- IN/OUT:
29 -- x_return_status Return status after the call. The status can
30 -- be FND_API.G_RET_STS_SUCCESS (success),
31 -- FND_API.G_RET_STS_ERROR (error),
32 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
33 --
34 -- NOTES
35 --
36 -- MODIFICATION HISTORY
37 --
38 -- 07-23-2001 Indrajit Sen o Created.
39 --
40 --
41
42 PROCEDURE validate_party(
43 p_create_update_flag IN VARCHAR2,
44 p_party_rec IN HZ_PARTY_V2PUB.PARTY_REC_TYPE,
45 p_old_party_rec IN HZ_PARTY_V2PUB.PARTY_REC_TYPE,
46 p_db_created_by_module IN VARCHAR2,
47 x_return_status IN OUT NOCOPY VARCHAR2
48 );
49
50 --
51 -- PROCEDURE validate_person
52 --
53 -- DESCRIPTION
54 -- Validates person record. Checks for
55 -- uniqueness
56 -- lookup types
57 -- mandatory columns
58 -- non-updateable fields
59 -- foreign key validations
60 -- other validations
61 --
62 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
63 --
64 -- ARGUMENTS
65 -- IN:
66 -- p_create_update_flag Create update flag. 'C' = create. 'U' = update.
67 -- p_person_rec Person record.
68 -- p_old_person_rec Old person record.
69 -- IN/OUT:
70 -- x_return_status Return status after the call. The status can
71 -- be FND_API.G_RET_STS_SUCCESS (success),
72 -- FND_API.G_RET_STS_ERROR (error),
73 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
74 --
75 -- NOTES
76 --
77 -- MODIFICATION HISTORY
78 --
79 -- 07-23-2001 Indrajit Sen o Created.
80 --
81 --
82
83 PROCEDURE validate_person(
84 p_create_update_flag IN VARCHAR2,
85 p_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
86 p_old_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
87 x_return_status IN OUT NOCOPY VARCHAR2
88 );
89
90 --
91 -- PROCEDURE validate_group
92 --
93 -- DESCRIPTION
94 -- Validates group record. Checks for
95 -- uniqueness
96 -- lookup types
97 -- mandatory columns
98 -- non-updateable fields
99 -- foreign key validations
100 -- other validations
101 --
102 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
103 --
104 -- ARGUMENTS
105 -- IN:
106 -- p_create_update_flag Create update flag. 'C' = create. 'U' = update.
107 -- p_group_rec Group record.
108 -- p_old_group_rec Old group record.
109 -- IN/OUT:
110 -- x_return_status Return status after the call. The status can
111 -- be FND_API.G_RET_STS_SUCCESS (success),
112 -- FND_API.G_RET_STS_ERROR (error),
113 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
114 --
115 -- NOTES
116 --
117 -- MODIFICATION HISTORY
118 --
119 -- 07-23-2001 Indrajit Sen o Created.
120 --
121 --
122
123 PROCEDURE validate_group(
124 p_create_update_flag IN VARCHAR2,
125 p_group_rec IN HZ_PARTY_V2PUB.GROUP_REC_TYPE,
126 p_old_group_rec IN HZ_PARTY_V2PUB.GROUP_REC_TYPE,
127 x_return_status IN OUT NOCOPY VARCHAR2
128 );
129
130 --
131 -- PROCEDURE validate_organization
132 --
133 -- DESCRIPTION
134 -- Validates organization record. Checks for
135 -- uniqueness
136 -- lookup types
137 -- mandatory columns
138 -- non-updateable fields
139 -- foreign key validations
140 -- other validations
141 --
142 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
143 --
144 -- ARGUMENTS
145 -- IN:
146 -- p_create_update_flag Create update flag. 'C' = create. 'U' = update.
147 -- p_organization_rec Organization record.
148 -- p_old_organization_rec Old organization record.
149 -- IN/OUT:
150 -- x_return_status Return status after the call. The status can
151 -- be FND_API.G_RET_STS_SUCCESS (success),
152 -- FND_API.G_RET_STS_ERROR (error),
153 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
154 --
155 -- NOTES
156 --
157 -- MODIFICATION HISTORY
158 --
159 -- 07-23-2001 Indrajit Sen o Created.
160 --
161 --
162
163 PROCEDURE validate_organization(
164 p_create_update_flag IN VARCHAR2,
165 p_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
166 p_old_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
167 x_return_status IN OUT NOCOPY VARCHAR2
168 );
169
170 --
171 -- PROCEDURE validate_party_site
172 --
173 -- DESCRIPTION
174 -- Validates party site record. Checks for
175 -- uniqueness
176 -- lookup types
177 -- mandatory columns
178 -- non-updateable fields
179 -- foreign key validations
180 -- other validations
181 --
182 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
183 --
184 -- ARGUMENTS
185 -- IN:
186 -- p_create_update_flag Create update flag. 'C' = create. 'U' = update.
187 -- p_party_site_rec Party site record.
188 -- p_rowid Rowid of the record (used only in update mode).
189 -- IN/OUT:
190 -- x_return_status Return status after the call. The status can
191 -- be FND_API.G_RET_STS_SUCCESS (success),
192 -- FND_API.G_RET_STS_ERROR (error),
193 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
194 --
195 -- NOTES
196 --
197 -- MODIFICATION HISTORY
198 --
199 -- 07-23-2001 Indrajit Sen o Created.
200 --
201 --
202
203 PROCEDURE validate_party_site(
204 p_create_update_flag IN VARCHAR2,
205 p_party_site_rec IN HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE,
206 p_rowid IN ROWID,
207 x_return_status IN OUT NOCOPY VARCHAR2,
208 x_loc_actual_content_source OUT NOCOPY VARCHAR2
209 );
210
211 --
212 -- PROCEDURE validate_party_site_use
213 --
214 -- DESCRIPTION
215 -- Validates party site use record. Checks for
216 -- uniqueness
217 -- lookup types
218 -- mandatory columns
219 -- non-updateable fields
220 -- foreign key validations
221 -- other validations
222 --
223 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
224 --
225 -- ARGUMENTS
226 -- IN:
227 -- p_create_update_flag Create update flag. 'C' = create. 'U' = update.
228 -- p_party_site_use_rec Party site use record.
229 -- p_rowid Rowid of the record (used only in update mode).
230 -- IN/OUT:
231 -- x_return_status Return status after the call. The status can
232 -- be FND_API.G_RET_STS_SUCCESS (success),
233 -- FND_API.G_RET_STS_ERROR (error),
234 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
235 --
236 -- NOTES
237 --
238 -- MODIFICATION HISTORY
239 --
240 -- 07-23-2001 Indrajit Sen o Created.
241 --
242 --
243
244 PROCEDURE validate_party_site_use(
245 p_create_update_flag IN VARCHAR2,
246 p_party_site_use_rec IN HZ_PARTY_SITE_V2PUB.party_site_use_rec_type,
247 p_rowid IN ROWID,
248 x_return_status IN OUT NOCOPY VARCHAR2
249 );
250
251 --
252 -- PROCEDURE validate_org_contact
253 --
254 -- DESCRIPTION
255 -- Validates org contact record. Checks for
256 -- uniqueness
257 -- lookup types
258 -- mandatory columns
259 -- non-updateable fields
260 -- foreign key validations
261 -- other validations
262 --
263 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
264 --
265 -- ARGUMENTS
266 -- IN:
267 -- p_create_update_flag Create update flag. 'C' = create. 'U' = update.
268 -- p_org_contact_rec Org contact record.
269 -- p_rowid Rowid of the record (used only in update mode).
270 -- IN/OUT:
271 -- x_return_status Return status after the call. The status can
272 -- be FND_API.G_RET_STS_SUCCESS (success),
273 -- FND_API.G_RET_STS_ERROR (error),
274 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
275 --
276 -- NOTES
277 --
278 -- MODIFICATION HISTORY
279 --
280 -- 07-23-2001 Indrajit Sen o Created.
281 --
282 --
283
284 PROCEDURE validate_org_contact(
285 p_create_update_flag IN VARCHAR2,
286 p_org_contact_rec IN HZ_PARTY_CONTACT_V2PUB.org_contact_rec_type,
287 p_rowid IN ROWID,
288 x_return_status IN OUT NOCOPY VARCHAR2
289 );
290
291 --
292 -- PROCEDURE validate_org_contact_role
293 --
294 -- DESCRIPTION
295 -- Validates org contact role record. Checks for
296 -- uniqueness
297 -- lookup types
298 -- mandatory columns
299 -- non-updateable fields
300 -- foreign key validations
301 -- other validations
302 --
303 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
304 --
305 -- ARGUMENTS
306 -- IN:
307 -- p_create_update_flag Create update flag. 'C' = create. 'U' = update.
308 -- p_org_contact_role_rec Org contact role record.
309 -- p_rowid Rowid of the record (used only in update mode).
310 -- IN/OUT:
311 -- x_return_status Return status after the call. The status can
312 -- be FND_API.G_RET_STS_SUCCESS (success),
313 -- FND_API.G_RET_STS_ERROR (error),
314 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
315 --
316 -- NOTES
317 --
318 -- MODIFICATION HISTORY
319 --
320 -- 07-23-2001 Indrajit Sen o Created.
321 --
322 --
323
324 PROCEDURE validate_org_contact_role(
325 p_create_update_flag IN VARCHAR2,
326 p_org_contact_role_rec IN HZ_PARTY_CONTACT_V2PUB.org_contact_role_rec_type,
327 p_rowid IN ROWID,
328 x_return_status IN OUT NOCOPY VARCHAR2
329 );
330
331 --
332 -- PROCEDURE validate_person_language
333 --
334 -- DESCRIPTION
335 -- Validates person language record. Checks for
336 -- uniqueness
337 -- lookup types
338 -- mandatory columns
339 -- non-updateable fields
340 -- foreign key validations
341 -- other validations
342 --
343 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
344 --
345 -- ARGUMENTS
346 -- IN:
347 -- p_create_update_flag Create update flag. 'C' = create. 'U' = update.
348 -- p_person_language_rec Person language record.
349 -- p_rowid Rowid of the record (used only in update mode).
350 -- IN/OUT:
351 -- x_return_status Return status after the call. The status can
352 -- be FND_API.G_RET_STS_SUCCESS (success),
353 -- FND_API.G_RET_STS_ERROR (error),
354 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error)
355 --
356 -- NOTES
357 --
358 -- MODIFICATION HISTORY
359 --
360 -- 07-23-2001 Indrajit Sen o Created.
361 --
362 --
363
364 PROCEDURE validate_person_language(
365 p_create_update_flag IN VARCHAR2,
366 p_person_language_rec IN hz_person_info_v2pub.person_language_rec_type,
367 p_rowid IN ROWID DEFAULT NULL,
368 x_return_status IN OUT NOCOPY VARCHAR2
369 );
370
371 --
372 -- PROCEDURE validate_location
373 --
374 -- DESCRIPTION
375 -- Validates location record. Checks for
376 -- uniqueness
377 -- lookup types
378 -- mandatory columns
379 -- non-updateable fields
380 -- foreign key validations
381 -- other validations
382 --
383 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
384 --
385 -- ARGUMENTS
386 -- IN:
387 -- p_create_update_flag Create update flag. 'C' = create. 'U' = update.
388 -- p_location_rec Location record.
389 -- p_rowid Rowid of the record (used only in update mode).
390 -- IN/OUT:
391 -- x_return_status Return status after the call. The status can
392 -- be FND_API.G_RET_STS_SUCCESS (success),
393 -- FND_API.G_RET_STS_ERROR (error),
394 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
395 --
396 -- NOTES
397 --
398 -- MODIFICATION HISTORY
399 --
400 -- 07-23-2001 Indrajit Sen o Created.
401 --
402 --
403
404 PROCEDURE validate_location(
405 p_create_update_flag IN VARCHAR2,
406 p_location_rec IN hz_location_v2pub.location_rec_type,
407 p_rowid IN ROWID DEFAULT NULL,
408 x_return_status IN OUT NOCOPY VARCHAR2
409 );
410
411 --
412 -- PROCEDURE validate_relationship_type
413 --
414 -- DESCRIPTION
415 -- Validates relationship type record. Checks for
416 -- uniqueness
417 -- lookup types
418 -- mandatory columns
419 -- non-updateable fields
420 -- foreign key validations
421 -- other validations
422 --
423 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
424 --
425 -- ARGUMENTS
426 -- IN:
427 -- p_create_update_flag Create update flag. 'C' = create. 'U' = update.
428 -- p_relationship_type_rec relationship type record.
429 -- p_rowid Rowid of the record (used only in update mode).
430 -- IN/OUT:
431 -- x_return_status Return status after the call. The status can
432 -- be FND_API.G_RET_STS_SUCCESS (success),
433 -- FND_API.G_RET_STS_ERROR (error),
434 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
435 --
436 -- NOTES
437 --
438 -- MODIFICATION HISTORY
439 --
440 -- 07-23-2001 Indrajit Sen o Created.
441 --
442 --
443
444 PROCEDURE validate_relationship_type(
445 p_create_update_flag IN VARCHAR2,
446 p_relationship_type_rec IN hz_relationship_type_v2pub.relationship_type_rec_type,
447 p_rowid IN ROWID DEFAULT NULL,
448 x_return_status IN OUT NOCOPY VARCHAR2
449 );
450
451 --
452 -- PROCEDURE validate_relationship
453 --
454 -- DESCRIPTION
455 -- Validates relationship record. Checks for
456 -- uniqueness
457 -- lookup types
458 -- mandatory columns
459 -- non-updateable fields
460 -- foreign key validations
461 -- other validations
462 --
463 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
464 --
465 -- ARGUMENTS
466 -- IN:
467 -- p_create_update_flag Create update flag. 'C' = create. 'U' = update.
468 -- p_relationship_rec Relationship record.
469 -- p_rowid Rowid of the record (used only in update mode).
470 -- IN/OUT:
471 -- x_return_status Return status after the call. The status can
472 -- be FND_API.G_RET_STS_SUCCESS (success),
473 -- FND_API.G_RET_STS_ERROR (error),
474 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
475 --
476 -- NOTES
477 --
478 -- MODIFICATION HISTORY
479 --
480 -- 07-23-2001 Indrajit Sen o Created.
481 --
482 --
483
484 PROCEDURE validate_relationship(
485 p_create_update_flag IN VARCHAR2,
486 p_relationship_rec IN hz_relationship_v2pub.relationship_rec_type,
487 p_rowid IN ROWID DEFAULT NULL,
488 x_return_status IN OUT NOCOPY VARCHAR2
489 );
490
491 --
492 -- PROCEDURE validate_contact_point
493 --
494 -- DESCRIPTION
495 -- Validates contact point record. Kept for backward compatibility.
496 --
497 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
498 --
499 -- ARGUMENTS
500 -- IN:
501 -- p_create_update_flag Create update flag. 'C' = create. 'U' = update.
502 -- p_contact_point_rec Contact point record.
503 -- p_edi_rec EDI record.
504 -- p_email_rec Email record.
505 -- p_phone_rec Phone record.
506 -- p_telex_rec Telex record.
507 -- p_web_rec Web record.
508 -- p_rowid Rowid of the record (used only in update mode).
509 -- IN/OUT:
510 -- x_return_status Return status after the call. The status can
511 -- be FND_API.G_RET_STS_SUCCESS (success),
512 -- FND_API.G_RET_STS_ERROR (error),
513 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
514 --
515 -- NOTES
516 --
517 -- MODIFICATION HISTORY
518 --
519 -- 07-23-2001 Jianying Huang o Created.
520 -- 20-NOV-2001 Joe del Callar Bug 2116225: Modified to accept EFT
521 -- records for bank consolidation.
522 -- Bug 2117973: Modified to comply with
523 -- PL/SQL coding standards.
524 --
525
526 PROCEDURE validate_contact_point (
527 p_create_update_flag IN VARCHAR2,
528 p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
529 p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := hz_contact_point_v2pub.g_miss_edi_rec,
530 p_email_rec IN hz_contact_point_v2pub.email_rec_type := hz_contact_point_v2pub.g_miss_email_rec,
531 p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := hz_contact_point_v2pub.g_miss_phone_rec,
532 p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := hz_contact_point_v2pub.g_miss_telex_rec,
533 p_web_rec IN hz_contact_point_v2pub.web_rec_type := hz_contact_point_v2pub.g_miss_web_rec,
534 p_rowid IN ROWID,
535 x_return_status IN OUT NOCOPY VARCHAR2
536 );
537
538 --
539 -- DESCRIPTION
540 -- Validates an EDI contact point record.
541 --
542 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
543 --
544 -- ARGUMENTS
545 -- IN:
546 -- p_create_update_flag Create update flag. 'C' = create. 'U' = update.
547 -- p_contact_point_rec Contact point record.
548 -- p_edi_rec EDI record.
549 -- p_rowid Rowid of the record (used only in update mode).
550 -- IN/OUT:
551 -- x_return_status Return status after the call. The status can
552 -- be FND_API.G_RET_STS_SUCCESS (success),
553 -- fnd_api.g_ret_sts_error (error),
554 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
555 --
556 -- NOTES
557 --
558 -- MODIFICATION HISTORY
559 -- 05-DEC-2001 Joe del Callar Bug 2136283: Created to improve
560 -- backward compatibility.
561 --
562 PROCEDURE validate_edi_contact_point (
563 p_create_update_flag IN VARCHAR2,
564 p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
565 p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := hz_contact_point_v2pub.g_miss_edi_rec,
566 p_rowid IN ROWID,
567 x_return_status IN OUT NOCOPY VARCHAR2
568 );
569
570 --
571 -- DESCRIPTION
572 -- Validates an EFT contact point record.
573 --
574 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
575 --
576 -- ARGUMENTS
577 -- IN:
578 -- p_create_update_flag Create update flag. 'C' = create. 'U' = update.
579 -- p_contact_point_rec Contact point record.
580 -- p_eft_rec EFT record.
581 -- p_rowid Rowid of the record (used only in update mode).
582 -- IN/OUT:
583 -- x_return_status Return status after the call. The status can
584 -- be FND_API.G_RET_STS_SUCCESS (success),
585 -- fnd_api.g_ret_sts_error (error),
586 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
587 --
588 -- NOTES
589 --
590 -- MODIFICATION HISTORY
591 -- 05-DEC-2001 Joe del Callar Bug 2136283: Created to improve
592 -- backward compatibility.
593 --
594 PROCEDURE validate_eft_contact_point (
595 p_create_update_flag IN VARCHAR2,
596 p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
597 p_eft_rec IN hz_contact_point_v2pub.eft_rec_type := hz_contact_point_v2pub.g_miss_eft_rec,
598 p_rowid IN ROWID,
599 x_return_status IN OUT NOCOPY VARCHAR2
600 );
601
602 --
603 -- DESCRIPTION
604 -- Validates an Web contact point record.
605 --
606 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
607 --
608 -- ARGUMENTS
609 -- IN:
610 -- p_create_update_flag Create update flag. 'C' = create. 'U' = update.
611 -- p_contact_point_rec Contact point record.
612 -- p_web_rec Web record.
613 -- p_rowid Rowid of the record (used only in update mode).
614 -- IN/OUT:
615 -- x_return_status Return status after the call. The status can
616 -- be FND_API.G_RET_STS_SUCCESS (success),
617 -- fnd_api.g_ret_sts_error (error),
618 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
619 --
620 -- NOTES
621 --
622 -- MODIFICATION HISTORY
623 -- 05-DEC-2001 Joe del Callar Bug 2136283: Created to improve
624 -- backward compatibility.
625 --
626 PROCEDURE validate_web_contact_point (
627 p_create_update_flag IN VARCHAR2,
628 p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
629 p_web_rec IN hz_contact_point_v2pub.web_rec_type := hz_contact_point_v2pub.g_miss_web_rec,
630 p_rowid IN ROWID,
631 x_return_status IN OUT NOCOPY VARCHAR2
632 );
633
634 --
635 -- DESCRIPTION
636 -- Validates an Phone contact point record.
637 --
638 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
639 --
640 -- ARGUMENTS
641 -- IN:
642 -- p_create_update_flag Create update flag. 'C' = create. 'U' = update.
643 -- p_contact_point_rec Contact point record.
644 -- p_phone_rec Phone record.
645 -- p_rowid Rowid of the record (used only in update mode).
646 -- IN/OUT:
647 -- x_return_status Return status after the call. The status can
648 -- be FND_API.G_RET_STS_SUCCESS (success),
649 -- fnd_api.g_ret_sts_error (error),
650 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
651 --
652 -- NOTES
653 --
654 -- MODIFICATION HISTORY
655 -- 05-DEC-2001 Joe del Callar Bug 2136283: Created to improve
656 -- backward compatibility.
657 --
658 PROCEDURE validate_phone_contact_point (
659 p_create_update_flag IN VARCHAR2,
660 p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
661 p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := hz_contact_point_v2pub.g_miss_phone_rec,
662 p_rowid IN ROWID,
663 x_return_status IN OUT NOCOPY VARCHAR2
664 );
665
666 --
667 -- DESCRIPTION
668 -- Validates an Telex contact point record.
669 --
670 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
671 --
672 -- ARGUMENTS
673 -- IN:
674 -- p_create_update_flag Create update flag. 'C' = create. 'U' = update.
675 -- p_contact_point_rec Contact point record.
676 -- p_telex_rec Telex record.
677 -- p_rowid Rowid of the record (used only in update mode).
678 -- IN/OUT:
679 -- x_return_status Return status after the call. The status can
680 -- be FND_API.G_RET_STS_SUCCESS (success),
681 -- fnd_api.g_ret_sts_error (error),
682 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
683 --
684 -- NOTES
685 --
686 -- MODIFICATION HISTORY
687 -- 05-DEC-2001 Joe del Callar Bug 2136283: Created to improve
688 -- backward compatibility.
689 --
690 PROCEDURE validate_telex_contact_point (
691 p_create_update_flag IN VARCHAR2,
692 p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
693 p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := hz_contact_point_v2pub.g_miss_telex_rec,
694 p_rowid IN ROWID,
695 x_return_status IN OUT NOCOPY VARCHAR2
696 );
697
698 --
699 -- DESCRIPTION
700 -- Validates an Email contact point record.
701 --
702 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
703 --
704 -- ARGUMENTS
705 -- IN:
706 -- p_create_update_flag Create update flag. 'C' = create. 'U' = update.
707 -- p_contact_point_rec Contact point record.
708 -- p_email_rec Email record.
709 -- p_rowid Rowid of the record (used only in update mode).
710 -- IN/OUT:
711 -- x_return_status Return status after the call. The status can
712 -- be FND_API.G_RET_STS_SUCCESS (success),
713 -- fnd_api.g_ret_sts_error (error),
714 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
715 --
716 -- NOTES
717 --
718 -- MODIFICATION HISTORY
719 -- 05-DEC-2001 Joe del Callar Bug 2136283: Created to improve
720 -- backward compatibility.
721 --
722 PROCEDURE validate_email_contact_point (
723 p_create_update_flag IN VARCHAR2,
724 p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
725 p_email_rec IN hz_contact_point_v2pub.email_rec_type := hz_contact_point_v2pub.g_miss_email_rec,
726 p_rowid IN ROWID,
727 x_return_status IN OUT NOCOPY VARCHAR2
728 );
729
730 --
731 -- DESCRIPTION
732 -- Validates nonsupported columns in Organization Profile
733 --
734 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
735 --
736 -- ARGUMENTS
737 -- p_create_update_flag Create update flag. 'C' = create. 'U' = update.
738 -- p_organization_rec Organization record.
739 -- IN/OUT:
740 -- x_return_status Return status after the call. The status can
741 -- be FND_API.G_RET_STS_SUCCESS (success),
742 -- FND_API.G_RET_STS_ERROR (error),
743 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
744 --
745 -- NOTES
746 --
747 -- MODIFICATION HISTORY
748 --
749 -- 01-25-2002 Kate Shan o Created.
750
751 PROCEDURE validate_org_nonsupport_column (
752 p_create_update_flag IN VARCHAR2,
753 p_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
754 x_return_status IN OUT NOCOPY VARCHAR2
755 );
756
757
758 --Made tax_location_validation a public procedure as it needs to be called by the DNB code.
759
760 PROCEDURE tax_location_validation(
761 p_location_rec IN hz_location_v2pub.location_rec_type,
762 p_create_update_flag IN VARCHAR2,
763 x_return_status IN OUT NOCOPY VARCHAR2
764 );
765
766 PROCEDURE validate_financial_report(
767 p_create_update_flag IN VARCHAR2,
768 p_financial_report_rec IN HZ_ORGANIZATION_INFO_V2PUB.FINANCIAL_REPORT_REC_TYPE,
769 p_rowid IN ROWID,
770 x_return_status IN OUT NOCOPY VARCHAR2
771 );
772
773 --bug 3942332:added out parameter x_actual_content_source
774 PROCEDURE validate_financial_number(
775 p_create_update_flag IN VARCHAR2,
776 p_financial_number_rec IN HZ_ORGANIZATION_INFO_V2PUB.FINANCIAL_NUMBER_REC_TYPE,
777 p_rowid IN ROWID,
778 x_return_status IN OUT NOCOPY VARCHAR2,
779 x_actual_content_source OUT NOCOPY VARCHAR2
780 );
781
782 PROCEDURE validate_credit_rating(
783 p_create_update_flag IN VARCHAR2,
784 p_credit_rating_rec IN HZ_PARTY_INFO_V2PUB.CREDIT_RATING_REC_TYPE,
785 p_rowid IN ROWID,
786 x_return_status IN OUT NOCOPY VARCHAR2
787 );
788
789 --
790 -- PROCEDURE validate_citizenship
791 --
792 -- DESCRIPTION
793 -- Validates citizenship record. Checks for
794 -- uniqueness
795 -- lookup types
796 -- mandatory columns
797 -- non-updateable fields
798 -- foreign key validations
799 -- other validations
800 --
801 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
802 --
803 -- ARGUMENTS
804 -- IN:
805 -- p_create_update_flag Create update flag. 'C' = create. 'U' = update.
806 -- p_citizenship_rec Citizenship record.
807 -- p_rowid Rowid of the record (used only in update mode).
808 -- IN/OUT:
809 -- x_return_status Return status after the call. The status can
810 -- be FND_API.G_RET_STS_SUCCESS (success),
811 -- FND_API.G_RET_STS_ERROR (error),
812 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
813 --
814 -- NOTES
815 --
816 -- MODIFICATION HISTORY
817 --
818 -- 31-Jan-2003 Porkodi C o Created.
819 --
820 --
821
822 PROCEDURE validate_citizenship(
823 p_create_update_flag IN VARCHAR2,
824 p_citizenship_rec IN HZ_PERSON_INFO_V2PUB.CITIZENSHIP_REC_TYPE,
825 p_rowid IN ROWID DEFAULT NULL,
826 x_return_status IN OUT NOCOPY VARCHAR2
827 );
828
829
830 --
831 -- PROCEDURE validate_education
832 --
833 -- DESCRIPTION
834 -- Validates education record. Checks for
835 -- uniqueness
836 -- lookup types
837 -- mandatory columns
838 -- non-updateable fields
839 -- foreign key validations
840 -- other validations
841 --
842 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
843 --
844 -- ARGUMENTS
845 -- IN:
846 -- p_create_update_flag Create update flag. 'C' = create. 'U' = update.
847 -- p_education_rec Education record.
848 -- p_rowid Rowid of the record (used only in update mode).
849 -- IN/OUT:
850 -- x_return_status Return status after the call. The status can
851 -- be FND_API.G_RET_STS_SUCCESS (success),
852 -- FND_API.G_RET_STS_ERROR (error),
853 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
854 --
855 -- NOTES
856 --
857 -- MODIFICATION HISTORY
858 --
859 -- 31-Jan-2003 Porkodi C o Created.
860 --
861 --
862
863 PROCEDURE validate_education(
864 p_create_update_flag IN VARCHAR2,
865 p_education_rec IN HZ_PERSON_INFO_V2PUB.EDUCATION_REC_TYPE,
866 p_rowid IN ROWID DEFAULT NULL,
867 x_return_status IN OUT NOCOPY VARCHAR2
868 );
869
870
871 --
872 -- PROCEDURE validate_employment_history
873 --
874 -- DESCRIPTION
875 -- Validates employment history record. Checks for
876 -- uniqueness
877 -- lookup types
878 -- mandatory columns
879 -- non-updateable fields
880 -- foreign key validations
881 -- other validations
882 --
883 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
884 --
885 -- ARGUMENTS
886 -- IN:
887 -- p_create_update_flag Create update flag. 'C' = create. 'U' = update.
888 -- p_employment_history_rec Employment history record.
889 -- p_rowid Rowid of the record (used only in update mode).
890 -- IN/OUT:
891 -- x_return_status Return status after the call. The status can
892 -- be FND_API.G_RET_STS_SUCCESS (success),
893 -- FND_API.G_RET_STS_ERROR (error),
894 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
895 --
896 -- NOTES
897 --
898 -- MODIFICATION HISTORY
899 --
900 -- 31-Jan-2003 Porkodi C o Created.
901 --
902 --
903
904 PROCEDURE validate_employment_history(
905 p_create_update_flag IN VARCHAR2,
906 p_employment_history_rec IN HZ_PERSON_INFO_V2PUB.EMPLOYMENT_HISTORY_REC_TYPE,
907 p_rowid IN ROWID DEFAULT NULL,
908 x_return_status IN OUT NOCOPY VARCHAR2
909 );
910
911 --
912 -- PROCEDURE validate_work_class
913 --
914 -- DESCRIPTION
915 -- Validates work class record. Checks for
916 -- uniqueness
917 -- mandatory columns
918 -- non-updateable fields
919 --
920 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
921 --
922 -- ARGUMENTS
923 -- IN:
924 -- p_create_update_flag Create update flag. 'C' = create. 'U' = update.
925 -- p_work_class_rec Work class record.
926 -- p_rowid Rowid of the record (used only in update mode).
927 -- IN/OUT:
928 -- x_return_status Return status after the call. The status can
929 -- be FND_API.G_RET_STS_SUCCESS (success),
930 -- FND_API.G_RET_STS_ERROR (error),
931 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
932 --
933 -- NOTES
934 --
935 -- MODIFICATION HISTORY
936 --
937 -- 02-Feb-2003 Porkodi C o Created.
938 --
939 --
940
941 PROCEDURE validate_work_class(
942 p_create_update_flag IN VARCHAR2,
943 p_work_class_rec IN HZ_PERSON_INFO_V2PUB.WORK_CLASS_REC_TYPE,
944 p_rowid IN ROWID DEFAULT NULL,
945 x_return_status IN OUT NOCOPY VARCHAR2
946 );
947
948
949 --
950 -- PROCEDURE validate_person_interest
951 --
952 -- DESCRIPTION
953 -- Validates work class record. Checks for
954 -- uniqueness
955 -- mandatory columns
956 -- non-updateable fields
957 --
958 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
959 --
960 -- ARGUMENTS
961 -- IN:
962 -- p_create_update_flag Create update flag. 'C' = create. 'U' = update.
963 -- p_person_interest_rec Work class record.
964 -- p_rowid Rowid of the record (used only in update mode).
965 -- IN/OUT:
966 -- x_return_status Return status after the call. The status can
967 -- be FND_API.G_RET_STS_SUCCESS (success),
968 -- FND_API.G_RET_STS_ERROR (error),
969 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
970 --
971 -- NOTES
972 --
973 -- MODIFICATION HISTORY
974 --
975 -- 02-Feb-2003 Porkodi C o Created.
976 --
977 --
978
979 PROCEDURE validate_person_interest(
980 p_create_update_flag IN VARCHAR2,
981 p_person_interest_rec IN HZ_PERSON_INFO_V2PUB.PERSON_INTEREST_REC_TYPE,
982 p_rowid IN ROWID DEFAULT NULL,
983 x_return_status IN OUT NOCOPY VARCHAR2
984 );
985
986
987
988 END hz_registry_validate_v2pub;