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