eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_AW_ADAPTER_KPI dependencies on DBMS_SQL

Line 6: g_commands dbms_sql.varchar2_table;

2: /*$Header: BSCAWAKS.pls 120.24 2006/04/17 15:38 vsurendr noship $*/
3: --program runtime parameters
4: g_debug boolean;
5: g_stmt varchar2(32000);
6: g_commands dbms_sql.varchar2_table;
7: ----types----------------------------------------------------------
8: --measures are the measures involved in the agg formula
9: --we need the measures becasue if we need to do the agg on-line, we need to know what the base measurea are for a formula.
10: --we first need to aggregate them, then run the formula

Line 16: cubes dbms_sql.varchar2_table, /the cubes in the formula /

12: agg_formula varchar2(2000),
13: sql_agg_formula varchar2(2000),/*this is the original agg formula from metadata. used when we have non std agg and partitions */
14: std_aggregation varchar2(20),--Y means sum average etc. N means its a formula like measure1/measure2
15: avg_aggregation varchar2(20),--Y means average
16: cubes dbms_sql.varchar2_table, /*the cubes in the formula */
17: measures dbms_sql.varchar2_table /*the measures in the formula */
18: );
19: --
20: /*

Line 17: measures dbms_sql.varchar2_table /the measures in the formula /

13: sql_agg_formula varchar2(2000),/*this is the original agg formula from metadata. used when we have non std agg and partitions */
14: std_aggregation varchar2(20),--Y means sum average etc. N means its a formula like measure1/measure2
15: avg_aggregation varchar2(20),--Y means average
16: cubes dbms_sql.varchar2_table, /*the cubes in the formula */
17: measures dbms_sql.varchar2_table /*the measures in the formula */
18: );
19: --
20: /*
21: we introduce here new classes. cube_r, partition_template_r, partition_r, composite_r and partition_r. we need to support the following designs

Line 40: composite_dimensions dbms_sql.varchar2_table

36: --
37: type composite_r is record(
38: composite_name varchar2(200),
39: composite_type varchar2(100), --compressed or non compressed
40: composite_dimensions dbms_sql.varchar2_table
41: );
42: type composite_tb is table of composite_r index by pls_integer;
43: --
44: /*we need to implement partitions in a whole new way. earlier we were implementing list and hash on dim keys. this will not do

Line 57: level_names dbms_sql.varchar2_table, /there can be multiple levels per dim we apply pt on. example, month and week level /

53: hpt: hash partition*/
54: type hpt_dimension_r is record( --dimensions of the dimset which are used to hash
55: dim_name varchar2(100),
56: dim_type varchar2(40),--normal,std,time
57: level_names dbms_sql.varchar2_table, /*there can be multiple levels per dim we apply pt on. example, month and week level */
58: level_keys dbms_sql.varchar2_table
59: );
60: type hpt_dimension_tb is table of hpt_dimension_r index by pls_integer;
61: --

Line 58: level_keys dbms_sql.varchar2_table

54: type hpt_dimension_r is record( --dimensions of the dimset which are used to hash
55: dim_name varchar2(100),
56: dim_type varchar2(40),--normal,std,time
57: level_names dbms_sql.varchar2_table, /*there can be multiple levels per dim we apply pt on. example, month and week level */
58: level_keys dbms_sql.varchar2_table
59: );
60: type hpt_dimension_tb is table of hpt_dimension_r index by pls_integer;
61: --
62: type hpt_data_r is record( --top hpt info holder

Line 79: template_dimensions dbms_sql.varchar2_table,--this just holds the dim of the template excluding partion and measure dim

75: template_name varchar2(200),
76: template_type varchar2(40), --lits or range etc
77: template_use varchar2(40), --used for datacube or countvar cube etc
78: template_dim varchar2(200), --hash dim or some range dim
79: template_dimensions dbms_sql.varchar2_table,--this just holds the dim of the template excluding partion and measure dim
80: template_partitions partition_tb,
81: hpt_data hpt_data_r --populated when there are hash partitions
82: );
83: type partition_template_tb is table of partition_template_r index by pls_integer;

Line 180: filter dbms_sql.varchar2_table, --we may have a long stmt, we dont want to constrain this to 4000 characters

