Restricting Absence Type LOV in Oracle Self Service

Oracle has given easy way to handle absence type LOV in SSHR.

Using Seeded package “HR_ABSENCE_RESTRICTED” we can achieve this by returning absence attendance type Id.

Below is sample code, where based on Responsibility how we can restrict absence types.

CREATE OR REPLACE PACKAGE BODY APPS.hr_absence_restricted

AS

   /* $Header: peabrest.pkb 120.0.12010000.4 2010/03/18 10:25:49 ghshanka noship $ */

   -- ----------------------------------------------------------------------------

   -- |----------------------< absences_restricted >--------------------------|

   -- Added by Sameer Patil

   -- ----------------------------------------------------------------------------

   --

   FUNCTION absences_restricted (selected_person_id   IN VARCHAR2,

                                 login_person_id      IN VARCHAR2)

      RETURN VARCHAR2

   IS

      l_count                 NUMBER;

      l_responsibility_name   VARCHAR2 (2000);

   BEGIN

      l_responsibility_name := fnd_profile.VALUE ('RESP_NAME'); -- added by Sameer Patil

      IF l_responsibility_name LIKE '%Employee%Self%'

      THEN

         --D.M ('After IF ');

         RETURN '2116’; -- Say '2116’ is Unpaid Leave

      ELSIF l_responsibility_name LIKE '%Manager%Self%'

      THEN

       RETURN ‘1019’; -- Say ‘1019’ is Unpaid Leave

      ELSE

         RETURN '-1';                                  -- do not return null..

      END IF;

   END absences_restricted;

--

END hr_absence_restricted;

/

"Team Work" More We Less Me.