[Home] [Help]
PACKAGE: APPS.JTF_LOC_HIERARCHIES_PVT
Source
1 PACKAGE JTF_Loc_Hierarchies_PVT AS
2 /* $Header: jtfvlohs.pls 120.2 2005/08/18 22:55:30 stopiwal ship $ */
3
4 TYPE loc_hier_rec_type IS RECORD
5 (
6 LOCATION_HIERARCHY_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 CREATED_BY_APPLICATION_ID NUMBER,
18 LOCATION_TYPE_CODE VARCHAR2(30),
19 START_DATE_ACTIVE DATE,
20 END_DATE_ACTIVE DATE,
21 AREA1_ID NUMBER,
22 AREA1_CODE VARCHAR2(30),
23 AREA2_ID NUMBER,
24 AREA2_CODE VARCHAR2(30),
25 COUNTRY_ID NUMBER,
26 COUNTRY_CODE VARCHAR2(30),
27 COUNTRY_REGION_ID NUMBER,
28 COUNTRY_REGION_CODE VARCHAR2(30),
29 STATE_ID NUMBER,
30 STATE_CODE VARCHAR2(30),
31 STATE_REGION_ID NUMBER,
32 STATE_REGION_CODE VARCHAR2(30),
33 CITY_ID NUMBER,
34 CITY_CODE VARCHAR2(30),
35 POSTAL_CODE_ID NUMBER
36 );
37
38 /****************************************************************************/
39 -- Procedure
40 -- create_hierarchy
41 -- Purpose
42 -- create a row in JTF_LOC_HIERARCHIES_B
43 -- Parameters
44 -- IN:
45 -- p_api_version IN NUMBER
46 -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
47 -- p_commit IN VARCHAR2 := FND_API.g_false
48 -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
49 --
50 -- p_loc_hier_rec IN loc_hier_rec_type
51 --
52 -- OUT:
53 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
54 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
55 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
56 -- x_hier_id OUT NOCOPY /* file.sql.39 change */ NUMBER
57 ------------------------------------------------------------------------------
58 PROCEDURE create_hierarchy
59 (
60 p_api_version IN NUMBER,
61 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
62 p_commit IN VARCHAR2 := FND_API.g_false,
63 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
64
65 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
66 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
67 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
68
69 p_loc_hier_rec IN loc_hier_rec_type,
70 x_hier_id OUT NOCOPY /* file.sql.39 change */ NUMBER
71 );
72
73
74 /****************************************************************************/
75 -- Procedure
76 -- update_hierarchy
77 -- Purpose
78 -- update a row in JTF_LOC_HIERARCHIES_B
79 -- Parameters
80 -- IN:
81 -- p_api_version IN NUMBER
82 -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
83 -- p_commit IN VARCHAR2 := FND_API.g_false
84 -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
85 --
86 -- p_loc_hier_rec IN loc_hier_rec_type
87 --
88 -- OUT:
89 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
90 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
91 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
92 ------------------------------------------------------------------------------
93 PROCEDURE update_hierarchy
94 (
95 p_api_version IN NUMBER,
96 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
97 p_commit IN VARCHAR2 := FND_API.g_false,
98 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
99
100 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
101 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
102 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
103
104 p_loc_hier_rec IN loc_hier_rec_type
105 );
106
107
108 /****************************************************************************/
109 -- Procedure
110 -- delete_hierarchy
111 -- Purpose
112 -- delete a row in JTF_LOC_HIERARCHIES_B
113 -- Parameters
114 -- IN:
115 -- p_api_version IN NUMBER
116 -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
117 -- p_commit IN VARCHAR2 := FND_API.g_false
118 --
119 -- p_hier_id IN NUMBER
120 -- p_object_version IN NUMBER
121 --
122 -- OUT:
123 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
124 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
125 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
126 ------------------------------------------------------------------------------
127 PROCEDURE delete_hierarchy
128 (
129 p_api_version IN NUMBER,
130 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
131 p_commit IN VARCHAR2 := FND_API.g_false,
132
133 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
134 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
135 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
136
137 p_hier_id IN NUMBER,
138 p_object_version IN NUMBER
139 );
140
141
142 /****************************************************************************/
143 -- Procedure
144 -- lock_hierarchy
145 -- Purpose
146 -- delete a row in JTF_LOC_HIERARCHIES_B
147 -- Parameters
148 -- IN:
149 -- p_api_version IN NUMBER
150 -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
151 --
152 -- p_hier_id IN NUMBER
153 -- p_object_version IN NUMBER
154 --
155 -- OUT:
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 PROCEDURE lock_hierarchy
161 (
162 p_api_version IN NUMBER,
163 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
164
165 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
166 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
167 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
168
169 p_hier_id IN NUMBER,
170 p_object_version IN NUMBER
171 );
172
173
174 /***************************************************************************/
175 -- Procedure
176 -- validate_hierarchy
177 -- Purpose
178 -- validate a record before inserting or updating JTF_LOC_HIERARCHIES_B
179 -- Parameters
180 -- IN:
181 -- p_api_version IN NUMBER
182 -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
183 -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
184 --
185 -- p_loc_hier_rec IN loc_hier_rec_type
186 --
187 -- OUT:
188 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
189 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
190 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
191 ------------------------------------------------------------------------------
192 PROCEDURE validate_hierarchy
193 (
194 p_api_version IN NUMBER,
195 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
196 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
197
198 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
199 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
200 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
201
202 p_loc_hier_rec IN loc_hier_rec_type
203 );
204
205 /****************************************************************************/
206 -- Procedure
207 -- check_items
208 -- Purpose
209 -- item_level validate
210 -- Parameters
211 -- IN:
212 -- p_validation_mode IN VARCHAR2
213 -- p_loc_hier_rec IN loc_hier_rec_type
214 -- OUT:
215 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
216 ------------------------------------------------------------------------------
217 PROCEDURE check_items
218 (
219 p_validation_mode IN VARCHAR2,
220 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
221 p_loc_hier_rec IN loc_hier_rec_type
222 );
223
224 /****************************************************************************/
225 -- Procedure
226 -- check_req_items
227 -- Purpose
228 -- check if required items are missing
229 -- Parameters
230 -- IN:
231 -- p_validation_mode IN VARCHAR2
232 -- p_loc_hier_rec IN loc_hier_rec_type
233 -- OUT:
234 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
235 ------------------------------------------------------------------------------
236 PROCEDURE check_req_items
237 (
238 p_validation_mode IN VARCHAR2,
239 p_loc_hier_rec IN loc_hier_rec_type,
240 x_return_status OUT NOCOPY /* file.sql.39 change */ 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_loc_hier_rec IN loc_hier_rec_type
252 -- OUT:
253 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
254 ------------------------------------------------------------------------------
255 PROCEDURE check_uk_items
256 (
257 p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
258 p_loc_hier_rec IN loc_hier_rec_type,
259 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
260 );
261
262 /****************************************************************************/
263 -- Procedure
264 -- check_fk_items
265 -- Purpose
266 -- check foreign key items
267 -- Parameters
268 -- IN:
269 -- p_loc_hier_rec IN loc_hier_rec_type
270 -- OUT:
271 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
272 ------------------------------------------------------------------------------
273 PROCEDURE check_fk_items
274 (
275 p_loc_hier_rec IN loc_hier_rec_type,
276 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
277 );
278
279 /*****************************************************************************/
280 -- Procedure
281 -- check_record
282 -- Purpose
283 -- record level check
284 -- Parameters
285 -- IN:
286 -- p_loc_hier_rec IN loc_hier_rec_type
287 -- p_complete_rec IN loc_hier_rec_type
288 -- OUT:
289 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
290 -- HISTORY
291 -- 12/23/99 julou Created.
292 -------------------------------------------------------------------------------
293 PROCEDURE check_record
294 (
295 p_loc_hier_rec IN loc_hier_rec_type,
296 p_complete_rec IN loc_hier_rec_type,
297 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
298 );
299
300 /****************************************************************************/
301 -- Procedure
302 -- complete_rec
303 -- Purpose
304 -- replace "g_miss" values with current database values
305 -- Parameters
306 -- IN:
307 -- p_loc_hier_rec IN loc_hier_rec_type
308 -- OUT:
309 -- x_complete_rec OUT NOCOPY /* file.sql.39 change */ loc_hier_rec_type
310 ------------------------------------------------------------------------------
311 PROCEDURE complete_rec
312 (
313 p_loc_hier_rec IN loc_hier_rec_type,
314 x_complete_rec OUT NOCOPY /* file.sql.39 change */ loc_hier_rec_type
315 );
316
317 /****************************************************************************/
318 -- Procedure
319 -- init_rec
320 --
321 -- HISTORY
322 -- 12/19/1999 julou Created.
323 ------------------------------------------------------------------------------
324 PROCEDURE init_rec
325 (
326 x_loc_hier_rec OUT NOCOPY /* file.sql.39 change */ loc_hier_rec_type
327 );
328
329 END JTF_Loc_Hierarchies_PVT;