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 943: l_accounting_affect_flag ar_receivables_trx.accounting_affect_flag%type;

939: /* VAT changes */
940: l_ae_doc_rec ae_doc_rec_type;
941:
942: l_adj_type ar_adjustments.type%type;
943: l_accounting_affect_flag ar_receivables_trx.accounting_affect_flag%type;
944:
945: l_app_ps_status VARCHAR2(10);
946: --BUG#2750340
947: l_xla_ev_rec arp_xla_events.xla_events_type;

Line 1370: FROM ar_receivables_trx

1366: +--------------------------------------------*/
1367:
1368: SELECT NVL(accounting_affect_flag, 'Y')
1369: INTO l_accounting_affect_flag
1370: FROM ar_receivables_trx
1371: WHERE receivables_trx_id = p_adj_rec.receivables_trx_id;
1372:
1373:
1374: --BUG#2750340

Line 1582: l_accounting_affect_flag ar_receivables_trx.accounting_affect_flag%type;

1578: l_status_changed_flag boolean;
1579: l_old_adj_rec ar_adjustments%rowtype;
1580: l_acctd_amount_adjusted ar_adjustments.acctd_amount%type;
1581: l_ae_doc_rec ae_doc_rec_type;
1582: l_accounting_affect_flag ar_receivables_trx.accounting_affect_flag%type;
1583: /* Bug fix 2377672
1584: variables to decide whether the accounting needs to be re-created */
1585: l_recreate_accounting boolean;
1586: l_accounts number;

Line 1852: FROM ar_receivables_trx

1848: --Bug 1277494 Added NVL to selection which was missing
1849: BEGIN
1850: SELECT NVL(accounting_affect_flag,'Y')
1851: INTO l_accounting_affect_flag
1852: FROM ar_receivables_trx
1853: WHERE receivables_trx_id = l_adj_rec.receivables_trx_id;
1854:
1855: EXCEPTION
1856: WHEN OTHERS THEN

Line 2036: l_accounting_affect_flag ar_receivables_trx.accounting_affect_flag%type;

2032: l_approval_action_history_id
2033: ar_approval_action_history.approval_action_history_id%type;
2034: l_old_adj_rec ar_adjustments%rowtype;
2035: l_ae_doc_rec ae_doc_rec_type;
2036: l_accounting_affect_flag ar_receivables_trx.accounting_affect_flag%type;
2037: --BUG#2750340
2038: l_xla_ev_rec arp_xla_events.xla_events_type;
2039:
2040: /* 4544013 */

Line 2262: FROM ar_receivables_trx

2258: +------------------------------------------------------------------+*/
2259: BEGIN
2260: SELECT NVL(accounting_affect_flag,'Y')
2261: INTO l_accounting_affect_flag
2262: FROM ar_receivables_trx
2263: WHERE receivables_trx_id = l_adj_rec.receivables_trx_id;
2264:
2265: EXCEPTION
2266: WHEN OTHERS THEN

Line 2929: | select name from ar_receivables_trx into

2925: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
2926: | 7/30/1996 Harri Kaukovuo Fixed the code to fnd_seqnum, because AOL
2927: | has changed the data type of the date parameter.
2928: | Fixed possible bug cancidate when trying to
2929: | select name from ar_receivables_trx into
2930: | VARCHAR2(30) field. Name is VARCHAR2(50).
2931: | 7/30/1996 Harri Kaukovuo Bug fix 387035
2932: |10/16/1998 Sushama Borde Bug fix 741725: Used AOL API get_next_sequence
2933: | instead of get_seq_name.

Line 2983: FROM ar_receivables_trx rt

2979: -- correct sequence is used for Adjustments
2980:
2981: SELECT rt.name
2982: INTO l_rec_name
2983: FROM ar_receivables_trx rt
2984: WHERE rt.receivables_trx_id = p_adj_rec.receivables_trx_id;
2985:
2986: IF PG_DEBUG in ('Y', 'C') THEN
2987: arp_standard.debug( 'after select in insert_revers_actions in app_delete' );

