APPS.BSC_AW_LOAD dependencies on DBMS_SQL

Line 8: p_dim_level_list dbms_sql.varchar2_table,

4: g_debug boolean;
5: g_stmt varchar2(32000);
6: --procedures-------------------------------------------------------
7: procedure load_dim(
8: p_dim_level_list dbms_sql.varchar2_table,
9: p_options varchar2
10: );
11: procedure load_kpi(
12: p_kpi_list dbms_sql.varchar2_table,

Line 12: p_kpi_list dbms_sql.varchar2_table,

8: p_dim_level_list dbms_sql.varchar2_table,
9: p_options varchar2
10: );
11: procedure load_kpi(
12: p_kpi_list dbms_sql.varchar2_table,
13: p_options varchar2
14: );
15: procedure load_base_table(
16: p_base_table_list dbms_sql.varchar2_table,

Line 16: p_base_table_list dbms_sql.varchar2_table,

12: p_kpi_list dbms_sql.varchar2_table,
13: p_options varchar2
14: );
15: procedure load_base_table(
16: p_base_table_list dbms_sql.varchar2_table,
17: p_kpi_list dbms_sql.varchar2_table,
18: p_options varchar2
19: );
20: procedure purge_kpi(p_kpi varchar2,p_options varchar2);

Line 17: p_kpi_list dbms_sql.varchar2_table,

13: p_options varchar2
14: );
15: procedure load_base_table(
16: p_base_table_list dbms_sql.varchar2_table,
17: p_kpi_list dbms_sql.varchar2_table,
18: p_options varchar2
19: );
20: procedure purge_kpi(p_kpi varchar2,p_options varchar2);
21: procedure purge_dim(

Line 22: p_dim_level_list dbms_sql.varchar2_table,

18: p_options varchar2
19: );
20: procedure purge_kpi(p_kpi varchar2,p_options varchar2);
21: procedure purge_dim(
22: p_dim_level_list dbms_sql.varchar2_table,
23: p_options varchar2
24: );
25: procedure dmp_dim_level_into_table(
26: p_dim_level_list dbms_sql.varchar2_table,

Line 26: p_dim_level_list dbms_sql.varchar2_table,

22: p_dim_level_list dbms_sql.varchar2_table,
23: p_options varchar2
24: );
25: procedure dmp_dim_level_into_table(
26: p_dim_level_list dbms_sql.varchar2_table,
27: p_options varchar2
28: ) ;
29: procedure dmp_kpi_cubes_into_table(
30: p_kpi varchar2,

Line 32: p_dim_levels dbms_sql.varchar2_table,

28: ) ;
29: procedure dmp_kpi_cubes_into_table(
30: p_kpi varchar2,
31: p_dimset varchar2,
32: p_dim_levels dbms_sql.varchar2_table,
33: p_table_name varchar2,
34: p_options varchar2);
35: procedure dmp_kpi_cubes_into_table(
36: p_kpi varchar2,

Line 39: p_tables out nocopy dbms_sql.varchar2_table

35: procedure dmp_kpi_cubes_into_table(
36: p_kpi varchar2,
37: p_table_name varchar2,
38: p_options varchar2,
39: p_tables out nocopy dbms_sql.varchar2_table
40: );
41: procedure init_bt_change_vector(p_base_table varchar2);
42: function get_bt_next_change_vector(p_base_table varchar2) return number;
43: procedure update_bt_change_vector(p_base_table varchar2, p_value number);