APPS.GME_REROUTE_BATCH_PVT dependencies on GME_BATCH_STEPS

Line 52: FROM gme_batch_steps

48:
49: CURSOR cur_get_max_step_date
50: IS
51: SELECT MAX (plan_cmplt_date)
52: FROM gme_batch_steps
53: WHERE batch_id = p_batch_header_rec.batch_id;
54:
55: CURSOR cur_get_material (v_batch_id NUMBER)
56: IS

Line 98: l_phantom_batch_step_rec gme_batch_steps%ROWTYPE;

94: l_plan_start_date DATE;
95: l_plan_cmplt_date DATE;
96: l_no_prod_rule_found BOOLEAN;
97: l_W_ReturnedAtLeastOnce BOOLEAN := FALSE;
98: l_phantom_batch_step_rec gme_batch_steps%ROWTYPE;
99: l_step_tbl gme_reschedule_step_pvt.step_tab;
100: x_batch_step_rec gme_batch_steps%ROWTYPE;
101: error_dbl EXCEPTION;
102: l_proc VARCHAR2(100);

Line 100: x_batch_step_rec gme_batch_steps%ROWTYPE;

96: l_no_prod_rule_found BOOLEAN;
97: l_W_ReturnedAtLeastOnce BOOLEAN := FALSE;
98: l_phantom_batch_step_rec gme_batch_steps%ROWTYPE;
99: l_step_tbl gme_reschedule_step_pvt.step_tab;
100: x_batch_step_rec gme_batch_steps%ROWTYPE;
101: error_dbl EXCEPTION;
102: l_proc VARCHAR2(100);
103: --FPBug#4585491
104: l_R_count NUMBER := 0;

Line 506: IF NOT gme_batch_steps_dbl.fetch_row(l_phantom_batch_step_rec, l_phantom_batch_step_rec) THEN

502: SELECT batchstep_id INTO l_phantom_batch_step_rec.batchstep_id
503: FROM gme_batch_step_items
504: WHERE batch_id = l_phantom_ids_tab (i)
505: AND material_detail_id = l_material_detail_rec.phantom_line_id;
506: IF NOT gme_batch_steps_dbl.fetch_row(l_phantom_batch_step_rec, l_phantom_batch_step_rec) THEN
507: l_proc := 'gme_batch_steps_dbl.fetch_row';
508: RAISE error_dbl;
509: END IF;
510: l_phantom_batch_step_rec.plan_cmplt_date:=l_material_detail_rec.material_requirement_date;

Line 507: l_proc := 'gme_batch_steps_dbl.fetch_row';

503: FROM gme_batch_step_items
504: WHERE batch_id = l_phantom_ids_tab (i)
505: AND material_detail_id = l_material_detail_rec.phantom_line_id;
506: IF NOT gme_batch_steps_dbl.fetch_row(l_phantom_batch_step_rec, l_phantom_batch_step_rec) THEN
507: l_proc := 'gme_batch_steps_dbl.fetch_row';
508: RAISE error_dbl;
509: END IF;
510: l_phantom_batch_step_rec.plan_cmplt_date:=l_material_detail_rec.material_requirement_date;
511: l_phantom_batch_step_rec.plan_start_date:=NULL;

Line 689: DELETE FROM gme_batch_steps

685:
686: DELETE FROM gme_batch_step_activities
687: WHERE batch_id = p_batch_id;
688:
689: DELETE FROM gme_batch_steps
690: WHERE batch_id = p_batch_id;
691:
692: IF (NVL (g_debug, 0) IN
693: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN