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

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

Line: 75


Procedure insert_dml
  (p_rec in out nocopy per_vac_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'insert_dml';

Line: 89


  insert into per_all_vacancies
      (vacancy_id
      ,business_group_id
      ,position_id
      ,job_id
      ,grade_id
      ,organization_id
      ,requisition_id
      ,people_group_id
      ,location_id
      ,recruiter_id
      ,date_from
      ,name
      ,comments
      ,date_to
      ,description
      ,number_of_openings
      ,status
      ,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
      ,vacancy_category
      ,vacancy_region_type
      ,budget_measurement_type
      ,budget_measurement_value
      ,manager_id
      ,security_method
      ,primary_posting_id
      ,assessment_id
      ,object_version_number
      )
  Values
    (p_rec.vacancy_id
    ,p_rec.business_group_id
    ,p_rec.position_id
    ,p_rec.job_id
    ,p_rec.grade_id
    ,p_rec.organization_id
    ,p_rec.requisition_id
    ,p_rec.people_group_id
    ,p_rec.location_id
    ,p_rec.recruiter_id
    ,p_rec.date_from
    ,p_rec.name
    ,p_rec.comments
    ,p_rec.date_to
    ,p_rec.description
    ,p_rec.number_of_openings
    ,p_rec.status
    ,p_rec.request_id
    ,p_rec.program_application_id
    ,p_rec.program_id
    ,p_rec.program_update_date
    ,p_rec.attribute_category
    ,p_rec.attribute1
    ,p_rec.attribute2
    ,p_rec.attribute3
    ,p_rec.attribute4
    ,p_rec.attribute5
    ,p_rec.attribute6
    ,p_rec.attribute7
    ,p_rec.attribute8
    ,p_rec.attribute9
    ,p_rec.attribute10
    ,p_rec.attribute11
    ,p_rec.attribute12
    ,p_rec.attribute13
    ,p_rec.attribute14
    ,p_rec.attribute15
    ,p_rec.attribute16
    ,p_rec.attribute17
    ,p_rec.attribute18
    ,p_rec.attribute19
    ,p_rec.attribute20
    ,p_rec.vacancy_category
    ,p_rec.vacancy_region_type
    ,p_rec.budget_measurement_type
    ,p_rec.budget_measurement_value
    ,p_rec.manager_id
    ,p_rec.security_method
    ,p_rec.primary_posting_id
    ,p_rec.assessment_id
    ,p_rec.object_version_number
    );

Line: 218


End insert_dml;

Line: 258


Procedure pre_insert
  (p_rec  in out nocopy per_vac_shd.g_rec_type
  ) is
--
  Cursor C_Sel1 is select per_vacancies_s.nextval from sys.dual;

Line: 265


    Select null
      from per_all_vacancies
     where vacancy_id =
             per_vac_ins.g_vacancy_id_i;

Line: 270


  l_proc   varchar2(72) := g_package||'pre_insert';

Line: 311


End pre_insert;

Line: 345


Procedure post_insert
  (p_rec                          in per_vac_shd.g_rec_type
  ,p_effective_date               in date
  ) is
--
  l_proc  varchar2(72) := g_package||'post_insert';

Line: 356


    per_vac_rki.after_insert
      (p_effective_date
      => p_effective_date
      ,p_vacancy_id
      => p_rec.vacancy_id
      ,p_business_group_id
      => p_rec.business_group_id
      ,p_position_id
      => p_rec.position_id
      ,p_job_id
      => p_rec.job_id
      ,p_grade_id
      => p_rec.grade_id
      ,p_organization_id
      => p_rec.organization_id
      ,p_requisition_id
      => p_rec.requisition_id
      ,p_people_group_id
      => p_rec.people_group_id
      ,p_location_id
      => p_rec.location_id
      ,p_recruiter_id
      => p_rec.recruiter_id
      ,p_date_from
      => p_rec.date_from
      ,p_name
      => p_rec.name
      ,p_comments
      => p_rec.comments
      ,p_date_to
      => p_rec.date_to
      ,p_description
      => p_rec.description
      ,p_number_of_openings
      => p_rec.number_of_openings
      ,p_status
      => p_rec.status
      ,p_request_id
      => p_rec.request_id
      ,p_program_application_id
      => p_rec.program_application_id
      ,p_program_id
      => p_rec.program_id
      ,p_program_update_date
      => p_rec.program_update_date
      ,p_attribute_category
      => p_rec.attribute_category
      ,p_attribute1
      => p_rec.attribute1
      ,p_attribute2
      => p_rec.attribute2
      ,p_attribute3
      => p_rec.attribute3
      ,p_attribute4
      => p_rec.attribute4
      ,p_attribute5
      => p_rec.attribute5
      ,p_attribute6
      => p_rec.attribute6
      ,p_attribute7
      => p_rec.attribute7
      ,p_attribute8
      => p_rec.attribute8
      ,p_attribute9
      => p_rec.attribute9
      ,p_attribute10
      => p_rec.attribute10
      ,p_attribute11
      => p_rec.attribute11
      ,p_attribute12
      => p_rec.attribute12
      ,p_attribute13
      => p_rec.attribute13
      ,p_attribute14
      => p_rec.attribute14
      ,p_attribute15
      => p_rec.attribute15
      ,p_attribute16
      => p_rec.attribute16
      ,p_attribute17
      => p_rec.attribute17
      ,p_attribute18
      => p_rec.attribute18
      ,p_attribute19
      => p_rec.attribute19
      ,p_attribute20
      => p_rec.attribute20
      ,p_vacancy_category
      => p_rec.vacancy_category
      ,p_vacancy_region_type
      => p_rec.vacancy_region_type
      ,p_budget_measurement_type
      => p_rec.budget_measurement_type
      ,p_budget_measurement_value
      => p_rec.budget_measurement_value
      ,p_manager_id
      => p_rec.manager_id
      ,p_security_method
      => p_rec.security_method
      ,p_primary_posting_id
      => p_rec.primary_posting_id
      ,p_assessment_id
      => p_rec.assessment_id
      ,p_object_version_number
      => p_rec.object_version_number
      );

Line: 474


End post_insert;

Line: 493


  per_vac_bus.insert_validate
     (p_rec                   => p_rec
     ,p_effective_date        => p_effective_date
     ,p_inv_pos_grade_warning => p_inv_pos_grade_warning
     ,p_inv_job_grade_warning => p_inv_job_grade_warning
     );

Line: 502


  per_vac_ins.pre_insert(p_rec);

Line: 506


  per_vac_ins.insert_dml(p_rec);

Line: 510


  per_vac_ins.post_insert
     (p_rec
     ,p_effective_date
     );

Line: 543


  ,p_program_update_date            in     date     default null
  ,p_attribute_category             in     varchar2 default null
  ,p_attribute1                     in     varchar2 default null
  ,p_attribute2                     in     varchar2 default null
  ,p_attribute3                     in     varchar2 default null
  ,p_attribute4                     in     varchar2 default null
  ,p_attribute5                     in     varchar2 default null
  ,p_attribute6                     in     varchar2 default null
  ,p_attribute7                     in     varchar2 default null
  ,p_attribute8                     in     varchar2 default null
  ,p_attribute9                     in     varchar2 default null
  ,p_attribute10                    in     varchar2 default null
  ,p_attribute11                    in     varchar2 default null
  ,p_attribute12                    in     varchar2 default null
  ,p_attribute13                    in     varchar2 default null
  ,p_attribute14                    in     varchar2 default null
  ,p_attribute15                    in     varchar2 default null
  ,p_attribute16                    in     varchar2 default null
  ,p_attribute17                    in     varchar2 default null
  ,p_attribute18                    in     varchar2 default null
  ,p_attribute19                    in     varchar2 default null
  ,p_attribute20                    in     varchar2 default null
  ,p_vacancy_category               in     varchar2 default null
  ,p_vacancy_region_type            in     varchar2 default null
  ,p_budget_measurement_type        in     varchar2 default null
  ,p_budget_measurement_value       in     number   default null
  ,p_manager_id                     in     number   default null
  ,p_security_method                in     varchar2 default null
  ,p_primary_posting_id             in     number   default null
  ,p_assessment_id                  in     number   default null
  ,p_inv_pos_grade_warning             out nocopy boolean
  ,p_inv_job_grade_warning             out nocopy boolean
  ,p_vacancy_id                        out nocopy number
  ,p_object_version_number             out nocopy number
  ) is
--
  l_rec   per_vac_shd.g_rec_type;

Line: 610


    ,p_program_update_date
    ,p_attribute_category
    ,p_attribute1
    ,p_attribute2
    ,p_attribute3
    ,p_attribute4
    ,p_attribute5
    ,p_attribute6
    ,p_attribute7
    ,p_attribute8
    ,p_attribute9
    ,p_attribute10
    ,p_attribute11
    ,p_attribute12
    ,p_attribute13
    ,p_attribute14
    ,p_attribute15
    ,p_attribute16
    ,p_attribute17
    ,p_attribute18
    ,p_attribute19
    ,p_attribute20
    ,p_vacancy_category
    ,p_vacancy_region_type
    ,p_budget_measurement_type
    ,p_budget_measurement_value
    ,p_manager_id
    ,p_security_method
    ,p_primary_posting_id
    ,p_assessment_id
    ,null
    );