[Home] [Help]
PACKAGE: APPS.OKL_TAP_PVT
Source
1 PACKAGE OKL_TAP_PVT AS
2 /* $Header: OKLSTAPS.pls 120.4 2007/11/06 07:39:50 veramach noship $ */
3 ---------------------------------------------------------------------------
4 -- PostGen --
5 -- SPEC:
6 -- 0. Global Messages (5) and Variables (2) = Done!
7 -- 06/01/00: Post postgen changes
8 -- Removed all references to TRX_TYPE. This columns dropped from BD -- Post postgen changes
9 -- Added 3 new columns: TRX_STATUS_CODE, SET_OF_BOOKS_ID, TRY_ID
10 -- Renamed Combo_ID to code_combination_id
11 -- 30-OCT-2006 ANSETHUR R12B - Legal Entity
12 -- Added New column : Legal entity Id
13 -- BODY:
14 -- 1. Check for Not Null Primary Keys
15 -- 2. Check for Not Null Foreign Keys
16 -- 5. Validity of Foreign Keys, where applicable
17 -- 4. Validity of Unique Keys, where applicable
18 -- 3. Validity of Org_id, where applicable
19 -- 6. Added domain validation, where applicable
20 -- 7. Added the Concurrent Manager Columns ( p104 )
21 -- 8. Any lookup code should be validated using the OKL_UTIL package.
22 -- 9. 02/04/02: Added new columns vendor_invoice_number, pay_group_lookup_code,invoice_type, nettable_yn
23 -- 10. Added New column : Legal entity Id : 30-OCT-2006 ANSETHUR R12B - Legal Entity
24
25 ---------------------------------------------------------------------------
26 -- GLOBAL DATASTRUCTURES
27 ---------------------------------------------------------------------------
28 TYPE tap_rec_type IS RECORD (
29 id NUMBER := OKL_API.G_MISS_NUM,
30 currency_code OKL_TRX_AP_INVOICES_B.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR,
31 payment_method_code OKL_TRX_AP_INVOICES_B.PAYMENT_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR,
32 funding_type_code OKL_TRX_AP_INVOICES_B.FUNDING_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR,
33 invoice_category_code OKL_TRX_AP_INVOICES_B.INVOICE_CATEGORY_CODE%TYPE := OKL_API.G_MISS_CHAR,
34 ipvs_id NUMBER := OKL_API.G_MISS_NUM,
35 khr_id NUMBER := OKL_API.G_MISS_NUM,
36 ccf_id NUMBER := OKL_API.G_MISS_NUM,
37 cct_id NUMBER := OKL_API.G_MISS_NUM,
38 cplv_id NUMBER := OKL_API.G_MISS_NUM,
39 pox_id NUMBER := OKL_API.G_MISS_NUM,
40 ippt_id NUMBER := OKL_API.G_MISS_NUM,
41 code_combination_id NUMBER := OKL_API.G_MISS_NUM,
42 qte_id NUMBER := OKL_API.G_MISS_NUM,
43 art_id NUMBER := OKL_API.G_MISS_NUM,
44 tcn_id NUMBER := OKL_API.G_MISS_NUM,
45 vpa_id NUMBER := OKL_API.G_MISS_NUM,
46 ipt_id NUMBER := OKL_API.G_MISS_NUM,
47 tap_id_reverses NUMBER := OKL_API.G_MISS_NUM,
48 date_entered OKL_TRX_AP_INVOICES_B.DATE_ENTERED%TYPE := OKL_API.G_MISS_DATE,
49 date_invoiced OKL_TRX_AP_INVOICES_B.DATE_INVOICED%TYPE := OKL_API.G_MISS_DATE,
50 amount NUMBER := OKL_API.G_MISS_NUM,
51 trx_status_code OKL_TRX_AP_INVOICES_B.TRX_STATUS_CODE%TYPE := Okl_Api.G_MISS_CHAR, -- Post postgen changes
52 set_of_books_id NUMBER := Okl_Api.G_MISS_NUM, -- Post postgen changes
53 try_id NUMBER := OKL_API.G_MISS_NUM, -- Post postgen changes
54 object_version_number NUMBER := OKL_API.G_MISS_NUM,
55 date_requisition OKL_TRX_AP_INVOICES_B.DATE_REQUISITION%TYPE := OKL_API.G_MISS_DATE,
56 date_funding_approved OKL_TRX_AP_INVOICES_B.DATE_FUNDING_APPROVED%TYPE := OKL_API.G_MISS_DATE,
57 invoice_number OKL_TRX_AP_INVOICES_B.INVOICE_NUMBER%TYPE := OKL_API.G_MISS_CHAR,
58 date_gl OKL_TRX_AP_INVOICES_B.DATE_GL%TYPE := OKL_API.G_MISS_DATE,
59 workflow_yn OKL_TRX_AP_INVOICES_B.WORKFLOW_YN%TYPE := OKL_API.G_MISS_CHAR,
60 match_required_yn OKL_TRX_AP_INVOICES_B.MATCH_REQUIRED_YN%TYPE := OKL_API.G_MISS_CHAR,
61 ipt_frequency OKL_TRX_AP_INVOICES_B.IPT_FREQUENCY%TYPE := OKL_API.G_MISS_CHAR,
62 consolidate_yn OKL_TRX_AP_INVOICES_B.CONSOLIDATE_YN%TYPE := OKL_API.G_MISS_CHAR,
63 wait_vendor_invoice_yn OKL_TRX_AP_INVOICES_B.WAIT_VENDOR_INVOICE_YN%TYPE := OKL_API.G_MISS_CHAR,
64 request_id NUMBER := OKL_API.G_MISS_NUM,
65 program_application_id NUMBER := OKL_API.G_MISS_NUM,
66 program_id NUMBER := OKL_API.G_MISS_NUM,
67 program_update_date OKL_TRX_AP_INVOICES_B.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
68 org_id NUMBER := OKL_API.G_MISS_NUM,
69 CURRENCY_CONVERSION_TYPE OKL_TRX_AP_INVOICES_B.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR,
70 CURRENCY_CONVERSION_RATE NUMBER := OKL_API.G_MISS_NUM,
71 CURRENCY_CONVERSION_DATE OKL_TRX_AP_INVOICES_B.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE,
72 vendor_id OKL_TRX_AP_INVOICES_B.vendor_id%TYPE := OKL_API.G_MISS_NUM,
73 attribute_category OKL_TRX_AP_INVOICES_B.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
74 attribute1 OKL_TRX_AP_INVOICES_B.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
75 attribute2 OKL_TRX_AP_INVOICES_B.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
76 attribute3 OKL_TRX_AP_INVOICES_B.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
77 attribute4 OKL_TRX_AP_INVOICES_B.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
78 attribute5 OKL_TRX_AP_INVOICES_B.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
79 attribute6 OKL_TRX_AP_INVOICES_B.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
80 attribute7 OKL_TRX_AP_INVOICES_B.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
81 attribute8 OKL_TRX_AP_INVOICES_B.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
82 attribute9 OKL_TRX_AP_INVOICES_B.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
83 attribute10 OKL_TRX_AP_INVOICES_B.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
84 attribute11 OKL_TRX_AP_INVOICES_B.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
85 attribute12 OKL_TRX_AP_INVOICES_B.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
86 attribute13 OKL_TRX_AP_INVOICES_B.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
87 attribute14 OKL_TRX_AP_INVOICES_B.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
88 attribute15 OKL_TRX_AP_INVOICES_B.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
89 created_by NUMBER := OKL_API.G_MISS_NUM,
90 creation_date OKL_TRX_AP_INVOICES_B.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
91 last_updated_by NUMBER := OKL_API.G_MISS_NUM,
92 last_update_date OKL_TRX_AP_INVOICES_B.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
93 last_update_login NUMBER := OKL_API.G_MISS_NUM,
94 invoice_type OKL_TRX_AP_INVOICES_B.invoice_type%TYPE,
95 pay_group_lookup_code OKL_TRX_AP_INVOICES_B.pay_group_lookup_code%TYPE,
96 vendor_invoice_number OKL_TRX_AP_INVOICES_B.vendor_invoice_number%TYPE,
97 nettable_yn OKL_TRX_AP_INVOICES_B.nettable_yn%TYPE,
98 ASSET_TAP_ID OKL_TRX_AP_INVOICES_B.ASSET_TAP_ID%TYPE := OKL_API.G_MISS_NUM,
99 -- 30-OCT-2006 ANSETHUR R12B - Legal Entity
100 legal_entity_id OKL_TRX_AP_INVOICES_B.legal_entity_id%TYPE := OKL_API.G_MISS_NUM
101 ,transaction_date OKL_TRX_AP_INVOICES_B.transaction_date%TYPE := OKL_API.G_MISS_DATE
102 );
103 g_miss_tap_rec tap_rec_type;
104 TYPE tap_tbl_type IS TABLE OF tap_rec_type
105 INDEX BY BINARY_INTEGER;
106 TYPE OklTrxApInvoicesTlRecType IS RECORD (
107 id NUMBER := OKL_API.G_MISS_NUM,
108 language OKL_TRX_AP_INVOICES_TL.LANGUAGE%TYPE := OKL_API.G_MISS_CHAR,
109 source_lang OKL_TRX_AP_INVOICES_TL.SOURCE_LANG%TYPE := OKL_API.G_MISS_CHAR,
110 sfwt_flag OKL_TRX_AP_INVOICES_TL.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR,
111 description OKL_TRX_AP_INVOICES_TL.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR,
112 created_by NUMBER := OKL_API.G_MISS_NUM,
113 creation_date OKL_TRX_AP_INVOICES_TL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
114 last_updated_by NUMBER := OKL_API.G_MISS_NUM,
115 last_update_date OKL_TRX_AP_INVOICES_TL.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
116 last_update_login NUMBER := OKL_API.G_MISS_NUM);
117 GMissOklTrxApInvoicesTlRec OklTrxApInvoicesTlRecType;
118 TYPE OklTrxApInvoicesTlTblType IS TABLE OF OklTrxApInvoicesTlRecType
119 INDEX BY BINARY_INTEGER;
120 TYPE tapv_rec_type IS RECORD (
121 id NUMBER := OKL_API.G_MISS_NUM,
122 object_version_number NUMBER := OKL_API.G_MISS_NUM,
123 sfwt_flag OKL_TRX_AP_INVOICES_V.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR,
124 cct_id NUMBER := OKL_API.G_MISS_NUM,
125 currency_code OKL_TRX_AP_INVOICES_V.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR,
126 ccf_id NUMBER := OKL_API.G_MISS_NUM,
127 funding_type_code OKL_TRX_AP_INVOICES_V.FUNDING_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR,
128 khr_id NUMBER := OKL_API.G_MISS_NUM,
129 art_id NUMBER := OKL_API.G_MISS_NUM,
130 tap_id_reverses NUMBER := OKL_API.G_MISS_NUM,
131 ippt_id NUMBER := OKL_API.G_MISS_NUM,
132 code_combination_id NUMBER := OKL_API.G_MISS_NUM,
133 ipvs_id NUMBER := OKL_API.G_MISS_NUM,
134 tcn_id NUMBER := OKL_API.G_MISS_NUM,
135 vpa_id NUMBER := OKL_API.G_MISS_NUM,
136 ipt_id NUMBER := OKL_API.G_MISS_NUM,
137 qte_id NUMBER := OKL_API.G_MISS_NUM,
138 invoice_category_code OKL_TRX_AP_INVOICES_V.INVOICE_CATEGORY_CODE%TYPE := OKL_API.G_MISS_CHAR,
139 payment_method_code OKL_TRX_AP_INVOICES_V.PAYMENT_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR,
140 cplv_id NUMBER := OKL_API.G_MISS_NUM,
141 pox_id NUMBER := OKL_API.G_MISS_NUM,
142 amount NUMBER := OKL_API.G_MISS_NUM,
143 date_invoiced OKL_TRX_AP_INVOICES_V.DATE_INVOICED%TYPE := OKL_API.G_MISS_DATE,
144 invoice_number OKL_TRX_AP_INVOICES_V.INVOICE_NUMBER%TYPE := OKL_API.G_MISS_CHAR,
145 date_funding_approved OKL_TRX_AP_INVOICES_V.DATE_FUNDING_APPROVED%TYPE := OKL_API.G_MISS_DATE,
146 date_gl OKL_TRX_AP_INVOICES_V.DATE_GL%TYPE := OKL_API.G_MISS_DATE,
147 workflow_yn OKL_TRX_AP_INVOICES_V.WORKFLOW_YN%TYPE := OKL_API.G_MISS_CHAR,
148 match_required_yn OKL_TRX_AP_INVOICES_B.MATCH_REQUIRED_YN%TYPE := OKL_API.G_MISS_CHAR,
149 ipt_frequency OKL_TRX_AP_INVOICES_B.IPT_FREQUENCY%TYPE := OKL_API.G_MISS_CHAR,
150 consolidate_yn OKL_TRX_AP_INVOICES_V.CONSOLIDATE_YN%TYPE := OKL_API.G_MISS_CHAR,
151 wait_vendor_invoice_yn OKL_TRX_AP_INVOICES_V.WAIT_VENDOR_INVOICE_YN%TYPE := OKL_API.G_MISS_CHAR,
152 date_requisition OKL_TRX_AP_INVOICES_V.DATE_REQUISITION%TYPE := OKL_API.G_MISS_DATE,
153 description OKL_TRX_AP_INVOICES_V.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR,
154 CURRENCY_CONVERSION_TYPE OKL_TRX_AP_INVOICES_B.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR,
155 CURRENCY_CONVERSION_RATE NUMBER := OKL_API.G_MISS_NUM,
156 CURRENCY_CONVERSION_DATE OKL_TRX_AP_INVOICES_B.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE,
157 vendor_id OKL_TRX_AP_INVOICES_B.vendor_id%TYPE := OKL_API.G_MISS_NUM,
158 attribute_category OKL_TRX_AP_INVOICES_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
159 attribute1 OKL_TRX_AP_INVOICES_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
160 attribute2 OKL_TRX_AP_INVOICES_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
161 attribute3 OKL_TRX_AP_INVOICES_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
162 attribute4 OKL_TRX_AP_INVOICES_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
163 attribute5 OKL_TRX_AP_INVOICES_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
164 attribute6 OKL_TRX_AP_INVOICES_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
165 attribute7 OKL_TRX_AP_INVOICES_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
166 attribute8 OKL_TRX_AP_INVOICES_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
167 attribute9 OKL_TRX_AP_INVOICES_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
168 attribute10 OKL_TRX_AP_INVOICES_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
169 attribute11 OKL_TRX_AP_INVOICES_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
170 attribute12 OKL_TRX_AP_INVOICES_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
171 attribute13 OKL_TRX_AP_INVOICES_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
172 attribute14 OKL_TRX_AP_INVOICES_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
173 attribute15 OKL_TRX_AP_INVOICES_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
174 date_entered OKL_TRX_AP_INVOICES_V.DATE_ENTERED%TYPE := OKL_API.G_MISS_DATE,
175 trx_status_code OKL_TRX_AP_INVOICES_V.TRX_STATUS_CODE%TYPE := Okl_Api.G_MISS_CHAR, -- Post postgen changes
176 set_of_books_id NUMBER := Okl_Api.G_MISS_NUM, -- Post postgen changes
177 try_id NUMBER := OKL_API.G_MISS_NUM, -- Post postgen changes
178 request_id NUMBER := OKL_API.G_MISS_NUM,
179 program_application_id NUMBER := OKL_API.G_MISS_NUM,
180 program_id NUMBER := OKL_API.G_MISS_NUM,
181 program_update_date OKL_TRX_AP_INVOICES_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
182 org_id NUMBER := OKL_API.G_MISS_NUM,
183 created_by NUMBER := OKL_API.G_MISS_NUM,
184 creation_date OKL_TRX_AP_INVOICES_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
185 last_updated_by NUMBER := OKL_API.G_MISS_NUM,
186 last_update_date OKL_TRX_AP_INVOICES_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
187 last_update_login NUMBER := OKL_API.G_MISS_NUM,
188 invoice_type OKL_TRX_AP_INVOICES_V.invoice_type%TYPE,
189 pay_group_lookup_code OKL_TRX_AP_INVOICES_V.pay_group_lookup_code%TYPE,
190 vendor_invoice_number OKL_TRX_AP_INVOICES_V.vendor_invoice_number%TYPE,
191 nettable_yn OKL_TRX_AP_INVOICES_B.nettable_yn%TYPE,
192 ASSET_TAP_ID OKL_TRX_AP_INVOICES_V.ASSET_TAP_ID%TYPE := OKL_API.G_MISS_NUM ,
193 -- 30-OCT-2006 ANSETHUR R12B - Legal Entity
194 legal_entity_id OKL_TRX_AP_INVOICES_V.legal_entity_id%TYPE := OKL_API.G_MISS_NUM
195 ,transaction_date OKL_TRX_AP_INVOICES_V.transaction_date%TYPE := OKL_API.G_MISS_DATE);
196 g_miss_tapv_rec tapv_rec_type;
197 TYPE tapv_tbl_type IS TABLE OF tapv_rec_type
198 INDEX BY BINARY_INTEGER;
199 ---------------------------------------------------------------------------
200 -- GLOBAL MESSAGE CONSTANTS
201 ---------------------------------------------------------------------------
202 G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
203 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
204 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
205 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
206 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
207 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
208 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
209 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
210 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
211 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
212 -- PostGen-Begin-0
213 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) :='OKL_UNEXPECTED_ERROR';
214 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) :='OKL_NO_PARENT_RECORD';
215 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) :='ERROR_MESSAGE';
216 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) :='ERROR_CODE';
217 G_NOT_SAME CONSTANT VARCHAR2(200) :='OKL_CANNOT_BE_SAME';
218 -- PostGen-End-0
219 ---------------------------------------------------------------------------
220 -- GLOBAL VARIABLES
221 ---------------------------------------------------------------------------
222 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_TAP_PVT';
223 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
224 -- Post-Gen Begin-0
225 G_VIEW CONSTANT VARCHAR2(30) := 'OKL_TRX_AP_INVOICES_V';
229 -- Procedures and Functions
226 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
227 -- Post-Gen End-0
228 ---------------------------------------------------------------------------
230 ---------------------------------------------------------------------------
231
232 PROCEDURE qc;
233 PROCEDURE change_version;
234 PROCEDURE api_copy;
235 PROCEDURE add_language;
236 PROCEDURE insert_row(
237 p_api_version IN NUMBER,
238 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
239 x_return_status OUT NOCOPY VARCHAR2,
240 x_msg_count OUT NOCOPY NUMBER,
241 x_msg_data OUT NOCOPY VARCHAR2,
242 p_tapv_rec IN tapv_rec_type,
243 x_tapv_rec OUT NOCOPY tapv_rec_type);
244
245 PROCEDURE insert_row(
246 p_api_version IN NUMBER,
247 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
248 x_return_status OUT NOCOPY VARCHAR2,
249 x_msg_count OUT NOCOPY NUMBER,
250 x_msg_data OUT NOCOPY VARCHAR2,
251 p_tapv_tbl IN tapv_tbl_type,
252 x_tapv_tbl OUT NOCOPY tapv_tbl_type);
253
254 PROCEDURE lock_row(
255 p_api_version IN NUMBER,
256 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
257 x_return_status OUT NOCOPY VARCHAR2,
258 x_msg_count OUT NOCOPY NUMBER,
259 x_msg_data OUT NOCOPY VARCHAR2,
260 p_tapv_rec IN tapv_rec_type);
261
262 PROCEDURE lock_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_tapv_tbl IN tapv_tbl_type);
269
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_tapv_rec IN tapv_rec_type,
277 x_tapv_rec OUT NOCOPY tapv_rec_type);
278
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_tapv_tbl IN tapv_tbl_type,
286 x_tapv_tbl OUT NOCOPY tapv_tbl_type);
287
288 PROCEDURE delete_row(
289 p_api_version IN NUMBER,
290 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
291 x_return_status OUT NOCOPY VARCHAR2,
292 x_msg_count OUT NOCOPY NUMBER,
293 x_msg_data OUT NOCOPY VARCHAR2,
294 p_tapv_rec IN tapv_rec_type);
295
296 PROCEDURE delete_row(
297 p_api_version IN NUMBER,
298 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
299 x_return_status OUT NOCOPY VARCHAR2,
300 x_msg_count OUT NOCOPY NUMBER,
301 x_msg_data OUT NOCOPY VARCHAR2,
302 p_tapv_tbl IN tapv_tbl_type);
303
304 PROCEDURE validate_row(
305 p_api_version IN NUMBER,
306 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
307 x_return_status OUT NOCOPY VARCHAR2,
308 x_msg_count OUT NOCOPY NUMBER,
309 x_msg_data OUT NOCOPY VARCHAR2,
310 p_tapv_rec IN tapv_rec_type);
311
312 PROCEDURE validate_row(
313 p_api_version IN NUMBER,
314 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
315 x_return_status OUT NOCOPY VARCHAR2,
316 x_msg_count OUT NOCOPY NUMBER,
317 x_msg_data OUT NOCOPY VARCHAR2,
318 p_tapv_tbl IN tapv_tbl_type);
319
320 END OKL_TAP_PVT;