APPS.HXC_ALIAS_UTILITY dependencies on HXC_ALIAS_DEFINITIONS_TL

Line 123: l_prompt hxc_alias_definitions_tl.prompt%TYPE;

119: l_index_alias_def number;
120:
121: l_alias_type hxc_alias_types.alias_type%TYPE;
122: l_reference_object hxc_alias_types.reference_object%TYPE;
123: l_prompt hxc_alias_definitions_tl.prompt%TYPE;
124:
125: BEGIN
126:
127: g_debug:=hr_utility.debug_enabled;

Line 1229: l_prompt hxc_alias_definitions_tl.prompt%TYPE;

1225: RETURN BOOLEAN IS
1226:
1227: l_alias_type hxc_alias_types.alias_type%TYPE;
1228: l_reference_object hxc_alias_types.reference_object%TYPE;
1229: l_prompt hxc_alias_definitions_tl.prompt%TYPE;
1230:
1231: l_index_global NUMBER;
1232:
1233: l_find_alias BOOLEAN := FALSE;

Line 2528: , hxc_alias_definitions_tl hadtl

2524: --
2525: cursor c_alias_type is
2526: select alias_type,reference_object,prompt
2527: from hxc_alias_types hat
2528: , hxc_alias_definitions_tl hadtl
2529: , hxc_alias_definitions had
2530: where hat.alias_type_id = had.alias_type_id
2531: and had.alias_definition_id = p_alias_definition_id
2532: and hadtl.language = userenv('LANG')

Line 2836: l_prompt hxc_alias_definitions_tl.prompt%TYPE;

2832: p_id_type OUT NOCOPY VARCHAR2) IS
2833:
2834: l_alias_type hxc_alias_types.alias_type%TYPE;
2835: l_reference_object hxc_alias_types.reference_object%TYPE;
2836: l_prompt hxc_alias_definitions_tl.prompt%TYPE;
2837:
2838: l_select VARCHAR2(200);
2839: l_success NUMBER(15);
2840:

Line 2882: l_prompt hxc_alias_definitions_tl.prompt%TYPE;

2878: x_select OUT NOCOPY VARCHAR2) IS
2879:
2880: l_alias_type hxc_alias_types.alias_type%TYPE;
2881: l_reference_object hxc_alias_types.reference_object%TYPE;
2882: l_prompt hxc_alias_definitions_tl.prompt%TYPE;
2883:
2884: l_select VARCHAR2(200);
2885: l_success NUMBER(15);
2886:

Line 2972: l_prompt hxc_alias_definitions_tl.prompt%TYPE;

2968:
2969:
2970: l_alias_type hxc_alias_types.alias_type%TYPE;
2971: l_reference_object hxc_alias_types.reference_object%TYPE;
2972: l_prompt hxc_alias_definitions_tl.prompt%TYPE;
2973:
2974: l_select VARCHAR2(200);
2975: l_success NUMBER(15);
2976:

Line 3019: l_prompt hxc_alias_definitions_tl.prompt%TYPE;

3015: x_select OUT NOCOPY VARCHAR2) IS
3016:
3017: l_alias_type hxc_alias_types.alias_type%TYPE;
3018: l_reference_object hxc_alias_types.reference_object%TYPE;
3019: l_prompt hxc_alias_definitions_tl.prompt%TYPE;
3020:
3021: l_select VARCHAR2(200);
3022: l_success NUMBER(15);
3023:

Line 4379: l_prompt hxc_alias_definitions_tl.prompt%TYPE;

4375: l_pref_table hxc_preference_evaluation.t_pref_table;
4376:
4377: l_alias_type hxc_alias_types.alias_type%TYPE;
4378: l_reference_object hxc_alias_types.reference_object%TYPE;
4379: l_prompt hxc_alias_definitions_tl.prompt%TYPE;
4380:
4381:
4382: BEGIN
4383: