APPS.JTF_MSITE_PRTY_ACCSS_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: 84

  IS SELECT party_id FROM hz_parties
    WHERE party_id = l_c_party_id;

Line: 148

  IS SELECT msite_prty_accss_id FROM jtf_msite_prty_accss
    WHERE msite_prty_accss_id = l_c_msite_prty_accss_id;

Line: 152

  IS SELECT msite_prty_accss_id FROM jtf_msite_prty_accss
    WHERE msite_id = l_c_msite_id
    AND party_id = l_c_party_id;

Line: 392

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_prty_accss_id            IN NUMBER,
   p_object_version_number          IN NUMBER,
   p_start_date_active              IN DATE,
   p_end_date_active                IN DATE,
   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: 500

END Validate_Update;

Line: 583

    Jtf_Msite_Prty_Accss_Pkg.insert_row
      (
      p_msite_prty_accss_id                => FND_API.G_MISS_NUM,
      p_object_version_number              => l_object_version_number,
      p_msite_id                           => p_msite_id,
      p_party_id                           => p_party_id,
      p_start_date_active                  => p_start_date_active,
      p_end_date_active                    => p_end_date_active,
      p_security_group_id                  => FND_API.G_MISS_NUM,
      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_prty_accss_id                => x_msite_prty_accss_id
      );

Line: 603

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

Line: 607

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

Line: 656

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

Line: 679

  IS SELECT msite_prty_accss_id FROM jtf_msite_prty_accss
    WHERE msite_id = l_c_msite_id
    AND party_id = l_c_party_id;

Line: 686

  SAVEPOINT update_msite_prty_accss_pvt;

Line: 747

  Validate_Update
    (
    p_init_msg_list                  => FND_API.G_FALSE,
    p_validation_level               => p_validation_level,
    p_msite_prty_accss_id            => l_msite_prty_accss_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,
    x_return_status                  => x_return_status,
    x_msg_count                      => x_msg_count,
    x_msg_data                       => x_msg_data
    );

Line: 761

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

Line: 765

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

Line: 772

    Jtf_Msite_Prty_Accss_Pkg.update_row
      (
      p_msite_prty_accss_id                => l_msite_prty_accss_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_security_group_id                  => FND_API.G_MISS_NUM,
      p_last_update_date                   => sysdate,
      p_last_updated_by                    => FND_GLOBAL.user_id,
      p_last_update_login                  => FND_GLOBAL.login_id
      );

Line: 786

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

Line: 790

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

Line: 811

     ROLLBACK TO update_msite_prty_accss_pvt;

Line: 818

     ROLLBACK TO update_msite_prty_accss_pvt;

Line: 825

     ROLLBACK TO update_msite_prty_accss_pvt;

Line: 837

END Update_Msite_Prty_Accss;

Line: 839

PROCEDURE Delete_Msite_Prty_Accss
  (
   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_prty_accss_id         IN NUMBER      := FND_API.G_MISS_NUM,
   p_msite_id                    IN NUMBER      := FND_API.G_MISS_NUM,
   p_party_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_Prty_Accss';

Line: 859

  IS SELECT msite_prty_accss_id FROM jtf_msite_prty_accss
    WHERE msite_id = l_c_msite_id
    AND party_id = l_c_party_id;

Line: 866

  SAVEPOINT delete_msite_prty_accss_pvt;

Line: 923

    Jtf_Msite_Prty_Accss_Pkg.delete_row(l_msite_prty_accss_id);

Line: 926

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

Line: 930

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

Line: 938

     ROLLBACK TO delete_msite_prty_accss_pvt;

Line: 945

     ROLLBACK TO delete_msite_prty_accss_pvt;

Line: 952

     ROLLBACK TO delete_msite_prty_accss_pvt;

Line: 964

END Delete_Msite_Prty_Accss;