DBA Data[Home] [Help]

APPS.GHR_APPROVED_PA_REQUESTS dependencies on GHR_PAR_UPD

Line 976: ghr_par_upd.upd(

972: hr_utility.set_location('Updating SF52 - OVN '||to_char(p_par_object_version_number)|| '-'|| l_proc, 25);
973: hr_utility.set_location(l_proc || 'Which NOA and Action ' || to_char(p_which_noa) || ' '|| p_which_action, 35);
974: if p_which_noa = 1 then
975: IF p_which_action = 'ORIGINAL' THEN
976: ghr_par_upd.upd(
977: P_PA_REQUEST_ID => p_pa_request_id
978: , P_OBJECT_VERSION_NUMBER => p_par_object_version_number
979: , p_first_noa_canc_pa_request_id => l_pa_req_rec.pa_request_id
980: );

Line 982: ghr_par_upd.upd(

978: , P_OBJECT_VERSION_NUMBER => p_par_object_version_number
979: , p_first_noa_canc_pa_request_id => l_pa_req_rec.pa_request_id
980: );
981: ELSE
982: ghr_par_upd.upd(
983: P_PA_REQUEST_ID => p_pa_request_id
984: , P_OBJECT_VERSION_NUMBER => p_par_object_version_number
985: , p_first_noa_pa_request_id => l_pa_req_rec.pa_request_id
986: , p_first_noa_cancel_or_correct => l_noa_cancel_or_correct

Line 991: ghr_par_upd.upd(

987: );
988: END IF;
989: else
990: IF p_which_action = 'ORIGINAL' THEN
991: ghr_par_upd.upd(
992: P_PA_REQUEST_ID => p_pa_request_id
993: , P_OBJECT_VERSION_NUMBER => p_par_object_version_number
994: , p_second_noa_canc_pa_request_i => l_pa_req_rec.pa_request_id
995: );

Line 997: ghr_par_upd.upd(

993: , P_OBJECT_VERSION_NUMBER => p_par_object_version_number
994: , p_second_noa_canc_pa_request_i => l_pa_req_rec.pa_request_id
995: );
996: ELSE
997: ghr_par_upd.upd(
998: P_PA_REQUEST_ID => p_pa_request_id
999: , P_OBJECT_VERSION_NUMBER => p_par_object_version_number
1000: , p_second_noa_pa_request_id => l_pa_req_rec.pa_request_id
1001: , p_second_noa_cancel_or_correct => l_noa_cancel_or_correct

Line 1664: ghr_par_upd.upd(

1660: hr_utility.set_location(l_proc || ' Last rows object version # ' || to_char(l_last_pa_request_rec.object_version_number), 20);
1661: hr_utility.set_location('Updating SF52 - OVN '||to_char(l_last_pa_request_rec.object_version_number)|| '-'|| l_proc, 25);
1662: hr_utility.set_location('Updated SF52 - PA Request ID '||to_char(l_last_pa_request_rec.pa_request_id)|| '-'|| l_proc, 26);
1663: if l_which_noa = 1 then
1664: ghr_par_upd.upd(
1665: P_PA_REQUEST_ID => l_last_pa_request_rec.pa_request_id
1666: , P_OBJECT_VERSION_NUMBER => l_last_pa_request_rec.object_version_number
1667: , p_first_noa_pa_request_id => l_last_pa_request_rec.pa_request_id
1668: , p_first_noa_cancel_or_correct => l_noa_cancel_or_correct

Line 1671: ghr_par_upd.upd(

1667: , p_first_noa_pa_request_id => l_last_pa_request_rec.pa_request_id
1668: , p_first_noa_cancel_or_correct => l_noa_cancel_or_correct
1669: );
1670: else
1671: ghr_par_upd.upd(
1672: P_PA_REQUEST_ID => l_last_pa_request_rec.pa_request_id
1673: , P_OBJECT_VERSION_NUMBER => l_last_pa_request_rec.object_version_number
1674: , p_second_noa_pa_request_id => l_last_pa_request_rec.pa_request_id
1675: , p_second_noa_cancel_or_correct => l_noa_cancel_or_correct