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 139: IF NOT GME_BATCH_HEADER_DBL.update_row(l_batch_header_rec) THEN

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

Line 193: (p_batch_header_rec IN GME_BATCH_HEADER%ROWTYPE

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

Line 204: l_batch_header_rec gme_batch_header%ROWTYPE;

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

Line 206: l_ph_batch_header_rec gme_batch_header%ROWTYPE;

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

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

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