1: package bism_core as
2: /* $Header: bibcores.pls 120.2 2006/04/03 05:21:25 akbansal noship $ */
3: type myrctype is ref cursor;
4: type obj_uvs is table of BISM_OBJECTS.USER_VISIBLE%TYPE;
5: type obj_ids is table of BISM_OBJECTS.OBJECT_ID%TYPE;
6: type obj_otids is table of BISM_OBJECTS.OBJECT_TYPE_ID%TYPE;
7:
8: function get_next_element(str varchar2,delimiter varchar2,startpos in out nocopy integer) return varchar2;
1: package bism_core as
2: /* $Header: bibcores.pls 120.2 2006/04/03 05:21:25 akbansal noship $ */
3: type myrctype is ref cursor;
4: type obj_uvs is table of BISM_OBJECTS.USER_VISIBLE%TYPE;
5: type obj_ids is table of BISM_OBJECTS.OBJECT_ID%TYPE;
6: type obj_otids is table of BISM_OBJECTS.OBJECT_TYPE_ID%TYPE;
7:
8: function get_next_element(str varchar2,delimiter varchar2,startpos in out nocopy integer) return varchar2;
9: function get_last_object_id(fid raw,path varchar2,startpos in out nocopy integer,myid raw) return raw;
2: /* $Header: bibcores.pls 120.2 2006/04/03 05:21:25 akbansal noship $ */
3: type myrctype is ref cursor;
4: type obj_uvs is table of BISM_OBJECTS.USER_VISIBLE%TYPE;
5: type obj_ids is table of BISM_OBJECTS.OBJECT_ID%TYPE;
6: type obj_otids is table of BISM_OBJECTS.OBJECT_TYPE_ID%TYPE;
7:
8: function get_next_element(str varchar2,delimiter varchar2,startpos in out nocopy integer) return varchar2;
9: function get_last_object_id(fid raw,path varchar2,startpos in out nocopy integer,myid raw) return raw;
10: procedure delete_folder(fid raw,myid raw);
44: function get_object(objid raw, myid raw, traceLastLoaded varchar2) return myrctype;
45: function fetch_objectsSQL1(cid raw, objid raw, myid raw) return myrctype;
46: function fetch_objectsSQL2(cid raw, myid raw, traceLastLoaded varchar2) return myrctype;
47: function rename_object(fid raw, objname varchar2, myid raw, callerid number, newobjname varchar2) return number;
48: function list(p_fid bism_objects.FOLDER_ID%type, p_subid bism_subjects.SUBJECT_ID%type) return myrctype;
49:
50: /* Added due to refactoring (ccchow) */
51: function init(p_subname in bism_subjects.subject_name%type) return bism_subjects.SUBJECT_ID%type;
52: function create_subcontext(p_tempTimeC bism_objects.time_date_created%type,
48: function list(p_fid bism_objects.FOLDER_ID%type, p_subid bism_subjects.SUBJECT_ID%type) return myrctype;
49:
50: /* Added due to refactoring (ccchow) */
51: function init(p_subname in bism_subjects.subject_name%type) return bism_subjects.SUBJECT_ID%type;
52: function create_subcontext(p_tempTimeC bism_objects.time_date_created%type,
53: p_tempTimeM bism_objects.time_date_modified%type,
54: p_creator bism_subjects.subject_name%type,
55: p_modifier bism_subjects.subject_name%type,
56: p_fid bism_objects.folder_id%type,
49:
50: /* Added due to refactoring (ccchow) */
51: function init(p_subname in bism_subjects.subject_name%type) return bism_subjects.SUBJECT_ID%type;
52: function create_subcontext(p_tempTimeC bism_objects.time_date_created%type,
53: p_tempTimeM bism_objects.time_date_modified%type,
54: p_creator bism_subjects.subject_name%type,
55: p_modifier bism_subjects.subject_name%type,
56: p_fid bism_objects.folder_id%type,
57: p_subid bism_subjects.subject_id%type,
52: function create_subcontext(p_tempTimeC bism_objects.time_date_created%type,
53: p_tempTimeM bism_objects.time_date_modified%type,
54: p_creator bism_subjects.subject_name%type,
55: p_modifier bism_subjects.subject_name%type,
56: p_fid bism_objects.folder_id%type,
57: p_subid bism_subjects.subject_id%type,
58: p_version bism_objects.VERSION%type,
59: p_object_name bism_objects.object_name%type,
60: p_title bism_objects.title%type,
54: p_creator bism_subjects.subject_name%type,
55: p_modifier bism_subjects.subject_name%type,
56: p_fid bism_objects.folder_id%type,
57: p_subid bism_subjects.subject_id%type,
58: p_version bism_objects.VERSION%type,
59: p_object_name bism_objects.object_name%type,
60: p_title bism_objects.title%type,
61: p_application bism_objects.application%type,
62: p_database bism_objects.database%type,
55: p_modifier bism_subjects.subject_name%type,
56: p_fid bism_objects.folder_id%type,
57: p_subid bism_subjects.subject_id%type,
58: p_version bism_objects.VERSION%type,
59: p_object_name bism_objects.object_name%type,
60: p_title bism_objects.title%type,
61: p_application bism_objects.application%type,
62: p_database bism_objects.database%type,
63: p_desc bism_objects.description%type,
56: p_fid bism_objects.folder_id%type,
57: p_subid bism_subjects.subject_id%type,
58: p_version bism_objects.VERSION%type,
59: p_object_name bism_objects.object_name%type,
60: p_title bism_objects.title%type,
61: p_application bism_objects.application%type,
62: p_database bism_objects.database%type,
63: p_desc bism_objects.description%type,
64: p_keywords bism_objects.keywords%type,
57: p_subid bism_subjects.subject_id%type,
58: p_version bism_objects.VERSION%type,
59: p_object_name bism_objects.object_name%type,
60: p_title bism_objects.title%type,
61: p_application bism_objects.application%type,
62: p_database bism_objects.database%type,
63: p_desc bism_objects.description%type,
64: p_keywords bism_objects.keywords%type,
65: p_appsubtype1 bism_objects.application_subtype1%type,
58: p_version bism_objects.VERSION%type,
59: p_object_name bism_objects.object_name%type,
60: p_title bism_objects.title%type,
61: p_application bism_objects.application%type,
62: p_database bism_objects.database%type,
63: p_desc bism_objects.description%type,
64: p_keywords bism_objects.keywords%type,
65: p_appsubtype1 bism_objects.application_subtype1%type,
66: p_compsubtype1 bism_objects.COMP_SUBTYPE1%type,
59: p_object_name bism_objects.object_name%type,
60: p_title bism_objects.title%type,
61: p_application bism_objects.application%type,
62: p_database bism_objects.database%type,
63: p_desc bism_objects.description%type,
64: p_keywords bism_objects.keywords%type,
65: p_appsubtype1 bism_objects.application_subtype1%type,
66: p_compsubtype1 bism_objects.COMP_SUBTYPE1%type,
67: p_compsubtype2 bism_objects.COMP_SUBTYPE2%type,
60: p_title bism_objects.title%type,
61: p_application bism_objects.application%type,
62: p_database bism_objects.database%type,
63: p_desc bism_objects.description%type,
64: p_keywords bism_objects.keywords%type,
65: p_appsubtype1 bism_objects.application_subtype1%type,
66: p_compsubtype1 bism_objects.COMP_SUBTYPE1%type,
67: p_compsubtype2 bism_objects.COMP_SUBTYPE2%type,
68: p_compsubtype3 bism_objects.COMP_SUBTYPE3%type) return bism_objects.object_id%type;
61: p_application bism_objects.application%type,
62: p_database bism_objects.database%type,
63: p_desc bism_objects.description%type,
64: p_keywords bism_objects.keywords%type,
65: p_appsubtype1 bism_objects.application_subtype1%type,
66: p_compsubtype1 bism_objects.COMP_SUBTYPE1%type,
67: p_compsubtype2 bism_objects.COMP_SUBTYPE2%type,
68: p_compsubtype3 bism_objects.COMP_SUBTYPE3%type) return bism_objects.object_id%type;
69: procedure bind(p_creator bism_subjects.SUBJECT_NAME%type,
62: p_database bism_objects.database%type,
63: p_desc bism_objects.description%type,
64: p_keywords bism_objects.keywords%type,
65: p_appsubtype1 bism_objects.application_subtype1%type,
66: p_compsubtype1 bism_objects.COMP_SUBTYPE1%type,
67: p_compsubtype2 bism_objects.COMP_SUBTYPE2%type,
68: p_compsubtype3 bism_objects.COMP_SUBTYPE3%type) return bism_objects.object_id%type;
69: procedure bind(p_creator bism_subjects.SUBJECT_NAME%type,
70: p_modifier bism_subjects.SUBJECT_NAME%type,
63: p_desc bism_objects.description%type,
64: p_keywords bism_objects.keywords%type,
65: p_appsubtype1 bism_objects.application_subtype1%type,
66: p_compsubtype1 bism_objects.COMP_SUBTYPE1%type,
67: p_compsubtype2 bism_objects.COMP_SUBTYPE2%type,
68: p_compsubtype3 bism_objects.COMP_SUBTYPE3%type) return bism_objects.object_id%type;
69: procedure bind(p_creator bism_subjects.SUBJECT_NAME%type,
70: p_modifier bism_subjects.SUBJECT_NAME%type,
71: p_subject_id bism_subjects.SUBJECT_ID%type,
64: p_keywords bism_objects.keywords%type,
65: p_appsubtype1 bism_objects.application_subtype1%type,
66: p_compsubtype1 bism_objects.COMP_SUBTYPE1%type,
67: p_compsubtype2 bism_objects.COMP_SUBTYPE2%type,
68: p_compsubtype3 bism_objects.COMP_SUBTYPE3%type) return bism_objects.object_id%type;
69: procedure bind(p_creator bism_subjects.SUBJECT_NAME%type,
70: p_modifier bism_subjects.SUBJECT_NAME%type,
71: p_subject_id bism_subjects.SUBJECT_ID%type,
72: p_visible bism_objects.USER_VISIBLE%type,
68: p_compsubtype3 bism_objects.COMP_SUBTYPE3%type) return bism_objects.object_id%type;
69: procedure bind(p_creator bism_subjects.SUBJECT_NAME%type,
70: p_modifier bism_subjects.SUBJECT_NAME%type,
71: p_subject_id bism_subjects.SUBJECT_ID%type,
72: p_visible bism_objects.USER_VISIBLE%type,
73: p_obj_type_id bism_objects.OBJECT_TYPE_ID%type,
74: p_version bism_objects.VERSION%type,
75: p_time_created bism_objects.TIME_DATE_CREATED%type,
76: p_time_modified bism_objects.TIME_DATE_MODIFIED%type,
69: procedure bind(p_creator bism_subjects.SUBJECT_NAME%type,
70: p_modifier bism_subjects.SUBJECT_NAME%type,
71: p_subject_id bism_subjects.SUBJECT_ID%type,
72: p_visible bism_objects.USER_VISIBLE%type,
73: p_obj_type_id bism_objects.OBJECT_TYPE_ID%type,
74: p_version bism_objects.VERSION%type,
75: p_time_created bism_objects.TIME_DATE_CREATED%type,
76: p_time_modified bism_objects.TIME_DATE_MODIFIED%type,
77: p_oid bism_objects.OBJECT_ID%type,
70: p_modifier bism_subjects.SUBJECT_NAME%type,
71: p_subject_id bism_subjects.SUBJECT_ID%type,
72: p_visible bism_objects.USER_VISIBLE%type,
73: p_obj_type_id bism_objects.OBJECT_TYPE_ID%type,
74: p_version bism_objects.VERSION%type,
75: p_time_created bism_objects.TIME_DATE_CREATED%type,
76: p_time_modified bism_objects.TIME_DATE_MODIFIED%type,
77: p_oid bism_objects.OBJECT_ID%type,
78: p_container_id bism_objects.CONTAINER_ID%type,
71: p_subject_id bism_subjects.SUBJECT_ID%type,
72: p_visible bism_objects.USER_VISIBLE%type,
73: p_obj_type_id bism_objects.OBJECT_TYPE_ID%type,
74: p_version bism_objects.VERSION%type,
75: p_time_created bism_objects.TIME_DATE_CREATED%type,
76: p_time_modified bism_objects.TIME_DATE_MODIFIED%type,
77: p_oid bism_objects.OBJECT_ID%type,
78: p_container_id bism_objects.CONTAINER_ID%type,
79: p_fid bism_objects.FOLDER_ID%type,
72: p_visible bism_objects.USER_VISIBLE%type,
73: p_obj_type_id bism_objects.OBJECT_TYPE_ID%type,
74: p_version bism_objects.VERSION%type,
75: p_time_created bism_objects.TIME_DATE_CREATED%type,
76: p_time_modified bism_objects.TIME_DATE_MODIFIED%type,
77: p_oid bism_objects.OBJECT_ID%type,
78: p_container_id bism_objects.CONTAINER_ID%type,
79: p_fid bism_objects.FOLDER_ID%type,
80: p_obj_name bism_objects.OBJECT_NAME%type,
73: p_obj_type_id bism_objects.OBJECT_TYPE_ID%type,
74: p_version bism_objects.VERSION%type,
75: p_time_created bism_objects.TIME_DATE_CREATED%type,
76: p_time_modified bism_objects.TIME_DATE_MODIFIED%type,
77: p_oid bism_objects.OBJECT_ID%type,
78: p_container_id bism_objects.CONTAINER_ID%type,
79: p_fid bism_objects.FOLDER_ID%type,
80: p_obj_name bism_objects.OBJECT_NAME%type,
81: p_title bism_objects.TITLE%type,
74: p_version bism_objects.VERSION%type,
75: p_time_created bism_objects.TIME_DATE_CREATED%type,
76: p_time_modified bism_objects.TIME_DATE_MODIFIED%type,
77: p_oid bism_objects.OBJECT_ID%type,
78: p_container_id bism_objects.CONTAINER_ID%type,
79: p_fid bism_objects.FOLDER_ID%type,
80: p_obj_name bism_objects.OBJECT_NAME%type,
81: p_title bism_objects.TITLE%type,
82: p_application bism_objects.APPLICATION%type,
75: p_time_created bism_objects.TIME_DATE_CREATED%type,
76: p_time_modified bism_objects.TIME_DATE_MODIFIED%type,
77: p_oid bism_objects.OBJECT_ID%type,
78: p_container_id bism_objects.CONTAINER_ID%type,
79: p_fid bism_objects.FOLDER_ID%type,
80: p_obj_name bism_objects.OBJECT_NAME%type,
81: p_title bism_objects.TITLE%type,
82: p_application bism_objects.APPLICATION%type,
83: p_database bism_objects.DATABASE%type,
76: p_time_modified bism_objects.TIME_DATE_MODIFIED%type,
77: p_oid bism_objects.OBJECT_ID%type,
78: p_container_id bism_objects.CONTAINER_ID%type,
79: p_fid bism_objects.FOLDER_ID%type,
80: p_obj_name bism_objects.OBJECT_NAME%type,
81: p_title bism_objects.TITLE%type,
82: p_application bism_objects.APPLICATION%type,
83: p_database bism_objects.DATABASE%type,
84: p_desc bism_objects.DESCRIPTION%type,
77: p_oid bism_objects.OBJECT_ID%type,
78: p_container_id bism_objects.CONTAINER_ID%type,
79: p_fid bism_objects.FOLDER_ID%type,
80: p_obj_name bism_objects.OBJECT_NAME%type,
81: p_title bism_objects.TITLE%type,
82: p_application bism_objects.APPLICATION%type,
83: p_database bism_objects.DATABASE%type,
84: p_desc bism_objects.DESCRIPTION%type,
85: p_keywords bism_objects.KEYWORDS%type,
78: p_container_id bism_objects.CONTAINER_ID%type,
79: p_fid bism_objects.FOLDER_ID%type,
80: p_obj_name bism_objects.OBJECT_NAME%type,
81: p_title bism_objects.TITLE%type,
82: p_application bism_objects.APPLICATION%type,
83: p_database bism_objects.DATABASE%type,
84: p_desc bism_objects.DESCRIPTION%type,
85: p_keywords bism_objects.KEYWORDS%type,
86: p_xml bism_objects.XML%type,
79: p_fid bism_objects.FOLDER_ID%type,
80: p_obj_name bism_objects.OBJECT_NAME%type,
81: p_title bism_objects.TITLE%type,
82: p_application bism_objects.APPLICATION%type,
83: p_database bism_objects.DATABASE%type,
84: p_desc bism_objects.DESCRIPTION%type,
85: p_keywords bism_objects.KEYWORDS%type,
86: p_xml bism_objects.XML%type,
87: p_appsubtype1 bism_objects.APPLICATION_SUBTYPE1%type,
80: p_obj_name bism_objects.OBJECT_NAME%type,
81: p_title bism_objects.TITLE%type,
82: p_application bism_objects.APPLICATION%type,
83: p_database bism_objects.DATABASE%type,
84: p_desc bism_objects.DESCRIPTION%type,
85: p_keywords bism_objects.KEYWORDS%type,
86: p_xml bism_objects.XML%type,
87: p_appsubtype1 bism_objects.APPLICATION_SUBTYPE1%type,
88: p_compsubtype1 bism_objects.COMP_SUBTYPE1%type,
81: p_title bism_objects.TITLE%type,
82: p_application bism_objects.APPLICATION%type,
83: p_database bism_objects.DATABASE%type,
84: p_desc bism_objects.DESCRIPTION%type,
85: p_keywords bism_objects.KEYWORDS%type,
86: p_xml bism_objects.XML%type,
87: p_appsubtype1 bism_objects.APPLICATION_SUBTYPE1%type,
88: p_compsubtype1 bism_objects.COMP_SUBTYPE1%type,
89: p_compsubtype2 bism_objects.COMP_SUBTYPE2%type,
82: p_application bism_objects.APPLICATION%type,
83: p_database bism_objects.DATABASE%type,
84: p_desc bism_objects.DESCRIPTION%type,
85: p_keywords bism_objects.KEYWORDS%type,
86: p_xml bism_objects.XML%type,
87: p_appsubtype1 bism_objects.APPLICATION_SUBTYPE1%type,
88: p_compsubtype1 bism_objects.COMP_SUBTYPE1%type,
89: p_compsubtype2 bism_objects.COMP_SUBTYPE2%type,
90: p_compsubtype3 bism_objects.COMP_SUBTYPE3%type,
83: p_database bism_objects.DATABASE%type,
84: p_desc bism_objects.DESCRIPTION%type,
85: p_keywords bism_objects.KEYWORDS%type,
86: p_xml bism_objects.XML%type,
87: p_appsubtype1 bism_objects.APPLICATION_SUBTYPE1%type,
88: p_compsubtype1 bism_objects.COMP_SUBTYPE1%type,
89: p_compsubtype2 bism_objects.COMP_SUBTYPE2%type,
90: p_compsubtype3 bism_objects.COMP_SUBTYPE3%type,
91: p_container_id2 bism_aggregates.CONTAINER_ID%type,
84: p_desc bism_objects.DESCRIPTION%type,
85: p_keywords bism_objects.KEYWORDS%type,
86: p_xml bism_objects.XML%type,
87: p_appsubtype1 bism_objects.APPLICATION_SUBTYPE1%type,
88: p_compsubtype1 bism_objects.COMP_SUBTYPE1%type,
89: p_compsubtype2 bism_objects.COMP_SUBTYPE2%type,
90: p_compsubtype3 bism_objects.COMP_SUBTYPE3%type,
91: p_container_id2 bism_aggregates.CONTAINER_ID%type,
92: p_aggregate_info bism_aggregates.AGGREGATE_INFO%type);
85: p_keywords bism_objects.KEYWORDS%type,
86: p_xml bism_objects.XML%type,
87: p_appsubtype1 bism_objects.APPLICATION_SUBTYPE1%type,
88: p_compsubtype1 bism_objects.COMP_SUBTYPE1%type,
89: p_compsubtype2 bism_objects.COMP_SUBTYPE2%type,
90: p_compsubtype3 bism_objects.COMP_SUBTYPE3%type,
91: p_container_id2 bism_aggregates.CONTAINER_ID%type,
92: p_aggregate_info bism_aggregates.AGGREGATE_INFO%type);
93: procedure bind(p_creator bism_subjects.SUBJECT_NAME%type,
86: p_xml bism_objects.XML%type,
87: p_appsubtype1 bism_objects.APPLICATION_SUBTYPE1%type,
88: p_compsubtype1 bism_objects.COMP_SUBTYPE1%type,
89: p_compsubtype2 bism_objects.COMP_SUBTYPE2%type,
90: p_compsubtype3 bism_objects.COMP_SUBTYPE3%type,
91: p_container_id2 bism_aggregates.CONTAINER_ID%type,
92: p_aggregate_info bism_aggregates.AGGREGATE_INFO%type);
93: procedure bind(p_creator bism_subjects.SUBJECT_NAME%type,
94: p_modifier bism_subjects.SUBJECT_NAME%type,
92: p_aggregate_info bism_aggregates.AGGREGATE_INFO%type);
93: procedure bind(p_creator bism_subjects.SUBJECT_NAME%type,
94: p_modifier bism_subjects.SUBJECT_NAME%type,
95: p_subject_id bism_subjects.SUBJECT_ID%type,
96: p_visible bism_objects.USER_VISIBLE%type,
97: p_obj_type_id bism_objects.OBJECT_TYPE_ID%type,
98: p_version bism_objects.VERSION%type,
99: p_time_created bism_objects.TIME_DATE_CREATED%type,
100: p_time_modified bism_objects.TIME_DATE_MODIFIED%type,
93: procedure bind(p_creator bism_subjects.SUBJECT_NAME%type,
94: p_modifier bism_subjects.SUBJECT_NAME%type,
95: p_subject_id bism_subjects.SUBJECT_ID%type,
96: p_visible bism_objects.USER_VISIBLE%type,
97: p_obj_type_id bism_objects.OBJECT_TYPE_ID%type,
98: p_version bism_objects.VERSION%type,
99: p_time_created bism_objects.TIME_DATE_CREATED%type,
100: p_time_modified bism_objects.TIME_DATE_MODIFIED%type,
101: p_oid bism_objects.OBJECT_ID%type,
94: p_modifier bism_subjects.SUBJECT_NAME%type,
95: p_subject_id bism_subjects.SUBJECT_ID%type,
96: p_visible bism_objects.USER_VISIBLE%type,
97: p_obj_type_id bism_objects.OBJECT_TYPE_ID%type,
98: p_version bism_objects.VERSION%type,
99: p_time_created bism_objects.TIME_DATE_CREATED%type,
100: p_time_modified bism_objects.TIME_DATE_MODIFIED%type,
101: p_oid bism_objects.OBJECT_ID%type,
102: p_container_id bism_objects.CONTAINER_ID%type,
95: p_subject_id bism_subjects.SUBJECT_ID%type,
96: p_visible bism_objects.USER_VISIBLE%type,
97: p_obj_type_id bism_objects.OBJECT_TYPE_ID%type,
98: p_version bism_objects.VERSION%type,
99: p_time_created bism_objects.TIME_DATE_CREATED%type,
100: p_time_modified bism_objects.TIME_DATE_MODIFIED%type,
101: p_oid bism_objects.OBJECT_ID%type,
102: p_container_id bism_objects.CONTAINER_ID%type,
103: p_fid bism_objects.FOLDER_ID%type,
96: p_visible bism_objects.USER_VISIBLE%type,
97: p_obj_type_id bism_objects.OBJECT_TYPE_ID%type,
98: p_version bism_objects.VERSION%type,
99: p_time_created bism_objects.TIME_DATE_CREATED%type,
100: p_time_modified bism_objects.TIME_DATE_MODIFIED%type,
101: p_oid bism_objects.OBJECT_ID%type,
102: p_container_id bism_objects.CONTAINER_ID%type,
103: p_fid bism_objects.FOLDER_ID%type,
104: p_obj_name bism_objects.OBJECT_NAME%type,
97: p_obj_type_id bism_objects.OBJECT_TYPE_ID%type,
98: p_version bism_objects.VERSION%type,
99: p_time_created bism_objects.TIME_DATE_CREATED%type,
100: p_time_modified bism_objects.TIME_DATE_MODIFIED%type,
101: p_oid bism_objects.OBJECT_ID%type,
102: p_container_id bism_objects.CONTAINER_ID%type,
103: p_fid bism_objects.FOLDER_ID%type,
104: p_obj_name bism_objects.OBJECT_NAME%type,
105: p_title bism_objects.TITLE%type,
98: p_version bism_objects.VERSION%type,
99: p_time_created bism_objects.TIME_DATE_CREATED%type,
100: p_time_modified bism_objects.TIME_DATE_MODIFIED%type,
101: p_oid bism_objects.OBJECT_ID%type,
102: p_container_id bism_objects.CONTAINER_ID%type,
103: p_fid bism_objects.FOLDER_ID%type,
104: p_obj_name bism_objects.OBJECT_NAME%type,
105: p_title bism_objects.TITLE%type,
106: p_application bism_objects.APPLICATION%type,
99: p_time_created bism_objects.TIME_DATE_CREATED%type,
100: p_time_modified bism_objects.TIME_DATE_MODIFIED%type,
101: p_oid bism_objects.OBJECT_ID%type,
102: p_container_id bism_objects.CONTAINER_ID%type,
103: p_fid bism_objects.FOLDER_ID%type,
104: p_obj_name bism_objects.OBJECT_NAME%type,
105: p_title bism_objects.TITLE%type,
106: p_application bism_objects.APPLICATION%type,
107: p_database bism_objects.DATABASE%type,
100: p_time_modified bism_objects.TIME_DATE_MODIFIED%type,
101: p_oid bism_objects.OBJECT_ID%type,
102: p_container_id bism_objects.CONTAINER_ID%type,
103: p_fid bism_objects.FOLDER_ID%type,
104: p_obj_name bism_objects.OBJECT_NAME%type,
105: p_title bism_objects.TITLE%type,
106: p_application bism_objects.APPLICATION%type,
107: p_database bism_objects.DATABASE%type,
108: p_desc bism_objects.DESCRIPTION%type,
101: p_oid bism_objects.OBJECT_ID%type,
102: p_container_id bism_objects.CONTAINER_ID%type,
103: p_fid bism_objects.FOLDER_ID%type,
104: p_obj_name bism_objects.OBJECT_NAME%type,
105: p_title bism_objects.TITLE%type,
106: p_application bism_objects.APPLICATION%type,
107: p_database bism_objects.DATABASE%type,
108: p_desc bism_objects.DESCRIPTION%type,
109: p_keywords bism_objects.KEYWORDS%type,
102: p_container_id bism_objects.CONTAINER_ID%type,
103: p_fid bism_objects.FOLDER_ID%type,
104: p_obj_name bism_objects.OBJECT_NAME%type,
105: p_title bism_objects.TITLE%type,
106: p_application bism_objects.APPLICATION%type,
107: p_database bism_objects.DATABASE%type,
108: p_desc bism_objects.DESCRIPTION%type,
109: p_keywords bism_objects.KEYWORDS%type,
110: p_xml bism_objects.XML%type,
103: p_fid bism_objects.FOLDER_ID%type,
104: p_obj_name bism_objects.OBJECT_NAME%type,
105: p_title bism_objects.TITLE%type,
106: p_application bism_objects.APPLICATION%type,
107: p_database bism_objects.DATABASE%type,
108: p_desc bism_objects.DESCRIPTION%type,
109: p_keywords bism_objects.KEYWORDS%type,
110: p_xml bism_objects.XML%type,
111: p_appsubtype1 bism_objects.APPLICATION_SUBTYPE1%type,
104: p_obj_name bism_objects.OBJECT_NAME%type,
105: p_title bism_objects.TITLE%type,
106: p_application bism_objects.APPLICATION%type,
107: p_database bism_objects.DATABASE%type,
108: p_desc bism_objects.DESCRIPTION%type,
109: p_keywords bism_objects.KEYWORDS%type,
110: p_xml bism_objects.XML%type,
111: p_appsubtype1 bism_objects.APPLICATION_SUBTYPE1%type,
112: p_compsubtype1 bism_objects.COMP_SUBTYPE1%type,
105: p_title bism_objects.TITLE%type,
106: p_application bism_objects.APPLICATION%type,
107: p_database bism_objects.DATABASE%type,
108: p_desc bism_objects.DESCRIPTION%type,
109: p_keywords bism_objects.KEYWORDS%type,
110: p_xml bism_objects.XML%type,
111: p_appsubtype1 bism_objects.APPLICATION_SUBTYPE1%type,
112: p_compsubtype1 bism_objects.COMP_SUBTYPE1%type,
113: p_compsubtype2 bism_objects.COMP_SUBTYPE2%type,
106: p_application bism_objects.APPLICATION%type,
107: p_database bism_objects.DATABASE%type,
108: p_desc bism_objects.DESCRIPTION%type,
109: p_keywords bism_objects.KEYWORDS%type,
110: p_xml bism_objects.XML%type,
111: p_appsubtype1 bism_objects.APPLICATION_SUBTYPE1%type,
112: p_compsubtype1 bism_objects.COMP_SUBTYPE1%type,
113: p_compsubtype2 bism_objects.COMP_SUBTYPE2%type,
114: p_compsubtype3 bism_objects.COMP_SUBTYPE3%type,
107: p_database bism_objects.DATABASE%type,
108: p_desc bism_objects.DESCRIPTION%type,
109: p_keywords bism_objects.KEYWORDS%type,
110: p_xml bism_objects.XML%type,
111: p_appsubtype1 bism_objects.APPLICATION_SUBTYPE1%type,
112: p_compsubtype1 bism_objects.COMP_SUBTYPE1%type,
113: p_compsubtype2 bism_objects.COMP_SUBTYPE2%type,
114: p_compsubtype3 bism_objects.COMP_SUBTYPE3%type,
115: p_container_id2 bism_aggregates.CONTAINER_ID%type,
108: p_desc bism_objects.DESCRIPTION%type,
109: p_keywords bism_objects.KEYWORDS%type,
110: p_xml bism_objects.XML%type,
111: p_appsubtype1 bism_objects.APPLICATION_SUBTYPE1%type,
112: p_compsubtype1 bism_objects.COMP_SUBTYPE1%type,
113: p_compsubtype2 bism_objects.COMP_SUBTYPE2%type,
114: p_compsubtype3 bism_objects.COMP_SUBTYPE3%type,
115: p_container_id2 bism_aggregates.CONTAINER_ID%type,
116: p_aggregate_info bism_aggregates.AGGREGATE_INFO%type,
109: p_keywords bism_objects.KEYWORDS%type,
110: p_xml bism_objects.XML%type,
111: p_appsubtype1 bism_objects.APPLICATION_SUBTYPE1%type,
112: p_compsubtype1 bism_objects.COMP_SUBTYPE1%type,
113: p_compsubtype2 bism_objects.COMP_SUBTYPE2%type,
114: p_compsubtype3 bism_objects.COMP_SUBTYPE3%type,
115: p_container_id2 bism_aggregates.CONTAINER_ID%type,
116: p_aggregate_info bism_aggregates.AGGREGATE_INFO%type,
117: p_ext_attrs_clob CLOB,
110: p_xml bism_objects.XML%type,
111: p_appsubtype1 bism_objects.APPLICATION_SUBTYPE1%type,
112: p_compsubtype1 bism_objects.COMP_SUBTYPE1%type,
113: p_compsubtype2 bism_objects.COMP_SUBTYPE2%type,
114: p_compsubtype3 bism_objects.COMP_SUBTYPE3%type,
115: p_container_id2 bism_aggregates.CONTAINER_ID%type,
116: p_aggregate_info bism_aggregates.AGGREGATE_INFO%type,
117: p_ext_attrs_clob CLOB,
118: p_time_last_loaded bism_objects.TIME_DATE_LAST_ACCESSED%type);
114: p_compsubtype3 bism_objects.COMP_SUBTYPE3%type,
115: p_container_id2 bism_aggregates.CONTAINER_ID%type,
116: p_aggregate_info bism_aggregates.AGGREGATE_INFO%type,
117: p_ext_attrs_clob CLOB,
118: p_time_last_loaded bism_objects.TIME_DATE_LAST_ACCESSED%type);
119: procedure bind_aggregate(p_container_id bism_aggregates.CONTAINER_ID%type,p_containee_id bism_aggregates.CONTAINEE_ID%type,p_aggregate_info bism_aggregates.AGGREGATE_INFO%type);
120: function list_bindings(p_fid bism_objects.FOLDER_ID%type,p_subid bism_subjects.SUBJECT_ID%type) return myrctype;
121: procedure rebind(p_creator bism_subjects.SUBJECT_NAME%type,
122: p_modifier bism_subjects.SUBJECT_NAME%type,
116: p_aggregate_info bism_aggregates.AGGREGATE_INFO%type,
117: p_ext_attrs_clob CLOB,
118: p_time_last_loaded bism_objects.TIME_DATE_LAST_ACCESSED%type);
119: procedure bind_aggregate(p_container_id bism_aggregates.CONTAINER_ID%type,p_containee_id bism_aggregates.CONTAINEE_ID%type,p_aggregate_info bism_aggregates.AGGREGATE_INFO%type);
120: function list_bindings(p_fid bism_objects.FOLDER_ID%type,p_subid bism_subjects.SUBJECT_ID%type) return myrctype;
121: procedure rebind(p_creator bism_subjects.SUBJECT_NAME%type,
122: p_modifier bism_subjects.SUBJECT_NAME%type,
123: p_subject_id bism_subjects.SUBJECT_ID%type,
124: p_visible bism_objects.USER_VISIBLE%type,
120: function list_bindings(p_fid bism_objects.FOLDER_ID%type,p_subid bism_subjects.SUBJECT_ID%type) return myrctype;
121: procedure rebind(p_creator bism_subjects.SUBJECT_NAME%type,
122: p_modifier bism_subjects.SUBJECT_NAME%type,
123: p_subject_id bism_subjects.SUBJECT_ID%type,
124: p_visible bism_objects.USER_VISIBLE%type,
125: p_obj_type_id bism_objects.OBJECT_TYPE_ID%type,
126: p_version bism_objects.VERSION%type,
127: p_time_created bism_objects.TIME_DATE_CREATED%type,
128: p_time_modified bism_objects.TIME_DATE_MODIFIED%type,
121: procedure rebind(p_creator bism_subjects.SUBJECT_NAME%type,
122: p_modifier bism_subjects.SUBJECT_NAME%type,
123: p_subject_id bism_subjects.SUBJECT_ID%type,
124: p_visible bism_objects.USER_VISIBLE%type,
125: p_obj_type_id bism_objects.OBJECT_TYPE_ID%type,
126: p_version bism_objects.VERSION%type,
127: p_time_created bism_objects.TIME_DATE_CREATED%type,
128: p_time_modified bism_objects.TIME_DATE_MODIFIED%type,
129: p_oid bism_objects.OBJECT_ID%type,
122: p_modifier bism_subjects.SUBJECT_NAME%type,
123: p_subject_id bism_subjects.SUBJECT_ID%type,
124: p_visible bism_objects.USER_VISIBLE%type,
125: p_obj_type_id bism_objects.OBJECT_TYPE_ID%type,
126: p_version bism_objects.VERSION%type,
127: p_time_created bism_objects.TIME_DATE_CREATED%type,
128: p_time_modified bism_objects.TIME_DATE_MODIFIED%type,
129: p_oid bism_objects.OBJECT_ID%type,
130: p_container_id bism_objects.CONTAINER_ID%type,
123: p_subject_id bism_subjects.SUBJECT_ID%type,
124: p_visible bism_objects.USER_VISIBLE%type,
125: p_obj_type_id bism_objects.OBJECT_TYPE_ID%type,
126: p_version bism_objects.VERSION%type,
127: p_time_created bism_objects.TIME_DATE_CREATED%type,
128: p_time_modified bism_objects.TIME_DATE_MODIFIED%type,
129: p_oid bism_objects.OBJECT_ID%type,
130: p_container_id bism_objects.CONTAINER_ID%type,
131: p_fid bism_objects.FOLDER_ID%type,
124: p_visible bism_objects.USER_VISIBLE%type,
125: p_obj_type_id bism_objects.OBJECT_TYPE_ID%type,
126: p_version bism_objects.VERSION%type,
127: p_time_created bism_objects.TIME_DATE_CREATED%type,
128: p_time_modified bism_objects.TIME_DATE_MODIFIED%type,
129: p_oid bism_objects.OBJECT_ID%type,
130: p_container_id bism_objects.CONTAINER_ID%type,
131: p_fid bism_objects.FOLDER_ID%type,
132: p_obj_name bism_objects.OBJECT_NAME%type,
125: p_obj_type_id bism_objects.OBJECT_TYPE_ID%type,
126: p_version bism_objects.VERSION%type,
127: p_time_created bism_objects.TIME_DATE_CREATED%type,
128: p_time_modified bism_objects.TIME_DATE_MODIFIED%type,
129: p_oid bism_objects.OBJECT_ID%type,
130: p_container_id bism_objects.CONTAINER_ID%type,
131: p_fid bism_objects.FOLDER_ID%type,
132: p_obj_name bism_objects.OBJECT_NAME%type,
133: p_title bism_objects.TITLE%type,
126: p_version bism_objects.VERSION%type,
127: p_time_created bism_objects.TIME_DATE_CREATED%type,
128: p_time_modified bism_objects.TIME_DATE_MODIFIED%type,
129: p_oid bism_objects.OBJECT_ID%type,
130: p_container_id bism_objects.CONTAINER_ID%type,
131: p_fid bism_objects.FOLDER_ID%type,
132: p_obj_name bism_objects.OBJECT_NAME%type,
133: p_title bism_objects.TITLE%type,
134: p_application bism_objects.APPLICATION%type,
127: p_time_created bism_objects.TIME_DATE_CREATED%type,
128: p_time_modified bism_objects.TIME_DATE_MODIFIED%type,
129: p_oid bism_objects.OBJECT_ID%type,
130: p_container_id bism_objects.CONTAINER_ID%type,
131: p_fid bism_objects.FOLDER_ID%type,
132: p_obj_name bism_objects.OBJECT_NAME%type,
133: p_title bism_objects.TITLE%type,
134: p_application bism_objects.APPLICATION%type,
135: p_database bism_objects.DATABASE%type,
128: p_time_modified bism_objects.TIME_DATE_MODIFIED%type,
129: p_oid bism_objects.OBJECT_ID%type,
130: p_container_id bism_objects.CONTAINER_ID%type,
131: p_fid bism_objects.FOLDER_ID%type,
132: p_obj_name bism_objects.OBJECT_NAME%type,
133: p_title bism_objects.TITLE%type,
134: p_application bism_objects.APPLICATION%type,
135: p_database bism_objects.DATABASE%type,
136: p_desc bism_objects.DESCRIPTION%type,
129: p_oid bism_objects.OBJECT_ID%type,
130: p_container_id bism_objects.CONTAINER_ID%type,
131: p_fid bism_objects.FOLDER_ID%type,
132: p_obj_name bism_objects.OBJECT_NAME%type,
133: p_title bism_objects.TITLE%type,
134: p_application bism_objects.APPLICATION%type,
135: p_database bism_objects.DATABASE%type,
136: p_desc bism_objects.DESCRIPTION%type,
137: p_keywords bism_objects.KEYWORDS%type,
130: p_container_id bism_objects.CONTAINER_ID%type,
131: p_fid bism_objects.FOLDER_ID%type,
132: p_obj_name bism_objects.OBJECT_NAME%type,
133: p_title bism_objects.TITLE%type,
134: p_application bism_objects.APPLICATION%type,
135: p_database bism_objects.DATABASE%type,
136: p_desc bism_objects.DESCRIPTION%type,
137: p_keywords bism_objects.KEYWORDS%type,
138: p_xml bism_objects.XML%type,
131: p_fid bism_objects.FOLDER_ID%type,
132: p_obj_name bism_objects.OBJECT_NAME%type,
133: p_title bism_objects.TITLE%type,
134: p_application bism_objects.APPLICATION%type,
135: p_database bism_objects.DATABASE%type,
136: p_desc bism_objects.DESCRIPTION%type,
137: p_keywords bism_objects.KEYWORDS%type,
138: p_xml bism_objects.XML%type,
139: p_appsubtype1 bism_objects.APPLICATION_SUBTYPE1%type,
132: p_obj_name bism_objects.OBJECT_NAME%type,
133: p_title bism_objects.TITLE%type,
134: p_application bism_objects.APPLICATION%type,
135: p_database bism_objects.DATABASE%type,
136: p_desc bism_objects.DESCRIPTION%type,
137: p_keywords bism_objects.KEYWORDS%type,
138: p_xml bism_objects.XML%type,
139: p_appsubtype1 bism_objects.APPLICATION_SUBTYPE1%type,
140: p_compsubtype1 bism_objects.COMP_SUBTYPE1%type,
133: p_title bism_objects.TITLE%type,
134: p_application bism_objects.APPLICATION%type,
135: p_database bism_objects.DATABASE%type,
136: p_desc bism_objects.DESCRIPTION%type,
137: p_keywords bism_objects.KEYWORDS%type,
138: p_xml bism_objects.XML%type,
139: p_appsubtype1 bism_objects.APPLICATION_SUBTYPE1%type,
140: p_compsubtype1 bism_objects.COMP_SUBTYPE1%type,
141: p_compsubtype2 bism_objects.COMP_SUBTYPE2%type,
134: p_application bism_objects.APPLICATION%type,
135: p_database bism_objects.DATABASE%type,
136: p_desc bism_objects.DESCRIPTION%type,
137: p_keywords bism_objects.KEYWORDS%type,
138: p_xml bism_objects.XML%type,
139: p_appsubtype1 bism_objects.APPLICATION_SUBTYPE1%type,
140: p_compsubtype1 bism_objects.COMP_SUBTYPE1%type,
141: p_compsubtype2 bism_objects.COMP_SUBTYPE2%type,
142: p_compsubtype3 bism_objects.COMP_SUBTYPE3%type);
135: p_database bism_objects.DATABASE%type,
136: p_desc bism_objects.DESCRIPTION%type,
137: p_keywords bism_objects.KEYWORDS%type,
138: p_xml bism_objects.XML%type,
139: p_appsubtype1 bism_objects.APPLICATION_SUBTYPE1%type,
140: p_compsubtype1 bism_objects.COMP_SUBTYPE1%type,
141: p_compsubtype2 bism_objects.COMP_SUBTYPE2%type,
142: p_compsubtype3 bism_objects.COMP_SUBTYPE3%type);
143: procedure rebind(p_creator bism_subjects.SUBJECT_NAME%type,
136: p_desc bism_objects.DESCRIPTION%type,
137: p_keywords bism_objects.KEYWORDS%type,
138: p_xml bism_objects.XML%type,
139: p_appsubtype1 bism_objects.APPLICATION_SUBTYPE1%type,
140: p_compsubtype1 bism_objects.COMP_SUBTYPE1%type,
141: p_compsubtype2 bism_objects.COMP_SUBTYPE2%type,
142: p_compsubtype3 bism_objects.COMP_SUBTYPE3%type);
143: procedure rebind(p_creator bism_subjects.SUBJECT_NAME%type,
144: p_modifier bism_subjects.SUBJECT_NAME%type,
137: p_keywords bism_objects.KEYWORDS%type,
138: p_xml bism_objects.XML%type,
139: p_appsubtype1 bism_objects.APPLICATION_SUBTYPE1%type,
140: p_compsubtype1 bism_objects.COMP_SUBTYPE1%type,
141: p_compsubtype2 bism_objects.COMP_SUBTYPE2%type,
142: p_compsubtype3 bism_objects.COMP_SUBTYPE3%type);
143: procedure rebind(p_creator bism_subjects.SUBJECT_NAME%type,
144: p_modifier bism_subjects.SUBJECT_NAME%type,
145: p_subject_id bism_subjects.SUBJECT_ID%type,
138: p_xml bism_objects.XML%type,
139: p_appsubtype1 bism_objects.APPLICATION_SUBTYPE1%type,
140: p_compsubtype1 bism_objects.COMP_SUBTYPE1%type,
141: p_compsubtype2 bism_objects.COMP_SUBTYPE2%type,
142: p_compsubtype3 bism_objects.COMP_SUBTYPE3%type);
143: procedure rebind(p_creator bism_subjects.SUBJECT_NAME%type,
144: p_modifier bism_subjects.SUBJECT_NAME%type,
145: p_subject_id bism_subjects.SUBJECT_ID%type,
146: p_visible bism_objects.USER_VISIBLE%type,
142: p_compsubtype3 bism_objects.COMP_SUBTYPE3%type);
143: procedure rebind(p_creator bism_subjects.SUBJECT_NAME%type,
144: p_modifier bism_subjects.SUBJECT_NAME%type,
145: p_subject_id bism_subjects.SUBJECT_ID%type,
146: p_visible bism_objects.USER_VISIBLE%type,
147: p_obj_type_id bism_objects.OBJECT_TYPE_ID%type,
148: p_version bism_objects.VERSION%type,
149: p_time_created bism_objects.TIME_DATE_CREATED%type,
150: p_time_modified bism_objects.TIME_DATE_MODIFIED%type,
143: procedure rebind(p_creator bism_subjects.SUBJECT_NAME%type,
144: p_modifier bism_subjects.SUBJECT_NAME%type,
145: p_subject_id bism_subjects.SUBJECT_ID%type,
146: p_visible bism_objects.USER_VISIBLE%type,
147: p_obj_type_id bism_objects.OBJECT_TYPE_ID%type,
148: p_version bism_objects.VERSION%type,
149: p_time_created bism_objects.TIME_DATE_CREATED%type,
150: p_time_modified bism_objects.TIME_DATE_MODIFIED%type,
151: p_oid bism_objects.OBJECT_ID%type,
144: p_modifier bism_subjects.SUBJECT_NAME%type,
145: p_subject_id bism_subjects.SUBJECT_ID%type,
146: p_visible bism_objects.USER_VISIBLE%type,
147: p_obj_type_id bism_objects.OBJECT_TYPE_ID%type,
148: p_version bism_objects.VERSION%type,
149: p_time_created bism_objects.TIME_DATE_CREATED%type,
150: p_time_modified bism_objects.TIME_DATE_MODIFIED%type,
151: p_oid bism_objects.OBJECT_ID%type,
152: p_container_id bism_objects.CONTAINER_ID%type,
145: p_subject_id bism_subjects.SUBJECT_ID%type,
146: p_visible bism_objects.USER_VISIBLE%type,
147: p_obj_type_id bism_objects.OBJECT_TYPE_ID%type,
148: p_version bism_objects.VERSION%type,
149: p_time_created bism_objects.TIME_DATE_CREATED%type,
150: p_time_modified bism_objects.TIME_DATE_MODIFIED%type,
151: p_oid bism_objects.OBJECT_ID%type,
152: p_container_id bism_objects.CONTAINER_ID%type,
153: p_fid bism_objects.FOLDER_ID%type,
146: p_visible bism_objects.USER_VISIBLE%type,
147: p_obj_type_id bism_objects.OBJECT_TYPE_ID%type,
148: p_version bism_objects.VERSION%type,
149: p_time_created bism_objects.TIME_DATE_CREATED%type,
150: p_time_modified bism_objects.TIME_DATE_MODIFIED%type,
151: p_oid bism_objects.OBJECT_ID%type,
152: p_container_id bism_objects.CONTAINER_ID%type,
153: p_fid bism_objects.FOLDER_ID%type,
154: p_obj_name bism_objects.OBJECT_NAME%type,
147: p_obj_type_id bism_objects.OBJECT_TYPE_ID%type,
148: p_version bism_objects.VERSION%type,
149: p_time_created bism_objects.TIME_DATE_CREATED%type,
150: p_time_modified bism_objects.TIME_DATE_MODIFIED%type,
151: p_oid bism_objects.OBJECT_ID%type,
152: p_container_id bism_objects.CONTAINER_ID%type,
153: p_fid bism_objects.FOLDER_ID%type,
154: p_obj_name bism_objects.OBJECT_NAME%type,
155: p_title bism_objects.TITLE%type,
148: p_version bism_objects.VERSION%type,
149: p_time_created bism_objects.TIME_DATE_CREATED%type,
150: p_time_modified bism_objects.TIME_DATE_MODIFIED%type,
151: p_oid bism_objects.OBJECT_ID%type,
152: p_container_id bism_objects.CONTAINER_ID%type,
153: p_fid bism_objects.FOLDER_ID%type,
154: p_obj_name bism_objects.OBJECT_NAME%type,
155: p_title bism_objects.TITLE%type,
156: p_application bism_objects.APPLICATION%type,
149: p_time_created bism_objects.TIME_DATE_CREATED%type,
150: p_time_modified bism_objects.TIME_DATE_MODIFIED%type,
151: p_oid bism_objects.OBJECT_ID%type,
152: p_container_id bism_objects.CONTAINER_ID%type,
153: p_fid bism_objects.FOLDER_ID%type,
154: p_obj_name bism_objects.OBJECT_NAME%type,
155: p_title bism_objects.TITLE%type,
156: p_application bism_objects.APPLICATION%type,
157: p_database bism_objects.DATABASE%type,
150: p_time_modified bism_objects.TIME_DATE_MODIFIED%type,
151: p_oid bism_objects.OBJECT_ID%type,
152: p_container_id bism_objects.CONTAINER_ID%type,
153: p_fid bism_objects.FOLDER_ID%type,
154: p_obj_name bism_objects.OBJECT_NAME%type,
155: p_title bism_objects.TITLE%type,
156: p_application bism_objects.APPLICATION%type,
157: p_database bism_objects.DATABASE%type,
158: p_desc bism_objects.DESCRIPTION%type,
151: p_oid bism_objects.OBJECT_ID%type,
152: p_container_id bism_objects.CONTAINER_ID%type,
153: p_fid bism_objects.FOLDER_ID%type,
154: p_obj_name bism_objects.OBJECT_NAME%type,
155: p_title bism_objects.TITLE%type,
156: p_application bism_objects.APPLICATION%type,
157: p_database bism_objects.DATABASE%type,
158: p_desc bism_objects.DESCRIPTION%type,
159: p_keywords bism_objects.KEYWORDS%type,
152: p_container_id bism_objects.CONTAINER_ID%type,
153: p_fid bism_objects.FOLDER_ID%type,
154: p_obj_name bism_objects.OBJECT_NAME%type,
155: p_title bism_objects.TITLE%type,
156: p_application bism_objects.APPLICATION%type,
157: p_database bism_objects.DATABASE%type,
158: p_desc bism_objects.DESCRIPTION%type,
159: p_keywords bism_objects.KEYWORDS%type,
160: p_xml bism_objects.XML%type,
153: p_fid bism_objects.FOLDER_ID%type,
154: p_obj_name bism_objects.OBJECT_NAME%type,
155: p_title bism_objects.TITLE%type,
156: p_application bism_objects.APPLICATION%type,
157: p_database bism_objects.DATABASE%type,
158: p_desc bism_objects.DESCRIPTION%type,
159: p_keywords bism_objects.KEYWORDS%type,
160: p_xml bism_objects.XML%type,
161: p_appsubtype1 bism_objects.APPLICATION_SUBTYPE1%type,
154: p_obj_name bism_objects.OBJECT_NAME%type,
155: p_title bism_objects.TITLE%type,
156: p_application bism_objects.APPLICATION%type,
157: p_database bism_objects.DATABASE%type,
158: p_desc bism_objects.DESCRIPTION%type,
159: p_keywords bism_objects.KEYWORDS%type,
160: p_xml bism_objects.XML%type,
161: p_appsubtype1 bism_objects.APPLICATION_SUBTYPE1%type,
162: p_compsubtype1 bism_objects.COMP_SUBTYPE1%type,
155: p_title bism_objects.TITLE%type,
156: p_application bism_objects.APPLICATION%type,
157: p_database bism_objects.DATABASE%type,
158: p_desc bism_objects.DESCRIPTION%type,
159: p_keywords bism_objects.KEYWORDS%type,
160: p_xml bism_objects.XML%type,
161: p_appsubtype1 bism_objects.APPLICATION_SUBTYPE1%type,
162: p_compsubtype1 bism_objects.COMP_SUBTYPE1%type,
163: p_compsubtype2 bism_objects.COMP_SUBTYPE2%type,
156: p_application bism_objects.APPLICATION%type,
157: p_database bism_objects.DATABASE%type,
158: p_desc bism_objects.DESCRIPTION%type,
159: p_keywords bism_objects.KEYWORDS%type,
160: p_xml bism_objects.XML%type,
161: p_appsubtype1 bism_objects.APPLICATION_SUBTYPE1%type,
162: p_compsubtype1 bism_objects.COMP_SUBTYPE1%type,
163: p_compsubtype2 bism_objects.COMP_SUBTYPE2%type,
164: p_compsubtype3 bism_objects.COMP_SUBTYPE3%type,
157: p_database bism_objects.DATABASE%type,
158: p_desc bism_objects.DESCRIPTION%type,
159: p_keywords bism_objects.KEYWORDS%type,
160: p_xml bism_objects.XML%type,
161: p_appsubtype1 bism_objects.APPLICATION_SUBTYPE1%type,
162: p_compsubtype1 bism_objects.COMP_SUBTYPE1%type,
163: p_compsubtype2 bism_objects.COMP_SUBTYPE2%type,
164: p_compsubtype3 bism_objects.COMP_SUBTYPE3%type,
165: p_ext_attrs_clob CLOB,
158: p_desc bism_objects.DESCRIPTION%type,
159: p_keywords bism_objects.KEYWORDS%type,
160: p_xml bism_objects.XML%type,
161: p_appsubtype1 bism_objects.APPLICATION_SUBTYPE1%type,
162: p_compsubtype1 bism_objects.COMP_SUBTYPE1%type,
163: p_compsubtype2 bism_objects.COMP_SUBTYPE2%type,
164: p_compsubtype3 bism_objects.COMP_SUBTYPE3%type,
165: p_ext_attrs_clob CLOB,
166: p_time_last_loaded bism_objects.TIME_DATE_LAST_ACCESSED%type,
159: p_keywords bism_objects.KEYWORDS%type,
160: p_xml bism_objects.XML%type,
161: p_appsubtype1 bism_objects.APPLICATION_SUBTYPE1%type,
162: p_compsubtype1 bism_objects.COMP_SUBTYPE1%type,
163: p_compsubtype2 bism_objects.COMP_SUBTYPE2%type,
164: p_compsubtype3 bism_objects.COMP_SUBTYPE3%type,
165: p_ext_attrs_clob CLOB,
166: p_time_last_loaded bism_objects.TIME_DATE_LAST_ACCESSED%type,
167: p_aggregate_info bism_aggregates.AGGREGATE_INFO%type,
160: p_xml bism_objects.XML%type,
161: p_appsubtype1 bism_objects.APPLICATION_SUBTYPE1%type,
162: p_compsubtype1 bism_objects.COMP_SUBTYPE1%type,
163: p_compsubtype2 bism_objects.COMP_SUBTYPE2%type,
164: p_compsubtype3 bism_objects.COMP_SUBTYPE3%type,
165: p_ext_attrs_clob CLOB,
166: p_time_last_loaded bism_objects.TIME_DATE_LAST_ACCESSED%type,
167: p_aggregate_info bism_aggregates.AGGREGATE_INFO%type,
168: p_obj_is_top_level varchar2);
162: p_compsubtype1 bism_objects.COMP_SUBTYPE1%type,
163: p_compsubtype2 bism_objects.COMP_SUBTYPE2%type,
164: p_compsubtype3 bism_objects.COMP_SUBTYPE3%type,
165: p_ext_attrs_clob CLOB,
166: p_time_last_loaded bism_objects.TIME_DATE_LAST_ACCESSED%type,
167: p_aggregate_info bism_aggregates.AGGREGATE_INFO%type,
168: p_obj_is_top_level varchar2);
169: /* new methods for object level security */
170: 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) return bism_acl_obj_t;
179: function get_privilege(oid raw, myid raw) return number;
180: function prepare_rebind(fid raw,folder_path varchar2,oname varchar2,myid raw,ids out nocopy bism_object_ids, current_time out nocopy date,num number,status out nocopy integer,parentid out nocopy raw) return raw;
181: function prepare_rebind_30(fid raw,folder_path varchar2,oname varchar2,myid raw,ids out nocopy raw, current_time out nocopy date,num number,status out nocopy integer,parentid out nocopy raw) return raw;
182: procedure lookup_folder_wo_security(fid raw,path varchar2,a_objid out nocopy raw,myid raw,startpos in out nocopy integer);
183: function create_subcontext_30(p_tempTimeC bism_objects.time_date_created%type,
184: p_tempTimeM bism_objects.time_date_modified%type,
185: p_oid bism_objects.object_id%type,
186: p_creator bism_subjects.subject_name%type,
187: p_modifier bism_subjects.subject_name%type,
180: function prepare_rebind(fid raw,folder_path varchar2,oname varchar2,myid raw,ids out nocopy bism_object_ids, current_time out nocopy date,num number,status out nocopy integer,parentid out nocopy raw) return raw;
181: function prepare_rebind_30(fid raw,folder_path varchar2,oname varchar2,myid raw,ids out nocopy raw, current_time out nocopy date,num number,status out nocopy integer,parentid out nocopy raw) return raw;
182: procedure lookup_folder_wo_security(fid raw,path varchar2,a_objid out nocopy raw,myid raw,startpos in out nocopy integer);
183: function create_subcontext_30(p_tempTimeC bism_objects.time_date_created%type,
184: p_tempTimeM bism_objects.time_date_modified%type,
185: p_oid bism_objects.object_id%type,
186: p_creator bism_subjects.subject_name%type,
187: p_modifier bism_subjects.subject_name%type,
188: p_fid bism_objects.folder_id%type,
181: function prepare_rebind_30(fid raw,folder_path varchar2,oname varchar2,myid raw,ids out nocopy raw, current_time out nocopy date,num number,status out nocopy integer,parentid out nocopy raw) return raw;
182: procedure lookup_folder_wo_security(fid raw,path varchar2,a_objid out nocopy raw,myid raw,startpos in out nocopy integer);
183: function create_subcontext_30(p_tempTimeC bism_objects.time_date_created%type,
184: p_tempTimeM bism_objects.time_date_modified%type,
185: p_oid bism_objects.object_id%type,
186: p_creator bism_subjects.subject_name%type,
187: p_modifier bism_subjects.subject_name%type,
188: p_fid bism_objects.folder_id%type,
189: p_subid bism_subjects.subject_id%type,
184: p_tempTimeM bism_objects.time_date_modified%type,
185: p_oid bism_objects.object_id%type,
186: p_creator bism_subjects.subject_name%type,
187: p_modifier bism_subjects.subject_name%type,
188: p_fid bism_objects.folder_id%type,
189: p_subid bism_subjects.subject_id%type,
190: p_version bism_objects.VERSION%type,
191: p_object_name bism_objects.object_name%type,
192: p_title bism_objects.title%type,
186: p_creator bism_subjects.subject_name%type,
187: p_modifier bism_subjects.subject_name%type,
188: p_fid bism_objects.folder_id%type,
189: p_subid bism_subjects.subject_id%type,
190: p_version bism_objects.VERSION%type,
191: p_object_name bism_objects.object_name%type,
192: p_title bism_objects.title%type,
193: p_application bism_objects.application%type,
194: p_database bism_objects.database%type,
187: p_modifier bism_subjects.subject_name%type,
188: p_fid bism_objects.folder_id%type,
189: p_subid bism_subjects.subject_id%type,
190: p_version bism_objects.VERSION%type,
191: p_object_name bism_objects.object_name%type,
192: p_title bism_objects.title%type,
193: p_application bism_objects.application%type,
194: p_database bism_objects.database%type,
195: p_desc bism_objects.description%type,
188: p_fid bism_objects.folder_id%type,
189: p_subid bism_subjects.subject_id%type,
190: p_version bism_objects.VERSION%type,
191: p_object_name bism_objects.object_name%type,
192: p_title bism_objects.title%type,
193: p_application bism_objects.application%type,
194: p_database bism_objects.database%type,
195: p_desc bism_objects.description%type,
196: p_keywords bism_objects.keywords%type,
189: p_subid bism_subjects.subject_id%type,
190: p_version bism_objects.VERSION%type,
191: p_object_name bism_objects.object_name%type,
192: p_title bism_objects.title%type,
193: p_application bism_objects.application%type,
194: p_database bism_objects.database%type,
195: p_desc bism_objects.description%type,
196: p_keywords bism_objects.keywords%type,
197: p_appsubtype1 bism_objects.application_subtype1%type,
190: p_version bism_objects.VERSION%type,
191: p_object_name bism_objects.object_name%type,
192: p_title bism_objects.title%type,
193: p_application bism_objects.application%type,
194: p_database bism_objects.database%type,
195: p_desc bism_objects.description%type,
196: p_keywords bism_objects.keywords%type,
197: p_appsubtype1 bism_objects.application_subtype1%type,
198: p_compsubtype1 bism_objects.COMP_SUBTYPE1%type,
191: p_object_name bism_objects.object_name%type,
192: p_title bism_objects.title%type,
193: p_application bism_objects.application%type,
194: p_database bism_objects.database%type,
195: p_desc bism_objects.description%type,
196: p_keywords bism_objects.keywords%type,
197: p_appsubtype1 bism_objects.application_subtype1%type,
198: p_compsubtype1 bism_objects.COMP_SUBTYPE1%type,
199: p_compsubtype2 bism_objects.COMP_SUBTYPE2%type,
192: p_title bism_objects.title%type,
193: p_application bism_objects.application%type,
194: p_database bism_objects.database%type,
195: p_desc bism_objects.description%type,
196: p_keywords bism_objects.keywords%type,
197: p_appsubtype1 bism_objects.application_subtype1%type,
198: p_compsubtype1 bism_objects.COMP_SUBTYPE1%type,
199: p_compsubtype2 bism_objects.COMP_SUBTYPE2%type,
200: p_compsubtype3 bism_objects.COMP_SUBTYPE3%type,
193: p_application bism_objects.application%type,
194: p_database bism_objects.database%type,
195: p_desc bism_objects.description%type,
196: p_keywords bism_objects.keywords%type,
197: p_appsubtype1 bism_objects.application_subtype1%type,
198: p_compsubtype1 bism_objects.COMP_SUBTYPE1%type,
199: p_compsubtype2 bism_objects.COMP_SUBTYPE2%type,
200: p_compsubtype3 bism_objects.COMP_SUBTYPE3%type,
201: p_extAttrs_clob CLOB) return bism_objects.object_id%type;
194: p_database bism_objects.database%type,
195: p_desc bism_objects.description%type,
196: p_keywords bism_objects.keywords%type,
197: p_appsubtype1 bism_objects.application_subtype1%type,
198: p_compsubtype1 bism_objects.COMP_SUBTYPE1%type,
199: p_compsubtype2 bism_objects.COMP_SUBTYPE2%type,
200: p_compsubtype3 bism_objects.COMP_SUBTYPE3%type,
201: p_extAttrs_clob CLOB) return bism_objects.object_id%type;
202:
195: p_desc bism_objects.description%type,
196: p_keywords bism_objects.keywords%type,
197: p_appsubtype1 bism_objects.application_subtype1%type,
198: p_compsubtype1 bism_objects.COMP_SUBTYPE1%type,
199: p_compsubtype2 bism_objects.COMP_SUBTYPE2%type,
200: p_compsubtype3 bism_objects.COMP_SUBTYPE3%type,
201: p_extAttrs_clob CLOB) return bism_objects.object_id%type;
202:
203: function list_dependents(p_fid bism_objects.FOLDER_ID%type, p_objname varchar2, p_myid raw) return myrctype;
196: p_keywords bism_objects.keywords%type,
197: p_appsubtype1 bism_objects.application_subtype1%type,
198: p_compsubtype1 bism_objects.COMP_SUBTYPE1%type,
199: p_compsubtype2 bism_objects.COMP_SUBTYPE2%type,
200: p_compsubtype3 bism_objects.COMP_SUBTYPE3%type,
201: p_extAttrs_clob CLOB) return bism_objects.object_id%type;
202:
203: function list_dependents(p_fid bism_objects.FOLDER_ID%type, p_objname varchar2, p_myid raw) return myrctype;
204: procedure update_attribute(a_fid raw,a_obj_name varchar2,a_attr_name varchar2, a_attr_val varchar2, a_sub_id raw);
197: p_appsubtype1 bism_objects.application_subtype1%type,
198: p_compsubtype1 bism_objects.COMP_SUBTYPE1%type,
199: p_compsubtype2 bism_objects.COMP_SUBTYPE2%type,
200: p_compsubtype3 bism_objects.COMP_SUBTYPE3%type,
201: p_extAttrs_clob CLOB) return bism_objects.object_id%type;
202:
203: function list_dependents(p_fid bism_objects.FOLDER_ID%type, p_objname varchar2, p_myid raw) return myrctype;
204: procedure update_attribute(a_fid raw,a_obj_name varchar2,a_attr_name varchar2, a_attr_val varchar2, a_sub_id raw);
205: procedure update_date_attribute(a_fid raw,a_obj_name varchar2,a_attr_name varchar2, a_attr_val date, a_sub_id raw);
199: p_compsubtype2 bism_objects.COMP_SUBTYPE2%type,
200: p_compsubtype3 bism_objects.COMP_SUBTYPE3%type,
201: p_extAttrs_clob CLOB) return bism_objects.object_id%type;
202:
203: function list_dependents(p_fid bism_objects.FOLDER_ID%type, p_objname varchar2, p_myid raw) return myrctype;
204: procedure update_attribute(a_fid raw,a_obj_name varchar2,a_attr_name varchar2, a_attr_val varchar2, a_sub_id raw);
205: procedure update_date_attribute(a_fid raw,a_obj_name varchar2,a_attr_name varchar2, a_attr_val date, a_sub_id raw);
206: procedure update_attribute(a_fid raw,a_obj_name varchar2,a_ext_attr_xml varchar2, a_sub_id raw);
207: procedure set_auto_commit(p_val varchar2);
211: SELECT T.USER_VISIBLE, T.OBJECT_TYPE_ID, T.OBJECT_ID
212: from
213: (
214: SELECT A.USER_VISIBLE, A.OBJECT_TYPE_ID, A.OBJECT_ID
215: from bism_objects A,
216: (
217: /* 3. distinct is required because there may be diamond relationships in the hierarchy
218: and if so, we only want to fetch it once */
219: /* 4. container_id = '30' is important because an object may have multiple containers