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
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
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 ;