[Home] [Help]
3: --
4: -- Package Variables
5: --
6:
7: g_debug boolean := hr_utility.debug_enabled;
8:
9: TYPE r_message_record IS RECORD ( name fnd_new_messages.message_name%TYPE,
10: token_name varchar2(240),
11: token_value varchar2(4000),
24:
25: deletedFlag boolean := true;
26:
27: BEGIN
28: g_debug := hr_utility.debug_enabled;
29:
30: if g_debug then
31: l_proc := g_package||'get_timecard_info';
32: hr_utility.set_location('Entering '||l_proc, 10);
28: g_debug := hr_utility.debug_enabled;
29:
30: if g_debug then
31: l_proc := g_package||'get_timecard_info';
32: hr_utility.set_location('Entering '||l_proc, 10);
33: end if;
34:
35: l_tbb_index := p_time_building_blocks.FIRST;
36:
39:
40: IF p_time_building_blocks(l_tbb_index).SCOPE = 'TIMECARD'
41: THEN
42: if g_debug then
43: hr_utility.trace('************* Timecard details *****************');
44: hr_utility.trace('timecard bb id is '||to_char(p_time_building_blocks(l_tbb_index).time_building_block_id));
45: hr_utility.trace('timecard ovn is '||to_char(p_time_building_blocks(l_tbb_index).object_version_number));
46: hr_utility.trace('start time is '||to_char(p_time_building_blocks(l_tbb_index).start_time, 'dd-mon-yyyy hh24:mi:ss'));
47: hr_utility.trace('stop time is ' ||to_char(p_time_building_blocks(l_tbb_index).stop_time, 'dd-mon-yyyy hh24:mi:ss'));
40: IF p_time_building_blocks(l_tbb_index).SCOPE = 'TIMECARD'
41: THEN
42: if g_debug then
43: hr_utility.trace('************* Timecard details *****************');
44: hr_utility.trace('timecard bb id is '||to_char(p_time_building_blocks(l_tbb_index).time_building_block_id));
45: hr_utility.trace('timecard ovn is '||to_char(p_time_building_blocks(l_tbb_index).object_version_number));
46: hr_utility.trace('start time is '||to_char(p_time_building_blocks(l_tbb_index).start_time, 'dd-mon-yyyy hh24:mi:ss'));
47: hr_utility.trace('stop time is ' ||to_char(p_time_building_blocks(l_tbb_index).stop_time, 'dd-mon-yyyy hh24:mi:ss'));
48: hr_utility.trace('resource id is '||to_char(p_time_building_blocks(l_tbb_index).resource_id));
41: THEN
42: if g_debug then
43: hr_utility.trace('************* Timecard details *****************');
44: hr_utility.trace('timecard bb id is '||to_char(p_time_building_blocks(l_tbb_index).time_building_block_id));
45: hr_utility.trace('timecard ovn is '||to_char(p_time_building_blocks(l_tbb_index).object_version_number));
46: hr_utility.trace('start time is '||to_char(p_time_building_blocks(l_tbb_index).start_time, 'dd-mon-yyyy hh24:mi:ss'));
47: hr_utility.trace('stop time is ' ||to_char(p_time_building_blocks(l_tbb_index).stop_time, 'dd-mon-yyyy hh24:mi:ss'));
48: hr_utility.trace('resource id is '||to_char(p_time_building_blocks(l_tbb_index).resource_id));
49: hr_utility.trace('************************************************');
42: if g_debug then
43: hr_utility.trace('************* Timecard details *****************');
44: hr_utility.trace('timecard bb id is '||to_char(p_time_building_blocks(l_tbb_index).time_building_block_id));
45: hr_utility.trace('timecard ovn is '||to_char(p_time_building_blocks(l_tbb_index).object_version_number));
46: hr_utility.trace('start time is '||to_char(p_time_building_blocks(l_tbb_index).start_time, 'dd-mon-yyyy hh24:mi:ss'));
47: hr_utility.trace('stop time is ' ||to_char(p_time_building_blocks(l_tbb_index).stop_time, 'dd-mon-yyyy hh24:mi:ss'));
48: hr_utility.trace('resource id is '||to_char(p_time_building_blocks(l_tbb_index).resource_id));
49: hr_utility.trace('************************************************');
50: end if;
43: hr_utility.trace('************* Timecard details *****************');
44: hr_utility.trace('timecard bb id is '||to_char(p_time_building_blocks(l_tbb_index).time_building_block_id));
45: hr_utility.trace('timecard ovn is '||to_char(p_time_building_blocks(l_tbb_index).object_version_number));
46: hr_utility.trace('start time is '||to_char(p_time_building_blocks(l_tbb_index).start_time, 'dd-mon-yyyy hh24:mi:ss'));
47: hr_utility.trace('stop time is ' ||to_char(p_time_building_blocks(l_tbb_index).stop_time, 'dd-mon-yyyy hh24:mi:ss'));
48: hr_utility.trace('resource id is '||to_char(p_time_building_blocks(l_tbb_index).resource_id));
49: hr_utility.trace('************************************************');
50: end if;
51:
44: hr_utility.trace('timecard bb id is '||to_char(p_time_building_blocks(l_tbb_index).time_building_block_id));
45: hr_utility.trace('timecard ovn is '||to_char(p_time_building_blocks(l_tbb_index).object_version_number));
46: hr_utility.trace('start time is '||to_char(p_time_building_blocks(l_tbb_index).start_time, 'dd-mon-yyyy hh24:mi:ss'));
47: hr_utility.trace('stop time is ' ||to_char(p_time_building_blocks(l_tbb_index).stop_time, 'dd-mon-yyyy hh24:mi:ss'));
48: hr_utility.trace('resource id is '||to_char(p_time_building_blocks(l_tbb_index).resource_id));
49: hr_utility.trace('************************************************');
50: end if;
51:
52: p_timecard_rec.start_date := p_time_building_blocks(l_tbb_index).start_time;
45: hr_utility.trace('timecard ovn is '||to_char(p_time_building_blocks(l_tbb_index).object_version_number));
46: hr_utility.trace('start time is '||to_char(p_time_building_blocks(l_tbb_index).start_time, 'dd-mon-yyyy hh24:mi:ss'));
47: hr_utility.trace('stop time is ' ||to_char(p_time_building_blocks(l_tbb_index).stop_time, 'dd-mon-yyyy hh24:mi:ss'));
48: hr_utility.trace('resource id is '||to_char(p_time_building_blocks(l_tbb_index).resource_id));
49: hr_utility.trace('************************************************');
50: end if;
51:
52: p_timecard_rec.start_date := p_time_building_blocks(l_tbb_index).start_time;
53: p_timecard_rec.end_date := p_time_building_blocks(l_tbb_index).stop_time;
81: end if;
82:
83:
84: if g_debug then
85: hr_utility.set_location('Leaving '||l_proc, 20);
86: end if;
87:
88: END get_timecard_info;
89:
97:
98: l_att_index BINARY_INTEGER;
99:
100: BEGIN
101: g_debug := hr_utility.debug_enabled;
102:
103: if g_debug then
104: l_proc := g_package||'get_timecard_info';
105: hr_utility.set_location('Entering '||l_proc, 10);
101: g_debug := hr_utility.debug_enabled;
102:
103: if g_debug then
104: l_proc := g_package||'get_timecard_info';
105: hr_utility.set_location('Entering '||l_proc, 10);
106: end if;
107:
108: get_timecard_info ( p_time_building_blocks => p_time_building_blocks
109: , p_timecard_rec => p_timecard_rec );
115:
116: IF ( p_time_attributes(l_att_index).attribute_category = 'SECURITY' )
117: THEN
118: if g_debug then
119: hr_utility.set_location('Processing '||l_proc, 30);
120: end if;
121:
122: p_timecard_rec.bg_id := TO_NUMBER(p_time_attributes(l_att_index).attribute2);
123:
129:
130: END LOOP;
131:
132: if g_debug then
133: hr_utility.set_location('Leaving '||l_proc, 20);
134: end if;
135:
136: END get_timecard_info;
137:
167: l_period_start_date DATE;
168: l_period_end_date DATE;
169:
170: BEGIN
171: g_debug := hr_utility.debug_enabled;
172:
173: if g_debug then
174: l_proc := g_package||'calc_timecard_periods';
175: hr_utility.set_location('Entering '||l_proc, 10);
171: g_debug := hr_utility.debug_enabled;
172:
173: if g_debug then
174: l_proc := g_package||'calc_timecard_periods';
175: hr_utility.set_location('Entering '||l_proc, 10);
176: end if;
177:
178: l_period_start_date := p_period_start_date;
179: l_period_end_date := p_period_end_date;
181: WHILE ( l_period_start_date <= p_timecard_period_end )
182: LOOP
183:
184: if g_debug then
185: hr_utility.set_location('Processing '||l_proc, 20);
186: end if;
187:
188:
189: IF ( l_period_start_date >= p_timecard_period_start AND
190: TRUNC(l_period_end_date) <= p_timecard_period_end )
191: THEN
192:
193: if g_debug then
194: hr_utility.set_location('Processing '||l_proc, 30);
195: end if;
196:
197: -- period completely within TCO
198:
208: TRUNC(l_period_end_date) <= p_timecard_period_end )
209: THEN
210:
211: if g_debug then
212: hr_utility.set_location('Processing '||l_proc, 40);
213: end if;
214:
215: -- period includes TC and stradles TCO start
216:
237: TRUNC(l_period_end_date) > p_timecard_period_end )
238: THEN
239:
240: if g_debug then
241: hr_utility.set_location('Processing '||l_proc, 50);
242: end if;
243:
244: -- period includes TC and stradles TC end
245:
258: TRUNC(l_period_end_date) > p_timecard_period_end )
259: THEN
260:
261: if g_debug then
262: hr_utility.set_location('Processing '||l_proc, 60);
263: end if;
264:
265: -- period completely stradles TCO
266:
277:
278: END IF;
279:
280: if g_debug then
281: hr_utility.trace('');
282: hr_utility.trace(' ********** Periods ************** ');
283: hr_utility.trace(' Actual TC period start is :'||TO_CHAR(p_timecard_period_start, 'DD-MON-YY HH24:MI:SS'));
284: hr_utility.trace(' Actual TC period end is :'||TO_CHAR(p_timecard_period_end, 'DD-MON-YY HH24:MI:SS'));
285: hr_utility.trace(' TC period start is :'||TO_CHAR(p_periods_tab(l_cnt).period_start, 'DD-MON-YY HH24:MI:SS'));
278: END IF;
279:
280: if g_debug then
281: hr_utility.trace('');
282: hr_utility.trace(' ********** Periods ************** ');
283: hr_utility.trace(' Actual TC period start is :'||TO_CHAR(p_timecard_period_start, 'DD-MON-YY HH24:MI:SS'));
284: hr_utility.trace(' Actual TC period end is :'||TO_CHAR(p_timecard_period_end, 'DD-MON-YY HH24:MI:SS'));
285: hr_utility.trace(' TC period start is :'||TO_CHAR(p_periods_tab(l_cnt).period_start, 'DD-MON-YY HH24:MI:SS'));
286: hr_utility.trace(' TC period end is :'||TO_CHAR(p_periods_tab(l_cnt).period_end, 'DD-MON-YY HH24:MI:SS'));
279:
280: if g_debug then
281: hr_utility.trace('');
282: hr_utility.trace(' ********** Periods ************** ');
283: hr_utility.trace(' Actual TC period start is :'||TO_CHAR(p_timecard_period_start, 'DD-MON-YY HH24:MI:SS'));
284: hr_utility.trace(' Actual TC period end is :'||TO_CHAR(p_timecard_period_end, 'DD-MON-YY HH24:MI:SS'));
285: hr_utility.trace(' TC period start is :'||TO_CHAR(p_periods_tab(l_cnt).period_start, 'DD-MON-YY HH24:MI:SS'));
286: hr_utility.trace(' TC period end is :'||TO_CHAR(p_periods_tab(l_cnt).period_end, 'DD-MON-YY HH24:MI:SS'));
287: hr_utility.trace(' pre TC period start is :'||TO_CHAR(p_periods_tab(l_cnt).db_pre_period_start, 'DD-MON-YY HH24:MI:SS'));
280: if g_debug then
281: hr_utility.trace('');
282: hr_utility.trace(' ********** Periods ************** ');
283: hr_utility.trace(' Actual TC period start is :'||TO_CHAR(p_timecard_period_start, 'DD-MON-YY HH24:MI:SS'));
284: hr_utility.trace(' Actual TC period end is :'||TO_CHAR(p_timecard_period_end, 'DD-MON-YY HH24:MI:SS'));
285: hr_utility.trace(' TC period start is :'||TO_CHAR(p_periods_tab(l_cnt).period_start, 'DD-MON-YY HH24:MI:SS'));
286: hr_utility.trace(' TC period end is :'||TO_CHAR(p_periods_tab(l_cnt).period_end, 'DD-MON-YY HH24:MI:SS'));
287: hr_utility.trace(' pre TC period start is :'||TO_CHAR(p_periods_tab(l_cnt).db_pre_period_start, 'DD-MON-YY HH24:MI:SS'));
288: hr_utility.trace(' pre TC period end is :'||TO_CHAR(p_periods_tab(l_cnt).db_pre_period_end, 'DD-MON-YY HH24:MI:SS'));
281: hr_utility.trace('');
282: hr_utility.trace(' ********** Periods ************** ');
283: hr_utility.trace(' Actual TC period start is :'||TO_CHAR(p_timecard_period_start, 'DD-MON-YY HH24:MI:SS'));
284: hr_utility.trace(' Actual TC period end is :'||TO_CHAR(p_timecard_period_end, 'DD-MON-YY HH24:MI:SS'));
285: hr_utility.trace(' TC period start is :'||TO_CHAR(p_periods_tab(l_cnt).period_start, 'DD-MON-YY HH24:MI:SS'));
286: hr_utility.trace(' TC period end is :'||TO_CHAR(p_periods_tab(l_cnt).period_end, 'DD-MON-YY HH24:MI:SS'));
287: hr_utility.trace(' pre TC period start is :'||TO_CHAR(p_periods_tab(l_cnt).db_pre_period_start, 'DD-MON-YY HH24:MI:SS'));
288: hr_utility.trace(' pre TC period end is :'||TO_CHAR(p_periods_tab(l_cnt).db_pre_period_end, 'DD-MON-YY HH24:MI:SS'));
289: hr_utility.trace(' post TC period start is:'||TO_CHAR(p_periods_tab(l_cnt).db_post_period_start, 'DD-MON-YY HH24:MI:SS'));
282: hr_utility.trace(' ********** Periods ************** ');
283: hr_utility.trace(' Actual TC period start is :'||TO_CHAR(p_timecard_period_start, 'DD-MON-YY HH24:MI:SS'));
284: hr_utility.trace(' Actual TC period end is :'||TO_CHAR(p_timecard_period_end, 'DD-MON-YY HH24:MI:SS'));
285: hr_utility.trace(' TC period start is :'||TO_CHAR(p_periods_tab(l_cnt).period_start, 'DD-MON-YY HH24:MI:SS'));
286: hr_utility.trace(' TC period end is :'||TO_CHAR(p_periods_tab(l_cnt).period_end, 'DD-MON-YY HH24:MI:SS'));
287: hr_utility.trace(' pre TC period start is :'||TO_CHAR(p_periods_tab(l_cnt).db_pre_period_start, 'DD-MON-YY HH24:MI:SS'));
288: hr_utility.trace(' pre TC period end is :'||TO_CHAR(p_periods_tab(l_cnt).db_pre_period_end, 'DD-MON-YY HH24:MI:SS'));
289: hr_utility.trace(' post TC period start is:'||TO_CHAR(p_periods_tab(l_cnt).db_post_period_start, 'DD-MON-YY HH24:MI:SS'));
290: hr_utility.trace(' post TC period end is :'||TO_CHAR(p_periods_tab(l_cnt).db_post_period_end, 'DD-MON-YY HH24:MI:SS'));
283: hr_utility.trace(' Actual TC period start is :'||TO_CHAR(p_timecard_period_start, 'DD-MON-YY HH24:MI:SS'));
284: hr_utility.trace(' Actual TC period end is :'||TO_CHAR(p_timecard_period_end, 'DD-MON-YY HH24:MI:SS'));
285: hr_utility.trace(' TC period start is :'||TO_CHAR(p_periods_tab(l_cnt).period_start, 'DD-MON-YY HH24:MI:SS'));
286: hr_utility.trace(' TC period end is :'||TO_CHAR(p_periods_tab(l_cnt).period_end, 'DD-MON-YY HH24:MI:SS'));
287: hr_utility.trace(' pre TC period start is :'||TO_CHAR(p_periods_tab(l_cnt).db_pre_period_start, 'DD-MON-YY HH24:MI:SS'));
288: hr_utility.trace(' pre TC period end is :'||TO_CHAR(p_periods_tab(l_cnt).db_pre_period_end, 'DD-MON-YY HH24:MI:SS'));
289: hr_utility.trace(' post TC period start is:'||TO_CHAR(p_periods_tab(l_cnt).db_post_period_start, 'DD-MON-YY HH24:MI:SS'));
290: hr_utility.trace(' post TC period end is :'||TO_CHAR(p_periods_tab(l_cnt).db_post_period_end, 'DD-MON-YY HH24:MI:SS'));
291: end if;
284: hr_utility.trace(' Actual TC period end is :'||TO_CHAR(p_timecard_period_end, 'DD-MON-YY HH24:MI:SS'));
285: hr_utility.trace(' TC period start is :'||TO_CHAR(p_periods_tab(l_cnt).period_start, 'DD-MON-YY HH24:MI:SS'));
286: hr_utility.trace(' TC period end is :'||TO_CHAR(p_periods_tab(l_cnt).period_end, 'DD-MON-YY HH24:MI:SS'));
287: hr_utility.trace(' pre TC period start is :'||TO_CHAR(p_periods_tab(l_cnt).db_pre_period_start, 'DD-MON-YY HH24:MI:SS'));
288: hr_utility.trace(' pre TC period end is :'||TO_CHAR(p_periods_tab(l_cnt).db_pre_period_end, 'DD-MON-YY HH24:MI:SS'));
289: hr_utility.trace(' post TC period start is:'||TO_CHAR(p_periods_tab(l_cnt).db_post_period_start, 'DD-MON-YY HH24:MI:SS'));
290: hr_utility.trace(' post TC period end is :'||TO_CHAR(p_periods_tab(l_cnt).db_post_period_end, 'DD-MON-YY HH24:MI:SS'));
291: end if;
292:
285: hr_utility.trace(' TC period start is :'||TO_CHAR(p_periods_tab(l_cnt).period_start, 'DD-MON-YY HH24:MI:SS'));
286: hr_utility.trace(' TC period end is :'||TO_CHAR(p_periods_tab(l_cnt).period_end, 'DD-MON-YY HH24:MI:SS'));
287: hr_utility.trace(' pre TC period start is :'||TO_CHAR(p_periods_tab(l_cnt).db_pre_period_start, 'DD-MON-YY HH24:MI:SS'));
288: hr_utility.trace(' pre TC period end is :'||TO_CHAR(p_periods_tab(l_cnt).db_pre_period_end, 'DD-MON-YY HH24:MI:SS'));
289: hr_utility.trace(' post TC period start is:'||TO_CHAR(p_periods_tab(l_cnt).db_post_period_start, 'DD-MON-YY HH24:MI:SS'));
290: hr_utility.trace(' post TC period end is :'||TO_CHAR(p_periods_tab(l_cnt).db_post_period_end, 'DD-MON-YY HH24:MI:SS'));
291: end if;
292:
293: l_period_start_date := l_period_start_date + p_duration_in_days;
286: hr_utility.trace(' TC period end is :'||TO_CHAR(p_periods_tab(l_cnt).period_end, 'DD-MON-YY HH24:MI:SS'));
287: hr_utility.trace(' pre TC period start is :'||TO_CHAR(p_periods_tab(l_cnt).db_pre_period_start, 'DD-MON-YY HH24:MI:SS'));
288: hr_utility.trace(' pre TC period end is :'||TO_CHAR(p_periods_tab(l_cnt).db_pre_period_end, 'DD-MON-YY HH24:MI:SS'));
289: hr_utility.trace(' post TC period start is:'||TO_CHAR(p_periods_tab(l_cnt).db_post_period_start, 'DD-MON-YY HH24:MI:SS'));
290: hr_utility.trace(' post TC period end is :'||TO_CHAR(p_periods_tab(l_cnt).db_post_period_end, 'DD-MON-YY HH24:MI:SS'));
291: end if;
292:
293: l_period_start_date := l_period_start_date + p_duration_in_days;
294: l_period_end_date := l_period_end_date + p_duration_in_days;
293: l_period_start_date := l_period_start_date + p_duration_in_days;
294: l_period_end_date := l_period_end_date + p_duration_in_days;
295:
296: if g_debug then
297: hr_utility.trace('');
298: hr_utility.trace('start is '||to_char(l_period_start_date, 'dd-mon-yyyy hh24:mi:ss'));
299: hr_utility.trace('end is '||to_char(l_period_end_date, 'dd-mon-yyyy hh24:mi:ss'));
300: hr_utility.trace('');
301: end if;
294: l_period_end_date := l_period_end_date + p_duration_in_days;
295:
296: if g_debug then
297: hr_utility.trace('');
298: hr_utility.trace('start is '||to_char(l_period_start_date, 'dd-mon-yyyy hh24:mi:ss'));
299: hr_utility.trace('end is '||to_char(l_period_end_date, 'dd-mon-yyyy hh24:mi:ss'));
300: hr_utility.trace('');
301: end if;
302:
295:
296: if g_debug then
297: hr_utility.trace('');
298: hr_utility.trace('start is '||to_char(l_period_start_date, 'dd-mon-yyyy hh24:mi:ss'));
299: hr_utility.trace('end is '||to_char(l_period_end_date, 'dd-mon-yyyy hh24:mi:ss'));
300: hr_utility.trace('');
301: end if;
302:
303: l_cnt := l_cnt + 1;
296: if g_debug then
297: hr_utility.trace('');
298: hr_utility.trace('start is '||to_char(l_period_start_date, 'dd-mon-yyyy hh24:mi:ss'));
299: hr_utility.trace('end is '||to_char(l_period_end_date, 'dd-mon-yyyy hh24:mi:ss'));
300: hr_utility.trace('');
301: end if;
302:
303: l_cnt := l_cnt + 1;
304:
304:
305: END LOOP;
306:
307: if g_debug then
308: hr_utility.set_location('Leaving '||l_proc, 70);
309: end if;
310:
311: END calc_timecard_periods;
312:
331: l_ref_period_end DATE;
332:
333: BEGIN
334:
335: g_debug := hr_utility.debug_enabled;
336:
337: if g_debug then
338: l_proc := g_package||'calc_reference_periods';
339: hr_utility.set_location('Entering '||l_proc, 10);
335: g_debug := hr_utility.debug_enabled;
336:
337: if g_debug then
338: l_proc := g_package||'calc_reference_periods';
339: hr_utility.set_location('Entering '||l_proc, 10);
340: end if;
341:
342: l_period_start_date := p_period_start_date;
343: l_period_end_date := p_period_end_date;
348: WHILE ( l_period_start_date <= p_timecard_period_end )
349: LOOP
350:
351: if g_debug then
352: hr_utility.set_location('Processing '||l_proc, 20);
353: end if;
354:
355: IF ( l_period_start_date >= p_timecard_period_start AND
356: TRUNC(l_period_end_date) <= p_timecard_period_end )
356: TRUNC(l_period_end_date) <= p_timecard_period_end )
357: THEN
358:
359: if g_debug then
360: hr_utility.set_location('Entering '||l_proc, 30);
361: end if;
362:
363: -- timecard period completely within TCO
364:
369: l_ref_period_start >= p_timecard_period_start )
370: THEN
371:
372: if g_debug then
373: hr_utility.set_location('Entering '||l_proc, 40);
374: end if;
375:
376: -- ref period completely enclosed in TCO
377:
384: l_ref_period_start < p_timecard_period_start )
385: THEN
386:
387: if g_debug then
388: hr_utility.set_location('Entering '||l_proc, 50);
389: end if;
390:
391: -- ref period stradles start of TCO or end falls exactly on TC start
392:
398:
399: ELSE
400:
401: if g_debug then
402: hr_utility.set_location('Entering '||l_proc, 70);
403: end if;
404:
405: p_periods_tab(l_cnt).db_ref_period_start := l_ref_period_start;
406: p_periods_tab(l_cnt).db_ref_period_end :=
413: TRUNC(l_period_end_date) <= p_timecard_period_end )
414: THEN
415:
416: if g_debug then
417: hr_utility.set_location('Entering '||l_proc, 80);
418: end if;
419:
420: -- period includes TC and stradles TCO start
421:
427: TRUNC(l_period_end_date) > p_timecard_period_end )
428: THEN
429:
430: if g_debug then
431: hr_utility.set_location('Entering '||l_proc, 90);
432: end if;
433:
434: -- period includes TC and stradles TC end
435:
439: l_ref_period_start >= p_timecard_period_start )
440: THEN
441:
442: if g_debug then
443: hr_utility.set_location('Entering '||l_proc, 100);
444: end if;
445:
446: -- reference period completely enclosed in TCO
447:
454: l_ref_period_start < p_timecard_period_start )
455: THEN
456:
457: if g_debug then
458: hr_utility.set_location('Entering '||l_proc, 110);
459: end if;
460:
461: -- ref period stradles start of TCO or end falls exactly on start of TCO
462:
468:
469: ELSE
470:
471: if g_debug then
472: hr_utility.set_location('Entering '||l_proc, 130);
473: end if;
474:
475: p_periods_tab(l_cnt).db_ref_period_start := l_ref_period_start;
476: p_periods_tab(l_cnt).db_ref_period_end :=
482: l_period_end_date > p_timecard_period_end )
483: THEN
484:
485: if g_debug then
486: hr_utility.set_location('Entering '||l_proc, 140);
487: end if;
488:
489: -- period completely stradles TCO
490: -- reference period outside of TCO
495:
496: END IF;
497:
498: if g_debug then
499: hr_utility.trace('');
500: hr_utility.trace(' ********** Periods ************** ');
501: hr_utility.trace(' Actual TC period start is :'||TO_CHAR(p_timecard_period_start, 'DD-MON-YY HH24:MI:SS'));
502: hr_utility.trace(' Actual TC period end is :'||TO_CHAR(p_timecard_period_end, 'DD-MON-YY HH24:MI:SS'));
503: hr_utility.trace(' TC period start is :'||TO_CHAR(p_periods_tab(l_cnt).period_start, 'DD-MON-YY HH24:MI:SS'));
496: END IF;
497:
498: if g_debug then
499: hr_utility.trace('');
500: hr_utility.trace(' ********** Periods ************** ');
501: hr_utility.trace(' Actual TC period start is :'||TO_CHAR(p_timecard_period_start, 'DD-MON-YY HH24:MI:SS'));
502: hr_utility.trace(' Actual TC period end is :'||TO_CHAR(p_timecard_period_end, 'DD-MON-YY HH24:MI:SS'));
503: hr_utility.trace(' TC period start is :'||TO_CHAR(p_periods_tab(l_cnt).period_start, 'DD-MON-YY HH24:MI:SS'));
504: hr_utility.trace(' TC period end is :'||TO_CHAR(p_periods_tab(l_cnt).period_end, 'DD-MON-YY HH24:MI:SS'));
497:
498: if g_debug then
499: hr_utility.trace('');
500: hr_utility.trace(' ********** Periods ************** ');
501: hr_utility.trace(' Actual TC period start is :'||TO_CHAR(p_timecard_period_start, 'DD-MON-YY HH24:MI:SS'));
502: hr_utility.trace(' Actual TC period end is :'||TO_CHAR(p_timecard_period_end, 'DD-MON-YY HH24:MI:SS'));
503: hr_utility.trace(' TC period start is :'||TO_CHAR(p_periods_tab(l_cnt).period_start, 'DD-MON-YY HH24:MI:SS'));
504: hr_utility.trace(' TC period end is :'||TO_CHAR(p_periods_tab(l_cnt).period_end, 'DD-MON-YY HH24:MI:SS'));
505: hr_utility.trace(' pre TC period start is :'||TO_CHAR(p_periods_tab(l_cnt).db_pre_period_start, 'DD-MON-YY HH24:MI:SS'));
498: if g_debug then
499: hr_utility.trace('');
500: hr_utility.trace(' ********** Periods ************** ');
501: hr_utility.trace(' Actual TC period start is :'||TO_CHAR(p_timecard_period_start, 'DD-MON-YY HH24:MI:SS'));
502: hr_utility.trace(' Actual TC period end is :'||TO_CHAR(p_timecard_period_end, 'DD-MON-YY HH24:MI:SS'));
503: hr_utility.trace(' TC period start is :'||TO_CHAR(p_periods_tab(l_cnt).period_start, 'DD-MON-YY HH24:MI:SS'));
504: hr_utility.trace(' TC period end is :'||TO_CHAR(p_periods_tab(l_cnt).period_end, 'DD-MON-YY HH24:MI:SS'));
505: hr_utility.trace(' pre TC period start is :'||TO_CHAR(p_periods_tab(l_cnt).db_pre_period_start, 'DD-MON-YY HH24:MI:SS'));
506: hr_utility.trace(' pre TC period end is :'||TO_CHAR(p_periods_tab(l_cnt).db_pre_period_end, 'DD-MON-YY HH24:MI:SS'));
499: hr_utility.trace('');
500: hr_utility.trace(' ********** Periods ************** ');
501: hr_utility.trace(' Actual TC period start is :'||TO_CHAR(p_timecard_period_start, 'DD-MON-YY HH24:MI:SS'));
502: hr_utility.trace(' Actual TC period end is :'||TO_CHAR(p_timecard_period_end, 'DD-MON-YY HH24:MI:SS'));
503: hr_utility.trace(' TC period start is :'||TO_CHAR(p_periods_tab(l_cnt).period_start, 'DD-MON-YY HH24:MI:SS'));
504: hr_utility.trace(' TC period end is :'||TO_CHAR(p_periods_tab(l_cnt).period_end, 'DD-MON-YY HH24:MI:SS'));
505: hr_utility.trace(' pre TC period start is :'||TO_CHAR(p_periods_tab(l_cnt).db_pre_period_start, 'DD-MON-YY HH24:MI:SS'));
506: hr_utility.trace(' pre TC period end is :'||TO_CHAR(p_periods_tab(l_cnt).db_pre_period_end, 'DD-MON-YY HH24:MI:SS'));
507: hr_utility.trace(' post TC period start is:'||TO_CHAR(p_periods_tab(l_cnt).db_post_period_start, 'DD-MON-YY HH24:MI:SS'));
500: hr_utility.trace(' ********** Periods ************** ');
501: hr_utility.trace(' Actual TC period start is :'||TO_CHAR(p_timecard_period_start, 'DD-MON-YY HH24:MI:SS'));
502: hr_utility.trace(' Actual TC period end is :'||TO_CHAR(p_timecard_period_end, 'DD-MON-YY HH24:MI:SS'));
503: hr_utility.trace(' TC period start is :'||TO_CHAR(p_periods_tab(l_cnt).period_start, 'DD-MON-YY HH24:MI:SS'));
504: hr_utility.trace(' TC period end is :'||TO_CHAR(p_periods_tab(l_cnt).period_end, 'DD-MON-YY HH24:MI:SS'));
505: hr_utility.trace(' pre TC period start is :'||TO_CHAR(p_periods_tab(l_cnt).db_pre_period_start, 'DD-MON-YY HH24:MI:SS'));
506: hr_utility.trace(' pre TC period end is :'||TO_CHAR(p_periods_tab(l_cnt).db_pre_period_end, 'DD-MON-YY HH24:MI:SS'));
507: hr_utility.trace(' post TC period start is:'||TO_CHAR(p_periods_tab(l_cnt).db_post_period_start, 'DD-MON-YY HH24:MI:SS'));
508: hr_utility.trace(' post TC period end is :'||TO_CHAR(p_periods_tab(l_cnt).db_post_period_end, 'DD-MON-YY HH24:MI:SS'));
501: hr_utility.trace(' Actual TC period start is :'||TO_CHAR(p_timecard_period_start, 'DD-MON-YY HH24:MI:SS'));
502: hr_utility.trace(' Actual TC period end is :'||TO_CHAR(p_timecard_period_end, 'DD-MON-YY HH24:MI:SS'));
503: hr_utility.trace(' TC period start is :'||TO_CHAR(p_periods_tab(l_cnt).period_start, 'DD-MON-YY HH24:MI:SS'));
504: hr_utility.trace(' TC period end is :'||TO_CHAR(p_periods_tab(l_cnt).period_end, 'DD-MON-YY HH24:MI:SS'));
505: hr_utility.trace(' pre TC period start is :'||TO_CHAR(p_periods_tab(l_cnt).db_pre_period_start, 'DD-MON-YY HH24:MI:SS'));
506: hr_utility.trace(' pre TC period end is :'||TO_CHAR(p_periods_tab(l_cnt).db_pre_period_end, 'DD-MON-YY HH24:MI:SS'));
507: hr_utility.trace(' post TC period start is:'||TO_CHAR(p_periods_tab(l_cnt).db_post_period_start, 'DD-MON-YY HH24:MI:SS'));
508: hr_utility.trace(' post TC period end is :'||TO_CHAR(p_periods_tab(l_cnt).db_post_period_end, 'DD-MON-YY HH24:MI:SS'));
509: hr_utility.trace(' ref period start is :'||TO_CHAR(p_periods_tab(l_cnt).db_ref_period_start, 'DD-MON-YY HH24:MI:SS'));
502: hr_utility.trace(' Actual TC period end is :'||TO_CHAR(p_timecard_period_end, 'DD-MON-YY HH24:MI:SS'));
503: hr_utility.trace(' TC period start is :'||TO_CHAR(p_periods_tab(l_cnt).period_start, 'DD-MON-YY HH24:MI:SS'));
504: hr_utility.trace(' TC period end is :'||TO_CHAR(p_periods_tab(l_cnt).period_end, 'DD-MON-YY HH24:MI:SS'));
505: hr_utility.trace(' pre TC period start is :'||TO_CHAR(p_periods_tab(l_cnt).db_pre_period_start, 'DD-MON-YY HH24:MI:SS'));
506: hr_utility.trace(' pre TC period end is :'||TO_CHAR(p_periods_tab(l_cnt).db_pre_period_end, 'DD-MON-YY HH24:MI:SS'));
507: hr_utility.trace(' post TC period start is:'||TO_CHAR(p_periods_tab(l_cnt).db_post_period_start, 'DD-MON-YY HH24:MI:SS'));
508: hr_utility.trace(' post TC period end is :'||TO_CHAR(p_periods_tab(l_cnt).db_post_period_end, 'DD-MON-YY HH24:MI:SS'));
509: hr_utility.trace(' ref period start is :'||TO_CHAR(p_periods_tab(l_cnt).db_ref_period_start, 'DD-MON-YY HH24:MI:SS'));
510: hr_utility.trace(' ref period end is :'||TO_CHAR(p_periods_tab(l_cnt).db_ref_period_end, 'DD-MON-YY HH24:MI:SS'));
503: hr_utility.trace(' TC period start is :'||TO_CHAR(p_periods_tab(l_cnt).period_start, 'DD-MON-YY HH24:MI:SS'));
504: hr_utility.trace(' TC period end is :'||TO_CHAR(p_periods_tab(l_cnt).period_end, 'DD-MON-YY HH24:MI:SS'));
505: hr_utility.trace(' pre TC period start is :'||TO_CHAR(p_periods_tab(l_cnt).db_pre_period_start, 'DD-MON-YY HH24:MI:SS'));
506: hr_utility.trace(' pre TC period end is :'||TO_CHAR(p_periods_tab(l_cnt).db_pre_period_end, 'DD-MON-YY HH24:MI:SS'));
507: hr_utility.trace(' post TC period start is:'||TO_CHAR(p_periods_tab(l_cnt).db_post_period_start, 'DD-MON-YY HH24:MI:SS'));
508: hr_utility.trace(' post TC period end is :'||TO_CHAR(p_periods_tab(l_cnt).db_post_period_end, 'DD-MON-YY HH24:MI:SS'));
509: hr_utility.trace(' ref period start is :'||TO_CHAR(p_periods_tab(l_cnt).db_ref_period_start, 'DD-MON-YY HH24:MI:SS'));
510: hr_utility.trace(' ref period end is :'||TO_CHAR(p_periods_tab(l_cnt).db_ref_period_end, 'DD-MON-YY HH24:MI:SS'));
511: end if;
504: hr_utility.trace(' TC period end is :'||TO_CHAR(p_periods_tab(l_cnt).period_end, 'DD-MON-YY HH24:MI:SS'));
505: hr_utility.trace(' pre TC period start is :'||TO_CHAR(p_periods_tab(l_cnt).db_pre_period_start, 'DD-MON-YY HH24:MI:SS'));
506: hr_utility.trace(' pre TC period end is :'||TO_CHAR(p_periods_tab(l_cnt).db_pre_period_end, 'DD-MON-YY HH24:MI:SS'));
507: hr_utility.trace(' post TC period start is:'||TO_CHAR(p_periods_tab(l_cnt).db_post_period_start, 'DD-MON-YY HH24:MI:SS'));
508: hr_utility.trace(' post TC period end is :'||TO_CHAR(p_periods_tab(l_cnt).db_post_period_end, 'DD-MON-YY HH24:MI:SS'));
509: hr_utility.trace(' ref period start is :'||TO_CHAR(p_periods_tab(l_cnt).db_ref_period_start, 'DD-MON-YY HH24:MI:SS'));
510: hr_utility.trace(' ref period end is :'||TO_CHAR(p_periods_tab(l_cnt).db_ref_period_end, 'DD-MON-YY HH24:MI:SS'));
511: end if;
512:
505: hr_utility.trace(' pre TC period start is :'||TO_CHAR(p_periods_tab(l_cnt).db_pre_period_start, 'DD-MON-YY HH24:MI:SS'));
506: hr_utility.trace(' pre TC period end is :'||TO_CHAR(p_periods_tab(l_cnt).db_pre_period_end, 'DD-MON-YY HH24:MI:SS'));
507: hr_utility.trace(' post TC period start is:'||TO_CHAR(p_periods_tab(l_cnt).db_post_period_start, 'DD-MON-YY HH24:MI:SS'));
508: hr_utility.trace(' post TC period end is :'||TO_CHAR(p_periods_tab(l_cnt).db_post_period_end, 'DD-MON-YY HH24:MI:SS'));
509: hr_utility.trace(' ref period start is :'||TO_CHAR(p_periods_tab(l_cnt).db_ref_period_start, 'DD-MON-YY HH24:MI:SS'));
510: hr_utility.trace(' ref period end is :'||TO_CHAR(p_periods_tab(l_cnt).db_ref_period_end, 'DD-MON-YY HH24:MI:SS'));
511: end if;
512:
513: l_period_start_date := l_period_start_date + p_duration_in_days;
506: hr_utility.trace(' pre TC period end is :'||TO_CHAR(p_periods_tab(l_cnt).db_pre_period_end, 'DD-MON-YY HH24:MI:SS'));
507: hr_utility.trace(' post TC period start is:'||TO_CHAR(p_periods_tab(l_cnt).db_post_period_start, 'DD-MON-YY HH24:MI:SS'));
508: hr_utility.trace(' post TC period end is :'||TO_CHAR(p_periods_tab(l_cnt).db_post_period_end, 'DD-MON-YY HH24:MI:SS'));
509: hr_utility.trace(' ref period start is :'||TO_CHAR(p_periods_tab(l_cnt).db_ref_period_start, 'DD-MON-YY HH24:MI:SS'));
510: hr_utility.trace(' ref period end is :'||TO_CHAR(p_periods_tab(l_cnt).db_ref_period_end, 'DD-MON-YY HH24:MI:SS'));
511: end if;
512:
513: l_period_start_date := l_period_start_date + p_duration_in_days;
514: l_period_end_date := l_period_end_date + p_duration_in_days;
520:
521: END LOOP;
522:
523: if g_debug then
524: hr_utility.set_location('Leaving '||l_proc, 160);
525: end if;
526:
527: END calc_reference_periods;
528:
619: l_timecard_hrs NUMBER;
620:
621: BEGIN -- calc_timecard_hrs
622:
623: g_debug := hr_utility.debug_enabled;
624:
625: if g_debug then
626: l_proc := g_package||'calc_timecard_hrs';
627: hr_utility.trace('p hrs period start is :'||to_char(p_hrs_period_start, 'DD-MON-YYYY HH24:MI:SS'));
623: g_debug := hr_utility.debug_enabled;
624:
625: if g_debug then
626: l_proc := g_package||'calc_timecard_hrs';
627: hr_utility.trace('p hrs period start is :'||to_char(p_hrs_period_start, 'DD-MON-YYYY HH24:MI:SS'));
628: hr_utility.trace('p hrs period end is :'||to_char(p_hrs_period_end, 'DD-MON-YYYY HH24:MI:SS'));
629: end if;
630:
631: IF ( p_time_category_id IS NOT NULL )
624:
625: if g_debug then
626: l_proc := g_package||'calc_timecard_hrs';
627: hr_utility.trace('p hrs period start is :'||to_char(p_hrs_period_start, 'DD-MON-YYYY HH24:MI:SS'));
628: hr_utility.trace('p hrs period end is :'||to_char(p_hrs_period_end, 'DD-MON-YYYY HH24:MI:SS'));
629: end if;
630:
631: IF ( p_time_category_id IS NOT NULL )
632: THEN
631: IF ( p_time_category_id IS NOT NULL )
632: THEN
633:
634: if g_debug then
635: hr_utility.set_location('Processing '||l_proc, 15);
636: end if;
637:
638: hxc_time_category_utils_pkg.initialise_time_category (
639: p_time_category_id => p_time_category_id
657:
658: END IF;
659:
660: if g_debug then
661: hr_utility.trace('');
662: hr_utility.trace(' TC hours are '||TO_CHAR(l_timecard_hrs));
663: hr_utility.trace('');
664: end if;
665:
658: END IF;
659:
660: if g_debug then
661: hr_utility.trace('');
662: hr_utility.trace(' TC hours are '||TO_CHAR(l_timecard_hrs));
663: hr_utility.trace('');
664: end if;
665:
666: RETURN l_timecard_hrs;
659:
660: if g_debug then
661: hr_utility.trace('');
662: hr_utility.trace(' TC hours are '||TO_CHAR(l_timecard_hrs));
663: hr_utility.trace('');
664: end if;
665:
666: RETURN l_timecard_hrs;
667:
667:
668: exception when others then
669:
670: if g_debug then
671: hr_utility.trace('In exception ....');
672: hr_utility.trace(SUBSTR(SQLERRM,1 ,80));
673: hr_utility.trace(SUBSTR(SQLERRM,81, 160));
674: end if;
675:
668: exception when others then
669:
670: if g_debug then
671: hr_utility.trace('In exception ....');
672: hr_utility.trace(SUBSTR(SQLERRM,1 ,80));
673: hr_utility.trace(SUBSTR(SQLERRM,81, 160));
674: end if;
675:
676: raise;
669:
670: if g_debug then
671: hr_utility.trace('In exception ....');
672: hr_utility.trace(SUBSTR(SQLERRM,1 ,80));
673: hr_utility.trace(SUBSTR(SQLERRM,81, 160));
674: end if;
675:
676: raise;
677:
711: l_hrs NUMBER;
712:
713: BEGIN -- calc_timecard_hrs
714:
715: g_debug := hr_utility.debug_enabled;
716:
717: l_hrs := calc_timecard_hrs (
718: p_hrs_period_start => p_hrs_period_start
719: , p_hrs_period_end => p_hrs_period_end
722: , p_time_category_id => p_time_category_id );
723:
724: if g_debug then
725: l_proc := g_package||'calc_timecard_hrs';
726: hr_utility.trace('');
727: hr_utility.trace(' TC hours are '||TO_CHAR(l_hrs));
728: hr_utility.trace('');
729: end if;
730:
723:
724: if g_debug then
725: l_proc := g_package||'calc_timecard_hrs';
726: hr_utility.trace('');
727: hr_utility.trace(' TC hours are '||TO_CHAR(l_hrs));
728: hr_utility.trace('');
729: end if;
730:
731: RETURN l_hrs;
724: if g_debug then
725: l_proc := g_package||'calc_timecard_hrs';
726: hr_utility.trace('');
727: hr_utility.trace(' TC hours are '||TO_CHAR(l_hrs));
728: hr_utility.trace('');
729: end if;
730:
731: RETURN l_hrs;
732:
732:
733: exception when others then
734:
735: if g_debug then
736: hr_utility.trace(SUBSTR(SQLERRM,1 ,80));
737: hr_utility.trace(SUBSTR(SQLERRM,81, 160));
738: end if;
739:
740: raise;
733: exception when others then
734:
735: if g_debug then
736: hr_utility.trace(SUBSTR(SQLERRM,1 ,80));
737: hr_utility.trace(SUBSTR(SQLERRM,81, 160));
738: end if;
739:
740: raise;
741:
772: l_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
773: l_message_token varchar2(4000);
774:
775: BEGIN
776: g_debug := hr_utility.debug_enabled;
777:
778: if g_debug then
779: l_proc := g_package||'add_error_to_table';
780: hr_utility.set_location('Entering '||l_proc, 10);
776: g_debug := hr_utility.debug_enabled;
777:
778: if g_debug then
779: l_proc := g_package||'add_error_to_table';
780: hr_utility.set_location('Entering '||l_proc, 10);
781: end if;
782:
783: l_tbb_ovn := p_timecard_bb_ovn+1;
784:
784:
785: l_last_index := NVL(p_message_table.last,0);
786:
787: if g_debug then
788: hr_utility.trace('index is '||to_char(l_last_index));
789: end if;
790:
791: l_message_token := SUBSTR(p_message_token,1,4000);
792:
820: p_message_table(l_last_index+1).time_attribute_ovn := p_time_attribute_ovn;
821: p_message_table(l_last_index+1).message_extent := p_message_extent; --Bug#2873563
822:
823: if g_debug then
824: hr_utility.set_location('Leaving '||l_proc, 20);
825: end if;
826:
827: END add_error_to_table;
828:
1023: IF ( p_timecard_info.deleted = 'N' )
1024: THEN
1025:
1026: if g_debug then
1027: hr_utility.trace('Entering check_commit');
1028: end if;
1029:
1030: OPEN chk_global_table;
1031: FETCH chk_global_table INTO l_dummy;
1035:
1036: CLOSE chk_global_table;
1037:
1038: if g_debug then
1039: hr_utility.trace('hxc tmp bld blks empty');
1040: end if;
1041:
1042: add_error_to_table (
1043: p_message_table => p_message_table
1058:
1059: CLOSE chk_global_table;
1060:
1061: if g_debug then
1062: hr_utility.trace('hxc tmp bld blks populated');
1063: end if;
1064:
1065: RETURN TRUE;
1066:
1086: **********************************************/
1087:
1088: if g_debug then
1089: l_proc := g_package||'execute_formula';
1090: hr_utility.set_location('Processing '||l_proc, 10);
1091: end if;
1092:
1093: hxc_ff_dict.decode_formula_segments (
1094: p_formula_name => p_formula_name
1099: , p_consider_zero_hours => l_consider_zero_hours );
1100:
1101:
1102: if g_debug then
1103: hr_utility.trace(' ************* Param values are.... ************ ');
1104: hr_utility.trace('');
1105: hr_utility.trace(' Rule name is '||p_rule_record.name);
1106: hr_utility.trace('');
1107: hr_utility.trace(' Period Id is '||to_char(l_period_id));
1100:
1101:
1102: if g_debug then
1103: hr_utility.trace(' ************* Param values are.... ************ ');
1104: hr_utility.trace('');
1105: hr_utility.trace(' Rule name is '||p_rule_record.name);
1106: hr_utility.trace('');
1107: hr_utility.trace(' Period Id is '||to_char(l_period_id));
1108: hr_utility.trace(' Reference Period is '||to_char(l_reference_period));
1101:
1102: if g_debug then
1103: hr_utility.trace(' ************* Param values are.... ************ ');
1104: hr_utility.trace('');
1105: hr_utility.trace(' Rule name is '||p_rule_record.name);
1106: hr_utility.trace('');
1107: hr_utility.trace(' Period Id is '||to_char(l_period_id));
1108: hr_utility.trace(' Reference Period is '||to_char(l_reference_period));
1109: hr_utility.trace(' Period Max is '||l_param_rec.param2_value);
1102: if g_debug then
1103: hr_utility.trace(' ************* Param values are.... ************ ');
1104: hr_utility.trace('');
1105: hr_utility.trace(' Rule name is '||p_rule_record.name);
1106: hr_utility.trace('');
1107: hr_utility.trace(' Period Id is '||to_char(l_period_id));
1108: hr_utility.trace(' Reference Period is '||to_char(l_reference_period));
1109: hr_utility.trace(' Period Max is '||l_param_rec.param2_value);
1110:
1103: hr_utility.trace(' ************* Param values are.... ************ ');
1104: hr_utility.trace('');
1105: hr_utility.trace(' Rule name is '||p_rule_record.name);
1106: hr_utility.trace('');
1107: hr_utility.trace(' Period Id is '||to_char(l_period_id));
1108: hr_utility.trace(' Reference Period is '||to_char(l_reference_period));
1109: hr_utility.trace(' Period Max is '||l_param_rec.param2_value);
1110:
1111:
1104: hr_utility.trace('');
1105: hr_utility.trace(' Rule name is '||p_rule_record.name);
1106: hr_utility.trace('');
1107: hr_utility.trace(' Period Id is '||to_char(l_period_id));
1108: hr_utility.trace(' Reference Period is '||to_char(l_reference_period));
1109: hr_utility.trace(' Period Max is '||l_param_rec.param2_value);
1110:
1111:
1112: hr_utility.set_location('Processing '||l_proc, 20);
1105: hr_utility.trace(' Rule name is '||p_rule_record.name);
1106: hr_utility.trace('');
1107: hr_utility.trace(' Period Id is '||to_char(l_period_id));
1108: hr_utility.trace(' Reference Period is '||to_char(l_reference_period));
1109: hr_utility.trace(' Period Max is '||l_param_rec.param2_value);
1110:
1111:
1112: hr_utility.set_location('Processing '||l_proc, 20);
1113: end if;
1108: hr_utility.trace(' Reference Period is '||to_char(l_reference_period));
1109: hr_utility.trace(' Period Max is '||l_param_rec.param2_value);
1110:
1111:
1112: hr_utility.set_location('Processing '||l_proc, 20);
1113: end if;
1114:
1115: -- if either PERIOD or REFERENCE_PERIOD specified.
1116:
1126: FETCH csr_get_period_info INTO l_period_type, l_duration_in_days, l_period_start;
1127: CLOSE csr_get_period_info;
1128:
1129: if g_debug then
1130: hr_utility.trace('');
1131: hr_utility.trace('*********** Period Info ************');
1132: hr_utility.trace('period type is '||l_period_type);
1133: hr_utility.trace('duration in days is '||TO_CHAR(l_duration_in_days));
1134: hr_utility.trace('period start date is '||TO_CHAR(l_period_start,'DD-MON-YY HH24:MI:SS'));
1127: CLOSE csr_get_period_info;
1128:
1129: if g_debug then
1130: hr_utility.trace('');
1131: hr_utility.trace('*********** Period Info ************');
1132: hr_utility.trace('period type is '||l_period_type);
1133: hr_utility.trace('duration in days is '||TO_CHAR(l_duration_in_days));
1134: hr_utility.trace('period start date is '||TO_CHAR(l_period_start,'DD-MON-YY HH24:MI:SS'));
1135: end if;
1128:
1129: if g_debug then
1130: hr_utility.trace('');
1131: hr_utility.trace('*********** Period Info ************');
1132: hr_utility.trace('period type is '||l_period_type);
1133: hr_utility.trace('duration in days is '||TO_CHAR(l_duration_in_days));
1134: hr_utility.trace('period start date is '||TO_CHAR(l_period_start,'DD-MON-YY HH24:MI:SS'));
1135: end if;
1136:
1129: if g_debug then
1130: hr_utility.trace('');
1131: hr_utility.trace('*********** Period Info ************');
1132: hr_utility.trace('period type is '||l_period_type);
1133: hr_utility.trace('duration in days is '||TO_CHAR(l_duration_in_days));
1134: hr_utility.trace('period start date is '||TO_CHAR(l_period_start,'DD-MON-YY HH24:MI:SS'));
1135: end if;
1136:
1137:
1130: hr_utility.trace('');
1131: hr_utility.trace('*********** Period Info ************');
1132: hr_utility.trace('period type is '||l_period_type);
1133: hr_utility.trace('duration in days is '||TO_CHAR(l_duration_in_days));
1134: hr_utility.trace('period start date is '||TO_CHAR(l_period_start,'DD-MON-YY HH24:MI:SS'));
1135: end if;
1136:
1137:
1138: IF ( l_duration_in_days IS NOT NULL )
1164:
1165: l_period_end_date := TO_DATE(TO_CHAR(l_period_end_date, 'DD/MM/YYYY')||' 23:59:59','DD/MM/YYYY HH24:MI:SS');
1166:
1167: if g_debug then
1168: Hr_utility.trace('');
1169: hr_utility.trace('*********** Period Start and End ************');
1170: hr_utility.trace('period start date is '||TO_CHAR(l_period_start_date,'DD-MON-YY HH24:MI:SS'));
1171: hr_utility.trace('period end date is '||TO_CHAR(l_period_end_date,'DD-MON-YY HH24:MI:SS'));
1172: hr_utility.trace('duration in days is '||TO_CHAR(l_duration_in_days));
1165: l_period_end_date := TO_DATE(TO_CHAR(l_period_end_date, 'DD/MM/YYYY')||' 23:59:59','DD/MM/YYYY HH24:MI:SS');
1166:
1167: if g_debug then
1168: Hr_utility.trace('');
1169: hr_utility.trace('*********** Period Start and End ************');
1170: hr_utility.trace('period start date is '||TO_CHAR(l_period_start_date,'DD-MON-YY HH24:MI:SS'));
1171: hr_utility.trace('period end date is '||TO_CHAR(l_period_end_date,'DD-MON-YY HH24:MI:SS'));
1172: hr_utility.trace('duration in days is '||TO_CHAR(l_duration_in_days));
1173: end if;
1166:
1167: if g_debug then
1168: Hr_utility.trace('');
1169: hr_utility.trace('*********** Period Start and End ************');
1170: hr_utility.trace('period start date is '||TO_CHAR(l_period_start_date,'DD-MON-YY HH24:MI:SS'));
1171: hr_utility.trace('period end date is '||TO_CHAR(l_period_end_date,'DD-MON-YY HH24:MI:SS'));
1172: hr_utility.trace('duration in days is '||TO_CHAR(l_duration_in_days));
1173: end if;
1174:
1167: if g_debug then
1168: Hr_utility.trace('');
1169: hr_utility.trace('*********** Period Start and End ************');
1170: hr_utility.trace('period start date is '||TO_CHAR(l_period_start_date,'DD-MON-YY HH24:MI:SS'));
1171: hr_utility.trace('period end date is '||TO_CHAR(l_period_end_date,'DD-MON-YY HH24:MI:SS'));
1172: hr_utility.trace('duration in days is '||TO_CHAR(l_duration_in_days));
1173: end if;
1174:
1175: -- now build up table of time entry rule periods that the timecard
1168: Hr_utility.trace('');
1169: hr_utility.trace('*********** Period Start and End ************');
1170: hr_utility.trace('period start date is '||TO_CHAR(l_period_start_date,'DD-MON-YY HH24:MI:SS'));
1171: hr_utility.trace('period end date is '||TO_CHAR(l_period_end_date,'DD-MON-YY HH24:MI:SS'));
1172: hr_utility.trace('duration in days is '||TO_CHAR(l_duration_in_days));
1173: end if;
1174:
1175: -- now build up table of time entry rule periods that the timecard
1176: -- may span
1220:
1221: END IF;
1222:
1223: if g_debug then
1224: hr_utility.trace('');
1225: hr_utility.trace('********** Original reference period ************');
1226: hr_utility.trace('ref period start is '||TO_CHAR(l_ref_period_start,'DD-MON-YY HH24:MI:SS'));
1227: hr_utility.trace('ref period end is '||TO_CHAR(l_ref_period_end,'DD-MON-YY HH24:MI:SS'));
1228: end if;
1221: END IF;
1222:
1223: if g_debug then
1224: hr_utility.trace('');
1225: hr_utility.trace('********** Original reference period ************');
1226: hr_utility.trace('ref period start is '||TO_CHAR(l_ref_period_start,'DD-MON-YY HH24:MI:SS'));
1227: hr_utility.trace('ref period end is '||TO_CHAR(l_ref_period_end,'DD-MON-YY HH24:MI:SS'));
1228: end if;
1229:
1222:
1223: if g_debug then
1224: hr_utility.trace('');
1225: hr_utility.trace('********** Original reference period ************');
1226: hr_utility.trace('ref period start is '||TO_CHAR(l_ref_period_start,'DD-MON-YY HH24:MI:SS'));
1227: hr_utility.trace('ref period end is '||TO_CHAR(l_ref_period_end,'DD-MON-YY HH24:MI:SS'));
1228: end if;
1229:
1230: END IF; -- ( l_reference_period IS NOT NULL )
1223: if g_debug then
1224: hr_utility.trace('');
1225: hr_utility.trace('********** Original reference period ************');
1226: hr_utility.trace('ref period start is '||TO_CHAR(l_ref_period_start,'DD-MON-YY HH24:MI:SS'));
1227: hr_utility.trace('ref period end is '||TO_CHAR(l_ref_period_end,'DD-MON-YY HH24:MI:SS'));
1228: end if;
1229:
1230: END IF; -- ( l_reference_period IS NOT NULL )
1231:
1229:
1230: END IF; -- ( l_reference_period IS NOT NULL )
1231:
1232: if g_debug then
1233: hr_utility.set_location('Processing '||l_proc, 30);
1234: end if;
1235:
1236: ELSE -- ( l_period and l_ref_period are NULL )
1237:
1250:
1251: END IF; -- ( l_period_id IS NOT NULL OR l_reference_period_id )
1252:
1253: if g_debug then
1254: hr_utility.trace('*********************************************** ******');
1255: hr_utility.trace('****** TIME CARD is ******');
1256: hr_utility.trace('*********************************************** ******');
1257: end if;
1258:
1251: END IF; -- ( l_period_id IS NOT NULL OR l_reference_period_id )
1252:
1253: if g_debug then
1254: hr_utility.trace('*********************************************** ******');
1255: hr_utility.trace('****** TIME CARD is ******');
1256: hr_utility.trace('*********************************************** ******');
1257: end if;
1258:
1259: l_new_index := p_tco_bb.FIRST;
1252:
1253: if g_debug then
1254: hr_utility.trace('*********************************************** ******');
1255: hr_utility.trace('****** TIME CARD is ******');
1256: hr_utility.trace('*********************************************** ******');
1257: end if;
1258:
1259: l_new_index := p_tco_bb.FIRST;
1260:
1261: WHILE ( l_new_index IS NOT NULL )
1262: LOOP
1263:
1264: if g_debug then
1265: hr_utility.trace('');
1266: hr_utility.trace('index is '||to_char(l_new_index));
1267: hr_utility.trace('scope is '||p_tco_bb(l_new_index).scope);
1268: hr_utility.trace('bb id '||to_char(p_tco_bb(l_new_index).time_building_block_id));
1269: hr_utility.trace('parent bb id '||to_char(p_tco_bb(l_new_index).parent_building_block_id));
1262: LOOP
1263:
1264: if g_debug then
1265: hr_utility.trace('');
1266: hr_utility.trace('index is '||to_char(l_new_index));
1267: hr_utility.trace('scope is '||p_tco_bb(l_new_index).scope);
1268: hr_utility.trace('bb id '||to_char(p_tco_bb(l_new_index).time_building_block_id));
1269: hr_utility.trace('parent bb id '||to_char(p_tco_bb(l_new_index).parent_building_block_id));
1270: hr_utility.trace('start '||to_char(p_tco_bb(l_new_index).start_time, 'dd-mon-yy'));
1263:
1264: if g_debug then
1265: hr_utility.trace('');
1266: hr_utility.trace('index is '||to_char(l_new_index));
1267: hr_utility.trace('scope is '||p_tco_bb(l_new_index).scope);
1268: hr_utility.trace('bb id '||to_char(p_tco_bb(l_new_index).time_building_block_id));
1269: hr_utility.trace('parent bb id '||to_char(p_tco_bb(l_new_index).parent_building_block_id));
1270: hr_utility.trace('start '||to_char(p_tco_bb(l_new_index).start_time, 'dd-mon-yy'));
1271: hr_utility.trace('measure '||to_char(p_tco_bb(l_new_index).measure));
1264: if g_debug then
1265: hr_utility.trace('');
1266: hr_utility.trace('index is '||to_char(l_new_index));
1267: hr_utility.trace('scope is '||p_tco_bb(l_new_index).scope);
1268: hr_utility.trace('bb id '||to_char(p_tco_bb(l_new_index).time_building_block_id));
1269: hr_utility.trace('parent bb id '||to_char(p_tco_bb(l_new_index).parent_building_block_id));
1270: hr_utility.trace('start '||to_char(p_tco_bb(l_new_index).start_time, 'dd-mon-yy'));
1271: hr_utility.trace('measure '||to_char(p_tco_bb(l_new_index).measure));
1272: hr_utility.trace('');
1265: hr_utility.trace('');
1266: hr_utility.trace('index is '||to_char(l_new_index));
1267: hr_utility.trace('scope is '||p_tco_bb(l_new_index).scope);
1268: hr_utility.trace('bb id '||to_char(p_tco_bb(l_new_index).time_building_block_id));
1269: hr_utility.trace('parent bb id '||to_char(p_tco_bb(l_new_index).parent_building_block_id));
1270: hr_utility.trace('start '||to_char(p_tco_bb(l_new_index).start_time, 'dd-mon-yy'));
1271: hr_utility.trace('measure '||to_char(p_tco_bb(l_new_index).measure));
1272: hr_utility.trace('');
1273: end if;
1266: hr_utility.trace('index is '||to_char(l_new_index));
1267: hr_utility.trace('scope is '||p_tco_bb(l_new_index).scope);
1268: hr_utility.trace('bb id '||to_char(p_tco_bb(l_new_index).time_building_block_id));
1269: hr_utility.trace('parent bb id '||to_char(p_tco_bb(l_new_index).parent_building_block_id));
1270: hr_utility.trace('start '||to_char(p_tco_bb(l_new_index).start_time, 'dd-mon-yy'));
1271: hr_utility.trace('measure '||to_char(p_tco_bb(l_new_index).measure));
1272: hr_utility.trace('');
1273: end if;
1274:
1267: hr_utility.trace('scope is '||p_tco_bb(l_new_index).scope);
1268: hr_utility.trace('bb id '||to_char(p_tco_bb(l_new_index).time_building_block_id));
1269: hr_utility.trace('parent bb id '||to_char(p_tco_bb(l_new_index).parent_building_block_id));
1270: hr_utility.trace('start '||to_char(p_tco_bb(l_new_index).start_time, 'dd-mon-yy'));
1271: hr_utility.trace('measure '||to_char(p_tco_bb(l_new_index).measure));
1272: hr_utility.trace('');
1273: end if;
1274:
1275: l_new_index := p_tco_bb.NEXT(l_new_index);
1268: hr_utility.trace('bb id '||to_char(p_tco_bb(l_new_index).time_building_block_id));
1269: hr_utility.trace('parent bb id '||to_char(p_tco_bb(l_new_index).parent_building_block_id));
1270: hr_utility.trace('start '||to_char(p_tco_bb(l_new_index).start_time, 'dd-mon-yy'));
1271: hr_utility.trace('measure '||to_char(p_tco_bb(l_new_index).measure));
1272: hr_utility.trace('');
1273: end if;
1274:
1275: l_new_index := p_tco_bb.NEXT(l_new_index);
1276:
1282:
1283: FOR p IN l_period_tab.FIRST .. l_period_tab.LAST
1284: LOOP
1285: if g_debug then
1286: hr_utility.set_location('Processing '||l_proc, 40);
1287: end if;
1288:
1289: IF ( hxc_time_entry_rules_utils_pkg.return_archived_status(l_period_tab(p)) = false )
1290: THEN
1295: IF ( NOT check_commit ( p_messages, p_timecard_info ) )
1296: THEN
1297:
1298: if g_debug then
1299: hr_utility.trace('Exiting period loop - check_commit');
1300: end if;
1301: EXIT;
1302:
1303: END IF;
1310: , p_tco_bb => p_tco_bb
1311: , p_tco_att => p_tco_att );
1312:
1313: if g_debug then
1314: hr_utility.trace('TER INC PTO plan id is '||hxc_time_entry_rules_utils_pkg.g_ter_record.ter_inc_pto_plan_id);
1315: end if;
1316:
1317: IF ( hxc_time_entry_rules_utils_pkg.g_ter_record.ter_inc_pto_plan_id IS NOT NULL )
1318: THEN
1327:
1328: END IF;
1329:
1330: if g_debug then
1331: hr_utility.set_location('Processing '||l_proc, 50);
1332: end if;
1333:
1334: -- now call the formula
1335:
1333:
1334: -- now call the formula
1335:
1336: if g_debug then
1337: hr_utility.trace('consider zero hours is '||l_consider_zero_hours);
1338: end if;
1339:
1340: IF ( l_consider_zero_hours = 'Y' OR ( l_consider_zero_hours = 'N' AND l_timecard_hrs > 0 ) )
1341: THEN
1340: IF ( l_consider_zero_hours = 'Y' OR ( l_consider_zero_hours = 'N' AND l_timecard_hrs > 0 ) )
1341: THEN
1342:
1343: if g_debug then
1344: hr_utility.trace('Calling ff dict . formula');
1345: end if;
1346:
1347: l_outputs := hxc_ff_dict.formula (
1348: p_formula_id => p_rule_record.formula_id
1360: , p_duration_in_days => l_duration_in_days
1361: , p_param_rec => l_param_rec );
1362:
1363: if g_debug then
1364: hr_utility.set_location('Processing '||l_proc, 60);
1365: end if;
1366:
1367: l_message_table.DELETE;
1368:
1366:
1367: l_message_table.DELETE;
1368:
1369: if g_debug then
1370: hr_utility.trace('l_outputs.COUNT = '||l_outputs.COUNT);
1371: end if;
1372:
1373: IF (l_outputs.COUNT > 0) THEN -- Bug 8875292
1374: FOR l_count IN l_outputs.FIRST .. l_outputs.LAST
1438: END LOOP; -- formula outputs loop
1439: END IF; -- Bug 8875292
1440:
1441: if g_debug then
1442: hr_utility.set_location('Processing '||l_proc, 70);
1443: end if;
1444:
1445: -- populate message table
1446:
1449: IF ( ( l_result = 'E' ) AND ( l_message_table.COUNT <> 0 ) )
1450: THEN
1451:
1452: if g_debug then
1453: hr_utility.set_location('Processing '||l_proc, 80);
1454: end if;
1455:
1456: l_message_count := l_message_table.FIRST;
1457:
1458: WHILE l_message_count IS NOT NULL
1459: LOOP
1460:
1461: if g_debug then
1462: hr_utility.set_location('Processing '||l_proc, 90);
1463: end if;
1464:
1465: IF ( l_message_table(l_message_count).name IS NOT NULL )
1466: THEN
1511: end if; -- hxc_time_entry_rules_utils_pkg.return_archived_status(l_period_tab(p)) = false )
1512:
1513:
1514: if g_debug then
1515: hr_utility.set_location('Processing '||l_proc, 100);
1516: end if;
1517:
1518: END LOOP; -- t_periods
1519:
1517:
1518: END LOOP; -- t_periods
1519:
1520: if g_debug then
1521: hr_utility.trace('After period loop');
1522: end if;
1523:
1524: if g_debug then
1525: hr_utility.set_location('Processing '||l_proc, 110);
1521: hr_utility.trace('After period loop');
1522: end if;
1523:
1524: if g_debug then
1525: hr_utility.set_location('Processing '||l_proc, 110);
1526: end if;
1527:
1528: -- reset variables
1529:
1989:
1990:
1991: if g_debug then
1992: l_proc := g_package||'execute_field_combo_rule';
1993: hr_utility.set_location('Processing '||l_proc, 10);
1994: end if;
1995:
1996: hxc_ff_dict.decode_formula_segments (
1997: p_formula_name => p_formula_name
2001: , p_reference_value => l_reference_period
2002: , p_consider_zero_hours => l_consider_zero_hours );
2003:
2004: if g_debug then
2005: hr_utility.trace(' ************* Param values are.... ************ ');
2006: hr_utility.trace('');
2007: hr_utility.trace(' Rule name is '||p_rule_record.name);
2008: hr_utility.trace('');
2009: hr_utility.trace(' Time Category ID I is '||l_param_rec.param1_value);
2002: , p_consider_zero_hours => l_consider_zero_hours );
2003:
2004: if g_debug then
2005: hr_utility.trace(' ************* Param values are.... ************ ');
2006: hr_utility.trace('');
2007: hr_utility.trace(' Rule name is '||p_rule_record.name);
2008: hr_utility.trace('');
2009: hr_utility.trace(' Time Category ID I is '||l_param_rec.param1_value);
2010: hr_utility.trace(' Time Category ID II is '||l_param_rec.param2_value);
2003:
2004: if g_debug then
2005: hr_utility.trace(' ************* Param values are.... ************ ');
2006: hr_utility.trace('');
2007: hr_utility.trace(' Rule name is '||p_rule_record.name);
2008: hr_utility.trace('');
2009: hr_utility.trace(' Time Category ID I is '||l_param_rec.param1_value);
2010: hr_utility.trace(' Time Category ID II is '||l_param_rec.param2_value);
2011: end if;
2004: if g_debug then
2005: hr_utility.trace(' ************* Param values are.... ************ ');
2006: hr_utility.trace('');
2007: hr_utility.trace(' Rule name is '||p_rule_record.name);
2008: hr_utility.trace('');
2009: hr_utility.trace(' Time Category ID I is '||l_param_rec.param1_value);
2010: hr_utility.trace(' Time Category ID II is '||l_param_rec.param2_value);
2011: end if;
2012:
2005: hr_utility.trace(' ************* Param values are.... ************ ');
2006: hr_utility.trace('');
2007: hr_utility.trace(' Rule name is '||p_rule_record.name);
2008: hr_utility.trace('');
2009: hr_utility.trace(' Time Category ID I is '||l_param_rec.param1_value);
2010: hr_utility.trace(' Time Category ID II is '||l_param_rec.param2_value);
2011: end if;
2012:
2013: l_tc_id_1 := to_number(l_param_rec.param1_value);
2006: hr_utility.trace('');
2007: hr_utility.trace(' Rule name is '||p_rule_record.name);
2008: hr_utility.trace('');
2009: hr_utility.trace(' Time Category ID I is '||l_param_rec.param1_value);
2010: hr_utility.trace(' Time Category ID II is '||l_param_rec.param2_value);
2011: end if;
2012:
2013: l_tc_id_1 := to_number(l_param_rec.param1_value);
2014: l_tc_id_2 := to_number(l_param_rec.param2_value);
2013: l_tc_id_1 := to_number(l_param_rec.param1_value);
2014: l_tc_id_2 := to_number(l_param_rec.param2_value);
2015:
2016: if g_debug then
2017: hr_utility.set_location('Processing '||l_proc, 20);
2018: end if;
2019:
2020: -- we always have to intialise the first time category so do it now
2021:
2023: p_time_category_id => l_tc_id_1
2024: , p_tco_att => p_tco_att );
2025:
2026: if g_debug then
2027: hr_utility.set_location('Processing '||l_proc, 30);
2028: end if;
2029:
2030: -- now process the first time category
2031:
2147: *****************************************************************/
2148:
2149: BEGIN -- execute_time_entry_rules
2150:
2151: g_debug := hr_utility.debug_enabled;
2152:
2153: if g_debug then
2154: l_proc := g_package||'execute_time_entry_rules';
2155: hr_utility.set_location('Processing '||l_proc, 10);
2151: g_debug := hr_utility.debug_enabled;
2152:
2153: if g_debug then
2154: l_proc := g_package||'execute_time_entry_rules';
2155: hr_utility.set_location('Processing '||l_proc, 10);
2156: end if;
2157:
2158: get_timecard_info (
2159: p_time_building_blocks => p_time_building_blocks
2214: -- loop through the time entry rules based on the resource's
2215: -- preference and get the message level
2216:
2217: if g_debug then
2218: hr_utility.set_location('Processing '||l_proc, 20);
2219: end if;
2220:
2221: l_rules_evl := hxc_preference_evaluation.resource_preferences(
2222: p_resource_id => l_timecard_info_rec.resource_id
2241:
2242: l_terg_id := l_pref_table(1).attribute1 ;
2243:
2244: if g_debug then
2245: hr_utility.set_location('Processing '||l_proc, 25);
2246: end if;
2247:
2248: FOR r_rules IN csr_get_rules ( p_terg_id => l_terg_id
2249: , p_start_date => l_timecard_info_rec.start_date
2249: , p_start_date => l_timecard_info_rec.start_date
2250: , p_end_date => l_timecard_info_rec.end_date )
2251: LOOP
2252: if g_debug then
2253: hr_utility.set_location('Processing '||l_proc, 30);
2254: end if;
2255:
2256: -- GPM v115.61 2180942
2257:
2255:
2256: -- GPM v115.61 2180942
2257:
2258: if g_debug then
2259: hr_utility.trace('GAZ OPERATION IS '||p_operation);
2260: hr_utility.trace('GAZ RESUBMIT IS '||p_resubmit);
2261: end if;
2262:
2263: -- maintain global record of TER info
2256: -- GPM v115.61 2180942
2257:
2258: if g_debug then
2259: hr_utility.trace('GAZ OPERATION IS '||p_operation);
2260: hr_utility.trace('GAZ RESUBMIT IS '||p_resubmit);
2261: end if;
2262:
2263: -- maintain global record of TER info
2264:
2277: )
2278: THEN
2279:
2280: if g_debug then
2281: hr_utility.trace('');
2282: hr_utility.trace('********** Rule Name is '||r_rules.name||' **************');
2283: hr_utility.trace('');
2284: end if;
2285:
2278: THEN
2279:
2280: if g_debug then
2281: hr_utility.trace('');
2282: hr_utility.trace('********** Rule Name is '||r_rules.name||' **************');
2283: hr_utility.trace('');
2284: end if;
2285:
2286: IF ( r_rules.formula_id IS NULL )
2279:
2280: if g_debug then
2281: hr_utility.trace('');
2282: hr_utility.trace('********** Rule Name is '||r_rules.name||' **************');
2283: hr_utility.trace('');
2284: end if;
2285:
2286: IF ( r_rules.formula_id IS NULL )
2287: THEN
2285:
2286: IF ( r_rules.formula_id IS NULL )
2287: THEN
2288: if g_debug then
2289: hr_utility.set_location('Processing '||l_proc, 40);
2290: end if;
2291: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2292: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'hxc_time_entry_rules', 'after 40');
2293: end if;
2314:
2315: ELSIF ( r_rules.formula_id IS NOT NULL AND r_rules.mapping_id IS NOT NULL )
2316: THEN
2317: if g_debug then
2318: hr_utility.set_location('Processing '||l_proc, 50);
2319: end if;
2320:
2321: IF ( hxc_mapping_utilities.chk_mapping_changed(
2322: p_mapping_id => r_rules.mapping_id
2331: ,p_called_from => 'TIME_ENTRY'
2332: ))
2333: THEN
2334: if g_debug then
2335: hr_utility.set_location('Processing '||l_proc, 60);
2336: end if;
2337:
2338: execute_formula ( p_formula_name=> r_rules.formula_name
2339: , p_message_table => p_messages
2347:
2348: ELSE -- basically means ( r_rules.formula_id IS NOT NULL AND r_rules.mapping_id IS NULL )
2349:
2350: if g_debug then
2351: hr_utility.set_location('Processing '||l_proc, 70);
2352: end if;
2353:
2354: -- special case for Field Combination rules
2355:
2393:
2394: END LOOP; -- csr_get_rules
2395:
2396: if g_debug then
2397: hr_utility.set_location('Processing '||l_proc, 75);
2398: end if;
2399:
2400: EXCEPTION WHEN OTHERS THEN
2401:
2399:
2400: EXCEPTION WHEN OTHERS THEN
2401:
2402: if g_debug then
2403: hr_utility.trace('SQLERRM is '||SQLERRM);
2404: end if;
2405:
2406: hxc_time_entry_rules_utils_pkg.add_error_to_table (
2407: p_message_table => p_messages
2538:
2539:
2540: BEGIN -- period_maximum
2541:
2542: g_debug := hr_utility.debug_enabled;
2543:
2544: if g_debug then
2545: l_proc := g_package||'period_maximum';
2546: hr_utility.set_location('Processing '||l_proc, 10);
2542: g_debug := hr_utility.debug_enabled;
2543:
2544: if g_debug then
2545: l_proc := g_package||'period_maximum';
2546: hr_utility.set_location('Processing '||l_proc, 10);
2547:
2548: hr_utility.trace('Lets see what is in the structure');
2549: end if;
2550:
2544: if g_debug then
2545: l_proc := g_package||'period_maximum';
2546: hr_utility.set_location('Processing '||l_proc, 10);
2547:
2548: hr_utility.trace('Lets see what is in the structure');
2549: end if;
2550:
2551: l_tc_bld_blks := hxc_self_service_time_deposit.get_building_blocks;
2552:
2555: while l_tc_ind is not null
2556: loop
2557:
2558: if g_debug then
2559: hr_utility.trace('scope is '||l_tc_bld_blks(l_tc_ind).scope);
2560: hr_utility.trace('bb id is '||to_number(l_tc_bld_blks(l_tc_ind).time_building_Block_id));
2561: hr_utility.trace('new is '||l_tc_bld_blks(l_tc_ind).new);
2562: hr_utility.trace('changed is '||l_tc_bld_blks(l_tc_ind).changed);
2563: end if;
2556: loop
2557:
2558: if g_debug then
2559: hr_utility.trace('scope is '||l_tc_bld_blks(l_tc_ind).scope);
2560: hr_utility.trace('bb id is '||to_number(l_tc_bld_blks(l_tc_ind).time_building_Block_id));
2561: hr_utility.trace('new is '||l_tc_bld_blks(l_tc_ind).new);
2562: hr_utility.trace('changed is '||l_tc_bld_blks(l_tc_ind).changed);
2563: end if;
2564:
2557:
2558: if g_debug then
2559: hr_utility.trace('scope is '||l_tc_bld_blks(l_tc_ind).scope);
2560: hr_utility.trace('bb id is '||to_number(l_tc_bld_blks(l_tc_ind).time_building_Block_id));
2561: hr_utility.trace('new is '||l_tc_bld_blks(l_tc_ind).new);
2562: hr_utility.trace('changed is '||l_tc_bld_blks(l_tc_ind).changed);
2563: end if;
2564:
2565: l_tc_ind := l_tc_bld_blks.NEXT(l_tc_ind);
2558: if g_debug then
2559: hr_utility.trace('scope is '||l_tc_bld_blks(l_tc_ind).scope);
2560: hr_utility.trace('bb id is '||to_number(l_tc_bld_blks(l_tc_ind).time_building_Block_id));
2561: hr_utility.trace('new is '||l_tc_bld_blks(l_tc_ind).new);
2562: hr_utility.trace('changed is '||l_tc_bld_blks(l_tc_ind).changed);
2563: end if;
2564:
2565: l_tc_ind := l_tc_bld_blks.NEXT(l_tc_ind);
2566:
2618:
2619: IF ( l_db_pre_period_start IS NOT NULL AND l_db_post_period_start IS NOT NULL )
2620: THEN
2621: if g_debug then
2622: hr_utility.set_location('Processing '||l_proc, 20);
2623: end if;
2624:
2625: -- now lets get the total hours worked based on the pre TC window
2626:
2628: FETCH csr_get_total_hrs INTO l_hrs;
2629: CLOSE csr_get_total_hrs;
2630:
2631: if g_debug then
2632: hr_utility.trace('');
2633: hr_utility.trace('Pre period hours are '||to_char(l_hrs));
2634: hr_utility.trace('');
2635: end if;
2636:
2629: CLOSE csr_get_total_hrs;
2630:
2631: if g_debug then
2632: hr_utility.trace('');
2633: hr_utility.trace('Pre period hours are '||to_char(l_hrs));
2634: hr_utility.trace('');
2635: end if;
2636:
2637: l_total_hrs := l_hrs;
2630:
2631: if g_debug then
2632: hr_utility.trace('');
2633: hr_utility.trace('Pre period hours are '||to_char(l_hrs));
2634: hr_utility.trace('');
2635: end if;
2636:
2637: l_total_hrs := l_hrs;
2638:
2644: FETCH csr_get_total_hrs INTO l_hrs;
2645: CLOSE csr_get_total_hrs;
2646:
2647: if g_debug then
2648: hr_utility.trace('Post period hours are '||to_char(l_hrs));
2649: hr_utility.trace('');
2650: end if;
2651:
2652: l_total_hrs := l_total_hrs + l_hrs + p_timecard_hrs;
2645: CLOSE csr_get_total_hrs;
2646:
2647: if g_debug then
2648: hr_utility.trace('Post period hours are '||to_char(l_hrs));
2649: hr_utility.trace('');
2650: end if;
2651:
2652: l_total_hrs := l_total_hrs + l_hrs + p_timecard_hrs;
2653:
2666: FETCH csr_get_total_hrs INTO l_hrs;
2667: CLOSE csr_get_total_hrs;
2668:
2669: if g_debug then
2670: hr_utility.trace('');
2671: hr_utility.trace('Pre period hours are '||to_char(l_hrs));
2672: hr_utility.trace('');
2673: end if;
2674:
2667: CLOSE csr_get_total_hrs;
2668:
2669: if g_debug then
2670: hr_utility.trace('');
2671: hr_utility.trace('Pre period hours are '||to_char(l_hrs));
2672: hr_utility.trace('');
2673: end if;
2674:
2675: l_total_hrs := l_total_hrs - l_hrs;
2668:
2669: if g_debug then
2670: hr_utility.trace('');
2671: hr_utility.trace('Pre period hours are '||to_char(l_hrs));
2672: hr_utility.trace('');
2673: end if;
2674:
2675: l_total_hrs := l_total_hrs - l_hrs;
2676:
2682: FETCH csr_get_total_hrs INTO l_hrs;
2683: CLOSE csr_get_total_hrs;
2684:
2685: if g_debug then
2686: hr_utility.trace('Post period hours are '||to_char(l_hrs));
2687: hr_utility.trace('');
2688: end if;
2689:
2690: l_total_hrs := l_total_hrs - l_hrs;
2683: CLOSE csr_get_total_hrs;
2684:
2685: if g_debug then
2686: hr_utility.trace('Post period hours are '||to_char(l_hrs));
2687: hr_utility.trace('');
2688: end if;
2689:
2690: l_total_hrs := l_total_hrs - l_hrs;
2691:
2695:
2696: ELSIF ( l_db_pre_period_start IS NOT NULL )
2697: THEN
2698: if g_debug then
2699: hr_utility.set_location('Processing '||l_proc, 30);
2700: end if;
2701:
2702: -- now lets get the total hours worked based on the pre TC window
2703:
2705: FETCH csr_get_total_hrs INTO l_hrs;
2706: CLOSE csr_get_total_hrs;
2707:
2708: if g_debug then
2709: hr_utility.trace('');
2710: hr_utility.trace('Pre period hours are '||to_char(l_hrs));
2711: hr_utility.trace('');
2712: end if;
2713:
2706: CLOSE csr_get_total_hrs;
2707:
2708: if g_debug then
2709: hr_utility.trace('');
2710: hr_utility.trace('Pre period hours are '||to_char(l_hrs));
2711: hr_utility.trace('');
2712: end if;
2713:
2714: l_total_hrs := l_total_hrs + l_hrs + p_timecard_hrs;
2707:
2708: if g_debug then
2709: hr_utility.trace('');
2710: hr_utility.trace('Pre period hours are '||to_char(l_hrs));
2711: hr_utility.trace('');
2712: end if;
2713:
2714: l_total_hrs := l_total_hrs + l_hrs + p_timecard_hrs;
2715:
2728: FETCH csr_get_total_hrs INTO l_hrs;
2729: CLOSE csr_get_total_hrs;
2730:
2731: if g_debug then
2732: hr_utility.trace('');
2733: hr_utility.trace('Pre period hours are '||to_char(l_hrs));
2734: hr_utility.trace('');
2735: end if;
2736:
2729: CLOSE csr_get_total_hrs;
2730:
2731: if g_debug then
2732: hr_utility.trace('');
2733: hr_utility.trace('Pre period hours are '||to_char(l_hrs));
2734: hr_utility.trace('');
2735: end if;
2736:
2737: l_total_hrs := l_total_hrs - l_hrs;
2730:
2731: if g_debug then
2732: hr_utility.trace('');
2733: hr_utility.trace('Pre period hours are '||to_char(l_hrs));
2734: hr_utility.trace('');
2735: end if;
2736:
2737: l_total_hrs := l_total_hrs - l_hrs;
2738:
2742:
2743: ELSIF( l_db_post_period_start IS NOT NULL )
2744: THEN
2745: if g_debug then
2746: hr_utility.set_location('Processing '||l_proc, 40);
2747: end if;
2748:
2749: -- now lets get the total hours worked based on the post TC window
2750:
2752: FETCH csr_get_total_hrs INTO l_hrs;
2753: CLOSE csr_get_total_hrs;
2754:
2755: if g_debug then
2756: hr_utility.trace('');
2757: hr_utility.trace('Post period hours are '||to_char(l_hrs));
2758: hr_utility.trace('');
2759: end if;
2760:
2753: CLOSE csr_get_total_hrs;
2754:
2755: if g_debug then
2756: hr_utility.trace('');
2757: hr_utility.trace('Post period hours are '||to_char(l_hrs));
2758: hr_utility.trace('');
2759: end if;
2760:
2761: l_total_hrs := l_hrs + p_timecard_hrs;
2754:
2755: if g_debug then
2756: hr_utility.trace('');
2757: hr_utility.trace('Post period hours are '||to_char(l_hrs));
2758: hr_utility.trace('');
2759: end if;
2760:
2761: l_total_hrs := l_hrs + p_timecard_hrs;
2762:
2775: FETCH csr_get_total_hrs INTO l_hrs;
2776: CLOSE csr_get_total_hrs;
2777:
2778: if g_debug then
2779: hr_utility.trace('Post period hours are '||to_char(l_hrs));
2780: hr_utility.trace('');
2781: end if;
2782:
2783: l_total_hrs := l_total_hrs - l_hrs;
2776: CLOSE csr_get_total_hrs;
2777:
2778: if g_debug then
2779: hr_utility.trace('Post period hours are '||to_char(l_hrs));
2780: hr_utility.trace('');
2781: end if;
2782:
2783: l_total_hrs := l_total_hrs - l_hrs;
2784:
2787: END IF;
2788:
2789: ELSE
2790: if g_debug then
2791: hr_utility.set_location('Processing '||l_proc, 50);
2792: end if;
2793:
2794: -- i.e. the whole time entry rule period is
2795: -- encompassed by the TCO
2797: l_total_hrs := p_timecard_hrs;
2798:
2799: END IF;
2800: if g_debug then
2801: hr_utility.set_location('Processing '||l_proc, 60);
2802: end if;
2803:
2804: IF ( l_db_ref_period_start IS NOT NULL )
2805: THEN
2814:
2815: l_total_hrs := (( l_total_hrs + l_ref_period_hrs ) / l_number_of_periods );
2816:
2817: if g_debug then
2818: hr_utility.trace('');
2819: hr_utility.trace('************* reference period info ****************');
2820: hr_utility.trace('reference period start is '||TO_CHAR(l_db_ref_period_start, 'DD-MON-YY HH24:MI:SS'));
2821: hr_utility.trace('reference period end is '||TO_CHAR(l_db_ref_period_end , 'DD-MON-YY HH24:MI:SS'));
2822: hr_utility.trace('number of periods is '||TO_CHAR(l_number_of_periods));
2815: l_total_hrs := (( l_total_hrs + l_ref_period_hrs ) / l_number_of_periods );
2816:
2817: if g_debug then
2818: hr_utility.trace('');
2819: hr_utility.trace('************* reference period info ****************');
2820: hr_utility.trace('reference period start is '||TO_CHAR(l_db_ref_period_start, 'DD-MON-YY HH24:MI:SS'));
2821: hr_utility.trace('reference period end is '||TO_CHAR(l_db_ref_period_end , 'DD-MON-YY HH24:MI:SS'));
2822: hr_utility.trace('number of periods is '||TO_CHAR(l_number_of_periods));
2823: hr_utility.trace('ref period hours are '||to_char(l_ref_period_hrs));
2816:
2817: if g_debug then
2818: hr_utility.trace('');
2819: hr_utility.trace('************* reference period info ****************');
2820: hr_utility.trace('reference period start is '||TO_CHAR(l_db_ref_period_start, 'DD-MON-YY HH24:MI:SS'));
2821: hr_utility.trace('reference period end is '||TO_CHAR(l_db_ref_period_end , 'DD-MON-YY HH24:MI:SS'));
2822: hr_utility.trace('number of periods is '||TO_CHAR(l_number_of_periods));
2823: hr_utility.trace('ref period hours are '||to_char(l_ref_period_hrs));
2824: end if;
2817: if g_debug then
2818: hr_utility.trace('');
2819: hr_utility.trace('************* reference period info ****************');
2820: hr_utility.trace('reference period start is '||TO_CHAR(l_db_ref_period_start, 'DD-MON-YY HH24:MI:SS'));
2821: hr_utility.trace('reference period end is '||TO_CHAR(l_db_ref_period_end , 'DD-MON-YY HH24:MI:SS'));
2822: hr_utility.trace('number of periods is '||TO_CHAR(l_number_of_periods));
2823: hr_utility.trace('ref period hours are '||to_char(l_ref_period_hrs));
2824: end if;
2825:
2818: hr_utility.trace('');
2819: hr_utility.trace('************* reference period info ****************');
2820: hr_utility.trace('reference period start is '||TO_CHAR(l_db_ref_period_start, 'DD-MON-YY HH24:MI:SS'));
2821: hr_utility.trace('reference period end is '||TO_CHAR(l_db_ref_period_end , 'DD-MON-YY HH24:MI:SS'));
2822: hr_utility.trace('number of periods is '||TO_CHAR(l_number_of_periods));
2823: hr_utility.trace('ref period hours are '||to_char(l_ref_period_hrs));
2824: end if;
2825:
2826: END IF;
2819: hr_utility.trace('************* reference period info ****************');
2820: hr_utility.trace('reference period start is '||TO_CHAR(l_db_ref_period_start, 'DD-MON-YY HH24:MI:SS'));
2821: hr_utility.trace('reference period end is '||TO_CHAR(l_db_ref_period_end , 'DD-MON-YY HH24:MI:SS'));
2822: hr_utility.trace('number of periods is '||TO_CHAR(l_number_of_periods));
2823: hr_utility.trace('ref period hours are '||to_char(l_ref_period_hrs));
2824: end if;
2825:
2826: END IF;
2827:
2825:
2826: END IF;
2827:
2828: if g_debug then
2829: hr_utility.trace('period maximum is '||to_char(p_period_maximum));
2830: hr_utility.trace('total hours are '||to_char(l_total_hrs));
2831: hr_utility.trace('');
2832: end if;
2833:
2826: END IF;
2827:
2828: if g_debug then
2829: hr_utility.trace('period maximum is '||to_char(p_period_maximum));
2830: hr_utility.trace('total hours are '||to_char(l_total_hrs));
2831: hr_utility.trace('');
2832: end if;
2833:
2834: if g_debug then
2827:
2828: if g_debug then
2829: hr_utility.trace('period maximum is '||to_char(p_period_maximum));
2830: hr_utility.trace('total hours are '||to_char(l_total_hrs));
2831: hr_utility.trace('');
2832: end if;
2833:
2834: if g_debug then
2835: hr_utility.set_location('Processing '||l_proc, 70);
2831: hr_utility.trace('');
2832: end if;
2833:
2834: if g_debug then
2835: hr_utility.set_location('Processing '||l_proc, 70);
2836: end if;
2837:
2838: -- WWB 3738796
2839: -- check to see if period max is being called from a TER which is using the seeded PTO formula
2931:
2932: END IF; -- g_ter_record.ter_formula_name = 'HXC_PTO_ACCRUAL_COMPARISON'
2933:
2934: if g_debug then
2935: hr_utility.set_location('Processing '||l_proc, 70);
2936: end if;
2937:
2938: END period_maximum;
2939:
3024: l_dummy NUMBER(1);
3025:
3026: BEGIN
3027:
3028: g_debug := hr_utility.debug_enabled;
3029:
3030: if g_debug then
3031: l_proc := g_package||'tc_edit_allowed';
3032: hr_utility.set_location('Entering '||l_proc, 10);
3028: g_debug := hr_utility.debug_enabled;
3029:
3030: if g_debug then
3031: l_proc := g_package||'tc_edit_allowed';
3032: hr_utility.set_location('Entering '||l_proc, 10);
3033: end if;
3034:
3035: -- GPM v115.25
3036: -- WWB - 2109325
3042: l_tc_status := p_timecard_status;
3043: end if;
3044:
3045: if g_debug then
3046: hr_utility.set_location('Processing '||l_proc, 20);
3047: end if;
3048:
3049:
3050: IF ( p_edit_allowed_preference = 'NEW_WORKING_REJECTED' )
3049:
3050: IF ( p_edit_allowed_preference = 'NEW_WORKING_REJECTED' )
3051: THEN
3052: if g_debug then
3053: hr_utility.set_location('Processing '||l_proc, 30);
3054: end if;
3055:
3056: IF ( ( l_tc_status = 'REJECTED' ) OR ( l_tc_status = 'WORKING' ) )
3057: THEN
3062:
3063: ELSIF ( p_edit_allowed_preference = 'SUBMITTED' )
3064: THEN
3065: if g_debug then
3066: hr_utility.set_location('Processing '||l_proc, 40);
3067: end if;
3068:
3069: IF ( ( l_tc_status = 'REJECTED' ) OR ( l_tc_status = 'WORKING' ) OR ( l_tc_status = 'SUBMITTED' ) )
3070: THEN
3075:
3076: ELSIF ( p_edit_allowed_preference = 'APPROVALS_INITIATED' )
3077: THEN
3078: if g_debug then
3079: hr_utility.set_location('Processing '||l_proc, 50);
3080: end if;
3081:
3082: -- all we need to do here is check that this timecard
3083: -- has not been transferred successfully to any recipient
3095:
3096: ELSIF ( p_edit_allowed_preference = 'RETRO' )
3097: THEN
3098: if g_debug then
3099: hr_utility.set_location('Processing '||l_proc, 60);
3100: end if;
3101:
3102: IF ( ( l_tc_status = 'REJECTED' ) OR ( l_tc_status = 'WORKING' ) OR ( l_tc_status = 'SUBMITTED' )
3103: OR ( l_tc_status = 'APPROVED' ) OR ( l_tc_status = 'ERROR' ) )
3108: END IF;
3109:
3110: ELSE
3111: if g_debug then
3112: hr_utility.set_location('Processing '||l_proc, 70);
3113: end if;
3114:
3115: p_edit_allowed := 'FALSE';
3116:
3123: END IF;
3124:
3125:
3126: if g_debug then
3127: hr_utility.set_location('Leaving '||l_proc, 80);
3128: end if;
3129:
3130: END tc_edit_allowed;
3131:
3177:
3178:
3179: BEGIN
3180:
3181: g_debug := hr_utility.debug_enabled;
3182:
3183: OPEN csr_chk_pto_ok;
3184: FETCH csr_chk_pto_ok INTO l_pto_ok;
3185:
3186: IF csr_chk_pto_ok%FOUND
3187: THEN
3188:
3189: if g_debug then
3190: hr_utility.trace('PTO PLAN OK');
3191: end if;
3192: l_pto_ok := 1;
3193:
3194: ELSE
3193:
3194: ELSE
3195:
3196: if g_debug then
3197: hr_utility.trace('PTO PLAN NOT OK');
3198: end if;
3199:
3200:
3201: END IF;
3218:
3219: l_prefs hxc_preference_evaluation.t_pref_table;
3220:
3221: Begin
3222: g_debug := hr_utility.debug_enabled;
3223:
3224: get_timecard_info (
3225: p_time_building_blocks => p_time_building_blocks
3226: , p_timecard_rec => l_timecard_info_rec );
3224: get_timecard_info (
3225: p_time_building_blocks => p_time_building_blocks
3226: , p_timecard_rec => l_timecard_info_rec );
3227: if g_debug then
3228: hr_utility.trace('After get_timecard_info');
3229: hr_utility.trace('start_date ' || l_timecard_info_rec.start_date);
3230: end if;
3231: -- Start 2944785
3232: /*
3225: p_time_building_blocks => p_time_building_blocks
3226: , p_timecard_rec => l_timecard_info_rec );
3227: if g_debug then
3228: hr_utility.trace('After get_timecard_info');
3229: hr_utility.trace('start_date ' || l_timecard_info_rec.start_date);
3230: end if;
3231: -- Start 2944785
3232: /*
3233: hxc_preference_evaluation.resource_preferences(p_resource_id => l_timecard_info_rec.resource_id,
3260: , p_start_date => l_timecard_info_rec.start_date
3261: , p_end_date => l_timecard_info_rec.end_date )
3262: LOOP
3263: if g_debug then
3264: hr_utility.trace('r_rules.Timecategory_name' || r_rules.attribute2);
3265: hr_utility.trace('r_rules.Recipient Application' || r_rules.attribute1);
3266: end if;
3267: l_time_category_id := r_rules.attribute2;
3268: if g_debug then
3261: , p_end_date => l_timecard_info_rec.end_date )
3262: LOOP
3263: if g_debug then
3264: hr_utility.trace('r_rules.Timecategory_name' || r_rules.attribute2);
3265: hr_utility.trace('r_rules.Recipient Application' || r_rules.attribute1);
3266: end if;
3267: l_time_category_id := r_rules.attribute2;
3268: if g_debug then
3269: hr_utility.trace('Time Category ID' || l_time_category_id);
3265: hr_utility.trace('r_rules.Recipient Application' || r_rules.attribute1);
3266: end if;
3267: l_time_category_id := r_rules.attribute2;
3268: if g_debug then
3269: hr_utility.trace('Time Category ID' || l_time_category_id);
3270: end if;
3271: hxc_time_category_utils_pkg.initialise_time_category(
3272: p_time_category_id => to_number(l_time_category_id),
3273: p_tco_att => P_TIME_ATTRIBUTES);
3292: end loop;
3293: end loop;
3294:
3295: if g_debug then
3296: hr_utility.trace('Message Table');
3297: end if;
3298: n := p_messages.first;
3299: loop
3300: exit when not p_messages.exists(n);
3299: loop
3300: exit when not p_messages.exists(n);
3301: if (p_messages(n).message_level = 'PTE') then
3302: if g_debug then
3303: hr_utility.trace('Time Building Block Id' || p_messages(n).time_building_block_id);
3304: hr_utility.trace('Time Building Block OVN' || p_messages(n).time_building_block_ovn);
3305: hr_utility.trace('Recipient Application ID' || p_messages(n).message_name);
3306: end if;
3307: end if;
3300: exit when not p_messages.exists(n);
3301: if (p_messages(n).message_level = 'PTE') then
3302: if g_debug then
3303: hr_utility.trace('Time Building Block Id' || p_messages(n).time_building_block_id);
3304: hr_utility.trace('Time Building Block OVN' || p_messages(n).time_building_block_ovn);
3305: hr_utility.trace('Recipient Application ID' || p_messages(n).message_name);
3306: end if;
3307: end if;
3308: n := p_messages.next(n);
3301: if (p_messages(n).message_level = 'PTE') then
3302: if g_debug then
3303: hr_utility.trace('Time Building Block Id' || p_messages(n).time_building_block_id);
3304: hr_utility.trace('Time Building Block OVN' || p_messages(n).time_building_block_ovn);
3305: hr_utility.trace('Recipient Application ID' || p_messages(n).message_name);
3306: end if;
3307: end if;
3308: n := p_messages.next(n);
3309: end loop;
3308: n := p_messages.next(n);
3309: end loop;
3310:
3311: if g_debug then
3312: hr_utility.trace('End of execute ELP time entry rules');
3313: end if;
3314:
3315: end execute_ELP_time_entry_rules;
3316:
3337: l_client_tz fnd_timezones_b.timezone_code%type;
3338: l_server_tz fnd_timezones_b.timezone_code%type;
3339: l_client_time DATE;
3340: BEGIN
3341: g_debug := hr_utility.debug_enabled;
3342:
3343: if g_debug then
3344: hr_utility.TRACE ( 'Stop Time '
3345: || p_stop_time);
3340: BEGIN
3341: g_debug := hr_utility.debug_enabled;
3342:
3343: if g_debug then
3344: hr_utility.TRACE ( 'Stop Time '
3345: || p_stop_time);
3346: hr_utility.TRACE ( 'p_st_late_hrs '
3347: || p_st_late_hrs);
3348: hr_utility.TRACE ( 'p_qnt_late_hrs '
3342:
3343: if g_debug then
3344: hr_utility.TRACE ( 'Stop Time '
3345: || p_stop_time);
3346: hr_utility.TRACE ( 'p_st_late_hrs '
3347: || p_st_late_hrs);
3348: hr_utility.TRACE ( 'p_qnt_late_hrs '
3349: || p_qnt_late_hrs);
3350: end if;
3344: hr_utility.TRACE ( 'Stop Time '
3345: || p_stop_time);
3346: hr_utility.TRACE ( 'p_st_late_hrs '
3347: || p_st_late_hrs);
3348: hr_utility.TRACE ( 'p_qnt_late_hrs '
3349: || p_qnt_late_hrs);
3350: end if;
3351: --Fix for Bug No:4948883
3352: fnd_date.timezones_enabled := true;
3358: THEN
3359: l_late_measure := ( l_client_time - p_stop_time
3360: ) * 24;
3361: if g_debug then
3362: hr_utility.TRACE ( 'l_late_measure '
3363: || l_late_measure);
3364: end if;
3365:
3366: IF (l_late_measure > p_st_late_hrs)
3368: RETURN TRUE;
3369: END IF;
3370: ELSE
3371: if g_debug then
3372: hr_utility.trace('L_date_worked...............' || to_char(p_date_worked,'dd-mon-rrrr hh:mi:ss'));
3373: end if;
3374: IF (( TRUNC (p_date_worked)
3375: + (p_qnt_late_hrs / 24)
3376: ) < l_client_time
3376: ) < l_client_time
3377: )
3378: THEN
3379: if g_debug then
3380: hr_utility.TRACE ('Late.....');
3381: end if;
3382: RETURN TRUE;
3383: END IF;
3384: END IF;
3480: BEGIN
3481:
3482:
3483: if g_debug then
3484: hr_utility.TRACE ('Start of populate old tco');
3485: end if;
3486: p_timecard_building_blocks.DELETE;
3487: p_timecard_attributes.DELETE;
3488: l_tbb_index := 0;
3490:
3491: FOR r_det_rec IN csr_get_det_bbs
3492: LOOP
3493: if g_debug then
3494: hr_utility.TRACE (
3495: 'r_det_rec.time_building_block_id '
3496: || r_det_rec.time_building_block_id
3497: );
3498: hr_utility.TRACE (
3494: hr_utility.TRACE (
3495: 'r_det_rec.time_building_block_id '
3496: || r_det_rec.time_building_block_id
3497: );
3498: hr_utility.TRACE (
3499: 'r_det_rec.object_version_number '
3500: || r_det_rec.object_version_number
3501: );
3502: end if;
3546: r_det_rec.object_version_number
3547: )
3548: LOOP
3549: if g_debug then
3550: hr_utility.TRACE (
3551: 'Attribute Id'
3552: || r_der_attr.time_attribute_id
3553: );
3554: hr_utility.TRACE (
3550: hr_utility.TRACE (
3551: 'Attribute Id'
3552: || r_der_attr.time_attribute_id
3553: );
3554: hr_utility.TRACE (
3555: 'Attribute Category '
3556: || r_der_attr.attribute_category
3557: );
3558: end if;
3636: END LOOP;
3637: END LOOP;
3638:
3639: if g_debug then
3640: hr_utility.TRACE ('Leaving populate old tco');
3641: end if;
3642: END populate_old_tco;
3643:
3644: FUNCTION compare_tbb_attributes (
3721: p_change_att_tab(l_change_att_index).changed_attribute :='ATTRIBUTE1';
3722: l_change_att_index := l_change_att_index+1;
3723:
3724: if g_debug then
3725: hr_utility.TRACE ('Att1');
3726: hr_utility.TRACE ( 'l_mapping_name '
3727: || l_mapping_name);
3728: hr_utility.TRACE ( 'l_return_mapp '
3729: || l_return_mapp);
3722: l_change_att_index := l_change_att_index+1;
3723:
3724: if g_debug then
3725: hr_utility.TRACE ('Att1');
3726: hr_utility.TRACE ( 'l_mapping_name '
3727: || l_mapping_name);
3728: hr_utility.TRACE ( 'l_return_mapp '
3729: || l_return_mapp);
3730: end if;
3724: if g_debug then
3725: hr_utility.TRACE ('Att1');
3726: hr_utility.TRACE ( 'l_mapping_name '
3727: || l_mapping_name);
3728: hr_utility.TRACE ( 'l_return_mapp '
3729: || l_return_mapp);
3730: end if;
3731: l_return_mapp := l_return_mapp
3732: || ':'
3758: p_change_att_tab(l_change_att_index).changed_attribute :='ATTRIBUTE2';
3759: l_change_att_index := l_change_att_index+1;
3760:
3761: if g_debug then
3762: hr_utility.TRACE ('Att2');
3763: hr_utility.TRACE ( 'l_mapping_name '
3764: || l_mapping_name);
3765: hr_utility.TRACE ( 'l_return_mapp '
3766: || l_return_mapp);
3759: l_change_att_index := l_change_att_index+1;
3760:
3761: if g_debug then
3762: hr_utility.TRACE ('Att2');
3763: hr_utility.TRACE ( 'l_mapping_name '
3764: || l_mapping_name);
3765: hr_utility.TRACE ( 'l_return_mapp '
3766: || l_return_mapp);
3767: end if;
3761: if g_debug then
3762: hr_utility.TRACE ('Att2');
3763: hr_utility.TRACE ( 'l_mapping_name '
3764: || l_mapping_name);
3765: hr_utility.TRACE ( 'l_return_mapp '
3766: || l_return_mapp);
3767: end if;
3768: l_return_mapp := l_return_mapp
3769: || ':'
3796: p_change_att_tab(l_change_att_index).changed_attribute :='ATTRIBUTE3';
3797: l_change_att_index := l_change_att_index+1;
3798:
3799: if g_debug then
3800: hr_utility.TRACE ('Att3');
3801: hr_utility.TRACE ( 'l_mapping_name '
3802: || l_mapping_name);
3803: hr_utility.TRACE ( 'l_return_mapp '
3804: || l_return_mapp);
3797: l_change_att_index := l_change_att_index+1;
3798:
3799: if g_debug then
3800: hr_utility.TRACE ('Att3');
3801: hr_utility.TRACE ( 'l_mapping_name '
3802: || l_mapping_name);
3803: hr_utility.TRACE ( 'l_return_mapp '
3804: || l_return_mapp);
3805: end if;
3799: if g_debug then
3800: hr_utility.TRACE ('Att3');
3801: hr_utility.TRACE ( 'l_mapping_name '
3802: || l_mapping_name);
3803: hr_utility.TRACE ( 'l_return_mapp '
3804: || l_return_mapp);
3805: end if;
3806: l_return_mapp := l_return_mapp
3807: || ':'
3833: p_change_att_tab(l_change_att_index).changed_attribute :='ATTRIBUTE4';
3834: l_change_att_index := l_change_att_index+1;
3835:
3836: if g_debug then
3837: hr_utility.TRACE ('Att4');
3838: hr_utility.TRACE ( 'l_mapping_name '
3839: || l_mapping_name);
3840: hr_utility.TRACE ( 'l_return_mapp '
3841: || l_return_mapp);
3834: l_change_att_index := l_change_att_index+1;
3835:
3836: if g_debug then
3837: hr_utility.TRACE ('Att4');
3838: hr_utility.TRACE ( 'l_mapping_name '
3839: || l_mapping_name);
3840: hr_utility.TRACE ( 'l_return_mapp '
3841: || l_return_mapp);
3842: end if;
3836: if g_debug then
3837: hr_utility.TRACE ('Att4');
3838: hr_utility.TRACE ( 'l_mapping_name '
3839: || l_mapping_name);
3840: hr_utility.TRACE ( 'l_return_mapp '
3841: || l_return_mapp);
3842: end if;
3843: l_return_mapp := l_return_mapp
3844: || ':'
4638: || l_mapping_name;
4639: END IF;
4640:
4641: if g_debug then
4642: hr_utility.TRACE (l_return_mapp);
4643: end if;
4644: RETURN l_return_mapp;
4645: END compare_tbb_attributes;
4646:
4690: l_change_att_index := p_change_att_tab.last+1;
4691: END IF;
4692:
4693: if g_debug then
4694: hr_utility.TRACE ( 'p_block1.scope'
4695: || p_block1.SCOPE);
4696: hr_utility.TRACE ( 'p_block2.scope'
4697: || p_block2.SCOPE);
4698: end if;
4692:
4693: if g_debug then
4694: hr_utility.TRACE ( 'p_block1.scope'
4695: || p_block1.SCOPE);
4696: hr_utility.TRACE ( 'p_block2.scope'
4697: || p_block2.SCOPE);
4698: end if;
4699:
4700: IF (p_block1.SCOPE = 'DETAIL')
4710: OR
4711: (p_block1.measure is not null and p_tbb_deleted ))
4712: THEN
4713: if g_debug then
4714: hr_utility.TRACE ('Before assignment');
4715: end if;
4716: OPEN csr_get_mapping_name('ATTRIBUTE1');
4717: FETCH csr_get_mapping_name INTO l_mapping_name;
4718: CLOSE csr_get_mapping_name;
4724: l_change_att_index := p_change_att_tab.last+1;
4725:
4726: l_ret_val := 'BUILDING_BLOCKS'||'|'||'ATTRIBUTE1'||'|'||l_mapping_name;
4727: if g_debug then
4728: hr_utility.TRACE ('After Assignment');
4729: end if;
4730: END IF;
4731:
4732: if g_debug then
4729: end if;
4730: END IF;
4731:
4732: if g_debug then
4733: hr_utility.TRACE ('l_ret_val');
4734: end if;
4735:
4736: -- 2. Start Time
4737: IF ((NVL (p_block1.start_time, to_date('01-01-0090','dd-mm-rrrr')) <>
4740: (p_block1.start_time is not null and p_tbb_deleted )
4741: )
4742: THEN
4743: if g_debug then
4744: hr_utility.TRACE ( 'l_ret_val'
4745: || l_ret_val);
4746: end if;
4747: OPEN csr_get_mapping_name('ATTRIBUTE2');
4748: FETCH csr_get_mapping_name INTO l_mapping_name;
4844: BEGIN
4845:
4846:
4847: if g_debug then
4848: hr_utility.TRACE ('Before get_timecard_info');
4849: end if;
4850: get_timecard_info (
4851: p_time_building_blocks=> P_TIME_BUILDING_BLOCKS,
4852: p_timecard_rec=> l_timecard_info_rec
4852: p_timecard_rec=> l_timecard_info_rec
4853: );
4854:
4855: if g_debug then
4856: hr_utility.TRACE ('Before populate_old_tco');
4857: end if;
4858: populate_old_tco (
4859: p_timecard_rec=> l_timecard_info_rec,
4860: p_timecard_building_blocks=> l_old_tco_bb,
4863:
4864: IF (p_rule_record.attribute1 IS NOT NULL)
4865: THEN
4866: if g_debug then
4867: hr_utility.TRACE (
4868: 'Attribute 1 -- Time Category '
4869: || p_rule_record.attribute1
4870: );
4871: end if;
4899:
4900: END IF;
4901:
4902: if g_debug then
4903: hr_utility.TRACE ('Returned from populate_old_tco');
4904: end if;
4905:
4906: n:= l_old_tco_bb.first;
4907: loop
4906: n:= l_old_tco_bb.first;
4907: loop
4908: exit when not l_old_tco_bb.exists(n);
4909: if g_debug then
4910: hr_utility.trace('ID ' || 'OVN' || 'SCOPE' || 'Changed' || 'New' || 'Date To');
4911: hr_utility.trace(l_old_tco_bb(n).time_building_block_id||' ' || l_old_tco_bb(n).object_version_number|| ' ' || l_old_tco_bb(n).scope ||' '
4912: || l_old_tco_bb(n).changed|| ' ' ||l_old_tco_bb(n).new || to_char(l_old_tco_bb(n).date_to,'dd-mon-rrrr'));
4913: end if;
4914: n := p_time_building_blocks.next(n);
4907: loop
4908: exit when not l_old_tco_bb.exists(n);
4909: if g_debug then
4910: hr_utility.trace('ID ' || 'OVN' || 'SCOPE' || 'Changed' || 'New' || 'Date To');
4911: hr_utility.trace(l_old_tco_bb(n).time_building_block_id||' ' || l_old_tco_bb(n).object_version_number|| ' ' || l_old_tco_bb(n).scope ||' '
4912: || l_old_tco_bb(n).changed|| ' ' ||l_old_tco_bb(n).new || to_char(l_old_tco_bb(n).date_to,'dd-mon-rrrr'));
4913: end if;
4914: n := p_time_building_blocks.next(n);
4915: end loop;
4918:
4919: LOOP
4920: EXIT WHEN NOT p_tco_att.EXISTS (l_tbb_index);
4921: if g_debug then
4922: hr_utility.TRACE (
4923: p_tco_att (l_tbb_index).time_attribute_id
4924: || ' ' || p_tco_att (l_tbb_index).object_version_number
4925: || 'attribute_category' || p_tco_att (l_tbb_index).attribute_category
4926: || 'attribute1 '|| p_tco_att (l_tbb_index).attribute1
4930: l_tbb_index := p_tco_att.NEXT (l_tbb_index);
4931: END LOOP;
4932:
4933: if g_debug then
4934: hr_utility.TRACE ('OLD TBB');
4935: end if;
4936: l_old_tbb_index := l_old_tco_att.FIRST;
4937:
4938: LOOP
4937:
4938: LOOP
4939: EXIT WHEN NOT l_old_tco_att.EXISTS (l_old_tbb_index);
4940: if g_debug then
4941: hr_utility.TRACE (
4942: l_old_tco_att (l_old_tbb_index).time_attribute_id
4943: || ' '|| l_old_tco_att (l_old_tbb_index).object_version_number
4944: || 'Attribute_category '|| l_old_tco_att (l_old_tbb_index).attribute_category
4945: || 'Attribute1 '|| l_old_tco_att (l_old_tbb_index).attribute1
4954:
4955: /* Loop through Building blocks */
4956: LOOP
4957: if g_debug then
4958: hr_utility.TRACE ('Timecard Loop');
4959: end if;
4960: l_build_change_list := null;
4961: l_tbb_deleted := FALSE;
4962: EXIT WHEN NOT p_tco_bb.EXISTS (l_tbb_index);
4970:
4971:
4972: l_old_tbb_index := l_old_tco_bb.FIRST;
4973: if g_debug then
4974: hr_utility.TRACE ('Old Timecard Loop');
4975: end if;
4976: if (trunc(p_tco_bb(l_tbb_index).date_to) = trunc(sysdate)) then
4977: l_tbb_deleted := TRUE;
4978: else
4981: LOOP
4982: EXIT WHEN NOT l_old_tco_bb.EXISTS (l_old_tbb_index); -- OR l_tbb_deleted;
4983: l_change_list := NULL;
4984: if g_debug then
4985: hr_utility.TRACE ('TBB Test');
4986: end if;
4987:
4988: if g_debug then
4989: hr_utility.trace('new bb/ovn is '||to_char(p_tco_bb(l_tbb_index).time_building_block_id)||':'
4985: hr_utility.TRACE ('TBB Test');
4986: end if;
4987:
4988: if g_debug then
4989: hr_utility.trace('new bb/ovn is '||to_char(p_tco_bb(l_tbb_index).time_building_block_id)||':'
4990: ||to_char(p_tco_bb(l_tbb_index).object_version_number));
4991:
4992: hr_utility.trace('old bb/ovn is '||to_char(l_old_tco_bb(l_old_tbb_index).time_building_block_id)||':'
4993: ||to_char(l_old_tco_bb(l_old_tbb_index).object_version_number));
4988: if g_debug then
4989: hr_utility.trace('new bb/ovn is '||to_char(p_tco_bb(l_tbb_index).time_building_block_id)||':'
4990: ||to_char(p_tco_bb(l_tbb_index).object_version_number));
4991:
4992: hr_utility.trace('old bb/ovn is '||to_char(l_old_tco_bb(l_old_tbb_index).time_building_block_id)||':'
4993: ||to_char(l_old_tco_bb(l_old_tbb_index).object_version_number));
4994: end if;
4995:
4996: IF ( p_tco_bb (l_tbb_index).time_building_block_id =
5065: IF p_tco_att(l_att_index).ATTRIBUTE_CATEGORY = 'SECURITY'
5066: AND l_old_tco_att(l_old_att_index).ATTRIBUTE_CATEGORY = 'SECURITY'
5067: THEN
5068: -- No need to compare security attributes..
5069: hr_utility.trace('Exclude comparing SECURITY Attributes');
5070: NULL;
5071: ELSE
5072: l_change_list :=
5073: compare_tbb_attributes (
5089: END IF;
5090:
5091: l_att_index := p_tco_att.NEXT (l_att_index);
5092: if g_debug then
5093: hr_utility.TRACE ('After old attr loop');
5094: end if;
5095: END LOOP;
5096: END IF;
5097:
5194: p_tco_att=> p_tco_att
5195: );
5196: l_tbb_index := p_tco_bb.FIRST;
5197: if g_debug then
5198: hr_utility.TRACE ('Outside Loop');
5199: end if;
5200:
5201: LOOP
5202: EXIT WHEN NOT p_tco_bb.EXISTS (l_tbb_index);
5305: END LOOP;
5306: END IF;
5307:
5308: if g_debug then
5309: hr_utility.TRACE ('CLA Lateeeeeeeeeeeeeee Message Table');
5310: hr_utility.trace('Count ' || p_messages.count);
5311: end if;
5312: n := p_messages.FIRST;
5313:
5306: END IF;
5307:
5308: if g_debug then
5309: hr_utility.TRACE ('CLA Lateeeeeeeeeeeeeee Message Table');
5310: hr_utility.trace('Count ' || p_messages.count);
5311: end if;
5312: n := p_messages.FIRST;
5313:
5314: LOOP
5316:
5317: IF (p_messages (n).message_level = 'REASON')
5318: THEN
5319: if g_debug then
5320: hr_utility.TRACE ('Time Building Block Id' || 'Time Building Block OVN' || 'message_name');
5321: hr_utility.trace(p_messages (n).time_building_block_id || ' ' || p_messages (n).time_building_block_ovn || ' ' || p_messages (n).message_name);
5322: end if;
5323: END IF;
5324: n := p_messages.NEXT (n);
5317: IF (p_messages (n).message_level = 'REASON')
5318: THEN
5319: if g_debug then
5320: hr_utility.TRACE ('Time Building Block Id' || 'Time Building Block OVN' || 'message_name');
5321: hr_utility.trace(p_messages (n).time_building_block_id || ' ' || p_messages (n).time_building_block_ovn || ' ' || p_messages (n).message_name);
5322: end if;
5323: END IF;
5324: n := p_messages.NEXT (n);
5325: END LOOP;
5323: END IF;
5324: n := p_messages.NEXT (n);
5325: END LOOP;
5326: if g_debug then
5327: hr_utility.trace('End Lateeeeeeeeeeeeeee');
5328: end if;
5329: END execute_late_ter;
5330: Begin
5331:
5328: end if;
5329: END execute_late_ter;
5330: Begin
5331:
5332: g_debug := hr_utility.debug_enabled;
5333:
5334: n:= p_time_building_blocks.first;
5335: loop
5336: exit when not p_time_building_blocks.exists(n);
5334: n:= p_time_building_blocks.first;
5335: loop
5336: exit when not p_time_building_blocks.exists(n);
5337: if g_debug then
5338: hr_utility.trace('ID ' || 'OVN' || 'SCOPE' || 'Changed' || 'New' || ' ' || 'Date to');
5339: hr_utility.trace(p_time_building_blocks(n).time_building_block_id||' ' || p_time_building_blocks(n).object_version_number|| ' ' || p_time_building_blocks(n).scope ||' '
5340: || p_time_building_blocks(n).changed|| ' ' ||p_time_building_blocks(n).new || to_char(p_time_building_blocks(n).date_to,'dd-mon-rrrr'));
5341: end if;
5342: n := p_time_building_blocks.next(n);
5335: loop
5336: exit when not p_time_building_blocks.exists(n);
5337: if g_debug then
5338: hr_utility.trace('ID ' || 'OVN' || 'SCOPE' || 'Changed' || 'New' || ' ' || 'Date to');
5339: hr_utility.trace(p_time_building_blocks(n).time_building_block_id||' ' || p_time_building_blocks(n).object_version_number|| ' ' || p_time_building_blocks(n).scope ||' '
5340: || p_time_building_blocks(n).changed|| ' ' ||p_time_building_blocks(n).new || to_char(p_time_building_blocks(n).date_to,'dd-mon-rrrr'));
5341: end if;
5342: n := p_time_building_blocks.next(n);
5343: end loop;
5344: get_timecard_info (
5345: p_time_building_blocks => P_TIME_BUILDING_BLOCKS
5346: , p_timecard_rec => l_timecard_info_rec );
5347: if g_debug then
5348: hr_utility.trace('After get_timecard_info');
5349: hr_utility.trace('start_date ' || l_timecard_info_rec.start_date);
5350: end if;
5351:
5352: n := p_messages.first;
5345: p_time_building_blocks => P_TIME_BUILDING_BLOCKS
5346: , p_timecard_rec => l_timecard_info_rec );
5347: if g_debug then
5348: hr_utility.trace('After get_timecard_info');
5349: hr_utility.trace('start_date ' || l_timecard_info_rec.start_date);
5350: end if;
5351:
5352: n := p_messages.first;
5353: loop
5403: end loop;
5404:
5405:
5406: if g_debug then
5407: hr_utility.trace('Final Message Table -- Late + Change......');
5408: end if;
5409: n := p_messages.first;
5410: loop
5411: exit when not p_messages.exists(n);
5410: loop
5411: exit when not p_messages.exists(n);
5412: if (p_messages(n).message_level = 'REASON') then
5413: if g_debug then
5414: hr_utility.trace('Time Building Block Id' || p_messages(n).time_building_block_id);
5415: hr_utility.trace('Time Building Block OVN' || p_messages(n).time_building_block_ovn);
5416: hr_utility.trace('Message name' || p_messages(n).message_name);
5417: hr_utility.trace('Message Level' || p_messages(n).message_level);
5418: hr_utility.trace('Message Tokens' || p_messages(n).message_tokens);
5411: exit when not p_messages.exists(n);
5412: if (p_messages(n).message_level = 'REASON') then
5413: if g_debug then
5414: hr_utility.trace('Time Building Block Id' || p_messages(n).time_building_block_id);
5415: hr_utility.trace('Time Building Block OVN' || p_messages(n).time_building_block_ovn);
5416: hr_utility.trace('Message name' || p_messages(n).message_name);
5417: hr_utility.trace('Message Level' || p_messages(n).message_level);
5418: hr_utility.trace('Message Tokens' || p_messages(n).message_tokens);
5419: hr_utility.trace('Field name' || p_messages(n).message_field);
5412: if (p_messages(n).message_level = 'REASON') then
5413: if g_debug then
5414: hr_utility.trace('Time Building Block Id' || p_messages(n).time_building_block_id);
5415: hr_utility.trace('Time Building Block OVN' || p_messages(n).time_building_block_ovn);
5416: hr_utility.trace('Message name' || p_messages(n).message_name);
5417: hr_utility.trace('Message Level' || p_messages(n).message_level);
5418: hr_utility.trace('Message Tokens' || p_messages(n).message_tokens);
5419: hr_utility.trace('Field name' || p_messages(n).message_field);
5420: hr_utility.trace('Recipient Application ID' || p_messages(n).message_name);
5413: if g_debug then
5414: hr_utility.trace('Time Building Block Id' || p_messages(n).time_building_block_id);
5415: hr_utility.trace('Time Building Block OVN' || p_messages(n).time_building_block_ovn);
5416: hr_utility.trace('Message name' || p_messages(n).message_name);
5417: hr_utility.trace('Message Level' || p_messages(n).message_level);
5418: hr_utility.trace('Message Tokens' || p_messages(n).message_tokens);
5419: hr_utility.trace('Field name' || p_messages(n).message_field);
5420: hr_utility.trace('Recipient Application ID' || p_messages(n).message_name);
5421: end if;
5414: hr_utility.trace('Time Building Block Id' || p_messages(n).time_building_block_id);
5415: hr_utility.trace('Time Building Block OVN' || p_messages(n).time_building_block_ovn);
5416: hr_utility.trace('Message name' || p_messages(n).message_name);
5417: hr_utility.trace('Message Level' || p_messages(n).message_level);
5418: hr_utility.trace('Message Tokens' || p_messages(n).message_tokens);
5419: hr_utility.trace('Field name' || p_messages(n).message_field);
5420: hr_utility.trace('Recipient Application ID' || p_messages(n).message_name);
5421: end if;
5422: end if;
5415: hr_utility.trace('Time Building Block OVN' || p_messages(n).time_building_block_ovn);
5416: hr_utility.trace('Message name' || p_messages(n).message_name);
5417: hr_utility.trace('Message Level' || p_messages(n).message_level);
5418: hr_utility.trace('Message Tokens' || p_messages(n).message_tokens);
5419: hr_utility.trace('Field name' || p_messages(n).message_field);
5420: hr_utility.trace('Recipient Application ID' || p_messages(n).message_name);
5421: end if;
5422: end if;
5423: n := p_messages.next(n);
5416: hr_utility.trace('Message name' || p_messages(n).message_name);
5417: hr_utility.trace('Message Level' || p_messages(n).message_level);
5418: hr_utility.trace('Message Tokens' || p_messages(n).message_tokens);
5419: hr_utility.trace('Field name' || p_messages(n).message_field);
5420: hr_utility.trace('Recipient Application ID' || p_messages(n).message_name);
5421: end if;
5422: end if;
5423: n := p_messages.next(n);
5424: end loop;
5423: n := p_messages.next(n);
5424: end loop;
5425:
5426: if g_debug then
5427: hr_utility.trace('End of execute CLA time entry rules');
5428: end if;
5429:
5430: end EXECUTE_CLA_TIME_ENTRY_RULES;
5431:
5459: AND hbb.BLD_BLK_INFO_TYPE_ID = hmc.bld_blk_info_type_id
5460: AND hbb.BLD_BLK_INFO_TYPE = 'BUILDING_BLOCKS';
5461: l_prompt_name varchar2(30);
5462: Begin
5463: g_debug := hr_utility.debug_enabled;
5464:
5465: if (p_blk_type = 'BUILDING_BLOCK' ) then
5466: open c_get_prompt_blk(p_attribute);
5467: fetch c_get_prompt_blk into l_prompt_name;
5465: if (p_blk_type = 'BUILDING_BLOCK' ) then
5466: open c_get_prompt_blk(p_attribute);
5467: fetch c_get_prompt_blk into l_prompt_name;
5468: if g_debug then
5469: hr_utility.trace('Prompt ' || l_prompt_name);
5470: end if;
5471: if c_get_prompt_blk%FOUND then
5472: p_prompt := l_prompt_name;
5473: end if;
5502: l_token_string VARCHAR2(4000) := NULL;
5503:
5504: BEGIN
5505:
5506: g_debug := hr_utility.debug_enabled;
5507:
5508: IF ( p_token_name is not null )
5509: THEN
5510:
5508: IF ( p_token_name is not null )
5509: THEN
5510:
5511: if g_debug then
5512: hr_utility.trace('GAZ token is '||p_token_name);
5513: hr_utility.trace('GAZ length P token value is '||to_char(length(p_token_value)));
5514: end if;
5515:
5516: l_token_string := SUBSTR(UPPER(p_token_name)||'&'||p_token_Value,1,4000);
5509: THEN
5510:
5511: if g_debug then
5512: hr_utility.trace('GAZ token is '||p_token_name);
5513: hr_utility.trace('GAZ length P token value is '||to_char(length(p_token_value)));
5514: end if;
5515:
5516: l_token_string := SUBSTR(UPPER(p_token_name)||'&'||p_token_Value,1,4000);
5517:
5515:
5516: l_token_string := SUBSTR(UPPER(p_token_name)||'&'||p_token_Value,1,4000);
5517:
5518: if g_debug then
5519: hr_utility.trace('GAZ length token string is '||to_char(length(l_token_string)));
5520: end if;
5521:
5522: END IF;
5523: