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: procedure create_dim(p_dim_level_list dbms_sql.varchar2_table) is

3:
4: --given a array of dim, first get the full list of dim as parent child
5: --and then group them into dim
6: --p_dim_level_list is a set of BSC dim levels
7: procedure create_dim(p_dim_level_list dbms_sql.varchar2_table) is
8: l_affected_kpi dbms_sql.varchar2_table;
9: Begin
10: create_dim(p_dim_level_list,l_affected_kpi);
11: Exception when others then

Line 8: l_affected_kpi dbms_sql.varchar2_table;

4: --given a array of dim, first get the full list of dim as parent child
5: --and then group them into dim
6: --p_dim_level_list is a set of BSC dim levels
7: procedure create_dim(p_dim_level_list dbms_sql.varchar2_table) is
8: l_affected_kpi dbms_sql.varchar2_table;
9: Begin
10: create_dim(p_dim_level_list,l_affected_kpi);
11: Exception when others then
12: log_n('Exception in create_dim '||sqlerrm);

Line 21: p_dim_level_list dbms_sql.varchar2_table,

17: if create_dim has to end up re-creating a dim, then the affected kpi are returned. these affected kpi have been
18: dropped so the dim can be recreated. mostly, p_affected_kpi should be empty
19: */
20: procedure create_dim(
21: p_dim_level_list dbms_sql.varchar2_table,
22: p_affected_kpi in out nocopy dbms_sql.varchar2_table
23: ) is
24: --
25: l_dim_parent_child dim_parent_child_tb;

Line 22: p_affected_kpi in out nocopy dbms_sql.varchar2_table

18: dropped so the dim can be recreated. mostly, p_affected_kpi should be empty
19: */
20: procedure create_dim(
21: p_dim_level_list dbms_sql.varchar2_table,
22: p_affected_kpi in out nocopy dbms_sql.varchar2_table
23: ) is
24: --
25: l_dim_parent_child dim_parent_child_tb;
26: l_dim_levels levels_tv;

Line 51: p_dim_level_list dbms_sql.varchar2_table,

47: --excluding the position
48: --position is later calculated
49: --needs to be reset later
50: procedure get_all_dim_levels(
51: p_dim_level_list dbms_sql.varchar2_table,
52: p_dim_parent_child out nocopy dim_parent_child_tb,
53: p_dim_levels out nocopy levels_tv
54: ) is
55: Begin

Line 77: l_level_considered dbms_sql.varchar2_table;

73: procedure group_levels_into_sets(
74: p_dim_parent_child in out nocopy dim_parent_child_tb
75: ) is
76: --
77: l_level_considered dbms_sql.varchar2_table;
78: l_set number;
79: l_flag boolean;
80: l_level varchar2(100);
81: --

Line 113: p_level_considered in out nocopy dbms_sql.varchar2_table,

109: --assign a set number to this level (p_level). then for each parent and child, see if a set is already assigned.
110: --if not, call this procedure recursively for those levels
111: procedure assign_set_to_level(
112: p_dim_parent_child in out nocopy dim_parent_child_tb,
113: p_level_considered in out nocopy dbms_sql.varchar2_table,
114: p_level varchar2,
115: p_set number
116: ) is
117: Begin

Line 540: p_affected_kpi in out nocopy dbms_sql.varchar2_table

536:
537: */
538: procedure implement_dim_aw(
539: p_dimensions in out nocopy dimension_tb,
540: p_affected_kpi in out nocopy dbms_sql.varchar2_table
541: ) is
542: --
543: --
544: Begin

Line 558: p_affected_kpi in out nocopy dbms_sql.varchar2_table

554: End;
555:
556: procedure implement_dim_aw(
557: p_dimension in out nocopy dimension_r,
558: p_affected_kpi in out nocopy dbms_sql.varchar2_table
559: ) is
560: --
561: l_dim_create varchar2(100);
562: l_recreate_option varchar2(100);

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

610:
611: /*
612: we will keep this api around. what if we need to drop and recreate kpi in some case?
613: */
614: procedure drop_kpi_objects_for_dim(p_dim_name varchar2,p_affected_kpi in out nocopy dbms_sql.varchar2_table) is
615: --
616: l_kpi_list dbms_sql.varchar2_table;
617: --
618: Begin

Line 616: l_kpi_list dbms_sql.varchar2_table;

612: we will keep this api around. what if we need to drop and recreate kpi in some case?
613: */
614: procedure drop_kpi_objects_for_dim(p_dim_name varchar2,p_affected_kpi in out nocopy dbms_sql.varchar2_table) is
615: --
616: l_kpi_list dbms_sql.varchar2_table;
617: --
618: Begin
619: --get_kpi_for_dim gives the list of kpi already implemented in AW for this dim
620: bsc_aw_md_api.get_kpi_for_dim(p_dim_name,l_kpi_list);

Line 641: l_flag dbms_sql.varchar2_table;

637: */
638: procedure drop_dim(p_dim_name varchar2) is
639: --
640: l_objects bsc_aw_md_wrapper.bsc_olap_object_tb;
641: l_flag dbms_sql.varchar2_table;
642: --
643: Begin
644: bsc_aw_md_api.get_dim_olap_objects(p_dim_name,l_objects,'all');
645: for i in 1..l_objects.count loop

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

688: /*see if any of the levels have a cc dim . if yes, drop them. for the levels, find the old cc dim,
689: for the ccdim, find the kpi drop the kpi structures, mark kpi for recreate, drop old cc dim
690: This is a specialized api. used only to drop the old cc dim for the levels
691: */
692: procedure drop_old_dim_for_level(p_dimension dimension_r,p_affected_kpi in out nocopy dbms_sql.varchar2_table) is
693: --
694: l_dim_list dbms_sql.varchar2_table;
695: --
696: Begin

Line 694: l_dim_list dbms_sql.varchar2_table;

690: This is a specialized api. used only to drop the old cc dim for the levels
691: */
692: procedure drop_old_dim_for_level(p_dimension dimension_r,p_affected_kpi in out nocopy dbms_sql.varchar2_table) is
693: --
694: l_dim_list dbms_sql.varchar2_table;
695: --
696: Begin
697: --for single level dim, there is one level, itself
698: --its best to have same structure for all dim. single level dim also have concat dimensions

Line 802: l_levels dbms_sql.varchar2_table;

798: raise;
799: End;
800:
801: procedure create_ccdim(p_dimension in out nocopy dimension_r) is
802: l_levels dbms_sql.varchar2_table;
803: Begin
804: g_stmt:='dfn '||p_dimension.dim_name||' dimension concat(';
805: --normal levels
806: for i in 1..p_dimension.level_groups(1).levels.count loop

Line 1624: p_limit_cubes out nocopy dbms_sql.varchar2_table,

1620: given a dim, what are the kpi limit cubes. called in dim load
1621: */
1622: procedure get_dim_kpi_limit_cubes(
1623: p_dim varchar2,
1624: p_limit_cubes out nocopy dbms_sql.varchar2_table,
1625: p_aggregate_marker out nocopy dbms_sql.varchar2_table,
1626: p_reset_cubes out nocopy dbms_sql.varchar2_table
1627: ) is
1628: --

Line 1625: p_aggregate_marker out nocopy dbms_sql.varchar2_table,

1621: */
1622: procedure get_dim_kpi_limit_cubes(
1623: p_dim varchar2,
1624: p_limit_cubes out nocopy dbms_sql.varchar2_table,
1625: p_aggregate_marker out nocopy dbms_sql.varchar2_table,
1626: p_reset_cubes out nocopy dbms_sql.varchar2_table
1627: ) is
1628: --
1629: l_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;

Line 1626: p_reset_cubes out nocopy dbms_sql.varchar2_table

1622: procedure get_dim_kpi_limit_cubes(
1623: p_dim varchar2,
1624: p_limit_cubes out nocopy dbms_sql.varchar2_table,
1625: p_aggregate_marker out nocopy dbms_sql.varchar2_table,
1626: p_reset_cubes out nocopy dbms_sql.varchar2_table
1627: ) is
1628: --
1629: l_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
1630: Begin

Line 1696: l_old_dim_list dbms_sql.varchar2_table;

1692: procedure correct_old_dim(p_dim dimension_r,p_flag out nocopy varchar2) is
1693: l_old_dim dimension_tb;
1694: l_merge_dim dimension_tb;
1695: l_new_dim dimension_r;
1696: l_old_dim_list dbms_sql.varchar2_table;
1697: l_old_dim_action dbms_sql.varchar2_table;
1698: Begin
1699: if g_debug then
1700: log('correct_old_dim for '||p_dim.dim_name);

Line 1697: l_old_dim_action dbms_sql.varchar2_table;

1693: l_old_dim dimension_tb;
1694: l_merge_dim dimension_tb;
1695: l_new_dim dimension_r;
1696: l_old_dim_list dbms_sql.varchar2_table;
1697: l_old_dim_action dbms_sql.varchar2_table;
1698: Begin
1699: if g_debug then
1700: log('correct_old_dim for '||p_dim.dim_name);
1701: end if;

Line 1811: l_new_levels dbms_sql.varchar2_table;

1807: if now all 10 levels are together, the 5 new dim are candidates for merge. merge into the one with
1808: 3 levels. all others are corrected
1809: */
1810: procedure merge_dim(p_old_dim in out nocopy dimension_tb,p_new_dim in out nocopy dimension_r) is
1811: l_new_levels dbms_sql.varchar2_table;
1812: l_number_match dbms_sql.number_table;
1813: l_max number;
1814: Begin
1815: for i in 1..p_new_dim.level_groups.count loop

Line 1812: l_number_match dbms_sql.number_table;

1808: 3 levels. all others are corrected
1809: */
1810: procedure merge_dim(p_old_dim in out nocopy dimension_tb,p_new_dim in out nocopy dimension_r) is
1811: l_new_levels dbms_sql.varchar2_table;
1812: l_number_match dbms_sql.number_table;
1813: l_max number;
1814: Begin
1815: for i in 1..p_new_dim.level_groups.count loop
1816: for j in 1..p_new_dim.level_groups(i).levels.count loop

Line 1905: l_levels dbms_sql.varchar2_table;

1901: raise;
1902: End;
1903:
1904: procedure correct_zero_levels(p_new_level levels_tb,p_old_zero_level zero_levels_tb,p_new_zero_level out nocopy zero_levels_tb) is
1905: l_levels dbms_sql.varchar2_table;
1906: Begin
1907: for i in 1..p_new_level.count loop
1908: l_levels(l_levels.count+1):=p_new_level(i).level_name;
1909: end loop;

Line 1921: l_parents dbms_sql.varchar2_table;

1917: raise;
1918: End;
1919:
1920: procedure correct_parent_child(p_level_group level_group_r,p_old_pc dim_parent_child_tb,p_new_pc out nocopy dim_parent_child_tb) is
1921: l_parents dbms_sql.varchar2_table;
1922: l_levels dbms_sql.varchar2_table;
1923: l_dim_levels dbms_sql.varchar2_table;
1924: Begin
1925: for i in 1..p_level_group.levels.count loop

Line 1922: l_levels dbms_sql.varchar2_table;

1918: End;
1919:
1920: procedure correct_parent_child(p_level_group level_group_r,p_old_pc dim_parent_child_tb,p_new_pc out nocopy dim_parent_child_tb) is
1921: l_parents dbms_sql.varchar2_table;
1922: l_levels dbms_sql.varchar2_table;
1923: l_dim_levels dbms_sql.varchar2_table;
1924: Begin
1925: for i in 1..p_level_group.levels.count loop
1926: l_dim_levels(l_dim_levels.count+1):=p_level_group.levels(i).level_name;

Line 1923: l_dim_levels dbms_sql.varchar2_table;

1919:
1920: procedure correct_parent_child(p_level_group level_group_r,p_old_pc dim_parent_child_tb,p_new_pc out nocopy dim_parent_child_tb) is
1921: l_parents dbms_sql.varchar2_table;
1922: l_levels dbms_sql.varchar2_table;
1923: l_dim_levels dbms_sql.varchar2_table;
1924: Begin
1925: for i in 1..p_level_group.levels.count loop
1926: l_dim_levels(l_dim_levels.count+1):=p_level_group.levels(i).level_name;
1927: end loop;

