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_MLC_PKG dependencies on GHR_PA_REQUESTS

Line 115: l_duty_station_desc ghr_pa_requests.duty_station_desc%type;

111: l_step_or_rate varchar2(30);
112: l_pay_basis varchar2(30);
113: l_location_id number;
114: l_duty_station_id number;
115: l_duty_station_desc ghr_pa_requests.duty_station_desc%type;
116: l_duty_station_code ghr_pa_requests.duty_station_code%type;
117: l_effective_date date;
118: l_personnel_office_id varchar2(300);
119: l_org_structure_id varchar2(300);

Line 116: l_duty_station_code ghr_pa_requests.duty_station_code%type;

112: l_pay_basis varchar2(30);
113: l_location_id number;
114: l_duty_station_id number;
115: l_duty_station_desc ghr_pa_requests.duty_station_desc%type;
116: l_duty_station_code ghr_pa_requests.duty_station_code%type;
117: l_effective_date date;
118: l_personnel_office_id varchar2(300);
119: l_org_structure_id varchar2(300);
120: l_sub_element_code varchar2(300);

Line 176: l_sf52_rec ghr_pa_requests%rowtype;

172: l_p_PERSONNEL_OFFICE_ID varchar2(5);
173:
174: L_row_cnt number := 0;
175:
176: l_sf52_rec ghr_pa_requests%rowtype;
177: l_lac_sf52_rec ghr_pa_requests%rowtype;
178: l_errbuf varchar2(2000);
179:
180: l_retcode number;

Line 177: l_lac_sf52_rec ghr_pa_requests%rowtype;

173:
174: L_row_cnt number := 0;
175:
176: l_sf52_rec ghr_pa_requests%rowtype;
177: l_lac_sf52_rec ghr_pa_requests%rowtype;
178: l_errbuf varchar2(2000);
179:
180: l_retcode number;
181:

Line 310: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

306: l_location_id := per.location_id;
307:
308: hr_utility.set_location('The location id is:'||l_location_id,12345);
309: begin
310: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
311: (p_location_id => l_location_id
312: ,p_duty_station_id => l_duty_station_id);
313: exception
314: when others then

Line 316: 'Error in Ghr_pa_requests_pkg.get_sf52_loc_ddf_details'||

312: ,p_duty_station_id => l_duty_station_id);
313: exception
314: when others then
315: hr_utility.set_location(
316: 'Error in Ghr_pa_requests_pkg.get_sf52_loc_ddf_details'||
317: 'Err is '||sqlerrm(sqlcode),20);
318: l_mlcerrbuf := 'Error in get_sf52_loc_ddf_details '||
319: 'Sql Err is '|| sqlerrm(sqlcode);
320: raise mlc_error;

Line 354: ghr_pa_requests_pkg.get_sf52_asg_ddf_details

350:
351: hr_utility.set_location('check_init_eligibility ' || l_proc,6);
352:
353: begin
354: ghr_pa_requests_pkg.get_sf52_asg_ddf_details
355: (l_assignment_id,
356: l_effective_date,
357: l_tenure,
358: l_annuitant_indicator,

Line 364: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details'||

360: l_work_schedule,
361: l_part_time_hour);
362: exception
363: when others then
364: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details'||
365: 'Err is '||sqlerrm(sqlcode),20);
366: l_mlcerrbuf := 'Error in get_sf52_asgddf_details Sql Err is '|| sqlerrm(sqlcode);
367: raise mlc_error;
368: end;

Line 406: ghr_pa_requests_pkg.get_duty_station_details

402: hr_utility.set_location('check_select_flg ' || l_proc,7);
403: BEGIN
404: hr_utility.set_location('The duty station name is:'||l_duty_station_code,12345);
405: hr_utility.set_location('The duty station desc is:'||l_duty_station_desc,12345);
406: ghr_pa_requests_pkg.get_duty_station_details
407: (p_duty_station_id => l_duty_station_id
408: ,p_effective_date => l_effective_date
409: ,p_duty_station_code => l_duty_station_code
410: ,p_duty_station_desc => l_duty_station_desc);

Line 413: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_duty_station_details'||

409: ,p_duty_station_code => l_duty_station_code
410: ,p_duty_station_desc => l_duty_station_desc);
411: EXCEPTION
412: when others then
413: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_duty_station_details'||
414: 'Err is '||sqlerrm(sqlcode),20);
415: l_mlcerrbuf := 'Error in get_duty_station_details Sql Err is '|| sqlerrm(sqlcode);
416: raise mlc_error;
417:

Line 611: l_capped_other_pay := ghr_pa_requests_pkg2.get_cop( p_assignment_id => l_assignment_id

607: hr_utility.set_location('Supervisory Diff Amount = ' || to_char(l_supervisory_differential),10);
608:
609: -------------Call Pay cap Procedure
610: begin
611: l_capped_other_pay := ghr_pa_requests_pkg2.get_cop( p_assignment_id => l_assignment_id
612: ,p_effective_date => l_effective_date);
613: l_old_capped_other_pay := l_capped_other_pay;
614: -- Sundar Added the following if statement to improve performance
615: if hr_utility.debug_enabled = true then

Line 893: l_pa_request_number ghr_pa_requests.request_number%TYPE;

889:
890: ------ Added by Dinkar for List reports problem
891:
892: DECLARE
893: l_pa_request_number ghr_pa_requests.request_number%TYPE;
894: BEGIN
895:
896: l_pa_request_number := l_sf52_rec.request_number||'-'||p_mass_salary_id;
897:

Line 1293: l_duty_station_desc ghr_pa_requests.duty_station_desc%type;

1289: l_step_or_rate varchar2(30);
1290: l_pay_basis varchar2(30);
1291: l_location_id number;
1292: l_duty_station_id number;
1293: l_duty_station_desc ghr_pa_requests.duty_station_desc%type;
1294: l_duty_station_code ghr_pa_requests.duty_station_code%type;
1295: l_effective_date date;
1296: l_personnel_office_id varchar2(300);
1297: l_org_structure_id varchar2(300);

Line 1294: l_duty_station_code ghr_pa_requests.duty_station_code%type;

1290: l_pay_basis varchar2(30);
1291: l_location_id number;
1292: l_duty_station_id number;
1293: l_duty_station_desc ghr_pa_requests.duty_station_desc%type;
1294: l_duty_station_code ghr_pa_requests.duty_station_code%type;
1295: l_effective_date date;
1296: l_personnel_office_id varchar2(300);
1297: l_org_structure_id varchar2(300);
1298: l_sub_element_code varchar2(300);

Line 1353: l_sf52_rec ghr_pa_requests%rowtype;

1349: l_p_PERSONNEL_OFFICE_ID varchar2(5);
1350:
1351: L_row_cnt number := 0;
1352:
1353: l_sf52_rec ghr_pa_requests%rowtype;
1354: l_lac_sf52_rec ghr_pa_requests%rowtype;
1355: l_errbuf varchar2(2000);
1356:
1357: l_retcode number;

Line 1354: l_lac_sf52_rec ghr_pa_requests%rowtype;

1350:
1351: L_row_cnt number := 0;
1352:
1353: l_sf52_rec ghr_pa_requests%rowtype;
1354: l_lac_sf52_rec ghr_pa_requests%rowtype;
1355: l_errbuf varchar2(2000);
1356:
1357: l_retcode number;
1358:

Line 1503: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

1499: l_location_id := p_location_id;
1500:
1501: hr_utility.set_location('The location id is:'||l_location_id,12345);
1502: begin
1503: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
1504: (p_location_id => l_location_id
1505: ,p_duty_station_id => l_duty_station_id);
1506: exception
1507: when others then

Line 1509: 'Error in Ghr_pa_requests_pkg.get_sf52_loc_ddf_details'||

1505: ,p_duty_station_id => l_duty_station_id);
1506: exception
1507: when others then
1508: hr_utility.set_location(
1509: 'Error in Ghr_pa_requests_pkg.get_sf52_loc_ddf_details'||
1510: 'Err is '||sqlerrm(sqlcode),20);
1511: l_mtcerrbuf := 'Error in get_sf52_loc_ddf_details '||
1512: 'Sql Err is '|| sqlerrm(sqlcode);
1513: raise mtc_error;

