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 240: SELECT /+ INDEX(HEADER ZX_TRX_HEADERS_GT_U1) INDEX(TRXLINES ZX_TRANSACTION_LINES_GT_U1 /

236:
237:
238: /* Cursor for GTT version of calculate tax*/
239: Cursor lines(p_event_class_rec ZX_API_PUB.event_class_rec_type) is
240: SELECT /*+ INDEX(HEADER ZX_TRX_HEADERS_GT_U1) INDEX(TRXLINES ZX_TRANSACTION_LINES_GT_U1 */
241: header.INTERNAL_ORGANIZATION_ID ,
242: header.APPLICATION_ID ,
243: header.ENTITY_CODE ,
244: header.EVENT_CLASS_CODE ,

Line 599: FROM ZX_TRANSACTION_LINES_GT trxlines,

595: 'DELETE','U') ,
596: null)INSERT_UPDATE_FLAG
597: /* The update insert flag is to determine the records that need to be inserted/updated
598: into zx_lines_det_factors depending on the line_level_action for tax event type UPDATE*/
599: FROM ZX_TRANSACTION_LINES_GT trxlines,
600: ZX_TRX_HEADERS_GT header
601: WHERE header.application_id = p_event_class_rec.application_id
602: AND header.entity_code = p_event_class_rec.entity_code
603: AND header.event_class_code = p_event_class_rec.event_class_code

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

612:
613: -- bug fix 5417887 begin
614: /* Cursor for GTT version of calculate tax as well as import_document_with_tax AI */
615: Cursor c_lines(p_event_class_rec ZX_API_PUB.event_class_rec_type) is
616: SELECT /*+ INDEX(HEADER ZX_TRX_HEADERS_GT_U1) INDEX(TRXLINES ZX_TRANSACTION_LINES_GT_U1) */
617: header.INTERNAL_ORGANIZATION_ID ,
618: header.APPLICATION_ID ,
619: header.ENTITY_CODE ,
620: header.EVENT_CLASS_CODE ,

Line 978: FROM ZX_TRANSACTION_LINES_GT trxlines,

974: null TAX_PROCESSING_COMPLETED_FLAG, -- Bug 8931030
975: null TAX_CALCULATION_DONE_FLAG -- Bug 8931030
976: /* The update insert flag is to determine the records that need to be inserted/updated
977: into zx_lines_det_factors depending on the line_level_action for tax event type UPDATE*/
978: FROM ZX_TRANSACTION_LINES_GT trxlines,
979: ZX_TRX_HEADERS_GT header
980: WHERE trxlines.application_id = header.application_id
981: AND trxlines.entity_code = header.entity_code
982: AND trxlines.event_class_code = header.event_class_code

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

9693: END IF;
9694:
9695: /*-----------------------------------------------------------------------*
9696: | Bug 3417023 - In case of call to calculate_tax with TAX_EVENT_TYPE as |
9697: | 'UPDATE' and no lines passed in zx_transaction_lines_gt/ |
9698: | trx_line_dist_tbl, we need to ignore all processsing |
9699: *-----------------------------------------------------------------------*/
9700: IF ZX_API_PUB.G_DATA_TRANSFER_MODE ='TAB' THEN
9701: /* IF p_event_class_rec.TAX_EVENT_TYPE_CODE = 'UPDATE' THEN

Line 9704: FROM ZX_TRANSACTION_LINES_GT

9700: IF ZX_API_PUB.G_DATA_TRANSFER_MODE ='TAB' THEN
9701: /* IF p_event_class_rec.TAX_EVENT_TYPE_CODE = 'UPDATE' THEN
9702: select count(*)
9703: INTO l_lines_passed
9704: FROM ZX_TRANSACTION_LINES_GT
9705: WHERE ROWNUM <=1 ;
9706: END IF;
9707: Event Type is not yet populated. So, commenting out*/
9708: null;

Line 12468: -- FROM ZX_TRANSACTION_LINES_GT

12464:
12465:
12466: -- SELECT COUNT(*)
12467: -- INTO l_count_line_level_action
12468: -- FROM ZX_TRANSACTION_LINES_GT
12469: -- WHERE application_id = zx_global_structures_pkg.trx_line_dist_tbl.application_id(l_trx_line_index)
12470: -- AND entity_code = zx_global_structures_pkg.trx_line_dist_tbl.entity_code(l_trx_line_index)
12471: -- AND event_class_code = zx_global_structures_pkg.trx_line_dist_tbl.event_class_code(l_trx_line_index)
12472: -- AND trx_id = zx_global_structures_pkg.trx_line_dist_tbl.trx_id(l_trx_line_index)

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

16970: l_call_default_APIs BOOLEAN;
16971: l_context_info_rec ZX_API_PUB.context_info_rec_type;
16972:
16973: CURSOR lines (p_event_class_rec ZX_API_PUB.event_class_rec_type)is
16974: SELECT /*+ INDEX(HEADER ZX_TRX_HEADERS_GT_U1) INDEX(TRXLINES ZX_TRANSACTION_LINES_GT_U1) */
16975: header.INTERNAL_ORGANIZATION_ID ,
16976: header.APPLICATION_ID ,
16977: header.ENTITY_CODE ,
16978: header.EVENT_CLASS_CODE ,

Line 17314: FROM ZX_TRANSACTION_LINES_GT trxlines,

17310: trxlines.GLOBAL_ATTRIBUTE_CATEGORY,
17311: trxlines.GLOBAL_ATTRIBUTE1,
17312: to_number(null) TOTAL_INC_TAX_AMT ,
17313: trxlines.USER_UPD_DET_FACTORS_FLAG
17314: FROM ZX_TRANSACTION_LINES_GT trxlines,
17315: ZX_TRX_HEADERS_GT header
17316: WHERE header.application_id = p_event_class_rec.application_id
17317: AND header.entity_code = p_event_class_rec.entity_code
17318: AND header.event_class_code = p_event_class_rec.event_class_code

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

17774: EXIT WHEN lines%NOTFOUND;
17775: END LOOP; --cursor
17776: CLOSE lines;
17777:
17778: --Update the zx_transaction_lines_gt and zx_trx_headers_gt with defaulted ATAs
17779:
17780: FORALL i IN 1..nvl(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id.LAST,-99)
17781: UPDATE ZX_TRANSACTION_LINES_GT SET
17782: trx_business_category = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_business_category(i),

Line 17781: UPDATE ZX_TRANSACTION_LINES_GT SET

17777:
17778: --Update the zx_transaction_lines_gt and zx_trx_headers_gt with defaulted ATAs
17779:
17780: FORALL i IN 1..nvl(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id.LAST,-99)
17781: UPDATE ZX_TRANSACTION_LINES_GT SET
17782: trx_business_category = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_business_category(i),
17783: line_intended_use = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_intended_use(i),
17784: user_defined_fisc_class = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.user_defined_fisc_class(i),
17785: product_fisc_classification = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.product_fisc_classification(i),