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_PAYMENT_SCHEDULES

Line 670: FROM ar_payment_schedules

666: AND TRUNC(p_trx_date) BETWEEN TRUNC(arma.start_date) AND TRUNC(nvl(arma.end_date, p_trx_date));
667:
668: CURSOR payment_schedule_info_cur IS
669: SELECT customer_site_use_id, invoice_currency_code, exchange_rate,trx_number
670: FROM ar_payment_schedules
671: WHERE payment_schedule_id = p_payment_schedule_id;
672:
673: payment_method_info payment_method_info_cur%ROWTYPE;
674: payment_schedule_info payment_schedule_info_cur%ROWTYPE;

Line 681: l_currency_code AR_PAYMENT_SCHEDULES_ALL.INVOICE_CURRENCY_CODE%TYPE;

677: ba_profile_pmt_method_info ba_profile_pmt_method_info_cur%ROWTYPE;
678:
679: l_customer_id RA_CUST_RECEIPT_METHODS.CUSTOMER_ID%TYPE;
680: l_site_use_id RA_CUST_RECEIPT_METHODS.SITE_USE_ID%TYPE;
681: l_currency_code AR_PAYMENT_SCHEDULES_ALL.INVOICE_CURRENCY_CODE%TYPE;
682:
683: l_procedure_name VARCHAR2(30);
684: l_debug_info VARCHAR2(200);
685:

Line 1124: l_currency_code ar_payment_schedules.invoice_currency_code%type;

1120:
1121: l_ps_balance NUMBER;
1122: l_bank_account_method NUMBER;
1123: l_credit_card_method NUMBER; /* J Rautiainen ACH Implementation */
1124: l_currency_code ar_payment_schedules.invoice_currency_code%type;
1125: l_class ar_payment_schedules.class%TYPE;
1126: l_creation_status ar_receipt_classes.creation_status%TYPE;
1127:
1128: BEGIN

Line 1125: l_class ar_payment_schedules.class%TYPE;

1121: l_ps_balance NUMBER;
1122: l_bank_account_method NUMBER;
1123: l_credit_card_method NUMBER; /* J Rautiainen ACH Implementation */
1124: l_currency_code ar_payment_schedules.invoice_currency_code%type;
1125: l_class ar_payment_schedules.class%TYPE;
1126: l_creation_status ar_receipt_classes.creation_status%TYPE;
1127:
1128: BEGIN
1129:

Line 1140: FROM ar_payment_schedules

1136: -- check trx type and balance: trx type must be debit item, balance > 0
1137:
1138: SELECT amount_due_remaining, class, invoice_currency_code
1139: INTO l_ps_balance, l_class, l_currency_code
1140: FROM ar_payment_schedules
1141: WHERE payment_schedule_id = p_payment_schedule_id;
1142: --Bug 4161986 - Pay Icon does not appear in the ChargeBack and its activities page. Added the class CB(Chargeback)
1143: IF l_ps_balance <= 0
1144: OR l_class NOT IN ('INV', 'DEP', 'GUAR', 'DM', 'CB') THEN

Line 2326: FROM AR_PAYMENT_SCHEDULES ps,

2322: ps.org_id,
2323: ct.PAYING_CUSTOMER_ID,
2324: ct.PAYING_SITE_USE_ID,
2325: ( decode( nvl(ps.AMOUNT_DUE_ORIGINAL,0),0,1,(ps.AMOUNT_DUE_ORIGINAL/abs(ps.AMOUNT_DUE_ORIGINAL)) ) *abs(nvl(ps.amount_in_dispute,0)) ) dispute_amt
2326: FROM AR_PAYMENT_SCHEDULES ps,
2327: RA_CUSTOMER_TRX ct,
2328: HZ_CUST_ACCOUNTS acct,
2329: RA_TERMS trm
2330: WHERE ps.CLASS IN ('INV', 'DM', 'CB', 'DEP')

Line 2517: | AR_PAYMENT_SCHEDULES to the Payment List GT

Line 2620: FROM AR_PAYMENT_SCHEDULES ps,

2616: ps.org_id,
2617: 0 PAYING_CUSTOMER_ID,
2618: 0 PAYING_SITE_USE_ID,
2619: 0 dispute_amt
2620: FROM AR_PAYMENT_SCHEDULES ps,
2621: RA_CUSTOMER_TRX_ALL ct,
2622: HZ_CUST_ACCOUNTS acct,
2623: RA_TERMS trm
2624: WHERE ps.customer_id = p_customer_id

Line 4392: l_invoice_exchange_rate AR_PAYMENT_SCHEDULES_ALL.EXCHANGE_RATE%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;
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);

Line 4402: l_invoice_trx_number AR_PAYMENT_SCHEDULES_ALL.TRX_NUMBER%TYPE;

4398: l_bank_account_id NUMBER;
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);

Line 5612: from ar_payment_schedules ps, ra_customer_trx_all ct

