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

Line 45: | IN: P_TRL_GLOBAL_VARIABLES_REC ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE|

41: | |
42: | Called from ARP_TAX_EXTRACT.POPULATE_MISSING_COLUMNS. |
43: | |
44: | Parameters : |
45: | IN: P_TRL_GLOBAL_VARIABLES_REC ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE|
46: | |
47: | |
48: | MODIFICATION HISTORY |
49: | 13-FEB-2006 RJREDDY Created |

Line 56: P_TRL_GLOBAL_VARIABLES_REC IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE

52: +===========================================================================*/
53:
54: PROCEDURE POPULATE_JE_AR
55: (
56: P_TRL_GLOBAL_VARIABLES_REC IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE
57: )
58:
59: IS
60:

Line 110: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;

106:
107: TYPE ATTRIBUTE26_TBL is TABLE OF
108: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE26%TYPE INDEX BY BINARY_INTEGER;
109:
110: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
111: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
112: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
113: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
114: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;

Line 111: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;

107: TYPE ATTRIBUTE26_TBL is TABLE OF
108: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE26%TYPE INDEX BY BINARY_INTEGER;
109:
110: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
111: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
112: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
113: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
114: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
115: l_tax_rate_id_tbl ZX_EXTRACT_PKG.tax_rate_id_tbl ;

Line 112: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;

108: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE26%TYPE INDEX BY BINARY_INTEGER;
109:
110: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
111: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
112: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
113: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
114: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
115: l_tax_rate_id_tbl ZX_EXTRACT_PKG.tax_rate_id_tbl ;
116:

Line 113: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;

109:
110: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
111: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
112: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
113: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
114: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
115: l_tax_rate_id_tbl ZX_EXTRACT_PKG.tax_rate_id_tbl ;
116:
117: l_attribute1_tbl ATTRIBUTE1_TBL;

Line 114: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;

110: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
111: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
112: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
113: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
114: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
115: l_tax_rate_id_tbl ZX_EXTRACT_PKG.tax_rate_id_tbl ;
116:
117: l_attribute1_tbl ATTRIBUTE1_TBL;
118: l_attribute2_tbl ATTRIBUTE2_TBL;

Line 115: l_tax_rate_id_tbl ZX_EXTRACT_PKG.tax_rate_id_tbl ;

111: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
112: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
113: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
114: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
115: l_tax_rate_id_tbl ZX_EXTRACT_PKG.tax_rate_id_tbl ;
116:
117: l_attribute1_tbl ATTRIBUTE1_TBL;
118: l_attribute2_tbl ATTRIBUTE2_TBL;
119: l_attribute3_tbl ATTRIBUTE3_TBL;

Line 474: P_TRL_GLOBAL_VARIABLES_REC IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE

470:
471:
472: PROCEDURE POPULATE_JE_AP
473: (
474: P_TRL_GLOBAL_VARIABLES_REC IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE
475: )
476:
477: IS
478: TYPE ATTRIBUTE1_TBL is TABLE OF

Line 537: l_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;

533: TYPE ATTRIBUTE26_TBL is TABLE OF
534: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE26%TYPE INDEX BY BINARY_INTEGER;
535:
536: l_detail_tax_line_id_tbl DETAIL_TAX_LINE_ID_TBL;
537: l_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
538: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
539: l_tax_rate_id_tbl ZX_EXTRACT_PKG.tax_rate_id_tbl ;
540:
541: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;

Line 538: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;

534: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE26%TYPE INDEX BY BINARY_INTEGER;
535:
536: l_detail_tax_line_id_tbl DETAIL_TAX_LINE_ID_TBL;
537: l_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
538: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
539: l_tax_rate_id_tbl ZX_EXTRACT_PKG.tax_rate_id_tbl ;
540:
541: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
542: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;

Line 539: l_tax_rate_id_tbl ZX_EXTRACT_PKG.tax_rate_id_tbl ;

535:
536: l_detail_tax_line_id_tbl DETAIL_TAX_LINE_ID_TBL;
537: l_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
538: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
539: l_tax_rate_id_tbl ZX_EXTRACT_PKG.tax_rate_id_tbl ;
540:
541: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
542: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
543: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;

Line 541: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;

537: l_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
538: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
539: l_tax_rate_id_tbl ZX_EXTRACT_PKG.tax_rate_id_tbl ;
540:
541: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
542: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
543: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
544:
545: l_attribute1_tbl ATTRIBUTE1_TBL;

Line 542: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;

538: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
539: l_tax_rate_id_tbl ZX_EXTRACT_PKG.tax_rate_id_tbl ;
540:
541: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
542: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
543: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
544:
545: l_attribute1_tbl ATTRIBUTE1_TBL;
546: l_attribute2_tbl ATTRIBUTE2_TBL;

Line 543: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;

539: l_tax_rate_id_tbl ZX_EXTRACT_PKG.tax_rate_id_tbl ;
540:
541: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
542: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
543: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
544:
545: l_attribute1_tbl ATTRIBUTE1_TBL;
546: l_attribute2_tbl ATTRIBUTE2_TBL;
547: l_attribute3_tbl ATTRIBUTE3_TBL;

Line 959: | IN: P_TRL_GLOBAL_VARIABLES_REC ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE|

955: | |
956: | Called from |
957: | |
958: | Parameters : |
959: | IN: P_TRL_GLOBAL_VARIABLES_REC ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE|
960: | |
961: | |
962: | MODIFICATION HISTORY |
963: | 22-MAY-2006 VSDOSHI Created |

Line 970: P_TRL_GLOBAL_VARIABLES_REC IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE

966: +===========================================================================*/
967:
968: PROCEDURE POPULATE_JE_GL
969: (
970: P_TRL_GLOBAL_VARIABLES_REC IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE
971: )
972:
973: IS
974:

Line 1021: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;

1017: l_attribute5_tmp_tbl ATTRIBUTE5_TBL;
1018: l_attribute6_tmp_tbl ATTRIBUTE6_TBL;
1019: l_attribute7_tmp_tbl ATTRIBUTE7_TBL;
1020:
1021: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
1022: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
1023: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
1024: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
1025: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;

Line 1022: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;

1018: l_attribute6_tmp_tbl ATTRIBUTE6_TBL;
1019: l_attribute7_tmp_tbl ATTRIBUTE7_TBL;
1020:
1021: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
1022: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
1023: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
1024: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
1025: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
1026: l_tax_rate_id_tbl ZX_EXTRACT_PKG.tax_rate_id_tbl ;

Line 1023: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;

1019: l_attribute7_tmp_tbl ATTRIBUTE7_TBL;
1020:
1021: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
1022: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
1023: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
1024: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
1025: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
1026: l_tax_rate_id_tbl ZX_EXTRACT_PKG.tax_rate_id_tbl ;
1027: L_COUNT NUMBER ;

Line 1024: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;

1020:
1021: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
1022: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
1023: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
1024: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
1025: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
1026: l_tax_rate_id_tbl ZX_EXTRACT_PKG.tax_rate_id_tbl ;
1027: L_COUNT NUMBER ;
1028: C_LINES_PER_COMMIT Number:=1000;

Line 1025: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;

1021: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
1022: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
1023: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
1024: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
1025: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
1026: l_tax_rate_id_tbl ZX_EXTRACT_PKG.tax_rate_id_tbl ;
1027: L_COUNT NUMBER ;
1028: C_LINES_PER_COMMIT Number:=1000;
1029:

Line 1026: l_tax_rate_id_tbl ZX_EXTRACT_PKG.tax_rate_id_tbl ;

1022: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
1023: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
1024: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
1025: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
1026: l_tax_rate_id_tbl ZX_EXTRACT_PKG.tax_rate_id_tbl ;
1027: L_COUNT NUMBER ;
1028: C_LINES_PER_COMMIT Number:=1000;
1029:
1030: CURSOR get_reporting_code_value(