PACKAGE: APPS.BSC_AW_LOAD

Source

1 package BSC_AW_LOAD AS
2 /*$Header: BSCAWLOS.pls 120.3 2006/01/14 20:48 vsurendr noship $*/
3 --program runtime parameters
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,
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(
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,
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,
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);
44 procedure drop_bt_change_vector(p_base_table varchar2);
45 procedure update_bt_current_period(p_base_table varchar2,p_period number,p_year number);
46 --procedures-------------------------------------------------------
47 procedure init_all;
48 procedure log(p_message varchar2);
49 procedure log_n(p_message varchar2);
50 -------------------------------------------------------------------
51 
52 END BSC_AW_LOAD;