APPS.GME_RESCHEDULE_STEP_PVT dependencies on GME_BATCH_STEPS_DBL

Line 265: IF NOT (gme_batch_steps_dbl.fetch_row (p_batch_step_rec

261: IF l_return_status <> x_return_status THEN
262: RAISE cal_dates_error;
263: END IF;
264:
265: IF NOT (gme_batch_steps_dbl.fetch_row (p_batch_step_rec
266: ,x_batch_step_rec) ) THEN
267: RAISE batch_step_fetch_error;
268: END IF;
269:

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

291: ,x_batch_step_rec.plan_cmplt_date) >
292: x_batch_step_rec.plan_cmplt_date THEN
293: x_batch_step_rec.plan_cmplt_date := p_batch_step_rec.plan_cmplt_date;
294:
295: IF NOT (gme_batch_steps_dbl.update_row (x_batch_step_rec) ) THEN
296: RAISE save_data_error;
297: END IF;
298: END IF;
299: --Bug#4543875 (port 4416699) Update the changed step due date in the procedure calc_dates with the original due date

Line 390: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_step_rec

386: l_batch_step_rec.batchstep_id :=
387: l_dep_step_rec.batchstep_id;
388: l_batch_step_rec.batch_id := p_batch_step_rec.batch_id;
389: -- Rework 4543875 Pawan Kumar added for fetching the data for succeding step
390: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_step_rec
391: ,l_batch_step_rec) ) THEN
392: RAISE batch_step_fetch_error;
393: END IF;
394: l_max_date :=

Line 489: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_step_rec

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

Line 759: IF NOT (gme_batch_steps_dbl.fetch_row (p_batch_step_rec

755: END IF; /* recipe_validity_rule_id IS NOT NULL */
756: END IF; /* p_source_step_id_tbl.COUNT = 0 */
757:
758: /* Re-query output batch step row */
759: IF NOT (gme_batch_steps_dbl.fetch_row (p_batch_step_rec
760: ,x_batch_step_rec) ) THEN
761: RAISE batch_step_fetch_error;
762: END IF;
763:

Line 786: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_step2_rec

782: --Bug#5606089 Start. Added the following code.
783: /* SELECT batchstep_id INTO l_batch_step2_rec.batchstep_id FROM GME_BATCH_STEP_ITEMS
784: WHERE material_detail_id = l_material_detail_id_tbl(i);
785:
786: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_step2_rec
787: ,x_batch_step2_rec) ) THEN
788: RAISE batch_step_fetch_error;
789: END IF;*/
790: --Bug#5606089 End.

Line 805: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_step2_rec

801:
802: SELECT batchstep_id INTO l_batch_step2_rec.batchstep_id FROM GME_BATCH_STEP_ITEMS
803: WHERE material_detail_id = l_material_detail_id_tbl(i);
804:
805: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_step2_rec
806: ,x_batch_step2_rec) ) THEN
807: RAISE batch_step_fetch_error;
808: END IF;
809: -- pawan kumar end bug 5929323