176: data_type varchar2(40), --for now, all dim are text. so this muust be varchar2(300) needed to create olap table fn
177: zero_code varchar2(10),
178: zero_code_level varchar2(300),--the name of the aw dim that is used to represent zero level
179: rec_parent_level varchar2(300),--the name of the aw dim that is used to represent rec parent level
180: filter dbms_sql.varchar2_table, --we may have a long stmt, we dont want to constrain this to 4000 characters
181: position number, --used by the aggregation_r object in bsc_aw_load_kpi
182: aggregated varchar2(10), --Y or N
183: zero_aggregated varchar2(10), --Y or N. Use together with zero_code, if zero_code=Y and zero_aggregated=Y then
184: property varchar2(400), --used for seeing if a level is a standalone level

Line 289: feed_levels dbms_sql.varchar2_table,--these are the levels that feed the dimset Y or N

285: --and will be different from what is in the base table
286: type base_table_r is record(
287: base_table_name varchar2(100),
288: levels level_tb, --all dim levels except time
289: feed_levels dbms_sql.varchar2_table,--these are the levels that feed the dimset Y or N
290: level_status dbms_sql.varchar2_table,--skip or correct or lower etc
291: periodicity periodicity_r, --the periodicity at which the base table is
292: projection_table varchar2(100),
293: current_period varchar2(40),--in period.year format. this field can be null

Line 290: level_status dbms_sql.varchar2_table,--skip or correct or lower etc

286: type base_table_r is record(
287: base_table_name varchar2(100),
288: levels level_tb, --all dim levels except time
289: feed_levels dbms_sql.varchar2_table,--these are the levels that feed the dimset Y or N
290: level_status dbms_sql.varchar2_table,--skip or correct or lower etc
291: periodicity periodicity_r, --the periodicity at which the base table is
292: projection_table varchar2(100),
293: current_period varchar2(40),--in period.year format. this field can be null
294: table_partition bsc_aw_utility.object_partition_r,

Line 295: base_table_sql dbms_sql.varchar2_table

291: periodicity periodicity_r, --the periodicity at which the base table is
292: projection_table varchar2(100),
293: current_period varchar2(40),--in period.year format. this field can be null
294: table_partition bsc_aw_utility.object_partition_r,
295: base_table_sql dbms_sql.varchar2_table
296: );
297: type base_table_tb is table of base_table_r index by pls_integer;
298: --
299: /*this data structute holds info on partition info for a DS. ie, what PT this DS is loading */

Line 325: data_source_stmt_type dbms_sql.varchar2_table, --dimension= or measure= or limit cube= or 'partition dim'

321: std_dim dim_tb,
322: calendar calendar_r,
323: measure measure_tb,
324: ds_type varchar2(40),--initial or inc
325: data_source_stmt_type dbms_sql.varchar2_table, --dimension= or measure= or limit cube= or 'partition dim'
326: data_source_stmt dbms_sql.varchar2_table, --(select k1,k2,m1,m2 from B)
327: base_tables base_table_tb,
328: data_source_PT data_source_PT_r,
329: property bsc_aw_utility.property_tb --any misc properties

Line 326: data_source_stmt dbms_sql.varchar2_table, --(select k1,k2,m1,m2 from B)

322: calendar calendar_r,
323: measure measure_tb,
324: ds_type varchar2(40),--initial or inc
325: data_source_stmt_type dbms_sql.varchar2_table, --dimension= or measure= or limit cube= or 'partition dim'
326: data_source_stmt dbms_sql.varchar2_table, --(select k1,k2,m1,m2 from B)
327: base_tables base_table_tb,
328: data_source_PT data_source_PT_r,
329: property bsc_aw_utility.property_tb --any misc properties
330: );

Line 431: procedure create_kpi(p_kpi_list dbms_sql.varchar2_table);

427: g_balance_loaded_column_prop constant varchar2(40):='BALANCE LOADED COLUMN';
428: --
429: --procedures-------------------------------------------------------
430: procedure drop_kpi_objects(p_kpi varchar2);
431: procedure create_kpi(p_kpi_list dbms_sql.varchar2_table);
432: procedure create_kpi(p_kpi in out nocopy kpi_r);
433: procedure get_dim_set_dim_properties(p_kpi varchar2,p_dim_set in out nocopy dim_set_r);
434: procedure get_dim_set_calendar(p_kpi kpi_r,p_dim_set in out nocopy dim_set_r);
435: procedure get_dim_set_dims(p_kpi varchar2,p_dim_set in out nocopy dim_set_r);

Line 525: p_distict_mo_dim_groups out nocopy dbms_sql.varchar2_table);

521: procedure create_kpi_view(p_kpi kpi_r,p_dim_set dim_set_r,p_s_view s_view_r,p_type varchar2);
522: procedure create_missing_dim_levels(p_kpi varchar2,p_dim_set in out nocopy dim_set_r);
523: procedure get_dim_mo_dim_groups(
524: p_dim dim_r,
525: p_distict_mo_dim_groups out nocopy dbms_sql.varchar2_table);
526: procedure identify_standalone_levels(
527: p_kpi varchar2,
528: p_dim_set in out nocopy dim_set_r);
529: procedure create_dmp_program(

Line 532: p_dim_levels dbms_sql.varchar2_table,

528: p_dim_set in out nocopy dim_set_r);
529: procedure create_dmp_program(
530: p_kpi varchar2,
531: p_dimset varchar2,
532: p_dim_levels dbms_sql.varchar2_table,
533: p_name varchar2,
534: p_table_name varchar2);
535: procedure get_missing_periodicity(p_kpi kpi_r,p_dim_set in out nocopy dim_set_r);
536: function get_periodicity_r(p_periodicity periodicity_tb,p_periodicity_dim varchar2) return periodicity_r;

Line 564: function get_comp_dimensions(p_dim_set in out nocopy dim_set_r) return dbms_sql.varchar2_table;

560: procedure create_kpi_program_limit_cube(
561: p_kpi kpi_r,
562: p_dim_set dim_set_r,
563: p_data_source data_source_r);
564: function get_comp_dimensions(p_dim_set in out nocopy dim_set_r) return dbms_sql.varchar2_table;
565: procedure create_cube(
566: p_kpi kpi_r,
567: p_dim_set dim_set_r,
568: p_cube cube_r);

Line 672: procedure set_PT_dim_aggregated(p_dim in out nocopy dim_r,p_dim_set dim_set_r,p_levels dbms_sql.varchar2_table);

668: procedure set_DS_hpt_rollup_data(p_DS_dim dim_tb,p_hpt_data hpt_data_r,p_data_source in out nocopy data_source_r);
669: procedure set_DS_hpt_rollup_data(p_calendar calendar_r,p_DS_calendar calendar_r,p_hpt_data hpt_data_r,p_data_source in out nocopy data_source_r);
670: function get_DS_PT_hash_stmt(p_dim_set dim_set_r,p_data_source data_source_r)return varchar2;
671: procedure set_PT_dim_aggregated(p_dim_set in out nocopy dim_set_r,p_partition_template partition_template_r);
672: procedure set_PT_dim_aggregated(p_dim in out nocopy dim_r,p_dim_set dim_set_r,p_levels dbms_sql.varchar2_table);
673: procedure set_PT_calendar_aggregated(p_dim_set in out nocopy dim_set_r,p_partition_template partition_template_r);
674: procedure set_PT_calendar_aggregated(p_calendar in out nocopy calendar_r,p_dim_set dim_set_r,p_levels dbms_sql.varchar2_table);
675: function is_dim_aggregated(p_dim dim_r) return boolean;
676: function is_calendar_aggregated(p_calendar calendar_r) return boolean;

Line 674: procedure set_PT_calendar_aggregated(p_calendar in out nocopy calendar_r,p_dim_set dim_set_r,p_levels dbms_sql.varchar2_table);

670: function get_DS_PT_hash_stmt(p_dim_set dim_set_r,p_data_source data_source_r)return varchar2;
671: procedure set_PT_dim_aggregated(p_dim_set in out nocopy dim_set_r,p_partition_template partition_template_r);
672: procedure set_PT_dim_aggregated(p_dim in out nocopy dim_r,p_dim_set dim_set_r,p_levels dbms_sql.varchar2_table);
673: procedure set_PT_calendar_aggregated(p_dim_set in out nocopy dim_set_r,p_partition_template partition_template_r);
674: procedure set_PT_calendar_aggregated(p_calendar in out nocopy calendar_r,p_dim_set dim_set_r,p_levels dbms_sql.varchar2_table);
675: function is_dim_aggregated(p_dim dim_r) return boolean;
676: function is_calendar_aggregated(p_calendar calendar_r) return boolean;
677: function get_projection_dim(p_dim_set dim_set_r) return varchar2;
678: procedure create_cube(p_kpi kpi_r,p_dim_set dim_set_r,p_cube cube_r,p_cube_axis axis_tb);