APPS.ZX_NEW_SERVICES_PKG dependencies on ZX_LINES_DET_FACTORS

Line 411: into zx_lines_det_factors depending on the line_level_action for tax event type UPDATE*/

407: 'CANCEL','U',
408: 'SYNCHRONIZE','U',
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

Line 510: UPDATE ZX_LINES_DET_FACTORS SET

506: END IF;
507:
508: x_return_status := FND_API.G_RET_STS_SUCCESS;
509: FORALL i IN NVL(p_trx_line_dist_tbl.application_id.FIRST,0) .. NVL(p_trx_line_dist_tbl.application_id.LAST,-99)
510: UPDATE ZX_LINES_DET_FACTORS SET
511: EVENT_ID = p_event_class_rec.event_id,
512: INTERNAL_ORGANIZATION_ID = p_trx_line_dist_tbl.INTERNAL_ORGANIZATION_ID(i),
513: EVENT_TYPE_CODE = p_trx_line_dist_tbl.EVENT_TYPE_CODE(i),
514: DOC_EVENT_STATUS = p_event_class_rec.DOC_STATUS_CODE,

Line 935: SELECT ZX_LINES_DET_FACTORS_S.NEXTVAL

931:
932: /*-----------------------------------------+
933: | Get the event id for the whole document |
934: +-----------------------------------------*/
935: SELECT ZX_LINES_DET_FACTORS_S.NEXTVAL
936: INTO l_event_class_rec.event_id
937: FROM dual;
938:
939: /*------------------------------------------------+

Line 940: | Update zx_lines_det_factors |

936: INTO l_event_class_rec.event_id
937: FROM dual;
938:
939: /*------------------------------------------------+
940: | Update zx_lines_det_factors |
941: +------------------------------------------------*/
942: FORALL i IN NVL(p_trx_line_dist_id_tbl.FIRST,0) ..NVL(p_trx_line_dist_id_tbl.LAST, -1)
943: UPDATE /*+ cardinality(ZX_LINES_DET_FACTORS,100) */ ZX_LINES_DET_FACTORS
944: SET EVENT_TYPE_CODE = p_transaction_rec.event_type_code,

Line 943: UPDATE /*+ cardinality(ZX_LINES_DET_FACTORS,100) */ ZX_LINES_DET_FACTORS

939: /*------------------------------------------------+
940: | Update zx_lines_det_factors |
941: +------------------------------------------------*/
942: FORALL i IN NVL(p_trx_line_dist_id_tbl.FIRST,0) ..NVL(p_trx_line_dist_id_tbl.LAST, -1)
943: UPDATE /*+ cardinality(ZX_LINES_DET_FACTORS,100) */ ZX_LINES_DET_FACTORS
944: SET EVENT_TYPE_CODE = p_transaction_rec.event_type_code,
945: TAX_EVENT_TYPE_CODE = p_transaction_rec.tax_event_type_code,
946: EVENT_ID = l_event_class_rec.event_id,
947: DOC_EVENT_STATUS = l_event_class_rec.doc_status_code

Line 963: UPDATE /*+ cardinality(ZX_LINES_DET_FACTORS,100) */ ZX_LINES_DET_FACTORS

959: AND trx_line_dist_id = p_trx_line_dist_id_tbl(i)
960: );
961:
962: -- Update Pseudo Item Lines for Tax only lines.
963: UPDATE /*+ cardinality(ZX_LINES_DET_FACTORS,100) */ ZX_LINES_DET_FACTORS
964: SET EVENT_TYPE_CODE = p_transaction_rec.event_type_code,
965: TAX_EVENT_TYPE_CODE = p_transaction_rec.tax_event_type_code,
966: EVENT_ID = l_event_class_rec.event_id,
967: DOC_EVENT_STATUS = l_event_class_rec.doc_status_code

Line 1219: select ZX_LINES_DET_FACTORS_S.nextval

1215: and event_class_code = p_transaction_rec.event_class_code
1216: and trx_id = p_transaction_rec.trx_id;
1217: END IF;
1218:
1219: select ZX_LINES_DET_FACTORS_S.nextval
1220: into l_event_id
1221: from dual;
1222:
1223: l_event_class_rec.EVENT_ID := l_event_id;

Line 2268: -- Check if data exists in zx_lines_det_factors after

2264: END IF;
2265: END IF;
2266: END IF;
2267:
2268: -- Check if data exists in zx_lines_det_factors after
2269: -- on the fly upgrade, if not return control to payables
2270: -- as no tax impacts here
2271: ZX_ON_FLY_TRX_UPGRADE_PKG.is_trx_migrated(
2272: p_upg_trx_info_rec => l_upg_trx_info_rec,