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_MV_ADAPTER dependencies on BSC_IM_UTILS

Line 21: p_child_mv BSC_IM_UTILS.varchar_tabletype,

17: function create_mv_normal(
18: p_kpi varchar2,
19: p_mv_name varchar2,
20: p_mv_owner varchar2,
21: p_child_mv BSC_IM_UTILS.varchar_tabletype,
22: p_number_child_mv number,
23: p_options BSC_IM_UTILS.varchar_tabletype,
24: p_number_options number,
25: p_apps_origin varchar2,

Line 23: p_options BSC_IM_UTILS.varchar_tabletype,

19: p_mv_name varchar2,
20: p_mv_owner varchar2,
21: p_child_mv BSC_IM_UTILS.varchar_tabletype,
22: p_number_child_mv number,
23: p_options BSC_IM_UTILS.varchar_tabletype,
24: p_number_options number,
25: p_apps_origin varchar2,
26: p_type varchar2,
27: p_create_non_unique_index boolean

Line 32: p_options BSC_IM_UTILS.varchar_tabletype,

28: )return boolean;
29: function create_mv_kpi(
30: p_kpi varchar2,
31: p_apps_origin varchar2,
32: p_options BSC_IM_UTILS.varchar_tabletype,
33: p_number_options number
34: ) return boolean ;
35: function create_mv_synonym(
36: p_level varchar2,

Line 47: p_options BSC_IM_UTILS.varchar_tabletype,

43: )return boolean;
44: function create_mv_log_on_table(
45: p_object varchar2,
46: p_apps_origin varchar2,
47: p_options BSC_IM_UTILS.varchar_tabletype,
48: p_number_options number,
49: p_snplog_created out nocopy boolean
50: )return boolean;
51: function refresh_mv_kpi(

Line 54: p_options BSC_IM_UTILS.varchar_tabletype,

50: )return boolean;
51: function refresh_mv_kpi(
52: p_kpi varchar2,
53: p_apps_origin varchar2,
54: p_options BSC_IM_UTILS.varchar_tabletype,
55: p_number_options number
56: ) return boolean;
57: function drop_mv_kpi(
58: p_kpi varchar2,

Line 60: p_options BSC_IM_UTILS.varchar_tabletype,

56: ) return boolean;
57: function drop_mv_kpi(
58: p_kpi varchar2,
59: p_apps_origin varchar2,
60: p_options BSC_IM_UTILS.varchar_tabletype,
61: p_number_options number
62: ) return boolean;
63: function drop_summary_objects(
64: p_mv_list varchar2,

Line 72: p_parent_summary_mv out nocopy BSC_IM_UTILS.varchar_tabletype,

68: ) return boolean;
69: function get_ordered_mv_list(
70: p_kpi varchar2,
71: p_apps_origin varchar2,
72: p_parent_summary_mv out nocopy BSC_IM_UTILS.varchar_tabletype,
73: p_child_summary_mv out nocopy BSC_IM_UTILS.varchar_tabletype,
74: p_number_pc_mv out nocopy number,
75: p_ordered_summary_mv out nocopy BSC_IM_UTILS.varchar_tabletype,
76: p_ordered_summary_mv_rank out nocopy BSC_IM_UTILS.number_tabletype,

Line 73: p_child_summary_mv out nocopy BSC_IM_UTILS.varchar_tabletype,

69: function get_ordered_mv_list(
70: p_kpi varchar2,
71: p_apps_origin varchar2,
72: p_parent_summary_mv out nocopy BSC_IM_UTILS.varchar_tabletype,
73: p_child_summary_mv out nocopy BSC_IM_UTILS.varchar_tabletype,
74: p_number_pc_mv out nocopy number,
75: p_ordered_summary_mv out nocopy BSC_IM_UTILS.varchar_tabletype,
76: p_ordered_summary_mv_rank out nocopy BSC_IM_UTILS.number_tabletype,
77: p_number_ordered_summary_mv out nocopy number,

Line 75: p_ordered_summary_mv out nocopy BSC_IM_UTILS.varchar_tabletype,

71: p_apps_origin varchar2,
72: p_parent_summary_mv out nocopy BSC_IM_UTILS.varchar_tabletype,
73: p_child_summary_mv out nocopy BSC_IM_UTILS.varchar_tabletype,
74: p_number_pc_mv out nocopy number,
75: p_ordered_summary_mv out nocopy BSC_IM_UTILS.varchar_tabletype,
76: p_ordered_summary_mv_rank out nocopy BSC_IM_UTILS.number_tabletype,
77: p_number_ordered_summary_mv out nocopy number,
78: p_max_rank out nocopy number
79: )return boolean ;

Line 76: p_ordered_summary_mv_rank out nocopy BSC_IM_UTILS.number_tabletype,

72: p_parent_summary_mv out nocopy BSC_IM_UTILS.varchar_tabletype,
73: p_child_summary_mv out nocopy BSC_IM_UTILS.varchar_tabletype,
74: p_number_pc_mv out nocopy number,
75: p_ordered_summary_mv out nocopy BSC_IM_UTILS.varchar_tabletype,
76: p_ordered_summary_mv_rank out nocopy BSC_IM_UTILS.number_tabletype,
77: p_number_ordered_summary_mv out nocopy number,
78: p_max_rank out nocopy number
79: )return boolean ;
80: function create_dummy_mv(

Line 81: p_b_tables BSC_IM_UTILS.varchar_tabletype,

77: p_number_ordered_summary_mv out nocopy number,
78: p_max_rank out nocopy number
79: )return boolean ;
80: function create_dummy_mv(
81: p_b_tables BSC_IM_UTILS.varchar_tabletype,
82: p_number_b_tables number,
83: p_mv_name varchar2,
84: p_mv_owner varchar2
85: )return boolean;

Line 89: p_dummy_mv out nocopy BSC_IM_UTILS.varchar_tabletype,

85: )return boolean;
86: function get_dummy_mv(
87: p_mv_name varchar2,
88: p_mv_owner varchar2,
89: p_dummy_mv out nocopy BSC_IM_UTILS.varchar_tabletype,
90: p_number_dummy_mv out nocopy number
91: )return boolean ;
92: function create_mv_index(
93: p_mv_name varchar2,

Line 105: p_options BSC_IM_UTILS.varchar_tabletype,

101: )return boolean;
102: function refresh_mv(
103: p_mv varchar2,
104: p_kpi varchar2,
105: p_options BSC_IM_UTILS.varchar_tabletype,
106: p_number_options number
107: ) return boolean;
108: function drop_mv(
109: p_mv varchar2,

Line 110: p_options BSC_IM_UTILS.varchar_tabletype,

106: p_number_options number
107: ) return boolean;
108: function drop_mv(
109: p_mv varchar2,
110: p_options BSC_IM_UTILS.varchar_tabletype,
111: p_number_options number
112: )return boolean;
113: function create_zero_code_mv_kpi(
114: p_kpi varchar2,

Line 116: p_options BSC_IM_UTILS.varchar_tabletype,

112: )return boolean;
113: function create_zero_code_mv_kpi(
114: p_kpi varchar2,
115: p_apps_origin varchar2,
116: p_options BSC_IM_UTILS.varchar_tabletype,
117: p_number_options number,
118: p_max_rank number,
119: p_bsc_owner varchar2,
120: p_max_mv_levels number,

Line 121: p_ordered_summary_mv BSC_IM_UTILS.varchar_tabletype,

117: p_number_options number,
118: p_max_rank number,
119: p_bsc_owner varchar2,
120: p_max_mv_levels number,
121: p_ordered_summary_mv BSC_IM_UTILS.varchar_tabletype,
122: p_ordered_summary_mv_rank BSC_IM_UTILS.number_tabletype,
123: p_number_ordered_summary_mv number
124: ) return boolean ;
125: function object_index_validation(

Line 122: p_ordered_summary_mv_rank BSC_IM_UTILS.number_tabletype,

118: p_max_rank number,
119: p_bsc_owner varchar2,
120: p_max_mv_levels number,
121: p_ordered_summary_mv BSC_IM_UTILS.varchar_tabletype,
122: p_ordered_summary_mv_rank BSC_IM_UTILS.number_tabletype,
123: p_number_ordered_summary_mv number
124: ) return boolean ;
125: function object_index_validation(
126: p_object varchar2,

Line 130: p_options BSC_IM_UTILS.varchar_tabletype,

126: p_object varchar2,
127: p_owner varchar2,
128: p_kpi varchar2,
129: p_apps_origin varchar2,
130: p_options BSC_IM_UTILS.varchar_tabletype,
131: p_number_options number,
132: p_create_non_unique_index boolean
133: )return boolean;
134: function check_old_mv_view(

Line 138: p_options BSC_IM_UTILS.varchar_tabletype,

134: function check_old_mv_view(
135: p_mv_name varchar2,
136: p_mv_owner varchar2,
137: p_type varchar2,
138: p_options BSC_IM_UTILS.varchar_tabletype,
139: p_number_options number
140: )return varchar2;
141: --procedures-------------------------------------------------------
142: procedure write_to_log_file(p_message varchar2);