[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
285: /*
286: IF UPPER(p_wsched) = 'NOT ENTERED' THEN
287:
288: hr_utility.set_location('Prorate_Earnings', 7);
289: v_hours_in_range := Standard_Hours_Worked( p_asg_std_hours,
290: p_range_start_date,
291: p_range_end_date,
292: p_asg_std_freq);
293:
832: -- For Hourly pay basis:
833: -- Get hours scheduled for the current period either from:
834: -- 1. ASG work schedule
835: -- 2. ORG default work schedule
836: -- 3. ASG standard hours and frequency
837: -- Multiply the hours scheduled for period by normal Hourly Rate (ie. from
838: -- pre-defined earnings, REGULAR_WAGES_RATE) pay period earnings.
839: --
840: -- In either case, need to find the payroll period type, let's do it upfront:
876: -- Pay basis is hourly,
877: -- Get hours scheduled for the current period either from:
878: -- 1. ASG work schedule
879: -- 2. ORG default work schedule
880: -- 3. ASG standard hours and frequency
881: -- Do we pass in Work Schedule from asst scl db item? Yes
882: -- 10-JAN-1996 hparicha : We no longer assume "standard hours" represent
883: -- a weekly figure. We also no longer use a week as the basis for annualization,
884: -- even when using work schedule - ie. need to find ACTUAL scheduled hours, not
878: -- 1. ASG work schedule
879: -- 2. ORG default work schedule
880: -- 3. ASG standard hours and frequency
881: -- Do we pass in Work Schedule from asst scl db item? Yes
882: -- 10-JAN-1996 hparicha : We no longer assume "standard hours" represent
883: -- a weekly figure. We also no longer use a week as the basis for annualization,
884: -- even when using work schedule - ie. need to find ACTUAL scheduled hours, not
885: -- actual hours for a week, converted to a period figure.
886: */
922: ,v_return_message);
923: /*
924: ELSE
925:
926: v_hrs_per_range := Standard_Hours_Worked( p_asst_std_hrs,
927: p_period_start,
928: p_period_end,
929: p_asst_std_freq);
930:
1906: END Calculate_Period_Earnings;
1907:
1908: -- **********************************************************************
1909:
1910: FUNCTION standard_hours_worked(
1911: p_std_hrs in NUMBER,
1912: p_range_start in DATE,
1913: p_range_end in DATE,
1914: p_std_freq in VARCHAR2) RETURN NUMBER IS
1923: v_curr_date DATE := NULL;
1924: v_curr_day VARCHAR2(3) := NULL; -- 3 char abbrev for day of wk.
1925: v_day_no NUMBER;
1926:
1927: BEGIN -- standard_hours_worked
1928:
1929: -- Check for valid range
1930: hr_utility.set_location('standard_hours_worked', 5);
1931: IF p_range_start > p_range_end THEN
1926:
1927: BEGIN -- standard_hours_worked
1928:
1929: -- Check for valid range
1930: hr_utility.set_location('standard_hours_worked', 5);
1931: IF p_range_start > p_range_end THEN
1932: hr_utility.set_location('standard_hours_worked', 7);
1933: RETURN v_total_hours;
1934: -- hr_utility.set_message(801,'PAY_xxxx_INVALID_DATE_RANGE');
1928:
1929: -- Check for valid range
1930: hr_utility.set_location('standard_hours_worked', 5);
1931: IF p_range_start > p_range_end THEN
1932: hr_utility.set_location('standard_hours_worked', 7);
1933: RETURN v_total_hours;
1934: -- hr_utility.set_message(801,'PAY_xxxx_INVALID_DATE_RANGE');
1935: -- hr_utility.raise_error;
1936: END IF;
1947: END IF;
1948:
1949: v_curr_date := p_range_start;
1950:
1951: hr_utility.set_location('standard_hours_worked', 10);
1952:
1953: hr_utility.trace('p_range_start is'|| to_char(p_range_start));
1954: hr_utility.trace('p_range_end is'|| to_char(p_range_end));
1955: LOOP
1955: LOOP
1956:
1957: v_day_no := TO_CHAR(v_curr_date, 'D');
1958:
1959: hr_utility.set_location('standard_hours_worked', 15);
1960:
1961: IF v_day_no > 1 and v_day_no < 7 then
1962:
1963: v_total_hours := v_total_hours + v_wrkday_hours;
1960:
1961: IF v_day_no > 1 and v_day_no < 7 then
1962:
1963: v_total_hours := v_total_hours + v_wrkday_hours;
1964: hr_utility.set_location('standard_hours_worked v_total_hours = ', v_total_hours);
1965: END IF;
1966: v_curr_date := v_curr_date + 1;
1967: EXIT WHEN v_curr_date > p_range_end;
1968: END LOOP;
1969: --
1970: hr_utility.set_location('v_total_hours is', to_number(v_total_hours));
1971: RETURN v_total_hours;
1972: --
1973: END standard_hours_worked;
1974: --
1975: -- **********************************************************************
1976: --
1977: FUNCTION Convert_Period_Type(
2121: ,v_schedule
2122: ,v_return_status
2123: ,v_return_message);
2124:
2125: /* ELSE-- Hourly emp using Standard Hours on asg.
2126:
2127: hr_utility.set_location('Get_Annualizing_Factor', 23);
2128:
2129:
2126:
2127: hr_utility.set_location('Get_Annualizing_Factor', 23);
2128:
2129:
2130: v_hrs_per_range := Standard_Hours_Worked( p_asg_std_hrs,
2131: v_range_start,
2132: v_range_end,
2133: p_asg_std_freq);
2134:
2310: ,v_schedule
2311: ,v_return_status
2312: ,v_return_message);
2313:
2314: /* ELSE-- Hourly emp using Standard Hours on asg.
2315:
2316: hr_utility.set_location('Get_Annualizing_Factor', 23);
2317:
2318:
2315:
2316: hr_utility.set_location('Get_Annualizing_Factor', 23);
2317:
2318:
2319: v_hrs_per_range := Standard_Hours_Worked( p_asg_std_hrs,
2320: v_range_start,
2321: v_range_end,
2322: p_asg_std_freq);
2323: