[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE update_rcv_transaction (
rcv_trx IN OUT NOCOPY rcv_transactions_interface%ROWTYPE) IS
X_rowid ROWID;
SELECT rowid
INTO X_Rowid
FROM rcv_transactions_interface
WHERE interface_transaction_id = rcv_trx.interface_transaction_id;
** Update the columns of the transaction
*/
RCV_TRX_INTERFACE_UPDATE_PKG.update_row(
X_Rowid,
rcv_trx.Interface_Transaction_Id,
rcv_trx.Group_Id,
rcv_trx.Last_Update_Date,
rcv_trx.Last_Updated_By,
rcv_trx.Last_Update_Login,
rcv_trx.Transaction_Type,
rcv_trx.Transaction_Date,
rcv_trx.Processing_Status_Code,
rcv_trx.Processing_Mode_Code,
rcv_trx.Processing_Request_Id,
rcv_trx.Transaction_Status_Code,
rcv_trx.Category_Id,
rcv_trx.Quantity,
rcv_trx.Unit_Of_Measure,
rcv_trx.Interface_Source_Code,
rcv_trx.Interface_Source_Line_Id,
rcv_trx.Inv_Transaction_Id,
rcv_trx.Item_Id,
rcv_trx.Item_Description,
rcv_trx.Item_Revision,
rcv_trx.Uom_Code,
rcv_trx.Employee_Id,
rcv_trx.Auto_Transact_Code,
rcv_trx.Shipment_Header_Id,
rcv_trx.Shipment_Line_Id,
rcv_trx.Ship_To_Location_Id,
rcv_trx.Primary_Quantity,
rcv_trx.Primary_Unit_Of_Measure,
rcv_trx.Receipt_Source_Code,
rcv_trx.Vendor_Id,
rcv_trx.Vendor_Site_Id,
rcv_trx.From_Organization_Id,
rcv_trx.To_Organization_Id,
rcv_trx.Routing_Header_Id,
rcv_trx.Routing_Step_Id,
rcv_trx.Source_Document_Code,
rcv_trx.Parent_Transaction_Id,
rcv_trx.Po_Header_Id,
rcv_trx.Po_Revision_Num,
rcv_trx.Po_Release_Id,
rcv_trx.Po_Line_Id,
rcv_trx.Po_Line_Location_Id,
rcv_trx.Po_Unit_Price,
rcv_trx.Currency_Code,
rcv_trx.Currency_Conversion_Type,
rcv_trx.Currency_Conversion_Rate,
rcv_trx.Currency_Conversion_Date,
rcv_trx.Po_Distribution_Id,
rcv_trx.Requisition_Line_Id,
rcv_trx.Req_Distribution_Id,
rcv_trx.Charge_Account_Id,
rcv_trx.Substitute_Unordered_Code,
rcv_trx.Receipt_Exception_Flag,
rcv_trx.Accrual_Status_Code,
rcv_trx.Inspection_Status_Code,
rcv_trx.Inspection_Quality_Code,
rcv_trx.Destination_Type_Code,
rcv_trx.Deliver_To_Person_Id,
rcv_trx.Location_Id,
rcv_trx.Deliver_To_Location_Id,
rcv_trx.Subinventory,
rcv_trx.Locator_Id,
rcv_trx.Wip_Entity_Id,
rcv_trx.Wip_Line_Id,
rcv_trx.Department_Code,
rcv_trx.Wip_Repetitive_Schedule_Id,
rcv_trx.Wip_Operation_Seq_Num,
rcv_trx.Wip_Resource_Seq_Num,
rcv_trx.Bom_Resource_Id,
rcv_trx.Shipment_Num,
rcv_trx.Freight_Carrier_Code,
rcv_trx.Bill_Of_Lading,
rcv_trx.Packing_Slip,
rcv_trx.Shipped_Date,
rcv_trx.Expected_Receipt_Date,
rcv_trx.Actual_Cost,
rcv_trx.Transfer_Cost,
rcv_trx.Transportation_Cost,
rcv_trx.Transportation_Account_Id,
rcv_trx.Num_Of_Containers,
rcv_trx.Waybill_Airbill_Num,
rcv_trx.Vendor_Item_Num,
rcv_trx.Vendor_Lot_Num,
rcv_trx.Rma_Reference,
rcv_trx.Comments,
rcv_trx.Attribute_Category,
rcv_trx.Attribute1,
rcv_trx.Attribute2,
rcv_trx.Attribute3,
rcv_trx.Attribute4,
rcv_trx.Attribute5,
rcv_trx.Attribute6,
rcv_trx.Attribute7,
rcv_trx.Attribute8,
rcv_trx.Attribute9,
rcv_trx.Attribute10,
rcv_trx.Attribute11,
rcv_trx.Attribute12,
rcv_trx.Attribute13,
rcv_trx.Attribute14,
rcv_trx.Attribute15,
rcv_trx.Ship_Head_Attribute_Category,
rcv_trx.Ship_Head_Attribute1,
rcv_trx.Ship_Head_Attribute2,
rcv_trx.Ship_Head_Attribute3,
rcv_trx.Ship_Head_Attribute4,
rcv_trx.Ship_Head_Attribute5,
rcv_trx.Ship_Head_Attribute6,
rcv_trx.Ship_Head_Attribute7,
rcv_trx.Ship_Head_Attribute8,
rcv_trx.Ship_Head_Attribute9,
rcv_trx.Ship_Head_Attribute10,
rcv_trx.Ship_Head_Attribute11,
rcv_trx.Ship_Head_Attribute12,
rcv_trx.Ship_Head_Attribute13,
rcv_trx.Ship_Head_Attribute14,
rcv_trx.Ship_Head_Attribute15,
rcv_trx.Ship_Line_Attribute_Category,
rcv_trx.Ship_Line_Attribute1,
rcv_trx.Ship_Line_Attribute2,
rcv_trx.Ship_Line_Attribute3,
rcv_trx.Ship_Line_Attribute4,
rcv_trx.Ship_Line_Attribute5,
rcv_trx.Ship_Line_Attribute6,
rcv_trx.Ship_Line_Attribute7,
rcv_trx.Ship_Line_Attribute8,
rcv_trx.Ship_Line_Attribute9,
rcv_trx.Ship_Line_Attribute10,
rcv_trx.Ship_Line_Attribute11,
rcv_trx.Ship_Line_Attribute12,
rcv_trx.Ship_Line_Attribute13,
rcv_trx.Ship_Line_Attribute14,
rcv_trx.Ship_Line_Attribute15,
rcv_trx.Ussgl_Transaction_Code,
rcv_trx.Government_Context,
rcv_trx.Reason_Id,
rcv_trx.Destination_Context,
rcv_trx.Source_Doc_Quantity,
rcv_trx.Source_Doc_Unit_Of_Measure,
rcv_trx.Use_Mtl_Lot,
rcv_trx.Use_Mtl_Serial);
END update_rcv_transaction;