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.MSC_HP_UTIL dependencies on MSC_PHUB_UTIL

Line 29: msc_phub_util.log('msc_hp_util.prepare_col_dtls('||p_plan_id||')');

25: is
26: l_calendar_code varchar2(20);
27: l_n number;
28: begin
29: msc_phub_util.log('msc_hp_util.prepare_col_dtls('||p_plan_id||')');
30: l_calendar_code := get_calendar_code(p_plan_id);
31: if (l_calendar_code is null) then
32: return;
33: end if;

Line 37: msc_phub_util.log('delete from msc_hp_col_dtls: '||sql%rowcount);

33: end if;
34:
35: if (p_refresh = 1) then
36: delete from msc_hp_col_dtls where plan_id=p_plan_id;
37: msc_phub_util.log('delete from msc_hp_col_dtls: '||sql%rowcount);
38: commit;
39: else
40: select count(*) into l_n
41: from msc_hp_col_dtls

Line 185: msc_phub_util.log('insert into msc_hp_col_dtls: '||sql%rowcount);

181: fnd_global.user_id, sysdate,
182: sysdate, fnd_global.user_id, fnd_global.login_id
183: from m
184: order by bucket_index;
185: msc_phub_util.log('insert into msc_hp_col_dtls: '||sql%rowcount);
186: commit;
187:
188: end prepare_col_dtls;
189:

Line 196: msc_phub_util.log('msc_hp_util.prepare_filters('||p_query_id||', '||p_filter_type||')');

192: i number;
193: s varchar2(5000) := p_filters||',';
194: t varchar2(5000);
195: begin
196: msc_phub_util.log('msc_hp_util.prepare_filters('||p_query_id||', '||p_filter_type||')');
197: i := instr(s, ',');
198: while nvl(i, 0) > 0 loop
199: t := trim(substr(s, 1, i - 1));
200: if (length(t) > 0) then

Line 246: msc_phub_util.log('msc_hp_util.sync_ui_data('||p_plan_id||','||p_mode||')');

242:
243: procedure sync_ui_data(p_plan_id number, p_mode number)
244: is
245: begin
246: msc_phub_util.log('msc_hp_util.sync_ui_data('||p_plan_id||','||p_mode||')');
247:
248: delete from msc_matl_plan_data where query_id in (select query_id from msc_hp_row_dtls where plan_id=p_plan_id);
249: msc_phub_util.log('delete from msc_matl_plan_data: '||sql%rowcount);
250: commit;

Line 249: msc_phub_util.log('delete from msc_matl_plan_data: '||sql%rowcount);

245: begin
246: msc_phub_util.log('msc_hp_util.sync_ui_data('||p_plan_id||','||p_mode||')');
247:
248: delete from msc_matl_plan_data where query_id in (select query_id from msc_hp_row_dtls where plan_id=p_plan_id);
249: msc_phub_util.log('delete from msc_matl_plan_data: '||sql%rowcount);
250: commit;
251:
252: delete from msc_res_plan_data where query_id in (select query_id from msc_hp_row_dtls where plan_id=p_plan_id);
253: msc_phub_util.log('delete from msc_res_plan_data: '||sql%rowcount);

Line 253: msc_phub_util.log('delete from msc_res_plan_data: '||sql%rowcount);

249: msc_phub_util.log('delete from msc_matl_plan_data: '||sql%rowcount);
250: commit;
251:
252: delete from msc_res_plan_data where query_id in (select query_id from msc_hp_row_dtls where plan_id=p_plan_id);
253: msc_phub_util.log('delete from msc_res_plan_data: '||sql%rowcount);
254: commit;
255:
256: delete from msc_hp_updates where query_id in (select query_id from msc_hp_row_dtls where plan_id=p_plan_id);
257: msc_phub_util.log('delete from msc_hp_updates: '||sql%rowcount);

Line 257: msc_phub_util.log('delete from msc_hp_updates: '||sql%rowcount);

253: msc_phub_util.log('delete from msc_res_plan_data: '||sql%rowcount);
254: commit;
255:
256: delete from msc_hp_updates where query_id in (select query_id from msc_hp_row_dtls where plan_id=p_plan_id);
257: msc_phub_util.log('delete from msc_hp_updates: '||sql%rowcount);
258: commit;
259:
260: delete from msc_res_plan_updates where query_id in (select query_id from msc_hp_row_dtls where plan_id=p_plan_id);
261: msc_phub_util.log('delete from msc_res_plan_updates: '||sql%rowcount);

Line 261: msc_phub_util.log('delete from msc_res_plan_updates: '||sql%rowcount);

257: msc_phub_util.log('delete from msc_hp_updates: '||sql%rowcount);
258: commit;
259:
260: delete from msc_res_plan_updates where query_id in (select query_id from msc_hp_row_dtls where plan_id=p_plan_id);
261: msc_phub_util.log('delete from msc_res_plan_updates: '||sql%rowcount);
262: commit;
263:
264: delete from msc_hp_row_dtls where plan_id=p_plan_id;
265: msc_phub_util.log('delete from msc_hp_row_dtls: '||sql%rowcount);

Line 265: msc_phub_util.log('delete from msc_hp_row_dtls: '||sql%rowcount);

261: msc_phub_util.log('delete from msc_res_plan_updates: '||sql%rowcount);
262: commit;
263:
264: delete from msc_hp_row_dtls where plan_id=p_plan_id;
265: msc_phub_util.log('delete from msc_hp_row_dtls: '||sql%rowcount);
266: commit;
267:
268: delete from msc_hp_col_dtls where plan_id=p_plan_id;
269: msc_phub_util.log('delete from msc_hp_col_dtls: '||sql%rowcount);

Line 269: msc_phub_util.log('delete from msc_hp_col_dtls: '||sql%rowcount);

265: msc_phub_util.log('delete from msc_hp_row_dtls: '||sql%rowcount);
266: commit;
267:
268: delete from msc_hp_col_dtls where plan_id=p_plan_id;
269: msc_phub_util.log('delete from msc_hp_col_dtls: '||sql%rowcount);
270: commit;
271:
272: if (p_mode = sync_launch) then
273: prepare_col_dtls(p_plan_id, 1);