APPS.BISM_WEAKAGGREGATES SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 101

insert into bism_associates (source_id,target_id,name,value) values (a_srcid,a_tgtid,name,value);

Line: 112

rows_deleted integer:= 0;

Line: 168

delete from bism_associates where source_id = a_srcid;

Line: 170

delete from bism_associates where source_id = a_srcid and name = a_name;

Line: 172

delete from bism_associates where source_id = a_srcid and name = a_name and value = a_value;

Line: 175

rows_deleted := SQL%ROWCOUNT;

Line: 176

if rows_deleted = 0 then
raise_application_error(BISM_ERRORCODES.ASSOCIATION_NOT_FOUND, 'Association not found');

Line: 232

select target_id into b_tgtid from bism_associates where source_id = a_srcid and name = a_attrname and value = a_attrvalue;

Line: 251

open rc for SELECT T.USER_VISIBLE, T.OBJECT_TYPE_ID, T.VERSION, T.TIME_DATE_CREATED,
T.TIME_DATE_MODIFIED, T.OBJECT_ID,T.FOLDER_ID, T.CREATED_BY,
T.LAST_MODIFIED_BY, T.OBJECT_NAME, T.TITLE, T.APPLICATION, T.DATABASE, T.DESCRIPTION,
T.KEYWORDS, T.XML, T.APPLICATION_SUBTYPE1, T.COMP_SUBTYPE1, T.COMP_SUBTYPE2,T.COMP_SUBTYPE3,T.TIME_DATE_LAST_ACCESSED,
T.container_id,T.aggregate_info from
(
SELECT A.USER_VISIBLE, A.OBJECT_TYPE_ID, A.VERSION, A.TIME_DATE_CREATED,
A.TIME_DATE_MODIFIED, A.OBJECT_ID,A.FOLDER_ID, A.CREATED_BY,
A.LAST_MODIFIED_BY, A.OBJECT_NAME, A.TITLE, A.APPLICATION, A.DATABASE, A.DESCRIPTION,
A.KEYWORDS, A.XML, A.APPLICATION_SUBTYPE1, A.COMP_SUBTYPE1, A.COMP_SUBTYPE2,A.COMP_SUBTYPE3, A.TIME_DATE_LAST_ACCESSED,
T1.container_id,T1.aggregate_info
from bism_objects A,
(
select distinct containee_id,container_id,aggregate_info from bism_aggregates start with containee_id = objid and container_id='30' connect by container_id = prior containee_id
order siblings by containee_id
)
T1
where A.object_id=T1.containee_id
)
T ;

Line: 299

    select object_id,object_type_id,object_name,user_visible into oid,typeid,oname,visible from bism_objects where folder_id = fid and object_name = newstr and user_visible = 'Y';