[Home] [Help]
PACKAGE: APPS.ZX_API_PUB
Source
1 PACKAGE ZX_API_PUB AUTHID CURRENT_USER AS
2 /* $Header: zxifpubsrvcspubs.pls 120.137 2010/11/24 14:26:57 ssanka ship $ */
3
4 /* ======================================================================*
5 | Global Variables |
6 * ======================================================================*/
7
8 G_PUB_SRVC VARCHAR2(80);
9 G_DATA_TRANSFER_MODE VARCHAR2(30);
10 G_EXTERNAL_API_CALL VARCHAR2(1);
11 G_PUB_CALLING_SRVC VARCHAR2(80);
12
13 /* ======================================================================*
14 | Data Type Definitions |
15 * ======================================================================*/
16
17 TYPE NUMBER_tbl_type is TABLE OF NUMBER
18 INDEX BY BINARY_INTEGER;
19
20 TYPE DATE_tbl_type is TABLE OF DATE
21 INDEX BY BINARY_INTEGER;
22
23 TYPE VARCHAR2_1_tbl_type is TABLE OF VARCHAR2(1)
24 INDEX BY BINARY_INTEGER;
25
26 TYPE VARCHAR2_2_tbl_type is TABLE OF VARCHAR2(2)
27 INDEX BY BINARY_INTEGER;
28
29 TYPE VARCHAR2_30_tbl_type is TABLE OF VARCHAR2(30)
30 INDEX BY BINARY_INTEGER;
31
32 TYPE VARCHAR2_50_tbl_type is TABLE OF VARCHAR2(50)
33 INDEX BY BINARY_INTEGER;
34
35 TYPE VARCHAR2_80_tbl_type is TABLE OF VARCHAR2(80)
36 INDEX BY BINARY_INTEGER;
37
38 TYPE VARCHAR2_150_tbl_type is TABLE OF VARCHAR2(150)
39 INDEX BY BINARY_INTEGER;
40
41 TYPE VARCHAR2_240_tbl_type is TABLE OF VARCHAR2(240)
42 INDEX BY BINARY_INTEGER;
43
44 TYPE VARCHAR2_250_tbl_type is TABLE OF VARCHAR2(250)
45 INDEX BY BINARY_INTEGER;
46
47 TYPE VARCHAR2_2000_tbl_type is TABLE OF VARCHAR2(2000)
48 INDEX BY BINARY_INTEGER;
49
50 TYPE transaction_line_rec_type IS RECORD
51 (INTERNAL_ORGANIZATION_ID NUMBER
52 ,APPLICATION_ID NUMBER
53 ,ENTITY_CODE VARCHAR2(30)
54 ,EVENT_CLASS_CODE VARCHAR2(30)
55 ,EVENT_TYPE_CODE VARCHAR2(30)
56 ,TRX_ID NUMBER
57 ,HDR_TRX_USER_KEY1 VARCHAR2(150)
58 ,HDR_TRX_USER_KEY2 VARCHAR2(150)
59 ,HDR_TRX_USER_KEY3 VARCHAR2(150)
60 ,HDR_TRX_USER_KEY4 VARCHAR2(150)
61 ,HDR_TRX_USER_KEY5 VARCHAR2(150)
62 ,HDR_TRX_USER_KEY6 VARCHAR2(150)
63 ,TRX_LEVEL_TYPE VARCHAR2(30)
64 ,TRX_LINE_ID NUMBER
65 ,LINE_TRX_USER_KEY1 VARCHAR2(150)
66 ,LINE_TRX_USER_KEY2 VARCHAR2(150)
67 ,LINE_TRX_USER_KEY3 VARCHAR2(150)
68 ,LINE_TRX_USER_KEY4 VARCHAR2(150)
69 ,LINE_TRX_USER_KEY5 VARCHAR2(150)
70 ,LINE_TRX_USER_KEY6 VARCHAR2(150)
71 ,FIRST_PTY_ORG_ID NUMBER(15)
72 ,TAX_EVENT_CLASS_CODE VARCHAR2(30)
73 ,TAX_EVENT_TYPE_CODE VARCHAR2(30)
74 ,DOC_EVENT_STATUS VARCHAR2(30)
75 );
76
77 TYPE transaction_rec_type IS RECORD
78 (APPLICATION_ID NUMBER,
79 ENTITY_CODE VARCHAR2(30),
80 EVENT_CLASS_CODE VARCHAR2(30),
81 EVENT_TYPE_CODE VARCHAR2(30),
82 TRX_ID NUMBER,
83 INTERNAL_ORGANIZATION_ID NUMBER,
84 HDR_TRX_USER_KEY1 VARCHAR2(150),
85 HDR_TRX_USER_KEY2 VARCHAR2(150),
86 HDR_TRX_USER_KEY3 VARCHAR2(150),
87 HDR_TRX_USER_KEY4 VARCHAR2(150),
88 HDR_TRX_USER_KEY5 VARCHAR2(150),
89 HDR_TRX_USER_KEY6 VARCHAR2(150),
90 FIRST_PTY_ORG_ID NUMBER(15),
91 TAX_EVENT_CLASS_CODE VARCHAR2(30),
92 TAX_EVENT_TYPE_CODE VARCHAR2(30),
93 DOC_EVENT_STATUS VARCHAR2(30),
94 APPLICATION_DOC_STATUS VARCHAR2(30)
95 );
96
97 TYPE transaction_header_rec_type IS RECORD
98 (INTERNAL_ORGANIZATION_ID NUMBER_tbl_type,
99 LEGAL_ENTITY_ID NUMBER_tbl_type,
100 LEDGER_ID NUMBER_tbl_type,
101 APPLICATION_ID NUMBER_tbl_type,
102 ENTITY_CODE VARCHAR2_30_tbl_type,
103 EVENT_CLASS_CODE VARCHAR2_30_tbl_type,
104 EVENT_TYPE_CODE VARCHAR2_30_tbl_type,
105 CTRL_TOTAL_HDR_TX_AMT VARCHAR2_30_tbl_type,
106 TRX_ID NUMBER_tbl_type,
107 HDR_TRX_USER_KEY1 VARCHAR2_150_tbl_type,
108 HDR_TRX_USER_KEY2 VARCHAR2_150_tbl_type,
109 HDR_TRX_USER_KEY3 VARCHAR2_150_tbl_type,
110 HDR_TRX_USER_KEY4 VARCHAR2_150_tbl_type,
111 HDR_TRX_USER_KEY5 VARCHAR2_150_tbl_type,
112 HDR_TRX_USER_KEY6 VARCHAR2_150_tbl_type,
113 TRX_DATE DATE_tbl_type,
114 REL_DOC_DATE DATE_tbl_type,
115 PROVNL_TAX_DETERMINATION_DATE DATE_tbl_type,
116 TRX_CURRENCY_CODE VARCHAR2_30_tbl_type,
117 PRECISION NUMBER_tbl_type,
118 CURRENCY_CONVERSION_TYPE VARCHAR2_30_tbl_type,
119 CURRENCY_CONVERSION_RATE NUMBER_tbl_type,
120 CURRENCY_CONVERSION_DATE DATE_tbl_type,
121 ROUNDING_SHIP_TO_PARTY_ID NUMBER_tbl_type,
122 ROUNDING_SHIP_FROM_PARTY_ID NUMBER_tbl_type,
123 ROUNDING_BILL_TO_PARTY_ID NUMBER_tbl_type,
124 ROUNDING_BILL_FROM_PARTY_ID NUMBER_tbl_type,
125 RNDG_SHIP_TO_PARTY_SITE_ID NUMBER_tbl_type,
126 RNDG_SHIP_FROM_PARTY_SITE_ID NUMBER_tbl_type,
127 RNDG_BILL_TO_PARTY_SITE_ID NUMBER_tbl_type,
128 RNDG_BILL_FROM_PARTY_SITE_ID NUMBER_tbl_type,
129 QUOTE_FLAG VARCHAR2_1_tbl_type,
130 ESTABLISHMENT_ID NUMBER_tbl_type,
131 ICX_SESSION_ID NUMBER_tbl_type
132 );
133
134 TYPE event_class_rec_type IS RECORD
135 (INTERNAL_ORGANIZATION_ID NUMBER,
136 LEGAL_ENTITY_ID NUMBER,
137 LEDGER_ID NUMBER,
138 FIRST_PTY_ORG_ID NUMBER(15),
139 APPLICATION_ID NUMBER,
140 CTRL_TOTAL_HDR_TX_AMT NUMBER,
141 CTRL_TOTAL_LINE_TX_AMT_FLG VARCHAR2(1),
142 ENTITY_CODE VARCHAR2(30),
143 EVENT_CLASS_CODE VARCHAR2(30),
144 EVENT_CLASS_MAPPING_ID NUMBER,
145 REFERENCE_APPLICATION_ID NUMBER,
146 EVENT_TYPE_CODE VARCHAR2(30),
147 TRX_ID NUMBER,
148 HDR_TRX_USER_KEY1 VARCHAR2(150),
149 HDR_TRX_USER_KEY2 VARCHAR2(150),
150 HDR_TRX_USER_KEY3 VARCHAR2(150),
151 HDR_TRX_USER_KEY4 VARCHAR2(150),
152 HDR_TRX_USER_KEY5 VARCHAR2(150),
153 HDR_TRX_USER_KEY6 VARCHAR2(150),
154 TRX_DATE DATE,
155 REL_DOC_DATE DATE,
156 PROVNL_TAX_DETERMINATION_DATE DATE,
157 TRX_CURRENCY_CODE VARCHAR2(30),
158 CURRENCY_CONVERSION_TYPE VARCHAR2(30),
159 CURRENCY_CONVERSION_RATE NUMBER,
160 CURRENCY_CONVERSION_DATE DATE,
161 PRECISION NUMBER,
162 ROUNDING_SHIP_TO_PARTY_ID NUMBER,
163 ROUNDING_SHIP_FROM_PARTY_ID NUMBER,
164 ROUNDING_BILL_TO_PARTY_ID NUMBER,
165 ROUNDING_BILL_FROM_PARTY_ID NUMBER,
166 RNDG_SHIP_TO_PARTY_SITE_ID NUMBER,
167 RNDG_SHIP_FROM_PARTY_SITE_ID NUMBER,
168 RNDG_BILL_TO_PARTY_SITE_ID NUMBER,
169 RNDG_BILL_FROM_PARTY_SITE_ID NUMBER,
170 TAX_EVENT_CLASS_CODE VARCHAR2(30),
171 TAX_EVENT_TYPE_CODE VARCHAR2(30),
172 DOC_STATUS_CODE VARCHAR2(30),
173 DET_FACTOR_TEMPL_CODE VARCHAR2(30),
174 DEFAULT_ROUNDING_LEVEL_CODE VARCHAR2(30),
175 ROUNDING_LEVEL_HIER_1_CODE VARCHAR2(30),
176 ROUNDING_LEVEL_HIER_2_CODE VARCHAR2(30),
177 ROUNDING_LEVEL_HIER_3_CODE VARCHAR2(30),
178 ROUNDING_LEVEL_HIER_4_CODE VARCHAR2(30),
179 RDNG_SHIP_TO_PTY_TX_PROF_ID NUMBER,
180 RDNG_SHIP_FROM_PTY_TX_PROF_ID NUMBER,
181 RDNG_BILL_TO_PTY_TX_PROF_ID NUMBER,
182 RDNG_BILL_FROM_PTY_TX_PROF_ID NUMBER,
183 RDNG_SHIP_TO_PTY_TX_P_ST_ID NUMBER,
184 RDNG_SHIP_FROM_PTY_TX_P_ST_ID NUMBER,
185 RDNG_BILL_TO_PTY_TX_P_ST_ID NUMBER,
186 RDNG_BILL_FROM_PTY_TX_P_ST_ID NUMBER,
187 ALLOW_MANUAL_LIN_RECALC_FLAG VARCHAR2(1),
188 ALLOW_MANUAL_LINES_FLAG VARCHAR2(1),
189 ALLOW_OVERRIDE_FLAG VARCHAR2(1),
190 ENFORCE_TAX_FROM_ACCT_FLAG VARCHAR2(1),
191 PERF_ADDNL_APPL_FOR_IMPRT_FLAG VARCHAR2(1),
192 ALLOW_OFFSET_TAX_CALC_FLAG VARCHAR2(1),
193 ALLOW_OFFSET_TAX_CODE_FLAG VARCHAR2(1),
194 SELF_ASSESS_TAX_LINES_FLAG VARCHAR2(1),
195 TAX_RECOVERY_FLAG VARCHAR2(1),
196 ALLOW_CANCEL_TAX_LINES_FLAG VARCHAR2(1),
197 ALLOW_MAN_TAX_ONLY_LINES_FLAG VARCHAR2(1),
198 TAX_VARIANCE_CALC_FLAG VARCHAR2(1),
199 RECORD_FLAG VARCHAR2(1),
200 QUOTE_FLAG VARCHAR2(1),
201 NORMAL_SIGN_FLAG VARCHAR2(1),
202 OVERRIDE_LEVEL VARCHAR2(30),
203 OFFSET_TAX_BASIS_CODE VARCHAR2(30),
204 TAX_TOLERANCE NUMBER,
205 TAX_TOL_AMT_RANGE NUMBER,
206 ENABLE_MRC_FLAG VARCHAR2(1),
207 TAX_REPORTING_FLAG VARCHAR2(1),
208 ENTER_OVRD_INCL_TAX_LINES_FLAG VARCHAR2(1),
209 CTRL_EFF_OVRD_CALC_LINES_FLAG VARCHAR2(1),
210 SUMMARIZATION_FLAG VARCHAR2(1),
211 RETAIN_SUMM_TAX_LINE_ID_FLAG VARCHAR2(1),
212 RECORD_FOR_PARTNERS_FLAG VARCHAR2(1),
213 MANUAL_LINES_FOR_PARTNER_FLAG VARCHAR2(1),
214 MAN_TAX_ONLY_LIN_FOR_PTNR_FLAG VARCHAR2(1),
215 ALWAYS_USE_EBTAX_FOR_CALC_FLAG VARCHAR2(1),
216 EVENT_ID NUMBER(15),
217 TAX_METHOD_CODE VARCHAR2(30),
218 INCLUSIVE_TAX_USED_FLAG VARCHAR2(1),
219 TAX_USE_CUSTOMER_EXEMPT_FLAG VARCHAR2(1),
220 TAX_USE_PRODUCT_EXEMPT_FLAG VARCHAR2(1),
221 TAX_USE_LOC_EXC_RATE_FLAG VARCHAR2(1),
222 TAX_ALLOW_COMPOUND_FLAG VARCHAR2(1),
223 USE_TAX_CLASSIFICATION_FLAG VARCHAR2(1),
224 ENFORCE_TAX_FROM_REF_DOC_FLAG VARCHAR2(1),
225 PROCESS_FOR_APPLICABILITY_FLAG VARCHAR2(1),
226 ALLOW_TAX_ROUNDING_OVRD_FLAG VARCHAR2(1),
227 HOME_COUNTRY_DEFAULT_FLAG VARCHAR2(1),
228 PROD_FAMILY_GRP_CODE VARCHAR2(30),
229 ESTABLISHMENT_ID NUMBER(15),
230 EXMPTN_PTY_BASIS_HIER_1_CODE VARCHAR2(30),
231 EXMPTN_PTY_BASIS_HIER_2_CODE VARCHAR2(30),
232 ALLOW_EXEMPTIONS_FLAG VARCHAR2(1),
233 SUP_CUST_ACCT_TYPE VARCHAR2(30),
234 TAX_CALCULATION_DONE_FLAG VARCHAR2(1),
235 INTGRTN_DET_FACTORS_UI_FLAG VARCHAR2(1),
236 DISPLAY_TAX_CLASSIF_FLAG VARCHAR2(1),
237 ICX_SESSION_ID NUMBER(15),
238 HEADER_LEVEL_CURRENCY_FLAG VARCHAR2(1),
239 SOURCE_EVENT_CLASS_MAPPING_ID NUMBER(15),
240 SOURCE_TAX_EVENT_CLASS_CODE VARCHAR2(30),
241 ASC_INTRCMP_TX_EVNT_CLS_CODE VARCHAR2(30),
242 INTRCMP_TX_EVNT_CLS_CODE VARCHAR2(30),
243 INTRCMP_SRC_APPLN_ID NUMBER,
244 INTRCMP_SRC_ENTITY_CODE VARCHAR2(30),
245 INTRCMP_SRC_EVNT_CLS_CODE VARCHAR2(30),
246 DEF_INTRCMP_TRX_BIZ_CATEGORY VARCHAR2(240),
247 SOURCE_PROCESS_FOR_APPL_FLAG VARCHAR2(1),
248 TEMPLATE_USAGE_CODE VARCHAR2(30)
249 );
250
251 TYPE sync_trx_rec_type IS RECORD
252 (APPLICATION_ID NUMBER,
253 ENTITY_CODE VARCHAR2(30),
254 EVENT_CLASS_CODE VARCHAR2(30),
255 EVENT_TYPE_CODE VARCHAR2(30),
256 TRX_ID NUMBER,
257 TRX_NUMBER VARCHAR2(150),
258 TRX_DESCRIPTION VARCHAR2(240),
259 TRX_COMMUNICATED_DATE DATE,
260 BATCH_SOURCE_ID NUMBER,
261 BATCH_SOURCE_NAME VARCHAR2(150),
262 DOC_SEQ_ID NUMBER,
263 DOC_SEQ_NAME VARCHAR2(150),
264 DOC_SEQ_VALUE VARCHAR2(240),
265 TRX_DUE_DATE DATE,
266 TRX_TYPE_DESCRIPTION VARCHAR2(240),
267 SUPPLIER_TAX_INVOICE_NUMBER VARCHAR2(150),
268 SUPPLIER_TAX_INVOICE_DATE DATE,
269 SUPPLIER_EXCHANGE_RATE NUMBER,
270 TAX_INVOICE_DATE DATE,
271 TAX_INVOICE_NUMBER VARCHAR2(150),
272 PORT_OF_ENTRY_CODE VARCHAR2(30),
273 APPLICATION_DOC_STATUS VARCHAR2(30)
274 );
275
276 TYPE sync_trx_lines_rec_type IS RECORD
277 (APPLICATION_ID NUMBER_tbl_type,
278 ENTITY_CODE VARCHAR2_30_tbl_type,
279 EVENT_CLASS_CODE VARCHAR2_30_tbl_type,
280 TRX_ID NUMBER_tbl_type,
281 TRX_LEVEL_TYPE VARCHAR2_30_tbl_type,
282 TRX_LINE_ID NUMBER_tbl_type,
283 TRX_WAYBILL_NUMBER VARCHAR2_50_tbl_type,
284 TRX_LINE_DESCRIPTION VARCHAR2_240_tbl_type,
285 PRODUCT_DESCRIPTION VARCHAR2_240_tbl_type,
286 TRX_LINE_GL_DATE DATE_tbl_TYPE,
287 MERCHANT_PARTY_NAME VARCHAR2_150_tbl_type,
291 MERCHANT_PARTY_TAX_REG_NUMBER VARCHAR2_150_tbl_type,
288 MERCHANT_PARTY_DOCUMENT_NUMBER VARCHAR2_150_tbl_type,
289 MERCHANT_PARTY_REFERENCE VARCHAR2_250_tbl_type,
290 MERCHANT_PARTY_TAXPAYER_ID VARCHAR2_150_tbl_type,
292 ASSET_NUMBER VARCHAR2_150_tbl_type
293 );
294 sync_trx_lines_tbl_type sync_trx_lines_rec_type;
295
296 TYPE distccid_det_facts_rec_type IS RECORD
297 (GL_DATE DATE,
298 TAX_RATE_ID NUMBER,
299 REC_RATE_ID NUMBER,
300 SELF_ASSESSED_FLAG VARCHAR2(1),
301 RECOVERABLE_FLAG VARCHAR2(1),
302 TAX_JURISDICTION_ID NUMBER,
303 TAX_REGIME_ID NUMBER,
304 TAX_ID NUMBER,
305 INTERNAL_ORGANIZATION_ID NUMBER,
306 REC_NREC_CCID NUMBER,
307 TAX_LIAB_CCID NUMBER,
308 TAX_STATUS_ID NUMBER,
309 REVENUE_EXPENSE_CCID NUMBER,
310 REC_NREC_TAX_DIST_ID NUMBER,
311 LEDGER_ID NUMBER,
312 ACCOUNT_SOURCE_TAX_RATE_ID NUMBER
313 );
314
315 TYPE header_det_factors_rec_type IS RECORD
316 (INTERNAL_ORGANIZATION_ID NUMBER,
317 APPLICATION_ID NUMBER,
318 ENTITY_CODE VARCHAR2(30),
319 EVENT_CLASS_CODE VARCHAR2(30),
320 EVENT_TYPE_CODE VARCHAR2(30),
321 INTERNAL_ORG_LOCATION_ID NUMBER,
322 LEGAL_ENTITY_ID NUMBER,
323 LEDGER_ID NUMBER,
324 TRX_ID NUMBER,
325 TRX_DATE DATE,
326 TRX_DOC_REVISION VARCHAR2(150),
327 TRX_CURRENCY_CODE VARCHAR2(30),
328 CURRENCY_CONVERSION_TYPE VARCHAR2(30),
329 CURRENCY_CONVERSION_RATE NUMBER,
330 CURRENCY_CONVERSION_DATE DATE,
331 MINIMUM_ACCOUNTABLE_UNIT NUMBER,
332 PRECISION NUMBER,
333 ROUNDING_SHIP_TO_PARTY_ID NUMBER,
334 ROUNDING_SHIP_FROM_PARTY_ID NUMBER,
335 ROUNDING_BILL_TO_PARTY_ID NUMBER,
336 ROUNDING_BILL_FROM_PARTY_ID NUMBER,
337 RNDG_SHIP_TO_PARTY_SITE_ID NUMBER,
338 RNDG_SHIP_FROM_PARTY_SITE_ID NUMBER,
339 RNDG_BILL_TO_PARTY_SITE_ID NUMBER,
340 RNDG_BILL_FROM_PARTY_SITE_ID NUMBER,
341 QUOTE_FLAG VARCHAR2(1),
342 ESTABLISHMENT_ID NUMBER,
343 RECEIVABLES_TRX_TYPE_ID NUMBER,
344 RELATED_DOC_APPLICATION_ID NUMBER ,
345 RELATED_DOC_ENTITY_CODE VARCHAR2(30) ,
346 RELATED_DOC_EVENT_CLASS_CODE VARCHAR2(30) ,
347 RELATED_DOC_TRX_ID NUMBER,
348 RELATED_DOC_NUMBER VARCHAR2(150),
349 RELATED_DOC_DATE DATE,
350 DEFAULT_TAXATION_COUNTRY VARCHAR2(2),
351 CTRL_TOTAL_HDR_TX_AMT NUMBER,
352 TRX_NUMBER VARCHAR2(150),
353 TRX_DESCRIPTION VARCHAR2(240),
354 TRX_COMMUNICATED_DATE DATE,
355 BATCH_SOURCE_ID NUMBER,
356 BATCH_SOURCE_NAME VARCHAR2(150),
357 DOC_SEQ_ID NUMBER,
358 DOC_SEQ_NAME VARCHAR2(150),
359 DOC_SEQ_VALUE VARCHAR2(240),
360 TRX_DUE_DATE DATE,
361 TRX_TYPE_DESCRIPTION VARCHAR2(240),
362 DOCUMENT_SUB_TYPE VARCHAR2(240) ,
363 SUPPLIER_TAX_INVOICE_NUMBER VARCHAR2(150),
364 SUPPLIER_TAX_INVOICE_DATE DATE,
365 SUPPLIER_EXCHANGE_RATE NUMBER,
366 TAX_INVOICE_DATE DATE,
367 TAX_INVOICE_NUMBER VARCHAR2(150),
368 FIRST_PTY_ORG_ID NUMBER,
369 TAX_EVENT_CLASS_CODE VARCHAR2(30),
370 TAX_EVENT_TYPE_CODE VARCHAR2(30),
371 DOC_EVENT_STATUS VARCHAR2(30),
372 RDNG_SHIP_TO_PTY_TX_PROF_ID NUMBER,
373 RDNG_SHIP_FROM_PTY_TX_PROF_ID NUMBER,
374 RDNG_BILL_TO_PTY_TX_PROF_ID NUMBER,
375 RDNG_BILL_FROM_PTY_TX_PROF_ID NUMBER,
376 RDNG_SHIP_TO_PTY_TX_P_ST_ID NUMBER,
377 RDNG_SHIP_FROM_PTY_TX_P_ST_ID NUMBER,
378 RDNG_BILL_TO_PTY_TX_P_ST_ID NUMBER,
379 RDNG_BILL_FROM_PTY_TX_P_ST_ID NUMBER,
380 PORT_OF_ENTRY_CODE VARCHAR2(30),
381 TAX_REPORTING_FLAG VARCHAR2(1),
382 PROVNL_TAX_DETERMINATION_DATE DATE,
383 SHIP_THIRD_PTY_ACCT_ID NUMBER,
384 BILL_THIRD_PTY_ACCT_ID NUMBER,
385 SHIP_THIRD_PTY_ACCT_SITE_ID NUMBER,
386 BILL_THIRD_PTY_ACCT_SITE_ID NUMBER,
387 SHIP_TO_CUST_ACCT_SITE_USE_ID NUMBER,
388 BILL_TO_CUST_ACCT_SITE_USE_ID NUMBER,
389 TRX_BATCH_ID NUMBER,
390 APPLIED_TO_TRX_NUMBER VARCHAR2(20),
391 APPLICATION_DOC_STATUS VARCHAR2(30),
392 SHIP_TO_PARTY_ID NUMBER,
393 SHIP_FROM_PARTY_ID NUMBER,
394 POA_PARTY_ID NUMBER,
395 POO_PARTY_ID NUMBER,
396 BILL_TO_PARTY_ID NUMBER,
397 BILL_FROM_PARTY_ID NUMBER,
398 MERCHANT_PARTY_ID NUMBER,
399 SHIP_TO_PARTY_SITE_ID NUMBER,
403 BILL_TO_PARTY_SITE_ID NUMBER,
400 SHIP_FROM_PARTY_SITE_ID NUMBER,
401 POA_PARTY_SITE_ID NUMBER,
402 POO_PARTY_SITE_ID NUMBER,
404 BILL_FROM_PARTY_SITE_ID NUMBER,
405 SHIP_TO_LOCATION_ID NUMBER,
406 SHIP_FROM_LOCATION_ID NUMBER,
407 POA_LOCATION_ID NUMBER,
408 POO_LOCATION_ID NUMBER,
409 BILL_TO_LOCATION_ID NUMBER,
410 BILL_FROM_LOCATION_ID NUMBER,
411 PAYING_PARTY_ID NUMBER,
412 OWN_HQ_PARTY_ID NUMBER,
413 TRADING_HQ_PARTY_ID NUMBER,
414 POI_PARTY_ID NUMBER,
415 POD_PARTY_ID NUMBER,
416 TITLE_TRANSFER_PARTY_ID NUMBER,
417 PAYING_PARTY_SITE_ID NUMBER,
418 OWN_HQ_PARTY_SITE_ID NUMBER,
419 TRADING_HQ_PARTY_SITE_ID NUMBER,
420 POI_PARTY_SITE_ID NUMBER,
421 POD_PARTY_SITE_ID NUMBER,
422 TITLE_TRANSFER_PARTY_SITE_ID NUMBER,
423 PAYING_LOCATION_ID NUMBER,
424 OWN_HQ_LOCATION_ID NUMBER,
425 TRADING_HQ_LOCATION_ID NUMBER,
426 POC_LOCATION_ID NUMBER,
427 POI_LOCATION_ID NUMBER,
428 POD_LOCATION_ID NUMBER,
429 TITLE_TRANSFER_LOCATION_ID NUMBER,
430 SHIP_TO_PARTY_TAX_PROF_ID NUMBER,
431 SHIP_FROM_PARTY_TAX_PROF_ID NUMBER,
432 POA_PARTY_TAX_PROF_ID NUMBER,
433 POO_PARTY_TAX_PROF_ID NUMBER,
434 PAYING_PARTY_TAX_PROF_ID NUMBER,
435 OWN_HQ_PARTY_TAX_PROF_ID NUMBER,
436 TRADING_HQ_PARTY_TAX_PROF_ID NUMBER,
437 POI_PARTY_TAX_PROF_ID NUMBER,
438 POD_PARTY_TAX_PROF_ID NUMBER,
439 BILL_TO_PARTY_TAX_PROF_ID NUMBER,
440 BILL_FROM_PARTY_TAX_PROF_ID NUMBER,
441 TITLE_TRANS_PARTY_TAX_PROF_ID NUMBER,
442 SHIP_TO_SITE_TAX_PROF_ID NUMBER,
443 SHIP_FROM_SITE_TAX_PROF_ID NUMBER,
444 POA_SITE_TAX_PROF_ID NUMBER,
445 POO_SITE_TAX_PROF_ID NUMBER,
446 PAYING_SITE_TAX_PROF_ID NUMBER,
447 OWN_HQ_SITE_TAX_PROF_ID NUMBER,
448 TRADING_HQ_SITE_TAX_PROF_ID NUMBER,
449 POI_SITE_TAX_PROF_ID NUMBER,
450 POD_SITE_TAX_PROF_ID NUMBER,
451 BILL_TO_SITE_TAX_PROF_ID NUMBER,
452 BILL_FROM_SITE_TAX_PROF_ID NUMBER,
453 TITLE_TRANS_SITE_TAX_PROF_ID NUMBER,
454 MERCHANT_PARTY_TAX_PROF_ID NUMBER,
455 HQ_ESTB_PARTY_TAX_PROF_ID NUMBER
456 );
457
458
459
460 /*Bug 2867448 - To be commented out until reolution on product integration extensible parameters
461 TYPE ext_param_rec_type IS RECORD
462 (APPLICATION_ID NUMBER,
463 ENTITY_CODE VARCHAR2(80),
464 EVENT_CLASS_CODE VARCHAR2(80),
465 TRX_ID NUMBER,
466 HDR_TRX_USER_KEY1 VARCHAR2(150),
467 HDR_TRX_USER_KEY2 VARCHAR2(150),
468 HDR_TRX_USER_KEY3 VARCHAR2(150),
469 HDR_TRX_USER_KEY4 VARCHAR2(150),
470 HDR_TRX_USER_KEY5 VARCHAR2(150),
471 HDR_TRX_USER_KEY6 VARCHAR2(150),
472 LINE_TRX_USER_KEY1 VARCHAR2(150),
473 LINE_TRX_USER_KEY2 VARCHAR2(150),
474 LINE_TRX_USER_KEY3 VARCHAR2(150),
475 LINE_TRX_USER_KEY4 VARCHAR2(150),
476 LINE_TRX_USER_KEY5 VARCHAR2(150),
477 LINE_TRX_USER_KEY6 VARCHAR2(150),
478 TRX_LINE_ID NUMBER,
479 TRX_LINE_DIST_ID NUMBER,
480 NUMERIC1 NUMBER,
481 NUMERIC2 NUMBER,
482 NUMERIC3 NUMBER,
483 NUMERIC4 NUMBER,
484 NUMERIC5 NUMBER,
485 NUMERIC6 NUMBER,
486 NUMERIC7 NUMBER,
487 NUMERIC8 NUMBER,
488 NUMERIC9 NUMBER,
489 NUMERIC10 NUMBER,
490 CHAR1 VARCHAR2(150),
491 CHAR2 VARCHAR2(150),
492 CHAR3 VARCHAR2(150),
493 CHAR4 VARCHAR2(150),
494 CHAR5 VARCHAR2(150),
495 CHAR6 VARCHAR2(150),
496 CHAR7 VARCHAR2(150),
497 CHAR8 VARCHAR2(150),
498 CHAR9 VARCHAR2(150),
499 CHAR10 VARCHAR2(150),
500 DATE1 DATE,
501 DATE2 DATE,
502 DATE3 DATE,
503 DATE4 DATE,
504 DATE5 DATE,
505 DATE6 DATE,
506 DATE7 DATE,
507 DATE8 DATE,
508 DATE9 DATE,
509 DATE10 DATE
510 );
511
512 TYPE ext_param_tbl_type IS TABLE OF ext_param_rec_type
516 TYPE context_info_rec_type IS RECORD (
513 INDEX BY BINARY_INTEGER;
514 */
515
517 APPLICATION_ID NUMBER,
518 ENTITY_CODE VARCHAR2(30),
519 EVENT_CLASS_CODE VARCHAR2(30),
520 TRX_ID NUMBER,
521 TRX_LINE_ID NUMBER ,
522 TRX_LEVEL_TYPE VARCHAR2(30),
523 SUMMARY_TAX_LINE_NUMBER NUMBER ,
524 TAX_LINE_ID NUMBER,
525 TRX_LINE_DIST_ID NUMBER
526 );
527
528 --Bug 3581953 - Create record of tables to facilitate bulk inserts
529 TYPE errors_rec_type is RECORD (
530 APPLICATION_ID NUMBER_tbl_type,
531 ENTITY_CODE VARCHAR2_30_tbl_type,
532 EVENT_CLASS_CODE VARCHAR2_30_tbl_type,
533 TRX_ID NUMBER_tbl_type,
534 TRX_LINE_ID NUMBER_tbl_type,
535 SUMMARY_TAX_LINE_NUMBER NUMBER_tbl_type,
536 TAX_LINE_ID NUMBER_tbl_type,
537 TRX_LEVEL_TYPE VARCHAR2_30_tbl_type,
538 TRX_LINE_DIST_ID NUMBER_tbl_type,
539 MESSAGE_TEXT VARCHAR2_2000_tbl_type
540 );
541 errors_tbl errors_rec_type;
542
543 TYPE pa_item_info_rec_type IS RECORD(
544 APPLICATION_ID ZX_REC_NREC_DIST.application_id%TYPE,
545 ENTITY_CODE ZX_REC_NREC_DIST.entity_code%TYPE,
546 EVENT_CLASS_CODE ZX_REC_NREC_DIST.entity_code%TYPE,
547 TRX_ID ZX_REC_NREC_DIST.trx_id%TYPE,
548 TRX_LINE_ID ZX_REC_NREC_DIST.trx_line_id%TYPE,
549 TRX_LEVEL_TYPE ZX_REC_NREC_DIST.trx_level_type%TYPE,
550 ITEM_EXPENSE_DIST_ID ZX_REC_NREC_DIST.trx_line_dist_id %TYPE,
551 NEW_ACCOUNT_CCID ZX_REC_NREC_DIST.account_ccid%TYPE,
552 NEW_ACCOUNT_STRING ZX_REC_NREC_DIST.account_string%TYPE,
553 NEW_PROJECT_ID ZX_REC_NREC_DIST.project_id %TYPE,
554 NEW_TASK_ID ZX_REC_NREC_DIST.task_id%TYPE,
555 RECOVERABILITY_AFFECTED BOOLEAN
556 );
557 TYPE pa_item_info_tbl_type is table of pa_item_info_rec_type
558 INDEX BY BINARY_INTEGER;
559
560 TYPE det_fact_defaulting_rec_type is RECORD (
561 APPLICATION_ID NUMBER,
562 ENTITY_CODE VARCHAR2(30),
563 EVENT_CLASS_CODE VARCHAR2(30),
564 ORG_ID NUMBER,
565 ITEM_ID NUMBER,
566 ITEM_ORG_ID NUMBER,
567 COUNTRY_CODE VARCHAR2(2),
568 EFFECTIVE_DATE DATE,
569 TRX_ID NUMBER,
570 TRX_LINE_ID NUMBER,
571 TRX_LEVEL_TYPE NUMBER,
572 TRX_DATE DATE,
573 LEDGER_ID NUMBER,
574 SHIP_FROM_PARTY_ID NUMBER,
575 SHIP_TO_PARTY_ID NUMBER,
576 BILL_TO_PARTY_ID NUMBER,
577 SHIP_FROM_PTY_SITE_ID NUMBER,
578 SHIP_TO_LOCATION_ID NUMBER,
579 SHIP_TO_ACCT_SITE_USE_ID NUMBER,
580 BILL_TO_ACCT_SITE_USE_ID NUMBER,
581 ACCOUNT_CCID NUMBER,
582 ACCOUNT_STRING VARCHAR2(2000),
583 TRX_TYPE_ID NUMBER,
584 SHIP_THIRD_PTY_ACCT_ID NUMBER,
585 BILL_THIRD_PTY_ACCT_ID NUMBER,
586 DEFAULTING_ATTRIBUTE1 VARCHAR2(150),
587 DEFAULTING_ATTRIBUTE2 VARCHAR2(150),
588 DEFAULTING_ATTRIBUTE3 VARCHAR2(150),
589 DEFAULTING_ATTRIBUTE4 VARCHAR2(150),
590 DEFAULTING_ATTRIBUTE5 VARCHAR2(150),
591 DEFAULTING_ATTRIBUTE6 VARCHAR2(150),
592 DEFAULTING_ATTRIBUTE7 VARCHAR2(150),
593 DEFAULTING_ATTRIBUTE8 VARCHAR2(150),
594 DEFAULTING_ATTRIBUTE9 VARCHAR2(150),
595 DEFAULTING_ATTRIBUTE10 VARCHAR2(150),
596 REF_DOC_APPLICATION_ID NUMBER,
597 REF_DOC_ENTITY_CODE VARCHAR2(30),
598 REF_DOC_EVENT_CLASS_CODE VARCHAR2(30),
599 REF_DOC_TRX_ID NUMBER,
600 REF_DOC_LINE_ID NUMBER,
601 REF_DOC_TRX_LEVEL_TYPE VARCHAR2(30),
602 LEGAL_ENTITY_ID NUMBER,
603 SOURCE_EVENT_CLASS_CODE VARCHAR2(30)
604 );
605
606
607 TYPE def_tax_cls_code_info_rec_type IS RECORD (
608 APPLICATION_ID NUMBER,
609 ENTITY_CODE VARCHAR2(30),
610 EVENT_CLASS_CODE VARCHAR2(30),
611 INTERNAL_ORGANIZATION_ID NUMBER,
612 TRX_ID NUMBER,
613 TRX_LINE_ID NUMBER,
614 TRX_LEVEL_TYPE VARCHAR2(30),
615 LEDGER_ID NUMBER(15),
616 TRX_DATE DATE,
617 REF_DOC_APPLICATION_ID NUMBER,
618 REF_DOC_ENTITY_CODE VARCHAR2(30),
619 REF_DOC_EVENT_CLASS_CODE VARCHAR2(30),
620 REF_DOC_TRX_ID NUMBER,
621 REF_DOC_LINE_ID NUMBER,
622 REF_DOC_TRX_LEVEL_TYPE VARCHAR2(30),
623 ACCOUNT_CCID NUMBER,
624 ACCOUNT_STRING VARCHAR2(2000),
625 PRODUCT_ID NUMBER,
626 PRODUCT_ORG_ID NUMBER,
627 RECEIVABLES_TRX_TYPE_ID NUMBER,
628 SHIP_THIRD_PTY_ACCT_ID NUMBER,
629 BILL_THIRD_PTY_ACCT_ID NUMBER,
630 SHIP_THIRD_PTY_ACCT_SITE_ID NUMBER,
631 BILL_THIRD_PTY_ACCT_SITE_ID NUMBER,
632 SHIP_TO_CUST_ACCT_SITE_USE_ID NUMBER,
636 DEFAULTING_ATTRIBUTE2 VARCHAR2(150),
633 BILL_TO_CUST_ACCT_SITE_USE_ID NUMBER,
634 SHIP_TO_LOCATION_ID NUMBER,
635 DEFAULTING_ATTRIBUTE1 VARCHAR2(150),
637 DEFAULTING_ATTRIBUTE3 VARCHAR2(150),
638 DEFAULTING_ATTRIBUTE4 VARCHAR2(150),
639 DEFAULTING_ATTRIBUTE5 VARCHAR2(150),
640 DEFAULTING_ATTRIBUTE6 VARCHAR2(150),
641 DEFAULTING_ATTRIBUTE7 VARCHAR2(150),
642 DEFAULTING_ATTRIBUTE8 VARCHAR2(150),
643 DEFAULTING_ATTRIBUTE9 VARCHAR2(150),
644 DEFAULTING_ATTRIBUTE10 VARCHAR2(150),
645 TAX_USER_OVERRIDE_FLAG VARCHAR2(1),
646 OVERRIDDEN_TAX_CLS_CODE VARCHAR2(30),
647 LEGAL_ENTITY_ID NUMBER,
648 INPUT_TAX_CLASSIFICATION_CODE VARCHAR2(50),
649 OUTPUT_TAX_CLASSIFICATION_CODE VARCHAR2(50),
650 X_TAX_CLASSIFICATION_CODE VARCHAR2(50),
651 X_ALLOW_TAX_CODE_OVERRIDE_FLAG VARCHAR2(1)
652 );
653
654 TYPE hold_codes_tbl_type IS TABLE OF varchar2(80)
655 INDEX BY BINARY_INTEGER;
656
657 TYPE validation_status_tbl_type IS TABLE OF varchar2(80)
658 INDEX BY BINARY_INTEGER;
659
660 TYPE tax_dist_id_tbl_type IS TABLE OF zx_rec_nrec_dist.REC_NREC_TAX_DIST_ID%type
661 INDEX BY BINARY_INTEGER;
662
663 /* =======================================================================*
664 | PROCEDURE set_tax_security_context : Sets the security context based |
665 | on OU and LE of transaction |
666 * =======================================================================*/
667
668 PROCEDURE set_tax_security_context
669 (
670 p_api_version IN NUMBER,
671 p_init_msg_list IN VARCHAR2,
672 p_commit IN VARCHAR2,
673 p_validation_level IN NUMBER,
674 x_return_status OUT NOCOPY VARCHAR2,
675 x_msg_count OUT NOCOPY NUMBER ,
676 x_msg_data OUT NOCOPY VARCHAR2,
677 p_internal_org_id IN NUMBER,
678 p_legal_entity_id IN NUMBER,
679 p_transaction_date IN DATE,
680 p_related_doc_date IN DATE,
681 p_adjusted_doc_date IN DATE,
682 x_effective_date OUT NOCOPY DATE
683 );
684
685
686 /* =======================================================================*
687 | Overloaded PROCEDURE set_tax_security_context: for Lease Management |
688 | Also includes setting the date based on provnl_tax_determination_date |
689 * =======================================================================*/
690
691 PROCEDURE set_tax_security_context
692 (
693 p_api_version IN NUMBER,
694 p_init_msg_list IN VARCHAR2,
695 p_commit IN VARCHAR2,
696 p_validation_level IN NUMBER,
697 x_return_status OUT NOCOPY VARCHAR2,
698 x_msg_count OUT NOCOPY NUMBER,
699 x_msg_data OUT NOCOPY VARCHAR2,
700 p_internal_org_id IN NUMBER,
701 p_legal_entity_id IN NUMBER,
702 p_transaction_date IN DATE,
703 p_related_doc_date IN DATE,
704 p_adjusted_doc_date IN DATE,
705 p_provnl_tax_det_date IN DATE,
706 x_effective_date OUT NOCOPY DATE
707 );
708
709 /* ======================================================================*
710 | PROCEDURE calculate_tax : Calculates and records tax info |
711 | This API accepts information in both pl/sql as well as GTT |
712 | This API also supports processing for multiple event classes |
713 | GTT involved : ZX_TRANSACTION_HEADERS_GT, ZX_TRANSACTION_LINES_GT |
714 * ======================================================================*/
715
716 PROCEDURE calculate_tax
717 (
718 p_api_version IN NUMBER,
719 p_init_msg_list IN VARCHAR2,
720 p_commit IN VARCHAR2,
721 p_validation_level IN NUMBER,
722 x_return_status OUT NOCOPY VARCHAR2,
723 x_msg_count OUT NOCOPY NUMBER,
724 x_msg_data OUT NOCOPY VARCHAR2
725 );
726
727
728 /*======================================================================*
729 | PROCEDURE calculate_tax : Calculates and records tax info |
730 | This API accepts information in both pl/sql as well as GTT |
731 | This API also supports processing for multiple event classes |
732 | PL/sql tables: trx_line_dist_tbl , transaction_rec |
733 * ======================================================================*/
734 PROCEDURE calculate_tax
735 (
736 p_api_version IN NUMBER,
737 p_init_msg_list IN VARCHAR2,
738 p_commit IN VARCHAR2,
739 p_validation_level IN NUMBER,
740 x_return_status OUT NOCOPY VARCHAR2 ,
741 x_msg_count OUT NOCOPY NUMBER ,
742 x_msg_data OUT NOCOPY VARCHAR2,
743 p_transaction_rec IN transaction_rec_type,
747 );
744 p_quote_flag IN VARCHAR2,
745 p_data_transfer_mode IN VARCHAR2,
746 x_doc_level_recalc_flag OUT NOCOPY VARCHAR2
748
749 /* ======================================================================*
750 | PROCEDURE import_document_with_tax : Imports document with tax |
751 | This API also supports processing for multiple event classes |
752 | GTT involved : ZX_TRANSACTION_HEADERS_GT, ZX_TRANSACTION_LINES_GT , |
753 | ZX_IMPORT_TAX_LINES_GT and ZX_TRX_TAX_LINK_GT |
754 * ======================================================================*/
755
756 PROCEDURE import_document_with_tax
757 (
758 p_api_version IN NUMBER,
759 p_init_msg_list IN VARCHAR2,
760 p_commit IN VARCHAR2,
761 p_validation_level IN NUMBER,
762 x_return_status OUT NOCOPY VARCHAR2,
763 x_msg_count OUT NOCOPY NUMBER,
764 x_msg_data OUT NOCOPY VARCHAR2
765 );
766
767
768 /* ======================================================================*
769 | PROCEDURE synchronize_tax_repository : Updates tax repository |
770 | GTT involved : ZX_TRX_HEADERS_GT and ZX_SYNC_TRX_LINES_GT |
771 * ======================================================================*/
772
773 PROCEDURE synchronize_tax_repository
774 (
775 p_api_version IN NUMBER,
776 p_init_msg_list IN VARCHAR2,
777 p_commit IN VARCHAR2,
778 p_validation_level IN NUMBER,
779 x_return_status OUT NOCOPY VARCHAR2,
780 x_msg_count OUT NOCOPY NUMBER,
781 x_msg_data OUT NOCOPY VARCHAR2,
782 p_sync_trx_rec IN sync_trx_rec_type,
783 p_sync_trx_lines_tbl IN sync_trx_lines_tbl_type%type
784 );
785
786 /* ======================================================================*
787 | PROCEDURE override_tax : Overrides tax lines |
788 * ======================================================================*/
789
790 PROCEDURE override_tax
791 (
792 p_api_version IN NUMBER,
793 p_init_msg_list IN VARCHAR2,
794 p_commit IN VARCHAR2,
795 p_validation_level IN NUMBER,
796 x_return_status OUT NOCOPY VARCHAR2,
797 x_msg_count OUT NOCOPY NUMBER,
798 x_msg_data OUT NOCOPY VARCHAR2,
799 p_transaction_rec IN transaction_rec_type,
800 p_override_level IN VARCHAR2,
801 p_event_id IN NUMBER
802 );
803
804
805 /* ======================================================================*
806 | PROCEDURE global_document_update : |
807 * ======================================================================*/
808
809 PROCEDURE global_document_update
810 (
811 p_api_version IN NUMBER,
812 p_init_msg_list IN VARCHAR2,
813 p_commit IN VARCHAR2,
814 p_validation_level IN NUMBER,
815 x_return_status OUT NOCOPY VARCHAR2,
816 x_msg_count OUT NOCOPY NUMBER,
817 x_msg_data OUT NOCOPY VARCHAR2,
818 p_transaction_rec IN OUT NOCOPY transaction_rec_type
819 );
820
821
822 /* ======================================================================*
823 | Overloaded PROCEDURE global_document_update for release holds |
824 * ======================================================================*/
825
826 PROCEDURE global_document_update
827 (
828 p_api_version IN NUMBER,
829 p_init_msg_list IN VARCHAR2,
830 p_commit IN VARCHAR2,
831 p_validation_level IN NUMBER,
832 x_return_status OUT NOCOPY VARCHAR2,
833 x_msg_count OUT NOCOPY NUMBER,
834 x_msg_data OUT NOCOPY VARCHAR2,
835 p_transaction_rec IN OUT NOCOPY transaction_rec_type,
836 p_validation_status IN ZX_API_PUB.validation_status_tbl_type
837 );
838
839
840 /* ======================================================================*
841 | PROCEDURE mark_tax_lines_deleted : |
842 * ======================================================================*/
843
844 PROCEDURE mark_tax_lines_deleted
845 (
846 p_api_version IN NUMBER,
847 p_init_msg_list IN VARCHAR2,
848 p_commit IN VARCHAR2,
849 p_validation_level IN NUMBER,
850 x_return_status OUT NOCOPY VARCHAR2,
851 x_msg_count OUT NOCOPY NUMBER,
852 x_msg_data OUT NOCOPY VARCHAR2,
856
853 p_transaction_line_rec IN OUT NOCOPY transaction_line_rec_type
854 );
855
857 /* ======================================================================*
858 | PROCEDURE reverse_document : Reverses the base document |
859 | GTT involved : ZX_REV_TRX_HEADERS_GT, ZX_REVERSE_TRX_LINES_GT |
860 * ======================================================================*/
861 PROCEDURE reverse_document
862 (
863 p_api_version IN NUMBER,
864 p_init_msg_list IN VARCHAR2,
865 p_commit IN VARCHAR2,
866 p_validation_level IN NUMBER,
867 x_return_status OUT NOCOPY VARCHAR2,
868 x_msg_count OUT NOCOPY NUMBER ,
869 x_msg_data OUT NOCOPY VARCHAR2
870 );
871
872 /* ================================================================================*
873 | PROCEDURE Reverse_document_distribution: Reverses the base reversing event class|
874 | GTT involved : ZX_REV_TRX_HEADERS_GT, ZX_REVERSE_TRX_LINES_GT |
875 * ================================================================================*/
876
877 PROCEDURE reverse_document_distribution
878 (
879 p_api_version IN NUMBER,
880 p_init_msg_list IN VARCHAR2,
881 p_commit IN VARCHAR2,
882 p_validation_level IN NUMBER,
883 x_return_status OUT NOCOPY VARCHAR2,
884 x_msg_count OUT NOCOPY NUMBER,
885 x_msg_data OUT NOCOPY VARCHAR2
886 );
887
888
889
890 /* ======================================================================*
891 | PROCEDURE Reverse_distributions : Reverses the base distribution |
892 | GTT involved : ZX_REVERSE_DIST_GT |
893 * ======================================================================*/
894
895 PROCEDURE reverse_distributions
896 (
897 p_api_version IN NUMBER,
898 p_init_msg_list IN VARCHAR2,
899 p_commit IN VARCHAR2,
900 p_validation_level IN NUMBER,
901 x_return_status OUT NOCOPY VARCHAR2,
902 x_msg_count OUT NOCOPY NUMBER,
903 x_msg_data OUT NOCOPY VARCHAR2
904 );
905
906
907 /* =======================================================================*
908 | PROCEDURE determine_recovery : Calculate the distribution of tax amounts
909 | into recoverable and/or non-recoverable tax amounts. |
910 | This API also supports processing for multiple event classes |
911 | GTT involved : ZX_TRANSACTION_HEADERS_GT, ZX_ITM_DISTRIBUTIONS_GT |
912 * =======================================================================*/
913
914 PROCEDURE determine_recovery
915 (
916 p_api_version IN NUMBER,
917 p_init_msg_list IN VARCHAR2,
918 p_commit IN VARCHAR2,
919 p_validation_level IN NUMBER,
920 x_return_status OUT NOCOPY VARCHAR2,
921 x_msg_count OUT NOCOPY NUMBER,
922 x_msg_data OUT NOCOPY VARCHAR2
923 );
924
925
926 /* =======================================================================*
927 | PROCEDURE override_recovery :Overrides the tax recovery rate code |
928 | |
929 * =======================================================================*/
930
931 PROCEDURE override_recovery
932 (
933 p_api_version IN NUMBER,
934 p_init_msg_list IN VARCHAR2,
935 p_commit IN VARCHAR2,
936 p_validation_level IN NUMBER,
937 x_return_status OUT NOCOPY VARCHAR2,
938 x_msg_count OUT NOCOPY NUMBER,
939 x_msg_data OUT NOCOPY VARCHAR2,
940 p_transaction_rec IN OUT NOCOPY transaction_rec_type
941 );
942
943 /* =======================================================================*
944 | PROCEDURE freeze_tax_distributions : |
945 * =======================================================================*/
946
947 PROCEDURE freeze_tax_distributions
948 (
949 p_api_version IN NUMBER,
950 p_init_msg_list IN VARCHAR2,
951 p_commit IN VARCHAR2,
952 p_validation_level IN NUMBER,
953 x_return_status OUT NOCOPY VARCHAR2,
954 x_msg_count OUT NOCOPY NUMBER,
955 x_msg_data OUT NOCOPY VARCHAR2,
956 p_transaction_rec IN OUT NOCOPY transaction_rec_type
957 );
958
959 /* ======================================================================*
960 | PROCEDURE get_tax_distribution_ccids : Products call this API if they |
961 | need to determine the code |
965 * ======================================================================*/
962 | combination identifiers for |
963 | tax liability and tax recovery/|
964 | nonrecovery accounts |
966
967 PROCEDURE get_tax_distribution_ccids
968 (
969 p_api_version IN NUMBER,
970 p_init_msg_list IN VARCHAR2,
971 p_commit IN VARCHAR2,
972 p_validation_level IN NUMBER,
973 x_return_status OUT NOCOPY VARCHAR2,
974 x_msg_count OUT NOCOPY NUMBER,
975 x_msg_data OUT NOCOPY VARCHAR2,
976 p_dist_ccid_rec IN OUT NOCOPY distccid_det_facts_rec_type
977 );
978
979
980 /* ===================================================================================*
981 | PROCEDURE Update_tax_dist_gl_date : Updates gl date of a list of Tax Distributions |
982 | GTT involved : ZX_TAX_DIST_ID_GT |
983 * ====================================================================================*/
984
985 PROCEDURE update_tax_dist_gl_date
986 (
987 p_api_version IN NUMBER,
988 p_init_msg_list IN VARCHAR2,
989 p_commit IN VARCHAR2,
990 p_validation_level IN NUMBER,
991 x_return_status OUT NOCOPY VARCHAR2,
992 x_msg_count OUT NOCOPY NUMBER,
993 x_msg_data OUT NOCOPY VARCHAR2,
994 p_gl_date IN DATE
995 );
996
997 /* =====================================================================*
998 | PROCEDURE Update_exchange_rate : Updates Exchange Rate |
999 | This is the GTT version |
1000 | There exists only pl/sql version of API |
1001 ========================================================================*/
1002
1003 PROCEDURE update_exchange_rate
1004 (
1005 p_api_version IN NUMBER,
1006 p_init_msg_list IN VARCHAR2,
1007 p_commit IN VARCHAR2,
1008 p_validation_level IN NUMBER,
1009 x_return_status OUT NOCOPY VARCHAR2,
1010 x_msg_count OUT NOCOPY NUMBER,
1011 x_msg_data OUT NOCOPY VARCHAR2,
1012 p_transaction_rec IN transaction_rec_type,
1013 p_curr_conv_rate IN NUMBER,
1014 p_curr_conv_date IN DATE,
1015 p_curr_conv_type IN VARCHAR2
1016 );
1017
1018 /* =======================================================================*
1019 | PROCEDURE validate_document_for_tax for Receivables Autoinvoice |
1020 | and recurring invoice. |
1021 | Bug 5518807 |
1022 * =======================================================================*/
1023
1024 PROCEDURE validate_document_for_tax
1025 (
1026 p_api_version IN NUMBER,
1027 p_init_msg_list IN VARCHAR2 ,
1028 p_commit IN VARCHAR2,
1029 p_validation_level IN NUMBER,
1030 x_return_status OUT NOCOPY VARCHAR2 ,
1031 x_msg_count OUT NOCOPY NUMBER ,
1032 x_msg_data OUT NOCOPY VARCHAR2
1033 );
1034
1035 /* =======================================================================*
1036 | PROCEDURE validate_document_for_tax : |
1037 * =======================================================================*/
1038
1039 PROCEDURE validate_document_for_tax
1040 (
1041 p_api_version IN NUMBER,
1042 p_init_msg_list IN VARCHAR2,
1043 p_commit IN VARCHAR2,
1044 p_validation_level IN NUMBER,
1045 x_return_status OUT NOCOPY VARCHAR2,
1046 x_msg_count OUT NOCOPY NUMBER,
1047 x_msg_data OUT NOCOPY VARCHAR2,
1048 p_transaction_rec IN OUT NOCOPY transaction_rec_type,
1049 x_validation_status OUT NOCOPY VARCHAR2,
1050 x_hold_codes_tbl OUT NOCOPY zx_api_pub.hold_codes_tbl_type
1051 );
1052
1053
1054 /* =======================================================================*
1055 | PROCEDURE validate_and_default_tax_attr : |
1056 | This api supports multiple document processing |
1057 * =======================================================================*/
1058
1059 PROCEDURE validate_and_default_tax_attr
1060 (
1061 p_api_version IN NUMBER,
1062 p_init_msg_list IN VARCHAR2,
1063 p_commit IN VARCHAR2,
1064 p_validation_level IN NUMBER,
1065 x_return_status OUT NOCOPY VARCHAR2,
1069
1066 x_msg_count OUT NOCOPY NUMBER,
1067 x_msg_data OUT NOCOPY VARCHAR2
1068 );
1070
1071 /* ============================================================================*
1072 | PROCEDURE get_default_tax_line_attribs : default the tax status and tax rate|
1073 | based on the tax regime and tax |
1074 * ===========================================================================*/
1075
1076 PROCEDURE get_default_tax_line_attribs
1077 (
1078 p_api_version IN NUMBER,
1079 p_init_msg_list IN VARCHAR2,
1080 p_commit IN VARCHAR2,
1081 p_validation_level IN NUMBER,
1082 x_return_status OUT NOCOPY VARCHAR2,
1083 x_msg_count OUT NOCOPY NUMBER,
1084 x_msg_data OUT NOCOPY VARCHAR2,
1085 p_tax_regime_code IN VARCHAR2,
1086 p_tax IN VARCHAR2,
1087 p_effective_date IN DATE,
1088 x_tax_status_code OUT NOCOPY VARCHAR2,
1089 x_tax_rate_code OUT NOCOPY VARCHAR2
1090 ) ;
1091
1092 /* ================================================================================*
1093 | PROCEDURE get_default_tax_det_attribs : default the fiscal classification values|
1094 * ===============================================================================*/
1095
1096 PROCEDURE get_default_tax_det_attribs
1097 (
1098 p_api_version IN NUMBER,
1099 p_init_msg_list IN VARCHAR2,
1100 p_commit IN VARCHAR2,
1101 p_validation_level IN NUMBER,
1102 x_return_status OUT NOCOPY VARCHAR2,
1103 x_msg_count OUT NOCOPY NUMBER,
1104 x_msg_data OUT NOCOPY VARCHAR2,
1105 p_application_id IN NUMBER,
1106 p_entity_code IN VARCHAR2,
1107 p_event_class_code IN VARCHAR2,
1108 p_org_id IN NUMBER,
1109 p_item_id IN NUMBER,
1110 p_country_code IN VARCHAR2,
1111 p_effective_date IN DATE,
1112 x_trx_biz_category OUT NOCOPY VARCHAR2,
1113 x_intended_use OUT NOCOPY VARCHAR2,
1114 x_prod_category OUT NOCOPY VARCHAR2,
1115 x_prod_fisc_class_code OUT NOCOPY VARCHAR2,
1116 x_product_type OUT NOCOPY VARCHAR2
1117 ) ;
1118
1119 /* ================================================================================*
1120 | PROCEDURE get_default_tax_det_attribs : default the fiscal classification values|
1121 * ===============================================================================*/
1122
1123 PROCEDURE get_default_tax_det_attribs
1124 (
1125 p_api_version IN NUMBER,
1126 p_init_msg_list IN VARCHAR2,
1127 p_commit IN VARCHAR2,
1128 p_validation_level IN NUMBER,
1129 x_return_status OUT NOCOPY VARCHAR2,
1130 x_msg_count OUT NOCOPY NUMBER,
1131 x_msg_data OUT NOCOPY VARCHAR2,
1132 p_application_id IN NUMBER,
1133 p_entity_code IN VARCHAR2,
1134 p_event_class_code IN VARCHAR2,
1135 p_org_id IN NUMBER,
1136 p_item_id IN NUMBER,
1137 p_country_code IN VARCHAR2,
1138 p_effective_date IN DATE,
1139 p_source_event_class_code IN VARCHAR2,
1140 x_trx_biz_category OUT NOCOPY VARCHAR2,
1141 x_intended_use OUT NOCOPY VARCHAR2,
1142 x_prod_category OUT NOCOPY VARCHAR2,
1143 x_prod_fisc_class_code OUT NOCOPY VARCHAR2,
1144 x_product_type OUT NOCOPY VARCHAR2,
1145 p_inventory_org_id IN NUMBER DEFAULT NULL
1146 ) ;
1147
1148 /* =============================================================================*
1149 | PROCEDURE Discard_tax_only_lines : Called when the whole document containing|
1150 | tax only lines is cancelled |
1151 * =============================================================================*/
1152
1153 PROCEDURE discard_tax_only_lines
1154 (
1155 p_api_version IN NUMBER,
1156 p_init_msg_list IN VARCHAR2,
1157 p_commit IN VARCHAR2,
1158 p_validation_level IN NUMBER,
1159 x_return_status OUT NOCOPY VARCHAR2,
1160 x_msg_count OUT NOCOPY NUMBER,
1161 x_msg_data OUT NOCOPY VARCHAR2,
1162 p_transaction_rec IN transaction_rec_type
1163 );
1164
1165
1166 /* =======================================================================*
1167 | FUNCTION determine_effective_date : |
1168 | |
1169 * =======================================================================*/
1170
1171 FUNCTION determine_effective_date
1175 p_adjusted_doc_date IN DATE
1172 (
1173 p_transaction_date IN DATE,
1174 p_related_doc_date IN DATE,
1176 ) RETURN DATE;
1177
1178
1179
1180 /* ==========================================================================*
1181 | PROCEDURE rollback_for_tax : Communicate to the Tax Partners to rollback|
1182 | transactions in their system |
1183 * =========================================================================*/
1184
1185 PROCEDURE rollback_for_tax
1186 (
1187 p_api_version IN NUMBER,
1188 p_init_msg_list IN VARCHAR2,
1189 p_commit IN VARCHAR2,
1190 p_validation_level IN NUMBER,
1191 x_return_status OUT NOCOPY VARCHAR2,
1192 x_msg_count OUT NOCOPY NUMBER,
1193 x_msg_data OUT NOCOPY VARCHAR2
1194 );
1195
1196 /* ========================================================================*
1197 | PROCEDURE commit_for_tax : Communicate to the Tax Partners to commit |
1198 | transactions in their system |
1199 * =======================================================================*/
1200
1201 PROCEDURE commit_for_tax
1202 (
1203 p_api_version IN NUMBER,
1204 p_init_msg_list IN VARCHAR2,
1205 p_commit IN VARCHAR2,
1206 p_validation_level IN NUMBER,
1207 x_return_status OUT NOCOPY VARCHAR2,
1208 x_msg_count OUT NOCOPY NUMBER,
1209 x_msg_data OUT NOCOPY VARCHAR2
1210 );
1211
1212
1213 /* =======================================================================*
1214 | PROCEDURE add_msg : Adds the message to the fnd message stack or |
1215 | local plsql table to be dumped later into the |
1216 | validation errors GT.
1217 * =======================================================================*/
1218
1219 PROCEDURE add_msg
1220 (
1221 p_context_info_rec IN context_info_rec_type
1222 );
1223
1224 /* =======================================================================*
1225 | PROCEDURE dump_msg : Dumps the messages into validation errors GT |
1226 * =======================================================================*/
1227
1228 PROCEDURE dump_msg;
1229
1230
1231 /* =================================================================================*
1232 | Overloaded Procedure get_default_tax_det_attribs- for products that do not call |
1233 | ARP_TAX.get_default_tax_classification |
1234 | Default the following product fiscal |
1235 | classification based on the relevant default taxation country, application event |
1236 | class, inventory organization and inventory item values: |
1237 | * trx_business_category |
1238 | * primary_intended_use |
1239 | * product_fisc_classificatio |
1240 | * product_category |
1241 | Also default the tax classification code |
1242 * ================================================================================*/
1243
1244 PROCEDURE get_default_tax_det_attribs
1245 (
1246 p_api_version IN NUMBER,
1247 p_init_msg_list IN VARCHAR2,
1248 p_commit IN VARCHAR2,
1249 p_validation_level IN NUMBER,
1250 x_return_status OUT NOCOPY VARCHAR2,
1251 x_msg_count OUT NOCOPY NUMBER,
1252 x_msg_data OUT NOCOPY VARCHAR2,
1253 p_defaulting_rec_type IN det_fact_defaulting_rec_type,
1254 x_trx_biz_category OUT NOCOPY VARCHAR2,
1255 x_intended_use OUT NOCOPY VARCHAR2,
1256 x_prod_category OUT NOCOPY VARCHAR2,
1257 x_prod_fisc_class_code OUT NOCOPY VARCHAR2,
1258 x_product_type OUT NOCOPY VARCHAR2,
1259 x_tax_classification_code OUT NOCOPY VARCHAR2
1260 );
1261
1262 /* =======================================================================*
1263 | Function Get_Default_Tax_Reg : Returns the Default Registration Number|
1264 | for a Given Party |
1265 * =======================================================================*/
1266 FUNCTION get_default_tax_reg
1267 (
1268 p_api_version IN NUMBER,
1269 p_init_msg_list IN VARCHAR2,
1270 p_commit IN VARCHAR2,
1271 p_validation_level IN NUMBER,
1272 x_return_status OUT NOCOPY VARCHAR2,
1273 x_msg_count OUT NOCOPY NUMBER,
1274 x_msg_data OUT NOCOPY VARCHAR2,
1275 p_party_id IN ZX_PARTY_TAX_PROFILE.party_id%type,
1276 p_party_type IN ZX_PARTY_TAX_PROFILE.party_type_code%type,
1277 p_effective_date IN ZX_REGISTRATIONS.effective_from%type
1281 | products when creating a document or inserting a new transaction line |
1278 ) RETURN Varchar2;
1279 /* ========================================================================*
1280 | PROCEDURE insert_line_det_factors : This procedure should be called by |
1282 | for existing document. This line will be flagged to be picked up by the |
1283 | tax calculation process |
1284 * =======================================================================*/
1285
1286 PROCEDURE insert_line_det_factors
1287 (
1288 p_api_version IN NUMBER,
1289 p_init_msg_list IN VARCHAR2,
1290 p_commit IN VARCHAR2,
1291 p_validation_level IN NUMBER,
1292 x_return_status OUT NOCOPY VARCHAR2,
1293 x_msg_count OUT NOCOPY NUMBER,
1294 x_msg_data OUT NOCOPY VARCHAR2,
1295 p_duplicate_line_rec IN transaction_line_rec_type
1296 );
1297
1298 /* ============================================================================*
1299 | PROCEDURE insert_line_det_factors : This overloaded procedure will be called|
1300 | by iProcurement to insert all the transaction lines with defaulted tax |
1301 | determining attributes into zx_lines_det_factors after complying with the |
1302 | validation process.All lines thus inserted will be flagged to be picked up by|
1303 | the tax calculation process |
1304 * ============================================================================*/
1305
1306 PROCEDURE insert_line_det_factors
1307 (
1308 p_api_version IN NUMBER,
1309 p_init_msg_list IN VARCHAR2,
1310 p_commit IN VARCHAR2,
1311 p_validation_level IN NUMBER,
1312 x_return_status OUT NOCOPY VARCHAR2,
1313 x_msg_count OUT NOCOPY NUMBER,
1314 x_msg_data OUT NOCOPY VARCHAR2
1315 );
1316
1317 /* ========================================================================*
1318 | PROCEDURE update_line_det_factors : This procedure should be called by |
1319 | products when updating any of the line attributes on the transaction |
1320 | so that the tax repository is also in sync with the line level updates |
1321 | This line will be flagged to be picked up by the tax calculation process|
1322 * =======================================================================*/
1323
1324 PROCEDURE update_line_det_factors
1325 (
1326 p_api_version IN NUMBER,
1327 p_init_msg_list IN VARCHAR2,
1328 p_commit IN VARCHAR2,
1329 p_validation_level IN NUMBER,
1330 x_return_status OUT NOCOPY VARCHAR2,
1331 x_msg_count OUT NOCOPY NUMBER,
1332 x_msg_data OUT NOCOPY VARCHAR2
1333 );
1334
1335
1336 /* ========================================================================*
1337 | PROCEDURE update_det_factors_hdr: This procedure should be called by |
1338 | products when updating any of the header attributes on the transaction |
1339 | so that the tax repository is also in sync with the header level updates|
1340 | and also so that the document is picked up for tax calculation later |
1341 * =======================================================================*/
1342
1343 PROCEDURE update_det_factors_hdr
1344 (
1345 p_api_version IN NUMBER,
1346 p_init_msg_list IN VARCHAR2,
1347 p_commit IN VARCHAR2,
1348 p_validation_level IN NUMBER,
1349 x_return_status OUT NOCOPY VARCHAR2,
1350 x_msg_count OUT NOCOPY NUMBER,
1351 x_msg_data OUT NOCOPY VARCHAR2,
1352 p_hdr_det_factors_rec IN header_det_factors_rec_type
1353 );
1354
1355
1356 /* ============================================================================*
1357 | PROCEDURE copy_insert_line_det_factors : This procedure will be called |
1358 | by iProcurement to insert all the transaction lines into zx_lines_det_factors|
1359 | after copying the tax determining attributes from the source document |
1360 | informaiton passed in. All lines thus inserted will be flagged to be picked |
1361 | up by the tax calculation process |
1362 * ============================================================================*/
1363
1364 PROCEDURE copy_insert_line_det_factors
1365 (
1366 p_api_version IN NUMBER,
1367 p_init_msg_list IN VARCHAR2,
1368 p_commit IN VARCHAR2,
1369 p_validation_level IN NUMBER,
1370 x_return_status OUT NOCOPY VARCHAR2,
1371 x_msg_count OUT NOCOPY NUMBER,
1372 x_msg_data OUT NOCOPY VARCHAR2
1373 );
1374
1375
1376 /* ============================================================================*
1377 | PROCEDURE is_recoverability_affected : This procedure will determine |
1378 | whether some accounting related information can be modified on the item |
1379 | distribution from tax point of view. |
1380 * ============================================================================*/
1381 PROCEDURE is_recoverability_affected
1382 (
1386 p_validation_level IN NUMBER,
1383 p_api_version IN NUMBER,
1384 p_init_msg_list IN VARCHAR2,
1385 p_commit IN VARCHAR2,
1387 x_return_status OUT NOCOPY VARCHAR2,
1388 x_msg_count OUT NOCOPY NUMBER,
1389 x_msg_data OUT NOCOPY VARCHAR2,
1390 p_pa_item_info_tbl IN OUT NOCOPY pa_item_info_tbl_type
1391 );
1392
1393 /* ======================================================================*
1394 | PROCEDURE delete_tax_line_and_distributions: |
1395 * ======================================================================*/
1396
1397 PROCEDURE del_tax_line_and_distributions
1398 (
1399 p_api_version IN NUMBER,
1400 p_init_msg_list IN VARCHAR2,
1401 p_commit IN VARCHAR2,
1402 p_validation_level IN NUMBER,
1403 x_return_status OUT NOCOPY VARCHAR2,
1404 x_msg_count OUT NOCOPY NUMBER,
1405 x_msg_data OUT NOCOPY VARCHAR2,
1406 p_transaction_line_rec IN OUT NOCOPY transaction_line_rec_type
1407 );
1408 /* ======================================================================*
1409 | PROCEDURE delete_tax_distributions: |
1410 * ======================================================================*/
1411
1412 PROCEDURE delete_tax_distributions
1413 (
1414 p_api_version IN NUMBER,
1415 p_init_msg_list IN VARCHAR2,
1416 p_commit IN VARCHAR2,
1417 p_validation_level IN NUMBER,
1418 x_return_status OUT NOCOPY VARCHAR2,
1419 x_msg_count OUT NOCOPY NUMBER,
1420 x_msg_data OUT NOCOPY VARCHAR2,
1421 p_transaction_line_rec IN OUT NOCOPY transaction_line_rec_type
1422 );
1423
1424 /* ======================================================================*
1425 | PROCEDURE get_default_tax_det_attribs: overloaded version for PO |
1426 * ======================================================================*/
1427
1428 PROCEDURE get_default_tax_det_attribs
1429 (
1430 p_api_version IN NUMBER,
1431 p_init_msg_list IN VARCHAR2,
1432 p_commit IN VARCHAR2,
1433 p_validation_level IN NUMBER,
1434 x_return_status OUT NOCOPY VARCHAR2,
1435 x_msg_count OUT NOCOPY NUMBER ,
1436 x_msg_data OUT NOCOPY VARCHAR2
1437 );
1438
1439
1440 /* ======================================================================*
1441 | PROCEDURE redefault_intended_use: Redefault intended use |
1442 * ======================================================================*/
1443
1444 PROCEDURE redefault_intended_use
1445 (
1446 p_api_version IN NUMBER,
1447 p_init_msg_list IN VARCHAR2,
1448 p_commit IN VARCHAR2,
1449 p_validation_level IN NUMBER,
1450 x_return_status OUT NOCOPY VARCHAR2,
1451 x_msg_count OUT NOCOPY NUMBER ,
1452 x_msg_data OUT NOCOPY VARCHAR2,
1453 p_application_id IN NUMBER,
1454 p_entity_code IN VARCHAR2,
1455 p_event_class_code IN VARCHAR2,
1456 p_internal_org_id IN NUMBER,
1457 p_country_code IN VARCHAR2,
1458 p_item_id IN NUMBER,
1459 p_item_org_id IN NUMBER,
1460 x_intended_use OUT NOCOPY VARCHAR2
1461 );
1462
1463 /* ======================================================================*
1464 | PROCEDURE redefault_prod_fisc_class_code: Redefault product fiscal |
1465 | classification |
1466 * ======================================================================*/
1467 PROCEDURE redefault_prod_fisc_class_code
1468 (
1469 p_api_version IN NUMBER,
1470 p_init_msg_list IN VARCHAR2,
1471 p_commit IN VARCHAR2,
1472 p_validation_level IN NUMBER,
1473 x_return_status OUT NOCOPY VARCHAR2,
1474 x_msg_count OUT NOCOPY NUMBER ,
1475 x_msg_data OUT NOCOPY VARCHAR2,
1476 p_application_id IN NUMBER,
1477 p_entity_code IN VARCHAR2,
1478 p_event_class_code IN VARCHAR2,
1479 p_internal_org_id IN NUMBER,
1480 p_country_code IN VARCHAR2,
1481 p_item_id IN NUMBER,
1482 p_item_org_id IN NUMBER,
1483 x_prod_fisc_class_code OUT NOCOPY VARCHAR2
1484 );
1485
1486 /* ======================================================================*
1487 | PROCEDURE redefault_assessable_value: Redefault assessable value |
1488 * ======================================================================*/
1492 p_api_version IN NUMBER,
1489
1490 PROCEDURE redefault_assessable_value
1491 (
1493 p_init_msg_list IN VARCHAR2,
1494 p_commit IN VARCHAR2,
1495 p_validation_level IN NUMBER,
1496 x_return_status OUT NOCOPY VARCHAR2,
1497 x_msg_count OUT NOCOPY NUMBER ,
1498 x_msg_data OUT NOCOPY VARCHAR2,
1499 p_application_id IN NUMBER,
1500 p_entity_code IN VARCHAR2,
1501 p_event_class_code IN VARCHAR2,
1502 p_internal_org_id IN NUMBER,
1503 p_trx_id IN NUMBER,
1504 p_trx_line_id IN NUMBER,
1505 p_trx_level_type IN VARCHAR2,
1506 p_item_id IN NUMBER,
1507 p_item_org_id IN NUMBER,
1508 p_line_amt IN NUMBER,
1509 x_assessable_value OUT NOCOPY NUMBER
1510 );
1511
1512 /* ======================================================================*
1513 | PROCEDURE redefault_product_type: Redefault product type |
1514 * ======================================================================*/
1515
1516 PROCEDURE redefault_product_type
1517 (
1518 p_api_version IN NUMBER,
1519 p_init_msg_list IN VARCHAR2,
1520 p_commit IN VARCHAR2,
1521 p_validation_level IN NUMBER,
1522 x_return_status OUT NOCOPY VARCHAR2,
1523 x_msg_count OUT NOCOPY NUMBER ,
1524 x_msg_data OUT NOCOPY VARCHAR2,
1525 p_application_id IN NUMBER,
1526 p_entity_code IN VARCHAR2,
1527 p_event_class_code IN VARCHAR2,
1528 p_country_code IN VARCHAR2,
1529 p_item_id IN NUMBER,
1530 p_org_id IN NUMBER,
1531 x_product_type OUT NOCOPY VARCHAR2
1532 );
1533
1534 /* ======================================================================*
1535 | PROCEDURE get_default_tax_classification: Default tax classification |
1536 * ======================================================================*/
1537 PROCEDURE redef_tax_classification_code
1538 (
1539 p_api_version IN NUMBER,
1540 p_init_msg_list IN VARCHAR2,
1541 p_commit IN VARCHAR2,
1542 p_validation_level IN NUMBER,
1543 x_msg_count OUT NOCOPY NUMBER ,
1544 x_msg_data OUT NOCOPY VARCHAR2,
1545 x_return_status OUT NOCOPY VARCHAR2,
1546 p_redef_tax_cls_code_info_rec IN OUT NOCOPY def_tax_cls_code_info_rec_type
1547 );
1548
1549
1550 /* =========================================================================*
1551 | PROCEDURE purge_tax_repository: Purges the transaction lines and tax data|
1552 * ========================================================================*/
1553 PROCEDURE purge_tax_repository
1554 (
1555 p_api_version IN NUMBER,
1556 p_init_msg_list IN VARCHAR2,
1557 p_commit IN VARCHAR2,
1558 p_validation_level IN NUMBER,
1559 x_msg_count OUT NOCOPY NUMBER ,
1560 x_msg_data OUT NOCOPY VARCHAR2,
1561 x_return_status OUT NOCOPY VARCHAR2
1562 );
1563
1564 /* ======================================================================*
1565 | API TO GET LE FOR AP IMPORT TRANSACTIONS |
1566 * ======================================================================*/
1567 FUNCTION get_le_from_tax_registration
1568 (
1569 p_api_version IN NUMBER,
1570 p_init_msg_list IN VARCHAR2,
1571 p_commit IN VARCHAR2,
1572 p_validation_level IN NUMBER,
1573 x_return_status OUT NOCOPY VARCHAR2,
1574 x_msg_count OUT NOCOPY NUMBER,
1575 x_msg_data OUT NOCOPY VARCHAR2,
1576 p_registration_num IN ZX_REGISTRATIONS.Registration_Number%type,
1577 p_effective_date IN ZX_REGISTRATIONS.effective_from%type,
1578 p_country IN ZX_PARTY_TAX_PROFILE.Country_code%type
1579 ) RETURN Number;
1580
1581 /* ===================================================================================*
1582 | PROCEDURE Update_posting_flag : Updates posting flag of a list of Tax Distributions |
1583 | from the product passed in PL/SQL table |
1584 * ====================================================================================*/
1585
1586 PROCEDURE update_posting_flag
1587 (
1588 p_api_version IN NUMBER,
1589 p_init_msg_list IN VARCHAR2,
1590 p_commit IN VARCHAR2,
1594 x_msg_data OUT NOCOPY VARCHAR2,
1591 p_validation_level IN NUMBER,
1592 x_return_status OUT NOCOPY VARCHAR2,
1593 x_msg_count OUT NOCOPY NUMBER,
1595 p_tax_dist_id_tbl IN tax_dist_id_tbl_type
1596 );
1597
1598 /* ===================================================================================*
1599 | PROCEDURE unapply_applied_cm : Null out the adjusted doc information on both |
1600 | zx_lines and zx_lines_det_factors |
1601 * ====================================================================================*/
1602
1603 PROCEDURE unapply_applied_cm
1604 ( p_api_version IN NUMBER,
1605 p_init_msg_list IN VARCHAR2,
1606 p_commit IN VARCHAR2,
1607 p_validation_level IN NUMBER,
1608 p_trx_id IN NUMBER,
1609 x_return_status OUT NOCOPY VARCHAR2,
1610 x_msg_count OUT NOCOPY NUMBER,
1611 x_msg_data OUT NOCOPY VARCHAR2
1612 );
1613
1614 END ZX_API_PUB;
1615