DBA Data[Home] [Help]

APPS.PER_HU_PERSON_EXTRA_INFO SQL Statements

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

Line: 96

 PROCEDURE UPDATE_HU_PERSON_EXTRA_INFO
  (p_person_extra_info_id          IN     NUMBER
  ,p_pei_information_category      IN     VARCHAR2
  ,p_pei_information3              IN     VARCHAR2
  ,p_pei_information4              IN     VARCHAR2
  ) IS
BEGIN
  --
  -- Added for GSI Bug 5472781
  --
  IF hr_utility.chk_product_install('Oracle Human Resources', 'HU') THEN
    --
    IF p_pei_information_category='HU_DRIVING_LICENSE' THEN
        per_hu_person_extra_info.chk_dl_date(p_pei_information3 => p_pei_information3
                                         ,p_pei_information4 => p_pei_information4);
Line: 125

END update_hu_person_extra_info;