APPS.HZ_EXTRACT_PERSON_BO_PVT dependencies on HZ_PERSON_PROFILES

Line 244: Party,Person Profile Y N HZ_PARTIES, HZ_PERSON_PROFILES

240: the Get procedure returns all records for the particular person from these TCA entity tables:
241:
242: Embedded TCA Entity Mandatory Multiple TCA Table Entities
243:
244: Party,Person Profile Y N HZ_PARTIES, HZ_PERSON_PROFILES
245: Person Preference N Y HZ_PARTY_PREFERENCES
246: Relationship N Y HZ_RELATIONSHIPS
247: Classification N Y HZ_CODE_ASSIGNMENTS
248: Language N Y HZ_PERSON_LANGUAGE

Line 545: FROM HZ_PERSON_PROFILES PRO, HZ_PARTIES P

541: FROM HZ_FINANCIAL_PROFILE
542: WHERE PARTY_ID = P_PERSON_ID) AS HZ_FINANCIAL_PROF_OBJ_TBL),
543: HZ_CONTACT_PREF_OBJ_TBL(),
544: HZ_PARTY_USAGE_OBJ_TBL())
545: FROM HZ_PERSON_PROFILES PRO, HZ_PARTIES P
546: WHERE PRO.PARTY_ID = P.PARTY_ID
547: AND PRO.PARTY_ID = P_PERSON_ID
548: AND SYSDATE BETWEEN EFFECTIVE_START_DATE AND NVL(EFFECTIVE_END_DATE,SYSDATE);
549:

Line 552: from HZ_PERSON_PROFILES

548: AND SYSDATE BETWEEN EFFECTIVE_START_DATE AND NVL(EFFECTIVE_END_DATE,SYSDATE);
549:
550: cursor get_profile_id_csr is
551: select person_profile_id
552: from HZ_PERSON_PROFILES
553: where party_id = p_person_id
554: AND sysdate between effective_start_date and nvl(effective_end_date,sysdate);
555: l_debug_prefix VARCHAR2(30) := '';
556: l_prof_id number;

Line 614: p_ext_object_name => 'HZ_PERSON_PROFILES',

610:
611: hz_extract_ext_attri_bo_pvt.get_ext_attribute_bos
612: (p_init_msg_list => fnd_api.g_false,
613: p_ext_object_id => l_prof_id,
614: p_ext_object_name => 'HZ_PERSON_PROFILES',
615: p_action_type => p_action_type,
616: x_ext_attribute_objs => x_person_obj.ext_attributes_objs,
617: x_return_status => x_return_status,
618: x_msg_count => x_msg_count,

Line 1247: and CHILD_ENTITY_NAME = 'HZ_PERSON_PROFILES';

1243: select CHILD_ENTITY_NAME
1244: FROM HZ_BUS_OBJ_TRACKING
1245: where event_id = p_event_id
1246: and populated_flag = 'N'
1247: and CHILD_ENTITY_NAME = 'HZ_PERSON_PROFILES';
1248:
1249: L_CHILD_OPERATION_FLAG VARCHAR2(1);
1250: L_CHILD_BO_CODE VARCHAR2(30);
1251: L_CHILD_ENTITY_NAME VARCHAR2(30);

Line 1269: if l_child_entity_name = 'HZ_PERSON_PROFILES'

1265: open c2;
1266: fetch c2 into L_CHILD_ENTITY_NAME;
1267: close c2;
1268:
1269: if l_child_entity_name = 'HZ_PERSON_PROFILES'
1270: then
1271: px_person_obj.action_type := 'UPDATED';
1272: else px_person_obj.action_type := 'CHILD_UPDATED';
1273: end if;