APPS.GME_INCREMENTAL_BACKFLUSH_PVT dependencies on GME_BATCH_STEPS

Line 85: FROM gme_batch_steps

81: ORDER BY line_type,line_no;
82:
83: CURSOR Cur_assoc_step(v_batch_id NUMBER) IS
84: SELECT *
85: FROM gme_batch_steps
86: WHERE batchstep_id IN (SELECT DISTINCT batchstep_id
87: FROM gme_batch_step_items
88: WHERE batch_id = v_batch_id);
89:

Line 92: FROM gme_batch_step_items m, gme_batch_steps s

88: WHERE batch_id = v_batch_id);
89:
90: CURSOR Cur_prod_assoc(V_batch_id NUMBER, V_material_detail_id NUMBER) IS
91: SELECT s.*
92: FROM gme_batch_step_items m, gme_batch_steps s
93: WHERE m.batch_id = V_batch_id
94: AND m.material_detail_id = V_material_detail_id
95: AND s.batch_id = m.batch_id
96: AND s.batchstep_id = m.batchstep_id

Line 114: l_batch_step_rec gme_batch_steps%ROWTYPE;

110: l_in_material_detail_rec gme_material_details%ROWTYPE;
111: l_phantom_material_rec gme_material_details%ROWTYPE;
112: l_material_detail_tbl gme_common_pvt.material_details_tab;
113:
114: l_batch_step_rec gme_batch_steps%ROWTYPE;
115: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
116: l_step_tbl gme_common_pvt.steps_tab;
117:
118: l_incr_qty NUMBER;

Line 115: l_in_batch_step_rec gme_batch_steps%ROWTYPE;

111: l_phantom_material_rec gme_material_details%ROWTYPE;
112: l_material_detail_tbl gme_common_pvt.material_details_tab;
113:
114: l_batch_step_rec gme_batch_steps%ROWTYPE;
115: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
116: l_step_tbl gme_common_pvt.steps_tab;
117:
118: l_incr_qty NUMBER;
119: l_decr_qty NUMBER;

Line 731: FROM gme_batch_step_dependencies d, gme_batch_steps s

727: l_api_name CONSTANT VARCHAR2 (30) := 'update_dependent_steps';
728:
729: CURSOR Cur_prev_steps(V_batchstep_id NUMBER) IS
730: SELECT d.dep_step_id, d.dep_type, s.step_status
731: FROM gme_batch_step_dependencies d, gme_batch_steps s
732: WHERE d.batchstep_id = V_batchstep_id
733: AND s.batchstep_id = d.dep_step_id;
734:
735: l_batch_step_rec GME_BATCH_STEPS%ROWTYPE;

Line 735: l_batch_step_rec GME_BATCH_STEPS%ROWTYPE;

731: FROM gme_batch_step_dependencies d, gme_batch_steps s
732: WHERE d.batchstep_id = V_batchstep_id
733: AND s.batchstep_id = d.dep_step_id;
734:
735: l_batch_step_rec GME_BATCH_STEPS%ROWTYPE;
736: l_in_batch_step_rec GME_BATCH_STEPS%ROWTYPE;
737:
738: l_message_count NUMBER;
739: l_backflush_factor NUMBER;

Line 736: l_in_batch_step_rec GME_BATCH_STEPS%ROWTYPE;

732: WHERE d.batchstep_id = V_batchstep_id
733: AND s.batchstep_id = d.dep_step_id;
734:
735: l_batch_step_rec GME_BATCH_STEPS%ROWTYPE;
736: l_in_batch_step_rec GME_BATCH_STEPS%ROWTYPE;
737:
738: l_message_count NUMBER;
739: l_backflush_factor NUMBER;
740: l_message_list VARCHAR2(2000);

Line 1457: FROM gme_batch_steps s, gme_batch_step_items i

1453: l_step_status NUMBER;
1454:
1455: CURSOR cur_get_step_status(v_material_detail_id NUMBER) IS
1456: SELECT s.batchstep_no, step_status
1457: FROM gme_batch_steps s, gme_batch_step_items i
1458: WHERE s.batchstep_id = i.batchstep_id
1459: AND i.material_detail_id = v_material_detail_id;
1460:
1461: ERROR_INV_ACTION_FPO EXCEPTION;