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_PER_SHD SQL Statements

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

Line: 99


    select
   person_id,
   effective_start_date,
   effective_end_date,
   business_group_id,
   person_type_id,
   last_name,
   start_date,
   applicant_number,
   comment_id,
   null,
   current_applicant_flag,
   current_emp_or_apl_flag,
   current_employee_flag,
   date_employee_data_verified,
   date_of_birth,
   email_address,
   employee_number,
   expense_check_send_to_address,
   first_name,
   full_name,
   known_as,
   marital_status,
   middle_names,
   nationality,
   national_identifier,
   previous_last_name,
   registered_disabled_flag,
   sex,
   title,
   vendor_id,
   work_telephone,
   request_id,
   program_application_id,
   program_id,
   program_update_date,
   attribute_category,
   attribute1,
   attribute2,
   attribute3,
   attribute4,
   attribute5,
   attribute6,
   attribute7,
   attribute8,
   attribute9,
   attribute10,
   attribute11,
   attribute12,
   attribute13,
   attribute14,
   attribute15,
   attribute16,
   attribute17,
   attribute18,
   attribute19,
   attribute20,
   attribute21,
   attribute22,
   attribute23,
   attribute24,
   attribute25,
   attribute26,
   attribute27,
   attribute28,
   attribute29,
   attribute30,
   per_information_category,
   per_information1,
   per_information2,
   per_information3,
   per_information4,
   per_information5,
   per_information6,
   per_information7,
   per_information8,
   per_information9,
   per_information10,
   per_information11,
   per_information12,
   per_information13,
   per_information14,
   per_information15,
   per_information16,
   per_information17,
   per_information18,
   per_information19,
   per_information20,
   object_version_number,
        suffix,
        DATE_OF_DEATH                ,
        BACKGROUND_CHECK_STATUS      ,
        BACKGROUND_DATE_CHECK        ,
        BLOOD_TYPE                   ,
        CORRESPONDENCE_LANGUAGE      ,
        FAST_PATH_EMPLOYEE           ,
        FTE_CAPACITY                 ,
        HOLD_APPLICANT_DATE_UNTIL    ,
        HONORS                       ,
        INTERNAL_LOCATION            ,
        LAST_MEDICAL_TEST_BY         ,
        LAST_MEDICAL_TEST_DATE       ,
        MAILSTOP                     ,
        OFFICE_NUMBER                ,
        ON_MILITARY_SERVICE          ,
        ORDER_NAME                   ,
        PRE_NAME_ADJUNCT             ,
        PROJECTED_START_DATE         ,
        REHIRE_AUTHORIZOR            ,
        REHIRE_RECOMMENDATION        ,
        RESUME_EXISTS                ,
        RESUME_LAST_UPDATED          ,
        SECOND_PASSPORT_EXISTS       ,
        STUDENT_STATUS               ,
        WORK_SCHEDULE                ,
        PER_INFORMATION21            ,
        PER_INFORMATION22            ,
        PER_INFORMATION23            ,
        PER_INFORMATION24            ,
        PER_INFORMATION25            ,
        PER_INFORMATION26            ,
        PER_INFORMATION27            ,
        PER_INFORMATION28            ,
        PER_INFORMATION29            ,
        PER_INFORMATION30            ,
        REHIRE_REASON                ,
        BENEFIT_GROUP_ID             ,
        RECEIPT_OF_DEATH_CERT_DATE   ,
        COORD_BEN_MED_PLN_NO         ,
        COORD_BEN_NO_CVG_FLAG        ,
        COORD_BEN_MED_EXT_ER,
        COORD_BEN_MED_PL_NAME,
        COORD_BEN_MED_INSR_CRR_NAME,
        COORD_BEN_MED_INSR_CRR_IDENT,
        COORD_BEN_MED_CVG_STRT_DT,
        COORD_BEN_MED_CVG_END_DT,
        USES_TOBACCO_FLAG            ,
        DPDNT_ADOPTION_DATE          ,
        DPDNT_VLNTRY_SVCE_FLAG       ,
        ORIGINAL_DATE_OF_HIRE        ,
      town_of_birth                ,
        region_of_birth              ,
      country_of_birth             ,
        global_person_id,
        party_id,
        npw_number,
        current_npw_flag,
        global_name,
        local_name
    from per_all_people_f
    where   person_id = p_person_id
    and     p_effective_date
    between effective_start_date and effective_end_date;

