APPS.PER_IN_PERSON_LEG_HOOK SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 114

 PROCEDURE check_unique_number_insert(
          p_per_information_category IN VARCHAR2
         ,p_business_group_id        IN NUMBER
         ,p_per_information4         IN VARCHAR2 DEFAULT NULL
         ,p_per_information8         IN VARCHAR2 DEFAULT NULL
         ,p_per_information9         IN VARCHAR2 DEFAULT NULL
         ,p_per_information10        IN VARCHAR2 DEFAULT NULL
         ,p_per_information11        IN VARCHAR2 DEFAULT NULL
         ,p_per_information12        IN VARCHAR2 DEFAULT NULL
         ,p_per_information13        IN VARCHAR2 DEFAULT NULL
        ) IS
BEGIN

NULL ;

Line: 129

END check_unique_number_insert;

Line: 164

PROCEDURE check_unique_number_update(
         p_effective_date           IN DATE
        ,p_per_information_category IN VARCHAR2
        ,p_person_id                IN NUMBER
        ,p_per_information4         IN VARCHAR2 DEFAULT NULL
        ,p_per_information8         IN VARCHAR2 DEFAULT NULL
        ,p_per_information9         IN VARCHAR2 DEFAULT NULL
        ,p_per_information10        IN VARCHAR2 DEFAULT NULL
        ,p_per_information11        IN VARCHAR2 DEFAULT NULL
        ,p_per_information12        IN VARCHAR2 DEFAULT NULL
        ,p_per_information13        IN VARCHAR2 DEFAULT NULL
        ) IS
BEGIN

NULL ;

Line: 180

END check_unique_number_update;

Line: 362

     SELECT NVL(org_information3,'Y') FROM hr_organization_information
     WHERE  organization_id = p_business_group_id
     AND    ORG_INFORMATION_CONTEXT = 'PER_IN_STAT_SETUP_DF';

Line: 409

       select decode( p_field,'PAN','per_information4'
                         ,'PF Number','per_information8'
                         ,'ESI Number','per_information9'
                         ,'Super Annuation Number','per_information10'
                         ,'Group Insurance Number','per_information11'
                         ,'Gratuity Number','per_information12'
                         ,'Pension Number','per_information13'
                         ,'PAN Reference Number','per_information14'
	                 ,'NSSN','per_information15') inf_column
        into l_inf_column  from dual;

Line: 425

   l_qry:=' SELECT count(1) from dual where exists(SELECT  1 FROM per_people_f '||
         '  WHERE business_group_id = '||p_business_group_id||
         '    AND per_information_category = ''IN'' '||
         '    AND (person_id <>'''|| p_person_id ||''' OR '''|| p_person_id||''' is null)'||
         '    AND '||l_inf_column||'='''||p_value||''') ';

Line: 756

   SELECT system_person_type
   FROM   per_person_types
   WHERE  business_group_id = p_business_group_id
   AND    person_type_id = p_person_type_id;

Line: 763

  SELECT ppt.system_person_type
    FROM per_person_type_usages_f pptu
        ,per_person_types   ppt
  WHERE  pptu.person_type_id  = ppt.person_type_id
    AND  pptu.person_id       = p_person_id
    AND  ppt.business_group_id = p_business_group_id
    AND  p_effective_date BETWEEN pptu.effective_start_date
    AND  pptu.effective_end_date;

Line: 1343

PROCEDURE check_in_person_insert
        (
         p_per_information_category IN VARCHAR2
        ,p_business_group_id        IN NUMBER
        ,p_person_type_id           IN NUMBER
        ,p_hire_date                IN DATE
        ,p_per_information4         IN VARCHAR2
        ,p_per_information5         IN VARCHAR2
        ,p_per_information6         IN VARCHAR2
        ,p_per_information7         IN VARCHAR2
        ,p_per_information8         IN VARCHAR2
        ,p_per_information9         IN VARCHAR2
        ,p_per_information10        IN VARCHAR2
        ,p_per_information11        IN VARCHAR2
        ,p_per_information12        IN VARCHAR2
        ,p_per_information13        IN VARCHAR2
        ,p_per_information14        IN VARCHAR2
        ,p_per_information15        IN VARCHAR2
        )

IS
   l_procedure    VARCHAR2(100);

Line: 1372

   l_procedure := g_package||'check_in_person_insert';

Line: 1432

END check_in_person_insert;

Line: 1474

PROCEDURE check_in_person_update
        (
         p_per_information_category IN VARCHAR2
        ,p_person_type_id           IN NUMBER
        ,p_person_id                IN NUMBER
        ,p_effective_date           IN DATE
        ,p_per_information4         IN VARCHAR2
        ,p_per_information5         IN VARCHAR2
        ,p_per_information6         IN VARCHAR2
        ,p_per_information7         IN VARCHAR2
        ,p_per_information8         IN VARCHAR2
        ,p_per_information9         IN VARCHAR2
        ,p_per_information10        IN VARCHAR2
        ,p_per_information11        IN VARCHAR2
        ,p_per_information12        IN VARCHAR2
        ,p_per_information13        IN VARCHAR2
        ,p_per_information14        IN VARCHAR2
        ,p_per_information15        IN VARCHAR2
        )


IS
       l_procedure               VARCHAR2(100);

Line: 1502

      SELECT per_information4
            ,per_information5
            ,per_information6
            ,per_information7
            ,per_information8
            ,per_information9
            ,per_information10
            ,per_information11
            ,per_information12
            ,per_information13
            ,per_information14
            ,per_information15
            ,business_group_id
      FROM  per_people_f
      WHERE p_effective_date BETWEEN effective_start_date
                             AND effective_end_date
      AND   person_id = p_person_id;

Line: 1535

   l_procedure := g_package||'check_in_person_update';

Line: 1661

END check_in_person_update;