APPS.CN_FORMULA_GEN_PKG dependencies on DBMS_SQL

Line 5042: sqlstring dbms_sql.varchar2s;

5038: l_dev_phase VARCHAR2(80);
5039: l_dev_status VARCHAR2(80) := 'INCOMPLETE';
5040: l_status BOOLEAN;
5041:
5042: sqlstring dbms_sql.varchar2s;
5043: empty_sqlstring dbms_sql.varchar2s;
5044: cursor1 INTEGER;
5045:
5046: i INTEGER;

Line 5043: empty_sqlstring dbms_sql.varchar2s;

5039: l_dev_status VARCHAR2(80) := 'INCOMPLETE';
5040: l_status BOOLEAN;
5041:
5042: sqlstring dbms_sql.varchar2s;
5043: empty_sqlstring dbms_sql.varchar2s;
5044: cursor1 INTEGER;
5045:
5046: i INTEGER;
5047: j INTEGER;

Line 5153: -- start usage of ad_ddl from bug 12330815 ( repalce dbms_sql with ad_ddl)

5149: 'cn.plsql.cn_formula_gen_pkg.generate_formula.progress',
5150: 'Generate the PL/SQL code successfully in generate_formula');
5151: end if;
5152:
5153: -- start usage of ad_ddl from bug 12330815 ( repalce dbms_sql with ad_ddl)
5154:
5155: SELECT user
5156: INTO l_applsys_schema
5157: FROM dual;