DBA Data[Home] [Help]

APPS.GME_POST_MIGRATION dependencies on MTL_MATERIAL_TRANSACTIONS

Line 2035: l_mmt_rec mtl_material_transactions%ROWTYPE;

2031: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
2032: l_mtl_dtl_rec gme_material_details%ROWTYPE;
2033: l_plot_out_rec gme_pending_product_lots%ROWTYPE;
2034: l_plot_in_rec gme_pending_product_lots%ROWTYPE;
2035: l_mmt_rec mtl_material_transactions%ROWTYPE;
2036: l_mmln_rec gme_common_pvt.mtl_trans_lots_num_tbl;
2037: uom_conversion_fail EXCEPTION;
2038: setup_failed EXCEPTION;
2039: create_txn_rsv_pp_err EXCEPTION;

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

2110: IF (l_mtl_rec.mtl_transactions_enabled_flag <> 'Y') THEN
2111: l_msg_name := 'GME_MIG_ITEM_NOT_TXNS_ENABLED';
2112: RAISE defined_error;
2113: END IF;
2114: SELECT mtl_material_transactions_s.NEXTVAL INTO gme_common_pvt.g_transaction_header_id FROM DUAL;
2115: IF (g_debug <= gme_debug.g_log_statement) THEN
2116: gme_debug.put_line('Transaction header ID = '||gme_common_pvt.g_transaction_header_id);
2117: END IF;
2118: l_mmti_rec.transaction_source_id := l_mtl_rec.batch_id;

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

2470: l_msg_name := 'GME_NO_OPEN_PERIODS_TXN';
2471: RAISE defined_error;
2472: END IF;
2473: l_mmti_rec.transaction_date := l_date;
2474: SELECT mtl_material_transactions_s.NEXTVAL INTO gme_common_pvt.g_transaction_header_id FROM DUAL;
2475: IF (g_debug <= gme_debug.g_log_statement) THEN
2476: gme_debug.put_line('Transaction header ID for reservation is '||gme_common_pvt.g_transaction_header_id);
2477: END IF;
2478: l_in_subinventory := l_subinventory;

Line 3027: SELECT mtl_material_transactions_s.NEXTVAL INTO

3023: ELSE
3024: l_issue_rec.transaction_date := l_date;
3025: END IF;
3026: /* Create a misc issue in original org/sub/loc and then a reciept in final org/sub/loc */
3027: SELECT mtl_material_transactions_s.NEXTVAL INTO
3028: l_issue_rec.transaction_interface_id FROM DUAL;
3029: l_issue_rec.transaction_header_id := gme_common_pvt.g_transaction_header_id;
3030: l_issue_rec.source_code := 'OPM_GME_MIGRATION';
3031: l_issue_rec.source_line_id := p_txn_rec.trans_id;

Line 3113: SELECT mtl_material_transactions_s.NEXTVAL INTO

3109: RAISE no_open_period_err;
3110: ELSE
3111: l_receipt_rec.transaction_date := l_date;
3112: END IF;
3113: SELECT mtl_material_transactions_s.NEXTVAL INTO
3114: l_receipt_rec.transaction_interface_id FROM DUAL;
3115: l_receipt_rec.organization_id := p_batch_org_id;
3116: /* We are creating a receipt txn in a sub which has the same name as org. This will always exist */
3117: BEGIN