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 201: x_location_info_rec OUT NOCOPY zx_global_Structures_pkg.loc_info_rec_type,

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 620: l_location_info_rec ZX_GLOBAL_STRUCTURES_PKG.loc_info_rec_type;

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

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

638:
639: x_return_status := FND_API.G_RET_STS_SUCCESS;
640:
641: -- Derive location table name based on location_type
642: IF ZX_GLOBAL_STRUCTURES_PKG.Loc_info_tbl.exists(to_char(p_location_id)) then
643:
644: l_loc_country_code := ZX_GLOBAL_STRUCTURES_PKG.Loc_info_tbl(to_char(p_location_id)).country_code;
645: x_location_table_name := ZX_GLOBAL_STRUCTURES_PKG.Loc_info_tbl(to_char(p_location_id)).location_table_name;
646: ELSE

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

640:
641: -- Derive location table name based on location_type
642: IF ZX_GLOBAL_STRUCTURES_PKG.Loc_info_tbl.exists(to_char(p_location_id)) then
643:
644: l_loc_country_code := ZX_GLOBAL_STRUCTURES_PKG.Loc_info_tbl(to_char(p_location_id)).country_code;
645: x_location_table_name := ZX_GLOBAL_STRUCTURES_PKG.Loc_info_tbl(to_char(p_location_id)).location_table_name;
646: ELSE
647:
648: get_location_table_name(p_location_type,

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

641: -- Derive location table name based on location_type
642: IF ZX_GLOBAL_STRUCTURES_PKG.Loc_info_tbl.exists(to_char(p_location_id)) then
643:
644: l_loc_country_code := ZX_GLOBAL_STRUCTURES_PKG.Loc_info_tbl(to_char(p_location_id)).country_code;
645: x_location_table_name := ZX_GLOBAL_STRUCTURES_PKG.Loc_info_tbl(to_char(p_location_id)).location_table_name;
646: ELSE
647:
648: get_location_table_name(p_location_type,
649: x_location_table_name);

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

655: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
656: END IF;
657:
658: get_location_info(p_location_id, x_location_table_name, l_location_info_rec, x_return_status);
659: x_location_table_name := ZX_GLOBAL_STRUCTURES_PKG.Loc_info_tbl(to_char(p_location_id)).location_table_name;
660:
661: l_loc_country_code := l_location_info_rec.country_code;
662:
663: END IF;

Line 667: IF ZX_GLOBAL_STRUCTURES_PKG.g_geography_type_info_tbl.exists(l_geography_type_index) THEN

663: END IF;
664:
665: l_geography_type_index := dbms_utility.get_hash_value(p_zone_type, 1, 8192);
666:
667: IF ZX_GLOBAL_STRUCTURES_PKG.g_geography_type_info_tbl.exists(l_geography_type_index) THEN
668: l_limited_by_geography_id :=
669: ZX_GLOBAL_STRUCTURES_PKG.g_geography_type_info_tbl(l_geography_type_index).limited_by_geography_id;
670:
671: ELSE

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

665: l_geography_type_index := dbms_utility.get_hash_value(p_zone_type, 1, 8192);
666:
667: IF ZX_GLOBAL_STRUCTURES_PKG.g_geography_type_info_tbl.exists(l_geography_type_index) THEN
668: l_limited_by_geography_id :=
669: ZX_GLOBAL_STRUCTURES_PKG.g_geography_type_info_tbl(l_geography_type_index).limited_by_geography_id;
670:
671: ELSE
672:
673: open C_GEOGRAPHY_TYPES(p_zone_type);

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

676: l_geography_use,
677: l_limited_by_geography_id;
678: close C_GEOGRAPHY_TYPES;
679:
680: ZX_GLOBAL_STRUCTURES_PKG.g_geography_type_info_tbl(l_geography_type_index).geography_type := l_geography_type;
681: ZX_GLOBAL_STRUCTURES_PKG.g_geography_type_info_tbl(l_geography_type_index).geography_use := l_geography_use;
682: ZX_GLOBAL_STRUCTURES_PKG.g_geography_type_info_tbl(l_geography_type_index).limited_by_geography_id := l_limited_by_geography_id;
683:
684: END IF;

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

677: l_limited_by_geography_id;
678: close C_GEOGRAPHY_TYPES;
679:
680: ZX_GLOBAL_STRUCTURES_PKG.g_geography_type_info_tbl(l_geography_type_index).geography_type := l_geography_type;
681: ZX_GLOBAL_STRUCTURES_PKG.g_geography_type_info_tbl(l_geography_type_index).geography_use := l_geography_use;
682: ZX_GLOBAL_STRUCTURES_PKG.g_geography_type_info_tbl(l_geography_type_index).limited_by_geography_id := l_limited_by_geography_id;
683:
684: END IF;
685:

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

678: close C_GEOGRAPHY_TYPES;
679:
680: ZX_GLOBAL_STRUCTURES_PKG.g_geography_type_info_tbl(l_geography_type_index).geography_type := l_geography_type;
681: ZX_GLOBAL_STRUCTURES_PKG.g_geography_type_info_tbl(l_geography_type_index).geography_use := l_geography_use;
682: ZX_GLOBAL_STRUCTURES_PKG.g_geography_type_info_tbl(l_geography_type_index).limited_by_geography_id := l_limited_by_geography_id;
683:
684: END IF;
685:
686: IF l_limited_by_geography_id IS NOT NULL THEN

Line 861: l_tax_regime_rec zx_global_structures_pkg.tax_regime_rec_type;

857: -- Logging Infra
858: l_procedure_name CONSTANT VARCHAR2(30) := 'get_tax_jurisdictions';
859: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
860: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;
861: l_tax_regime_rec zx_global_structures_pkg.tax_regime_rec_type;
862:
863: l_tbl_index BINARY_INTEGER;
864: i NUMBER;
865: l_location_info_rec ZX_GLOBAL_STRUCTURES_PKG.loc_info_rec_type;

Line 865: l_location_info_rec ZX_GLOBAL_STRUCTURES_PKG.loc_info_rec_type;

861: l_tax_regime_rec zx_global_structures_pkg.tax_regime_rec_type;
862:
863: l_tbl_index BINARY_INTEGER;
864: i NUMBER;
865: l_location_info_rec ZX_GLOBAL_STRUCTURES_PKG.loc_info_rec_type;
866:
867: BEGIN
868:
869: -- Logging Infra: Setting up runtime message level

Line 1256: l_location_info_rec ZX_GLOBAL_STRUCTURES_PKG.loc_info_rec_type;

1252: -- Logging Infra
1253: l_procedure_name CONSTANT VARCHAR2(30) := 'get_master_geography';
1254: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1255:
1256: l_location_info_rec ZX_GLOBAL_STRUCTURES_PKG.loc_info_rec_type;
1257: l_geography_use hz_geographies.geography_use%type;
1258: l_tbl_index binary_integer;
1259: l_tbl_country_index binary_integer;
1260:

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

1300: */
1301: get_location_table_name(p_location_type,
1302: x_location_table_name);
1303: get_location_info(p_location_id, x_location_table_name, l_location_info_rec,x_return_status);
1304: x_location_table_name := ZX_GLOBAL_STRUCTURES_PKG.Loc_info_tbl(to_char(p_location_id)).location_table_name;
1305:
1306:
1307: -- Logging Infra: Statement level: "B" means "B"reak point
1308: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

1318: to_char(p_location_id)||p_geography_type,
1319: 1,
1320: 8192);
1321:
1322: IF zx_global_structures_pkg.Loc_geography_info_tbl.exists(l_tbl_index) AND
1323: (zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).location_id = p_location_id AND
1324: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_type = p_geography_type) THEN
1325:
1326: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN

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

1319: 1,
1320: 8192);
1321:
1322: IF zx_global_structures_pkg.Loc_geography_info_tbl.exists(l_tbl_index) AND
1323: (zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).location_id = p_location_id AND
1324: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_type = p_geography_type) THEN
1325:
1326: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1327: l_log_msg := 'Found the geography id and geography name info in cache';

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

1320: 8192);
1321:
1322: IF zx_global_structures_pkg.Loc_geography_info_tbl.exists(l_tbl_index) AND
1323: (zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).location_id = p_location_id AND
1324: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_type = p_geography_type) THEN
1325:
1326: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1327: l_log_msg := 'Found the geography id and geography name info in cache';
1328: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, l_log_msg);

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

1327: l_log_msg := 'Found the geography id and geography name info in cache';
1328: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, l_log_msg);
1329: END IF;
1330:
1331: x_geography_id := zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_id;
1332: x_geography_code := zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_code;
1333: x_geography_name := zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_name;
1334:
1335: ELSE

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

1328: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, l_log_msg);
1329: END IF;
1330:
1331: x_geography_id := zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_id;
1332: x_geography_code := zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_code;
1333: x_geography_name := zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_name;
1334:
1335: ELSE
1336:

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

1329: END IF;
1330:
1331: x_geography_id := zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_id;
1332: x_geography_code := zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_code;
1333: x_geography_name := zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_name;
1334:
1335: ELSE
1336:
1337: BEGIN

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

1347: l_log_msg := 'B: SEL hz_geo_name_ref: out: x_geography_id='||x_geography_id;
1348: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1349: END IF;
1350:
1351: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).location_id := p_location_id;
1352: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_type := p_geography_type;
1353: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_id := x_geography_id;
1354: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_code := x_geography_code;
1355: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_name := x_geography_name;

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

1348: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1349: END IF;
1350:
1351: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).location_id := p_location_id;
1352: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_type := p_geography_type;
1353: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_id := x_geography_id;
1354: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_code := x_geography_code;
1355: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_name := x_geography_name;
1356: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_use := l_geography_use;

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

1349: END IF;
1350:
1351: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).location_id := p_location_id;
1352: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_type := p_geography_type;
1353: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_id := x_geography_id;
1354: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_code := x_geography_code;
1355: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_name := x_geography_name;
1356: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_use := l_geography_use;
1357:

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

1350:
1351: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).location_id := p_location_id;
1352: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_type := p_geography_type;
1353: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_id := x_geography_id;
1354: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_code := x_geography_code;
1355: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_name := x_geography_name;
1356: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_use := l_geography_use;
1357:
1358:

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

1351: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).location_id := p_location_id;
1352: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_type := p_geography_type;
1353: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_id := x_geography_id;
1354: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_code := x_geography_code;
1355: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_name := x_geography_name;
1356: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_use := l_geography_use;
1357:
1358:
1359: EXCEPTION WHEN NO_DATA_FOUND THEN

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

1352: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_type := p_geography_type;
1353: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_id := x_geography_id;
1354: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_code := x_geography_code;
1355: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_name := x_geography_name;
1356: zx_global_structures_pkg.Loc_geography_info_tbl(l_tbl_index).geography_use := l_geography_use;
1357:
1358:
1359: EXCEPTION WHEN NO_DATA_FOUND THEN
1360:

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

1476: p_geography_type;
1477:
1478: TABLEIDX := dbms_utility.get_hash_value(hash_string,1,TABLE_SIZE);
1479:
1480: IF (ZX_GLOBAL_STRUCTURES_PKG.location_hash_tbl.EXISTS(TABLEIDX)) THEN
1481: loc_info_idx := ZX_GLOBAL_STRUCTURES_PKG.location_hash_tbl(TABLEIDX);
1482: x_geography_value := ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.geography_value(loc_info_idx);
1483: x_geography_id:= ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.geography_id(loc_info_idx);
1484: x_geo_val_found := TRUE;

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

1477:
1478: TABLEIDX := dbms_utility.get_hash_value(hash_string,1,TABLE_SIZE);
1479:
1480: IF (ZX_GLOBAL_STRUCTURES_PKG.location_hash_tbl.EXISTS(TABLEIDX)) THEN
1481: loc_info_idx := ZX_GLOBAL_STRUCTURES_PKG.location_hash_tbl(TABLEIDX);
1482: x_geography_value := ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.geography_value(loc_info_idx);
1483: x_geography_id:= ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.geography_id(loc_info_idx);
1484: x_geo_val_found := TRUE;
1485: ELSE

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

1478: TABLEIDX := dbms_utility.get_hash_value(hash_string,1,TABLE_SIZE);
1479:
1480: IF (ZX_GLOBAL_STRUCTURES_PKG.location_hash_tbl.EXISTS(TABLEIDX)) THEN
1481: loc_info_idx := ZX_GLOBAL_STRUCTURES_PKG.location_hash_tbl(TABLEIDX);
1482: x_geography_value := ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.geography_value(loc_info_idx);
1483: x_geography_id:= ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.geography_id(loc_info_idx);
1484: x_geo_val_found := TRUE;
1485: ELSE
1486: x_geo_val_found := FALSE;

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

1479:
1480: IF (ZX_GLOBAL_STRUCTURES_PKG.location_hash_tbl.EXISTS(TABLEIDX)) THEN
1481: loc_info_idx := ZX_GLOBAL_STRUCTURES_PKG.location_hash_tbl(TABLEIDX);
1482: x_geography_value := ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.geography_value(loc_info_idx);
1483: x_geography_id:= ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.geography_id(loc_info_idx);
1484: x_geo_val_found := TRUE;
1485: ELSE
1486: x_geo_val_found := FALSE;
1487: END IF;

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

1545: -- END IF;
1546:
1547: n := 1;
1548: idx1 := to_char(event_class_mapping_id)||location_type_tbl(i)||location_id_tbl(i) ||x_loc_tbl|| to_char(n);
1549: k := ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.event_class_mapping_id.last;
1550: IF k IS NOT NULL THEN
1551: k := k + 1;
1552: ELSE
1553: k := 1;

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

1560: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1561: l_log_msg := 'B: Geography found ';
1562: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1563: END IF;
1564: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.event_class_mapping_id(k) :=
1565: event_class_mapping_id;
1566: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_id(k) := trx_id;
1567: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_line_id(k) := trx_line_id;
1568: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_level_type(k) := trx_level_type;

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

1562: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1563: END IF;
1564: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.event_class_mapping_id(k) :=
1565: event_class_mapping_id;
1566: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_id(k) := trx_id;
1567: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_line_id(k) := trx_line_id;
1568: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_level_type(k) := trx_level_type;
1569: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_type(k) := location_type_tbl(i);
1570: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_table_name(k) := x_loc_tbl;

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

1563: END IF;
1564: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.event_class_mapping_id(k) :=
1565: event_class_mapping_id;
1566: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_id(k) := trx_id;
1567: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_line_id(k) := trx_line_id;
1568: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_level_type(k) := trx_level_type;
1569: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_type(k) := location_type_tbl(i);
1570: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_table_name(k) := x_loc_tbl;
1571: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_id (k) := location_id_tbl(i);

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

1564: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.event_class_mapping_id(k) :=
1565: event_class_mapping_id;
1566: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_id(k) := trx_id;
1567: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_line_id(k) := trx_line_id;
1568: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_level_type(k) := trx_level_type;
1569: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_type(k) := location_type_tbl(i);
1570: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_table_name(k) := x_loc_tbl;
1571: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_id (k) := location_id_tbl(i);
1572: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_id(k) := g_geography_id_tbl(idx1);

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

1565: event_class_mapping_id;
1566: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_id(k) := trx_id;
1567: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_line_id(k) := trx_line_id;
1568: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_level_type(k) := trx_level_type;
1569: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_type(k) := location_type_tbl(i);
1570: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_table_name(k) := x_loc_tbl;
1571: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_id (k) := location_id_tbl(i);
1572: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_id(k) := g_geography_id_tbl(idx1);
1573:

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

1566: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_id(k) := trx_id;
1567: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_line_id(k) := trx_line_id;
1568: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_level_type(k) := trx_level_type;
1569: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_type(k) := location_type_tbl(i);
1570: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_table_name(k) := x_loc_tbl;
1571: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_id (k) := location_id_tbl(i);
1572: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_id(k) := g_geography_id_tbl(idx1);
1573:
1574: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_type(k) := g_geography_type_tbl(idx1);

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

1567: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_line_id(k) := trx_line_id;
1568: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_level_type(k) := trx_level_type;
1569: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_type(k) := location_type_tbl(i);
1570: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_table_name(k) := x_loc_tbl;
1571: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_id (k) := location_id_tbl(i);
1572: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_id(k) := g_geography_id_tbl(idx1);
1573:
1574: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_type(k) := g_geography_type_tbl(idx1);
1575: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_value(k) := g_geography_name_tbl(idx1);

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

1568: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_level_type(k) := trx_level_type;
1569: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_type(k) := location_type_tbl(i);
1570: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_table_name(k) := x_loc_tbl;
1571: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_id (k) := location_id_tbl(i);
1572: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_id(k) := g_geography_id_tbl(idx1);
1573:
1574: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_type(k) := g_geography_type_tbl(idx1);
1575: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_value(k) := g_geography_name_tbl(idx1);
1576:

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

1570: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_table_name(k) := x_loc_tbl;
1571: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_id (k) := location_id_tbl(i);
1572: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_id(k) := g_geography_id_tbl(idx1);
1573:
1574: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_type(k) := g_geography_type_tbl(idx1);
1575: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_value(k) := g_geography_name_tbl(idx1);
1576:
1577:
1578: hash_string := to_char(event_class_mapping_id)||'|'||

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

1571: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_id (k) := location_id_tbl(i);
1572: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_id(k) := g_geography_id_tbl(idx1);
1573:
1574: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_type(k) := g_geography_type_tbl(idx1);
1575: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_value(k) := g_geography_name_tbl(idx1);
1576:
1577:
1578: hash_string := to_char(event_class_mapping_id)||'|'||
1579: to_char(trx_id)||'|'||

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

1584: g_geography_type_tbl(idx1);
1585:
1586: TABLEIDX := dbms_utility.get_hash_value(hash_string,1,TABLE_SIZE);
1587:
1588: ZX_GLOBAL_STRUCTURES_PKG.location_hash_tbl(TABLEIDX) := k;
1589:
1590:
1591: -- Logging Infra: Statement level: "B" means "B"reak point
1592: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

1654: g_geography_type_tbl(idx1) := l_geography_type(m);
1655:
1656: g_geography_name_tbl(idx1) := l_geography_name(m);
1657:
1658: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.event_class_mapping_id(k) := event_class_mapping_id;
1659:
1660: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_id(k) := trx_id;
1661:
1662: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_line_id(k) := trx_line_id;

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

1656: g_geography_name_tbl(idx1) := l_geography_name(m);
1657:
1658: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.event_class_mapping_id(k) := event_class_mapping_id;
1659:
1660: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_id(k) := trx_id;
1661:
1662: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_line_id(k) := trx_line_id;
1663:
1664: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_level_type(k) := trx_level_type;

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

1658: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.event_class_mapping_id(k) := event_class_mapping_id;
1659:
1660: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_id(k) := trx_id;
1661:
1662: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_line_id(k) := trx_line_id;
1663:
1664: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_level_type(k) := trx_level_type;
1665:
1666: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_type(k) := location_type_tbl(i);

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

1660: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_id(k) := trx_id;
1661:
1662: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_line_id(k) := trx_line_id;
1663:
1664: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_level_type(k) := trx_level_type;
1665:
1666: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_type(k) := location_type_tbl(i);
1667:
1668: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_table_name(k) := x_loc_tbl;

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

1662: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_line_id(k) := trx_line_id;
1663:
1664: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_level_type(k) := trx_level_type;
1665:
1666: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_type(k) := location_type_tbl(i);
1667:
1668: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_table_name(k) := x_loc_tbl;
1669:
1670: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_id (k) := location_id_tbl(i);

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

1664: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_level_type(k) := trx_level_type;
1665:
1666: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_type(k) := location_type_tbl(i);
1667:
1668: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_table_name(k) := x_loc_tbl;
1669:
1670: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_id (k) := location_id_tbl(i);
1671:
1672: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_id(k) := g_geography_id_tbl(idx1);

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

1666: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_type(k) := location_type_tbl(i);
1667:
1668: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_table_name(k) := x_loc_tbl;
1669:
1670: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_id (k) := location_id_tbl(i);
1671:
1672: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_id(k) := g_geography_id_tbl(idx1);
1673:
1674: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_type(k) := g_geography_type_tbl(idx1);

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

1668: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_table_name(k) := x_loc_tbl;
1669:
1670: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_id (k) := location_id_tbl(i);
1671:
1672: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_id(k) := g_geography_id_tbl(idx1);
1673:
1674: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_type(k) := g_geography_type_tbl(idx1);
1675:
1676: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_value(k) := g_geography_name_tbl(idx1);

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

1670: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_id (k) := location_id_tbl(i);
1671:
1672: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_id(k) := g_geography_id_tbl(idx1);
1673:
1674: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_type(k) := g_geography_type_tbl(idx1);
1675:
1676: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_value(k) := g_geography_name_tbl(idx1);
1677:
1678: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

