APPS.WIP_WICTPG dependencies on MTL_TRANSACTIONS_INTERFACE

Line 1613: x_purge_rec.table_name := 'MTL_TRANSACTIONS_INTERFACE';

1609: num_rows => x_num_rows);
1610: end if;
1611:
1612:
1613: x_purge_rec.table_name := 'MTL_TRANSACTIONS_INTERFACE';
1614:
1615: if (p_option = REPORT_ONLY) then
1616: SELECT COUNT(*) INTO x_num_rows
1617: FROM MTL_TRANSACTIONS_INTERFACE

Line 1617: FROM MTL_TRANSACTIONS_INTERFACE

1613: x_purge_rec.table_name := 'MTL_TRANSACTIONS_INTERFACE';
1614:
1615: if (p_option = REPORT_ONLY) then
1616: SELECT COUNT(*) INTO x_num_rows
1617: FROM MTL_TRANSACTIONS_INTERFACE
1618: WHERE TRANSACTION_SOURCE_TYPE_ID = 5
1619: AND TRANSACTION_SOURCE_ID = x_purge_rec.wip_entity_id;
1620: else
1621: DELETE FROM MTL_TRANSACTIONS_INTERFACE

Line 1621: DELETE FROM MTL_TRANSACTIONS_INTERFACE

1617: FROM MTL_TRANSACTIONS_INTERFACE
1618: WHERE TRANSACTION_SOURCE_TYPE_ID = 5
1619: AND TRANSACTION_SOURCE_ID = x_purge_rec.wip_entity_id;
1620: else
1621: DELETE FROM MTL_TRANSACTIONS_INTERFACE
1622: WHERE TRANSACTION_SOURCE_TYPE_ID = 5
1623: AND TRANSACTION_SOURCE_ID = x_purge_rec.wip_entity_id;
1624: x_num_rows := SQL%ROWCOUNT ;
1625: end if ;