1 PACKAGE MSD_DEM_COLLECT_HISTORY_DATA AUTHID CURRENT_USER AS
2 /* $Header: msddemchds.pls 120.3.12020000.3 2013/01/10 07:18:32 kkhatri ship $ */
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 G_COMMA NUMBER := 1 ;
9 G_SQL NUMBER := 2 ;
10 G_VSET NUMBER := 3 ;
11
12
13
14
15 /*** PROCEDURES ***/
16
17
18 /*
19 * This procedure analyzes the given table
20 */
21 PROCEDURE ANALYZE_TABLE (
22 errbuf OUT NOCOPY VARCHAR2,
23 retcode OUT NOCOPY VARCHAR2,
24 p_table_name IN VARCHAR2);
25
26
27 PROCEDURE COLLECT_HISTORY_DATA (
28 errbuf OUT NOCOPY VARCHAR2,
29 retcode OUT NOCOPY VARCHAR2,
30 p_sr_instance_id IN NUMBER,
31 p_collection_group IN VARCHAR2,
32 p_collection_method IN NUMBER,
33 p_hidden_param1 IN VARCHAR2,
34 p_date_range_type IN NUMBER,
35 p_collection_window IN NUMBER,
36 p_from_date IN VARCHAR2,
37 p_to_date IN VARCHAR2,
38 p_bh_bi_bd IN NUMBER,
39 p_bh_bi_rd IN NUMBER,
40 p_bh_ri_bd IN NUMBER,
41 p_bh_ri_rd IN NUMBER,
42 p_sh_si_sd IN NUMBER,
43 p_sh_si_rd IN NUMBER,
44 p_sh_ri_sd IN NUMBER,
45 p_sh_ri_rd IN NUMBER,
46 p_collect_iso IN NUMBER DEFAULT G_NO,
47 p_collect_all_order_types IN NUMBER DEFAULT G_YES,
48 p_hidden_param2 IN VARCHAR2,
49 p_type_selection_method IN NUMBER DEFAULT G_COMMA,
50 p_include_order_types IN VARCHAR2 DEFAULT NULL,
51 p_exclude_order_types IN VARCHAR2 DEFAULT NULL,
52 p_auto_run_download IN NUMBER,
53 p_for_spf IN NUMBER DEFAULT G_NO );
54
55
56 PROCEDURE RUN_LOAD (
57 errbuf OUT NOCOPY VARCHAR2,
58 retcode OUT NOCOPY VARCHAR2,
59 p_auto_run_download IN NUMBER,
60 p_synchronous IN NUMBER DEFAULT G_NO,
61 p_check_finish IN NUMBER DEFAULT 60,
62 p_time_out IN NUMBER DEFAULT 60 );
63
64
65 /*
66 * This procedure inserts dummy rows into the sales staging tables for new items
67 */
68 PROCEDURE INSERT_DUMMY_ROWS (
69 errbuf OUT NOCOPY VARCHAR2,
70 retcode OUT NOCOPY VARCHAR2,
71 p_dest_table IN VARCHAR2,
72 p_sr_instance_id IN NUMBER);
73
74 END MSD_DEM_COLLECT_HISTORY_DATA;