DBA Data[Home] [Help]

APPS.HXC_TER_BUS dependencies on HXC_TIME_ENTRY_RULES

Line 292: p_name in hxc_time_entry_rules.name%TYPE

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

Line 293: ,p_time_entry_rule_id in hxc_time_entry_rules.time_entry_rule_id%TYPE

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

Line 294: ,p_end_date in hxc_time_entry_rules.end_date%TYPE

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

Line 295: ,p_start_date in hxc_time_entry_rules.start_date%TYPE

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

Line 306: FROM hxc_time_entry_rules ter

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 )

Line 410: p_rule_usage in hxc_time_entry_rules.rule_usage%TYPE

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

Line 491: p_mapping_id in hxc_time_entry_rules.mapping_id%TYPE

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

Line 555: p_formula_id in hxc_time_entry_rules.formula_id%TYPE

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

Line 556: ,p_start_date in hxc_time_entry_rules.start_date%TYPE

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';

Line 557: ,p_end_date in hxc_time_entry_rules.end_date%TYPE

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

Line 623: p_formula_id in hxc_time_entry_rules.formula_id%TYPE

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';

Line 624: , p_mapping_id in hxc_time_entry_rules.mapping_id%TYPE

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:

Line 648: p_name in hxc_time_entry_rules.name%TYPE

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

Line 649: ,p_start_date in hxc_time_entry_rules.start_date%TYPE

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

Line 650: ,p_end_date in hxc_time_entry_rules.end_date%TYPE

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

Line 651: ,p_ovn in hxc_time_entry_rules.object_version_number%TYPE

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

Line 662: FROM hxc_time_entry_rules ter

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 (

Line 750: p_name in hxc_time_entry_rules.name%TYPE

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

Line 751: ,p_start_date in hxc_time_entry_rules.start_date%TYPE

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

Line 752: ,p_end_date in hxc_time_entry_rules.end_date%TYPE

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

Line 753: ,p_ovn in hxc_time_entry_rules.object_version_number%TYPE

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

Line 764: FROM hxc_time_entry_rules ter

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 (

Line 855: p_time_entry_rule_id in hxc_time_entry_rules.time_entry_rule_id%TYPE

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: