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 121: l_alias_type hxc_alias_types.alias_type%TYPE;

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

Line 122: l_reference_object hxc_alias_types.reference_object%TYPE;

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

Line 883: hxc_alias_types hat,

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

Line 986: hxc_alias_types hat,

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

Line 1227: l_alias_type hxc_alias_types.alias_type%TYPE;

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

Line 1228: l_reference_object hxc_alias_types.reference_object%TYPE;

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

Line 2527: from hxc_alias_types hat

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

Line 2535: l_alias_type hxc_alias_types.alias_type%TYPE;

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;
2534:
2535: l_alias_type hxc_alias_types.alias_type%TYPE;
2536: l_reference_object hxc_alias_types.reference_object%TYPE;
2537:
2538: BEGIN
2539:

Line 2536: l_reference_object hxc_alias_types.reference_object%TYPE;

2532: and hadtl.language = userenv('LANG')
2533: and hadtl.alias_definition_id = p_alias_definition_id;
2534:
2535: l_alias_type hxc_alias_types.alias_type%TYPE;
2536: l_reference_object hxc_alias_types.reference_object%TYPE;
2537:
2538: BEGIN
2539:
2540: -- first look in the global table that we don't have the information

Line 2834: l_alias_type hxc_alias_types.alias_type%TYPE;

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

Line 2835: l_reference_object hxc_alias_types.reference_object%TYPE;

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

Line 2880: l_alias_type hxc_alias_types.alias_type%TYPE;

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

Line 2881: l_reference_object hxc_alias_types.reference_object%TYPE;

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

Line 2970: l_alias_type hxc_alias_types.alias_type%TYPE;

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

Line 2971: l_reference_object hxc_alias_types.reference_object%TYPE;

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

Line 3017: l_alias_type hxc_alias_types.alias_type%TYPE;

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

Line 3018: l_reference_object hxc_alias_types.reference_object%TYPE;

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

Line 3342: hxc_alias_types h,

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

Line 4377: l_alias_type hxc_alias_types.alias_type%TYPE;

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

Line 4378: l_reference_object hxc_alias_types.reference_object%TYPE;

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

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: