APPS.WIP_WICTPG dependencies on WIP_OP_RESOURCE_INSTANCES

Line 211: x_purge_rec.table_name := 'WIP_OP_RESOURCE_INSTANCES';

207: num_rows => x_num_rows);
208: end if;
209:
210: /*fix for bug no 4774572*/
211: x_purge_rec.table_name := 'WIP_OP_RESOURCE_INSTANCES';
212: if (p_option = REPORT_ONLY) then
213: select count(*) into x_num_rows from WIP_OP_RESOURCE_INSTANCES where
214: WIP_ENTITY_ID= x_purge_rec.wip_entity_id
215: AND ORGANIZATION_ID = x_purge_rec.org_id;

Line 213: select count(*) into x_num_rows from WIP_OP_RESOURCE_INSTANCES where

209:
210: /*fix for bug no 4774572*/
211: x_purge_rec.table_name := 'WIP_OP_RESOURCE_INSTANCES';
212: if (p_option = REPORT_ONLY) then
213: select count(*) into x_num_rows from WIP_OP_RESOURCE_INSTANCES where
214: WIP_ENTITY_ID= x_purge_rec.wip_entity_id
215: AND ORGANIZATION_ID = x_purge_rec.org_id;
216: else
217: DELETE FROM WIP_OP_RESOURCE_INSTANCES

Line 217: DELETE FROM WIP_OP_RESOURCE_INSTANCES

213: select count(*) into x_num_rows from WIP_OP_RESOURCE_INSTANCES where
214: WIP_ENTITY_ID= x_purge_rec.wip_entity_id
215: AND ORGANIZATION_ID = x_purge_rec.org_id;
216: else
217: DELETE FROM WIP_OP_RESOURCE_INSTANCES
218: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id
219: AND ORGANIZATION_ID = x_purge_rec.org_id;
220: x_num_rows := SQL%ROWCOUNT;
221: end if;

Line 416: x_purge_rec.table_name := 'WIP_OP_RESOURCE_INSTANCES';

412: num_rows => x_num_rows);
413: end if;
414:
415: /*fix for bug no 4774572*/
416: x_purge_rec.table_name := 'WIP_OP_RESOURCE_INSTANCES';
417: if (p_option = REPORT_ONLY) then
418: select count(*) into x_num_rows from WIP_OP_RESOURCE_INSTANCES
419: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id
420: AND ORGANIZATION_ID = x_purge_rec.org_id;

Line 418: select count(*) into x_num_rows from WIP_OP_RESOURCE_INSTANCES

414:
415: /*fix for bug no 4774572*/
416: x_purge_rec.table_name := 'WIP_OP_RESOURCE_INSTANCES';
417: if (p_option = REPORT_ONLY) then
418: select count(*) into x_num_rows from WIP_OP_RESOURCE_INSTANCES
419: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id
420: AND ORGANIZATION_ID = x_purge_rec.org_id;
421: else
422: DELETE FROM WIP_OP_RESOURCE_INSTANCES

Line 422: DELETE FROM WIP_OP_RESOURCE_INSTANCES

418: select count(*) into x_num_rows from WIP_OP_RESOURCE_INSTANCES
419: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id
420: AND ORGANIZATION_ID = x_purge_rec.org_id;
421: else
422: DELETE FROM WIP_OP_RESOURCE_INSTANCES
423: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id
424: AND ORGANIZATION_ID = x_purge_rec.org_id;
425: x_num_rows := SQL%ROWCOUNT;
426: end if;