DBA Data[Home] [Help]

APPS.WIP_WICTPG dependencies on WIP_SCHEDULING_EXCEPTIONS

Line 1855: x_purge_rec.table_name := 'WIP_SCHEDULING_EXCEPTIONS';

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

Line 1860: FROM WIP_SCHEDULING_EXCEPTIONS

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;

Line 1863: DELETE FROM WIP_SCHEDULING_EXCEPTIONS

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: