APPS.GME_CANCEL_BATCH_PVT dependencies on GME_BATCH_HEADER

Line 64: p_batch_header_rec IN gme_batch_header%ROWTYPE

60: G. Muratore 10-JAN-2013 Bug 16031581
61: Load resource transactions into memory so that they get reversed.
62: ================================================================================*/
63: PROCEDURE cancel_batch (
64: p_batch_header_rec IN gme_batch_header%ROWTYPE
65: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
66: ,x_return_status OUT NOCOPY VARCHAR2)
67: IS
68: CURSOR cur_get_steps (v_batch_id NUMBER)

Line 65: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

61: Load resource transactions into memory so that they get reversed.
62: ================================================================================*/
63: PROCEDURE cancel_batch (
64: p_batch_header_rec IN gme_batch_header%ROWTYPE
65: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
66: ,x_return_status OUT NOCOPY VARCHAR2)
67: IS
68: CURSOR cur_get_steps (v_batch_id NUMBER)
69: IS

Line 84: l_batch_header_rec gme_batch_header%ROWTYPE;

80: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
81: l_material_details_rec gme_material_details%ROWTYPE;
82: l_material_details_tab gme_common_pvt.material_details_tab;
83: l_batch_step_tab gme_common_pvt.steps_tab;
84: l_batch_header_rec gme_batch_header%ROWTYPE;
85: l_ph_batch_header_rec gme_batch_header%ROWTYPE;
86: l_rsrc_trans_count NUMBER;
87: l_message_count NUMBER; -- 4944024
88: l_message_data VARCHAR2(2000); -- 4944024

Line 85: l_ph_batch_header_rec gme_batch_header%ROWTYPE;

81: l_material_details_rec gme_material_details%ROWTYPE;
82: l_material_details_tab gme_common_pvt.material_details_tab;
83: l_batch_step_tab gme_common_pvt.steps_tab;
84: l_batch_header_rec gme_batch_header%ROWTYPE;
85: l_ph_batch_header_rec gme_batch_header%ROWTYPE;
86: l_rsrc_trans_count NUMBER;
87: l_message_count NUMBER; -- 4944024
88: l_message_data VARCHAR2(2000); -- 4944024
89: l_return_status VARCHAR2 (1);

Line 183: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec

179:
180: -- Recursive call to the private API.
181: l_batch_header_rec.batch_id :=
182: l_material_details_tab (i).phantom_id;
183: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec
184: ,l_ph_batch_header_rec) ) THEN
185: RAISE batch_header_fetch_failure;
186: END IF;
187:

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

326: || 'Call batch UPDATE_ROW'
327: || x_batch_header_rec.batch_status);
328: END IF;
329:
330: IF NOT (gme_batch_header_dbl.update_row (x_batch_header_rec) ) THEN
331: RAISE batch_header_upd_err;
332: END IF;
333:
334: IF x_batch_header_rec.update_inventory_ind = 'Y' THEN

Line 471: p_batch_header_rec IN gme_batch_header%ROWTYPE

467:
468:
469:
470: PROCEDURE purge_batch_exceptions (
471: p_batch_header_rec IN gme_batch_header%ROWTYPE
472: ,p_delete_invis_mo IN VARCHAR2 := 'F'
473: ,p_delete_reservations IN VARCHAR2 := 'F'
474: ,p_delete_trans_pairs IN VARCHAR2 := 'F'
475: ,p_recursive IN VARCHAR2 := 'N'

Line 481: l_batch_header_rec gme_batch_header%ROWTYPE;

477: IS
478:
479: l_material_details_rec gme_material_details%ROWTYPE;
480: l_material_details_tab gme_common_pvt.material_details_tab;
481: l_batch_header_rec gme_batch_header%ROWTYPE;
482: l_ph_batch_header_rec gme_batch_header%ROWTYPE;
483: l_api_name CONSTANT VARCHAR2 (30) := 'purge_batch_exceptions';
484: delete_reservations_err EXCEPTION;
485: delete_move_order_err EXCEPTION;

Line 482: l_ph_batch_header_rec gme_batch_header%ROWTYPE;

478:
479: l_material_details_rec gme_material_details%ROWTYPE;
480: l_material_details_tab gme_common_pvt.material_details_tab;
481: l_batch_header_rec gme_batch_header%ROWTYPE;
482: l_ph_batch_header_rec gme_batch_header%ROWTYPE;
483: l_api_name CONSTANT VARCHAR2 (30) := 'purge_batch_exceptions';
484: delete_reservations_err EXCEPTION;
485: delete_move_order_err EXCEPTION;
486: delete_trans_pair_err EXCEPTION;

Line 572: IF NOT (gme_batch_header_dbl.fetch_row (l_ph_batch_header_rec

568:
569: -- Recursive call to the private API.
570: l_ph_batch_header_rec.batch_id :=
571: l_material_details_tab (i).phantom_id;
572: IF NOT (gme_batch_header_dbl.fetch_row (l_ph_batch_header_rec
573: ,l_ph_batch_header_rec) ) THEN
574: RAISE batch_header_fetch_failure;
575: END IF;
576: