eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_EXTRACT_ORGANIZATION_BO_PVT dependencies on HZ_PARTIES

Line 8: * @rep:category BUSINESS_ENTITY HZ_PARTIES

4: * This package contains the private APIs for logical organization.
5: * @rep:scope private
6: * @rep:product HZ
7: * @rep:displayname Organization
8: * @rep:category BUSINESS_ENTITY HZ_PARTIES
9: * @rep:lifecycle active
10: * @rep:doccd 115hztig.pdf Organization Get APIs
11: */
12:

Line 251: Party, Org Profile Y N HZ_PARTIES, HZ_ORGANIZATION_PROFILES

247: the Get procedure returns all records for the particular organization from these TCA entity tables:
248:
249: Embedded TCA Entity Mandatory Multiple TCA Table Entities
250:
251: Party, Org Profile Y N HZ_PARTIES, HZ_ORGANIZATION_PROFILES
252: Org Preference N Y HZ_PARTY_PREFERENCES
253: Relationship N Y HZ_RELATIONSHIPS
254: Classification N Y HZ_CODE_ASSIGNMENTS
255: Credit Rating N Y HZ_CREDIT_RATINGS

Line 437: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type('HZ_PARTIES',PARTY_ID),

433: SELECT HZ_PARTY_PREF_OBJ(
434: P_ACTION_TYPE,
435: NULL, -- COMMON_OBJ_ID
436: PARTY_PREFERENCE_ID,
437: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type('HZ_PARTIES',PARTY_ID),
438: PARTY_ID,
439: CATEGORY,
440: PREFERENCE_CODE,
441: VALUE_VARCHAR2,

Line 469: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type('HZ_PARTIES',OWNER_TABLE_ID),

465: SELECT HZ_CODE_ASSIGNMENT_OBJ(
466: P_ACTION_TYPE,
467: NULL, -- COMMON_OBJ_ID
468: CODE_ASSIGNMENT_ID,
469: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type('HZ_PARTIES',OWNER_TABLE_ID),
470: OWNER_TABLE_ID,
471: CLASS_CATEGORY,
472: CLASS_CODE,
473: PRIMARY_FLAG,

Line 486: WHERE OWNER_TABLE_NAME = 'HZ_PARTIES'

482: LAST_UPDATE_DATE,
483: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
484: RANK)
485: FROM HZ_CODE_ASSIGNMENTS
486: WHERE OWNER_TABLE_NAME = 'HZ_PARTIES'
487: AND OWNER_TABLE_ID = P_ORGANIZATION_ID) AS HZ_CODE_ASSIGNMENT_OBJ_TBL),
488: HZ_FINANCIAL_BO_TBL(),
489: CAST(MULTISET (
490: SELECT HZ_CREDIT_RATING_OBJ(

Line 602: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type('HZ_PARTIES',PARTY_ID),

598: P_ACTION_TYPE,
599: NULL, -- COMMON_OBJ_ID
600: CERTIFICATION_ID,
601: CERTIFICATION_NAME,
602: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type('HZ_PARTIES',PARTY_ID),
603: PARTY_ID,
604: CURRENT_STATUS,
605: EXPIRES_ON_DATE,
606: GRADE,

Line 631: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type('HZ_PARTIES',PARTY_ID),

627: FINANCIAL_ACCOUNT_NUMBER,
628: FINANCIAL_ACCOUNT_TYPE,
629: FINANCIAL_ORG_TYPE,
630: FINANCIAL_ORGANIZATION_NAME,
631: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type('HZ_PARTIES',PARTY_ID),
632: PARTY_ID,
633: --WH_UPDATE_DATE,
634: STATUS,
635: PROGRAM_UPDATE_DATE,

Line 644: FROM HZ_ORGANIZATION_PROFILES PRO, HZ_PARTIES P

640: FROM HZ_FINANCIAL_PROFILE
641: WHERE PARTY_ID = P_ORGANIZATION_ID) AS HZ_FINANCIAL_PROF_OBJ_TBL),
642: HZ_CONTACT_PREF_OBJ_TBL(),
643: HZ_PARTY_USAGE_OBJ_TBL())
644: FROM HZ_ORGANIZATION_PROFILES PRO, HZ_PARTIES P
645: WHERE PRO.PARTY_ID = P.PARTY_ID
646: AND PRO.PARTY_ID = P_ORGANIZATION_ID
647: AND SYSDATE BETWEEN EFFECTIVE_START_DATE AND NVL(EFFECTIVE_END_DATE,SYSDATE);
648:

Line 682: p_owner_table_name => 'HZ_PARTIES',

678:
679: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos
680: (p_init_msg_list => fnd_api.g_false,
681: p_owner_table_id => p_organization_id,
682: p_owner_table_name => 'HZ_PARTIES',
683: p_action_type => NULL, --p_action_type,
684: x_orig_sys_ref_objs => x_organization_obj.orig_sys_objs,
685: x_return_status => x_return_status,
686: x_msg_count => x_msg_count,

Line 728: p_owner_table_name => 'HZ_PARTIES',

724:
725: HZ_EXTRACT_PARTY_USAGE_BO_PVT.get_party_usage_bos
726: (p_init_msg_list => fnd_api.g_false,
727: p_owner_table_id => p_organization_id,
728: p_owner_table_name => 'HZ_PARTIES',
729: p_action_type => p_action_type,
730: x_party_usage_objs => x_organization_obj.party_usage_objs,
731: x_return_status => x_return_status,
732: x_msg_count => x_msg_count,

Line 770: p_parent_table_name => 'HZ_PARTIES',

766: hz_extract_cont_point_bo_pvt.get_phone_bos
767: (p_init_msg_list => fnd_api.g_false,
768: p_phone_id => null,
769: p_parent_id => p_organization_id,
770: p_parent_table_name => 'HZ_PARTIES',
771: p_action_type => p_action_type,
772: x_phone_objs => x_organization_obj.phone_objs,
773: x_return_status => x_return_status,
774: x_msg_count => x_msg_count,

Line 785: p_parent_table_name => 'HZ_PARTIES',

781: hz_extract_cont_point_bo_pvt.get_telex_bos
782: (p_init_msg_list => fnd_api.g_false,
783: p_telex_id => null,
784: p_parent_id => p_organization_id,
785: p_parent_table_name => 'HZ_PARTIES',
786: p_action_type => p_action_type,
787: x_telex_objs => x_organization_obj.telex_objs,
788: x_return_status => x_return_status,
789: x_msg_count => x_msg_count,

Line 801: p_parent_table_name => 'HZ_PARTIES',

797: hz_extract_cont_point_bo_pvt.get_email_bos
798: (p_init_msg_list => fnd_api.g_false,
799: p_email_id => null,
800: p_parent_id => p_organization_id,
801: p_parent_table_name => 'HZ_PARTIES',
802: p_action_type => p_action_type,
803: x_email_objs => x_organization_obj.email_objs,
804: x_return_status => x_return_status,
805: x_msg_count => x_msg_count,

Line 817: p_parent_table_name => 'HZ_PARTIES',

813: hz_extract_cont_point_bo_pvt.get_web_bos
814: (p_init_msg_list => fnd_api.g_false,
815: p_web_id => null,
816: p_parent_id => p_organization_id,
817: p_parent_table_name => 'HZ_PARTIES',
818: p_action_type => p_action_type,
819: x_web_objs => x_organization_obj.web_objs,
820: x_return_status => x_return_status,
821: x_msg_count => x_msg_count,

Line 834: p_parent_table_name => 'HZ_PARTIES',

830: hz_extract_cont_point_bo_pvt.get_edi_bos
831: (p_init_msg_list => fnd_api.g_false,
832: p_edi_id => null,
833: p_parent_id => p_organization_id,
834: p_parent_table_name => 'HZ_PARTIES',
835: p_action_type => p_action_type,
836: x_edi_objs => x_organization_obj.edi_objs,
837: x_return_status => x_return_status,
838: x_msg_count => x_msg_count,

Line 850: p_parent_table_name => 'HZ_PARTIES',

846: hz_extract_cont_point_bo_pvt.get_eft_bos
847: (p_init_msg_list => fnd_api.g_false,
848: p_eft_id => null,
849: p_parent_id => p_organization_id,
850: p_parent_table_name => 'HZ_PARTIES',
851: p_action_type => p_action_type,
852: x_eft_objs => x_organization_obj.eft_objs,
853: x_return_status => x_return_status,
854: x_msg_count => x_msg_count,

Line 879: p_cont_level_table => 'HZ_PARTIES',

875:
876: hz_extract_cont_point_bo_pvt.get_cont_pref_objs
877: (p_init_msg_list => fnd_api.g_false,
878: p_cont_level_table_id => p_organization_id,
879: p_cont_level_table => 'HZ_PARTIES',
880: p_contact_type => NULL,
881: p_action_type => p_action_type,
882: x_cont_pref_objs => x_organization_obj.contact_pref_objs,
883: x_return_status => x_return_status,

Line 1472: and child_entity_name = 'HZ_PARTIES'

1468: populated_flag
1469: FROM HZ_BUS_OBJ_TRACKING
1470: where event_id = p_event_id
1471: START WITH child_id = p_root_id
1472: and child_entity_name = 'HZ_PARTIES'
1473: AND PARENT_BO_CODE IS NULL
1474: AND CHILD_BO_CODE = 'ORG' --(or ORG, PERSON_CUST, ORG_CUST).
1475: and event_id = p_event_id
1476: CONNECT BY PARENT_ENTITY_NAME = PRIOR CHILD_ENTITY_NAME

Line 1502: -- Solve populate_flag is not in sync in hz_parties and hz_org_profiles.

1498: begin
1499: -- initialize API return status to success.
1500: x_return_status := FND_API.G_RET_STS_SUCCESS;
1501:
1502: -- Solve populate_flag is not in sync in hz_parties and hz_org_profiles.
1503: -- c1 can't return profile entity.
1504:
1505: open c2;
1506: fetch c2 into L_CHILD_ENTITY_NAME;