DBA Data[Home] [Help]

APPS.PER_EVT_SHD SQL Statements

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

Line: 74

    select
       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
    from        per_events
    where       event_id = p_event_id;
Line: 182

    select
       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
    from        per_events
    where       event_id = p_event_id
    for update nowait;
Line: 302

  ,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_party_id                       in number  default null
  ,p_object_version_number          in number
  )
  Return g_rec_type is
--
  l_rec   g_rec_type;
Line: 354

  l_rec.program_update_date              := p_program_update_date;