DBA Data[Home] [Help]

APPS.HXC_APP_ATTRIBUTE_UTILS dependencies on FND_DESCR_FLEX_COL_USAGE_TL

Line 299: ,fnd_descr_flex_col_usage_tl fcu

295: cursor c_prompt_name(p_comp_id in number) is
296: select substr(fcu.form_left_prompt,1,30) prompt
297: from hxc_mapping_components mc
298: ,hxc_bld_blk_info_types bbit
299: ,fnd_descr_flex_col_usage_tl fcu
300: where mc.mapping_component_id = p_comp_id
301: and mc.bld_blk_info_type_id = bbit.bld_blk_info_type_id
302: and fcu.application_column_name = mc.segment
303: and fcu.descriptive_flex_context_code = bbit.bld_blk_info_type

Line 311: l_field_prompt fnd_descr_flex_col_usage_tl.form_left_prompt%type;

307:
308: l_index number;
309: l_found boolean := false;
310: l_segment hxc_mapping_components.segment%type;
311: l_field_prompt fnd_descr_flex_col_usage_tl.form_left_prompt%type;
312: l_prompt fnd_descr_flex_col_usage_tl.form_left_prompt%type;
313: l_field_no number;
314: l_field_names hxc_deposit_wrapper_utilities.t_simple_table;
315: l_ret_string varchar2(4000) := '';

Line 312: l_prompt fnd_descr_flex_col_usage_tl.form_left_prompt%type;

308: l_index number;
309: l_found boolean := false;
310: l_segment hxc_mapping_components.segment%type;
311: l_field_prompt fnd_descr_flex_col_usage_tl.form_left_prompt%type;
312: l_prompt fnd_descr_flex_col_usage_tl.form_left_prompt%type;
313: l_field_no number;
314: l_field_names hxc_deposit_wrapper_utilities.t_simple_table;
315: l_ret_string varchar2(4000) := '';
316: l_deposit_proc number;