APPS.WIP_WICTPG dependencies on WIP_LPN_COMPLETIONS_SERIALS

Line 1714: --Purge records from WIP_LPN_COMPLETIONS, WIP_LPN_COMPLETIONS_LOTS, WIP_LPN_COMPLETIONS_SERIALS

1710:
1711:
1712: --
1713: --Bug#4716115 START
1714: --Purge records from WIP_LPN_COMPLETIONS, WIP_LPN_COMPLETIONS_LOTS, WIP_LPN_COMPLETIONS_SERIALS
1715: --
1716:
1717: -- delete from wip_lpn_completions_lots
1718: x_purge_rec.table_name := 'WIP_LPN_COMPLETIONS_LOTS';

Line 1747: -- delete from wip_lpn_completions_serials

1743: p_purge_rec => x_purge_rec,
1744: num_rows => x_num_rows);
1745: end if;
1746:
1747: -- delete from wip_lpn_completions_serials
1748: x_purge_rec.table_name := 'WIP_LPN_COMPLETIONS_SERIALS';
1749:
1750: if (p_option = REPORT_ONLY) then
1751: SELECT COUNT(*) INTO X_NUM_ROWS

Line 1748: x_purge_rec.table_name := 'WIP_LPN_COMPLETIONS_SERIALS';

1744: num_rows => x_num_rows);
1745: end if;
1746:
1747: -- delete from wip_lpn_completions_serials
1748: x_purge_rec.table_name := 'WIP_LPN_COMPLETIONS_SERIALS';
1749:
1750: if (p_option = REPORT_ONLY) then
1751: SELECT COUNT(*) INTO X_NUM_ROWS
1752: FROM WIP_LPN_COMPLETIONS_SERIALS WLCS

Line 1752: FROM WIP_LPN_COMPLETIONS_SERIALS WLCS

1748: x_purge_rec.table_name := 'WIP_LPN_COMPLETIONS_SERIALS';
1749:
1750: if (p_option = REPORT_ONLY) then
1751: SELECT COUNT(*) INTO X_NUM_ROWS
1752: FROM WIP_LPN_COMPLETIONS_SERIALS WLCS
1753: WHERE WLCS.HEADER_ID IN
1754: (
1755: SELECT WLC.HEADER_ID
1756: FROM WIP_LPN_COMPLETIONS WLC

Line 1760: DELETE FROM WIP_LPN_COMPLETIONS_SERIALS WLCS

1756: FROM WIP_LPN_COMPLETIONS WLC
1757: WHERE TRANSACTION_SOURCE_ID = X_PURGE_REC.WIP_ENTITY_ID
1758: );
1759: else
1760: DELETE FROM WIP_LPN_COMPLETIONS_SERIALS WLCS
1761: WHERE WLCS.HEADER_ID IN
1762: (
1763: SELECT WLC.HEADER_ID
1764: FROM WIP_LPN_COMPLETIONS WLC