1 PACKAGE MSD_DEM_COLLECT_HISTORY_DATA AS
2 /* $Header: msddemchds.pls 120.0.12000000.2 2007/09/25 06:23:57 syenamar noship $ */
3
4 /*** GLOBAL VARIABLES ***/
5 G_YES NUMBER := MSD_DEM_COMMON_UTILITIES.C_YES;
6 G_NO NUMBER := MSD_DEM_COMMON_UTILITIES.C_NO;
7
8
9
10 /*** PROCEDURES ***/
11
12
13 /*
14 * This procedure analyzes the given table
15 */
16 PROCEDURE ANALYZE_TABLE (
17 errbuf OUT NOCOPY VARCHAR2,
18 retcode OUT NOCOPY VARCHAR2,
19 p_table_name IN VARCHAR2);
20
21
22 PROCEDURE COLLECT_HISTORY_DATA (
23 errbuf OUT NOCOPY VARCHAR2,
24 retcode OUT NOCOPY VARCHAR2,
25 p_sr_instance_id IN NUMBER,
26 p_collection_group IN VARCHAR2,
27 p_collection_method IN NUMBER,
28 p_hidden_param1 IN VARCHAR2,
29 p_date_range_type IN NUMBER,
30 p_collection_window IN NUMBER,
31 p_from_date IN VARCHAR2,
32 p_to_date IN VARCHAR2,
33 p_bh_bi_bd IN NUMBER,
34 p_bh_bi_rd IN NUMBER,
35 p_bh_ri_bd IN NUMBER,
36 p_bh_ri_rd IN NUMBER,
37 p_sh_si_sd IN NUMBER,
38 p_sh_si_rd IN NUMBER,
39 p_sh_ri_sd IN NUMBER,
40 p_sh_ri_rd IN NUMBER,
41 p_collect_iso IN NUMBER DEFAULT G_NO,
42 p_collect_all_order_types IN NUMBER DEFAULT G_YES,
43 p_include_order_types IN VARCHAR2 DEFAULT NULL,
44 p_exclude_order_types IN VARCHAR2 DEFAULT NULL,
45 p_auto_run_download IN NUMBER );
46
47
48 PROCEDURE RUN_LOAD (
49 errbuf OUT NOCOPY VARCHAR2,
50 retcode OUT NOCOPY VARCHAR2,
51 p_auto_run_download IN NUMBER );
52
53 END MSD_DEM_COLLECT_HISTORY_DATA;