DBA Data[Home] [Help]

APPS.ZX_TAXWARE_USER_PKG dependencies on ARP_TAX_VIEW_TAXWARE

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

1231: The overall logic here is like this:
1232: Initially populate the exemption id into a nested table at the same index .Meaning if a exemption
1233: id of 2000 gets derived for a state level tax then for the exemptions nested table store this
1234: value of 2000 at the 2000th location in the table.Also use the derived exemption id to
1235: call the ARP_TAX_VIEW_TAXWARE.GET_EXEMPTIONS in order to populate the exemption records table
1236: at the same location ie 2000.
1237:
1238: ****NOTE**** Here p_position is the position in the linear table (in the main loop)
1239: into which the derived values are ultimately getting inserted .

Line 1242: ARP_TAX_VIEW_TAXWARE.GET_EXEMPTIONS(

1238: ****NOTE**** Here p_position is the position in the linear table (in the main loop)
1239: into which the derived values are ultimately getting inserted .
1240: */
1241: IF NOT exemptions_info_tab.EXISTS(x_exempt_record.exemption_id) THEN
1242: ARP_TAX_VIEW_TAXWARE.GET_EXEMPTIONS(
1243: X_EXEMPT_RECORD.EXEMPTION_ID, --This is the input parameter for this call
1244: exemptions_info_tab(x_exempt_record.exemption_id).state_exempt_pct,
1245: exemptions_info_tab(x_exempt_record.exemption_id).state_exempt_reason,
1246: exemptions_info_tab(x_exempt_record.exemption_id).state_cert_no,

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

1597: END IF;
1598:
1599: IF l_view_name = 'TAX_ADJUSTMENTS_V_A' THEN
1600: BEGIN
1601: arp_audit_flag_tab(i) := ARP_TAX_VIEW_TAXWARE.AUDIT_FLAG
1602: (l_view_name,
1603: trx_id_tab(i),
1604: trx_line_id_tab(i));
1605: EXCEPTION WHEN OTHERS THEN

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

1671: l_memo_line_id := product_id_tab(i);
1672: END IF;
1673:
1674: BEGIN
1675: arp_product_code_tab(i) := ARP_TAX_VIEW_TAXWARE.PRODUCT_CODE(l_view_name
1676: , trx_id_tab(i)
1677: , trx_line_id_tab(i)
1678: , l_product_id
1679: , l_memo_line_id);

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

1766: END;
1767: END IF;
1768:
1769: BEGIN
1770: arp_ship_to_add_tab(i) := ARP_TAX_VIEW_TAXWARE.SHIP_TO_ADDRESS_CODE
1771: (l_view_name,
1772: trx_id_tab(i),
1773: trx_line_id_tab(i),
1774: ship_to_address_id_tab(i),

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

1877: EXCEPTION WHEN NO_DATA_FOUND THEN
1878: l_ship_from_party_id := NULL;
1879: END;
1880:
1881: arp_ship_from_add_tab(i) := ARP_TAX_VIEW_TAXWARE.SHIP_FROM_ADDRESS_CODE
1882: (l_view_name,
1883: trx_id_tab(i),
1884: trx_line_id_tab(i),
1885: l_ship_from_party_id);

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

1893: and hr.location_id = lc.location_id;
1894:
1895: arp_ship_from_add_tab(i) := '1'||arp_ship_from_add_tab(i);
1896: EXCEPTION WHEN OTHERS THEN
1897: arp_ship_from_add_tab(i):=arp_tax_view_taxware.USE_SHIP_TO;
1898: END;
1899: END IF;
1900:
1901: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

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

1916: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
1917: END IF;
1918:
1919: BEGIN
1920: arp_poa_add_code_tab(i) := ARP_TAX_VIEW_TAXWARE.POA_ADDRESS_CODE
1921: (l_view_name,
1922: trx_id_tab(i),
1923: trx_line_id_tab(i));
1924: Exception When Others then

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

1938: AND APPLICATION_ID = application_id_tab(i)
1939: AND ENTITY_CODE = entity_code_tab(i));
1940: arp_poa_add_code_tab(i) := '1'||arp_poa_add_code_tab(i);
1941: EXCEPTION WHEN OTHERS THEN
1942: arp_poa_add_code_tab(i) := arp_tax_view_taxware.USE_SHIP_TO;
1943: END;
1944: END IF;
1945:
1946: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

1966: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
1967: END IF;
1968:
1969: BEGIN
1970: arp_poo_add_code_tab(i) := ARP_TAX_VIEW_TAXWARE.POO_ADDRESS_CODE
1971: (l_view_name,
1972: trx_id_tab(i),
1973: trx_line_id_tab(i),
1974: g_sales_repid);

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

1985:
1986: arp_poo_add_code_tab(i) := '1'||arp_poo_add_code_tab(i);
1987:
1988: EXCEPTION WHEN OTHERS THEN
1989: arp_poo_add_code_tab(i) := arp_tax_view_taxware.USE_SHIP_TO;
1990: END;
1991: END IF;
1992:
1993:

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

2011: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2012: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
2013: END IF;
2014:
2015: arp_customer_code_tab(i) := ARP_TAX_VIEW_TAXWARE.CUSTOMER_CODE
2016: (l_view_name,
2017: trx_id_tab(i),
2018: trx_line_id_tab(i));
2019: IF arp_customer_code_tab(i) IS NULL THEN

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

2105: END IF;
2106:
2107:
2108: BEGIN
2109: arp_customer_name_tab(i) := ARP_TAX_VIEW_TAXWARE.CUSTOMER_NAME
2110: (l_view_name,
2111: trx_id_tab(i),
2112: trx_line_id_tab(i));
2113:

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

2175: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2176: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
2177: END IF;
2178:
2179: arp_division_code_tab(i) := ARP_TAX_VIEW_TAXWARE.DIVISION_CODE
2180: (l_view_name,
2181: trx_id_tab(i),
2182: trx_line_id_tab(i));
2183: if(arp_division_code_tab(i) is NULL) then

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

2199: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2200: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
2201: END IF;
2202:
2203: arp_transaction_date_tab(i) := ARP_TAX_VIEW_TAXWARE.TRANSACTION_DATE
2204: (l_view_name,
2205: trx_id_tab(i),
2206: trx_line_id_tab(i));
2207: IF arp_transaction_date_tab(i) IS NULL THEN

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

2238: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2239: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
2240: END IF;
2241:
2242: arp_company_code_tab(i) := ARP_TAX_VIEW_TAXWARE.COMPANY_CODE
2243: (l_view_name,
2244: trx_id_tab(i),
2245: trx_line_id_tab(i));
2246: IF (arp_company_code_tab(i) is NULL) THEN

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

2262: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2263: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
2264: END IF;
2265:
2266: arp_vnd_ctrl_exmpt_tab(i):= ARP_TAX_VIEW_TAXWARE.VENDOR_CONTROL_EXEMPTIONS
2267: (l_view_name,
2268: trx_id_tab(i),
2269: trx_line_id_tab(i),
2270: trx_type_id_tab(i));

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

2299: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2300: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
2301: END IF;
2302:
2303: arp_use_nexpro_tab(i) := ARP_TAX_VIEW_TAXWARE.USE_NEXPRO
2304: (l_view_name,
2305: trx_id_tab(i),
2306: trx_line_id_tab(i));
2307: if(arp_use_nexpro_tab(i) is NULL) then

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

2323: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2324: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
2325: END IF;
2326:
2327: arp_service_ind_tab(i) := ARP_TAX_VIEW_TAXWARE.SERVICE_INDICATOR
2328: (l_view_name,
2329: trx_id_tab(i),
2330: trx_line_id_tab(i));
2331: if(arp_service_ind_tab(i) is NULL) then

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

2347: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2348: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
2349: END IF;
2350:
2351: arp_tax_sel_param_tab(i) := ARP_TAX_VIEW_TAXWARE.TAX_SEL_PARM
2352: (l_view_name,
2353: trx_id_tab(i),
2354: trx_line_id_tab(i));
2355: if(arp_tax_sel_param_tab(i) is NULL) then

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

2371: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2372: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
2373: END IF;
2374:
2375: calculation_flag_tab(i) := ARP_TAX_VIEW_TAXWARE.Calculation_Flag
2376: (l_view_name,
2377: trx_id_tab(i),
2378: trx_line_id_tab(i));
2379: if(calculation_flag_tab(i) is NULL) then

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

2417:
2418: PROCEDURE INITIALIZE IS
2419: BEGIN
2420: IF (g_level_procedure >= g_current_runtime_level ) THEN
2421: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_TAXWARE.INITIALIZE',
2422: 'ZX.PARTNER.ARP_TAX_VIEW_TAXWARE.INITIALIZE(+)');
2423: END IF;
2424:
2425: g_usenexpro := fnd_profile.value('ZX_TAXVDR_USENEXPRO');

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

2418: PROCEDURE INITIALIZE IS
2419: BEGIN
2420: IF (g_level_procedure >= g_current_runtime_level ) THEN
2421: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_TAXWARE.INITIALIZE',
2422: 'ZX.PARTNER.ARP_TAX_VIEW_TAXWARE.INITIALIZE(+)');
2423: END IF;
2424:
2425: g_usenexpro := fnd_profile.value('ZX_TAXVDR_USENEXPRO');
2426: g_taxselparam := TO_NUMBER(fnd_profile.value('ZX_TAXVDR_TAXSELPARAM'));

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

2426: g_taxselparam := TO_NUMBER(fnd_profile.value('ZX_TAXVDR_TAXSELPARAM'));
2427: -- g_taxtype := TO_NUMBER(fnd_profile.value('ZX_TAXVDR_TAXTYPE'));
2428: g_serviceind := TO_NUMBER(fnd_profile.value('ZX_TAXVDR_SERVICEIND'));
2429: IF (g_level_procedure >= g_current_runtime_level ) THEN
2430: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_TAXWARE.INITIALIZE',
2431: 'ZX.PARTNER.ARP_TAX_VIEW_TAXWARE.INITIALIZE(-)');
2432: END IF;
2433:
2434: END INITIALIZE;

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

2427: -- g_taxtype := TO_NUMBER(fnd_profile.value('ZX_TAXVDR_TAXTYPE'));
2428: g_serviceind := TO_NUMBER(fnd_profile.value('ZX_TAXVDR_SERVICEIND'));
2429: IF (g_level_procedure >= g_current_runtime_level ) THEN
2430: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_TAXWARE.INITIALIZE',
2431: 'ZX.PARTNER.ARP_TAX_VIEW_TAXWARE.INITIALIZE(-)');
2432: END IF;
2433:
2434: END INITIALIZE;
2435: