APPS.GHR_APPROVED_PA_REQUESTS dependencies on GHR_PAR_UPD

Line 1021: ghr_par_upd.upd(

1017: hr_utility.set_location('Updating SF52 - OVN '||to_char(p_par_object_version_number)|| '-'|| l_proc, 25);
1018: hr_utility.set_location(l_proc || 'Which NOA and Action ' || to_char(p_which_noa) || ' '|| p_which_action, 35);
1019: if p_which_noa = 1 then
1020: IF p_which_action = 'ORIGINAL' THEN
1021: ghr_par_upd.upd(
1022: P_PA_REQUEST_ID => p_pa_request_id
1023: , P_OBJECT_VERSION_NUMBER => p_par_object_version_number
1024: , p_first_noa_canc_pa_request_id => l_pa_req_rec.pa_request_id
1025: );

Line 1027: ghr_par_upd.upd(

1023: , P_OBJECT_VERSION_NUMBER => p_par_object_version_number
1024: , p_first_noa_canc_pa_request_id => l_pa_req_rec.pa_request_id
1025: );
1026: ELSE
1027: ghr_par_upd.upd(
1028: P_PA_REQUEST_ID => p_pa_request_id
1029: , P_OBJECT_VERSION_NUMBER => p_par_object_version_number
1030: , p_first_noa_pa_request_id => l_pa_req_rec.pa_request_id
1031: , p_first_noa_cancel_or_correct => l_noa_cancel_or_correct

Line 1036: ghr_par_upd.upd(

1032: );
1033: END IF;
1034: else
1035: IF p_which_action = 'ORIGINAL' THEN
1036: ghr_par_upd.upd(
1037: P_PA_REQUEST_ID => p_pa_request_id
1038: , P_OBJECT_VERSION_NUMBER => p_par_object_version_number
1039: , p_second_noa_canc_pa_request_i => l_pa_req_rec.pa_request_id
1040: );

Line 1042: ghr_par_upd.upd(

1038: , P_OBJECT_VERSION_NUMBER => p_par_object_version_number
1039: , p_second_noa_canc_pa_request_i => l_pa_req_rec.pa_request_id
1040: );
1041: ELSE
1042: ghr_par_upd.upd(
1043: P_PA_REQUEST_ID => p_pa_request_id
1044: , P_OBJECT_VERSION_NUMBER => p_par_object_version_number
1045: , p_second_noa_pa_request_id => l_pa_req_rec.pa_request_id
1046: , p_second_noa_cancel_or_correct => l_noa_cancel_or_correct

Line 1752: ghr_par_upd.upd(

1748: hr_utility.set_location(l_proc || ' Last rows object version # ' || to_char(l_last_pa_request_rec.object_version_number), 20);
1749: hr_utility.set_location('Updating SF52 - OVN '||to_char(l_last_pa_request_rec.object_version_number)|| '-'|| l_proc, 25);
1750: hr_utility.set_location('Updated SF52 - PA Request ID '||to_char(l_last_pa_request_rec.pa_request_id)|| '-'|| l_proc, 26);
1751: if l_which_noa = 1 then
1752: ghr_par_upd.upd(
1753: P_PA_REQUEST_ID => l_last_pa_request_rec.pa_request_id
1754: , P_OBJECT_VERSION_NUMBER => l_last_pa_request_rec.object_version_number
1755: , p_first_noa_pa_request_id => l_last_pa_request_rec.pa_request_id
1756: , p_first_noa_cancel_or_correct => l_noa_cancel_or_correct

Line 1759: ghr_par_upd.upd(

1755: , p_first_noa_pa_request_id => l_last_pa_request_rec.pa_request_id
1756: , p_first_noa_cancel_or_correct => l_noa_cancel_or_correct
1757: );
1758: else
1759: ghr_par_upd.upd(
1760: P_PA_REQUEST_ID => l_last_pa_request_rec.pa_request_id
1761: , P_OBJECT_VERSION_NUMBER => l_last_pa_request_rec.object_version_number
1762: , p_second_noa_pa_request_id => l_last_pa_request_rec.pa_request_id
1763: , p_second_noa_cancel_or_correct => l_noa_cancel_or_correct

Line 2092: ghr_par_upd.upd(p_pa_request_id => p_first_dual_action_id

2088: l_ovn2 := rec_get_ovn.object_version_number;
2089: end loop;
2090:
2091:
2092: ghr_par_upd.upd(p_pa_request_id => p_first_dual_action_id
2093: ,p_object_version_number => l_ovn1
2094: ,p_mass_action_id => p_second_dual_action_id
2095: ,p_rpa_type => 'DUAL');
2096:

Line 2097: ghr_par_upd.upd(p_pa_request_id => p_second_dual_action_id

2093: ,p_object_version_number => l_ovn1
2094: ,p_mass_action_id => p_second_dual_action_id
2095: ,p_rpa_type => 'DUAL');
2096:
2097: ghr_par_upd.upd(p_pa_request_id => p_second_dual_action_id
2098: ,p_object_version_number => l_ovn2
2099: ,p_mass_action_id => p_first_dual_action_id
2100: ,p_rpa_type => 'DUAL');
2101: