[Home] [Help]
PACKAGE: APPS.OKL_TRQ_PVT
Source
1 PACKAGE OKL_TRQ_PVT AS
2 /* $Header: OKLSTRQS.pls 120.5 2006/11/16 07:10:08 dkagrawa noship $ */
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL DATASTRUCTURES
6 ---------------------------------------------------------------------------
7 -- OKL_TRX_REQUESTS_V Record Spec
8 TYPE trqv_rec_type IS RECORD (
9 id NUMBER := OKL_API.G_MISS_NUM
10 ,object1_id1 OKL_TRX_REQUESTS.OBJECT1_ID1%TYPE := OKL_API.G_MISS_CHAR
11 ,object1_id2 OKL_TRX_REQUESTS.OBJECT1_ID2%TYPE := OKL_API.G_MISS_CHAR
12 ,jtot_object1_code OKL_TRX_REQUESTS.JTOT_OBJECT1_CODE%TYPE := OKL_API.G_MISS_CHAR
13 ,dnz_khr_id NUMBER := OKL_API.G_MISS_NUM
14 ,request_type_code OKL_TRX_REQUESTS.REQUEST_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
15 ,apply_to_code OKL_TRX_REQUESTS.APPLY_TO_CODE%TYPE := OKL_API.G_MISS_CHAR
16 ,start_date OKL_TRX_REQUESTS.START_DATE%TYPE := OKL_API.G_MISS_DATE
17 ,end_date OKL_TRX_REQUESTS.END_DATE%TYPE := OKL_API.G_MISS_DATE
18 ,term_duration NUMBER := OKL_API.G_MISS_NUM
19 ,AMOUNT NUMBER := OKL_API.G_MISS_NUM
20 ,currency_code OKL_TRX_REQUESTS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
21 ,subsidy_yn OKL_TRX_REQUESTS.SUBSIDY_YN%TYPE := OKL_API.G_MISS_CHAR
22 ,cash_applied_yn OKL_TRX_REQUESTS.CASH_APPLIED_YN%TYPE := OKL_API.G_MISS_CHAR
23 ,object_version_number NUMBER := OKL_API.G_MISS_NUM
24 ,attribute_category OKL_TRX_REQUESTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
25 ,attribute1 OKL_TRX_REQUESTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
26 ,attribute2 OKL_TRX_REQUESTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
27 ,attribute3 OKL_TRX_REQUESTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
28 ,attribute4 OKL_TRX_REQUESTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
29 ,attribute5 OKL_TRX_REQUESTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
30 ,attribute6 OKL_TRX_REQUESTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
31 ,attribute7 OKL_TRX_REQUESTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
32 ,attribute8 OKL_TRX_REQUESTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
33 ,attribute9 OKL_TRX_REQUESTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
34 ,attribute10 OKL_TRX_REQUESTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
35 ,attribute11 OKL_TRX_REQUESTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
36 ,attribute12 OKL_TRX_REQUESTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
37 ,attribute13 OKL_TRX_REQUESTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
38 ,attribute14 OKL_TRX_REQUESTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
39 ,attribute15 OKL_TRX_REQUESTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
40 ,org_id NUMBER := OKL_API.G_MISS_NUM
41 ,request_id NUMBER := OKL_API.G_MISS_NUM
42 ,program_application_id NUMBER := OKL_API.G_MISS_NUM
43 ,program_id NUMBER := OKL_API.G_MISS_NUM
44 ,program_update_date OKL_TRX_REQUESTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
45 ,created_by NUMBER := OKL_API.G_MISS_NUM
46 ,creation_date OKL_TRX_REQUESTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
47 ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
48 ,last_update_date OKL_TRX_REQUESTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
49 ,last_update_login NUMBER := OKL_API.G_MISS_NUM
50 ,minimum_rate NUMBER := OKL_API.G_MISS_NUM
51 ,maximum_rate NUMBER := OKL_API.G_MISS_NUM
52 ,tolerance NUMBER := OKL_API.G_MISS_NUM
53 ,adjustment_frequency_code OKL_TRX_REQUESTS.ADJUSTMENT_FREQUENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
54 ,base_rate NUMBER := OKL_API.G_MISS_NUM
55 ,index_name OKL_TRX_REQUESTS.INDEX_NAME%TYPE := OKL_API.G_MISS_CHAR
56 ,variable_method_code OKL_TRX_REQUESTS.VARIABLE_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR
57 ,adder NUMBER := OKL_API.G_MISS_NUM
58 ,days_in_year OKL_TRX_REQUESTS.DAYS_IN_YEAR%TYPE := OKL_API.G_MISS_CHAR
59 ,days_in_month OKL_TRX_REQUESTS.DAYS_IN_MONTH%TYPE := OKL_API.G_MISS_CHAR
60 ,interest_method_code OKL_TRX_REQUESTS.INTEREST_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR
61 ,interest_start_date OKL_TRX_REQUESTS.INTEREST_START_DATE%TYPE := OKL_API.G_MISS_DATE
62 ,method_of_calculation_code OKL_TRX_REQUESTS.METHOD_OF_CALCULATION_CODE%TYPE := OKL_API.G_MISS_CHAR
63 ,request_number OKL_TRX_REQUESTS.REQUEST_NUMBER%TYPE := OKL_API.G_MISS_CHAR
64 ,date_of_conversion OKL_TRX_REQUESTS.DATE_OF_CONVERSION%TYPE := OKL_API.G_MISS_DATE
65 ,variable_rate_yn OKL_TRX_REQUESTS.VARIABLE_RATE_YN%TYPE := OKL_API.G_MISS_CHAR
66 ,request_status_code OKL_TRX_REQUESTS.REQUEST_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
67 ,yield NUMBER := OKL_API.G_MISS_NUM
68 ,residual NUMBER := OKL_API.G_MISS_NUM
69 ,comments OKL_TRX_REQUESTS.COMMENTS%TYPE := OKL_API.G_MISS_CHAR
70 ,payment_frequency_code OKL_TRX_REQUESTS.PAYMENT_FREQUENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
71 ,restructure_date OKL_TRX_REQUESTS.RESTRUCTURE_DATE%TYPE := OKL_API.G_MISS_DATE
72 ,past_due_yn OKL_TRX_REQUESTS.PAST_DUE_YN%TYPE := OKL_API.G_MISS_CHAR
73 ,request_reason_code OKL_TRX_REQUESTS.REQUEST_REASON_CODE%TYPE := OKL_API.G_MISS_CHAR
74 ,parent_khr_id NUMBER := OKL_API.G_MISS_NUM
75 ,yield_type OKL_TRX_REQUESTS.YIELD_TYPE%TYPE := OKL_API.G_MISS_CHAR
76 ,payment_amount NUMBER := OKL_API.G_MISS_NUM
77 ,payment_date OKL_TRX_REQUESTS.PAYMENT_DATE%TYPE := OKL_API.G_MISS_DATE
78 ,paydown_type OKL_TRX_REQUESTS.PAYDOWN_TYPE%TYPE := OKL_API.G_MISS_CHAR
79 ,currency_conversion_type OKL_TRX_REQUESTS.currency_conversion_type%TYPE := OKL_API.G_MISS_CHAR
80 ,currency_conversion_rate NUMBER := OKL_API.G_MISS_NUM
81 ,currency_conversion_date OKL_TRX_REQUESTS.currency_conversion_date%TYPE := OKL_API.G_MISS_DATE
82 ,lsm_id NUMBER := OKL_API.G_MISS_NUM
83 ,receipt_id NUMBER := OKL_API.G_MISS_NUM
84 ,tcn_id NUMBER := OKL_API.G_MISS_NUM
85 ,try_id NUMBER := OKL_API.G_MISS_NUM
86 ,cur_principal_balance NUMBER := OKL_API.G_MISS_NUM
87 ,cur_accum_interest NUMBER := OKL_API.G_MISS_NUM
88 ,legal_entity_id OKL_TRX_REQUESTS.LEGAL_ENTITY_ID%TYPE := OKL_API.G_MISS_NUM);
89
90 G_MISS_trqv_rec trqv_rec_type;
91
92 TYPE trqv_tbl_type IS TABLE OF trqv_rec_type
93 INDEX BY BINARY_INTEGER;
94
95 -- OKL_TRX_REQUESTS Record Spec
96 TYPE trq_rec_type IS RECORD (
97 id NUMBER := OKL_API.G_MISS_NUM
98 ,object1_id1 OKL_TRX_REQUESTS.OBJECT1_ID1%TYPE := OKL_API.G_MISS_CHAR
99 ,object1_id2 OKL_TRX_REQUESTS.OBJECT1_ID2%TYPE := OKL_API.G_MISS_CHAR
100 ,jtot_object1_code OKL_TRX_REQUESTS.JTOT_OBJECT1_CODE%TYPE := OKL_API.G_MISS_CHAR
101 ,dnz_khr_id NUMBER := OKL_API.G_MISS_NUM
102 ,request_type_code OKL_TRX_REQUESTS.REQUEST_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
103 ,apply_to_code OKL_TRX_REQUESTS.APPLY_TO_CODE%TYPE := OKL_API.G_MISS_CHAR
104 ,start_date OKL_TRX_REQUESTS.START_DATE%TYPE := OKL_API.G_MISS_DATE
105 ,end_date OKL_TRX_REQUESTS.END_DATE%TYPE := OKL_API.G_MISS_DATE
106 ,term_duration NUMBER := OKL_API.G_MISS_NUM
107 ,AMOUNT NUMBER := OKL_API.G_MISS_NUM
108 ,currency_code OKL_TRX_REQUESTS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
109 ,subsidy_yn OKL_TRX_REQUESTS.SUBSIDY_YN%TYPE := OKL_API.G_MISS_CHAR
110 ,cash_applied_yn OKL_TRX_REQUESTS.CASH_APPLIED_YN%TYPE := OKL_API.G_MISS_CHAR
111 ,object_version_number NUMBER := OKL_API.G_MISS_NUM
112 ,attribute_category OKL_TRX_REQUESTS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
113 ,attribute1 OKL_TRX_REQUESTS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
114 ,attribute2 OKL_TRX_REQUESTS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
115 ,attribute3 OKL_TRX_REQUESTS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
116 ,attribute4 OKL_TRX_REQUESTS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
117 ,attribute5 OKL_TRX_REQUESTS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
118 ,attribute6 OKL_TRX_REQUESTS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
119 ,attribute7 OKL_TRX_REQUESTS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
120 ,attribute8 OKL_TRX_REQUESTS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
121 ,attribute9 OKL_TRX_REQUESTS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
122 ,attribute10 OKL_TRX_REQUESTS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
123 ,attribute11 OKL_TRX_REQUESTS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
124 ,attribute12 OKL_TRX_REQUESTS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
125 ,attribute13 OKL_TRX_REQUESTS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
126 ,attribute14 OKL_TRX_REQUESTS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
127 ,attribute15 OKL_TRX_REQUESTS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
128 ,org_id NUMBER := OKL_API.G_MISS_NUM
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_TRX_REQUESTS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
133 ,created_by NUMBER := OKL_API.G_MISS_NUM
134 ,creation_date OKL_TRX_REQUESTS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
135 ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
136 ,last_update_date OKL_TRX_REQUESTS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
137 ,last_update_login NUMBER := OKL_API.G_MISS_NUM
138 ,minimum_rate NUMBER := OKL_API.G_MISS_NUM
139 ,maximum_rate NUMBER := OKL_API.G_MISS_NUM
140 ,tolerance NUMBER := OKL_API.G_MISS_NUM
141 ,adjustment_frequency_code OKL_TRX_REQUESTS.ADJUSTMENT_FREQUENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
142 ,base_rate NUMBER := OKL_API.G_MISS_NUM
143 ,index_name OKL_TRX_REQUESTS.INDEX_NAME%TYPE := OKL_API.G_MISS_CHAR
144 ,variable_method_code OKL_TRX_REQUESTS.VARIABLE_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR
145 ,adder NUMBER := OKL_API.G_MISS_NUM
146 ,days_in_year OKL_TRX_REQUESTS.DAYS_IN_YEAR%TYPE := OKL_API.G_MISS_CHAR
147 ,days_in_month OKL_TRX_REQUESTS.DAYS_IN_MONTH%TYPE := OKL_API.G_MISS_CHAR
148 ,interest_method_code OKL_TRX_REQUESTS.INTEREST_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR
149 ,interest_start_date OKL_TRX_REQUESTS.INTEREST_START_DATE%TYPE := OKL_API.G_MISS_DATE
150 ,method_of_calculation_code OKL_TRX_REQUESTS.METHOD_OF_CALCULATION_CODE%TYPE := OKL_API.G_MISS_CHAR
151 ,request_number OKL_TRX_REQUESTS.REQUEST_NUMBER%TYPE := OKL_API.G_MISS_CHAR
152 ,date_of_conversion OKL_TRX_REQUESTS.DATE_OF_CONVERSION%TYPE := OKL_API.G_MISS_DATE
153 ,variable_rate_yn OKL_TRX_REQUESTS.VARIABLE_RATE_YN%TYPE := OKL_API.G_MISS_CHAR
154 ,request_status_code OKL_TRX_REQUESTS.REQUEST_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
155 ,yield NUMBER := OKL_API.G_MISS_NUM
156 ,residual NUMBER := OKL_API.G_MISS_NUM
157 ,comments OKL_TRX_REQUESTS.COMMENTS%TYPE := OKL_API.G_MISS_CHAR
158 ,payment_frequency_code OKL_TRX_REQUESTS.PAYMENT_FREQUENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
159 ,restructure_date OKL_TRX_REQUESTS.RESTRUCTURE_DATE%TYPE := OKL_API.G_MISS_DATE
160 ,past_due_yn OKL_TRX_REQUESTS.PAST_DUE_YN%TYPE := OKL_API.G_MISS_CHAR
161 ,request_reason_code OKL_TRX_REQUESTS.REQUEST_REASON_CODE%TYPE := OKL_API.G_MISS_CHAR
162 ,parent_khr_id NUMBER := OKL_API.G_MISS_NUM
163 ,yield_type OKL_TRX_REQUESTS.YIELD_TYPE%TYPE := OKL_API.G_MISS_CHAR
164 ,payment_amount NUMBER := OKL_API.G_MISS_NUM
165 ,payment_date OKL_TRX_REQUESTS.PAYMENT_DATE%TYPE := OKL_API.G_MISS_DATE
166 ,paydown_type OKL_TRX_REQUESTS.PAYDOWN_TYPE%TYPE := OKL_API.G_MISS_CHAR
167 ,currency_conversion_type OKL_TRX_REQUESTS.currency_conversion_type%TYPE := OKL_API.G_MISS_CHAR
168 ,currency_conversion_rate NUMBER := OKL_API.G_MISS_NUM
169 ,currency_conversion_date OKL_TRX_REQUESTS.currency_conversion_date%TYPE := OKL_API.G_MISS_DATE
170 ,lsm_id NUMBER := OKL_API.G_MISS_NUM
171 ,receipt_id NUMBER := OKL_API.G_MISS_NUM
172 ,tcn_id NUMBER := OKL_API.G_MISS_NUM
173 ,try_id NUMBER := OKL_API.G_MISS_NUM
174 ,cur_principal_balance NUMBER := OKL_API.G_MISS_NUM
175 ,cur_accum_interest NUMBER := OKL_API.G_MISS_NUM
176 ,legal_entity_id OKL_TRX_REQUESTS.LEGAL_ENTITY_ID%TYPE := OKL_API.G_MISS_NUM);
177
178 G_MISS_trq_rec trq_rec_type;
179 TYPE trq_tbl_type IS TABLE OF trq_rec_type
180 INDEX BY BINARY_INTEGER;
181 ---------------------------------------------------------------------------
182 -- GLOBAL MESSAGE CONSTANTS
183 ---------------------------------------------------------------------------
184 G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
185 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
186 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
187 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
188 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
189 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
190 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
191 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
192 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
193 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
194 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
195 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
196 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
197
198 ---------------------------------------------------------------------------
199 -- GLOBAL EXCEPTIONS
200 ---------------------------------------------------------------------------
201 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
202
203 ---------------------------------------------------------------------------
204 -- GLOBAL VARIABLES
205 ---------------------------------------------------------------------------
206 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_TRQ_PVT';
207 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
208 ---------------------------------------------------------------------------
209 -- Procedures and Functions
210 ---------------------------------------------------------------------------
211
212 PROCEDURE qc;
213 PROCEDURE change_version;
214 PROCEDURE api_copy;
215 PROCEDURE insert_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_trqv_rec IN trqv_rec_type,
222 x_trqv_rec OUT NOCOPY trqv_rec_type);
223 PROCEDURE insert_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_trqv_tbl IN trqv_tbl_type,
230 x_trqv_tbl OUT NOCOPY trqv_tbl_type,
231 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
232 PROCEDURE insert_row(
233 p_api_version IN NUMBER,
234 p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_trqv_tbl IN trqv_tbl_type,
239 x_trqv_tbl OUT NOCOPY trqv_tbl_type);
240 PROCEDURE lock_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_trqv_rec IN trqv_rec_type);
247 PROCEDURE lock_row(
248 p_api_version IN NUMBER,
249 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
250 x_return_status OUT NOCOPY VARCHAR2,
251 x_msg_count OUT NOCOPY NUMBER,
252 x_msg_data OUT NOCOPY VARCHAR2,
253 p_trqv_tbl IN trqv_tbl_type,
254 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
255 PROCEDURE lock_row(
256 p_api_version IN NUMBER,
257 p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_trqv_tbl IN trqv_tbl_type);
262 PROCEDURE update_row(
263 p_api_version IN NUMBER,
264 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
265 x_return_status OUT NOCOPY VARCHAR2,
266 x_msg_count OUT NOCOPY NUMBER,
267 x_msg_data OUT NOCOPY VARCHAR2,
268 p_trqv_rec IN trqv_rec_type,
269 x_trqv_rec OUT NOCOPY trqv_rec_type);
270 PROCEDURE update_row(
271 p_api_version IN NUMBER,
272 p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_trqv_tbl IN trqv_tbl_type,
277 x_trqv_tbl OUT NOCOPY trqv_tbl_type,
278 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
279 PROCEDURE update_row(
280 p_api_version IN NUMBER,
281 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
282 x_return_status OUT NOCOPY VARCHAR2,
283 x_msg_count OUT NOCOPY NUMBER,
284 x_msg_data OUT NOCOPY VARCHAR2,
285 p_trqv_tbl IN trqv_tbl_type,
286 x_trqv_tbl OUT NOCOPY trqv_tbl_type);
287 PROCEDURE delete_row(
288 p_api_version IN NUMBER,
289 p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_trqv_rec IN trqv_rec_type);
294 PROCEDURE delete_row(
295 p_api_version IN NUMBER,
296 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
297 x_return_status OUT NOCOPY VARCHAR2,
298 x_msg_count OUT NOCOPY NUMBER,
299 x_msg_data OUT NOCOPY VARCHAR2,
300 p_trqv_tbl IN trqv_tbl_type,
301 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
302 PROCEDURE delete_row(
303 p_api_version IN NUMBER,
304 p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_trqv_tbl IN trqv_tbl_type);
309 PROCEDURE validate_row(
310 p_api_version IN NUMBER,
311 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
312 x_return_status OUT NOCOPY VARCHAR2,
313 x_msg_count OUT NOCOPY NUMBER,
314 x_msg_data OUT NOCOPY VARCHAR2,
315 p_trqv_rec IN trqv_rec_type);
316 PROCEDURE validate_row(
317 p_api_version IN NUMBER,
318 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
319 x_return_status OUT NOCOPY VARCHAR2,
320 x_msg_count OUT NOCOPY NUMBER,
321 x_msg_data OUT NOCOPY VARCHAR2,
322 p_trqv_tbl IN trqv_tbl_type,
323 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
324 PROCEDURE validate_row(
325 p_api_version IN NUMBER,
326 p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_trqv_tbl IN trqv_tbl_type);
331 END OKL_TRQ_PVT;