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 390: l_agency_code ghr_pa_requests.agency_code%type;

386:
387: l_PA_REQUEST_EXTRA_INFO_ID number;
388: l_pa_OBJECT_VERSION_NUMBER number;
389: l_dummy varchar2(35);
390: l_agency_code ghr_pa_requests.agency_code%type;
391: --------
392:
393: l_assignment_id per_assignments_f.assignment_id%type;
394: l_position_id per_assignments_f.position_id%type;

Line 419: l_duty_station_desc ghr_pa_requests.duty_station_desc%type;

415: l_step_or_rate varchar2(30);
416: l_pay_basis varchar2(30);
417: l_location_id number;
418: l_duty_station_id number;
419: l_duty_station_desc ghr_pa_requests.duty_station_desc%type;
420: l_duty_station_code ghr_pa_requests.duty_station_code%type;
421:
422: l_check_child varchar2(2);
423: l_check_org_pos varchar2(2);

Line 420: l_duty_station_code ghr_pa_requests.duty_station_code%type;

416: l_pay_basis varchar2(30);
417: l_location_id number;
418: l_duty_station_id number;
419: l_duty_station_desc ghr_pa_requests.duty_station_desc%type;
420: l_duty_station_code ghr_pa_requests.duty_station_code%type;
421:
422: l_check_child varchar2(2);
423: l_check_org_pos varchar2(2);
424: l_org_pos_id number;

Line 465: t_duty_station_desc ghr_pa_requests.duty_station_desc%type;

461:
462: t_personnel_office_id varchar2(300);
463: t_sub_element_code varchar2(300);
464: t_duty_station_id number(15);
465: t_duty_station_desc ghr_pa_requests.duty_station_desc%type;
466: t_duty_station_code ghr_pa_requests.duty_station_code%type;
467: t_office_symbol varchar2(30);
468: t_payroll_office_id varchar2(30);
469: t_org_func_code varchar2(30);

Line 466: t_duty_station_code ghr_pa_requests.duty_station_code%type;

462: t_personnel_office_id varchar2(300);
463: t_sub_element_code varchar2(300);
464: t_duty_station_id number(15);
465: t_duty_station_desc ghr_pa_requests.duty_station_desc%type;
466: t_duty_station_code ghr_pa_requests.duty_station_code%type;
467: t_office_symbol varchar2(30);
468: t_payroll_office_id varchar2(30);
469: t_org_func_code varchar2(30);
470: t_appropriation_code1 varchar2(30);

Line 493: l_sf52_rec ghr_pa_requests%rowtype;

489: l_executive_order_date date;
490:
491: l_row_cnt number := 0;
492:
493: l_sf52_rec ghr_pa_requests%rowtype;
494: l_lac_sf52_rec ghr_pa_requests%rowtype;
495: l_errbuf varchar2(2000);
496:
497: l_retcode number;

Line 494: l_lac_sf52_rec ghr_pa_requests%rowtype;

490:
491: l_row_cnt number := 0;
492:
493: l_sf52_rec ghr_pa_requests%rowtype;
494: l_lac_sf52_rec ghr_pa_requests%rowtype;
495: l_errbuf varchar2(2000);
496:
497: l_retcode number;
498:

Line 798: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

794:
795: pr('After check sel flg value is ',l_sel_flg,l_sel_status);
796: l_ind := 70;
797: begin
798: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
799: (p_location_id => l_location_id
800: ,p_duty_station_id => l_duty_station_id);
801: exception
802: when others then

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

799: (p_location_id => l_location_id
800: ,p_duty_station_id => l_duty_station_id);
801: exception
802: when others then
803: pr('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details');
804: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_loc_ddf_details'||
805: 'Err is '||sqlerrm(sqlcode),20);
806: l_mass_errbuf := 'Error in get_sf52_loc_ddf_details Sql Err is '||
807: sqlerrm(sqlcode);

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

800: ,p_duty_station_id => l_duty_station_id);
801: exception
802: when others then
803: pr('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details');
804: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_loc_ddf_details'||
805: 'Err is '||sqlerrm(sqlcode),20);
806: l_mass_errbuf := 'Error in get_sf52_loc_ddf_details Sql Err is '||
807: sqlerrm(sqlcode);
808: raise mass_error;

Line 856: ghr_pa_requests_pkg.get_sf52_asg_ddf_details

852: per.person_id) then
853:
854: l_ind := 60;
855: BEGIN
856: ghr_pa_requests_pkg.get_sf52_asg_ddf_details
857: (l_assignment_id,
858: l_effective_date,
859: l_tenure,
860: l_annuitant_indicator,

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

862: l_work_schedule,
863: l_part_time_hour);
864: EXCEPTION
865: when others then
866: pr('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details');
867: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details'||
868: 'Err is '||sqlerrm(sqlcode),20);
869: l_mass_errbuf := 'Error in get_sf52_asgddf_details Sql Err is '||
870: sqlerrm(sqlcode);

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

863: l_part_time_hour);
864: EXCEPTION
865: when others then
866: pr('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details');
867: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details'||
868: 'Err is '||sqlerrm(sqlcode),20);
869: l_mass_errbuf := 'Error in get_sf52_asgddf_details Sql Err is '||
870: sqlerrm(sqlcode);
871: raise mass_error;

Line 913: ghr_pa_requests_pkg.get_duty_station_details

909: l_appropriation_code2,
910: l_pos_grp2_rec);
911: l_ind := 90;
912: BEGIN
913: ghr_pa_requests_pkg.get_duty_station_details
914: (p_duty_station_id => l_duty_station_id
915: ,p_effective_date => l_effective_date
916: ,p_duty_station_code => l_duty_station_code
917: ,p_duty_station_desc => l_duty_station_desc);

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

916: ,p_duty_station_code => l_duty_station_code
917: ,p_duty_station_desc => l_duty_station_desc);
918: EXCEPTION
919: when others then
920: pr('Error in Ghr_pa_requests_pkg.get_duty_station_details');
921: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_duty_station_details'||
922: 'Err is '||sqlerrm(sqlcode),20);
923: l_mass_errbuf := 'Error in get_duty_station_details Sql Err is '||
924: sqlerrm(sqlcode);

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

917: ,p_duty_station_desc => l_duty_station_desc);
918: EXCEPTION
919: when others then
920: pr('Error in Ghr_pa_requests_pkg.get_duty_station_details');
921: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_duty_station_details'||
922: 'Err is '||sqlerrm(sqlcode),20);
923: l_mass_errbuf := 'Error in get_duty_station_details Sql Err is '||
924: sqlerrm(sqlcode);
925: raise mass_error;

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

1029: l_ind := 200;
1030:
1031: --Added by Dinkar for quick fix.
1032: ---declare -- Commented by AVR
1033: ---l_agency_code ghr_pa_requests.agency_code%type;
1034: begin
1035: get_to_agency (per.person_id,
1036: l_effective_date,
1037: l_agency_code);

Line 1105: l_pa_request_number ghr_pa_requests.request_number%TYPE;

1101:
1102: ------ Added by Dinkar for List reports problem
1103:
1104: declare
1105: l_pa_request_number ghr_pa_requests.request_number%TYPE;
1106: begin
1107:
1108: l_pa_request_number :=
1109: l_sf52_rec.request_number||'-'||p_mass_transfer_id;

Line 1278: IF ghr_pa_requests_pkg.get_pos_availability_status(l_avail_status_id)

1274: hr_general.decode_availability_status is return pos_aval_status description not the system code
1275: IF ( HR_GENERAL.DECODE_AVAILABILITY_STATUS(l_avail_status_id)
1276: not in ('Eliminated','Frozen','Deleted') ) THEN*/
1277:
1278: IF ghr_pa_requests_pkg.get_pos_availability_status(l_avail_status_id)
1279: NOT IN ('DELETED','FROZEN','ELIMINATED') THEN
1280: --End Bug# 13684234
1281:
1282: l_position_id := per.position_id;

Line 1347: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

1343: l_position_organization,
1344: l_pos_grp1_rec);
1345:
1346: begin
1347: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
1348: (p_location_id => l_location_id
1349: ,p_duty_station_id => l_duty_station_id);
1350: end;
1351:

Line 1353: ghr_pa_requests_pkg.get_duty_station_details

