DBA Data[Home] [Help]

APPS.HXC_FF_DICT dependencies on HXC_TIME_CATEGORY_UTILS_PKG

Line 344: hxc_time_category_utils_pkg.g_time_category_id := l_tc_id;

340:
341: IF ( l_tc_name like 'OTL_DEC_%' )
342: THEN
343:
344: hxc_time_category_utils_pkg.g_time_category_id := l_tc_id;
345:
346: ELSIF ( l_tc_name like 'OTL_INC_%' )
347: THEN
348:

Line 372: hxc_time_category_utils_pkg.g_time_category_id := NULL;

368: end if;
369:
370: -- initialise g_time_category_id
371:
372: hxc_time_category_utils_pkg.g_time_category_id := NULL;
373:
374: FOR r_seg IN csr_get_flex_segments ( p_formula_name => p_formula_name )
375: LOOP
376:

Line 402: hxc_time_category_utils_pkg.g_time_category_id := TO_NUMBER(p_rule_rec.attribute1);

398: p_reference_value := TO_NUMBER(p_rule_rec.attribute1);
399:
400: ELSIF ( UPPER(r_seg.end_user_column_name) = 'TIME_CATEGORY' )
401: THEN
402: hxc_time_category_utils_pkg.g_time_category_id := TO_NUMBER(p_rule_rec.attribute1);
403:
404: ELSIF ( UPPER(r_seg.end_user_column_name) = 'ACCRUAL_PLAN' )
405: THEN
406: set_pto_time_category ( TO_NUMBER(p_rule_rec.attribute1) );

Line 435: hxc_time_category_utils_pkg.g_time_category_id := TO_NUMBER(p_rule_rec.attribute2);

431: p_reference_value := TO_NUMBER(p_rule_rec.attribute2);
432:
433: ELSIF ( UPPER(r_seg.end_user_column_name) = 'TIME_CATEGORY' )
434: THEN
435: hxc_time_category_utils_pkg.g_time_category_id := TO_NUMBER(p_rule_rec.attribute2);
436:
437: ELSIF ( UPPER(r_seg.end_user_column_name) = 'ACCRUAL_PLAN' )
438: THEN
439: set_pto_time_category ( TO_NUMBER(p_rule_rec.attribute2) );

Line 468: hxc_time_category_utils_pkg.g_time_category_id := TO_NUMBER(p_rule_rec.attribute3);

464: p_reference_value := TO_NUMBER(p_rule_rec.attribute3);
465:
466: ELSIF ( UPPER(r_seg.end_user_column_name) = 'TIME_CATEGORY' )
467: THEN
468: hxc_time_category_utils_pkg.g_time_category_id := TO_NUMBER(p_rule_rec.attribute3);
469:
470: ELSIF ( UPPER(r_seg.end_user_column_name) = 'ACCRUAL_PLAN' )
471: THEN
472: set_pto_time_category ( TO_NUMBER(p_rule_rec.attribute3) );

Line 495: hxc_time_category_utils_pkg.g_time_category_id := TO_NUMBER(p_rule_rec.attribute4);

491: p_reference_value := TO_NUMBER(p_rule_rec.attribute4);
492:
493: ELSIF ( UPPER(r_seg.end_user_column_name) = 'TIME_CATEGORY' )
494: THEN
495: hxc_time_category_utils_pkg.g_time_category_id := TO_NUMBER(p_rule_rec.attribute4);
496:
497: ELSIF ( UPPER(r_seg.end_user_column_name) = 'ACCRUAL_PLAN' )
498: THEN
499: set_pto_time_category ( TO_NUMBER(p_rule_rec.attribute4) );

Line 522: hxc_time_category_utils_pkg.g_time_category_id := TO_NUMBER(p_rule_rec.attribute5);

518: p_reference_value := TO_NUMBER(p_rule_rec.attribute5);
519:
520: ELSIF ( UPPER(r_seg.end_user_column_name) = 'TIME_CATEGORY' )
521: THEN
522: hxc_time_category_utils_pkg.g_time_category_id := TO_NUMBER(p_rule_rec.attribute5);
523:
524: ELSIF ( UPPER(r_seg.end_user_column_name) = 'ACCRUAL_PLAN' )
525: THEN
526: set_pto_time_category ( TO_NUMBER(p_rule_rec.attribute5) );

Line 549: hxc_time_category_utils_pkg.g_time_category_id := TO_NUMBER(p_rule_rec.attribute6);

545: p_reference_value := TO_NUMBER(p_rule_rec.attribute6);
546:
547: ELSIF ( UPPER(r_seg.end_user_column_name) = 'TIME_CATEGORY' )
548: THEN
549: hxc_time_category_utils_pkg.g_time_category_id := TO_NUMBER(p_rule_rec.attribute6);
550:
551: ELSIF ( UPPER(r_seg.end_user_column_name) = 'ACCRUAL_PLAN' )
552: THEN
553: set_pto_time_category ( TO_NUMBER(p_rule_rec.attribute6) );

Line 576: hxc_time_category_utils_pkg.g_time_category_id := TO_NUMBER(p_rule_rec.attribute7);

572: p_reference_value := TO_NUMBER(p_rule_rec.attribute7);
573:
574: ELSIF ( UPPER(r_seg.end_user_column_name) = 'TIME_CATEGORY' )
575: THEN
576: hxc_time_category_utils_pkg.g_time_category_id := TO_NUMBER(p_rule_rec.attribute7);
577:
578: ELSIF ( UPPER(r_seg.end_user_column_name) = 'ACCRUAL_PLAN' )
579: THEN
580: set_pto_time_category ( TO_NUMBER(p_rule_rec.attribute7) );

Line 603: hxc_time_category_utils_pkg.g_time_category_id := TO_NUMBER(p_rule_rec.attribute8);

599: p_reference_value := TO_NUMBER(p_rule_rec.attribute8);
600:
601: ELSIF ( UPPER(r_seg.end_user_column_name) = 'TIME_CATEGORY' )
602: THEN
603: hxc_time_category_utils_pkg.g_time_category_id := TO_NUMBER(p_rule_rec.attribute8);
604:
605: ELSIF ( UPPER(r_seg.end_user_column_name) = 'ACCRUAL_PLAN' )
606: THEN
607: set_pto_time_category ( TO_NUMBER(p_rule_rec.attribute8) );

Line 630: hxc_time_category_utils_pkg.g_time_category_id := TO_NUMBER(p_rule_rec.attribute9);

626: p_reference_value := TO_NUMBER(p_rule_rec.attribute9);
627:
628: ELSIF ( UPPER(r_seg.end_user_column_name) = 'TIME_CATEGORY' )
629: THEN
630: hxc_time_category_utils_pkg.g_time_category_id := TO_NUMBER(p_rule_rec.attribute9);
631:
632: ELSIF ( UPPER(r_seg.end_user_column_name) = 'ACCRUAL_PLAN' )
633: THEN
634: set_pto_time_category ( TO_NUMBER(p_rule_rec.attribute9) );

Line 657: hxc_time_category_utils_pkg.g_time_category_id := TO_NUMBER(p_rule_rec.attribute10);

653: p_reference_value := TO_NUMBER(p_rule_rec.attribute10);
654:
655: ELSIF ( UPPER(r_seg.end_user_column_name) = 'TIME_CATEGORY' )
656: THEN
657: hxc_time_category_utils_pkg.g_time_category_id := TO_NUMBER(p_rule_rec.attribute10);
658:
659: ELSIF ( UPPER(r_seg.end_user_column_name) = 'ACCRUAL_PLAN' )
660: THEN
661: set_pto_time_category ( TO_NUMBER(p_rule_rec.attribute10) );

Line 684: hxc_time_category_utils_pkg.g_time_category_id := TO_NUMBER(p_rule_rec.attribute11);

680: p_reference_value := TO_NUMBER(p_rule_rec.attribute11);
681:
682: ELSIF ( UPPER(r_seg.end_user_column_name) = 'TIME_CATEGORY' )
683: THEN
684: hxc_time_category_utils_pkg.g_time_category_id := TO_NUMBER(p_rule_rec.attribute11);
685:
686: ELSIF ( UPPER(r_seg.end_user_column_name) = 'ACCRUAL_PLAN' )
687: THEN
688: set_pto_time_category ( TO_NUMBER(p_rule_rec.attribute11) );

Line 711: hxc_time_category_utils_pkg.g_time_category_id := TO_NUMBER(p_rule_rec.attribute12);

707: p_reference_value := TO_NUMBER(p_rule_rec.attribute12);
708:
709: ELSIF ( UPPER(r_seg.end_user_column_name) = 'TIME_CATEGORY' )
710: THEN
711: hxc_time_category_utils_pkg.g_time_category_id := TO_NUMBER(p_rule_rec.attribute12);
712:
713: ELSIF ( UPPER(r_seg.end_user_column_name) = 'ACCRUAL_PLAN' )
714: THEN
715: set_pto_time_category ( TO_NUMBER(p_rule_rec.attribute12) );

Line 738: hxc_time_category_utils_pkg.g_time_category_id := TO_NUMBER(p_rule_rec.attribute13);

734: p_reference_value := TO_NUMBER(p_rule_rec.attribute13);
735:
736: ELSIF ( UPPER(r_seg.end_user_column_name) = 'TIME_CATEGORY' )
737: THEN
738: hxc_time_category_utils_pkg.g_time_category_id := TO_NUMBER(p_rule_rec.attribute13);
739:
740: ELSIF ( UPPER(r_seg.end_user_column_name) = 'ACCRUAL_PLAN' )
741: THEN
742: set_pto_time_category ( TO_NUMBER(p_rule_rec.attribute13) );

Line 765: hxc_time_category_utils_pkg.g_time_category_id := TO_NUMBER(p_rule_rec.attribute14);

761: p_reference_value := TO_NUMBER(p_rule_rec.attribute14);
762:
763: ELSIF ( UPPER(r_seg.end_user_column_name) = 'TIME_CATEGORY' )
764: THEN
765: hxc_time_category_utils_pkg.g_time_category_id := TO_NUMBER(p_rule_rec.attribute14);
766:
767: ELSIF ( UPPER(r_seg.end_user_column_name) = 'ACCRUAL_PLAN' )
768: THEN
769: set_pto_time_category ( TO_NUMBER(p_rule_rec.attribute14) );

Line 792: hxc_time_category_utils_pkg.g_time_category_id := TO_NUMBER(p_rule_rec.attribute15);

788: p_reference_value := TO_NUMBER(p_rule_rec.attribute15);
789:
790: ELSIF ( UPPER(r_seg.end_user_column_name) = 'TIME_CATEGORY' )
791: THEN
792: hxc_time_category_utils_pkg.g_time_category_id := TO_NUMBER(p_rule_rec.attribute15);
793:
794: ELSIF ( UPPER(r_seg.end_user_column_name) = 'ACCRUAL_PLAN' )
795: THEN
796: set_pto_time_category ( TO_NUMBER(p_rule_rec.attribute15) );