PACKAGE: APPS.WMS_SAVE_QUERY_PVT

Source

1 PACKAGE wms_save_query_pvt AUTHID CURRENT_USER AS
2 /* $Header: WMSVSQRS.pls 115.2 2003/01/15 19:17:36 piwong noship $ */
3 
4 TYPE save_query_record IS RECORD
5   (
6    query_type     wms_saved_queries.query_type%TYPE,
7    query_name     wms_saved_queries.query_name%TYPE,
8    field_name     wms_saved_queries.field_name%TYPE,
9    field_type     wms_saved_queries.field_type%TYPE,
10    field_value    wms_saved_queries.field_value%TYPE,
11    return_status  VARCHAR2(1));
12 
13 TYPE save_query_table IS TABLE OF save_query_record
14   INDEX BY BINARY_INTEGER;
15 
16 PROCEDURE insert_query_row(p_query_type  wms_saved_queries.query_type%TYPE,
17 			   p_query_name  wms_saved_queries.query_name%TYPE,
18 			   p_org_id      wms_saved_queries.organization_id%TYPE,
19 			   p_user_id     wms_saved_queries.user_id%TYPE,
20 			   p_login_id    wms_saved_queries.last_update_login%TYPE,
21 			   p_table       save_query_table,
22 			   x_return_status OUT NOCOPY varchar2);
23 
24 PROCEDURE update_query_row(p_query_type  wms_saved_queries.query_type%TYPE,
25 			   p_query_name  wms_saved_queries.query_name%TYPE,
26 			   p_org_id      wms_saved_queries.organization_id%TYPE,
27 			   p_user_id     wms_saved_queries.user_id%TYPE,
28 			   p_login_id    wms_saved_queries.last_update_login%TYPE,
29 			   p_table       save_query_table,
30 			   x_return_status OUT NOCOPY varchar2);
31 
32 PROCEDURE update_query_row(p_query_type   wms_saved_queries.query_type%TYPE,
33 			   p_query_name   wms_saved_queries.query_name%TYPE,
34 			   p_field_name   wms_saved_queries.field_name%TYPE,
35 			   p_field_value  wms_saved_queries.field_value%TYPE,
36 			   p_field_type   wms_saved_queries.field_type%TYPE,
37 			   p_org_id       wms_saved_queries.organization_id%TYPE,
38 			   p_user_id      wms_saved_queries.user_id%TYPE,
39 			   x_return_status OUT NOCOPY VARCHAR2);
40 
41 PROCEDURE delete_query_row(p_query_type   wms_saved_queries.query_type%TYPE,
42 			   p_query_name   wms_saved_queries.query_name%TYPE,
43 			   p_field_name   wms_saved_queries.field_name%TYPE,
44 			   p_org_id       wms_saved_queries.organization_id%TYPE,
45 			   p_user_id      wms_saved_queries.user_id%TYPE,
46 			   x_return_status OUT NOCOPY VARCHAR2);
47 
48 PROCEDURE delete_query(p_query_type   wms_saved_queries.query_type%TYPE,
49 		       p_query_name   wms_saved_queries.query_name%TYPE,
50 		       p_org_id       wms_saved_queries.organization_id%TYPE,
51 		       p_user_id      wms_saved_queries.user_id%TYPE,
52 		       x_return_status OUT NOCOPY VARCHAR2);
53 
54 END wms_save_query_pvt;
55