[Home] [Help]
PACKAGE: APPS.AMS_LIST_RULE_FIELDS_PVT
Source
1 PACKAGE AMS_List_Rule_Fields_PVT AUTHID CURRENT_USER AS
2 /* $Header: amsvrufs.pls 115.6 2002/11/22 08:56:18 jieli ship $ */
3
4 TYPE rule_fld_rec_type IS RECORD
5 (
6 LIST_RULE_FIELD_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 FIELD_TABLE_NAME VARCHAR2(30),
14 FIELD_COLUMN_NAME VARCHAR2(30),
15 LIST_RULE_ID NUMBER,
16 SUBSTRING_LENGTH NUMBER,
17 WEIGHTAGE NUMBER,
18 SEQUENCE_NUMBER NUMBER,
19 WORD_REPLACEMENT_CODE VARCHAR2(30)
20 );
21
22
23 /****************************************************************************/
24 -- Procedure
25 -- create_list_rule_field
26 -- Purpose
27 -- create a row in AMS_LIST_RULE_FIELDS
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_rule_fld_rec IN rule_fld_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_rule_fld_id OUT NUMBER
43 ------------------------------------------------------------------------------
44 PROCEDURE create_list_rule_field
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_rule_fld_rec IN rule_fld_rec_type,
56 x_rule_fld_id OUT NOCOPY NUMBER
57 );
58
59 /****************************************************************************/
60 -- Procedure
61 -- update_list_rule_field
62 -- Purpose
63 -- update a row in AMS_LIST_RULE_FIELDS
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_rule_fld_rec IN rule_fld_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_field
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_rule_fld_rec IN rule_fld_rec_type
90 );
91
92 /****************************************************************************/
93 -- Procedure
94 -- delete_list_rule_field
95 -- Purpose
96 -- delete a row from AMS_LIST_RULE_FIELDS
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_rule_fld_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_field
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_rule_fld_id IN NUMBER,
122 p_object_version IN NUMBER
123 );
124
125 /****************************************************************************/
126 -- Procedure
127 -- lock_list_rule_field
128 -- Purpose
129 -- lock a row form AMS_LIST_RULE_FIELDS
130 -- Parameters
131 -- IN:
132 -- p_api_version IN NUMBER
133 -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
134 --
135 -- p_rule_fld_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_field
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_rule_fld_id IN NUMBER,
153 p_object_version IN NUMBER
154 );
155
156 /***************************************************************************/
157 -- Procedure
158 -- validate_list_rule_field
159 -- Purpose
160 -- validate a record before inserting or updating
161 -- AMS_LIST_RULE_FIELDS
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_rule_fld_rec IN rule_fld_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_field
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_rule_fld_rec IN rule_fld_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_rule_fld_rec IN rule_fld_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_rule_fld_rec IN rule_fld_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_rule_fld_rec IN rule_fld_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_rule_fld_rec IN rule_fld_rec_type,
223 x_return_status OUT NOCOPY VARCHAR2
224 );
225
226 /****************************************************************************/
227 -- Procedure
228 -- check_fk_items
229 -- Purpose
230 -- check foreign key items
231 -- Parameters
232 -- IN:
233 -- p_rule_fld_rec IN rule_fld_rec_type
234 -- OUT:
235 -- x_return_status OUT VARCHAR2
236 ------------------------------------------------------------------------------
237 PROCEDURE check_fk_items
238 (
239 p_rule_fld_rec IN rule_fld_rec_type,
240 x_return_status OUT NOCOPY VARCHAR2
241 );
242
243 /****************************************************************************/
244 -- Procedure
245 -- check_uk_items
246 -- Purpose
247 -- check unique keys
248 -- Parameters
249 -- IN:
250 -- p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
251 -- p_rule_fld_rec IN rule_fld_rec_type
252 -- OUT:
253 -- x_return_status OUT VARCHAR2
254 ------------------------------------------------------------------------------
255 PROCEDURE check_uk_items
256 (
257 p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
258 p_rule_fld_rec IN rule_fld_rec_type,
259 x_return_status OUT NOCOPY VARCHAR2
260 );
261
262 /****************************************************************************/
263 -- Procedure
264 -- complete_rec
265 -- Purpose
266 -- field "g_miss" values with current database values
267 -- Parameters
268 -- IN:
269 -- p_rule_fld_rec IN rule_fld_rec_type
270 -- OUT:
271 -- x_complete_rec OUT rule_fld_rec_type
272 ------------------------------------------------------------------------------
273 PROCEDURE complete_rec
274 (
275 p_rule_fld_rec IN rule_fld_rec_type,
276 x_complete_rec OUT NOCOPY rule_fld_rec_type
277 );
278
279 /****************************************************************************/
280 -- Procedure
281 -- init_rec
282 --
283 -- HISTORY
284 -- 12/19/1999 julou Created.
285 ------------------------------------------------------------------------------
286 PROCEDURE init_rec
287 (
291 END AMS_List_Rule_Fields_PVT;
288 x_rule_fld_rec OUT NOCOPY rule_fld_rec_type
289 );
290