DBA Data[Home] [Help]

APPS.WIP_WICTPG dependencies on WIP_SHOP_FLOOR_STATUSES

Line 231: x_purge_rec.table_name := 'WIP_SHOP_FLOOR_STATUSES';

227: num_rows => x_num_rows);
228: end if;
229: /* end fix for bug#4774572*/
230:
231: x_purge_rec.table_name := 'WIP_SHOP_FLOOR_STATUSES';
232: if (p_option = REPORT_ONLY) then
233: select count(*) into x_num_rows from WIP_SHOP_FLOOR_STATUSES where
234: WIP_ENTITY_ID= x_purge_rec.wip_entity_id;
235: else

Line 233: select count(*) into x_num_rows from WIP_SHOP_FLOOR_STATUSES where

229: /* end fix for bug#4774572*/
230:
231: x_purge_rec.table_name := 'WIP_SHOP_FLOOR_STATUSES';
232: if (p_option = REPORT_ONLY) then
233: select count(*) into x_num_rows from WIP_SHOP_FLOOR_STATUSES where
234: WIP_ENTITY_ID= x_purge_rec.wip_entity_id;
235: else
236: DELETE FROM WIP_SHOP_FLOOR_STATUSES
237: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id;

Line 236: DELETE FROM WIP_SHOP_FLOOR_STATUSES

232: if (p_option = REPORT_ONLY) then
233: select count(*) into x_num_rows from WIP_SHOP_FLOOR_STATUSES where
234: WIP_ENTITY_ID= x_purge_rec.wip_entity_id;
235: else
236: DELETE FROM WIP_SHOP_FLOOR_STATUSES
237: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id;
238: x_num_rows := SQL%ROWCOUNT;
239: end if;
240: