[Home] [Help]
50: /* Cursor for updating Det Factors information during Cancel/Discard */
51: Cursor c_lines(p_event_class_rec ZX_API_PUB.event_class_rec_type,
52: p_trx_line_id NUMBER,
53: p_trx_level_type VARCHAR2) is
54: SELECT /*+ INDEX(HEADER ZX_TRX_HEADERS_GT_U1) INDEX(TRXLINES ZX_TRANSACTION_LINES_GT_U1) */
55: header.INTERNAL_ORGANIZATION_ID ,
56: header.APPLICATION_ID ,
57: header.ENTITY_CODE ,
58: header.EVENT_CLASS_CODE ,
409: 'DELETE','U') INSERT_UPDATE_FLAG
410: /* The update insert flag is to determine the records that need to be inserted/updated
411: into zx_lines_det_factors depending on the line_level_action for tax event type UPDATE*/
412: FROM ZX_TRANSACTION_LINES_GT trxlines,
413: ZX_TRX_HEADERS_GT header
414: WHERE trxlines.application_id = header.application_id
415: AND trxlines.entity_code = header.entity_code
416: AND trxlines.event_class_code = header.event_class_code
417: AND trxlines.trx_id = header.trx_id
1119: evntmap.processing_precedence,
1120: header.icx_session_id,
1121: header.quote_flag
1122: FROM ZX_EVNT_CLS_MAPPINGS evntmap,
1123: ZX_TRX_HEADERS_GT header
1124: WHERE header.application_id = evntmap.application_id
1125: AND header.entity_code = evntmap.entity_code
1126: AND header.event_class_code = evntmap.event_class_code
1127: AND header.application_id = p_transaction_rec.application_id
1208: l_evnt_cls.entity_code(1),
1209: l_evnt_cls.internal_organization_id(1),
1210: l_evnt_cls.icx_session_id(1),
1211: l_evnt_cls.quote_flag(1)
1212: from ZX_TRX_HEADERS_GT
1213: where application_id = p_transaction_rec.application_id
1214: and entity_code = p_transaction_rec.entity_code
1215: and event_class_code = p_transaction_rec.event_class_code
1216: and trx_id = p_transaction_rec.trx_id;