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 HR_LOCATIONS_ALL

Line 107: ELSIF x_loc_tbl = 'HR_LOCATIONS_ALL' THEN

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
110: x_loc_site := 'PARTY_SITE_ID';
111: END IF;

Line 142: IF x_location_table_name = 'HR_LOCATIONS_ALL' THEN

138: l_hr_location_exists VARCHAR2(5);
139: l_hz_location_exists VARCHAR2(5);
140: l_procedure_name CONSTANT VARCHAR2(30) := 'check_location_exists';
141: BEGIN
142: IF x_location_table_name = 'HR_LOCATIONS_ALL' THEN
143: BEGIN
144: SELECT 'TRUE'
145: INTO l_hr_location_exists
146: FROM hr_locations_all

Line 146: FROM hr_locations_all

142: IF x_location_table_name = 'HR_LOCATIONS_ALL' THEN
143: BEGIN
144: SELECT 'TRUE'
145: INTO l_hr_location_exists
146: FROM hr_locations_all
147: WHERE location_id = p_location_id;
148:
149: EXCEPTION WHEN NO_DATA_FOUND THEN
150: l_hr_location_exists := 'FALSE';

Line 184: FROM hr_locations_all

180: IF l_hz_location_exists = 'FALSE' THEN
181: BEGIN
182: SELECT 'TRUE'
183: INTO l_hr_location_exists
184: FROM hr_locations_all
185: WHERE location_id = p_location_id;
186:
187: EXCEPTION WHEN NO_DATA_FOUND THEN
188: l_hr_location_exists := 'FALSE';

Line 191: x_location_table_name := 'HR_LOCATIONS_ALL';

187: EXCEPTION WHEN NO_DATA_FOUND THEN
188: l_hr_location_exists := 'FALSE';
189: END;
190: IF l_hr_location_exists = 'TRUE' THEN
191: x_location_table_name := 'HR_LOCATIONS_ALL';
192: ELSE
193: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
194: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, 'B: Invalid Location_id');
195: END IF;

Line 229: IF p_location_table_name = 'HR_LOCATIONS_ALL' THEN

225: x_location_info_rec.location_table_name);
226: END IF;
227:
228: ELSE
229: IF p_location_table_name = 'HR_LOCATIONS_ALL' THEN
230: BEGIN
231: SELECT country
232: INTO l_loc_country_code
233: FROM hr_locations_all

Line 233: FROM hr_locations_all

229: IF p_location_table_name = 'HR_LOCATIONS_ALL' THEN
230: BEGIN
231: SELECT country
232: INTO l_loc_country_code
233: FROM hr_locations_all
234: WHERE location_id = p_location_id;
235:
236: x_location_info_rec.country_code := l_loc_country_code;
237: x_location_info_rec.location_table_name := 'HR_LOCATIONS_ALL';

Line 237: x_location_info_rec.location_table_name := 'HR_LOCATIONS_ALL';

233: FROM hr_locations_all
234: WHERE location_id = p_location_id;
235:
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:

Line 290: FROM hr_locations_all

286:
287: BEGIN
288: SELECT country
289: INTO l_loc_country_code
290: FROM hr_locations_all
291: WHERE location_id = p_location_id;
292:
293: x_location_info_rec.country_code := l_loc_country_code;
294: x_location_info_rec.location_table_name := 'HR_LOCATIONS_ALL';

Line 294: x_location_info_rec.location_table_name := 'HR_LOCATIONS_ALL';

290: FROM hr_locations_all
291: WHERE location_id = p_location_id;
292:
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:

Line 476: x_location_table_name := 'HR_LOCATIONS_ALL';

472: RAISE FND_API.G_EXC_ERROR;
473: END IF;
474:
475: ELSIF p_location_type = 'INTERNAL_ORG' THEN
476: x_location_table_name := 'HR_LOCATIONS_ALL';
477:
478: END IF;
479:
480: -- Logging Infra: Statement level:"R" means "R"eturned value to a caller

Line 1065: ELSIF x_location_table_name = 'HR_LOCATIONS_ALL' 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
1068: FROM hr_locations_all
1069: WHERE location_id = p_location_id;

Line 1068: FROM hr_locations_all

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
1068: FROM hr_locations_all
1069: WHERE location_id = p_location_id;
1070: END IF;
1071: */
1072:

Line 1236: FROM hr_locations_all

1232: WHEN OTHERS THEN
1233: BEGIN
1234: SELECT NVL(loc_information14, 'N')
1235: INTO l_inner_city_jurisdiction_flag
1236: FROM hr_locations_all
1237: WHERE location_id = p_location_id;
1238: EXCEPTION
1239: WHEN OTHERS THEN
1240: l_inner_city_jurisdiction_flag := NULL;

Line 1244: ELSIF x_location_table_name = 'HR_LOCATIONS_ALL' THEN

1240: l_inner_city_jurisdiction_flag := NULL;
1241: END;
1242: END;
1243: EXIT;
1244: ELSIF x_location_table_name = 'HR_LOCATIONS_ALL' THEN
1245: BEGIN
1246: SELECT NVL(loc_information14, 'N')
1247: INTO l_inner_city_jurisdiction_flag
1248: FROM hr_locations_all

Line 1248: FROM hr_locations_all

1244: ELSIF x_location_table_name = 'HR_LOCATIONS_ALL' THEN
1245: BEGIN
1246: SELECT NVL(loc_information14, 'N')
1247: INTO l_inner_city_jurisdiction_flag
1248: FROM hr_locations_all
1249: WHERE location_id = p_location_id;
1250: EXCEPTION
1251: WHEN OTHERS THEN
1252: BEGIN