eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.BNE_SECURITY_UTILS_PKG dependencies on BNE_SECURITY_RULES

Line 86: -- to BNE_SECURED_OBJECT and BNE_SECURITY_RULES --

82: --------------------------------------------------------------------------------
83: -- PROCEDURE: ADD_OBJECT_RULES --
84: -- --
85: -- DESCRIPTION: Adds security rules for a BNE object e.g. an Integrator
86: -- to BNE_SECURED_OBJECT and BNE_SECURITY_RULES --
87: -- --
88: -- PARAMETERS: P_APPLICATION_ID: Application ID of Object --
89: -- P_OBJECT_CODE: Name of object --
90: -- P_OBJECT_TYPE: Currently support Object types of 'INTEGRATOR',--

Line 118: VV_SECURITY_TYPE BNE_SECURITY_RULES.SECURITY_TYPE%TYPE;

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;
122: BEGIN

Line 119: VV_SECURITY_VALUE BNE_SECURITY_RULES.SECURITY_VALUE%TYPE;

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;
122: BEGIN
123:

Line 161: BNE_SECURITY_RULES_PKG.INSERT_ROW( VR_ROW_ID,

157: THEN
158: CHECK_FUNCTION_EXISTANCE(VV_SECURITY_VALUE);
159: END IF;
160:
161: BNE_SECURITY_RULES_PKG.INSERT_ROW( VR_ROW_ID,
162: P_APPLICATION_ID,
163: P_SECURITY_CODE,
164: VN_OBJECT_VERSION_NUMBER,
165: VV_SECURITY_TYPE,

Line 191: -- from BNE_SECURED_OBJECT and BNE_SECURITY_RULES --

187: --------------------------------------------------------------------------------
188: -- PROCEDURE: UPDATE_OBJECT_RULES --
189: -- --
190: -- DESCRIPTION: Updates security rules for a BNE object e.g. an Integrator
191: -- from BNE_SECURED_OBJECT and BNE_SECURITY_RULES --
192: -- --
193: -- PARAMETERS: P_OBJECT_APP_ID: BNE_SECURED_OBJECT.APPLICATION_ID --
194: -- P_OBJECT_CODE: BNE_SECURED_OBJECT.OBJECT_CODE --
195: -- P_OBJECT_TYPE: BNE_SECURED_OBJECT.OBJECT_TYPE --

Line 196: -- P_SECURITY_APP_ID: BNE_SECURITY_RULES.APPLICATION_ID --

192: -- --
193: -- PARAMETERS: P_OBJECT_APP_ID: BNE_SECURED_OBJECT.APPLICATION_ID --
194: -- P_OBJECT_CODE: BNE_SECURED_OBJECT.OBJECT_CODE --
195: -- P_OBJECT_TYPE: BNE_SECURED_OBJECT.OBJECT_TYPE --
196: -- P_SECURITY_APP_ID: BNE_SECURITY_RULES.APPLICATION_ID --
197: -- P_SECURITY_CODE: BNE_SECURITY_RULES.SECURITY_CODE --
198: -- P_SECURITY_TYPE: BNE_SECURITY_RULES.SECURITY_TYPE --
199: -- P_SECURITY_VALUE: BNE_SECURITY_RULES.SECURITY_VALUE --
200: -- P_USER_ID: User ID --

Line 197: -- P_SECURITY_CODE: BNE_SECURITY_RULES.SECURITY_CODE --

193: -- PARAMETERS: P_OBJECT_APP_ID: BNE_SECURED_OBJECT.APPLICATION_ID --
194: -- P_OBJECT_CODE: BNE_SECURED_OBJECT.OBJECT_CODE --
195: -- P_OBJECT_TYPE: BNE_SECURED_OBJECT.OBJECT_TYPE --
196: -- P_SECURITY_APP_ID: BNE_SECURITY_RULES.APPLICATION_ID --
197: -- P_SECURITY_CODE: BNE_SECURITY_RULES.SECURITY_CODE --
198: -- P_SECURITY_TYPE: BNE_SECURITY_RULES.SECURITY_TYPE --
199: -- P_SECURITY_VALUE: BNE_SECURITY_RULES.SECURITY_VALUE --
200: -- P_USER_ID: User ID --
201: -- --

Line 198: -- P_SECURITY_TYPE: BNE_SECURITY_RULES.SECURITY_TYPE --

194: -- P_OBJECT_CODE: BNE_SECURED_OBJECT.OBJECT_CODE --
195: -- P_OBJECT_TYPE: BNE_SECURED_OBJECT.OBJECT_TYPE --
196: -- P_SECURITY_APP_ID: BNE_SECURITY_RULES.APPLICATION_ID --
197: -- P_SECURITY_CODE: BNE_SECURITY_RULES.SECURITY_CODE --
198: -- P_SECURITY_TYPE: BNE_SECURITY_RULES.SECURITY_TYPE --
199: -- P_SECURITY_VALUE: BNE_SECURITY_RULES.SECURITY_VALUE --
200: -- P_USER_ID: User ID --
201: -- --
202: -- MODIFICATION HISTORY --

Line 199: -- P_SECURITY_VALUE: BNE_SECURITY_RULES.SECURITY_VALUE --

195: -- P_OBJECT_TYPE: BNE_SECURED_OBJECT.OBJECT_TYPE --
196: -- P_SECURITY_APP_ID: BNE_SECURITY_RULES.APPLICATION_ID --
197: -- P_SECURITY_CODE: BNE_SECURITY_RULES.SECURITY_CODE --
198: -- P_SECURITY_TYPE: BNE_SECURITY_RULES.SECURITY_TYPE --
199: -- P_SECURITY_VALUE: BNE_SECURITY_RULES.SECURITY_VALUE --
200: -- P_USER_ID: User ID --
201: -- --
202: -- MODIFICATION HISTORY --
203: -- Date Username Description --

Line 262: BNE_SECURITY_RULES_PKG.UPDATE_ROW( P_SECURITY_APP_ID,

258: SYSDATE,
259: P_USER_ID,
260: 0 );
261:
262: BNE_SECURITY_RULES_PKG.UPDATE_ROW( P_SECURITY_APP_ID,
263: P_SECURITY_CODE,
264: VN_OBJECT_VERSION_NUMBER,
265: P_SECURITY_TYPE,
266: P_SECURITY_VALUE,

Line 278: -- from BNE_SECURED_OBJECT and BNE_SECURITY_RULES --

274: --------------------------------------------------------------------------------
275: -- PROCEDURE: DELETE_OBJECT_RULES --
276: -- --
277: -- DESCRIPTION: Deletes security rules for a BNE object e.g. an Integrator
278: -- from BNE_SECURED_OBJECT and BNE_SECURITY_RULES --
279: -- --
280: -- PARAMETERS: P_OBJECT_APP_ID: BNE_SECURED_OBJECT.APPLICATION_ID --
281: -- P_OBJECT_CODE: BNE_SECURED_OBJECT.OBJECT_CODE --
282: -- P_OBJECT_TYPE: BNE_SECURED_OBJECT.OBJECT_TYPE --

Line 283: -- P_SECURITY_APP_ID: BNE_SECURITY_RULES.APPLICATION_ID --

279: -- --
280: -- PARAMETERS: P_OBJECT_APP_ID: BNE_SECURED_OBJECT.APPLICATION_ID --
281: -- P_OBJECT_CODE: BNE_SECURED_OBJECT.OBJECT_CODE --
282: -- P_OBJECT_TYPE: BNE_SECURED_OBJECT.OBJECT_TYPE --
283: -- P_SECURITY_APP_ID: BNE_SECURITY_RULES.APPLICATION_ID --
284: -- P_SECURITY_CODE: BNE_SECURITY_RULES.SECURITY_CODE --
285: -- --
286: -- MODIFICATION HISTORY --
287: -- Date Username Description --

Line 284: -- P_SECURITY_CODE: BNE_SECURITY_RULES.SECURITY_CODE --

280: -- PARAMETERS: P_OBJECT_APP_ID: BNE_SECURED_OBJECT.APPLICATION_ID --
281: -- P_OBJECT_CODE: BNE_SECURED_OBJECT.OBJECT_CODE --
282: -- P_OBJECT_TYPE: BNE_SECURED_OBJECT.OBJECT_TYPE --
283: -- P_SECURITY_APP_ID: BNE_SECURITY_RULES.APPLICATION_ID --
284: -- P_SECURITY_CODE: BNE_SECURITY_RULES.SECURITY_CODE --
285: -- --
286: -- MODIFICATION HISTORY --
287: -- Date Username Description --
288: -- 16-Aug-2004 Kdobinso Created --

Line 296: VV_SECURITY_CODE BNE_SECURITY_RULES.SECURITY_CODE%type;

292: P_OBJECT_CODE in VARCHAR2,
293: P_OBJECT_TYPE in VARCHAR2,
294: P_SECURITY_APP_ID in NUMBER,
295: P_SECURITY_CODE in VARCHAR2) IS
296: VV_SECURITY_CODE BNE_SECURITY_RULES.SECURITY_CODE%type;
297: BEGIN
298:
299: BEGIN
300: SELECT SECURITY_RULE_CODE

Line 317: BNE_SECURITY_RULES_PKG.DELETE_ROW( P_SECURITY_APP_ID, P_SECURITY_CODE );

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:
321: