PACKAGE: APPS.WSH_SAVED_QUERIES_PKG

Source

1 package wsh_saved_queries_pkg AUTHID CURRENT_USER as
2 /* $Header: WSHQACTS.pls 115.4 2002/11/13 20:47:19 nparikh ship $ */
3 
4 
5 procedure insert_row(
6   X_rowid				  out NOCOPY  varchar2,
7   X_query_id			          out NOCOPY  number,
8   X_name				  varchar2,
9   X_description				  varchar2,
10   X_entity_type			          varchar2,
11   X_shared_flag			          varchar2,
12   X_pseudo_query			  long,
13   X_attribute_category			  varchar2,
14   X_attribute1				  varchar2,
15   X_attribute2				  varchar2,
16   X_attribute3				  varchar2,
17   X_attribute4				  varchar2,
18   X_attribute5				  varchar2,
19   X_attribute6				  varchar2,
20   X_attribute7				  varchar2,
21   X_attribute8				  varchar2,
22   X_attribute9				  varchar2,
23   X_attribute10				  varchar2,
24   X_attribute11				  varchar2,
25   X_attribute12				  varchar2,
26   X_attribute13				  varchar2,
27   X_attribute14				  varchar2,
28   X_attribute15				  varchar2,
29   X_creation_date			  date,
30   X_created_by			          number,
31   X_last_update_date		          date,
32   X_last_updated_by		          number,
33   X_last_update_login			  number,
34   X_program_application_id 		  number,
35   X_program_id				  number,
36   X_program_update_date			  date,
37   X_request_id				  number
38 );
39 
40 procedure lock_row(
41   X_query_id			          number,
42   X_name				  varchar2,
43   X_description				  varchar2,
44   X_entity_type			          varchar2,
45   X_shared_flag			          varchar2,
46   X_pseudo_query			  long,
47   X_attribute_category			  varchar2,
48   X_attribute1				  varchar2,
49   X_attribute2				  varchar2,
50   X_attribute3				  varchar2,
51   X_attribute4				  varchar2,
52   X_attribute5				  varchar2,
53   X_attribute6				  varchar2,
54   X_attribute7				  varchar2,
55   X_attribute8				  varchar2,
56   X_attribute9				  varchar2,
57   X_attribute10				  varchar2,
58   X_attribute11				  varchar2,
59   X_attribute12				  varchar2,
60   X_attribute13				  varchar2,
61   X_attribute14				  varchar2,
62   X_attribute15				  varchar2,
63   X_creation_date			  date,
64   X_created_by			          number,
65   X_last_update_date		          date,
66   X_last_updated_by		          number,
67   X_last_update_login			  number,
68   X_program_application_id 		  number,
69   X_program_id				  number,
70   X_program_update_date			  date,
71   X_request_id				  number
72 );
73 
74 procedure update_row(
75   X_query_id			          number,
76   X_name				  varchar2,
77   X_description				  varchar2,
78   X_entity_type			          varchar2,
79   X_shared_flag			          varchar2,
80   X_pseudo_query			  long,
81   X_attribute_category			  varchar2,
82   X_attribute1				  varchar2,
83   X_attribute2				  varchar2,
84   X_attribute3				  varchar2,
85   X_attribute4				  varchar2,
86   X_attribute5				  varchar2,
87   X_attribute6				  varchar2,
88   X_attribute7				  varchar2,
89   X_attribute8				  varchar2,
90   X_attribute9				  varchar2,
91   X_attribute10				  varchar2,
92   X_attribute11				  varchar2,
93   X_attribute12				  varchar2,
94   X_attribute13				  varchar2,
95   X_attribute14				  varchar2,
96   X_attribute15				  varchar2,
97   X_last_update_date		          date,
98   X_last_updated_by		          number,
99   X_last_update_login			  number,
100   X_program_application_id 		  number,
101   X_program_id				  number,
102   X_program_update_date			  date,
103   X_request_id				  number
104 );
105 
106 procedure delete_row(X_query_id wsh_saved_queries_b.query_id%type);
107 
108 procedure add_language;
109 
110 end wsh_saved_queries_pkg;