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_LOAD dependencies on BSC_AW_UTILITY

Line 16: bsc_aw_utility.g_options.delete;

12: p_dim_level_list dbms_sql.varchar2_table,
13: p_options varchar2
14: ) is
15: Begin
16: bsc_aw_utility.g_options.delete;
17: bsc_aw_utility.parse_parameter_values(p_options,',',bsc_aw_utility.g_options);
18: bsc_aw_utility.open_file('TEST');
19: bsc_aw_utility.dmp_g_options(bsc_aw_utility.g_options);
20: init_all;

Line 17: bsc_aw_utility.parse_parameter_values(p_options,',',bsc_aw_utility.g_options);

13: p_options varchar2
14: ) is
15: Begin
16: bsc_aw_utility.g_options.delete;
17: bsc_aw_utility.parse_parameter_values(p_options,',',bsc_aw_utility.g_options);
18: bsc_aw_utility.open_file('TEST');
19: bsc_aw_utility.dmp_g_options(bsc_aw_utility.g_options);
20: init_all;
21: bsc_aw_adapter.upgrade(p_options);/*serial across all processes. we call upgrade(p_options) to invoke workspace attach in that api*/

Line 18: bsc_aw_utility.open_file('TEST');

14: ) is
15: Begin
16: bsc_aw_utility.g_options.delete;
17: bsc_aw_utility.parse_parameter_values(p_options,',',bsc_aw_utility.g_options);
18: bsc_aw_utility.open_file('TEST');
19: bsc_aw_utility.dmp_g_options(bsc_aw_utility.g_options);
20: init_all;
21: bsc_aw_adapter.upgrade(p_options);/*serial across all processes. we call upgrade(p_options) to invoke workspace attach in that api*/
22: bsc_aw_load_dim.load_dim(p_dim_level_list);

Line 19: bsc_aw_utility.dmp_g_options(bsc_aw_utility.g_options);

15: Begin
16: bsc_aw_utility.g_options.delete;
17: bsc_aw_utility.parse_parameter_values(p_options,',',bsc_aw_utility.g_options);
18: bsc_aw_utility.open_file('TEST');
19: bsc_aw_utility.dmp_g_options(bsc_aw_utility.g_options);
20: init_all;
21: bsc_aw_adapter.upgrade(p_options);/*serial across all processes. we call upgrade(p_options) to invoke workspace attach in that api*/
22: bsc_aw_load_dim.load_dim(p_dim_level_list);
23: bsc_aw_management.detach_workspace;

Line 43: bsc_aw_utility.g_options.delete;

39: p_dim_level_list dbms_sql.varchar2_table,
40: p_options varchar2
41: ) is
42: Begin
43: bsc_aw_utility.g_options.delete;
44: bsc_aw_utility.parse_parameter_values(p_options,',',bsc_aw_utility.g_options);
45: bsc_aw_utility.open_file('TEST');
46: bsc_aw_utility.dmp_g_options(bsc_aw_utility.g_options);
47: init_all;

Line 44: bsc_aw_utility.parse_parameter_values(p_options,',',bsc_aw_utility.g_options);

40: p_options varchar2
41: ) is
42: Begin
43: bsc_aw_utility.g_options.delete;
44: bsc_aw_utility.parse_parameter_values(p_options,',',bsc_aw_utility.g_options);
45: bsc_aw_utility.open_file('TEST');
46: bsc_aw_utility.dmp_g_options(bsc_aw_utility.g_options);
47: init_all;
48: bsc_aw_load_dim.purge_dim(p_dim_level_list);

Line 45: bsc_aw_utility.open_file('TEST');

41: ) is
42: Begin
43: bsc_aw_utility.g_options.delete;
44: bsc_aw_utility.parse_parameter_values(p_options,',',bsc_aw_utility.g_options);
45: bsc_aw_utility.open_file('TEST');
46: bsc_aw_utility.dmp_g_options(bsc_aw_utility.g_options);
47: init_all;
48: bsc_aw_load_dim.purge_dim(p_dim_level_list);
49: bsc_aw_management.detach_workspace;

Line 46: bsc_aw_utility.dmp_g_options(bsc_aw_utility.g_options);

42: Begin
43: bsc_aw_utility.g_options.delete;
44: bsc_aw_utility.parse_parameter_values(p_options,',',bsc_aw_utility.g_options);
45: bsc_aw_utility.open_file('TEST');
46: bsc_aw_utility.dmp_g_options(bsc_aw_utility.g_options);
47: init_all;
48: bsc_aw_load_dim.purge_dim(p_dim_level_list);
49: bsc_aw_management.detach_workspace;
50: Exception when others then

Line 70: bsc_aw_utility.g_options.delete;

66: p_dim_level_list dbms_sql.varchar2_table,
67: p_options varchar2
68: ) is
69: Begin
70: bsc_aw_utility.g_options.delete;
71: bsc_aw_utility.parse_parameter_values(p_options,',',bsc_aw_utility.g_options);
72: bsc_aw_utility.open_file('TEST');
73: bsc_aw_utility.dmp_g_options(bsc_aw_utility.g_options);
74: init_all;

Line 71: bsc_aw_utility.parse_parameter_values(p_options,',',bsc_aw_utility.g_options);

67: p_options varchar2
68: ) is
69: Begin
70: bsc_aw_utility.g_options.delete;
71: bsc_aw_utility.parse_parameter_values(p_options,',',bsc_aw_utility.g_options);
72: bsc_aw_utility.open_file('TEST');
73: bsc_aw_utility.dmp_g_options(bsc_aw_utility.g_options);
74: init_all;
75: bsc_aw_management.get_workspace_lock('ro',null);

Line 72: bsc_aw_utility.open_file('TEST');

68: ) is
69: Begin
70: bsc_aw_utility.g_options.delete;
71: bsc_aw_utility.parse_parameter_values(p_options,',',bsc_aw_utility.g_options);
72: bsc_aw_utility.open_file('TEST');
73: bsc_aw_utility.dmp_g_options(bsc_aw_utility.g_options);
74: init_all;
75: bsc_aw_management.get_workspace_lock('ro',null);
76: bsc_aw_load_dim.dmp_dim_level_into_table(p_dim_level_list);

Line 73: bsc_aw_utility.dmp_g_options(bsc_aw_utility.g_options);

69: Begin
70: bsc_aw_utility.g_options.delete;
71: bsc_aw_utility.parse_parameter_values(p_options,',',bsc_aw_utility.g_options);
72: bsc_aw_utility.open_file('TEST');
73: bsc_aw_utility.dmp_g_options(bsc_aw_utility.g_options);
74: init_all;
75: bsc_aw_management.get_workspace_lock('ro',null);
76: bsc_aw_load_dim.dmp_dim_level_into_table(p_dim_level_list);
77: bsc_aw_management.detach_workspace;

Line 96: bsc_aw_utility.g_options.delete;

92: p_kpi_list dbms_sql.varchar2_table,
93: p_options varchar2
94: ) is
95: Begin
96: bsc_aw_utility.g_options.delete;
97: bsc_aw_utility.parse_parameter_values(p_options,',',bsc_aw_utility.g_options);
98: bsc_aw_utility.open_file('TEST');
99: bsc_aw_utility.dmp_g_options(bsc_aw_utility.g_options);
100: init_all;

Line 97: bsc_aw_utility.parse_parameter_values(p_options,',',bsc_aw_utility.g_options);

93: p_options varchar2
94: ) is
95: Begin
96: bsc_aw_utility.g_options.delete;
97: bsc_aw_utility.parse_parameter_values(p_options,',',bsc_aw_utility.g_options);
98: bsc_aw_utility.open_file('TEST');
99: bsc_aw_utility.dmp_g_options(bsc_aw_utility.g_options);
100: init_all;
101: bsc_aw_adapter.upgrade(p_options);/*serial across all processes*/

Line 98: bsc_aw_utility.open_file('TEST');

94: ) is
95: Begin
96: bsc_aw_utility.g_options.delete;
97: bsc_aw_utility.parse_parameter_values(p_options,',',bsc_aw_utility.g_options);
98: bsc_aw_utility.open_file('TEST');
99: bsc_aw_utility.dmp_g_options(bsc_aw_utility.g_options);
100: init_all;
101: bsc_aw_adapter.upgrade(p_options);/*serial across all processes*/
102: bsc_aw_load_kpi.load_kpi(p_kpi_list);

Line 99: bsc_aw_utility.dmp_g_options(bsc_aw_utility.g_options);

95: Begin
96: bsc_aw_utility.g_options.delete;
97: bsc_aw_utility.parse_parameter_values(p_options,',',bsc_aw_utility.g_options);
98: bsc_aw_utility.open_file('TEST');
99: bsc_aw_utility.dmp_g_options(bsc_aw_utility.g_options);
100: init_all;
101: bsc_aw_adapter.upgrade(p_options);/*serial across all processes*/
102: bsc_aw_load_kpi.load_kpi(p_kpi_list);
103: bsc_aw_management.detach_workspace;

Line 123: bsc_aw_utility.g_options.delete;

119: p_kpi_list dbms_sql.varchar2_table,
120: p_options varchar2
121: ) is
122: Begin
123: bsc_aw_utility.g_options.delete;
124: bsc_aw_utility.parse_parameter_values(p_options,',',bsc_aw_utility.g_options);
125: bsc_aw_utility.open_file('TEST');
126: bsc_aw_utility.dmp_g_options(bsc_aw_utility.g_options);
127: init_all;

Line 124: bsc_aw_utility.parse_parameter_values(p_options,',',bsc_aw_utility.g_options);

120: p_options varchar2
121: ) is
122: Begin
123: bsc_aw_utility.g_options.delete;
124: bsc_aw_utility.parse_parameter_values(p_options,',',bsc_aw_utility.g_options);
125: bsc_aw_utility.open_file('TEST');
126: bsc_aw_utility.dmp_g_options(bsc_aw_utility.g_options);
127: init_all;
128: bsc_aw_adapter.upgrade(p_options);/*serial across all processes*/

Line 125: bsc_aw_utility.open_file('TEST');

121: ) is
122: Begin
123: bsc_aw_utility.g_options.delete;
124: bsc_aw_utility.parse_parameter_values(p_options,',',bsc_aw_utility.g_options);
125: bsc_aw_utility.open_file('TEST');
126: bsc_aw_utility.dmp_g_options(bsc_aw_utility.g_options);
127: init_all;
128: bsc_aw_adapter.upgrade(p_options);/*serial across all processes*/
129: bsc_aw_load_kpi.load_base_table(p_base_table_list,p_kpi_list);

Line 126: bsc_aw_utility.dmp_g_options(bsc_aw_utility.g_options);

122: Begin
123: bsc_aw_utility.g_options.delete;
124: bsc_aw_utility.parse_parameter_values(p_options,',',bsc_aw_utility.g_options);
125: bsc_aw_utility.open_file('TEST');
126: bsc_aw_utility.dmp_g_options(bsc_aw_utility.g_options);
127: init_all;
128: bsc_aw_adapter.upgrade(p_options);/*serial across all processes*/
129: bsc_aw_load_kpi.load_base_table(p_base_table_list,p_kpi_list);
130: bsc_aw_management.detach_workspace;

Line 140: bsc_aw_utility.g_options.delete;

136: End;
137:
138: procedure purge_kpi(p_kpi varchar2,p_options varchar2) is
139: Begin
140: bsc_aw_utility.g_options.delete;
141: bsc_aw_utility.parse_parameter_values(p_options,',',bsc_aw_utility.g_options);
142: bsc_aw_utility.open_file('TEST');
143: bsc_aw_utility.dmp_g_options(bsc_aw_utility.g_options);
144: init_all;

Line 141: bsc_aw_utility.parse_parameter_values(p_options,',',bsc_aw_utility.g_options);

137:
138: procedure purge_kpi(p_kpi varchar2,p_options varchar2) is
139: Begin
140: bsc_aw_utility.g_options.delete;
141: bsc_aw_utility.parse_parameter_values(p_options,',',bsc_aw_utility.g_options);
142: bsc_aw_utility.open_file('TEST');
143: bsc_aw_utility.dmp_g_options(bsc_aw_utility.g_options);
144: init_all;
145: bsc_aw_load_kpi.purge_kpi(p_kpi);

Line 142: bsc_aw_utility.open_file('TEST');

138: procedure purge_kpi(p_kpi varchar2,p_options varchar2) is
139: Begin
140: bsc_aw_utility.g_options.delete;
141: bsc_aw_utility.parse_parameter_values(p_options,',',bsc_aw_utility.g_options);
142: bsc_aw_utility.open_file('TEST');
143: bsc_aw_utility.dmp_g_options(bsc_aw_utility.g_options);
144: init_all;
145: bsc_aw_load_kpi.purge_kpi(p_kpi);
146: bsc_aw_management.detach_workspace;

Line 143: bsc_aw_utility.dmp_g_options(bsc_aw_utility.g_options);

139: Begin
140: bsc_aw_utility.g_options.delete;
141: bsc_aw_utility.parse_parameter_values(p_options,',',bsc_aw_utility.g_options);
142: bsc_aw_utility.open_file('TEST');
143: bsc_aw_utility.dmp_g_options(bsc_aw_utility.g_options);
144: init_all;
145: bsc_aw_load_kpi.purge_kpi(p_kpi);
146: bsc_aw_management.detach_workspace;
147: Exception when others then

Line 165: bsc_aw_utility.g_options.delete;

161: p_options varchar2,
162: p_tables out nocopy dbms_sql.varchar2_table
163: ) is
164: Begin
165: bsc_aw_utility.g_options.delete;
166: bsc_aw_utility.parse_parameter_values(p_options,',',bsc_aw_utility.g_options);
167: bsc_aw_utility.open_file('TEST');
168: bsc_aw_utility.dmp_g_options(bsc_aw_utility.g_options);
169: init_all;

Line 166: bsc_aw_utility.parse_parameter_values(p_options,',',bsc_aw_utility.g_options);

162: p_tables out nocopy dbms_sql.varchar2_table
163: ) is
164: Begin
165: bsc_aw_utility.g_options.delete;
166: bsc_aw_utility.parse_parameter_values(p_options,',',bsc_aw_utility.g_options);
167: bsc_aw_utility.open_file('TEST');
168: bsc_aw_utility.dmp_g_options(bsc_aw_utility.g_options);
169: init_all;
170: --read lock only

Line 167: bsc_aw_utility.open_file('TEST');

163: ) is
164: Begin
165: bsc_aw_utility.g_options.delete;
166: bsc_aw_utility.parse_parameter_values(p_options,',',bsc_aw_utility.g_options);
167: bsc_aw_utility.open_file('TEST');
168: bsc_aw_utility.dmp_g_options(bsc_aw_utility.g_options);
169: init_all;
170: --read lock only
171: bsc_aw_management.get_workspace_lock('ro',null);

Line 168: bsc_aw_utility.dmp_g_options(bsc_aw_utility.g_options);

164: Begin
165: bsc_aw_utility.g_options.delete;
166: bsc_aw_utility.parse_parameter_values(p_options,',',bsc_aw_utility.g_options);
167: bsc_aw_utility.open_file('TEST');
168: bsc_aw_utility.dmp_g_options(bsc_aw_utility.g_options);
169: init_all;
170: --read lock only
171: bsc_aw_management.get_workspace_lock('ro',null);
172: bsc_aw_load_kpi.dmp_kpi_cubes_into_table(p_kpi,p_table_name,p_tables);

