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.

APPS.GL_DRM_INTEGRATION_PKG dependencies on FND_FLEX_VALUES_TL

Line 840: l_s_flex_desc_tl FND_FLEX_VALUES_TL.description%TYPE;

836: WHERE
837: l.installed_flag IN ('B','I') AND
838: l.language_code <> UserEnv('LANG');
839:
840: l_s_flex_desc_tl FND_FLEX_VALUES_TL.description%TYPE;
841: l_n_flex_value_id FND_FLEX_VALUES.flex_value_id%TYPE;
842: l_n_translate_count NUMBER;
843: l_n_notrans_count NUMBER;
844:

Line 889: UPDATE fnd_flex_values_tl

885: vl.flex_value_set_id = g_value_set_id AND
886: vl.flex_value = g_flex_values_tbl(i).flex_value;
887:
888: -- update description in MLS table
889: UPDATE fnd_flex_values_tl
890: SET
891: description = l_s_flex_desc_tl,
892: source_lang = rec_c_installed_languages.language_code,
893: last_update_date = Trunc(SYSDATE)

Line 1289: l_DESC_AR FND_FLEX_VALUES_TL.description%TYPE;

1285: l_attribute VARCHAR2(240);
1286: l_position NUMBER;
1287:
1288: -- 1235002: for translated descriptions
1289: l_DESC_AR FND_FLEX_VALUES_TL.description%TYPE;
1290: l_DESC_CS FND_FLEX_VALUES_TL.description%TYPE;
1291: l_DESC_D FND_FLEX_VALUES_TL.description%TYPE;
1292: l_DESC_DK FND_FLEX_VALUES_TL.description%TYPE;
1293: l_DESC_E FND_FLEX_VALUES_TL.description%TYPE;

Line 1290: l_DESC_CS FND_FLEX_VALUES_TL.description%TYPE;

1286: l_position NUMBER;
1287:
1288: -- 1235002: for translated descriptions
1289: l_DESC_AR FND_FLEX_VALUES_TL.description%TYPE;
1290: l_DESC_CS FND_FLEX_VALUES_TL.description%TYPE;
1291: l_DESC_D FND_FLEX_VALUES_TL.description%TYPE;
1292: l_DESC_DK FND_FLEX_VALUES_TL.description%TYPE;
1293: l_DESC_E FND_FLEX_VALUES_TL.description%TYPE;
1294: l_DESC_EL FND_FLEX_VALUES_TL.description%TYPE;

Line 1291: l_DESC_D FND_FLEX_VALUES_TL.description%TYPE;

1287:
1288: -- 1235002: for translated descriptions
1289: l_DESC_AR FND_FLEX_VALUES_TL.description%TYPE;
1290: l_DESC_CS FND_FLEX_VALUES_TL.description%TYPE;
1291: l_DESC_D FND_FLEX_VALUES_TL.description%TYPE;
1292: l_DESC_DK FND_FLEX_VALUES_TL.description%TYPE;
1293: l_DESC_E FND_FLEX_VALUES_TL.description%TYPE;
1294: l_DESC_EL FND_FLEX_VALUES_TL.description%TYPE;
1295: l_DESC_ESA FND_FLEX_VALUES_TL.description%TYPE;

Line 1292: l_DESC_DK FND_FLEX_VALUES_TL.description%TYPE;

1288: -- 1235002: for translated descriptions
1289: l_DESC_AR FND_FLEX_VALUES_TL.description%TYPE;
1290: l_DESC_CS FND_FLEX_VALUES_TL.description%TYPE;
1291: l_DESC_D FND_FLEX_VALUES_TL.description%TYPE;
1292: l_DESC_DK FND_FLEX_VALUES_TL.description%TYPE;
1293: l_DESC_E FND_FLEX_VALUES_TL.description%TYPE;
1294: l_DESC_EL FND_FLEX_VALUES_TL.description%TYPE;
1295: l_DESC_ESA FND_FLEX_VALUES_TL.description%TYPE;
1296: l_DESC_F FND_FLEX_VALUES_TL.description%TYPE;

Line 1293: l_DESC_E FND_FLEX_VALUES_TL.description%TYPE;

