APPS.BSC_AW_ADAPTER dependencies on DBMS_SQL

Line 17: p_kpi_list dbms_sql.varchar2_table,

13: TABLESPACE : which tablespace to create aw workspace
14: SEGMENTSIZE : segment size to use
15: */
16: procedure implement_kpi_aw(
17: p_kpi_list dbms_sql.varchar2_table,
18: p_options varchar2
19: ) is
20: --
21: l_affected_kpi dbms_sql.varchar2_table;

Line 21: l_affected_kpi dbms_sql.varchar2_table;

17: p_kpi_list dbms_sql.varchar2_table,
18: p_options varchar2
19: ) is
20: --
21: l_affected_kpi dbms_sql.varchar2_table;
22: Begin
23: implement_kpi_aw(p_kpi_list,p_options,l_affected_kpi);
24: Exception when others then
25: log_n('Exception in implement_kpi_aw '||sqlerrm);

Line 30: p_kpi_list dbms_sql.varchar2_table,

26: raise;
27: End;
28:
29: procedure implement_kpi_aw(
30: p_kpi_list dbms_sql.varchar2_table,
31: p_options varchar2,
32: p_affected_kpi out nocopy dbms_sql.varchar2_table
33: ) is
34: l_options varchar2(8000);

Line 32: p_affected_kpi out nocopy dbms_sql.varchar2_table

28:
29: procedure implement_kpi_aw(
30: p_kpi_list dbms_sql.varchar2_table,
31: p_options varchar2,
32: p_affected_kpi out nocopy dbms_sql.varchar2_table
33: ) is
34: l_options varchar2(8000);
35: Begin
36: l_options:='create workspace,'||p_options;

Line 53: p_kpi_list dbms_sql.varchar2_table,

49: raise;
50: End;
51:
52: procedure implement_kpi_aw(
53: p_kpi_list dbms_sql.varchar2_table,
54: p_affected_kpi out nocopy dbms_sql.varchar2_table
55: ) is
56: --
57: l_dim_list dbms_sql.varchar2_table;

Line 54: p_affected_kpi out nocopy dbms_sql.varchar2_table

50: End;
51:
52: procedure implement_kpi_aw(
53: p_kpi_list dbms_sql.varchar2_table,
54: p_affected_kpi out nocopy dbms_sql.varchar2_table
55: ) is
56: --
57: l_dim_list dbms_sql.varchar2_table;
58: l_calendar number;

Line 57: l_dim_list dbms_sql.varchar2_table;

53: p_kpi_list dbms_sql.varchar2_table,
54: p_affected_kpi out nocopy dbms_sql.varchar2_table
55: ) is
56: --
57: l_dim_list dbms_sql.varchar2_table;
58: l_calendar number;
59: l_affected_kpi dbms_sql.varchar2_table;
60: l_calendar_processed dbms_sql.number_table;
61: Begin

Line 59: l_affected_kpi dbms_sql.varchar2_table;

55: ) is
56: --
57: l_dim_list dbms_sql.varchar2_table;
58: l_calendar number;
59: l_affected_kpi dbms_sql.varchar2_table;
60: l_calendar_processed dbms_sql.number_table;
61: Begin
62: --drop the kpi that are going to be processed
63: drop_kpi(p_kpi_list);

Line 60: l_calendar_processed dbms_sql.number_table;

56: --
57: l_dim_list dbms_sql.varchar2_table;
58: l_calendar number;
59: l_affected_kpi dbms_sql.varchar2_table;
60: l_calendar_processed dbms_sql.number_table;
61: Begin
62: --drop the kpi that are going to be processed
63: drop_kpi(p_kpi_list);
64: --for the list of kpi, get the dim list...then call the dim adapter

Line 99: procedure drop_kpi(p_kpi_list dbms_sql.varchar2_table,p_options varchar2) is

95: when we drop kpi, we must also process the dim. we can have a case like
96: city,state, country. one kpi on all three. this kpi is dropped. we have to correct the existing dim to city
97: state. if the kpi is dropped and we do not correct the dim, we can have issues later when country is deleted.
98: */
99: procedure drop_kpi(p_kpi_list dbms_sql.varchar2_table,p_options varchar2) is
100: --
101: l_dim_list dbms_sql.varchar2_table;
102: Begin
103: set_up(p_options);

Line 101: l_dim_list dbms_sql.varchar2_table;

97: state. if the kpi is dropped and we do not correct the dim, we can have issues later when country is deleted.
98: */
99: procedure drop_kpi(p_kpi_list dbms_sql.varchar2_table,p_options varchar2) is
100: --
101: l_dim_list dbms_sql.varchar2_table;
102: Begin
103: set_up(p_options);
104: bsc_aw_management.get_workspace_lock('rw',p_options);
105: bsc_aw_bsc_metadata.get_dims_for_kpis(p_kpi_list,l_dim_list);

Line 118: procedure drop_kpi(p_kpi_list dbms_sql.varchar2_table) is

114: log_n('Exception in drop_kpi '||sqlerrm);
115: raise;
116: End;
117:
118: procedure drop_kpi(p_kpi_list dbms_sql.varchar2_table) is
119: Begin
120: for i in 1..p_kpi_list.count loop
121: bsc_aw_adapter_kpi.drop_kpi_objects(p_kpi_list(i));
122: end loop;

Line 132: p_dim_level_list dbms_sql.varchar2_table,

128: /*
129: this procedure lets anyone create a dim or recreate a dim
130: */
131: procedure create_dim(
132: p_dim_level_list dbms_sql.varchar2_table,
133: p_options varchar2
134: ) is
135: l_options varchar2(8000);
136: Begin