DBA Data[Home] [Help]

APPS.BNE_INTEGRATOR_UTILS dependencies on BNE_SECURED_OBJECTS

Line 4254: FROM BNE_SECURED_OBJECTS

4250: BEGIN
4251: SELECT SECURITY_RULE_APP_ID, SECURITY_RULE_CODE
4252: INTO
4253: VV_SECURITY_RULE_APP_ID, VV_SECURITY_RULE_CODE
4254: FROM BNE_SECURED_OBJECTS
4255: WHERE APPLICATION_ID = P_APPLICATION_ID
4256: AND OBJECT_CODE = P_INTEGRATOR_CODE
4257: AND OBJECT_TYPE = 'INTEGRATOR';
4258:

Line 4259: DELETE FROM BNE_SECURED_OBJECTS

4255: WHERE APPLICATION_ID = P_APPLICATION_ID
4256: AND OBJECT_CODE = P_INTEGRATOR_CODE
4257: AND OBJECT_TYPE = 'INTEGRATOR';
4258:
4259: DELETE FROM BNE_SECURED_OBJECTS
4260: WHERE APPLICATION_ID = P_APPLICATION_ID
4261: AND OBJECT_CODE = P_INTEGRATOR_CODE
4262: AND OBJECT_TYPE = 'INTEGRATOR';
4263:

Line 4266: FROM BNE_SECURED_OBJECTS

4262: AND OBJECT_TYPE = 'INTEGRATOR';
4263:
4264: SELECT COUNT(*)
4265: INTO VV_DUMMY
4266: FROM BNE_SECURED_OBJECTS
4267: WHERE SECURITY_RULE_APP_ID = VV_SECURITY_RULE_APP_ID
4268: AND SECURITY_RULE_CODE = VV_SECURITY_RULE_CODE;
4269:
4270: IF VV_DUMMY = 0