APPS.BSC_AW_LOAD dependencies on DBMS_SQL

Line 12: p_dim_level_list dbms_sql.varchar2_table,

8: /*
9: load dim handles aw dim loads. input to this procedure is a list of dim and options
10: */
11: procedure load_dim(
12: p_dim_level_list dbms_sql.varchar2_table,
13: p_options varchar2
14: ) is
15: Begin
16: bsc_aw_utility.g_options.delete;

Line 39: p_dim_level_list dbms_sql.varchar2_table,

35: NOTE!!! when dim is purged, all related kpi are completely purged. if a dim is to be removed from a kpi, the kpi has
36: to be recreated. so if a dim is purged, data in the kpi makes no sense anymore
37: */
38: procedure purge_dim(
39: p_dim_level_list dbms_sql.varchar2_table,
40: p_options varchar2
41: ) is
42: Begin
43: bsc_aw_utility.g_options.delete;

Line 66: p_dim_level_list dbms_sql.varchar2_table,

62: this creates the program on the fly, executes it and drops the program
63: NO COMMIT!!!
64: */
65: procedure dmp_dim_level_into_table(
66: p_dim_level_list dbms_sql.varchar2_table,
67: p_options varchar2
68: ) is
69: Begin
70: bsc_aw_utility.g_options.delete;

Line 92: p_kpi_list dbms_sql.varchar2_table,

88: 2 load base table and kpi associated with them
89: */
90:
91: procedure load_kpi(
92: p_kpi_list dbms_sql.varchar2_table,
93: p_options varchar2
94: ) is
95: Begin
96: bsc_aw_utility.g_options.delete;

Line 118: p_base_table_list dbms_sql.varchar2_table,

114: BSC_B_1 4000
115: BSC_B_2 3014
116: */
117: procedure load_base_table(
118: p_base_table_list dbms_sql.varchar2_table,
119: p_kpi_list dbms_sql.varchar2_table,
120: p_options varchar2
121: ) is
122: Begin

Line 119: p_kpi_list dbms_sql.varchar2_table,

115: BSC_B_2 3014
116: */
117: procedure load_base_table(
118: p_base_table_list dbms_sql.varchar2_table,
119: p_kpi_list dbms_sql.varchar2_table,
120: p_options varchar2
121: ) is
122: Begin
123: bsc_aw_utility.g_options.delete;

Line 162: p_tables out nocopy dbms_sql.varchar2_table

158: procedure dmp_kpi_cubes_into_table(
159: p_kpi varchar2,
160: p_table_name varchar2,
161: p_options varchar2,
162: p_tables out nocopy dbms_sql.varchar2_table
163: ) is
164: Begin
165: bsc_aw_utility.g_options.delete;
166: bsc_aw_utility.parse_parameter_values(p_options,',',bsc_aw_utility.g_options);

Line 184: p_dim_levels dbms_sql.varchar2_table,

180:
181: procedure dmp_kpi_cubes_into_table(
182: p_kpi varchar2,
183: p_dimset varchar2,
184: p_dim_levels dbms_sql.varchar2_table,
185: p_table_name varchar2,
186: p_options varchar2) is
187: Begin
188: bsc_aw_utility.g_options.delete;