eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_MASS_SEL_NOA dependencies on GHR_PA_REQUESTS

Line 20: l_p_personnel_office_id ghr_pa_requests.personnel_office_id%type;

16: l_target_job_id ghr_mass_salaries.target_job_id%type;
17: l_target_agency_code_subelmt ghr_mass_salaries.target_agency_code_subelement%type;
18: l_target_duty_station_id ghr_mass_salaries.target_duty_station_id%type;
19: l_target_duty_station_code ghr_mass_salaries.target_duty_station_code%type;
20: l_p_personnel_office_id ghr_pa_requests.personnel_office_id%type;
21: l_target_functional_class ghr_mass_salaries.target_functional_class%type;--Bug# 14410401
22: -- Begin Bug# 14751973
23: l_target_duty_station_desc varchar2(150);
24: l_old_barg_unit_status ghr_mass_salaries.target_bargaining_unit_status%type;

Line 53: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;

49: , p_effective_date IN date
50: , p_first_noa_code IN varchar2) RETURN boolean IS
51:
52: l_name per_people_f.full_name%TYPE;
53: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
54: l_employee_number per_people_f.employee_number%TYPE;
55:
56: CURSOR csr_action_taken IS
57: SELECT pr.pa_request_id

Line 59: FROM ghr_pa_requests pr

55:
56: CURSOR csr_action_taken IS
57: SELECT pr.pa_request_id
58: , max (pa_routing_history_id) pa_routing_history_id
59: FROM ghr_pa_requests pr
60: , ghr_pa_routing_history prh
61: WHERE pr.pa_request_id = prh.pa_request_id
62: AND person_id = p_person_id
63: AND first_noa_code = p_first_noa_code

Line 72: FROM ghr_pa_requests pr

68: SELECT substr (pr.employee_last_name
69: || ', '
70: || pr.employee_first_name, 1
71: , 240) fname
72: FROM ghr_pa_requests pr
73: WHERE pr.pa_request_id = l_pa_request_id;
74: CURSOR pa_hist_cur
75: (p_r_hist_id IN number) IS
76: SELECT nvl (action_taken, ' ') action_taken

Line 100: l_employee_number := ghr_pa_requests_pkg2.get_employee_number

96: EXIT;
97: END LOOP;
98:
99: IF p_person_id IS NOT NULL THEN
100: l_employee_number := ghr_pa_requests_pkg2.get_employee_number
101: (p_person_id => p_person_id
102: , p_effective_date => p_effective_date);
103: END IF;
104:

Line 311: (p_noa_action IN ghr_pa_requests.first_noa_code%TYPE

307: RAISE mnoa_error;
308: END get_extra_info_comments;
309:
310: PROCEDURE refresh_ei_details
311: (p_noa_action IN ghr_pa_requests.first_noa_code%TYPE
312: , p_effective_date IN date
313: , p_person_id IN per_people_f.person_id%TYPE
314: , p_work_schedule IN ghr_pa_requests.work_schedule%TYPE
315: , p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE) IS

Line 314: , p_work_schedule IN ghr_pa_requests.work_schedule%TYPE

310: PROCEDURE refresh_ei_details
311: (p_noa_action IN ghr_pa_requests.first_noa_code%TYPE
312: , p_effective_date IN date
313: , p_person_id IN per_people_f.person_id%TYPE
314: , p_work_schedule IN ghr_pa_requests.work_schedule%TYPE
315: , p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE) IS
316:
317: l_proc varchar2(72);
318: l_pa_request_extra_info_id number;

Line 315: , p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE) IS

311: (p_noa_action IN ghr_pa_requests.first_noa_code%TYPE
312: , p_effective_date IN date
313: , p_person_id IN per_people_f.person_id%TYPE
314: , p_work_schedule IN ghr_pa_requests.work_schedule%TYPE
315: , p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE) IS
316:
317: l_proc varchar2(72);
318: l_pa_request_extra_info_id number;
319: l_pa_request_extra_info_sh_id number;

Line 329: l_rpa_position_id ghr_pa_requests.from_position_id%type;

325: l_pa_rei_id number;
326: l_rpa_eff_date date;
327: l_rpa_nte_date date;
328: --Bug# 14456039
329: l_rpa_position_id ghr_pa_requests.from_position_id%type;
330: l_pos_agency_code ghr_pa_requests.agency_code%type;
331: l_eit_agency ghr_pa_request_extra_info.rei_information4%type;
332: l_eit_poi ghr_pa_request_extra_info.rei_information3%type;
333: l_eit_poi_dt ghr_pa_request_extra_info.rei_information5%type;

Line 330: l_pos_agency_code ghr_pa_requests.agency_code%type;

326: l_rpa_eff_date date;
327: l_rpa_nte_date date;
328: --Bug# 14456039
329: l_rpa_position_id ghr_pa_requests.from_position_id%type;
330: l_pos_agency_code ghr_pa_requests.agency_code%type;
331: l_eit_agency ghr_pa_request_extra_info.rei_information4%type;
332: l_eit_poi ghr_pa_request_extra_info.rei_information3%type;
333: l_eit_poi_dt ghr_pa_request_extra_info.rei_information5%type;
334:

Line 353: FROM ghr_pa_requests

349:
350: CURSOR cur_rpa_dtl
351: (p_pa_request_id IN number) IS
352: SELECT *
353: FROM ghr_pa_requests
354: WHERE pa_request_id = p_pa_request_id;
355:
356: BEGIN
357: g_proc := 'refresh_ei_details';

Line 660: l_occ_series ghr_pa_requests.from_occ_code%type;

656: l_position_title varchar2(300);
657: l_position_number varchar2(20);
658: l_position_seq_no varchar2(20);
659: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
660: l_occ_series ghr_pa_requests.from_occ_code%type;
661: l_mnoa_occ_series ghr_pa_requests.from_occ_code%type;
662: l_bargaining_unit ghr_pa_requests.bargaining_unit_status%type;
663: l_flsa_category ghr_pa_requests.flsa_category%type;
664: l_fetch_poid_data boolean DEFAULT FALSE;

Line 661: l_mnoa_occ_series ghr_pa_requests.from_occ_code%type;

657: l_position_number varchar2(20);
658: l_position_seq_no varchar2(20);
659: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
660: l_occ_series ghr_pa_requests.from_occ_code%type;
661: l_mnoa_occ_series ghr_pa_requests.from_occ_code%type;
662: l_bargaining_unit ghr_pa_requests.bargaining_unit_status%type;
663: l_flsa_category ghr_pa_requests.flsa_category%type;
664: l_fetch_poid_data boolean DEFAULT FALSE;
665: l_fetch_ds_data boolean DEFAULT FALSE;

Line 662: l_bargaining_unit ghr_pa_requests.bargaining_unit_status%type;

658: l_position_seq_no varchar2(20);
659: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
660: l_occ_series ghr_pa_requests.from_occ_code%type;
661: l_mnoa_occ_series ghr_pa_requests.from_occ_code%type;
662: l_bargaining_unit ghr_pa_requests.bargaining_unit_status%type;
663: l_flsa_category ghr_pa_requests.flsa_category%type;
664: l_fetch_poid_data boolean DEFAULT FALSE;
665: l_fetch_ds_data boolean DEFAULT FALSE;
666: l_fetch_agency_data boolean DEFAULT FALSE;

Line 663: l_flsa_category ghr_pa_requests.flsa_category%type;

659: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
660: l_occ_series ghr_pa_requests.from_occ_code%type;
661: l_mnoa_occ_series ghr_pa_requests.from_occ_code%type;
662: l_bargaining_unit ghr_pa_requests.bargaining_unit_status%type;
663: l_flsa_category ghr_pa_requests.flsa_category%type;
664: l_fetch_poid_data boolean DEFAULT FALSE;
665: l_fetch_ds_data boolean DEFAULT FALSE;
666: l_fetch_agency_data boolean DEFAULT FALSE;
667: l_fetch_occ_data boolean DEFAULT FALSE;

Line 730: ghr_pa_requests_pkg.get_sf52_loc_ddf_details

726: hr_utility.set_location ('Agency PASS', 30);
727:
728: IF p_mnoa_duty_station_id IS NOT NULL THEN
729: hr_utility.set_location ('DS CHECK', 35);
730: ghr_pa_requests_pkg.get_sf52_loc_ddf_details
731: (p_location_id => l_location_id
732: , p_duty_station_id => l_duty_station_id);
733: l_fetch_ds_data := TRUE;
734: END IF;

Line 748: l_occ_series := ghr_pa_requests_pkg.get_occ_series(l_position_id,l_effective_date,l_business_group_id);

