1851: end if;
1852:
1853:
1854:
1855: x_purge_rec.table_name := 'WIP_SCHEDULING_EXCEPTIONS';
1856:
1857: if (p_option = REPORT_ONLY) then
1858: SELECT COUNT(*)
1859: INTO x_num_rows
1856:
1857: if (p_option = REPORT_ONLY) then
1858: SELECT COUNT(*)
1859: INTO x_num_rows
1860: FROM WIP_SCHEDULING_EXCEPTIONS
1861: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id;
1862: else
1863: DELETE FROM WIP_SCHEDULING_EXCEPTIONS
1864: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id;
1859: INTO x_num_rows
1860: FROM WIP_SCHEDULING_EXCEPTIONS
1861: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id;
1862: else
1863: DELETE FROM WIP_SCHEDULING_EXCEPTIONS
1864: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id;
1865: x_num_rows := SQL%ROWCOUNT ;
1866: end if ;
1867: