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

Line 26: (p_pa_request_id IN ghr_pa_requests.pa_request_id%type,

22: -- Procedure to create remarks M67 Test Sundar 1295
23:
24:
25: PROCEDURE create_lac_remarks
26: (p_pa_request_id IN ghr_pa_requests.pa_request_id%type,
27: p_new_pa_request_id IN ghr_pa_requests.pa_request_id%type,
28: p_effective_date IN ghr_pa_requests.effective_date%type,
29: p_pa_request_rec IN ghr_pa_requests%rowtype) is
30:

Line 27: p_new_pa_request_id IN ghr_pa_requests.pa_request_id%type,

23:
24:
25: PROCEDURE create_lac_remarks
26: (p_pa_request_id IN ghr_pa_requests.pa_request_id%type,
27: p_new_pa_request_id IN ghr_pa_requests.pa_request_id%type,
28: p_effective_date IN ghr_pa_requests.effective_date%type,
29: p_pa_request_rec IN ghr_pa_requests%rowtype) is
30:
31: l_proc VARCHAR2(72) := g_package || '.create_lac_remarks';

Line 28: p_effective_date IN ghr_pa_requests.effective_date%type,

24:
25: PROCEDURE create_lac_remarks
26: (p_pa_request_id IN ghr_pa_requests.pa_request_id%type,
27: p_new_pa_request_id IN ghr_pa_requests.pa_request_id%type,
28: p_effective_date IN ghr_pa_requests.effective_date%type,
29: p_pa_request_rec IN ghr_pa_requests%rowtype) is
30:
31: l_proc VARCHAR2(72) := g_package || '.create_lac_remarks';
32:

Line 29: p_pa_request_rec IN ghr_pa_requests%rowtype) is

25: PROCEDURE create_lac_remarks
26: (p_pa_request_id IN ghr_pa_requests.pa_request_id%type,
27: p_new_pa_request_id IN ghr_pa_requests.pa_request_id%type,
28: p_effective_date IN ghr_pa_requests.effective_date%type,
29: p_pa_request_rec IN ghr_pa_requests%rowtype) is
30:
31: l_proc VARCHAR2(72) := g_package || '.create_lac_remarks';
32:
33: CURSOR cur_pa_rem_cur is

Line 37: CURSOR cur_rem_code(c_effective_date ghr_pa_requests.effective_date%type) IS

33: CURSOR cur_pa_rem_cur is
34: SELECT * FROM ghr_pa_remarks
35: WHERE pa_request_id = p_pa_request_id;
36:
37: CURSOR cur_rem_code(c_effective_date ghr_pa_requests.effective_date%type) IS
38: SELECT remark_id
39: FROM ghr_remarks
40: WHERE code = 'M67'
41: AND enabled_flag = 'Y'

Line 364: l_agency_code ghr_pa_requests.agency_code%type;

360:
361: l_PA_REQUEST_EXTRA_INFO_ID number;
362: l_pa_OBJECT_VERSION_NUMBER number;
363: l_dummy varchar2(35);
364: l_agency_code ghr_pa_requests.agency_code%type;
365: --------
366:
367: l_assignment_id per_assignments_f.assignment_id%type;
368: l_position_id per_assignments_f.position_id%type;

Line 393: l_duty_station_desc ghr_pa_requests.duty_station_desc%type;

389: l_step_or_rate varchar2(30);
390: l_pay_basis varchar2(30);
391: l_location_id number;
392: l_duty_station_id number;
393: l_duty_station_desc ghr_pa_requests.duty_station_desc%type;
394: l_duty_station_code ghr_pa_requests.duty_station_code%type;
395:
396: l_check_child varchar2(2);
397: l_check_org_pos varchar2(2);

Line 394: l_duty_station_code ghr_pa_requests.duty_station_code%type;

390: l_pay_basis varchar2(30);
391: l_location_id number;
392: l_duty_station_id number;
393: l_duty_station_desc ghr_pa_requests.duty_station_desc%type;
394: l_duty_station_code ghr_pa_requests.duty_station_code%type;
395:
396: l_check_child varchar2(2);
397: l_check_org_pos varchar2(2);
398: l_org_pos_id number;

Line 439: t_duty_station_desc ghr_pa_requests.duty_station_desc%type;

435:
436: t_personnel_office_id varchar2(300);
437: t_sub_element_code varchar2(300);
438: t_duty_station_id number(15);
439: t_duty_station_desc ghr_pa_requests.duty_station_desc%type;
440: t_duty_station_code ghr_pa_requests.duty_station_code%type;
441: t_office_symbol varchar2(30);
442: t_payroll_office_id varchar2(30);
443: t_org_func_code varchar2(30);

Line 440: t_duty_station_code ghr_pa_requests.duty_station_code%type;

