DBA Data[Home] [Help]

APPS.GHR_SF52_API dependencies on GHR_PRH_INS

Line 1222: ghr_prh_ins.ins

1218: if l_action_taken = 'UPDATE_HR' and trunc(p_effective_date) > trunc(sysdate) then
1219: l_action_taken := 'FUTURE_ACTION';
1220: End if;
1221:
1222: ghr_prh_ins.ins
1223: (
1224: p_pa_routing_history_id => p_1_pa_routing_history_id,
1225: p_pa_request_id => l_pa_request_id,
1226: p_attachment_modified_flag => nvl(p_1_attachment_modified_flag,'N') ,

Line 1300: ghr_prh_ins.ins

1296: /***dk***/
1297: -- added END_ROUTING to the following if stmt.
1298: if nvl(l_action_taken,hr_api.g_varchar2) not in ('NOT_ROUTED','UPDATE_HR','FUTURE_ACTION','END_ROUTING') then
1299:
1300: ghr_prh_ins.ins
1301: (p_pa_routing_history_id => p_2_pa_routing_history_id,
1302: p_pa_request_id => l_pa_request_id,
1303: p_attachment_modified_flag => 'N',
1304: p_initiator_flag => 'N',

Line 3570: ghr_prh_ins.ins

3566: /***dk***/
3567: -- Should I add ENDED and/or END_ROUTING to the following if??
3568: if nvl(l_action_taken,hr_api.g_varchar2) not in ('NOT_ROUTED','UPDATE_HR','FUTURE_ACTION','NONE','END_ROUTING') then
3569:
3570: ghr_prh_ins.ins
3571: (p_pa_routing_history_id => l_i_pa_routing_history_id,
3572: p_pa_request_id => p_pa_request_id,
3573: p_attachment_modified_flag => 'N',
3574: p_initiator_flag => 'N',

Line 4592: ghr_prh_ins.ins

4588: l_NOA_FAMILY_CODE := cur_routing_history.noa_family_code;
4589: l_SECOND_noa_id := cur_routing_history.second_nature_of_action_id;
4590: exit;
4591: end loop;
4592: ghr_prh_ins.ins
4593: (
4594: p_pa_routing_history_id => l_pa_routing_history_id,
4595: p_pa_request_id => p_pa_request_id,
4596: p_attachment_modified_flag => 'N',