APPS.HXC_ALIAS_UTILS_PKG dependencies on HXC_ALIAS_VALUES

Line 13: and the hxc_alias_values blocks.

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
17: 01-Nov-00 RAMURTHY 115.0 Date created.

Line 145: FROM hxc_alias_values_tl avtl,

141: cursor c_translation(p_language IN VARCHAR2,
142: p_alias_value_name IN VARCHAR2,
143: p_alias_value_id IN NUMBER) IS
144: SELECT 1
145: FROM hxc_alias_values_tl avtl,
146: hxc_alias_values av
147: WHERE upper(avtl.alias_value_name) =
148: upper(translate(p_alias_value_name, '_',' '))
149: AND avtl.alias_value_id = av.alias_value_id

Line 146: hxc_alias_values av

142: p_alias_value_name IN VARCHAR2,
143: p_alias_value_id IN NUMBER) IS
144: SELECT 1
145: FROM hxc_alias_values_tl avtl,
146: hxc_alias_values av
147: WHERE upper(avtl.alias_value_name) =
148: upper(translate(p_alias_value_name, '_',' '))
149: AND avtl.alias_value_id = av.alias_value_id
150: AND avtl.language = p_language

Line 155: l_name hxc_alias_values.alias_value_name%type := p_alias_value_name;

151: AND (av.alias_value_id <> p_alias_value_id OR
152: p_alias_value_id IS NULL );
153:
154: l_package_name VARCHAR2(80);
155: l_name hxc_alias_values.alias_value_name%type := p_alias_value_name;
156: l_dummy varchar2(100);
157: l_dummy_number number;
158:
159: BEGIN