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.CN_CALC_SQL_EXPS_PVT dependencies on CN_API

Line 370: l_prompt := cn_api.get_lkup_meaning('EXP_NAME', 'CN_PROMPTS');

366:
367: -- API body
368: IF (p_name IS NULL) THEN
369: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
370: l_prompt := cn_api.get_lkup_meaning('EXP_NAME', 'CN_PROMPTS');
371: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
372: fnd_message.set_token('OBJ_NAME', l_prompt);
373: fnd_msg_pub.ADD;
374: END IF;

Line 677: l_prompt := cn_api.get_lkup_meaning('EXP_NAME', 'CN_PROMPTS');

673:
674: -- API body
675: IF (p_name IS NULL) THEN
676: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
677: l_prompt := cn_api.get_lkup_meaning('EXP_NAME', 'CN_PROMPTS');
678: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
679: fnd_message.set_token('OBJ_NAME', l_prompt);
680: fnd_msg_pub.ADD;
681: END IF;

Line 1309: cn_api.get_lkup_meaning('OSC_ELEMENTS', 'EXPRESSION_TYPE'),

1305: BEGIN
1306: -- add nodes of calculation value tree in DFS order
1307: x_types(l_count) :=
1308: add_tree_node('OSC_ELEMENTS',
1309: cn_api.get_lkup_meaning('OSC_ELEMENTS', 'EXPRESSION_TYPE'),
1310: null, null);
1311: l_count := l_count + 1;
1312: for t in osc_elements loop
1313: x_types(l_count) :=

Line 1326: cn_api.get_lkup_meaning('EXPRESSIONS', 'EXPRESSION_TYPE'),

1322: end loop;
1323:
1324: x_types(l_count) :=
1325: add_tree_node('EXPRESSIONS',
1326: cn_api.get_lkup_meaning('EXPRESSIONS', 'EXPRESSION_TYPE'),
1327: null, null);
1328: l_count := l_count + 1;
1329: for e in calc_expressions loop
1330: x_types(l_count) :=

Line 1337: cn_api.get_lkup_meaning('FORMULAS', 'EXPRESSION_TYPE'),null,

1333: end loop;
1334:
1335: x_types(l_count) :=
1336: add_tree_node('FORMULAS',
1337: cn_api.get_lkup_meaning('FORMULAS', 'EXPRESSION_TYPE'),null,
1338: null);
1339: l_count := l_count + 1;
1340: for f in calc_formulas loop
1341: x_types(l_count) :=

Line 1348: cn_api.get_lkup_meaning('EXTERNAL_ELEMENTS',

1344: end loop;
1345:
1346: x_types(l_count) :=
1347: add_tree_node('EXTERNAL_ELEMENTS',
1348: cn_api.get_lkup_meaning('EXTERNAL_ELEMENTS',
1349: 'EXPRESSION_TYPE'),
1350: null, null);
1351: l_count := l_count + 1;
1352: for x in ext_elements loop

Line 1367: add_tree_node('SQL_FUNCTIONS', cn_api.get_lkup_meaning('SQL_FUNCTIONS',

1363: end loop;
1364: end loop;
1365:
1366: x_types(l_count) :=
1367: add_tree_node('SQL_FUNCTIONS', cn_api.get_lkup_meaning('SQL_FUNCTIONS',
1368: 'EXPRESSION_TYPE'),
1369: null, null);
1370: l_count := l_count + 1;
1371: x_types(l_count) :=

Line 1373: cn_api.get_lkup_meaning('NUMBER_FUNCTIONS',

1369: null, null);
1370: l_count := l_count + 1;
1371: x_types(l_count) :=
1372: add_tree_node('NUMBER_FUNCTIONS',
1373: cn_api.get_lkup_meaning('NUMBER_FUNCTIONS',
1374: 'EXPRESSION_TYPE'),
1375: 'SQL_FUNCTIONS', null);
1376: l_count := l_count + 1;
1377: for i in num_functions.first..num_functions.last loop

Line 1385: cn_api.get_lkup_meaning('GROUP_FUNCTIONS',

1381: l_count := l_count + 1;
1382: end loop;
1383: x_types(l_count) :=
1384: add_tree_node('GROUP_FUNCTIONS',
1385: cn_api.get_lkup_meaning('GROUP_FUNCTIONS',
1386: 'EXPRESSION_TYPE'),
1387: 'SQL_FUNCTIONS', null);
1388: l_count := l_count + 1;
1389: for i in grp_functions.first..grp_functions.last loop

Line 1398: cn_api.get_lkup_meaning('OTHERS', 'EXPRESSION_TYPE'),

1394: end loop;
1395:
1396: x_types(l_count) :=
1397: add_tree_node('OTHER_FUNCTIONS',
1398: cn_api.get_lkup_meaning('OTHERS', 'EXPRESSION_TYPE'),
1399: 'SQL_FUNCTIONS', null);
1400: l_count := l_count + 1;
1401: for i in oth_functions.first..oth_functions.last loop
1402: x_types(l_count) :=

Line 1413: cn_api.get_lkup_meaning('PLAN_ELTS', 'EXPRESSION_TYPE'),

1409: -- Previously Commented out - START
1410:
1411: x_types(l_count) :=
1412: add_tree_node('PLAN_ELEMENTS',
1413: cn_api.get_lkup_meaning('PLAN_ELTS', 'EXPRESSION_TYPE'),
1414: null, null);
1415: l_count := l_count + 1;
1416: for i in plan_elements loop
1417: x_types(l_count) :=

Line 1433: add_tree_node('OTHERS', cn_api.get_lkup_meaning('OTHERS',

1429:
1430: -- Previously Commented out - END
1431:
1432: x_types(l_count) :=
1433: add_tree_node('OTHERS', cn_api.get_lkup_meaning('OTHERS',
1434: 'EXPRESSION_TYPE'),
1435: null, null);
1436: l_count := l_count + 1;
1437: x_types(l_count) :=

Line 1438: add_tree_node(cn_api.get_lkup_meaning('RATE_TABLE_RESULT',

1434: 'EXPRESSION_TYPE'),
1435: null, null);
1436: l_count := l_count + 1;
1437: x_types(l_count) :=
1438: add_tree_node(cn_api.get_lkup_meaning('RATE_TABLE_RESULT',
1439: 'EXPRESSION_TYPE'),
1440: cn_api.get_lkup_meaning('RATE_TABLE_RESULT',
1441: 'EXPRESSION_TYPE'),
1442: 'OTHERS', 'RateResult');

Line 1440: cn_api.get_lkup_meaning('RATE_TABLE_RESULT',

1436: l_count := l_count + 1;
1437: x_types(l_count) :=
1438: add_tree_node(cn_api.get_lkup_meaning('RATE_TABLE_RESULT',
1439: 'EXPRESSION_TYPE'),
1440: cn_api.get_lkup_meaning('RATE_TABLE_RESULT',
1441: 'EXPRESSION_TYPE'),
1442: 'OTHERS', 'RateResult');
1443: l_count := l_count + 1;
1444: x_types(l_count) :=

Line 1445: add_tree_node(cn_api.get_lkup_meaning('FORECAST_AMOUNT',

1441: 'EXPRESSION_TYPE'),
1442: 'OTHERS', 'RateResult');
1443: l_count := l_count + 1;
1444: x_types(l_count) :=
1445: add_tree_node(cn_api.get_lkup_meaning('FORECAST_AMOUNT',
1446: 'EXPRESSION_TYPE'),
1447: cn_api.get_lkup_meaning('FORECAST_AMOUNT',
1448: 'EXPRESSION_TYPE'),
1449: 'OTHERS', 'ForecastAmount');

Line 1447: cn_api.get_lkup_meaning('FORECAST_AMOUNT',

1443: l_count := l_count + 1;
1444: x_types(l_count) :=
1445: add_tree_node(cn_api.get_lkup_meaning('FORECAST_AMOUNT',
1446: 'EXPRESSION_TYPE'),
1447: cn_api.get_lkup_meaning('FORECAST_AMOUNT',
1448: 'EXPRESSION_TYPE'),
1449: 'OTHERS', 'ForecastAmount');
1450: l_count := l_count + 1;
1451: END get_type_tree; */

Line 1902: disp_pieces(1) := cn_api.get_lkup_meaning('RATE_TABLE_RESULT', 'EXPRESSION_TYPE');

1898:
1899: -- Initialize API return status to success
1900: x_return_status := fnd_api.g_ret_sts_success;
1901: -- translate RateResult and ForecastAmount
1902: disp_pieces(1) := cn_api.get_lkup_meaning('RATE_TABLE_RESULT', 'EXPRESSION_TYPE');
1903: disp_pieces(2) := cn_api.get_lkup_meaning('FORECAST_AMOUNT', 'EXPRESSION_TYPE');
1904:
1905: -- Bug 2295522
1906: -- set p_sql_select to upper

Line 1903: disp_pieces(2) := cn_api.get_lkup_meaning('FORECAST_AMOUNT', 'EXPRESSION_TYPE');

1899: -- Initialize API return status to success
1900: x_return_status := fnd_api.g_ret_sts_success;
1901: -- translate RateResult and ForecastAmount
1902: disp_pieces(1) := cn_api.get_lkup_meaning('RATE_TABLE_RESULT', 'EXPRESSION_TYPE');
1903: disp_pieces(2) := cn_api.get_lkup_meaning('FORECAST_AMOUNT', 'EXPRESSION_TYPE');
1904:
1905: -- Bug 2295522
1906: -- set p_sql_select to upper
1907: SELECT UPPER(p_sql_select)