157: stlocke 23-JAN-2001 115.33 Added procedure init-fndload.
158: stlocke 08-FEB-2001 115.34 Procedure init-fndload removed.
159: cnholmes 28-NOV-2001 115.35 Add iRecruitment to HRSM_OBJECT.
160: hsajja 17-JAN-2002 115.36 NLS fix: Changed per_shared_types to
161: per_shared_types_vl in function
162: DECODE_AVAILABILITY_STATUS
163: gsayers 05-FEB-2002 115.37 Added check to prevent '01/01/0001'-1
164: in init_forms.
165: gperry 08-FEB-2002 115.38 Fixed WWBUG 2110218.
1754: p_availability_status_id number) return varchar2 is
1755: --
1756: cursor csr_lookup is
1757: select shared_type_name
1758: from per_shared_types_vl
1759: where shared_type_id = p_availability_status_id;
1760: --
1761: v_meaning per_shared_types_vl.shared_type_name%TYPE := null;
1762: --
1757: select shared_type_name
1758: from per_shared_types_vl
1759: where shared_type_id = p_availability_status_id;
1760: --
1761: v_meaning per_shared_types_vl.shared_type_name%TYPE := null;
1762: --
1763: begin
1764: --
1765: -- Only open the cursor if the parameter is going to retrieve anything