[Home] [Help]
PACKAGE: APPS.AMS_LIST_WORD_REPLACES_PVT
Source
1 PACKAGE AMS_List_Word_Replaces_PVT AUTHID CURRENT_USER AS
2 /* $Header: amsvwdrs.pls 115.5 2002/11/22 08:56:37 jieli ship $ */
3
4 TYPE wrd_rpl_rec_type IS RECORD
5 (
6 LIST_WORD_REPLACES_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 ORIGINAL_WORD VARCHAR2(120),
14 REPLACEMENT_WORD VARCHAR2(120),
15 ENABLED_FLAG VARCHAR2(1),
16 DESCRIPTION VARCHAR2(4000)
17 );
18
19
20 /****************************************************************************/
21 -- Procedure
22 -- create_list_word_replace
23 -- Purpose
24 -- create a row in AMS_LIST_WORD_REPLACES
25 -- Parameters
26 -- IN:
27 -- p_api_version IN NUMBER
28 -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
29 -- p_commit IN VARCHAR2 := FND_API.g_false
30 -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
31 --
32 -- p_wrd_rpl_rec IN wrd_rpl_rec_type
33 --
34 -- OUT:
35 -- x_return_status OUT VARCHAR2
36 -- x_msg_count OUT NUMBER
37 -- x_msg_data OUT VARCHAR2
38 --
39 -- x_wrd_rpl_id OUT NUMBER
40 ------------------------------------------------------------------------------
41 PROCEDURE create_list_word_replace
42 (
43 p_api_version IN NUMBER,
44 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
45 p_commit IN VARCHAR2 := FND_API.g_false,
46 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
47
48 x_return_status OUT NOCOPY VARCHAR2,
49 x_msg_count OUT NOCOPY NUMBER,
50 x_msg_data OUT NOCOPY VARCHAR2,
51
52 p_wrd_rpl_rec IN wrd_rpl_rec_type,
53 x_wrd_rpl_id OUT NOCOPY NUMBER
54 );
55
56 /****************************************************************************/
57 -- Procedure
58 -- update_list_word_replace
59 -- Purpose
60 -- update a row in AMS_LIST_WORD_REPLACES
61 -- Parameters
62 -- IN:
63 -- p_api_version IN NUMBER
64 -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
65 -- p_commit IN VARCHAR2 := FND_API.g_false
66 -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
67 --
68 -- p_wrd_rpl_rec IN wrd_rpl_rec_type
69 --
70 -- OUT:
71 -- x_return_status OUT VARCHAR2
72 -- x_msg_count OUT NUMBER
73 -- x_msg_data OUT VARCHAR2
74 ------------------------------------------------------------------------------
75 PROCEDURE update_list_word_replace
76 (
77 p_api_version IN NUMBER,
78 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
79 p_commit IN VARCHAR2 := FND_API.g_false,
80 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
81
82 x_return_status OUT NOCOPY VARCHAR2,
83 x_msg_count OUT NOCOPY NUMBER,
84 x_msg_data OUT NOCOPY VARCHAR2,
85
86 p_wrd_rpl_rec IN wrd_rpl_rec_type
87 );
88
89 /****************************************************************************/
90 -- Procedure
91 -- delete_list_word_replace
92 -- Purpose
93 -- delete a row from AMS_LIST_WORD_REPLACES
94 -- Parameters
95 -- IN:
96 -- p_api_version IN NUMBER
97 -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
98 -- p_commit IN VARCHAR2 := FND_API.g_false
99 --
100 -- p_wrd_rpl_id IN NUMBER
101 -- p_object_version IN NUMBER
102 --
103 -- OUT:
104 -- x_return_status OUT VARCHAR2
105 -- x_msg_count OUT NUMBER
106 -- x_msg_data OUT VARCHAR2
107 ------------------------------------------------------------------------------
108 PROCEDURE delete_list_word_replace
109 (
110 p_api_version IN NUMBER,
111 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
112 p_commit IN VARCHAR2 := FND_API.g_false,
113
114 x_return_status OUT NOCOPY VARCHAR2,
115 x_msg_count OUT NOCOPY NUMBER,
116 x_msg_data OUT NOCOPY VARCHAR2,
117
118 p_wrd_rpl_id IN NUMBER,
119 p_object_version IN NUMBER
120 );
121
122 /****************************************************************************/
123 -- Procedure
124 -- lock_list_word_replace
125 -- Purpose
126 -- lock a row form AMS_LIST_WORD_REPLACES
127 -- Parameters
128 -- IN:
129 -- p_api_version IN NUMBER
130 -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
131 --
132 -- p_wrd_rpl_id IN NUMBER
133 -- p_object_version IN NUMBER
134 --
135 -- OUT:
136 -- x_return_status OUT VARCHAR2
137 -- x_msg_count OUT NUMBER
138 -- x_msg_data OUT VARCHAR2
139 ------------------------------------------------------------------------------
140 PROCEDURE lock_list_word_replace
141 (
142 p_api_version IN NUMBER,
143 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
144
145 x_return_status OUT NOCOPY VARCHAR2,
146 x_msg_count OUT NOCOPY NUMBER,
147 x_msg_data OUT NOCOPY VARCHAR2,
148
149 p_wrd_rpl_id IN NUMBER,
150 p_object_version IN NUMBER
151 );
152
153 /***************************************************************************/
154 -- Procedure
155 -- validate_list_word_replace
156 -- Purpose
157 -- validate a record before inserting or updating
158 -- AMS_LIST_WORD_REPLACES
159 -- Parameters
160 -- IN:
161 -- p_api_version IN NUMBER
162 -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
163 -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
164 --
165 -- p_wrd_rpl_rec IN wrd_rpl_rec_type
166 --
167 -- OUT:
168 -- x_return_status OUT VARCHAR2
169 -- x_msg_count OUT NUMBER
170 -- x_msg_data OUT VARCHAR2
171 ------------------------------------------------------------------------------
172 PROCEDURE validate_list_word_replace
173 (
174 p_api_version IN NUMBER,
175 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
176 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
177
178 x_return_status OUT NOCOPY VARCHAR2,
179 x_msg_count OUT NOCOPY NUMBER,
180 x_msg_data OUT NOCOPY VARCHAR2,
181
182 p_wrd_rpl_rec IN wrd_rpl_rec_type
183 );
184
185 /****************************************************************************/
186 -- Procedure
187 -- check_items
188 -- Purpose
189 -- item_level validate
190 -- Parameters
191 -- IN:
192 -- p_validation_mode IN VARCHAR2
193 -- p_wrd_rpl_rec IN wrd_rpl_rec_type
194 -- OUT:
195 -- x_return_status OUT VARCHAR2
196 ------------------------------------------------------------------------------
197 PROCEDURE check_items
198 (
199 p_validation_mode IN VARCHAR2,
200 x_return_status OUT NOCOPY VARCHAR2,
201 p_wrd_rpl_rec IN wrd_rpl_rec_type
202 );
203
204 /****************************************************************************/
205 -- Procedure
206 -- check_req_items
207 -- Purpose
208 -- check if required items are missing
209 -- Parameters
210 -- IN:
211 -- p_validation_mode IN VARCHAR2
212 -- p_wrd_rpl_rec IN wrd_rpl_rec_type
213 -- OUT:
214 -- x_return_status OUT VARCHAR2
215 ------------------------------------------------------------------------------
216 PROCEDURE check_req_items
217 (
218 p_validation_mode IN VARCHAR2,
219 p_wrd_rpl_rec IN wrd_rpl_rec_type,
220 x_return_status OUT NOCOPY VARCHAR2
221 );
222
223 /****************************************************************************/
224 -- Procedure
225 -- check_uk_items
226 -- Purpose
227 -- check unique keys
228 -- Parameters
229 -- IN:
230 -- p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
231 -- p_wrd_rpl_rec IN wrd_rpl_rec_type
232 -- OUT:
233 -- x_return_status OUT VARCHAR2
234 ------------------------------------------------------------------------------
235 PROCEDURE check_uk_items
236 (
237 p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
238 p_wrd_rpl_rec IN wrd_rpl_rec_type,
239 x_return_status OUT NOCOPY VARCHAR2
240 );
241
242 /****************************************************************************/
243 -- Procedure
244 -- complete_rec
245 -- Purpose
246 -- replace "g_miss" values with current database values
247 -- Parameters
248 -- IN:
249 -- p_wrd_rpl_rec IN wrd_rpl_rec_type
250 -- OUT:
251 -- x_complete_rec OUT wrd_rpl_rec_type
252 ------------------------------------------------------------------------------
253 PROCEDURE complete_rec
254 (
255 p_wrd_rpl_rec IN wrd_rpl_rec_type,
256 x_complete_rec OUT NOCOPY wrd_rpl_rec_type
257 );
258
259 /****************************************************************************/
260 -- Procedure
261 -- init_rec
262 --
263 -- HISTORY
264 -- 12/19/1999 julou Created.
265 ------------------------------------------------------------------------------
266 PROCEDURE init_rec
267 (
268 x_wrd_rpl_rec OUT NOCOPY wrd_rpl_rec_type
269 );
270
271 END AMS_List_Word_Replaces_PVT;