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.

[Home] [Help]

APPS.HXC_ALIAS_UTILITY dependencies on HXC_ALIAS_TYPES

Line 52: hxc_alias_types hat,

48: select hmc.bld_blk_info_type_id,segment,bld_blk_info_type,
49: hatc.component_type,hatc.component_name,bldu.building_block_category,
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

Line 185: l_alias_type hxc_alias_types.alias_type%TYPE;

181:
182: l_index_alias_val_att number;
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

Line 186: l_reference_object hxc_alias_types.reference_object%TYPE;

182: l_index_alias_val_att number;
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:

Line 1092: hxc_alias_types hat,

1088: select hmc.bld_blk_info_type_id,segment,bld_blk_info_type,
1089: hatc.component_type,hatc.component_name,bldu.building_block_category,
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

Line 1248: hxc_alias_types hat,

1244: select hmc.bld_blk_info_type_id,segment,bld_blk_info_type,
1245: hatc.component_type,hatc.component_name,bldu.building_block_category,
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

Line 1543: l_alias_type hxc_alias_types.alias_type%TYPE;

1539: p_pref_start_date IN DATE,
1540: p_pref_end_date IN DATE)
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;

Line 1544: l_reference_object hxc_alias_types.reference_object%TYPE;

1540: p_pref_end_date IN DATE)
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:

Line 2843: from hxc_alias_types hat

2839: -- Cursor to find the type
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

Line 2851: l_alias_type hxc_alias_types.alias_type%TYPE;

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;
2850:
2851: l_alias_type hxc_alias_types.alias_type%TYPE;
2852: l_reference_object hxc_alias_types.reference_object%TYPE;
2853:
2854: BEGIN
2855:

Line 2852: l_reference_object hxc_alias_types.reference_object%TYPE;

2848: and hadtl.language = userenv('LANG')
2849: and hadtl.alias_definition_id = p_alias_definition_id;
2850:
2851: l_alias_type hxc_alias_types.alias_type%TYPE;
2852: l_reference_object hxc_alias_types.reference_object%TYPE;
2853:
2854: BEGIN
2855:
2856: -- first look in the global table that we don't have the information

Line 3150: l_alias_type hxc_alias_types.alias_type%TYPE;

3146: (p_alias_definition_id IN NUMBER,
3147: x_select OUT NOCOPY VARCHAR2,
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);

Line 3151: l_reference_object hxc_alias_types.reference_object%TYPE;

3147: x_select OUT NOCOPY VARCHAR2,
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);

Line 3196: l_alias_type hxc_alias_types.alias_type%TYPE;

3192: PROCEDURE get_vset_indep_type_select
3193: (p_alias_definition_id IN NUMBER,
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);

Line 3197: l_reference_object hxc_alias_types.reference_object%TYPE;

3193: (p_alias_definition_id IN NUMBER,
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);

Line 3286: l_alias_type hxc_alias_types.alias_type%TYPE;

3282: WHERE validation_type = 'N'
3283: AND flex_value_set_id = p_value_set_id;
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);

Line 3287: l_reference_object hxc_alias_types.reference_object%TYPE;

3283: AND flex_value_set_id = p_value_set_id;
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);

Line 3333: l_alias_type hxc_alias_types.alias_type%TYPE;

3329: (p_alias_definition_id IN NUMBER,
3330: p_timekeeper_person_type IN VARCHAR2 DEFAULT NULL,
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);

Line 3334: l_reference_object hxc_alias_types.reference_object%TYPE;

3330: p_timekeeper_person_type IN VARCHAR2 DEFAULT NULL,
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);

Line 3658: hxc_alias_types h,

3654:
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;

Line 4693: l_alias_type hxc_alias_types.alias_type%TYPE;

4689:
4690: l_pref_index NUMBER;
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:

Line 4694: l_reference_object hxc_alias_types.reference_object%TYPE;

4690: l_pref_index NUMBER;
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

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: