DBA Data[Home] [Help]

APPS.WSM_JOBPURGE_GRP dependencies on WIP_OPERATION_YIELDS

Line 579: x_purge_rec.table_name := 'WIP_OPERATION_YIELDS';

575: );
576: END IF;
577: -- Bug 4722718 : End
578:
579: x_purge_rec.table_name := 'WIP_OPERATION_YIELDS';
580:
581: if (p_option = REPORT_ONLY) then
582: select count(*)
583: into x_num_rows

Line 584: from WIP_OPERATION_YIELDS

580:
581: if (p_option = REPORT_ONLY) then
582: select count(*)
583: into x_num_rows
584: from WIP_OPERATION_YIELDS
585: where wip_entity_id = x_purge_rec.wip_entity_id;
586:
587: else
588:

Line 589: DELETE FROM WIP_OPERATION_YIELDS

585: where wip_entity_id = x_purge_rec.wip_entity_id;
586:
587: else
588:
589: DELETE FROM WIP_OPERATION_YIELDS
590: WHERE wip_entity_id = x_purge_rec.wip_entity_id;
591: x_num_rows := SQL%ROWCOUNT;
592:
593: end if;