APPS.BSC_MIGRATION dependencies on DBMS_SQL

Line 5402: h_dim_level_list dbms_sql.varchar2_table;

5398: h_dbi_table_name VARCHAR2(30);
5399: h_dbi_short_name VARCHAR2(30);
5400:
5401: --AW_INTEGRATION: new variables
5402: h_dim_level_list dbms_sql.varchar2_table;
5403: h_kpi_list dbms_sql.varchar2_table;
5404: h_calendar_id NUMBER;
5405: h_level_table_name VARCHAR2(50);
5406: h_dim_tables BSC_UPDATE_UTIL.t_array_of_varchar2;

Line 5403: h_kpi_list dbms_sql.varchar2_table;

5399: h_dbi_short_name VARCHAR2(30);
5400:
5401: --AW_INTEGRATION: new variables
5402: h_dim_level_list dbms_sql.varchar2_table;
5403: h_kpi_list dbms_sql.varchar2_table;
5404: h_calendar_id NUMBER;
5405: h_level_table_name VARCHAR2(50);
5406: h_dim_tables BSC_UPDATE_UTIL.t_array_of_varchar2;
5407: h_num_dim_tables NUMBER;

Line 8061: h_list dbms_sql.varchar2_table;

8057: +============================================================================*/
8058: FUNCTION Get_RowId_Table_Name (
8059: x_table_name IN VARCHAR2
8060: ) RETURN VARCHAR2 IS
8061: h_list dbms_sql.varchar2_table;
8062: h_values dbms_sql.varchar2_table;
8063: BEGIN
8064: h_list.delete;
8065: h_list(1) := BSC_DBGEN_STD_METADATA.BSC_I_ROWID_TABLE;

Line 8062: h_values dbms_sql.varchar2_table;

8058: FUNCTION Get_RowId_Table_Name (
8059: x_table_name IN VARCHAR2
8060: ) RETURN VARCHAR2 IS
8061: h_list dbms_sql.varchar2_table;
8062: h_values dbms_sql.varchar2_table;
8063: BEGIN
8064: h_list.delete;
8065: h_list(1) := BSC_DBGEN_STD_METADATA.BSC_I_ROWID_TABLE;
8066: h_values := BSC_DBGEN_METADATA_READER.Get_Table_Properties(x_table_name, h_list);

Line 8078: h_list dbms_sql.varchar2_table;

8074: +============================================================================*/
8075: FUNCTION Get_Proj_Table_Name (
8076: x_table_name IN VARCHAR2
8077: ) RETURN VARCHAR2 IS
8078: h_list dbms_sql.varchar2_table;
8079: h_values dbms_sql.varchar2_table;
8080: BEGIN
8081: h_list.delete;
8082: h_list(1) := BSC_DBGEN_STD_METADATA.BSC_B_PRJ_TABLE;

Line 8079: h_values dbms_sql.varchar2_table;

8075: FUNCTION Get_Proj_Table_Name (
8076: x_table_name IN VARCHAR2
8077: ) RETURN VARCHAR2 IS
8078: h_list dbms_sql.varchar2_table;
8079: h_values dbms_sql.varchar2_table;
8080: BEGIN
8081: h_list.delete;
8082: h_list(1) := BSC_DBGEN_STD_METADATA.BSC_B_PRJ_TABLE;
8083: h_values := BSC_DBGEN_METADATA_READER.Get_Table_Properties(x_table_name, h_list);

Line 8095: h_list dbms_sql.varchar2_table;

8091: +============================================================================*/
8092: FUNCTION Get_Num_Partitions (
8093: x_table_name IN VARCHAR2
8094: ) RETURN NUMBER IS
8095: h_list dbms_sql.varchar2_table;
8096: h_values dbms_sql.varchar2_table;
8097: BEGIN
8098: h_list.delete;
8099: h_list(1) := BSC_DBGEN_STD_METADATA.BSC_PARTITION;

Line 8096: h_values dbms_sql.varchar2_table;

8092: FUNCTION Get_Num_Partitions (
8093: x_table_name IN VARCHAR2
8094: ) RETURN NUMBER IS
8095: h_list dbms_sql.varchar2_table;
8096: h_values dbms_sql.varchar2_table;
8097: BEGIN
8098: h_list.delete;
8099: h_list(1) := BSC_DBGEN_STD_METADATA.BSC_PARTITION;
8100: h_values := BSC_DBGEN_METADATA_READER.Get_Table_Properties(x_table_name, h_list);