[Home] [Help]
4: * This package contains the private APIs for logical person.
5: * @rep:scope private
6: * @rep:product HZ
7: * @rep:displayname Person
8: * @rep:category BUSINESS_ENTITY HZ_PARTIES
9: * @rep:lifecycle active
10: * @rep:doccd 115hztig.pdf Person Get APIs
11: */
12:
102: LAST_UPDATE_DATE,
103: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
104: FROM HZ_WORK_CLASS
105: WHERE WORK_CLASS_ID = P_PERSON_ID
106: AND WORK_CLASS_NAME = 'HZ_PARTIES') AS HZ_WORK_CLASS_OBJ_TBL))
107: FROM HZ_EMPLOYMENT_HISTORY
108: WHERE PARTY_ID = P_PERSON_ID;
109:
110: l_debug_prefix VARCHAR2(30) := '';
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
353: SELECT HZ_PARTY_PREF_OBJ(
354: P_ACTION_TYPE,
355: NULL, -- COMMON_OBJ_ID
356: PARTY_PREFERENCE_ID,
357: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type('HZ_PARTIES',PARTY_ID),
358: PARTY_ID,
359: CATEGORY,
360: PREFERENCE_CODE,
361: VALUE_VARCHAR2,
383: SELECT HZ_CODE_ASSIGNMENT_OBJ(
384: P_ACTION_TYPE,
385: NULL, -- COMMON_OBJ_ID
386: CODE_ASSIGNMENT_ID,
387: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type('HZ_PARTIES',OWNER_TABLE_ID),
388: OWNER_TABLE_ID,
389: CLASS_CATEGORY,
390: CLASS_CODE,
391: PRIMARY_FLAG,
400: LAST_UPDATE_DATE,
401: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
402: RANK)
403: FROM HZ_CODE_ASSIGNMENTS
404: WHERE OWNER_TABLE_NAME = 'HZ_PARTIES'
405: AND OWNER_TABLE_ID = P_PERSON_ID) AS HZ_CODE_ASSIGNMENT_OBJ_TBL),
406: CAST(MULTISET (
407: SELECT HZ_PERSON_LANG_OBJ(
408: P_ACTION_TYPE,
499: P_ACTION_TYPE,
500: NULL, -- COMMON_OBJ_ID
501: CERTIFICATION_ID,
502: CERTIFICATION_NAME,
503: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type('HZ_PARTIES',PARTY_ID),
504: PARTY_ID,
505: CURRENT_STATUS,
506: EXPIRES_ON_DATE,
507: GRADE,
528: FINANCIAL_ACCOUNT_NUMBER,
529: FINANCIAL_ACCOUNT_TYPE,
530: FINANCIAL_ORG_TYPE,
531: FINANCIAL_ORGANIZATION_NAME,
532: HZ_EXTRACT_BO_UTIL_PVT.get_parent_object_type('HZ_PARTIES',PARTY_ID),
533: PARTY_ID,
534: --WH_UPDATE_DATE,
535: STATUS,
536: PROGRAM_UPDATE_DATE,
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:
578:
579: HZ_EXTRACT_ORIG_SYS_REF_BO_PVT.get_orig_sys_ref_bos
580: (p_init_msg_list => fnd_api.g_false,
581: p_owner_table_id => p_person_id,
582: p_owner_table_name => 'HZ_PARTIES',
583: p_action_type => NULL, --p_action_type,
584: x_orig_sys_ref_objs => x_person_obj.orig_sys_objs,
585: x_return_status => x_return_status,
586: x_msg_count => x_msg_count,
592:
593: HZ_EXTRACT_PARTY_USAGE_BO_PVT.get_party_usage_bos
594: (p_init_msg_list => fnd_api.g_false,
595: p_owner_table_id => p_person_id,
596: p_owner_table_name => 'HZ_PARTIES',
597: p_action_type => p_action_type,
598: x_party_usage_objs => x_person_obj.party_usage_objs,
599: x_return_status => x_return_status,
600: x_msg_count => x_msg_count,
654: hz_extract_cont_point_bo_pvt.get_phone_bos
655: (p_init_msg_list => fnd_api.g_false,
656: p_phone_id => null,
657: p_parent_id => p_person_id,
658: p_parent_table_name => 'HZ_PARTIES',
659: p_action_type => p_action_type,
660: x_phone_objs => x_person_obj.phone_objs,
661: x_return_status => x_return_status,
662: x_msg_count => x_msg_count,
669: hz_extract_cont_point_bo_pvt.get_email_bos
670: (p_init_msg_list => fnd_api.g_false,
671: p_email_id => null,
672: p_parent_id => p_person_id,
673: p_parent_table_name => 'HZ_PARTIES',
674: p_action_type => p_action_type,
675: x_email_objs => x_person_obj.email_objs,
676: x_return_status => x_return_status,
677: x_msg_count => x_msg_count,
685: hz_extract_cont_point_bo_pvt.get_web_bos
686: (p_init_msg_list => fnd_api.g_false,
687: p_web_id => null,
688: p_parent_id => p_person_id,
689: p_parent_table_name => 'HZ_PARTIES',
690: p_action_type => p_action_type,
691: x_web_objs => x_person_obj.web_objs,
692: x_return_status => x_return_status,
693: x_msg_count => x_msg_count,
700: hz_extract_cont_point_bo_pvt.get_sms_bos
701: (p_init_msg_list => fnd_api.g_false,
702: p_sms_id => null,
703: p_parent_id => p_person_id,
704: p_parent_table_name => 'HZ_PARTIES',
705: p_action_type => p_action_type,
706: x_sms_objs => x_person_obj.sms_objs,
707: x_return_status => x_return_status,
708: x_msg_count => x_msg_count,
723:
724: hz_extract_cont_point_bo_pvt.get_cont_pref_objs
725: (p_init_msg_list => fnd_api.g_false,
726: p_cont_level_table_id => p_person_id,
727: p_cont_level_table => 'HZ_PARTIES',
728: p_contact_type => NULL,
729: p_action_type => p_action_type,
730: x_cont_pref_objs => x_person_obj.contact_pref_objs,
731: x_return_status => x_return_status,
1228: populated_flag
1229: FROM HZ_BUS_OBJ_TRACKING
1230: where event_id = p_event_id
1231: START WITH child_id = p_root_id
1232: AND child_entity_name = 'HZ_PARTIES'
1233: AND PARENT_BO_CODE IS NULL
1234: AND event_id = p_event_id
1235: AND CHILD_BO_CODE = 'PERSON' --(or ORG, PERSON_CUST, ORG_CUST).
1236: and event_id = p_event_id
1258: begin
1259: -- initialize API return status to success.
1260: x_return_status := FND_API.G_RET_STS_SUCCESS;
1261:
1262: -- Solve populate_flag is not in sync in hz_parties and hz_org_profiles.
1263: -- c1 can't return profile entity.
1264:
1265: open c2;
1266: fetch c2 into L_CHILD_ENTITY_NAME;