[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
X_Mass_Addition_Id IN OUT NOCOPY NUMBER ,
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_Created_By NUMBER DEFAULT NULL,
X_Creation_Date DATE 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_deprn_method_code VARCHAR2 DEFAULT NULL,
X_life_in_months VARCHAR2 DEFAULT NULL,
X_basic_rate NUMBER DEFAULT NULL,
X_adjusted_rate NUMBER DEFAULT NULL,
X_bonus_rule VARCHAR2 DEFAULT NULL, --Bug 8675206
X_prorate_convention_code VARCHAR2 DEFAULT NULL, --Bug8675206
X_deprn_limit_type VARCHAR2 DEFAULT NULL,
X_allowed_deprn_limit_amount NUMBER DEFAULT NULL,
X_allowed_deprn_limit NUMBER DEFAULT NULL,
X_salvage_type VARCHAR2 DEFAULT NULL,
X_percent_salvage_value NUMBER DEFAULT NULL,
X_nbv_at_switch NUMBER DEFAULT NULL, -- Changes made as per the ER No.s 6606548 and 6606552 by Sbyreddy Start
X_prior_deprn_limit_type VARCHAR2 DEFAULT NULL,
X_prior_deprn_limit_amount NUMBER DEFAULT NULL,
X_prior_deprn_limit NUMBER DEFAULT NULL,
X_prior_deprn_method VARCHAR2 DEFAULT NULL,
X_prior_life_in_months NUMBER DEFAULT NULL,
X_prior_basic_rate NUMBER DEFAULT NULL,
X_prior_adjusted_rate NUMBER DEFAULT NULL,
X_period_full_reserve VARCHAR2 DEFAULT NULL,
X_period_extd_deprn VARCHAR2 DEFAULT NULL,
-- Changes made as per the ER No.s 6606548 and 6606552 by Sbyreddy End
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) IS
CURSOR C IS SELECT rowid FROM fa_mass_additions
WHERE mass_addition_id = X_Mass_Addition_Id;
CURSOR C2 IS SELECT fa_mass_additions_s.nextval FROM sys.dual;
INSERT INTO fa_mass_additions(
mass_addition_id,
asset_number,
tag_number,
description,
asset_category_id,
manufacturer_name,
serial_number,
model_number,
book_type_code,
date_placed_in_service,
fixed_assets_cost,
payables_units,
fixed_assets_units,
payables_code_combination_id,
expense_code_combination_id,
location_id,
assigned_to,
feeder_system_name,
create_batch_date,
create_batch_id,
last_update_date,
last_updated_by,
reviewer_comments,
invoice_number,
vendor_number,
po_vendor_id,
po_number,
posting_status,
queue_name,
invoice_date,
invoice_created_by,
invoice_updated_by,
payables_cost,
invoice_id,
payables_batch_name,
depreciate_flag,
parent_mass_addition_id,
parent_asset_id,
split_merged_code,
ap_distribution_line_number,
post_batch_id,
add_to_asset_id,
amortize_flag,
new_master_flag,
asset_key_ccid,
asset_type,
deprn_reserve,
ytd_deprn,
beginning_nbv,
created_by,
creation_date,
last_update_login,
salvage_value,
accounting_date,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute_category_code,
fully_rsvd_revals_counter,
merge_invoice_number,
merge_vendor_number,
production_capacity,
reval_amortization_basis,
reval_reserve,
unit_of_measure,
unrevalued_cost,
ytd_reval_deprn_expense,
attribute16,
attribute17,
attribute18,
attribute19,
attribute20,
attribute21,
attribute22,
attribute23,
attribute24,
attribute25,
attribute26,
attribute27,
attribute28,
attribute29,
attribute30,
merged_code,
split_code,
merge_parent_mass_additions_id,
split_parent_mass_additions_id,
sum_units,
context,
global_attribute1,
global_attribute2,
global_attribute3,
global_attribute4,
global_attribute5,
global_attribute6,
global_attribute7,
global_attribute8,
global_attribute9,
global_attribute10,
global_attribute11,
global_attribute12,
global_attribute13,
global_attribute14,
global_attribute15,
global_attribute16,
global_attribute17,
global_attribute18,
global_attribute19,
global_attribute20,
global_attribute_category,
inventorial,
transaction_type_code,
transaction_date,
warranty_id,
lease_id,
lessor_id,
property_type_code,
property_1245_1250_code,
in_use_flag,
owned_leased,
new_used,
asset_id,
group_asset_id,
deprn_method_code,
life_in_months ,
basic_rate ,
adjusted_rate
,prorate_convention_code --Bug8675206
,bonus_rule --Bug 8675206
, deprn_limit_type -- Changes made as per the ER No.s 6606548 and 6606552 by Sbyreddy Start
, allowed_deprn_limit_amount
, allowed_deprn_limit
, salvage_type
, percent_salvage_value
, nbv_at_switch
, prior_deprn_limit_type
, prior_deprn_limit_amount
, prior_deprn_limit
, prior_deprn_method
, prior_life_in_months
, prior_basic_rate
, prior_adjusted_rate
, period_full_reserve
, period_extd_deprn
-- Changes made as per the ER No.s 6606548 and 6606552 by Sbyreddy End
,invoice_distribution_id,
invoice_line_number,
po_distribution_id,
warranty_number
) VALUES (
X_Mass_Addition_Id,
X_Asset_Number,
X_Tag_Number,
X_Description,
X_Asset_Category_Id,
X_Manufacturer_Name,
X_Serial_Number,
X_Model_Number,
X_Book_Type_Code,
X_Date_Placed_In_Service,
X_Fixed_Assets_Cost,
X_Payables_Units,
X_Fixed_Assets_Units,
X_Payables_Code_Combination_Id,
X_Expense_Code_Combination_Id,
X_Location_Id,
X_Assigned_To,
X_Feeder_System_Name,
X_Create_Batch_Date,
X_Create_Batch_Id,
X_Last_Update_Date,
X_Last_Updated_By,
X_Reviewer_Comments,
X_Invoice_Number,
X_Vendor_Number,
X_Po_Vendor_Id,
X_Po_Number,
X_Posting_Status,
X_Queue_Name,
X_Invoice_Date,
X_Invoice_Created_By,
X_Invoice_Updated_By,
X_Payables_Cost,
X_Invoice_Id,
X_Payables_Batch_Name,
X_Depreciate_Flag,
X_Parent_Mass_Addition_Id,
X_Parent_Asset_Id,
X_Split_Merged_Code,
X_Ap_Distribution_Line_Number,
X_Post_Batch_Id,
X_Add_To_Asset_Id,
X_Amortize_Flag,
X_New_Master_Flag,
X_Asset_Key_Ccid,
X_Asset_Type,
X_Deprn_Reserve,
X_Ytd_Deprn,
X_Beginning_Nbv,
X_Created_By,
X_Creation_Date,
X_Last_Update_Login,
X_Salvage_Value,
X_Accounting_Date,
X_Attribute1,
X_Attribute2,
X_Attribute3,
X_Attribute4,
X_Attribute5,
X_Attribute6,
X_Attribute7,
X_Attribute8,
X_Attribute9,
X_Attribute10,
X_Attribute11,
X_Attribute12,
X_Attribute13,
X_Attribute14,
X_Attribute15,
X_Attribute_Category_Code,
X_Fully_Rsvd_Revals_Counter,
X_Merge_Invoice_Number,
X_Merge_Vendor_Number,
X_Production_Capacity,
X_Reval_Amortization_Basis,
X_Reval_Reserve,
X_Unit_Of_Measure,
X_Unrevalued_Cost,
X_Ytd_Reval_Deprn_Expense,
X_Attribute16,
X_Attribute17,
X_Attribute18,
X_Attribute19,
X_Attribute20,
X_Attribute21,
X_Attribute22,
X_Attribute23,
X_Attribute24,
X_Attribute25,
X_Attribute26,
X_Attribute27,
X_Attribute28,
X_Attribute29,
X_Attribute30,
X_Merged_Code,
X_Split_Code,
X_Merge_Parent_Mass_Add_Id,
X_Split_Parent_Mass_Add_Id,
X_Sum_Units,
X_Context,
X_global_attribute1,
X_global_attribute2,
X_global_attribute3,
X_global_attribute4,
X_global_attribute5,
X_global_attribute6,
X_global_attribute7,
X_global_attribute8,
X_global_attribute9,
X_global_attribute10,
X_global_attribute11,
X_global_attribute12,
X_global_attribute13,
X_global_attribute14,
X_global_attribute15,
X_global_attribute16,
X_global_attribute17,
X_global_attribute18,
X_global_attribute19,
X_global_attribute20,
X_global_attribute_category,
X_Inventorial,
X_Transaction_type_code,
X_transaction_date,
X_warranty_id,
X_lease_id,
X_lessor_id,
X_property_type_code,
X_property_1245_1250_code,
X_in_use_flag,
X_owned_leased,
X_new_used,
X_asset_id,
X_group_asset_id,
X_deprn_method_code ,
X_life_in_months ,
X_basic_rate ,
X_adjusted_rate ,
X_prorate_convention_code , --Bug8675206
X_bonus_rule , --Bug8675206
-- Changes made as per the ER No.s 6606548 and 6606552 by Sbyreddy Start
X_deprn_limit_type ,
X_allowed_deprn_limit_amount ,
X_allowed_deprn_limit ,
X_salvage_type ,
X_percent_salvage_value ,
X_nbv_at_switch ,
X_prior_deprn_limit_type ,
X_prior_deprn_limit_amount ,
X_prior_deprn_limit ,
X_prior_deprn_method ,
X_prior_life_in_months ,
X_prior_basic_rate ,
X_prior_adjusted_rate ,
X_period_full_reserve ,
X_period_extd_deprn
-- -- Changes made as per the ER No.s 6606548 and 6606552 by Sbyreddy End
,X_invoice_distribution_id,
X_invoice_line_number,
X_po_distribution_id,
X_warranty_number
);
END Insert_Row;