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 58: FROM ap_card_programs_all

54: BEGIN
55: BEGIN
56: SELECT nvl(average_download_size, 0), nvl(download_count, 0)
57: INTO l_curr_average_size, l_curr_download_count
58: FROM ap_card_programs_all
59: WHERE card_program_id = p_card_program_id;
60: EXCEPTION
61: WHEN No_Data_Found THEN
62: RETURN;

Line 64: UPDATE ap_card_programs_all

60: EXCEPTION
61: WHEN No_Data_Found THEN
62: RETURN;
63: END;
64: UPDATE ap_card_programs_all
65: SET last_download_date = SYSDATE,
66: last_download_size = p_file_size,
67: average_download_size = (l_curr_average_size * l_curr_download_count + p_file_size) / (l_curr_download_count + 1),
68: download_count = l_curr_download_count + 1