APPS.GME_REVERT_BATCH_PVT dependencies on GME_MATERIAL_DETAILS

Line 7: G_table_name VARCHAR2(80) DEFAULT 'GME_MATERIAL_DETAILS';

3:
4: G_DEBUG VARCHAR2(5) := FND_PROFILE.VALUE('AFLOG_LEVEL');
5:
6: /* Global Variables */
7: G_table_name VARCHAR2(80) DEFAULT 'GME_MATERIAL_DETAILS';
8: g_pkg_name CONSTANT VARCHAR2(30) := 'GME_REVERT_BATCH';
9:
10: /*===========================================================================================
11: Procedure

Line 30: FROM gme_material_details

26: , x_return_status OUT NOCOPY VARCHAR2) IS
27:
28: CURSOR Cur_lock_batch_materials (v_batch_id NUMBER) IS
29: SELECT *
30: FROM gme_material_details
31: WHERE batch_id = v_batch_id
32: FOR UPDATE OF actual_qty NOWAIT;
33: CURSOR Cur_revert_materials (v_batch_id NUMBER) IS
34: SELECT *

Line 35: FROM gme_material_details

31: WHERE batch_id = v_batch_id
32: FOR UPDATE OF actual_qty NOWAIT;
33: CURSOR Cur_revert_materials (v_batch_id NUMBER) IS
34: SELECT *
35: FROM gme_material_details
36: WHERE batch_id = v_batch_id
37: AND ((line_type = -1 AND phantom_id IS NOT NULL) OR
38: (line_type <> -1 AND phantom_line_id IS NULL ))
39: ORDER BY line_no ;

Line 193: ,p_material_details_rec IN gme_material_details%ROWTYPE

189: =============================================================================================*/
190:
191: PROCEDURE revert_line
192: (p_batch_header_rec IN GME_BATCH_HEADER%ROWTYPE
193: ,p_material_details_rec IN gme_material_details%ROWTYPE
194: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
195: ,x_return_status OUT NOCOPY VARCHAR2)IS
196:
197: /* Local variable definitions */

Line 204: l_material_details_rec gme_material_details%ROWTYPE;

200: l_step_date DATE;
201: l_api_name CONSTANT VARCHAR2 (30) := 'revert_line';
202: l_rel_type NUMBER;
203: l_batch_header_rec gme_batch_header%ROWTYPE;
204: l_material_details_rec gme_material_details%ROWTYPE;
205: l_ph_batch_header_rec gme_batch_header%ROWTYPE;
206: l_batch_step_rec gme_batch_steps%ROWTYPE;
207: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
208: l_rsrc_trans_count NUMBER;

Line 286: IF NOT GME_MATERIAL_DETAILS_DBL.update_row (l_material_details_rec) THEN

282: /* Default the actual qty to zero */
283: l_material_details_rec.actual_qty := 0;
284:
285: /* Update the material detail row to the database */
286: IF NOT GME_MATERIAL_DETAILS_DBL.update_row (l_material_details_rec) THEN
287: RAISE ERROR_UPD_MATERIAL_DETAIL;
288: END IF;
289: IF l_batch_header_rec.POC_IND= 'Y' THEN
290: IF l_batch_header_rec.automatic_step_calculation = 1 THEN