223:
224: CURSOR csr_get_tag_name IS
225: SELECT TRANSLATE (UPPER(end_user_column_name), ' /','__') tag_name,
226: end_user_column_name segment_name
227: FROM fnd_descr_flex_col_usage_vl
228: WHERE descriptive_flexfield_name = p_flexfield_name
229: AND descriptive_flex_context_code = p_context_code
230: AND application_column_name = UPPER (p_node)
231: AND application_id = 801; /* Bug 6522667 */
459: ) RETURN BOOLEAN AS
460:
461: CURSOR csr_seg_enabled IS
462: SELECT 'Y'
463: FROM fnd_descr_flex_col_usage_vl
464: WHERE descriptive_flexfield_name like 'Action Information DF'
465: AND descriptive_flex_context_code = p_context_code
466: AND application_column_name like p_application_column_name
467: AND application_id = 801 /* Bug 6522667 */