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: 56

  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: 64

  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: 70

END UPDATE_DOWNLOAD_SIZES;

Line: 119

        select invoice_id,amount,reversal_flag
        from AP_INVOICE_PAYMENTS_ALL
        where check_id = P_CHECK_ID;

Line: 141

    SELECT check_number,
           currency_code,
           check_date,
           payment_profile_id,
           external_bank_account_id       -- bug 2426077
    INTO   l_checkNumber,
           l_paymentCurrency,
           l_paymentDate,
           l_paymentProfileId,
           l_ext_bank_account_id      -- bug 2426077
    FROM   AP_CHECKS_ALL
    WHERE  check_id = P_Check_ID;

Line: 156

      SELECT processing_type
      INTO   l_processing_type
      FROM   IBY_PAYMENT_PROFILES
      WHERE  payment_profile_id = l_paymentProfileId
      AND    rownum = 1;

Line: 166

      SELECT bank_account_number,
             bank_name||','||bank_branch_name
      INTO   l_account,
             l_bankName
      FROM   IBY_EXT_BANK_ACCOUNTS_V
      WHERE  ext_bank_account_id = l_ext_bank_account_id
      AND    rownum = 1;

Line: 198

        SELECT 1, source
        INTO l_flag, l_source
        FROM ap_invoices_all
        WHERE
	    invoice_id = l_invoiceId
	    AND SOURCE IN ( 'SelfService', 'Both Pay', 'CREDIT CARD','XpenseXpress');

Line: 213

        AP_WEB_UTILITIES_PKG.UpdateExpenseStatusCode( p_invoice_id => l_invoiceId);

Line: 221

	SELECT nvl(PV.employee_id,AIA.paid_on_behalf_employee_id) INTO l_employee_id FROM PO_VENDORS PV, AP_INVOICES_ALL AIA
	WHERE PV.vendor_id = AIA.vendor_id AND AIA.invoice_id = l_invoiceId;

Line: 228

		select PROFILE_OPTION_VALUE INTO l_notify FROM FND_PROFILE_OPTION_VALUES FPOV, FND_PROFILE_OPTIONS FPO,
			FND_USER FU, FND_USER_RESP_GROUPS FURG WHERE
			fu.employee_id = l_employee_id
			and fu.user_id = furg.user_id
			and fpo.profile_option_name = 'SSE_CC_PAYMENT_NOTIFY'
			and fpov.profile_option_id = fpo.profile_option_id
			and furg.responsibility_id = fpov.level_value
			and fpov.level_value_application_id = 200
			and fpov.application_id = 200
			and sysdate between furg.start_date and nvl(furg.end_date, sysdate)
			and rownum = 1
		order by furg.responsibility_id;

Line: 253

	      SELECT
		      AIA.invoice_type_lookup_code,
		      PV.employee_id,
		      AIA.paid_on_behalf_employee_id,
		      AIA.invoice_num,
		      PV.vendor_name
	      INTO
		      l_invoice_type_lookup_code,
		      l_employeeID,
		      l_paid_on_behalf_employee_id,
		      l_invoiceNumber,
		      l_cardIssuer
	      FROM
	              PO_VENDORS PV,
		      AP_INVOICES_ALL AIA
	      WHERE
		      PV.vendor_id = AIA.vendor_id
                      AND AIA.invoice_id = l_invoiceId;