eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_TRANS_API_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 30


     p_last_update_date             IN     DATE,
     p_last_updated_by              IN     NUMBER,
     p_created_by                   IN     NUMBER,
     p_creation_date                IN     DATE,
     p_last_update_login            IN     NUMBER,
     p_attribute1                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute2                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute3                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute4                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute5                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute6                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute7                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute8                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute9                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute10                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute11                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute12                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute13                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute14                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute15                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute_category_code      IN     VARCHAR2 DEFAULT NULL,
     -- Transaction Info (Distributions) --
     p_dist_transaction_name        IN     VARCHAR2 DEFAULT NULL,
     p_dist_attribute1              IN     VARCHAR2 DEFAULT NULL,
     p_dist_attribute2              IN     VARCHAR2 DEFAULT NULL,
     p_dist_attribute3              IN     VARCHAR2 DEFAULT NULL,
     p_dist_attribute4              IN     VARCHAR2 DEFAULT NULL,
     p_dist_attribute5              IN     VARCHAR2 DEFAULT NULL,
     p_dist_attribute6              IN     VARCHAR2 DEFAULT NULL,
     p_dist_attribute7              IN     VARCHAR2 DEFAULT NULL,
     p_dist_attribute8              IN     VARCHAR2 DEFAULT NULL,
     p_dist_attribute9              IN     VARCHAR2 DEFAULT NULL,
     p_dist_attribute10             IN     VARCHAR2 DEFAULT NULL,
     p_dist_attribute11             IN     VARCHAR2 DEFAULT NULL,
     p_dist_attribute12             IN     VARCHAR2 DEFAULT NULL,
     p_dist_attribute13             IN     VARCHAR2 DEFAULT NULL,
     p_dist_attribute14             IN     VARCHAR2 DEFAULT NULL,
     p_dist_attribute15             IN     VARCHAR2 DEFAULT NULL,
     p_dist_attribute_category_code IN     VARCHAR2 DEFAULT NULL,
     -- Asset Header Info --
     p_asset_id                     IN     NUMBER   DEFAULT NULL,
     p_book_type_code               IN     VARCHAR2,
     p_set_of_books_id              IN     NUMBER   DEFAULT NULL,
     -- Asset Description Info --
     p_asset_number                 IN     VARCHAR2 DEFAULT NULL,
     p_description                  IN     VARCHAR2,
     p_tag_number                   IN     VARCHAR2 DEFAULT NULL,
     p_serial_number                IN     VARCHAR2 DEFAULT NULL,
     p_asset_key_ccid               IN     NUMBER   DEFAULT NULL,
     p_parent_asset_id              IN     NUMBER   DEFAULT NULL,
     p_status                       IN     VARCHAR2 DEFAULT NULL,
     p_manufacturer_name            IN     VARCHAR2 DEFAULT NULL,
     p_model_number                 IN     VARCHAR2 DEFAULT NULL,
     p_warranty_id                  IN     NUMBER   DEFAULT NULL,
     p_property_type_code           IN     VARCHAR2,
     p_property_1245_1250_code      IN     VARCHAR2,
     p_in_use_flag                  IN     VARCHAR2,
     p_inventorial                  IN     VARCHAR2 DEFAULT NULL,
     p_commitment	   	    IN     VARCHAR2 DEFAULT NULL,
     p_investment_law		    IN     VARCHAR2 DEFAULT NULL,
     p_owned_leased                 IN     VARCHAR2,
     p_new_used                     IN     VARCHAR2,
     p_lease_id                     IN     NUMBER   DEFAULT NULL,
     p_ls_attribute1                IN     VARCHAR2 DEFAULT NULL,
     p_ls_attribute2                IN     VARCHAR2 DEFAULT NULL,
     p_ls_attribute3                IN     VARCHAR2 DEFAULT NULL,
     p_ls_attribute4                IN     VARCHAR2 DEFAULT NULL,
     p_ls_attribute5                IN     VARCHAR2 DEFAULT NULL,
     p_ls_attribute6                IN     VARCHAR2 DEFAULT NULL,
     p_ls_attribute7                IN     VARCHAR2 DEFAULT NULL,
     p_ls_attribute8                IN     VARCHAR2 DEFAULT NULL,
     p_ls_attribute9                IN     VARCHAR2 DEFAULT NULL,
     p_ls_attribute10               IN     VARCHAR2 DEFAULT NULL,
     p_ls_attribute11               IN     VARCHAR2 DEFAULT NULL,
     p_ls_attribute12               IN     VARCHAR2 DEFAULT NULL,
     p_ls_attribute13               IN     VARCHAR2 DEFAULT NULL,
     p_ls_attribute14               IN     VARCHAR2 DEFAULT NULL,
     p_ls_attribute15               IN     VARCHAR2 DEFAULT NULL,
     p_ls_attribute_category_code   IN     VARCHAR2 DEFAULT NULL,
     p_ad_global_attribute1         IN     VARCHAR2 DEFAULT NULL,
     p_ad_global_attribute2         IN     VARCHAR2 DEFAULT NULL,
     p_ad_global_attribute3         IN     VARCHAR2 DEFAULT NULL,
     p_ad_global_attribute4         IN     VARCHAR2 DEFAULT NULL,
     p_ad_global_attribute5         IN     VARCHAR2 DEFAULT NULL,
     p_ad_global_attribute6         IN     VARCHAR2 DEFAULT NULL,
     p_ad_global_attribute7         IN     VARCHAR2 DEFAULT NULL,
     p_ad_global_attribute8         IN     VARCHAR2 DEFAULT NULL,
     p_ad_global_attribute9         IN     VARCHAR2 DEFAULT NULL,
     p_ad_global_attribute10        IN     VARCHAR2 DEFAULT NULL,
     p_ad_global_attribute11        IN     VARCHAR2 DEFAULT NULL,
     p_ad_global_attribute12        IN     VARCHAR2 DEFAULT NULL,
     p_ad_global_attribute13        IN     VARCHAR2 DEFAULT NULL,
     p_ad_global_attribute14        IN     VARCHAR2 DEFAULT NULL,
     p_ad_global_attribute15        IN     VARCHAR2 DEFAULT NULL,
     p_ad_global_attribute16        IN     VARCHAR2 DEFAULT NULL,
     p_ad_global_attribute17        IN     VARCHAR2 DEFAULT NULL,
     p_ad_global_attribute18        IN     VARCHAR2 DEFAULT NULL,
     p_ad_global_attribute19        IN     VARCHAR2 DEFAULT NULL,
     p_ad_global_attribute20        IN     VARCHAR2 DEFAULT NULL,
     p_ad_global_attribute_category IN     VARCHAR2 DEFAULT NULL,
     -- Asset Type Info --
     p_asset_type                   IN     VARCHAR2,
     -- Asset Category Info --
     p_category_id                  IN     NUMBER,
     p_cat_attribute1               IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute2               IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute3               IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute4               IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute5               IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute6               IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute7               IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute8               IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute9               IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute10              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute11              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute12              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute13              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute14              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute15              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute16              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute17              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute18              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute19              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute20              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute21              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute22              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute23              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute24              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute25              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute26              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute27              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute28              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute29              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute30              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute_category_code  IN     VARCHAR2 DEFAULT NULL,
     p_context                      IN     VARCHAR2 DEFAULT NULL,
     -- Asset Hierarchy Info --
     p_parent_hierarchy_id          IN     NUMBER   DEFAULT NULL,
     -- Asset Financial Info --
     p_cost                         IN     NUMBER,
     p_original_cost                IN     NUMBER,
     p_unrevalued_cost              IN     NUMBER   DEFAULT NULL,
     p_salvage_value                IN     NUMBER,
     p_ceiling_name                 IN     VARCHAR2 DEFAULT NULL,
     p_reval_ceiling                IN     NUMBER   DEFAULT NULL,
     p_depreciate_flag              IN     VARCHAR2,
     -- HH group ed.
     p_disabled_flag                IN     VARCHAR2 DEFAULT NULL,
     p_date_placed_in_service       IN     DATE,
     p_prorate_convention_code      IN     VARCHAR2,
     p_deprn_method_code            IN     VARCHAR2,
     p_life_in_months               IN     NUMBER   DEFAULT NULL,
     p_basic_rate                   IN     NUMBER   DEFAULT NULL,
     p_adjusted_rate                IN     NUMBER   DEFAULT NULL,
     p_production_capacity          IN     NUMBER   DEFAULT NULL,
     p_unit_of_measure              IN     VARCHAR2 DEFAULT NULL,
     p_bonus_rule                   IN     VARCHAR2 DEFAULT NULL,
     p_itc_amount_id                IN     NUMBER   DEFAULT NULL,
     p_short_fiscal_year_flag       IN     VARCHAR2 DEFAULT NULL,
     p_conversion_date              IN     DATE     DEFAULT NULL,
     p_orig_deprn_start_date        IN     DATE     DEFAULT NULL,
     p_group_asset_id               IN     NUMBER   DEFAULT NULL,
