eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.GME_UNRELEASE_BATCH_PVT dependencies on GME_PENDING_PRODUCT_LOTS

Line 379: l_pplot_rec gme_pending_product_lots%ROWTYPE;

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;
381: l_return_status VARCHAR2(1);
382:
383: -- Bug 13017256

Line 380: l_out_pplot_rec gme_pending_product_lots%ROWTYPE;

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;
381: l_return_status VARCHAR2(1);
382:
383: -- Bug 13017256
384: l_trans_date DATE;

Line 765: l_pplot_rec gme_pending_product_lots%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;
767: l_return_status VARCHAR2(1);
768:
769: BEGIN

Line 766: l_out_pplot_rec gme_pending_product_lots%ROWTYPE;

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;
767: l_return_status VARCHAR2(1);
768:
769: BEGIN
770: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN

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