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

Line 103: FROM ar_receivable_applications

99: SELECT applied_payment_schedule_id
100: , secondary_application_ref_id
101: INTO l_payment_schedule_id
102: , l_claim_id
103: FROM ar_receivable_applications
104: WHERE applied_customer_trx_id = p_customer_trx_id
105: AND application_ref_num = p_claim_number
106: AND application_ref_type = 'CLAIM'
107: AND display = 'Y'

Line 277: ar_receivable_applications.application_ref_num%TYPE,

273: p_cash_receipt_id IN NUMBER,
274: p_receivables_trx_id IN NUMBER,
275: p_ussgl_transaction_code IN NUMBER,
276: p_application_ref_num IN
277: ar_receivable_applications.application_ref_num%TYPE,
278: p_secondary_application_ref_id IN
279: ar_receivable_applications.secondary_application_ref_id%TYPE,
280: p_customer_reference IN
281: ar_receivable_applications.customer_reference%TYPE,

Line 279: ar_receivable_applications.secondary_application_ref_id%TYPE,

275: p_ussgl_transaction_code IN NUMBER,
276: p_application_ref_num IN
277: ar_receivable_applications.application_ref_num%TYPE,
278: p_secondary_application_ref_id IN
279: ar_receivable_applications.secondary_application_ref_id%TYPE,
280: p_customer_reference IN
281: ar_receivable_applications.customer_reference%TYPE,
282: x_return_status OUT NOCOPY VARCHAR2,
283: x_msg_count OUT NOCOPY NUMBER,

Line 281: ar_receivable_applications.customer_reference%TYPE,

277: ar_receivable_applications.application_ref_num%TYPE,
278: p_secondary_application_ref_id IN
279: ar_receivable_applications.secondary_application_ref_id%TYPE,
280: p_customer_reference IN
281: ar_receivable_applications.customer_reference%TYPE,
282: x_return_status OUT NOCOPY VARCHAR2,
283: x_msg_count OUT NOCOPY NUMBER,
284: x_msg_data OUT NOCOPY VARCHAR2)
285: IS

Line 295: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE := NULL;

291: l_amount NUMBER;
292: l_bal_due_remaining NUMBER;
293: l_receivable_application_id NUMBER;
294: l_application_ref_id NUMBER := NULL;
295: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE := NULL;
296: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE := NULL;
297: l_application_ref_reason ar_receivable_applications.application_ref_reason%TYPE;
298: l_dum_app_ref_type ar_receivable_applications.application_ref_type%TYPE;
299: l_dum_app_ref_id NUMBER;

Line 296: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE := NULL;

292: l_bal_due_remaining NUMBER;
293: l_receivable_application_id NUMBER;
294: l_application_ref_id NUMBER := NULL;
295: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE := NULL;
296: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE := NULL;
297: l_application_ref_reason ar_receivable_applications.application_ref_reason%TYPE;
298: l_dum_app_ref_type ar_receivable_applications.application_ref_type%TYPE;
299: l_dum_app_ref_id NUMBER;
300: l_dum_app_ref_num ar_receivable_applications.application_ref_num%TYPE;

Line 297: l_application_ref_reason ar_receivable_applications.application_ref_reason%TYPE;

293: l_receivable_application_id NUMBER;
294: l_application_ref_id NUMBER := NULL;
295: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE := NULL;
296: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE := NULL;
297: l_application_ref_reason ar_receivable_applications.application_ref_reason%TYPE;
298: l_dum_app_ref_type ar_receivable_applications.application_ref_type%TYPE;
299: l_dum_app_ref_id NUMBER;
300: l_dum_app_ref_num ar_receivable_applications.application_ref_num%TYPE;
301: l_dum_sec_app_ref_id NUMBER;

Line 298: l_dum_app_ref_type ar_receivable_applications.application_ref_type%TYPE;

294: l_application_ref_id NUMBER := NULL;
295: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE := NULL;
296: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE := NULL;
297: l_application_ref_reason ar_receivable_applications.application_ref_reason%TYPE;
298: l_dum_app_ref_type ar_receivable_applications.application_ref_type%TYPE;
299: l_dum_app_ref_id NUMBER;
300: l_dum_app_ref_num ar_receivable_applications.application_ref_num%TYPE;
301: l_dum_sec_app_ref_id NUMBER;
302: l_payment_set_id NUMBER;

Line 300: l_dum_app_ref_num ar_receivable_applications.application_ref_num%TYPE;

296: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE := NULL;
297: l_application_ref_reason ar_receivable_applications.application_ref_reason%TYPE;
298: l_dum_app_ref_type ar_receivable_applications.application_ref_type%TYPE;
299: l_dum_app_ref_id NUMBER;
300: l_dum_app_ref_num ar_receivable_applications.application_ref_num%TYPE;
301: l_dum_sec_app_ref_id NUMBER;
302: l_payment_set_id NUMBER;
303: l_claim_receivables_trx_id NUMBER;
304: l_comments ar_receivable_applications.comments%TYPE;

Line 304: l_comments ar_receivable_applications.comments%TYPE;

300: l_dum_app_ref_num ar_receivable_applications.application_ref_num%TYPE;
301: l_dum_sec_app_ref_id NUMBER;
302: l_payment_set_id NUMBER;
303: l_claim_receivables_trx_id NUMBER;
304: l_comments ar_receivable_applications.comments%TYPE;
305: l_customer_reference ar_receivable_applications.customer_reference%TYPE;
306: l_attribute_rec AR_Receipt_API_PUB.attribute_rec_type;
307: l_global_attribute_rec AR_Receipt_API_PUB.global_attribute_rec_type;
308: l_balance NUMBER := 0;

Line 305: l_customer_reference ar_receivable_applications.customer_reference%TYPE;

301: l_dum_sec_app_ref_id NUMBER;
302: l_payment_set_id NUMBER;
303: l_claim_receivables_trx_id NUMBER;
304: l_comments ar_receivable_applications.comments%TYPE;
305: l_customer_reference ar_receivable_applications.customer_reference%TYPE;
306: l_attribute_rec AR_Receipt_API_PUB.attribute_rec_type;
307: l_global_attribute_rec AR_Receipt_API_PUB.global_attribute_rec_type;
308: l_balance NUMBER := 0;
309: l_receipt_number ar_cash_receipts.receipt_number%TYPE;

Line 323: l_new_claim_num ar_receivable_applications.application_ref_num%TYPE;

319: l_receivables_trx_id NUMBER;
320: l_trans_to_receipt_rate NUMBER;
321: l_discount_earned NUMBER;
322: l_discount_unearned NUMBER;
323: l_new_claim_num ar_receivable_applications.application_ref_num%TYPE;
324: l_return_status VARCHAR2(1);
325: l_api_name CONSTANT VARCHAR2(30)
326: := 'create_receipt_writeoff';
327: l_error_message VARCHAR2(2000);

Line 740: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE := NULL;

736: l_app_gl_date DATE;
737: l_amount NUMBER;
738: l_bal_due_remaining NUMBER;
739: l_application_ref_id NUMBER := NULL;
740: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE := NULL;
741: l_application_ref_reason ar_receivable_applications.application_ref_reason%TYPE;
742: l_dum_app_ref_type ar_receivable_applications.application_ref_type%TYPE;
743: l_dum_app_ref_id NUMBER;
744: l_dum_app_ref_num ar_receivable_applications.application_ref_num%TYPE;

Line 741: l_application_ref_reason ar_receivable_applications.application_ref_reason%TYPE;

737: l_amount NUMBER;
738: l_bal_due_remaining NUMBER;
739: l_application_ref_id NUMBER := NULL;
740: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE := NULL;
741: l_application_ref_reason ar_receivable_applications.application_ref_reason%TYPE;
742: l_dum_app_ref_type ar_receivable_applications.application_ref_type%TYPE;
743: l_dum_app_ref_id NUMBER;
744: l_dum_app_ref_num ar_receivable_applications.application_ref_num%TYPE;
745: l_dum_sec_app_ref_id NUMBER;

Line 742: l_dum_app_ref_type ar_receivable_applications.application_ref_type%TYPE;

738: l_bal_due_remaining NUMBER;
739: l_application_ref_id NUMBER := NULL;
740: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE := NULL;
741: l_application_ref_reason ar_receivable_applications.application_ref_reason%TYPE;
742: l_dum_app_ref_type ar_receivable_applications.application_ref_type%TYPE;
743: l_dum_app_ref_id NUMBER;
744: l_dum_app_ref_num ar_receivable_applications.application_ref_num%TYPE;
745: l_dum_sec_app_ref_id NUMBER;
746: l_payment_set_id NUMBER;

Line 744: l_dum_app_ref_num ar_receivable_applications.application_ref_num%TYPE;

740: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE := NULL;
741: l_application_ref_reason ar_receivable_applications.application_ref_reason%TYPE;
742: l_dum_app_ref_type ar_receivable_applications.application_ref_type%TYPE;
743: l_dum_app_ref_id NUMBER;
744: l_dum_app_ref_num ar_receivable_applications.application_ref_num%TYPE;
745: l_dum_sec_app_ref_id NUMBER;
746: l_payment_set_id NUMBER;
747: l_claim_receivables_trx_id NUMBER;
748: l_comments ar_receivable_applications.comments%TYPE;

Line 748: l_comments ar_receivable_applications.comments%TYPE;

744: l_dum_app_ref_num ar_receivable_applications.application_ref_num%TYPE;
745: l_dum_sec_app_ref_id NUMBER;
746: l_payment_set_id NUMBER;
747: l_claim_receivables_trx_id NUMBER;
748: l_comments ar_receivable_applications.comments%TYPE;
749: l_customer_reference ar_receivable_applications.customer_reference%TYPE;
750: l_attribute_rec AR_Receipt_API_PUB.attribute_rec_type;
751: l_global_attribute_rec AR_Receipt_API_PUB.global_attribute_rec_type;
752: l_balance NUMBER := 0;

Line 749: l_customer_reference ar_receivable_applications.customer_reference%TYPE;

745: l_dum_sec_app_ref_id NUMBER;
746: l_payment_set_id NUMBER;
747: l_claim_receivables_trx_id NUMBER;
748: l_comments ar_receivable_applications.comments%TYPE;
749: l_customer_reference ar_receivable_applications.customer_reference%TYPE;
750: l_attribute_rec AR_Receipt_API_PUB.attribute_rec_type;
751: l_global_attribute_rec AR_Receipt_API_PUB.global_attribute_rec_type;
752: l_balance NUMBER := 0;
753: l_receipt_number ar_cash_receipts.receipt_number%TYPE;

Line 772: l_new_claim_num ar_receivable_applications.application_ref_num%TYPE;

768: l_discount_earned NUMBER;
769: l_discount_unearned NUMBER;
770: l_applied_amount_from NUMBER;
771: l_applied_amt_from_old NUMBER; /* Bug fix 5291088*/
772: l_new_claim_num ar_receivable_applications.application_ref_num%TYPE;
773: l_return_status VARCHAR2(1);
774: l_amount_status VARCHAR2(1); -- Bug 3809272
775: l_api_name CONSTANT VARCHAR2(30)
776: := 'split_claim_reapplication';

Line 788: select receivable_application_id from ar_receivable_applications_all

784:
785: /* Bug 7479983: Cursor is used to identify the applications associated to the claim on the receipt */
786:
787: CURSOR get_app_ids(p_cash_rcpt_id in NUMBER, p_ctx_id in NUMBER) IS
788: select receivable_application_id from ar_receivable_applications_all
789: where cash_receipt_id = p_cash_rcpt_id
790: and applied_customer_trx_id = p_ctx_id
791: and status = 'APP'
792: and reversal_gl_date IS NULL

Line 801: FROM ar_receivable_applications rec

797: , cv_claim_id IN NUMBER ) IS
798: SELECT sum(rec.amount_applied) amt_applied,
799: sum(rec.earned_discount_taken) earned_discount_taken,
800: sum(rec.unearned_discount_taken) unearned_discount_taken
801: FROM ar_receivable_applications rec
802: , ar_payment_schedules pay
803: WHERE rec.applied_payment_schedule_id = pay.payment_schedule_id
804: AND rec.cash_receipt_id = cv_cash_receipt_id
805: AND pay.customer_trx_id = cv_customer_trx_id

Line 875: ar_receivable_applications ra

871: INTO l_applied_ps_id
872: , l_trx_currency_code
873: , l_installment
874: FROM ar_payment_schedules ps,
875: ar_receivable_applications ra
876: WHERE ps.payment_schedule_id = ra.applied_payment_schedule_id
877: AND ra.application_ref_type = 'CLAIM'
878: AND ra.secondary_application_ref_id = p_claim_id
879: AND ra.cash_receipt_id = p_cash_receipt_id

Line 1455: FROM ar_receivable_applications app

1451: , x_global_attribute_rec.global_attribute17
1452: , x_global_attribute_rec.global_attribute18
1453: , x_global_attribute_rec.global_attribute19
1454: , x_global_attribute_rec.global_attribute20
1455: FROM ar_receivable_applications app
1456: WHERE app.secondary_application_ref_id = p_claim_id
1457: AND app.applied_payment_schedule_id + 0 = p_applied_ps_id
1458: AND app.application_ref_type = 'CLAIM'
1459: AND app.display = 'Y'

Line 1566: FROM ar_receivable_applications app

1562: , x_global_attribute_rec.global_attribute17
1563: , x_global_attribute_rec.global_attribute18
1564: , x_global_attribute_rec.global_attribute19
1565: , x_global_attribute_rec.global_attribute20
1566: FROM ar_receivable_applications app
1567: WHERE app.secondary_application_ref_id = p_claim_id
1568: AND app.applied_payment_schedule_id + 0 = p_applied_ps_id
1569: AND app.application_ref_type = 'CLAIM'
1570: AND app.status = DECODE(p_applied_ps_id,-4,'OTHER ACC','APP')

Line 1778: FROM ar_receivable_applications ra

1774: x_return_status := FND_API.G_RET_STS_SUCCESS;
1775:
1776: SELECT SUM(NVL(ra.amount_applied,0))
1777: INTO l_unapplied_total
1778: FROM ar_receivable_applications ra
1779: WHERE ra.cash_receipt_id = p_cash_receipt_id
1780: AND ra.status = 'UNAPP'
1781: AND NVL(ra.confirmed_flag,'Y') = 'Y';
1782: