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 473: P_TRL_GLOBAL_VARIABLES_REC IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE

469:
470:
471: PROCEDURE FILTER_JA_AP_TAX_LINES
472: (
473: P_TRL_GLOBAL_VARIABLES_REC IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE
474: )
475:
476: /* Following parameters are removed since we now access global variables directly
477: (

Line 753: P_TRL_GLOBAL_VARIABLES_REC IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE

749: +===========================================================================*/
750:
751: PROCEDURE POPULATE_JA_AR
752: (
753: P_TRL_GLOBAL_VARIABLES_REC IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE
754: )
755:
756: /* Following parameter is removed since we now access global variables directly
757: (

Line 856: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;

852:
853: lp_count_taxable number(15);
854: test varchar2(200);
855:
856: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
857: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
858: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
859: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
860: l_trx_batch_source_name_tbl ZX_EXTRACT_PKG.TRX_BATCH_SOURCE_NAME_TBL;

Line 857: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;

853: lp_count_taxable number(15);
854: test varchar2(200);
855:
856: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
857: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
858: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
859: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
860: l_trx_batch_source_name_tbl ZX_EXTRACT_PKG.TRX_BATCH_SOURCE_NAME_TBL;
861: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;

Line 858: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;

854: test varchar2(200);
855:
856: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
857: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
858: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
859: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
860: l_trx_batch_source_name_tbl ZX_EXTRACT_PKG.TRX_BATCH_SOURCE_NAME_TBL;
861: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
862: l_prod_fisc_classification_tbl ZX_EXTRACT_PKG.PROD_FISC_CLASSIFICATION_TBL;

Line 859: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;

855:
856: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
857: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
858: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
859: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
860: l_trx_batch_source_name_tbl ZX_EXTRACT_PKG.TRX_BATCH_SOURCE_NAME_TBL;
861: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
862: l_prod_fisc_classification_tbl ZX_EXTRACT_PKG.PROD_FISC_CLASSIFICATION_TBL;
863:

Line 860: l_trx_batch_source_name_tbl ZX_EXTRACT_PKG.TRX_BATCH_SOURCE_NAME_TBL;

856: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
857: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
858: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
859: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
860: l_trx_batch_source_name_tbl ZX_EXTRACT_PKG.TRX_BATCH_SOURCE_NAME_TBL;
861: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
862: l_prod_fisc_classification_tbl ZX_EXTRACT_PKG.PROD_FISC_CLASSIFICATION_TBL;
863:
864: l_location_code_tbl ATTRIBUTE1_TBL;

Line 861: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;

857: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
858: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
859: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
860: l_trx_batch_source_name_tbl ZX_EXTRACT_PKG.TRX_BATCH_SOURCE_NAME_TBL;
861: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
862: l_prod_fisc_classification_tbl ZX_EXTRACT_PKG.PROD_FISC_CLASSIFICATION_TBL;
863:
864: l_location_code_tbl ATTRIBUTE1_TBL;
865: l_address_line_1_tbl ATTRIBUTE1_TBL;

Line 862: l_prod_fisc_classification_tbl ZX_EXTRACT_PKG.PROD_FISC_CLASSIFICATION_TBL;

858: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
859: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
860: l_trx_batch_source_name_tbl ZX_EXTRACT_PKG.TRX_BATCH_SOURCE_NAME_TBL;
861: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
862: l_prod_fisc_classification_tbl ZX_EXTRACT_PKG.PROD_FISC_CLASSIFICATION_TBL;
863:
864: l_location_code_tbl ATTRIBUTE1_TBL;
865: l_address_line_1_tbl ATTRIBUTE1_TBL;
866: l_address_line_2_tbl ATTRIBUTE1_TBL;

Line 879: l_trx_date_tbl zx_extract_pkg.trx_date_tbl;

875: l_ind_sub_classif_tbl ATTRIBUTE1_TBL;
876: l_ind_classif_tbl ATTRIBUTE1_TBL;
877:
878: --Bug 5251425
879: l_trx_date_tbl zx_extract_pkg.trx_date_tbl;
880: x_trx_date_tbl zx_extract_pkg.trx_date_tbl;
881: l_canonical_date VARCHAR2(20);
882: l_roc_year NUMBER(15);
883: l_roc_mmdd VARCHAR2(5);

Line 880: x_trx_date_tbl zx_extract_pkg.trx_date_tbl;

876: l_ind_classif_tbl ATTRIBUTE1_TBL;
877:
878: --Bug 5251425
879: l_trx_date_tbl zx_extract_pkg.trx_date_tbl;
880: x_trx_date_tbl zx_extract_pkg.trx_date_tbl;
881: l_canonical_date VARCHAR2(20);
882: l_roc_year NUMBER(15);
883: l_roc_mmdd VARCHAR2(5);
884: l_roc_date VARCHAR2(20);

Line 1326: P_TRL_GLOBAL_VARIABLES_REC IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE

1322:
1323:
1324: PROCEDURE POPULATE_JA_AP
1325: (
1326: P_TRL_GLOBAL_VARIABLES_REC IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE
1327: )
1328:
1329: /* Following parameter is removed since we now access global variables directly
1330: (

Line 1414: l_trx_date_tbl zx_extract_pkg.trx_date_tbl;

1410: P_LOOKUP_TYPE varchar2(100);
1411: P_LOOKUP_CODE varchar2(1000);
1412: P_VENDOR_ID number(15);
1413: P_INVOICE_NUM varchar2(30);
1414: l_trx_date_tbl zx_extract_pkg.trx_date_tbl;
1415:
1416: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
1417: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
1418: l_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;

Line 1416: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;

1412: P_VENDOR_ID number(15);
1413: P_INVOICE_NUM varchar2(30);
1414: l_trx_date_tbl zx_extract_pkg.trx_date_tbl;
1415:
1416: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
1417: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
1418: l_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;
1419: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
1420: l_tax_status_id_tbl ZX_EXTRACT_PKG.TAX_STATUS_ID_TBL;

Line 1417: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;

1413: P_INVOICE_NUM varchar2(30);
1414: l_trx_date_tbl zx_extract_pkg.trx_date_tbl;
1415:
1416: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
1417: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
1418: l_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;
1419: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
1420: l_tax_status_id_tbl ZX_EXTRACT_PKG.TAX_STATUS_ID_TBL;
1421: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;

Line 1418: l_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;

1414: l_trx_date_tbl zx_extract_pkg.trx_date_tbl;
1415:
1416: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
1417: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
1418: l_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;
1419: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
1420: l_tax_status_id_tbl ZX_EXTRACT_PKG.TAX_STATUS_ID_TBL;
1421: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
1422: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;

Line 1419: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;

1415:
1416: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
1417: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
1418: l_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;
1419: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
1420: l_tax_status_id_tbl ZX_EXTRACT_PKG.TAX_STATUS_ID_TBL;
1421: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
1422: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
1423: l_billing_tp_id_tbl ZX_EXTRACT_PKG.BILLING_TRADING_PARTNER_ID_TBL;

Line 1420: l_tax_status_id_tbl ZX_EXTRACT_PKG.TAX_STATUS_ID_TBL;

1416: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
1417: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
1418: l_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;
1419: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
1420: l_tax_status_id_tbl ZX_EXTRACT_PKG.TAX_STATUS_ID_TBL;
1421: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
1422: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
1423: l_billing_tp_id_tbl ZX_EXTRACT_PKG.BILLING_TRADING_PARTNER_ID_TBL;
1424: l_adjusted_doc_number_tbl ZX_EXTRACT_PKG.ADJUSTED_DOC_NUMBER_TBL;

Line 1421: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;

1417: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
1418: l_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;
1419: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
1420: l_tax_status_id_tbl ZX_EXTRACT_PKG.TAX_STATUS_ID_TBL;
1421: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
1422: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
1423: l_billing_tp_id_tbl ZX_EXTRACT_PKG.BILLING_TRADING_PARTNER_ID_TBL;
1424: l_adjusted_doc_number_tbl ZX_EXTRACT_PKG.ADJUSTED_DOC_NUMBER_TBL;
1425: l_taxable_amt_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_TBL;

Line 1422: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;

1418: l_trx_line_id_tbl ZX_EXTRACT_PKG.TRX_LINE_ID_TBL;
1419: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
1420: l_tax_status_id_tbl ZX_EXTRACT_PKG.TAX_STATUS_ID_TBL;
1421: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
1422: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
1423: l_billing_tp_id_tbl ZX_EXTRACT_PKG.BILLING_TRADING_PARTNER_ID_TBL;
1424: l_adjusted_doc_number_tbl ZX_EXTRACT_PKG.ADJUSTED_DOC_NUMBER_TBL;
1425: l_taxable_amt_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_TBL;
1426: l_currency_conversion_rate_tbl ZX_EXTRACT_PKG.CURRENCY_CONVERSION_RATE_TBL;

Line 1423: l_billing_tp_id_tbl ZX_EXTRACT_PKG.BILLING_TRADING_PARTNER_ID_TBL;

1419: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
1420: l_tax_status_id_tbl ZX_EXTRACT_PKG.TAX_STATUS_ID_TBL;
1421: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
1422: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
1423: l_billing_tp_id_tbl ZX_EXTRACT_PKG.BILLING_TRADING_PARTNER_ID_TBL;
1424: l_adjusted_doc_number_tbl ZX_EXTRACT_PKG.ADJUSTED_DOC_NUMBER_TBL;
1425: l_taxable_amt_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_TBL;
1426: l_currency_conversion_rate_tbl ZX_EXTRACT_PKG.CURRENCY_CONVERSION_RATE_TBL;
1427: l_precision_tbl ZX_EXTRACT_PKG.PRECISION_TBL;

Line 1424: l_adjusted_doc_number_tbl ZX_EXTRACT_PKG.ADJUSTED_DOC_NUMBER_TBL;

1420: l_tax_status_id_tbl ZX_EXTRACT_PKG.TAX_STATUS_ID_TBL;
1421: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
1422: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
1423: l_billing_tp_id_tbl ZX_EXTRACT_PKG.BILLING_TRADING_PARTNER_ID_TBL;
1424: l_adjusted_doc_number_tbl ZX_EXTRACT_PKG.ADJUSTED_DOC_NUMBER_TBL;
1425: l_taxable_amt_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_TBL;
1426: l_currency_conversion_rate_tbl ZX_EXTRACT_PKG.CURRENCY_CONVERSION_RATE_TBL;
1427: l_precision_tbl ZX_EXTRACT_PKG.PRECISION_TBL;
1428: l_supplier_exchange_rate_tbl ZX_EXTRACT_PKG.SUPPLIER_EXCHANGE_RATE_TBL;

Line 1425: l_taxable_amt_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_TBL;

1421: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
1422: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
1423: l_billing_tp_id_tbl ZX_EXTRACT_PKG.BILLING_TRADING_PARTNER_ID_TBL;
1424: l_adjusted_doc_number_tbl ZX_EXTRACT_PKG.ADJUSTED_DOC_NUMBER_TBL;
1425: l_taxable_amt_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_TBL;
1426: l_currency_conversion_rate_tbl ZX_EXTRACT_PKG.CURRENCY_CONVERSION_RATE_TBL;
1427: l_precision_tbl ZX_EXTRACT_PKG.PRECISION_TBL;
1428: l_supplier_exchange_rate_tbl ZX_EXTRACT_PKG.SUPPLIER_EXCHANGE_RATE_TBL;
1429: l_tax_amt_tbl ZX_EXTRACT_PKG.TAX_AMT_TBL;

Line 1426: l_currency_conversion_rate_tbl ZX_EXTRACT_PKG.CURRENCY_CONVERSION_RATE_TBL;

1422: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
1423: l_billing_tp_id_tbl ZX_EXTRACT_PKG.BILLING_TRADING_PARTNER_ID_TBL;
1424: l_adjusted_doc_number_tbl ZX_EXTRACT_PKG.ADJUSTED_DOC_NUMBER_TBL;
1425: l_taxable_amt_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_TBL;
1426: l_currency_conversion_rate_tbl ZX_EXTRACT_PKG.CURRENCY_CONVERSION_RATE_TBL;
1427: l_precision_tbl ZX_EXTRACT_PKG.PRECISION_TBL;
1428: l_supplier_exchange_rate_tbl ZX_EXTRACT_PKG.SUPPLIER_EXCHANGE_RATE_TBL;
1429: l_tax_amt_tbl ZX_EXTRACT_PKG.TAX_AMT_TBL;
1430: l_applied_to_trx_number_tbl ZX_EXTRACT_PKG.APPLIED_TO_TRX_NUMBER_TBL;

Line 1427: l_precision_tbl ZX_EXTRACT_PKG.PRECISION_TBL;

1423: l_billing_tp_id_tbl ZX_EXTRACT_PKG.BILLING_TRADING_PARTNER_ID_TBL;
1424: l_adjusted_doc_number_tbl ZX_EXTRACT_PKG.ADJUSTED_DOC_NUMBER_TBL;
1425: l_taxable_amt_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_TBL;
1426: l_currency_conversion_rate_tbl ZX_EXTRACT_PKG.CURRENCY_CONVERSION_RATE_TBL;
1427: l_precision_tbl ZX_EXTRACT_PKG.PRECISION_TBL;
1428: l_supplier_exchange_rate_tbl ZX_EXTRACT_PKG.SUPPLIER_EXCHANGE_RATE_TBL;
1429: l_tax_amt_tbl ZX_EXTRACT_PKG.TAX_AMT_TBL;
1430: l_applied_to_trx_number_tbl ZX_EXTRACT_PKG.APPLIED_TO_TRX_NUMBER_TBL;
1431:

Line 1428: l_supplier_exchange_rate_tbl ZX_EXTRACT_PKG.SUPPLIER_EXCHANGE_RATE_TBL;

1424: l_adjusted_doc_number_tbl ZX_EXTRACT_PKG.ADJUSTED_DOC_NUMBER_TBL;
1425: l_taxable_amt_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_TBL;
1426: l_currency_conversion_rate_tbl ZX_EXTRACT_PKG.CURRENCY_CONVERSION_RATE_TBL;
1427: l_precision_tbl ZX_EXTRACT_PKG.PRECISION_TBL;
1428: l_supplier_exchange_rate_tbl ZX_EXTRACT_PKG.SUPPLIER_EXCHANGE_RATE_TBL;
1429: l_tax_amt_tbl ZX_EXTRACT_PKG.TAX_AMT_TBL;
1430: l_applied_to_trx_number_tbl ZX_EXTRACT_PKG.APPLIED_TO_TRX_NUMBER_TBL;
1431:
1432: l_location_code_tbl ATTRIBUTE1_TBL;

Line 1429: l_tax_amt_tbl ZX_EXTRACT_PKG.TAX_AMT_TBL;

1425: l_taxable_amt_tbl ZX_EXTRACT_PKG.TAXABLE_AMT_TBL;
1426: l_currency_conversion_rate_tbl ZX_EXTRACT_PKG.CURRENCY_CONVERSION_RATE_TBL;
1427: l_precision_tbl ZX_EXTRACT_PKG.PRECISION_TBL;
1428: l_supplier_exchange_rate_tbl ZX_EXTRACT_PKG.SUPPLIER_EXCHANGE_RATE_TBL;
1429: l_tax_amt_tbl ZX_EXTRACT_PKG.TAX_AMT_TBL;
1430: l_applied_to_trx_number_tbl ZX_EXTRACT_PKG.APPLIED_TO_TRX_NUMBER_TBL;
1431:
1432: l_location_code_tbl ATTRIBUTE1_TBL;
1433: l_address_line_1_tbl ATTRIBUTE1_TBL;

Line 1430: l_applied_to_trx_number_tbl ZX_EXTRACT_PKG.APPLIED_TO_TRX_NUMBER_TBL;

1426: l_currency_conversion_rate_tbl ZX_EXTRACT_PKG.CURRENCY_CONVERSION_RATE_TBL;
1427: l_precision_tbl ZX_EXTRACT_PKG.PRECISION_TBL;
1428: l_supplier_exchange_rate_tbl ZX_EXTRACT_PKG.SUPPLIER_EXCHANGE_RATE_TBL;
1429: l_tax_amt_tbl ZX_EXTRACT_PKG.TAX_AMT_TBL;
1430: l_applied_to_trx_number_tbl ZX_EXTRACT_PKG.APPLIED_TO_TRX_NUMBER_TBL;
1431:
1432: l_location_code_tbl ATTRIBUTE1_TBL;
1433: l_address_line_1_tbl ATTRIBUTE1_TBL;
1434: l_address_line_2_tbl ATTRIBUTE1_TBL;

Line 2634: P_TRL_GLOBAL_VARIABLES_REC IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE

2630:
2631:
2632: PROCEDURE bank_info
2633: (
2634: P_TRL_GLOBAL_VARIABLES_REC IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE
2635: )
2636: IS
2637:
2638: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;

Line 2638: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;

2634: P_TRL_GLOBAL_VARIABLES_REC IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE
2635: )
2636: IS
2637:
2638: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
2639:
2640: CURSOR reg_bank_count_cur IS
2641: SELECT reg.bank_id,
2642: reg.bank_branch_id,