[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
534: IF UPPER(p_wsched) = 'NOT ENTERED' THEN
535:
536: hr_utility.set_location('Prorate_Earnings', 7);
537: hr_utility.trace('p_wsched NOT ENTERED');
538: hr_utility.trace('Calling Standard Hours Worked');
539:
540: v_hours_in_range := Standard_Hours_Worked( p_asg_std_hours,
541: p_range_start_date,
542: p_range_end_date,
536: hr_utility.set_location('Prorate_Earnings', 7);
537: hr_utility.trace('p_wsched NOT ENTERED');
538: hr_utility.trace('Calling Standard Hours Worked');
539:
540: v_hours_in_range := Standard_Hours_Worked( p_asg_std_hours,
541: p_range_start_date,
542: p_range_end_date,
543: p_asg_std_freq);
544:
1185: -- For Hourly pay basis:
1186: -- Get hours scheduled for the current period either from:
1187: -- 1. ASG work schedule
1188: -- 2. ORG default work schedule
1189: -- 3. ASG standard hours and frequency
1190: -- Multiply the hours scheduled for period by normal Hourly Rate (ie. from
1191: -- pre-defined earnings, REGULAR_WAGES_RATE) pay period earnings.
1192: --
1193: -- In either case, need to find the payroll period type, let's do it upfront:
1234: -- Pay basis is hourly,
1235: -- Get hours scheduled for the current period either from:
1236: -- 1. ASG work schedule
1237: -- 2. ORG default work schedule
1238: -- 3. ASG standard hours and frequency
1239: -- Do we pass in Work Schedule from asst scl db item? Yes
1240: -- 10-JAN-1996 hparicha : We no longer assume "standard hours" represent
1241: -- a weekly figure. We also no longer use a week as
1242: -- the basis for annualization,
1236: -- 1. ASG work schedule
1237: -- 2. ORG default work schedule
1238: -- 3. ASG standard hours and frequency
1239: -- Do we pass in Work Schedule from asst scl db item? Yes
1240: -- 10-JAN-1996 hparicha : We no longer assume "standard hours" represent
1241: -- a weekly figure. We also no longer use a week as
1242: -- the basis for annualization,
1243: -- even when using work schedule - ie. need to find ACTUAL
1244: -- scheduled hours, not
1275: hr_utility.trace('v_hrs_per_range ='||to_char(v_hrs_per_range));
1276: ELSE
1277:
1278: hr_utility.trace('Asg has No Work Schedule');
1279: hr_utility.trace('Calling Standard_Hours_Worked');
1280:
1281: v_hrs_per_range := Standard_Hours_Worked( p_asst_std_hrs,
1282: p_period_start,
1283: p_period_end,
1277:
1278: hr_utility.trace('Asg has No Work Schedule');
1279: hr_utility.trace('Calling Standard_Hours_Worked');
1280:
1281: v_hrs_per_range := Standard_Hours_Worked( p_asst_std_hrs,
1282: p_period_start,
1283: p_period_end,
1284: p_asst_std_freq);
1285: hr_utility.trace('v_hrs_per_range ='||to_char(v_hrs_per_range));
2210: END Calculate_Period_Earnings;
2211:
2212: -- **********************************************************************
2213:
2214: FUNCTION standard_hours_worked(
2215: p_std_hrs in NUMBER,
2216: p_range_start in DATE,
2217: p_range_end in DATE,
2218: p_std_freq in VARCHAR2) RETURN NUMBER IS
2227: v_curr_date DATE;
2228: v_curr_day VARCHAR2(3); -- 3 char abbrev for day of wk.
2229: v_day_no NUMBER;
2230:
2231: BEGIN -- standard_hours_worked
2232:
2233: /* Init */
2234: c_wkdays_per_week := 5;
2235: c_wkdays_per_month := 20;
2239: v_curr_date := NULL;
2240: v_curr_day :=NULL;
2241:
2242: -- Check for valid range
2243: hr_utility.trace('Entered standard_hours_worked');
2244:
2245: IF p_range_start > p_range_end THEN
2246: hr_utility.trace('p_range_start greater than p_range_end');
2247: RETURN v_total_hours;
2306: v_curr_date := v_curr_date + 1;
2307: EXIT WHEN v_curr_date > p_range_end;
2308: END LOOP;
2309: hr_utility.trace(' Final v_total_hours = '||to_char(v_total_hours));
2310: hr_utility.trace(' Leaving standard_hours_worked' );
2311: --
2312: RETURN v_total_hours;
2313: --
2314: END standard_hours_worked;
2310: hr_utility.trace(' Leaving standard_hours_worked' );
2311: --
2312: RETURN v_total_hours;
2313: --
2314: END standard_hours_worked;
2315: --
2316: -- **********************************************************************
2317: FUNCTION Convert_Period_Type(
2318: p_bus_grp_id in NUMBER,
2456: v_work_sched_name,
2457: v_range_start,
2458: v_range_end);
2459:
2460: ELSE-- Hourly emp using Standard Hours on asg.
2461:
2462: hr_utility.trace(' Hourly emp using Standard Hours on asg');
2463:
2464:
2458: v_range_end);
2459:
2460: ELSE-- Hourly emp using Standard Hours on asg.
2461:
2462: hr_utility.trace(' Hourly emp using Standard Hours on asg');
2463:
2464:
2465: hr_utility.trace(' calling Standard_Hours_Worked');
2466: v_hrs_per_range := Standard_Hours_Worked( p_asg_std_hrs,
2461:
2462: hr_utility.trace(' Hourly emp using Standard Hours on asg');
2463:
2464:
2465: hr_utility.trace(' calling Standard_Hours_Worked');
2466: v_hrs_per_range := Standard_Hours_Worked( p_asg_std_hrs,
2467: v_range_start,
2468: v_range_end,
2469: p_asg_std_freq);
2462: hr_utility.trace(' Hourly emp using Standard Hours on asg');
2463:
2464:
2465: hr_utility.trace(' calling Standard_Hours_Worked');
2466: v_hrs_per_range := Standard_Hours_Worked( p_asg_std_hrs,
2467: v_range_start,
2468: v_range_end,
2469: p_asg_std_freq);
2470:
2628: v_work_sched_name,
2629: v_range_start,
2630: v_range_end);
2631:
2632: ELSE-- Hourly emp using Standard Hours on asg.
2633:
2634: hr_utility.trace(' Hourly emp using Standard Hours on asg');
2635:
2636: hr_utility.trace('calling Standard_Hours_Worked');
2630: v_range_end);
2631:
2632: ELSE-- Hourly emp using Standard Hours on asg.
2633:
2634: hr_utility.trace(' Hourly emp using Standard Hours on asg');
2635:
2636: hr_utility.trace('calling Standard_Hours_Worked');
2637:
2638: v_hrs_per_range := Standard_Hours_Worked(p_asg_std_hrs,
2632: ELSE-- Hourly emp using Standard Hours on asg.
2633:
2634: hr_utility.trace(' Hourly emp using Standard Hours on asg');
2635:
2636: hr_utility.trace('calling Standard_Hours_Worked');
2637:
2638: v_hrs_per_range := Standard_Hours_Worked(p_asg_std_hrs,
2639: v_range_start,
2640: v_range_end,
2634: hr_utility.trace(' Hourly emp using Standard Hours on asg');
2635:
2636: hr_utility.trace('calling Standard_Hours_Worked');
2637:
2638: v_hrs_per_range := Standard_Hours_Worked(p_asg_std_hrs,
2639: v_range_start,
2640: v_range_end,
2641: p_asg_std_freq);
2642:
2639: v_range_start,
2640: v_range_end,
2641: p_asg_std_freq);
2642:
2643: hr_utility.trace('returned Standard_Hours_Worked');
2644: END IF;
2645:
2646:
2647: IF v_period_hours THEN
2769: /***********************************************************
2770: The is wrapper is added to check the caluclation rule given
2771: at the payroll level. Depending upon the Rule we will the
2772: Get_Annualizing_Factor fun calls. If the rule is
2773: standard it goes to Standard Caluclation type. If the rule
2774: is Annual then it goes to ANNU rule
2775: **************************************************************/
2776: IF p_period_start_date IS NULL THEN
2777: v_stnd_start_date := sysdate;