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.ARP_PROCESS_APPLICATION2 dependencies on AR_CASH_RECEIPTS

Line 147: l_currency_code ar_cash_receipts.currency_code%TYPE;

143: p_on_acct_po_num IN ar_receivable_applications.on_acct_po_num%TYPE DEFAULT NULL
144: ) IS
145:
146: l_rec_ra_rec ar_receivable_applications%ROWTYPE;
147: l_currency_code ar_cash_receipts.currency_code%TYPE;
148: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
149: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
150: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
151: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;

Line 148: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;

144: ) IS
145:
146: l_rec_ra_rec ar_receivable_applications%ROWTYPE;
147: l_currency_code ar_cash_receipts.currency_code%TYPE;
148: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
149: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
150: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
151: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
152: l_bill_to_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;

Line 149: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;

145:
146: l_rec_ra_rec ar_receivable_applications%ROWTYPE;
147: l_currency_code ar_cash_receipts.currency_code%TYPE;
148: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
149: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
150: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
151: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
152: l_bill_to_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
153: l_ship_to_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;

Line 150: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;

146: l_rec_ra_rec ar_receivable_applications%ROWTYPE;
147: l_currency_code ar_cash_receipts.currency_code%TYPE;
148: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
149: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
150: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
151: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
152: l_bill_to_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
153: l_ship_to_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
154: l_receipt_number ar_cash_receipts.receipt_number%TYPE;

Line 151: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;

147: l_currency_code ar_cash_receipts.currency_code%TYPE;
148: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
149: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
150: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
151: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
152: l_bill_to_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
153: l_ship_to_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
154: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
155: l_amount_due_remaining NUMBER;

Line 152: l_bill_to_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;

148: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
149: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
150: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
151: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
152: l_bill_to_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
153: l_ship_to_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
154: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
155: l_amount_due_remaining NUMBER;
156: l_claim_amount NUMBER;

Line 153: l_ship_to_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;

149: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
150: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
151: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
152: l_bill_to_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
153: l_ship_to_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
154: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
155: l_amount_due_remaining NUMBER;
156: l_claim_amount NUMBER;
157: l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE;

Line 154: l_receipt_number ar_cash_receipts.receipt_number%TYPE;

150: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
151: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
152: l_bill_to_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
153: l_ship_to_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
154: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
155: l_amount_due_remaining NUMBER;
156: l_claim_amount NUMBER;
157: l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE;
158: l_trx_number ra_customer_trx.trx_number%TYPE;

Line 163: l_legal_entity_id ar_cash_receipts.legal_entity_id%TYPE;

159: l_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%TYPE;
160: l_salesrep_id ra_customer_trx.primary_salesrep_id%TYPE;
161: --BUG#2750340
162: l_xla_ev_rec arp_xla_events.xla_events_type;
163: l_legal_entity_id ar_cash_receipts.legal_entity_id%TYPE;
164:
165: BEGIN
166: IF PG_DEBUG in ('Y', 'C') THEN
167: arp_standard.debug( 'arp_process_application.update_application()+');

Line 298: , ar_cash_receipts cr

294: , l_ship_to_site_use_id
295: , l_receipt_number
296: , l_legal_entity_id
297: FROM ar_payment_schedules ps
298: , ar_cash_receipts cr
299: , ar_cash_receipt_history crh
300: , ar_receipt_methods rm
301: , ce_bank_acct_uses ba
302: , ar_receipt_method_accounts rma

Line 353: FROM ar_cash_receipts cr,

349:
350: SELECT cr.cash_receipt_id, cr.receipt_number
351: INTO l_rec_ra_rec.cash_receipt_id
352: , l_receipt_number
353: FROM ar_cash_receipts cr,
354: ar_payment_schedules ps
355: WHERE ps.payment_schedule_id = p_receipt_ps_id
356: AND cr.cash_receipt_id = ps.cash_receipt_id;
357: END IF;