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 HR_API

Line 139: ghr_api.g_api_dml := TRUE;

135: hr_utility.set_location(' Payment Option ' || p_sf52_data.pa_incentive_payment_option, 15);
136:
137: -- set global to disable checks that disallow changes to core data.
138: -- This is also set back to false when exiting this procedure.
139: ghr_api.g_api_dml := TRUE;
140: -- Start Bug 3256085
141: g_prd := NULL;
142: g_step_or_rate := NULL;
143: -- End Bug 3256085

Line 205: ghr_api.g_api_dml := FALSE;

201: p_process_type => p_process_type,
202: p_capped_other_pay => p_capped_other_pay);
203: else
204: hr_utility.set_message(8301,'GHR_38222_UNKNOWN_NOA');
205: ghr_api.g_api_dml := FALSE;
206: hr_utility.raise_error;
207: -- raise error.
208: end if;
209: -- if validate only mode, then rollback.

Line 228: ghr_api.g_api_dml := FALSE;

224: );
225: End if;
226:
227: ghr_history_api.reinit_g_session_var;
228: ghr_api.g_api_dml := FALSE;
229: hr_utility.set_location(' Leaving : ' || l_proc, 200);
230:
231: EXCEPTION
232: WHEN others THEN

Line 3102: ghr_api.call_workflow(

3098: ' has errors.' || l_new_line ||
3099: 'Error : ' || p_error || l_new_line ||
3100: 'Errored while routing it to the approver''s Inbox ';
3101:
3102: ghr_api.call_workflow(
3103: p_pa_request_id => p_sf52.pa_request_id,
3104: p_action_taken => 'CONTINUE',
3105: p_error => p_error);
3106: hr_utility.set_location( 'Leaving : ' || l_proc, 20);

Line 3385: ghr_api.call_workflow( p_pa_request_id => l_rec.pa_request_id,

3381: exit when get_req%notfound;
3382: Begin
3383: savepoint future_Action;
3384:
3385: ghr_api.call_workflow( p_pa_request_id => l_rec.pa_request_id,
3386: p_action_taken => 'CONTINUE',
3387: p_error => l_error);
3388: Exception
3389: when others then

Line 3435: ghr_api.call_workflow( p_pa_request_id => l_rec.pa_request_id,

3431: exit when get_req%notfound;
3432: Begin
3433: savepoint route_pending_Actions;
3434:
3435: ghr_api.call_workflow( p_pa_request_id => l_rec.pa_request_id,
3436: p_action_taken => 'CONTINUE',
3437: p_error => l_error);
3438: Exception
3439: when others then

Line 3618: l_per_type per_person_types.system_person_type%type := hr_api.g_varchar2;

3614: l_first_noa_id ghr_pa_requests.first_noa_id%type;
3615: l_first_noa_code ghr_pa_requests.first_noa_code%type;
3616: l_second_noa_id ghr_pa_requests.second_noa_id%type;
3617: l_second_noa_code ghr_pa_requests.second_noa_code%type;
3618: l_per_type per_person_types.system_person_type%type := hr_api.g_varchar2;
3619: l_prd varchar2(30);
3620: l_prd1 varchar2(30);
3621: l_person_id ghr_pa_requests.person_id%type;
3622: l_temp_to_position_id ghr_pa_requests.to_position_id%type;

Line 3863: GHR_API.sf52_from_data_elements(

3859: l_from_position_title := p_sf52_data.from_position_title;
3860:
3861: l_assignment_id := p_sf52_data.employee_assignment_id;
3862: If l_noa_family_code <> 'APP' THEN
3863: GHR_API.sf52_from_data_elements(
3864: p_person_id => p_person_id
3865: ,p_assignment_id => l_assignment_id
3866: ,p_effective_date => nvl(p_effective_date, trunc(sysdate))
3867: ,p_altered_pa_request_id => l_session_var.altered_pa_request_id

Line 3980: l_agency_code := ghr_api.get_position_agency_code(

3976: p_sf52_data.from_position_org_line5 := l_position_org_line5;
3977: p_sf52_data.from_position_org_line6 := l_position_org_line6;
3978:
3979:
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

Line 4019: IF l_noa_family_code = 'CONV_APP' and nvl(l_per_type,hr_api.g_varchar2) = 'EX_EMP' then

4015: -- Initialization of all the varibles related to Other Pay in the case of Conversion of Ex Employee
4016: FOR per_type in get_person_type LOOP
4017: l_per_type := per_type.system_person_type;
4018: END LOOP;
4019: IF l_noa_family_code = 'CONV_APP' and nvl(l_per_type,hr_api.g_varchar2) = 'EX_EMP' then
4020: p_sf52_data.to_retention_allowance := NULL;
4021: p_sf52_data.to_retention_allow_percentage := NULL;
4022: p_sf52_data.to_staffing_differential := NULL;
4023: p_sf52_data.to_staffing_diff_percentage := NULL;

Line 4206: l_prd <> nvl(p_sf52_data.pay_rate_determinant,hr_api.g_varchar2) then

4202: hr_utility.set_location('PRD Process Method :'|| l_prd_pm,92);
4203: --End Bug# 14047036, 13587903
4204: --Bug# 13587903 added RPA prd not null condition to get the PRD from assginment
4205: IF l_prd IS NOT NULL AND l_prd_pm NOT IN ('AP') AND --Bug# 13587903
4206: l_prd <> nvl(p_sf52_data.pay_rate_determinant,hr_api.g_varchar2) then
4207: p_sf52_data.pay_rate_determinant := l_prd;
4208: END IF;
4209: hr_utility.set_location('p_sf52_data.to_position_id'||p_sf52_data.to_position_id,10);
4210: hr_utility.set_location('p_sf52_data.from_position_id'||p_sf52_data.from_position_id,11);

Line 4219: l_step_or_rate1 <> nvl(p_sf52_data.to_step_or_rate,hr_api.g_varchar2) AND

4215: hr_utility.set_location('l_step_or_rate1'||l_step_or_rate1,12);
4216:
4217: -- Added to compare step or rate with '00' for dual actions
4218: IF l_step_or_rate1 IS NOT NULL AND
4219: l_step_or_rate1 <> nvl(p_sf52_data.to_step_or_rate,hr_api.g_varchar2) AND
4220: p_sf52_data.to_step_or_rate <> '00' then
4221: p_sf52_data.to_step_or_rate := l_step_or_rate1;
4222: END IF;
4223:

Line 4299: if nvl(p_sf52_data.pay_rate_determinant,hr_api.g_varchar2) in ('A','B','E','F','U','V') then

4295: END IF;
4296: END IF;
4297:
4298: hr_utility.set_location('aft call to to_data pay BAsis ' || p_sf52_data.to_pay_basis ,16);
4299: if nvl(p_sf52_data.pay_rate_determinant,hr_api.g_varchar2) in ('A','B','E','F','U','V') 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

Line 4303: if nvl(p_sf52_data.pay_rate_determinant,hr_api.g_varchar2) in ('A','B','E','F') AND

4299: if nvl(p_sf52_data.pay_rate_determinant,hr_api.g_varchar2) in ('A','B','E','F','U','V') 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',

Line 4369: p_sf52_data.to_position_number := ghr_api.get_position_desc_no_pos

4365: else
4366: close get_pos_bg;
4367: end if;
4368:
4369: p_sf52_data.to_position_number := ghr_api.get_position_desc_no_pos
4370: (p_position_id => p_sf52_data.to_position_id
4371: ,p_business_group_id => l_business_group_id
4372: ,p_effective_date => p_effective_date);
4373:

Line 4374: p_sf52_data.to_position_seq_no := ghr_api.get_position_sequence_no_pos

4370: (p_position_id => p_sf52_data.to_position_id
4371: ,p_business_group_id => l_business_group_id
4372: ,p_effective_date => p_effective_date);
4373:
4374: p_sf52_data.to_position_seq_no := ghr_api.get_position_sequence_no_pos
4375: (p_position_id => p_sf52_data.to_position_id
4376: ,p_business_group_id => l_business_group_id
4377: ,p_effective_date => p_effective_date);
4378:

Line 4379: p_sf52_data.to_position_title := ghr_api.get_position_title_pos

4375: (p_position_id => p_sf52_data.to_position_id
4376: ,p_business_group_id => l_business_group_id
4377: ,p_effective_date => p_effective_date);
4378:
4379: p_sf52_data.to_position_title := ghr_api.get_position_title_pos
4380: (p_position_id => p_sf52_data.to_position_id
4381: ,p_business_group_id => l_business_group_id
4382: ,p_effective_date => p_effective_date);
4383:

Line 4398: ELSIF l_pm = 'APUE' and nvl(p_sf52_data.to_position_id,hr_api.g_number)

4394: hr_utility.set_location('To Posn PM ' || l_pm ,20);
4395: IF l_pm = 'UE' THEN
4396: p_sf52_data.duty_station_location_id := l_location_id;
4397: p_sf52_data.duty_station_id := l_duty_station_id;
4398: ELSIF l_pm = 'APUE' and nvl(p_sf52_data.to_position_id,hr_api.g_number)
4399: <> nvl(p_sf52_data.from_position_id,hr_api.g_number) THEN
4400: p_sf52_data.duty_station_location_id := l_location_id;
4401: p_sf52_data.duty_station_id := l_duty_station_id;
4402: END IF;

Line 4399: <> nvl(p_sf52_data.from_position_id,hr_api.g_number) THEN

4395: IF l_pm = 'UE' THEN
4396: p_sf52_data.duty_station_location_id := l_location_id;
4397: p_sf52_data.duty_station_id := l_duty_station_id;
4398: ELSIF l_pm = 'APUE' and nvl(p_sf52_data.to_position_id,hr_api.g_number)
4399: <> nvl(p_sf52_data.from_position_id,hr_api.g_number) THEN
4400: p_sf52_data.duty_station_location_id := l_location_id;
4401: p_sf52_data.duty_station_id := l_duty_station_id;
4402: END IF;
4403: END IF;

Line 4535: ghr_api.return_education_details(

4531: p_sf52_data.veterans_status := l_veterans_status;
4532: p_sf52_data.service_comp_date := fnd_date.canonical_to_date(l_service_comp_date);
4533: --, 'YYYY/MM/DD HH24:MI:SS');
4534:
4535: ghr_api.return_education_details(
4536: p_person_id => p_person_id
4537: ,p_effective_date => p_effective_date
4538: ,p_education_level => l_education_level
4539: ,p_academic_discipline => l_academic_discipline

Line 4599: ELSIF l_pm = 'APUE' AND nvl(p_sf52_data.to_position_id,hr_api.g_number)

4595: */
4596: IF l_pm = 'UE' THEN
4597: p_sf52_data.work_schedule := l_work_schedule;
4598: p_sf52_data.part_time_hours := l_part_time_hours;
4599: ELSIF l_pm = 'APUE' AND nvl(p_sf52_data.to_position_id,hr_api.g_number)
4600: <> nvl(p_sf52_data.from_position_id,hr_api.g_number) THEN
4601: p_sf52_data.work_schedule := l_work_schedule;
4602: p_sf52_data.part_time_hours := l_part_time_hours;
4603: END IF;

Line 4600: <> nvl(p_sf52_data.from_position_id,hr_api.g_number) THEN

4596: IF l_pm = 'UE' THEN
4597: p_sf52_data.work_schedule := l_work_schedule;
4598: p_sf52_data.part_time_hours := l_part_time_hours;
4599: ELSIF l_pm = 'APUE' AND nvl(p_sf52_data.to_position_id,hr_api.g_number)
4600: <> nvl(p_sf52_data.from_position_id,hr_api.g_number) THEN
4601: p_sf52_data.work_schedule := l_work_schedule;
4602: p_sf52_data.part_time_hours := l_part_time_hours;
4603: END IF;
4604: END IF;

Line 4607: ghr_api.retrieve_element_entry_value

4603: END IF;
4604: END IF;
4605: -- JH
4606:
4607: ghr_api.retrieve_element_entry_value
4608: (p_element_name => 'FEGLI'
4609: ,p_input_value_name => 'FEGLI'
4610: ,p_assignment_id => l_assignment_id
4611: ,p_effective_date => p_effective_date

Line 4627: ghr_api.retrieve_element_entry_value

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
4628: (p_element_name => 'Retirement Plan'
4629: ,p_input_value_name => 'Plan'
4630: ,p_assignment_id => l_assignment_id
4631: ,p_effective_date => p_effective_date

Line 5545: ghr_api.retrieve_element_entry_value (p_element_name => 'Retention Allowance'

5541: END IF;
5542: -- Bug 3704438 - PTH Issue - End
5543: --Calculating Other Pay Components
5544: --Get the retention allowance on that date
5545: ghr_api.retrieve_element_entry_value (p_element_name => 'Retention Allowance'
5546: ,p_input_value_name => 'Amount'
5547: ,p_assignment_id => p_sf52_data.employee_assignment_id
5548: ,p_effective_date => p_sf52_data.effective_date
5549: ,p_value => l_retention_allowance

Line 5552: ghr_api.retrieve_element_entry_value (p_element_name => 'Supervisory Differential'

5548: ,p_effective_date => p_sf52_data.effective_date
5549: ,p_value => l_retention_allowance
5550: ,p_multiple_error_flag => l_multi_error_flag);
5551: hr_utility.set_location('Retention Allowance on Eff Date'||l_retention_allowance, 164);
5552: ghr_api.retrieve_element_entry_value (p_element_name => 'Supervisory Differential'
5553: ,p_input_value_name => 'Amount'
5554: ,p_assignment_id => p_sf52_data.employee_assignment_id
5555: ,p_effective_date => p_sf52_data.effective_date
5556: ,p_value => l_supervisory_differential

Line 5559: ghr_api.retrieve_element_entry_value (p_element_name => 'Staffing Differential'

5555: ,p_effective_date => p_sf52_data.effective_date
5556: ,p_value => l_supervisory_differential
5557: ,p_multiple_error_flag => l_multi_error_flag);
5558: hr_utility.set_location('Supervisory Differential on Eff Date'||l_supervisory_differential, 165);
5559: ghr_api.retrieve_element_entry_value (p_element_name => 'Staffing Differential'
5560: ,p_input_value_name => 'Amount'
5561: ,p_assignment_id => p_sf52_data.employee_assignment_id
5562: ,p_effective_date => p_sf52_data.effective_date
5563: ,p_value => l_staffing_differential

Line 5631: ghr_api.retrieve_element_entry_value (p_element_name => 'Retention Allowance'

5627: if nvl(p_sf52_data.from_basic_pay,0) <> nvl(p_sf52_data.to_basic_pay,0) and
5628: p_sf52_data.first_noa_code not in ('810','818','819') then
5629: hr_utility.set_location('Change in Basic Pay and Non Other Pay Action', 163);
5630: --Get the retention allowance and supervisory differential on that date
5631: ghr_api.retrieve_element_entry_value (p_element_name => 'Retention Allowance'
5632: ,p_input_value_name => 'Amount'
5633: ,p_assignment_id => p_sf52_data.employee_assignment_id
5634: ,p_effective_date => p_sf52_data.effective_date
5635: ,p_value => l_retention_allowance

Line 5638: ghr_api.retrieve_element_entry_value (p_element_name => 'Supervisory Differential'

5634: ,p_effective_date => p_sf52_data.effective_date
5635: ,p_value => l_retention_allowance
5636: ,p_multiple_error_flag => l_multi_error_flag);
5637: hr_utility.set_location('Retention Allowance on Eff Date'||l_retention_allowance, 164);
5638: ghr_api.retrieve_element_entry_value (p_element_name => 'Supervisory Differential'
5639: ,p_input_value_name => 'Amount'
5640: ,p_assignment_id => p_sf52_data.employee_assignment_id
5641: ,p_effective_date => p_sf52_data.effective_date
5642: ,p_value => l_supervisory_differential

Line 5672: IF NVL(p_process_type,hr_api.g_varchar2) <> 'NPA' THEN

5668: -- End Bug 1457792
5669: -- Redo Pay Calc
5670: -- Bug#3228557 Don't process redo_pay_calc for NPA Report
5671:
5672: IF NVL(p_process_type,hr_api.g_varchar2) <> 'NPA' THEN
5673: redo_Pay_calc ( p_sf52_rec => p_sf52_data,
5674: p_capped_other_pay => l_capped_other_pay);
5675: END IF;
5676:

Line 5733: If nvl(p_sf52_rec.noa_family_code,hr_api.g_varchar2)

5729: hr_utility.set_location( 'Entering : ' || l_proc,10);
5730:
5731: print_sf52('Before redo_pay : ' , p_sf52_rec);
5732:
5733: If nvl(p_sf52_rec.noa_family_code,hr_api.g_varchar2)
5734: in ('APP', 'CHG_DUTY_STATION', 'CONV_APP', 'POS_CHG',
5735: 'REASSIGNMENT') or
5736: (nvl(p_sf52_rec.noa_family_code,hr_api.g_varchar2) like 'GHR_SAL%')
5737: then

Line 5736: (nvl(p_sf52_rec.noa_family_code,hr_api.g_varchar2) like 'GHR_SAL%')

5732:
5733: If nvl(p_sf52_rec.noa_family_code,hr_api.g_varchar2)
5734: in ('APP', 'CHG_DUTY_STATION', 'CONV_APP', 'POS_CHG',
5735: 'REASSIGNMENT') or
5736: (nvl(p_sf52_rec.noa_family_code,hr_api.g_varchar2) like 'GHR_SAL%')
5737: then
5738: -- and (p_sf52_rec.first_noa_code <> '899') and
5739: -- not (p_sf52_rec.first_noa_code = '002' and
5740: -- p_sf52_rec.second_noa_code = '899')

Line 5742: If nvl(p_sf52_rec.custom_pay_calc_flag,hr_api.g_varchar2) <> 'Y' then

5738: -- and (p_sf52_rec.first_noa_code <> '899') and
5739: -- not (p_sf52_rec.first_noa_code = '002' and
5740: -- p_sf52_rec.second_noa_code = '899')
5741: hr_utility.set_location('Valid Family ' || l_proc, 11);
5742: If nvl(p_sf52_rec.custom_pay_calc_flag,hr_api.g_varchar2) <> 'Y' then
5743: hr_utility.set_location('Custom Pay Calc is NOT Y ' || l_proc, 12);
5744: hr_utility.set_location('Input PRD : '||p_sf52_rec.input_pay_rate_determinant, 14);
5745: hr_utility.set_location('PRD : '||p_sf52_rec.pay_rate_determinant, 14);
5746: l_pay_calc_in_rec.pa_request_id := p_sf52_rec.pa_request_id;

Line 5808: ghr_api.retrieve_element_entry_value

5804: p_sf52_rec.effective_date >= to_date('01/05/2005','dd/mm/yyyy') THEN
5805: l_pay_calc_in_rec.retention_allowance := p_sf52_rec.to_retention_allowance;
5806: hr_utility.set_location('setting retention - fwfa ' || p_sf52_rec.to_retention_allowance,120);
5807: ELSE
5808: ghr_api.retrieve_element_entry_value
5809: (p_element_name => 'Retention Allowance'
5810: ,p_input_value_name => 'Amount'
5811: ,p_assignment_id => p_sf52_rec.employee_assignment_id
5812: ,p_effective_date => p_sf52_rec.effective_date

Line 5917: Elsif nvl(p_sf52_rec.noa_family_code,hr_api.g_varchar2) = 'OTHER_PAY'

5913: -- error; -- send back to user
5914:
5915: End if;
5916: End if;
5917: Elsif nvl(p_sf52_rec.noa_family_code,hr_api.g_varchar2) = 'OTHER_PAY'
5918: then
5919: -- and (p_sf52_rec.first_noa_code <> '899') and not (p_sf52_rec.first_noa_code = '002' and
5920: -- p_sf52_rec.second_noa_code = '899')
5921: hr_utility.set_location( 'Other Pay Calculation ' || l_proc, 95);

Line 5956: if nvl(p_sf52_rec.noa_family_code,hr_api.g_varchar2) <> 'OTHER_PAY' THEN

5952: hr_utility.set_location( 'p_sf52_rec.to_total_salary is ' || p_sf52_rec.to_total_salary, 95);
5953:
5954: --BUG # 14032192 passing total salary as addition of adjusted basic pay and other pay
5955: lo_total_salary := p_sf52_rec.to_total_salary;
5956: if nvl(p_sf52_rec.noa_family_code,hr_api.g_varchar2) <> 'OTHER_PAY' THEN
5957: if p_sf52_rec.to_other_pay_amount is not null then
5958: lo_entitled_other_pay := nvl(p_sf52_rec.to_au_overtime , 0) +
5959: nvl(p_sf52_rec.to_availability_pay , 0) +
5960: nvl(p_sf52_rec.to_retention_allowance , 0) +

Line 5969: IF p_capped_other_pay <> hr_api.g_number OR

5965: nvl(lo_entitled_other_pay,0);
5966: end if;
5967: end if;
5968:
5969: IF p_capped_other_pay <> hr_api.g_number OR
5970: p_capped_other_pay is NULL THEN
5971: hr_utility.set_location( 'p_sf52_rec.to_total_salary is ' || p_sf52_rec.to_total_salary, 95);
5972:
5973: ghr_pay_caps.do_pay_caps_main (

Line 6083: If nvl(l_per_type,hr_api.g_varchar2) = 'EX_EMP' then

6079: If trunc(p_sf52_data.effective_date) > trunc(sysdate) then
6080: for per_type in get_person_type loop
6081: l_per_type := per_type.system_person_type;
6082: end loop;
6083: If nvl(l_per_type,hr_api.g_varchar2) = 'EX_EMP' then
6084: p_sf52_data.employee_assignment_id := Null;
6085: End if;
6086: End if;
6087: