DBA Data[Home] [Help]

APPS.MTL_MOVEMENT_STATISTICS3_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 4

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;
Line: 230

end update_row;