[Home] [Help]
PACKAGE: APPS.OKL_XPI_PVT
Source
1 PACKAGE OKL_XPI_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSXPIS.pls 120.3 2007/02/28 00:09:51 ssiruvol noship $ */
3 ---------------------------------------------------------------------------
4 -- PostGen --
5 -- SPEC:
6 -- 0. Global Messages (5) and Variables (2) = Done!
7 -- 06/01/00: Post postgen changes
8 -- Added 1 new column: TRX_STATUS_CODE
9 -- 30-OCT-2006 ANSETHUR R12B - Legal Entity
10 -- Added New column : Legal entity Id
11 -- BODY:
12 -- 1. Check for Not Null Primary Keys
13 -- 2. Check for Not Null Foreign Keys
14 -- 5. Validity of Foreign Keys, where applicable
15 -- 4. Validity of Unique Keys, where applicable
16 -- 3. Validity of Org_id, where applicable
17 -- 6. Added domain validation, where applicable
18 -- 7. Added the Concurrent Manager Columns ( p104 )
19 -- 8. Any lookup code should be validated using the OKL_UTIL package.
20 -- 9. 02/04/02: Added new columns vendor_invoice_number, pay_group_lookup_code, nettable_yn.
21 -- 10. Added New column : Legal entity Id : 30-OCT-2006 ANSETHUR R12B - Legal Entity
22 ---------------------------------------------------------------------------
23 -- GLOBAL DATASTRUCTURES
24 ---------------------------------------------------------------------------
25 TYPE xpi_rec_type IS RECORD (
26 id NUMBER := OKL_API.G_MISS_NUM,
27 invoice_id NUMBER := OKL_API.G_MISS_NUM,
28 object_version_number NUMBER := OKL_API.G_MISS_NUM,
29 trx_status_code OKL_EXT_PAY_INVS_B.TRX_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR, -- Post postgen add column
30 invoice_num OKL_EXT_PAY_INVS_B.INVOICE_NUM%TYPE := OKL_API.G_MISS_CHAR,
31 invoice_type OKL_EXT_PAY_INVS_B.INVOICE_TYPE%TYPE := OKL_API.G_MISS_CHAR,
32 invoice_date OKL_EXT_PAY_INVS_B.INVOICE_DATE%TYPE := OKL_API.G_MISS_DATE,
33 vendor_id NUMBER := OKL_API.G_MISS_NUM,
34 vendor_site_id NUMBER := OKL_API.G_MISS_NUM,
35 invoice_amount NUMBER := OKL_API.G_MISS_NUM,
36 invoice_currency_code OKL_EXT_PAY_INVS_B.INVOICE_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR,
37 terms_id NUMBER := OKL_API.G_MISS_NUM,
38 workflow_flag OKL_EXT_PAY_INVS_B.WORKFLOW_FLAG%TYPE := OKL_API.G_MISS_CHAR,
39 doc_category_code OKL_EXT_PAY_INVS_B.DOC_CATEGORY_CODE%TYPE := OKL_API.G_MISS_CHAR,
40 payment_method OKL_EXT_PAY_INVS_B.PAYMENT_METHOD%TYPE := OKL_API.G_MISS_CHAR,
41 gl_date OKL_EXT_PAY_INVS_B.GL_DATE%TYPE := OKL_API.G_MISS_DATE,
42 accts_pay_cc_id NUMBER := OKL_API.G_MISS_NUM,
43 pay_alone_flag OKL_EXT_PAY_INVS_B.PAY_ALONE_FLAG%TYPE := OKL_API.G_MISS_CHAR,
44 wait_vendor_invoice_yn OKL_EXT_PAY_INVS_B.WAIT_VENDOR_INVOICE_YN%TYPE := OKL_API.G_MISS_CHAR,
45 payables_invoice_id NUMBER := OKL_API.G_MISS_NUM,
46 request_id NUMBER := OKL_API.G_MISS_NUM,
47 program_application_id NUMBER := OKL_API.G_MISS_NUM,
48 program_id NUMBER := OKL_API.G_MISS_NUM,
49 program_update_date OKL_EXT_PAY_INVS_B.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
50 org_id NUMBER := OKL_API.G_MISS_NUM,
51 CURRENCY_CONVERSION_TYPE OKL_EXT_PAY_INVS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR,
52 CURRENCY_CONVERSION_RATE NUMBER := OKL_API.G_MISS_NUM,
53 CURRENCY_CONVERSION_DATE OKL_EXT_PAY_INVS_B.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE,
54 attribute_category OKL_EXT_PAY_INVS_B.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
55 attribute1 OKL_EXT_PAY_INVS_B.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
56 attribute2 OKL_EXT_PAY_INVS_B.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
57 attribute3 OKL_EXT_PAY_INVS_B.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
58 attribute4 OKL_EXT_PAY_INVS_B.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
59 attribute5 OKL_EXT_PAY_INVS_B.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
60 attribute6 OKL_EXT_PAY_INVS_B.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
61 attribute7 OKL_EXT_PAY_INVS_B.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
62 attribute8 OKL_EXT_PAY_INVS_B.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
63 attribute9 OKL_EXT_PAY_INVS_B.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
64 attribute10 OKL_EXT_PAY_INVS_B.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
65 attribute11 OKL_EXT_PAY_INVS_B.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
66 attribute12 OKL_EXT_PAY_INVS_B.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
67 attribute13 OKL_EXT_PAY_INVS_B.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
68 attribute14 OKL_EXT_PAY_INVS_B.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
69 attribute15 OKL_EXT_PAY_INVS_B.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
70 created_by NUMBER := OKL_API.G_MISS_NUM,
71 creation_date OKL_EXT_PAY_INVS_B.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
72 last_updated_by NUMBER := OKL_API.G_MISS_NUM,
73 last_update_date OKL_EXT_PAY_INVS_B.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
74 last_update_login NUMBER := OKL_API.G_MISS_NUM,
75 pay_group_lookup_code OKL_EXT_PAY_INVS_B.PAY_GROUP_LOOKUP_CODE%TYPE,
76 vendor_invoice_number OKL_EXT_PAY_INVS_B.VENDOR_INVOICE_NUMBER%TYPE,
77 nettable_yn OKL_EXT_PAY_INVS_B.NETTABLE_YN%TYPE,
78 -- 30-OCT-2006 ANSETHUR R12B - Legal Entity
79 legal_entity_id OKL_EXT_PAY_INVS_B.legal_entity_id%TYPE := OKL_API.G_MISS_NUM,
80 CNSLD_AP_INV_ID OKL_EXT_PAY_INVS_B.CNSLD_AP_INV_ID%TYPE := OKL_API.G_MISS_NUM);
81 g_miss_xpi_rec xpi_rec_type;
82 TYPE xpi_tbl_type IS TABLE OF xpi_rec_type
83 INDEX BY BINARY_INTEGER;
84 TYPE okl_ext_pay_invs_tl_rec_type IS RECORD (
85 id NUMBER := OKL_API.G_MISS_NUM,
86 language OKL_EXT_PAY_INVS_TL.LANGUAGE%TYPE := OKL_API.G_MISS_CHAR,
87 source_lang OKL_EXT_PAY_INVS_TL.SOURCE_LANG%TYPE := OKL_API.G_MISS_CHAR,
88 sfwt_flag OKL_EXT_PAY_INVS_TL.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR,
89 description OKL_EXT_PAY_INVS_TL.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR,
90 source OKL_EXT_PAY_INVS_TL.SOURCE%TYPE := OKL_API.G_MISS_CHAR,
91 stream_type OKL_EXT_PAY_INVS_TL.STREAM_TYPE%TYPE := OKL_API.G_MISS_CHAR,
92 created_by NUMBER := OKL_API.G_MISS_NUM,
93 creation_date OKL_EXT_PAY_INVS_TL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
94 last_updated_by NUMBER := OKL_API.G_MISS_NUM,
95 last_update_date OKL_EXT_PAY_INVS_TL.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
96 last_update_login NUMBER := OKL_API.G_MISS_NUM);
97 g_miss_okl_ext_pay_invs_tl_rec okl_ext_pay_invs_tl_rec_type;
98 TYPE okl_ext_pay_invs_tl_tbl_type IS TABLE OF okl_ext_pay_invs_tl_rec_type
99 INDEX BY BINARY_INTEGER;
100 TYPE xpiv_rec_type IS RECORD (
101 id NUMBER := OKL_API.G_MISS_NUM,
102 object_version_number NUMBER := OKL_API.G_MISS_NUM,
103 sfwt_flag OKL_EXT_PAY_INVS_V.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR,
104 trx_status_code OKL_EXT_PAY_INVS_V.TRX_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR, -- Post postgen add column
105 invoice_id NUMBER := OKL_API.G_MISS_NUM,
106 invoice_num OKL_EXT_PAY_INVS_V.INVOICE_NUM%TYPE := OKL_API.G_MISS_CHAR,
107 invoice_type OKL_EXT_PAY_INVS_V.INVOICE_TYPE%TYPE := OKL_API.G_MISS_CHAR,
108 invoice_date OKL_EXT_PAY_INVS_V.INVOICE_DATE%TYPE := OKL_API.G_MISS_DATE,
109 vendor_id NUMBER := OKL_API.G_MISS_NUM,
110 vendor_site_id NUMBER := OKL_API.G_MISS_NUM,
111 invoice_amount NUMBER := OKL_API.G_MISS_NUM,
112 invoice_currency_code OKL_EXT_PAY_INVS_V.INVOICE_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR,
113 terms_id NUMBER := OKL_API.G_MISS_NUM,
114 description OKL_EXT_PAY_INVS_V.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR,
115 source OKL_EXT_PAY_INVS_V.SOURCE%TYPE := OKL_API.G_MISS_CHAR,
116 workflow_flag OKL_EXT_PAY_INVS_V.WORKFLOW_FLAG%TYPE := OKL_API.G_MISS_CHAR,
117 doc_category_code OKL_EXT_PAY_INVS_V.DOC_CATEGORY_CODE%TYPE := OKL_API.G_MISS_CHAR,
118 payment_method OKL_EXT_PAY_INVS_V.PAYMENT_METHOD%TYPE := OKL_API.G_MISS_CHAR,
119 gl_date OKL_EXT_PAY_INVS_V.GL_DATE%TYPE := OKL_API.G_MISS_DATE,
120 accts_pay_cc_id NUMBER := OKL_API.G_MISS_NUM,
121 pay_alone_flag OKL_EXT_PAY_INVS_V.PAY_ALONE_FLAG%TYPE := OKL_API.G_MISS_CHAR,
122 wait_vendor_invoice_yn OKL_EXT_PAY_INVS_V.WAIT_VENDOR_INVOICE_YN%TYPE := OKL_API.G_MISS_CHAR,
123 stream_type OKL_EXT_PAY_INVS_V.STREAM_TYPE%TYPE := OKL_API.G_MISS_CHAR,
124 payables_invoice_id NUMBER := OKL_API.G_MISS_NUM,
125 CURRENCY_CONVERSION_TYPE OKL_EXT_PAY_INVS_V.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR,
126 CURRENCY_CONVERSION_RATE NUMBER := OKL_API.G_MISS_NUM,
127 CURRENCY_CONVERSION_DATE OKL_EXT_PAY_INVS_V.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE,
128 attribute_category OKL_EXT_PAY_INVS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
129 attribute1 OKL_EXT_PAY_INVS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
130 attribute2 OKL_EXT_PAY_INVS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
131 attribute3 OKL_EXT_PAY_INVS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
132 attribute4 OKL_EXT_PAY_INVS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
133 attribute5 OKL_EXT_PAY_INVS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
134 attribute6 OKL_EXT_PAY_INVS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
135 attribute7 OKL_EXT_PAY_INVS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
136 attribute8 OKL_EXT_PAY_INVS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
137 attribute9 OKL_EXT_PAY_INVS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
138 attribute10 OKL_EXT_PAY_INVS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
139 attribute11 OKL_EXT_PAY_INVS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
140 attribute12 OKL_EXT_PAY_INVS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
141 attribute13 OKL_EXT_PAY_INVS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
142 attribute14 OKL_EXT_PAY_INVS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
143 attribute15 OKL_EXT_PAY_INVS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
144 request_id NUMBER := OKL_API.G_MISS_NUM,
145 program_application_id NUMBER := OKL_API.G_MISS_NUM,
146 program_id NUMBER := OKL_API.G_MISS_NUM,
147 program_update_date OKL_EXT_PAY_INVS_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
148 org_id NUMBER := OKL_API.G_MISS_NUM,
149 created_by NUMBER := OKL_API.G_MISS_NUM,
150 creation_date OKL_EXT_PAY_INVS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
151 last_updated_by NUMBER := OKL_API.G_MISS_NUM,
152 last_update_date OKL_EXT_PAY_INVS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
153 last_update_login NUMBER := OKL_API.G_MISS_NUM,
154 pay_group_lookup_code OKL_EXT_PAY_INVS_V.PAY_GROUP_LOOKUP_CODE%TYPE,
155 vendor_invoice_number OKL_EXT_PAY_INVS_V.VENDOR_INVOICE_NUMBER%TYPE,
156 nettable_yn OKL_EXT_PAY_INVS_V.NETTABLE_YN%TYPE,
157 -- 30-OCT-2006 ANSETHUR R12B - Legal Entity
158 legal_entity_id OKL_EXT_PAY_INVS_B.legal_entity_id%TYPE := OKL_API.G_MISS_NUM,
159 CNSLD_AP_INV_ID OKL_EXT_PAY_INVS_B.CNSLD_AP_INV_ID%TYPE := OKL_API.G_MISS_NUM
160 );
161 g_miss_xpiv_rec xpiv_rec_type;
162 TYPE xpiv_tbl_type IS TABLE OF xpiv_rec_type
163 INDEX BY BINARY_INTEGER;
164 ---------------------------------------------------------------------------
165 -- GLOBAL MESSAGE CONSTANTS
166 ---------------------------------------------------------------------------
167 G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
168 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
169 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
170 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
171 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
172 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
176 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
173 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
174 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
175 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
177 -- PostGen-Begin-0
178 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) :='OKL_UNEXPECTED_ERROR';
179 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) :='OKL_NO_PARENT_RECORD';
180 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) :='ERROR_MESSAGE';
181 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) :='ERROR_CODE';
182 G_NOT_SAME CONSTANT VARCHAR2(200) :='OKL_CANNOT_BE_SAME';
183 -- PostGen-End-0
184 ---------------------------------------------------------------------------
185 -- GLOBAL VARIABLES
186 ---------------------------------------------------------------------------
187 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_XPI_PVT';
188 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
189 -- Post-Gen Begin-0
190 G_VIEW CONSTANT VARCHAR2(30) := 'OKL_EXT_PAY_INVS_V';
191 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
192 -- Post-Gen End-0
193 ---------------------------------------------------------------------------
194 -- Procedures and Functions
195 ---------------------------------------------------------------------------
196
197 PROCEDURE qc;
198 PROCEDURE change_version;
199 PROCEDURE api_copy;
200 PROCEDURE add_language;
201 PROCEDURE insert_row(
202 p_api_version IN NUMBER,
203 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
204 x_return_status OUT NOCOPY VARCHAR2,
205 x_msg_count OUT NOCOPY NUMBER,
206 x_msg_data OUT NOCOPY VARCHAR2,
207 p_xpiv_rec IN xpiv_rec_type,
208 x_xpiv_rec OUT NOCOPY xpiv_rec_type);
209
210 PROCEDURE insert_row(
211 p_api_version IN NUMBER,
212 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
213 x_return_status OUT NOCOPY VARCHAR2,
214 x_msg_count OUT NOCOPY NUMBER,
215 x_msg_data OUT NOCOPY VARCHAR2,
216 p_xpiv_tbl IN xpiv_tbl_type,
217 x_xpiv_tbl OUT NOCOPY xpiv_tbl_type);
218
219 PROCEDURE lock_row(
220 p_api_version IN NUMBER,
221 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
222 x_return_status OUT NOCOPY VARCHAR2,
223 x_msg_count OUT NOCOPY NUMBER,
224 x_msg_data OUT NOCOPY VARCHAR2,
225 p_xpiv_rec IN xpiv_rec_type);
226
227 PROCEDURE lock_row(
228 p_api_version IN NUMBER,
229 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
230 x_return_status OUT NOCOPY VARCHAR2,
231 x_msg_count OUT NOCOPY NUMBER,
232 x_msg_data OUT NOCOPY VARCHAR2,
233 p_xpiv_tbl IN xpiv_tbl_type);
234
235 PROCEDURE update_row(
236 p_api_version IN NUMBER,
237 p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_xpiv_rec IN xpiv_rec_type,
242 x_xpiv_rec OUT NOCOPY xpiv_rec_type);
243
244 PROCEDURE update_row(
245 p_api_version IN NUMBER,
246 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
247 x_return_status OUT NOCOPY VARCHAR2,
248 x_msg_count OUT NOCOPY NUMBER,
249 x_msg_data OUT NOCOPY VARCHAR2,
250 p_xpiv_tbl IN xpiv_tbl_type,
251 x_xpiv_tbl OUT NOCOPY xpiv_tbl_type);
252
253 PROCEDURE delete_row(
254 p_api_version IN NUMBER,
255 p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_xpiv_rec IN xpiv_rec_type);
260
261 PROCEDURE delete_row(
262 p_api_version IN NUMBER,
263 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
264 x_return_status OUT NOCOPY VARCHAR2,
265 x_msg_count OUT NOCOPY NUMBER,
266 x_msg_data OUT NOCOPY VARCHAR2,
267 p_xpiv_tbl IN xpiv_tbl_type);
268
269 PROCEDURE validate_row(
270 p_api_version IN NUMBER,
271 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
272 x_return_status OUT NOCOPY VARCHAR2,
273 x_msg_count OUT NOCOPY NUMBER,
274 x_msg_data OUT NOCOPY VARCHAR2,
275 p_xpiv_rec IN xpiv_rec_type);
276
277 PROCEDURE validate_row(
278 p_api_version IN NUMBER,
279 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
280 x_return_status OUT NOCOPY VARCHAR2,
281 x_msg_count OUT NOCOPY NUMBER,
282 x_msg_data OUT NOCOPY VARCHAR2,
283 p_xpiv_tbl IN xpiv_tbl_type);
284
285 END OKL_XPI_PVT;