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 217: l_phantom_batch_rec gme_batch_header%ROWTYPE;

213: ,p_from_batch IN BOOLEAN
214: ,x_return_status OUT NOCOPY VARCHAR2)
215: IS
216: l_api_name CONSTANT VARCHAR2 (30) := 'unrelease_material';
217: l_phantom_batch_rec gme_batch_header%ROWTYPE;
218: l_in_phantom_batch_rec gme_batch_header%ROWTYPE;
219: l_item_rec mtl_system_items_b%ROWTYPE;
220: l_material_detail_rec gme_material_details%ROWTYPE;
221:

Line 218: l_in_phantom_batch_rec gme_batch_header%ROWTYPE;

214: ,x_return_status OUT NOCOPY VARCHAR2)
215: IS
216: l_api_name CONSTANT VARCHAR2 (30) := 'unrelease_material';
217: l_phantom_batch_rec gme_batch_header%ROWTYPE;
218: l_in_phantom_batch_rec gme_batch_header%ROWTYPE;
219: l_item_rec mtl_system_items_b%ROWTYPE;
220: l_material_detail_rec gme_material_details%ROWTYPE;
221:
222: l_exception_material_tbl gme_common_pvt.exceptions_tab;

Line 250: IF NOT gme_batch_header_dbl.fetch_row (l_phantom_batch_rec

246: IF l_material_detail_rec.phantom_id IS NOT NULL THEN
247: -- phantom -> unrelease the phantom batch
248: l_phantom_batch_rec.batch_id := l_material_detail_rec.phantom_id;
249:
250: IF NOT gme_batch_header_dbl.fetch_row (l_phantom_batch_rec
251: ,l_phantom_batch_rec) THEN
252: RAISE error_fetch_batch;
253: END IF;
254:

Line 768: (p_batch_hdr_rec IN gme_batch_header%ROWTYPE

764: x_return_status := fnd_api.g_ret_sts_unexp_error;
765: END create_resv_pplot;
766:
767: PROCEDURE validate_batch_for_unrelease
768: (p_batch_hdr_rec IN gme_batch_header%ROWTYPE
769: ,x_return_status OUT NOCOPY VARCHAR2) IS
770:
771: l_api_name CONSTANT VARCHAR2 (30) := 'validate_batch_for_unrelease';
772: