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

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

Line: 75


PROCEDURE insert_row
  (
   p_section_id                         IN NUMBER,
   p_object_version_number              IN NUMBER,
   p_access_name                        IN VARCHAR2,
   p_start_date_active                  IN DATE,
   p_end_date_active                    IN DATE,
   p_section_type_code                  IN VARCHAR2,
   p_status_code                        IN VARCHAR2,
   p_display_context_id                 IN NUMBER,
   p_deliverable_id                     IN NUMBER,
   p_available_in_all_sites_flag        IN VARCHAR2,
   p_auto_placement_rule                IN VARCHAR2,
   p_order_by_clause                    IN VARCHAR2,
   p_attribute_category                 IN VARCHAR2,
   p_attribute1                         IN VARCHAR2,
   p_attribute2                         IN VARCHAR2,
   p_attribute3                         IN VARCHAR2,
   p_attribute4                         IN VARCHAR2,
   p_attribute5                         IN VARCHAR2,
   p_attribute6                         IN VARCHAR2,
   p_attribute7                         IN VARCHAR2,
   p_attribute8                         IN VARCHAR2,
   p_attribute9                         IN VARCHAR2,
   p_attribute10                        IN VARCHAR2,
   p_attribute11                        IN VARCHAR2,
   p_attribute12                        IN VARCHAR2,
   p_attribute13                        IN VARCHAR2,
   p_attribute14                        IN VARCHAR2,
   p_attribute15                        IN VARCHAR2,
   p_display_name                       IN VARCHAR2,
   p_description                        IN VARCHAR2,
   p_long_description                   IN VARCHAR2,
   p_keywords                           IN VARCHAR2,
   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_section_id                         OUT NOCOPY NUMBER
  )
IS
  l_display_context_id   NUMBER;

Line: 121


  CURSOR c IS SELECT rowid FROM ibe_dsp_sections_b
    WHERE section_id = x_section_id;

Line: 123


  CURSOR c2 IS SELECT ibe_dsp_sections_b_s1.nextval FROM dual;

