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

Line 226: l_duty_station_desc ghr_pa_requests.duty_station_desc%type;

222: l_step_or_rate varchar2(30);
223: l_pay_basis varchar2(30);
224: l_location_id number;
225: l_duty_station_id number;
226: l_duty_station_desc ghr_pa_requests.duty_station_desc%type;
227: l_duty_station_code ghr_pa_requests.duty_station_code%type;
228: l_effective_date date;
229: l_personnel_office_id varchar2(300);
230: l_org_structure_id varchar2(300);

Line 227: l_duty_station_code ghr_pa_requests.duty_station_code%type;

223: l_pay_basis varchar2(30);
224: l_location_id number;
225: l_duty_station_id number;
226: l_duty_station_desc ghr_pa_requests.duty_station_desc%type;
227: l_duty_station_code ghr_pa_requests.duty_station_code%type;
228: l_effective_date date;
229: l_personnel_office_id varchar2(300);
230: l_org_structure_id varchar2(300);
231: l_sub_element_code varchar2(300);

Line 291: l_sf52_rec ghr_pa_requests%rowtype;

287: l_p_PERSONNEL_OFFICE_ID varchar2(5);
288:
289: L_row_cnt number := 0;
290:
291: l_sf52_rec ghr_pa_requests%rowtype;
292: l_lac_sf52_rec ghr_pa_requests%rowtype;
293: l_errbuf varchar2(2000);
294:
295: l_retcode number;

Line 292: l_lac_sf52_rec ghr_pa_requests%rowtype;

288:
289: L_row_cnt number := 0;
290:
291: l_sf52_rec ghr_pa_requests%rowtype;
292: l_lac_sf52_rec ghr_pa_requests%rowtype;
293: l_errbuf varchar2(2000);
294:
295: l_retcode number;
296:

Line 511: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

507: END IF;
508: -- End of bug 3437354
509:
510: /* -- BEGIN
511: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
512: (p_location_id => l_location_id
513: ,p_duty_station_id => l_duty_station_id);
514: / *exception
515: when others then

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

513: ,p_duty_station_id => l_duty_station_id);
514: / *exception
515: when others then
516: hr_utility.set_location(
517: 'Error in Ghr_pa_requests_pkg.get_sf52_loc_ddf_details'||
518: 'Err is '||sqlerrm(sqlcode),20);
519: l_mslerrbuf := 'Error in get_sf52_loc_ddf_details '||
520: 'Sql Err is '|| sqlerrm(sqlcode);
521: raise msl_error;

Line 557: ghr_pa_requests_pkg.get_sf52_asg_ddf_details

553: -- Bug 3457205 Filter the Pay plan table id condition also b4 checking any other thing
554: -- Moving check_eligibility to here.
555: -- Get PRD, work schedule etc form ASG EI
556: begin
557: ghr_pa_requests_pkg.get_sf52_asg_ddf_details
558: (l_assignment_id,
559: l_effective_date,
560: l_tenure,
561: l_annuitant_indicator,

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

563: l_work_schedule,
564: l_part_time_hour);
565: exception
566: when others then
567: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details'||
568: 'Err is '||sqlerrm(sqlcode),20);
569: l_mslerrbuf := 'Error in get_sf52_asgddf_details Sql Err is '|| sqlerrm(sqlcode);
570: raise msl_error;
571: end;

Line 627: ghr_pa_requests_pkg.get_duty_station_details

623: hr_utility.set_location('check_select_flg ' || l_proc,7);
624: BEGIN
625: hr_utility.set_location('The duty station name is:'||l_duty_station_code,12345);
626: hr_utility.set_location('The duty station desc is:'||l_duty_station_desc,12345);
627: ghr_pa_requests_pkg.get_duty_station_details
628: (p_duty_station_id => l_duty_station_id
629: ,p_effective_date => l_effective_date
630: ,p_duty_station_code => l_duty_station_code
631: ,p_duty_station_desc => l_duty_station_desc);

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

630: ,p_duty_station_code => l_duty_station_code
631: ,p_duty_station_desc => l_duty_station_desc);
632: EXCEPTION
633: WHEN others THEN
634: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_duty_station_details'||
635: 'Err is '||sqlerrm(sqlcode),20);
636: l_mslerrbuf := 'Error in get_duty_station_details Sql Err is '|| sqlerrm(sqlcode);
637: RAISE msl_error;
638:

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

835:
836:
837: -------------Call Pay cap Procedure
838: begin
839: l_capped_other_pay := ghr_pa_requests_pkg2.get_cop( p_assignment_id => l_assignment_id
840: ,p_effective_date => l_effective_date);
841: l_old_capped_other_pay := l_capped_other_pay;
842: -- Sundar Added the following if statement to improve performance
843: if hr_utility.debug_enabled = true then

Line 1148: l_pa_request_number ghr_pa_requests.request_number%TYPE;

1144: ---------------------------------------
1145: IF l_errbuf IS NULL THEN
1146:
1147: DECLARE
1148: l_pa_request_number ghr_pa_requests.request_number%TYPE;
1149: BEGIN
1150: l_pa_request_number :=
1151: l_sf52_rec.request_number||'-'||p_mass_salary_id;
1152:

Line 1826: FROM ghr_pa_requests

1822: input_pay_rate_determinant,
1823: from_pay_table_identifier,
1824: to_pay_table_identifier
1825: -- FWFA Changes
1826: FROM ghr_pa_requests
1827: WHERE person_id = p_person_id
1828: AND effective_date = p_effective_date
1829: -- Added by Dinkar for reports
1830: AND SUBSTR(request_number,(instr(request_number,'-')+1)) = TO_CHAR(p_mass_salary_id)

Line 2890: l_duty_station_desc ghr_pa_requests.duty_station_desc%type;

2886: -- Bug#5089732
2887: l_step_or_rate VARCHAR2(30);
2888: l_pay_basis VARCHAR2(30);
2889: l_duty_station_id NUMBER;
2890: l_duty_station_desc ghr_pa_requests.duty_station_desc%type;
2891: l_duty_station_code ghr_pa_requests.duty_station_code%type;
2892: l_effective_date DATE;
2893: l_personnel_office_id VARCHAR2(300);
2894: l_org_structure_id VARCHAR2(300);

Line 2891: l_duty_station_code ghr_pa_requests.duty_station_code%type;

2887: l_step_or_rate VARCHAR2(30);
2888: l_pay_basis VARCHAR2(30);
2889: l_duty_station_id NUMBER;
2890: l_duty_station_desc ghr_pa_requests.duty_station_desc%type;
2891: l_duty_station_code ghr_pa_requests.duty_station_code%type;
2892: l_effective_date DATE;
2893: l_personnel_office_id VARCHAR2(300);
2894: l_org_structure_id VARCHAR2(300);
2895: l_sub_element_code VARCHAR2(300);

Line 2971: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

2967: NOT(l_fetch_agency_data) THEN
2968: hr_utility.set_location('Agency PASS',30);
2969: IF p_msl_duty_station_id IS NOT NULL THEN
2970: hr_utility.set_location('DS CHECK',35);
2971: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
2972: (p_location_id => l_location_id
2973: ,p_duty_station_id => l_duty_station_id);
2974: l_fetch_ds_data := TRUE;
2975: END IF;

Line 3004: ghr_pa_requests_pkg.get_sf52_asg_ddf_details

3000:
3001: -- If the initial eligibility is passed then proceed further. Otherwise move to next record.
3002: IF init_elig_flag THEN
3003: hr_utility.set_location('Init Criteria Pass',95);
3004: ghr_pa_requests_pkg.get_sf52_asg_ddf_details
3005: (l_assignment_id,
3006: l_effective_date,
3007: l_tenure,
3008: l_annuitant_indicator,

Line 3111: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

3107: l_pos_grp1_rec);
3108: END IF;
3109:
3110: IF NOT l_fetch_ds_data THEN
3111: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
3112: (p_location_id => l_location_id
3113: ,p_duty_station_id => l_duty_station_id);
3114: END IF;
3115:

Line 3251: l_duty_station_desc ghr_pa_requests.duty_station_desc%type;

3247: l_grade_or_level VARCHAR2(30);
3248: l_step_or_rate VARCHAR2(30);
3249: l_pay_basis VARCHAR2(30);
3250: l_duty_station_id NUMBER;
3251: l_duty_station_desc ghr_pa_requests.duty_station_desc%type;
3252: l_duty_station_code ghr_pa_requests.duty_station_code%type;
3253: l_effective_date DATE;
3254: l_personnel_office_id VARCHAR2(300);
3255: l_org_structure_id VARCHAR2(300);

Line 3252: l_duty_station_code ghr_pa_requests.duty_station_code%type;

3248: l_step_or_rate VARCHAR2(30);
3249: l_pay_basis VARCHAR2(30);
3250: l_duty_station_id NUMBER;
3251: l_duty_station_desc ghr_pa_requests.duty_station_desc%type;
3252: l_duty_station_code ghr_pa_requests.duty_station_code%type;
3253: l_effective_date DATE;
3254: l_personnel_office_id VARCHAR2(300);
3255: l_org_structure_id VARCHAR2(300);
3256: l_sub_element_code VARCHAR2(300);

Line 3330: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

3326: NOT(l_fetch_agency_data) THEN
3327: hr_utility.set_location('Agency PASS',30);
3328: IF p_msl_duty_station_id IS NOT NULL THEN
3329: hr_utility.set_location('DS CHECK',35);
3330: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
3331: (p_location_id => l_location_id
3332: ,p_duty_station_id => l_duty_station_id);
3333: l_fetch_ds_data := TRUE;
3334: END IF;

Line 3363: ghr_pa_requests_pkg.get_sf52_asg_ddf_details

3359:
3360: -- If the initial eligibility is passed then proceed further. Otherwise move to next record.
3361: IF init_elig_flag THEN
3362: hr_utility.set_location('Init Criteria Pass',95);
3363: ghr_pa_requests_pkg.get_sf52_asg_ddf_details
3364: (l_assignment_id,
3365: l_effective_date,
3366: l_tenure,
3367: l_annuitant_indicator,

Line 3464: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

3460: l_pos_grp1_rec);
3461: END IF;
3462:
3463: IF NOT l_fetch_ds_data THEN
3464: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
3465: (p_location_id => l_location_id
3466: ,p_duty_station_id => l_duty_station_id);
3467: END IF;
3468:

Line 3718: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;

3714: --
3715: l_name per_people_f.full_name%type;
3716: -- Bug#3718167 Added l_ssn
3717: l_ssn per_people_f.national_identifier%TYPE;
3718: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
3719: --Bug # 9329643
3720: l_employee_number per_people_f.employee_number%type;
3721:
3722: cursor csr_action_taken is

Line 3724: from ghr_pa_requests pr, ghr_pa_routing_history prh

3720: l_employee_number per_people_f.employee_number%type;
3721:
3722: cursor csr_action_taken is
3723: select pr.pa_request_id, max(pa_routing_history_id) pa_routing_history_id
3724: from ghr_pa_requests pr, ghr_pa_routing_history prh
3725: where pr.pa_request_id = prh.pa_request_id
3726: and person_id = p_person_id
3727: and first_noa_code = p_first_noa_code
3728: and effective_date = p_effective_date

Line 3738: from ghr_pa_requests pr

3734: -- Bug#3718167
3735: cursor csr_name_ssn is
3736: select substr(pr.employee_last_name || ', ' || pr.employee_first_name,1,240) fname,
3737: pr.employee_national_identifier SSN
3738: from ghr_pa_requests pr
3739: where pr.pa_request_id = l_pa_request_id;
3740:
3741: cursor csr_action_taken_fw is
3742: select pr.pa_request_id, max(pa_routing_history_id) pa_routing_history_id

Line 3743: from ghr_pa_requests pr, ghr_pa_routing_history prh

3739: where pr.pa_request_id = l_pa_request_id;
3740:
3741: cursor csr_action_taken_fw is
3742: select pr.pa_request_id, max(pa_routing_history_id) pa_routing_history_id
3743: from ghr_pa_requests pr, ghr_pa_routing_history prh
3744: where pr.pa_request_id = prh.pa_request_id
3745: and person_id = p_person_id
3746: and first_noa_code = p_first_noa_code
3747: and effective_date = p_effective_date

Line 3791: l_employee_number := ghr_pa_requests_pkg2.get_employee_number

3787: exit;
3788: end loop;
3789: --Bug # 9329643
3790: If p_person_id is not null then
3791: l_employee_number := ghr_pa_requests_pkg2.get_employee_number
3792: (p_person_id => p_person_id,
3793: p_effective_date => p_effective_date);
3794: End if;
3795: if l_action_taken <> 'CANCELED' then

Line 3825: l_employee_number := ghr_pa_requests_pkg2.get_employee_number

3821: exit;
3822: end loop;
3823: --Bug # 9329643
3824: If p_person_id is not null then
3825: l_employee_number := ghr_pa_requests_pkg2.get_employee_number
3826: (p_person_id => p_person_id,
3827: p_effective_date => p_effective_date);
3828: End if;
3829: if l_action_taken <> 'CANCELED' then

Line 3859: from ghr_pa_requests pr, ghr_pa_routing_history prh

3855: return boolean is
3856: --
3857: cursor csr_action_taken is
3858: select pr.pa_request_id, max(pa_routing_history_id) pa_routing_history_id
3859: from ghr_pa_requests pr, ghr_pa_routing_history prh
3860: where pr.pa_request_id = prh.pa_request_id
3861: and nvl(person_id,0) = p_person_id
3862: and nvl(second_noa_code,0) = p_second_noa_code
3863: and nvl(effective_date,trunc(sysdate)) >= (p_effective_date-p_days)

Line 4681: p_sf52_rec out nocopy ghr_pa_requests%rowtype) IS

4677: --
4678:
4679: procedure get_lac_dtls
4680: (p_pa_request_id in number,
4681: p_sf52_rec out nocopy ghr_pa_requests%rowtype) IS
4682:
4683: l_proc varchar2(72) := g_package || '.get_lac_dtls';
4684:
4685: cursor cur_pa_req_cur is

Line 4686: select * from ghr_pa_requests

4682:
4683: l_proc varchar2(72) := g_package || '.get_lac_dtls';
4684:
4685: cursor cur_pa_req_cur is
4686: select * from ghr_pa_requests
4687: where pa_request_id = p_pa_request_id;
4688:
4689: begin
4690: g_proc := 'get_lac_dtls';

Line 4849: p_duty_station_code in ghr_pa_requests.duty_station_code%type,

4845: p_to_supervisory_differential in number,
4846: p_to_supervisory_diff_perce in number,
4847: p_to_staffing_differential in number,
4848: p_duty_station_id in number,
4849: p_duty_station_code in ghr_pa_requests.duty_station_code%type,
4850: p_duty_station_desc in ghr_pa_requests.duty_station_desc%type,
4851: -- FWFA Changes Bug#4444609
4852: p_input_pay_rate_determinant in ghr_pa_requests.input_pay_rate_determinant%type,
4853: p_from_pay_table_id in ghr_pa_requests.from_pay_table_identifier%type,

Line 4850: p_duty_station_desc in ghr_pa_requests.duty_station_desc%type,

4846: p_to_supervisory_diff_perce in number,
4847: p_to_staffing_differential in number,
4848: p_duty_station_id in number,
4849: p_duty_station_code in ghr_pa_requests.duty_station_code%type,
4850: p_duty_station_desc in ghr_pa_requests.duty_station_desc%type,
4851: -- FWFA Changes Bug#4444609
4852: p_input_pay_rate_determinant in ghr_pa_requests.input_pay_rate_determinant%type,
4853: p_from_pay_table_id in ghr_pa_requests.from_pay_table_identifier%type,
4854: p_to_pay_table_id in ghr_pa_requests.to_pay_table_identifier%type,

Line 4852: p_input_pay_rate_determinant in ghr_pa_requests.input_pay_rate_determinant%type,

4848: p_duty_station_id in number,
4849: p_duty_station_code in ghr_pa_requests.duty_station_code%type,
4850: p_duty_station_desc in ghr_pa_requests.duty_station_desc%type,
4851: -- FWFA Changes Bug#4444609
4852: p_input_pay_rate_determinant in ghr_pa_requests.input_pay_rate_determinant%type,
4853: p_from_pay_table_id in ghr_pa_requests.from_pay_table_identifier%type,
4854: p_to_pay_table_id in ghr_pa_requests.to_pay_table_identifier%type,
4855: -- FWFA Changes
4856: p_lac_sf52_rec in ghr_pa_requests%rowtype,

Line 4853: p_from_pay_table_id in ghr_pa_requests.from_pay_table_identifier%type,

4849: p_duty_station_code in ghr_pa_requests.duty_station_code%type,
4850: p_duty_station_desc in ghr_pa_requests.duty_station_desc%type,
4851: -- FWFA Changes Bug#4444609
4852: p_input_pay_rate_determinant in ghr_pa_requests.input_pay_rate_determinant%type,
4853: p_from_pay_table_id in ghr_pa_requests.from_pay_table_identifier%type,
4854: p_to_pay_table_id in ghr_pa_requests.to_pay_table_identifier%type,
4855: -- FWFA Changes
4856: p_lac_sf52_rec in ghr_pa_requests%rowtype,
4857: p_sf52_rec out nocopy ghr_pa_requests%rowtype) IS

Line 4854: p_to_pay_table_id in ghr_pa_requests.to_pay_table_identifier%type,

4850: p_duty_station_desc in ghr_pa_requests.duty_station_desc%type,
4851: -- FWFA Changes Bug#4444609
4852: p_input_pay_rate_determinant in ghr_pa_requests.input_pay_rate_determinant%type,
4853: p_from_pay_table_id in ghr_pa_requests.from_pay_table_identifier%type,
4854: p_to_pay_table_id in ghr_pa_requests.to_pay_table_identifier%type,
4855: -- FWFA Changes
4856: p_lac_sf52_rec in ghr_pa_requests%rowtype,
4857: p_sf52_rec out nocopy ghr_pa_requests%rowtype) IS
4858:

Line 4856: p_lac_sf52_rec in ghr_pa_requests%rowtype,

4852: p_input_pay_rate_determinant in ghr_pa_requests.input_pay_rate_determinant%type,
4853: p_from_pay_table_id in ghr_pa_requests.from_pay_table_identifier%type,
4854: p_to_pay_table_id in ghr_pa_requests.to_pay_table_identifier%type,
4855: -- FWFA Changes
4856: p_lac_sf52_rec in ghr_pa_requests%rowtype,
4857: p_sf52_rec out nocopy ghr_pa_requests%rowtype) IS
4858:
4859: l_proc varchar2(72) := g_package || '.assign_to_sf52_rec';
4860: begin

Line 4857: p_sf52_rec out nocopy ghr_pa_requests%rowtype) IS

4853: p_from_pay_table_id in ghr_pa_requests.from_pay_table_identifier%type,
4854: p_to_pay_table_id in ghr_pa_requests.to_pay_table_identifier%type,
4855: -- FWFA Changes
4856: p_lac_sf52_rec in ghr_pa_requests%rowtype,
4857: p_sf52_rec out nocopy ghr_pa_requests%rowtype) IS
4858:
4859: l_proc varchar2(72) := g_package || '.assign_to_sf52_rec';
4860: begin
4861:

Line 5125: l_duty_station_desc ghr_pa_requests.duty_station_desc%type;

5121: l_step_or_rate varchar2(30);
5122: l_pay_basis varchar2(30);
5123: l_location_id number;
5124: l_duty_station_id number;
5125: l_duty_station_desc ghr_pa_requests.duty_station_desc%type;
5126: l_duty_station_code ghr_pa_requests.duty_station_code%type;
5127: l_effective_date date;
5128: l_personnel_office_id varchar2(300);
5129: l_org_structure_id varchar2(300);

Line 5126: l_duty_station_code ghr_pa_requests.duty_station_code%type;

5122: l_pay_basis varchar2(30);
5123: l_location_id number;
5124: l_duty_station_id number;
5125: l_duty_station_desc ghr_pa_requests.duty_station_desc%type;
5126: l_duty_station_code ghr_pa_requests.duty_station_code%type;
5127: l_effective_date date;
5128: l_personnel_office_id varchar2(300);
5129: l_org_structure_id varchar2(300);
5130: l_sub_element_code varchar2(300);

Line 5186: l_sf52_rec ghr_pa_requests%rowtype;

5182: l_p_PERSONNEL_OFFICE_ID varchar2(5);
5183:
5184: L_row_cnt number := 0;
5185:
5186: l_sf52_rec ghr_pa_requests%rowtype;
5187: l_lac_sf52_rec ghr_pa_requests%rowtype;
5188: l_errbuf varchar2(2000);
5189:
5190: l_retcode number;

Line 5187: l_lac_sf52_rec ghr_pa_requests%rowtype;

5183:
5184: L_row_cnt number := 0;
5185:
5186: l_sf52_rec ghr_pa_requests%rowtype;
5187: l_lac_sf52_rec ghr_pa_requests%rowtype;
5188: l_errbuf varchar2(2000);
5189:
5190: l_retcode number;
5191:

Line 5484: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

5480: END IF;
5481: -- End of bug 3437354
5482:
5483: /*begin
5484: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
5485: (p_location_id => l_location_id
5486: ,p_duty_station_id => l_duty_station_id);
5487: exception
5488: when others then

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

5486: ,p_duty_station_id => l_duty_station_id);
5487: exception
5488: when others then
5489: hr_utility.set_location(
5490: 'Error in Ghr_pa_requests_pkg.get_sf52_loc_ddf_details'||
5491: 'Err is '||sqlerrm(sqlcode),20);
5492: l_mslerrbuf := 'Error in get_sf52_loc_ddf_details '||
5493: 'Sql Err is '|| sqlerrm(sqlcode);
5494: raise msl_error;

Line 5535: ghr_pa_requests_pkg.get_sf52_asg_ddf_details

5531: -- Bug 3457205 Filter the Pay plan table id condition also b4 checking any other thing
5532: -- Moving check_eligibility to here.
5533: -- Get PRD, work schedule etc form ASG EI
5534: begin
5535: ghr_pa_requests_pkg.get_sf52_asg_ddf_details
5536: (l_assignment_id,
5537: l_effective_date,
5538: l_tenure,
5539: l_annuitant_indicator,

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

5541: l_work_schedule,
5542: l_part_time_hour);
5543: exception
5544: when others then
5545: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details'||
5546: 'Err is '||sqlerrm(sqlcode),20);
5547: l_mslerrbuf := 'Error in get_sf52_asgddf_details Sql Err is '|| sqlerrm(sqlcode);
5548: raise msl_error;
5549: end;

Line 5607: ghr_pa_requests_pkg.get_duty_station_details

5603: begin
5604: hr_utility.set_location('The duty station name is:'||l_duty_station_code,12345);
5605: hr_utility.set_location('The duty station desc is:'||l_duty_station_desc,12345);
5606:
5607: ghr_pa_requests_pkg.get_duty_station_details
5608: (p_duty_station_id => l_duty_station_id
5609: ,p_effective_date => l_effective_date
5610: ,p_duty_station_code => l_duty_station_code
5611: ,p_duty_station_desc => l_duty_station_desc);

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

5610: ,p_duty_station_code => l_duty_station_code
5611: ,p_duty_station_desc => l_duty_station_desc);
5612: exception
5613: when others then
5614: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_duty_station_details'||
5615: 'Err is '||sqlerrm(sqlcode),20);
5616: l_mslerrbuf := 'Error in get_duty_station_details Sql Err is '|| sqlerrm(sqlcode);
5617: raise msl_error;
5618:

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

5865: hr_utility.set_location('Supervisory Diff Amount = ' || to_char(l_supervisory_differential),10);
5866:
5867: -------------Call Pay cap Procedure
5868: begin
5869: l_capped_other_pay := ghr_pa_requests_pkg2.get_cop( p_assignment_id => l_assignment_id
5870: ,p_effective_date => l_effective_date);
5871: l_old_capped_other_pay := l_capped_other_pay;
5872: -- Sundar Added the following if statement to improve performance
5873: if hr_utility.debug_enabled = true then

Line 6162: l_pa_request_number ghr_pa_requests.request_number%TYPE;

6158: ------ Added by Dinkar for List reports problem
6159: ---------------------------------------
6160: IF l_errbuf IS NULL THEN
6161: DECLARE
6162: l_pa_request_number ghr_pa_requests.request_number%TYPE;
6163: BEGIN
6164: l_pa_request_number :=
6165: l_sf52_rec.request_number||'-'||p_mass_salary_id;
6166:

Line 6787: l_duty_station_desc ghr_pa_requests.duty_station_desc%type;

6783: -- Bug#5089732
6784: l_step_or_rate VARCHAR2(30);
6785: l_pay_basis VARCHAR2(30);
6786: l_duty_station_id NUMBER;
6787: l_duty_station_desc ghr_pa_requests.duty_station_desc%type;
6788: l_duty_station_code ghr_pa_requests.duty_station_code%type;
6789: l_effective_date DATE;
6790: l_personnel_office_id VARCHAR2(300);
6791: l_org_structure_id VARCHAR2(300);

Line 6788: l_duty_station_code ghr_pa_requests.duty_station_code%type;

6784: l_step_or_rate VARCHAR2(30);
6785: l_pay_basis VARCHAR2(30);
6786: l_duty_station_id NUMBER;
6787: l_duty_station_desc ghr_pa_requests.duty_station_desc%type;
6788: l_duty_station_code ghr_pa_requests.duty_station_code%type;
6789: l_effective_date DATE;
6790: l_personnel_office_id VARCHAR2(300);
6791: l_org_structure_id VARCHAR2(300);
6792: l_sub_element_code VARCHAR2(300);

Line 6876: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

6872: NOT(l_fetch_agency_data) THEN
6873: hr_utility.set_location('Agency PASS',30);
6874: IF p_msl_duty_station_id IS NOT NULL THEN
6875: hr_utility.set_location('DS CHECK',35);
6876: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
6877: (p_location_id => l_location_id
6878: ,p_duty_station_id => l_duty_station_id);
6879: l_fetch_ds_data := TRUE;
6880: END IF;

Line 6909: ghr_pa_requests_pkg.get_sf52_asg_ddf_details

6905:
6906: -- If the initial eligibility is passed then proceed further. Otherwise move to next record.
6907: IF init_elig_flag THEN
6908: hr_utility.set_location('Init Criteria Pass',95);
6909: ghr_pa_requests_pkg.get_sf52_asg_ddf_details
6910: (l_assignment_id,
6911: l_effective_date,
6912: l_tenure,
6913: l_annuitant_indicator,

Line 7042: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

7038: l_pos_grp1_rec);
7039: END IF;
7040:
7041: IF NOT l_fetch_ds_data THEN
7042: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
7043: (p_location_id => l_location_id
7044: ,p_duty_station_id => l_duty_station_id);
7045: END IF;
7046:

Line 7261: l_duty_station_desc ghr_pa_requests.duty_station_desc%type;

7257: l_step_or_rate varchar2(30);
7258: l_pay_basis varchar2(30);
7259: l_location_id number;
7260: l_duty_station_id number;
7261: l_duty_station_desc ghr_pa_requests.duty_station_desc%type;
7262: l_duty_station_code ghr_pa_requests.duty_station_code%type;
7263: l_effective_date date;
7264: l_personnel_office_id varchar2(300);
7265: l_org_structure_id varchar2(300);

Line 7262: l_duty_station_code ghr_pa_requests.duty_station_code%type;

7258: l_pay_basis varchar2(30);
7259: l_location_id number;
7260: l_duty_station_id number;
7261: l_duty_station_desc ghr_pa_requests.duty_station_desc%type;
7262: l_duty_station_code ghr_pa_requests.duty_station_code%type;
7263: l_effective_date date;
7264: l_personnel_office_id varchar2(300);
7265: l_org_structure_id varchar2(300);
7266: l_sub_element_code varchar2(300);

Line 7327: l_sf52_rec ghr_pa_requests%rowtype;

7323: l_p_PERSONNEL_OFFICE_ID varchar2(5);
7324:
7325: L_row_cnt number := 0;
7326:
7327: l_sf52_rec ghr_pa_requests%rowtype;
7328: l_lac_sf52_rec ghr_pa_requests%rowtype;
7329: l_errbuf varchar2(2000);
7330:
7331: l_retcode number;

Line 7328: l_lac_sf52_rec ghr_pa_requests%rowtype;

7324:
7325: L_row_cnt number := 0;
7326:
7327: l_sf52_rec ghr_pa_requests%rowtype;
7328: l_lac_sf52_rec ghr_pa_requests%rowtype;
7329: l_errbuf varchar2(2000);
7330:
7331: l_retcode number;
7332:

Line 7521: l_lac_sf52_rec.first_action_la_desc1 := ghr_pa_requests_pkg.get_lookup_description(800,'GHR_US_LEGAL_AUTHORITY','Q3C');

7517: --5470182
7518: ghr_msl_pkg.g_first_noa_code := '890';
7519: l_lac_sf52_rec.first_action_la_code1 := 'Q3C';
7520: -- l_lac_sf52_rec.first_action_la_desc1 := 'Reg. 534.404(h)';
7521: l_lac_sf52_rec.first_action_la_desc1 := ghr_pa_requests_pkg.get_lookup_description(800,'GHR_US_LEGAL_AUTHORITY','Q3C');
7522:
7523: g_proc := 'Location Validation';
7524: -- Start of Bug3437354
7525: IF l_location_id IS NULL THEN

Line 7552: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

7548: END IF;
7549: -- End of bug 3437354
7550:
7551: /* -- BEGIN
7552: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
7553: (p_location_id => l_location_id
7554: ,p_duty_station_id => l_duty_station_id);
7555: / *exception
7556: when others then

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

7554: ,p_duty_station_id => l_duty_station_id);
7555: / *exception
7556: when others then
7557: hr_utility.set_location(
7558: 'Error in Ghr_pa_requests_pkg.get_sf52_loc_ddf_details'||
7559: 'Err is '||sqlerrm(sqlcode),20);
7560: l_mslerrbuf := 'Error in get_sf52_loc_ddf_details '||
7561: 'Sql Err is '|| sqlerrm(sqlcode);
7562: raise msl_error;

Line 7598: ghr_pa_requests_pkg.get_sf52_asg_ddf_details

7594: -- Bug 3457205 Filter the Pay plan table id condition also b4 checking any other thing
7595: -- Moving check_eligibility to here.
7596: -- Get PRD, work schedule etc form ASG EI
7597: begin
7598: ghr_pa_requests_pkg.get_sf52_asg_ddf_details
7599: (l_assignment_id,
7600: l_effective_date,
7601: l_tenure,
7602: l_annuitant_indicator,

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

7604: l_work_schedule,
7605: l_part_time_hour);
7606: exception
7607: when others then
7608: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details'||
7609: 'Err is '||sqlerrm(sqlcode),20);
7610: l_mslerrbuf := 'Error in get_sf52_asgddf_details Sql Err is '|| sqlerrm(sqlcode);
7611: raise msl_error;
7612: end;

Line 7668: ghr_pa_requests_pkg.get_duty_station_details

7664: hr_utility.set_location('check_select_flg ' || l_proc,7);
7665: BEGIN
7666: hr_utility.set_location('The duty station name is:'||l_duty_station_code,12345);
7667: hr_utility.set_location('The duty station desc is:'||l_duty_station_desc,12345);
7668: ghr_pa_requests_pkg.get_duty_station_details
7669: (p_duty_station_id => l_duty_station_id
7670: ,p_effective_date => l_effective_date
7671: ,p_duty_station_code => l_duty_station_code
7672: ,p_duty_station_desc => l_duty_station_desc);

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

7671: ,p_duty_station_code => l_duty_station_code
7672: ,p_duty_station_desc => l_duty_station_desc);
7673: EXCEPTION
7674: WHEN others THEN
7675: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_duty_station_details'||
7676: 'Err is '||sqlerrm(sqlcode),20);
7677: l_mslerrbuf := 'Error in get_duty_station_details Sql Err is '|| sqlerrm(sqlcode);
7678: RAISE msl_error;
7679:

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

7868:
7869:
7870: -------------Call Pay cap Procedure
7871: begin
7872: l_capped_other_pay := ghr_pa_requests_pkg2.get_cop( p_assignment_id => l_assignment_id
7873: ,p_effective_date => l_effective_date);
7874: l_old_capped_other_pay := l_capped_other_pay;
7875: -- Sundar Added the following if statement to improve performance
7876: if hr_utility.debug_enabled = true then

Line 8173: l_pa_request_number ghr_pa_requests.request_number%TYPE;

8169: ---------------------------------------
8170: IF l_errbuf IS NULL THEN
8171:
8172: DECLARE
8173: l_pa_request_number ghr_pa_requests.request_number%TYPE;
8174: BEGIN
8175: l_pa_request_number :=
8176: l_sf52_rec.request_number||'-'||p_mass_salary_id;
8177: