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 1607: l_amount := dbms_lob.getlength(p_clob_loc);

1603:
1604: PROCEDURE convert_clob_to_string ( p_clob_loc clob, x_string OUT NOCOPY VARCHAR2) IS
1605: l_amount NUMBER;
1606: BEGIN
1607: l_amount := dbms_lob.getlength(p_clob_loc);
1608: dbms_lob.read( p_clob_loc, l_amount, 1 , x_string);
1609:
1610: IF (g_pe_id_tbl.COUNT > 0) THEN
1611: FOR i IN g_pe_id_tbl.first..g_pe_id_tbl.last LOOP

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

1604: PROCEDURE convert_clob_to_string ( p_clob_loc clob, x_string OUT NOCOPY VARCHAR2) IS
1605: l_amount NUMBER;
1606: BEGIN
1607: l_amount := dbms_lob.getlength(p_clob_loc);
1608: dbms_lob.read( p_clob_loc, l_amount, 1 , x_string);
1609:
1610: IF (g_pe_id_tbl.COUNT > 0) THEN
1611: FOR i IN g_pe_id_tbl.first..g_pe_id_tbl.last LOOP
1612: x_string := REPLACE(x_string, g_pe_id_tbl(i)||'PE.', 'g_'||g_pe_id_tbl(i)||'PE_');

Line 2529: SELECT dbms_lob.substr(sql_select) sql_select

2525: IS
2526: l_sql_select VARCHAR2(8000);
2527:
2528: CURSOR exps IS
2529: SELECT dbms_lob.substr(sql_select) sql_select
2530: FROM cn_calc_sql_exps_all
2531: WHERE calc_sql_exp_id = (SELECT calc_sql_exp_id
2532: FROM cn_formula_inputs_all
2533: WHERE calc_formula_id = g_formula_id

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

4334: AND org_id = g_org_id
4335: AND ROWNUM = 1));
4336:
4337: CURSOR sql_statement(p_calc_sql_exp_id NUMBER) IS
4338: SELECT dbms_lob.substr(sql_select), dbms_lob.substr(sql_from)
4339: FROM cn_calc_sql_exps_all
4340: WHERE calc_sql_exp_id = p_calc_sql_exp_id;
4341: BEGIN
4342: OPEN f_output;

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

4712: WHERE calc_formula_id = g_formula_id
4713: AND org_id = g_org_id;
4714:
4715: CURSOR sql_statement(p_calc_sql_exp_id NUMBER) IS
4716: SELECT dbms_lob.substr(piped_sql_select), dbms_lob.substr(sql_select), dbms_lob.substr(sql_from)
4717: FROM cn_calc_sql_exps_all
4718: WHERE calc_sql_exp_id = p_calc_sql_exp_id;
4719: BEGIN
4720: OPEN output;