DBA Data[Home] [Help]

APPS.BISM_ACCESS_CONTROL dependencies on BISM_OBJECTS

Line 8: name bism_objects.object_name%type;

4: function check_list_access(fid raw,myid raw)
5: return varchar2
6: is
7: priv number(2):=0;
8: name bism_objects.object_name%type;
9: begin
10:
11: -- resolve folder path,getUserPrivilege,checkUserPrivilege calls this function
12: -- cheks to see if the specified user has at least

Line 23: select object_name into name from bism_objects where object_id = fid;

19: );
20:
21: if priv is null then
22: begin
23: select object_name into name from bism_objects where object_id = fid;
24: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for folder');
25: exception
26: when no_data_found then
27: raise_application_error(BISM_ERRORCODES.FOLDER_NOT_FOUND,'Folder not found');

Line 44: name bism_objects.object_name%type;

40:
41: function check_ins_access(fid raw,myid raw)
42: return varchar2
43: is
44: name bism_objects.object_name%type;
45: priv number(2):=0;
46: begin
47:
48: -- always look at the folder id and see if the folder allows this

Line 59: select object_name into name from bism_objects where object_id = fid;

55: );
56:
57: if priv is null then
58: begin
59: select object_name into name from bism_objects where object_id = fid;
60: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for folder');
61: exception
62: when no_data_found then
63: raise_application_error(BISM_ERRORCODES.FOLDER_NOT_FOUND,'Folder not found');

Line 83: name bism_objects.object_name%type;

79: return varchar2
80: is
81: priv number(2):=0;
82: thisid raw(16);
83: name bism_objects.object_name%type;
84: begin
85:
86:
87: if is_record_a_folder = 'Y' OR is_record_a_folder = 'y' then

Line 101: select object_name into name from bism_objects where object_id = thisid;

97: );
98:
99: if priv is null then
100: begin
101: select object_name into name from bism_objects where object_id = thisid;
102: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for folder');
103: exception
104: when no_data_found then
105: raise_application_error(BISM_ERRORCODES.FOLDER_NOT_FOUND,'Folder not found');

Line 128: name bism_objects.object_name%type;

124: return varchar2
125: is
126: priv number(2):=0;
127: tempid raw(16);
128: name bism_objects.object_name%type;
129: begin
130:
131: if current_selection_is_folder = 'Y' OR current_selection_is_folder = 'y' then
132: tempid := oid;

Line 145: select object_name into name from bism_objects where object_id = tempid;

141: );
142:
143: if priv is null then
144: begin
145: select object_name into name from bism_objects where object_id = tempid;
146: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for folder');
147: exception
148: when no_data_found then
149: raise_application_error(BISM_ERRORCODES.FOLDER_NOT_FOUND,'Folder not found');

Line 171: tempid bism_objects.object_id%type;

167: is
168: c1 number;
169: c2 number;
170: priv number(2):=0;
171: tempid bism_objects.object_id%type;
172: fname bism_objects.object_name%type;
173: begin
174:
175: if is_folder = 'N' OR is_folder = 'n' then

Line 172: fname bism_objects.object_name%type;

168: c1 number;
169: c2 number;
170: priv number(2):=0;
171: tempid bism_objects.object_id%type;
172: fname bism_objects.object_name%type;
173: begin
174:
175: if is_folder = 'N' OR is_folder = 'n' then
176: -- if the record is an object, check its folder privilege

Line 194: select object_name into fname from bism_objects where object_id = tempid;

190:
191:
192: if priv is null then
193: begin
194: select object_name into fname from bism_objects where object_id = tempid;
195: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for folder');
196: exception
197: when no_data_found then
198: raise_application_error(BISM_ERRORCODES.FOLDER_NOT_FOUND,'Folder not found');

Line 219: name bism_objects.object_name%type;

215: function check_fullcontrol_access(oid raw,myid raw)
216: return varchar2
217: is
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

Line 230: select object_name into name from bism_objects where object_id = oid;

226: );
227:
228: if priv is null then
229: begin
230: select object_name into name from bism_objects where object_id = oid;
231: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for folder');
232: exception
233: when no_data_found then
234: raise_application_error(BISM_ERRORCODES.FOLDER_NOT_FOUND,'Folder not found');

Line 254: name bism_objects.object_name%type;

250: function check_show_entries_access(oid raw,myid raw)
251: return varchar2
252: is
253: priv number(2):=0;
254: name bism_objects.object_name%type;
255: oname bism_objects.object_name%type;
256: begin
257:
258: -- this function must be called only on a folder

Line 255: oname bism_objects.object_name%type;

251: return varchar2
252: is
253: priv number(2):=0;
254: name bism_objects.object_name%type;
255: oname bism_objects.object_name%type;
256: begin
257:
258: -- this function must be called only on a folder
259: -- for now entries() is the only method calling this

Line 269: select object_name into name from bism_objects where object_id = oid;

265: );
266:
267: if priv is null then
268: begin
269: select object_name into name from bism_objects where object_id = oid;
270: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for folder');
271: exception
272: when no_data_found then
273: raise_application_error(BISM_ERRORCODES.FOLDER_NOT_FOUND,'Folder not found');

Line 291: select object_name into oname from bism_objects where object_id = oid;

287: end if;
288: exception
289: when no_data_found then
290: begin
291: select object_name into oname from bism_objects where object_id = oid;
292: raise_application_error(BISM_ERRORCODES.NO_PRIVILEGES,'User has no privileges for folder');
293: exception
294: when no_data_found then
295: raise_application_error(BISM_ERRORCODES.FOLDER_NOT_FOUND,'Folder not found');