DBA Data[Home] [Help]

APPS.GHR_MASS_AWARDS_PKG dependencies on GHR_PAR_UPD

Line 1092: ghr_par_upd.upd(

1088: hr_utility.set_location(l_proc,135);
1089: begin
1090: l_log_text := p_action_type || '-Error After creating the RPA before upd ';
1091: g_log_text := p_action_type || '-Error After creating the RPA before upd ';
1092: ghr_par_upd.upd(
1093: p_pa_request_id => l_pa_request_rec.pa_request_id,
1094: p_object_version_number => l_pa_request_rec.object_version_number,
1095: p_agency_code => l_pa_request_rec.agency_code,
1096: p_employee_dept_or_agency => l_pa_request_rec.employee_dept_or_agency,

Line 1541: ghr_par_upd.upd(

1537: hr_utility.set_location(l_proc,156);
1538: begin
1539: l_log_text := p_action_type || '-Error After updating the RPA before upd ';
1540: g_log_text := p_action_type || '-Error After updating the RPA before upd ';
1541: ghr_par_upd.upd(
1542: p_pa_request_id => l_pa_request_id,
1543: p_object_version_number => l_object_version_number,
1544: p_agency_code => l_pa_request_rec.agency_code,
1545: p_employee_dept_or_agency => l_pa_request_rec.employee_dept_or_agency,

Line 2076: -- Call ghr_par_upd.upd here

2072: WHEN OTHERS THEN
2073: hr_utility.set_location('Getting Group Box Failure ' || l_proc,170);
2074: l_log_text := 'Error in POI groupbox ' ||' Sql error : '||sqlerrm(sqlcode);
2075:
2076: -- Call ghr_par_upd.upd here
2077:
2078: raise groupboxerr;
2079: end;
2080:

Line 2101: -- Call ghr_par_upd.upd here

2097: p_object_version_number => l_prh_object_version_number);
2098:
2099: hr_utility.set_location('Updating par ' || l_proc,180);
2100:
2101: -- Call ghr_par_upd.upd here
2102: ghr_par_upd.upd(
2103: p_pa_request_id => l_pa_request_rec.pa_request_id,
2104: p_routing_group_id => l_routing_group_id,
2105: p_object_version_number => l_pa_request_rec.object_version_number);

Line 2102: ghr_par_upd.upd(

2098:
2099: hr_utility.set_location('Updating par ' || l_proc,180);
2100:
2101: -- Call ghr_par_upd.upd here
2102: ghr_par_upd.upd(
2103: p_pa_request_id => l_pa_request_rec.pa_request_id,
2104: p_routing_group_id => l_routing_group_id,
2105: p_object_version_number => l_pa_request_rec.object_version_number);
2106:

Line 2354: hr_utility.set_location('Action before last ghr_par_upd.upd ' || l_rpa_action || ' ' || l_proc,175);

2350: else
2351: l_rpa_action := 'UPDATE_HR';
2352: end if;
2353:
2354: hr_utility.set_location('Action before last ghr_par_upd.upd ' || l_rpa_action || ' ' || l_proc,175);
2355:
2356: ---Bug 2356373
2357: ghr_par_upd.upd
2358: (p_pa_request_id => l_pa_request_rec.pa_request_id,

Line 2357: ghr_par_upd.upd

2353:
2354: hr_utility.set_location('Action before last ghr_par_upd.upd ' || l_rpa_action || ' ' || l_proc,175);
2355:
2356: ---Bug 2356373
2357: ghr_par_upd.upd
2358: (p_pa_request_id => l_pa_request_rec.pa_request_id,
2359: p_object_version_number => l_pa_request_rec.object_version_number,
2360: p_personnel_office_id => l_pa_request_rec.personnel_office_id,
2361: p_employee_dept_or_agency => l_pa_request_rec.employee_dept_or_agency,

Line 2369: hr_utility.set_location('Action after last ghr_par_upd.upd ' || l_rpa_action || ' ' || l_proc,175);

2365: p_sf50_approving_ofcl_work_tit => l_approving_off_work_title
2366: );
2367: ---Bug 2356373 End
2368:
2369: hr_utility.set_location('Action after last ghr_par_upd.upd ' || l_rpa_action || ' ' || l_proc,175);
2370:
2371: hr_utility.set_location('Action before ' || l_rpa_action || ' ' || l_proc,185);
2372: hr_utility.set_location('PA REQ ID ' || to_char(l_pa_request_rec.pa_request_id) ,185);
2373: hr_utility.set_location('PA OVN ' || to_char(l_pa_request_rec.object_version_number),185);

Line 2448: -- Call ghr_par_upd.upd here

2444: When groupboxerr then
2445: rollback to build_rpa_save_preview;
2446: hr_utility.set_location('rollback grp build_rpa_save_preview ' || l_proc,1);
2447:
2448: -- Call ghr_par_upd.upd here
2449: begin
2450:
2451: get_pa_request_id_ovn
2452: ( p_mass_award_id => p_mass_award_id,

Line 2463: ghr_par_upd.upd(

2459: --Bug#3804067 Added mass action comments
2460: p_mass_action_comments => l_mass_action_comments,
2461: p_object_version_number => l_object_version_number);
2462:
2463: ghr_par_upd.upd(
2464: p_pa_request_id => l_pa_request_id,
2465: p_mass_action_eligible_flag => 'Y',
2466: p_mass_action_select_flag => 'N',
2467: p_mass_action_comments => 'PRG: Programatically Deselected',

Line 3319: -- Call ghr_par_upd.upd here

3315: l_employee_national_identifier := cur_rpa_rec.employee_national_identifier;
3316: hr_utility.set_location('object_version_number = ' ||to_char( l_object_version_number),10);
3317: end loop;
3318:
3319: -- Call ghr_par_upd.upd here
3320: ghr_par_upd.upd(
3321: p_pa_request_id => l_pa_request_id,
3322: p_rpa_type => 'M',
3323: p_object_version_number => l_object_version_number);

Line 3320: ghr_par_upd.upd(

3316: hr_utility.set_location('object_version_number = ' ||to_char( l_object_version_number),10);
3317: end loop;
3318:
3319: -- Call ghr_par_upd.upd here
3320: ghr_par_upd.upd(
3321: p_pa_request_id => l_pa_request_id,
3322: p_rpa_type => 'M',
3323: p_object_version_number => l_object_version_number);
3324:

Line 3342: ghr_par_upd.upd(

3338:
3339: exception when others then
3340: p_result := TRUE;
3341: begin
3342: ghr_par_upd.upd(
3343: p_pa_request_id => l_pa_request_id,
3344: p_mass_action_eligible_flag => 'Y',
3345: p_mass_action_select_flag => 'N',
3346: p_mass_action_comments =>