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 BSC_AW_DBMS_AW

Line 116: bsc_aw_dbms_aw.execute('aw attach '||p_name||' '||p_mode);

112: end if;
113: /*Q:is serialization reqd here? as soon as session 1 releases WS, will there be a race by session 2? serializing just the ws attach may not be a
114: solution anyway */
115: detach_aw_workspace(p_name);
116: bsc_aw_dbms_aw.execute('aw attach '||p_name||' '||p_mode);
117: end if;
118: g_attached:=true;
119: g_attached_mode:=upper(p_mode);
120: Exception when others then

Line 161: --even if bsc_aw_dbms_aw.execute raises an exception, this will not go into an infinite loop

157: end if;
158: Exception when others then
159: --we have to release the locks, else there may be a deadlock
160: --we cannot rollback. it has to be an explicit release
161: --even if bsc_aw_dbms_aw.execute raises an exception, this will not go into an infinite loop
162: if l_count is not null and l_count>0 then --release them
163: for i in 1..l_count loop
164: bsc_aw_dbms_aw.execute('release '||p_locked_objects(i));
165: end loop;

Line 164: bsc_aw_dbms_aw.execute('release '||p_locked_objects(i));

160: --we cannot rollback. it has to be an explicit release
161: --even if bsc_aw_dbms_aw.execute raises an exception, this will not go into an infinite loop
162: if l_count is not null and l_count>0 then --release them
163: for i in 1..l_count loop
164: bsc_aw_dbms_aw.execute('release '||p_locked_objects(i));
165: end loop;
166: end if;
167: log_n('Exception in get_lock '||sqlerrm);
168: raise;

Line 184: bsc_aw_dbms_aw.execute('acquire '||l_resync||' '||p_object||' '||l_wait);

180: l_wait:=p_wait;
181: end if;
182: loop
183: begin
184: bsc_aw_dbms_aw.execute('acquire '||l_resync||' '||p_object||' '||l_wait);
185: exit;
186: exception when others then
187: if sqlcode=-37014 then --lock already acquired by the same session
188: if g_debug then

Line 234: bsc_aw_dbms_aw.execute('release '||p_object);

230:
231: procedure release_lock(p_object varchar2) is
232: Begin
233: if bsc_aw_utility.get_db_version>=10 and nvl(bsc_aw_utility.get_parameter_value('exclusive lock'),'N')='N' then
234: bsc_aw_dbms_aw.execute('release '||p_object);
235: end if;
236: Exception when others then
237: if sqlcode=-37021 then
238: log_n('Object '||p_object||' not acquired');

Line 266: bsc_aw_dbms_aw.execute('aw detach '||p_workspace);

262: procedure detach_aw_workspace(p_workspace varchar2) is
263: Begin
264: if g_attached then
265: bsc_aw_utility.add_sqlerror(-34344,'ignore',null);--ignore if the ws is not already attached
266: bsc_aw_dbms_aw.execute('aw detach '||p_workspace);
267: bsc_aw_utility.remove_sqlerror(-34344,'ignore');
268: end if;
269: g_attached:=false;
270: g_attached_mode:=null;

Line 302: bsc_aw_dbms_aw.execute('commit');

298: procedure commit_aw(p_options varchar2) is
299: Begin
300: if g_locked_objects.count>0 then --10g
301: commit_aw_multi;
302: bsc_aw_dbms_aw.execute('commit');
303: if not(nvl(bsc_aw_utility.get_parameter_value(p_options,'no release lock',','),'N')='Y') then
304: for i in 1..g_locked_objects.count loop
305: release_lock(g_locked_objects(i));
306: end loop;

Line 312: bsc_aw_dbms_aw.execute('commit');

308: end if;
309: else
310: update_aw;
311: end if;
312: bsc_aw_dbms_aw.execute('commit');
313: Exception when others then
314: log_n('Exception in commit_aw '||sqlerrm);
315: raise;
316: End;

Line 346: bsc_aw_dbms_aw.execute('commit');

342: for i in 1..p_locked_objects.count loop
343: bsc_aw_utility.remove_array_element(g_locked_objects,p_locked_objects(i));
344: end loop;
345: end if;
346: bsc_aw_dbms_aw.execute('commit');
347: Exception when others then
348: log_n('Exception in commit_aw '||sqlerrm);
349: raise;
350: End;

Line 388: bsc_aw_dbms_aw.execute(l_update_stmt);

384: end if;
385: end loop;
386: end if;
387: if l_multi_update then
388: bsc_aw_dbms_aw.execute(l_update_stmt);
389: else
390: update_aw;
391: end if;
392: Exception when others then

Line 418: bsc_aw_dbms_aw.execute('aw create '||p_name);

414: bsc_aw_utility.g_options.delete;
415: bsc_aw_utility.parse_parameter_values(p_options,',',bsc_aw_utility.g_options);
416: l_tablespace:=bsc_aw_utility.get_parameter_value(bsc_aw_utility.g_options,'TABLESPACE');
417: if l_tablespace is null then
418: bsc_aw_dbms_aw.execute('aw create '||p_name);
419: else
420: bsc_aw_dbms_aw.execute('aw create '||p_name||' tablespace '||l_tablespace);
421: end if;
422: l_segmentsize:=bsc_aw_utility.get_parameter_value(bsc_aw_utility.g_options,'SEGMENTSIZE');

Line 420: bsc_aw_dbms_aw.execute('aw create '||p_name||' tablespace '||l_tablespace);

416: l_tablespace:=bsc_aw_utility.get_parameter_value(bsc_aw_utility.g_options,'TABLESPACE');
417: if l_tablespace is null then
418: bsc_aw_dbms_aw.execute('aw create '||p_name);
419: else
420: bsc_aw_dbms_aw.execute('aw create '||p_name||' tablespace '||l_tablespace);
421: end if;
422: l_segmentsize:=bsc_aw_utility.get_parameter_value(bsc_aw_utility.g_options,'SEGMENTSIZE');
423: if l_segmentsize is not null then
424: bsc_aw_dbms_aw.execute('aw SEGMENTSIZE '||l_segmentsize||' '||p_name);

Line 424: bsc_aw_dbms_aw.execute('aw SEGMENTSIZE '||l_segmentsize||' '||p_name);

420: bsc_aw_dbms_aw.execute('aw create '||p_name||' tablespace '||l_tablespace);
421: end if;
422: l_segmentsize:=bsc_aw_utility.get_parameter_value(bsc_aw_utility.g_options,'SEGMENTSIZE');
423: if l_segmentsize is not null then
424: bsc_aw_dbms_aw.execute('aw SEGMENTSIZE '||l_segmentsize||' '||p_name);
425: bsc_aw_dbms_aw.execute('aw ALLOCATE '||l_segmentsize||' '||p_name);
426: end if;
427: create_default_elements;
428: --make the LOB nologging. this is the suggestion of the AW team as per Vladimir

Line 425: bsc_aw_dbms_aw.execute('aw ALLOCATE '||l_segmentsize||' '||p_name);

421: end if;
422: l_segmentsize:=bsc_aw_utility.get_parameter_value(bsc_aw_utility.g_options,'SEGMENTSIZE');
423: if l_segmentsize is not null then
424: bsc_aw_dbms_aw.execute('aw SEGMENTSIZE '||l_segmentsize||' '||p_name);
425: bsc_aw_dbms_aw.execute('aw ALLOCATE '||l_segmentsize||' '||p_name);
426: end if;
427: create_default_elements;
428: --make the LOB nologging. this is the suggestion of the AW team as per Vladimir
429: bsc_aw_utility.execute_stmt_ne('ALTER TABLE aw$'||p_name||' MODIFY LOB(awlob) (PCTVERSION 0 CACHE READS NOLOGGING)');

Line 455: bsc_aw_dbms_aw.execute('aw detach '||p_name);

