DBA Data[Home] [Help]

APPS.WIP_WICTPG dependencies on MRP_RELIEF_INTERFACE

Line 1564: x_purge_rec.table_name := 'MRP_RELIEF_INTERFACE';

1560: num_rows => x_num_rows);
1561: end if;
1562:
1563:
1564: x_purge_rec.table_name := 'MRP_RELIEF_INTERFACE';
1565:
1566: if (p_option = REPORT_ONLY) then
1567: SELECT COUNT(*) INTO x_num_rows
1568: FROM MRP_RELIEF_INTERFACE

Line 1568: FROM MRP_RELIEF_INTERFACE

1564: x_purge_rec.table_name := 'MRP_RELIEF_INTERFACE';
1565:
1566: if (p_option = REPORT_ONLY) then
1567: SELECT COUNT(*) INTO x_num_rows
1568: FROM MRP_RELIEF_INTERFACE
1569: WHERE DISPOSITION_TYPE = 1
1570: AND DISPOSITION_ID = x_purge_rec.wip_entity_id;
1571: else
1572: DELETE FROM MRP_RELIEF_INTERFACE

Line 1572: DELETE FROM MRP_RELIEF_INTERFACE

1568: FROM MRP_RELIEF_INTERFACE
1569: WHERE DISPOSITION_TYPE = 1
1570: AND DISPOSITION_ID = x_purge_rec.wip_entity_id;
1571: else
1572: DELETE FROM MRP_RELIEF_INTERFACE
1573: WHERE DISPOSITION_TYPE = 1
1574: AND DISPOSITION_ID = x_purge_rec.wip_entity_id;
1575:
1576: x_num_rows := SQL%ROWCOUNT ;