APPS.AS_SC_DENORM dependencies on DBMS_SQL

Line 98: ddl_curs := dbms_sql.open_cursor;

94: ELSE
95: trace(FALSE);
96: END IF;
97:
98: ddl_curs := dbms_sql.open_cursor;
99: dbms_sql.parse(ddl_curs,'TRUNCATE TABLE ' || l_oracle_schema || '.AS_PERIOD_DAYS drop storage',
100: dbms_sql.native);
101: dbms_sql.close_cursor(ddl_curs);
102:

Line 99: dbms_sql.parse(ddl_curs,'TRUNCATE TABLE ' || l_oracle_schema || '.AS_PERIOD_DAYS drop storage',

95: trace(FALSE);
96: END IF;
97:
98: ddl_curs := dbms_sql.open_cursor;
99: dbms_sql.parse(ddl_curs,'TRUNCATE TABLE ' || l_oracle_schema || '.AS_PERIOD_DAYS drop storage',
100: dbms_sql.native);
101: dbms_sql.close_cursor(ddl_curs);
102:
103: INSERT INTO as_period_days (period_set_name, period_name, period_day,

Line 100: dbms_sql.native);

96: END IF;
97:
98: ddl_curs := dbms_sql.open_cursor;
99: dbms_sql.parse(ddl_curs,'TRUNCATE TABLE ' || l_oracle_schema || '.AS_PERIOD_DAYS drop storage',
100: dbms_sql.native);
101: dbms_sql.close_cursor(ddl_curs);
102:
103: INSERT INTO as_period_days (period_set_name, period_name, period_day,
104: start_date,end_date, period_type)

Line 101: dbms_sql.close_cursor(ddl_curs);

97:
98: ddl_curs := dbms_sql.open_cursor;
99: dbms_sql.parse(ddl_curs,'TRUNCATE TABLE ' || l_oracle_schema || '.AS_PERIOD_DAYS drop storage',
100: dbms_sql.native);
101: dbms_sql.close_cursor(ddl_curs);
102:
103: INSERT INTO as_period_days (period_set_name, period_name, period_day,
104: start_date,end_date, period_type)
105: SELECT period_set_name, period_name, trunc(start_date),

Line 184: ddl_curs := dbms_sql.open_cursor;

180: l_schema_return := FND_INSTALLATION.get_app_info('AS', l_fnd_status, l_industry, l_oracle_schema);
181:
182: SELECT USER INTO l_apps_schema FROM DUAL;
183:
184: ddl_curs := dbms_sql.open_cursor;
185: /* Parse implicitly executes the DDL statements */
186: FOR chg_tbl in dr_obj LOOP
187: dbms_sql.parse(ddl_curs, chg_tbl.sqlstmt,dbms_sql.native) ;
188: END LOOP;

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

183:
184: ddl_curs := dbms_sql.open_cursor;
185: /* Parse implicitly executes the DDL statements */
186: FOR chg_tbl in dr_obj LOOP
187: dbms_sql.parse(ddl_curs, chg_tbl.sqlstmt,dbms_sql.native) ;
188: END LOOP;
189: dbms_sql.close_cursor(ddl_curs);
190: EXCEPTION WHEN OTHERS THEN
191: NULL;

Line 189: dbms_sql.close_cursor(ddl_curs);

185: /* Parse implicitly executes the DDL statements */
186: FOR chg_tbl in dr_obj LOOP
187: dbms_sql.parse(ddl_curs, chg_tbl.sqlstmt,dbms_sql.native) ;
188: END LOOP;
189: dbms_sql.close_cursor(ddl_curs);
190: EXCEPTION WHEN OTHERS THEN
191: NULL;
192: END clear_snapshots;
193: