460: VALUES (rcv_headers_interface_s.NEXTVAL,
461: rcv_interface_groups_s.NEXTVAL,
462: p_receive_tbl (1).to_organization_id,
463: p_receive_tbl (1).expected_receipt_date, SYSDATE,
464: fnd_global.user_id, fnd_global.login_id, SYSDATE,
465: fnd_global.user_id, l_validation_flag, l_process_sts_pending,
466: l_receipt_source_code, l_txn_Type_new,
467: -- added for internal orders.
468: p_receive_tbl (1).shipped_date,
461: rcv_interface_groups_s.NEXTVAL,
462: p_receive_tbl (1).to_organization_id,
463: p_receive_tbl (1).expected_receipt_date, SYSDATE,
464: fnd_global.user_id, fnd_global.login_id, SYSDATE,
465: fnd_global.user_id, l_validation_flag, l_process_sts_pending,
466: l_receipt_source_code, l_txn_Type_new,
467: -- added for internal orders.
468: p_receive_tbl (1).shipped_date,
469: p_receive_tbl (1).shipment_number
528: 'Inserting transactions interface table data'
529: );
530: END IF;
531:
532: csd_receive_util.get_employee_id (fnd_global.user_id, l_emp_id);
533:
534: --Insert data into the transactions interface table.
535: FOR i IN p_receive_tbl.FIRST .. p_receive_tbl.LAST
536: LOOP
633: p_receive_rec.item_revision,
634: p_receive_rec.to_organization_id,
635: p_receive_rec.ship_to_location_id,
636: p_receive_rec.subinventory, SYSDATE,
637: fnd_global.user_id, SYSDATE, fnd_global.user_id,
638: fnd_global.login_id, 'Y',
639: l_source_document_code
640: , 'RCV' --Interface_source_Code
641: , 'DELIVER' -- auto _Transact_Code
634: p_receive_rec.to_organization_id,
635: p_receive_rec.ship_to_location_id,
636: p_receive_rec.subinventory, SYSDATE,
637: fnd_global.user_id, SYSDATE, fnd_global.user_id,
638: fnd_global.login_id, 'Y',
639: l_source_document_code
640: , 'RCV' --Interface_source_Code
641: , 'DELIVER' -- auto _Transact_Code
642: , l_receipt_source_Code --receipt_source_code
779: transaction_quantity, primary_quantity,
780: serial_transaction_temp_id
781: )
782: VALUES (l_intf_txn_id, l_source_code,
783: l_source_line_id, SYSDATE, fnd_global.user_id,
784: SYSDATE, fnd_global.user_id, fnd_global.login_id,
785: p_receive_rec.lot_number, l_lot_expiration_date,
786: p_receive_rec.quantity, p_receive_rec.quantity,
787: --l_txn_tmp_id
780: serial_transaction_temp_id
781: )
782: VALUES (l_intf_txn_id, l_source_code,
783: l_source_line_id, SYSDATE, fnd_global.user_id,
784: SYSDATE, fnd_global.user_id, fnd_global.login_id,
785: p_receive_rec.lot_number, l_lot_expiration_date,
786: p_receive_rec.quantity, p_receive_rec.quantity,
787: --l_txn_tmp_id
788: decode(p_receive_rec.serial_number,null, null,l_txn_tmp_id)
847: to_serial_number,
848: process_flag
849: )
850: VALUES (l_txn_tmp_id, l_source_code,
851: l_source_line_id, SYSDATE, fnd_global.user_id,
852: SYSDATE, fnd_global.user_id, fnd_global.login_id,
853: p_receive_rec.serial_number,
854: p_receive_rec.serial_number,
855: l_process_flag
848: process_flag
849: )
850: VALUES (l_txn_tmp_id, l_source_code,
851: l_source_line_id, SYSDATE, fnd_global.user_id,
852: SYSDATE, fnd_global.user_id, fnd_global.login_id,
853: p_receive_rec.serial_number,
854: p_receive_rec.serial_number,
855: l_process_flag
856: );