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 2382: l_ct_id ra_customer_trx.customer_trx_id%TYPE;

2378: p_module_name IN VARCHAR2,
2379: p_module_version IN VARCHAR2 ) RETURN BOOLEAN IS
2380: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
2381: l_ass_cr_id ar_adjustments.associated_cash_receipt_id%TYPE;
2382: l_ct_id ra_customer_trx.customer_trx_id%TYPE;
2383: l_adj_amt NUMBER;
2384: l_pend_amt NUMBER;
2385: l_pmt NUMBER;
2386: l_edisc NUMBER;

Line 2984: UPDATE ra_customer_trx

2980: arp_debug.debug(
2981: 'after ar_adjustment.reverse_adjustment in app_delete' );
2982: END IF;
2983: --
2984: UPDATE ra_customer_trx
2985: SET status_trx = 'CL'
2986: WHERE customer_trx_id = l_adj_rec.chargeback_customer_trx_id;
2987: IF PG_DEBUG in ('Y', 'C') THEN
2988: arp_debug.debug( 'after UPDATE in app_delete ' );

Line 3367: l_exchange_rate_type ra_customer_trx.exchange_rate_type%TYPE;

3363:
3364: l_old_ps_rec ar_payment_schedules%ROWTYPE; /* jrautiai BR implementation */
3365: l_new_ps_rec ar_payment_schedules%ROWTYPE; /* jrautiai BR implementation */
3366: l_source_type ar_distributions.source_type%TYPE; /* jrautiai BR implementation */
3367: l_exchange_rate_type ra_customer_trx.exchange_rate_type%TYPE;
3368: l_exchange_rate_date ra_customer_trx.exchange_date%TYPE;
3369: l_exchange_rate ra_customer_trx.exchange_rate%TYPE;
3370: l_trx_number ra_customer_trx.trx_number%TYPE;
3371: l_cust_trx_type_id ra_customer_trx.cust_trx_type_id%TYPE;

Line 3368: l_exchange_rate_date ra_customer_trx.exchange_date%TYPE;

3364: l_old_ps_rec ar_payment_schedules%ROWTYPE; /* jrautiai BR implementation */
3365: l_new_ps_rec ar_payment_schedules%ROWTYPE; /* jrautiai BR implementation */
3366: l_source_type ar_distributions.source_type%TYPE; /* jrautiai BR implementation */
3367: l_exchange_rate_type ra_customer_trx.exchange_rate_type%TYPE;
3368: l_exchange_rate_date ra_customer_trx.exchange_date%TYPE;
3369: l_exchange_rate ra_customer_trx.exchange_rate%TYPE;
3370: l_trx_number ra_customer_trx.trx_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;

Line 3369: l_exchange_rate ra_customer_trx.exchange_rate%TYPE;

3365: l_new_ps_rec ar_payment_schedules%ROWTYPE; /* jrautiai BR implementation */
3366: l_source_type ar_distributions.source_type%TYPE; /* jrautiai BR implementation */
3367: l_exchange_rate_type ra_customer_trx.exchange_rate_type%TYPE;
3368: l_exchange_rate_date ra_customer_trx.exchange_date%TYPE;
3369: l_exchange_rate ra_customer_trx.exchange_rate%TYPE;
3370: l_trx_number ra_customer_trx.trx_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;

Line 3370: l_trx_number ra_customer_trx.trx_number%TYPE;

3366: l_source_type ar_distributions.source_type%TYPE; /* jrautiai BR implementation */
3367: l_exchange_rate_type ra_customer_trx.exchange_rate_type%TYPE;
3368: l_exchange_rate_date ra_customer_trx.exchange_date%TYPE;
3369: l_exchange_rate ra_customer_trx.exchange_rate%TYPE;
3370: l_trx_number ra_customer_trx.trx_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;

Line 3371: l_cust_trx_type_id ra_customer_trx.cust_trx_type_id%TYPE;

3367: l_exchange_rate_type ra_customer_trx.exchange_rate_type%TYPE;
3368: l_exchange_rate_date ra_customer_trx.exchange_date%TYPE;
3369: l_exchange_rate ra_customer_trx.exchange_rate%TYPE;
3370: l_trx_number ra_customer_trx.trx_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;

Line 3372: l_customer_id ra_customer_trx.bill_to_customer_id%TYPE;

3368: l_exchange_rate_date ra_customer_trx.exchange_date%TYPE;
3369: l_exchange_rate ra_customer_trx.exchange_rate%TYPE;
3370: l_trx_number ra_customer_trx.trx_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;

Line 3373: l_bill_to_site_use_id ra_customer_trx.bill_to_site_use_id%TYPE;

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

Line 3374: l_ship_to_site_use_id ra_customer_trx.ship_to_site_use_id%TYPE;

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

Line 3378: l_salesrep_id ra_customer_trx.primary_salesrep_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;
3380: l_claim_id NUMBER;
3381: l_claim_reason_code_id NUMBER;
3382: l_claim_reason_name VARCHAR2(80);

Line 3409: FROM ra_customer_trx t

3405: , t.bill_to_site_use_id
3406: , t.ship_to_site_use_id
3407: , t.primary_salesrep_id
3408: , t.legal_entity_id
3409: FROM ra_customer_trx t
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

Line 5005: FROM RA_CUSTOMER_TRX

5001: arp_acct_main.Create_Acct_Entry(l_ae_doc_rec);
5002:
5003: SELECT NVL(UPGRADE_METHOD,'NONE')
5004: INTO l_upgrade_flag
5005: FROM RA_CUSTOMER_TRX
5006: WHERE CUSTOMER_TRX_ID=l_inv_ra_rec.customer_trx_id;
5007:
5008: IF l_upgrade_flag = 'R12_MERGE' THEN
5009: arp_ps_util.update_cm_related_columns(

Line 5851: l_invoice_currency_code ra_customer_trx.invoice_currency_code%TYPE;

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

Line 5853: l_exchange_rate ra_customer_trx.exchange_rate%TYPE;

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

Line 6180: FROM ra_customer_trx

6176: SELECT invoice_currency_code,
6177: exchange_rate
6178: INTO l_invoice_currency_code,
6179: l_exchange_rate
6180: FROM ra_customer_trx
6181: WHERE customer_trx_id = p_application_ref_id;
6182:
6183: l_ra_rec.acctd_amount_applied_to :=
6184: ARPCURR.functional_amount(

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

6655: FROM ar_payment_schedules ps
6656: WHERE ps.payment_schedule_id = p_invoice_ps_id;
6657:
6658: /* Cursor to fetch normal transaction CCID, the old functionality */
6659: CURSOR trx_dist_cur(l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE) IS
6660: SELECT dist.code_combination_id
6661: FROM ra_cust_trx_line_gl_dist dist
6662: WHERE dist.customer_trx_id = l_customer_trx_id
6663: AND dist.account_class = 'REC'

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

6681: and (nvl(dist.AMOUNT_DR,0) = 0) and (nvl(dist.ACCTD_AMOUNT_DR,0) = 0)))
6682: order by dist.line_id desc;
6683:
6684: /* Cursor to fetch current BR transaction history record */
6685: CURSOR br_current_trh_cur(p_customer_trx_id ra_customer_trx.customer_trx_id%TYPE) IS
6686: SELECT trh.transaction_history_id, trh.postable_flag, trh.event
6687: FROM ar_transaction_history trh
6688: WHERE trh.customer_trx_id = p_customer_trx_id
6689: AND trh.current_accounted_flag = 'Y';

Line 9058: l_trx_number ra_customer_trx.trx_number%TYPE;

9054: +===========================================================================*/
9055: PROCEDURE Unassociate_Regular_CM ( p_cust_Trx_id IN NUMBER,
9056: p_app_cust_trx_id IN NUMBER) IS
9057:
9058: l_trx_number ra_customer_trx.trx_number%TYPE;
9059: l_message_text VARCHAR2(2000);
9060: l_cnt NUMBER;
9061:
9062: x_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 9084: from ra_customer_trx_lines

9080: arp_debug.debug('Updating CM ard to stamp ref_prev_cust_trx_line_id');
9081:
9082: update ar_distributions ard
9083: set ref_prev_cust_trx_line_id = (select previous_customer_trx_line_id
9084: from ra_customer_trx_lines
9085: where customer_trx_line_id = ard.ref_customer_trx_line_id)
9086: where source_id = rec.source_id
9087: and source_table = 'RA'
9088: and ref_customer_trx_line_id in (select customer_trx_line_id

Line 9089: from ra_customer_trx_lines ctl_cm,

9085: where customer_trx_line_id = ard.ref_customer_trx_line_id)
9086: where source_id = rec.source_id
9087: and source_table = 'RA'
9088: and ref_customer_trx_line_id in (select customer_trx_line_id
9089: from ra_customer_trx_lines ctl_cm,
9090: ar_receivable_applications ra
9091: where ra.receivable_application_id = rec.source_id
9092: and ra.customer_trx_id = ctl_cm.customer_trx_id
9093: and ctl_cm.previous_customer_trx_line_id is not null);

Line 9092: and ra.customer_trx_id = ctl_cm.customer_trx_id

9088: and ref_customer_trx_line_id in (select customer_trx_line_id
9089: from ra_customer_trx_lines ctl_cm,
9090: ar_receivable_applications ra
9091: where ra.receivable_application_id = rec.source_id
9092: and ra.customer_trx_id = ctl_cm.customer_trx_id
9093: and ctl_cm.previous_customer_trx_line_id is not null);
9094:
9095: l_cnt := sql%rowcount;
9096:

Line 9110: from ra_customer_trx_lines ctl_inv,

9106: and ref_prev_cust_trx_line_id = ard.ref_customer_trx_line_id
9107: and rownum = 1)
9108: where source_id = rec.source_id
9109: and ref_customer_trx_line_id in (select customer_trx_line_id
9110: from ra_customer_trx_lines ctl_inv,
9111: ar_receivable_applications ra
9112: where ra.receivable_application_id = rec.source_id
9113: and ra.applied_customer_trx_id = ctl_inv.customer_trx_id);
9114: l_cnt := sql%rowcount;

Line 9124: Update ra_customer_Trx

9120:
9121: -- since we are unapplying the regular cm, we need to null out the
9122: -- previous_customer_trx_id and previous_customer_trx_line_id
9123:
9124: Update ra_customer_Trx
9125: set previous_customer_Trx_id = NULL
9126: where customer_Trx_id = p_cust_trx_id
9127: and previous_customer_Trx_id = p_app_cust_trx_id;
9128:

Line 9129: update ra_customer_Trx_lines

9125: set previous_customer_Trx_id = NULL
9126: where customer_Trx_id = p_cust_trx_id
9127: and previous_customer_Trx_id = p_app_cust_trx_id;
9128:
9129: update ra_customer_Trx_lines
9130: set previous_customer_Trx_line_id = NULL,
9131: previous_customer_Trx_id = NULL -- Fix for Bug 6726394 (customer_trx_id
9132: where customer_Trx_id = p_cust_trx_id -- value has to be set to null in ra_customer_Trx_lines)
9133: and previous_customer_Trx_id = p_app_cust_trx_id;

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

9128:
9129: update ra_customer_Trx_lines
9130: set previous_customer_Trx_line_id = NULL,
9131: previous_customer_Trx_id = NULL -- Fix for Bug 6726394 (customer_trx_id
9132: where customer_Trx_id = p_cust_trx_id -- value has to be set to null in ra_customer_Trx_lines)
9133: and previous_customer_Trx_id = p_app_cust_trx_id;
9134:
9135: /* Bug 9928392 - Remove association to invoice tax in etax tables */
9136: BEGIN

Line 9177: FROM ra_customer_trx

9173: /* end 9928392 */
9174:
9175: SELECT trx_number
9176: INTO l_trx_number
9177: FROM ra_customer_trx
9178: WHERE customer_Trx_id = p_app_cust_Trx_id;
9179:
9180: FND_MESSAGE.SET_NAME('AR', 'AR_REG_CM_UNAPP_COMMENTS');
9181: FND_MESSAGE.SET_TOKEN('INVOICE_NUMBER', l_trx_number);

Line 9205: FROM ra_customer_trx

9201: SELECT nvl(previous_customer_Trx_id, -999),
9202: nvl(invoicing_rule_id, -999)
9203: INTO l_prev_cust_trx_id,
9204: p_invoicing_rule_id
9205: FROM ra_customer_trx
9206: WHERE customer_trx_id = p_customer_trx_id;
9207:
9208: IF (l_prev_cust_trx_id = -999) THEN
9209: return FALSE;

Line 9220: FROM ra_customer_trx trx,

9216: p_inv_cust_trx_id IN NUMBER) IS
9217:
9218: cursor c_dep_exists is
9219: SELECT trx.initial_customer_trx_id
9220: FROM ra_customer_trx trx,
9221: ar_adjustments adj
9222: WHERE trx.customer_trx_id = p_cm_cust_trx_id
9223: AND adj.customer_trx_id = p_inv_cust_trx_id
9224: AND adj.subsequent_trx_id = p_cm_cust_trx_id; --Bug 14376534

Line 9231: ra_customer_trx ra

9227: p_cm_customer_trx_id number,
9228: p_initial_customer_trx_id number) is
9229: select adj.adjustment_id
9230: from ar_adjustments_all adj,
9231: ra_customer_trx ra
9232: where adj.customer_trx_id = p_inv_customer_trx_id
9233: and adj.subsequent_trx_id = p_cm_customer_trx_id
9234: and ra.initial_customer_trx_id = p_initial_customer_trx_id
9235: and adj.customer_trx_id = ra.customer_trx_id;

Line 9235: and adj.customer_trx_id = ra.customer_trx_id;

9231: ra_customer_trx ra
9232: where adj.customer_trx_id = p_inv_customer_trx_id
9233: and adj.subsequent_trx_id = p_cm_customer_trx_id
9234: and ra.initial_customer_trx_id = p_initial_customer_trx_id
9235: and adj.customer_trx_id = ra.customer_trx_id;
9236:
9237: l_initial_customer_trx_id number;
9238: l_adjustment_id number;
9239: l_adj_rec ar_adjustments%ROWTYPE;

Line 9307: Update ra_customer_Trx

9303: l_app_rec.ps_id := l_adj_rec.payment_schedule_id;
9304:
9305: arp_ps_util.update_reverse_actions( l_app_rec, NULL, NULL );
9306:
9307: Update ra_customer_Trx
9308: set initial_customer_trx_id = NULL
9309: where customer_Trx_id = p_cm_cust_trx_id
9310: and initial_customer_trx_id = l_initial_customer_trx_id;
9311: