DBA Data[Home] [Help]

APPS.ARP_ALLOCATION_PKG dependencies on ARP_ETAX_UTIL

Line 1321: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,

1317: g_ae_sys_rec.base_currency ,
1318: g_cust_inv_rec.exchange_rate,
1319: g_ae_sys_rec.base_precision ,
1320: g_ae_sys_rec.base_min_acc_unit) ae_taxable_acctd_amount,
1321: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1322: gld.gl_date,
1323: 'ADJ') ae_adj_ccid,
1324: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1325: gld.gl_date,

Line 1324: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,

1320: g_ae_sys_rec.base_min_acc_unit) ae_taxable_acctd_amount,
1321: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1322: gld.gl_date,
1323: 'ADJ') ae_adj_ccid,
1324: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1325: gld.gl_date,
1326: 'EDISC') ae_edisc_ccid,
1327: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1328: gld.gl_date,

Line 1327: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,

1323: 'ADJ') ae_adj_ccid,
1324: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1325: gld.gl_date,
1326: 'EDISC') ae_edisc_ccid,
1327: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1328: gld.gl_date,
1329: 'UNEDISC') ae_unedisc_ccid,
1330: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1331: gld.gl_date,

Line 1330: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,

1326: 'EDISC') ae_edisc_ccid,
1327: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1328: gld.gl_date,
1329: 'UNEDISC') ae_unedisc_ccid,
1330: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1331: gld.gl_date,
1332: 'FINCHRG') ae_finchrg_ccid,
1333: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1334: gld.gl_date,

Line 1333: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,

1329: 'UNEDISC') ae_unedisc_ccid,
1330: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1331: gld.gl_date,
1332: 'FINCHRG') ae_finchrg_ccid,
1333: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1334: gld.gl_date,
1335: 'ADJ_NON_REC') ae_adj_non_rec_tax_ccid,
1336: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1337: gld.gl_date,

Line 1336: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,

1332: 'FINCHRG') ae_finchrg_ccid,
1333: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1334: gld.gl_date,
1335: 'ADJ_NON_REC') ae_adj_non_rec_tax_ccid,
1336: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1337: gld.gl_date,
1338: 'EDISC_NON_REC') ae_edisc_non_rec_tax_ccid,
1339: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1340: gld.gl_date,

Line 1339: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,

1335: 'ADJ_NON_REC') ae_adj_non_rec_tax_ccid,
1336: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1337: gld.gl_date,
1338: 'EDISC_NON_REC') ae_edisc_non_rec_tax_ccid,
1339: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1340: gld.gl_date,
1341: 'UNEDISC_NON_REC') ae_unedisc_non_rec_tax_ccid,
1342: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1343: gld.gl_date,

Line 1342: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,

1338: 'EDISC_NON_REC') ae_edisc_non_rec_tax_ccid,
1339: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1340: gld.gl_date,
1341: 'UNEDISC_NON_REC') ae_unedisc_non_rec_tax_ccid,
1342: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1343: gld.gl_date,
1344: 'FINCHRG_NON_REC') ae_finchrg_non_rec_tax_ccid,
1345: decode(g_ae_rule_rec.tax_code_source1,
1346: 'INVOICE', decode(g_ae_rule_rec.tax_recoverable_flag1,

Line 1350: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,

1346: 'INVOICE', decode(g_ae_rule_rec.tax_recoverable_flag1,
1347: 'N',
1348: decode(g_ae_doc_rec.source_table,
1349: 'RA',
1350: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1351: gld.gl_date,
1352: 'EDISC_NON_REC'),
1353: 'ADJ',
1354: decode(g_ae_doc_rec.document_type,

Line 1356: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,

1352: 'EDISC_NON_REC'),
1353: 'ADJ',
1354: decode(g_ae_doc_rec.document_type,
1355: 'ADJUSTMENT',
1356: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1357: gld.gl_date,
1358: 'ADJ_NON_REC'),
1359: 'FINANCE_CHARGES',
1360: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,

Line 1360: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,

1356: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1357: gld.gl_date,
1358: 'ADJ_NON_REC'),
1359: 'FINANCE_CHARGES',
1360: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1361: gld.gl_date,
1362: 'FINCHRG_NON_REC'),
1363: ''),
1364: ''),

Line 1372: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,

1368: decode(g_ae_rule_rec.tax_code_source2,
1369: 'INVOICE',decode(g_ae_rule_rec.tax_recoverable_flag2,
1370: 'N', decode(g_ae_doc_rec.source_table,
1371: 'RA',
1372: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1373: gld.gl_date,
1374: 'UNEDISC_NON_REC'),
1375: ''),
1376: ''),

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

1904: select ctl.link_to_cust_trx_line_id ae_link_to_cust_trx_line_id,
1905: max(decode(g_ae_rule_rec.gl_account_source1,
1906: 'TAX_CODE_ON_INVOICE',
1907: decode(g_ae_doc_rec.source_table,
1908: 'RA', arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1909: gld.gl_date,
1910: 'EDISC'),
1911: 'ADJ',decode(g_ae_doc_rec.document_type,
1912: 'ADJUSTMENT',

Line 1913: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,

1909: gld.gl_date,
1910: 'EDISC'),
1911: 'ADJ',decode(g_ae_doc_rec.document_type,
1912: 'ADJUSTMENT',
1913: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1914: gld.gl_date,
1915: 'ADJ'),
1916: 'FINANCE_CHARGES',
1917: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,

Line 1917: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,

1913: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1914: gld.gl_date,
1915: 'ADJ'),
1916: 'FINANCE_CHARGES',
1917: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1918: gld.gl_date,
1919: 'FINCHRG'),
1920: ''),
1921: ''),

Line 1926: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,

1922: '')) override_ccid1,
1923: max(decode(g_ae_rule_rec.gl_account_source2,
1924: 'TAX_CODE_ON_INVOICE', decode(g_ae_doc_rec.source_table,
1925: 'RA',
1926: arp_etax_util.get_tax_account(ctl.customer_trx_line_id,
1927: gld.gl_date,
1928: 'UNEDISC'),
1929: ''),
1930: '')) override_ccid2

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

8886: p_receivables_trx_id IN NUMBER)
8887: RETURN NUMBER
8888: IS
8889: CURSOR c1 IS
8890: SELECT arp_etax_util.get_tax_account(tax.tax_rate_id,
8891: null,
8892: 'ADJ',
8893: 'TAX_RATE'),
8894: arp_etax_util.get_tax_account(tax.tax_rate_id,

Line 8894: arp_etax_util.get_tax_account(tax.tax_rate_id,

8890: SELECT arp_etax_util.get_tax_account(tax.tax_rate_id,
8891: null,
8892: 'ADJ',
8893: 'TAX_RATE'),
8894: arp_etax_util.get_tax_account(tax.tax_rate_id,
8895: null,
8896: 'ADJ_NON_REC',
8897: 'TAX_RATE'),
8898: rt.tax_recoverable_flag

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

8903: AND sysdate between nvl(tax.effective_from, sysdate) AND
8904: nvl(tax.effective_to, sysdate);
8905:
8906: CURSOR c1_le(p_legal_entity_id NUMBER) IS
8907: SELECT arp_etax_util.get_tax_account(tax.tax_rate_id,
8908: null,
8909: 'ADJ',
8910: 'TAX_RATE'),
8911: arp_etax_util.get_tax_account(tax.tax_rate_id,

Line 8911: arp_etax_util.get_tax_account(tax.tax_rate_id,

8907: SELECT arp_etax_util.get_tax_account(tax.tax_rate_id,
8908: null,
8909: 'ADJ',
8910: 'TAX_RATE'),
8911: arp_etax_util.get_tax_account(tax.tax_rate_id,
8912: null,
8913: 'ADJ_NON_REC',
8914: 'TAX_RATE'),
8915: rt.tax_recoverable_flag

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

8924: AND trunc(sysdate) between nvl(tax.effective_from, trunc(sysdate)) AND
8925: nvl(tax.effective_to, trunc(sysdate));
8926:
8927: CURSOR c2 IS
8928: SELECT arp_etax_util.get_tax_account(tl.customer_trx_line_id,
8929: trunc(sysdate),
8930: 'ADJ',
8931: 'TAX_LINE'),
8932: arp_etax_util.get_tax_account(tl.customer_trx_line_id,

Line 8932: arp_etax_util.get_tax_account(tl.customer_trx_line_id,

8928: SELECT arp_etax_util.get_tax_account(tl.customer_trx_line_id,
8929: trunc(sysdate),
8930: 'ADJ',
8931: 'TAX_LINE'),
8932: arp_etax_util.get_tax_account(tl.customer_trx_line_id,
8933: trunc(sysdate),
8934: 'FINCHRG',
8935: 'TAX_LINE')
8936: FROM ra_customer_trx_lines tl