DBA Data[Home] [Help]

APPS.BISM_CORE dependencies on BISM_AGGREGATES

Line 91: p_container_id2 bism_aggregates.CONTAINER_ID%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,
95: p_subject_id bism_subjects.SUBJECT_ID%type,

Line 92: p_aggregate_info bism_aggregates.AGGREGATE_INFO%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,
95: p_subject_id bism_subjects.SUBJECT_ID%type,
96: p_visible bism_objects.USER_VISIBLE%type,

Line 115: p_container_id2 bism_aggregates.CONTAINER_ID%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);
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);

Line 116: p_aggregate_info bism_aggregates.AGGREGATE_INFO%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);
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;

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

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,
123: p_subject_id bism_subjects.SUBJECT_ID%type,

Line 167: p_aggregate_info bism_aggregates.AGGREGATE_INFO%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;
171: 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);

Line 222: select distinct containee_id,container_id,aggregate_info from bism_aggregates start with containee_id = cid and container_id='30' connect by container_id = prior containee_id

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
220: in which case we end up fetching those rows as well, which is useless
221: */
222: select distinct containee_id,container_id,aggregate_info from bism_aggregates start with containee_id = cid and container_id='30' connect by container_id = prior containee_id
223: )
224: T1
225: /* 5. fetch only the required object hierarchy */
226: where A.object_id=T1.containee_id