DBA Data[Home] [Help]

APPS.WIP_WICTPG dependencies on WIP_EXCEPTIONS

Line 1876: x_purge_rec.table_name := 'WIP_EXCEPTIONS';

1872: num_rows => x_num_rows);
1873: end if;
1874:
1875: /* Bug#4675116 */
1876: x_purge_rec.table_name := 'WIP_EXCEPTIONS';
1877:
1878: if (p_option = REPORT_ONLY) then
1879: SELECT COUNT(*)
1880: INTO x_num_rows

Line 1881: FROM WIP_EXCEPTIONS

1877:
1878: if (p_option = REPORT_ONLY) then
1879: SELECT COUNT(*)
1880: INTO x_num_rows
1881: FROM WIP_EXCEPTIONS
1882: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id
1883: AND ORGANIZATION_ID = x_purge_rec.org_id;
1884: else
1885: DELETE FROM WIP_EXCEPTIONS

Line 1885: DELETE FROM WIP_EXCEPTIONS

1881: FROM WIP_EXCEPTIONS
1882: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id
1883: AND ORGANIZATION_ID = x_purge_rec.org_id;
1884: else
1885: DELETE FROM WIP_EXCEPTIONS
1886: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id
1887: AND ORGANIZATION_ID = x_purge_rec.org_id;
1888: x_num_rows := SQL%ROWCOUNT ;
1889: end if ;