665: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
666:
667: l_commitElement := xmldom.makeElement(l_CommitNode);
668: l_postState := xmldom.getAttribute(l_commitElement, 'PS');
669: l_object_version_number := hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectVersionNumber');
670:
671: if l_postState = '0' then
672:
673: create_element_outcome
672:
673: create_element_outcome
674: (p_validate => p_validate
675: ,p_effective_date => p_effective_date
676: ,p_competence_element_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceElementId',null)
677: ,p_outcome_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OutcomeId',null)
678: ,p_date_from => hr_transaction_swi.getDateValue(l_CommitNode,'DateFrom',null)
679: ,p_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'DateTo',null)
680: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
673: create_element_outcome
674: (p_validate => p_validate
675: ,p_effective_date => p_effective_date
676: ,p_competence_element_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceElementId',null)
677: ,p_outcome_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OutcomeId',null)
678: ,p_date_from => hr_transaction_swi.getDateValue(l_CommitNode,'DateFrom',null)
679: ,p_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'DateTo',null)
680: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
681: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
674: (p_validate => p_validate
675: ,p_effective_date => p_effective_date
676: ,p_competence_element_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceElementId',null)
677: ,p_outcome_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OutcomeId',null)
678: ,p_date_from => hr_transaction_swi.getDateValue(l_CommitNode,'DateFrom',null)
679: ,p_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'DateTo',null)
680: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
681: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
682: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
675: ,p_effective_date => p_effective_date
676: ,p_competence_element_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceElementId',null)
677: ,p_outcome_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OutcomeId',null)
678: ,p_date_from => hr_transaction_swi.getDateValue(l_CommitNode,'DateFrom',null)
679: ,p_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'DateTo',null)
680: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
681: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
682: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
683: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
676: ,p_competence_element_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceElementId',null)
677: ,p_outcome_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OutcomeId',null)
678: ,p_date_from => hr_transaction_swi.getDateValue(l_CommitNode,'DateFrom',null)
679: ,p_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'DateTo',null)
680: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
681: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
682: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
683: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
684: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
677: ,p_outcome_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OutcomeId',null)
678: ,p_date_from => hr_transaction_swi.getDateValue(l_CommitNode,'DateFrom',null)
679: ,p_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'DateTo',null)
680: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
681: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
682: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
683: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
684: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
685: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
678: ,p_date_from => hr_transaction_swi.getDateValue(l_CommitNode,'DateFrom',null)
679: ,p_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'DateTo',null)
680: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
681: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
682: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
683: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
684: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
685: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
686: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
679: ,p_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'DateTo',null)
680: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
681: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
682: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
683: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
684: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
685: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
686: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
687: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
680: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
681: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
682: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
683: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
684: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
685: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
686: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
687: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
688: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
681: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
682: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
683: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
684: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
685: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
686: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
687: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
688: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
689: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
682: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
683: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
684: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
685: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
686: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
687: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
688: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
689: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
690: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
683: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
684: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
685: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
686: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
687: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
688: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
689: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
690: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
691: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
684: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
685: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
686: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
687: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
688: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
689: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
690: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
691: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
692: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
685: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
686: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
687: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
688: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
689: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
690: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
691: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
692: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
693: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
686: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
687: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
688: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
689: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
690: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
691: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
692: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
693: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
694: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
687: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
688: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
689: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
690: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
691: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
692: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
693: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
694: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
695: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
688: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
689: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
690: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
691: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
692: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
693: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
694: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
695: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
696: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
689: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
690: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
691: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
692: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
693: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
694: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
695: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
696: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
697: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
690: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
691: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
692: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
693: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
694: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
695: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
696: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
697: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
698: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
691: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
692: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
693: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
694: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
695: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
696: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
697: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
698: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
699: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
692: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
693: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
694: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
695: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
696: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
697: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
698: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
699: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
700: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
693: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
694: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
695: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
696: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
697: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
698: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
699: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
700: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
701: ,p_information_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'InformationCategory',null)
694: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
695: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
696: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
697: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
698: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
699: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
700: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
701: ,p_information_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'InformationCategory',null)
702: ,p_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information1',null)
695: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
696: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
697: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
698: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
699: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
700: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
701: ,p_information_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'InformationCategory',null)
702: ,p_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information1',null)
703: ,p_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information2',null)
696: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
697: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
698: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
699: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
700: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
701: ,p_information_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'InformationCategory',null)
702: ,p_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information1',null)
703: ,p_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information2',null)
704: ,p_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information3',null)
697: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
698: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
699: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
700: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
701: ,p_information_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'InformationCategory',null)
702: ,p_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information1',null)
703: ,p_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information2',null)
704: ,p_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information3',null)
705: ,p_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information4',null)
698: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
699: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
700: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
701: ,p_information_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'InformationCategory',null)
702: ,p_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information1',null)
703: ,p_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information2',null)
704: ,p_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information3',null)
705: ,p_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information4',null)
706: ,p_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information5',null)
699: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
700: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
701: ,p_information_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'InformationCategory',null)
702: ,p_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information1',null)
703: ,p_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information2',null)
704: ,p_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information3',null)
705: ,p_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information4',null)
706: ,p_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information5',null)
707: ,p_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information6',null)
700: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
701: ,p_information_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'InformationCategory',null)
702: ,p_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information1',null)
703: ,p_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information2',null)
704: ,p_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information3',null)
705: ,p_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information4',null)
706: ,p_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information5',null)
707: ,p_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information6',null)
708: ,p_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information7',null)
701: ,p_information_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'InformationCategory',null)
702: ,p_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information1',null)
703: ,p_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information2',null)
704: ,p_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information3',null)
705: ,p_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information4',null)
706: ,p_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information5',null)
707: ,p_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information6',null)
708: ,p_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information7',null)
709: ,p_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information8',null)
702: ,p_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information1',null)
703: ,p_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information2',null)
704: ,p_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information3',null)
705: ,p_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information4',null)
706: ,p_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information5',null)
707: ,p_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information6',null)
708: ,p_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information7',null)
709: ,p_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information8',null)
710: ,p_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information9',null)
703: ,p_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information2',null)
704: ,p_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information3',null)
705: ,p_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information4',null)
706: ,p_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information5',null)
707: ,p_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information6',null)
708: ,p_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information7',null)
709: ,p_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information8',null)
710: ,p_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information9',null)
711: ,p_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information10',null)
704: ,p_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information3',null)
705: ,p_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information4',null)
706: ,p_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information5',null)
707: ,p_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information6',null)
708: ,p_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information7',null)
709: ,p_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information8',null)
710: ,p_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information9',null)
711: ,p_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information10',null)
712: ,p_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information11',null)
705: ,p_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information4',null)
706: ,p_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information5',null)
707: ,p_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information6',null)
708: ,p_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information7',null)
709: ,p_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information8',null)
710: ,p_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information9',null)
711: ,p_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information10',null)
712: ,p_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information11',null)
713: ,p_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information12',null)
706: ,p_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information5',null)
707: ,p_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information6',null)
708: ,p_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information7',null)
709: ,p_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information8',null)
710: ,p_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information9',null)
711: ,p_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information10',null)
712: ,p_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information11',null)
713: ,p_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information12',null)
714: ,p_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information13',null)
707: ,p_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information6',null)
708: ,p_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information7',null)
709: ,p_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information8',null)
710: ,p_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information9',null)
711: ,p_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information10',null)
712: ,p_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information11',null)
713: ,p_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information12',null)
714: ,p_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information13',null)
715: ,p_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information14',null)
708: ,p_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information7',null)
709: ,p_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information8',null)
710: ,p_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information9',null)
711: ,p_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information10',null)
712: ,p_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information11',null)
713: ,p_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information12',null)
714: ,p_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information13',null)
715: ,p_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information14',null)
716: ,p_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information15',null)
709: ,p_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information8',null)
710: ,p_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information9',null)
711: ,p_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information10',null)
712: ,p_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information11',null)
713: ,p_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information12',null)
714: ,p_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information13',null)
715: ,p_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information14',null)
716: ,p_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information15',null)
717: ,p_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information16',null)
710: ,p_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information9',null)
711: ,p_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information10',null)
712: ,p_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information11',null)
713: ,p_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information12',null)
714: ,p_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information13',null)
715: ,p_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information14',null)
716: ,p_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information15',null)
717: ,p_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information16',null)
718: ,p_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information17',null)
711: ,p_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information10',null)
712: ,p_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information11',null)
713: ,p_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information12',null)
714: ,p_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information13',null)
715: ,p_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information14',null)
716: ,p_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information15',null)
717: ,p_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information16',null)
718: ,p_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information17',null)
719: ,p_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information18',null)
712: ,p_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information11',null)
713: ,p_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information12',null)
714: ,p_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information13',null)
715: ,p_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information14',null)
716: ,p_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information15',null)
717: ,p_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information16',null)
718: ,p_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information17',null)
719: ,p_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information18',null)
720: ,p_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information19',null)
713: ,p_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information12',null)
714: ,p_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information13',null)
715: ,p_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information14',null)
716: ,p_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information15',null)
717: ,p_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information16',null)
718: ,p_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information17',null)
719: ,p_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information18',null)
720: ,p_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information19',null)
721: ,p_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information20',null)
714: ,p_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information13',null)
715: ,p_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information14',null)
716: ,p_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information15',null)
717: ,p_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information16',null)
718: ,p_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information17',null)
719: ,p_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information18',null)
720: ,p_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information19',null)
721: ,p_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information20',null)
722: ,p_comp_element_outcome_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompElementOutcomeId',null)
715: ,p_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information14',null)
716: ,p_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information15',null)
717: ,p_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information16',null)
718: ,p_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information17',null)
719: ,p_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information18',null)
720: ,p_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information19',null)
721: ,p_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information20',null)
722: ,p_comp_element_outcome_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompElementOutcomeId',null)
723: ,p_object_version_number => l_object_version_number
716: ,p_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information15',null)
717: ,p_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information16',null)
718: ,p_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information17',null)
719: ,p_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information18',null)
720: ,p_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information19',null)
721: ,p_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information20',null)
722: ,p_comp_element_outcome_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompElementOutcomeId',null)
723: ,p_object_version_number => l_object_version_number
724: ,p_return_status => l_return_status
717: ,p_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information16',null)
718: ,p_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information17',null)
719: ,p_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information18',null)
720: ,p_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information19',null)
721: ,p_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information20',null)
722: ,p_comp_element_outcome_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompElementOutcomeId',null)
723: ,p_object_version_number => l_object_version_number
724: ,p_return_status => l_return_status
725: );
718: ,p_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information17',null)
719: ,p_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information18',null)
720: ,p_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information19',null)
721: ,p_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information20',null)
722: ,p_comp_element_outcome_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompElementOutcomeId',null)
723: ,p_object_version_number => l_object_version_number
724: ,p_return_status => l_return_status
725: );
726: elsif l_postState = '2' then
726: elsif l_postState = '2' then
727: update_element_outcome
728: (p_validate => p_validate
729: ,p_effective_date => p_effective_date
730: ,p_comp_element_outcome_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompElementOutcomeId')
731: ,p_object_version_number => l_object_version_number
732: ,p_competence_element_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceElementId')
733: ,p_outcome_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OutcomeId')
734: ,p_date_from => hr_transaction_swi.getDateValue(l_CommitNode,'DateFrom')
728: (p_validate => p_validate
729: ,p_effective_date => p_effective_date
730: ,p_comp_element_outcome_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompElementOutcomeId')
731: ,p_object_version_number => l_object_version_number
732: ,p_competence_element_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceElementId')
733: ,p_outcome_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OutcomeId')
734: ,p_date_from => hr_transaction_swi.getDateValue(l_CommitNode,'DateFrom')
735: ,p_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'DateTo')
736: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
729: ,p_effective_date => p_effective_date
730: ,p_comp_element_outcome_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompElementOutcomeId')
731: ,p_object_version_number => l_object_version_number
732: ,p_competence_element_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceElementId')
733: ,p_outcome_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OutcomeId')
734: ,p_date_from => hr_transaction_swi.getDateValue(l_CommitNode,'DateFrom')
735: ,p_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'DateTo')
736: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
737: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
730: ,p_comp_element_outcome_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompElementOutcomeId')
731: ,p_object_version_number => l_object_version_number
732: ,p_competence_element_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceElementId')
733: ,p_outcome_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OutcomeId')
734: ,p_date_from => hr_transaction_swi.getDateValue(l_CommitNode,'DateFrom')
735: ,p_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'DateTo')
736: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
737: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
738: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
731: ,p_object_version_number => l_object_version_number
732: ,p_competence_element_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceElementId')
733: ,p_outcome_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OutcomeId')
734: ,p_date_from => hr_transaction_swi.getDateValue(l_CommitNode,'DateFrom')
735: ,p_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'DateTo')
736: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
737: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
738: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
739: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
732: ,p_competence_element_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceElementId')
733: ,p_outcome_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OutcomeId')
734: ,p_date_from => hr_transaction_swi.getDateValue(l_CommitNode,'DateFrom')
735: ,p_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'DateTo')
736: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
737: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
738: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
739: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
740: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
733: ,p_outcome_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OutcomeId')
734: ,p_date_from => hr_transaction_swi.getDateValue(l_CommitNode,'DateFrom')
735: ,p_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'DateTo')
736: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
737: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
738: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
739: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
740: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
741: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
734: ,p_date_from => hr_transaction_swi.getDateValue(l_CommitNode,'DateFrom')
735: ,p_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'DateTo')
736: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
737: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
738: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
739: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
740: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
741: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
742: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
735: ,p_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'DateTo')
736: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
737: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
738: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
739: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
740: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
741: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
742: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
743: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
736: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
737: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
738: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
739: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
740: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
741: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
742: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
743: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
744: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
737: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
738: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
739: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
740: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
741: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
742: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
743: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
744: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
745: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
738: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
739: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
740: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
741: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
742: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
743: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
744: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
745: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
746: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
739: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
740: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
741: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
742: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
743: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
744: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
745: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
746: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
747: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
740: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
741: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
742: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
743: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
744: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
745: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
746: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
747: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
748: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
741: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
742: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
743: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
744: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
745: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
746: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
747: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
748: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
749: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
742: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
743: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
744: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
745: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
746: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
747: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
748: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
749: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
750: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
743: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
744: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
745: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
746: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
747: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
748: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
749: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
750: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
751: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
744: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
745: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
746: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
747: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
748: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
749: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
750: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
751: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
752: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
745: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
746: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
747: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
748: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
749: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
750: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
751: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
752: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
753: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
746: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
747: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
748: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
749: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
750: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
751: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
752: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
753: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
754: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
747: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
748: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
749: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
750: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
751: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
752: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
753: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
754: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
755: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
748: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
749: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
750: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
751: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
752: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
753: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
754: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
755: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
756: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
749: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
750: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
751: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
752: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
753: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
754: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
755: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
756: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
757: ,p_information_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'InformationCategory')
750: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
751: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
752: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
753: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
754: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
755: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
756: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
757: ,p_information_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'InformationCategory')
758: ,p_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information1')
751: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
752: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
753: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
754: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
755: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
756: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
757: ,p_information_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'InformationCategory')
758: ,p_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information1')
759: ,p_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information2')
752: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
753: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
754: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
755: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
756: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
757: ,p_information_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'InformationCategory')
758: ,p_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information1')
759: ,p_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information2')
760: ,p_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information3')
753: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
754: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
755: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
756: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
757: ,p_information_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'InformationCategory')
758: ,p_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information1')
759: ,p_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information2')
760: ,p_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information3')
761: ,p_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information4')
754: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
755: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
756: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
757: ,p_information_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'InformationCategory')
758: ,p_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information1')
759: ,p_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information2')
760: ,p_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information3')
761: ,p_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information4')
762: ,p_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information5')
755: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
756: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
757: ,p_information_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'InformationCategory')
758: ,p_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information1')
759: ,p_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information2')
760: ,p_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information3')
761: ,p_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information4')
762: ,p_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information5')
763: ,p_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information6')
756: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
757: ,p_information_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'InformationCategory')
758: ,p_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information1')
759: ,p_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information2')
760: ,p_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information3')
761: ,p_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information4')
762: ,p_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information5')
763: ,p_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information6')
764: ,p_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information7')
757: ,p_information_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'InformationCategory')
758: ,p_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information1')
759: ,p_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information2')
760: ,p_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information3')
761: ,p_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information4')
762: ,p_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information5')
763: ,p_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information6')
764: ,p_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information7')
765: ,p_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information8')
758: ,p_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information1')
759: ,p_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information2')
760: ,p_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information3')
761: ,p_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information4')
762: ,p_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information5')
763: ,p_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information6')
764: ,p_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information7')
765: ,p_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information8')
766: ,p_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information9')
759: ,p_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information2')
760: ,p_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information3')
761: ,p_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information4')
762: ,p_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information5')
763: ,p_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information6')
764: ,p_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information7')
765: ,p_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information8')
766: ,p_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information9')
767: ,p_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information10')
760: ,p_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information3')
761: ,p_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information4')
762: ,p_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information5')
763: ,p_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information6')
764: ,p_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information7')
765: ,p_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information8')
766: ,p_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information9')
767: ,p_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information10')
768: ,p_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information11')
761: ,p_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information4')
762: ,p_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information5')
763: ,p_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information6')
764: ,p_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information7')
765: ,p_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information8')
766: ,p_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information9')
767: ,p_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information10')
768: ,p_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information11')
769: ,p_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information12')
762: ,p_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information5')
763: ,p_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information6')
764: ,p_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information7')
765: ,p_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information8')
766: ,p_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information9')
767: ,p_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information10')
768: ,p_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information11')
769: ,p_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information12')
770: ,p_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information13')
763: ,p_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information6')
764: ,p_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information7')
765: ,p_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information8')
766: ,p_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information9')
767: ,p_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information10')
768: ,p_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information11')
769: ,p_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information12')
770: ,p_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information13')
771: ,p_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information14')
764: ,p_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information7')
765: ,p_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information8')
766: ,p_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information9')
767: ,p_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information10')
768: ,p_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information11')
769: ,p_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information12')
770: ,p_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information13')
771: ,p_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information14')
772: ,p_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information15')
765: ,p_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information8')
766: ,p_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information9')
767: ,p_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information10')
768: ,p_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information11')
769: ,p_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information12')
770: ,p_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information13')
771: ,p_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information14')
772: ,p_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information15')
773: ,p_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information16')
766: ,p_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information9')
767: ,p_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information10')
768: ,p_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information11')
769: ,p_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information12')
770: ,p_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information13')
771: ,p_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information14')
772: ,p_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information15')
773: ,p_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information16')
774: ,p_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information17')
767: ,p_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information10')
768: ,p_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information11')
769: ,p_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information12')
770: ,p_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information13')
771: ,p_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information14')
772: ,p_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information15')
773: ,p_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information16')
774: ,p_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information17')
775: ,p_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information18')
768: ,p_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information11')
769: ,p_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information12')
770: ,p_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information13')
771: ,p_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information14')
772: ,p_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information15')
773: ,p_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information16')
774: ,p_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information17')
775: ,p_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information18')
776: ,p_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information19')
769: ,p_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information12')
770: ,p_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information13')
771: ,p_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information14')
772: ,p_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information15')
773: ,p_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information16')
774: ,p_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information17')
775: ,p_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information18')
776: ,p_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information19')
777: ,p_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information20')
770: ,p_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information13')
771: ,p_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information14')
772: ,p_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information15')
773: ,p_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information16')
774: ,p_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information17')
775: ,p_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information18')
776: ,p_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information19')
777: ,p_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information20')
778: ,p_return_status => l_return_status
771: ,p_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information14')
772: ,p_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information15')
773: ,p_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information16')
774: ,p_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information17')
775: ,p_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information18')
776: ,p_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information19')
777: ,p_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information20')
778: ,p_return_status => l_return_status
779: -- ,p_datetrack_update_mode => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DatetrackUpdate',hr_api.g_correction)
772: ,p_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information15')
773: ,p_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information16')
774: ,p_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information17')
775: ,p_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information18')
776: ,p_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information19')
777: ,p_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information20')
778: ,p_return_status => l_return_status
779: -- ,p_datetrack_update_mode => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DatetrackUpdate',hr_api.g_correction)
780: );
773: ,p_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information16')
774: ,p_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information17')
775: ,p_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information18')
776: ,p_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information19')
777: ,p_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information20')
778: ,p_return_status => l_return_status
779: -- ,p_datetrack_update_mode => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DatetrackUpdate',hr_api.g_correction)
780: );
781:
775: ,p_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information18')
776: ,p_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information19')
777: ,p_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Information20')
778: ,p_return_status => l_return_status
779: -- ,p_datetrack_update_mode => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DatetrackUpdate',hr_api.g_correction)
780: );
781:
782: elsif l_postState = '3' then
783:
782: elsif l_postState = '3' then
783:
784: delete_element_outcome
785: (p_validate => p_validate
786: ,p_comp_element_outcome_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompElementOutcomeId')
787: ,p_object_version_number => l_object_version_number
788: ,p_return_status => l_return_status
789: );
790: