APPS.BSC_MV_ADAPTER dependencies on DBMS_SQL

Line 671: l_zero_code_cols dbms_sql.varchar2_table;

667: ------------------------------------------------------------
668: l_create_non_unique_index boolean;
669: l_owner varchar2(200);
670: ------------------------------------------------------------
671: l_zero_code_cols dbms_sql.varchar2_table;
672: -----
673: l_higher_level_view_exists boolean ;
674: l_time_columns VARCHAR2(100):= '(PERIODICITY_ID, YEAR, PERIOD)';
675: l_index_counter number := 1;

Line 676: l_nonzero_code_cols dbms_sql.varchar2_table;

672: -----
673: l_higher_level_view_exists boolean ;
674: l_time_columns VARCHAR2(100):= '(PERIODICITY_ID, YEAR, PERIOD)';
675: l_index_counter number := 1;
676: l_nonzero_code_cols dbms_sql.varchar2_table;
677: l_is_zmv boolean;
678: l_zmv_exists_for_mv boolean;
679: l_mv_name_for_zmv varchar2(100);
680: ---------------------------------

Line 2141: l_zero_code_cols dbms_sql.varchar2_table;

2137: -------------------------------------------------------------------------
2138: l_create_non_unique_index boolean;
2139: -------------------------------------------------------------------------
2140:
2141: l_zero_code_cols dbms_sql.varchar2_table;
2142: -----
2143: l_higher_level_view_exists boolean ;
2144: l_time_columns VARCHAR2(100):= '(PERIODICITY_ID, YEAR, PERIOD)';
2145: l_index_counter number := 1;

Line 2146: l_nonzero_code_cols dbms_sql.varchar2_table;

2142: -----
2143: l_higher_level_view_exists boolean ;
2144: l_time_columns VARCHAR2(100):= '(PERIODICITY_ID, YEAR, PERIOD)';
2145: l_index_counter number := 1;
2146: l_nonzero_code_cols dbms_sql.varchar2_table;
2147: l_is_zmv boolean;
2148: l_zmv_exists_for_mv boolean;
2149: l_mv_name_for_zmv varchar2(100);
2150: