PACKAGE: APPS.BSC_DBGEN_UTILS

Source

1 Package BSC_DBGEN_UTILS AS
2 /* $Header: BSCDBUTS.pls 120.6 2006/01/11 13:47 arsantha noship $ */
3 g_apps_schema VARCHAR2(100);
4 g_bsc_schema VARCHAR2(100);
5 g_ak_schema VARCHAR2(100);
6 FUNCTION get_bsc_schema return varchar2;
7 Function get_apps_schema  RETURN VARCHAR2;
8 FUNCTION get_measure_list(p_expression IN VARCHAR2) RETURN dbms_sql.varchar2_table ;
9 Function get_kpi_property_value(
10     p_kpi IN NUMBER,
11 	p_property IN VARCHAR2,
12 	p_default IN NUMBER)
13 	return NUMBER;
14 Function Get_New_Big_In_Cond_Number( x_variable_id IN NUMBER, x_column_name IN VARCHAR2) return VARCHAR2;
15 PROCEDURE Add_Value_Big_In_Cond_Number(x_variable_id IN NUMBER, x_value IN NUMBER) ;
16 Function Get_New_Big_In_Cond_Varchar2( x_variable_id in number, x_column_name in varchar2) return VARCHAR2 ;
17 PROCEDURE Add_Value_Big_In_Cond_Varchar2(x_variable_id IN NUMBER, x_value IN VARCHAR2);
18 FUNCTION get_datatype(p_table_name in varchar2, p_column_name in varchar2) return VARCHAR2;
19 PROCEDURE add_property(p_properties in out NOCOPY BSC_DBGEN_STD_METADATA.tab_ClsProperties, p_name in varchar2, p_value in varchar2);
20 PROCEDURE add_property(p_properties in out NOCOPY BSC_DBGEN_STD_METADATA.tab_ClsProperties, p_name in varchar2, p_value in number);
21 FUNCTION get_property_value(p_properties IN BSC_DBGEN_STD_METADATA.tab_ClsProperties, p_name in varchar2) return VARCHAR2;
22 FUNCTION get_source_table_names(p_table_name IN VARCHAR2) RETURN DBMS_SQL.VARCHAR2_TABLE;
23 
24 FUNCTION parse_value(p_string IN VARCHAR2, p_property_name IN VARCHAR2, p_assignment_operator IN VARCHAR2, p_pre_separator IN VARCHAR2, p_post_separator IN VARCHAR2) return varchar2;
25 
26 --Return I, B, S, T, D or DI
27 FUNCTION get_table_type(p_table_name IN VARCHAR2) RETURN VARCHAR2;
28 FUNCTION get_mvlog_for_table(p_table_name IN VARCHAR2) RETURN VARCHAR2;
29 FUNCTION get_Objective_Type (p_Short_Name IN VARCHAR2) RETURN VARCHAR2;
30 FUNCTION get_char_chunks(p_msg IN VARCHAR2, p_chunk_size IN NUMBER default 256) return DBMS_SQL.VARCHAR2_TABLE;
31 PROCEDURE init;
32 g_initialized boolean :=false;
33 Function get_objective_type_for_b_table(p_b_table_name IN VARCHAR2) return  VARCHAR2 ;
34 FUNCTION IS_TMP_TABLE_EXISTED(Table_Name IN VARCHAR2) RETURN BOOLEAN;
35 
36 FUNCTION table_exists(p_table_name IN VARCHAR2) return BOOLEAN;
37 FUNCTION get_table_owner(p_table_name VARCHAR2) RETURN VARCHAR2;
38 
39 PROCEDURE drop_table(p_table_name IN VARCHAR2);
40 
41 PROCEDURE add_string(p_varchar2_table IN OUT nocopy DBMS_SQL.VARCHAR2A, p_string IN VARCHAR2);
42 PROCEDURE execute_immediate(p_varchar2_table IN DBMS_SQL.VARCHAR2A);
43 PROCEDURE execute_immediate(p_varchar2_table IN DBMS_SQL.VARCHAR2A, p_bind_vars_values dbms_sql.varchar2_table, p_num_bind_vars number);
44 
45 
46 END BSC_DBGEN_UTILS;