DBA Data[Home] [Help]

APPS.GME_UNRELEASE_STEP_PVT dependencies on GME_BATCH_STEP_RESOURCES

Line 198: UPDATE gme_batch_step_resources

194: WHERE batchstep_id = x_batch_step_rec.batchstep_id
195: AND batch_id = x_batch_step_rec.batch_id;
196:
197: -- Remove the actual start date of the resources... set defaults; set WHO columns
198: UPDATE gme_batch_step_resources
199: SET actual_start_date = NULL
200: ,plan_rsrc_count = NVL (plan_rsrc_count, 1)
201: ,plan_rsrc_qty = NVL (plan_rsrc_qty, 0)
202: ,plan_rsrc_usage = NVL (plan_rsrc_usage, 0)

Line 217: UPDATE gme_batch_step_resources

213: WHERE batchstep_id = x_batch_step_rec.batchstep_id
214: AND batch_id = x_batch_step_rec.batch_id
215: AND plan_start_date IS NULL;
216:
217: UPDATE gme_batch_step_resources
218: SET plan_start_date = x_batch_step_rec.plan_start_date
219: WHERE batchstep_id = x_batch_step_rec.batchstep_id
220: AND batch_id = x_batch_step_rec.batch_id
221: AND plan_start_date IS NULL;

Line 229: UPDATE gme_batch_step_resources

225: WHERE batchstep_id = x_batch_step_rec.batchstep_id
226: AND batch_id = x_batch_step_rec.batch_id
227: AND plan_cmplt_date IS NULL;
228:
229: UPDATE gme_batch_step_resources
230: SET plan_cmplt_date = x_batch_step_rec.plan_cmplt_date
231: WHERE batchstep_id = x_batch_step_rec.batchstep_id
232: AND batch_id = x_batch_step_rec.batch_id
233: AND plan_cmplt_date IS NULL;