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_WEAKAGGREGATES dependencies on BISM_ASSOCIATES

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

97: end;
98:
99: --if something went wrong, it would have thrown exception by now, so every thing
100: -- is a OK
101: insert into bism_associates (source_id,target_id,name,value) values (a_srcid,a_tgtid,name,value);
102: -- if there is any exceptions, let it bubble up
103:
104: end;
105:

Line 168: delete from bism_associates where source_id = a_srcid;

164: --if something went wrong, it would have thrown exception by now, so every thing
165: -- is a OK
166:
167: if a_srcid is not null and a_name is null then
168: delete from bism_associates where source_id = a_srcid;
169: elsif a_srcid is not null and a_name is not null and a_value is null then
170: delete from bism_associates where source_id = a_srcid and name = a_name;
171: else
172: delete from bism_associates where source_id = a_srcid and name = a_name and value = a_value;

Line 170: delete from bism_associates where source_id = a_srcid and name = a_name;

166:
167: if a_srcid is not null and a_name is null then
168: delete from bism_associates where source_id = a_srcid;
169: elsif a_srcid is not null and a_name is not null and a_value is null then
170: delete from bism_associates where source_id = a_srcid and name = a_name;
171: else
172: delete from bism_associates where source_id = a_srcid and name = a_name and value = a_value;
173: end if;
174:

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

168: delete from bism_associates where source_id = a_srcid;
169: elsif a_srcid is not null and a_name is not null and a_value is null then
170: delete from bism_associates where source_id = a_srcid and name = a_name;
171: else
172: delete from bism_associates where source_id = a_srcid and name = a_name and value = a_value;
173: end if;
174:
175: rows_deleted := SQL%ROWCOUNT;
176: if rows_deleted = 0 then

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

228: raise;
229: end;
230:
231: begin
232: select target_id into b_tgtid from bism_associates where source_id = a_srcid and name = a_attrname and value = a_attrvalue;
233: exception
234: when no_data_found then
235: raise_application_error(BISM_ERRORCODES.ASSOCIATION_NOT_FOUND,'Association not found');
236: when others then