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 139: IF x_location_table_name = 'HR_LOCATIONS_ALL' THEN

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

Line 143: FROM hr_locations_all

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

Line 181: FROM hr_locations_all

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

Line 188: x_location_table_name := 'HR_LOCATIONS_ALL';

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

Line 226: IF p_location_table_name = 'HR_LOCATIONS_ALL' THEN

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

Line 230: FROM hr_locations_all

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

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

230: FROM hr_locations_all
231: WHERE location_id = p_location_id;
232:
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:

Line 287: FROM hr_locations_all

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

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

287: FROM hr_locations_all
288: WHERE location_id = p_location_id;
289:
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:

Line 473: x_location_table_name := 'HR_LOCATIONS_ALL';

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

Line 950: ELSIF x_location_table_name = 'HR_LOCATIONS_ALL' 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
953: FROM hr_locations_all
954: WHERE location_id = p_location_id;

Line 953: FROM hr_locations_all

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
953: FROM hr_locations_all
954: WHERE location_id = p_location_id;
955: END IF;
956: */
957: