DBA Data[Home] [Help]

APPS.GMD_QC_TESTS_PUB SQL Statements

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

Line: 8

 *          DELETE_TEST_HEADERS                                  *
 *          DELETE_TEST_VALUES                                   *
 *          DELETE_CUSTOMER_TESTS                                *
 *                                                               *
 * Use      This is the public layer for the QC TESTS API        *
 *                                                               *
 * History                                                       *
 *         Written by H Verdding, OPM Development (EMEA)         *
 *                                                               *
 *         HVerddin B2711643: Added call to set user_context     *
 *                                                               *
 *                                                               *
 *****************************************************************
*/

/*  Global variables   */

G_PKG_NAME           CONSTANT  VARCHAR2(30):='GMD_QC_TESTS_PUB';
Line: 180

     GMD_QC_TESTS_GRP.VALIDATE_BEFORE_INSERT(
           p_gmd_qc_tests_rec => l_qc_tests_rec_in,
           x_gmd_qc_tests_rec => l_qc_tests_rec,
           x_return_status    => l_return_status,
           x_message_data     => l_msg_data);
Line: 195

      l_qc_tests_rec.last_updated_by := l_user_id;
Line: 198

      IF NOT GMD_QC_TESTS_PVT.INSERT_ROW(
            p_qc_tests_rec  => l_qc_tests_rec) THEN
            RAISE FND_API.G_EXC_ERROR;
Line: 205

      GMD_QC_TESTS_GRP.PROCESS_AFTER_INSERT(
           p_init_msg_list    => p_init_msg_list,
           p_gmd_qc_tests_rec => l_qc_tests_rec,
           x_return_status    => x_return_status,
           x_message_data     => x_msg_data
      );
Line: 280

            GMD_QC_TEST_VALUES_GRP.VALIDATE_BEFORE_INSERT(
                p_qc_test_values_rec => l_qc_test_values_rec_in,
                x_qc_test_values_rec => l_qc_test_values_rec,
                x_return_status      => l_return_status,
                x_message_data       => l_msg_data
            );
Line: 295

           l_qc_test_values_rec.last_updated_by := l_user_id;
Line: 298

            IF NOT GMD_QC_TEST_VALUES_PVT.INSERT_ROW(
                p_qc_test_values_rec => l_qc_test_values_rec) THEN
                RAISE FND_API.G_EXC_ERROR;
Line: 311

     GMD_QC_TEST_VALUES_GRP.VALIDATE_AFTER_INSERT_ALL(
        p_gmd_qc_tests_rec => l_qc_tests_rec,
        x_gmd_qc_tests_rec => l_qc_tests_rec_in,
        x_return_status    => l_return_status,
        x_message_data     => l_msg_data);
Line: 381

           GMD_CUSTOMER_TESTS_GRP.VALIDATE_BEFORE_INSERT(
              p_init_msg_list      => p_init_msg_list,
              p_customer_tests_rec => l_qc_cust_tests_rec,
              x_return_status      => l_return_status,
              x_message_data       => l_msg_data);
Line: 395

           l_qc_cust_tests_rec.last_updated_by := l_user_id;
Line: 397

            IF NOT GMD_CUSTOMER_TESTS_PVT.INSERT_ROW(
                p_customer_tests_rec => l_qc_cust_tests_rec ) THEN
                RAISE FND_API.G_EXC_ERROR;
Line: 455

PROCEDURE DELETE_TEST_HEADERS
( p_api_version          IN  NUMBER
, p_init_msg_list        IN  VARCHAR2
, p_commit               IN  VARCHAR2
, p_validation_level     IN  NUMBER
, p_qc_tests_rec         IN  GMD_QC_TESTS%ROWTYPE
, p_user_name            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) := 'DELETE_TEST_HEADERS';
Line: 483

  SAVEPOINT DELETE_TEST_HEADERS;
Line: 543

  IF l_qc_tests_rec.delete_mark = 1 THEN
     GMD_API_PUB.Log_Message('GMD_RECORD_DELETE_MARKED',
                              'l_table_name', 'GMD_QC_TESTS',
                              'l_column_name', 'TEST_ID',
                              'l_key_value', l_qc_tests_rec.test_id);
Line: 568

      IF NOT GMD_QC_TESTS_PVT.mark_for_delete(
         p_test_id           => l_qc_tests_rec.test_id,
         p_test_code         => l_qc_tests_rec.test_code,
         p_last_update_date  => SYSDATE,
         p_last_updated_by   => l_user_id,
         p_last_update_login => l_qc_tests_rec.last_update_login
         ) THEN
          GMD_API_PUB.Log_Message('GMD_FAILED_TO_DELETE_ROW',
                              'l_table_name', 'GMD_QC_TESTS',
                              'l_column_name','TEST_ID',
                              'l_key_value', l_qc_tests_rec.test_id);
Line: 597

      ROLLBACK TO DELETE_TEST_HEADERS;
Line: 605

      ROLLBACK TO DELETE_TEST_HEADERS;
Line: 616

      ROLLBACK TO DELETE_TEST_HEADERS;
Line: 626

END DELETE_TEST_HEADERS;
Line: 629

PROCEDURE DELETE_TEST_VALUES
( p_api_version          IN  NUMBER
, p_init_msg_list        IN  VARCHAR2
, p_commit               IN  VARCHAR2
, p_validation_level     IN  NUMBER
, p_qc_test_values_tbl   IN  GMD_QC_TESTS_PUB.qc_test_values_tbl
, x_deleted_rows         OUT NOCOPY NUMBER
, 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) := 'DELETE_TEST_VALUES';
Line: 650

  l_deleted_rows       NUMBER(10);
Line: 658

  SAVEPOINT DELETE_TEST_VALUES;
Line: 747

     GMD_QC_TEST_VALUES_GRP.VALIDATE_BEFORE_DELETE(
       p_test_value_id   => l_qc_test_values_rec.test_value_id,
       x_return_status   => l_return_status,
       x_message_data    => l_msg_data);
Line: 771

      IF NOT GMD_QC_TEST_VALUES_PVT.DELETE_ROW(
         p_test_value_id     => l_qc_test_values_rec.test_value_id) THEN
         GMD_API_PUB.Log_Message('GMD_FAILED_TO_DELETE_ROW',
                            'l_table_name', 'GMD_QC_TEST_VALUES',
                            'l_column_name', 'TEST_VALUE_ID',
                            'l_key_value', l_qc_test_values_rec.test_value_id);
Line: 783

      l_deleted_rows := l_deleted_rows + i;
Line: 789

   GMD_QC_TEST_VALUES_GRP.VALIDATE_AFTER_DELETE_ALL(
    p_gmd_qc_tests_rec => l_qc_tests_rec,
    x_gmd_qc_tests_rec => l_qc_tests_rec_in,
    x_return_status    => l_return_status,
    x_message_data     => l_msg_data);
Line: 809

  x_deleted_rows       := l_deleted_rows;
Line: 813

      ROLLBACK TO DELETE_TEST_VALUES;
Line: 821

      ROLLBACK TO DELETE_TEST_VALUES;
Line: 832

      ROLLBACK TO DELETE_TEST_VALUES;
Line: 842

END DELETE_TEST_VALUES;
Line: 844

PROCEDURE DELETE_CUSTOMER_TESTS
( p_api_version          IN  NUMBER
, p_init_msg_list        IN  VARCHAR2
, p_commit               IN  VARCHAR2
, p_validation_level     IN  NUMBER
, p_qc_cust_tests_tbl    IN  GMD_QC_TESTS_PUB.qc_cust_tests_tbl
, x_deleted_rows         OUT NOCOPY NUMBER
, 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) := 'DELETE_CUSTOMER_TESTS';
Line: 864

  l_deleted_rows       NUMBER;
Line: 872

  SAVEPOINT DELETE_CUSTOMER_TESTS;
Line: 949

      GMD_CUSTOMER_TESTS_GRP.VALIDATE_BEFORE_DELETE(
          p_init_msg_list   => p_init_msg_list,
          p_test_id         => l_qc_cust_tests_rec.test_id,
          p_cust_id         => l_qc_cust_tests_rec.cust_id,
          x_return_status   => l_return_status,
          x_message_data    => l_msg_data);
Line: 975

      IF NOT GMD_CUSTOMER_TESTS_PVT.DELETE_ROW(
         p_test_id      => l_qc_cust_tests_rec.test_id,
         p_cust_id      => l_qc_cust_tests_rec.cust_id) THEN

         GMD_API_PUB.Log_Message('GMD_FAILED_TO_DELETE_ROW',
                              'l_table_name', 'GMD_CUSTOMER_TESTS',
                              'l_column_name','CUST_ID',
                              'l_key_value', l_qc_cust_tests_rec.cust_id);
Line: 989

      l_deleted_rows := l_deleted_rows + i;
Line: 1002

  x_deleted_rows       := l_deleted_rows;
Line: 1006

      ROLLBACK TO DELETE_CUSTOMER_TESTS;
Line: 1014

      ROLLBACK TO DELETE_CUSTOMER_TESTS;
Line: 1025

      ROLLBACK TO DELETE_CUSTOMER_TESTS;
Line: 1035

END delete_customer_tests;