APPS.MSC_RES_PLAN_PKG dependencies on MSC_RES_PLAN_PKG

Line 1: package body msc_res_plan_pkg as

1: package body msc_res_plan_pkg as
2: /* $Header: MSCPCRHB.pls 120.0.12020000.2 2012/10/10 15:29:55 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 23: msc_phub_util.log('msc_res_plan_pkg.prepare_row_dtls('||p_query_id||', '||p_plan_id||

19: l_dept_filter_cnt number;
20: l_res_filter_cnt number;
21: l_exception_filter_cnt number;
22: begin
23: msc_phub_util.log('msc_res_plan_pkg.prepare_row_dtls('||p_query_id||', '||p_plan_id||
24: ','||p_page_size||')');
25:
26: delete from msc_form_query where query_id = p_query_id;
27: msc_phub_util.log('delete from msc_form_query: '||sql%rowcount);

Line 257: msc_phub_util.log('msc_res_plan_pkg.populate_data('||p_query_id||', '||p_summary||')');

253: l_constrained_plan number := null;
254: l_plan_id number;
255: l_past_date date;
256: begin
257: msc_phub_util.log('msc_res_plan_pkg.populate_data('||p_query_id||', '||p_summary||')');
258:
259: begin
260: select h.plan_id, b.bkt_start_date
261: into l_plan_id, l_past_date

Line 554: msc_phub_util.log('msc_res_plan_pkg.summarize_data('||p_query_id||')');

550:
551: procedure summarize_data(p_query_id number)
552: is
553: begin
554: msc_phub_util.log('msc_res_plan_pkg.summarize_data('||p_query_id||')');
555:
556: update msc_hp_row_dtls
557: set data_flag = 3
558: where query_id = p_query_id

Line 577: msc_phub_util.log('msc_res_plan_pkg.initialize_data('||p_query_id||', '||p_plan_id||

573: p_item_filters varchar2,
574: p_page_size number)
575: is
576: begin
577: msc_phub_util.log('msc_res_plan_pkg.initialize_data('||p_query_id||', '||p_plan_id||
578: ','||p_page_size||')');
579:
580: msc_hp_util.prepare_col_dtls(p_plan_id, 2);
581:

Line 597: msc_phub_util.log('msc_res_plan_pkg.fetch_data('||p_query_id||', '||p_row_index||')');

593: procedure fetch_data(p_query_id number, p_row_index number)
594: is
595: l_n number;
596: begin
597: msc_phub_util.log('msc_res_plan_pkg.fetch_data('||p_query_id||', '||p_row_index||')');
598:
599: select count(*) into l_n
600: from msc_hp_row_dtls
601: where query_id = p_query_id

Line 699: msc_phub_util.log('msc_res_plan_pkg.recalculate('||p_query_id||')');

695: l_total_capacity number;
696: l_new_to_time2 date;
697: l_new_from_time2 date;
698: begin
699: msc_phub_util.log('msc_res_plan_pkg.recalculate('||p_query_id||')');
700: l_calendar_code := msc_hp_util.get_calendar_code(msc_hp_util.get_plan_id(p_query_id));
701:
702: for ru in cu loop
703: -- prepare staging table

Line 1119: msc_phub_util.log('msc_res_plan_pkg.close_data('||p_query_id||')');

1115:
1116: procedure close_data(p_query_id number)
1117: is
1118: begin
1119: msc_phub_util.log('msc_res_plan_pkg.close_data('||p_query_id||')');
1120:
1121: delete from msc_hp_row_dtls where query_id = p_query_id;
1122: msc_phub_util.log('delete from msc_hp_row_dtls: '||sql%rowcount);
1123: commit;

Line 1201: msc_phub_util.log('msc_res_plan_pkg.save_changes('||p_query_id||')');

1197: for update nowait;
1198:
1199: l_n number;
1200: begin
1201: msc_phub_util.log('msc_res_plan_pkg.save_changes('||p_query_id||')');
1202:
1203: for r3 in c3 loop
1204: msc_phub_util.log('r3.transaction_id='||r3.transaction_id||', r3.parent_id='||r3.parent_id);
1205:

Line 1346: end msc_res_plan_pkg;

1342:
1343:
1344: end save_changes;
1345:
1346: end msc_res_plan_pkg;