[Home] [Help]
PACKAGE: APPS.OKL_ART_PVT
Source
1 PACKAGE OKL_ART_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSARTS.pls 120.5 2007/11/09 22:09:59 djanaswa noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE art_rec_type IS RECORD (
7 id NUMBER := OKC_API.G_MISS_NUM,
8 kle_id NUMBER := OKC_API.G_MISS_NUM,
9 security_dep_trx_ap_id NUMBER := OKC_API.G_MISS_NUM,
10 iso_id NUMBER := OKC_API.G_MISS_NUM,
11 rna_id NUMBER := OKC_API.G_MISS_NUM,
12 rmr_id NUMBER := OKC_API.G_MISS_NUM,
13 ars_code OKL_ASSET_RETURNS_B.ARS_CODE%TYPE := OKC_API.G_MISS_CHAR,
14 imr_id NUMBER := OKC_API.G_MISS_NUM,
15 art1_code OKL_ASSET_RETURNS_B.ART1_CODE%TYPE := OKC_API.G_MISS_CHAR,
16 date_return_due OKL_ASSET_RETURNS_B.DATE_RETURN_DUE%TYPE := OKC_API.G_MISS_DATE,
17 date_return_notified OKL_ASSET_RETURNS_B.DATE_RETURN_NOTIFIED%TYPE := OKC_API.G_MISS_DATE,
18 relocate_asset_yn OKL_ASSET_RETURNS_B.RELOCATE_ASSET_YN%TYPE := OKC_API.G_MISS_CHAR,
19 object_version_number NUMBER := OKC_API.G_MISS_NUM,
20 voluntary_yn OKL_ASSET_RETURNS_B.VOLUNTARY_YN%TYPE := OKC_API.G_MISS_CHAR,
21 commmercially_reas_sale_yn OKL_ASSET_RETURNS_B.COMMMERCIALLY_REAS_SALE_YN%TYPE := OKC_API.G_MISS_CHAR,
22 date_repossession_required OKL_ASSET_RETURNS_B.DATE_REPOSSESSION_REQUIRED%TYPE := OKC_API.G_MISS_DATE,
23 date_repossession_actual OKL_ASSET_RETURNS_B.DATE_REPOSSESSION_ACTUAL%TYPE := OKC_API.G_MISS_DATE,
24 date_hold_until OKL_ASSET_RETURNS_B.DATE_HOLD_UNTIL%TYPE := OKC_API.G_MISS_DATE,
25 date_returned OKL_ASSET_RETURNS_B.DATE_RETURNED%TYPE := OKC_API.G_MISS_DATE,
26 date_title_returned OKL_ASSET_RETURNS_B.DATE_TITLE_RETURNED%TYPE := OKC_API.G_MISS_DATE,
27 org_id NUMBER := OKC_API.G_MISS_NUM,
28 request_id NUMBER := OKC_API.G_MISS_NUM,
29 program_application_id NUMBER := OKC_API.G_MISS_NUM,
30 program_id NUMBER := OKC_API.G_MISS_NUM,
31 program_update_date OKL_ASSET_RETURNS_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32 attribute_category OKL_ASSET_RETURNS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
33 attribute1 OKL_ASSET_RETURNS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
34 attribute2 OKL_ASSET_RETURNS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
35 attribute3 OKL_ASSET_RETURNS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
36 attribute4 OKL_ASSET_RETURNS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
37 attribute5 OKL_ASSET_RETURNS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
38 attribute6 OKL_ASSET_RETURNS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
39 attribute7 OKL_ASSET_RETURNS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
40 attribute8 OKL_ASSET_RETURNS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
41 attribute9 OKL_ASSET_RETURNS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
42 attribute10 OKL_ASSET_RETURNS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
43 attribute11 OKL_ASSET_RETURNS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
44 attribute12 OKL_ASSET_RETURNS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
45 attribute13 OKL_ASSET_RETURNS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
46 attribute14 OKL_ASSET_RETURNS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
47 attribute15 OKL_ASSET_RETURNS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
48 created_by NUMBER := OKC_API.G_MISS_NUM,
49 creation_date OKL_ASSET_RETURNS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
50 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
51 last_update_date OKL_ASSET_RETURNS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
52 last_update_login NUMBER := OKC_API.G_MISS_NUM,
53 floor_price NUMBER := OKC_API.G_MISS_NUM,
54 -- SECHAWLA 30-SEP-04 3924244 : added a new column new_item_number
55
56 -- 17-MAR-05 SECHAWLA 4239947 : initailize new_item_number to OKC_API.G_MISS_CHAR
57 new_item_number OKL_ASSET_RETURNS_B.new_item_number%TYPE := OKC_API.G_MISS_CHAR,
58
59 new_item_price NUMBER := OKC_API.G_MISS_NUM,
60 asset_relocated_yn OKL_ASSET_RETURNS_B.ASSET_RELOCATED_YN%TYPE := OKC_API.G_MISS_CHAR,
61 repurchase_agmt_yn OKL_ASSET_RETURNS_B.REPURCHASE_AGMT_YN%TYPE := OKC_API.G_MISS_CHAR,
62 like_kind_yn OKL_ASSET_RETURNS_B.LIKE_KIND_YN%TYPE := OKC_API.G_MISS_CHAR,
63 -- RABHUPAT - 2667636 - Start
64 currency_code OKL_ASSET_RETURNS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
65 currency_conversion_code OKL_ASSET_RETURNS_B.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
66 currency_conversion_type OKL_ASSET_RETURNS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
67 currency_conversion_rate OKL_ASSET_RETURNS_B.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
68 currency_conversion_date OKL_ASSET_RETURNS_B.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
69 --RABHUPAT - 2667636 - End
70 -- RRAVIKIR - Legal Entity Changes
71 legal_entity_id OKL_ASSET_RETURNS_B.LEGAL_ENTITY_ID%TYPE := OKC_API.G_MISS_NUM,
72 -- Legal Entity Changes End
73 -- DJANASWA Loan Repossession proj start
74 ASSET_FMV_AMOUNT OKL_ASSET_RETURNS_B.ASSET_FMV_AMOUNT%TYPE := OKC_API.G_MISS_NUM);
75 -- Loan Repossession proj end
76 g_miss_art_rec art_rec_type;
77 TYPE art_tbl_type IS TABLE OF art_rec_type
78 INDEX BY BINARY_INTEGER;
79 TYPE okl_asset_returns_tl_rec_type IS RECORD (
80 id NUMBER := OKC_API.G_MISS_NUM,
81 language OKL_ASSET_RETURNS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
82 source_lang OKL_ASSET_RETURNS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
83 sfwt_flag OKL_ASSET_RETURNS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
84 comments OKL_ASSET_RETURNS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
85 created_by NUMBER := OKC_API.G_MISS_NUM,
86 creation_date OKL_ASSET_RETURNS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
87 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
88 last_update_date OKL_ASSET_RETURNS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
89 last_update_login NUMBER := OKC_API.G_MISS_NUM,
90 new_item_description OKL_ASSET_RETURNS_TL.NEW_ITEM_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR);
91 GMissOklAssetReturnsTlRec okl_asset_returns_tl_rec_type;
92 TYPE okl_asset_returns_tl_tbl_type IS TABLE OF okl_asset_returns_tl_rec_type
93 INDEX BY BINARY_INTEGER;
94 TYPE artv_rec_type IS RECORD (
95 id NUMBER := OKC_API.G_MISS_NUM,
96 object_version_number NUMBER := OKC_API.G_MISS_NUM,
97 sfwt_flag OKL_ASSET_RETURNS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
98 rmr_id NUMBER := OKC_API.G_MISS_NUM,
99 imr_id NUMBER := OKC_API.G_MISS_NUM,
100 rna_id NUMBER := OKC_API.G_MISS_NUM,
101 kle_id NUMBER := OKC_API.G_MISS_NUM,
102 iso_id NUMBER := OKC_API.G_MISS_NUM,
103 security_dep_trx_ap_id NUMBER := OKC_API.G_MISS_NUM,
104 ars_code OKL_ASSET_RETURNS_V.ARS_CODE%TYPE := OKC_API.G_MISS_CHAR,
105 art1_code OKL_ASSET_RETURNS_V.ART1_CODE%TYPE := OKC_API.G_MISS_CHAR,
106 date_returned OKL_ASSET_RETURNS_V.DATE_RETURNED%TYPE := OKC_API.G_MISS_DATE,
107 date_title_returned OKL_ASSET_RETURNS_V.DATE_TITLE_RETURNED%TYPE := OKC_API.G_MISS_DATE,
108 date_return_due OKL_ASSET_RETURNS_V.DATE_RETURN_DUE%TYPE := OKC_API.G_MISS_DATE,
109 date_return_notified OKL_ASSET_RETURNS_V.DATE_RETURN_NOTIFIED%TYPE := OKC_API.G_MISS_DATE,
110 relocate_asset_yn OKL_ASSET_RETURNS_V.RELOCATE_ASSET_YN%TYPE := OKC_API.G_MISS_CHAR,
111 voluntary_yn OKL_ASSET_RETURNS_V.VOLUNTARY_YN%TYPE := OKC_API.G_MISS_CHAR,
112 date_repossession_required OKL_ASSET_RETURNS_V.DATE_REPOSSESSION_REQUIRED%TYPE := OKC_API.G_MISS_DATE,
113 date_repossession_actual OKL_ASSET_RETURNS_V.DATE_REPOSSESSION_ACTUAL%TYPE := OKC_API.G_MISS_DATE,
114 date_hold_until OKL_ASSET_RETURNS_V.DATE_HOLD_UNTIL%TYPE := OKC_API.G_MISS_DATE,
115 commmercially_reas_sale_yn OKL_ASSET_RETURNS_V.COMMMERCIALLY_REAS_SALE_YN%TYPE := OKC_API.G_MISS_CHAR,
116 comments OKL_ASSET_RETURNS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
117 attribute_category OKL_ASSET_RETURNS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
118 attribute1 OKL_ASSET_RETURNS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
119 attribute2 OKL_ASSET_RETURNS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
120 attribute3 OKL_ASSET_RETURNS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
121 attribute4 OKL_ASSET_RETURNS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
122 attribute5 OKL_ASSET_RETURNS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
123 attribute6 OKL_ASSET_RETURNS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
124 attribute7 OKL_ASSET_RETURNS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
125 attribute8 OKL_ASSET_RETURNS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
126 attribute9 OKL_ASSET_RETURNS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
127 attribute10 OKL_ASSET_RETURNS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
128 attribute11 OKL_ASSET_RETURNS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
129 attribute12 OKL_ASSET_RETURNS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
130 attribute13 OKL_ASSET_RETURNS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
131 attribute14 OKL_ASSET_RETURNS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
132 attribute15 OKL_ASSET_RETURNS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
133 org_id NUMBER := OKC_API.G_MISS_NUM,
134 request_id NUMBER := OKC_API.G_MISS_NUM,
135 program_application_id NUMBER := OKC_API.G_MISS_NUM,
136 program_id NUMBER := OKC_API.G_MISS_NUM,
137 program_update_date OKL_ASSET_RETURNS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
138 created_by NUMBER := OKC_API.G_MISS_NUM,
139 creation_date OKL_ASSET_RETURNS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
140 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
141 last_update_date OKL_ASSET_RETURNS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
142 last_update_login NUMBER := OKC_API.G_MISS_NUM,
143 floor_price NUMBER := OKC_API.G_MISS_NUM,
144 -- SECHAWLA 30-SEP-04 3924244 : added a new column new_item_number
145
146 -- 17-MAR-05 SECHAWLA 4239947 : initailize new_item_number to OKC_API.G_MISS_CHAR
147 new_item_number OKL_ASSET_RETURNS_B.new_item_number%TYPE := OKC_API.G_MISS_CHAR,
148 new_item_price NUMBER := OKC_API.G_MISS_NUM,
149 asset_relocated_yn OKL_ASSET_RETURNS_V.ASSET_RELOCATED_YN%TYPE := OKC_API.G_MISS_CHAR,
150 new_item_description OKL_ASSET_RETURNS_V.NEW_ITEM_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
151 repurchase_agmt_yn OKL_ASSET_RETURNS_V.REPURCHASE_AGMT_YN%TYPE := OKC_API.G_MISS_CHAR,
152 like_kind_yn OKL_ASSET_RETURNS_V.LIKE_KIND_YN%TYPE := OKC_API.G_MISS_CHAR,
153 -- RABHUPAT - 2667636 - Start
154 currency_code OKL_ASSET_RETURNS_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
155 currency_conversion_code OKL_ASSET_RETURNS_V.CURRENCY_CONVERSION_CODE%TYPE := OKC_API.G_MISS_CHAR,
156 currency_conversion_type OKL_ASSET_RETURNS_V.CURRENCY_CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
157 currency_conversion_rate OKL_ASSET_RETURNS_V.CURRENCY_CONVERSION_RATE%TYPE := OKC_API.G_MISS_NUM,
158 currency_conversion_date OKL_ASSET_RETURNS_V.CURRENCY_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE,
159 -- RABHUPAT - 2667636 - End
160 -- RRAVIKIR - Legal Entity Changes
161 legal_entity_id OKL_ASSET_RETURNS_B.LEGAL_ENTITY_ID%TYPE := OKC_API.G_MISS_NUM,
162 -- Legal Entity Changes End
163 -- DJANASWA Loan Repossession proj start
164 ASSET_FMV_AMOUNT OKL_ASSET_RETURNS_V.ASSET_FMV_AMOUNT%TYPE := OKC_API.G_MISS_NUM);
165 -- Loan Repossession proj end
166
167 g_miss_artv_rec artv_rec_type;
168 TYPE artv_tbl_type IS TABLE OF artv_rec_type
169 INDEX BY BINARY_INTEGER;
170 ---------------------------------------------------------------------------
171 -- GLOBAL MESSAGE CONSTANTS
172 ---------------------------------------------------------------------------
173 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
174 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
175 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
176 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
177 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
178 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
179 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
180 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
181 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
182 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
183 ---------------------------------------------------------------------------
184 -- GLOBAL VARIABLES
185 ---------------------------------------------------------------------------
186 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_ART_PVT';
187 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
188 ---------------------------------------------------------------------------
189 -- Procedures and Functions
190 ---------------------------------------------------------------------------
191
192 PROCEDURE qc;
193 PROCEDURE change_version;
194 PROCEDURE api_copy;
195 PROCEDURE add_language;
196 PROCEDURE insert_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_artv_rec IN artv_rec_type,
203 x_artv_rec OUT NOCOPY artv_rec_type);
204
205 PROCEDURE insert_row(
206 p_api_version IN NUMBER,
207 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_artv_tbl IN artv_tbl_type,
212 x_artv_tbl OUT NOCOPY artv_tbl_type);
213
214 PROCEDURE lock_row(
215 p_api_version IN NUMBER,
216 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
217 x_return_status OUT NOCOPY VARCHAR2,
218 x_msg_count OUT NOCOPY NUMBER,
219 x_msg_data OUT NOCOPY VARCHAR2,
220 p_artv_rec IN artv_rec_type);
221
222 PROCEDURE lock_row(
223 p_api_version IN NUMBER,
224 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
225 x_return_status OUT NOCOPY VARCHAR2,
226 x_msg_count OUT NOCOPY NUMBER,
227 x_msg_data OUT NOCOPY VARCHAR2,
228 p_artv_tbl IN artv_tbl_type);
229
230 PROCEDURE update_row(
231 p_api_version IN NUMBER,
232 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
233 x_return_status OUT NOCOPY VARCHAR2,
234 x_msg_count OUT NOCOPY NUMBER,
235 x_msg_data OUT NOCOPY VARCHAR2,
236 p_artv_rec IN artv_rec_type,
237 x_artv_rec OUT NOCOPY artv_rec_type);
238
239 PROCEDURE update_row(
240 p_api_version IN NUMBER,
241 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
242 x_return_status OUT NOCOPY VARCHAR2,
243 x_msg_count OUT NOCOPY NUMBER,
244 x_msg_data OUT NOCOPY VARCHAR2,
245 p_artv_tbl IN artv_tbl_type,
246 x_artv_tbl OUT NOCOPY artv_tbl_type);
247
248 PROCEDURE delete_row(
249 p_api_version IN NUMBER,
250 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
251 x_return_status OUT NOCOPY VARCHAR2,
252 x_msg_count OUT NOCOPY NUMBER,
253 x_msg_data OUT NOCOPY VARCHAR2,
254 p_artv_rec IN artv_rec_type);
255
256 PROCEDURE delete_row(
257 p_api_version IN NUMBER,
258 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
259 x_return_status OUT NOCOPY VARCHAR2,
260 x_msg_count OUT NOCOPY NUMBER,
261 x_msg_data OUT NOCOPY VARCHAR2,
262 p_artv_tbl IN artv_tbl_type);
263
264 PROCEDURE validate_row(
265 p_api_version IN NUMBER,
266 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
267 x_return_status OUT NOCOPY VARCHAR2,
268 x_msg_count OUT NOCOPY NUMBER,
269 x_msg_data OUT NOCOPY VARCHAR2,
270 p_artv_rec IN artv_rec_type);
271
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_artv_tbl IN artv_tbl_type);
279
280 END OKL_ART_PVT;