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_JA_EXTRACT_PKG dependencies on ZX_EXTRACT_PKG

Line 26: P_TRL_GLOBAL_VARIABLES_REC IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE

22:
23:
24: PROCEDURE bank_info
25: (
26: P_TRL_GLOBAL_VARIABLES_REC IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE
27: );
28:
29: PROCEDURE GET_INVOICE_AMT
30: (

Line 113: P_TRL_GLOBAL_VARIABLES_REC IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE

109:
110:
111: PROCEDURE FILTER_JA_AR_TAX_LINES
112: (
113: P_TRL_GLOBAL_VARIABLES_REC IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE
114: )
115:
116: /* Following parameters are removed since we now access global variables directly
117: (

Line 461: P_TRL_GLOBAL_VARIABLES_REC IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE

457:
458:
459: PROCEDURE FILTER_JA_AP_TAX_LINES
460: (
461: P_TRL_GLOBAL_VARIABLES_REC IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE
462: )
463:
464: /* Following parameters are removed since we now access global variables directly
465: (

Line 741: P_TRL_GLOBAL_VARIABLES_REC IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE

737: +===========================================================================*/
738:
739: PROCEDURE POPULATE_JA_AR
740: (
741: P_TRL_GLOBAL_VARIABLES_REC IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE
742: )
743:
744: /* Following parameter is removed since we now access global variables directly
745: (

Line 844: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;

840:
841: lp_count_taxable number(15);
842: test varchar2(200);
843:
844: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
845: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
846: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
847: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
848: l_trx_batch_source_name_tbl ZX_EXTRACT_PKG.TRX_BATCH_SOURCE_NAME_TBL;

Line 845: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;

841: lp_count_taxable number(15);
842: test varchar2(200);
843:
844: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
845: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
846: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
847: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
848: l_trx_batch_source_name_tbl ZX_EXTRACT_PKG.TRX_BATCH_SOURCE_NAME_TBL;
849: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;

Line 846: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;

842: test varchar2(200);
843:
844: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
845: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
846: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
847: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
848: l_trx_batch_source_name_tbl ZX_EXTRACT_PKG.TRX_BATCH_SOURCE_NAME_TBL;
849: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
850: l_prod_fisc_classification_tbl ZX_EXTRACT_PKG.PROD_FISC_CLASSIFICATION_TBL;

Line 847: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;

843:
844: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
845: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
846: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
847: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
848: l_trx_batch_source_name_tbl ZX_EXTRACT_PKG.TRX_BATCH_SOURCE_NAME_TBL;
849: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
850: l_prod_fisc_classification_tbl ZX_EXTRACT_PKG.PROD_FISC_CLASSIFICATION_TBL;
851:

Line 848: l_trx_batch_source_name_tbl ZX_EXTRACT_PKG.TRX_BATCH_SOURCE_NAME_TBL;

844: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
845: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
846: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
847: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
848: l_trx_batch_source_name_tbl ZX_EXTRACT_PKG.TRX_BATCH_SOURCE_NAME_TBL;
849: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
850: l_prod_fisc_classification_tbl ZX_EXTRACT_PKG.PROD_FISC_CLASSIFICATION_TBL;
851:
852: l_location_code_tbl ATTRIBUTE1_TBL;

Line 849: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;

845: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
846: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
847: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
848: l_trx_batch_source_name_tbl ZX_EXTRACT_PKG.TRX_BATCH_SOURCE_NAME_TBL;
849: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
850: l_prod_fisc_classification_tbl ZX_EXTRACT_PKG.PROD_FISC_CLASSIFICATION_TBL;
851:
852: l_location_code_tbl ATTRIBUTE1_TBL;
853: l_address_line_1_tbl ATTRIBUTE1_TBL;

Line 850: l_prod_fisc_classification_tbl ZX_EXTRACT_PKG.PROD_FISC_CLASSIFICATION_TBL;

846: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
847: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
848: l_trx_batch_source_name_tbl ZX_EXTRACT_PKG.TRX_BATCH_SOURCE_NAME_TBL;
849: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
850: l_prod_fisc_classification_tbl ZX_EXTRACT_PKG.PROD_FISC_CLASSIFICATION_TBL;
851:
852: l_location_code_tbl ATTRIBUTE1_TBL;
853: l_address_line_1_tbl ATTRIBUTE1_TBL;
854: l_address_line_2_tbl ATTRIBUTE1_TBL;

Line 867: l_trx_date_tbl zx_extract_pkg.trx_date_tbl;

863: l_ind_sub_classif_tbl ATTRIBUTE1_TBL;
864: l_ind_classif_tbl ATTRIBUTE1_TBL;
865:
866: --Bug 5251425
867: l_trx_date_tbl zx_extract_pkg.trx_date_tbl;
868: x_trx_date_tbl zx_extract_pkg.trx_date_tbl;
869: l_canonical_date VARCHAR2(20);
870: l_roc_year NUMBER(15);
871: l_roc_mmdd VARCHAR2(5);

Line 868: x_trx_date_tbl zx_extract_pkg.trx_date_tbl;

864: l_ind_classif_tbl ATTRIBUTE1_TBL;
865:
866: --Bug 5251425
867: l_trx_date_tbl zx_extract_pkg.trx_date_tbl;
868: x_trx_date_tbl zx_extract_pkg.trx_date_tbl;
869: l_canonical_date VARCHAR2(20);
870: l_roc_year NUMBER(15);
871: l_roc_mmdd VARCHAR2(5);
872: l_roc_date VARCHAR2(20);

Line 1321: P_TRL_GLOBAL_VARIABLES_REC IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE

1317:
1318:
1319: PROCEDURE POPULATE_JA_AP
1320: (
1321: P_TRL_GLOBAL_VARIABLES_REC IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE
1322: )
1323:
1324: /* Following parameter is removed since we now access global variables directly
1325: (

Line 1409: l_trx_date_tbl zx_extract_pkg.trx_date_tbl;

1405: P_LOOKUP_TYPE varchar2(100);
1406: P_LOOKUP_CODE varchar2(1000);
1407: P_VENDOR_ID number(15);
1408: P_INVOICE_NUM varchar2(30);
1409: l_trx_date_tbl zx_extract_pkg.trx_date_tbl;
1410:
1411: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
1412: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
1413: l_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;

Line 1411: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;

1407: P_VENDOR_ID number(15);
1408: P_INVOICE_NUM varchar2(30);
1409: l_trx_date_tbl zx_extract_pkg.trx_date_tbl;
1410:
1411: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
1412: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
1413: l_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;
1414: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
1415: l_tax_status_id_tbl ZX_EXTRACT_PKG.TAX_STATUS_ID_TBL;

Line 1412: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;

1408: P_INVOICE_NUM varchar2(30);
1409: l_trx_date_tbl zx_extract_pkg.trx_date_tbl;
1410:
1411: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
1412: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
1413: l_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;
1414: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
1415: l_tax_status_id_tbl ZX_EXTRACT_PKG.TAX_STATUS_ID_TBL;
1416: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;

Line 1413: l_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;

1409: l_trx_date_tbl zx_extract_pkg.trx_date_tbl;
1410:
1411: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
1412: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
1413: l_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;
1414: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
1415: l_tax_status_id_tbl ZX_EXTRACT_PKG.TAX_STATUS_ID_TBL;
1416: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
1417: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;

Line 1414: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;

1410:
1411: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
1412: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
1413: l_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;
1414: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
1415: l_tax_status_id_tbl ZX_EXTRACT_PKG.TAX_STATUS_ID_TBL;
1416: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
1417: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
1418: l_billing_tp_id_tbl ZX_EXTRACT_PKG.BILLING_TRADING_PARTNER_ID_TBL;

Line 1415: l_tax_status_id_tbl ZX_EXTRACT_PKG.TAX_STATUS_ID_TBL;

1411: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
1412: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
1413: l_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;
1414: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
1415: l_tax_status_id_tbl ZX_EXTRACT_PKG.TAX_STATUS_ID_TBL;
1416: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
1417: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
1418: l_billing_tp_id_tbl ZX_EXTRACT_PKG.BILLING_TRADING_PARTNER_ID_TBL;
1419: l_adjusted_doc_number_tbl ZX_EXTRACT_PKG.ADJUSTED_DOC_NUMBER_TBL;

Line 1416: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;

1412: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
1413: l_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;
1414: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
1415: l_tax_status_id_tbl ZX_EXTRACT_PKG.TAX_STATUS_ID_TBL;
1416: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
1417: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
1418: l_billing_tp_id_tbl ZX_EXTRACT_PKG.BILLING_TRADING_PARTNER_ID_TBL;
1419: l_adjusted_doc_number_tbl ZX_EXTRACT_PKG.ADJUSTED_DOC_NUMBER_TBL;
1420: l_taxable_amt_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_TBL;

Line 1417: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;

1413: l_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;
1414: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
1415: l_tax_status_id_tbl ZX_EXTRACT_PKG.TAX_STATUS_ID_TBL;
1416: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
1417: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
1418: l_billing_tp_id_tbl ZX_EXTRACT_PKG.BILLING_TRADING_PARTNER_ID_TBL;
1419: l_adjusted_doc_number_tbl ZX_EXTRACT_PKG.ADJUSTED_DOC_NUMBER_TBL;
1420: l_taxable_amt_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_TBL;
1421: l_currency_conversion_rate_tbl ZX_EXTRACT_PKG.CURRENCY_CONVERSION_RATE_TBL;

Line 1418: l_billing_tp_id_tbl ZX_EXTRACT_PKG.BILLING_TRADING_PARTNER_ID_TBL;

1414: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
1415: l_tax_status_id_tbl ZX_EXTRACT_PKG.TAX_STATUS_ID_TBL;
1416: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
1417: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
1418: l_billing_tp_id_tbl ZX_EXTRACT_PKG.BILLING_TRADING_PARTNER_ID_TBL;
1419: l_adjusted_doc_number_tbl ZX_EXTRACT_PKG.ADJUSTED_DOC_NUMBER_TBL;
1420: l_taxable_amt_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_TBL;
1421: l_currency_conversion_rate_tbl ZX_EXTRACT_PKG.CURRENCY_CONVERSION_RATE_TBL;
1422: l_precision_tbl ZX_EXTRACT_PKG.PRECISION_TBL;

Line 1419: l_adjusted_doc_number_tbl ZX_EXTRACT_PKG.ADJUSTED_DOC_NUMBER_TBL;

1415: l_tax_status_id_tbl ZX_EXTRACT_PKG.TAX_STATUS_ID_TBL;
1416: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
1417: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
1418: l_billing_tp_id_tbl ZX_EXTRACT_PKG.BILLING_TRADING_PARTNER_ID_TBL;
1419: l_adjusted_doc_number_tbl ZX_EXTRACT_PKG.ADJUSTED_DOC_NUMBER_TBL;
1420: l_taxable_amt_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_TBL;
1421: l_currency_conversion_rate_tbl ZX_EXTRACT_PKG.CURRENCY_CONVERSION_RATE_TBL;
1422: l_precision_tbl ZX_EXTRACT_PKG.PRECISION_TBL;
1423: l_supplier_exchange_rate_tbl ZX_EXTRACT_PKG.SUPPLIER_EXCHANGE_RATE_TBL;

Line 1420: l_taxable_amt_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_TBL;

1416: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
1417: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
1418: l_billing_tp_id_tbl ZX_EXTRACT_PKG.BILLING_TRADING_PARTNER_ID_TBL;
1419: l_adjusted_doc_number_tbl ZX_EXTRACT_PKG.ADJUSTED_DOC_NUMBER_TBL;
1420: l_taxable_amt_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_TBL;
1421: l_currency_conversion_rate_tbl ZX_EXTRACT_PKG.CURRENCY_CONVERSION_RATE_TBL;
1422: l_precision_tbl ZX_EXTRACT_PKG.PRECISION_TBL;
1423: l_supplier_exchange_rate_tbl ZX_EXTRACT_PKG.SUPPLIER_EXCHANGE_RATE_TBL;
1424: l_tax_amt_tbl ZX_EXTRACT_PKG.TAX_AMT_TBL;

Line 1421: l_currency_conversion_rate_tbl ZX_EXTRACT_PKG.CURRENCY_CONVERSION_RATE_TBL;

1417: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
1418: l_billing_tp_id_tbl ZX_EXTRACT_PKG.BILLING_TRADING_PARTNER_ID_TBL;
1419: l_adjusted_doc_number_tbl ZX_EXTRACT_PKG.ADJUSTED_DOC_NUMBER_TBL;
1420: l_taxable_amt_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_TBL;
1421: l_currency_conversion_rate_tbl ZX_EXTRACT_PKG.CURRENCY_CONVERSION_RATE_TBL;
1422: l_precision_tbl ZX_EXTRACT_PKG.PRECISION_TBL;
1423: l_supplier_exchange_rate_tbl ZX_EXTRACT_PKG.SUPPLIER_EXCHANGE_RATE_TBL;
1424: l_tax_amt_tbl ZX_EXTRACT_PKG.TAX_AMT_TBL;
1425: l_applied_to_trx_number_tbl ZX_EXTRACT_PKG.APPLIED_TO_TRX_NUMBER_TBL;

Line 1422: l_precision_tbl ZX_EXTRACT_PKG.PRECISION_TBL;

1418: l_billing_tp_id_tbl ZX_EXTRACT_PKG.BILLING_TRADING_PARTNER_ID_TBL;
1419: l_adjusted_doc_number_tbl ZX_EXTRACT_PKG.ADJUSTED_DOC_NUMBER_TBL;
1420: l_taxable_amt_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_TBL;
1421: l_currency_conversion_rate_tbl ZX_EXTRACT_PKG.CURRENCY_CONVERSION_RATE_TBL;
1422: l_precision_tbl ZX_EXTRACT_PKG.PRECISION_TBL;
1423: l_supplier_exchange_rate_tbl ZX_EXTRACT_PKG.SUPPLIER_EXCHANGE_RATE_TBL;
1424: l_tax_amt_tbl ZX_EXTRACT_PKG.TAX_AMT_TBL;
1425: l_applied_to_trx_number_tbl ZX_EXTRACT_PKG.APPLIED_TO_TRX_NUMBER_TBL;
1426:

Line 1423: l_supplier_exchange_rate_tbl ZX_EXTRACT_PKG.SUPPLIER_EXCHANGE_RATE_TBL;

1419: l_adjusted_doc_number_tbl ZX_EXTRACT_PKG.ADJUSTED_DOC_NUMBER_TBL;
1420: l_taxable_amt_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_TBL;
1421: l_currency_conversion_rate_tbl ZX_EXTRACT_PKG.CURRENCY_CONVERSION_RATE_TBL;
1422: l_precision_tbl ZX_EXTRACT_PKG.PRECISION_TBL;
1423: l_supplier_exchange_rate_tbl ZX_EXTRACT_PKG.SUPPLIER_EXCHANGE_RATE_TBL;
1424: l_tax_amt_tbl ZX_EXTRACT_PKG.TAX_AMT_TBL;
1425: l_applied_to_trx_number_tbl ZX_EXTRACT_PKG.APPLIED_TO_TRX_NUMBER_TBL;
1426:
1427: l_location_code_tbl ATTRIBUTE1_TBL;

Line 1424: l_tax_amt_tbl ZX_EXTRACT_PKG.TAX_AMT_TBL;

1420: l_taxable_amt_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_TBL;
1421: l_currency_conversion_rate_tbl ZX_EXTRACT_PKG.CURRENCY_CONVERSION_RATE_TBL;
1422: l_precision_tbl ZX_EXTRACT_PKG.PRECISION_TBL;
1423: l_supplier_exchange_rate_tbl ZX_EXTRACT_PKG.SUPPLIER_EXCHANGE_RATE_TBL;
1424: l_tax_amt_tbl ZX_EXTRACT_PKG.TAX_AMT_TBL;
1425: l_applied_to_trx_number_tbl ZX_EXTRACT_PKG.APPLIED_TO_TRX_NUMBER_TBL;
1426:
1427: l_location_code_tbl ATTRIBUTE1_TBL;
1428: l_address_line_1_tbl ATTRIBUTE1_TBL;

Line 1425: l_applied_to_trx_number_tbl ZX_EXTRACT_PKG.APPLIED_TO_TRX_NUMBER_TBL;

1421: l_currency_conversion_rate_tbl ZX_EXTRACT_PKG.CURRENCY_CONVERSION_RATE_TBL;
1422: l_precision_tbl ZX_EXTRACT_PKG.PRECISION_TBL;
1423: l_supplier_exchange_rate_tbl ZX_EXTRACT_PKG.SUPPLIER_EXCHANGE_RATE_TBL;
1424: l_tax_amt_tbl ZX_EXTRACT_PKG.TAX_AMT_TBL;
1425: l_applied_to_trx_number_tbl ZX_EXTRACT_PKG.APPLIED_TO_TRX_NUMBER_TBL;
1426:
1427: l_location_code_tbl ATTRIBUTE1_TBL;
1428: l_address_line_1_tbl ATTRIBUTE1_TBL;
1429: l_address_line_2_tbl ATTRIBUTE1_TBL;

Line 2561: P_TRL_GLOBAL_VARIABLES_REC IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE

2557:
2558:
2559: PROCEDURE bank_info
2560: (
2561: P_TRL_GLOBAL_VARIABLES_REC IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE
2562: )
2563: IS
2564:
2565: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;

Line 2565: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;

2561: P_TRL_GLOBAL_VARIABLES_REC IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE
2562: )
2563: IS
2564:
2565: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
2566:
2567: CURSOR reg_bank_count_cur IS
2568: SELECT reg.bank_id,
2569: reg.bank_branch_id,