APPS.FA_INV_XFR_PUB SQL Statements

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

Line: 186

   FA_INVOICE_TRANSACTIONS_PKG.Insert_Row
     (X_Rowid                     => l_rowid,
      X_Invoice_Transaction_Id    => l_inv_trans_rec.invoice_transaction_id ,
      X_Book_Type_Code            => px_src_asset_hdr_rec.book_type_code,
      X_Transaction_Type          => l_inv_trans_rec.transaction_type,
      X_Date_Effective            => sysdate,
      X_Calling_Fn                => l_calling_fn
     ,p_log_level_rec => g_log_level_rec);

Line: 323

   select asset_type,
          current_units
     into l_from_asset_type,
          l_from_current_units
     from fa_additions_b
    where asset_id = px_src_asset_hdr_rec.asset_id;

Line: 330

   select asset_type,
          current_units
     into l_to_asset_type,
          l_to_current_units
     from fa_additions_b
    where asset_id = px_dest_asset_hdr_rec.asset_id;

Line: 341

   select fa_transaction_headers_s.nextval
     into px_src_trans_rec.transaction_header_id
     from dual;

Line: 345

   select fa_transaction_headers_s.nextval
     into px_dest_trans_rec.transaction_header_id
     from dual;

Line: 385

   select fa_trx_references_s.nextval
     into px_src_trans_rec.trx_reference_id
     from dual;

Line: 414

   fa_trx_references_pkg.insert_row
      (X_Rowid                          => l_rowid,
       X_Trx_Reference_Id               => px_src_trans_rec.trx_reference_id,
       X_Book_Type_Code                 => px_src_asset_hdr_rec.book_type_code,
       X_Src_Asset_Id                   => px_src_asset_hdr_rec.asset_id,
       X_Src_Transaction_Header_Id      => px_src_trans_rec.transaction_header_id,
       X_Dest_Asset_Id                  => px_dest_asset_hdr_rec.asset_id,
       X_Dest_Transaction_Header_Id     => px_dest_trans_rec.transaction_header_id,
       X_Member_Asset_Id                => null,
       X_Member_Transaction_Header_Id   => null,
       X_Transaction_Type               => 'INVOICE TRANSFER',
       X_Src_Transaction_Subtype        => px_src_trans_rec.transaction_subtype,       X_Dest_Transaction_Subtype       => px_dest_trans_rec.transaction_subtype,
       X_Src_Amortization_Start_Date    => px_src_trans_rec.amortization_start_date,
       X_Dest_Amortization_Start_Date   => px_dest_trans_rec.amortization_start_date,
       X_Reserve_Transfer_Amount        => null,
       X_Src_Expense_Amount             => null,
       X_Dest_Expense_Amount            => null,
       X_Src_Eofy_Reserve               => null,
       X_Dest_Eofy_Reserve              => null,
       X_event_id                    => px_src_trans_rec.event_id,
       X_Invoice_Transaction_Id      => l_inv_trans_rec.invoice_transaction_id,
       X_Creation_Date                  => px_src_trans_rec.who_info.creation_date,
       X_Created_By                     => px_src_trans_rec.who_info.created_by,       X_Last_Update_Date               => px_src_trans_rec.who_info.last_update_date,
       X_Last_Updated_By                => px_src_trans_rec.who_info.last_updated_by,
       X_Last_Update_Login              => px_src_trans_rec.who_info.last_update_login,
       X_Return_Status                  => l_return_status_bool,
       X_Calling_Fn                     => l_calling_fn,
       p_log_level_rec => g_log_level_rec);

Line: 565

   delete from fa_adjustments
    where asset_id              in (px_src_asset_hdr_rec.asset_id,
                                    px_dest_asset_hdr_rec.asset_id
                                    )
      and book_type_code         = px_src_asset_hdr_rec.book_type_code
      and period_counter_created = l_current_period_counter
      and transaction_header_id in (px_dest_trans_rec.transaction_header_id,
                                    px_src_trans_rec.transaction_header_id
                                    )
      and adjustment_type        = 'COST CLEARING';

Line: 576

   delete from fa_mc_adjustments
    where asset_id              in (px_src_asset_hdr_rec.asset_id,
                                    px_dest_asset_hdr_rec.asset_id
                                    )
      and book_type_code         = px_src_asset_hdr_rec.book_type_code
      and period_counter_created = l_current_period_counter
      and transaction_header_id in (px_dest_trans_rec.transaction_header_id,
                                    px_src_trans_rec.transaction_header_id
                                    )
      and adjustment_type        = 'COST CLEARING';

Line: 593

   update fa_adjustments
      set source_dest_code =
          decode(transaction_header_Id,
                 px_src_trans_rec.transaction_header_id, 'SOURCE',
                 'DEST')
   where transaction_header_id in
         (px_src_trans_rec.transaction_header_id,
          px_dest_trans_rec.transaction_header_id
          );