APPS.EGO_CATEGORY_SET_PUB SQL Statements

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

Line: 59

      '    ENI_DENORM_HRCHY.INSERT_INTO_STAGING                       '||
      '    (                                                         '||
      '      p_object_type         =>  :p_object_type                '||
      '   ,  p_object_id           =>  :p_cat_set_id                 '||
      '   ,  p_child_id            =>  :p_child_id                   '||
      '   ,  p_parent_id           =>  :p_parent_id                  '||
      '   ,  p_mode_flag           =>  :p_mode_flag                  '||
      '   ,  x_return_status       =>  :x_return_status              '||
      '   ,  x_msg_count           =>  :x_msg_count                  '||
      '   ,  x_msg_data            =>  :x_msg_data                   '||
      '   );                                                         '||

Line: 110

  select count(1) into l_exists
  from mtl_default_category_sets
  where functional_area_id = G_DBI_FUNCTIONAL_AREA_ID;

Line: 141

    SELECT category_set_id INTO l_DBI_category_set_id
    FROM
    (select * from mtl_default_category_sets
     where functional_area_id = EGO_CATEGORY_SET_PUB.G_DBI_FUNCTIONAL_AREA_ID
     and rownum = 1);

Line: 171

    select count(1) into l_exists
    from mtl_category_set_valid_cats
    where category_set_id = l_DBI_category_set_id
    and category_id = p_Category_Id;