DBA Data[Home] [Help]

APPS.HXC_FF_DICT dependencies on HXC_TIME_CATEGORY_UTILS_PKG

Line 345: hxc_time_category_utils_pkg.g_time_category_id := l_tc_id;

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

Line 373: hxc_time_category_utils_pkg.g_time_category_id := NULL;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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