eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_TCM_GEO_JUR_PKG dependencies on ZX_GLOBAL_STRUCTURES_PKG

Line 17: g_geography_use_info_tbl zx_global_Structures_pkg.geography_use_info_tbl_type;

13:
14: TYPE geography_id_type is TABLE OF NUMBER INDEX BY BINARY_INTEGER;
15: l_jurisdiction_rec_tmp_tbl tax_jurisdiction_rec_tbl_type;
16:
17: g_geography_use_info_tbl zx_global_Structures_pkg.geography_use_info_tbl_type;
18: -- this table is used in jurisdictions API to get geography types and uses for a given tax
19: -- and this structure is value for the whole session.
20:
21: g_geo_name_references_tbl zx_global_structures_pkg.geo_name_references_tbl_type;

Line 21: g_geo_name_references_tbl zx_global_structures_pkg.geo_name_references_tbl_type;

17: g_geography_use_info_tbl zx_global_Structures_pkg.geography_use_info_tbl_type;
18: -- this table is used in jurisdictions API to get geography types and uses for a given tax
19: -- and this structure is value for the whole session.
20:
21: g_geo_name_references_tbl zx_global_structures_pkg.geo_name_references_tbl_type;
22: -- this table is used in get_zone API to get geo name reference for a given location_id
23: -- and this structure is value for the whole session.
24:
25: PROCEDURE get_location_info(p_location_id IN NUMBER,

Line 27: x_location_info_rec OUT NOCOPY zx_global_Structures_pkg.loc_info_rec_type,

23: -- and this structure is value for the whole session.
24:
25: PROCEDURE get_location_info(p_location_id IN NUMBER,
26: p_location_table_name IN VARCHAR2 default NULL,
27: x_location_info_rec OUT NOCOPY zx_global_Structures_pkg.loc_info_rec_type,
28: x_return_status OUT NOCOPY VARCHAR2);
29:
30: PROCEDURE get_pos_loc_or_site(p_party_type IN VARCHAR2,
31: x_loc_tbl OUT NOCOPY VARCHAR2,

Line 69: IF (ZX_GLOBAL_STRUCTURES_PKG.ZX_PARTY_TYPES_CACHE.exists(l_party_type_tbl_idx)) THEN

65: x_return_status := FND_API.G_RET_STS_SUCCESS;
66:
67: l_party_type_tbl_idx := dbms_utility.get_hash_value(p_party_type, 1, 8192);
68:
69: IF (ZX_GLOBAL_STRUCTURES_PKG.ZX_PARTY_TYPES_CACHE.exists(l_party_type_tbl_idx)) THEN
70: x_loc_tbl := ZX_GLOBAL_STRUCTURES_PKG.ZX_PARTY_TYPES_CACHE(l_party_type_tbl_idx).LOCATION_SOURCE_TABLE;
71:
72: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
73: l_log_msg := 'Found the party type information in cache for:'||p_party_type;

Line 70: x_loc_tbl := ZX_GLOBAL_STRUCTURES_PKG.ZX_PARTY_TYPES_CACHE(l_party_type_tbl_idx).LOCATION_SOURCE_TABLE;

66:
67: l_party_type_tbl_idx := dbms_utility.get_hash_value(p_party_type, 1, 8192);
68:
69: IF (ZX_GLOBAL_STRUCTURES_PKG.ZX_PARTY_TYPES_CACHE.exists(l_party_type_tbl_idx)) THEN
70: x_loc_tbl := ZX_GLOBAL_STRUCTURES_PKG.ZX_PARTY_TYPES_CACHE(l_party_type_tbl_idx).LOCATION_SOURCE_TABLE;
71:
72: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
73: l_log_msg := 'Found the party type information in cache for:'||p_party_type;
74: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

Line 84: ZX_GLOBAL_STRUCTURES_PKG.ZX_PARTY_TYPES_CACHE(l_idx).PARTY_TYPE_CODE

80: LOOP
81:
82: l_idx := dbms_utility.get_hash_value(c_party_type_rec.party_type_code, 1, 8192);
83:
84: ZX_GLOBAL_STRUCTURES_PKG.ZX_PARTY_TYPES_CACHE(l_idx).PARTY_TYPE_CODE
85: := c_party_type_rec.PARTY_TYPE_CODE;
86: ZX_GLOBAL_STRUCTURES_PKG.ZX_PARTY_TYPES_CACHE(l_idx).PARTY_SOURCE_TABLE
87: := c_party_type_rec.PARTY_SOURCE_TABLE;
88: ZX_GLOBAL_STRUCTURES_PKG.ZX_PARTY_TYPES_CACHE(l_idx).PARTY_SOURCE_COLUMN

Line 86: ZX_GLOBAL_STRUCTURES_PKG.ZX_PARTY_TYPES_CACHE(l_idx).PARTY_SOURCE_TABLE

82: l_idx := dbms_utility.get_hash_value(c_party_type_rec.party_type_code, 1, 8192);
83:
84: ZX_GLOBAL_STRUCTURES_PKG.ZX_PARTY_TYPES_CACHE(l_idx).PARTY_TYPE_CODE
85: := c_party_type_rec.PARTY_TYPE_CODE;
86: ZX_GLOBAL_STRUCTURES_PKG.ZX_PARTY_TYPES_CACHE(l_idx).PARTY_SOURCE_TABLE
87: := c_party_type_rec.PARTY_SOURCE_TABLE;
88: ZX_GLOBAL_STRUCTURES_PKG.ZX_PARTY_TYPES_CACHE(l_idx).PARTY_SOURCE_COLUMN
89: := c_party_type_rec.PARTY_SOURCE_COLUMN;
90: ZX_GLOBAL_STRUCTURES_PKG.ZX_PARTY_TYPES_CACHE(l_idx).APPLICABLE_TO_EVNT_CLS_FLAG

Line 88: ZX_GLOBAL_STRUCTURES_PKG.ZX_PARTY_TYPES_CACHE(l_idx).PARTY_SOURCE_COLUMN

84: ZX_GLOBAL_STRUCTURES_PKG.ZX_PARTY_TYPES_CACHE(l_idx).PARTY_TYPE_CODE
85: := c_party_type_rec.PARTY_TYPE_CODE;
86: ZX_GLOBAL_STRUCTURES_PKG.ZX_PARTY_TYPES_CACHE(l_idx).PARTY_SOURCE_TABLE
87: := c_party_type_rec.PARTY_SOURCE_TABLE;
88: ZX_GLOBAL_STRUCTURES_PKG.ZX_PARTY_TYPES_CACHE(l_idx).PARTY_SOURCE_COLUMN
89: := c_party_type_rec.PARTY_SOURCE_COLUMN;
90: ZX_GLOBAL_STRUCTURES_PKG.ZX_PARTY_TYPES_CACHE(l_idx).APPLICABLE_TO_EVNT_CLS_FLAG
91: := c_party_type_rec.APPLICABLE_TO_EVNT_CLS_FLAG;
92: ZX_GLOBAL_STRUCTURES_PKG.ZX_PARTY_TYPES_CACHE(l_idx).PARTY_SITE_TYPE

Line 90: ZX_GLOBAL_STRUCTURES_PKG.ZX_PARTY_TYPES_CACHE(l_idx).APPLICABLE_TO_EVNT_CLS_FLAG

86: ZX_GLOBAL_STRUCTURES_PKG.ZX_PARTY_TYPES_CACHE(l_idx).PARTY_SOURCE_TABLE
87: := c_party_type_rec.PARTY_SOURCE_TABLE;
88: ZX_GLOBAL_STRUCTURES_PKG.ZX_PARTY_TYPES_CACHE(l_idx).PARTY_SOURCE_COLUMN
89: := c_party_type_rec.PARTY_SOURCE_COLUMN;
90: ZX_GLOBAL_STRUCTURES_PKG.ZX_PARTY_TYPES_CACHE(l_idx).APPLICABLE_TO_EVNT_CLS_FLAG
91: := c_party_type_rec.APPLICABLE_TO_EVNT_CLS_FLAG;
92: ZX_GLOBAL_STRUCTURES_PKG.ZX_PARTY_TYPES_CACHE(l_idx).PARTY_SITE_TYPE
93: := c_party_type_rec.PARTY_SITE_TYPE;
94: ZX_GLOBAL_STRUCTURES_PKG.ZX_PARTY_TYPES_CACHE(l_idx).LOCATION_SOURCE_TABLE

Line 92: ZX_GLOBAL_STRUCTURES_PKG.ZX_PARTY_TYPES_CACHE(l_idx).PARTY_SITE_TYPE

88: ZX_GLOBAL_STRUCTURES_PKG.ZX_PARTY_TYPES_CACHE(l_idx).PARTY_SOURCE_COLUMN
89: := c_party_type_rec.PARTY_SOURCE_COLUMN;
90: ZX_GLOBAL_STRUCTURES_PKG.ZX_PARTY_TYPES_CACHE(l_idx).APPLICABLE_TO_EVNT_CLS_FLAG
91: := c_party_type_rec.APPLICABLE_TO_EVNT_CLS_FLAG;
92: ZX_GLOBAL_STRUCTURES_PKG.ZX_PARTY_TYPES_CACHE(l_idx).PARTY_SITE_TYPE
93: := c_party_type_rec.PARTY_SITE_TYPE;
94: ZX_GLOBAL_STRUCTURES_PKG.ZX_PARTY_TYPES_CACHE(l_idx).LOCATION_SOURCE_TABLE
95: := c_party_type_rec.LOCATION_SOURCE_TABLE;
96: ZX_GLOBAL_STRUCTURES_PKG.ZX_PARTY_TYPES_CACHE(l_idx).LOCATION_SOURCE_COLUMN

Line 94: ZX_GLOBAL_STRUCTURES_PKG.ZX_PARTY_TYPES_CACHE(l_idx).LOCATION_SOURCE_TABLE

90: ZX_GLOBAL_STRUCTURES_PKG.ZX_PARTY_TYPES_CACHE(l_idx).APPLICABLE_TO_EVNT_CLS_FLAG
91: := c_party_type_rec.APPLICABLE_TO_EVNT_CLS_FLAG;
92: ZX_GLOBAL_STRUCTURES_PKG.ZX_PARTY_TYPES_CACHE(l_idx).PARTY_SITE_TYPE
93: := c_party_type_rec.PARTY_SITE_TYPE;
94: ZX_GLOBAL_STRUCTURES_PKG.ZX_PARTY_TYPES_CACHE(l_idx).LOCATION_SOURCE_TABLE
95: := c_party_type_rec.LOCATION_SOURCE_TABLE;
96: ZX_GLOBAL_STRUCTURES_PKG.ZX_PARTY_TYPES_CACHE(l_idx).LOCATION_SOURCE_COLUMN
97: := c_party_type_rec.LOCATION_SOURCE_COLUMN;
98: END LOOP;

Line 96: ZX_GLOBAL_STRUCTURES_PKG.ZX_PARTY_TYPES_CACHE(l_idx).LOCATION_SOURCE_COLUMN

92: ZX_GLOBAL_STRUCTURES_PKG.ZX_PARTY_TYPES_CACHE(l_idx).PARTY_SITE_TYPE
93: := c_party_type_rec.PARTY_SITE_TYPE;
94: ZX_GLOBAL_STRUCTURES_PKG.ZX_PARTY_TYPES_CACHE(l_idx).LOCATION_SOURCE_TABLE
95: := c_party_type_rec.LOCATION_SOURCE_TABLE;
96: ZX_GLOBAL_STRUCTURES_PKG.ZX_PARTY_TYPES_CACHE(l_idx).LOCATION_SOURCE_COLUMN
97: := c_party_type_rec.LOCATION_SOURCE_COLUMN;
98: END LOOP;
99: x_loc_tbl := ZX_GLOBAL_STRUCTURES_PKG.ZX_PARTY_TYPES_CACHE(l_party_type_tbl_idx).LOCATION_SOURCE_TABLE;
100:

Line 99: x_loc_tbl := ZX_GLOBAL_STRUCTURES_PKG.ZX_PARTY_TYPES_CACHE(l_party_type_tbl_idx).LOCATION_SOURCE_TABLE;

95: := c_party_type_rec.LOCATION_SOURCE_TABLE;
96: ZX_GLOBAL_STRUCTURES_PKG.ZX_PARTY_TYPES_CACHE(l_idx).LOCATION_SOURCE_COLUMN
97: := c_party_type_rec.LOCATION_SOURCE_COLUMN;
98: END LOOP;
99: x_loc_tbl := ZX_GLOBAL_STRUCTURES_PKG.ZX_PARTY_TYPES_CACHE(l_party_type_tbl_idx).LOCATION_SOURCE_TABLE;
100:
101: END IF;
102:
103:

Line 204: x_location_info_rec OUT NOCOPY zx_global_Structures_pkg.loc_info_rec_type,

200: END;
201:
202: PROCEDURE get_location_info( p_location_id IN NUMBER,
203: p_location_table_name IN VARCHAR2 default NULL,
204: x_location_info_rec OUT NOCOPY zx_global_Structures_pkg.loc_info_rec_type,
205: x_return_status OUT NOCOPY VARCHAR2)
206: IS
207: l_loc_country_code hz_locations.country%type;
208: l_procedure_name CONSTANT VARCHAR2(30) := 'get_location_info';

Line 218: IF ZX_GLOBAL_STRUCTURES_PKG.Loc_info_tbl.exists(to_char(p_location_id)) then

214: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name || '.begin', l_log_msg);
215: END IF;
216:
217: x_return_status := FND_API.G_RET_STS_SUCCESS;
218: IF ZX_GLOBAL_STRUCTURES_PKG.Loc_info_tbl.exists(to_char(p_location_id)) then
219:
220: x_location_info_rec := zx_global_Structures_pkg.loc_info_tbl(to_char(p_location_id));
221:
222: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 220: x_location_info_rec := zx_global_Structures_pkg.loc_info_tbl(to_char(p_location_id));

216:
217: x_return_status := FND_API.G_RET_STS_SUCCESS;
218: IF ZX_GLOBAL_STRUCTURES_PKG.Loc_info_tbl.exists(to_char(p_location_id)) then
219:
220: x_location_info_rec := zx_global_Structures_pkg.loc_info_tbl(to_char(p_location_id));
221:
222: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
223: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,
224: 'Found the location info in cache for location id: '||p_location_id||' for table '||

Line 240: zx_global_Structures_pkg.loc_info_tbl(to_char(p_location_id)) := x_location_info_rec;

236: x_location_info_rec.country_code := l_loc_country_code;
237: x_location_info_rec.location_table_name := 'HR_LOCATIONS_ALL';
238: x_location_info_rec.location_id := p_location_id;
239:
240: zx_global_Structures_pkg.loc_info_tbl(to_char(p_location_id)) := x_location_info_rec;
241:
242: EXCEPTION WHEN NO_DATA_FOUND THEN
243:
244: BEGIN

Line 254: zx_global_Structures_pkg.loc_info_tbl(to_char(p_location_id)) := x_location_info_rec;

250: x_location_info_rec.country_code := l_loc_country_code;
251: x_location_info_rec.location_table_name := 'HZ_LOCATIONS';
252: x_location_info_rec. location_id := p_location_id;
253:
254: zx_global_Structures_pkg.loc_info_tbl(to_char(p_location_id)) := x_location_info_rec;
255:
256:
257: EXCEPTION WHEN NO_DATA_FOUND THEN
258: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 283: zx_global_Structures_pkg.loc_info_tbl(to_char(p_location_id)) := x_location_info_rec;

279: x_location_info_rec.country_code := l_loc_country_code;
280: x_location_info_rec.location_table_name := 'HZ_LOCATIONS';
281: x_location_info_rec. location_id := p_location_id;
282:
283: zx_global_Structures_pkg.loc_info_tbl(to_char(p_location_id)) := x_location_info_rec;
284:
285: EXCEPTION WHEN NO_DATA_FOUND THEN
286:
287: BEGIN

Line 297: zx_global_Structures_pkg.loc_info_tbl(to_char(p_location_id)) := x_location_info_rec;

293: x_location_info_rec.country_code := l_loc_country_code;
294: x_location_info_rec.location_table_name := 'HR_LOCATIONS_ALL';
295: x_location_info_rec. location_id := p_location_id;
296:
297: zx_global_Structures_pkg.loc_info_tbl(to_char(p_location_id)) := x_location_info_rec;
298:
299:
300: EXCEPTION WHEN NO_DATA_FOUND THEN
301: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 623: l_location_info_rec ZX_GLOBAL_STRUCTURES_PKG.loc_info_rec_type;

619: -- calling place to compile. Needs to be removed later...
620: l_init_msg_list VARCHAR2(30);
621: x_msg_count NUMBER;
622: x_msg_data VARCHAR2(2000);
623: l_location_info_rec ZX_GLOBAL_STRUCTURES_PKG.loc_info_rec_type;
624:
625: l_geography_type_index BINARY_INTEGER;
626: l_geography_type hz_geography_types_b.geography_type%TYPE;
627: l_geography_use hz_geography_types_b.geography_use%TYPE;

Line 649: IF ZX_GLOBAL_STRUCTURES_PKG.Loc_info_tbl.exists(to_char(p_location_id)) then

645:
646: x_return_status := FND_API.G_RET_STS_SUCCESS;
647:
648: -- Derive location table name based on location_type
649: IF ZX_GLOBAL_STRUCTURES_PKG.Loc_info_tbl.exists(to_char(p_location_id)) then
650:
651: l_loc_country_code := ZX_GLOBAL_STRUCTURES_PKG.Loc_info_tbl(to_char(p_location_id)).country_code;
652: x_location_table_name := ZX_GLOBAL_STRUCTURES_PKG.Loc_info_tbl(to_char(p_location_id)).location_table_name;
653: ELSE

Line 651: l_loc_country_code := ZX_GLOBAL_STRUCTURES_PKG.Loc_info_tbl(to_char(p_location_id)).country_code;

647:
648: -- Derive location table name based on location_type
649: IF ZX_GLOBAL_STRUCTURES_PKG.Loc_info_tbl.exists(to_char(p_location_id)) then
650:
651: l_loc_country_code := ZX_GLOBAL_STRUCTURES_PKG.Loc_info_tbl(to_char(p_location_id)).country_code;
652: x_location_table_name := ZX_GLOBAL_STRUCTURES_PKG.Loc_info_tbl(to_char(p_location_id)).location_table_name;
653: ELSE
654:
655: get_location_table_name(p_location_type,

Line 652: x_location_table_name := ZX_GLOBAL_STRUCTURES_PKG.Loc_info_tbl(to_char(p_location_id)).location_table_name;

648: -- Derive location table name based on location_type
649: IF ZX_GLOBAL_STRUCTURES_PKG.Loc_info_tbl.exists(to_char(p_location_id)) then
650:
651: l_loc_country_code := ZX_GLOBAL_STRUCTURES_PKG.Loc_info_tbl(to_char(p_location_id)).country_code;
652: x_location_table_name := ZX_GLOBAL_STRUCTURES_PKG.Loc_info_tbl(to_char(p_location_id)).location_table_name;
653: ELSE
654:
655: get_location_table_name(p_location_type,
656: x_location_table_name);

Line 666: x_location_table_name := ZX_GLOBAL_STRUCTURES_PKG.Loc_info_tbl(to_char(p_location_id)).location_table_name;

662: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
663: END IF;
664:
665: get_location_info(p_location_id, x_location_table_name, l_location_info_rec, x_return_status);
666: x_location_table_name := ZX_GLOBAL_STRUCTURES_PKG.Loc_info_tbl(to_char(p_location_id)).location_table_name;
667:
668: l_loc_country_code := l_location_info_rec.country_code;
669:
670: END IF;

Line 675: IF ZX_GLOBAL_STRUCTURES_PKG.g_geography_type_info_tbl.exists(l_geography_type_index)

671:
672: l_geography_type_index := dbms_utility.get_hash_value(p_zone_type, 1, 8192);
673:
674: --bug8251315
675: IF ZX_GLOBAL_STRUCTURES_PKG.g_geography_type_info_tbl.exists(l_geography_type_index)
676: AND ZX_GLOBAL_STRUCTURES_PKG.g_geography_type_info_tbl(l_geography_type_index).zone_type = p_zone_type THEN
677: l_limited_by_geography_id :=
678: ZX_GLOBAL_STRUCTURES_PKG.g_geography_type_info_tbl(l_geography_type_index).limited_by_geography_id;
679:

Line 676: AND ZX_GLOBAL_STRUCTURES_PKG.g_geography_type_info_tbl(l_geography_type_index).zone_type = p_zone_type THEN

672: l_geography_type_index := dbms_utility.get_hash_value(p_zone_type, 1, 8192);
673:
674: --bug8251315
675: IF ZX_GLOBAL_STRUCTURES_PKG.g_geography_type_info_tbl.exists(l_geography_type_index)
676: AND ZX_GLOBAL_STRUCTURES_PKG.g_geography_type_info_tbl(l_geography_type_index).zone_type = p_zone_type THEN
677: l_limited_by_geography_id :=
678: ZX_GLOBAL_STRUCTURES_PKG.g_geography_type_info_tbl(l_geography_type_index).limited_by_geography_id;
679:
680: ELSE

Line 678: ZX_GLOBAL_STRUCTURES_PKG.g_geography_type_info_tbl(l_geography_type_index).limited_by_geography_id;

674: --bug8251315
675: IF ZX_GLOBAL_STRUCTURES_PKG.g_geography_type_info_tbl.exists(l_geography_type_index)
676: AND ZX_GLOBAL_STRUCTURES_PKG.g_geography_type_info_tbl(l_geography_type_index).zone_type = p_zone_type THEN
677: l_limited_by_geography_id :=
678: ZX_GLOBAL_STRUCTURES_PKG.g_geography_type_info_tbl(l_geography_type_index).limited_by_geography_id;
679:
680: ELSE
681:
682: open C_GEOGRAPHY_TYPES(p_zone_type);

Line 689: ZX_GLOBAL_STRUCTURES_PKG.g_geography_type_info_tbl(l_geography_type_index).geography_type := l_geography_type;

685: l_geography_use,
686: l_limited_by_geography_id;
687: close C_GEOGRAPHY_TYPES;
688:
689: ZX_GLOBAL_STRUCTURES_PKG.g_geography_type_info_tbl(l_geography_type_index).geography_type := l_geography_type;
690: ZX_GLOBAL_STRUCTURES_PKG.g_geography_type_info_tbl(l_geography_type_index).geography_use := l_geography_use;
691: ZX_GLOBAL_STRUCTURES_PKG.g_geography_type_info_tbl(l_geography_type_index).limited_by_geography_id := l_limited_by_geography_id;
692: --bug8251315
693: ZX_GLOBAL_STRUCTURES_PKG.g_geography_type_info_tbl(l_geography_type_index).zone_type := p_zone_type;

Line 690: ZX_GLOBAL_STRUCTURES_PKG.g_geography_type_info_tbl(l_geography_type_index).geography_use := l_geography_use;

686: l_limited_by_geography_id;
687: close C_GEOGRAPHY_TYPES;
688:
689: ZX_GLOBAL_STRUCTURES_PKG.g_geography_type_info_tbl(l_geography_type_index).geography_type := l_geography_type;
690: ZX_GLOBAL_STRUCTURES_PKG.g_geography_type_info_tbl(l_geography_type_index).geography_use := l_geography_use;
691: ZX_GLOBAL_STRUCTURES_PKG.g_geography_type_info_tbl(l_geography_type_index).limited_by_geography_id := l_limited_by_geography_id;
692: --bug8251315
693: ZX_GLOBAL_STRUCTURES_PKG.g_geography_type_info_tbl(l_geography_type_index).zone_type := p_zone_type;
694:

Line 691: ZX_GLOBAL_STRUCTURES_PKG.g_geography_type_info_tbl(l_geography_type_index).limited_by_geography_id := l_limited_by_geography_id;

687: close C_GEOGRAPHY_TYPES;
688:
689: ZX_GLOBAL_STRUCTURES_PKG.g_geography_type_info_tbl(l_geography_type_index).geography_type := l_geography_type;
690: ZX_GLOBAL_STRUCTURES_PKG.g_geography_type_info_tbl(l_geography_type_index).geography_use := l_geography_use;
691: ZX_GLOBAL_STRUCTURES_PKG.g_geography_type_info_tbl(l_geography_type_index).limited_by_geography_id := l_limited_by_geography_id;
692: --bug8251315
693: ZX_GLOBAL_STRUCTURES_PKG.g_geography_type_info_tbl(l_geography_type_index).zone_type := p_zone_type;
694:
695: END IF;

Line 693: ZX_GLOBAL_STRUCTURES_PKG.g_geography_type_info_tbl(l_geography_type_index).zone_type := p_zone_type;

689: ZX_GLOBAL_STRUCTURES_PKG.g_geography_type_info_tbl(l_geography_type_index).geography_type := l_geography_type;
690: ZX_GLOBAL_STRUCTURES_PKG.g_geography_type_info_tbl(l_geography_type_index).geography_use := l_geography_use;
691: ZX_GLOBAL_STRUCTURES_PKG.g_geography_type_info_tbl(l_geography_type_index).limited_by_geography_id := l_limited_by_geography_id;
692: --bug8251315
693: ZX_GLOBAL_STRUCTURES_PKG.g_geography_type_info_tbl(l_geography_type_index).zone_type := p_zone_type;
694:
695: END IF;
696:
697: IF l_limited_by_geography_id IS NOT NULL THEN

Line 768: IF ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl.EXISTS(l_zone_indx) AND

764: p_location_type || '|' ||
765: p_zone_type || '|' ||
766: p_trx_date || '|' ||
767: to_char(1);
768: IF ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl.EXISTS(l_zone_indx) AND
769: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).location_id = p_location_id AND
770: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).location_type = p_location_type AND
771: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).zone_type = p_zone_type AND
772: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).indx_value = l_zone_indx AND

Line 769: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).location_id = p_location_id AND

765: p_zone_type || '|' ||
766: p_trx_date || '|' ||
767: to_char(1);
768: IF ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl.EXISTS(l_zone_indx) AND
769: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).location_id = p_location_id AND
770: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).location_type = p_location_type AND
771: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).zone_type = p_zone_type AND
772: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).indx_value = l_zone_indx AND
773: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).value = 1 THEN

Line 770: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).location_type = p_location_type AND

766: p_trx_date || '|' ||
767: to_char(1);
768: IF ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl.EXISTS(l_zone_indx) AND
769: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).location_id = p_location_id AND
770: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).location_type = p_location_type AND
771: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).zone_type = p_zone_type AND
772: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).indx_value = l_zone_indx AND
773: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).value = 1 THEN
774:

Line 771: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).zone_type = p_zone_type AND

767: to_char(1);
768: IF ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl.EXISTS(l_zone_indx) AND
769: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).location_id = p_location_id AND
770: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).location_type = p_location_type AND
771: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).zone_type = p_zone_type AND
772: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).indx_value = l_zone_indx AND
773: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).value = 1 THEN
774:
775: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 772: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).indx_value = l_zone_indx AND

768: IF ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl.EXISTS(l_zone_indx) AND
769: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).location_id = p_location_id AND
770: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).location_type = p_location_type AND
771: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).zone_type = p_zone_type AND
772: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).indx_value = l_zone_indx AND
773: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).value = 1 THEN
774:
775: IF (g_level_statement >= g_current_runtime_level ) THEN
776: FND_LOG.STRING(g_level_statement,

Line 773: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).value = 1 THEN

