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_WRITEOFF dependencies on AR_RECEIVABLE_APPLICATIONS

Line 248: p_comments IN ar_receivable_applications.comments%type

244: p_receipt_number IN ar_cash_receipts.receipt_number%type,
245: p_receivable_trx_id IN VARCHAR2,
246: p_apply_date IN VARCHAR2,
247: p_gl_date IN VARCHAR2,
248: p_comments IN ar_receivable_applications.comments%type
249: ) IS
250:
251: --Declare Local Variables
252: l_msg_count NUMBER;

Line 256: l_unapp_amount ar_receivable_applications.amount_applied%type;

252: l_msg_count NUMBER;
253: l_msg_data VARCHAR2(240);
254: l_return_status VARCHAR2(1);
255:
256: l_unapp_amount ar_receivable_applications.amount_applied%type;
257: l_unapp_amount_percent NUMBER;
258: l_receipt_date_from ar_cash_receipts.receipt_date%type;
259: l_receipt_date_to ar_cash_receipts.receipt_date%type;
260: l_receipt_gl_date_from ar_receivable_applications.gl_date%type;

Line 260: l_receipt_gl_date_from ar_receivable_applications.gl_date%type;

256: l_unapp_amount ar_receivable_applications.amount_applied%type;
257: l_unapp_amount_percent NUMBER;
258: l_receipt_date_from ar_cash_receipts.receipt_date%type;
259: l_receipt_date_to ar_cash_receipts.receipt_date%type;
260: l_receipt_gl_date_from ar_receivable_applications.gl_date%type;
261: l_receipt_gl_date_to ar_receivable_applications.gl_date%type;
262: l_receipt_method_id ar_cash_receipts.receipt_method_id%type;
263:
264: -- Bug 1981698 Changed the definition for l_customer_number.

Line 261: l_receipt_gl_date_to ar_receivable_applications.gl_date%type;

257: l_unapp_amount_percent NUMBER;
258: l_receipt_date_from ar_cash_receipts.receipt_date%type;
259: l_receipt_date_to ar_cash_receipts.receipt_date%type;
260: l_receipt_gl_date_from ar_receivable_applications.gl_date%type;
261: l_receipt_gl_date_to ar_receivable_applications.gl_date%type;
262: l_receipt_method_id ar_cash_receipts.receipt_method_id%type;
263:
264: -- Bug 1981698 Changed the definition for l_customer_number.
265:

Line 268: l_receivable_trx_id ar_receivable_applications.receivables_trx_id%type;

264: -- Bug 1981698 Changed the definition for l_customer_number.
265:
266: l_customer_number hz_cust_accounts.account_number%type;
267: l_customer_id hz_cust_accounts.cust_account_id%type;
268: l_receivable_trx_id ar_receivable_applications.receivables_trx_id%type;
269: l_apply_date ar_cash_receipts.receipt_date%type;
270: l_gl_date ar_cash_receipts.receipt_date%type;
271: l_receipt_currency_code ar_cash_receipts.currency_code%type;
272: l_receipt_number ar_cash_receipts.receipt_number%type;

Line 273: l_comments ar_receivable_applications.comments%type;

269: l_apply_date ar_cash_receipts.receipt_date%type;
270: l_gl_date ar_cash_receipts.receipt_date%type;
271: l_receipt_currency_code ar_cash_receipts.currency_code%type;
272: l_receipt_number ar_cash_receipts.receipt_number%type;
273: l_comments ar_receivable_applications.comments%type;
274: l_user_id NUMBER;
275: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
276: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
277: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;

Line 275: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;

271: l_receipt_currency_code ar_cash_receipts.currency_code%type;
272: l_receipt_number ar_cash_receipts.receipt_number%type;
273: l_comments ar_receivable_applications.comments%type;
274: l_user_id NUMBER;
275: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
276: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
277: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
278: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
279: l_receivable_application_id NUMBER;

Line 276: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;

272: l_receipt_number ar_cash_receipts.receipt_number%type;
273: l_comments ar_receivable_applications.comments%type;
274: l_user_id NUMBER;
275: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
276: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
277: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
278: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
279: l_receivable_application_id NUMBER;
280:

Line 277: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;

273: l_comments ar_receivable_applications.comments%type;
274: l_user_id NUMBER;
275: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
276: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
277: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
278: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
279: l_receivable_application_id NUMBER;
280:
281: l_unapp_amount_balance NUMBER := 0;

Line 278: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;

274: l_user_id NUMBER;
275: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
276: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
277: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
278: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
279: l_receivable_application_id NUMBER;
280:
281: l_unapp_amount_balance NUMBER := 0;
282: l_written_off_amount ar_receivable_applications.amount_applied%TYPE;

Line 282: l_written_off_amount ar_receivable_applications.amount_applied%TYPE;

278: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
279: l_receivable_application_id NUMBER;
280:
281: l_unapp_amount_balance NUMBER := 0;
282: l_written_off_amount ar_receivable_applications.amount_applied%TYPE;
283: l_tot_write_off_amount ar_receivable_applications.amount_applied%TYPE;
284: l_min_wrt_off_amount ar_receivable_applications.amount_applied%TYPE;
285: l_max_wrt_off_amount ar_receivable_applications.amount_applied%TYPE;
286: l_tot_writeoff_amt_func ar_receivable_applications.amount_applied%TYPE;

Line 283: l_tot_write_off_amount ar_receivable_applications.amount_applied%TYPE;

279: l_receivable_application_id NUMBER;
280:
281: l_unapp_amount_balance NUMBER := 0;
282: l_written_off_amount ar_receivable_applications.amount_applied%TYPE;
283: l_tot_write_off_amount ar_receivable_applications.amount_applied%TYPE;
284: l_min_wrt_off_amount ar_receivable_applications.amount_applied%TYPE;
285: l_max_wrt_off_amount ar_receivable_applications.amount_applied%TYPE;
286: l_tot_writeoff_amt_func ar_receivable_applications.amount_applied%TYPE;
287: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;

Line 284: l_min_wrt_off_amount ar_receivable_applications.amount_applied%TYPE;

280:
281: l_unapp_amount_balance NUMBER := 0;
282: l_written_off_amount ar_receivable_applications.amount_applied%TYPE;
283: l_tot_write_off_amount ar_receivable_applications.amount_applied%TYPE;
284: l_min_wrt_off_amount ar_receivable_applications.amount_applied%TYPE;
285: l_max_wrt_off_amount ar_receivable_applications.amount_applied%TYPE;
286: l_tot_writeoff_amt_func ar_receivable_applications.amount_applied%TYPE;
287: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
288: l_actual_writeoff_amount NUMBER := 0;

Line 285: l_max_wrt_off_amount ar_receivable_applications.amount_applied%TYPE;

281: l_unapp_amount_balance NUMBER := 0;
282: l_written_off_amount ar_receivable_applications.amount_applied%TYPE;
283: l_tot_write_off_amount ar_receivable_applications.amount_applied%TYPE;
284: l_min_wrt_off_amount ar_receivable_applications.amount_applied%TYPE;
285: l_max_wrt_off_amount ar_receivable_applications.amount_applied%TYPE;
286: l_tot_writeoff_amt_func ar_receivable_applications.amount_applied%TYPE;
287: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
288: l_actual_writeoff_amount NUMBER := 0;
289: l_rcpt_percent_amount NUMBER;

Line 286: l_tot_writeoff_amt_func ar_receivable_applications.amount_applied%TYPE;

282: l_written_off_amount ar_receivable_applications.amount_applied%TYPE;
283: l_tot_write_off_amount ar_receivable_applications.amount_applied%TYPE;
284: l_min_wrt_off_amount ar_receivable_applications.amount_applied%TYPE;
285: l_max_wrt_off_amount ar_receivable_applications.amount_applied%TYPE;
286: l_tot_writeoff_amt_func ar_receivable_applications.amount_applied%TYPE;
287: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
288: l_actual_writeoff_amount NUMBER := 0;
289: l_rcpt_percent_amount NUMBER;
290:

