eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_JG_EXTRACT_PKG dependencies on ZX_EXTRACT_PKG

Line 119: p_tax_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,

115: PROCEDURE prorate_tax (
116: p_tax_total IN NUMBER,
117: p_tax_funcl_curr_total IN NUMBER,
118: p_percent_tbl IN OUT NOCOPY numtab,
119: p_tax_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,
120: p_tax_amt_funcl_curr_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL,
121: p_precision_tbl IN OUT NOCOPY numtab,
122: p_minimum_accountable_unit_tbl IN OUT NOCOPY numtab,
123: p_func_precision IN NUMBER,

Line 120: p_tax_amt_funcl_curr_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL,

116: p_tax_total IN NUMBER,
117: p_tax_funcl_curr_total IN NUMBER,
118: p_percent_tbl IN OUT NOCOPY numtab,
119: p_tax_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,
120: p_tax_amt_funcl_curr_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL,
121: p_precision_tbl IN OUT NOCOPY numtab,
122: p_minimum_accountable_unit_tbl IN OUT NOCOPY numtab,
123: p_func_precision IN NUMBER,
124: p_func_min_account_unit IN NUMBER,

Line 226: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,

222: *
223: **/
224:
225: PROCEDURE insert_row (
226: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
227: p_taxable_amt_tbl IN ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
228: p_taxable_amt_funcl_curr_tbl IN ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,
229: p_tax_amt_tbl IN ZX_EXTRACT_PKG.TAX_AMT_TBL,
230: p_tax_amt_funcl_curr_tbl IN ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL)

Line 227: p_taxable_amt_tbl IN ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,

223: **/
224:
225: PROCEDURE insert_row (
226: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
227: p_taxable_amt_tbl IN ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
228: p_taxable_amt_funcl_curr_tbl IN ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,
229: p_tax_amt_tbl IN ZX_EXTRACT_PKG.TAX_AMT_TBL,
230: p_tax_amt_funcl_curr_tbl IN ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL)
231:

Line 228: p_taxable_amt_funcl_curr_tbl IN ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,

224:
225: PROCEDURE insert_row (
226: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
227: p_taxable_amt_tbl IN ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
228: p_taxable_amt_funcl_curr_tbl IN ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,
229: p_tax_amt_tbl IN ZX_EXTRACT_PKG.TAX_AMT_TBL,
230: p_tax_amt_funcl_curr_tbl IN ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL)
231:
232: IS

Line 229: p_tax_amt_tbl IN ZX_EXTRACT_PKG.TAX_AMT_TBL,

225: PROCEDURE insert_row (
226: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
227: p_taxable_amt_tbl IN ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
228: p_taxable_amt_funcl_curr_tbl IN ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,
229: p_tax_amt_tbl IN ZX_EXTRACT_PKG.TAX_AMT_TBL,
230: p_tax_amt_funcl_curr_tbl IN ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL)
231:
232: IS
233:

Line 230: p_tax_amt_funcl_curr_tbl IN ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL)

226: p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
227: p_taxable_amt_tbl IN ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
228: p_taxable_amt_funcl_curr_tbl IN ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,
229: p_tax_amt_tbl IN ZX_EXTRACT_PKG.TAX_AMT_TBL,
230: p_tax_amt_funcl_curr_tbl IN ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL)
231:
232: IS
233:
234: count_tbl numtab;

Line 370: p_trl_global_variables_rec IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE,

366: *
367: **/
368:
369: PROCEDURE initialize (
370: p_trl_global_variables_rec IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE,
371: l_func_precision OUT NOCOPY NUMBER,
372: l_func_min_account_unit OUT NOCOPY NUMBER,
373: l_sob_type OUT NOCOPY VARCHAR2)
374: IS

