APPS.CN_FORMULA_GEN_PKG dependencies on DBMS_LOB

Line 158: dbms_lob.substr(piped_sql_from) sql_from,

154: -- +======================================================================+
155: PROCEDURE init_tab_column_list (p_formula_id IN NUMBER) IS
156: CURSOR formula_expressions IS
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

Line 159: dbms_lob.substr(piped_sql_select) sql_select,

155: PROCEDURE init_tab_column_list (p_formula_id IN NUMBER) IS
156: CURSOR formula_expressions IS
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

Line 679: SELECT dbms_lob.substr(piped_sql_select) sql_select

675: p1 pls_integer; -- temporary position pointer
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

Line 696: SELECT dbms_lob.substr(piped_sql_select) sql_select

692: FROM cn_formula_inputs_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

Line 1600: l_amount := dbms_lob.getlength(p_clob_loc);

1596:
1597: PROCEDURE convert_clob_to_string ( p_clob_loc clob, x_string OUT NOCOPY VARCHAR2) IS
1598: l_amount NUMBER;
1599: BEGIN
1600: l_amount := dbms_lob.getlength(p_clob_loc);
1601: dbms_lob.read( p_clob_loc, l_amount, 1 , x_string);
1602:
1603: IF (g_pe_id_tbl.COUNT > 0) THEN
1604: FOR i IN g_pe_id_tbl.first..g_pe_id_tbl.last LOOP

Line 1601: dbms_lob.read( p_clob_loc, l_amount, 1 , x_string);

1597: PROCEDURE convert_clob_to_string ( p_clob_loc clob, x_string OUT NOCOPY VARCHAR2) IS
1598: l_amount NUMBER;
1599: BEGIN
1600: l_amount := dbms_lob.getlength(p_clob_loc);
1601: dbms_lob.read( p_clob_loc, l_amount, 1 , x_string);
1602:
1603: IF (g_pe_id_tbl.COUNT > 0) THEN
1604: FOR i IN g_pe_id_tbl.first..g_pe_id_tbl.last LOOP
1605: x_string := REPLACE(x_string, g_pe_id_tbl(i)||'PE.', 'g_'||g_pe_id_tbl(i)||'PE_');

Line 2516: SELECT dbms_lob.substr(sql_select) sql_select

2512: IS
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

Line 4325: SELECT dbms_lob.substr(sql_select), dbms_lob.substr(sql_from)

4321: AND org_id = g_org_id
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;

Line 4703: SELECT dbms_lob.substr(piped_sql_select), dbms_lob.substr(sql_select), dbms_lob.substr(sql_from)

4699: WHERE calc_formula_id = g_formula_id
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;