PACKAGE: APPS.MSC_DEMANTRA_PKG

Source

1 package msc_demantra_pkg authid definer as
2     /*  $Header: MSCHBDMS.pls 120.8 2011/05/04 16:51:56 wexia ship $ */
3 
4     procedure populate_details(errbuf out nocopy varchar2, retcode out nocopy varchar2,
5         p_plan_id number, p_plan_run_id number);
6 
7     procedure summarize_demantra_f(errbuf out nocopy varchar2, retcode out nocopy varchar2,
8         p_plan_id number, p_plan_run_id number);
9 
10     procedure export_demantra_f (
11         errbuf out nocopy varchar2, retcode out nocopy varchar2,
12         p_st_transaction_id number, p_plan_run_id number,
13         p_dblink varchar2, p_source_version varchar2);
14 
15     procedure export_demantra_ods_f (
16         errbuf out nocopy varchar2, retcode out nocopy varchar2,
17         p_st_transaction_id number, p_plan_run_id number,
18         p_dblink varchar2, p_source_version varchar2);
19 
20     procedure import_demantra_f (
21         errbuf out nocopy varchar2, retcode out nocopy varchar2,
22         p_st_transaction_id number, p_plan_id number, p_plan_run_id number,
23         p_plan_type number, p_plan_start_date date, p_plan_cutoff_date date,
24         p_upload_mode number, p_overwrite_after_date date, p_def_instance_code varchar2);
25 
26     procedure import_demantra_ods_f (
27         errbuf out nocopy varchar2, retcode out nocopy varchar2,
28         p_st_transaction_id number, p_plan_id number, p_plan_run_id number,
29         p_plan_type number, p_plan_start_date date, p_plan_cutoff_date date,
30         p_upload_mode number, p_overwrite_after_date date, p_def_instance_code varchar2);
31 
32     procedure archive(p_plan_id number, p_plan_run_id number, p_fact_type number, p_publisher varchar2, p_transfer_id number);
33     procedure register_custom_measures;
34     procedure create_item_hierarchy_view;
35     procedure build_custom_hierarchy;
36     function seeded_measure_mapping return msc_apcc_measure_map_table;
37 
38 end msc_demantra_pkg;