APPS.BNE_SECURITY_UTILS_PKG dependencies on BNE_SECURED_OBJECTS

Line 117: VV_OBJECT_TYPE BNE_SECURED_OBJECTS.OBJECT_TYPE%TYPE;

113: P_SECURITY_TYPE in VARCHAR2,
114: P_SECURITY_VALUE in VARCHAR2,
115: P_USER_ID in NUMBER)
116: IS
117: VV_OBJECT_TYPE BNE_SECURED_OBJECTS.OBJECT_TYPE%TYPE;
118: VV_SECURITY_TYPE BNE_SECURITY_RULES.SECURITY_TYPE%TYPE;
119: VV_SECURITY_VALUE BNE_SECURITY_RULES.SECURITY_VALUE%TYPE;
120: VN_OBJECT_VERSION_NUMBER CONSTANT NUMBER := 1;
121: VR_ROW_ID ROWID;

Line 173: BNE_SECURED_OBJECTS_PKG.INSERT_ROW( VR_ROW_ID,

169: SYSDATE,
170: P_USER_ID,
171: 0);
172:
173: BNE_SECURED_OBJECTS_PKG.INSERT_ROW( VR_ROW_ID,
174: P_APPLICATION_ID,
175: P_OBJECT_CODE,
176: VV_OBJECT_TYPE,
177: VN_OBJECT_VERSION_NUMBER,

Line 252: BNE_SECURED_OBJECTS_PKG.UPDATE_ROW( P_OBJECT_APP_ID,

248: THEN
249: CHECK_FUNCTION_EXISTANCE(P_SECURITY_VALUE);
250: END IF;
251:
252: BNE_SECURED_OBJECTS_PKG.UPDATE_ROW( P_OBJECT_APP_ID,
253: P_OBJECT_CODE,
254: P_OBJECT_TYPE,
255: VN_OBJECT_VERSION_NUMBER,
256: P_SECURITY_APP_ID,

Line 302: FROM BNE_SECURED_OBJECTS

298:
299: BEGIN
300: SELECT SECURITY_RULE_CODE
301: INTO VV_SECURITY_CODE
302: FROM BNE_SECURED_OBJECTS
303: WHERE APPLICATION_ID = P_OBJECT_APP_ID
304: AND OBJECT_CODE = P_OBJECT_CODE
305: AND OBJECT_TYPE = P_OBJECT_TYPE
306: AND SECURITY_RULE_APP_ID = P_SECURITY_APP_ID;

Line 316: BNE_SECURED_OBJECTS_PKG.DELETE_ROW( P_OBJECT_APP_ID, P_OBJECT_CODE, P_OBJECT_TYPE );

312: IF P_SECURITY_CODE <> VV_SECURITY_CODE THEN
313: RAISE_APPLICATION_ERROR( -20000,'The supplied security code ' || P_SECURITY_CODE || ' does not match security referenced by ' || P_OBJECT_APP_ID || ':' || P_OBJECT_CODE || ' in BNE_SECURED_OBJECT');
314: END IF;
315:
316: BNE_SECURED_OBJECTS_PKG.DELETE_ROW( P_OBJECT_APP_ID, P_OBJECT_CODE, P_OBJECT_TYPE );
317: BNE_SECURITY_RULES_PKG.DELETE_ROW( P_SECURITY_APP_ID, P_SECURITY_CODE );
318:
319: END DELETE_OBJECT_RULES;
320: