APPS.GME_TERMINATE_BATCH_PVT dependencies on GME_BATCH_HEADER

Line 35: p_batch_header_rec IN gme_batch_header%ROWTYPE

31: E - Error
32: U - Unexpected error
33: ================================================================================*/
34: PROCEDURE terminate_batch (
35: p_batch_header_rec IN gme_batch_header%ROWTYPE
36: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
37: ,x_return_status OUT NOCOPY VARCHAR2)
38: IS
39: /* Cursors */

Line 36: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

32: U - Unexpected error
33: ================================================================================*/
34: PROCEDURE terminate_batch (
35: p_batch_header_rec IN gme_batch_header%ROWTYPE
36: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
37: ,x_return_status OUT NOCOPY VARCHAR2)
38: IS
39: /* Cursors */
40: CURSOR cur_get_wip_steps (v_batch_id NUMBER)

Line 59: l_batch_header_rec gme_batch_header%ROWTYPE;

55:
56: /* Variable Declarations */
57: l_material_details gme_material_details%ROWTYPE;
58: l_material_details_tab gme_common_pvt.material_details_tab;
59: l_batch_header_rec gme_batch_header%ROWTYPE;
60: l_in_batch_header_rec gme_batch_header%ROWTYPE;
61: l_batch_step_rec gme_batch_steps%ROWTYPE;
62: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
63: l_batch_step_ids gme_common_pvt.number_tab;

Line 60: l_in_batch_header_rec gme_batch_header%ROWTYPE;

56: /* Variable Declarations */
57: l_material_details gme_material_details%ROWTYPE;
58: l_material_details_tab gme_common_pvt.material_details_tab;
59: l_batch_header_rec gme_batch_header%ROWTYPE;
60: l_in_batch_header_rec gme_batch_header%ROWTYPE;
61: l_batch_step_rec gme_batch_steps%ROWTYPE;
62: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
63: l_batch_step_ids gme_common_pvt.number_tab;
64: l_rsrc_trans_count NUMBER;

Line 155: IF NOT (gme_batch_header_dbl.fetch_row

151: IF (NVL (l_material_details_tab (i).phantom_id, 0) <> 0) THEN
152: l_batch_header_rec.batch_id :=
153: l_material_details_tab (i).phantom_id;
154:
155: IF NOT (gme_batch_header_dbl.fetch_row
156: (p_batch_header => l_batch_header_rec
157: ,x_batch_header => l_in_batch_header_rec) ) THEN
158: RAISE batch_header_fetch_error;
159: END IF;

Line 320: IF NOT (gme_batch_header_dbl.update_row (x_batch_header_rec) ) THEN

316: || ':'
317: || 'Call BATCH UPDATE_ROW');
318: END IF;
319:
320: IF NOT (gme_batch_header_dbl.update_row (x_batch_header_rec) ) THEN
321: RAISE batch_header_upd_err;
322: END IF;
323:
324: /* Re-retrieve batch header */

Line 325: IF NOT (gme_batch_header_dbl.fetch_row

321: RAISE batch_header_upd_err;
322: END IF;
323:
324: /* Re-retrieve batch header */
325: IF NOT (gme_batch_header_dbl.fetch_row
326: (p_batch_header => p_batch_header_rec
327: ,x_batch_header => x_batch_header_rec) ) THEN
328: RAISE batch_header_fetch_error;
329: END IF;