DBA Data[Home] [Help]

APPS.ZX_VTX_USER_PKG dependencies on ZX_TCM_GEO_JUR_PKG

Line 916: l_jurisdiction_rec ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_type;

912: l_exempt_percent ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_NUMBER_ATTRIBUTE1%TYPE;
913: l_exempt_reason ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_VARCHAR_ATTRIBUTE4%TYPE;
914: l_certificate_number ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_VARCHAR_ATTRIBUTE3%TYPE;
915: l_tax_account_source_tax VARCHAR2(50);
916: l_jurisdiction_rec ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_type;
917: l_jurisdictions_found VARCHAR2(5);
918: l_multiple_jurisdictions_flag VARCHAR2(5);
919: l_event_class_rec zx_api_pub.event_class_rec_type;
920: l_ptnr_exemption_indx BINARY_INTEGER;

Line 1073: ZX_TCM_GEO_JUR_PKG.get_tax_jurisdictions (

1069: END IF;
1070:
1071: delete from zx_jurisdictions_gt;
1072: IF p_bill_to_location_id IS NOT NULL THEN
1073: ZX_TCM_GEO_JUR_PKG.get_tax_jurisdictions (
1074: p_location_id => p_bill_to_location_id,
1075: p_location_type => l_location_type,
1076: p_tax => tax_identifier_tab(i),
1077: p_tax_regime_code => p_tax_regime_code,

Line 1661: l_tax_jurisdiction_rec ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_type;

1657: END DERIVE_PRODUCT_CODE;
1658:
1659: PROCEDURE DERIVE_SHIP_TO_ADDRESS_CODE
1660: IS
1661: l_tax_jurisdiction_rec ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_type;
1662: x_ret_status VARCHAR2(30);
1663: l_jurisdictions_found VARCHAR2(1);
1664: l_jur_code VARCHAR2(30);
1665: l_jur_count NUMBER;

Line 1741: ZX_TCM_GEO_JUR_PKG.get_tax_jurisdictions(

1737: END;
1738:
1739: IF NOT check_geocode(substr(nvl(arp_ship_to_add_tab(i),'XXXXXXXXX'), 2,9)) THEN
1740: IF ship_to_loc_id_tab(i) IS NULL THEN
1741: ZX_TCM_GEO_JUR_PKG.get_tax_jurisdictions(
1742: p_location_id => bill_to_location_id_tab(i),
1743: p_location_type => 'SHIP_TO',
1744: p_tax => 'CITY',
1745: p_tax_regime_code => tax_regime_code_tab(i),

Line 1751: ZX_TCM_GEO_JUR_PKG.get_tax_jurisdictions(

1747: x_tax_jurisdiction_rec => l_tax_jurisdiction_rec,
1748: x_jurisdictions_found => l_jurisdictions_found,
1749: x_return_status => x_ret_status);
1750: ELSE
1751: ZX_TCM_GEO_JUR_PKG.get_tax_jurisdictions(
1752: p_location_id => ship_to_loc_id_tab(i),
1753: p_location_type => 'SHIP_TO',
1754: p_tax => 'CITY',
1755: p_tax_regime_code => tax_regime_code_tab(i),