[Home] [Help]
668: ba_profile_pmt_method_info ba_profile_pmt_method_info_cur%ROWTYPE;
669:
670: l_customer_id RA_CUST_RECEIPT_METHODS.CUSTOMER_ID%TYPE;
671: l_site_use_id RA_CUST_RECEIPT_METHODS.SITE_USE_ID%TYPE;
672: l_currency_code AR_PAYMENT_SCHEDULES_ALL.INVOICE_CURRENCY_CODE%TYPE;
673:
674: l_procedure_name VARCHAR2(30);
675: l_debug_info VARCHAR2(200);
676:
3868: l_receipt_exchange_rate AR_CASH_RECEIPTS_ALL.EXCHANGE_RATE%TYPE;
3869: l_receipt_exchange_rate_type AR_CASH_RECEIPTS_ALL.EXCHANGE_RATE_TYPE%TYPE;
3870: l_receipt_exchange_rate_date DATE;
3871:
3872: l_invoice_exchange_rate AR_PAYMENT_SCHEDULES_ALL.EXCHANGE_RATE%TYPE;
3873: l_receipt_method_id AR_CASH_RECEIPTS_ALL.RECEIPT_METHOD_ID%TYPE;
3874: l_remit_bank_account_id AR_CASH_RECEIPTS_ALL.REMIT_BANK_ACCT_USE_ID%TYPE;
3875: l_receipt_creation_status VARCHAR2(80);
3876: l_site_use_id NUMBER(15);
3877: l_bank_account_id NUMBER;
3878: l_bank_account_uses_id NUMBER;
3879: l_cvv2 iby_fndcpt_tx_extensions.instrument_security_code%TYPE;
3880:
3881: l_invoice_trx_number AR_PAYMENT_SCHEDULES_ALL.TRX_NUMBER%TYPE;
3882: l_cr_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE;
3883: x_return_status VARCHAR2(100);
3884: l_msg_count NUMBER;
3885: l_msg_data VARCHAR2(4000);