eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_IREC_PAYMENTS dependencies on AR_CASH_RECEIPTS

Line 3109: l_receipt_method_id AR_CASH_RECEIPTS_ALL.RECEIPT_METHOD_ID%TYPE;

3105: p_status OUT NOCOPY VARCHAR2,
3106: x_msg_count OUT NOCOPY NUMBER,
3107: x_msg_data OUT NOCOPY VARCHAR2) IS
3108:
3109: l_receipt_method_id AR_CASH_RECEIPTS_ALL.RECEIPT_METHOD_ID%TYPE;
3110: l_receipt_creation_status VARCHAR2(80);
3111: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE;
3112: x_return_status VARCHAR2(100);
3113:

Line 3111: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE;

3107: x_msg_data OUT NOCOPY VARCHAR2) IS
3108:
3109: l_receipt_method_id AR_CASH_RECEIPTS_ALL.RECEIPT_METHOD_ID%TYPE;
3110: l_receipt_creation_status VARCHAR2(80);
3111: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE;
3112: x_return_status VARCHAR2(100);
3113:
3114: l_procedure_name VARCHAR2(30);
3115: l_debug_info VARCHAR2(200);

Line 3867: l_receipt_currency_code AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE;

3863: ) IS
3864: -- =================================
3865: -- DECLARE ALL LOCAL VARIABLES HERE
3866: -- =================================
3867: l_receipt_currency_code AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE;
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:

Line 3868: l_receipt_exchange_rate AR_CASH_RECEIPTS_ALL.EXCHANGE_RATE%TYPE;

3864: -- =================================
3865: -- DECLARE ALL LOCAL VARIABLES HERE
3866: -- =================================
3867: l_receipt_currency_code AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE;
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;

Line 3869: l_receipt_exchange_rate_type AR_CASH_RECEIPTS_ALL.EXCHANGE_RATE_TYPE%TYPE;

3865: -- DECLARE ALL LOCAL VARIABLES HERE
3866: -- =================================
3867: l_receipt_currency_code AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE;
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;

Line 3873: l_receipt_method_id AR_CASH_RECEIPTS_ALL.RECEIPT_METHOD_ID%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;

Line 3874: l_remit_bank_account_id AR_CASH_RECEIPTS_ALL.REMIT_BANK_ACCT_USE_ID%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;

Line 3882: l_cr_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE;

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);
3886:

Line 4619: FROM ar_cash_receipts cr,

4615: cr.amount,
4616: cr.currency_code,
4617: rc.creation_status,
4618: cr.org_id,cr.payment_trxn_extension_id
4619: FROM ar_cash_receipts cr,
4620: ar_receipt_methods rm,
4621: ar_receipt_classes rc
4622: WHERE cr.cash_receipt_id = p_cash_receipt_id
4623: AND cr.receipt_method_id = rm.receipt_method_id

Line 4629: l_cr_rec ar_cash_receipts%ROWTYPE;

4625:
4626:
4627: rct_info rct_info_cur%ROWTYPE;
4628:
4629: l_cr_rec ar_cash_receipts%ROWTYPE;
4630:
4631:
4632:
4633: l_auth_rec IBY_FNDCPT_TRXN_PUB.AuthAttribs_rec_type;