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 1159: call the ARP_TAX_VIEW_VERTEX.GET_EXEMPTIONS in order to populate the exemption records table

1155: The overall logic here is like this:
1156: Initially populate the exemption id into a nested table at the same index .Meaning if a exemption
1157: id of 2000 gets derived for a state level tax then for the exemptions nested table store this
1158: value of 2000 at the 2000th location in the table.Also use the derived exemption id to
1159: call the ARP_TAX_VIEW_VERTEX.GET_EXEMPTIONS in order to populate the exemption records table
1160: at the same location ie 2000.
1161:
1162: ****NOTE**** Here p_position is the position in the linear table (in the main loop)
1163: into which the derived values are ultimately getting inserted .

Line 1166: ARP_TAX_VIEW_VERTEX.GET_EXEMPTIONS(

1162: ****NOTE**** Here p_position is the position in the linear table (in the main loop)
1163: into which the derived values are ultimately getting inserted .
1164: */
1165: IF NOT exemptions_info_tab.EXISTS(x_exempt_record.exemption_id) THEN
1166: ARP_TAX_VIEW_VERTEX.GET_EXEMPTIONS(
1167: X_EXEMPT_RECORD.EXEMPTION_ID, --This is the input parameter for this call
1168: exemptions_info_tab(x_exempt_record.exemption_id).certificate_number,
1169: exemptions_info_tab(x_exempt_record.exemption_id).state_exempt_pct,
1170: exemptions_info_tab(x_exempt_record.exemption_id).state_exempt_reason,

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

1514: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1515: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
1516: END IF;
1517:
1518: arp_trx_line_type_tab(i):= ARP_TAX_VIEW_VERTEX.TRX_LINE_TYPE
1519: (l_view_name,
1520: trx_id_tab(i),
1521: trx_line_id_tab(i)) ;
1522: IF (arp_trx_line_type_tab(i) is NULL) THEN

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

1540: END IF;
1541:
1542: IF l_view_name = 'TAX_ADJUSTMENTS_V_V' THEN
1543: BEGIN
1544: arp_audit_flag_tab(i) := ARP_TAX_VIEW_VERTEX.AUDIT_FLAG
1545: (l_view_name,
1546: trx_id_tab(i),
1547: trx_line_id_tab(i));
1548: EXCEPTION WHEN OTHERS THEN

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

1601: l_memo_line_id := product_id_tab(i);
1602: END IF;
1603:
1604: BEGIN
1605: arp_product_code_tab(i) := ARP_TAX_VIEW_VERTEX.PRODUCT_CODE(l_view_name
1606: , trx_id_tab(i)
1607: , trx_line_id_tab(i)
1608: , l_product_id
1609: , l_memo_line_id);

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

1695: END IF;
1696:
1697: BEGIN --bug6523242
1698: IF ship_to_loc_id_tab(i) IS NULL THEN
1699: arp_ship_to_add_tab(i) := ARP_TAX_VIEW_VERTEX.SHIP_TO_ADDRESS_CODE
1700: (l_view_name,
1701: trx_id_tab(i),
1702: trx_line_id_tab(i),
1703: ship_to_address_id_tab(i),

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

1706: NULL,--p_ship_to_state
1707: NULL--p_postal_code
1708: );
1709: ELSE
1710: arp_ship_to_add_tab(i) := ARP_TAX_VIEW_VERTEX.SHIP_TO_ADDRESS_CODE
1711: (l_view_name,
1712: trx_id_tab(i),
1713: trx_line_id_tab(i),
1714: ship_to_address_id_tab(i),

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

1862: EXCEPTION WHEN NO_DATA_FOUND THEN
1863: l_ship_from_party_id := NULL;
1864: END;
1865:
1866: arp_ship_from_add_tab(i) := ARP_TAX_VIEW_VERTEX.SHIP_FROM_ADDRESS_CODE
1867: (l_view_name,
1868: trx_id_tab(i),
1869: trx_line_id_tab(i),
1870: l_ship_from_party_id);

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

1927: END IF;
1928: END IF;
1929:
1930: IF l_sfr_geocode IS NULL THEN
1931: arp_ship_from_add_tab(i):= arp_tax_view_vertex.USE_SHIP_TO;
1932: ELSE
1933: IF NOT Check_Geocode(l_sfr_geocode) THEN
1934: arp_ship_from_add_tab(i):=ARP_TAX_VIEW_VERTEX.USE_SHIP_TO;
1935: ELSE

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

1930: IF l_sfr_geocode IS NULL THEN
1931: arp_ship_from_add_tab(i):= arp_tax_view_vertex.USE_SHIP_TO;
1932: ELSE
1933: IF NOT Check_Geocode(l_sfr_geocode) THEN
1934: arp_ship_from_add_tab(i):=ARP_TAX_VIEW_VERTEX.USE_SHIP_TO;
1935: ELSE
1936: IF l_sfr_in_out_flag IS NULL THEN
1937: arp_ship_from_add_tab(i) := 'X'||l_sfr_geocode;
1938: ELSE

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

1946: END IF;
1947: END IF;
1948: EXCEPTION
1949: WHEN OTHERS THEN
1950: arp_ship_from_add_tab(i) := ARP_TAX_VIEW_VERTEX.USE_SHIP_TO;
1951: END;
1952: END IF;
1953:
1954: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

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

2010: END IF;
2011: END IF;
2012: END IF;
2013:
2014: arp_poa_add_code_tab(i) := ARP_TAX_VIEW_VERTEX.POA_ADDRESS_CODE
2015: (l_view_name,
2016: trx_id_tab(i),
2017: trx_line_id_tab(i),
2018: l_sales_repid);

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

2027: FROM ra_salesreps
2028: WHERE salesrep_id = l_sales_repid;
2029: EXCEPTION
2030: WHEN OTHERS THEN
2031: arp_poa_add_code_tab(i) := ARP_TAX_VIEW_VERTEX.USE_SHIP_TO;
2032: END;
2033:
2034: IF l_poa_geocode IS NULL THEN
2035: arp_poa_add_code_tab(i) := ARP_TAX_VIEW_VERTEX.USE_SHIP_TO;

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

2031: arp_poa_add_code_tab(i) := ARP_TAX_VIEW_VERTEX.USE_SHIP_TO;
2032: END;
2033:
2034: IF l_poa_geocode IS NULL THEN
2035: arp_poa_add_code_tab(i) := ARP_TAX_VIEW_VERTEX.USE_SHIP_TO;
2036: ELSE
2037: IF NOT Check_Geocode(l_poa_geocode) THEN
2038: arp_poa_add_code_tab(i) := ARP_TAX_VIEW_VERTEX.USE_SHIP_TO;
2039: ELSE

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

2034: IF l_poa_geocode IS NULL THEN
2035: arp_poa_add_code_tab(i) := ARP_TAX_VIEW_VERTEX.USE_SHIP_TO;
2036: ELSE
2037: IF NOT Check_Geocode(l_poa_geocode) THEN
2038: arp_poa_add_code_tab(i) := ARP_TAX_VIEW_VERTEX.USE_SHIP_TO;
2039: ELSE
2040: IF l_poa_in_out_flag IS NULL THEN
2041: arp_poa_add_code_tab(i) := l_in_out_flag||l_poa_geocode;
2042: ELSE

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

2046: END IF;
2047: poa_add_code_cache_tbl(l_sales_repid) := arp_poa_add_code_tab(i);
2048: END IF;
2049: ELSE
2050: arp_poa_add_code_tab(i) := ARP_TAX_VIEW_VERTEX.USE_SHIP_TO;
2051: END IF;
2052: END IF;
2053:
2054: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

2071: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2072: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
2073: END IF;
2074:
2075: arp_customer_code_tab(i) := ARP_TAX_VIEW_VERTEX.CUSTOMER_CODE
2076: (l_view_name,
2077: trx_id_tab(i),
2078: trx_line_id_tab(i));
2079:

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

2178: p_party_id_tbl(l_ptp_id) := l_party_id;
2179: END IF;
2180: END IF; --- Bug 6024643
2181: BEGIN
2182: arp_customer_class_tab(i) := ARP_TAX_VIEW_VERTEX.CUSTOMER_CLASS
2183: (l_view_name,
2184: trx_id_tab(i),
2185: trx_line_id_tab(i),
2186: l_party_id);

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

2204: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2205: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
2206: END IF;
2207:
2208: arp_division_code_tab(i) := ARP_TAX_VIEW_VERTEX.DIVISION_CODE
2209: (l_view_name,
2210: trx_id_tab(i),
2211: trx_line_id_tab(i));
2212: /*IF (arp_division_code_tab(i) is NULL) THEN

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

2228: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2229: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
2230: END IF;
2231:
2232: arp_transaction_date_tab(i) := ARP_TAX_VIEW_VERTEX.TRANSACTION_DATE
2233: (l_view_name,
2234: trx_id_tab(i),
2235: trx_line_id_tab(i));
2236: IF arp_transaction_date_tab(i) IS NULL THEN

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

2267: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2268: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
2269: END IF;
2270:
2271: arp_company_code_tab(i) := ARP_TAX_VIEW_VERTEX.COMPANY_CODE
2272: (l_view_name,
2273: trx_id_tab(i),
2274: trx_line_id_tab(i));
2275: IF (arp_company_code_tab(i) is NULL) THEN