eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_CALC_HOURS_WORKED dependencies on HR_UTILITY

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 62: hr_utility.trace('p_range_start greater than p_range_end');

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;
64: -- hr_utility.set_message(801,'PAY_xxxx_INVALID_DATE_RANGE');
65: -- hr_utility.raise_error;
66: END IF;

Line 64: -- hr_utility.set_message(801,'PAY_xxxx_INVALID_DATE_RANGE');

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;
64: -- hr_utility.set_message(801,'PAY_xxxx_INVALID_DATE_RANGE');
65: -- hr_utility.raise_error;
66: END IF;
67: --
68:

Line 65: -- hr_utility.raise_error;

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;
64: -- hr_utility.set_message(801,'PAY_xxxx_INVALID_DATE_RANGE');
65: -- hr_utility.raise_error;
66: END IF;
67: --
68:
69: IF UPPER(p_std_freq) = 'WEEK' THEN

Line 70: hr_utility.trace('p_std_freq = WEEK ');

66: END IF;
67: --
68:
69: IF UPPER(p_std_freq) = 'WEEK' THEN
70: hr_utility.trace('p_std_freq = WEEK ');
71:
72: v_wrkday_hours := p_std_hrs / c_wkdays_per_week;
73:
74: hr_utility.trace('p_std_hrs ='||to_number(p_std_hrs));

Line 74: hr_utility.trace('p_std_hrs ='||to_number(p_std_hrs));

70: hr_utility.trace('p_std_freq = WEEK ');
71:
72: v_wrkday_hours := p_std_hrs / c_wkdays_per_week;
73:
74: hr_utility.trace('p_std_hrs ='||to_number(p_std_hrs));
75: hr_utility.trace('c_wkdays_per_week ='||to_number(c_wkdays_per_week));
76: hr_utility.trace('v_wrkday_hours ='||to_number(v_wrkday_hours));
77:
78: ELSIF UPPER(p_std_freq) = 'MONTH' THEN

Line 75: hr_utility.trace('c_wkdays_per_week ='||to_number(c_wkdays_per_week));

71:
72: v_wrkday_hours := p_std_hrs / c_wkdays_per_week;
73:
74: hr_utility.trace('p_std_hrs ='||to_number(p_std_hrs));
75: hr_utility.trace('c_wkdays_per_week ='||to_number(c_wkdays_per_week));
76: hr_utility.trace('v_wrkday_hours ='||to_number(v_wrkday_hours));
77:
78: ELSIF UPPER(p_std_freq) = 'MONTH' THEN
79:

Line 76: hr_utility.trace('v_wrkday_hours ='||to_number(v_wrkday_hours));

72: v_wrkday_hours := p_std_hrs / c_wkdays_per_week;
73:
74: hr_utility.trace('p_std_hrs ='||to_number(p_std_hrs));
75: hr_utility.trace('c_wkdays_per_week ='||to_number(c_wkdays_per_week));
76: hr_utility.trace('v_wrkday_hours ='||to_number(v_wrkday_hours));
77:
78: ELSIF UPPER(p_std_freq) = 'MONTH' THEN
79:
80: hr_utility.trace('p_std_freq = MONTH ');

Line 80: hr_utility.trace('p_std_freq = MONTH ');

76: hr_utility.trace('v_wrkday_hours ='||to_number(v_wrkday_hours));
77:
78: ELSIF UPPER(p_std_freq) = 'MONTH' THEN
79:
80: hr_utility.trace('p_std_freq = MONTH ');
81:
82: v_wrkday_hours := p_std_hrs / c_wkdays_per_month;
83:
84:

Line 85: hr_utility.trace('p_std_hrs ='||to_number(p_std_hrs));

81:
82: v_wrkday_hours := p_std_hrs / c_wkdays_per_month;
83:
84:
85: hr_utility.trace('p_std_hrs ='||to_number(p_std_hrs));
86: hr_utility.trace('c_wkdays_per_month ='||to_number(c_wkdays_per_month));
87: hr_utility.trace('v_wrkday_hours ='||to_number(v_wrkday_hours));
88:
89: ELSIF UPPER(p_std_freq) = 'YEAR' THEN

Line 86: hr_utility.trace('c_wkdays_per_month ='||to_number(c_wkdays_per_month));

82: v_wrkday_hours := p_std_hrs / c_wkdays_per_month;
83:
84:
85: hr_utility.trace('p_std_hrs ='||to_number(p_std_hrs));
86: hr_utility.trace('c_wkdays_per_month ='||to_number(c_wkdays_per_month));
87: hr_utility.trace('v_wrkday_hours ='||to_number(v_wrkday_hours));
88:
89: ELSIF UPPER(p_std_freq) = 'YEAR' THEN
90:

Line 87: hr_utility.trace('v_wrkday_hours ='||to_number(v_wrkday_hours));

83:
84:
85: hr_utility.trace('p_std_hrs ='||to_number(p_std_hrs));
86: hr_utility.trace('c_wkdays_per_month ='||to_number(c_wkdays_per_month));
87: hr_utility.trace('v_wrkday_hours ='||to_number(v_wrkday_hours));
88:
89: ELSIF UPPER(p_std_freq) = 'YEAR' THEN
90:
91: hr_utility.trace('p_std_freq = YEAR ');

Line 91: hr_utility.trace('p_std_freq = YEAR ');

87: hr_utility.trace('v_wrkday_hours ='||to_number(v_wrkday_hours));
88:
89: ELSIF UPPER(p_std_freq) = 'YEAR' THEN
90:
91: hr_utility.trace('p_std_freq = YEAR ');
92: v_wrkday_hours := p_std_hrs / c_wkdays_per_year;
93:
94: hr_utility.trace('p_std_hrs ='||to_number(p_std_hrs));
95: hr_utility.trace('c_wkdays_per_year ='||to_number(c_wkdays_per_year));

Line 94: hr_utility.trace('p_std_hrs ='||to_number(p_std_hrs));

90:
91: hr_utility.trace('p_std_freq = YEAR ');
92: v_wrkday_hours := p_std_hrs / c_wkdays_per_year;
93:
94: hr_utility.trace('p_std_hrs ='||to_number(p_std_hrs));
95: hr_utility.trace('c_wkdays_per_year ='||to_number(c_wkdays_per_year));
96: hr_utility.trace('v_wrkday_hours ='||to_number(v_wrkday_hours));
97:
98: ELSE

Line 95: hr_utility.trace('c_wkdays_per_year ='||to_number(c_wkdays_per_year));

91: hr_utility.trace('p_std_freq = YEAR ');
92: v_wrkday_hours := p_std_hrs / c_wkdays_per_year;
93:
94: hr_utility.trace('p_std_hrs ='||to_number(p_std_hrs));
95: hr_utility.trace('c_wkdays_per_year ='||to_number(c_wkdays_per_year));
96: hr_utility.trace('v_wrkday_hours ='||to_number(v_wrkday_hours));
97:
98: ELSE
99: hr_utility.trace('p_std_freq in ELSE ');

Line 96: hr_utility.trace('v_wrkday_hours ='||to_number(v_wrkday_hours));

92: v_wrkday_hours := p_std_hrs / c_wkdays_per_year;
93:
94: hr_utility.trace('p_std_hrs ='||to_number(p_std_hrs));
95: hr_utility.trace('c_wkdays_per_year ='||to_number(c_wkdays_per_year));
96: hr_utility.trace('v_wrkday_hours ='||to_number(v_wrkday_hours));
97:
98: ELSE
99: hr_utility.trace('p_std_freq in ELSE ');
100: v_wrkday_hours := p_std_hrs;

Line 99: hr_utility.trace('p_std_freq in ELSE ');

95: hr_utility.trace('c_wkdays_per_year ='||to_number(c_wkdays_per_year));
96: hr_utility.trace('v_wrkday_hours ='||to_number(v_wrkday_hours));
97:
98: ELSE
99: hr_utility.trace('p_std_freq in ELSE ');
100: v_wrkday_hours := p_std_hrs;
101: END IF;
102:
103: v_curr_date := p_range_start;

Line 105: hr_utility.trace('v_curr_date is range start'||to_char(v_curr_date));

101: END IF;
102:
103: v_curr_date := p_range_start;
104:
105: hr_utility.trace('v_curr_date is range start'||to_char(v_curr_date));
106:
107:
108: LOOP
109:

Line 118: hr_utility.trace(' v_day_no = '||to_char(v_day_no));

114:
115:
116: v_total_hours := nvl(v_total_hours,0) + v_wrkday_hours;
117:
118: hr_utility.trace(' v_day_no = '||to_char(v_day_no));
119: hr_utility.trace(' v_total_hours = '||to_char(v_total_hours));
120: END IF;
121:
122: v_curr_date := v_curr_date + 1;

Line 119: hr_utility.trace(' v_total_hours = '||to_char(v_total_hours));

115:
116: v_total_hours := nvl(v_total_hours,0) + v_wrkday_hours;
117:
118: hr_utility.trace(' v_day_no = '||to_char(v_day_no));
119: hr_utility.trace(' v_total_hours = '||to_char(v_total_hours));
120: END IF;
121:
122: v_curr_date := v_curr_date + 1;
123: EXIT WHEN v_curr_date > p_range_end;

Line 125: hr_utility.trace(' Final v_total_hours = '||to_char(v_total_hours));

121:
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: --

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 177: hr_utility.trace( 'date_earned '||date_earned);

173: BEGIN
174: l_work_schedule_found := FALSE;
175: l_total_hours := 0;
176:
177: hr_utility.trace( 'date_earned '||date_earned);
178: hr_utility.trace('assignment_action_id=' || assignment_action_id);
179: hr_utility.trace('assignment_id=' || assignment_id);
180: hr_utility.trace('business_group_id=' || business_group_id);
181: hr_utility.trace('element_entry_id=' || element_entry_id);

Line 178: hr_utility.trace('assignment_action_id=' || assignment_action_id);

174: l_work_schedule_found := FALSE;
175: l_total_hours := 0;
176:
177: hr_utility.trace( 'date_earned '||date_earned);
178: hr_utility.trace('assignment_action_id=' || assignment_action_id);
179: hr_utility.trace('assignment_id=' || assignment_id);
180: hr_utility.trace('business_group_id=' || business_group_id);
181: hr_utility.trace('element_entry_id=' || element_entry_id);
182: hr_utility.trace( 'date_earned '||date_earned);

Line 179: hr_utility.trace('assignment_id=' || assignment_id);

175: l_total_hours := 0;
176:
177: hr_utility.trace( 'date_earned '||date_earned);
178: hr_utility.trace('assignment_action_id=' || assignment_action_id);
179: hr_utility.trace('assignment_id=' || assignment_id);
180: hr_utility.trace('business_group_id=' || business_group_id);
181: hr_utility.trace('element_entry_id=' || element_entry_id);
182: hr_utility.trace( 'date_earned '||date_earned);
183: hr_utility.trace('p_period_start_date=' || p_period_start_date);

Line 180: hr_utility.trace('business_group_id=' || business_group_id);

176:
177: hr_utility.trace( 'date_earned '||date_earned);
178: hr_utility.trace('assignment_action_id=' || assignment_action_id);
179: hr_utility.trace('assignment_id=' || assignment_id);
180: hr_utility.trace('business_group_id=' || business_group_id);
181: hr_utility.trace('element_entry_id=' || element_entry_id);
182: hr_utility.trace( 'date_earned '||date_earned);
183: hr_utility.trace('p_period_start_date=' || p_period_start_date);
184: hr_utility.trace('p_period_end_date=' || p_period_end_date);

Line 181: hr_utility.trace('element_entry_id=' || element_entry_id);

177: hr_utility.trace( 'date_earned '||date_earned);
178: hr_utility.trace('assignment_action_id=' || assignment_action_id);
179: hr_utility.trace('assignment_id=' || assignment_id);
180: hr_utility.trace('business_group_id=' || business_group_id);
181: hr_utility.trace('element_entry_id=' || element_entry_id);
182: hr_utility.trace( 'date_earned '||date_earned);
183: hr_utility.trace('p_period_start_date=' || p_period_start_date);
184: hr_utility.trace('p_period_end_date=' || p_period_end_date);
185: hr_utility.trace('p_legislation_code=' || p_legislation_code);

Line 182: hr_utility.trace( 'date_earned '||date_earned);

178: hr_utility.trace('assignment_action_id=' || assignment_action_id);
179: hr_utility.trace('assignment_id=' || assignment_id);
180: hr_utility.trace('business_group_id=' || business_group_id);
181: hr_utility.trace('element_entry_id=' || element_entry_id);
182: hr_utility.trace( 'date_earned '||date_earned);
183: hr_utility.trace('p_period_start_date=' || p_period_start_date);
184: hr_utility.trace('p_period_end_date=' || p_period_end_date);
185: hr_utility.trace('p_legislation_code=' || p_legislation_code);
186: hr_utility.trace('p_schedule_category=' || p_schedule_category);

Line 183: hr_utility.trace('p_period_start_date=' || p_period_start_date);

179: hr_utility.trace('assignment_id=' || assignment_id);
180: hr_utility.trace('business_group_id=' || business_group_id);
181: hr_utility.trace('element_entry_id=' || element_entry_id);
182: hr_utility.trace( 'date_earned '||date_earned);
183: hr_utility.trace('p_period_start_date=' || p_period_start_date);
184: hr_utility.trace('p_period_end_date=' || p_period_end_date);
185: hr_utility.trace('p_legislation_code=' || p_legislation_code);
186: hr_utility.trace('p_schedule_category=' || p_schedule_category);
187: hr_utility.trace('p_schedule_source=' || p_schedule_source);

Line 184: hr_utility.trace('p_period_end_date=' || p_period_end_date);

180: hr_utility.trace('business_group_id=' || business_group_id);
181: hr_utility.trace('element_entry_id=' || element_entry_id);
182: hr_utility.trace( 'date_earned '||date_earned);
183: hr_utility.trace('p_period_start_date=' || p_period_start_date);
184: hr_utility.trace('p_period_end_date=' || p_period_end_date);
185: hr_utility.trace('p_legislation_code=' || p_legislation_code);
186: hr_utility.trace('p_schedule_category=' || p_schedule_category);
187: hr_utility.trace('p_schedule_source=' || p_schedule_source);
188: hr_utility.trace('p_include_exceptions=' || p_include_exceptions);

Line 185: hr_utility.trace('p_legislation_code=' || p_legislation_code);

181: hr_utility.trace('element_entry_id=' || element_entry_id);
182: hr_utility.trace( 'date_earned '||date_earned);
183: hr_utility.trace('p_period_start_date=' || p_period_start_date);
184: hr_utility.trace('p_period_end_date=' || p_period_end_date);
185: hr_utility.trace('p_legislation_code=' || p_legislation_code);
186: hr_utility.trace('p_schedule_category=' || p_schedule_category);
187: hr_utility.trace('p_schedule_source=' || p_schedule_source);
188: hr_utility.trace('p_include_exceptions=' || p_include_exceptions);
189: hr_utility.trace('p_busy_tentative_as=' || p_busy_tentative_as);

Line 186: hr_utility.trace('p_schedule_category=' || p_schedule_category);

182: hr_utility.trace( 'date_earned '||date_earned);
183: hr_utility.trace('p_period_start_date=' || p_period_start_date);
184: hr_utility.trace('p_period_end_date=' || p_period_end_date);
185: hr_utility.trace('p_legislation_code=' || p_legislation_code);
186: hr_utility.trace('p_schedule_category=' || p_schedule_category);
187: hr_utility.trace('p_schedule_source=' || p_schedule_source);
188: hr_utility.trace('p_include_exceptions=' || p_include_exceptions);
189: hr_utility.trace('p_busy_tentative_as=' || p_busy_tentative_as);
190: hr_utility.trace('p_schedule=' || p_schedule);

Line 187: hr_utility.trace('p_schedule_source=' || p_schedule_source);

183: hr_utility.trace('p_period_start_date=' || p_period_start_date);
184: hr_utility.trace('p_period_end_date=' || p_period_end_date);
185: hr_utility.trace('p_legislation_code=' || p_legislation_code);
186: hr_utility.trace('p_schedule_category=' || p_schedule_category);
187: hr_utility.trace('p_schedule_source=' || p_schedule_source);
188: hr_utility.trace('p_include_exceptions=' || p_include_exceptions);
189: hr_utility.trace('p_busy_tentative_as=' || p_busy_tentative_as);
190: hr_utility.trace('p_schedule=' || p_schedule);
191:

Line 188: hr_utility.trace('p_include_exceptions=' || p_include_exceptions);

184: hr_utility.trace('p_period_end_date=' || p_period_end_date);
185: hr_utility.trace('p_legislation_code=' || p_legislation_code);
186: hr_utility.trace('p_schedule_category=' || p_schedule_category);
187: hr_utility.trace('p_schedule_source=' || p_schedule_source);
188: hr_utility.trace('p_include_exceptions=' || p_include_exceptions);
189: hr_utility.trace('p_busy_tentative_as=' || p_busy_tentative_as);
190: hr_utility.trace('p_schedule=' || p_schedule);
191:
192:

Line 189: hr_utility.trace('p_busy_tentative_as=' || p_busy_tentative_as);

185: hr_utility.trace('p_legislation_code=' || p_legislation_code);
186: hr_utility.trace('p_schedule_category=' || p_schedule_category);
187: hr_utility.trace('p_schedule_source=' || p_schedule_source);
188: hr_utility.trace('p_include_exceptions=' || p_include_exceptions);
189: hr_utility.trace('p_busy_tentative_as=' || p_busy_tentative_as);
190: hr_utility.trace('p_schedule=' || p_schedule);
191:
192:
193: IF (p_legislation_code IS NULL) AND (g_legislation_code IS NULL) THEN

Line 190: hr_utility.trace('p_schedule=' || p_schedule);

186: hr_utility.trace('p_schedule_category=' || p_schedule_category);
187: hr_utility.trace('p_schedule_source=' || p_schedule_source);
188: hr_utility.trace('p_include_exceptions=' || p_include_exceptions);
189: hr_utility.trace('p_busy_tentative_as=' || p_busy_tentative_as);
190: hr_utility.trace('p_schedule=' || p_schedule);
191:
192:
193: IF (p_legislation_code IS NULL) AND (g_legislation_code IS NULL) THEN
194: OPEN get_leg_code(business_group_id);

Line 222: hr_utility.trace( 'getting work schedule from SCL ');

218: */
219:
220: IF NOT l_work_schedule_found THEN
221: BEGIN
222: hr_utility.trace( 'getting work schedule from SCL ');
223: lv_wk_sch_found := 'FALSE';
224: EXECUTE IMMEDIATE 'BEGIN :1 := PAY_'||g_legislation_code||
225: '_RULES.Work_Schedule_Total_Hours(:2,:3,:4,:5,:6,:7,:8,:9); END;'
226: USING OUT l_total_hours,

Line 232: hr_utility.trace( 'work schedule found from SCL ');

228: ,IN date_earned,IN p_period_start_date,IN p_period_end_date,IN OUT lv_wk_sch_found;
229:
230: /*
231: IF l_total_hours > 0 THEN
232: hr_utility.trace( 'work schedule found from SCL ');
233: l_work_schedule_found := TRUE;
234: return l_total_hours;
235: END IF;
236: */

Line 245: hr_utility.trace( 'work schedule found from SCL ');

241: -- total hours returned by work schedule may be zero for the FLSA
242: -- or pro ration period.
243:
244: IF lv_wk_sch_found = 'TRUE' THEN
245: hr_utility.trace( 'work schedule found from SCL ');
246: l_work_schedule_found := TRUE;
247: return l_total_hours;
248: END IF;
249:

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 262: hr_utility.trace( 'Assignment Id '||assignment_id);

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
266: INTO l_asg_frequency, l_normal_hours;

Line 263: hr_utility.trace( 'date_earned '||date_earned);

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
266: INTO l_asg_frequency, l_normal_hours;
267: CLOSE get_asg_hours_freq;

Line 269: hr_utility.trace( 'l_asg_frequency '||l_asg_frequency);

265: FETCH get_asg_hours_freq
266: INTO l_asg_frequency, l_normal_hours;
267: CLOSE get_asg_hours_freq;
268:
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

Line 270: hr_utility.trace( 'l_normal_hours '||l_normal_hours);

266: INTO l_asg_frequency, l_normal_hours;
267: CLOSE get_asg_hours_freq;
268:
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