APPS.BSC_DBGEN_UTILS dependencies on DBMS_SQL

Line 8: FUNCTION get_measure_list(p_expression IN VARCHAR2) RETURN dbms_sql.varchar2_table ;

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)

Line 22: FUNCTION get_source_table_names(p_table_name IN VARCHAR2) RETURN DBMS_SQL.VARCHAR2_TABLE;

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

Line 30: FUNCTION get_char_chunks(p_msg IN VARCHAR2, p_chunk_size IN NUMBER default 256) return DBMS_SQL.VARCHAR2_TABLE;

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;

Line 41: PROCEDURE add_string(p_varchar2_table IN OUT nocopy DBMS_SQL.VARCHAR2A, p_string IN VARCHAR2);

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:

Line 42: PROCEDURE execute_immediate(p_varchar2_table IN DBMS_SQL.VARCHAR2A);

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;

Line 43: PROCEDURE execute_immediate(p_varchar2_table IN DBMS_SQL.VARCHAR2A, p_bind_vars_values dbms_sql.varchar2_table, p_num_bind_vars number);

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;