APPS.CZ_RULE_TEXT_GEN SQL Statements

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

Line: 145

      FOR c_name IN (SELECT name, parent_id FROM cz_ps_nodes
                      START WITH ps_node_id = p_ps_node_id
                    CONNECT BY PRIOR parent_id = ps_node_id) LOOP

        IF(v_Name IS NULL)THEN

          v_Name := '''' || c_name.name || '''';

Line: 154

          FOR c_node IN (SELECT NULL FROM cz_ps_nodes WHERE deleted_flag = '0'
                            AND devl_project_id = p_devl_project_id
                            AND name = c_name.name
                            AND ps_node_id <> p_ps_node_id)LOOP
            h_FullName(p_ps_node_id) := 1;

Line: 161

          FOR c_node IN (SELECT NULL FROM cz_ps_nodes WHERE deleted_flag = '0'
                            AND devl_project_id IN
                              (SELECT component_id FROM cz_model_ref_expls
                                WHERE deleted_flag = '0'
                                  AND model_id = p_devl_project_id
                                  AND ps_node_type IN (PS_NODE_TYPE_REFERENCE, PS_NODE_TYPE_CONNECTOR))
                            AND name = c_name.name)LOOP
            h_FullName(p_ps_node_id) := 1;

Line: 208

              SELECT name INTO v_ModelName FROM cz_ps_nodes
               WHERE ps_node_id = h_ComponentId(v_Node);

Line: 470

          SELECT name INTO v_Name FROM cz_properties
           WHERE property_id = v_ExprPropertyId(j);

Line: 663

   SELECT presentation_flag
      INTO v_pres_flag
   FROM cz_rules ru
   WHERE rule_id = p_rule_id
   AND(rule_text IS NULL
     OR EXISTS
      (SELECT 1
       FROM cz_expression_nodes
       WHERE rule_id = ru.rule_id
       AND template_id IN(712,    714 , 552 , 2))
     );

Line: 680

   SELECT expr_node_id, expr_parent_id, expr_type, template_id,
          ps_node_id, model_ref_expl_id, property_id, data_type, data_value, data_num_value,
          param_index, argument_name
     BULK COLLECT INTO v_ExprId, v_ExprParentId, v_ExprType, v_ExprTemplateId,
                       v_ExprPsNodeId, v_ExplNodeId, v_ExprPropertyId, v_ExprDataType, v_ExprDataValue, v_ExprDataNumValue,
                       v_ExprParamIndex, v_ExprArgumentName
     FROM cz_expression_nodes
    WHERE rule_id = p_rule_id
      AND expr_type <> 208
      AND deleted_flag = '0'
    ORDER BY expr_parent_id, seq_nbr;

Line: 744

     UPDATE cz_expression_nodes SET
       display_node_depth = vi_Depth(i),
       source_offset = vi_Pos(i),
       source_length = LENGTH(vi_Name(i))
     WHERE expr_node_id = vi_ExprId(i);

Line: 753

     UPDATE cz_expression_nodes SET
       data_type = v_ExprDataType(i),
       data_num_value = v_ExprDataNumValue(i)
     WHERE expr_node_id = v_ExprId(i);

Line: 758

   UPDATE cz_rules SET rule_text = v_RuleText WHERE rule_id = p_rule_id;

Line: 781

  SELECT TO_NUMBER(value) INTO schema_version
    FROM cz_db_settings
   WHERE setting_id = 'MAJOR_VERSION'
     AND section_name = 'SCHEMA';

Line: 797

   SELECT rule_id, name, template_token BULK COLLECT INTO v_RuleId, v_RuleName, v_TemplateToken
     FROM cz_rules
    WHERE deleted_flag = '0'
      AND disabled_flag = '0'
      AND rule_id < 1000;

Line: 811

   SELECT model_ref_expl_id, parent_expl_node_id, component_id, referring_node_id, ps_node_type
     BULK COLLECT INTO v_NodeId, v_ParentId, v_ComponentId, v_ReferringId, v_NodeType
     FROM cz_model_ref_expls
    WHERE model_id = p_devl_project_id
      AND deleted_flag = '0';

Line: 830

     FOR c_rule IN (SELECT rule_id FROM cz_rules
                     WHERE deleted_flag = '0'
                       AND devl_project_id = p_devl_project_id
                       AND rule_type IN (100, 200)) LOOP
       populate_rule_text(c_rule.rule_id);