APPS.WIP_WICTPG dependencies on WIP_SO_ALLOCATIONS

Line 1826: /* Moved WIP_SO_ALLOCATIONS deletion codes to this section so that it will go

1822: end if;
1823:
1824:
1825:
1826: /* Moved WIP_SO_ALLOCATIONS deletion codes to this section so that it will go
1827: through the foreign key verifications to ensure that WIP_SO_ALLOCATIONS will
1828: NOT be purged if foreign key references exist in the MTL_DEMAND table.
1829: Bug # 622330 */
1830:

Line 1827: through the foreign key verifications to ensure that WIP_SO_ALLOCATIONS will

1823:
1824:
1825:
1826: /* Moved WIP_SO_ALLOCATIONS deletion codes to this section so that it will go
1827: through the foreign key verifications to ensure that WIP_SO_ALLOCATIONS will
1828: NOT be purged if foreign key references exist in the MTL_DEMAND table.
1829: Bug # 622330 */
1830:
1831: if (OE_INSTALL.Get_Active_Product = 'OE') then

Line 1832: x_purge_rec.table_name := 'WIP_SO_ALLOCATIONS';

1828: NOT be purged if foreign key references exist in the MTL_DEMAND table.
1829: Bug # 622330 */
1830:
1831: if (OE_INSTALL.Get_Active_Product = 'OE') then
1832: x_purge_rec.table_name := 'WIP_SO_ALLOCATIONS';
1833:
1834: if (p_option = REPORT_ONLY) then
1835: SELECT COUNT(*) INTO x_num_rows
1836: FROM WIP_SO_ALLOCATIONS

Line 1836: FROM WIP_SO_ALLOCATIONS

1832: x_purge_rec.table_name := 'WIP_SO_ALLOCATIONS';
1833:
1834: if (p_option = REPORT_ONLY) then
1835: SELECT COUNT(*) INTO x_num_rows
1836: FROM WIP_SO_ALLOCATIONS
1837: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id;
1838: else
1839: DELETE FROM WIP_SO_ALLOCATIONS
1840: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id;

Line 1839: DELETE FROM WIP_SO_ALLOCATIONS

1835: SELECT COUNT(*) INTO x_num_rows
1836: FROM WIP_SO_ALLOCATIONS
1837: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id;
1838: else
1839: DELETE FROM WIP_SO_ALLOCATIONS
1840: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id;
1841: x_num_rows := SQL%ROWCOUNT ;
1842: end if ;
1843: