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_CORE dependencies on DUAL

Line 326: select sys_guid() into tempid from dual;

322:
323: --everything went well so fetch ids and return it
324: begin
325: for i in 1..num-1 loop
326: select sys_guid() into tempid from dual;
327: ids.extend();
328: ids(i) := tempid;
329: end loop;
330: select sysdate into current_time from dual;

Line 330: select sysdate into current_time from dual;

326: select sys_guid() into tempid from dual;
327: ids.extend();
328: ids(i) := tempid;
329: end loop;
330: select sysdate into current_time from dual;
331: end;
332: status :=BISM_CONSTANTS.IS_OBJECT;
333: return oid;
334: else -- type is 100 , i.e it's a folder !

Line 354: select sys_guid() into tempid from dual;

350:
351:
352: begin
353: for i in 1..num loop
354: select sys_guid() into tempid from dual;
355: ids.extend();
356: ids(i) := tempid;
357: end loop;
358: select sysdate into current_time from dual;

Line 358: select sysdate into current_time from dual;

354: select sys_guid() into tempid from dual;
355: ids.extend();
356: ids(i) := tempid;
357: end loop;
358: select sysdate into current_time from dual;
359: end;
360: return null;
361: end;
362:

Line 376: --select sysdate into current_time from dual;

372: ret varchar2(1) := 'n';
373: begin
374: --ids := bism_object_ids();
375: -- the caller shouldn't ask for more than 2000 ids at a time
376: --select sysdate into current_time from dual;
377: --if num > 2000 then
378: -- return null;
379: -- make sure the folder exists and that the user has delete
380: -- privilege on it

Line 416: select sys_guid() into tempid from dual;

412:
413: --everything went well so fetch ids and return it
414: begin
415: for i in 1..num-1 loop
416: select sys_guid() into tempid from dual;
417: --ids.extend();
418: --ids(i) := tempid;
419: ids := ids || tempid;
420: end loop;

Line 421: select sysdate into current_time from dual;

417: --ids.extend();
418: --ids(i) := tempid;
419: ids := ids || tempid;
420: end loop;
421: select sysdate into current_time from dual;
422: end;
423: status :=BISM_CONSTANTS.IS_OBJECT;
424: return oid;
425: else -- type is 100 , i.e it's a folder !

Line 445: select sys_guid() into tempid from dual;

441:
442:
443: begin
444: for i in 1..num loop
445: select sys_guid() into tempid from dual;
446: --ids.extend();
447: --ids(i) := tempid;
448: ids := ids || tempid;
449: end loop;

Line 450: select sysdate into current_time from dual;

446: --ids.extend();
447: --ids(i) := tempid;
448: ids := ids || tempid;
449: end loop;
450: select sysdate into current_time from dual;
451: end;
452: return null;
453: end;
454:

Line 534: select sys_guid() into tempid from dual;

530:
531: --everything went well so fetch ids and return it
532: for i in 1..num-1
533: loop
534: select sys_guid() into tempid from dual;
535: ids.extend();
536: ids(i) := tempid;
537: end loop;
538: select sysdate into current_time from dual;

Line 538: select sysdate into current_time from dual;

534: select sys_guid() into tempid from dual;
535: ids.extend();
536: ids(i) := tempid;
537: end loop;
538: select sysdate into current_time from dual;
539:
540: status :=BISM_CONSTANTS.IS_OBJECT;
541: return oid;
542: else -- type is 100 , i.e it's a folder !

Line 556: select sys_guid() into tempid from dual;

552:
553: begin
554: for i in 1..num
555: loop
556: select sys_guid() into tempid from dual;
557: ids.extend();
558: ids(i) := tempid;
559: end loop;
560: select sysdate into current_time from dual;

Line 560: select sysdate into current_time from dual;

556: select sys_guid() into tempid from dual;
557: ids.extend();
558: ids(i) := tempid;
559: end loop;
560: select sysdate into current_time from dual;
561: end;
562: return null;
563: end;
564: end prepare_rebind;

Line 611: select sys_guid() into tempid from dual;

607:
608: --everything went well so fetch ids and return it
609: for i in 1..num-1
610: loop
611: select sys_guid() into tempid from dual;
612: --ids.extend();
613: --ids(i) := tempid;
614: ids := ids || tempid;
615: end loop;

Line 616: select sysdate into current_time from dual;

612: --ids.extend();
613: --ids(i) := tempid;
614: ids := ids || tempid;
615: end loop;
616: select sysdate into current_time from dual;
617:
618: status :=BISM_CONSTANTS.IS_OBJECT;
619: return oid;
620: else -- type is 100 , i.e it's a folder !

Line 634: select sys_guid() into tempid from dual;

630:
631: begin
632: for i in 1..num
633: loop
634: select sys_guid() into tempid from dual;
635: --ids.extend();
636: --ids(i) := tempid;
637: ids := ids || tempid;
638: end loop;

Line 639: select sysdate into current_time from dual;

635: --ids.extend();
636: --ids(i) := tempid;
637: ids := ids || tempid;
638: end loop;
639: select sysdate into current_time from dual;
640: end;
641: return null;
642: end;
643: end prepare_rebind_30;

Line 918: select 'y' into v_var from dual where tgtfid = any ( select object_id from bism_objects where object_type_id = 100 start with object_id = srcfid connect by folder_id = prior object_id);

914: -- if so we cannot move src folder to target folder
915: -- ex : assume : folder foo contains folder goo
916: -- user attempts to move foo to goo which is illegal
917: -- so check to see if target (goo) is in the path of source (foo)
918: select 'y' into v_var from dual where tgtfid = any ( select object_id from bism_objects where object_type_id = 100 start with object_id = srcfid connect by folder_id = prior object_id);
919: exception
920: when no_data_found then
921: return false;
922: end;

Line 1871: select sysdate into current_date from dual;

1867: /* technically speaking we dont have to check the privilege any more
1868: because th euser would have access to the OID only when could access that object*/
1869: and 'y' = bism_core.check_lookup_access(T1.object_id,T1.object_type_id,T1.user_visible,myid);
1870: if traceLastLoaded = '1' then
1871: select sysdate into current_date from dual;
1872: update bism_objects set TIME_DATE_LAST_ACCESSED = current_date where object_id = objid;
1873: end if;
1874:
1875: return rc;

Line 1990: select sysdate into current_date from dual;

1986: 'y' = bism_core.check_lookup_access(T.object_id, T.object_type_id, T.user_visible, myid);
1987:
1988: /* now set lastLoaded attribute*/
1989: if traceLastLoaded = '1' then
1990: select sysdate into current_date from dual;
1991: --update bism_objects set TIME_DATE_LAST_ACCESSED = current_date where object_id = oid;
1992: open obj_ids_cursor(cid,myid);
1993: fetch obj_ids_cursor bulk collect into uvs_array, otids_array, ids_array;
1994: if ids_array.COUNT > 0 then