APPS.BISM_ACCESS_CONTROL dependencies on BISM_PERMISSIONS

Line 15: select max(privilege) into priv from bism_permissions where

11: -- resolve folder path,getUserPrivilege,checkUserPrivilege calls this function
12: -- cheks to see if the specified user has at least
13: -- list access to the specified folder
14:
15: select max(privilege) into priv from bism_permissions where
16: object_id = fid and subject_id in
17: (
18: select group_id from bism_groups where user_id = myid
19: );

Line 51: select max(privilege) into priv from bism_permissions where

47:
48: -- always look at the folder id and see if the folder allows this
49: -- object to be inserted (this object can be either be a folder
50: -- or an object - it does not matter)
51: select max(privilege) into priv from bism_permissions where
52: object_id = fid and subject_id in
53: (
54: select group_id from bism_groups where user_id = myid
55: );

Line 93: select max(privilege) into priv from bism_permissions where

89: else
90: thisid := fid;-- if current record is an object, walk up to its parent folder
91: end if;
92:
93: select max(privilege) into priv from bism_permissions where
94: object_id = thisid and subject_id in
95: (
96: select group_id from bism_groups where user_id = curr_user_id
97: );

Line 137: select max(privilege) into priv from bism_permissions where

133: else
134: tempid := fid;
135: end if;
136:
137: select max(privilege) into priv from bism_permissions where
138: object_id = tempid and subject_id in
139: (
140: select group_id from bism_groups where user_id = curr_user_id
141: );

Line 185: select max(privilege) into priv from bism_permissions

181: tempid := oid;
182: end if;
183:
184:
185: select max(privilege) into priv from bism_permissions
186: where object_id = tempid and subject_id in
187: (
188: select group_id from bism_groups where user_id = curr_user_id
189: );

Line 222: select max(privilege) into priv from bism_permissions where

218: priv number(2):=0;
219: name bism_objects.object_name%type;
220: begin
221: -- this function mus be called only on a folder
222: select max(privilege) into priv from bism_permissions where
223: object_id = oid and subject_id in
224: (
225: select group_id from bism_groups where user_id = myid
226: );

Line 261: select max(privilege) into priv from bism_permissions where

257:
258: -- this function must be called only on a folder
259: -- for now entries() is the only method calling this
260:
261: select max(privilege) into priv from bism_permissions where
262: object_id = oid and subject_id in
263: (
264: select group_id from bism_groups where user_id = myid
265: );