436: t_personnel_office_id varchar2(300);
437: t_sub_element_code varchar2(300);
438: t_duty_station_id number(15);
439: t_duty_station_desc ghr_pa_requests.duty_station_desc%type;
440: t_duty_station_code ghr_pa_requests.duty_station_code%type;
441: t_office_symbol varchar2(30);
442: t_payroll_office_id varchar2(30);
443: t_org_func_code varchar2(30);
444: t_appropriation_code1 varchar2(30);

Line 467: l_sf52_rec ghr_pa_requests%rowtype;

463: l_executive_order_date date;
464:
465: l_row_cnt number := 0;
466:
467: l_sf52_rec ghr_pa_requests%rowtype;
468: l_lac_sf52_rec ghr_pa_requests%rowtype;
469: l_errbuf varchar2(2000);
470:
471: l_retcode number;

Line 468: l_lac_sf52_rec ghr_pa_requests%rowtype;

464:
465: l_row_cnt number := 0;
466:
467: l_sf52_rec ghr_pa_requests%rowtype;
468: l_lac_sf52_rec ghr_pa_requests%rowtype;
469: l_errbuf varchar2(2000);
470:
471: l_retcode number;
472:

Line 750: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

746:
747: pr('After check sel flg value is ',l_sel_flg,l_sel_status);
748: l_ind := 70;
749: begin
750: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
751: (p_location_id => l_location_id
752: ,p_duty_station_id => l_duty_station_id);
753: exception
754: when others then

Line 755: pr('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details');

751: (p_location_id => l_location_id
752: ,p_duty_station_id => l_duty_station_id);
753: exception
754: when others then
755: pr('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details');
756: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_loc_ddf_details'||
757: 'Err is '||sqlerrm(sqlcode),20);
758: l_mass_errbuf := 'Error in get_sf52_loc_ddf_details Sql Err is '||
759: sqlerrm(sqlcode);

Line 756: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_loc_ddf_details'||

752: ,p_duty_station_id => l_duty_station_id);
753: exception
754: when others then
755: pr('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details');
756: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_loc_ddf_details'||
757: 'Err is '||sqlerrm(sqlcode),20);
758: l_mass_errbuf := 'Error in get_sf52_loc_ddf_details Sql Err is '||
759: sqlerrm(sqlcode);
760: raise mass_error;

Line 808: ghr_pa_requests_pkg.get_sf52_asg_ddf_details

804: per.person_id) then
805:
806: l_ind := 60;
807: BEGIN
808: ghr_pa_requests_pkg.get_sf52_asg_ddf_details
809: (l_assignment_id,
810: l_effective_date,
811: l_tenure,
812: l_annuitant_indicator,

Line 818: pr('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details');

814: l_work_schedule,
815: l_part_time_hour);
816: EXCEPTION
817: when others then
818: pr('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details');
819: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details'||
820: 'Err is '||sqlerrm(sqlcode),20);
821: l_mass_errbuf := 'Error in get_sf52_asgddf_details Sql Err is '||
822: sqlerrm(sqlcode);

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

815: l_part_time_hour);
816: EXCEPTION
817: when others then
818: pr('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details');
819: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details'||
820: 'Err is '||sqlerrm(sqlcode),20);
821: l_mass_errbuf := 'Error in get_sf52_asgddf_details Sql Err is '||
822: sqlerrm(sqlcode);
823: raise mass_error;

Line 848: ghr_pa_requests_pkg.get_duty_station_details

844: l_appropriation_code2,
845: l_pos_grp2_rec);
846: l_ind := 90;
847: BEGIN
848: ghr_pa_requests_pkg.get_duty_station_details
849: (p_duty_station_id => l_duty_station_id
850: ,p_effective_date => l_effective_date
851: ,p_duty_station_code => l_duty_station_code
852: ,p_duty_station_desc => l_duty_station_desc);

Line 855: pr('Error in Ghr_pa_requests_pkg.get_duty_station_details');

851: ,p_duty_station_code => l_duty_station_code
852: ,p_duty_station_desc => l_duty_station_desc);
853: EXCEPTION
854: when others then
855: pr('Error in Ghr_pa_requests_pkg.get_duty_station_details');
856: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_duty_station_details'||
857: 'Err is '||sqlerrm(sqlcode),20);
858: l_mass_errbuf := 'Error in get_duty_station_details Sql Err is '||
859: sqlerrm(sqlcode);

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

852: ,p_duty_station_desc => l_duty_station_desc);
853: EXCEPTION
854: when others then
855: pr('Error in Ghr_pa_requests_pkg.get_duty_station_details');
856: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_duty_station_details'||
857: 'Err is '||sqlerrm(sqlcode),20);
858: l_mass_errbuf := 'Error in get_duty_station_details Sql Err is '||
859: sqlerrm(sqlcode);
860: raise mass_error;

