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_RAA_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_raa_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'insert_dml';

Line: 90


  insert into per_recruitment_activities
      (recruitment_activity_id
      ,business_group_id
      ,authorising_person_id
      ,run_by_organization_id
      ,internal_contact_person_id
      ,parent_recruitment_activity_id
      ,currency_code
      ,date_start
      ,name
      ,actual_cost
      ,comments
      ,contact_telephone_number
      ,date_closing
      ,date_end
      ,external_contact
      ,planned_cost
      ,recruiting_site_id
      ,recruiting_site_response
      ,last_posted_date
      ,type
      ,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
      ,posting_content_id
      ,status
      ,object_version_number
      )
  Values
    (p_rec.recruitment_activity_id
    ,p_rec.business_group_id
    ,p_rec.authorising_person_id
    ,p_rec.run_by_organization_id
    ,p_rec.internal_contact_person_id
    ,p_rec.parent_recruitment_activity_id
    ,p_rec.currency_code
    ,p_rec.date_start
    ,p_rec.name
    ,p_rec.actual_cost
    ,p_rec.comments
    ,p_rec.contact_telephone_number
    ,p_rec.date_closing
    ,p_rec.date_end
    ,p_rec.external_contact
    ,p_rec.planned_cost
    ,p_rec.recruiting_site_id
    ,empty_clob()
    ,p_rec.last_posted_date
    ,p_rec.type
    ,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.posting_content_id
    ,p_rec.status
    ,p_rec.object_version_number
    ) returning recruiting_site_response into l_recruiting_site_response;

Line: 222


End insert_dml;

Line: 261


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

Line: 268


    Select null
      from per_recruitment_activities
     where recruitment_activity_id =
             per_raa_ins.g_recruitment_activity_id_i;

Line: 273


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

Line: 314


End pre_insert;

Line: 348


Procedure post_insert
  (p_rec                          in per_raa_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'post_insert';

Line: 358


    per_raa_rki.after_insert
      (p_recruitment_activity_id
      => p_rec.recruitment_activity_id
      ,p_business_group_id
      => p_rec.business_group_id
      ,p_authorising_person_id
      => p_rec.authorising_person_id
      ,p_run_by_organization_id
      => p_rec.run_by_organization_id
      ,p_internal_contact_person_id
      => p_rec.internal_contact_person_id
      ,p_parent_recruitment_activity
      => p_rec.parent_recruitment_activity_id
      ,p_currency_code
      => p_rec.currency_code
      ,p_date_start
      => p_rec.date_start
      ,p_name
      => p_rec.name
      ,p_actual_cost
      => p_rec.actual_cost
      ,p_comments
      => p_rec.comments
      ,p_contact_telephone_number
      => p_rec.contact_telephone_number
      ,p_date_closing
      => p_rec.date_closing
      ,p_date_end
      => p_rec.date_end
      ,p_external_contact
      => p_rec.external_contact
      ,p_planned_cost
      => p_rec.planned_cost
      ,p_recruiting_site_id
      => p_rec.recruiting_site_id
      ,p_recruiting_site_response
      => p_rec.recruiting_site_response
      ,p_last_posted_date
      => p_rec.last_posted_date
      ,p_type
      => p_rec.type
      ,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_posting_content_id
      => p_rec.posting_content_id
      ,p_status
      => p_rec.status
      ,p_object_version_number
      => p_rec.object_version_number
      );

Line: 468


End post_insert;

Line: 484


  per_raa_bus.insert_validate
     (p_rec
     );

Line: 493


  per_raa_ins.pre_insert(p_rec);

Line: 497


  per_raa_ins.insert_dml(p_rec);

Line: 501


  per_raa_ins.post_insert
     (p_rec
     );

Line: 537


  ,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_posting_content_id             in     number   default null
  ,p_status                         in     varchar2 default null
  ,p_recruitment_activity_id           out nocopy number
  ,p_object_version_number             out nocopy number
  ) is
--
  l_rec   per_raa_shd.g_rec_type;

Line: 599


    ,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_posting_content_id
    ,p_status
    ,null
    );