[Home] [Help]
152: Fixed number width for
153: total hours variables in
154: convert_period_type,
155: work_schedule_total_hours,
156: and standard_hours_worked.
157:
158: 25-Jul-96 P Jones 40.30 Removed user_errors
159:
160: 1st Nov 1996 hparicha 40.31 408507 Removing vacation and sick
252: be done depending on the calculation
253: rule given on the payroll define screen.
254: The default calculation rule is
255: Annulization, and the other available
256: rule is Standard.
257: Also added ORDERED hint in function
258: addr_val(Bug 1484707).
259: 09-MAR-2001 ssarma 115.24 Added a new parameter
260: p_hour_calc_override to
300: not translated. Now it is
301: getting the day number and then
302: based upon the number it deter
303: mines the day. Also changed
304: standard_hours_worked to do the
305: same.
306: 18-NOV-2002 tclewis 115.31 2666118 Changed convert_period_type
307: where we are querring number per
308: fiscal year. to change
543: IF UPPER(p_wsched) = 'NOT ENTERED' THEN
544:
545: hr_utility.set_location('Prorate_Earnings', 7);
546: hr_utility.trace('p_wsched NOT ENTERED');
547: hr_utility.trace('Calling Standard Hours Worked');
548:
549: v_hours_in_range := Standard_Hours_Worked( p_asg_std_hours,
550: p_range_start_date,
551: p_range_end_date,
545: hr_utility.set_location('Prorate_Earnings', 7);
546: hr_utility.trace('p_wsched NOT ENTERED');
547: hr_utility.trace('Calling Standard Hours Worked');
548:
549: v_hours_in_range := Standard_Hours_Worked( p_asg_std_hours,
550: p_range_start_date,
551: p_range_end_date,
552: p_asg_std_freq);
553:
1194: -- For Hourly pay basis:
1195: -- Get hours scheduled for the current period either from:
1196: -- 1. ASG work schedule
1197: -- 2. ORG default work schedule
1198: -- 3. ASG standard hours and frequency
1199: -- Multiply the hours scheduled for period by normal Hourly Rate (ie. from
1200: -- pre-defined earnings, REGULAR_WAGES_RATE) pay period earnings.
1201: --
1202: -- In either case, need to find the payroll period type, let's do it upfront:
1243: -- Pay basis is hourly,
1244: -- Get hours scheduled for the current period either from:
1245: -- 1. ASG work schedule
1246: -- 2. ORG default work schedule
1247: -- 3. ASG standard hours and frequency
1248: -- Do we pass in Work Schedule from asst scl db item? Yes
1249: -- 10-JAN-1996 hparicha : We no longer assume "standard hours" represent
1250: -- a weekly figure. We also no longer use a week as
1251: -- the basis for annualization,
1245: -- 1. ASG work schedule
1246: -- 2. ORG default work schedule
1247: -- 3. ASG standard hours and frequency
1248: -- Do we pass in Work Schedule from asst scl db item? Yes
1249: -- 10-JAN-1996 hparicha : We no longer assume "standard hours" represent
1250: -- a weekly figure. We also no longer use a week as
1251: -- the basis for annualization,
1252: -- even when using work schedule - ie. need to find ACTUAL
1253: -- scheduled hours, not
1284: hr_utility.trace('v_hrs_per_range ='||to_char(v_hrs_per_range));
1285: ELSE
1286:
1287: hr_utility.trace('Asg has No Work Schedule');
1288: hr_utility.trace('Calling Standard_Hours_Worked');
1289:
1290: v_hrs_per_range := Standard_Hours_Worked( p_asst_std_hrs,
1291: p_period_start,
1292: p_period_end,
1286:
1287: hr_utility.trace('Asg has No Work Schedule');
1288: hr_utility.trace('Calling Standard_Hours_Worked');
1289:
1290: v_hrs_per_range := Standard_Hours_Worked( p_asst_std_hrs,
1291: p_period_start,
1292: p_period_end,
1293: p_asst_std_freq);
1294: hr_utility.trace('v_hrs_per_range ='||to_char(v_hrs_per_range));
2219: END Calculate_Period_Earnings;
2220:
2221: -- **********************************************************************
2222:
2223: FUNCTION standard_hours_worked(
2224: p_std_hrs in NUMBER,
2225: p_range_start in DATE,
2226: p_range_end in DATE,
2227: p_std_freq in VARCHAR2) RETURN NUMBER IS
2236: v_curr_date DATE;
2237: v_curr_day VARCHAR2(3); -- 3 char abbrev for day of wk.
2238: v_day_no NUMBER;
2239:
2240: BEGIN -- standard_hours_worked
2241:
2242: /* Init */
2243: c_wkdays_per_week := 5;
2244: c_wkdays_per_month := 20;
2248: v_curr_date := NULL;
2249: v_curr_day :=NULL;
2250:
2251: -- Check for valid range
2252: hr_utility.trace('Entered standard_hours_worked');
2253:
2254: IF p_range_start > p_range_end THEN
2255: hr_utility.trace('p_range_start greater than p_range_end');
2256: RETURN v_total_hours;
2315: v_curr_date := v_curr_date + 1;
2316: EXIT WHEN v_curr_date > p_range_end;
2317: END LOOP;
2318: hr_utility.trace(' Final v_total_hours = '||to_char(v_total_hours));
2319: hr_utility.trace(' Leaving standard_hours_worked' );
2320: --
2321: RETURN v_total_hours;
2322: --
2323: END standard_hours_worked;
2319: hr_utility.trace(' Leaving standard_hours_worked' );
2320: --
2321: RETURN v_total_hours;
2322: --
2323: END standard_hours_worked;
2324: --
2325: -- **********************************************************************
2326: FUNCTION Convert_Period_Type(
2327: p_bus_grp_id in NUMBER,
2465: v_work_sched_name,
2466: v_range_start,
2467: v_range_end);
2468:
2469: ELSE-- Hourly emp using Standard Hours on asg.
2470:
2471: hr_utility.trace(' Hourly emp using Standard Hours on asg');
2472:
2473:
2467: v_range_end);
2468:
2469: ELSE-- Hourly emp using Standard Hours on asg.
2470:
2471: hr_utility.trace(' Hourly emp using Standard Hours on asg');
2472:
2473:
2474: hr_utility.trace(' calling Standard_Hours_Worked');
2475: v_hrs_per_range := Standard_Hours_Worked( p_asg_std_hrs,
2470:
2471: hr_utility.trace(' Hourly emp using Standard Hours on asg');
2472:
2473:
2474: hr_utility.trace(' calling Standard_Hours_Worked');
2475: v_hrs_per_range := Standard_Hours_Worked( p_asg_std_hrs,
2476: v_range_start,
2477: v_range_end,
2478: p_asg_std_freq);
2471: hr_utility.trace(' Hourly emp using Standard Hours on asg');
2472:
2473:
2474: hr_utility.trace(' calling Standard_Hours_Worked');
2475: v_hrs_per_range := Standard_Hours_Worked( p_asg_std_hrs,
2476: v_range_start,
2477: v_range_end,
2478: p_asg_std_freq);
2479:
2637: v_work_sched_name,
2638: v_range_start,
2639: v_range_end);
2640:
2641: ELSE-- Hourly emp using Standard Hours on asg.
2642:
2643: hr_utility.trace(' Hourly emp using Standard Hours on asg');
2644:
2645: hr_utility.trace('calling Standard_Hours_Worked');
2639: v_range_end);
2640:
2641: ELSE-- Hourly emp using Standard Hours on asg.
2642:
2643: hr_utility.trace(' Hourly emp using Standard Hours on asg');
2644:
2645: hr_utility.trace('calling Standard_Hours_Worked');
2646:
2647: v_hrs_per_range := Standard_Hours_Worked(p_asg_std_hrs,
2641: ELSE-- Hourly emp using Standard Hours on asg.
2642:
2643: hr_utility.trace(' Hourly emp using Standard Hours on asg');
2644:
2645: hr_utility.trace('calling Standard_Hours_Worked');
2646:
2647: v_hrs_per_range := Standard_Hours_Worked(p_asg_std_hrs,
2648: v_range_start,
2649: v_range_end,
2643: hr_utility.trace(' Hourly emp using Standard Hours on asg');
2644:
2645: hr_utility.trace('calling Standard_Hours_Worked');
2646:
2647: v_hrs_per_range := Standard_Hours_Worked(p_asg_std_hrs,
2648: v_range_start,
2649: v_range_end,
2650: p_asg_std_freq);
2651:
2648: v_range_start,
2649: v_range_end,
2650: p_asg_std_freq);
2651:
2652: hr_utility.trace('returned Standard_Hours_Worked');
2653: END IF;
2654:
2655:
2656: IF v_period_hours THEN
2778: /***********************************************************
2779: The is wrapper is added to check the caluclation rule given
2780: at the payroll level. Depending upon the Rule we will the
2781: Get_Annualizing_Factor fun calls. If the rule is
2782: standard it goes to Standard Caluclation type. If the rule
2783: is Annual then it goes to ANNU rule
2784: **************************************************************/
2785: IF p_period_start_date IS NULL THEN
2786: v_stnd_start_date := sysdate;