APPS.CN_FORMULA_GEN_PKG dependencies on AD_DDL

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;

Line 5172: ad_ddl.build_package(pkg_line.text, i);

5168:
5169: i := 0;
5170: FOR pkg_line IN fetch_code(c_pkg_spec.object_id, l_pkg_start_rec.line_no, l_pkg_end_rec.line_no) LOOP
5171: i:= i + 1;
5172: ad_ddl.build_package(pkg_line.text, i);
5173: END LOOP;
5174: ad_ddl.create_package(l_applsys_schema, 'CN', c_pkg_spec.name, 'FALSE', 1, i);
5175:
5176: END LOOP;

Line 5174: ad_ddl.create_package(l_applsys_schema, 'CN', c_pkg_spec.name, 'FALSE', 1, i);

5170: FOR pkg_line IN fetch_code(c_pkg_spec.object_id, l_pkg_start_rec.line_no, l_pkg_end_rec.line_no) LOOP
5171: i:= i + 1;
5172: ad_ddl.build_package(pkg_line.text, i);
5173: END LOOP;
5174: ad_ddl.create_package(l_applsys_schema, 'CN', c_pkg_spec.name, 'FALSE', 1, i);
5175:
5176: END LOOP;
5177:
5178:

Line 5192: ad_ddl.build_package(pkg_line.text, i);

5188:
5189: i := 0;
5190: FOR pkg_line IN fetch_code(c_pkg_body.object_id, l_pkg_start_rec.line_no, l_pkg_end_rec.line_no) LOOP
5191: i := i + 1;
5192: ad_ddl.build_package(pkg_line.text, i);
5193: END LOOP;
5194: ad_ddl.create_package(l_applsys_schema, 'CN', c_pkg_body.name, 'TRUE', 1, i);
5195:
5196: END LOOP;

Line 5194: ad_ddl.create_package(l_applsys_schema, 'CN', c_pkg_body.name, 'TRUE', 1, i);

5190: FOR pkg_line IN fetch_code(c_pkg_body.object_id, l_pkg_start_rec.line_no, l_pkg_end_rec.line_no) LOOP
5191: i := i + 1;
5192: ad_ddl.build_package(pkg_line.text, i);
5193: END LOOP;
5194: ad_ddl.create_package(l_applsys_schema, 'CN', c_pkg_body.name, 'TRUE', 1, i);
5195:
5196: END LOOP;
5197:
5198:

Line 5199: -- end usage of ad_ddl from bug 12330815

5195:
5196: END LOOP;
5197:
5198:
5199: -- end usage of ad_ddl from bug 12330815
5200:
5201: -- check whether package is installed successfully
5202: SELECT COUNT(*)
5203: INTO l_error_count