1 PACKAGE AMS_List_Query_PUB AUTHID CURRENT_USER AS
2 /* $Header: amspliqs.pls 115.4 2002/11/22 08:54:07 jieli ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_List_Query_PUB
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- End of Comments
14 -- ===============================================================
15
16 -- Default number of records fetch per call
17 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
18 -- ==============================================================================
19 -- Start of Comments
20 -- ==============================================================================
21 -- API Name
22 -- Create_List_Query
23 -- Type
24 -- Public
25 -- Pre-Req
26 --
27 -- Parameters
28 --
29 -- IN
30 -- p_api_version_number IN NUMBER Required
31 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
32 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
33 -- p_list_query_rec IN list_query_rec_type Required
34 --
35 -- OUT
36 -- x_return_status OUT VARCHAR2
37 -- x_msg_count OUT NUMBER
38 -- x_msg_data OUT VARCHAR2
39 -- Version : Current version 1.0
40 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
41 -- and basic operation, developer must manually add parameters and business logic as necessary.
42 --
43 -- End of Comments
44 -- ==============================================================================
45 --
46
47 PROCEDURE Create_List_Query(
48 p_api_version_number IN NUMBER,
49 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
50 p_commit IN VARCHAR2 := FND_API.G_FALSE,
51
52 x_return_status OUT NOCOPY VARCHAR2,
53 x_msg_count OUT NOCOPY NUMBER,
54 x_msg_data OUT NOCOPY VARCHAR2,
55
56 p_list_query_rec IN AMS_List_Query_PVT.list_query_rec_type,
57 x_list_query_id OUT NOCOPY NUMBER
58 );
59
60 PROCEDURE Create_List_Query(
61 p_api_version_number IN NUMBER,
62 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
63 p_commit IN VARCHAR2 := FND_API.G_FALSE,
64 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
65 x_return_status OUT NOCOPY VARCHAR2,
66 x_msg_count OUT NOCOPY NUMBER,
67 x_msg_data OUT NOCOPY VARCHAR2,
68 p_list_query_rec_tbl IN AMS_List_Query_PVT.list_query_rec_type_tbl ,
69 p_sql_string_tbl in AMS_List_Query_PVT.sql_string_tbl ,
70
71 x_parent_list_query_id OUT NOCOPY NUMBER
72 );
73
74
75 -- ==============================================================================
76 -- Start of Comments
77 -- ==============================================================================
78 -- API Name
79 -- Update_List_Query
80 -- Type
81 -- Public
82 -- Pre-Req
83 --
84 -- Parameters
85 --
86 -- IN
87 -- p_api_version_number IN NUMBER Required
88 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
89 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
90 -- p_list_query_rec IN list_query_rec_type Required
91 --
92 -- OUT
93 -- x_return_status OUT VARCHAR2
94 -- x_msg_count OUT NUMBER
95 -- x_msg_data OUT VARCHAR2
96 -- Version : Current version 1.0
97 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
98 -- and basic operation, developer must manually add parameters and business logic as necessary.
99 --
100 -- End of Comments
101 -- ==============================================================================
102 --
103
104
105 PROCEDURE Update_List_Query(
106 p_api_version_number IN NUMBER,
107 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
108 p_commit IN VARCHAR2 := FND_API.G_FALSE,
109
110 x_return_status OUT NOCOPY VARCHAR2,
111 x_msg_count OUT NOCOPY NUMBER,
112 x_msg_data OUT NOCOPY VARCHAR2,
113
114 p_list_query_rec IN AMS_List_Query_PVT.list_query_rec_type,
115 x_object_version_number OUT NOCOPY NUMBER
116 );
117
118 PROCEDURE Update_List_Query(
119 p_api_version_number IN NUMBER,
120 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
121 p_commit IN VARCHAR2 := FND_API.G_FALSE,
122 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
123 x_return_status OUT NOCOPY VARCHAR2,
124 x_msg_count OUT NOCOPY NUMBER,
125 x_msg_data OUT NOCOPY VARCHAR2,
126 p_list_query_rec_tbl IN AMS_List_Query_PVT.list_query_rec_type_tbl,
127 p_sql_string_tbl in AMS_List_Query_PVT.sql_string_tbl ,
128
129 x_object_version_number OUT NOCOPY NUMBER
130 );
131
132
133 -- ==============================================================================
134 -- Start of Comments
135 -- ==============================================================================
136 -- API Name
137 -- Delete_List_Query
138 -- Type
139 -- Public
140 -- Pre-Req
141 --
142 -- Parameters
143 --
144 -- IN
145 -- p_api_version_number IN NUMBER Required
146 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
147 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
148 -- p_LIST_QUERY_ID IN NUMBER
149 -- p_object_version_number IN NUMBER Optional Default = NULL
150 --
151 -- OUT
152 -- x_return_status OUT VARCHAR2
153 -- x_msg_count OUT NUMBER
154 -- x_msg_data OUT VARCHAR2
155 -- Version : Current version 1.0
156 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
157 -- and basic operation, developer must manually add parameters and business logic as necessary.
158 --
159 -- End of Comments
160 -- ==============================================================================
161 --
162
163 PROCEDURE Delete_List_Query(
164 p_api_version_number IN NUMBER,
165 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
166 p_commit IN VARCHAR2 := FND_API.G_FALSE,
167 x_return_status OUT NOCOPY VARCHAR2,
168 x_msg_count OUT NOCOPY NUMBER,
169 x_msg_data OUT NOCOPY VARCHAR2,
170 p_list_query_id IN NUMBER,
171 p_object_version_number IN NUMBER
172 );
173
174 PROCEDURE Delete_parent_List_Query(
175 p_api_version_number IN NUMBER,
176 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
177 p_commit IN VARCHAR2 := FND_API.G_FALSE,
178 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
179 x_return_status OUT NOCOPY VARCHAR2,
180 x_msg_count OUT NOCOPY NUMBER,
181 x_msg_data OUT NOCOPY VARCHAR2,
182 p_parent_list_query_id IN NUMBER,
183 p_object_version_number IN NUMBER
184 );
185
186
187 -- ==============================================================================
188 -- Start of Comments
189 -- ==============================================================================
190 -- API Name
191 -- Lock_List_Query
192 -- Type
193 -- Public
194 -- Pre-Req
195 --
196 -- Parameters
197 --
198 -- IN
199 -- p_api_version_number IN NUMBER Required
200 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
201 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
202 -- p_list_query_rec IN list_query_rec_type Required
203 --
204 -- OUT
205 -- x_return_status OUT VARCHAR2
206 -- x_msg_count OUT NUMBER
207 -- x_msg_data OUT VARCHAR2
208 -- Version : Current version 1.0
209 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
210 -- and basic operation, developer must manually add parameters and business logic as necessary.
211 --
212 -- End of Comments
213 -- ==============================================================================
214 --
215
216 PROCEDURE Lock_List_Query(
217 p_api_version_number IN NUMBER,
218 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
219 x_return_status OUT NOCOPY VARCHAR2,
220 x_msg_count OUT NOCOPY NUMBER,
221 x_msg_data OUT NOCOPY VARCHAR2,
222
223 p_list_query_id IN NUMBER,
224 p_object_version IN NUMBER
225 );
226
227 END AMS_List_Query_PUB;