DBA Data[Home] [Help]

APPS.AR_IREC_PAYMENTS dependencies on AR_CASH_RECEIPTS_ALL

Line 3578: l_receipt_method_id AR_CASH_RECEIPTS_ALL.RECEIPT_METHOD_ID%TYPE;

3574: p_status OUT NOCOPY VARCHAR2,
3575: x_msg_count OUT NOCOPY NUMBER,
3576: x_msg_data OUT NOCOPY VARCHAR2) IS
3577:
3578: l_receipt_method_id AR_CASH_RECEIPTS_ALL.RECEIPT_METHOD_ID%TYPE;
3579: l_receipt_creation_status VARCHAR2(80);
3580: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE;
3581: x_return_status VARCHAR2(100);
3582:

Line 3580: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE;

3576: x_msg_data OUT NOCOPY VARCHAR2) IS
3577:
3578: l_receipt_method_id AR_CASH_RECEIPTS_ALL.RECEIPT_METHOD_ID%TYPE;
3579: l_receipt_creation_status VARCHAR2(80);
3580: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE;
3581: x_return_status VARCHAR2(100);
3582:
3583: l_procedure_name VARCHAR2(30);
3584: l_debug_info VARCHAR2(200);

Line 4387: l_receipt_currency_code AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE;

4383: ) IS
4384: -- =================================
4385: -- DECLARE ALL LOCAL VARIABLES HERE
4386: -- =================================
4387: l_receipt_currency_code AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE;
4388: l_receipt_exchange_rate AR_CASH_RECEIPTS_ALL.EXCHANGE_RATE%TYPE;
4389: l_receipt_exchange_rate_type AR_CASH_RECEIPTS_ALL.EXCHANGE_RATE_TYPE%TYPE;
4390: l_receipt_exchange_rate_date DATE;
4391:

Line 4388: l_receipt_exchange_rate AR_CASH_RECEIPTS_ALL.EXCHANGE_RATE%TYPE;

4384: -- =================================
4385: -- DECLARE ALL LOCAL VARIABLES HERE
4386: -- =================================
4387: l_receipt_currency_code AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE;
4388: l_receipt_exchange_rate AR_CASH_RECEIPTS_ALL.EXCHANGE_RATE%TYPE;
4389: l_receipt_exchange_rate_type AR_CASH_RECEIPTS_ALL.EXCHANGE_RATE_TYPE%TYPE;
4390: l_receipt_exchange_rate_date DATE;
4391:
4392: l_invoice_exchange_rate AR_PAYMENT_SCHEDULES_ALL.EXCHANGE_RATE%TYPE;

Line 4389: l_receipt_exchange_rate_type AR_CASH_RECEIPTS_ALL.EXCHANGE_RATE_TYPE%TYPE;

4385: -- DECLARE ALL LOCAL VARIABLES HERE
4386: -- =================================
4387: l_receipt_currency_code AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE;
4388: l_receipt_exchange_rate AR_CASH_RECEIPTS_ALL.EXCHANGE_RATE%TYPE;
4389: l_receipt_exchange_rate_type AR_CASH_RECEIPTS_ALL.EXCHANGE_RATE_TYPE%TYPE;
4390: l_receipt_exchange_rate_date DATE;
4391:
4392: l_invoice_exchange_rate AR_PAYMENT_SCHEDULES_ALL.EXCHANGE_RATE%TYPE;
4393: l_receipt_method_id AR_CASH_RECEIPTS_ALL.RECEIPT_METHOD_ID%TYPE;

Line 4393: l_receipt_method_id AR_CASH_RECEIPTS_ALL.RECEIPT_METHOD_ID%TYPE;

4389: l_receipt_exchange_rate_type AR_CASH_RECEIPTS_ALL.EXCHANGE_RATE_TYPE%TYPE;
4390: l_receipt_exchange_rate_date DATE;
4391:
4392: l_invoice_exchange_rate AR_PAYMENT_SCHEDULES_ALL.EXCHANGE_RATE%TYPE;
4393: l_receipt_method_id AR_CASH_RECEIPTS_ALL.RECEIPT_METHOD_ID%TYPE;
4394: l_remit_bank_account_id AR_CASH_RECEIPTS_ALL.REMIT_BANK_ACCT_USE_ID%TYPE;
4395: l_receipt_creation_status VARCHAR2(80);
4396: l_site_use_id NUMBER(15);
4397: l_site_use_id_pay_instr NUMBER(15); -- Added for Bug#14556872

Line 4394: l_remit_bank_account_id AR_CASH_RECEIPTS_ALL.REMIT_BANK_ACCT_USE_ID%TYPE;

4390: l_receipt_exchange_rate_date DATE;
4391:
4392: l_invoice_exchange_rate AR_PAYMENT_SCHEDULES_ALL.EXCHANGE_RATE%TYPE;
4393: l_receipt_method_id AR_CASH_RECEIPTS_ALL.RECEIPT_METHOD_ID%TYPE;
4394: l_remit_bank_account_id AR_CASH_RECEIPTS_ALL.REMIT_BANK_ACCT_USE_ID%TYPE;
4395: l_receipt_creation_status VARCHAR2(80);
4396: l_site_use_id NUMBER(15);
4397: l_site_use_id_pay_instr NUMBER(15); -- Added for Bug#14556872
4398: l_bank_account_id NUMBER;

Line 4403: l_cr_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE;

4399: l_bank_account_uses_id NUMBER;
4400: l_cvv2 iby_fndcpt_tx_extensions.instrument_security_code%TYPE;
4401:
4402: l_invoice_trx_number AR_PAYMENT_SCHEDULES_ALL.TRX_NUMBER%TYPE;
4403: l_cr_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE;
4404: x_return_status VARCHAR2(100);
4405: l_msg_count NUMBER;
4406: l_msg_data VARCHAR2(4000);
4407: x_auth_result IBY_FNDCPT_TRXN_PUB.AuthResult_rec_type;

Line 4998: from ar_cash_receipts_all cr,

4994: l_call_payment_processor = FND_API.G_TRUE) THEN
4995:
4996: BEGIN
4997: select pr.home_country into l_home_country
4998: from ar_cash_receipts_all cr,
4999: ce_bank_acct_uses bau,
5000: ce_bank_accounts cba,
5001: hz_parties bank,
5002: hz_organization_profiles pr