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 194: ,p_material_details_rec IN gme_material_details%ROWTYPE

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

Line 205: l_material_details_rec gme_material_details%ROWTYPE;

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

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

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