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 RA_CUSTOMER_TRX

Line 2296: l_ct_id ra_customer_trx.customer_trx_id%TYPE;

2292: p_module_name IN VARCHAR2,
2293: p_module_version IN VARCHAR2 ) RETURN BOOLEAN IS
2294: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
2295: l_ass_cr_id ar_adjustments.associated_cash_receipt_id%TYPE;
2296: l_ct_id ra_customer_trx.customer_trx_id%TYPE;
2297: l_adj_amt NUMBER;
2298: l_pend_amt NUMBER;
2299: l_pmt NUMBER;
2300: l_edisc NUMBER;

Line 2880: UPDATE ra_customer_trx

2876: arp_standard.debug(
2877: 'after ar_adjustment.reverse_adjustment in app_delete' );
2878: END IF;
2879: --
2880: UPDATE ra_customer_trx
2881: SET status_trx = 'CL'
2882: WHERE customer_trx_id = l_adj_rec.chargeback_customer_trx_id;
2883: IF PG_DEBUG in ('Y', 'C') THEN
2884: arp_standard.debug( 'after UPDATE in app_delete ' );

Line 3261: l_exchange_rate_type ra_customer_trx.exchange_rate_type%TYPE;

3257:
3258: l_old_ps_rec ar_payment_schedules%ROWTYPE; /* jrautiai BR implementation */
3259: l_new_ps_rec ar_payment_schedules%ROWTYPE; /* jrautiai BR implementation */
3260: l_source_type ar_distributions.source_type%TYPE; /* jrautiai BR implementation */
3261: l_exchange_rate_type ra_customer_trx.exchange_rate_type%TYPE;
3262: l_exchange_rate_date ra_customer_trx.exchange_date%TYPE;
3263: l_exchange_rate ra_customer_trx.exchange_rate%TYPE;
3264: l_trx_number ra_customer_trx.trx_number%TYPE;
3265: l_cust_trx_type_id ra_customer_trx.cust_trx_type_id%TYPE;

Line 3262: l_exchange_rate_date ra_customer_trx.exchange_date%TYPE;

3258: l_old_ps_rec ar_payment_schedules%ROWTYPE; /* jrautiai BR implementation */
3259: l_new_ps_rec ar_payment_schedules%ROWTYPE; /* jrautiai BR implementation */
3260: l_source_type ar_distributions.source_type%TYPE; /* jrautiai BR implementation */
3261: l_exchange_rate_type ra_customer_trx.exchange_rate_type%TYPE;
3262: l_exchange_rate_date ra_customer_trx.exchange_date%TYPE;
3263: l_exchange_rate ra_customer_trx.exchange_rate%TYPE;
3264: l_trx_number ra_customer_trx.trx_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;

Line 3263: l_exchange_rate ra_customer_trx.exchange_rate%TYPE;

3259: l_new_ps_rec ar_payment_schedules%ROWTYPE; /* jrautiai BR implementation */
3260: l_source_type ar_distributions.source_type%TYPE; /* jrautiai BR implementation */
3261: l_exchange_rate_type ra_customer_trx.exchange_rate_type%TYPE;
3262: l_exchange_rate_date ra_customer_trx.exchange_date%TYPE;
3263: l_exchange_rate ra_customer_trx.exchange_rate%TYPE;
3264: l_trx_number ra_customer_trx.trx_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;

Line 3264: l_trx_number ra_customer_trx.trx_number%TYPE;

3260: l_source_type ar_distributions.source_type%TYPE; /* jrautiai BR implementation */
3261: l_exchange_rate_type ra_customer_trx.exchange_rate_type%TYPE;
3262: l_exchange_rate_date ra_customer_trx.exchange_date%TYPE;
3263: l_exchange_rate ra_customer_trx.exchange_rate%TYPE;
3264: l_trx_number ra_customer_trx.trx_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;

Line 3265: l_cust_trx_type_id ra_customer_trx.cust_trx_type_id%TYPE;

3261: l_exchange_rate_type ra_customer_trx.exchange_rate_type%TYPE;
3262: l_exchange_rate_date ra_customer_trx.exchange_date%TYPE;
3263: l_exchange_rate ra_customer_trx.exchange_rate%TYPE;
3264: l_trx_number ra_customer_trx.trx_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;

Line 3266: l_customer_id ra_customer_trx.bill_to_customer_id%TYPE;

3262: l_exchange_rate_date ra_customer_trx.exchange_date%TYPE;
3263: l_exchange_rate ra_customer_trx.exchange_rate%TYPE;
3264: l_trx_number ra_customer_trx.trx_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;

Line 3267: l_bill_to_site_use_id ra_customer_trx.bill_to_site_use_id%TYPE;

3263: l_exchange_rate ra_customer_trx.exchange_rate%TYPE;
3264: l_trx_number ra_customer_trx.trx_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;

Line 3268: l_ship_to_site_use_id ra_customer_trx.ship_to_site_use_id%TYPE;

3264: l_trx_number ra_customer_trx.trx_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;

Line 3272: l_salesrep_id ra_customer_trx.primary_salesrep_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;
3274: l_claim_id NUMBER;
3275: l_claim_reason_code_id NUMBER;
3276: l_claim_reason_name VARCHAR2(80);

Line 3303: FROM ra_customer_trx t

3299: , t.bill_to_site_use_id
3300: , t.ship_to_site_use_id
3301: , t.primary_salesrep_id
3302: , t.legal_entity_id
3303: FROM ra_customer_trx t
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

Line 5503: l_invoice_currency_code ra_customer_trx.invoice_currency_code%TYPE;

5499: l_ae_doc_rec ae_doc_rec_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;

Line 5505: l_exchange_rate ra_customer_trx.exchange_rate%TYPE;

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:
5509: l_fnd_api_constants_rec ar_bills_main.fnd_api_constants_type := ar_bills_main.get_fnd_api_constants_rec;

Line 5828: FROM ra_customer_trx

5824: SELECT invoice_currency_code,
5825: exchange_rate
5826: INTO l_invoice_currency_code,
5827: l_exchange_rate
5828: FROM ra_customer_trx
5829: WHERE customer_trx_id = p_application_ref_id;
5830:
5831: l_ra_rec.acctd_amount_applied_to :=
5832: ARPCURR.functional_amount(

Line 6307: CURSOR trx_dist_cur(l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE) IS

6303: FROM ar_payment_schedules ps
6304: WHERE ps.payment_schedule_id = p_invoice_ps_id;
6305:
6306: /* Cursor to fetch normal transaction CCID, the old functionality */
6307: CURSOR trx_dist_cur(l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE) IS
6308: SELECT dist.code_combination_id
6309: FROM ra_cust_trx_line_gl_dist dist
6310: WHERE dist.customer_trx_id = l_customer_trx_id
6311: AND dist.account_class = 'REC'

Line 6333: CURSOR br_current_trh_cur(p_customer_trx_id ra_customer_trx.customer_trx_id%TYPE) IS

6329: and (nvl(dist.AMOUNT_DR,0) = 0) and (nvl(dist.ACCTD_AMOUNT_DR,0) = 0)))
6330: order by dist.line_id desc;
6331:
6332: /* Cursor to fetch current BR transaction history record */
6333: CURSOR br_current_trh_cur(p_customer_trx_id ra_customer_trx.customer_trx_id%TYPE) IS
6334: SELECT trh.transaction_history_id, trh.postable_flag, trh.event
6335: FROM ar_transaction_history trh
6336: WHERE trh.customer_trx_id = p_customer_trx_id
6337: AND trh.current_accounted_flag = 'Y';

Line 8520: l_trx_number ra_customer_trx.trx_number%TYPE;

8516: +===========================================================================*/
8517: PROCEDURE Unassociate_Regular_CM ( p_cust_Trx_id IN NUMBER,
8518: p_app_cust_trx_id IN NUMBER) IS
8519:
8520: l_trx_number ra_customer_trx.trx_number%TYPE;
8521: l_message_text VARCHAR2(2000);
8522:
8523: BEGIN
8524: arp_standard.debug('arp_process_application.Unapply_Regular_CM()+');

Line 8529: Update ra_customer_Trx

8525:
8526: -- since we are unapplying the regular cm, we need to null out the
8527: -- previous_customer_trx_id and previous_customer_trx_line_id
8528:
8529: Update ra_customer_Trx
8530: set previous_customer_Trx_id = NULL
8531: where customer_Trx_id = p_cust_trx_id
8532: and previous_customer_Trx_id = p_app_cust_trx_id;
8533:

Line 8534: update ra_customer_Trx_lines

8530: set previous_customer_Trx_id = NULL
8531: where customer_Trx_id = p_cust_trx_id
8532: and previous_customer_Trx_id = p_app_cust_trx_id;
8533:
8534: update ra_customer_Trx_lines
8535: set previous_customer_Trx_line_id = NULL,
8536: previous_customer_Trx_id = NULL -- Fix for Bug 6726394 (customer_trx_id
8537: where customer_Trx_id = p_cust_trx_id -- value has to be set to null in ra_customer_Trx_lines)
8538: and previous_customer_Trx_id = p_app_cust_trx_id;

Line 8537: where customer_Trx_id = p_cust_trx_id -- value has to be set to null in ra_customer_Trx_lines)

8533:
8534: update ra_customer_Trx_lines
8535: set previous_customer_Trx_line_id = NULL,
8536: previous_customer_Trx_id = NULL -- Fix for Bug 6726394 (customer_trx_id
8537: where customer_Trx_id = p_cust_trx_id -- value has to be set to null in ra_customer_Trx_lines)
8538: and previous_customer_Trx_id = p_app_cust_trx_id;
8539:
8540: SELECT trx_number
8541: INTO l_trx_number

Line 8542: FROM ra_customer_trx

8538: and previous_customer_Trx_id = p_app_cust_trx_id;
8539:
8540: SELECT trx_number
8541: INTO l_trx_number
8542: FROM ra_customer_trx
8543: WHERE customer_Trx_id = p_app_cust_Trx_id;
8544:
8545: FND_MESSAGE.SET_NAME('AR', 'AR_REG_CM_UNAPP_COMMENTS');
8546: FND_MESSAGE.SET_TOKEN('INVOICE_NUMBER', l_trx_number);

Line 8570: FROM ra_customer_trx

8566: SELECT nvl(previous_customer_Trx_id, -999),
8567: nvl(invoicing_rule_id, -999)
8568: INTO l_prev_cust_trx_id,
8569: p_invoicing_rule_id
8570: FROM ra_customer_trx
8571: WHERE customer_trx_id = p_customer_trx_id;
8572:
8573: IF (l_prev_cust_trx_id = -999) THEN
8574: return FALSE;