[Home] [Help]
2137: hr_utility.set_location( 'Fetch old Retention Allowance' || l_proc,15);
2138:
2139: -------Assignment id is different then need to be checked the following logic.
2140:
2141: ghr_api.retrieve_element_entry_value (p_element_name => 'Retention Allowance'
2142: ,p_input_value_name => 'Amount'
2143: ,p_assignment_id => l_session.assignment_id
2144: ,p_effective_date => l_old_effective_date
2145: ,p_value => l_value
2146: ,p_multiple_error_flag => l_multi_error_flag);
2147: l_old_ret_allow := to_number(l_value);
2148: hr_utility.set_location( 'l_old_ret_allow is ' || to_char(l_old_ret_allow), 15);
2149:
2150: ghr_api.retrieve_element_entry_value (p_element_name => 'Retention Allowance'
2151: ,p_input_value_name => 'Amount'
2152: ,p_assignment_id => l_session.assignment_id
2153: ,p_effective_date => nvl(l_ia_effective_date,l_effective_date)
2154: ,p_value => l_value
2157: hr_utility.set_location( 'l_from_retention_allowance is ' || to_char(l_from_retention_allowance), 15);
2158: --
2159: -- Modifying the input values from percent to percentage for Payroll Integration
2160: --
2161: ghr_api.retrieve_element_entry_value (p_element_name => 'Basic Salary Rate'
2162: ,p_input_value_name => 'Rate'
2163: ,p_assignment_id => l_session.assignment_id
2164: ,p_effective_date => nvl(l_ia_effective_date,l_effective_date)
2165: ,p_value => l_value
2167: l_from_basic_pay := to_number(l_value);
2168: hr_utility.set_location( 'l_from_basic_pay is ' || to_char(l_from_basic_pay), 15);
2169:
2170: if l_ia_effective_date is not null then
2171: ghr_api.retrieve_element_entry_value (p_element_name => 'Retention Allowance'
2172: ,p_input_value_name => 'Amount'
2173: ,p_assignment_id => l_session.assignment_id
2174: ,p_effective_date => l_ia_effective_date
2175: ,p_value => l_value
2179: hr_utility.set_location( 'RA is ' || to_char(l_ghr_pa_request_rec.to_retention_allowance), 15);
2180: --
2181: -- Modifying the input values from percent to percentage for Payroll Integration
2182: --
2183: ghr_api.retrieve_element_entry_value (p_element_name => 'Retention Allowance'
2184: ,p_input_value_name => 'Percentage'
2185: ,p_assignment_id => l_session.assignment_id
2186: ,p_effective_date => l_ia_effective_date
2187: ,p_value => l_value
2189:
2190: l_ghr_pa_request_rec.to_retention_allow_percentage := to_number(l_value);
2191: hr_utility.set_location( 'RA % is ' || to_char(l_ghr_pa_request_rec.to_retention_allow_percentage),15);
2192:
2193: ghr_api.retrieve_element_entry_value (p_element_name => 'Supervisory Differential'
2194: ,p_input_value_name => 'Amount'
2195: ,p_assignment_id => l_session.assignment_id
2196: ,p_effective_date => l_ia_effective_date
2197: ,p_value => l_value
2200: l_ghr_pa_request_rec.to_supervisory_differential := to_number(l_value);
2201: hr_utility.set_location( 'SD is ' || to_char(l_ghr_pa_request_rec.to_supervisory_differential), 15);
2202:
2203:
2204: ghr_api.retrieve_element_entry_value (p_element_name => 'AUO'
2205: ,p_input_value_name => 'Premium Pay Ind'
2206: ,p_assignment_id => l_session.assignment_id
2207: ,p_effective_date => l_ia_effective_date
2208: ,p_value => l_value
2211: l_ghr_pa_request_rec.to_auo_premium_pay_indicator := l_value;
2212: hr_utility.set_location( 'AUO is ' || (l_ghr_pa_request_rec.to_auo_premium_pay_indicator), 15);
2213:
2214:
2215: ghr_api.retrieve_element_entry_value (p_element_name => 'Availability Pay'
2216: ,p_input_value_name => 'Premium Pay Ind'
2217: ,p_assignment_id => l_session.assignment_id
2218: ,p_effective_date => l_ia_effective_date
2219: ,p_value => l_value
2418: IF l_pay_calc_data.pay_rate_determinant IN ('A','B','E','F','U','V','M') THEN
2419: BEGIN
2420: -- Begin Bug# 13619633, as per bug 1929382 for 866 we are passing eff date+1 this is casuing the issue.
2421: --- So passing eff date -1 for noa 866.
2422: IF NVL(p_noa_code,hr_api.g_varchar2) = '866' OR NVL(p_second_noa_code,hr_api.g_varchar2) = '866' THEN
2423: l_retained_grade := ghr_pc_basic_pay.get_retained_grade_details (l_pay_calc_data.person_id
2424: ,l_pay_calc_data.effective_date-1
2425: ,l_pay_calc_data.pa_request_id);
2426: ELSE
3662: -- Fetch the value Unadjusted Basic pay. The very first time user will enter it.
3663: --
3664: begin
3665:
3666: ghr_api.retrieve_element_entry_value (p_element_name => 'Unadjusted Basic Pay'
3667: ,p_input_value_name => 'Amount'
3668: ,p_assignment_id => l_assignment_id
3669: ,p_effective_date => (p_pay_calc_data.effective_date - 1)
3670: ,p_value => l_value
3841: -- Fetch the value Unadjusted Basic pay. The very first time user will enter it.
3842: --
3843: begin
3844:
3845: ghr_api.retrieve_element_entry_value (p_element_name => 'Unadjusted Basic Pay'
3846: ,p_input_value_name => 'Amount'
3847: ,p_assignment_id => l_assignment_id
3848: ,p_effective_date => (p_pay_calc_data.effective_date - 1)
3849: ,p_value => l_value