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 3730: l_capped_other_pay := ghr_pa_requests_pkg2.get_cop(l_assignment_id,

3726: ,p_work_schedule => l_dummy_varchar
3727:
3728: );
3729:
3730: l_capped_other_pay := ghr_pa_requests_pkg2.get_cop(l_assignment_id,
3731: nvl(p_effective_date, trunc(sysdate)));
3732:
3733: if (p_derive_to_cols) then
3734: p_sf52_data.to_organization_id := l_organization_id;

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

3781: -- p_sf52_data.from_staffing_diff_percentage := l_staffing_diff_percentage;
3782: -- p_sf52_data.from_organization_id := l_organization_id;
3783: END IF;
3784: if (l_noa_family_code = 'APP') then
3785: p_sf52_data.from_position_org_line1 := ghr_pa_requests_pkg2.get_agency_code_from(
3786: p_pa_request_id => p_sf52_data.pa_request_id,
3787: p_noa_id => l_first_noa_id);
3788: else
3789: p_sf52_data.from_position_org_line1 := l_position_org_line1;

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

3798: l_agency_code := ghr_api.get_position_agency_code(
3799: p_person_id => p_person_id,
3800: p_assignment_id => l_assignment_id,
3801: p_effective_date => p_effective_date);
3802: p_sf52_data.from_agency_desc := ghr_pa_requests_pkg.get_lookup_meaning(800
3803: ,'GHR_US_AGENCY_CODE'
3804: ,l_agency_code);
3805: p_sf52_data.agency_code := l_agency_code;
3806: -- ????? is this the right from agency code?

Line 3815: ghr_pa_requests_pkg2.get_agency_code_to(

3811: return;
3812: end if;
3813: if (l_first_noa_code = '352') then
3814: p_sf52_data.to_position_org_line1 :=
3815: ghr_pa_requests_pkg2.get_agency_code_to(
3816: p_pa_request_id => p_sf52_data.pa_request_id,
3817: p_noa_id => l_first_noa_id);
3818: -- Added by ENUNEZ (23-FEB-2000 bug# 756335)
3819: elsif (l_first_noa_code = '002' and l_second_noa_code = '352') then

Line 3821: ghr_pa_requests_pkg2.get_agency_code_to(

3817: p_noa_id => l_first_noa_id);
3818: -- Added by ENUNEZ (23-FEB-2000 bug# 756335)
3819: elsif (l_first_noa_code = '002' and l_second_noa_code = '352') then
3820: p_sf52_data.to_position_org_line1 :=
3821: ghr_pa_requests_pkg2.get_agency_code_to(
3822: p_pa_request_id => p_sf52_data.pa_request_id,
3823: p_noa_id => l_second_noa_id);
3824: end if;
3825:

Line 3895: ghr_pa_requests_pkg2.get_agency_code_to(

3891: p_sf52_data.to_pay_basis := l_pay_basis;
3892: p_sf52_data.to_pay_plan := l_pay_plan;
3893: if (l_first_noa_code = '352') then
3894: p_sf52_data.to_position_org_line1 :=
3895: ghr_pa_requests_pkg2.get_agency_code_to(
3896: p_pa_request_id => p_sf52_data.pa_request_id,
3897: p_noa_id => l_first_noa_id);
3898: -- Added by ENUNEZ (23-FEB-2000 bug# 756335)
3899: elsif (l_first_noa_code = '002' and l_second_noa_code = '352') then

Line 3901: ghr_pa_requests_pkg2.get_agency_code_to(

3897: p_noa_id => l_first_noa_id);
3898: -- Added by ENUNEZ (23-FEB-2000 bug# 756335)
3899: elsif (l_first_noa_code = '002' and l_second_noa_code = '352') then
3900: p_sf52_data.to_position_org_line1 :=
3901: ghr_pa_requests_pkg2.get_agency_code_to(
3902: p_pa_request_id => p_sf52_data.pa_request_id,
3903: p_noa_id => l_second_noa_id);
3904: else
3905: p_sf52_data.to_position_org_line1 := l_position_org_line1;

Line 3999: ghr_pa_requests_pkg.get_sf52_to_data_elements

3995: END IF;
3996: END IF;
3997: hr_utility.set_location('bef call to to_data PRD ' || p_sf52_data.pay_rate_determinant ,15);
3998: hr_utility.set_location('bef call to to_data pay BAsis ' || p_sf52_data.to_pay_basis ,15);
3999: ghr_pa_requests_pkg.get_sf52_to_data_elements
4000: (p_position_id => p_sf52_data.to_position_id
4001: ,p_effective_date => p_sf52_data.effective_date
4002: ,p_prd => p_sf52_data.pay_rate_determinant
4003: ,p_grade_id => l_grade_id

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

4050:
4051: ----Temp Promo Changes by AVR 03-JUN-2000--Start---
4052:
4053: if nvl(p_sf52_data.pay_rate_determinant,hr_api.g_varchar2) in ('A','B','E','F') AND
4054: ghr_pa_requests_pkg.temp_step_true(p_sf52_data.pa_request_id) THEN
4055: ghr_history_fetch.fetch_positionei(
4056: p_position_id => p_sf52_data.to_position_id,
4057: p_information_type => 'GHR_US_POS_VALID_GRADE',
4058: p_date_effective => p_sf52_data.effective_date,

Line 4065: p_sf52_data.to_pay_basis := ghr_pa_requests_pkg.get_upd34_pay_basis

4061: p_sf52_data.to_pay_basis := l_pos_ei_grade_data.poei_information6;
4062: else
4063: ----Temp Promo Changes by AVR 03-JUN-2000--End---
4064:
4065: p_sf52_data.to_pay_basis := ghr_pa_requests_pkg.get_upd34_pay_basis
4066: (p_person_id => p_person_id,
4067: p_position_id => p_sf52_data.to_position_id,
4068: p_prd => p_sf52_data.pay_rate_determinant,
4069: p_pa_request_id => p_sf52_data.pa_request_id,

Line 4079: ghr_pa_requests_pkg2.get_agency_code_to(

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

Line 4085: ghr_pa_requests_pkg2.get_agency_code_to(

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

Line 4159: -- ghr_pa_requests_pkg.get_rei_org_lines

4155: end if;
4156: end if;
4157:
4158: -- If the refresh is for realignment then refresh position org. lines using the procedure
4159: -- ghr_pa_requests_pkg.get_rei_org_lines
4160: if p_sf52_data.first_noa_code = '790' or
4161: p_sf52_data.second_noa_code = '790' then
4162: hr_utility.set_location('Realignment NOA: ' || l_proc, 410);
4163: ghr_pa_requests_pkg.get_rei_org_lines(

Line 4163: ghr_pa_requests_pkg.get_rei_org_lines(

4159: -- ghr_pa_requests_pkg.get_rei_org_lines
4160: if p_sf52_data.first_noa_code = '790' or
4161: p_sf52_data.second_noa_code = '790' then
4162: hr_utility.set_location('Realignment NOA: ' || l_proc, 410);
4163: ghr_pa_requests_pkg.get_rei_org_lines(
4164: P_PA_REQUEST_ID => p_sf52_data.pa_request_id,
4165: P_ORGANIZATION_ID => l_organization_id,
4166: P_POSITION_ORG_LINE1 => l_position_org_line1,
4167: P_POSITION_ORG_LINE2 => l_position_org_line2,

Line 4186: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

4182: hr_utility.set_location('Realignment NOA NOT Refreshed: ' || l_proc, 430);
4183: end if;
4184: end if;
4185:
4186: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
4187: (p_location_id => p_sf52_data.duty_station_location_id
4188: ,p_duty_station_id => l_duty_station_id);
4189:
4190: p_sf52_data.duty_station_id := l_duty_station_id;

Line 4192: ghr_pa_requests_pkg.get_duty_station_details

4188: ,p_duty_station_id => l_duty_station_id);
4189:
4190: p_sf52_data.duty_station_id := l_duty_station_id;
4191:
4192: ghr_pa_requests_pkg.get_duty_station_details
4193: (p_duty_station_id => l_duty_station_id
4194: ,p_effective_date => p_sf52_data.effective_date
4195: ,p_duty_station_code => l_duty_station_code
4196: ,p_duty_station_desc => l_duty_station_desc);

Line 4202: ghr_pa_requests_pkg.get_SF52_pos_ddf_details

4198: -- p_sf52_data.duty_station_id := l_duty_station_id;
4199: p_sf52_data.duty_station_code := l_duty_station_code;
4200: p_sf52_data.duty_station_desc := l_duty_station_desc;
4201:
4202: ghr_pa_requests_pkg.get_SF52_pos_ddf_details
4203: (p_position_id => l_position_id
4204: ,p_date_effective => p_effective_date
4205: ,p_flsa_category => l_flsa_category
4206: ,p_bargaining_unit_status => l_bargaining_unit_status

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

4227: p_sf52_data.appropriation_code2 := l_appropriation_code2;
4228: p_sf52_data.personnel_office_id := l_personnel_office_id;
4229: p_sf52_data.part_time_hours := l_part_time_hours;
4230:
4231: p_sf52_data.work_schedule_desc := ghr_pa_requests_pkg.get_lookup_meaning(800
4232: ,'GHR_US_WORK_SCHEDULE'
4233: ,l_work_schedule);
4234: end if;
4235: hr_utility.set_location('l_work_schedule_desc is ' || p_sf52_data.work_schedule_desc, 13);

Line 4271: ghr_pa_requests_pkg.get_SF52_person_ddf_details

4267: p_sf52_data.employee_first_name := l_employee_first_name;
4268: p_sf52_data.employee_last_name := l_employee_last_name;
4269: p_sf52_data.employee_middle_names := l_employee_middle_names;
4270: */
4271: ghr_pa_requests_pkg.get_SF52_person_ddf_details
4272: (p_person_id => p_person_id
4273: ,p_date_effective => p_effective_date
4274: ,p_citizenship => l_citizenship
4275: ,p_veterans_preference => l_veterans_preference

Line 4297: ghr_pa_requests_pkg.get_address_details

4293: p_sf52_data.education_level := l_education_level;
4294: p_sf52_data.academic_discipline := l_academic_discipline;
4295: p_sf52_data.year_degree_attained := l_year_degree_attained;
4296:
4297: ghr_pa_requests_pkg.get_address_details
4298: (p_person_id => p_person_id
4299: ,p_effective_date => p_effective_date
4300: ,p_address_line1 => l_forwarding_address_line1
4301: ,p_address_line2 => l_forwarding_address_line2

Line 4319: ghr_pa_requests_pkg.get_SF52_asg_ddf_details

4315: p_sf52_data.forwarding_country := l_forwarding_country;
4316: p_sf52_data.forwarding_country_short_name := l_forwarding_country_short_na;
4317:
4318: -- JH altered to return WS/PTH directly to p_sf52_data.
4319: ghr_pa_requests_pkg.get_SF52_asg_ddf_details
4320: (p_assignment_id => l_assignment_id
4321: ,p_date_effective => p_effective_date
4322: ,p_tenure => l_tenure
4323: ,p_annuitant_indicator => l_annuitant_indicator

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

4371: end if;
4372: */
4373:
4374: p_sf52_data.fegli := l_fegli ;
4375: p_sf52_data.fegli_desc := ghr_pa_requests_pkg.get_lookup_meaning(800
4376: ,'GHR_US_FEGLI'
4377: ,l_fegli);
4378:
4379: ghr_api.retrieve_element_entry_value

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

4390: end if;
4391: */
4392:
4393: p_sf52_data.retirement_plan := l_retirement_plan ;
4394: p_sf52_data.retirement_plan_desc := ghr_pa_requests_pkg.get_lookup_meaning(800
4395: ,'GHR_US_RETIREMENT_PLAN'
4396: ,l_retirement_plan);
4397:
4398: end if;

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

4413: l_pm = 'AP' THEN
4414: ----Temp Promo Changes by AVR 03-JUN-2000--Start---
4415:
4416: if p_sf52_data.pay_rate_determinant in ('A','B','E','F') AND
4417: ghr_pa_requests_pkg.temp_step_true(p_sf52_data.pa_request_id) THEN
4418: ghr_history_fetch.fetch_positionei(
4419: p_position_id => p_sf52_data.to_position_id,
4420: p_information_type => 'GHR_US_POS_VALID_GRADE',
4421: p_date_effective => p_sf52_data.effective_date,

Line 4429: ghr_pa_requests_pkg.get_upd34_pay_basis

4425: else
4426: ----Temp Promo Changes by AVR 03-JUN-2000--End---
4427:
4428: p_sf52_data.to_pay_basis :=
4429: ghr_pa_requests_pkg.get_upd34_pay_basis
4430: (p_person_id => p_person_id
4431: ,p_position_id => p_sf52_data.to_position_id
4432: ,p_prd => p_sf52_data.pay_rate_determinant
4433: ,p_pa_request_id => p_sf52_data.pa_request_id

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

4432: ,p_prd => p_sf52_data.pay_rate_determinant
4433: ,p_pa_request_id => p_sf52_data.pa_request_id
4434: ,p_effective_date => nvl(p_sf52_data.effective_date,trunc(sysdate)));
4435: end if;
4436: IF NOT ghr_pa_requests_pkg.temp_step_true(p_sf52_data.pa_request_id) THEN
4437: IF p_sf52_data.from_pay_basis <> p_sf52_data.to_pay_basis THEN
4438: p_sf52_data.to_basic_pay := ghr_pay_calc.convert_amount(p_sf52_data.from_basic_pay
4439: ,p_sf52_data.from_pay_basis
4440: ,p_sf52_data.to_pay_basis);