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:
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:
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) );
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) );
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) );
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) );
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) );
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) );
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) );
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) );
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) );
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) );
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) );
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) );
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) );
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) );
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) );