APPS.ENI_PROD_VALUESET dependencies on FND_FLEX_VALUES_TL

Line 91: l_new_description FND_FLEX_VALUES_TL.DESCRIPTION%TYPE;

87:
88: l_flex_value_id NUMBER;
89: l_flex_value FND_FLEX_VALUES.FLEX_VALUE%TYPE;
90: l_new_enabled_flag VARCHAR2(1);
91: l_new_description FND_FLEX_VALUES_TL.DESCRIPTION%TYPE;
92: l_new_start_date DATE;
93: l_new_end_date DATE;
94: l_old_enabled_flag VARCHAR2(1);
95: l_old_start_date DATE;

Line 98: l_old_description FND_FLEX_VALUES_TL.DESCRIPTION%TYPE;

94: l_old_enabled_flag VARCHAR2(1);
95: l_old_start_date DATE;
96: l_old_end_date DATE;
97: l_old_summary_flag VARCHAR2(1);
98: l_old_description FND_FLEX_VALUES_TL.DESCRIPTION%TYPE;
99: l_new_summary_flag VARCHAR2(1);
100: l_schema VARCHAR2(10) := 'ENI';
101:
102: table_not_found EXCEPTION;

Line 430: FND_FLEX_VALUES_TL FT,

426: AND C.PARENT_CATEGORY_ID = V.CATEGORY_ID
427: AND ROWNUM = 1), ''N'') NEW_SUMMARY_FLAG
428: FROM MTL_CATEGORIES_KFV V, MTL_CATEGORIES_TL T,
429: FND_FLEX_VALUES F,
430: FND_FLEX_VALUES_TL FT,
431: MTL_CATEGORY_SET_VALID_CATS H
432: WHERE V.STRUCTURE_ID = :l_struct_id
433: AND V.CATEGORY_ID = T.CATEGORY_ID
434: AND T.LANGUAGE = USERENV(''LANG'')