Line 306: c_receipt_gl_date_from ar_receivable_applications.gl_date%type,

302: --Declare Cursor
303: CURSOR writeoff_cur(c_receipt_currency_code ar_cash_receipts.currency_code%type,
304: c_receipt_date_from ar_cash_receipts.receipt_date%type,
305: c_receipt_date_to ar_cash_receipts.receipt_date%type,
306: c_receipt_gl_date_from ar_receivable_applications.gl_date%type,
307: c_receipt_gl_date_to ar_receivable_applications.gl_date%type,
308: c_receipt_method_id ar_cash_receipts.receipt_method_id%type,
309: --Bug 1981698 Changed c_customer_number to c_customer_id.
310: c_customer_id ar_cash_receipts.pay_from_customer%type,

Line 307: c_receipt_gl_date_to ar_receivable_applications.gl_date%type,

303: CURSOR writeoff_cur(c_receipt_currency_code ar_cash_receipts.currency_code%type,
304: c_receipt_date_from ar_cash_receipts.receipt_date%type,
305: c_receipt_date_to ar_cash_receipts.receipt_date%type,
306: c_receipt_gl_date_from ar_receivable_applications.gl_date%type,
307: c_receipt_gl_date_to ar_receivable_applications.gl_date%type,
308: c_receipt_method_id ar_cash_receipts.receipt_method_id%type,
309: --Bug 1981698 Changed c_customer_number to c_customer_id.
310: c_customer_id ar_cash_receipts.pay_from_customer%type,
311: c_receipt_number ar_cash_receipts.receipt_number%type,

Line 314: c_user_id ar_receivable_applications.created_by%Type

310: c_customer_id ar_cash_receipts.pay_from_customer%type,
311: c_receipt_number ar_cash_receipts.receipt_number%type,
312: c_apply_date ar_cash_receipts.receipt_date%type,
313: c_gl_date ar_cash_receipts.receipt_date%type,
314: c_user_id ar_receivable_applications.created_by%Type
315: ) IS
316:
317: /*5444407*/
318: SELECT acr.cash_receipt_id cash_receipt_id,

Line 330: ar_receivable_applications app

326: crh.batch_id batch_id
327: FROM ar_payment_schedules ps,
328: ar_cash_receipts acr,
329: ar_cash_receipt_history crh,
330: ar_receivable_applications app
331: WHERE ps.invoice_currency_code = c_receipt_currency_code
332: AND acr.cash_receipt_id = ps.cash_receipt_id
333: AND acr.cash_receipt_id = crh.cash_receipt_id
334: AND crh.current_record_flag = 'Y'

Line 687: l_written_off_amount ar_receivable_applications.amount_applied%TYPE;

683: p_amount_to IN NUMBER default null)
684: RETURN number IS
685:
686: l_unapp_amount_balance NUMBER := 0;
687: l_written_off_amount ar_receivable_applications.amount_applied%TYPE;
688: l_tot_write_off_amount ar_receivable_applications.amount_applied%TYPE;
689: l_max_wrt_off_amount ar_receivable_applications.amount_applied%TYPE;
690: l_tot_writeoff_amt_func ar_receivable_applications.amount_applied%TYPE;
691: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;

Line 688: l_tot_write_off_amount ar_receivable_applications.amount_applied%TYPE;

684: RETURN number IS
685:
686: l_unapp_amount_balance NUMBER := 0;
687: l_written_off_amount ar_receivable_applications.amount_applied%TYPE;
688: l_tot_write_off_amount ar_receivable_applications.amount_applied%TYPE;
689: l_max_wrt_off_amount ar_receivable_applications.amount_applied%TYPE;
690: l_tot_writeoff_amt_func ar_receivable_applications.amount_applied%TYPE;
691: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
692:

Line 689: l_max_wrt_off_amount ar_receivable_applications.amount_applied%TYPE;

685:
686: l_unapp_amount_balance NUMBER := 0;
687: l_written_off_amount ar_receivable_applications.amount_applied%TYPE;
688: l_tot_write_off_amount ar_receivable_applications.amount_applied%TYPE;
689: l_max_wrt_off_amount ar_receivable_applications.amount_applied%TYPE;
690: l_tot_writeoff_amt_func ar_receivable_applications.amount_applied%TYPE;
691: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
692:
693: l_amount_to NUMBER;

Line 690: l_tot_writeoff_amt_func ar_receivable_applications.amount_applied%TYPE;

686: l_unapp_amount_balance NUMBER := 0;
687: l_written_off_amount ar_receivable_applications.amount_applied%TYPE;
688: l_tot_write_off_amount ar_receivable_applications.amount_applied%TYPE;
689: l_max_wrt_off_amount ar_receivable_applications.amount_applied%TYPE;
690: l_tot_writeoff_amt_func ar_receivable_applications.amount_applied%TYPE;
691: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
692:
693: l_amount_to NUMBER;
694: l_amount_from NUMBER;

Line 707: FROM ar_receivable_applications ra

703: SELECT SUM(DECODE(ra.status,'UNAPP',NVL(ra.amount_applied, 0),0)) unapplied_amount,
704: SUM(decode(ra.status,'ACTIVITY',decode(ra.applied_payment_schedule_id,-3,
705: decode(ra.created_by,p_user_id,NVL(ra.amount_applied,0),0),0),0)) written_off_amount
706: INTO l_unapp_amount_balance,l_written_off_amount
707: FROM ar_receivable_applications ra
708: WHERE ra.cash_receipt_id = p_cash_receipt_id
709: AND ra.status in ('UNAPP','ACTIVITY');
710:
711: --Check how much amount has been written-off by this user for this receipt

Line 716: FROM ar_receivable_applications ra

712: /* Bug 2479793 : The index on applied_payment_schedule_id is supressed as
713: CBO sometimes find this better than index on cash_receipt_id */
714: /*SELECT NVL(SUM(NVL(ra.amount_applied, 0)),0) written_off_amount
715: INTO l_written_off_amount
716: FROM ar_receivable_applications ra
717: WHERE ra.cash_receipt_id = p_cash_receipt_id
718: AND ra.status = 'ACTIVITY'
719: AND ra.applied_payment_schedule_id + 0 = -3
720: AND ra.created_by = p_user_id;*/

Line 793: FROM ar_receivable_applications ra

789:
790: ELSE
791: SELECT NVL(SUM(NVL(ra.amount_applied,0)),10) l_unapplied_amount
792: INTO l_unapp_amount_balance
793: FROM ar_receivable_applications ra
794: WHERE ra.cash_receipt_id = p_cash_receipt_id
795: AND status = 'ACTIVITY'
796: AND ra.request_id = p_request_id;
797:

Line 864: ar_receivable_applications ra

860: ,0)) applied_amount
861:
862: INTO l_applied_amount
863: FROM
864: ar_receivable_applications ra
865: WHERE ra.cash_receipt_id = p_cash_receipt_id
866: AND ra.request_id <> p_request_id;
867: ELSE
868: --Sum of the all the applied amounts for a receipt

Line 883: ar_receivable_applications ra

879: ,0)) applied_amount
880:
881: INTO l_applied_amount
882: FROM
883: ar_receivable_applications ra
884: WHERE ra.cash_receipt_id = p_cash_receipt_id;
885: END IF;
886:
887: arp_util.debug('arp_process_writeoff.applied_amount()-');

Line 935: ar_receivable_applications ra

931: SUM(DECODE(ra.status,'ACC', NVL(ra.amount_applied, 0),
932: 0)) on_account_amount
933: INTO l_on_account_amount
934: FROM
935: ar_receivable_applications ra
936: WHERE ra.cash_receipt_id = p_cash_receipt_id;
937:
938: arp_util.debug('arp_process_writeoff.on_account_amount()-');
939: