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

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

Line: 428


PROCEDURE update_medical_assessment
  (p_validate                      IN     BOOLEAN  DEFAULT FALSE
  ,p_medical_assessment_id         IN     NUMBER
  ,p_object_version_number         IN OUT NOCOPY NUMBER
  ,p_effective_date                IN     DATE
  ,p_consultation_date             IN     DATE     DEFAULT hr_api.g_date
  ,p_consultation_type             IN     VARCHAR2 DEFAULT hr_api.g_varchar2
  ,p_examiner_name                 IN     VARCHAR2 DEFAULT hr_api.g_varchar2
  ,p_organization_id               IN     NUMBER   DEFAULT hr_api.g_number
  ,p_consultation_result           IN     VARCHAR2 DEFAULT hr_api.g_varchar2
  ,p_incident_id                   IN     NUMBER   DEFAULT hr_api.g_number
  ,p_disability_id                 IN     NUMBER   DEFAULT hr_api.g_number
  ,p_next_consultation_date        IN     DATE     DEFAULT hr_api.g_date
  ,p_description                   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_mea_information_category      IN     VARCHAR2 DEFAULT hr_api.g_varchar2
  ,p_mea_information1              IN     VARCHAR2 DEFAULT hr_api.g_varchar2
  ,p_mea_information2              IN     VARCHAR2 DEFAULT hr_api.g_varchar2
  ,p_mea_information3              IN     VARCHAR2 DEFAULT hr_api.g_varchar2
  ,p_mea_information4              IN     VARCHAR2 DEFAULT hr_api.g_varchar2
  ,p_mea_information5              IN     VARCHAR2 DEFAULT hr_api.g_varchar2
  ,p_mea_information6              IN     VARCHAR2 DEFAULT hr_api.g_varchar2
  ,p_mea_information7              IN     VARCHAR2 DEFAULT hr_api.g_varchar2
  ,p_mea_information8              IN     VARCHAR2 DEFAULT hr_api.g_varchar2
  ,p_mea_information9              IN     VARCHAR2 DEFAULT hr_api.g_varchar2
  ,p_mea_information10             IN     VARCHAR2 DEFAULT hr_api.g_varchar2
  ,p_mea_information11             IN     VARCHAR2 DEFAULT hr_api.g_varchar2
  ,p_mea_information12             IN     VARCHAR2 DEFAULT hr_api.g_varchar2
  ,p_mea_information13             IN     VARCHAR2 DEFAULT hr_api.g_varchar2
  ,p_mea_information14             IN     VARCHAR2 DEFAULT hr_api.g_varchar2
  ,p_mea_information15             IN     VARCHAR2 DEFAULT hr_api.g_varchar2
  ,p_mea_information16             IN     VARCHAR2 DEFAULT hr_api.g_varchar2
  ,p_mea_information17             IN     VARCHAR2 DEFAULT hr_api.g_varchar2
  ,p_mea_information18             IN     VARCHAR2 DEFAULT hr_api.g_varchar2
  ,p_mea_information19             IN     VARCHAR2 DEFAULT hr_api.g_varchar2
  ,p_mea_information20             IN     VARCHAR2 DEFAULT hr_api.g_varchar2
  ,p_mea_information21             IN     VARCHAR2 DEFAULT hr_api.g_varchar2
  ,p_mea_information22             IN     VARCHAR2 DEFAULT hr_api.g_varchar2
  ,p_mea_information23             IN     VARCHAR2 DEFAULT hr_api.g_varchar2
  ,p_mea_information24             IN     VARCHAR2 DEFAULT hr_api.g_varchar2
  ,p_mea_information25             IN     VARCHAR2 DEFAULT hr_api.g_varchar2
  ,p_mea_information26             IN     VARCHAR2 DEFAULT hr_api.g_varchar2
  ,p_mea_information27             IN     VARCHAR2 DEFAULT hr_api.g_varchar2
  ,p_mea_information28             IN     VARCHAR2 DEFAULT hr_api.g_varchar2
  ,p_mea_information29             IN     VARCHAR2 DEFAULT hr_api.g_varchar2
  ,p_mea_information30             IN     VARCHAR2 DEFAULT hr_api.g_varchar2
  ) IS
  --
  -- Declare LOCAL variables
  --
  l_proc  varchar2(72) := g_package||'update_medical_assessment';

Line: 522


  SAVEPOINT update_medical_assessment;

Line: 540


    per_medical_assessment_bk2.update_medical_assessment_b
      (p_medical_assessment_id         => p_medical_assessment_id
      ,p_object_version_number         => l_object_version_number
      ,p_effective_date                => l_effective_date
      ,p_consultation_date             => l_consultation_date
      ,p_consultation_type             => p_consultation_type
      ,p_examiner_name                 => p_examiner_name
      ,p_organization_id               => p_organization_id
      ,p_consultation_result           => p_consultation_result
      ,p_incident_id                   => p_incident_id
      ,p_disability_id                 => p_disability_id
      ,p_next_consultation_date        => l_next_consultation_date
      ,p_description                   => p_description
      ,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_mea_information_category      => p_mea_information_category
      ,p_mea_information1              => p_mea_information1
      ,p_mea_information2              => p_mea_information2
      ,p_mea_information3              => p_mea_information3
      ,p_mea_information4              => p_mea_information4
      ,p_mea_information5              => p_mea_information5
      ,p_mea_information6              => p_mea_information6
      ,p_mea_information7              => p_mea_information7
      ,p_mea_information8              => p_mea_information8
      ,p_mea_information9              => p_mea_information9
      ,p_mea_information10             => p_mea_information10
      ,p_mea_information11             => p_mea_information11
      ,p_mea_information12             => p_mea_information12
      ,p_mea_information13             => p_mea_information13
      ,p_mea_information14             => p_mea_information14
      ,p_mea_information15             => p_mea_information15
      ,p_mea_information16             => p_mea_information16
      ,p_mea_information17             => p_mea_information17
      ,p_mea_information18             => p_mea_information18
      ,p_mea_information19             => p_mea_information19
      ,p_mea_information20             => p_mea_information20
      ,p_mea_information21             => p_mea_information21
      ,p_mea_information22             => p_mea_information22
      ,p_mea_information23             => p_mea_information23
      ,p_mea_information24             => p_mea_information24
      ,p_mea_information25             => p_mea_information25
      ,p_mea_information26             => p_mea_information26
      ,p_mea_information27             => p_mea_information27
      ,p_mea_information28             => p_mea_information28
      ,p_mea_information29             => p_mea_information29
      ,p_mea_information30             => p_mea_information30);

Line: 621


        (p_module_name => 'update_medical_assessment_b'
        ,p_hook_type   => 'BP');

Line: 713


    per_medical_assessment_bk2.update_medical_assessment_a
      (p_medical_assessment_id         => p_medical_assessment_id
      ,p_object_version_number         => l_object_version_number
      ,p_effective_date                => l_effective_date
      ,p_consultation_date             => l_consultation_date
      ,p_consultation_type             => p_consultation_type
      ,p_examiner_name                 => p_examiner_name
      ,p_organization_id               => p_organization_id
      ,p_consultation_result           => p_consultation_result
      ,p_incident_id                   => p_incident_id
      ,p_disability_id                 => p_disability_id
      ,p_next_consultation_date        => l_next_consultation_date
      ,p_description                   => p_description
      ,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_mea_information_category      => p_mea_information_category
      ,p_mea_information1              => p_mea_information1
      ,p_mea_information2              => p_mea_information2
      ,p_mea_information3              => p_mea_information3
      ,p_mea_information4              => p_mea_information4
      ,p_mea_information5              => p_mea_information5
      ,p_mea_information6              => p_mea_information6
      ,p_mea_information7              => p_mea_information7
      ,p_mea_information8              => p_mea_information8
      ,p_mea_information9              => p_mea_information9
      ,p_mea_information10             => p_mea_information10
      ,p_mea_information11             => p_mea_information11
      ,p_mea_information12             => p_mea_information12
      ,p_mea_information13             => p_mea_information13
      ,p_mea_information14             => p_mea_information14
      ,p_mea_information15             => p_mea_information15
      ,p_mea_information16             => p_mea_information16
      ,p_mea_information17             => p_mea_information17
      ,p_mea_information18             => p_mea_information18
      ,p_mea_information19             => p_mea_information19
      ,p_mea_information20             => p_mea_information20
      ,p_mea_information21             => p_mea_information21
      ,p_mea_information22             => p_mea_information22
      ,p_mea_information23             => p_mea_information23
      ,p_mea_information24             => p_mea_information24
      ,p_mea_information25             => p_mea_information25
      ,p_mea_information26             => p_mea_information26
      ,p_mea_information27             => p_mea_information27
      ,p_mea_information28             => p_mea_information28
      ,p_mea_information29             => p_mea_information29
      ,p_mea_information30             => p_mea_information30);

Line: 794


        (p_module_name => 'update_medical_assessment_a'
        ,p_hook_type   => 'AP');

Line: 822


    ROLLBACK TO update_medical_assessment;

Line: 834


    ROLLBACK TO update_medical_assessment;

Line: 844


END update_medical_assessment;

Line: 850


PROCEDURE delete_medical_assessment
  (p_validate                      IN     BOOLEAN  DEFAULT FALSE
  ,p_medical_assessment_id         IN     NUMBER
  ,p_object_version_number         IN     NUMBER
  ) IS
  --
  -- Declare cursors and local variables
  --
  l_proc VARCHAR2(72) := g_package||'delete_medical_assessment';

Line: 866


  SAVEPOINT delete_medical_assessment;

Line: 872


    per_medical_assessment_bk3.delete_medical_assessment_b
     (p_medical_assessment_id => p_medical_assessment_id
     ,p_object_version_number => p_object_version_number);

Line: 881


         (p_module_name => 'delete_medical_assessment_b'
         ,p_hook_type   => 'BP');

Line: 901


    per_medical_assessment_bk3.delete_medical_assessment_a
      (p_medical_assessment_id => p_medical_assessment_id
      ,p_object_version_number => p_object_version_number);

Line: 910


        (p_module_name  => 'delete_medical_assessment_a'
        ,p_hook_type   => 'AP');

Line: 932


    ROLLBACK TO delete_medical_assessment;

Line: 938


    ROLLBACK TO delete_medical_assessment;

Line: 942


END delete_medical_assessment;