/* toru */
     -- Addition for Group Depreciation
     p_percent_salvage_value        IN     NUMBER   DEFAULT NULL,
     p_allowed_deprn_limit          IN     NUMBER   DEFAULT NULL,
     p_allowed_deprn_limit_amount   IN     NUMBER   DEFAULT NULL,
     p_super_group_id               IN     NUMBER   DEFAULT NULL,
     p_reduction_rate               IN     NUMBER   DEFAULT NULL,
     p_reduce_addition_flag         IN     VARCHAR2 DEFAULT NULL,
     p_reduce_adjustment_flag       IN     VARCHAR2 DEFAULT NULL,
     p_reduce_retirement_flag       IN     VARCHAR2 DEFAULT NULL,
     p_over_depreciate_option       IN     VARCHAR2 DEFAULT NULL,
     p_recognize_gain_loss          IN     VARCHAR2 DEFAULT NULL,
     p_recapture_reserve_flag       IN     VARCHAR2 DEFAULT NULL,
     p_limit_proceeds_flag          IN     VARCHAR2 DEFAULT NULL,
     p_terminal_gain_loss           IN     VARCHAR2 DEFAULT NULL,
     p_exclude_proceeds_from_basis  IN     VARCHAR2 DEFAULT NULL,
     p_retirement_deprn_option      IN     VARCHAR2 DEFAULT NULL,
     p_salvage_type                 IN     VARCHAR2 DEFAULT NULL,
     p_deprn_limit_type             IN     VARCHAR2 DEFAULT NULL,
     p_tracking_method              IN     VARCHAR2 DEFAULT NULL,
     p_allocate_to_fully_rsv_flag   IN     VARCHAR2 DEFAULT NULL,
     p_allocate_to_fully_ret_flag   IN     VARCHAR2 DEFAULT NULL,
     p_excess_allocation_option     IN     VARCHAR2 DEFAULT NULL,
     p_depreciation_option          IN     VARCHAR2 DEFAULT NULL,
     p_member_rollup_flag           IN     VARCHAR2 DEFAULT NULL,
     p_ytd_proceeds                 IN     NUMBER   DEFAULT NULL,
     p_ltd_proceeds                 IN     NUMBER   DEFAULT NULL,
     p_exclude_fully_rsv_flag       IN     VARCHAR2 DEFAULT NULL,
     p_eofy_reserve                 IN     NUMBER   DEFAULT NULL,
     p_reclass_transfer_type        IN     VARCHAR2 DEFAULT NULL,
     p_reclass_transfer_amount      IN     NUMBER   DEFAULT NULL,
     p_reclass_src_expense          IN     NUMBER   DEFAULT NULL,
     p_reclass_dest_expense         IN     NUMBER   DEFAULT NULL,
     p_reclass_src_eofy_reserve     IN     NUMBER   DEFAULT NULL,
     p_reclass_dest_eofy_reserve    IN     NUMBER   DEFAULT NULL,
     -- End of Addition for Group Depreciation
/* Etoru */
     p_bk_global_attribute1         IN     VARCHAR2 DEFAULT NULL,
     p_bk_global_attribute2         IN     VARCHAR2 DEFAULT NULL,
     p_bk_global_attribute3         IN     VARCHAR2 DEFAULT NULL,
     p_bk_global_attribute4         IN     VARCHAR2 DEFAULT NULL,
     p_bk_global_attribute5         IN     VARCHAR2 DEFAULT NULL,
     p_bk_global_attribute6         IN     VARCHAR2 DEFAULT NULL,
     p_bk_global_attribute7         IN     VARCHAR2 DEFAULT NULL,
     p_bk_global_attribute8         IN     VARCHAR2 DEFAULT NULL,
     p_bk_global_attribute9         IN     VARCHAR2 DEFAULT NULL,
     p_bk_global_attribute10        IN     VARCHAR2 DEFAULT NULL,
     p_bk_global_attribute11        IN     VARCHAR2 DEFAULT NULL,
     p_bk_global_attribute12        IN     VARCHAR2 DEFAULT NULL,
     p_bk_global_attribute13        IN     VARCHAR2 DEFAULT NULL,
     p_bk_global_attribute14        IN     VARCHAR2 DEFAULT NULL,
     p_bk_global_attribute15        IN     VARCHAR2 DEFAULT NULL,
     p_bk_global_attribute16        IN     VARCHAR2 DEFAULT NULL,
     p_bk_global_attribute17        IN     VARCHAR2 DEFAULT NULL,
     p_bk_global_attribute18        IN     VARCHAR2 DEFAULT NULL,
     p_bk_global_attribute19        IN     VARCHAR2 DEFAULT NULL,
     p_bk_global_attribute20        IN     VARCHAR2 DEFAULT NULL,
     p_bk_global_attribute_category IN     VARCHAR2 DEFAULT NULL,
     -- Asset Depreciation Info --
     p_ytd_deprn                    IN     NUMBER   DEFAULT NULL,
     p_deprn_reserve                IN     NUMBER   DEFAULT NULL,
     p_reval_deprn_reserve          IN     NUMBER   DEFAULT NULL,
     p_ytd_production               IN     NUMBER   DEFAULT NULL,
     p_ltd_production               IN     NUMBER   DEFAULT NULL,
     -- IAS36 Impairment Info --
     p_cash_generating_unit_id      IN     NUMBER   DEFAULT NULL,
-- Changes made as per the ER No.s 6606548 and 6606552 by Sbyreddy Start
     p_nbv_at_switch                IN     NUMBER   DEFAULT NULL,
     p_prior_deprn_limit_type       IN     VARCHAR2 DEFAULT NULL,
     p_prior_deprn_limit_amount     IN     NUMBER   DEFAULT NULL,
     p_prior_deprn_limit            IN     NUMBER   DEFAULT NULL,
     p_period_counter_fully_rsrved  IN     NUMBER   DEFAULT NULL,
     p_extended_depreciation_period IN     NUMBER   DEFAULT NULL,
     p_prior_deprn_method           IN     VARCHAR2 DEFAULT NULL,
     p_prior_life_in_months         IN     NUMBER   DEFAULT NULL,
     p_prior_basic_rate             IN     NUMBER   DEFAULT NULL,
     p_prior_adjusted_rate          IN     NUMBER   DEFAULT NULL,
     p_extended_deprn_flag          IN     VARCHAR2 DEFAULT NULL
-- Changes made as per the ER No.s 6606548 and 6606552 by Sbyreddy End
) AS

    l_trans_rec                 fa_api_types.trans_rec_type;

Line: 332


   l_trans_rec.who_info.last_update_date := p_last_update_date;

Line: 333


   l_trans_rec.who_info.last_updated_by := p_last_updated_by;

Line: 336


   l_trans_rec.who_info.last_update_login := p_last_update_login;

Line: 374


      select set_of_books_id
      into   l_asset_hdr_rec.set_of_books_id
      from   fa_book_controls
      where  book_type_code = l_asset_hdr_rec.book_type_code;

Line: 611


   l_asset_dist_tbl.delete;

Line: 615


      if (fa_load_tbl_pkg.dist_table(i).record_status = 'INSERT') then
         l_asset_dist_rec.distribution_id :=
            fa_load_tbl_pkg.dist_table(i).dist_id;

Line: 632


   l_inv_tbl.delete;

Line: 642


      l_inv_rec.deleted_flag :=  fa_load_tbl_pkg.inv_table(i).deleted_flag;

Line: 810


     p_last_update_date             IN     DATE,
     p_last_updated_by              IN     NUMBER,
     p_created_by                   IN     NUMBER,
     p_creation_date                IN     DATE,
     p_last_update_login            IN     NUMBER,
     p_attribute1                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute2                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute3                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute4                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute5                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute6                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute7                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute8                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute9                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute10                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute11                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute12                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute13                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute14                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute15                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute_category_code      IN     VARCHAR2 DEFAULT NULL,
     -- Asset Header Info --
     p_asset_id                     IN     NUMBER,
     p_book_type_code               IN     VARCHAR2,
     p_set_of_books_id              IN     NUMBER   DEFAULT NULL,
     -- Asset Financial Info --
     p_cost                         IN     NUMBER   DEFAULT NULL,
     p_original_cost                IN     NUMBER   DEFAULT NULL,
     p_unrevalued_cost              IN     NUMBER   DEFAULT NULL,
     p_recoverable_cost             IN     NUMBER   DEFAULT NULL,
     p_salvage_value                IN     NUMBER   DEFAULT NULL,
     p_ceiling_name                 IN     VARCHAR2 DEFAULT NULL,
     p_reval_ceiling                IN     NUMBER   DEFAULT NULL,
     p_depreciate_flag              IN     VARCHAR2 DEFAULT NULL,
     -- HH group ed.
     p_disabled_flag                IN     VARCHAR2 DEFAULT NULL,
     p_date_placed_in_service       IN     DATE     DEFAULT NULL,
     p_prorate_convention_code      IN     VARCHAR2 DEFAULT NULL,
     p_deprn_method_code            IN     VARCHAR2 DEFAULT NULL,
     p_life_in_months               IN     NUMBER   DEFAULT NULL,
     p_basic_rate                   IN     NUMBER   DEFAULT NULL,
     p_adjusted_rate                IN     NUMBER   DEFAULT NULL,
     p_production_capacity          IN     NUMBER   DEFAULT NULL,
     p_unit_of_measure              IN     VARCHAR2 DEFAULT NULL,
     p_bonus_rule                   IN     VARCHAR2 DEFAULT NULL,
     p_itc_amount_id                IN     NUMBER   DEFAULT NULL,
     p_short_fiscal_year_flag       IN     VARCHAR2 DEFAULT NULL,
     p_conversion_date              IN     DATE     DEFAULT NULL,
     p_orig_deprn_start_date        IN     DATE     DEFAULT NULL,
     p_group_asset_id               IN     NUMBER   DEFAULT NULL,
/* toru */
     -- Addition for Group Depreciation
     p_percent_salvage_value        IN     NUMBER   DEFAULT NULL,
     p_allowed_deprn_limit          IN     NUMBER   DEFAULT NULL,
     p_allowed_deprn_limit_amount   IN     NUMBER   DEFAULT NULL,
     p_super_group_id               IN     NUMBER   DEFAULT NULL,
     p_reduction_rate               IN     NUMBER   DEFAULT NULL,
     p_reduce_addition_flag         IN     VARCHAR2 DEFAULT NULL,
     p_reduce_adjustment_flag       IN     VARCHAR2 DEFAULT NULL,
     p_reduce_retirement_flag       IN     VARCHAR2 DEFAULT NULL,
     p_over_depreciate_option       IN     VARCHAR2 DEFAULT NULL,
     p_recognize_gain_loss          IN     VARCHAR2 DEFAULT NULL,
     p_recapture_reserve_flag       IN     VARCHAR2 DEFAULT NULL,
     p_limit_proceeds_flag          IN     VARCHAR2 DEFAULT NULL,
     p_terminal_gain_loss           IN     VARCHAR2 DEFAULT NULL,
     p_exclude_proceeds_from_basis  IN     VARCHAR2 DEFAULT NULL,
     p_retirement_deprn_option      IN     VARCHAR2 DEFAULT NULL,
     p_salvage_type                 IN     VARCHAR2 DEFAULT NULL,
     p_deprn_limit_type             IN     VARCHAR2 DEFAULT NULL,
     p_tracking_method              IN     VARCHAR2 DEFAULT NULL,
     p_allocate_to_fully_rsv_flag   IN     VARCHAR2 DEFAULT NULL,
     p_allocate_to_fully_ret_flag   IN     VARCHAR2 DEFAULT NULL,
     p_excess_allocation_option     IN     VARCHAR2 DEFAULT NULL,
     p_depreciation_option          IN     VARCHAR2 DEFAULT NULL,
     p_member_rollup_flag           IN     VARCHAR2 DEFAULT NULL,
     p_ytd_proceeds                 IN     NUMBER   DEFAULT NULL,
     p_ltd_proceeds                 IN     NUMBER   DEFAULT NULL,
     p_exclude_fully_rsv_flag       IN     VARCHAR2 DEFAULT NULL,
     p_eofy_reserve                 IN     NUMBER   DEFAULT NULL,
     p_reclass_transfer_type        IN     VARCHAR2 DEFAULT NULL,
     p_reclass_transfer_amount      IN     NUMBER   DEFAULT NULL,
     p_reclass_src_expense          IN     NUMBER   DEFAULT NULL,
     p_reclass_dest_expense         IN     NUMBER   DEFAULT NULL,
     p_reclass_src_eofy_reserve     IN     NUMBER   DEFAULT NULL,
     p_reclass_dest_eofy_reserve    IN     NUMBER   DEFAULT NULL,
     -- End of Addition for Group Depreciation
/* Etoru */
     p_bk_global_attribute1         IN     VARCHAR2 DEFAULT NULL,
     p_bk_global_attribute2         IN     VARCHAR2 DEFAULT NULL,
     p_bk_global_attribute3         IN     VARCHAR2 DEFAULT NULL,
     p_bk_global_attribute4         IN     VARCHAR2 DEFAULT NULL,
     p_bk_global_attribute5         IN     VARCHAR2 DEFAULT NULL,
     p_bk_global_attribute6         IN     VARCHAR2 DEFAULT NULL,
     p_bk_global_attribute7         IN     VARCHAR2 DEFAULT NULL,
     p_bk_global_attribute8         IN     VARCHAR2 DEFAULT NULL,
     p_bk_global_attribute9         IN     VARCHAR2 DEFAULT NULL,
     p_bk_global_attribute10        IN     VARCHAR2 DEFAULT NULL,
     p_bk_global_attribute11        IN     VARCHAR2 DEFAULT NULL,
     p_bk_global_attribute12        IN     VARCHAR2 DEFAULT NULL,
     p_bk_global_attribute13        IN     VARCHAR2 DEFAULT NULL,
     p_bk_global_attribute14        IN     VARCHAR2 DEFAULT NULL,
     p_bk_global_attribute15        IN     VARCHAR2 DEFAULT NULL,
     p_bk_global_attribute16        IN     VARCHAR2 DEFAULT NULL,
     p_bk_global_attribute17        IN     VARCHAR2 DEFAULT NULL,
     p_bk_global_attribute18        IN     VARCHAR2 DEFAULT NULL,
     p_bk_global_attribute19        IN     VARCHAR2 DEFAULT NULL,
     p_bk_global_attribute20        IN     VARCHAR2 DEFAULT NULL,
     p_bk_global_attribute_category IN     VARCHAR2 DEFAULT NULL,
     -- Asset Depreciation Info --
     p_ytd_deprn                    IN     NUMBER   DEFAULT NULL,
     p_deprn_reserve                IN     NUMBER   DEFAULT NULL,
     p_reval_deprn_reserve          IN     NUMBER   DEFAULT NULL,
     p_ytd_production               IN     NUMBER   DEFAULT NULL,
     p_ltd_production               IN     NUMBER   DEFAULT NULL,
     -- Invoice Info --
     p_invoice_transaction_type     IN     VARCHAR2 DEFAULT NULL,
     -- Group Reclass Options --
     p_transfer_flag                IN     VARCHAR2 DEFAULT NULL,
     p_manual_amount                IN     NUMBER   DEFAULT NULL,
     p_manual_flag                  IN     VARCHAR2 DEFAULT NULL,
     -- IAS36 Impairment Info --
     p_cash_generating_unit_id      IN     NUMBER   DEFAULT NULL,
-- Changes made as per the ER No.s 6606548 and 6606552 by Sbyreddy Start
     p_nbv_at_switch                IN     NUMBER   DEFAULT NULL,
     p_prior_deprn_limit_type       IN     VARCHAR2 DEFAULT NULL,
     p_prior_deprn_limit_amount     IN     NUMBER   DEFAULT NULL,
     p_prior_deprn_limit            IN     NUMBER   DEFAULT NULL,
     p_period_counter_fully_rsrved  IN     VARCHAR2 DEFAULT NULL,
     p_extended_depreciation_period            IN     VARCHAR2 DEFAULT NULL,
     p_prior_deprn_method           IN     VARCHAR2 DEFAULT NULL,
     p_prior_life_in_months         IN     NUMBER   DEFAULT NULL,
     p_prior_basic_rate             IN     NUMBER   DEFAULT NULL,
     p_prior_adjusted_rate          IN     NUMBER   DEFAULT NULL,
     p_extended_deprn_flag          IN     VARCHAR2 DEFAULT NULL
-- Changes made as per the ER No.s 6606548 and 6606552 by Sbyreddy End
) AS

    adj_err                      exception;

Line: 1010


   l_trans_rec.who_info.last_update_date := p_last_update_date;

Line: 1011


   l_trans_rec.who_info.last_updated_by := p_last_updated_by;

Line: 1014


   l_trans_rec.who_info.last_update_login := p_last_update_login;

Line: 1031


      select set_of_books_id
      into   l_asset_hdr_rec.set_of_books_id
      from   fa_book_controls
      where  book_type_code = l_asset_hdr_rec.book_type_code;

Line: 1273


   l_inv_tbl.delete;

Line: 1284


      l_inv_rec.deleted_flag :=  fa_load_tbl_pkg.inv_table(i).deleted_flag;

Line: 1436


     p_last_update_date             IN     DATE,
     p_last_updated_by              IN     NUMBER,
     p_created_by                   IN     NUMBER,
     p_creation_date                IN     DATE,
     p_last_update_login            IN     NUMBER,
     p_attribute1                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute2                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute3                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute4                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute5                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute6                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute7                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute8                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute9                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute10                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute11                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute12                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute13                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute14                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute15                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute_category_code      IN     VARCHAR2 DEFAULT NULL,
     -- Asset Header Info --
     p_asset_id                     IN     NUMBER,
     p_book_type_code               IN     VARCHAR2,
     p_set_of_books_id              IN     NUMBER   DEFAULT NULL
) AS

   l_trans_rec             fa_api_types.trans_rec_type;

Line: 1511


   l_trans_rec.who_info.last_update_date := p_last_update_date;

Line: 1512


   l_trans_rec.who_info.last_updated_by := p_last_updated_by;

Line: 1515


   l_trans_rec.who_info.last_update_login := p_last_update_login;

Line: 1525


      select set_of_books_id
      into   l_asset_hdr_rec.set_of_books_id
      from   fa_book_controls
      where  book_type_code = l_asset_hdr_rec.book_type_code;

Line: 1532


   l_asset_dist_tbl.delete;

Line: 1598


     p_last_update_date             IN     DATE,
     p_last_updated_by              IN     NUMBER,
     p_created_by                   IN     NUMBER,
     p_creation_date                IN     DATE,
     p_last_update_login            IN     NUMBER,
     p_attribute1                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute2                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute3                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute4                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute5                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute6                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute7                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute8                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute9                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute10                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute11                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute12                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute13                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute14                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute15                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute_category_code      IN     VARCHAR2 DEFAULT NULL,
     -- Asset Header Info --
     p_asset_id                     IN     NUMBER,
     p_book_type_code               IN     VARCHAR2,
     p_set_of_books_id              IN     NUMBER   DEFAULT NULL
) AS

   l_trans_rec             fa_api_types.trans_rec_type;

Line: 1673


   l_trans_rec.who_info.last_update_date := p_last_update_date;

Line: 1674


   l_trans_rec.who_info.last_updated_by := p_last_updated_by;

Line: 1677


   l_trans_rec.who_info.last_update_login := p_last_update_login;

Line: 1687


      select set_of_books_id
      into   l_asset_hdr_rec.set_of_books_id
      from   fa_book_controls
      where  book_type_code = l_asset_hdr_rec.book_type_code;

Line: 1694


   l_asset_dist_tbl.delete;

Line: 1761


     p_last_update_date             IN     DATE,
     p_last_updated_by              IN     NUMBER,
     p_created_by                   IN     NUMBER,
     p_creation_date                IN     DATE,
     p_last_update_login            IN     NUMBER,
     -- Source Asset Header Info --
     p_src_asset_id                 IN     NUMBER,
     p_book_type_code               IN     VARCHAR2,
     p_set_of_books_id              IN     NUMBER   DEFAULT NULL,
     -- Destination Asset Header Info --
     p_dest_asset_id                IN     NUMBER
) AS

   l_src_trans_rec                fa_api_types.trans_rec_type;

Line: 1828


   l_src_trans_rec.who_info.last_update_date := p_last_update_date;

Line: 1829


   l_src_trans_rec.who_info.last_updated_by := p_last_updated_by;

Line: 1832


   l_src_trans_rec.who_info.last_update_login := p_last_update_login;

Line: 1842


      select set_of_books_id
      into   l_src_asset_hdr_rec.set_of_books_id
      from   fa_book_controls
      where  book_type_code = l_src_asset_hdr_rec.book_type_code;

Line: 1879


   l_dest_trans_rec.who_info.last_update_date := p_last_update_date;

Line: 1880


   l_dest_trans_rec.who_info.last_updated_by := p_last_updated_by;

Line: 1883


   l_dest_trans_rec.who_info.last_update_login := p_last_update_login;

Line: 1892


   l_inv_tbl.delete;

Line: 1902


      l_inv_rec.deleted_flag :=  fa_load_tbl_pkg.inv_table(i).deleted_flag;

Line: 2016


     p_last_update_date             IN     DATE,
     p_last_updated_by              IN     NUMBER,
     p_created_by                   IN     NUMBER,
     p_creation_date                IN     DATE,
     p_last_update_login            IN     NUMBER,
     p_attribute1                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute2                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute3                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute4                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute5                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute6                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute7                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute8                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute9                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute10                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute11                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute12                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute13                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute14                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute15                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute_category_code      IN     VARCHAR2 DEFAULT NULL,
     -- Asset Header Info --
     p_asset_id                     IN     NUMBER,
     -- Asset Category Info --
     p_new_category_id              IN     NUMBER,
     p_cat_attribute1               IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute2               IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute3               IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute4               IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute5               IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute6               IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute7               IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute8               IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute9               IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute10              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute11              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute12              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute13              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute14              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute15              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute16              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute17              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute18              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute19              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute20              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute21              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute22              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute23              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute24              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute25              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute26              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute27              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute28              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute29              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute30              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute_category_code  IN     VARCHAR2 DEFAULT NULL,
     p_context                      IN     VARCHAR2 DEFAULT NULL,
     -- Reclass Options Info --
     p_copy_cat_desc_flag           IN     VARCHAR2 DEFAULT 'NO',
     p_redefault_flag               IN     VARCHAR2 DEFAULT 'NO'
) AS

   l_trans_rec           fa_api_types.trans_rec_type;

Line: 2126


   l_trans_rec.who_info.last_update_date := p_last_update_date;

Line: 2127


   l_trans_rec.who_info.last_updated_by := p_last_updated_by;

Line: 2130


   l_trans_rec.who_info.last_update_login := p_last_update_login;

Line: 2142


/* select set_of_books_id
   into   l_asset_hdr_rec.set_of_books_id
   from   fa_book_controls
   where  book_type_code = l_asset_hdr_rec.book_type_code;

Line: 2238


     p_last_update_date             IN     DATE,
     p_last_updated_by              IN     NUMBER,
     p_created_by                   IN     NUMBER,
     p_creation_date                IN     DATE,
     p_last_update_login            IN     NUMBER,
     p_attribute1                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute2                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute3                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute4                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute5                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute6                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute7                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute8                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute9                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute10                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute11                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute12                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute13                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute14                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute15                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute_category_code      IN     VARCHAR2 DEFAULT NULL,
     -- Transaction Info (Distributions) --
     p_dist_transaction_name        IN     VARCHAR2 DEFAULT NULL,
     p_dist_attribute1              IN     VARCHAR2 DEFAULT NULL,
     p_dist_attribute2              IN     VARCHAR2 DEFAULT NULL,
     p_dist_attribute3              IN     VARCHAR2 DEFAULT NULL,
     p_dist_attribute4              IN     VARCHAR2 DEFAULT NULL,
     p_dist_attribute5              IN     VARCHAR2 DEFAULT NULL,
     p_dist_attribute6              IN     VARCHAR2 DEFAULT NULL,
     p_dist_attribute7              IN     VARCHAR2 DEFAULT NULL,
     p_dist_attribute8              IN     VARCHAR2 DEFAULT NULL,
     p_dist_attribute9              IN     VARCHAR2 DEFAULT NULL,
     p_dist_attribute10             IN     VARCHAR2 DEFAULT NULL,
     p_dist_attribute11             IN     VARCHAR2 DEFAULT NULL,
     p_dist_attribute12             IN     VARCHAR2 DEFAULT NULL,
     p_dist_attribute13             IN     VARCHAR2 DEFAULT NULL,
     p_dist_attribute14             IN     VARCHAR2 DEFAULT NULL,
     p_dist_attribute15             IN     VARCHAR2 DEFAULT NULL,
     p_dist_attribute_category_code IN     VARCHAR2 DEFAULT NULL,
     -- Asset Header Info --
     p_asset_id                     IN     NUMBER,
     p_book_type_code               IN     VARCHAR2,
     p_set_of_books_id              IN     NUMBER   DEFAULT NULL,
     -- Asset Retirement Info --
     p_calculate_gain_loss          IN     VARCHAR2 DEFAULT FND_API.G_FALSE,
     p_units_retired                IN     NUMBER   DEFAULT NULL,
     p_cost_retired                 IN     NUMBER   DEFAULT NULL,
     p_proceeds_of_sale             IN     NUMBER   DEFAULT NULL,
     p_cost_of_removal              IN     NUMBER   DEFAULT NULL,
     p_retirement_type_code         IN     VARCHAR2 DEFAULT NULL,
     p_retire_prorate_convention    IN     VARCHAR2 DEFAULT NULL,
     p_stl_method_code              IN     VARCHAR2 DEFAULT NULL,
     p_stl_life_in_months           IN     NUMBER   DEFAULT NULL,
     p_sold_to                      IN     VARCHAR2 DEFAULT NULL,
     p_trade_in_asset_id            IN     NUMBER   DEFAULT NULL,
     p_status                       IN     VARCHAR2 DEFAULT NULL,
     p_reference_num                IN     VARCHAR2 DEFAULT NULL,
     p_recognize_gain_loss          IN     VARCHAR2 DEFAULT NULL,
     p_recapture_reserve_flag       IN     VARCHAR2 DEFAULT NULL,
     p_limit_proceeds_flag          IN     VARCHAR2 DEFAULT NULL,
     p_terminal_gain_loss           IN     VARCHAR2 DEFAULT NULL,
     p_reduction_rate               IN     NUMBER   DEFAULT NULL,
     p_reserve_retired              IN     NUMBER   DEFAULT NULL,
     p_eofy_reserve                 IN     NUMBER   DEFAULT NULL,
     p_ret_attribute1               IN     VARCHAR2 DEFAULT NULL,
     p_ret_attribute2               IN     VARCHAR2 DEFAULT NULL,
     p_ret_attribute3               IN     VARCHAR2 DEFAULT NULL,
     p_ret_attribute4               IN     VARCHAR2 DEFAULT NULL,
     p_ret_attribute5               IN     VARCHAR2 DEFAULT NULL,
     p_ret_attribute6               IN     VARCHAR2 DEFAULT NULL,
     p_ret_attribute7               IN     VARCHAR2 DEFAULT NULL,
     p_ret_attribute8               IN     VARCHAR2 DEFAULT NULL,
     p_ret_attribute9               IN     VARCHAR2 DEFAULT NULL,
     p_ret_attribute10              IN     VARCHAR2 DEFAULT NULL,
     p_ret_attribute11              IN     VARCHAR2 DEFAULT NULL,
     p_ret_attribute12              IN     VARCHAR2 DEFAULT NULL,
     p_ret_attribute13              IN     VARCHAR2 DEFAULT NULL,
     p_ret_attribute14              IN     VARCHAR2 DEFAULT NULL,
     p_ret_attribute15              IN     VARCHAR2 DEFAULT NULL,
     p_ret_attribute_category_code  IN     VARCHAR2 DEFAULT NULL
) AS

   l_trans_rec              fa_api_types.trans_rec_type;

Line: 2375


   l_trans_rec.who_info.last_update_date := p_last_update_date;

Line: 2376


   l_trans_rec.who_info.last_updated_by := p_last_updated_by;

Line: 2379


   l_trans_rec.who_info.last_update_login := p_last_update_login;

Line: 2403


   l_dist_trans_rec.who_info.last_update_date := p_last_update_date;

Line: 2404


   l_dist_trans_rec.who_info.last_updated_by := p_last_updated_by;

Line: 2407


   l_dist_trans_rec.who_info.last_update_login := p_last_update_login;

Line: 2417


      select set_of_books_id
      into   l_asset_hdr_rec.set_of_books_id
      from   fa_book_controls
      where  book_type_code = l_asset_hdr_rec.book_type_code;

Line: 2469


   l_asset_dist_tbl.delete;

Line: 2473


      if (fa_load_tbl_pkg.dist_table(i).record_status = 'UPDATE') then
         l_asset_dist_rec.distribution_id :=
            fa_load_tbl_pkg.dist_table(i).dist_id;

Line: 2492


   l_subcomp_tbl.delete;

Line: 2495


   l_inv_tbl.delete;

Line: 2506


      l_inv_rec.deleted_flag :=  fa_load_tbl_pkg.inv_table(i).deleted_flag;

Line: 2614


     p_last_update_date             IN     DATE,
     p_last_updated_by              IN     NUMBER,
     p_last_update_login            IN     NUMBER,
     -- Asset Header Info --
     p_asset_id                     IN     NUMBER,
     p_book_type_code               IN     VARCHAR2,
     p_set_of_books_id              IN     NUMBER   DEFAULT NULL,
     -- Asset Retirement Info --
     p_retirement_id                IN     NUMBER   DEFAULT NULL,
     p_status                       IN     VARCHAR2 DEFAULT NULL
) AS

   l_trans_rec              fa_api_types.trans_rec_type;

Line: 2673


   l_trans_rec.who_info.last_update_date := p_last_update_date;

Line: 2674


   l_trans_rec.who_info.last_updated_by := p_last_updated_by;

Line: 2677


   l_trans_rec.who_info.last_update_login := p_last_update_login;

Line: 2687


      select set_of_books_id
      into   l_asset_hdr_rec.set_of_books_id
      from   fa_book_controls
      where  book_type_code = l_asset_hdr_rec.book_type_code;

Line: 2770


     p_last_update_date             IN     DATE,
     p_last_updated_by              IN     NUMBER,
     p_created_by                   IN     NUMBER,
     p_creation_date                IN     DATE,
     p_last_update_login            IN     NUMBER,
     p_attribute1                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute2                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute3                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute4                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute5                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute6                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute7                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute8                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute9                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute10                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute11                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute12                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute13                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute14                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute15                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute_category_code      IN     VARCHAR2 DEFAULT NULL,
     -- Asset Header Info --
     p_asset_id                     IN     NUMBER,
     p_book_type_code               IN     VARCHAR2,
     p_set_of_books_id              IN     NUMBER   DEFAULT NULL,
     -- Asset Retirement Info --
     p_calculate_gain_loss          IN     VARCHAR2 DEFAULT FND_API.G_FALSE,
     p_retirement_id                IN     NUMBER   DEFAULT NULL,
     p_proceeds_of_sale             IN     NUMBER   DEFAULT NULL,
     p_cost_of_removal              IN     NUMBER   DEFAULT NULL,
     p_retirement_type_code         IN     VARCHAR2 DEFAULT NULL,
     p_retire_prorate_convention    IN     VARCHAR2 DEFAULT NULL,
     p_sold_to                      IN     VARCHAR2 DEFAULT NULL,
     p_trade_in_asset_id            IN     NUMBER   DEFAULT NULL,
     p_status                       IN     VARCHAR2 DEFAULT NULL,
     p_reference_num                IN     VARCHAR2 DEFAULT NULL,
     p_ret_attribute1               IN     VARCHAR2 DEFAULT NULL,
     p_ret_attribute2               IN     VARCHAR2 DEFAULT NULL,
     p_ret_attribute3               IN     VARCHAR2 DEFAULT NULL,
     p_ret_attribute4               IN     VARCHAR2 DEFAULT NULL,
     p_ret_attribute5               IN     VARCHAR2 DEFAULT NULL,
     p_ret_attribute6               IN     VARCHAR2 DEFAULT NULL,
     p_ret_attribute7               IN     VARCHAR2 DEFAULT NULL,
     p_ret_attribute8               IN     VARCHAR2 DEFAULT NULL,
     p_ret_attribute9               IN     VARCHAR2 DEFAULT NULL,
     p_ret_attribute10              IN     VARCHAR2 DEFAULT NULL,
     p_ret_attribute11              IN     VARCHAR2 DEFAULT NULL,
     p_ret_attribute12              IN     VARCHAR2 DEFAULT NULL,
     p_ret_attribute13              IN     VARCHAR2 DEFAULT NULL,
     p_ret_attribute14              IN     VARCHAR2 DEFAULT NULL,
     p_ret_attribute15              IN     VARCHAR2 DEFAULT NULL,
     p_ret_attribute_category_code  IN     VARCHAR2 DEFAULT NULL
) AS

   l_trans_rec              fa_api_types.trans_rec_type;

Line: 2878


   l_trans_rec.who_info.last_update_date := p_last_update_date;

Line: 2879


   l_trans_rec.who_info.last_updated_by := p_last_updated_by;

Line: 2882


   l_trans_rec.who_info.last_update_login := p_last_update_login;

Line: 2892


      select set_of_books_id
      into   l_asset_hdr_rec.set_of_books_id
      from   fa_book_controls
      where  book_type_code = l_asset_hdr_rec.book_type_code;

Line: 2932


   l_asset_dist_tbl.delete;

Line: 2936


      if (fa_load_tbl_pkg.dist_table(i).record_status = 'UPDATE') then
         l_asset_dist_rec.distribution_id :=
            fa_load_tbl_pkg.dist_table(i).dist_id;

Line: 2955


   l_subcomp_tbl.delete;

Line: 2960


   l_inv_tbl.delete;

Line: 2970


      l_inv_rec.deleted_flag :=  fa_load_tbl_pkg.inv_table(i).deleted_flag;

Line: 3075


     p_last_update_date             IN     DATE,
     p_last_updated_by              IN     NUMBER,
     p_last_update_login            IN     NUMBER,
     -- Asset Header Info --
     p_asset_id                     IN     NUMBER,
     p_book_type_code               IN     VARCHAR2,
     p_set_of_books_id              IN     NUMBER   DEFAULT NULL,
     -- Asset Retirement Info --
     p_retirement_id                IN     NUMBER   DEFAULT NULL,
     p_status                       IN     VARCHAR2 DEFAULT NULL
) AS

   l_trans_rec              fa_api_types.trans_rec_type;

Line: 3135


   l_trans_rec.who_info.last_update_date := p_last_update_date;

Line: 3136


   l_trans_rec.who_info.last_updated_by := p_last_updated_by;

Line: 3139


   l_trans_rec.who_info.last_update_login := p_last_update_login;

Line: 3149


      select set_of_books_id
      into   l_asset_hdr_rec.set_of_books_id
      from   fa_book_controls
      where  book_type_code = l_asset_hdr_rec.book_type_code;

Line: 3232


     p_last_update_date             IN     DATE,
     p_last_updated_by              IN     NUMBER,
     p_created_by                   IN     NUMBER,
     p_creation_date                IN     DATE,
     p_last_update_login            IN     NUMBER,
     p_attribute1                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute2                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute3                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute4                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute5                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute6                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute7                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute8                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute9                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute10                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute11                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute12                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute13                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute14                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute15                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute_category_code      IN     VARCHAR2 DEFAULT NULL,
     -- Asset Header Info --
     p_asset_id                     IN     NUMBER,
     p_book_type_code               IN     VARCHAR2,
     p_set_of_books_id              IN     NUMBER   DEFAULT NULL,
     -- Asset Financial Info --
     p_date_placed_in_service       IN     DATE
) AS

   l_trans_rec              fa_api_types.trans_rec_type;

Line: 3308


   l_trans_rec.who_info.last_update_date := p_last_update_date;

Line: 3309


   l_trans_rec.who_info.last_updated_by := p_last_updated_by;

Line: 3312


   l_trans_rec.who_info.last_update_login := p_last_update_login;

Line: 3322


      select set_of_books_id
      into   l_asset_hdr_rec.set_of_books_id
      from   fa_book_controls
      where  book_type_code = l_asset_hdr_rec.book_type_code;

Line: 3379


     p_last_update_date             IN     DATE,
     p_last_updated_by              IN     NUMBER,
     p_created_by                   IN     NUMBER,
     p_creation_date                IN     DATE,
     p_last_update_login            IN     NUMBER,
     p_attribute1                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute2                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute3                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute4                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute5                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute6                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute7                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute8                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute9                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute10                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute11                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute12                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute13                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute14                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute15                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute_category_code      IN     VARCHAR2 DEFAULT NULL,
     -- Asset Header Info --
     p_asset_id                     IN     NUMBER,
     p_book_type_code               IN     VARCHAR2,
     p_set_of_books_id              IN     NUMBER   DEFAULT NULL,
     -- Asset Financial Info --
     p_date_placed_in_service       IN     DATE
) AS

   l_trans_rec              fa_api_types.trans_rec_type;

Line: 3455


   l_trans_rec.who_info.last_update_date := p_last_update_date;

Line: 3456


   l_trans_rec.who_info.last_updated_by := p_last_updated_by;

Line: 3459


   l_trans_rec.who_info.last_update_login := p_last_update_login;

Line: 3469


      select set_of_books_id
      into   l_asset_hdr_rec.set_of_books_id
      from   fa_book_controls
      where  book_type_code = l_asset_hdr_rec.book_type_code;

Line: 3507


PROCEDURE do_asset_desc_update (
     -- Standard Parameters --
     p_api_version                  IN     NUMBER,
     p_init_msg_list                IN     VARCHAR2 := FND_API.G_TRUE,
     p_commit                       IN     VARCHAR2 := FND_API.G_FALSE,
     p_validation_level             IN     NUMBER := FND_API.G_VALID_LEVEL_FULL,
     x_return_status                   OUT NOCOPY VARCHAR2,
     x_msg_count                       OUT NOCOPY NUMBER,
     x_msg_data                        OUT NOCOPY VARCHAR2,
     p_calling_fn                   IN     VARCHAR2,
     -- API Options --
     p_debug_flag                   IN     VARCHAR2 DEFAULT 'NO',
     p_reset_miss_flag              IN     VARCHAR2 DEFAULT 'NO',
     -- Transaction Info --
     p_last_update_date             IN     DATE,
     p_last_updated_by              IN     NUMBER,
     p_last_update_login            IN     NUMBER,
     -- Asset Header Info --
     p_asset_id                     IN     NUMBER,
     -- Asset Description Info --
     p_asset_number                 IN     VARCHAR2 DEFAULT NULL,
     p_description                  IN     VARCHAR2 DEFAULT NULL,
     p_tag_number                   IN     VARCHAR2 DEFAULT NULL,
     p_serial_number                IN     VARCHAR2 DEFAULT NULL,
     p_asset_key_ccid               IN     NUMBER   DEFAULT NULL,
     p_current_units                IN     NUMBER   DEFAULT NULL,
     p_parent_asset_id              IN     NUMBER   DEFAULT NULL,
     p_status                       IN     VARCHAR2 DEFAULT NULL,
     p_manufacturer_name            IN     VARCHAR2 DEFAULT NULL,
     p_model_number                 IN     VARCHAR2 DEFAULT NULL,
     p_warranty_id                  IN     NUMBER   DEFAULT NULL,
     p_property_type_code           IN     VARCHAR2 DEFAULT NULL,
     p_property_1245_1250_code      IN     VARCHAR2 DEFAULT NULL,
     p_in_use_flag                  IN     VARCHAR2 DEFAULT NULL,
     p_inventorial                  IN     VARCHAR2 DEFAULT NULL,
     p_commitment		    IN	   VARCHAR2 DEFAULT NULL,
     p_investment_law		    IN     VARCHAR2 DEFAULT NULL,
     p_owned_leased                 IN     VARCHAR2 DEFAULT NULL,
     p_new_used                     IN     VARCHAR2 DEFAULT NULL,
     p_lease_id                     IN     NUMBER   DEFAULT NULL,
     p_ls_attribute1                IN     VARCHAR2 DEFAULT NULL,
     p_ls_attribute2                IN     VARCHAR2 DEFAULT NULL,
     p_ls_attribute3                IN     VARCHAR2 DEFAULT NULL,
     p_ls_attribute4                IN     VARCHAR2 DEFAULT NULL,
     p_ls_attribute5                IN     VARCHAR2 DEFAULT NULL,
     p_ls_attribute6                IN     VARCHAR2 DEFAULT NULL,
     p_ls_attribute7                IN     VARCHAR2 DEFAULT NULL,
     p_ls_attribute8                IN     VARCHAR2 DEFAULT NULL,
     p_ls_attribute9                IN     VARCHAR2 DEFAULT NULL,
     p_ls_attribute10               IN     VARCHAR2 DEFAULT NULL,
     p_ls_attribute11               IN     VARCHAR2 DEFAULT NULL,
     p_ls_attribute12               IN     VARCHAR2 DEFAULT NULL,
     p_ls_attribute13               IN     VARCHAR2 DEFAULT NULL,
     p_ls_attribute14               IN     VARCHAR2 DEFAULT NULL,
     p_ls_attribute15               IN     VARCHAR2 DEFAULT NULL,
     p_ls_attribute_category_code   IN     VARCHAR2 DEFAULT NULL,
     p_ad_global_attribute1         IN     VARCHAR2 DEFAULT NULL,
     p_ad_global_attribute2         IN     VARCHAR2 DEFAULT NULL,
     p_ad_global_attribute3         IN     VARCHAR2 DEFAULT NULL,
     p_ad_global_attribute4         IN     VARCHAR2 DEFAULT NULL,
     p_ad_global_attribute5         IN     VARCHAR2 DEFAULT NULL,
     p_ad_global_attribute6         IN     VARCHAR2 DEFAULT NULL,
     p_ad_global_attribute7         IN     VARCHAR2 DEFAULT NULL,
     p_ad_global_attribute8         IN     VARCHAR2 DEFAULT NULL,
     p_ad_global_attribute9         IN     VARCHAR2 DEFAULT NULL,
     p_ad_global_attribute10        IN     VARCHAR2 DEFAULT NULL,
     p_ad_global_attribute11        IN     VARCHAR2 DEFAULT NULL,
     p_ad_global_attribute12        IN     VARCHAR2 DEFAULT NULL,
     p_ad_global_attribute13        IN     VARCHAR2 DEFAULT NULL,
     p_ad_global_attribute14        IN     VARCHAR2 DEFAULT NULL,
     p_ad_global_attribute15        IN     VARCHAR2 DEFAULT NULL,
     p_ad_global_attribute16        IN     VARCHAR2 DEFAULT NULL,
     p_ad_global_attribute17        IN     VARCHAR2 DEFAULT NULL,
     p_ad_global_attribute18        IN     VARCHAR2 DEFAULT NULL,
     p_ad_global_attribute19        IN     VARCHAR2 DEFAULT NULL,
     p_ad_global_attribute20        IN     VARCHAR2 DEFAULT NULL,
     p_ad_global_attribute_category IN     VARCHAR2 DEFAULT NULL,
     -- Asset Category Info --
     p_category_id                  IN     NUMBER,
     p_cat_attribute1               IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute2               IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute3               IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute4               IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute5               IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute6               IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute7               IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute8               IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute9               IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute10              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute11              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute12              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute13              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute14              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute15              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute16              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute17              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute18              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute19              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute20              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute21              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute22              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute23              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute24              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute25              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute26              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute27              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute28              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute29              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute30              IN     VARCHAR2 DEFAULT NULL,
     p_cat_attribute_category_code  IN     VARCHAR2 DEFAULT NULL,
     p_context                      IN     VARCHAR2 DEFAULT NULL
) AS

    l_trans_rec                fa_api_types.trans_rec_type;

Line: 3672


   l_trans_rec.who_info.last_update_date := p_last_update_date;

Line: 3673


   l_trans_rec.who_info.last_updated_by := p_last_updated_by;

Line: 3676


   l_trans_rec.who_info.last_update_login := p_last_update_login;

Line: 3685


/* select set_of_books_id
   into   l_asset_hdr_rec.set_of_books_id
   from   fa_book_controls
   where  book_type_code = l_asset_hdr_rec.book_type_code;

Line: 3819


   fa_asset_desc_pub.update_desc (
          p_api_version          => p_api_version,
          p_init_msg_list        => p_init_msg_list,
          p_commit               => p_commit,
          p_validation_level     => p_validation_level,
          x_return_status        => x_return_status,
          x_msg_count            => x_msg_count,
          x_msg_data             => x_msg_data,
          p_calling_fn           => p_calling_fn,
          px_trans_rec           => l_trans_rec,
          px_asset_hdr_rec       => l_asset_hdr_rec,
          px_asset_desc_rec_new  => l_asset_desc_rec,
          px_asset_cat_rec_new   => l_asset_cat_rec);

Line: 3839


      fa_srvr_msg.add_message(calling_fn => 'fa_trans_api_pub.do_desc_update',
                   p_log_level_rec => g_log_level_rec);

Line: 3843


      fa_srvr_msg.add_sql_error(calling_fn => 'fa_trans_api_pub.do_desc_update',
                   p_log_level_rec => g_log_level_rec);

Line: 3846


END do_asset_desc_update;

Line: 3848


PROCEDURE do_invoice_desc_update (
     -- Standard Parameters --
     p_api_version                  IN     NUMBER,
     p_init_msg_list                IN     VARCHAR2 := FND_API.G_TRUE,
     p_commit                       IN     VARCHAR2 := FND_API.G_FALSE,
     p_validation_level             IN     NUMBER := FND_API.G_VALID_LEVEL_FULL,
     x_return_status                   OUT NOCOPY VARCHAR2,
     x_msg_count                       OUT NOCOPY NUMBER,
     x_msg_data                        OUT NOCOPY VARCHAR2,
     p_calling_fn                   IN     VARCHAR2,
     -- API Options --
     p_debug_flag                   IN     VARCHAR2 DEFAULT 'NO',
     p_reset_miss_flag              IN     VARCHAR2 DEFAULT 'NO',
     -- Transaction Info --
     p_last_update_date             IN     DATE,
     p_last_updated_by              IN     NUMBER,
     p_last_update_login            IN     NUMBER,
     -- Asset Header Info --
     p_asset_id                     IN     NUMBER,
     p_book_type_code               IN     VARCHAR2,
     p_set_of_books_id              IN     NUMBER   DEFAULT NULL
) AS

    l_trans_rec                fa_api_types.trans_rec_type;

Line: 3922


   l_trans_rec.who_info.last_update_date := p_Last_Update_Date;

Line: 3923


   l_trans_rec.who_info.last_updated_by := p_Last_Updated_By;

Line: 3926


   l_trans_rec.who_info.last_update_login := p_Last_Update_Login;

Line: 3936


      select set_of_books_id
      into   l_asset_hdr_rec.set_of_books_id
      from   fa_book_controls
      where  book_type_code = l_asset_hdr_rec.book_type_code;

Line: 3943


   l_inv_tbl.delete;

Line: 3953


      l_inv_rec.deleted_flag :=  fa_load_tbl_pkg.inv_table(i).deleted_flag;

Line: 4028


   fa_asset_desc_pub.update_invoice_desc (
          p_api_version      => p_api_version,
          p_init_msg_list    => p_init_msg_list ,
          p_commit           => p_commit,
          p_validation_level => p_validation_level,
          x_return_status    => x_return_status,
          x_msg_count        => x_msg_count,
          x_msg_data         => x_msg_data,
          p_calling_fn       => p_calling_fn,
          px_trans_rec       => l_trans_rec,
          px_asset_hdr_rec   => l_asset_hdr_rec,
          px_inv_tbl_new     => l_inv_tbl);

Line: 4056


END do_invoice_desc_update;

Line: 4058


PROCEDURE do_retirement_desc_update (
     -- Standard Parameters --
     p_api_version                  IN     NUMBER,
     p_init_msg_list                IN     VARCHAR2 := FND_API.G_TRUE,
     p_commit                       IN     VARCHAR2 := FND_API.G_FALSE,
     p_validation_level             IN     NUMBER := FND_API.G_VALID_LEVEL_FULL,
     x_return_status                   OUT NOCOPY VARCHAR2,
     x_msg_count                       OUT NOCOPY NUMBER,
     x_msg_data                        OUT NOCOPY VARCHAR2,
     p_calling_fn                   IN     VARCHAR2,
     -- API Options --
     p_debug_flag                   IN     VARCHAR2 DEFAULT 'NO',
     p_reset_miss_flag               IN    VARCHAR2 DEFAULT 'NO',
     -- Transaction Info (Retirement) --
     p_last_update_date             IN     DATE,
     p_last_updated_by              IN     NUMBER,
     p_last_update_login            IN     NUMBER,
     -- Asset Header Info --
     p_asset_id                     IN     NUMBER,
     p_book_type_code               IN     VARCHAR2,
     p_set_of_books_id              IN     NUMBER   DEFAULT NULL,
     -- Asset Retirement Info --
     p_retirement_id                IN     NUMBER,
     p_proceeds_of_sale             IN     NUMBER   DEFAULT NULL,
     p_cost_of_removal              IN     NUMBER   DEFAULT NULL,
     p_retirement_type_code         IN     VARCHAR2 DEFAULT NULL,
     p_retire_prorate_convention    IN     VARCHAR2 DEFAULT NULL,
     p_sold_to                      IN     VARCHAR2 DEFAULT NULL,
     p_trade_in_asset_id            IN     NUMBER   DEFAULT NULL,
     p_status                       IN     VARCHAR2 DEFAULT NULL,
     p_reference_num                IN     VARCHAR2 DEFAULT NULL,
     p_ret_attribute1               IN     VARCHAR2 DEFAULT NULL,
     p_ret_attribute2               IN     VARCHAR2 DEFAULT NULL,
     p_ret_attribute3               IN     VARCHAR2 DEFAULT NULL,
     p_ret_attribute4               IN     VARCHAR2 DEFAULT NULL,
     p_ret_attribute5               IN     VARCHAR2 DEFAULT NULL,
     p_ret_attribute6               IN     VARCHAR2 DEFAULT NULL,
     p_ret_attribute7               IN     VARCHAR2 DEFAULT NULL,
     p_ret_attribute8               IN     VARCHAR2 DEFAULT NULL,
     p_ret_attribute9               IN     VARCHAR2 DEFAULT NULL,
     p_ret_attribute10              IN     VARCHAR2 DEFAULT NULL,
     p_ret_attribute11              IN     VARCHAR2 DEFAULT NULL,
     p_ret_attribute12              IN     VARCHAR2 DEFAULT NULL,
     p_ret_attribute13              IN     VARCHAR2 DEFAULT NULL,
     p_ret_attribute14              IN     VARCHAR2 DEFAULT NULL,
     p_ret_attribute15              IN     VARCHAR2 DEFAULT NULL,
     p_ret_attribute_category_code  IN     VARCHAR2 DEFAULT NULL
) AS

    l_trans_rec                fa_api_types.trans_rec_type;

Line: 4157


   l_trans_rec.who_info.last_update_date := p_last_update_date;

Line: 4158


   l_trans_rec.who_info.last_updated_by := p_last_updated_by;

Line: 4161


   l_trans_rec.who_info.last_update_login := p_last_update_login;

Line: 4171


      select set_of_books_id
      into   l_asset_hdr_rec.set_of_books_id
      from   fa_book_controls
      where  book_type_code = l_asset_hdr_rec.book_type_code;

Line: 4220


   fa_asset_desc_pub.update_retirement_desc (
          p_api_version           => p_api_version,
          p_init_msg_list         => p_init_msg_list,
          p_commit                => p_commit,
          p_validation_level      => p_validation_level,
          x_return_status         => x_return_status,
          x_msg_count             => x_msg_count,
          x_msg_data              => x_msg_data,
          p_calling_fn            => p_calling_fn,
          px_trans_rec            => l_trans_rec,
          px_asset_hdr_rec        => l_asset_hdr_rec,
          px_asset_retire_rec_new => l_asset_retire_rec);

Line: 4248


END do_retirement_desc_update;

Line: 4271


     p_last_update_date             IN     DATE,
     p_last_updated_by              IN     NUMBER,
     p_created_by                   IN     NUMBER,
     p_creation_date                IN     DATE,
     p_last_update_login            IN     NUMBER,
     p_attribute1                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute2                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute3                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute4                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute5                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute6                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute7                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute8                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute9                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute10                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute11                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute12                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute13                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute14                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute15                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute_category_code      IN     VARCHAR2 DEFAULT NULL,
     -- Asset Header Info --
     p_asset_id                     IN     NUMBER,
     p_book_type_code               IN     VARCHAR2,
     p_set_of_books_id              IN     NUMBER   DEFAULT NULL,
     -- Unplanned Depreciation Info --
     p_code_combination_id          IN     NUMBER,
     p_unplanned_amount             IN     NUMBER,
     p_unplanned_type               IN     VARCHAR2 DEFAULT NULL
) AS

    l_trans_rec                fa_api_types.trans_rec_type;

Line: 4349


   l_trans_rec.who_info.last_update_date := p_last_update_date;

Line: 4350


   l_trans_rec.who_info.last_updated_by := p_last_updated_by;

Line: 4353


   l_trans_rec.who_info.last_update_login := p_last_update_login;

Line: 4369


      select set_of_books_id
      into   l_asset_hdr_rec.set_of_books_id
      from   fa_book_controls
      where  book_type_code = l_asset_hdr_rec.book_type_code;

Line: 4431


     p_last_update_date             IN     DATE,
     p_last_updated_by              IN     NUMBER,
     p_created_by                   IN     NUMBER,
     p_creation_date                IN     DATE,
     p_last_update_login            IN     NUMBER,
     p_attribute1                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute2                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute3                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute4                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute5                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute6                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute7                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute8                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute9                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute10                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute11                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute12                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute13                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute14                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute15                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute_category_code      IN     VARCHAR2 DEFAULT NULL,
     -- Asset Header Info --
     p_src_asset_id                 IN     NUMBER,  -- Source Asset Id
     p_book_type_code               IN     VARCHAR2,-- Source Book Type Code
     -- Reserve Transfer Info --
     p_transfer_amount              IN     NUMBER,
     p_dest_asset_id                IN     NUMBER   -- Destination Asset Id
) IS

  l_src_trans_rec     FA_API_TYPES.trans_rec_type;

Line: 4483


   l_src_trans_rec.who_info.last_update_date := p_last_update_date;

Line: 4484


   l_src_trans_rec.who_info.last_updated_by := p_last_updated_by;

Line: 4493


   l_dest_trans_rec.who_info.last_update_date := p_last_update_date;

Line: 4494


   l_dest_trans_rec.who_info.last_updated_by := p_last_updated_by;

Line: 4552


     p_last_update_date             IN     DATE,
     p_last_updated_by              IN     NUMBER,
     p_created_by                   IN     NUMBER,
     p_creation_date                IN     DATE,
     p_last_update_login            IN     NUMBER,
     p_attribute1                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute2                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute3                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute4                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute5                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute6                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute7                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute8                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute9                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute10                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute11                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute12                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute13                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute14                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute15                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute_category_code      IN     VARCHAR2 DEFAULT NULL,
     -- Asset Header Info --
     p_asset_id                     IN     NUMBER,
     p_book_type_code               IN     VARCHAR2,
     -- Retirement Adjustment Info --
     p_proceeds_of_sale             IN     NUMBER,
     p_cost_of_removal              IN     NUMBER
) IS

    l_trans_rec                fa_api_types.trans_rec_type;

Line: 4588


  l_trans_rec.who_info.last_update_date := p_last_update_date;

Line: 4589


  l_trans_rec.who_info.last_updated_by := p_last_updated_by;

Line: 4643


     p_last_update_date             IN     DATE,
     p_last_updated_by              IN     NUMBER,
     p_created_by                   IN     NUMBER,
     p_creation_date                IN     DATE,
     p_last_update_login            IN     NUMBER,
     p_attribute1                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute2                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute3                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute4                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute5                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute6                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute7                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute8                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute9                   IN     VARCHAR2 DEFAULT NULL,
     p_attribute10                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute11                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute12                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute13                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute14                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute15                  IN     VARCHAR2 DEFAULT NULL,
     p_attribute_category_code      IN     VARCHAR2 DEFAULT NULL,
     -- Asset Header Info --
     p_asset_id                     IN     NUMBER,
     p_book_type_code               IN     VARCHAR2,
     -- Tax Reserve Adjustment Info --
     p_fiscal_year                  IN     NUMBER,
     p_adjusted_ytd_deprn           IN OUT NOCOPY NUMBER,      -- Delta (New_FY_Ytd_Deprn - Old_FY_Ytd_Deprn)
     p_deprn_basis_formula          IN     NUMBER,
     p_run_mode                     IN     VARCHAR2 DEFAULT 'RUN'
) IS

    l_trans_rec                fa_api_types.trans_rec_type;

Line: 4727


   l_trans_rec.who_info.last_update_date := p_last_update_date;

Line: 4728


   l_trans_rec.who_info.last_updated_by := p_last_updated_by;

Line: 4731


   l_trans_rec.who_info.last_update_login := p_last_update_login;