APPS.CZ_CX_UTIL_PVT SQL Statements

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

Line: 21

        SELECT NVL(cz_utils.conv_num(value), DEFAULT_INCREMENT) INTO m_increment
        FROM CZ_DB_SETTINGS
        WHERE section_name = 'SCHEMA' AND setting_id = 'OracleSequenceIncr';

Line: 30

    SELECT cz_rules_s.NEXTVAL INTO m_rule_id FROM DUAL;

Line: 81

    SELECT 1 INTO l_dummy FROM cz_rp_entries
    WHERE object_id = p_model_id AND object_type = 'PRJ' AND deleted_flag = '0';

Line: 89

  UPDATE cz_func_comp_specs
  SET rule_folder_type = NULL
  WHERE rule_folder_type IS NOT NULL AND deleted_flag = '0';

Line: 97

    SELECT DISTINCT component_id
    BULK COLLECT INTO model_tbl
    FROM cz_model_ref_expls
    WHERE model_id = p_model_id AND ps_node_type = 263
    AND deleted_flag = '0';

Line: 108

    SELECT rule_folder_id, tree_seq
    BULK COLLECT INTO fc_tbl, seq_tbl
    FROM cz_rule_folders
    WHERE devl_project_id = model_tbl(i)
    AND object_type = 'FNC' AND deleted_flag = '0';

Line: 118

        UPDATE cz_func_comp_specs
        SET rule_folder_type = l_rule_id
        WHERE func_comp_id = fc_tbl(j);

Line: 123

        UPDATE cz_rule_folders
        SET rule_folder_id = l_rule_id, object_type = 'CXT'
        WHERE rule_folder_id = fc_tbl(j) AND object_type = 'FNC';

Line: 128

        INSERT INTO cz_rules(rule_id
                            ,persistent_rule_id
                            ,rule_type
                            ,seq_nbr
                            ,invalid_flag
                            ,disabled_flag
                            ,mutable_flag
                            ,effective_usage_mask
                            ,effective_from
                            ,effective_until
                            ,instantiation_scope
                            ,class_name
                            ,devl_project_id
                            ,component_id
                            ,model_ref_expl_id
                            ,rule_folder_id
                            ,name
                            ,desc_text
                            )
        SELECT l_rule_id
              ,l_rule_id
              ,300
              ,seq_tbl(j)
              ,'0'
              ,'0'
              ,'0'
              ,'0000000000000000'
              ,cz_utils.EPOCH_BEGIN
              ,cz_utils.EPOCH_END
              ,1
              ,program_string
              ,devl_project_id
              ,component_id
              ,model_ref_expl_id
              ,rule_folder_id
              ,name
              ,desc_text
        FROM cz_func_comp_specs
        WHERE func_comp_id = fc_tbl(j);

Line: 177

  FOR fc_rec IN (SELECT func_comp_id, rule_folder_type
                 FROM cz_func_comp_specs
                 WHERE deleted_flag = '0'
                 AND rule_folder_type IS NOT NULL) LOOP
    fc2rule_map(fc_rec.func_comp_id) := fc_rec.rule_folder_type;

Line: 187

    FOR ui_rec IN (SELECT def.ui_def_id, node.ui_node_id,
                          node.func_comp_id, prop.value_str
                   FROM cz_ui_defs def, cz_ui_nodes node, cz_ui_node_props prop
                   WHERE def.devl_project_id = model_tbl(i)
                   AND def.deleted_flag = '0'
                   AND def.ui_def_id = node.ui_def_id
                   AND node.deleted_flag = '0'
                   AND node.func_comp_id IS NOT NULL
                   AND node.ui_def_id = prop.ui_def_id
                   AND node.ui_node_id = prop.ui_node_id
                   AND prop.key_str = 'ActionType'
                   AND prop.value_str IN (FC_OUTPUT, FC_AUTOCONFIG)
                   AND prop.deleted_flag = '0'
                   AND node.parent_id <> (SELECT ui_node_id FROM CZ_UI_NODES
                                           WHERE ui_def_id=def.ui_def_id AND
                                                 name='Limbo' AND
                                                 deleted_flag='0')
    ) LOOP
      l_stat := 5.1;

Line: 222

      UPDATE cz_ui_nodes
      SET cx_command_name = l_command_name, func_comp_id = NULL
      WHERE ui_node_id = ui_rec.ui_node_id;

Line: 227

      UPDATE cz_ui_node_props
      SET value_str = l_value_str
      WHERE ui_def_id = ui_rec.ui_def_id
      AND ui_node_id = ui_rec.ui_node_id
      AND key_str = 'ActionType';

Line: 240

      UPDATE CZ_UI_NODES
         SET deleted_flag='1'
       WHERE ui_def_id=deluinodes_uidefids_tbl(k) AND ui_node_id=deluinodes_ids_tbl(k);

Line: 245

      UPDATE CZ_UI_NODE_PROPS
         SET deleted_flag='1'
       WHERE ui_def_id=deluinodes_uidefids_tbl(k) AND ui_node_id=deluinodes_ids_tbl(k);