Line 966: ---l_agency_code ghr_pa_requests.agency_code%type;

962: l_ind := 200;
963:
964: --Added by Dinkar for quick fix.
965: ---declare -- Commented by AVR
966: ---l_agency_code ghr_pa_requests.agency_code%type;
967: begin
968: get_to_agency (per.person_id,
969: l_effective_date,
970: l_agency_code);

Line 1038: l_pa_request_number ghr_pa_requests.request_number%TYPE;

1034:
1035: ------ Added by Dinkar for List reports problem
1036:
1037: declare
1038: l_pa_request_number ghr_pa_requests.request_number%TYPE;
1039: begin
1040:
1041: l_pa_request_number :=
1042: l_sf52_rec.request_number||'-'||p_mass_transfer_id;

Line 1252: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

1248: l_position_organization,
1249: l_pos_grp1_rec);
1250:
1251: begin
1252: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
1253: (p_location_id => l_location_id
1254: ,p_duty_station_id => l_duty_station_id);
1255: end;
1256:

Line 1258: ghr_pa_requests_pkg.get_duty_station_details

1254: ,p_duty_station_id => l_duty_station_id);
1255: end;
1256:
1257: begin
1258: ghr_pa_requests_pkg.get_duty_station_details
1259: (p_duty_station_id => l_duty_station_id
1260: ,p_effective_date => l_effective_date
1261: ,p_duty_station_code => l_duty_station_code
1262: ,p_duty_station_desc => l_duty_station_desc);

Line 1614: from ghr_pa_requests /**, per_organization_units B*/

1610: FROM_OCC_CODE,
1611: TO_ORGANIZATION_ID ORGANIZATION_ID,
1612: ---B.NAME ORGANIZATION_NAME,
1613: EMPLOYEE_ASSIGNMENT_ID
1614: from ghr_pa_requests /**, per_organization_units B*/
1615: where person_id = p_person_id
1616: and effective_date = p_effective_date
1617: and first_noa_code = '352'
1618: -- Added by Dinkar for reports

Line 2609: p_duty_station_code in ghr_pa_requests.duty_station_code%type,

2605: p_supervisory_status in varchar2,
2606: p_personnel_office_id in varchar2,
2607: p_sub_element_code in varchar2,
2608: p_duty_station_id in number,
2609: p_duty_station_code in ghr_pa_requests.duty_station_code%type,
2610: p_duty_station_desc in ghr_pa_requests.duty_station_desc%type,
2611: p_office_symbol in varchar2,
2612: p_payroll_office_id in varchar2,
2613: p_org_func_code in varchar2,

Line 2610: p_duty_station_desc in ghr_pa_requests.duty_station_desc%type,

2606: p_personnel_office_id in varchar2,
2607: p_sub_element_code in varchar2,
2608: p_duty_station_id in number,
2609: p_duty_station_code in ghr_pa_requests.duty_station_code%type,
2610: p_duty_station_desc in ghr_pa_requests.duty_station_desc%type,
2611: p_office_symbol in varchar2,
2612: p_payroll_office_id in varchar2,
2613: p_org_func_code in varchar2,
2614: p_appropriation_code1 in varchar2,

Line 2619: p_lac_sf52_rec in ghr_pa_requests%rowtype,

2615: p_appropriation_code2 in varchar2,
2616: p_position_organization in varchar2,
2617: p_first_noa_information1 in varchar2,
2618: p_to_position_org_line1 in varchar2, -- AVR
2619: p_lac_sf52_rec in ghr_pa_requests%rowtype,
2620: p_sf52_rec out NOCOPY ghr_pa_requests%rowtype) IS
2621:
2622: l_proc varchar2(72)
2623: := g_package || '.assign_to_sf52_rec';

Line 2620: p_sf52_rec out NOCOPY ghr_pa_requests%rowtype) IS

2616: p_position_organization in varchar2,
2617: p_first_noa_information1 in varchar2,
2618: p_to_position_org_line1 in varchar2, -- AVR
2619: p_lac_sf52_rec in ghr_pa_requests%rowtype,
2620: p_sf52_rec out NOCOPY ghr_pa_requests%rowtype) IS
2621:
2622: l_proc varchar2(72)
2623: := g_package || '.assign_to_sf52_rec';
2624: l_sf52_rec ghr_pa_requests%rowtype;

Line 2624: l_sf52_rec ghr_pa_requests%rowtype;

2620: p_sf52_rec out NOCOPY ghr_pa_requests%rowtype) IS
2621:
2622: l_proc varchar2(72)
2623: := g_package || '.assign_to_sf52_rec';
2624: l_sf52_rec ghr_pa_requests%rowtype;
2625: begin
2626:
2627: l_sf52_rec := p_sf52_rec;
2628: