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

50: reference_object
51: from hxc_mapping_components hmc,
52: hxc_alias_types hat,
53: hxc_alias_type_components hatc,
54: hxc_alias_definitions had,
55: hxc_bld_blk_info_type_usages bldu,
56: hxc_bld_blk_info_types bld
57: where had.alias_definition_id = 1
58: and had.alias_type_id = hat.alias_type_id

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

1090: reference_object
1091: from hxc_mapping_components hmc,
1092: hxc_alias_types hat,
1093: hxc_alias_type_components hatc,
1094: hxc_alias_definitions had,
1095: hxc_bld_blk_info_type_usages bldu,
1096: hxc_bld_blk_info_types bld
1097: where had.alias_definition_id = p_alias_definition_id
1098: and had.alias_type_id = hat.alias_type_id

Line 1250: hxc_alias_definitions had,

1246: reference_object
1247: from hxc_mapping_components hmc,
1248: hxc_alias_types hat,
1249: hxc_alias_type_components hatc,
1250: hxc_alias_definitions had,
1251: hxc_bld_blk_info_type_usages bldu,
1252: hxc_bld_blk_info_types bld
1253: where had.alias_definition_id = p_alias_definition_id
1254: and had.alias_type_id = hat.alias_type_id

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

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

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

3360:
3361: x_select := 'select distinct(havtl.alias_value_name) display_value, havtl.alias_value_id id_value '||
3362: 'from hxc_alias_values_tl havtl,'||
3363: 'hxc_alias_values hav,'||
3364: 'hxc_alias_definitions had,'||
3365: 'pa_online_expenditure_types_v pa,'||
3366: 'PAY_ELEMENT_TYPES_F_TL ELEMENTTL, '||
3367: 'PAY_ELEMENT_TYPES_F ELEMENT, '||
3368: 'PAY_ELEMENT_CLASSIFICATIONS_TL CLASSIFICATIONTL, '||

Line 3450: ' hxc_alias_definitions had, '||

3446: x_select := 'select distinct(havt.alias_value_name) Display_Value,'||
3447: ' hav.alias_value_id id_value '||
3448: 'from hxc_alias_values hav, '||
3449: ' hxc_alias_values_tl havt, '||
3450: ' hxc_alias_definitions had, '||
3451: ' PAY_ELEMENT_TYPES_F_TL ELEMENTTL, '||
3452: ' PAY_ELEMENT_TYPES_F ELEMENT, '||
3453: ' PAY_ELEMENT_CLASSIFICATIONS_TL CLASSIFICATIONTL, '||
3454: ' PAY_ELEMENT_CLASSIFICATIONS CLASSIFICATION, '||

Line 3532: ' hxc_alias_definitions had '||

3528: x_select := 'select havt.alias_value_name Display_Value,'||
3529: ' hav.alias_value_id id_value '||
3530: 'from hxc_alias_values hav, '||
3531: ' hxc_alias_values_tl havt, '||
3532: ' hxc_alias_definitions had '||
3533: 'where hav.enabled_flag=''Y'' '||
3534: ' and had.alias_definition_id = hav.alias_definition_id '||
3535: ' and had.alias_definition_id = '||p_alias_definition_id||
3536: ' and havt.language = USERENV(''LANG'') '||

Line 3659: hxc_alias_definitions hd

3655: select application_table_name
3656: into l_apps_table
3657: from fnd_flex_validation_tables t,
3658: hxc_alias_types h,
3659: hxc_alias_definitions hd
3660: where t.flex_value_set_id = h.reference_object
3661: and hd.alias_definition_id = p_alias_definition_id
3662: and hd.alias_type_id = h.alias_type_id;
3663:

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:

Line 5358: from hxc_alias_definitions had,hxc_alias_types hat

5354:
5355:
5356: select reference_object
5357: into l_alias_type
5358: from hxc_alias_definitions had,hxc_alias_types hat
5359: where hat.alias_type_id =had.alias_type_id
5360: and alias_definition_id =
5361: l_pref_value(l_index_pref_val).ALIAS_DEFINITION_ID;
5362: