APPS.IGI_IMP_IAC_IMPORT_PKG SQL Statements

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

Line: 22

         SELECT COUNT(*)
         FROM   fnd_concurrent_programs
         WHERE  concurrent_program_name = p_program_name
         AND    concurrent_program_id = FND_GLOBAL.Conc_Program_Id
         AND    application_id = FND_GLOBAL.Prog_Appl_Id;

Line: 136

      UPDATE igi_imp_iac_intermediate
      SET    request_id             = l_request_id
            ,program_id             = FND_GLOBAL.Conc_Program_Id
            ,program_application_id = FND_GLOBAL.Prog_Appl_Id
            ,program_update_date    = SYSDATE
      WHERE  errored_flag IS NULL;

Line: 186

   PROCEDURE Validate_Update_IMP_Data ( p_file_name      IN  VARCHAR2
                                      , p_book_type_code IN  VARCHAR2
                                      , p_category_id    IN  NUMBER
                                      ) IS

       -- Count records to process
      CURSOR c_count_recs IS
         SELECT COUNT(*)
         FROM   igi_imp_iac_intermediate
         WHERE  errored_flag IS NULL;

Line: 199

         SELECT asset_id
               ,asset_number
               ,book_type_code
               ,category_id
               ,cost_mhca
               ,ytd_mhca
               ,accum_deprn_mhca
               ,reval_reserve_mhca
               ,backlog_mhca
               ,general_fund_mhca
               ,operating_account_cost
               ,operating_account_backlog
               ,request_id
               ,program_application_id
               ,program_id
               ,program_update_date
         FROM   igi_imp_iac_intermediate
         WHERE  errored_flag IS NULL;

Line: 223

         SELECT COUNT(*)
         FROM   igi_imp_iac_interface
         WHERE  asset_id       = cp_asset_id
         AND    asset_number   = cp_asset_number
         AND    book_type_code = cp_book_type_code
         AND    category_id    = cp_category_id;

Line: 237

         SELECT transfer_status
         FROM   igi_imp_iac_interface_ctrl
         WHERE  book_type_code = cp_book_type_code
         AND    category_id    = cp_category_id;

Line: 243

         Select book_class
         from fa_booK_controls
         where book_type_code = cp_book_type_code;

Line: 249

           select depreciate_flag
           from fa_books
            where book_type_code =cp_book_type_code
             and  asset_id =cp_asset_id
             and transaction_header_id_out is null;

Line: 277

      l_path_name VARCHAR2(150) := g_path||'validate_update_imp_data';

Line: 407

            UPDATE igi_imp_iac_interface
            SET    cost_mhca = cv_recs_to_process.cost_mhca
                  ,ytd_mhca = cv_recs_to_process.ytd_mhca
                  ,accum_deprn_mhca = cv_recs_to_process.accum_deprn_mhca
                  ,reval_reserve_mhca = cv_recs_to_process.reval_reserve_mhca
                  ,backlog_mhca = cv_recs_to_process.backlog_mhca
                  ,general_fund_mhca = cv_recs_to_process.general_fund_mhca
                  ,operating_account_cost = (-1) * cv_recs_to_process.operating_account_cost
                  ,operating_account_backlog = (-1) * cv_recs_to_process.operating_account_backlog
                  ,import_file = l_file_name
                  ,import_date = SYSDATE
                  ,request_id = cv_recs_to_process.request_id
                  ,program_id = cv_recs_to_process.program_id
                  ,program_application_id = cv_recs_to_process.program_application_id
                  ,program_update_date = cv_recs_to_process.program_update_date
		  ,valid_flag = 'N'
            WHERE  asset_id = cv_recs_to_process.asset_id
            AND    asset_number = cv_recs_to_process.asset_number
            AND    book_type_code = cv_recs_to_process.book_type_code
            AND    category_id = cv_recs_to_process.category_id;

Line: 429

            UPDATE igi_imp_iac_interface
            SET    cost_mhca = cv_recs_to_process.cost_mhca
                  ,reval_reserve_mhca = cv_recs_to_process.reval_reserve_mhca
                  ,operating_account_cost = (-1) * cv_recs_to_process.operating_account_cost
                  ,import_file = l_file_name
                  ,import_date = SYSDATE
                  ,request_id = cv_recs_to_process.request_id
                  ,program_id = cv_recs_to_process.program_id
                  ,program_application_id = cv_recs_to_process.program_application_id
                  ,program_update_date = cv_recs_to_process.program_update_date
		  ,valid_flag = 'N'
            WHERE  asset_id = cv_recs_to_process.asset_id
            AND    asset_number = cv_recs_to_process.asset_number
            AND    book_type_code = cv_recs_to_process.book_type_code
            AND    category_id = cv_recs_to_process.category_id;

Line: 449

            DELETE FROM igi_imp_iac_intermediate
            WHERE  asset_id = cv_recs_to_process.asset_id
            AND    asset_number = cv_recs_to_process.asset_number
            AND    book_type_code = cv_recs_to_process.book_type_code
            AND    category_id = cv_recs_to_process.category_id;

Line: 458

            UPDATE igi_imp_iac_intermediate
            SET    errored_flag = 'Y'
            WHERE  asset_id       = cv_recs_to_process.asset_id
            AND    asset_number   = cv_recs_to_process.asset_number
            AND    book_type_code = cv_recs_to_process.book_type_code
            AND    category_id    = cv_recs_to_process.category_id;

Line: 498

   END Validate_Update_IMP_Data;

Line: 513

         SELECT request_status
         FROM   igi_imp_iac_controls
         WHERE  book_type_code = cp_book_type_code;

Line: 522

         SELECT COUNT(*)
         FROM   igi_imp_iac_interface_ctrl
         WHERE  book_type_code = cp_book_type_code
         AND    category_id = cp_category_id;

Line: 530

         SELECT COUNT(DISTINCT group_id)
         FROM   igi_imp_iac_interface
         WHERE  book_type_code = cp_book_type_code
         AND    category_id = cp_category_id
         AND    group_id IS NOT NULL;

Line: 539

         SELECT DISTINCT group_id
         FROM   igi_imp_iac_interface
         WHERE  book_type_code = cp_book_type_code
         AND    category_id = cp_category_id
         AND    group_id IS NOT NULL;

Line: 603

      DELETE FROM igi_imp_iac_intermediate;

Line: 641

         Validate_Update_IMP_Data( l_file_name
                                 , l_book_type_code
                                 , l_category_id
                                 );