PACKAGE: APPS.MST_PQ_WORKS

Source

1 PACKAGE MST_PQ_WORKS AUTHID CURRENT_USER AS
2 /* $Header: MSTPQWKS.pls 115.3 2004/01/10 12:05:43 skakani noship $ */
3     PROCEDURE populate_result_table(errbuf		OUT NOCOPY VARCHAR2,
4 					                retcode		OUT NOCOPY NUMBER,
5                                     p_query_id     IN NUMBER,
6                                     p_plan_id      IN NUMBER );
7 
8     --PROCEDURE populate_result_table(p_query_id     IN NUMBER,
9       --                              p_plan_id      IN NUMBER);
10 
11                                     --p_where_clause IN VARCHAR2,
12                                     --p_execute_flag IN BOOLEAN);
13 
14     PROCEDURE remove_query(P_QUERY_ID IN NUMBER,
15                            P_QUERY_TYPE IN NUMBER);
16 
17     PROCEDURE remove_qry_and_results(P_QUERY_ID IN NUMBER,
18                                      P_QUERY_TYPE IN NUMBER);
19 
20     PROCEDURE RENAME_QUERY(P_QUERY_ID IN NUMBER,
21                            p_query_name IN VARCHAR2,
22                            p_description IN VARCHAR2,
23                            p_public_flag IN NUMBER);
24 
25     PROCEDURE insert_load_selection(p_query_id IN NUMBER);
26 
27     PROCEDURE insert_cm_selection(p_query_id IN NUMBER);
28 
29     PROCEDURE insert_order_selection(p_query_id IN NUMBER);
30 
31     PROCEDURE insert_excep_selection(p_query_id IN NUMBER);
32 
33     PROCEDURE save_query_result(p_query_id IN NUMBER);
34 
35     PROCEDURE clear_temp_query(p_query_id IN NUMBER);
36 
37     FUNCTION launch_request(p_query_id IN NUMBER,p_plan_id IN NUMBER)
38      RETURN NUMBER;
39 
40 END MST_PQ_WORKS;