PACKAGE: APPS.MSC_PERS_QUERIES

Source

1 package MSC_PERS_QUERIES AUTHID CURRENT_USER as
2 /* $Header: MSCPQS.pls 120.5 2007/10/05 21:25:34 cnazarma ship $ */
3 
4   p_item_type constant number := 1;
5   p_res_type constant number := 2;
6   p_excp_type constant number := 4;
7   p_supp_type constant number := 5;
8   p_shipment_type constant number := 6;
9   p_order_type constant number := 9;
10   p_wl_type    constant number := 10;
11   p_crit_type constant number := 12;
12 
13   p_item_view constant varchar2(50) := 'MSC_SYSTEM_ITEMS_SC_V';
14   p_excp_view constant varchar2(50) := 'MSC_EXCEPTION_DETAILS_V';
15   p_cp_custom_excp_view constant varchar2(50) := 'MSC_CP_CUSTOM_EXC_DETAILS_V';
16   p_cp_excp_view constant varchar2(50) := 'MSC_X_EXCEPTION_DETAILS_V';
17   p_supp_view constant varchar2(50) := 'MSC_ITEM_SUPPLIER_V';
18   p_res_view constant varchar2(50) := 'MSC_PLANNED_RESOURCES_V';
19   p_shipment_view constant varchar2(50) := 'MSC_SHIPMENT_DETAILS_V';
20   p_order_view constant varchar2(50) := 'MSC_ORDERS_V';
21   p_item_attributes_view constant varchar2(80) := 'MSC_ITEM_ATTRIBUTES_V';
22 
23   procedure populate_result_table(p_query_id in number,
24 		p_query_type in number,
25                 p_plan_id in number,
26 		p_where_clause in varchar2,
27 		p_execute_flag in boolean,
28                 P_MASTER_QUERY_ID in NUMBER DEFAULT NULL,
29                 p_sequence_id in NUMBER DEFAULT NULL);
30 
31   function get_user(p_user_id in number) return varchar2;
32   function get_query_name(p_query_id in number) return varchar2;
33   function get_query_type(p_query_id in number) return number;
34 
35   procedure populate_cp_temp_table(p_query_id in number);
36 
37   Procedure purge_plan(p_plan_id IN NUMBER);
38   procedure update_category( ERRBUF     OUT NOCOPY VARCHAR2,
39                              RETCODE    OUT NOCOPY NUMBER,
40                              p_query_id in NUMBER);
41 
42   procedure save_as(p_query_id in number,
43 	p_query_name in varchar2,
44 	p_query_desc in varchar2,
45 	p_public_flag in number);
46 
47   procedure delete_query(p_query_id in number,
48 	p_query_name in varchar2 default null);
49 
50 FUNCTION save_as(p_query_id in number,
51 	p_query_name in varchar2,
52 	p_query_desc in varchar2,
53 	p_public_flag in number) return number;
54 
55 FUNCTION copy_query(p_query_id in number,
56 	p_query_name in varchar2,
57 	p_query_desc in varchar2,
58 	p_public_flag in number) return number;
59 
60 end MSC_PERS_QUERIES;