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_SQL_EXPS

Line 13: calc_sql_exp_id cn_calc_sql_exps.calc_sql_exp_id%TYPE,

9:
10: -- following type def added for Formula Perf 11.5.10 Enhancments
11: TYPE exp_tbl_clmn_names_type IS record
12: (exp_type_name VARCHAR2(3),
13: calc_sql_exp_id cn_calc_sql_exps.calc_sql_exp_id%TYPE,
14: table_alias cn_objects.name%TYPE,
15: table_name cn_objects.name%type,
16: table_object_id cn_objects.object_id%TYPE,
17: schema cn_objects.schema%TYPE,

Line 29: calc_sql_exp_id cn_calc_sql_exps.calc_sql_exp_id%TYPE,

25:
26:
27: TYPE exp_tbl_names_type IS record
28: (exp_type_name VARCHAR2(3),
29: calc_sql_exp_id cn_calc_sql_exps.calc_sql_exp_id%TYPE,
30: table_alias cn_objects.name%TYPE,
31: table_name cn_objects.name%TYPE,
32: table_object_id cn_objects.object_id%TYPE,
33: schema cn_objects.schema%TYPE,

Line 161: FROM cn_calc_sql_exps_all cse,(SELECT 'PRF' exp_type_name,perf_measure_id exp_id

157: SELECT formula_exps.exp_type_name exp_type_name,
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

Line 680: FROM cn_calc_sql_exps_all

676: p2 pls_integer; -- temporary position pointer
677:
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

Line 697: FROM cn_calc_sql_exps_all

693: WHERE calc_formula_id = p_formula_id
694: AND org_id = g_org_id);
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

Line 1652: FROM cn_calc_sql_exps_all

1648: AND ROWNUM = 1));
1649:
1650: CURSOR l_sql_select_from_csr (l_calc_sql_exp_id NUMBER) IS
1651: SELECT sql_select input_sql_select, sql_from input_sql_from
1652: FROM cn_calc_sql_exps_all
1653: WHERE calc_sql_exp_id = l_calc_sql_exp_id;
1654:
1655: BEGIN
1656: procedure_name := 'get_input';

Line 1996: l_out_calc_sql_exp_id cn_calc_sql_exps.calc_sql_exp_id%TYPE;

1992: l_operator VARCHAR2(1);
1993:
1994: l_output_sql_select_clob clob;
1995: l_output_sql_from_clob clob;
1996: l_out_calc_sql_exp_id cn_calc_sql_exps.calc_sql_exp_id%TYPE;
1997:
1998: CURSOR l_sql_select_from_csr IS
1999: SELECT calc_sql_exp_id,
2000: sql_select output_sql_select,

Line 2002: FROM cn_calc_sql_exps_all

1998: CURSOR l_sql_select_from_csr IS
1999: SELECT calc_sql_exp_id,
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);

Line 2236: l_input_sql_exp_id cn_calc_sql_exps.calc_sql_exp_id%TYPE;

2232: l_perf_sql_where varchar2(4000) := 'WHERE 1=1 ';
2233:
2234: l_perf_sql_select_clob clob;
2235: l_perf_sql_from_clob clob;
2236: l_input_sql_exp_id cn_calc_sql_exps.calc_sql_exp_id%TYPE;
2237:
2238: CURSOR l_perf_select_from_csr IS
2239: select sql_select, sql_from
2240: from cn_calc_sql_exps_all

Line 2240: from cn_calc_sql_exps_all

2236: l_input_sql_exp_id cn_calc_sql_exps.calc_sql_exp_id%TYPE;
2237:
2238: CURSOR l_perf_select_from_csr IS
2239: select sql_select, sql_from
2240: from cn_calc_sql_exps_all
2241: where calc_sql_exp_id = g_perf_measure_id;
2242:
2243: CURSOR l_input_select_from_csr IS
2244: SELECT calc_sql_exp_id,

Line 2247: FROM cn_calc_sql_exps_all

2243: CURSOR l_input_select_from_csr IS
2244: SELECT calc_sql_exp_id,
2245: sql_select input_sql_select,
2246: sql_from input_sql_from
2247: FROM cn_calc_sql_exps_all
2248: WHERE calc_sql_exp_id = (SELECT calc_sql_exp_id
2249: FROM cn_formula_inputs_all
2250: WHERE calc_formula_id = g_formula_id
2251: AND org_id = g_org_id

Line 2517: FROM cn_calc_sql_exps_all

2513: l_sql_select VARCHAR2(8000);
2514:
2515: CURSOR exps IS
2516: SELECT dbms_lob.substr(sql_select) sql_select
2517: FROM cn_calc_sql_exps_all
2518: WHERE calc_sql_exp_id = (SELECT calc_sql_exp_id
2519: FROM cn_formula_inputs_all
2520: WHERE calc_formula_id = g_formula_id
2521: AND org_id = g_org_id

Line 2961: FROM cn_calc_sql_exps_all

2957: || itd_input.rate_dim_sequence || ';' );
2958:
2959: SELECT sql_select input_sql_select, sql_from input_sql_from
2960: INTO l_input_sql_select_clob, l_input_sql_from_clob
2961: FROM cn_calc_sql_exps_all
2962: WHERE calc_sql_exp_id = itd_input.calc_sql_exp_id
2963: AND org_id = g_org_id;
2964:
2965: convert_clob_to_string( l_input_sql_select_clob, l_input_sql_select );

Line 3046: FROM cn_calc_sql_exps_all

3042: cn_utils.appendcr(body_code);
3043: IF g_itd_flag = 'Y' THEN
3044: SELECT sql_select output_sql_select
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

Line 3065: FROM cn_calc_sql_exps_all

3061: END IF;
3062:
3063: SELECT sql_select input_sql_select, sql_from input_sql_from
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

Line 3719: from cn_calc_sql_exps_all

3715:
3716: IF g_perf_measure_id IS NOT NULL THEN
3717: select sql_select, sql_from
3718: into l_input_sql_select_clob, l_input_sql_from_clob
3719: from cn_calc_sql_exps_all
3720: where calc_sql_exp_id = g_perf_measure_id
3721: and org_id = g_org_id;
3722:
3723: convert_clob_to_string(l_input_sql_select_clob, l_input_sql_select);

Line 3731: FROM cn_calc_sql_exps_all

3727:
3728: ELSE /* default to be the input with the lowest input_sequence */
3729: SELECT sql_select input_sql_select, sql_from input_sql_from
3730: INTO l_input_sql_select_clob, l_input_sql_from_clob
3731: FROM cn_calc_sql_exps_all
3732: WHERE org_id = g_org_id
3733: AND calc_sql_exp_id = (SELECT calc_sql_exp_id
3734: FROM cn_formula_inputs_all
3735: WHERE calc_formula_id = g_formula_id

Line 3858: FROM cn_calc_sql_exps_all

3854: AND ROWNUM = 1));
3855:
3856: CURSOR l_input_sql_select_from_csr (l_calc_sql_exp_id NUMBER) IS
3857: SELECT sql_select input_sql_select, sql_from input_sql_from
3858: FROM cn_calc_sql_exps_all
3859: WHERE calc_sql_exp_id = l_calc_sql_exp_id
3860: AND org_id = g_org_id;
3861:
3862: l_output_sql_select varchar2(8000);

Line 3871: FROM cn_calc_sql_exps_all

3867: l_output_sql_where varchar2(4000) := 'WHERE 1=1 ';
3868:
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);

Line 3879: from cn_calc_sql_exps_all

3875: AND org_id = g_org_id);
3876:
3877: CURSOR l_perf_select_from_csr IS
3878: select sql_select, sql_from
3879: from cn_calc_sql_exps_all
3880: where calc_sql_exp_id = g_perf_measure_id;
3881:
3882: CURSOR l_inp_perf_select_from_csr IS
3883: SELECT sql_select input_sql_select, sql_from input_sql_from

Line 3884: FROM cn_calc_sql_exps_all

3880: where calc_sql_exp_id = g_perf_measure_id;
3881:
3882: CURSOR l_inp_perf_select_from_csr IS
3883: SELECT sql_select input_sql_select, sql_from input_sql_from
3884: FROM cn_calc_sql_exps_all
3885: WHERE calc_sql_exp_id = (SELECT calc_sql_exp_id
3886: FROM cn_formula_inputs_all
3887: WHERE calc_formula_id = g_formula_id
3888: AND org_id = g_org_id

Line 4326: FROM cn_calc_sql_exps_all

4322: AND ROWNUM = 1));
4323:
4324: CURSOR sql_statement(p_calc_sql_exp_id NUMBER) IS
4325: SELECT dbms_lob.substr(sql_select), dbms_lob.substr(sql_from)
4326: FROM cn_calc_sql_exps_all
4327: WHERE calc_sql_exp_id = p_calc_sql_exp_id;
4328: BEGIN
4329: OPEN f_output;
4330: FETCH f_output INTO l_output_exp_id;

Line 4704: FROM cn_calc_sql_exps_all

4700: AND org_id = g_org_id;
4701:
4702: CURSOR sql_statement(p_calc_sql_exp_id NUMBER) IS
4703: SELECT dbms_lob.substr(piped_sql_select), dbms_lob.substr(sql_select), dbms_lob.substr(sql_from)
4704: FROM cn_calc_sql_exps_all
4705: WHERE calc_sql_exp_id = p_calc_sql_exp_id;
4706: BEGIN
4707: OPEN output;
4708: FETCH output INTO l_output_exp_id, l_modeling_flag;