APPS.BSC_AW_UTILITY dependencies on BSC_AW_DBMS_AW

Line 252: bsc_aw_dbms_aw.execute('delete '||p_object);

248:
249: procedure delete_aw_object(p_object varchar2) is
250: Begin
251: if p_object is not null then
252: bsc_aw_dbms_aw.execute('delete '||p_object);
253: end if;
254: Exception when others then
255: null;--may try to delete an object that does not exist
256: End;

Line 413: bsc_aw_dbms_aw.execute_ne('delete '||p_program);

409: procedure exec_program_commands(p_program varchar2,p_commands dbms_sql.varchar2_table) is
410: Begin
411: --the first stmt is 'dfn abc program' this does not have "joinlines"
412: --first try and drop the programs if it exists.
413: bsc_aw_dbms_aw.execute_ne('delete '||p_program);
414: exec_aw_program_aggmap(p_program,p_commands,'program');
415: bsc_aw_dbms_aw.execute('compile '||p_program);
416: Exception when others then
417: log('Exception in exec_program_commands '||sqlerrm);

Line 415: bsc_aw_dbms_aw.execute('compile '||p_program);

411: --the first stmt is 'dfn abc program' this does not have "joinlines"
412: --first try and drop the programs if it exists.
413: bsc_aw_dbms_aw.execute_ne('delete '||p_program);
414: exec_aw_program_aggmap(p_program,p_commands,'program');
415: bsc_aw_dbms_aw.execute('compile '||p_program);
416: Exception when others then
417: log('Exception in exec_program_commands '||sqlerrm);
418: raise;
419: End;

Line 424: bsc_aw_dbms_aw.execute_ne('delete '||p_aggmap);

420:
421: procedure exec_aggmap_commands(p_aggmap varchar2,p_commands dbms_sql.varchar2_table) is
422: Begin
423: --the first stmt is 'dfn abc program' this does not have "joinlines"
424: bsc_aw_dbms_aw.execute_ne('delete '||p_aggmap);
425: exec_aw_program_aggmap(p_aggmap,p_commands,'aggmap');
426: bsc_aw_dbms_aw.execute('compile '||p_aggmap);
427: Exception when others then
428: log('Exception in exec_aggmap_commands '||sqlerrm);

Line 426: bsc_aw_dbms_aw.execute('compile '||p_aggmap);

422: Begin
423: --the first stmt is 'dfn abc program' this does not have "joinlines"
424: bsc_aw_dbms_aw.execute_ne('delete '||p_aggmap);
425: exec_aw_program_aggmap(p_aggmap,p_commands,'aggmap');
426: bsc_aw_dbms_aw.execute('compile '||p_aggmap);
427: Exception when others then
428: log('Exception in exec_aggmap_commands '||sqlerrm);
429: raise;
430: End;

Line 436: bsc_aw_dbms_aw.execute(p_commands(1));

432: --p_type is 'program' or 'aggmap'
433: procedure exec_aw_program_aggmap(p_name varchar2,p_commands dbms_sql.varchar2_table,p_type varchar2) is
434: l_commands varchar2(8000);
435: Begin
436: bsc_aw_dbms_aw.execute(p_commands(1));
437: for i in 2..p_commands.count loop
438: l_commands:=p_commands(i);
439: make_stmt_for_aw(p_name,l_commands,p_type);
440: bsc_aw_dbms_aw.execute(l_commands);

Line 440: bsc_aw_dbms_aw.execute(l_commands);

436: bsc_aw_dbms_aw.execute(p_commands(1));
437: for i in 2..p_commands.count loop
438: l_commands:=p_commands(i);
439: make_stmt_for_aw(p_name,l_commands,p_type);
440: bsc_aw_dbms_aw.execute(l_commands);
441: end loop;
442: Exception when others then
443: log('Exception in exec_aw_program_aggmap '||sqlerrm);
444: raise;

Line 886: bsc_aw_dbms_aw.init_all;

882: bsc_aw_bsc_metadata.init_all;
883: bsc_metadata.init_all;
884: bsc_aw_load_dim.init_all;
885: bsc_aw_load_kpi.init_all;
886: bsc_aw_dbms_aw.init_all;
887: bsc_aw_md_api.init_all;
888: bsc_aw_md_wrapper.init_all;
889: bsc_aw_management.init_all;
890: bsc_aw_calendar.init_all;

Line 1774: bsc_aw_dbms_aw.execute('dotf tracefile');

1770: if g_trace_set is null or g_trace_set=false then
1771: execute immediate 'alter session set sql_trace=true';
1772: execute immediate 'alter session set events=''10046 trace name context forever, level 12''';
1773: execute immediate 'alter session set events=''37395 trace name context forever, level 1''';
1774: bsc_aw_dbms_aw.execute('dotf tracefile');
1775: g_trace_set:=true;
1776: end if;
1777: Exception when others then
1778: log_n('Exception in set_aw_trace '||sqlerrm);