[Home] [Help]
PACKAGE: APPS.OKL_TXS_PVT
Source
1 PACKAGE OKL_TXS_PVT AS
2 /* $Header: OKLSTXSS.pls 120.5 2007/07/12 22:15:49 rravikir noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 -- OKL_TAX_SOURCES_V Record Spec
7 TYPE txsv_rec_type IS RECORD (
8 id NUMBER := OKL_API.G_MISS_NUM
9 ,khr_id NUMBER := OKL_API.G_MISS_NUM
10 ,kle_id NUMBER := OKL_API.G_MISS_NUM
11 ,asset_number OKL_TAX_SOURCES.LINE_NAME%TYPE := OKL_API.G_MISS_CHAR
12 ,trx_id NUMBER := OKL_API.G_MISS_NUM
13 ,trx_line_id NUMBER := OKL_API.G_MISS_NUM
14 ,entity_code OKL_TAX_SOURCES.ENTITY_CODE%TYPE := OKL_API.G_MISS_CHAR
15 ,event_class_code OKL_TAX_SOURCES.EVENT_CLASS_CODE%TYPE := OKL_API.G_MISS_CHAR
16 ,trx_level_type OKL_TAX_SOURCES.TRX_LEVEL_TYPE%TYPE := OKL_API.G_MISS_CHAR
17 --,trx_line_type OKL_TAX_SOURCES.TRX_LINE_TYPE%TYPE := OKL_API.G_MISS_CHAR
18 ,adjusted_doc_entity_code OKL_TAX_SOURCES.ADJUSTED_DOC_ENTITY_CODE%TYPE := OKL_API.G_MISS_CHAR
19 ,adjusted_doc_event_class_code OKL_TAX_SOURCES.ADJUSTED_DOC_EVENT_CLASS_CODE%TYPE := OKL_API.G_MISS_CHAR
20 ,adjusted_doc_trx_id NUMBER := OKL_API.G_MISS_NUM
21 ,adjusted_doc_trx_line_id NUMBER := OKL_API.G_MISS_NUM
22 ,adjusted_doc_trx_level_type OKL_TAX_SOURCES.ADJUSTED_DOC_TRX_LEVEL_TYPE%TYPE := OKL_API.G_MISS_CHAR
23 ,adjusted_doc_number OKL_TAX_SOURCES.ADJUSTED_DOC_NUMBER%TYPE := OKL_API.G_MISS_CHAR
24 ,adjusted_doc_date OKL_TAX_SOURCES.ADJUSTED_DOC_DATE%TYPE := OKL_API.G_MISS_DATE
25 ,tax_call_type_code OKL_TAX_SOURCES.TAX_CALL_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
26 ,sty_id NUMBER := OKL_API.G_MISS_NUM
27 ,trx_business_category OKL_TAX_SOURCES.TRX_BUSINESS_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
28 ,tax_line_status_code OKL_TAX_SOURCES.TAX_LINE_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
29 ,sel_id NUMBER := OKL_API.G_MISS_NUM
30 ,reported_yn OKL_TAX_SOURCES.TAX_REPORTING_FLAG%TYPE := OKL_API.G_MISS_CHAR
31 ,program_id 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_update_date OKL_TAX_SOURCES.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
35 ,attribute_category OKL_TAX_SOURCES.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
36 ,attribute1 OKL_TAX_SOURCES.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
37 ,attribute2 OKL_TAX_SOURCES.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
38 ,attribute3 OKL_TAX_SOURCES.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
39 ,attribute4 OKL_TAX_SOURCES.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
40 ,attribute5 OKL_TAX_SOURCES.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
41 ,attribute6 OKL_TAX_SOURCES.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
42 ,attribute7 OKL_TAX_SOURCES.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
43 ,attribute8 OKL_TAX_SOURCES.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
44 ,attribute9 OKL_TAX_SOURCES.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
45 ,attribute10 OKL_TAX_SOURCES.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
46 ,attribute11 OKL_TAX_SOURCES.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
47 ,attribute12 OKL_TAX_SOURCES.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
48 ,attribute13 OKL_TAX_SOURCES.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
49 ,attribute14 OKL_TAX_SOURCES.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
50 ,attribute15 OKL_TAX_SOURCES.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
51 ,created_by NUMBER := OKL_API.G_MISS_NUM
52 ,creation_date OKL_TAX_SOURCES.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
53 ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
54 ,last_update_date OKL_TAX_SOURCES.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
55 ,last_update_login NUMBER := OKL_API.G_MISS_NUM
56 ,object_version_number NUMBER := OKL_API.G_MISS_NUM
57 -- modified by eBTax by dcshanmu - modification starts
58 ,application_id NUMBER := OKL_API.G_MISS_NUM
59 ,default_taxation_country OKL_TAX_SOURCES.DEFAULT_TAXATION_COUNTRY%TYPE := OKL_API.G_MISS_CHAR
60 ,product_category OKL_TAX_SOURCES.PRODUCT_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
61 ,user_defined_fisc_class OKL_TAX_SOURCES.USER_DEFINED_FISC_CLASS%TYPE := OKL_API.G_MISS_CHAR
62 ,line_intended_use OKL_TAX_SOURCES.LINE_INTENDED_USE%TYPE := OKL_API.G_MISS_CHAR
63 ,inventory_item_id NUMBER := OKL_API.G_MISS_NUM
64 ,bill_to_cust_acct_id NUMBER := OKL_API.G_MISS_NUM
65 ,org_id NUMBER := OKL_API.G_MISS_NUM
66 ,legaL_entity_id NUMBER := OKL_API.G_MISS_NUM
67 ,line_amt NUMBER := OKL_API.G_MISS_NUM
68 ,assessable_value NUMBER := OKL_API.G_MISS_NUM
69 ,total_tax NUMBER := OKL_API.G_MISS_NUM
70 ,product_type OKL_TAX_SOURCES.PRODUCT_TYPE%TYPE := OKL_API.G_MISS_CHAR
71 ,product_fisc_classification OKL_TAX_SOURCES.PRODUCT_FISC_CLASSIFICATION%TYPE := OKL_API.G_MISS_CHAR
72 ,trx_date OKL_TAX_SOURCES.TRX_DATE%TYPE := OKL_API.G_MISS_DATE
73 ,provnl_tax_determination_date OKL_TAX_SOURCES.PROVNL_TAX_DETERMINATION_DATE%TYPE := OKL_API.G_MISS_DATE
74 ,try_id NUMBER := OKL_API.G_MISS_NUM
75 ,ship_to_location_id NUMBER := OKL_API.G_MISS_NUM
76 ,trx_currency_code OKL_TAX_SOURCES.TRX_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
77 ,currency_conversion_type OKL_TAX_SOURCES.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR
78 ,currency_conversion_rate NUMBER := OKL_API.G_MISS_NUM
79 ,currency_conversion_date OKL_TAX_SOURCES.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE
80 -- modified by eBTax by dcshanmu - modification end
81 --modified by asawanka for eBTax start
82 ,SHIP_TO_PARTY_SITE_ID NUMBER := OKL_API.G_MISS_NUM
83 ,SHIP_TO_PARTY_ID NUMBER := OKL_API.G_MISS_NUM
84 ,BILL_TO_PARTY_SITE_ID NUMBER := OKL_API.G_MISS_NUM
85 ,BILL_TO_LOCATION_ID NUMBER := OKL_API.G_MISS_NUM
86 ,BILL_TO_PARTY_ID NUMBER := OKL_API.G_MISS_NUM
87 ,ship_to_cust_acct_site_use_id NUMBER := OKL_API.G_MISS_NUM
88 ,bill_to_cust_acct_site_use_id NUMBER := OKL_API.G_MISS_NUM
89 ,TAX_CLASSIFICATION_CODE OKL_TAX_SOURCES.TAX_CLASSIFICATION_CODE%TYPE := OKL_API.G_MISS_CHAR
90 ,tax_reporting_flag OKL_TAX_SOURCES.tax_reporting_flag%TYPE := OKL_API.G_MISS_CHAR
91 ,line_name OKL_TAX_SOURCES.line_name%TYPE := OKL_API.G_MISS_CHAR
92 --modified by asawanka for eBTax end
93 ,alc_serialized_yn OKL_TAX_SOURCES.ALC_SERIALIZED_YN%TYPE := OKL_API.G_MISS_CHAR
94 ,alc_serialized_total_tax NUMBER := OKL_API.G_MISS_NUM
95 ,alc_serialized_total_line_amt NUMBER := OKL_API.G_MISS_NUM);
96
97 G_MISS_txsv_rec txsv_rec_type;
98 TYPE txsv_tbl_type IS TABLE OF txsv_rec_type
99 INDEX BY BINARY_INTEGER;
100 -- OKL_TAX_SOURCES Record Spec
101 TYPE txs_rec_type IS RECORD (
102 id NUMBER := OKL_API.G_MISS_NUM
103 ,khr_id NUMBER := OKL_API.G_MISS_NUM
104 ,kle_id NUMBER := OKL_API.G_MISS_NUM
105 ,asset_number OKL_TAX_SOURCES.LINE_NAME%TYPE := OKL_API.G_MISS_CHAR
106 ,trx_id NUMBER := OKL_API.G_MISS_NUM
107 ,trx_line_id NUMBER := OKL_API.G_MISS_NUM
108 ,entity_code OKL_TAX_SOURCES.ENTITY_CODE%TYPE := OKL_API.G_MISS_CHAR
109 ,event_class_code OKL_TAX_SOURCES.EVENT_CLASS_CODE%TYPE := OKL_API.G_MISS_CHAR
110 ,trx_level_type OKL_TAX_SOURCES.TRX_LEVEL_TYPE%TYPE := OKL_API.G_MISS_CHAR
111 --,trx_line_type OKL_TAX_SOURCES.TRX_LINE_TYPE%TYPE := OKL_API.G_MISS_CHAR
112 ,adjusted_doc_entity_code OKL_TAX_SOURCES.ADJUSTED_DOC_ENTITY_CODE%TYPE := OKL_API.G_MISS_CHAR
113 ,adjusted_doc_event_class_code OKL_TAX_SOURCES.ADJUSTED_DOC_EVENT_CLASS_CODE%TYPE := OKL_API.G_MISS_CHAR
114 ,adjusted_doc_trx_id NUMBER := OKL_API.G_MISS_NUM
115 ,adjusted_doc_trx_line_id NUMBER := OKL_API.G_MISS_NUM
116 ,adjusted_doc_trx_level_type OKL_TAX_SOURCES.ADJUSTED_DOC_TRX_LEVEL_TYPE%TYPE := OKL_API.G_MISS_CHAR
117 ,adjusted_doc_number OKL_TAX_SOURCES.ADJUSTED_DOC_NUMBER%TYPE := OKL_API.G_MISS_CHAR
118 ,adjusted_doc_date OKL_TAX_SOURCES.ADJUSTED_DOC_DATE%TYPE := OKL_API.G_MISS_DATE
119 ,tax_call_type_code OKL_TAX_SOURCES.TAX_CALL_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
120 ,sty_id NUMBER := OKL_API.G_MISS_NUM
121 ,trx_business_category OKL_TAX_SOURCES.TRX_BUSINESS_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
122 ,tax_line_status_code OKL_TAX_SOURCES.TAX_LINE_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
123 ,sel_id NUMBER := OKL_API.G_MISS_NUM
124 ,reported_yn OKL_TAX_SOURCES.TAX_REPORTING_FLAG%TYPE := OKL_API.G_MISS_CHAR
125 ,program_id NUMBER := OKL_API.G_MISS_NUM
126 ,request_id NUMBER := OKL_API.G_MISS_NUM
127 ,program_application_id NUMBER := OKL_API.G_MISS_NUM
128 ,program_update_date OKL_TAX_SOURCES.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
129 ,attribute_category OKL_TAX_SOURCES.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
130 ,attribute1 OKL_TAX_SOURCES.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
131 ,attribute2 OKL_TAX_SOURCES.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
132 ,attribute3 OKL_TAX_SOURCES.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
133 ,attribute4 OKL_TAX_SOURCES.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
134 ,attribute5 OKL_TAX_SOURCES.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
135 ,attribute6 OKL_TAX_SOURCES.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
136 ,attribute7 OKL_TAX_SOURCES.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
137 ,attribute8 OKL_TAX_SOURCES.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
138 ,attribute9 OKL_TAX_SOURCES.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
139 ,attribute10 OKL_TAX_SOURCES.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
140 ,attribute11 OKL_TAX_SOURCES.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
141 ,attribute12 OKL_TAX_SOURCES.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
142 ,attribute13 OKL_TAX_SOURCES.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
143 ,attribute14 OKL_TAX_SOURCES.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
144 ,attribute15 OKL_TAX_SOURCES.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
145 ,created_by NUMBER := OKL_API.G_MISS_NUM
146 ,creation_date OKL_TAX_SOURCES.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
147 ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
148 ,last_update_date OKL_TAX_SOURCES.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
149 ,last_update_login NUMBER := OKL_API.G_MISS_NUM
150 ,object_version_number NUMBER := OKL_API.G_MISS_NUM
151 -- modified by eBTax by dcshanmu - modification starts
152 ,application_id NUMBER := OKL_API.G_MISS_NUM
153 ,default_taxation_country OKL_TAX_SOURCES.DEFAULT_TAXATION_COUNTRY%TYPE := OKL_API.G_MISS_CHAR
154 ,product_category OKL_TAX_SOURCES.PRODUCT_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
155 ,user_defined_fisc_class OKL_TAX_SOURCES.USER_DEFINED_FISC_CLASS%TYPE := OKL_API.G_MISS_CHAR
156 ,line_intended_use OKL_TAX_SOURCES.LINE_INTENDED_USE%TYPE := OKL_API.G_MISS_CHAR
157 ,inventory_item_id NUMBER := OKL_API.G_MISS_NUM
158 ,bill_to_cust_acct_id NUMBER := OKL_API.G_MISS_NUM
159 ,org_id NUMBER := OKL_API.G_MISS_NUM
160 ,legaL_entity_id NUMBER := OKL_API.G_MISS_NUM
161 ,line_amt NUMBER := OKL_API.G_MISS_NUM
162 ,assessable_value NUMBER := OKL_API.G_MISS_NUM
163 ,total_tax NUMBER := OKL_API.G_MISS_NUM
164 ,product_type OKL_TAX_SOURCES.PRODUCT_TYPE%TYPE := OKL_API.G_MISS_CHAR
165 ,product_fisc_classification OKL_TAX_SOURCES.PRODUCT_FISC_CLASSIFICATION%TYPE := OKL_API.G_MISS_CHAR
166 ,trx_date OKL_TAX_SOURCES.TRX_DATE%TYPE := OKL_API.G_MISS_DATE
167 ,provnl_tax_determination_date OKL_TAX_SOURCES.PROVNL_TAX_DETERMINATION_DATE%TYPE := OKL_API.G_MISS_DATE
168 ,try_id NUMBER := OKL_API.G_MISS_NUM
169 ,ship_to_location_id NUMBER := OKL_API.G_MISS_NUM
170 ,trx_currency_code OKL_TAX_SOURCES.TRX_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
171 ,currency_conversion_type OKL_TAX_SOURCES.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR
172 ,currency_conversion_rate NUMBER := OKL_API.G_MISS_NUM
173 ,currency_conversion_date OKL_TAX_SOURCES.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE
174 -- modified by eBTax by dcshanmu - modification end
175 --modified by asawanka for eBTax start
176 ,SHIP_TO_PARTY_SITE_ID NUMBER := OKL_API.G_MISS_NUM
177 ,SHIP_TO_PARTY_ID NUMBER := OKL_API.G_MISS_NUM
178 ,BILL_TO_PARTY_SITE_ID NUMBER := OKL_API.G_MISS_NUM
179 ,BILL_TO_LOCATION_ID NUMBER := OKL_API.G_MISS_NUM
180 ,BILL_TO_PARTY_ID NUMBER := OKL_API.G_MISS_NUM
181 ,ship_to_cust_acct_site_use_id NUMBER := OKL_API.G_MISS_NUM
182 ,bill_to_cust_acct_site_use_id NUMBER := OKL_API.G_MISS_NUM
183 ,TAX_CLASSIFICATION_CODE OKL_TAX_SOURCES.TAX_CLASSIFICATION_CODE%TYPE := OKL_API.G_MISS_CHAR
184 ,tax_reporting_flag OKL_TAX_SOURCES.tax_reporting_flag%TYPE := OKL_API.G_MISS_CHAR
185 ,line_name OKL_TAX_SOURCES.line_name%TYPE := OKL_API.G_MISS_CHAR
186 --modified by asawanka for eBTax end
187 ,alc_serialized_yn OKL_TAX_SOURCES.ALC_SERIALIZED_YN%TYPE := OKL_API.G_MISS_CHAR
188 ,alc_serialized_total_tax NUMBER := OKL_API.G_MISS_NUM
189 ,alc_serialized_total_line_amt NUMBER := OKL_API.G_MISS_NUM);
190
191 G_MISS_txs_rec txs_rec_type;
192 TYPE txs_tbl_type IS TABLE OF txs_rec_type
193 INDEX BY BINARY_INTEGER;
194 ---------------------------------------------------------------------------
195 -- GLOBAL MESSAGE CONSTANTS
196 ---------------------------------------------------------------------------
197 G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
198 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
199 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
200 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
204 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
201 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
202 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
203 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
205 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
206 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
207 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
208 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
209 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
210
211 ---------------------------------------------------------------------------
212 -- GLOBAL EXCEPTIONS
213 ---------------------------------------------------------------------------
214 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
215
216 ---------------------------------------------------------------------------
217 -- GLOBAL VARIABLES
218 ---------------------------------------------------------------------------
219 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_TXS_PVT';
220 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
221
222 -- SECHAWLA Added
223 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
224 ---------------------------------------------------------------------------
225 -- Procedures and Functions
226 ---------------------------------------------------------------------------
227
228 PROCEDURE qc;
229 PROCEDURE change_version;
230 PROCEDURE api_copy;
231 PROCEDURE insert_row(
232 p_api_version IN NUMBER,
233 p_init_msg_list IN VARCHAR2,
234 x_return_status OUT NOCOPY VARCHAR2,
235 x_msg_count OUT NOCOPY NUMBER,
236 x_msg_data OUT NOCOPY VARCHAR2,
237 p_txsv_rec IN txsv_rec_type,
238 x_txsv_rec OUT NOCOPY txsv_rec_type);
239 PROCEDURE insert_row(
240 p_api_version IN NUMBER,
241 p_init_msg_list IN VARCHAR2,
242 x_return_status OUT NOCOPY VARCHAR2,
243 x_msg_count OUT NOCOPY NUMBER,
244 x_msg_data OUT NOCOPY VARCHAR2,
245 p_txsv_tbl IN txsv_tbl_type,
246 x_txsv_tbl OUT NOCOPY txsv_tbl_type,
247 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
248 PROCEDURE insert_row(
249 p_api_version IN NUMBER,
250 p_init_msg_list IN VARCHAR2,
251 x_return_status OUT NOCOPY VARCHAR2,
252 x_msg_count OUT NOCOPY NUMBER,
253 x_msg_data OUT NOCOPY VARCHAR2,
254 p_txsv_tbl IN txsv_tbl_type,
255 x_txsv_tbl OUT NOCOPY txsv_tbl_type);
256 PROCEDURE lock_row(
257 p_api_version IN NUMBER,
258 p_init_msg_list IN VARCHAR2,
259 x_return_status OUT NOCOPY VARCHAR2,
260 x_msg_count OUT NOCOPY NUMBER,
261 x_msg_data OUT NOCOPY VARCHAR2,
262 p_txsv_rec IN txsv_rec_type);
263 PROCEDURE lock_row(
264 p_api_version IN NUMBER,
265 p_init_msg_list IN VARCHAR2,
266 x_return_status OUT NOCOPY VARCHAR2,
267 x_msg_count OUT NOCOPY NUMBER,
268 x_msg_data OUT NOCOPY VARCHAR2,
269 p_txsv_tbl IN txsv_tbl_type,
270 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
271 PROCEDURE lock_row(
272 p_api_version IN NUMBER,
273 p_init_msg_list IN VARCHAR2,
274 x_return_status OUT NOCOPY VARCHAR2,
275 x_msg_count OUT NOCOPY NUMBER,
276 x_msg_data OUT NOCOPY VARCHAR2,
277 p_txsv_tbl IN txsv_tbl_type);
278 PROCEDURE update_row(
279 p_api_version IN NUMBER,
280 p_init_msg_list IN VARCHAR2,
281 x_return_status OUT NOCOPY VARCHAR2,
282 x_msg_count OUT NOCOPY NUMBER,
283 x_msg_data OUT NOCOPY VARCHAR2,
284 p_txsv_rec IN txsv_rec_type,
285 x_txsv_rec OUT NOCOPY txsv_rec_type);
286 PROCEDURE update_row(
287 p_api_version IN NUMBER,
288 p_init_msg_list IN VARCHAR2,
289 x_return_status OUT NOCOPY VARCHAR2,
290 x_msg_count OUT NOCOPY NUMBER,
291 x_msg_data OUT NOCOPY VARCHAR2,
292 p_txsv_tbl IN txsv_tbl_type,
293 x_txsv_tbl OUT NOCOPY txsv_tbl_type,
294 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
295 PROCEDURE update_row(
296 p_api_version IN NUMBER,
297 p_init_msg_list IN VARCHAR2,
298 x_return_status OUT NOCOPY VARCHAR2,
299 x_msg_count OUT NOCOPY NUMBER,
300 x_msg_data OUT NOCOPY VARCHAR2,
301 p_txsv_tbl IN txsv_tbl_type,
302 x_txsv_tbl OUT NOCOPY txsv_tbl_type);
303 PROCEDURE delete_row(
304 p_api_version IN NUMBER,
305 p_init_msg_list IN VARCHAR2,
306 x_return_status OUT NOCOPY VARCHAR2,
307 x_msg_count OUT NOCOPY NUMBER,
308 x_msg_data OUT NOCOPY VARCHAR2,
309 p_txsv_rec IN txsv_rec_type);
310 PROCEDURE delete_row(
311 p_api_version IN NUMBER,
312 p_init_msg_list IN VARCHAR2,
313 x_return_status OUT NOCOPY VARCHAR2,
314 x_msg_count OUT NOCOPY NUMBER,
315 x_msg_data OUT NOCOPY VARCHAR2,
316 p_txsv_tbl IN txsv_tbl_type,
317 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
318 PROCEDURE delete_row(
319 p_api_version IN NUMBER,
320 p_init_msg_list IN VARCHAR2,
321 x_return_status OUT NOCOPY VARCHAR2,
322 x_msg_count OUT NOCOPY NUMBER,
323 x_msg_data OUT NOCOPY VARCHAR2,
324 p_txsv_tbl IN txsv_tbl_type);
325 PROCEDURE validate_row(
326 p_api_version IN NUMBER,
327 p_init_msg_list IN VARCHAR2,
328 x_return_status OUT NOCOPY VARCHAR2,
329 x_msg_count OUT NOCOPY NUMBER,
330 x_msg_data OUT NOCOPY VARCHAR2,
331 p_txsv_rec IN txsv_rec_type);
332 PROCEDURE validate_row(
333 p_api_version IN NUMBER,
334 p_init_msg_list IN VARCHAR2,
335 x_return_status OUT NOCOPY VARCHAR2,
336 x_msg_count OUT NOCOPY NUMBER,
337 x_msg_data OUT NOCOPY VARCHAR2,
338 p_txsv_tbl IN txsv_tbl_type,
339 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
340 PROCEDURE validate_row(
341 p_api_version IN NUMBER,
342 p_init_msg_list IN VARCHAR2,
343 x_return_status OUT NOCOPY VARCHAR2,
344 x_msg_count OUT NOCOPY NUMBER,
345 x_msg_data OUT NOCOPY VARCHAR2,
346 p_txsv_tbl IN txsv_tbl_type);
347 END OKL_TXS_PVT;