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_PKG

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 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 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 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 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: '