451: --
452: procedure drop_workspace(p_name varchar2,p_options varchar2) is
453: Begin
454: attach_workspace(p_name,'rw');
455: bsc_aw_dbms_aw.execute('aw detach '||p_name);
456: bsc_aw_dbms_aw.execute('aw delete '||p_name);
457: g_attached:=false;
458: g_attached_mode:=null;
459: bsc_aw_md_api.drop_workspace(p_name);

Line 456: bsc_aw_dbms_aw.execute('aw delete '||p_name);

452: procedure drop_workspace(p_name varchar2,p_options varchar2) is
453: Begin
454: attach_workspace(p_name,'rw');
455: bsc_aw_dbms_aw.execute('aw detach '||p_name);
456: bsc_aw_dbms_aw.execute('aw delete '||p_name);
457: g_attached:=false;
458: g_attached_mode:=null;
459: bsc_aw_md_api.drop_workspace(p_name);
460: Exception when others then

Line 471: --bsc_aw_dbms_aw.execute('SORTCOMPOSITE=FALSE');

467: End;
468:
469: procedure exec_workspace_settings is
470: Begin
471: --bsc_aw_dbms_aw.execute('SORTCOMPOSITE=FALSE');
472: bsc_aw_dbms_aw.execute('MULTIPATHHIER=TRUE');
473: bsc_aw_dbms_aw.execute('NASKIP=TRUE');
474: bsc_aw_dbms_aw.execute('NASKIP2=TRUE');
475: bsc_aw_dbms_aw.execute('DIVIDEBYZERO=TRUE');

Line 472: bsc_aw_dbms_aw.execute('MULTIPATHHIER=TRUE');

468:
469: procedure exec_workspace_settings is
470: Begin
471: --bsc_aw_dbms_aw.execute('SORTCOMPOSITE=FALSE');
472: bsc_aw_dbms_aw.execute('MULTIPATHHIER=TRUE');
473: bsc_aw_dbms_aw.execute('NASKIP=TRUE');
474: bsc_aw_dbms_aw.execute('NASKIP2=TRUE');
475: bsc_aw_dbms_aw.execute('DIVIDEBYZERO=TRUE');
476: bsc_aw_dbms_aw.execute('OKNULLSTATUS=TRUE');

Line 473: bsc_aw_dbms_aw.execute('NASKIP=TRUE');

469: procedure exec_workspace_settings is
470: Begin
471: --bsc_aw_dbms_aw.execute('SORTCOMPOSITE=FALSE');
472: bsc_aw_dbms_aw.execute('MULTIPATHHIER=TRUE');
473: bsc_aw_dbms_aw.execute('NASKIP=TRUE');
474: bsc_aw_dbms_aw.execute('NASKIP2=TRUE');
475: bsc_aw_dbms_aw.execute('DIVIDEBYZERO=TRUE');
476: bsc_aw_dbms_aw.execute('OKNULLSTATUS=TRUE');
477: bsc_aw_dbms_aw.execute('LIMIT.SORTREL=FALSE');

Line 474: bsc_aw_dbms_aw.execute('NASKIP2=TRUE');

470: Begin
471: --bsc_aw_dbms_aw.execute('SORTCOMPOSITE=FALSE');
472: bsc_aw_dbms_aw.execute('MULTIPATHHIER=TRUE');
473: bsc_aw_dbms_aw.execute('NASKIP=TRUE');
474: bsc_aw_dbms_aw.execute('NASKIP2=TRUE');
475: bsc_aw_dbms_aw.execute('DIVIDEBYZERO=TRUE');
476: bsc_aw_dbms_aw.execute('OKNULLSTATUS=TRUE');
477: bsc_aw_dbms_aw.execute('LIMIT.SORTREL=FALSE');
478: bsc_aw_dbms_aw.execute('COMMAS=FALSE');

Line 475: bsc_aw_dbms_aw.execute('DIVIDEBYZERO=TRUE');

