DBA Data[Home] [Help]

APPS.GME_POST_MIGRATION dependencies on MTL_MATERIAL_TRANSACTIONS_S

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 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: