APPS.FA_INV_XFR_PUB SQL Statements

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

Line: 105

   SELECT BK.GROUP_ASSET_ID
     FROM FA_BOOKS BK,FA_DEPRN_PERIODS DP
    WHERE BK.ASSET_ID = PX_SRC_ASSET_HDR_REC.ASSET_ID
      AND BK.BOOK_TYPE_CODE = PX_SRC_ASSET_HDR_REC.BOOK_TYPE_CODE
      AND BK.DATE_INEFFECTIVE IS NULL
      AND BK.GROUP_ASSET_ID IS NOT NULL
      AND DP.BOOK_TYPE_CODE = BK.BOOK_TYPE_CODE
      AND DP.PERIOD_CLOSE_DATE IS NULL
      AND DP.CALENDAR_PERIOD_OPEN_DATE > PX_SRC_TRANS_REC.AMORTIZATION_START_DATE;

Line: 116

   SELECT BK.GROUP_ASSET_ID
     FROM FA_BOOKS BK,FA_DEPRN_PERIODS DP
    WHERE BK.ASSET_ID = PX_DEST_ASSET_HDR_REC.ASSET_ID
      AND BK.BOOK_TYPE_CODE = PX_DEST_ASSET_HDR_REC.BOOK_TYPE_CODE
      AND BK.DATE_INEFFECTIVE IS NULL
      AND BK.GROUP_ASSET_ID IS NOT NULL
      AND DP.BOOK_TYPE_CODE = BK.BOOK_TYPE_CODE
      AND DP.PERIOD_CLOSE_DATE IS NULL
      AND DP.CALENDAR_PERIOD_OPEN_DATE > PX_DEST_TRANS_REC.AMORTIZATION_START_DATE;

Line: 222

   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: 363

   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: 370

   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: 418

   select fa_trx_references_s.nextval
     into px_src_trans_rec.trx_reference_id
     from dual;

Line: 450

   select fa_transaction_headers_s.nextval
     into px_src_trans_rec.transaction_header_id
     from dual;

Line: 454

   select fa_transaction_headers_s.nextval
     into px_dest_trans_rec.transaction_header_id
     from dual;

Line: 459

   px_src_trans_rec.who_info.last_update_date := sysdate;

Line: 477

    create/update/delete event for secondary ledger*/
   l_secondary_sob_id := FA_XLA_EVENTS_PVT.get_secondary_sob_id(px_src_asset_hdr_rec.book_type_code);

Line: 508

   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: 601

      px_dest_trans_rec.who_info.last_update_date := sysdate;

Line: 703

      select sum(decode(adjustment_type,
                        'INTERCO AR', decode(debit_credit_flag,
                                             'DR', adjustment_amount,
                                                   -adjustment_amount),
                        'INTERCO AP', decode(debit_credit_flag,
                                             'CR', adjustment_amount,
                                                   -adjustment_amount),
                        decode(debit_credit_flag,
                               'CR', adjustment_amount,
                                     -adjustment_amount)))
        from fa_adjustments
       where asset_id               = p_asset_id
         and book_type_code         = p_book_type_code
         and period_counter_created = p_period_counter
         and transaction_header_id  = p_thid
         and adjustment_type        like p_adj_type;

Line: 726

      select sum(decode(adjustment_type,
                        'INTERCO AR', decode(debit_credit_flag,
                                             'DR', adjustment_amount,
                                                   -adjustment_amount),
                        'INTERCO AP', decode(debit_credit_flag,
                                             'CR', adjustment_amount,
                                                   -adjustment_amount),
                        decode(debit_credit_flag,
                               'CR', adjustment_amount,
                                     -adjustment_amount)))
        from fa_mc_adjustments
       where asset_id               = p_asset_id
         and book_type_code         = p_book_type_code
         and period_counter_created = p_period_counter
         and transaction_header_id  = p_thid
         and adjustment_type        like p_adj_type
         and set_of_books_id        = l_set_of_books_id;

Line: 857

         l_adj.selection_mode           := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;

Line: 858

         l_adj.selection_thid           := 0;

Line: 859

         l_adj.selection_retid          := 0;

Line: 861

         l_adj.last_update_date         := p_src_trans_rec.who_info.last_update_date;

Line: 893

                    p_src_trans_rec.who_info.last_update_date,
                    p_src_trans_rec.who_info.last_updated_by,
                    p_src_trans_rec.who_info.last_update_login, p_log_level_rec => p_log_level_rec) then
            raise inv_xfr_err;

Line: 912

         l_adj.selection_mode           := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;

Line: 913

         l_adj.selection_thid           := 0;

Line: 914

         l_adj.selection_retid          := 0;

Line: 916

         l_adj.last_update_date         := p_dest_trans_rec.who_info.last_update_date;

Line: 948

                    p_src_trans_rec.who_info.last_update_date,
                    p_src_trans_rec.who_info.last_updated_by,
                    p_src_trans_rec.who_info.last_update_login, p_log_level_rec => p_log_level_rec) then
            raise inv_xfr_err;

Line: 1092

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

Line: 1097

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

Line: 1114

      delete from fa_adjustments
       where asset_id              in (l_src_asset_hdr_rec.asset_id,l_dest_asset_hdr_rec.asset_id)
         and book_type_code         = l_src_asset_hdr_rec.book_type_code
         and period_counter_created = l_current_period_counter
         and transaction_header_id in (l_dest_trans_rec.transaction_header_id,l_src_trans_rec.transaction_header_id)
         and adjustment_type        = 'COST CLEARING';

Line: 1121

      delete from fa_mc_adjustments
       where asset_id              in (l_src_asset_hdr_rec.asset_id,l_dest_asset_hdr_rec.asset_id)
         and book_type_code         = l_src_asset_hdr_rec.book_type_code
         and period_counter_created = l_current_period_counter
         and transaction_header_id in (l_dest_trans_rec.transaction_header_id,l_src_trans_rec.transaction_header_id)
         and adjustment_type        = 'COST CLEARING';

Line: 1142

      SELECT CODE_COMBINATION_ID
        INTO l_clearing_ccid
        FROM FA_ADJUSTMENTS
       WHERE ASSET_ID              = l_src_asset_hdr_rec.asset_id
         AND BOOK_TYPE_CODE        = l_src_asset_hdr_rec.book_type_code
         AND TRANSACTION_HEADER_ID = l_src_trans_rec.transaction_header_id
         AND ADJUSTMENT_TYPE       = 'COST CLEARING'
         AND ROWNUM                < 2;

Line: 1155

         delete from fa_adjustments
          where asset_id              in (l_src_asset_hdr_rec.asset_id,l_dest_asset_hdr_rec.asset_id)
            and book_type_code         = l_src_asset_hdr_rec.book_type_code
            and period_counter_created = l_current_period_counter
            and transaction_header_id in (l_dest_trans_rec.transaction_header_id,l_src_trans_rec.transaction_header_id)
            and adjustment_type        = 'COST CLEARING';

Line: 1162

         delete from fa_mc_adjustments
          where asset_id              in (l_src_asset_hdr_rec.asset_id,l_dest_asset_hdr_rec.asset_id)
            and book_type_code         = l_src_asset_hdr_rec.book_type_code
            and period_counter_created = l_current_period_counter
            and transaction_header_id in (l_dest_trans_rec.transaction_header_id,l_src_trans_rec.transaction_header_id)
            and adjustment_type        = 'COST CLEARING';

Line: 1195

         UPDATE FA_ADJUSTMENTS
            SET CODE_COMBINATION_ID   = l_clearing_ccid,
                DEBIT_CREDIT_FLAG     = DECODE(DEBIT_CREDIT_FLAG, 'CR','DR','CR'),
                ADJUSTMENT_AMOUNT     = -1 * ADJUSTMENT_AMOUNT
          WHERE ASSET_ID              = l_src_asset_hdr_rec.asset_id
            AND BOOK_TYPE_CODE        = l_src_asset_hdr_rec.book_type_code
            AND TRANSACTION_HEADER_ID = l_src_trans_rec.transaction_header_id
            AND ADJUSTMENT_TYPE       = 'COST CLEARING';

Line: 1204

         UPDATE FA_MC_ADJUSTMENTS
            SET CODE_COMBINATION_ID   = l_clearing_ccid,
                DEBIT_CREDIT_FLAG     = DECODE(DEBIT_CREDIT_FLAG, 'CR','DR','CR'),
                ADJUSTMENT_AMOUNT     = -1 * ADJUSTMENT_AMOUNT
         WHERE ASSET_ID               = l_src_asset_hdr_rec.asset_id
            AND BOOK_TYPE_CODE        = l_src_asset_hdr_rec.book_type_code
            AND TRANSACTION_HEADER_ID = l_src_trans_rec.transaction_header_id
            AND ADJUSTMENT_TYPE       = 'COST CLEARING';

Line: 1213

         UPDATE FA_ADJUSTMENTS
            SET CODE_COMBINATION_ID   = l_clearing_ccid,
                DEBIT_CREDIT_FLAG     = DECODE(DEBIT_CREDIT_FLAG, 'CR','DR','CR'),
                ADJUSTMENT_AMOUNT     = -1 * ADJUSTMENT_AMOUNT
          WHERE ASSET_ID              = l_dest_asset_hdr_rec.asset_id
            AND BOOK_TYPE_CODE        = l_dest_asset_hdr_rec.book_type_code
            AND TRANSACTION_HEADER_ID = l_dest_trans_rec.transaction_header_id
            AND ADJUSTMENT_TYPE       = 'COST CLEARING';

Line: 1222

         UPDATE FA_MC_ADJUSTMENTS
            SET CODE_COMBINATION_ID   = l_clearing_ccid,
                DEBIT_CREDIT_FLAG     = DECODE(DEBIT_CREDIT_FLAG, 'CR','DR','CR'),
                ADJUSTMENT_AMOUNT     = -1 * ADJUSTMENT_AMOUNT
          WHERE ASSET_ID              = l_dest_asset_hdr_rec.asset_id
            AND BOOK_TYPE_CODE        = l_dest_asset_hdr_rec.book_type_code
            AND TRANSACTION_HEADER_ID = l_dest_trans_rec.transaction_header_id
            AND ADJUSTMENT_TYPE       = 'COST CLEARING';

Line: 1236

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

Line: 1240

   update fa_mc_adjustments
      set source_dest_code =decode(transaction_header_Id,l_src_trans_rec.transaction_header_id, 'SOURCE','DEST')
   where transaction_header_id in (l_src_trans_rec.transaction_header_id,l_dest_trans_rec.transaction_header_id);