471: --bsc_aw_dbms_aw.execute('SORTCOMPOSITE=FALSE');
472: bsc_aw_dbms_aw.execute('MULTIPATHHIER=TRUE');
473: bsc_aw_dbms_aw.execute('NASKIP=TRUE');
474: bsc_aw_dbms_aw.execute('NASKIP2=TRUE');
475: bsc_aw_dbms_aw.execute('DIVIDEBYZERO=TRUE');
476: bsc_aw_dbms_aw.execute('OKNULLSTATUS=TRUE');
477: bsc_aw_dbms_aw.execute('LIMIT.SORTREL=FALSE');
478: bsc_aw_dbms_aw.execute('COMMAS=FALSE');
479: bsc_aw_dbms_aw.execute('AWWAITTIME='||bsc_aw_utility.g_max_wait_time);

Line 476: bsc_aw_dbms_aw.execute('OKNULLSTATUS=TRUE');

472: bsc_aw_dbms_aw.execute('MULTIPATHHIER=TRUE');
473: bsc_aw_dbms_aw.execute('NASKIP=TRUE');
474: bsc_aw_dbms_aw.execute('NASKIP2=TRUE');
475: bsc_aw_dbms_aw.execute('DIVIDEBYZERO=TRUE');
476: bsc_aw_dbms_aw.execute('OKNULLSTATUS=TRUE');
477: bsc_aw_dbms_aw.execute('LIMIT.SORTREL=FALSE');
478: bsc_aw_dbms_aw.execute('COMMAS=FALSE');
479: bsc_aw_dbms_aw.execute('AWWAITTIME='||bsc_aw_utility.g_max_wait_time);
480: Exception when others then

Line 477: bsc_aw_dbms_aw.execute('LIMIT.SORTREL=FALSE');

473: bsc_aw_dbms_aw.execute('NASKIP=TRUE');
474: bsc_aw_dbms_aw.execute('NASKIP2=TRUE');
475: bsc_aw_dbms_aw.execute('DIVIDEBYZERO=TRUE');
476: bsc_aw_dbms_aw.execute('OKNULLSTATUS=TRUE');
477: bsc_aw_dbms_aw.execute('LIMIT.SORTREL=FALSE');
478: bsc_aw_dbms_aw.execute('COMMAS=FALSE');
479: bsc_aw_dbms_aw.execute('AWWAITTIME='||bsc_aw_utility.g_max_wait_time);
480: Exception when others then
481: log_n('Exception in exec_workspace_settings '||sqlerrm);

Line 478: bsc_aw_dbms_aw.execute('COMMAS=FALSE');

474: bsc_aw_dbms_aw.execute('NASKIP2=TRUE');
475: bsc_aw_dbms_aw.execute('DIVIDEBYZERO=TRUE');
476: bsc_aw_dbms_aw.execute('OKNULLSTATUS=TRUE');
477: bsc_aw_dbms_aw.execute('LIMIT.SORTREL=FALSE');
478: bsc_aw_dbms_aw.execute('COMMAS=FALSE');
479: bsc_aw_dbms_aw.execute('AWWAITTIME='||bsc_aw_utility.g_max_wait_time);
480: Exception when others then
481: log_n('Exception in exec_workspace_settings '||sqlerrm);
482: raise;

Line 479: bsc_aw_dbms_aw.execute('AWWAITTIME='||bsc_aw_utility.g_max_wait_time);

475: bsc_aw_dbms_aw.execute('DIVIDEBYZERO=TRUE');
476: bsc_aw_dbms_aw.execute('OKNULLSTATUS=TRUE');
477: bsc_aw_dbms_aw.execute('LIMIT.SORTREL=FALSE');
478: bsc_aw_dbms_aw.execute('COMMAS=FALSE');
479: bsc_aw_dbms_aw.execute('AWWAITTIME='||bsc_aw_utility.g_max_wait_time);
480: Exception when others then
481: log_n('Exception in exec_workspace_settings '||sqlerrm);
482: raise;
483: End;

Line 495: bsc_aw_dbms_aw.execute_ne('define temp_text text');

491: End;
492:
493: procedure create_default_elements is
494: Begin
495: bsc_aw_dbms_aw.execute_ne('define temp_text text');
496: bsc_aw_dbms_aw.execute_ne('define temp_number number');
497: bsc_aw_dbms_aw.execute_ne('define temp_decimal decimal');
498: bsc_aw_dbms_aw.execute_ne('define temp_integer integer');
499: set_hash_partition_dim;

Line 496: bsc_aw_dbms_aw.execute_ne('define temp_number number');

492:
493: procedure create_default_elements is
494: Begin
495: bsc_aw_dbms_aw.execute_ne('define temp_text text');
496: bsc_aw_dbms_aw.execute_ne('define temp_number number');
497: bsc_aw_dbms_aw.execute_ne('define temp_decimal decimal');
498: bsc_aw_dbms_aw.execute_ne('define temp_integer integer');
499: set_hash_partition_dim;
500: Exception when others then

Line 497: bsc_aw_dbms_aw.execute_ne('define temp_decimal decimal');

493: procedure create_default_elements is
494: Begin
495: bsc_aw_dbms_aw.execute_ne('define temp_text text');
496: bsc_aw_dbms_aw.execute_ne('define temp_number number');
497: bsc_aw_dbms_aw.execute_ne('define temp_decimal decimal');
498: bsc_aw_dbms_aw.execute_ne('define temp_integer integer');
499: set_hash_partition_dim;
500: Exception when others then
501: log_n('Exception in create_default_elements '||sqlerrm);

Line 498: bsc_aw_dbms_aw.execute_ne('define temp_integer integer');

494: Begin
495: bsc_aw_dbms_aw.execute_ne('define temp_text text');
496: bsc_aw_dbms_aw.execute_ne('define temp_number number');
497: bsc_aw_dbms_aw.execute_ne('define temp_decimal decimal');
498: bsc_aw_dbms_aw.execute_ne('define temp_integer integer');
499: set_hash_partition_dim;
500: Exception when others then
501: log_n('Exception in create_default_elements '||sqlerrm);
502: raise;

Line 509: bsc_aw_dbms_aw.execute_ne('dfn HASH_PARTITION_DIM dimension number(4)');

505: procedure set_hash_partition_dim is
506: l_cpu_count number;
507: Begin
508: l_cpu_count:=bsc_aw_utility.get_cpu_count;
509: bsc_aw_dbms_aw.execute_ne('dfn HASH_PARTITION_DIM dimension number(4)');
510: for i in 0..l_cpu_count-1 loop
511: bsc_aw_dbms_aw.execute('mnt HASH_PARTITION_DIM merge '||i);
512: end loop;
513: Exception when others then

Line 511: bsc_aw_dbms_aw.execute('mnt HASH_PARTITION_DIM merge '||i);

507: Begin
508: l_cpu_count:=bsc_aw_utility.get_cpu_count;
509: bsc_aw_dbms_aw.execute_ne('dfn HASH_PARTITION_DIM dimension number(4)');
510: for i in 0..l_cpu_count-1 loop
511: bsc_aw_dbms_aw.execute('mnt HASH_PARTITION_DIM merge '||i);
512: end loop;
513: Exception when others then
514: log_n('Exception in set_hash_partition_dim '||sqlerrm);
515: raise;

Line 565: bsc_aw_dbms_aw.execute('update');

561:
562: procedure update_aw is
563: Begin
564: bsc_aw_utility.add_sqlerror(-34684,'ignore',null);--ignore if the ws is not alreay attached and there are no objects to update
565: bsc_aw_dbms_aw.execute('update');
566: bsc_aw_utility.remove_sqlerror(-34684,'ignore');
567: Exception when others then
568: log_n('Exception in update_aw '||sqlerrm);
569: raise;