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.ZX_VTX_USER_PKG dependencies on ARP_TAX_VIEW_VERTEX

Line 1263: call the ARP_TAX_VIEW_VERTEX.GET_EXEMPTIONS in order to populate the exemption records table

1259: The overall logic here is like this:
1260: Initially populate the exemption id into a nested table at the same index .Meaning if a exemption
1261: id of 2000 gets derived for a state level tax then for the exemptions nested table store this
1262: value of 2000 at the 2000th location in the table.Also use the derived exemption id to
1263: call the ARP_TAX_VIEW_VERTEX.GET_EXEMPTIONS in order to populate the exemption records table
1264: at the same location ie 2000.
1265:
1266: ****NOTE**** Here p_position is the position in the linear table (in the main loop)
1267: into which the derived values are ultimately getting inserted .

Line 1271: ARP_TAX_VIEW_VERTEX.GET_EXEMPTIONS(

1267: into which the derived values are ultimately getting inserted .
1268: */
1269: IF NOT exemptions_info_tab.EXISTS(NVL(x_exempt_record.exemption_id, -99)) THEN
1270: IF x_exempt_record.exemption_id IS NOT NULL THEN
1271: ARP_TAX_VIEW_VERTEX.GET_EXEMPTIONS(
1272: X_EXEMPT_RECORD.EXEMPTION_ID, --This is the input parameter for this call
1273: exemptions_info_tab(x_exempt_record.exemption_id).certificate_number,
1274: exemptions_info_tab(x_exempt_record.exemption_id).state_exempt_pct,
1275: exemptions_info_tab(x_exempt_record.exemption_id).state_exempt_reason,

Line 1664: arp_trx_line_type_tab(i):= ARP_TAX_VIEW_VERTEX.TRX_LINE_TYPE

1660: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1661: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
1662: END IF;
1663:
1664: arp_trx_line_type_tab(i):= ARP_TAX_VIEW_VERTEX.TRX_LINE_TYPE
1665: (l_view_name,
1666: trx_id_tab(i),
1667: trx_line_id_tab(i)) ;
1668: IF (arp_trx_line_type_tab(i) is NULL) THEN

Line 1690: arp_audit_flag_tab(i) := ARP_TAX_VIEW_VERTEX.AUDIT_FLAG

1686: END IF;
1687:
1688: IF l_view_name = 'TAX_ADJUSTMENTS_V_V' THEN
1689: BEGIN
1690: arp_audit_flag_tab(i) := ARP_TAX_VIEW_VERTEX.AUDIT_FLAG
1691: (l_view_name,
1692: trx_id_tab(i),
1693: trx_line_id_tab(i));
1694: EXCEPTION WHEN OTHERS THEN

Line 1751: arp_product_code_tab(i) := ARP_TAX_VIEW_VERTEX.PRODUCT_CODE(l_view_name

1747: l_memo_line_id := product_id_tab(i);
1748: END IF;
1749:
1750: BEGIN
1751: arp_product_code_tab(i) := ARP_TAX_VIEW_VERTEX.PRODUCT_CODE(l_view_name
1752: , trx_id_tab(i)
1753: , trx_line_id_tab(i)
1754: , l_product_id
1755: , l_memo_line_id);

Line 1845: arp_ship_to_add_tab(i) := ARP_TAX_VIEW_VERTEX.SHIP_TO_ADDRESS_CODE

1841: END IF;
1842:
1843: BEGIN --bug6523242
1844: IF ship_to_loc_id_tab(i) IS NULL THEN
1845: arp_ship_to_add_tab(i) := ARP_TAX_VIEW_VERTEX.SHIP_TO_ADDRESS_CODE
1846: (l_view_name,
1847: trx_id_tab(i),
1848: trx_line_id_tab(i),
1849: ship_to_address_id_tab(i),

Line 1856: arp_ship_to_add_tab(i) := ARP_TAX_VIEW_VERTEX.SHIP_TO_ADDRESS_CODE

1852: NULL,--p_ship_to_state
1853: NULL--p_postal_code
1854: );
1855: ELSE
1856: arp_ship_to_add_tab(i) := ARP_TAX_VIEW_VERTEX.SHIP_TO_ADDRESS_CODE
1857: (l_view_name,
1858: trx_id_tab(i),
1859: trx_line_id_tab(i),
1860: ship_to_address_id_tab(i),

Line 2016: arp_ship_from_add_tab(i) := ARP_TAX_VIEW_VERTEX.SHIP_FROM_ADDRESS_CODE

2012: EXCEPTION WHEN NO_DATA_FOUND THEN
2013: l_ship_from_party_id := NULL;
2014: END;
2015:
2016: arp_ship_from_add_tab(i) := ARP_TAX_VIEW_VERTEX.SHIP_FROM_ADDRESS_CODE
2017: (l_view_name,
2018: trx_id_tab(i),
2019: trx_line_id_tab(i),
2020: l_ship_from_party_id);

Line 2081: arp_ship_from_add_tab(i):= arp_tax_view_vertex.USE_SHIP_TO;

2077: END IF;
2078: END IF;
2079:
2080: IF l_sfr_geocode IS NULL THEN
2081: arp_ship_from_add_tab(i):= arp_tax_view_vertex.USE_SHIP_TO;
2082: ELSE
2083: IF NOT Check_Geocode(l_sfr_geocode) THEN
2084: arp_ship_from_add_tab(i):=ARP_TAX_VIEW_VERTEX.USE_SHIP_TO;
2085: ELSE

Line 2084: arp_ship_from_add_tab(i):=ARP_TAX_VIEW_VERTEX.USE_SHIP_TO;

2080: IF l_sfr_geocode IS NULL THEN
2081: arp_ship_from_add_tab(i):= arp_tax_view_vertex.USE_SHIP_TO;
2082: ELSE
2083: IF NOT Check_Geocode(l_sfr_geocode) THEN
2084: arp_ship_from_add_tab(i):=ARP_TAX_VIEW_VERTEX.USE_SHIP_TO;
2085: ELSE
2086: IF l_sfr_in_out_flag IS NULL THEN
2087: arp_ship_from_add_tab(i) := 'X'||l_sfr_geocode;
2088: ELSE

Line 2100: arp_ship_from_add_tab(i) := ARP_TAX_VIEW_VERTEX.USE_SHIP_TO;

2096: END IF;
2097: END IF;
2098: EXCEPTION
2099: WHEN OTHERS THEN
2100: arp_ship_from_add_tab(i) := ARP_TAX_VIEW_VERTEX.USE_SHIP_TO;
2101: END;
2102: END IF;
2103:
2104: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 2174: arp_poa_add_code_tab(i) := ARP_TAX_VIEW_VERTEX.POA_ADDRESS_CODE

2170: p_salesrep_tbl(trx_id_tab(i)) := l_sales_repid;
2171: END IF;
2172: END IF;
2173:
2174: arp_poa_add_code_tab(i) := ARP_TAX_VIEW_VERTEX.POA_ADDRESS_CODE
2175: (l_view_name,
2176: trx_id_tab(i),
2177: trx_line_id_tab(i),
2178: l_sales_repid);

Line 2191: arp_poa_add_code_tab(i) := ARP_TAX_VIEW_VERTEX.USE_SHIP_TO;

2187: FROM ra_salesreps
2188: WHERE salesrep_id = l_sales_repid;
2189: EXCEPTION
2190: WHEN OTHERS THEN
2191: arp_poa_add_code_tab(i) := ARP_TAX_VIEW_VERTEX.USE_SHIP_TO;
2192: END;
2193:
2194: IF l_poa_geocode IS NULL THEN
2195: arp_poa_add_code_tab(i) := ARP_TAX_VIEW_VERTEX.USE_SHIP_TO;

Line 2195: arp_poa_add_code_tab(i) := ARP_TAX_VIEW_VERTEX.USE_SHIP_TO;

2191: arp_poa_add_code_tab(i) := ARP_TAX_VIEW_VERTEX.USE_SHIP_TO;
2192: END;
2193:
2194: IF l_poa_geocode IS NULL THEN
2195: arp_poa_add_code_tab(i) := ARP_TAX_VIEW_VERTEX.USE_SHIP_TO;
2196: ELSE
2197: IF NOT Check_Geocode(l_poa_geocode) THEN
2198: arp_poa_add_code_tab(i) := ARP_TAX_VIEW_VERTEX.USE_SHIP_TO;
2199: ELSE

Line 2198: arp_poa_add_code_tab(i) := ARP_TAX_VIEW_VERTEX.USE_SHIP_TO;

2194: IF l_poa_geocode IS NULL THEN
2195: arp_poa_add_code_tab(i) := ARP_TAX_VIEW_VERTEX.USE_SHIP_TO;
2196: ELSE
2197: IF NOT Check_Geocode(l_poa_geocode) THEN
2198: arp_poa_add_code_tab(i) := ARP_TAX_VIEW_VERTEX.USE_SHIP_TO;
2199: ELSE
2200: IF l_poa_in_out_flag IS NULL THEN
2201: arp_poa_add_code_tab(i) := l_in_out_flag||l_poa_geocode;
2202: ELSE

Line 2210: arp_poa_add_code_tab(i) := ARP_TAX_VIEW_VERTEX.USE_SHIP_TO;

2206: END IF;
2207: poa_add_code_cache_tbl(l_sales_repid) := arp_poa_add_code_tab(i);
2208: END IF;
2209: ELSE
2210: arp_poa_add_code_tab(i) := ARP_TAX_VIEW_VERTEX.USE_SHIP_TO;
2211: END IF;
2212: END IF;
2213:
2214: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 2235: arp_customer_code_tab(i) := ARP_TAX_VIEW_VERTEX.CUSTOMER_CODE

2231: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2232: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
2233: END IF;
2234:
2235: arp_customer_code_tab(i) := ARP_TAX_VIEW_VERTEX.CUSTOMER_CODE
2236: (l_view_name,
2237: trx_id_tab(i),
2238: trx_line_id_tab(i));
2239:

Line 2342: arp_customer_class_tab(i) := ARP_TAX_VIEW_VERTEX.CUSTOMER_CLASS

2338: p_party_id_tbl(l_ptp_id) := l_party_id;
2339: END IF;
2340: END IF; --- Bug 6024643
2341: BEGIN
2342: arp_customer_class_tab(i) := ARP_TAX_VIEW_VERTEX.CUSTOMER_CLASS
2343: (l_view_name,
2344: trx_id_tab(i),
2345: trx_line_id_tab(i),
2346: l_party_id);

Line 2368: arp_division_code_tab(i) := ARP_TAX_VIEW_VERTEX.DIVISION_CODE

2364: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2365: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
2366: END IF;
2367:
2368: arp_division_code_tab(i) := ARP_TAX_VIEW_VERTEX.DIVISION_CODE
2369: (l_view_name,
2370: trx_id_tab(i),
2371: trx_line_id_tab(i));
2372: /*IF (arp_division_code_tab(i) is NULL) THEN

Line 2392: arp_transaction_date_tab(i) := ARP_TAX_VIEW_VERTEX.TRANSACTION_DATE

2388: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2389: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
2390: END IF;
2391:
2392: arp_transaction_date_tab(i) := ARP_TAX_VIEW_VERTEX.TRANSACTION_DATE
2393: (l_view_name,
2394: trx_id_tab(i),
2395: trx_line_id_tab(i));
2396: IF arp_transaction_date_tab(i) IS NULL THEN

Line 2431: arp_company_code_tab(i) := ARP_TAX_VIEW_VERTEX.COMPANY_CODE

2427: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2428: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
2429: END IF;
2430:
2431: arp_company_code_tab(i) := ARP_TAX_VIEW_VERTEX.COMPANY_CODE
2432: (l_view_name,
2433: trx_id_tab(i),
2434: trx_line_id_tab(i));
2435: IF (arp_company_code_tab(i) is NULL) THEN