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_PROCESS_SF52 dependencies on GHR_PA_REQUESTS_PKG

Line 2784: l_employee_number := ghr_pa_requests_pkg2.get_employee_number

2780: hr_utility.set_location('l_rec ' || l_rec.first_noa_code,3);
2781:
2782: l_sf52_rec := l_rec;
2783: --Bug # 9329643
2784: l_employee_number := ghr_pa_requests_pkg2.get_employee_number
2785: (p_person_id => l_sf52_rec.person_id,
2786: p_effective_date => l_sf52_rec.effective_date);
2787:
2788: Begin

Line 3093: l_employee_number := ghr_pa_requests_pkg2.get_employee_number

3089: */
3090: hr_utility.set_location( l_proc, 20);
3091:
3092: --Bug # 9329643
3093: l_employee_number := ghr_pa_requests_pkg2.get_employee_number
3094: (p_person_id => l_sf52.person_id,
3095: p_effective_date => l_sf52.effective_date);
3096: l_log_text := 'Request Number : ' || p_sf52.request_number || l_new_line ||
3097: 'PA_REQUEST_ID : ' || to_char(p_sf52.pa_request_id) ||

Line 3912: l_capped_other_pay := ghr_pa_requests_pkg2.get_cop(l_assignment_id,

3908: ,p_work_schedule => l_dummy_varchar
3909:
3910: );
3911:
3912: l_capped_other_pay := ghr_pa_requests_pkg2.get_cop(l_assignment_id,
3913: nvl(p_effective_date, trunc(sysdate)));
3914:
3915: if (p_derive_to_cols) then
3916: p_sf52_data.to_organization_id := l_organization_id;

Line 3967: p_sf52_data.from_position_org_line1 := ghr_pa_requests_pkg2.get_agency_code_from(

3963: -- p_sf52_data.from_staffing_diff_percentage := l_staffing_diff_percentage;
3964: -- p_sf52_data.from_organization_id := l_organization_id;
3965: END IF;
3966: if (l_noa_family_code = 'APP') then
3967: p_sf52_data.from_position_org_line1 := ghr_pa_requests_pkg2.get_agency_code_from(
3968: p_pa_request_id => p_sf52_data.pa_request_id,
3969: p_noa_id => l_first_noa_id);
3970: else
3971: p_sf52_data.from_position_org_line1 := l_position_org_line1;

Line 3984: p_sf52_data.from_agency_desc := ghr_pa_requests_pkg.get_lookup_meaning(800

3980: l_agency_code := ghr_api.get_position_agency_code(
3981: p_person_id => p_person_id,
3982: p_assignment_id => l_assignment_id,
3983: p_effective_date => p_effective_date);
3984: p_sf52_data.from_agency_desc := ghr_pa_requests_pkg.get_lookup_meaning(800
3985: ,'GHR_US_AGENCY_CODE'
3986: ,l_agency_code);
3987: p_sf52_data.agency_code := l_agency_code;
3988: -- ????? is this the right from agency code?

Line 3997: ghr_pa_requests_pkg2.get_agency_code_to(

3993: return;
3994: end if;
3995: if (l_first_noa_code = '352') then
3996: p_sf52_data.to_position_org_line1 :=
3997: ghr_pa_requests_pkg2.get_agency_code_to(
3998: p_pa_request_id => p_sf52_data.pa_request_id,
3999: p_noa_id => l_first_noa_id);
4000: -- Added by ENUNEZ (23-FEB-2000 bug# 756335)
4001: elsif (l_first_noa_code = '002' and l_second_noa_code = '352') then

Line 4003: ghr_pa_requests_pkg2.get_agency_code_to(

3999: p_noa_id => l_first_noa_id);
4000: -- Added by ENUNEZ (23-FEB-2000 bug# 756335)
4001: elsif (l_first_noa_code = '002' and l_second_noa_code = '352') then
4002: p_sf52_data.to_position_org_line1 :=
4003: ghr_pa_requests_pkg2.get_agency_code_to(
4004: p_pa_request_id => p_sf52_data.pa_request_id,
4005: p_noa_id => l_second_noa_id);
4006: end if;
4007:

Line 4077: ghr_pa_requests_pkg2.get_agency_code_to(

4073: p_sf52_data.to_pay_basis := l_pay_basis;
4074: p_sf52_data.to_pay_plan := l_pay_plan;
4075: if (l_first_noa_code = '352') then
4076: p_sf52_data.to_position_org_line1 :=
4077: ghr_pa_requests_pkg2.get_agency_code_to(
4078: p_pa_request_id => p_sf52_data.pa_request_id,
4079: p_noa_id => l_first_noa_id);
4080: -- Added by ENUNEZ (23-FEB-2000 bug# 756335)
4081: elsif (l_first_noa_code = '002' and l_second_noa_code = '352') then

Line 4083: ghr_pa_requests_pkg2.get_agency_code_to(

4079: p_noa_id => l_first_noa_id);
4080: -- Added by ENUNEZ (23-FEB-2000 bug# 756335)
4081: elsif (l_first_noa_code = '002' and l_second_noa_code = '352') then
4082: p_sf52_data.to_position_org_line1 :=
4083: ghr_pa_requests_pkg2.get_agency_code_to(
4084: p_pa_request_id => p_sf52_data.pa_request_id,
4085: p_noa_id => l_second_noa_id);
4086: else
4087: p_sf52_data.to_position_org_line1 := l_position_org_line1;

Line 4234: ghr_pa_requests_pkg.get_sf52_to_data_elements

4230: --6850492
4231: END IF;
4232: hr_utility.set_location('bef call to to_data PRD ' || p_sf52_data.pay_rate_determinant ,15);
4233: hr_utility.set_location('bef call to to_data pay BAsis ' || p_sf52_data.to_pay_basis ,15);
4234: ghr_pa_requests_pkg.get_sf52_to_data_elements
4235: (p_position_id => p_sf52_data.to_position_id
4236: ,p_effective_date => p_sf52_data.effective_date
4237: ,p_prd => p_sf52_data.pay_rate_determinant
4238: ,p_grade_id => l_grade_id

Line 4304: ghr_pa_requests_pkg.temp_step_true(p_sf52_data.pa_request_id) THEN

4300:
4301: ----Temp Promo Changes by AVR 03-JUN-2000--Start---
4302:
4303: if nvl(p_sf52_data.pay_rate_determinant,hr_api.g_varchar2) in ('A','B','E','F') AND
4304: ghr_pa_requests_pkg.temp_step_true(p_sf52_data.pa_request_id) THEN
4305: ghr_history_fetch.fetch_positionei(
4306: p_position_id => p_sf52_data.to_position_id,
4307: p_information_type => 'GHR_US_POS_VALID_GRADE',
4308: p_date_effective => p_sf52_data.effective_date,

Line 4315: p_sf52_data.to_pay_basis := ghr_pa_requests_pkg.get_upd34_pay_basis

4311: p_sf52_data.to_pay_basis := l_pos_ei_grade_data.poei_information6;
4312: else
4313: ----Temp Promo Changes by AVR 03-JUN-2000--End---
4314:
4315: p_sf52_data.to_pay_basis := ghr_pa_requests_pkg.get_upd34_pay_basis
4316: (p_person_id => p_person_id,
4317: p_position_id => p_sf52_data.to_position_id,
4318: p_prd => p_sf52_data.pay_rate_determinant,
4319: p_pa_request_id => p_sf52_data.pa_request_id,

Line 4329: ghr_pa_requests_pkg2.get_agency_code_to(

4325: || p_sf52_data.to_pay_basis ,1);
4326:
4327: if (l_first_noa_code = '352') then
4328: p_sf52_data.to_position_org_line1 :=
4329: ghr_pa_requests_pkg2.get_agency_code_to(
4330: p_pa_request_id => p_sf52_data.pa_request_id,
4331: p_noa_id => l_first_noa_id);
4332: -- Added by ENUNEZ (23-FEB-2000 bug# 756335)
4333: elsif (l_first_noa_code = '002' and l_second_noa_code = '352') then

Line 4335: ghr_pa_requests_pkg2.get_agency_code_to(

4331: p_noa_id => l_first_noa_id);
4332: -- Added by ENUNEZ (23-FEB-2000 bug# 756335)
4333: elsif (l_first_noa_code = '002' and l_second_noa_code = '352') then
4334: p_sf52_data.to_position_org_line1 :=
4335: ghr_pa_requests_pkg2.get_agency_code_to(
4336: p_pa_request_id => p_sf52_data.pa_request_id,
4337: p_noa_id => l_second_noa_id);
4338: else
4339: p_sf52_data.to_position_org_line1 := l_position_org_line1;

Line 4408: -- ghr_pa_requests_pkg.get_rei_org_lines

4404:
4405: end if;
4406: end if;
4407: -- If the refresh is for realignment then refresh position org. lines using the procedure
4408: -- ghr_pa_requests_pkg.get_rei_org_lines
4409: if p_sf52_data.first_noa_code = '790' or
4410: p_sf52_data.second_noa_code = '790' then
4411: hr_utility.set_location('Realignment NOA: ' || l_proc, 410);
4412: ghr_pa_requests_pkg.get_rei_org_lines(

Line 4412: ghr_pa_requests_pkg.get_rei_org_lines(

4408: -- ghr_pa_requests_pkg.get_rei_org_lines
4409: if p_sf52_data.first_noa_code = '790' or
4410: p_sf52_data.second_noa_code = '790' then
4411: hr_utility.set_location('Realignment NOA: ' || l_proc, 410);
4412: ghr_pa_requests_pkg.get_rei_org_lines(
4413: P_PA_REQUEST_ID => p_sf52_data.pa_request_id,
4414: P_ORGANIZATION_ID => l_organization_id,
4415: P_POSITION_ORG_LINE1 => l_position_org_line1,
4416: P_POSITION_ORG_LINE2 => l_position_org_line2,

Line 4435: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

4431: hr_utility.set_location('Realignment NOA NOT Refreshed: ' || l_proc, 430);
4432: end if;
4433: end if;
4434:
4435: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
4436: (p_location_id => p_sf52_data.duty_station_location_id
4437: ,p_duty_station_id => l_duty_station_id);
4438:
4439: p_sf52_data.duty_station_id := l_duty_station_id;

Line 4441: ghr_pa_requests_pkg.get_duty_station_details

4437: ,p_duty_station_id => l_duty_station_id);
4438:
4439: p_sf52_data.duty_station_id := l_duty_station_id;
4440:
4441: ghr_pa_requests_pkg.get_duty_station_details
4442: (p_duty_station_id => l_duty_station_id
4443: ,p_effective_date => p_sf52_data.effective_date
4444: ,p_duty_station_code => l_duty_station_code
4445: ,p_duty_station_desc => l_duty_station_desc);

Line 4451: ghr_pa_requests_pkg.get_SF52_pos_ddf_details

4447: -- p_sf52_data.duty_station_id := l_duty_station_id;
4448: p_sf52_data.duty_station_code := l_duty_station_code;
4449: p_sf52_data.duty_station_desc := l_duty_station_desc;
4450:
4451: ghr_pa_requests_pkg.get_SF52_pos_ddf_details
4452: (p_position_id => l_position_id
4453: ,p_date_effective => p_effective_date
4454: ,p_flsa_category => l_flsa_category
4455: ,p_bargaining_unit_status => l_bargaining_unit_status

Line 4480: p_sf52_data.work_schedule_desc := ghr_pa_requests_pkg.get_lookup_meaning(800

4476: p_sf52_data.appropriation_code2 := l_appropriation_code2;
4477: p_sf52_data.personnel_office_id := l_personnel_office_id;
4478: p_sf52_data.part_time_hours := l_part_time_hours;
4479:
4480: p_sf52_data.work_schedule_desc := ghr_pa_requests_pkg.get_lookup_meaning(800
4481: ,'GHR_US_WORK_SCHEDULE'
4482: ,l_work_schedule);
4483: end if;
4484: hr_utility.set_location('l_work_schedule_desc is ' || p_sf52_data.work_schedule_desc, 13);

Line 4519: ghr_pa_requests_pkg.get_SF52_person_ddf_details

4515: p_sf52_data.employee_first_name := l_employee_first_name;
4516: p_sf52_data.employee_last_name := l_employee_last_name;
4517: p_sf52_data.employee_middle_names := l_employee_middle_names;
4518: */
4519: ghr_pa_requests_pkg.get_SF52_person_ddf_details
4520: (p_person_id => p_person_id
4521: ,p_date_effective => p_effective_date
4522: ,p_citizenship => l_citizenship
4523: ,p_veterans_preference => l_veterans_preference

Line 4545: ghr_pa_requests_pkg.get_address_details

4541: p_sf52_data.education_level := l_education_level;
4542: p_sf52_data.academic_discipline := l_academic_discipline;
4543: p_sf52_data.year_degree_attained := l_year_degree_attained;
4544:
4545: ghr_pa_requests_pkg.get_address_details
4546: (p_person_id => p_person_id
4547: ,p_effective_date => p_effective_date
4548: ,p_address_line1 => l_forwarding_address_line1
4549: ,p_address_line2 => l_forwarding_address_line2

Line 4567: ghr_pa_requests_pkg.get_SF52_asg_ddf_details

4563: p_sf52_data.forwarding_country := l_forwarding_country;
4564: p_sf52_data.forwarding_country_short_name := l_forwarding_country_short_na;
4565:
4566: -- JH altered to return WS/PTH directly to p_sf52_data.
4567: ghr_pa_requests_pkg.get_SF52_asg_ddf_details
4568: (p_assignment_id => l_assignment_id
4569: ,p_date_effective => p_effective_date
4570: ,p_tenure => l_tenure
4571: ,p_annuitant_indicator => l_annuitant_indicator

Line 4623: p_sf52_data.fegli_desc := ghr_pa_requests_pkg.get_lookup_meaning(800

4619: end if;
4620: */
4621:
4622: p_sf52_data.fegli := l_fegli ;
4623: p_sf52_data.fegli_desc := ghr_pa_requests_pkg.get_lookup_meaning(800
4624: ,'GHR_US_FEGLI'
4625: ,l_fegli);
4626:
4627: ghr_api.retrieve_element_entry_value

Line 4642: p_sf52_data.retirement_plan_desc := ghr_pa_requests_pkg.get_lookup_meaning(800

4638: end if;
4639: */
4640:
4641: p_sf52_data.retirement_plan := l_retirement_plan ;
4642: p_sf52_data.retirement_plan_desc := ghr_pa_requests_pkg.get_lookup_meaning(800
4643: ,'GHR_US_RETIREMENT_PLAN'
4644: ,l_retirement_plan);
4645:
4646: end if;

Line 4665: ghr_pa_requests_pkg.temp_step_true(p_sf52_data.pa_request_id) THEN

4661: l_pm = 'AP' THEN
4662: ----Temp Promo Changes by AVR 03-JUN-2000--Start---
4663:
4664: if p_sf52_data.pay_rate_determinant in ('A','B','E','F') AND
4665: ghr_pa_requests_pkg.temp_step_true(p_sf52_data.pa_request_id) THEN
4666: ghr_history_fetch.fetch_positionei(
4667: p_position_id => p_sf52_data.to_position_id,
4668: p_information_type => 'GHR_US_POS_VALID_GRADE',
4669: p_date_effective => p_sf52_data.effective_date,

Line 4677: ghr_pa_requests_pkg.get_upd34_pay_basis

4673: else
4674: ----Temp Promo Changes by AVR 03-JUN-2000--End---
4675:
4676: p_sf52_data.to_pay_basis :=
4677: ghr_pa_requests_pkg.get_upd34_pay_basis
4678: (p_person_id => p_person_id
4679: ,p_position_id => p_sf52_data.to_position_id
4680: ,p_prd => p_sf52_data.pay_rate_determinant
4681: ,p_pa_request_id => p_sf52_data.pa_request_id

Line 4684: IF NOT ghr_pa_requests_pkg.temp_step_true(p_sf52_data.pa_request_id) THEN

4680: ,p_prd => p_sf52_data.pay_rate_determinant
4681: ,p_pa_request_id => p_sf52_data.pa_request_id
4682: ,p_effective_date => nvl(p_sf52_data.effective_date,trunc(sysdate)));
4683: end if;
4684: IF NOT ghr_pa_requests_pkg.temp_step_true(p_sf52_data.pa_request_id) THEN
4685: IF p_sf52_data.from_pay_basis <> p_sf52_data.to_pay_basis THEN
4686: p_sf52_data.to_basic_pay := ghr_pay_calc.convert_amount(p_sf52_data.from_basic_pay
4687: ,p_sf52_data.from_pay_basis
4688: ,p_sf52_data.to_pay_basis);