DBA Data[Home] [Help]

APPS.IBE_REPORTING_PVT dependencies on DBMS_SQL

Line 1512: ddl_curs := dbms_sql.open_cursor;

1508: EXECUTE IMMEDIATE chg_tbl.sqlstmt;
1509: end loop;
1510: */
1511:
1512: ddl_curs := dbms_sql.open_cursor;
1513: for chg_tbl in dr_obj_mv(pOwner,pName) loop
1514: /* Parse implicitly executes the DDL statements */
1515: dbms_sql.parse(ddl_curs, chg_tbl.sqlstmt,dbms_sql.native) ;
1516: end loop;

Line 1515: dbms_sql.parse(ddl_curs, chg_tbl.sqlstmt,dbms_sql.native) ;

1511:
1512: ddl_curs := dbms_sql.open_cursor;
1513: for chg_tbl in dr_obj_mv(pOwner,pName) loop
1514: /* Parse implicitly executes the DDL statements */
1515: dbms_sql.parse(ddl_curs, chg_tbl.sqlstmt,dbms_sql.native) ;
1516: end loop;
1517: dbms_sql.close_cursor(ddl_curs);
1518:
1519: End If;

Line 1517: dbms_sql.close_cursor(ddl_curs);

1513: for chg_tbl in dr_obj_mv(pOwner,pName) loop
1514: /* Parse implicitly executes the DDL statements */
1515: dbms_sql.parse(ddl_curs, chg_tbl.sqlstmt,dbms_sql.native) ;
1516: end loop;
1517: dbms_sql.close_cursor(ddl_curs);
1518:
1519: End If;
1520: IF (l_debug = 'Y') THEN
1521: printDebugLog('dropMview(-)');