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_ALIAS_UTILITY dependencies on HXC_ALIAS_DEFINITIONS

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 885: hxc_alias_definitions had,

881: reference_object
882: from hxc_mapping_components hmc,
883: hxc_alias_types hat,
884: hxc_alias_type_components hatc,
885: hxc_alias_definitions had,
886: hxc_bld_blk_info_type_usages bldu,
887: hxc_bld_blk_info_types bld
888: where had.alias_definition_id = p_alias_definition_id
889: and had.alias_type_id = hat.alias_type_id

Line 988: hxc_alias_definitions had,

984: reference_object
985: from hxc_mapping_components hmc,
986: hxc_alias_types hat,
987: hxc_alias_type_components hatc,
988: hxc_alias_definitions had,
989: hxc_bld_blk_info_type_usages bldu,
990: hxc_bld_blk_info_types bld
991: where had.alias_definition_id = p_alias_definition_id
992: and had.alias_type_id = hat.alias_type_id

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 2529: , hxc_alias_definitions had

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')
2533: and hadtl.alias_definition_id = p_alias_definition_id;

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 3048: 'hxc_alias_definitions had,'||

3044:
3045: x_select := 'select distinct(havtl.alias_value_name) display_value, havtl.alias_value_id id_value '||
3046: 'from hxc_alias_values_tl havtl,'||
3047: 'hxc_alias_values hav,'||
3048: 'hxc_alias_definitions had,'||
3049: 'pa_online_expenditure_types_v pa,'||
3050: 'PAY_ELEMENT_TYPES_F_TL ELEMENTTL, '||
3051: 'PAY_ELEMENT_TYPES_F ELEMENT, '||
3052: 'PAY_ELEMENT_CLASSIFICATIONS_TL CLASSIFICATIONTL, '||

Line 3134: ' hxc_alias_definitions had, '||

3130: x_select := 'select distinct(havt.alias_value_name) Display_Value,'||
3131: ' hav.alias_value_id id_value '||
3132: 'from hxc_alias_values hav, '||
3133: ' hxc_alias_values_tl havt, '||
3134: ' hxc_alias_definitions had, '||
3135: ' PAY_ELEMENT_TYPES_F_TL ELEMENTTL, '||
3136: ' PAY_ELEMENT_TYPES_F ELEMENT, '||
3137: ' PAY_ELEMENT_CLASSIFICATIONS_TL CLASSIFICATIONTL, '||
3138: ' PAY_ELEMENT_CLASSIFICATIONS CLASSIFICATION, '||

Line 3216: ' hxc_alias_definitions had '||

3212: x_select := 'select havt.alias_value_name Display_Value,'||
3213: ' hav.alias_value_id id_value '||
3214: 'from hxc_alias_values hav, '||
3215: ' hxc_alias_values_tl havt, '||
3216: ' hxc_alias_definitions had '||
3217: 'where hav.enabled_flag=''Y'' '||
3218: ' and had.alias_definition_id = hav.alias_definition_id '||
3219: ' and had.alias_definition_id = '||p_alias_definition_id||
3220: ' and havt.language = USERENV(''LANG'') '||

Line 3343: hxc_alias_definitions hd

3339: select application_table_name
3340: into l_apps_table
3341: from fnd_flex_validation_tables t,
3342: hxc_alias_types h,
3343: hxc_alias_definitions hd
3344: where t.flex_value_set_id = h.reference_object
3345: and hd.alias_definition_id = p_alias_definition_id
3346: and hd.alias_type_id = h.alias_type_id;
3347:

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:

Line 5042: from hxc_alias_definitions had,hxc_alias_types hat

5038:
5039:
5040: select reference_object
5041: into l_alias_type
5042: from hxc_alias_definitions had,hxc_alias_types hat
5043: where hat.alias_type_id =had.alias_type_id
5044: and alias_definition_id =
5045: l_pref_value(l_index_pref_val).ALIAS_DEFINITION_ID;
5046: