[Home] [Help]
13:
14: g_assignment_id per_all_assignments_f.assignment_id%TYPE := 0;
15: g_pl_typ_id ben_pl_f.pl_id%TYPE := 0;
16: g_balance_date DATE := hr_api.g_date;
17: g_absences_taken_to_date pqp_absval_pkg.t_entitlements;
18:
19: g_scheme_calendar_type pay_element_type_extra_info.eei_information1%TYPE;
20: g_scheme_calendar_duration pay_element_type_extra_info.eei_information1%TYPE;
21: g_scheme_calendar_uom pay_element_type_extra_info.eei_information1%TYPE;
24: -- Cache for get_omp_band_ent_bal_pl_typ
25: g_omp_assignment_id per_all_assignments_f.assignment_id%TYPE := 0;
26: g_omp_pl_typ_id ben_pl_f.pl_id%TYPE := 0;
27: g_omp_balance_date DATE := hr_api.g_date;
28: g_omp_absences_taken_to_date pqp_absval_pkg.t_entitlements;
29:
30: -- Cache for pqp_get_plan_extra_info
31: g_element_type_id pay_element_type_extra_info.element_type_id%TYPE;
32: g_plan_id ben_pl_f.pl_id%TYPE;
182:
183: g_assignment_id := NULL;--per_all_assignments_f.assignment_id%TYPE := 0
184: g_pl_typ_id := NULL;--ben_pl_f.pl_id%TYPE := 0
185: g_balance_date := NULL;--DATE := hr_api.g_date
186: g_absences_taken_to_date.DELETE; --pqp_absval_pkg.t_entitlements
187:
188: g_scheme_calendar_type := NULL ;
189: g_scheme_calendar_duration := NULL ;
190: g_scheme_calendar_uom := NULL ;
193: -- Cache for get_omp_band_ent_bal_pl_typ
194: g_omp_assignment_id := NULL;--per_all_assignments_f.assignment_id%TYPE := 0
195: g_omp_pl_typ_id := NULL;--ben_pl_f.pl_id%TYPE := 0
196: g_omp_balance_date := NULL;--DATE := hr_api.g_date
197: g_omp_absences_taken_to_date.DELETE; --pqp_absval_pkg.t_entitlements
198:
199: -- Cache for pqp_get_plan_extra_info
200: g_element_type_id := NULL;--pay_element_type_extra_info.element_type_id%TYPE
201: g_plan_id := NULL;--ben_pl_f.pl_id%TYPE
2138: (p_assignment_id IN NUMBER
2139: ,p_business_group_id IN NUMBER
2140: ,p_pl_id IN NUMBER
2141: ,p_effective_date IN DATE
2142: ,p_band_entitlements OUT NOCOPY pqp_absval_pkg.t_entitlements
2143: ,p_absence_pay_plan_class IN VARCHAR2 DEFAULT 'OMP'
2144: ,p_omp_intend_to_return_to_work IN VARCHAR2 DEFAULT 'X'
2145: ,p_entitlement_bands_list_name IN VARCHAR2 DEFAULT
2146: 'PQP_GAP_ENTITLEMENT_BANDS'
2173: l_override_entitlement_found BOOLEAN:= FALSE;
2174:
2175: l_pl_id_txt per_people_extra_info.pei_information3%TYPE;
2176:
2177: l_band_entitlements pqp_absval_pkg.t_entitlements;
2178:
2179: i BINARY_INTEGER:= 0;
2180: l_band_entitlement NUMBER;
2181:
2339: ,p_pl_id IN NUMBER
2340: ,p_absence_pay_plan_class IN VARCHAR2
2341: ,p_entitlement_table_id IN NUMBER
2342: ,p_benefits_length_of_service IN NUMBER
2343: ,p_band_entitlements OUT NOCOPY pqp_absval_pkg.t_entitlements
2344: ,p_error_msg OUT NOCOPY VARCHAR2
2345: ,p_omp_intend_to_return_to_work IN VARCHAR2 DEFAULT 'X'
2346: ,p_entitlement_bands_list_name IN VARCHAR2 DEFAULT
2347: 'PQP_GAP_ENTITLEMENT_BANDS'
2349: )
2350: RETURN NUMBER
2351: IS
2352: l_user_column_id pay_user_columns.user_column_id%TYPE;
2353: l_band_ent pqp_absval_pkg.t_entitlements;
2354: l_band_entitlement NUMBER;
2355: l_retval NUMBER;
2356:
2357: l_proc_step NUMBER(38,10):=0;
2869: )
2870: RETURN NUMBER
2871: IS
2872: l_user_column_id pay_user_columns.user_column_id%TYPE;
2873: l_band_ent pqp_absval_pkg.t_entitlements;
2874: l_band_ent_rows r_entitlement_parameters;
2875: l_ent_parameters t_entitlement_parameters;
2876: l_band_entitlement NUMBER;
2877: l_retval NUMBER;
3219: ,p_truncated_yes_no => l_truncated_yes_no
3220: ,p_error_msg => p_error_msg
3221: );
3222:
3223: pqp_absval_pkg.get_factors (
3224: p_business_group_id => p_business_group_id
3225: ,p_effective_date => l_effective_date
3226: ,p_assignment_id => p_assignment_id
3227: ,p_entitlement_uom => l_entitlement_uom
5535: IS
5536: l_proc_step NUMBER(38,10):=0;
5537: l_proc_name VARCHAR2(61):=
5538: g_package_name||'get_band_entitlement_balance';
5539: l_entitlements pqp_absval_pkg.t_entitlements;
5540: -- dummy used only to ensure that all mandatory params
5541: -- to get_absences_taken_to_date are fulfilled
5542: -- note passing an empty entitlements table to
5543: -- get_absences_taken_to_date has no impact
5543: -- get_absences_taken_to_date has no impact
5544: -- if you do pass it then the function ensures that
5545: -- any bands not used are set to 0.
5546:
5547: l_absences_taken_to_date pqp_absval_pkg.t_entitlements;
5548: i BINARY_INTEGER;
5549: l_retval NUMBER(11, 5) := 0;
5550: -- Added for CS
5551: l_dualrolling_4_year BOOLEAN := FALSE ;
5665: -- absence.To get the absences in terms of the current work pattern
5666: -- we need to multiply it with the l_working_days_per_week factor
5667: -- returned by the get_factors call.
5668:
5669: pqp_absval_pkg.get_absences_taken_to_date(
5670: p_assignment_id => p_assignment_id
5671: ,p_business_group_id => p_business_group_id
5672: ,p_effective_date => p_effective_date
5673: ,p_pl_typ_id => p_pl_typ_id
5735: -- l_retval := g_absences_taken_to_date(i).entitlement;
5736: -- i := NULL;
5737:
5738: --Added to get the current work-pattern and fte
5739: pqp_absval_pkg.get_factors (
5740: p_business_group_id => p_business_group_id
5741: ,p_effective_date => p_effective_date
5742: ,p_assignment_id => p_assignment_id
5743: ,p_entitlement_uom => p_entitlement_uom
6937: l_proc_step NUMBER(38,10):=0;
6938: l_proc_name VARCHAR2(61):=
6939: g_package_name||'get_omp_band_ent_bal_pl_typ';
6940:
6941: l_omp_absences_taken_to_date pqp_absval_pkg.t_entitlements;
6942: l_retval NUMBER;
6943: i BINARY_INTEGER;
6944: BEGIN
6945: debug_enter(l_proc_name);
10754: ,p_effective_date IN DATE
10755: ,p_pl_id IN NUMBER
10756: ,p_entitlement_table_id IN NUMBER
10757: ,p_benefits_length_of_service IN NUMBER
10758: ,p_band_entitlements OUT NOCOPY pqp_absval_pkg.t_entitlements
10759: ,p_entitlement_bands_list_name IN VARCHAR2 DEFAULT
10760: 'PQP_GAP_ENTITLEMENT_BANDS'
10761: )
10762: IS
10760: 'PQP_GAP_ENTITLEMENT_BANDS'
10761: )
10762: IS
10763: l_user_column_id pay_user_columns.user_column_id%TYPE;
10764: l_band_ent pqp_absval_pkg.t_entitlements;
10765: l_band_entitlement NUMBER;
10766: l_retval NUMBER;
10767:
10768: l_proc_step NUMBER(38,10):=0;