APPS.ENG_CHANGE_BES_UTIL SQL Statements

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

Line: 24

        SELECT ec.change_mgmt_type_code
        FROM eng_engineering_changes ec
        WHERE ec.change_id = p_change_id ;

Line: 48

          SELECT ChangeCategory.BASE_CHANGE_MGMT_TYPE_CODE
          FROM ENG_ENGINEERING_CHANGES EngineeringChangeEO,
               ENG_CHANGE_ORDER_TYPES ChangeCategory
          WHERE  ChangeCategory.type_classification = 'CATEGORY'
          AND ChangeCategory.change_mgmt_type_code = EngineeringChangeEO.change_mgmt_type_code
          AND EngineeringChangeEO.change_id = p_change_id  ;

Line: 131

    l_param_list.DELETE;

Line: 187

    l_param_list.DELETE;

Line: 260

    l_param_list.DELETE;

Line: 307

    l_param_list.DELETE;

Line: 316

  PROCEDURE Raise_Update_Change_Event
  ( p_change_id                 IN   NUMBER
  )
  IS

    l_param_list                WF_PARAMETER_LIST_T := WF_PARAMETER_LIST_T();

Line: 348

    ( p_event_name    => ENG_CHANGE_BES_UTIL.G_CMBE_HEADER_UPDATE
     ,p_event_key     => p_change_id
     ,p_parameters    => l_param_list
     );

Line: 353

    l_param_list.DELETE;

Line: 359

  END Raise_Update_Change_Event ;