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_APPLICATION dependencies on AR_CASH_RECEIPTS

Line 23: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,

19: p_module_version IN VARCHAR2 ) RETURN BOOLEAN;
20: --
21: PROCEDURE reverse_action(
22: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE,
23: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
24: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
25: p_reversal_gl_date IN DATE
26: , p_reversal_date IN DATE,
27: P_SELECT_FLAG IN BOOLEAN,

Line 59: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,

55: , p_reversal_date IN DATE);
56: --
57: PROCEDURE validate_reverse_action_args(
58: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE,
59: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
60: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
61: p_reversal_gl_date IN DATE, p_reversal_date IN DATE,
62: p_select_flag IN BOOLEAN );
63: --

Line 74: p_receipt_currency_code IN ar_cash_receipts.currency_code%TYPE,

70: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
71: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE,
72: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE,
73: p_invoice_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
74: p_receipt_currency_code IN ar_cash_receipts.currency_code%TYPE,
75: p_earned_discount_taken IN ar_receivable_applications.earned_discount_taken%TYPE,
76: p_unearned_discount_taken IN ar_receivable_applications.unearned_discount_taken%TYPE,
77: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
78: p_gl_date IN ar_receivable_applications.gl_date%TYPE );

Line 1461: l_cr_rec AR_CASH_RECEIPTS%ROWTYPE;

1457: l_amount_due_original NUMBER;
1458: l_on_account_total NUMBER; /*Added for Bug 2729626 */
1459:
1460: -- This is used to update cash receipt status after unapply.
1461: l_cr_rec AR_CASH_RECEIPTS%ROWTYPE;
1462: l_ae_doc_rec ae_doc_rec_type;
1463:
1464:
1465: l_gt_id NUMBER := 0;

Line 1999: , ar_cash_receipts cr

1995: , l_amount_due_original
1996: FROM
1997: ar_receipt_method_accounts rma
1998: , ar_payment_schedules ps
1999: , ar_cash_receipts cr
2000: , ar_receivables_trx ed
2001: , ar_receivables_trx uned
2002: WHERE
2003: cr.cash_receipt_id = p_ra_rec.cash_receipt_id

Line 2693: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,

2689: | |
2690: +===========================================================================*/
2691: PROCEDURE reverse_action(
2692: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE,
2693: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
2694: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
2695: p_reversal_gl_date IN DATE, p_reversal_date IN DATE,
2696: p_select_flag IN BOOLEAN,
2697: p_module_name IN VARCHAR2,

Line 2701: l_ass_cr_id ar_cash_receipts.cash_receipt_id%TYPE;

2697: p_module_name IN VARCHAR2,
2698: p_module_version IN VARCHAR2 ) IS
2699: l_adj_amount NUMBER;
2700: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
2701: l_ass_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
2702: l_app_rec arp_global.app_rec_type;
2703: l_ps_rec ar_payment_schedules%ROWTYPE;
2704:
2705: l_count NUMBER DEFAULT 0;

Line 2708: l_ass_cr_id ar_cash_receipts.cash_receipt_id%TYPE ) IS

2704:
2705: l_count NUMBER DEFAULT 0;
2706: --
2707: CURSOR ar_adjustments_C( l_ps_id ar_payment_schedules.payment_schedule_id%TYPE,
2708: l_ass_cr_id ar_cash_receipts.cash_receipt_id%TYPE ) IS
2709: SELECT a.chargeback_customer_trx_id,
2710: a.adjustment_id,
2711: a.status
2712: FROM ar_adjustments a,

Line 2723: l_ass_cr_id ar_cash_receipts.cash_receipt_id%TYPE ) IS

2719: AND b.customer_trx_id is null;
2720: --
2721: CURSOR ar_adjustments_radj_C(
2722: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE,
2723: l_ass_cr_id ar_cash_receipts.cash_receipt_id%TYPE ) IS
2724: SELECT adjustment_id,
2725: status
2726: FROM ar_adjustments
2727: WHERE associated_cash_receipt_id = l_ass_cr_id

Line 2996: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,

2992: | |
2993: +===========================================================================*/
2994: PROCEDURE validate_reverse_action_args(
2995: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE,
2996: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
2997: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
2998: p_reversal_gl_date IN DATE, p_reversal_date IN DATE,
2999: p_select_flag IN BOOLEAN ) IS
3000: BEGIN

Line 3157: p_receipt_currency_code IN ar_cash_receipts.currency_code%TYPE,

3153: p_trans_to_receipt_rate IN
3154: ar_receivable_applications.trans_to_receipt_rate%TYPE,
3155: p_invoice_currency_code IN
3156: ar_payment_schedules.invoice_currency_code%TYPE,
3157: p_receipt_currency_code IN ar_cash_receipts.currency_code%TYPE,
3158: p_earned_discount_taken IN
3159: ar_receivable_applications.earned_discount_taken%TYPE,
3160: p_unearned_discount_taken IN
3161: ar_receivable_applications.unearned_discount_taken%TYPE,

Line 3244: l_cr_rec ar_cash_receipts%ROWTYPE;

3240:
3241: l_rec_ra_rec ar_receivable_applications%ROWTYPE;
3242: l_inv_ra_rec ar_receivable_applications%ROWTYPE;
3243:
3244: l_cr_rec ar_cash_receipts%ROWTYPE;
3245: l_amount_due_remaining NUMBER;
3246: ln_batch_id NUMBER;
3247: --
3248: l_on_account_total NUMBER;

Line 3269: l_receipt_number ar_cash_receipts.receipt_number%TYPE;

3265: l_cust_trx_type_id ra_customer_trx.cust_trx_type_id%TYPE;
3266: l_customer_id ra_customer_trx.bill_to_customer_id%TYPE;
3267: l_bill_to_site_use_id ra_customer_trx.bill_to_site_use_id%TYPE;
3268: l_ship_to_site_use_id ra_customer_trx.ship_to_site_use_id%TYPE;
3269: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
3270: l_trx_amount_due NUMBER;
3271: l_claim_amount NUMBER;
3272: l_salesrep_id ra_customer_trx.primary_salesrep_id%TYPE;
3273: l_claim_trx_ps_id NUMBER;

Line 3308: FROM ar_cash_receipts

3304: WHERE t.customer_trx_id = p_customer_trx_id;
3305:
3306: CURSOR c_claim_rct_details (p_receipt_id NUMBER) IS
3307: SELECT receipt_number
3308: FROM ar_cash_receipts
3309: WHERE cash_receipt_id = p_receipt_id;
3310:
3311: CURSOR c_trx_amount_due (p_payment_schedule_id NUMBER) IS
3312: SELECT amount_due_remaining

Line 3467: FROM ar_cash_receipts cr

3463: , l_rec_ra_rec.code_combination_id
3464: , l_inv_ra_rec.earned_discount_ccid
3465: , l_inv_ra_rec.unearned_discount_ccid
3466: , ln_batch_id
3467: FROM ar_cash_receipts cr
3468: , ar_cash_receipt_history crh
3469: , ar_receipt_methods rm
3470: , ce_bank_acct_uses_ou ba
3471: , ar_receipt_method_accounts rma

Line 4229: p_receipt_currency_code IN ar_cash_receipts.currency_code%TYPE,

4225: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
4226: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE,
4227: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE,
4228: p_invoice_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
4229: p_receipt_currency_code IN ar_cash_receipts.currency_code%TYPE,
4230: p_earned_discount_taken IN ar_receivable_applications.earned_discount_taken%TYPE,
4231: p_unearned_discount_taken IN ar_receivable_applications.unearned_discount_taken%TYPE,
4232: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
4233: p_gl_date IN ar_receivable_applications.gl_date%TYPE ) IS

Line 4905: l_cr_rec ar_cash_receipts%ROWTYPE;

4901:
4902: l_ra_rec ar_receivable_applications%ROWTYPE;
4903: l_ps_rec ar_payment_schedules%ROWTYPE;
4904:
4905: l_cr_rec ar_cash_receipts%ROWTYPE;
4906: l_amount_due_remaining NUMBER;
4907: ln_batch_id NUMBER;
4908: functional_curr VARCHAR2(100);
4909:

Line 4958: , ar_cash_receipts cr

4954: l_onacc_cc_id,
4955: l_unapp_cc_id
4956: , ln_batch_id
4957: FROM ar_payment_schedules ps
4958: , ar_cash_receipts cr
4959: , ar_cash_receipt_history crh
4960: , ar_receipt_methods rm
4961: , ce_bank_acct_uses ba
4962: , ar_receipt_method_accounts rma

Line 5451: p_netted_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,

5447: p_out_rec_application_id OUT NOCOPY NUMBER,
5448: p_applied_rec_app_id IN NUMBER,
5449: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE,
5450: p_netted_receipt_flag IN VARCHAR2,
5451: p_netted_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
5452: p_secondary_app_ref_type IN
5453: ar_receivable_applications.secondary_application_ref_type%TYPE := null,
5454: p_secondary_app_ref_num IN
5455: ar_receivable_applications.secondary_application_ref_num%TYPE := null,

Line 5472: ar_cash_receipts cr,

5468: crh.batch_id,
5469: rt.code_combination_id activity_ccid,
5470: rt.type activity_type
5471: FROM ar_payment_schedules ps,
5472: ar_cash_receipts cr,
5473: ar_cash_receipt_history crh,
5474: ar_receipt_methods rm,
5475: ce_bank_acct_uses ba,
5476: ar_receipt_method_accounts rma,

Line 5492: l_cr_rec ar_cash_receipts%ROWTYPE;

5488: activity_rec activity_c%ROWTYPE;
5489:
5490: l_ra_rec ar_receivable_applications%ROWTYPE;
5491: l_ps_rec ar_payment_schedules%ROWTYPE;
5492: l_cr_rec ar_cash_receipts%ROWTYPE;
5493: l_crcpt_rec ar_cash_receipts%ROWTYPE;
5494:
5495: l_unapp_ra_rec ar_receivable_applications%ROWTYPE; /* MRC */
5496:

Line 5493: l_crcpt_rec ar_cash_receipts%ROWTYPE;

5489:
5490: l_ra_rec ar_receivable_applications%ROWTYPE;
5491: l_ps_rec ar_payment_schedules%ROWTYPE;
5492: l_cr_rec ar_cash_receipts%ROWTYPE;
5493: l_crcpt_rec ar_cash_receipts%ROWTYPE;
5494:
5495: l_unapp_ra_rec ar_receivable_applications%ROWTYPE; /* MRC */
5496:
5497: functional_curr VARCHAR2(100);

Line 5504: l_receipt_currency_code ar_cash_receipts.currency_code%TYPE;

5500: l_prev_unapp_id NUMBER;
5501: l_acctd_amount_applied_from ar_receivable_applications.acctd_amount_applied_from%TYPE;
5502: l_acctd_amount_applied_to ar_receivable_applications.acctd_amount_applied_to%TYPE;
5503: l_invoice_currency_code ra_customer_trx.invoice_currency_code%TYPE;
5504: l_receipt_currency_code ar_cash_receipts.currency_code%TYPE;
5505: l_exchange_rate ra_customer_trx.exchange_rate%TYPE;
5506: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
5507: l_func_amount_due_remaining ar_payment_schedules.amount_due_remaining%TYPE;
5508:

Line 5541: l_pymnt_trxn_ext_id_temp ar_cash_receipts.payment_trxn_extension_id%TYPE;

5537: l_xla_ev_rec arp_xla_events.xla_events_type;
5538: l_xla_doc_table VARCHAR2(20);
5539:
5540: -- Bug 7317841
5541: l_pymnt_trxn_ext_id_temp ar_cash_receipts.payment_trxn_extension_id%TYPE;
5542:
5543: BEGIN
5544: IF PG_DEBUG in ('Y', 'C') THEN
5545: arp_standard.debug( 'arp_process_application.activity_application()+' );

Line 5630: FROM ar_cash_receipts

5626: /* Start Bug 7317841 */
5627: BEGIN
5628: SELECT payment_trxn_extension_id
5629: INTO l_pymnt_trxn_ext_id_temp
5630: FROM ar_cash_receipts
5631: WHERE cash_receipt_id IN (
5632: SELECT MAX(application_ref_id)
5633: FROM ar_receivable_applications
5634: WHERE cash_receipt_id = l_ps_rec.cash_receipt_id

Line 5849: FROM ar_cash_receipts

5845: SELECT currency_code,
5846: exchange_rate
5847: INTO l_receipt_currency_code,
5848: l_exchange_rate
5849: FROM ar_cash_receipts
5850: WHERE cash_receipt_id = l_application_ref_id;
5851:
5852: l_ra_rec.acctd_amount_applied_to :=
5853: ARPCURR.functional_amount(

Line 6727: l_cr_rec ar_cash_receipts%ROWTYPE;

6723:
6724: l_ra_rec ar_receivable_applications%ROWTYPE;
6725: l_ps_rec ar_payment_schedules%ROWTYPE;
6726:
6727: l_cr_rec ar_cash_receipts%ROWTYPE;
6728: l_amount_due_remaining NUMBER;
6729: ln_batch_id NUMBER;
6730: functional_curr VARCHAR2(100);
6731:

Line 6738: l_currency_code ar_cash_receipts.currency_code%TYPE;

6734:
6735: l_on_account_total NUMBER;
6736: l_ae_doc_rec ae_doc_rec_type;
6737: l_prev_unapp_id NUMBER;
6738: l_currency_code ar_cash_receipts.currency_code%TYPE;
6739: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
6740: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
6741: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
6742: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;

Line 6739: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;

6735: l_on_account_total NUMBER;
6736: l_ae_doc_rec ae_doc_rec_type;
6737: l_prev_unapp_id NUMBER;
6738: l_currency_code ar_cash_receipts.currency_code%TYPE;
6739: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
6740: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
6741: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
6742: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
6743: l_customer_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;

Line 6740: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;

6736: l_ae_doc_rec ae_doc_rec_type;
6737: l_prev_unapp_id NUMBER;
6738: l_currency_code ar_cash_receipts.currency_code%TYPE;
6739: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
6740: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
6741: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
6742: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
6743: l_customer_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
6744: l_receipt_number ar_cash_receipts.receipt_number%TYPE;

Line 6741: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;

6737: l_prev_unapp_id NUMBER;
6738: l_currency_code ar_cash_receipts.currency_code%TYPE;
6739: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
6740: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
6741: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
6742: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
6743: l_customer_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
6744: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
6745: l_claim_reason_code_id NUMBER;

Line 6742: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;

6738: l_currency_code ar_cash_receipts.currency_code%TYPE;
6739: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
6740: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
6741: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
6742: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
6743: l_customer_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
6744: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
6745: l_claim_reason_code_id NUMBER;
6746: l_claim_reason_name VARCHAR2(80);

Line 6743: l_customer_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;

6739: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
6740: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
6741: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
6742: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
6743: l_customer_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
6744: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
6745: l_claim_reason_code_id NUMBER;
6746: l_claim_reason_name VARCHAR2(80);
6747: l_amount_applied NUMBER;

Line 6744: l_receipt_number ar_cash_receipts.receipt_number%TYPE;

6740: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
6741: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
6742: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
6743: l_customer_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
6744: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
6745: l_claim_reason_code_id NUMBER;
6746: l_claim_reason_name VARCHAR2(80);
6747: l_amount_applied NUMBER;
6748: l_legal_entity_id NUMBER;

Line 6811: , ar_cash_receipts cr

6807: , l_customer_site_use_id
6808: , l_receipt_number
6809: , l_legal_entity_id
6810: FROM ar_payment_schedules ps
6811: , ar_cash_receipts cr
6812: , ar_cash_receipt_history crh
6813: , ar_receipt_methods rm
6814: , ce_bank_acct_uses ba
6815: , ar_receipt_method_accounts rma

Line 7483: l_receipt_number ar_cash_receipts.receipt_number%TYPE;

7479: , x_msg_data OUT NOCOPY VARCHAR2)
7480: IS
7481:
7482: l_claim_rec OZF_Claim_GRP.Deduction_Rec_Type;
7483: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
7484: l_return_status VARCHAR2(1);
7485: l_object_version_number NUMBER;
7486: l_claim_number VARCHAR2(30);
7487: l_amount_from_dispute NUMBER;

Line 7512: FROM ar_cash_receipts

7508: l_claim_rec.applied_receipt_id := p_cash_receipt_id;
7509: IF p_receipt_number IS NULL
7510: THEN
7511: SELECT receipt_number INTO l_receipt_number
7512: FROM ar_cash_receipts
7513: WHERE cash_receipt_id = p_cash_receipt_id;
7514: ELSE
7515: l_receipt_number := p_receipt_number;
7516: END IF;

Line 8269: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;

8265: l_return_status VARCHAR2(1);
8266: l_msg_count NUMBER;
8267: l_msg_data VARCHAR2(2000);
8268: l_msg_index NUMBER;
8269: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
8270: functional_curr VARCHAR2(100);
8271:
8272: l_receivable_application_id NUMBER;
8273: