APPS.FA_TRANSFER_XIT_PKG SQL Statements

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

Line: 23

  SELECT p_psob_id AS sob_id,
         1 AS index_id
    FROM dual
   UNION
  SELECT set_of_books_id AS sob_id,
         2 AS index_id
    FROM fa_mc_book_controls
   WHERE book_type_code = p_book_type_code
     AND primary_set_of_books_id = p_psob_id
     AND enabled_flag = 'Y'
   ORDER BY 2;

Line: 50

                X_last_update_date   IN DATE default sysdate,
                X_last_updated_by    IN NUMBER default -1,
                X_last_update_login  IN NUMBER default -1,
                X_init_message_flag  IN VARCHAR2 DEFAULT 'NO'
 ,p_log_level_rec           IN     FA_API_TYPES.log_level_rec_type default null)
         return BOOLEAN is


   h_amount_cleard NUMBER := 0;

Line: 88

   l_amount_inserted_tr_out    NUMBER;

Line: 127

        select nvl(bk.tracking_method, 'NONE'),
               nvl(bk.member_rollup_flag, 'N')
          into h_tracking_method,
               h_member_rollup_flag
          from fa_books bk
         where asset_id = X_asset_id
           and book_type_code = X_book
           and transaction_header_id_out is null;

Line: 156

     h_adj.last_update_date      := X_today;

Line: 158

     h_adj.selection_thid        := X_thid;

Line: 161

     h_adj.amount_inserted       := 0;

Line: 268

                             X_last_update_date  => X_last_update_date,
                             X_last_updated_by   => X_last_updated_by,
                             X_last_update_login => X_last_update_login,
                             X_mrc_sob_type_code => h_mrc_sob_type_code
                             ,p_log_level_rec => p_log_level_rec)) then
                 raise ERROR_FOUND;

Line: 289

                              X_last_update_date  => X_last_update_date,
                              X_last_updated_by   => X_last_updated_by,
                              X_last_update_login => X_last_update_login,
                              X_mrc_sob_type_code => h_mrc_sob_type_code
                              ,p_log_level_rec => p_log_level_rec)) then
                  raise ERROR_FOUND;

Line: 314

                              X_last_update_date  => X_last_update_date,
                              X_last_updated_by   => X_last_updated_by,
                              X_last_update_login => X_last_update_login,
                              X_mrc_sob_type_code => h_mrc_sob_type_code
                              ,p_log_level_rec => p_log_level_rec)) then
                  raise ERROR_FOUND;

Line: 331

                                 X_last_update_date  => X_last_update_date,
                                 X_last_updated_by   => X_last_updated_by,
                                 X_last_update_login => X_last_update_login,
                                 X_mrc_sob_type_code => h_mrc_sob_type_code
                                 ,p_log_level_rec => p_log_level_rec)) then
                    raise ERROR_FOUND;

Line: 350

                                 X_last_update_date  => X_last_update_date,
                                 X_last_updated_by   => X_last_updated_by,
                                 X_last_update_login => X_last_update_login,
                                 X_mrc_sob_type_code => h_mrc_sob_type_code
                                 ,p_log_level_rec => p_log_level_rec)) then
                     raise ERROR_FOUND;

Line: 414

                 X_last_update_date  IN DATE default sysdate,
                 X_last_updated_by   IN NUMBER default -1,
                 X_last_update_login IN NUMBER default -1,
                 X_mrc_sob_type_code IN VARCHAR2
 ,p_log_level_rec           IN     FA_API_TYPES.log_level_rec_type default null)
         return BOOLEAN is

   h_amount_cleared NUMBER;

Line: 438

                   X_select_mode => fa_adjust_type_pkg.FA_AJ_CLEAR,
                   X_cat_id      => X_old_cat_id,
                   X_asset_type  => X_asset_type
                   ,p_log_level_rec => p_log_level_rec)) then
       raise ERROR_FOUND;

Line: 445

   X_adj_ptr.selection_retid   := X_old_cat_id;

Line: 446

   X_adj_ptr.selection_mode    := fa_adjust_type_pkg.FA_AJ_CLEAR;

Line: 451

                                     X_last_update_date,
                                     X_last_updated_by,
                                     X_last_update_login
                                     ,p_log_level_rec => p_log_level_rec)) then
      if (g_print_debug) then
         fa_debug_pkg.add(fname   => 'FA_TRANSFER_XIT_PKG.fadotfr',
                          element => 'X_acctcode',
                          value   => X_acctcode
                          ,p_log_level_rec => p_log_level_rec);

Line: 465

                          element => 'select_mode',
                          value   => X_adj_ptr.selection_mode
                          ,p_log_level_rec => p_log_level_rec);

Line: 474

   h_amount_cleared := X_adj_ptr.amount_inserted;

Line: 478

   X_adj_ptr.amount_inserted   := 0;

Line: 483

                   X_select_mode => fa_adjust_type_pkg.FA_AJ_ACTIVE,
                   X_cat_id      => X_new_cat_id,
                   X_asset_type  => X_asset_type
,p_log_level_rec => p_log_level_rec)) then
      raise ERROR_FOUND;

Line: 490

   X_adj_ptr.selection_retid   := X_new_cat_id;

Line: 491

   X_adj_ptr.selection_mode    := fa_adjust_type_pkg.FA_AJ_ACTIVE;

Line: 496

                                     X_last_update_date,
                                     X_last_updated_by,
                                     X_last_update_login
                                     ,p_log_level_rec => p_log_level_rec)) then
      if (g_print_debug) then
         fa_debug_pkg.add(fname   => 'FA_TRANSFER_XIT_PKG.fadotfr',
                          element => 'X_acctcode',
                          value   => X_acctcode
                          ,p_log_level_rec => p_log_level_rec);

Line: 510

                          element => 'select_mode',
                          value   => X_adj_ptr.selection_mode
                          ,p_log_level_rec => p_log_level_rec);

Line: 518

   if (h_amount_cleared <> X_adj_ptr.amount_inserted) then
       h_msg_name := 'FA_TFR_UNBAL_AMTS';

Line: 521

       h_token2   := 'INSERTED';

Line: 523

       h_value2   := X_adj_ptr.amount_inserted;

Line: 527

   /* clear the amount inserted */

   X_adj_ptr.amount_inserted := 0;

Line: 557

                 X_select_mode IN NUMBER,
                 X_cat_id      IN NUMBER,
                 X_asset_type  IN VARCHAR2
 ,p_log_level_rec           IN     FA_API_TYPES.log_level_rec_type default null)
        return BOOLEAN is

   h_book          X_adj_ptr.book_type_code%type;

Line: 578

                       element => 'X_select_mode',
                       value   => X_select_mode
                       ,p_log_level_rec => p_log_level_rec);

Line: 593

         select cip_cost_acct
           into X_adj_ptr.account
           from fa_category_books
          where book_type_code = h_book
            and category_id = h_category_id;

Line: 605

         select asset_cost_acct
           into X_adj_ptr.account
           from fa_category_books
          where book_type_code = h_book
            and category_id = h_category_id;

Line: 613

      if (X_select_mode = fa_adjust_type_pkg.FA_AJ_CLEAR) then
         X_adj_ptr.debit_credit_flag := 'CR';

Line: 625

      select deprn_reserve_acct
        into X_adj_ptr.account
        from fa_category_books
       where book_type_code = h_book
         and category_id = h_category_id;

Line: 631

      if (X_select_mode = fa_adjust_type_pkg.FA_AJ_CLEAR) then
         X_adj_ptr.debit_credit_flag := 'DR';

Line: 644

      select bonus_deprn_reserve_acct
        into X_adj_ptr.account
        from fa_category_books
       where book_type_code = h_book
         and category_id = h_category_id;

Line: 650

      if (X_select_mode = fa_adjust_type_pkg.FA_AJ_CLEAR) then
         X_adj_ptr.debit_credit_flag := 'DR';

Line: 662

      select reval_reserve_acct
        into X_adj_ptr.account
        from fa_category_books
       where book_type_code = h_book
         and category_id = h_category_id;

Line: 668

      if (X_select_mode = fa_adjust_type_pkg.FA_AJ_CLEAR) then
         X_adj_ptr.debit_credit_flag := 'DR';

Line: 680

      select ar_intercompany_acct
        into X_adj_ptr.account
        from fa_book_controls
       where book_type_code = h_book;

Line: 685

      if (X_select_mode = fa_adjust_type_pkg.FA_AJ_CLEAR) then
         X_adj_ptr.debit_credit_flag := 'DR';

Line: 697

      select ap_intercompany_acct
        into X_adj_ptr.account
        from fa_book_controls
       where book_type_code = h_book;

Line: 702

      if (X_select_mode = fa_adjust_type_pkg.FA_AJ_CLEAR) then
         X_adj_ptr.debit_credit_flag := 'CR';

Line: 710

   if (X_select_mode = fa_adjust_type_pkg.FA_AJ_CLEAR) then
      X_adj_ptr.source_dest_code := 'SOURCE';

Line: 734

                X_last_update_date  IN DATE default sysdate,
                X_last_updated_by   IN NUMBER default -1,
                X_last_update_login IN NUMBER default -1,
                X_mrc_sob_type_code IN VARCHAR2
 ,p_log_level_rec           IN     FA_API_TYPES.log_level_rec_type default null)
         return BOOLEAN is

  h_dpr        FA_STD_TYPES.FA_DEPRN_ROW_STRUCT;

Line: 753

  h_cost_inserted_so_far      NUMBER := 0;

Line: 754

  h_rsv_inserted_so_far       NUMBER := 0;

Line: 755

  h_rev_inserted_so_far       NUMBER := 0;

Line: 756

  h_bonus_rsv_inserted_so_far NUMBER := 0;

Line: 771

      SELECT
          DECODE(TH.TRANSACTION_HEADER_ID,
                 DH.TRANSACTION_HEADER_ID_OUT, 1,
                 DH.TRANSACTION_HEADER_ID_IN, 2,
                 3),
          TH.TRANSACTION_HEADER_ID,
          DH.DISTRIBUTION_ID,
          DH.CODE_COMBINATION_ID,
          DH.UNITS_ASSIGNED
      FROM
          FA_DISTRIBUTION_HISTORY DH,
          FA_TRANSACTION_HEADERS TH
      WHERE
          TH.TRANSACTION_HEADER_ID = X_adj.selection_thid AND
         (TH.TRANSACTION_HEADER_ID = DH.TRANSACTION_HEADER_ID_IN OR
          TH.TRANSACTION_HEADER_ID = DH.TRANSACTION_HEADER_ID_OUT)
      ORDER BY
          1,
          DH.DISTRIBUTION_ID;

Line: 820

      X_adj.selection_mode := fa_adjust_type_pkg.FA_AJ_TRANSFER_SINGLE;

Line: 870

                         X_select_mode => fa_adjust_type_pkg.FA_AJ_CLEAR,
                         X_cat_id => X_cat_id,
                         X_asset_type => X_asset_type
                         ,p_log_level_rec => p_log_level_rec)) then
            raise ERROR_FOUND;

Line: 882

                                           X_last_update_date,
                                           X_last_updated_by,
                                           X_last_update_login
                                           ,p_log_level_rec => p_log_level_rec)) then
            if (g_print_debug) then
               fa_debug_pkg.add(fname => 'FA_TRANSFER_XIT_PKG.fatsgl',
                                element => 'X_acctcode',
                                value   => 'FA_TFR_COST'
                                ,p_log_level_rec => p_log_level_rec);

