DBA Data[Home] [Help]

APPS.GHR_SF52_DO_UPDATE dependencies on GHR_PAY_CALC

Line 666: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;

662: and (rei.rei_information5 is null or rei.rei_information5 = 'Y')
663: and nvl(rei.rei_information30,hr_api.g_varchar2) <> 'Original RPA';
664:
665:
666: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
667: l_ret_grade_rec ghr_pay_calc.retained_grade_rec_type;
668: -- Bug#4698321 created l_cur_date_from variable.
669: l_cur_date_from per_people_extra_info.pei_information1%type;
670: l_new_date_to per_people_extra_info.pei_information1%type;

Line 667: l_ret_grade_rec ghr_pay_calc.retained_grade_rec_type;

663: and nvl(rei.rei_information30,hr_api.g_varchar2) <> 'Original RPA';
664:
665:
666: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
667: l_ret_grade_rec ghr_pay_calc.retained_grade_rec_type;
668: -- Bug#4698321 created l_cur_date_from variable.
669: l_cur_date_from per_people_extra_info.pei_information1%type;
670: l_new_date_to per_people_extra_info.pei_information1%type;
671: l_new_grade_or_level per_people_extra_info.pei_information3%type;

Line 876: IF (ghr_pay_calc.g_fwfa_pay_calc_flag) and

872: -- SKIP the following process for NOA Code 866 as it is already handled in the above code.
873: -- However, don't skip NOACs 702,740 as they may not terminate RG. In some cases, they
874: -- may have effective RG record.
875: -------Bug 5913362 -- Adding 890
876: IF (ghr_pay_calc.g_fwfa_pay_calc_flag) and
877: p_pa_request_rec.first_noa_code NOT IN ('866', '890')THEN
878:
879: BEGIN
880: -- FWFA Changes Bug#4444609 Added the IF Condition.

Line 903: IF ghr_pay_calc.g_pay_table_upd_flag THEN

899: l_new_temp_step := retained_grade_ovn.pei_information9;
900: exit;
901: END LOOP;
902:
903: IF ghr_pay_calc.g_pay_table_upd_flag THEN
904: l_new_pay_table := p_per_retained_grade.retain_pay_table_id;
905: p_per_retained_grade.per_retained_grade_flag := 'Y';
906: END IF;
907:

Line 1001: WHEN ghr_pay_calc.pay_calc_message THEN

997: END IF; -- per_retained_grade_flag
998: END IF; -- l_retained_grade_rec.person_extra_info_id NOT NULL
999: EXCEPTION
1000: -- IF No RG Record Exists, skip this updation.
1001: WHEN ghr_pay_calc.pay_calc_message THEN
1002: NULL;
1003: WHEN OTHERS THEN
1004: RAISE;
1005: END;

Line 2123: IF ghr_pay_calc.g_pay_table_upd_flag THEN

2119: ,p_information6 => p_pos_valid_grade.pay_basis
2120: ,p_information7 => p_pos_valid_grade.employment_category_group
2121: );
2122: -- Bug#4699682
2123: IF ghr_pay_calc.g_pay_table_upd_flag THEN
2124: ghr_mlc_pkg.position_history_update (p_position_id => P_PA_REQUEST_REC.to_position_id,
2125: p_effective_date => P_PA_REQUEST_REC.effective_date,
2126: p_table_id => P_PA_REQUEST_REC.from_pay_table_identifier,
2127: p_upd_tableid => p_pos_valid_grade.pay_table_id);

Line 5021: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;

5017: l_lei_date varchar2(60); -- Bug 3111719
5018: v_payroll_id number;
5019: v_asg_effective_start_date date;
5020: v_asg_effective_end_date date;
5021: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
5022: l_ret_grade_rec ghr_pay_calc.retained_grade_rec_type;
5023: l_new_date_to per_people_extra_info.pei_information1%type;
5024: l_new_grade_or_level per_people_extra_info.pei_information3%type;
5025: l_new_pay_plan per_people_extra_info.pei_information3%type;

Line 5022: l_ret_grade_rec ghr_pay_calc.retained_grade_rec_type;

5018: v_payroll_id number;
5019: v_asg_effective_start_date date;
5020: v_asg_effective_end_date date;
5021: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
5022: l_ret_grade_rec ghr_pay_calc.retained_grade_rec_type;
5023: l_new_date_to per_people_extra_info.pei_information1%type;
5024: l_new_grade_or_level per_people_extra_info.pei_information3%type;
5025: l_new_pay_plan per_people_extra_info.pei_information3%type;
5026: l_new_pay_table per_people_extra_info.pei_information3%type;

Line 5632: if ghr_pay_calc.g_gm_unadjd_basic_pay is not null and ghr_pay_calc.g_gm_unadjd_basic_pay <> 0 then

