[Home] [Help]
PACKAGE: APPS.HZ_REGISTRY_VALIDATE_BO_PVT
Source
1 PACKAGE HZ_REGISTRY_VALIDATE_BO_PVT AUTHID CURRENT_USER AS
2 /*$Header: ARHBRGVS.pls 120.6.12010000.2 2009/06/25 22:10:55 awu 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
381 --
378 -- Check the operation of org contact role based on pass in parameter.
379 --
380 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
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,
429 x_return_status OUT NOCOPY VARCHAR2
430 );
431
432 -- PROCEDURE check_financial_prof_op
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:
535 -- NOTES
532 -- px_credit_rating_id Credit rating Id.
533 -- OUT:
534 -- x_object_version_number Object version number of credit rating.
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,
580 x_object_version_number OUT NOCOPY NUMBER
581 );
582
583 -- PROCEDURE check_fin_number_op
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:
686 -- MODIFICATION HISTORY
683 -- x_object_version_number Object version number of customer profile amount.
684 -- NOTES
685 --
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 p_org_id IN NUMBER,
720 x_object_version_number OUT NOCOPY NUMBER
721 );
722
723 -- PROCEDURE check_payment_method_op
724 --
725 -- DESCRIPTION
726 -- Check the operation of payment method based on pass in parameter.
727 --
728 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
729 --
730 -- ARGUMENTS
731 -- IN:
732 -- p_cust_receipt_method_id Payment method Id.
733 -- OUT:
734 -- x_last_update_date Last update date of payment method.
735 -- NOTES
736 --
737 -- MODIFICATION HISTORY
738 --
739 -- 13-Jul-2005 Arnold Ng o Created.
740
741 PROCEDURE check_payment_method_op(
742 p_cust_receipt_method_id IN NUMBER,
743 x_last_update_date OUT NOCOPY DATE
744 );
745
746 -- FUNCTION check_bo_op
747 --
748 -- DESCRIPTION
749 -- Return the operation of business object based on pass in parameter.
750 -- Return value can be 'C' (create) or 'U' (update)
751 --
752 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
753 --
754 -- ARGUMENTS
755 -- IN:
756 -- p_entity_id Business object Id.
757 -- p_entity_os Business object original system.
758 -- p_entity_osr Business object original system reference.
759 -- p_entity_type Business object type.
760 -- p_cp_type Contact point type.
761 -- NOTES
762 --
763 -- MODIFICATION HISTORY
764 --
765 -- 13-Jul-2005 Arnold Ng o Created.
766
767 FUNCTION check_bo_op(
768 p_entity_id IN NUMBER,
769 p_entity_os IN VARCHAR2,
770 p_entity_osr IN VARCHAR2,
771 p_entity_type IN VARCHAR2,
772 p_cp_type IN VARCHAR2 := NULL,
773 p_parent_id IN NUMBER,
774 p_parent_obj_type IN VARCHAR2
775 ) RETURN VARCHAR2;
776
777
778 -- PROCEDURE check_party_usage_op
779 --
780 -- DESCRIPTION
781 -- Checks if a row exists in party_usg_assigments table for agiven
782 -- party_id and party_usages_code.
783 -- If exists Return last_update_date value. otherwise null.
784 --
785 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
786 --
787 -- ARGUMENTS
788 -- IN:
789 -- p_party_id id of a party for whicch party_usage was created.
790 -- p_party_usage_code seeded usage code.
791 -- OUT:
792 -- x_last_update_date last_update_date column.
793 -- x_return_status status of the call
794 -- NOTES
795 --
796 -- MODIFICATION HISTORY
797 --
798 -- 01-Mar-2006 Hadi Alatasi o Created.
799
800 PROCEDURE check_party_usage_op(
801 p_party_id IN NUMBER,
802 p_party_usage_code IN VARCHAR2,
803 x_last_update_date OUT NOCOPY DATE,
804 x_return_status OUT NOCOPY VARCHAR2
805 );
806
807 -- FUNCTION get_owner_table_name
808 --
809 -- DESCRIPTION
810 -- Return the owner table name based on object type.
811 --
812 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
813 --
814 -- ARGUMENTS
815 -- IN:
816 -- p_obj_type Object type.
817 -- NOTES
818 --
819 -- MODIFICATION HISTORY
820 --
821 -- 13-Jul-2005 Arnold Ng o Created.
822
823 FUNCTION get_owner_table_name(
824 p_obj_type IN VARCHAR2
825 ) RETURN VARCHAR2;
826
827 -- FUNCTION get_parent_object_type
828 --
829 -- DESCRIPTION
830 -- Return the object type based on parent table and Id.
831 --
832 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
833 --
834 -- ARGUMENTS
835 -- IN:
836 -- p_parent_table_name Parent table name.
837 -- p_parent_id Parent Id.
838 -- NOTES
839 --
840 -- MODIFICATION HISTORY
841 --
845 p_parent_table_name IN VARCHAR2,
842 -- 13-Jul-2005 Arnold Ng o Created.
843
844 FUNCTION get_parent_object_type(
846 p_parent_id IN NUMBER
847 ) RETURN VARCHAR2;
848
849 -- FUNCTION is_cp_bo_comp
850 --
851 -- DESCRIPTION
852 -- Return true if contact point object is complete. Otherwise, return false.
853 --
854 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
855 --
856 -- ARGUMENTS
857 -- IN:
858 -- p_phone_objs List of phone business objects.
859 -- p_email_objs List of email business objects.
860 -- p_telex_objs List of telex business objects.
861 -- p_web_objs List of web business objects.
862 -- p_edi_objs List of edi business objects.
863 -- p_eft_objs List of eft business objects.
864 -- p_sms_objs List of sms business objects.
865 -- p_bus_object Business object structure for contact point.
866 -- NOTES
867 --
868 -- MODIFICATION HISTORY
869 --
870 -- 13-Jul-2005 Arnold Ng o Created.
871
872 FUNCTION is_cp_bo_comp(
873 p_phone_objs IN HZ_PHONE_CP_BO_TBL,
874 p_email_objs IN HZ_EMAIL_CP_BO_TBL,
875 p_telex_objs IN HZ_TELEX_CP_BO_TBL,
876 p_web_objs IN HZ_WEB_CP_BO_TBL,
877 p_edi_objs IN HZ_EDI_CP_BO_TBL,
878 p_eft_objs IN HZ_EFT_CP_BO_TBL,
879 p_sms_objs IN HZ_SMS_CP_BO_TBL,
880 p_bus_object IN COMPLETENESS_REC_TYPE
881 ) RETURN BOOLEAN;
882
883 -- FUNCTION is_ps_bo_comp
884 --
885 -- DESCRIPTION
886 -- Return true if party site object is complete. Otherwise, return false.
887 --
888 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
889 --
890 -- ARGUMENTS
891 -- IN:
892 -- p_ps_objs List of party site business objects.
893 -- p_bus_object Business object structure for party site.
894 -- NOTES
895 --
896 -- MODIFICATION HISTORY
897 --
898 -- 13-Jul-2005 Arnold Ng o Created.
899
900 FUNCTION is_ps_bo_comp(
901 p_ps_objs IN HZ_PARTY_SITE_BO_TBL,
902 p_bus_object IN COMPLETENESS_REC_TYPE
903 ) RETURN BOOLEAN;
904
905 -- FUNCTION is_person_bo_comp
906 --
907 -- DESCRIPTION
908 -- Return true if person object is complete. Otherwise, return false.
909 --
910 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
911 --
912 -- ARGUMENTS
913 -- IN:
914 -- p_person_obj Person business objects.
915 -- p_bus_object Business object structure for person.
916 -- NOTES
917 --
918 -- MODIFICATION HISTORY
919 --
920 -- 13-Jul-2005 Arnold Ng o Created.
921
922 FUNCTION is_person_bo_comp(
923 p_person_obj IN HZ_PERSON_BO,
924 p_bus_object IN COMPLETENESS_REC_TYPE
925 ) RETURN BOOLEAN;
926
927 -- FUNCTION is_org_bo_comp
928 --
929 -- DESCRIPTION
930 -- Return true if organization object is complete. Otherwise, return false.
931 --
932 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
933 --
934 -- ARGUMENTS
935 -- IN:
936 -- p_organization_obj Organization business objects.
937 -- p_bus_object Business object structure for organization.
938 -- NOTES
939 --
940 -- MODIFICATION HISTORY
941 --
942 -- 13-Jul-2005 Arnold Ng o Created.
943
944 FUNCTION is_org_bo_comp(
945 p_organization_obj IN HZ_ORGANIZATION_BO,
946 p_bus_object IN COMPLETENESS_REC_TYPE
947 ) RETURN BOOLEAN;
948
949 -- FUNCTION is_oc_bo_comp
950 --
951 -- DESCRIPTION
952 -- Return true if org contact object is complete. Otherwise, return false.
953 --
954 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
955 --
956 -- ARGUMENTS
957 -- IN:
958 -- p_oc_objs List of organization contact business objects.
959 -- p_bus_object Business object structure for organization contact.
960 -- NOTES
961 --
962 -- MODIFICATION HISTORY
963 --
964 -- 13-Jul-2005 Arnold Ng o Created.
965
966 FUNCTION is_oc_bo_comp(
967 p_oc_objs IN HZ_ORG_CONTACT_BO_TBL,
968 p_bus_object IN COMPLETENESS_REC_TYPE
969 ) RETURN BOOLEAN;
970
971 -- FUNCTION is_cac_bo_comp
972 --
973 -- DESCRIPTION
974 -- Return true if customer account contact object is complete.
975 -- Otherwise, return false.
976 --
977 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
978 --
979 -- ARGUMENTS
980 -- IN:
981 -- p_cac_objs List of customer account contact business objects.
982 -- p_bus_object Business object structure for customer account contact.
983 -- NOTES
984 --
985 -- MODIFICATION HISTORY
986 --
987 -- 13-Jul-2005 Arnold Ng o Created.
988
989 FUNCTION is_cac_bo_comp(
990 p_cac_objs IN HZ_CUST_ACCT_CONTACT_BO_TBL,
994 -- FUNCTION is_cas_bo_comp
991 p_bus_object IN COMPLETENESS_REC_TYPE
992 ) RETURN BOOLEAN;
993
995 --
996 -- DESCRIPTION
997 -- Return true if customer account site object is complete.
998 -- Otherwise, return false.
999 --
1000 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1001 --
1002 -- ARGUMENTS
1003 -- IN:
1004 -- p_cas_objs List of customer account site business objects.
1005 -- p_bus_object Business object structure for customer account site.
1006 -- NOTES
1007 --
1008 -- MODIFICATION HISTORY
1009 --
1010 -- 13-Jul-2005 Arnold Ng o Created.
1011
1012 FUNCTION is_cas_bo_comp(
1013 p_cas_objs IN HZ_CUST_ACCT_SITE_BO_TBL,
1014 p_bus_object IN COMPLETENESS_REC_TYPE
1015 ) RETURN BOOLEAN;
1016
1017 -- FUNCTION is_ca_bo_comp
1018 --
1019 -- DESCRIPTION
1020 -- Return true if customer account object is complete. Otherwise, return false.
1021 --
1022 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1023 --
1024 -- ARGUMENTS
1025 -- IN:
1026 -- p_ca_objs List of customer account business objects.
1027 -- p_bus_object Business object structure for customer account.
1028 -- NOTES
1029 --
1030 -- MODIFICATION HISTORY
1031 --
1032 -- 13-Jul-2005 Arnold Ng o Created.
1033
1034 FUNCTION is_ca_bo_comp(
1035 p_ca_objs IN HZ_CUST_ACCT_BO_TBL,
1036 p_bus_object IN COMPLETENESS_REC_TYPE
1037 ) RETURN BOOLEAN;
1038
1039 -- FUNCTION is_pca_bo_comp
1040 --
1041 -- DESCRIPTION
1042 -- Return true if person customer object is complete. Otherwise, return false.
1043 --
1044 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1045 --
1046 -- ARGUMENTS
1047 -- IN:
1048 -- p_person_obj Person business object.
1049 -- p_ca_objs List of customer account objects.
1050 -- NOTES
1051 --
1052 -- MODIFICATION HISTORY
1053 --
1054 -- 13-Jul-2005 Arnold Ng o Created.
1055
1056 FUNCTION is_pca_bo_comp(
1057 p_person_obj IN HZ_PERSON_BO,
1058 p_ca_objs IN HZ_CUST_ACCT_BO_TBL
1059 ) RETURN BOOLEAN;
1060
1061 -- FUNCTION is_oca_bo_comp
1062 --
1063 -- DESCRIPTION
1064 -- Return true if organization customer object is complete.
1065 -- Otherwise, return false.
1066 --
1067 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1068 --
1069 -- ARGUMENTS
1070 -- IN:
1071 -- p_org_obj Organization business object.
1072 -- p_ca_objs List of customer account objects.
1073 -- NOTES
1074 --
1075 -- MODIFICATION HISTORY
1076 --
1077 -- 13-Jul-2005 Arnold Ng o Created.
1078
1079 FUNCTION is_oca_bo_comp(
1080 p_org_obj IN HZ_ORGANIZATION_BO,
1081 p_ca_objs IN HZ_CUST_ACCT_BO_TBL
1082 ) RETURN BOOLEAN;
1083
1084 -- FUNCTION get_bus_object_struct
1085 --
1086 -- DESCRIPTION
1087 -- Get contact point business object structure.
1088 --
1089 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1090 --
1091 -- ARGUMENTS
1092 -- IN:
1093 -- p_bus_object_code Business object code, such as 'PARTY_SITE',
1094 -- 'ORG_CONTACT'
1095 -- OUT:
1096 -- x_bus_object Business object structure.
1097 -- NOTES
1098 --
1099 -- MODIFICATION HISTORY
1100 --
1101 -- 13-Jul-2005 Arnold Ng o Created.
1102
1103 PROCEDURE get_bus_obj_struct(
1104 p_bus_object_code IN VARCHAR2,
1105 x_bus_object OUT NOCOPY COMPLETENESS_REC_TYPE
1106 );
1107
1108 -- FUNCTION get_cp_bus_obj_struct
1109 --
1110 -- DESCRIPTION
1111 -- Get contact point business object structure.
1112 --
1113 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1114 --
1115 -- ARGUMENTS
1116 -- IN:
1117 -- p_phone_code 'PHONE'.
1118 -- p_email_code 'EMAIL'.
1119 -- p_telex_code 'TLX'.
1120 -- p_web_code 'WEB'.
1121 -- p_edi_code 'EDI'.
1122 -- p_eft_code 'EFT'.
1123 -- p_sms_code 'SMS'.
1124 -- OUT:
1125 -- x_bus_object Contact point business object structure.
1126 -- NOTES
1127 --
1128 -- MODIFICATION HISTORY
1129 --
1130 -- 13-Jul-2005 Arnold Ng o Created.
1131
1132 PROCEDURE get_cp_bus_obj_struct(
1133 p_phone_code IN VARCHAR2,
1134 p_email_code IN VARCHAR2,
1135 p_telex_code IN VARCHAR2,
1136 p_web_code IN VARCHAR2,
1137 p_edi_code IN VARCHAR2,
1138 p_eft_code IN VARCHAR2,
1139 p_sms_code IN VARCHAR2,
1140 x_bus_object OUT NOCOPY COMPLETENESS_REC_TYPE
1141 );
1142
1143 -- FUNCTION get_id_from_ososr
1144 --
1145 -- DESCRIPTION
1146 -- Get TCA Id based on original system and original system reference.
1147 --
1148 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1149 --
1150 -- ARGUMENTS
1154 -- p_owner_table_name Owner table name
1151 -- IN:
1152 -- p_os Original system
1153 -- p_osr Original system reference
1155 -- NOTES
1156 --
1157 -- MODIFICATION HISTORY
1158 --
1159 -- 13-Jul-2005 Arnold Ng o Created.
1160
1161 FUNCTION get_id_from_ososr(
1162 p_os IN VARCHAR2,
1163 p_osr IN VARCHAR2,
1164 p_owner_table_name IN VARCHAR2
1165 ) RETURN NUMBER;
1166
1167 -- FUNCTION is_cas_v2_bo_comp
1168 --
1169 -- DESCRIPTION
1170 -- Return true if customer account site object is complete.
1171 -- Otherwise, return false.
1172 --
1173 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1174 --
1175 -- ARGUMENTS
1176 -- IN:
1177 -- p_cas_v2_objs List of customer account site business objects.
1178 -- p_bus_object Business object structure for customer account site.
1179 -- NOTES
1180 --
1181 -- MODIFICATION HISTORY
1182 --
1183 -- 1-FEB-2008 vsegu o Created.
1184
1185 FUNCTION is_cas_v2_bo_comp(
1186 p_cas_v2_objs IN HZ_CUST_ACCT_SITE_V2_BO_TBL,
1187 p_bus_object IN COMPLETENESS_REC_TYPE
1188 ) RETURN BOOLEAN;
1189
1190 -- FUNCTION is_ca_v2_bo_comp
1191 --
1192 -- DESCRIPTION
1193 -- Return true if customer account object is complete. Otherwise, return false.
1194 --
1195 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1196 --
1197 -- ARGUMENTS
1198 -- IN:
1199 -- p_ca_v2_objs List of customer account business objects.
1200 -- p_bus_object Business object structure for customer account.
1201 -- NOTES
1202 --
1203 -- MODIFICATION HISTORY
1204 --
1205 -- 1-FEB-2008 vsegu o Created.
1206
1207 FUNCTION is_ca_v2_bo_comp(
1208 p_ca_v2_objs IN HZ_CUST_ACCT_V2_BO_TBL,
1209 p_bus_object IN COMPLETENESS_REC_TYPE
1210 ) RETURN BOOLEAN;
1211
1212 -- FUNCTION is_pca_v2_bo_comp
1213 --
1214 -- DESCRIPTION
1215 -- Return true if person customer object is complete. Otherwise, return false.
1216 --
1217 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1218 --
1219 -- ARGUMENTS
1220 -- IN:
1221 -- p_person_obj Person business object.
1222 -- p_ca_v2_objs List of customer account objects.
1223 -- NOTES
1224 --
1225 -- MODIFICATION HISTORY
1226 --
1227 -- 1-Feb-2008 vsegu o Created.
1228
1229 FUNCTION is_pca_v2_bo_comp(
1230 p_person_obj IN HZ_PERSON_BO,
1231 p_ca_v2_objs IN HZ_CUST_ACCT_V2_BO_TBL
1232 ) RETURN BOOLEAN;
1233
1234 -- FUNCTION is_oca_v2_bo_comp
1235 --
1236 -- DESCRIPTION
1237 -- Return true if organization customer object is complete.
1238 -- Otherwise, return false.
1239 --
1240 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1241 --
1242 -- ARGUMENTS
1243 -- IN:
1244 -- p_org_obj Organization business object.
1245 -- p_ca_v2_objs List of customer account objects.
1246 -- NOTES
1247 --
1248 -- MODIFICATION HISTORY
1249 --
1250 -- 1-Feb-2008 vsegu o Created.
1251
1252 FUNCTION is_oca_v2_bo_comp(
1253 p_org_obj IN HZ_ORGANIZATION_BO,
1254 p_ca_v2_objs IN HZ_CUST_ACCT_V2_BO_TBL
1255 ) RETURN BOOLEAN;
1256
1257 END HZ_REGISTRY_VALIDATE_BO_PVT;