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 2004: FROM cn_calc_formulas_all

2000: sql_select output_sql_select,
2001: sql_from output_sql_from
2002: FROM cn_calc_sql_exps_all
2003: WHERE calc_sql_exp_id = (SELECT output_exp_id
2004: FROM cn_calc_formulas_all
2005: WHERE calc_formula_id = g_formula_id
2006: AND org_id = g_org_id);
2007:
2008: BEGIN

Line 3049: FROM cn_calc_formulas_all

3045: INTO l_output_sql_select_clob
3046: FROM cn_calc_sql_exps_all
3047: WHERE org_id = g_org_id
3048: AND calc_sql_exp_id = (SELECT output_exp_id
3049: FROM cn_calc_formulas_all
3050: WHERE calc_formula_id = g_formula_id
3051: AND org_id = g_org_id);
3052:
3053: convert_clob_to_string( l_output_sql_select_clob, l_output_sql_select );

Line 3068: FROM cn_calc_formulas_all

3064: INTO l_input_sql_select_clob, l_input_sql_from_clob
3065: FROM cn_calc_sql_exps_all
3066: WHERE org_id = g_org_id
3067: AND calc_sql_exp_id = (SELECT output_exp_id
3068: FROM cn_calc_formulas_all
3069: WHERE calc_formula_id = g_formula_id
3070: AND org_id = g_org_id);
3071:
3072: convert_clob_to_string( l_input_sql_select_clob, l_input_sql_select );

Line 3873: FROM cn_calc_formulas_all

3869: CURSOR l_output_select_from_csr IS
3870: SELECT sql_select output_sql_select, sql_from output_sql_from
3871: FROM cn_calc_sql_exps_all
3872: WHERE calc_sql_exp_id = (SELECT output_exp_id
3873: FROM cn_calc_formulas_all
3874: WHERE calc_formula_id = g_formula_id
3875: AND org_id = g_org_id);
3876:
3877: CURSOR l_perf_select_from_csr IS

Line 4302: FROM cn_calc_formulas_all

4298: l_operator VARCHAR2(1);
4299:
4300: CURSOR f_output IS
4301: SELECT f_output_exp_id
4302: FROM cn_calc_formulas_all
4303: WHERE calc_formula_id = g_formula_id
4304: AND org_id = g_org_id;
4305:
4306: CURSOR f_inputs IS

Line 4692: FROM cn_calc_formulas_all

4688:
4689:
4690: CURSOR output IS
4691: SELECT output_exp_id, modeling_flag
4692: FROM cn_calc_formulas_all
4693: WHERE calc_formula_id = g_formula_id
4694: AND org_id = g_org_id;
4695:
4696: CURSOR input IS

Line 5126: UPDATE cn_calc_formulas_all

5122: WHERE name = 'CN_FORMULA_'|| abs(p_formula_id) || '_' || abs(g_org_id) || '_PKG'
5123: AND TYPE IN ('PACKAGE', 'PACKAGE BODY');
5124:
5125: IF l_error_count = 0 THEN
5126: UPDATE cn_calc_formulas_all
5127: SET formula_status = 'COMPLETE'
5128: WHERE calc_formula_id = p_formula_id
5129: AND org_id = g_org_id;
5130:

Line 5137: UPDATE cn_calc_formulas_all

5133: 'cn.plsql.cn_formula_gen_pkg.generate_formula.progress',
5134: 'Compiled formula package successfullly in generate_formula');
5135: end if;
5136: ELSE
5137: UPDATE cn_calc_formulas_all
5138: SET formula_status = 'INCOMPLETE'
5139: WHERE calc_formula_id = p_formula_id
5140: AND org_id = g_org_id;
5141:

Line 5169: UPDATE cn_calc_formulas_all

5165: 'cn.plsql.cn_formula_gen_pkg.generate_formula.progress',
5166: 'Failed to generate the PL/SQL code in generate_formula');
5167: end if;
5168:
5169: UPDATE cn_calc_formulas_all
5170: SET formula_status = 'INCOMPLETE'
5171: WHERE calc_formula_id = p_formula_id
5172: AND org_id = g_org_id;
5173:

Line 5250: FROM cn_calc_formulas

5246: l_msg_data VARCHAR2(2000);
5247:
5248: CURSOR formulas IS
5249: SELECT calc_formula_id, org_id
5250: FROM cn_calc_formulas
5251: WHERE org_id = nvl(p_org_id, org_id);
5252:
5253: CURSOR compile_pkg_cur IS
5254: select object_name || ' ' ||