DBA Data[Home] [Help]

APPS.GHR_SF52_API dependencies on GHR_PRH_INS

Line 1160: ghr_prh_ins.ins

1156: if l_action_taken = 'UPDATE_HR' and trunc(p_effective_date) > trunc(sysdate) then
1157: l_action_taken := 'FUTURE_ACTION';
1158: End if;
1159:
1160: ghr_prh_ins.ins
1161: (
1162: p_pa_routing_history_id => p_1_pa_routing_history_id,
1163: p_pa_request_id => l_pa_request_id,
1164: p_attachment_modified_flag => nvl(p_1_attachment_modified_flag,'N') ,

Line 1239: ghr_prh_ins.ins

1235: /***dk***/
1236: -- added END_ROUTING to the following if stmt.
1237: if nvl(l_action_taken,hr_api.g_varchar2) not in ('NOT_ROUTED','UPDATE_HR','FUTURE_ACTION','END_ROUTING') then
1238:
1239: ghr_prh_ins.ins
1240: (p_pa_routing_history_id => p_2_pa_routing_history_id,
1241: p_pa_request_id => l_pa_request_id,
1242: p_attachment_modified_flag => 'N',
1243: p_initiator_flag => 'N',

Line 3391: ghr_prh_ins.ins

3387: /***dk***/
3388: -- Should I add ENDED and/or END_ROUTING to the following if??
3389: if nvl(l_action_taken,hr_api.g_varchar2) not in ('NOT_ROUTED','UPDATE_HR','FUTURE_ACTION','NONE','END_ROUTING') then
3390:
3391: ghr_prh_ins.ins
3392: (p_pa_routing_history_id => l_i_pa_routing_history_id,
3393: p_pa_request_id => p_pa_request_id,
3394: p_attachment_modified_flag => 'N',
3395: p_initiator_flag => 'N',

Line 4349: ghr_prh_ins.ins

4345: l_NOA_FAMILY_CODE := cur_routing_history.noa_family_code;
4346: l_SECOND_noa_id := cur_routing_history.second_nature_of_action_id;
4347: exit;
4348: end loop;
4349: ghr_prh_ins.ins
4350: (
4351: p_pa_routing_history_id => l_pa_routing_history_id,
4352: p_pa_request_id => p_pa_request_id,
4353: p_attachment_modified_flag => 'N',