[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
X_Book_Type_Code VARCHAR2,
X_Asset_Id NUMBER,
X_Deprn_Run_Date DATE,
X_Deprn_Amount NUMBER,
X_Ytd_Deprn NUMBER,
X_Deprn_Reserve NUMBER,
X_Deprn_Source_Code VARCHAR2,
X_Adjusted_Cost NUMBER,
X_Bonus_Rate NUMBER DEFAULT NULL,
X_Ltd_Production NUMBER DEFAULT NULL,
X_Period_Counter NUMBER,
X_Production NUMBER DEFAULT NULL,
X_Reval_Amortization NUMBER DEFAULT NULL,
X_Reval_Amortization_Basis NUMBER DEFAULT NULL,
X_Reval_Deprn_Expense NUMBER DEFAULT NULL,
X_Reval_Reserve NUMBER DEFAULT NULL,
X_Ytd_Production NUMBER DEFAULT NULL,
X_Ytd_Reval_Deprn_Expense NUMBER DEFAULT NULL,
X_Bonus_Deprn_Amount NUMBER,
X_Bonus_Ytd_Deprn NUMBER,
X_Bonus_Deprn_Reserve NUMBER,
X_mrc_sob_type_code VARCHAR2 DEFAULT 'P',
X_Calling_Fn VARCHAR2,
p_log_level_rec in fa_api_types.log_level_rec_type default null) IS
CURSOR C_ds IS SELECT rowid FROM fa_deprn_summary
WHERE asset_id = X_Asset_Id
AND book_type_code = X_Book_Type_Code
AND period_counter = X_Period_Counter;
CURSOR C_ds_mc IS SELECT rowid FROM fa_deprn_summary_mrc_v
WHERE asset_id = X_Asset_Id
AND book_type_code = X_Book_Type_Code
AND period_counter = X_Period_Counter;
INSERT INTO fa_deprn_summary_mrc_v(
book_type_code,
asset_id,
deprn_run_date,
deprn_amount,
ytd_deprn,
deprn_reserve,
deprn_source_code,
adjusted_cost,
bonus_rate,
ltd_production,
period_counter,
production,
reval_amortization,
reval_amortization_basis,
reval_deprn_expense,
reval_reserve,
ytd_production,
ytd_reval_deprn_expense,
bonus_deprn_amount,
bonus_ytd_deprn,
bonus_deprn_reserve
) VALUES (
X_Book_Type_Code,
X_Asset_Id,
X_Deprn_Run_Date,
X_Deprn_Amount,
X_Ytd_Deprn,
X_Deprn_Reserve,
X_Deprn_Source_Code,
X_Adjusted_Cost,
X_Bonus_Rate,
X_Ltd_Production,
X_Period_Counter,
X_Production,
X_Reval_Amortization,
X_Reval_Amortization_Basis,
X_Reval_Deprn_Expense,
X_Reval_Reserve,
X_Ytd_Production,
X_Ytd_Reval_Deprn_Expense,
X_Bonus_Deprn_Amount,
X_Bonus_Ytd_Deprn,
X_Bonus_Deprn_Reserve
);
INSERT INTO fa_deprn_summary(
book_type_code,
asset_id,
deprn_run_date,
deprn_amount,
ytd_deprn,
deprn_reserve,
deprn_source_code,
adjusted_cost,
bonus_rate,
ltd_production,
period_counter,
production,
reval_amortization,
reval_amortization_basis,
reval_deprn_expense,
reval_reserve,
ytd_production,
ytd_reval_deprn_expense,
bonus_deprn_amount,
bonus_ytd_deprn,
bonus_deprn_reserve
) VALUES (
X_Book_Type_Code,
X_Asset_Id,
X_Deprn_Run_Date,
X_Deprn_Amount,
X_Ytd_Deprn,
X_Deprn_Reserve,
X_Deprn_Source_Code,
X_Adjusted_Cost,
X_Bonus_Rate,
X_Ltd_Production,
X_Period_Counter,
X_Production,
X_Reval_Amortization,
X_Reval_Amortization_Basis,
X_Reval_Deprn_Expense,
X_Reval_Reserve,
X_Ytd_Production,
X_Ytd_Reval_Deprn_Expense,
X_Bonus_Deprn_Amount,
X_Bonus_Ytd_Deprn,
X_Bonus_Deprn_Reserve
);
CALLED_FN => 'fa_deprn_summary_pkg.insert_row',
CALLING_FN => X_Calling_Fn
,p_log_level_rec => p_log_level_rec);
END Insert_Row;
SELECT book_type_code,
asset_id,
deprn_run_date,
deprn_amount,
ytd_deprn,
deprn_reserve,
deprn_source_code,
adjusted_cost,
bonus_rate,
ltd_production,
period_counter,
production,
reval_amortization,
reval_amortization_basis,
reval_deprn_expense,
reval_reserve,
ytd_production,
ytd_reval_deprn_expense,
prior_fy_expense
FROM fa_deprn_summary
WHERE rowid = X_Rowid
FOR UPDATE of Asset_Id NOWAIT;
FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
PROCEDURE Update_Row(X_Rowid VARCHAR2 DEFAULT NULL,
X_Book_Type_Code VARCHAR2 DEFAULT NULL,
X_Asset_Id NUMBER DEFAULT NULL,
X_Deprn_Run_Date DATE DEFAULT NULL,
X_Deprn_Amount NUMBER DEFAULT NULL,
X_Ytd_Deprn NUMBER DEFAULT NULL,
X_Deprn_Reserve NUMBER DEFAULT NULL,
X_Deprn_Source_Code VARCHAR2 DEFAULT NULL,
X_Adjusted_Cost NUMBER DEFAULT NULL,
X_Bonus_Rate NUMBER DEFAULT NULL,
X_Ltd_Production NUMBER DEFAULT NULL,
X_Period_Counter NUMBER DEFAULT NULL,
X_Production NUMBER DEFAULT NULL,
X_Reval_Amortization NUMBER DEFAULT NULL,
X_Reval_Amortization_Basis NUMBER DEFAULT NULL,
X_Reval_Deprn_Expense NUMBER DEFAULT NULL,
X_Reval_Reserve NUMBER DEFAULT NULL,
X_Ytd_Production NUMBER DEFAULT NULL,
X_Ytd_Reval_Deprn_Expense NUMBER DEFAULT NULL,
X_Bonus_Deprn_Amount NUMBER DEFAULT NULL,
X_Bonus_Ytd_Deprn NUMBER DEFAULT NULL,
X_Bonus_Deprn_Reserve NUMBER DEFAULT NULL,
X_mrc_sob_type_code VARCHAR2 DEFAULT 'P',
X_Calling_Fn VARCHAR2,
p_log_level_rec in fa_api_types.log_level_rec_type default null) IS
BEGIN
if (X_rowid is not null) then
if (X_mrc_sob_type_code = 'R') then
UPDATE fa_deprn_summary_mrc_v
SET
book_type_code = decode(X_Book_Type_Code,
NULL, book_type_code,
FND_API.G_MISS_CHAR, null,
X_Book_Type_Code),
asset_id = decode(X_Asset_Id,
NULL, asset_id,
FND_API.G_MISS_NUM, null,
X_Asset_Id),
deprn_run_date = decode(X_Deprn_Run_Date,
NULL, deprn_run_date,
X_Deprn_Run_Date),
deprn_amount = decode(X_Deprn_Amount,
NULL, deprn_amount,
FND_API.G_MISS_NUM, null,
X_Deprn_Amount),
ytd_deprn = decode(X_Ytd_Deprn,
NULL, ytd_deprn,
FND_API.G_MISS_NUM, null,
X_Ytd_Deprn),
deprn_reserve = decode(X_Deprn_Reserve,
NULL, deprn_reserve,
FND_API.G_MISS_NUM, null,
X_Deprn_Reserve),
deprn_source_code = decode(X_Deprn_Source_Code,
NULL, deprn_source_code,
FND_API.G_MISS_CHAR, null,
X_Deprn_Source_Code),
adjusted_cost = decode(X_Adjusted_Cost,
NULL, adjusted_cost,
FND_API.G_MISS_NUM, null,
X_Adjusted_Cost),
bonus_rate = decode(X_Bonus_Rate,
NULL, bonus_rate,
FND_API.G_MISS_NUM, null,
X_Bonus_Rate),
ltd_production = decode(X_Ltd_Production,
NULL, ltd_production,
FND_API.G_MISS_NUM, null,
X_Ltd_Production),
period_counter = decode(X_Period_Counter,
NULL, period_counter,
FND_API.G_MISS_NUM, null,
X_Period_Counter),
production = decode(X_Production,
NULL, production,
FND_API.G_MISS_NUM, null,
X_Production),
reval_amortization = decode(X_Reval_Amortization,
NULL, reval_amortization,
FND_API.G_MISS_NUM, null,
X_Reval_Amortization),
reval_amortization_basis = decode(X_Reval_Amortization_Basis,
NULL, reval_amortization_basis,
FND_API.G_MISS_NUM, null,
X_Reval_Amortization_Basis),
reval_deprn_expense = decode(X_Reval_Deprn_Expense,
NULL, reval_deprn_expense,
FND_API.G_MISS_NUM, null,
X_Reval_Deprn_Expense),
reval_reserve = decode(X_Reval_Reserve,
NULL, reval_reserve,
FND_API.G_MISS_NUM, null,
X_Reval_Reserve),
ytd_production = decode(X_Ytd_Production,
NULL, ytd_production,
FND_API.G_MISS_NUM, null,
X_Ytd_Production),
ytd_reval_deprn_expense = decode(X_Ytd_Reval_Deprn_Expense,
NULL, ytd_reval_deprn_expense,
FND_API.G_MISS_NUM, null,
X_Ytd_Reval_Deprn_Expense),
bonus_deprn_amount = decode(X_Bonus_Deprn_Amount,
NULL, bonus_deprn_amount,
FND_API.G_MISS_NUM, null,
X_Bonus_Deprn_Amount),
bonus_ytd_deprn = decode(X_Bonus_Ytd_Deprn,
NULL, bonus_ytd_deprn,
FND_API.G_MISS_NUM, null,
X_Bonus_Ytd_Deprn),
bonus_deprn_reserve = decode(X_Bonus_Deprn_Reserve,
NULL, bonus_deprn_reserve,
FND_API.G_MISS_NUM, null,
X_Bonus_Deprn_Reserve)
WHERE rowid = X_Rowid;
UPDATE fa_deprn_summary
SET
book_type_code = decode(X_Book_Type_Code,
NULL, book_type_code,
FND_API.G_MISS_CHAR, null,
X_Book_Type_Code),
asset_id = decode(X_Asset_Id,
NULL, asset_id,
FND_API.G_MISS_NUM, null,
X_Asset_Id),
deprn_run_date = decode(X_Deprn_Run_Date,
NULL, deprn_run_date,
X_Deprn_Run_Date),
deprn_amount = decode(X_Deprn_Amount,
NULL, deprn_amount,
FND_API.G_MISS_NUM, null,
X_Deprn_Amount),
ytd_deprn = decode(X_Ytd_Deprn,
NULL, ytd_deprn,
FND_API.G_MISS_NUM, null,
X_Ytd_Deprn),
deprn_reserve = decode(X_Deprn_Reserve,
NULL, deprn_reserve,
FND_API.G_MISS_NUM, null,
X_Deprn_Reserve),
deprn_source_code = decode(X_Deprn_Source_Code,
NULL, deprn_source_code,
FND_API.G_MISS_CHAR, null,
X_Deprn_Source_Code),
adjusted_cost = decode(X_Adjusted_Cost,
NULL, adjusted_cost,
FND_API.G_MISS_NUM, null,
X_Adjusted_Cost),
bonus_rate = decode(X_Bonus_Rate,
NULL, bonus_rate,
FND_API.G_MISS_NUM, null,
X_Bonus_Rate),
ltd_production = decode(X_Ltd_Production,
NULL, ltd_production,
FND_API.G_MISS_NUM, null,
X_Ltd_Production),
period_counter = decode(X_Period_Counter,
NULL, period_counter,
FND_API.G_MISS_NUM, null,
X_Period_Counter),
production = decode(X_Production,
NULL, production,
FND_API.G_MISS_NUM, null,
X_Production),
reval_amortization = decode(X_Reval_Amortization,
NULL, reval_amortization,
FND_API.G_MISS_NUM, null,
X_Reval_Amortization),
reval_amortization_basis = decode(X_Reval_Amortization_Basis,
NULL, reval_amortization_basis,
FND_API.G_MISS_NUM, null,
X_Reval_Amortization_Basis),
reval_deprn_expense = decode(X_Reval_Deprn_Expense,
NULL, reval_deprn_expense,
FND_API.G_MISS_NUM, null,
X_Reval_Deprn_Expense),
reval_reserve = decode(X_Reval_Reserve,
NULL, reval_reserve,
FND_API.G_MISS_NUM, null,
X_Reval_Reserve),
ytd_production = decode(X_Ytd_Production,
NULL, ytd_production,
FND_API.G_MISS_NUM, null,
X_Ytd_Production),
ytd_reval_deprn_expense = decode(X_Ytd_Reval_Deprn_Expense,
NULL, ytd_reval_deprn_expense,
FND_API.G_MISS_NUM, null,
X_Ytd_Reval_Deprn_Expense),
bonus_deprn_amount = decode(X_Bonus_Deprn_Amount,
NULL, bonus_deprn_amount,
FND_API.G_MISS_NUM, null,
X_Bonus_Deprn_Amount),
bonus_ytd_deprn = decode(X_Bonus_Ytd_Deprn,
NULL, bonus_ytd_deprn,
FND_API.G_MISS_NUM, null,
X_Bonus_Ytd_Deprn),
bonus_deprn_reserve = decode(X_Bonus_Deprn_Reserve,
NULL, bonus_deprn_reserve,
FND_API.G_MISS_NUM, null,
X_Bonus_Deprn_Reserve)
WHERE rowid = X_Rowid;
UPDATE fa_deprn_summary_mrc_v
SET
book_type_code = decode(X_Book_Type_Code,
NULL, book_type_code,
FND_API.G_MISS_CHAR, null,
X_Book_Type_Code),
asset_id = decode(X_Asset_Id,
NULL, asset_id,
FND_API.G_MISS_NUM, null,
X_Asset_Id),
deprn_run_date = decode(X_Deprn_Run_Date,
NULL, deprn_run_date,
X_Deprn_Run_Date),
deprn_amount = decode(X_Deprn_Amount,
NULL, deprn_amount,
FND_API.G_MISS_NUM, null,
X_Deprn_Amount),
ytd_deprn = decode(X_Ytd_Deprn,
NULL, ytd_deprn,
FND_API.G_MISS_NUM, null,
X_Ytd_Deprn),
deprn_reserve = decode(X_Deprn_Reserve,
NULL, deprn_reserve,
FND_API.G_MISS_NUM, null,
X_Deprn_Reserve),
deprn_source_code = decode(X_Deprn_Source_Code,
NULL, deprn_source_code,
FND_API.G_MISS_CHAR, null,
X_Deprn_Source_Code),
adjusted_cost = decode(X_Adjusted_Cost,
NULL, adjusted_cost,
FND_API.G_MISS_NUM, null,
X_Adjusted_Cost),
bonus_rate = decode(X_Bonus_Rate,
NULL, bonus_rate,
FND_API.G_MISS_NUM, null,
X_Bonus_Rate),
ltd_production = decode(X_Ltd_Production,
NULL, ltd_production,
FND_API.G_MISS_NUM, null,
X_Ltd_Production),
period_counter = decode(X_Period_Counter,
NULL, period_counter,
FND_API.G_MISS_NUM, null,
X_Period_Counter),
production = decode(X_Production,
NULL, production,
FND_API.G_MISS_NUM, null,
X_Production),
reval_amortization = decode(X_Reval_Amortization,
NULL, reval_amortization,
FND_API.G_MISS_NUM, null,
X_Reval_Amortization),
reval_amortization_basis = decode(X_Reval_Amortization_Basis,
NULL, reval_amortization_basis,
FND_API.G_MISS_NUM, null,
X_Reval_Amortization_Basis),
reval_deprn_expense = decode(X_Reval_Deprn_Expense,
NULL, reval_deprn_expense,
FND_API.G_MISS_NUM, null,
X_Reval_Deprn_Expense),
reval_reserve = decode(X_Reval_Reserve,
NULL, reval_reserve,
FND_API.G_MISS_NUM, null,
X_Reval_Reserve),
ytd_production = decode(X_Ytd_Production,
NULL, ytd_production,
FND_API.G_MISS_NUM, null,
X_Ytd_Production),
ytd_reval_deprn_expense = decode(X_Ytd_Reval_Deprn_Expense,
NULL, ytd_reval_deprn_expense,
FND_API.G_MISS_NUM, null,
X_Ytd_Reval_Deprn_Expense),
bonus_deprn_amount = decode(X_Bonus_Deprn_Amount,
NULL, bonus_deprn_amount,
FND_API.G_MISS_NUM, null,
X_Bonus_Deprn_Amount),
bonus_ytd_deprn = decode(X_Bonus_Ytd_Deprn,
NULL, bonus_ytd_deprn,
FND_API.G_MISS_NUM, null,
X_Bonus_Ytd_Deprn),
bonus_deprn_reserve = decode(X_Bonus_Deprn_Reserve,
NULL, bonus_deprn_reserve,
FND_API.G_MISS_NUM, null,
X_Bonus_Deprn_Reserve)
WHERE book_type_code = X_Book_Type_Code
and asset_id = X_Asset_Id
and period_counter = X_Period_Counter;
UPDATE fa_deprn_summary
SET
book_type_code = decode(X_Book_Type_Code,
NULL, book_type_code,
FND_API.G_MISS_CHAR, null,
X_Book_Type_Code),
asset_id = decode(X_Asset_Id,
NULL, asset_id,
FND_API.G_MISS_NUM, null,
X_Asset_Id),
deprn_run_date = decode(X_Deprn_Run_Date,
NULL, deprn_run_date,
X_Deprn_Run_Date),
deprn_amount = decode(X_Deprn_Amount,
NULL, deprn_amount,
FND_API.G_MISS_NUM, null,
X_Deprn_Amount),
ytd_deprn = decode(X_Ytd_Deprn,
NULL, ytd_deprn,
FND_API.G_MISS_NUM, null,
X_Ytd_Deprn),
deprn_reserve = decode(X_Deprn_Reserve,
NULL, deprn_reserve,
FND_API.G_MISS_NUM, null,
X_Deprn_Reserve),
deprn_source_code = decode(X_Deprn_Source_Code,
NULL, deprn_source_code,
FND_API.G_MISS_CHAR, null,
X_Deprn_Source_Code),
adjusted_cost = decode(X_Adjusted_Cost,
NULL, adjusted_cost,
FND_API.G_MISS_NUM, null,
X_Adjusted_Cost),
bonus_rate = decode(X_Bonus_Rate,
NULL, bonus_rate,
FND_API.G_MISS_NUM, null,
X_Bonus_Rate),
ltd_production = decode(X_Ltd_Production,
NULL, ltd_production,
FND_API.G_MISS_NUM, null,
X_Ltd_Production),
period_counter = decode(X_Period_Counter,
NULL, period_counter,
FND_API.G_MISS_NUM, null,
X_Period_Counter),
production = decode(X_Production,
NULL, production,
FND_API.G_MISS_NUM, null,
X_Production),
reval_amortization = decode(X_Reval_Amortization,
NULL, reval_amortization,
FND_API.G_MISS_NUM, null,
X_Reval_Amortization),
reval_amortization_basis = decode(X_Reval_Amortization_Basis,
NULL, reval_amortization_basis,
FND_API.G_MISS_NUM, null,
X_Reval_Amortization_Basis),
reval_deprn_expense = decode(X_Reval_Deprn_Expense,
NULL, reval_deprn_expense,
FND_API.G_MISS_NUM, null,
X_Reval_Deprn_Expense),
reval_reserve = decode(X_Reval_Reserve,
NULL, reval_reserve,
FND_API.G_MISS_NUM, null,
X_Reval_Reserve),
ytd_production = decode(X_Ytd_Production,
NULL, ytd_production,
FND_API.G_MISS_NUM, null,
X_Ytd_Production),
ytd_reval_deprn_expense = decode(X_Ytd_Reval_Deprn_Expense,
NULL, ytd_reval_deprn_expense,
FND_API.G_MISS_NUM, null,
X_Ytd_Reval_Deprn_Expense),
bonus_deprn_amount = decode(X_Bonus_Deprn_Amount,
NULL, bonus_deprn_amount,
FND_API.G_MISS_NUM, null,
X_Bonus_Deprn_Amount),
bonus_ytd_deprn = decode(X_Bonus_Ytd_Deprn,
NULL, bonus_ytd_deprn,
FND_API.G_MISS_NUM, null,
X_Bonus_Ytd_Deprn),
bonus_deprn_reserve = decode(X_Bonus_Deprn_Reserve,
NULL, bonus_deprn_reserve,
FND_API.G_MISS_NUM, null,
X_Bonus_Deprn_Reserve)
WHERE book_type_code = X_Book_Type_Code
and asset_id = X_Asset_Id
and period_counter = X_Period_Counter;
calling_fn => 'fa_deprn_summary_pkg.update_row'
,p_log_level_rec => p_log_level_rec);
END Update_Row;
PROCEDURE Delete_Row(X_Rowid VARCHAR2 DEFAULT NULL,
X_Asset_Id NUMBER DEFAULT NULL,
X_mrc_sob_type_code VARCHAR2 DEFAULT 'P',
X_Calling_Fn VARCHAR2,
p_log_level_rec in fa_api_types.log_level_rec_type default null) IS
BEGIN
if (X_mrc_sob_type_code = 'R') then
if X_Rowid is not null then
DELETE FROM fa_deprn_summary_mrc_v
WHERE rowid = X_Rowid;
DELETE FROM fa_deprn_summary_mrc_v
WHERE asset_id = X_Asset_Id;
DELETE FROM fa_deprn_summary
WHERE rowid = X_Rowid;
DELETE FROM fa_deprn_summary
WHERE asset_id = X_Asset_Id;
CALLED_FN => 'fa_deprn_summary_pkg.delete_row',
CALLING_FN => X_Calling_Fn
,p_log_level_rec => p_log_level_rec);
END Delete_Row;
SELECT book_type_code,
asset_id,
date_placed_in_service,
date_effective,
deprn_start_date,
deprn_method_code,
life_in_months,
rate_adjustment_factor,
adjusted_cost,
cost,
original_cost,
salvage_value,
prorate_convention_code,
prorate_date,
cost_change_flag,
adjustment_required_status,
capitalize_flag,
retirement_pending_flag,
depreciate_flag,
last_update_date,
last_updated_by,
date_ineffective,
transaction_header_id_in,
transaction_header_id_out,
itc_amount_id,
itc_amount,
retirement_id,
tax_request_id,
itc_basis,
basic_rate,
adjusted_rate,
bonus_rule,
ceiling_name,
recoverable_cost,
last_update_login,
adjusted_capacity,
fully_rsvd_revals_counter,
idled_flag,
period_counter_capitalized,
period_counter_fully_reserved,
period_counter_fully_retired,
production_capacity,
reval_amortization_basis,
reval_ceiling,
unit_of_measure,
unrevalued_cost,
annual_deprn_rounding_flag,
percent_salvage_value,
allowed_deprn_limit,
allowed_deprn_limit_amount,
period_counter_life_complete,
adjusted_recoverable_cost,
annual_rounding_flag,
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,
eofy_adj_cost,
short_fiscal_year_flag,
conversion_date,
remaining_life1,
remaining_life2,
original_deprn_start_date,
old_adjusted_cost,
formula_factor,
eofy_formula_factor
FROM fa_books
WHERE Book_Type_Code = nvl(X_Book_Type_Code, Book_Type_Code)
AND Asset_Id = X_Asset_Id
AND Date_Ineffective is null
FOR UPDATE of Asset_Id NOWAIT;
SELECT asset_id,
category_id,
asset_type,
units,
date_effective,
date_ineffective,
transaction_header_id_in,
transaction_header_id_out,
last_update_date,
last_updated_by,
last_update_login
FROM fa_asset_history
WHERE Asset_Id = X_Asset_Id
AND Date_Ineffective is null
FOR UPDATE of Asset_Id NOWAIT;
SELECT distribution_id,
book_type_code,
asset_id,
units_assigned,
date_effective,
code_combination_id,
location_id,
transaction_header_id_in,
last_update_date,
last_updated_by,
date_ineffective,
assigned_to,
transaction_header_id_out,
transaction_units,
retirement_id,
last_update_login
FROM fa_distribution_history
WHERE Asset_Id = X_Asset_Id
AND Date_Ineffective is null
FOR UPDATE of Asset_Id NOWAIT;
SELECT book_type_code,
asset_id,
deprn_run_date,
deprn_amount,
ytd_deprn,
deprn_reserve,
deprn_source_code,
adjusted_cost,
bonus_rate,
ltd_production,
period_counter,
production,
reval_amortization,
reval_amortization_basis,
reval_deprn_expense,
reval_reserve,
ytd_production,
ytd_reval_deprn_expense,
prior_fy_expense
FROM fa_deprn_summary
WHERE Book_Type_Code = nvl(X_Book_Type_Code, Book_Type_Code)
AND Asset_Id = X_Asset_Id
AND Deprn_Source_Code = 'BOOKS'
FOR UPDATE of Asset_Id NOWAIT;
FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');