Line 542: (p_detail_tax_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,

538: *
539: **/
540:
541: PROCEDURE reset_result_tables
542: (p_detail_tax_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
543: p_trx_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TRX_ID_TBL,
544: p_tax_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,
545: p_trx_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
546: p_tax_dist_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.ACTG_SOURCE_ID_TBL,

Line 543: p_trx_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TRX_ID_TBL,

539: **/
540:
541: PROCEDURE reset_result_tables
542: (p_detail_tax_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
543: p_trx_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TRX_ID_TBL,
544: p_tax_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,
545: p_trx_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
546: p_tax_dist_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.ACTG_SOURCE_ID_TBL,
547: p_event_class_code_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL,

Line 544: p_tax_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,

540:
541: PROCEDURE reset_result_tables
542: (p_detail_tax_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
543: p_trx_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TRX_ID_TBL,
544: p_tax_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,
545: p_trx_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
546: p_tax_dist_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.ACTG_SOURCE_ID_TBL,
547: p_event_class_code_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL,
548: p_taxable_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,

Line 545: p_trx_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,

541: PROCEDURE reset_result_tables
542: (p_detail_tax_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
543: p_trx_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TRX_ID_TBL,
544: p_tax_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,
545: p_trx_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
546: p_tax_dist_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.ACTG_SOURCE_ID_TBL,
547: p_event_class_code_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL,
548: p_taxable_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
549: p_tax_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,

Line 546: p_tax_dist_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.ACTG_SOURCE_ID_TBL,

542: (p_detail_tax_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
543: p_trx_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TRX_ID_TBL,
544: p_tax_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,
545: p_trx_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
546: p_tax_dist_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.ACTG_SOURCE_ID_TBL,
547: p_event_class_code_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL,
548: p_taxable_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
549: p_tax_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,
550: p_tax_amt_funcl_curr_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL,

Line 547: p_event_class_code_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL,

543: p_trx_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TRX_ID_TBL,
544: p_tax_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,
545: p_trx_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
546: p_tax_dist_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.ACTG_SOURCE_ID_TBL,
547: p_event_class_code_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL,
548: p_taxable_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
549: p_tax_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,
550: p_tax_amt_funcl_curr_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL,
551: p_tax_rate_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,

Line 548: p_taxable_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,

544: p_tax_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,
545: p_trx_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
546: p_tax_dist_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.ACTG_SOURCE_ID_TBL,
547: p_event_class_code_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL,
548: p_taxable_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
549: p_tax_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,
550: p_tax_amt_funcl_curr_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL,
551: p_tax_rate_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,
552: p_extract_source_ledger_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.EXTRACT_SOURCE_LEDGER_TBL,

Line 549: p_tax_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,

545: p_trx_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
546: p_tax_dist_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.ACTG_SOURCE_ID_TBL,
547: p_event_class_code_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL,
548: p_taxable_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
549: p_tax_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,
550: p_tax_amt_funcl_curr_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL,
551: p_tax_rate_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,
552: p_extract_source_ledger_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.EXTRACT_SOURCE_LEDGER_TBL,
553: p_ledger_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.LEDGER_ID_TBL,

Line 550: p_tax_amt_funcl_curr_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL,

546: p_tax_dist_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.ACTG_SOURCE_ID_TBL,
547: p_event_class_code_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL,
548: p_taxable_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
549: p_tax_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,
550: p_tax_amt_funcl_curr_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL,
551: p_tax_rate_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,
552: p_extract_source_ledger_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.EXTRACT_SOURCE_LEDGER_TBL,
553: p_ledger_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.LEDGER_ID_TBL,
554: l_detail_tax_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,

Line 551: p_tax_rate_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,

547: p_event_class_code_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL,
548: p_taxable_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
549: p_tax_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,
550: p_tax_amt_funcl_curr_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL,
551: p_tax_rate_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,
552: p_extract_source_ledger_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.EXTRACT_SOURCE_LEDGER_TBL,
553: p_ledger_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.LEDGER_ID_TBL,
554: l_detail_tax_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
555: l_taxable_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,

Line 552: p_extract_source_ledger_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.EXTRACT_SOURCE_LEDGER_TBL,

548: p_taxable_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
549: p_tax_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,
550: p_tax_amt_funcl_curr_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL,
551: p_tax_rate_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,
552: p_extract_source_ledger_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.EXTRACT_SOURCE_LEDGER_TBL,
553: p_ledger_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.LEDGER_ID_TBL,
554: l_detail_tax_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
555: l_taxable_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
556: l_taxable_amt_funcl_curr_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,

Line 553: p_ledger_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.LEDGER_ID_TBL,

549: p_tax_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,
550: p_tax_amt_funcl_curr_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL,
551: p_tax_rate_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,
552: p_extract_source_ledger_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.EXTRACT_SOURCE_LEDGER_TBL,
553: p_ledger_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.LEDGER_ID_TBL,
554: l_detail_tax_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
555: l_taxable_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
556: l_taxable_amt_funcl_curr_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,
557: l_tax_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,

Line 554: l_detail_tax_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,

550: p_tax_amt_funcl_curr_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL,
551: p_tax_rate_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,
552: p_extract_source_ledger_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.EXTRACT_SOURCE_LEDGER_TBL,
553: p_ledger_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.LEDGER_ID_TBL,
554: l_detail_tax_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
555: l_taxable_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
556: l_taxable_amt_funcl_curr_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,
557: l_tax_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,
558: l_tax_amt_funcl_curr_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL,

Line 555: l_taxable_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,

551: p_tax_rate_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,
552: p_extract_source_ledger_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.EXTRACT_SOURCE_LEDGER_TBL,
553: p_ledger_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.LEDGER_ID_TBL,
554: l_detail_tax_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
555: l_taxable_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
556: l_taxable_amt_funcl_curr_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,
557: l_tax_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,
558: l_tax_amt_funcl_curr_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL,
559: l_ccid_tbl IN OUT NOCOPY t_ccid_tbl,

Line 556: l_taxable_amt_funcl_curr_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,

552: p_extract_source_ledger_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.EXTRACT_SOURCE_LEDGER_TBL,
553: p_ledger_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.LEDGER_ID_TBL,
554: l_detail_tax_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
555: l_taxable_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
556: l_taxable_amt_funcl_curr_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,
557: l_tax_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,
558: l_tax_amt_funcl_curr_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL,
559: l_ccid_tbl IN OUT NOCOPY t_ccid_tbl,
560: l_acct_date_tbl IN OUT NOCOPY t_acct_date_tbl)

Line 557: l_tax_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,

553: p_ledger_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.LEDGER_ID_TBL,
554: l_detail_tax_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
555: l_taxable_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
556: l_taxable_amt_funcl_curr_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,
557: l_tax_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,
558: l_tax_amt_funcl_curr_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL,
559: l_ccid_tbl IN OUT NOCOPY t_ccid_tbl,
560: l_acct_date_tbl IN OUT NOCOPY t_acct_date_tbl)
561: IS

Line 558: l_tax_amt_funcl_curr_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL,

554: l_detail_tax_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
555: l_taxable_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
556: l_taxable_amt_funcl_curr_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,
557: l_tax_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,
558: l_tax_amt_funcl_curr_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL,
559: l_ccid_tbl IN OUT NOCOPY t_ccid_tbl,
560: l_acct_date_tbl IN OUT NOCOPY t_acct_date_tbl)
561: IS
562:

Line 623: ( c_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,

619: **/
620:
621:
622: PROCEDURE get_gl_taxable_obsolete
623: ( c_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
624: c_trx_id_tbl IN ZX_EXTRACT_PKG.TRX_ID_TBL,
625: c_tax_line_id_tbl IN ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,
626: c_trx_line_id_tbl IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
627: t_detail_tax_line_id_tbl OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,

Line 624: c_trx_id_tbl IN ZX_EXTRACT_PKG.TRX_ID_TBL,

620:
621:
622: PROCEDURE get_gl_taxable_obsolete
623: ( c_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
624: c_trx_id_tbl IN ZX_EXTRACT_PKG.TRX_ID_TBL,
625: c_tax_line_id_tbl IN ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,
626: c_trx_line_id_tbl IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
627: t_detail_tax_line_id_tbl OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
628: t_ccid_tbl OUT NOCOPY t_ccid_tbl,

Line 625: c_tax_line_id_tbl IN ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,

621:
622: PROCEDURE get_gl_taxable_obsolete
623: ( c_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
624: c_trx_id_tbl IN ZX_EXTRACT_PKG.TRX_ID_TBL,
625: c_tax_line_id_tbl IN ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,
626: c_trx_line_id_tbl IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
627: t_detail_tax_line_id_tbl OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
628: t_ccid_tbl OUT NOCOPY t_ccid_tbl,
629: t_acct_date_tbl OUT NOCOPY t_acct_date_tbl,

Line 626: c_trx_line_id_tbl IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,

622: PROCEDURE get_gl_taxable_obsolete
623: ( c_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
624: c_trx_id_tbl IN ZX_EXTRACT_PKG.TRX_ID_TBL,
625: c_tax_line_id_tbl IN ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,
626: c_trx_line_id_tbl IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
627: t_detail_tax_line_id_tbl OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
628: t_ccid_tbl OUT NOCOPY t_ccid_tbl,
629: t_acct_date_tbl OUT NOCOPY t_acct_date_tbl,
630: t_taxable_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,

Line 627: t_detail_tax_line_id_tbl OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,

623: ( c_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
624: c_trx_id_tbl IN ZX_EXTRACT_PKG.TRX_ID_TBL,
625: c_tax_line_id_tbl IN ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,
626: c_trx_line_id_tbl IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
627: t_detail_tax_line_id_tbl OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
628: t_ccid_tbl OUT NOCOPY t_ccid_tbl,
629: t_acct_date_tbl OUT NOCOPY t_acct_date_tbl,
630: t_taxable_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
631: t_taxable_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,

Line 630: t_taxable_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,

626: c_trx_line_id_tbl IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
627: t_detail_tax_line_id_tbl OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
628: t_ccid_tbl OUT NOCOPY t_ccid_tbl,
629: t_acct_date_tbl OUT NOCOPY t_acct_date_tbl,
630: t_taxable_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
631: t_taxable_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,
632: t_tax_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,
633: t_tax_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL
634: )

Line 631: t_taxable_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,

627: t_detail_tax_line_id_tbl OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
628: t_ccid_tbl OUT NOCOPY t_ccid_tbl,
629: t_acct_date_tbl OUT NOCOPY t_acct_date_tbl,
630: t_taxable_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
631: t_taxable_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,
632: t_tax_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,
633: t_tax_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL
634: )
635: IS

Line 632: t_tax_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,

628: t_ccid_tbl OUT NOCOPY t_ccid_tbl,
629: t_acct_date_tbl OUT NOCOPY t_acct_date_tbl,
630: t_taxable_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
631: t_taxable_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,
632: t_tax_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,
633: t_tax_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL
634: )
635: IS
636:

Line 633: t_tax_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL

629: t_acct_date_tbl OUT NOCOPY t_acct_date_tbl,
630: t_taxable_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
631: t_taxable_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,
632: t_tax_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,
633: t_tax_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL
634: )
635: IS
636:
637: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;

Line 637: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;

633: t_tax_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL
634: )
635: IS
636:
637: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
638:
639: --
640: -- Cursor definition
641: --

Line 705: c_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,

701: **/
702:
703:
704: PROCEDURE get_ap_taxable_obsolete (
705: c_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
706: c_trx_id_tbl IN ZX_EXTRACT_PKG.TRX_ID_TBL,
707: c_tax_line_id_tbl IN ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,
708: c_trx_line_id_tbl IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
709: c_tax_dist_id_tbl IN ZX_EXTRACT_PKG.ACTG_SOURCE_ID_TBL,

Line 706: c_trx_id_tbl IN ZX_EXTRACT_PKG.TRX_ID_TBL,

702:
703:
704: PROCEDURE get_ap_taxable_obsolete (
705: c_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
706: c_trx_id_tbl IN ZX_EXTRACT_PKG.TRX_ID_TBL,
707: c_tax_line_id_tbl IN ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,
708: c_trx_line_id_tbl IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
709: c_tax_dist_id_tbl IN ZX_EXTRACT_PKG.ACTG_SOURCE_ID_TBL,
710: c_ledger_id_tbl IN ZX_EXTRACT_PKG.ledger_id_tbl,

Line 707: c_tax_line_id_tbl IN ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,

703:
704: PROCEDURE get_ap_taxable_obsolete (
705: c_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
706: c_trx_id_tbl IN ZX_EXTRACT_PKG.TRX_ID_TBL,
707: c_tax_line_id_tbl IN ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,
708: c_trx_line_id_tbl IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
709: c_tax_dist_id_tbl IN ZX_EXTRACT_PKG.ACTG_SOURCE_ID_TBL,
710: c_ledger_id_tbl IN ZX_EXTRACT_PKG.ledger_id_tbl,
711: t_detail_tax_line_id_tbl OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,

Line 708: c_trx_line_id_tbl IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,

704: PROCEDURE get_ap_taxable_obsolete (
705: c_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
706: c_trx_id_tbl IN ZX_EXTRACT_PKG.TRX_ID_TBL,
707: c_tax_line_id_tbl IN ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,
708: c_trx_line_id_tbl IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
709: c_tax_dist_id_tbl IN ZX_EXTRACT_PKG.ACTG_SOURCE_ID_TBL,
710: c_ledger_id_tbl IN ZX_EXTRACT_PKG.ledger_id_tbl,
711: t_detail_tax_line_id_tbl OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
712: t_ccid_tbl OUT NOCOPY t_ccid_tbl,

Line 709: c_tax_dist_id_tbl IN ZX_EXTRACT_PKG.ACTG_SOURCE_ID_TBL,

705: c_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
706: c_trx_id_tbl IN ZX_EXTRACT_PKG.TRX_ID_TBL,
707: c_tax_line_id_tbl IN ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,
708: c_trx_line_id_tbl IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
709: c_tax_dist_id_tbl IN ZX_EXTRACT_PKG.ACTG_SOURCE_ID_TBL,
710: c_ledger_id_tbl IN ZX_EXTRACT_PKG.ledger_id_tbl,
711: t_detail_tax_line_id_tbl OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
712: t_ccid_tbl OUT NOCOPY t_ccid_tbl,
713: t_acct_date_tbl OUT NOCOPY t_acct_date_tbl,

Line 710: c_ledger_id_tbl IN ZX_EXTRACT_PKG.ledger_id_tbl,

706: c_trx_id_tbl IN ZX_EXTRACT_PKG.TRX_ID_TBL,
707: c_tax_line_id_tbl IN ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,
708: c_trx_line_id_tbl IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
709: c_tax_dist_id_tbl IN ZX_EXTRACT_PKG.ACTG_SOURCE_ID_TBL,
710: c_ledger_id_tbl IN ZX_EXTRACT_PKG.ledger_id_tbl,
711: t_detail_tax_line_id_tbl OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
712: t_ccid_tbl OUT NOCOPY t_ccid_tbl,
713: t_acct_date_tbl OUT NOCOPY t_acct_date_tbl,
714: t_taxable_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,

Line 711: t_detail_tax_line_id_tbl OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,

707: c_tax_line_id_tbl IN ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,
708: c_trx_line_id_tbl IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
709: c_tax_dist_id_tbl IN ZX_EXTRACT_PKG.ACTG_SOURCE_ID_TBL,
710: c_ledger_id_tbl IN ZX_EXTRACT_PKG.ledger_id_tbl,
711: t_detail_tax_line_id_tbl OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
712: t_ccid_tbl OUT NOCOPY t_ccid_tbl,
713: t_acct_date_tbl OUT NOCOPY t_acct_date_tbl,
714: t_taxable_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
715: t_taxable_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,

Line 714: t_taxable_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,

710: c_ledger_id_tbl IN ZX_EXTRACT_PKG.ledger_id_tbl,
711: t_detail_tax_line_id_tbl OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
712: t_ccid_tbl OUT NOCOPY t_ccid_tbl,
713: t_acct_date_tbl OUT NOCOPY t_acct_date_tbl,
714: t_taxable_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
715: t_taxable_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,
716: t_tax_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,
717: t_tax_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL
718: ) IS

Line 715: t_taxable_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,

711: t_detail_tax_line_id_tbl OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
712: t_ccid_tbl OUT NOCOPY t_ccid_tbl,
713: t_acct_date_tbl OUT NOCOPY t_acct_date_tbl,
714: t_taxable_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
715: t_taxable_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,
716: t_tax_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,
717: t_tax_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL
718: ) IS
719:

Line 716: t_tax_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,

712: t_ccid_tbl OUT NOCOPY t_ccid_tbl,
713: t_acct_date_tbl OUT NOCOPY t_acct_date_tbl,
714: t_taxable_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
715: t_taxable_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,
716: t_tax_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,
717: t_tax_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL
718: ) IS
719:
720: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;

Line 717: t_tax_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL

713: t_acct_date_tbl OUT NOCOPY t_acct_date_tbl,
714: t_taxable_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
715: t_taxable_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,
716: t_tax_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,
717: t_tax_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL
718: ) IS
719:
720: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
721: j INTEGER;

Line 720: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;

716: t_tax_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,
717: t_tax_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL
718: ) IS
719:
720: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
721: j INTEGER;
722: k INTEGER;
723: k_taxable_amt_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_TBL;
724:

Line 723: k_taxable_amt_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_TBL;

719:
720: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
721: j INTEGER;
722: k INTEGER;
723: k_taxable_amt_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_TBL;
724:
725: --
726: -- Private Data Type
727: --

Line 926: c_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,

922: *
923: **/
924:
925: PROCEDURE get_ar_taxable (
926: c_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
927: c_event_class_code_tbl IN ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL,
928: c_trx_id_tbl IN ZX_EXTRACT_PKG.TRX_ID_TBL,
929: c_tax_line_id_tbl IN ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,
930: c_trx_line_id_tbl IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,

Line 927: c_event_class_code_tbl IN ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL,

923: **/
924:
925: PROCEDURE get_ar_taxable (
926: c_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
927: c_event_class_code_tbl IN ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL,
928: c_trx_id_tbl IN ZX_EXTRACT_PKG.TRX_ID_TBL,
929: c_tax_line_id_tbl IN ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,
930: c_trx_line_id_tbl IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
931: c_taxable_amt_tbl IN ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,

Line 928: c_trx_id_tbl IN ZX_EXTRACT_PKG.TRX_ID_TBL,

924:
925: PROCEDURE get_ar_taxable (
926: c_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
927: c_event_class_code_tbl IN ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL,
928: c_trx_id_tbl IN ZX_EXTRACT_PKG.TRX_ID_TBL,
929: c_tax_line_id_tbl IN ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,
930: c_trx_line_id_tbl IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
931: c_taxable_amt_tbl IN ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
932: c_taxable_amt_funcl_curr_tbl IN ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,

Line 929: c_tax_line_id_tbl IN ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,

925: PROCEDURE get_ar_taxable (
926: c_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
927: c_event_class_code_tbl IN ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL,
928: c_trx_id_tbl IN ZX_EXTRACT_PKG.TRX_ID_TBL,
929: c_tax_line_id_tbl IN ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,
930: c_trx_line_id_tbl IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
931: c_taxable_amt_tbl IN ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
932: c_taxable_amt_funcl_curr_tbl IN ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,
933: c_tax_amt_tbl IN ZX_EXTRACT_PKG.TAX_AMT_TBL,

Line 930: c_trx_line_id_tbl IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,

926: c_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
927: c_event_class_code_tbl IN ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL,
928: c_trx_id_tbl IN ZX_EXTRACT_PKG.TRX_ID_TBL,
929: c_tax_line_id_tbl IN ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,
930: c_trx_line_id_tbl IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
931: c_taxable_amt_tbl IN ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
932: c_taxable_amt_funcl_curr_tbl IN ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,
933: c_tax_amt_tbl IN ZX_EXTRACT_PKG.TAX_AMT_TBL,
934: c_tax_amt_funcl_curr_tbl IN ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL,

Line 931: c_taxable_amt_tbl IN ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,

927: c_event_class_code_tbl IN ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL,
928: c_trx_id_tbl IN ZX_EXTRACT_PKG.TRX_ID_TBL,
929: c_tax_line_id_tbl IN ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,
930: c_trx_line_id_tbl IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
931: c_taxable_amt_tbl IN ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
932: c_taxable_amt_funcl_curr_tbl IN ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,
933: c_tax_amt_tbl IN ZX_EXTRACT_PKG.TAX_AMT_TBL,
934: c_tax_amt_funcl_curr_tbl IN ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL,
935: c_tax_rate_id_tbl IN ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,

Line 932: c_taxable_amt_funcl_curr_tbl IN ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,

928: c_trx_id_tbl IN ZX_EXTRACT_PKG.TRX_ID_TBL,
929: c_tax_line_id_tbl IN ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,
930: c_trx_line_id_tbl IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
931: c_taxable_amt_tbl IN ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
932: c_taxable_amt_funcl_curr_tbl IN ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,
933: c_tax_amt_tbl IN ZX_EXTRACT_PKG.TAX_AMT_TBL,
934: c_tax_amt_funcl_curr_tbl IN ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL,
935: c_tax_rate_id_tbl IN ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,
936: p_sob_type IN VARCHAR2,

Line 933: c_tax_amt_tbl IN ZX_EXTRACT_PKG.TAX_AMT_TBL,

929: c_tax_line_id_tbl IN ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,
930: c_trx_line_id_tbl IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
931: c_taxable_amt_tbl IN ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
932: c_taxable_amt_funcl_curr_tbl IN ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,
933: c_tax_amt_tbl IN ZX_EXTRACT_PKG.TAX_AMT_TBL,
934: c_tax_amt_funcl_curr_tbl IN ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL,
935: c_tax_rate_id_tbl IN ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,
936: p_sob_type IN VARCHAR2,
937: p_func_precision IN NUMBER,

Line 934: c_tax_amt_funcl_curr_tbl IN ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL,

930: c_trx_line_id_tbl IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
931: c_taxable_amt_tbl IN ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
932: c_taxable_amt_funcl_curr_tbl IN ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,
933: c_tax_amt_tbl IN ZX_EXTRACT_PKG.TAX_AMT_TBL,
934: c_tax_amt_funcl_curr_tbl IN ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL,
935: c_tax_rate_id_tbl IN ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,
936: p_sob_type IN VARCHAR2,
937: p_func_precision IN NUMBER,
938: p_func_min_account_unit IN NUMBER,

Line 935: c_tax_rate_id_tbl IN ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,

931: c_taxable_amt_tbl IN ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
932: c_taxable_amt_funcl_curr_tbl IN ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,
933: c_tax_amt_tbl IN ZX_EXTRACT_PKG.TAX_AMT_TBL,
934: c_tax_amt_funcl_curr_tbl IN ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL,
935: c_tax_rate_id_tbl IN ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,
936: p_sob_type IN VARCHAR2,
937: p_func_precision IN NUMBER,
938: p_func_min_account_unit IN NUMBER,
939: t_detail_tax_line_id_tbl OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,

Line 939: t_detail_tax_line_id_tbl OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,

935: c_tax_rate_id_tbl IN ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,
936: p_sob_type IN VARCHAR2,
937: p_func_precision IN NUMBER,
938: p_func_min_account_unit IN NUMBER,
939: t_detail_tax_line_id_tbl OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
940: t_ccid_tbl OUT NOCOPY t_ccid_tbl,
941: t_acct_date_tbl OUT NOCOPY t_acct_date_tbl,
942: t_taxable_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
943: t_taxable_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,

Line 942: t_taxable_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,

938: p_func_min_account_unit IN NUMBER,
939: t_detail_tax_line_id_tbl OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
940: t_ccid_tbl OUT NOCOPY t_ccid_tbl,
941: t_acct_date_tbl OUT NOCOPY t_acct_date_tbl,
942: t_taxable_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
943: t_taxable_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,
944: t_tax_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,
945: t_tax_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL) IS
946:

Line 943: t_taxable_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,

939: t_detail_tax_line_id_tbl OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
940: t_ccid_tbl OUT NOCOPY t_ccid_tbl,
941: t_acct_date_tbl OUT NOCOPY t_acct_date_tbl,
942: t_taxable_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
943: t_taxable_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,
944: t_tax_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,
945: t_tax_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL) IS
946:
947: CURSOR c_ar_inv (c_detail_tax_line_id in NUMBER) IS

Line 944: t_tax_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,

940: t_ccid_tbl OUT NOCOPY t_ccid_tbl,
941: t_acct_date_tbl OUT NOCOPY t_acct_date_tbl,
942: t_taxable_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
943: t_taxable_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,
944: t_tax_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,
945: t_tax_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL) IS
946:
947: CURSOR c_ar_inv (c_detail_tax_line_id in NUMBER) IS
948: SELECT detail_tax_line_id,

Line 945: t_tax_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL) IS

941: t_acct_date_tbl OUT NOCOPY t_acct_date_tbl,
942: t_taxable_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
943: t_taxable_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,
944: t_tax_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,
945: t_tax_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL) IS
946:
947: CURSOR c_ar_inv (c_detail_tax_line_id in NUMBER) IS
948: SELECT detail_tax_line_id,
949: actg_line_ccid code_combination_id,

Line 977: l_tax_amt_tbl ZX_EXTRACT_PKG.TAX_AMT_TBL;

973: l_ra_customer_trx_lines VARCHAR2(30);
974: l_ra_cust_trx_line_gl_dist VARCHAR2(30);
975:
976: l_percent_tbl numtab;
977: l_tax_amt_tbl ZX_EXTRACT_PKG.TAX_AMT_TBL;
978: l_tax_amt_funcl_curr_tbl ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL;
979: l_precision_tbl numtab;
980: l_minimum_accountable_unit_tbl numtab;
981:

Line 978: l_tax_amt_funcl_curr_tbl ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL;

974: l_ra_cust_trx_line_gl_dist VARCHAR2(30);
975:
976: l_percent_tbl numtab;
977: l_tax_amt_tbl ZX_EXTRACT_PKG.TAX_AMT_TBL;
978: l_tax_amt_funcl_curr_tbl ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL;
979: l_precision_tbl numtab;
980: l_minimum_accountable_unit_tbl numtab;
981:
982: j INTEGER;

Line 1575: p_trl_global_variables_rec IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE)

1571: *
1572: **/
1573:
1574: PROCEDURE get_taxable (
1575: p_trl_global_variables_rec IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE)
1576: IS
1577:
1578: --
1579: -- Private Parameters

Line 1581: p_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;

1577:
1578: --
1579: -- Private Parameters
1580: --
1581: p_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
1582: p_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
1583: p_tax_line_id_tbl ZX_EXTRACT_PKG.TAX_LINE_ID_TBL;
1584: p_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;
1585: p_tax_dist_id_tbl ZX_EXTRACT_PKG.actg_source_id_tbl;

Line 1582: p_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;

1578: --
1579: -- Private Parameters
1580: --
1581: p_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
1582: p_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
1583: p_tax_line_id_tbl ZX_EXTRACT_PKG.TAX_LINE_ID_TBL;
1584: p_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;
1585: p_tax_dist_id_tbl ZX_EXTRACT_PKG.actg_source_id_tbl;
1586: p_event_class_code_tbl ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL;

Line 1583: p_tax_line_id_tbl ZX_EXTRACT_PKG.TAX_LINE_ID_TBL;

1579: -- Private Parameters
1580: --
1581: p_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
1582: p_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
1583: p_tax_line_id_tbl ZX_EXTRACT_PKG.TAX_LINE_ID_TBL;
1584: p_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;
1585: p_tax_dist_id_tbl ZX_EXTRACT_PKG.actg_source_id_tbl;
1586: p_event_class_code_tbl ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL;
1587: p_taxable_amt_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_TBL;

Line 1584: p_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;

1580: --
1581: p_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
1582: p_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
1583: p_tax_line_id_tbl ZX_EXTRACT_PKG.TAX_LINE_ID_TBL;
1584: p_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;
1585: p_tax_dist_id_tbl ZX_EXTRACT_PKG.actg_source_id_tbl;
1586: p_event_class_code_tbl ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL;
1587: p_taxable_amt_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_TBL;
1588: p_taxable_amt_funcl_curr_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL;

Line 1585: p_tax_dist_id_tbl ZX_EXTRACT_PKG.actg_source_id_tbl;

1581: p_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
1582: p_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
1583: p_tax_line_id_tbl ZX_EXTRACT_PKG.TAX_LINE_ID_TBL;
1584: p_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;
1585: p_tax_dist_id_tbl ZX_EXTRACT_PKG.actg_source_id_tbl;
1586: p_event_class_code_tbl ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL;
1587: p_taxable_amt_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_TBL;
1588: p_taxable_amt_funcl_curr_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL;
1589: p_tax_amt_tbl ZX_EXTRACT_PKG.TAX_AMT_TBL;

Line 1586: p_event_class_code_tbl ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL;

1582: p_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
1583: p_tax_line_id_tbl ZX_EXTRACT_PKG.TAX_LINE_ID_TBL;
1584: p_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;
1585: p_tax_dist_id_tbl ZX_EXTRACT_PKG.actg_source_id_tbl;
1586: p_event_class_code_tbl ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL;
1587: p_taxable_amt_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_TBL;
1588: p_taxable_amt_funcl_curr_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL;
1589: p_tax_amt_tbl ZX_EXTRACT_PKG.TAX_AMT_TBL;
1590: p_tax_amt_funcl_curr_tbl ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL;

Line 1587: p_taxable_amt_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_TBL;

1583: p_tax_line_id_tbl ZX_EXTRACT_PKG.TAX_LINE_ID_TBL;
1584: p_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;
1585: p_tax_dist_id_tbl ZX_EXTRACT_PKG.actg_source_id_tbl;
1586: p_event_class_code_tbl ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL;
1587: p_taxable_amt_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_TBL;
1588: p_taxable_amt_funcl_curr_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL;
1589: p_tax_amt_tbl ZX_EXTRACT_PKG.TAX_AMT_TBL;
1590: p_tax_amt_funcl_curr_tbl ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL;
1591: p_tax_rate_id_tbl ZX_EXTRACT_PKG.TAX_RATE_ID_TBL;

Line 1588: p_taxable_amt_funcl_curr_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL;

1584: p_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;
1585: p_tax_dist_id_tbl ZX_EXTRACT_PKG.actg_source_id_tbl;
1586: p_event_class_code_tbl ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL;
1587: p_taxable_amt_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_TBL;
1588: p_taxable_amt_funcl_curr_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL;
1589: p_tax_amt_tbl ZX_EXTRACT_PKG.TAX_AMT_TBL;
1590: p_tax_amt_funcl_curr_tbl ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL;
1591: p_tax_rate_id_tbl ZX_EXTRACT_PKG.TAX_RATE_ID_TBL;
1592: p_extract_source_ledger_tbl ZX_EXTRACT_PKG.EXTRACT_SOURCE_LEDGER_TBL;

Line 1589: p_tax_amt_tbl ZX_EXTRACT_PKG.TAX_AMT_TBL;

1585: p_tax_dist_id_tbl ZX_EXTRACT_PKG.actg_source_id_tbl;
1586: p_event_class_code_tbl ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL;
1587: p_taxable_amt_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_TBL;
1588: p_taxable_amt_funcl_curr_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL;
1589: p_tax_amt_tbl ZX_EXTRACT_PKG.TAX_AMT_TBL;
1590: p_tax_amt_funcl_curr_tbl ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL;
1591: p_tax_rate_id_tbl ZX_EXTRACT_PKG.TAX_RATE_ID_TBL;
1592: p_extract_source_ledger_tbl ZX_EXTRACT_PKG.EXTRACT_SOURCE_LEDGER_TBL;
1593: p_ledger_id_tbl ZX_EXTRACT_PKG.LEDGER_ID_TBL;

Line 1590: p_tax_amt_funcl_curr_tbl ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL;

1586: p_event_class_code_tbl ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL;
1587: p_taxable_amt_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_TBL;
1588: p_taxable_amt_funcl_curr_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL;
1589: p_tax_amt_tbl ZX_EXTRACT_PKG.TAX_AMT_TBL;
1590: p_tax_amt_funcl_curr_tbl ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL;
1591: p_tax_rate_id_tbl ZX_EXTRACT_PKG.TAX_RATE_ID_TBL;
1592: p_extract_source_ledger_tbl ZX_EXTRACT_PKG.EXTRACT_SOURCE_LEDGER_TBL;
1593: p_ledger_id_tbl ZX_EXTRACT_PKG.LEDGER_ID_TBL;
1594: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;

Line 1591: p_tax_rate_id_tbl ZX_EXTRACT_PKG.TAX_RATE_ID_TBL;

1587: p_taxable_amt_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_TBL;
1588: p_taxable_amt_funcl_curr_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL;
1589: p_tax_amt_tbl ZX_EXTRACT_PKG.TAX_AMT_TBL;
1590: p_tax_amt_funcl_curr_tbl ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL;
1591: p_tax_rate_id_tbl ZX_EXTRACT_PKG.TAX_RATE_ID_TBL;
1592: p_extract_source_ledger_tbl ZX_EXTRACT_PKG.EXTRACT_SOURCE_LEDGER_TBL;
1593: p_ledger_id_tbl ZX_EXTRACT_PKG.LEDGER_ID_TBL;
1594: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
1595: l_ccid_tbl t_ccid_tbl;

Line 1592: p_extract_source_ledger_tbl ZX_EXTRACT_PKG.EXTRACT_SOURCE_LEDGER_TBL;

1588: p_taxable_amt_funcl_curr_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL;
1589: p_tax_amt_tbl ZX_EXTRACT_PKG.TAX_AMT_TBL;
1590: p_tax_amt_funcl_curr_tbl ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL;
1591: p_tax_rate_id_tbl ZX_EXTRACT_PKG.TAX_RATE_ID_TBL;
1592: p_extract_source_ledger_tbl ZX_EXTRACT_PKG.EXTRACT_SOURCE_LEDGER_TBL;
1593: p_ledger_id_tbl ZX_EXTRACT_PKG.LEDGER_ID_TBL;
1594: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
1595: l_ccid_tbl t_ccid_tbl;
1596: l_acct_date_tbl t_acct_date_tbl;

Line 1593: p_ledger_id_tbl ZX_EXTRACT_PKG.LEDGER_ID_TBL;

1589: p_tax_amt_tbl ZX_EXTRACT_PKG.TAX_AMT_TBL;
1590: p_tax_amt_funcl_curr_tbl ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL;
1591: p_tax_rate_id_tbl ZX_EXTRACT_PKG.TAX_RATE_ID_TBL;
1592: p_extract_source_ledger_tbl ZX_EXTRACT_PKG.EXTRACT_SOURCE_LEDGER_TBL;
1593: p_ledger_id_tbl ZX_EXTRACT_PKG.LEDGER_ID_TBL;
1594: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
1595: l_ccid_tbl t_ccid_tbl;
1596: l_acct_date_tbl t_acct_date_tbl;
1597: l_percent_tbl numtab;

Line 1594: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;

1590: p_tax_amt_funcl_curr_tbl ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL;
1591: p_tax_rate_id_tbl ZX_EXTRACT_PKG.TAX_RATE_ID_TBL;
1592: p_extract_source_ledger_tbl ZX_EXTRACT_PKG.EXTRACT_SOURCE_LEDGER_TBL;
1593: p_ledger_id_tbl ZX_EXTRACT_PKG.LEDGER_ID_TBL;
1594: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
1595: l_ccid_tbl t_ccid_tbl;
1596: l_acct_date_tbl t_acct_date_tbl;
1597: l_percent_tbl numtab;
1598: l_taxable_amt_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_TBL;

Line 1598: l_taxable_amt_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_TBL;

1594: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
1595: l_ccid_tbl t_ccid_tbl;
1596: l_acct_date_tbl t_acct_date_tbl;
1597: l_percent_tbl numtab;
1598: l_taxable_amt_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_TBL;
1599: l_taxable_amt_funcl_curr_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL;
1600: l_tax_amt_tbl ZX_EXTRACT_PKG.TAX_AMT_TBL;
1601: l_tax_amt_funcl_curr_tbl ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL;
1602: l_precision_tbl numtab;

Line 1599: l_taxable_amt_funcl_curr_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL;

1595: l_ccid_tbl t_ccid_tbl;
1596: l_acct_date_tbl t_acct_date_tbl;
1597: l_percent_tbl numtab;
1598: l_taxable_amt_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_TBL;
1599: l_taxable_amt_funcl_curr_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL;
1600: l_tax_amt_tbl ZX_EXTRACT_PKG.TAX_AMT_TBL;
1601: l_tax_amt_funcl_curr_tbl ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL;
1602: l_precision_tbl numtab;
1603: l_minimum_accountable_unit_tbl numtab;

Line 1600: l_tax_amt_tbl ZX_EXTRACT_PKG.TAX_AMT_TBL;

1596: l_acct_date_tbl t_acct_date_tbl;
1597: l_percent_tbl numtab;
1598: l_taxable_amt_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_TBL;
1599: l_taxable_amt_funcl_curr_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL;
1600: l_tax_amt_tbl ZX_EXTRACT_PKG.TAX_AMT_TBL;
1601: l_tax_amt_funcl_curr_tbl ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL;
1602: l_precision_tbl numtab;
1603: l_minimum_accountable_unit_tbl numtab;
1604: l_func_precision NUMBER;

Line 1601: l_tax_amt_funcl_curr_tbl ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL;

1597: l_percent_tbl numtab;
1598: l_taxable_amt_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_TBL;
1599: l_taxable_amt_funcl_curr_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL;
1600: l_tax_amt_tbl ZX_EXTRACT_PKG.TAX_AMT_TBL;
1601: l_tax_amt_funcl_curr_tbl ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL;
1602: l_precision_tbl numtab;
1603: l_minimum_accountable_unit_tbl numtab;
1604: l_func_precision NUMBER;
1605: l_func_min_account_unit NUMBER;