eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BISM_CORE dependencies on BISM_SUBJECTS

Line 219: select subject_id into sub_id from bism_subjects where subject_name = grantee_name;

215: end;
216:
217: ret := bism_access_control.check_fullcontrol_access(fid,grantor);
218: if ret = 'y' then
219: select subject_id into sub_id from bism_subjects where subject_name = grantee_name;
220: insert into bism_permissions (subject_id,object_id,privilege) values(sub_id,fid,priv);
221: if bism_core.v_auto_commit = TRUE then
222: commit;
223: end if;

Line 228: raise_application_error(BISM_ERRORCODES.USER_NOT_FOUND,'Grantee not found in BISM_SUBJECTS table');

224:
225: end if;
226: exception
227: when no_data_found then
228: raise_application_error(BISM_ERRORCODES.USER_NOT_FOUND,'Grantee not found in BISM_SUBJECTS table');
229: end set_privilege;
230:
231:
232:

Line 781: decode(CREATED_BY,CREATED_BY,(select subject_name from bism_subjects where subject_id = created_by and subject_type='u'),null),

777: begin
778: open v_rc for
779: select USER_VISIBLE,OBJECT_TYPE_ID,VERSION,TIME_DATE_CREATED,TIME_DATE_MODIFIED,OBJECT_ID,
780: CONTAINER_ID,FOLDER_ID,
781: decode(CREATED_BY,CREATED_BY,(select subject_name from bism_subjects where subject_id = created_by and subject_type='u'),null),
782: decode(LAST_MODIFIED_BY,LAST_MODIFIED_BY,(select subject_name from bism_subjects where subject_id = LAST_MODIFIED_BY and subject_type='u'), null),
783: OBJECT_NAME,TITLE,APPLICATION,DATABASE,
784: DESCRIPTION,KEYWORDS,APPLICATION_SUBTYPE1,COMP_SUBTYPE1,COMP_SUBTYPE2,COMP_SUBTYPE3,TIME_DATE_LAST_ACCESSED
785: from bism_objects

Line 782: decode(LAST_MODIFIED_BY,LAST_MODIFIED_BY,(select subject_name from bism_subjects where subject_id = LAST_MODIFIED_BY and subject_type='u'), null),

778: open v_rc for
779: select USER_VISIBLE,OBJECT_TYPE_ID,VERSION,TIME_DATE_CREATED,TIME_DATE_MODIFIED,OBJECT_ID,
780: CONTAINER_ID,FOLDER_ID,
781: decode(CREATED_BY,CREATED_BY,(select subject_name from bism_subjects where subject_id = created_by and subject_type='u'),null),
782: decode(LAST_MODIFIED_BY,LAST_MODIFIED_BY,(select subject_name from bism_subjects where subject_id = LAST_MODIFIED_BY and subject_type='u'), null),
783: OBJECT_NAME,TITLE,APPLICATION,DATABASE,
784: DESCRIPTION,KEYWORDS,APPLICATION_SUBTYPE1,COMP_SUBTYPE1,COMP_SUBTYPE2,COMP_SUBTYPE3,TIME_DATE_LAST_ACCESSED
785: from bism_objects
786: where 'y' = bism_core.check_get_attrs_access(p_fid,p_objname,p_myid)

Line 835: v_subid bism_subjects.subject_id%type;

831: --
832: function check_user_privileges(p_username varchar2, p_oid raw, p_myid raw)
833: return number
834: is
835: v_subid bism_subjects.subject_id%type;
836: v_priv bism_permissions.privilege%type;
837: begin
838: begin
839: select subject_id into v_subid from bism_subjects where subject_name = p_username and subject_type='u';

Line 839: select subject_id into v_subid from bism_subjects where subject_name = p_username and subject_type='u';

835: v_subid bism_subjects.subject_id%type;
836: v_priv bism_permissions.privilege%type;
837: begin
838: begin
839: select subject_id into v_subid from bism_subjects where subject_name = p_username and subject_type='u';
840: exception
841: when no_data_found then
842: raise_application_error(-20503,'User not found');
843: end;

Line 864: (select subject_name from bism_subjects where subject_id = t1.subject_id),

860: v_rc myrctype;
861: begin
862: open v_rc for
863: select decode(t1.subject_id, t1.subject_id,
864: (select subject_name from bism_subjects where subject_id = t1.subject_id),
865: null),
866: t1.privilege,
867: t2.subject_type
868: from bism_permissions t1,

Line 869: bism_subjects t2

865: null),
866: t1.privilege,
867: t2.subject_type
868: from bism_permissions t1,
869: bism_subjects t2
870: where 'y' = bism_access_control.check_show_entries_access(p_oid,p_myid)
871: and t1.object_id = p_oid
872: and t2.subject_id = t1.subject_id;
873: return v_rc;

Line 1804: (select subject_name from bism_subjects where subject_id = CREATED_BY and subject_type='u'),

1800: open rc for
1801: select USER_VISIBLE, OBJECT_TYPE_ID, VERSION, TIME_DATE_CREATED, TIME_DATE_MODIFIED,
1802: OBJECT_ID, CONTAINER_ID, FOLDER_ID,
1803: decode(CREATED_BY, CREATED_BY,
1804: (select subject_name from bism_subjects where subject_id = CREATED_BY and subject_type='u'),
1805: null),
1806: decode(LAST_MODIFIED_BY, LAST_MODIFIED_BY,
1807: (select subject_name from bism_subjects where subject_id = LAST_MODIFIED_BY and subject_type='u'),
1808: null),

Line 1807: (select subject_name from bism_subjects where subject_id = LAST_MODIFIED_BY and subject_type='u'),

1803: decode(CREATED_BY, CREATED_BY,
1804: (select subject_name from bism_subjects where subject_id = CREATED_BY and subject_type='u'),
1805: null),
1806: decode(LAST_MODIFIED_BY, LAST_MODIFIED_BY,
1807: (select subject_name from bism_subjects where subject_id = LAST_MODIFIED_BY and subject_type='u'),
1808: null),
1809: OBJECT_NAME, TITLE, APPLICATION, DATABASE, DESCRIPTION, KEYWORDS, XML,
1810: APPLICATION_SUBTYPE1, COMP_SUBTYPE1, COMP_SUBTYPE2, COMP_SUBTYPE3,
1811: decode(USER_VISIBLE,'Y',bism_core.get_object_full_name(object_id),'') FULLNAME

Line 1846: (select subject_name from bism_subjects where subject_id = T1.CREATED_BY and subject_type='u'),

