[Home] [Help]
PACKAGE: APPS.OKL_OIN_PVT
Source
1 PACKAGE OKL_OIN_PVT AS
2 /* $Header: OKLSOINS.pls 120.2 2006/07/11 10:23:47 dkagrawa noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 -- OKL_OPEN_INT_V Record Spec
7 TYPE oinv_rec_type IS RECORD (
8 id NUMBER := OKC_API.G_MISS_NUM
9 ,party_id NUMBER := OKC_API.G_MISS_NUM
10 ,party_name OKL_OPEN_INT.PARTY_NAME%TYPE := OKC_API.G_MISS_CHAR
11 ,party_type OKL_OPEN_INT.PARTY_TYPE%TYPE := OKC_API.G_MISS_CHAR
12 ,date_of_birth OKL_OPEN_INT.DATE_OF_BIRTH%TYPE := OKC_API.G_MISS_DATE
13 ,place_of_birth OKL_OPEN_INT.PLACE_OF_BIRTH%TYPE := OKC_API.G_MISS_CHAR
14 ,person_identifier OKL_OPEN_INT.PERSON_IDENTIFIER%TYPE := OKC_API.G_MISS_CHAR
15 ,person_iden_type OKL_OPEN_INT.PERSON_IDEN_TYPE%TYPE := OKC_API.G_MISS_CHAR
16 ,country OKL_OPEN_INT.COUNTRY%TYPE := OKC_API.G_MISS_CHAR
17 ,address1 OKL_OPEN_INT.ADDRESS1%TYPE := OKC_API.G_MISS_CHAR
18 ,address2 OKL_OPEN_INT.ADDRESS2%TYPE := OKC_API.G_MISS_CHAR
19 ,address3 OKL_OPEN_INT.ADDRESS3%TYPE := OKC_API.G_MISS_CHAR
20 ,address4 OKL_OPEN_INT.ADDRESS4%TYPE := OKC_API.G_MISS_CHAR
21 ,city OKL_OPEN_INT.CITY%TYPE := OKC_API.G_MISS_CHAR
22 ,postal_code OKL_OPEN_INT.POSTAL_CODE%TYPE := OKC_API.G_MISS_CHAR
23 ,state OKL_OPEN_INT.STATE%TYPE := OKC_API.G_MISS_CHAR
24 ,province OKL_OPEN_INT.PROVINCE%TYPE := OKC_API.G_MISS_CHAR
25 ,county OKL_OPEN_INT.COUNTY%TYPE := OKC_API.G_MISS_CHAR
26 ,po_box_number OKL_OPEN_INT.PO_BOX_NUMBER%TYPE := OKC_API.G_MISS_CHAR
27 ,house_number OKL_OPEN_INT.HOUSE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
28 ,street_suffix OKL_OPEN_INT.STREET_SUFFIX%TYPE := OKC_API.G_MISS_CHAR
29 ,apartment_number OKL_OPEN_INT.APARTMENT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
30 ,street OKL_OPEN_INT.STREET%TYPE := OKC_API.G_MISS_CHAR
31 ,rural_route_number OKL_OPEN_INT.RURAL_ROUTE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
32 ,street_number OKL_OPEN_INT.STREET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
33 ,building OKL_OPEN_INT.BUILDING%TYPE := OKC_API.G_MISS_CHAR
34 ,floor OKL_OPEN_INT.FLOOR%TYPE := OKC_API.G_MISS_CHAR
35 ,suite OKL_OPEN_INT.SUITE%TYPE := OKC_API.G_MISS_CHAR
36 ,room OKL_OPEN_INT.ROOM%TYPE := OKC_API.G_MISS_CHAR
37 ,postal_plus4_code OKL_OPEN_INT.POSTAL_PLUS4_CODE%TYPE := OKC_API.G_MISS_CHAR
38 ,cas_id NUMBER := OKC_API.G_MISS_NUM
39 ,case_number OKL_OPEN_INT.CASE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
40 ,khr_id NUMBER := OKC_API.G_MISS_NUM
41 ,contract_number OKL_OPEN_INT.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
42 ,contract_type OKL_OPEN_INT.CONTRACT_TYPE%TYPE := OKC_API.G_MISS_CHAR
43 ,contract_status OKL_OPEN_INT.CONTRACT_STATUS%TYPE := OKC_API.G_MISS_CHAR
44 ,original_amount NUMBER := OKC_API.G_MISS_NUM
45 ,start_date OKL_OPEN_INT.START_DATE%TYPE := OKC_API.G_MISS_DATE
46 ,close_date OKL_OPEN_INT.CLOSE_DATE%TYPE := OKC_API.G_MISS_DATE
47 ,term_duration NUMBER := OKC_API.G_MISS_NUM
48 ,monthly_payment_amount NUMBER := OKC_API.G_MISS_NUM
49 ,last_payment_date OKL_OPEN_INT.LAST_PAYMENT_DATE%TYPE := OKC_API.G_MISS_DATE
50 ,delinquency_occurance_date OKL_OPEN_INT.DELINQUENCY_OCCURANCE_DATE%TYPE := OKC_API.G_MISS_DATE
51 ,past_due_amount NUMBER := OKC_API.G_MISS_NUM
52 ,remaining_amount NUMBER := OKC_API.G_MISS_NUM
53 ,credit_indicator OKL_OPEN_INT.CREDIT_INDICATOR%TYPE := OKC_API.G_MISS_CHAR
54 ,notification_date OKL_OPEN_INT.NOTIFICATION_DATE%TYPE := OKC_API.G_MISS_DATE
55 ,credit_bureau_report_date OKL_OPEN_INT.CREDIT_BUREAU_REPORT_DATE%TYPE := OKC_API.G_MISS_DATE
56 ,external_agency_transfer_date OKL_OPEN_INT.EXTERNAL_AGENCY_TRANSFER_DATE%TYPE := OKC_API.G_MISS_DATE
57 ,external_agency_recall_date OKL_OPEN_INT.EXTERNAL_AGENCY_RECALL_DATE%TYPE := OKC_API.G_MISS_DATE
58 ,referral_number NUMBER := OKC_API.G_MISS_NUM
59 ,contact_id NUMBER := OKC_API.G_MISS_NUM
60 ,contact_name OKL_OPEN_INT.CONTACT_NAME%TYPE := OKC_API.G_MISS_CHAR
61 ,contact_phone OKL_OPEN_INT.CONTACT_PHONE%TYPE := OKC_API.G_MISS_CHAR
62 ,contact_email OKL_OPEN_INT.CONTACT_EMAIL%TYPE := OKC_API.G_MISS_CHAR
63 ,object_version_number NUMBER := OKC_API.G_MISS_NUM
64 ,org_id NUMBER := OKC_API.G_MISS_NUM
65 ,request_id NUMBER := OKC_API.G_MISS_NUM
66 ,program_application_id NUMBER := OKC_API.G_MISS_NUM
67 ,program_id NUMBER := OKC_API.G_MISS_NUM
68 ,program_update_date OKL_OPEN_INT.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
69 ,attribute_category OKL_OPEN_INT.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
70 ,attribute1 OKL_OPEN_INT.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
71 ,attribute2 OKL_OPEN_INT.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
72 ,attribute3 OKL_OPEN_INT.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
73 ,attribute4 OKL_OPEN_INT.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
74 ,attribute5 OKL_OPEN_INT.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
75 ,attribute6 OKL_OPEN_INT.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
76 ,attribute7 OKL_OPEN_INT.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
77 ,attribute8 OKL_OPEN_INT.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
78 ,attribute9 OKL_OPEN_INT.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
79 ,attribute10 OKL_OPEN_INT.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
80 ,attribute11 OKL_OPEN_INT.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
81 ,attribute12 OKL_OPEN_INT.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
82 ,attribute13 OKL_OPEN_INT.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
83 ,attribute14 OKL_OPEN_INT.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
84 ,attribute15 OKL_OPEN_INT.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
85 ,created_by NUMBER := OKC_API.G_MISS_NUM
86 ,creation_date OKL_OPEN_INT.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
87 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
88 ,last_update_date OKL_OPEN_INT.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
89 ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
90 G_MISS_oinv_rec oinv_rec_type;
91 TYPE oinv_tbl_type IS TABLE OF oinv_rec_type
92 INDEX BY BINARY_INTEGER;
93 -- OKL_OPEN_INT Record Spec
94 TYPE oin_rec_type IS RECORD (
95 id NUMBER := OKC_API.G_MISS_NUM
96 ,party_id NUMBER := OKC_API.G_MISS_NUM
97 ,party_name OKL_OPEN_INT.PARTY_NAME%TYPE := OKC_API.G_MISS_CHAR
98 ,party_type OKL_OPEN_INT.PARTY_TYPE%TYPE := OKC_API.G_MISS_CHAR
99 ,date_of_birth OKL_OPEN_INT.DATE_OF_BIRTH%TYPE := OKC_API.G_MISS_DATE
100 ,place_of_birth OKL_OPEN_INT.PLACE_OF_BIRTH%TYPE := OKC_API.G_MISS_CHAR
101 ,person_identifier OKL_OPEN_INT.PERSON_IDENTIFIER%TYPE := OKC_API.G_MISS_CHAR
102 ,person_iden_type OKL_OPEN_INT.PERSON_IDEN_TYPE%TYPE := OKC_API.G_MISS_CHAR
103 ,country OKL_OPEN_INT.COUNTRY%TYPE := OKC_API.G_MISS_CHAR
104 ,address1 OKL_OPEN_INT.ADDRESS1%TYPE := OKC_API.G_MISS_CHAR
105 ,address2 OKL_OPEN_INT.ADDRESS2%TYPE := OKC_API.G_MISS_CHAR
106 ,address3 OKL_OPEN_INT.ADDRESS3%TYPE := OKC_API.G_MISS_CHAR
107 ,address4 OKL_OPEN_INT.ADDRESS4%TYPE := OKC_API.G_MISS_CHAR
108 ,city OKL_OPEN_INT.CITY%TYPE := OKC_API.G_MISS_CHAR
109 ,postal_code OKL_OPEN_INT.POSTAL_CODE%TYPE := OKC_API.G_MISS_CHAR
110 ,state OKL_OPEN_INT.STATE%TYPE := OKC_API.G_MISS_CHAR
111 ,province OKL_OPEN_INT.PROVINCE%TYPE := OKC_API.G_MISS_CHAR
112 ,county OKL_OPEN_INT.COUNTY%TYPE := OKC_API.G_MISS_CHAR
113 ,po_box_number OKL_OPEN_INT.PO_BOX_NUMBER%TYPE := OKC_API.G_MISS_CHAR
114 ,house_number OKL_OPEN_INT.HOUSE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
115 ,street_suffix OKL_OPEN_INT.STREET_SUFFIX%TYPE := OKC_API.G_MISS_CHAR
116 ,apartment_number OKL_OPEN_INT.APARTMENT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
117 ,street OKL_OPEN_INT.STREET%TYPE := OKC_API.G_MISS_CHAR
118 ,rural_route_number OKL_OPEN_INT.RURAL_ROUTE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
119 ,street_number OKL_OPEN_INT.STREET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
120 ,building OKL_OPEN_INT.BUILDING%TYPE := OKC_API.G_MISS_CHAR
121 ,floor OKL_OPEN_INT.FLOOR%TYPE := OKC_API.G_MISS_CHAR
122 ,suite OKL_OPEN_INT.SUITE%TYPE := OKC_API.G_MISS_CHAR
123 ,room OKL_OPEN_INT.ROOM%TYPE := OKC_API.G_MISS_CHAR
124 ,postal_plus4_code OKL_OPEN_INT.POSTAL_PLUS4_CODE%TYPE := OKC_API.G_MISS_CHAR
125 ,cas_id NUMBER := OKC_API.G_MISS_NUM
126 ,case_number OKL_OPEN_INT.CASE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
127 ,khr_id NUMBER := OKC_API.G_MISS_NUM
128 ,contract_number OKL_OPEN_INT.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
129 ,contract_type OKL_OPEN_INT.CONTRACT_TYPE%TYPE := OKC_API.G_MISS_CHAR
130 ,contract_status OKL_OPEN_INT.CONTRACT_STATUS%TYPE := OKC_API.G_MISS_CHAR
131 ,original_amount NUMBER := OKC_API.G_MISS_NUM
132 ,start_date OKL_OPEN_INT.START_DATE%TYPE := OKC_API.G_MISS_DATE
133 ,close_date OKL_OPEN_INT.CLOSE_DATE%TYPE := OKC_API.G_MISS_DATE
134 ,term_duration NUMBER := OKC_API.G_MISS_NUM
135 ,monthly_payment_amount NUMBER := OKC_API.G_MISS_NUM
136 ,last_payment_date OKL_OPEN_INT.LAST_PAYMENT_DATE%TYPE := OKC_API.G_MISS_DATE
137 ,delinquency_occurance_date OKL_OPEN_INT.DELINQUENCY_OCCURANCE_DATE%TYPE := OKC_API.G_MISS_DATE
138 ,past_due_amount NUMBER := OKC_API.G_MISS_NUM
139 ,remaining_amount NUMBER := OKC_API.G_MISS_NUM
140 ,credit_indicator OKL_OPEN_INT.CREDIT_INDICATOR%TYPE := OKC_API.G_MISS_CHAR
141 ,notification_date OKL_OPEN_INT.NOTIFICATION_DATE%TYPE := OKC_API.G_MISS_DATE
142 ,credit_bureau_report_date OKL_OPEN_INT.CREDIT_BUREAU_REPORT_DATE%TYPE := OKC_API.G_MISS_DATE
143 ,external_agency_transfer_date OKL_OPEN_INT.EXTERNAL_AGENCY_TRANSFER_DATE%TYPE := OKC_API.G_MISS_DATE
144 ,external_agency_recall_date OKL_OPEN_INT.EXTERNAL_AGENCY_RECALL_DATE%TYPE := OKC_API.G_MISS_DATE
145 ,referral_number NUMBER := OKC_API.G_MISS_NUM
146 ,contact_id NUMBER := OKC_API.G_MISS_NUM
147 ,contact_name OKL_OPEN_INT.CONTACT_NAME%TYPE := OKC_API.G_MISS_CHAR
148 ,contact_phone OKL_OPEN_INT.CONTACT_PHONE%TYPE := OKC_API.G_MISS_CHAR
149 ,contact_email OKL_OPEN_INT.CONTACT_EMAIL%TYPE := OKC_API.G_MISS_CHAR
150 ,object_version_number NUMBER := OKC_API.G_MISS_NUM
151 ,org_id NUMBER := OKC_API.G_MISS_NUM
152 ,request_id NUMBER := OKC_API.G_MISS_NUM
153 ,program_application_id NUMBER := OKC_API.G_MISS_NUM
154 ,program_id NUMBER := OKC_API.G_MISS_NUM
155 ,program_update_date OKL_OPEN_INT.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
156 ,attribute_category OKL_OPEN_INT.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
157 ,attribute1 OKL_OPEN_INT.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
158 ,attribute2 OKL_OPEN_INT.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
159 ,attribute3 OKL_OPEN_INT.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
160 ,attribute4 OKL_OPEN_INT.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
161 ,attribute5 OKL_OPEN_INT.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
162 ,attribute6 OKL_OPEN_INT.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
163 ,attribute7 OKL_OPEN_INT.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
164 ,attribute8 OKL_OPEN_INT.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
165 ,attribute9 OKL_OPEN_INT.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
166 ,attribute10 OKL_OPEN_INT.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
167 ,attribute11 OKL_OPEN_INT.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
168 ,attribute12 OKL_OPEN_INT.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
169 ,attribute13 OKL_OPEN_INT.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
170 ,attribute14 OKL_OPEN_INT.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
171 ,attribute15 OKL_OPEN_INT.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
172 ,created_by NUMBER := OKC_API.G_MISS_NUM
173 ,creation_date OKL_OPEN_INT.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
174 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
175 ,last_update_date OKL_OPEN_INT.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
176 ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
177 G_MISS_oin_rec oin_rec_type;
178 TYPE oin_tbl_type IS TABLE OF oin_rec_type
179 INDEX BY BINARY_INTEGER;
180 ---------------------------------------------------------------------------
181 -- GLOBAL MESSAGE CONSTANTS
182 ---------------------------------------------------------------------------
183 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
184 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
185 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
186 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
187 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
188 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
189 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
190 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
191 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
192 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
193 --G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
194 --G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
195 --G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
196
197 ---------------------------------------------------------------------------
198 -- GLOBAL EXCEPTIONS
199 ---------------------------------------------------------------------------
200 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
201
202 ---------------------------------------------------------------------------
203 -- GLOBAL VARIABLES
204 ---------------------------------------------------------------------------
205 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_OIN_PVT';
206 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
207 -------------------------------------------------------------------------------
208 --Post change to TAPI code
209 -------------------------------------------------------------------------------
210 --G_EXCEPTION_HALT_VALIDATION EXCEPTION;
211 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
212 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
213 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
214 g_no_parent_record CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
215 ---------------------------------------------------------------------------
216 ---------------------------------------------------------------------------
217 -- Procedures and Functions
218 ---------------------------------------------------------------------------
219
220 PROCEDURE qc;
221 PROCEDURE change_version;
222 PROCEDURE api_copy;
223 PROCEDURE insert_row(
224 p_api_version IN NUMBER,
225 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_oinv_rec IN oinv_rec_type,
230 x_oinv_rec OUT NOCOPY oinv_rec_type);
231 PROCEDURE insert_row(
232 p_api_version IN NUMBER,
233 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_oinv_tbl IN oinv_tbl_type,
238 x_oinv_tbl OUT NOCOPY oinv_tbl_type,
239 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
240 PROCEDURE insert_row(
241 p_api_version IN NUMBER,
242 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_oinv_tbl IN oinv_tbl_type,
247 x_oinv_tbl OUT NOCOPY oinv_tbl_type);
248 PROCEDURE lock_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_oinv_rec IN oinv_rec_type);
255 PROCEDURE lock_row(
256 p_api_version IN NUMBER,
257 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
258 x_return_status OUT NOCOPY VARCHAR2,
259 x_msg_count OUT NOCOPY NUMBER,
260 x_msg_data OUT NOCOPY VARCHAR2,
261 p_oinv_tbl IN oinv_tbl_type,
262 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
263 PROCEDURE lock_row(
264 p_api_version IN NUMBER,
265 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
266 x_return_status OUT NOCOPY VARCHAR2,
267 x_msg_count OUT NOCOPY NUMBER,
268 x_msg_data OUT NOCOPY VARCHAR2,
269 p_oinv_tbl IN oinv_tbl_type);
270 PROCEDURE update_row(
271 p_api_version IN NUMBER,
272 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
273 x_return_status OUT NOCOPY VARCHAR2,
274 x_msg_count OUT NOCOPY NUMBER,
275 x_msg_data OUT NOCOPY VARCHAR2,
276 p_oinv_rec IN oinv_rec_type,
277 x_oinv_rec OUT NOCOPY oinv_rec_type);
278 PROCEDURE update_row(
279 p_api_version IN NUMBER,
280 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
281 x_return_status OUT NOCOPY VARCHAR2,
282 x_msg_count OUT NOCOPY NUMBER,
283 x_msg_data OUT NOCOPY VARCHAR2,
284 p_oinv_tbl IN oinv_tbl_type,
285 x_oinv_tbl OUT NOCOPY oinv_tbl_type,
286 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
287 PROCEDURE update_row(
288 p_api_version IN NUMBER,
289 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
290 x_return_status OUT NOCOPY VARCHAR2,
291 x_msg_count OUT NOCOPY NUMBER,
292 x_msg_data OUT NOCOPY VARCHAR2,
293 p_oinv_tbl IN oinv_tbl_type,
294 x_oinv_tbl OUT NOCOPY oinv_tbl_type);
295 PROCEDURE delete_row(
296 p_api_version IN NUMBER,
297 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
298 x_return_status OUT NOCOPY VARCHAR2,
299 x_msg_count OUT NOCOPY NUMBER,
300 x_msg_data OUT NOCOPY VARCHAR2,
301 p_oinv_rec IN oinv_rec_type);
302 PROCEDURE delete_row(
303 p_api_version IN NUMBER,
304 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
305 x_return_status OUT NOCOPY VARCHAR2,
306 x_msg_count OUT NOCOPY NUMBER,
307 x_msg_data OUT NOCOPY VARCHAR2,
308 p_oinv_tbl IN oinv_tbl_type,
309 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
310 PROCEDURE delete_row(
311 p_api_version IN NUMBER,
312 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
313 x_return_status OUT NOCOPY VARCHAR2,
314 x_msg_count OUT NOCOPY NUMBER,
315 x_msg_data OUT NOCOPY VARCHAR2,
316 p_oinv_tbl IN oinv_tbl_type);
317 PROCEDURE validate_row(
318 p_api_version IN NUMBER,
319 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
320 x_return_status OUT NOCOPY VARCHAR2,
321 x_msg_count OUT NOCOPY NUMBER,
322 x_msg_data OUT NOCOPY VARCHAR2,
323 p_oinv_rec IN oinv_rec_type);
324 PROCEDURE validate_row(
325 p_api_version IN NUMBER,
326 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
327 x_return_status OUT NOCOPY VARCHAR2,
328 x_msg_count OUT NOCOPY NUMBER,
329 x_msg_data OUT NOCOPY VARCHAR2,
330 p_oinv_tbl IN oinv_tbl_type,
331 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
332 PROCEDURE validate_row(
333 p_api_version IN NUMBER,
334 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
335 x_return_status OUT NOCOPY VARCHAR2,
336 x_msg_count OUT NOCOPY NUMBER,
337 x_msg_data OUT NOCOPY VARCHAR2,
338 p_oinv_tbl IN oinv_tbl_type);
339 END OKL_OIN_PVT;