The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE NAME: delete_row()
=============================================================================*/
PROCEDURE delete_row(
X_Schedule_Item_ID IN NUMBER
) IS
BEGIN
DELETE FROM chv_authorizations
WHERE reference_id = X_Schedule_Item_Id
AND reference_type = 'SCHEDULE_ITEMS' ;
END delete_row ;