APPS.GME_REVERT_BATCH_PVT dependencies on GME_BATCH_HEADER

Line 24: ( p_batch_header_rec IN GME_BATCH_HEADER%ROWTYPE

20: U - Unexpected error
21: =============================================================================================*/
22:
23: PROCEDURE revert_batch
24: ( p_batch_header_rec IN GME_BATCH_HEADER%ROWTYPE
25: , x_batch_header_rec OUT NOCOPY GME_BATCH_HEADER%ROWTYPE
26: , x_return_status OUT NOCOPY VARCHAR2) IS
27:
28: CURSOR Cur_lock_batch_materials (v_batch_id NUMBER) IS

Line 25: , x_batch_header_rec OUT NOCOPY GME_BATCH_HEADER%ROWTYPE

21: =============================================================================================*/
22:
23: PROCEDURE revert_batch
24: ( p_batch_header_rec IN GME_BATCH_HEADER%ROWTYPE
25: , x_batch_header_rec OUT NOCOPY GME_BATCH_HEADER%ROWTYPE
26: , x_return_status OUT NOCOPY VARCHAR2) IS
27:
28: CURSOR Cur_lock_batch_materials (v_batch_id NUMBER) IS
29: SELECT *

Line 43: l_batch_header_rec gme_batch_header%ROWTYPE;

39: ORDER BY line_no ;
40:
41: /* Buffers for database reads/writes */
42:
43: l_batch_header_rec gme_batch_header%ROWTYPE;
44: l_material_details_tab gme_common_pvt.material_details_tab ;
45:
46: /* Exception definitions */
47: BATCH_LINES_LOCKED EXCEPTION;

Line 138: IF NOT GME_BATCH_HEADER_DBL.update_row(l_batch_header_rec) THEN

134: /* Remove the actual completion date of the batch */
135: l_batch_header_rec.actual_cmplt_date := NULL;
136:
137: /* Update the batch header row to the database */
138: IF NOT GME_BATCH_HEADER_DBL.update_row(l_batch_header_rec) THEN
139: RAISE BATCH_HDR_UPDATE_ERROR;
140: END IF;
141: x_batch_header_rec := l_batch_header_rec ;
142: /* Update the row who columns */

Line 192: (p_batch_header_rec IN GME_BATCH_HEADER%ROWTYPE

188: U - Unexpected error
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:

Line 203: l_batch_header_rec gme_batch_header%ROWTYPE;

199: l_step_id NUMBER;
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;

Line 205: l_ph_batch_header_rec gme_batch_header%ROWTYPE;

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;
209: l_message_count NUMBER;

Line 244: IF NOT (GME_BATCH_HEADER_DBL.fetch_row(l_ph_batch_header_rec, l_ph_batch_header_rec)) THEN

240:
241: IF p_material_details_rec.line_type = -1 THEN
242: l_ph_batch_header_rec.batch_id := p_material_details_rec.phantom_id ;
243: /* Initialize output batch header */
244: IF NOT (GME_BATCH_HEADER_DBL.fetch_row(l_ph_batch_header_rec, l_ph_batch_header_rec)) THEN
245: RAISE BATCH_HEADER_FETCH_ERROR;
246: END IF;
247: -- revert_batch for phantom batch
248: IF (g_debug <= gme_debug.g_log_statement) THEN