DBA Data[Home] [Help]

APPS.ZX_NEW_SERVICES_PKG dependencies on ZX_REC_NREC_DIST

Line 164: FROM zx_rec_nrec_dist dist

160: AND EVENT_CLASS_CODE = p_transaction_rec.EVENT_CLASS_CODE
161: AND TRX_ID = p_transaction_rec.TRX_ID
162: AND (TRX_ID, TRX_LINE_ID, TRX_LEVEL_TYPE) IN
163: (SELECT dist.trx_id, dist.trx_line_id, dist.trx_level_type
164: FROM zx_rec_nrec_dist dist
165: WHERE application_id = p_transaction_rec.application_id
166: AND entity_code = p_transaction_rec.entity_code
167: AND event_class_code = p_transaction_rec.event_class_code
168: AND trx_id = p_transaction_rec.trx_id

Line 182: UPDATE ZX_REC_NREC_DIST

178: -- Initialize API return status to success
179: x_return_status := FND_API.G_RET_STS_SUCCESS;
180:
181: FORALL i IN NVL(p_trx_line_dist_id_tbl.FIRST,0) ..NVL(p_trx_line_dist_id_tbl.LAST, -1)
182: UPDATE ZX_REC_NREC_DIST
183: SET freeze_flag = 'Y',
184: event_type_code = l_event_class_rec.event_type_code,
185: tax_event_type_code = l_event_class_rec.tax_event_type_code
186: WHERE application_id = p_transaction_rec.application_id

Line 199: FROM ZX_REC_NREC_DIST ZD

195: event_type_code = l_event_class_rec.event_type_code,
196: tax_event_type_code = l_event_class_rec.tax_event_type_code,
197: doc_event_status = l_event_class_rec.doc_status_code
198: WHERE TAX_LINE_ID IN (SELECT ZD.TAX_LINE_ID
199: FROM ZX_REC_NREC_DIST ZD
200: WHERE application_id = p_transaction_rec.application_id
201: AND entity_code = p_transaction_rec.entity_code
202: AND event_class_code = p_transaction_rec.event_class_code
203: AND trx_id = p_transaction_rec.trx_id