APPS.BISM_CORE dependencies on DBMS_LOB

Line 2698: if (acllist is null) or (DBMS_LOB.getlength(acllist) = 0) then

2694: usrnm BISM_SUBJECTS.SUBJECT_NAME%TYPE;
2695: usrpriv BISM_PERMISSIONS.PRIVILEGE%TYPE;
2696: usrtype BISM_SUBJECTS.SUBJECT_TYPE%TYPE;
2697: begin
2698: if (acllist is null) or (DBMS_LOB.getlength(acllist) = 0) then
2699: return;
2700: end if;
2701:
2702: 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);

Line 2918: if (acllist is null) or (DBMS_LOB.getlength(acllist) = 0) then

2914: -- used for cascading acl to objects
2915: type oid_t is table of bism_objects.object_id%type;
2916: oid_var oid_t := oid_t();
2917: begin
2918: if (acllist is null) or (DBMS_LOB.getlength(acllist) = 0) then
2919: return null;
2920: end if;
2921:
2922: 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);

Line 3134: if (acllist is null) or (DBMS_LOB.getlength(acllist) = 0) then

3130: usrtype BISM_SUBJECTS.SUBJECT_TYPE%TYPE;
3131: firstTime boolean := true;
3132: begin
3133:
3134: if (acllist is null) or (DBMS_LOB.getlength(acllist) = 0) then
3135: return;
3136: end if;
3137:
3138: -- make sure grantor has privilege and enough privilege