APPS.HZ_EXTRACT_ORGANIZATION_BO_PVT dependencies on HZ_ORGANIZATION_PROFILES

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 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 651: from HZ_ORGANIZATION_PROFILES

647: AND SYSDATE BETWEEN EFFECTIVE_START_DATE AND NVL(EFFECTIVE_END_DATE,SYSDATE);
648:
649: cursor get_profile_id_csr is
650: select organization_profile_id
651: from HZ_ORGANIZATION_PROFILES
652: where party_id = p_organization_id
653: AND sysdate between effective_start_date and nvl(effective_end_date,sysdate);
654:
655: l_debug_prefix VARCHAR2(30) := '';

Line 700: p_ext_object_name => 'HZ_ORGANIZATION_PROFILES',

696:
697: hz_extract_ext_attri_bo_pvt.get_ext_attribute_bos
698: (p_init_msg_list => fnd_api.g_false,
699: p_ext_object_id => l_prof_id,
700: p_ext_object_name => 'HZ_ORGANIZATION_PROFILES',
701: p_action_type => p_action_type,
702: x_ext_attribute_objs => x_organization_obj.ext_attributes_objs,
703: x_return_status => x_return_status,
704: x_msg_count => x_msg_count,

Line 1487: and CHILD_ENTITY_NAME = 'HZ_ORGANIZATION_PROFILES';

1483: select CHILD_ENTITY_NAME
1484: FROM HZ_BUS_OBJ_TRACKING
1485: where event_id = p_event_id
1486: and populated_flag = 'N'
1487: and CHILD_ENTITY_NAME = 'HZ_ORGANIZATION_PROFILES';
1488:
1489: L_CHILD_OPERATION_FLAG VARCHAR2(1);
1490: L_CHILD_BO_CODE VARCHAR2(30);
1491: L_CHILD_ENTITY_NAME VARCHAR2(30);

Line 1509: if l_child_entity_name = 'HZ_ORGANIZATION_PROFILES'

1505: open c2;
1506: fetch c2 into L_CHILD_ENTITY_NAME;
1507: close c2;
1508:
1509: if l_child_entity_name = 'HZ_ORGANIZATION_PROFILES'
1510: then
1511: px_org_obj.action_type := 'UPDATED';
1512: else px_org_obj.action_type := 'CHILD_UPDATED';
1513: end if;

Line 1520: if l_child_entity_name = 'HZ_ORGANIZATION_PROFILES'

1516: loop
1517: fetch c1 into L_NODE_PATH, L_CHILD_OPERATION_FLAG,L_CHILD_BO_CODE,
1518: L_CHILD_ENTITY_NAME, L_CHILD_ID, l_populated_flag;
1519: exit when c1%NOTFOUND;
1520: if l_child_entity_name = 'HZ_ORGANIZATION_PROFILES'
1521: then
1522: px_org_obj.action_type := 'UPDATED';
1523: end if;
1524: if l_populated_flag = 'N'