483: CURSOR c_check_existence (v_un_number VARCHAR2) IS
484: SELECT 1
485: FROM sys.dual
486: WHERE EXISTS (SELECT 1
487: FROM po_un_numbers_tl
488: WHERE un_number = 'UN'||v_un_number);
489:
490: /* Cursor used to retrieve the next sequence number */
491: CURSOR c_get_seq IS