1289: l_DESC_AR FND_FLEX_VALUES_TL.description%TYPE;
1290: l_DESC_CS FND_FLEX_VALUES_TL.description%TYPE;
1291: l_DESC_D FND_FLEX_VALUES_TL.description%TYPE;
1292: l_DESC_DK FND_FLEX_VALUES_TL.description%TYPE;
1293: l_DESC_E FND_FLEX_VALUES_TL.description%TYPE;
1294: l_DESC_EL FND_FLEX_VALUES_TL.description%TYPE;
1295: l_DESC_ESA FND_FLEX_VALUES_TL.description%TYPE;
1296: l_DESC_F FND_FLEX_VALUES_TL.description%TYPE;
1297: l_DESC_FRC FND_FLEX_VALUES_TL.description%TYPE;

Line 1294: l_DESC_EL FND_FLEX_VALUES_TL.description%TYPE;

1290: l_DESC_CS FND_FLEX_VALUES_TL.description%TYPE;
1291: l_DESC_D FND_FLEX_VALUES_TL.description%TYPE;
1292: l_DESC_DK FND_FLEX_VALUES_TL.description%TYPE;
1293: l_DESC_E FND_FLEX_VALUES_TL.description%TYPE;
1294: l_DESC_EL FND_FLEX_VALUES_TL.description%TYPE;
1295: l_DESC_ESA FND_FLEX_VALUES_TL.description%TYPE;
1296: l_DESC_F FND_FLEX_VALUES_TL.description%TYPE;
1297: l_DESC_FRC FND_FLEX_VALUES_TL.description%TYPE;
1298: l_DESC_HR FND_FLEX_VALUES_TL.description%TYPE;

Line 1295: l_DESC_ESA FND_FLEX_VALUES_TL.description%TYPE;

1291: l_DESC_D FND_FLEX_VALUES_TL.description%TYPE;
1292: l_DESC_DK FND_FLEX_VALUES_TL.description%TYPE;
1293: l_DESC_E FND_FLEX_VALUES_TL.description%TYPE;
1294: l_DESC_EL FND_FLEX_VALUES_TL.description%TYPE;
1295: l_DESC_ESA FND_FLEX_VALUES_TL.description%TYPE;
1296: l_DESC_F FND_FLEX_VALUES_TL.description%TYPE;
1297: l_DESC_FRC FND_FLEX_VALUES_TL.description%TYPE;
1298: l_DESC_HR FND_FLEX_VALUES_TL.description%TYPE;
1299: l_DESC_HU FND_FLEX_VALUES_TL.description%TYPE;

Line 1296: l_DESC_F FND_FLEX_VALUES_TL.description%TYPE;

1292: l_DESC_DK FND_FLEX_VALUES_TL.description%TYPE;
1293: l_DESC_E FND_FLEX_VALUES_TL.description%TYPE;
1294: l_DESC_EL FND_FLEX_VALUES_TL.description%TYPE;
1295: l_DESC_ESA FND_FLEX_VALUES_TL.description%TYPE;
1296: l_DESC_F FND_FLEX_VALUES_TL.description%TYPE;
1297: l_DESC_FRC FND_FLEX_VALUES_TL.description%TYPE;
1298: l_DESC_HR FND_FLEX_VALUES_TL.description%TYPE;
1299: l_DESC_HU FND_FLEX_VALUES_TL.description%TYPE;
1300: l_DESC_I FND_FLEX_VALUES_TL.description%TYPE;

Line 1297: l_DESC_FRC FND_FLEX_VALUES_TL.description%TYPE;

1293: l_DESC_E FND_FLEX_VALUES_TL.description%TYPE;
1294: l_DESC_EL FND_FLEX_VALUES_TL.description%TYPE;
1295: l_DESC_ESA FND_FLEX_VALUES_TL.description%TYPE;
1296: l_DESC_F FND_FLEX_VALUES_TL.description%TYPE;
1297: l_DESC_FRC FND_FLEX_VALUES_TL.description%TYPE;
1298: l_DESC_HR FND_FLEX_VALUES_TL.description%TYPE;
1299: l_DESC_HU FND_FLEX_VALUES_TL.description%TYPE;
1300: l_DESC_I FND_FLEX_VALUES_TL.description%TYPE;
1301: l_DESC_IS FND_FLEX_VALUES_TL.description%TYPE;

Line 1298: l_DESC_HR FND_FLEX_VALUES_TL.description%TYPE;

