DBA Data[Home] [Help]

APPS.ZX_VERTEX_TAX_SERVICE_PKG dependencies on ZX_TAX_VERTEX_GEO

Line 133: search_rec ZX_TAX_VERTEX_GEO.tGeoSearchRecord;

129:
130: /*-----------------------------------------------
131: | Records for GeoCode Retrieval Package |
132: -----------------------------------------------*/
133: search_rec ZX_TAX_VERTEX_GEO.tGeoSearchRecord;
134: result_rec ZX_TAX_VERTEX_GEO.tGeoResultsRecord;
135:
136: TYPE location_info_rec_type IS RECORD(
137: state VARCHAR2(2),

Line 134: result_rec ZX_TAX_VERTEX_GEO.tGeoResultsRecord;

130: /*-----------------------------------------------
131: | Records for GeoCode Retrieval Package |
132: -----------------------------------------------*/
133: search_rec ZX_TAX_VERTEX_GEO.tGeoSearchRecord;
134: result_rec ZX_TAX_VERTEX_GEO.tGeoResultsRecord;
135:
136: TYPE location_info_rec_type IS RECORD(
137: state VARCHAR2(2),
138: county VARCHAR2(30),

Line 3022: ZX_TAX_VERTEX_GEO.GeoSetNameCriteria(

3018: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Call API to set search criteria for '||
3019: 'finding GeoCode.');
3020: END IF;
3021:
3022: ZX_TAX_VERTEX_GEO.GeoSetNameCriteria(
3023: search_rec,
3024: ZX_TAX_VERTEX_GEO.cGeoCodeLevelCity,
3025: substrb(l_state, 1, 2),
3026: FALSE,

Line 3024: ZX_TAX_VERTEX_GEO.cGeoCodeLevelCity,

3020: END IF;
3021:
3022: ZX_TAX_VERTEX_GEO.GeoSetNameCriteria(
3023: search_rec,
3024: ZX_TAX_VERTEX_GEO.cGeoCodeLevelCity,
3025: substrb(l_state, 1, 2),
3026: FALSE,
3027: '',
3028: FALSE,

Line 3057: retval := ZX_TAX_VERTEX_GEO.GeoRetrieveFirst(search_rec, result_rec);

3053: ---------------------------*/
3054: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3055: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Call API to get GeoCode.' );
3056: END IF;
3057: retval := ZX_TAX_VERTEX_GEO.GeoRetrieveFirst(search_rec, result_rec);
3058:
3059: EXCEPTION
3060: WHEN OTHERS THEN
3061: IF (g_level_exception >= g_current_runtime_level ) THEN

Line 3094: l_geocode :=ZX_TAX_VERTEX_GEO.GeoPackGeoCode( result_rec.fResGeoState,

3090: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Call API to pack GeoCode to convert state, '||
3091: 'county, and city GeoCode into one 9-digit GeoCode.' );
3092: END IF;
3093:
3094: l_geocode :=ZX_TAX_VERTEX_GEO.GeoPackGeoCode( result_rec.fResGeoState,
3095: result_rec.fResGeoCounty,
3096: result_rec.fResGeoCity);
3097:
3098: EXCEPTION

Line 3129: retval := ZX_TAX_VERTEX_GEO.GeoRetrieveNext(search_rec, result_rec);

3125: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Call API to find out whether there is another '||
3126: 'record or not. If there is, then raise error later.' );
3127: END IF;
3128:
3129: retval := ZX_TAX_VERTEX_GEO.GeoRetrieveNext(search_rec, result_rec);
3130:
3131: EXCEPTION
3132: WHEN OTHERS THEN
3133: IF (g_level_exception >= g_current_runtime_level ) THEN