APPS.GME_POST_MIGRATION dependencies on MTL_MATERIAL_TRANSACTIONS

Line 2253: l_mmt_rec mtl_material_transactions%ROWTYPE;

2249: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
2250: l_mtl_dtl_rec gme_material_details%ROWTYPE;
2251: l_plot_out_rec gme_pending_product_lots%ROWTYPE;
2252: l_plot_in_rec gme_pending_product_lots%ROWTYPE;
2253: l_mmt_rec mtl_material_transactions%ROWTYPE;
2254: l_mmln_rec gme_common_pvt.mtl_trans_lots_num_tbl;
2255: uom_conversion_fail EXCEPTION;
2256: setup_failed EXCEPTION;
2257: create_txn_rsv_pp_err EXCEPTION;

Line 2346: SELECT mtl_material_transactions_s.NEXTVAL INTO gme_common_pvt.g_transaction_header_id FROM DUAL;

2342: l_msg_name := 'GME_MIG_ITEM_NOT_TXNS_ENABLED';
2343: RAISE defined_error;
2344: END IF;
2345:
2346: SELECT mtl_material_transactions_s.NEXTVAL INTO gme_common_pvt.g_transaction_header_id FROM DUAL;
2347: IF (g_debug <= gme_debug.g_log_statement) THEN
2348: gme_debug.put_line('Transaction header ID = '||gme_common_pvt.g_transaction_header_id);
2349: END IF;
2350:

Line 2663: --UPDATE mtl_material_transactions

2659: RAISE create_txn_rsv_pp_err;
2660: END IF;
2661:
2662: -- Bug 13706812 Suguna only Set the costed flag for migrated transactions.
2663: --UPDATE mtl_material_transactions
2664: -- SET OPM_COSTED_FLAG = NULL
2665: -- WHERE transaction_id = l_mmt_rec.transaction_id;
2666:
2667: ELSE /* IF (l_txns_tbl(i).completed_ind = 1) THEN */

Line 2794: SELECT mtl_material_transactions_s.NEXTVAL INTO gme_common_pvt.g_transaction_header_id FROM DUAL;

2790: RAISE defined_error;
2791: END IF;
2792:
2793: l_mmti_rec.transaction_date := l_date;
2794: SELECT mtl_material_transactions_s.NEXTVAL INTO gme_common_pvt.g_transaction_header_id FROM DUAL;
2795: IF (g_debug <= gme_debug.g_log_statement) THEN
2796: gme_debug.put_line('Transaction header ID for reservation is '||gme_common_pvt.g_transaction_header_id);
2797: END IF;
2798:

Line 3495: SELECT mtl_material_transactions_s.NEXTVAL INTO

3491: l_issue_rec.transaction_date := l_date;
3492: END IF;
3493:
3494: /* Create a misc issue in original org/sub/loc and then a reciept in final org/sub/loc */
3495: SELECT mtl_material_transactions_s.NEXTVAL INTO
3496: l_issue_rec.transaction_interface_id FROM DUAL;
3497: l_issue_rec.transaction_header_id := gme_common_pvt.g_transaction_header_id;
3498: l_issue_rec.source_code := 'OPM_GME_MIGRATION';
3499: l_issue_rec.source_line_id := p_txn_rec.trans_id;

Line 3594: SELECT mtl_material_transactions_s.NEXTVAL INTO

3590: ELSE
3591: l_receipt_rec.transaction_date := l_date;
3592: END IF;
3593:
3594: SELECT mtl_material_transactions_s.NEXTVAL INTO
3595: l_receipt_rec.transaction_interface_id FROM DUAL;
3596:
3597: l_receipt_rec.organization_id := p_batch_org_id;
3598: