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_RESOURCE_PKG dependencies on MSC_ST_RESOURCES_F

Line 71: -- msc_st_resources_f:requirements

67: p_plan_id||','||p_plan_run_id||','||l_plan_type||','||
68: l_sr_instance_id||','||l_plan_start_date||','||l_plan_cutoff_date||','||
69: l_transfer_id||','||l_refresh_mode||','||l_res_rn_qid);
70:
71: -- msc_st_resources_f:requirements
72: insert /*+ append nologging */ into msc_st_resources_f (
73: st_transaction_id,
74: error_code,
75: sr_instance_id,

Line 72: insert /+ append nologging / into msc_st_resources_f (

68: l_sr_instance_id||','||l_plan_start_date||','||l_plan_cutoff_date||','||
69: l_transfer_id||','||l_refresh_mode||','||l_res_rn_qid);
70:
71: -- msc_st_resources_f:requirements
72: insert /*+ append nologging */ into msc_st_resources_f (
73: st_transaction_id,
74: error_code,
75: sr_instance_id,
76: organization_id,

Line 139: msc_phub_util.log('insert into msc_st_resources_f:requirements: '||sql%rowcount);

135: mrr.department_id,
136: mrr.resource_id,
137: trunc(decode(l_constrained_plan,1,mrr.start_date,nvl(mrr.end_date,mrr.start_date)));
138:
139: msc_phub_util.log('insert into msc_st_resources_f:requirements: '||sql%rowcount);
140: commit;
141:
142: -- msc_st_resources_f:availability
143: insert /*+ append nologging */ into msc_st_resources_f (

Line 142: -- msc_st_resources_f:availability

138:
139: msc_phub_util.log('insert into msc_st_resources_f:requirements: '||sql%rowcount);
140: commit;
141:
142: -- msc_st_resources_f:availability
143: insert /*+ append nologging */ into msc_st_resources_f (
144: st_transaction_id,
145: error_code,
146: sr_instance_id,

Line 143: insert /+ append nologging / into msc_st_resources_f (

139: msc_phub_util.log('insert into msc_st_resources_f:requirements: '||sql%rowcount);
140: commit;
141:
142: -- msc_st_resources_f:availability
143: insert /*+ append nologging */ into msc_st_resources_f (
144: st_transaction_id,
145: error_code,
146: sr_instance_id,
147: organization_id,

Line 197: msc_phub_util.log('insert into msc_st_resources_f:availability: '||sql%rowcount);

193: mra.department_id,
194: mra.resource_id,
195: trunc(mra.shift_date);
196:
197: msc_phub_util.log('insert into msc_st_resources_f:availability: '||sql%rowcount);
198: commit;
199:
200: -- msc_st_resources_f:orders
201: insert /*+ append nologging */ into msc_st_resources_f (

Line 200: -- msc_st_resources_f:orders

196:
197: msc_phub_util.log('insert into msc_st_resources_f:availability: '||sql%rowcount);
198: commit;
199:
200: -- msc_st_resources_f:orders
201: insert /*+ append nologging */ into msc_st_resources_f (
202: st_transaction_id,
203: error_code,
204: sr_instance_id,

Line 201: insert /+ append nologging / into msc_st_resources_f (

197: msc_phub_util.log('insert into msc_st_resources_f:availability: '||sql%rowcount);
198: commit;
199:
200: -- msc_st_resources_f:orders
201: insert /*+ append nologging */ into msc_st_resources_f (
202: st_transaction_id,
203: error_code,
204: sr_instance_id,
205: organization_id,

Line 263: msc_phub_util.log('insert into msc_st_resources_f:orders: '||sql%rowcount);

259: ms.inventory_item_id,
260: ms.transaction_id,
261: trunc(nvl(mrr.end_date,mrr.start_date));
262:
263: msc_phub_util.log('insert into msc_st_resources_f:orders: '||sql%rowcount);
264: commit;
265:
266: -- msc_st_resources_f:resource_cost
267: insert /*+ append nologging */ into msc_st_resources_f (

Line 266: -- msc_st_resources_f:resource_cost

262:
263: msc_phub_util.log('insert into msc_st_resources_f:orders: '||sql%rowcount);
264: commit;
265:
266: -- msc_st_resources_f:resource_cost
267: insert /*+ append nologging */ into msc_st_resources_f (
268: st_transaction_id,
269: error_code,
270: sr_instance_id,

Line 267: insert /+ append nologging / into msc_st_resources_f (

263: msc_phub_util.log('insert into msc_st_resources_f:orders: '||sql%rowcount);
264: commit;
265:
266: -- msc_st_resources_f:resource_cost
267: insert /*+ append nologging */ into msc_st_resources_f (
268: st_transaction_id,
269: error_code,
270: sr_instance_id,
271: organization_id,

Line 359: msc_phub_util.log('insert into msc_st_resources_f:resource_cost: '||sql%rowcount);

355: and mcc.from_currency(+) = decode(l_plan_type, 6, l_owning_currency_code, t1.currency_code)
356: and mcc.calendar_date(+) = t1.resource_date
357: and p_plan_id <> -1;
358:
359: msc_phub_util.log('insert into msc_st_resources_f:resource_cost: '||sql%rowcount);
360: commit;
361:
362: -- msc_resources_f:final
363: msc_phub_util.gather_table_stats(msc_phub_util.stats_st, 'MSC_ST_RESOURCES_F', l_transfer_id);

Line 363: msc_phub_util.gather_table_stats(msc_phub_util.stats_st, 'MSC_ST_RESOURCES_F', l_transfer_id);

359: msc_phub_util.log('insert into msc_st_resources_f:resource_cost: '||sql%rowcount);
360: commit;
361:
362: -- msc_resources_f:final
363: msc_phub_util.gather_table_stats(msc_phub_util.stats_st, 'MSC_ST_RESOURCES_F', l_transfer_id);
364: insert into msc_resources_f (
365: plan_id,
366: plan_run_id,
367: sr_instance_id,

Line 410: from msc_st_resources_f f

406: fnd_global.user_id, sysdate,
407: sysdate, fnd_global.user_id, fnd_global.login_id,
408: fnd_global.conc_program_id, fnd_global.conc_login_id,
409: fnd_global.prog_appl_id, fnd_global.conc_request_id
410: from msc_st_resources_f f
411: where f.st_transaction_id=l_transfer_id
412: group by
413: sr_instance_id,
414: organization_id,

Line 421: msc_phub_util.log('insert into msc_st_resources_f:final: '||sql%rowcount);

417: inventory_item_id,
418: analysis_date;
419:
420: l_rowcount1 := l_rowcount1 + sql%rowcount;
421: msc_phub_util.log('insert into msc_st_resources_f:final: '||sql%rowcount);
422: commit;
423: msc_phub_util.gather_table_stats(msc_phub_util.stats_fact, 'MSC_RESOURCES_F', p_plan_run_id);
424:
425: if (l_enable_num not in (2)) then

Line 812: delete from msc_st_resources_f where st_transaction_id=p_st_transaction_id;

808: msc_phub_util.log('msc_resource_pkg.export_resources_f');
809: retcode := 0;
810: errbuf := null;
811:
812: delete from msc_st_resources_f where st_transaction_id=p_st_transaction_id;
813: commit;
814:
815: l_sql :=
816: ' insert into msc_st_resources_f('||

Line 816: ' insert into msc_st_resources_f('||

812: delete from msc_st_resources_f where st_transaction_id=p_st_transaction_id;
813: commit;
814:
815: l_sql :=
816: ' insert into msc_st_resources_f('||
817: ' st_transaction_id,'||
818: ' error_code,'||
819: ' sr_instance_id,'||
820: ' organization_id,'||

Line 989: l_staging_table varchar2(30) := 'msc_st_resources_f';

985: p_st_transaction_id number, p_plan_id number, p_plan_run_id number,
986: p_plan_type number, p_plan_start_date date, p_plan_cutoff_date date,
987: p_upload_mode number, p_overwrite_after_date date, p_def_instance_code varchar2)
988: is
989: l_staging_table varchar2(30) := 'msc_st_resources_f';
990: l_fact_table varchar2(30) := 'msc_resources_f';
991: l_result number := 0;
992: begin
993: msc_phub_util.log('msc_resource_pkg.import_resources_f');

Line 1058: from msc_st_resources_f

1054: resource_cost2,
1055: 0, '-23453',
1056: fnd_global.user_id, sysdate,
1057: fnd_global.user_id, sysdate, fnd_global.login_id
1058: from msc_st_resources_f
1059: where st_transaction_id=p_st_transaction_id and error_code=0;
1060:
1061: msc_phub_util.log('msc_resource_pkg.import_resources_f: inserted='||sql%rowcount);
1062: commit;