APPS.GME_UNRELEASE_BATCH_PVT dependencies on MTL_MATERIAL_TRANSACTIONS

Line 376: l_mmt_rec mtl_material_transactions%ROWTYPE;

372: ,x_return_status OUT NOCOPY VARCHAR2)
373: IS
374: l_api_name CONSTANT VARCHAR2 (30) := 'revert_material_full';
375: l_mmt_tbl gme_common_pvt.mtl_mat_tran_tbl;
376: l_mmt_rec mtl_material_transactions%ROWTYPE;
377: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
378: l_sequence NUMBER;
379: l_pplot_rec gme_pending_product_lots%ROWTYPE;
380: l_out_pplot_rec gme_pending_product_lots%ROWTYPE;

Line 667: l_mmt_rec mtl_material_transactions%ROWTYPE;

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

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

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;
671: l_api_name CONSTANT VARCHAR2 (30) := 'CREATE_MATL_RESV_PPLOT';
672: -- Bug 6997483

Line 677: FROM mtl_material_transactions mmt

673: l_new_transaction_id NUMBER;
674: CURSOR cur_get_transaction (v_transaction_id NUMBER)
675: IS
676: SELECT *
677: FROM mtl_material_transactions mmt
678: WHERE transaction_id = v_transaction_id;
679: BEGIN
680: IF (NVL (g_debug, 0) IN (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
681: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':' || 'Entering');

Line 754: ,p_mmt_rec IN mtl_material_transactions%ROWTYPE

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

Line 760: l_mmt_rec mtl_material_transactions%ROWTYPE;

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

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

948: x_return_status := fnd_api.g_ret_sts_unexp_error;
949: END validate_batch_for_unrelease;
950:
951: /* Bug 5021522 added function RETURNS TRUE if inv will go negative and org control does not allow it */
952: FUNCTION check_inv_negative(p_mmt_rec IN mtl_material_transactions%ROWTYPE,
953: p_mmln_tbl IN gme_common_pvt.mtl_trans_lots_num_tbl,
954: p_org_neg_control IN NUMBER DEFAULT gme_common_pvt.g_allow_neg_inv,
955: p_item_no IN VARCHAR2) RETURN BOOLEAN IS
956: l_api_name CONSTANT VARCHAR2(30) := 'check_inv_negative';