DBA Data[Home] [Help]

APPS.GME_COMPLETE_BATCH_PVT dependencies on GME_PENDING_PRODUCT_LOTS

Line 626: l_pp_lot_rec gme_pending_product_lots%ROWTYPE;

622:
623: l_api_name CONSTANT VARCHAR2 (30) := 'YIELD_MATERIAL';
624:
625: l_pending_product_lot_tab gme_common_pvt.pending_lots_tab;
626: l_pp_lot_rec gme_pending_product_lots%ROWTYPE;
627: i NUMBER;
628:
629: l_yield_qty NUMBER;
630: l_trans_date DATE;

Line 770: gme_pending_product_lots_pvt.get_pending_lot

766: x_return_status := l_return_status;
767: RAISE error_build_trxn;
768: END IF;
769: ELSE -- lot control... go to pending product lots
770: gme_pending_product_lots_pvt.get_pending_lot
771: (p_material_detail_id => p_material_dtl_rec.material_detail_id
772: ,x_return_status => l_return_status
773: ,x_pending_product_lot_tbl => l_pending_product_lot_tab);
774: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 862: ,p_pp_lot_rec IN gme_pending_product_lots%ROWTYPE

858: END yield_material;
859:
860: PROCEDURE build_and_create_transaction
861: (p_mtl_dtl_rec IN gme_material_details%ROWTYPE
862: ,p_pp_lot_rec IN gme_pending_product_lots%ROWTYPE
863: ,p_subinv IN VARCHAR2
864: ,p_locator_id IN NUMBER
865: ,p_trans_date IN DATE
866: ,p_yield_qty IN NUMBER

Line 996: gme_pending_product_lots_pvt.relieve_pending_lot

992: x_actual_qty := x_actual_qty + l_trxn_qty;
993:
994: -- If pending product lot, then decrease qty, entry remains if the qty goes to zero
995: IF p_pp_lot_rec.pending_product_lot_id IS NOT NULL THEN
996: gme_pending_product_lots_pvt.relieve_pending_lot
997: (p_pending_lot_id => p_pp_lot_rec.pending_product_lot_id
998: ,p_quantity => l_trxn_qty
999: ,p_secondary_quantity => l_sec_qty
1000: ,x_return_status => x_return_status);

Line 1029: ,p_pp_lot_rec IN gme_pending_product_lots%ROWTYPE

1025: ,p_yield_qty IN NUMBER
1026: ,p_subinv IN VARCHAR2
1027: ,p_locator_id IN NUMBER
1028: ,p_revision IN VARCHAR2
1029: ,p_pp_lot_rec IN gme_pending_product_lots%ROWTYPE
1030: ,x_mmti_rec OUT NOCOPY mtl_transactions_interface%ROWTYPE
1031: ,x_mmli_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_inter_tbl
1032: ,x_sec_qty OUT NOCOPY NUMBER
1033: ,x_dtl_qty OUT NOCOPY NUMBER