4 APEX_APP_OBJECT_DEPENDENCY
This API enables building the Application Database Object Dependencies report on demand.
It scans the application (or a page in the application) for all database objects that it depends on (including but not limited to tables, views, procedures, functions, packages, and synonyms), whether these dependencies are in forms, reports, PL/SQL regions, conditions, plugins, or elsewhere. It can also be used to detect invalid SQL and PL/SQL in the application.
The result of the scan may be viewed by querying the following views:
- APEX_USED_DB_OBJECT_COMP_PROPS - all application SQL and PL/SQL found
- APEX_USED_DB_OBJECTS - all database objects referred to
- APEX_USED_DB_OBJ_DEPENDENCIES - all dependencies found
In the event that a fragment of SQL or PL/SQL is invalid (such as a required object is missing), the dependencies are not be detected. The compilation error message may be queried in the APEX_USED_DB_OBJECT_COMP_PROPS view.