1842: open rc for
1843: select T1.USER_VISIBLE, T1.OBJECT_TYPE_ID, T1.VERSION, T1.TIME_DATE_CREATED, T1.TIME_DATE_MODIFIED,
1844: T1.OBJECT_ID, T1.CONTAINER_ID, T1.FOLDER_ID,
1845: decode(T1.CREATED_BY, T1.CREATED_BY,
1846: (select subject_name from bism_subjects where subject_id = T1.CREATED_BY and subject_type='u'),
1847: null),
1848: decode(T1.LAST_MODIFIED_BY, T1.LAST_MODIFIED_BY,
1849: (select subject_name from bism_subjects where subject_id = T1.LAST_MODIFIED_BY and subject_type='u'),
1850: null),

Line 1849: (select subject_name from bism_subjects where subject_id = T1.LAST_MODIFIED_BY and subject_type='u'),

1845: decode(T1.CREATED_BY, T1.CREATED_BY,
1846: (select subject_name from bism_subjects where subject_id = T1.CREATED_BY and subject_type='u'),
1847: null),
1848: decode(T1.LAST_MODIFIED_BY, T1.LAST_MODIFIED_BY,
1849: (select subject_name from bism_subjects where subject_id = T1.LAST_MODIFIED_BY and subject_type='u'),
1850: null),
1851: T1.OBJECT_NAME, T1.TITLE, T1.APPLICATION, T1.DATABASE, T1.DESCRIPTION, T1.KEYWORDS, T1.XML,
1852: T1.APPLICATION_SUBTYPE1, T1.COMP_SUBTYPE1, T1.COMP_SUBTYPE2, T1.COMP_SUBTYPE3, T1.TIME_DATE_LAST_ACCESSED, T2.container_id,
1853: T2.containee_id,T2.AGGREGATE_INFO,

Line 1894: (select subject_name from bism_subjects where subject_id = T1.CREATED_BY and subject_type='u'),

1890: open rc for
1891: SELECT /*+ NO_MERGE */ T1.USER_VISIBLE, T1.OBJECT_TYPE_ID, T1.VERSION, T1.TIME_DATE_CREATED,
1892: T1.TIME_DATE_MODIFIED, T1.OBJECT_ID, T1.CONTAINER_ID, T1.FOLDER_ID,
1893: decode(T1.CREATED_BY, T1.CREATED_BY,
1894: (select subject_name from bism_subjects where subject_id = T1.CREATED_BY and subject_type='u'),
1895: null),
1896: decode(T1.LAST_MODIFIED_BY, T1.LAST_MODIFIED_BY,
1897: (select subject_name from bism_subjects where subject_id = T1.LAST_MODIFIED_BY and subject_type='u'),
1898: null),

Line 1897: (select subject_name from bism_subjects where subject_id = T1.LAST_MODIFIED_BY and subject_type='u'),

1893: decode(T1.CREATED_BY, T1.CREATED_BY,
1894: (select subject_name from bism_subjects where subject_id = T1.CREATED_BY and subject_type='u'),
1895: null),
1896: decode(T1.LAST_MODIFIED_BY, T1.LAST_MODIFIED_BY,
1897: (select subject_name from bism_subjects where subject_id = T1.LAST_MODIFIED_BY and subject_type='u'),
1898: null),
1899: T1.OBJECT_NAME, T1.TITLE, T1.APPLICATION, T1.DATABASE, T1.DESCRIPTION,
1900: T1.KEYWORDS, T1.XML, T1.APPLICATION_SUBTYPE1, T1.COMP_SUBTYPE1, T1.COMP_SUBTYPE2,T1.COMP_SUBTYPE3, T1.TIME_DATE_LAST_ACCESSED,
1901: T2.container_id, T2.containee_id, T2.AGGREGATE_INFO

Line 1950: decode(T.CREATED_BY,T.CREATED_BY,(select subject_name from bism_subjects where subject_id = T.CREATED_BY and subject_type='u'),null),

1946: begin
1947: open rc for
1948: SELECT /*+ NO_MERGE */ T.USER_VISIBLE, T.OBJECT_TYPE_ID, T.VERSION, T.TIME_DATE_CREATED,
1949: T.TIME_DATE_MODIFIED, T.OBJECT_ID,T.FOLDER_ID,
1950: decode(T.CREATED_BY,T.CREATED_BY,(select subject_name from bism_subjects where subject_id = T.CREATED_BY and subject_type='u'),null),
1951: decode(T.LAST_MODIFIED_BY,T.LAST_MODIFIED_BY,(select subject_name from bism_subjects where subject_id = T.LAST_MODIFIED_BY and subject_type='u'),null),
1952: T.OBJECT_NAME, T.TITLE, T.APPLICATION, T.DATABASE, T.DESCRIPTION,
1953: T.KEYWORDS, T.XML, T.APPLICATION_SUBTYPE1, T.COMP_SUBTYPE1, T.COMP_SUBTYPE2,T.COMP_SUBTYPE3, T.TIME_DATE_LAST_ACCESSED,
1954: /*1. containee_id is not fetched from bism_aggregates because it is pulling several extra rows

Line 1951: decode(T.LAST_MODIFIED_BY,T.LAST_MODIFIED_BY,(select subject_name from bism_subjects where subject_id = T.LAST_MODIFIED_BY and subject_type='u'),null),

1947: open rc for
1948: SELECT /*+ NO_MERGE */ T.USER_VISIBLE, T.OBJECT_TYPE_ID, T.VERSION, T.TIME_DATE_CREATED,
1949: T.TIME_DATE_MODIFIED, T.OBJECT_ID,T.FOLDER_ID,
1950: decode(T.CREATED_BY,T.CREATED_BY,(select subject_name from bism_subjects where subject_id = T.CREATED_BY and subject_type='u'),null),
1951: decode(T.LAST_MODIFIED_BY,T.LAST_MODIFIED_BY,(select subject_name from bism_subjects where subject_id = T.LAST_MODIFIED_BY and subject_type='u'),null),
1952: T.OBJECT_NAME, T.TITLE, T.APPLICATION, T.DATABASE, T.DESCRIPTION,
1953: T.KEYWORDS, T.XML, T.APPLICATION_SUBTYPE1, T.COMP_SUBTYPE1, T.COMP_SUBTYPE2,T.COMP_SUBTYPE3, T.TIME_DATE_LAST_ACCESSED,
1954: /*1. containee_id is not fetched from bism_aggregates because it is pulling several extra rows
1955: when an object is shared by multiple containers, however containee_id is same as object_id

Line 2032: p_subid bism_subjects.SUBJECT_ID%type)

2028: end rename_object;
2029:
2030: function list
2031: (p_fid bism_objects.FOLDER_ID%type,
2032: p_subid bism_subjects.SUBJECT_ID%type)
2033: return myrctype
2034: is
2035: rc myrctype;
2036: begin

Line 2056: function init(p_subname in bism_subjects.subject_name%type)

2052: end list;
2053:
2054:
2055: -- begin refactoring code for init, bind, rebind, createSubcontext
2056: function init(p_subname in bism_subjects.subject_name%type)
2057: return bism_subjects.subject_id%type
2058: is
2059: subid bism_subjects.subject_id%type;
2060: oid bism_objects.object_id%type := null;

Line 2057: return bism_subjects.subject_id%type

2053:
2054:
2055: -- begin refactoring code for init, bind, rebind, createSubcontext
2056: function init(p_subname in bism_subjects.subject_name%type)
2057: return bism_subjects.subject_id%type
2058: is
2059: subid bism_subjects.subject_id%type;
2060: oid bism_objects.object_id%type := null;
2061: priv bism_permissions.privilege%type := 0;

Line 2059: subid bism_subjects.subject_id%type;

2055: -- begin refactoring code for init, bind, rebind, createSubcontext
2056: function init(p_subname in bism_subjects.subject_name%type)
2057: return bism_subjects.subject_id%type
2058: is
2059: subid bism_subjects.subject_id%type;
2060: oid bism_objects.object_id%type := null;
2061: priv bism_permissions.privilege%type := 0;
2062: begin
2063: /* make sure root folder exists */

Line 2073: select subject_id into subid from bism_subjects where subject_name = p_subname and subject_type= 'u';

2069: end;
2070:
2071: /* make sure user exists */
2072: begin
2073: select subject_id into subid from bism_subjects where subject_name = p_subname and subject_type= 'u';
2074: exception
2075: when no_data_found then
2076: raise_application_error (BISM_ERRORCODES.USER_NOT_IDENTIFIED,'User could not be identified');
2077: end;

Line 2097: p_creator bism_subjects.subject_name%type,

2093:
2094: function create_subcontext
2095: (p_tempTimeC bism_objects.time_date_created%type,
2096: p_tempTimeM bism_objects.time_date_modified%type,
2097: p_creator bism_subjects.subject_name%type,
2098: p_modifier bism_subjects.subject_name%type,
2099: p_fid bism_objects.folder_id%type,
2100: p_subid bism_subjects.subject_id%type,
2101: p_version bism_objects.VERSION%type,

Line 2098: p_modifier bism_subjects.subject_name%type,

2094: function create_subcontext
2095: (p_tempTimeC bism_objects.time_date_created%type,
2096: p_tempTimeM bism_objects.time_date_modified%type,
2097: p_creator bism_subjects.subject_name%type,
2098: p_modifier bism_subjects.subject_name%type,
2099: p_fid bism_objects.folder_id%type,
2100: p_subid bism_subjects.subject_id%type,
2101: p_version bism_objects.VERSION%type,
2102: p_object_name bism_objects.object_name%type,

Line 2100: p_subid bism_subjects.subject_id%type,

2096: p_tempTimeM bism_objects.time_date_modified%type,
2097: p_creator bism_subjects.subject_name%type,
2098: p_modifier bism_subjects.subject_name%type,
2099: p_fid bism_objects.folder_id%type,
2100: p_subid bism_subjects.subject_id%type,
2101: p_version bism_objects.VERSION%type,
2102: p_object_name bism_objects.object_name%type,
2103: p_title bism_objects.title%type,
2104: p_application bism_objects.application%type,

Line 2114: sub_id bism_subjects.subject_id%type;

2110: p_compsubtype2 bism_objects.COMP_SUBTYPE2%type,
2111: p_compsubtype3 bism_objects.COMP_SUBTYPE3%type)
2112: return bism_objects.object_id%type
2113: is
2114: sub_id bism_subjects.subject_id%type;
2115: oid bism_objects.object_id%type;
2116: oname bism_objects.object_name%type;
2117: fid bism_objects.folder_id%type;
2118: created_subid bism_subjects.subject_id%type;

Line 2118: created_subid bism_subjects.subject_id%type;

2114: sub_id bism_subjects.subject_id%type;
2115: oid bism_objects.object_id%type;
2116: oname bism_objects.object_name%type;
2117: fid bism_objects.folder_id%type;
2118: created_subid bism_subjects.subject_id%type;
2119: modified_subid bism_subjects.subject_id%type;
2120: timeC bism_objects.time_date_created%type := sysdate;
2121: timeM bism_objects.time_date_modified%type := sysdate;
2122: tempTimeC bism_objects.time_date_created%type := null;

Line 2119: modified_subid bism_subjects.subject_id%type;

2115: oid bism_objects.object_id%type;
2116: oname bism_objects.object_name%type;
2117: fid bism_objects.folder_id%type;
2118: created_subid bism_subjects.subject_id%type;
2119: modified_subid bism_subjects.subject_id%type;
2120: timeC bism_objects.time_date_created%type := sysdate;
2121: timeM bism_objects.time_date_modified%type := sysdate;
2122: tempTimeC bism_objects.time_date_created%type := null;
2123: tempTimeM bism_objects.time_date_modified%type := null;

Line 2129: select subject_id into created_subid from bism_subjects where subject_name = p_creator and subject_type = 'u';

2125: begin
2126: begin
2127: tempTimeC := p_tempTimeC;
2128: tempTimeM := p_tempTimeM;
2129: select subject_id into created_subid from bism_subjects where subject_name = p_creator and subject_type = 'u';
2130: if p_creator <> p_modifier then
2131: select subject_id into modified_subid from bism_subjects where subject_name = p_modifier and subject_type = 'u';
2132: else
2133: modified_subid := created_subid;

Line 2131: select subject_id into modified_subid from bism_subjects where subject_name = p_modifier and subject_type = 'u';

2127: tempTimeC := p_tempTimeC;
2128: tempTimeM := p_tempTimeM;
2129: select subject_id into created_subid from bism_subjects where subject_name = p_creator and subject_type = 'u';
2130: if p_creator <> p_modifier then
2131: select subject_id into modified_subid from bism_subjects where subject_name = p_modifier and subject_type = 'u';
2132: else
2133: modified_subid := created_subid;
2134: end if;
2135: exception

Line 2171: p_creator bism_subjects.subject_name%type,

2167: function create_subcontext_30
2168: (p_tempTimeC bism_objects.time_date_created%type,
2169: p_tempTimeM bism_objects.time_date_modified%type,
2170: p_oid bism_objects.object_id%type,
2171: p_creator bism_subjects.subject_name%type,
2172: p_modifier bism_subjects.subject_name%type,
2173: p_fid bism_objects.folder_id%type,
2174: p_subid bism_subjects.subject_id%type,
2175: p_version bism_objects.VERSION%type,

Line 2172: p_modifier bism_subjects.subject_name%type,

2168: (p_tempTimeC bism_objects.time_date_created%type,
2169: p_tempTimeM bism_objects.time_date_modified%type,
2170: p_oid bism_objects.object_id%type,
2171: p_creator bism_subjects.subject_name%type,
2172: p_modifier bism_subjects.subject_name%type,
2173: p_fid bism_objects.folder_id%type,
2174: p_subid bism_subjects.subject_id%type,
2175: p_version bism_objects.VERSION%type,
2176: p_object_name bism_objects.object_name%type,

Line 2174: p_subid bism_subjects.subject_id%type,

2170: p_oid bism_objects.object_id%type,
2171: p_creator bism_subjects.subject_name%type,
2172: p_modifier bism_subjects.subject_name%type,
2173: p_fid bism_objects.folder_id%type,
2174: p_subid bism_subjects.subject_id%type,
2175: p_version bism_objects.VERSION%type,
2176: p_object_name bism_objects.object_name%type,
2177: p_title bism_objects.title%type,
2178: p_application bism_objects.application%type,

Line 2189: sub_id bism_subjects.subject_id%type;

2185: p_compsubtype3 bism_objects.COMP_SUBTYPE3%type,
2186: p_extAttrs_Clob CLOB)
2187: return bism_objects.object_id%type
2188: is
2189: sub_id bism_subjects.subject_id%type;
2190: oid bism_objects.object_id%type;
2191: oname bism_objects.object_name%type;
2192: fid bism_objects.folder_id%type;
2193: created_subid bism_subjects.subject_id%type;

Line 2193: created_subid bism_subjects.subject_id%type;

2189: sub_id bism_subjects.subject_id%type;
2190: oid bism_objects.object_id%type;
2191: oname bism_objects.object_name%type;
2192: fid bism_objects.folder_id%type;
2193: created_subid bism_subjects.subject_id%type;
2194: modified_subid bism_subjects.subject_id%type;
2195: timeC bism_objects.time_date_created%type := sysdate;
2196: timeM bism_objects.time_date_modified%type := sysdate;
2197: tempTimeC bism_objects.time_date_created%type := null;

Line 2194: modified_subid bism_subjects.subject_id%type;

2190: oid bism_objects.object_id%type;
2191: oname bism_objects.object_name%type;
2192: fid bism_objects.folder_id%type;
2193: created_subid bism_subjects.subject_id%type;
2194: modified_subid bism_subjects.subject_id%type;
2195: timeC bism_objects.time_date_created%type := sysdate;
2196: timeM bism_objects.time_date_modified%type := sysdate;
2197: tempTimeC bism_objects.time_date_created%type := null;
2198: tempTimeM bism_objects.time_date_modified%type := null;

Line 2207: select subject_id into created_subid from bism_subjects where subject_name = p_creator and subject_type = 'u';

2203: begin
2204: tempTimeC := p_tempTimeC;
2205: tempTimeM := p_tempTimeM;
2206:
2207: select subject_id into created_subid from bism_subjects where subject_name = p_creator and subject_type = 'u';
2208: if p_creator <> p_modifier then
2209: select subject_id into modified_subid from bism_subjects where subject_name = p_modifier and subject_type = 'u';
2210: else
2211: modified_subid := created_subid;

Line 2209: select subject_id into modified_subid from bism_subjects where subject_name = p_modifier and subject_type = 'u';

2205: tempTimeM := p_tempTimeM;
2206:
2207: select subject_id into created_subid from bism_subjects where subject_name = p_creator and subject_type = 'u';
2208: if p_creator <> p_modifier then
2209: select subject_id into modified_subid from bism_subjects where subject_name = p_modifier and subject_type = 'u';
2210: else
2211: modified_subid := created_subid;
2212: end if;
2213: exception

Line 2257: (p_creator bism_subjects.SUBJECT_NAME%type,

2253: return oid;
2254: end create_subcontext_30;
2255:
2256: procedure bind
2257: (p_creator bism_subjects.SUBJECT_NAME%type,
2258: p_modifier bism_subjects.SUBJECT_NAME%type,
2259: p_subject_id bism_subjects.SUBJECT_ID%type,
2260: p_visible bism_objects.USER_VISIBLE%type,
2261: p_obj_type_id bism_objects.OBJECT_TYPE_ID%type,

Line 2258: p_modifier bism_subjects.SUBJECT_NAME%type,

2254: end create_subcontext_30;
2255:
2256: procedure bind
2257: (p_creator bism_subjects.SUBJECT_NAME%type,
2258: p_modifier bism_subjects.SUBJECT_NAME%type,
2259: p_subject_id bism_subjects.SUBJECT_ID%type,
2260: p_visible bism_objects.USER_VISIBLE%type,
2261: p_obj_type_id bism_objects.OBJECT_TYPE_ID%type,
2262: p_version bism_objects.VERSION%type,

Line 2259: p_subject_id bism_subjects.SUBJECT_ID%type,

2255:
2256: procedure bind
2257: (p_creator bism_subjects.SUBJECT_NAME%type,
2258: p_modifier bism_subjects.SUBJECT_NAME%type,
2259: p_subject_id bism_subjects.SUBJECT_ID%type,
2260: p_visible bism_objects.USER_VISIBLE%type,
2261: p_obj_type_id bism_objects.OBJECT_TYPE_ID%type,
2262: p_version bism_objects.VERSION%type,
2263: p_time_created bism_objects.TIME_DATE_CREATED%type,

Line 2286: created_subid bism_subjects.subject_id%type;

2282: p_time_last_loaded bism_objects.TIME_DATE_LAST_ACCESSED%type
2283: )
2284: is
2285: ret varchar2(1);
2286: created_subid bism_subjects.subject_id%type;
2287: modified_subid bism_subjects.subject_id%type;
2288: p_ext_attrs bism_objects.extensible_attributes%type := null;
2289: begin
2290: begin

Line 2287: modified_subid bism_subjects.subject_id%type;

2283: )
2284: is
2285: ret varchar2(1);
2286: created_subid bism_subjects.subject_id%type;
2287: modified_subid bism_subjects.subject_id%type;
2288: p_ext_attrs bism_objects.extensible_attributes%type := null;
2289: begin
2290: begin
2291: select subject_id into created_subid from bism_subjects where subject_name = p_creator and subject_type ='u';

Line 2291: select subject_id into created_subid from bism_subjects where subject_name = p_creator and subject_type ='u';

2287: modified_subid bism_subjects.subject_id%type;
2288: p_ext_attrs bism_objects.extensible_attributes%type := null;
2289: begin
2290: begin
2291: select subject_id into created_subid from bism_subjects where subject_name = p_creator and subject_type ='u';
2292: if p_creator <> p_modifier then
2293: select subject_id into modified_subid from bism_subjects where subject_name = p_modifier and subject_type = 'u';
2294: else
2295: modified_subid := created_subid;

Line 2293: select subject_id into modified_subid from bism_subjects where subject_name = p_modifier and subject_type = 'u';

2289: begin
2290: begin
2291: select subject_id into created_subid from bism_subjects where subject_name = p_creator and subject_type ='u';
2292: if p_creator <> p_modifier then
2293: select subject_id into modified_subid from bism_subjects where subject_name = p_modifier and subject_type = 'u';
2294: else
2295: modified_subid := created_subid;
2296: end if;
2297: exception

Line 2330: (p_creator bism_subjects.SUBJECT_NAME%type,

2326: end bind;
2327:
2328:
2329: procedure bind
2330: (p_creator bism_subjects.SUBJECT_NAME%type,
2331: p_modifier bism_subjects.SUBJECT_NAME%type,
2332: p_subject_id bism_subjects.SUBJECT_ID%type,
2333: p_visible bism_objects.USER_VISIBLE%type,
2334: p_obj_type_id bism_objects.OBJECT_TYPE_ID%type,

Line 2331: p_modifier bism_subjects.SUBJECT_NAME%type,

2327:
2328:
2329: procedure bind
2330: (p_creator bism_subjects.SUBJECT_NAME%type,
2331: p_modifier bism_subjects.SUBJECT_NAME%type,
2332: p_subject_id bism_subjects.SUBJECT_ID%type,
2333: p_visible bism_objects.USER_VISIBLE%type,
2334: p_obj_type_id bism_objects.OBJECT_TYPE_ID%type,
2335: p_version bism_objects.VERSION%type,

Line 2332: p_subject_id bism_subjects.SUBJECT_ID%type,

2328:
2329: procedure bind
2330: (p_creator bism_subjects.SUBJECT_NAME%type,
2331: p_modifier bism_subjects.SUBJECT_NAME%type,
2332: p_subject_id bism_subjects.SUBJECT_ID%type,
2333: p_visible bism_objects.USER_VISIBLE%type,
2334: p_obj_type_id bism_objects.OBJECT_TYPE_ID%type,
2335: p_version bism_objects.VERSION%type,
2336: p_time_created bism_objects.TIME_DATE_CREATED%type,

Line 2357: created_subid bism_subjects.subject_id%type;

2353: p_aggregate_info bism_aggregates.AGGREGATE_INFO%type
2354: )
2355: is
2356: ret varchar2(1);
2357: created_subid bism_subjects.subject_id%type;
2358: modified_subid bism_subjects.subject_id%type;
2359: begin
2360: begin
2361: select subject_id into created_subid from bism_subjects where subject_name = p_creator and subject_type ='u';

Line 2358: modified_subid bism_subjects.subject_id%type;

2354: )
2355: is
2356: ret varchar2(1);
2357: created_subid bism_subjects.subject_id%type;
2358: modified_subid bism_subjects.subject_id%type;
2359: begin
2360: begin
2361: select subject_id into created_subid from bism_subjects where subject_name = p_creator and subject_type ='u';
2362: if p_creator <> p_modifier then

Line 2361: select subject_id into created_subid from bism_subjects where subject_name = p_creator and subject_type ='u';

2357: created_subid bism_subjects.subject_id%type;
2358: modified_subid bism_subjects.subject_id%type;
2359: begin
2360: begin
2361: select subject_id into created_subid from bism_subjects where subject_name = p_creator and subject_type ='u';
2362: if p_creator <> p_modifier then
2363: select subject_id into modified_subid from bism_subjects where subject_name = p_modifier and subject_type = 'u';
2364: else
2365: modified_subid := created_subid;

Line 2363: select subject_id into modified_subid from bism_subjects where subject_name = p_modifier and subject_type = 'u';

2359: begin
2360: begin
2361: select subject_id into created_subid from bism_subjects where subject_name = p_creator and subject_type ='u';
2362: if p_creator <> p_modifier then
2363: select subject_id into modified_subid from bism_subjects where subject_name = p_modifier and subject_type = 'u';
2364: else
2365: modified_subid := created_subid;
2366: end if;
2367: exception

Line 2402: p_subid bism_subjects.SUBJECT_ID%type)

2398: end bind_aggregate;
2399:
2400: function list_bindings
2401: (p_fid bism_objects.FOLDER_ID%type,
2402: p_subid bism_subjects.SUBJECT_ID%type)
2403: return myrctype
2404: is
2405: rc myrctype;
2406: begin

Line 2412: (p_creator bism_subjects.SUBJECT_NAME%type,

2408: return rc;
2409: end list_bindings;
2410:
2411: procedure rebind
2412: (p_creator bism_subjects.SUBJECT_NAME%type,
2413: p_modifier bism_subjects.SUBJECT_NAME%type,
2414: p_subject_id bism_subjects.SUBJECT_ID%type,
2415: p_visible bism_objects.USER_VISIBLE%type,
2416: p_obj_type_id bism_objects.OBJECT_TYPE_ID%type,

Line 2413: p_modifier bism_subjects.SUBJECT_NAME%type,

2409: end list_bindings;
2410:
2411: procedure rebind
2412: (p_creator bism_subjects.SUBJECT_NAME%type,
2413: p_modifier bism_subjects.SUBJECT_NAME%type,
2414: p_subject_id bism_subjects.SUBJECT_ID%type,
2415: p_visible bism_objects.USER_VISIBLE%type,
2416: p_obj_type_id bism_objects.OBJECT_TYPE_ID%type,
2417: p_version bism_objects.VERSION%type,

Line 2414: p_subject_id bism_subjects.SUBJECT_ID%type,

2410:
2411: procedure rebind
2412: (p_creator bism_subjects.SUBJECT_NAME%type,
2413: p_modifier bism_subjects.SUBJECT_NAME%type,
2414: p_subject_id bism_subjects.SUBJECT_ID%type,
2415: p_visible bism_objects.USER_VISIBLE%type,
2416: p_obj_type_id bism_objects.OBJECT_TYPE_ID%type,
2417: p_version bism_objects.VERSION%type,
2418: p_time_created bism_objects.TIME_DATE_CREATED%type,

Line 2440: created_subid bism_subjects.subject_id%type;

2436: p_aggregate_info bism_aggregates.AGGREGATE_INFO%type,
2437: p_obj_is_top_level varchar2)
2438: is
2439: ret varchar2(1);
2440: created_subid bism_subjects.subject_id%type;
2441: modified_subid bism_subjects.subject_id%type;
2442: p_ext_attrs bism_objects.extensible_attributes%type := null;
2443: begin
2444: begin

Line 2441: modified_subid bism_subjects.subject_id%type;

2437: p_obj_is_top_level varchar2)
2438: is
2439: ret varchar2(1);
2440: created_subid bism_subjects.subject_id%type;
2441: modified_subid bism_subjects.subject_id%type;
2442: p_ext_attrs bism_objects.extensible_attributes%type := null;
2443: begin
2444: begin
2445: select subject_id into created_subid from bism_subjects where subject_name = p_creator and subject_type ='u';

Line 2445: select subject_id into created_subid from bism_subjects where subject_name = p_creator and subject_type ='u';

2441: modified_subid bism_subjects.subject_id%type;
2442: p_ext_attrs bism_objects.extensible_attributes%type := null;
2443: begin
2444: begin
2445: select subject_id into created_subid from bism_subjects where subject_name = p_creator and subject_type ='u';
2446: select subject_id into modified_subid from bism_subjects where subject_name = p_modifier and subject_type ='u';
2447: exception
2448: when no_data_found then
2449: raise_application_error(-20503,'User not found');

Line 2446: select subject_id into modified_subid from bism_subjects where subject_name = p_modifier and subject_type ='u';

2442: p_ext_attrs bism_objects.extensible_attributes%type := null;
2443: begin
2444: begin
2445: select subject_id into created_subid from bism_subjects where subject_name = p_creator and subject_type ='u';
2446: select subject_id into modified_subid from bism_subjects where subject_name = p_modifier and subject_type ='u';
2447: exception
2448: when no_data_found then
2449: raise_application_error(-20503,'User not found');
2450: /* let other exceptions bubble up */

Line 2514: (p_creator bism_subjects.SUBJECT_NAME%type,

2510: end rebind;
2511:
2512:
2513: procedure rebind
2514: (p_creator bism_subjects.SUBJECT_NAME%type,
2515: p_modifier bism_subjects.SUBJECT_NAME%type,
2516: p_subject_id bism_subjects.SUBJECT_ID%type,
2517: p_visible bism_objects.USER_VISIBLE%type,
2518: p_obj_type_id bism_objects.OBJECT_TYPE_ID%type,

Line 2515: p_modifier bism_subjects.SUBJECT_NAME%type,

2511:
2512:
2513: procedure rebind
2514: (p_creator bism_subjects.SUBJECT_NAME%type,
2515: p_modifier bism_subjects.SUBJECT_NAME%type,
2516: p_subject_id bism_subjects.SUBJECT_ID%type,
2517: p_visible bism_objects.USER_VISIBLE%type,
2518: p_obj_type_id bism_objects.OBJECT_TYPE_ID%type,
2519: p_version bism_objects.VERSION%type,

Line 2516: p_subject_id bism_subjects.SUBJECT_ID%type,

2512:
2513: procedure rebind
2514: (p_creator bism_subjects.SUBJECT_NAME%type,
2515: p_modifier bism_subjects.SUBJECT_NAME%type,
2516: p_subject_id bism_subjects.SUBJECT_ID%type,
2517: p_visible bism_objects.USER_VISIBLE%type,
2518: p_obj_type_id bism_objects.OBJECT_TYPE_ID%type,
2519: p_version bism_objects.VERSION%type,
2520: p_time_created bism_objects.TIME_DATE_CREATED%type,

Line 2538: created_subid bism_subjects.subject_id%type;

2534: p_compsubtype2 bism_objects.COMP_SUBTYPE2%type,
2535: p_compsubtype3 bism_objects.COMP_SUBTYPE3%type)
2536: is
2537: ret varchar2(1);
2538: created_subid bism_subjects.subject_id%type;
2539: modified_subid bism_subjects.subject_id%type;
2540: begin
2541: begin
2542: select subject_id into created_subid from bism_subjects where subject_name = p_creator and subject_type ='u';

Line 2539: modified_subid bism_subjects.subject_id%type;

2535: p_compsubtype3 bism_objects.COMP_SUBTYPE3%type)
2536: is
2537: ret varchar2(1);
2538: created_subid bism_subjects.subject_id%type;
2539: modified_subid bism_subjects.subject_id%type;
2540: begin
2541: begin
2542: select subject_id into created_subid from bism_subjects where subject_name = p_creator and subject_type ='u';
2543: select subject_id into modified_subid from bism_subjects where subject_name = p_modifier and subject_type ='u';

Line 2542: select subject_id into created_subid from bism_subjects where subject_name = p_creator and subject_type ='u';

2538: created_subid bism_subjects.subject_id%type;
2539: modified_subid bism_subjects.subject_id%type;
2540: begin
2541: begin
2542: select subject_id into created_subid from bism_subjects where subject_name = p_creator and subject_type ='u';
2543: select subject_id into modified_subid from bism_subjects where subject_name = p_modifier and subject_type ='u';
2544: exception
2545: when no_data_found then
2546: raise_application_error(-20503,'User not found');

Line 2543: select subject_id into modified_subid from bism_subjects where subject_name = p_modifier and subject_type ='u';

2539: modified_subid bism_subjects.subject_id%type;
2540: begin
2541: begin
2542: select subject_id into created_subid from bism_subjects where subject_name = p_creator and subject_type ='u';
2543: select subject_id into modified_subid from bism_subjects where subject_name = p_modifier and subject_type ='u';
2544: exception
2545: when no_data_found then
2546: raise_application_error(-20503,'User not found');
2547: /* let other exceptions bubble up */

Line 2570: username bism_subjects.subject_name%type;

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;
2572: priv number(2);
2573: grantorpriv number(2);
2574: newusers bism_acl_obj_t := bism_acl_obj_t();

Line 2603: select subject_id into sid from bism_subjects where subject_name = acllist(i).subjname;

2599: if topfolder = 'y' or topfolder = 'Y' then
2600: for i in 1..acllist.count
2601: loop
2602: begin
2603: select subject_id into sid from bism_subjects where subject_name = acllist(i).subjname;
2604: acllist(i).subjid := sid;
2605: exception
2606: when no_data_found then
2607: --generate a new id for the new user

Line 2613: insert into bism_subjects (SUBJECT_ID, SUBJECT_NAME, SUBJECT_TYPE) values (newguid,acllist(i).subjname,'u');

2609: -- dont throw exception, instead return the acl object of the new user to
2610: -- the caller so that the JdbcAdapter can cache the name to Id mapping
2611: newusers.extend();
2612: newusers(newusers.count) := bism_acl_obj(acllist(i).subjname,acllist(i).privilege, newguid);
2613: insert into bism_subjects (SUBJECT_ID, SUBJECT_NAME, SUBJECT_TYPE) values (newguid,acllist(i).subjname,'u');
2614: insert into bism_groups (USER_ID, GROUP_ID) values(newguid,newguid);
2615: acllist(i).subjid := newguid;
2616: end;
2617: end loop;

Line 2688: username bism_subjects.subject_name%type;

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;
2690: priv number(2);
2691: grantorpriv number(2);
2692: sid bism_subjects.SUBJECT_ID%TYPE;

Line 2692: sid bism_subjects.SUBJECT_ID%TYPE;

2688: username bism_subjects.subject_name%type;
2689: objname bism_objects.object_name%type;
2690: priv number(2);
2691: grantorpriv number(2);
2692: sid bism_subjects.SUBJECT_ID%TYPE;
2693: startpos INTEGER := 1;
2694: usrnm BISM_SUBJECTS.SUBJECT_NAME%TYPE;
2695: usrpriv BISM_PERMISSIONS.PRIVILEGE%TYPE;
2696: usrtype BISM_SUBJECTS.SUBJECT_TYPE%TYPE;

Line 2694: usrnm BISM_SUBJECTS.SUBJECT_NAME%TYPE;

2690: priv number(2);
2691: grantorpriv number(2);
2692: sid bism_subjects.SUBJECT_ID%TYPE;
2693: startpos INTEGER := 1;
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

Line 2696: usrtype BISM_SUBJECTS.SUBJECT_TYPE%TYPE;

2692: sid bism_subjects.SUBJECT_ID%TYPE;
2693: startpos INTEGER := 1;
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;

Line 2729: select subject_id into sid from bism_subjects where subject_name = usrnm;

2725: usrtype := get_next_element(acllist,aclseparator,startpos);
2726: -- always do this for the top level objects: first time around
2727: if topfolder = 'Y' or topfolder = 'y' then
2728: begin
2729: select subject_id into sid from bism_subjects where subject_name = usrnm;
2730: exception
2731: when no_data_found then
2732: --generate a new id for the new user
2733: newguid := bism_utils.get_guid;

Line 2734: insert into bism_subjects (SUBJECT_ID, SUBJECT_NAME, SUBJECT_TYPE) values (newguid,usrnm,usrtype);

2730: exception
2731: when no_data_found then
2732: --generate a new id for the new user
2733: newguid := bism_utils.get_guid;
2734: insert into bism_subjects (SUBJECT_ID, SUBJECT_NAME, SUBJECT_TYPE) values (newguid,usrnm,usrtype);
2735: insert into bism_groups (USER_ID, GROUP_ID) values(newguid,newguid);
2736: sid := newguid;
2737: end;
2738: else

Line 2741: select subject_id into sid from bism_subjects where subject_name = usrnm;

2737: end;
2738: else
2739: -- same as in topfolder but there won't be an exception
2740: -- because we already inserted the user if he wasn't present
2741: select subject_id into sid from bism_subjects where subject_name = usrnm;
2742: end if;
2743:
2744: -- ok the grantor has enough privilege, proceed with adding entries
2745: if sid is not null then

Line 2800: username bism_subjects.subject_name%type;

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;
2802: priv number(2);
2803: grantorpriv number(2);
2804: errormsgs bism_chararray_t := bism_chararray_t();

Line 2838: select subject_id into sid from bism_subjects where subject_name = acllist(i).subjname;

2834: if topfolder = 'Y' or topfolder = 'y' then
2835: for i in 1..acllist.count
2836: loop
2837: begin
2838: select subject_id into sid from bism_subjects where subject_name = acllist(i).subjname;
2839: acllist(i).subjid := sid;
2840: exception
2841: when no_data_found then
2842: errors_occured := true;

Line 2900: username bism_subjects.subject_name%type;

2896: function remove_entries_30(oid in raw,acllist in out nocopy CLOB,myid in raw,cascade_to_subfolders in varchar2,cascade_to_objs in varchar2,topfolder in varchar2,isfolder in varchar2, aclseparator in varchar2)
2897: --return bism_chararray_t
2898: return varchar2
2899: is
2900: username bism_subjects.subject_name%type;
2901: objname bism_objects.object_name%type;
2902: priv number(2);
2903: grantorpriv number(2);
2904: errormsgs varchar2(32767) := '';

Line 2909: sid bism_subjects.SUBJECT_ID%TYPE;

2905: childerrormsgs varchar2(32767) := '';
2906: -- errormsgs bism_chararray_t := bism_chararray_t();
2907: -- childerrormsgs bism_chararray_t := bism_chararray_t();
2908: errors_occured boolean;
2909: sid bism_subjects.SUBJECT_ID%TYPE;
2910: startpos INTEGER := 1;
2911: usrnm BISM_SUBJECTS.SUBJECT_NAME%TYPE;
2912: usrpriv BISM_PERMISSIONS.PRIVILEGE%TYPE;
2913:

Line 2911: usrnm BISM_SUBJECTS.SUBJECT_NAME%TYPE;

2907: -- childerrormsgs bism_chararray_t := bism_chararray_t();
2908: errors_occured boolean;
2909: sid bism_subjects.SUBJECT_ID%TYPE;
2910: startpos INTEGER := 1;
2911: usrnm BISM_SUBJECTS.SUBJECT_NAME%TYPE;
2912: usrpriv BISM_PERMISSIONS.PRIVILEGE%TYPE;
2913:
2914: -- used for cascading acl to objects
2915: type oid_t is table of bism_objects.object_id%type;

Line 2947: select subject_id into sid from bism_subjects where subject_name = usrnm;

2943: usrnm := get_next_element(acllist,aclseparator,startpos);
2944: usrpriv := get_next_element(acllist,aclseparator,startpos);
2945: -- always do this for the top level objects: first time around
2946: begin
2947: select subject_id into sid from bism_subjects where subject_name = usrnm;
2948: exception
2949: when no_data_found then
2950: errors_occured := true;
2951: errormsgs := errormsgs || ' ' || usrnm;

Line 3013: username bism_subjects.subject_name%type;

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;
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();

Line 3042: select subject_id into sid from bism_subjects where subject_name = acllist(i).subjname;

3038: if topfolder = 'Y' or topfolder = 'y' then
3039: for i in 1..acllist.count
3040: loop
3041: begin
3042: select subject_id into sid from bism_subjects where subject_name = acllist(i).subjname;
3043: acllist(i).subjid := sid;
3044: exception
3045: when no_data_found then
3046: --generate a new id for the new user

Line 3052: insert into bism_subjects (SUBJECT_ID, SUBJECT_NAME, SUBJECT_TYPE) values (newguid,acllist(i).subjname,'u');

3048: -- dont throw exception, instead return the acl object of the new user to
3049: -- the caller so that the JdbcAdapter can cache the name to Id mapping
3050: newusers.extend();
3051: newusers(newusers.count) := bism_acl_obj(acllist(i).subjname,acllist(i).privilege, newguid);
3052: insert into bism_subjects (SUBJECT_ID, SUBJECT_NAME, SUBJECT_TYPE) values (newguid,acllist(i).subjname,'u');
3053: insert into bism_groups (USER_ID, GROUP_ID) values(newguid,newguid);
3054: acllist(i).subjid := newguid;
3055: end;
3056: end loop;

Line 3123: username bism_subjects.subject_name%type;

3119: procedure set_entries_30(oid in raw,acllist in out nocopy CLOB,myid in raw,cascade_to_subfolders in varchar2,cascade_to_objs in varchar2,topfolder in varchar2,isfolder in varchar2, aclseparator in varchar2)
3120: is
3121: newguid bism_objects.object_id%type:= null;
3122: objname bism_objects.object_name%type;
3123: username bism_subjects.subject_name%type;
3124: priv number(2);
3125: grantorpriv number(2);
3126: sid bism_subjects.SUBJECT_ID%TYPE;
3127: startpos INTEGER := 1;

Line 3126: sid bism_subjects.SUBJECT_ID%TYPE;

3122: objname bism_objects.object_name%type;
3123: username bism_subjects.subject_name%type;
3124: priv number(2);
3125: grantorpriv number(2);
3126: sid bism_subjects.SUBJECT_ID%TYPE;
3127: startpos INTEGER := 1;
3128: usrnm BISM_SUBJECTS.SUBJECT_NAME%TYPE;
3129: usrpriv BISM_PERMISSIONS.PRIVILEGE%TYPE;
3130: usrtype BISM_SUBJECTS.SUBJECT_TYPE%TYPE;

Line 3128: usrnm BISM_SUBJECTS.SUBJECT_NAME%TYPE;

3124: priv number(2);
3125: grantorpriv number(2);
3126: sid bism_subjects.SUBJECT_ID%TYPE;
3127: startpos INTEGER := 1;
3128: usrnm BISM_SUBJECTS.SUBJECT_NAME%TYPE;
3129: usrpriv BISM_PERMISSIONS.PRIVILEGE%TYPE;
3130: usrtype BISM_SUBJECTS.SUBJECT_TYPE%TYPE;
3131: firstTime boolean := true;
3132: begin

Line 3130: usrtype BISM_SUBJECTS.SUBJECT_TYPE%TYPE;

3126: sid bism_subjects.SUBJECT_ID%TYPE;
3127: startpos INTEGER := 1;
3128: usrnm BISM_SUBJECTS.SUBJECT_NAME%TYPE;
3129: usrpriv BISM_PERMISSIONS.PRIVILEGE%TYPE;
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

Line 3166: select subject_id into sid from bism_subjects where subject_name = usrnm;

3162: usrtype := get_next_element(acllist,aclseparator,startpos);
3163: -- always do this for the top level objects: first time around
3164: if topfolder = 'Y' or topfolder = 'y' then
3165: begin
3166: select subject_id into sid from bism_subjects where subject_name = usrnm;
3167: exception
3168: when no_data_found then
3169: --generate a new id for the new user
3170: newguid := bism_utils.get_guid;

Line 3173: insert into bism_subjects (SUBJECT_ID, SUBJECT_NAME, SUBJECT_TYPE) values (newguid,usrnm,usrtype);

3169: --generate a new id for the new user
3170: newguid := bism_utils.get_guid;
3171: -- dont throw exception, instead return the acl object of the new user to
3172: -- the caller so that the JdbcAdapter can cache the name to Id mapping
3173: insert into bism_subjects (SUBJECT_ID, SUBJECT_NAME, SUBJECT_TYPE) values (newguid,usrnm,usrtype);
3174: insert into bism_groups (USER_ID, GROUP_ID) values(newguid,newguid);
3175: sid := newguid;
3176: end;
3177: else

Line 3180: select subject_id into sid from bism_subjects where subject_name = usrnm;

3176: end;
3177: else
3178: -- same as in topfolder but there won't be an exception
3179: -- because we already inserted the user if he wasn't present
3180: select subject_id into sid from bism_subjects where subject_name = usrnm;
3181: end if;
3182:
3183: -- ok the grantor has enough privilege, proceed with setting entries
3184:

Line 3319: select subject_id into created_subid from bism_subjects

3315: -- if created by and modified by were specified, look them up, we need them later
3316: if a_attr_name = 'created_by' or a_attr_name = 'CREATED_BY' then
3317: if a_attr_val is not null then
3318: begin
3319: select subject_id into created_subid from bism_subjects
3320: where
3321: subject_name = a_attr_val and subject_type ='u';
3322: EXECUTE IMMEDIATE 'update bism_objects set created_by = :1 where folder_id = :2 and user_visible = :3 and object_name = :4 '
3323: using created_subid,a_fid, v_uv , a_obj_name;

Line 3332: select subject_id into modified_subid from bism_subjects

3328: end if;
3329: elsif a_attr_name = 'last_modified_by' or a_attr_name = 'LAST_MODIFIED_BY' then
3330: if a_attr_val is not null then
3331: begin
3332: select subject_id into modified_subid from bism_subjects
3333: where
3334: subject_name = a_attr_val and subject_type ='u';
3335: EXECUTE IMMEDIATE 'update bism_objects set last_modified_by = :1
3336: where folder_id = :2 and user_visible = :3 and object_name = :4'