[Home] [Help]
PACKAGE: APPS.OKL_TAL_PVT
Source
1 Package OKL_TAL_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSTALS.pls 120.4 2006/02/13 20:45:41 rpillay noship $ */
3 -- Badrinath Kuchibholta
4 ---------------------------------------------------------------------------
5 -- GLOBAL DATASTRUCTURES
6 ---------------------------------------------------------------------------
7 TYPE tal_rec_type IS RECORD (
8 id NUMBER := OKC_API.G_MISS_NUM,
9 object_version_number NUMBER := OKC_API.G_MISS_NUM,
10 tas_id NUMBER := OKC_API.G_MISS_NUM,
11 ilo_id NUMBER := OKC_API.G_MISS_NUM,
12 ilo_id_old NUMBER := OKC_API.G_MISS_NUM,
13 iay_id NUMBER := OKC_API.G_MISS_NUM,
14 iay_id_new NUMBER := OKC_API.G_MISS_NUM,
15 kle_id NUMBER := OKC_API.G_MISS_NUM,
16 dnz_khr_id NUMBER := OKC_API.G_MISS_NUM,
17 line_number NUMBER := OKC_API.G_MISS_NUM,
18 org_id NUMBER := OKC_API.G_MISS_NUM,
19 tal_type OKL_TXL_ASSETS_B.TAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
20 asset_number OKL_TXL_ASSETS_B.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
21 fa_location_id NUMBER := OKC_API.G_MISS_NUM,
22 original_cost NUMBER := OKC_API.G_MISS_NUM,
23 current_units NUMBER := OKC_API.G_MISS_NUM,
24 manufacturer_name OKL_TXL_ASSETS_B.MANUFACTURER_NAME%TYPE := OKC_API.G_MISS_CHAR,
25 year_manufactured NUMBER := OKC_API.G_MISS_NUM,
26 supplier_id NUMBER := OKC_API.G_MISS_NUM,
27 used_asset_yn OKL_TXL_ASSETS_B.USED_ASSET_YN%TYPE := OKC_API.G_MISS_CHAR,
28 tag_number OKL_TXL_ASSETS_B.TAG_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
29 model_number OKL_TXL_ASSETS_B.MODEL_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
30 corporate_book OKL_TXL_ASSETS_B.CORPORATE_BOOK%TYPE := OKC_API.G_MISS_CHAR,
31 date_purchased OKL_TXL_ASSETS_B.DATE_PURCHASED%TYPE := OKC_API.G_MISS_DATE,
32 date_delivery OKL_TXL_ASSETS_B.DATE_DELIVERY%TYPE := OKC_API.G_MISS_DATE,
33 in_service_date OKL_TXL_ASSETS_B.IN_SERVICE_DATE%TYPE := OKC_API.G_MISS_DATE,
34 life_in_months NUMBER := OKC_API.G_MISS_NUM,
35 depreciation_id NUMBER := OKC_API.G_MISS_NUM,
36 depreciation_cost NUMBER := OKC_API.G_MISS_NUM,
37 deprn_method OKL_TXL_ASSETS_B.DEPRN_METHOD%TYPE := OKC_API.G_MISS_CHAR,
38 deprn_rate NUMBER := OKC_API.G_MISS_NUM,
39 salvage_value NUMBER := OKC_API.G_MISS_NUM,
40 percent_salvage_value NUMBER := OKC_API.G_MISS_NUM,
41 --Bug# 2981308
42 asset_key_id NUMBER := OKL_API.G_MISS_NUM,
43 -- Bug 4028371
44 fa_trx_date OKL_TXL_ASSETS_B.FA_TRX_DATE%TYPE := OKC_API.G_MISS_DATE,
45 --Bug# 4899328
46 fa_cost NUMBER := OKL_API.G_MISS_NUM,
47 attribute_category OKL_TXL_ASSETS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
48 attribute1 OKL_TXL_ASSETS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
49 attribute2 OKL_TXL_ASSETS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
50 attribute3 OKL_TXL_ASSETS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
51 attribute4 OKL_TXL_ASSETS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
52 attribute5 OKL_TXL_ASSETS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
53 attribute6 OKL_TXL_ASSETS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
54 attribute7 OKL_TXL_ASSETS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
55 attribute8 OKL_TXL_ASSETS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
56 attribute9 OKL_TXL_ASSETS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
57 attribute10 OKL_TXL_ASSETS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
58 attribute11 OKL_TXL_ASSETS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
59 attribute12 OKL_TXL_ASSETS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
60 attribute13 OKL_TXL_ASSETS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
61 attribute14 OKL_TXL_ASSETS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
62 attribute15 OKL_TXL_ASSETS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
63 created_by NUMBER := OKC_API.G_MISS_NUM,
64 creation_date OKL_TXL_ASSETS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
65 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
66 last_update_date OKL_TXL_ASSETS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
67 last_update_login NUMBER := OKC_API.G_MISS_NUM,
68 depreciate_yn OKL_TXL_ASSETS_B.DEPRECIATE_YN%TYPE := OKC_API.G_MISS_CHAR,
69 hold_period_days NUMBER := OKC_API.G_MISS_NUM,
70 old_salvage_value NUMBER := OKC_API.G_MISS_NUM,
71 new_residual_value NUMBER := OKC_API.G_MISS_NUM,
72 old_residual_value NUMBER := OKC_API.G_MISS_NUM,
73 units_retired NUMBER := OKC_API.G_MISS_NUM,
74 cost_retired NUMBER := OKC_API.G_MISS_NUM,
75 sale_proceeds NUMBER := OKC_API.G_MISS_NUM,
76 removal_cost NUMBER := OKC_API.G_MISS_NUM,
77 dnz_asset_id NUMBER := OKC_API.G_MISS_NUM,
78 date_due OKL_TXL_ASSETS_B.DATE_DUE%TYPE := OKC_API.G_MISS_DATE,
79 rep_asset_id NUMBER := OKC_API.G_MISS_NUM,
80 lke_asset_id NUMBER := OKC_API.G_MISS_NUM,
81 match_amount NUMBER := OKC_API.G_MISS_NUM,
82 split_into_singles_flag OKL_TXL_ASSETS_B.SPLIT_INTO_SINGLES_FLAG%TYPE := OKC_API.G_MISS_CHAR,
83 split_into_units NUMBER := OKC_API.G_MISS_NUM,
84 -- Multi-Currency Change
85 currency_code OKL_TXL_ASSETS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
86 currency_conversion_type OKL_TXL_ASSETS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
87 currency_conversion_rate NUMBER := OKC_API.G_MISS_NUM,
88 currency_conversion_date OKL_TXL_ASSETS_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
89 -- Multi-Currency Change
90 -- VRS Project - START
91 RESIDUAL_SHR_PARTY_ID NUMBER := OKC_API.G_MISS_NUM,
92 RESIDUAL_SHR_AMOUNT NUMBER := OKC_API.G_MISS_NUM,
93 RETIREMENT_ID NUMBER := OKC_API.G_MISS_NUM
94 -- VRS Project - END
95 );
96 g_miss_tal_rec tal_rec_type;
97 TYPE tal_tbl_type IS TABLE OF tal_rec_type
98 INDEX BY BINARY_INTEGER;
99 TYPE okl_txl_assets_tl_rec_type IS RECORD (
100 id NUMBER := OKC_API.G_MISS_NUM,
101 language OKL_TXL_ASSETS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
102 source_lang OKL_TXL_ASSETS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
103 sfwt_flag OKL_TXL_ASSETS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
104 description OKL_TXL_ASSETS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
105 created_by NUMBER := OKC_API.G_MISS_NUM,
106 creation_date OKL_TXL_ASSETS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
107 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
108 last_update_date OKL_TXL_ASSETS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
109 last_update_login NUMBER := OKC_API.G_MISS_NUM);
110 g_miss_okl_txl_assets_tl_rec okl_txl_assets_tl_rec_type;
111 TYPE okl_txl_assets_tl_tbl_type IS TABLE OF okl_txl_assets_tl_rec_type
112 INDEX BY BINARY_INTEGER;
113 TYPE talv_rec_type IS RECORD (
114 id NUMBER := OKC_API.G_MISS_NUM,
115 object_version_number NUMBER := OKC_API.G_MISS_NUM,
116 sfwt_flag OKL_TXL_ASSETS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
117 tas_id NUMBER := OKC_API.G_MISS_NUM,
118 ilo_id NUMBER := OKC_API.G_MISS_NUM,
119 ilo_id_old NUMBER := OKC_API.G_MISS_NUM,
120 iay_id NUMBER := OKC_API.G_MISS_NUM,
121 iay_id_new NUMBER := OKC_API.G_MISS_NUM,
122 kle_id NUMBER := OKC_API.G_MISS_NUM,
123 dnz_khr_id NUMBER := OKC_API.G_MISS_NUM,
124 line_number NUMBER := OKC_API.G_MISS_NUM,
125 org_id NUMBER := OKC_API.G_MISS_NUM,
126 tal_type OKL_TXL_ASSETS_V.TAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
127 asset_number OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
128 description OKL_TXL_ASSETS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
129 fa_location_id NUMBER := OKC_API.G_MISS_NUM,
130 original_cost NUMBER := OKC_API.G_MISS_NUM,
131 current_units NUMBER := OKC_API.G_MISS_NUM,
132 manufacturer_name OKL_TXL_ASSETS_B.MANUFACTURER_NAME%TYPE := OKC_API.G_MISS_CHAR,
133 year_manufactured NUMBER := OKC_API.G_MISS_NUM,
134 supplier_id NUMBER := OKC_API.G_MISS_NUM,
135 used_asset_yn OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE := OKC_API.G_MISS_CHAR,
136 tag_number OKL_TXL_ASSETS_V.TAG_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
137 model_number OKL_TXL_ASSETS_V.MODEL_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
138 corporate_book OKL_TXL_ASSETS_V.CORPORATE_BOOK%TYPE := OKC_API.G_MISS_CHAR,
139 date_purchased OKL_TXL_ASSETS_V.DATE_PURCHASED%TYPE := OKC_API.G_MISS_DATE,
140 date_delivery OKL_TXL_ASSETS_V.DATE_DELIVERY%TYPE := OKC_API.G_MISS_DATE,
141 in_service_date OKL_TXL_ASSETS_V.IN_SERVICE_DATE%TYPE := OKC_API.G_MISS_DATE,
142 life_in_months NUMBER := OKC_API.G_MISS_NUM,
143 depreciation_id NUMBER := OKC_API.G_MISS_NUM,
144 depreciation_cost NUMBER := OKC_API.G_MISS_NUM,
145 deprn_method OKL_TXL_ASSETS_V.DEPRN_METHOD%TYPE := OKC_API.G_MISS_CHAR,
146 deprn_rate NUMBER := OKC_API.G_MISS_NUM,
147 salvage_value NUMBER := OKC_API.G_MISS_NUM,
148 percent_salvage_value NUMBER := OKC_API.G_MISS_NUM,
149 --Bug# 2981308
150 asset_key_id NUMBER := OKL_API.G_MISS_NUM,
151 -- Bug 4028371
152 fa_trx_date OKL_TXL_ASSETS_V.FA_TRX_DATE%TYPE := OKC_API.G_MISS_DATE,
153 --Bug# 4899328
154 fa_cost NUMBER := OKL_API.G_MISS_NUM,
155 attribute_category OKL_TXL_ASSETS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
156 attribute1 OKL_TXL_ASSETS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
157 attribute2 OKL_TXL_ASSETS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
158 attribute3 OKL_TXL_ASSETS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
159 attribute4 OKL_TXL_ASSETS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
160 attribute5 OKL_TXL_ASSETS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
161 attribute6 OKL_TXL_ASSETS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
162 attribute7 OKL_TXL_ASSETS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
163 attribute8 OKL_TXL_ASSETS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
164 attribute9 OKL_TXL_ASSETS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
165 attribute10 OKL_TXL_ASSETS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
166 attribute11 OKL_TXL_ASSETS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
167 attribute12 OKL_TXL_ASSETS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
168 attribute13 OKL_TXL_ASSETS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
169 attribute14 OKL_TXL_ASSETS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
170 attribute15 OKL_TXL_ASSETS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
171 created_by NUMBER := OKC_API.G_MISS_NUM,
172 creation_date OKL_TXL_ASSETS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
173 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
174 last_update_date OKL_TXL_ASSETS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
175 last_update_login NUMBER := OKC_API.G_MISS_NUM,
176 depreciate_yn OKL_TXL_ASSETS_B.DEPRECIATE_YN%TYPE := OKC_API.G_MISS_CHAR,
177 hold_period_days NUMBER := OKC_API.G_MISS_NUM,
178 old_salvage_value NUMBER := OKC_API.G_MISS_NUM,
179 new_residual_value NUMBER := OKC_API.G_MISS_NUM,
180 old_residual_value NUMBER := OKC_API.G_MISS_NUM,
181 units_retired NUMBER := OKC_API.G_MISS_NUM,
182 cost_retired NUMBER := OKC_API.G_MISS_NUM,
183 sale_proceeds NUMBER := OKC_API.G_MISS_NUM,
184 removal_cost NUMBER := OKC_API.G_MISS_NUM,
185 dnz_asset_id NUMBER := OKC_API.G_MISS_NUM,
186 date_due OKL_TXL_ASSETS_B.DATE_DUE%TYPE := OKC_API.G_MISS_DATE,
187 rep_asset_id NUMBER := OKC_API.G_MISS_NUM,
188 lke_asset_id NUMBER := OKC_API.G_MISS_NUM,
189 match_amount NUMBER := OKC_API.G_MISS_NUM,
190 split_into_singles_flag OKL_TXL_ASSETS_B.SPLIT_INTO_SINGLES_FLAG%TYPE := OKC_API.G_MISS_CHAR,
191 split_into_units NUMBER := OKC_API.G_MISS_NUM,
192 -- Multi-Currency Change
193 currency_code OKL_TXL_ASSETS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
194 currency_conversion_type OKL_TXL_ASSETS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
195 currency_conversion_rate NUMBER := OKC_API.G_MISS_NUM,
196 currency_conversion_date OKL_TXL_ASSETS_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
197 -- Multi-Currency Change
198 -- VRS Project - START
199 RESIDUAL_SHR_PARTY_ID NUMBER := OKC_API.G_MISS_NUM,
200 RESIDUAL_SHR_AMOUNT NUMBER := OKC_API.G_MISS_NUM,
201 RETIREMENT_ID NUMBER := OKC_API.G_MISS_NUM
202 -- VRS Project - END
203 );
204
205 g_miss_talv_rec talv_rec_type;
206 TYPE talv_tbl_type IS TABLE OF talv_rec_type
207 INDEX BY BINARY_INTEGER;
208 ---------------------------------------------------------------------------
209 -- GLOBAL MESSAGE CONSTANTS
210 ---------------------------------------------------------------------------
211 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
212 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
213 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
214 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
215 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
216 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
217 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
218 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
219 ---------------------------------------------------------------------------
220 -- GLOBAL VARIABLES
221 ---------------------------------------------------------------------------
222 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_TAL_PVT';
223 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
224 ---------------------------------------------------------------------------
225 -- Procedures and Functions
226 ---------------------------------------------------------------------------
227
228 PROCEDURE qc;
229 PROCEDURE change_version;
230 PROCEDURE api_copy;
231 PROCEDURE add_language;
232 PROCEDURE insert_row(
233 p_api_version IN NUMBER,
234 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
235 x_return_status OUT NOCOPY VARCHAR2,
236 x_msg_count OUT NOCOPY NUMBER,
237 x_msg_data OUT NOCOPY VARCHAR2,
238 p_talv_rec IN talv_rec_type,
239 x_talv_rec OUT NOCOPY talv_rec_type);
240
241 PROCEDURE insert_row(
242 p_api_version IN NUMBER,
243 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
244 x_return_status OUT NOCOPY VARCHAR2,
245 x_msg_count OUT NOCOPY NUMBER,
246 x_msg_data OUT NOCOPY VARCHAR2,
247 p_talv_tbl IN talv_tbl_type,
248 x_talv_tbl OUT NOCOPY talv_tbl_type);
249
250 PROCEDURE lock_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_talv_rec IN talv_rec_type);
257
258 PROCEDURE lock_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_talv_tbl IN talv_tbl_type);
265
266 PROCEDURE update_row(
267 p_api_version IN NUMBER,
268 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
269 x_return_status OUT NOCOPY VARCHAR2,
270 x_msg_count OUT NOCOPY NUMBER,
271 x_msg_data OUT NOCOPY VARCHAR2,
272 p_talv_rec IN talv_rec_type,
273 x_talv_rec OUT NOCOPY talv_rec_type);
274
275 PROCEDURE update_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_talv_tbl IN talv_tbl_type,
282 x_talv_tbl OUT NOCOPY talv_tbl_type);
283
284 PROCEDURE delete_row(
285 p_api_version IN NUMBER,
286 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
287 x_return_status OUT NOCOPY VARCHAR2,
288 x_msg_count OUT NOCOPY NUMBER,
289 x_msg_data OUT NOCOPY VARCHAR2,
290 p_talv_rec IN talv_rec_type);
291
292 PROCEDURE delete_row(
293 p_api_version IN NUMBER,
294 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
295 x_return_status OUT NOCOPY VARCHAR2,
296 x_msg_count OUT NOCOPY NUMBER,
297 x_msg_data OUT NOCOPY VARCHAR2,
298 p_talv_tbl IN talv_tbl_type);
299
300 PROCEDURE validate_row(
301 p_api_version IN NUMBER,
302 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
303 x_return_status OUT NOCOPY VARCHAR2,
304 x_msg_count OUT NOCOPY NUMBER,
305 x_msg_data OUT NOCOPY VARCHAR2,
306 p_talv_rec IN talv_rec_type);
307
308 PROCEDURE validate_row(
309 p_api_version IN NUMBER,
310 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
311 x_return_status OUT NOCOPY VARCHAR2,
312 x_msg_count OUT NOCOPY NUMBER,
313 x_msg_data OUT NOCOPY VARCHAR2,
314 p_talv_tbl IN talv_tbl_type);
315
316 END OKL_TAL_PVT;