Line: 138


  INSERT INTO ibe_dsp_sections_b
  (
  section_id,
  object_version_number,
  access_name,
  start_date_active,
  end_date_active,
  section_type_code,
  status_code,
  display_context_id,
  deliverable_id,
  available_in_all_sites_flag,
  auto_placement_rule,
  order_by_clause,
  attribute_category,
  attribute1,
  attribute2,
  attribute3,
  attribute4,
  attribute5,
  attribute6,
  attribute7,
  attribute8,
  attribute9,
  attribute10,
  attribute11,
  attribute12,
  attribute13,
  attribute14,
  attribute15,
  creation_date,
  created_by,
  last_update_date,
  last_updated_by,
  last_update_login
  )
  VALUES
  (
  x_section_id,
  p_object_version_number,
  decode(p_access_name, FND_API.G_MISS_CHAR, NULL, p_access_name),
  p_start_date_active,
  decode(p_end_date_active, FND_API.G_MISS_DATE, NULL, p_end_date_active),
  p_section_type_code,
  p_status_code,
  decode(p_display_context_id, FND_API.G_MISS_NUM,NULL,p_display_context_id),
  decode(p_deliverable_id, FND_API.G_MISS_NUM, NULL, p_deliverable_id),
  decode(p_available_in_all_sites_flag, FND_API.G_MISS_CHAR, 'Y', NULL, 'Y',
         p_available_in_all_sites_flag),
  decode(p_auto_placement_rule, FND_API.G_MISS_CHAR, NULL,
         p_auto_placement_rule),
  decode(p_order_by_clause, FND_API.G_MISS_CHAR, NULL, p_order_by_clause),
  decode(p_attribute_category, FND_API.G_MISS_CHAR, NULL,p_attribute_category),
  decode(p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
  decode(p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
  decode(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
  decode(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
  decode(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
  decode(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
  decode(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
  decode(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
  decode(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
  decode(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
  decode(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
  decode(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
  decode(p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
  decode(p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
  decode(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),
  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: 228


  INSERT INTO ibe_dsp_sections_tl
  (
  last_update_login,
  display_name,
  description,
  long_description,
  keywords,
  last_updated_by,
  last_update_date,
  creation_date,
  section_id,
  object_version_number,
  created_by,
  language,
  source_lang
  )
  SELECT
    decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
           NULL, FND_GLOBAL.login_id, p_last_update_login),
    p_display_name,
    decode(p_description,FND_API.G_MISS_CHAR, NULL, p_description),
    decode(p_long_description, FND_API.G_MISS_CHAR, NULL, p_long_description),
    decode(p_keywords, FND_API.G_MISS_CHAR, NULL, p_keywords),
    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_date, FND_API.G_MISS_DATE, sysdate,
           NULL, sysdate, p_last_update_date),
    decode(p_creation_date, FND_API.G_MISS_DATE, sysdate,
           NULL, sysdate, p_creation_date),
    x_section_id,
    p_object_version_number,
    decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
           NULL, FND_GLOBAL.user_id, p_created_by),
    L.language_code,
    USERENV('LANG')
    FROM fnd_languages L
    WHERE L.installed_flag IN ('I', 'B')
    AND NOT EXISTS
    (SELECT NULL
    FROM ibe_dsp_sections_tl T
    WHERE T.section_id = x_section_id
    AND T.language = L.language_code);

Line: 280


END insert_row;

Line: 286


PROCEDURE update_row
  (
  p_section_id                          IN NUMBER,
  p_object_version_number               IN NUMBER   := FND_API.G_MISS_NUM,
  p_access_name                         IN VARCHAR2,
  p_start_date_active                   IN DATE,
  p_end_date_active                     IN DATE,
  p_section_type_code                   IN VARCHAR2,
  p_status_code                         IN VARCHAR2,
  p_display_context_id                  IN NUMBER,
  p_deliverable_id                      IN NUMBER,
  p_available_in_all_sites_flag         IN VARCHAR2,
  p_auto_placement_rule                 IN VARCHAR2,
  p_order_by_clause                     IN VARCHAR2,
  p_attribute_category                  IN VARCHAR2,
  p_attribute1                          IN VARCHAR2,
  p_attribute2                          IN VARCHAR2,
  p_attribute3                          IN VARCHAR2,
  p_attribute4                          IN VARCHAR2,
  p_attribute5                          IN VARCHAR2,
  p_attribute6                          IN VARCHAR2,
  p_attribute7                          IN VARCHAR2,
  p_attribute8                          IN VARCHAR2,
  p_attribute9                          IN VARCHAR2,
  p_attribute10                         IN VARCHAR2,
  p_attribute11                         IN VARCHAR2,
  p_attribute12                         IN VARCHAR2,
  p_attribute13                         IN VARCHAR2,
  p_attribute14                         IN VARCHAR2,
  p_attribute15                         IN VARCHAR2,
  p_display_name                        IN VARCHAR2,
  p_description                         IN VARCHAR2,
  p_long_description                    IN VARCHAR2,
  p_keywords                            IN VARCHAR2,
  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_sections_b SET
  object_version_number = object_version_number + 1,
  access_name = decode(p_access_name, FND_API.G_MISS_CHAR,
                       access_name, p_access_name),
  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),
  section_type_code = decode(p_section_type_code, FND_API.G_MISS_CHAR,
                             section_type_code, p_section_type_code),
  status_code = decode(p_status_code, FND_API.G_MISS_CHAR,
                       status_code, p_status_code),
  display_context_id = decode(p_display_context_id, FND_API.G_MISS_NUM,
                              display_context_id, p_display_context_id),
  deliverable_id = decode(p_deliverable_id, FND_API.G_MISS_NUM,
                          deliverable_id, p_deliverable_id),
  available_in_all_sites_flag =
    decode(p_available_in_all_sites_flag, FND_API.G_MISS_CHAR,
           available_in_all_sites_flag, p_available_in_all_sites_flag),
  auto_placement_rule = decode(p_auto_placement_rule, FND_API.G_MISS_CHAR,
                               auto_placement_rule, p_auto_placement_rule),
  order_by_clause = decode(p_order_by_clause, FND_API.G_MISS_CHAR,
                           order_by_clause, p_order_by_clause),
  attribute_category = decode(p_attribute_category, FND_API.G_MISS_CHAR,
                              attribute_category, p_attribute_category),
  attribute1 = decode(p_attribute1, FND_API.G_MISS_CHAR,
                      attribute1, p_attribute1),
  attribute2 = decode(p_attribute2, FND_API.G_MISS_CHAR,
                      attribute2, p_attribute2),
  attribute3 = decode(p_attribute3, FND_API.G_MISS_CHAR,
                      attribute3, p_attribute3),
  attribute4 = decode(p_attribute4, FND_API.G_MISS_CHAR,
                      attribute4, p_attribute4),
  attribute5 = decode(p_attribute5, FND_API.G_MISS_CHAR,
                      attribute5, p_attribute5),
  attribute6 = decode(p_attribute6, FND_API.G_MISS_CHAR,
                      attribute6, p_attribute6),
  attribute7 = decode(p_attribute7, FND_API.G_MISS_CHAR,
                      attribute7, p_attribute7),
  attribute8 = decode(p_attribute8, FND_API.G_MISS_CHAR,
                      attribute8, p_attribute8),
  attribute9 = decode(p_attribute9, FND_API.G_MISS_CHAR,
                      attribute9, p_attribute9),
  attribute10 = decode(p_attribute10, FND_API.G_MISS_CHAR,
                      attribute10, p_attribute10),
  attribute11 = decode(p_attribute11, FND_API.G_MISS_CHAR,
                      attribute11, p_attribute11),
  attribute12 = decode(p_attribute12, FND_API.G_MISS_CHAR,
                      attribute12, p_attribute12),
  attribute13 = decode(p_attribute13, FND_API.G_MISS_CHAR,
                      attribute13, p_attribute13),
  attribute14 = decode(p_attribute14, FND_API.G_MISS_CHAR,
                      attribute14, p_attribute14),
  attribute15 = decode(p_attribute15, FND_API.G_MISS_CHAR,
                      attribute15, p_attribute15),
  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 section_id = p_section_id
    AND object_version_number = decode(p_object_version_number,
                                       FND_API.G_MISS_NUM,
                                       object_version_number,
                                       p_object_version_number);

Line: 402


  UPDATE ibe_dsp_sections_tl SET
    object_version_number = object_version_number + 1,
    display_name = decode(p_display_name, FND_API.G_MISS_CHAR,
                          display_name, p_display_name),
    description = decode(p_description, FND_API.G_MISS_CHAR,
                         description, p_description),
    long_description = decode(p_long_description, FND_API.G_MISS_CHAR,
                              long_description, p_long_description),
    keywords = decode(p_keywords, FND_API.G_MISS_CHAR, keywords, p_keywords),
    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),
    source_lang = USERENV('LANG')
    WHERE section_id = p_section_id
    --    AND object_version_number = decode(p_object_version_number,
    --                                 FND_API.G_MISS_NUM,
    --                                 object_version_number,
    --                                 p_object_version_number)
    AND USERENV('LANG') IN (language, source_lang);

Line: 431


END update_row;

Line: 437


PROCEDURE delete_row
  (
   p_section_id IN NUMBER
  )
IS
BEGIN

  DELETE FROM ibe_dsp_sections_tl
  WHERE section_id = p_section_id;

Line: 451


  DELETE FROM ibe_dsp_sections_b
  WHERE section_id = p_section_id;

Line: 458


END delete_row;

Line: 498


   P_LAST_UPDATE_DATE                   IN varchar2,
   P_CUSTOM_MODE                        IN Varchar2
  )
IS
  l_user_id           NUMBER := 0;

Line: 507


  f_ludate  date;    -- entity update date in file

Line: 509


  db_ludate date;    -- entity update date in db

Line: 515


  f_ludate := nvl(to_date(P_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);

Line: 517


  select LAST_UPDATED_BY, LAST_UPDATE_DATE
   	into db_luby, db_ludate
  	from ibe_dsp_sections_b
   	where SECTION_ID = p_section_id;

Line: 530


     update_row
      (
      p_section_id                          => p_section_id,
      p_object_version_number               => p_object_version_number,
      p_access_name                         => p_access_name,
      p_start_date_active                   => p_start_date_active,
      p_end_date_active                     => p_end_date_active,
      p_section_type_code                   => p_section_type_code,
      p_status_code                         => p_status_code,
      p_display_context_id                  => p_display_context_id,
      p_deliverable_id                      => p_deliverable_id,
      p_available_in_all_sites_flag         => p_available_in_all_sites_flag,
      p_auto_placement_rule                 => p_auto_placement_rule,
      p_order_by_clause                     => p_order_by_clause,
      p_attribute_category                  => p_attribute_category,
      p_attribute1                          => p_attribute1,
      p_attribute2                          => p_attribute2,
      p_attribute3                          => p_attribute3,
      p_attribute4                          => p_attribute4,
      p_attribute5                          => p_attribute5,
      p_attribute6                          => p_attribute6,
      p_attribute7                          => p_attribute7,
      p_attribute8                          => p_attribute8,
      p_attribute9                          => p_attribute9,
      p_attribute10                         => p_attribute10,
      p_attribute11                         => p_attribute11,
      p_attribute12                         => p_attribute12,
      p_attribute13                         => p_attribute13,
      p_attribute14                         => p_attribute14,
      p_attribute15                         => p_attribute15,
      p_display_name                        => p_display_name,
      p_description                         => p_description,
      p_long_description                    => p_long_description,
      p_keywords                            => p_keywords,
      p_last_update_date                    => f_ludate, --sysdate,
      p_last_updated_by                     => f_luby,--l_user_id,
      p_last_update_login                   => 0
      );

Line: 573


       insert_row
       (
       p_section_id                         => p_section_id,
       p_object_version_number              => l_object_version_number,
       p_access_name                        => p_access_name,
       p_start_date_active                  => p_start_date_active,
       p_end_date_active                    => p_end_date_active,
       p_section_type_code                  => p_section_type_code,
       p_status_code                        => p_status_code,
       p_display_context_id                 => p_display_context_id,
       p_deliverable_id                     => p_deliverable_id,
       p_available_in_all_sites_flag        => p_available_in_all_sites_flag,
       p_auto_placement_rule                => p_auto_placement_rule,
       p_order_by_clause                    => p_order_by_clause,
       p_attribute_category                 => p_attribute_category,
       p_attribute1                         => p_attribute1,
       p_attribute2                         => p_attribute2,
       p_attribute3                         => p_attribute3,
       p_attribute4                         => p_attribute4,
       p_attribute5                         => p_attribute5,
       p_attribute6                         => p_attribute6,
       p_attribute7                         => p_attribute7,
       p_attribute8                         => p_attribute8,
       p_attribute9                         => p_attribute9,
       p_attribute10                        => p_attribute10,
       p_attribute11                        => p_attribute11,
       p_attribute12                        => p_attribute12,
       p_attribute13                        => p_attribute13,
       p_attribute14                        => p_attribute14,
       p_attribute15                        => p_attribute15,
       p_display_name                       => p_display_name,
       p_description                        => p_description,
       p_long_description                   => p_long_description,
       p_keywords                           => p_keywords,
       p_creation_date                      => f_ludate, --sysdate,
       p_created_by                         => f_luby,--l_user_id,
       p_last_update_date                   => f_ludate, --sysdate,
       p_last_updated_by                    => f_luby,--l_user_id,
       p_last_update_login                  => 0,
       x_rowid                              => l_rowid,
       x_section_id                         => l_section_id
       );

Line: 669


  IS SELECT section_id
    FROM ibe_dsp_sections_b
    WHERE access_name = l_c_access_name;

Line: 859


  IS SELECT lookup_code FROM fnd_lookup_values
    WHERE lookup_type = 'IBE_SECTION_STATUS' AND
    lookup_code = l_c_status_code AND
    language = USERENV('LANG');

Line: 956


      'SELECT rowid FROM mtl_system_items_vl WHERE rownum < 1 '
      || ' ORDER BY ' || p_order_by_clause,
      x_return_status
      );

Line: 997


      SELECT context_id INTO l_display_context_id FROM ibe_dsp_context_b
        WHERE context_id = p_display_context_id;

Line: 1023


      SELECT item_id INTO l_deliverable_id FROM jtf_amv_items_b
        WHERE item_id = p_deliverable_id;

Line: 1047


    SELECT lookup_code INTO l_tmp_str FROM fnd_lookup_values
      WHERE lookup_type = 'IBE_SECTION_TYPE' AND
            lookup_code = p_section_type_code AND
            language = USERENV('LANG');

Line: 1123


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_section_id                     IN NUMBER,
   p_object_version_number          IN NUMBER,
   p_access_name                    IN VARCHAR2,
   p_start_date_active              IN DATE,
   p_end_date_active                IN DATE,
   p_section_type_code              IN VARCHAR2,
   p_status_code                    IN VARCHAR2,
   p_display_context_id             IN NUMBER,
   p_deliverable_id                 IN NUMBER,
   p_available_in_all_sites_flag    IN VARCHAR2,
   p_auto_placement_rule            IN VARCHAR2,
   p_order_by_clause                IN VARCHAR2,
   p_display_name                   IN VARCHAR2,
   p_description                    IN VARCHAR2,
   p_long_description               IN VARCHAR2,
   p_keywords                       IN VARCHAR2,
   p_attribute_category             IN VARCHAR2,
   p_attribute1                     IN VARCHAR2,
   p_attribute2                     IN VARCHAR2,
   p_attribute3                     IN VARCHAR2,
   p_attribute4                     IN VARCHAR2,
   p_attribute5                     IN VARCHAR2,
   p_attribute6                     IN VARCHAR2,
   p_attribute7                     IN VARCHAR2,
   p_attribute8                     IN VARCHAR2,
   p_attribute9                     IN VARCHAR2,
   p_attribute10                    IN VARCHAR2,
   p_attribute11                    IN VARCHAR2,
   p_attribute12                    IN VARCHAR2,
   p_attribute13                    IN VARCHAR2,
   p_attribute14                    IN VARCHAR2,
   p_attribute15                    IN VARCHAR2,
   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: 1176


  IS SELECT lookup_code FROM fnd_lookup_values
    WHERE lookup_type = 'IBE_SECTION_STATUS' AND
    lookup_code = l_c_status_code AND
    language = USERENV('LANG');

Line: 1269


      'SELECT rowid FROM mtl_system_items_vl WHERE rownum < 1 '
      || ' ORDER BY ' || p_order_by_clause,
      x_return_status
      );

Line: 1311


      SELECT context_id INTO l_display_context_id FROM ibe_dsp_context_b
        WHERE context_id = p_display_context_id;

Line: 1337


      SELECT item_id INTO l_deliverable_id FROM jtf_amv_items_b
        WHERE item_id = p_deliverable_id;

Line: 1362


      SELECT lookup_code INTO l_tmp_str FROM fnd_lookup_values
        WHERE lookup_type = 'IBE_SECTION_TYPE' AND
              lookup_code = p_section_type_code AND
              language = USERENV('LANG');

Line: 1432


END Validate_Update;

Line: 1571


    insert_row
      (
      FND_API.G_MISS_NUM,
      l_object_version_number,
      p_access_name,
      p_start_date_active,
      p_end_date_active,
      p_section_type_code,
      p_status_code,
      p_display_context_id,
      p_deliverable_id,
      p_available_in_all_sites_flag,
      p_auto_placement_rule,
      p_order_by_clause,
      p_attribute_category,
      p_attribute1,
      p_attribute2,
      p_attribute3,
      p_attribute4,
      p_attribute5,
      p_attribute6,
      p_attribute7,
      p_attribute8,
      p_attribute9,
      p_attribute10,
      p_attribute11,
      p_attribute12,
      p_attribute13,
      p_attribute14,
      p_attribute15,
      p_display_name,
      p_description,
      p_long_description,
      p_keywords,
      SYSDATE,
      FND_GLOBAL.user_id,
      SYSDATE,
      FND_GLOBAL.user_id,
      FND_GLOBAL.login_id,
      l_rowid,
      x_section_id
      );

Line: 1615


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

Line: 1625


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

Line: 1681


PROCEDURE Update_Section
  (
   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_section_id                     IN NUMBER   := FND_API.G_MISS_NUM,
   p_object_version_number          IN NUMBER,
   p_access_name                    IN VARCHAR2 := FND_API.G_MISS_CHAR,
   p_start_date_active              IN DATE     := FND_API.G_MISS_DATE,
   p_end_date_active                IN DATE     := FND_API.G_MISS_DATE,
   p_section_type_code              IN VARCHAR2 := FND_API.G_MISS_CHAR,
   p_status_code                    IN VARCHAR2 := FND_API.G_MISS_CHAR,
   p_display_context_id             IN NUMBER   := FND_API.G_MISS_NUM,
   p_deliverable_id                 IN NUMBER   := FND_API.G_MISS_NUM,
   p_available_in_all_sites_flag    IN VARCHAR2 := FND_API.G_MISS_CHAR,
   p_auto_placement_rule            IN VARCHAR2 := FND_API.G_MISS_CHAR,
   p_order_by_clause                IN VARCHAR2 := FND_API.G_MISS_CHAR,
   p_display_name                   IN VARCHAR2 := FND_API.G_MISS_CHAR,
   p_description                    IN VARCHAR2 := FND_API.G_MISS_CHAR,
   p_long_description               IN VARCHAR2 := FND_API.G_MISS_CHAR,
   p_keywords                       IN VARCHAR2 := FND_API.G_MISS_CHAR,
   p_attribute_category             IN VARCHAR2 := FND_API.G_MISS_CHAR,
   p_attribute1                     IN VARCHAR2 := FND_API.G_MISS_CHAR,
   p_attribute2                     IN VARCHAR2 := FND_API.G_MISS_CHAR,
   p_attribute3                     IN VARCHAR2 := FND_API.G_MISS_CHAR,
   p_attribute4                     IN VARCHAR2 := FND_API.G_MISS_CHAR,
   p_attribute5                     IN VARCHAR2 := FND_API.G_MISS_CHAR,
   p_attribute6                     IN VARCHAR2 := FND_API.G_MISS_CHAR,
   p_attribute7                     IN VARCHAR2 := FND_API.G_MISS_CHAR,
   p_attribute8                     IN VARCHAR2 := FND_API.G_MISS_CHAR,
   p_attribute9                     IN VARCHAR2 := FND_API.G_MISS_CHAR,
   p_attribute10                    IN VARCHAR2 := FND_API.G_MISS_CHAR,
   p_attribute11                    IN VARCHAR2 := FND_API.G_MISS_CHAR,
   p_attribute12                    IN VARCHAR2 := FND_API.G_MISS_CHAR,
   p_attribute13                    IN VARCHAR2 := FND_API.G_MISS_CHAR,
   p_attribute14                    IN VARCHAR2 := FND_API.G_MISS_CHAR,
   p_attribute15                    IN VARCHAR2 := FND_API.G_MISS_CHAR,
   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_Section';

Line: 1735


  SAVEPOINT  UPDATE_SECTION_GRP;

Line: 1770


        SELECT section_id INTO l_section_id FROM ibe_dsp_sections_b
          WHERE access_name = p_access_name;

Line: 1801


  Validate_Update
    (
    p_init_msg_list                  => FND_API.G_FALSE,
    p_validation_level               => p_validation_level,
    p_section_id                     => l_section_id,
    p_object_version_number          => p_object_version_number,
    p_access_name                    => p_access_name,
    p_start_date_active              => p_start_date_active,
    p_end_date_active                => p_end_date_active,
    p_section_type_code              => p_section_type_code,
    p_status_code                    => p_status_code,
    p_display_context_id             => p_display_context_id,
    p_deliverable_id                 => p_deliverable_id,
    p_available_in_all_sites_flag    => p_available_in_all_sites_flag,
    p_auto_placement_rule            => p_auto_placement_rule,
    p_order_by_clause                => p_order_by_clause,
    p_attribute_category             => p_attribute_category,
    p_attribute1                     => p_attribute1,
    p_attribute2                     => p_attribute2,
    p_attribute3                     => p_attribute3,
    p_attribute4                     => p_attribute4,
    p_attribute5                     => p_attribute5,
    p_attribute6                     => p_attribute6,
    p_attribute7                     => p_attribute7,
    p_attribute8                     => p_attribute8,
    p_attribute9                     => p_attribute9,
    p_attribute10                    => p_attribute10,
    p_attribute11                    => p_attribute11,
    p_attribute12                    => p_attribute12,
    p_attribute13                    => p_attribute13,
    p_attribute14                    => p_attribute14,
    p_attribute15                    => p_attribute15,
    p_display_name                   => p_display_name,
    p_description                    => p_description,
    p_long_description               => p_long_description,
    p_keywords                       => p_keywords,
    x_return_status                  => l_return_status,
    x_msg_count                      => l_msg_count,
    x_msg_data                       => l_msg_data
    );

Line: 1852


    update_row
      (
      l_section_id,
      p_object_version_number,
      p_access_name,
      p_start_date_active,
      p_end_date_active,
      p_section_type_code,
      p_status_code,
      p_display_context_id,
      p_deliverable_id,
      p_available_in_all_sites_flag,
      p_auto_placement_rule,
      p_order_by_clause,
      p_attribute_category,
      p_attribute1,
      p_attribute2,
      p_attribute3,
      p_attribute4,
      p_attribute5,
      p_attribute6,
      p_attribute7,
      p_attribute8,
      p_attribute9,
      p_attribute10,
      p_attribute11,
      p_attribute12,
      p_attribute13,
      p_attribute14,
      p_attribute15,
      p_display_name,
      p_description,
      p_long_description,
      p_keywords,
      SYSDATE,
      FND_GLOBAL.user_id,
      FND_GLOBAL.login_id
      );

Line: 1892


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

Line: 1902


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

Line: 1923


     ROLLBACK TO UPDATE_SECTION_GRP;

Line: 1930


     ROLLBACK TO UPDATE_SECTION_GRP;

Line: 1937


     ROLLBACK TO UPDATE_SECTION_GRP;

Line: 1956


END Update_Section;

Line: 1958


PROCEDURE Delete_Section
  (
   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_section_id          IN NUMBER      := FND_API.G_MISS_NUM,
   p_access_name         IN VARCHAR2    := FND_API.G_MISS_CHAR,
   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_Section';

Line: 1978


    SELECT mini_site_section_section_id FROM ibe_dsp_msite_sct_sects
      WHERE child_section_id = l_c_child_section_id;

Line: 1982


    SELECT section_item_id FROM ibe_dsp_section_items
      WHERE section_id = l_c_section_id;

Line: 1986


      SELECT msite_id FROM ibe_msites_b
        WHERE msite_root_section_id = l_c_section_id and site_type = 'I';

Line: 1991


  SAVEPOINT  DELETE_SECTION_GRP;

Line: 2026


        SELECT section_id INTO l_section_id FROM ibe_dsp_sections_b
          WHERE access_name = p_access_name;

Line: 2072


    IBE_DSP_MSITE_SCT_SECT_PVT.Delete_MSite_Section_Section
      (
      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_mini_site_section_section_id => r1.mini_site_section_section_id,
      p_mini_site_id                 => FND_API.G_MISS_NUM,
      p_parent_section_id            => FND_API.G_MISS_NUM,
      p_child_section_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: 2098


    IBE_DSP_SECTION_ITEM_PVT.Delete_Section_Item
      (
      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_call_from_trigger            => FALSE,
      p_section_item_id              => r2.section_item_id,
      p_section_id                   => FND_API.G_MISS_NUM,
      p_inventory_item_id            => FND_API.G_MISS_NUM,
      p_organization_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: 2123


  IBE_PROD_RELATION_PVT.Section_Deleted
    (
    p_section_id => l_section_id
    );

Line: 2129


  IBE_LOGICALCONTENT_GRP.Delete_Section(l_section_id);

Line: 2132


  delete_row(l_section_id);

Line: 2137


     ROLLBACK TO DELETE_SECTION_GRP;

Line: 2144


     ROLLBACK TO DELETE_SECTION_GRP;

Line: 2151


     ROLLBACK TO DELETE_SECTION_GRP;

Line: 2170


END Delete_Section;

Line: 2172


PROCEDURE Update_Dsp_Context_To_Null
  (
   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_display_context_id             IN NUMBER,
   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_Dsp_Context_To_Null';

Line: 2192


  SAVEPOINT  UPDATE_DSP_CONTEXT_TO_NULL_GRP;

Line: 2217


  UPDATE ibe_dsp_sections_b
    SET display_context_id = NULL,
    object_version_number = object_version_number + 1
    WHERE display_context_id = p_display_context_id;

Line: 2238


     ROLLBACK TO UPDATE_DSP_CONTEXT_TO_NULL_GRP;

Line: 2245


     ROLLBACK TO UPDATE_DSP_CONTEXT_TO_NULL_GRP;

Line: 2252


     ROLLBACK TO UPDATE_DSP_CONTEXT_TO_NULL_GRP;

Line: 2271


END Update_Dsp_Context_To_Null;

Line: 2273


PROCEDURE Update_Deliverable_To_Null
  (
   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_deliverable_id                 IN NUMBER,
   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_Deliverable_To_Null';

Line: 2293


  SAVEPOINT  UPDATE_DELIVERABLE_TO_NULL_GRP;

Line: 2318


  UPDATE ibe_dsp_sections_b
    SET deliverable_id = NULL,
    object_version_number = object_version_number + 1
    WHERE deliverable_id = p_deliverable_id;

Line: 2339


     ROLLBACK TO UPDATE_DELIVERABLE_TO_NULL_GRP;

Line: 2346


     ROLLBACK TO UPDATE_DELIVERABLE_TO_NULL_GRP;

Line: 2353


     ROLLBACK TO UPDATE_DELIVERABLE_TO_NULL_GRP;

Line: 2372


END Update_Deliverable_To_Null;

Line: 2381


  delete from IBE_DSP_SECTIONS_TL T
  where not exists
    (select NULL
    from IBE_DSP_SECTIONS_B B
    where B.SECTION_ID = T.SECTION_ID
    );

Line: 2388


  update IBE_DSP_SECTIONS_TL T set (
      DISPLAY_NAME,
      DESCRIPTION,
      LONG_DESCRIPTION,
      KEYWORDS
    ) = (select
      B.DISPLAY_NAME,
      B.DESCRIPTION,
      B.LONG_DESCRIPTION,
      B.KEYWORDS
    from IBE_DSP_SECTIONS_TL B
    where B.SECTION_ID = T.SECTION_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.SECTION_ID,
      T.LANGUAGE
  ) in (select
      SUBT.SECTION_ID,
      SUBT.LANGUAGE
    from IBE_DSP_SECTIONS_TL SUBB, IBE_DSP_SECTIONS_TL SUBT
    where SUBB.SECTION_ID = SUBT.SECTION_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
      or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
      or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
      or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
      or SUBB.LONG_DESCRIPTION <> SUBT.LONG_DESCRIPTION
      or (SUBB.LONG_DESCRIPTION is null and SUBT.LONG_DESCRIPTION is not null)
      or (SUBB.LONG_DESCRIPTION is not null and SUBT.LONG_DESCRIPTION is null)
      or SUBB.KEYWORDS <> SUBT.KEYWORDS
      or (SUBB.KEYWORDS is null and SUBT.KEYWORDS is not null)
      or (SUBB.KEYWORDS is not null and SUBT.KEYWORDS is null)
  ));

Line: 2422


  insert into IBE_DSP_SECTIONS_TL (
    SECTION_ID,
    OBJECT_VERSION_NUMBER,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    DISPLAY_NAME,
    DESCRIPTION,
    LONG_DESCRIPTION,
    KEYWORDS,
    LANGUAGE,
    SOURCE_LANG
  ) select
    B.SECTION_ID,
    B.OBJECT_VERSION_NUMBER,
    B.CREATED_BY,
    B.CREATION_DATE,
    B.LAST_UPDATED_BY,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATE_LOGIN,
    B.DISPLAY_NAME,
    B.DESCRIPTION,
    B.LONG_DESCRIPTION,
    B.KEYWORDS,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from IBE_DSP_SECTIONS_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from IBE_DSP_SECTIONS_TL T
    where T.SECTION_ID = B.SECTION_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 2468


   P_LAST_UPDATE_DATE                   IN varchar2,
   P_CUSTOM_MODE                        IN Varchar2
  )
IS
 f_luby    number;  -- entity owner in file

Line: 2473


 f_ludate  date;    -- entity update date in file

Line: 2475


 db_ludate date;    -- entity update date in db

Line: 2479


  f_ludate := nvl(to_date(P_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);

Line: 2480


  select LAST_UPDATED_BY, LAST_UPDATE_DATE
   	into db_luby, db_ludate
  	from ibe_dsp_sections_tl
   	where SECTION_ID = p_section_id
	and language=userenv('LANG'); -- bug #5089259

Line: 2487


   UPDATE ibe_dsp_sections_tl SET
    section_id = p_section_id,
    display_name = p_display_name,
    description = p_description,
    long_description = p_long_description,
    keywords = p_keywords,
    last_update_date = f_ludate,--sysdate,
    last_updated_by = f_luby, --decode(X_OWNER, 'SEED', 1, 0),
    last_update_login = 0,
    source_lang = userenv('LANG')
    WHERE userenv('LANG') in (LANGUAGE, SOURCE_LANG) AND
    section_id = p_section_id;

Line: 2538


			P_LAST_UPDATE_DATE		IN VARCHAR2,
            P_CUSTOM_MODE           IN VARCHAR2,
   			P_UPLOAD_MODE           IN VARCHAR2
  )
IS
BEGIN
		IF (P_UPLOAD_MODE = 'NLS') then
		   TRANSLATE_ROW(
					P_SECTION_ID,
 					P_DISPLAY_NAME,
 					P_DESCRIPTION,
					P_LONG_DESCRIPTION,
					P_KEYWORDS,
 					p_OWNER,
 					P_LAST_UPDATE_DATE,
 					P_CUSTOM_MODE
					);

Line: 2590


                    P_LAST_UPDATE_DATE,
                    P_CUSTOM_MODE);