One row of data exists for each combination of project_id and task number but it is throwing no data found error.
SELECT into throws error, but just a select with where clause is fetching one row of data.
Here is the procedure

`

   PROCEDURE GET_TASK_ID(P_TASK_NUMBER_IN IN VARCHAR2,
   P_PROJ_ID_IN NUMBER,
   P_TASK_ID_OUT OUT NUMBER) IS
   L_TASK_ID_OUT NUMBER;
   BEGIN
   G_PROC_NAME := 'GET_TASK_ID';
   G_ERR_LOCATION := '10';

   BEGIN
   SELECT TASK_ID INTO L_TASK_ID_OUT
   FROM PA_TASKS
   WHERE PROJECT_ID =P_PROJ_ID_IN
   AND TASK_NUMBER =P_TASK_NUMBER_IN
   AND CHARGEABLE_FLAG = 'Y';
   P_TASK_ID_OUT := L_TASK_ID_OUT;

I think the task_number has a new line character.

Replace and translate functions are not working for my scenario. any leads here please?