APPS.OZF_REFRESH_VIEW_PVT dependencies on DBMS_SQL

Line 680: ddl_curs := dbms_sql.open_CURSOR;

676: COMMIT;
677:
678: --Disable the indexes on the main table (rename cannot happen along INDEXES
679:
680: ddl_curs := dbms_sql.open_CURSOR;
681: FOR chg_tbl in dis_obj LOOP
682: dbms_sql.parse(ddl_curs, chg_tbl.sqlstmt,dbms_sql.native) ;
683: END LOOP;
684: dbms_sql.close_CURSOR(ddl_curs);

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

678: --Disable the indexes on the main table (rename cannot happen along INDEXES
679:
680: ddl_curs := dbms_sql.open_CURSOR;
681: FOR chg_tbl in dis_obj LOOP
682: dbms_sql.parse(ddl_curs, chg_tbl.sqlstmt,dbms_sql.native) ;
683: END LOOP;
684: dbms_sql.close_CURSOR(ddl_curs);
685: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ': End');
686:

Line 684: dbms_sql.close_CURSOR(ddl_curs);

680: ddl_curs := dbms_sql.open_CURSOR;
681: FOR chg_tbl in dis_obj LOOP
682: dbms_sql.parse(ddl_curs, chg_tbl.sqlstmt,dbms_sql.native) ;
683: END LOOP;
684: dbms_sql.close_CURSOR(ddl_curs);
685: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ': End');
686:
687: /*truncate and rename main table as an intermediate table.
688: rename temp table as main table.

Line 701: ddl_curs := dbms_sql.open_CURSOR;

697: EXECUTE IMMEDIATE 'ALTER TABLE '|| ls_owner||'.'||p_table_name||'_I RENAME TO '||p_table_name||'_TEMP';
698:
699: --enable indexes on main table
700:
701: ddl_curs := dbms_sql.open_CURSOR;
702: FOR chg_tbl in en_obj LOOP
703: dbms_sql.parse(ddl_curs, chg_tbl.sqlstmt,dbms_sql.native) ;
704: END LOOP;
705: dbms_sql.close_CURSOR(ddl_curs);

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

699: --enable indexes on main table
700:
701: ddl_curs := dbms_sql.open_CURSOR;
702: FOR chg_tbl in en_obj LOOP
703: dbms_sql.parse(ddl_curs, chg_tbl.sqlstmt,dbms_sql.native) ;
704: END LOOP;
705: dbms_sql.close_CURSOR(ddl_curs);
706:
707:

Line 705: dbms_sql.close_CURSOR(ddl_curs);

701: ddl_curs := dbms_sql.open_CURSOR;
702: FOR chg_tbl in en_obj LOOP
703: dbms_sql.parse(ddl_curs, chg_tbl.sqlstmt,dbms_sql.native) ;
704: END LOOP;
705: dbms_sql.close_CURSOR(ddl_curs);
706:
707:
708: END refresh_summary_table;
709: