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.

[Home] [Help]

APPS.MSC_RES_PLAN_PKG dependencies on MSC_HP_UTIL

Line 30: msc_hp_util.prepare_filters(p_query_id, msc_hp_util.ft_organization, p_organization_filters);

26: delete from msc_form_query where query_id = p_query_id;
27: msc_phub_util.log('delete from msc_form_query: '||sql%rowcount);
28: commit;
29:
30: msc_hp_util.prepare_filters(p_query_id, msc_hp_util.ft_organization, p_organization_filters);
31: msc_hp_util.prepare_filters(p_query_id, msc_hp_util.ft_department, p_department_filters);
32: msc_hp_util.prepare_filters(p_query_id, msc_hp_util.ft_resource, p_resource_filters);
33: msc_hp_util.prepare_filters(p_query_id, msc_hp_util.ft_exception, p_exception_filters);
34: msc_hp_util.prepare_filters(p_query_id, msc_hp_util.ft_item, p_item_filters);

Line 31: msc_hp_util.prepare_filters(p_query_id, msc_hp_util.ft_department, p_department_filters);

27: msc_phub_util.log('delete from msc_form_query: '||sql%rowcount);
28: commit;
29:
30: msc_hp_util.prepare_filters(p_query_id, msc_hp_util.ft_organization, p_organization_filters);
31: msc_hp_util.prepare_filters(p_query_id, msc_hp_util.ft_department, p_department_filters);
32: msc_hp_util.prepare_filters(p_query_id, msc_hp_util.ft_resource, p_resource_filters);
33: msc_hp_util.prepare_filters(p_query_id, msc_hp_util.ft_exception, p_exception_filters);
34: msc_hp_util.prepare_filters(p_query_id, msc_hp_util.ft_item, p_item_filters);
35:

Line 32: msc_hp_util.prepare_filters(p_query_id, msc_hp_util.ft_resource, p_resource_filters);

28: commit;
29:
30: msc_hp_util.prepare_filters(p_query_id, msc_hp_util.ft_organization, p_organization_filters);
31: msc_hp_util.prepare_filters(p_query_id, msc_hp_util.ft_department, p_department_filters);
32: msc_hp_util.prepare_filters(p_query_id, msc_hp_util.ft_resource, p_resource_filters);
33: msc_hp_util.prepare_filters(p_query_id, msc_hp_util.ft_exception, p_exception_filters);
34: msc_hp_util.prepare_filters(p_query_id, msc_hp_util.ft_item, p_item_filters);
35:
36: select count(*)

Line 33: msc_hp_util.prepare_filters(p_query_id, msc_hp_util.ft_exception, p_exception_filters);

29:
30: msc_hp_util.prepare_filters(p_query_id, msc_hp_util.ft_organization, p_organization_filters);
31: msc_hp_util.prepare_filters(p_query_id, msc_hp_util.ft_department, p_department_filters);
32: msc_hp_util.prepare_filters(p_query_id, msc_hp_util.ft_resource, p_resource_filters);
33: msc_hp_util.prepare_filters(p_query_id, msc_hp_util.ft_exception, p_exception_filters);
34: msc_hp_util.prepare_filters(p_query_id, msc_hp_util.ft_item, p_item_filters);
35:
36: select count(*)
37: into l_org_filter_cnt

Line 34: msc_hp_util.prepare_filters(p_query_id, msc_hp_util.ft_item, p_item_filters);

30: msc_hp_util.prepare_filters(p_query_id, msc_hp_util.ft_organization, p_organization_filters);
31: msc_hp_util.prepare_filters(p_query_id, msc_hp_util.ft_department, p_department_filters);
32: msc_hp_util.prepare_filters(p_query_id, msc_hp_util.ft_resource, p_resource_filters);
33: msc_hp_util.prepare_filters(p_query_id, msc_hp_util.ft_exception, p_exception_filters);
34: msc_hp_util.prepare_filters(p_query_id, msc_hp_util.ft_item, p_item_filters);
35:
36: select count(*)
37: into l_org_filter_cnt
38: from msc_form_query

Line 39: where query_id = p_query_id and number1 = msc_hp_util.ft_organization;

35:
36: select count(*)
37: into l_org_filter_cnt
38: from msc_form_query
39: where query_id = p_query_id and number1 = msc_hp_util.ft_organization;
40:
41: select count(*)
42: into l_dept_filter_cnt
43: from msc_form_query

Line 44: where query_id = p_query_id and number1 = msc_hp_util.ft_department;

40:
41: select count(*)
42: into l_dept_filter_cnt
43: from msc_form_query
44: where query_id = p_query_id and number1 = msc_hp_util.ft_department;
45:
46: select count(*)
47: into l_res_filter_cnt
48: from msc_form_query

Line 49: where query_id = p_query_id and number1 = msc_hp_util.ft_resource;

45:
46: select count(*)
47: into l_res_filter_cnt
48: from msc_form_query
49: where query_id = p_query_id and number1 = msc_hp_util.ft_resource;
50:
51: select count(*)
52: into l_exception_filter_cnt
53: from msc_form_query

Line 54: where query_id = p_query_id and number1 = msc_hp_util.ft_exception and number2 in (24,26);

50:
51: select count(*)
52: into l_exception_filter_cnt
53: from msc_form_query
54: where query_id = p_query_id and number1 = msc_hp_util.ft_exception and number2 in (24,26);
55:
56: select count(*)
57: into l_item_filter_cnt
58: from msc_form_query

Line 59: where query_id = p_query_id and number1 = msc_hp_util.ft_item;

55:
56: select count(*)
57: into l_item_filter_cnt
58: from msc_form_query
59: where query_id = p_query_id and number1 = msc_hp_util.ft_item;
60:
61: msc_phub_util.log('l_org_filter_cnt = '||l_org_filter_cnt||', '||
62: 'l_dept_filter_cnt = '||l_dept_filter_cnt||', '||
63: 'l_res_filter_cnt = '||l_res_filter_cnt||', '||

Line 76: msc_hp_util.ft_end_pegging,

72: insert into msc_form_query(query_id, number1, number2, number3,
73: created_by, creation_date, last_update_date, last_updated_by, last_update_login)
74: select /*+ ordered */
75: p_query_id,
76: msc_hp_util.ft_end_pegging,
77: mfp1.sr_instance_id,
78: mfp1.end_pegging_id,
79: fnd_global.user_id, sysdate,
80: sysdate, fnd_global.user_id, fnd_global.login_id

Line 93: and q.number1 = msc_hp_util.ft_exception

89: and mfp1.plan_id = med1.plan_id
90: and mfp1.demand_id = med1.number1
91: and med1.exception_type = q.number2
92: and q.query_id = p_query_id
93: and q.number1 = msc_hp_util.ft_exception
94: and q.number2 in (24,26)
95: and mfp1.sr_instance_id = mtp1.sr_instance_id
96: and mfp1.organization_id = mtp1.sr_tp_id
97: and mtp1.partner_type = 3

Line 98: and (l_org_filter_cnt = 0 or mtp1.organization_code in (select char1 from msc_form_query where query_id = p_query_id and number1 = msc_hp_util.ft_organization))

94: and q.number2 in (24,26)
95: and mfp1.sr_instance_id = mtp1.sr_instance_id
96: and mfp1.organization_id = mtp1.sr_tp_id
97: and mtp1.partner_type = 3
98: and (l_org_filter_cnt = 0 or mtp1.organization_code in (select char1 from msc_form_query where query_id = p_query_id and number1 = msc_hp_util.ft_organization))
99: and (l_item_filter_cnt = 0 or mfp1.inventory_item_id in (select number2 from msc_form_query where query_id = p_query_id and number1 = msc_hp_util.ft_item));
100: msc_phub_util.log('insert into msc_form_query: '||sql%rowcount);
101: commit;
102:

Line 99: and (l_item_filter_cnt = 0 or mfp1.inventory_item_id in (select number2 from msc_form_query where query_id = p_query_id and number1 = msc_hp_util.ft_item));

95: and mfp1.sr_instance_id = mtp1.sr_instance_id
96: and mfp1.organization_id = mtp1.sr_tp_id
97: and mtp1.partner_type = 3
98: and (l_org_filter_cnt = 0 or mtp1.organization_code in (select char1 from msc_form_query where query_id = p_query_id and number1 = msc_hp_util.ft_organization))
99: and (l_item_filter_cnt = 0 or mfp1.inventory_item_id in (select number2 from msc_form_query where query_id = p_query_id and number1 = msc_hp_util.ft_item));
100: msc_phub_util.log('insert into msc_form_query: '||sql%rowcount);
101: commit;
102:
103: insert into msc_hp_row_dtls(

Line 165: and q.number1 = msc_hp_util.ft_end_pegging

161: msc_form_query q,
162: msc_trading_partners mtp2,
163: msc_department_resources mdp
164: where q.query_id = p_query_id
165: and q.number1 = msc_hp_util.ft_end_pegging
166: and r.sr_instance_id = q.number2
167: and r.end_pegging_id = q.number3
168: and r.plan_id = med2.plan_id
169: and r.transaction_id = med2.number1

Line 180: and (l_dept_filter_cnt = 0 or mdp.department_code in (select char1 from msc_form_query where query_id = p_query_id and number1 = msc_hp_util.ft_department))

176: and r.sr_instance_id = mdp.sr_instance_id
177: and r.organization_id = mdp.organization_id
178: and r.department_id = mdp.department_id
179: and r.resource_id = mdp.resource_id
180: and (l_dept_filter_cnt = 0 or mdp.department_code in (select char1 from msc_form_query where query_id = p_query_id and number1 = msc_hp_util.ft_department))
181: and (l_res_filter_cnt = 0 or mdp.resource_code in (select char1 from msc_form_query where query_id = p_query_id and number1 = msc_hp_util.ft_resource))
182: ) t;
183: msc_phub_util.log('insert into msc_hp_row_dtls: '||sql%rowcount);
184: commit;

Line 181: and (l_res_filter_cnt = 0 or mdp.resource_code in (select char1 from msc_form_query where query_id = p_query_id and number1 = msc_hp_util.ft_resource))

177: and r.organization_id = mdp.organization_id
178: and r.department_id = mdp.department_id
179: and r.resource_id = mdp.resource_id
180: and (l_dept_filter_cnt = 0 or mdp.department_code in (select char1 from msc_form_query where query_id = p_query_id and number1 = msc_hp_util.ft_department))
181: and (l_res_filter_cnt = 0 or mdp.resource_code in (select char1 from msc_form_query where query_id = p_query_id and number1 = msc_hp_util.ft_resource))
182: ) t;
183: msc_phub_util.log('insert into msc_hp_row_dtls: '||sql%rowcount);
184: commit;
185: else

Line 222: and (l_org_filter_cnt = 0 or mtp.organization_code in (select char1 from msc_form_query where query_id = p_query_id and number1 = msc_hp_util.ft_organization))

218: and mdp.sr_instance_id = mtp.sr_instance_id
219: and mdp.organization_id = mtp.sr_tp_id
220: and mtp.partner_type = 3
221: and mdp.resource_id > 0
222: and (l_org_filter_cnt = 0 or mtp.organization_code in (select char1 from msc_form_query where query_id = p_query_id and number1 = msc_hp_util.ft_organization))
223: and (l_dept_filter_cnt = 0 or mdp.department_code in (select char1 from msc_form_query where query_id = p_query_id and number1 = msc_hp_util.ft_department))
224: and (l_res_filter_cnt = 0 or mdp.resource_code in (select char1 from msc_form_query where query_id = p_query_id and number1 = msc_hp_util.ft_resource));
225: msc_phub_util.log('insert into msc_hp_row_dtls: '||sql%rowcount);
226: commit;

Line 223: and (l_dept_filter_cnt = 0 or mdp.department_code in (select char1 from msc_form_query where query_id = p_query_id and number1 = msc_hp_util.ft_department))

219: and mdp.organization_id = mtp.sr_tp_id
220: and mtp.partner_type = 3
221: and mdp.resource_id > 0
222: and (l_org_filter_cnt = 0 or mtp.organization_code in (select char1 from msc_form_query where query_id = p_query_id and number1 = msc_hp_util.ft_organization))
223: and (l_dept_filter_cnt = 0 or mdp.department_code in (select char1 from msc_form_query where query_id = p_query_id and number1 = msc_hp_util.ft_department))
224: and (l_res_filter_cnt = 0 or mdp.resource_code in (select char1 from msc_form_query where query_id = p_query_id and number1 = msc_hp_util.ft_resource));
225: msc_phub_util.log('insert into msc_hp_row_dtls: '||sql%rowcount);
226: commit;
227: end if;

Line 224: and (l_res_filter_cnt = 0 or mdp.resource_code in (select char1 from msc_form_query where query_id = p_query_id and number1 = msc_hp_util.ft_resource));

220: and mtp.partner_type = 3
221: and mdp.resource_id > 0
222: and (l_org_filter_cnt = 0 or mtp.organization_code in (select char1 from msc_form_query where query_id = p_query_id and number1 = msc_hp_util.ft_organization))
223: and (l_dept_filter_cnt = 0 or mdp.department_code in (select char1 from msc_form_query where query_id = p_query_id and number1 = msc_hp_util.ft_department))
224: and (l_res_filter_cnt = 0 or mdp.resource_code in (select char1 from msc_form_query where query_id = p_query_id and number1 = msc_hp_util.ft_resource));
225: msc_phub_util.log('insert into msc_hp_row_dtls: '||sql%rowcount);
226: commit;
227: end if;
228:

Line 580: msc_hp_util.prepare_col_dtls(p_plan_id, 2);

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:
582: prepare_row_dtls(p_query_id, p_plan_id,
583: p_organization_filters, p_department_filters, p_resource_filters, p_exception_filters, p_item_filters,
584: p_page_size);

Line 700: l_calendar_code := msc_hp_util.get_calendar_code(msc_hp_util.get_plan_id(p_query_id));

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
704: msc_phub_util.log('ru='||ru.sr_instance_id||','||ru.organization_id||','||