APPS.INV_ENI_ITEMS_STAR_PKG SQL Statements

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

Line: 70

      '    ENI_UPD_ASSGN.UPDATE_ASSGN_FLAG(              '||
      '       p_new_category_id   => :p_new_category_id  '||
      '    ,  p_old_category_id   => :p_old_category_id  '||
      '    ,  x_return_status     => :x_return_status    '||
      '    ,  x_msg_count         => :x_msg_count        '||
      '    ,  x_msg_data          => :x_msg_data   );    '||

Line: 83

      ENI_UPD_ASSGN.UPDATE_ASSGN_FLAG(
             p_new_category_id   => p_new_category_id
          ,  p_old_category_id   => p_old_category_id
          ,  x_return_status     => x_return_status
          ,  x_msg_count         => x_msg_count
          ,  x_msg_data          => x_msg_data   );

Line: 99

PROCEDURE Update_ENI_Staging_Table(
                  p_mode_flag         IN         VARCHAR2
                 ,p_category_set_id   IN         NUMBER
                 ,p_category_id       IN         NUMBER
                 ,p_language_code     IN         VARCHAR2
                 ,x_return_status     OUT NOCOPY VARCHAR2
                 ,x_msg_count         OUT NOCOPY NUMBER
                 ,x_msg_data          OUT NOCOPY VARCHAR2) IS
  ----------------------------------------------------------------------
  -- Start of comments
  --
  -- Procedure name  : Update_ENI_Staging_Table
  -- Type            : Public
  -- Pre-reqs        : None
  -- Requirement     : Bug 3134279 (11.5.10 Requirement)
  -- Functionality   : To insert data into eni_denorm_hrchy_stg so that
  --                   DBI team can use the same for denormalization
  -- Notes           :
  --
  -- History         :
  --    09-SEP-2003     Sridhar R       Creation
  --
  -- END OF comments
  ----------------------------------------------------------------------

  l_object_type  CONSTANT VARCHAR2(20) := 'CATEGORY_SET';

Line: 132

       '    ENI_DENORM_HRCHY.Insert_Into_Staging (         '||
       '       p_object_type     => :b_object_type         '||
       '      ,p_object_id       => :b_caregory_set_id     '||
       '      ,p_child_id        => :b_category_id         '||
       '      ,p_parent_id       => NULL                   '||
       '      ,p_mode_flag       => :b_mode_flag           '||
       '      ,p_language_code   => :b_language_code       '||
       '      ,x_return_status   => :b_return_status       '||
       '      ,x_msg_count       => :b_msg_count           '||
       '      ,x_msg_data        => :b_msg_data   );       '||

Line: 160

END Update_ENI_Staging_Table;