DBA Data[Home] [Help]

APPS.WIP_WICTPG dependencies on PO_DISTRIBUTIONS_INTERFACE

Line 2140: x_purge_rec.table_name := 'PO_DISTRIBUTIONS_INTERFACE';

2136: if (x_records_found = FALSE and p_sched_txn_flag = FALSE
2137: and p_sched_move_txn_flag = FALSE) then
2138:
2139: x_purge_rec.info_type := ROWS_AFFECTED ;
2140: x_purge_rec.table_name := 'PO_DISTRIBUTIONS_INTERFACE';
2141:
2142: savepoint sched_header01;
2143: DELETE FROM PO_DISTRIBUTIONS_INTERFACE
2144: WHERE WIP_REPETITIVE_SCHEDULE_ID = x_purge_rec.schedule_id;

Line 2143: DELETE FROM PO_DISTRIBUTIONS_INTERFACE

2139: x_purge_rec.info_type := ROWS_AFFECTED ;
2140: x_purge_rec.table_name := 'PO_DISTRIBUTIONS_INTERFACE';
2141:
2142: savepoint sched_header01;
2143: DELETE FROM PO_DISTRIBUTIONS_INTERFACE
2144: WHERE WIP_REPETITIVE_SCHEDULE_ID = x_purge_rec.schedule_id;
2145: l_num_rows := sql%rowcount;
2146: if ( p_option = REPORT_ONLY) then
2147: -- rollback deletes