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_FORMULAS_PVT dependencies on CN_CALC_SQL_EXPS

Line 135: PROCEDURE check_planning_exp (p_calc_sql_exp_id IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE) IS

131: */
132:
133: END validate_name_flags;
134:
135: PROCEDURE check_planning_exp (p_calc_sql_exp_id IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE) IS
136: CURSOR get_sql_select is
137: select dbms_lob.substr(sql_select)
138: from cn_calc_sql_exps
139: where calc_sql_exp_id = p_calc_sql_exp_id;

Line 138: from cn_calc_sql_exps

134:
135: PROCEDURE check_planning_exp (p_calc_sql_exp_id IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE) IS
136: CURSOR get_sql_select is
137: select dbms_lob.substr(sql_select)
138: from cn_calc_sql_exps
139: where calc_sql_exp_id = p_calc_sql_exp_id;
140:
141: l_sql varchar2(2000);
142: l_pos number := 1;

Line 359: from cn_calc_sql_exps

355: );
356:
357: IF p_output_exp_id IS NOT NULL THEN
358: select name INTO l_output_exp_name
359: from cn_calc_sql_exps
360: where calc_sql_exp_id = p_output_exp_id;
361:
362: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_OPEXPR_CRE');
363: fnd_message.set_token('EXPR', l_output_exp_name);

Line 385: from cn_calc_sql_exps

381: END IF;
382:
383: IF p_f_output_exp_id IS NOT NULL THEN
384: select name INTO l_f_output_exp_name
385: from cn_calc_sql_exps
386: where calc_sql_exp_id = p_f_output_exp_id;
387:
388: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_OPFORE_CRE');
389: fnd_message.set_token('EXPR', l_f_output_exp_name);

Line 428: from cn_calc_sql_exps

424: END IF;
425:
426: IF p_perf_measure_id IS NOT NULL THEN
427: select name INTO l_perf_measure_name
428: from cn_calc_sql_exps
429: where calc_sql_exp_id = p_perf_measure_id;
430:
431: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_PERF_CREATE');
432: fnd_message.set_token('PERF_MEASURE', l_perf_measure_name);

Line 614: l_plan_elt_tbl CN_CALC_SQL_EXPS_PVT.NUM_TBL_TYPE;

610: l_update_count NUMBER := 0;
611: l_srp_prd_quota_ext_id cn_srp_period_quotas_ext.srp_period_quota_ext_id%TYPE;
612: l_num_dim CN_CALC_FORMULAS.NUMBER_DIM%TYPE;
613: l_count_formula_input NUMBER := 0;
614: l_plan_elt_tbl CN_CALC_SQL_EXPS_PVT.NUM_TBL_TYPE;
615:
616: /* Start - R12 Notes History */
617: l_formula_name VARCHAR2(30);
618: l_old_formula_name VARCHAR2(30);

Line 640: cn_calc_sql_exps cs1, cn_calc_sql_exps cs2, cn_calc_sql_exps cs3

636: cf.SPLIT_FLAG, cf.CUMULATIVE_FLAG, cf.ITD_FLAG, cf.MODELING_FLAG, cl.MEANING,
637: cf.output_exp_id, cf.f_output_exp_id, cf.perf_measure_id, cs1.name oname,
638: cs2.name fname, cs3.name pname
639: FROM cn_calc_formulas cf, cn_lookups cl,
640: cn_calc_sql_exps cs1, cn_calc_sql_exps cs2, cn_calc_sql_exps cs3
641: WHERE cl.lookup_code = cf.FORMULA_TYPE
642: AND cl.lookup_type = 'FORMULA_TYPE'
643: AND cf.OUTPUT_EXP_ID = cs1.CALC_SQL_EXP_ID (+)
644: AND cf.F_OUTPUT_EXP_ID = cs2.CALC_SQL_EXP_ID (+)

Line 1066: from cn_calc_sql_exps

1062: (l_old_rec.output_exp_id <> p_output_exp_id)) OR
1063: (p_output_exp_id IS NOT NULL AND l_old_rec.output_exp_id IS NULL))THEN
1064:
1065: select name INTO l_output_exp_name
1066: from cn_calc_sql_exps
1067: where calc_sql_exp_id = p_output_exp_id;
1068:
1069: IF l_old_rec.output_exp_id IS NOT NULL THEN
1070: l_output_exp_name_old := l_old_rec.oname;

Line 1125: from cn_calc_sql_exps

1121: (l_old_rec.f_output_exp_id <> p_f_output_exp_id)) OR
1122: (p_f_output_exp_id IS NOT NULL AND l_old_rec.f_output_exp_id IS NULL))THEN
1123:
1124: select name INTO l_f_output_exp_name
1125: from cn_calc_sql_exps
1126: where calc_sql_exp_id = p_f_output_exp_id;
1127:
1128: IF l_old_rec.f_output_exp_id IS NOT NULL THEN
1129: l_f_output_exp_name_old := l_old_rec.fname;

Line 1203: from cn_calc_sql_exps

1199: (l_old_rec.perf_measure_id <> p_perf_measure_id)) OR
1200: (p_perf_measure_id IS NOT NULL AND l_old_rec.perf_measure_id IS NULL))THEN
1201:
1202: select name INTO l_perf_measure_name
1203: from cn_calc_sql_exps
1204: where calc_sql_exp_id = p_perf_measure_id;
1205:
1206: IF l_old_rec.perf_measure_id IS NOT NULL THEN
1207: l_perf_measure_name_old := l_old_rec.pname;

Line 1366: cn_calc_sql_exps_pvt.get_dependent_plan_elts

1362: check_modeling(p_calc_formula_id, p_cumulative_flag, p_output_exp_id, p_f_output_exp_id);
1363: end if;
1364:
1365: -- make sure this formula wouldn't be involved in a cycle
1366: cn_calc_sql_exps_pvt.get_dependent_plan_elts
1367: (p_api_version => 1.0,
1368: p_node_type => 'F',
1369: p_node_id => p_calc_formula_id,
1370: x_plan_elt_id_tbl => l_plan_elt_tbl,

Line 1646: l_exp_type_code CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE;

1642: l_dummy pls_integer;
1643: l_ii_flag VARCHAR2(30) := 'N';
1644: l_status CN_CALC_FORMULAS.FORMULA_STATUS%TYPE;
1645: l_f_status CN_CALC_FORMULAS.FORMULA_STATUS%TYPE;
1646: l_exp_type_code CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE;
1647: l_f_exp_type_code CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE;
1648: l_formula_type CN_CALC_FORMULAS.FORMULA_TYPE%TYPE;
1649: l_trx_group_code CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE;
1650: l_number_dim CN_CALC_FORMULAS.NUMBER_DIM%TYPE;

Line 1647: l_f_exp_type_code CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE;

1643: l_ii_flag VARCHAR2(30) := 'N';
1644: l_status CN_CALC_FORMULAS.FORMULA_STATUS%TYPE;
1645: l_f_status CN_CALC_FORMULAS.FORMULA_STATUS%TYPE;
1646: l_exp_type_code CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE;
1647: l_f_exp_type_code CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE;
1648: l_formula_type CN_CALC_FORMULAS.FORMULA_TYPE%TYPE;
1649: l_trx_group_code CN_CALC_FORMULAS.TRX_GROUP_CODE%TYPE;
1650: l_number_dim CN_CALC_FORMULAS.NUMBER_DIM%TYPE;
1651: l_itd_flag CN_CALC_FORMULAS.ITD_FLAG%TYPE;

Line 1683: FROM cn_calc_sql_exps

1679:
1680:
1681: CURSOR perf_measure IS
1682: SELECT status, exp_type_code
1683: FROM cn_calc_sql_exps
1684: WHERE calc_sql_exp_id = l_perf_measure_id;
1685:
1686: CURSOR inputs IS
1687: SELECT a.status, a.exp_type_code, b.status f_status,

Line 1689: FROM cn_calc_sql_exps a,

1685:
1686: CURSOR inputs IS
1687: SELECT a.status, a.exp_type_code, b.status f_status,
1688: b.exp_type_code f_exp_type_code
1689: FROM cn_calc_sql_exps a,
1690: cn_calc_sql_exps b,
1691: cn_formula_inputs c
1692: WHERE a.calc_sql_exp_id = c.calc_sql_exp_id
1693: AND b.calc_sql_exp_id(+) = c.f_calc_sql_exp_id

Line 1690: cn_calc_sql_exps b,

1686: CURSOR inputs IS
1687: SELECT a.status, a.exp_type_code, b.status f_status,
1688: b.exp_type_code f_exp_type_code
1689: FROM cn_calc_sql_exps a,
1690: cn_calc_sql_exps b,
1691: cn_formula_inputs c
1692: WHERE a.calc_sql_exp_id = c.calc_sql_exp_id
1693: AND b.calc_sql_exp_id(+) = c.f_calc_sql_exp_id
1694: AND c.calc_formula_id = p_calc_formula_id;

Line 1698: FROM cn_calc_sql_exps

1694: AND c.calc_formula_id = p_calc_formula_id;
1695:
1696: CURSOR output IS
1697: SELECT status, exp_type_code
1698: FROM cn_calc_sql_exps
1699: WHERE calc_sql_exp_id = l_output_exp_id;
1700:
1701: CURSOR f_output IS
1702: SELECT status, exp_type_code

Line 1703: FROM cn_calc_sql_exps

1699: WHERE calc_sql_exp_id = l_output_exp_id;
1700:
1701: CURSOR f_output IS
1702: SELECT status, exp_type_code
1703: FROM cn_calc_sql_exps
1704: WHERE calc_sql_exp_id = l_f_output_exp_id;
1705:
1706: CURSOR check_dimensions IS
1707: SELECT 1