6295: IS
6296: l_prompt varchar2(2000);
6297: x_prompt varchar2(2000);
6298: slash varchar2(20);
6299: CURSOR c1 IS select form_left_prompt from fnd_descr_flex_col_usage_vl
6300: where application_id=660
6301: and descriptive_flexfield_name= p_descriptive_flexfield_name
6302: and application_column_name =p_application_column_name
6303: and DESCRIPTIVE_FLEX_CONTEXT_CODE in (p_descriptive_flex_context_cod, p_desc_flex_context_cod_prior, p_desc_flex_context_cod_next, 'Global Data Elements');
6315: ELSE --Attribute Prompt
6316: IF p_descriptive_flex_context_cod IS NULL
6317: AND p_desc_flex_context_cod_prior IS NULL
6318: AND p_desc_flex_context_cod_next IS NULL THEN
6319: select form_left_prompt into l_prompt from fnd_descr_flex_col_usage_vl where application_id=660
6320: and descriptive_flexfield_name= p_descriptive_flexfield_name
6321: and application_column_name =p_application_column_name;
6322:
6323: oe_debug_pub.add('Prompt='||l_prompt);