APPS.GME_UNRELEASE_STEP_PVT dependencies on GME_BATCH_STEP_ACTIVITIES

Line 170: UPDATE gme_batch_step_activities

166: RAISE update_step_qty_error;
167: END IF;
168:
169: -- Remove the actual start date of the activities... set defaults; set WHO columns
170: UPDATE gme_batch_step_activities
171: SET actual_start_date = NULL
172: ,plan_activity_factor = NVL (plan_activity_factor, 0)
173: ,last_updated_by = gme_common_pvt.g_user_ident
174: ,last_update_date = gme_common_pvt.g_timestamp

Line 193: UPDATE gme_batch_step_activities

189: AND batch_id = x_batch_step_rec.batch_id;
190:
191: -- Update plan start date and plan completion date on activity and resources
192: -- to that on the step if they are NULL; who columns set above, no need again...
193: UPDATE gme_batch_step_activities
194: SET plan_start_date = x_batch_step_rec.plan_start_date
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;

Line 205: UPDATE gme_batch_step_activities

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;
204:
205: UPDATE gme_batch_step_activities
206: SET plan_cmplt_date = x_batch_step_rec.plan_cmplt_date
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;