APPS.GME_UNRELEASE_BATCH_PVT dependencies on GME_BATCH_HEADER

Line 24: p_batch_header_rec IN gme_batch_header%ROWTYPE

20: History
21:
22: =============================================================================================*/
23: PROCEDURE unrelease_batch (
24: p_batch_header_rec IN gme_batch_header%ROWTYPE
25: ,p_create_resv_pend_lots IN NUMBER
26: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
27: ,x_return_status OUT NOCOPY VARCHAR2)
28: IS

Line 26: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

22: =============================================================================================*/
23: PROCEDURE unrelease_batch (
24: p_batch_header_rec IN gme_batch_header%ROWTYPE
25: ,p_create_resv_pend_lots IN NUMBER
26: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
27: ,x_return_status OUT NOCOPY VARCHAR2)
28: IS
29: l_api_name CONSTANT VARCHAR2 (30) := 'unrelease_batch';
30:

Line 97: IF NOT gme_batch_header_dbl.update_row

93: -- set actual start date to NULL...
94: x_batch_header_rec.actual_start_date := NULL;
95:
96: -- Update the batch header
97: IF NOT gme_batch_header_dbl.update_row
98: (p_batch_header => x_batch_header_rec) THEN
99: RAISE error_update_row;
100: END IF;
101:

Line 232: l_phantom_batch_rec gme_batch_header%ROWTYPE;

228: ,p_from_batch IN BOOLEAN
229: ,x_return_status OUT NOCOPY VARCHAR2)
230: IS
231: l_api_name CONSTANT VARCHAR2 (30) := 'unrelease_material';
232: l_phantom_batch_rec gme_batch_header%ROWTYPE;
233: l_in_phantom_batch_rec gme_batch_header%ROWTYPE;
234: l_item_rec mtl_system_items_b%ROWTYPE;
235: l_material_detail_rec gme_material_details%ROWTYPE;
236:

Line 233: l_in_phantom_batch_rec gme_batch_header%ROWTYPE;

229: ,x_return_status OUT NOCOPY VARCHAR2)
230: IS
231: l_api_name CONSTANT VARCHAR2 (30) := 'unrelease_material';
232: l_phantom_batch_rec gme_batch_header%ROWTYPE;
233: l_in_phantom_batch_rec gme_batch_header%ROWTYPE;
234: l_item_rec mtl_system_items_b%ROWTYPE;
235: l_material_detail_rec gme_material_details%ROWTYPE;
236:
237: l_exception_material_tbl gme_common_pvt.exceptions_tab;

Line 265: IF NOT gme_batch_header_dbl.fetch_row (l_phantom_batch_rec

261: IF l_material_detail_rec.phantom_id IS NOT NULL THEN
262: -- phantom -> unrelease the phantom batch
263: l_phantom_batch_rec.batch_id := l_material_detail_rec.phantom_id;
264:
265: IF NOT gme_batch_header_dbl.fetch_row (l_phantom_batch_rec
266: ,l_phantom_batch_rec) THEN
267: RAISE error_fetch_batch;
268: END IF;
269:

Line 877: (p_batch_hdr_rec IN gme_batch_header%ROWTYPE

873: x_return_status := fnd_api.g_ret_sts_unexp_error;
874: END create_resv_pplot;
875:
876: PROCEDURE validate_batch_for_unrelease
877: (p_batch_hdr_rec IN gme_batch_header%ROWTYPE
878: ,x_return_status OUT NOCOPY VARCHAR2) IS
879:
880: l_api_name CONSTANT VARCHAR2 (30) := 'validate_batch_for_unrelease';
881: