APPS.GME_UNRELEASE_BATCH_PVT dependencies on GME_BATCH_STEPS

Line 34: FROM gme_batch_steps

30:
31: CURSOR cur_get_steps (v_batch_id NUMBER)
32: IS
33: SELECT *
34: FROM gme_batch_steps
35: WHERE batch_id = v_batch_id;
36:
37: CURSOR cur_get_and_lock_mtls (v_batch_id NUMBER)
38: IS

Line 47: l_batch_step_rec gme_batch_steps%ROWTYPE;

43:
44: l_material_detail_tbl gme_common_pvt.material_details_tab;
45: l_material_detail_rec gme_material_details%ROWTYPE;
46: l_batch_step_tbl gme_common_pvt.steps_tab;
47: l_batch_step_rec gme_batch_steps%ROWTYPE;
48: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
49:
50: error_update_row EXCEPTION;
51: error_unrelease_matl EXCEPTION;

Line 48: l_in_batch_step_rec gme_batch_steps%ROWTYPE;

44: l_material_detail_tbl gme_common_pvt.material_details_tab;
45: l_material_detail_rec gme_material_details%ROWTYPE;
46: l_batch_step_tbl gme_common_pvt.steps_tab;
47: l_batch_step_rec gme_batch_steps%ROWTYPE;
48: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
49:
50: error_update_row EXCEPTION;
51: error_unrelease_matl EXCEPTION;
52: error_unrelease_step EXCEPTION;

Line 136: IF (gme_batch_steps_dbl.fetch_row (l_batch_step_rec, l_in_batch_step_rec)) THEN

132: -- l_in_batch_step_rec := l_batch_step_rec;
133:
134: -- 8672422 - We need to refetch step here and make sure it's not already processed
135: -- as unrelease step also processes dependent steps.
136: IF (gme_batch_steps_dbl.fetch_row (l_batch_step_rec, l_in_batch_step_rec)) THEN
137: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
138: gme_debug.put_line ('In DB date is '||TO_CHAR(l_in_batch_step_rec.last_update_date, 'DD-MON-YYYY HH24:MI:SS'));
139: gme_debug.put_line ('In step status is '||l_in_batch_step_rec.step_status);
140: END IF;

Line 884: FROM gme_batch_steps

880: l_api_name CONSTANT VARCHAR2 (30) := 'validate_batch_for_unrelease';
881:
882: CURSOR cur_is_step_status_valid (v_batch_id NUMBER) IS
883: SELECT count(1)
884: FROM gme_batch_steps
885: WHERE step_status NOT IN (gme_common_pvt.g_step_pending, gme_common_pvt.g_step_wip)
886: AND batch_id = v_batch_id;
887:
888: l_is_step_status_valid NUMBER;