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.HR_PSF_SHD SQL Statements

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

Line: 13


cursor c1 is select system_type_cd
             from per_shared_types
             where shared_type_id = p_availability_status_id
             and lookup_type ='POSITION_AVAILABILITY_STATUS'
             and (business_group_id = p_business_group_id or business_group_id is null);

Line: 36


cursor c1 is select job_id, organization_id
             from hr_all_positions_f
             where position_id = p_position_id
             and p_effective_date
                  between effective_start_date
                  and effective_end_date;

Line: 58


         select    system_type_cd
         from      per_shared_types sht, hr_all_positions_f psf
         where     shared_type_id  = psf.availability_status_id
         and       psf.position_id = p_position_id
         and       p_effective_date between psf.effective_start_date and psf.effective_end_date;

Line: 87


         select    system_type_cd
         from      per_shared_types
         where     shared_type_id  = p_availability_status_id;

Line: 152


select count(*) into cnt from hr_all_positions_f where position_id = l_position_id and availability_status_id = 1;

Line: 154


select hr_general.effective_date into l_expiration_date from dual;

Line: 173


select min(effective_start_date), max(effective_end_date)
into l_start_date, l_expiration_date from hr_all_positions_f
where position_id = l_position_id and availability_status_id = 1;

Line: 178


select name into l_name from hr_all_positions_f_tl where position_id = l_position_id and language = userenv('LANG');

Line: 291


    select
   position_id,
   effective_start_date,
   effective_end_date,
   availability_status_id,
   business_group_id,
   entry_step_id,
   entry_grade_rule_id,
   job_id,
   location_id,
   organization_id,
   pay_freq_payroll_id,
   position_definition_id,
   position_transaction_id,
   prior_position_id,
   relief_position_id,
   entry_grade_id,
   successor_position_id,
   supervisor_position_id,
   amendment_date,
   amendment_recommendation,
   amendment_ref_number,
   bargaining_unit_cd,
   null,
   current_job_prop_end_date,
   current_org_prop_end_date,
   avail_status_prop_end_date,
   date_effective,
   date_end,
   earliest_hire_date,
   fill_by_date,
   frequency,
   fte,
   max_persons,
   name,
   overlap_period,
   overlap_unit_cd,
   pay_term_end_day_cd,
   pay_term_end_month_cd,
   permanent_temporary_flag,
   permit_recruitment_flag,
   position_type,
   posting_description,
   probation_period,
   probation_period_unit_cd,
   replacement_required_flag,
   review_flag,
   seasonal_flag,
   security_requirements,
   status,
   term_start_day_cd,
   term_start_month_cd,
   time_normal_finish,
   time_normal_start,
   update_source_cd,
   working_hours,
   works_council_approval_flag,
   work_period_type_cd,
   work_term_end_day_cd,
   work_term_end_month_cd,
        proposed_fte_for_layoff,
        proposed_date_for_layoff,
        pay_basis_id            ,
        supervisor_id           ,
        copied_to_old_table_flag,
/*
position_id               ,
effective_start_date      ,
effective_end_date        ,
availability_status_id    ,
business_group_id         ,
entry_step_id             ,
entry_grade_rule_id       ,
job_id                    ,
location_id               ,
organization_id           ,
pay_freq_payroll_id       ,
position_definition_id    ,
position_transaction_id   ,
prior_position_id         ,
relief_position_id        ,
entry_grade_id            ,
successor_position_id     ,
supervisor_position_id    ,
amendment_date            ,
amendment_recommendation  ,
amendment_ref_number      ,
bargaining_unit_cd        ,
comments                  ,
current_job_prop_end_date ,
current_org_prop_end_date ,
avail_status_prop_end_date,
date_effective            ,
date_end                  ,
earliest_hire_date        ,
fill_by_date              ,
frequency                 ,
fte                       ,
max_persons               ,
name                      ,
overlap_period            ,
overlap_unit_cd           ,
pay_term_end_day_cd       ,
pay_term_end_month_cd     ,
permanent_temporary_flag  ,
permit_recruitment_flag   ,
position_type             ,
posting_description       ,
probation_period          ,
probation_period_unit_cd  ,
replacement_required_flag ,
review_flag               ,
seasonal_flag             ,
security_requirements     ,
status                    ,
term_start_day_cd         ,
term_start_month_cd       ,
time_normal_finish        ,
time_normal_start         ,
update_source_cd          ,
working_hours             ,
works_council_approval_flag,
work_period_type_cd       ,
work_term_end_day_cd      ,
work_term_end_month_cd    ,
proposed_fte_for_layoff   ,
proposed_date_for_layoff  ,
pay_basis_id              ,
supervisor_id             ,
copied_to_old_table_flag  ,
*/
   information1,
   information2,
   information3,
   information4,
   information5,
   information6,
   information7,
   information8,
   information9,
   information10,
   information11,
   information12,
   information13,
   information14,
   information15,
   information16,
   information17,
   information18,
   information19,
   information20,
   information21,
   information22,
   information23,
   information24,
   information25,
   information26,
   information27,
   information28,
   information29,
   information30,
   information_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,
   attribute_category,
   request_id,
   program_application_id,
   program_id,
   program_update_date,
   object_version_number,
   null
    from hr_all_positions_f
    where   position_id = p_position_id
    and     p_effective_date
    between effective_start_date and effective_end_date;

Line: 563


    p_delete    out nocopy boolean,
    p_future_change out nocopy boolean,
    p_delete_next_change out nocopy boolean) is
--
  l_proc       varchar2(72);

Line: 575


    select  t.supervisor_position_id,
            t.successor_position_id,
            t.relief_position_id
    from    hr_all_positions_f t
    where   t.position_id = p_base_key_value
    and     p_effective_date
    between t.effective_start_date and t.effective_end_date;

Line: 619


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

Line: 623


  p_delete := false ;

Line: 637


    p_update    out nocopy boolean,
    p_update_override out nocopy boolean,
    p_update_change_insert out nocopy boolean) is
--
  l_proc    varchar2(72);

Line: 658


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

Line: 705


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

Line: 743


    select
   position_id,
   effective_start_date,
   effective_end_date,
   availability_status_id,
   business_group_id,
   entry_step_id,
   entry_grade_rule_id,
   job_id,
   location_id,
   organization_id,
   pay_freq_payroll_id,
   position_definition_id,
   position_transaction_id,
   prior_position_id,
   relief_position_id,
   entry_grade_id,
   successor_position_id,
   supervisor_position_id,
   amendment_date,
   amendment_recommendation,
   amendment_ref_number,
   bargaining_unit_cd,
   comments,
   current_job_prop_end_date,
   current_org_prop_end_date,
   avail_status_prop_end_date,
   date_effective,
   date_end,
   earliest_hire_date,
   fill_by_date,
   frequency,
   fte,
   max_persons,
   name,
   overlap_period,
   overlap_unit_cd,
   pay_term_end_day_cd,
   pay_term_end_month_cd,
   permanent_temporary_flag,
   permit_recruitment_flag,
   position_type,
   posting_description,
   probation_period,
   probation_period_unit_cd,
   replacement_required_flag,
   review_flag,
   seasonal_flag,
   security_requirements,
   status,
   term_start_day_cd,
   term_start_month_cd,
   time_normal_finish,
   time_normal_start,
   update_source_cd,
   working_hours,
   works_council_approval_flag,
   work_period_type_cd,
   work_term_end_day_cd,
   work_term_end_month_cd,
      proposed_fte_for_layoff,
      proposed_date_for_layoff,
pay_basis_id              ,
supervisor_id             ,
copied_to_old_table_flag  ,
   information1,
   information2,
   information3,
   information4,
   information5,
   information6,
   information7,
   information8,
   information9,
   information10,
   information11,
   information12,
   information13,
   information14,
   information15,
   information16,
   information17,
   information18,
   information19,
   information20,
   information21,
   information22,
   information23,
   information24,
   information25,
   information26,
   information27,
   information28,
   information29,
   information30,
   information_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,
   attribute_category,
   request_id,
   program_application_id,
   program_id,
   program_update_date,
   object_version_number,
   null
    from    hr_all_positions_f
    where   position_id         = p_position_id
    and      p_effective_date
    between effective_start_date and effective_end_date
    for update nowait;

Line: 911


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

Line: 1072


   p_update_source_cd              in varchar2,
   p_working_hours                 in number,
   p_works_council_approval_flag   in varchar2,
   p_work_period_type_cd           in varchar2,
   p_work_term_end_day_cd          in varchar2,
   p_work_term_end_month_cd        in varchar2,
        p_proposed_fte_for_layoff       in number,
        p_proposed_date_for_layoff      in date,
        p_pay_basis_id                  in number,
        p_supervisor_id                 in number,
        p_copied_to_old_table_flag      in varchar2,
   p_information1                  in varchar2,
   p_information2                  in varchar2,
   p_information3                  in varchar2,
   p_information4                  in varchar2,
   p_information5                  in varchar2,
   p_information6                  in varchar2,
   p_information7                  in varchar2,
   p_information8                  in varchar2,
   p_information9                  in varchar2,
   p_information10                 in varchar2,
   p_information11                 in varchar2,
   p_information12                 in varchar2,
   p_information13                 in varchar2,
   p_information14                 in varchar2,
   p_information15                 in varchar2,
   p_information16                 in varchar2,
   p_information17                 in varchar2,
   p_information18                 in varchar2,
   p_information19                 in varchar2,
   p_information20                 in varchar2,
   p_information21                 in varchar2,
   p_information22                 in varchar2,
   p_information23                 in varchar2,
   p_information24                 in varchar2,
   p_information25                 in varchar2,
   p_information26                 in varchar2,
   p_information27                 in varchar2,
   p_information28                 in varchar2,
   p_information29                 in varchar2,
   p_information30                 in varchar2,
   p_information_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_attribute_category            in varchar2,
   p_request_id                    in number,
   p_program_application_id        in number,
   p_program_id                    in number,
   p_program_update_date           in date,
   p_object_version_number         in number,
   p_security_profile_id      in number
   )
   Return g_rec_type is
--
  l_rec    g_rec_type;

Line: 1220


  l_rec.update_source_cd                 := p_update_source_cd;

Line: 1296


  l_rec.program_update_date              := p_program_update_date;