APPS.PAY_CALC_HOURS_WORKED dependencies on STANDARD

Line 30: FUNCTION standard_hours_worked(

26: */
27:
28: g_legislation_code VARCHAR2(10);
29:
30: FUNCTION standard_hours_worked(
31: p_std_hrs in NUMBER,
32: p_range_start in DATE,
33: p_range_end in DATE,
34: p_std_freq in VARCHAR2) RETURN NUMBER IS

Line 47: BEGIN -- standard_hours_worked

43: v_curr_date DATE;
44: v_curr_day VARCHAR2(3); -- 3 char abbrev for day of wk.
45: v_day_no NUMBER;
46:
47: BEGIN -- standard_hours_worked
48:
49: /* Init */
50: c_wkdays_per_week := 5;
51: c_wkdays_per_month := 20;

Line 59: hr_utility.trace('Entered standard_hours_worked');

55: v_curr_date := NULL;
56: v_curr_day :=NULL;
57:
58: -- Check for valid range
59: hr_utility.trace('Entered standard_hours_worked');
60:
61: IF p_range_start > p_range_end THEN
62: hr_utility.trace('p_range_start greater than p_range_end');
63: RETURN v_total_hours;

Line 126: hr_utility.trace(' Leaving standard_hours_worked' );

122: v_curr_date := v_curr_date + 1;
123: EXIT WHEN v_curr_date > p_range_end;
124: END LOOP;
125: hr_utility.trace(' Final v_total_hours = '||to_char(v_total_hours));
126: hr_utility.trace(' Leaving standard_hours_worked' );
127: --
128: RETURN v_total_hours;
129: --
130: END standard_hours_worked;

Line 130: END standard_hours_worked;

126: hr_utility.trace(' Leaving standard_hours_worked' );
127: --
128: RETURN v_total_hours;
129: --
130: END standard_hours_worked;
131:
132:
133: FUNCTION calculate_actual_hours_worked
134: (assignment_action_id IN number --Context

Line 256: /* Calculate hours worked based on standard conditions if the actual hours

252: NULL;
253: END;
254: END IF;
255:
256: /* Calculate hours worked based on standard conditions if the actual hours
257: worked are not available from either ATG work schedule or work schedule
258: at assignment/org level */
259:
260: IF NOT l_work_schedule_found THEN

Line 261: hr_utility.trace('Calculating hours based on Standard conditions ');

257: worked are not available from either ATG work schedule or work schedule
258: at assignment/org level */
259:
260: IF NOT l_work_schedule_found THEN
261: hr_utility.trace('Calculating hours based on Standard conditions ');
262: hr_utility.trace( 'Assignment Id '||assignment_id);
263: hr_utility.trace( 'date_earned '||date_earned);
264: OPEN get_asg_hours_freq(date_earned,assignment_id);
265: FETCH get_asg_hours_freq

Line 273: l_total_hours := standard_hours_worked(l_normal_hours

269: hr_utility.trace( 'l_asg_frequency '||l_asg_frequency);
270: hr_utility.trace( 'l_normal_hours '||l_normal_hours);
271:
272: IF l_asg_frequency IS NOT NULL and l_normal_hours IS NOT NULL THEN
273: l_total_hours := standard_hours_worked(l_normal_hours
274: ,p_period_start_date
275: ,p_period_end_date
276: ,l_asg_frequency);
277: return l_total_hours;