[Home] [Help]
3215: RETURN v_total_hours;
3216: --
3217: END work_schedule_total_hours;
3218: --
3219: -----------------------Standard_hours_worked---------------------------------
3220: --
3221: -- The foll function was borrowed from payroll but has been revamped because of lookup
3222: -- issues.
3223: --
3220: --
3221: -- The foll function was borrowed from payroll but has been revamped because of lookup
3222: -- issues.
3223: --
3224: FUNCTION standard_hours_worked( p_std_hrs in NUMBER,
3225: p_range_start in DATE,
3226: p_range_end in DATE,
3227: p_std_freq in VARCHAR2) RETURN NUMBER IS
3228: --
3238: select information3
3239: from per_shared_types
3240: where lookup_type ='FREQUENCY'
3241: and system_type_cd = p_std_freq;
3242: BEGIN -- standard_hours_worked
3243: --
3244: -- Check for valid range. If range_end is NULL or range_end < range_start
3245: -- 0 hours will be returned.
3246: --
3243: --
3244: -- Check for valid range. If range_end is NULL or range_end < range_start
3245: -- 0 hours will be returned.
3246: --
3247: hr_utility.set_location('standard_hours_worked', 5);
3248: --
3249: IF p_range_start > p_range_end THEN
3250: hr_utility.set_location('standard_hours_worked', 7);
3251: RETURN v_total_hours;
3246: --
3247: hr_utility.set_location('standard_hours_worked', 5);
3248: --
3249: IF p_range_start > p_range_end THEN
3250: hr_utility.set_location('standard_hours_worked', 7);
3251: RETURN v_total_hours;
3252: END IF;
3253: --
3254: -- This portion calculates how may hours are worked in a day.
3271: v_wrkday_hours := p_std_hrs/l_wkdays;
3272: --
3273: v_curr_date := p_range_start;
3274: --
3275: hr_utility.set_location('standard_hours_worked', 10);
3276:
3277: LOOP
3278: --
3279: -- Loop through all the working days in the range supplied and find
3280: -- how may hours were worked , during that period.
3281: --
3282: v_curr_day := TO_CHAR(v_curr_date, 'DY');
3283: --
3284: hr_utility.set_location('standard_hours_worked', 15);
3285: --
3286: IF UPPER(v_curr_day) in ('MON', 'TUE', 'WED', 'THU', 'FRI') THEN
3287: v_total_hours := v_total_hours + v_wrkday_hours;
3288: hr_utility.set_location('standard_hours_worked v_total_hours = ', v_total_hours);
3284: hr_utility.set_location('standard_hours_worked', 15);
3285: --
3286: IF UPPER(v_curr_day) in ('MON', 'TUE', 'WED', 'THU', 'FRI') THEN
3287: v_total_hours := v_total_hours + v_wrkday_hours;
3288: hr_utility.set_location('standard_hours_worked v_total_hours = ', v_total_hours);
3289: END IF;
3290: --
3291: v_curr_date := v_curr_date + 1;
3292: --
3295: END LOOP;
3296: --
3297: RETURN v_total_hours;
3298: --
3299: END standard_hours_worked;
3300: --
3301: ---------------------Convert_period_Type--------------------------------------
3302: --
3303: -- The following function converts the passed p_figure from one
3418: END IF;
3419: --
3420: -- If this is an Hourly employee and the work schedule name
3421: -- has not been provided , then the total hours worked during the
3422: -- given period is calculated using Standard Hours on the
3423: -- assignment.
3424: -- removed reference of work schedule as it was always passed as null
3425: --
3426: v_hrs_per_range := Standard_Hours_Worked(p_asg_std_hrs,
3422: -- given period is calculated using Standard Hours on the
3423: -- assignment.
3424: -- removed reference of work schedule as it was always passed as null
3425: --
3426: v_hrs_per_range := Standard_Hours_Worked(p_asg_std_hrs,
3427: v_range_start,
3428: v_range_end,
3429: p_asg_std_freq);
3430: --
3592: v_range_end := sysdate + 6;
3593: v_period_hours := FALSE;
3594: END IF;
3595: hr_utility.set_location('getting std hours', 100);
3596: v_hrs_per_range := Standard_Hours_Worked(p_asg_std_hrs,
3597: v_range_start,
3598: v_range_end,
3599: p_asg_std_freq);
3600: IF v_period_hours THEN