PACKAGE: APPS.MSD_DEM_QUERY_UTILITIES

Source

1 PACKAGE MSD_DEM_QUERY_UTILITIES AS
2 /* $Header: msddemqutls.pls 120.2.12000000.2 2007/09/24 11:16:53 nallkuma noship $ */
3 
4 
5    /* MSD DEM Debug Profile Value */
6    C_MSD_DEM_DEBUG   		VARCHAR2(1)   := nvl( fnd_profile.value( 'MSD_DEM_DEBUG_MODE'), 'N');
7 
8 procedure get_query(retcode             OUT NOCOPY NUMBER,
9 		    query               OUT NOCOPY VARCHAR2,
10                     p_entity_name       IN  VARCHAR2,
11                     p_instance_id       IN  NUMBER,
12                     p_dest_table        IN VARCHAR2 DEFAULT NULL,
13                     p_add_where_clause  IN VARCHAR2 DEFAULT NULL);
14 
15 procedure get_query2(retcode             OUT NOCOPY NUMBER,
16 		    query               OUT NOCOPY VARCHAR2,
17                     p_entity_name       IN  VARCHAR2,
18                     p_instance_id       IN  NUMBER,
19                     keys_values IN VARCHAR2,
20                     flag IN NUMBER,
21 		    view_name VARCHAR2 default null
22 );
23 
24 
25    PROCEDURE GET_QUERY3 (
26    		retcode             	OUT NOCOPY 	NUMBER,
27 		query               	OUT NOCOPY 	VARCHAR2,
28                 p_entity_name       	IN  		VARCHAR2,
29                 p_instance_id       	IN  		NUMBER,
30                 p_key_values 		IN 		VARCHAR2,
31                 p_custom_view_flag	IN 		NUMBER,
32 		p_custom_view_name	IN 		VARCHAR2 DEFAULT NULL,
33 		p_series_type		IN		NUMBER	 DEFAULT 1,
34 		p_ps_view_name		IN		VARCHAR2 DEFAULT NULL );
35 
36 END MSD_DEM_QUERY_UTILITIES;
37