APPS.GME_UNRELEASE_STEP_PVT dependencies on GME_MATERIAL_DETAILS

Line 34: FROM gme_batch_step_items i, gme_material_details d

30: v_batch_id gme_batch_header.batch_id%TYPE
31: ,v_batchstep_id gme_batch_steps.batchstep_id%TYPE)
32: IS
33: SELECT d.*
34: FROM gme_batch_step_items i, gme_material_details d
35: WHERE d.batch_id = v_batch_id
36: AND d.material_detail_id = i.material_detail_id
37: AND i.batchstep_id = v_batchstep_id
38: AND d.release_type = gme_common_pvt.g_mtl_autobystep_release;

Line 42: l_material_detail_rec gme_material_details%ROWTYPE;

38: AND d.release_type = gme_common_pvt.g_mtl_autobystep_release;
39:
40: l_api_name CONSTANT VARCHAR2 (30) := 'unrelease_step';
41: l_material_detail_tbl gme_common_pvt.material_details_tab;
42: l_material_detail_rec gme_material_details%ROWTYPE;
43: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
44: l_msg_count NUMBER;
45: l_msg_stack VARCHAR2 (2000);
46: l_lock_status VARCHAR2(1);