APPS.AMS_DMMODEL_PUB SQL Statements

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

Line: 102

      l_pvt_model_rec.row_selection_type := p_model_rec.row_selection_type;

Line: 213

PROCEDURE Update_Model(
    p_api_version_number         IN   NUMBER,
    p_init_msg_list              IN   VARCHAR2     := FND_API.G_FALSE,
    p_commit                     IN   VARCHAR2     := FND_API.G_FALSE,

    x_return_status              OUT NOCOPY  VARCHAR2,
    x_msg_count                  OUT NOCOPY  NUMBER,
    x_msg_data                   OUT NOCOPY  VARCHAR2,

    p_model_rec               IN    model_rec_type,
    x_object_version_number      OUT NOCOPY  NUMBER
    )

 IS
   L_API_NAME                  CONSTANT VARCHAR2(30) := 'Update_Model';

Line: 233

      SAVEPOINT Update_Model_PUB;

Line: 286

      l_pvt_model_rec.row_selection_type := p_model_rec.row_selection_type;

Line: 311

      AMS_DM_Model_PVT.Update_DM_Model(
         p_api_version_number    => 1.0,
         p_init_msg_list         => FND_API.G_FALSE,
         p_commit                => p_commit,
         p_validation_level      => FND_API.G_VALID_LEVEL_FULL,
         x_return_status         => x_return_status,
         x_msg_count             => x_msg_count,
         x_msg_data              => x_msg_data,
         p_dm_model_rec  =>      l_pvt_model_rec,
         x_object_version_number => l_object_version_number
      );

Line: 360

     ROLLBACK TO Update_Model_PUB;

Line: 370

     ROLLBACK TO Update_Model_PUB;

Line: 380

     ROLLBACK TO Update_Model_PUB;

Line: 392

End Update_Model;

Line: 395

PROCEDURE Delete_Model(
    p_api_version_number         IN   NUMBER,
    p_init_msg_list              IN   VARCHAR2     := FND_API.G_FALSE,
    p_commit                     IN   VARCHAR2     := FND_API.G_FALSE,
    x_return_status              OUT NOCOPY  VARCHAR2,
    x_msg_count                  OUT NOCOPY  NUMBER,
    x_msg_data                   OUT NOCOPY  VARCHAR2,
    p_model_id                   IN  NUMBER,
    p_object_version_number      IN   NUMBER
    )

 IS
   L_API_NAME                  CONSTANT VARCHAR2(30) := 'Delete_Model';

Line: 414

      SAVEPOINT Delete_Model_PUB;

Line: 444

      AMS_DM_Model_PVT.Delete_DM_Model(
         p_api_version_number => 1.0,
         p_init_msg_list      => FND_API.G_FALSE,
         p_commit             => p_commit,
         p_validation_level   => FND_API.G_VALID_LEVEL_FULL,
         x_return_status      => x_return_status,
         x_msg_count          => x_msg_count,
         x_msg_data           => x_msg_data,
         p_model_id           => l_model_id,
         p_object_version_number => l_object_version_number );

Line: 494

     ROLLBACK TO Delete_Model_PUB;

Line: 504

     ROLLBACK TO Delete_Model_PUB;

Line: 514

     ROLLBACK TO Delete_Model_PUB;

Line: 526

End Delete_Model;

Line: 664

   L_STANDARD_ROW_SELECTION   CONSTANT VARCHAR2(30) := 'STANDARD';

Line: 675

      SELECT user_status_id
      FROM   ams_user_statuses_vl
      WHERE  system_status_type = p_type
      AND    system_status_code = p_code;

Line: 681

      SELECT custom_setup_id
      FROM   ams_custom_setups_b
      WHERE  object_type = L_OBJECT_TYPE_MODEL
      AND    enabled_flag = 'Y'
      ;

Line: 688

      SELECT ams_dm_models_all_b_s.NEXTVAL
      FROM   dual;

Line: 692

      SELECT 1
      FROM   dual
      WHERE EXISTS (SELECT 1
                    FROM   ams_dm_models_all_b
                    WHERE  model_id = p_model_id)
      ;

Line: 743

   l_model_rec.row_selection_type := L_STANDARD_ROW_SELECTION;