APPS.GME_RESCHEDULE_STEP_PVT dependencies on GME_BATCH_STEPS_DBL

Line 271: IF NOT (gme_batch_steps_dbl.fetch_row (p_batch_step_rec

267: IF l_return_status <> x_return_status THEN
268: RAISE cal_dates_error;
269: END IF;
270:
271: IF NOT (gme_batch_steps_dbl.fetch_row (p_batch_step_rec
272: ,x_batch_step_rec) ) THEN
273: RAISE batch_step_fetch_error;
274: END IF;
275:

Line 301: IF NOT (gme_batch_steps_dbl.update_row (x_batch_step_rec) ) THEN

297: ,x_batch_step_rec.plan_cmplt_date) >
298: x_batch_step_rec.plan_cmplt_date THEN
299: x_batch_step_rec.plan_cmplt_date := p_batch_step_rec.plan_cmplt_date;
300:
301: IF NOT (gme_batch_steps_dbl.update_row (x_batch_step_rec) ) THEN
302: RAISE save_data_error;
303: END IF;
304: END IF;
305: --Bug#4543875 (port 4416699) Update the changed step due date in the procedure calc_dates with the original due date

Line 396: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_step_rec

392: l_batch_step_rec.batchstep_id :=
393: l_dep_step_rec.batchstep_id;
394: l_batch_step_rec.batch_id := p_batch_step_rec.batch_id;
395: -- Rework 4543875 Pawan Kumar added for fetching the data for succeding step
396: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_step_rec
397: ,l_batch_step_rec) ) THEN
398: RAISE batch_step_fetch_error;
399: END IF;
400: l_max_date :=

Line 495: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_step_rec

491: l_batch_step_rec.batchstep_id :=
492: l_dep_step_rec.batchstep_id;
493: l_batch_step_rec.batch_id := p_batch_step_rec.batch_id;
494: -- Rework 4543875 Pawan Kumar added for fetching the data for succeding step
495: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_step_rec
496: ,l_batch_step_rec) ) THEN
497: RAISE batch_step_fetch_error;
498: END IF;
499: /* Standard Delay should always be divided by 24 if used in date calculations */

Line 765: IF NOT (gme_batch_steps_dbl.fetch_row (p_batch_step_rec

761: END IF; /* recipe_validity_rule_id IS NOT NULL */
762: END IF; /* p_source_step_id_tbl.COUNT = 0 */
763:
764: /* Re-query output batch step row */
765: IF NOT (gme_batch_steps_dbl.fetch_row (p_batch_step_rec
766: ,x_batch_step_rec) ) THEN
767: RAISE batch_step_fetch_error;
768: END IF;
769:

Line 792: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_step2_rec

788: --Bug#5606089 Start. Added the following code.
789: /* SELECT batchstep_id INTO l_batch_step2_rec.batchstep_id FROM GME_BATCH_STEP_ITEMS
790: WHERE material_detail_id = l_material_detail_id_tbl(i);
791:
792: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_step2_rec
793: ,x_batch_step2_rec) ) THEN
794: RAISE batch_step_fetch_error;
795: END IF;*/
796: --Bug#5606089 End.

Line 811: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_step2_rec

807:
808: SELECT batchstep_id INTO l_batch_step2_rec.batchstep_id FROM GME_BATCH_STEP_ITEMS
809: WHERE material_detail_id = l_material_detail_id_tbl(i);
810:
811: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_step2_rec
812: ,x_batch_step2_rec) ) THEN
813: RAISE batch_step_fetch_error;
814: END IF;
815: -- pawan kumar end bug 5929323