APPS.QA_CHAR_UPDATE_PKG SQL Statements

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

Line: 31

    FUNCTION Update_User_Name
    (
      p_subscription_guid IN RAW,
      p_event             IN OUT NOCOPY WF_EVENT_T
    ) RETURN VARCHAR2
    IS
      l_api_name      CONSTANT VARCHAR2(30)   := 'Update_User_Name';

Line: 81

          'Before Invoking Update_Element_Value with p_old_value => ' || l_old_user_name || ' and p_new_value => ' || l_new_user_name
        );

Line: 87

      Update_Element_Value
      (
        p_api_version         => 1.0,
        p_init_msg_list       => FND_API.G_TRUE,
        p_commit              => FND_API.G_TRUE,
        p_validation_level    => FND_API.G_VALID_LEVEL_FULL,
        p_char_id             => QA_SS_CONST.send_notification_to,
        p_old_value           => l_old_user_name,
        p_new_value           => l_new_user_name,
        x_return_status       => l_return_status,
        x_msg_count           => l_msg_count,
        x_msg_data            => l_msg_data
      );

Line: 106

          'After Invoking Update_Element_Value. Return Status is: ' || l_return_status
        );

Line: 132

            'User Name Update Failed with Error: ' || l_error_string
          );

Line: 139

            'User Name Update Failed with Error: ' || l_error_string
          );

Line: 189

            'User Name Update Failed with Error: ' || SQLERRM
          );

Line: 196

            'User Name Update Failed with Error: ' || SQLERRM
          );

Line: 224

    END Update_User_Name;

Line: 229

    PROCEDURE update_results
    (
      p_char_id          IN         NUMBER,
      p_old_value        IN         VARCHAR2,
      p_new_value        IN         VARCHAR2,
      p_commit           IN         BOOLEAN
    )
    IS

      l_api_name      CONSTANT VARCHAR2(30)   := 'update_results';

Line: 263

      SELECT qpc.plan_id,
             qpc.result_column_name
      BULK COLLECT INTO
             l_plan_ids,
             l_result_columns
      FROM   qa_chars qc,
             qa_plan_chars qpc,
             qa_plans qp
      WHERE  qc.hardcoded_column IS NULL
      AND    qc.char_id = qpc.char_id
      AND    qpc.char_id = p_char_id
      AND    qpc.plan_id = qp.plan_id
      AND    qp.organization_id <> 0
      AND NOT EXISTS
             (
               SELECT 1
               FROM   qa_pc_plan_relationship
               WHERE  data_entry_mode = 4
               AND    child_plan_id = qp.plan_id
             );

Line: 328

        l_dml_string := 'UPDATE qa_results qr SET ' || l_result_columns(i) || ' = :1 WHERE plan_id = :2 AND ' || NVL( l_index_predicate, l_result_columns(i) ) || ' = :3 ';

Line: 353

            'Updated ' || SQL%ROWCOUNT || ' Rows of QA Results with plan_id: ' || l_plan_ids(i) || ' for char_id: ' || p_char_id
          );

Line: 361

          SAVEPOINT Update_Element_Value_PKG;

Line: 366

    END update_results;

Line: 369

    PROCEDURE update_plan_chars
    (
      p_char_id          IN         NUMBER,
      p_old_value        IN         VARCHAR2,
      p_new_value        IN         VARCHAR2
    )
    IS
      l_api_name      CONSTANT VARCHAR2(30)   := 'update_plan_chars';

Line: 378

        UPDATE  QA_PLAN_CHARS
        SET     default_value     = p_new_value
        WHERE   char_id           = p_char_id
        AND     default_value     = p_old_value;

Line: 388

            'Updated ' || SQL%ROWCOUNT || ' Rows for QA_PLAN_CHARS.default_value for char_id: ' || p_char_id
          );

Line: 391

    END update_plan_chars;

Line: 394

    PROCEDURE update_chars
    (
      p_char_id          IN         NUMBER,
      p_old_value        IN         VARCHAR2,
      p_new_value        IN         VARCHAR2
    )
    IS
      l_api_name      CONSTANT VARCHAR2(30)   := 'update_chars';

Line: 403

        UPDATE  QA_CHARS
        SET     default_value       = p_new_value
        WHERE   char_id             = p_char_id
        AND     default_value       = p_old_value;

Line: 413

            'Updated ' || SQL%ROWCOUNT || ' Rows for QA_CHARS.default_value for char_id: ' || p_char_id
          );

Line: 416

    END update_chars;

Line: 419

    PROCEDURE update_char_action_trig
    (
      p_char_id          IN         NUMBER,
      p_old_value        IN         VARCHAR2,
      p_new_value        IN         VARCHAR2
    )
    IS
      l_api_name      CONSTANT VARCHAR2(30)   := 'update_char_action_trig';

Line: 428

        UPDATE  QA_CHAR_ACTION_TRIGGERS
        SET     low_value_other   = p_new_value
        WHERE   char_id           = p_char_id
        AND     low_value_other   = p_old_value;

Line: 438

            'Updated ' || SQL%ROWCOUNT || ' Rows for QA_CHAR_ACTION_TRIGGERS.low_value_other for char_id: ' || p_char_id
          );

Line: 442

        UPDATE  QA_CHAR_ACTION_TRIGGERS
        SET     high_value_other  = p_new_value
        WHERE   char_id           = p_char_id
        AND     high_value_other  = p_old_value;

Line: 452

            'Updated ' || SQL%ROWCOUNT || ' Rows for QA_CHAR_ACTION_TRIGGERS.high_value_other for char_id: ' || p_char_id
          );

Line: 455

    END update_char_action_trig;

Line: 458

    PROCEDURE update_plan_char_action_trig
    (
      p_char_id          IN         NUMBER,
      p_old_value        IN         VARCHAR2,
      p_new_value        IN         VARCHAR2
    )
    IS
      l_api_name      CONSTANT VARCHAR2(30)   := 'update_plan_char_action_trig';

Line: 467

        UPDATE  QA_PLAN_CHAR_ACTION_TRIGGERS
        SET     low_value_other   = p_new_value
        WHERE   char_id           = p_char_id
        AND     low_value_other   = p_old_value
        AND     plan_id           IN
                (
                  SELECT  DISTINCT plan_id
                  FROM    QA_PLAN_CHARS
                  WHERE   char_id = p_char_id
                );

Line: 483

            'Updated ' || SQL%ROWCOUNT || ' Rows for QA_PLAN_CHAR_ACTION_TRIGGERS.low_value_other for char_id: ' || p_char_id
          );

Line: 487

        UPDATE  QA_PLAN_CHAR_ACTION_TRIGGERS
        SET     high_value_other  = p_new_value
        WHERE   char_id           = p_char_id
        AND     high_value_other  = p_old_value
        AND     plan_id           IN
                (
                  SELECT  DISTINCT plan_id
                  FROM    QA_PLAN_CHARS
                  WHERE   char_id = p_char_id
                );

Line: 503

            'Updated ' || SQL%ROWCOUNT || ' Rows for QA_PLAN_CHAR_ACTION_TRIGGERS.high_value_other for char_id: ' || p_char_id
          );

Line: 506

    END update_plan_char_action_trig;

Line: 509

    PROCEDURE update_plan_coll_trig
    (
      p_char_id          IN         NUMBER,
      p_old_value        IN         VARCHAR2,
      p_new_value        IN         VARCHAR2
    )
    IS
      l_api_name      CONSTANT VARCHAR2(30)   := 'update_plan_coll_trig';

Line: 518

        UPDATE  QA_PLAN_COLLECTION_TRIGGERS
        SET     low_value             = p_new_value
        WHERE   collection_trigger_id = p_char_id
        AND     low_value             = p_old_value
        AND     plan_transaction_id   IN
                (
                  SELECT  qpt.plan_transaction_id
                  FROM    QA_PLAN_TRANSACTIONS qpt,
                          QA_PLAN_CHARS qpc
                  WHERE   qpt.plan_id = qpc.plan_id
                  AND     qpc.char_id = p_char_id
                );

Line: 536

            'Updated ' || SQL%ROWCOUNT || ' Rows for QA_PLAN_COLLECTION_TRIGGERS.low_value for char_id: ' || p_char_id
          );

Line: 540

        UPDATE  QA_PLAN_COLLECTION_TRIGGERS
        SET     high_value            = p_new_value
        WHERE   collection_trigger_id = p_char_id
        AND     high_value            = p_old_value
        AND     plan_transaction_id   IN
                (
                  SELECT  qpt.plan_transaction_id
                  FROM    QA_PLAN_TRANSACTIONS qpt,
                          QA_PLAN_CHARS qpc
                  WHERE   qpt.plan_id = qpc.plan_id
                  AND     qpc.char_id = p_char_id
                );

Line: 558

            'Updated ' || SQL%ROWCOUNT || ' Rows for QA_PLAN_COLLECTION_TRIGGERS.high_value for char_id: ' || p_char_id
          );

Line: 561

    END update_plan_coll_trig;

Line: 564

    PROCEDURE update_criteria
    (
      p_char_id          IN         NUMBER,
      p_old_value        IN         VARCHAR2,
      p_new_value        IN         VARCHAR2
    )
    IS
      l_api_name      CONSTANT VARCHAR2(30)   := 'update_criteria';

Line: 573

        UPDATE  QA_CRITERIA
        SET     low_value   = p_new_value
        WHERE   char_id     = p_char_id
        AND     low_value   = p_old_value
        AND     criteria_id IN
                (
                  SELECT  qch.criteria_id
                  FROM    QA_CRITERIA_HEADERS qch,
                          QA_PLANS qp,
                          QA_PLAN_CHARS qpc
                  WHERE   qch.organization_id = qp.organization_id
                  AND     qp.plan_id = qpc.plan_id
                  AND     qpc.char_id = p_char_id
                );

Line: 593

            'Updated ' || SQL%ROWCOUNT || ' Rows for QA_CRITERIA.low_value for char_id: ' || p_char_id
          );

Line: 597

        UPDATE  QA_CRITERIA
        SET     high_value  = p_new_value
        WHERE   char_id     = p_char_id
        AND     high_value  = p_old_value
        AND     criteria_id IN
                (
                  SELECT  qch.criteria_id
                  FROM    QA_CRITERIA_HEADERS qch,
                          QA_PLANS qp,
                          QA_PLAN_CHARS qpc
                  WHERE   qch.organization_id = qp.organization_id
                  AND     qp.plan_id = qpc.plan_id
                  AND     qpc.char_id = p_char_id
                );

Line: 617

            'Updated ' || SQL%ROWCOUNT || ' Rows for QA_CRITERIA.high_value for char_id: ' || p_char_id
          );

Line: 620

    END update_criteria;

Line: 623

    PROCEDURE update_pc_criteria
    (
      p_char_id          IN         NUMBER,
      p_old_value        IN         VARCHAR2,
      p_new_value        IN         VARCHAR2
    )
    IS
      l_api_name      CONSTANT VARCHAR2(30)   := 'update_pc_criteria';

Line: 632

        UPDATE  QA_PC_CRITERIA
        SET     low_value   = p_new_value
        WHERE   char_id     = p_char_id
        AND     low_value   = p_old_value
        AND     plan_relationship_id IN
                (
                   SELECT  qppr.plan_relationship_id
                   FROM    QA_PC_PLAN_RELATIONSHIP qppr,
                           QA_PLAN_CHARS qpc
                   WHERE   qppr.parent_plan_id = qpc.plan_id
                   AND     qpc.char_id = p_char_id
                );

Line: 650

            'Updated ' || SQL%ROWCOUNT || ' Rows for QA_PC_CRITERIA.low_value for char_id: ' || p_char_id
          );

Line: 654

        UPDATE  QA_PC_CRITERIA
        SET     high_value  = p_new_value
        WHERE   char_id     = p_char_id
        AND     high_value  = p_old_value
        AND     plan_relationship_id IN
                (
                   SELECT  qppr.plan_relationship_id
                   FROM    QA_PC_PLAN_RELATIONSHIP qppr,
                           QA_PLAN_CHARS qpc
                   WHERE   qppr.parent_plan_id = qpc.plan_id
                   AND     qpc.char_id = p_char_id
                );

Line: 672

            'Updated ' || SQL%ROWCOUNT || ' Rows for QA_PC_CRITERIA.high_value for char_id: ' || p_char_id
          );

Line: 675

    END update_pc_criteria;

Line: 678

    PROCEDURE update_specs
    (
      p_char_id          IN         NUMBER,
      p_old_value        IN         VARCHAR2,
      p_new_value        IN         VARCHAR2
    )
    IS
      l_api_name      CONSTANT VARCHAR2(30)   := 'update_specs';

Line: 687

        UPDATE  QA_SPECS
        SET     spec_element_value   = p_new_value
        WHERE   char_id              = p_char_id
        AND     spec_element_value   = p_old_value;

Line: 697

            'Updated ' || SQL%ROWCOUNT || ' Rows for QA_SPECS.spec_element_value for char_id: ' || p_char_id
          );

Line: 700

    END update_specs;

Line: 705

    PROCEDURE Update_Element_Value
    (
      p_api_version      IN         NUMBER   := NULL,
      p_init_msg_list    IN         VARCHAR2 := NULL,
      p_commit           IN         VARCHAR2 := NULL,
      p_validation_level IN         NUMBER   := NULL,
      p_char_id          IN         NUMBER,
      p_old_value        IN         VARCHAR2,
      p_new_value        IN         VARCHAR2,
      x_return_status    OUT NOCOPY VARCHAR2,
      x_msg_count        OUT NOCOPY NUMBER,
      x_msg_data         OUT NOCOPY VARCHAR2
    )
    IS
      l_api_name      CONSTANT VARCHAR2(30)   := 'Update_Element_Value';

Line: 723

        SELECT 'Y'
        FROM   QA_PLAN_CHARS qpc,
               QA_PLANS qp
        WHERE  qpc.char_id = p_char_id
        AND    qpc.plan_id = qp.plan_id
        AND    qp.organization_id <> 0;

Line: 746

      SAVEPOINT Update_Element_Value_PKG;

Line: 772

          'Before Calling update_chars'
        );

Line: 777

      update_chars
      (
        p_char_id          => p_char_id,
        p_old_value        => p_old_value,
        p_new_value        => p_new_value
      );

Line: 789

          'Before Calling update_char_action_trig'
        );

Line: 794

      update_char_action_trig
      (
        p_char_id          => p_char_id,
        p_old_value        => p_old_value,
        p_new_value        => p_new_value
      );

Line: 829

          'Before Calling update_plan_chars'
        );

Line: 834

      update_plan_chars
      (
        p_char_id          => p_char_id,
        p_old_value        => p_old_value,
        p_new_value        => p_new_value
      );

Line: 846

          'Before Calling update_plan_char_action_trig'
        );

Line: 851

      update_plan_char_action_trig
      (
        p_char_id          => p_char_id,
        p_old_value        => p_old_value,
        p_new_value        => p_new_value
      );

Line: 863

          'Before Calling update_plan_coll_trig'
        );

Line: 868

      update_plan_coll_trig
      (
        p_char_id          => p_char_id,
        p_old_value        => p_old_value,
        p_new_value        => p_new_value
      );

Line: 880

          'Before Calling update_criteria'
        );

Line: 889

          'Before Calling update_pc_criteria'
        );

Line: 894

      update_pc_criteria
      (
        p_char_id          => p_char_id,
        p_old_value        => p_old_value,
        p_new_value        => p_new_value
      );

Line: 906

          'Before Calling update_specs'
        );

Line: 911

      update_specs
      (
        p_char_id          => p_char_id,
        p_old_value        => p_old_value,
        p_new_value        => p_new_value
      );

Line: 919

      update_criteria
      (
        p_char_id          => p_char_id,
        p_old_value        => p_old_value,
        p_new_value        => p_new_value
      );

Line: 930

        SAVEPOINT Update_Element_Value_PKG;

Line: 938

          'Before Calling update_results'
        );

Line: 943

      update_results
      (
        p_char_id          => p_char_id,
        p_old_value        => p_old_value,
        p_new_value        => p_new_value,
        p_commit           => l_commit
      );

Line: 975

        ROLLBACK TO Update_Element_Value_PKG;

Line: 993

        ROLLBACK TO Update_Element_Value_PKG;

Line: 1011

        ROLLBACK TO Update_Element_Value_PKG;

Line: 1037

    END Update_Element_Value;