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_PHUB_PKG dependencies on MSC_PLAN_RUNS_S

Line 799: update msc_plan_runs set

795:
796: exception
797: when others then
798: if (l_plan_run_id > 0) then
799: update msc_plan_runs set
800: archive_flag=decode(archive_flag, 3, 2, archive_flag),
801: last_update_date = sysdate
802: where plan_run_id=l_plan_run_id;
803: commit;

Line 829: update msc_plan_runs set

825:
826: for r in c loop
827: manage_partitions(list_fact_tables(null), r.plan_run_id, partition_drop, partition_range);
828:
829: update msc_plan_runs set
830: planning_hub_flag = sys_no,
831: last_run_flag = sys_no,
832: archive_flag = sys_no,
833: last_update_date = sysdate,

Line 859: update msc_plan_runs set

855: where plan_name=l_plan_name
856: and archive_flag=1;
857:
858: if (l_last_plan_run_id > 0) then
859: update msc_plan_runs set
860: last_run_flag = 1,
861: last_update_date = sysdate,
862: last_updated_by = fnd_global.user_id,
863: last_update_login = fnd_global.login_id,

Line 1014: update msc_plan_runs set

1010: from msc_plan_runs
1011: where plan_run_id=p_plan_run_id;
1012:
1013: if (p_success = sys_yes) then
1014: update msc_plan_runs set
1015: last_run_flag=sys_no,
1016: last_update_date = sysdate,
1017: last_updated_by = fnd_global.user_id,
1018: last_update_login = fnd_global.login_id

Line 1023: update msc_plan_runs set

1019: where plan_name = l_plan_name
1020: and plan_run_id < p_plan_run_id
1021: and (p_plan_id<>-1 or sr_instance_id=l_sr_instance_id);
1022:
1023: update msc_plan_runs set
1024: last_run_flag=sys_yes,
1025: planning_hub_flag=sys_yes,
1026: end_date=sysdate,
1027: archive_flag=p_archive_flag

Line 1030: update msc_plan_runs set end_date=sysdate

1026: end_date=sysdate,
1027: archive_flag=p_archive_flag
1028: where plan_id=p_plan_id and plan_run_id=p_plan_run_id;
1029: else
1030: update msc_plan_runs set end_date=sysdate
1031: where plan_id=p_plan_id and plan_run_id=p_plan_run_id;
1032: end if;
1033: commit;
1034: end if;

Line 1114: dbms_lock.allocate_unique('msc_plan_runs_s', l_lock);

1110: end if;
1111:
1112: if (l_fact_tables.count > 0) then
1113: -- create fact partitions synchronuously
1114: dbms_lock.allocate_unique('msc_plan_runs_s', l_lock);
1115: msc_phub_util.log('msc_phub_pkg.create_fact_partitions: dbms_lock.request');
1116: l_error := dbms_lock.request(l_lock);
1117: if (l_error <> 0) then
1118: msc_phub_util.log('msc_phub_pkg.create_fact_partitions: dbms_lock.request='||l_error);

Line 1122: select msc_plan_runs_s.nextval into l_plan_run_id from dual;

1118: msc_phub_util.log('msc_phub_pkg.create_fact_partitions: dbms_lock.request='||l_error);
1119: raise e_create_fact_partitions;
1120: end if;
1121:
1122: select msc_plan_runs_s.nextval into l_plan_run_id from dual;
1123: manage_partitions(l_fact_tables, l_plan_run_id, partition_add, partition_range);
1124: l_error := dbms_lock.release(l_lock);
1125: end if;
1126: return l_plan_run_id;

Line 1962: update msc_plan_runs set

1958: -- prepare staging tables
1959: l_transfer_id := create_staging_partitions(l_pi.plan_type, sys_no);
1960:
1961: -- update msc_plan_runs
1962: update msc_plan_runs set
1963: refresh_mode = p_refresh_mode,
1964: plan_type = l_pi.plan_type,
1965: sr_instance_id = p_sr_instance_id,
1966: organization_id = l_pi.organization_id,

Line 2002: update msc_plan_runs set lcid = l_lcid

1998: retcode := -1;
1999: errbuf := 'Error while populating the fact tables. purging this plan summary. ';
2000: msc_phub_util.log(errbuf);
2001: else
2002: update msc_plan_runs set lcid = l_lcid
2003: where plan_run_id=l_plan_run_id;
2004: commit;
2005: end if;
2006: finalize_plan_run(-1, l_plan_run_id, sys_no, sys_yes, l_return_status, sys_yes);

Line 2233: update msc_plan_runs set scenario_name = regexp_substr(plan_run_name, '\[.*\]', 1, 1);

2229:
2230: procedure migrate_scenario_names is
2231: begin
2232: msc_phub_util.log('msc_phub_pkg.migrate_scenario_names');
2233: update msc_plan_runs set scenario_name = regexp_substr(plan_run_name, '\[.*\]', 1, 1);
2234: update msc_plan_runs set scenario_name = substr(scenario_name, 2, length(scenario_name)-2);
2235: commit;
2236:
2237: update msc_plan_runs set last_run_flag=2

Line 2234: update msc_plan_runs set scenario_name = substr(scenario_name, 2, length(scenario_name)-2);

2230: procedure migrate_scenario_names is
2231: begin
2232: msc_phub_util.log('msc_phub_pkg.migrate_scenario_names');
2233: update msc_plan_runs set scenario_name = regexp_substr(plan_run_name, '\[.*\]', 1, 1);
2234: update msc_plan_runs set scenario_name = substr(scenario_name, 2, length(scenario_name)-2);
2235: commit;
2236:
2237: update msc_plan_runs set last_run_flag=2
2238: where plan_run_id in

Line 2237: update msc_plan_runs set last_run_flag=2

2233: update msc_plan_runs set scenario_name = regexp_substr(plan_run_name, '\[.*\]', 1, 1);
2234: update msc_plan_runs set scenario_name = substr(scenario_name, 2, length(scenario_name)-2);
2235: commit;
2236:
2237: update msc_plan_runs set last_run_flag=2
2238: where plan_run_id in
2239: (select plan_run_id from
2240: (select plan_name, plan_run_id,
2241: last_value(plan_run_id) over(partition by plan_name order by plan_run_id