[Home] [Help]
1700: -- per_absence_attendances. Inputs are absence_attendance_id and the title
1701: -- of the column in the absence form.The mapping of form title to the DB
1702: -- column is done in Lookup and the same is fetched by calling
1703: -- get_lookup_code function. For the Fields which are displayed from
1704: -- Other Tables are derived individually and those columns are ABSENCE_TYPE,
1705: -- ABSENCE_CATEGORY, ABSENCE_REASON, AUTHORIZATION PERSON,
1706: -- AUTHORIZATION PERSON EMPLOYEE NUMBER ,REPLACEMENT PERSON NAME,
1707: -- REPLACEMENT PERSON EMPLOYEE NUMBER
1708: FUNCTION get_absence_details(
2057: SELECT fnd_date.date_to_canonical(
2058: ssp_smp_pkg.qualifying_week(fnd_date.canonical_to_date(l_due_date))
2059: )
2060: INTO l_val
2061: FROM DUAL;
2062: EXCEPTION
2063: WHEN OTHERS
2064: THEN
2065: p_error_code := -1;
2088: SELECT fnd_date.date_to_canonical(
2089: ssp_smp_pkg.expected_week_of_confinement(fnd_date.canonical_to_date(l_due_date))
2090: )
2091: INTO l_val
2092: FROM DUAL;
2093: EXCEPTION
2094: WHEN OTHERS
2095: THEN
2096: p_error_code := -1;
3241:
3242:
3243: -- Change this logic as this will be supported by the above changes
3244:
3245: IF l_scheme_type = 'DUALROLLING' THEN
3246:
3247: -- l_retval :=
3248: -- pqp_utilities.pqp_get_extra_element_info(
3249: -- p_element_type_id => p_element_type_id
3574: -- ,hr_api.g_eot, p_abs_start_date
3575: -- ,p_abs_end_date
3576: -- )
3577: --INTO l_abs_end_date
3578: --FROM DUAL;
3579:
3580: IF TRUNC(p_abs_end_date) = hr_api.g_eot THEN
3581: l_abs_end_date := p_abs_start_date;
3582: ELSE
3632:
3633: CURSOR c_no_of_days(c_start_date IN DATE, c_end_date IN DATE)
3634: IS
3635: SELECT (c_end_date - c_start_date + 1) cnt
3636: FROM DUAL;
3637: BEGIN
3638: IF g_debug THEN
3639: debug_enter(l_proc_name);
3640: debug('p_start_date:'||fnd_date.date_to_canonical(p_start_date));
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 ;
5552: l_working_days_in_week
5553: pqp_gap_daily_absences.working_days_per_week%TYPE ;
5554: l_standard_work_days_in_week
5555: pqp_gap_daily_absences.working_days_per_week%TYPE ;
5652: debug(l_proc_name,l_proc_step);
5653: END IF;
5654:
5655: IF p_days_hours = 'WEEKS' THEN -- CSDAYS is changed to WEEKS
5656: l_dualrolling_4_year := TRUE ;
5657: END IF ;
5658:
5659:
5660: -- Idealy get_absences_taken_to_dates should return absences
5677: ,p_scheme_period_uom => p_scheme_calendar_uom
5678: ,p_scheme_period_start => p_scheme_start_date
5679: ,p_entitlements => l_entitlements
5680: ,p_absences_taken_to_date => l_absences_taken_to_date
5681: ,p_dualrolling_4_year => l_dualrolling_4_year
5682: ,p_plan_types_to_extend_period => p_plan_types_to_extend_period
5683: ,p_entitlement_uom => p_entitlement_uom
5684: ,p_default_wp => p_default_work_pattern
5685: ,p_absence_schedule_wp => p_absence_schedule_wp
5953: ,eei.eei_information5 cal_uom
5954: ,eei.eei_information6 start_date
5955: ,eei.eei_information26 overlap_rul
5956: -- Added for CS
5957: ,eei.eei_information20 dualrolling_dur
5958: ,eei.eei_information21 dualrolling_uom
5959: ,eei.eei_information17 default_work_pattern
5960: -- Added for LG/PT
5961: ,eei.eei_information22 track_part_timers
5954: ,eei.eei_information6 start_date
5955: ,eei.eei_information26 overlap_rul
5956: -- Added for CS
5957: ,eei.eei_information20 dualrolling_dur
5958: ,eei.eei_information21 dualrolling_uom
5959: ,eei.eei_information17 default_work_pattern
5960: -- Added for LG/PT
5961: ,eei.eei_information22 track_part_timers
5962: ,eei.eei_information8 entitlement_uom
6007: -- This control enters into this IF only
6008: -- when this is called from 4-Years Function
6009: -- changing the scheme duration and uom to refer to 4-years
6010: -- segments.
6011: IF l_scheme_det.cal_type = 'DUALROLLING' AND p_days_hours='WEEKS' THEN
6012: l_scheme_duration := l_scheme_det.dualrolling_dur ;
6013: l_scheme_uom := l_scheme_det.dualrolling_uom ;
6014: END IF;
6015:
6008: -- when this is called from 4-Years Function
6009: -- changing the scheme duration and uom to refer to 4-years
6010: -- segments.
6011: IF l_scheme_det.cal_type = 'DUALROLLING' AND p_days_hours='WEEKS' THEN
6012: l_scheme_duration := l_scheme_det.dualrolling_dur ;
6013: l_scheme_uom := l_scheme_det.dualrolling_uom ;
6014: END IF;
6015:
6016: -- setting the p_days_hours to WEEKS
6009: -- changing the scheme duration and uom to refer to 4-years
6010: -- segments.
6011: IF l_scheme_det.cal_type = 'DUALROLLING' AND p_days_hours='WEEKS' THEN
6012: l_scheme_duration := l_scheme_det.dualrolling_dur ;
6013: l_scheme_uom := l_scheme_det.dualrolling_uom ;
6014: END IF;
6015:
6016: -- setting the p_days_hours to WEEKS
6017: -- for 4-year call p_days_hours is already WEEKS
6019: -- the reason being in the function we are returning the
6020: -- BANd Days based on work pattern when p_days_hours = 'WEEKS'
6021: -- this is requried whether it is 4-year or 1-year.
6022:
6023: IF l_scheme_det.cal_type = 'DUALROLLING' THEN
6024: l_days_hours := 'WEEKS' ;
6025: END IF ;
6026: --
6027: -- Call get_band_entitlement_balance to get the entitlements.
11620: debug(l_proc_name,20);
11621: END IF;
11622:
11623:
11624: IF p_scheme_cal_type = 'DUALROLLING'
11625: THEN
11626:
11627: IF g_debug THEN
11628: debug(l_proc_name,25);
11703: p_band2_remaining := l_band2_entitlement - p_band2_ent_used;
11704: p_band3_remaining := l_band3_entitlement - p_band3_ent_used;
11705: p_band4_remaining := l_band4_entitlement - p_band4_ent_used;
11706:
11707: IF p_scheme_cal_type <> 'DUALROLLING' THEN
11708:
11709: IF g_debug THEN
11710: debug(l_proc_name,55);
11711: END IF;
11788: ) ;
11789:
11790:
11791: --Round Absence Used Four years figures
11792: IF p_scheme_cal_type = 'DUALROLLING'
11793: THEN
11794:
11795: IF g_debug THEN
11796: debug(l_proc_name,65);