APPS.MSC_SCN_UTILS dependencies on MSC_PLAN_RUNS

Line 1880: from msc_plan_runs

1876: where scenario_id=p_plan_id and p_plan_type=10;
1877:
1878: cursor c_plan_name_arch is
1879: select plan_run_name
1880: from msc_plan_runs
1881: where plan_id=p_plan_id and
1882: plan_run_id = p_plan_run_id;
1883:
1884: cursor c_end_date is

Line 1886: from msc_plan_runs

1882: plan_run_id = p_plan_run_id;
1883:
1884: cursor c_end_date is
1885: select end_date
1886: from msc_plan_runs
1887: where plan_run_id = p_plan_run_id;
1888:
1889: l_plan_name varchar2(80);
1890: l_plan_name_arch varchar2(80);

Line 1946: from msc_plan_runs

1942:
1943: FUNCTION get_plan_version(p_plan_run_id in number) return varchar2 is
1944: cursor c_end_date is
1945: select end_date
1946: from msc_plan_runs
1947: where plan_run_id = p_plan_run_id;
1948:
1949: l_pln_version varchar2(30);
1950: l_end_date date;

Line 2209: from msc_plan_runs

2205: l_publisher := null;
2206: begin
2207: select plan_name, publisher
2208: into l_plan_name, l_publisher
2209: from msc_plan_runs
2210: where plan_run_id=l_old_plan_run_id;
2211: exception when others then null;
2212: end;
2213:

Line 2248: from msc_scenario_plans sp, msc_plan_runs r

2244: procedure purge_scn_conc( errbuf out nocopy varchar2, retcode out nocopy varchar2 , p_scn_id in number) is
2245:
2246: cursor c_scn_plans is
2247: select r.plan_run_name, r.plan_run_id
2248: from msc_scenario_plans sp, msc_plan_runs r
2249: where sp.scenario_id = p_scn_id and sp.purge_flag = 'Y'
2250: and sp.plan_run_id = r.plan_run_id;
2251:
2252: cursor c_scn_version is

Line 2313: from msc_plan_runs

2309: begin
2310: begin
2311: select plan_name, plan_run_id
2312: into l_plan_name, l_plan_run_id
2313: from msc_plan_runs
2314: where plan_run_name = p_plan_name;
2315: exception
2316: when no_data_found then
2317: l_plan_name := p_plan_name;

Line 2327: delete from msc_scenario_plans where plan_run_id in (select plan_run_id from msc_plan_runs where plan_name=l_plan_name);

2323: --null; -- errored out
2324: raise exc_error_purge_plan;
2325: end if;
2326:
2327: delete from msc_scenario_plans where plan_run_id in (select plan_run_id from msc_plan_runs where plan_name=l_plan_name);
2328: commit;
2329: end if;
2330: EXCEPTION
2331: when exc_error_purge_plan then

Line 2438: msc_plan_runs mpr,

2434: 'MSC_SCN_PLAN_STATUS',
2435: decode(upper(fcr.status_code),'C',4,'E',3)
2436: ) plan_status_display
2437: from msc_plans mp,
2438: msc_plan_runs mpr,
2439: fnd_concurrent_requests fcr
2440: where mp.plan_type is not null and
2441: mp.plan_id = mpr.plan_id and
2442: mpr.end_date is not null and