eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_ES_ABSENCE SQL Statements

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

Line: 26


    SELECT pivf.input_value_id  iv_start_date_id
    FROM   pay_input_values_f    pivf
          ,pay_element_entries_f peef
          ,pay_element_types_f   petf
    WHERE  peef.element_entry_id  = p_element_entry_id
    AND    peef.element_type_id   = petf.element_type_id
    AND    pivf.element_type_id   = petf.element_type_id
    AND    pivf.name              = p_input_value_name
    AND    p_date                  BETWEEN peef.effective_start_date
                                   AND     peef.effective_end_date
    AND    p_date                  BETWEEN petf.effective_start_date
                                   AND     petf.effective_end_date
    AND    p_date                  BETWEEN pivf.effective_start_date
                                   AND     pivf.effective_end_date;

Line: 113


                SELECT max(object_version_number) INTO l_ovn
                FROM   pay_element_entries_f
                WHERE  element_entry_id = l_element_entry_id;

Line: 121


                    pay_element_entry_api.update_element_entry
                         (p_validate                => FALSE
                         ,p_datetrack_update_mode   => 'CORRECTION'
                         ,p_effective_date          => l_effective_start_date
                         ,p_business_group_id       => p_business_group_id
                         ,p_element_entry_id        => l_element_entry_id
                         ,p_object_version_number   => l_ovn
                         ,p_input_value_id1         => l_start_date_iv_id
                         ,p_entry_value1            => fnd_date.date_to_displaydate(l_effective_start_date) --l_effective_start_date
                         ,p_input_value_id2         => l_end_date_iv_id
                         ,p_entry_value2            => fnd_date.date_to_displaydate(l_effective_end_date) --l_effective_end_date
                         ,p_input_value_id3         => l_absence_id
                         ,p_entry_value3            => p_absence_attendance_id
                         ,p_input_value_id4         => l_ptm_percentage_iv_id
                         ,p_entry_value4            => p_abs_information3
                         ,p_effective_start_date    => l_o_start_dt
                         ,p_effective_end_date      => l_o_end_dt
                         ,p_update_warning          => l_o_warning);

Line: 141


                    pay_element_entry_api.update_element_entry
                         (p_validate                => FALSE
                         ,p_datetrack_update_mode   => 'CORRECTION'
                         ,p_effective_date          => l_effective_start_date
                         ,p_business_group_id       => p_business_group_id
                         ,p_element_entry_id        => l_element_entry_id
                         ,p_object_version_number   => l_ovn
                         ,p_input_value_id1         => l_start_date_iv_id
                         ,p_entry_value1            => fnd_date.date_to_displaydate(l_effective_start_date) --l_effective_start_date
                         ,p_input_value_id2         => l_end_date_iv_id
                         ,p_entry_value2            => fnd_date.date_to_displaydate(l_effective_end_date) --l_effective_end_date
                         ,p_input_value_id3         => l_absence_id
                         ,p_entry_value3            => p_absence_attendance_id
                         ,p_effective_start_date    => l_o_start_dt
                         ,p_effective_end_date      => l_o_end_dt
                         ,p_update_warning          => l_o_warning);

Line: 172


PROCEDURE person_entry_update(p_absence_attendance_id        IN NUMBER
                             ,p_date_start                   IN DATE
                             ,p_date_end                     IN DATE
                             ,p_abs_information_category     IN VARCHAR2
                             ,p_abs_information1             IN VARCHAR2
                             ,p_abs_information2             IN VARCHAR2
                             ,p_abs_information3             IN VARCHAR2
                             ,p_abs_information4             IN VARCHAR2
                             ,p_abs_information5             IN VARCHAR2
                             ,p_abs_information6             IN VARCHAR2
                             ,p_abs_information7             IN VARCHAR2
                             ,p_abs_information8             IN VARCHAR2
                             ,p_abs_information9             IN VARCHAR2
                             ,p_abs_information10            IN VARCHAR2) IS


    --
    CURSOR csr_get_input_value_info(p_element_entry_id NUMBER
                                   ,p_input_value_name VARCHAR2
                                   ,p_date             DATE) IS
    SELECT pivf.input_value_id  iv_start_date_id
    FROM   pay_input_values_f    pivf
          ,pay_element_entries_f peef
          ,pay_element_types_f   petf
    WHERE  peef.element_entry_id  = p_element_entry_id
    AND    peef.element_type_id   = petf.element_type_id
    AND    pivf.element_type_id   = petf.element_type_id
    AND    pivf.name              = p_input_value_name
    AND    p_date                  BETWEEN peef.effective_start_date
                                   AND     peef.effective_end_date
    AND    p_date                  BETWEEN petf.effective_start_date
                                   AND     petf.effective_end_date
    AND    p_date                  BETWEEN pivf.effective_start_date
                                   AND     pivf.effective_end_date;

