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_SCN_UTILS dependencies on MSC_PHUB_PKG

Line 2194: l_plan_run_id := msc_phub_pkg.populate_plan_run_info(l_plan_id,l_plan_name,l_plan_type,l_run_date);

2190: exit when c_scn_plans%NOTFOUND;
2191: l_plan_name := msc_scn_utils.get_plan_name(l_plan_type,l_plan_id,null);
2192: if(l_plan_type <> 10) then
2193:
2194: l_plan_run_id := msc_phub_pkg.populate_plan_run_info(l_plan_id,l_plan_name,l_plan_type,l_run_date);
2195: if(l_plan_type = 6) then -- for sno plans
2196: msc_phub_pkg.populate_details(errbuf,retcode,l_plan_id,l_plan_run_id);
2197: else
2198: msc_phub_pkg.populate_details(errbuf,retcode,l_plan_id,l_plan_run_id);

Line 2196: msc_phub_pkg.populate_details(errbuf,retcode,l_plan_id,l_plan_run_id);

2192: if(l_plan_type <> 10) then
2193:
2194: l_plan_run_id := msc_phub_pkg.populate_plan_run_info(l_plan_id,l_plan_name,l_plan_type,l_run_date);
2195: if(l_plan_type = 6) then -- for sno plans
2196: msc_phub_pkg.populate_details(errbuf,retcode,l_plan_id,l_plan_run_id);
2197: else
2198: msc_phub_pkg.populate_details(errbuf,retcode,l_plan_id,l_plan_run_id);
2199: end if;
2200: else -- Demantra scenarios archival

Line 2198: msc_phub_pkg.populate_details(errbuf,retcode,l_plan_id,l_plan_run_id);

2194: l_plan_run_id := msc_phub_pkg.populate_plan_run_info(l_plan_id,l_plan_name,l_plan_type,l_run_date);
2195: if(l_plan_type = 6) then -- for sno plans
2196: msc_phub_pkg.populate_details(errbuf,retcode,l_plan_id,l_plan_run_id);
2197: else
2198: msc_phub_pkg.populate_details(errbuf,retcode,l_plan_id,l_plan_run_id);
2199: end if;
2200: else -- Demantra scenarios archival
2201: l_plan_run_id := msc_phub_pkg.populate_plan_run_info(l_plan_id,null,l_plan_type,null);
2202: msc_phub_pkg.populate_demantra_details(errbuf,retcode,l_plan_id,l_plan_run_id);

Line 2201: l_plan_run_id := msc_phub_pkg.populate_plan_run_info(l_plan_id,null,l_plan_type,null);

2197: else
2198: msc_phub_pkg.populate_details(errbuf,retcode,l_plan_id,l_plan_run_id);
2199: end if;
2200: else -- Demantra scenarios archival
2201: l_plan_run_id := msc_phub_pkg.populate_plan_run_info(l_plan_id,null,l_plan_type,null);
2202: msc_phub_pkg.populate_demantra_details(errbuf,retcode,l_plan_id,l_plan_run_id);
2203:
2204: end if;
2205:

Line 2202: msc_phub_pkg.populate_demantra_details(errbuf,retcode,l_plan_id,l_plan_run_id);

2198: msc_phub_pkg.populate_details(errbuf,retcode,l_plan_id,l_plan_run_id);
2199: end if;
2200: else -- Demantra scenarios archival
2201: l_plan_run_id := msc_phub_pkg.populate_plan_run_info(l_plan_id,null,l_plan_type,null);
2202: msc_phub_pkg.populate_demantra_details(errbuf,retcode,l_plan_id,l_plan_run_id);
2203:
2204: end if;
2205:
2206: if retcode <> 0 then

Line 2265: msc_phub_pkg.purge_details(errbuf,retcode,l_plan_id,l_plan_run_id);

2261:
2262: if(l_plan_type <> 10) then
2263:
2264: if(l_plan_type = 6) then -- for sno plans
2265: msc_phub_pkg.purge_details(errbuf,retcode,l_plan_id,l_plan_run_id);
2266: -- null;
2267: else
2268: msc_phub_pkg.purge_details(errbuf,retcode,l_plan_id,l_plan_run_id);
2269: end if;

Line 2268: msc_phub_pkg.purge_details(errbuf,retcode,l_plan_id,l_plan_run_id);

2264: if(l_plan_type = 6) then -- for sno plans
2265: msc_phub_pkg.purge_details(errbuf,retcode,l_plan_id,l_plan_run_id);
2266: -- null;
2267: else
2268: msc_phub_pkg.purge_details(errbuf,retcode,l_plan_id,l_plan_run_id);
2269: end if;
2270: else -- Demantra plan purge
2271: msc_phub_pkg.purge_demantra_details(errbuf,retcode,l_plan_id,l_plan_run_id);
2272: end if;

Line 2271: msc_phub_pkg.purge_demantra_details(errbuf,retcode,l_plan_id,l_plan_run_id);

2267: else
2268: msc_phub_pkg.purge_details(errbuf,retcode,l_plan_id,l_plan_run_id);
2269: end if;
2270: else -- Demantra plan purge
2271: msc_phub_pkg.purge_demantra_details(errbuf,retcode,l_plan_id,l_plan_run_id);
2272: end if;
2273:
2274: if retcode <> 0 then
2275: msc_util.msc_debug('Purge Plan Failed for Plan:'||get_plan_name(l_plan_type,l_plan_id,l_plan_run_id));

Line 2311: msc_phub_pkg.purge_details(errbuf,retcode,p_plan_id,null);

2307: begin
2308: if(p_plan_type <> 10) then
2309:
2310: if(p_plan_type = 6) then -- for sno plans
2311: msc_phub_pkg.purge_details(errbuf,retcode,p_plan_id,null);
2312: -- null;
2313: else
2314: msc_phub_pkg.purge_details(errbuf,retcode,p_plan_id,null);
2315: end if;

Line 2314: msc_phub_pkg.purge_details(errbuf,retcode,p_plan_id,null);

2310: if(p_plan_type = 6) then -- for sno plans
2311: msc_phub_pkg.purge_details(errbuf,retcode,p_plan_id,null);
2312: -- null;
2313: else
2314: msc_phub_pkg.purge_details(errbuf,retcode,p_plan_id,null);
2315: end if;
2316: else -- Demantra plan purge
2317: msc_phub_pkg.purge_demantra_details(errbuf,retcode,p_plan_id,null);
2318: end if;

Line 2317: msc_phub_pkg.purge_demantra_details(errbuf,retcode,p_plan_id,null);

2313: else
2314: msc_phub_pkg.purge_details(errbuf,retcode,p_plan_id,null);
2315: end if;
2316: else -- Demantra plan purge
2317: msc_phub_pkg.purge_demantra_details(errbuf,retcode,p_plan_id,null);
2318: end if;
2319:
2320: if retcode <> 0 then
2321: --null; -- errored out