Line 2039: l_level_considered dbms_sql.varchar2_table;

2035:
2036: procedure correct_level_groups(p_old_level_group level_group_r,p_new_level_groups out nocopy level_group_tb) is
2037: --
2038: l_max_set number;
2039: l_level_considered dbms_sql.varchar2_table;
2040: l_zero_level zero_levels_r;
2041: l_rec_level rec_levels_r;
2042: l_old_level_group level_group_r;
2043: Begin

Line 2126: l_level_list dbms_sql.varchar2_table;

2122: p_flag = correct, merge, noop or same
2123: p_flag is from the perspective of p_old_dim
2124: */
2125: procedure check_old_dim_operation(p_old_dim dimension_r,p_new_dim dimension_r,p_flag out nocopy varchar2) is
2126: l_level_list dbms_sql.varchar2_table;
2127: l_old_level_list dbms_sql.varchar2_table;
2128: l_level_group level_group_r;
2129: l_pc_comparison number;
2130: Begin

Line 2127: l_old_level_list dbms_sql.varchar2_table;

2123: p_flag is from the perspective of p_old_dim
2124: */
2125: procedure check_old_dim_operation(p_old_dim dimension_r,p_new_dim dimension_r,p_flag out nocopy varchar2) is
2126: l_level_list dbms_sql.varchar2_table;
2127: l_old_level_list dbms_sql.varchar2_table;
2128: l_level_group level_group_r;
2129: l_pc_comparison number;
2130: Begin
2131: if g_debug then

Line 2318: function get_std_dim_list return dbms_sql.varchar2_table is

2314: log_n('Exception in get_default_lg_name '||sqlerrm);
2315: raise;
2316: End;
2317:
2318: function get_std_dim_list return dbms_sql.varchar2_table is
2319: l_dim dbms_sql.varchar2_table;
2320: Begin
2321: l_dim(1):='TYPE';
2322: l_dim(2):='PROJECTION';

Line 2319: l_dim dbms_sql.varchar2_table;

2315: raise;
2316: End;
2317:
2318: function get_std_dim_list return dbms_sql.varchar2_table is
2319: l_dim dbms_sql.varchar2_table;
2320: Begin
2321: l_dim(1):='TYPE';
2322: l_dim(2):='PROJECTION';
2323: return l_dim;

Line 2329: function get_preloaded_dim_list return dbms_sql.varchar2_table is

2325: log_n('Exception in get_std_dim_list '||sqlerrm);
2326: raise;
2327: End;
2328:
2329: function get_preloaded_dim_list return dbms_sql.varchar2_table is
2330: l_dim dbms_sql.varchar2_table;
2331: Begin
2332: l_dim(1):='PROJECTION';
2333: return l_dim;

Line 2330: l_dim dbms_sql.varchar2_table;

2326: raise;
2327: End;
2328:
2329: function get_preloaded_dim_list return dbms_sql.varchar2_table is
2330: l_dim dbms_sql.varchar2_table;
2331: Begin
2332: l_dim(1):='PROJECTION';
2333: return l_dim;
2334: Exception when others then

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

2336: raise;
2337: End;
2338:
2339: /*given a set of child levels and parent levels, find the hier subset that includes all of them */
2340: function get_hier_subset(p_parent_child dim_parent_child_tb,p_parent_level dbms_sql.varchar2_table,
2341: p_child_level dbms_sql.varchar2_table) return dim_parent_child_tb is
2342: l_pc_subset dim_parent_child_tb;
2343: l_pc_subset_temp dim_parent_child_tb;
2344: Begin

Line 2341: p_child_level dbms_sql.varchar2_table) return dim_parent_child_tb is

2337: End;
2338:
2339: /*given a set of child levels and parent levels, find the hier subset that includes all of them */
2340: function get_hier_subset(p_parent_child dim_parent_child_tb,p_parent_level dbms_sql.varchar2_table,
2341: p_child_level dbms_sql.varchar2_table) return dim_parent_child_tb is
2342: l_pc_subset dim_parent_child_tb;
2343: l_pc_subset_temp dim_parent_child_tb;
2344: Begin
2345: for i in 1..p_child_level.count loop