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_TAXWARE_USER_PKG dependencies on ARP_TAX_VIEW_TAXWARE

Line 1299: call the ARP_TAX_VIEW_TAXWARE.GET_EXEMPTIONS in order to populate the exemption records table

1295: The overall logic here is like this:
1296: Initially populate the exemption id into a nested table at the same index .Meaning if a exemption
1297: id of 2000 gets derived for a state level tax then for the exemptions nested table store this
1298: value of 2000 at the 2000th location in the table.Also use the derived exemption id to
1299: call the ARP_TAX_VIEW_TAXWARE.GET_EXEMPTIONS in order to populate the exemption records table
1300: at the same location ie 2000.
1301:
1302: ****NOTE**** Here p_position is the position in the linear table (in the main loop)
1303: into which the derived values are ultimately getting inserted .

Line 1307: ARP_TAX_VIEW_TAXWARE.GET_EXEMPTIONS(

1303: into which the derived values are ultimately getting inserted .
1304: */
1305: IF NOT exemptions_info_tab.EXISTS(NVL(x_exempt_record.exemption_id, -99)) THEN
1306: IF x_exempt_record.exemption_id IS NOT NULL THEN
1307: ARP_TAX_VIEW_TAXWARE.GET_EXEMPTIONS(
1308: X_EXEMPT_RECORD.EXEMPTION_ID, --This is the input parameter for this call
1309: exemptions_info_tab(x_exempt_record.exemption_id).state_exempt_pct,
1310: exemptions_info_tab(x_exempt_record.exemption_id).state_exempt_reason,
1311: exemptions_info_tab(x_exempt_record.exemption_id).state_cert_no,

Line 1753: arp_audit_flag_tab(i) := ARP_TAX_VIEW_TAXWARE.AUDIT_FLAG

1749: END IF;
1750:
1751: IF l_view_name = 'TAX_ADJUSTMENTS_V_A' THEN
1752: BEGIN
1753: arp_audit_flag_tab(i) := ARP_TAX_VIEW_TAXWARE.AUDIT_FLAG
1754: (l_view_name,
1755: trx_id_tab(i),
1756: trx_line_id_tab(i));
1757: EXCEPTION WHEN OTHERS THEN

Line 1827: arp_product_code_tab(i) := ARP_TAX_VIEW_TAXWARE.PRODUCT_CODE(l_view_name

1823: l_memo_line_id := product_id_tab(i);
1824: END IF;
1825:
1826: BEGIN
1827: arp_product_code_tab(i) := ARP_TAX_VIEW_TAXWARE.PRODUCT_CODE(l_view_name
1828: , trx_id_tab(i)
1829: , trx_line_id_tab(i)
1830: , l_product_id
1831: , l_memo_line_id);

Line 1922: arp_ship_to_add_tab(i) := ARP_TAX_VIEW_TAXWARE.SHIP_TO_ADDRESS_CODE

1918: END;
1919: END IF;
1920:
1921: BEGIN
1922: arp_ship_to_add_tab(i) := ARP_TAX_VIEW_TAXWARE.SHIP_TO_ADDRESS_CODE
1923: (l_view_name,
1924: trx_id_tab(i),
1925: trx_line_id_tab(i),
1926: ship_to_address_id_tab(i),

Line 2050: arp_ship_from_add_tab(i) := ARP_TAX_VIEW_TAXWARE.SHIP_FROM_ADDRESS_CODE

2046: EXCEPTION WHEN NO_DATA_FOUND THEN
2047: l_ship_from_party_id := NULL;
2048: END;
2049:
2050: arp_ship_from_add_tab(i) := ARP_TAX_VIEW_TAXWARE.SHIP_FROM_ADDRESS_CODE
2051: (l_view_name,
2052: trx_id_tab(i),
2053: trx_line_id_tab(i),
2054: l_ship_from_party_id);

Line 2067: arp_ship_from_add_tab(i):= arp_tax_view_taxware.USE_SHIP_TO;

2063:
2064: IF arp_ship_from_add_tab(i) IS NOT NULL THEN
2065: arp_ship_from_add_tab(i) := '1'||arp_ship_from_add_tab(i);
2066: ELSE
2067: arp_ship_from_add_tab(i):= arp_tax_view_taxware.USE_SHIP_TO;
2068: END IF;
2069: EXCEPTION WHEN OTHERS THEN
2070: BEGIN
2071: SELECT lc.loc_information13

Line 2079: arp_ship_from_add_tab(i):= arp_tax_view_taxware.USE_SHIP_TO;

2075:
2076: IF arp_ship_from_add_tab(i) IS NOT NULL THEN
2077: arp_ship_from_add_tab(i) := '1'||arp_ship_from_add_tab(i);
2078: ELSE
2079: arp_ship_from_add_tab(i):= arp_tax_view_taxware.USE_SHIP_TO;
2080: END IF;
2081: EXCEPTION WHEN OTHERS THEN
2082: arp_ship_from_add_tab(i):= arp_tax_view_taxware.USE_SHIP_TO;
2083: END;

Line 2082: arp_ship_from_add_tab(i):= arp_tax_view_taxware.USE_SHIP_TO;

2078: ELSE
2079: arp_ship_from_add_tab(i):= arp_tax_view_taxware.USE_SHIP_TO;
2080: END IF;
2081: EXCEPTION WHEN OTHERS THEN
2082: arp_ship_from_add_tab(i):= arp_tax_view_taxware.USE_SHIP_TO;
2083: END;
2084: END;
2085: END IF;
2086:

Line 2106: arp_poa_add_code_tab(i) := ARP_TAX_VIEW_TAXWARE.POA_ADDRESS_CODE

2102: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
2103: END IF;
2104:
2105: BEGIN
2106: arp_poa_add_code_tab(i) := ARP_TAX_VIEW_TAXWARE.POA_ADDRESS_CODE
2107: (l_view_name,
2108: trx_id_tab(i),
2109: trx_line_id_tab(i));
2110: Exception When Others then

Line 2128: arp_poa_add_code_tab(i) := arp_tax_view_taxware.USE_SHIP_TO;

2124: WHERE EVENT_CLASS_CODE = event_class_code_tab(i)
2125: AND APPLICATION_ID = application_id_tab(i)
2126: AND ENTITY_CODE = entity_code_tab(i)));
2127: IF arp_poa_add_code_tab(i) IS NULL THEN
2128: arp_poa_add_code_tab(i) := arp_tax_view_taxware.USE_SHIP_TO;
2129: ELSE
2130: IF NOT check_geocode(arp_poa_add_code_tab(i)) THEN
2131: arp_poa_add_code_tab(i) := arp_tax_view_taxware.USE_SHIP_TO;
2132: ELSE

Line 2131: arp_poa_add_code_tab(i) := arp_tax_view_taxware.USE_SHIP_TO;

2127: IF arp_poa_add_code_tab(i) IS NULL THEN
2128: arp_poa_add_code_tab(i) := arp_tax_view_taxware.USE_SHIP_TO;
2129: ELSE
2130: IF NOT check_geocode(arp_poa_add_code_tab(i)) THEN
2131: arp_poa_add_code_tab(i) := arp_tax_view_taxware.USE_SHIP_TO;
2132: ELSE
2133: arp_poa_add_code_tab(i) := '1'||arp_poa_add_code_tab(i);
2134: END IF;
2135: END IF;

Line 2137: arp_poa_add_code_tab(i) := arp_tax_view_taxware.USE_SHIP_TO;

2133: arp_poa_add_code_tab(i) := '1'||arp_poa_add_code_tab(i);
2134: END IF;
2135: END IF;
2136: EXCEPTION WHEN OTHERS THEN
2137: arp_poa_add_code_tab(i) := arp_tax_view_taxware.USE_SHIP_TO;
2138: END;
2139: END IF;
2140:
2141: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 2165: arp_poo_add_code_tab(i) := ARP_TAX_VIEW_TAXWARE.POO_ADDRESS_CODE

2161: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
2162: END IF;
2163:
2164: BEGIN
2165: arp_poo_add_code_tab(i) := ARP_TAX_VIEW_TAXWARE.POO_ADDRESS_CODE
2166: (l_view_name,
2167: trx_id_tab(i),
2168: trx_line_id_tab(i),
2169: g_sales_repid);

Line 2181: arp_poo_add_code_tab(i) := arp_tax_view_taxware.USE_SHIP_TO;

2177: into arp_poo_add_code_tab(i)
2178: from ra_salesreps
2179: where salesrep_id = g_sales_repid;
2180: IF arp_poo_add_code_tab(i) IS NULL THEN
2181: arp_poo_add_code_tab(i) := arp_tax_view_taxware.USE_SHIP_TO;
2182: ELSE
2183: IF NOT check_geocode(arp_poo_add_code_tab(i)) THEN
2184: arp_poo_add_code_tab(i) := arp_tax_view_taxware.USE_SHIP_TO;
2185: ELSE

Line 2184: arp_poo_add_code_tab(i) := arp_tax_view_taxware.USE_SHIP_TO;

2180: IF arp_poo_add_code_tab(i) IS NULL THEN
2181: arp_poo_add_code_tab(i) := arp_tax_view_taxware.USE_SHIP_TO;
2182: ELSE
2183: IF NOT check_geocode(arp_poo_add_code_tab(i)) THEN
2184: arp_poo_add_code_tab(i) := arp_tax_view_taxware.USE_SHIP_TO;
2185: ELSE
2186: arp_poo_add_code_tab(i) := '1'||arp_poo_add_code_tab(i);
2187: END IF;
2188: END IF;

Line 2190: arp_poo_add_code_tab(i) := arp_tax_view_taxware.USE_SHIP_TO;

2186: arp_poo_add_code_tab(i) := '1'||arp_poo_add_code_tab(i);
2187: END IF;
2188: END IF;
2189: EXCEPTION WHEN OTHERS THEN
2190: arp_poo_add_code_tab(i) := arp_tax_view_taxware.USE_SHIP_TO;
2191: END;
2192: END IF;
2193:
2194:

Line 2216: arp_customer_code_tab(i) := ARP_TAX_VIEW_TAXWARE.CUSTOMER_CODE

2212: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2213: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
2214: END IF;
2215:
2216: arp_customer_code_tab(i) := ARP_TAX_VIEW_TAXWARE.CUSTOMER_CODE
2217: (l_view_name,
2218: trx_id_tab(i),
2219: trx_line_id_tab(i));
2220: IF arp_customer_code_tab(i) IS NULL THEN

Line 2310: arp_customer_name_tab(i) := ARP_TAX_VIEW_TAXWARE.CUSTOMER_NAME

2306: END IF;
2307:
2308:
2309: BEGIN
2310: arp_customer_name_tab(i) := ARP_TAX_VIEW_TAXWARE.CUSTOMER_NAME
2311: (l_view_name,
2312: trx_id_tab(i),
2313: trx_line_id_tab(i));
2314:

Line 2380: arp_division_code_tab(i) := ARP_TAX_VIEW_TAXWARE.DIVISION_CODE

2376: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2377: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
2378: END IF;
2379:
2380: arp_division_code_tab(i) := ARP_TAX_VIEW_TAXWARE.DIVISION_CODE
2381: (l_view_name,
2382: trx_id_tab(i),
2383: trx_line_id_tab(i));
2384: if(arp_division_code_tab(i) is NULL) then

Line 2404: arp_transaction_date_tab(i) := ARP_TAX_VIEW_TAXWARE.TRANSACTION_DATE

2400: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2401: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
2402: END IF;
2403:
2404: arp_transaction_date_tab(i) := ARP_TAX_VIEW_TAXWARE.TRANSACTION_DATE
2405: (l_view_name,
2406: trx_id_tab(i),
2407: trx_line_id_tab(i));
2408: IF arp_transaction_date_tab(i) IS NULL THEN

Line 2443: arp_company_code_tab(i) := ARP_TAX_VIEW_TAXWARE.COMPANY_CODE

2439: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2440: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
2441: END IF;
2442:
2443: arp_company_code_tab(i) := ARP_TAX_VIEW_TAXWARE.COMPANY_CODE
2444: (l_view_name,
2445: trx_id_tab(i),
2446: trx_line_id_tab(i));
2447: IF (arp_company_code_tab(i) is NULL) THEN

Line 2467: arp_vnd_ctrl_exmpt_tab(i):= ARP_TAX_VIEW_TAXWARE.VENDOR_CONTROL_EXEMPTIONS

2463: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2464: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
2465: END IF;
2466:
2467: arp_vnd_ctrl_exmpt_tab(i):= ARP_TAX_VIEW_TAXWARE.VENDOR_CONTROL_EXEMPTIONS
2468: (l_view_name,
2469: trx_id_tab(i),
2470: trx_line_id_tab(i),
2471: trx_type_id_tab(i));

Line 2504: arp_use_nexpro_tab(i) := ARP_TAX_VIEW_TAXWARE.USE_NEXPRO

2500: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2501: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
2502: END IF;
2503:
2504: arp_use_nexpro_tab(i) := ARP_TAX_VIEW_TAXWARE.USE_NEXPRO
2505: (l_view_name,
2506: trx_id_tab(i),
2507: trx_line_id_tab(i));
2508: if(arp_use_nexpro_tab(i) is NULL) then

Line 2528: arp_service_ind_tab(i) := ARP_TAX_VIEW_TAXWARE.SERVICE_INDICATOR

2524: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2525: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
2526: END IF;
2527:
2528: arp_service_ind_tab(i) := ARP_TAX_VIEW_TAXWARE.SERVICE_INDICATOR
2529: (l_view_name,
2530: trx_id_tab(i),
2531: trx_line_id_tab(i));
2532: if(arp_service_ind_tab(i) is NULL) then

Line 2552: arp_tax_sel_param_tab(i) := ARP_TAX_VIEW_TAXWARE.TAX_SEL_PARM

2548: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2549: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
2550: END IF;
2551:
2552: arp_tax_sel_param_tab(i) := ARP_TAX_VIEW_TAXWARE.TAX_SEL_PARM
2553: (l_view_name,
2554: trx_id_tab(i),
2555: trx_line_id_tab(i));
2556: if(arp_tax_sel_param_tab(i) is NULL) then

Line 2576: calculation_flag_tab(i) := ARP_TAX_VIEW_TAXWARE.Calculation_Flag

2572: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2573: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
2574: END IF;
2575:
2576: calculation_flag_tab(i) := ARP_TAX_VIEW_TAXWARE.Calculation_Flag
2577: (l_view_name,
2578: trx_id_tab(i),
2579: trx_line_id_tab(i));
2580: if(calculation_flag_tab(i) is NULL) then

Line 2622: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_TAXWARE.INITIALIZE',

2618:
2619: PROCEDURE INITIALIZE IS
2620: BEGIN
2621: IF (g_level_procedure >= g_current_runtime_level ) THEN
2622: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_TAXWARE.INITIALIZE',
2623: 'ZX.PARTNER.ARP_TAX_VIEW_TAXWARE.INITIALIZE(+)');
2624: END IF;
2625:
2626: g_usenexpro := fnd_profile.value('ZX_TAXVDR_USENEXPRO');

Line 2623: 'ZX.PARTNER.ARP_TAX_VIEW_TAXWARE.INITIALIZE(+)');

2619: PROCEDURE INITIALIZE IS
2620: BEGIN
2621: IF (g_level_procedure >= g_current_runtime_level ) THEN
2622: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_TAXWARE.INITIALIZE',
2623: 'ZX.PARTNER.ARP_TAX_VIEW_TAXWARE.INITIALIZE(+)');
2624: END IF;
2625:
2626: g_usenexpro := fnd_profile.value('ZX_TAXVDR_USENEXPRO');
2627: g_taxselparam := TO_NUMBER(fnd_profile.value('ZX_TAXVDR_TAXSELPARAM'));

Line 2631: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_TAXWARE.INITIALIZE',

2627: g_taxselparam := TO_NUMBER(fnd_profile.value('ZX_TAXVDR_TAXSELPARAM'));
2628: -- g_taxtype := TO_NUMBER(fnd_profile.value('ZX_TAXVDR_TAXTYPE'));
2629: g_serviceind := TO_NUMBER(fnd_profile.value('ZX_TAXVDR_SERVICEIND'));
2630: IF (g_level_procedure >= g_current_runtime_level ) THEN
2631: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_TAXWARE.INITIALIZE',
2632: 'ZX.PARTNER.ARP_TAX_VIEW_TAXWARE.INITIALIZE(-)');
2633: END IF;
2634:
2635: END INITIALIZE;

Line 2632: 'ZX.PARTNER.ARP_TAX_VIEW_TAXWARE.INITIALIZE(-)');

2628: -- g_taxtype := TO_NUMBER(fnd_profile.value('ZX_TAXVDR_TAXTYPE'));
2629: g_serviceind := TO_NUMBER(fnd_profile.value('ZX_TAXVDR_SERVICEIND'));
2630: IF (g_level_procedure >= g_current_runtime_level ) THEN
2631: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_TAXWARE.INITIALIZE',
2632: 'ZX.PARTNER.ARP_TAX_VIEW_TAXWARE.INITIALIZE(-)');
2633: END IF;
2634:
2635: END INITIALIZE;
2636: