1 PACKAGE MSD_DEM_QUERY_UTILITIES AUTHID CURRENT_USER AS
2 /* $Header: msddemqutls.pls 120.2.12010000.2 2008/11/04 11:01:08 sjagathe ship $ */
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
37 /*
38 * Given an identifier for the query to be executed and a list of key value pairs.
39 * This procedure generates the query, replaces the constants and executes the query.
40 */
41 PROCEDURE EXECUTE_QUERY (
42 errbuf OUT NOCOPY VARCHAR2,
43 retcode OUT NOCOPY VARCHAR2,
44 p_entity_name IN VARCHAR2,
45 p_sr_instance_id IN NUMBER,
46 p_key_values IN VARCHAR2 );
47
48
49 /*
50 * Given a table name, location (MSD(2) or Demantra(1)), this procedure truncates(1) or deletes(2)
51 * all data from the table.
52 */
53 PROCEDURE TRUNCATE_TABLE (
54 errbuf OUT NOCOPY VARCHAR2,
55 retcode OUT NOCOPY VARCHAR2,
56 p_table_name IN VARCHAR2,
57 p_owner IN NUMBER DEFAULT 1,
58 p_truncate IN NUMBER DEFAULT 1 );
59
60 END MSD_DEM_QUERY_UTILITIES;
61