1294: l_DESC_EL FND_FLEX_VALUES_TL.description%TYPE;
1295: l_DESC_ESA FND_FLEX_VALUES_TL.description%TYPE;
1296: l_DESC_F FND_FLEX_VALUES_TL.description%TYPE;
1297: l_DESC_FRC FND_FLEX_VALUES_TL.description%TYPE;
1298: l_DESC_HR FND_FLEX_VALUES_TL.description%TYPE;
1299: l_DESC_HU FND_FLEX_VALUES_TL.description%TYPE;
1300: l_DESC_I FND_FLEX_VALUES_TL.description%TYPE;
1301: l_DESC_IS FND_FLEX_VALUES_TL.description%TYPE;
1302: l_DESC_IW FND_FLEX_VALUES_TL.description%TYPE;

Line 1299: l_DESC_HU FND_FLEX_VALUES_TL.description%TYPE;

1295: l_DESC_ESA FND_FLEX_VALUES_TL.description%TYPE;
1296: l_DESC_F FND_FLEX_VALUES_TL.description%TYPE;
1297: l_DESC_FRC FND_FLEX_VALUES_TL.description%TYPE;
1298: l_DESC_HR FND_FLEX_VALUES_TL.description%TYPE;
1299: l_DESC_HU FND_FLEX_VALUES_TL.description%TYPE;
1300: l_DESC_I FND_FLEX_VALUES_TL.description%TYPE;
1301: l_DESC_IS FND_FLEX_VALUES_TL.description%TYPE;
1302: l_DESC_IW FND_FLEX_VALUES_TL.description%TYPE;
1303: l_DESC_JA FND_FLEX_VALUES_TL.description%TYPE;

Line 1300: l_DESC_I FND_FLEX_VALUES_TL.description%TYPE;

1296: l_DESC_F FND_FLEX_VALUES_TL.description%TYPE;
1297: l_DESC_FRC FND_FLEX_VALUES_TL.description%TYPE;
1298: l_DESC_HR FND_FLEX_VALUES_TL.description%TYPE;
1299: l_DESC_HU FND_FLEX_VALUES_TL.description%TYPE;
1300: l_DESC_I FND_FLEX_VALUES_TL.description%TYPE;
1301: l_DESC_IS FND_FLEX_VALUES_TL.description%TYPE;
1302: l_DESC_IW FND_FLEX_VALUES_TL.description%TYPE;
1303: l_DESC_JA FND_FLEX_VALUES_TL.description%TYPE;
1304: l_DESC_KO FND_FLEX_VALUES_TL.description%TYPE;

Line 1301: l_DESC_IS FND_FLEX_VALUES_TL.description%TYPE;

1297: l_DESC_FRC FND_FLEX_VALUES_TL.description%TYPE;
1298: l_DESC_HR FND_FLEX_VALUES_TL.description%TYPE;
1299: l_DESC_HU FND_FLEX_VALUES_TL.description%TYPE;
1300: l_DESC_I FND_FLEX_VALUES_TL.description%TYPE;
1301: l_DESC_IS FND_FLEX_VALUES_TL.description%TYPE;
1302: l_DESC_IW FND_FLEX_VALUES_TL.description%TYPE;
1303: l_DESC_JA FND_FLEX_VALUES_TL.description%TYPE;
1304: l_DESC_KO FND_FLEX_VALUES_TL.description%TYPE;
1305: l_DESC_LT FND_FLEX_VALUES_TL.description%TYPE;

Line 1302: l_DESC_IW FND_FLEX_VALUES_TL.description%TYPE;

1298: l_DESC_HR FND_FLEX_VALUES_TL.description%TYPE;
1299: l_DESC_HU FND_FLEX_VALUES_TL.description%TYPE;
1300: l_DESC_I FND_FLEX_VALUES_TL.description%TYPE;
1301: l_DESC_IS FND_FLEX_VALUES_TL.description%TYPE;
1302: l_DESC_IW FND_FLEX_VALUES_TL.description%TYPE;
1303: l_DESC_JA FND_FLEX_VALUES_TL.description%TYPE;
1304: l_DESC_KO FND_FLEX_VALUES_TL.description%TYPE;
1305: l_DESC_LT FND_FLEX_VALUES_TL.description%TYPE;
1306: l_DESC_N FND_FLEX_VALUES_TL.description%TYPE;

Line 1303: l_DESC_JA FND_FLEX_VALUES_TL.description%TYPE;

