APPS.BSC_AW_MANAGEMENT dependencies on DBMS_SQL

Line 17: procedure get_workspace_lock(p_objects dbms_sql.varchar2_table,p_options varchar2) is

13: /*
14: get object lock (10g)
15: g_locked_objects.delete; happens when commit_aw happens
16: */
17: procedure get_workspace_lock(p_objects dbms_sql.varchar2_table,p_options varchar2) is
18: Begin
19: --we have bsc_aw_utility.add_option so that if "exclusive lock" is passed as an option we can hold it in bsc_aw_utility.g_options
20: bsc_aw_utility.add_option(p_options,null,',');
21: g_locked_objects.delete;

Line 96: procedure get_lock(p_name varchar2,p_mode varchar2,p_locked_objects dbms_sql.varchar2_table) is

92: log_n('Exception in get_lock '||sqlerrm);
93: raise;
94: End;
95:
96: procedure get_lock(p_name varchar2,p_mode varchar2,p_locked_objects dbms_sql.varchar2_table) is
97: Begin
98: attach_workspace(p_name,p_mode);
99: get_lock(p_locked_objects=>p_locked_objects,p_options=>null);
100: Exception when others then

Line 126: procedure get_lock(p_locked_objects dbms_sql.varchar2_table,p_options varchar2) is

122: raise;
123: End;
124:
125: --called from bsc_aw_load_kpi for copy target to actual and aggregate measures in parallel
126: procedure get_lock(p_locked_objects dbms_sql.varchar2_table,p_options varchar2) is
127: --
128: l_count number;
129: l_resync varchar2(20);
130: l_wait varchar2(20);

Line 131: l_resync_object dbms_sql.varchar2_table;

127: --
128: l_count number;
129: l_resync varchar2(20);
130: l_wait varchar2(20);
131: l_resync_object dbms_sql.varchar2_table;
132: l_wait_object dbms_sql.varchar2_table;
133: Begin
134: l_resync:=null;
135: l_wait:=null;

Line 132: l_wait_object dbms_sql.varchar2_table;

128: l_count number;
129: l_resync varchar2(20);
130: l_wait varchar2(20);
131: l_resync_object dbms_sql.varchar2_table;
132: l_wait_object dbms_sql.varchar2_table;
133: Begin
134: l_resync:=null;
135: l_wait:=null;
136: bsc_aw_utility.add_option(p_options,null,',');

Line 221: procedure release_lock(p_objects dbms_sql.varchar2_table) is

217: log_n('Exception in get_lock_object '||sqlerrm);
218: raise;
219: End;
220:
221: procedure release_lock(p_objects dbms_sql.varchar2_table) is
222: Begin
223: for i in 1..p_objects.count loop
224: release_lock(p_objects(i));
225: end loop;

Line 323: procedure commit_aw(p_locked_objects dbms_sql.varchar2_table) is

319: this procedure will update and commit selected objects
320: this is called from kpi loading just before measures are aggregated in parallel. the main process
321: will still lock the limit cubes, but must release the measure cubes
322: */
323: procedure commit_aw(p_locked_objects dbms_sql.varchar2_table) is
324: Begin
325: commit_aw(p_locked_objects=>p_locked_objects,p_options=>null);
326: Exception when others then
327: log_n('Exception in commit_aw '||sqlerrm);

Line 335: procedure commit_aw(p_locked_objects dbms_sql.varchar2_table,p_options varchar2) is

331: /*
332: when we aggregate measures in parallel, just prior to aggregating the measures, we would like to update all the objects
333: so far, but we would not like the lock to be released
334: */
335: procedure commit_aw(p_locked_objects dbms_sql.varchar2_table,p_options varchar2) is
336: Begin
337: commit_aw_multi(p_locked_objects);
338: if not(nvl(bsc_aw_utility.get_parameter_value(p_options,'no release lock',','),'N')='Y') then
339: for i in 1..p_locked_objects.count loop

Line 370: procedure commit_aw_multi(p_locked_objects dbms_sql.varchar2_table) is

366: log_n('Exception in commit_aw_multi '||sqlerrm);
367: raise;
368: End;
369:
370: procedure commit_aw_multi(p_locked_objects dbms_sql.varchar2_table) is
371: l_update_stmt varchar2(5000);
372: l_multi_update boolean;
373: Begin
374: l_multi_update:=false;

Line 534: l_lock_objects dbms_sql.varchar2_table;

530: End;
531:
532: /*p_options:resync */
533: procedure lock_lock_set(p_set_name varchar2,p_options varchar2) is
534: l_lock_objects dbms_sql.varchar2_table;
535: Begin
536: if g_lock_set.exists(p_set_name) then
537: for i in 1..g_lock_set(p_set_name).locked_objects.count loop
538: if bsc_aw_utility.in_array(g_locked_objects,g_lock_set(p_set_name).locked_objects(i))=false then