[Home] [Help]
PACKAGE: APPS.AMS_LIST_RULES_ALL_PVT
Source
1 PACKAGE AMS_List_Rules_All_PVT AUTHID CURRENT_USER AS
2 /* $Header: amsvruas.pls 115.5 2002/11/22 08:56:14 jieli ship $ */
3
4 TYPE list_rule_rec_type IS RECORD
5 (
6 LIST_RULE_ID NUMBER,
7 LAST_UPDATE_DATE DATE,
8 LAST_UPDATED_BY NUMBER,
9 CREATION_DATE DATE,
10 CREATED_BY NUMBER,
11 LAST_UPDATE_LOGIN NUMBER,
12 OBJECT_VERSION_NUMBER NUMBER,
13 LIST_RULE_NAME VARCHAR2(120),
14 WEIGHTAGE_FOR_DEDUPE NUMBER,
15 ACTIVE_FROM_DATE DATE,
16 ACTIVE_TO_DATE DATE,
17 DESCRIPTION VARCHAR2(4000),
18 ORG_ID NUMBER,
19 LIST_RULE_TYPE VARCHAR(30)
20 );
21
22
23 /****************************************************************************/
24 -- Procedure
25 -- create_list_rule
26 -- Purpose
27 -- create a row in AMS_LIST_RULES_ALL
28 -- Parameters
29 -- IN:
30 -- p_api_version IN NUMBER
31 -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
32 -- p_commit IN VARCHAR2 := FND_API.g_false
33 -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
34 --
35 -- p_list_rule_rec IN list_rule_rec_type
36 --
37 -- OUT:
38 -- x_return_status OUT VARCHAR2
39 -- x_msg_count OUT NUMBER
40 -- x_msg_data OUT VARCHAR2
41 --
42 -- x_list_rule_id OUT NUMBER
43 ------------------------------------------------------------------------------
44 PROCEDURE create_list_rule
45 (
46 p_api_version IN NUMBER,
47 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
48 p_commit IN VARCHAR2 := FND_API.g_false,
49 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
50
51 x_return_status OUT NOCOPY VARCHAR2,
52 x_msg_count OUT NOCOPY NUMBER,
53 x_msg_data OUT NOCOPY VARCHAR2,
54
55 p_list_rule_rec IN list_rule_rec_type,
56 x_list_rule_id OUT NOCOPY NUMBER
57 );
58
59 /****************************************************************************/
60 -- Procedure
61 -- update_list_rule
62 -- Purpose
63 -- update a row in AMS_LIST_RULES_ALL
64 -- Parameters
65 -- IN:
66 -- p_api_version IN NUMBER
67 -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
68 -- p_commit IN VARCHAR2 := FND_API.g_false
69 -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
70 --
71 -- p_list_rule_rec IN list_rule_rec_type
72 --
73 -- OUT:
74 -- x_return_status OUT VARCHAR2
75 -- x_msg_count OUT NUMBER
76 -- x_msg_data OUT VARCHAR2
77 ------------------------------------------------------------------------------
78 PROCEDURE update_list_rule
79 (
80 p_api_version IN NUMBER,
81 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
82 p_commit IN VARCHAR2 := FND_API.g_false,
83 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
84
85 x_return_status OUT NOCOPY VARCHAR2,
86 x_msg_count OUT NOCOPY NUMBER,
87 x_msg_data OUT NOCOPY VARCHAR2,
88
89 p_list_rule_rec IN list_rule_rec_type
90 );
91
92 /****************************************************************************/
93 -- Procedure
94 -- delete_list_rule
95 -- Purpose
96 -- delete a row from AMS_LIST_RULES_ALL
97 -- Parameters
98 -- IN:
99 -- p_api_version IN NUMBER
100 -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
101 -- p_commit IN VARCHAR2 := FND_API.g_false
102 --
103 -- p_list_rule_id IN NUMBER
104 -- p_object_version IN NUMBER
105 --
106 -- OUT:
107 -- x_return_status OUT VARCHAR2
108 -- x_msg_count OUT NUMBER
109 -- x_msg_data OUT VARCHAR2
110 ------------------------------------------------------------------------------
111 PROCEDURE delete_list_rule
112 (
113 p_api_version IN NUMBER,
114 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
115 p_commit IN VARCHAR2 := FND_API.g_false,
116
117 x_return_status OUT NOCOPY VARCHAR2,
118 x_msg_count OUT NOCOPY NUMBER,
119 x_msg_data OUT NOCOPY VARCHAR2,
120
121 p_list_rule_id IN NUMBER,
122 p_object_version IN NUMBER
123 );
124
125 /****************************************************************************/
126 -- Procedure
127 -- lock_list_rule
128 -- Purpose
129 -- lock a row form AMS_LIST_RULES_ALL
130 -- Parameters
131 -- IN:
132 -- p_api_version IN NUMBER
133 -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
134 --
135 -- p_list_rule_id IN NUMBER
136 -- p_object_version IN NUMBER
137 --
138 -- OUT:
139 -- x_return_status OUT VARCHAR2
140 -- x_msg_count OUT NUMBER
141 -- x_msg_data OUT VARCHAR2
142 ------------------------------------------------------------------------------
143 PROCEDURE lock_list_rule
144 (
145 p_api_version IN NUMBER,
146 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
147
148 x_return_status OUT NOCOPY VARCHAR2,
149 x_msg_count OUT NOCOPY NUMBER,
150 x_msg_data OUT NOCOPY VARCHAR2,
151
152 p_list_rule_id IN NUMBER,
153 p_object_version IN NUMBER
154 );
155
156 /***************************************************************************/
157 -- Procedure
158 -- validate_list_rule
159 -- Purpose
160 -- validate a record before inserting or updating
161 -- AMS_LIST_RULES_ALL
162 -- Parameters
163 -- IN:
164 -- p_api_version IN NUMBER
165 -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
166 -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
167 --
168 -- p_list_rule_rec IN list_rule_rec_type
169 --
170 -- OUT:
171 -- x_return_status OUT VARCHAR2
172 -- x_msg_count OUT NUMBER
173 -- x_msg_data OUT VARCHAR2
174 ------------------------------------------------------------------------------
175 PROCEDURE validate_list_rule
176 (
177 p_api_version IN NUMBER,
178 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
179 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
180
181 x_return_status OUT NOCOPY VARCHAR2,
182 x_msg_count OUT NOCOPY NUMBER,
183 x_msg_data OUT NOCOPY VARCHAR2,
184
185 p_list_rule_rec IN list_rule_rec_type
186 );
187
188 /****************************************************************************/
189 -- Procedure
190 -- check_items
191 -- Purpose
192 -- item_level validate
193 -- Parameters
194 -- IN:
195 -- p_validation_mode IN VARCHAR2
196 -- p_list_rule_rec IN list_rule_rec_type
197 -- OUT:
198 -- x_return_status OUT VARCHAR2
199 ------------------------------------------------------------------------------
200 PROCEDURE check_items
201 (
202 p_validation_mode IN VARCHAR2,
203 x_return_status OUT NOCOPY VARCHAR2,
204 p_list_rule_rec IN list_rule_rec_type
205 );
206
207 /****************************************************************************/
208 -- Procedure
209 -- check_req_items
210 -- Purpose
211 -- check if required items are missing
212 -- Parameters
213 -- IN:
214 -- p_validation_mode IN VARCHAR2
215 -- p_list_rule_rec IN list_rule_rec_type
216 -- OUT:
217 -- x_return_status OUT VARCHAR2
218 ------------------------------------------------------------------------------
219 PROCEDURE check_req_items
220 (
221 p_validation_mode IN VARCHAR2,
222 p_list_rule_rec IN list_rule_rec_type,
223 x_return_status OUT NOCOPY VARCHAR2
224 );
225
226 /****************************************************************************/
227 -- Procedure
228 -- check_uk_items
229 -- Purpose
230 -- check unique keys
231 -- Parameters
232 -- IN:
233 -- p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
234 -- p_list_rule_rec IN list_rule_rec_type
235 -- OUT:
236 -- x_return_status OUT VARCHAR2
237 ------------------------------------------------------------------------------
238 PROCEDURE check_uk_items
239 (
240 p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
241 p_list_rule_rec IN list_rule_rec_type,
242 x_return_status OUT NOCOPY VARCHAR2
243 );
244
245 /****************************************************************************/
246 -- Procedure
247 -- check_lookup_items
248 -- Purpose
249 -- check lookup items against AMS_LOOKUPS
250 -- Parameters
251 -- IN:
252 -- p_list_rule_rec IN list_rule_rec_type
253 -- OUT:
254 -- x_return_status OUT list_rule_rec_type
255 ------------------------------------------------------------------------------
256 PROCEDURE check_lookup_items
257 (
258 p_list_rule_rec IN list_rule_rec_type,
259 x_return_status OUT NOCOPY VARCHAR2
260 );
261
262 /*****************************************************************************/
263 -- Procedure
264 -- check_record
265 -- Purpose
266 -- record level check
267 -- Parameters
268 -- IN:
269 -- p_list_rule_rec IN list_rule_rec_type
270 -- p_complete_rec IN list_rule_rec_type
271 -- OUT:
272 -- x_return_status OUT VARCHAR2
273 -------------------------------------------------------------------------------
274 PROCEDURE check_record
275 (
276 p_list_rule_rec IN list_rule_rec_type,
277 p_complete_rec IN list_rule_rec_type,
278 x_return_status OUT NOCOPY VARCHAR2
279 );
280
281 /****************************************************************************/
282 -- Procedure
283 -- complete_rec
284 -- Purpose
285 -- replace "g_miss" values with current database values
286 -- Parameters
287 -- IN:
288 -- p_list_rule_rec IN list_rule_rec_type
289 -- OUT:
290 -- x_complete_rec OUT list_rule_rec_type
291 ------------------------------------------------------------------------------
292 PROCEDURE complete_rec
293 (
294 p_list_rule_rec IN list_rule_rec_type,
295 x_complete_rec OUT NOCOPY list_rule_rec_type
296 );
297
298 /****************************************************************************/
299 -- Procedure
300 -- init_rec
301 --
302 -- HISTORY
303 -- 12/19/1999 julou Created.
304 ------------------------------------------------------------------------------
305 PROCEDURE init_rec
306 (
307 x_list_rule_rec OUT NOCOPY list_rule_rec_type
308 );
309
310 END AMS_List_Rules_All_PVT;