1299: l_DESC_HU FND_FLEX_VALUES_TL.description%TYPE;
1300: l_DESC_I FND_FLEX_VALUES_TL.description%TYPE;
1301: l_DESC_IS FND_FLEX_VALUES_TL.description%TYPE;
1302: l_DESC_IW FND_FLEX_VALUES_TL.description%TYPE;
1303: l_DESC_JA FND_FLEX_VALUES_TL.description%TYPE;
1304: l_DESC_KO FND_FLEX_VALUES_TL.description%TYPE;
1305: l_DESC_LT FND_FLEX_VALUES_TL.description%TYPE;
1306: l_DESC_N FND_FLEX_VALUES_TL.description%TYPE;
1307: l_DESC_NL FND_FLEX_VALUES_TL.description%TYPE;

Line 1304: l_DESC_KO FND_FLEX_VALUES_TL.description%TYPE;

1300: l_DESC_I FND_FLEX_VALUES_TL.description%TYPE;
1301: l_DESC_IS FND_FLEX_VALUES_TL.description%TYPE;
1302: l_DESC_IW FND_FLEX_VALUES_TL.description%TYPE;
1303: l_DESC_JA FND_FLEX_VALUES_TL.description%TYPE;
1304: l_DESC_KO FND_FLEX_VALUES_TL.description%TYPE;
1305: l_DESC_LT FND_FLEX_VALUES_TL.description%TYPE;
1306: l_DESC_N FND_FLEX_VALUES_TL.description%TYPE;
1307: l_DESC_NL FND_FLEX_VALUES_TL.description%TYPE;
1308: l_DESC_PL FND_FLEX_VALUES_TL.description%TYPE;

Line 1305: l_DESC_LT FND_FLEX_VALUES_TL.description%TYPE;

1301: l_DESC_IS FND_FLEX_VALUES_TL.description%TYPE;
1302: l_DESC_IW FND_FLEX_VALUES_TL.description%TYPE;
1303: l_DESC_JA FND_FLEX_VALUES_TL.description%TYPE;
1304: l_DESC_KO FND_FLEX_VALUES_TL.description%TYPE;
1305: l_DESC_LT FND_FLEX_VALUES_TL.description%TYPE;
1306: l_DESC_N FND_FLEX_VALUES_TL.description%TYPE;
1307: l_DESC_NL FND_FLEX_VALUES_TL.description%TYPE;
1308: l_DESC_PL FND_FLEX_VALUES_TL.description%TYPE;
1309: l_DESC_PT FND_FLEX_VALUES_TL.description%TYPE;

Line 1306: l_DESC_N FND_FLEX_VALUES_TL.description%TYPE;

1302: l_DESC_IW FND_FLEX_VALUES_TL.description%TYPE;
1303: l_DESC_JA FND_FLEX_VALUES_TL.description%TYPE;
1304: l_DESC_KO FND_FLEX_VALUES_TL.description%TYPE;
1305: l_DESC_LT FND_FLEX_VALUES_TL.description%TYPE;
1306: l_DESC_N FND_FLEX_VALUES_TL.description%TYPE;
1307: l_DESC_NL FND_FLEX_VALUES_TL.description%TYPE;
1308: l_DESC_PL FND_FLEX_VALUES_TL.description%TYPE;
1309: l_DESC_PT FND_FLEX_VALUES_TL.description%TYPE;
1310: l_DESC_PTB FND_FLEX_VALUES_TL.description%TYPE;

Line 1307: l_DESC_NL FND_FLEX_VALUES_TL.description%TYPE;

1303: l_DESC_JA FND_FLEX_VALUES_TL.description%TYPE;
1304: l_DESC_KO FND_FLEX_VALUES_TL.description%TYPE;
1305: l_DESC_LT FND_FLEX_VALUES_TL.description%TYPE;
1306: l_DESC_N FND_FLEX_VALUES_TL.description%TYPE;
1307: l_DESC_NL FND_FLEX_VALUES_TL.description%TYPE;
1308: l_DESC_PL FND_FLEX_VALUES_TL.description%TYPE;
1309: l_DESC_PT FND_FLEX_VALUES_TL.description%TYPE;
1310: l_DESC_PTB FND_FLEX_VALUES_TL.description%TYPE;
1311: l_DESC_RO FND_FLEX_VALUES_TL.description%TYPE;

Line 1308: l_DESC_PL FND_FLEX_VALUES_TL.description%TYPE;

1304: l_DESC_KO FND_FLEX_VALUES_TL.description%TYPE;
1305: l_DESC_LT FND_FLEX_VALUES_TL.description%TYPE;
1306: l_DESC_N FND_FLEX_VALUES_TL.description%TYPE;
1307: l_DESC_NL FND_FLEX_VALUES_TL.description%TYPE;
1308: l_DESC_PL FND_FLEX_VALUES_TL.description%TYPE;
1309: l_DESC_PT FND_FLEX_VALUES_TL.description%TYPE;
1310: l_DESC_PTB FND_FLEX_VALUES_TL.description%TYPE;
1311: l_DESC_RO FND_FLEX_VALUES_TL.description%TYPE;
1312: l_DESC_RU FND_FLEX_VALUES_TL.description%TYPE;

Line 1309: l_DESC_PT FND_FLEX_VALUES_TL.description%TYPE;

1305: l_DESC_LT FND_FLEX_VALUES_TL.description%TYPE;
1306: l_DESC_N FND_FLEX_VALUES_TL.description%TYPE;
1307: l_DESC_NL FND_FLEX_VALUES_TL.description%TYPE;
1308: l_DESC_PL FND_FLEX_VALUES_TL.description%TYPE;
1309: l_DESC_PT FND_FLEX_VALUES_TL.description%TYPE;
1310: l_DESC_PTB FND_FLEX_VALUES_TL.description%TYPE;
1311: l_DESC_RO FND_FLEX_VALUES_TL.description%TYPE;
1312: l_DESC_RU FND_FLEX_VALUES_TL.description%TYPE;
1313: l_DESC_S FND_FLEX_VALUES_TL.description%TYPE;

Line 1310: l_DESC_PTB FND_FLEX_VALUES_TL.description%TYPE;

1306: l_DESC_N FND_FLEX_VALUES_TL.description%TYPE;
1307: l_DESC_NL FND_FLEX_VALUES_TL.description%TYPE;
1308: l_DESC_PL FND_FLEX_VALUES_TL.description%TYPE;
1309: l_DESC_PT FND_FLEX_VALUES_TL.description%TYPE;
1310: l_DESC_PTB FND_FLEX_VALUES_TL.description%TYPE;
1311: l_DESC_RO FND_FLEX_VALUES_TL.description%TYPE;
1312: l_DESC_RU FND_FLEX_VALUES_TL.description%TYPE;
1313: l_DESC_S FND_FLEX_VALUES_TL.description%TYPE;
1314: l_DESC_SF FND_FLEX_VALUES_TL.description%TYPE;

Line 1311: l_DESC_RO FND_FLEX_VALUES_TL.description%TYPE;

1307: l_DESC_NL FND_FLEX_VALUES_TL.description%TYPE;
1308: l_DESC_PL FND_FLEX_VALUES_TL.description%TYPE;
1309: l_DESC_PT FND_FLEX_VALUES_TL.description%TYPE;
1310: l_DESC_PTB FND_FLEX_VALUES_TL.description%TYPE;
1311: l_DESC_RO FND_FLEX_VALUES_TL.description%TYPE;
1312: l_DESC_RU FND_FLEX_VALUES_TL.description%TYPE;
1313: l_DESC_S FND_FLEX_VALUES_TL.description%TYPE;
1314: l_DESC_SF FND_FLEX_VALUES_TL.description%TYPE;
1315: l_DESC_SK FND_FLEX_VALUES_TL.description%TYPE;

Line 1312: l_DESC_RU FND_FLEX_VALUES_TL.description%TYPE;

1308: l_DESC_PL FND_FLEX_VALUES_TL.description%TYPE;
1309: l_DESC_PT FND_FLEX_VALUES_TL.description%TYPE;
1310: l_DESC_PTB FND_FLEX_VALUES_TL.description%TYPE;
1311: l_DESC_RO FND_FLEX_VALUES_TL.description%TYPE;
1312: l_DESC_RU FND_FLEX_VALUES_TL.description%TYPE;
1313: l_DESC_S FND_FLEX_VALUES_TL.description%TYPE;
1314: l_DESC_SF FND_FLEX_VALUES_TL.description%TYPE;
1315: l_DESC_SK FND_FLEX_VALUES_TL.description%TYPE;
1316: l_DESC_SL FND_FLEX_VALUES_TL.description%TYPE;

Line 1313: l_DESC_S FND_FLEX_VALUES_TL.description%TYPE;

1309: l_DESC_PT FND_FLEX_VALUES_TL.description%TYPE;
1310: l_DESC_PTB FND_FLEX_VALUES_TL.description%TYPE;
1311: l_DESC_RO FND_FLEX_VALUES_TL.description%TYPE;
1312: l_DESC_RU FND_FLEX_VALUES_TL.description%TYPE;
1313: l_DESC_S FND_FLEX_VALUES_TL.description%TYPE;
1314: l_DESC_SF FND_FLEX_VALUES_TL.description%TYPE;
1315: l_DESC_SK FND_FLEX_VALUES_TL.description%TYPE;
1316: l_DESC_SL FND_FLEX_VALUES_TL.description%TYPE;
1317: l_DESC_TH FND_FLEX_VALUES_TL.description%TYPE;

Line 1314: l_DESC_SF FND_FLEX_VALUES_TL.description%TYPE;

1310: l_DESC_PTB FND_FLEX_VALUES_TL.description%TYPE;
1311: l_DESC_RO FND_FLEX_VALUES_TL.description%TYPE;
1312: l_DESC_RU FND_FLEX_VALUES_TL.description%TYPE;
1313: l_DESC_S FND_FLEX_VALUES_TL.description%TYPE;
1314: l_DESC_SF FND_FLEX_VALUES_TL.description%TYPE;
1315: l_DESC_SK FND_FLEX_VALUES_TL.description%TYPE;
1316: l_DESC_SL FND_FLEX_VALUES_TL.description%TYPE;
1317: l_DESC_TH FND_FLEX_VALUES_TL.description%TYPE;
1318: l_DESC_TR FND_FLEX_VALUES_TL.description%TYPE;

Line 1315: l_DESC_SK FND_FLEX_VALUES_TL.description%TYPE;

1311: l_DESC_RO FND_FLEX_VALUES_TL.description%TYPE;
1312: l_DESC_RU FND_FLEX_VALUES_TL.description%TYPE;
1313: l_DESC_S FND_FLEX_VALUES_TL.description%TYPE;
1314: l_DESC_SF FND_FLEX_VALUES_TL.description%TYPE;
1315: l_DESC_SK FND_FLEX_VALUES_TL.description%TYPE;
1316: l_DESC_SL FND_FLEX_VALUES_TL.description%TYPE;
1317: l_DESC_TH FND_FLEX_VALUES_TL.description%TYPE;
1318: l_DESC_TR FND_FLEX_VALUES_TL.description%TYPE;
1319: l_DESC_US FND_FLEX_VALUES_TL.description%TYPE;

Line 1316: l_DESC_SL FND_FLEX_VALUES_TL.description%TYPE;

1312: l_DESC_RU FND_FLEX_VALUES_TL.description%TYPE;
1313: l_DESC_S FND_FLEX_VALUES_TL.description%TYPE;
1314: l_DESC_SF FND_FLEX_VALUES_TL.description%TYPE;
1315: l_DESC_SK FND_FLEX_VALUES_TL.description%TYPE;
1316: l_DESC_SL FND_FLEX_VALUES_TL.description%TYPE;
1317: l_DESC_TH FND_FLEX_VALUES_TL.description%TYPE;
1318: l_DESC_TR FND_FLEX_VALUES_TL.description%TYPE;
1319: l_DESC_US FND_FLEX_VALUES_TL.description%TYPE;
1320: l_DESC_ZHS FND_FLEX_VALUES_TL.description%TYPE;

Line 1317: l_DESC_TH FND_FLEX_VALUES_TL.description%TYPE;

1313: l_DESC_S FND_FLEX_VALUES_TL.description%TYPE;
1314: l_DESC_SF FND_FLEX_VALUES_TL.description%TYPE;
1315: l_DESC_SK FND_FLEX_VALUES_TL.description%TYPE;
1316: l_DESC_SL FND_FLEX_VALUES_TL.description%TYPE;
1317: l_DESC_TH FND_FLEX_VALUES_TL.description%TYPE;
1318: l_DESC_TR FND_FLEX_VALUES_TL.description%TYPE;
1319: l_DESC_US FND_FLEX_VALUES_TL.description%TYPE;
1320: l_DESC_ZHS FND_FLEX_VALUES_TL.description%TYPE;
1321: l_DESC_ZHT FND_FLEX_VALUES_TL.description%TYPE;

Line 1318: l_DESC_TR FND_FLEX_VALUES_TL.description%TYPE;

