DBA Data[Home] [Help]

APPS.BISM_UTILS dependencies on DUAL

Line 8: select sys_guid() into oid from dual;

4: return raw
5: is
6: oid raw(16);
7: begin
8: select sys_guid() into oid from dual;
9: return oid;
10: end;
11:
12: function get_database_user return varchar2

Line 16: select sys_context('userenv','session_user') into user from dual;

12: function get_database_user return varchar2
13: is
14: user varchar2(64);
15: begin
16: select sys_context('userenv','session_user') into user from dual;
17: return user;
18: end;
19:
20: function get_current_user_id return raw

Line 24: -- select sys_context('bism_session','current_user_id') into id from dual;

20: function get_current_user_id return raw
21: is
22: id raw(16);
23: begin
24: -- select sys_context('bism_session','current_user_id') into id from dual;
25: return id;
26: end;
27:
28: function init_user(user varchar2) return raw

Line 47: -- select sys_context('bism_session','current_user_id') into sub_id from dual;

43: -- make sure that the user is internally identified (we need SUBJECT_ID)
44: begin
45: select subject_id into sub_id from bism_subjects where subject_name = user ;
46: -- bism_context.set_user(sub_id);
47: -- select sys_context('bism_session','current_user_id') into sub_id from dual;
48: exception
49: when no_data_found then
50: -- renumber the error messages later..
51: raise_application_error(BISM_ERRORCODES.USER_NOT_IDENTIFIED,'User could not be identified',true);

Line 81: select sys_guid() into oid from dual;

77: oid raw(16);
78: ids bism_object_ids := bism_object_ids();
79: begin
80: for i in 1..num loop
81: select sys_guid() into oid from dual;
82: ids.extend();
83: ids(i) := oid;
84: end loop;
85: select sysdate into current_time from dual;

Line 85: select sysdate into current_time from dual;

81: select sys_guid() into oid from dual;
82: ids.extend();
83: ids(i) := oid;
84: end loop;
85: select sysdate into current_time from dual;
86: return ids;
87: end;
88:
89: function get_object_ids_and_time_30(num number,current_time out nocopy date)

Line 96: select sysdate into current_time from dual;

92: oid raw(16);
93: ids raw(32000);
94: begin
95: -- the caller shouldn't ask for more than 2000 ids at a time
96: select sysdate into current_time from dual;
97: if num > 2000 then
98: return null;
99: end if;
100: for i in 1..num loop

Line 101: select sys_guid() into oid from dual;

97: if num > 2000 then
98: return null;
99: end if;
100: for i in 1..num loop
101: select sys_guid() into oid from dual;
102: ids := ids || oid;
103: end loop;
104: return ids;
105: end;