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 127: p_tax_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,

123:
124: PROCEDURE prorate_tax(p_tax_total IN NUMBER,
125: p_tax_funcl_curr_total IN NUMBER,
126: p_percent_tbl IN OUT NOCOPY numtab,
127: p_tax_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,
128: p_tax_amt_funcl_curr_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL,
129: p_precision_tbl IN OUT NOCOPY numtab,
130: p_minimum_accountable_unit_tbl IN OUT NOCOPY numtab,
131: p_func_precision IN NUMBER,

Line 128: p_tax_amt_funcl_curr_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL,

124: PROCEDURE prorate_tax(p_tax_total IN NUMBER,
125: p_tax_funcl_curr_total IN NUMBER,
126: p_percent_tbl IN OUT NOCOPY numtab,
127: p_tax_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,
128: p_tax_amt_funcl_curr_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL,
129: p_precision_tbl IN OUT NOCOPY numtab,
130: p_minimum_accountable_unit_tbl IN OUT NOCOPY numtab,
131: p_func_precision IN NUMBER,
132: p_func_min_account_unit IN NUMBER,

Line 243: PROCEDURE insert_row(p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,

239: * @parameter: p_acct_date_tbl
240: *
241: **/
242:
243: PROCEDURE insert_row(p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
244: p_taxable_amt_tbl IN ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
245: p_taxable_amt_funcl_curr_tbl IN ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,
246: p_tax_amt_tbl IN ZX_EXTRACT_PKG.TAX_AMT_TBL,
247: p_tax_amt_funcl_curr_tbl IN ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL,

Line 244: p_taxable_amt_tbl IN ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,

240: *
241: **/
242:
243: PROCEDURE insert_row(p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
244: p_taxable_amt_tbl IN ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
245: p_taxable_amt_funcl_curr_tbl IN ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,
246: p_tax_amt_tbl IN ZX_EXTRACT_PKG.TAX_AMT_TBL,
247: p_tax_amt_funcl_curr_tbl IN ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL,
248: p_ccid_tbl IN t_ccid_tbl,

Line 245: p_taxable_amt_funcl_curr_tbl IN ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,

241: **/
242:
243: PROCEDURE insert_row(p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
244: p_taxable_amt_tbl IN ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
245: p_taxable_amt_funcl_curr_tbl IN ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,
246: p_tax_amt_tbl IN ZX_EXTRACT_PKG.TAX_AMT_TBL,
247: p_tax_amt_funcl_curr_tbl IN ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL,
248: p_ccid_tbl IN t_ccid_tbl,
249: p_acct_date_tbl IN t_acct_date_tbl)

Line 246: p_tax_amt_tbl IN ZX_EXTRACT_PKG.TAX_AMT_TBL,

242:
243: PROCEDURE insert_row(p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
244: p_taxable_amt_tbl IN ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
245: p_taxable_amt_funcl_curr_tbl IN ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,
246: p_tax_amt_tbl IN ZX_EXTRACT_PKG.TAX_AMT_TBL,
247: p_tax_amt_funcl_curr_tbl IN ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL,
248: p_ccid_tbl IN t_ccid_tbl,
249: p_acct_date_tbl IN t_acct_date_tbl)
250:

Line 247: p_tax_amt_funcl_curr_tbl IN ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL,

243: PROCEDURE insert_row(p_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
244: p_taxable_amt_tbl IN ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
245: p_taxable_amt_funcl_curr_tbl IN ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,
246: p_tax_amt_tbl IN ZX_EXTRACT_PKG.TAX_AMT_TBL,
247: p_tax_amt_funcl_curr_tbl IN ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL,
248: p_ccid_tbl IN t_ccid_tbl,
249: p_acct_date_tbl IN t_acct_date_tbl)
250:
251: IS

Line 390: PROCEDURE initialize(p_trl_global_variables_rec IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE,

386: *
387: *
388: **/
389:
390: PROCEDURE initialize(p_trl_global_variables_rec IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE,
391: l_func_precision OUT NOCOPY NUMBER,
392: l_func_min_account_unit OUT NOCOPY NUMBER,
393: l_sob_type OUT NOCOPY VARCHAR2)
394: IS

Line 581: PROCEDURE reset_result_tables(p_detail_tax_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,

577: * @parameter: l_acct_date_tbl
578: *
579: **/
580:
581: PROCEDURE reset_result_tables(p_detail_tax_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
582: p_trx_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TRX_ID_TBL,
583: p_tax_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,
584: p_trx_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
585: p_tax_dist_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.ACTG_SOURCE_ID_TBL,

Line 582: p_trx_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TRX_ID_TBL,

578: *
579: **/
580:
581: PROCEDURE reset_result_tables(p_detail_tax_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
582: p_trx_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TRX_ID_TBL,
583: p_tax_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,
584: p_trx_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
585: p_tax_dist_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.ACTG_SOURCE_ID_TBL,
586: p_event_class_code_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL,

Line 583: p_tax_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,

579: **/
580:
581: PROCEDURE reset_result_tables(p_detail_tax_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
582: p_trx_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TRX_ID_TBL,
583: p_tax_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,
584: p_trx_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
585: p_tax_dist_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.ACTG_SOURCE_ID_TBL,
586: p_event_class_code_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL,
587: p_taxable_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,

Line 584: p_trx_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,

580:
581: PROCEDURE reset_result_tables(p_detail_tax_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
582: p_trx_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TRX_ID_TBL,
583: p_tax_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,
584: p_trx_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
585: p_tax_dist_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.ACTG_SOURCE_ID_TBL,
586: p_event_class_code_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL,
587: p_taxable_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
588: p_tax_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,

Line 585: p_tax_dist_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.ACTG_SOURCE_ID_TBL,

581: PROCEDURE reset_result_tables(p_detail_tax_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
582: p_trx_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TRX_ID_TBL,
583: p_tax_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,
584: p_trx_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
585: p_tax_dist_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.ACTG_SOURCE_ID_TBL,
586: p_event_class_code_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL,
587: p_taxable_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
588: p_tax_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,
589: p_tax_amt_funcl_curr_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL,

Line 586: p_event_class_code_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL,

582: p_trx_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TRX_ID_TBL,
583: p_tax_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,
584: p_trx_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
585: p_tax_dist_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.ACTG_SOURCE_ID_TBL,
586: p_event_class_code_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL,
587: p_taxable_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
588: p_tax_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,
589: p_tax_amt_funcl_curr_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL,
590: p_tax_rate_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,

Line 587: p_taxable_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,

583: p_tax_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,
584: p_trx_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
585: p_tax_dist_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.ACTG_SOURCE_ID_TBL,
586: p_event_class_code_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL,
587: p_taxable_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
588: p_tax_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,
589: p_tax_amt_funcl_curr_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL,
590: p_tax_rate_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,
591: p_extract_source_ledger_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.EXTRACT_SOURCE_LEDGER_TBL,

Line 588: p_tax_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,

584: p_trx_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
585: p_tax_dist_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.ACTG_SOURCE_ID_TBL,
586: p_event_class_code_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL,
587: p_taxable_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
588: p_tax_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,
589: p_tax_amt_funcl_curr_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL,
590: p_tax_rate_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,
591: p_extract_source_ledger_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.EXTRACT_SOURCE_LEDGER_TBL,
592: p_ledger_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.LEDGER_ID_TBL,

Line 589: p_tax_amt_funcl_curr_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL,

585: p_tax_dist_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.ACTG_SOURCE_ID_TBL,
586: p_event_class_code_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL,
587: p_taxable_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
588: p_tax_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,
589: p_tax_amt_funcl_curr_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL,
590: p_tax_rate_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,
591: p_extract_source_ledger_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.EXTRACT_SOURCE_LEDGER_TBL,
592: p_ledger_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.LEDGER_ID_TBL,
593: l_detail_tax_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,

Line 590: p_tax_rate_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,

586: p_event_class_code_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL,
587: p_taxable_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
588: p_tax_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,
589: p_tax_amt_funcl_curr_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL,
590: p_tax_rate_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,
591: p_extract_source_ledger_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.EXTRACT_SOURCE_LEDGER_TBL,
592: p_ledger_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.LEDGER_ID_TBL,
593: l_detail_tax_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
594: l_taxable_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,

Line 591: p_extract_source_ledger_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.EXTRACT_SOURCE_LEDGER_TBL,

587: p_taxable_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
588: p_tax_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,
589: p_tax_amt_funcl_curr_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL,
590: p_tax_rate_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,
591: p_extract_source_ledger_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.EXTRACT_SOURCE_LEDGER_TBL,
592: p_ledger_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.LEDGER_ID_TBL,
593: l_detail_tax_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
594: l_taxable_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
595: l_taxable_amt_funcl_curr_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,

Line 592: p_ledger_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.LEDGER_ID_TBL,

588: p_tax_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,
589: p_tax_amt_funcl_curr_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL,
590: p_tax_rate_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,
591: p_extract_source_ledger_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.EXTRACT_SOURCE_LEDGER_TBL,
592: p_ledger_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.LEDGER_ID_TBL,
593: l_detail_tax_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
594: l_taxable_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
595: l_taxable_amt_funcl_curr_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,
596: l_tax_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,

Line 593: l_detail_tax_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,

589: p_tax_amt_funcl_curr_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL,
590: p_tax_rate_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,
591: p_extract_source_ledger_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.EXTRACT_SOURCE_LEDGER_TBL,
592: p_ledger_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.LEDGER_ID_TBL,
593: l_detail_tax_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
594: l_taxable_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
595: l_taxable_amt_funcl_curr_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,
596: l_tax_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,
597: l_tax_amt_funcl_curr_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL,

Line 594: l_taxable_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,

590: p_tax_rate_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,
591: p_extract_source_ledger_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.EXTRACT_SOURCE_LEDGER_TBL,
592: p_ledger_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.LEDGER_ID_TBL,
593: l_detail_tax_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
594: l_taxable_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
595: l_taxable_amt_funcl_curr_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,
596: l_tax_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,
597: l_tax_amt_funcl_curr_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL,
598: l_ccid_tbl IN OUT NOCOPY t_ccid_tbl,

Line 595: l_taxable_amt_funcl_curr_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,

591: p_extract_source_ledger_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.EXTRACT_SOURCE_LEDGER_TBL,
592: p_ledger_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.LEDGER_ID_TBL,
593: l_detail_tax_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
594: l_taxable_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
595: l_taxable_amt_funcl_curr_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,
596: l_tax_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,
597: l_tax_amt_funcl_curr_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL,
598: l_ccid_tbl IN OUT NOCOPY t_ccid_tbl,
599: l_acct_date_tbl IN OUT NOCOPY t_acct_date_tbl)

Line 596: l_tax_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,

592: p_ledger_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.LEDGER_ID_TBL,
593: l_detail_tax_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
594: l_taxable_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
595: l_taxable_amt_funcl_curr_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,
596: l_tax_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,
597: l_tax_amt_funcl_curr_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL,
598: l_ccid_tbl IN OUT NOCOPY t_ccid_tbl,
599: l_acct_date_tbl IN OUT NOCOPY t_acct_date_tbl)
600:

Line 597: l_tax_amt_funcl_curr_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL,

593: l_detail_tax_line_id_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
594: l_taxable_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
595: l_taxable_amt_funcl_curr_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,
596: l_tax_amt_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,
597: l_tax_amt_funcl_curr_tbl IN OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL,
598: l_ccid_tbl IN OUT NOCOPY t_ccid_tbl,
599: l_acct_date_tbl IN OUT NOCOPY t_acct_date_tbl)
600:
601: IS

Line 676: PROCEDURE get_gl_taxable( c_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,

672: * @param p_func_min_account_unit
673: **/
674:
675:
676: PROCEDURE get_gl_taxable( c_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
677: c_trx_id_tbl IN ZX_EXTRACT_PKG.TRX_ID_TBL,
678: c_tax_line_id_tbl IN ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,
679: c_trx_line_id_tbl IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
680: t_detail_tax_line_id_tbl OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,

Line 677: c_trx_id_tbl IN ZX_EXTRACT_PKG.TRX_ID_TBL,

673: **/
674:
675:
676: PROCEDURE get_gl_taxable( c_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
677: c_trx_id_tbl IN ZX_EXTRACT_PKG.TRX_ID_TBL,
678: c_tax_line_id_tbl IN ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,
679: c_trx_line_id_tbl IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
680: t_detail_tax_line_id_tbl OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
681: t_ccid_tbl OUT NOCOPY t_ccid_tbl,

Line 678: c_tax_line_id_tbl IN ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,

674:
675:
676: PROCEDURE get_gl_taxable( c_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
677: c_trx_id_tbl IN ZX_EXTRACT_PKG.TRX_ID_TBL,
678: c_tax_line_id_tbl IN ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,
679: c_trx_line_id_tbl IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
680: t_detail_tax_line_id_tbl OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
681: t_ccid_tbl OUT NOCOPY t_ccid_tbl,
682: t_acct_date_tbl OUT NOCOPY t_acct_date_tbl,

Line 679: c_trx_line_id_tbl IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,

675:
676: PROCEDURE get_gl_taxable( c_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
677: c_trx_id_tbl IN ZX_EXTRACT_PKG.TRX_ID_TBL,
678: c_tax_line_id_tbl IN ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,
679: c_trx_line_id_tbl IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
680: t_detail_tax_line_id_tbl OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
681: t_ccid_tbl OUT NOCOPY t_ccid_tbl,
682: t_acct_date_tbl OUT NOCOPY t_acct_date_tbl,
683: t_taxable_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,

Line 680: t_detail_tax_line_id_tbl OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,

676: PROCEDURE get_gl_taxable( c_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
677: c_trx_id_tbl IN ZX_EXTRACT_PKG.TRX_ID_TBL,
678: c_tax_line_id_tbl IN ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,
679: c_trx_line_id_tbl IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
680: t_detail_tax_line_id_tbl OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
681: t_ccid_tbl OUT NOCOPY t_ccid_tbl,
682: t_acct_date_tbl OUT NOCOPY t_acct_date_tbl,
683: t_taxable_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
684: t_taxable_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,

Line 683: t_taxable_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,

679: c_trx_line_id_tbl IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
680: t_detail_tax_line_id_tbl OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
681: t_ccid_tbl OUT NOCOPY t_ccid_tbl,
682: t_acct_date_tbl OUT NOCOPY t_acct_date_tbl,
683: t_taxable_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
684: t_taxable_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,
685: t_tax_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,
686: t_tax_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL
687: )

Line 684: t_taxable_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,

680: t_detail_tax_line_id_tbl OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
681: t_ccid_tbl OUT NOCOPY t_ccid_tbl,
682: t_acct_date_tbl OUT NOCOPY t_acct_date_tbl,
683: t_taxable_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
684: t_taxable_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,
685: t_tax_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,
686: t_tax_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL
687: )
688: IS

Line 685: t_tax_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,

681: t_ccid_tbl OUT NOCOPY t_ccid_tbl,
682: t_acct_date_tbl OUT NOCOPY t_acct_date_tbl,
683: t_taxable_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
684: t_taxable_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,
685: t_tax_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,
686: t_tax_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL
687: )
688: IS
689:

Line 686: t_tax_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL

682: t_acct_date_tbl OUT NOCOPY t_acct_date_tbl,
683: t_taxable_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
684: t_taxable_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,
685: t_tax_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,
686: t_tax_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL
687: )
688: IS
689:
690: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;

Line 690: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;

686: t_tax_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL
687: )
688: IS
689:
690: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
691:
692: --
693: -- Cursor definition
694: --

Line 761: PROCEDURE get_ap_taxable( c_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,

757: *
758: **/
759:
760:
761: PROCEDURE get_ap_taxable( c_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
762: c_trx_id_tbl IN ZX_EXTRACT_PKG.TRX_ID_TBL,
763: c_tax_line_id_tbl IN ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,
764: c_trx_line_id_tbl IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
765: c_tax_dist_id_tbl IN ZX_EXTRACT_PKG.ACTG_SOURCE_ID_TBL,

Line 762: c_trx_id_tbl IN ZX_EXTRACT_PKG.TRX_ID_TBL,

758: **/
759:
760:
761: PROCEDURE get_ap_taxable( c_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
762: c_trx_id_tbl IN ZX_EXTRACT_PKG.TRX_ID_TBL,
763: c_tax_line_id_tbl IN ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,
764: c_trx_line_id_tbl IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
765: c_tax_dist_id_tbl IN ZX_EXTRACT_PKG.ACTG_SOURCE_ID_TBL,
766: c_ledger_id_tbl IN ZX_EXTRACT_PKG.ledger_id_tbl,

Line 763: c_tax_line_id_tbl IN ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,

759:
760:
761: PROCEDURE get_ap_taxable( c_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
762: c_trx_id_tbl IN ZX_EXTRACT_PKG.TRX_ID_TBL,
763: c_tax_line_id_tbl IN ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,
764: c_trx_line_id_tbl IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
765: c_tax_dist_id_tbl IN ZX_EXTRACT_PKG.ACTG_SOURCE_ID_TBL,
766: c_ledger_id_tbl IN ZX_EXTRACT_PKG.ledger_id_tbl,
767: t_detail_tax_line_id_tbl OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,

Line 764: c_trx_line_id_tbl IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,

760:
761: PROCEDURE get_ap_taxable( c_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
762: c_trx_id_tbl IN ZX_EXTRACT_PKG.TRX_ID_TBL,
763: c_tax_line_id_tbl IN ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,
764: c_trx_line_id_tbl IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
765: c_tax_dist_id_tbl IN ZX_EXTRACT_PKG.ACTG_SOURCE_ID_TBL,
766: c_ledger_id_tbl IN ZX_EXTRACT_PKG.ledger_id_tbl,
767: t_detail_tax_line_id_tbl OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
768: t_ccid_tbl OUT NOCOPY t_ccid_tbl,

Line 765: c_tax_dist_id_tbl IN ZX_EXTRACT_PKG.ACTG_SOURCE_ID_TBL,

761: PROCEDURE get_ap_taxable( c_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
762: c_trx_id_tbl IN ZX_EXTRACT_PKG.TRX_ID_TBL,
763: c_tax_line_id_tbl IN ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,
764: c_trx_line_id_tbl IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
765: c_tax_dist_id_tbl IN ZX_EXTRACT_PKG.ACTG_SOURCE_ID_TBL,
766: c_ledger_id_tbl IN ZX_EXTRACT_PKG.ledger_id_tbl,
767: t_detail_tax_line_id_tbl OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
768: t_ccid_tbl OUT NOCOPY t_ccid_tbl,
769: t_acct_date_tbl OUT NOCOPY t_acct_date_tbl,

Line 766: c_ledger_id_tbl IN ZX_EXTRACT_PKG.ledger_id_tbl,

762: c_trx_id_tbl IN ZX_EXTRACT_PKG.TRX_ID_TBL,
763: c_tax_line_id_tbl IN ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,
764: c_trx_line_id_tbl IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
765: c_tax_dist_id_tbl IN ZX_EXTRACT_PKG.ACTG_SOURCE_ID_TBL,
766: c_ledger_id_tbl IN ZX_EXTRACT_PKG.ledger_id_tbl,
767: t_detail_tax_line_id_tbl OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
768: t_ccid_tbl OUT NOCOPY t_ccid_tbl,
769: t_acct_date_tbl OUT NOCOPY t_acct_date_tbl,
770: t_taxable_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,

Line 767: t_detail_tax_line_id_tbl OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,

763: c_tax_line_id_tbl IN ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,
764: c_trx_line_id_tbl IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
765: c_tax_dist_id_tbl IN ZX_EXTRACT_PKG.ACTG_SOURCE_ID_TBL,
766: c_ledger_id_tbl IN ZX_EXTRACT_PKG.ledger_id_tbl,
767: t_detail_tax_line_id_tbl OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
768: t_ccid_tbl OUT NOCOPY t_ccid_tbl,
769: t_acct_date_tbl OUT NOCOPY t_acct_date_tbl,
770: t_taxable_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
771: t_taxable_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,

Line 770: t_taxable_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,

766: c_ledger_id_tbl IN ZX_EXTRACT_PKG.ledger_id_tbl,
767: t_detail_tax_line_id_tbl OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
768: t_ccid_tbl OUT NOCOPY t_ccid_tbl,
769: t_acct_date_tbl OUT NOCOPY t_acct_date_tbl,
770: t_taxable_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
771: t_taxable_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,
772: t_tax_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,
773: t_tax_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL
774: )

Line 771: t_taxable_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,

767: t_detail_tax_line_id_tbl OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
768: t_ccid_tbl OUT NOCOPY t_ccid_tbl,
769: t_acct_date_tbl OUT NOCOPY t_acct_date_tbl,
770: t_taxable_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
771: t_taxable_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,
772: t_tax_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,
773: t_tax_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL
774: )
775: IS

Line 772: t_tax_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,

768: t_ccid_tbl OUT NOCOPY t_ccid_tbl,
769: t_acct_date_tbl OUT NOCOPY t_acct_date_tbl,
770: t_taxable_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
771: t_taxable_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,
772: t_tax_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,
773: t_tax_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL
774: )
775: IS
776:

Line 773: t_tax_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL

769: t_acct_date_tbl OUT NOCOPY t_acct_date_tbl,
770: t_taxable_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
771: t_taxable_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,
772: t_tax_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,
773: t_tax_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL
774: )
775: IS
776:
777: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;

Line 777: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;

773: t_tax_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL
774: )
775: IS
776:
777: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
778: j INTEGER;
779: k INTEGER;
780: k_taxable_amt_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_TBL;
781:

Line 780: k_taxable_amt_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_TBL;

776:
777: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
778: j INTEGER;
779: k INTEGER;
780: k_taxable_amt_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_TBL;
781:
782: --
783: -- Private Data Type
784: --

Line 977: PROCEDURE get_ar_taxable(c_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,

973: * @param p_func_min_account_unit
974: *
975: **/
976:
977: PROCEDURE get_ar_taxable(c_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
978: c_event_class_code_tbl IN ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL,
979: c_trx_id_tbl IN ZX_EXTRACT_PKG.TRX_ID_TBL,
980: c_tax_line_id_tbl IN ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,
981: c_trx_line_id_tbl IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,

Line 978: c_event_class_code_tbl IN ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL,

974: *
975: **/
976:
977: PROCEDURE get_ar_taxable(c_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
978: c_event_class_code_tbl IN ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL,
979: c_trx_id_tbl IN ZX_EXTRACT_PKG.TRX_ID_TBL,
980: c_tax_line_id_tbl IN ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,
981: c_trx_line_id_tbl IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
982: c_taxable_amt_tbl IN ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,

Line 979: c_trx_id_tbl IN ZX_EXTRACT_PKG.TRX_ID_TBL,

975: **/
976:
977: PROCEDURE get_ar_taxable(c_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
978: c_event_class_code_tbl IN ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL,
979: c_trx_id_tbl IN ZX_EXTRACT_PKG.TRX_ID_TBL,
980: c_tax_line_id_tbl IN ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,
981: c_trx_line_id_tbl IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
982: c_taxable_amt_tbl IN ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
983: c_tax_amt_tbl IN ZX_EXTRACT_PKG.TAX_AMT_TBL,

Line 980: c_tax_line_id_tbl IN ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,

976:
977: PROCEDURE get_ar_taxable(c_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
978: c_event_class_code_tbl IN ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL,
979: c_trx_id_tbl IN ZX_EXTRACT_PKG.TRX_ID_TBL,
980: c_tax_line_id_tbl IN ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,
981: c_trx_line_id_tbl IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
982: c_taxable_amt_tbl IN ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
983: c_tax_amt_tbl IN ZX_EXTRACT_PKG.TAX_AMT_TBL,
984: c_tax_amt_funcl_curr_tbl IN ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL,

Line 981: c_trx_line_id_tbl IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,

977: PROCEDURE get_ar_taxable(c_detail_tax_line_id_tbl IN ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
978: c_event_class_code_tbl IN ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL,
979: c_trx_id_tbl IN ZX_EXTRACT_PKG.TRX_ID_TBL,
980: c_tax_line_id_tbl IN ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,
981: c_trx_line_id_tbl IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
982: c_taxable_amt_tbl IN ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
983: c_tax_amt_tbl IN ZX_EXTRACT_PKG.TAX_AMT_TBL,
984: c_tax_amt_funcl_curr_tbl IN ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL,
985: c_tax_rate_id_tbl IN ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,

Line 982: c_taxable_amt_tbl IN ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,

978: c_event_class_code_tbl IN ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL,
979: c_trx_id_tbl IN ZX_EXTRACT_PKG.TRX_ID_TBL,
980: c_tax_line_id_tbl IN ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,
981: c_trx_line_id_tbl IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
982: c_taxable_amt_tbl IN ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
983: c_tax_amt_tbl IN ZX_EXTRACT_PKG.TAX_AMT_TBL,
984: c_tax_amt_funcl_curr_tbl IN ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL,
985: c_tax_rate_id_tbl IN ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,
986: p_sob_type IN VARCHAR2,

Line 983: c_tax_amt_tbl IN ZX_EXTRACT_PKG.TAX_AMT_TBL,

979: c_trx_id_tbl IN ZX_EXTRACT_PKG.TRX_ID_TBL,
980: c_tax_line_id_tbl IN ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,
981: c_trx_line_id_tbl IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
982: c_taxable_amt_tbl IN ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
983: c_tax_amt_tbl IN ZX_EXTRACT_PKG.TAX_AMT_TBL,
984: c_tax_amt_funcl_curr_tbl IN ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL,
985: c_tax_rate_id_tbl IN ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,
986: p_sob_type IN VARCHAR2,
987: p_func_precision IN NUMBER,

Line 984: c_tax_amt_funcl_curr_tbl IN ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL,

980: c_tax_line_id_tbl IN ZX_EXTRACT_PKG.TAX_LINE_ID_TBL,
981: c_trx_line_id_tbl IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
982: c_taxable_amt_tbl IN ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
983: c_tax_amt_tbl IN ZX_EXTRACT_PKG.TAX_AMT_TBL,
984: c_tax_amt_funcl_curr_tbl IN ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL,
985: c_tax_rate_id_tbl IN ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,
986: p_sob_type IN VARCHAR2,
987: p_func_precision IN NUMBER,
988: p_func_min_account_unit IN NUMBER,

Line 985: c_tax_rate_id_tbl IN ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,

981: c_trx_line_id_tbl IN ZX_EXTRACT_PKG.TRX_LINE_ID_TBL,
982: c_taxable_amt_tbl IN ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
983: c_tax_amt_tbl IN ZX_EXTRACT_PKG.TAX_AMT_TBL,
984: c_tax_amt_funcl_curr_tbl IN ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL,
985: c_tax_rate_id_tbl IN ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,
986: p_sob_type IN VARCHAR2,
987: p_func_precision IN NUMBER,
988: p_func_min_account_unit IN NUMBER,
989: t_detail_tax_line_id_tbl OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,

Line 989: t_detail_tax_line_id_tbl OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,

985: c_tax_rate_id_tbl IN ZX_EXTRACT_PKG.TAX_RATE_ID_TBL,
986: p_sob_type IN VARCHAR2,
987: p_func_precision IN NUMBER,
988: p_func_min_account_unit IN NUMBER,
989: t_detail_tax_line_id_tbl OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
990: t_ccid_tbl OUT NOCOPY t_ccid_tbl,
991: t_acct_date_tbl OUT NOCOPY t_acct_date_tbl,
992: t_taxable_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
993: t_taxable_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,

Line 992: t_taxable_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,

988: p_func_min_account_unit IN NUMBER,
989: t_detail_tax_line_id_tbl OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
990: t_ccid_tbl OUT NOCOPY t_ccid_tbl,
991: t_acct_date_tbl OUT NOCOPY t_acct_date_tbl,
992: t_taxable_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
993: t_taxable_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,
994: t_tax_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,
995: t_tax_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL) IS
996:

Line 993: t_taxable_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,

989: t_detail_tax_line_id_tbl OUT NOCOPY ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL,
990: t_ccid_tbl OUT NOCOPY t_ccid_tbl,
991: t_acct_date_tbl OUT NOCOPY t_acct_date_tbl,
992: t_taxable_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
993: t_taxable_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,
994: t_tax_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,
995: t_tax_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL) IS
996:
997:

Line 994: t_tax_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,

990: t_ccid_tbl OUT NOCOPY t_ccid_tbl,
991: t_acct_date_tbl OUT NOCOPY t_acct_date_tbl,
992: t_taxable_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
993: t_taxable_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,
994: t_tax_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,
995: t_tax_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL) IS
996:
997:
998: CURSOR c_ar_inv (c_detail_tax_line_id in NUMBER) IS

Line 995: t_tax_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL) IS

991: t_acct_date_tbl OUT NOCOPY t_acct_date_tbl,
992: t_taxable_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_TBL,
993: t_taxable_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL,
994: t_tax_amt_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_TBL,
995: t_tax_amt_funcl_curr_tbl OUT NOCOPY ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL) IS
996:
997:
998: CURSOR c_ar_inv (c_detail_tax_line_id in NUMBER) IS
999: SELECT detail_tax_line_id,

Line 1091: l_tax_amt_tbl ZX_EXTRACT_PKG.TAX_AMT_TBL;

1087: l_ra_customer_trx_lines VARCHAR2(30);
1088: l_ra_cust_trx_line_gl_dist VARCHAR2(30);
1089:
1090: l_percent_tbl numtab;
1091: l_tax_amt_tbl ZX_EXTRACT_PKG.TAX_AMT_TBL;
1092: l_tax_amt_funcl_curr_tbl ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL;
1093: l_precision_tbl numtab;
1094: l_minimum_accountable_unit_tbl numtab;
1095:

Line 1092: l_tax_amt_funcl_curr_tbl ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL;

1088: l_ra_cust_trx_line_gl_dist VARCHAR2(30);
1089:
1090: l_percent_tbl numtab;
1091: l_tax_amt_tbl ZX_EXTRACT_PKG.TAX_AMT_TBL;
1092: l_tax_amt_funcl_curr_tbl ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL;
1093: l_precision_tbl numtab;
1094: l_minimum_accountable_unit_tbl numtab;
1095:
1096: j INTEGER;

Line 1616: PROCEDURE get_taxable(p_trl_global_variables_rec IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE)

1612: * @param p_trx_global_variabl_variables_rec
1613: *
1614: **/
1615:
1616: PROCEDURE get_taxable(p_trl_global_variables_rec IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE)
1617:
1618: IS
1619:
1620: --

Line 1623: p_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;

1619:
1620: --
1621: -- Private Parameters
1622: --
1623: p_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
1624: p_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
1625: p_tax_line_id_tbl ZX_EXTRACT_PKG.TAX_LINE_ID_TBL;
1626: p_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;
1627: p_tax_dist_id_tbl ZX_EXTRACT_PKG.actg_source_id_tbl;

Line 1624: p_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;

1620: --
1621: -- Private Parameters
1622: --
1623: p_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
1624: p_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
1625: p_tax_line_id_tbl ZX_EXTRACT_PKG.TAX_LINE_ID_TBL;
1626: p_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;
1627: p_tax_dist_id_tbl ZX_EXTRACT_PKG.actg_source_id_tbl;
1628: p_event_class_code_tbl ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL;

Line 1625: p_tax_line_id_tbl ZX_EXTRACT_PKG.TAX_LINE_ID_TBL;

1621: -- Private Parameters
1622: --
1623: p_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
1624: p_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
1625: p_tax_line_id_tbl ZX_EXTRACT_PKG.TAX_LINE_ID_TBL;
1626: p_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;
1627: p_tax_dist_id_tbl ZX_EXTRACT_PKG.actg_source_id_tbl;
1628: p_event_class_code_tbl ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL;
1629: p_taxable_amt_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_TBL;

Line 1626: p_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;

1622: --
1623: p_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
1624: p_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
1625: p_tax_line_id_tbl ZX_EXTRACT_PKG.TAX_LINE_ID_TBL;
1626: p_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;
1627: p_tax_dist_id_tbl ZX_EXTRACT_PKG.actg_source_id_tbl;
1628: p_event_class_code_tbl ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL;
1629: p_taxable_amt_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_TBL;
1630: p_tax_amt_tbl ZX_EXTRACT_PKG.TAX_AMT_TBL;

Line 1627: p_tax_dist_id_tbl ZX_EXTRACT_PKG.actg_source_id_tbl;

1623: p_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
1624: p_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
1625: p_tax_line_id_tbl ZX_EXTRACT_PKG.TAX_LINE_ID_TBL;
1626: p_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;
1627: p_tax_dist_id_tbl ZX_EXTRACT_PKG.actg_source_id_tbl;
1628: p_event_class_code_tbl ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL;
1629: p_taxable_amt_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_TBL;
1630: p_tax_amt_tbl ZX_EXTRACT_PKG.TAX_AMT_TBL;
1631: p_tax_amt_funcl_curr_tbl ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL;

Line 1628: p_event_class_code_tbl ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL;

1624: p_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
1625: p_tax_line_id_tbl ZX_EXTRACT_PKG.TAX_LINE_ID_TBL;
1626: p_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;
1627: p_tax_dist_id_tbl ZX_EXTRACT_PKG.actg_source_id_tbl;
1628: p_event_class_code_tbl ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL;
1629: p_taxable_amt_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_TBL;
1630: p_tax_amt_tbl ZX_EXTRACT_PKG.TAX_AMT_TBL;
1631: p_tax_amt_funcl_curr_tbl ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL;
1632: p_tax_rate_id_tbl ZX_EXTRACT_PKG.TAX_RATE_ID_TBL;

Line 1629: p_taxable_amt_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_TBL;

1625: p_tax_line_id_tbl ZX_EXTRACT_PKG.TAX_LINE_ID_TBL;
1626: p_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;
1627: p_tax_dist_id_tbl ZX_EXTRACT_PKG.actg_source_id_tbl;
1628: p_event_class_code_tbl ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL;
1629: p_taxable_amt_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_TBL;
1630: p_tax_amt_tbl ZX_EXTRACT_PKG.TAX_AMT_TBL;
1631: p_tax_amt_funcl_curr_tbl ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL;
1632: p_tax_rate_id_tbl ZX_EXTRACT_PKG.TAX_RATE_ID_TBL;
1633: p_extract_source_ledger_tbl ZX_EXTRACT_PKG.EXTRACT_SOURCE_LEDGER_TBL;

Line 1630: p_tax_amt_tbl ZX_EXTRACT_PKG.TAX_AMT_TBL;

1626: p_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;
1627: p_tax_dist_id_tbl ZX_EXTRACT_PKG.actg_source_id_tbl;
1628: p_event_class_code_tbl ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL;
1629: p_taxable_amt_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_TBL;
1630: p_tax_amt_tbl ZX_EXTRACT_PKG.TAX_AMT_TBL;
1631: p_tax_amt_funcl_curr_tbl ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL;
1632: p_tax_rate_id_tbl ZX_EXTRACT_PKG.TAX_RATE_ID_TBL;
1633: p_extract_source_ledger_tbl ZX_EXTRACT_PKG.EXTRACT_SOURCE_LEDGER_TBL;
1634: p_ledger_id_tbl ZX_EXTRACT_PKG.LEDGER_ID_TBL;

Line 1631: p_tax_amt_funcl_curr_tbl ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL;

1627: p_tax_dist_id_tbl ZX_EXTRACT_PKG.actg_source_id_tbl;
1628: p_event_class_code_tbl ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL;
1629: p_taxable_amt_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_TBL;
1630: p_tax_amt_tbl ZX_EXTRACT_PKG.TAX_AMT_TBL;
1631: p_tax_amt_funcl_curr_tbl ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL;
1632: p_tax_rate_id_tbl ZX_EXTRACT_PKG.TAX_RATE_ID_TBL;
1633: p_extract_source_ledger_tbl ZX_EXTRACT_PKG.EXTRACT_SOURCE_LEDGER_TBL;
1634: p_ledger_id_tbl ZX_EXTRACT_PKG.LEDGER_ID_TBL;
1635:

Line 1632: p_tax_rate_id_tbl ZX_EXTRACT_PKG.TAX_RATE_ID_TBL;

1628: p_event_class_code_tbl ZX_EXTRACT_PKG.EVENT_CLASS_CODE_TBL;
1629: p_taxable_amt_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_TBL;
1630: p_tax_amt_tbl ZX_EXTRACT_PKG.TAX_AMT_TBL;
1631: p_tax_amt_funcl_curr_tbl ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL;
1632: p_tax_rate_id_tbl ZX_EXTRACT_PKG.TAX_RATE_ID_TBL;
1633: p_extract_source_ledger_tbl ZX_EXTRACT_PKG.EXTRACT_SOURCE_LEDGER_TBL;
1634: p_ledger_id_tbl ZX_EXTRACT_PKG.LEDGER_ID_TBL;
1635:
1636:

Line 1633: p_extract_source_ledger_tbl ZX_EXTRACT_PKG.EXTRACT_SOURCE_LEDGER_TBL;

1629: p_taxable_amt_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_TBL;
1630: p_tax_amt_tbl ZX_EXTRACT_PKG.TAX_AMT_TBL;
1631: p_tax_amt_funcl_curr_tbl ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL;
1632: p_tax_rate_id_tbl ZX_EXTRACT_PKG.TAX_RATE_ID_TBL;
1633: p_extract_source_ledger_tbl ZX_EXTRACT_PKG.EXTRACT_SOURCE_LEDGER_TBL;
1634: p_ledger_id_tbl ZX_EXTRACT_PKG.LEDGER_ID_TBL;
1635:
1636:
1637: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;

Line 1634: p_ledger_id_tbl ZX_EXTRACT_PKG.LEDGER_ID_TBL;

1630: p_tax_amt_tbl ZX_EXTRACT_PKG.TAX_AMT_TBL;
1631: p_tax_amt_funcl_curr_tbl ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL;
1632: p_tax_rate_id_tbl ZX_EXTRACT_PKG.TAX_RATE_ID_TBL;
1633: p_extract_source_ledger_tbl ZX_EXTRACT_PKG.EXTRACT_SOURCE_LEDGER_TBL;
1634: p_ledger_id_tbl ZX_EXTRACT_PKG.LEDGER_ID_TBL;
1635:
1636:
1637: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
1638: l_ccid_tbl t_ccid_tbl;

Line 1637: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;

1633: p_extract_source_ledger_tbl ZX_EXTRACT_PKG.EXTRACT_SOURCE_LEDGER_TBL;
1634: p_ledger_id_tbl ZX_EXTRACT_PKG.LEDGER_ID_TBL;
1635:
1636:
1637: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
1638: l_ccid_tbl t_ccid_tbl;
1639: l_acct_date_tbl t_acct_date_tbl;
1640: l_percent_tbl numtab;
1641: l_taxable_amt_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_TBL;

Line 1641: l_taxable_amt_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_TBL;

1637: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
1638: l_ccid_tbl t_ccid_tbl;
1639: l_acct_date_tbl t_acct_date_tbl;
1640: l_percent_tbl numtab;
1641: l_taxable_amt_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_TBL;
1642: l_taxable_amt_funcl_curr_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL;
1643: l_tax_amt_tbl ZX_EXTRACT_PKG.TAX_AMT_TBL;
1644: l_tax_amt_funcl_curr_tbl ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL;
1645: l_precision_tbl numtab;

Line 1642: l_taxable_amt_funcl_curr_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL;

1638: l_ccid_tbl t_ccid_tbl;
1639: l_acct_date_tbl t_acct_date_tbl;
1640: l_percent_tbl numtab;
1641: l_taxable_amt_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_TBL;
1642: l_taxable_amt_funcl_curr_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL;
1643: l_tax_amt_tbl ZX_EXTRACT_PKG.TAX_AMT_TBL;
1644: l_tax_amt_funcl_curr_tbl ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL;
1645: l_precision_tbl numtab;
1646: l_minimum_accountable_unit_tbl numtab;

Line 1643: l_tax_amt_tbl ZX_EXTRACT_PKG.TAX_AMT_TBL;

1639: l_acct_date_tbl t_acct_date_tbl;
1640: l_percent_tbl numtab;
1641: l_taxable_amt_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_TBL;
1642: l_taxable_amt_funcl_curr_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL;
1643: l_tax_amt_tbl ZX_EXTRACT_PKG.TAX_AMT_TBL;
1644: l_tax_amt_funcl_curr_tbl ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL;
1645: l_precision_tbl numtab;
1646: l_minimum_accountable_unit_tbl numtab;
1647:

Line 1644: l_tax_amt_funcl_curr_tbl ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL;

1640: l_percent_tbl numtab;
1641: l_taxable_amt_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_TBL;
1642: l_taxable_amt_funcl_curr_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_FUNCL_CURR_TBL;
1643: l_tax_amt_tbl ZX_EXTRACT_PKG.TAX_AMT_TBL;
1644: l_tax_amt_funcl_curr_tbl ZX_EXTRACT_PKG.TAX_AMT_FUNCL_CURR_TBL;
1645: l_precision_tbl numtab;
1646: l_minimum_accountable_unit_tbl numtab;
1647:
1648: l_func_precision NUMBER;