APPS.ZX_NEW_SERVICES_PKG dependencies on ZX_LINES_DET_FACTORS

Line 145: SELECT ZX_LINES_DET_FACTORS_S.NEXTVAL

141:
142: /*-----------------------------------------+
143: | Get the event id for the whole document |
144: +-----------------------------------------*/
145: SELECT ZX_LINES_DET_FACTORS_S.NEXTVAL
146: INTO l_event_class_rec.event_id
147: FROM dual;
148:
149: /*------------------------------------------------+

Line 150: | Update zx_lines_det_factors |

146: INTO l_event_class_rec.event_id
147: FROM dual;
148:
149: /*------------------------------------------------+
150: | Update zx_lines_det_factors |
151: +------------------------------------------------*/
152: FORALL i IN NVL(p_trx_line_dist_id_tbl.FIRST,0) ..NVL(p_trx_line_dist_id_tbl.LAST, -1)
153: UPDATE ZX_LINES_DET_FACTORS
154: SET EVENT_TYPE_CODE = p_transaction_rec.event_type_code,

Line 153: UPDATE ZX_LINES_DET_FACTORS

149: /*------------------------------------------------+
150: | Update zx_lines_det_factors |
151: +------------------------------------------------*/
152: FORALL i IN NVL(p_trx_line_dist_id_tbl.FIRST,0) ..NVL(p_trx_line_dist_id_tbl.LAST, -1)
153: UPDATE ZX_LINES_DET_FACTORS
154: SET EVENT_TYPE_CODE = p_transaction_rec.event_type_code,
155: TAX_EVENT_TYPE_CODE = p_transaction_rec.tax_event_type_code,
156: EVENT_ID = l_event_class_rec.event_id,
157: DOC_EVENT_STATUS = l_event_class_rec.doc_status_code