Line: 896

                                element => 'select_mode',
                                value   => X_adj.selection_mode
                                ,p_log_level_rec => p_log_level_rec);

Line: 905

         h_total_cost_to_prorate := h_total_cost_to_prorate + X_adj.amount_inserted;

Line: 913

                         X_select_mode => fa_adjust_type_pkg.FA_AJ_CLEAR,
                         X_cat_id      => X_cat_id,
                         X_asset_type  => X_asset_type
                         ,p_log_level_rec => p_log_level_rec)) then
            raise ERROR_FOUND;

Line: 924

                                           X_last_update_date,
                                           X_last_updated_by,
                                           X_last_update_login
                                           ,p_log_level_rec => p_log_level_rec)) then
            if (g_print_debug) then
               fa_debug_pkg.add(fname   => 'FA_TRANSFER_XIT_PKG.fatsgl',
                                element => 'X_acctcode',
                                value   => 'FA_TFR_DEPRN_RSV'
                                ,p_log_level_rec => p_log_level_rec);

Line: 938

                                element => 'select_mode',
                                value   => X_adj.selection_mode
                                ,p_log_level_rec => p_log_level_rec);

Line: 946

         h_total_rsv_to_prorate := h_total_rsv_to_prorate + X_adj.amount_inserted;

Line: 953

                            X_select_mode => fa_adjust_type_pkg.FA_AJ_CLEAR,
                            X_cat_id      => X_cat_id,
                            X_asset_type  => X_asset_type
                            ,p_log_level_rec => p_log_level_rec)) then
               raise ERROR_FOUND;

Line: 963

                                              X_last_update_date,
                                              X_last_updated_by,
                                              X_last_update_login
                                              ,p_log_level_rec => p_log_level_rec)) then
               if (g_print_debug) then
                  fa_debug_pkg.add(fname   => 'FA_TRANSFER_XIT_PKG.fatsgl',
                                   element => 'X_acctcode',
                                   value   => 'FA_TFR_BONUS_DEPRN_RSV'
                                   ,p_log_level_rec => p_log_level_rec);

Line: 977

                                   element => 'select_mode',
                                   value   => X_adj.selection_mode
                                   ,p_log_level_rec => p_log_level_rec);

Line: 988

                                            X_adj.amount_inserted;

Line: 998

                            X_select_mode => fa_adjust_type_pkg.FA_AJ_CLEAR,
                            X_cat_id      => X_cat_id,
                            X_asset_type  => X_asset_type
                            ,p_log_level_rec => p_log_level_rec)) then
               raise ERROR_FOUND;

Line: 1006

                                              X_last_update_date,
                                              X_last_updated_by,
                                              X_last_update_login
                                              ,p_log_level_rec => p_log_level_rec)) then
               if (g_print_debug) then
                  fa_debug_pkg.add(fname   => 'FA_TRANSFER_XIT_PKG.fatsgl',
                                   element => 'X_acctcode',
                                   value   => 'FA_TFR_REVAL_RSV'
                                   ,p_log_level_rec => p_log_level_rec);

Line: 1020

                                   element => 'select_mode',
                                   value   => X_adj.selection_mode
                                   ,p_log_level_rec => p_log_level_rec);

Line: 1029

                                      X_adj.amount_inserted;

Line: 1045

                            X_select_mode => fa_adjust_type_pkg.FA_AJ_ACTIVE,
                            X_cat_id      => X_cat_id,
                            X_asset_type  => X_asset_type
                            ,p_log_level_rec => p_log_level_rec)) then
               raise ERROR_FOUND;

Line: 1062

            h_cost_inserted_so_far := h_cost_inserted_so_far +
                                      X_adj.adjustment_amount;

Line: 1068

                                              X_last_update_date,
                                              X_last_updated_by,
                                              X_last_update_login
                                              ,p_log_level_rec => p_log_level_rec)) then
               if (g_print_debug) then
                  fa_debug_pkg.add(fname   => 'FA_TRANSFER_XIT_PKG.fatsgl',
                                   element => 'X_acctcode',
                                   value   => 'FA_TFR_COST'
                                   ,p_log_level_rec => p_log_level_rec);

Line: 1082

                                   element => 'select_mode',
                                   value   => X_adj.selection_mode
                                   ,p_log_level_rec => p_log_level_rec);

Line: 1095

                            X_select_mode => fa_adjust_type_pkg.FA_AJ_ACTIVE,
                            X_cat_id      => X_cat_id,
                            X_asset_type  => X_asset_type
                            ,p_log_level_rec => p_log_level_rec)) then
               raise ERROR_FOUND;

Line: 1112

            h_rsv_inserted_so_far := h_rsv_inserted_so_far +
                                     X_adj.adjustment_amount;

Line: 1118

                                              X_last_update_date,
                                              X_last_updated_by,
                                              X_last_update_login
                                              ,p_log_level_rec => p_log_level_rec)) then

               if (g_print_debug) then
                  fa_debug_pkg.add(fname   => 'FA_TRANSFER_XIT_PKG.fatsgl',
                                   element => 'X_acctcode',
                                   value   => 'FA_TFR_DEPRN_RSV'
                                   ,p_log_level_rec => p_log_level_rec);

Line: 1133

                                   element => 'select_mode',
                                   value   => X_adj.selection_mode
                                   ,p_log_level_rec => p_log_level_rec);

Line: 1149

                               X_select_mode => fa_adjust_type_pkg.FA_AJ_ACTIVE,
                               X_cat_id      => X_cat_id,
                               X_asset_type  => X_asset_type
                               ,p_log_level_rec => p_log_level_rec)) then
                      raise ERROR_FOUND;

Line: 1166

               h_bonus_rsv_inserted_so_far := h_bonus_rsv_inserted_so_far +
                                              X_adj.adjustment_amount;

Line: 1172

                                                 X_last_update_date,
                                                 X_last_updated_by,
                                                 X_last_update_login
                                                 ,p_log_level_rec => p_log_level_rec)) then

                  if (g_print_debug) then
                     fa_debug_pkg.add(fname   => 'FA_TRANSFER_XIT_PKG.fatsgl',
                                      element => 'X_acctcode',
                                      value   => 'FA_TFR_BONUS_DEPRN_RSV'
                                      ,p_log_level_rec => p_log_level_rec);

Line: 1187

                                      element => 'select_mode',
                                      value   => X_adj.selection_mode
                                      ,p_log_level_rec => p_log_level_rec);

Line: 1200

                               X_select_mode => fa_adjust_type_pkg.FA_AJ_ACTIVE,
                               X_cat_id      => X_cat_id,
                               X_asset_type  => X_asset_type
                               ,p_log_level_rec => p_log_level_rec)) then
                  raise ERROR_FOUND;

Line: 1217

               h_rev_inserted_so_far := h_rev_inserted_so_far +
                                        X_adj.adjustment_amount;

Line: 1223

                                                 X_last_update_date,
                                                 X_last_updated_by,
                                                 X_last_update_login
                                                 ,p_log_level_rec => p_log_level_rec)) then
                  if (g_print_debug) then
                     fa_debug_pkg.add(fname   => 'FA_TRANSFER_XIT_PKG.fatsgl',
                                      element => 'X_acctcode',
                                      value   => 'FA_TFR_REVAL_RSV'
                                      ,p_log_level_rec => p_log_level_rec);

Line: 1237

                                      element => 'select_mode',
                                      value   => X_adj.selection_mode
                                      ,p_log_level_rec => p_log_level_rec);

Line: 1254

                            X_select_mode => fa_adjust_type_pkg.FA_AJ_ACTIVE,
                            X_cat_id      => X_cat_id,
                            X_asset_type  => X_asset_type
                            ,p_log_level_rec => p_log_level_rec)) then
               raise ERROR_FOUND;

Line: 1263

                                       h_cost_inserted_so_far;

Line: 1268

                                              X_last_update_date,
                                              X_last_updated_by,
                                              X_last_update_login
                                              ,p_log_level_rec => p_log_level_rec)) then
               if (g_print_debug) then
                  fa_debug_pkg.add(fname   => 'FA_TRANSFER_XIT_PKG.fatsgl',
                                   element => 'X_acctcode',
                                   value   => 'FA_TFR_COST'
                                   ,p_log_level_rec => p_log_level_rec);

Line: 1282

                                   element => 'select_mode',
                                   value   => X_adj.selection_mode
                                   ,p_log_level_rec => p_log_level_rec);

Line: 1295

                            X_select_mode => fa_adjust_type_pkg.FA_AJ_ACTIVE,
                            X_cat_id      => X_cat_id,
                            X_asset_type  => X_asset_type
                            ,p_log_level_rec => p_log_level_rec)) then
               raise ERROR_FOUND;

Line: 1303

                                       h_rsv_inserted_so_far;

Line: 1308

                                              X_last_update_date,
                                              X_last_updated_by,
                                              X_last_update_login
                                              ,p_log_level_rec => p_log_level_rec)) then
               if (g_print_debug) then
                  fa_debug_pkg.add(fname   => 'FA_TRANSFER_XIT_PKG.fatsgl',
                                   element => 'X_acctcode',
                                   value   => 'FA_TFR_DEPRN_RSV'
                                   ,p_log_level_rec => p_log_level_rec);

Line: 1322

                                   element => 'select_mode',
                                   value   => X_adj.selection_mode
                                   ,p_log_level_rec => p_log_level_rec);

Line: 1335

                               X_select_mode => fa_adjust_type_pkg.FA_AJ_ACTIVE,
                               X_cat_id      => X_cat_id,
                               X_asset_type  => X_asset_type
                               ,p_log_level_rec => p_log_level_rec)) then
                  raise ERROR_FOUND;

Line: 1343

                                          h_bonus_rsv_inserted_so_far;

Line: 1348

                                                 X_last_update_date,
                                                 X_last_updated_by,
                                                 X_last_update_login
                                                 ,p_log_level_rec => p_log_level_rec)) then
                  if (g_print_debug) then
                     fa_debug_pkg.add(fname   => 'FA_TRANSFER_XIT_PKG.fatsgl',
                                      element => 'X_acctcode',
                                      value   => 'FA_TFR_BONUS_DEPRN_RSV'
                                      ,p_log_level_rec => p_log_level_rec);

Line: 1362

                                      element => 'select_mode',
                                      value   => X_adj.selection_mode
                                      ,p_log_level_rec => p_log_level_rec);

Line: 1377

                               X_select_mode => fa_adjust_type_pkg.FA_AJ_ACTIVE,
                               X_cat_id      => X_cat_id,
                               X_asset_type  => X_asset_type
                               ,p_log_level_rec => p_log_level_rec)) then
                  raise ERROR_FOUND;

Line: 1385

                                          h_rev_inserted_so_far;

Line: 1390

                                                 X_last_update_date,
                                                 X_last_updated_by,
                                                 X_last_update_login
                                                 ,p_log_level_rec => p_log_level_rec)) then
                  if (g_print_debug) then
                     fa_debug_pkg.add(fname   => 'FA_TRANSFER_XIT_PKG.fatsgl',
                                      element => 'X_acctcode',
                                      value   => 'FA_TFR_REVAL_RSV'
                                      ,p_log_level_rec => p_log_level_rec);

Line: 1404

                                      element => 'select_mode',
                                      value   => X_adj.selection_mode
                                      ,p_log_level_rec => p_log_level_rec);