DBA Data[Home] [Help]

APPS.BISM_CORE dependencies on BISM_ACL_OBJ_T

Line 876: function add_entries(fid in raw,acllist in out nocopy bism_acl_obj_t,myid in raw,cascade in varchar2,topfolder in varchar2)

872: and t2.subject_id = t1.subject_id;
873: return v_rc;
874: end;
875:
876: function add_entries(fid in raw,acllist in out nocopy bism_acl_obj_t,myid in raw,cascade in varchar2,topfolder in varchar2)
877: return bism_acl_obj_t
878: is
879: begin
880: return add_entries(fid,acllist,myid,cascade,'n',topfolder,'y');

Line 877: return bism_acl_obj_t

873: return v_rc;
874: end;
875:
876: function add_entries(fid in raw,acllist in out nocopy bism_acl_obj_t,myid in raw,cascade in varchar2,topfolder in varchar2)
877: return bism_acl_obj_t
878: is
879: begin
880: return add_entries(fid,acllist,myid,cascade,'n',topfolder,'y');
881: end;

Line 884: -- function add_entries(fid in raw,acllist in out nocopy bism_acl_obj_t,myid in raw,cascade in varchar2,topfolder in varchar2)

880: return add_entries(fid,acllist,myid,cascade,'n',topfolder,'y');
881: end;
882:
883: procedure add_entries_30(fid in raw,acllist in CLOB,myid in raw,cascade in varchar2,topfolder in varchar2, aclseparator in varchar2)
884: -- function add_entries(fid in raw,acllist in out nocopy bism_acl_obj_t,myid in raw,cascade in varchar2,topfolder in varchar2)
885: -- return bism_acl_obj_t
886: is
887: begin
888: add_entries_30(fid,acllist,myid,cascade,'N',topfolder,'Y',aclseparator);

Line 885: -- return bism_acl_obj_t

881: end;
882:
883: procedure add_entries_30(fid in raw,acllist in CLOB,myid in raw,cascade in varchar2,topfolder in varchar2, aclseparator in varchar2)
884: -- function add_entries(fid in raw,acllist in out nocopy bism_acl_obj_t,myid in raw,cascade in varchar2,topfolder in varchar2)
885: -- return bism_acl_obj_t
886: is
887: begin
888: add_entries_30(fid,acllist,myid,cascade,'N',topfolder,'Y',aclseparator);
889: end;

Line 891: function remove_entries(fid in raw,acllist in out nocopy bism_acl_obj_t,myid in raw,cascade in varchar2,topfolder in varchar2)

887: begin
888: add_entries_30(fid,acllist,myid,cascade,'N',topfolder,'Y',aclseparator);
889: end;
890:
891: function remove_entries(fid in raw,acllist in out nocopy bism_acl_obj_t,myid in raw,cascade in varchar2,topfolder in varchar2)
892: return bism_chararray_t
893: is
894: begin
895: return remove_entries(fid,acllist,myid,cascade,'n',topfolder,'y');

Line 2566: function add_entries(oid in raw,acllist in out nocopy bism_acl_obj_t,myid in raw,cascade_to_subfolders in varchar2,cascade_to_objs in varchar2,topfolder in varchar2,isfolder in varchar2)

2562: -- end refactoring code for init, bind, rebind, createSubcontext
2563:
2564:
2565: -- new methods for object level security feature
2566: function add_entries(oid in raw,acllist in out nocopy bism_acl_obj_t,myid in raw,cascade_to_subfolders in varchar2,cascade_to_objs in varchar2,topfolder in varchar2,isfolder in varchar2)
2567: return bism_acl_obj_t
2568: is
2569: newguid bism_objects.object_id%type:= null;
2570: username bism_subjects.subject_name%type;

Line 2567: return bism_acl_obj_t

2563:
2564:
2565: -- new methods for object level security feature
2566: function add_entries(oid in raw,acllist in out nocopy bism_acl_obj_t,myid in raw,cascade_to_subfolders in varchar2,cascade_to_objs in varchar2,topfolder in varchar2,isfolder in varchar2)
2567: return bism_acl_obj_t
2568: is
2569: newguid bism_objects.object_id%type:= null;
2570: username bism_subjects.subject_name%type;
2571: objname bism_objects.object_name%type;

Line 2574: newusers bism_acl_obj_t := bism_acl_obj_t();

2570: username bism_subjects.subject_name%type;
2571: objname bism_objects.object_name%type;
2572: priv number(2);
2573: grantorpriv number(2);
2574: newusers bism_acl_obj_t := bism_acl_obj_t();
2575: dummy bism_acl_obj_t := bism_acl_obj_t();
2576: sid raw(16);
2577: begin
2578: if acllist.count = 0 then

Line 2575: dummy bism_acl_obj_t := bism_acl_obj_t();

2571: objname bism_objects.object_name%type;
2572: priv number(2);
2573: grantorpriv number(2);
2574: newusers bism_acl_obj_t := bism_acl_obj_t();
2575: dummy bism_acl_obj_t := bism_acl_obj_t();
2576: sid raw(16);
2577: begin
2578: if acllist.count = 0 then
2579: return null;

Line 2685: -- return bism_acl_obj_t

2681: return newusers;
2682: end add_entries;
2683:
2684: procedure add_entries_30(oid in raw,acllist in CLOB,myid in raw,cascade_to_subfolders in varchar2,cascade_to_objs in varchar2,topfolder in varchar2,isfolder in varchar2, aclseparator in varchar2)
2685: -- return bism_acl_obj_t
2686: is
2687: newguid bism_objects.object_id%type:= null;
2688: username bism_subjects.subject_name%type;
2689: objname bism_objects.object_name%type;

Line 2797: function remove_entries(oid in raw,acllist in out nocopy bism_acl_obj_t,myid in raw,cascade_to_subfolders in varchar2,cascade_to_objs in varchar2,topfolder in varchar2,isfolder in varchar2)

2793: end if;
2794: -- return newusers;
2795: end add_entries_30;
2796:
2797: function remove_entries(oid in raw,acllist in out nocopy bism_acl_obj_t,myid in raw,cascade_to_subfolders in varchar2,cascade_to_objs in varchar2,topfolder in varchar2,isfolder in varchar2)
2798: return bism_chararray_t
2799: is
2800: username bism_subjects.subject_name%type;
2801: objname bism_objects.object_name%type;

Line 3008: function set_entries(oid in raw,acllist in out nocopy bism_acl_obj_t,myid in raw,cascade_to_subfolders in varchar2,cascade_to_objs in varchar2,topfolder in varchar2,isfolder in varchar2)

3004: end remove_entries_30;
3005:
3006: -- new function (ccchow)
3007: -- basically, same as add_entires except replaces every acl
3008: function set_entries(oid in raw,acllist in out nocopy bism_acl_obj_t,myid in raw,cascade_to_subfolders in varchar2,cascade_to_objs in varchar2,topfolder in varchar2,isfolder in varchar2)
3009: return bism_acl_obj_t
3010: is
3011: newguid bism_objects.object_id%type:= null;
3012: objname bism_objects.object_name%type;

Line 3009: return bism_acl_obj_t

3005:
3006: -- new function (ccchow)
3007: -- basically, same as add_entires except replaces every acl
3008: function set_entries(oid in raw,acllist in out nocopy bism_acl_obj_t,myid in raw,cascade_to_subfolders in varchar2,cascade_to_objs in varchar2,topfolder in varchar2,isfolder in varchar2)
3009: return bism_acl_obj_t
3010: is
3011: newguid bism_objects.object_id%type:= null;
3012: objname bism_objects.object_name%type;
3013: username bism_subjects.subject_name%type;

Line 3016: newusers bism_acl_obj_t := bism_acl_obj_t();

3012: objname bism_objects.object_name%type;
3013: username bism_subjects.subject_name%type;
3014: priv number(2);
3015: grantorpriv number(2);
3016: newusers bism_acl_obj_t := bism_acl_obj_t();
3017: dummy bism_acl_obj_t := bism_acl_obj_t();
3018: sid raw(16);
3019: begin
3020: -- make sure grantor has privilege and enough privilege

Line 3017: dummy bism_acl_obj_t := bism_acl_obj_t();

3013: username bism_subjects.subject_name%type;
3014: priv number(2);
3015: grantorpriv number(2);
3016: newusers bism_acl_obj_t := bism_acl_obj_t();
3017: dummy bism_acl_obj_t := bism_acl_obj_t();
3018: sid raw(16);
3019: begin
3020: -- make sure grantor has privilege and enough privilege
3021: select max(privilege) into grantorpriv from bism_permissions where object_id = oid and subject_id in (select group_id from bism_groups where user_id = myid);