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.BSC_AW_MANAGEMENT dependencies on DBMS_SQL

Line 7: g_locked_objects dbms_sql.varchar2_table;--used to update, release and commit (10g)

3: --program runtime parameters
4: g_debug boolean;
5: g_attached boolean;--is the aw workspace attached or not
6: g_attached_mode varchar2(80);/*RO,RW,Multi */
7: g_locked_objects dbms_sql.varchar2_table;--used to update, release and commit (10g)
8: --
9: type current_sessions_r is record(
10: sid number,
11: serial number,

Line 18: locked_objects dbms_sql.varchar2_table

14: type current_sessions_tb is table of current_sessions_r index by pls_integer;
15: --
16: type lock_sets_r is record(
17: lock_set varchar2(100),
18: locked_objects dbms_sql.varchar2_table
19: );
20: type lock_sets_tv is table of lock_sets_r index by varchar2(100);
21: g_lock_set lock_sets_tv;
22: --procedures-------------------------------------------------------

Line 23: procedure get_workspace_lock(p_objects dbms_sql.varchar2_table,p_options varchar2);

19: );
20: type lock_sets_tv is table of lock_sets_r index by varchar2(100);
21: g_lock_set lock_sets_tv;
22: --procedures-------------------------------------------------------
23: procedure get_workspace_lock(p_objects dbms_sql.varchar2_table,p_options varchar2);
24: procedure get_workspace_lock(p_mode varchar2,p_options varchar2);
25: procedure get_lock(p_mode varchar2,p_options varchar2);
26: procedure get_lock(p_name varchar2,p_mode varchar2,p_locked_objects dbms_sql.varchar2_table);
27: procedure get_lock(p_locked_objects dbms_sql.varchar2_table,p_options varchar2);

Line 26: procedure get_lock(p_name varchar2,p_mode varchar2,p_locked_objects dbms_sql.varchar2_table);

22: --procedures-------------------------------------------------------
23: procedure get_workspace_lock(p_objects dbms_sql.varchar2_table,p_options varchar2);
24: procedure get_workspace_lock(p_mode varchar2,p_options varchar2);
25: procedure get_lock(p_mode varchar2,p_options varchar2);
26: procedure get_lock(p_name varchar2,p_mode varchar2,p_locked_objects dbms_sql.varchar2_table);
27: procedure get_lock(p_locked_objects dbms_sql.varchar2_table,p_options varchar2);
28: function get_aw_workspace_name return varchar2;
29: procedure detach_workspace;
30: procedure detach_workspace(p_workspace varchar2);

Line 27: procedure get_lock(p_locked_objects dbms_sql.varchar2_table,p_options varchar2);

23: procedure get_workspace_lock(p_objects dbms_sql.varchar2_table,p_options varchar2);
24: procedure get_workspace_lock(p_mode varchar2,p_options varchar2);
25: procedure get_lock(p_mode varchar2,p_options varchar2);
26: procedure get_lock(p_name varchar2,p_mode varchar2,p_locked_objects dbms_sql.varchar2_table);
27: procedure get_lock(p_locked_objects dbms_sql.varchar2_table,p_options varchar2);
28: function get_aw_workspace_name return varchar2;
29: procedure detach_workspace;
30: procedure detach_workspace(p_workspace varchar2);
31: procedure commit_aw;

Line 40: procedure commit_aw_multi(p_locked_objects dbms_sql.varchar2_table);

36: procedure drop_workspace(p_name varchar2,p_options varchar2);
37: procedure exec_workspace_settings;
38: procedure release_lock(p_object varchar2) ;
39: procedure commit_aw_multi;
40: procedure commit_aw_multi(p_locked_objects dbms_sql.varchar2_table);
41: procedure commit_aw(p_locked_objects dbms_sql.varchar2_table);
42: procedure commit_aw(p_locked_objects dbms_sql.varchar2_table,p_options varchar2);
43: procedure release_lock(p_objects dbms_sql.varchar2_table) ;
44: procedure get_lock_object(p_object varchar2,p_resync varchar2,p_wait varchar2);

Line 41: procedure commit_aw(p_locked_objects dbms_sql.varchar2_table);

37: procedure exec_workspace_settings;
38: procedure release_lock(p_object varchar2) ;
39: procedure commit_aw_multi;
40: procedure commit_aw_multi(p_locked_objects dbms_sql.varchar2_table);
41: procedure commit_aw(p_locked_objects dbms_sql.varchar2_table);
42: procedure commit_aw(p_locked_objects dbms_sql.varchar2_table,p_options varchar2);
43: procedure release_lock(p_objects dbms_sql.varchar2_table) ;
44: procedure get_lock_object(p_object varchar2,p_resync varchar2,p_wait varchar2);
45: procedure create_default_elements;

Line 42: procedure commit_aw(p_locked_objects dbms_sql.varchar2_table,p_options varchar2);

38: procedure release_lock(p_object varchar2) ;
39: procedure commit_aw_multi;
40: procedure commit_aw_multi(p_locked_objects dbms_sql.varchar2_table);
41: procedure commit_aw(p_locked_objects dbms_sql.varchar2_table);
42: procedure commit_aw(p_locked_objects dbms_sql.varchar2_table,p_options varchar2);
43: procedure release_lock(p_objects dbms_sql.varchar2_table) ;
44: procedure get_lock_object(p_object varchar2,p_resync varchar2,p_wait varchar2);
45: procedure create_default_elements;
46: procedure set_hash_partition_dim;

Line 43: procedure release_lock(p_objects dbms_sql.varchar2_table) ;

39: procedure commit_aw_multi;
40: procedure commit_aw_multi(p_locked_objects dbms_sql.varchar2_table);
41: procedure commit_aw(p_locked_objects dbms_sql.varchar2_table);
42: procedure commit_aw(p_locked_objects dbms_sql.varchar2_table,p_options varchar2);
43: procedure release_lock(p_objects dbms_sql.varchar2_table) ;
44: procedure get_lock_object(p_object varchar2,p_resync varchar2,p_wait varchar2);
45: procedure create_default_elements;
46: procedure set_hash_partition_dim;
47: procedure attach_workspace(p_name varchar2,p_mode varchar2);