[Home] [Help]
2044:
2045: x_return_status := FND_API.G_RET_STS_SUCCESS;
2046:
2047: BEGIN
2048: SELECT /*+ INDEX(ZX_REV_TRX_HEADERS_GT ZX_REV_TRX_HEADERS_GT_U1) INDEX(ZX_REVERSE_TRX_LINES_GT ZX_REVERSE_TRX_LINES_GT_U1) */
2049: hdrgt.legal_entity_id ,
2050: hdrgt.internal_organization_id,
2051: zl.related_doc_date,
2052: zl.adjusted_doc_date,
2065: l_application_id,
2066: l_entity_code,
2067: l_event_class_code,
2068: l_trx_id
2069: FROM ZX_REV_TRX_HEADERS_GT hdrgt,
2070: ZX_REVERSE_TRX_LINES_GT lngt,
2071: ZX_LINES_DET_FACTORS zl
2072: WHERE hdrgt.reversing_appln_id = p_event_class_rec.application_id
2073: AND hdrgt.reversing_entity_code = p_event_class_rec.entity_code
2109: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2111: END IF;
2112: END IF;
2113: SELECT /*+ INDEX(ZX_REV_TRX_HEADERS_GT ZX_REV_TRX_HEADERS_GT_U1) INDEX(ZX_REVERSE_TRX_LINES_GT ZX_REVERSE_TRX_LINES_GT_U1) */
2114: hdrgt.legal_entity_id ,
2115: hdrgt .internal_organization_id,
2116: zl.related_doc_date,
2117: zl.adjusted_doc_date,
2130: l_application_id,
2131: l_entity_code,
2132: l_event_class_code,
2133: l_trx_id
2134: FROM ZX_REV_TRX_HEADERS_GT hdrgt,
2135: ZX_REVERSE_TRX_LINES_GT lngt,
2136: ZX_LINES_DET_FACTORS zl
2137: WHERE hdrgt.reversing_appln_id = p_event_class_rec.application_id
2138: AND hdrgt.reversing_entity_code = p_event_class_rec.entity_code
3105: INTO p_event_class_rec.application_id,
3106: p_event_class_rec.entity_code,
3107: p_event_class_rec.event_class_code,
3108: p_event_class_rec.trx_id
3109: FROM ZX_REV_TRX_HEADERS_GT
3110: WHERE rownum = 1;
3111:
3112: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3113: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,' Get tax event class');