DBA Data[Home] [Help]

APPS.PER_NO_WORK_INCIDENT_API SQL Statements

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

Line: 107

    select per.business_group_id
    from per_all_people_f per
    where per.person_id = p_person_id
    and   p_effective_date between per.effective_start_date
                               and per.effective_end_date;
Line: 114

    select legislation_code
    from per_business_groups pbg
    where pbg.business_group_id = l_business_group_id;
Line: 268

procedure update_no_work_incident
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_incident_id                   in     number
  ,p_object_version_number         in out nocopy number
  ,p_incident_reference            in     varchar2 default hr_api.g_varchar2
  ,p_incident_type                 in     varchar2 default hr_api.g_varchar2
  ,p_at_work_flag                  in     varchar2 default hr_api.g_varchar2
  ,p_incident_date                 in     date     default hr_api.g_date
  ,p_incident_time                 in     varchar2 default hr_api.g_varchar2
  ,p_org_notified_date             in     date     default hr_api.g_date
  ,p_assignment_id                 in     number   default hr_api.g_number
  ,p_location                      in     varchar2 default hr_api.g_varchar2
  ,p_report_date                   in     date     default hr_api.g_date
  ,p_report_time                   in     varchar2 default hr_api.g_varchar2
  ,p_report_method                 in     varchar2 default hr_api.g_varchar2
  ,p_person_reported_by            in     number   default hr_api.g_number
  ,p_person_reported_to            in     varchar2 default hr_api.g_varchar2
  ,p_witness_details               in     varchar2 default hr_api.g_varchar2
  ,p_description                   in     varchar2 default hr_api.g_varchar2
  ,p_injury_type                   in     varchar2 default hr_api.g_varchar2
  ,p_disease_type                  in     varchar2 default hr_api.g_varchar2
  ,p_hazard_type                   in     varchar2 default hr_api.g_varchar2
  ,p_body_part                     in     varchar2 default hr_api.g_varchar2
  ,p_treatment_received_flag       in     varchar2 default hr_api.g_varchar2
  ,p_hospital_details              in     varchar2 default hr_api.g_varchar2
  ,p_emergency_code                in     varchar2 default hr_api.g_varchar2
  ,p_hospitalized_flag             in     varchar2 default hr_api.g_varchar2
  ,p_hospital_address              in     varchar2 default hr_api.g_varchar2
  ,p_activity_at_time_of_work      in     varchar2 default hr_api.g_varchar2
  ,p_objects_involved              in     varchar2 default hr_api.g_varchar2
  ,p_privacy_issue                 in     varchar2 default hr_api.g_varchar2
  ,p_work_start_time               in     varchar2 default hr_api.g_varchar2
  ,p_date_of_death                 in     date     default hr_api.g_date
  ,p_report_completed_by           in     varchar2 default hr_api.g_varchar2
  ,p_reporting_person_title        in     varchar2 default hr_api.g_varchar2
  ,p_reporting_person_phone        in     varchar2 default hr_api.g_varchar2
  ,p_days_restricted_work          in     number   default hr_api.g_number
  ,p_days_away_from_work           in     number   default hr_api.g_number
  ,p_doctor_name                   in     varchar2 default hr_api.g_varchar2
  ,p_compensation_date             in     date     default hr_api.g_date
  ,p_compensation_currency         in     varchar2 default hr_api.g_varchar2
  ,p_compensation_amount           in     number   default hr_api.g_number
  ,p_remedial_hs_action            in     varchar2 default hr_api.g_varchar2
  ,p_notified_hsrep_id             in     number   default hr_api.g_number
  ,p_notified_hsrep_date           in     date     default hr_api.g_date
  ,p_notified_rep_id               in     number   default hr_api.g_number
  ,p_notified_rep_date             in     date     default hr_api.g_date
  ,p_notified_rep_org_id           in     number   default hr_api.g_number
  ,p_related_incident_id           in     number   default hr_api.g_number
  ,p_over_time_flag                in     varchar2 default hr_api.g_varchar2
  ,p_absence_exists_flag           in     varchar2 default hr_api.g_varchar2
  ,p_attribute_category            in     varchar2 default hr_api.g_varchar2
  ,p_attribute1                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute2                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute3                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute4                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute5                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute6                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute7                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute8                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute9                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute10                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute11                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute12                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute13                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute14                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute15                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute16                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute17                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute18                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute19                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute20                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute21                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute22                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute23                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute24                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute25                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute26                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute27                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute28                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute29                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute30                   in     varchar2 default hr_api.g_varchar2
  ,p_date_rep_social_security      in     varchar2 default hr_api.g_varchar2
  ,p_date_rep_labor_inspection     in     varchar2 default hr_api.g_varchar2

  ) is
  --
  -- Declare cursors and local variables
  --
  l_business_group_id    per_contracts_f.business_group_id%TYPE;
Line: 359

  l_proc                 varchar2(72) := g_package||'update_no_work_incident';
Line: 363

    select per.business_group_id
    from per_all_people_f per
    where per.person_id = (select person_id
                          from    per_work_incidents
                          where   incident_id = p_incident_id)
    and   p_effective_date between per.effective_start_date
                               and per.effective_end_date;
Line: 372

    select legislation_code
    from per_business_groups pbg
    where pbg.business_group_id = l_business_group_id;
Line: 382

  savepoint update_no_work_incident;
Line: 429

    per_work_incident_api.update_work_incident
      (p_validate                       => p_validate
       ,p_effective_date                => p_effective_date
       ,p_incident_id                   => p_incident_id
       ,p_object_version_number         => p_object_version_number
       ,p_incident_reference            => p_incident_reference
       ,p_incident_type                 => p_incident_type
       ,p_at_work_flag                  => p_at_work_flag
       ,p_incident_date                 => p_incident_date
       ,p_incident_time                 => p_incident_time
       ,p_org_notified_date             => p_org_notified_date
       ,p_assignment_id                 => p_assignment_id
       ,p_location                      => p_location
       ,p_report_date                   => p_report_date
       ,p_report_time                   => p_report_time
       ,p_report_method                 => p_report_method
       ,p_person_reported_by            => p_person_reported_by
       ,p_person_reported_to            => p_person_reported_to
       ,p_witness_details               => p_witness_details
       ,p_description                   => p_description
       ,p_injury_type                   => p_injury_type
       ,p_disease_type                  => p_disease_type
       ,p_hazard_type                   => p_hazard_type
       ,p_body_part                     => p_body_part
       ,p_treatment_received_flag       => p_treatment_received_flag
       ,p_hospital_details              => p_hospital_details
       ,p_emergency_code                => p_emergency_code
       ,p_hospitalized_flag             => p_hospitalized_flag
       ,p_hospital_address              => p_hospital_address
       ,p_activity_at_time_of_work      => p_activity_at_time_of_work
       ,p_objects_involved              => p_objects_involved
       ,p_privacy_issue                 => p_privacy_issue
       ,p_work_start_time               => p_work_start_time
       ,p_date_of_death                 => p_date_of_death
       ,p_report_completed_by           => p_report_completed_by
       ,p_reporting_person_title        => p_reporting_person_title
       ,p_reporting_person_phone        => p_reporting_person_phone
       ,p_days_restricted_work          => p_days_restricted_work
       ,p_days_away_from_work           => p_days_away_from_work
       ,p_doctor_name                   => p_doctor_name
       ,p_compensation_date             => p_compensation_date
       ,p_compensation_currency         => p_compensation_currency
       ,p_compensation_amount           => p_compensation_amount
       ,p_remedial_hs_action            => p_remedial_hs_action
       ,p_notified_hsrep_id             => p_notified_hsrep_id
       ,p_notified_hsrep_date           => p_notified_hsrep_date
       ,p_notified_rep_id               => p_notified_rep_id
       ,p_notified_rep_date             => p_notified_rep_date
       ,p_notified_rep_org_id           => p_notified_rep_org_id
       ,p_related_incident_id           => p_related_incident_id
       ,p_over_time_flag                => p_over_time_flag
       ,p_absence_exists_flag           => p_absence_exists_flag
       ,p_attribute_category            => p_attribute_category
       ,p_attribute1                    => p_attribute1
       ,p_attribute2                    => p_attribute2
       ,p_attribute3                    => p_attribute3
       ,p_attribute4                    => p_attribute4
       ,p_attribute5                    => p_attribute5
       ,p_attribute6                    => p_attribute6
       ,p_attribute7                    => p_attribute7
       ,p_attribute8                    => p_attribute8
       ,p_attribute9                    => p_attribute9
       ,p_attribute10                   => p_attribute10
       ,p_attribute11                   => p_attribute11
       ,p_attribute12                   => p_attribute12
       ,p_attribute13                   => p_attribute13
       ,p_attribute14                   => p_attribute14
       ,p_attribute15                   => p_attribute15
       ,p_attribute16                   => p_attribute16
       ,p_attribute17                   => p_attribute17
       ,p_attribute18                   => p_attribute18
       ,p_attribute19                   => p_attribute19
       ,p_attribute20                   => p_attribute20
       ,p_attribute21                   => p_attribute21
       ,p_attribute22                   => p_attribute22
       ,p_attribute23                   => p_attribute23
       ,p_attribute24                   => p_attribute24
       ,p_attribute25                   => p_attribute25
       ,p_attribute26                   => p_attribute26
       ,p_attribute27                   => p_attribute27
       ,p_attribute28                   => p_attribute28
       ,p_attribute29                   => p_attribute29
       ,p_attribute30                   => p_attribute30
       ,p_inc_information_category      => 'NO'
       ,p_inc_information1              => p_date_rep_social_security
       ,p_inc_information2              => p_date_rep_labor_inspection

      );
Line: 520

end update_no_work_incident;