APPS.CZ_DIAGNOSTICS_PVT SQL Statements

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

Line: 91

    INSERT INTO cz_db_logs (run_id, logtime, message, caller, message_id)
    VALUES (x_run_id, SYSDATE, inMessage, 'CZ_DIAGNOSTICS_PVT.VERIFY_STRUCTURE', g_message_id);

Line: 170

     SELECT model_ref_expl_id, component_id, ps_node_type, virtual_flag, referring_node_id,
            child_model_expl_id, expl_node_type, node_depth
       BULK COLLECT INTO v_tExplNodeId, v_tComponentId, v_tNodeType, v_tVirtualFlag, v_tReferringId,
            v_tChildModelExpl, v_tExplNodeType, v_tNodeDepth
       FROM cz_model_ref_expls
      WHERE deleted_flag = '0'
        AND model_id = inProjectId
        AND parent_expl_node_id = inExplId;

Line: 199

  ntPsNodeId.DELETE;

Line: 200

  ntParentId.DELETE;

Line: 201

  ntName.DELETE;

Line: 202

  ntPsNodeType.DELETE;

Line: 203

  ntVirtualFlag.DELETE;

Line: 204

  ntReferenceId.DELETE;

Line: 206

  SELECT ps_node_id, parent_id, name, ps_node_type, virtual_flag, reference_id
    BULK COLLECT INTO ntPsNodeId, ntParentId, ntName, ntPsNodeType, ntVirtualFlag, ntReferenceId
    FROM cz_ps_nodes
   WHERE deleted_flag = '0'
   START WITH ps_node_id = inComponentId
   CONNECT BY
    (PRIOR virtual_flag IS NULL OR PRIOR virtual_flag = '1' OR
     PRIOR ps_node_id = inComponentId)
       AND PRIOR ps_node_id = parent_id;

Line: 347

      IF(j IS NOT NULL)THEN v_tExplNodeId.DELETE(j); END IF;

Line: 393

        v_tExplNodeId.DELETE(j);

Line: 421

        UPDATE cz_model_ref_expls SET deleted_flag = p_mark_fixed_char WHERE model_ref_expl_id = v_tExplNodeId(j);

Line: 466

    SELECT cz_xfr_run_infos_s.NEXTVAL INTO x_run_id FROM DUAL;

Line: 476

    SELECT model_ref_expl_id INTO rootExplId
      FROM cz_model_ref_expls
     WHERE deleted_flag = '0'
       AND model_id = p_devl_project_id
       AND parent_expl_node_id IS NULL;