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

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

Line: 76


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

Line: 90


  insert into per_events
      (event_id
      ,business_group_id
      ,location_id
      ,internal_contact_person_id
      ,organization_run_by_id
      ,assignment_id
      ,date_start
      ,type
      ,comments
      ,contact_telephone_number
      ,date_end
      ,emp_or_apl
      ,event_or_interview
      ,external_contact
      ,time_end
      ,time_start
      ,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
      ,party_id
      ,object_version_number
      )
  Values
    (p_rec.event_id
    ,p_rec.business_group_id
    ,p_rec.location_id
    ,p_rec.internal_contact_person_id
    ,p_rec.organization_run_by_id
    ,p_rec.assignment_id
    ,p_rec.date_start
    ,p_rec.type
    ,p_rec.comments
    ,p_rec.contact_telephone_number
    ,p_rec.date_end
    ,p_rec.emp_or_apl
    ,p_rec.event_or_interview
    ,p_rec.external_contact
    ,p_rec.time_end
    ,p_rec.time_start
    ,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.party_id
    ,p_rec.object_version_number
    );

Line: 203


End insert_dml;

Line: 242


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

Line: 250


    Select null
      from per_events
     where event_id =
             per_evt_ins.g_event_id_i;

Line: 255


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

Line: 296


End pre_insert;

Line: 330


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

Line: 340


    per_evt_rki.after_insert
      (p_event_id
      => p_rec.event_id
      ,p_business_group_id
      => p_rec.business_group_id
      ,p_location_id
      => p_rec.location_id
      ,p_internal_contact_person_id
      => p_rec.internal_contact_person_id
      ,p_organization_run_by_id
      => p_rec.organization_run_by_id
      ,p_assignment_id
      => p_rec.assignment_id
      ,p_date_start
      => p_rec.date_start
      ,p_type
      => p_rec.type
      ,p_comments
      => p_rec.comments
      ,p_contact_telephone_number
      => p_rec.contact_telephone_number
      ,p_date_end
      => p_rec.date_end
      ,p_emp_or_apl
      => p_rec.emp_or_apl
      ,p_event_or_interview
      => p_rec.event_or_interview
      ,p_external_contact
      => p_rec.external_contact
      ,p_time_end
      => p_rec.time_end
      ,p_time_start
      => p_rec.time_start
      ,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_party_id
      => p_rec.party_id
      ,p_object_version_number
      => p_rec.object_version_number
      );

Line: 440


End post_insert;

Line: 456


  per_evt_bus.insert_validate
     (p_rec
     );

Line: 462


  per_evt_ins.pre_insert(p_rec);

Line: 466


  per_evt_ins.insert_dml(p_rec);

Line: 470


  per_evt_ins.post_insert
     (p_rec
     );

Line: 499


  ,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_party_id                       in     number   default null
  ,p_event_id                          out nocopy number
  ,p_object_version_number             out nocopy number
  ) is
--
  l_rec   per_evt_shd.g_rec_type;

Line: 556


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