1672: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_id(k) := g_geography_id_tbl(idx1);
1673:
1674: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_type(k) := g_geography_type_tbl(idx1);
1675:
1676: ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_value(k) := g_geography_name_tbl(idx1);
1677:
1678: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1679: l_log_msg := 'B: g_geography_id_tbl(idx1): l_geography_id(m)'||
1680: g_geography_id_tbl(idx1)|| l_geography_id(m);

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

1682: ||g_geography_type_tbl(idx1)|| l_geography_type(m);
1683: l_log_msg := l_log_msg ||' B: g_geography_name_tbl(idx1): l_geography_name(m)'
1684: ||g_geography_name_tbl(idx1)|| l_geography_name(m);
1685: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.event_class_mapping_id(k)'
1686: || ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.event_class_mapping_id(k);
1687: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.trx_id(k)'
1688: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_id(k);
1689: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.trx_line_id(k)'
1690: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_line_id(k);

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

1684: ||g_geography_name_tbl(idx1)|| l_geography_name(m);
1685: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.event_class_mapping_id(k)'
1686: || ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.event_class_mapping_id(k);
1687: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.trx_id(k)'
1688: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_id(k);
1689: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.trx_line_id(k)'
1690: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_line_id(k);
1691: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.trx_level_type(k)'
1692: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_level_type(k);

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

1686: || ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.event_class_mapping_id(k);
1687: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.trx_id(k)'
1688: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_id(k);
1689: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.trx_line_id(k)'
1690: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_line_id(k);
1691: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.trx_level_type(k)'
1692: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_level_type(k);
1693: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.location_type(k)'
1694: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_type(k);

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

1688: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_id(k);
1689: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.trx_line_id(k)'
1690: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_line_id(k);
1691: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.trx_level_type(k)'
1692: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_level_type(k);
1693: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.location_type(k)'
1694: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_type(k);
1695: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.location_table_name(k)'
1696: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_table_name(k);

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

1690: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_line_id(k);
1691: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.trx_level_type(k)'
1692: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_level_type(k);
1693: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.location_type(k)'
1694: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_type(k);
1695: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.location_table_name(k)'
1696: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_table_name(k);
1697: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.location_id(k)'
1698: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_id(k);

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

1692: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.trx_level_type(k);
1693: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.location_type(k)'
1694: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_type(k);
1695: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.location_table_name(k)'
1696: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_table_name(k);
1697: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.location_id(k)'
1698: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_id(k);
1699: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.geography_id(k)'
1700: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_id(k);

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

1694: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_type(k);
1695: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.location_table_name(k)'
1696: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_table_name(k);
1697: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.location_id(k)'
1698: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_id(k);
1699: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.geography_id(k)'
1700: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_id(k);
1701: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.geography_type(k)'
1702: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_type(k);

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

1696: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_table_name(k);
1697: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.location_id(k)'
1698: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_id(k);
1699: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.geography_id(k)'
1700: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_id(k);
1701: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.geography_type(k)'
1702: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_type(k);
1703: l_log_msg := l_log_msg || 'B: LOCATION_INFO_TBL.geography_value(k)'
1704: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_value(k);

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

1698: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.location_id(k);
1699: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.geography_id(k)'
1700: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_id(k);
1701: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.geography_type(k)'
1702: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_type(k);
1703: l_log_msg := l_log_msg || 'B: LOCATION_INFO_TBL.geography_value(k)'
1704: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_value(k);
1705: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1706: END IF;

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

1700: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_id(k);
1701: l_log_msg := l_log_msg ||' B: LOCATION_INFO_TBL.geography_type(k)'
1702: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_type(k);
1703: l_log_msg := l_log_msg || 'B: LOCATION_INFO_TBL.geography_value(k)'
1704: ||ZX_GLOBAL_STRUCTURES_PKG.LOCATION_INFO_TBL.geography_value(k);
1705: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1706: END IF;
1707:
1708: hash_string := to_char(event_class_mapping_id)||'|'||

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

1714: g_geography_type_tbl(idx1);
1715:
1716: TABLEIDX := dbms_utility.get_hash_value(hash_string,1,TABLE_SIZE);
1717:
1718: ZX_GLOBAL_STRUCTURES_PKG.location_hash_tbl(TABLEIDX) := k;
1719:
1720: -- Logging Infra: Statement level: "B" means "B"reak point
1721: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1722: l_log_msg := 'B: Geography details populated'|| g_geography_id_tbl(idx1)