[Home] [Help]
1: PACKAGE BODY PER_SALADMIN_UTILITY AS
2: /* $Header: pesalutl.pkb 120.41.12020000.3 2012/11/08 06:42:55 vsripera 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.41.12020000.3 2012/11/08 06:42:55 vsripera 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;
359:
360: begin
361:
362: if g_debug then
363: hr_utility.trace('In per_saladmin_utility.adjust_pay_proposals');
364: end if;
365: for i in csr_pay_proposals loop
366: ---vkodedal fix -5941519
367: l_element_entry_end_date:=null;
424:
425: end loop;
426:
427: if g_debug then
428: hr_utility.trace('OUT per_saladmin_utility.adjust_pay_proposals');
429: end if;
430:
431: end adjust_pay_proposals;
432:
1060:
1061: begin
1062:
1063: ---
1064: hr_utility.set_location('Entering PER_SALADMIN_UTILITY.handle_asg_crit_change ',1);
1065: --
1066: hr_utility.set_location('p_assignment_id ='||to_char(p_assignment_id),5);
1067: hr_utility.set_location('p_effective_date ='||p_effective_date,5);
1068: --get the element entry details that's created on p_effective_date
1199: close csr_creator_id;
1200:
1201: --
1202: --
1203: hr_utility.set_location('Leaving PER_SALADMIN_UTILITY.handle_asg_crit_change ',100);
1204: --
1205: EXCEPTION
1206: WHEN others THEN
1207: --
1204: --
1205: EXCEPTION
1206: WHEN others THEN
1207: --
1208: hr_utility.set_location('Exception: PER_SALADMIN_UTILITY.handle_asg_crit_change',120);
1209: raise;
1210: --
1211: end;
1212:
1283: and prl.period_type = tpt.period_type(+);
1284: --
1285: begin
1286: --
1287: hr_utility.set_location('Entering PER_SALADMIN_UTILITY.get_sal_on_basis_chg',10);
1288: --
1289: l_change:=null;
1290: l_new:=null;
1291: l_comps:='N'; --:REVIEW.MULTIPLE_COMPONENTS;
1459: g_new_sal_value := l_new;
1460: --
1461: End if;
1462: --
1463: hr_utility.set_location('Leaving PER_SALADMIN_UTILITY.get_sal_on_basis_chg ',100);
1464: --
1465: EXCEPTION
1466: WHEN others THEN
1467: --
1464: --
1465: EXCEPTION
1466: WHEN others THEN
1467: --
1468: hr_utility.set_location('Exception: PER_SALADMIN_UTILITY.get_sal_on_basis_chg',100);
1469: g_proposal_rec := null;
1470: g_new_sal_value := null;
1471: raise;
1472: --
1538: g_new_sal_value := null;
1539:
1540: EXCEPTION
1541: WHEN others THEN
1542: hr_utility.set_location('Exception: PER_SALADMIN_UTILITY.insert_pay_proposal',100);
1543: g_proposal_rec := null;
1544: g_new_sal_value := null;
1545: raise;
1546: end;
1818: CLOSE c_asg_sal_basis_end_dt;
1819: return (null);
1820: end get_asg_sal_basis_end_dt;
1821:
1822: END PER_SALADMIN_UTILITY;
1823: