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

Line 226: CURSOR c_fnd_flex_values(p_value VARCHAR2) IS

222: x_success OUT NOCOPY BOOLEAN
223: ) AS
224:
225: -- Cursor to fetch existing value properties
226: CURSOR c_fnd_flex_values(p_value VARCHAR2) IS
227: SELECT ffv.ROWID, ffv.*
228: FROM fnd_flex_values ffv
229: WHERE ffv.flex_value_set_id = g_value_set_id
230: AND ffv.flex_value = p_value;

Line 228: FROM fnd_flex_values ffv

224:
225: -- Cursor to fetch existing value properties
226: CURSOR c_fnd_flex_values(p_value VARCHAR2) IS
227: SELECT ffv.ROWID, ffv.*
228: FROM fnd_flex_values ffv
229: WHERE ffv.flex_value_set_id = g_value_set_id
230: AND ffv.flex_value = p_value;
231:
232: -- Local variables

Line 233: rec_existing_value c_fnd_flex_values%ROWTYPE;

229: WHERE ffv.flex_value_set_id = g_value_set_id
230: AND ffv.flex_value = p_value;
231:
232: -- Local variables
233: rec_existing_value c_fnd_flex_values%ROWTYPE;
234: l_rollup_id FND_FLEX_HIERARCHIES.hierarchy_id%TYPE;
235: l_old_account_type FND_FLEX_VALUES.compiled_value_attributes%TYPE;
236: l_val_exists BOOLEAN;
237:

Line 235: l_old_account_type FND_FLEX_VALUES.compiled_value_attributes%TYPE;

231:
232: -- Local variables
233: rec_existing_value c_fnd_flex_values%ROWTYPE;
234: l_rollup_id FND_FLEX_HIERARCHIES.hierarchy_id%TYPE;
235: l_old_account_type FND_FLEX_VALUES.compiled_value_attributes%TYPE;
236: l_val_exists BOOLEAN;
237:
238: BEGIN
239: x_success := false;

Line 242: OPEN c_fnd_flex_values(p_seg_value);

238: BEGIN
239: x_success := false;
240:
241: -- Check if value already exists and fetch properties
242: OPEN c_fnd_flex_values(p_seg_value);
243: FETCH c_fnd_flex_values INTO rec_existing_value;
244: IF c_fnd_flex_values%NOTFOUND
245: THEN
246: l_val_exists := FALSE;

Line 243: FETCH c_fnd_flex_values INTO rec_existing_value;

239: x_success := false;
240:
241: -- Check if value already exists and fetch properties
242: OPEN c_fnd_flex_values(p_seg_value);
243: FETCH c_fnd_flex_values INTO rec_existing_value;
244: IF c_fnd_flex_values%NOTFOUND
245: THEN
246: l_val_exists := FALSE;
247: ELSE

Line 244: IF c_fnd_flex_values%NOTFOUND

240:
241: -- Check if value already exists and fetch properties
242: OPEN c_fnd_flex_values(p_seg_value);
243: FETCH c_fnd_flex_values INTO rec_existing_value;
244: IF c_fnd_flex_values%NOTFOUND
245: THEN
246: l_val_exists := FALSE;
247: ELSE
248: l_val_exists := TRUE;

Line 548: l_storage_value FND_FLEX_VALUES.flex_value%TYPE;

544: l_uppercase_only FND_FLEX_VALUE_SETS.uppercase_only_flag%TYPE;
545: l_zero_fill FND_FLEX_VALUE_SETS.numeric_mode_enabled_flag%TYPE;
546: l_min_value FND_FLEX_VALUE_SETS.minimum_value%TYPE;
547: l_max_value FND_FLEX_VALUE_SETS.maximum_value%TYPE;
548: l_storage_value FND_FLEX_VALUES.flex_value%TYPE;
549: l_display_value FND_FLEX_VALUES.flex_value%TYPE;
550:
551: -- counters
552: l_cntr NUMBER;

Line 549: l_display_value FND_FLEX_VALUES.flex_value%TYPE;

545: l_zero_fill FND_FLEX_VALUE_SETS.numeric_mode_enabled_flag%TYPE;
546: l_min_value FND_FLEX_VALUE_SETS.minimum_value%TYPE;
547: l_max_value FND_FLEX_VALUE_SETS.maximum_value%TYPE;
548: l_storage_value FND_FLEX_VALUES.flex_value%TYPE;
549: l_display_value FND_FLEX_VALUES.flex_value%TYPE;
550:
551: -- counters
552: l_cntr NUMBER;
553: l_err_count NUMBER;

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 841: l_n_flex_value_id FND_FLEX_VALUES.flex_value_id%TYPE;

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:
845: BEGIN

Line 883: fnd_flex_values vl

879: -- get flex_value_id
880: SELECT vl.flex_value_id
881: INTO l_n_flex_value_id
882: FROM
883: fnd_flex_values vl
884: WHERE
885: vl.flex_value_set_id = g_value_set_id AND
886: vl.flex_value = g_flex_values_tbl(i).flex_value;
887:

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 1102: * FND_FLEX_VALUES.compiled_value_attributes

1098: * PUBLIC FUNCTION
1099: * get_value_attribute
1100: * PURPOSE
1101: * Fetches the property value at a given postion in the field
1102: * FND_FLEX_VALUES.compiled_value_attributes
1103: * CHANGE HISTORY
1104: * Who When What
1105: * vnetan 09/10/2010 Created
1106: * +=======================================================================+*/

Line 1108: p_compiled_attr FND_FLEX_VALUES.compiled_value_attributes%TYPE,

1104: * Who When What
1105: * vnetan 09/10/2010 Created
1106: * +=======================================================================+*/
1107: FUNCTION get_value_attribute (
1108: p_compiled_attr FND_FLEX_VALUES.compiled_value_attributes%TYPE,
1109: p_attribute_pos NUMBER)
1110: RETURN VARCHAR2 AS
1111: l_current FND_FLEX_VALUES.compiled_value_attributes%TYPE;
1112: l_current_pos NUMBER(2);

Line 1111: l_current FND_FLEX_VALUES.compiled_value_attributes%TYPE;

1107: FUNCTION get_value_attribute (
1108: p_compiled_attr FND_FLEX_VALUES.compiled_value_attributes%TYPE,
1109: p_attribute_pos NUMBER)
1110: RETURN VARCHAR2 AS
1111: l_current FND_FLEX_VALUES.compiled_value_attributes%TYPE;
1112: l_current_pos NUMBER(2);
1113: l_new FND_FLEX_VALUES.compiled_value_attributes%TYPE;
1114: BEGIN
1115: l_current_pos := 1;

Line 1113: l_new FND_FLEX_VALUES.compiled_value_attributes%TYPE;

1109: p_attribute_pos NUMBER)
1110: RETURN VARCHAR2 AS
1111: l_current FND_FLEX_VALUES.compiled_value_attributes%TYPE;
1112: l_current_pos NUMBER(2);
1113: l_new FND_FLEX_VALUES.compiled_value_attributes%TYPE;
1114: BEGIN
1115: l_current_pos := 1;
1116: l_current := p_compiled_attr||FND_GLOBAL.newline;
1117:

Line 1160: FROM FND_FLEX_VALUES_VL ffv

1156: IS
1157: SELECT
1158: FFV.flex_value TOP_NODE,
1159: FFV.description
1160: FROM FND_FLEX_VALUES_VL ffv
1161: WHERE FFV.flex_value_set_id = p_value_set_id
1162: AND FFV.summary_flag = 'Y'
1163: AND NOT EXISTS
1164: (SELECT 'X'

Line 1178: FROM FND_FLEX_VALUES ffv1

1174: AND FNH1.parent_flex_value = FFV.flex_value
1175: -- confirm that the ranges have at least one child node defined
1176: AND EXISTS
1177: (SELECT 'X'
1178: FROM FND_FLEX_VALUES ffv1
1179: WHERE FNH1.flex_value_set_id = FFV1.flex_value_set_id
1180: AND (FFV1.summary_flag = 'N' AND FNH1.range_attribute = 'C' OR
1181: FFV1.summary_flag = 'Y' AND FNH1.range_attribute = 'P')
1182: AND FFV1.flex_value BETWEEN FNH1.child_flex_value_low AND FNH1.child_flex_value_high)

Line 1193: Fnd_Flex_Values cv

1189: SELECT
1190: nh.parent_flex_value parent,
1191: cv.flex_value child
1192: FROM Fnd_Flex_Value_Norm_Hierarchy nh,
1193: Fnd_Flex_Values cv
1194: WHERE nh.flex_value_set_id = p_value_set_id
1195: AND nh.flex_value_set_Id = cv.flex_value_set_id
1196: AND cv.flex_value <> nh.parent_flex_value
1197: AND(( nh.range_attribute = 'P' AND cv.summary_flag = 'Y')

Line 1216: FROM fnd_flex_values_vl ffv,

1212: ffv.end_date_active,
1213: ffv.compiled_value_attributes,
1214: ffh.hierarchy_code rollup_group,
1215: ffv.hierarchy_level
1216: FROM fnd_flex_values_vl ffv,
1217: fnd_flex_hierarchies ffh
1218: WHERE ffv.flex_value_set_id = p_value_set_id
1219: AND ffv.flex_value_set_id = ffh.flex_value_set_id(+)
1220: AND ffv.structured_hierarchy_level = ffh.hierarchy_id(+);

Line 1270: l_flex_value_id FND_FLEX_VALUES.flex_value_id%TYPE;

1266: l_value_set_details fnd_flex_value_sets%ROWTYPE;
1267: l_natural_account VARCHAR2(10);
1268:
1269: -- node level properties
1270: l_flex_value_id FND_FLEX_VALUES.flex_value_id%TYPE;
1271: l_node FND_FLEX_VALUES.flex_value%TYPE;
1272: l_leaf VARCHAR2(10);
1273: l_enabled VARCHAR2(10);
1274: l_from VARCHAR2(240);

Line 1271: l_node FND_FLEX_VALUES.flex_value%TYPE;

1267: l_natural_account VARCHAR2(10);
1268:
1269: -- node level properties
1270: l_flex_value_id FND_FLEX_VALUES.flex_value_id%TYPE;
1271: l_node FND_FLEX_VALUES.flex_value%TYPE;
1272: l_leaf VARCHAR2(10);
1273: l_enabled VARCHAR2(10);
1274: l_from VARCHAR2(240);
1275: l_to VARCHAR2(240);

Line 1277: l_level FND_FLEX_VALUES.hierarchy_level%TYPE;

1273: l_enabled VARCHAR2(10);
1274: l_from VARCHAR2(240);
1275: l_to VARCHAR2(240);
1276: l_rollup FND_FLEX_HIERARCHIES.hierarchy_code%TYPE;
1277: l_level FND_FLEX_VALUES.hierarchy_level%TYPE;
1278: l_budgeting VARCHAR2(240);
1279: l_posting VARCHAR2(240);
1280: l_accttype VARCHAR2(240);
1281: l_thirdparty VARCHAR2(240);

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: