DBA Data[Home] [Help]

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 153: FROM hz_locations

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

Line 160: x_location_table_name := 'HZ_LOCATIONS';

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

Line 167: ELSIF x_location_table_name = 'HZ_LOCATIONS' THEN

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

Line 171: FROM hz_locations

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

Line 204: l_loc_country_code hz_locations.country%type;

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';
206: l_log_msg VARCHAR2(2000);
207: BEGIN
208:

Line 244: FROM hz_locations

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

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

244: FROM hz_locations
245: WHERE location_id = p_location_id;
246:
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:

Line 269: ELSIF p_location_table_name = 'HZ_LOCATIONS' THEN

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

Line 273: FROM hz_locations

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

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

273: FROM hz_locations
274: WHERE location_id = p_location_id;
275:
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:

Line 945: IF x_location_table_name = 'HZ_LOCATIONS' THEN

941:
942: l_loc_country_code := l_location_info_rec.country_code;
943: /* nipatel location caching
944: check_location_exists(p_location_id, x_location_table_name);
945: IF x_location_table_name = 'HZ_LOCATIONS' THEN
946: SELECT country
947: INTO l_loc_country_code
948: FROM hz_locations
949: WHERE location_id = p_location_id;

Line 948: FROM hz_locations

944: check_location_exists(p_location_id, x_location_table_name);
945: IF x_location_table_name = 'HZ_LOCATIONS' THEN
946: SELECT country
947: INTO l_loc_country_code
948: FROM hz_locations
949: WHERE location_id = p_location_id;
950: ELSIF x_location_table_name = 'HR_LOCATIONS_ALL' THEN
951: SELECT country
952: INTO l_loc_country_code