unexpected result when the procedure ran.

Hi,

I have a procedure that runs as needed. However, there were instances that have unexpected result. I am having trouble to identify what may have caused it. Maybe it is a logical error or something. Below is the procedure.

create or replace PROCEDURE                PROC_USR_CHECK_BACKORDER

(

  P_HEADER_ID IN APPS.OE_ORDER_HEADERS_ALL.HEADER_ID%TYPE 

)

as

  V_HEADER_ID NUMBER;

  V_ORDER_NUMBER NUMBER;

  V_BACK_ORDER VARCHAR2(240);

  l_count_line number;

  l_new_line number;

  lot_number_flag number;

  manu_flag number;

  expiry_flag number;

  remaining_qty number;

 

  cursor boga2 is

   SELECT pick.header_id header_id