APPS.GMI_MO_PURGE dependencies on IC_TXN_REQUEST_HEADERS

Line 100: v_sql_stmt := 'CREATE TABLE IC_TXN_REQUEST_HEADERS_BAK AS SELECT * FROM IC_TXN_REQUEST_HEADERS WHERE 1=2';

96: --
97: -- Create the table. If table exists handle the exception.
98: --
99: BEGIN
100: v_sql_stmt := 'CREATE TABLE IC_TXN_REQUEST_HEADERS_BAK AS SELECT * FROM IC_TXN_REQUEST_HEADERS WHERE 1=2';
101: EXECUTE IMMEDIATE v_sql_stmt;
102: EXCEPTION
103: WHEN table_already_exists THEN
104: NULL;

Line 164: 'INSERT INTO IC_TXN_REQUEST_HEADERS_BAK ' ||

160:
161: EXECUTE IMMEDIATE v_sql_stmt using l_line_id;
162:
163: v_sql_stmt :=
164: 'INSERT INTO IC_TXN_REQUEST_HEADERS_BAK ' ||
165: ' (SELECT * FROM IC_TXN_REQUEST_HEADERS ' ||
166: ' WHERE header_id = :1) ';
167:
168: EXECUTE IMMEDIATE v_sql_stmt using l_header_id;

Line 165: ' (SELECT * FROM IC_TXN_REQUEST_HEADERS ' ||

161: EXECUTE IMMEDIATE v_sql_stmt using l_line_id;
162:
163: v_sql_stmt :=
164: 'INSERT INTO IC_TXN_REQUEST_HEADERS_BAK ' ||
165: ' (SELECT * FROM IC_TXN_REQUEST_HEADERS ' ||
166: ' WHERE header_id = :1) ';
167:
168: EXECUTE IMMEDIATE v_sql_stmt using l_header_id;
169:

Line 176: DELETE FROM ic_txn_request_headers ich

172: --
173: DELETE FROM ic_txn_request_lines
174: WHERE line_id=l_line_id;
175:
176: DELETE FROM ic_txn_request_headers ich
177: WHERE header_id=l_header_id
178: AND NOT EXISTS (select 1 from ic_txn_request_lines icl
179: where icl.header_id=ich.header_id);
180: EXCEPTION