[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT DP.FISCAL_YEAR, MAX(DP.PERIOD_NUM),MAX(DP.PERIOD_COUNTER)
FROM FA_DEPRN_PERIODS DP
WHERE DP.BOOK_TYPE_CODE = p_book_type_code
AND DP.FISCAL_YEAR > p_fiscal_year
AND DP.PERIOD_CLOSE_DATE IS NOT NULL
GROUP BY DP.FISCAL_YEAR
ORDER BY MIN(DP.PERIOD_OPEN_DATE);
select fa_transaction_headers_s.nextval
into px_trans_rec.transaction_header_id
from dual;
FA_TRANSACTION_HEADERS_PKG.Insert_Row
(X_Rowid => l_th_rowid,
X_Transaction_Header_Id => px_trans_rec.transaction_header_id,
X_Book_Type_Code => px_asset_hdr_rec.book_type_code,
X_Asset_Id => px_asset_hdr_rec.asset_id,
X_Transaction_Type_Code => px_trans_rec.transaction_type_code,
X_Transaction_Date_Entered => px_trans_rec.transaction_date_entered,
X_Date_Effective => px_trans_rec.who_info.creation_date,
X_Last_Update_Date => px_trans_rec.who_info.last_update_date,
X_Last_Updated_By => px_trans_rec.who_info.last_updated_by,
X_Transaction_Name => px_trans_rec.transaction_name,
X_Invoice_Transaction_Id => NULL,
X_Source_Transaction_Header_Id => px_trans_rec.Source_Transaction_Header_Id,
X_Mass_Reference_Id => px_trans_rec.mass_reference_id,
X_Last_Update_Login => px_trans_rec.who_info.last_update_login,
X_Transaction_Subtype => px_trans_rec.transaction_subtype,
X_Attribute1 => px_trans_rec.desc_flex.attribute1,
X_Attribute2 => px_trans_rec.desc_flex.attribute2,
X_Attribute3 => px_trans_rec.desc_flex.attribute3,
X_Attribute4 => px_trans_rec.desc_flex.attribute4,
X_Attribute5 => px_trans_rec.desc_flex.attribute5,
X_Attribute6 => px_trans_rec.desc_flex.attribute6,
X_Attribute7 => px_trans_rec.desc_flex.attribute7,
X_Attribute8 => px_trans_rec.desc_flex.attribute8,
X_Attribute9 => px_trans_rec.desc_flex.attribute9,
X_Attribute10 => px_trans_rec.desc_flex.attribute10,
X_Attribute11 => px_trans_rec.desc_flex.attribute11,
X_Attribute12 => px_trans_rec.desc_flex.attribute12,
X_Attribute13 => px_trans_rec.desc_flex.attribute13,
X_Attribute14 => px_trans_rec.desc_flex.attribute14,
X_Attribute15 => px_trans_rec.desc_flex.attribute15,
X_Attribute_Category_Code => px_trans_rec.desc_flex.attribute_category_code,
X_Transaction_Key => px_trans_rec.transaction_key,
X_Amortization_Start_Date => px_trans_rec.amortization_start_date,
X_Calling_Interface => px_trans_rec.calling_interface,
X_Mass_Transaction_ID => px_trans_rec.mass_transaction_id,
X_Member_Transaction_Header_Id => px_trans_rec.member_transaction_header_id,
X_Trx_Reference_Id => px_trans_rec.trx_reference_id,
X_event_Id => px_trans_rec.event_id,
X_Return_Status => l_status,
X_Calling_Fn => l_calling_fn,
p_log_level_rec => p_log_level_rec
);
* Insert the adjustment row for the first fiscal year adjusted
* using the Insert into FA_ADJUSTMENTS function*/
/*
* Bug 4597471 -- only when the run_mode is 'RUN' we need to insert into FA_ADJUSTMENTS
*
*/
if (l_asset_tax_rsv_adj_rec.run_mode = 'RUN') then
l_adj.transaction_header_id := l_fin_info.transaction_id;
l_adj.last_update_date := l_fin_info.current_time;
l_adj.selection_mode := fa_std_types.FA_AJ_ACTIVE;
* (We don't want to insert any more FA_ADJUSTMENTS rows, and
* don't want to terminate and insert FA_BOOKS rows, for non NBV-based
* assets unless asset is no longer fully reserved.
*/
if l_deprn_basis_rule = fa_std_types.FAD_DBR_COST then
If (( l_asset_fin_rec.period_counter_fully_reserved > 0 ) and
( l_new_dpr_rsv < l_fin_info.rec_cost ))then
If (l_asset_tax_rsv_adj_rec.deprn_basis_formula = 'STRICT_FLAT' ) then
l_annual_deprn_rounding_flag := l_asset_fin_rec.annual_deprn_rounding_flag;
-- terminate/insert fa_books rows
-- terminate the active row
fa_books_pkg.deactivate_row
(X_asset_id => px_asset_hdr_rec.asset_id,
X_book_type_code => px_asset_hdr_rec.book_type_code,
X_transaction_header_id_out => px_trans_rec.transaction_header_id,
X_date_ineffective => px_trans_rec.who_info.last_update_date,
X_mrc_sob_type_code => l_reporting_flag,
X_Calling_Fn => l_calling_fn,
p_log_level_rec => p_log_level_rec
);
fa_books_pkg.insert_row
(X_Rowid => l_bks_rowid,
X_Book_Type_Code => px_asset_hdr_rec.book_type_code,
X_Asset_Id => px_asset_hdr_rec.asset_id,
X_Date_Placed_In_Service => l_asset_fin_rec.date_placed_in_service,
X_Date_Effective => px_trans_rec.who_info.last_update_date,
X_Deprn_Start_Date => l_asset_fin_rec.deprn_start_date,
X_Deprn_Method_Code => l_asset_fin_rec.deprn_method_code,
X_Life_In_Months => l_asset_fin_rec.life_in_months,
X_Rate_Adjustment_Factor => l_fin_info.rate_adj_factor, -- MVK will change.
X_Adjusted_Cost => l_fin_info.adj_cost, -- MVK will change.
X_Cost => l_asset_fin_rec.cost,
X_Original_Cost => l_asset_fin_rec.original_cost,
X_Salvage_Value => l_asset_fin_rec.salvage_value,
X_Prorate_Convention_Code => l_asset_fin_rec.prorate_convention_code,
X_Prorate_Date => l_asset_fin_rec.prorate_date,
X_Cost_Change_Flag => l_asset_fin_rec.cost_change_flag,
X_Adjustment_Required_Status => l_asset_fin_rec.adjustment_required_status,
X_Capitalize_Flag => l_asset_fin_rec.capitalize_flag,
X_Retirement_Pending_Flag => l_asset_fin_rec.retirement_pending_flag,
X_Depreciate_Flag => l_asset_fin_rec.depreciate_flag,
X_Disabled_Flag => l_asset_fin_rec.disabled_flag,--HH
X_Last_Update_Date => px_trans_rec.who_info.last_update_date,
X_Last_Updated_By => px_trans_rec.who_info.last_updated_by,
X_Date_Ineffective => NULL, -- MVK will change.
X_Transaction_Header_Id_In => l_fin_info.transaction_id, -- MVK will change.
X_Transaction_Header_Id_Out => NULL, -- MVK will change.
X_Itc_Amount_Id => l_asset_fin_rec.itc_amount_id,
X_Itc_Amount => l_asset_fin_rec.itc_amount,
X_Retirement_Id => l_asset_fin_rec.retirement_id,
X_Tax_Request_Id => l_asset_fin_rec.tax_request_id,
X_Itc_Basis => l_asset_fin_rec.itc_basis,
X_Basic_Rate => l_asset_fin_rec.basic_rate,
X_Adjusted_Rate => l_asset_fin_rec.adjusted_rate,
X_Bonus_Rule => l_asset_fin_rec.bonus_rule,
X_Ceiling_Name => l_asset_fin_rec.ceiling_name,
X_Recoverable_Cost => l_asset_fin_rec.recoverable_cost,
X_Last_Update_Login => px_trans_rec.who_info.last_update_login,
X_Adjusted_Capacity => l_asset_fin_rec.adjusted_capacity,
X_Fully_Rsvd_Revals_Counter => l_asset_fin_rec.fully_rsvd_revals_counter,
X_Idled_Flag => l_asset_fin_rec.idled_flag,
X_Period_Counter_Capitalized => l_asset_fin_rec.period_counter_capitalized,
X_PC_Fully_Reserved => l_asset_fin_rec.period_counter_fully_reserved, -- MVK will change
X_Period_Counter_Fully_Retired => l_asset_fin_rec.period_counter_fully_retired,
X_Production_Capacity => l_asset_fin_rec.production_capacity,
X_Reval_Amortization_Basis => l_asset_fin_rec.reval_amortization_basis,
X_Reval_Ceiling => l_asset_fin_rec.reval_ceiling,
X_Unit_Of_Measure => l_asset_fin_rec.unit_of_measure,
X_Unrevalued_Cost => l_asset_fin_rec.unrevalued_cost,
X_Annual_Deprn_Rounding_Flag => l_annual_deprn_rounding_flag, -- MVK will change
X_Percent_Salvage_Value => l_asset_fin_rec.percent_salvage_value,
X_Allowed_Deprn_Limit => l_asset_fin_rec.allowed_deprn_limit,
X_Allowed_Deprn_Limit_Amount => l_asset_fin_rec.allowed_deprn_limit_amount,
X_Period_Counter_Life_Complete => l_asset_fin_rec.period_counter_life_complete,
X_Adjusted_Recoverable_Cost => l_asset_fin_rec.adjusted_recoverable_cost,
X_Short_Fiscal_Year_Flag => l_asset_fin_rec.short_fiscal_year_flag,
X_Conversion_Date => l_asset_fin_rec.conversion_date,
X_Orig_Deprn_Start_Date => l_asset_fin_rec.orig_deprn_start_date,
X_Remaining_Life1 => l_asset_fin_rec.remaining_life1,
X_Remaining_Life2 => l_asset_fin_rec.remaining_life2,
X_Old_Adj_Cost => l_asset_fin_rec.old_adjusted_cost,
X_Formula_Factor => l_asset_fin_rec.formula_factor,
X_gf_Attribute1 => l_asset_fin_rec.global_attribute1,
X_gf_Attribute2 => l_asset_fin_rec.global_attribute2,
X_gf_Attribute3 => l_asset_fin_rec.global_attribute3,
X_gf_Attribute4 => l_asset_fin_rec.global_attribute4,
X_gf_Attribute5 => l_asset_fin_rec.global_attribute5,
X_gf_Attribute6 => l_asset_fin_rec.global_attribute6,
X_gf_Attribute7 => l_asset_fin_rec.global_attribute7,
X_gf_Attribute8 => l_asset_fin_rec.global_attribute8,
X_gf_Attribute9 => l_asset_fin_rec.global_attribute9,
X_gf_Attribute10 => l_asset_fin_rec.global_attribute10,
X_gf_Attribute11 => l_asset_fin_rec.global_attribute11,
X_gf_Attribute12 => l_asset_fin_rec.global_attribute12,
X_gf_Attribute13 => l_asset_fin_rec.global_attribute13,
X_gf_Attribute14 => l_asset_fin_rec.global_attribute14,
X_gf_Attribute15 => l_asset_fin_rec.global_attribute15,
X_gf_Attribute16 => l_asset_fin_rec.global_attribute16,
X_gf_Attribute17 => l_asset_fin_rec.global_attribute17,
X_gf_Attribute18 => l_asset_fin_rec.global_attribute18,
X_gf_Attribute19 => l_asset_fin_rec.global_attribute19,
X_gf_Attribute20 => l_asset_fin_rec.global_attribute20,
X_global_attribute_category => l_asset_fin_rec.global_attribute_category,
X_group_asset_id => l_asset_fin_rec.group_asset_id,
X_salvage_type => l_asset_fin_rec.salvage_type,
X_deprn_limit_type => l_asset_fin_rec.deprn_limit_type,
X_over_depreciate_option => l_asset_fin_rec.over_depreciate_option,
X_super_group_id => l_asset_fin_rec.super_group_id,
X_reduction_rate => l_asset_fin_rec.reduction_rate,
X_reduce_addition_flag => l_asset_fin_rec.reduce_addition_flag,
X_reduce_adjustment_flag => l_asset_fin_rec.reduce_adjustment_flag,
X_reduce_retirement_flag => l_asset_fin_rec.reduce_retirement_flag,
X_recognize_gain_loss => l_asset_fin_rec.recognize_gain_loss,
X_recapture_reserve_flag => l_asset_fin_rec.recapture_reserve_flag,
X_limit_proceeds_flag => l_asset_fin_rec.limit_proceeds_flag,
X_terminal_gain_loss => l_asset_fin_rec.terminal_gain_loss,
X_exclude_proceeds_from_basis => l_asset_fin_rec.exclude_proceeds_from_basis,
X_retirement_deprn_option => l_asset_fin_rec.retirement_deprn_option,
X_tracking_method => l_asset_fin_rec.tracking_method,
X_allocate_to_fully_rsv_flag => l_asset_fin_rec.allocate_to_fully_rsv_flag,
X_allocate_to_fully_ret_flag => l_asset_fin_rec.allocate_to_fully_ret_flag,
X_exclude_fully_rsv_flag => l_asset_fin_rec.exclude_fully_rsv_flag,
X_excess_allocation_option => l_asset_fin_rec.excess_allocation_option,
X_depreciation_option => l_asset_fin_rec.depreciation_option,
X_member_rollup_flag => l_asset_fin_rec.member_rollup_flag,
X_ytd_proceeds => nvl(l_asset_fin_rec.ytd_proceeds, 0),
X_ltd_proceeds => nvl(l_asset_fin_rec.ltd_proceeds, 0),
X_eofy_reserve => l_asset_fin_rec.eofy_reserve,
X_terminal_gain_loss_amount => l_asset_fin_rec.terminal_gain_loss_amount,
X_ltd_cost_of_removal => nvl(l_asset_fin_rec.ltd_cost_of_removal, 0),
X_mrc_sob_type_code => l_reporting_flag,
X_Return_Status => l_status,
X_Calling_Fn => l_calling_fn,
p_log_level_rec => p_log_level_rec
);
* Call the Insert into FA_ADJUSTMENTS function
* for EXPENSE adjustment; use the CCID from FA_DISTRIBUTION_HISTORY,
/* Bug 4597471 -- insert into FA_ADJUSTMENTS only if the run_mode is 'RUN' */
if (l_asset_tax_rsv_adj_rec.run_mode = 'RUN') then
l_adj.last_update_date := l_fin_info.current_time;
l_adj.selection_mode := fa_std_types.FA_AJ_ACTIVE;
* terminate the current FA_BOOKS row; and insert a new one, with
* the updated adjusted cost and rate adjustment factor
* we only do this for assets with an NBV-based deprn method
* and if this is not the year of adjustment
*/
if l_new_dpr_rsv < l_fin_info.rec_cost then
l_rsv_flag := TRUE;
X_date_ineffective => px_trans_rec.who_info.last_update_date,
X_mrc_sob_type_code => l_reporting_flag,
X_Calling_Fn => l_calling_fn,
p_log_level_rec => p_log_level_rec
);
fa_books_pkg.insert_row
(X_Rowid => l_bks_rowid,
X_Book_Type_Code => px_asset_hdr_rec.book_type_code,
X_Asset_Id => px_asset_hdr_rec.asset_id,
X_Date_Placed_In_Service => l_asset_fin_rec.date_placed_in_service,
X_Date_Effective => px_trans_rec.who_info.last_update_date,
X_Deprn_Start_Date => l_asset_fin_rec.deprn_start_date,
X_Deprn_Method_Code => l_asset_fin_rec.deprn_method_code,
X_Life_In_Months => l_asset_fin_rec.life_in_months,
X_Rate_Adjustment_Factor => l_fin_info.rate_adj_factor, -- MVK will change.
X_Adjusted_Cost => l_fin_info.adj_cost, -- MVK will change.
X_Cost => l_asset_fin_rec.cost,
X_Original_Cost => l_asset_fin_rec.original_cost,
X_Salvage_Value => l_asset_fin_rec.salvage_value,
X_Prorate_Convention_Code => l_asset_fin_rec.prorate_convention_code,
X_Prorate_Date => l_asset_fin_rec.prorate_date,
X_Cost_Change_Flag => l_asset_fin_rec.cost_change_flag,
X_Adjustment_Required_Status => l_asset_fin_rec.adjustment_required_status,
X_Capitalize_Flag => l_asset_fin_rec.capitalize_flag,
X_Retirement_Pending_Flag => l_asset_fin_rec.retirement_pending_flag,
X_Depreciate_Flag => l_asset_fin_rec.depreciate_flag,
X_Disabled_Flag => l_asset_fin_rec.disabled_flag,--HH
X_Last_Update_Date => px_trans_rec.who_info.last_update_date,
X_Last_Updated_By => px_trans_rec.who_info.last_updated_by,
X_Date_Ineffective => NULL, -- MVK will change.
X_Transaction_Header_Id_In => px_trans_rec.transaction_header_id, -- MVK will change.
X_Transaction_Header_Id_Out => NULL, -- MVK will change.
X_Itc_Amount_Id => l_asset_fin_rec.itc_amount_id,
X_Itc_Amount => l_asset_fin_rec.itc_amount,
X_Retirement_Id => l_asset_fin_rec.retirement_id,
X_Tax_Request_Id => l_asset_fin_rec.tax_request_id,
X_Itc_Basis => l_asset_fin_rec.itc_basis,
X_Basic_Rate => l_asset_fin_rec.basic_rate,
X_Adjusted_Rate => l_asset_fin_rec.adjusted_rate,
X_Bonus_Rule => l_asset_fin_rec.bonus_rule,
X_Ceiling_Name => l_asset_fin_rec.ceiling_name,
X_Recoverable_Cost => l_asset_fin_rec.recoverable_cost,
X_Last_Update_Login => px_trans_rec.who_info.last_update_login,
X_Adjusted_Capacity => l_asset_fin_rec.adjusted_capacity,
X_Fully_Rsvd_Revals_Counter => l_asset_fin_rec.fully_rsvd_revals_counter,
X_Idled_Flag => l_asset_fin_rec.idled_flag,
X_Period_Counter_Capitalized => l_asset_fin_rec.period_counter_capitalized,
X_PC_Fully_Reserved => l_asset_fin_rec.period_counter_fully_reserved, -- MVK will change
X_Period_Counter_Fully_Retired => l_asset_fin_rec.period_counter_fully_retired,
X_Production_Capacity => l_asset_fin_rec.production_capacity,
X_Reval_Amortization_Basis => l_asset_fin_rec.reval_amortization_basis,
X_Reval_Ceiling => l_asset_fin_rec.reval_ceiling,
X_Unit_Of_Measure => l_asset_fin_rec.unit_of_measure,
X_Unrevalued_Cost => l_asset_fin_rec.unrevalued_cost,
X_Annual_Deprn_Rounding_Flag => l_annual_deprn_rounding_flag, -- MVK will change
X_Percent_Salvage_Value => l_asset_fin_rec.percent_salvage_value,
X_Allowed_Deprn_Limit => l_asset_fin_rec.allowed_deprn_limit,
X_Allowed_Deprn_Limit_Amount => l_asset_fin_rec.allowed_deprn_limit_amount,
X_Period_Counter_Life_Complete => l_asset_fin_rec.period_counter_life_complete,
X_Adjusted_Recoverable_Cost => l_asset_fin_rec.adjusted_recoverable_cost,
X_Short_Fiscal_Year_Flag => l_asset_fin_rec.short_fiscal_year_flag,
X_Conversion_Date => l_asset_fin_rec.conversion_date,
X_Orig_Deprn_Start_Date => l_asset_fin_rec.orig_deprn_start_date,
X_Remaining_Life1 => l_asset_fin_rec.remaining_life1,
X_Remaining_Life2 => l_asset_fin_rec.remaining_life2,
X_Old_Adj_Cost => l_asset_fin_rec.old_adjusted_cost,
X_Formula_Factor => l_asset_fin_rec.formula_factor,
X_gf_Attribute1 => l_asset_fin_rec.global_attribute1,
X_gf_Attribute2 => l_asset_fin_rec.global_attribute2,
X_gf_Attribute3 => l_asset_fin_rec.global_attribute3,
X_gf_Attribute4 => l_asset_fin_rec.global_attribute4,
X_gf_Attribute5 => l_asset_fin_rec.global_attribute5,
X_gf_Attribute6 => l_asset_fin_rec.global_attribute6,
X_gf_Attribute7 => l_asset_fin_rec.global_attribute7,
X_gf_Attribute8 => l_asset_fin_rec.global_attribute8,
X_gf_Attribute9 => l_asset_fin_rec.global_attribute9,
X_gf_Attribute10 => l_asset_fin_rec.global_attribute10,
X_gf_Attribute11 => l_asset_fin_rec.global_attribute11,
X_gf_Attribute12 => l_asset_fin_rec.global_attribute12,
X_gf_Attribute13 => l_asset_fin_rec.global_attribute13,
X_gf_Attribute14 => l_asset_fin_rec.global_attribute14,
X_gf_Attribute15 => l_asset_fin_rec.global_attribute15,
X_gf_Attribute16 => l_asset_fin_rec.global_attribute16,
X_gf_Attribute17 => l_asset_fin_rec.global_attribute17,
X_gf_Attribute18 => l_asset_fin_rec.global_attribute18,
X_gf_Attribute19 => l_asset_fin_rec.global_attribute19,
X_gf_Attribute20 => l_asset_fin_rec.global_attribute20,
X_global_attribute_category => l_asset_fin_rec.global_attribute_category,
X_group_asset_id => l_asset_fin_rec.group_asset_id,
X_salvage_type => l_asset_fin_rec.salvage_type,
X_deprn_limit_type => l_asset_fin_rec.deprn_limit_type,
X_over_depreciate_option => l_asset_fin_rec.over_depreciate_option,
X_super_group_id => l_asset_fin_rec.super_group_id,
X_reduction_rate => l_asset_fin_rec.reduction_rate,
X_reduce_addition_flag => l_asset_fin_rec.reduce_addition_flag,
X_reduce_adjustment_flag => l_asset_fin_rec.reduce_adjustment_flag,
X_reduce_retirement_flag => l_asset_fin_rec.reduce_retirement_flag,
X_recognize_gain_loss => l_asset_fin_rec.recognize_gain_loss,
X_recapture_reserve_flag => l_asset_fin_rec.recapture_reserve_flag,
X_limit_proceeds_flag => l_asset_fin_rec.limit_proceeds_flag,
X_terminal_gain_loss => l_asset_fin_rec.terminal_gain_loss,
X_exclude_proceeds_from_basis => l_asset_fin_rec.exclude_proceeds_from_basis,
X_retirement_deprn_option => l_asset_fin_rec.retirement_deprn_option,
X_tracking_method => l_asset_fin_rec.tracking_method,
X_allocate_to_fully_rsv_flag => l_asset_fin_rec.allocate_to_fully_rsv_flag,
X_allocate_to_fully_ret_flag => l_asset_fin_rec.allocate_to_fully_ret_flag,
X_exclude_fully_rsv_flag => l_asset_fin_rec.exclude_fully_rsv_flag,
X_excess_allocation_option => l_asset_fin_rec.excess_allocation_option,
X_depreciation_option => l_asset_fin_rec.depreciation_option,
X_member_rollup_flag => l_asset_fin_rec.member_rollup_flag,
X_ytd_proceeds => nvl(l_asset_fin_rec.ytd_proceeds, 0),
X_ltd_proceeds => nvl(l_asset_fin_rec.ltd_proceeds, 0),
X_eofy_reserve => l_asset_fin_rec.eofy_reserve,
X_terminal_gain_loss_amount => l_asset_fin_rec.terminal_gain_loss_amount,
X_ltd_cost_of_removal => nvl(l_asset_fin_rec.ltd_cost_of_removal, 0),
X_mrc_sob_type_code => l_reporting_flag,
X_Return_Status => l_status,
X_Calling_Fn => l_calling_fn,
p_log_level_rec => p_log_level_rec
);
/* Bug 4597471 -- for PREVIEW mode insert into interface table so that the preview report can just pick the
values from the interface table */
if not fa_utils_pkg.faxrnd
(x_amount => l_asset_tax_rsv_adj_rec.adjusted_ytd_deprn,
x_book => px_asset_hdr_rec.book_type_code,
p_log_level_rec => p_log_level_rec
) then
raise tax_rsv_adj_err;
insert into fa_mass_tax_adj_rep_t
(MASS_TAX_ADJ_ID ,
REQUEST_ID ,
ADJUSTED_BOOK_TYPE_CODE ,
ASSET_ID ,
ASSET_NUMBER ,
DESCRIPTION ,
DEPRN_RESERVE_ACCT ,
ASSET_COST_ACCT ,
COST ,
OLD_YTD_DEPRN ,
ADJ_YTD_DEPRN ,
NEW_YTD_DEPRN ,
LAST_UPDATE_DATE ,
LAST_UPDATED_BY ,
CREATED_BY ,
CREATION_DATE ,
LAST_UPDATE_LOGIN )
values
(px_trans_rec.mass_transaction_id ,
px_trans_rec.mass_reference_id ,
px_asset_hdr_rec.book_type_code ,
px_asset_hdr_rec.asset_id ,
p_asset_desc_rec.asset_number ,
p_asset_desc_rec.description ,
l_rsv_acct ,
l_cost_acct ,
l_asset_fin_rec.cost ,
l_old_ytd_deprn ,--old_ytd
l_asset_tax_rsv_adj_rec.adjusted_ytd_deprn - l_old_ytd_deprn,--adj_ytd
l_asset_tax_rsv_adj_rec.adjusted_ytd_deprn,--new_ytd_deprn
px_trans_rec.who_info.last_update_date ,
px_trans_rec.who_info.last_updated_by ,
px_trans_rec.who_info.last_updated_by ,
px_trans_rec.who_info.last_update_date ,
px_trans_rec.who_info.last_update_login );