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 2086: -- Call ghr_par_upd.upd here

2082: WHEN OTHERS THEN
2083: hr_utility.set_location('Getting Group Box Failure ' || l_proc,170);
2084: l_log_text := 'Error in POI groupbox ' ||' Sql error : '||sqlerrm(sqlcode);
2085:
2086: -- Call ghr_par_upd.upd here
2087:
2088: raise groupboxerr;
2089: end;
2090:

Line 2111: -- Call ghr_par_upd.upd here

2107: p_object_version_number => l_prh_object_version_number);
2108:
2109: hr_utility.set_location('Updating par ' || l_proc,180);
2110:
2111: -- Call ghr_par_upd.upd here
2112: ghr_par_upd.upd(
2113: p_pa_request_id => l_pa_request_rec.pa_request_id,
2114: p_routing_group_id => l_routing_group_id,
2115: p_object_version_number => l_pa_request_rec.object_version_number);

Line 2112: ghr_par_upd.upd(

2108:
2109: hr_utility.set_location('Updating par ' || l_proc,180);
2110:
2111: -- Call ghr_par_upd.upd here
2112: ghr_par_upd.upd(
2113: p_pa_request_id => l_pa_request_rec.pa_request_id,
2114: p_routing_group_id => l_routing_group_id,
2115: p_object_version_number => l_pa_request_rec.object_version_number);
2116:

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

2360: else
2361: l_rpa_action := 'UPDATE_HR';
2362: end if;
2363:
2364: hr_utility.set_location('Action before last ghr_par_upd.upd ' || l_rpa_action || ' ' || l_proc,175);
2365:
2366: ---Bug 2356373
2367: ghr_par_upd.upd
2368: (p_pa_request_id => l_pa_request_rec.pa_request_id,

Line 2367: ghr_par_upd.upd

2363:
2364: hr_utility.set_location('Action before last ghr_par_upd.upd ' || l_rpa_action || ' ' || l_proc,175);
2365:
2366: ---Bug 2356373
2367: ghr_par_upd.upd
2368: (p_pa_request_id => l_pa_request_rec.pa_request_id,
2369: p_object_version_number => l_pa_request_rec.object_version_number,
2370: p_personnel_office_id => l_pa_request_rec.personnel_office_id,
2371: p_employee_dept_or_agency => l_pa_request_rec.employee_dept_or_agency,

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

2375: p_sf50_approving_ofcl_work_tit => l_approving_off_work_title
2376: );
2377: ---Bug 2356373 End
2378:
2379: hr_utility.set_location('Action after last ghr_par_upd.upd ' || l_rpa_action || ' ' || l_proc,175);
2380:
2381: hr_utility.set_location('Action before ' || l_rpa_action || ' ' || l_proc,185);
2382: hr_utility.set_location('PA REQ ID ' || to_char(l_pa_request_rec.pa_request_id) ,185);
2383: hr_utility.set_location('PA OVN ' || to_char(l_pa_request_rec.object_version_number),185);

Line 2458: -- Call ghr_par_upd.upd here

2454: When groupboxerr then
2455: rollback to build_rpa_save_preview;
2456: hr_utility.set_location('rollback grp build_rpa_save_preview ' || l_proc,1);
2457:
2458: -- Call ghr_par_upd.upd here
2459: begin
2460:
2461: get_pa_request_id_ovn
2462: ( p_mass_award_id => p_mass_award_id,

Line 2473: ghr_par_upd.upd(

2469: --Bug#3804067 Added mass action comments
2470: p_mass_action_comments => l_mass_action_comments,
2471: p_object_version_number => l_object_version_number);
2472:
2473: ghr_par_upd.upd(
2474: p_pa_request_id => l_pa_request_id,
2475: p_mass_action_eligible_flag => 'Y',
2476: p_mass_action_select_flag => 'N',
2477: p_mass_action_comments => 'PRG: Programatically Deselected',

Line 3350: -- Call ghr_par_upd.upd here

3346: (p_person_id => l_person_id,
3347: p_effective_date => l_effective_date);
3348: End if;
3349:
3350: -- Call ghr_par_upd.upd here
3351: ghr_par_upd.upd(
3352: p_pa_request_id => l_pa_request_id,
3353: p_rpa_type => 'M',
3354: p_object_version_number => l_object_version_number);

Line 3351: ghr_par_upd.upd(

3347: p_effective_date => l_effective_date);
3348: End if;
3349:
3350: -- Call ghr_par_upd.upd here
3351: ghr_par_upd.upd(
3352: p_pa_request_id => l_pa_request_id,
3353: p_rpa_type => 'M',
3354: p_object_version_number => l_object_version_number);
3355:

Line 3374: ghr_par_upd.upd(

3370:
3371: exception when others then
3372: p_result := TRUE;
3373: begin
3374: ghr_par_upd.upd(
3375: p_pa_request_id => l_pa_request_id,
3376: p_mass_action_eligible_flag => 'Y',
3377: p_mass_action_select_flag => 'N',
3378: p_mass_action_comments =>