APPS.FA_ADDITION_PUB SQL Statements

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

Line: 222

      select fa_transaction_headers_s.nextval
      into   l_trans_rec.transaction_header_id
      from   dual;

Line: 274

         select fa_transaction_headers_s.nextval
         into   px_dist_trans_rec.transaction_header_id
         from   dual;

Line: 438

            l_asset_fin_mrc_tbl_new.delete;

Line: 439

            l_asset_deprn_mrc_tbl.delete;

Line: 662

         if (NOT fa_addition_pvt.insert_asset (
            p_trans_rec              => l_trans_rec,
            p_dist_trans_rec         => px_dist_trans_rec,
            p_asset_hdr_rec          => l_mrc_asset_hdr_rec,
            p_asset_desc_rec         => px_asset_desc_rec,
            p_asset_type_rec         => px_asset_type_rec,
            p_asset_cat_rec          => px_asset_cat_rec,
            p_asset_hierarchy_rec    => px_asset_hierarchy_rec,
            p_asset_fin_rec          => l_mrc_asset_fin_rec_new,
            p_asset_deprn_rec        => l_mrc_asset_deprn_rec_new,
            px_asset_dist_tbl        => px_asset_dist_tbl,
            p_inv_trans_rec          => l_inv_trans_rec,
            p_primary_cost           => l_asset_fin_rec_new.cost,
            p_exchange_rate          => l_exchange_rate,
            x_return_status          => x_return_status,
            p_mrc_sob_type_code      => l_reporting_flag,
            p_period_rec             => l_period_rec,
            p_calling_fn             => 'fa_addition_pub.do_addition',
            p_log_level_rec           => g_log_level_rec)) then
            raise add_err2;

Line: 744

               select fa_transaction_headers_s.nextval
                 into l_group_trans_rec.transaction_header_id
                 from dual;