DBA Data[Home] [Help]

APPS.AD_OBSOLETE_PRODUCTS dependencies on FND_APPLICATION

Line 239: from DBA_OBJECTS DO, FND_APPLICATION fa

235: -- Do a bulk collect
236:
237: select object_name,object_type
238: bulk collect into obs_object_name, obs_object_type
239: from DBA_OBJECTS DO, FND_APPLICATION fa
240: where fa.APPLICATION_ID = x_appl_id
241: --and fa.APPLICATION_SHORT_NAME = do.OWNER
242: and do.OWNER = decode (fa.APPLICATION_SHORT_NAME,
243: 'SQLGL', 'GL',

Line 407: from FND_APPLICATION

403:
404: begin
405: select APPLICATION_SHORT_NAME
406: into l_app_short_name
407: from FND_APPLICATION
408: where APPLICATION_ID = x_appl_id;
409:
410: exception
411: when no_data_found then

Line 414: ||'" is not registered in FND_APPLICATION. ');

410: exception
411: when no_data_found then
412: raise_application_error(-20001,
413: 'Application ID "'|| x_appl_id
414: ||'" is not registered in FND_APPLICATION. ');
415:
416: end;
417:
418: -- Verify if a shared base schema for multiple products