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_RES_PLAN_PKG dependencies on MSC_HP_ROW_DTLS

Line 67: delete from msc_hp_row_dtls where query_id = p_query_id;

63: 'l_res_filter_cnt = '||l_res_filter_cnt||', '||
64: 'l_exception_filter_cnt = '||l_exception_filter_cnt||', '||
65: 'l_item_filter_cnt = '||l_item_filter_cnt);
66:
67: delete from msc_hp_row_dtls where query_id = p_query_id;
68: msc_phub_util.log('delete from msc_hp_row_dtls: '||sql%rowcount);
69: commit;
70:
71: if (l_exception_filter_cnt > 0) then

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

64: 'l_exception_filter_cnt = '||l_exception_filter_cnt||', '||
65: 'l_item_filter_cnt = '||l_item_filter_cnt);
66:
67: delete from msc_hp_row_dtls where query_id = p_query_id;
68: msc_phub_util.log('delete from msc_hp_row_dtls: '||sql%rowcount);
69: commit;
70:
71: if (l_exception_filter_cnt > 0) then
72: insert into msc_form_query(query_id, number1, number2, number3,

Line 103: insert into msc_hp_row_dtls(

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(
104: query_id,
105: row_index,
106: plan_id,
107: sr_instance_id,

Line 183: msc_phub_util.log('insert into msc_hp_row_dtls: '||sql%rowcount);

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
186: insert into msc_hp_row_dtls(
187: query_id,

Line 186: insert into msc_hp_row_dtls(

182: ) t;
183: msc_phub_util.log('insert into msc_hp_row_dtls: '||sql%rowcount);
184: commit;
185: else
186: insert into msc_hp_row_dtls(
187: query_id,
188: row_index,
189: plan_id,
190: sr_instance_id,

Line 225: msc_phub_util.log('insert into msc_hp_row_dtls: '||sql%rowcount);

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:
229: insert into msc_hp_row_dtls(

Line 229: insert into msc_hp_row_dtls(

225: msc_phub_util.log('insert into msc_hp_row_dtls: '||sql%rowcount);
226: commit;
227: end if;
228:
229: insert into msc_hp_row_dtls(
230: query_id,
231: row_index,
232: plan_id,
233: data_flag,

Line 239: msc_phub_util.log('insert into msc_hp_row_dtls: '||sql%rowcount);

235: last_update_date, last_updated_by, last_update_login)
236: values (p_query_id, -1, p_plan_id, 1,
237: fnd_global.user_id, sysdate,
238: sysdate, fnd_global.user_id, fnd_global.login_id);
239: msc_phub_util.log('insert into msc_hp_row_dtls: '||sql%rowcount);
240: commit;
241:
242: g_page_size := p_page_size;
243: g_fetch_size := ceil(g_max_fetch_size/g_page_size) * g_page_size;

Line 262: from msc_hp_row_dtls h, msc_hp_col_dtls b

258:
259: begin
260: select h.plan_id, b.bkt_start_date
261: into l_plan_id, l_past_date
262: from msc_hp_row_dtls h, msc_hp_col_dtls b
263: where h.query_id = p_query_id
264: and h.data_flag = decode(p_summary, 1, h.data_flag, 3)
265: and h.plan_id = b.plan_id
266: and b.bucket_type = 0

Line 278: from msc_hp_row_dtls h

274: where (query_id, row_index) in
275: (select
276: h.query_id,
277: decode(p_summary, 1, -1, h.row_index) row_index
278: from msc_hp_row_dtls h
279: where h.query_id = p_query_id
280: and h.data_flag = decode(p_summary, 1, h.data_flag, 3));
281: msc_phub_util.log('delete from msc_res_plan_data: '||sql%rowcount);
282: commit;

Line 329: msc_hp_row_dtls h

325: from
326: msc_resource_requirements mrr,
327: msc_department_resources mdr,
328: msc_hp_col_dtls b,
329: msc_hp_row_dtls h
330: where h.query_id = p_query_id
331: and mrr.plan_id = h.plan_id
332: and mrr.sr_instance_id = h.sr_instance_id
333: and mrr.organization_id = h.organization_id

Line 368: msc_hp_row_dtls h

364: from
365: msc_resource_requirements mrr,
366: msc_department_resources mdr,
367: msc_hp_col_dtls b,
368: msc_hp_row_dtls h
369: where h.query_id = p_query_id
370: and mrr.plan_id = h.plan_id
371: and mrr.sr_instance_id = h.sr_instance_id
372: and mrr.organization_id = h.organization_id

Line 409: msc_hp_row_dtls h

405: to_number(null) total_resource_cost
406: from
407: msc_net_resource_avail mra,
408: msc_hp_col_dtls b,
409: msc_hp_row_dtls h
410: where h.query_id = p_query_id
411: and mra.plan_id = h.plan_id
412: and mra.sr_instance_id = h.sr_instance_id
413: and mra.organization_id = h.organization_id

Line 453: msc_hp_row_dtls h

449: to_number(null) total_resource_cost
450: from
451: msc_res_plan_updates a2,
452: msc_hp_col_dtls b,
453: msc_hp_row_dtls h
454: where h.query_id = p_query_id
455: and a2.query_id = h.query_id
456: and a2.plan_id = h.plan_id
457: and a2.sr_instance_id = h.sr_instance_id

Line 503: msc_hp_row_dtls h

499: msc_department_resources mdr,
500: msc_department_resources mdr2,
501: msc_supplies ms,
502: msc_hp_col_dtls b,
503: msc_hp_row_dtls h
504: where h.query_id = p_query_id
505: and mrr.plan_id = h.plan_id
506: and mrr.sr_instance_id = h.sr_instance_id
507: and mrr.organization_id = h.organization_id

Line 543: update msc_hp_row_dtls

539: analysis_date;
540: msc_phub_util.log('insert into msc_res_plan_data: '||sql%rowcount);
541: commit;
542:
543: update msc_hp_row_dtls
544: set data_flag = 2
545: where query_id = p_query_id and data_flag = 3;
546: msc_phub_util.log('update msc_hp_row_dtls: '||sql%rowcount);
547: commit;

Line 546: msc_phub_util.log('update msc_hp_row_dtls: '||sql%rowcount);

542:
543: update msc_hp_row_dtls
544: set data_flag = 2
545: where query_id = p_query_id and data_flag = 3;
546: msc_phub_util.log('update msc_hp_row_dtls: '||sql%rowcount);
547: commit;
548:
549: end populate_data;
550:

Line 556: update msc_hp_row_dtls

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
559: and row_index = -1
560: and data_flag = 1;

Line 600: from msc_hp_row_dtls

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
602: and row_index between p_row_index and p_row_index+g_page_size-1
603: and data_flag = 1;
604: if (l_n = 0) then

Line 608: update msc_hp_row_dtls

604: if (l_n = 0) then
605: return;
606: end if;
607:
608: update msc_hp_row_dtls
609: set data_flag = 3
610: where query_id = p_query_id
611: and row_index between p_row_index and p_row_index+g_fetch_size-1
612: and data_flag = 1;

Line 636: msc_hp_row_dtls h,

632: decode(u.time_level, 2, b.week_last_work_date, 3, period_last_work_date, bkt_end_date) last_work_date,
633: u.new_value
634: from
635: msc_hp_updates u,
636: msc_hp_row_dtls h,
637: msc_hp_col_dtls b
638: where h.query_id = p_query_id
639: and h.query_id = u.query_id
640: and h.row_index = u.row_index

Line 1094: update msc_hp_row_dtls

1090: close c;
1091: end loop;
1092: end if;
1093:
1094: update msc_hp_row_dtls
1095: set data_flag = 3
1096: where query_id = p_query_id
1097: and row_index = ru.row_index;
1098: msc_phub_util.log('update msc_hp_row_dtls: '||sql%rowcount);

Line 1098: msc_phub_util.log('update msc_hp_row_dtls: '||sql%rowcount);

1094: update msc_hp_row_dtls
1095: set data_flag = 3
1096: where query_id = p_query_id
1097: and row_index = ru.row_index;
1098: msc_phub_util.log('update msc_hp_row_dtls: '||sql%rowcount);
1099: commit;
1100: end loop;
1101:
1102: populate_data(p_query_id, 2);

Line 1121: delete from msc_hp_row_dtls where query_id = p_query_id;

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;
1124:
1125: delete from msc_res_plan_data where query_id = p_query_id;

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

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;
1124:
1125: delete from msc_res_plan_data where query_id = p_query_id;
1126: msc_phub_util.log('delete from msc_res_plan_data: '||sql%rowcount);