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 376: l_prompt := cn_api.get_lkup_meaning('EXP_NAME', 'CN_PROMPTS');

372:
373: -- API body
374: IF (p_name IS NULL) THEN
375: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
376: l_prompt := cn_api.get_lkup_meaning('EXP_NAME', 'CN_PROMPTS');
377: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
378: fnd_message.set_token('OBJ_NAME', l_prompt);
379: fnd_msg_pub.ADD;
380: END IF;

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

680:
681: -- API body
682: IF (p_name IS NULL) THEN
683: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
684: l_prompt := cn_api.get_lkup_meaning('EXP_NAME', 'CN_PROMPTS');
685: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
686: fnd_message.set_token('OBJ_NAME', l_prompt);
687: fnd_msg_pub.ADD;
688: END IF;

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

1313: BEGIN
1314: -- add nodes of calculation value tree in DFS order
1315: x_types(l_count) :=
1316: add_tree_node('OSC_ELEMENTS',
1317: cn_api.get_lkup_meaning('OSC_ELEMENTS', 'EXPRESSION_TYPE'),
1318: null, null);
1319: l_count := l_count + 1;
1320: for t in osc_elements loop
1321: x_types(l_count) :=

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

1330: end loop;
1331:
1332: x_types(l_count) :=
1333: add_tree_node('EXPRESSIONS',
1334: cn_api.get_lkup_meaning('EXPRESSIONS', 'EXPRESSION_TYPE'),
1335: null, null);
1336: l_count := l_count + 1;
1337: for e in calc_expressions loop
1338: x_types(l_count) :=

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

1341: end loop;
1342:
1343: x_types(l_count) :=
1344: add_tree_node('FORMULAS',
1345: cn_api.get_lkup_meaning('FORMULAS', 'EXPRESSION_TYPE'),null,
1346: null);
1347: l_count := l_count + 1;
1348: for f in calc_formulas loop
1349: x_types(l_count) :=

Line 1356: cn_api.get_lkup_meaning('EXTERNAL_ELEMENTS',

1352: end loop;
1353:
1354: x_types(l_count) :=
1355: add_tree_node('EXTERNAL_ELEMENTS',
1356: cn_api.get_lkup_meaning('EXTERNAL_ELEMENTS',
1357: 'EXPRESSION_TYPE'),
1358: null, null);
1359: l_count := l_count + 1;
1360: for x in ext_elements loop

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

1371: end loop;
1372: end loop;
1373:
1374: x_types(l_count) :=
1375: add_tree_node('SQL_FUNCTIONS', cn_api.get_lkup_meaning('SQL_FUNCTIONS',
1376: 'EXPRESSION_TYPE'),
1377: null, null);
1378: l_count := l_count + 1;
1379: x_types(l_count) :=

Line 1381: cn_api.get_lkup_meaning('NUMBER_FUNCTIONS',

1377: null, null);
1378: l_count := l_count + 1;
1379: x_types(l_count) :=
1380: add_tree_node('NUMBER_FUNCTIONS',
1381: cn_api.get_lkup_meaning('NUMBER_FUNCTIONS',
1382: 'EXPRESSION_TYPE'),
1383: 'SQL_FUNCTIONS', null);
1384: l_count := l_count + 1;
1385: for i in num_functions.first..num_functions.last loop

Line 1393: cn_api.get_lkup_meaning('GROUP_FUNCTIONS',

1389: l_count := l_count + 1;
1390: end loop;
1391: x_types(l_count) :=
1392: add_tree_node('GROUP_FUNCTIONS',
1393: cn_api.get_lkup_meaning('GROUP_FUNCTIONS',
1394: 'EXPRESSION_TYPE'),
1395: 'SQL_FUNCTIONS', null);
1396: l_count := l_count + 1;
1397: for i in grp_functions.first..grp_functions.last loop

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

1402: end loop;
1403:
1404: x_types(l_count) :=
1405: add_tree_node('OTHER_FUNCTIONS',
1406: cn_api.get_lkup_meaning('OTHERS', 'EXPRESSION_TYPE'),
1407: 'SQL_FUNCTIONS', null);
1408: l_count := l_count + 1;
1409: for i in oth_functions.first..oth_functions.last loop
1410: x_types(l_count) :=

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

1417: -- Previously Commented out - START
1418:
1419: x_types(l_count) :=
1420: add_tree_node('PLAN_ELEMENTS',
1421: cn_api.get_lkup_meaning('PLAN_ELTS', 'EXPRESSION_TYPE'),
1422: null, null);
1423: l_count := l_count + 1;
1424: for i in plan_elements loop
1425: x_types(l_count) :=

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

1437:
1438: -- Previously Commented out - END
1439:
1440: x_types(l_count) :=
1441: add_tree_node('OTHERS', cn_api.get_lkup_meaning('OTHERS',
1442: 'EXPRESSION_TYPE'),
1443: null, null);
1444: l_count := l_count + 1;
1445: x_types(l_count) :=

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

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

Line 1448: cn_api.get_lkup_meaning('RATE_TABLE_RESULT',

1444: l_count := l_count + 1;
1445: x_types(l_count) :=
1446: add_tree_node(cn_api.get_lkup_meaning('RATE_TABLE_RESULT',
1447: 'EXPRESSION_TYPE'),
1448: cn_api.get_lkup_meaning('RATE_TABLE_RESULT',
1449: 'EXPRESSION_TYPE'),
1450: 'OTHERS', 'RateResult');
1451: l_count := l_count + 1;
1452: x_types(l_count) :=

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

1449: 'EXPRESSION_TYPE'),
1450: 'OTHERS', 'RateResult');
1451: l_count := l_count + 1;
1452: x_types(l_count) :=
1453: add_tree_node(cn_api.get_lkup_meaning('FORECAST_AMOUNT',
1454: 'EXPRESSION_TYPE'),
1455: cn_api.get_lkup_meaning('FORECAST_AMOUNT',
1456: 'EXPRESSION_TYPE'),
1457: 'OTHERS', 'ForecastAmount');

Line 1455: cn_api.get_lkup_meaning('FORECAST_AMOUNT',

1451: l_count := l_count + 1;
1452: x_types(l_count) :=
1453: add_tree_node(cn_api.get_lkup_meaning('FORECAST_AMOUNT',
1454: 'EXPRESSION_TYPE'),
1455: cn_api.get_lkup_meaning('FORECAST_AMOUNT',
1456: 'EXPRESSION_TYPE'),
1457: 'OTHERS', 'ForecastAmount');
1458: l_count := l_count + 1;
1459: END get_type_tree; */

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

1917:
1918: -- Initialize API return status to success
1919: x_return_status := fnd_api.g_ret_sts_success;
1920: -- translate RateResult and ForecastAmount
1921: disp_pieces(1) := cn_api.get_lkup_meaning('RATE_TABLE_RESULT', 'EXPRESSION_TYPE');
1922: disp_pieces(2) := cn_api.get_lkup_meaning('FORECAST_AMOUNT', 'EXPRESSION_TYPE');
1923:
1924: -- Bug 2295522
1925: -- set p_sql_select to upper

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

1918: -- Initialize API return status to success
1919: x_return_status := fnd_api.g_ret_sts_success;
1920: -- translate RateResult and ForecastAmount
1921: disp_pieces(1) := cn_api.get_lkup_meaning('RATE_TABLE_RESULT', 'EXPRESSION_TYPE');
1922: disp_pieces(2) := cn_api.get_lkup_meaning('FORECAST_AMOUNT', 'EXPRESSION_TYPE');
1923:
1924: -- Bug 2295522
1925: -- set p_sql_select to upper
1926: SELECT UPPER(p_sql_select)