[Home] [Help]
PACKAGE: APPS.OKL_RXL_PVT
Source
1 PACKAGE OKL_RXL_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSRXLS.pls 120.4 2007/12/27 14:25:31 zrehman noship $ */
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL DATASTRUCTURES
6 ---------------------------------------------------------------------------
7 -- OKL_EXT_AR_LINE_SOURCES_V Record Spec
8 TYPE rxlv_rec_type IS RECORD (
9 line_extension_id NUMBER
10 ,header_extension_id NUMBER
11 ,source_id NUMBER
12 ,source_table OKL_EXT_AR_LINE_SOURCES_V.SOURCE_TABLE%TYPE
13 ,object_version_number NUMBER
14 ,kle_id NUMBER
15 ,sty_id NUMBER
16 ,asset_number OKL_EXT_AR_LINE_SOURCES_V.ASSET_NUMBER%TYPE
17 ,contract_line_number OKL_EXT_AR_LINE_SOURCES_V.CONTRACT_LINE_NUMBER%TYPE
18 ,asset_vendor_name OKL_EXT_AR_LINE_SOURCES_V.ASSET_VENDOR_NAME%TYPE
19 ,installed_site_id NUMBER
20 ,fixed_asset_location_name OKL_EXT_AR_LINE_SOURCES_V.FIXED_ASSET_LOCATION_NAME%TYPE
21 ,subsidy_name OKL_EXT_AR_LINE_SOURCES_V.SUBSIDY_NAME%TYPE
22 ,accounting_template_name OKL_EXT_AR_LINE_SOURCES_V.ACCOUNTING_TEMPLATE_NAME%TYPE
23 ,subsidy_party_name OKL_EXT_AR_LINE_SOURCES_V.SUBSIDY_PARTY_NAME%TYPE
24 ,contingency_code OKL_EXT_AR_LINE_SOURCES_V.CONTINGENCY_CODE%TYPE
25 ,fee_type_code OKL_EXT_AR_LINE_SOURCES_V.FEE_TYPE_CODE%TYPE
26 ,memo_flag OKL_EXT_AR_LINE_SOURCES_V.MEMO_FLAG%TYPE
27 ,contract_line_type OKL_EXT_AR_LINE_SOURCES_V.CONTRACT_LINE_TYPE%TYPE
28 ,line_attribute_category OKL_EXT_AR_LINE_SOURCES_V.LINE_ATTRIBUTE_CATEGORY%TYPE
29 ,line_attribute1 OKL_EXT_AR_LINE_SOURCES_V.LINE_ATTRIBUTE1%TYPE
30 ,line_attribute2 OKL_EXT_AR_LINE_SOURCES_V.LINE_ATTRIBUTE2%TYPE
31 ,line_attribute3 OKL_EXT_AR_LINE_SOURCES_V.LINE_ATTRIBUTE3%TYPE
32 ,line_attribute4 OKL_EXT_AR_LINE_SOURCES_V.LINE_ATTRIBUTE4%TYPE
33 ,line_attribute5 OKL_EXT_AR_LINE_SOURCES_V.LINE_ATTRIBUTE5%TYPE
34 ,line_attribute6 OKL_EXT_AR_LINE_SOURCES_V.LINE_ATTRIBUTE6%TYPE
35 ,line_attribute7 OKL_EXT_AR_LINE_SOURCES_V.LINE_ATTRIBUTE7%TYPE
36 ,line_attribute8 OKL_EXT_AR_LINE_SOURCES_V.LINE_ATTRIBUTE8%TYPE
37 ,line_attribute9 OKL_EXT_AR_LINE_SOURCES_V.LINE_ATTRIBUTE9%TYPE
38 ,line_attribute10 OKL_EXT_AR_LINE_SOURCES_V.LINE_ATTRIBUTE10%TYPE
39 ,line_attribute11 OKL_EXT_AR_LINE_SOURCES_V.LINE_ATTRIBUTE11%TYPE
40 ,line_attribute12 OKL_EXT_AR_LINE_SOURCES_V.LINE_ATTRIBUTE12%TYPE
41 ,line_attribute13 OKL_EXT_AR_LINE_SOURCES_V.LINE_ATTRIBUTE13%TYPE
42 ,line_attribute14 OKL_EXT_AR_LINE_SOURCES_V.LINE_ATTRIBUTE14%TYPE
43 ,line_attribute15 OKL_EXT_AR_LINE_SOURCES_V.LINE_ATTRIBUTE15%TYPE
44 ,stream_type_code OKL_EXT_AR_LINE_SOURCES_V.STREAM_TYPE_CODE%TYPE
45 ,stream_type_purpose_code OKL_EXT_AR_LINE_SOURCES_V.STREAM_TYPE_PURPOSE_CODE%TYPE
46 ,inventory_org_code OKL_EXT_AR_LINE_SOURCES_V.INVENTORY_ORG_CODE%TYPE
47 ,language OKL_EXT_AR_LINE_SOURCES_V.LANGUAGE%TYPE
48 ,inventory_org_name OKL_EXT_AR_LINE_SOURCES_V.INVENTORY_ORG_NAME%TYPE
49 ,stream_type_name OKL_EXT_AR_LINE_SOURCES_V.STREAM_TYPE_NAME%TYPE
50 ,trans_line_description OKL_EXT_AR_LINE_SOURCES_V.TRANS_LINE_DESCRIPTION%TYPE
51 ,created_by NUMBER
52 ,creation_date OKL_EXT_AR_LINE_SOURCES_V.CREATION_DATE%TYPE
53 ,last_updated_by NUMBER
54 ,last_update_date OKL_EXT_AR_LINE_SOURCES_V.LAST_UPDATE_DATE%TYPE
55 ,last_update_login NUMBER
56 --Start : PRASJAIN : Bug#6334150
57 ,asset_category_name OKL_EXT_AR_LINE_SOURCES_V.ASSET_CATEGORY_NAME%TYPE
58 ,inventory_item_name_code OKL_EXT_AR_LINE_SOURCES_V.INVENTORY_ITEM_NAME_CODE%TYPE
59 ,inventory_item_name OKL_EXT_AR_LINE_SOURCES_V.INVENTORY_ITEM_NAME%TYPE
60 ,asset_vendor_id OKL_EXT_AR_LINE_SOURCES_V.ASSET_VENDOR_ID%TYPE
61 ,subsidy_vendor_id OKL_EXT_AR_LINE_SOURCES_V.SUBSIDY_VENDOR_ID%TYPE);
62 --End : PRASJAIN : Bug#6334150
63 G_MISS_rxlv_rec rxlv_rec_type;
64 TYPE rxlv_tbl_type IS TABLE OF rxlv_rec_type
65 INDEX BY BINARY_INTEGER;
66 -- OKL_EXT_AR_LINE_SOURCES_TL Record Spec
67 TYPE rxll_rec_type IS RECORD (
68 line_extension_id NUMBER
69 ,language OKL_EXT_AR_LINE_SOURCES_TL.LANGUAGE%TYPE
70 ,source_lang OKL_EXT_AR_LINE_SOURCES_TL.SOURCE_LANG%TYPE
71 ,sfwt_flag OKL_EXT_AR_LINE_SOURCES_TL.SFWT_FLAG%TYPE
72 ,inventory_org_name OKL_EXT_AR_LINE_SOURCES_TL.INVENTORY_ORG_NAME%TYPE
73 ,stream_type_name OKL_EXT_AR_LINE_SOURCES_TL.STREAM_TYPE_NAME%TYPE
74 ,trans_line_description OKL_EXT_AR_LINE_SOURCES_TL.TRANS_LINE_DESCRIPTION%TYPE
75 ,created_by NUMBER
76 ,creation_date OKL_EXT_AR_LINE_SOURCES_TL.CREATION_DATE%TYPE
77 ,last_updated_by NUMBER
78 ,last_update_date OKL_EXT_AR_LINE_SOURCES_TL.LAST_UPDATE_DATE%TYPE
79 ,last_update_login NUMBER
80 --Start : PRASJAIN : Bug#6334150
81 ,inventory_item_name OKL_EXT_AR_LINE_SOURCES_TL.INVENTORY_ITEM_NAME%TYPE
82 ,asset_vendor_id OKL_EXT_AR_LINE_SOURCES_V.ASSET_VENDOR_ID%TYPE
83 ,subsidy_vendor_id OKL_EXT_AR_LINE_SOURCES_V.SUBSIDY_VENDOR_ID%TYPE);
84 --End : PRASJAIN : Bug#6334150
85 G_MISS_rxll_rec rxll_rec_type;
86 TYPE rxll_tbl_type IS TABLE OF rxll_rec_type
87 INDEX BY BINARY_INTEGER;
88 -- OKL_EXT_AR_LINE_SOURCES_B Record Spec
89 TYPE rxl_rec_type IS RECORD (
90 line_extension_id NUMBER
91 ,header_extension_id NUMBER
92 ,source_id NUMBER
93 ,source_table OKL_EXT_AR_LINE_SOURCES_B.SOURCE_TABLE%TYPE
94 ,object_version_number NUMBER
95 ,kle_id NUMBER
96 ,sty_id NUMBER
97 ,asset_number OKL_EXT_AR_LINE_SOURCES_B.ASSET_NUMBER%TYPE
98 ,contract_line_number OKL_EXT_AR_LINE_SOURCES_B.CONTRACT_LINE_NUMBER%TYPE
99 ,asset_vendor_name OKL_EXT_AR_LINE_SOURCES_B.ASSET_VENDOR_NAME%TYPE
100 ,installed_site_id NUMBER
101 ,fixed_asset_location_name OKL_EXT_AR_LINE_SOURCES_B.FIXED_ASSET_LOCATION_NAME%TYPE
102 ,subsidy_name OKL_EXT_AR_LINE_SOURCES_B.SUBSIDY_NAME%TYPE
103 ,accounting_template_name OKL_EXT_AR_LINE_SOURCES_B.ACCOUNTING_TEMPLATE_NAME%TYPE
104 ,subsidy_party_name OKL_EXT_AR_LINE_SOURCES_B.SUBSIDY_PARTY_NAME%TYPE
105 ,contingency_code OKL_EXT_AR_LINE_SOURCES_B.CONTINGENCY_CODE%TYPE
106 ,fee_type_code OKL_EXT_AR_LINE_SOURCES_B.FEE_TYPE_CODE%TYPE
107 ,memo_flag OKL_EXT_AR_LINE_SOURCES_B.MEMO_FLAG%TYPE
108 ,contract_line_type OKL_EXT_AR_LINE_SOURCES_B.CONTRACT_LINE_TYPE%TYPE
109 ,line_attribute_category OKL_EXT_AR_LINE_SOURCES_B.LINE_ATTRIBUTE_CATEGORY%TYPE
110 ,line_attribute1 OKL_EXT_AR_LINE_SOURCES_B.LINE_ATTRIBUTE1%TYPE
111 ,line_attribute2 OKL_EXT_AR_LINE_SOURCES_B.LINE_ATTRIBUTE2%TYPE
112 ,line_attribute3 OKL_EXT_AR_LINE_SOURCES_B.LINE_ATTRIBUTE3%TYPE
113 ,line_attribute4 OKL_EXT_AR_LINE_SOURCES_B.LINE_ATTRIBUTE4%TYPE
114 ,line_attribute5 OKL_EXT_AR_LINE_SOURCES_B.LINE_ATTRIBUTE5%TYPE
118 ,line_attribute9 OKL_EXT_AR_LINE_SOURCES_B.LINE_ATTRIBUTE9%TYPE
115 ,line_attribute6 OKL_EXT_AR_LINE_SOURCES_B.LINE_ATTRIBUTE6%TYPE
116 ,line_attribute7 OKL_EXT_AR_LINE_SOURCES_B.LINE_ATTRIBUTE7%TYPE
117 ,line_attribute8 OKL_EXT_AR_LINE_SOURCES_B.LINE_ATTRIBUTE8%TYPE
119 ,line_attribute10 OKL_EXT_AR_LINE_SOURCES_B.LINE_ATTRIBUTE10%TYPE
120 ,line_attribute11 OKL_EXT_AR_LINE_SOURCES_B.LINE_ATTRIBUTE11%TYPE
121 ,line_attribute12 OKL_EXT_AR_LINE_SOURCES_B.LINE_ATTRIBUTE12%TYPE
122 ,line_attribute13 OKL_EXT_AR_LINE_SOURCES_B.LINE_ATTRIBUTE13%TYPE
123 ,line_attribute14 OKL_EXT_AR_LINE_SOURCES_B.LINE_ATTRIBUTE14%TYPE
124 ,line_attribute15 OKL_EXT_AR_LINE_SOURCES_B.LINE_ATTRIBUTE15%TYPE
125 ,stream_type_code OKL_EXT_AR_LINE_SOURCES_B.STREAM_TYPE_CODE%TYPE
126 ,stream_type_purpose_code OKL_EXT_AR_LINE_SOURCES_B.STREAM_TYPE_PURPOSE_CODE%TYPE
127 ,inventory_org_code OKL_EXT_AR_LINE_SOURCES_B.INVENTORY_ORG_CODE%TYPE
128 ,created_by NUMBER
129 ,creation_date OKL_EXT_AR_LINE_SOURCES_B.CREATION_DATE%TYPE
130 ,last_updated_by NUMBER
131 ,last_update_date OKL_EXT_AR_LINE_SOURCES_B.LAST_UPDATE_DATE%TYPE
132 ,last_update_login NUMBER
133 --Start : PRASJAIN : Bug#6334150
134 ,asset_category_name OKL_EXT_AR_LINE_SOURCES_V.ASSET_CATEGORY_NAME%TYPE
135 ,inventory_item_name_code OKL_EXT_AR_LINE_SOURCES_V.INVENTORY_ITEM_NAME_CODE%TYPE
136 --End : PRASJAIN : Bug#6334150
137 -- added by zrehman Bug#6707320 for Party Merge impact on Accounting sources tables start
138 ,asset_vendor_id OKL_EXT_AR_LINE_SOURCES_B.ASSET_VENDOR_ID%TYPE
139 ,subsidy_vendor_id OKL_EXT_AR_LINE_SOURCES_B.SUBSIDY_VENDOR_ID%TYPE);
140 -- added by zrehman Bug#6707320 for Party Merge impact on Accounting sources tables end
141
142 G_MISS_rxl_rec rxl_rec_type;
143 TYPE rxl_tbl_type IS TABLE OF rxl_rec_type
144 INDEX BY BINARY_INTEGER;
145 ---------------------------------------------------------------------------
146 -- GLOBAL MESSAGE CONSTANTS
147 ---------------------------------------------------------------------------
148 G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
149 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
150 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
151 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
152 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
153 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
154 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
155 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
156 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
157 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
158 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
159 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
160 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
161
162 ---------------------------------------------------------------------------
163 -- GLOBAL EXCEPTIONS
164 ---------------------------------------------------------------------------
165 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
166
167 ---------------------------------------------------------------------------
168 -- GLOBAL VARIABLES
169 ---------------------------------------------------------------------------
170 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_RXL_PVT';
171 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
172 ---------------------------------------------------------------------------
173 -- Procedures and Functions
174 ---------------------------------------------------------------------------
175
176 PROCEDURE qc;
177 PROCEDURE change_version;
178 PROCEDURE api_copy;
179 PROCEDURE add_language;
180 PROCEDURE insert_row(
181 p_api_version IN NUMBER,
182 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
183 x_return_status OUT NOCOPY VARCHAR2,
184 x_msg_count OUT NOCOPY NUMBER,
185 x_msg_data OUT NOCOPY VARCHAR2,
186 p_rxlv_rec IN rxlv_rec_type,
187 x_rxlv_rec OUT NOCOPY rxlv_rec_type);
188 PROCEDURE insert_row(
189 p_api_version IN NUMBER,
190 p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_rxlv_tbl IN rxlv_tbl_type,
195 x_rxlv_tbl OUT NOCOPY rxlv_tbl_type,
196 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
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_rxlv_tbl IN rxlv_tbl_type,
204 x_rxlv_tbl OUT NOCOPY rxlv_tbl_type);
205 PROCEDURE lock_row(
206 p_api_version IN NUMBER,
207 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
208 x_return_status OUT NOCOPY VARCHAR2,
209 x_msg_count OUT NOCOPY NUMBER,
210 x_msg_data OUT NOCOPY VARCHAR2,
211 p_rxlv_rec IN rxlv_rec_type);
212 PROCEDURE lock_row(
213 p_api_version IN NUMBER,
214 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
215 x_return_status OUT NOCOPY VARCHAR2,
216 x_msg_count OUT NOCOPY NUMBER,
217 x_msg_data OUT NOCOPY VARCHAR2,
218 p_rxlv_tbl IN rxlv_tbl_type,
219 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
220 PROCEDURE lock_row(
221 p_api_version IN NUMBER,
222 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
223 x_return_status OUT NOCOPY VARCHAR2,
224 x_msg_count OUT NOCOPY NUMBER,
225 x_msg_data OUT NOCOPY VARCHAR2,
226 p_rxlv_tbl IN rxlv_tbl_type);
227 PROCEDURE update_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_rxlv_rec IN rxlv_rec_type,
234 x_rxlv_rec OUT NOCOPY rxlv_rec_type);
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_rxlv_tbl IN rxlv_tbl_type,
242 x_rxlv_tbl OUT NOCOPY rxlv_tbl_type,
243 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
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_rxlv_tbl IN rxlv_tbl_type,
251 x_rxlv_tbl OUT NOCOPY rxlv_tbl_type);
252 PROCEDURE delete_row(
253 p_api_version IN NUMBER,
254 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
255 x_return_status OUT NOCOPY VARCHAR2,
256 x_msg_count OUT NOCOPY NUMBER,
257 x_msg_data OUT NOCOPY VARCHAR2,
258 p_rxlv_rec IN rxlv_rec_type);
259 PROCEDURE delete_row(
260 p_api_version IN NUMBER,
261 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
262 x_return_status OUT NOCOPY VARCHAR2,
263 x_msg_count OUT NOCOPY NUMBER,
264 x_msg_data OUT NOCOPY VARCHAR2,
265 p_rxlv_tbl IN rxlv_tbl_type,
266 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
267 PROCEDURE delete_row(
268 p_api_version IN NUMBER,
269 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
270 x_return_status OUT NOCOPY VARCHAR2,
271 x_msg_count OUT NOCOPY NUMBER,
272 x_msg_data OUT NOCOPY VARCHAR2,
273 p_rxlv_tbl IN rxlv_tbl_type);
274 PROCEDURE validate_row(
275 p_api_version IN NUMBER,
276 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
277 x_return_status OUT NOCOPY VARCHAR2,
278 x_msg_count OUT NOCOPY NUMBER,
279 x_msg_data OUT NOCOPY VARCHAR2,
280 p_rxlv_rec IN rxlv_rec_type);
281 PROCEDURE validate_row(
282 p_api_version IN NUMBER,
283 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
284 x_return_status OUT NOCOPY VARCHAR2,
285 x_msg_count OUT NOCOPY NUMBER,
286 x_msg_data OUT NOCOPY VARCHAR2,
287 p_rxlv_tbl IN rxlv_tbl_type,
288 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
289 PROCEDURE validate_row(
290 p_api_version IN NUMBER,
291 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
292 x_return_status OUT NOCOPY VARCHAR2,
293 x_msg_count OUT NOCOPY NUMBER,
294 x_msg_data OUT NOCOPY VARCHAR2,
295 p_rxlv_tbl IN rxlv_tbl_type);
296 -- Added for Bug# 6268782 : PRASJAIN
297 PROCEDURE insert_row(
298 p_api_version IN NUMBER,
299 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
300 x_return_status OUT NOCOPY VARCHAR2,
301 x_msg_count OUT NOCOPY NUMBER,
302 x_msg_data OUT NOCOPY VARCHAR2,
303 p_rxl_rec IN rxl_rec_type,
304 p_rxll_tbl IN rxll_tbl_type,
305 x_rxl_rec OUT NOCOPY rxl_rec_type,
306 x_rxll_tbl OUT NOCOPY rxll_tbl_type);
307 END OKL_RXL_PVT;