APPS.GME_UNRELEASE_BATCH_PVT dependencies on MTL_MATERIAL_TRANSACTIONS

Line 361: l_mmt_rec mtl_material_transactions%ROWTYPE;

357: ,x_return_status OUT NOCOPY VARCHAR2)
358: IS
359: l_api_name CONSTANT VARCHAR2 (30) := 'revert_material_full';
360: l_mmt_tbl gme_common_pvt.mtl_mat_tran_tbl;
361: l_mmt_rec mtl_material_transactions%ROWTYPE;
362: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
363: l_sequence NUMBER;
364: l_pplot_rec gme_pending_product_lots%ROWTYPE;
365: l_out_pplot_rec gme_pending_product_lots%ROWTYPE;

Line 558: l_mmt_rec mtl_material_transactions%ROWTYPE;

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;
562: l_api_name CONSTANT VARCHAR2 (30) := 'CREATE_MATL_RESV_PPLOT';

Line 559: l_new_mmt_rec mtl_material_transactions%ROWTYPE; -- Bug 6997483

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;
562: l_api_name CONSTANT VARCHAR2 (30) := 'CREATE_MATL_RESV_PPLOT';
563:

Line 569: FROM mtl_material_transactions mmt

565: l_new_transaction_id NUMBER;
566: CURSOR cur_get_transaction (v_transaction_id NUMBER)
567: IS
568: SELECT *
569: FROM mtl_material_transactions mmt
570: WHERE transaction_id = v_transaction_id;
571: BEGIN
572: IF (NVL (g_debug, 0) IN (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
573: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':' || 'Entering');

Line 646: ,p_mmt_rec IN mtl_material_transactions%ROWTYPE

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
650: l_api_name CONSTANT VARCHAR2 (30) := 'create_resv_pplot';

Line 652: l_mmt_rec mtl_material_transactions%ROWTYPE;

648: ,x_return_status OUT NOCOPY VARCHAR2)
649: IS
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;

Line 843: FUNCTION check_inv_negative(p_mmt_rec IN mtl_material_transactions%ROWTYPE,

839: x_return_status := fnd_api.g_ret_sts_unexp_error;
840: END validate_batch_for_unrelease;
841:
842: /* Bug 5021522 added function RETURNS TRUE if inv will go negative and org control does not allow it */
843: FUNCTION check_inv_negative(p_mmt_rec IN mtl_material_transactions%ROWTYPE,
844: p_mmln_tbl IN gme_common_pvt.mtl_trans_lots_num_tbl,
845: p_org_neg_control IN NUMBER DEFAULT gme_common_pvt.g_allow_neg_inv,
846: p_item_no IN VARCHAR2) RETURN BOOLEAN IS
847: l_api_name CONSTANT VARCHAR2(30) := 'check_inv_negative';