eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_MSITE_RESP_PVT SQL Statements

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

Line: 21


  IS SELECT msite_id FROM jtf_msites_b
    WHERE msite_id = l_c_msite_id
    AND master_msite_flag = 'N';

Line: 85


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

Line: 153


  IS SELECT msite_resp_id FROM jtf_msite_resps_b
    WHERE msite_resp_id = l_c_msite_resp_id;

Line: 158


  IS SELECT msite_resp_id FROM jtf_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: 440


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 VARCHAR2,
   x_msg_count                      OUT NUMBER,
   x_msg_data                       OUT VARCHAR2
  )
IS
  l_api_name              CONSTANT VARCHAR2(30) := 'Validate_Update';

Line: 570


END Validate_Update;

Line: 659


    Jtf_Msite_Resp_Pkg.insert_row
      (
      p_msite_resp_id                      => FND_API.G_MISS_NUM,
      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_security_group_id                  => FND_API.G_MISS_NUM,
      p_display_name                       => p_display_name,
      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: 682


       FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITE_RESP_INSERT_FL');

Line: 686


       FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITE_RESP_INSERT_FL');

Line: 735


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,
   x_return_status                  OUT VARCHAR2,
   x_msg_count                      OUT NUMBER,
   x_msg_data                       OUT VARCHAR2
  )
IS
  l_api_name          CONSTANT VARCHAR2(30) := 'Update_Msite_Resp';

Line: 762


  IS SELECT msite_resp_id FROM jtf_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: 770


  SAVEPOINT update_msite_resp_pvt;

Line: 834


  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: 850


    FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MR_INVALID_UPDATE');

Line: 854


    FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MR_INVALID_UPDATE');

Line: 861


    Jtf_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_security_group_id                  => FND_API.G_MISS_NUM,
      p_display_name                       => p_display_name,
      p_last_update_date                   => sysdate,
      p_last_updated_by                    => FND_GLOBAL.user_id,
      p_last_update_login                  => FND_GLOBAL.login_id
      );

Line: 877


       FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITE_RESP_UPDATE_FL');

Line: 881


       FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITE_RESP_UPDATE_FL');

Line: 902


     ROLLBACK TO update_msite_resp_pvt;

Line: 909


     ROLLBACK TO update_msite_resp_pvt;

Line: 916


     ROLLBACK TO update_msite_resp_pvt;

Line: 928


END Update_Msite_Resp;

Line: 930


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 VARCHAR2,
   x_msg_count                   OUT NUMBER,
   x_msg_data                    OUT VARCHAR2
  )
IS
  l_api_name          CONSTANT VARCHAR2(30)  := 'Delete_Msite_Resp';

Line: 952


  IS SELECT msite_resp_id FROM jtf_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: 960


  SAVEPOINT delete_msite_resp_pvt;

Line: 1020


    Jtf_Msite_Resp_Pkg.delete_row(l_msite_resp_id);

Line: 1023


       FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITE_RESP_DELETE_FL');

Line: 1027


       FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_MSITE_RESP_DELETE_FL');

Line: 1035


     ROLLBACK TO delete_msite_resp_pvt;

Line: 1042


     ROLLBACK TO delete_msite_resp_pvt;

Line: 1049


     ROLLBACK TO delete_msite_resp_pvt;

Line: 1061


END Delete_Msite_Resp;