APPS.HXC_ALIAS_UTILS_PKG dependencies on HXC_ALIAS_DEFINITIONS

Line 12: Used by HXCALIAS (Define Alternate Names) for the hxc_alias_definitions

8: +============================================================================+
9: Name
10: hxc_alias_utils_pkg
11: Purpose
12: Used by HXCALIAS (Define Alternate Names) for the hxc_alias_definitions
13: and the hxc_alias_values blocks.
14: Notes
15:
16: History

Line 46: FROM hxc_alias_definitions_tl adtl,

42: cursor c_translation(p_language IN VARCHAR2,
43: p_alias_definition_name IN VARCHAR2,
44: p_alias_definition_id IN NUMBER) IS
45: SELECT 1
46: FROM hxc_alias_definitions_tl adtl,
47: hxc_alias_definitions ad
48: WHERE upper(adtl.alias_definition_name) =
49: upper(translate(p_alias_definition_name, '_',' '))
50: AND adtl.alias_definition_id = ad.alias_definition_id

Line 47: hxc_alias_definitions ad

43: p_alias_definition_name IN VARCHAR2,
44: p_alias_definition_id IN NUMBER) IS
45: SELECT 1
46: FROM hxc_alias_definitions_tl adtl,
47: hxc_alias_definitions ad
48: WHERE upper(adtl.alias_definition_name) =
49: upper(translate(p_alias_definition_name, '_',' '))
50: AND adtl.alias_definition_id = ad.alias_definition_id
51: AND adtl.language = p_language

Line 56: l_name hxc_alias_definitions.alias_definition_name%type

52: AND (ad.alias_definition_id <> p_alias_definition_id OR
53: p_alias_definition_id IS NULL );
54:
55: l_package_name VARCHAR2(80);
56: l_name hxc_alias_definitions.alias_definition_name%type
57: := p_alias_definition_name;
58: l_dummy varchar2(100);
59: l_dummy_number number;
60: