DBA Data[Home] [Help]

APPS.ORACLEAPPS dependencies on FND_ENABLED_PLSQL

Line 2558: FROM FND_ENABLED_PLSQL

2554: l_resp_appl_id NUMBER;
2555:
2556: cursor procFind(p_name varchar2) is
2557: SELECT 'exists'
2558: FROM FND_ENABLED_PLSQL
2559: WHERE PLSQL_TYPE = 'PROCEDURE'
2560: AND PLSQL_NAME = p_name
2561: AND ENABLED = 'Y';
2562:

Line 2565: FROM FND_ENABLED_PLSQL

2561: AND ENABLED = 'Y';
2562:
2563: cursor packFind(p_pack varchar2, p_proc varchar2) is
2564: SELECT 'exists'
2565: FROM FND_ENABLED_PLSQL
2566: WHERE (PLSQL_TYPE = 'PACKAGE' AND PLSQL_NAME = p_pack
2567: OR PLSQL_TYPE = 'PACKAGE.PROCEDURE' AND PLSQL_NAME = p_proc)
2568: AND ENABLED = 'Y';
2569: