[Home] [Help]
PACKAGE: APPS.JTF_LOC_POSTAL_CODES_PVT
Source
1 PACKAGE JTF_Loc_Postal_Codes_PVT AUTHID CURRENT_USER AS
2 /* $Header: jtfvlops.pls 120.2 2005/08/18 22:55:39 stopiwal ship $ */
3
4 TYPE postal_code_rec_type IS RECORD
5 (
6 LOCATION_POSTAL_CODE_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 ORIG_SYSTEM_REF VARCHAR2(30),
14 ORIG_SYSTEM_ID NUMBER,
15 LOCATION_AREA_ID NUMBER,
16 START_DATE_ACTIVE DATE,
17 END_DATE_ACTIVE DATE,
18 POSTAL_CODE_START VARCHAR2(6),
19 POSTAL_CODE_END VARCHAR2(6)
20 );
21
22
23 /****************************************************************************/
24 -- Procedure
25 -- create_postal_code
26 -- Purpose
27 -- create rows in JTF_LOC_POSTAL_CODES
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_postal_code_rec IN postal_code_rec_type
36 --
37 -- OUT:
38 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
39 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
40 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
41 --
42 -- x_postal_code_id OUT NOCOPY /* file.sql.39 change */ NUMBER
43 ------------------------------------------------------------------------------
44 PROCEDURE create_postal_code
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 /* file.sql.39 change */ VARCHAR2,
52 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
53 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
54
55 p_postal_code_rec IN postal_code_rec_type,
56 x_postal_code_id OUT NOCOPY /* file.sql.39 change */ NUMBER
57 );
58
59 /****************************************************************************/
60 -- Procedure
61 -- update_postal_code
62 -- Purpose
63 -- update rows in JTF_LOC_POSTAL_CODES
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 -- p_remove_flag IN VARCHAR2 := 'N'
71 -- p_postal_code_rec IN postal_code_rec_type
72 --
73 -- OUT:
74 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
75 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
76 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
77 ------------------------------------------------------------------------------
78 PROCEDURE update_postal_code
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 /* file.sql.39 change */ VARCHAR2,
86 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
87 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
88
89 p_postal_code_rec IN postal_code_rec_type,
90 p_remove_flag IN VARCHAR2 := 'N'
91 );
92
93 /****************************************************************************/
94 -- Procedure
95 -- delete_postal_code
96 -- Purpose
97 -- delete rows in JTF_LOC_POSTAL_CODES
98 -- Parameters
99 -- IN:
100 -- p_api_version IN NUMBER
101 -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
102 -- p_commit IN VARCHAR2 := FND_API.g_false
103 --
104 -- p_postal_code_id IN NUMBER
105 -- p_object_version IN NUMBER
106 --
107 -- OUT:
108 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
109 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
110 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
111 ------------------------------------------------------------------------------
112 PROCEDURE delete_postal_code
113 (
114 p_api_version IN NUMBER,
115 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
116 p_commit IN VARCHAR2 := FND_API.g_false,
117
118 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
119 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
120 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
121
122 p_postal_code_id IN NUMBER,
123 p_object_version IN NUMBER
124 );
125
126 /****************************************************************************/
127 -- Procedure
128 -- lock_postal_code
129 -- Purpose
130 -- lock rows in JTF_LOC_POSTAL_CODES
131 -- Parameters
132 -- IN:
133 -- p_api_version IN NUMBER
134 -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
135 --
136 -- p_postal_code_id IN NUMBER
137 -- p_object_version IN NUMBER
138 --
139 -- OUT:
140 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
141 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
142 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
143 ------------------------------------------------------------------------------
144 PROCEDURE lock_postal_code
145 (
146 p_api_version IN NUMBER,
147 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
148
149 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
150 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
151 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
152
153 p_postal_code_id IN NUMBER,
154 p_object_version IN NUMBER
155 );
156
157 /***************************************************************************/
158 -- Procedure
159 -- validate_postal_code
160 -- Purpose
161 -- validate the record
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_postal_code_rec IN postal_code_rec_type
169 --
170 -- OUT:
171 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
172 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
173 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
174 ------------------------------------------------------------------------------
175 PROCEDURE validate_postal_code
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 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
181 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
182 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
183
184 p_postal_code_rec IN postal_code_rec_type
185 );
186
187 /****************************************************************************/
188 -- Procedure
189 -- check_items
190 -- Purpose
191 -- item_level validate
192 -- Parameters
193 -- IN:
194 -- p_validation_mode IN VARCHAR2
195 -- p_postal_code_rec IN postal_code_rec_type
196 -- OUT:
197 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
198 ------------------------------------------------------------------------------
199 PROCEDURE check_items
200 (
201 p_validation_mode IN VARCHAR2,
202 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
203 p_postal_code_rec IN postal_code_rec_type
204 );
205
206 /****************************************************************************/
207 -- Procedure
208 -- check_req_items
209 -- Purpose
210 -- check if required items are miss
211 -- Parameters
212 -- IN:
213 -- p_validation_mode IN VARCHAR2
214 -- p_postal_code_rec IN postal_code_rec_type
215 -- OUT:
216 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
217 ------------------------------------------------------------------------------
218 PROCEDURE check_req_items
219 (
220 p_validation_mode IN VARCHAR2,
221 p_postal_code_rec IN postal_code_rec_type,
222 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
223 );
224
225 /****************************************************************************/
226 -- Procedure
227 -- check_fk_items
228 -- Purpose
229 -- check foreign key items
230 -- Parameters
231 -- IN:
232 -- p_postal_code_rec IN postal_code_rec_type
233 -- OUT:
234 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
235 ------------------------------------------------------------------------------
236 PROCEDURE check_fk_items
237 (
238 p_postal_code_rec IN postal_code_rec_type,
239 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
240 );
241
242 /*****************************************************************************/
243 -- Procedure
244 -- check_record
245 -- Purpose
246 -- record level check
247 -- Parameters
248 -- IN:
249 -- p_postal_code_rec IN postal_code_rec_type
250 -- p_complete_rec IN postal_code_rec_type
251 -- OUT:
252 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
253 -- HISTORY
254 -- 12/23/99 julou Created.
255 -------------------------------------------------------------------------------
256 PROCEDURE check_record
257 (
258 p_postal_code_rec IN postal_code_rec_type,
259 p_complete_rec IN postal_code_rec_type,
260 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
261 );
262
263 /****************************************************************************/
264 -- Procedure
265 -- complete_rec
266 -- Purpose
267 -- replace "g_miss" or NULL values with current database values
268 -- Parameters
269 -- IN:
270 -- p_postal_code_rec IN postal_code_rec_type
271 -- OUT:
272 -- x_complete_rec OUT NOCOPY /* file.sql.39 change */ postal_code_rec_type
273 ------------------------------------------------------------------------------
274 PROCEDURE complete_rec
275 (
276 p_postal_code_rec IN postal_code_rec_type,
277 x_complete_rec OUT NOCOPY /* file.sql.39 change */ postal_code_rec_type
278 );
279
280 /****************************************************************************/
281 -- Procedure
282 -- init_rec
283 -- Purpose
284 -- initialize a record
285 -- Parameters
286 ------------------------------------------------------------------------------
287 PROCEDURE init_rec
288 (
289 x_postal_code_rec OUT NOCOPY /* file.sql.39 change */ postal_code_rec_type
290 );
291
292 END JTF_Loc_Postal_Codes_PVT;