46: PROCEDURE get_employ_hist_bos(
47: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
48: p_person_id IN NUMBER,
49: p_action_type IN VARCHAR2 := NULL,
50: x_employ_hist_objs OUT NOCOPY HZ_EMPLOY_HIST_BO_TBL,
51: x_return_status OUT NOCOPY VARCHAR2,
52: x_msg_count OUT NOCOPY NUMBER,
53: x_msg_data OUT NOCOPY VARCHAR2
54: ) is
53: x_msg_data OUT NOCOPY VARCHAR2
54: ) is
55:
56: CURSOR C1 IS
57: SELECT HZ_EMPLOY_HIST_BO(
58: P_ACTION_TYPE,
59: NULL, -- COMMON_OBJ_ID
60: EMPLOYMENT_HISTORY_ID,
61: PARTY_ID,
127: p_prefix=>l_debug_prefix,
128: p_msg_level=>fnd_log.level_procedure);
129: END IF;
130:
131: x_employ_hist_objs := HZ_EMPLOY_HIST_BO_TBL();
132: open c1;
133: fetch c1 BULK COLLECT into x_employ_hist_objs;
134: close c1;
135:
468: LAST_UPDATE_DATE,
469: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
470: FROM HZ_CITIZENSHIP
471: WHERE PARTY_ID = P_PERSON_ID) AS HZ_CITIZENSHIP_OBJ_TBL),
472: HZ_EMPLOY_HIST_BO_TBL(),
473: CAST(MULTISET (
474: SELECT HZ_PERSON_INTEREST_OBJ(
475: P_ACTION_TYPE,
476: NULL, -- COMMON_OBJ_ID