Line: 234


            hr_utility.set_location(' IN Update User hook ',20);

Line: 277


                SELECT max(object_version_number) INTO l_ovn
                FROM   pay_element_entries_f
                WHERE  element_entry_id = l_element_entry_id;

Line: 281


                SELECT business_group_id INTO l_bus_grp_id
                FROM   per_absence_attendances
                WHERE  absence_attendance_id = p_absence_attendance_id;

Line: 290


                    pay_element_entry_api.update_element_entry
                         (p_validate                => FALSE
                         ,p_datetrack_update_mode   => 'CORRECTION'
                         ,p_effective_date          => l_effective_start_date
                         ,p_business_group_id       => l_bus_grp_id
                         ,p_element_entry_id        => l_element_entry_id
                         ,p_object_version_number   => l_ovn
                         ,p_input_value_id1         => l_start_date_iv_id
                         ,p_entry_value1            => fnd_date.date_to_displaydate(l_effective_start_date) --l_effective_start_date
                         ,p_input_value_id2         => l_end_date_iv_id
                         ,p_entry_value2            => fnd_date.date_to_displaydate(l_effective_end_date) --l_effective_end_date
                         ,p_input_value_id3         => l_absence_type_iv_id
                         ,p_entry_value3            => p_absence_attendance_id
                         ,p_input_value_id4         => l_ptm_percentage_iv_id
                         ,p_entry_value4            => p_abs_information3
                         ,p_effective_start_date    => l_o_start_dt
                         ,p_effective_end_date      => l_o_end_dt
                         ,p_update_warning          => l_o_warning);

Line: 309


                    pay_element_entry_api.update_element_entry
                         (p_validate                => FALSE
                         ,p_datetrack_update_mode   => 'CORRECTION'
                         ,p_effective_date          => l_effective_start_date
                         ,p_business_group_id       => l_bus_grp_id
                         ,p_element_entry_id        => l_element_entry_id
                         ,p_object_version_number   => l_ovn
                         ,p_input_value_id1         => l_start_date_iv_id
                         ,p_entry_value1            => fnd_date.date_to_displaydate(l_effective_start_date) --l_effective_start_date
                         ,p_input_value_id2         => l_end_date_iv_id
                         ,p_entry_value2            => fnd_date.date_to_displaydate(l_effective_end_date) --l_effective_end_date
                         ,p_input_value_id3         => l_absence_type_iv_id
                         ,p_entry_value3            => p_absence_attendance_id
                         ,p_effective_start_date    => l_o_start_dt
                         ,p_effective_end_date      => l_o_end_dt
                         ,p_update_warning          => l_o_warning);

Line: 334


  hr_utility.set_location('Leaving hook Person_entry_Update',90);

Line: 336


END person_entry_update;

Line: 360


    SELECT absence_category
    FROM   per_absence_attendance_types
    WHERE  absence_attendance_type_id = p_absence_attendance_type_id;

Line: 367


    SELECT PAAT.absence_category
    FROM   per_absence_attendances      PAA
          ,per_absence_attendance_types PAAT
    WHERE  PAA.person_id                   = p_person_id
    AND    PAAT.absence_attendance_type_id = PAA.absence_attendance_type_id
    AND    (( p_date_start             BETWEEN  PAA.date_start
                                      AND      NVL(PAA.date_end,to_date('31-12-4712','DD-MM-YYYY')))
    OR     (PAA.date_start             BETWEEN  p_date_start
                                      AND      NVL(p_date_end,to_date('31-12-4712','DD-MM-YYYY'))));

