DBA Data[Home] [Help]

APPS.BNE_INTEGRATOR_UTILS dependencies on BNE_SECURED_OBJECTS

Line 4345: FROM BNE_SECURED_OBJECTS

4341: BEGIN
4342: SELECT SECURITY_RULE_APP_ID, SECURITY_RULE_CODE
4343: INTO
4344: VV_SECURITY_RULE_APP_ID, VV_SECURITY_RULE_CODE
4345: FROM BNE_SECURED_OBJECTS
4346: WHERE APPLICATION_ID = P_APPLICATION_ID
4347: AND OBJECT_CODE = P_INTEGRATOR_CODE
4348: AND OBJECT_TYPE = 'INTEGRATOR';
4349:

Line 4350: DELETE FROM BNE_SECURED_OBJECTS

4346: WHERE APPLICATION_ID = P_APPLICATION_ID
4347: AND OBJECT_CODE = P_INTEGRATOR_CODE
4348: AND OBJECT_TYPE = 'INTEGRATOR';
4349:
4350: DELETE FROM BNE_SECURED_OBJECTS
4351: WHERE APPLICATION_ID = P_APPLICATION_ID
4352: AND OBJECT_CODE = P_INTEGRATOR_CODE
4353: AND OBJECT_TYPE = 'INTEGRATOR';
4354:

Line 4357: FROM BNE_SECURED_OBJECTS

4353: AND OBJECT_TYPE = 'INTEGRATOR';
4354:
4355: SELECT COUNT(*)
4356: INTO VV_DUMMY
4357: FROM BNE_SECURED_OBJECTS
4358: WHERE SECURITY_RULE_APP_ID = VV_SECURITY_RULE_APP_ID
4359: AND SECURITY_RULE_CODE = VV_SECURITY_RULE_CODE;
4360:
4361: IF VV_DUMMY = 0