APPS.BISM_ACCESS_CONTROL SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 15

select max(privilege) into priv from bism_permissions where
object_id = fid and subject_id in
(
select group_id from bism_groups where user_id = myid
);

Line: 23

select object_name into name from bism_objects where object_id = fid;

Line: 51

select max(privilege) into priv from bism_permissions where
object_id = fid and subject_id in
(
select group_id from bism_groups where user_id = myid
);

Line: 59

select object_name into name from bism_objects where object_id = fid;

Line: 88

thisid := oid;--if curr selection is a folder, fine lets look up access on folder

Line: 93

select max(privilege) into priv from bism_permissions where
object_id = thisid and subject_id in
(
select group_id from bism_groups where user_id = curr_user_id
);

Line: 101

select object_name into name from bism_objects where object_id = thisid;

Line: 123

function check_read_access(oid raw,fid raw,current_selection_is_folder varchar2,curr_user_id raw)
return varchar2
is
priv number(2):=0;

Line: 131

if current_selection_is_folder = 'Y' OR current_selection_is_folder = 'y' then
tempid := oid;

Line: 137

select max(privilege) into priv from bism_permissions where
object_id = tempid and subject_id in
(
select group_id from bism_groups where user_id = curr_user_id
);

Line: 145

select object_name into name from bism_objects where object_id = tempid;

Line: 185

select max(privilege) into priv from bism_permissions
where object_id = tempid and subject_id in
(
select group_id from bism_groups where user_id = curr_user_id
);

Line: 194

select object_name into fname from bism_objects where object_id = tempid;

Line: 222

select max(privilege) into priv from bism_permissions where
object_id = oid and subject_id in
(
select group_id from bism_groups where user_id = myid
);

Line: 230

select object_name into name from bism_objects where object_id = oid;

Line: 261

select max(privilege) into priv from bism_permissions where
object_id = oid and subject_id in
(
select group_id from bism_groups where user_id = myid
);

Line: 269

select object_name into name from bism_objects where object_id = oid;

Line: 291

select object_name into oname from bism_objects where object_id = oid;

Line: 310

function dummy_op2(oid raw,fid raw,current_selection_is_folder varchar2,myid raw)
return varchar2
is
begin
return 'y';