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 571: HZ_GEOGRAPHY_STRUCTURE_PUB.create_zone_type

567: l_zone_type_rec.geography_use := 'TAX';
568: l_zone_type_rec.limited_by_geography_id := 1;
569: l_zone_type_rec.created_by_module := G_CREATED_BY_MODULE;
570: l_zone_type_rec.application_id := 235;
571: HZ_GEOGRAPHY_STRUCTURE_PUB.create_zone_type
572: (
573: 'F',
574: l_zone_type_rec,
575: l_return_status,

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

579:
580: FND_FILE.PUT_LINE
581: (
582: FND_FILE.LOG,
583: 'Status returned by HZ_GEOGRAPHY_STRUCTURE_PUB.create_zone_type: '||l_return_status||', and message: '||l_msg_data
584: );
585:
586: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
587: THEN