1349: ,p_duty_station_id => l_duty_station_id);
1350: end;
1351:
1352: begin
1353: ghr_pa_requests_pkg.get_duty_station_details
1354: (p_duty_station_id => l_duty_station_id
1355: ,p_effective_date => l_effective_date
1356: ,p_duty_station_code => l_duty_station_code
1357: ,p_duty_station_desc => l_duty_station_desc);

Line 1456: IF ghr_pa_requests_pkg.get_pos_availability_status(l_avail_status_id)

1452: hr_general.decode_availability_status is return pos_aval_status description not the system code
1453: IF ( HR_GENERAL.DECODE_AVAILABILITY_STATUS(l_avail_status_id)
1454: not in ('Eliminated','Frozen','Deleted') ) THEN*/
1455:
1456: IF ghr_pa_requests_pkg.get_pos_availability_status(l_avail_status_id)
1457: NOT IN ('DELETED','FROZEN','ELIMINATED') THEN
1458: --End Bug# 13684234
1459:
1460: IF check_select_flg(per_vacant.position_id,upper(p_action),

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

1715: FROM_OCC_CODE,
1716: TO_ORGANIZATION_ID ORGANIZATION_ID,
1717: ---B.NAME ORGANIZATION_NAME,
1718: EMPLOYEE_ASSIGNMENT_ID
1719: from ghr_pa_requests /**, per_organization_units B*/
1720: where person_id = p_person_id
1721: and effective_date = p_effective_date
1722: and first_noa_code = '352'
1723: -- Added by Dinkar for reports

Line 2722: p_duty_station_code in ghr_pa_requests.duty_station_code%type,

2718: p_supervisory_status in varchar2,
2719: p_personnel_office_id in varchar2,
2720: p_sub_element_code in varchar2,
2721: p_duty_station_id in number,
2722: p_duty_station_code in ghr_pa_requests.duty_station_code%type,
2723: p_duty_station_desc in ghr_pa_requests.duty_station_desc%type,
2724: p_office_symbol in varchar2,
2725: p_payroll_office_id in varchar2,
2726: p_org_func_code in varchar2,

Line 2723: p_duty_station_desc in ghr_pa_requests.duty_station_desc%type,

2719: p_personnel_office_id in varchar2,
2720: p_sub_element_code in varchar2,
2721: p_duty_station_id in number,
2722: p_duty_station_code in ghr_pa_requests.duty_station_code%type,
2723: p_duty_station_desc in ghr_pa_requests.duty_station_desc%type,
2724: p_office_symbol in varchar2,
2725: p_payroll_office_id in varchar2,
2726: p_org_func_code in varchar2,
2727: p_appropriation_code1 in varchar2,

Line 2732: p_lac_sf52_rec in ghr_pa_requests%rowtype,

2728: p_appropriation_code2 in varchar2,
2729: p_position_organization in varchar2,
2730: p_first_noa_information1 in varchar2,
2731: p_to_position_org_line1 in varchar2, -- AVR
2732: p_lac_sf52_rec in ghr_pa_requests%rowtype,
2733: p_sf52_rec out NOCOPY ghr_pa_requests%rowtype) IS
2734:
2735: l_proc varchar2(72)
2736: := g_package || '.assign_to_sf52_rec';

Line 2733: p_sf52_rec out NOCOPY ghr_pa_requests%rowtype) IS

2729: p_position_organization in varchar2,
2730: p_first_noa_information1 in varchar2,
2731: p_to_position_org_line1 in varchar2, -- AVR
2732: p_lac_sf52_rec in ghr_pa_requests%rowtype,
2733: p_sf52_rec out NOCOPY ghr_pa_requests%rowtype) IS
2734:
2735: l_proc varchar2(72)
2736: := g_package || '.assign_to_sf52_rec';
2737: l_sf52_rec ghr_pa_requests%rowtype;

Line 2737: l_sf52_rec ghr_pa_requests%rowtype;

2733: p_sf52_rec out NOCOPY ghr_pa_requests%rowtype) IS
2734:
2735: l_proc varchar2(72)
2736: := g_package || '.assign_to_sf52_rec';
2737: l_sf52_rec ghr_pa_requests%rowtype;
2738: begin
2739:
2740: l_sf52_rec := p_sf52_rec;
2741: