APPS.GME_TERMINATE_BATCH_PVT dependencies on GME_BATCH_HEADER

Line 39: p_batch_header_rec IN gme_batch_header%ROWTYPE

35: 30-Mar-2010 G. Muratore Bug 9478698
36: Make call to GMO conditionally based on enhanced_pi_ind.
37: ================================================================================*/
38: PROCEDURE terminate_batch (
39: p_batch_header_rec IN gme_batch_header%ROWTYPE
40: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
41: ,x_return_status OUT NOCOPY VARCHAR2)
42: IS
43: /* Cursors */

Line 40: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

36: Make call to GMO conditionally based on enhanced_pi_ind.
37: ================================================================================*/
38: PROCEDURE terminate_batch (
39: p_batch_header_rec IN gme_batch_header%ROWTYPE
40: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
41: ,x_return_status OUT NOCOPY VARCHAR2)
42: IS
43: /* Cursors */
44: CURSOR cur_get_wip_steps (v_batch_id NUMBER)

Line 63: l_batch_header_rec gme_batch_header%ROWTYPE;

59:
60: /* Variable Declarations */
61: l_material_details gme_material_details%ROWTYPE;
62: l_material_details_tab gme_common_pvt.material_details_tab;
63: l_batch_header_rec gme_batch_header%ROWTYPE;
64: l_in_batch_header_rec gme_batch_header%ROWTYPE;
65: l_batch_step_rec gme_batch_steps%ROWTYPE;
66: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
67: l_batch_step_ids gme_common_pvt.number_tab;

Line 64: l_in_batch_header_rec gme_batch_header%ROWTYPE;

60: /* Variable Declarations */
61: l_material_details gme_material_details%ROWTYPE;
62: l_material_details_tab gme_common_pvt.material_details_tab;
63: l_batch_header_rec gme_batch_header%ROWTYPE;
64: l_in_batch_header_rec gme_batch_header%ROWTYPE;
65: l_batch_step_rec gme_batch_steps%ROWTYPE;
66: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
67: l_batch_step_ids gme_common_pvt.number_tab;
68: l_rsrc_trans_count NUMBER;

Line 159: IF NOT (gme_batch_header_dbl.fetch_row

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

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

327: || ':'
328: || 'Call BATCH UPDATE_ROW');
329: END IF;
330:
331: IF NOT (gme_batch_header_dbl.update_row (x_batch_header_rec) ) THEN
332: RAISE batch_header_upd_err;
333: END IF;
334:
335: /* Re-retrieve batch header */

Line 336: IF NOT (gme_batch_header_dbl.fetch_row

332: RAISE batch_header_upd_err;
333: END IF;
334:
335: /* Re-retrieve batch header */
336: IF NOT (gme_batch_header_dbl.fetch_row
337: (p_batch_header => p_batch_header_rec
338: ,x_batch_header => x_batch_header_rec) ) THEN
339: RAISE batch_header_fetch_error;
340: END IF;