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