APPS.HXC_ALIAS_UTILITY dependencies on HXC_ALIAS_DEFINITIONS_TL

Line 187: l_prompt hxc_alias_definitions_tl.prompt%TYPE;

183: l_index_alias_def number;
184:
185: l_alias_type hxc_alias_types.alias_type%TYPE;
186: l_reference_object hxc_alias_types.reference_object%TYPE;
187: l_prompt hxc_alias_definitions_tl.prompt%TYPE;
188:
189: BEGIN
190:
191: g_debug:=hr_utility.debug_enabled;

Line 1545: l_prompt hxc_alias_definitions_tl.prompt%TYPE;

1541: RETURN BOOLEAN IS
1542:
1543: l_alias_type hxc_alias_types.alias_type%TYPE;
1544: l_reference_object hxc_alias_types.reference_object%TYPE;
1545: l_prompt hxc_alias_definitions_tl.prompt%TYPE;
1546:
1547: l_index_global NUMBER;
1548:
1549: l_find_alias BOOLEAN := FALSE;

Line 2844: , hxc_alias_definitions_tl hadtl

2840: --
2841: cursor c_alias_type is
2842: select alias_type,reference_object,prompt
2843: from hxc_alias_types hat
2844: , hxc_alias_definitions_tl hadtl
2845: , hxc_alias_definitions had
2846: where hat.alias_type_id = had.alias_type_id
2847: and had.alias_definition_id = p_alias_definition_id
2848: and hadtl.language = userenv('LANG')

Line 3152: l_prompt hxc_alias_definitions_tl.prompt%TYPE;

3148: p_id_type OUT NOCOPY VARCHAR2) IS
3149:
3150: l_alias_type hxc_alias_types.alias_type%TYPE;
3151: l_reference_object hxc_alias_types.reference_object%TYPE;
3152: l_prompt hxc_alias_definitions_tl.prompt%TYPE;
3153:
3154: l_select VARCHAR2(200);
3155: l_success NUMBER(15);
3156:

Line 3198: l_prompt hxc_alias_definitions_tl.prompt%TYPE;

3194: x_select OUT NOCOPY VARCHAR2) IS
3195:
3196: l_alias_type hxc_alias_types.alias_type%TYPE;
3197: l_reference_object hxc_alias_types.reference_object%TYPE;
3198: l_prompt hxc_alias_definitions_tl.prompt%TYPE;
3199:
3200: l_select VARCHAR2(200);
3201: l_success NUMBER(15);
3202:

Line 3288: l_prompt hxc_alias_definitions_tl.prompt%TYPE;

3284:
3285:
3286: l_alias_type hxc_alias_types.alias_type%TYPE;
3287: l_reference_object hxc_alias_types.reference_object%TYPE;
3288: l_prompt hxc_alias_definitions_tl.prompt%TYPE;
3289:
3290: l_select VARCHAR2(200);
3291: l_success NUMBER(15);
3292:

Line 3335: l_prompt hxc_alias_definitions_tl.prompt%TYPE;

3331: x_select OUT NOCOPY VARCHAR2) IS
3332:
3333: l_alias_type hxc_alias_types.alias_type%TYPE;
3334: l_reference_object hxc_alias_types.reference_object%TYPE;
3335: l_prompt hxc_alias_definitions_tl.prompt%TYPE;
3336:
3337: l_select VARCHAR2(200);
3338: l_success NUMBER(15);
3339:

Line 4695: l_prompt hxc_alias_definitions_tl.prompt%TYPE;

4691: l_pref_table hxc_preference_evaluation.t_pref_table;
4692:
4693: l_alias_type hxc_alias_types.alias_type%TYPE;
4694: l_reference_object hxc_alias_types.reference_object%TYPE;
4695: l_prompt hxc_alias_definitions_tl.prompt%TYPE;
4696:
4697:
4698: BEGIN
4699: