[Home] [Help]
268: 'C',SYSDATE,
269: 'S',nvl(l_line_rec.schedule_ship_date,SYSDATE),
270: l_ordered_date)
271: INTO l_trx_date_for_inv_iface
272: FROM DUAL;
273:
274: IF l_debug_level > 0 THEN
275: OE_DEBUG_PUB.add('Transaction Date derived from system parameter setup is '||l_trx_date_for_inv_iface,1);
276: END IF;
370: -- we will use this transaction_header_id for all
371: -- interface lines
372: SELECT mtl_material_transactions_s.nextval
373: INTO l_transaction_header_id
374: FROM dual;
375:
376: l_transaction_interface_id := l_transaction_header_id;
377:
378: l_transaction_reference := l_line_rec.header_id;
746: IF ( l_process_org = 0 ) THEN */
747:
748: SELECT oe_transactions_iface_s.nextval
749: INTO l_source_line_id
750: FROM dual;
751:
752: --ER 8419373 check if lot and serial controlled and get new transaction_interface_id for column SERIAL_TRANSACTION_TEMP_ID
753: IF l_lot = 'Y' AND l_serial = 'Y' THEN
754: SELECT mtl_material_transactions_s.nextval
752: --ER 8419373 check if lot and serial controlled and get new transaction_interface_id for column SERIAL_TRANSACTION_TEMP_ID
753: IF l_lot = 'Y' AND l_serial = 'Y' THEN
754: SELECT mtl_material_transactions_s.nextval
755: INTO l_serial_transaction_temp_id
756: FROM dual;
757: else
758: l_serial_transaction_temp_id := null;
759: END IF;
760:
1153: WHERE code_combination_id = l_trans_acc;
1154:
1155: SELECT mtl_material_transactions_s.nextval
1156: INTO l_transaction_interface_id
1157: FROM dual;
1158: -- for use when looping or used by the second
1159: -- insert into mtl_transactions_interface
1160: -- interface_id need to be unique for each interface record
1161:
1310: -- mtl_transactions_interface table
1311: IF ( l_process_org = 0 ) THEN */
1312: SELECT oe_transactions_iface_s.nextval
1313: INTO l_source_line_id
1314: FROM dual;
1315:
1316: IF l_debug_level > 0 THEN
1317: oe_debug_pub.add( 'INV IFACE: INSERTING RECORD - 2' , 5 ) ;
1318: