79: p_line_code IN VARCHAR2) IS
80: BEGIN
81: OPEN x_Revs FOR
82: select line_code, description, line_id 83: from wip_lines 84: where organization_id = p_Organization_Id
85: and line_code like (p_line_code)
86: order by line_code;
87: END GET_WIP_LINE;