1314: l_DESC_SF FND_FLEX_VALUES_TL.description%TYPE;
1315: l_DESC_SK FND_FLEX_VALUES_TL.description%TYPE;
1316: l_DESC_SL FND_FLEX_VALUES_TL.description%TYPE;
1317: l_DESC_TH FND_FLEX_VALUES_TL.description%TYPE;
1318: l_DESC_TR FND_FLEX_VALUES_TL.description%TYPE;
1319: l_DESC_US FND_FLEX_VALUES_TL.description%TYPE;
1320: l_DESC_ZHS FND_FLEX_VALUES_TL.description%TYPE;
1321: l_DESC_ZHT FND_FLEX_VALUES_TL.description%TYPE;
1322:

Line 1319: l_DESC_US FND_FLEX_VALUES_TL.description%TYPE;

1315: l_DESC_SK FND_FLEX_VALUES_TL.description%TYPE;
1316: l_DESC_SL FND_FLEX_VALUES_TL.description%TYPE;
1317: l_DESC_TH FND_FLEX_VALUES_TL.description%TYPE;
1318: l_DESC_TR FND_FLEX_VALUES_TL.description%TYPE;
1319: l_DESC_US FND_FLEX_VALUES_TL.description%TYPE;
1320: l_DESC_ZHS FND_FLEX_VALUES_TL.description%TYPE;
1321: l_DESC_ZHT FND_FLEX_VALUES_TL.description%TYPE;
1322:
1323: -- 1235002: For fetching translations

Line 1320: l_DESC_ZHS FND_FLEX_VALUES_TL.description%TYPE;

1316: l_DESC_SL FND_FLEX_VALUES_TL.description%TYPE;
1317: l_DESC_TH FND_FLEX_VALUES_TL.description%TYPE;
1318: l_DESC_TR FND_FLEX_VALUES_TL.description%TYPE;
1319: l_DESC_US FND_FLEX_VALUES_TL.description%TYPE;
1320: l_DESC_ZHS FND_FLEX_VALUES_TL.description%TYPE;
1321: l_DESC_ZHT FND_FLEX_VALUES_TL.description%TYPE;
1322:
1323: -- 1235002: For fetching translations
1324: TYPE arrayLangType IS VARRAY(50) OF VARCHAR2(3);

Line 1321: l_DESC_ZHT FND_FLEX_VALUES_TL.description%TYPE;

1317: l_DESC_TH FND_FLEX_VALUES_TL.description%TYPE;
1318: l_DESC_TR FND_FLEX_VALUES_TL.description%TYPE;
1319: l_DESC_US FND_FLEX_VALUES_TL.description%TYPE;
1320: l_DESC_ZHS FND_FLEX_VALUES_TL.description%TYPE;
1321: l_DESC_ZHT FND_FLEX_VALUES_TL.description%TYPE;
1322:
1323: -- 1235002: For fetching translations
1324: TYPE arrayLangType IS VARRAY(50) OF VARCHAR2(3);
1325: l_installed_languages ARRAYLANGTYPE;

Line 1327: l_translated_desc FND_FLEX_VALUES_TL.description%TYPE;

1323: -- 1235002: For fetching translations
1324: TYPE arrayLangType IS VARRAY(50) OF VARCHAR2(3);
1325: l_installed_languages ARRAYLANGTYPE;
1326: l_lang_count NUMBER;
1327: l_translated_desc FND_FLEX_VALUES_TL.description%TYPE;
1328:
1329: --===========================--
1330: -- Sub-Routines
1331: --===========================--

Line 1350: l_description FND_FLEX_VALUES_TL.description%TYPE;

1346:
1347: -- fetch description for a p_value_id in p_language
1348: FUNCTION get_description(p_language VARCHAR2, p_flex_value_id NUMBER)
1349: RETURN VARCHAR2 AS
1350: l_description FND_FLEX_VALUES_TL.description%TYPE;
1351: BEGIN
1352: SELECT flv.description
1353: INTO l_description
1354: FROM fnd_flex_values_tl flv

Line 1354: FROM fnd_flex_values_tl flv

1350: l_description FND_FLEX_VALUES_TL.description%TYPE;
1351: BEGIN
1352: SELECT flv.description
1353: INTO l_description
1354: FROM fnd_flex_values_tl flv
1355: WHERE flv.flex_value_id = p_flex_value_id
1356: AND flv.language = p_language
1357: AND flv.source_lang = p_language;
1358: