[Home] [Help]
PACKAGE: APPS.OKL_TLD_PVT
Source
1 PACKAGE Okl_Tld_Pvt AS
2 /* $Header: OKLSTLDS.pls 120.6 2007/03/22 18:21:34 cklee ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE tld_rec_type IS RECORD (
7 id NUMBER := Okl_api.G_MISS_NUM,
8 bch_id NUMBER := Okl_api.G_MISS_NUM,
9 bcl_id NUMBER := Okl_api.G_MISS_NUM,
10 bsl_id NUMBER := Okl_api.G_MISS_NUM,
11 bgh_id NUMBER := Okl_api.G_MISS_NUM,
12 idx_id NUMBER := Okl_api.G_MISS_NUM,
13 sel_id NUMBER := Okl_api.G_MISS_NUM,
14 sty_id NUMBER := Okl_api.G_MISS_NUM,
15 til_id_details NUMBER := Okl_api.G_MISS_NUM,
16 tld_id_reverses NUMBER := Okl_api.G_MISS_NUM,
17 line_detail_number NUMBER := Okl_api.G_MISS_NUM,
18 object_version_number NUMBER := Okl_api.G_MISS_NUM,
19 late_charge_yn OKL_TXD_AR_LN_DTLS_B.LATE_CHARGE_YN%TYPE := Okl_api.G_MISS_CHAR,
20 date_calculation OKL_TXD_AR_LN_DTLS_B.DATE_CALCULATION%TYPE := Okl_api.G_MISS_DATE,
21 fixed_rate_yn OKL_TXD_AR_LN_DTLS_B.FIXED_RATE_YN%TYPE := Okl_api.G_MISS_CHAR,
22 amount NUMBER := Okl_api.G_MISS_NUM,
23 receivables_invoice_id NUMBER := Okl_api.G_MISS_NUM,
24 amount_applied NUMBER := Okl_api.G_MISS_NUM,
25 request_id NUMBER := Okl_api.G_MISS_NUM,
26 program_application_id NUMBER := Okl_api.G_MISS_NUM,
27 program_id NUMBER := Okl_api.G_MISS_NUM,
28 program_update_date OKL_TXD_AR_LN_DTLS_B.PROGRAM_UPDATE_DATE%TYPE := Okl_api.G_MISS_DATE,
29 org_id NUMBER := Okl_api.G_MISS_NUM,
30 inventory_org_id NUMBER := Okl_Api.G_MISS_NUM,
31 -- Start changes on remarketing by fmiao on 10/18/04 --
32 inventory_item_id NUMBER := Okl_api.G_MISS_NUM,
33 -- End changes on remarketing by fmiao on 10/18/04 --
34 attribute_category OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE_CATEGORY%TYPE := Okl_api.G_MISS_CHAR,
35 attribute1 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE1%TYPE := Okl_api.G_MISS_CHAR,
36 attribute2 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE2%TYPE := Okl_api.G_MISS_CHAR,
37 attribute3 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE3%TYPE := Okl_api.G_MISS_CHAR,
38 attribute4 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE4%TYPE := Okl_api.G_MISS_CHAR,
39 attribute5 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE5%TYPE := Okl_api.G_MISS_CHAR,
40 attribute6 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE6%TYPE := Okl_api.G_MISS_CHAR,
41 attribute7 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE7%TYPE := Okl_api.G_MISS_CHAR,
42 attribute8 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE8%TYPE := Okl_api.G_MISS_CHAR,
43 attribute9 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE9%TYPE := Okl_api.G_MISS_CHAR,
44 attribute10 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE10%TYPE := Okl_api.G_MISS_CHAR,
45 attribute11 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE11%TYPE := Okl_api.G_MISS_CHAR,
46 attribute12 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE12%TYPE := Okl_api.G_MISS_CHAR,
47 attribute13 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE13%TYPE := Okl_api.G_MISS_CHAR,
48 attribute14 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE14%TYPE := Okl_api.G_MISS_CHAR,
49 attribute15 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE15%TYPE := Okl_api.G_MISS_CHAR,
50 created_by NUMBER := Okl_api.G_MISS_NUM,
51 creation_date OKL_TXD_AR_LN_DTLS_B.CREATION_DATE%TYPE := Okl_api.G_MISS_DATE,
52 last_updated_by NUMBER := Okl_api.G_MISS_NUM,
53 last_update_date OKL_TXD_AR_LN_DTLS_B.LAST_UPDATE_DATE%TYPE := Okl_api.G_MISS_DATE,
54 last_update_login NUMBER := Okl_api.G_MISS_NUM,
55
56 --start: 30-Jan-07 cklee Billing R12 project |
57 TXL_AR_LINE_NUMBER OKL_TXD_AR_LN_DTLS_B.TXL_AR_LINE_NUMBER%TYPE := Okl_api.G_MISS_NUM,
58 INVOICE_FORMAT_TYPE OKL_TXD_AR_LN_DTLS_B.INVOICE_FORMAT_TYPE%TYPE := Okl_api.G_MISS_CHAR,
59 INVOICE_FORMAT_LINE_TYPE OKL_TXD_AR_LN_DTLS_B.INVOICE_FORMAT_LINE_TYPE%TYPE := Okl_api.G_MISS_CHAR,
60 LATE_CHARGE_ASSESS_DATE OKL_TXD_AR_LN_DTLS_B.LATE_CHARGE_ASSESS_DATE%TYPE := Okl_api.G_MISS_DATE,
61 --start: 26-02-07 gkhuntet Invalid assignment.
62 LATE_INT_ASSESS_DATE OKL_TXD_AR_LN_DTLS_B.LATE_INT_ASSESS_DATE%TYPE := Okl_api.G_MISS_DATE,
63 --end: 26-02-07 gkhuntet
64 LATE_CHARGE_ASS_YN OKL_TXD_AR_LN_DTLS_B.LATE_CHARGE_ASS_YN%TYPE := Okl_api.G_MISS_CHAR,
65 LATE_INT_ASS_YN OKL_TXD_AR_LN_DTLS_B.LATE_INT_ASS_YN%TYPE := Okl_api.G_MISS_CHAR,
66 INVESTOR_DISB_STATUS OKL_TXD_AR_LN_DTLS_B.INVESTOR_DISB_STATUS%TYPE := Okl_api.G_MISS_CHAR,
67 INVESTOR_DISB_ERR_MG OKL_TXD_AR_LN_DTLS_B.INVESTOR_DISB_ERR_MG%TYPE := Okl_api.G_MISS_CHAR,
68 DATE_DISBURSED OKL_TXD_AR_LN_DTLS_B.DATE_DISBURSED%TYPE := Okl_api.G_MISS_DATE,
69 PAY_STATUS_CODE OKL_TXD_AR_LN_DTLS_B.PAY_STATUS_CODE%TYPE := Okl_api.G_MISS_CHAR,
70 RBK_ORI_INVOICE_NUMBER OKL_TXD_AR_LN_DTLS_B.RBK_ORI_INVOICE_NUMBER%TYPE := Okl_api.G_MISS_CHAR,
71 RBK_ORI_INVOICE_LINE_NUMBER OKL_TXD_AR_LN_DTLS_B.RBK_ORI_INVOICE_LINE_NUMBER%TYPE := Okl_api.G_MISS_CHAR,
72 RBK_ADJUSTMENT_DATE OKL_TXD_AR_LN_DTLS_B.RBK_ADJUSTMENT_DATE%TYPE := Okl_api.G_MISS_DATE,
73 --start: 26-02-07 gkhuntet Invalid assignment.
74 --KHR_ID OKL_TXD_AR_LN_DTLS_B.KHR_ID%TYPE := Okl_api.G_MISS_CHAR,
75 KHR_ID OKL_TXD_AR_LN_DTLS_B.KHR_ID%TYPE := Okl_api.G_MISS_NUM,
76 KLE_ID OKL_TXD_AR_LN_DTLS_B.KLE_ID%TYPE := Okl_api.G_MISS_NUM,
77 TAX_AMOUNT NUMBER := Okl_api.G_MISS_NUM
78 --end: 26-02-07 gkhuntet
79 --end: 30-Jan-07 cklee Billing R12 project |
80
81 );
82 g_miss_tld_rec tld_rec_type;
83 TYPE tld_tbl_type IS TABLE OF tld_rec_type
84 INDEX BY BINARY_INTEGER;
85 TYPE okl_txd_ar_ln_dtls_tl_rec_type IS RECORD (
86 id NUMBER := Okl_api.G_MISS_NUM,
87 LANGUAGE OKL_TXD_AR_LN_DTLS_TL.LANGUAGE%TYPE := Okl_api.G_MISS_CHAR,
88 source_lang OKL_TXD_AR_LN_DTLS_TL.SOURCE_LANG%TYPE := Okl_api.G_MISS_CHAR,
89 error_message OKL_TXD_AR_LN_DTLS_TL.ERROR_MESSAGE%TYPE := Okl_api.G_MISS_CHAR,
90 sfwt_flag OKL_TXD_AR_LN_DTLS_TL.SFWT_FLAG%TYPE := Okl_api.G_MISS_CHAR,
91 description OKL_TXD_AR_LN_DTLS_TL.DESCRIPTION%TYPE := Okl_api.G_MISS_CHAR,
92 created_by NUMBER := Okl_api.G_MISS_NUM,
93 creation_date OKL_TXD_AR_LN_DTLS_TL.CREATION_DATE%TYPE := Okl_api.G_MISS_DATE,
94 last_updated_by NUMBER := Okl_api.G_MISS_NUM,
95 last_update_date OKL_TXD_AR_LN_DTLS_TL.LAST_UPDATE_DATE%TYPE := Okl_api.G_MISS_DATE,
96 last_update_login NUMBER := Okl_api.G_MISS_NUM);
97 GMissOklTxdArLnDtlsTlRec okl_txd_ar_ln_dtls_tl_rec_type;
98 TYPE okl_txd_ar_ln_dtls_tl_tbl_type IS TABLE OF okl_txd_ar_ln_dtls_tl_rec_type
99 INDEX BY BINARY_INTEGER;
100 TYPE tldv_rec_type IS RECORD (
101 id NUMBER := Okl_api.G_MISS_NUM,
102 object_version_number NUMBER := Okl_api.G_MISS_NUM,
103 error_message OKL_TXD_AR_LN_DTLS_TL.ERROR_MESSAGE%TYPE := Okl_api.G_MISS_CHAR,
104 sfwt_flag OKL_TXD_AR_LN_DTLS_V.SFWT_FLAG%TYPE := Okl_api.G_MISS_CHAR,
105 bch_id NUMBER := Okl_api.G_MISS_NUM,
106 bgh_id NUMBER := Okl_api.G_MISS_NUM,
107 idx_id NUMBER := Okl_api.G_MISS_NUM,
108 tld_id_reverses NUMBER := Okl_api.G_MISS_NUM,
109 sty_id NUMBER := Okl_api.G_MISS_NUM,
110 sel_id NUMBER := Okl_api.G_MISS_NUM,
111 til_id_details NUMBER := Okl_api.G_MISS_NUM,
112 bcl_id NUMBER := Okl_api.G_MISS_NUM,
113 bsl_id NUMBER := Okl_api.G_MISS_NUM,
114 amount NUMBER := Okl_api.G_MISS_NUM,
115 line_detail_number NUMBER := Okl_api.G_MISS_NUM,
116 receivables_invoice_id NUMBER := Okl_api.G_MISS_NUM,
117 late_charge_yn OKL_TXD_AR_LN_DTLS_V.LATE_CHARGE_YN%TYPE := Okl_api.G_MISS_CHAR,
118 description OKL_TXD_AR_LN_DTLS_V.DESCRIPTION%TYPE := Okl_api.G_MISS_CHAR,
119 amount_applied NUMBER := Okl_api.G_MISS_NUM,
120 date_calculation OKL_TXD_AR_LN_DTLS_V.DATE_CALCULATION%TYPE := Okl_api.G_MISS_DATE,
121 fixed_rate_yn OKL_TXD_AR_LN_DTLS_V.FIXED_RATE_YN%TYPE := Okl_api.G_MISS_CHAR,
122 -- Start changes on remarketing by fmiao on 10/18/04 --
123 inventory_item_id NUMBER := Okl_api.G_MISS_NUM,
124 -- End changes on remarketing by fmiao on 10/18/04 --
125 attribute_category OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_api.G_MISS_CHAR,
126 attribute1 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE1%TYPE := Okl_api.G_MISS_CHAR,
127 attribute2 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE2%TYPE := Okl_api.G_MISS_CHAR,
128 attribute3 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE3%TYPE := Okl_api.G_MISS_CHAR,
129 attribute4 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE4%TYPE := Okl_api.G_MISS_CHAR,
130 attribute5 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE5%TYPE := Okl_api.G_MISS_CHAR,
131 attribute6 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE6%TYPE := Okl_api.G_MISS_CHAR,
132 attribute7 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE7%TYPE := Okl_api.G_MISS_CHAR,
133 attribute8 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE8%TYPE := Okl_api.G_MISS_CHAR,
134 attribute9 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE9%TYPE := Okl_api.G_MISS_CHAR,
135 attribute10 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE10%TYPE := Okl_api.G_MISS_CHAR,
136 attribute11 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE11%TYPE := Okl_api.G_MISS_CHAR,
137 attribute12 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE12%TYPE := Okl_api.G_MISS_CHAR,
138 attribute13 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE13%TYPE := Okl_api.G_MISS_CHAR,
139 attribute14 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE14%TYPE := Okl_api.G_MISS_CHAR,
140 attribute15 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE15%TYPE := Okl_api.G_MISS_CHAR,
141 request_id NUMBER := Okl_api.G_MISS_NUM,
142 program_application_id NUMBER := Okl_api.G_MISS_NUM,
143 program_id NUMBER := Okl_api.G_MISS_NUM,
144 program_update_date OKL_TXD_AR_LN_DTLS_V.PROGRAM_UPDATE_DATE%TYPE := Okl_api.G_MISS_DATE,
145 org_id NUMBER := Okl_api.G_MISS_NUM,
146 inventory_org_id NUMBER := Okl_Api.G_MISS_NUM,
147 created_by NUMBER := Okl_api.G_MISS_NUM,
148 creation_date OKL_TXD_AR_LN_DTLS_V.CREATION_DATE%TYPE := Okl_api.G_MISS_DATE,
149 last_updated_by NUMBER := Okl_api.G_MISS_NUM,
150 last_update_date OKL_TXD_AR_LN_DTLS_V.LAST_UPDATE_DATE%TYPE := Okl_api.G_MISS_DATE,
151 last_update_login NUMBER := Okl_api.G_MISS_NUM,
152
153 --start: 30-Jan-07 cklee Billing R12 project |
154 TXL_AR_LINE_NUMBER OKL_TXD_AR_LN_DTLS_B.TXL_AR_LINE_NUMBER%TYPE := Okl_api.G_MISS_NUM,
155 INVOICE_FORMAT_TYPE OKL_TXD_AR_LN_DTLS_B.INVOICE_FORMAT_TYPE%TYPE := Okl_api.G_MISS_CHAR,
156 INVOICE_FORMAT_LINE_TYPE OKL_TXD_AR_LN_DTLS_B.INVOICE_FORMAT_LINE_TYPE%TYPE := Okl_api.G_MISS_CHAR,
157 LATE_CHARGE_ASSESS_DATE OKL_TXD_AR_LN_DTLS_B.LATE_CHARGE_ASSESS_DATE%TYPE := Okl_api.G_MISS_DATE,
158
159 --start: 26-02-07 gkhuntet Invalid assignment.
160 LATE_INT_ASSESS_DATE OKL_TXD_AR_LN_DTLS_B.LATE_INT_ASSESS_DATE%TYPE := Okl_api.G_MISS_DATE,
161 --end: 26-02-07 gkhuntet
162
163 LATE_CHARGE_ASS_YN OKL_TXD_AR_LN_DTLS_B.LATE_CHARGE_ASS_YN%TYPE := Okl_api.G_MISS_CHAR,
164 LATE_INT_ASS_YN OKL_TXD_AR_LN_DTLS_B.LATE_INT_ASS_YN%TYPE := Okl_api.G_MISS_CHAR,
165 INVESTOR_DISB_STATUS OKL_TXD_AR_LN_DTLS_B.INVESTOR_DISB_STATUS%TYPE := Okl_api.G_MISS_CHAR,
166 INVESTOR_DISB_ERR_MG OKL_TXD_AR_LN_DTLS_B.INVESTOR_DISB_ERR_MG%TYPE := Okl_api.G_MISS_CHAR,
167 DATE_DISBURSED OKL_TXD_AR_LN_DTLS_B.DATE_DISBURSED%TYPE := Okl_api.G_MISS_DATE,
168 PAY_STATUS_CODE OKL_TXD_AR_LN_DTLS_B.PAY_STATUS_CODE%TYPE := Okl_api.G_MISS_CHAR,
169 RBK_ORI_INVOICE_NUMBER OKL_TXD_AR_LN_DTLS_B.RBK_ORI_INVOICE_NUMBER%TYPE := Okl_api.G_MISS_CHAR,
170 RBK_ORI_INVOICE_LINE_NUMBER OKL_TXD_AR_LN_DTLS_B.RBK_ORI_INVOICE_LINE_NUMBER%TYPE := Okl_api.G_MISS_CHAR,
171 RBK_ADJUSTMENT_DATE OKL_TXD_AR_LN_DTLS_B.RBK_ADJUSTMENT_DATE%TYPE := Okl_api.G_MISS_DATE,
172 --start: 26-02-07 gkhuntet Invalid assignment.
173 --KHR_ID OKL_TXD_AR_LN_DTLS_B.KHR_ID%TYPE := Okl_api.G_MISS_CHAR,
174 KHR_ID OKL_TXD_AR_LN_DTLS_B.KHR_ID%TYPE := Okl_api.G_MISS_NUM,
175 KLE_ID OKL_TXD_AR_LN_DTLS_B.KLE_ID%TYPE := Okl_api.G_MISS_NUM,
176 TAX_AMOUNT NUMBER := Okl_api.G_MISS_NUM
177 --end: 26-02-07 gkhuntet
178 --end: 30-Jan-07 cklee Billing R12 project |
179
180 );
181
182 g_miss_tldv_rec tldv_rec_type;
183 TYPE tldv_tbl_type IS TABLE OF tldv_rec_type
184 INDEX BY BINARY_INTEGER;
185 ---------------------------------------------------------------------------
186 -- GLOBAL MESSAGE CONSTANTS
187 ---------------------------------------------------------------------------
188 G_FND_APP CONSTANT VARCHAR2(200) := Okl_api.G_FND_APP;
189 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
190 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_api.G_FORM_RECORD_DELETED;
191 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_api.G_FORM_RECORD_CHANGED;
192 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_api.G_RECORD_LOGICALLY_DELETED;
193 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_api.G_REQUIRED_VALUE;
194 G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_api.G_INVALID_VALUE;
195 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_api.G_COL_NAME_TOKEN;
196 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_api.G_PARENT_TABLE_TOKEN;
197 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_api.G_CHILD_TABLE_TOKEN;
198 ---------------------------------------------------------------------------
199 -- GLOBAL VARIABLES
200 ---------------------------------------------------------------------------
201 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_TLD_PVT';
202 G_APP_NAME CONSTANT VARCHAR2(3) := Okl_api.G_APP_NAME;
203
204 /******************ADDED AFTER TAPI, Sunil T. Mathew (04/16/2001) ****************/
205 --GLOBAL MESSAGES
206 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
207 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
208 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
209 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
210 G_NOT_SAME CONSTANT VARCHAR2(200) := 'OKL_CANNOT_BE_SAME';
211
212
213 --GLOBAL VARIABLES
214 G_VIEW CONSTANT VARCHAR2(30) := 'OKL_TXD_AR_LN_DTLS_V';
215 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
216
217 ---------------------------------------------------------------------------
218 -- validation Procedures and Functions
219 ---------------------------------------------------------------------------
220 --PROCEDURE validate_unique(p_saiv_rec IN saiv_rec_type,
221 -- x_return_status OUT NOCOPY VARCHAR2);
222
223 /****************END ADDED AFTER TAPI, Sunil T. Mathew (04/16/2001)**************/
224
225 ---------------------------------------------------------------------------
226 -- Procedures and Functions
227 ---------------------------------------------------------------------------
228
229 PROCEDURE qc;
230 PROCEDURE change_version;
231 PROCEDURE api_copy;
232 PROCEDURE add_language;
233 PROCEDURE insert_row(
234 p_api_version IN NUMBER,
235 p_init_msg_list IN VARCHAR2 DEFAULT Okl_api.G_FALSE,
236 x_return_status OUT NOCOPY VARCHAR2,
237 x_msg_count OUT NOCOPY NUMBER,
238 x_msg_data OUT NOCOPY VARCHAR2,
239 p_tldv_rec IN tldv_rec_type,
240 x_tldv_rec OUT NOCOPY tldv_rec_type);
241
242 PROCEDURE insert_row(
243 p_api_version IN NUMBER,
244 p_init_msg_list IN VARCHAR2 DEFAULT Okl_api.G_FALSE,
245 x_return_status OUT NOCOPY VARCHAR2,
246 x_msg_count OUT NOCOPY NUMBER,
247 x_msg_data OUT NOCOPY VARCHAR2,
248 p_tldv_tbl IN tldv_tbl_type,
249 x_tldv_tbl OUT NOCOPY tldv_tbl_type);
250
251 PROCEDURE lock_row(
252 p_api_version IN NUMBER,
253 p_init_msg_list IN VARCHAR2 DEFAULT Okl_api.G_FALSE,
254 x_return_status OUT NOCOPY VARCHAR2,
255 x_msg_count OUT NOCOPY NUMBER,
256 x_msg_data OUT NOCOPY VARCHAR2,
257 p_tldv_rec IN tldv_rec_type);
258
259 PROCEDURE lock_row(
260 p_api_version IN NUMBER,
261 p_init_msg_list IN VARCHAR2 DEFAULT Okl_api.G_FALSE,
262 x_return_status OUT NOCOPY VARCHAR2,
263 x_msg_count OUT NOCOPY NUMBER,
264 x_msg_data OUT NOCOPY VARCHAR2,
265 p_tldv_tbl IN tldv_tbl_type);
266
267 PROCEDURE update_row(
268 p_api_version IN NUMBER,
269 p_init_msg_list IN VARCHAR2 DEFAULT Okl_api.G_FALSE,
270 x_return_status OUT NOCOPY VARCHAR2,
271 x_msg_count OUT NOCOPY NUMBER,
272 x_msg_data OUT NOCOPY VARCHAR2,
273 p_tldv_rec IN tldv_rec_type,
274 x_tldv_rec OUT NOCOPY tldv_rec_type);
275
276 PROCEDURE update_row(
277 p_api_version IN NUMBER,
278 p_init_msg_list IN VARCHAR2 DEFAULT Okl_api.G_FALSE,
279 x_return_status OUT NOCOPY VARCHAR2,
280 x_msg_count OUT NOCOPY NUMBER,
281 x_msg_data OUT NOCOPY VARCHAR2,
282 p_tldv_tbl IN tldv_tbl_type,
283 x_tldv_tbl OUT NOCOPY tldv_tbl_type);
284
285 PROCEDURE delete_row(
286 p_api_version IN NUMBER,
287 p_init_msg_list IN VARCHAR2 DEFAULT Okl_api.G_FALSE,
288 x_return_status OUT NOCOPY VARCHAR2,
289 x_msg_count OUT NOCOPY NUMBER,
290 x_msg_data OUT NOCOPY VARCHAR2,
291 p_tldv_rec IN tldv_rec_type);
292
293 PROCEDURE delete_row(
294 p_api_version IN NUMBER,
295 p_init_msg_list IN VARCHAR2 DEFAULT Okl_api.G_FALSE,
296 x_return_status OUT NOCOPY VARCHAR2,
297 x_msg_count OUT NOCOPY NUMBER,
298 x_msg_data OUT NOCOPY VARCHAR2,
299 p_tldv_tbl IN tldv_tbl_type);
300
301 PROCEDURE validate_row(
302 p_api_version IN NUMBER,
303 p_init_msg_list IN VARCHAR2 DEFAULT Okl_api.G_FALSE,
304 x_return_status OUT NOCOPY VARCHAR2,
305 x_msg_count OUT NOCOPY NUMBER,
306 x_msg_data OUT NOCOPY VARCHAR2,
307 p_tldv_rec IN tldv_rec_type);
308
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_tldv_tbl IN tldv_tbl_type);
316
317 END Okl_Tld_Pvt;