APPS.MSC_HP_UTIL dependencies on MSC_HP_UTIL

Line 1: package body msc_hp_util as

1: package body msc_hp_util as
2: /* $Header: MSCPCUTB.pls 120.0.12020000.3 2012/11/02 17:38:37 wexia noship $ */
3: g_page_size number := 10;
4: g_max_fetch_size number := 100;
5: g_fetch_size number := g_max_fetch_size;

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 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 277: end msc_hp_util;

273: prepare_col_dtls(p_plan_id, 1);
274: end if;
275:
276: end sync_ui_data;
277: end msc_hp_util;