[Home] [Help]
PACKAGE: APPS.JTF_LOC_AREAS_PVT
Source
1 PACKAGE JTF_Loc_Areas_PVT AUTHID CURRENT_USER AS
2 /* $Header: jtfvloas.pls 120.2 2005/08/18 22:55:20 stopiwal ship $ */
3
4 TYPE loc_area_rec_type IS RECORD
5 (
6 LOCATION_AREA_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 REQUEST_ID NUMBER,
14 PROGRAM_APPLICATION_ID NUMBER,
15 PROGRAM_ID NUMBER,
16 PROGRAM_UPDATE_DATE DATE,
17 LOCATION_TYPE_CODE VARCHAR2(30),
18 START_DATE_ACTIVE DATE,
19 END_DATE_ACTIVE DATE,
20 LOCATION_AREA_CODE VARCHAR2(30),
21 ORIG_SYSTEM_ID NUMBER,
22 ORIG_SYSTEM_REF VARCHAR2(30),
23 PARENT_LOCATION_AREA_ID NUMBER,
24 LOCATION_AREA_NAME VARCHAR2(240),
25 LOCATION_AREA_DESCRIPTION VARCHAR2(4000)
26 );
27
28
29 /****************************************************************************/
30 -- Procedure
31 -- create_loc_area
32 -- Purpose
33 -- create a row in JTF_LOC_AREAS_B and JTF_LOC_AREAS_TL
34 -- Parameters
35 -- IN:
36 -- p_api_version IN NUMBER
37 -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
38 -- p_commit IN VARCHAR2 := FND_API.g_false
39 -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
40 --
41 -- p_loc_area_rec IN loc_area_rec_type
42 --
43 -- OUT:
44 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
45 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
46 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
47 --
48 -- x_loc_area_id OUT NOCOPY /* file.sql.39 change */ NUMBER
49 ------------------------------------------------------------------------------
50 PROCEDURE create_loc_area
51 (
52 p_api_version IN NUMBER,
53 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
54 p_commit IN VARCHAR2 := FND_API.g_false,
55 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
56
57 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
58 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
59 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
60
61 p_loc_area_rec IN loc_area_rec_type,
62 x_loc_area_id OUT NOCOPY /* file.sql.39 change */ NUMBER
63 );
64
65 /****************************************************************************/
66 -- Procedure
67 -- update_loc_area
68 -- Purpose
69 -- update a row in JTF_LOC_AREAS_B and JTF_LOC_AREAS_TL
70 -- Parameters
71 -- IN:
72 -- p_api_version IN NUMBER
73 -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
74 -- p_commit IN VARCHAR2 := FND_API.g_false
75 -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
76 --
77 -- p_loc_area_rec IN loc_area_rec_type
78 -- p_remove_flag IN VARCHAR2 := 'N'
79 --
80 -- OUT:
81 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
82 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
83 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
84 ------------------------------------------------------------------------------
85 PROCEDURE update_loc_area
86 (
87 p_api_version IN NUMBER,
88 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
89 p_commit IN VARCHAR2 := FND_API.g_false,
90 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
91
92 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
93 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
94 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
95
96 p_loc_area_rec IN loc_area_rec_type,
97 p_remove_flag IN VARCHAR2 := 'N'
98 );
99
100 /****************************************************************************/
101 -- Procedure
102 -- delete_loc_area
103 -- Purpose
104 -- delete a row from JTF_LOC_AREAS_B and JTF_LOC_AREAS_TL
105 -- Parameters
106 -- IN:
107 -- p_api_version IN NUMBER
108 -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
109 -- p_commit IN VARCHAR2 := FND_API.g_false
110 --
111 -- p_loc_area_id IN NUMBER
112 -- p_object_version IN NUMBER
113 --
114 -- OUT:
115 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
116 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
117 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
118 ------------------------------------------------------------------------------
119 PROCEDURE delete_loc_area
120 (
121 p_api_version IN NUMBER,
122 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
123 p_commit IN VARCHAR2 := FND_API.g_false,
124
125 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
126 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
127 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
128
129 p_loc_area_id IN NUMBER,
130 p_object_version IN NUMBER
131 );
132
133 /****************************************************************************/
134 -- Procedure
135 -- lock_loc_area
136 -- Purpose
137 -- lock a row form JTF_LOC_AREAS_B and JTF_LOC_AREAS_TL
138 -- Parameters
139 -- IN:
140 -- p_api_version IN NUMBER
141 -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
142 --
143 -- p_loc_area_id IN NUMBER
144 -- p_object_version IN NUMBER
145 --
146 -- OUT:
147 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
148 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
149 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
150 ------------------------------------------------------------------------------
151 PROCEDURE lock_loc_area
152 (
153 p_api_version IN NUMBER,
154 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
155
156 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
157 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
158 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
159
160 p_loc_area_id IN NUMBER,
161 p_object_version IN NUMBER
162 );
163
164 /***************************************************************************/
165 -- Procedure
166 -- validate_loc_area
167 -- Purpose
168 -- validate a record before inserting or updating
169 -- JTF_LOC_AREAS_B and JTF_LOC_AREAS_TL
170 -- Parameters
171 -- IN:
172 -- p_api_version IN NUMBER
173 -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
174 -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
175 --
176 -- p_loc_area_rec IN loc_area_rec_type
177 --
178 -- OUT:
179 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
180 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
181 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
182 ------------------------------------------------------------------------------
183 PROCEDURE validate_loc_area
184 (
185 p_api_version IN NUMBER,
186 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
187 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
188
189 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
190 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
191 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
192
193 p_loc_area_rec IN loc_area_rec_type
194 );
195
196 /****************************************************************************/
197 -- Procedure
198 -- check_items
199 -- Purpose
200 -- item_level validate
201 -- Parameters
202 -- IN:
203 -- p_validation_mode IN VARCHAR2
204 -- p_loc_area_rec IN loc_area_rec_type
205 -- OUT:
206 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
207 ------------------------------------------------------------------------------
208 PROCEDURE check_items
209 (
210 p_validation_mode IN VARCHAR2,
211 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
212 p_loc_area_rec IN loc_area_rec_type
213 );
214
215 /****************************************************************************/
216 -- Procedure
217 -- check_loc_area_req_items
218 -- Purpose
219 -- check if required items are missing
220 -- Parameters
221 -- IN:
222 -- p_validation_mode IN VARCHAR2
223 -- p_loc_area_rec IN loc_area_rec_type
224 -- OUT:
225 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
226 ------------------------------------------------------------------------------
227 PROCEDURE check_loc_area_req_items
228 (
229 p_validation_mode IN VARCHAR2,
230 p_loc_area_rec IN loc_area_rec_type,
231 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
232 );
233
234 /****************************************************************************/
235 -- Procedure
236 -- check_loc_area_uk_items
237 -- Purpose
238 -- check unique keys
239 -- Parameters
240 -- IN:
241 -- p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
242 -- p_loc_area_rec IN loc_area_rec_type
243 -- OUT:
244 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
245 ------------------------------------------------------------------------------
246 PROCEDURE check_loc_area_uk_items
247 (
248 p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
249 p_loc_area_rec IN loc_area_rec_type,
250 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
251 );
252
253 /****************************************************************************/
254 -- Procedure
255 -- check_loc_area_fk_items
256 -- Purpose
257 -- check foreign key items
258 -- Parameters
259 -- IN:
260 -- p_loc_area_rec IN loc_area_rec_type
261 -- OUT:
262 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
263 ------------------------------------------------------------------------------
264 PROCEDURE check_loc_area_fk_items
265 (
266 p_loc_area_rec IN loc_area_rec_type,
267 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
268 );
269
270 /*****************************************************************************/
271 -- Procedure
272 -- check_record
273 -- Purpose
274 -- record level check
275 -- Parameters
276 -- IN:
277 -- p_loc_area_rec IN loc_area_rec_type
278 -- p_complete_rec IN loc_area_rec_type
279 -- OUT:
280 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
281 -- HISTORY
282 -- 12/23/99 julou Created.
283 -------------------------------------------------------------------------------
284 PROCEDURE check_record
285 (
286 p_loc_area_rec IN loc_area_rec_type,
287 p_complete_rec IN loc_area_rec_type,
288 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
289 );
290
291 /****************************************************************************/
292 -- Procedure
293 -- complete_loc_area_rec
294 -- Purpose
295 -- replace "g_miss" or NULL values with current database values
296 -- Parameters
297 -- IN:
298 -- p_loc_area_rec IN loc_area_rec_type
299 -- OUT:
300 -- x_complete_rec OUT NOCOPY /* file.sql.39 change */ loc_area_rec_type
301 ------------------------------------------------------------------------------
302 PROCEDURE complete_loc_area_rec
303 (
304 p_loc_area_rec IN loc_area_rec_type,
305 x_complete_rec OUT NOCOPY /* file.sql.39 change */ loc_area_rec_type
306 );
307
308 /****************************************************************************/
309 -- Procedure
310 -- init_rec
311 --
312 -- HISTORY
313 -- 12/19/1999 julou Created.
314 ------------------------------------------------------------------------------
315 PROCEDURE init_rec
316 (
317 x_loc_area_rec OUT NOCOPY /* file.sql.39 change */ loc_area_rec_type
318 );
319
320 END JTF_Loc_Areas_PVT;