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 HZ_LOCATIONS

Line 105: IF x_loc_tbl = 'HZ_LOCATIONS' THEN

101: END IF;
102:
103:
104: /* 3471450 -- SITE_ID changed to PARTY_SITE_ID */
105: IF x_loc_tbl = 'HZ_LOCATIONS' THEN
106: x_loc_site := 'LOCATION_ID';
107: ELSIF x_loc_tbl = 'HR_LOCATIONS_ALL' THEN
108: x_loc_site := 'LOCATION_ID';
109: ELSIF x_loc_tbl = 'PO_VENDOR_SITES_ALL' THEN

Line 156: FROM hz_locations

152: IF l_hr_location_exists = 'FALSE' THEN
153: BEGIN
154: SELECT 'TRUE'
155: INTO l_hz_location_exists
156: FROM hz_locations
157: WHERE location_id = p_location_id;
158:
159: EXCEPTION WHEN NO_DATA_FOUND THEN
160: l_hz_location_exists := 'FALSE';

Line 163: x_location_table_name := 'HZ_LOCATIONS';

159: EXCEPTION WHEN NO_DATA_FOUND THEN
160: l_hz_location_exists := 'FALSE';
161: END;
162: IF l_hz_location_exists = 'TRUE' THEN
163: x_location_table_name := 'HZ_LOCATIONS';
164: ELSE
165: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
166: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, 'B: Invalid Location_id');
167: END IF;

Line 170: ELSIF x_location_table_name = 'HZ_LOCATIONS' THEN

166: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, 'B: Invalid Location_id');
167: END IF;
168: END IF;
169: END IF;
170: ELSIF x_location_table_name = 'HZ_LOCATIONS' THEN
171: BEGIN
172: SELECT 'TRUE'
173: INTO l_hz_location_exists
174: FROM hz_locations

Line 174: FROM hz_locations

170: ELSIF x_location_table_name = 'HZ_LOCATIONS' THEN
171: BEGIN
172: SELECT 'TRUE'
173: INTO l_hz_location_exists
174: FROM hz_locations
175: WHERE location_id = p_location_id;
176:
177: EXCEPTION WHEN NO_DATA_FOUND THEN
178: l_hz_location_exists := 'FALSE';

Line 207: l_loc_country_code hz_locations.country%type;

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';
209: l_log_msg VARCHAR2(2000);
210: BEGIN
211:

Line 247: FROM hz_locations

243:
244: BEGIN
245: SELECT country
246: INTO l_loc_country_code
247: FROM hz_locations
248: WHERE location_id = p_location_id;
249:
250: x_location_info_rec.country_code := l_loc_country_code;
251: x_location_info_rec.location_table_name := 'HZ_LOCATIONS';

Line 251: x_location_info_rec.location_table_name := 'HZ_LOCATIONS';

247: FROM hz_locations
248: WHERE location_id = p_location_id;
249:
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:

Line 272: ELSIF p_location_table_name = 'HZ_LOCATIONS' THEN

268: RAISE FND_API.G_EXC_ERROR;
269: END;
270: END;
271:
272: ELSIF p_location_table_name = 'HZ_LOCATIONS' THEN
273: BEGIN
274: SELECT country
275: INTO l_loc_country_code
276: FROM hz_locations

Line 276: FROM hz_locations

272: ELSIF p_location_table_name = 'HZ_LOCATIONS' THEN
273: BEGIN
274: SELECT country
275: INTO l_loc_country_code
276: FROM hz_locations
277: WHERE location_id = p_location_id;
278:
279: x_location_info_rec.country_code := l_loc_country_code;
280: x_location_info_rec.location_table_name := 'HZ_LOCATIONS';

Line 280: x_location_info_rec.location_table_name := 'HZ_LOCATIONS';

276: FROM hz_locations
277: WHERE location_id = p_location_id;
278:
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:

Line 1060: IF x_location_table_name = 'HZ_LOCATIONS' THEN

1056:
1057: l_loc_country_code := l_location_info_rec.country_code;
1058: /* nipatel location caching
1059: check_location_exists(p_location_id, x_location_table_name);
1060: IF x_location_table_name = 'HZ_LOCATIONS' THEN
1061: SELECT country
1062: INTO l_loc_country_code
1063: FROM hz_locations
1064: WHERE location_id = p_location_id;

Line 1063: FROM hz_locations

1059: check_location_exists(p_location_id, x_location_table_name);
1060: IF x_location_table_name = 'HZ_LOCATIONS' THEN
1061: SELECT country
1062: INTO l_loc_country_code
1063: FROM hz_locations
1064: WHERE location_id = p_location_id;
1065: ELSIF x_location_table_name = 'HR_LOCATIONS_ALL' THEN
1066: SELECT country
1067: INTO l_loc_country_code

Line 1225: IF x_location_table_name = 'HZ_LOCATIONS' THEN

1221: END IF;
1222:
1223: IF NVL(FND_PROFILE.value('ZX_USE_LOC_INSIDE_CITY_LIMITS'), 'N') = 'Y'
1224: AND l_obj_geo_type = 'CITY' THEN
1225: IF x_location_table_name = 'HZ_LOCATIONS' THEN
1226: BEGIN
1227: SELECT DECODE(NVL(sales_tax_inside_city_limits, '0'), '0', 'N', 'Y')
1228: INTO l_inner_city_jurisdiction_flag
1229: FROM hz_locations

Line 1229: FROM hz_locations

1225: IF x_location_table_name = 'HZ_LOCATIONS' THEN
1226: BEGIN
1227: SELECT DECODE(NVL(sales_tax_inside_city_limits, '0'), '0', 'N', 'Y')
1228: INTO l_inner_city_jurisdiction_flag
1229: FROM hz_locations
1230: WHERE location_id = p_location_id;
1231: EXCEPTION
1232: WHEN OTHERS THEN
1233: BEGIN

Line 1255: FROM hz_locations

1251: WHEN OTHERS THEN
1252: BEGIN
1253: SELECT DECODE(NVL(sales_tax_inside_city_limits, '0'), '0', 'N', 'Y')
1254: INTO l_inner_city_jurisdiction_flag
1255: FROM hz_locations
1256: WHERE location_id = p_location_id;
1257: EXCEPTION
1258: WHEN OTHERS THEN
1259: l_inner_city_jurisdiction_flag := NULL;