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 95: ghr_api.g_api_dml := TRUE;

91: hr_utility.set_location(' Payment Option ' || p_sf52_data.pa_incentive_payment_option, 15);
92:
93: -- set global to disable checks that disallow changes to core data.
94: -- This is also set back to false when exiting this procedure.
95: ghr_api.g_api_dml := TRUE;
96: -- Start Bug 3256085
97: g_prd := NULL;
98: g_step_or_rate := NULL;
99: -- End Bug 3256085

Line 131: ghr_api.g_api_dml := FALSE;

127: p_process_type => p_process_type,
128: p_capped_other_pay => p_capped_other_pay);
129: else
130: hr_utility.set_message(8301,'GHR_38222_UNKNOWN_NOA');
131: ghr_api.g_api_dml := FALSE;
132: hr_utility.raise_error;
133: -- raise error.
134: end if;
135: -- if validate only mode, then rollback.

Line 154: ghr_api.g_api_dml := FALSE;

150: );
151: End if;
152:
153: ghr_history_api.reinit_g_session_var;
154: ghr_api.g_api_dml := FALSE;
155: hr_utility.set_location(' Leaving : ' || l_proc, 200);
156:
157: EXCEPTION
158: WHEN others THEN

Line 350: l_capped_other_pay number := hr_api.g_number;

346: l_session_var ghr_history_api.g_session_var_type;
347: l_result varchar2(30);
348: l_proc varchar2(30):='dual_action_sf52';
349: l_new_assignment_id per_all_assignments_f.assignment_id%type;
350: l_capped_other_pay number := hr_api.g_number;
351:
352: Begin
353:
354: l_sf52_data := p_sf52_data ; --NOCOPY Changes

Line 2977: ghr_api.call_workflow(

2973: ' has errors.' || l_new_line ||
2974: 'Error : ' || p_error || l_new_line ||
2975: 'Errored while routing it to the approver''s Inbox ';
2976:
2977: ghr_api.call_workflow(
2978: p_pa_request_id => p_sf52.pa_request_id,
2979: p_action_taken => 'CONTINUE',
2980: p_error => p_error);
2981: hr_utility.set_location( 'Leaving : ' || l_proc, 20);

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

3255: exit when get_req%notfound;
3256: Begin
3257: savepoint future_Action;
3258:
3259: ghr_api.call_workflow( p_pa_request_id => l_rec.pa_request_id,
3260: p_action_taken => 'CONTINUE',
3261: p_error => l_error);
3262: Exception
3263: when others then

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

3305: exit when get_req%notfound;
3306: Begin
3307: savepoint route_pending_Actions;
3308:
3309: ghr_api.call_workflow( p_pa_request_id => l_rec.pa_request_id,
3310: p_action_taken => 'CONTINUE',
3311: p_error => l_error);
3312: Exception
3313: when others then

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

3486: l_first_noa_id ghr_pa_requests.first_noa_id%type;
3487: l_first_noa_code ghr_pa_requests.first_noa_code%type;
3488: l_second_noa_id ghr_pa_requests.second_noa_id%type;
3489: l_second_noa_code ghr_pa_requests.second_noa_code%type;
3490: l_per_type per_person_types.system_person_type%type := hr_api.g_varchar2;
3491: l_prd varchar2(30);
3492: l_person_id ghr_pa_requests.person_id%type;
3493: l_temp_to_position_id ghr_pa_requests.to_position_id%type;
3494: l_pm varchar2(50);

Line 3681: GHR_API.sf52_from_data_elements(

3677: l_from_position_title := p_sf52_data.from_position_title;
3678:
3679: l_assignment_id := p_sf52_data.employee_assignment_id;
3680: If l_noa_family_code <> 'APP' THEN
3681: GHR_API.sf52_from_data_elements(
3682: p_person_id => p_person_id
3683: ,p_assignment_id => l_assignment_id
3684: ,p_effective_date => nvl(p_effective_date, trunc(sysdate))
3685: ,p_altered_pa_request_id => l_session_var.altered_pa_request_id

Line 3798: l_agency_code := ghr_api.get_position_agency_code(

3794: p_sf52_data.from_position_org_line5 := l_position_org_line5;
3795: p_sf52_data.from_position_org_line6 := l_position_org_line6;
3796:
3797:
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

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

3833: -- Initialization of all the varibles related to Other Pay in the case of Conversion of Ex Employee
3834: FOR per_type in get_person_type LOOP
3835: l_per_type := per_type.system_person_type;
3836: END LOOP;
3837: IF l_noa_family_code = 'CONV_APP' and nvl(l_per_type,hr_api.g_varchar2) = 'EX_EMP' then
3838: p_sf52_data.to_retention_allowance := NULL;
3839: p_sf52_data.to_retention_allow_percentage := NULL;
3840: p_sf52_data.to_staffing_differential := NULL;
3841: p_sf52_data.to_staffing_diff_percentage := NULL;

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

3989: ELSE
3990: hr_utility.set_location('FWFA prd :'||l_prd,80);
3991: hr_utility.set_location('FWFA refresh prd :'||p_sf52_data.pay_rate_determinant,90);
3992: IF l_prd IS NOT NULL AND
3993: l_prd <> nvl(p_sf52_data.pay_rate_determinant,hr_api.g_varchar2) then
3994: p_sf52_data.pay_rate_determinant := l_prd;
3995: END IF;
3996: END IF;
3997: hr_utility.set_location('bef call to to_data PRD ' || p_sf52_data.pay_rate_determinant ,15);

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

4045: p_sf52_data.to_step_or_rate := l_step_or_rate;
4046: END IF;
4047:
4048: hr_utility.set_location('aft call to to_data pay BAsis ' || p_sf52_data.to_pay_basis ,16);
4049: if nvl(p_sf52_data.pay_rate_determinant,hr_api.g_varchar2) in ('A','B','E','F','U','V') 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

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

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

Line 4119: p_sf52_data.to_position_number := ghr_api.get_position_desc_no_pos

4115: else
4116: close get_pos_bg;
4117: end if;
4118:
4119: p_sf52_data.to_position_number := ghr_api.get_position_desc_no_pos
4120: (p_position_id => p_sf52_data.to_position_id
4121: ,p_business_group_id => l_business_group_id
4122: ,p_effective_date => p_effective_date);
4123:

Line 4124: p_sf52_data.to_position_seq_no := ghr_api.get_position_sequence_no_pos

4120: (p_position_id => p_sf52_data.to_position_id
4121: ,p_business_group_id => l_business_group_id
4122: ,p_effective_date => p_effective_date);
4123:
4124: p_sf52_data.to_position_seq_no := ghr_api.get_position_sequence_no_pos
4125: (p_position_id => p_sf52_data.to_position_id
4126: ,p_business_group_id => l_business_group_id
4127: ,p_effective_date => p_effective_date);
4128:

Line 4129: p_sf52_data.to_position_title := ghr_api.get_position_title_pos

4125: (p_position_id => p_sf52_data.to_position_id
4126: ,p_business_group_id => l_business_group_id
4127: ,p_effective_date => p_effective_date);
4128:
4129: p_sf52_data.to_position_title := ghr_api.get_position_title_pos
4130: (p_position_id => p_sf52_data.to_position_id
4131: ,p_business_group_id => l_business_group_id
4132: ,p_effective_date => p_effective_date);
4133:

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

4144: hr_utility.set_location('To Posn PM ' || l_pm ,20);
4145: IF l_pm = 'UE' THEN
4146: p_sf52_data.duty_station_location_id := l_location_id;
4147: p_sf52_data.duty_station_id := l_duty_station_id;
4148: ELSIF l_pm = 'APUE' and nvl(p_sf52_data.to_position_id,hr_api.g_number)
4149: <> nvl(p_sf52_data.from_position_id,hr_api.g_number) THEN
4150: p_sf52_data.duty_station_location_id := l_location_id;
4151: p_sf52_data.duty_station_id := l_duty_station_id;
4152: END IF;

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

4145: IF l_pm = 'UE' THEN
4146: p_sf52_data.duty_station_location_id := l_location_id;
4147: p_sf52_data.duty_station_id := l_duty_station_id;
4148: ELSIF l_pm = 'APUE' and nvl(p_sf52_data.to_position_id,hr_api.g_number)
4149: <> nvl(p_sf52_data.from_position_id,hr_api.g_number) THEN
4150: p_sf52_data.duty_station_location_id := l_location_id;
4151: p_sf52_data.duty_station_id := l_duty_station_id;
4152: END IF;
4153: END IF;

Line 4287: ghr_api.return_education_details(

4283: p_sf52_data.veterans_status := l_veterans_status;
4284: p_sf52_data.service_comp_date := fnd_date.canonical_to_date(l_service_comp_date);
4285: --, 'YYYY/MM/DD HH24:MI:SS');
4286:
4287: ghr_api.return_education_details(
4288: p_person_id => p_person_id
4289: ,p_effective_date => p_effective_date
4290: ,p_education_level => l_education_level
4291: ,p_academic_discipline => l_academic_discipline

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

4347: */
4348: IF l_pm = 'UE' THEN
4349: p_sf52_data.work_schedule := l_work_schedule;
4350: p_sf52_data.part_time_hours := l_part_time_hours;
4351: ELSIF l_pm = 'APUE' AND nvl(p_sf52_data.to_position_id,hr_api.g_number)
4352: <> nvl(p_sf52_data.from_position_id,hr_api.g_number) THEN
4353: p_sf52_data.work_schedule := l_work_schedule;
4354: p_sf52_data.part_time_hours := l_part_time_hours;
4355: END IF;

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

4348: IF l_pm = 'UE' THEN
4349: p_sf52_data.work_schedule := l_work_schedule;
4350: p_sf52_data.part_time_hours := l_part_time_hours;
4351: ELSIF l_pm = 'APUE' AND nvl(p_sf52_data.to_position_id,hr_api.g_number)
4352: <> nvl(p_sf52_data.from_position_id,hr_api.g_number) THEN
4353: p_sf52_data.work_schedule := l_work_schedule;
4354: p_sf52_data.part_time_hours := l_part_time_hours;
4355: END IF;
4356: END IF;

Line 4359: ghr_api.retrieve_element_entry_value

4355: END IF;
4356: END IF;
4357: -- JH
4358:
4359: ghr_api.retrieve_element_entry_value
4360: (p_element_name => 'FEGLI'
4361: ,p_input_value_name => 'FEGLI'
4362: ,p_assignment_id => l_assignment_id
4363: ,p_effective_date => p_effective_date

Line 4379: ghr_api.retrieve_element_entry_value

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
4380: (p_element_name => 'Retirement Plan'
4381: ,p_input_value_name => 'Plan'
4382: ,p_assignment_id => l_assignment_id
4383: ,p_effective_date => p_effective_date

Line 5177: l_capped_other_pay number := hr_api.g_number;

5173: l_ret_calc_perc number;
5174: l_supervisory_differential number;
5175: l_staffing_differential number;
5176: l_multi_error_flag boolean;
5177: l_capped_other_pay number := hr_api.g_number;
5178: l_sf52_data ghr_pa_requests%rowtype;
5179:
5180: cursor c_sf52_shadow (c_pa_request_id in number) is
5181: select *

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

5295: END IF;
5296: -- Bug 3704438 - PTH Issue - End
5297: --Calculating Other Pay Components
5298: --Get the retention allowance on that date
5299: ghr_api.retrieve_element_entry_value (p_element_name => 'Retention Allowance'
5300: ,p_input_value_name => 'Amount'
5301: ,p_assignment_id => p_sf52_data.employee_assignment_id
5302: ,p_effective_date => p_sf52_data.effective_date
5303: ,p_value => l_retention_allowance

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

5302: ,p_effective_date => p_sf52_data.effective_date
5303: ,p_value => l_retention_allowance
5304: ,p_multiple_error_flag => l_multi_error_flag);
5305: hr_utility.set_location('Retention Allowance on Eff Date'||l_retention_allowance, 164);
5306: ghr_api.retrieve_element_entry_value (p_element_name => 'Supervisory Differential'
5307: ,p_input_value_name => 'Amount'
5308: ,p_assignment_id => p_sf52_data.employee_assignment_id
5309: ,p_effective_date => p_sf52_data.effective_date
5310: ,p_value => l_supervisory_differential

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

5309: ,p_effective_date => p_sf52_data.effective_date
5310: ,p_value => l_supervisory_differential
5311: ,p_multiple_error_flag => l_multi_error_flag);
5312: hr_utility.set_location('Supervisory Differential on Eff Date'||l_supervisory_differential, 165);
5313: ghr_api.retrieve_element_entry_value (p_element_name => 'Staffing Differential'
5314: ,p_input_value_name => 'Amount'
5315: ,p_assignment_id => p_sf52_data.employee_assignment_id
5316: ,p_effective_date => p_sf52_data.effective_date
5317: ,p_value => l_staffing_differential

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

5382: if nvl(p_sf52_data.from_basic_pay,0) <> nvl(p_sf52_data.to_basic_pay,0) and
5383: p_sf52_data.first_noa_code not in ('810','818','819') then
5384: hr_utility.set_location('Change in Basic Pay and Non Other Pay Action', 163);
5385: --Get the retention allowance and supervisory differential on that date
5386: ghr_api.retrieve_element_entry_value (p_element_name => 'Retention Allowance'
5387: ,p_input_value_name => 'Amount'
5388: ,p_assignment_id => p_sf52_data.employee_assignment_id
5389: ,p_effective_date => p_sf52_data.effective_date
5390: ,p_value => l_retention_allowance

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

5389: ,p_effective_date => p_sf52_data.effective_date
5390: ,p_value => l_retention_allowance
5391: ,p_multiple_error_flag => l_multi_error_flag);
5392: hr_utility.set_location('Retention Allowance on Eff Date'||l_retention_allowance, 164);
5393: ghr_api.retrieve_element_entry_value (p_element_name => 'Supervisory Differential'
5394: ,p_input_value_name => 'Amount'
5395: ,p_assignment_id => p_sf52_data.employee_assignment_id
5396: ,p_effective_date => p_sf52_data.effective_date
5397: ,p_value => l_supervisory_differential

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

5422: */
5423: -- End Bug 1457792
5424: -- Redo Pay Calc
5425: -- Bug#3228557 Don't process redo_pay_calc for NPA Report
5426: IF NVL(p_process_type,hr_api.g_varchar2) <> 'NPA' THEN
5427: redo_Pay_calc ( p_sf52_rec => p_sf52_data,
5428: p_capped_other_pay => l_capped_other_pay);
5429: END IF;
5430:

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

5478:
5479: hr_utility.set_location( 'Entering : ' || l_proc,10);
5480:
5481: print_sf52('Before redo_pay : ' , p_sf52_rec);
5482: If nvl(p_sf52_rec.noa_family_code,hr_api.g_varchar2)
5483: in ('APP', 'CHG_DUTY_STATION', 'CONV_APP', 'POS_CHG',
5484: 'REASSIGNMENT') or
5485: (nvl(p_sf52_rec.noa_family_code,hr_api.g_varchar2) like 'GHR_SAL%')
5486: then

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

5481: print_sf52('Before redo_pay : ' , p_sf52_rec);
5482: If nvl(p_sf52_rec.noa_family_code,hr_api.g_varchar2)
5483: in ('APP', 'CHG_DUTY_STATION', 'CONV_APP', 'POS_CHG',
5484: 'REASSIGNMENT') or
5485: (nvl(p_sf52_rec.noa_family_code,hr_api.g_varchar2) like 'GHR_SAL%')
5486: then
5487: -- and (p_sf52_rec.first_noa_code <> '899') and
5488: -- not (p_sf52_rec.first_noa_code = '002' and
5489: -- p_sf52_rec.second_noa_code = '899')

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

5487: -- and (p_sf52_rec.first_noa_code <> '899') and
5488: -- not (p_sf52_rec.first_noa_code = '002' and
5489: -- p_sf52_rec.second_noa_code = '899')
5490: hr_utility.set_location('Valid Family ' || l_proc, 11);
5491: If nvl(p_sf52_rec.custom_pay_calc_flag,hr_api.g_varchar2) <> 'Y' then
5492: hr_utility.set_location('Custom Pay Calc is NOT Y ' || l_proc, 12);
5493: hr_utility.set_location('Input PRD : '||p_sf52_rec.input_pay_rate_determinant, 14);
5494: hr_utility.set_location('PRD : '||p_sf52_rec.pay_rate_determinant, 14);
5495: l_pay_calc_in_rec.pa_request_id := p_sf52_rec.pa_request_id;

Line 5549: ghr_api.retrieve_element_entry_value

5545: p_sf52_rec.effective_date >= to_date('01/05/2005','dd/mm/yyyy') THEN
5546: l_pay_calc_in_rec.retention_allowance := p_sf52_rec.to_retention_allowance;
5547: hr_utility.set_location('setting retention - fwfa ' || p_sf52_rec.to_retention_allowance,120);
5548: ELSE
5549: ghr_api.retrieve_element_entry_value
5550: (p_element_name => 'Retention Allowance'
5551: ,p_input_value_name => 'Amount'
5552: ,p_assignment_id => p_sf52_rec.employee_assignment_id
5553: ,p_effective_date => p_sf52_rec.effective_date

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

5653: -- error; -- send back to user
5654:
5655: End if;
5656: End if;
5657: Elsif nvl(p_sf52_rec.noa_family_code,hr_api.g_varchar2) = 'OTHER_PAY'
5658: then
5659: -- and (p_sf52_rec.first_noa_code <> '899') and not (p_sf52_rec.first_noa_code = '002' and
5660: -- p_sf52_rec.second_noa_code = '899')
5661: hr_utility.set_location( 'Other Pay Calculation ' || l_proc, 95);

Line 5693: IF p_capped_other_pay <> hr_api.g_number OR

5689: -- AND l_session_var.noa_id_correct is not NULL) THEN
5690: ) THEN
5691: hr_utility.set_location( 'Before calling do_pay_caps_main ' ||p_capped_other_pay , 95);
5692: hr_utility.set_location( 'p_sf52_rec.to_total_salary is ' || p_sf52_rec.to_total_salary, 95);
5693: IF p_capped_other_pay <> hr_api.g_number OR
5694: p_capped_other_pay is NULL THEN
5695: hr_utility.set_location( 'p_sf52_rec.to_total_salary is ' || p_sf52_rec.to_total_salary, 95);
5696:
5697: ghr_pay_caps.do_pay_caps_main (

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

5801: If trunc(p_sf52_data.effective_date) > trunc(sysdate) then
5802: for per_type in get_person_type loop
5803: l_per_type := per_type.system_person_type;
5804: end loop;
5805: If nvl(l_per_type,hr_api.g_varchar2) = 'EX_EMP' then
5806: p_sf52_data.employee_assignment_id := Null;
5807: End if;
5808: End if;
5809: