[Home] [Help]
PACKAGE: APPS.HZ_REGISTRY_VALIDATE_BO_PVT
Source
1 PACKAGE HZ_REGISTRY_VALIDATE_BO_PVT AS
2 /*$Header: ARHBRGVS.pls 120.6 2008/02/06 10:08:11 vsegu ship $ */
3
4 TYPE boc_tbl IS TABLE OF HZ_BUS_OBJ_DEFINITIONS.BUSINESS_OBJECT_CODE%TYPE;
5 TYPE cbc_tbl IS TABLE OF HZ_BUS_OBJ_DEFINITIONS.CHILD_BO_CODE%TYPE;
6 TYPE tmf_tbl IS TABLE OF HZ_BUS_OBJ_DEFINITIONS.TCA_MANDATED_FLAG%TYPE;
7 TYPE umf_tbl IS TABLE OF HZ_BUS_OBJ_DEFINITIONS.USER_MANDATED_FLAG%TYPE;
8 TYPE rnf_tbl IS TABLE OF HZ_BUS_OBJ_DEFINITIONS.ROOT_NODE_FLAG%TYPE;
9 TYPE ent_tbl IS TABLE OF HZ_BUS_OBJ_DEFINITIONS.ENTITY_NAME%TYPE;
10
11 TYPE completeness_rec_type IS RECORD(
12 business_object_code boc_tbl,
13 child_bo_code cbc_tbl,
14 tca_mandated_flag tmf_tbl,
15 user_mandated_flag umf_tbl,
16 root_node_flag rnf_tbl,
17 entity_name ent_tbl
18 );
19
20 -- PROCEDURE validate_parent_id
21 --
22 -- DESCRIPTION
23 -- Validates parent id of business object.
24 --
25 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
26 --
27 -- ARGUMENTS
28 -- IN:
29 -- px_parent_id Parent Id.
30 -- px_parent_os Parent original system.
31 -- px_parent_osr Parent original system reference.
32 -- p_person_obj_type Parent object type.
33 -- OUT:
34 -- x_return_status Return status after the call. The status can
35 -- be FND_API.G_RET_STS_SUCCESS (success),
36 -- FND_API.G_RET_STS_ERROR (error),
37 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
38 -- x_msg_count Return total number of message.
39 -- x_msg_data Return message content.
40 -- NOTES
41 --
42 -- MODIFICATION HISTORY
43 --
44 -- 13-Jul-2005 Arnold Ng o Created.
45
46 PROCEDURE validate_parent_id(
47 px_parent_id IN OUT NOCOPY NUMBER,
48 px_parent_os IN OUT NOCOPY VARCHAR2,
49 px_parent_osr IN OUT NOCOPY VARCHAR2,
50 p_parent_obj_type IN VARCHAR2,
51 x_return_status OUT NOCOPY VARCHAR2,
52 x_msg_count OUT NOCOPY NUMBER,
53 x_msg_data OUT NOCOPY VARCHAR2
54 );
55
56 -- PROCEDURE validate_ssm_id
57 --
58 -- DESCRIPTION
59 -- Validates Id, original system and original system reference of business object.
60 --
61 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
62 --
63 -- ARGUMENTS
64 -- IN:
65 -- px_id Id.
66 -- px_os Original system.
67 -- px_osr Original system reference.
68 -- p_org_id Org_Id for customer account site, customer account
69 -- site use and customer account relationship.
70 -- p_obj_type Business object type.
71 -- p_create_or_update Flag to indicate create or update.
72 -- OUT:
73 -- x_return_status Return status after the call. The status can
74 -- be FND_API.G_RET_STS_SUCCESS (success),
75 -- FND_API.G_RET_STS_ERROR (error),
76 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
77 -- x_msg_count Return total number of message.
78 -- x_msg_data Return message content.
79 -- NOTES
80 --
81 -- MODIFICATION HISTORY
82 --
83 -- 13-Jul-2005 Arnold Ng o Created.
84
85 PROCEDURE validate_ssm_id(
86 px_id IN OUT NOCOPY NUMBER,
87 px_os IN OUT NOCOPY VARCHAR2,
88 px_osr IN OUT NOCOPY VARCHAR2,
89 p_org_id IN NUMBER := NULL,
90 p_obj_type IN VARCHAR2,
91 p_create_or_update IN VARCHAR2,
92 x_return_status OUT NOCOPY VARCHAR2,
93 x_msg_count OUT NOCOPY NUMBER,
94 x_msg_data OUT NOCOPY VARCHAR2
95 );
96
97 -- PROCEDURE check_contact_pref_op
98 --
99 -- DESCRIPTION
100 -- Check the operation of contact preference based on pass in parameter.
101 --
102 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
103 --
104 -- ARGUMENTS
105 -- IN:
106 -- p_contact_level_table_id Contact level table Id.
107 -- p_contact_level_table Contact level table.
108 -- p_contact_type Contact preference type.
109 -- p_preference_code Contact preference code.
110 -- p_preference_start_date Contact preference start date.
111 -- p_preference_end_date Contact preference end date.
112 -- IN/OUT:
113 -- px_contact_pref_id Contact preference Id.
114 -- OUT:
115 -- x_object_version_number Object version number of contact preference.
116 -- NOTES
117 --
118 -- MODIFICATION HISTORY
119 --
120 -- 13-Jul-2005 Arnold Ng o Created.
121
122 PROCEDURE check_contact_pref_op(
123 p_contact_level_table_id IN NUMBER,
124 p_contact_level_table IN VARCHAR2,
125 px_contact_pref_id IN OUT NOCOPY NUMBER,
126 p_contact_type IN VARCHAR2,
127 p_preference_code IN VARCHAR2,
128 p_preference_start_date IN DATE,
129 p_preference_end_date IN DATE,
130 x_object_version_number OUT NOCOPY NUMBER
131 );
132
133 -- PROCEDURE check_language_op
134 --
135 -- DESCRIPTION
136 -- Check the operation of person language based on pass in parameter.
137 --
138 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
139 --
140 -- ARGUMENTS
141 -- IN:
142 -- p_party_id Party Id.
143 -- p_language_name Language name.
144 -- IN/OUT:
145 -- px_language_use_ref_id Language use reference Id.
146 -- OUT:
147 -- x_object_version_number Object version number of person language.
148 -- NOTES
149 --
150 -- MODIFICATION HISTORY
151 --
152 -- 13-Jul-2005 Arnold Ng o Created.
153
154 PROCEDURE check_language_op(
155 p_party_id IN NUMBER,
156 px_language_use_ref_id IN OUT NOCOPY NUMBER,
157 p_language_name IN VARCHAR2,
158 x_object_version_number OUT NOCOPY NUMBER
159 );
160
161 -- PROCEDURE check_education_op
162 --
163 -- DESCRIPTION
164 -- Check the operation of education based on pass in parameter.
165 --
166 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
167 --
168 -- ARGUMENTS
169 -- IN:
170 -- p_party_id Party Id.
171 -- p_course_major Course major.
172 -- p_school_attended_name Name of attended school.
173 -- p_degree_received Received degree.
174 -- IN/OUT:
175 -- px_education_id Education Id.
176 -- OUT:
177 -- x_object_version_number Object version number of education.
178 -- NOTES
179 --
180 -- MODIFICATION HISTORY
181 --
182 -- 13-Jul-2005 Arnold Ng o Created.
183
184 PROCEDURE check_education_op(
185 p_party_id IN NUMBER,
186 px_education_id IN OUT NOCOPY NUMBER,
187 p_course_major IN VARCHAR2,
188 p_school_attended_name IN VARCHAR2,
189 p_degree_received IN VARCHAR2,
190 x_object_version_number OUT NOCOPY NUMBER
191 );
192
193 -- PROCEDURE check_citizenship_op
194 --
195 -- DESCRIPTION
196 -- Check the operation of citizenship based on pass in parameter.
197 --
198 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
199 --
200 -- ARGUMENTS
201 -- IN:
202 -- p_party_id Party Id.
203 -- p_country_code Country code.
204 -- IN/OUT:
205 -- px_citizenship_id Citizenship Id.
206 -- OUT:
207 -- x_object_version_number Object version number of citizenship.
208 -- NOTES
209 --
210 -- MODIFICATION HISTORY
211 --
212 -- 13-Jul-2005 Arnold Ng o Created.
213
214 PROCEDURE check_citizenship_op(
215 p_party_id IN NUMBER,
216 px_citizenship_id IN OUT NOCOPY NUMBER,
217 p_country_code IN VARCHAR2,
218 x_object_version_number OUT NOCOPY NUMBER
219 );
220
221 -- PROCEDURE check_employ_hist_op
222 --
223 -- DESCRIPTION
224 -- Check the operation of employment history based on pass in parameter.
225 --
226 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
227 --
228 -- ARGUMENTS
229 -- IN:
230 -- p_party_id Party Id.
231 -- p_employed_by_name_company Name of company.
232 -- p_employed_as_title Job title.
233 -- p_begin_date Begin date.
234 -- IN/OUT:
235 -- px_emp_hist_id Employment history Id.
236 -- OUT:
237 -- x_object_version_number Object version number of employment history.
238 -- NOTES
239 --
240 -- MODIFICATION HISTORY
241 --
242 -- 13-Jul-2005 Arnold Ng o Created.
243
244 PROCEDURE check_employ_hist_op(
245 p_party_id IN NUMBER,
246 px_emp_hist_id IN OUT NOCOPY NUMBER,
247 p_employed_by_name_company IN VARCHAR2,
248 p_employed_as_title IN VARCHAR2,
249 p_begin_date IN DATE,
250 x_object_version_number OUT NOCOPY NUMBER
251 );
252
253 -- PROCEDURE check_work_class_op
254 --
255 -- DESCRIPTION
256 -- Check the operation of work class based on pass in parameter.
257 --
258 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
259 --
260 -- ARGUMENTS
261 -- IN:
262 -- p_party_id Party Id.
263 -- p_work_class_name Name of work class.
264 -- IN/OUT:
265 -- px_work_class_id Work class Id.
266 -- OUT:
267 -- x_object_version_number Object version number of work class.
268 -- NOTES
269 --
270 -- MODIFICATION HISTORY
271 --
272 -- 13-Jul-2005 Arnold Ng o Created.
273
274 PROCEDURE check_work_class_op(
275 p_employ_hist_id IN NUMBER,
276 px_work_class_id IN OUT NOCOPY NUMBER,
277 p_work_class_name IN VARCHAR2,
278 x_object_version_number OUT NOCOPY NUMBER
279 );
280
281 -- PROCEDURE check_interest_op
282 --
283 -- DESCRIPTION
284 -- Check the operation of person interest based on pass in parameter.
285 --
286 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
287 --
288 -- ARGUMENTS
289 -- IN:
290 -- p_party_id Party Id.
291 -- p_interest_type_code Interest type code.
292 -- p_sub_interest_type_code Sub-interest type code.
293 -- p_interest_name Name of interest.
294 -- IN/OUT:
295 -- px_interest_id Person interest Id.
296 -- OUT:
297 -- x_object_version_number Object version number of person interest.
298 -- NOTES
299 --
300 -- MODIFICATION HISTORY
301 --
302 -- 13-Jul-2005 Arnold Ng o Created.
303
304 PROCEDURE check_interest_op(
305 p_party_id IN NUMBER,
306 px_interest_id IN OUT NOCOPY NUMBER,
307 p_interest_type_code IN VARCHAR2,
308 p_sub_interest_type_code IN VARCHAR2,
309 p_interest_name IN VARCHAR2,
310 x_object_version_number OUT NOCOPY NUMBER
311 );
312
313 -- PROCEDURE check_party_site_use_op
314 --
315 -- DESCRIPTION
316 -- Check the operation of party site use based on pass in parameter.
317 --
318 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
319 --
320 -- ARGUMENTS
321 -- IN:
322 -- p_party_site_id Party site Id.
323 -- p_site_use_type Site use type.
324 -- IN/OUT:
325 -- px_party_site_use_id Party site use Id.
326 -- OUT:
327 -- x_object_version_number Object version number of party site use.
328 -- NOTES
329 --
330 -- MODIFICATION HISTORY
331 --
332 -- 13-Jul-2005 Arnold Ng o Created.
333
334 PROCEDURE check_party_site_use_op(
335 p_party_site_id IN NUMBER,
336 px_party_site_use_id IN OUT NOCOPY NUMBER,
337 p_site_use_type IN VARCHAR2,
338 x_object_version_number OUT NOCOPY NUMBER
339 );
340
341 -- PROCEDURE check_relationship_op
342 --
343 -- DESCRIPTION
344 -- Check the operation of relationship based on pass in parameter.
345 --
346 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
347 --
348 -- ARGUMENTS
349 -- IN:
350 -- p_subject_id Subject Id.
351 -- p_object_id Object Id.
352 -- p_relationship_type Relationship type.
353 -- p_relationship_code Relationship code.
354 -- IN/OUT:
355 -- px_relationship_id Relationship Id.
356 -- OUT:
357 -- x_object_version_number Object version number of relationship.
358 -- x_party_object_version_number Object version number of relationship party.
359 -- NOTES
360 --
361 -- MODIFICATION HISTORY
362 --
363 -- 13-Jul-2005 Arnold Ng o Created.
364
365 PROCEDURE check_relationship_op(
366 p_subject_id IN NUMBER,
367 p_object_id IN NUMBER,
368 px_relationship_id IN OUT NOCOPY NUMBER,
369 p_relationship_type IN VARCHAR2,
370 p_relationship_code IN VARCHAR2,
371 x_object_version_number OUT NOCOPY NUMBER,
372 x_party_obj_version_number OUT NOCOPY NUMBER
373 );
374
375 -- PROCEDURE check_org_contact_role_op
376 --
377 -- DESCRIPTION
378 -- Check the operation of org contact role based on pass in parameter.
379 --
380 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
381 --
382 -- ARGUMENTS
383 -- IN:
384 -- p_org_contact_id Org contact Id.
385 -- p_role_type Role type.
386 -- IN/OUT:
387 -- px_org_contact_role_id Org contact role Id.
388 -- OUT:
389 -- x_object_version_number Object version number of org contact role.
390 -- NOTES
391 --
392 -- MODIFICATION HISTORY
393 --
394 -- 13-Jul-2005 Arnold Ng o Created.
395
396 PROCEDURE check_org_contact_role_op(
397 p_org_contact_id IN NUMBER,
398 px_org_contact_role_id IN OUT NOCOPY NUMBER,
399 p_role_type IN VARCHAR2,
400 x_object_version_number OUT NOCOPY NUMBER
401 );
402
403 -- PROCEDURE check_certification_op
404 --
405 -- DESCRIPTION
406 -- Check the operation of certification based on pass in parameter.
407 --
408 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
409 --
410 -- ARGUMENTS
411 -- IN:
412 -- p_party_id Party Id.
413 -- p_certification_name Name of certification.
414 -- IN/OUT:
415 -- px_certification_id Certification Id.
416 -- OUT:
417 -- x_last_update_date Last update date of certification.
418 -- NOTES
419 --
420 -- MODIFICATION HISTORY
421 --
422 -- 13-Jul-2005 Arnold Ng o Created.
423
424 PROCEDURE check_certification_op(
425 p_party_id IN NUMBER,
426 px_certification_id IN OUT NOCOPY NUMBER,
427 p_certification_name IN VARCHAR2,
428 x_last_update_date OUT NOCOPY DATE,
432 -- PROCEDURE check_financial_prof_op
429 x_return_status OUT NOCOPY VARCHAR2
430 );
431
433 --
434 -- DESCRIPTION
435 -- Check the operation of financial profile based on pass in parameter.
436 --
437 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
438 --
439 -- ARGUMENTS
440 -- IN:
441 -- p_party_id Party Id.
442 -- p_financial_profile_id Financial profile Id.
443 -- OUT:
444 -- x_last_update_date Last update date of financial profile.
445 -- NOTES
446 --
447 -- MODIFICATION HISTORY
448 --
449 -- 13-Jul-2005 Arnold Ng o Created.
450
451 PROCEDURE check_financial_prof_op(
452 p_party_id IN NUMBER,
453 p_financial_profile_id IN NUMBER,
454 x_last_update_date OUT NOCOPY DATE,
455 x_return_status OUT NOCOPY VARCHAR2
456 );
457
458 -- PROCEDURE check_code_assign_op
459 --
460 -- DESCRIPTION
461 -- Check the operation of classification based on pass in parameter.
462 --
463 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
464 --
465 -- ARGUMENTS
466 -- IN:
467 -- p_owner_table_name Owner table name.
468 -- p_owner_table_id Owner table Id.
469 -- p_class_category Class category.
470 -- p_class_code Class code.
471 -- IN/OUT:
472 -- px_code_assignment_id Code assignment Id.
473 -- OUT:
474 -- x_object_version_number Object version number of classification.
475 -- NOTES
476 --
477 -- MODIFICATION HISTORY
478 --
479 -- 13-Jul-2005 Arnold Ng o Created.
480
481 PROCEDURE check_code_assign_op(
482 p_owner_table_name IN VARCHAR2,
483 p_owner_table_id IN NUMBER,
484 px_code_assignment_id IN OUT NOCOPY NUMBER,
485 p_class_category IN VARCHAR2,
486 p_class_code IN VARCHAR2,
487 x_object_version_number OUT NOCOPY NUMBER
488 );
489
490 -- PROCEDURE check_party_pref_op
491 --
492 -- DESCRIPTION
493 -- Check the operation of party preference based on pass in parameter.
494 --
495 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
496 --
497 -- ARGUMENTS
498 -- IN:
499 -- p_party_id Party Id.
500 -- p_module Module.
501 -- p_category Category.
502 -- p_preference_code Preference code.
503 -- OUT:
504 -- x_object_version_number Object version number of party preference.
505 -- NOTES
506 --
507 -- MODIFICATION HISTORY
508 --
509 -- 13-Jul-2005 Arnold Ng o Created.
510
511 PROCEDURE check_party_pref_op(
512 p_party_id IN NUMBER,
513 p_module IN VARCHAR2,
514 p_category IN VARCHAR2,
515 p_preference_code IN VARCHAR2,
516 x_object_version_number OUT NOCOPY NUMBER
517 );
518
519 -- PROCEDURE check_credit_rating_op
520 --
521 -- DESCRIPTION
522 -- Check the operation of credit rating based on pass in parameter.
523 --
524 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
525 --
526 -- ARGUMENTS
527 -- IN:
528 -- p_party_id Party Id.
529 -- p_rating_organization Rating organization.
530 -- p_rated_as_of_date Rated date.
531 -- IN/OUT:
532 -- px_credit_rating_id Credit rating Id.
533 -- OUT:
534 -- x_object_version_number Object version number of credit rating.
535 -- NOTES
536 --
537 -- MODIFICATION HISTORY
538 --
539 -- 13-Jul-2005 Arnold Ng o Created.
540
541 PROCEDURE check_credit_rating_op(
542 p_party_id IN NUMBER,
543 px_credit_rating_id IN OUT NOCOPY NUMBER,
544 p_rating_organization IN VARCHAR2,
545 p_rated_as_of_date IN DATE,
546 x_object_version_number OUT NOCOPY NUMBER
547 );
548
549 -- PROCEDURE check_fin_report_op
550 --
551 -- DESCRIPTION
552 -- Check the operation of financial report based on pass in parameter.
553 --
554 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
555 --
556 -- ARGUMENTS
557 -- IN:
558 -- p_party_id Party Id.
559 -- p_type_of_financial_report Type of financial report.
560 -- p_document_reference Document reference.
561 -- p_date_report_issued Report issued date.
562 -- p_issued_period Issued period.
563 -- IN/OUT:
564 -- px_fin_report_id Financial report Id.
565 -- OUT:
566 -- x_object_version_number Object version number of financial report.
567 -- NOTES
568 --
569 -- MODIFICATION HISTORY
570 --
571 -- 13-Jul-2005 Arnold Ng o Created.
572
573 PROCEDURE check_fin_report_op(
574 p_party_id IN NUMBER,
575 px_fin_report_id IN OUT NOCOPY NUMBER,
576 p_type_of_financial_report IN VARCHAR2,
577 p_document_reference IN VARCHAR2,
578 p_date_report_issued IN DATE,
579 p_issued_period IN VARCHAR2,
583 -- PROCEDURE check_fin_number_op
580 x_object_version_number OUT NOCOPY NUMBER
581 );
582
584 --
585 -- DESCRIPTION
586 -- Check the operation of financial number based on pass in parameter.
587 --
588 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
589 --
590 -- ARGUMENTS
591 -- IN:
592 -- p_fin_report_id Financial report Id.
593 -- p_financial_number_name Name of financial number.
594 -- IN/OUT:
595 -- px_fin_number_id Financial number Id.
596 -- OUT:
597 -- x_object_version_number Object version number of financial number.
598 -- NOTES
599 --
600 -- MODIFICATION HISTORY
601 --
602 -- 13-Jul-2005 Arnold Ng o Created.
603
604 PROCEDURE check_fin_number_op(
605 p_fin_report_id IN NUMBER,
606 px_fin_number_id IN OUT NOCOPY NUMBER,
607 p_financial_number_name IN VARCHAR2,
608 x_object_version_number OUT NOCOPY NUMBER
609 );
610
611 -- PROCEDURE check_role_resp_op
612 --
613 -- DESCRIPTION
614 -- Check the operation of role responsibility based on pass in parameter.
615 --
616 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
617 --
618 -- ARGUMENTS
619 -- IN:
620 -- p_cust_acct_contact_id Customer account contact Id.
621 -- p_responsibility_type Role responsibility type.
622 -- IN/OUT:
623 -- px_responsibility_id Role responsibility Id.
624 -- OUT:
625 -- x_object_version_number Object version number of role responsibility.
626 -- NOTES
627 --
628 -- MODIFICATION HISTORY
629 --
630 -- 13-Jul-2005 Arnold Ng o Created.
631
632 PROCEDURE check_role_resp_op(
633 p_cust_acct_contact_id IN NUMBER,
634 px_responsibility_id IN OUT NOCOPY NUMBER,
635 p_responsibility_type IN VARCHAR2,
636 x_object_version_number OUT NOCOPY NUMBER
637 );
638
639 -- PROCEDURE check_cust_profile_op
640 --
641 -- DESCRIPTION
642 -- Check the operation of customer profile based on pass in parameter.
643 --
644 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
645 --
646 -- ARGUMENTS
647 -- IN:
648 -- p_cust_acct_id Customer account Id.
649 -- p_site_use_id Customer site use Id.
650 -- p_profile_class_id Profile class Id.
651 -- IN/OUT:
652 -- px_cust_acct_profile_id Customer profile Id.
653 -- OUT:
654 -- x_object_version_number Object version number of customer profile.
655 -- NOTES
656 --
657 -- MODIFICATION HISTORY
658 --
659 -- 13-Jul-2005 Arnold Ng o Created.
660
661 PROCEDURE check_cust_profile_op(
662 p_cust_acct_id IN NUMBER,
663 px_cust_acct_profile_id IN OUT NOCOPY NUMBER,
664 p_site_use_id IN NUMBER,
665 p_profile_class_id IN NUMBER,
666 x_object_version_number OUT NOCOPY NUMBER
667 );
668
669 -- PROCEDURE check_cust_profile_amt_op
670 --
671 -- DESCRIPTION
672 -- Check the operation of customer profile amount based on pass in parameter.
673 --
674 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
675 --
676 -- ARGUMENTS
677 -- IN:
678 -- p_cust_profile_id Customer profile Id.
679 -- p_currency_code Currency code.
680 -- IN/OUT:
681 -- px_cust_acct_prof_amt_id Customer profile amount Id.
682 -- OUT:
683 -- x_object_version_number Object version number of customer profile amount.
684 -- NOTES
685 --
686 -- MODIFICATION HISTORY
687 --
688 -- 13-Jul-2005 Arnold Ng o Created.
689
690 PROCEDURE check_cust_profile_amt_op(
691 p_cust_profile_id IN NUMBER,
692 px_cust_acct_prof_amt_id IN OUT NOCOPY NUMBER,
693 p_currency_code IN VARCHAR2,
694 x_object_version_number OUT NOCOPY NUMBER
695 );
696
697 -- PROCEDURE check_cust_acct_relate_op
698 --
699 -- DESCRIPTION
700 -- Check the operation of customer account relationship based on pass in parameter.
701 --
702 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
703 --
704 -- ARGUMENTS
705 -- IN:
706 -- p_cust_acct_id Customer account Id.
707 -- p_related_cust_acct_id Related customer account Id.
708 -- OUT:
709 -- x_object_version_number Object version number of customer account relationship.
710 -- NOTES
711 --
712 -- MODIFICATION HISTORY
713 --
714 -- 13-Jul-2005 Arnold Ng o Created.
715
716 PROCEDURE check_cust_acct_relate_op(
717 p_cust_acct_id IN NUMBER,
718 p_related_cust_acct_id IN NUMBER,
719 x_object_version_number OUT NOCOPY NUMBER
720 );
721
722 -- PROCEDURE check_payment_method_op
723 --
724 -- DESCRIPTION
725 -- Check the operation of payment method based on pass in parameter.
726 --
727 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
728 --
729 -- ARGUMENTS
730 -- IN:
731 -- p_cust_receipt_method_id Payment method Id.
732 -- OUT:
733 -- x_last_update_date Last update date of payment method.
734 -- NOTES
735 --
739
736 -- MODIFICATION HISTORY
737 --
738 -- 13-Jul-2005 Arnold Ng o Created.
740 PROCEDURE check_payment_method_op(
741 p_cust_receipt_method_id IN NUMBER,
742 x_last_update_date OUT NOCOPY DATE
743 );
744
745 -- FUNCTION check_bo_op
746 --
747 -- DESCRIPTION
748 -- Return the operation of business object based on pass in parameter.
749 -- Return value can be 'C' (create) or 'U' (update)
750 --
751 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
752 --
753 -- ARGUMENTS
754 -- IN:
755 -- p_entity_id Business object Id.
756 -- p_entity_os Business object original system.
757 -- p_entity_osr Business object original system reference.
758 -- p_entity_type Business object type.
759 -- p_cp_type Contact point type.
760 -- NOTES
761 --
762 -- MODIFICATION HISTORY
763 --
764 -- 13-Jul-2005 Arnold Ng o Created.
765
766 FUNCTION check_bo_op(
767 p_entity_id IN NUMBER,
768 p_entity_os IN VARCHAR2,
769 p_entity_osr IN VARCHAR2,
770 p_entity_type IN VARCHAR2,
771 p_cp_type IN VARCHAR2 := NULL,
772 p_parent_id IN NUMBER,
773 p_parent_obj_type IN VARCHAR2
774 ) RETURN VARCHAR2;
775
776
777 -- PROCEDURE check_party_usage_op
778 --
779 -- DESCRIPTION
780 -- Checks if a row exists in party_usg_assigments table for agiven
781 -- party_id and party_usages_code.
782 -- If exists Return last_update_date value. otherwise null.
783 --
784 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
785 --
786 -- ARGUMENTS
787 -- IN:
788 -- p_party_id id of a party for whicch party_usage was created.
789 -- p_party_usage_code seeded usage code.
790 -- OUT:
791 -- x_last_update_date last_update_date column.
792 -- x_return_status status of the call
793 -- NOTES
794 --
795 -- MODIFICATION HISTORY
796 --
797 -- 01-Mar-2006 Hadi Alatasi o Created.
798
799 PROCEDURE check_party_usage_op(
800 p_party_id IN NUMBER,
801 p_party_usage_code IN VARCHAR2,
802 x_last_update_date OUT NOCOPY DATE,
803 x_return_status OUT NOCOPY VARCHAR2
804 );
805
806 -- FUNCTION get_owner_table_name
807 --
808 -- DESCRIPTION
809 -- Return the owner table name based on object type.
810 --
811 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
812 --
813 -- ARGUMENTS
814 -- IN:
815 -- p_obj_type Object type.
816 -- NOTES
817 --
818 -- MODIFICATION HISTORY
819 --
820 -- 13-Jul-2005 Arnold Ng o Created.
821
822 FUNCTION get_owner_table_name(
823 p_obj_type IN VARCHAR2
824 ) RETURN VARCHAR2;
825
826 -- FUNCTION get_parent_object_type
827 --
828 -- DESCRIPTION
829 -- Return the object type based on parent table and Id.
830 --
831 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
832 --
833 -- ARGUMENTS
834 -- IN:
835 -- p_parent_table_name Parent table name.
836 -- p_parent_id Parent Id.
837 -- NOTES
838 --
839 -- MODIFICATION HISTORY
840 --
841 -- 13-Jul-2005 Arnold Ng o Created.
842
843 FUNCTION get_parent_object_type(
844 p_parent_table_name IN VARCHAR2,
845 p_parent_id IN NUMBER
846 ) RETURN VARCHAR2;
847
848 -- FUNCTION is_cp_bo_comp
849 --
850 -- DESCRIPTION
851 -- Return true if contact point object is complete. Otherwise, return false.
852 --
853 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
854 --
855 -- ARGUMENTS
856 -- IN:
857 -- p_phone_objs List of phone business objects.
858 -- p_email_objs List of email business objects.
859 -- p_telex_objs List of telex business objects.
860 -- p_web_objs List of web business objects.
861 -- p_edi_objs List of edi business objects.
862 -- p_eft_objs List of eft business objects.
863 -- p_sms_objs List of sms business objects.
864 -- p_bus_object Business object structure for contact point.
865 -- NOTES
866 --
867 -- MODIFICATION HISTORY
868 --
869 -- 13-Jul-2005 Arnold Ng o Created.
870
871 FUNCTION is_cp_bo_comp(
872 p_phone_objs IN HZ_PHONE_CP_BO_TBL,
873 p_email_objs IN HZ_EMAIL_CP_BO_TBL,
874 p_telex_objs IN HZ_TELEX_CP_BO_TBL,
875 p_web_objs IN HZ_WEB_CP_BO_TBL,
876 p_edi_objs IN HZ_EDI_CP_BO_TBL,
877 p_eft_objs IN HZ_EFT_CP_BO_TBL,
878 p_sms_objs IN HZ_SMS_CP_BO_TBL,
879 p_bus_object IN COMPLETENESS_REC_TYPE
880 ) RETURN BOOLEAN;
881
882 -- FUNCTION is_ps_bo_comp
883 --
884 -- DESCRIPTION
885 -- Return true if party site object is complete. Otherwise, return false.
889 -- ARGUMENTS
886 --
887 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
888 --
890 -- IN:
891 -- p_ps_objs List of party site business objects.
892 -- p_bus_object Business object structure for party site.
893 -- NOTES
894 --
895 -- MODIFICATION HISTORY
896 --
897 -- 13-Jul-2005 Arnold Ng o Created.
898
899 FUNCTION is_ps_bo_comp(
900 p_ps_objs IN HZ_PARTY_SITE_BO_TBL,
901 p_bus_object IN COMPLETENESS_REC_TYPE
902 ) RETURN BOOLEAN;
903
904 -- FUNCTION is_person_bo_comp
905 --
906 -- DESCRIPTION
907 -- Return true if person object is complete. Otherwise, return false.
908 --
909 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
910 --
911 -- ARGUMENTS
912 -- IN:
913 -- p_person_obj Person business objects.
914 -- p_bus_object Business object structure for person.
915 -- NOTES
916 --
917 -- MODIFICATION HISTORY
918 --
919 -- 13-Jul-2005 Arnold Ng o Created.
920
921 FUNCTION is_person_bo_comp(
922 p_person_obj IN HZ_PERSON_BO,
923 p_bus_object IN COMPLETENESS_REC_TYPE
924 ) RETURN BOOLEAN;
925
926 -- FUNCTION is_org_bo_comp
927 --
928 -- DESCRIPTION
929 -- Return true if organization object is complete. Otherwise, return false.
930 --
931 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
932 --
933 -- ARGUMENTS
934 -- IN:
935 -- p_organization_obj Organization business objects.
936 -- p_bus_object Business object structure for organization.
937 -- NOTES
938 --
939 -- MODIFICATION HISTORY
940 --
941 -- 13-Jul-2005 Arnold Ng o Created.
942
943 FUNCTION is_org_bo_comp(
944 p_organization_obj IN HZ_ORGANIZATION_BO,
945 p_bus_object IN COMPLETENESS_REC_TYPE
946 ) RETURN BOOLEAN;
947
948 -- FUNCTION is_oc_bo_comp
949 --
950 -- DESCRIPTION
951 -- Return true if org contact object is complete. Otherwise, return false.
952 --
953 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
954 --
955 -- ARGUMENTS
956 -- IN:
957 -- p_oc_objs List of organization contact business objects.
958 -- p_bus_object Business object structure for organization contact.
959 -- NOTES
960 --
961 -- MODIFICATION HISTORY
962 --
963 -- 13-Jul-2005 Arnold Ng o Created.
964
965 FUNCTION is_oc_bo_comp(
966 p_oc_objs IN HZ_ORG_CONTACT_BO_TBL,
967 p_bus_object IN COMPLETENESS_REC_TYPE
968 ) RETURN BOOLEAN;
969
970 -- FUNCTION is_cac_bo_comp
971 --
972 -- DESCRIPTION
973 -- Return true if customer account contact object is complete.
974 -- Otherwise, return false.
975 --
976 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
977 --
978 -- ARGUMENTS
979 -- IN:
980 -- p_cac_objs List of customer account contact business objects.
981 -- p_bus_object Business object structure for customer account contact.
982 -- NOTES
983 --
984 -- MODIFICATION HISTORY
985 --
986 -- 13-Jul-2005 Arnold Ng o Created.
987
988 FUNCTION is_cac_bo_comp(
989 p_cac_objs IN HZ_CUST_ACCT_CONTACT_BO_TBL,
990 p_bus_object IN COMPLETENESS_REC_TYPE
991 ) RETURN BOOLEAN;
992
993 -- FUNCTION is_cas_bo_comp
994 --
995 -- DESCRIPTION
996 -- Return true if customer account site object is complete.
997 -- Otherwise, return false.
998 --
999 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1000 --
1001 -- ARGUMENTS
1002 -- IN:
1003 -- p_cas_objs List of customer account site business objects.
1004 -- p_bus_object Business object structure for customer account site.
1005 -- NOTES
1006 --
1007 -- MODIFICATION HISTORY
1008 --
1009 -- 13-Jul-2005 Arnold Ng o Created.
1010
1011 FUNCTION is_cas_bo_comp(
1012 p_cas_objs IN HZ_CUST_ACCT_SITE_BO_TBL,
1013 p_bus_object IN COMPLETENESS_REC_TYPE
1014 ) RETURN BOOLEAN;
1015
1016 -- FUNCTION is_ca_bo_comp
1017 --
1018 -- DESCRIPTION
1019 -- Return true if customer account object is complete. Otherwise, return false.
1020 --
1021 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1022 --
1023 -- ARGUMENTS
1024 -- IN:
1025 -- p_ca_objs List of customer account business objects.
1026 -- p_bus_object Business object structure for customer account.
1027 -- NOTES
1028 --
1029 -- MODIFICATION HISTORY
1030 --
1031 -- 13-Jul-2005 Arnold Ng o Created.
1032
1033 FUNCTION is_ca_bo_comp(
1034 p_ca_objs IN HZ_CUST_ACCT_BO_TBL,
1035 p_bus_object IN COMPLETENESS_REC_TYPE
1036 ) RETURN BOOLEAN;
1037
1038 -- FUNCTION is_pca_bo_comp
1039 --
1040 -- DESCRIPTION
1041 -- Return true if person customer object is complete. Otherwise, return false.
1042 --
1043 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1044 --
1048 -- p_ca_objs List of customer account objects.
1045 -- ARGUMENTS
1046 -- IN:
1047 -- p_person_obj Person business object.
1049 -- NOTES
1050 --
1051 -- MODIFICATION HISTORY
1052 --
1053 -- 13-Jul-2005 Arnold Ng o Created.
1054
1055 FUNCTION is_pca_bo_comp(
1056 p_person_obj IN HZ_PERSON_BO,
1057 p_ca_objs IN HZ_CUST_ACCT_BO_TBL
1058 ) RETURN BOOLEAN;
1059
1060 -- FUNCTION is_oca_bo_comp
1061 --
1062 -- DESCRIPTION
1063 -- Return true if organization customer object is complete.
1064 -- Otherwise, return false.
1065 --
1066 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1067 --
1068 -- ARGUMENTS
1069 -- IN:
1070 -- p_org_obj Organization business object.
1071 -- p_ca_objs List of customer account objects.
1072 -- NOTES
1073 --
1074 -- MODIFICATION HISTORY
1075 --
1076 -- 13-Jul-2005 Arnold Ng o Created.
1077
1078 FUNCTION is_oca_bo_comp(
1079 p_org_obj IN HZ_ORGANIZATION_BO,
1080 p_ca_objs IN HZ_CUST_ACCT_BO_TBL
1081 ) RETURN BOOLEAN;
1082
1083 -- FUNCTION get_bus_object_struct
1084 --
1085 -- DESCRIPTION
1086 -- Get contact point business object structure.
1087 --
1088 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1089 --
1090 -- ARGUMENTS
1091 -- IN:
1092 -- p_bus_object_code Business object code, such as 'PARTY_SITE',
1093 -- 'ORG_CONTACT'
1094 -- OUT:
1095 -- x_bus_object Business object structure.
1096 -- NOTES
1097 --
1098 -- MODIFICATION HISTORY
1099 --
1100 -- 13-Jul-2005 Arnold Ng o Created.
1101
1102 PROCEDURE get_bus_obj_struct(
1103 p_bus_object_code IN VARCHAR2,
1104 x_bus_object OUT NOCOPY COMPLETENESS_REC_TYPE
1105 );
1106
1107 -- FUNCTION get_cp_bus_obj_struct
1108 --
1109 -- DESCRIPTION
1110 -- Get contact point business object structure.
1111 --
1112 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1113 --
1114 -- ARGUMENTS
1115 -- IN:
1116 -- p_phone_code 'PHONE'.
1117 -- p_email_code 'EMAIL'.
1118 -- p_telex_code 'TLX'.
1119 -- p_web_code 'WEB'.
1120 -- p_edi_code 'EDI'.
1121 -- p_eft_code 'EFT'.
1122 -- p_sms_code 'SMS'.
1123 -- OUT:
1124 -- x_bus_object Contact point business object structure.
1125 -- NOTES
1126 --
1127 -- MODIFICATION HISTORY
1128 --
1129 -- 13-Jul-2005 Arnold Ng o Created.
1130
1131 PROCEDURE get_cp_bus_obj_struct(
1132 p_phone_code IN VARCHAR2,
1133 p_email_code IN VARCHAR2,
1134 p_telex_code IN VARCHAR2,
1135 p_web_code IN VARCHAR2,
1136 p_edi_code IN VARCHAR2,
1137 p_eft_code IN VARCHAR2,
1138 p_sms_code IN VARCHAR2,
1139 x_bus_object OUT NOCOPY COMPLETENESS_REC_TYPE
1140 );
1141
1142 -- FUNCTION get_id_from_ososr
1143 --
1144 -- DESCRIPTION
1145 -- Get TCA Id based on original system and original system reference.
1146 --
1147 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1148 --
1149 -- ARGUMENTS
1150 -- IN:
1151 -- p_os Original system
1152 -- p_osr Original system reference
1153 -- p_owner_table_name Owner table name
1154 -- NOTES
1155 --
1156 -- MODIFICATION HISTORY
1157 --
1158 -- 13-Jul-2005 Arnold Ng o Created.
1159
1160 FUNCTION get_id_from_ososr(
1161 p_os IN VARCHAR2,
1162 p_osr IN VARCHAR2,
1163 p_owner_table_name IN VARCHAR2
1164 ) RETURN NUMBER;
1165
1166 -- FUNCTION is_cas_v2_bo_comp
1167 --
1168 -- DESCRIPTION
1169 -- Return true if customer account site object is complete.
1170 -- Otherwise, return false.
1171 --
1172 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1173 --
1174 -- ARGUMENTS
1175 -- IN:
1176 -- p_cas_v2_objs List of customer account site business objects.
1177 -- p_bus_object Business object structure for customer account site.
1178 -- NOTES
1179 --
1180 -- MODIFICATION HISTORY
1181 --
1182 -- 1-FEB-2008 vsegu o Created.
1183
1184 FUNCTION is_cas_v2_bo_comp(
1185 p_cas_v2_objs IN HZ_CUST_ACCT_SITE_V2_BO_TBL,
1186 p_bus_object IN COMPLETENESS_REC_TYPE
1187 ) RETURN BOOLEAN;
1188
1189 -- FUNCTION is_ca_v2_bo_comp
1190 --
1191 -- DESCRIPTION
1192 -- Return true if customer account object is complete. Otherwise, return false.
1193 --
1194 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1195 --
1196 -- ARGUMENTS
1197 -- IN:
1198 -- p_ca_v2_objs List of customer account business objects.
1199 -- p_bus_object Business object structure for customer account.
1200 -- NOTES
1201 --
1202 -- MODIFICATION HISTORY
1203 --
1204 -- 1-FEB-2008 vsegu o Created.
1205
1206 FUNCTION is_ca_v2_bo_comp(
1207 p_ca_v2_objs IN HZ_CUST_ACCT_V2_BO_TBL,
1208 p_bus_object IN COMPLETENESS_REC_TYPE
1209 ) RETURN BOOLEAN;
1210
1211 -- FUNCTION is_pca_v2_bo_comp
1212 --
1213 -- DESCRIPTION
1214 -- Return true if person customer object is complete. Otherwise, return false.
1215 --
1216 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1217 --
1218 -- ARGUMENTS
1219 -- IN:
1220 -- p_person_obj Person business object.
1224 -- MODIFICATION HISTORY
1221 -- p_ca_v2_objs List of customer account objects.
1222 -- NOTES
1223 --
1225 --
1226 -- 1-Feb-2008 vsegu o Created.
1227
1228 FUNCTION is_pca_v2_bo_comp(
1229 p_person_obj IN HZ_PERSON_BO,
1230 p_ca_v2_objs IN HZ_CUST_ACCT_V2_BO_TBL
1231 ) RETURN BOOLEAN;
1232
1233 -- FUNCTION is_oca_v2_bo_comp
1234 --
1235 -- DESCRIPTION
1236 -- Return true if organization customer object is complete.
1237 -- Otherwise, return false.
1238 --
1239 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1240 --
1241 -- ARGUMENTS
1242 -- IN:
1243 -- p_org_obj Organization business object.
1244 -- p_ca_v2_objs List of customer account objects.
1245 -- NOTES
1246 --
1247 -- MODIFICATION HISTORY
1248 --
1249 -- 1-Feb-2008 vsegu o Created.
1250
1251 FUNCTION is_oca_v2_bo_comp(
1252 p_org_obj IN HZ_ORGANIZATION_BO,
1253 p_ca_v2_objs IN HZ_CUST_ACCT_V2_BO_TBL
1254 ) RETURN BOOLEAN;
1255
1256 END HZ_REGISTRY_VALIDATE_BO_PVT;