[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
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_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_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_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
CURSOR C IS
SELECT 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,
project_asset_line_id,
project_id,
task_id,
sum_units,
dist_name,
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,
context,
inventorial,
short_fiscal_year_flag,
conversion_date,
original_deprn_start_date,
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,
invoice_distribution_id,
invoice_line_number,
po_distribution_id,
warranty_number
FROM fa_mass_additions
WHERE rowid = X_Rowid
FOR UPDATE of Mass_Addition_Id NOWAIT;
FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
AND ( (Recinfo.invoice_updated_by = X_Invoice_Updated_By)
OR ( (Recinfo.invoice_updated_by IS NULL)
AND (X_Invoice_Updated_By IS NULL)))) then
null;
PROCEDURE Delete_Row(X_Rowid VARCHAR2,p_log_level_rec in fa_api_types.log_level_rec_type default null) IS
BEGIN
DELETE FROM fa_mass_additions
WHERE rowid = X_Rowid;
END Delete_Row;
PROCEDURE Select_Summary(X_MAss_Addition_ID IN NUMBER,
X_TOTAL_COST IN OUT NOCOPY NUMBER,
X_TOTAL_COST_RTOT_DB IN OUT NOCOPY NUMBER,
X_TOTAL_UNITS IN OUT NOCOPY NUMBER,
X_TOTAL_UNITS_RTOT_DB IN OUT NOCOPY NUMBER,
p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
Begin
Select NVL(Sum(Fixed_Assets_Cost), 0), NVL(Sum(Fixed_Assets_Cost), 0),
NVL(Sum(Fixed_Assets_Units), 0), NVL(Sum(Fixed_Assets_Units), 0)
Into X_Total_Cost, X_TOTAL_Cost_RTOT_DB,
X_Total_Units, X_Total_Units_RTOT_DB
From Fa_MAss_Additions
Where Merge_PArent_MAss_Additions_ID = X_Mass_Addition_ID;
End Select_Summary;