APPS.GME_UNRELEASE_STEP_PVT dependencies on GME_BATCH_STEP_ACTIVITIES

Line 188: UPDATE gme_batch_step_activities

184: RAISE update_step_qty_error;
185: END IF;
186:
187: -- Remove the actual start date of the activities... set defaults; set WHO columns
188: UPDATE gme_batch_step_activities
189: SET actual_start_date = NULL
190: ,plan_activity_factor = NVL (plan_activity_factor, 0)
191: ,last_updated_by = gme_common_pvt.g_user_ident
192: ,last_update_date = gme_common_pvt.g_timestamp

Line 211: UPDATE gme_batch_step_activities

207: AND batch_id = x_batch_step_rec.batch_id;
208:
209: -- Update plan start date and plan completion date on activity and resources
210: -- to that on the step if they are NULL; who columns set above, no need again...
211: UPDATE gme_batch_step_activities
212: SET plan_start_date = x_batch_step_rec.plan_start_date
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;

Line 223: UPDATE gme_batch_step_activities

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;
222:
223: UPDATE gme_batch_step_activities
224: SET plan_cmplt_date = x_batch_step_rec.plan_cmplt_date
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;