APPS.PAY_CALC_HOURS_WORKED dependencies on STANDARD

Line 28: FUNCTION standard_hours_worked(

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

Line 45: BEGIN -- standard_hours_worked

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

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

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

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

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

Line 128: END standard_hours_worked;

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

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

234: null;
235: END;
236: END IF;
237:
238: /* Calculate hours worked based on standard conditions if the actual hours
239: worked are not available from either ATG work schedule or work schedule
240: at assignment/org level */
241:
242: IF NOT l_work_schedule_found THEN

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

239: worked are not available from either ATG work schedule or work schedule
240: at assignment/org level */
241:
242: IF NOT l_work_schedule_found THEN
243: hr_utility.trace('Calculating hours based on Standard conditions ');
244: hr_utility.trace( 'Assignment Id '||assignment_id);
245: hr_utility.trace( 'date_earned '||date_earned);
246: OPEN get_asg_hours_freq(date_earned,assignment_id);
247: FETCH get_asg_hours_freq

Line 255: l_total_hours := standard_hours_worked(l_normal_hours

251: hr_utility.trace( 'l_asg_frequency '||l_asg_frequency);
252: hr_utility.trace( 'l_normal_hours '||l_normal_hours);
253:
254: IF l_asg_frequency IS NOT NULL and l_normal_hours IS NOT NULL THEN
255: l_total_hours := standard_hours_worked(l_normal_hours
256: ,p_period_start_date
257: ,p_period_end_date
258: ,l_asg_frequency);
259: return l_total_hours;