APPS.ZX_NEW_SERVICES_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 50

SELECT evntcls.application_id,
       evntcls.entity_code,
       evntcls.event_class_code,
       evnttyp.event_type_code,
       null,                              --dist.tax_event_class_code,
       'UPDATE' tax_event_type_code,
       'UPDATED' doc_status_code,
       evntcls.summarization_flag,
       evntcls.retain_summ_tax_line_id_flag
  FROM zx_evnt_cls_mappings evntcls,
       zx_evnt_typ_mappings evnttyp
 WHERE p_transaction_rec.application_id = evntcls.application_id
   AND p_transaction_rec.entity_code = evntcls.entity_code
   AND p_transaction_rec.event_class_code = evntcls.event_class_code
   AND evnttyp.application_id = evntcls.application_id
   AND evnttyp.entity_code = evntcls.entity_code
   AND evnttyp.event_class_code = evntcls.event_class_code
   AND evnttyp.tax_event_type_code = 'UPDATE';

Line: 145

    SELECT ZX_LINES_DET_FACTORS_S.NEXTVAL
    INTO l_event_class_rec.event_id
    FROM dual;

Line: 150

   |  Update zx_lines_det_factors                   |
   +------------------------------------------------*/
   FORALL i IN NVL(p_trx_line_dist_id_tbl.FIRST,0) ..NVL(p_trx_line_dist_id_tbl.LAST, -1)
     UPDATE ZX_LINES_DET_FACTORS
       SET EVENT_TYPE_CODE     = p_transaction_rec.event_type_code,
           TAX_EVENT_TYPE_CODE = p_transaction_rec.tax_event_type_code,
           EVENT_ID            = l_event_class_rec.event_id,
           DOC_EVENT_STATUS    = l_event_class_rec.doc_status_code
     WHERE APPLICATION_ID      = p_transaction_rec.APPLICATION_ID
       AND ENTITY_CODE         = p_transaction_rec.ENTITY_CODE
       AND EVENT_CLASS_CODE    = p_transaction_rec.EVENT_CLASS_CODE
       AND TRX_ID              = p_transaction_rec.TRX_ID
       AND (TRX_ID, TRX_LINE_ID, TRX_LEVEL_TYPE) IN
            (SELECT dist.trx_id, dist.trx_line_id, dist.trx_level_type
               FROM zx_rec_nrec_dist dist
              WHERE application_id = p_transaction_rec.application_id
                AND entity_code = p_transaction_rec.entity_code
                AND event_class_code = p_transaction_rec.event_class_code
                AND trx_id = p_transaction_rec.trx_id
                AND trx_line_dist_id  = p_trx_line_dist_id_tbl(i)
            );

Line: 182

      UPDATE ZX_REC_NREC_DIST
         SET freeze_flag = 'Y',
             event_type_code = l_event_class_rec.event_type_code,
             tax_event_type_code = l_event_class_rec.tax_event_type_code
       WHERE application_id = p_transaction_rec.application_id
         AND entity_code = p_transaction_rec.entity_code
         AND event_class_code = p_transaction_rec.event_class_code
         AND trx_id = p_transaction_rec.trx_id
         AND trx_line_dist_id  = p_trx_line_dist_id_tbl(i);

Line: 193

     UPDATE ZX_LINES ZL
        SET associated_child_frozen_flag ='Y',
            event_type_code = l_event_class_rec.event_type_code,
            tax_event_type_code = l_event_class_rec.tax_event_type_code,
            doc_event_status = l_event_class_rec.doc_status_code
      WHERE TAX_LINE_ID IN (SELECT ZD.TAX_LINE_ID
                              FROM ZX_REC_NREC_DIST ZD
                             WHERE application_id = p_transaction_rec.application_id
                               AND entity_code = p_transaction_rec.entity_code
                               AND event_class_code = p_transaction_rec.event_class_code
                               AND trx_id = p_transaction_rec.trx_id
                               AND trx_line_dist_id  = p_trx_line_dist_id_tbl(i)
                            );