APPS.IGI_IMP_IAC_WEBADI_PKG SQL Statements

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

Line: 22

     SELECT request_status
     INTO l_req_status
     FROM igi_imp_iac_controls
     WHERE book_type_code = n_book_code;

Line: 44

    SELECT COUNT(*)
    INTO l_count
    FROM   igi_imp_iac_interface_ctrl
    WHERE  book_type_code = n_book_code
    AND    category_id = (SELECT category_id
                          FROM fa_categories_b_kfv
                          WHERE concatenated_segments = n_category_desc);

Line: 68

     SELECT transfer_status
     INTO l_tfr_stat
     FROM   igi_imp_iac_interface_ctrl
     WHERE  book_type_code = n_book_code
     AND    category_id    = (SELECT category_id
                              FROM fa_categories_b_kfv
                              WHERE concatenated_segments = n_category_desc);

Line: 94

     SELECT COUNT(*)
     INTO l_count
     FROM igi_imp_iac_interface
     WHERE asset_id = (SELECT asset_id
                       FROM fa_additions
                       WHERE asset_number = n_asset_number)
     AND   book_type_code = n_book_code
     AND   category_id = (SELECT category_id
                          FROM fa_categories_b_kfv
                          WHERE concatenated_segments = n_category_desc);

Line: 124

     SELECT COUNT(*)
     INTO l_count
     FROM igi_imp_iac_interface
     WHERE asset_id = (SELECT asset_id
                       FROM fa_additions
                       WHERE asset_number = n_asset_number)
     AND   book_type_code = n_book_code
     AND   group_id = n_group_id
     AND   category_id = (SELECT category_id
                          FROM fa_categories_b_kfv
                          WHERE concatenated_segments = n_category_desc);

Line: 167

  SELECT COUNT(*)
  FROM igi_imp_iac_interface
  WHERE asset_id = (SELECT asset_id
                    FROM fa_additions
                    WHERE asset_number = p_asset_number)
  AND   book_type_code = p_book_code
  AND   category_id = (SELECT category_id
                       FROM fa_categories_b_kfv
                       WHERE concatenated_segments = p_category_desc);

Line: 178

         Select book_class
         from fa_booK_controls
         where book_type_code = cp_book_type_code;

Line: 184

           select depreciate_flag
           from fa_books fb,fa_additions fa
            where book_type_code =cp_book_type_code
             and fa.asset_number = cp_asset_num
            and  fb.asset_id =fa.asset_id
             and transaction_header_id_out is null;

Line: 212

  e_update_error           EXCEPTION;

Line: 310

     UPDATE igi_imp_iac_interface
        SET
        cost_mhca                 =  p_cost_mhca,
           ytd_mhca                  =  p_ytd_mhca,
           accum_deprn_mhca          =  p_accum_deprn_mhca,
           reval_reserve_mhca        =  p_reval_reserve_mhca,
           backlog_mhca              =  p_backlog_mhca,
           general_fund_mhca         =  p_general_fund_mhca,
           operating_account_cost    = nvl(p_operating_account_cost,0) * -1,
           operating_account_backlog = nvl(p_operating_account_backlog,0) * -1,
           last_update_login         = fnd_global.login_id,
           last_update_date          = sysdate,
           last_updated_by           = fnd_global.login_id,
	   valid_flag                = 'N'     -- Bug 5137813
         WHERE group_id = p_group_id
     AND   asset_number = p_asset_number
     AND   book_type_code = p_book_code;

Line: 328

       UPDATE igi_imp_iac_interface
        SET
           cost_mhca                 =  p_cost_mhca,
           reval_reserve_mhca        =  p_reval_reserve_mhca,
	   operating_account_cost    = nvl(p_operating_account_cost,0) * -1,
           last_update_login         = fnd_global.login_id,
           last_update_date          = sysdate,
           last_updated_by           = fnd_global.login_id,
           valid_flag                = 'N' --Bug 5137813
       WHERE group_id = p_group_id
     AND   asset_number = p_asset_number
     AND   book_type_code = p_book_code;

Line: 345

    RAISE e_update_error;

Line: 348

 igi_iac_debug_pkg.debug_other_string(g_event_level, g_path||'upload_data', 'Update successful');

Line: 406

      WHEN e_update_error THEN
         FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_UPDATE_ERR_ADI');