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_OBJECTS

Line 5: a_srcname bism_objects.object_name%type;

1: package body bism_weakaggregates as
2: /* $Header: bibasctb.pls 120.2 2006/04/03 05:19:39 akbansal noship $ */
3: procedure associate(fid raw, a_srcpath varchar2,a_tgtpath varchar2,name varchar2,value varchar2, myid raw)
4: is
5: a_srcname bism_objects.object_name%type;
6: a_srcid bism_objects.object_id%type;
7: a_srctypeid bism_objects.object_type_id%type;
8: a_tgtname bism_objects.object_name%type;
9: a_tgtid bism_objects.object_id%type;

Line 6: a_srcid bism_objects.object_id%type;

2: /* $Header: bibasctb.pls 120.2 2006/04/03 05:19:39 akbansal noship $ */
3: procedure associate(fid raw, a_srcpath varchar2,a_tgtpath varchar2,name varchar2,value varchar2, myid raw)
4: is
5: a_srcname bism_objects.object_name%type;
6: a_srcid bism_objects.object_id%type;
7: a_srctypeid bism_objects.object_type_id%type;
8: a_tgtname bism_objects.object_name%type;
9: a_tgtid bism_objects.object_id%type;
10: a_tgttypeid bism_objects.object_type_id%type;

Line 7: a_srctypeid bism_objects.object_type_id%type;

3: procedure associate(fid raw, a_srcpath varchar2,a_tgtpath varchar2,name varchar2,value varchar2, myid raw)
4: is
5: a_srcname bism_objects.object_name%type;
6: a_srcid bism_objects.object_id%type;
7: a_srctypeid bism_objects.object_type_id%type;
8: a_tgtname bism_objects.object_name%type;
9: a_tgtid bism_objects.object_id%type;
10: a_tgttypeid bism_objects.object_type_id%type;
11: ret varchar2(1);

Line 8: a_tgtname bism_objects.object_name%type;

4: is
5: a_srcname bism_objects.object_name%type;
6: a_srcid bism_objects.object_id%type;
7: a_srctypeid bism_objects.object_type_id%type;
8: a_tgtname bism_objects.object_name%type;
9: a_tgtid bism_objects.object_id%type;
10: a_tgttypeid bism_objects.object_type_id%type;
11: ret varchar2(1);
12: -- I need to map the following exceptions

Line 9: a_tgtid bism_objects.object_id%type;

5: a_srcname bism_objects.object_name%type;
6: a_srcid bism_objects.object_id%type;
7: a_srctypeid bism_objects.object_type_id%type;
8: a_tgtname bism_objects.object_name%type;
9: a_tgtid bism_objects.object_id%type;
10: a_tgttypeid bism_objects.object_type_id%type;
11: ret varchar2(1);
12: -- I need to map the following exceptions
13: invalid_folder_path EXCEPTION;

Line 10: a_tgttypeid bism_objects.object_type_id%type;

6: a_srcid bism_objects.object_id%type;
7: a_srctypeid bism_objects.object_type_id%type;
8: a_tgtname bism_objects.object_name%type;
9: a_tgtid bism_objects.object_id%type;
10: a_tgttypeid bism_objects.object_type_id%type;
11: ret varchar2(1);
12: -- I need to map the following exceptions
13: invalid_folder_path EXCEPTION;
14: object_not_found EXCEPTION;

Line 109: a_srcname bism_objects.object_name%type;

105:
106: procedure dissociate(fid raw, a_srcpath varchar2, a_name varchar2, a_value varchar2,myid raw)
107: is
108: ret varchar2(1);
109: a_srcname bism_objects.object_name%type;
110: a_srcid bism_objects.object_id%type;
111: a_srctypeid bism_objects.object_type_id%type;
112: rows_deleted integer:= 0;
113:

Line 110: a_srcid bism_objects.object_id%type;

106: procedure dissociate(fid raw, a_srcpath varchar2, a_name varchar2, a_value varchar2,myid raw)
107: is
108: ret varchar2(1);
109: a_srcname bism_objects.object_name%type;
110: a_srcid bism_objects.object_id%type;
111: a_srctypeid bism_objects.object_type_id%type;
112: rows_deleted integer:= 0;
113:
114: invalid_folder_path EXCEPTION;

Line 111: a_srctypeid bism_objects.object_type_id%type;

107: is
108: ret varchar2(1);
109: a_srcname bism_objects.object_name%type;
110: a_srcid bism_objects.object_id%type;
111: a_srctypeid bism_objects.object_type_id%type;
112: rows_deleted integer:= 0;
113:
114: invalid_folder_path EXCEPTION;
115: object_not_found EXCEPTION;

Line 188: a_srcname bism_objects.object_name%type;

184: return myrctype
185: is
186: rc myrctype;
187: ret varchar2(1);
188: a_srcname bism_objects.object_name%type;
189: a_srcid bism_objects.object_id%type;
190: a_srctypeid bism_objects.object_type_id%type;
191: b_tgtid bism_objects.object_id%type;
192: invalid_folder_path EXCEPTION;

Line 189: a_srcid bism_objects.object_id%type;

185: is
186: rc myrctype;
187: ret varchar2(1);
188: a_srcname bism_objects.object_name%type;
189: a_srcid bism_objects.object_id%type;
190: a_srctypeid bism_objects.object_type_id%type;
191: b_tgtid bism_objects.object_id%type;
192: invalid_folder_path EXCEPTION;
193: object_not_found EXCEPTION;

Line 190: a_srctypeid bism_objects.object_type_id%type;

186: rc myrctype;
187: ret varchar2(1);
188: a_srcname bism_objects.object_name%type;
189: a_srcid bism_objects.object_id%type;
190: a_srctypeid bism_objects.object_type_id%type;
191: b_tgtid bism_objects.object_id%type;
192: invalid_folder_path EXCEPTION;
193: object_not_found EXCEPTION;
194: no_privileges EXCEPTION;

Line 191: b_tgtid bism_objects.object_id%type;

187: ret varchar2(1);
188: a_srcname bism_objects.object_name%type;
189: a_srcid bism_objects.object_id%type;
190: a_srctypeid bism_objects.object_type_id%type;
191: b_tgtid bism_objects.object_id%type;
192: invalid_folder_path EXCEPTION;
193: object_not_found EXCEPTION;
194: no_privileges EXCEPTION;
195: insufficient_provileges EXCEPTION;

Line 262: from bism_objects A,

258: A.TIME_DATE_MODIFIED, A.OBJECT_ID,A.FOLDER_ID, A.CREATED_BY,
259: A.LAST_MODIFIED_BY, A.OBJECT_NAME, A.TITLE, A.APPLICATION, A.DATABASE, A.DESCRIPTION,
260: A.KEYWORDS, A.XML, A.APPLICATION_SUBTYPE1, A.COMP_SUBTYPE1, A.COMP_SUBTYPE2,A.COMP_SUBTYPE3, A.TIME_DATE_LAST_ACCESSED,
261: T1.container_id,T1.aggregate_info
262: from bism_objects A,
263: (
264: 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
265: order siblings by containee_id
266: )

Line 283: oid bism_objects.object_id%type;

279: end;
280:
281: procedure get(fid raw,path varchar2,a_objname out nocopy varchar2,a_objid out nocopy raw,a_typeid out nocopy number,myid raw,startpos in out nocopy integer,folderid out nocopy raw)
282: is
283: oid bism_objects.object_id%type;
284: typeid bism_objects.object_type_id%type;
285: oname bism_objects.object_name%type;
286: ret varchar2(1) := 'n';
287: visible bism_objects.user_visible%type;

Line 284: typeid bism_objects.object_type_id%type;

280:
281: procedure get(fid raw,path varchar2,a_objname out nocopy varchar2,a_objid out nocopy raw,a_typeid out nocopy number,myid raw,startpos in out nocopy integer,folderid out nocopy raw)
282: is
283: oid bism_objects.object_id%type;
284: typeid bism_objects.object_type_id%type;
285: oname bism_objects.object_name%type;
286: ret varchar2(1) := 'n';
287: visible bism_objects.user_visible%type;
288: newstr varchar2(2000) := '';

Line 285: oname bism_objects.object_name%type;

281: procedure get(fid raw,path varchar2,a_objname out nocopy varchar2,a_objid out nocopy raw,a_typeid out nocopy number,myid raw,startpos in out nocopy integer,folderid out nocopy raw)
282: is
283: oid bism_objects.object_id%type;
284: typeid bism_objects.object_type_id%type;
285: oname bism_objects.object_name%type;
286: ret varchar2(1) := 'n';
287: visible bism_objects.user_visible%type;
288: newstr varchar2(2000) := '';
289: len integer :=0;

Line 287: visible bism_objects.user_visible%type;

283: oid bism_objects.object_id%type;
284: typeid bism_objects.object_type_id%type;
285: oname bism_objects.object_name%type;
286: ret varchar2(1) := 'n';
287: visible bism_objects.user_visible%type;
288: newstr varchar2(2000) := '';
289: len integer :=0;
290: len1 integer :=0;
291: begin

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';

295: newstr := bism_core.get_next_element(path,'/',startpos);
296: len := nvl(length(newstr),0);
297: if len <> 0 then
298: begin
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';
300: ret := bism_access_control.check_list_access(fid,myid);
301:
302: if ret = 'y' then
303: -- when the given string does not contain the delimiter any more

Line 331: a_srcname bism_objects.object_name%type;

327: function verify_source(fid raw,a_srcpath varchar2,myid raw,folderid out nocopy raw)
328: return raw
329: is
330: rc bism_weakaggregates.myrctype;
331: a_srcname bism_objects.object_name%type;
332: a_srcid bism_objects.object_id%type;
333: a_srctypeid bism_objects.object_type_id%type;
334:
335: invalid_folder_path EXCEPTION;

Line 332: a_srcid bism_objects.object_id%type;

328: return raw
329: is
330: rc bism_weakaggregates.myrctype;
331: a_srcname bism_objects.object_name%type;
332: a_srcid bism_objects.object_id%type;
333: a_srctypeid bism_objects.object_type_id%type;
334:
335: invalid_folder_path EXCEPTION;
336: object_not_found EXCEPTION;

Line 333: a_srctypeid bism_objects.object_type_id%type;

329: is
330: rc bism_weakaggregates.myrctype;
331: a_srcname bism_objects.object_name%type;
332: a_srcid bism_objects.object_id%type;
333: a_srctypeid bism_objects.object_type_id%type;
334:
335: invalid_folder_path EXCEPTION;
336: object_not_found EXCEPTION;
337: no_privileges EXCEPTION;

Line 346: a_objname bism_objects.object_name%type;

342: PRAGMA EXCEPTION_INIT(object_not_found,-20200);
343: PRAGMA EXCEPTION_INIT(no_privileges, -20404);
344: PRAGMA EXCEPTION_INIT(insufficient_provileges, -20400);
345: PRAGMA EXCEPTION_INIT(folder_not_found, -20300);
346: a_objname bism_objects.object_name%type;
347: a_objid bism_objects.object_id%type;
348: a_typeid bism_objects.object_type_id%type;
349: startpos integer := 1;-- unparsed string, so start at 1
350: ret varchar2(1);

Line 347: a_objid bism_objects.object_id%type;

343: PRAGMA EXCEPTION_INIT(no_privileges, -20404);
344: PRAGMA EXCEPTION_INIT(insufficient_provileges, -20400);
345: PRAGMA EXCEPTION_INIT(folder_not_found, -20300);
346: a_objname bism_objects.object_name%type;
347: a_objid bism_objects.object_id%type;
348: a_typeid bism_objects.object_type_id%type;
349: startpos integer := 1;-- unparsed string, so start at 1
350: ret varchar2(1);
351:

Line 348: a_typeid bism_objects.object_type_id%type;

344: PRAGMA EXCEPTION_INIT(insufficient_provileges, -20400);
345: PRAGMA EXCEPTION_INIT(folder_not_found, -20300);
346: a_objname bism_objects.object_name%type;
347: a_objid bism_objects.object_id%type;
348: a_typeid bism_objects.object_type_id%type;
349: startpos integer := 1;-- unparsed string, so start at 1
350: ret varchar2(1);
351:
352: begin