DBA Data[Home] [Help]

APPS.ZX_TAXWARE_USER_PKG dependencies on ZX_TCM_GEO_JUR_PKG

Line 444: l_tax_jurisdiction_rec ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_type;

440: j PLS_INTEGER;
441:
442: l_master_org_id oe_system_parameters_all.master_organization_id%type;
443: /* Bug 4668932 */
444: l_tax_jurisdiction_rec ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_type;
445: l_jurisdictions_found VARCHAR2(1);
446: l_ship_to_geocode VARCHAR2(30);
447: row_count number;
448: /* Bug 4668932 */

Line 992: l_jurisdiction_rec ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_type;

988: l_exempt_percent ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_NUMBER_ATTRIBUTE1%TYPE;
989: l_exempt_reason ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_VARCHAR_ATTRIBUTE4%TYPE;
990: l_certificate_number ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_VARCHAR_ATTRIBUTE3%TYPE;
991: l_tax_account_source_tax VARCHAR2(50);
992: l_jurisdiction_rec ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_type;
993: l_jurisdictions_found VARCHAR2(5);
994: l_multiple_jurisdictions_flag VARCHAR2(5);
995: l_ptnr_exemption_indx VARCHAR2(4000);
996:

Line 1209: ZX_TCM_GEO_JUR_PKG.get_tax_jurisdictions (

1205: FND_LOG.STRING(G_LEVEL_STATEMENT,'Location ID: ',to_char(p_bill_to_location_id));
1206: END IF;
1207:
1208: IF p_bill_to_location_id IS NOT NULL THEN
1209: ZX_TCM_GEO_JUR_PKG.get_tax_jurisdictions (
1210: p_location_id => p_bill_to_location_id,
1211: p_location_type => l_location_type,
1212: p_tax => tax_identifier_tab(i),
1213: p_tax_regime_code => p_tax_regime_code,

Line 1884: l_tax_jurisdiction_rec ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_type;

1880: END DERIVE_PRODUCT_CODE;
1881:
1882: PROCEDURE DERIVE_SHIP_TO_ADDRESS_CODE
1883: IS
1884: l_tax_jurisdiction_rec ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_type;
1885: x_ret_status VARCHAR2(30);
1886: l_jurisdictions_found VARCHAR2(1);
1887: l_ship_to_geocode varchar2(30);
1888: l_state_code VARCHAR2(60);

Line 1952: ZX_TCM_GEO_JUR_PKG.get_tax_jurisdictions(

1948: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME,'GeoCode Override: '||arp_ship_to_add_tab(i));
1949: END IF;
1950:
1951: IF NOT check_geocode(substrb(nvl(arp_ship_to_add_tab(i),'XXXXXXXXXX'),2,9)) THEN
1952: ZX_TCM_GEO_JUR_PKG.get_tax_jurisdictions(
1953: p_location_id => nvl(ship_to_loc_id_tab(i), bill_to_location_id_tab(i)),
1954: p_location_type => 'SHIP_TO',
1955: p_tax => 'CITY',
1956: p_tax_regime_code => tax_regime_code_tab(i),