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 27: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,

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

Line 63: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,

59: , p_reversal_date IN DATE);
60: --
61: PROCEDURE validate_reverse_action_args(
62: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE,
63: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
64: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
65: p_reversal_gl_date IN DATE, p_reversal_date IN DATE,
66: p_select_flag IN BOOLEAN );
67: --

Line 78: p_receipt_currency_code IN ar_cash_receipts.currency_code%TYPE,

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

Line 1542: l_cr_rec AR_CASH_RECEIPTS%ROWTYPE;

1538: l_amount_due_original NUMBER;
1539: l_on_account_total NUMBER; /*Added for Bug 2729626 */
1540:
1541: -- This is used to update cash receipt status after unapply.
1542: l_cr_rec AR_CASH_RECEIPTS%ROWTYPE;
1543: l_ae_doc_rec ae_doc_rec_type;
1544:
1545:
1546: l_gt_id NUMBER := 0;

Line 2082: , ar_cash_receipts cr

2078: , l_amount_due_original
2079: FROM
2080: ar_receipt_method_accounts rma
2081: , ar_payment_schedules ps
2082: , ar_cash_receipts cr
2083: , ar_receivables_trx ed
2084: , ar_receivables_trx uned
2085: WHERE
2086: cr.cash_receipt_id = p_ra_rec.cash_receipt_id

Line 2788: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,

2784: | |
2785: +===========================================================================*/
2786: PROCEDURE reverse_action(
2787: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE,
2788: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
2789: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
2790: p_reversal_gl_date IN DATE, p_reversal_date IN DATE,
2791: p_select_flag IN BOOLEAN,
2792: p_module_name IN VARCHAR2,

Line 2796: l_ass_cr_id ar_cash_receipts.cash_receipt_id%TYPE;

2792: p_module_name IN VARCHAR2,
2793: p_module_version IN VARCHAR2 ) IS
2794: l_adj_amount NUMBER;
2795: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
2796: l_ass_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
2797: l_app_rec arp_global.app_rec_type;
2798: l_ps_rec ar_payment_schedules%ROWTYPE;
2799:
2800: l_count NUMBER DEFAULT 0;

Line 2803: l_ass_cr_id ar_cash_receipts.cash_receipt_id%TYPE ) IS

2799:
2800: l_count NUMBER DEFAULT 0;
2801: --
2802: CURSOR ar_adjustments_C( l_ps_id ar_payment_schedules.payment_schedule_id%TYPE,
2803: l_ass_cr_id ar_cash_receipts.cash_receipt_id%TYPE ) IS
2804: SELECT a.chargeback_customer_trx_id,
2805: a.adjustment_id,
2806: a.status
2807: FROM ar_adjustments a,

Line 2818: l_ass_cr_id ar_cash_receipts.cash_receipt_id%TYPE ) IS

2814: AND b.customer_trx_id is null;
2815: --
2816: CURSOR ar_adjustments_radj_C(
2817: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE,
2818: l_ass_cr_id ar_cash_receipts.cash_receipt_id%TYPE ) IS
2819: SELECT adjustment_id,
2820: status
2821: FROM ar_adjustments
2822: WHERE associated_cash_receipt_id = l_ass_cr_id

Line 3100: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,

3096: | |
3097: +===========================================================================*/
3098: PROCEDURE validate_reverse_action_args(
3099: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE,
3100: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
3101: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
3102: p_reversal_gl_date IN DATE, p_reversal_date IN DATE,
3103: p_select_flag IN BOOLEAN ) IS
3104: BEGIN

Line 3263: p_receipt_currency_code IN ar_cash_receipts.currency_code%TYPE,

3259: p_trans_to_receipt_rate IN
3260: ar_receivable_applications.trans_to_receipt_rate%TYPE,
3261: p_invoice_currency_code IN
3262: ar_payment_schedules.invoice_currency_code%TYPE,
3263: p_receipt_currency_code IN ar_cash_receipts.currency_code%TYPE,
3264: p_earned_discount_taken IN
3265: ar_receivable_applications.earned_discount_taken%TYPE,
3266: p_unearned_discount_taken IN
3267: ar_receivable_applications.unearned_discount_taken%TYPE,

Line 3350: l_cr_rec ar_cash_receipts%ROWTYPE;

3346:
3347: l_rec_ra_rec ar_receivable_applications%ROWTYPE;
3348: l_inv_ra_rec ar_receivable_applications%ROWTYPE;
3349:
3350: l_cr_rec ar_cash_receipts%ROWTYPE;
3351: l_amount_due_remaining NUMBER;
3352: ln_batch_id NUMBER;
3353: --
3354: l_on_account_total NUMBER;

Line 3375: l_receipt_number ar_cash_receipts.receipt_number%TYPE;

3371: l_cust_trx_type_id ra_customer_trx.cust_trx_type_id%TYPE;
3372: l_customer_id ra_customer_trx.bill_to_customer_id%TYPE;
3373: l_bill_to_site_use_id ra_customer_trx.bill_to_site_use_id%TYPE;
3374: l_ship_to_site_use_id ra_customer_trx.ship_to_site_use_id%TYPE;
3375: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
3376: l_trx_amount_due NUMBER;
3377: l_claim_amount NUMBER;
3378: l_salesrep_id ra_customer_trx.primary_salesrep_id%TYPE;
3379: l_claim_trx_ps_id NUMBER;

Line 3414: FROM ar_cash_receipts

3410: WHERE t.customer_trx_id = p_customer_trx_id;
3411:
3412: CURSOR c_claim_rct_details (p_receipt_id NUMBER) IS
3413: SELECT receipt_number
3414: FROM ar_cash_receipts
3415: WHERE cash_receipt_id = p_receipt_id;
3416:
3417: CURSOR c_trx_amount_due (p_payment_schedule_id NUMBER) IS
3418: SELECT amount_due_remaining

Line 3603: FROM ar_cash_receipts cr,

3599: SELECT cr.deposit_date, rm.maturity_date_rule_code, ps.due_date,
3600: ps.amount_applied, cr.org_id
3601: INTO l_receipt_date, l_maturity_date_rule, l_maturity_date,
3602: l_amount_applied, l_org_id
3603: FROM ar_cash_receipts cr,
3604: ar_receipt_methods rm,
3605: ar_payment_schedules ps
3606: WHERE cr.cash_receipt_id = l_rec_ra_rec.cash_receipt_id
3607: AND cr.receipt_method_id = rm.receipt_method_id

Line 3640: FROM ar_cash_receipts cr

3636: , l_receipt_date
3637: , l_maturity_date
3638: , l_amount_applied
3639: , l_org_id
3640: FROM ar_cash_receipts cr
3641: , ar_cash_receipt_history crh
3642: , ar_receipt_methods rm
3643: , ce_bank_acct_uses_ou ba
3644: , ar_receipt_method_accounts rma

Line 4520: p_receipt_currency_code IN ar_cash_receipts.currency_code%TYPE,

4516: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
4517: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE,
4518: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE,
4519: p_invoice_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
4520: p_receipt_currency_code IN ar_cash_receipts.currency_code%TYPE,
4521: p_earned_discount_taken IN ar_receivable_applications.earned_discount_taken%TYPE,
4522: p_unearned_discount_taken IN ar_receivable_applications.unearned_discount_taken%TYPE,
4523: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
4524: p_gl_date IN ar_receivable_applications.gl_date%TYPE ) IS

Line 5248: l_cr_rec ar_cash_receipts%ROWTYPE;

5244:
5245: l_ra_rec ar_receivable_applications%ROWTYPE;
5246: l_ps_rec ar_payment_schedules%ROWTYPE;
5247:
5248: l_cr_rec ar_cash_receipts%ROWTYPE;
5249: l_amount_due_remaining NUMBER;
5250: ln_batch_id NUMBER;
5251: functional_curr VARCHAR2(100);
5252:

Line 5301: , ar_cash_receipts cr

5297: l_onacc_cc_id,
5298: l_unapp_cc_id
5299: , ln_batch_id
5300: FROM ar_payment_schedules ps
5301: , ar_cash_receipts cr
5302: , ar_cash_receipt_history crh
5303: , ar_receipt_methods rm
5304: , ce_bank_acct_uses ba
5305: , ar_receipt_method_accounts rma

Line 5799: p_netted_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,

5795: p_out_rec_application_id OUT NOCOPY NUMBER,
5796: p_applied_rec_app_id IN NUMBER,
5797: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE,
5798: p_netted_receipt_flag IN VARCHAR2,
5799: p_netted_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
5800: p_secondary_app_ref_type IN
5801: ar_receivable_applications.secondary_application_ref_type%TYPE := null,
5802: p_secondary_app_ref_num IN
5803: ar_receivable_applications.secondary_application_ref_num%TYPE := null,

Line 5820: ar_cash_receipts cr,

5816: crh.batch_id,
5817: rt.code_combination_id activity_ccid,
5818: rt.type activity_type
5819: FROM ar_payment_schedules ps,
5820: ar_cash_receipts cr,
5821: ar_cash_receipt_history crh,
5822: ar_receipt_methods rm,
5823: ce_bank_acct_uses ba,
5824: ar_receipt_method_accounts rma,

Line 5840: l_cr_rec ar_cash_receipts%ROWTYPE;

5836: activity_rec activity_c%ROWTYPE;
5837:
5838: l_ra_rec ar_receivable_applications%ROWTYPE;
5839: l_ps_rec ar_payment_schedules%ROWTYPE;
5840: l_cr_rec ar_cash_receipts%ROWTYPE;
5841: l_crcpt_rec ar_cash_receipts%ROWTYPE;
5842:
5843: l_unapp_ra_rec ar_receivable_applications%ROWTYPE; /* MRC */
5844:

Line 5841: l_crcpt_rec ar_cash_receipts%ROWTYPE;

5837:
5838: l_ra_rec ar_receivable_applications%ROWTYPE;
5839: l_ps_rec ar_payment_schedules%ROWTYPE;
5840: l_cr_rec ar_cash_receipts%ROWTYPE;
5841: l_crcpt_rec ar_cash_receipts%ROWTYPE;
5842:
5843: l_unapp_ra_rec ar_receivable_applications%ROWTYPE; /* MRC */
5844:
5845: functional_curr VARCHAR2(100);

Line 5852: l_receipt_currency_code ar_cash_receipts.currency_code%TYPE;

5848: l_prev_unapp_id NUMBER;
5849: l_acctd_amount_applied_from ar_receivable_applications.acctd_amount_applied_from%TYPE;
5850: l_acctd_amount_applied_to ar_receivable_applications.acctd_amount_applied_to%TYPE;
5851: l_invoice_currency_code ra_customer_trx.invoice_currency_code%TYPE;
5852: l_receipt_currency_code ar_cash_receipts.currency_code%TYPE;
5853: l_exchange_rate ra_customer_trx.exchange_rate%TYPE;
5854: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
5855: l_func_amount_due_remaining ar_payment_schedules.amount_due_remaining%TYPE;
5856:

Line 5889: l_pymnt_trxn_ext_id_temp ar_cash_receipts.payment_trxn_extension_id%TYPE;

5885: l_xla_ev_rec arp_xla_events.xla_events_type;
5886: l_xla_doc_table VARCHAR2(20);
5887:
5888: -- Bug 7317841
5889: l_pymnt_trxn_ext_id_temp ar_cash_receipts.payment_trxn_extension_id%TYPE;
5890:
5891: BEGIN
5892: IF PG_DEBUG in ('Y', 'C') THEN
5893: arp_debug.debug( 'arp_process_application.activity_application()+' );

Line 5979: FROM ar_cash_receipts

5975: IF(Nvl(l_called_from,'x') <> 'CC_CHARGEBACK') THEN -- Bug 13850391
5976: BEGIN
5977: SELECT payment_trxn_extension_id
5978: INTO l_pymnt_trxn_ext_id_temp
5979: FROM ar_cash_receipts
5980: WHERE cash_receipt_id IN (
5981: SELECT MAX(application_ref_id)
5982: FROM ar_receivable_applications
5983: WHERE cash_receipt_id = l_ps_rec.cash_receipt_id

Line 6201: FROM ar_cash_receipts

6197: SELECT currency_code,
6198: exchange_rate
6199: INTO l_receipt_currency_code,
6200: l_exchange_rate
6201: FROM ar_cash_receipts
6202: WHERE cash_receipt_id = l_application_ref_id;
6203:
6204: l_ra_rec.acctd_amount_applied_to :=
6205: ARPCURR.functional_amount(

Line 7079: l_cr_rec ar_cash_receipts%ROWTYPE;

7075:
7076: l_ra_rec ar_receivable_applications%ROWTYPE;
7077: l_ps_rec ar_payment_schedules%ROWTYPE;
7078:
7079: l_cr_rec ar_cash_receipts%ROWTYPE;
7080: l_amount_due_remaining NUMBER;
7081: ln_batch_id NUMBER;
7082: functional_curr VARCHAR2(100);
7083:

Line 7090: l_currency_code ar_cash_receipts.currency_code%TYPE;

7086:
7087: l_on_account_total NUMBER;
7088: l_ae_doc_rec ae_doc_rec_type;
7089: l_prev_unapp_id NUMBER;
7090: l_currency_code ar_cash_receipts.currency_code%TYPE;
7091: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
7092: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
7093: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
7094: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;

Line 7091: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;

7087: l_on_account_total NUMBER;
7088: l_ae_doc_rec ae_doc_rec_type;
7089: l_prev_unapp_id NUMBER;
7090: l_currency_code ar_cash_receipts.currency_code%TYPE;
7091: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
7092: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
7093: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
7094: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
7095: l_customer_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;

Line 7092: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;

7088: l_ae_doc_rec ae_doc_rec_type;
7089: l_prev_unapp_id NUMBER;
7090: l_currency_code ar_cash_receipts.currency_code%TYPE;
7091: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
7092: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
7093: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
7094: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
7095: l_customer_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
7096: l_receipt_number ar_cash_receipts.receipt_number%TYPE;

Line 7093: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;

7089: l_prev_unapp_id NUMBER;
7090: l_currency_code ar_cash_receipts.currency_code%TYPE;
7091: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
7092: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
7093: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
7094: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
7095: l_customer_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
7096: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
7097: l_claim_reason_code_id NUMBER;

Line 7094: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;

7090: l_currency_code ar_cash_receipts.currency_code%TYPE;
7091: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
7092: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
7093: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
7094: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
7095: l_customer_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
7096: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
7097: l_claim_reason_code_id NUMBER;
7098: l_claim_reason_name VARCHAR2(80);

Line 7095: l_customer_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;

7091: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
7092: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
7093: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
7094: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
7095: l_customer_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
7096: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
7097: l_claim_reason_code_id NUMBER;
7098: l_claim_reason_name VARCHAR2(80);
7099: l_amount_applied NUMBER;

Line 7096: l_receipt_number ar_cash_receipts.receipt_number%TYPE;

7092: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
7093: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
7094: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
7095: l_customer_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
7096: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
7097: l_claim_reason_code_id NUMBER;
7098: l_claim_reason_name VARCHAR2(80);
7099: l_amount_applied NUMBER;
7100: l_legal_entity_id NUMBER;

Line 7163: , ar_cash_receipts cr

7159: , l_customer_site_use_id
7160: , l_receipt_number
7161: , l_legal_entity_id
7162: FROM ar_payment_schedules ps
7163: , ar_cash_receipts cr
7164: , ar_cash_receipt_history crh
7165: , ar_receipt_methods rm
7166: , ce_bank_acct_uses ba
7167: , ar_receipt_method_accounts rma

Line 7838: l_receipt_number ar_cash_receipts.receipt_number%TYPE;

7834: , p_reason_id IN NUMBER DEFAULT NULL)--Yao Zhang add for bug 10197191
7835: IS
7836:
7837: l_claim_rec OZF_Claim_GRP.Deduction_Rec_Type;
7838: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
7839: l_return_status VARCHAR2(1);
7840: l_object_version_number NUMBER;
7841: l_claim_number VARCHAR2(30);
7842: l_amount_from_dispute NUMBER;

Line 7884: FROM ar_cash_receipts

7880: l_claim_rec.reason_code_id := p_reason_id;--Yao Zhang added for bug 10197191
7881: IF p_receipt_number IS NULL
7882: THEN
7883: SELECT receipt_number INTO l_receipt_number
7884: FROM ar_cash_receipts
7885: WHERE cash_receipt_id = p_cash_receipt_id;
7886: ELSE
7887: l_receipt_number := p_receipt_number;
7888: END IF;

Line 8736: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;

8732: l_return_status VARCHAR2(1);
8733: l_msg_count NUMBER;
8734: l_msg_data VARCHAR2(2000);
8735: l_msg_index NUMBER;
8736: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
8737: functional_curr VARCHAR2(100);
8738:
8739: l_line_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
8740: l_tax_remaining ar_payment_schedules.tax_remaining%TYPE:=0;