[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE NAME: insert_rcv_transaction
===========================================================================*/
PROCEDURE insert_rcv_transaction (
rcv_trx IN OUT NOCOPY rcv_transactions_interface%ROWTYPE) IS
X_progress VARCHAR2(3) := '000';
rcv_trx_interface_insert_pkg.Insert_Row(X_Rowid,
rcv_trx.Interface_Transaction_Id,
rcv_trx.Group_Id,
rcv_trx.Last_Update_Date,
rcv_trx.Last_Updated_By,
rcv_trx.Creation_Date,
rcv_trx.Created_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,
NULL,
rcv_trx.Country_of_origin_code,
rcv_trx.oe_order_header_id,
rcv_trx.oe_order_line_id,
rcv_trx.customer_item_num,
rcv_trx.customer_id,
rcv_trx.customer_site_id,
rcv_trx.put_away_rule_id,
rcv_trx.put_away_strategy_id,
rcv_trx.lpn_id,
rcv_trx.transfer_lpn_id,
rcv_trx.cost_group_id,
rcv_trx.mmtt_temp_id,
rcv_trx.mobile_txn,
rcv_trx.transfer_cost_group_id,
/* Bug# 1548597 */
rcv_trx.secondary_quantity,
rcv_trx.secondary_unit_of_measure,
/* Bug 4392483 */
rcv_trx.lpn_group_id,
rcv_trx.org_id );
po_message_s.sql_error('insert_rcv_transaction', X_progress, sqlcode);
END insert_rcv_transaction;