APPS.BSC_DIMENSION_KEYS_PKG dependencies on DBMS_SQL

Line 12: g_xtd_date dbms_sql.varchar2_table;

8: g_periodicities BIS_PMV_PAGE_PARAMETER_TBL;
9: -- XTD specific
10: g_xtd_type varchar2(100);
11: g_xtd_periodicity number;
12: g_xtd_date dbms_sql.varchar2_table;
13: g_xtd_period dbms_sql.number_table;
14: g_xtd_year dbms_sql.number_table;
15:
16: g_dimensions BIS_PMV_PAGE_PARAMETER_TBL;

Line 13: g_xtd_period dbms_sql.number_table;

9: -- XTD specific
10: g_xtd_type varchar2(100);
11: g_xtd_periodicity number;
12: g_xtd_date dbms_sql.varchar2_table;
13: g_xtd_period dbms_sql.number_table;
14: g_xtd_year dbms_sql.number_table;
15:
16: g_dimensions BIS_PMV_PAGE_PARAMETER_TBL;
17: g_measures BIS_PMV_PAGE_PARAMETER_TBL;

Line 14: g_xtd_year dbms_sql.number_table;

10: g_xtd_type varchar2(100);
11: g_xtd_periodicity number;
12: g_xtd_date dbms_sql.varchar2_table;
13: g_xtd_period dbms_sql.number_table;
14: g_xtd_year dbms_sql.number_table;
15:
16: g_dimensions BIS_PMV_PAGE_PARAMETER_TBL;
17: g_measures BIS_PMV_PAGE_PARAMETER_TBL;
18: g_user_periods TabTimePeriods;

Line 206: l_period_start_period dbms_sql.number_table;

202: l_custom number;
203: l_db_column_name varchar2(100);
204: l_calendar_id number;
205:
206: l_period_start_period dbms_sql.number_table;
207: l_period_start_year dbms_sql.number_table;
208: l_period_end_period dbms_sql.number_table;
209: l_period_end_year dbms_sql.number_table;
210: l_stmt varchar2(1000);

Line 207: l_period_start_year dbms_sql.number_table;

203: l_db_column_name varchar2(100);
204: l_calendar_id number;
205:
206: l_period_start_period dbms_sql.number_table;
207: l_period_start_year dbms_sql.number_table;
208: l_period_end_period dbms_sql.number_table;
209: l_period_end_year dbms_sql.number_table;
210: l_stmt varchar2(1000);
211:

Line 208: l_period_end_period dbms_sql.number_table;

204: l_calendar_id number;
205:
206: l_period_start_period dbms_sql.number_table;
207: l_period_start_year dbms_sql.number_table;
208: l_period_end_period dbms_sql.number_table;
209: l_period_end_year dbms_sql.number_table;
210: l_stmt varchar2(1000);
211:
212: begin

Line 209: l_period_end_year dbms_sql.number_table;

205:
206: l_period_start_period dbms_sql.number_table;
207: l_period_start_year dbms_sql.number_table;
208: l_period_end_period dbms_sql.number_table;
209: l_period_end_year dbms_sql.number_table;
210: l_stmt varchar2(1000);
211:
212: begin
213: l_periodicity_id := g_periodicities(1).parameter_id;