APPS.JTF_MSITE_RESP_MGR_PVT SQL Statements

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

Line: 60

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

PROCEDURE Update_Delete_Msite_Resps
  (
   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_ids                 IN JTF_NUMBER_TABLE,
   p_object_version_numbers         IN JTF_NUMBER_TABLE,
   p_start_date_actives             IN JTF_DATE_TABLE,
   p_end_date_actives               IN JTF_DATE_TABLE,
   p_sort_orders                    IN JTF_NUMBER_TABLE,
   p_display_names                  IN JTF_VARCHAR2_TABLE_300,
   p_delete_flags                   IN JTF_VARCHAR2_TABLE_100,
   x_return_status                  OUT VARCHAR2,
   x_msg_count                      OUT NUMBER,
   x_msg_data                       OUT VARCHAR2
  )
IS
  l_api_name          CONSTANT VARCHAR2(30) := 'Update_Delete_Msite_Resps';

Line: 220

  SAVEPOINT  Update_Delete_Msite_Resps_Pvt;

Line: 245

    IF (p_delete_flags(i) = 'Y') THEN

      Jtf_Msite_Resp_Pvt.Delete_Msite_Resp
        (
        p_api_version                  => p_api_version,
        p_init_msg_list                => FND_API.G_FALSE,
        p_commit                       => FND_API.G_FALSE,
        p_validation_level             => p_validation_level,
        p_msite_resp_id                => p_msite_resp_ids(i),
        p_msite_id                     => FND_API.G_MISS_NUM,
        p_responsibility_id            => FND_API.G_MISS_NUM,
        p_application_id               => FND_API.G_MISS_NUM,
        x_return_status                => x_return_status,
        x_msg_count                    => x_msg_count,
        x_msg_data                     => x_msg_data
        );

Line: 263

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

Line: 267

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

Line: 274

      Jtf_Msite_Resp_Pvt.Update_Msite_Resp
        (
        p_api_version                    => p_api_version,
        p_init_msg_list                  => FND_API.G_FALSE,
        p_commit                         => FND_API.G_FALSE,
        p_validation_level               => p_validation_level,
        p_msite_resp_id                  => p_msite_resp_ids(i),
        p_object_version_number          => p_object_version_numbers(i),
        p_msite_id                       => FND_API.G_MISS_NUM,
        p_responsibility_id              => FND_API.G_MISS_NUM,
        p_application_id                 => FND_API.G_MISS_NUM,
        p_start_date_active              => p_start_date_actives(i),
        p_end_date_active                => p_end_date_actives(i),
        p_sort_order                     => p_sort_orders(i),
        p_display_name                   => p_display_names(i),
        x_return_status                  => x_return_status,
        x_msg_count                      => x_msg_count,
        x_msg_data                       => x_msg_data
        );

Line: 295

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

Line: 299

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

Line: 324

     ROLLBACK TO Update_Delete_Msite_Resps_Pvt;

Line: 331

     ROLLBACK TO Update_Delete_Msite_Resps_Pvt;

Line: 338

     ROLLBACK TO Update_Delete_Msite_Resps_Pvt;

Line: 350

END Update_Delete_Msite_Resps;

Line: 386

  OPEN x_msite_csr FOR SELECT msite_name, msite_description
    FROM jtf_msites_vl
    WHERE msite_id = p_msite_id;

Line: 396

    OPEN x_msite_resp_csr FOR SELECT MR.msite_resp_id,
      MR.object_version_number, R.responsibility_id, R.application_id,
      MR.display_name, A.application_name,
      R.responsibility_key, R.responsibility_name, MR.start_date_active,
      MR.end_date_active, MR.sort_order
      FROM jtf_msite_resps_vl MR, fnd_responsibility_vl R, fnd_application_vl A
      WHERE MR.msite_id = p_msite_id
      AND MR.responsibility_id = R.responsibility_id
      AND MR.application_id = R.application_id
      AND R.application_id = A.application_id;

Line: 409

    OPEN x_msite_resp_csr FOR SELECT MR.msite_resp_id,
      MR.object_version_number, R.responsibility_id, R.application_id,
      MR.display_name, A.application_name,
      R.responsibility_key, R.responsibility_name, MR.start_date_active,
      MR.end_date_active, MR.sort_order
      FROM jtf_msite_resps_vl MR, fnd_responsibility_vl R, fnd_application_vl A
      WHERE MR.msite_id = p_msite_id
      AND MR.application_id = p_application_id
      AND MR.responsibility_id = R.responsibility_id
      AND MR.application_id = R.application_id
      AND R.application_id = A.application_id;

Line: 542

    'SELECT R.responsibility_id, R.application_id FROM fnd_responsibility_vl R, fnd_application_vl A WHERE R.application_id = A.application_id AND ' || l_application_id_sql_str;

Line: 706

    'SELECT R.responsibility_id, R.application_id, A.application_name, R.responsibility_key, R.responsibility_name, R.description, R.start_date, R.end_date FROM fnd_responsibility_vl R, fnd_application_vl A WHERE ' ||
    ' R.application_id = A.application_id AND ' ||
    l_tmp_str;