The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure update_row( v_rowid varchar2,
v_movement_id number,
v_parent_movement_id number,
v_Organization_Id number,
v_Last_Update_Date date,
v_Last_Updated_By number,
v_Last_Update_Login number,
v_movement_type varchar2,
v_document_source_type varchar2,
v_entity_org_id number,
v_Transaction_date date,
v_movement_status varchar2,
v_go_detail varchar2,
v_from_org_id number,
v_from_org_name varchar2,
v_to_org_id number,
v_to_org_name varchar2,
v_customer_name varchar2,
v_customer_number varchar2,
v_customer_location varchar2,
v_ship_to_customer_id number,
v_ship_to_site_use_id number,
v_vendor_name varchar2,
v_vendor_number varchar2,
v_vendor_site varchar2,
v_vendor_id number,
v_vendor_site_id number,
v_po_header_id number,
v_order_header_id number,
v_requisition_header_id number,
v_doc_reference varchar2,
v_po_line_id number,
v_order_line_id number,
v_requisition_line_id number,
v_doc_line_reference varchar2,
v_shipment_header_id number,
v_shipment_reference varchar2,
v_shipment_line_id number,
v_shipment_line_reference varchar2,
v_po_line_location_id number,
v_picking_line_id number,
v_picking_line_detail_id number,
v_pick_slip_reference varchar2,
v_bill_to_name varchar2,
v_bill_to_number varchar2,
v_bill_to_site varchar2,
v_bill_to_customer_id number,
v_bill_to_site_use_id number,
v_invoice_batch_id number,
v_invoice_batch_reference varchar2,
v_invoice_id number,
v_invoice_reference varchar2,
v_customer_trx_line_id number,
v_invoice_line_reference varchar2,
v_invoice_qty number,
v_invoice_unit_price number,
v_invoice_line_ext_val number,
v_invoice_date_reference date,
v_inventory_item_id number,
v_item_cost number,
v_item_desc varchar2,
v_commodity_code varchar2,
v_commodity_code_description varchar2,
v_category_id number,
v_transaction_uom_code varchar2,
v_transaction_qty number,
v_document_unit_price number,
v_document_line_ext_value number,
v_primary_qty number,
v_dispatch_terr_code varchar2,
v_destination_terr_code varchar2,
v_origin_terr_code varchar2,
v_txn_nature varchar2,
v_delivery_terms varchar2,
v_transport_mode varchar2,
v_area varchar2,
v_port varchar2,
v_stat_type varchar2,
v_weight_method varchar2,
v_unit_weight number ,
v_total_weight number ,
v_stat_adj_pct number ,
v_stat_adj_amt number ,
v_stat_ext_val number ,
v_stat_method varchar2,
v_comments varchar2,
v_alt_qty number,
v_alt_uom_code varchar2,
v_outside_code varchar2,
v_outside_unit_price number,
v_outside_ext_val number,
v_currency_code varchar2,
v_attribute_category varchar2,
v_attribute1 varchar2 ,
v_attribute2 varchar2 ,
v_attribute3 varchar2 ,
v_attribute4 varchar2 ,
v_attribute5 varchar2 ,
v_attribute6 varchar2 ,
v_attribute7 varchar2 ,
v_attribute8 varchar2 ,
v_attribute9 varchar2 ,
v_attribute10 varchar2 ,
v_attribute11 varchar2 ,
v_attribute12 varchar2 ,
v_attribute13 varchar2 ,
v_attribute14 varchar2 ,
v_attribute15 varchar2) is
begin
update mtl_movement_statistics
set
MOVEMENT_ID = v_movement_id,
ORGANIZATION_ID = v_organization_id,
ENTITY_ORG_ID = v_entity_org_id,
MOVEMENT_TYPE = v_movement_type,
MOVEMENT_STATUS = v_movement_status,
TRANSACTION_DATE = v_transaction_date,
LAST_UPDATE_DATE = v_last_update_date,
LAST_UPDATED_BY = v_last_updated_by,
LAST_UPDATE_LOGIN = v_last_update_login,
DOCUMENT_SOURCE_TYPE = v_document_source_type,
CREATION_METHOD = decode(v_go_detail, null, 'M', 'Z'),
DOCUMENT_REFERENCE = v_doc_reference,
DOCUMENT_LINE_REFERENCE = v_doc_line_reference,
DOCUMENT_UNIT_PRICE = v_document_unit_price,
DOCUMENT_LINE_EXT_VALUE = v_document_line_ext_value,
RECEIPT_REFERENCE = null,
SHIPMENT_REFERENCE = v_shipment_reference,
SHIPMENT_LINE_REFERENCE = v_shipment_line_reference,
PICK_SLIP_REFERENCE = v_pick_slip_reference,
CUSTOMER_NAME = v_customer_name,
CUSTOMER_NUMBER = v_customer_number,
CUSTOMER_LOCATION = v_customer_location,
TRANSACTING_FROM_ORG = v_from_org_name,
TRANSACTING_TO_ORG = v_to_org_name,
VENDOR_NAME = v_vendor_name,
VENDOR_NUMBER = v_vendor_number,
VENDOR_SITE = v_vendor_site,
BILL_TO_NAME = v_bill_to_name,
BILL_TO_NUMBER = v_bill_to_number,
BILL_TO_SITE = v_bill_to_site,
PO_HEADER_ID = v_po_header_id,
PO_LINE_ID = v_po_line_id,
PO_LINE_LOCATION_ID = v_po_line_location_id,
PICKING_LINE_ID = v_picking_line_id,
PICKING_LINE_DETAIL_ID = v_picking_line_detail_id,
ORDER_HEADER_ID = v_order_header_id,
ORDER_LINE_ID = v_order_line_id,
REQUISITION_HEADER_ID = v_requisition_header_id,
REQUISITION_LINE_ID = v_requisition_line_id,
SHIPMENT_HEADER_ID = v_shipment_header_id,
SHIPMENT_LINE_ID = v_shipment_line_id,
SHIP_TO_CUSTOMER_ID = v_ship_to_customer_id,
SHIP_TO_SITE_USE_ID = v_ship_to_site_use_id,
BILL_TO_CUSTOMER_ID = v_bill_to_customer_id,
BILL_TO_SITE_USE_ID = v_bill_to_site_use_id,
VENDOR_ID = v_vendor_id,
VENDOR_SITE_ID = v_vendor_site_id,
INVENTORY_ITEM_ID = v_inventory_item_id,
FROM_ORGANIZATION_ID = v_from_org_id,
TO_ORGANIZATION_ID = v_to_org_id,
ITEM_DESCRIPTION = v_item_desc,
ITEM_COST = v_item_cost,
TRANSACTION_QUANTITY = v_transaction_qty,
TRANSACTION_UOM_CODE = v_transaction_uom_code,
PRIMARY_QUANTITY = v_primary_qty,
INVOICE_BATCH_ID = v_invoice_batch_id,
INVOICE_ID = v_invoice_id,
CUSTOMER_TRX_LINE_ID = v_customer_trx_line_id,
INVOICE_BATCH_REFERENCE = v_invoice_batch_reference,
INVOICE_REFERENCE = v_invoice_reference,
INVOICE_LINE_REFERENCE = v_invoice_line_reference,
INVOICE_DATE_REFERENCE = v_invoice_date_reference,
INVOICE_QUANTITY = v_invoice_qty,
INVOICE_UNIT_PRICE = v_invoice_unit_price,
INVOICE_LINE_EXT_VALUE = v_invoice_line_ext_val,
OUTSIDE_CODE = v_outside_code,
OUTSIDE_EXT_VALUE = v_outside_ext_val,
OUTSIDE_UNIT_PRICE = v_outside_unit_price,
CURRENCY_CODE = v_currency_code,
CATEGORY_ID = v_category_id,
COMMODITY_CODE = v_commodity_code,
COMMODITY_DESCRIPTION = v_commodity_code_description,
WEIGHT_METHOD = v_weight_method,
UNIT_WEIGHT = v_unit_weight,
TOTAL_WEIGHT = v_total_weight,
TRANSACTION_NATURE = v_txn_nature,
DELIVERY_TERMS = v_delivery_terms,
TRANSPORT_MODE = v_transport_mode,
ALTERNATE_QUANTITY = v_alt_qty,
ALTERNATE_UOM_CODE = v_alt_uom_code,
DISPATCH_TERRITORY_CODE = v_dispatch_terr_code,
DESTINATION_TERRITORY_CODE = v_destination_terr_code,
ORIGIN_TERRITORY_CODE = v_origin_terr_code,
STAT_METHOD = v_stat_method,
STAT_ADJ_PERCENT = v_stat_adj_pct,
STAT_ADJ_AMOUNT = v_stat_adj_amt,
STAT_EXT_VALUE = v_stat_ext_val,
AREA = v_area,
PORT = v_port,
STAT_TYPE = v_stat_type,
COMMENTS = v_comments,
ATTRIBUTE_CATEGORY = v_attribute_category,
ATTRIBUTE1 = v_attribute1,
ATTRIBUTE2 = v_attribute2,
ATTRIBUTE3 = v_attribute3,
ATTRIBUTE4 = v_attribute4,
ATTRIBUTE5 = v_attribute5,
ATTRIBUTE6 = v_attribute6,
ATTRIBUTE7 = v_attribute7,
ATTRIBUTE8 = v_attribute8,
ATTRIBUTE9 = v_attribute9,
ATTRIBUTE10 = v_attribute10,
ATTRIBUTE11 = v_attribute11,
ATTRIBUTE12 = v_attribute12,
ATTRIBUTE13 = v_attribute13,
ATTRIBUTE14 = v_attribute14,
ATTRIBUTE15 = v_attribute15
where rowid = v_rowid;
end update_row;