[Home] [Help]
PACKAGE: APPS.OKL_TTD_PVT
Source
1 PACKAGE OKL_TTD_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSTTDS.pls 120.4 2007/01/15 11:15:20 dcshanmu noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 -- OKL_TAX_TRX_DETAILS_V Record Spec
7 TYPE ttdv_rec_type IS RECORD (
8 id NUMBER := OKL_API.G_MISS_NUM
9 ,txs_id NUMBER := OKL_API.G_MISS_NUM
10 ,tax_determine_date OKL_TAX_TRX_DETAILS.TAX_DETERMINE_DATE%TYPE := OKL_API.G_MISS_DATE
11 ,tax_rate_id NUMBER := OKL_API.G_MISS_NUM
12 ,tax_rate_code OKL_TAX_TRX_DETAILS.TAX_RATE_CODE%TYPE := OKL_API.G_MISS_CHAR
13 ,taxable_amt NUMBER := OKL_API.G_MISS_NUM
14 ,tax_exemption_id NUMBER := OKL_API.G_MISS_NUM
15 ,tax_rate NUMBER := OKL_API.G_MISS_NUM
16 ,tax_amt NUMBER := OKL_API.G_MISS_NUM
17 ,billed_yn OKL_TAX_TRX_DETAILS.BILLED_YN%TYPE := OKL_API.G_MISS_CHAR
18 ,tax_call_type_code OKL_TAX_TRX_DETAILS.TAX_CALL_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
19 ,program_id NUMBER := OKL_API.G_MISS_NUM
20 ,request_id NUMBER := OKL_API.G_MISS_NUM
21 ,program_application_id NUMBER := OKL_API.G_MISS_NUM
22 ,program_update_date OKL_TAX_TRX_DETAILS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
23 ,attribute_category OKL_TAX_TRX_DETAILS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
24 ,attribute1 OKL_TAX_TRX_DETAILS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
25 ,attribute2 OKL_TAX_TRX_DETAILS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
26 ,attribute3 OKL_TAX_TRX_DETAILS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
27 ,attribute4 OKL_TAX_TRX_DETAILS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
28 ,attribute5 OKL_TAX_TRX_DETAILS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
29 ,attribute6 OKL_TAX_TRX_DETAILS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
30 ,attribute7 OKL_TAX_TRX_DETAILS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
31 ,attribute8 OKL_TAX_TRX_DETAILS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
32 ,attribute9 OKL_TAX_TRX_DETAILS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
33 ,attribute10 OKL_TAX_TRX_DETAILS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
34 ,attribute11 OKL_TAX_TRX_DETAILS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
35 ,attribute12 OKL_TAX_TRX_DETAILS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
36 ,attribute13 OKL_TAX_TRX_DETAILS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
37 ,attribute14 OKL_TAX_TRX_DETAILS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
38 ,attribute15 OKL_TAX_TRX_DETAILS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
39 ,created_by NUMBER := OKL_API.G_MISS_NUM
40 ,creation_date OKL_TAX_TRX_DETAILS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
41 ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
42 ,last_update_date OKL_TAX_TRX_DETAILS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
43 ,last_update_login NUMBER := OKL_API.G_MISS_NUM
44 ,object_version_number NUMBER := OKL_API.G_MISS_NUM
45 -- Modified by dcshanmu for eBTax - modification starts
46 ,tax_date OKL_TAX_TRX_DETAILS.TAX_DATE%TYPE := OKL_API.G_MISS_DATE
47 ,line_amt NUMBER := OKL_API.G_MISS_NUM
48 ,internal_organization_id NUMBER := OKL_API.G_MISS_NUM
49 ,application_id NUMBER := OKL_API.G_MISS_NUM
50 ,entity_code OKL_TAX_TRX_DETAILS.ENTITY_CODE%TYPE := OKL_API.G_MISS_CHAR
51 ,event_class_code OKL_TAX_TRX_DETAILS.EVENT_CLASS_CODE%TYPE := OKL_API.G_MISS_CHAR
52 ,event_type_code OKL_TAX_TRX_DETAILS.EVENT_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
53 ,trx_id NUMBER :=OKL_API.G_MISS_CHAR
54 ,trx_line_id NUMBER := OKL_API.G_MISS_CHAR
55 ,trx_level_type OKL_TAX_TRX_DETAILS.TRX_LEVEL_TYPE%TYPE := OKL_API.G_MISS_CHAR
56 ,trx_line_number NUMBER := OKL_API.G_MISS_NUM
57 ,tax_line_number NUMBER := OKL_API.G_MISS_NUM
58 ,tax_regime_id NUMBER := OKL_API.G_MISS_NUM
59 ,tax_regime_code OKL_TAX_TRX_DETAILS.TAX_REGIME_CODE%TYPE := OKL_API.G_MISS_CHAR
60 ,tax_id NUMBER := OKL_API.G_MISS_NUM
61 ,tax OKL_TAX_TRX_DETAILS.TAX%TYPE := OKL_API.G_MISS_CHAR
62 ,tax_status_id NUMBER := OKL_API.G_MISS_NUM
63 ,tax_status_code OKL_TAX_TRX_DETAILS.TAX_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
64 ,tax_apportionment_line_number NUMBER := OKL_API.G_MISS_NUM
65 ,legal_entity_id NUMBER := OKL_API.G_MISS_NUM
66 ,trx_number OKL_TAX_TRX_DETAILS.TRX_NUMBER%TYPE := OKL_API.G_MISS_CHAR
67 ,trx_date OKL_TAX_TRX_DETAILS.TRX_DATE%TYPE := OKL_API.G_MISS_DATE
68 ,tax_jurisdiction_id NUMBER := OKL_API.G_MISS_NUM
69 ,tax_jurisdiction_code OKL_TAX_TRX_DETAILS.TAX_JURISDICTION_CODE%TYPE := OKL_API.G_MISS_CHAR
70 ,tax_type_code OKL_TAX_TRX_DETAILS.TAX_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
71 ,tax_currency_code OKL_TAX_TRX_DETAILS.TAX_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
72 ,taxable_amt_tax_curr NUMBER := OKL_API.G_MISS_NUM
73 ,trx_currency_code OKL_TAX_TRX_DETAILS.TRX_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
74 ,minimum_accountable_unit NUMBER := OKL_API.G_MISS_NUM
75 ,precision NUMBER := OKL_API.G_MISS_NUM
76 ,currency_conversion_type OKL_TAX_TRX_DETAILS.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR
77 ,currency_conversion_rate NUMBER := OKL_API.G_MISS_NUM
78 ,currency_conversion_date OKL_TAX_TRX_DETAILS.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE);
79 -- Modified by dcshanmu for eBTax - modification end
80 GMissOklTaxTrxDetailsVRec ttdv_rec_type;
81 TYPE ttdv_tbl_type IS TABLE OF ttdv_rec_type
82 INDEX BY BINARY_INTEGER;
83 -- OKL_TAX_TRX_DETAILS Record Spec
84 TYPE ttd_rec_type IS RECORD (
85 id NUMBER := OKL_API.G_MISS_NUM
86 ,txs_id NUMBER := OKL_API.G_MISS_NUM
87 ,tax_determine_date OKL_TAX_TRX_DETAILS.TAX_DETERMINE_DATE%TYPE := OKL_API.G_MISS_DATE
88 ,tax_rate_id NUMBER := OKL_API.G_MISS_NUM
89 ,tax_rate_code OKL_TAX_TRX_DETAILS.TAX_RATE_CODE%TYPE := OKL_API.G_MISS_CHAR
90 ,taxable_amt NUMBER := OKL_API.G_MISS_NUM
91 ,tax_exemption_id NUMBER := OKL_API.G_MISS_NUM
92 ,tax_rate NUMBER := OKL_API.G_MISS_NUM
93 ,tax_amt NUMBER := OKL_API.G_MISS_NUM
94 ,billed_yn OKL_TAX_TRX_DETAILS.BILLED_YN%TYPE := OKL_API.G_MISS_CHAR
95 ,tax_call_type_code OKL_TAX_TRX_DETAILS.TAX_CALL_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
96 ,program_id NUMBER := OKL_API.G_MISS_NUM
97 ,request_id NUMBER := OKL_API.G_MISS_NUM
98 ,program_application_id NUMBER := OKL_API.G_MISS_NUM
99 ,program_update_date OKL_TAX_TRX_DETAILS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
100 ,attribute_category OKL_TAX_TRX_DETAILS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
101 ,attribute1 OKL_TAX_TRX_DETAILS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
102 ,attribute2 OKL_TAX_TRX_DETAILS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
103 ,attribute3 OKL_TAX_TRX_DETAILS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
104 ,attribute4 OKL_TAX_TRX_DETAILS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
105 ,attribute5 OKL_TAX_TRX_DETAILS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
106 ,attribute6 OKL_TAX_TRX_DETAILS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
107 ,attribute7 OKL_TAX_TRX_DETAILS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
108 ,attribute8 OKL_TAX_TRX_DETAILS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
109 ,attribute9 OKL_TAX_TRX_DETAILS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
110 ,attribute10 OKL_TAX_TRX_DETAILS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
111 ,attribute11 OKL_TAX_TRX_DETAILS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
112 ,attribute12 OKL_TAX_TRX_DETAILS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
113 ,attribute13 OKL_TAX_TRX_DETAILS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
114 ,attribute14 OKL_TAX_TRX_DETAILS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
115 ,attribute15 OKL_TAX_TRX_DETAILS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
116 ,created_by NUMBER := OKL_API.G_MISS_NUM
117 ,creation_date OKL_TAX_TRX_DETAILS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
118 ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
119 ,last_update_date OKL_TAX_TRX_DETAILS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
120 ,last_update_login NUMBER := OKL_API.G_MISS_NUM
121 ,object_version_number NUMBER := OKL_API.G_MISS_NUM
122 -- Modified by dcshanmu for eBTax - modification starts
123 ,tax_date OKL_TAX_TRX_DETAILS.TAX_DATE%TYPE := OKL_API.G_MISS_DATE
124 ,line_amt NUMBER := OKL_API.G_MISS_NUM
125 ,internal_organization_id NUMBER := OKL_API.G_MISS_NUM
126 ,application_id NUMBER := OKL_API.G_MISS_NUM
127 ,entity_code OKL_TAX_TRX_DETAILS.ENTITY_CODE%TYPE := OKL_API.G_MISS_CHAR
128 ,event_class_code OKL_TAX_TRX_DETAILS.EVENT_CLASS_CODE%TYPE := OKL_API.G_MISS_CHAR
129 ,event_type_code OKL_TAX_TRX_DETAILS.EVENT_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
130 ,trx_id NUMBER :=OKL_API.G_MISS_CHAR
131 ,trx_line_id NUMBER := OKL_API.G_MISS_CHAR
132 ,trx_level_type OKL_TAX_TRX_DETAILS.TRX_LEVEL_TYPE%TYPE := OKL_API.G_MISS_CHAR
133 ,trx_line_number NUMBER := OKL_API.G_MISS_NUM
134 ,tax_line_number NUMBER := OKL_API.G_MISS_NUM
135 ,tax_regime_id NUMBER := OKL_API.G_MISS_NUM
136 ,tax_regime_code OKL_TAX_TRX_DETAILS.TAX_REGIME_CODE%TYPE := OKL_API.G_MISS_CHAR
137 ,tax_id NUMBER := OKL_API.G_MISS_NUM
138 ,tax OKL_TAX_TRX_DETAILS.TAX%TYPE := OKL_API.G_MISS_CHAR
139 ,tax_status_id NUMBER := OKL_API.G_MISS_NUM
140 ,tax_status_code OKL_TAX_TRX_DETAILS.TAX_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
141 ,tax_apportionment_line_number NUMBER := OKL_API.G_MISS_NUM
142 ,legal_entity_id NUMBER := OKL_API.G_MISS_NUM
143 ,trx_number OKL_TAX_TRX_DETAILS.TRX_NUMBER%TYPE := OKL_API.G_MISS_CHAR
144 ,trx_date OKL_TAX_TRX_DETAILS.TRX_DATE%TYPE := OKL_API.G_MISS_DATE
145 ,tax_jurisdiction_id NUMBER := OKL_API.G_MISS_NUM
146 ,tax_jurisdiction_code OKL_TAX_TRX_DETAILS.TAX_JURISDICTION_CODE%TYPE := OKL_API.G_MISS_CHAR
147 ,tax_type_code OKL_TAX_TRX_DETAILS.TAX_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
148 ,tax_currency_code OKL_TAX_TRX_DETAILS.TAX_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
149 ,taxable_amt_tax_curr NUMBER := OKL_API.G_MISS_NUM
150 ,trx_currency_code OKL_TAX_TRX_DETAILS.TRX_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
151 ,minimum_accountable_unit NUMBER := OKL_API.G_MISS_NUM
152 ,precision NUMBER := OKL_API.G_MISS_NUM
153 ,currency_conversion_type OKL_TAX_TRX_DETAILS.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR
154 ,currency_conversion_rate NUMBER := OKL_API.G_MISS_NUM
155 ,currency_conversion_date OKL_TAX_TRX_DETAILS.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE);
156 -- Modified by dcshanmu for eBTax - modification end
157 G_MISS_ttd_rec ttd_rec_type;
158 TYPE ttd_tbl_type IS TABLE OF ttd_rec_type
159 INDEX BY BINARY_INTEGER;
160 ---------------------------------------------------------------------------
161 -- GLOBAL MESSAGE CONSTANTS
162 ---------------------------------------------------------------------------
163 G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
164 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
165 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
166 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
167 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
168 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
169 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
170 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
171 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
172 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
173 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
174 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
175 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
176
177 ---------------------------------------------------------------------------
178 -- GLOBAL EXCEPTIONS
179 ---------------------------------------------------------------------------
180 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
181
182 ---------------------------------------------------------------------------
183 -- GLOBAL VARIABLES
184 ---------------------------------------------------------------------------
185 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_TTD_PVT';
186 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
187
188 -- SECHAWLA Added
189 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
190 ---------------------------------------------------------------------------
191 -- Procedures and Functions
192 ---------------------------------------------------------------------------
193
194 PROCEDURE qc;
195 PROCEDURE change_version;
196 PROCEDURE api_copy;
197 PROCEDURE insert_row(
198 p_api_version IN NUMBER,
199 p_init_msg_list IN VARCHAR2,
200 x_return_status OUT NOCOPY VARCHAR2,
201 x_msg_count OUT NOCOPY NUMBER,
202 x_msg_data OUT NOCOPY VARCHAR2,
203 p_ttdv_rec IN ttdv_rec_type,
204 x_ttdv_rec OUT NOCOPY ttdv_rec_type);
205 PROCEDURE insert_row(
206 p_api_version IN NUMBER,
207 p_init_msg_list IN VARCHAR2,
208 x_return_status OUT NOCOPY VARCHAR2,
209 x_msg_count OUT NOCOPY NUMBER,
210 x_msg_data OUT NOCOPY VARCHAR2,
211 p_ttdv_tbl IN ttdv_tbl_type,
212 x_ttdv_tbl OUT NOCOPY ttdv_tbl_type,
213 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
217 x_return_status OUT NOCOPY VARCHAR2,
214 PROCEDURE insert_row(
215 p_api_version IN NUMBER,
216 p_init_msg_list IN VARCHAR2,
218 x_msg_count OUT NOCOPY NUMBER,
219 x_msg_data OUT NOCOPY VARCHAR2,
220 p_ttdv_tbl IN ttdv_tbl_type,
221 x_ttdv_tbl OUT NOCOPY ttdv_tbl_type);
222 PROCEDURE lock_row(
223 p_api_version IN NUMBER,
224 p_init_msg_list IN VARCHAR2,
225 x_return_status OUT NOCOPY VARCHAR2,
226 x_msg_count OUT NOCOPY NUMBER,
227 x_msg_data OUT NOCOPY VARCHAR2,
228 p_ttdv_rec IN ttdv_rec_type);
229 PROCEDURE lock_row(
230 p_api_version IN NUMBER,
231 p_init_msg_list IN VARCHAR2,
232 x_return_status OUT NOCOPY VARCHAR2,
233 x_msg_count OUT NOCOPY NUMBER,
234 x_msg_data OUT NOCOPY VARCHAR2,
235 p_ttdv_tbl IN ttdv_tbl_type,
236 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
237 PROCEDURE lock_row(
238 p_api_version IN NUMBER,
239 p_init_msg_list IN VARCHAR2,
240 x_return_status OUT NOCOPY VARCHAR2,
241 x_msg_count OUT NOCOPY NUMBER,
242 x_msg_data OUT NOCOPY VARCHAR2,
243 p_ttdv_tbl IN ttdv_tbl_type);
244 PROCEDURE update_row(
245 p_api_version IN NUMBER,
246 p_init_msg_list IN VARCHAR2,
247 x_return_status OUT NOCOPY VARCHAR2,
248 x_msg_count OUT NOCOPY NUMBER,
249 x_msg_data OUT NOCOPY VARCHAR2,
250 p_ttdv_rec IN ttdv_rec_type,
251 x_ttdv_rec OUT NOCOPY ttdv_rec_type);
252 PROCEDURE update_row(
253 p_api_version IN NUMBER,
254 p_init_msg_list IN VARCHAR2,
255 x_return_status OUT NOCOPY VARCHAR2,
256 x_msg_count OUT NOCOPY NUMBER,
257 x_msg_data OUT NOCOPY VARCHAR2,
258 p_ttdv_tbl IN ttdv_tbl_type,
259 x_ttdv_tbl OUT NOCOPY ttdv_tbl_type,
260 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
261 PROCEDURE update_row(
262 p_api_version IN NUMBER,
263 p_init_msg_list IN VARCHAR2,
264 x_return_status OUT NOCOPY VARCHAR2,
265 x_msg_count OUT NOCOPY NUMBER,
266 x_msg_data OUT NOCOPY VARCHAR2,
267 p_ttdv_tbl IN ttdv_tbl_type,
268 x_ttdv_tbl OUT NOCOPY ttdv_tbl_type);
269 PROCEDURE delete_row(
270 p_api_version IN NUMBER,
271 p_init_msg_list IN VARCHAR2,
272 x_return_status OUT NOCOPY VARCHAR2,
273 x_msg_count OUT NOCOPY NUMBER,
274 x_msg_data OUT NOCOPY VARCHAR2,
275 p_ttdv_rec IN ttdv_rec_type);
276 PROCEDURE delete_row(
277 p_api_version IN NUMBER,
278 p_init_msg_list IN VARCHAR2,
279 x_return_status OUT NOCOPY VARCHAR2,
280 x_msg_count OUT NOCOPY NUMBER,
281 x_msg_data OUT NOCOPY VARCHAR2,
282 p_ttdv_tbl IN ttdv_tbl_type,
283 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
284 PROCEDURE delete_row(
285 p_api_version IN NUMBER,
286 p_init_msg_list IN VARCHAR2,
287 x_return_status OUT NOCOPY VARCHAR2,
288 x_msg_count OUT NOCOPY NUMBER,
289 x_msg_data OUT NOCOPY VARCHAR2,
290 p_ttdv_tbl IN ttdv_tbl_type);
291 PROCEDURE validate_row(
292 p_api_version IN NUMBER,
293 p_init_msg_list IN VARCHAR2,
294 x_return_status OUT NOCOPY VARCHAR2,
295 x_msg_count OUT NOCOPY NUMBER,
296 x_msg_data OUT NOCOPY VARCHAR2,
297 p_ttdv_rec IN ttdv_rec_type);
298 PROCEDURE validate_row(
299 p_api_version IN NUMBER,
300 p_init_msg_list IN VARCHAR2,
301 x_return_status OUT NOCOPY VARCHAR2,
302 x_msg_count OUT NOCOPY NUMBER,
303 x_msg_data OUT NOCOPY VARCHAR2,
304 p_ttdv_tbl IN ttdv_tbl_type,
305 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
306 PROCEDURE validate_row(
307 p_api_version IN NUMBER,
308 p_init_msg_list IN VARCHAR2,
309 x_return_status OUT NOCOPY VARCHAR2,
310 x_msg_count OUT NOCOPY NUMBER,
311 x_msg_data OUT NOCOPY VARCHAR2,
312 p_ttdv_tbl IN ttdv_tbl_type);
313 END OKL_TTD_PVT;