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_FORMULA_GEN_PKG dependencies on CN_CALC_FORMULAS

Line 57: g_org_id cn_calc_formulas.org_id%TYPE;

53: TYPE exp_other_tabused_tbl_type IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
54:
55: TYPE comm_tbl_clmn_nms_tbl_type IS TABLE OF comm_tbl_clmn_names_type INDEX BY BINARY_INTEGER;
56:
57: g_org_id cn_calc_formulas.org_id%TYPE;
58: g_formula_id cn_calc_formulas.calc_formula_id%TYPE;
59: g_trx_group_code cn_calc_formulas.trx_group_code%TYPE;
60: g_itd_flag cn_calc_formulas.itd_flag%TYPE;
61: g_cumulative_flag cn_calc_formulas.cumulative_flag%TYPE;

Line 58: g_formula_id cn_calc_formulas.calc_formula_id%TYPE;

54:
55: TYPE comm_tbl_clmn_nms_tbl_type IS TABLE OF comm_tbl_clmn_names_type INDEX BY BINARY_INTEGER;
56:
57: g_org_id cn_calc_formulas.org_id%TYPE;
58: g_formula_id cn_calc_formulas.calc_formula_id%TYPE;
59: g_trx_group_code cn_calc_formulas.trx_group_code%TYPE;
60: g_itd_flag cn_calc_formulas.itd_flag%TYPE;
61: g_cumulative_flag cn_calc_formulas.cumulative_flag%TYPE;
62: g_perf_measure_id cn_calc_formulas.perf_measure_id%TYPE;

Line 59: g_trx_group_code cn_calc_formulas.trx_group_code%TYPE;

55: TYPE comm_tbl_clmn_nms_tbl_type IS TABLE OF comm_tbl_clmn_names_type INDEX BY BINARY_INTEGER;
56:
57: g_org_id cn_calc_formulas.org_id%TYPE;
58: g_formula_id cn_calc_formulas.calc_formula_id%TYPE;
59: g_trx_group_code cn_calc_formulas.trx_group_code%TYPE;
60: g_itd_flag cn_calc_formulas.itd_flag%TYPE;
61: g_cumulative_flag cn_calc_formulas.cumulative_flag%TYPE;
62: g_perf_measure_id cn_calc_formulas.perf_measure_id%TYPE;
63: g_split_flag cn_calc_formulas.split_flag%TYPE;

Line 60: g_itd_flag cn_calc_formulas.itd_flag%TYPE;

56:
57: g_org_id cn_calc_formulas.org_id%TYPE;
58: g_formula_id cn_calc_formulas.calc_formula_id%TYPE;
59: g_trx_group_code cn_calc_formulas.trx_group_code%TYPE;
60: g_itd_flag cn_calc_formulas.itd_flag%TYPE;
61: g_cumulative_flag cn_calc_formulas.cumulative_flag%TYPE;
62: g_perf_measure_id cn_calc_formulas.perf_measure_id%TYPE;
63: g_split_flag cn_calc_formulas.split_flag%TYPE;
64: g_number_dim cn_calc_formulas.number_dim%TYPE;

Line 61: g_cumulative_flag cn_calc_formulas.cumulative_flag%TYPE;

57: g_org_id cn_calc_formulas.org_id%TYPE;
58: g_formula_id cn_calc_formulas.calc_formula_id%TYPE;
59: g_trx_group_code cn_calc_formulas.trx_group_code%TYPE;
60: g_itd_flag cn_calc_formulas.itd_flag%TYPE;
61: g_cumulative_flag cn_calc_formulas.cumulative_flag%TYPE;
62: g_perf_measure_id cn_calc_formulas.perf_measure_id%TYPE;
63: g_split_flag cn_calc_formulas.split_flag%TYPE;
64: g_number_dim cn_calc_formulas.number_dim%TYPE;
65: g_formula_type cn_calc_formulas.formula_type%TYPE;

Line 62: g_perf_measure_id cn_calc_formulas.perf_measure_id%TYPE;

58: g_formula_id cn_calc_formulas.calc_formula_id%TYPE;
59: g_trx_group_code cn_calc_formulas.trx_group_code%TYPE;
60: g_itd_flag cn_calc_formulas.itd_flag%TYPE;
61: g_cumulative_flag cn_calc_formulas.cumulative_flag%TYPE;
62: g_perf_measure_id cn_calc_formulas.perf_measure_id%TYPE;
63: g_split_flag cn_calc_formulas.split_flag%TYPE;
64: g_number_dim cn_calc_formulas.number_dim%TYPE;
65: g_formula_type cn_calc_formulas.formula_type%TYPE;
66: g_rollover_flag VARCHAR2(1) := 'N';

Line 63: g_split_flag cn_calc_formulas.split_flag%TYPE;

59: g_trx_group_code cn_calc_formulas.trx_group_code%TYPE;
60: g_itd_flag cn_calc_formulas.itd_flag%TYPE;
61: g_cumulative_flag cn_calc_formulas.cumulative_flag%TYPE;
62: g_perf_measure_id cn_calc_formulas.perf_measure_id%TYPE;
63: g_split_flag cn_calc_formulas.split_flag%TYPE;
64: g_number_dim cn_calc_formulas.number_dim%TYPE;
65: g_formula_type cn_calc_formulas.formula_type%TYPE;
66: g_rollover_flag VARCHAR2(1) := 'N';
67: g_cumulative_input_no NUMBER := 1;

Line 64: g_number_dim cn_calc_formulas.number_dim%TYPE;

60: g_itd_flag cn_calc_formulas.itd_flag%TYPE;
61: g_cumulative_flag cn_calc_formulas.cumulative_flag%TYPE;
62: g_perf_measure_id cn_calc_formulas.perf_measure_id%TYPE;
63: g_split_flag cn_calc_formulas.split_flag%TYPE;
64: g_number_dim cn_calc_formulas.number_dim%TYPE;
65: g_formula_type cn_calc_formulas.formula_type%TYPE;
66: g_rollover_flag VARCHAR2(1) := 'N';
67: g_cumulative_input_no NUMBER := 1;
68:

Line 65: g_formula_type cn_calc_formulas.formula_type%TYPE;

61: g_cumulative_flag cn_calc_formulas.cumulative_flag%TYPE;
62: g_perf_measure_id cn_calc_formulas.perf_measure_id%TYPE;
63: g_split_flag cn_calc_formulas.split_flag%TYPE;
64: g_number_dim cn_calc_formulas.number_dim%TYPE;
65: g_formula_type cn_calc_formulas.formula_type%TYPE;
66: g_rollover_flag VARCHAR2(1) := 'N';
67: g_cumulative_input_no NUMBER := 1;
68:
69: g_pe_reference_tbl str_tbl_type;

Line 162: FROM cn_calc_formulas_all

158: dbms_lob.substr(piped_sql_from) sql_from,
159: dbms_lob.substr(piped_sql_select) sql_select,
160: cse.CALC_SQL_EXP_ID CALC_SQL_EXP_ID
161: FROM cn_calc_sql_exps_all cse,(SELECT 'PRF' exp_type_name,perf_measure_id exp_id
162: FROM cn_calc_formulas_all
163: WHERE calc_formula_id = p_formula_id
164: AND org_id = g_org_id
165: UNION ALL
166: SELECT 'OUT' exp_type_name,output_exp_id exp_id

Line 167: FROM cn_calc_formulas_all

163: WHERE calc_formula_id = p_formula_id
164: AND org_id = g_org_id
165: UNION ALL
166: SELECT 'OUT' exp_type_name,output_exp_id exp_id
167: FROM cn_calc_formulas_all
168: WHERE calc_formula_id = p_formula_id
169: AND org_id = g_org_id
170: UNION ALL
171: SELECT 'INP' exp_type_name,calc_sql_exp_id exp_id

Line 671: PROCEDURE generate_init(p_formula_id cn_calc_formulas.calc_formula_id%TYPE) IS

667: cn_utils.appendcr(body_code, ' IS');
668: END proc_init;
669:
670: -- initialize global variables in this package
671: PROCEDURE generate_init(p_formula_id cn_calc_formulas.calc_formula_id%TYPE) IS
672: i pls_integer := 0; -- index into PL/SQL tables
673: b pls_integer; -- beginning position of an occurence of xxxxPE.
674: l pls_integer; -- length of sql_select
675: p1 pls_integer; -- temporary position pointer

Line 682: FROM cn_calc_formulas_all

678: CURSOR exprs IS
679: SELECT dbms_lob.substr(piped_sql_select) sql_select
680: FROM cn_calc_sql_exps_all
681: WHERE calc_sql_exp_id IN (SELECT perf_measure_id
682: FROM cn_calc_formulas_all
683: WHERE calc_formula_id = p_formula_id
684: AND org_id = g_org_id
685: UNION ALL
686: SELECT output_exp_id

Line 687: FROM cn_calc_formulas_all

683: WHERE calc_formula_id = p_formula_id
684: AND org_id = g_org_id
685: UNION ALL
686: SELECT output_exp_id
687: FROM cn_calc_formulas_all
688: WHERE calc_formula_id = p_formula_id
689: AND org_id = g_org_id
690: UNION ALL
691: SELECT calc_sql_exp_id

Line 699: FROM cn_calc_formulas_all

695: CURSOR exprs2 IS
696: SELECT dbms_lob.substr(piped_sql_select) sql_select
697: FROM cn_calc_sql_exps_all
698: WHERE calc_sql_exp_id IN (SELECT output_exp_id
699: FROM cn_calc_formulas_all
700: WHERE calc_formula_id = p_formula_id
701: AND org_id = g_org_id
702: UNION ALL
703: SELECT calc_sql_exp_id

Line 719: FROM cn_calc_formulas_all

715: SELECT calc_formula_id, trx_group_code, itd_flag, cumulative_flag, perf_measure_id, split_flag,
716: number_dim, formula_type
717: INTO g_formula_id, g_trx_group_code, g_itd_flag, g_cumulative_flag, g_perf_measure_id, g_split_flag,
718: g_number_dim, g_formula_type
719: FROM cn_calc_formulas_all
720: WHERE calc_formula_id = p_formula_id
721: AND org_id = g_org_id;
722:
723: g_pe_reference_tbl.delete;

Line 2017: FROM cn_calc_formulas_all

2013: sql_select output_sql_select,
2014: sql_from output_sql_from
2015: FROM cn_calc_sql_exps_all
2016: WHERE calc_sql_exp_id = (SELECT output_exp_id
2017: FROM cn_calc_formulas_all
2018: WHERE calc_formula_id = g_formula_id
2019: AND org_id = g_org_id);
2020:
2021: BEGIN

Line 3062: FROM cn_calc_formulas_all

3058: INTO l_output_sql_select_clob
3059: FROM cn_calc_sql_exps_all
3060: WHERE org_id = g_org_id
3061: AND calc_sql_exp_id = (SELECT output_exp_id
3062: FROM cn_calc_formulas_all
3063: WHERE calc_formula_id = g_formula_id
3064: AND org_id = g_org_id);
3065:
3066: convert_clob_to_string( l_output_sql_select_clob, l_output_sql_select );

Line 3081: FROM cn_calc_formulas_all

3077: INTO l_input_sql_select_clob, l_input_sql_from_clob
3078: FROM cn_calc_sql_exps_all
3079: WHERE org_id = g_org_id
3080: AND calc_sql_exp_id = (SELECT output_exp_id
3081: FROM cn_calc_formulas_all
3082: WHERE calc_formula_id = g_formula_id
3083: AND org_id = g_org_id);
3084:
3085: convert_clob_to_string( l_input_sql_select_clob, l_input_sql_select );

Line 3886: FROM cn_calc_formulas_all

3882: CURSOR l_output_select_from_csr IS
3883: SELECT sql_select output_sql_select, sql_from output_sql_from
3884: FROM cn_calc_sql_exps_all
3885: WHERE calc_sql_exp_id = (SELECT output_exp_id
3886: FROM cn_calc_formulas_all
3887: WHERE calc_formula_id = g_formula_id
3888: AND org_id = g_org_id);
3889:
3890: CURSOR l_perf_select_from_csr IS

Line 4315: FROM cn_calc_formulas_all

4311: l_operator VARCHAR2(1);
4312:
4313: CURSOR f_output IS
4314: SELECT f_output_exp_id
4315: FROM cn_calc_formulas_all
4316: WHERE calc_formula_id = g_formula_id
4317: AND org_id = g_org_id;
4318:
4319: CURSOR f_inputs IS

Line 4705: FROM cn_calc_formulas_all

4701:
4702:
4703: CURSOR output IS
4704: SELECT output_exp_id, modeling_flag
4705: FROM cn_calc_formulas_all
4706: WHERE calc_formula_id = g_formula_id
4707: AND org_id = g_org_id;
4708:
4709: CURSOR input IS

Line 5209: UPDATE cn_calc_formulas_all

5205: WHERE name = 'CN_FORMULA_'|| abs(p_formula_id) || '_' || abs(g_org_id) || '_PKG'
5206: AND TYPE IN ('PACKAGE', 'PACKAGE BODY');
5207:
5208: IF l_error_count = 0 THEN
5209: UPDATE cn_calc_formulas_all
5210: SET formula_status = 'COMPLETE'
5211: WHERE calc_formula_id = p_formula_id
5212: AND org_id = g_org_id;
5213:

Line 5220: UPDATE cn_calc_formulas_all

5216: 'cn.plsql.cn_formula_gen_pkg.generate_formula.progress',
5217: 'Compiled formula package successfullly in generate_formula');
5218: end if;
5219: ELSE
5220: UPDATE cn_calc_formulas_all
5221: SET formula_status = 'INCOMPLETE'
5222: WHERE calc_formula_id = p_formula_id
5223: AND org_id = g_org_id;
5224:

Line 5252: UPDATE cn_calc_formulas_all

5248: 'cn.plsql.cn_formula_gen_pkg.generate_formula.progress',
5249: 'Failed to generate the PL/SQL code in generate_formula');
5250: end if;
5251:
5252: UPDATE cn_calc_formulas_all
5253: SET formula_status = 'INCOMPLETE'
5254: WHERE calc_formula_id = p_formula_id
5255: AND org_id = g_org_id;
5256:

Line 5343: FROM cn_calc_formulas

5339: AND object_type = 'PACKAGE';
5340:
5341: CURSOR formulas IS
5342: SELECT calc_formula_id, org_id
5343: FROM cn_calc_formulas
5344: WHERE org_id = nvl(p_org_id, org_id);
5345:
5346: CURSOR compile_pkg_cur IS
5347: select object_name || ' ' ||