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 dependencies on HR_TRANSACTION_SWI

Line 686: l_object_version_number := hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectVersionNumber');

682: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
683:
684: l_commitElement := xmldom.makeElement(l_CommitNode);
685: l_postState := xmldom.getAttribute(l_commitElement, 'PS');
686: l_object_version_number := hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectVersionNumber');
687:
688: -- overiding for poststate
689: -- CancelMode
690: if(l_postState = '2') then

Line 693: /*lv_action:= hr_xml_util.get_node_value(hr_transaction_swi.g_txn_ctx.TRANSACTION_ID,'AbsenceAction','Transaction/TransCtx/CNode',

689: -- CancelMode
690: if(l_postState = '2') then
691: -- Check if the transaction is for delete
692: begin
693: /*lv_action:= hr_xml_util.get_node_value(hr_transaction_swi.g_txn_ctx.TRANSACTION_ID,'AbsenceAction','Transaction/TransCtx/CNode',
694: NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);*/
695: null;
696: end;
697: if(lv_action='CancelMode') then

Line 706: l_absence_attendance_id := hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceId',null);

702:
703:
704: if l_postState = '0' then
705:
706: l_absence_attendance_id := hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceId',null);
707: l_medical_id := hr_transaction_swi.getNumberValue(l_CommitNode,'MedicalId',null);
708:
709: create_gb_absence_evidence
710: (p_validate => p_validate

Line 707: l_medical_id := hr_transaction_swi.getNumberValue(l_CommitNode,'MedicalId',null);

703:
704: if l_postState = '0' then
705:
706: l_absence_attendance_id := hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceId',null);
707: l_medical_id := hr_transaction_swi.getNumberValue(l_CommitNode,'MedicalId',null);
708:
709: create_gb_absence_evidence
710: (p_validate => p_validate
711: ,p_effective_date => p_effective_date

Line 712: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId',null)

708:
709: create_gb_absence_evidence
710: (p_validate => p_validate
711: ,p_effective_date => p_effective_date
712: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId',null)
713: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',null)
714: ,p_medical_id => l_medical_id
715: ,p_absence_attendance_id => l_absence_attendance_id
716: ,p_evidence_source => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EvidenceSource',null)

Line 713: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',null)

709: create_gb_absence_evidence
710: (p_validate => p_validate
711: ,p_effective_date => p_effective_date
712: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId',null)
713: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',null)
714: ,p_medical_id => l_medical_id
715: ,p_absence_attendance_id => l_absence_attendance_id
716: ,p_evidence_source => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EvidenceSource',null)
717: ,p_evidence_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EvidenceStatus',null)

Line 716: ,p_evidence_source => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EvidenceSource',null)

712: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId',null)
713: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',null)
714: ,p_medical_id => l_medical_id
715: ,p_absence_attendance_id => l_absence_attendance_id
716: ,p_evidence_source => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EvidenceSource',null)
717: ,p_evidence_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EvidenceStatus',null)
718: ,p_medical_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MedicalType',null)
719: ,p_evidence_details => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EvidenceDetails',null)
720: ,p_evidence_date => hr_transaction_swi.getDateValue(l_CommitNode,'EvidenceDate',null)

Line 717: ,p_evidence_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EvidenceStatus',null)

713: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',null)
714: ,p_medical_id => l_medical_id
715: ,p_absence_attendance_id => l_absence_attendance_id
716: ,p_evidence_source => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EvidenceSource',null)
717: ,p_evidence_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EvidenceStatus',null)
718: ,p_medical_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MedicalType',null)
719: ,p_evidence_details => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EvidenceDetails',null)
720: ,p_evidence_date => hr_transaction_swi.getDateValue(l_CommitNode,'EvidenceDate',null)
721: ,p_evidence_received_date => hr_transaction_swi.getDateValue(l_CommitNode,'EvidenceReceivedDate',null)

Line 718: ,p_medical_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MedicalType',null)

714: ,p_medical_id => l_medical_id
715: ,p_absence_attendance_id => l_absence_attendance_id
716: ,p_evidence_source => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EvidenceSource',null)
717: ,p_evidence_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EvidenceStatus',null)
718: ,p_medical_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MedicalType',null)
719: ,p_evidence_details => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EvidenceDetails',null)
720: ,p_evidence_date => hr_transaction_swi.getDateValue(l_CommitNode,'EvidenceDate',null)
721: ,p_evidence_received_date => hr_transaction_swi.getDateValue(l_CommitNode,'EvidenceReceivedDate',null)
722: ,p_predicted_fitness_date => hr_transaction_swi.getDateValue(l_CommitNode,'PredictedFitnessDate',null)

Line 719: ,p_evidence_details => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EvidenceDetails',null)

715: ,p_absence_attendance_id => l_absence_attendance_id
716: ,p_evidence_source => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EvidenceSource',null)
717: ,p_evidence_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EvidenceStatus',null)
718: ,p_medical_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MedicalType',null)
719: ,p_evidence_details => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EvidenceDetails',null)
720: ,p_evidence_date => hr_transaction_swi.getDateValue(l_CommitNode,'EvidenceDate',null)
721: ,p_evidence_received_date => hr_transaction_swi.getDateValue(l_CommitNode,'EvidenceReceivedDate',null)
722: ,p_predicted_fitness_date => hr_transaction_swi.getDateValue(l_CommitNode,'PredictedFitnessDate',null)
723: ,p_self_certificate => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SelfCertificate',null)

Line 720: ,p_evidence_date => hr_transaction_swi.getDateValue(l_CommitNode,'EvidenceDate',null)

716: ,p_evidence_source => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EvidenceSource',null)
717: ,p_evidence_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EvidenceStatus',null)
718: ,p_medical_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MedicalType',null)
719: ,p_evidence_details => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EvidenceDetails',null)
720: ,p_evidence_date => hr_transaction_swi.getDateValue(l_CommitNode,'EvidenceDate',null)
721: ,p_evidence_received_date => hr_transaction_swi.getDateValue(l_CommitNode,'EvidenceReceivedDate',null)
722: ,p_predicted_fitness_date => hr_transaction_swi.getDateValue(l_CommitNode,'PredictedFitnessDate',null)
723: ,p_self_certificate => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SelfCertificate',null)
724: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)

Line 721: ,p_evidence_received_date => hr_transaction_swi.getDateValue(l_CommitNode,'EvidenceReceivedDate',null)

717: ,p_evidence_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EvidenceStatus',null)
718: ,p_medical_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MedicalType',null)
719: ,p_evidence_details => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EvidenceDetails',null)
720: ,p_evidence_date => hr_transaction_swi.getDateValue(l_CommitNode,'EvidenceDate',null)
721: ,p_evidence_received_date => hr_transaction_swi.getDateValue(l_CommitNode,'EvidenceReceivedDate',null)
722: ,p_predicted_fitness_date => hr_transaction_swi.getDateValue(l_CommitNode,'PredictedFitnessDate',null)
723: ,p_self_certificate => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SelfCertificate',null)
724: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
725: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)

Line 722: ,p_predicted_fitness_date => hr_transaction_swi.getDateValue(l_CommitNode,'PredictedFitnessDate',null)

718: ,p_medical_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MedicalType',null)
719: ,p_evidence_details => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EvidenceDetails',null)
720: ,p_evidence_date => hr_transaction_swi.getDateValue(l_CommitNode,'EvidenceDate',null)
721: ,p_evidence_received_date => hr_transaction_swi.getDateValue(l_CommitNode,'EvidenceReceivedDate',null)
722: ,p_predicted_fitness_date => hr_transaction_swi.getDateValue(l_CommitNode,'PredictedFitnessDate',null)
723: ,p_self_certificate => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SelfCertificate',null)
724: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
725: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
726: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)

Line 723: ,p_self_certificate => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SelfCertificate',null)

719: ,p_evidence_details => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EvidenceDetails',null)
720: ,p_evidence_date => hr_transaction_swi.getDateValue(l_CommitNode,'EvidenceDate',null)
721: ,p_evidence_received_date => hr_transaction_swi.getDateValue(l_CommitNode,'EvidenceReceivedDate',null)
722: ,p_predicted_fitness_date => hr_transaction_swi.getDateValue(l_CommitNode,'PredictedFitnessDate',null)
723: ,p_self_certificate => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SelfCertificate',null)
724: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
725: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
726: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
727: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)

Line 724: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)

720: ,p_evidence_date => hr_transaction_swi.getDateValue(l_CommitNode,'EvidenceDate',null)
721: ,p_evidence_received_date => hr_transaction_swi.getDateValue(l_CommitNode,'EvidenceReceivedDate',null)
722: ,p_predicted_fitness_date => hr_transaction_swi.getDateValue(l_CommitNode,'PredictedFitnessDate',null)
723: ,p_self_certificate => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SelfCertificate',null)
724: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
725: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
726: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
727: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
728: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)

Line 725: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)

721: ,p_evidence_received_date => hr_transaction_swi.getDateValue(l_CommitNode,'EvidenceReceivedDate',null)
722: ,p_predicted_fitness_date => hr_transaction_swi.getDateValue(l_CommitNode,'PredictedFitnessDate',null)
723: ,p_self_certificate => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SelfCertificate',null)
724: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
725: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
726: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
727: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
728: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
729: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)

Line 726: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)

722: ,p_predicted_fitness_date => hr_transaction_swi.getDateValue(l_CommitNode,'PredictedFitnessDate',null)
723: ,p_self_certificate => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SelfCertificate',null)
724: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
725: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
726: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
727: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
728: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
729: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
730: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)

Line 727: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)

723: ,p_self_certificate => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SelfCertificate',null)
724: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
725: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
726: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
727: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
728: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
729: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
730: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
731: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)

Line 728: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)

724: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
725: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
726: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
727: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
728: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
729: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
730: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
731: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
732: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)

Line 729: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)

725: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
726: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
727: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
728: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
729: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
730: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
731: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
732: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
733: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)

Line 730: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)

726: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
727: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
728: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
729: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
730: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
731: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
732: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
733: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
734: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)

Line 731: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)

727: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
728: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
729: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
730: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
731: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
732: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
733: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
734: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
735: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)

Line 732: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)

728: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
729: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
730: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
731: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
732: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
733: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
734: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
735: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
736: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)

Line 733: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)

729: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
730: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
731: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
732: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
733: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
734: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
735: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
736: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
737: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)

Line 734: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)

730: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
731: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
732: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
733: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
734: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
735: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
736: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
737: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
738: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)

Line 735: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)

731: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
732: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
733: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
734: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
735: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
736: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
737: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
738: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
739: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)

Line 736: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)

732: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
733: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
734: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
735: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
736: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
737: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
738: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
739: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
740: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)

Line 737: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)

733: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
734: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
735: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
736: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
737: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
738: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
739: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
740: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
741: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)

Line 738: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)

734: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
735: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
736: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
737: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
738: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
739: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
740: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
741: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
742: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)

Line 739: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)

735: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
736: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
737: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
738: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
739: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
740: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
741: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
742: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
743: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)

Line 740: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)

736: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
737: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
738: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
739: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
740: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
741: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
742: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
743: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
744: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)

Line 741: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)

737: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
738: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
739: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
740: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
741: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
742: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
743: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
744: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
745: ,p_object_version_number => l_object_version_number

Line 742: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)

738: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
739: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
740: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
741: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
742: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
743: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
744: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
745: ,p_object_version_number => l_object_version_number
746: ,p_return_status => l_return_status

Line 743: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)

739: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
740: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
741: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
742: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
743: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
744: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
745: ,p_object_version_number => l_object_version_number
746: ,p_return_status => l_return_status
747: );

Line 744: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)

740: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
741: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
742: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
743: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
744: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
745: ,p_object_version_number => l_object_version_number
746: ,p_return_status => l_return_status
747: );
748:

Line 751: l_medical_id := hr_transaction_swi.getNumberValue(l_CommitNode,'MedicalId',null);

747: );
748:
749: elsif l_postState = '2' then
750:
751: l_medical_id := hr_transaction_swi.getNumberValue(l_CommitNode,'MedicalId',null);
752:
753: update_gb_absence_evidence
754: (p_validate => p_validate
755: ,p_effective_date => p_effective_date

Line 759: ,p_evidence_date => hr_transaction_swi.getDateValue(l_CommitNode,'EvidenceDate')

755: ,p_effective_date => p_effective_date
756: ,p_person_id => null
757: ,p_business_group_id => null
758: ,p_absence_attendance_type_id => null
759: ,p_evidence_date => hr_transaction_swi.getDateValue(l_CommitNode,'EvidenceDate')
760: ,p_evidence_source => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EvidenceSource')
761: ,p_absence_attendance_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceId')
762: ,p_maternity_id => null
763: ,p_medical_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MedicalType')

Line 760: ,p_evidence_source => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EvidenceSource')

756: ,p_person_id => null
757: ,p_business_group_id => null
758: ,p_absence_attendance_type_id => null
759: ,p_evidence_date => hr_transaction_swi.getDateValue(l_CommitNode,'EvidenceDate')
760: ,p_evidence_source => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EvidenceSource')
761: ,p_absence_attendance_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceId')
762: ,p_maternity_id => null
763: ,p_medical_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MedicalType')
764: ,p_self_certificate => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SelfCertificate')

Line 761: ,p_absence_attendance_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceId')

757: ,p_business_group_id => null
758: ,p_absence_attendance_type_id => null
759: ,p_evidence_date => hr_transaction_swi.getDateValue(l_CommitNode,'EvidenceDate')
760: ,p_evidence_source => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EvidenceSource')
761: ,p_absence_attendance_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceId')
762: ,p_maternity_id => null
763: ,p_medical_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MedicalType')
764: ,p_self_certificate => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SelfCertificate')
765: ,p_predicted_fitness_date => hr_transaction_swi.getDateValue(l_CommitNode,'PredictedFitnessDate')

Line 763: ,p_medical_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MedicalType')

759: ,p_evidence_date => hr_transaction_swi.getDateValue(l_CommitNode,'EvidenceDate')
760: ,p_evidence_source => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EvidenceSource')
761: ,p_absence_attendance_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceId')
762: ,p_maternity_id => null
763: ,p_medical_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MedicalType')
764: ,p_self_certificate => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SelfCertificate')
765: ,p_predicted_fitness_date => hr_transaction_swi.getDateValue(l_CommitNode,'PredictedFitnessDate')
766: ,p_evidence_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EvidenceStatus')
767: ,p_evidence_details => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EvidenceDetails')

Line 764: ,p_self_certificate => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SelfCertificate')

760: ,p_evidence_source => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EvidenceSource')
761: ,p_absence_attendance_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceId')
762: ,p_maternity_id => null
763: ,p_medical_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MedicalType')
764: ,p_self_certificate => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SelfCertificate')
765: ,p_predicted_fitness_date => hr_transaction_swi.getDateValue(l_CommitNode,'PredictedFitnessDate')
766: ,p_evidence_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EvidenceStatus')
767: ,p_evidence_details => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EvidenceDetails')
768: ,p_accept_late_evidence_flag => null

Line 765: ,p_predicted_fitness_date => hr_transaction_swi.getDateValue(l_CommitNode,'PredictedFitnessDate')

761: ,p_absence_attendance_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceId')
762: ,p_maternity_id => null
763: ,p_medical_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MedicalType')
764: ,p_self_certificate => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SelfCertificate')
765: ,p_predicted_fitness_date => hr_transaction_swi.getDateValue(l_CommitNode,'PredictedFitnessDate')
766: ,p_evidence_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EvidenceStatus')
767: ,p_evidence_details => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EvidenceDetails')
768: ,p_accept_late_evidence_flag => null
769: ,p_reason_for_late_evidence => null

Line 766: ,p_evidence_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EvidenceStatus')

762: ,p_maternity_id => null
763: ,p_medical_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MedicalType')
764: ,p_self_certificate => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SelfCertificate')
765: ,p_predicted_fitness_date => hr_transaction_swi.getDateValue(l_CommitNode,'PredictedFitnessDate')
766: ,p_evidence_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EvidenceStatus')
767: ,p_evidence_details => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EvidenceDetails')
768: ,p_accept_late_evidence_flag => null
769: ,p_reason_for_late_evidence => null
770: ,p_evidence_received_date => hr_transaction_swi.getDateValue(l_CommitNode,'EvidenceReceivedDate')

Line 767: ,p_evidence_details => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EvidenceDetails')

763: ,p_medical_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MedicalType')
764: ,p_self_certificate => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SelfCertificate')
765: ,p_predicted_fitness_date => hr_transaction_swi.getDateValue(l_CommitNode,'PredictedFitnessDate')
766: ,p_evidence_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EvidenceStatus')
767: ,p_evidence_details => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EvidenceDetails')
768: ,p_accept_late_evidence_flag => null
769: ,p_reason_for_late_evidence => null
770: ,p_evidence_received_date => hr_transaction_swi.getDateValue(l_CommitNode,'EvidenceReceivedDate')
771: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')

Line 770: ,p_evidence_received_date => hr_transaction_swi.getDateValue(l_CommitNode,'EvidenceReceivedDate')

766: ,p_evidence_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EvidenceStatus')
767: ,p_evidence_details => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EvidenceDetails')
768: ,p_accept_late_evidence_flag => null
769: ,p_reason_for_late_evidence => null
770: ,p_evidence_received_date => hr_transaction_swi.getDateValue(l_CommitNode,'EvidenceReceivedDate')
771: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
772: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
773: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
774: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')

Line 771: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')

767: ,p_evidence_details => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EvidenceDetails')
768: ,p_accept_late_evidence_flag => null
769: ,p_reason_for_late_evidence => null
770: ,p_evidence_received_date => hr_transaction_swi.getDateValue(l_CommitNode,'EvidenceReceivedDate')
771: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
772: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
773: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
774: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
775: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')

Line 772: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')

768: ,p_accept_late_evidence_flag => null
769: ,p_reason_for_late_evidence => null
770: ,p_evidence_received_date => hr_transaction_swi.getDateValue(l_CommitNode,'EvidenceReceivedDate')
771: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
772: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
773: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
774: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
775: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
776: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')

Line 773: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')

769: ,p_reason_for_late_evidence => null
770: ,p_evidence_received_date => hr_transaction_swi.getDateValue(l_CommitNode,'EvidenceReceivedDate')
771: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
772: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
773: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
774: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
775: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
776: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
777: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')

Line 774: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')

770: ,p_evidence_received_date => hr_transaction_swi.getDateValue(l_CommitNode,'EvidenceReceivedDate')
771: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
772: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
773: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
774: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
775: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
776: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
777: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
778: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')

Line 775: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')

771: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
772: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
773: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
774: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
775: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
776: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
777: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
778: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
779: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')

Line 776: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')

772: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
773: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
774: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
775: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
776: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
777: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
778: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
779: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
780: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')

Line 777: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')

773: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
774: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
775: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
776: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
777: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
778: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
779: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
780: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
781: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')

Line 778: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')

774: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
775: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
776: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
777: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
778: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
779: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
780: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
781: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
782: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')

Line 779: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')

775: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
776: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
777: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
778: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
779: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
780: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
781: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
782: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
783: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')

Line 780: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')

776: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
777: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
778: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
779: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
780: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
781: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
782: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
783: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
784: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')

Line 781: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')

777: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
778: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
779: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
780: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
781: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
782: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
783: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
784: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
785: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')

Line 782: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')

778: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
779: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
780: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
781: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
782: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
783: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
784: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
785: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
786: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')

Line 783: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')

779: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
780: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
781: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
782: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
783: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
784: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
785: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
786: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
787: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')

Line 784: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')

780: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
781: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
782: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
783: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
784: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
785: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
786: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
787: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
788: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')

Line 785: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')

781: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
782: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
783: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
784: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
785: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
786: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
787: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
788: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
789: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')

Line 786: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')

782: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
783: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
784: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
785: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
786: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
787: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
788: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
789: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
790: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')

Line 787: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')

783: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
784: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
785: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
786: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
787: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
788: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
789: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
790: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
791: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')

Line 788: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')

784: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
785: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
786: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
787: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
788: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
789: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
790: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
791: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
792: ,p_medical_id => l_medical_id

Line 789: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')

785: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
786: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
787: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
788: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
789: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
790: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
791: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
792: ,p_medical_id => l_medical_id
793: ,p_object_version_number => l_object_version_number

Line 790: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')

786: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
787: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
788: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
789: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
790: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
791: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
792: ,p_medical_id => l_medical_id
793: ,p_object_version_number => l_object_version_number
794: ,p_return_status => l_return_status

Line 791: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')

787: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
788: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
789: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
790: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
791: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
792: ,p_medical_id => l_medical_id
793: ,p_object_version_number => l_object_version_number
794: ,p_return_status => l_return_status
795: );

Line 801: ,p_absence_attendance_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceId')

797: elsif l_postState = '3' then
798:
799: delete_gb_absence_evidence
800: (p_validate => p_validate
801: ,p_absence_attendance_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceId')
802: ,p_medical_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MedicalId')
803: ,p_object_version_number => l_object_version_number
804: ,p_return_status => l_return_status
805: );

Line 802: ,p_medical_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MedicalId')

798:
799: delete_gb_absence_evidence
800: (p_validate => p_validate
801: ,p_absence_attendance_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AbsenceAttendanceId')
802: ,p_medical_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MedicalId')
803: ,p_object_version_number => l_object_version_number
804: ,p_return_status => l_return_status
805: );
806: