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_DSP_MSITE_SCT_ITEM_PVT SQL Statements

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

Line: 43


PROCEDURE insert_row
  (
   p_mini_site_section_item_id          IN NUMBER,
   p_object_version_number              IN NUMBER,
   p_mini_site_id                       IN NUMBER,
   p_section_item_id                    IN NUMBER,
   p_start_date_active                  IN DATE,
   p_end_date_active                    IN DATE,
   p_creation_date                      IN DATE,
   p_created_by                         IN NUMBER,
   p_last_update_date                   IN DATE,
   p_last_updated_by                    IN NUMBER,
   p_last_update_login                  IN NUMBER,
   x_rowid                              OUT VARCHAR2,
   x_mini_site_section_item_id          OUT NUMBER
  )
IS

  CURSOR c IS SELECT rowid FROM jtf_dsp_msite_sct_items
    WHERE mini_site_section_item_id = x_mini_site_section_item_id;

Line: 63


  CURSOR c2 IS SELECT jtf_dsp_msite_sct_items_s1.nextval FROM dual;

Line: 78


  INSERT INTO jtf_dsp_msite_sct_items
    (
    mini_site_section_item_id,
    object_version_number,
    mini_site_id,
    section_item_id,
    start_date_active,
    end_date_active,
    creation_date,
    created_by,
    last_update_date,
    last_updated_by,
    last_update_login
    )
    VALUES
    (
    x_mini_site_section_item_id,
    p_object_version_number,
    p_mini_site_id,
    p_section_item_id,
    p_start_date_active,
    decode(p_end_date_active, FND_API.G_MISS_DATE, NULL, p_end_date_active),
    decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
           p_creation_date),
    decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
           NULL, FND_GLOBAL.user_id, p_created_by),
    decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
           p_last_update_date),
    decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
           NULL, FND_GLOBAL.user_id, p_last_updated_by),
    decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
           NULL, FND_GLOBAL.login_id, p_last_update_login)
    );

Line: 121


END insert_row;

Line: 127


PROCEDURE update_row
  (
  p_mini_site_section_item_id           IN NUMBER,
  p_object_version_number               IN NUMBER   := FND_API.G_MISS_NUM,
  p_start_date_active                   IN DATE,
  p_end_date_active                     IN DATE,
  p_last_update_date                    IN DATE,
  p_last_updated_by                     IN NUMBER,
  p_last_update_login                   IN NUMBER
  )
IS
BEGIN

  -- update base
  UPDATE jtf_dsp_msite_sct_items SET
    object_version_number = object_version_number + 1,
    start_date_active = decode(p_start_date_active, FND_API.G_MISS_DATE,
                               start_date_active, p_start_date_active),
    end_date_active = decode(p_end_date_active, FND_API.G_MISS_DATE,
                             end_date_active, p_end_date_active),
    last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE,
                              sysdate, NULL, sysdate, p_last_update_date),
    last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
                             FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
                             p_last_updated_by),
    last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
                               FND_GLOBAL.login_id, NULL,
                               FND_GLOBAL.login_id, p_last_update_login)
    WHERE mini_site_section_item_id = p_mini_site_section_item_id
      AND object_version_number = decode(p_object_version_number,
                                         FND_API.G_MISS_NUM,
                                         object_version_number,
                                         p_object_version_number);

Line: 165


END update_row;

Line: 172


PROCEDURE delete_row
  (
   p_mini_site_section_item_id IN NUMBER
  )
IS
BEGIN

  DELETE FROM jtf_dsp_msite_sct_items
    WHERE mini_site_section_item_id = p_mini_site_section_item_id;

Line: 186


END delete_row;

Line: 238


      SELECT mini_site_section_item_id INTO l_tmp_msite_sct_item_id
        FROM  jtf_dsp_msite_sct_items
        WHERE mini_site_id = p_mini_site_id
          AND section_item_id = p_section_item_id;

Line: 365


    SELECT msite_id INTO l_mini_site_id FROM jtf_msites_b
      WHERE msite_id = p_mini_site_id;

Line: 383


    SELECT section_item_id INTO l_section_item_id FROM jtf_dsp_section_items
      WHERE section_item_id = p_section_item_id;

Line: 449


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_mini_site_section_item_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: 527


END Validate_Update;

Line: 615


    insert_row
      (
      FND_API.G_MISS_NUM,
      l_object_version_number,
      p_mini_site_id,
      p_section_item_id,
      p_start_date_active,
      p_end_date_active,
      SYSDATE,
      FND_GLOBAL.user_id,
      SYSDATE,
      FND_GLOBAL.user_id,
      FND_GLOBAL.login_id,
      l_rowid,
      x_mini_site_section_item_id
      );

Line: 633


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

Line: 637


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

Line: 692


PROCEDURE Update_MSite_Section_Item
  (
   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_mini_site_section_item_id      IN NUMBER   := FND_API.G_MISS_NUM,
   p_object_version_number          IN NUMBER,
   p_mini_site_id                   IN NUMBER   := FND_API.G_MISS_NUM,
   p_section_item_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_Section_Item';

Line: 720


  SAVEPOINT  UPDATE_MSITE_SCT_ITEM_PVT;

Line: 762


      SELECT mini_site_section_item_id INTO l_msite_sct_item_id
        FROM jtf_dsp_msite_sct_items
        WHERE mini_site_id = p_mini_site_id
          AND section_item_id = p_section_item_id;

Line: 792


  Validate_Update
    (
    p_init_msg_list                  => FND_API.G_FALSE,
    p_validation_level               => p_validation_level,
    p_mini_site_section_item_id      => l_msite_sct_item_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                  => l_return_status,
    x_msg_count                      => l_msg_count,
    x_msg_data                       => l_msg_data
    );

Line: 808


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

Line: 815


    update_row
      (
      l_msite_sct_item_id,
      p_object_version_number,
      p_start_date_active,
      p_end_date_active,
      SYSDATE,
      FND_GLOBAL.user_id,
      FND_GLOBAL.login_id
      );

Line: 827


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

Line: 831


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

Line: 852


     ROLLBACK TO UPDATE_MSITE_SCT_ITEM_PVT;

Line: 859


     ROLLBACK TO UPDATE_MSITE_SCT_ITEM_PVT;

Line: 866


     ROLLBACK TO UPDATE_MSITE_SCT_ITEM_PVT;

Line: 878


END Update_MSite_Section_Item;

Line: 881


PROCEDURE Delete_MSite_Section_Item
  (
   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_call_from_trigger            IN BOOLEAN     := FALSE,
   p_mini_site_section_item_id    IN NUMBER      := FND_API.G_MISS_NUM,
   p_mini_site_id                 IN NUMBER      := FND_API.G_MISS_NUM,
   p_section_item_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_Section_Item';

Line: 904


    SAVEPOINT  DELETE_MSITE_SCT_ITEM_PVT;

Line: 944


        SELECT mini_site_section_item_id INTO l_msite_sct_item_id
          FROM jtf_dsp_msite_sct_items
          WHERE mini_site_id = p_mini_site_id
            AND section_item_id = p_section_item_id;

Line: 973


  delete_row(l_msite_sct_item_id);

Line: 979


       ROLLBACK TO DELETE_MSITE_SCT_ITEM_PVT;

Line: 988


       ROLLBACK TO DELETE_MSITE_SCT_ITEM_PVT;

Line: 997


       ROLLBACK TO DELETE_MSITE_SCT_ITEM_PVT;

Line: 1010


END Delete_MSite_Section_Item;