769: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).location_id = p_location_id AND
770: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).location_type = p_location_type AND
771: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).zone_type = p_zone_type AND
772: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).indx_value = l_zone_indx AND
773: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).value = 1 THEN
774:
775: IF (g_level_statement >= g_current_runtime_level ) THEN
776: FND_LOG.STRING(g_level_statement,
777: G_MODULE_NAME || l_procedure_name,

Line 788: IF NOT ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl.EXISTS(l_zone_indx) THEN

784: p_location_type || '|' ||
785: p_zone_type || '|' ||
786: p_trx_date || '|' ||
787: to_char(l);
788: IF NOT ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl.EXISTS(l_zone_indx) THEN
789: EXIT;
790: END IF;
791: p_zone_tbl(l).zone_id := ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).zone_id;
792: p_zone_tbl(l).zone_name := ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).zone_name;

Line 791: p_zone_tbl(l).zone_id := ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).zone_id;

787: to_char(l);
788: IF NOT ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl.EXISTS(l_zone_indx) THEN
789: EXIT;
790: END IF;
791: p_zone_tbl(l).zone_id := ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).zone_id;
792: p_zone_tbl(l).zone_name := ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).zone_name;
793: p_zone_tbl(l).zone_code := ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).zone_code;
794: p_zone_tbl(l).zone_type := ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).zone_type;
795: l := l + 1;