Line 188: bsc_aw_utility.g_options.delete;

184: p_dim_levels dbms_sql.varchar2_table,
185: p_table_name varchar2,
186: p_options varchar2) is
187: Begin
188: bsc_aw_utility.g_options.delete;
189: bsc_aw_utility.parse_parameter_values(p_options,',',bsc_aw_utility.g_options);
190: bsc_aw_utility.open_file('TEST');
191: bsc_aw_utility.dmp_g_options(bsc_aw_utility.g_options);
192: init_all;

Line 189: bsc_aw_utility.parse_parameter_values(p_options,',',bsc_aw_utility.g_options);

185: p_table_name varchar2,
186: p_options varchar2) is
187: Begin
188: bsc_aw_utility.g_options.delete;
189: bsc_aw_utility.parse_parameter_values(p_options,',',bsc_aw_utility.g_options);
190: bsc_aw_utility.open_file('TEST');
191: bsc_aw_utility.dmp_g_options(bsc_aw_utility.g_options);
192: init_all;
193: --read lock only

Line 190: bsc_aw_utility.open_file('TEST');

186: p_options varchar2) is
187: Begin
188: bsc_aw_utility.g_options.delete;
189: bsc_aw_utility.parse_parameter_values(p_options,',',bsc_aw_utility.g_options);
190: bsc_aw_utility.open_file('TEST');
191: bsc_aw_utility.dmp_g_options(bsc_aw_utility.g_options);
192: init_all;
193: --read lock only
194: bsc_aw_management.get_workspace_lock('ro',null);

Line 191: bsc_aw_utility.dmp_g_options(bsc_aw_utility.g_options);

187: Begin
188: bsc_aw_utility.g_options.delete;
189: bsc_aw_utility.parse_parameter_values(p_options,',',bsc_aw_utility.g_options);
190: bsc_aw_utility.open_file('TEST');
191: bsc_aw_utility.dmp_g_options(bsc_aw_utility.g_options);
192: init_all;
193: --read lock only
194: bsc_aw_management.get_workspace_lock('ro',null);
195: bsc_aw_load_kpi.dmp_kpi_cubes_into_table(p_kpi,p_dimset,p_dim_levels,p_table_name);

Line 277: if bsc_aw_utility.get_parameter_value(bsc_aw_utility.g_options,'DEBUG LOG')='Y'

273:
274: --------------------------------------------------------
275: procedure init_all is
276: Begin
277: if bsc_aw_utility.get_parameter_value(bsc_aw_utility.g_options,'DEBUG LOG')='Y'
278: or bsc_aw_utility.g_log_level>=FND_LOG.G_CURRENT_RUNTIME_LEVEL then
279: g_debug:=true;
280: else
281: g_debug:=false;

Line 278: or bsc_aw_utility.g_log_level>=FND_LOG.G_CURRENT_RUNTIME_LEVEL then

274: --------------------------------------------------------
275: procedure init_all is
276: Begin
277: if bsc_aw_utility.get_parameter_value(bsc_aw_utility.g_options,'DEBUG LOG')='Y'
278: or bsc_aw_utility.g_log_level>=FND_LOG.G_CURRENT_RUNTIME_LEVEL then
279: g_debug:=true;
280: else
281: g_debug:=false;
282: end if;

Line 283: bsc_aw_utility.init_all(g_debug);

279: g_debug:=true;
280: else
281: g_debug:=false;
282: end if;
283: bsc_aw_utility.init_all(g_debug);
284: bsc_aw_load_dim.init_all;
285: bsc_aw_load_kpi.init_all;
286: bsc_aw_dbms_aw.init_all;
287: bsc_aw_md_api.init_all;

Line 297: bsc_aw_utility.log(p_message);

293: End;
294:
295: procedure log(p_message varchar2) is
296: Begin
297: bsc_aw_utility.log(p_message);
298: Exception when others then
299: null;
300: End;
301: