APPS.PER_GB_EXTRA_PERSON_CHECKS SQL Statements

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

Line: 51

   procedure update_gb_person_extra_info(P_PERSON_EXTRA_INFO_ID in NUMBER
                                       ,P_PEI_INFORMATION_CATEGORY in VARCHAR2
                                       ,P_PEI_INFORMATION1 in VARCHAR2
                                       ,P_PEI_INFORMATION2 in VARCHAR2
                                       ,P_PEI_INFORMATION3 in VARCHAR2
                                       ,P_PEI_INFORMATION4 in VARCHAR2
                                       ,P_PEI_INFORMATION5 in VARCHAR2
                                       ,P_PEI_INFORMATION6 in VARCHAR2
                                       ,P_PEI_INFORMATION7 in VARCHAR2
                                       ,P_PEI_INFORMATION8 in VARCHAR2
                                       ,P_PEI_INFORMATION9 in VARCHAR2
                                       ,P_PEI_INFORMATION10 in VARCHAR2) as
   begin
       -- Checks for School Workforce Census
       if p_pei_information_category = 'PQP_SCHOOL_WORKFORCE_CENSUS' then

           -- 1) If Qualified Teacher Status = Yes,
           --    then Qualified Teacher Status Date must be provided
           if p_pei_information1 = 'Y' and p_pei_information2 is null then
               fnd_message.set_name('PQP', 'PQP_230250_QTS_YES_FIELD_MAND');

Line: 93

   end update_gb_person_extra_info;