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_ALLOCATION_PKG dependencies on ARP_ETAX_UTIL

Line 1390: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,

1386: g_ae_sys_rec.base_currency ,
1387: g_cust_inv_rec.exchange_rate,
1388: g_ae_sys_rec.base_precision ,
1389: g_ae_sys_rec.base_min_acc_unit) ae_taxable_acctd_amount,
1390: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1391: gld.gl_date,
1392: 'ADJ') ae_adj_ccid,
1393: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1394: gld.gl_date,

Line 1393: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,

1389: g_ae_sys_rec.base_min_acc_unit) ae_taxable_acctd_amount,
1390: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1391: gld.gl_date,
1392: 'ADJ') ae_adj_ccid,
1393: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1394: gld.gl_date,
1395: 'EDISC') ae_edisc_ccid,
1396: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1397: gld.gl_date,

Line 1396: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,

1392: 'ADJ') ae_adj_ccid,
1393: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1394: gld.gl_date,
1395: 'EDISC') ae_edisc_ccid,
1396: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1397: gld.gl_date,
1398: 'UNEDISC') ae_unedisc_ccid,
1399: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1400: gld.gl_date,

Line 1399: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,

1395: 'EDISC') ae_edisc_ccid,
1396: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1397: gld.gl_date,
1398: 'UNEDISC') ae_unedisc_ccid,
1399: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1400: gld.gl_date,
1401: 'FINCHRG') ae_finchrg_ccid,
1402: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1403: gld.gl_date,

Line 1402: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,

1398: 'UNEDISC') ae_unedisc_ccid,
1399: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1400: gld.gl_date,
1401: 'FINCHRG') ae_finchrg_ccid,
1402: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1403: gld.gl_date,
1404: 'ADJ_NON_REC') ae_adj_non_rec_tax_ccid,
1405: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1406: gld.gl_date,

Line 1405: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,

1401: 'FINCHRG') ae_finchrg_ccid,
1402: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1403: gld.gl_date,
1404: 'ADJ_NON_REC') ae_adj_non_rec_tax_ccid,
1405: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1406: gld.gl_date,
1407: 'EDISC_NON_REC') ae_edisc_non_rec_tax_ccid,
1408: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1409: gld.gl_date,

Line 1408: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,

1404: 'ADJ_NON_REC') ae_adj_non_rec_tax_ccid,
1405: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1406: gld.gl_date,
1407: 'EDISC_NON_REC') ae_edisc_non_rec_tax_ccid,
1408: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1409: gld.gl_date,
1410: 'UNEDISC_NON_REC') ae_unedisc_non_rec_tax_ccid,
1411: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1412: gld.gl_date,

Line 1411: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,

1407: 'EDISC_NON_REC') ae_edisc_non_rec_tax_ccid,
1408: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1409: gld.gl_date,
1410: 'UNEDISC_NON_REC') ae_unedisc_non_rec_tax_ccid,
1411: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1412: gld.gl_date,
1413: 'FINCHRG_NON_REC') ae_finchrg_non_rec_tax_ccid,
1414: decode(g_ae_rule_rec.tax_code_source1,
1415: 'INVOICE', decode(g_ae_rule_rec.tax_recoverable_flag1,

Line 1419: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,

1415: 'INVOICE', decode(g_ae_rule_rec.tax_recoverable_flag1,
1416: 'N',
1417: decode(g_ae_doc_rec.source_table,
1418: 'RA',
1419: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1420: gld.gl_date,
1421: 'EDISC_NON_REC'),
1422: 'ADJ',
1423: decode(g_ae_doc_rec.document_type,

Line 1425: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,

1421: 'EDISC_NON_REC'),
1422: 'ADJ',
1423: decode(g_ae_doc_rec.document_type,
1424: 'ADJUSTMENT',
1425: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1426: gld.gl_date,
1427: 'ADJ_NON_REC'),
1428: 'FINANCE_CHARGES',
1429: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,

Line 1429: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,

1425: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1426: gld.gl_date,
1427: 'ADJ_NON_REC'),
1428: 'FINANCE_CHARGES',
1429: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1430: gld.gl_date,
1431: 'FINCHRG_NON_REC'),
1432: ''),
1433: ''),

Line 1441: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,

1437: decode(g_ae_rule_rec.tax_code_source2,
1438: 'INVOICE',decode(g_ae_rule_rec.tax_recoverable_flag2,
1439: 'N', decode(g_ae_doc_rec.source_table,
1440: 'RA',
1441: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1442: gld.gl_date,
1443: 'UNEDISC_NON_REC'),
1444: ''),
1445: ''),

Line 1620: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,

1616: g_cust_inv_rec.exchange_rate,
1617: g_ae_sys_rec.base_precision ,
1618: g_ae_sys_rec.base_min_acc_unit) ae_taxable_acctd_amount,
1619:
1620: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1621: null,
1622: 'ADJ') ae_adj_ccid,
1623: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1624: null,

Line 1623: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,

1619:
1620: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1621: null,
1622: 'ADJ') ae_adj_ccid,
1623: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1624: null,
1625: 'EDISC') ae_edisc_ccid,
1626: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1627: null,

Line 1626: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,

1622: 'ADJ') ae_adj_ccid,
1623: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1624: null,
1625: 'EDISC') ae_edisc_ccid,
1626: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1627: null,
1628: 'UNEDISC') ae_unedisc_ccid,
1629: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1630: null,

Line 1629: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,

1625: 'EDISC') ae_edisc_ccid,
1626: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1627: null,
1628: 'UNEDISC') ae_unedisc_ccid,
1629: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1630: null,
1631: 'FINCHRG') ae_finchrg_ccid,
1632: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1633: null,

Line 1632: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,

1628: 'UNEDISC') ae_unedisc_ccid,
1629: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1630: null,
1631: 'FINCHRG') ae_finchrg_ccid,
1632: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1633: null,
1634: 'ADJ_NON_REC') ae_adj_non_rec_tax_ccid,
1635: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1636: null,

Line 1635: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,

1631: 'FINCHRG') ae_finchrg_ccid,
1632: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1633: null,
1634: 'ADJ_NON_REC') ae_adj_non_rec_tax_ccid,
1635: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1636: null,
1637: 'EDISC_NON_REC') ae_edisc_non_rec_tax_ccid,
1638: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1639: null,

Line 1638: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,

1634: 'ADJ_NON_REC') ae_adj_non_rec_tax_ccid,
1635: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1636: null,
1637: 'EDISC_NON_REC') ae_edisc_non_rec_tax_ccid,
1638: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1639: null,
1640: 'UNEDISC_NON_REC') ae_unedisc_non_rec_tax_ccid,
1641: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1642: null,

Line 1641: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,

1637: 'EDISC_NON_REC') ae_edisc_non_rec_tax_ccid,
1638: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1639: null,
1640: 'UNEDISC_NON_REC') ae_unedisc_non_rec_tax_ccid,
1641: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1642: null,
1643: 'FINCHRG_NON_REC') ae_finchrg_non_rec_tax_ccid,
1644: decode(g_ae_rule_rec.tax_code_source1,
1645: 'INVOICE', decode(g_ae_rule_rec.tax_recoverable_flag1,

Line 1649: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,

1645: 'INVOICE', decode(g_ae_rule_rec.tax_recoverable_flag1,
1646: 'N',
1647: decode(g_ae_doc_rec.source_table,
1648: 'RA',
1649: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1650: null,
1651: 'EDISC_NON_REC'),
1652: 'ADJ',
1653: decode(g_ae_doc_rec.document_type,

Line 1655: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,

1651: 'EDISC_NON_REC'),
1652: 'ADJ',
1653: decode(g_ae_doc_rec.document_type,
1654: 'ADJUSTMENT',
1655: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1656: null,
1657: 'ADJ_NON_REC'),
1658: 'FINANCE_CHARGES',
1659: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,

Line 1659: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,

1655: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1656: null,
1657: 'ADJ_NON_REC'),
1658: 'FINANCE_CHARGES',
1659: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1660: null,
1661: 'FINCHRG_NON_REC'),
1662: ''),
1663: ''),

Line 1671: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,

1667: decode(g_ae_rule_rec.tax_code_source2,
1668: 'INVOICE',decode(g_ae_rule_rec.tax_recoverable_flag2,
1669: 'N', decode(g_ae_doc_rec.source_table,
1670: 'RA',
1671: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1672: null,
1673: 'UNEDISC_NON_REC'),
1674: ''),
1675: ''),

Line 2067: 'RA', arp_etax_util.get_tax_account(ctl.customer_trx_line_id,

2063: select ctl.link_to_cust_trx_line_id ae_link_to_cust_trx_line_id,
2064: max(decode(g_ae_rule_rec.gl_account_source1,
2065: 'TAX_CODE_ON_INVOICE',
2066: decode(g_ae_doc_rec.source_table,
2067: 'RA', arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
2068: gld.gl_date,
2069: 'EDISC'),
2070: 'ADJ',decode(g_ae_doc_rec.document_type,
2071: 'ADJUSTMENT',

Line 2072: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,

2068: gld.gl_date,
2069: 'EDISC'),
2070: 'ADJ',decode(g_ae_doc_rec.document_type,
2071: 'ADJUSTMENT',
2072: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
2073: gld.gl_date,
2074: 'ADJ'),
2075: 'FINANCE_CHARGES',
2076: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,

Line 2076: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,

2072: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
2073: gld.gl_date,
2074: 'ADJ'),
2075: 'FINANCE_CHARGES',
2076: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
2077: gld.gl_date,
2078: 'FINCHRG'),
2079: ''),
2080: ''),

Line 2085: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,

2081: '')) override_ccid1,
2082: max(decode(g_ae_rule_rec.gl_account_source2,
2083: 'TAX_CODE_ON_INVOICE', decode(g_ae_doc_rec.source_table,
2084: 'RA',
2085: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
2086: gld.gl_date,
2087: 'UNEDISC'),
2088: ''),
2089: '')) override_ccid2

Line 2350: 'RA', arp_etax_util.get_tax_account(ctl.customer_trx_line_id,

2346: select ctl.link_to_cust_trx_line_id ae_link_to_cust_trx_line_id,
2347: max(decode(g_ae_rule_rec.gl_account_source1,
2348: 'TAX_CODE_ON_INVOICE',
2349: decode(g_ae_doc_rec.source_table,
2350: 'RA', arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
2351: gld.gl_date,
2352: 'EDISC'),
2353: 'ADJ',decode(g_ae_doc_rec.document_type,
2354: 'ADJUSTMENT',

Line 2355: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,

2351: gld.gl_date,
2352: 'EDISC'),
2353: 'ADJ',decode(g_ae_doc_rec.document_type,
2354: 'ADJUSTMENT',
2355: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
2356: gld.gl_date,
2357: 'ADJ'),
2358: 'FINANCE_CHARGES',
2359: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,

Line 2359: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,

2355: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
2356: gld.gl_date,
2357: 'ADJ'),
2358: 'FINANCE_CHARGES',
2359: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
2360: gld.gl_date,
2361: 'FINCHRG'),
2362: ''),
2363: ''),

Line 2368: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,

2364: '')) override_ccid1,
2365: max(decode(g_ae_rule_rec.gl_account_source2,
2366: 'TAX_CODE_ON_INVOICE', decode(g_ae_doc_rec.source_table,
2367: 'RA',
2368: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
2369: gld.gl_date,
2370: 'UNEDISC'),
2371: ''),
2372: '')) override_ccid2

Line 9380: SELECT arp_etax_util.get_tax_account(tax.tax_rate_id,

9376: p_receivables_trx_id IN NUMBER)
9377: RETURN NUMBER
9378: IS
9379: CURSOR c1 IS
9380: SELECT arp_etax_util.get_tax_account(tax.tax_rate_id,
9381: null,
9382: 'ADJ',
9383: 'TAX_RATE'),
9384: arp_etax_util.get_tax_account(tax.tax_rate_id,

Line 9384: arp_etax_util.get_tax_account(tax.tax_rate_id,

9380: SELECT arp_etax_util.get_tax_account(tax.tax_rate_id,
9381: null,
9382: 'ADJ',
9383: 'TAX_RATE'),
9384: arp_etax_util.get_tax_account(tax.tax_rate_id,
9385: null,
9386: 'ADJ_NON_REC',
9387: 'TAX_RATE'),
9388: rt.tax_recoverable_flag

Line 9397: SELECT arp_etax_util.get_tax_account(tax.tax_rate_id,

9393: AND sysdate between nvl(tax.effective_from, sysdate) AND
9394: nvl(tax.effective_to, sysdate);
9395:
9396: CURSOR c1_le(p_legal_entity_id NUMBER) IS
9397: SELECT arp_etax_util.get_tax_account(tax.tax_rate_id,
9398: null,
9399: 'ADJ',
9400: 'TAX_RATE'),
9401: arp_etax_util.get_tax_account(tax.tax_rate_id,

Line 9401: arp_etax_util.get_tax_account(tax.tax_rate_id,

9397: SELECT arp_etax_util.get_tax_account(tax.tax_rate_id,
9398: null,
9399: 'ADJ',
9400: 'TAX_RATE'),
9401: arp_etax_util.get_tax_account(tax.tax_rate_id,
9402: null,
9403: 'ADJ_NON_REC',
9404: 'TAX_RATE'),
9405: rt.tax_recoverable_flag

Line 9418: SELECT arp_etax_util.get_tax_account(tl.customer_trx_line_id,

9414: AND trunc(sysdate) between nvl(tax.effective_from, trunc(sysdate)) AND
9415: nvl(tax.effective_to, trunc(sysdate));
9416:
9417: CURSOR c2 IS
9418: SELECT arp_etax_util.get_tax_account(tl.customer_trx_line_id,
9419: trunc(sysdate),
9420: 'ADJ',
9421: 'TAX_LINE'),
9422: arp_etax_util.get_tax_account(tl.customer_trx_line_id,

Line 9422: arp_etax_util.get_tax_account(tl.customer_trx_line_id,

9418: SELECT arp_etax_util.get_tax_account(tl.customer_trx_line_id,
9419: trunc(sysdate),
9420: 'ADJ',
9421: 'TAX_LINE'),
9422: arp_etax_util.get_tax_account(tl.customer_trx_line_id,
9423: trunc(sysdate),
9424: 'FINCHRG',
9425: 'TAX_LINE')
9426: FROM ra_customer_trx_lines tl