5628: --
5629: -- Processing Unadjusted Basic Pay
5630: --
5631: If p_pa_request_rec.to_adj_basic_pay is not null then
5632: if ghr_pay_calc.g_gm_unadjd_basic_pay is not null and ghr_pay_calc.g_gm_unadjd_basic_pay <> 0 then
5633: hr_utility.set_location(l_proc,21);
5634:
5635: ghr_element_api.process_sf52_element
5636: (p_assignment_id => p_pa_request_rec.employee_assignment_id

Line 5639: ,p_value1 => to_char(ghr_pay_calc.g_gm_unadjd_basic_pay)

5635: ghr_element_api.process_sf52_element
5636: (p_assignment_id => p_pa_request_rec.employee_assignment_id
5637: ,p_element_name => 'Unadjusted Basic Pay'
5638: ,p_input_value_name1 => 'Amount'
5639: ,p_value1 => to_char(ghr_pay_calc.g_gm_unadjd_basic_pay)
5640: ,p_effective_date => l_effective_date
5641: ,p_process_warning => l_basic_pay_warn
5642: );
5643: end if;

Line 6495: IF NOT(ghr_pay_calc.g_fwfa_pay_calc_flag) AND

6491: -- FWFA Changes. Restrict this update if the update happens already in call_extra_info_api.
6492:
6493:
6494:
6495: IF NOT(ghr_pay_calc.g_fwfa_pay_calc_flag) AND
6496: NOT(ghr_pay_calc.g_gl_upd_flag) THEN
6497: ghr_history_api.get_g_session_var(l_session);
6498: IF p_pa_request_rec.first_noa_code = '894' and
6499: ghr_process_sf52.g_prd IS NOT NULL AND

Line 6496: NOT(ghr_pay_calc.g_gl_upd_flag) THEN

6492:
6493:
6494:
6495: IF NOT(ghr_pay_calc.g_fwfa_pay_calc_flag) AND
6496: NOT(ghr_pay_calc.g_gl_upd_flag) THEN
6497: ghr_history_api.get_g_session_var(l_session);
6498: IF p_pa_request_rec.first_noa_code = '894' and
6499: ghr_process_sf52.g_prd IS NOT NULL AND
6500: l_session.noa_id_correct IS NULL THEN

Line 8150: p_retained_grade_rec out nocopy ghr_pay_calc.retained_grade_rec_type,

8146: Procedure get_wgi_dates
8147: (p_pa_request_rec in ghr_pa_requests%rowtype,
8148: p_wgi_due_date in out nocopy date,
8149: p_wgi_pay_date out nocopy date,
8150: p_retained_grade_rec out nocopy ghr_pay_calc.retained_grade_rec_type,
8151: p_dlei in date
8152: )
8153: is
8154:

Line 8165: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;

8161: l_wgi_pay_date date;
8162: l_wait_period ghr_pay_plan_waiting_periods.waiting_period%type;
8163: l_pay_plan ghr_pay_plans.pay_plan%type;
8164: l_step_or_rate ghr_pa_requests.to_step_or_rate%type;
8165: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
8166: l_maximum_step ghr_pa_requests.to_step_or_rate%type;
8167: l_grade_or_level ghr_pa_requests.to_grade_or_level%type;
8168: l_user_table_id pay_user_tables.user_table_id%TYPE;
8169:

Line 8243: ghr_pay_calc.get_pay_table_value

8239: --
8240: l_user_table_id := l_pos_ei_data.poei_information5;
8241: End if;
8242: -- get table values for the given payplan.,grade or level, step or rate, pay table combination.
8243: ghr_pay_calc.get_pay_table_value
8244: (p_user_table_id => l_user_table_id,
8245: p_pay_plan => 'GS',
8246: p_grade_or_level => l_grade_or_level,
8247: p_step_or_rate => '04',

Line 8256: ghr_pay_calc.get_pay_table_value

8252: );
8253: If p_pa_request_rec.to_basic_pay < l_step4value then
8254: p_wgi_due_date := p_pa_request_rec.effective_date + 364;
8255: Else
8256: ghr_pay_calc.get_pay_table_value
8257: (p_user_table_id => l_user_table_id,
8258: p_pay_plan => 'GS',
8259: p_grade_or_level => l_grade_or_level,
8260: p_step_or_rate => '07',

Line 8269: ghr_pay_calc.get_pay_table_value

8265: );
8266: If p_pa_request_rec.to_basic_pay between l_step4value and l_step7value then
8267: p_wgi_due_date := p_pa_request_rec.effective_date + 728;
8268: Else
8269: ghr_pay_calc.get_pay_table_value
8270: (p_user_table_id => l_user_table_id,
8271: p_pay_plan => 'GS',
8272: p_grade_or_level => l_grade_or_level,
8273: p_step_or_rate => '10',

Line 8366: when ghr_pay_calc.pay_calc_message then

8362: p_retained_Grade_rec.person_extra_info_id := l_retained_grade_rec.person_extra_info_id;
8363: End if; -- If p_pa_request_rec.first_noa_code in ('867',
8364:
8365: Exception
8366: when ghr_pay_calc.pay_calc_message then
8367: Null;
8368: End;
8369:
8370: Else -- else for -- If p_pa_request_rec.pay_rate_de