APPS.FA_TRX_APPROVAL_PKG SQL Statements

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

Line: 101

        SELECT count(*)
          INTO h_mrc_book_count
          FROM fa_mc_book_controls
         WHERE book_type_code = X_book
           AND enabled_flag = 'Y';

Line: 108

            SELECT COUNT(*) INTO h_count
            FROM fa_retirements faret
            WHERE faret.asset_id = X_asset_id
            AND   faret.book_type_code = X_book
            AND   UPPER(faret.status) in ('PENDING', 'REINSTATE');

Line: 118

            SELECT COUNT(*) INTO h_count_mrc
            FROM fa_retirements ret,
                 fa_mc_retirements mc_ret,
                 fa_mc_book_controls mc_bks
            WHERE ret.asset_id          = X_asset_id
            AND   ret.book_type_code    = X_book
            AND   mc_bks.book_type_code = X_book
            AND   mc_bks.enabled_flag   = 'Y'
            AND   ret.retirement_id     = mc_ret.retirement_id
            AND   UPPER(mc_ret.status) in ('PENDING', 'REINSTATE')
            AND   mc_ret.set_of_books_id = mc_bks.set_of_books_id;

Line: 141

                (X_trx_type = 'DELETE REINSTATEMENT')) then
               /*  correcting BUG# 1340968 to not use "!="  */
               IF (h_mrc_book_count <> 0) THEN
                  IF (h_count <> (h_count_mrc/h_mrc_book_count))  THEN
                     FA_SRVR_MSG.add_message
                     (CALLING_FN  =>  'FA_TRX_APPROVAL_PKG.faxcti',
                     NAME         =>  'FA_SHARED_PENDING_RETIREMENT',  p_log_level_rec => p_log_level_rec);

Line: 178

               SELECT COUNT(*) INTO h_count
               FROM fa_retirements faret
               WHERE faret.asset_id = X_asset_id
               AND   faret.book_type_code = l_corp_book
               AND   UPPER(faret.status) in ('PENDING');

Line: 189

               SELECT COUNT(*) INTO h_count_mrc
               FROM fa_retirements ret,
                    fa_mc_retirements mc_ret,
                    fa_mc_book_controls mc_bks
               WHERE ret.asset_id          = X_asset_id
               AND   ret.book_type_code    = l_corp_book
               AND   mc_bks.book_type_code = l_corp_book
               AND   mc_bks.enabled_flag   = 'Y'
               AND   ret.retirement_id     = mc_ret.retirement_id
               AND   UPPER(mc_ret.status) in ('PENDING')
               AND   mc_ret.set_of_books_id = mc_bks.set_of_books_id;

Line: 207

                   (X_trx_type = 'DELETE REINSTATEMENT')) then
                  /*  correcting BUG# 1340968 to not use "!="  */
                  IF (h_mrc_book_count <> 0) THEN
                     IF (h_count <> (h_count_mrc/h_mrc_book_count))  THEN
                        FA_SRVR_MSG.add_message
                        (CALLING_FN  =>  'FA_TRX_APPROVAL_PKG.faxcti',
                         NAME         =>  'FA_SHARED_PENDING_RETIREMENT'
                         ,p_log_level_rec => p_log_level_rec);

Line: 240

                SELECT units
		INTO h_ah_units
		FROM fa_asset_history
                WHERE asset_id = X_asset_id
                AND date_ineffective IS NULL;

Line: 250

            	SELECT SUM(units_assigned)
		INTO h_dh_units
		FROM fa_distribution_history
            	WHERE asset_id = X_asset_id
            	AND date_ineffective IS NULL;

Line: 282

        FA_TRACK_MEMBER_PVT.p_track_member_table.delete;

Line: 284

        FA_TRACK_MEMBER_PVT.p_track_mem_index_table.delete;