PACKAGE: APPS.MSC_PHUB_PKG

Source

1 PACKAGE msc_phub_pkg authid definer AS
2 /* $Header: MSCHBPBS.pls 120.37 2011/12/30 19:09:57 wexia ship $ */
3 
4     sys_yes constant number := 1;
5     sys_no constant number := 2;
6 
7     type plan_info is record (
8         plan_id number,
9         plan_name varchar2(50),
10         plan_description varchar2(100),
11         plan_type number,
12         sr_instance_id number,
13         organization_id number,
14         plan_start_date date,
15         plan_cutoff_date date,
16         plan_completion_date date,
17         publisher varchar2(200)
18     );
19 
20     function list_plan_runs(p_plan_name varchar2, p_plan_run_id number) return msc_apcc_number_list;
21 
22     function get_plan_type_meaning(p_plan_type number) return varchar2;
23 
24     type object_names is table of varchar2(30);
25     function meta_info return msc_apcc_fact_type_table;
26 
27     procedure populate_details(errbuf out nocopy varchar2, retcode out nocopy varchar2,
28         p_plan_id number default null,
29         p_plan_run_id number default null,
30         p_archive_flag number default sys_yes,
31         p_target_plan_name varchar2 default null,
32         p_dblink varchar2 default null,
33         p_include_ods number default sys_no,
34         p_plan_type number default null,
35         p_scenario_name in varchar2 default null,
36         p_publisher varchar2 default null);
37 
38     function populate_details_fn(errbuf out nocopy varchar2, retcode out nocopy varchar2,
39         p_plan_id number default null,
40         p_plan_run_id number default null,
41         p_archive_flag number default sys_yes,
42         p_target_plan_name varchar2 default null,
43         p_dblink varchar2 default null,
44         p_include_ods number default sys_no,
45         p_plan_type number default null,
46         p_scenario_name in varchar2 default null,
47         p_publisher varchar2 default null)
48         return number;
49 
50     procedure purge_details(p_plan_name varchar2, p_plan_run_id number);
51 
52     procedure refresh_mvs(p_refresh_mode varchar2);
53     procedure refresh_mvs(errbuf out nocopy varchar2, retcode out nocopy varchar2, p_refresh_mode varchar2);
54 
55     procedure populate_demantra_details(errbuf out nocopy varchar2, retcode out nocopy varchar2,
56         p_plan_id number, p_plan_run_id number, p_archive_flag number default -1,
57         p_dblink varchar2 default null,
58         p_include_ods number default sys_no);
59 
60     procedure populate_sno_details(errbuf out nocopy varchar2, retcode out nocopy varchar2,
61         p_plan_id number,
62         p_plan_run_id number default null,
63         p_archive_flag number default -1,
64         p_scenario_name in varchar2 default null);
65 
66     procedure finalize_plan_run(
67         p_plan_id number, p_plan_run_id number, p_include_ods number,
68         p_archive_flag number, p_success number, p_keep_previous number);
69 
70     function get_plan_info(p_plan_id number, p_plan_type number) return plan_info;
71 
72     function create_staging_partitions(p_plan_type number, p_include_ods number) return number;
73     procedure drop_staging_partitions(p_transfer_id number, p_plan_type number, p_include_ods number);
74 
75     function create_plan_run(
76         p_scenario_name varchar2, p_include_ods number,
77         p_local_archive_flag number, p_pi plan_info)
78         return number;
79 
80     procedure populate_demantra_ods(errbuf out nocopy varchar2, retcode out nocopy varchar2);
81 
82     procedure populate_each(errbuf out nocopy varchar2, retcode out nocopy varchar2,
83         p_package varchar2, p_plan_id number, p_plan_run_id number);
84 
85     procedure build_items_from_pds(p_plan_id number);
86     procedure build_items_from_apcc(p_plan_id number, p_plan_run_id number);
87     procedure populate_ods_details(errbuf out nocopy varchar2, retcode out nocopy varchar2,
88         p_sr_instance_id number, p_refresh_mode number, p_param1 varchar2 default null);
89 
90     procedure maintain_data_model(errbuf out nocopy varchar2, retcode out nocopy varchar2,
91         p_cleanup_facts number default null, p_operation_code varchar2 default null);
92     procedure check_migrate(errbuf out nocopy varchar2, retcode out nocopy varchar2);
93 
94     procedure archive_demantra_plan(p_publisher varchar2, p_plan_name varchar2, p_keep_previous number);
95     procedure archive_demantra_ods(p_publisher varchar2);
96     procedure sync_demantra(errbuf out nocopy varchar2, retcode out nocopy varchar2);
97 
98 END msc_phub_pkg;