APPS.AP_WEB_UTIL_PKG SQL Statements

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

Line: 48

 * Updates the download columns in AP_CARD_PROGRAMS_ALL
 */
PROCEDURE UPDATE_DOWNLOAD_SIZES(p_card_program_id in NUMBER, p_file_size in NUMBER)
 IS
  l_curr_average_size number;

Line: 55

  SELECT nvl(average_download_size, 0), nvl(download_count, 0)
        INTO l_curr_average_size, l_curr_download_count
        FROM ap_card_programs_all
        WHERE card_program_id = p_card_program_id;

Line: 60

  UPDATE ap_card_programs_all
     SET last_download_date = SYSDATE,
         last_download_size = p_file_size,
         average_download_size = (l_curr_average_size * l_curr_download_count + p_file_size) / (l_curr_download_count + 1),
         download_count = l_curr_download_count + 1
     WHERE card_program_id = p_card_program_id;

Line: 66

END UPDATE_DOWNLOAD_SIZES;