APPS.HXC_EGC_BUS dependencies on HXC_ENTITY_GROUP_COMPS

Line 275: p_entity_id in hxc_entity_group_comps.entity_id%TYPE

271: --
272: -- ----------------------------------------------------------------------------
273: Procedure chk_entity_id
274: (
275: p_entity_id in hxc_entity_group_comps.entity_id%TYPE
276: , p_entity_type in hxc_entity_group_comps.entity_type%TYPE
277: ) IS
278: --
279: l_proc varchar2(72);

Line 276: , p_entity_type in hxc_entity_group_comps.entity_type%TYPE

272: -- ----------------------------------------------------------------------------
273: Procedure chk_entity_id
274: (
275: p_entity_id in hxc_entity_group_comps.entity_id%TYPE
276: , p_entity_type in hxc_entity_group_comps.entity_type%TYPE
277: ) IS
278: --
279: l_proc varchar2(72);
280: --

Line 520: p_entity_type in hxc_entity_group_comps.entity_type%TYPE

516: --
517: -- ----------------------------------------------------------------------------
518: Procedure chk_entity_type
519: (
520: p_entity_type in hxc_entity_group_comps.entity_type%TYPE
521: , p_effective_date in DATE
522: ) IS
523: --
524: l_proc varchar2(72);

Line 586: (p_entity_group_id hxc_entity_group_comps.entity_group_id%TYPE

582: -- ----------------------------------------------------------------------------
583: -- |---------------------------< chk_dup_app_PTE >----------------------------|
584: -- ----------------------------------------------------------------------------
585: Procedure chk_dup_app_PTE
586: (p_entity_group_id hxc_entity_group_comps.entity_group_id%TYPE
587: ,p_entity_id hxc_entity_group_comps.entity_id%TYPE
588: ,p_entity_group_comp_id hxc_entity_group_comps.entity_group_comp_id%TYPE
589: ) is
590: cursor csr_chk_dup_app is

Line 587: ,p_entity_id hxc_entity_group_comps.entity_id%TYPE

583: -- |---------------------------< chk_dup_app_PTE >----------------------------|
584: -- ----------------------------------------------------------------------------
585: Procedure chk_dup_app_PTE
586: (p_entity_group_id hxc_entity_group_comps.entity_group_id%TYPE
587: ,p_entity_id hxc_entity_group_comps.entity_id%TYPE
588: ,p_entity_group_comp_id hxc_entity_group_comps.entity_group_comp_id%TYPE
589: ) is
590: cursor csr_chk_dup_app is
591: select 'Y'

Line 588: ,p_entity_group_comp_id hxc_entity_group_comps.entity_group_comp_id%TYPE

584: -- ----------------------------------------------------------------------------
585: Procedure chk_dup_app_PTE
586: (p_entity_group_id hxc_entity_group_comps.entity_group_id%TYPE
587: ,p_entity_id hxc_entity_group_comps.entity_id%TYPE
588: ,p_entity_group_comp_id hxc_entity_group_comps.entity_group_comp_id%TYPE
589: ) is
590: cursor csr_chk_dup_app is
591: select 'Y'
592: from hxc_entity_groups heg,

Line 593: hxc_entity_group_comps hec,

589: ) is
590: cursor csr_chk_dup_app is
591: select 'Y'
592: from hxc_entity_groups heg,
593: hxc_entity_group_comps hec,
594: hxc_time_entry_rules hte1,
595: hxc_time_entry_rules hte2
596: where heg.entity_type = 'TIME_ENTRY_RULES' and
597: heg.entity_group_id = nvl(p_entity_group_id,-999) and