APPS.GME_UNRELEASE_BATCH_PVT dependencies on GME_MATERIAL_DETAILS

Line 40: FROM gme_material_details

36:
37: CURSOR cur_get_and_lock_mtls (v_batch_id NUMBER)
38: IS
39: SELECT *
40: FROM gme_material_details
41: WHERE batch_id = v_batch_id
42: FOR UPDATE OF actual_qty NOWAIT;
43:
44: l_material_detail_tbl gme_common_pvt.material_details_tab;

Line 45: l_material_detail_rec gme_material_details%ROWTYPE;

41: WHERE batch_id = v_batch_id
42: FOR UPDATE OF actual_qty NOWAIT;
43:
44: l_material_detail_tbl gme_common_pvt.material_details_tab;
45: l_material_detail_rec gme_material_details%ROWTYPE;
46: l_batch_step_tbl gme_common_pvt.steps_tab;
47: l_batch_step_rec gme_batch_steps%ROWTYPE;
48: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
49:

Line 210: p_material_detail_rec IN gme_material_details%ROWTYPE

206: x_return_status := fnd_api.g_ret_sts_unexp_error;
207: END unrelease_batch;
208:
209: PROCEDURE unrelease_material (
210: p_material_detail_rec IN gme_material_details%ROWTYPE
211: ,p_update_inventory_ind IN VARCHAR2
212: ,p_create_resv_pend_lots IN NUMBER
213: ,p_from_batch IN BOOLEAN
214: ,x_return_status OUT NOCOPY VARCHAR2)

Line 220: l_material_detail_rec gme_material_details%ROWTYPE;

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;
223: l_actual_qty NUMBER;
224:

Line 321: IF NOT gme_material_details_dbl.update_row (l_material_detail_rec) THEN

317: IF p_from_batch THEN
318: l_material_detail_rec.wip_plan_qty := NULL;
319: END IF;
320:
321: IF NOT gme_material_details_dbl.update_row (l_material_detail_rec) THEN
322: RAISE error_update_row;
323: END IF;
324:
325: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=

Line 352: p_material_detail_rec IN gme_material_details%ROWTYPE

348: x_return_status := fnd_api.g_ret_sts_unexp_error;
349: END unrelease_material;
350:
351: PROCEDURE revert_material_full (
352: p_material_detail_rec IN gme_material_details%ROWTYPE
353: ,p_create_resv_pend_lots IN NUMBER
354: ,p_ignore_transactable IN BOOLEAN DEFAULT FALSE
355: ,x_actual_qty OUT NOCOPY NUMBER
356: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab

Line 557: l_mat_dtl_rec gme_material_details%ROWTYPE;

553: p_material_dtl_id IN NUMBER,
554: p_transaction_id IN NUMBER,
555: x_return_status OUT NOCOPY VARCHAR2)
556: IS
557: l_mat_dtl_rec gme_material_details%ROWTYPE;
558: l_mmt_rec mtl_material_transactions%ROWTYPE;
559: l_new_mmt_rec mtl_material_transactions%ROWTYPE; -- Bug 6997483
560: l_mmln_rec gme_common_pvt.mtl_trans_lots_num_tbl;
561: l_trans_hdr_id NUMBER;

Line 600: IF NOT gme_material_details_dbl.fetch_row

596: END IF;
597:
598: l_mat_dtl_rec.material_detail_id := gme_common_pvt.g_mat_txn_hdr_tbl(cnt).material_dtl_id;
599:
600: IF NOT gme_material_details_dbl.fetch_row
601: (p_material_detail => l_mat_dtl_rec
602: ,x_material_detail => l_mat_dtl_rec) THEN
603: RAISE fnd_api.g_exc_error;
604: END IF;

Line 645: p_material_detail_rec IN gme_material_details%ROWTYPE

641: END IF;
642: END create_matl_resv_pplot;
643:
644: PROCEDURE create_resv_pplot (
645: p_material_detail_rec IN gme_material_details%ROWTYPE
646: ,p_mmt_rec IN mtl_material_transactions%ROWTYPE
647: ,p_mmln_tbl IN gme_common_pvt.mtl_trans_lots_num_tbl
648: ,x_return_status OUT NOCOPY VARCHAR2)
649: IS

Line 654: l_material_detail_rec gme_material_details%ROWTYPE;

650: l_api_name CONSTANT VARCHAR2 (30) := 'create_resv_pplot';
651:
652: l_mmt_rec mtl_material_transactions%ROWTYPE;
653: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
654: l_material_detail_rec gme_material_details%ROWTYPE;
655:
656: l_sequence NUMBER;
657: l_pplot_rec gme_pending_product_lots%ROWTYPE;
658: l_out_pplot_rec gme_pending_product_lots%ROWTYPE;