The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT ec.change_mgmt_type_code
FROM eng_engineering_changes ec
WHERE ec.change_id = p_change_id ;
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 ;
l_param_list.DELETE;
l_param_list.DELETE;
l_param_list.DELETE;
l_param_list.DELETE;
PROCEDURE Raise_Update_Change_Event
( p_change_id IN NUMBER
)
IS
l_param_list WF_PARAMETER_LIST_T := WF_PARAMETER_LIST_T();
( p_event_name => ENG_CHANGE_BES_UTIL.G_CMBE_HEADER_UPDATE
,p_event_key => p_change_id
,p_parameters => l_param_list
);
l_param_list.DELETE;
END Raise_Update_Change_Event ;