DBA Data[Home] [Help]

APPS.GHR_MRE_PKG dependencies on GHR_PA_REQUESTS

Line 316: l_duty_station_desc ghr_pa_requests.duty_station_desc%type;

312: l_step_or_rate VARCHAR2(30);
313: l_pay_basis VARCHAR2(30);
314: l_location_id NUMBER;
315: l_duty_station_id NUMBER;
316: l_duty_station_desc ghr_pa_requests.duty_station_desc%type;
317: l_duty_station_code ghr_pa_requests.duty_station_code%type;
318:
319: l_check_child VARCHAR2(2);
320: l_check_org_pos VARCHAR2(2);

Line 317: l_duty_station_code ghr_pa_requests.duty_station_code%type;

313: l_pay_basis VARCHAR2(30);
314: l_location_id NUMBER;
315: l_duty_station_id NUMBER;
316: l_duty_station_desc ghr_pa_requests.duty_station_desc%type;
317: l_duty_station_code ghr_pa_requests.duty_station_code%type;
318:
319: l_check_child VARCHAR2(2);
320: l_check_org_pos VARCHAR2(2);
321: l_avail_status_id NUMBER;

Line 363: t_duty_station_desc ghr_pa_requests.duty_station_desc%type;

359:
360: t_personnel_office_id VARCHAR2(300);
361: t_sub_element_code VARCHAR2(300);
362: t_duty_station_id NUMBER(15);
363: t_duty_station_desc ghr_pa_requests.duty_station_desc%type;
364: t_duty_station_code ghr_pa_requests.duty_station_code%type;
365: t_duty_station_locn_id NUMBER(15);
366: t_office_symbol VARCHAR2(30);
367: t_payroll_office_id VARCHAR2(30);

Line 364: t_duty_station_code ghr_pa_requests.duty_station_code%type;

360: t_personnel_office_id VARCHAR2(300);
361: t_sub_element_code VARCHAR2(300);
362: t_duty_station_id NUMBER(15);
363: t_duty_station_desc ghr_pa_requests.duty_station_desc%type;
364: t_duty_station_code ghr_pa_requests.duty_station_code%type;
365: t_duty_station_locn_id NUMBER(15);
366: t_office_symbol VARCHAR2(30);
367: t_payroll_office_id VARCHAR2(30);
368: t_org_func_code VARCHAR2(30);

Line 420: l_sf52_rec ghr_pa_requests%rowtype;

416: l_executive_order_DATE DATE;
417:
418: l_row_cnt NUMBER := 0;
419:
420: l_sf52_rec ghr_pa_requests%rowtype;
421: l_lac_sf52_rec ghr_pa_requests%rowtype;
422: l_errbuf VARCHAR2(2000);
423:
424: l_retcode NUMBER;

Line 421: l_lac_sf52_rec ghr_pa_requests%rowtype;

417:
418: l_row_cnt NUMBER := 0;
419:
420: l_sf52_rec ghr_pa_requests%rowtype;
421: l_lac_sf52_rec ghr_pa_requests%rowtype;
422: l_errbuf VARCHAR2(2000);
423:
424: l_retcode NUMBER;
425:

Line 676: ghr_pa_requests_pkg.get_sf52_asg_ddf_details

672: ,p_business_group_id => per.business_group_id
673: );
674: l_ind := 60;
675: BEGIN
676: ghr_pa_requests_pkg.get_sf52_asg_ddf_details
677: (l_assignment_id,
678: l_effective_DATE,
679: l_tenure,
680: l_annuitant_indicator,

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

682: l_work_schedule,
683: l_part_time_hour);
684: EXCEPTION
685: when others then
686: pr('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details');
687: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details'||
688: 'Err is '||sqlerrm(sqlcode),20);
689: l_mslerrbuf := 'Error in get_sf52_asgddf_details Sql Err is '||
690: sqlerrm(sqlcode);

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

683: l_part_time_hour);
684: EXCEPTION
685: when others then
686: pr('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details');
687: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details'||
688: 'Err is '||sqlerrm(sqlcode),20);
689: l_mslerrbuf := 'Error in get_sf52_asgddf_details Sql Err is '||
690: sqlerrm(sqlcode);
691: raise mass_error;

Line 710: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

706: raise mass_error;
707: END;
708: l_ind := 70;
709: BEGIN
710: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
711: (p_location_id => l_location_id
712: ,p_duty_station_id => l_duty_station_id);
713: EXCEPTION
714: when others then

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

711: (p_location_id => l_location_id
712: ,p_duty_station_id => l_duty_station_id);
713: EXCEPTION
714: when others then
715: pr('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details');
716: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_loc_ddf_details'||
717: 'Err is '||sqlerrm(sqlcode),20);
718: -- Bug 3718167 Added Person,SSN in the message instead of person_id
719: l_mslerrbuf := 'Error in get_sf52_loc_ddf_details Sql Err is '||

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

712: ,p_duty_station_id => l_duty_station_id);
713: EXCEPTION
714: when others then
715: pr('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details');
716: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_loc_ddf_details'||
717: 'Err is '||sqlerrm(sqlcode),20);
718: -- Bug 3718167 Added Person,SSN in the message instead of person_id
719: l_mslerrbuf := 'Error in get_sf52_loc_ddf_details Sql Err is '||
720: sqlerrm(sqlcode);

Line 733: ghr_pa_requests_pkg.get_duty_station_details

729: l_appropriation_code2);
730: --l_pos_grp2_rec);
731: l_ind := 90;
732: BEGIN
733: ghr_pa_requests_pkg.get_duty_station_details
734: (p_duty_station_id => l_duty_station_id
735: ,p_effective_DATE => l_effective_DATE
736: ,p_duty_station_code => l_duty_station_code
737: ,p_duty_station_desc => l_duty_station_desc);

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

736: ,p_duty_station_code => l_duty_station_code
737: ,p_duty_station_desc => l_duty_station_desc);
738: EXCEPTION
739: when others then
740: pr('Error in Ghr_pa_requests_pkg.get_duty_station_details');
741: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_duty_station_details'||
742: 'Err is '||sqlerrm(sqlcode),20);
743: l_mslerrbuf := 'Error in get_duty_station_details Sql Err is '||
744: sqlerrm(sqlcode);

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

737: ,p_duty_station_desc => l_duty_station_desc);
738: EXCEPTION
739: when others then
740: pr('Error in Ghr_pa_requests_pkg.get_duty_station_details');
741: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_duty_station_details'||
742: 'Err is '||sqlerrm(sqlcode),20);
743: l_mslerrbuf := 'Error in get_duty_station_details Sql Err is '||
744: sqlerrm(sqlcode);
745: raise mass_error;

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

1051: END;
1052:
1053: --Call Pay cap Procedure
1054: BEGIN
1055: l_capped_other_pay := ghr_pa_requests_pkg2.get_cop( p_assignment_id => l_assignment_id
1056: ,p_effective_DATE => l_effective_DATE);
1057: ghr_pay_caps.do_pay_caps_main
1058: (p_pa_request_id => null
1059: ,p_effective_DATE => l_effective_DATE

Line 1274: l_approving_off_work_title ghr_pa_requests.APPROVING_OFFICIAL_WORK_TITLE%type;

1270: l_position_org_line6 VARCHAR2(40);
1271: l_par_object_version_NUMBER NUMBER := l_sf52_rec.object_version_NUMBER;
1272: l_dummy NUMBER;
1273: l_personnel_officer_name per_people_f.full_name%type;
1274: l_approving_off_work_title ghr_pa_requests.APPROVING_OFFICIAL_WORK_TITLE%type;
1275: BEGIN
1276: ghr_pa_requests_pkg.get_rei_org_lines(
1277: p_pa_request_id => l_sf52_rec.pa_request_id,
1278: p_organization_id => l_organization_id,

Line 1276: ghr_pa_requests_pkg.get_rei_org_lines(

1272: l_dummy NUMBER;
1273: l_personnel_officer_name per_people_f.full_name%type;
1274: l_approving_off_work_title ghr_pa_requests.APPROVING_OFFICIAL_WORK_TITLE%type;
1275: BEGIN
1276: ghr_pa_requests_pkg.get_rei_org_lines(
1277: p_pa_request_id => l_sf52_rec.pa_request_id,
1278: p_organization_id => l_organization_id,
1279: p_position_org_line1 => l_position_org_line1,
1280: p_position_org_line2 => l_position_org_line2,

Line 1317: l_pa_request_NUMBER ghr_pa_requests.request_NUMBER%TYPE;

1313: END IF;
1314:
1315: -- Added by Dinkar for reports
1316: declare
1317: l_pa_request_NUMBER ghr_pa_requests.request_NUMBER%TYPE;
1318: --
1319: BEGIN
1320: l_pa_request_NUMBER :=
1321: l_sf52_rec.request_NUMBER||'-'||p_mass_realignment_id;

Line 1509: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

1505: l_appropriation_code1,
1506: l_appropriation_code2);
1507:
1508: BEGIN
1509: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
1510: (p_location_id => l_location_id
1511: ,p_duty_station_id => l_duty_station_id);
1512: END;
1513:

Line 1515: ghr_pa_requests_pkg.get_duty_station_details

1511: ,p_duty_station_id => l_duty_station_id);
1512: END;
1513:
1514: BEGIN
1515: ghr_pa_requests_pkg.get_duty_station_details
1516: (p_duty_station_id => l_duty_station_id
1517: ,p_effective_DATE => l_effective_DATE
1518: ,p_duty_station_code => l_duty_station_code
1519: ,p_duty_station_desc => l_duty_station_desc);

Line 1724: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

1720: );
1721:
1722: l_location_id := per_vacant.location_id;
1723: BEGIN
1724: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
1725: (p_location_id => l_location_id
1726: ,p_duty_station_id => l_duty_station_id);
1727: END;
1728:

Line 1730: ghr_pa_requests_pkg.get_duty_station_details

1726: ,p_duty_station_id => l_duty_station_id);
1727: END;
1728:
1729: BEGIN
1730: ghr_pa_requests_pkg.get_duty_station_details
1731: (p_duty_station_id => l_duty_station_id
1732: ,p_effective_DATE => l_effective_DATE
1733: ,p_duty_station_code => l_duty_station_code
1734: ,p_duty_station_desc => l_duty_station_desc);

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

2073: B.NAME ORGANIZATION_NAME,
2074: */
2075: EMPLOYEE_ASSIGNMENT_ID,
2076: PAY_RATE_DETERMINANT
2077: from ghr_pa_requests /*, per_organization_units B*/
2078: WHERE person_id = p_person_id
2079: and effective_DATE = p_effective_DATE
2080: -- Added by Dinkar for reports
2081: and substr(request_NUMBER,(instr(request_NUMBER,'-')+1)) = to_char(p_mass_realignment_id)

Line 2553: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;

2549: l_name per_people_f.full_name%type;
2550: -- Bug#3718167 Added l_ssn
2551: l_ssn per_people_f.national_identifier%TYPE;
2552: l_code_action VARCHAR2(65);
2553: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
2554:
2555: cursor csr_action_taken is
2556: SELECT pr.pa_request_id, max(pa_routing_history_id) pa_routing_history_id
2557: from ghr_pa_requests pr, ghr_pa_routing_history prh

Line 2557: from ghr_pa_requests pr, ghr_pa_routing_history prh

2553: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
2554:
2555: cursor csr_action_taken is
2556: SELECT pr.pa_request_id, max(pa_routing_history_id) pa_routing_history_id
2557: from ghr_pa_requests pr, ghr_pa_routing_history prh
2558: WHERE pr.pa_request_id = prh.pa_request_id
2559: and person_id = p_person_id
2560: and first_noa_code = p_first_noa_code
2561: and effective_DATE = p_effective_DATE

Line 2571: from ghr_pa_requests pr

2567: -- Bug#3718167 Added SSN in the cursor
2568: cursor csr_name is
2569: SELECT substr(pr.employee_last_name || ', ' || pr.employee_first_name,1,240) fname,
2570: pr.employee_national_identifier SSN
2571: from ghr_pa_requests pr
2572: WHERE pr.pa_request_id = l_pa_request_id;
2573:
2574: cursor pa_hist_cur (p_r_hist_id NUMBER) is
2575: SELECT nvl(action_taken,' ') action_taken

Line 2633: from ghr_pa_requests pr, ghr_pa_routing_history prh

2629: return BOOLEAN is
2630: --
2631: cursor csr_action_taken is
2632: SELECT pr.pa_request_id, max(pa_routing_history_id) pa_routing_history_id
2633: from ghr_pa_requests pr, ghr_pa_routing_history prh
2634: WHERE pr.pa_request_id = prh.pa_request_id
2635: and nvl(person_id,0) = p_person_id
2636: and nvl(second_noa_code,0) = p_second_noa_code
2637: and trunc(nvl(effective_DATE,sysDATE)) = trunc(p_effective_DATE)

Line 3526: ghr_pa_requests_pkg.get_duty_station_details

3522: END IF;
3523:
3524: if l_duty_station_id is not null or o_duty_station_id is not null then
3525: ----- Duty station is changed
3526: ghr_pa_requests_pkg.get_duty_station_details
3527: (p_duty_station_id => ll_duty_station_id
3528: ,p_effective_DATE => p_effective_DATE
3529: ,p_duty_station_code => ll_duty_station_code
3530: ,p_duty_station_desc => ll_duty_station_desc);

Line 3638: p_duty_station_code in ghr_pa_requests.duty_station_code%type,

3634: p_personnel_office_id in VARCHAR2,
3635: p_sub_element_code in VARCHAR2,
3636: p_duty_station_id in NUMBER,
3637: p_duty_station_locn_id in NUMBER,
3638: p_duty_station_code in ghr_pa_requests.duty_station_code%type,
3639: p_duty_station_desc in ghr_pa_requests.duty_station_desc%type,
3640: p_office_symbol in VARCHAR2,
3641: p_payroll_office_id in VARCHAR2,
3642: p_org_func_code in VARCHAR2,

Line 3639: p_duty_station_desc in ghr_pa_requests.duty_station_desc%type,

3635: p_sub_element_code in VARCHAR2,
3636: p_duty_station_id in NUMBER,
3637: p_duty_station_locn_id in NUMBER,
3638: p_duty_station_code in ghr_pa_requests.duty_station_code%type,
3639: p_duty_station_desc in ghr_pa_requests.duty_station_desc%type,
3640: p_office_symbol in VARCHAR2,
3641: p_payroll_office_id in VARCHAR2,
3642: p_org_func_code in VARCHAR2,
3643: p_appropriation_code1 in VARCHAR2,

Line 3646: p_lac_sf52_rec in ghr_pa_requests%rowtype,

3642: p_org_func_code in VARCHAR2,
3643: p_appropriation_code1 in VARCHAR2,
3644: p_appropriation_code2 in VARCHAR2,
3645: p_position_organization in VARCHAR2,
3646: p_lac_sf52_rec in ghr_pa_requests%rowtype,
3647: p_sf52_rec out NOCOPY ghr_pa_requests%rowtype) IS
3648:
3649: l_proc VARCHAR2(72)
3650: := g_package || '.assign_to_sf52_rec';

Line 3647: p_sf52_rec out NOCOPY ghr_pa_requests%rowtype) IS

3643: p_appropriation_code1 in VARCHAR2,
3644: p_appropriation_code2 in VARCHAR2,
3645: p_position_organization in VARCHAR2,
3646: p_lac_sf52_rec in ghr_pa_requests%rowtype,
3647: p_sf52_rec out NOCOPY ghr_pa_requests%rowtype) IS
3648:
3649: l_proc VARCHAR2(72)
3650: := g_package || '.assign_to_sf52_rec';
3651: BEGIN