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_DIM dependencies on DBMS_SQL

Line 7: g_commands dbms_sql.varchar2_table;

3: --program runtime parameters
4: g_debug boolean;
5: g_stmt varchar2(32000);
6: --cache a series of aw commands to execute...creating aw program
7: g_commands dbms_sql.varchar2_table;
8: g_exception exception;
9: g_corrected_dim dbms_sql.varchar2_table;
10: ----records----------------
11: type dim_parent_child_r is record(

Line 9: g_corrected_dim dbms_sql.varchar2_table;

5: g_stmt varchar2(32000);
6: --cache a series of aw commands to execute...creating aw program
7: g_commands dbms_sql.varchar2_table;
8: g_exception exception;
9: g_corrected_dim dbms_sql.varchar2_table;
10: ----records----------------
11: type dim_parent_child_r is record(
12: parent_level varchar2(200),
13: child_level varchar2(200),

Line 29: seed_values dbms_sql.varchar2_table,--these are seed values for the dim level. used by projection dim

25: level_name varchar2(200),
26: level_id number,
27: position number, --for norml dim, lowest level is 1, for rec, top level is 1. but for rec dim, this is not set
28: property varchar2(200),
29: seed_values dbms_sql.varchar2_table,--these are seed values for the dim level. used by projection dim
30: pk level_pk_r,
31: filter_variable varchar2(300),
32: limit_variable varchar2(300),
33: level_name_dim varchar2(300), --reqd for snow flake implementation

Line 58: dim_set dbms_sql.varchar2_table

54: --
55: --what are the kpi that have this dim
56: type kpi_for_dim_r is record(
57: kpi varchar2(200),
58: dim_set dbms_sql.varchar2_table
59: );
60: type kpi_for_dim_tb is table of kpi_for_dim_r index by pls_integer;
61: --
62: --this will be used by DBI dimensions both rec and non-rec

Line 65: dim_name dbms_sql.varchar2_table,

61: --
62: --this will be used by DBI dimensions both rec and non-rec
63: --we will match between dim_name and pk_col when we construct the :append stmts
64: type dim_data_source_r is record(
65: dim_name dbms_sql.varchar2_table,
66: pk_col dbms_sql.varchar2_table, --this is the pk col of the relation table
67: data_source varchar2(8000), --(select distinct ...from table)
68: inc_data_source varchar2(8000),
69: child_col varchar2(100), --of the denorm table

Line 66: pk_col dbms_sql.varchar2_table, --this is the pk col of the relation table

62: --this will be used by DBI dimensions both rec and non-rec
63: --we will match between dim_name and pk_col when we construct the :append stmts
64: type dim_data_source_r is record(
65: dim_name dbms_sql.varchar2_table,
66: pk_col dbms_sql.varchar2_table, --this is the pk col of the relation table
67: data_source varchar2(8000), --(select distinct ...from table)
68: inc_data_source varchar2(8000),
69: child_col varchar2(100), --of the denorm table
70: parent_col varchar2(100), --of the denorm table

Line 138: p_dim_level_list dbms_sql.varchar2_table,

134: --------------------
135: g_dimensions dimension_tb;
136: ---procedures-------------------------------------------------------
137: procedure create_dim(
138: p_dim_level_list dbms_sql.varchar2_table,
139: p_affected_kpi in out nocopy dbms_sql.varchar2_table
140: );
141: procedure get_all_dim_levels(
142: p_dim_level_list dbms_sql.varchar2_table,

Line 139: p_affected_kpi in out nocopy dbms_sql.varchar2_table

135: g_dimensions dimension_tb;
136: ---procedures-------------------------------------------------------
137: procedure create_dim(
138: p_dim_level_list dbms_sql.varchar2_table,
139: p_affected_kpi in out nocopy dbms_sql.varchar2_table
140: );
141: procedure get_all_dim_levels(
142: p_dim_level_list dbms_sql.varchar2_table,
143: p_dim_parent_child out nocopy dim_parent_child_tb,

Line 142: p_dim_level_list dbms_sql.varchar2_table,

138: p_dim_level_list dbms_sql.varchar2_table,
139: p_affected_kpi in out nocopy dbms_sql.varchar2_table
140: );
141: procedure get_all_dim_levels(
142: p_dim_level_list dbms_sql.varchar2_table,
143: p_dim_parent_child out nocopy dim_parent_child_tb,
144: p_dim_levels out nocopy levels_tv
145: );
146: procedure group_levels_into_sets(

Line 151: p_level_considered in out nocopy dbms_sql.varchar2_table,

147: p_dim_parent_child in out nocopy dim_parent_child_tb
148: );
149: procedure assign_set_to_level(
150: p_dim_parent_child in out nocopy dim_parent_child_tb,
151: p_level_considered in out nocopy dbms_sql.varchar2_table,
152: p_level varchar2,
153: p_set number
154: );
155: procedure create_dim(

Line 178: p_affected_kpi in out nocopy dbms_sql.varchar2_table

174: p_dimension in out nocopy dimension_r
175: );
176: procedure implement_dim_aw(
177: p_dimensions in out nocopy dimension_tb,
178: p_affected_kpi in out nocopy dbms_sql.varchar2_table
179: );
180: procedure implement_dim_aw(
181: p_dimension in out nocopy dimension_r,
182: p_affected_kpi in out nocopy dbms_sql.varchar2_table

Line 182: p_affected_kpi in out nocopy dbms_sql.varchar2_table

178: p_affected_kpi in out nocopy dbms_sql.varchar2_table
179: );
180: procedure implement_dim_aw(
181: p_dimension in out nocopy dimension_r,
182: p_affected_kpi in out nocopy dbms_sql.varchar2_table
183: );
184: procedure drop_kpi_objects_for_dim(p_dim_name varchar2,p_affected_kpi in out nocopy dbms_sql.varchar2_table);
185: procedure drop_dim(p_dim_name varchar2);
186: procedure drop_old_dim_for_level(p_dimension dimension_r,p_affected_kpi in out nocopy dbms_sql.varchar2_table);

Line 184: procedure drop_kpi_objects_for_dim(p_dim_name varchar2,p_affected_kpi in out nocopy dbms_sql.varchar2_table);

180: procedure implement_dim_aw(
181: p_dimension in out nocopy dimension_r,
182: p_affected_kpi in out nocopy dbms_sql.varchar2_table
183: );
184: procedure drop_kpi_objects_for_dim(p_dim_name varchar2,p_affected_kpi in out nocopy dbms_sql.varchar2_table);
185: procedure drop_dim(p_dim_name varchar2);
186: procedure drop_old_dim_for_level(p_dimension dimension_r,p_affected_kpi in out nocopy dbms_sql.varchar2_table);
187: procedure create_dim_objects(p_dimension in out nocopy dimension_r);
188: procedure create_dim_for_levels(p_dimension in out nocopy dimension_r);

Line 186: procedure drop_old_dim_for_level(p_dimension dimension_r,p_affected_kpi in out nocopy dbms_sql.varchar2_table);

182: p_affected_kpi in out nocopy dbms_sql.varchar2_table
183: );
184: procedure drop_kpi_objects_for_dim(p_dim_name varchar2,p_affected_kpi in out nocopy dbms_sql.varchar2_table);
185: procedure drop_dim(p_dim_name varchar2);
186: procedure drop_old_dim_for_level(p_dimension dimension_r,p_affected_kpi in out nocopy dbms_sql.varchar2_table);
187: procedure create_dim_objects(p_dimension in out nocopy dimension_r);
188: procedure create_dim_for_levels(p_dimension in out nocopy dimension_r);
189: procedure create_ccdim(p_dimension in out nocopy dimension_r);
190: procedure create_level_name_dim(p_dimension in out nocopy dimension_r);

Line 213: p_limit_cubes out nocopy dbms_sql.varchar2_table,

209: procedure create_dmp_program(p_dim_level varchar2,p_name varchar2);
210: function get_zero_level(p_dimension dimension_r,p_level varchar2) return zero_levels_r ;
211: procedure get_dim_kpi_limit_cubes(
212: p_dim varchar2,
213: p_limit_cubes out nocopy dbms_sql.varchar2_table,
214: p_aggregate_marker out nocopy dbms_sql.varchar2_table,
215: p_reset_cubes out nocopy dbms_sql.varchar2_table);
216: procedure create_dim_program_rec_norm(p_dimension dimension_r,p_mode varchar2);
217: procedure create_dim(p_dim_level_list dbms_sql.varchar2_table);

Line 214: p_aggregate_marker out nocopy dbms_sql.varchar2_table,

210: function get_zero_level(p_dimension dimension_r,p_level varchar2) return zero_levels_r ;
211: procedure get_dim_kpi_limit_cubes(
212: p_dim varchar2,
213: p_limit_cubes out nocopy dbms_sql.varchar2_table,
214: p_aggregate_marker out nocopy dbms_sql.varchar2_table,
215: p_reset_cubes out nocopy dbms_sql.varchar2_table);
216: procedure create_dim_program_rec_norm(p_dimension dimension_r,p_mode varchar2);
217: procedure create_dim(p_dim_level_list dbms_sql.varchar2_table);
218: procedure create_dim_program(p_dimension dimension_r,p_level_group level_group_r,p_mode varchar2);

Line 215: p_reset_cubes out nocopy dbms_sql.varchar2_table);

211: procedure get_dim_kpi_limit_cubes(
212: p_dim varchar2,
213: p_limit_cubes out nocopy dbms_sql.varchar2_table,
214: p_aggregate_marker out nocopy dbms_sql.varchar2_table,
215: p_reset_cubes out nocopy dbms_sql.varchar2_table);
216: procedure create_dim_program_rec_norm(p_dimension dimension_r,p_mode varchar2);
217: procedure create_dim(p_dim_level_list dbms_sql.varchar2_table);
218: procedure create_dim_program(p_dimension dimension_r,p_level_group level_group_r,p_mode varchar2);
219: procedure create_dim_program(

Line 217: procedure create_dim(p_dim_level_list dbms_sql.varchar2_table);

213: p_limit_cubes out nocopy dbms_sql.varchar2_table,
214: p_aggregate_marker out nocopy dbms_sql.varchar2_table,
215: p_reset_cubes out nocopy dbms_sql.varchar2_table);
216: procedure create_dim_program_rec_norm(p_dimension dimension_r,p_mode varchar2);
217: procedure create_dim(p_dim_level_list dbms_sql.varchar2_table);
218: procedure create_dim_program(p_dimension dimension_r,p_level_group level_group_r,p_mode varchar2);
219: procedure create_dim_program(
220: p_dimension dimension_r,
221: p_levels levels_tb,

Line 249: function get_std_dim_list return dbms_sql.varchar2_table ;

245: function get_dim_name_hash_string(p_dimension dimension_r) return varchar2 ;
246: procedure make_dim_name(p_dimension in out nocopy dimension_r,p_hash_string varchar2);
247: procedure check_dim_name_conflict(p_dimension in out nocopy dimension_r);
248: function get_default_lg_name return varchar2;
249: function get_std_dim_list return dbms_sql.varchar2_table ;
250: procedure check_parent(
251: p_parent_child dim_parent_child_tb,
252: p_child_level varchar2,
253: p_check_level varchar2,

Line 259: function get_preloaded_dim_list return dbms_sql.varchar2_table;

255: );
256: function get_hier_subset(p_parent_child dim_parent_child_tb,p_parent_level varchar2,p_child_level varchar2) return dim_parent_child_tb;
257: procedure set_rec_dim_properties(p_dimension in out nocopy dimension_r);
258: procedure set_dim_recursive(p_dimension in out nocopy dimension_r);
259: function get_preloaded_dim_list return dbms_sql.varchar2_table;
260: function check_dim_view_based(p_dim varchar2) return varchar2 ;
261: procedure upgrade(p_new_version number,p_old_version number);
262: procedure merge_hier(p_pc_subset in out nocopy dim_parent_child_tb,p_pc_subset_merge dim_parent_child_tb);
263: function get_hier_subset(p_parent_child dim_parent_child_tb,p_parent_level dbms_sql.varchar2_table,

Line 263: function get_hier_subset(p_parent_child dim_parent_child_tb,p_parent_level dbms_sql.varchar2_table,

259: function get_preloaded_dim_list return dbms_sql.varchar2_table;
260: function check_dim_view_based(p_dim varchar2) return varchar2 ;
261: procedure upgrade(p_new_version number,p_old_version number);
262: procedure merge_hier(p_pc_subset in out nocopy dim_parent_child_tb,p_pc_subset_merge dim_parent_child_tb);
263: function get_hier_subset(p_parent_child dim_parent_child_tb,p_parent_level dbms_sql.varchar2_table,
264: p_child_level dbms_sql.varchar2_table) return dim_parent_child_tb;
265: --std procedures----------------------------------------------------
266: procedure init_all;
267: procedure log(p_message varchar2);

Line 264: p_child_level dbms_sql.varchar2_table) return dim_parent_child_tb;

260: function check_dim_view_based(p_dim varchar2) return varchar2 ;
261: procedure upgrade(p_new_version number,p_old_version number);
262: procedure merge_hier(p_pc_subset in out nocopy dim_parent_child_tb,p_pc_subset_merge dim_parent_child_tb);
263: function get_hier_subset(p_parent_child dim_parent_child_tb,p_parent_level dbms_sql.varchar2_table,
264: p_child_level dbms_sql.varchar2_table) return dim_parent_child_tb;
265: --std procedures----------------------------------------------------
266: procedure init_all;
267: procedure log(p_message varchar2);
268: procedure log_n(p_message varchar2);