PACKAGE: APPS.MSC_PHUB_PKG

Source

1 PACKAGE msc_phub_pkg AS
2 /* $Header: MSCHBPBS.pls 120.12 2008/02/10 19:39:00 wexia noship $ */
3 
4    g_log_flag number := 2; --0 no-log, 1 log-to-file, 2 log-to-conc-log
5    g_log_row number := 0;
6    g_log_file_dir varchar2(250);
7    g_log_file_name varchar2(250);
8    g_log_file_handle utl_file.file_type;
9 
10    procedure println(p_msg varchar2);
11 
12    function populate_plan_run_info(p_plan_id number, p_plan_name varchar2,
13       p_plan_type number, p_plan_comp_date date) return number;
14 
15    procedure populate_details(errbuf out nocopy varchar2, retcode out nocopy varchar2,
16      p_plan_id number, p_plan_run_id number default null, p_archive_flag number default -1);
17    procedure purge_details(errbuf out nocopy varchar2, retcode out nocopy varchar2,
18      p_plan_id number, p_plan_run_id number);
19 
20    procedure refresh_mvs(p_refresh_mode varchar2);
21 
22     procedure populate_demantra_details(errbuf out nocopy varchar2, retcode out nocopy varchar2,
23         p_scenario_id number, p_plan_run_id number, p_archive_flag number default -1);
24     procedure purge_demantra_details(errbuf out nocopy varchar2, retcode out nocopy varchar2,
25         p_scenario_id number, p_plan_run_id number);
26 
27     procedure populate_sno_details(errbuf out nocopy varchar2, retcode out nocopy varchar2,
28         p_plan_id number, p_plan_run_id number default null,
29         p_archive_flag number default -1,
30         p_scenario_name in varchar2 default null);
31 
32 END msc_phub_pkg;