Line: 316


    p_delete    out nocopy boolean,
    p_future_change out nocopy boolean,
    p_delete_next_change out nocopy boolean) is
--
  l_proc       varchar2(72)   := g_package||'find_dt_del_modes';

Line: 337


    p_delete      => p_delete,
    p_future_change  => p_future_change,
    p_delete_next_change   => p_delete_next_change);

Line: 351


    p_update    out nocopy boolean,
    p_update_override out nocopy boolean,
    p_update_change_insert out nocopy boolean) is
--
  l_proc    varchar2(72) := g_package||'find_dt_upd_modes';

Line: 368


    p_update      => p_update,
    p_update_override   => p_update_override,
    p_update_change_insert => p_update_change_insert);

Line: 407


  update  per_all_people_f t
  set   t.effective_end_date    = p_new_effective_end_date,
     t.object_version_number = l_object_version_number
  where    t.person_id    = p_base_key_value
  and   p_effective_date
  between t.effective_start_date and t.effective_end_date;

Line: 445


    select
   person_id,
   effective_start_date,
   effective_end_date,
   business_group_id,
   person_type_id,
   last_name,
   start_date,
   applicant_number,
   comment_id,
   null,
   current_applicant_flag,
   current_emp_or_apl_flag,
   current_employee_flag,
   date_employee_data_verified,
   date_of_birth,
   email_address,
   employee_number,
   expense_check_send_to_address,
   first_name,
   full_name,
   known_as,
   marital_status,
   middle_names,
   nationality,
   national_identifier,
   previous_last_name,
   registered_disabled_flag,
   sex,
   title,
   vendor_id,
   work_telephone,
   request_id,
   program_application_id,
   program_id,
   program_update_date,
   attribute_category,
   attribute1,
   attribute2,
   attribute3,
   attribute4,
   attribute5,
   attribute6,
   attribute7,
   attribute8,
   attribute9,
   attribute10,
   attribute11,
   attribute12,
   attribute13,
   attribute14,
   attribute15,
   attribute16,
   attribute17,
   attribute18,
   attribute19,
   attribute20,
   attribute21,
   attribute22,
   attribute23,
   attribute24,
   attribute25,
   attribute26,
   attribute27,
   attribute28,
   attribute29,
   attribute30,
   per_information_category,
   per_information1,
   per_information2,
   per_information3,
   per_information4,
   per_information5,
   per_information6,
   per_information7,
   per_information8,
   per_information9,
   per_information10,
   per_information11,
   per_information12,
   per_information13,
   per_information14,
   per_information15,
   per_information16,
   per_information17,
   per_information18,
   per_information19,
   per_information20,
   object_version_number,
        suffix,
        DATE_OF_DEATH                ,
        BACKGROUND_CHECK_STATUS      ,
        BACKGROUND_DATE_CHECK        ,
        BLOOD_TYPE                   ,
        CORRESPONDENCE_LANGUAGE      ,
        FAST_PATH_EMPLOYEE           ,
        FTE_CAPACITY                 ,
        HOLD_APPLICANT_DATE_UNTIL    ,
        HONORS                       ,
        INTERNAL_LOCATION            ,
        LAST_MEDICAL_TEST_BY         ,
        LAST_MEDICAL_TEST_DATE       ,
        MAILSTOP                     ,
        OFFICE_NUMBER                ,
        ON_MILITARY_SERVICE          ,
        ORDER_NAME                   ,
        PRE_NAME_ADJUNCT             ,
        PROJECTED_START_DATE         ,
        REHIRE_AUTHORIZOR            ,
        REHIRE_RECOMMENDATION        ,
        RESUME_EXISTS                ,
        RESUME_LAST_UPDATED          ,
        SECOND_PASSPORT_EXISTS       ,
        STUDENT_STATUS               ,
        WORK_SCHEDULE                ,
        PER_INFORMATION21            ,
        PER_INFORMATION22            ,
        PER_INFORMATION23            ,
        PER_INFORMATION24            ,
        PER_INFORMATION25            ,
        PER_INFORMATION26            ,
        PER_INFORMATION27            ,
        PER_INFORMATION28            ,
        PER_INFORMATION29            ,
        PER_INFORMATION30            ,
        REHIRE_REASON                ,
        BENEFIT_GROUP_ID             ,
        RECEIPT_OF_DEATH_CERT_DATE   ,
        COORD_BEN_MED_PLN_NO         ,
        COORD_BEN_NO_CVG_FLAG        ,
        COORD_BEN_MED_EXT_ER,
        COORD_BEN_MED_PL_NAME,
        COORD_BEN_MED_INSR_CRR_NAME,
        COORD_BEN_MED_INSR_CRR_IDENT,
        COORD_BEN_MED_CVG_STRT_DT,
        COORD_BEN_MED_CVG_END_DT,
        USES_TOBACCO_FLAG            ,
        DPDNT_ADOPTION_DATE          ,
        DPDNT_VLNTRY_SVCE_FLAG       ,
        ORIGINAL_DATE_OF_HIRE        ,
      town_of_birth                ,
        region_of_birth              ,
      country_of_birth             ,
        global_person_id             ,
        party_id,
        npw_number,
        current_npw_flag,
        global_name,
        local_name
    from    per_people_f
    where   person_id         = p_person_id
    and      p_effective_date
    between effective_start_date and effective_end_date
    for update nowait;

Line: 603


    select hc.comment_text
    from   hr_comments hc
    where  hc.comment_id = per_per_shd.g_old_rec.comment_id;

Line: 630


  If (p_datetrack_mode <> 'INSERT') then
    --
    -- We must select and lock the current row.
    --
    Open  C_Sel1;

Line: 655


        (p_datetrack_mode = 'UPDATE'                   or
         p_datetrack_mode = 'CORRECTION'               or
         p_datetrack_mode = 'UPDATE_OVERRIDE'          or
         p_datetrack_mode = 'UPDATE_CHANGE_INSERT')) then
      Open C_Sel3;

Line: 765


   p_program_update_date           in date,
   p_attribute_category            in varchar2,
   p_attribute1                    in varchar2,
   p_attribute2                    in varchar2,
   p_attribute3                    in varchar2,
   p_attribute4                    in varchar2,
   p_attribute5                    in varchar2,
   p_attribute6                    in varchar2,
   p_attribute7                    in varchar2,
   p_attribute8                    in varchar2,
   p_attribute9                    in varchar2,
   p_attribute10                   in varchar2,
   p_attribute11                   in varchar2,
   p_attribute12                   in varchar2,
   p_attribute13                   in varchar2,
   p_attribute14                   in varchar2,
   p_attribute15                   in varchar2,
   p_attribute16                   in varchar2,
   p_attribute17                   in varchar2,
   p_attribute18                   in varchar2,
   p_attribute19                   in varchar2,
   p_attribute20                   in varchar2,
   p_attribute21                   in varchar2,
   p_attribute22                   in varchar2,
   p_attribute23                   in varchar2,
   p_attribute24                   in varchar2,
   p_attribute25                   in varchar2,
   p_attribute26                   in varchar2,
   p_attribute27                   in varchar2,
   p_attribute28                   in varchar2,
   p_attribute29                   in varchar2,
   p_attribute30                   in varchar2,
   p_per_information_category      in varchar2,
   p_per_information1              in varchar2,
   p_per_information2              in varchar2,
   p_per_information3              in varchar2,
   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,
   p_per_information16             in varchar2,
   p_per_information17             in varchar2,
   p_per_information18             in varchar2,
   p_per_information19             in varchar2,
   p_per_information20             in varchar2,
   p_object_version_number         in number,
        p_suffix                        in varchar2,
        p_DATE_OF_DEATH                 in DATE,
        p_BACKGROUND_CHECK_STATUS       in varchar2,
        p_BACKGROUND_DATE_CHECK         in DATE,
        p_BLOOD_TYPE                    in varchar2,
        p_CORRESPONDENCE_LANGUAGE       in varchar2,
        p_FAST_PATH_EMPLOYEE            in varchar2,
        p_FTE_CAPACITY                  in NUMBER,
        p_HOLD_APPLICANT_DATE_UNTIL     in DATE,
        p_HONORS                        in varchar2,
        p_INTERNAL_LOCATION             in varchar2,
        p_LAST_MEDICAL_TEST_BY          in varchar2,
        p_LAST_MEDICAL_TEST_DATE        in DATE,
        p_MAILSTOP                      in varchar2,
        p_OFFICE_NUMBER                 in varchar2,
        p_ON_MILITARY_SERVICE           in varchar2,
        p_ORDER_NAME                    in varchar2,
        p_PRE_NAME_ADJUNCT              in varchar2,
        p_PROJECTED_START_DATE          in DATE,
        p_REHIRE_AUTHORIZOR             in varchar2,
        p_REHIRE_RECOMMENDATION         in varchar2,
        p_RESUME_EXISTS                 in varchar2,
        p_RESUME_LAST_UPDATED           in DATE,
        p_SECOND_PASSPORT_EXISTS        in varchar2,
        p_STUDENT_STATUS                in varchar2,
        p_WORK_SCHEDULE                 in varchar2,
        p_PER_INFORMATION21             in varchar2,
        p_PER_INFORMATION22             in varchar2,
        p_PER_INFORMATION23             in varchar2,
        p_PER_INFORMATION24             in varchar2,
        p_PER_INFORMATION25             in varchar2,
        p_PER_INFORMATION26             in varchar2,
        p_PER_INFORMATION27             in varchar2,
        p_PER_INFORMATION28             in varchar2,
        p_PER_INFORMATION29             in varchar2,
        p_PER_INFORMATION30             in varchar2,
        p_REHIRE_REASON                 in varchar2,
        p_BENEFIT_GROUP_ID              in number,
        p_RECEIPT_OF_DEATH_CERT_DATE    in DATE,
        p_COORD_BEN_MED_PLN_NO          in varchar2,
        p_COORD_BEN_NO_CVG_FLAG         in varchar2,
        p_coord_ben_med_ext_er          in varchar2,
        p_coord_ben_med_pl_name         in varchar2,
        p_coord_ben_med_insr_crr_name   in varchar2,
        p_coord_ben_med_insr_crr_ident  in varchar2,
        p_coord_ben_med_cvg_strt_dt     in date,
        p_coord_ben_med_cvg_end_dt      in date,
        p_USES_TOBACCO_FLAG             in varchar2,
        p_DPDNT_ADOPTION_DATE           in DATE,
        p_DPDNT_VLNTRY_SVCE_FLAG        in varchar2,
        p_ORIGINAL_DATE_OF_HIRE         in DATE,
      p_town_of_birth                   in varchar2,
        p_region_of_birth               in varchar2,
      p_country_of_birth                in varchar2,
        p_global_person_id              in varchar2,
        p_party_id                      in number,
        p_npw_number                    in varchar2,
        p_current_npw_flag              in varchar2,
        p_global_name                   in  varchar2,
        p_local_name                    in  varchar2
   )
   Return g_rec_type is
--
  l_rec    g_rec_type;

Line: 925


  l_rec.program_update_date              := p_program_update_date;

Line: 1002


  l_rec.RESUME_LAST_UPDATED              := p_RESUME_LAST_UPDATED;