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.

[Home] [Help]

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 723: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE := NULL;

719: l_app_gl_date DATE;
720: l_amount NUMBER;
721: l_bal_due_remaining NUMBER;
722: l_application_ref_id NUMBER := NULL;
723: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE := NULL;
724: l_application_ref_reason ar_receivable_applications.application_ref_reason%TYPE;
725: l_dum_app_ref_type ar_receivable_applications.application_ref_type%TYPE;
726: l_dum_app_ref_id NUMBER;
727: l_dum_app_ref_num ar_receivable_applications.application_ref_num%TYPE;

Line 724: l_application_ref_reason ar_receivable_applications.application_ref_reason%TYPE;

720: l_amount NUMBER;
721: l_bal_due_remaining NUMBER;
722: l_application_ref_id NUMBER := NULL;
723: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE := NULL;
724: l_application_ref_reason ar_receivable_applications.application_ref_reason%TYPE;
725: l_dum_app_ref_type ar_receivable_applications.application_ref_type%TYPE;
726: l_dum_app_ref_id NUMBER;
727: l_dum_app_ref_num ar_receivable_applications.application_ref_num%TYPE;
728: l_dum_sec_app_ref_id NUMBER;

Line 725: l_dum_app_ref_type ar_receivable_applications.application_ref_type%TYPE;

721: l_bal_due_remaining NUMBER;
722: l_application_ref_id NUMBER := NULL;
723: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE := NULL;
724: l_application_ref_reason ar_receivable_applications.application_ref_reason%TYPE;
725: l_dum_app_ref_type ar_receivable_applications.application_ref_type%TYPE;
726: l_dum_app_ref_id NUMBER;
727: l_dum_app_ref_num ar_receivable_applications.application_ref_num%TYPE;
728: l_dum_sec_app_ref_id NUMBER;
729: l_payment_set_id NUMBER;

Line 727: l_dum_app_ref_num ar_receivable_applications.application_ref_num%TYPE;

723: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE := NULL;
724: l_application_ref_reason ar_receivable_applications.application_ref_reason%TYPE;
725: l_dum_app_ref_type ar_receivable_applications.application_ref_type%TYPE;
726: l_dum_app_ref_id NUMBER;
727: l_dum_app_ref_num ar_receivable_applications.application_ref_num%TYPE;
728: l_dum_sec_app_ref_id NUMBER;
729: l_payment_set_id NUMBER;
730: l_claim_receivables_trx_id NUMBER;
731: l_comments ar_receivable_applications.comments%TYPE;

Line 731: l_comments ar_receivable_applications.comments%TYPE;

727: l_dum_app_ref_num ar_receivable_applications.application_ref_num%TYPE;
728: l_dum_sec_app_ref_id NUMBER;
729: l_payment_set_id NUMBER;
730: l_claim_receivables_trx_id NUMBER;
731: l_comments ar_receivable_applications.comments%TYPE;
732: l_customer_reference ar_receivable_applications.customer_reference%TYPE;
733: l_attribute_rec AR_Receipt_API_PUB.attribute_rec_type;
734: l_global_attribute_rec AR_Receipt_API_PUB.global_attribute_rec_type;
735: l_balance NUMBER := 0;

Line 732: l_customer_reference ar_receivable_applications.customer_reference%TYPE;

728: l_dum_sec_app_ref_id NUMBER;
729: l_payment_set_id NUMBER;
730: l_claim_receivables_trx_id NUMBER;
731: l_comments ar_receivable_applications.comments%TYPE;
732: l_customer_reference ar_receivable_applications.customer_reference%TYPE;
733: l_attribute_rec AR_Receipt_API_PUB.attribute_rec_type;
734: l_global_attribute_rec AR_Receipt_API_PUB.global_attribute_rec_type;
735: l_balance NUMBER := 0;
736: l_receipt_number ar_cash_receipts.receipt_number%TYPE;

Line 755: l_new_claim_num ar_receivable_applications.application_ref_num%TYPE;

751: l_discount_earned NUMBER;
752: l_discount_unearned NUMBER;
753: l_applied_amount_from NUMBER;
754: l_applied_amt_from_old NUMBER; /* Bug fix 5291088*/
755: l_new_claim_num ar_receivable_applications.application_ref_num%TYPE;
756: l_return_status VARCHAR2(1);
757: l_amount_status VARCHAR2(1); -- Bug 3809272
758: l_api_name CONSTANT VARCHAR2(30)
759: := 'split_claim_reapplication';

Line 770: select receivable_application_id from ar_receivable_applications_all

766:
767: /* Bug 7479983: Cursor is used to identify the applications associated to the claim on the receipt */
768:
769: CURSOR get_app_ids(p_cash_rcpt_id in NUMBER, p_ctx_id in NUMBER) IS
770: select receivable_application_id from ar_receivable_applications_all
771: where cash_receipt_id = p_cash_rcpt_id
772: and applied_customer_trx_id = p_ctx_id
773: and status = 'APP'
774: and reversal_gl_date IS NULL

Line 783: FROM ar_receivable_applications rec

779: , cv_claim_id IN NUMBER ) IS
780: SELECT sum(rec.amount_applied) amt_applied,
781: sum(rec.earned_discount_taken) earned_discount_taken,
782: sum(rec.unearned_discount_taken) unearned_discount_taken
783: FROM ar_receivable_applications rec
784: , ar_payment_schedules pay
785: WHERE rec.applied_payment_schedule_id = pay.payment_schedule_id
786: AND rec.cash_receipt_id = cv_cash_receipt_id
787: AND pay.customer_trx_id = cv_customer_trx_id

Line 841: ar_receivable_applications ra

837: INTO l_applied_ps_id
838: , l_trx_currency_code
839: , l_installment
840: FROM ar_payment_schedules ps,
841: ar_receivable_applications ra
842: WHERE ps.payment_schedule_id = ra.applied_payment_schedule_id
843: AND ra.application_ref_type = 'CLAIM'
844: AND ra.secondary_application_ref_id = p_claim_id
845: AND ra.cash_receipt_id = p_cash_receipt_id

Line 1421: FROM ar_receivable_applications app

1417: , x_global_attribute_rec.global_attribute17
1418: , x_global_attribute_rec.global_attribute18
1419: , x_global_attribute_rec.global_attribute19
1420: , x_global_attribute_rec.global_attribute20
1421: FROM ar_receivable_applications app
1422: WHERE app.secondary_application_ref_id = p_claim_id
1423: AND app.applied_payment_schedule_id + 0 = p_applied_ps_id
1424: AND app.application_ref_type = 'CLAIM'
1425: AND app.display = 'Y'

Line 1532: FROM ar_receivable_applications app

1528: , x_global_attribute_rec.global_attribute17
1529: , x_global_attribute_rec.global_attribute18
1530: , x_global_attribute_rec.global_attribute19
1531: , x_global_attribute_rec.global_attribute20
1532: FROM ar_receivable_applications app
1533: WHERE app.secondary_application_ref_id = p_claim_id
1534: AND app.applied_payment_schedule_id + 0 = p_applied_ps_id
1535: AND app.application_ref_type = 'CLAIM'
1536: AND app.status = DECODE(p_applied_ps_id,-4,'OTHER ACC','APP')

Line 1744: FROM ar_receivable_applications ra

1740: x_return_status := FND_API.G_RET_STS_SUCCESS;
1741:
1742: SELECT SUM(NVL(ra.amount_applied,0))
1743: INTO l_unapplied_total
1744: FROM ar_receivable_applications ra
1745: WHERE ra.cash_receipt_id = p_cash_receipt_id
1746: AND ra.status = 'UNAPP'
1747: AND NVL(ra.confirmed_flag,'Y') = 'Y';
1748: