APPS.EDW_TRUNC_STG dependencies on DBMS_SQL

Line 126: cid := DBMS_SQL.open_cursor;

122: close table_owner;
123: edw_log.put_line('owner '||l_owner);
124: edw_log.put_line('staging '||p_stg_name);
125: if l_owner is not null then
126: cid := DBMS_SQL.open_cursor;
127: DBMS_SQL.PARSE(cid, 'truncate table '||l_owner||'.'||p_stg_name||' drop storage', dbms_sql.native);
128: g_dummy_int:=DBMS_SQL.EXECUTE(cid);
129: commit;
130: end if;

Line 127: DBMS_SQL.PARSE(cid, 'truncate table '||l_owner||'.'||p_stg_name||' drop storage', dbms_sql.native);

123: edw_log.put_line('owner '||l_owner);
124: edw_log.put_line('staging '||p_stg_name);
125: if l_owner is not null then
126: cid := DBMS_SQL.open_cursor;
127: DBMS_SQL.PARSE(cid, 'truncate table '||l_owner||'.'||p_stg_name||' drop storage', dbms_sql.native);
128: g_dummy_int:=DBMS_SQL.EXECUTE(cid);
129: commit;
130: end if;
131: EXCEPTION

Line 128: g_dummy_int:=DBMS_SQL.EXECUTE(cid);

124: edw_log.put_line('staging '||p_stg_name);
125: if l_owner is not null then
126: cid := DBMS_SQL.open_cursor;
127: DBMS_SQL.PARSE(cid, 'truncate table '||l_owner||'.'||p_stg_name||' drop storage', dbms_sql.native);
128: g_dummy_int:=DBMS_SQL.EXECUTE(cid);
129: commit;
130: end if;
131: EXCEPTION
132: when others then