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

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

Line: 498


    INSERT INTO ego_cat_grp_templates
    (   template_id
      , catalog_group_id
      , created_by
      , creation_date
      , last_updated_by
      , last_update_date
    )
    VALUES
    (   p_Template_Id
      , x_catalog_group_id
      , p_user_id
      , sysdate
      , p_user_id
      , sysdate
    );

Line: 551


PROCEDURE Update_Catalog_Group
(  p_Catalog_Group_Id              IN  NUMBER     := NULL
 , p_Parent_Catalog_Group_Id       IN  NUMBER         := NULL
 , p_Description                   IN  VARCHAR2   := NULL
 , p_Item_Creation_Allowed_Flag    IN  VARCHAR2   := NULL
 , p_Start_Effective_Date      IN  DATE   := NULL
 , p_Inactive_date       IN  DATE   := NULL
 , p_Enabled_Flag                  IN  VARCHAR2   := NULL
 , p_Summary_Flag                  IN  VARCHAR2   := NULL
 , p_segment1        IN  VARCHAR2   := NULL
 , p_segment2        IN  VARCHAR2   := NULL
 , p_segment3        IN  VARCHAR2   := NULL
 , p_segment4        IN  VARCHAR2   := NULL
 , p_segment5        IN  VARCHAR2   := NULL
 , p_segment6        IN  VARCHAR2   := NULL
 , p_segment7        IN  VARCHAR2   := NULL
 , p_segment8        IN  VARCHAR2   := NULL
 , p_segment9        IN  VARCHAR2   := NULL
 , p_segment10         IN  VARCHAR2   := NULL
 , p_segment11         IN  VARCHAR2   := NULL
 , p_segment12         IN  VARCHAR2   := NULL
 , p_segment13         IN  VARCHAR2   := NULL
 , p_segment14         IN  VARCHAR2   := NULL
 , p_segment15         IN  VARCHAR2   := NULL
 , p_segment16         IN  VARCHAR2   := NULL
 , p_segment17         IN  VARCHAR2   := NULL
 , p_segment18         IN  VARCHAR2   := NULL
 , p_segment19         IN  VARCHAR2   := NULL
 , p_segment20           IN  VARCHAR2   := NULL
 , Attribute_category            IN  VARCHAR2   := NULL
 , Attribute1                    IN  VARCHAR2   := NULL
 , Attribute2                    IN  VARCHAR2   := NULL
 , Attribute3                    IN  VARCHAR2   := NULL
 , Attribute4                    IN  VARCHAR2   := NULL
 , Attribute5                    IN  VARCHAR2   := NULL
 , Attribute6                    IN  VARCHAR2   := NULL
 , Attribute7                    IN  VARCHAR2   := NULL
 , Attribute8                    IN  VARCHAR2   := NULL
 , Attribute9                    IN  VARCHAR2   := NULL
 , Attribute10                   IN  VARCHAR2   := NULL
 , Attribute11                   IN  VARCHAR2   := NULL
 , Attribute12                   IN  VARCHAR2   := NULL
 , Attribute13                   IN  VARCHAR2   := NULL
 , Attribute14                   IN  VARCHAR2   := NULL
 , Attribute15                   IN  VARCHAR2   := NULL
 , p_Template_Id                   IN  NUMBER
 , p_User_id               IN  NUMBER
 , x_Return_Status                 OUT NOCOPY VARCHAR2
 , x_msg_count         OUT NOCOPY NUMBER
 , x_msg_data                      OUT NOCOPY VARCHAR2
 , p_debug                       IN  VARCHAR2 := 'N'
 , p_output_dir                  IN  VARCHAR2 := NULL
 , p_debug_filename              IN  VARCHAR2 := 'Ego_Catalog_Grp.log'
 , x_catalog_group_id              OUT NOCOPY NUMBER
 , x_catalog_group_name            OUT NOCOPY VARCHAR2
)

IS
  l_entity_index             number;

Line: 647


        , p_Transaction_Type           => 'UPDATE'
        , x_return_status              => x_return_status
        , x_msg_count                  => x_msg_count
  , p_debug                      => p_debug
        , p_output_dir                 => p_output_dir
        , p_debug_filename             => p_debug_filename
        , x_catalog_group_id           => x_catalog_group_id
        , x_catalog_group_name         => x_catalog_group_name
       );

Line: 661


    SELECT 'x' INTO v_dummy
    FROM ego_cat_grp_templates
    WHERE catalog_group_id = x_catalog_group_id;

Line: 668


      UPDATE ego_cat_grp_templates
      SET template_id = p_Template_Id
      WHERE catalog_group_id = x_catalog_group_id;

Line: 675


      DELETE FROM ego_cat_grp_templates
      WHERE catalog_group_id = x_catalog_group_id;

Line: 691


      x_msg_data := 'Executing - EGO_ITEM_CATALOG_PUB.UPDATE_CATALOG_GROUP '||l_message_list;

Line: 701


        INSERT INTO ego_cat_grp_templates
        (   template_id
          , catalog_group_id
          , created_by
          , creation_date
          , last_updated_by
          , last_update_date
        )
        VALUES
        (   p_Template_Id
          , x_catalog_group_id
          , p_user_id
          , sysdate
          , p_user_id
          , sysdate
        );

Line: 738


      x_msg_data := 'Executing - EGO_ITEM_CATALOG_PUB.UPDATE_CATALOG_GROUP '||l_message_list;

Line: 740


END UPDATE_CATALOG_GROUP;

Line: 746


PROCEDURE Check_Delete_AttrGroup_Assoc
(
    p_api_version                   IN      NUMBER
   ,p_association_id                IN      NUMBER
   ,p_classification_code           IN      VARCHAR2
   ,p_data_level                    IN      VARCHAR2
   ,p_attr_group_id                 IN      NUMBER
   ,p_application_id                IN      NUMBER
   ,p_attr_group_type               IN      VARCHAR2
   ,p_attr_group_name               IN      VARCHAR2
   ,p_enabled_code                  IN      VARCHAR2
   ,p_init_msg_list                 IN      VARCHAR2   := fnd_api.g_FALSE
   ,x_ok_to_delete                  OUT     NOCOPY VARCHAR2
   ,x_return_status                 OUT     NOCOPY VARCHAR2
   ,x_errorcode                     OUT     NOCOPY NUMBER
   ,x_msg_count                     OUT     NOCOPY NUMBER
   ,x_msg_data                      OUT     NOCOPY VARCHAR2
)
IS

    l_api_version           CONSTANT NUMBER           := 1.0;

Line: 768


    l_api_name              CONSTANT VARCHAR2(30)     := 'Check_Delete_AttrGroup_Assoc';

Line: 793


    SELECT
      attr_group_disp_name INTO l_attr_display_name
    FROM
      ego_obj_attr_grp_assocs_v
    WHERE association_id =  p_association_id;

Line: 802


    SELECT COUNT(*) INTO l_count
      FROM EGO_PAGE_ENTRIES_B A,
                  FND_OBJECTS B ,
                  EGO_OBJ_ATTR_GRP_ASSOCS_V C
    WHERE C.ASSOCIATION_ID =  A.ASSOCIATION_ID
         AND A.ASSOCIATION_ID = p_association_id
         AND C.OBJECT_ID =  B.OBJECT_ID
         AND B.OBJ_NAME = 'EGO_ITEM' ;

Line: 813


      x_ok_to_delete := FND_API.G_FALSE;

Line: 828


      l_dynamic_sql :=  'SELECT COUNT (*) '||
                        'FROM AK_CRITERIA cols , '||
                        '     EGO_CRITERIA_TEMPLATES_V criterions '||
                        'WHERE cols.customization_code = criterions.customization_code '||
                        ' AND ( criterions.classification1 IN ( SELECT item_catalog_group_id '||
                        '              FROM mtl_item_catalog_groups_b CONNECT BY PRIOR item_catalog_group_id = '||
                        '              parent_catalog_group_id START WITH parent_catalog_group_id = :1 ) '||
                        '     OR criterions.classification1 = :2 ) '||
                        '  AND cols.attribute_code LIKE :3 '||
                        '  AND criterions.REGION_CODE LIKE ''EGO%'' '||
                        '  AND COLS.REGION_CODE = CRITERIONS.REGION_CODE ';

Line: 843


       x_ok_to_delete := FND_API.G_FALSE;

Line: 853


       l_dynamic_sql := 'SELECT COUNT(*) ' ||
                        'FROM AK_CUSTOM_REGION_ITEMS COLS, ' ||
                        '     EGO_RESULTS_FORMAT_V RF ' ||
                        'WHERE cols.customization_code = RF.customization_code ' ||
                        ' AND ( RF.classification1 IN ( SELECT item_catalog_group_id '||
                        '              FROM mtl_item_catalog_groups_b CONNECT BY PRIOR item_catalog_group_id = '||
                        '              parent_catalog_group_id START WITH parent_catalog_group_id = :1 ) '||
                        '     OR RF.classification1 = :2 ) '||
                        '  AND cols.attribute_code LIKE :3 '||
                        '  AND RF.REGION_CODE LIKE ''EGO%'' ' ||
                        '  AND COLS.REGION_CODE = RF.REGION_CODE ';

Line: 868


         x_ok_to_delete := FND_API.G_FALSE;

Line: 881


     SELECT VARIANT INTO l_variant_Behaviour
     FROM EGO_FND_DSC_FLX_CTX_EXT
     WHERE ATTR_GROUP_ID = p_attr_group_id;

Line: 894


       x_ok_to_delete := FND_API.G_FALSE;

Line: 912


      x_ok_to_delete := FND_API.G_TRUE;

Line: 916


      x_ok_to_delete := FND_API.G_FALSE;

Line: 924


END Check_Delete_AttrGroup_Assoc;

Line: 956


  cursor c is select
      PARENT_CATALOG_GROUP_ID,
      ITEM_CREATION_ALLOWED_FLAG,
      INACTIVE_DATE,
      SUMMARY_FLAG,
      ENABLED_FLAG,
      START_DATE_ACTIVE,
      END_DATE_ACTIVE,
      SEGMENT1,
      SEGMENT2,
      SEGMENT3,
      SEGMENT4,
      SEGMENT5,
      SEGMENT6,
      SEGMENT7,
      SEGMENT8,
      SEGMENT9,
      SEGMENT10,
      SEGMENT11,
      SEGMENT12,
      SEGMENT13,
      SEGMENT14,
      SEGMENT15,
      SEGMENT16,
      SEGMENT17,
      SEGMENT18,
      SEGMENT19,
      SEGMENT20,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      REQUEST_ID
    from MTL_ITEM_CATALOG_GROUPS_B
    where ITEM_CATALOG_GROUP_ID = p_item_catalog_group_id
    for update of ITEM_CATALOG_GROUP_ID nowait;

Line: 1006


  cursor c1 is select
      DESCRIPTION,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from MTL_ITEM_CATALOG_GROUPS_TL
    where ITEM_CATALOG_GROUP_ID = p_item_catalog_group_id
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of ITEM_CATALOG_GROUP_ID nowait;

Line: 1022


    fnd_message.set_name('FND', 'FORM_RECORD_DELETED');