DBA Data[Home] [Help]

PACKAGE: APPS.MSD_DEM_COLLECT_HISTORY_DATA

Source


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;