DBA Data[Home] [Help]

APPS.BSC_AW_MANAGEMENT dependencies on BSC_AW_MD_API

Line 65: if bsc_aw_md_api.check_workspace(l_name)='N' then

61: Begin
62: bsc_aw_utility.add_option(p_options,null,',');
63: l_name:=get_aw_workspace_name;
64: if nvl(bsc_aw_utility.get_parameter_value(p_options,'create workspace',','),'N')='Y' then
65: if bsc_aw_md_api.check_workspace(l_name)='N' then
66: create_workspace(p_options);
67: end if;
68: end if;
69: l_nowait:=nvl(bsc_aw_utility.get_parameter_value(p_options,'nowait',','),'N');

Line 430: bsc_aw_md_api.create_workspace(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)');
430: bsc_aw_md_api.create_workspace(p_name);
431: bsc_aw_md_api.set_upgrade_version(bsc_aw_utility.g_upgrade_version);
432: Exception when others then
433: if sqlcode=-33270 then
434: log_n('Workspace '||p_name||' already exists');

Line 431: bsc_aw_md_api.set_upgrade_version(bsc_aw_utility.g_upgrade_version);

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)');
430: bsc_aw_md_api.create_workspace(p_name);
431: bsc_aw_md_api.set_upgrade_version(bsc_aw_utility.g_upgrade_version);
432: Exception when others then
433: if sqlcode=-33270 then
434: log_n('Workspace '||p_name||' already exists');
435: else

Line 459: bsc_aw_md_api.drop_workspace(p_name);

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
461: if sqlcode=-33262 then
462: log_n('workspace '||p_name||' does not exist');
463: else