DBA Data[Home] [Help]

APPS.GME_UNRELEASE_BATCH_PVT dependencies on GME_PENDING_PRODUCT_LOTS_PVT

Line 835: l_sequence := gme_pending_product_lots_pvt.get_last_sequence

831: l_pplot_rec.secondary_quantity := l_mmln_tbl (j).secondary_transaction_quantity;
832: l_pplot_rec.reason_id := l_mmln_tbl (j).reason_id;
833: l_pplot_rec.lot_number := l_mmln_tbl (j).lot_number;
834:
835: l_sequence := gme_pending_product_lots_pvt.get_last_sequence
836: (p_matl_dtl_id => l_pplot_rec.material_detail_id
837: ,x_return_status => l_return_status);
838: IF NVL (g_debug, -1) <= gme_debug.g_log_statement THEN
839: gme_debug.put_line (g_pkg_name || '.' || l_api_name||' return_status from lot_qty '|| l_mmln_tbl (j).transaction_quantity);

Line 842: l_sequence := l_sequence + gme_pending_product_lots_pvt.g_sequence_increment;

838: IF NVL (g_debug, -1) <= gme_debug.g_log_statement THEN
839: gme_debug.put_line (g_pkg_name || '.' || l_api_name||' return_status from lot_qty '|| l_mmln_tbl (j).transaction_quantity);
840: gme_debug.put_line (g_pkg_name || '.' || l_api_name||' return_status from get_sequence '||l_return_status);
841: END IF;
842: l_sequence := l_sequence + gme_pending_product_lots_pvt.g_sequence_increment;
843: l_pplot_rec.sequence := l_sequence;
844:
845: gme_pending_product_lots_pvt.create_pending_product_lot
846: (p_pending_product_lots_rec => l_pplot_rec

Line 845: gme_pending_product_lots_pvt.create_pending_product_lot

841: END IF;
842: l_sequence := l_sequence + gme_pending_product_lots_pvt.g_sequence_increment;
843: l_pplot_rec.sequence := l_sequence;
844:
845: gme_pending_product_lots_pvt.create_pending_product_lot
846: (p_pending_product_lots_rec => l_pplot_rec
847: ,x_pending_product_lots_rec => l_out_pplot_rec
848: ,x_return_status => l_return_status);
849: IF l_return_status <> fnd_api.g_ret_sts_success THEN