[Home] [Help]
45: not translated. Now it is
46: getting the day number and then
47: based upon the number it deter
48: mines the day. Also changed
49: standard_hours_worked to do the
50: same.
51: 18-NOV-2002 tclewis 2666118 Changed convert_period_type
52: where we are querring number per
53: fiscal year. to change
291: /*
292: IF UPPER(p_wsched) = 'NOT ENTERED' THEN
293:
294: hr_utility.set_location('Prorate_Earnings', 7);
295: v_hours_in_range := Standard_Hours_Worked( p_asg_std_hours,
296: p_range_start_date,
297: p_range_end_date,
298: p_asg_std_freq);
299:
838: -- For Hourly pay basis:
839: -- Get hours scheduled for the current period either from:
840: -- 1. ASG work schedule
841: -- 2. ORG default work schedule
842: -- 3. ASG standard hours and frequency
843: -- Multiply the hours scheduled for period by normal Hourly Rate (ie. from
844: -- pre-defined earnings, REGULAR_WAGES_RATE) pay period earnings.
845: --
846: -- In either case, need to find the payroll period type, let's do it upfront:
882: -- Pay basis is hourly,
883: -- Get hours scheduled for the current period either from:
884: -- 1. ASG work schedule
885: -- 2. ORG default work schedule
886: -- 3. ASG standard hours and frequency
887: -- Do we pass in Work Schedule from asst scl db item? Yes
888: -- 10-JAN-1996 hparicha : We no longer assume "standard hours" represent
889: -- a weekly figure. We also no longer use a week as the basis for annualization,
890: -- even when using work schedule - ie. need to find ACTUAL scheduled hours, not
884: -- 1. ASG work schedule
885: -- 2. ORG default work schedule
886: -- 3. ASG standard hours and frequency
887: -- Do we pass in Work Schedule from asst scl db item? Yes
888: -- 10-JAN-1996 hparicha : We no longer assume "standard hours" represent
889: -- a weekly figure. We also no longer use a week as the basis for annualization,
890: -- even when using work schedule - ie. need to find ACTUAL scheduled hours, not
891: -- actual hours for a week, converted to a period figure.
892: */
928: ,v_return_message);
929: /*
930: ELSE
931:
932: v_hrs_per_range := Standard_Hours_Worked( p_asst_std_hrs,
933: p_period_start,
934: p_period_end,
935: p_asst_std_freq);
936:
1943: END Calculate_Period_Earnings;
1944:
1945: -- **********************************************************************
1946:
1947: FUNCTION standard_hours_worked(
1948: p_std_hrs in NUMBER,
1949: p_range_start in DATE,
1950: p_range_end in DATE,
1951: p_std_freq in VARCHAR2) RETURN NUMBER IS
1960: v_curr_date DATE := NULL;
1961: v_curr_day VARCHAR2(3) := NULL; -- 3 char abbrev for day of wk.
1962: v_day_no NUMBER;
1963:
1964: BEGIN -- standard_hours_worked
1965:
1966: -- Check for valid range
1967: hr_utility.set_location('standard_hours_worked', 5);
1968: IF p_range_start > p_range_end THEN
1963:
1964: BEGIN -- standard_hours_worked
1965:
1966: -- Check for valid range
1967: hr_utility.set_location('standard_hours_worked', 5);
1968: IF p_range_start > p_range_end THEN
1969: hr_utility.set_location('standard_hours_worked', 7);
1970: RETURN v_total_hours;
1971: -- hr_utility.set_message(801,'PAY_xxxx_INVALID_DATE_RANGE');
1965:
1966: -- Check for valid range
1967: hr_utility.set_location('standard_hours_worked', 5);
1968: IF p_range_start > p_range_end THEN
1969: hr_utility.set_location('standard_hours_worked', 7);
1970: RETURN v_total_hours;
1971: -- hr_utility.set_message(801,'PAY_xxxx_INVALID_DATE_RANGE');
1972: -- hr_utility.raise_error;
1973: END IF;
1984: END IF;
1985:
1986: v_curr_date := p_range_start;
1987:
1988: hr_utility.set_location('standard_hours_worked', 10);
1989:
1990: hr_utility.trace('p_range_start is'|| to_char(p_range_start));
1991: hr_utility.trace('p_range_end is'|| to_char(p_range_end));
1992: LOOP
1992: LOOP
1993:
1994: v_day_no := TO_CHAR(v_curr_date, 'D');
1995:
1996: hr_utility.set_location('standard_hours_worked', 15);
1997:
1998: IF v_day_no > 1 and v_day_no < 7 then
1999:
2000: v_total_hours := v_total_hours + v_wrkday_hours;
1997:
1998: IF v_day_no > 1 and v_day_no < 7 then
1999:
2000: v_total_hours := v_total_hours + v_wrkday_hours;
2001: hr_utility.set_location('standard_hours_worked v_total_hours = ', v_total_hours);
2002: END IF;
2003: v_curr_date := v_curr_date + 1;
2004: EXIT WHEN v_curr_date > p_range_end;
2005: END LOOP;
2006: --
2007: hr_utility.set_location('v_total_hours is', to_number(v_total_hours));
2008: RETURN v_total_hours;
2009: --
2010: END standard_hours_worked;
2011: --
2012: -- **********************************************************************
2013: --
2014: FUNCTION Convert_Period_Type(
2158: ,v_schedule
2159: ,v_return_status
2160: ,v_return_message);
2161:
2162: /* ELSE-- Hourly emp using Standard Hours on asg.
2163:
2164: hr_utility.set_location('Get_Annualizing_Factor', 23);
2165:
2166:
2163:
2164: hr_utility.set_location('Get_Annualizing_Factor', 23);
2165:
2166:
2167: v_hrs_per_range := Standard_Hours_Worked( p_asg_std_hrs,
2168: v_range_start,
2169: v_range_end,
2170: p_asg_std_freq);
2171:
2347: ,v_schedule
2348: ,v_return_status
2349: ,v_return_message);
2350:
2351: /* ELSE-- Hourly emp using Standard Hours on asg.
2352:
2353: hr_utility.set_location('Get_Annualizing_Factor', 23);
2354:
2355:
2352:
2353: hr_utility.set_location('Get_Annualizing_Factor', 23);
2354:
2355:
2356: v_hrs_per_range := Standard_Hours_Worked( p_asg_std_hrs,
2357: v_range_start,
2358: v_range_end,
2359: p_asg_std_freq);
2360: