[Home] [Help]
1: PACKAGE BODY PER_SALADMIN_UTILITY AS
2: /* $Header: pesalutl.pkb 120.25.12010000.2 2008/11/07 07:00:46 schowdhu ship $ */
3:
4: g_package Varchar2(30) := 'per_saladmin_utility.';
5: g_debug boolean := hr_utility.debug_enabled;
1: PACKAGE BODY PER_SALADMIN_UTILITY AS
2: /* $Header: pesalutl.pkb 120.25.12010000.2 2008/11/07 07:00:46 schowdhu ship $ */
3:
4: g_package Varchar2(30) := 'per_saladmin_utility.';
5: g_debug boolean := hr_utility.debug_enabled;
6:
7: function Check_GSP_Manual_Override (p_assignment_id in NUMBER, p_effective_date in DATE) RETURN VARCHAR2 is
8: Cursor Grade_Ladder Is
54: select ppb.grade_annualization_factor
55: ,ppb.pay_basis
56: ,ppb.rate_basis
57: ,pet.input_currency_code as element_currency_code
58: ,PER_SALADMIN_UTILITY.get_grade_currency(paa.grade_id,ppb.rate_id,p_effective_date,paa.business_group_id) as grade_rate_currency_code
59: ,ben_cwb_person_info_pkg.get_grd_min_val(paa.grade_id,ppb.rate_id,p_effective_date)
60: from per_all_assignments_f paa
61: ,per_pay_bases ppb
62: ,pay_input_values_f piv
72: open grd_min_rate;
73: fetch grd_min_rate into l_grd_annualization_factor,l_pay_basis,l_rate_basis,l_element_curr_code,l_grade_curr_code,l_grd_min_val;
74: close grd_min_rate;
75:
76: l_conversion_rate := nvl(PER_SALADMIN_UTILITY.get_currency_rate(l_grade_curr_code,l_element_curr_code,p_effective_date,p_business_group_id),1);
77:
78: if(l_element_curr_code = l_grade_curr_code) then
79: if l_grd_annualization_factor is null then
80: l_grd_min_val := null;
112: select ppb.grade_annualization_factor
113: ,ppb.pay_basis
114: ,ppb.rate_basis
115: ,pet.input_currency_code as element_currency_code
116: ,PER_SALADMIN_UTILITY.get_grade_currency(paa.grade_id,ppb.rate_id,p_effective_date,paa.business_group_id) as grade_rate_currency_code
117: ,ben_cwb_person_info_pkg.get_grd_max_val(paa.grade_id,ppb.rate_id,p_effective_date)
118: from per_all_assignments_f paa
119: ,per_pay_bases ppb
120: ,pay_input_values_f piv
130: open grd_max_rate;
131: fetch grd_max_rate into l_grd_annualization_factor,l_pay_basis,l_rate_basis,l_element_curr_code,l_grade_curr_code,l_grd_max_val;
132: close grd_max_rate;
133:
134: l_conversion_rate := nvl(PER_SALADMIN_UTILITY.get_currency_rate(l_grade_curr_code,l_element_curr_code,p_effective_date,p_business_group_id),1);
135:
136: if(l_element_curr_code = l_grade_curr_code) then
137: if l_grd_annualization_factor is null then
138: l_grd_max_val := null;
355:
356: begin
357:
358: if g_debug then
359: hr_utility.trace('In per_saladmin_utility.adjust_pay_proposals');
360: end if;
361: for i in csr_pay_proposals loop
362: ---vkodedal fix -5941519
363: l_element_entry_end_date:=null;
420:
421: end loop;
422:
423: if g_debug then
424: hr_utility.trace('OUT per_saladmin_utility.adjust_pay_proposals');
425: end if;
426:
427: end adjust_pay_proposals;
428:
1058: and prl.period_type = tpt.period_type(+);
1059: --
1060: begin
1061: --
1062: hr_utility.set_location('Entering PER_SALADMIN_UTILITY.get_sal_on_basis_chg',10);
1063: --
1064: l_change:=null;
1065: l_new:=null;
1066: l_comps:='N'; --:REVIEW.MULTIPLE_COMPONENTS;
1234: g_new_sal_value := l_new;
1235: --
1236: End if;
1237: --
1238: hr_utility.set_location('Leaving PER_SALADMIN_UTILITY.get_sal_on_basis_chg ',100);
1239: --
1240: EXCEPTION
1241: WHEN others THEN
1242: --
1239: --
1240: EXCEPTION
1241: WHEN others THEN
1242: --
1243: hr_utility.set_location('Exception: PER_SALADMIN_UTILITY.get_sal_on_basis_chg',100);
1244: g_proposal_rec := null;
1245: g_new_sal_value := null;
1246: raise;
1247: --
1313: g_new_sal_value := null;
1314:
1315: EXCEPTION
1316: WHEN others THEN
1317: hr_utility.set_location('Exception: PER_SALADMIN_UTILITY.insert_pay_proposal',100);
1318: g_proposal_rec := null;
1319: g_new_sal_value := null;
1320: raise;
1321: end;
1573: CLOSE c_asg_sal_basis_end_dt;
1574: return (null);
1575: end get_asg_sal_basis_end_dt;
1576:
1577: END PER_SALADMIN_UTILITY;
1578: