[Home] [Help]
PACKAGE: APPS.OKL_OIA_PVT
Source
1 Package OKL_OIA_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSOIAS.pls 120.2 2006/07/11 10:23:02 dkagrawa noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE oiav_rec_type IS RECORD (
7 id NUMBER := OKC_API.G_MISS_NUM
8 ,khr_id NUMBER := OKC_API.G_MISS_NUM
9 ,instance_number OKL_OPEN_INT_ASST.INSTANCE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
10 ,asset_id NUMBER := OKC_API.G_MISS_NUM
11 ,asset_number OKL_OPEN_INT_ASST.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
12 ,description OKL_OPEN_INT_ASST.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
13 ,asset_type OKL_OPEN_INT_ASST.ASSET_TYPE%TYPE := OKC_API.G_MISS_CHAR
14 ,manufacturer_name OKL_OPEN_INT_ASST.MANUFACTURER_NAME%TYPE := OKC_API.G_MISS_CHAR
15 ,model_number OKL_OPEN_INT_ASST.MODEL_NUMBER%TYPE := OKC_API.G_MISS_CHAR
16 ,serial_number OKL_OPEN_INT_ASST.SERIAL_NUMBER%TYPE := OKC_API.G_MISS_CHAR
17 ,tag_number OKL_OPEN_INT_ASST.TAG_NUMBER%TYPE := OKC_API.G_MISS_CHAR
18 ,original_cost NUMBER := OKC_API.G_MISS_NUM
19 ,quantity OKL_OPEN_INT_ASST.QUANTITY%TYPE := OKC_API.G_MISS_CHAR
20 ,country OKL_OPEN_INT_ASST.COUNTRY%TYPE := OKC_API.G_MISS_CHAR
21 ,address1 OKL_OPEN_INT_ASST.ADDRESS1%TYPE := OKC_API.G_MISS_CHAR
22 ,address2 OKL_OPEN_INT_ASST.ADDRESS2%TYPE := OKC_API.G_MISS_CHAR
23 ,address3 OKL_OPEN_INT_ASST.ADDRESS3%TYPE := OKC_API.G_MISS_CHAR
24 ,address4 OKL_OPEN_INT_ASST.ADDRESS4%TYPE := OKC_API.G_MISS_CHAR
25 ,city OKL_OPEN_INT_ASST.CITY%TYPE := OKC_API.G_MISS_CHAR
26 ,postal_code OKL_OPEN_INT_ASST.POSTAL_CODE%TYPE := OKC_API.G_MISS_CHAR
27 ,state OKL_OPEN_INT_ASST.STATE%TYPE := OKC_API.G_MISS_CHAR
28 ,province OKL_OPEN_INT_ASST.PROVINCE%TYPE := OKC_API.G_MISS_CHAR
29 ,county OKL_OPEN_INT_ASST.COUNTY%TYPE := OKC_API.G_MISS_CHAR
30 ,po_box_number OKL_OPEN_INT_ASST.PO_BOX_NUMBER%TYPE := OKC_API.G_MISS_CHAR
31 ,house_number OKL_OPEN_INT_ASST.HOUSE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
32 ,street_suffix OKL_OPEN_INT_ASST.STREET_SUFFIX%TYPE := OKC_API.G_MISS_CHAR
33 ,apartment_number OKL_OPEN_INT_ASST.APARTMENT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
34 ,street OKL_OPEN_INT_ASST.STREET%TYPE := OKC_API.G_MISS_CHAR
35 ,rural_route_number OKL_OPEN_INT_ASST.RURAL_ROUTE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
36 ,street_number OKL_OPEN_INT_ASST.STREET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
37 ,building OKL_OPEN_INT_ASST.BUILDING%TYPE := OKC_API.G_MISS_CHAR
38 ,floor OKL_OPEN_INT_ASST.FLOOR%TYPE := OKC_API.G_MISS_CHAR
39 ,suite OKL_OPEN_INT_ASST.SUITE%TYPE := OKC_API.G_MISS_CHAR
40 ,room OKL_OPEN_INT_ASST.ROOM%TYPE := OKC_API.G_MISS_CHAR
41 ,postal_plus4_code OKL_OPEN_INT_ASST.POSTAL_PLUS4_CODE%TYPE := OKC_API.G_MISS_CHAR
42 ,object_version_number NUMBER := OKC_API.G_MISS_NUM
43 ,org_id NUMBER := OKC_API.G_MISS_NUM
44 ,request_id NUMBER := OKC_API.G_MISS_NUM
45 ,program_application_id NUMBER := OKC_API.G_MISS_NUM
46 ,program_id NUMBER := OKC_API.G_MISS_NUM
47 ,program_update_date OKL_OPEN_INT_ASST.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
48 ,attribute_category OKL_OPEN_INT_ASST.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
49 ,attribute1 OKL_OPEN_INT_ASST.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
50 ,attribute2 OKL_OPEN_INT_ASST.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
51 ,attribute3 OKL_OPEN_INT_ASST.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
52 ,attribute4 OKL_OPEN_INT_ASST.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
53 ,attribute5 OKL_OPEN_INT_ASST.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
54 ,attribute6 OKL_OPEN_INT_ASST.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
55 ,attribute7 OKL_OPEN_INT_ASST.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
56 ,attribute8 OKL_OPEN_INT_ASST.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
57 ,attribute9 OKL_OPEN_INT_ASST.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
58 ,attribute10 OKL_OPEN_INT_ASST.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
59 ,attribute11 OKL_OPEN_INT_ASST.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
60 ,attribute12 OKL_OPEN_INT_ASST.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
61 ,attribute13 OKL_OPEN_INT_ASST.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
62 ,attribute14 OKL_OPEN_INT_ASST.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
63 ,attribute15 OKL_OPEN_INT_ASST.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
64 ,created_by NUMBER := OKC_API.G_MISS_NUM
65 ,creation_date OKL_OPEN_INT_ASST.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
66 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
67 ,last_update_date OKL_OPEN_INT_ASST.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
68 ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
69 G_MISS_oiav_rec oiav_rec_type;
70 TYPE oiav_tbl_type IS TABLE OF oiav_rec_type
71 INDEX BY BINARY_INTEGER;
72 TYPE oia_rec_type IS RECORD (
73 id NUMBER := OKC_API.G_MISS_NUM
74 ,khr_id NUMBER := OKC_API.G_MISS_NUM
75 ,instance_number OKL_OPEN_INT_ASST.INSTANCE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
76 ,asset_id NUMBER := OKC_API.G_MISS_NUM
77 ,asset_number OKL_OPEN_INT_ASST.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
78 ,description OKL_OPEN_INT_ASST.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
79 ,asset_type OKL_OPEN_INT_ASST.ASSET_TYPE%TYPE := OKC_API.G_MISS_CHAR
80 ,manufacturer_name OKL_OPEN_INT_ASST.MANUFACTURER_NAME%TYPE := OKC_API.G_MISS_CHAR
81 ,model_number OKL_OPEN_INT_ASST.MODEL_NUMBER%TYPE := OKC_API.G_MISS_CHAR
82 ,serial_number OKL_OPEN_INT_ASST.SERIAL_NUMBER%TYPE := OKC_API.G_MISS_CHAR
83 ,tag_number OKL_OPEN_INT_ASST.TAG_NUMBER%TYPE := OKC_API.G_MISS_CHAR
84 ,original_cost NUMBER := OKC_API.G_MISS_NUM
85 ,quantity OKL_OPEN_INT_ASST.QUANTITY%TYPE := OKC_API.G_MISS_CHAR
86 ,country OKL_OPEN_INT_ASST.COUNTRY%TYPE := OKC_API.G_MISS_CHAR
87 ,address1 OKL_OPEN_INT_ASST.ADDRESS1%TYPE := OKC_API.G_MISS_CHAR
88 ,address2 OKL_OPEN_INT_ASST.ADDRESS2%TYPE := OKC_API.G_MISS_CHAR
89 ,address3 OKL_OPEN_INT_ASST.ADDRESS3%TYPE := OKC_API.G_MISS_CHAR
90 ,address4 OKL_OPEN_INT_ASST.ADDRESS4%TYPE := OKC_API.G_MISS_CHAR
91 ,city OKL_OPEN_INT_ASST.CITY%TYPE := OKC_API.G_MISS_CHAR
92 ,postal_code OKL_OPEN_INT_ASST.POSTAL_CODE%TYPE := OKC_API.G_MISS_CHAR
93 ,state OKL_OPEN_INT_ASST.STATE%TYPE := OKC_API.G_MISS_CHAR
94 ,province OKL_OPEN_INT_ASST.PROVINCE%TYPE := OKC_API.G_MISS_CHAR
95 ,county OKL_OPEN_INT_ASST.COUNTY%TYPE := OKC_API.G_MISS_CHAR
96 ,po_box_number OKL_OPEN_INT_ASST.PO_BOX_NUMBER%TYPE := OKC_API.G_MISS_CHAR
97 ,house_number OKL_OPEN_INT_ASST.HOUSE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
98 ,street_suffix OKL_OPEN_INT_ASST.STREET_SUFFIX%TYPE := OKC_API.G_MISS_CHAR
99 ,apartment_number OKL_OPEN_INT_ASST.APARTMENT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
100 ,street OKL_OPEN_INT_ASST.STREET%TYPE := OKC_API.G_MISS_CHAR
101 ,rural_route_number OKL_OPEN_INT_ASST.RURAL_ROUTE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
102 ,street_number OKL_OPEN_INT_ASST.STREET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
103 ,building OKL_OPEN_INT_ASST.BUILDING%TYPE := OKC_API.G_MISS_CHAR
104 ,floor OKL_OPEN_INT_ASST.FLOOR%TYPE := OKC_API.G_MISS_CHAR
105 ,suite OKL_OPEN_INT_ASST.SUITE%TYPE := OKC_API.G_MISS_CHAR
106 ,room OKL_OPEN_INT_ASST.ROOM%TYPE := OKC_API.G_MISS_CHAR
107 ,postal_plus4_code OKL_OPEN_INT_ASST.POSTAL_PLUS4_CODE%TYPE := OKC_API.G_MISS_CHAR
108 ,object_version_number NUMBER := OKC_API.G_MISS_NUM
109 ,org_id NUMBER := OKC_API.G_MISS_NUM
110 ,request_id NUMBER := OKC_API.G_MISS_NUM
111 ,program_application_id NUMBER := OKC_API.G_MISS_NUM
112 ,program_id NUMBER := OKC_API.G_MISS_NUM
113 ,program_update_date OKL_OPEN_INT_ASST.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
114 ,attribute_category OKL_OPEN_INT_ASST.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
115 ,attribute1 OKL_OPEN_INT_ASST.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
116 ,attribute2 OKL_OPEN_INT_ASST.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
117 ,attribute3 OKL_OPEN_INT_ASST.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
118 ,attribute4 OKL_OPEN_INT_ASST.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
119 ,attribute5 OKL_OPEN_INT_ASST.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
120 ,attribute6 OKL_OPEN_INT_ASST.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
121 ,attribute7 OKL_OPEN_INT_ASST.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
122 ,attribute8 OKL_OPEN_INT_ASST.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
123 ,attribute9 OKL_OPEN_INT_ASST.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
124 ,attribute10 OKL_OPEN_INT_ASST.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
125 ,attribute11 OKL_OPEN_INT_ASST.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
126 ,attribute12 OKL_OPEN_INT_ASST.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
127 ,attribute13 OKL_OPEN_INT_ASST.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
128 ,attribute14 OKL_OPEN_INT_ASST.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
129 ,attribute15 OKL_OPEN_INT_ASST.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
130 ,created_by NUMBER := OKC_API.G_MISS_NUM
131 ,creation_date OKL_OPEN_INT_ASST.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
132 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
133 ,last_update_date OKL_OPEN_INT_ASST.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
134 ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
135 G_MISS_oia_rec oia_rec_type;
136 TYPE oia_tbl_type IS TABLE OF oia_rec_type
137 INDEX BY BINARY_INTEGER;
138 ---------------------------------------------------------------------------
139 -- GLOBAL MESSAGE CONSTANTS
140 ---------------------------------------------------------------------------
141 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
142 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
143 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
144 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
145 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
146 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
147 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
148 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
149 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
150 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
151 --G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
152 --G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
153 --G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
154
155 ---------------------------------------------------------------------------
156 -- GLOBAL EXCEPTIONS
157 ---------------------------------------------------------------------------
158 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
159
160 ---------------------------------------------------------------------------
161 -- GLOBAL VARIABLES
162 ---------------------------------------------------------------------------
163 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_OIA_PVT';
164 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
165 -------------------------------------------------------------------------------
166 --Post change to TAPI code
167 -------------------------------------------------------------------------------
168 --G_EXCEPTION_HALT_VALIDATION EXCEPTION;
169 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
170 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
171 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
172 g_no_parent_record CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
173 ---------------------------------------------------------------------------
174 ---------------------------------------------------------------------------
175 -- Procedures and Functions
176 ---------------------------------------------------------------------------
177
178 PROCEDURE qc;
179 PROCEDURE change_version;
180 PROCEDURE api_copy;
181 PROCEDURE insert_row(
182 p_api_version IN NUMBER,
183 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
184 x_return_status OUT NOCOPY VARCHAR2,
185 x_msg_count OUT NOCOPY NUMBER,
186 x_msg_data OUT NOCOPY VARCHAR2,
187 p_oiav_rec IN oiav_rec_type,
188 x_oiav_rec OUT NOCOPY oiav_rec_type);
189 PROCEDURE insert_row(
190 p_api_version IN NUMBER,
191 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
192 x_return_status OUT NOCOPY VARCHAR2,
193 x_msg_count OUT NOCOPY NUMBER,
194 x_msg_data OUT NOCOPY VARCHAR2,
195 p_oiav_tbl IN oiav_tbl_type,
196 x_oiav_tbl OUT NOCOPY oiav_tbl_type,
197 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
198 PROCEDURE insert_row(
199 p_api_version IN NUMBER,
200 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
201 x_return_status OUT NOCOPY VARCHAR2,
202 x_msg_count OUT NOCOPY NUMBER,
203 x_msg_data OUT NOCOPY VARCHAR2,
204 p_oiav_tbl IN oiav_tbl_type,
205 x_oiav_tbl OUT NOCOPY oiav_tbl_type);
206 PROCEDURE lock_row(
207 p_api_version IN NUMBER,
208 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
209 x_return_status OUT NOCOPY VARCHAR2,
210 x_msg_count OUT NOCOPY NUMBER,
211 x_msg_data OUT NOCOPY VARCHAR2,
212 p_oiav_rec IN oiav_rec_type);
213 PROCEDURE lock_row(
214 p_api_version IN NUMBER,
215 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
216 x_return_status OUT NOCOPY VARCHAR2,
217 x_msg_count OUT NOCOPY NUMBER,
218 x_msg_data OUT NOCOPY VARCHAR2,
219 p_oiav_tbl IN oiav_tbl_type,
220 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
221 PROCEDURE lock_row(
222 p_api_version IN NUMBER,
223 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
224 x_return_status OUT NOCOPY VARCHAR2,
225 x_msg_count OUT NOCOPY NUMBER,
226 x_msg_data OUT NOCOPY VARCHAR2,
227 p_oiav_tbl IN oiav_tbl_type);
228 PROCEDURE update_row(
229 p_api_version IN NUMBER,
230 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
231 x_return_status OUT NOCOPY VARCHAR2,
232 x_msg_count OUT NOCOPY NUMBER,
233 x_msg_data OUT NOCOPY VARCHAR2,
234 p_oiav_rec IN oiav_rec_type,
235 x_oiav_rec OUT NOCOPY oiav_rec_type);
236 PROCEDURE update_row(
237 p_api_version IN NUMBER,
238 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
239 x_return_status OUT NOCOPY VARCHAR2,
240 x_msg_count OUT NOCOPY NUMBER,
241 x_msg_data OUT NOCOPY VARCHAR2,
242 p_oiav_tbl IN oiav_tbl_type,
243 x_oiav_tbl OUT NOCOPY oiav_tbl_type,
244 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
245 PROCEDURE update_row(
246 p_api_version IN NUMBER,
247 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
248 x_return_status OUT NOCOPY VARCHAR2,
249 x_msg_count OUT NOCOPY NUMBER,
250 x_msg_data OUT NOCOPY VARCHAR2,
251 p_oiav_tbl IN oiav_tbl_type,
252 x_oiav_tbl OUT NOCOPY oiav_tbl_type);
253 PROCEDURE delete_row(
254 p_api_version IN NUMBER,
255 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
256 x_return_status OUT NOCOPY VARCHAR2,
257 x_msg_count OUT NOCOPY NUMBER,
258 x_msg_data OUT NOCOPY VARCHAR2,
259 p_oiav_rec IN oiav_rec_type);
260 PROCEDURE delete_row(
261 p_api_version IN NUMBER,
262 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
263 x_return_status OUT NOCOPY VARCHAR2,
264 x_msg_count OUT NOCOPY NUMBER,
265 x_msg_data OUT NOCOPY VARCHAR2,
266 p_oiav_tbl IN oiav_tbl_type,
267 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
268 PROCEDURE delete_row(
269 p_api_version IN NUMBER,
270 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
271 x_return_status OUT NOCOPY VARCHAR2,
272 x_msg_count OUT NOCOPY NUMBER,
273 x_msg_data OUT NOCOPY VARCHAR2,
274 p_oiav_tbl IN oiav_tbl_type);
275 PROCEDURE validate_row(
276 p_api_version IN NUMBER,
277 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
278 x_return_status OUT NOCOPY VARCHAR2,
279 x_msg_count OUT NOCOPY NUMBER,
280 x_msg_data OUT NOCOPY VARCHAR2,
281 p_oiav_rec IN oiav_rec_type);
282 PROCEDURE validate_row(
283 p_api_version IN NUMBER,
284 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
285 x_return_status OUT NOCOPY VARCHAR2,
286 x_msg_count OUT NOCOPY NUMBER,
287 x_msg_data OUT NOCOPY VARCHAR2,
288 p_oiav_tbl IN oiav_tbl_type,
289 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
290 PROCEDURE validate_row(
291 p_api_version IN NUMBER,
292 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
293 x_return_status OUT NOCOPY VARCHAR2,
294 x_msg_count OUT NOCOPY NUMBER,
295 x_msg_data OUT NOCOPY VARCHAR2,
296 p_oiav_tbl IN oiav_tbl_type);
297 END OKL_OIA_PVT;