eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXC_HAD_BUS dependencies on HXC_ALIAS_DEFINITIONS

Line 28: -- hxc_alias_definitions and PER_BUSINESS_GROUPS

24: --
25: -- Declare cursor
26: --
27: -- EDIT_HERE In the following cursor statement add join(s) between
28: -- hxc_alias_definitions and PER_BUSINESS_GROUPS
29: -- so that the security_group_id for
30: -- the current business group context can be derived.
31: -- Remove this comment when the edit has been completed.
32: cursor csr_sec_grp is

Line 35: , hxc_alias_definitions had

31: -- Remove this comment when the edit has been completed.
32: cursor csr_sec_grp is
33: select pbg.security_group_id
34: from per_business_groups pbg
35: , hxc_alias_definitions had
36: -- , EDIT_HERE table_name(s) 333
37: where had.alias_definition_id = p_alias_definition_id;
38: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
39: --

Line 100: -- hxc_alias_definitions and PER_BUSINESS_GROUPS

96: --
97: -- Declare cursor
98: --
99: -- EDIT_HERE In the following cursor statement add join(s) between
100: -- hxc_alias_definitions and PER_BUSINESS_GROUPS
101: -- so that the legislation_code for
102: -- the current business group context can be derived.
103: -- Remove this comment when the edit has been completed.
104: cursor csr_leg_code is

Line 107: , hxc_alias_definitions had

103: -- Remove this comment when the edit has been completed.
104: cursor csr_leg_code is
105: select pbg.legislation_code
106: from per_business_groups pbg
107: , hxc_alias_definitions had
108: -- , EDIT_HERE table_name(s) 333
109: where had.alias_definition_id = p_alias_definition_id;
110: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
111: --

Line 266: p_name in hxc_alias_definitions.alias_definition_name%TYPE

262: -- {End Of Comments}
263: -- ----------------------------------------------------------------------------
264: Procedure chk_name
265: (
266: p_name in hxc_alias_definitions.alias_definition_name%TYPE
267: ,p_ovn in hxc_alias_definitions.object_version_number%TYPE
268: ,p_alias_definition_id in hxc_alias_definitions.timecard_field%TYPE
269: ,p_business_group_id in hxc_alias_definitions.business_group_id%TYPE
270: ) IS

Line 267: ,p_ovn in hxc_alias_definitions.object_version_number%TYPE

263: -- ----------------------------------------------------------------------------
264: Procedure chk_name
265: (
266: p_name in hxc_alias_definitions.alias_definition_name%TYPE
267: ,p_ovn in hxc_alias_definitions.object_version_number%TYPE
268: ,p_alias_definition_id in hxc_alias_definitions.timecard_field%TYPE
269: ,p_business_group_id in hxc_alias_definitions.business_group_id%TYPE
270: ) IS
271: --

Line 268: ,p_alias_definition_id in hxc_alias_definitions.timecard_field%TYPE

264: Procedure chk_name
265: (
266: p_name in hxc_alias_definitions.alias_definition_name%TYPE
267: ,p_ovn in hxc_alias_definitions.object_version_number%TYPE
268: ,p_alias_definition_id in hxc_alias_definitions.timecard_field%TYPE
269: ,p_business_group_id in hxc_alias_definitions.business_group_id%TYPE
270: ) IS
271: --
272: l_proc varchar2(72);

Line 269: ,p_business_group_id in hxc_alias_definitions.business_group_id%TYPE

265: (
266: p_name in hxc_alias_definitions.alias_definition_name%TYPE
267: ,p_ovn in hxc_alias_definitions.object_version_number%TYPE
268: ,p_alias_definition_id in hxc_alias_definitions.timecard_field%TYPE
269: ,p_business_group_id in hxc_alias_definitions.business_group_id%TYPE
270: ) IS
271: --
272: l_proc varchar2(72);
273: --

Line 278: FROM hxc_alias_definitions had,

274: -- cursor to check alias definition name does not overlap
275: --
276: CURSOR csr_chk_name IS
277: SELECT 'error'
278: FROM hxc_alias_definitions had,
279: hxc_alias_definitions_tl hadtl
280: WHERE hadtl.alias_definition_name = p_name
281: AND hadtl.alias_definition_id = had.alias_definition_id
282: and hadtl.language = USERENV('LANG')

Line 279: hxc_alias_definitions_tl hadtl

275: --
276: CURSOR csr_chk_name IS
277: SELECT 'error'
278: FROM hxc_alias_definitions had,
279: hxc_alias_definitions_tl hadtl
280: WHERE hadtl.alias_definition_name = p_name
281: AND hadtl.alias_definition_id = had.alias_definition_id
282: and hadtl.language = USERENV('LANG')
283: AND had.alias_definition_id <> NVL(p_alias_definition_id,9.99E125)

Line 364: p_alias_definition_id in hxc_alias_definitions.alias_definition_id%TYPE

360: -- {End Of Comments}
361: -- ----------------------------------------------------------------------------
362: Procedure chk_delete
363: (
364: p_alias_definition_id in hxc_alias_definitions.alias_definition_id%TYPE
365: ) IS
366: --
367: l_proc varchar2(72);
368: --

Line 560: p_context_name in hxc_alias_definitions.alias_context_code%TYPE

556: -- {End Of Comments}
557: -- ----------------------------------------------------------------------------
558: Procedure chk_context
559: (
560: p_context_name in hxc_alias_definitions.alias_context_code%TYPE
561: ) IS
562: --
563: l_proc varchar2(72);
564: --