5608:
5609: select class, amount_due_remaining, cash_receipt_id, ps.CUSTOMER_ID, ct.PAYING_CUSTOMER_ID, ps.CUSTOMER_SITE_USE_ID,ct.PAYING_SITE_USE_ID, ps.customer_trx_id,
5610: (decode( nvl(AMOUNT_DUE_ORIGINAL,0),0,1,(AMOUNT_DUE_ORIGINAL/abs(AMOUNT_DUE_ORIGINAL)) ) *abs(nvl(amount_in_dispute,0)) )
5611: into l_trx_class, l_amount_due_remaining, l_cash_receipt_id, l_pay_for_cust_id, l_paying_cust_id, l_pay_for_cust_site_id, l_paying_cust_site_id, l_customer_trx_id, l_dispute_amount
5612: from ar_payment_schedules ps, ra_customer_trx_all ct
5613: where ps.CUSTOMER_TRX_ID = ct.CUSTOMER_TRX_ID(+)
5614: and ps.payment_schedule_id = p_payment_schedule_id;
5615:
5616: --Bug 4479224

Line 5814: FROM AR_PAYMENT_SCHEDULES ps,

5810: l_pay_for_cust_id,
5811: --Bug 4062938 - Handling of transactions with no site id
5812: decode(ps.customer_site_use_id, null, -1,ps.customer_site_use_id) as CUSTOMER_SITE_USE_ID,
5813: (decode( nvl(ps.AMOUNT_DUE_ORIGINAL,0),0,1,(ps.AMOUNT_DUE_ORIGINAL/abs(ps.AMOUNT_DUE_ORIGINAL)) ) *abs(nvl(ps.amount_in_dispute,0)) )
5814: FROM AR_PAYMENT_SCHEDULES ps,
5815: RA_CUSTOMER_TRX_ALL ct,
5816: HZ_CUST_ACCOUNTS acct,
5817: RA_TERMS trm
5818: WHERE ps.payment_schedule_id = p_payment_schedule_id

Line 6302: FUNCTION get_discount_wrapper ( p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

6298: | MODIFICATION HISTORY
6299: | Date Author Description of Changes
6300: | 19-JUL-2004 vnb Created
6301: +============================================================*/
6302: FUNCTION get_discount_wrapper ( p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
6303: p_in_applied_amount IN NUMBER) RETURN NUMBER IS
6304: l_discount_amount NUMBER;
6305: l_customer_id NUMBER;
6306: l_customer_site_use_id NUMBER;

Line 6313: FROM ar_payment_schedules

6309: l_grace_days_flag VARCHAR2(2);
6310: BEGIN
6311: SELECT CUSTOMER_ID, CUSTOMER_SITE_USE_ID
6312: INTO l_customer_id, l_customer_site_use_id
6313: FROM ar_payment_schedules
6314: WHERE PAYMENT_SCHEDULE_ID = p_ps_id;
6315:
6316: -- Check if grace days have to be considered for discount.
6317: --l_grace_days_flag := is_grace_days_enabled_wrapper();

Line 6661: | This procedure will update the PAYMENT_APPROVAL column in ar_payment_schedules

6657: /*=====================================================================
6658: | PROCEDURE update_invoice_payment_status
6659: |
6660: | DESCRIPTION
6661: | This procedure will update the PAYMENT_APPROVAL column in ar_payment_schedules
6662: | with the value p_inv_pay_status for the records in p_payment_schedule_id_list
6663: |
6664: | PARAMETERS
6665: | p_payment_schedule_id_list IN Inv_list_table_type

Line 6692: UPDATE AR_PAYMENT_SCHEDULES set PAYMENT_APPROVAL = p_inv_pay_status,

6688: l_last_updated_by := FND_GLOBAL.USER_ID;
6689:
6690: FORALL trx
6691: IN p_payment_schedule_id_list.first .. p_payment_schedule_id_list.last
6692: UPDATE AR_PAYMENT_SCHEDULES set PAYMENT_APPROVAL = p_inv_pay_status,
6693: LAST_UPDATE_DATE = l_last_update_date, LAST_UPDATED_BY = l_last_updated_by,
6694: LAST_UPDATE_LOGIN = l_last_update_login
6695: where payment_schedule_id = p_payment_schedule_id_list(trx);
6696:

Line 6864: FUNCTION get_future_discount_wrapper ( p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

6860: | MODIFICATION HISTORY
6861: | Date Author Description of Changes
6862: | 06-MAY-2011 rsinthre Created for bug 10106518
6863: +============================================================*/
6864: FUNCTION get_future_discount_wrapper ( p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
6865: p_in_applied_amount IN NUMBER,
6866: p_discount_date IN DATE DEFAULT NULL) RETURN NUMBER IS
6867: l_discount_amount NUMBER;
6868: l_rem_amt_rcpt NUMBER;