[Home] [Help]
324: CAST(MULTISET
325: (SELECT hz_party_pref_obj(p_action_type,
326: NULL, -- COMMON_OBJ_ID
327: party_preference_id,
328: hz_extract_bo_util_pvt.get_parent_object_type('HZ_PARTIES',
329: party_id),
330: party_id,
331: category,
332: preference_code,
358: CAST(MULTISET
359: (SELECT hz_code_assignment_obj(p_action_type,
360: NULL, -- COMMON_OBJ_ID
361: code_assignment_id,
362: hz_extract_bo_util_pvt.get_parent_object_type('HZ_PARTIES',
363: owner_table_id),
364: owner_table_id,
365: class_category,
366: class_code,
377: hz_extract_bo_util_pvt.get_user_name(last_updated_by),
378: rank)
379: FROM hz_code_assignments
380: WHERE owner_table_name =
381: 'HZ_PARTIES'
382: AND owner_table_id =
383: p_organization_id) AS
384: hz_code_assignment_obj_tbl),
385: hz_financial_bo_tbl(),
495: (SELECT hz_certification_obj(p_action_type,
496: NULL, -- COMMON_OBJ_ID
497: certification_id,
498: certification_name,
499: hz_extract_bo_util_pvt.get_parent_object_type('HZ_PARTIES',
500: party_id),
501: party_id,
502: current_status,
503: expires_on_date,
526: financial_account_number,
527: financial_account_type,
528: financial_org_type,
529: financial_organization_name,
530: hz_extract_bo_util_pvt.get_parent_object_type('HZ_PARTIES',
531: party_id),
532: party_id,
533: --WH_UPDATE_DATE,
534: status,
543: hz_financial_prof_obj_tbl),
544: hz_contact_pref_obj_tbl(),
545: hz_party_usage_obj_tbl())
546: FROM hz_organization_profiles pro,
547: hz_parties p
548: WHERE pro.party_id = p.party_id
549: AND pro.party_id = p_organization_id
550: AND SYSDATE BETWEEN effective_start_date AND
551: nvl(effective_end_date, SYSDATE);
582: CLOSE c1;
583:
584: hz_extract_orig_sys_ref_bo_pvt.get_orig_sys_ref_bos(p_init_msg_list => fnd_api.g_false,
585: p_owner_table_id => p_organization_id,
586: p_owner_table_name => 'HZ_PARTIES',
587: p_action_type => NULL, --p_action_type,
588: x_orig_sys_ref_objs => x_organization_obj.orig_sys_objs,
589: x_return_status => x_return_status,
590: x_msg_count => x_msg_count,
626: END IF;
627:
628: hz_extract_party_usage_bo_pvt.get_party_usage_bos(p_init_msg_list => fnd_api.g_false,
629: p_owner_table_id => p_organization_id,
630: p_owner_table_name => 'HZ_PARTIES',
631: p_action_type => p_action_type,
632: x_party_usage_objs => x_organization_obj.party_usage_objs,
633: x_return_status => x_return_status,
634: x_msg_count => x_msg_count,
664:
665: hz_extract_cont_point_bo_pvt.get_phone_bos(p_init_msg_list => fnd_api.g_false,
666: p_phone_id => NULL,
667: p_parent_id => p_organization_id,
668: p_parent_table_name => 'HZ_PARTIES',
669: p_action_type => p_action_type,
670: x_phone_objs => x_organization_obj.phone_objs,
671: x_return_status => x_return_status,
672: x_msg_count => x_msg_count,
678:
679: hz_extract_cont_point_bo_pvt.get_telex_bos(p_init_msg_list => fnd_api.g_false,
680: p_telex_id => NULL,
681: p_parent_id => p_organization_id,
682: p_parent_table_name => 'HZ_PARTIES',
683: p_action_type => p_action_type,
684: x_telex_objs => x_organization_obj.telex_objs,
685: x_return_status => x_return_status,
686: x_msg_count => x_msg_count,
692:
693: hz_extract_cont_point_bo_pvt.get_email_bos(p_init_msg_list => fnd_api.g_false,
694: p_email_id => NULL,
695: p_parent_id => p_organization_id,
696: p_parent_table_name => 'HZ_PARTIES',
697: p_action_type => p_action_type,
698: x_email_objs => x_organization_obj.email_objs,
699: x_return_status => x_return_status,
700: x_msg_count => x_msg_count,
706:
707: hz_extract_cont_point_bo_pvt.get_web_bos(p_init_msg_list => fnd_api.g_false,
708: p_web_id => NULL,
709: p_parent_id => p_organization_id,
710: p_parent_table_name => 'HZ_PARTIES',
711: p_action_type => p_action_type,
712: x_web_objs => x_organization_obj.web_objs,
713: x_return_status => x_return_status,
714: x_msg_count => x_msg_count,
720:
721: hz_extract_cont_point_bo_pvt.get_edi_bos(p_init_msg_list => fnd_api.g_false,
722: p_edi_id => NULL,
723: p_parent_id => p_organization_id,
724: p_parent_table_name => 'HZ_PARTIES',
725: p_action_type => p_action_type,
726: x_edi_objs => x_organization_obj.edi_objs,
727: x_return_status => x_return_status,
728: x_msg_count => x_msg_count,
734:
735: hz_extract_cont_point_bo_pvt.get_eft_bos(p_init_msg_list => fnd_api.g_false,
736: p_eft_id => NULL,
737: p_parent_id => p_organization_id,
738: p_parent_table_name => 'HZ_PARTIES',
739: p_action_type => p_action_type,
740: x_eft_objs => x_organization_obj.eft_objs,
741: x_return_status => x_return_status,
742: x_msg_count => x_msg_count,
759: END IF;
760:
761: hz_extract_cont_point_bo_pvt.get_cont_pref_objs(p_init_msg_list => fnd_api.g_false,
762: p_cont_level_table_id => p_organization_id,
763: p_cont_level_table => 'HZ_PARTIES',
764: p_contact_type => NULL,
765: p_action_type => p_action_type,
766: x_cont_pref_objs => x_organization_obj.contact_pref_objs,
767: x_return_status => x_return_status,
812: BEGIN
813: SELECT owner_table_id
814: INTO l_party_id
815: FROM hz_orig_sys_references hr
816: WHERE hr.owner_table_name = 'HZ_PARTIES'
817: AND hr.orig_system = p_orig_system
818: AND hr.orig_system_reference = p_orig_system_reference
819: AND nvl(hr.end_date_active, SYSDATE) >= SYSDATE;
820: