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_RESOURCES_CUM_F

Line 53: delete from msc_resources_cum_f

49: l_rowcount1 := l_rowcount1 + sql%rowcount;
50: msc_phub_util.log('msc_resources_f, delete='||sql%rowcount||', l_rowcount1='||l_rowcount1);
51:
52: if (l_enable_num not in (2)) then
53: delete from msc_resources_cum_f
54: where plan_id = p_plan_id
55: and plan_run_id = p_plan_run_id
56: and (p_plan_id, sr_instance_id, organization_id, department_id, resource_id) in
57: (select number1, number2, number3, number4, number5 from msc_hub_query q where q.query_id = l_res_rn_qid);

Line 60: msc_phub_util.log('msc_resources_cum_f, delete='||sql%rowcount||', l_rowcount2='||l_rowcount2);

56: and (p_plan_id, sr_instance_id, organization_id, department_id, resource_id) in
57: (select number1, number2, number3, number4, number5 from msc_hub_query q where q.query_id = l_res_rn_qid);
58:
59: l_rowcount2 := l_rowcount2 + sql%rowcount;
60: msc_phub_util.log('msc_resources_cum_f, delete='||sql%rowcount||', l_rowcount2='||l_rowcount2);
61: commit;
62: end if;
63: end if;
64: end if;

Line 426: -- msc_resources_cum_f

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
426: -- msc_resources_cum_f
427: insert into msc_resources_cum_f (
428: plan_id,
429: plan_run_id,
430: sr_instance_id,

Line 427: insert into msc_resources_cum_f (

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
426: -- msc_resources_cum_f
427: insert into msc_resources_cum_f (
428: plan_id,
429: plan_run_id,
430: sr_instance_id,
431: organization_id,

Line 488: msc_phub_util.log('msc_resources_cum_f, insert='||sql%rowcount||', l_rowcount2='||l_rowcount2);

484: f.inventory_item_id,
485: d.calendar_date;
486:
487: l_rowcount2 := l_rowcount2 + sql%rowcount;
488: msc_phub_util.log('msc_resources_cum_f, insert='||sql%rowcount||', l_rowcount2='||l_rowcount2);
489: commit;
490: msc_phub_util.gather_table_stats(msc_phub_util.stats_fact, 'MSC_RESOURCES_CUM_F', p_plan_run_id);
491: end if;
492:

Line 490: msc_phub_util.gather_table_stats(msc_phub_util.stats_fact, 'MSC_RESOURCES_CUM_F', p_plan_run_id);

486:
487: l_rowcount2 := l_rowcount2 + sql%rowcount;
488: msc_phub_util.log('msc_resources_cum_f, insert='||sql%rowcount||', l_rowcount2='||l_rowcount2);
489: commit;
490: msc_phub_util.gather_table_stats(msc_phub_util.stats_fact, 'MSC_RESOURCES_CUM_F', p_plan_run_id);
491: end if;
492:
493: if (l_rowcount1 > 0) then
494: summarize_resources_f(errbuf, retcode, p_plan_id, p_plan_run_id);

Line 719: delete from msc_resources_cum_f

715: msc_phub_util.log('msc_resource_pkg.summarize_resources_cum_f');
716: retcode := 0;
717: errbuf := '';
718:
719: delete from msc_resources_cum_f
720: where plan_id=p_plan_id and plan_run_id=p_plan_run_id and aggr_type>0;
721: msc_phub_util.log('msc_resource_pkg.summarize_resources_cum_f, delete='||sql%rowcount);
722: commit;
723:

Line 725: insert into msc_resources_cum_f (

721: msc_phub_util.log('msc_resource_pkg.summarize_resources_cum_f, delete='||sql%rowcount);
722: commit;
723:
724: -- level 1
725: insert into msc_resources_cum_f (
726: plan_id, plan_run_id,
727: sr_instance_id, organization_id,
728: department_id, resource_id,
729: inventory_item_id, analysis_date,

Line 751: msc_resources_cum_f f

747: sysdate, fnd_global.user_id, fnd_global.login_id,
748: fnd_global.conc_program_id, fnd_global.conc_login_id,
749: fnd_global.prog_appl_id, fnd_global.conc_request_id
750: from
751: msc_resources_cum_f f
752: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id
753: and f.aggr_type=0
754: group by
755: f.plan_id, f.plan_run_id,

Line 775: msc_resources_cum_f f,

771: sysdate, fnd_global.user_id, fnd_global.login_id,
772: fnd_global.conc_program_id, fnd_global.conc_login_id,
773: fnd_global.prog_appl_id, fnd_global.conc_request_id
774: from
775: msc_resources_cum_f f,
776: msc_phub_resources_mv r
777: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id
778: and f.aggr_type=0
779: and r.sr_instance_id(+) = f.sr_instance_id

Line 956: ' '||l_apps_schema||'.msc_resources_cum_f'||l_suffix||' f,'||

952: l_sql := l_sql||
953: ' fnd_global.user_id, sysdate,'||
954: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
955: ' from'||
956: ' '||l_apps_schema||'.msc_resources_cum_f'||l_suffix||' f,'||
957: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||
958: ' '||l_apps_schema||'.msc_items'||l_suffix||' mi,'||
959: ' '||l_apps_schema||'.msc_department_resources'||l_suffix||' mdr'||
960: ' where f.plan_run_id=:p_plan_run_id'||

Line 1086: l_fact_table varchar2(30) := 'msc_resources_cum_f';

1082: p_plan_type number, p_plan_start_date date, p_plan_cutoff_date date,
1083: p_upload_mode number, p_overwrite_after_date date, p_def_instance_code varchar2)
1084: is
1085: l_staging_table varchar2(30) := 'msc_st_resources_cum_f';
1086: l_fact_table varchar2(30) := 'msc_resources_cum_f';
1087: l_result number := 0;
1088: begin
1089: msc_phub_util.log('msc_resource_pkg.import_resources_cum_f');
1090: retcode := 0;

Line 1112: msc_phub_util.log('msc_resource_pkg.import_resources_cum_f: insert into msc_resources_cum_f');

1108:
1109: l_result := l_result + msc_phub_util.decode_resource_key(
1110: l_staging_table, p_st_transaction_id);
1111:
1112: msc_phub_util.log('msc_resource_pkg.import_resources_cum_f: insert into msc_resources_cum_f');
1113: insert into msc_resources_cum_f (
1114: plan_id,
1115: plan_run_id,
1116: sr_instance_id,

Line 1113: insert into msc_resources_cum_f (

1109: l_result := l_result + msc_phub_util.decode_resource_key(
1110: l_staging_table, p_st_transaction_id);
1111:
1112: msc_phub_util.log('msc_resource_pkg.import_resources_cum_f: insert into msc_resources_cum_f');
1113: insert into msc_resources_cum_f (
1114: plan_id,
1115: plan_run_id,
1116: sr_instance_id,
1117: organization_id,