DBA Data[Home] [Help]

APPS.GME_UNRELEASE_STEP_PVT dependencies on GME_BATCH_STEP_RESOURCES

Line 180: UPDATE gme_batch_step_resources

176: WHERE batchstep_id = x_batch_step_rec.batchstep_id
177: AND batch_id = x_batch_step_rec.batch_id;
178:
179: -- Remove the actual start date of the resources... set defaults; set WHO columns
180: UPDATE gme_batch_step_resources
181: SET actual_start_date = NULL
182: ,plan_rsrc_count = NVL (plan_rsrc_count, 1)
183: ,plan_rsrc_qty = NVL (plan_rsrc_qty, 0)
184: ,plan_rsrc_usage = NVL (plan_rsrc_usage, 0)

Line 199: UPDATE gme_batch_step_resources

195: WHERE batchstep_id = x_batch_step_rec.batchstep_id
196: AND batch_id = x_batch_step_rec.batch_id
197: AND plan_start_date IS NULL;
198:
199: UPDATE gme_batch_step_resources
200: SET plan_start_date = x_batch_step_rec.plan_start_date
201: WHERE batchstep_id = x_batch_step_rec.batchstep_id
202: AND batch_id = x_batch_step_rec.batch_id
203: AND plan_start_date IS NULL;

Line 211: UPDATE gme_batch_step_resources

207: WHERE batchstep_id = x_batch_step_rec.batchstep_id
208: AND batch_id = x_batch_step_rec.batch_id
209: AND plan_cmplt_date IS NULL;
210:
211: UPDATE gme_batch_step_resources
212: SET plan_cmplt_date = x_batch_step_rec.plan_cmplt_date
213: WHERE batchstep_id = x_batch_step_rec.batchstep_id
214: AND batch_id = x_batch_step_rec.batch_id
215: AND plan_cmplt_date IS NULL;