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 VARCHAR2(4000);

Line 1182: ZX_TCM_GEO_JUR_PKG.get_tax_jurisdictions (

1178:
1179: delete from zx_jurisdictions_gt;
1180:
1181: IF p_bill_to_location_id IS NOT NULL THEN
1182: ZX_TCM_GEO_JUR_PKG.get_tax_jurisdictions (
1183: p_location_id => p_bill_to_location_id,
1184: p_location_type => l_location_type,
1185: p_tax => tax_identifier_tab(i),
1186: p_tax_regime_code => p_tax_regime_code,

Line 1807: l_tax_jurisdiction_rec ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_type;

1803: END DERIVE_PRODUCT_CODE;
1804:
1805: PROCEDURE DERIVE_SHIP_TO_ADDRESS_CODE
1806: IS
1807: l_tax_jurisdiction_rec ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_type;
1808: x_ret_status VARCHAR2(30);
1809: l_jurisdictions_found VARCHAR2(1);
1810: l_jur_code VARCHAR2(30);
1811: l_jur_count NUMBER;

Line 1887: ZX_TCM_GEO_JUR_PKG.get_tax_jurisdictions(

1883: END;
1884:
1885: IF NOT check_geocode(substr(nvl(arp_ship_to_add_tab(i),'XXXXXXXXX'), 2,9)) THEN
1886: IF ship_to_loc_id_tab(i) IS NULL THEN
1887: ZX_TCM_GEO_JUR_PKG.get_tax_jurisdictions(
1888: p_location_id => bill_to_location_id_tab(i),
1889: p_location_type => 'SHIP_TO',
1890: p_tax => 'CITY',
1891: p_tax_regime_code => tax_regime_code_tab(i),

Line 1897: ZX_TCM_GEO_JUR_PKG.get_tax_jurisdictions(

1893: x_tax_jurisdiction_rec => l_tax_jurisdiction_rec,
1894: x_jurisdictions_found => l_jurisdictions_found,
1895: x_return_status => x_ret_status);
1896: ELSE
1897: ZX_TCM_GEO_JUR_PKG.get_tax_jurisdictions(
1898: p_location_id => ship_to_loc_id_tab(i),
1899: p_location_type => 'SHIP_TO',
1900: p_tax => 'CITY',
1901: p_tax_regime_code => tax_regime_code_tab(i),