Line 792: p_zone_tbl(l).zone_name := ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).zone_name;

788: IF NOT ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl.EXISTS(l_zone_indx) THEN
789: EXIT;
790: END IF;
791: p_zone_tbl(l).zone_id := ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).zone_id;
792: p_zone_tbl(l).zone_name := ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).zone_name;
793: p_zone_tbl(l).zone_code := ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).zone_code;
794: p_zone_tbl(l).zone_type := ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).zone_type;
795: l := l + 1;
796: END LOOP;

Line 793: p_zone_tbl(l).zone_code := ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).zone_code;

789: EXIT;
790: END IF;
791: p_zone_tbl(l).zone_id := ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).zone_id;
792: p_zone_tbl(l).zone_name := ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).zone_name;
793: p_zone_tbl(l).zone_code := ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).zone_code;
794: p_zone_tbl(l).zone_type := ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).zone_type;
795: l := l + 1;
796: END LOOP;
797: x_zone_tbl := p_zone_tbl;

Line 794: p_zone_tbl(l).zone_type := ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).zone_type;

790: END IF;
791: p_zone_tbl(l).zone_id := ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).zone_id;
792: p_zone_tbl(l).zone_name := ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).zone_name;
793: p_zone_tbl(l).zone_code := ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).zone_code;
794: p_zone_tbl(l).zone_type := ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).zone_type;
795: l := l + 1;
796: END LOOP;
797: x_zone_tbl := p_zone_tbl;
798: ELSE

