514: -- ----------------------------------------------------------------------------
515: -- {Start Of Comments}
516: --
517: -- Description:
518: -- If the UOM is not null, check that it is contained in HR_LOOKUPS
519: -- Pre Conditions:
520: --
521: -- In Arguments:
522: -- p_uom
538: IS
539: --
540: CURSOR csr_chk_uom_exists IS
541: SELECT start_date_active, end_date_active, enabled_flag
542: FROM hr_lookups
543: WHERE lookup_type = 'UNITS'
544: and lookup_code = p_uom;
545: --
546: l_start_date DATE;
568: FETCH csr_chk_uom_exists INTO l_start_date, l_end_date, l_enabled_flag;
569: --
570: IF csr_chk_uom_exists%NOTFOUND THEN
571: --
572: -- The lookup code entered doesn't exist in hr_lookups
573: -- so error.
574: --
575: hr_utility.set_message(800, 'HR_52943_UOM_NOT_EXIST');
576: hr_utility.raise_error;
682: -- ----------------------------------------------------------------------------
683: -- {Start Of Comments}
684: --
685: -- Description:
686: -- If the CATEGORY is not null, check that it is contained in HR_LOOKUPS
687: -- and is valid
688: -- Pre Conditions:
689: --
690: -- In Arguments:
706: IS
707: --
708: CURSOR csr_check_category IS
709: SELECT start_date_active, end_date_active , enabled_flag
710: FROM hr_lookups
711: WHERE lookup_type = 'BACKFEED_BT_CATEGORY'
712: AND lookup_code = p_category;
713: --
714: l_start_date DATE;
739: FETCH csr_check_category INTO l_start_date, l_end_date, l_enabled_flag;
740: --
741: IF csr_check_category%NOTFOUND THEN
742: --
743: -- The lookup code entered doesn't exist in hr_lookups
744: -- so error.
745: --
746: hr_utility.set_message(800, 'HR_52945_CAT_NOT_EXIST');
747: hr_utility.raise_error;