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_SRVC_TYP_PKG dependencies on ZX_TRANSACTION_LINES_GT

Line 225: SELECT /+ INDEX(HEADER ZX_TRX_HEADERS_GT_U1) INDEX(TRXLINES ZX_TRANSACTION_LINES_GT_U1 /

221:
222:
223: /* Cursor for GTT version of calculate tax*/
224: Cursor lines(p_event_class_rec ZX_API_PUB.event_class_rec_type) is
225: SELECT /*+ INDEX(HEADER ZX_TRX_HEADERS_GT_U1) INDEX(TRXLINES ZX_TRANSACTION_LINES_GT_U1 */
226: header.INTERNAL_ORGANIZATION_ID ,
227: header.APPLICATION_ID ,
228: header.ENTITY_CODE ,
229: header.EVENT_CLASS_CODE ,

Line 584: FROM ZX_TRANSACTION_LINES_GT trxlines,

580: 'DELETE','U') ,
581: null)INSERT_UPDATE_FLAG
582: /* The update insert flag is to determine the records that need to be inserted/updated
583: into zx_lines_det_factors depending on the line_level_action for tax event type UPDATE*/
584: FROM ZX_TRANSACTION_LINES_GT trxlines,
585: ZX_TRX_HEADERS_GT header
586: WHERE header.application_id = p_event_class_rec.application_id
587: AND header.entity_code = p_event_class_rec.entity_code
588: AND header.event_class_code = p_event_class_rec.event_class_code

Line 601: SELECT /+ INDEX(HEADER ZX_TRX_HEADERS_GT_U1) INDEX(TRXLINES ZX_TRANSACTION_LINES_GT_U1) /

597:
598: -- bug fix 5417887 begin
599: /* Cursor for GTT version of calculate tax as well as import_document_with_tax AI */
600: Cursor c_lines(p_event_class_rec ZX_API_PUB.event_class_rec_type) is
601: SELECT /*+ INDEX(HEADER ZX_TRX_HEADERS_GT_U1) INDEX(TRXLINES ZX_TRANSACTION_LINES_GT_U1) */
602: header.INTERNAL_ORGANIZATION_ID ,
603: header.APPLICATION_ID ,
604: header.ENTITY_CODE ,
605: header.EVENT_CLASS_CODE ,

Line 959: FROM ZX_TRANSACTION_LINES_GT trxlines,

955: 'SYNCHRONIZE','U',
956: 'DELETE','U') INSERT_UPDATE_FLAG
957: /* The update insert flag is to determine the records that need to be inserted/updated
958: into zx_lines_det_factors depending on the line_level_action for tax event type UPDATE*/
959: FROM ZX_TRANSACTION_LINES_GT trxlines,
960: ZX_TRX_HEADERS_GT header
961: WHERE trxlines.application_id = header.application_id
962: AND trxlines.entity_code = header.entity_code
963: AND trxlines.event_class_code = header.event_class_code

Line 8787: | 'UPDATE' and no lines passed in zx_transaction_lines_gt/ |

8783: END IF;
8784:
8785: /*-----------------------------------------------------------------------*
8786: | Bug 3417023 - In case of call to calculate_tax with TAX_EVENT_TYPE as |
8787: | 'UPDATE' and no lines passed in zx_transaction_lines_gt/ |
8788: | trx_line_dist_tbl, we need to ignore all processsing |
8789: *-----------------------------------------------------------------------*/
8790: IF ZX_API_PUB.G_DATA_TRANSFER_MODE ='TAB' THEN
8791: /* IF p_event_class_rec.TAX_EVENT_TYPE_CODE = 'UPDATE' THEN

Line 8794: FROM ZX_TRANSACTION_LINES_GT

8790: IF ZX_API_PUB.G_DATA_TRANSFER_MODE ='TAB' THEN
8791: /* IF p_event_class_rec.TAX_EVENT_TYPE_CODE = 'UPDATE' THEN
8792: select count(*)
8793: INTO l_lines_passed
8794: FROM ZX_TRANSACTION_LINES_GT
8795: WHERE ROWNUM <=1 ;
8796: END IF;
8797: Event Type is not yet populated. So, commenting out*/
8798: null;

Line 10607: SELECT INDEX(HEADER ZX_TRX_HEADERS_GT_U1) INDEX(TRXLINES ZX_TRANSACTION_LINES_GT_U1)

10603:
10604: Cursor for import_document_with_tax API - need to retrieve only those lines
10605: that have passed validation in the validate and default API run
10606: Cursor get_imported_lines(p_event_class_rec zx_api_pub.event_class_rec_type) is
10607: SELECT INDEX(HEADER ZX_TRX_HEADERS_GT_U1) INDEX(TRXLINES ZX_TRANSACTION_LINES_GT_U1)
10608: header.INTERNAL_ORGANIZATION_ID ,
10609: header.APPLICATION_ID ,
10610: header.ENTITY_CODE ,
10611: header.EVENT_CLASS_CODE ,

Line 10947: FROM ZX_TRANSACTION_LINES_GT trxlines, ZX_TRX_HEADERS_GT header

10943: trxlines.GLOBAL_ATTRIBUTE_CATEGORY,
10944: trxlines.GLOBAL_ATTRIBUTE1,
10945: to_number(null) TOTAL_INC_TAX_AMT ,
10946: trxlines.USER_UPD_DET_FACTORS_FLAG
10947: FROM ZX_TRANSACTION_LINES_GT trxlines, ZX_TRX_HEADERS_GT header
10948: WHERE header.application_id = p_event_class_rec.application_id
10949: AND header.entity_code = p_event_class_rec.entity_code
10950: AND header.event_class_code = p_event_class_rec.event_class_code
10951: -- AND header.trx_id = p_event_class_rec.trx_id

Line 11552: FROM ZX_TRANSACTION_LINES_GT

11548:
11549:
11550: /* SELECT COUNT(*)
11551: INTO l_count_line_level_action
11552: FROM ZX_TRANSACTION_LINES_GT
11553: WHERE application_id = zx_global_structures_pkg.trx_line_dist_tbl.application_id(l_trx_line_index)
11554: AND entity_code = zx_global_structures_pkg.trx_line_dist_tbl.entity_code(l_trx_line_index)
11555: AND event_class_code = zx_global_structures_pkg.trx_line_dist_tbl.event_class_code(l_trx_line_index)
11556: AND trx_id = zx_global_structures_pkg.trx_line_dist_tbl.trx_id(l_trx_line_index)

Line 15863: SELECT /+ INDEX(HEADER ZX_TRX_HEADERS_GT_U1) INDEX(TRXLINES ZX_TRANSACTION_LINES_GT_U1) /

15859: l_call_default_APIs BOOLEAN;
15860: l_context_info_rec ZX_API_PUB.context_info_rec_type;
15861:
15862: CURSOR lines (p_event_class_rec ZX_API_PUB.event_class_rec_type)is
15863: SELECT /*+ INDEX(HEADER ZX_TRX_HEADERS_GT_U1) INDEX(TRXLINES ZX_TRANSACTION_LINES_GT_U1) */
15864: header.INTERNAL_ORGANIZATION_ID ,
15865: header.APPLICATION_ID ,
15866: header.ENTITY_CODE ,
15867: header.EVENT_CLASS_CODE ,

Line 16203: FROM ZX_TRANSACTION_LINES_GT trxlines,

16199: trxlines.GLOBAL_ATTRIBUTE_CATEGORY,
16200: trxlines.GLOBAL_ATTRIBUTE1,
16201: to_number(null) TOTAL_INC_TAX_AMT ,
16202: trxlines.USER_UPD_DET_FACTORS_FLAG
16203: FROM ZX_TRANSACTION_LINES_GT trxlines,
16204: ZX_TRX_HEADERS_GT header
16205: WHERE header.application_id = p_event_class_rec.application_id
16206: AND header.entity_code = p_event_class_rec.entity_code
16207: AND header.event_class_code = p_event_class_rec.event_class_code

Line 16667: --Update the zx_transaction_lines_gt and zx_trx_headers_gt with defaulted ATAs

16663: EXIT WHEN lines%NOTFOUND;
16664: END LOOP; --cursor
16665: CLOSE lines;
16666:
16667: --Update the zx_transaction_lines_gt and zx_trx_headers_gt with defaulted ATAs
16668:
16669: FORALL i IN 1..nvl(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id.LAST,-99)
16670: UPDATE ZX_TRANSACTION_LINES_GT SET
16671: trx_business_category = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_business_category(i),

Line 16670: UPDATE ZX_TRANSACTION_LINES_GT SET

16666:
16667: --Update the zx_transaction_lines_gt and zx_trx_headers_gt with defaulted ATAs
16668:
16669: FORALL i IN 1..nvl(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id.LAST,-99)
16670: UPDATE ZX_TRANSACTION_LINES_GT SET
16671: trx_business_category = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_business_category(i),
16672: line_intended_use = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_intended_use(i),
16673: user_defined_fisc_class = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.user_defined_fisc_class(i),
16674: product_fisc_classification = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.product_fisc_classification(i),