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 143: l_currency_code ar_cash_receipts.currency_code%TYPE;

139: p_applied_rec_app_id IN ar_receivable_applications.applied_rec_app_id%TYPE,
140: x_claim_reason_name OUT NOCOPY VARCHAR2) IS
141:
142: l_rec_ra_rec ar_receivable_applications%ROWTYPE;
143: l_currency_code ar_cash_receipts.currency_code%TYPE;
144: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
145: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
146: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
147: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;

Line 144: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;

140: x_claim_reason_name OUT NOCOPY VARCHAR2) IS
141:
142: l_rec_ra_rec ar_receivable_applications%ROWTYPE;
143: l_currency_code ar_cash_receipts.currency_code%TYPE;
144: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
145: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
146: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
147: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
148: l_bill_to_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;

Line 145: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;

141:
142: l_rec_ra_rec ar_receivable_applications%ROWTYPE;
143: l_currency_code ar_cash_receipts.currency_code%TYPE;
144: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
145: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
146: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
147: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
148: l_bill_to_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
149: l_ship_to_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;

Line 146: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;

142: l_rec_ra_rec ar_receivable_applications%ROWTYPE;
143: l_currency_code ar_cash_receipts.currency_code%TYPE;
144: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
145: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
146: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
147: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
148: l_bill_to_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
149: l_ship_to_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
150: l_receipt_number ar_cash_receipts.receipt_number%TYPE;

Line 147: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;

143: l_currency_code ar_cash_receipts.currency_code%TYPE;
144: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
145: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
146: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
147: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
148: l_bill_to_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
149: l_ship_to_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
150: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
151: l_amount_due_remaining NUMBER;

Line 148: l_bill_to_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;

144: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
145: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
146: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
147: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
148: l_bill_to_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
149: l_ship_to_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
150: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
151: l_amount_due_remaining NUMBER;
152: l_claim_amount NUMBER;

Line 149: l_ship_to_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;

145: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
146: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
147: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
148: l_bill_to_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
149: l_ship_to_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
150: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
151: l_amount_due_remaining NUMBER;
152: l_claim_amount NUMBER;
153: l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE;

Line 150: l_receipt_number ar_cash_receipts.receipt_number%TYPE;

146: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
147: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
148: l_bill_to_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
149: l_ship_to_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
150: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
151: l_amount_due_remaining NUMBER;
152: l_claim_amount NUMBER;
153: l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE;
154: l_trx_number ra_customer_trx.trx_number%TYPE;

Line 159: l_legal_entity_id ar_cash_receipts.legal_entity_id%TYPE;

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

Line 287: , ar_cash_receipts cr

283: , l_ship_to_site_use_id
284: , l_receipt_number
285: , l_legal_entity_id
286: FROM ar_payment_schedules ps
287: , ar_cash_receipts cr
288: , ar_cash_receipt_history crh
289: , ar_receipt_methods rm
290: , ce_bank_acct_uses ba
291: , ar_receipt_method_accounts rma

Line 342: FROM ar_cash_receipts cr,

338:
339: SELECT cr.cash_receipt_id, cr.receipt_number
340: INTO l_rec_ra_rec.cash_receipt_id
341: , l_receipt_number
342: FROM ar_cash_receipts cr,
343: ar_payment_schedules ps
344: WHERE ps.payment_schedule_id = p_receipt_ps_id
345: AND cr.cash_receipt_id = ps.cash_receipt_id;
346: END IF;