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 775: FROM gme_batch_steps

771: l_api_name CONSTANT VARCHAR2 (30) := 'validate_batch_for_unrelease';
772:
773: CURSOR cur_is_step_status_valid (v_batch_id NUMBER) IS
774: SELECT count(1)
775: FROM gme_batch_steps
776: WHERE step_status NOT IN (gme_common_pvt.g_step_pending, gme_common_pvt.g_step_wip)
777: AND batch_id = v_batch_id;
778:
779: l_is_step_status_valid NUMBER;