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

146: | |
147: | Called from ARP_TAX_EXTRACT.POPULATE_MISSING_COLUMNS. |
148: | |
149: | Parameters : |
150: | IN: P_TRL_GLOBAL_VARIABLES_REC ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE|
151: | |
152: | |
153: | MODIFICATION HISTORY |
154: | 13-FEB-2006 RJREDDY Created |

Line 161: P_TRL_GLOBAL_VARIABLES_REC IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE

157: +===========================================================================*/
158:
159: PROCEDURE POPULATE_JE_AR
160: (
161: P_TRL_GLOBAL_VARIABLES_REC IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE
162: )
163:
164: IS
165:

Line 221: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;

217:
218: TYPE ATTRIBUTE28_TBL is TABLE OF
219: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE28%TYPE INDEX BY BINARY_INTEGER;
220:
221: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
222: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
223: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
224: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
225: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;

Line 222: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;

218: TYPE ATTRIBUTE28_TBL is TABLE OF
219: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE28%TYPE INDEX BY BINARY_INTEGER;
220:
221: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
222: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
223: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
224: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
225: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
226: l_tax_rate_id_tbl ZX_EXTRACT_PKG.tax_rate_id_tbl ;

Line 223: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;

219: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE28%TYPE INDEX BY BINARY_INTEGER;
220:
221: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
222: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
223: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
224: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
225: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
226: l_tax_rate_id_tbl ZX_EXTRACT_PKG.tax_rate_id_tbl ;
227: l_taxline_id_tbl ZX_EXTRACT_PKG.TAX_LINE_ID_TBL;

Line 224: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;

220:
221: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
222: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
223: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
224: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
225: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
226: l_tax_rate_id_tbl ZX_EXTRACT_PKG.tax_rate_id_tbl ;
227: l_taxline_id_tbl ZX_EXTRACT_PKG.TAX_LINE_ID_TBL;
228:

Line 225: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;

221: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
222: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
223: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
224: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
225: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
226: l_tax_rate_id_tbl ZX_EXTRACT_PKG.tax_rate_id_tbl ;
227: l_taxline_id_tbl ZX_EXTRACT_PKG.TAX_LINE_ID_TBL;
228:
229: l_attribute1_tbl ATTRIBUTE1_TBL;

Line 226: l_tax_rate_id_tbl ZX_EXTRACT_PKG.tax_rate_id_tbl ;

222: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
223: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
224: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
225: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
226: l_tax_rate_id_tbl ZX_EXTRACT_PKG.tax_rate_id_tbl ;
227: l_taxline_id_tbl ZX_EXTRACT_PKG.TAX_LINE_ID_TBL;
228:
229: l_attribute1_tbl ATTRIBUTE1_TBL;
230: l_attribute2_tbl ATTRIBUTE2_TBL;

Line 227: l_taxline_id_tbl ZX_EXTRACT_PKG.TAX_LINE_ID_TBL;

223: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
224: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
225: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
226: l_tax_rate_id_tbl ZX_EXTRACT_PKG.tax_rate_id_tbl ;
227: l_taxline_id_tbl ZX_EXTRACT_PKG.TAX_LINE_ID_TBL;
228:
229: l_attribute1_tbl ATTRIBUTE1_TBL;
230: l_attribute2_tbl ATTRIBUTE2_TBL;
231: l_attribute3_tbl ATTRIBUTE3_TBL;

Line 724: P_TRL_GLOBAL_VARIABLES_REC IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE

720:
721:
722: PROCEDURE POPULATE_JE_AP
723: (
724: P_TRL_GLOBAL_VARIABLES_REC IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE
725: )
726:
727: IS
728: TYPE ATTRIBUTE1_TBL is TABLE OF

Line 788: l_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;

784: TYPE ATTRIBUTE28_TBL is TABLE OF
785: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE28%TYPE INDEX BY BINARY_INTEGER;
786:
787: l_detail_tax_line_id_tbl DETAIL_TAX_LINE_ID_TBL;
788: l_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
789: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
790: l_tax_rate_id_tbl ZX_EXTRACT_PKG.tax_rate_id_tbl ;
791:
792: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;

Line 789: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;

785: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE28%TYPE INDEX BY BINARY_INTEGER;
786:
787: l_detail_tax_line_id_tbl DETAIL_TAX_LINE_ID_TBL;
788: l_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
789: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
790: l_tax_rate_id_tbl ZX_EXTRACT_PKG.tax_rate_id_tbl ;
791:
792: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
793: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;

Line 790: l_tax_rate_id_tbl ZX_EXTRACT_PKG.tax_rate_id_tbl ;

786:
787: l_detail_tax_line_id_tbl DETAIL_TAX_LINE_ID_TBL;
788: l_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
789: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
790: l_tax_rate_id_tbl ZX_EXTRACT_PKG.tax_rate_id_tbl ;
791:
792: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
793: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
794: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;

Line 792: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;

788: l_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
789: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
790: l_tax_rate_id_tbl ZX_EXTRACT_PKG.tax_rate_id_tbl ;
791:
792: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
793: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
794: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
795: l_taxline_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
796: l_attribute1_tbl ATTRIBUTE1_TBL;

Line 793: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;

789: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
790: l_tax_rate_id_tbl ZX_EXTRACT_PKG.tax_rate_id_tbl ;
791:
792: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
793: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
794: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
795: l_taxline_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
796: l_attribute1_tbl ATTRIBUTE1_TBL;
797: l_attribute2_tbl ATTRIBUTE2_TBL;

Line 794: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;

790: l_tax_rate_id_tbl ZX_EXTRACT_PKG.tax_rate_id_tbl ;
791:
792: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
793: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
794: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
795: l_taxline_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
796: l_attribute1_tbl ATTRIBUTE1_TBL;
797: l_attribute2_tbl ATTRIBUTE2_TBL;
798: l_attribute3_tbl ATTRIBUTE3_TBL;

Line 795: l_taxline_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;

791:
792: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
793: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
794: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
795: l_taxline_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
796: l_attribute1_tbl ATTRIBUTE1_TBL;
797: l_attribute2_tbl ATTRIBUTE2_TBL;
798: l_attribute3_tbl ATTRIBUTE3_TBL;
799: l_attribute4_tbl ATTRIBUTE4_TBL;

Line 1250: | IN: P_TRL_GLOBAL_VARIABLES_REC ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE|

1246: | |
1247: | Called from |
1248: | |
1249: | Parameters : |
1250: | IN: P_TRL_GLOBAL_VARIABLES_REC ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE|
1251: | |
1252: | |
1253: | MODIFICATION HISTORY |
1254: | 22-MAY-2006 VSDOSHI Created |

Line 1261: P_TRL_GLOBAL_VARIABLES_REC IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE

1257: +===========================================================================*/
1258:
1259: PROCEDURE POPULATE_JE_GL
1260: (
1261: P_TRL_GLOBAL_VARIABLES_REC IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE
1262: )
1263:
1264: IS
1265:

Line 1312: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;

1308: l_attribute5_tmp_tbl ATTRIBUTE5_TBL;
1309: l_attribute6_tmp_tbl ATTRIBUTE6_TBL;
1310: l_attribute7_tmp_tbl ATTRIBUTE7_TBL;
1311:
1312: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
1313: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
1314: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
1315: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
1316: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;

Line 1313: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;

1309: l_attribute6_tmp_tbl ATTRIBUTE6_TBL;
1310: l_attribute7_tmp_tbl ATTRIBUTE7_TBL;
1311:
1312: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
1313: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
1314: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
1315: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
1316: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
1317: l_tax_rate_id_tbl ZX_EXTRACT_PKG.tax_rate_id_tbl ;

Line 1314: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;

1310: l_attribute7_tmp_tbl ATTRIBUTE7_TBL;
1311:
1312: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
1313: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
1314: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
1315: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
1316: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
1317: l_tax_rate_id_tbl ZX_EXTRACT_PKG.tax_rate_id_tbl ;
1318: L_COUNT NUMBER ;

Line 1315: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;

1311:
1312: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
1313: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
1314: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
1315: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
1316: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
1317: l_tax_rate_id_tbl ZX_EXTRACT_PKG.tax_rate_id_tbl ;
1318: L_COUNT NUMBER ;
1319: C_LINES_PER_COMMIT Number:=1000;

Line 1316: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;

1312: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
1313: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
1314: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
1315: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
1316: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
1317: l_tax_rate_id_tbl ZX_EXTRACT_PKG.tax_rate_id_tbl ;
1318: L_COUNT NUMBER ;
1319: C_LINES_PER_COMMIT Number:=1000;
1320:

Line 1317: l_tax_rate_id_tbl ZX_EXTRACT_PKG.tax_rate_id_tbl ;

1313: l_trx_id_tbl ZX_EXTRACT_PKG.TRX_ID_TBL;
1314: l_tax_status_code_tbl ZX_EXTRACT_PKG.TAX_STATUS_CODE_TBL;
1315: l_trx_business_category_tbl ZX_EXTRACT_PKG.TRX_BUSINESS_CATEGORY_TBL;
1316: l_document_sub_type_tbl ZX_EXTRACT_PKG.DOCUMENT_SUB_TYPE_TBL;
1317: l_tax_rate_id_tbl ZX_EXTRACT_PKG.tax_rate_id_tbl ;
1318: L_COUNT NUMBER ;
1319: C_LINES_PER_COMMIT Number:=1000;
1320:
1321: CURSOR get_reporting_code_value(