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

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

Line: 19


   select absence_category
   from per_absence_attendance_types
   where absence_attendance_type_id = p_absence_attendance_type_id;

Line: 100


  select 1 from ssp_medicals
  where absence_attendance_id = p_abs_attd_id
  and evidence_date > p_evid_date;

Line: 140


        update ssp_medicals
        set evidence_status='SUPERCEDED'
        where absence_attendance_id = p_absence_attendance_id
        and evidence_status = 'CURRENT'
        and evidence_date < p_evidence_date;

Line: 148


        insert into ssp_medicals
        (MEDICAL_ID,
        OBJECT_VERSION_NUMBER,
        EVIDENCE_DATE,
        EVIDENCE_SOURCE,
        ABSENCE_ATTENDANCE_ID,
        MATERNITY_ID,
        MEDICAL_TYPE,
        SELF_CERTIFICATE,
        PREDICTED_FITNESS_DATE,
        EVIDENCE_STATUS,
        EVIDENCE_DETAILS,
        ACCEPT_LATE_EVIDENCE_FLAG,
        REASON_FOR_LATE_EVIDENCE,
        EVIDENCE_RECEIVED_DATE,
        ATTRIBUTE_CATEGORY,
        ATTRIBUTE1,
        ATTRIBUTE2,
        ATTRIBUTE3,
        ATTRIBUTE4,
        ATTRIBUTE5,
        ATTRIBUTE6,
        ATTRIBUTE7,
        ATTRIBUTE8,
        ATTRIBUTE9,
        ATTRIBUTE10,
        ATTRIBUTE11,
        ATTRIBUTE12,
        ATTRIBUTE13,
        ATTRIBUTE14,
        ATTRIBUTE15,
        ATTRIBUTE16,
        ATTRIBUTE17,
        ATTRIBUTE18,
        ATTRIBUTE19,
        ATTRIBUTE20,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_DATE,
        LAST_UPDATE_LOGIN)
        values
        (p_medical_id, -- ssp_medicals_s.nextval,
        p_object_version_number,
        trunc(p_evidence_date),
        p_evidence_source,
        p_absence_attendance_id,
        null,
        p_medical_type,
        p_self_certificate,
        trunc(p_predicted_fitness_date),
        l_evidence_status,
        p_evidence_details,
        p_accept_late_evidence_flag,
        p_reason_for_late_evidence,
        trunc(p_evidence_received_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,
        -1,
        trunc(sysdate),
        -1,
        trunc(sysdate),
        -1);

Line: 283


PROCEDURE update_gb_absence_evidence
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_effective_date               in     date default hr_api.g_date
  ,p_person_id                    in     number default hr_api.g_number
  ,p_business_group_id            in     number default hr_api.g_number
  ,p_absence_attendance_type_id   in     number default hr_api.g_number
  ,p_evidence_date in date default hr_api.g_date
  ,p_evidence_source in varchar2 default hr_api.g_varchar2
  ,p_absence_attendance_id        in     number   default hr_api.g_number
  ,p_maternity_id in number default hr_api.g_number
  ,p_medical_type in varchar2 default hr_api.g_varchar2
  ,p_self_certificate in varchar2 default hr_api.g_varchar2
  ,p_predicted_fitness_date in date default hr_api.g_date
  ,p_evidence_status in varchar2 default hr_api.g_varchar2
  ,p_evidence_details in varchar2 default hr_api.g_varchar2
  ,p_accept_late_evidence_flag in varchar2 default hr_api.g_varchar2
  ,p_reason_for_late_evidence in varchar2 default hr_api.g_varchar2
  ,p_evidence_received_date in date default hr_api.g_date
  ,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_medical_id in out nocopy number
  ,p_object_version_number           out nocopy number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 338


   select absence_attendance_type_id, business_group_id
   from per_absence_attendances
   where absence_attendance_id = p_absence_attendance_id;

Line: 344


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

Line: 350


   select * from ssp_medicals
   where medical_id = p_medical_id;

Line: 360


  savepoint update_gb_absence_swi;

Line: 479


       update ssp_medicals set
       evidence_source = ssp_rec.evidence_source
       ,evidence_date = ssp_rec.evidence_date
       ,evidence_details = ssp_rec.evidence_details
       ,evidence_received_date = ssp_rec.evidence_received_date
       ,evidence_status = ssp_rec.evidence_status
       ,predicted_fitness_date = ssp_rec.predicted_fitness_date
       ,self_certificate = ssp_rec.self_certificate
       ,attribute_category = ssp_rec.attribute_category
       ,attribute1 = ssp_rec.attribute1
       ,attribute2 = ssp_rec.attribute2
       ,attribute3 = ssp_rec.attribute3
       ,attribute4 = ssp_rec.attribute4
       ,attribute5 = ssp_rec.attribute5
       ,attribute6 = ssp_rec.attribute6
       ,attribute7 = ssp_rec.attribute7
       ,attribute8 = ssp_rec.attribute8
       ,attribute9 = ssp_rec.attribute9
       ,attribute10 = ssp_rec.attribute10
       ,attribute11 = ssp_rec.attribute11
       ,attribute12 = ssp_rec.attribute12
       ,attribute13 = ssp_rec.attribute13
       ,attribute14 = ssp_rec.attribute14
       ,attribute15 = ssp_rec.attribute15
       ,attribute16 = ssp_rec.attribute16
       ,attribute17 = ssp_rec.attribute17
       ,attribute18 = ssp_rec.attribute18
       ,attribute19 = ssp_rec.attribute19
       ,attribute20 = ssp_rec.attribute20
       where MEDICAL_ID=p_medical_id;

Line: 538


    rollback to update_gb_absence_swi;

Line: 556


end update_gb_absence_evidence;

Line: 560


PROCEDURE delete_gb_absence_evidence
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_absence_attendance_id        in     number
  ,p_medical_id        in     number
  ,p_object_version_number        in     number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 574


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

Line: 582


  savepoint delete_gb_absence_swi;

Line: 598


     delete from ssp_medicals where medical_id = p_medical_id;

Line: 603


/*  hr_person_absence_api.delete_person_absence
    (p_validate                     => l_validate
    ,p_absence_attendance_id        => p_absence_attendance_id
    ,p_object_version_number        => p_object_version_number
    );*/

Line: 632


    rollback to delete_gb_absence_swi;

Line: 642


end delete_gb_absence_evidence;

Line: 669


   select absence_days, absence_hours
   from per_absence_attendances
   where absence_attendance_id = p_absence_attendance_id;

Line: 753


update_gb_absence_evidence
  (p_validate            => p_validate
  ,p_effective_date      =>  p_effective_date
  ,p_person_id           =>  null
  ,p_business_group_id   => null
  ,p_absence_attendance_type_id  => null
  ,p_evidence_date       => hr_transaction_swi.getDateValue(l_CommitNode,'EvidenceDate')
  ,p_evidence_source     => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EvidenceSource')
  ,p_absence_attendance_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceId')
  ,p_maternity_id        => null
  ,p_medical_type        => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MedicalType')
  ,p_self_certificate    => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SelfCertificate')
  ,p_predicted_fitness_date => hr_transaction_swi.getDateValue(l_CommitNode,'PredictedFitnessDate')
  ,p_evidence_status     => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EvidenceStatus')
  ,p_evidence_details    => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EvidenceDetails')
  ,p_accept_late_evidence_flag => null
  ,p_reason_for_late_evidence  => null
  ,p_evidence_received_date => hr_transaction_swi.getDateValue(l_CommitNode,'EvidenceReceivedDate')
  ,p_attribute_category  => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
  ,p_attribute1          => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
  ,p_attribute2          => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
  ,p_attribute3          => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
  ,p_attribute4          => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
  ,p_attribute5          => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
  ,p_attribute6          => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
  ,p_attribute7          => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
  ,p_attribute8          => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
  ,p_attribute9          => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
  ,p_attribute10         => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
  ,p_attribute11         => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
  ,p_attribute12         => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
  ,p_attribute13         => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
  ,p_attribute14         => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
  ,p_attribute15         => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
  ,p_attribute16         => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
  ,p_attribute17         => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
  ,p_attribute18         => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
  ,p_attribute19         => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
  ,p_attribute20         => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
  ,p_medical_id          => l_medical_id
  ,p_object_version_number  => l_object_version_number
  ,p_return_status          => l_return_status
  );

Line: 799


			delete_gb_absence_evidence
			  (p_validate               => p_validate
			  ,p_absence_attendance_id  => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceId')
			  ,p_medical_id             => hr_transaction_swi.getNumberValue(l_CommitNode,'MedicalId')
			  ,p_object_version_number  => l_object_version_number
			  ,p_return_status          => l_return_status
			  );