495: RETURN x_contract_number;
496:
497: END contract_number;
498:
499: -- Return contract_line_number from oke_k_lines_full_v
500: -- given contract_line_id.
501:
502: FUNCTION contract_line_number(x_id number) RETURN varchar2 IS
503:
503:
504: x_contract_line_number varchar2(150) := NULL;
505: CURSOR c IS
506: SELECT line_number
507: FROM oke_k_lines_full_v
508: WHERE k_line_id = x_id;
509:
510: BEGIN
511: IF x_id IS NOT NULL THEN