[Home] [Help]
86: CREATION_DATE,
87: LAST_UPDATE_DATE,
88: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
89: CAST(MULTISET (
90: SELECT HZ_WORK_CLASS_OBJ(
91: P_ACTION_TYPE,
92: NULL, -- COMMON_OBJ_ID
93: WORK_CLASS_ID,
94: LEVEL_OF_EXPERIENCE,
100: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
101: CREATION_DATE,
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;
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) := '';
232: Phone N Y get_phone_bo
233: Email N Y get_email_bo
234: Web N Y get_web_bo
235: SMS N Y get_sms_bo
236: Employment History N Y Business Structure. Included entities:HZ_EMPLOYMENT_HISTORY, HZ_WORK_CLASS
237:
238:
239: To retrieve the appropriate embedded entities within the Person business object,
240: the Get procedure returns all records for the particular person from these TCA entity tables:
1582: end if;
1583:
1584: -- check second level
1585:
1586: if l_child_entity_name = 'HZ_WORK_CLASS'
1587: then
1588: for j in 1..PX_PERSON_OBJ.EMPLOY_HIST_OBJS(i).WORK_CLASS_OBJS.COUNT
1589: loop
1590: if PX_PERSON_OBJ.EMPLOY_HIST_OBJS(i).WORK_CLASS_OBJS(j).work_class_id = l_child_id