APPS.GME_UNRELEASE_STEP_PVT dependencies on GME_MATERIAL_DETAILS

Line 37: FROM gme_batch_step_items i, gme_material_details d

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

Line 55: l_material_detail_rec gme_material_details%ROWTYPE;

51: l_enhanced_pi_ind VARCHAR2(1);
52:
53: l_api_name CONSTANT VARCHAR2 (30) := 'unrelease_step';
54: l_material_detail_tbl gme_common_pvt.material_details_tab;
55: l_material_detail_rec gme_material_details%ROWTYPE;
56: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
57: l_msg_count NUMBER;
58: l_msg_stack VARCHAR2 (2000);
59: l_lock_status VARCHAR2(1);