288: -- {End Of Comments}
289: -- ----------------------------------------------------------------------------
290: Procedure chk_name
291: (
292: p_name in hxc_time_entry_rules.name%TYPE
293: ,p_time_entry_rule_id in hxc_time_entry_rules.time_entry_rule_id%TYPE
294: ,p_end_date in hxc_time_entry_rules.end_date%TYPE
295: ,p_start_date in hxc_time_entry_rules.start_date%TYPE
296: ,p_legislation_code VARCHAR2
289: -- ----------------------------------------------------------------------------
290: Procedure chk_name
291: (
292: p_name in hxc_time_entry_rules.name%TYPE
293: ,p_time_entry_rule_id in hxc_time_entry_rules.time_entry_rule_id%TYPE
294: ,p_end_date in hxc_time_entry_rules.end_date%TYPE
295: ,p_start_date in hxc_time_entry_rules.start_date%TYPE
296: ,p_legislation_code VARCHAR2
297: ,p_bg_id NUMBER
290: Procedure chk_name
291: (
292: p_name in hxc_time_entry_rules.name%TYPE
293: ,p_time_entry_rule_id in hxc_time_entry_rules.time_entry_rule_id%TYPE
294: ,p_end_date in hxc_time_entry_rules.end_date%TYPE
295: ,p_start_date in hxc_time_entry_rules.start_date%TYPE
296: ,p_legislation_code VARCHAR2
297: ,p_bg_id NUMBER
298: ) IS
291: (
292: p_name in hxc_time_entry_rules.name%TYPE
293: ,p_time_entry_rule_id in hxc_time_entry_rules.time_entry_rule_id%TYPE
294: ,p_end_date in hxc_time_entry_rules.end_date%TYPE
295: ,p_start_date in hxc_time_entry_rules.start_date%TYPE
296: ,p_legislation_code VARCHAR2
297: ,p_bg_id NUMBER
298: ) IS
299: --
302: -- cursor to check name does not overlap
303: --
304: CURSOR csr_chk_name IS
305: SELECT 'error'
306: FROM hxc_time_entry_rules ter
307: WHERE
308: ter.name = p_name AND
309: ( ter.time_entry_rule_id <> p_time_entry_rule_id OR
310: p_time_entry_rule_id IS NULL )
406: -- {End Of Comments}
407: -- ----------------------------------------------------------------------------
408: Procedure chk_rule_usage
409: (
410: p_rule_usage in hxc_time_entry_rules.rule_usage%TYPE
411: ) IS
412: --
413: l_proc varchar2(72);
414: --
487: -- {End Of Comments}
488: -- ----------------------------------------------------------------------------
489: Procedure chk_mapping_id
490: (
491: p_mapping_id in hxc_time_entry_rules.mapping_id%TYPE
492: ) IS
493: --
494: l_proc varchar2(72) := g_package||'chk_mapping_id';
495: --
551: -- {End Of Comments}
552: -- ----------------------------------------------------------------------------
553: Procedure chk_formula_id
554: (
555: p_formula_id in hxc_time_entry_rules.formula_id%TYPE
556: ,p_start_date in hxc_time_entry_rules.start_date%TYPE
557: ,p_end_date in hxc_time_entry_rules.end_date%TYPE
558: ) IS
559: --
552: -- ----------------------------------------------------------------------------
553: Procedure chk_formula_id
554: (
555: p_formula_id in hxc_time_entry_rules.formula_id%TYPE
556: ,p_start_date in hxc_time_entry_rules.start_date%TYPE
557: ,p_end_date in hxc_time_entry_rules.end_date%TYPE
558: ) IS
559: --
560: l_proc varchar2(72) := g_package||'chk_formula_id';
553: Procedure chk_formula_id
554: (
555: p_formula_id in hxc_time_entry_rules.formula_id%TYPE
556: ,p_start_date in hxc_time_entry_rules.start_date%TYPE
557: ,p_end_date in hxc_time_entry_rules.end_date%TYPE
558: ) IS
559: --
560: l_proc varchar2(72) := g_package||'chk_formula_id';
561: --
619: -- {End Of Comments}
620: -- ----------------------------------------------------------------------------
621: Procedure chk_formula_mapping
622: (
623: p_formula_id in hxc_time_entry_rules.formula_id%TYPE
624: , p_mapping_id in hxc_time_entry_rules.mapping_id%TYPE
625: ) IS
626:
627: l_proc varchar2(72) := g_package||'chk_formula_mapping';
620: -- ----------------------------------------------------------------------------
621: Procedure chk_formula_mapping
622: (
623: p_formula_id in hxc_time_entry_rules.formula_id%TYPE
624: , p_mapping_id in hxc_time_entry_rules.mapping_id%TYPE
625: ) IS
626:
627: l_proc varchar2(72) := g_package||'chk_formula_mapping';
628:
644: -- doc for this procedure is located in the header
645: -- ----------------------------------------------------------------------------
646: Procedure chk_start_date
647: (
648: p_name in hxc_time_entry_rules.name%TYPE
649: ,p_start_date in hxc_time_entry_rules.start_date%TYPE
650: ,p_end_date in hxc_time_entry_rules.end_date%TYPE
651: ,p_ovn in hxc_time_entry_rules.object_version_number%TYPE
652: ,p_bg_id NUMBER
645: -- ----------------------------------------------------------------------------
646: Procedure chk_start_date
647: (
648: p_name in hxc_time_entry_rules.name%TYPE
649: ,p_start_date in hxc_time_entry_rules.start_date%TYPE
650: ,p_end_date in hxc_time_entry_rules.end_date%TYPE
651: ,p_ovn in hxc_time_entry_rules.object_version_number%TYPE
652: ,p_bg_id NUMBER
653: ,p_legislation_code VARCHAR2
646: Procedure chk_start_date
647: (
648: p_name in hxc_time_entry_rules.name%TYPE
649: ,p_start_date in hxc_time_entry_rules.start_date%TYPE
650: ,p_end_date in hxc_time_entry_rules.end_date%TYPE
651: ,p_ovn in hxc_time_entry_rules.object_version_number%TYPE
652: ,p_bg_id NUMBER
653: ,p_legislation_code VARCHAR2
654: ) IS
647: (
648: p_name in hxc_time_entry_rules.name%TYPE
649: ,p_start_date in hxc_time_entry_rules.start_date%TYPE
650: ,p_end_date in hxc_time_entry_rules.end_date%TYPE
651: ,p_ovn in hxc_time_entry_rules.object_version_number%TYPE
652: ,p_bg_id NUMBER
653: ,p_legislation_code VARCHAR2
654: ) IS
655: --
658: -- cursor to check start date does not overlap
659: --
660: CURSOR csr_chk_start_date IS
661: SELECT 'error'
662: FROM hxc_time_entry_rules ter
663: WHERE
664: ter.name = p_name AND
665: ter.object_version_number <> NVL(p_ovn, -1)
666: AND (
746: -- doc for this procedure is located in the header
747: -- ----------------------------------------------------------------------------
748: Procedure chk_end_date
749: (
750: p_name in hxc_time_entry_rules.name%TYPE
751: ,p_start_date in hxc_time_entry_rules.start_date%TYPE
752: ,p_end_date in hxc_time_entry_rules.end_date%TYPE
753: ,p_ovn in hxc_time_entry_rules.object_version_number%TYPE
754: ,p_bg_id NUMBER
747: -- ----------------------------------------------------------------------------
748: Procedure chk_end_date
749: (
750: p_name in hxc_time_entry_rules.name%TYPE
751: ,p_start_date in hxc_time_entry_rules.start_date%TYPE
752: ,p_end_date in hxc_time_entry_rules.end_date%TYPE
753: ,p_ovn in hxc_time_entry_rules.object_version_number%TYPE
754: ,p_bg_id NUMBER
755: ,p_legislation_code VARCHAR2
748: Procedure chk_end_date
749: (
750: p_name in hxc_time_entry_rules.name%TYPE
751: ,p_start_date in hxc_time_entry_rules.start_date%TYPE
752: ,p_end_date in hxc_time_entry_rules.end_date%TYPE
753: ,p_ovn in hxc_time_entry_rules.object_version_number%TYPE
754: ,p_bg_id NUMBER
755: ,p_legislation_code VARCHAR2
756: ) IS
749: (
750: p_name in hxc_time_entry_rules.name%TYPE
751: ,p_start_date in hxc_time_entry_rules.start_date%TYPE
752: ,p_end_date in hxc_time_entry_rules.end_date%TYPE
753: ,p_ovn in hxc_time_entry_rules.object_version_number%TYPE
754: ,p_bg_id NUMBER
755: ,p_legislation_code VARCHAR2
756: ) IS
757: --
760: -- cursor to check start date does not overlap
761: --
762: CURSOR csr_chk_end_date IS
763: SELECT 'error'
764: FROM hxc_time_entry_rules ter
765: WHERE
766: ter.name = p_name AND
767: ter.object_version_number <> NVL(p_ovn, -1)
768: AND (
851: -- {End Of Comments}
852: -- ----------------------------------------------------------------------------
853: Procedure chk_delete
854: (
855: p_time_entry_rule_id in hxc_time_entry_rules.time_entry_rule_id%TYPE
856: ) IS
857:
858: l_proc varchar2(72);
859: