DBA Data[Home] [Help]

APPS.GME_COMPLETE_BATCH_STEP_PVT dependencies on GME_BATCH_STEP_RSRC_SUMMARY

Line 502: /* We need to remove the resource information for the gme_batch_step_rsrc_summary */

498: WHERE batchstep_id = x_batch_step_rec.batchstep_id
499: AND batch_id = x_batch_step_rec.batch_id
500: AND actual_start_date IS NULL;
501:
502: /* We need to remove the resource information for the gme_batch_step_rsrc_summary */
503: /* table, as this table should only hold data of the resources which are in PENDING or WIP */
504: DELETE FROM gme_batch_step_rsrc_summary
505: WHERE batchstep_id = x_batch_step_rec.batchstep_id
506: AND batch_id = x_batch_step_rec.batch_id;

Line 504: DELETE FROM gme_batch_step_rsrc_summary

500: AND actual_start_date IS NULL;
501:
502: /* We need to remove the resource information for the gme_batch_step_rsrc_summary */
503: /* table, as this table should only hold data of the resources which are in PENDING or WIP */
504: DELETE FROM gme_batch_step_rsrc_summary
505: WHERE batchstep_id = x_batch_step_rec.batchstep_id
506: AND batch_id = x_batch_step_rec.batch_id;
507:
508: EXCEPTION