Line 855: IF ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl.EXISTS(l_zone_indx) THEN

851: p_location_type || '|' ||
852: p_zone_type || '|' ||
853: p_trx_date || '|' ||
854: to_char(i);
855: IF ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl.EXISTS(l_zone_indx) THEN
856: IF (g_level_unexpected >= g_current_runtime_level ) THEN
857: FND_LOG.STRING(g_level_unexpected,
858: 'ZX.PLSQL.ZX_TCM_GEO_JUR_PKG.get_zone',
859: 'Caching issue can cause incorrect tax calculation.');

Line 863: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).zone_id := x_zone_tbl(x_zone_tbl.first+i-1).zone_id;

859: 'Caching issue can cause incorrect tax calculation.');
860: END IF;
861: END IF;
862:
863: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).zone_id := x_zone_tbl(x_zone_tbl.first+i-1).zone_id;
864: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).zone_name := x_zone_tbl(x_zone_tbl.first+i-1).zone_name;
865: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).zone_code := x_zone_tbl(x_zone_tbl.first+i-1).zone_code;
866: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).zone_type := x_zone_tbl(x_zone_tbl.first+i-1).zone_type;
867: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).location_id := p_location_id;

Line 864: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).zone_name := x_zone_tbl(x_zone_tbl.first+i-1).zone_name;

860: END IF;
861: END IF;
862:
863: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).zone_id := x_zone_tbl(x_zone_tbl.first+i-1).zone_id;
864: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).zone_name := x_zone_tbl(x_zone_tbl.first+i-1).zone_name;
865: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).zone_code := x_zone_tbl(x_zone_tbl.first+i-1).zone_code;
866: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).zone_type := x_zone_tbl(x_zone_tbl.first+i-1).zone_type;
867: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).location_id := p_location_id;
868: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).location_type := p_location_type;

Line 865: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).zone_code := x_zone_tbl(x_zone_tbl.first+i-1).zone_code;

861: END IF;
862:
863: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).zone_id := x_zone_tbl(x_zone_tbl.first+i-1).zone_id;
864: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).zone_name := x_zone_tbl(x_zone_tbl.first+i-1).zone_name;
865: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).zone_code := x_zone_tbl(x_zone_tbl.first+i-1).zone_code;
866: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).zone_type := x_zone_tbl(x_zone_tbl.first+i-1).zone_type;
867: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).location_id := p_location_id;
868: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).location_type := p_location_type;
869: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).trx_date := p_trx_date;

Line 866: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).zone_type := x_zone_tbl(x_zone_tbl.first+i-1).zone_type;

862:
863: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).zone_id := x_zone_tbl(x_zone_tbl.first+i-1).zone_id;
864: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).zone_name := x_zone_tbl(x_zone_tbl.first+i-1).zone_name;
865: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).zone_code := x_zone_tbl(x_zone_tbl.first+i-1).zone_code;
866: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).zone_type := x_zone_tbl(x_zone_tbl.first+i-1).zone_type;
867: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).location_id := p_location_id;
868: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).location_type := p_location_type;
869: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).trx_date := p_trx_date;
870: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).indx_value := l_zone_indx;

Line 867: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).location_id := p_location_id;

863: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).zone_id := x_zone_tbl(x_zone_tbl.first+i-1).zone_id;
864: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).zone_name := x_zone_tbl(x_zone_tbl.first+i-1).zone_name;
865: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).zone_code := x_zone_tbl(x_zone_tbl.first+i-1).zone_code;
866: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).zone_type := x_zone_tbl(x_zone_tbl.first+i-1).zone_type;
867: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).location_id := p_location_id;
868: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).location_type := p_location_type;
869: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).trx_date := p_trx_date;
870: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).indx_value := l_zone_indx;
871: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).value := i;

Line 868: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).location_type := p_location_type;

864: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).zone_name := x_zone_tbl(x_zone_tbl.first+i-1).zone_name;
865: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).zone_code := x_zone_tbl(x_zone_tbl.first+i-1).zone_code;
866: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).zone_type := x_zone_tbl(x_zone_tbl.first+i-1).zone_type;
867: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).location_id := p_location_id;
868: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).location_type := p_location_type;
869: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).trx_date := p_trx_date;
870: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).indx_value := l_zone_indx;
871: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).value := i;
872:

Line 869: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).trx_date := p_trx_date;

865: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).zone_code := x_zone_tbl(x_zone_tbl.first+i-1).zone_code;
866: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).zone_type := x_zone_tbl(x_zone_tbl.first+i-1).zone_type;
867: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).location_id := p_location_id;
868: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).location_type := p_location_type;
869: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).trx_date := p_trx_date;
870: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).indx_value := l_zone_indx;
871: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).value := i;
872:
873: END LOOP;

Line 870: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).indx_value := l_zone_indx;

866: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).zone_type := x_zone_tbl(x_zone_tbl.first+i-1).zone_type;
867: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).location_id := p_location_id;
868: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).location_type := p_location_type;
869: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).trx_date := p_trx_date;
870: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).indx_value := l_zone_indx;
871: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).value := i;
872:
873: END LOOP;
874:

Line 871: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).value := i;

867: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).location_id := p_location_id;
868: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).location_type := p_location_type;
869: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).trx_date := p_trx_date;
870: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).indx_value := l_zone_indx;
871: ZX_GLOBAL_STRUCTURES_PKG.g_hz_zone_tbl(l_zone_indx).value := i;
872:
873: END LOOP;
874:
875: END IF;

Line 976: l_tax_regime_rec zx_global_structures_pkg.tax_regime_rec_type;

972: -- Logging Infra
973: l_procedure_name CONSTANT VARCHAR2(30) := 'get_tax_jurisdictions';
974: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
975: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;
976: l_tax_regime_rec zx_global_structures_pkg.tax_regime_rec_type;
977:
978: l_tbl_index BINARY_INTEGER;
979: i NUMBER;
980: l_location_info_rec ZX_GLOBAL_STRUCTURES_PKG.loc_info_rec_type;

Line 980: l_location_info_rec ZX_GLOBAL_STRUCTURES_PKG.loc_info_rec_type;

976: l_tax_regime_rec zx_global_structures_pkg.tax_regime_rec_type;
977:
978: l_tbl_index BINARY_INTEGER;
979: i NUMBER;
980: l_location_info_rec ZX_GLOBAL_STRUCTURES_PKG.loc_info_rec_type;
981:
982: BEGIN
983:
984: -- Logging Infra: Setting up runtime message level

Line 1463: l_location_info_rec ZX_GLOBAL_STRUCTURES_PKG.loc_info_rec_type;

1459: -- Logging Infra
1460: l_procedure_name CONSTANT VARCHAR2(30) := 'get_master_geography';
1461: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1462:
1463: l_location_info_rec ZX_GLOBAL_STRUCTURES_PKG.loc_info_rec_type;
1464: l_geography_use hz_geographies.geography_use%type;
1465: l_tbl_index binary_integer;
1466: l_tbl_country_index binary_integer;
1467:

Line 1511: x_location_table_name := ZX_GLOBAL_STRUCTURES_PKG.Loc_info_tbl(to_char(p_location_id)).location_table_name;

1507: */
1508: get_location_table_name(p_location_type,
1509: x_location_table_name);
1510: get_location_info(p_location_id, x_location_table_name, l_location_info_rec,x_return_status);
1511: x_location_table_name := ZX_GLOBAL_STRUCTURES_PKG.Loc_info_tbl(to_char(p_location_id)).location_table_name;
1512:
1513:
1514: -- Logging Infra: Statement level: "B" means "B"reak point
1515: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1529: IF zx_global_structures_pkg.Loc_geography_info_tbl.exists(l_tbl_index) AND

1525: to_char(p_location_id)||p_geography_type,
1526: 1,
1527: 8192);
1528:
1529: IF zx_global_structures_pkg.Loc_geography_info_tbl.exists(l_tbl_index) AND
1530: (zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).location_id = p_location_id AND
1531: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_type = p_geography_type) THEN
1532:
1533: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 1530: (zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).location_id = p_location_id AND

1526: 1,
1527: 8192);
1528:
1529: IF zx_global_structures_pkg.Loc_geography_info_tbl.exists(l_tbl_index) AND
1530: (zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).location_id = p_location_id AND
1531: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_type = p_geography_type) THEN
1532:
1533: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1534: l_log_msg := 'Found the geography id and geography name info in cache';

Line 1531: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_type = p_geography_type) THEN

1527: 8192);
1528:
1529: IF zx_global_structures_pkg.Loc_geography_info_tbl.exists(l_tbl_index) AND
1530: (zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).location_id = p_location_id AND
1531: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_type = p_geography_type) THEN
1532:
1533: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1534: l_log_msg := 'Found the geography id and geography name info in cache';
1535: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, l_log_msg);

Line 1538: x_geography_id := zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_id;

1534: l_log_msg := 'Found the geography id and geography name info in cache';
1535: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, l_log_msg);
1536: END IF;
1537:
1538: x_geography_id := zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_id;
1539: x_geography_code := zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_code;
1540: x_geography_name := zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_name;
1541:
1542: ELSE

Line 1539: x_geography_code := zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_code;

1535: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, l_log_msg);
1536: END IF;
1537:
1538: x_geography_id := zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_id;
1539: x_geography_code := zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_code;
1540: x_geography_name := zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_name;
1541:
1542: ELSE
1543:

Line 1540: x_geography_name := zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_name;

1536: END IF;
1537:
1538: x_geography_id := zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_id;
1539: x_geography_code := zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_code;
1540: x_geography_name := zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_name;
1541:
1542: ELSE
1543:
1544: BEGIN

Line 1558: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).location_id := p_location_id;

1554: l_log_msg := 'B: SEL hz_geo_name_ref: out: x_geography_id='||x_geography_id;
1555: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1556: END IF;
1557:
1558: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).location_id := p_location_id;
1559: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_type := p_geography_type;
1560: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_id := x_geography_id;
1561: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_code := x_geography_code;
1562: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_name := x_geography_name;

Line 1559: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_type := p_geography_type;

1555: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1556: END IF;
1557:
1558: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).location_id := p_location_id;
1559: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_type := p_geography_type;
1560: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_id := x_geography_id;
1561: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_code := x_geography_code;
1562: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_name := x_geography_name;
1563: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_use := l_geography_use;

Line 1560: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_id := x_geography_id;

1556: END IF;
1557:
1558: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).location_id := p_location_id;
1559: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_type := p_geography_type;
1560: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_id := x_geography_id;
1561: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_code := x_geography_code;
1562: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_name := x_geography_name;
1563: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_use := l_geography_use;
1564:

Line 1561: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_code := x_geography_code;

1557:
1558: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).location_id := p_location_id;
1559: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_type := p_geography_type;
1560: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_id := x_geography_id;
1561: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_code := x_geography_code;
1562: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_name := x_geography_name;
1563: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_use := l_geography_use;
1564:
1565:

Line 1562: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_name := x_geography_name;

1558: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).location_id := p_location_id;
1559: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_type := p_geography_type;
1560: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_id := x_geography_id;
1561: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_code := x_geography_code;
1562: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_name := x_geography_name;
1563: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_use := l_geography_use;
1564:
1565:
1566: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 1563: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_use := l_geography_use;

1559: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_type := p_geography_type;
1560: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_id := x_geography_id;
1561: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_code := x_geography_code;
1562: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_name := x_geography_name;
1563: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_use := l_geography_use;
1564:
1565:
1566: EXCEPTION WHEN NO_DATA_FOUND THEN
1567:

Line 1691: IF (ZX_GLOBAL_STRUCTURES_PKG.location_hash_tbl.EXISTS(TABLEIDX)) THEN

1687: p_geography_type;
1688:
1689: TABLEIDX := dbms_utility.get_hash_value(hash_string,1,TABLE_SIZE);
1690:
1691: IF (ZX_GLOBAL_STRUCTURES_PKG.location_hash_tbl.EXISTS(TABLEIDX)) THEN
1692: loc_info_idx := ZX_GLOBAL_STRUCTURES_PKG.location_hash_tbl(TABLEIDX);
1693: x_geography_value := ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.geography_value(loc_info_idx);
1694: x_geography_id:= ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.geography_id(loc_info_idx);
1695: x_geo_val_found := TRUE;

Line 1692: loc_info_idx := ZX_GLOBAL_STRUCTURES_PKG.location_hash_tbl(TABLEIDX);

1688:
1689: TABLEIDX := dbms_utility.get_hash_value(hash_string,1,TABLE_SIZE);
1690:
1691: IF (ZX_GLOBAL_STRUCTURES_PKG.location_hash_tbl.EXISTS(TABLEIDX)) THEN
1692: loc_info_idx := ZX_GLOBAL_STRUCTURES_PKG.location_hash_tbl(TABLEIDX);
1693: x_geography_value := ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.geography_value(loc_info_idx);
1694: x_geography_id:= ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.geography_id(loc_info_idx);
1695: x_geo_val_found := TRUE;
1696: ELSE

Line 1693: x_geography_value := ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.geography_value(loc_info_idx);

1689: TABLEIDX := dbms_utility.get_hash_value(hash_string,1,TABLE_SIZE);
1690:
1691: IF (ZX_GLOBAL_STRUCTURES_PKG.location_hash_tbl.EXISTS(TABLEIDX)) THEN
1692: loc_info_idx := ZX_GLOBAL_STRUCTURES_PKG.location_hash_tbl(TABLEIDX);
1693: x_geography_value := ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.geography_value(loc_info_idx);
1694: x_geography_id:= ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.geography_id(loc_info_idx);
1695: x_geo_val_found := TRUE;
1696: ELSE
1697: x_geo_val_found := FALSE;

Line 1694: x_geography_id:= ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.geography_id(loc_info_idx);

1690:
1691: IF (ZX_GLOBAL_STRUCTURES_PKG.location_hash_tbl.EXISTS(TABLEIDX)) THEN
1692: loc_info_idx := ZX_GLOBAL_STRUCTURES_PKG.location_hash_tbl(TABLEIDX);
1693: x_geography_value := ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.geography_value(loc_info_idx);
1694: x_geography_id:= ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.geography_id(loc_info_idx);
1695: x_geo_val_found := TRUE;
1696: ELSE
1697: x_geo_val_found := FALSE;
1698: END IF;

Line 1760: k := ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.event_class_mapping_id.last;

1756: -- END IF;
1757:
1758: n := 1;
1759: idx1 := to_char(event_class_mapping_id)||location_type_tbl(i)||location_id_tbl(i) ||x_loc_tbl|| to_char(n);
1760: k := ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.event_class_mapping_id.last;
1761: IF k IS NOT NULL THEN
1762: k := k + 1;
1763: ELSE
1764: k := 1;

Line 1775: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.event_class_mapping_id(k) :=

1771: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1772: l_log_msg := 'B: Geography found ';
1773: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1774: END IF;
1775: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.event_class_mapping_id(k) :=
1776: event_class_mapping_id;
1777: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_id(k) := trx_id;
1778: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_line_id(k) := trx_line_id;
1779: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_level_type(k) := trx_level_type;

Line 1777: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_id(k) := trx_id;

1773: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1774: END IF;
1775: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.event_class_mapping_id(k) :=
1776: event_class_mapping_id;
1777: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_id(k) := trx_id;
1778: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_line_id(k) := trx_line_id;
1779: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_level_type(k) := trx_level_type;
1780: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_type(k) := location_type_tbl(i);
1781: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_table_name(k) := x_loc_tbl;

Line 1778: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_line_id(k) := trx_line_id;

1774: END IF;
1775: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.event_class_mapping_id(k) :=
1776: event_class_mapping_id;
1777: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_id(k) := trx_id;
1778: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_line_id(k) := trx_line_id;
1779: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_level_type(k) := trx_level_type;
1780: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_type(k) := location_type_tbl(i);
1781: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_table_name(k) := x_loc_tbl;
1782: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_id (k) := location_id_tbl(i);

Line 1779: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_level_type(k) := trx_level_type;

1775: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.event_class_mapping_id(k) :=
1776: event_class_mapping_id;
1777: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_id(k) := trx_id;
1778: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_line_id(k) := trx_line_id;
1779: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_level_type(k) := trx_level_type;
1780: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_type(k) := location_type_tbl(i);
1781: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_table_name(k) := x_loc_tbl;
1782: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_id (k) := location_id_tbl(i);
1783: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_id(k) := g_geography_id_tbl(idx1);

Line 1780: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_type(k) := location_type_tbl(i);

1776: event_class_mapping_id;
1777: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_id(k) := trx_id;
1778: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_line_id(k) := trx_line_id;
1779: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_level_type(k) := trx_level_type;
1780: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_type(k) := location_type_tbl(i);
1781: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_table_name(k) := x_loc_tbl;
1782: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_id (k) := location_id_tbl(i);
1783: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_id(k) := g_geography_id_tbl(idx1);
1784:

Line 1781: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_table_name(k) := x_loc_tbl;

1777: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_id(k) := trx_id;
1778: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_line_id(k) := trx_line_id;
1779: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_level_type(k) := trx_level_type;
1780: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_type(k) := location_type_tbl(i);
1781: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_table_name(k) := x_loc_tbl;
1782: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_id (k) := location_id_tbl(i);
1783: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_id(k) := g_geography_id_tbl(idx1);
1784:
1785: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_type(k) := g_geography_type_tbl(idx1);

Line 1782: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_id (k) := location_id_tbl(i);

1778: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_line_id(k) := trx_line_id;
1779: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_level_type(k) := trx_level_type;
1780: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_type(k) := location_type_tbl(i);
1781: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_table_name(k) := x_loc_tbl;
1782: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_id (k) := location_id_tbl(i);
1783: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_id(k) := g_geography_id_tbl(idx1);
1784:
1785: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_type(k) := g_geography_type_tbl(idx1);
1786: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_value(k) := g_geography_name_tbl(idx1);

Line 1783: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_id(k) := g_geography_id_tbl(idx1);

1779: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_level_type(k) := trx_level_type;
1780: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_type(k) := location_type_tbl(i);
1781: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_table_name(k) := x_loc_tbl;
1782: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_id (k) := location_id_tbl(i);
1783: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_id(k) := g_geography_id_tbl(idx1);
1784:
1785: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_type(k) := g_geography_type_tbl(idx1);
1786: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_value(k) := g_geography_name_tbl(idx1);
1787:

Line 1785: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_type(k) := g_geography_type_tbl(idx1);

1781: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_table_name(k) := x_loc_tbl;
1782: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_id (k) := location_id_tbl(i);
1783: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_id(k) := g_geography_id_tbl(idx1);
1784:
1785: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_type(k) := g_geography_type_tbl(idx1);
1786: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_value(k) := g_geography_name_tbl(idx1);
1787:
1788:
1789: hash_string := to_char(event_class_mapping_id)||'|'||

Line 1786: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_value(k) := g_geography_name_tbl(idx1);

1782: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_id (k) := location_id_tbl(i);
1783: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_id(k) := g_geography_id_tbl(idx1);
1784:
1785: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_type(k) := g_geography_type_tbl(idx1);
1786: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_value(k) := g_geography_name_tbl(idx1);
1787:
1788:
1789: hash_string := to_char(event_class_mapping_id)||'|'||
1790: to_char(trx_id)||'|'||

Line 1799: ZX_GLOBAL_STRUCTURES_PKG.location_hash_tbl(TABLEIDX) := k;

1795: g_geography_type_tbl(idx1);
1796:
1797: TABLEIDX := dbms_utility.get_hash_value(hash_string,1,TABLE_SIZE);
1798:
1799: ZX_GLOBAL_STRUCTURES_PKG.location_hash_tbl(TABLEIDX) := k;
1800:
1801:
1802: -- Logging Infra: Statement level: "B" means "B"reak point
1803: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1869: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.event_class_mapping_id(k) := event_class_mapping_id;

1865: g_geography_type_tbl(idx1) := l_geography_type(m);
1866:
1867: g_geography_name_tbl(idx1) := l_geography_name(m);
1868:
1869: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.event_class_mapping_id(k) := event_class_mapping_id;
1870:
1871: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_id(k) := trx_id;
1872:
1873: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_line_id(k) := trx_line_id;

Line 1871: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_id(k) := trx_id;

1867: g_geography_name_tbl(idx1) := l_geography_name(m);
1868:
1869: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.event_class_mapping_id(k) := event_class_mapping_id;
1870:
1871: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_id(k) := trx_id;
1872:
1873: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_line_id(k) := trx_line_id;
1874:
1875: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_level_type(k) := trx_level_type;

Line 1873: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_line_id(k) := trx_line_id;

1869: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.event_class_mapping_id(k) := event_class_mapping_id;
1870:
1871: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_id(k) := trx_id;
1872:
1873: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_line_id(k) := trx_line_id;
1874:
1875: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_level_type(k) := trx_level_type;
1876:
1877: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_type(k) := location_type_tbl(i);

Line 1875: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_level_type(k) := trx_level_type;

1871: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_id(k) := trx_id;
1872:
1873: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_line_id(k) := trx_line_id;
1874:
1875: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_level_type(k) := trx_level_type;
1876:
1877: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_type(k) := location_type_tbl(i);
1878:
1879: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_table_name(k) := x_loc_tbl;

Line 1877: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_type(k) := location_type_tbl(i);

1873: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_line_id(k) := trx_line_id;
1874:
1875: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_level_type(k) := trx_level_type;
1876:
1877: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_type(k) := location_type_tbl(i);
1878:
1879: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_table_name(k) := x_loc_tbl;
1880:
1881: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_id (k) := location_id_tbl(i);

Line 1879: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_table_name(k) := x_loc_tbl;

1875: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_level_type(k) := trx_level_type;
1876:
1877: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_type(k) := location_type_tbl(i);
1878:
1879: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_table_name(k) := x_loc_tbl;
1880:
1881: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_id (k) := location_id_tbl(i);
1882:
1883: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_id(k) := g_geography_id_tbl(idx1);

Line 1881: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_id (k) := location_id_tbl(i);

1877: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_type(k) := location_type_tbl(i);
1878:
1879: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_table_name(k) := x_loc_tbl;
1880:
1881: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_id (k) := location_id_tbl(i);
1882:
1883: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_id(k) := g_geography_id_tbl(idx1);
1884:
1885: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_type(k) := g_geography_type_tbl(idx1);

Line 1883: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_id(k) := g_geography_id_tbl(idx1);

1879: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_table_name(k) := x_loc_tbl;
1880:
1881: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_id (k) := location_id_tbl(i);
1882:
1883: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_id(k) := g_geography_id_tbl(idx1);
1884:
1885: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_type(k) := g_geography_type_tbl(idx1);
1886:
1887: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_value(k) := g_geography_name_tbl(idx1);

Line 1885: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_type(k) := g_geography_type_tbl(idx1);

1881: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_id (k) := location_id_tbl(i);
1882:
1883: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_id(k) := g_geography_id_tbl(idx1);
1884:
1885: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_type(k) := g_geography_type_tbl(idx1);
1886:
1887: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_value(k) := g_geography_name_tbl(idx1);
1888:
1889: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1887: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_value(k) := g_geography_name_tbl(idx1);

1883: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_id(k) := g_geography_id_tbl(idx1);
1884:
1885: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_type(k) := g_geography_type_tbl(idx1);
1886:
1887: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_value(k) := g_geography_name_tbl(idx1);
1888:
1889: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1890: l_log_msg := 'B: g_geography_id_tbl(idx1): l_geography_id(m)'||
1891: g_geography_id_tbl(idx1)|| l_geography_id(m);

Line 1897: || ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.event_class_mapping_id(k);

1893: ||g_geography_type_tbl(idx1)|| l_geography_type(m);
1894: l_log_msg := l_log_msg ||' B: g_geography_name_tbl(idx1): l_geography_name(m)'
1895: ||g_geography_name_tbl(idx1)|| l_geography_name(m);
1896: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.event_class_mapping_id(k)'
1897: || ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.event_class_mapping_id(k);
1898: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.trx_id(k)'
1899: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_id(k);
1900: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.trx_line_id(k)'
1901: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_line_id(k);

Line 1899: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_id(k);

1895: ||g_geography_name_tbl(idx1)|| l_geography_name(m);
1896: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.event_class_mapping_id(k)'
1897: || ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.event_class_mapping_id(k);
1898: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.trx_id(k)'
1899: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_id(k);
1900: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.trx_line_id(k)'
1901: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_line_id(k);
1902: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.trx_level_type(k)'
1903: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_level_type(k);

Line 1901: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_line_id(k);

1897: || ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.event_class_mapping_id(k);
1898: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.trx_id(k)'
1899: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_id(k);
1900: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.trx_line_id(k)'
1901: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_line_id(k);
1902: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.trx_level_type(k)'
1903: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_level_type(k);
1904: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.location_type(k)'
1905: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_type(k);

Line 1903: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_level_type(k);

1899: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_id(k);
1900: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.trx_line_id(k)'
1901: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_line_id(k);
1902: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.trx_level_type(k)'
1903: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_level_type(k);
1904: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.location_type(k)'
1905: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_type(k);
1906: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.location_table_name(k)'
1907: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_table_name(k);

Line 1905: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_type(k);

1901: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_line_id(k);
1902: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.trx_level_type(k)'
1903: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_level_type(k);
1904: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.location_type(k)'
1905: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_type(k);
1906: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.location_table_name(k)'
1907: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_table_name(k);
1908: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.location_id(k)'
1909: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_id(k);

Line 1907: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_table_name(k);

1903: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_level_type(k);
1904: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.location_type(k)'
1905: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_type(k);
1906: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.location_table_name(k)'
1907: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_table_name(k);
1908: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.location_id(k)'
1909: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_id(k);
1910: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.geography_id(k)'
1911: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_id(k);

Line 1909: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_id(k);

1905: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_type(k);
1906: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.location_table_name(k)'
1907: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_table_name(k);
1908: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.location_id(k)'
1909: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_id(k);
1910: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.geography_id(k)'
1911: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_id(k);
1912: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.geography_type(k)'
1913: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_type(k);

Line 1911: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_id(k);

1907: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_table_name(k);
1908: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.location_id(k)'
1909: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_id(k);
1910: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.geography_id(k)'
1911: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_id(k);
1912: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.geography_type(k)'
1913: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_type(k);
1914: l_log_msg := l_log_msg || 'B: LOCATION_INFO_TBL.geography_value(k)'
1915: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_value(k);

Line 1913: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_type(k);

1909: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_id(k);
1910: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.geography_id(k)'
1911: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_id(k);
1912: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.geography_type(k)'
1913: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_type(k);
1914: l_log_msg := l_log_msg || 'B: LOCATION_INFO_TBL.geography_value(k)'
1915: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_value(k);
1916: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1917: END IF;

Line 1915: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_value(k);

1911: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_id(k);
1912: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.geography_type(k)'
1913: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_type(k);
1914: l_log_msg := l_log_msg || 'B: LOCATION_INFO_TBL.geography_value(k)'
1915: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_value(k);
1916: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1917: END IF;
1918:
1919: hash_string := to_char(event_class_mapping_id)||'|'||

Line 1929: ZX_GLOBAL_STRUCTURES_PKG.location_hash_tbl(TABLEIDX) := k;

1925: g_geography_type_tbl(idx1);
1926:
1927: TABLEIDX := dbms_utility.get_hash_value(hash_string,1,TABLE_SIZE);
1928:
1929: ZX_GLOBAL_STRUCTURES_PKG.location_hash_tbl(TABLEIDX) := k;
1930:
1931: -- Logging Infra: Statement level: "B" means "B"reak point
1932: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1933: l_log_msg := 'B: Geography details populated'|| g_geography_id_tbl(idx1)