[Home] [Help]
PACKAGE: APPS.OKL_XSI_PVT
Source
1 PACKAGE Okl_Xsi_Pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLSXSIS.pls 120.3 2006/11/17 10:22:08 zrehman noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE xsi_rec_type IS RECORD (
7 id NUMBER := Okl_Api.G_MISS_NUM,
8 isi_id NUMBER := Okl_Api.G_MISS_NUM,
9 object_version_number NUMBER := Okl_Api.G_MISS_NUM,
10 receivables_invoice_id NUMBER := Okl_Api.G_MISS_NUM,
11 set_of_books_id NUMBER := Okl_Api.G_MISS_NUM,
12 trx_date OKL_EXT_SELL_INVS_B.TRX_DATE%TYPE := Okl_Api.G_MISS_DATE,
13 currency_code OKL_EXT_SELL_INVS_B.CURRENCY_CODE%TYPE := Okl_Api.G_MISS_CHAR,
14 currency_conversion_type OKL_EXT_SELL_INVS_B.currency_conversion_type%TYPE := Okl_Api.G_MISS_CHAR,
15 currency_conversion_rate OKL_EXT_SELL_INVS_B.currency_conversion_rate%TYPE := Okl_Api.G_MISS_NUM,
16 currency_conversion_date OKL_EXT_SELL_INVS_B.currency_conversion_date%TYPE := Okl_Api.G_MISS_DATE,
17 customer_id NUMBER := Okl_Api.G_MISS_NUM,
18 receipt_method_id NUMBER := Okl_Api.G_MISS_NUM,
19 term_id NUMBER := Okl_Api.G_MISS_NUM,
20 customer_address_id NUMBER := Okl_Api.G_MISS_NUM,
21 cust_trx_type_id NUMBER := Okl_Api.G_MISS_NUM,
22 request_id NUMBER := Okl_Api.G_MISS_NUM,
23 program_application_id NUMBER := Okl_Api.G_MISS_NUM,
24 program_id NUMBER := Okl_Api.G_MISS_NUM,
25 program_update_date OKL_EXT_SELL_INVS_B.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
26 org_id NUMBER := Okl_Api.G_MISS_NUM,
27 REFERENCE_LINE_ID NUMBER := Okl_Api.G_MISS_NUM,
28 CUSTOMER_BANK_ACCOUNT_ID NUMBER := Okl_Api.G_MISS_NUM,
29 TRX_NUMBER OKL_EXT_SELL_INVS_B.TRX_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
30 inf_id NUMBER := Okl_Api.G_MISS_NUM,
31 /* khr_id NUMBER := Okl_Api.G_MISS_NUM, */
32 /* clg_id NUMBER := Okl_Api.G_MISS_NUM, */
33 /* cpy_id NUMBER := Okl_Api.G_MISS_NUM, */
34 /* qte_id NUMBER := Okl_Api.G_MISS_NUM, */
35 attribute_category OKL_EXT_SELL_INVS_B.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
36 attribute1 OKL_EXT_SELL_INVS_B.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
37 attribute2 OKL_EXT_SELL_INVS_B.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
41 attribute6 OKL_EXT_SELL_INVS_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
38 attribute3 OKL_EXT_SELL_INVS_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
39 attribute4 OKL_EXT_SELL_INVS_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
40 attribute5 OKL_EXT_SELL_INVS_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
42 attribute7 OKL_EXT_SELL_INVS_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
43 attribute8 OKL_EXT_SELL_INVS_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
44 attribute9 OKL_EXT_SELL_INVS_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
45 attribute10 OKL_EXT_SELL_INVS_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
46 attribute11 OKL_EXT_SELL_INVS_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
47 attribute12 OKL_EXT_SELL_INVS_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
48 attribute13 OKL_EXT_SELL_INVS_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
49 attribute14 OKL_EXT_SELL_INVS_B.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
50 attribute15 OKL_EXT_SELL_INVS_B.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
51 created_by NUMBER := Okl_Api.G_MISS_NUM,
52 creation_date OKL_EXT_SELL_INVS_B.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
53 last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
54 last_update_date OKL_EXT_SELL_INVS_B.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
55 last_update_login NUMBER := Okl_Api.G_MISS_NUM,
56 trx_status_code OKL_EXT_SELL_INVS_B.TRX_STATUS_CODE%TYPE := Okl_Api.G_MISS_CHAR,
57 tax_exempt_flag OKL_EXT_SELL_INVS_B.TAX_EXEMPT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
58 tax_exempt_reason_code OKL_EXT_SELL_INVS_B.TAX_EXEMPT_REASON_CODE%TYPE:= Okl_Api.G_MISS_CHAR,
59 xtrx_invoice_pull_yn OKL_EXT_SELL_INVS_B.XTRX_INVOICE_PULL_YN%TYPE := Okl_Api.G_MISS_CHAR,
60 legal_entity_id OKL_EXT_SELL_INVS_B.LEGAL_ENTITY_ID%TYPE := Okl_Api.G_MISS_NUM -- for LE Uptake project 08-11-2006
61 );
62 g_miss_xsi_rec xsi_rec_type;
63 TYPE xsi_tbl_type IS TABLE OF xsi_rec_type
64 INDEX BY BINARY_INTEGER;
65 TYPE okl_ext_sell_invs_tl_rec_type IS RECORD (
66 id NUMBER := Okl_Api.G_MISS_NUM,
67 LANGUAGE OKL_EXT_SELL_INVS_TL.LANGUAGE%TYPE := Okl_Api.G_MISS_CHAR,
68 source_lang OKL_EXT_SELL_INVS_TL.SOURCE_LANG%TYPE := Okl_Api.G_MISS_CHAR,
69 sfwt_flag OKL_EXT_SELL_INVS_TL.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
70 xtrx_cons_invoice_number OKL_EXT_SELL_INVS_TL.XTRX_CONS_INVOICE_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
71 xtrx_format_type OKL_EXT_SELL_INVS_TL.XTRX_FORMAT_TYPE%TYPE := Okl_Api.G_MISS_CHAR,
72 xtrx_private_label OKL_EXT_SELL_INVS_TL.XTRX_PRIVATE_LABEL%TYPE := Okl_Api.G_MISS_CHAR,
73 invoice_message OKL_EXT_SELL_INVS_TL.INVOICE_MESSAGE%TYPE := Okl_Api.G_MISS_CHAR,
74 description OKL_EXT_SELL_INVS_TL.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
75 created_by NUMBER := Okl_Api.G_MISS_NUM,
76 creation_date OKL_EXT_SELL_INVS_TL.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
77 last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
78 last_update_date OKL_EXT_SELL_INVS_TL.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
79 last_update_login NUMBER := Okl_Api.G_MISS_NUM);
80 GMissOklExtSellInvsTlRec okl_ext_sell_invs_tl_rec_type;
81 TYPE okl_ext_sell_invs_tl_tbl_type IS TABLE OF okl_ext_sell_invs_tl_rec_type
82 INDEX BY BINARY_INTEGER;
83 TYPE xsiv_rec_type IS RECORD (
84 id NUMBER := Okl_Api.G_MISS_NUM,
85 object_version_number NUMBER := Okl_Api.G_MISS_NUM,
86 sfwt_flag OKL_EXT_SELL_INVS_V.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
87 isi_id NUMBER := Okl_Api.G_MISS_NUM,
88 trx_date OKL_EXT_SELL_INVS_V.TRX_DATE%TYPE := Okl_Api.G_MISS_DATE,
89 customer_id NUMBER := Okl_Api.G_MISS_NUM,
90 receipt_method_id NUMBER := Okl_Api.G_MISS_NUM,
91 term_id NUMBER := Okl_Api.G_MISS_NUM,
92 currency_code OKL_EXT_SELL_INVS_V.CURRENCY_CODE%TYPE := Okl_Api.G_MISS_CHAR,
93 currency_conversion_type OKL_EXT_SELL_INVS_V.currency_conversion_type%TYPE := Okl_Api.G_MISS_CHAR,
94 currency_conversion_rate OKL_EXT_SELL_INVS_V.currency_conversion_rate%TYPE := Okl_Api.G_MISS_NUM,
95 currency_conversion_date OKL_EXT_SELL_INVS_V.currency_conversion_date%TYPE := Okl_Api.G_MISS_DATE,
96 customer_address_id NUMBER := Okl_Api.G_MISS_NUM,
97 set_of_books_id NUMBER := Okl_Api.G_MISS_NUM,
98 receivables_invoice_id NUMBER := Okl_Api.G_MISS_NUM,
99 cust_trx_type_id NUMBER := Okl_Api.G_MISS_NUM,
100 invoice_message OKL_EXT_SELL_INVS_V.INVOICE_MESSAGE%TYPE := Okl_Api.G_MISS_CHAR,
101 description OKL_EXT_SELL_INVS_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
102 xtrx_cons_invoice_number OKL_EXT_SELL_INVS_V.XTRX_CONS_INVOICE_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
103 xtrx_format_type OKL_EXT_SELL_INVS_V.XTRX_FORMAT_TYPE%TYPE := Okl_Api.G_MISS_CHAR,
104 xtrx_private_label OKL_EXT_SELL_INVS_V.XTRX_PRIVATE_LABEL%TYPE := Okl_Api.G_MISS_CHAR,
105 REFERENCE_LINE_ID NUMBER := Okl_Api.G_MISS_NUM,
106 CUSTOMER_BANK_ACCOUNT_ID NUMBER := Okl_Api.G_MISS_NUM,
107 TRX_NUMBER OKL_EXT_SELL_INVS_V.TRX_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
108 inf_id NUMBER := Okl_Api.G_MISS_NUM,
109 /* khr_id NUMBER := Okl_Api.G_MISS_NUM, */
110 /* clg_id NUMBER := Okl_Api.G_MISS_NUM, */
114 attribute1 OKL_EXT_SELL_INVS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
111 /* cpy_id NUMBER := Okl_Api.G_MISS_NUM, */
112 /* qte_id NUMBER := Okl_Api.G_MISS_NUM, */
113 attribute_category OKL_EXT_SELL_INVS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
115 attribute2 OKL_EXT_SELL_INVS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
116 attribute3 OKL_EXT_SELL_INVS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
117 attribute4 OKL_EXT_SELL_INVS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
118 attribute5 OKL_EXT_SELL_INVS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
119 attribute6 OKL_EXT_SELL_INVS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
120 attribute7 OKL_EXT_SELL_INVS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
121 attribute8 OKL_EXT_SELL_INVS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
122 attribute9 OKL_EXT_SELL_INVS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
123 attribute10 OKL_EXT_SELL_INVS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
124 attribute11 OKL_EXT_SELL_INVS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
125 attribute12 OKL_EXT_SELL_INVS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
126 attribute13 OKL_EXT_SELL_INVS_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
127 attribute14 OKL_EXT_SELL_INVS_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
128 attribute15 OKL_EXT_SELL_INVS_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
129 request_id NUMBER := Okl_Api.G_MISS_NUM,
130 program_application_id NUMBER := Okl_Api.G_MISS_NUM,
131 program_id NUMBER := Okl_Api.G_MISS_NUM,
132 program_update_date OKL_EXT_SELL_INVS_V.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
133 org_id NUMBER := Okl_Api.G_MISS_NUM,
134 created_by NUMBER := Okl_Api.G_MISS_NUM,
135 creation_date OKL_EXT_SELL_INVS_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
136 last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
137 last_update_date OKL_EXT_SELL_INVS_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
138 last_update_login NUMBER := Okl_Api.G_MISS_NUM,
139 trx_status_code OKL_EXT_SELL_INVS_B.TRX_STATUS_CODE%TYPE := Okl_Api.G_MISS_CHAR,
140 tax_exempt_flag OKL_EXT_SELL_INVS_B.TAX_EXEMPT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
141 tax_exempt_reason_code OKL_EXT_SELL_INVS_B.TAX_EXEMPT_REASON_CODE%TYPE:= Okl_Api.G_MISS_CHAR,
142 xtrx_invoice_pull_yn OKL_EXT_SELL_INVS_B.XTRX_INVOICE_PULL_YN%TYPE := Okl_Api.G_MISS_CHAR,
143 legal_entity_id OKL_EXT_SELL_INVS_B.LEGAL_ENTITY_ID%TYPE := Okl_Api.G_MISS_NUM -- for LE Uptake project 08-11-2006
144 );
145
146 g_miss_xsiv_rec xsiv_rec_type;
147 TYPE xsiv_tbl_type IS TABLE OF xsiv_rec_type
148 INDEX BY BINARY_INTEGER;
149 ---------------------------------------------------------------------------
150 -- GLOBAL MESSAGE CONSTANTS
151 ---------------------------------------------------------------------------
152 G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
153 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
154 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
155 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
156 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
157 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
158 G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
159 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
160 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
161 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
162 ---------------------------------------------------------------------------
163 -- GLOBAL VARIABLES
164 ---------------------------------------------------------------------------
165 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_XSI_PVT';
166 G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
167
168 /******************ADDED AFTER TAPI, Sunil T. Mathew (04/16/2001) ****************/
169 --GLOBAL MESSAGES
170 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
171 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
172 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
173 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
174 G_NOT_SAME CONSTANT VARCHAR2(200) := 'OKL_CANNOT_BE_SAME';
175
176
177 --GLOBAL VARIABLES
178 G_VIEW CONSTANT VARCHAR2(30) := 'OKL_EXT_SELL_INVS_V';
179 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
180
181 ---------------------------------------------------------------------------
182 -- validation Procedures and Functions
183 ---------------------------------------------------------------------------
184 --PROCEDURE validate_unique(p_saiv_rec IN saiv_rec_type,
185 -- x_return_status OUT NOCOPY VARCHAR2);
186
187 /****************END ADDED AFTER TAPI, Sunil T. Mathew (04/16/2001)**************/
188
189 ---------------------------------------------------------------------------
190 -- Procedures and Functions
191 ---------------------------------------------------------------------------
192
193 PROCEDURE qc;
194 PROCEDURE change_version;
195 PROCEDURE api_copy;
196 PROCEDURE add_language;
197 PROCEDURE insert_row(
198 p_api_version IN NUMBER,
199 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
200 x_return_status OUT NOCOPY VARCHAR2,
201 x_msg_count OUT NOCOPY NUMBER,
202 x_msg_data OUT NOCOPY VARCHAR2,
203 p_xsiv_rec IN xsiv_rec_type,
204 x_xsiv_rec OUT NOCOPY xsiv_rec_type);
205
206 PROCEDURE insert_row(
207 p_api_version IN NUMBER,
208 p_init_msg_list IN VARCHAR2 DEFAULT Okl_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_xsiv_tbl IN xsiv_tbl_type,
213 x_xsiv_tbl OUT NOCOPY xsiv_tbl_type);
214
215 PROCEDURE lock_row(
216 p_api_version IN NUMBER,
217 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
218 x_return_status OUT NOCOPY VARCHAR2,
219 x_msg_count OUT NOCOPY NUMBER,
220 x_msg_data OUT NOCOPY VARCHAR2,
221 p_xsiv_rec IN xsiv_rec_type);
222
223 PROCEDURE lock_row(
224 p_api_version IN NUMBER,
225 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
226 x_return_status OUT NOCOPY VARCHAR2,
227 x_msg_count OUT NOCOPY NUMBER,
228 x_msg_data OUT NOCOPY VARCHAR2,
229 p_xsiv_tbl IN xsiv_tbl_type);
230
231 PROCEDURE update_row(
232 p_api_version IN NUMBER,
233 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
234 x_return_status OUT NOCOPY VARCHAR2,
235 x_msg_count OUT NOCOPY NUMBER,
236 x_msg_data OUT NOCOPY VARCHAR2,
237 p_xsiv_rec IN xsiv_rec_type,
238 x_xsiv_rec OUT NOCOPY xsiv_rec_type);
239
240 PROCEDURE update_row(
241 p_api_version IN NUMBER,
242 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
243 x_return_status OUT NOCOPY VARCHAR2,
244 x_msg_count OUT NOCOPY NUMBER,
245 x_msg_data OUT NOCOPY VARCHAR2,
246 p_xsiv_tbl IN xsiv_tbl_type,
247 x_xsiv_tbl OUT NOCOPY xsiv_tbl_type);
248
249 PROCEDURE delete_row(
250 p_api_version IN NUMBER,
251 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
252 x_return_status OUT NOCOPY VARCHAR2,
253 x_msg_count OUT NOCOPY NUMBER,
254 x_msg_data OUT NOCOPY VARCHAR2,
255 p_xsiv_rec IN xsiv_rec_type);
256
257 PROCEDURE delete_row(
258 p_api_version IN NUMBER,
259 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
260 x_return_status OUT NOCOPY VARCHAR2,
261 x_msg_count OUT NOCOPY NUMBER,
262 x_msg_data OUT NOCOPY VARCHAR2,
263 p_xsiv_tbl IN xsiv_tbl_type);
264
265 PROCEDURE validate_row(
266 p_api_version IN NUMBER,
267 p_init_msg_list IN VARCHAR2 DEFAULT Okl_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_xsiv_rec IN xsiv_rec_type);
272
273 PROCEDURE validate_row(
274 p_api_version IN NUMBER,
275 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
276 x_return_status OUT NOCOPY VARCHAR2,
277 x_msg_count OUT NOCOPY NUMBER,
278 x_msg_data OUT NOCOPY VARCHAR2,
279 p_xsiv_tbl IN xsiv_tbl_type);
280
281 END Okl_Xsi_Pvt;