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.IBE_DSP_MSITE_SCT_ITEM_PVT SQL Statements

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

Line: 45


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 NOCOPY VARCHAR2,
   x_mini_site_section_item_id          OUT NOCOPY NUMBER
  )
IS

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

Line: 65


  CURSOR c2 IS SELECT ibe_dsp_msite_sct_items_s1.nextval FROM dual;

Line: 80


  INSERT INTO ibe_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: 123


END insert_row;

Line: 129


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 ibe_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: 167


END update_row;

Line: 174


PROCEDURE delete_row
  (
   p_mini_site_section_item_id IN NUMBER
  )
IS
BEGIN

  DELETE FROM ibe_dsp_msite_sct_items
    WHERE mini_site_section_item_id = p_mini_site_section_item_id;

Line: 188


END delete_row;

Line: 240


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

Line: 378


    SELECT msite_id INTO l_mini_site_id FROM ibe_msites_b
      WHERE msite_id = p_mini_site_id and site_type = 'I';

Line: 402


    SELECT section_item_id INTO l_section_item_id FROM ibe_dsp_section_items
      WHERE section_item_id = p_section_item_id;

Line: 480


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

Line: 564


END Validate_Update;

Line: 652


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


       FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_MSI_INSERT_FAIL');

Line: 680


       FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_MSI_INSERT_FAIL');

Line: 742


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

Line: 770


  SAVEPOINT  UPDATE_MSITE_SCT_ITEM_PVT;

Line: 812


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

Line: 848


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


    FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_MSI_INVALID_UPDATE');

Line: 871


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


       FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_MSI_UPDATE_FAIL');

Line: 893


       FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_MSI_UPDATE_FAIL');

Line: 914


     ROLLBACK TO UPDATE_MSITE_SCT_ITEM_PVT;

Line: 921


     ROLLBACK TO UPDATE_MSITE_SCT_ITEM_PVT;

Line: 928


     ROLLBACK TO UPDATE_MSITE_SCT_ITEM_PVT;

Line: 947


END Update_MSite_Section_Item;

Line: 950


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

Line: 973


    SAVEPOINT  DELETE_MSITE_SCT_ITEM_PVT;

Line: 1013


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

Line: 1048


  delete_row(l_msite_sct_item_id);

Line: 1054


       ROLLBACK TO DELETE_MSITE_SCT_ITEM_PVT;

Line: 1063


       ROLLBACK TO DELETE_MSITE_SCT_ITEM_PVT;

Line: 1072


       ROLLBACK TO DELETE_MSITE_SCT_ITEM_PVT;

Line: 1092


END Delete_MSite_Section_Item;