APPS.HXC_ATC_BUS dependencies on HXC_ALIAS_TYPE_COMPONENTS

Line 31: , hxc_alias_type_components atc

27: --
28: cursor csr_sec_grp is
29: select pbg.security_group_id
30: from per_business_groups pbg
31: , hxc_alias_type_components atc
32: where atc.alias_type_component_id = p_alias_type_component_id;
33: --
34: -- Declare local variables
35: --

Line 100: , hxc_alias_type_components atc

96: --
97: cursor csr_leg_code is
98: select pbg.legislation_code
99: from per_business_groups pbg
100: , hxc_alias_type_components atc
101: where atc.alias_type_component_id = p_alias_type_component_id;
102: --
103: -- Declare local variables
104: --

Line 221: Procedure chk_dup_comb (p_alias_type_id hxc_alias_type_components.alias_type_id%TYPE,

217: --
218: -------------------------------------------------------------------------------
219: -- |----------------------------------------------------------------|
220: -------------------------------------------------------------------------------
221: Procedure chk_dup_comb (p_alias_type_id hxc_alias_type_components.alias_type_id%TYPE,
222: p_alias_type_component_id hxc_alias_type_components.alias_type_component_id%TYPE,
223: p_mapping_component_id hxc_alias_type_components.mapping_component_id%TYPE) is
224: Cursor csr_chk_atc IS
225: select 'error'

Line 222: p_alias_type_component_id hxc_alias_type_components.alias_type_component_id%TYPE,

218: -------------------------------------------------------------------------------
219: -- |----------------------------------------------------------------|
220: -------------------------------------------------------------------------------
221: Procedure chk_dup_comb (p_alias_type_id hxc_alias_type_components.alias_type_id%TYPE,
222: p_alias_type_component_id hxc_alias_type_components.alias_type_component_id%TYPE,
223: p_mapping_component_id hxc_alias_type_components.mapping_component_id%TYPE) is
224: Cursor csr_chk_atc IS
225: select 'error'
226: from sys.dual

Line 223: p_mapping_component_id hxc_alias_type_components.mapping_component_id%TYPE) is

219: -- |----------------------------------------------------------------|
220: -------------------------------------------------------------------------------
221: Procedure chk_dup_comb (p_alias_type_id hxc_alias_type_components.alias_type_id%TYPE,
222: p_alias_type_component_id hxc_alias_type_components.alias_type_component_id%TYPE,
223: p_mapping_component_id hxc_alias_type_components.mapping_component_id%TYPE) is
224: Cursor csr_chk_atc IS
225: select 'error'
226: from sys.dual
227: where exists(

Line 229: from hxc_alias_type_components hac

225: select 'error'
226: from sys.dual
227: where exists(
228: select 'x'
229: from hxc_alias_type_components hac
230: where hac.alias_type_id = p_alias_type_id AND
231: hac.mapping_component_id = p_mapping_component_id AND
232: hac.alias_type_component_id <> nvl(p_alias_type_component_id,-999)
233: );

Line 264: Procedure chk_dup_comb_ins (p_alias_type_id hxc_alias_type_components.alias_type_id%TYPE,

260:
261: -------------------------------------------------------------------------------
262: -- |----------------------------------------------------------------|
263: -------------------------------------------------------------------------------
264: Procedure chk_dup_comb_ins (p_alias_type_id hxc_alias_type_components.alias_type_id%TYPE,
265: p_mapping_component_id hxc_alias_type_components.mapping_component_id%TYPE) is
266: Cursor csr_chk_atc IS
267: select 'error'
268: from sys.dual

Line 265: p_mapping_component_id hxc_alias_type_components.mapping_component_id%TYPE) is

261: -------------------------------------------------------------------------------
262: -- |----------------------------------------------------------------|
263: -------------------------------------------------------------------------------
264: Procedure chk_dup_comb_ins (p_alias_type_id hxc_alias_type_components.alias_type_id%TYPE,
265: p_mapping_component_id hxc_alias_type_components.mapping_component_id%TYPE) is
266: Cursor csr_chk_atc IS
267: select 'error'
268: from sys.dual
269: where exists(

Line 271: from hxc_alias_type_components hac

267: select 'error'
268: from sys.dual
269: where exists(
270: select 'x'
271: from hxc_alias_type_components hac
272: where hac.alias_type_id = p_alias_type_id AND
273: hac.mapping_component_id = p_mapping_component_id
274: );
275: