[Home] [Help]
PACKAGE: APPS.OKL_TAI_PVT
Source
1 PACKAGE Okl_Tai_Pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLSTAIS.pls 120.7 2007/11/06 07:30:20 dcshanmu noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE tai_rec_type IS RECORD (
7 id NUMBER := Okl_Api.G_MISS_NUM,
8 currency_code OKL_TRX_AR_INVOICES_B.CURRENCY_CODE%TYPE := Okl_Api.G_MISS_CHAR,
9 currency_conversion_type OKL_TRX_AR_INVOICES_B.currency_conversion_type%TYPE := Okl_Api.G_MISS_CHAR,
10 currency_conversion_rate OKL_TRX_AR_INVOICES_B.currency_conversion_rate%TYPE := Okl_Api.G_MISS_NUM,
11 currency_conversion_date OKL_TRX_AR_INVOICES_B.currency_conversion_date%TYPE := Okl_Api.G_MISS_DATE,
12 ibt_id NUMBER := Okl_Api.G_MISS_NUM,
13 ixx_id NUMBER := Okl_Api.G_MISS_NUM,
14 khr_id NUMBER := Okl_Api.G_MISS_NUM,
15 irm_id NUMBER := Okl_Api.G_MISS_NUM,
16 irt_id NUMBER := Okl_Api.G_MISS_NUM,
17 cra_id NUMBER := Okl_Api.G_MISS_NUM,
18 svf_id NUMBER := Okl_Api.G_MISS_NUM,
19 tap_id NUMBER := Okl_Api.G_MISS_NUM,
20 qte_id NUMBER := Okl_Api.G_MISS_NUM,
21 tcn_id NUMBER := Okl_Api.G_MISS_NUM,
22 tai_id_reverses NUMBER := Okl_Api.G_MISS_NUM,
23 ipy_id NUMBER := Okl_Api.G_MISS_NUM, --Added after postgen changes
24 trx_status_code OKL_TRX_AR_INVOICES_B.TRX_STATUS_CODE%TYPE := Okl_Api.G_MISS_CHAR,
25 set_of_books_id NUMBER := Okl_Api.G_MISS_NUM, --Added after postgen changes
26 try_id NUMBER := Okl_Api.G_MISS_NUM, --Added after postgen changes
27 date_entered OKL_TRX_AR_INVOICES_B.DATE_ENTERED%TYPE := Okl_Api.G_MISS_DATE,
28 date_invoiced OKL_TRX_AR_INVOICES_B.DATE_INVOICED%TYPE := Okl_Api.G_MISS_DATE,
29 amount NUMBER := Okl_Api.G_MISS_NUM,
30 object_version_number NUMBER := Okl_Api.G_MISS_NUM,
31 amount_applied NUMBER := Okl_Api.G_MISS_NUM,
32 request_id NUMBER := Okl_Api.G_MISS_NUM,
33 program_application_id NUMBER := Okl_Api.G_MISS_NUM,
34 program_id NUMBER := Okl_Api.G_MISS_NUM,
35 program_update_date OKL_TRX_AR_INVOICES_B.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
36 org_id NUMBER := Okl_Api.G_MISS_NUM,
37 TRX_NUMBER OKL_TRX_AR_INVOICES_B.TRX_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
38 CLG_ID NUMBER := Okl_Api.G_MISS_NUM,
39 POX_ID NUMBER := Okl_Api.G_MISS_NUM,
40 CPY_ID NUMBER := Okl_Api.G_MISS_NUM,
41 attribute_category OKL_TRX_AR_INVOICES_B.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
42 attribute1 OKL_TRX_AR_INVOICES_B.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
43 attribute2 OKL_TRX_AR_INVOICES_B.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
44 attribute3 OKL_TRX_AR_INVOICES_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
45 attribute4 OKL_TRX_AR_INVOICES_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
46 attribute5 OKL_TRX_AR_INVOICES_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
47 attribute6 OKL_TRX_AR_INVOICES_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
48 attribute7 OKL_TRX_AR_INVOICES_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
49 attribute8 OKL_TRX_AR_INVOICES_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
50 attribute9 OKL_TRX_AR_INVOICES_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
51 attribute10 OKL_TRX_AR_INVOICES_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
52 attribute11 OKL_TRX_AR_INVOICES_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
53 attribute12 OKL_TRX_AR_INVOICES_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
54 attribute13 OKL_TRX_AR_INVOICES_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
55 attribute14 OKL_TRX_AR_INVOICES_B.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
56 attribute15 OKL_TRX_AR_INVOICES_B.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
57 created_by NUMBER := Okl_Api.G_MISS_NUM,
58 creation_date OKL_TRX_AR_INVOICES_B.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
59 last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
60 last_update_date OKL_TRX_AR_INVOICES_B.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
61 last_update_login NUMBER := Okl_Api.G_MISS_NUM,
62 legal_entity_id OKL_TRX_AR_INVOICES_B.LEGAL_ENTITY_ID%TYPE := Okl_Api.G_MISS_NUM, -- for LE Uptake project 08-11-2006
63
64
65 -- start:30-Jan-07 cklee Billing R12 project
66 Investor_Agreement_Number OKL_TRX_AR_INVOICES_B.Investor_Agreement_Number%TYPE := Okl_Api.G_MISS_CHAR,
67 Investor_Name OKL_TRX_AR_INVOICES_B.Investor_Name%TYPE := Okl_Api.G_MISS_CHAR,
68 OKL_SOURCE_BILLING_TRX OKL_TRX_AR_INVOICES_B.OKL_SOURCE_BILLING_TRX%TYPE := Okl_Api.G_MISS_CHAR,
69 INF_ID OKL_TRX_AR_INVOICES_B.INF_ID%TYPE := Okl_Api.G_MISS_NUM,
70 INVOICE_PULL_YN OKL_TRX_AR_INVOICES_B.INVOICE_PULL_YN%TYPE := Okl_Api.G_MISS_CHAR,
71 CONSOLIDATED_INVOICE_NUMBER OKL_TRX_AR_INVOICES_B.CONSOLIDATED_INVOICE_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
72 DUE_DATE OKL_TRX_AR_INVOICES_B.DUE_DATE%TYPE := Okl_Api.G_MISS_DATE,
73 ISI_ID OKL_TRX_AR_INVOICES_B.ISI_ID%TYPE := Okl_Api.G_MISS_NUM,
74 RECEIVABLES_INVOICE_ID OKL_TRX_AR_INVOICES_B.RECEIVABLES_INVOICE_ID%TYPE := Okl_Api.G_MISS_NUM,
75 --start: 26-02-07 gkhuntet Insufficient assignment.
76 CUST_TRX_TYPE_ID NUMBER := Okl_Api.G_MISS_NUM,
77 CUSTOMER_BANK_ACCOUNT_ID NUMBER := Okl_Api.G_MISS_NUM,
78 --end: 26-02-07 gkhuntet
79 TAX_EXEMPT_FLAG OKL_TRX_AR_INVOICES_B.TAX_EXEMPT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
80 TAX_EXEMPT_REASON_CODE OKL_TRX_AR_INVOICES_B.TAX_EXEMPT_REASON_CODE%TYPE := Okl_Api.G_MISS_CHAR,
81 --start: 26-02-07 gkhuntet Insufficient assignment.
82 REFERENCE_LINE_ID NUMBER := Okl_Api.G_MISS_NUM,
83
84 PRIVATE_LABEL OKL_TRX_AR_INVOICES_B.PRIVATE_LABEL%TYPE := Okl_Api.G_MISS_CHAR,
85 --end: 26-02-07 gkhuntet
86 -- end: 30-Jan-07 cklee Billing R12 project
87 --gkhuntet start 02-Nov-07
88 TRANSACTION_DATE OKL_TRX_AR_INVOICES_B.TRANSACTION_DATE%TYPE := Okl_Api.G_MISS_DATE
89 --gkhuntet end 02-Nov-07
90 );
91 g_miss_tai_rec tai_rec_type;
92 TYPE tai_tbl_type IS TABLE OF tai_rec_type
93 INDEX BY BINARY_INTEGER;
94 TYPE OklTrxArInvoicesTlRecType IS RECORD (
95 id NUMBER := Okl_Api.G_MISS_NUM,
96 LANGUAGE OKL_TRX_AR_INVOICES_TL.LANGUAGE%TYPE := Okl_Api.G_MISS_CHAR,
97 source_lang OKL_TRX_AR_INVOICES_TL.SOURCE_LANG%TYPE := Okl_Api.G_MISS_CHAR,
98 sfwt_flag OKL_TRX_AR_INVOICES_TL.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
99 description OKL_TRX_AR_INVOICES_TL.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
100 created_by NUMBER := Okl_Api.G_MISS_NUM,
101 creation_date OKL_TRX_AR_INVOICES_TL.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
102 last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
103 last_update_date OKL_TRX_AR_INVOICES_TL.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
104 last_update_login NUMBER := Okl_Api.G_MISS_NUM);
105 GMissOklTrxArInvoicesTlRec OklTrxArInvoicesTlRecType;
106 TYPE OklTrxArInvoicesTlTblType IS TABLE OF OklTrxArInvoicesTlRecType
107 INDEX BY BINARY_INTEGER;
108 TYPE taiv_rec_type IS RECORD (
109 id NUMBER := Okl_Api.G_MISS_NUM,
110 object_version_number NUMBER := Okl_Api.G_MISS_NUM,
111 sfwt_flag OKL_TRX_AR_INVOICES_V.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
112 currency_code OKL_TRX_AR_INVOICES_V.CURRENCY_CODE%TYPE := Okl_Api.G_MISS_CHAR,
113 currency_conversion_type OKL_TRX_AR_INVOICES_B.currency_conversion_type%TYPE := Okl_Api.G_MISS_CHAR,
114 currency_conversion_rate OKL_TRX_AR_INVOICES_B.currency_conversion_rate%TYPE := Okl_Api.G_MISS_NUM,
115 currency_conversion_date OKL_TRX_AR_INVOICES_B.currency_conversion_date%TYPE := Okl_Api.G_MISS_DATE,
116 khr_id NUMBER := Okl_Api.G_MISS_NUM,
117 cra_id NUMBER := Okl_Api.G_MISS_NUM,
118 tap_id NUMBER := Okl_Api.G_MISS_NUM,
119 qte_id NUMBER := Okl_Api.G_MISS_NUM,
120 tcn_id NUMBER := Okl_Api.G_MISS_NUM,
121 tai_id_reverses NUMBER := Okl_Api.G_MISS_NUM,
122 ipy_id NUMBER := Okl_Api.G_MISS_NUM,
123 trx_status_code OKL_TRX_AR_INVOICES_B.TRX_STATUS_CODE%TYPE := Okl_Api.G_MISS_CHAR,
124 set_of_books_id NUMBER := Okl_Api.G_MISS_NUM, --Added after postgen changes
125 try_id NUMBER := Okl_Api.G_MISS_NUM, --Added after postgen changes
126 ibt_id NUMBER := Okl_Api.G_MISS_NUM,
127 ixx_id NUMBER := Okl_Api.G_MISS_NUM,
128 irm_id NUMBER := Okl_Api.G_MISS_NUM,
129 irt_id NUMBER := Okl_Api.G_MISS_NUM,
130 svf_id NUMBER := Okl_Api.G_MISS_NUM,
131 amount NUMBER := Okl_Api.G_MISS_NUM,
132 date_invoiced OKL_TRX_AR_INVOICES_V.DATE_INVOICED%TYPE := Okl_Api.G_MISS_DATE,
133 amount_applied NUMBER := Okl_Api.G_MISS_NUM,
134 description OKL_TRX_AR_INVOICES_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
135 TRX_NUMBER OKL_TRX_AR_INVOICES_B.TRX_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
136 CLG_ID NUMBER := Okl_Api.G_MISS_NUM,
137 POX_ID NUMBER := Okl_Api.G_MISS_NUM,
138 CPY_ID NUMBER := Okl_Api.G_MISS_NUM,
139 attribute_category OKL_TRX_AR_INVOICES_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
140 attribute1 OKL_TRX_AR_INVOICES_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
141 attribute2 OKL_TRX_AR_INVOICES_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
142 attribute3 OKL_TRX_AR_INVOICES_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
143 attribute4 OKL_TRX_AR_INVOICES_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
144 attribute5 OKL_TRX_AR_INVOICES_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
145 attribute6 OKL_TRX_AR_INVOICES_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
146 attribute7 OKL_TRX_AR_INVOICES_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
147 attribute8 OKL_TRX_AR_INVOICES_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
148 attribute9 OKL_TRX_AR_INVOICES_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
149 attribute10 OKL_TRX_AR_INVOICES_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
150 attribute11 OKL_TRX_AR_INVOICES_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
151 attribute12 OKL_TRX_AR_INVOICES_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
152 attribute13 OKL_TRX_AR_INVOICES_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
153 attribute14 OKL_TRX_AR_INVOICES_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
154 attribute15 OKL_TRX_AR_INVOICES_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
155 date_entered OKL_TRX_AR_INVOICES_V.DATE_ENTERED%TYPE := Okl_Api.G_MISS_DATE,
156 request_id NUMBER := Okl_Api.G_MISS_NUM,
157 program_application_id NUMBER := Okl_Api.G_MISS_NUM,
158 program_id NUMBER := Okl_Api.G_MISS_NUM,
159 program_update_date OKL_TRX_AR_INVOICES_V.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
160 org_id NUMBER := Okl_Api.G_MISS_NUM,
161 created_by NUMBER := Okl_Api.G_MISS_NUM,
162 creation_date OKL_TRX_AR_INVOICES_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
163 last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
164 last_update_date OKL_TRX_AR_INVOICES_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
165 last_update_login NUMBER := Okl_Api.G_MISS_NUM,
166 legal_entity_id OKL_TRX_AR_INVOICES_V.LEGAL_ENTITY_ID%TYPE := Okl_Api.G_MISS_NUM, -- for LE Uptake project 08-11-2006
167
168 -- start:30-Jan-07 cklee Billing R12 project
169 Investor_Agreement_Number OKL_TRX_AR_INVOICES_B.Investor_Agreement_Number%TYPE := Okl_Api.G_MISS_CHAR,
170 Investor_Name OKL_TRX_AR_INVOICES_B.Investor_Name%TYPE := Okl_Api.G_MISS_CHAR,
171 OKL_SOURCE_BILLING_TRX OKL_TRX_AR_INVOICES_B.OKL_SOURCE_BILLING_TRX%TYPE := Okl_Api.G_MISS_CHAR,
172 INF_ID OKL_TRX_AR_INVOICES_B.INF_ID%TYPE := Okl_Api.G_MISS_NUM,
173 INVOICE_PULL_YN OKL_TRX_AR_INVOICES_B.INVOICE_PULL_YN%TYPE := Okl_Api.G_MISS_CHAR,
174 DUE_DATE OKL_TRX_AR_INVOICES_B.DUE_DATE%TYPE := Okl_Api.G_MISS_DATE,
175 CONSOLIDATED_INVOICE_NUMBER OKL_TRX_AR_INVOICES_B.CONSOLIDATED_INVOICE_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
176 ISI_ID OKL_TRX_AR_INVOICES_B.ISI_ID%TYPE := Okl_Api.G_MISS_NUM,
177 RECEIVABLES_INVOICE_ID OKL_TRX_AR_INVOICES_B.RECEIVABLES_INVOICE_ID%TYPE := Okl_Api.G_MISS_NUM,
178 --start: 26-02-07 gkhuntet Insufficient assignment.
179 CUST_TRX_TYPE_ID NUMBER := Okl_Api.G_MISS_NUM,
180 CUSTOMER_BANK_ACCOUNT_ID NUMBER := Okl_Api.G_MISS_NUM,
181 --end: 26-02-07 gkhuntet OKL_TRX_AR_INVOICES_B.CUSTOMER_BANK_ACCOUNT_ID%TYPE := Okl_Api.G_MISS_NUM,
182 TAX_EXEMPT_FLAG OKL_TRX_AR_INVOICES_B.TAX_EXEMPT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
183 TAX_EXEMPT_REASON_CODE OKL_TRX_AR_INVOICES_B.TAX_EXEMPT_REASON_CODE%TYPE := Okl_Api.G_MISS_CHAR,
184 --start: 26-02-07 gkhuntet Insufficient assignment.
185 REFERENCE_LINE_ID NUMBER := Okl_Api.G_MISS_NUM,
186 --end: 26-02-07 gkhuntet
187 PRIVATE_LABEL OKL_TRX_AR_INVOICES_B.PRIVATE_LABEL%TYPE := Okl_Api.G_MISS_CHAR,
188 --end: 26-02-07 gkhuntet
189 -- end: 30-Jan-07 cklee Billing R12 project
190 --gkhuntet start 02-Nov-07
191 TRANSACTION_DATE OKL_TRX_AR_INVOICES_B.TRANSACTION_DATE%TYPE := Okl_Api.G_MISS_DATE
192 --gkhuntet end 02-Nov-07
193 );
194
195 g_miss_taiv_rec taiv_rec_type;
196 TYPE taiv_tbl_type IS TABLE OF taiv_rec_type
197 INDEX BY BINARY_INTEGER;
198 ---------------------------------------------------------------------------
199 -- GLOBAL MESSAGE CONSTANTS
200 ---------------------------------------------------------------------------
201 G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
202 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
203 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
204 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
205 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
206 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
207 G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
208 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
209 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
210 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
211 ---------------------------------------------------------------------------
212 -- GLOBAL VARIABLES
213 ---------------------------------------------------------------------------
214 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_TAI_PVT';
215 G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
216
217 /******************ADDED AFTER TAPI, Sunil T. Mathew (04/16/2001) ****************/
218 --GLOBAL MESSAGES
219 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
220 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
221 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
222 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
223 G_NOT_SAME CONSTANT VARCHAR2(200) := 'OKL_CANNOT_BE_SAME';
224
225
226 --GLOBAL VARIABLES
227 G_VIEW CONSTANT VARCHAR2(30) := 'OKL_TRX_AR_INVOICES_V';
228 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
229
230 ---------------------------------------------------------------------------
231 -- validation Procedures and Functions
232 ---------------------------------------------------------------------------
233 --PROCEDURE validate_unique(p_saiv_rec IN saiv_rec_type,
234 -- x_return_status OUT NOCOPY VARCHAR2);
235
236 /****************END ADDED AFTER TAPI, Sunil T. Mathew (04/16/2001)**************/
237
238 ---------------------------------------------------------------------------
239 -- Procedures and Functions
240 ---------------------------------------------------------------------------
241
242 PROCEDURE qc;
243 PROCEDURE change_version;
244 PROCEDURE api_copy;
245 PROCEDURE add_language;
246 PROCEDURE insert_row(
247 p_api_version IN NUMBER,
248 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
249 x_return_status OUT NOCOPY VARCHAR2,
250 x_msg_count OUT NOCOPY NUMBER,
251 x_msg_data OUT NOCOPY VARCHAR2,
252 p_taiv_rec IN taiv_rec_type,
253 x_taiv_rec OUT NOCOPY taiv_rec_type);
254
255 PROCEDURE insert_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_taiv_tbl IN taiv_tbl_type,
262 x_taiv_tbl OUT NOCOPY taiv_tbl_type);
263
264 PROCEDURE lock_row(
265 p_api_version IN NUMBER,
266 p_init_msg_list IN VARCHAR2 DEFAULT Okl_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_taiv_rec IN taiv_rec_type);
271
272 PROCEDURE lock_row(
273 p_api_version IN NUMBER,
274 p_init_msg_list IN VARCHAR2 DEFAULT Okl_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_taiv_tbl IN taiv_tbl_type);
279
280 PROCEDURE update_row(
281 p_api_version IN NUMBER,
282 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
283 x_return_status OUT NOCOPY VARCHAR2,
284 x_msg_count OUT NOCOPY NUMBER,
285 x_msg_data OUT NOCOPY VARCHAR2,
286 p_taiv_rec IN taiv_rec_type,
287 x_taiv_rec OUT NOCOPY taiv_rec_type);
288
289 PROCEDURE update_row(
290 p_api_version IN NUMBER,
291 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
292 x_return_status OUT NOCOPY VARCHAR2,
293 x_msg_count OUT NOCOPY NUMBER,
294 x_msg_data OUT NOCOPY VARCHAR2,
295 p_taiv_tbl IN taiv_tbl_type,
296 x_taiv_tbl OUT NOCOPY taiv_tbl_type);
297
298 PROCEDURE delete_row(
299 p_api_version IN NUMBER,
300 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
301 x_return_status OUT NOCOPY VARCHAR2,
302 x_msg_count OUT NOCOPY NUMBER,
303 x_msg_data OUT NOCOPY VARCHAR2,
304 p_taiv_rec IN taiv_rec_type);
305
306 PROCEDURE delete_row(
307 p_api_version IN NUMBER,
308 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
309 x_return_status OUT NOCOPY VARCHAR2,
310 x_msg_count OUT NOCOPY NUMBER,
311 x_msg_data OUT NOCOPY VARCHAR2,
312 p_taiv_tbl IN taiv_tbl_type);
313
314 PROCEDURE validate_row(
315 p_api_version IN NUMBER,
316 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
317 x_return_status OUT NOCOPY VARCHAR2,
318 x_msg_count OUT NOCOPY NUMBER,
319 x_msg_data OUT NOCOPY VARCHAR2,
320 p_taiv_rec IN taiv_rec_type);
321
322 PROCEDURE validate_row(
323 p_api_version IN NUMBER,
324 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
325 x_return_status OUT NOCOPY VARCHAR2,
326 x_msg_count OUT NOCOPY NUMBER,
327 x_msg_data OUT NOCOPY VARCHAR2,
328 p_taiv_tbl IN taiv_tbl_type);
329
330 END Okl_Tai_Pvt;