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 225: p_material_detail_rec IN gme_material_details%ROWTYPE

221: x_return_status := fnd_api.g_ret_sts_unexp_error;
222: END unrelease_batch;
223:
224: PROCEDURE unrelease_material (
225: p_material_detail_rec IN gme_material_details%ROWTYPE
226: ,p_update_inventory_ind IN VARCHAR2
227: ,p_create_resv_pend_lots IN NUMBER
228: ,p_from_batch IN BOOLEAN
229: ,x_return_status OUT NOCOPY VARCHAR2)

Line 235: l_material_detail_rec gme_material_details%ROWTYPE;

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;
238: l_actual_qty NUMBER;
239:

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

332: IF p_from_batch THEN
333: l_material_detail_rec.wip_plan_qty := NULL;
334: END IF;
335:
336: IF NOT gme_material_details_dbl.update_row (l_material_detail_rec) THEN
337: RAISE error_update_row;
338: END IF;
339:
340: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=

Line 367: p_material_detail_rec IN gme_material_details%ROWTYPE

363: x_return_status := fnd_api.g_ret_sts_unexp_error;
364: END unrelease_material;
365:
366: PROCEDURE revert_material_full (
367: p_material_detail_rec IN gme_material_details%ROWTYPE
368: ,p_create_resv_pend_lots IN NUMBER
369: ,p_ignore_transactable IN BOOLEAN DEFAULT FALSE
370: ,x_actual_qty OUT NOCOPY NUMBER
371: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab

Line 666: l_mat_dtl_rec gme_material_details%ROWTYPE;

662: p_material_dtl_id IN NUMBER,
663: p_transaction_id IN NUMBER,
664: x_return_status OUT NOCOPY VARCHAR2)
665: IS
666: l_mat_dtl_rec gme_material_details%ROWTYPE;
667: l_mmt_rec mtl_material_transactions%ROWTYPE;
668: l_new_mmt_rec mtl_material_transactions%ROWTYPE; -- Bug 6997483
669: l_mmln_rec gme_common_pvt.mtl_trans_lots_num_tbl;
670: l_trans_hdr_id NUMBER;

Line 708: IF NOT gme_material_details_dbl.fetch_row

704: END IF;
705:
706: l_mat_dtl_rec.material_detail_id := gme_common_pvt.g_mat_txn_hdr_tbl(cnt).material_dtl_id;
707:
708: IF NOT gme_material_details_dbl.fetch_row
709: (p_material_detail => l_mat_dtl_rec
710: ,x_material_detail => l_mat_dtl_rec) THEN
711: RAISE fnd_api.g_exc_error;
712: END IF;

Line 753: p_material_detail_rec IN gme_material_details%ROWTYPE

749: END IF;
750: END create_matl_resv_pplot;
751:
752: PROCEDURE create_resv_pplot (
753: p_material_detail_rec IN gme_material_details%ROWTYPE
754: ,p_mmt_rec IN mtl_material_transactions%ROWTYPE
755: ,p_mmln_tbl IN gme_common_pvt.mtl_trans_lots_num_tbl
756: ,x_return_status OUT NOCOPY VARCHAR2)
757: IS

Line 762: l_material_detail_rec gme_material_details%ROWTYPE;

758: l_api_name CONSTANT VARCHAR2 (30) := 'create_resv_pplot';
759:
760: l_mmt_rec mtl_material_transactions%ROWTYPE;
761: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
762: l_material_detail_rec gme_material_details%ROWTYPE;
763:
764: l_sequence NUMBER;
765: l_pplot_rec gme_pending_product_lots%ROWTYPE;
766: l_out_pplot_rec gme_pending_product_lots%ROWTYPE;