APPS.ZX_NEW_SERVICES_PKG dependencies on ZX_LINES

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

Line 193: UPDATE ZX_LINES ZL

189: AND trx_id = p_transaction_rec.trx_id
190: AND trx_line_dist_id = p_trx_line_dist_id_tbl(i);
191:
192: FORALL i IN NVL(p_trx_line_dist_id_tbl.FIRST,0) ..NVL(p_trx_line_dist_id_tbl.LAST, -1)
193: UPDATE ZX_LINES ZL
194: SET associated_child_frozen_flag ='Y',
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