154: SELECT
155: gbs.last_update_date,
156: gbs.step_status
157: FROM
158: gme_batch_steps gbs
159: WHERE
160: gbs.batch_id = v_batch_id
161: AND gbs.batchstep_no = v_step_no;
162:
202: v_start_date := wip_datetimes.float_to_DT(pstart_date(i)/1440+phorizon);
203: v_end_date := wip_datetimes.float_to_DT(pend_date(i)/1440+phorizon);
204:
205: UPDATE
206: gme_batch_steps
207: SET
208: plan_start_date = v_start_date,
209: plan_cmplt_date = v_end_date,
210: last_update_date = SYSDATE,
334: SELECT
335: gsa.last_update_date,
336: gbs.step_status
337: FROM
338: gme_batch_steps gbs,
339: gme_batch_step_activities gsa
340: WHERE
341: gbs.batchstep_id = v_step_id
342: AND gbs.batchstep_id = gsa.batchstep_id
561: crd.resources,
562: gsr.usage_um,
563: gsr.batchstep_activity_id
564: FROM
565: gme_batch_steps gbs,
566: gme_batch_step_resources gsr,
567: cr_rsrc_dtl crd
568: WHERE
569: gbs.batchstep_id = v_step_id
1078: CURSOR lock_batch_steps IS
1079: SELECT
1080: batch_id
1081: FROM
1082: gme_batch_steps
1083: WHERE
1084: batch_id = v_batch_id
1085: FOR UPDATE NOWAIT;
1086: