[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Update_Row(X_Rowid VARCHAR2,
X_Mass_Addition_Id NUMBER DEFAULT NULL,
X_Asset_Number VARCHAR2 DEFAULT NULL,
X_Tag_Number VARCHAR2 DEFAULT NULL,
X_Description VARCHAR2 DEFAULT NULL,
X_Asset_Category_Id NUMBER DEFAULT NULL,
X_Manufacturer_Name VARCHAR2 DEFAULT NULL,
X_Serial_Number VARCHAR2 DEFAULT NULL,
X_Model_Number VARCHAR2 DEFAULT NULL,
X_Book_Type_Code VARCHAR2 DEFAULT NULL,
X_Date_Placed_In_Service DATE DEFAULT NULL,
X_Fixed_Assets_Cost NUMBER DEFAULT NULL,
X_Payables_Units NUMBER DEFAULT NULL,
X_Fixed_Assets_Units NUMBER DEFAULT NULL,
X_Payables_Code_Combination_Id NUMBER DEFAULT NULL,
X_Expense_Code_Combination_Id NUMBER DEFAULT NULL,
X_Location_Id NUMBER DEFAULT NULL,
X_Assigned_To NUMBER DEFAULT NULL,
X_Feeder_System_Name VARCHAR2 DEFAULT NULL,
X_Create_Batch_Date DATE DEFAULT NULL,
X_Create_Batch_Id NUMBER DEFAULT NULL,
X_Last_Update_Date DATE DEFAULT NULL,
X_Last_Updated_By NUMBER DEFAULT NULL,
X_Reviewer_Comments VARCHAR2 DEFAULT NULL,
X_Invoice_Number VARCHAR2 DEFAULT NULL,
X_Vendor_Number VARCHAR2 DEFAULT NULL,
X_Po_Vendor_Id NUMBER DEFAULT NULL,
X_Po_Number VARCHAR2 DEFAULT NULL,
X_Posting_Status VARCHAR2 DEFAULT NULL,
X_Queue_Name VARCHAR2 DEFAULT NULL,
X_Invoice_Date DATE DEFAULT NULL,
X_Invoice_Created_By NUMBER DEFAULT NULL,
X_Invoice_Updated_By NUMBER DEFAULT NULL,
X_Payables_Cost NUMBER DEFAULT NULL,
X_Invoice_Id NUMBER DEFAULT NULL,
X_Payables_Batch_Name VARCHAR2 DEFAULT NULL,
X_Depreciate_Flag VARCHAR2 DEFAULT NULL,
X_Parent_Mass_Addition_Id NUMBER DEFAULT NULL,
X_Parent_Asset_Id NUMBER DEFAULT NULL,
X_Split_Merged_Code VARCHAR2 DEFAULT NULL,
X_Ap_Distribution_Line_Number NUMBER DEFAULT NULL,
X_Post_Batch_Id NUMBER DEFAULT NULL,
X_Add_To_Asset_Id NUMBER DEFAULT NULL,
X_Amortize_Flag VARCHAR2 DEFAULT NULL,
X_New_Master_Flag VARCHAR2 DEFAULT NULL,
X_Asset_Key_Ccid NUMBER DEFAULT NULL,
X_Asset_Type VARCHAR2 DEFAULT NULL,
X_Deprn_Reserve NUMBER DEFAULT NULL,
X_Ytd_Deprn NUMBER DEFAULT NULL,
X_Beginning_Nbv NUMBER DEFAULT NULL,
X_Last_Update_Login NUMBER DEFAULT NULL,
X_Salvage_Value NUMBER DEFAULT NULL,
X_Accounting_Date DATE DEFAULT NULL,
X_Attribute1 VARCHAR2 DEFAULT NULL,
X_Attribute2 VARCHAR2 DEFAULT NULL,
X_Attribute3 VARCHAR2 DEFAULT NULL,
X_Attribute4 VARCHAR2 DEFAULT NULL,
X_Attribute5 VARCHAR2 DEFAULT NULL,
X_Attribute6 VARCHAR2 DEFAULT NULL,
X_Attribute7 VARCHAR2 DEFAULT NULL,
X_Attribute8 VARCHAR2 DEFAULT NULL,
X_Attribute9 VARCHAR2 DEFAULT NULL,
X_Attribute10 VARCHAR2 DEFAULT NULL,
X_Attribute11 VARCHAR2 DEFAULT NULL,
X_Attribute12 VARCHAR2 DEFAULT NULL,
X_Attribute13 VARCHAR2 DEFAULT NULL,
X_Attribute14 VARCHAR2 DEFAULT NULL,
X_Attribute15 VARCHAR2 DEFAULT NULL,
X_Attribute_Category_Code VARCHAR2 DEFAULT NULL,
X_Fully_Rsvd_Revals_Counter NUMBER DEFAULT NULL,
X_Merge_Invoice_Number VARCHAR2 DEFAULT NULL,
X_Merge_Vendor_Number VARCHAR2 DEFAULT NULL,
X_Production_Capacity NUMBER DEFAULT NULL,
X_Reval_Amortization_Basis NUMBER DEFAULT NULL,
X_Reval_Reserve NUMBER DEFAULT NULL,
X_Unit_Of_Measure VARCHAR2 DEFAULT NULL,
X_Unrevalued_Cost NUMBER DEFAULT NULL,
X_Ytd_Reval_Deprn_Expense NUMBER DEFAULT NULL,
X_Attribute16 VARCHAR2 DEFAULT NULL,
X_Attribute17 VARCHAR2 DEFAULT NULL,
X_Attribute18 VARCHAR2 DEFAULT NULL,
X_Attribute19 VARCHAR2 DEFAULT NULL,
X_Attribute20 VARCHAR2 DEFAULT NULL,
X_Attribute21 VARCHAR2 DEFAULT NULL,
X_Attribute22 VARCHAR2 DEFAULT NULL,
X_Attribute23 VARCHAR2 DEFAULT NULL,
X_Attribute24 VARCHAR2 DEFAULT NULL,
X_Attribute25 VARCHAR2 DEFAULT NULL,
X_Attribute26 VARCHAR2 DEFAULT NULL,
X_Attribute27 VARCHAR2 DEFAULT NULL,
X_Attribute28 VARCHAR2 DEFAULT NULL,
X_Attribute29 VARCHAR2 DEFAULT NULL,
X_Attribute30 VARCHAR2 DEFAULT NULL,
X_Merged_Code VARCHAR2 DEFAULT NULL,
X_Split_Code VARCHAR2 DEFAULT NULL,
X_Merge_parent_Mass_Add_ID NUMBER DEFAULT NULL,
X_Split_PArent_Mass_Add_ID NUMBER DEFAULT NULL,
X_Sum_Units VARCHAR2 DEFAULT NULL,
X_Context VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE1 VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE10 VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE11 VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE12 VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE13 VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE14 VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE15 VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE16 VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE17 VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE18 VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE19 VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE2 VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE20 VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE3 VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE4 VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE5 VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE6 VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE7 VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE8 VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE9 VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 DEFAULT NULL,
X_INVENTORIAL VARCHAR2 DEFAULT NULL,
X_Transaction_type_code VARCHAR2 DEFAULT NULL,
X_transaction_date DATE DEFAULT NULL,
X_warranty_id NUMBER DEFAULT NULL,
X_lease_id NUMBER DEFAULT NULL,
X_lessor_id NUMBER DEFAULT NULL,
X_property_type_code VARCHAR2 DEFAULT NULL,
X_property_1245_1250_code VARCHAR2 DEFAULT NULL,
X_in_use_flag VARCHAR2 DEFAULT NULL,
X_owned_leased VARCHAR2 DEFAULT NULL,
X_new_used VARCHAR2 DEFAULT NULL,
X_asset_id NUMBER DEFAULT NULL,
X_group_asset_id NUMBER DEFAULT NULL,
X_invoice_distribution_id NUMBER DEFAULT NULL,
X_invoice_line_number NUMBER DEFAULT NULL,
X_po_distribution_id NUMBER DEFAULT NULL,
X_warranty_number VARCHAR2 DEFAULT NULL,
p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
BEGIN
UPDATE fa_mass_additions
SET
mass_addition_id = X_Mass_Addition_Id,
asset_number = X_Asset_Number,
tag_number = X_Tag_Number,
description = X_Description,
asset_category_id = X_Asset_Category_Id,
Manufacturer_name = X_Manufacturer_Name,
serial_number = X_Serial_Number,
model_number = X_Model_Number,
book_type_code = X_Book_Type_Code,
date_placed_in_service = X_Date_Placed_In_Service,
fixed_assets_cost = X_Fixed_Assets_Cost,
payables_units = X_Payables_Units,
fixed_assets_units = X_Fixed_Assets_Units,
payables_code_combination_id = X_Payables_Code_Combination_Id,
expense_code_combination_id = X_Expense_Code_Combination_Id,
location_id = X_Location_Id,
assigned_to = X_Assigned_To,
feeder_system_name = X_Feeder_System_Name,
create_batch_date = X_Create_Batch_Date,
create_batch_id = X_Create_Batch_Id,
last_update_date = X_Last_Update_Date,
last_updated_by = X_Last_Updated_By,
reviewer_comments = X_Reviewer_Comments,
invoice_number = X_Invoice_Number,
vendor_number = X_Vendor_Number,
po_vendor_id = X_Po_Vendor_Id,
po_number = X_Po_Number,
posting_status = X_Posting_Status,
queue_name = X_Queue_Name,
invoice_date = X_Invoice_Date,
invoice_created_by = X_Invoice_Created_By,
invoice_updated_by = X_Invoice_Updated_By,
payables_cost = X_Payables_Cost,
invoice_id = X_Invoice_Id,
payables_batch_name = X_Payables_Batch_Name,
depreciate_flag = X_Depreciate_Flag,
parent_Mass_addition_id = X_Parent_Mass_Addition_Id,
parent_asset_id = X_Parent_Asset_Id,
split_merged_code = X_Split_Merged_Code,
ap_distribution_line_number = X_Ap_Distribution_Line_Number,
post_batch_id = X_Post_Batch_Id,
add_to_asset_id = X_Add_To_Asset_Id,
amortize_flag = X_Amortize_Flag,
new_Master_flag = X_New_Master_Flag,
asset_key_ccid = X_Asset_Key_Ccid,
asset_type = X_Asset_Type,
deprn_reserve = X_Deprn_Reserve,
ytd_deprn = X_Ytd_Deprn,
beginning_nbv = X_Beginning_Nbv,
last_update_login = X_Last_Update_Login,
salvage_value = X_Salvage_Value,
accounting_date = X_Accounting_Date,
attribute1 = X_Attribute1,
attribute2 = X_Attribute2,
attribute3 = X_Attribute3,
attribute4 = X_Attribute4,
attribute5 = X_Attribute5,
attribute6 = X_Attribute6,
attribute7 = X_Attribute7,
attribute8 = X_Attribute8,
attribute9 = X_Attribute9,
attribute10 = X_Attribute10,
attribute11 = X_Attribute11,
attribute12 = X_Attribute12,
attribute13 = X_Attribute13,
attribute14 = X_Attribute14,
attribute15 = X_Attribute15,
attribute_category_code = X_Attribute_Category_Code,
fully_rsvd_revals_counter = X_Fully_Rsvd_Revals_Counter,
merge_invoice_number = X_Merge_Invoice_Number,
merge_vendor_number = X_Merge_Vendor_Number,
production_capacity = X_Production_Capacity,
reval_amortization_basis = X_Reval_Amortization_Basis,
reval_reserve = X_Reval_Reserve,
unit_of_measure = X_Unit_Of_Measure,
unrevalued_cost = X_Unrevalued_Cost,
ytd_reval_deprn_expense = X_Ytd_Reval_Deprn_Expense,
attribute16 = X_Attribute16,
attribute17 = X_Attribute17,
attribute18 = X_Attribute18,
attribute19 = X_Attribute19,
attribute20 = X_Attribute20,
attribute21 = X_Attribute21,
attribute22 = X_Attribute22,
attribute23 = X_Attribute23,
attribute24 = X_Attribute24,
attribute25 = X_Attribute25,
attribute26 = X_Attribute26,
attribute27 = X_Attribute27,
attribute28 = X_Attribute28,
attribute29 = X_Attribute29,
attribute30 = X_Attribute30,
merged_code = X_Merged_Code,
split_code = X_Split_Code,
merge_parent_Mass_additions_id = X_Merge_parent_Mass_Add_ID,
split_parent_Mass_additions_id = X_Split_PArent_Mass_Add_ID,
sum_units = X_Sum_Units,
context = X_Context,
global_attribute1 = X_GLOBAL_ATTRIBUTE1,
global_attribute10 = X_GLOBAL_ATTRIBUTE10,
global_attribute11 = X_GLOBAL_ATTRIBUTE11,
global_attribute12 = X_GLOBAL_ATTRIBUTE12,
global_attribute13 = X_GLOBAL_ATTRIBUTE13,
global_attribute14 = X_GLOBAL_ATTRIBUTE14,
global_attribute15 = X_GLOBAL_ATTRIBUTE15,
global_attribute16 = X_GLOBAL_ATTRIBUTE16,
global_attribute17 = X_GLOBAL_ATTRIBUTE17,
global_attribute18 = X_GLOBAL_ATTRIBUTE18,
global_attribute19 = X_GLOBAL_ATTRIBUTE19,
global_attribute2 = X_GLOBAL_ATTRIBUTE2 ,
global_attribute20 = X_GLOBAL_ATTRIBUTE20,
global_attribute3 = X_GLOBAL_ATTRIBUTE3 ,
global_attribute4 = X_GLOBAL_ATTRIBUTE4 ,
global_attribute5 = X_GLOBAL_ATTRIBUTE5 ,
global_attribute6 = X_GLOBAL_ATTRIBUTE6 ,
global_attribute7 = X_GLOBAL_ATTRIBUTE7 ,
global_attribute8 = X_GLOBAL_ATTRIBUTE8 ,
global_attribute9 = X_GLOBAL_ATTRIBUTE9 ,
global_attribute_category = X_GLOBAL_ATTRIBUTE_CATEGORY ,
inventorial = X_INVENTORIAL,
transaction_type_code = X_transaction_type_code,
transaction_date = X_transaction_date,
warranty_id = X_warranty_id,
lease_id = X_lease_id,
lessor_id = X_lessor_id,
property_type_code = X_property_type_code,
property_1245_1250_code = X_property_1245_1250_code,
in_use_flag = X_in_use_flag,
owned_leased = X_owned_leased,
new_used = X_new_used,
asset_id = X_asset_id,
group_asset_id = X_group_asset_id,
invoice_distribution_id = X_invoice_distribution_id,
invoice_line_number = X_invoice_line_number,
po_distribution_id = X_po_distribution_id,
warranty_number = X_warranty_number
WHERE rowid = X_Rowid;
END Update_Row;