870: (p_person_obj.contact_pref_objs.COUNT > 0)) THEN
871: HZ_CONTACT_PREFERENCE_BO_PVT.create_contact_preferences(
872: p_cp_pref_objs => p_person_obj.contact_pref_objs,
873: p_contact_level_table_id => x_person_id,
874: p_contact_level_table => 'HZ_PARTIES',
875: x_return_status => x_return_status,
876: x_msg_count => x_msg_count,
877: x_msg_data => x_msg_data
878: );
907: IF((p_person_obj.class_objs IS NOT NULL) AND
908: (p_person_obj.class_objs.COUNT > 0)) THEN
909: HZ_PARTY_BO_PVT.create_classifications(
910: p_code_assign_objs => p_person_obj.class_objs,
911: p_owner_table_name => 'HZ_PARTIES',
912: p_owner_table_id => x_person_id,
913: x_return_status => x_return_status,
914: x_msg_count => x_msg_count,
915: x_msg_data => x_msg_data
1262: l_party_number VARCHAR2(30);
1263:
1264: CURSOR get_ovn(l_party_id NUMBER) IS
1265: SELECT p.object_version_number, p.party_number
1266: FROM HZ_PARTIES p
1267: WHERE p.party_id = l_party_id
1268: AND p.party_type = 'PERSON'
1269: AND p.status in ('A','I');
1270:
1454: (p_person_obj.contact_pref_objs.COUNT > 0)) THEN
1455: HZ_CONTACT_PREFERENCE_BO_PVT.save_contact_preferences(
1456: p_cp_pref_objs => p_person_obj.contact_pref_objs,
1457: p_contact_level_table_id => x_person_id,
1458: p_contact_level_table => 'HZ_PARTIES',
1459: x_return_status => x_return_status,
1460: x_msg_count => x_msg_count,
1461: x_msg_data => x_msg_data
1462: );
1491: IF((p_person_obj.class_objs IS NOT NULL) AND
1492: (p_person_obj.class_objs.COUNT > 0)) THEN
1493: HZ_PARTY_BO_PVT.save_classifications(
1494: p_code_assign_objs => p_person_obj.class_objs,
1495: p_owner_table_name => 'HZ_PARTIES',
1496: p_owner_table_id => x_person_id,
1497: x_return_status => x_return_status,
1498: x_msg_count => x_msg_count,
1499: x_msg_data => x_msg_data
1864: l_create_update_flag := HZ_REGISTRY_VALIDATE_BO_PVT.check_bo_op(
1865: p_entity_id => x_person_id,
1866: p_entity_os => x_person_os,
1867: p_entity_osr => x_person_osr,
1868: p_entity_type => 'HZ_PARTIES',
1869: p_parent_id => NULL,
1870: p_parent_obj_type=> NULL);
1871:
1872: IF(l_create_update_flag = 'E') THEN
3056: the Get procedure returns all records for the particular person from these TCA entity tables:
3057:
3058: Embedded TCA Entity Mandatory Multiple TCA Table Entities
3059:
3060: Party,Person Profile Y N HZ_PARTIES, HZ_PERSON_PROFILES
3061: Person Preference N Y HZ_PARTY_PREFERENCES
3062: Relationship N Y HZ_RELATIONSHIPS
3063: Classification N Y HZ_CODE_ASSIGNMENTS
3064: Language N Y HZ_PERSON_LANGUAGE