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

APPS.HXC_TPD_END dependencies on HR_UTILITY

Line 5: g_debug BOOLEAN := hr_utility.debug_enabled;

1: PACKAGE BODY hxc_tpd_end AS
2: /* $Header: hxcendtp.pkb 120.17 2011/04/19 09:12:56 asrajago ship $ */
3:
4: -- g_time_periods time_periods_table;
5: g_debug BOOLEAN := hr_utility.debug_enabled;
6:
7: -- Bug 6998662
8: -- Added these global variables to manipulate the
9: -- global tables for missing periods. Used in

Line 245: g_debug := hr_utility.debug_enabled;

241: END IF;
242: END check_valid_period;
243:
244: BEGIN
245: g_debug := hr_utility.debug_enabled;
246:
247:
248: -- Bug 10084099
249: -- Build a concatenated list of all the params passed now.

Line 261: hr_utility.trace(' L_param_index ');

257:
258: IF g_debug
259: THEN
260:
261: hr_utility.trace(' L_param_index ');
262: hr_utility.trace(l_param_index);
263: END IF;
264:
265: -- Check if the same set of params came in before.

Line 262: hr_utility.trace(l_param_index);

258: IF g_debug
259: THEN
260:
261: hr_utility.trace(' L_param_index ');
262: hr_utility.trace(l_param_index);
263: END IF;
264:
265: -- Check if the same set of params came in before.
266: -- If yes, return -- do not process further.

Line 269: hr_utility.trace('This list is already processed ');

265: -- Check if the same set of params came in before.
266: -- If yes, return -- do not process further.
267: IF g_param_list.EXISTS(l_param_index)
268: THEN
269: hr_utility.trace('This list is already processed ');
270: RETURN(g_param_list(l_param_index));
271: END IF;
272:
273:

Line 276: hr_utility.TRACE ('Inside populate missing timecard function');

272:
273:
274: IF g_debug
275: THEN
276: hr_utility.TRACE ('Inside populate missing timecard function');
277: hr_utility.set_location ('populate_missing_time_periods', 10);
278: END IF;
279:
280: IF g_time_periods.COUNT > 0

Line 277: hr_utility.set_location ('populate_missing_time_periods', 10);

273:
274: IF g_debug
275: THEN
276: hr_utility.TRACE ('Inside populate missing timecard function');
277: hr_utility.set_location ('populate_missing_time_periods', 10);
278: END IF;
279:
280: IF g_time_periods.COUNT > 0
281: THEN

Line 287: hr_utility.set_location ('populate_missing_time_periods', 25);

283:
284:
285: IF g_debug
286: THEN
287: hr_utility.set_location ('populate_missing_time_periods', 25);
288: hr_utility.TRACE ( 'p_start_date:'
289: || TO_CHAR (p_start_date, 'DD-MON-YYYY HH24:MI:SS')
290: );
291: hr_utility.TRACE ( 'p_end_date :'

Line 288: hr_utility.TRACE ( 'p_start_date:'

284:
285: IF g_debug
286: THEN
287: hr_utility.set_location ('populate_missing_time_periods', 25);
288: hr_utility.TRACE ( 'p_start_date:'
289: || TO_CHAR (p_start_date, 'DD-MON-YYYY HH24:MI:SS')
290: );
291: hr_utility.TRACE ( 'p_end_date :'
292: || TO_CHAR (p_end_date, 'DD-MON-YYYY HH24:MI:SS')

Line 291: hr_utility.TRACE ( 'p_end_date :'

287: hr_utility.set_location ('populate_missing_time_periods', 25);
288: hr_utility.TRACE ( 'p_start_date:'
289: || TO_CHAR (p_start_date, 'DD-MON-YYYY HH24:MI:SS')
290: );
291: hr_utility.TRACE ( 'p_end_date :'
292: || TO_CHAR (p_end_date, 'DD-MON-YYYY HH24:MI:SS')
293: );
294:
295: hr_utility.TRACE ('p_resource_id :'|| p_resource_id);

Line 295: hr_utility.TRACE ('p_resource_id :'|| p_resource_id);

291: hr_utility.TRACE ( 'p_end_date :'
292: || TO_CHAR (p_end_date, 'DD-MON-YYYY HH24:MI:SS')
293: );
294:
295: hr_utility.TRACE ('p_resource_id :'|| p_resource_id);
296: hr_utility.TRACE ('p_assignment_id :'||p_assignment_id);
297: hr_utility.TRACE ('p_appln_set_id :'||p_appln_set_id);
298: hr_utility.TRACE ('p_tim_rec_id :'||p_tim_rec_id);
299:

Line 296: hr_utility.TRACE ('p_assignment_id :'||p_assignment_id);

292: || TO_CHAR (p_end_date, 'DD-MON-YYYY HH24:MI:SS')
293: );
294:
295: hr_utility.TRACE ('p_resource_id :'|| p_resource_id);
296: hr_utility.TRACE ('p_assignment_id :'||p_assignment_id);
297: hr_utility.TRACE ('p_appln_set_id :'||p_appln_set_id);
298: hr_utility.TRACE ('p_tim_rec_id :'||p_tim_rec_id);
299:
300: hr_utility.set_location ('populate_missing_time_periods', 20);

Line 297: hr_utility.TRACE ('p_appln_set_id :'||p_appln_set_id);

293: );
294:
295: hr_utility.TRACE ('p_resource_id :'|| p_resource_id);
296: hr_utility.TRACE ('p_assignment_id :'||p_assignment_id);
297: hr_utility.TRACE ('p_appln_set_id :'||p_appln_set_id);
298: hr_utility.TRACE ('p_tim_rec_id :'||p_tim_rec_id);
299:
300: hr_utility.set_location ('populate_missing_time_periods', 20);
301: END IF;

Line 298: hr_utility.TRACE ('p_tim_rec_id :'||p_tim_rec_id);

294:
295: hr_utility.TRACE ('p_resource_id :'|| p_resource_id);
296: hr_utility.TRACE ('p_assignment_id :'||p_assignment_id);
297: hr_utility.TRACE ('p_appln_set_id :'||p_appln_set_id);
298: hr_utility.TRACE ('p_tim_rec_id :'||p_tim_rec_id);
299:
300: hr_utility.set_location ('populate_missing_time_periods', 20);
301: END IF;
302:

Line 300: hr_utility.set_location ('populate_missing_time_periods', 20);

296: hr_utility.TRACE ('p_assignment_id :'||p_assignment_id);
297: hr_utility.TRACE ('p_appln_set_id :'||p_appln_set_id);
298: hr_utility.TRACE ('p_tim_rec_id :'||p_tim_rec_id);
299:
300: hr_utility.set_location ('populate_missing_time_periods', 20);
301: END IF;
302:
303: -- Following piece of code not needed since g_time_periods.delete is sufficient.
304:

Line 312: hr_utility.TRACE ('Deleted PL/SQL table');

308: -- g_time_periods(i).resource_id := null;
309: -- END LOOP;
310: IF g_debug
311: THEN
312: hr_utility.TRACE ('Deleted PL/SQL table');
313: END IF;
314:
315: -- Bug 6998662
316: -- Need all the three below conditions

Line 325: hr_utility.TRACE ('Deleted PL/SQL table2');

321: OR p_tim_rec_id <> g_tim_rec_id
322: OR p_assignment_id <> g_assignment_id
323: --AND p_appln_set_id <> g_appln_set_id
324: THEN
325: hr_utility.TRACE ('Deleted PL/SQL table2');
326: g_time_periods.DELETE;
327: -- Get the current values into the global variables to
328: -- compare with the next iteration.
329: g_resource_id := p_resource_id;

Line 340: hr_utility.set_location ('populate_missing_time_periods', 25);

336: END IF;
337:
338: IF g_debug
339: THEN
340: hr_utility.set_location ('populate_missing_time_periods', 25);
341: hr_utility.TRACE ( 'p_start_date:'
342: || TO_CHAR (p_start_date, 'DD-MON-YYYY HH24:MI:SS')
343: );
344: hr_utility.TRACE ( 'p_end_date :'

Line 341: hr_utility.TRACE ( 'p_start_date:'

337:
338: IF g_debug
339: THEN
340: hr_utility.set_location ('populate_missing_time_periods', 25);
341: hr_utility.TRACE ( 'p_start_date:'
342: || TO_CHAR (p_start_date, 'DD-MON-YYYY HH24:MI:SS')
343: );
344: hr_utility.TRACE ( 'p_end_date :'
345: || TO_CHAR (p_end_date, 'DD-MON-YYYY HH24:MI:SS')

Line 344: hr_utility.TRACE ( 'p_end_date :'

340: hr_utility.set_location ('populate_missing_time_periods', 25);
341: hr_utility.TRACE ( 'p_start_date:'
342: || TO_CHAR (p_start_date, 'DD-MON-YYYY HH24:MI:SS')
343: );
344: hr_utility.TRACE ( 'p_end_date :'
345: || TO_CHAR (p_end_date, 'DD-MON-YYYY HH24:MI:SS')
346: );
347: hr_utility.TRACE ('p_resource_id :'|| p_resource_id);
348: hr_utility.TRACE ('p_assignment_id :'||p_assignment_id);

Line 347: hr_utility.TRACE ('p_resource_id :'|| p_resource_id);

343: );
344: hr_utility.TRACE ( 'p_end_date :'
345: || TO_CHAR (p_end_date, 'DD-MON-YYYY HH24:MI:SS')
346: );
347: hr_utility.TRACE ('p_resource_id :'|| p_resource_id);
348: hr_utility.TRACE ('p_assignment_id :'||p_assignment_id);
349: hr_utility.TRACE ('p_appln_set_id :'||p_appln_set_id);
350: hr_utility.TRACE ('p_tim_rec_id :'||p_tim_rec_id);
351:

Line 348: hr_utility.TRACE ('p_assignment_id :'||p_assignment_id);

344: hr_utility.TRACE ( 'p_end_date :'
345: || TO_CHAR (p_end_date, 'DD-MON-YYYY HH24:MI:SS')
346: );
347: hr_utility.TRACE ('p_resource_id :'|| p_resource_id);
348: hr_utility.TRACE ('p_assignment_id :'||p_assignment_id);
349: hr_utility.TRACE ('p_appln_set_id :'||p_appln_set_id);
350: hr_utility.TRACE ('p_tim_rec_id :'||p_tim_rec_id);
351:
352: END IF;

Line 349: hr_utility.TRACE ('p_appln_set_id :'||p_appln_set_id);

345: || TO_CHAR (p_end_date, 'DD-MON-YYYY HH24:MI:SS')
346: );
347: hr_utility.TRACE ('p_resource_id :'|| p_resource_id);
348: hr_utility.TRACE ('p_assignment_id :'||p_assignment_id);
349: hr_utility.TRACE ('p_appln_set_id :'||p_appln_set_id);
350: hr_utility.TRACE ('p_tim_rec_id :'||p_tim_rec_id);
351:
352: END IF;
353:

Line 350: hr_utility.TRACE ('p_tim_rec_id :'||p_tim_rec_id);

346: );
347: hr_utility.TRACE ('p_resource_id :'|| p_resource_id);
348: hr_utility.TRACE ('p_assignment_id :'||p_assignment_id);
349: hr_utility.TRACE ('p_appln_set_id :'||p_appln_set_id);
350: hr_utility.TRACE ('p_tim_rec_id :'||p_tim_rec_id);
351:
352: END IF;
353:
354: l_p_start_date := p_start_date;

Line 477: hr_utility.TRACE ( 'l_p_start_date:'|| TO_CHAR (l_p_start_date,'dd-mon-yyyy hh24:mi:ss'));

473: ));
474:
475: IF g_debug
476: THEN
477: hr_utility.TRACE ( 'l_p_start_date:'|| TO_CHAR (l_p_start_date,'dd-mon-yyyy hh24:mi:ss'));
478: hr_utility.TRACE ( 'l_p_end_date:' || TO_CHAR (l_p_end_date,'dd-mon-yyyy hh24:mi:ss'));
479: END IF;
480:
481: IF (l_p_start_date IS NULL OR l_p_end_date IS NULL)

Line 478: hr_utility.TRACE ( 'l_p_end_date:' || TO_CHAR (l_p_end_date,'dd-mon-yyyy hh24:mi:ss'));

474:
475: IF g_debug
476: THEN
477: hr_utility.TRACE ( 'l_p_start_date:'|| TO_CHAR (l_p_start_date,'dd-mon-yyyy hh24:mi:ss'));
478: hr_utility.TRACE ( 'l_p_end_date:' || TO_CHAR (l_p_end_date,'dd-mon-yyyy hh24:mi:ss'));
479: END IF;
480:
481: IF (l_p_start_date IS NULL OR l_p_end_date IS NULL)
482: THEN

Line 507: hr_utility.set_location ('populate_missing_time_periods', 26);

503: l_asg_end_date := l_p_end_date;
504:
505: IF g_debug
506: THEN
507: hr_utility.set_location ('populate_missing_time_periods', 26);
508: END IF;
509:
510: IF g_debug
511: THEN

Line 512: hr_utility.TRACE ( 'l_p_start_date:'

508: END IF;
509:
510: IF g_debug
511: THEN
512: hr_utility.TRACE ( 'l_p_start_date:'
513: || TO_CHAR (l_p_start_date,
514: 'DD-MON-YYYY HH24:MI:SS'
515: )
516: );

Line 517: hr_utility.TRACE ( 'l_p_end_date :'

513: || TO_CHAR (l_p_start_date,
514: 'DD-MON-YYYY HH24:MI:SS'
515: )
516: );
517: hr_utility.TRACE ( 'l_p_end_date :'
518: || TO_CHAR (l_p_end_date, 'DD-MON-YYYY HH24:MI:SS')
519: );
520: hr_utility.TRACE ( 'lv_end_date :'
521: || TO_CHAR (lv_end_date, 'DD-MON-YYYY HH24:MI:SS')

Line 520: hr_utility.TRACE ( 'lv_end_date :'

516: );
517: hr_utility.TRACE ( 'l_p_end_date :'
518: || TO_CHAR (l_p_end_date, 'DD-MON-YYYY HH24:MI:SS')
519: );
520: hr_utility.TRACE ( 'lv_end_date :'
521: || TO_CHAR (lv_end_date, 'DD-MON-YYYY HH24:MI:SS')
522: );
523: END IF;
524:

Line 538: hr_utility.set_location ('populate_missing_time_periods', 30);

534: );
535:
536: IF g_debug
537: THEN
538: hr_utility.set_location ('populate_missing_time_periods', 30);
539: hr_utility.TRACE ('l_pref_tc_period = ' || l_pref_tc_period);
540: END IF;
541:
542: SELECT hrp.recurring_period_id, hrp.start_date, hrp.end_date,

Line 539: hr_utility.TRACE ('l_pref_tc_period = ' || l_pref_tc_period);

535:
536: IF g_debug
537: THEN
538: hr_utility.set_location ('populate_missing_time_periods', 30);
539: hr_utility.TRACE ('l_pref_tc_period = ' || l_pref_tc_period);
540: END IF;
541:
542: SELECT hrp.recurring_period_id, hrp.start_date, hrp.end_date,
543: hrp.period_type, hrp.duration_in_days

Line 551: hr_utility.TRACE ('l_recurring_period_id:' || l_recurring_period_id);

547: WHERE hrp.recurring_period_id = l_pref_tc_period;
548:
549: IF g_debug
550: THEN
551: hr_utility.TRACE ('l_recurring_period_id:' || l_recurring_period_id);
552: hr_utility.TRACE ( 'l_start_date :'
553: || TO_CHAR (l_start_date, 'DD-MON-YYYY HH24:MI:SS')
554: );
555: hr_utility.TRACE ( 'l_end_date :'

Line 552: hr_utility.TRACE ( 'l_start_date :'

548:
549: IF g_debug
550: THEN
551: hr_utility.TRACE ('l_recurring_period_id:' || l_recurring_period_id);
552: hr_utility.TRACE ( 'l_start_date :'
553: || TO_CHAR (l_start_date, 'DD-MON-YYYY HH24:MI:SS')
554: );
555: hr_utility.TRACE ( 'l_end_date :'
556: || TO_CHAR (l_end_date, 'DD-MON-YYYY HH24:MI:SS')

Line 555: hr_utility.TRACE ( 'l_end_date :'

551: hr_utility.TRACE ('l_recurring_period_id:' || l_recurring_period_id);
552: hr_utility.TRACE ( 'l_start_date :'
553: || TO_CHAR (l_start_date, 'DD-MON-YYYY HH24:MI:SS')
554: );
555: hr_utility.TRACE ( 'l_end_date :'
556: || TO_CHAR (l_end_date, 'DD-MON-YYYY HH24:MI:SS')
557: );
558: hr_utility.TRACE ('l_period_type :' || l_period_type);
559: hr_utility.TRACE ('l_duration_in_days :' || l_duration_in_days);

Line 558: hr_utility.TRACE ('l_period_type :' || l_period_type);

554: );
555: hr_utility.TRACE ( 'l_end_date :'
556: || TO_CHAR (l_end_date, 'DD-MON-YYYY HH24:MI:SS')
557: );
558: hr_utility.TRACE ('l_period_type :' || l_period_type);
559: hr_utility.TRACE ('l_duration_in_days :' || l_duration_in_days);
560: hr_utility.set_location ('populate_missing_time_periods', 50);
561: END IF;
562:

Line 559: hr_utility.TRACE ('l_duration_in_days :' || l_duration_in_days);

555: hr_utility.TRACE ( 'l_end_date :'
556: || TO_CHAR (l_end_date, 'DD-MON-YYYY HH24:MI:SS')
557: );
558: hr_utility.TRACE ('l_period_type :' || l_period_type);
559: hr_utility.TRACE ('l_duration_in_days :' || l_duration_in_days);
560: hr_utility.set_location ('populate_missing_time_periods', 50);
561: END IF;
562:
563: IF l_end_date IS NULL

Line 560: hr_utility.set_location ('populate_missing_time_periods', 50);

556: || TO_CHAR (l_end_date, 'DD-MON-YYYY HH24:MI:SS')
557: );
558: hr_utility.TRACE ('l_period_type :' || l_period_type);
559: hr_utility.TRACE ('l_duration_in_days :' || l_duration_in_days);
560: hr_utility.set_location ('populate_missing_time_periods', 50);
561: END IF;
562:
563: IF l_end_date IS NULL
564: THEN

Line 579: hr_utility.set_location ('populate_missing_time_periods', 60);

575: END IF;
576: */
577: IF g_debug
578: THEN
579: hr_utility.set_location ('populate_missing_time_periods', 60);
580: END IF;
581:
582: l_temp_periods :=
583: hxc_period_evaluation.get_period_list

Line 594: hr_utility.TRACE ('l_temp_periods.count ' || l_temp_periods.COUNT);

590: );
591:
592: IF g_debug
593: THEN
594: hr_utility.TRACE ('l_temp_periods.count ' || l_temp_periods.COUNT);
595: END IF;
596:
597:
598:

Line 609: hr_utility.trace('Printing l_temp_periods ');

605: -- Bug 6998662
606: -- Looping thru and printing out the values, nothing more.
607: IF g_debug
608: THEN
609: hr_utility.trace('Printing l_temp_periods ');
610: FOR i IN l_temp_periods.FIRST..l_temp_periods.LAST
611: LOOP
612: IF l_temp_periods.EXISTS(i)
613: THEN

Line 614: hr_utility.trace(TO_CHAR (l_temp_periods(i).start_date,'DD-MON-YYYY')||

610: FOR i IN l_temp_periods.FIRST..l_temp_periods.LAST
611: LOOP
612: IF l_temp_periods.EXISTS(i)
613: THEN
614: hr_utility.trace(TO_CHAR (l_temp_periods(i).start_date,'DD-MON-YYYY')||
615: '--'||TO_CHAR (l_temp_periods(i).end_date,'DD-MON-YYYY'));
616: END IF;
617: END LOOP;
618: END IF;

Line 624: hr_utility.set_location ('populate_missing_time_periods', 65);

620:
621: LOOP
622: IF g_debug
623: THEN
624: hr_utility.set_location ('populate_missing_time_periods', 65);
625: END IF;
626:
627: EXIT WHEN NOT l_temp_periods.EXISTS (l_index);
628: l_period_list (i).start_date :=

Line 638: hr_utility.TRACE ('FYI');

634: END IF;
635:
636: IF g_debug
637: THEN
638: hr_utility.TRACE ('FYI');
639: END IF;
640:
641: IF l_period_list.COUNT <> 0
642: THEN

Line 645: hr_utility.set_location ('populate_missing_time_periods', 70);

641: IF l_period_list.COUNT <> 0
642: THEN
643: IF g_debug
644: THEN
645: hr_utility.set_location ('populate_missing_time_periods', 70);
646: END IF;
647:
648: FOR l_cnt IN l_period_list.FIRST .. l_period_list.LAST
649: LOOP

Line 652: hr_utility.TRACE ( 'l_period_list.start_date is:'

648: FOR l_cnt IN l_period_list.FIRST .. l_period_list.LAST
649: LOOP
650: IF g_debug
651: THEN
652: hr_utility.TRACE ( 'l_period_list.start_date is:'
653: || TO_CHAR (l_period_list (l_cnt).start_date,
654: 'DD-MON-YYYY'
655: )
656: );

Line 657: hr_utility.TRACE ( 'l_period_list.end_date is:'

653: || TO_CHAR (l_period_list (l_cnt).start_date,
654: 'DD-MON-YYYY'
655: )
656: );
657: hr_utility.TRACE ( 'l_period_list.end_date is:'
658: || TO_CHAR (l_period_list (l_cnt).end_date,
659: 'DD-MON-YYYY'
660: )
661: );

Line 667: hr_utility.set_location ('populate_missing_time_periods', 75);

663: END LOOP;
664:
665: IF g_debug
666: THEN
667: hr_utility.set_location ('populate_missing_time_periods', 75);
668: END IF;
669: END IF;
670:
671: --------------------------------------------------------------------------------

Line 674: hr_utility.set_location ('populate_missing_time_periods', 80);

670:
671: --------------------------------------------------------------------------------
672: IF g_debug
673: THEN
674: hr_utility.set_location ('populate_missing_time_periods', 80);
675: END IF;
676:
677: IF l_period_list.COUNT <> 0 THEN /* Bug: 5484502 */
678:

Line 683: hr_utility.set_location ('populate_missing_time_periods', 84);

679: FOR i IN REVERSE l_period_list.FIRST .. l_period_list.LAST
680: LOOP
681: IF g_debug
682: THEN
683: hr_utility.set_location ('populate_missing_time_periods', 84);
684: hr_utility.TRACE ('i :' || i);
685: END IF;
686:
687: EXIT WHEN NOT l_period_list.EXISTS (i);

Line 684: hr_utility.TRACE ('i :' || i);

680: LOOP
681: IF g_debug
682: THEN
683: hr_utility.set_location ('populate_missing_time_periods', 84);
684: hr_utility.TRACE ('i :' || i);
685: END IF;
686:
687: EXIT WHEN NOT l_period_list.EXISTS (i);
688:

Line 691: hr_utility.set_location ('populate_missing_time_periods', 85);

687: EXIT WHEN NOT l_period_list.EXISTS (i);
688:
689: IF g_debug
690: THEN
691: hr_utility.set_location ('populate_missing_time_periods', 85);
692: END IF;
693:
694: l_start_date := l_period_list (i).start_date;
695: l_period_end_date := l_period_list (i).end_date;

Line 704: hr_utility.TRACE ( 'lv_end_date = '

700: END IF;
701:
702: IF g_debug
703: THEN
704: hr_utility.TRACE ( 'lv_end_date = '
705: || TO_CHAR (lv_end_date,
706: 'DD-MON-YYYY HH24:MI:SS'
707: )
708: );

Line 709: hr_utility.TRACE ( 'l_start_date = '

705: || TO_CHAR (lv_end_date,
706: 'DD-MON-YYYY HH24:MI:SS'
707: )
708: );
709: hr_utility.TRACE ( 'l_start_date = '
710: || TO_CHAR (l_start_date,
711: 'DD-MON-YYYY HH24:MI:SS'
712: )
713: );

Line 714: hr_utility.TRACE ( 'l_period_end_date = '

710: || TO_CHAR (l_start_date,
711: 'DD-MON-YYYY HH24:MI:SS'
712: )
713: );
714: hr_utility.TRACE ( 'l_period_end_date = '
715: || TO_CHAR (l_period_end_date,
716: 'DD-MON-YYYY HH24:MI:SS'
717: )
718: );

Line 725: hr_utility.set_location ('populate_missing_time_periods', 90);

721: IF lv_end_date >= l_start_date AND lv_end_date <= l_period_end_date
722: THEN
723: IF g_debug
724: THEN
725: hr_utility.set_location ('populate_missing_time_periods', 90);
726: hr_utility.TRACE ('p_resource_id = ' || p_resource_id);
727: hr_utility.TRACE ( 'lv_end_date = '
728: || TO_CHAR (lv_end_date,
729: 'DD-MON-YYYY HH24:MI:SS'

Line 726: hr_utility.TRACE ('p_resource_id = ' || p_resource_id);

722: THEN
723: IF g_debug
724: THEN
725: hr_utility.set_location ('populate_missing_time_periods', 90);
726: hr_utility.TRACE ('p_resource_id = ' || p_resource_id);
727: hr_utility.TRACE ( 'lv_end_date = '
728: || TO_CHAR (lv_end_date,
729: 'DD-MON-YYYY HH24:MI:SS'
730: )

Line 727: hr_utility.TRACE ( 'lv_end_date = '

723: IF g_debug
724: THEN
725: hr_utility.set_location ('populate_missing_time_periods', 90);
726: hr_utility.TRACE ('p_resource_id = ' || p_resource_id);
727: hr_utility.TRACE ( 'lv_end_date = '
728: || TO_CHAR (lv_end_date,
729: 'DD-MON-YYYY HH24:MI:SS'
730: )
731: );

Line 732: hr_utility.TRACE ( 'l_start_date = '

728: || TO_CHAR (lv_end_date,
729: 'DD-MON-YYYY HH24:MI:SS'
730: )
731: );
732: hr_utility.TRACE ( 'l_start_date = '
733: || TO_CHAR (l_start_date,
734: 'DD-MON-YYYY HH24:MI:SS'
735: )
736: );

Line 737: hr_utility.TRACE ( 'l_period_end_date = '

733: || TO_CHAR (l_start_date,
734: 'DD-MON-YYYY HH24:MI:SS'
735: )
736: );
737: hr_utility.TRACE ( 'l_period_end_date = '
738: || TO_CHAR (l_period_end_date,
739: 'DD-MON-YYYY HH24:MI:SS'
740: )
741: );

Line 750: hr_utility.TRACE ( 'lv_end_date:'

746: lv_end_date := p_period_start - 1;
747:
748: IF g_debug
749: THEN
750: hr_utility.TRACE ( 'lv_end_date:'
751: || TO_CHAR (lv_end_date,
752: 'DD-MON-YYYY HH24:MI:SS'
753: )
754: );

Line 762: hr_utility.TRACE ( 'p_period_start :'

758: ld_period_end_date := p_period_end;
759:
760: IF g_debug
761: THEN
762: hr_utility.TRACE ( 'p_period_start :'
763: || TO_CHAR (p_period_start,
764: 'DD-MON-YYYY HH24:MI:SS'
765: )
766: );

Line 767: hr_utility.TRACE ( 'p_period_end :'

763: || TO_CHAR (p_period_start,
764: 'DD-MON-YYYY HH24:MI:SS'
765: )
766: );
767: hr_utility.TRACE ( 'p_period_end :'
768: || TO_CHAR (p_period_end,
769: 'DD-MON-YYYY HH24:MI:SS'
770: )
771: );

Line 772: hr_utility.TRACE ( 'lv_end_date :'

768: || TO_CHAR (p_period_end,
769: 'DD-MON-YYYY HH24:MI:SS'
770: )
771: );
772: hr_utility.TRACE ( 'lv_end_date :'
773: || TO_CHAR (lv_end_date,
774: 'DD-MON-YYYY HH24:MI:SS'
775: )
776: );

Line 777: hr_utility.TRACE ( 'l_start_date :'

773: || TO_CHAR (lv_end_date,
774: 'DD-MON-YYYY HH24:MI:SS'
775: )
776: );
777: hr_utility.TRACE ( 'l_start_date :'
778: || TO_CHAR (l_start_date,
779: 'DD-MON-YYYY HH24:MI:SS'
780: )
781: );

Line 782: hr_utility.TRACE ( 'l_period_end_date :'

778: || TO_CHAR (l_start_date,
779: 'DD-MON-YYYY HH24:MI:SS'
780: )
781: );
782: hr_utility.TRACE ( 'l_period_end_date :'
783: || TO_CHAR (l_period_end_date,
784: 'DD-MON-YYYY HH24:MI:SS'
785: )
786: );

Line 794: hr_utility.set_location ('populate_missing_time_periods',

790:
791: LOOP
792: IF g_debug
793: THEN
794: hr_utility.set_location ('populate_missing_time_periods',
795: 95
796: );
797: END IF;
798:

Line 804: hr_utility.TRACE ('p_resource_id :' || p_resource_id);

800: INTO lv_start_time, lv_stop_time;
801:
802: IF g_debug
803: THEN
804: hr_utility.TRACE ('p_resource_id :' || p_resource_id);
805: hr_utility.TRACE ('lv_row_found :' || lv_row_found);
806: hr_utility.TRACE ( 'lv_start_time :'
807: || TO_CHAR (lv_start_time,
808: 'DD-MON-YYYY HH24:MI:SS'

Line 805: hr_utility.TRACE ('lv_row_found :' || lv_row_found);

801:
802: IF g_debug
803: THEN
804: hr_utility.TRACE ('p_resource_id :' || p_resource_id);
805: hr_utility.TRACE ('lv_row_found :' || lv_row_found);
806: hr_utility.TRACE ( 'lv_start_time :'
807: || TO_CHAR (lv_start_time,
808: 'DD-MON-YYYY HH24:MI:SS'
809: )

Line 806: hr_utility.TRACE ( 'lv_start_time :'

802: IF g_debug
803: THEN
804: hr_utility.TRACE ('p_resource_id :' || p_resource_id);
805: hr_utility.TRACE ('lv_row_found :' || lv_row_found);
806: hr_utility.TRACE ( 'lv_start_time :'
807: || TO_CHAR (lv_start_time,
808: 'DD-MON-YYYY HH24:MI:SS'
809: )
810: );

Line 811: hr_utility.TRACE ( 'lv_stop_time :'

807: || TO_CHAR (lv_start_time,
808: 'DD-MON-YYYY HH24:MI:SS'
809: )
810: );
811: hr_utility.TRACE ( 'lv_stop_time :'
812: || TO_CHAR (lv_stop_time,
813: 'DD-MON-YYYY HH24:MI:SS'
814: )
815: );

Line 816: hr_utility.TRACE ( 'ld_period_start_date:'

812: || TO_CHAR (lv_stop_time,
813: 'DD-MON-YYYY HH24:MI:SS'
814: )
815: );
816: hr_utility.TRACE ( 'ld_period_start_date:'
817: || TO_CHAR (ld_period_start_date,
818: 'DD-MON-YYYY HH24:MI:SS'
819: )
820: );

Line 821: hr_utility.TRACE ( 'ld_period_end_date :'

817: || TO_CHAR (ld_period_start_date,
818: 'DD-MON-YYYY HH24:MI:SS'
819: )
820: );
821: hr_utility.TRACE ( 'ld_period_end_date :'
822: || TO_CHAR (ld_period_end_date,
823: 'DD-MON-YYYY HH24:MI:SS'
824: )
825: );

Line 826: hr_utility.TRACE ( 'p_period_start :'

822: || TO_CHAR (ld_period_end_date,
823: 'DD-MON-YYYY HH24:MI:SS'
824: )
825: );
826: hr_utility.TRACE ( 'p_period_start :'
827: || TO_CHAR (p_period_start,
828: 'DD-MON-YYYY HH24:MI:SS'
829: )
830: );

Line 831: hr_utility.TRACE ( 'p_period_end :'

827: || TO_CHAR (p_period_start,
828: 'DD-MON-YYYY HH24:MI:SS'
829: )
830: );
831: hr_utility.TRACE ( 'p_period_end :'
832: || TO_CHAR (p_period_end,
833: 'DD-MON-YYYY HH24:MI:SS'
834: )
835: );

Line 842: hr_utility.set_location

838: IF c_period_exists%NOTFOUND AND lv_row_found = 'N'
839: THEN
840: IF g_debug
841: THEN
842: hr_utility.set_location
843: ('populate_missing_time_periods',
844: 100
845: );
846: END IF;

Line 873: hr_utility.set_location

869: IF c_period_exists%NOTFOUND
870: THEN
871: IF g_debug
872: THEN
873: hr_utility.set_location
874: ('populate_missing_time_periods',
875: 110
876: );
877: END IF;

Line 886: hr_utility.set_location ('populate_missing_time_periods',

882: lv_row_found := 'Y';
883:
884: IF g_debug
885: THEN
886: hr_utility.set_location ('populate_missing_time_periods',
887: 120
888: );
889: END IF;
890:

Line 896: hr_utility.set_location

892: AND TRUNC (p_period_end) < TRUNC (lv_stop_time)
893: THEN
894: IF g_debug
895: THEN
896: hr_utility.set_location
897: ('populate_missing_time_periods',
898: 130
899: );
900: END IF;

Line 907: hr_utility.TRACE ( 'ld_period_start_date:'

903: ld_period_end_date := lv_start_time - 1;
904:
905: IF g_debug
906: THEN
907: hr_utility.TRACE ( 'ld_period_start_date:'
908: || TO_CHAR (ld_period_start_date,
909: 'DD-MON-YYYY HH24:MI:SS'
910: )
911: );

Line 912: hr_utility.TRACE ( 'ld_period_end_date :'

908: || TO_CHAR (ld_period_start_date,
909: 'DD-MON-YYYY HH24:MI:SS'
910: )
911: );
912: hr_utility.TRACE ( 'ld_period_end_date :'
913: || TO_CHAR (ld_period_end_date,
914: 'DD-MON-YYYY HH24:MI:SS'
915: )
916: );

Line 917: hr_utility.set_location ('populate_missing_time_periods',

913: || TO_CHAR (ld_period_end_date,
914: 'DD-MON-YYYY HH24:MI:SS'
915: )
916: );
917: hr_utility.set_location ('populate_missing_time_periods',
918: 140
919: );
920: END IF;
921:

Line 934: hr_utility.set_location

930: IF c_period_exists_chk%NOTFOUND
931: THEN
932: IF g_debug
933: THEN
934: hr_utility.set_location
935: ('populate_missing_time_periods',
936: 150
937: );
938: END IF;

Line 968: hr_utility.set_location

964: AND TRUNC (p_period_end) > TRUNC (lv_stop_time)
965: THEN
966: IF g_debug
967: THEN
968: hr_utility.set_location
969: ('populate_missing_time_periods',
970: 160
971: );
972: END IF;

Line 979: hr_utility.TRACE ( 'ld_period_start_date:'

975: ld_period_end_date := p_period_end;
976:
977: IF g_debug
978: THEN
979: hr_utility.TRACE ( 'ld_period_start_date:'
980: || TO_CHAR (ld_period_start_date,
981: 'DD-MON-YYYY HH24:MI:SS'
982: )
983: );

Line 984: hr_utility.TRACE ( 'ld_period_end_date :'

980: || TO_CHAR (ld_period_start_date,
981: 'DD-MON-YYYY HH24:MI:SS'
982: )
983: );
984: hr_utility.TRACE ( 'ld_period_end_date :'
985: || TO_CHAR (ld_period_end_date,
986: 'DD-MON-YYYY HH24:MI:SS'
987: )
988: );

Line 989: hr_utility.TRACE ('p_resource_id :'

985: || TO_CHAR (ld_period_end_date,
986: 'DD-MON-YYYY HH24:MI:SS'
987: )
988: );
989: hr_utility.TRACE ('p_resource_id :'
990: || p_resource_id
991: );
992: END IF;
993:

Line 1030: hr_utility.set_location

1026: CLOSE c_period_exists_chk;
1027:
1028: IF g_debug
1029: THEN
1030: hr_utility.set_location
1031: ('populate_missing_time_periods',
1032: 170
1033: );
1034: END IF;

Line 1039: hr_utility.set_location ('populate_missing_time_periods',

1035: END IF;
1036:
1037: IF g_debug
1038: THEN
1039: hr_utility.set_location ('populate_missing_time_periods',
1040: 180
1041: );
1042: END IF;
1043: END LOOP;

Line 1051: hr_utility.set_location ('populate_missing_time_periods', 190);

1047: lv_row_found := 'N';
1048:
1049: IF g_debug
1050: THEN
1051: hr_utility.set_location ('populate_missing_time_periods', 190);
1052: hr_utility.TRACE ( 'lv_end_date :'
1053: || TO_CHAR (lv_end_date,
1054: 'DD-MON-YYYY HH24:MI:SS'
1055: )

Line 1052: hr_utility.TRACE ( 'lv_end_date :'

1048:
1049: IF g_debug
1050: THEN
1051: hr_utility.set_location ('populate_missing_time_periods', 190);
1052: hr_utility.TRACE ( 'lv_end_date :'
1053: || TO_CHAR (lv_end_date,
1054: 'DD-MON-YYYY HH24:MI:SS'
1055: )
1056: );

Line 1057: hr_utility.TRACE ( 'p_start_date :'

1053: || TO_CHAR (lv_end_date,
1054: 'DD-MON-YYYY HH24:MI:SS'
1055: )
1056: );
1057: hr_utility.TRACE ( 'p_start_date :'
1058: || TO_CHAR (p_start_date,
1059: 'DD-MON-YYYY HH24:MI:SS'
1060: )
1061: );

Line 1069: hr_utility.set_location ('populate_missing_time_periods', 200);

1065: EXIT WHEN lv_end_date < l_p_start_date;
1066: ELSE
1067: IF g_debug
1068: THEN
1069: hr_utility.set_location ('populate_missing_time_periods', 200);
1070: END IF;
1071:
1072: p_period_start := '';
1073: p_period_end := '';

Line 1081: hr_utility.TRACE ( 'p_period_start :'

1077: lv_row_found := 'N';
1078:
1079: IF g_debug
1080: THEN
1081: hr_utility.TRACE ( 'p_period_start :'
1082: || TO_CHAR (p_period_start,
1083: 'DD-MON-YYYY HH24:MI:SS'
1084: )
1085: );

Line 1086: hr_utility.TRACE ( 'p_period_end :'

1082: || TO_CHAR (p_period_start,
1083: 'DD-MON-YYYY HH24:MI:SS'
1084: )
1085: );
1086: hr_utility.TRACE ( 'p_period_end :'
1087: || TO_CHAR (p_period_end,
1088: 'DD-MON-YYYY HH24:MI:SS'
1089: )
1090: );

Line 1091: hr_utility.TRACE ( 'l_start_date :'

1087: || TO_CHAR (p_period_end,
1088: 'DD-MON-YYYY HH24:MI:SS'
1089: )
1090: );
1091: hr_utility.TRACE ( 'l_start_date :'
1092: || TO_CHAR (l_start_date,
1093: 'DD-MON-YYYY HH24:MI:SS'
1094: )
1095: );

Line 1096: hr_utility.TRACE ( 'l_period_end_date :'

1092: || TO_CHAR (l_start_date,
1093: 'DD-MON-YYYY HH24:MI:SS'
1094: )
1095: );
1096: hr_utility.TRACE ( 'l_period_end_date :'
1097: || TO_CHAR (l_period_end_date,
1098: 'DD-MON-YYYY HH24:MI:SS'
1099: )
1100: );

Line 1101: hr_utility.TRACE ( 'lv_end_date :'

1097: || TO_CHAR (l_period_end_date,
1098: 'DD-MON-YYYY HH24:MI:SS'
1099: )
1100: );
1101: hr_utility.TRACE ( 'lv_end_date :'
1102: || TO_CHAR (lv_end_date,
1103: 'DD-MON-YYYY HH24:MI:SS'
1104: )
1105: );

Line 1106: hr_utility.TRACE ('lv_row_found :' || lv_row_found);

1102: || TO_CHAR (lv_end_date,
1103: 'DD-MON-YYYY HH24:MI:SS'
1104: )
1105: );
1106: hr_utility.TRACE ('lv_row_found :' || lv_row_found);
1107: END IF;
1108: END IF;
1109:
1110: IF g_debug

Line 1112: hr_utility.set_location ('populate_missing_time_periods', 210);

1108: END IF;
1109:
1110: IF g_debug
1111: THEN
1112: hr_utility.set_location ('populate_missing_time_periods', 210);
1113: END IF;
1114:
1115: l_index := l_period_list.NEXT (l_index);
1116: END LOOP;

Line 1121: hr_utility.set_location ('populate_missing_time_periods', 220);

1117: END IF; /* Bug: 5484502 */
1118:
1119: IF g_debug
1120: THEN
1121: hr_utility.set_location ('populate_missing_time_periods', 220);
1122: END IF;
1123:
1124: IF g_time_periods.COUNT > 0
1125: THEN

Line 1130: hr_utility.set_location ('populate_missing_time_periods', 230);

1126: FOR i IN g_time_periods.FIRST .. g_time_periods.LAST
1127: LOOP
1128: IF g_debug
1129: THEN
1130: hr_utility.set_location ('populate_missing_time_periods', 230);
1131: hr_utility.TRACE ('i ' || i);
1132: hr_utility.TRACE ( 'Start time '
1133: || TO_CHAR (g_time_periods (i).start_time,
1134: 'dd/mm/yyyy'

Line 1131: hr_utility.TRACE ('i ' || i);

1127: LOOP
1128: IF g_debug
1129: THEN
1130: hr_utility.set_location ('populate_missing_time_periods', 230);
1131: hr_utility.TRACE ('i ' || i);
1132: hr_utility.TRACE ( 'Start time '
1133: || TO_CHAR (g_time_periods (i).start_time,
1134: 'dd/mm/yyyy'
1135: )

Line 1132: hr_utility.TRACE ( 'Start time '

1128: IF g_debug
1129: THEN
1130: hr_utility.set_location ('populate_missing_time_periods', 230);
1131: hr_utility.TRACE ('i ' || i);
1132: hr_utility.TRACE ( 'Start time '
1133: || TO_CHAR (g_time_periods (i).start_time,
1134: 'dd/mm/yyyy'
1135: )
1136: );

Line 1137: hr_utility.TRACE ( 'Stop time '

1133: || TO_CHAR (g_time_periods (i).start_time,
1134: 'dd/mm/yyyy'
1135: )
1136: );
1137: hr_utility.TRACE ( 'Stop time '
1138: || TO_CHAR (g_time_periods (i).stop_time,
1139: 'dd/mm/yyyy'
1140: )
1141: );

Line 1148: hr_utility.TRACE ('g_time_periods.count ' || g_time_periods.COUNT);

1144: END IF;
1145:
1146: IF g_debug
1147: THEN
1148: hr_utility.TRACE ('g_time_periods.count ' || g_time_periods.COUNT);
1149: END IF;
1150:
1151:
1152: -- Bug 10084099

Line 1183: g_debug := hr_utility.debug_enabled;

1179: l_start_time DATE;
1180: l_stop_time DATE;
1181: l_resource_id NUMBER;
1182: BEGIN
1183: g_debug := hr_utility.debug_enabled;
1184:
1185: --if p_rownum <= g_time_periods.count then
1186: IF ( p_rownum <= g_time_periods.COUNT
1187: AND p_resource_id = g_time_periods (p_rownum - 1).resource_id

Line 1192: hr_utility.set_location ('retrieve_missing_time_periods', 10);

1188: )
1189: THEN
1190: IF g_debug
1191: THEN
1192: hr_utility.set_location ('retrieve_missing_time_periods', 10);
1193: hr_utility.TRACE ('p_rownum ' || p_rownum);
1194: --l_count := p_count - p_rownum;
1195: hr_utility.TRACE ( 'Start time '
1196: || TO_CHAR

Line 1193: hr_utility.TRACE ('p_rownum ' || p_rownum);

1189: THEN
1190: IF g_debug
1191: THEN
1192: hr_utility.set_location ('retrieve_missing_time_periods', 10);
1193: hr_utility.TRACE ('p_rownum ' || p_rownum);
1194: --l_count := p_count - p_rownum;
1195: hr_utility.TRACE ( 'Start time '
1196: || TO_CHAR
1197: (g_time_periods (p_rownum - 1).start_time,

Line 1195: hr_utility.TRACE ( 'Start time '

1191: THEN
1192: hr_utility.set_location ('retrieve_missing_time_periods', 10);
1193: hr_utility.TRACE ('p_rownum ' || p_rownum);
1194: --l_count := p_count - p_rownum;
1195: hr_utility.TRACE ( 'Start time '
1196: || TO_CHAR
1197: (g_time_periods (p_rownum - 1).start_time,
1198: 'dd/mm/yyyy'
1199: )

Line 1201: hr_utility.TRACE ( 'Stop time '

1197: (g_time_periods (p_rownum - 1).start_time,
1198: 'dd/mm/yyyy'
1199: )
1200: );
1201: hr_utility.TRACE ( 'Stop time '
1202: || TO_CHAR
1203: (g_time_periods (p_rownum - 1).stop_time,
1204: 'dd/mm/yyyy'
1205: )

Line 1214: -- hr_utility.set_location('retrieve_missing_time_periods', 160);

1210: l_stop_time := TO_CHAR (g_time_periods (p_rownum - 1).stop_time);
1211: l_resource_id := g_time_periods (p_rownum - 1).resource_id;
1212: -- if g_debug then
1213: -- for i in g_time_periods.first .. g_time_periods.last loop
1214: -- hr_utility.set_location('retrieve_missing_time_periods', 160);
1215: -- hr_utility.trace('i '|| i);
1216: -- hr_utility.trace('Start time '
1217: -- || to_char(g_time_periods(i).start_time, 'dd/mm/yyyy'));
1218: -- hr_utility.trace('Stop time '

Line 1215: -- hr_utility.trace('i '|| i);

1211: l_resource_id := g_time_periods (p_rownum - 1).resource_id;
1212: -- if g_debug then
1213: -- for i in g_time_periods.first .. g_time_periods.last loop
1214: -- hr_utility.set_location('retrieve_missing_time_periods', 160);
1215: -- hr_utility.trace('i '|| i);
1216: -- hr_utility.trace('Start time '
1217: -- || to_char(g_time_periods(i).start_time, 'dd/mm/yyyy'));
1218: -- hr_utility.trace('Stop time '
1219: -- || to_char(g_time_periods(i).stop_time, 'dd/mm/yyyy'));

Line 1216: -- hr_utility.trace('Start time '

1212: -- if g_debug then
1213: -- for i in g_time_periods.first .. g_time_periods.last loop
1214: -- hr_utility.set_location('retrieve_missing_time_periods', 160);
1215: -- hr_utility.trace('i '|| i);
1216: -- hr_utility.trace('Start time '
1217: -- || to_char(g_time_periods(i).start_time, 'dd/mm/yyyy'));
1218: -- hr_utility.trace('Stop time '
1219: -- || to_char(g_time_periods(i).stop_time, 'dd/mm/yyyy'));
1220: -- end loop;

Line 1218: -- hr_utility.trace('Stop time '

1214: -- hr_utility.set_location('retrieve_missing_time_periods', 160);
1215: -- hr_utility.trace('i '|| i);
1216: -- hr_utility.trace('Start time '
1217: -- || to_char(g_time_periods(i).start_time, 'dd/mm/yyyy'));
1218: -- hr_utility.trace('Stop time '
1219: -- || to_char(g_time_periods(i).stop_time, 'dd/mm/yyyy'));
1220: -- end loop;
1221: -- hr_utility.trace('g_time_periods.count '|| g_time_periods.count);
1222: -- end if;

Line 1221: -- hr_utility.trace('g_time_periods.count '|| g_time_periods.count);

1217: -- || to_char(g_time_periods(i).start_time, 'dd/mm/yyyy'));
1218: -- hr_utility.trace('Stop time '
1219: -- || to_char(g_time_periods(i).stop_time, 'dd/mm/yyyy'));
1220: -- end loop;
1221: -- hr_utility.trace('g_time_periods.count '|| g_time_periods.count);
1222: -- end if;
1223: RETURN (l_start_time || l_stop_time || l_resource_id);
1224: ELSE
1225: IF g_debug

Line 1227: hr_utility.TRACE ('Passed values did not match, abt to delete the table.');

1223: RETURN (l_start_time || l_stop_time || l_resource_id);
1224: ELSE
1225: IF g_debug
1226: THEN
1227: hr_utility.TRACE ('Passed values did not match, abt to delete the table.');
1228: END IF;
1229:
1230: IF g_time_periods.COUNT > 0
1231: THEN

Line 1234: hr_utility.set_location ('populate_missing_time_periods', 20);

1230: IF g_time_periods.COUNT > 0
1231: THEN
1232: IF g_debug
1233: THEN
1234: hr_utility.set_location ('populate_missing_time_periods', 20);
1235: END IF;
1236:
1237: -- Bug 6998662
1238: -- Commented out the below loop -- when you are deleting,

Line 1251: hr_utility.TRACE ('Deleted PL/SQL table');

1247: */
1248:
1249: IF g_debug
1250: THEN
1251: hr_utility.TRACE ('Deleted PL/SQL table');
1252: END IF;
1253:
1254: g_time_periods.DELETE;
1255: END IF;