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.8.12010000.3 2008/08/05 12:01:44 ubhat ship $ */
3:
4: -- g_time_periods time_periods_table;
5: g_debug BOOLEAN := hr_utility.debug_enabled;
6:
7: -- This change is in accordance to the changes in the report query
8: -- Q_Resource_Pref_Eval.
9: -- Since Application is one of the Sort Option, Application_Id needs to be

Line 182: g_debug := hr_utility.debug_enabled;

178: END IF;
179: END check_valid_period;
180:
181: BEGIN
182: g_debug := hr_utility.debug_enabled;
183:
184: IF g_debug
185: THEN
186: hr_utility.TRACE ('Inside populate missing timecard function');

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

182: g_debug := hr_utility.debug_enabled;
183:
184: IF g_debug
185: THEN
186: hr_utility.TRACE ('Inside populate missing timecard function');
187: hr_utility.set_location ('populate_missing_time_periods', 10);
188: END IF;
189:
190: IF g_time_periods.COUNT > 0

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

183:
184: IF g_debug
185: THEN
186: hr_utility.TRACE ('Inside populate missing timecard function');
187: hr_utility.set_location ('populate_missing_time_periods', 10);
188: END IF;
189:
190: IF g_time_periods.COUNT > 0
191: THEN

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

190: IF g_time_periods.COUNT > 0
191: THEN
192: IF g_debug
193: THEN
194: hr_utility.set_location ('populate_missing_time_periods', 20);
195: END IF;
196:
197: -- Following piece of code not needed since g_time_periods.delete is sufficient.
198:

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

202: -- g_time_periods(i).resource_id := null;
203: -- END LOOP;
204: IF g_debug
205: THEN
206: hr_utility.TRACE ('Deleted PL/SQL table');
207: END IF;
208:
209: g_time_periods.DELETE;
210: END IF;

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

210: END IF;
211:
212: IF g_debug
213: THEN
214: hr_utility.set_location ('populate_missing_time_periods', 25);
215: hr_utility.TRACE ( 'p_start_date:'
216: || TO_CHAR (p_start_date, 'DD-MON-YYYY HH24:MI:SS')
217: );
218: hr_utility.TRACE ( 'p_end_date :'

Line 215: hr_utility.TRACE ( 'p_start_date:'

211:
212: IF g_debug
213: THEN
214: hr_utility.set_location ('populate_missing_time_periods', 25);
215: hr_utility.TRACE ( 'p_start_date:'
216: || TO_CHAR (p_start_date, 'DD-MON-YYYY HH24:MI:SS')
217: );
218: hr_utility.TRACE ( 'p_end_date :'
219: || TO_CHAR (p_end_date, 'DD-MON-YYYY HH24:MI:SS')

Line 218: hr_utility.TRACE ( 'p_end_date :'

214: hr_utility.set_location ('populate_missing_time_periods', 25);
215: hr_utility.TRACE ( 'p_start_date:'
216: || TO_CHAR (p_start_date, 'DD-MON-YYYY HH24:MI:SS')
217: );
218: hr_utility.TRACE ( 'p_end_date :'
219: || TO_CHAR (p_end_date, 'DD-MON-YYYY HH24:MI:SS')
220: );
221: hr_utility.TRACE ('p_resource_id :' || p_resource_id);
222: END IF;

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

217: );
218: hr_utility.TRACE ( 'p_end_date :'
219: || TO_CHAR (p_end_date, 'DD-MON-YYYY HH24:MI:SS')
220: );
221: hr_utility.TRACE ('p_resource_id :' || p_resource_id);
222: END IF;
223:
224: l_p_start_date := p_start_date;
225: l_p_end_date := p_end_date;

Line 345: hr_utility.TRACE ( 'l_p_start_date:'

341: ));
342:
343: IF g_debug
344: THEN
345: hr_utility.TRACE ( 'l_p_start_date:'
346: || TO_CHAR (l_p_start_date,
347: 'dd-mon-yyyy hh24:mi:ss'
348: )
349: );

Line 350: hr_utility.TRACE ( 'l_p_end_date:'

346: || TO_CHAR (l_p_start_date,
347: 'dd-mon-yyyy hh24:mi:ss'
348: )
349: );
350: hr_utility.TRACE ( 'l_p_end_date:'
351: || TO_CHAR (l_p_end_date,
352: 'dd-mon-yyyy hh24:mi:ss'
353: )
354: );

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

376: END;
377:
378: IF g_debug
379: THEN
380: hr_utility.set_location ('populate_missing_time_periods', 26);
381: END IF;
382:
383: IF g_debug
384: THEN

Line 385: hr_utility.TRACE ( 'l_p_start_date:'

381: END IF;
382:
383: IF g_debug
384: THEN
385: hr_utility.TRACE ( 'l_p_start_date:'
386: || TO_CHAR (l_p_start_date,
387: 'DD-MON-YYYY HH24:MI:SS'
388: )
389: );

Line 390: hr_utility.TRACE ( 'l_p_end_date :'

386: || TO_CHAR (l_p_start_date,
387: 'DD-MON-YYYY HH24:MI:SS'
388: )
389: );
390: hr_utility.TRACE ( 'l_p_end_date :'
391: || TO_CHAR (l_p_end_date, 'DD-MON-YYYY HH24:MI:SS')
392: );
393: hr_utility.TRACE ( 'lv_end_date :'
394: || TO_CHAR (lv_end_date, 'DD-MON-YYYY HH24:MI:SS')

Line 393: hr_utility.TRACE ( 'lv_end_date :'

389: );
390: hr_utility.TRACE ( 'l_p_end_date :'
391: || TO_CHAR (l_p_end_date, 'DD-MON-YYYY HH24:MI:SS')
392: );
393: hr_utility.TRACE ( 'lv_end_date :'
394: || TO_CHAR (lv_end_date, 'DD-MON-YYYY HH24:MI:SS')
395: );
396: END IF;
397:

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

406: );
407:
408: IF g_debug
409: THEN
410: hr_utility.set_location ('populate_missing_time_periods', 30);
411: hr_utility.TRACE ('l_pref_tc_period = ' || l_pref_tc_period);
412: END IF;
413:
414: SELECT hrp.recurring_period_id, hrp.start_date, hrp.end_date,

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

407:
408: IF g_debug
409: THEN
410: hr_utility.set_location ('populate_missing_time_periods', 30);
411: hr_utility.TRACE ('l_pref_tc_period = ' || l_pref_tc_period);
412: END IF;
413:
414: SELECT hrp.recurring_period_id, hrp.start_date, hrp.end_date,
415: hrp.period_type, hrp.duration_in_days

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

419: WHERE hrp.recurring_period_id = l_pref_tc_period;
420:
421: IF g_debug
422: THEN
423: hr_utility.TRACE ('l_recurring_period_id:' || l_recurring_period_id);
424: hr_utility.TRACE ( 'l_start_date :'
425: || TO_CHAR (l_start_date, 'DD-MON-YYYY HH24:MI:SS')
426: );
427: hr_utility.TRACE ( 'l_end_date :'

Line 424: hr_utility.TRACE ( 'l_start_date :'

420:
421: IF g_debug
422: THEN
423: hr_utility.TRACE ('l_recurring_period_id:' || l_recurring_period_id);
424: hr_utility.TRACE ( 'l_start_date :'
425: || TO_CHAR (l_start_date, 'DD-MON-YYYY HH24:MI:SS')
426: );
427: hr_utility.TRACE ( 'l_end_date :'
428: || TO_CHAR (l_end_date, 'DD-MON-YYYY HH24:MI:SS')

Line 427: hr_utility.TRACE ( 'l_end_date :'

423: hr_utility.TRACE ('l_recurring_period_id:' || l_recurring_period_id);
424: hr_utility.TRACE ( 'l_start_date :'
425: || TO_CHAR (l_start_date, 'DD-MON-YYYY HH24:MI:SS')
426: );
427: hr_utility.TRACE ( 'l_end_date :'
428: || TO_CHAR (l_end_date, 'DD-MON-YYYY HH24:MI:SS')
429: );
430: hr_utility.TRACE ('l_period_type :' || l_period_type);
431: hr_utility.TRACE ('l_duration_in_days :' || l_duration_in_days);

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

426: );
427: hr_utility.TRACE ( 'l_end_date :'
428: || TO_CHAR (l_end_date, 'DD-MON-YYYY HH24:MI:SS')
429: );
430: hr_utility.TRACE ('l_period_type :' || l_period_type);
431: hr_utility.TRACE ('l_duration_in_days :' || l_duration_in_days);
432: hr_utility.set_location ('populate_missing_time_periods', 50);
433: END IF;
434:

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

427: hr_utility.TRACE ( 'l_end_date :'
428: || TO_CHAR (l_end_date, 'DD-MON-YYYY HH24:MI:SS')
429: );
430: hr_utility.TRACE ('l_period_type :' || l_period_type);
431: hr_utility.TRACE ('l_duration_in_days :' || l_duration_in_days);
432: hr_utility.set_location ('populate_missing_time_periods', 50);
433: END IF;
434:
435: IF l_end_date IS NULL

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

428: || TO_CHAR (l_end_date, 'DD-MON-YYYY HH24:MI:SS')
429: );
430: hr_utility.TRACE ('l_period_type :' || l_period_type);
431: hr_utility.TRACE ('l_duration_in_days :' || l_duration_in_days);
432: hr_utility.set_location ('populate_missing_time_periods', 50);
433: END IF;
434:
435: IF l_end_date IS NULL
436: THEN

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

447: END IF;
448: */
449: IF g_debug
450: THEN
451: hr_utility.set_location ('populate_missing_time_periods', 60);
452: END IF;
453:
454: l_temp_periods :=
455: hxc_period_evaluation.get_period_list

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

462: );
463:
464: IF g_debug
465: THEN
466: hr_utility.TRACE ('l_temp_periods.count ' || l_temp_periods.COUNT);
467: END IF;
468:
469: -- Since the l_temp_periods pl sql table index is not in sequence,
470: -- move these periods to l_period_list pl sql table with sequenced index

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

474:
475: LOOP
476: IF g_debug
477: THEN
478: hr_utility.set_location ('populate_missing_time_periods', 65);
479: END IF;
480:
481: EXIT WHEN NOT l_temp_periods.EXISTS (l_index);
482: l_period_list (i).start_date :=

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

488: END IF;
489:
490: IF g_debug
491: THEN
492: hr_utility.TRACE ('FYI');
493: END IF;
494:
495: IF l_period_list.COUNT <> 0
496: THEN

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

495: IF l_period_list.COUNT <> 0
496: THEN
497: IF g_debug
498: THEN
499: hr_utility.set_location ('populate_missing_time_periods', 70);
500: END IF;
501:
502: FOR l_cnt IN l_period_list.FIRST .. l_period_list.LAST
503: LOOP

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

502: FOR l_cnt IN l_period_list.FIRST .. l_period_list.LAST
503: LOOP
504: IF g_debug
505: THEN
506: hr_utility.TRACE ( 'l_period_list.start_date is:'
507: || TO_CHAR (l_period_list (l_cnt).start_date,
508: 'DD-MON-YYYY'
509: )
510: );

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

507: || TO_CHAR (l_period_list (l_cnt).start_date,
508: 'DD-MON-YYYY'
509: )
510: );
511: hr_utility.TRACE ( 'l_period_list.end_date is:'
512: || TO_CHAR (l_period_list (l_cnt).end_date,
513: 'DD-MON-YYYY'
514: )
515: );

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

517: END LOOP;
518:
519: IF g_debug
520: THEN
521: hr_utility.set_location ('populate_missing_time_periods', 75);
522: END IF;
523: END IF;
524:
525: --------------------------------------------------------------------------------

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

524:
525: --------------------------------------------------------------------------------
526: IF g_debug
527: THEN
528: hr_utility.set_location ('populate_missing_time_periods', 80);
529: END IF;
530:
531: IF l_period_list.COUNT <> 0 THEN /* Bug: 5484502 */
532:

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

533: FOR i IN REVERSE l_period_list.FIRST .. l_period_list.LAST
534: LOOP
535: IF g_debug
536: THEN
537: hr_utility.set_location ('populate_missing_time_periods', 84);
538: hr_utility.TRACE ('i :' || i);
539: END IF;
540:
541: EXIT WHEN NOT l_period_list.EXISTS (i);

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

534: LOOP
535: IF g_debug
536: THEN
537: hr_utility.set_location ('populate_missing_time_periods', 84);
538: hr_utility.TRACE ('i :' || i);
539: END IF;
540:
541: EXIT WHEN NOT l_period_list.EXISTS (i);
542:

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

541: EXIT WHEN NOT l_period_list.EXISTS (i);
542:
543: IF g_debug
544: THEN
545: hr_utility.set_location ('populate_missing_time_periods', 85);
546: END IF;
547:
548: l_start_date := l_period_list (i).start_date;
549: l_period_end_date := l_period_list (i).end_date;

Line 558: hr_utility.TRACE ( 'lv_end_date = '

554: END IF;
555:
556: IF g_debug
557: THEN
558: hr_utility.TRACE ( 'lv_end_date = '
559: || TO_CHAR (lv_end_date,
560: 'DD-MON-YYYY HH24:MI:SS'
561: )
562: );

Line 563: hr_utility.TRACE ( 'l_start_date = '

559: || TO_CHAR (lv_end_date,
560: 'DD-MON-YYYY HH24:MI:SS'
561: )
562: );
563: hr_utility.TRACE ( 'l_start_date = '
564: || TO_CHAR (l_start_date,
565: 'DD-MON-YYYY HH24:MI:SS'
566: )
567: );

Line 568: hr_utility.TRACE ( 'l_period_end_date = '

564: || TO_CHAR (l_start_date,
565: 'DD-MON-YYYY HH24:MI:SS'
566: )
567: );
568: hr_utility.TRACE ( 'l_period_end_date = '
569: || TO_CHAR (l_period_end_date,
570: 'DD-MON-YYYY HH24:MI:SS'
571: )
572: );

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

575: IF lv_end_date >= l_start_date AND lv_end_date <= l_period_end_date
576: THEN
577: IF g_debug
578: THEN
579: hr_utility.set_location ('populate_missing_time_periods', 90);
580: hr_utility.TRACE ('p_resource_id = ' || p_resource_id);
581: hr_utility.TRACE ( 'lv_end_date = '
582: || TO_CHAR (lv_end_date,
583: 'DD-MON-YYYY HH24:MI:SS'

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

576: THEN
577: IF g_debug
578: THEN
579: hr_utility.set_location ('populate_missing_time_periods', 90);
580: hr_utility.TRACE ('p_resource_id = ' || p_resource_id);
581: hr_utility.TRACE ( 'lv_end_date = '
582: || TO_CHAR (lv_end_date,
583: 'DD-MON-YYYY HH24:MI:SS'
584: )

Line 581: hr_utility.TRACE ( 'lv_end_date = '

577: IF g_debug
578: THEN
579: hr_utility.set_location ('populate_missing_time_periods', 90);
580: hr_utility.TRACE ('p_resource_id = ' || p_resource_id);
581: hr_utility.TRACE ( 'lv_end_date = '
582: || TO_CHAR (lv_end_date,
583: 'DD-MON-YYYY HH24:MI:SS'
584: )
585: );

Line 586: hr_utility.TRACE ( 'l_start_date = '

582: || TO_CHAR (lv_end_date,
583: 'DD-MON-YYYY HH24:MI:SS'
584: )
585: );
586: hr_utility.TRACE ( 'l_start_date = '
587: || TO_CHAR (l_start_date,
588: 'DD-MON-YYYY HH24:MI:SS'
589: )
590: );

Line 591: hr_utility.TRACE ( 'l_period_end_date = '

587: || TO_CHAR (l_start_date,
588: 'DD-MON-YYYY HH24:MI:SS'
589: )
590: );
591: hr_utility.TRACE ( 'l_period_end_date = '
592: || TO_CHAR (l_period_end_date,
593: 'DD-MON-YYYY HH24:MI:SS'
594: )
595: );

Line 604: hr_utility.TRACE ( 'lv_end_date:'

600: lv_end_date := p_period_start - 1;
601:
602: IF g_debug
603: THEN
604: hr_utility.TRACE ( 'lv_end_date:'
605: || TO_CHAR (lv_end_date,
606: 'DD-MON-YYYY HH24:MI:SS'
607: )
608: );

Line 616: hr_utility.TRACE ( 'p_period_start :'

612: ld_period_end_date := p_period_end;
613:
614: IF g_debug
615: THEN
616: hr_utility.TRACE ( 'p_period_start :'
617: || TO_CHAR (p_period_start,
618: 'DD-MON-YYYY HH24:MI:SS'
619: )
620: );

Line 621: hr_utility.TRACE ( 'p_period_end :'

617: || TO_CHAR (p_period_start,
618: 'DD-MON-YYYY HH24:MI:SS'
619: )
620: );
621: hr_utility.TRACE ( 'p_period_end :'
622: || TO_CHAR (p_period_end,
623: 'DD-MON-YYYY HH24:MI:SS'
624: )
625: );

Line 626: hr_utility.TRACE ( 'lv_end_date :'

622: || TO_CHAR (p_period_end,
623: 'DD-MON-YYYY HH24:MI:SS'
624: )
625: );
626: hr_utility.TRACE ( 'lv_end_date :'
627: || TO_CHAR (lv_end_date,
628: 'DD-MON-YYYY HH24:MI:SS'
629: )
630: );

Line 631: hr_utility.TRACE ( 'l_start_date :'

627: || TO_CHAR (lv_end_date,
628: 'DD-MON-YYYY HH24:MI:SS'
629: )
630: );
631: hr_utility.TRACE ( 'l_start_date :'
632: || TO_CHAR (l_start_date,
633: 'DD-MON-YYYY HH24:MI:SS'
634: )
635: );

Line 636: hr_utility.TRACE ( 'l_period_end_date :'

632: || TO_CHAR (l_start_date,
633: 'DD-MON-YYYY HH24:MI:SS'
634: )
635: );
636: hr_utility.TRACE ( 'l_period_end_date :'
637: || TO_CHAR (l_period_end_date,
638: 'DD-MON-YYYY HH24:MI:SS'
639: )
640: );

Line 648: hr_utility.set_location ('populate_missing_time_periods',

644:
645: LOOP
646: IF g_debug
647: THEN
648: hr_utility.set_location ('populate_missing_time_periods',
649: 95
650: );
651: END IF;
652:

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

654: INTO lv_start_time, lv_stop_time;
655:
656: IF g_debug
657: THEN
658: hr_utility.TRACE ('p_resource_id :' || p_resource_id);
659: hr_utility.TRACE ('lv_row_found :' || lv_row_found);
660: hr_utility.TRACE ( 'lv_start_time :'
661: || TO_CHAR (lv_start_time,
662: 'DD-MON-YYYY HH24:MI:SS'

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

655:
656: IF g_debug
657: THEN
658: hr_utility.TRACE ('p_resource_id :' || p_resource_id);
659: hr_utility.TRACE ('lv_row_found :' || lv_row_found);
660: hr_utility.TRACE ( 'lv_start_time :'
661: || TO_CHAR (lv_start_time,
662: 'DD-MON-YYYY HH24:MI:SS'
663: )

Line 660: hr_utility.TRACE ( 'lv_start_time :'

656: IF g_debug
657: THEN
658: hr_utility.TRACE ('p_resource_id :' || p_resource_id);
659: hr_utility.TRACE ('lv_row_found :' || lv_row_found);
660: hr_utility.TRACE ( 'lv_start_time :'
661: || TO_CHAR (lv_start_time,
662: 'DD-MON-YYYY HH24:MI:SS'
663: )
664: );

Line 665: hr_utility.TRACE ( 'lv_stop_time :'

661: || TO_CHAR (lv_start_time,
662: 'DD-MON-YYYY HH24:MI:SS'
663: )
664: );
665: hr_utility.TRACE ( 'lv_stop_time :'
666: || TO_CHAR (lv_stop_time,
667: 'DD-MON-YYYY HH24:MI:SS'
668: )
669: );

Line 670: hr_utility.TRACE ( 'ld_period_start_date:'

666: || TO_CHAR (lv_stop_time,
667: 'DD-MON-YYYY HH24:MI:SS'
668: )
669: );
670: hr_utility.TRACE ( 'ld_period_start_date:'
671: || TO_CHAR (ld_period_start_date,
672: 'DD-MON-YYYY HH24:MI:SS'
673: )
674: );

Line 675: hr_utility.TRACE ( 'ld_period_end_date :'

671: || TO_CHAR (ld_period_start_date,
672: 'DD-MON-YYYY HH24:MI:SS'
673: )
674: );
675: hr_utility.TRACE ( 'ld_period_end_date :'
676: || TO_CHAR (ld_period_end_date,
677: 'DD-MON-YYYY HH24:MI:SS'
678: )
679: );

Line 680: hr_utility.TRACE ( 'p_period_start :'

676: || TO_CHAR (ld_period_end_date,
677: 'DD-MON-YYYY HH24:MI:SS'
678: )
679: );
680: hr_utility.TRACE ( 'p_period_start :'
681: || TO_CHAR (p_period_start,
682: 'DD-MON-YYYY HH24:MI:SS'
683: )
684: );

Line 685: hr_utility.TRACE ( 'p_period_end :'

681: || TO_CHAR (p_period_start,
682: 'DD-MON-YYYY HH24:MI:SS'
683: )
684: );
685: hr_utility.TRACE ( 'p_period_end :'
686: || TO_CHAR (p_period_end,
687: 'DD-MON-YYYY HH24:MI:SS'
688: )
689: );

Line 696: hr_utility.set_location

692: IF c_period_exists%NOTFOUND AND lv_row_found = 'N'
693: THEN
694: IF g_debug
695: THEN
696: hr_utility.set_location
697: ('populate_missing_time_periods',
698: 100
699: );
700: END IF;

Line 717: hr_utility.set_location

713: IF c_period_exists%NOTFOUND
714: THEN
715: IF g_debug
716: THEN
717: hr_utility.set_location
718: ('populate_missing_time_periods',
719: 110
720: );
721: END IF;

Line 730: hr_utility.set_location ('populate_missing_time_periods',

726: lv_row_found := 'Y';
727:
728: IF g_debug
729: THEN
730: hr_utility.set_location ('populate_missing_time_periods',
731: 120
732: );
733: END IF;
734:

Line 740: hr_utility.set_location

736: AND TRUNC (p_period_end) < TRUNC (lv_stop_time)
737: THEN
738: IF g_debug
739: THEN
740: hr_utility.set_location
741: ('populate_missing_time_periods',
742: 130
743: );
744: END IF;

Line 751: hr_utility.TRACE ( 'ld_period_start_date:'

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

Line 756: hr_utility.TRACE ( 'ld_period_end_date :'

752: || TO_CHAR (ld_period_start_date,
753: 'DD-MON-YYYY HH24:MI:SS'
754: )
755: );
756: hr_utility.TRACE ( 'ld_period_end_date :'
757: || TO_CHAR (ld_period_end_date,
758: 'DD-MON-YYYY HH24:MI:SS'
759: )
760: );

Line 761: hr_utility.set_location ('populate_missing_time_periods',

757: || TO_CHAR (ld_period_end_date,
758: 'DD-MON-YYYY HH24:MI:SS'
759: )
760: );
761: hr_utility.set_location ('populate_missing_time_periods',
762: 140
763: );
764: END IF;
765:

Line 778: hr_utility.set_location

774: IF c_period_exists_chk%NOTFOUND
775: THEN
776: IF g_debug
777: THEN
778: hr_utility.set_location
779: ('populate_missing_time_periods',
780: 150
781: );
782: END IF;

Line 802: hr_utility.set_location

798: AND TRUNC (p_period_end) > TRUNC (lv_stop_time)
799: THEN
800: IF g_debug
801: THEN
802: hr_utility.set_location
803: ('populate_missing_time_periods',
804: 160
805: );
806: END IF;

Line 813: hr_utility.TRACE ( 'ld_period_start_date:'

809: ld_period_end_date := p_period_end;
810:
811: IF g_debug
812: THEN
813: hr_utility.TRACE ( 'ld_period_start_date:'
814: || TO_CHAR (ld_period_start_date,
815: 'DD-MON-YYYY HH24:MI:SS'
816: )
817: );

Line 818: hr_utility.TRACE ( 'ld_period_end_date :'

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

Line 823: hr_utility.TRACE ('p_resource_id :'

819: || TO_CHAR (ld_period_end_date,
820: 'DD-MON-YYYY HH24:MI:SS'
821: )
822: );
823: hr_utility.TRACE ('p_resource_id :'
824: || p_resource_id
825: );
826: END IF;
827:

Line 854: hr_utility.set_location

850: CLOSE c_period_exists_chk;
851:
852: IF g_debug
853: THEN
854: hr_utility.set_location
855: ('populate_missing_time_periods',
856: 170
857: );
858: END IF;

Line 863: hr_utility.set_location ('populate_missing_time_periods',

859: END IF;
860:
861: IF g_debug
862: THEN
863: hr_utility.set_location ('populate_missing_time_periods',
864: 180
865: );
866: END IF;
867: END LOOP;

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

871: lv_row_found := 'N';
872:
873: IF g_debug
874: THEN
875: hr_utility.set_location ('populate_missing_time_periods', 190);
876: hr_utility.TRACE ( 'lv_end_date :'
877: || TO_CHAR (lv_end_date,
878: 'DD-MON-YYYY HH24:MI:SS'
879: )

Line 876: hr_utility.TRACE ( 'lv_end_date :'

872:
873: IF g_debug
874: THEN
875: hr_utility.set_location ('populate_missing_time_periods', 190);
876: hr_utility.TRACE ( 'lv_end_date :'
877: || TO_CHAR (lv_end_date,
878: 'DD-MON-YYYY HH24:MI:SS'
879: )
880: );

Line 881: hr_utility.TRACE ( 'p_start_date :'

877: || TO_CHAR (lv_end_date,
878: 'DD-MON-YYYY HH24:MI:SS'
879: )
880: );
881: hr_utility.TRACE ( 'p_start_date :'
882: || TO_CHAR (p_start_date,
883: 'DD-MON-YYYY HH24:MI:SS'
884: )
885: );

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

889: EXIT WHEN lv_end_date < l_p_start_date;
890: ELSE
891: IF g_debug
892: THEN
893: hr_utility.set_location ('populate_missing_time_periods', 200);
894: END IF;
895:
896: p_period_start := '';
897: p_period_end := '';

Line 905: hr_utility.TRACE ( 'p_period_start :'

901: lv_row_found := 'N';
902:
903: IF g_debug
904: THEN
905: hr_utility.TRACE ( 'p_period_start :'
906: || TO_CHAR (p_period_start,
907: 'DD-MON-YYYY HH24:MI:SS'
908: )
909: );

Line 910: hr_utility.TRACE ( 'p_period_end :'

906: || TO_CHAR (p_period_start,
907: 'DD-MON-YYYY HH24:MI:SS'
908: )
909: );
910: hr_utility.TRACE ( 'p_period_end :'
911: || TO_CHAR (p_period_end,
912: 'DD-MON-YYYY HH24:MI:SS'
913: )
914: );

Line 915: hr_utility.TRACE ( 'l_start_date :'

911: || TO_CHAR (p_period_end,
912: 'DD-MON-YYYY HH24:MI:SS'
913: )
914: );
915: hr_utility.TRACE ( 'l_start_date :'
916: || TO_CHAR (l_start_date,
917: 'DD-MON-YYYY HH24:MI:SS'
918: )
919: );

Line 920: hr_utility.TRACE ( 'l_period_end_date :'

916: || TO_CHAR (l_start_date,
917: 'DD-MON-YYYY HH24:MI:SS'
918: )
919: );
920: hr_utility.TRACE ( 'l_period_end_date :'
921: || TO_CHAR (l_period_end_date,
922: 'DD-MON-YYYY HH24:MI:SS'
923: )
924: );

Line 925: hr_utility.TRACE ( 'lv_end_date :'

921: || TO_CHAR (l_period_end_date,
922: 'DD-MON-YYYY HH24:MI:SS'
923: )
924: );
925: hr_utility.TRACE ( 'lv_end_date :'
926: || TO_CHAR (lv_end_date,
927: 'DD-MON-YYYY HH24:MI:SS'
928: )
929: );

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

926: || TO_CHAR (lv_end_date,
927: 'DD-MON-YYYY HH24:MI:SS'
928: )
929: );
930: hr_utility.TRACE ('lv_row_found :' || lv_row_found);
931: END IF;
932: END IF;
933:
934: IF g_debug

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

932: END IF;
933:
934: IF g_debug
935: THEN
936: hr_utility.set_location ('populate_missing_time_periods', 210);
937: END IF;
938:
939: l_index := l_period_list.NEXT (l_index);
940: END LOOP;

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

941: END IF; /* Bug: 5484502 */
942:
943: IF g_debug
944: THEN
945: hr_utility.set_location ('populate_missing_time_periods', 220);
946: END IF;
947:
948: IF g_time_periods.COUNT > 0
949: THEN

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

950: FOR i IN g_time_periods.FIRST .. g_time_periods.LAST
951: LOOP
952: IF g_debug
953: THEN
954: hr_utility.set_location ('populate_missing_time_periods', 230);
955: hr_utility.TRACE ('i ' || i);
956: hr_utility.TRACE ( 'Start time '
957: || TO_CHAR (g_time_periods (i).start_time,
958: 'dd/mm/yyyy'

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

951: LOOP
952: IF g_debug
953: THEN
954: hr_utility.set_location ('populate_missing_time_periods', 230);
955: hr_utility.TRACE ('i ' || i);
956: hr_utility.TRACE ( 'Start time '
957: || TO_CHAR (g_time_periods (i).start_time,
958: 'dd/mm/yyyy'
959: )

Line 956: hr_utility.TRACE ( 'Start time '

952: IF g_debug
953: THEN
954: hr_utility.set_location ('populate_missing_time_periods', 230);
955: hr_utility.TRACE ('i ' || i);
956: hr_utility.TRACE ( 'Start time '
957: || TO_CHAR (g_time_periods (i).start_time,
958: 'dd/mm/yyyy'
959: )
960: );

Line 961: hr_utility.TRACE ( 'Stop time '

957: || TO_CHAR (g_time_periods (i).start_time,
958: 'dd/mm/yyyy'
959: )
960: );
961: hr_utility.TRACE ( 'Stop time '
962: || TO_CHAR (g_time_periods (i).stop_time,
963: 'dd/mm/yyyy'
964: )
965: );

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

968: END IF;
969:
970: IF g_debug
971: THEN
972: hr_utility.TRACE ('g_time_periods.count ' || g_time_periods.COUNT);
973: END IF;
974:
975: RETURN (g_time_periods.COUNT);
976: END populate_missing_time_periods;

Line 996: g_debug := hr_utility.debug_enabled;

992: l_start_time DATE;
993: l_stop_time DATE;
994: l_resource_id NUMBER;
995: BEGIN
996: g_debug := hr_utility.debug_enabled;
997:
998: --if p_rownum <= g_time_periods.count then
999: IF ( p_rownum <= g_time_periods.COUNT
1000: AND p_resource_id = g_time_periods (p_rownum - 1).resource_id

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

1001: )
1002: THEN
1003: IF g_debug
1004: THEN
1005: hr_utility.set_location ('retrieve_missing_time_periods', 10);
1006: hr_utility.TRACE ('p_rownum ' || p_rownum);
1007: --l_count := p_count - p_rownum;
1008: hr_utility.TRACE ( 'Start time '
1009: || TO_CHAR

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

1002: THEN
1003: IF g_debug
1004: THEN
1005: hr_utility.set_location ('retrieve_missing_time_periods', 10);
1006: hr_utility.TRACE ('p_rownum ' || p_rownum);
1007: --l_count := p_count - p_rownum;
1008: hr_utility.TRACE ( 'Start time '
1009: || TO_CHAR
1010: (g_time_periods (p_rownum - 1).start_time,

Line 1008: hr_utility.TRACE ( 'Start time '

1004: THEN
1005: hr_utility.set_location ('retrieve_missing_time_periods', 10);
1006: hr_utility.TRACE ('p_rownum ' || p_rownum);
1007: --l_count := p_count - p_rownum;
1008: hr_utility.TRACE ( 'Start time '
1009: || TO_CHAR
1010: (g_time_periods (p_rownum - 1).start_time,
1011: 'dd/mm/yyyy'
1012: )

Line 1014: hr_utility.TRACE ( 'Stop time '

1010: (g_time_periods (p_rownum - 1).start_time,
1011: 'dd/mm/yyyy'
1012: )
1013: );
1014: hr_utility.TRACE ( 'Stop time '
1015: || TO_CHAR
1016: (g_time_periods (p_rownum - 1).stop_time,
1017: 'dd/mm/yyyy'
1018: )

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

1023: l_stop_time := TO_CHAR (g_time_periods (p_rownum - 1).stop_time);
1024: l_resource_id := g_time_periods (p_rownum - 1).resource_id;
1025: -- if g_debug then
1026: -- for i in g_time_periods.first .. g_time_periods.last loop
1027: -- hr_utility.set_location('retrieve_missing_time_periods', 160);
1028: -- hr_utility.trace('i '|| i);
1029: -- hr_utility.trace('Start time '
1030: -- || to_char(g_time_periods(i).start_time, 'dd/mm/yyyy'));
1031: -- hr_utility.trace('Stop time '

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

1024: l_resource_id := g_time_periods (p_rownum - 1).resource_id;
1025: -- if g_debug then
1026: -- for i in g_time_periods.first .. g_time_periods.last loop
1027: -- hr_utility.set_location('retrieve_missing_time_periods', 160);
1028: -- hr_utility.trace('i '|| i);
1029: -- hr_utility.trace('Start time '
1030: -- || to_char(g_time_periods(i).start_time, 'dd/mm/yyyy'));
1031: -- hr_utility.trace('Stop time '
1032: -- || to_char(g_time_periods(i).stop_time, 'dd/mm/yyyy'));

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

1025: -- if g_debug then
1026: -- for i in g_time_periods.first .. g_time_periods.last loop
1027: -- hr_utility.set_location('retrieve_missing_time_periods', 160);
1028: -- hr_utility.trace('i '|| i);
1029: -- hr_utility.trace('Start time '
1030: -- || to_char(g_time_periods(i).start_time, 'dd/mm/yyyy'));
1031: -- hr_utility.trace('Stop time '
1032: -- || to_char(g_time_periods(i).stop_time, 'dd/mm/yyyy'));
1033: -- end loop;

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

1027: -- hr_utility.set_location('retrieve_missing_time_periods', 160);
1028: -- hr_utility.trace('i '|| i);
1029: -- hr_utility.trace('Start time '
1030: -- || to_char(g_time_periods(i).start_time, 'dd/mm/yyyy'));
1031: -- hr_utility.trace('Stop time '
1032: -- || to_char(g_time_periods(i).stop_time, 'dd/mm/yyyy'));
1033: -- end loop;
1034: -- hr_utility.trace('g_time_periods.count '|| g_time_periods.count);
1035: -- end if;

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

1030: -- || to_char(g_time_periods(i).start_time, 'dd/mm/yyyy'));
1031: -- hr_utility.trace('Stop time '
1032: -- || to_char(g_time_periods(i).stop_time, 'dd/mm/yyyy'));
1033: -- end loop;
1034: -- hr_utility.trace('g_time_periods.count '|| g_time_periods.count);
1035: -- end if;
1036: RETURN (l_start_time || l_stop_time || l_resource_id);
1037: ELSE
1038: IF g_debug

Line 1040: hr_utility.TRACE ('in else for Deleted PL/SQL table');

1036: RETURN (l_start_time || l_stop_time || l_resource_id);
1037: ELSE
1038: IF g_debug
1039: THEN
1040: hr_utility.TRACE ('in else for Deleted PL/SQL table');
1041: END IF;
1042:
1043: IF g_time_periods.COUNT > 0
1044: THEN

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

1043: IF g_time_periods.COUNT > 0
1044: THEN
1045: IF g_debug
1046: THEN
1047: hr_utility.set_location ('populate_missing_time_periods', 20);
1048: END IF;
1049:
1050: FOR i IN g_time_periods.FIRST .. g_time_periods.LAST
1051: LOOP

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

1055: END LOOP;
1056:
1057: IF g_debug
1058: THEN
1059: hr_utility.TRACE ('Deleted PL/SQL table');
1060: END IF;
1061:
1062: g_time_periods.DELETE;
1063: END IF;