Line 1563: ghr_pa_requests_pkg.get_sf52_asg_ddf_details

1559: hr_utility.set_location('check_init_eligibility ' || l_proc,6);
1560: -- Get PRD, work schedule etc form ASG EI
1561:
1562: begin
1563: ghr_pa_requests_pkg.get_sf52_asg_ddf_details
1564: (l_assignment_id,
1565: l_effective_date,
1566: l_tenure,
1567: l_annuitant_indicator,

Line 1573: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details'||

1569: l_work_schedule,
1570: l_part_time_hour);
1571: exception
1572: when others then
1573: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details'||
1574: 'Err is '||sqlerrm(sqlcode),20);
1575: l_mtcerrbuf := 'Error in get_sf52_asgddf_details Sql Err is '|| sqlerrm(sqlcode);
1576: raise mtc_error;
1577: end;

Line 1626: ghr_pa_requests_pkg.get_duty_station_details

1622: hr_utility.set_location('The duty station name is:'||l_duty_station_code,12345);
1623: hr_utility.set_location('The duty station desc is:'||l_duty_station_desc,12345);
1624:
1625: begin
1626: ghr_pa_requests_pkg.get_duty_station_details
1627: (p_duty_station_id => l_duty_station_id
1628: ,p_effective_date => l_effective_date
1629: ,p_duty_station_code => l_duty_station_code
1630: ,p_duty_station_desc => l_duty_station_desc);

Line 1633: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_duty_station_details'||

1629: ,p_duty_station_code => l_duty_station_code
1630: ,p_duty_station_desc => l_duty_station_desc);
1631: exception
1632: when others then
1633: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_duty_station_details'||
1634: 'Err is '||sqlerrm(sqlcode),20);
1635: l_mtcerrbuf := 'Error in get_duty_station_details Sql Err is '|| sqlerrm(sqlcode);
1636: raise mtc_error;
1637: end;

Line 1818: l_capped_other_pay := ghr_pa_requests_pkg2.get_cop( p_assignment_id => l_assignment_id

1814:
1815:
1816: -------------Call Pay cap Procedure
1817: begin
1818: l_capped_other_pay := ghr_pa_requests_pkg2.get_cop( p_assignment_id => l_assignment_id
1819: ,p_effective_date => l_effective_date);
1820: l_old_capped_other_pay := l_capped_other_pay;
1821: -- Sundar Added the following if statement to improve performance
1822: if hr_utility.debug_enabled = true then

Line 2074: l_pa_request_number ghr_pa_requests.request_number%TYPE;

2070:
2071: ------ Added by Dinkar for List reports problem
2072:
2073: declare
2074: l_pa_request_number ghr_pa_requests.request_number%TYPE;
2075: begin
2076:
2077: l_pa_request_number :=
2078: l_sf52_rec.request_number||'-'||p_mass_salary_id;

Line 2380: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

2376: l_location_id := un_per.location_id;
2377:
2378: hr_utility.set_location('position valid grade table id is ' || to_char(l_pay_table_id) || l_proc,45);
2379: BEGIN
2380: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
2381: (p_location_id => l_location_id
2382: ,p_duty_station_id => l_duty_station_id);
2383: END;
2384:

Line 2467: ghr_pa_requests_pkg.get_duty_station_details

2463:
2464: hr_utility.set_location('check l_pay_plan ' || l_pay_plan || l_proc,58);
2465: hr_utility.set_location('check l_grade_or_level ' || l_grade_or_level || l_proc,58);
2466: BEGIN
2467: ghr_pa_requests_pkg.get_duty_station_details
2468: (p_duty_station_id => l_duty_station_id
2469: ,p_effective_DATE => l_effective_DATE
2470: ,p_duty_station_code => l_duty_station_code
2471: ,p_duty_station_desc => l_duty_station_desc);

Line 2798: from ghr_pa_requests

2794: input_pay_rate_determinant,
2795: from_pay_table_identifier,
2796: to_pay_table_identifier
2797: -- FWFA Changes
2798: from ghr_pa_requests
2799: where person_id = p_person_id
2800: and effective_date = p_effective_date
2801: and substr(request_number,(instr(request_number,'-')+1)) = to_char(p_mass_salary_id)
2802: and first_noa_code = nvl(ghr_msl_pkg.g_first_noa_code,'895');

Line 2945: from ghr_pa_requests

2941: input_pay_rate_determinant,
2942: from_pay_table_identifier,
2943: to_pay_table_identifier
2944: -- FWFA Changes
2945: from ghr_pa_requests
2946: where person_id = p_person_id
2947: and effective_date = p_effective_date
2948: and substr(request_number,(instr(request_number,'-')+1)) = to_char(p_mass_salary_id)
2949: and first_noa_code in ('894','800');

Line 3521: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;

3517: )
3518: return boolean is
3519: --
3520: l_name per_people_f.full_name%type;
3521: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
3522:
3523: cursor csr_action_taken is
3524: select pr.pa_request_id, max(pa_routing_history_id) pa_routing_history_id
3525: from ghr_pa_requests pr, ghr_pa_routing_history prh

Line 3525: from ghr_pa_requests pr, ghr_pa_routing_history prh

3521: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
3522:
3523: cursor csr_action_taken is
3524: select pr.pa_request_id, max(pa_routing_history_id) pa_routing_history_id
3525: from ghr_pa_requests pr, ghr_pa_routing_history prh
3526: where pr.pa_request_id = prh.pa_request_id
3527: and person_id = p_person_id
3528: and first_noa_code = p_first_noa_code
3529: and effective_date = p_effective_date

Line 3537: from ghr_pa_requests pr

3533: group by pr.pa_request_id;
3534:
3535: cursor csr_name is
3536: select substr(pr.employee_last_name || ', ' || pr.employee_first_name,1,240) fname
3537: from ghr_pa_requests pr
3538: where pr.pa_request_id = l_pa_request_id;
3539:
3540: cursor csr_action_taken_fw is
3541: select pr.pa_request_id, max(pa_routing_history_id) pa_routing_history_id

Line 3542: from ghr_pa_requests pr, ghr_pa_routing_history prh

3538: where pr.pa_request_id = l_pa_request_id;
3539:
3540: cursor csr_action_taken_fw is
3541: select pr.pa_request_id, max(pa_routing_history_id) pa_routing_history_id
3542: from ghr_pa_requests pr, ghr_pa_routing_history prh
3543: where pr.pa_request_id = prh.pa_request_id
3544: and person_id = p_person_id
3545: and first_noa_code = p_first_noa_code
3546: and effective_date = p_effective_date

Line 3697: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;

3693: )
3694: return boolean is
3695: --
3696: l_name per_people_f.full_name%type;
3697: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
3698:
3699: cursor csr_action_taken is
3700: select pr.pa_request_id, max(pa_routing_history_id) pa_routing_history_id
3701: from ghr_pa_requests pr, ghr_pa_routing_history prh

Line 3701: from ghr_pa_requests pr, ghr_pa_routing_history prh

3697: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
3698:
3699: cursor csr_action_taken is
3700: select pr.pa_request_id, max(pa_routing_history_id) pa_routing_history_id
3701: from ghr_pa_requests pr, ghr_pa_routing_history prh
3702: where pr.pa_request_id = prh.pa_request_id
3703: and person_id = p_person_id
3704: and (first_noa_code = p_first_noa_code or first_noa_code = '800')
3705: and effective_date = p_effective_date

Line 3711: from ghr_pa_requests pr

3707: group by pr.pa_request_id;
3708:
3709: cursor csr_name is
3710: select substr(pr.employee_last_name || ', ' || pr.employee_first_name,1,240) fname
3711: from ghr_pa_requests pr
3712: where pr.pa_request_id = l_pa_request_id;
3713:
3714: cursor csr_action_taken_fw is
3715: select pr.pa_request_id, max(pa_routing_history_id) pa_routing_history_id

Line 3716: from ghr_pa_requests pr, ghr_pa_routing_history prh

3712: where pr.pa_request_id = l_pa_request_id;
3713:
3714: cursor csr_action_taken_fw is
3715: select pr.pa_request_id, max(pa_routing_history_id) pa_routing_history_id
3716: from ghr_pa_requests pr, ghr_pa_routing_history prh
3717: where pr.pa_request_id = prh.pa_request_id
3718: and person_id = p_person_id
3719: and (first_noa_code = p_first_noa_code or first_noa_code = '800')
3720: and effective_date = p_effective_date

Line 4881: p_sf52_rec out nocopy ghr_pa_requests%rowtype) IS

4877: --
4878:
4879: procedure get_lac_dtls
4880: (p_pa_request_id in number,
4881: p_sf52_rec out nocopy ghr_pa_requests%rowtype) IS
4882:
4883: l_proc varchar2(72) := g_package || '.get_lac_dtls';
4884:
4885: cursor cur_pa_req_cur is

Line 4886: select * from ghr_pa_requests

4882:
4883: l_proc varchar2(72) := g_package || '.get_lac_dtls';
4884:
4885: cursor cur_pa_req_cur is
4886: select * from ghr_pa_requests
4887: where pa_request_id = p_pa_request_id;
4888:
4889: begin
4890: g_proc := 'get_lac_dtls';

Line 5064: p_duty_station_code in ghr_pa_requests.duty_station_code%type,

5060: p_to_supervisory_differential in number,
5061: p_to_supervisory_diff_perce in number,
5062: p_to_staffing_differential in number,
5063: p_duty_station_id in number,
5064: p_duty_station_code in ghr_pa_requests.duty_station_code%type,
5065: p_duty_station_desc in ghr_pa_requests.duty_station_desc%type,
5066: -- FWFA Changes Bug#4444609
5067: p_input_pay_rate_determinant in ghr_pa_requests.input_pay_rate_determinant%type,
5068: p_from_pay_table_id in ghr_pa_requests.from_pay_table_identifier%type,

Line 5065: p_duty_station_desc in ghr_pa_requests.duty_station_desc%type,

5061: p_to_supervisory_diff_perce in number,
5062: p_to_staffing_differential in number,
5063: p_duty_station_id in number,
5064: p_duty_station_code in ghr_pa_requests.duty_station_code%type,
5065: p_duty_station_desc in ghr_pa_requests.duty_station_desc%type,
5066: -- FWFA Changes Bug#4444609
5067: p_input_pay_rate_determinant in ghr_pa_requests.input_pay_rate_determinant%type,
5068: p_from_pay_table_id in ghr_pa_requests.from_pay_table_identifier%type,
5069: p_to_pay_table_id in ghr_pa_requests.to_pay_table_identifier%type,

Line 5067: p_input_pay_rate_determinant in ghr_pa_requests.input_pay_rate_determinant%type,

5063: p_duty_station_id in number,
5064: p_duty_station_code in ghr_pa_requests.duty_station_code%type,
5065: p_duty_station_desc in ghr_pa_requests.duty_station_desc%type,
5066: -- FWFA Changes Bug#4444609
5067: p_input_pay_rate_determinant in ghr_pa_requests.input_pay_rate_determinant%type,
5068: p_from_pay_table_id in ghr_pa_requests.from_pay_table_identifier%type,
5069: p_to_pay_table_id in ghr_pa_requests.to_pay_table_identifier%type,
5070: -- FWFA Changes
5071: p_lac_sf52_rec in ghr_pa_requests%rowtype,

Line 5068: p_from_pay_table_id in ghr_pa_requests.from_pay_table_identifier%type,

5064: p_duty_station_code in ghr_pa_requests.duty_station_code%type,
5065: p_duty_station_desc in ghr_pa_requests.duty_station_desc%type,
5066: -- FWFA Changes Bug#4444609
5067: p_input_pay_rate_determinant in ghr_pa_requests.input_pay_rate_determinant%type,
5068: p_from_pay_table_id in ghr_pa_requests.from_pay_table_identifier%type,
5069: p_to_pay_table_id in ghr_pa_requests.to_pay_table_identifier%type,
5070: -- FWFA Changes
5071: p_lac_sf52_rec in ghr_pa_requests%rowtype,
5072: p_sf52_rec out nocopy ghr_pa_requests%rowtype) IS

Line 5069: p_to_pay_table_id in ghr_pa_requests.to_pay_table_identifier%type,

5065: p_duty_station_desc in ghr_pa_requests.duty_station_desc%type,
5066: -- FWFA Changes Bug#4444609
5067: p_input_pay_rate_determinant in ghr_pa_requests.input_pay_rate_determinant%type,
5068: p_from_pay_table_id in ghr_pa_requests.from_pay_table_identifier%type,
5069: p_to_pay_table_id in ghr_pa_requests.to_pay_table_identifier%type,
5070: -- FWFA Changes
5071: p_lac_sf52_rec in ghr_pa_requests%rowtype,
5072: p_sf52_rec out nocopy ghr_pa_requests%rowtype) IS
5073:

Line 5071: p_lac_sf52_rec in ghr_pa_requests%rowtype,

5067: p_input_pay_rate_determinant in ghr_pa_requests.input_pay_rate_determinant%type,
5068: p_from_pay_table_id in ghr_pa_requests.from_pay_table_identifier%type,
5069: p_to_pay_table_id in ghr_pa_requests.to_pay_table_identifier%type,
5070: -- FWFA Changes
5071: p_lac_sf52_rec in ghr_pa_requests%rowtype,
5072: p_sf52_rec out nocopy ghr_pa_requests%rowtype) IS
5073:
5074: l_proc varchar2(72) := g_package || '.assign_to_sf52_rec';
5075: begin

Line 5072: p_sf52_rec out nocopy ghr_pa_requests%rowtype) IS

5068: p_from_pay_table_id in ghr_pa_requests.from_pay_table_identifier%type,
5069: p_to_pay_table_id in ghr_pa_requests.to_pay_table_identifier%type,
5070: -- FWFA Changes
5071: p_lac_sf52_rec in ghr_pa_requests%rowtype,
5072: p_sf52_rec out nocopy ghr_pa_requests%rowtype) IS
5073:
5074: l_proc varchar2(72) := g_package || '.assign_to_sf52_rec';
5075: begin
5076:

Line 5408: l_his_eff_date ghr_pa_requests.effective_date%type;

5404: AND HR_GENERAL.DECODE_AVAILABILITY_STATUS(pos.availability_status_id) = 'Active');
5405:
5406: l_hist_id ghr_pa_history.pa_history_id%type;
5407: l_position_id per_assignments_f.position_id%type;
5408: l_his_eff_date ghr_pa_requests.effective_date%type;
5409: l_user_tab_id pay_user_tables.user_table_id%type;
5410:
5411:
5412: begin