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 993: l_jurisdiction_rec ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_type;

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

Line 1147: ZX_TCM_GEO_JUR_PKG.get_tax_jurisdictions (

1143: FND_LOG.STRING(G_LEVEL_STATEMENT,'Location ID: ',to_char(p_bill_to_location_id));
1144: END IF;
1145:
1146: IF p_bill_to_location_id IS NOT NULL THEN
1147: ZX_TCM_GEO_JUR_PKG.get_tax_jurisdictions (
1148: p_location_id => p_bill_to_location_id,
1149: p_location_type => l_location_type,
1150: p_tax => tax_identifier_tab(i),
1151: p_tax_regime_code => p_tax_regime_code,

Line 1732: l_tax_jurisdiction_rec ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_type;

1728: END DERIVE_PRODUCT_CODE;
1729:
1730: PROCEDURE DERIVE_SHIP_TO_ADDRESS_CODE
1731: IS
1732: l_tax_jurisdiction_rec ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_type;
1733: x_ret_status VARCHAR2(30);
1734: l_jurisdictions_found VARCHAR2(1);
1735: l_ship_to_geocode varchar2(30);
1736: l_state_code VARCHAR2(60);

Line 1800: ZX_TCM_GEO_JUR_PKG.get_tax_jurisdictions(

1796: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME,'GeoCode Override: '||arp_ship_to_add_tab(i));
1797: END IF;
1798:
1799: IF NOT check_geocode(substrb(nvl(arp_ship_to_add_tab(i),'XXXXXXXXXX'),2,9)) THEN
1800: ZX_TCM_GEO_JUR_PKG.get_tax_jurisdictions(
1801: p_location_id => nvl(ship_to_loc_id_tab(i), bill_to_location_id_tab(i)),
1802: p_location_type => 'SHIP_TO',
1803: p_tax => 'CITY',
1804: p_tax_regime_code => tax_regime_code_tab(i),