PACKAGE: APPS.MSC_PHUB_FILE_PKG

Source

1 package msc_phub_file_pkg AUTHID CURRENT_USER as
2     /* $Header: MSCHBPFS.pls 120.9 2011/12/07 18:19:36 lreinhar noship $ */
3     transfer_staging constant number := 1;
4     transfer_file constant number := 2;
5     transfer_blob constant number := 3;
6     transfer_other_staging constant number := 4;
7 
8     status_transfering constant number := 1;
9     status_transfered constant number := 2;
10     status_purging constant number := 3;
11 
12     function prepare_transfer_tables_ui(
13         errbuf out nocopy varchar2, retcode out nocopy varchar2,
14         p_query_id number) return number;
15 
16     function prepare_transfer_tables(
17         p_export_level number,
18         p_import_level number,
19         p_upload_mode number,
20         p_directory varchar2,
21         p_source_plan_run_id number,
22         p_source_dblink varchar2,
23         p_source_version varchar2,
24         p_include_pds number,
25         p_include_ods number,
26         p_plan_name varchar2,
27         p_plan_type number,
28         p_plan_description varchar2,
29         p_instance_code varchar2,
30         p_organization_code varchar2,
31         p_plan_start_date date,
32         p_plan_cutoff_date date,
33         p_plan_completion_date date) return number;
34 
35     procedure save_overwrite_date(p_transfer_id number, p_fact_type number,
36         p_overwrite_after_date date);
37 
38     procedure prepare_export(errbuf out nocopy varchar2, retcode out nocopy varchar2,
39         p_transfer_id number);
40 
41     procedure prepare_import(errbuf out nocopy varchar2, retcode out nocopy varchar2,
42         p_transfer_id number);
43 
44     procedure finalize_export(errbuf out nocopy varchar2, retcode out nocopy varchar2,
45         p_transfer_id number);
46 
47     procedure finalize_import(errbuf out nocopy varchar2, retcode out nocopy varchar2,
48         p_transfer_id number);
49 
50     procedure export_table(
51         errbuf out nocopy varchar2, retcode out nocopy varchar2,
52         p_transfer_id number, p_fact_type number);
53 
54     procedure import_table(
55         errbuf out nocopy varchar2, retcode out nocopy varchar2,
56         p_transfer_id number, p_fact_type number);
57 
58     procedure cleanup(
59         errbuf out nocopy varchar2, retcode out nocopy varchar2,
60         p_transfer_id number);
61 
62     procedure prepare_context(errbuf out nocopy varchar2, retcode out nocopy varchar2,
63         p_transfer_id number, p_validate_only number);
64 
65     function create_plan(errbuf out nocopy varchar2, retcode out nocopy varchar2,
66         p_transfer_id number) return number;
67 
68     function get_staging_table(p_fact_type number) return varchar2;
69 
70     procedure purge_plan_summary(errbuf out nocopy varchar2, retcode out nocopy varchar2,
71         p_plan_name varchar2, p_plan_run_id number default null);
72 
73 end msc_phub_file_pkg;