APPS.AP_WEB_UTIL_PKG dependencies on AP_CARD_PROGRAMS_ALL

Line 48: * Updates the download columns in AP_CARD_PROGRAMS_ALL

44: END GET_PROXY;
45:
46:
47: /*
48: * Updates the download columns in AP_CARD_PROGRAMS_ALL
49: */
50: PROCEDURE UPDATE_DOWNLOAD_SIZES(p_card_program_id in NUMBER, p_file_size in NUMBER)
51: IS
52: l_curr_average_size number;

Line 57: FROM ap_card_programs_all

53: l_curr_download_count number;
54: BEGIN
55: SELECT nvl(average_download_size, 0), nvl(download_count, 0)
56: INTO l_curr_average_size, l_curr_download_count
57: FROM ap_card_programs_all
58: WHERE card_program_id = p_card_program_id;
59:
60: UPDATE ap_card_programs_all
61: SET last_download_date = SYSDATE,

Line 60: UPDATE ap_card_programs_all

56: INTO l_curr_average_size, l_curr_download_count
57: FROM ap_card_programs_all
58: WHERE card_program_id = p_card_program_id;
59:
60: UPDATE ap_card_programs_all
61: SET last_download_date = SYSDATE,
62: last_download_size = p_file_size,
63: average_download_size = (l_curr_average_size * l_curr_download_count + p_file_size) / (l_curr_download_count + 1),
64: download_count = l_curr_download_count + 1