744:
745: l_mnoa_occ_series := ghr_api.get_job_occ_series_job
746: (p_job_id => p_mnoa_job_id
747: ,p_business_group_id => l_business_group_id);
748: l_occ_series := ghr_pa_requests_pkg.get_occ_series(l_position_id,l_effective_date,l_business_group_id);
749: l_fetch_occ_data := TRUE;
750: END IF;
751: IF (l_mnoa_occ_series = l_occ_series) OR NOT(l_fetch_occ_data) THEN
752: hr_utility.set_location ('OCC PASS', 35);

Line 755: l_bargaining_unit:= ghr_pa_requests_pkg.get_bargaining_unit(p_position_id,l_effective_date);

751: IF (l_mnoa_occ_series = l_occ_series) OR NOT(l_fetch_occ_data) THEN
752: hr_utility.set_location ('OCC PASS', 35);
753: IF p_mnoa_bargaining_unit IS NOT NULL THEN
754: hr_utility.set_location ('Bargaining Unit CHECK', 35);
755: l_bargaining_unit:= ghr_pa_requests_pkg.get_bargaining_unit(p_position_id,l_effective_date);
756: l_fetch_bu_data := TRUE;
757: END IF;
758: IF (p_mnoa_bargaining_unit = l_bargaining_unit) OR NOT(l_fetch_bu_data) THEN
759: hr_utility.set_location ('BU PASS', 30);

Line 762: l_flsa_category:= ghr_pa_requests_pkg.get_flsa_category(p_position_id,l_effective_date);

758: IF (p_mnoa_bargaining_unit = l_bargaining_unit) OR NOT(l_fetch_bu_data) THEN
759: hr_utility.set_location ('BU PASS', 30);
760: IF p_mnoa_flsa_category IS NOT NULL THEN
761: hr_utility.set_location ('FLSA Category CHECK', 35);
762: l_flsa_category:= ghr_pa_requests_pkg.get_flsa_category(p_position_id,l_effective_date);
763: l_fetch_flsa_data := TRUE;
764: END IF;
765: IF (p_mnoa_flsa_category = l_flsa_category) OR NOT(l_fetch_flsa_data) THEN
766: hr_utility.set_location ('FLSA PASS', 40);

Line 815: ghr_pa_requests_pkg.get_sf52_loc_ddf_details

811: p_first_noa_code => l_noa_code
812: )) then
813: --End Bug# 14805985
814: IF NOT l_fetch_ds_data THEN
815: ghr_pa_requests_pkg.get_sf52_loc_ddf_details
816: (p_location_id => l_location_id
817: , p_duty_station_id => l_duty_station_id);
818: END IF;
819:

Line 820: ghr_pa_requests_pkg.get_sf52_asg_ddf_details (l_assignment_id, l_effective_date

816: (p_location_id => l_location_id
817: , p_duty_station_id => l_duty_station_id);
818: END IF;
819:
820: ghr_pa_requests_pkg.get_sf52_asg_ddf_details (l_assignment_id, l_effective_date
821: , l_tenure, l_annuitant_indicator
822: , l_pay_rate_determinant, l_work_schedule
823: , l_part_time_hour);
824:

Line 1402: , p_sf52_rec OUT NOCOPY ghr_pa_requests%ROWTYPE) IS

1398: END ins_upd_per_extra_info;
1399:
1400: PROCEDURE get_lac_dtls
1401: (p_pa_request_id IN number
1402: , p_sf52_rec OUT NOCOPY ghr_pa_requests%ROWTYPE) IS
1403:
1404: l_proc varchar2(72) DEFAULT g_package|| '.get_lac_dtls';
1405: CURSOR cur_pa_req_cur IS
1406: SELECT *

Line 1407: FROM ghr_pa_requests

1403:
1404: l_proc varchar2(72) DEFAULT g_package|| '.get_lac_dtls';
1405: CURSOR cur_pa_req_cur IS
1406: SELECT *
1407: FROM ghr_pa_requests
1408: WHERE pa_request_id = p_pa_request_id;
1409: BEGIN
1410: g_proc := 'get_lac_dtls';
1411:

Line 1521: l_duty_station_desc ghr_pa_requests.duty_station_desc%TYPE;

1517: l_step_or_rate varchar2(30);
1518: l_pay_basis varchar2(30);
1519: l_location_id number;
1520: l_duty_station_id number;
1521: l_duty_station_desc ghr_pa_requests.duty_station_desc%TYPE;
1522: l_duty_station_code ghr_pa_requests.duty_station_code%TYPE;
1523: l_effective_date date;
1524: l_p_locality_area_code ghr_mass_salaries.locality_pay_area_code%TYPE;
1525: l_personnel_office_id varchar2(300);

Line 1522: l_duty_station_code ghr_pa_requests.duty_station_code%TYPE;

1518: l_pay_basis varchar2(30);
1519: l_location_id number;
1520: l_duty_station_id number;
1521: l_duty_station_desc ghr_pa_requests.duty_station_desc%TYPE;
1522: l_duty_station_code ghr_pa_requests.duty_station_code%TYPE;
1523: l_effective_date date;
1524: l_p_locality_area_code ghr_mass_salaries.locality_pay_area_code%TYPE;
1525: l_personnel_office_id varchar2(300);
1526: l_org_structure_id varchar2(300);

Line 1573: l_p_job_id ghr_pa_requests.from_occ_code%type;

1569: l_pa_request_id number;
1570: l_rowid varchar2(30);
1571: l_p_organization_id number;
1572: l_p_duty_station_id number;
1573: l_p_job_id ghr_pa_requests.from_occ_code%type;
1574: l_p_bargaining_unit ghr_pa_requests.bargaining_unit_status%type;
1575: l_p_flsa_category ghr_pa_requests.flsa_category%type;
1576: l_row_cnt number DEFAULT 0;
1577: l_sf52_rec ghr_pa_requests%ROWTYPE;

Line 1574: l_p_bargaining_unit ghr_pa_requests.bargaining_unit_status%type;

1570: l_rowid varchar2(30);
1571: l_p_organization_id number;
1572: l_p_duty_station_id number;
1573: l_p_job_id ghr_pa_requests.from_occ_code%type;
1574: l_p_bargaining_unit ghr_pa_requests.bargaining_unit_status%type;
1575: l_p_flsa_category ghr_pa_requests.flsa_category%type;
1576: l_row_cnt number DEFAULT 0;
1577: l_sf52_rec ghr_pa_requests%ROWTYPE;
1578: l_lac_sf52_rec ghr_pa_requests%ROWTYPE;

Line 1575: l_p_flsa_category ghr_pa_requests.flsa_category%type;

1571: l_p_organization_id number;
1572: l_p_duty_station_id number;
1573: l_p_job_id ghr_pa_requests.from_occ_code%type;
1574: l_p_bargaining_unit ghr_pa_requests.bargaining_unit_status%type;
1575: l_p_flsa_category ghr_pa_requests.flsa_category%type;
1576: l_row_cnt number DEFAULT 0;
1577: l_sf52_rec ghr_pa_requests%ROWTYPE;
1578: l_lac_sf52_rec ghr_pa_requests%ROWTYPE;
1579: l_errbuf varchar2(2000);

Line 1577: l_sf52_rec ghr_pa_requests%ROWTYPE;

1573: l_p_job_id ghr_pa_requests.from_occ_code%type;
1574: l_p_bargaining_unit ghr_pa_requests.bargaining_unit_status%type;
1575: l_p_flsa_category ghr_pa_requests.flsa_category%type;
1576: l_row_cnt number DEFAULT 0;
1577: l_sf52_rec ghr_pa_requests%ROWTYPE;
1578: l_lac_sf52_rec ghr_pa_requests%ROWTYPE;
1579: l_errbuf varchar2(2000);
1580: l_retcode number;
1581: l_pos_ei_data per_position_extra_info%ROWTYPE;

Line 1578: l_lac_sf52_rec ghr_pa_requests%ROWTYPE;

1574: l_p_bargaining_unit ghr_pa_requests.bargaining_unit_status%type;
1575: l_p_flsa_category ghr_pa_requests.flsa_category%type;
1576: l_row_cnt number DEFAULT 0;
1577: l_sf52_rec ghr_pa_requests%ROWTYPE;
1578: l_lac_sf52_rec ghr_pa_requests%ROWTYPE;
1579: l_errbuf varchar2(2000);
1580: l_retcode number;
1581: l_pos_ei_data per_position_extra_info%ROWTYPE;
1582: l_pay_calc_in_data ghr_pay_calc.pay_calc_in_rec_type;

Line 1991: CURSOR get_loc_id(c_duty_station_code ghr_pa_requests.duty_station_code%type) IS

1987: )
1988: )
1989: AND proc_method_flag = 'Y';
1990:
1991: CURSOR get_loc_id(c_duty_station_code ghr_pa_requests.duty_station_code%type) IS
1992: SELECT lei.location_id location_id
1993: FROM hr_location_extra_info lei, ghr_duty_stations_v ds
1994: WHERE ds.duty_station_code = c_duty_station_code
1995: AND lei.information_type = 'GHR_US_LOC_INFORMATION'

Line 2039: l_vac_duty_location_id ghr_pa_requests.duty_station_location_id%TYPE;

2035: l_proc varchar2(72) DEFAULT g_package
2036: || 'vacant_pos_process';
2037: l_vac_flsa_category per_position_extra_info.poei_information7%TYPE;
2038: l_vac_barg_unit_status per_position_extra_info.poei_information8%TYPE;
2039: l_vac_duty_location_id ghr_pa_requests.duty_station_location_id%TYPE;
2040: l_vac_functional_class per_position_extra_info.poei_information11%TYPE;
2041: -- Begin Bug# 14751973
2042: l_vac_duty_station_code ghr_mass_salaries.target_duty_station_code%type;
2043: l_vac_duty_station_desc varchar2(150);

Line 2095: ghr_pa_requests_pkg.get_duty_station_details

2091: l_grade_or_level := c_grade_kff_rec.segment2;
2092: EXIT;
2093: END LOOP;
2094: BEGIN
2095: ghr_pa_requests_pkg.get_duty_station_details
2096: (p_duty_station_id => l_duty_station_id
2097: , p_effective_date => l_effective_date
2098: , p_duty_station_code => l_duty_station_code
2099: , p_duty_station_desc => l_duty_station_desc);

Line 2105: hr_utility.set_location ('Error in Ghr_pa_requests_pkg.get_duty_station_details'

2101: hr_utility.set_location ('The duty station name is:'
2102: || l_duty_station_code, 12345);
2103: EXCEPTION
2104: WHEN others THEN
2105: hr_utility.set_location ('Error in Ghr_pa_requests_pkg.get_duty_station_details'
2106: || 'Err is '
2107: || sqlerrm (sqlcode), 20);
2108:
2109: l_noaerrbuf := 'Error in get_duty_station_details Sql Err is '

Line 2115: ghr_pa_requests_pkg.get_duty_station_details

2111: RAISE mnoa_error;
2112: END;
2113: --Begin Bug# 14751973
2114: BEGIN
2115: ghr_pa_requests_pkg.get_duty_station_details
2116: (p_duty_station_id => l_target_duty_station_id
2117: , p_effective_date => l_effective_date
2118: , p_duty_station_code => l_vac_duty_station_code
2119: , p_duty_station_desc => l_vac_duty_station_desc);

Line 2125: hr_utility.set_location ('Error in Target get Ghr_pa_requests_pkg.get_duty_station_details'

2121: hr_utility.set_location ('The target duty station name is:'
2122: || l_vac_duty_station_code, 12345);
2123: EXCEPTION
2124: WHEN others THEN
2125: hr_utility.set_location ('Error in Target get Ghr_pa_requests_pkg.get_duty_station_details'
2126: || 'Err is '
2127: || sqlerrm (sqlcode), 20);
2128:
2129: l_noaerrbuf := 'Error in Target get duty_station_details Sql Err is '

Line 2141: ghr_pa_requests_pkg.get_sf52_pos_ddf_details

2137:
2138: BEGIN
2139: IF upper (p_action) IN ('SHOW') THEN
2140: -- Begin Bug# 14751973
2141: ghr_pa_requests_pkg.get_sf52_pos_ddf_details
2142: (p_position_id => l_position_id
2143: ,p_date_Effective => l_effective_date
2144: ,p_flsa_category => l_vac_flsa_category
2145: ,p_bargaining_unit_status => l_vac_barg_unit_status

Line 2156: l_vac_occ_code := ghr_pa_requests_pkg.get_occ_series(l_position_id,l_effective_date,l_business_group_id);

2152: ,p_personnel_office_id => l_dummy
2153: ,p_office_symbol => l_dummy
2154: ,p_part_time_hours => l_dummy
2155: );
2156: l_vac_occ_code := ghr_pa_requests_pkg.get_occ_series(l_position_id,l_effective_date,l_business_group_id);
2157:
2158: create_mass_noa_prev
2159: (p_effective_date => l_effective_date
2160: , p_date_of_birth => p_date_of_birth

Line 2532: ghr_pa_requests_pkg.get_duty_station_details

2528: l_duty_station_id := l_target_duty_station_id;
2529: ELSE
2530: l_duty_station_id := l_duty_station_id;
2531: END IF;*/
2532: ghr_pa_requests_pkg.get_duty_station_details
2533: (p_duty_station_id => l_duty_station_id
2534: , p_effective_date => l_effective_date
2535: , p_duty_station_code => l_duty_station_code
2536: , p_duty_station_desc => l_duty_station_desc);

Line 2543: hr_utility.set_location ('Error in Ghr_pa_requests_pkg.get_duty_station_details'|| 'Err is '|| sqlerrm (sqlcode), 20);

2539:
2540: hr_utility.set_location ('The duty station desc is:'|| l_duty_station_desc, 12345);
2541: EXCEPTION
2542: WHEN others THEN
2543: hr_utility.set_location ('Error in Ghr_pa_requests_pkg.get_duty_station_details'|| 'Err is '|| sqlerrm (sqlcode), 20);
2544: l_noaerrbuf := 'Error in get_duty_station_details Sql Err is '|| sqlerrm (sqlcode);
2545: RAISE mnoa_error;
2546: END;
2547: -- Begin Bug# 14751973

Line 2550: ghr_pa_requests_pkg.get_duty_station_details

2546: END;
2547: -- Begin Bug# 14751973
2548: IF l_target_duty_station_id IS NOT NULL THEN
2549: BEGIN
2550: ghr_pa_requests_pkg.get_duty_station_details
2551: (p_duty_station_id => l_target_duty_station_id
2552: , p_effective_date => l_effective_date
2553: , p_duty_station_code => l_target_duty_station_code
2554: , p_duty_station_desc => l_target_duty_station_desc);

Line 2559: hr_utility.set_location ('Error in Target Ghr_pa_requests_pkg.get_duty_station_details'|| 'Err is '|| sqlerrm (sqlcode), 20);

2555:
2556: hr_utility.set_location ('The Target duty station name is:'|| l_target_duty_station_code, 12346);
2557: EXCEPTION
2558: WHEN others THEN
2559: hr_utility.set_location ('Error in Target Ghr_pa_requests_pkg.get_duty_station_details'|| 'Err is '|| sqlerrm (sqlcode), 20);
2560: l_noaerrbuf := 'Error in Target get_duty_station_details Sql Err is '|| sqlerrm (sqlcode);
2561: RAISE mnoa_error;
2562: END;
2563: END IF;

Line 2716: l_capped_other_pay := ghr_pa_requests_pkg2.get_cop

2712:
2713: l_new_total_salary := l_pay_calc_out_data.total_salary;
2714:
2715: BEGIN
2716: l_capped_other_pay := ghr_pa_requests_pkg2.get_cop
2717: (p_assignment_id => l_assignment_id
2718: , p_effective_date => l_effective_date);
2719:
2720: l_old_capped_other_pay := l_capped_other_pay;

Line 2870: ghr_pa_requests_pkg.get_sf52_pos_ddf_details

2866: IF upper (p_action) IN ('SHOW', 'REPORT') THEN
2867: hr_utility.set_location ('Calling create_mass_noa_prev in p_action '|| p_action, 1331);
2868: -- Begin Bug# 14751973
2869: IF l_noa_code IN ('800','792') THEN
2870: ghr_pa_requests_pkg.get_sf52_pos_ddf_details
2871: (p_position_id => l_position_id
2872: ,p_date_Effective => l_effective_date
2873: ,p_flsa_category => l_old_flsa_category
2874: ,p_bargaining_unit_status => l_old_barg_unit_status

Line 2886: l_old_occ_code := ghr_pa_requests_pkg.get_occ_series(l_position_id,l_effective_date,l_business_group_id);

2882: ,p_office_symbol => l_dummy
2883: ,p_part_time_hours => l_dummy
2884: );
2885: IF l_noa_code ='800' THEN
2886: l_old_occ_code := ghr_pa_requests_pkg.get_occ_series(l_position_id,l_effective_date,l_business_group_id);
2887: ELSIF l_noa_code ='792' THEN
2888: l_old_flsa_category := NULL;
2889: l_old_functional_class := NULL;
2890: END IF;

Line 3014: l_pa_request_number ghr_pa_requests.request_number%TYPE;

3010: , p_errbuf => l_errbuf
3011: , p_retcode => l_retcode);
3012:
3013: DECLARE
3014: l_pa_request_number ghr_pa_requests.request_number%TYPE;
3015: BEGIN
3016: l_pa_request_number := l_sf52_rec.request_number|| '-'|| p_mass_salary_id;
3017: ghr_par_upd.upd
3018: (p_pa_request_id => l_sf52_rec.pa_request_id

Line 3720: IF ghr_pa_requests_pkg.get_work_schedule (per.position_id, l_effective_date) IN ('G', 'J', 'Q', 'T') THEN

3716: l_step_or_rate := NULL;
3717: l_pay_basis := NULL;
3718: l_elig_flag := FALSE;
3719: l_org_name := ghr_mre_pkg.get_organization_name (per.organization_id);
3720: IF ghr_pa_requests_pkg.get_work_schedule (per.position_id, l_effective_date) IN ('G', 'J', 'Q', 'T') THEN
3721: BEGIN
3722: hr_utility.set_location ('Calling fetch_and_validate_emp '|| l_noa_code, 2237);
3723:
3724: fetch_and_validate_emp

Line 4158: IF ghr_pa_requests_pkg.get_pos_availability_status (l_avail_status_id) NOT IN ('DELETED', 'FROZEN', 'ELIMINATED') THEN

4154: END LOOP;
4155: FOR c_vacant_pos IN vacant_pos (cur_business_group_id, l_effective_date) LOOP
4156: l_avail_status_id := c_vacant_pos.availability_status_id;
4157:
4158: IF ghr_pa_requests_pkg.get_pos_availability_status (l_avail_status_id) NOT IN ('DELETED', 'FROZEN', 'ELIMINATED') THEN
4159: BEGIN
4160: l_personnel_office_id := NULL;
4161: l_org_structure_id := NULL;
4162: l_position_title := NULL;

Line 4369: l_pa_req_rec ghr_pa_requests%ROWTYPE;

4365: l_name per_people_f.full_name%TYPE;
4366: l_employee_number per_people_f.employee_number%TYPE;
4367: l_total_recs number DEFAULT 0;
4368: l_recs_failed number DEFAULT 0;
4369: l_pa_req_rec ghr_pa_requests%ROWTYPE;
4370: l_effective_date date;
4371: l_submit_flag varchar2(2);
4372: l_row_cnt number DEFAULT 0;
4373: l_ovn number;

Line 4374: l_lac_sf52_rec ghr_pa_requests%ROWTYPE;

4370: l_effective_date date;
4371: l_submit_flag varchar2(2);
4372: l_row_cnt number DEFAULT 0;
4373: l_ovn number;
4374: l_lac_sf52_rec ghr_pa_requests%ROWTYPE;
4375: l_errbuf varchar2(2000);
4376: l_retcode number;
4377: p_full_name per_people_f.full_name%TYPE;
4378: p_employee_number per_people_f.employee_number%TYPE;

Line 4379: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;

4375: l_errbuf varchar2(2000);
4376: l_retcode number;
4377: p_full_name per_people_f.full_name%TYPE;
4378: p_employee_number per_people_f.employee_number%TYPE;
4379: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
4380: l_groupbox_id ghr_groupboxes.groupbox_id%TYPE;
4381: l_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;
4382: l_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
4383: l_u_prh_object_version_number number;

Line 4386: l_object_version_number ghr_pa_requests.object_version_number%TYPE;

4382: l_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
4383: l_u_prh_object_version_number number;
4384: l_i_pa_routing_history_id number;
4385: l_i_prh_object_version_number number;
4386: l_object_version_number ghr_pa_requests.object_version_number%TYPE;
4387: l_personnel_officer_name per_people_f.full_name%TYPE;
4388: l_approving_off_work_title ghr_pa_requests.approving_official_work_title%TYPE;
4389: rec_busy EXCEPTION;
4390: PRAGMA EXCEPTION_INIT(rec_busy, -54);

Line 4388: l_approving_off_work_title ghr_pa_requests.approving_official_work_title%TYPE;

4384: l_i_pa_routing_history_id number;
4385: l_i_prh_object_version_number number;
4386: l_object_version_number ghr_pa_requests.object_version_number%TYPE;
4387: l_personnel_officer_name per_people_f.full_name%TYPE;
4388: l_approving_off_work_title ghr_pa_requests.approving_official_work_title%TYPE;
4389: rec_busy EXCEPTION;
4390: PRAGMA EXCEPTION_INIT(rec_busy, -54);
4391: l_proc varchar2(72) DEFAULT 'GHR_MASS_CANCEL.'|| '.execute_mcancel';
4392: CURSOR ghr_mcancel

Line 4406: (p_mass_action_id IN ghr_pa_requests.mass_action_id%TYPE

4402: WHERE mass_salary_id = p_mcan_id
4403: FOR UPDATE OF user_table_id NOWAIT;
4404:
4405: CURSOR cur_can_records
4406: (p_mass_action_id IN ghr_pa_requests.mass_action_id%TYPE
4407: , p_effective_date IN date) IS
4408: SELECT *
4409: FROM ghr_pa_requests a
4410: WHERE a.effective_date = p_effective_date

Line 4409: FROM ghr_pa_requests a

4405: CURSOR cur_can_records
4406: (p_mass_action_id IN ghr_pa_requests.mass_action_id%TYPE
4407: , p_effective_date IN date) IS
4408: SELECT *
4409: FROM ghr_pa_requests a
4410: WHERE a.effective_date = p_effective_date
4411: AND a.mass_action_id = p_mass_action_id
4412: AND a.pa_notification_id IS NOT NULL
4413: AND NOT EXISTS

Line 4416: FROM ghr_pa_requests b

4412: AND a.pa_notification_id IS NOT NULL
4413: AND NOT EXISTS
4414: (
4415: SELECT 1
4416: FROM ghr_pa_requests b
4417: WHERE b.first_noa_code IN ('001')
4418: AND b.person_id = a.person_id
4419: AND b.pa_notification_id IS NOT NULL
4420: START WITH pa_request_id = a.pa_request_id

Line 4425: (p_mass_action_id IN ghr_pa_requests.mass_action_id%TYPE

4421: AND altered_pa_request_id IS NULL
4422: CONNECT BY altered_pa_request_id = PRIOR pa_request_id
4423: );
4424: CURSOR cur_get_dtl
4425: (p_mass_action_id IN ghr_pa_requests.mass_action_id%TYPE
4426: , p_effective_date IN date) IS
4427: SELECT substr (employee_last_name|| ', '|| employee_first_name, 1, 240) fname,person_id
4428: FROM ghr_pa_requests
4429: WHERE effective_date = p_effective_date

Line 4428: FROM ghr_pa_requests

4424: CURSOR cur_get_dtl
4425: (p_mass_action_id IN ghr_pa_requests.mass_action_id%TYPE
4426: , p_effective_date IN date) IS
4427: SELECT substr (employee_last_name|| ', '|| employee_first_name, 1, 240) fname,person_id
4428: FROM ghr_pa_requests
4429: WHERE effective_date = p_effective_date
4430: AND mass_action_id = p_mass_action_id;
4431:
4432: CURSOR cur_pa_rowid

Line 4433: (p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE) IS

4429: WHERE effective_date = p_effective_date
4430: AND mass_action_id = p_mass_action_id;
4431:
4432: CURSOR cur_pa_rowid
4433: (p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE) IS
4434: SELECT rowid
4435: , object_version_number
4436: FROM ghr_pa_requests a
4437: WHERE pa_request_id = p_pa_request_id;

Line 4436: FROM ghr_pa_requests a

4432: CURSOR cur_pa_rowid
4433: (p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE) IS
4434: SELECT rowid
4435: , object_version_number
4436: FROM ghr_pa_requests a
4437: WHERE pa_request_id = p_pa_request_id;
4438:
4439: CURSOR cur_ppl_dtl
4440: (p_person_id IN number

Line 4460: FROM ghr_pa_requests

4456:
4457: CURSOR c_req_num IS
4458: SELECT request_number
4459: , object_version_number
4460: FROM ghr_pa_requests
4461: WHERE pa_request_id = l_can_pa_request_id
4462: ORDER BY 1 DESC;
4463:
4464: PROCEDURE mcancel_process

Line 4607: l_pa_request_number ghr_pa_requests.request_number%TYPE;

4603: BEGIN
4604: g_proc := 'update_Mass_cancel_record';
4605:
4606: DECLARE
4607: l_pa_request_number ghr_pa_requests.request_number%TYPE;
4608: BEGIN
4609: hr_utility.set_location ('Update pa_req_num '|| l_proc, 200);
4610:
4611: FOR cur_req_num IN c_req_num LOOP

Line 4880: l_employee_number := ghr_pa_requests_pkg2.get_employee_number

4876: BEGIN
4877: g_proc := 'RPA Cancelled Already';
4878: FOR c_get_dtl IN cur_get_dtl (p_target_mass_action_id, p_effective_date) LOOP
4879: l_name := c_get_dtl.fname;
4880: l_employee_number := ghr_pa_requests_pkg2.get_employee_number
4881: (p_person_id => c_get_dtl.person_id
4882: , p_effective_date => p_effective_date);
4883: hr_utility.set_location ('Mass Cancellation already done for this ' || l_proc, 1);
4884: l_mcanerrbuf := 'Name: '