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_ADJUSTMENT dependencies on AR_RECEIVABLES_TRX

Line 545: l_tax_code_source ar_receivables_trx.tax_code_source%TYPE; -- Bug 13882660

541: l_line_credited NUMBER;
542: l_line_applied NUMBER;
543: l_line_tax VARCHAR2(10);
544: l_remain_amt NUMBER;
545: l_tax_code_source ar_receivables_trx.tax_code_source%TYPE; -- Bug 13882660
546:
547:
548: BEGIN
549:

Line 568: FROM ar_receivables_trx

564:
565: IF(p_adj_rec.receivables_trx_id IS NOT NULL) THEN -- Bug 13882660
566: SELECT tax_code_source
567: INTO l_tax_code_source
568: FROM ar_receivables_trx
569: WHERE receivables_trx_id = p_adj_rec.receivables_trx_id;
570: END IF;
571:
572: FOR i IN cu_rem_amt(p_adj_rec.customer_trx_id, p_adj_rec.customer_trx_line_id) LOOP

Line 1165: l_accounting_affect_flag ar_receivables_trx.accounting_affect_flag%type;

1161: /* VAT changes */
1162: l_ae_doc_rec ae_doc_rec_type;
1163:
1164: l_adj_type ar_adjustments.type%type;
1165: l_accounting_affect_flag ar_receivables_trx.accounting_affect_flag%type;
1166:
1167: l_app_ps_status VARCHAR2(10);
1168: --BUG#2750340
1169: l_xla_ev_rec arp_xla_events.xla_events_type;

Line 1186: l_gl_account_source ar_receivables_trx.gl_account_source%type;

1182: v_cont NUMBER;
1183: v_claim_amt varchar2(100);
1184:
1185: l_customer_trx ra_customer_trx%ROWTYPE;
1186: l_gl_account_source ar_receivables_trx.gl_account_source%type;
1187: l_tax_code_source ar_receivables_trx.tax_code_source%type;
1188: BEGIN
1189:
1190: arp_util.debug('ar_process_adjustment.insert_adjustment()+');

Line 1187: l_tax_code_source ar_receivables_trx.tax_code_source%type;

1183: v_claim_amt varchar2(100);
1184:
1185: l_customer_trx ra_customer_trx%ROWTYPE;
1186: l_gl_account_source ar_receivables_trx.gl_account_source%type;
1187: l_tax_code_source ar_receivables_trx.tax_code_source%type;
1188: BEGIN
1189:
1190: arp_util.debug('ar_process_adjustment.insert_adjustment()+');
1191:

Line 1231: from ar_receivables_trx

1227: select nvl(gl_account_source,'NONE'),
1228: nvl(tax_code_source,'NONE')
1229: into l_gl_account_source,
1230: l_tax_code_source
1231: from ar_receivables_trx
1232: where receivables_trx_id = p_adj_rec.receivables_trx_id;
1233:
1234: IF ((l_gl_account_source = 'REVENUE_ON_INVOICE')
1235: AND (((nvl(p_adj_rec.line_adjusted,0) +

Line 1642: FROM ar_receivables_trx

1638: +--------------------------------------------*/
1639:
1640: SELECT NVL(accounting_affect_flag, 'Y')
1641: INTO l_accounting_affect_flag
1642: FROM ar_receivables_trx
1643: WHERE receivables_trx_id = p_adj_rec.receivables_trx_id;
1644:
1645:
1646: --BUG#2750340

Line 1864: l_accounting_affect_flag ar_receivables_trx.accounting_affect_flag%type;

1860: l_status_changed_flag boolean;
1861: l_old_adj_rec ar_adjustments%rowtype;
1862: l_acctd_amount_adjusted ar_adjustments.acctd_amount%type;
1863: l_ae_doc_rec ae_doc_rec_type;
1864: l_accounting_affect_flag ar_receivables_trx.accounting_affect_flag%type;
1865: /* Bug fix 2377672
1866: variables to decide whether the accounting needs to be re-created */
1867: l_recreate_accounting boolean;
1868: l_accounts number;

Line 2055: FROM ar_receivables_trx

2051: --Bug 1277494 Added NVL to selection which was missing
2052: BEGIN
2053: SELECT NVL(accounting_affect_flag,'Y')
2054: INTO l_accounting_affect_flag
2055: FROM ar_receivables_trx
2056: WHERE receivables_trx_id = l_adj_rec.receivables_trx_id;
2057:
2058: EXCEPTION
2059: WHEN OTHERS THEN

Line 2276: FROM ar_receivables_trx

2272: --Bug 1277494 Added NVL to selection which was missing
2273: BEGIN
2274: SELECT NVL(accounting_affect_flag,'Y')
2275: INTO l_accounting_affect_flag
2276: FROM ar_receivables_trx
2277: WHERE receivables_trx_id = l_adj_rec.receivables_trx_id;
2278:
2279: EXCEPTION
2280: WHEN OTHERS THEN

Line 2464: l_accounting_affect_flag ar_receivables_trx.accounting_affect_flag%type;

2460: l_approval_action_history_id
2461: ar_approval_action_history.approval_action_history_id%type;
2462: l_old_adj_rec ar_adjustments%rowtype;
2463: l_ae_doc_rec ae_doc_rec_type;
2464: l_accounting_affect_flag ar_receivables_trx.accounting_affect_flag%type;
2465: --BUG#2750340
2466: l_xla_ev_rec arp_xla_events.xla_events_type;
2467:
2468: /* 4544013 */

Line 2690: FROM ar_receivables_trx

2686: +------------------------------------------------------------------+*/
2687: BEGIN
2688: SELECT NVL(accounting_affect_flag,'Y')
2689: INTO l_accounting_affect_flag
2690: FROM ar_receivables_trx
2691: WHERE receivables_trx_id = l_adj_rec.receivables_trx_id;
2692:
2693: EXCEPTION
2694: WHEN OTHERS THEN

Line 3421: | select name from ar_receivables_trx into

3417: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
3418: | 7/30/1996 Harri Kaukovuo Fixed the code to fnd_seqnum, because AOL
3419: | has changed the data type of the date parameter.
3420: | Fixed possible bug cancidate when trying to
3421: | select name from ar_receivables_trx into
3422: | VARCHAR2(30) field. Name is VARCHAR2(50).
3423: | 7/30/1996 Harri Kaukovuo Bug fix 387035
3424: |10/16/1998 Sushama Borde Bug fix 741725: Used AOL API get_next_sequence
3425: | instead of get_seq_name.

Line 3482: FROM ar_receivables_trx rt

3478: -- correct sequence is used for Adjustments
3479:
3480: SELECT rt.name
3481: INTO l_rec_name
3482: FROM ar_receivables_trx rt
3483: WHERE rt.receivables_trx_id = p_adj_rec.receivables_trx_id;
3484:
3485: IF PG_DEBUG in ('Y', 'C') THEN
3486: arp_standard.debug( 'after select in insert_revers_actions in app_delete' );

Line 3851: l_activity_type ar_receivables_trx.type%TYPE;

3847: l_line_remaining number;
3848: l_tax_remaining number;
3849: l_prorated_tax number;
3850: l_invoice_currency_code ar_payment_schedules.invoice_currency_code%TYPE;
3851: l_activity_type ar_receivables_trx.type%TYPE;
3852: l_tax_code_source ar_receivables_trx.tax_code_source%TYPE;
3853: l_asset_tax_code ar_receivables_trx.asset_tax_code%TYPE;
3854: l_sob_id ar_receivables_trx.set_of_books_id%TYPE;
3855: l_tax_rate ar_vat_tax.tax_rate%TYPE;

Line 3852: l_tax_code_source ar_receivables_trx.tax_code_source%TYPE;

3848: l_tax_remaining number;
3849: l_prorated_tax number;
3850: l_invoice_currency_code ar_payment_schedules.invoice_currency_code%TYPE;
3851: l_activity_type ar_receivables_trx.type%TYPE;
3852: l_tax_code_source ar_receivables_trx.tax_code_source%TYPE;
3853: l_asset_tax_code ar_receivables_trx.asset_tax_code%TYPE;
3854: l_sob_id ar_receivables_trx.set_of_books_id%TYPE;
3855: l_tax_rate ar_vat_tax.tax_rate%TYPE;
3856:

Line 3853: l_asset_tax_code ar_receivables_trx.asset_tax_code%TYPE;

3849: l_prorated_tax number;
3850: l_invoice_currency_code ar_payment_schedules.invoice_currency_code%TYPE;
3851: l_activity_type ar_receivables_trx.type%TYPE;
3852: l_tax_code_source ar_receivables_trx.tax_code_source%TYPE;
3853: l_asset_tax_code ar_receivables_trx.asset_tax_code%TYPE;
3854: l_sob_id ar_receivables_trx.set_of_books_id%TYPE;
3855: l_tax_rate ar_vat_tax.tax_rate%TYPE;
3856:
3857: -- Bug 2189230

Line 3854: l_sob_id ar_receivables_trx.set_of_books_id%TYPE;

3850: l_invoice_currency_code ar_payment_schedules.invoice_currency_code%TYPE;
3851: l_activity_type ar_receivables_trx.type%TYPE;
3852: l_tax_code_source ar_receivables_trx.tax_code_source%TYPE;
3853: l_asset_tax_code ar_receivables_trx.asset_tax_code%TYPE;
3854: l_sob_id ar_receivables_trx.set_of_books_id%TYPE;
3855: l_tax_rate ar_vat_tax.tax_rate%TYPE;
3856:
3857: -- Bug 2189230
3858: /* The tax of Adjustment was calculated according to nearest rule everytime */

Line 3902: FROM ar_receivables_trx trx,

3898: INTO l_activity_type,
3899: l_tax_code_source,
3900: l_asset_tax_code,
3901: l_sob_id
3902: FROM ar_receivables_trx trx,
3903: ar_rec_trx_le_details details
3904: WHERE trx.receivables_trx_id = p_receivables_trx_id
3905: and trx.receivables_trx_id = details.receivables_trx_id (+)
3906: and details.legal_entity_id (+) = l_le_id;

Line 3910: FROM ar_receivables_trx

3906: and details.legal_entity_id (+) = l_le_id;
3907: ELSE
3908: SELECT type, tax_code_source, asset_tax_code, set_of_books_id
3909: INTO l_activity_type, l_tax_code_source, l_asset_tax_code, l_sob_id
3910: FROM ar_receivables_trx
3911: WHERE receivables_trx_id = p_receivables_trx_id;
3912: END IF;
3913:
3914: IF l_tax_code_source = 'NONE' THEN