APPS.ZX_GEO_JUR_MIGR_PKG dependencies on HZ_GEOGRAPHY_STRUCTURE_PUB

Line 78: l_geography_type_rec HZ_GEOGRAPHY_STRUCTURE_PUB.GEOGRAPHY_TYPE_REC_TYPE;

74: AND segment_attribute_type NOT IN ('TAX_ACCOUNT', 'EXEMPT_LEVEL')
75: GROUP BY segment_attribute_type;
76:
77: l_geo_type VARCHAR2(30);
78: l_geography_type_rec HZ_GEOGRAPHY_STRUCTURE_PUB.GEOGRAPHY_TYPE_REC_TYPE;
79: x_geography_type VARCHAR2(30);
80: x_return_status VARCHAR2(1);
81: x_msg_count NUMBER;
82: x_msg_data VARCHAR2(2000);

Line 93: HZ_GEOGRAPHY_STRUCTURE_PUB.create_geography_type('T',

89: l_geography_type_rec.application_id := 235;
90:
91: -- Create Postal Code also though it is not in use in any structure.
92:
93: HZ_GEOGRAPHY_STRUCTURE_PUB.create_geography_type('T',
94: l_geography_type_rec,
95: x_return_status,
96: x_msg_count,
97: x_msg_data);

Line 104: HZ_GEOGRAPHY_STRUCTURE_PUB.create_geography_type('T',

100: l_geography_type_rec.created_by_module := 'EBTAX_MIGRATION';
101: l_geography_type_rec.application_id := 235;
102:
103:
104: HZ_GEOGRAPHY_STRUCTURE_PUB.create_geography_type('T',
105: l_geography_type_rec,
106: x_return_status,
107: x_msg_count,
108: x_msg_data);

Line 115: l_zone_type_rec HZ_GEOGRAPHY_STRUCTURE_PUB.ZONE_TYPE_REC_TYPE;

111:
112: END;
113:
114: PROCEDURE CREATE_ZONE_TYPE IS
115: l_zone_type_rec HZ_GEOGRAPHY_STRUCTURE_PUB.ZONE_TYPE_REC_TYPE;
116: TYPE seg_attr_type_tbl IS TABLE OF VARCHAR2(30) INDEX BY binary_integer;
117: l_segment_attribute_type_tbl seg_attr_type_tbl;
118: TYPE country_code_tbl IS TABLE OF VARCHAR2(60) INDEX BY BINARY_INTEGER;
119: l_country_code_tbl country_code_tbl;

Line 124: l_incl_geo_type HZ_GEOGRAPHY_STRUCTURE_PUB.INCL_GEO_TYPE_TBL_TYPE;

120: TYPE location_structure_id_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
121: l_location_structure_id_tbl location_structure_id_tbl;
122: TYPE geography_id_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
123: l_geography_id_tbl geography_id_tbl;
124: l_incl_geo_type HZ_GEOGRAPHY_STRUCTURE_PUB.INCL_GEO_TYPE_TBL_TYPE;
125: l_incl_geo_type1 HZ_GEOGRAPHY_STRUCTURE_PUB.INCL_GEO_TYPE_TBL_TYPE;
126: l_geo_rel_type_rec HZ_GEOGRAPHY_STRUCTURE_PUB.GEO_REL_TYPE_REC_TYPE;
127: n BINARY_INTEGER;
128: l_geography_id NUMBER;

Line 125: l_incl_geo_type1 HZ_GEOGRAPHY_STRUCTURE_PUB.INCL_GEO_TYPE_TBL_TYPE;

121: l_location_structure_id_tbl location_structure_id_tbl;
122: TYPE geography_id_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
123: l_geography_id_tbl geography_id_tbl;
124: l_incl_geo_type HZ_GEOGRAPHY_STRUCTURE_PUB.INCL_GEO_TYPE_TBL_TYPE;
125: l_incl_geo_type1 HZ_GEOGRAPHY_STRUCTURE_PUB.INCL_GEO_TYPE_TBL_TYPE;
126: l_geo_rel_type_rec HZ_GEOGRAPHY_STRUCTURE_PUB.GEO_REL_TYPE_REC_TYPE;
127: n BINARY_INTEGER;
128: l_geography_id NUMBER;
129: l_prev_structure_id NUMBER := -99;

Line 126: l_geo_rel_type_rec HZ_GEOGRAPHY_STRUCTURE_PUB.GEO_REL_TYPE_REC_TYPE;

122: TYPE geography_id_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
123: l_geography_id_tbl geography_id_tbl;
124: l_incl_geo_type HZ_GEOGRAPHY_STRUCTURE_PUB.INCL_GEO_TYPE_TBL_TYPE;
125: l_incl_geo_type1 HZ_GEOGRAPHY_STRUCTURE_PUB.INCL_GEO_TYPE_TBL_TYPE;
126: l_geo_rel_type_rec HZ_GEOGRAPHY_STRUCTURE_PUB.GEO_REL_TYPE_REC_TYPE;
127: n BINARY_INTEGER;
128: l_geography_id NUMBER;
129: l_prev_structure_id NUMBER := -99;
130: l_prev_country_code VARCHAR2(10) := '-1';

Line 187: HZ_GEOGRAPHY_STRUCTURE_PUB.create_zone_type('F',l_zone_type_rec,

183: l_zone_type_rec.limited_by_geography_id := l_geography_id_tbl(i);
184: END IF;
185: l_zone_type_rec.created_by_module := 'EBTAX_MIGRATION';
186: l_zone_type_rec.application_id := 235;
187: HZ_GEOGRAPHY_STRUCTURE_PUB.create_zone_type('F',l_zone_type_rec,
188: x_return_status,
189: x_msg_count,
190: x_msg_data);
191: IF l_country_code_tbl(i) = 'US' THEN

Line 203: HZ_GEOGRAPHY_STRUCTURE_PUB.create_zone_type('F',l_zone_type_rec,

199: l_zone_type_rec.geography_use := 'TAX';
200: l_zone_type_rec.limited_by_geography_id := l_geography_id_tbl(i);
201: l_zone_type_rec.created_by_module := 'EBTAX_MIGRATION';
202: l_zone_type_rec.application_id := 235;
203: HZ_GEOGRAPHY_STRUCTURE_PUB.create_zone_type('F',l_zone_type_rec,
204: x_return_status,
205: x_msg_count,
206: x_msg_data);
207: END IF;

Line 220: HZ_GEOGRAPHY_STRUCTURE_PUB.create_zone_type('F',l_zone_type_rec,

216: l_zone_type_rec.geography_use := 'TAX';
217: l_zone_type_rec.limited_by_geography_id := l_geography_id_tbl(i);
218: l_zone_type_rec.created_by_module := 'EBTAX_MIGRATION';
219: l_zone_type_rec.application_id := 235;
220: HZ_GEOGRAPHY_STRUCTURE_PUB.create_zone_type('F',l_zone_type_rec,
221: x_return_status,
222: x_msg_count,
223: x_msg_data);
224: END IF;

Line 237: HZ_GEOGRAPHY_STRUCTURE_PUB.create_geo_rel_type(

233: l_geo_rel_type_rec.created_by_module := 'EBTAX_MIGRATION';
234: l_geo_rel_type_rec.application_id := 235;
235:
236:
237: HZ_GEOGRAPHY_STRUCTURE_PUB.create_geo_rel_type(
238: p_init_msg_list => 'F',
239: p_geo_rel_type_rec => l_geo_rel_type_rec,
240: x_relationship_type_id => x_relationship_type_id,
241: x_return_status => x_return_status,