Line: 379


    SELECT nvl(to_number(max(PAA.date_end) - max(PAA.date_start)+1),0)
    FROM   per_absence_attendances      PAA
          ,per_absence_attendance_types PAAT
    WHERE  PAA.person_id                   = p_person_id
    AND    PAAT.absence_attendance_type_id = PAA.absence_attendance_type_id
    AND    PAAT.absence_category           = 'M'
    AND    p_date_start                    = PAA.date_end + 1 ;

Line: 390


    SELECT ppf.sex
    FROM   per_people_f ppf
    WHERE  ppf.person_id = p_person_id ;

Line: 580


PROCEDURE validate_abs_update(p_absence_attendance_id        IN NUMBER
                             ,p_date_start                   IN DATE
                             ,p_time_start                   IN VARCHAR2
                             ,p_date_end                     IN DATE
                             ,p_time_end                     IN VARCHAR2
                             ,p_abs_information_category     IN VARCHAR2
                             ,p_abs_information1             IN VARCHAR2
                             ,p_abs_information2             IN VARCHAR2
                             ,p_abs_information3             IN VARCHAR2
                             ,p_abs_information4             IN VARCHAR2
                             ,p_abs_information5             IN VARCHAR2
                             ,p_abs_information6             IN VARCHAR2
                             ,p_abs_information7             IN VARCHAR2
                             ,p_abs_information8             IN VARCHAR2
                             ,p_abs_information9             IN VARCHAR2
                             ,p_abs_information10            IN VARCHAR2) IS
    --
    CURSOR csr_get_absence_category(p_absence_attendance_id  NUMBER) IS
    SELECT paat.absence_category
    FROM   per_absence_attendance_types paat
          ,per_absence_attendances      paa
    WHERE  paa.absence_attendance_id       = p_absence_attendance_id
    AND    paat.absence_attendance_type_id = paa.absence_attendance_type_id;

Line: 607


    SELECT PAAT.absence_category
    FROM   per_absence_attendances      PAA1
          ,per_absence_attendances      PAA2
          ,per_absence_attendance_types PAAT
    WHERE  PAA1.absence_attendance_id      = p_absence_attendance_id
    AND    PAA2.person_id                  = PAA1.person_id
    AND    PAAT.absence_attendance_type_id = PAA2.absence_attendance_type_id
    AND    PAA1.absence_attendance_id      <> PAA2.absence_attendance_id
    AND    (( p_date_start            BETWEEN  PAA2.date_start
                                      AND      NVL(PAA2.date_end,to_date('31-12-4712','DD-MM-YYYY')))
    OR     (PAA2.date_start            BETWEEN  p_date_start
                                      AND      NVL(p_date_end,to_date('31-12-4712','DD-MM-YYYY'))));

Line: 622


    SELECT nvl(to_number(max(PAA2.date_end) - max(PAA2.date_start)+1),0)
    FROM   per_absence_attendances      PAA1
          ,per_absence_attendances      PAA2
          ,per_absence_attendance_types PAAT
    WHERE  PAA1.absence_attendance_id      = p_absence_attendance_id
    AND    PAA2.person_id                  = PAA1.person_id
    AND    PAAT.absence_attendance_type_id = PAA2.absence_attendance_type_id
    AND    PAA1.absence_attendance_id      <> PAA2.absence_attendance_id
    AND    PAAT.absence_category           = 'M'
    AND    p_date_start                    = PAA2.date_end + 1;

Line: 635


    SELECT person_id
    FROM   per_absence_attendances
    WHERE  absence_attendance_id =p_absence_attendance_id;

Line: 641


    SELECT ppf.sex
    FROM   per_people_f ppf
    WHERE  ppf.person_id = p_person_id ;

Line: 831


END validate_abs_update;