DBA Data[Home] [Help]

APPS.GME_COMPLETE_BATCH_STEP_PVT dependencies on GME_BATCH_STEP_RSRC_SUMMARY

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

441: WHERE batchstep_id = x_batch_step_rec.batchstep_id
442: AND batch_id = x_batch_step_rec.batch_id
443: AND actual_start_date IS NULL;
444:
445: /* We need to remove the resource information for the gme_batch_step_rsrc_summary */
446: /* table, as this table should only hold data of the resources which are in PENDING or WIP */
447: DELETE FROM gme_batch_step_rsrc_summary
448: WHERE batchstep_id = x_batch_step_rec.batchstep_id
449: AND batch_id = x_batch_step_rec.batch_id;

Line 447: DELETE FROM gme_batch_step_rsrc_summary

443: AND actual_start_date IS NULL;
444:
445: /* We need to remove the resource information for the gme_batch_step_rsrc_summary */
446: /* table, as this table should only hold data of the resources which are in PENDING or WIP */
447: DELETE FROM gme_batch_step_rsrc_summary
448: WHERE batchstep_id = x_batch_step_rec.batchstep_id
449: AND batch_id = x_batch_step_rec.batch_id;
450:
451: EXCEPTION