Line 3273: l_activity_type ar_receivables_trx.type%TYPE;

3269: l_line_remaining number;
3270: l_tax_remaining number;
3271: l_prorated_tax number;
3272: l_invoice_currency_code ar_payment_schedules.invoice_currency_code%TYPE;
3273: l_activity_type ar_receivables_trx.type%TYPE;
3274: l_tax_code_source ar_receivables_trx.tax_code_source%TYPE;
3275: l_asset_tax_code ar_receivables_trx.asset_tax_code%TYPE;
3276: l_sob_id ar_receivables_trx.set_of_books_id%TYPE;
3277: l_tax_rate ar_vat_tax.tax_rate%TYPE;

Line 3274: l_tax_code_source ar_receivables_trx.tax_code_source%TYPE;

3270: l_tax_remaining number;
3271: l_prorated_tax number;
3272: l_invoice_currency_code ar_payment_schedules.invoice_currency_code%TYPE;
3273: l_activity_type ar_receivables_trx.type%TYPE;
3274: l_tax_code_source ar_receivables_trx.tax_code_source%TYPE;
3275: l_asset_tax_code ar_receivables_trx.asset_tax_code%TYPE;
3276: l_sob_id ar_receivables_trx.set_of_books_id%TYPE;
3277: l_tax_rate ar_vat_tax.tax_rate%TYPE;
3278:

Line 3275: l_asset_tax_code ar_receivables_trx.asset_tax_code%TYPE;

3271: l_prorated_tax number;
3272: l_invoice_currency_code ar_payment_schedules.invoice_currency_code%TYPE;
3273: l_activity_type ar_receivables_trx.type%TYPE;
3274: l_tax_code_source ar_receivables_trx.tax_code_source%TYPE;
3275: l_asset_tax_code ar_receivables_trx.asset_tax_code%TYPE;
3276: l_sob_id ar_receivables_trx.set_of_books_id%TYPE;
3277: l_tax_rate ar_vat_tax.tax_rate%TYPE;
3278:
3279: -- Bug 2189230

Line 3276: l_sob_id ar_receivables_trx.set_of_books_id%TYPE;

3272: l_invoice_currency_code ar_payment_schedules.invoice_currency_code%TYPE;
3273: l_activity_type ar_receivables_trx.type%TYPE;
3274: l_tax_code_source ar_receivables_trx.tax_code_source%TYPE;
3275: l_asset_tax_code ar_receivables_trx.asset_tax_code%TYPE;
3276: l_sob_id ar_receivables_trx.set_of_books_id%TYPE;
3277: l_tax_rate ar_vat_tax.tax_rate%TYPE;
3278:
3279: -- Bug 2189230
3280: /* The tax of Adjustment was calculated according to nearest rule everytime */

Line 3319: FROM ar_receivables_trx trx,

3315: INTO l_activity_type,
3316: l_tax_code_source,
3317: l_asset_tax_code,
3318: l_sob_id
3319: FROM ar_receivables_trx trx,
3320: ar_rec_trx_le_details details
3321: WHERE trx.receivables_trx_id = p_receivables_trx_id
3322: and trx.receivables_trx_id = details.receivables_trx_id (+)
3323: and details.legal_entity_id (+) = l_le_id;

Line 3327: FROM ar_receivables_trx

3323: and details.legal_entity_id (+) = l_le_id;
3324: ELSE
3325: SELECT type, tax_code_source, asset_tax_code, set_of_books_id
3326: INTO l_activity_type, l_tax_code_source, l_asset_tax_code, l_sob_id
3327: FROM ar_receivables_trx
3328: WHERE receivables_trx_id = p_receivables_trx_id;
3329: END IF;
3330:
3331: IF l_tax_code_source = 'NONE' THEN