DBA Data[Home] [Help]

APPS.IBE_MSITE_RESP_PVT SQL Statements

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

Line: 27

  IS SELECT msite_id FROM ibe_msites_b
    WHERE msite_id = l_c_msite_id
    AND master_msite_flag = 'N' and site_type = 'I';
Line: 91

  IS SELECT responsibility_id FROM fnd_responsibility_vl
    WHERE responsibility_id = l_c_responsibility_id
    AND application_id = l_c_application_id;
Line: 159

  IS SELECT msite_resp_id FROM ibe_msite_resps_b
    WHERE msite_resp_id = l_c_msite_resp_id;
Line: 164

  IS SELECT msite_resp_id FROM ibe_msite_resps_b
    WHERE msite_id = l_c_msite_id
    AND responsibility_id = l_c_responsibility_id
    AND application_id = l_c_application_id;
Line: 448

PROCEDURE Validate_Update
  (
   p_init_msg_list                  IN VARCHAR2 := FND_API.G_FALSE,
   p_validation_level               IN NUMBER   := FND_API.G_VALID_LEVEL_FULL,
   p_msite_resp_id                  IN NUMBER,
   p_object_version_number          IN NUMBER,
   p_start_date_active              IN DATE,
   p_end_date_active                IN DATE,
   p_sort_order                     IN NUMBER,
   p_display_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) := 'Validate_Update';
Line: 578

END Validate_Update;
Line: 669

    Ibe_Msite_Resp_Pkg.insert_row
      (
      p_msite_resp_id                      => p_msite_resp_id,
      p_object_version_number              => l_object_version_number,
      p_msite_id                           => p_msite_id,
      p_responsibility_id                  => p_responsibility_id,
      p_application_id                     => p_application_id,
      p_start_date_active                  => p_start_date_active,
      p_end_date_active                    => p_end_date_active,
      p_sort_order                         => p_sort_order,
      p_display_name                       => p_display_name,
      p_group_code                         => p_group_code,
      p_creation_date                      => sysdate,
      p_created_by                         => FND_GLOBAL.user_id,
      p_last_update_date                   => sysdate,
      p_last_updated_by                    => FND_GLOBAL.user_id,
      p_last_update_login                  => FND_GLOBAL.login_id,
      x_rowid                              => l_rowid,
      x_msite_resp_id                      => x_msite_resp_id
      );
Line: 692

       FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITE_RESP_INSERT_FL');
Line: 696

       FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITE_RESP_INSERT_FL');
Line: 744

PROCEDURE Update_Msite_Resp
  (
   p_api_version                    IN NUMBER,
   p_init_msg_list                  IN VARCHAR2 := FND_API.G_FALSE,
   p_commit                         IN VARCHAR2 := FND_API.G_FALSE,
   p_validation_level               IN NUMBER   := FND_API.G_VALID_LEVEL_FULL,
   p_msite_resp_id                  IN NUMBER   := FND_API.G_MISS_NUM,
   p_object_version_number          IN NUMBER,
   p_msite_id                       IN NUMBER   := FND_API.G_MISS_NUM,
   p_responsibility_id              IN NUMBER   := FND_API.G_MISS_NUM,
   p_application_id                 IN NUMBER   := FND_API.G_MISS_NUM,
   p_start_date_active              IN DATE     := FND_API.G_MISS_DATE,
   p_end_date_active                IN DATE     := FND_API.G_MISS_DATE,
   p_sort_order                     IN NUMBER   := FND_API.G_MISS_NUM,
   p_display_name                   IN VARCHAR2 := FND_API.G_MISS_CHAR,
   p_group_code                     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_Msite_Resp';
Line: 772

  IS SELECT msite_resp_id FROM ibe_msite_resps_b
    WHERE msite_id = l_c_msite_id
    AND responsibility_id = l_c_responsibility_id
    AND application_id = l_c_application_id;
Line: 780

  SAVEPOINT update_msite_resp_pvt;
Line: 844

  Validate_Update
    (
    p_init_msg_list                  => FND_API.G_FALSE,
    p_validation_level               => p_validation_level,
    p_msite_resp_id                  => l_msite_resp_id,
    p_object_version_number          => p_object_version_number,
    p_start_date_active              => p_start_date_active,
    p_end_date_active                => p_end_date_active,
    p_sort_order                     => p_sort_order,
    p_display_name                   => p_display_name,
    x_return_status                  => x_return_status,
    x_msg_count                      => x_msg_count,
    x_msg_data                       => x_msg_data
    );
Line: 860

    FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MR_INVALID_UPDATE');
Line: 864

    FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MR_INVALID_UPDATE');
Line: 871

    Ibe_Msite_Resp_Pkg.update_row
      (
      p_msite_resp_id                      => l_msite_resp_id,
      p_object_version_number              => p_object_version_number,
      p_start_date_active                  => p_start_date_active,
      p_end_date_active                    => p_end_date_active,
      p_sort_order                         => p_sort_order,
      p_display_name                       => p_display_name,
      p_group_code                         => p_group_code,
      p_last_update_date                   => sysdate,
      p_last_updated_by                    => FND_GLOBAL.user_id,
      p_last_update_login                  => FND_GLOBAL.login_id
      );
Line: 887

       FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITE_RESP_UPDATE_FL');
Line: 891

       FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITE_RESP_UPDATE_FL');
Line: 912

     ROLLBACK TO update_msite_resp_pvt;
Line: 919

     ROLLBACK TO update_msite_resp_pvt;
Line: 926

     ROLLBACK TO update_msite_resp_pvt;
Line: 938

END Update_Msite_Resp;
Line: 940

PROCEDURE Delete_Msite_Resp
  (
   p_api_version                 IN NUMBER,
   p_init_msg_list               IN VARCHAR2    := FND_API.G_FALSE,
   p_commit                      IN VARCHAR2    := FND_API.G_FALSE,
   p_validation_level            IN NUMBER      := FND_API.G_VALID_LEVEL_FULL,
   p_msite_resp_id               IN NUMBER      := FND_API.G_MISS_NUM,
   p_msite_id                    IN NUMBER      := FND_API.G_MISS_NUM,
   p_responsibility_id           IN NUMBER      := FND_API.G_MISS_NUM,
   p_application_id              IN NUMBER      := FND_API.G_MISS_NUM,
   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_Msite_Resp';
Line: 962

  IS SELECT msite_resp_id FROM ibe_msite_resps_b
    WHERE msite_id = l_c_msite_id
    AND responsibility_id = l_c_responsibility_id
    AND application_id = l_c_application_id;
Line: 970

  SAVEPOINT delete_msite_resp_pvt;
Line: 1030

    Ibe_Msite_Resp_Pkg.delete_row(l_msite_resp_id);
Line: 1033

       FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITE_RESP_DELETE_FL');
Line: 1037

       FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITE_RESP_DELETE_FL');
Line: 1045

     ROLLBACK TO delete_msite_resp_pvt;
Line: 1052

     ROLLBACK TO delete_msite_resp_pvt;
Line: 1059

     ROLLBACK TO delete_msite_resp_pvt;
Line: 1071

END Delete_Msite_Resp;
Line: 1074

PROCEDURE Delete_Msite_Resp_Group
  (
   p_api_version                 IN NUMBER,
   p_init_msg_list               IN VARCHAR2    := FND_API.G_FALSE,
   p_commit                      IN VARCHAR2    := FND_API.G_FALSE,
   p_validation_level            IN NUMBER      := FND_API.G_VALID_LEVEL_FULL,
   p_msite_resp_id               IN NUMBER      := FND_API.G_MISS_NUM,
   p_msite_id                    IN NUMBER      := FND_API.G_MISS_NUM,
   p_responsibility_id           IN NUMBER      := FND_API.G_MISS_NUM,
   p_application_id              IN NUMBER      := FND_API.G_MISS_NUM,
   p_group_code                  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_Msite_Resp_Group';
Line: 1098

  IS SELECT msite_resp_id
    FROM ibe_msite_resps_b
    WHERE msite_id = l_c_msite_id
    AND responsibility_id = l_c_responsibility_id
    AND application_id = l_c_application_id;
Line: 1105

  IS SELECT count(*)
  FROM ibe_msite_resps_b
  WHERE msite_resp_id = l_msite_resp_id;
Line: 1112

  SAVEPOINT delete_msite_resp_pvt;
Line: 1186

      UPDATE ibe_msite_resps_b SET
      group_code = null
      where msite_resp_id = p_msite_resp_id
      AND group_code = p_group_code;
Line: 1197

        FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITE_RESP_DELETE_FL');
Line: 1201

        FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITE_RESP_DELETE_FL');
Line: 1212

      DELETE FROM ibe_msite_resps_b
      WHERE msite_resp_id = p_msite_resp_id
      AND group_code = p_group_code;
Line: 1222

        FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITE_RESP_DELETE_FL');
Line: 1226

        FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_MSITE_RESP_DELETE_FL');
Line: 1234

     ROLLBACK TO delete_msite_resp_pvt;
Line: 1241

     ROLLBACK TO delete_msite_resp_pvt;
Line: 1248

     ROLLBACK TO delete_msite_resp_pvt;
Line: 1260

END Delete_Msite_Resp_Group;