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.EAM_LINEAR_LOCATIONS_PUB dependencies on DUAL

Line 143: SELECT count(*) INTO l_count FROM dual WHERE EXISTS

139:
140: -- API body
141:
142: -- Validation of external_source_name
143: SELECT count(*) INTO l_count FROM dual WHERE EXISTS
144: (SELECT 1 FROM mfg_lookups WHERE lookup_code = p_external_source_name
145: AND lookup_type = 'EAM_EXTERNAL_SOURCE_NAME');
146:
147: IF (l_count = 0) THEN

Line 162: SELECT count(*) INTO l_count FROM dual WHERE EXISTS

158: fnd_msg_pub.add;
159: RAISE fnd_api.g_exc_error;
160: END IF;
161:
162: SELECT count(*) INTO l_count FROM dual WHERE EXISTS
163: (SELECT 1 FROM eam_linear_locations WHERE external_linear_id = p_external_linear_id
164: AND external_source_name = p_external_source_name
165: AND external_linear_type = p_external_linear_type);
166:

Line 267: SELECT count(*) INTO l_count FROM dual WHERE EXISTS

263:
264: -- API body
265:
266: -- Validation of eam_linear_id
267: SELECT count(*) INTO l_count FROM dual WHERE EXISTS
268: (SELECT 1 FROM eam_linear_locations WHERE eam_linear_id = p_eam_linear_id);
269:
270: IF (l_count = 0) THEN
271: fnd_message.set_name('EAM', 'EAM_INVALID_PARAMETER');

Line 278: SELECT count(*) INTO l_count FROM dual WHERE EXISTS

274: RAISE fnd_api.g_exc_error;
275: END IF;
276:
277: -- Validation of external_source_name
278: SELECT count(*) INTO l_count FROM dual WHERE EXISTS
279: (SELECT 1 FROM mfg_lookups WHERE lookup_code = p_external_source_name
280: AND lookup_type = 'EAM_EXTERNAL_SOURCE_NAME');
281:
282: IF (l_count = 0) THEN

Line 297: SELECT count(*) INTO l_count FROM dual WHERE EXISTS

293: fnd_msg_pub.add;
294: RAISE fnd_api.g_exc_error;
295: END IF;
296:
297: SELECT count(*) INTO l_count FROM dual WHERE EXISTS
298: (SELECT 1 FROM eam_linear_locations WHERE external_linear_id = p_external_linear_id
299: AND external_source_name = p_external_source_name
300: AND external_linear_type = p_external_linear_type
301: AND eam_linear_id <> p_eam_linear_id);

Line 393: SELECT count(*) INTO l_count FROM dual WHERE EXISTS

389:
390: -- API body
391:
392: -- Validation of external_source_name
393: SELECT count(*) INTO l_count FROM dual WHERE EXISTS
394: (SELECT 1 FROM mfg_lookups WHERE lookup_code = p_external_source_name
395: AND lookup_type = 'EAM_EXTERNAL_SOURCE_NAME');
396:
397: IF (l_count = 0) THEN