APPS.ZX_TAX_CONTENT_UPLOAD dependencies on HZ_GEOGRAPHY_STRUCTURE_PUB

Line 70: l_incl_geo_type HZ_GEOGRAPHY_STRUCTURE_PUB.INCL_GEO_TYPE_TBL_TYPE;

66: WHERE GEOGRAPHY_TYPE = b_geography_type;
67:
68: l_exists_flag VARCHAR2(1);
69: l_tax VARCHAR2(30);
70: l_incl_geo_type HZ_GEOGRAPHY_STRUCTURE_PUB.INCL_GEO_TYPE_TBL_TYPE;
71: l_zone_type_rec HZ_GEOGRAPHY_STRUCTURE_PUB.ZONE_TYPE_REC_TYPE;
72: l_return_status VARCHAR2(1);
73: l_msg_count NUMBER;
74: l_msg_data VARCHAR2(2000);

Line 71: l_zone_type_rec HZ_GEOGRAPHY_STRUCTURE_PUB.ZONE_TYPE_REC_TYPE;

67:
68: l_exists_flag VARCHAR2(1);
69: l_tax VARCHAR2(30);
70: l_incl_geo_type HZ_GEOGRAPHY_STRUCTURE_PUB.INCL_GEO_TYPE_TBL_TYPE;
71: l_zone_type_rec HZ_GEOGRAPHY_STRUCTURE_PUB.ZONE_TYPE_REC_TYPE;
72: l_return_status VARCHAR2(1);
73: l_msg_count NUMBER;
74: l_msg_data VARCHAR2(2000);
75:

Line 536: HZ_GEOGRAPHY_STRUCTURE_PUB.create_zone_type

532: l_zone_type_rec.geography_use := 'TAX';
533: l_zone_type_rec.limited_by_geography_id := 1;
534: l_zone_type_rec.created_by_module := G_CREATED_BY_MODULE;
535: l_zone_type_rec.application_id := 235;
536: HZ_GEOGRAPHY_STRUCTURE_PUB.create_zone_type
537: (
538: 'F',
539: l_zone_type_rec,
540: l_return_status,

Line 548: 'Status returned by HZ_GEOGRAPHY_STRUCTURE_PUB.create_zone_type: '||l_return_status||', and message: '||l_msg_data

544:
545: FND_FILE.PUT_LINE
546: (
547: FND_FILE.LOG,
548: 'Status returned by HZ_GEOGRAPHY_STRUCTURE_PUB.create_zone_type: '||l_return_status||', and message: '||l_msg_data
549: );
550:
551: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
552: THEN