800: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
801:
802: l_commitElement := xmldom.makeElement(l_CommitNode);
803: l_postState := xmldom.getAttribute(l_commitElement, 'PS');
804: l_object_version_number := hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectVersionNumber');
805:
806: if l_postState = '0' then
807:
808: create_objective
807:
808: create_objective
809: ( p_validate => p_validate
810: ,p_effective_date => p_effective_date
811: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',null)
812: ,p_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Name',null)
813: ,p_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'StartDate',null)
814: ,p_owning_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OwningPersonId',null)
815: ,p_target_date => hr_transaction_swi.getDateValue(l_CommitNode,'TargetDate',null)
808: create_objective
809: ( p_validate => p_validate
810: ,p_effective_date => p_effective_date
811: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',null)
812: ,p_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Name',null)
813: ,p_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'StartDate',null)
814: ,p_owning_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OwningPersonId',null)
815: ,p_target_date => hr_transaction_swi.getDateValue(l_CommitNode,'TargetDate',null)
816: ,p_achievement_date => hr_transaction_swi.getDateValue(l_CommitNode,'AchievementDate',null)
809: ( p_validate => p_validate
810: ,p_effective_date => p_effective_date
811: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',null)
812: ,p_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Name',null)
813: ,p_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'StartDate',null)
814: ,p_owning_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OwningPersonId',null)
815: ,p_target_date => hr_transaction_swi.getDateValue(l_CommitNode,'TargetDate',null)
816: ,p_achievement_date => hr_transaction_swi.getDateValue(l_CommitNode,'AchievementDate',null)
817: ,p_detail => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Detail',null)
810: ,p_effective_date => p_effective_date
811: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',null)
812: ,p_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Name',null)
813: ,p_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'StartDate',null)
814: ,p_owning_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OwningPersonId',null)
815: ,p_target_date => hr_transaction_swi.getDateValue(l_CommitNode,'TargetDate',null)
816: ,p_achievement_date => hr_transaction_swi.getDateValue(l_CommitNode,'AchievementDate',null)
817: ,p_detail => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Detail',null)
818: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
811: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',null)
812: ,p_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Name',null)
813: ,p_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'StartDate',null)
814: ,p_owning_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OwningPersonId',null)
815: ,p_target_date => hr_transaction_swi.getDateValue(l_CommitNode,'TargetDate',null)
816: ,p_achievement_date => hr_transaction_swi.getDateValue(l_CommitNode,'AchievementDate',null)
817: ,p_detail => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Detail',null)
818: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
819: ,p_success_criteria => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SuccessCriteria',null)
812: ,p_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Name',null)
813: ,p_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'StartDate',null)
814: ,p_owning_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OwningPersonId',null)
815: ,p_target_date => hr_transaction_swi.getDateValue(l_CommitNode,'TargetDate',null)
816: ,p_achievement_date => hr_transaction_swi.getDateValue(l_CommitNode,'AchievementDate',null)
817: ,p_detail => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Detail',null)
818: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
819: ,p_success_criteria => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SuccessCriteria',null)
820: ,p_appraisal_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AppraisalId',null)
813: ,p_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'StartDate',null)
814: ,p_owning_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OwningPersonId',null)
815: ,p_target_date => hr_transaction_swi.getDateValue(l_CommitNode,'TargetDate',null)
816: ,p_achievement_date => hr_transaction_swi.getDateValue(l_CommitNode,'AchievementDate',null)
817: ,p_detail => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Detail',null)
818: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
819: ,p_success_criteria => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SuccessCriteria',null)
820: ,p_appraisal_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AppraisalId',null)
821: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
814: ,p_owning_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OwningPersonId',null)
815: ,p_target_date => hr_transaction_swi.getDateValue(l_CommitNode,'TargetDate',null)
816: ,p_achievement_date => hr_transaction_swi.getDateValue(l_CommitNode,'AchievementDate',null)
817: ,p_detail => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Detail',null)
818: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
819: ,p_success_criteria => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SuccessCriteria',null)
820: ,p_appraisal_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AppraisalId',null)
821: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
822: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
815: ,p_target_date => hr_transaction_swi.getDateValue(l_CommitNode,'TargetDate',null)
816: ,p_achievement_date => hr_transaction_swi.getDateValue(l_CommitNode,'AchievementDate',null)
817: ,p_detail => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Detail',null)
818: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
819: ,p_success_criteria => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SuccessCriteria',null)
820: ,p_appraisal_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AppraisalId',null)
821: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
822: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
823: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
816: ,p_achievement_date => hr_transaction_swi.getDateValue(l_CommitNode,'AchievementDate',null)
817: ,p_detail => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Detail',null)
818: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
819: ,p_success_criteria => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SuccessCriteria',null)
820: ,p_appraisal_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AppraisalId',null)
821: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
822: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
823: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
824: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
817: ,p_detail => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Detail',null)
818: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
819: ,p_success_criteria => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SuccessCriteria',null)
820: ,p_appraisal_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AppraisalId',null)
821: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
822: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
823: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
824: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
825: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
818: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
819: ,p_success_criteria => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SuccessCriteria',null)
820: ,p_appraisal_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AppraisalId',null)
821: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
822: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
823: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
824: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
825: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
826: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
819: ,p_success_criteria => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SuccessCriteria',null)
820: ,p_appraisal_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AppraisalId',null)
821: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
822: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
823: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
824: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
825: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
826: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
827: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
820: ,p_appraisal_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AppraisalId',null)
821: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
822: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
823: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
824: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
825: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
826: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
827: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
828: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
821: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
822: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
823: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
824: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
825: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
826: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
827: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
828: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
829: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
822: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
823: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
824: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
825: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
826: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
827: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
828: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
829: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
830: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
823: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
824: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
825: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
826: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
827: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
828: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
829: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
830: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
831: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
824: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
825: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
826: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
827: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
828: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
829: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
830: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
831: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
832: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
825: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
826: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
827: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
828: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
829: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
830: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
831: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
832: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
833: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
826: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
827: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
828: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
829: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
830: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
831: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
832: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
833: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
834: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
827: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
828: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
829: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
830: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
831: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
832: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
833: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
834: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
835: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
828: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
829: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
830: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
831: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
832: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
833: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
834: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
835: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
836: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
829: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
830: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
831: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
832: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
833: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
834: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
835: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
836: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
837: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
830: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
831: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
832: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
833: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
834: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
835: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
836: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
837: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
838: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
831: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
832: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
833: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
834: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
835: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
836: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
837: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
838: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
839: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
832: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
833: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
834: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
835: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
836: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
837: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
838: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
839: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
840: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
833: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
834: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
835: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
836: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
837: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
838: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
839: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
840: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
841: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
834: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
835: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
836: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
837: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
838: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
839: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
840: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
841: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
842:
835: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
836: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
837: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
838: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
839: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
840: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
841: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
842:
843: ,p_attribute21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute21',null)
836: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
837: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
838: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
839: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
840: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
841: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
842:
843: ,p_attribute21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute21',null)
844: ,p_attribute22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute22',null)
837: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
838: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
839: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
840: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
841: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
842:
843: ,p_attribute21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute21',null)
844: ,p_attribute22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute22',null)
845: ,p_attribute23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute23',null)
839: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
840: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
841: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
842:
843: ,p_attribute21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute21',null)
844: ,p_attribute22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute22',null)
845: ,p_attribute23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute23',null)
846: ,p_attribute24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute24',null)
847: ,p_attribute25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute25',null)
840: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
841: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
842:
843: ,p_attribute21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute21',null)
844: ,p_attribute22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute22',null)
845: ,p_attribute23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute23',null)
846: ,p_attribute24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute24',null)
847: ,p_attribute25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute25',null)
848: ,p_attribute26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute26',null)
841: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
842:
843: ,p_attribute21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute21',null)
844: ,p_attribute22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute22',null)
845: ,p_attribute23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute23',null)
846: ,p_attribute24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute24',null)
847: ,p_attribute25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute25',null)
848: ,p_attribute26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute26',null)
849: ,p_attribute27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute27',null)
842:
843: ,p_attribute21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute21',null)
844: ,p_attribute22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute22',null)
845: ,p_attribute23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute23',null)
846: ,p_attribute24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute24',null)
847: ,p_attribute25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute25',null)
848: ,p_attribute26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute26',null)
849: ,p_attribute27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute27',null)
850: ,p_attribute28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute28',null)
843: ,p_attribute21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute21',null)
844: ,p_attribute22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute22',null)
845: ,p_attribute23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute23',null)
846: ,p_attribute24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute24',null)
847: ,p_attribute25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute25',null)
848: ,p_attribute26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute26',null)
849: ,p_attribute27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute27',null)
850: ,p_attribute28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute28',null)
851: ,p_attribute29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute29',null)
844: ,p_attribute22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute22',null)
845: ,p_attribute23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute23',null)
846: ,p_attribute24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute24',null)
847: ,p_attribute25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute25',null)
848: ,p_attribute26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute26',null)
849: ,p_attribute27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute27',null)
850: ,p_attribute28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute28',null)
851: ,p_attribute29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute29',null)
852: ,p_attribute30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute30',null)
845: ,p_attribute23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute23',null)
846: ,p_attribute24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute24',null)
847: ,p_attribute25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute25',null)
848: ,p_attribute26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute26',null)
849: ,p_attribute27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute27',null)
850: ,p_attribute28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute28',null)
851: ,p_attribute29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute29',null)
852: ,p_attribute30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute30',null)
853:
846: ,p_attribute24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute24',null)
847: ,p_attribute25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute25',null)
848: ,p_attribute26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute26',null)
849: ,p_attribute27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute27',null)
850: ,p_attribute28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute28',null)
851: ,p_attribute29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute29',null)
852: ,p_attribute30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute30',null)
853:
854: ,p_scorecard_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ScorecardId',null)
847: ,p_attribute25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute25',null)
848: ,p_attribute26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute26',null)
849: ,p_attribute27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute27',null)
850: ,p_attribute28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute28',null)
851: ,p_attribute29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute29',null)
852: ,p_attribute30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute30',null)
853:
854: ,p_scorecard_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ScorecardId',null)
855: ,p_copied_from_library_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CopiedFromLibraryId',null)
848: ,p_attribute26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute26',null)
849: ,p_attribute27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute27',null)
850: ,p_attribute28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute28',null)
851: ,p_attribute29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute29',null)
852: ,p_attribute30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute30',null)
853:
854: ,p_scorecard_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ScorecardId',null)
855: ,p_copied_from_library_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CopiedFromLibraryId',null)
856: ,p_copied_from_objective_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CopiedFromObjectiveId',null)
850: ,p_attribute28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute28',null)
851: ,p_attribute29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute29',null)
852: ,p_attribute30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute30',null)
853:
854: ,p_scorecard_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ScorecardId',null)
855: ,p_copied_from_library_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CopiedFromLibraryId',null)
856: ,p_copied_from_objective_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CopiedFromObjectiveId',null)
857: ,p_aligned_with_objective_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AlignedWithObjectiveId',null)
858: ,p_next_review_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextReviewDate',null)
851: ,p_attribute29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute29',null)
852: ,p_attribute30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute30',null)
853:
854: ,p_scorecard_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ScorecardId',null)
855: ,p_copied_from_library_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CopiedFromLibraryId',null)
856: ,p_copied_from_objective_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CopiedFromObjectiveId',null)
857: ,p_aligned_with_objective_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AlignedWithObjectiveId',null)
858: ,p_next_review_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextReviewDate',null)
859: ,p_group_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'GroupCode',null)
852: ,p_attribute30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute30',null)
853:
854: ,p_scorecard_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ScorecardId',null)
855: ,p_copied_from_library_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CopiedFromLibraryId',null)
856: ,p_copied_from_objective_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CopiedFromObjectiveId',null)
857: ,p_aligned_with_objective_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AlignedWithObjectiveId',null)
858: ,p_next_review_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextReviewDate',null)
859: ,p_group_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'GroupCode',null)
860: ,p_priority_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PriorityCode',null)
853:
854: ,p_scorecard_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ScorecardId',null)
855: ,p_copied_from_library_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CopiedFromLibraryId',null)
856: ,p_copied_from_objective_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CopiedFromObjectiveId',null)
857: ,p_aligned_with_objective_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AlignedWithObjectiveId',null)
858: ,p_next_review_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextReviewDate',null)
859: ,p_group_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'GroupCode',null)
860: ,p_priority_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PriorityCode',null)
861: ,p_appraise_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraiseFlag',null)
854: ,p_scorecard_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ScorecardId',null)
855: ,p_copied_from_library_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CopiedFromLibraryId',null)
856: ,p_copied_from_objective_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CopiedFromObjectiveId',null)
857: ,p_aligned_with_objective_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AlignedWithObjectiveId',null)
858: ,p_next_review_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextReviewDate',null)
859: ,p_group_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'GroupCode',null)
860: ,p_priority_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PriorityCode',null)
861: ,p_appraise_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraiseFlag',null)
862: ,p_verified_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'VerifiedFlag',null)
855: ,p_copied_from_library_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CopiedFromLibraryId',null)
856: ,p_copied_from_objective_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CopiedFromObjectiveId',null)
857: ,p_aligned_with_objective_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AlignedWithObjectiveId',null)
858: ,p_next_review_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextReviewDate',null)
859: ,p_group_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'GroupCode',null)
860: ,p_priority_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PriorityCode',null)
861: ,p_appraise_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraiseFlag',null)
862: ,p_verified_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'VerifiedFlag',null)
863: ,p_target_value => hr_transaction_swi.getNumberValue(l_CommitNode,'TargetValue',null)
856: ,p_copied_from_objective_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CopiedFromObjectiveId',null)
857: ,p_aligned_with_objective_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AlignedWithObjectiveId',null)
858: ,p_next_review_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextReviewDate',null)
859: ,p_group_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'GroupCode',null)
860: ,p_priority_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PriorityCode',null)
861: ,p_appraise_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraiseFlag',null)
862: ,p_verified_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'VerifiedFlag',null)
863: ,p_target_value => hr_transaction_swi.getNumberValue(l_CommitNode,'TargetValue',null)
864: ,p_actual_value => hr_transaction_swi.getNumberValue(l_CommitNode,'ActualValue',null)
857: ,p_aligned_with_objective_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AlignedWithObjectiveId',null)
858: ,p_next_review_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextReviewDate',null)
859: ,p_group_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'GroupCode',null)
860: ,p_priority_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PriorityCode',null)
861: ,p_appraise_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraiseFlag',null)
862: ,p_verified_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'VerifiedFlag',null)
863: ,p_target_value => hr_transaction_swi.getNumberValue(l_CommitNode,'TargetValue',null)
864: ,p_actual_value => hr_transaction_swi.getNumberValue(l_CommitNode,'ActualValue',null)
865: ,p_weighting_percent => hr_transaction_swi.getNumberValue(l_CommitNode,'WeightingPercent',null)
858: ,p_next_review_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextReviewDate',null)
859: ,p_group_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'GroupCode',null)
860: ,p_priority_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PriorityCode',null)
861: ,p_appraise_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraiseFlag',null)
862: ,p_verified_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'VerifiedFlag',null)
863: ,p_target_value => hr_transaction_swi.getNumberValue(l_CommitNode,'TargetValue',null)
864: ,p_actual_value => hr_transaction_swi.getNumberValue(l_CommitNode,'ActualValue',null)
865: ,p_weighting_percent => hr_transaction_swi.getNumberValue(l_CommitNode,'WeightingPercent',null)
866: ,p_complete_percent => hr_transaction_swi.getNumberValue(l_CommitNode,'CompletePercent',null)
859: ,p_group_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'GroupCode',null)
860: ,p_priority_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PriorityCode',null)
861: ,p_appraise_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraiseFlag',null)
862: ,p_verified_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'VerifiedFlag',null)
863: ,p_target_value => hr_transaction_swi.getNumberValue(l_CommitNode,'TargetValue',null)
864: ,p_actual_value => hr_transaction_swi.getNumberValue(l_CommitNode,'ActualValue',null)
865: ,p_weighting_percent => hr_transaction_swi.getNumberValue(l_CommitNode,'WeightingPercent',null)
866: ,p_complete_percent => hr_transaction_swi.getNumberValue(l_CommitNode,'CompletePercent',null)
867: ,p_uom_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'UomCode',null)
860: ,p_priority_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PriorityCode',null)
861: ,p_appraise_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraiseFlag',null)
862: ,p_verified_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'VerifiedFlag',null)
863: ,p_target_value => hr_transaction_swi.getNumberValue(l_CommitNode,'TargetValue',null)
864: ,p_actual_value => hr_transaction_swi.getNumberValue(l_CommitNode,'ActualValue',null)
865: ,p_weighting_percent => hr_transaction_swi.getNumberValue(l_CommitNode,'WeightingPercent',null)
866: ,p_complete_percent => hr_transaction_swi.getNumberValue(l_CommitNode,'CompletePercent',null)
867: ,p_uom_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'UomCode',null)
868: ,p_measurement_style_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasurementStyleCode',null)
861: ,p_appraise_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraiseFlag',null)
862: ,p_verified_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'VerifiedFlag',null)
863: ,p_target_value => hr_transaction_swi.getNumberValue(l_CommitNode,'TargetValue',null)
864: ,p_actual_value => hr_transaction_swi.getNumberValue(l_CommitNode,'ActualValue',null)
865: ,p_weighting_percent => hr_transaction_swi.getNumberValue(l_CommitNode,'WeightingPercent',null)
866: ,p_complete_percent => hr_transaction_swi.getNumberValue(l_CommitNode,'CompletePercent',null)
867: ,p_uom_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'UomCode',null)
868: ,p_measurement_style_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasurementStyleCode',null)
869: ,p_measure_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasureName',null)
862: ,p_verified_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'VerifiedFlag',null)
863: ,p_target_value => hr_transaction_swi.getNumberValue(l_CommitNode,'TargetValue',null)
864: ,p_actual_value => hr_transaction_swi.getNumberValue(l_CommitNode,'ActualValue',null)
865: ,p_weighting_percent => hr_transaction_swi.getNumberValue(l_CommitNode,'WeightingPercent',null)
866: ,p_complete_percent => hr_transaction_swi.getNumberValue(l_CommitNode,'CompletePercent',null)
867: ,p_uom_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'UomCode',null)
868: ,p_measurement_style_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasurementStyleCode',null)
869: ,p_measure_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasureName',null)
870: ,p_measure_type_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasureTypeCode',null)
863: ,p_target_value => hr_transaction_swi.getNumberValue(l_CommitNode,'TargetValue',null)
864: ,p_actual_value => hr_transaction_swi.getNumberValue(l_CommitNode,'ActualValue',null)
865: ,p_weighting_percent => hr_transaction_swi.getNumberValue(l_CommitNode,'WeightingPercent',null)
866: ,p_complete_percent => hr_transaction_swi.getNumberValue(l_CommitNode,'CompletePercent',null)
867: ,p_uom_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'UomCode',null)
868: ,p_measurement_style_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasurementStyleCode',null)
869: ,p_measure_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasureName',null)
870: ,p_measure_type_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasureTypeCode',null)
871: ,p_measure_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasureComments',null)
864: ,p_actual_value => hr_transaction_swi.getNumberValue(l_CommitNode,'ActualValue',null)
865: ,p_weighting_percent => hr_transaction_swi.getNumberValue(l_CommitNode,'WeightingPercent',null)
866: ,p_complete_percent => hr_transaction_swi.getNumberValue(l_CommitNode,'CompletePercent',null)
867: ,p_uom_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'UomCode',null)
868: ,p_measurement_style_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasurementStyleCode',null)
869: ,p_measure_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasureName',null)
870: ,p_measure_type_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasureTypeCode',null)
871: ,p_measure_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasureComments',null)
872: ,p_sharing_access_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SharingAccessCode',null)
865: ,p_weighting_percent => hr_transaction_swi.getNumberValue(l_CommitNode,'WeightingPercent',null)
866: ,p_complete_percent => hr_transaction_swi.getNumberValue(l_CommitNode,'CompletePercent',null)
867: ,p_uom_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'UomCode',null)
868: ,p_measurement_style_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasurementStyleCode',null)
869: ,p_measure_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasureName',null)
870: ,p_measure_type_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasureTypeCode',null)
871: ,p_measure_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasureComments',null)
872: ,p_sharing_access_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SharingAccessCode',null)
873:
866: ,p_complete_percent => hr_transaction_swi.getNumberValue(l_CommitNode,'CompletePercent',null)
867: ,p_uom_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'UomCode',null)
868: ,p_measurement_style_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasurementStyleCode',null)
869: ,p_measure_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasureName',null)
870: ,p_measure_type_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasureTypeCode',null)
871: ,p_measure_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasureComments',null)
872: ,p_sharing_access_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SharingAccessCode',null)
873:
874: ,p_objective_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectiveId',null)
867: ,p_uom_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'UomCode',null)
868: ,p_measurement_style_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasurementStyleCode',null)
869: ,p_measure_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasureName',null)
870: ,p_measure_type_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasureTypeCode',null)
871: ,p_measure_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasureComments',null)
872: ,p_sharing_access_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SharingAccessCode',null)
873:
874: ,p_objective_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectiveId',null)
875: ,p_object_version_number => l_object_version_number
868: ,p_measurement_style_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasurementStyleCode',null)
869: ,p_measure_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasureName',null)
870: ,p_measure_type_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasureTypeCode',null)
871: ,p_measure_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasureComments',null)
872: ,p_sharing_access_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SharingAccessCode',null)
873:
874: ,p_objective_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectiveId',null)
875: ,p_object_version_number => l_object_version_number
876: ,p_return_status => l_return_status
870: ,p_measure_type_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasureTypeCode',null)
871: ,p_measure_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasureComments',null)
872: ,p_sharing_access_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SharingAccessCode',null)
873:
874: ,p_objective_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectiveId',null)
875: ,p_object_version_number => l_object_version_number
876: ,p_return_status => l_return_status
877: );
878:
879: elsif l_postState = '2' then
880:
881: --7795134 check_cascade will directly process the AlignedWithObjectiveId from transaction doc.Changed the value before calling the api
882:
883: if( hr_transaction_swi.getNumberValue(l_CommitNode,'AlignedWithObjectiveId',null) = hr_api.g_number ) then
884: open chk_aligned_with_obj_id(hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectiveId'));
885: fetch chk_aligned_with_obj_id into l_aligned_with_objective_id;
886: close chk_aligned_with_obj_id;
887: end if;
880:
881: --7795134 check_cascade will directly process the AlignedWithObjectiveId from transaction doc.Changed the value before calling the api
882:
883: if( hr_transaction_swi.getNumberValue(l_CommitNode,'AlignedWithObjectiveId',null) = hr_api.g_number ) then
884: open chk_aligned_with_obj_id(hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectiveId'));
885: fetch chk_aligned_with_obj_id into l_aligned_with_objective_id;
886: close chk_aligned_with_obj_id;
887: end if;
888: --13055426
885: fetch chk_aligned_with_obj_id into l_aligned_with_objective_id;
886: close chk_aligned_with_obj_id;
887: end if;
888: --13055426
889: l_aligned_with_objective_id := NVL(l_aligned_with_objective_id, hr_transaction_swi.getNumberValue(l_CommitNode,'AlignedWithObjectiveId'));
890:
891: update_objective
892: ( p_validate => p_validate
893: ,p_effective_date => p_effective_date
890:
891: update_objective
892: ( p_validate => p_validate
893: ,p_effective_date => p_effective_date
894: ,p_objective_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectiveId')
895: ,p_object_version_number => l_object_version_number
896: ,p_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Name')
897: ,p_target_date => hr_transaction_swi.getDateValue(l_CommitNode,'TargetDate')
898: ,p_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'StartDate')
892: ( p_validate => p_validate
893: ,p_effective_date => p_effective_date
894: ,p_objective_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectiveId')
895: ,p_object_version_number => l_object_version_number
896: ,p_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Name')
897: ,p_target_date => hr_transaction_swi.getDateValue(l_CommitNode,'TargetDate')
898: ,p_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'StartDate')
899: ,p_achievement_date => hr_transaction_swi.getDateValue(l_CommitNode,'AchievementDate')
900: ,p_detail => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Detail')
893: ,p_effective_date => p_effective_date
894: ,p_objective_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectiveId')
895: ,p_object_version_number => l_object_version_number
896: ,p_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Name')
897: ,p_target_date => hr_transaction_swi.getDateValue(l_CommitNode,'TargetDate')
898: ,p_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'StartDate')
899: ,p_achievement_date => hr_transaction_swi.getDateValue(l_CommitNode,'AchievementDate')
900: ,p_detail => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Detail')
901: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
894: ,p_objective_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectiveId')
895: ,p_object_version_number => l_object_version_number
896: ,p_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Name')
897: ,p_target_date => hr_transaction_swi.getDateValue(l_CommitNode,'TargetDate')
898: ,p_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'StartDate')
899: ,p_achievement_date => hr_transaction_swi.getDateValue(l_CommitNode,'AchievementDate')
900: ,p_detail => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Detail')
901: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
902: ,p_success_criteria => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SuccessCriteria')
895: ,p_object_version_number => l_object_version_number
896: ,p_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Name')
897: ,p_target_date => hr_transaction_swi.getDateValue(l_CommitNode,'TargetDate')
898: ,p_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'StartDate')
899: ,p_achievement_date => hr_transaction_swi.getDateValue(l_CommitNode,'AchievementDate')
900: ,p_detail => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Detail')
901: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
902: ,p_success_criteria => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SuccessCriteria')
903: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
896: ,p_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Name')
897: ,p_target_date => hr_transaction_swi.getDateValue(l_CommitNode,'TargetDate')
898: ,p_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'StartDate')
899: ,p_achievement_date => hr_transaction_swi.getDateValue(l_CommitNode,'AchievementDate')
900: ,p_detail => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Detail')
901: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
902: ,p_success_criteria => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SuccessCriteria')
903: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
904: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
897: ,p_target_date => hr_transaction_swi.getDateValue(l_CommitNode,'TargetDate')
898: ,p_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'StartDate')
899: ,p_achievement_date => hr_transaction_swi.getDateValue(l_CommitNode,'AchievementDate')
900: ,p_detail => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Detail')
901: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
902: ,p_success_criteria => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SuccessCriteria')
903: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
904: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
905: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
898: ,p_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'StartDate')
899: ,p_achievement_date => hr_transaction_swi.getDateValue(l_CommitNode,'AchievementDate')
900: ,p_detail => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Detail')
901: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
902: ,p_success_criteria => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SuccessCriteria')
903: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
904: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
905: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
906: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
899: ,p_achievement_date => hr_transaction_swi.getDateValue(l_CommitNode,'AchievementDate')
900: ,p_detail => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Detail')
901: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
902: ,p_success_criteria => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SuccessCriteria')
903: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
904: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
905: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
906: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
907: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
900: ,p_detail => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Detail')
901: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
902: ,p_success_criteria => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SuccessCriteria')
903: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
904: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
905: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
906: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
907: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
908: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
901: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
902: ,p_success_criteria => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SuccessCriteria')
903: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
904: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
905: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
906: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
907: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
908: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
909: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
902: ,p_success_criteria => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SuccessCriteria')
903: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
904: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
905: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
906: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
907: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
908: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
909: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
910: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
903: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
904: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
905: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
906: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
907: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
908: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
909: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
910: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
911: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
904: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
905: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
906: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
907: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
908: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
909: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
910: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
911: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
912: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
905: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
906: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
907: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
908: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
909: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
910: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
911: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
912: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
913: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
906: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
907: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
908: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
909: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
910: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
911: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
912: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
913: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
914: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
907: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
908: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
909: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
910: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
911: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
912: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
913: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
914: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
915: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
908: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
909: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
910: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
911: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
912: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
913: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
914: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
915: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
916: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
909: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
910: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
911: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
912: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
913: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
914: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
915: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
916: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
917: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
910: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
911: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
912: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
913: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
914: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
915: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
916: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
917: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
918: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
911: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
912: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
913: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
914: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
915: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
916: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
917: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
918: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
919: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
912: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
913: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
914: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
915: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
916: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
917: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
918: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
919: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
920: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
913: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
914: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
915: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
916: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
917: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
918: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
919: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
920: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
921: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
914: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
915: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
916: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
917: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
918: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
919: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
920: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
921: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
922: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
915: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
916: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
917: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
918: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
919: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
920: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
921: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
922: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
923: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
916: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
917: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
918: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
919: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
920: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
921: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
922: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
923: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
924:
917: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
918: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
919: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
920: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
921: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
922: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
923: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
924:
925: ,p_attribute21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute21')
918: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
919: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
920: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
921: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
922: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
923: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
924:
925: ,p_attribute21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute21')
926: ,p_attribute22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute22')
919: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
920: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
921: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
922: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
923: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
924:
925: ,p_attribute21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute21')
926: ,p_attribute22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute22')
927: ,p_attribute23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute23')
921: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
922: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
923: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
924:
925: ,p_attribute21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute21')
926: ,p_attribute22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute22')
927: ,p_attribute23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute23')
928: ,p_attribute24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute24')
929: ,p_attribute25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute25')
922: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
923: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
924:
925: ,p_attribute21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute21')
926: ,p_attribute22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute22')
927: ,p_attribute23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute23')
928: ,p_attribute24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute24')
929: ,p_attribute25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute25')
930: ,p_attribute26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute26')
923: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
924:
925: ,p_attribute21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute21')
926: ,p_attribute22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute22')
927: ,p_attribute23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute23')
928: ,p_attribute24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute24')
929: ,p_attribute25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute25')
930: ,p_attribute26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute26')
931: ,p_attribute27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute27')
924:
925: ,p_attribute21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute21')
926: ,p_attribute22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute22')
927: ,p_attribute23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute23')
928: ,p_attribute24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute24')
929: ,p_attribute25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute25')
930: ,p_attribute26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute26')
931: ,p_attribute27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute27')
932: ,p_attribute28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute28')
925: ,p_attribute21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute21')
926: ,p_attribute22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute22')
927: ,p_attribute23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute23')
928: ,p_attribute24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute24')
929: ,p_attribute25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute25')
930: ,p_attribute26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute26')
931: ,p_attribute27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute27')
932: ,p_attribute28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute28')
933: ,p_attribute29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute29')
926: ,p_attribute22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute22')
927: ,p_attribute23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute23')
928: ,p_attribute24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute24')
929: ,p_attribute25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute25')
930: ,p_attribute26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute26')
931: ,p_attribute27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute27')
932: ,p_attribute28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute28')
933: ,p_attribute29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute29')
934: ,p_attribute30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute30')
927: ,p_attribute23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute23')
928: ,p_attribute24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute24')
929: ,p_attribute25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute25')
930: ,p_attribute26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute26')
931: ,p_attribute27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute27')
932: ,p_attribute28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute28')
933: ,p_attribute29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute29')
934: ,p_attribute30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute30')
935: ,p_scorecard_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ScorecardId')
928: ,p_attribute24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute24')
929: ,p_attribute25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute25')
930: ,p_attribute26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute26')
931: ,p_attribute27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute27')
932: ,p_attribute28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute28')
933: ,p_attribute29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute29')
934: ,p_attribute30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute30')
935: ,p_scorecard_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ScorecardId')
936: ,p_copied_from_library_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CopiedFromLibraryId')
929: ,p_attribute25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute25')
930: ,p_attribute26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute26')
931: ,p_attribute27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute27')
932: ,p_attribute28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute28')
933: ,p_attribute29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute29')
934: ,p_attribute30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute30')
935: ,p_scorecard_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ScorecardId')
936: ,p_copied_from_library_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CopiedFromLibraryId')
937: ,p_copied_from_objective_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CopiedFromObjectiveId')
930: ,p_attribute26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute26')
931: ,p_attribute27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute27')
932: ,p_attribute28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute28')
933: ,p_attribute29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute29')
934: ,p_attribute30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute30')
935: ,p_scorecard_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ScorecardId')
936: ,p_copied_from_library_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CopiedFromLibraryId')
937: ,p_copied_from_objective_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CopiedFromObjectiveId')
938: -- ,p_aligned_with_objective_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AlignedWithObjectiveId')
931: ,p_attribute27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute27')
932: ,p_attribute28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute28')
933: ,p_attribute29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute29')
934: ,p_attribute30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute30')
935: ,p_scorecard_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ScorecardId')
936: ,p_copied_from_library_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CopiedFromLibraryId')
937: ,p_copied_from_objective_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CopiedFromObjectiveId')
938: -- ,p_aligned_with_objective_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AlignedWithObjectiveId')
939: ,p_aligned_with_objective_id => l_aligned_with_objective_id
932: ,p_attribute28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute28')
933: ,p_attribute29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute29')
934: ,p_attribute30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute30')
935: ,p_scorecard_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ScorecardId')
936: ,p_copied_from_library_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CopiedFromLibraryId')
937: ,p_copied_from_objective_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CopiedFromObjectiveId')
938: -- ,p_aligned_with_objective_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AlignedWithObjectiveId')
939: ,p_aligned_with_objective_id => l_aligned_with_objective_id
940: ,p_next_review_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextReviewDate')
933: ,p_attribute29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute29')
934: ,p_attribute30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute30')
935: ,p_scorecard_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ScorecardId')
936: ,p_copied_from_library_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CopiedFromLibraryId')
937: ,p_copied_from_objective_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CopiedFromObjectiveId')
938: -- ,p_aligned_with_objective_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AlignedWithObjectiveId')
939: ,p_aligned_with_objective_id => l_aligned_with_objective_id
940: ,p_next_review_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextReviewDate')
941: ,p_group_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'GroupCode')
934: ,p_attribute30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute30')
935: ,p_scorecard_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ScorecardId')
936: ,p_copied_from_library_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CopiedFromLibraryId')
937: ,p_copied_from_objective_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CopiedFromObjectiveId')
938: -- ,p_aligned_with_objective_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AlignedWithObjectiveId')
939: ,p_aligned_with_objective_id => l_aligned_with_objective_id
940: ,p_next_review_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextReviewDate')
941: ,p_group_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'GroupCode')
942: ,p_priority_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PriorityCode')
936: ,p_copied_from_library_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CopiedFromLibraryId')
937: ,p_copied_from_objective_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CopiedFromObjectiveId')
938: -- ,p_aligned_with_objective_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AlignedWithObjectiveId')
939: ,p_aligned_with_objective_id => l_aligned_with_objective_id
940: ,p_next_review_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextReviewDate')
941: ,p_group_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'GroupCode')
942: ,p_priority_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PriorityCode')
943: ,p_appraise_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraiseFlag')
944: ,p_verified_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'VerifiedFlag')
937: ,p_copied_from_objective_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CopiedFromObjectiveId')
938: -- ,p_aligned_with_objective_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AlignedWithObjectiveId')
939: ,p_aligned_with_objective_id => l_aligned_with_objective_id
940: ,p_next_review_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextReviewDate')
941: ,p_group_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'GroupCode')
942: ,p_priority_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PriorityCode')
943: ,p_appraise_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraiseFlag')
944: ,p_verified_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'VerifiedFlag')
945: ,p_target_value => hr_transaction_swi.getNumberValue(l_CommitNode,'TargetValue')
938: -- ,p_aligned_with_objective_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AlignedWithObjectiveId')
939: ,p_aligned_with_objective_id => l_aligned_with_objective_id
940: ,p_next_review_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextReviewDate')
941: ,p_group_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'GroupCode')
942: ,p_priority_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PriorityCode')
943: ,p_appraise_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraiseFlag')
944: ,p_verified_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'VerifiedFlag')
945: ,p_target_value => hr_transaction_swi.getNumberValue(l_CommitNode,'TargetValue')
946: ,p_actual_value => hr_transaction_swi.getNumberValue(l_CommitNode,'ActualValue')
939: ,p_aligned_with_objective_id => l_aligned_with_objective_id
940: ,p_next_review_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextReviewDate')
941: ,p_group_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'GroupCode')
942: ,p_priority_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PriorityCode')
943: ,p_appraise_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraiseFlag')
944: ,p_verified_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'VerifiedFlag')
945: ,p_target_value => hr_transaction_swi.getNumberValue(l_CommitNode,'TargetValue')
946: ,p_actual_value => hr_transaction_swi.getNumberValue(l_CommitNode,'ActualValue')
947: ,p_weighting_percent => hr_transaction_swi.getNumberValue(l_CommitNode,'WeightingPercent')
940: ,p_next_review_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextReviewDate')
941: ,p_group_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'GroupCode')
942: ,p_priority_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PriorityCode')
943: ,p_appraise_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraiseFlag')
944: ,p_verified_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'VerifiedFlag')
945: ,p_target_value => hr_transaction_swi.getNumberValue(l_CommitNode,'TargetValue')
946: ,p_actual_value => hr_transaction_swi.getNumberValue(l_CommitNode,'ActualValue')
947: ,p_weighting_percent => hr_transaction_swi.getNumberValue(l_CommitNode,'WeightingPercent')
948: ,p_complete_percent => hr_transaction_swi.getNumberValue(l_CommitNode,'CompletePercent')
941: ,p_group_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'GroupCode')
942: ,p_priority_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PriorityCode')
943: ,p_appraise_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraiseFlag')
944: ,p_verified_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'VerifiedFlag')
945: ,p_target_value => hr_transaction_swi.getNumberValue(l_CommitNode,'TargetValue')
946: ,p_actual_value => hr_transaction_swi.getNumberValue(l_CommitNode,'ActualValue')
947: ,p_weighting_percent => hr_transaction_swi.getNumberValue(l_CommitNode,'WeightingPercent')
948: ,p_complete_percent => hr_transaction_swi.getNumberValue(l_CommitNode,'CompletePercent')
949: ,p_uom_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'UomCode')
942: ,p_priority_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PriorityCode')
943: ,p_appraise_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraiseFlag')
944: ,p_verified_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'VerifiedFlag')
945: ,p_target_value => hr_transaction_swi.getNumberValue(l_CommitNode,'TargetValue')
946: ,p_actual_value => hr_transaction_swi.getNumberValue(l_CommitNode,'ActualValue')
947: ,p_weighting_percent => hr_transaction_swi.getNumberValue(l_CommitNode,'WeightingPercent')
948: ,p_complete_percent => hr_transaction_swi.getNumberValue(l_CommitNode,'CompletePercent')
949: ,p_uom_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'UomCode')
950: ,p_measurement_style_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasurementStyleCode')
943: ,p_appraise_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraiseFlag')
944: ,p_verified_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'VerifiedFlag')
945: ,p_target_value => hr_transaction_swi.getNumberValue(l_CommitNode,'TargetValue')
946: ,p_actual_value => hr_transaction_swi.getNumberValue(l_CommitNode,'ActualValue')
947: ,p_weighting_percent => hr_transaction_swi.getNumberValue(l_CommitNode,'WeightingPercent')
948: ,p_complete_percent => hr_transaction_swi.getNumberValue(l_CommitNode,'CompletePercent')
949: ,p_uom_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'UomCode')
950: ,p_measurement_style_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasurementStyleCode')
951: ,p_measure_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasureName')
944: ,p_verified_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'VerifiedFlag')
945: ,p_target_value => hr_transaction_swi.getNumberValue(l_CommitNode,'TargetValue')
946: ,p_actual_value => hr_transaction_swi.getNumberValue(l_CommitNode,'ActualValue')
947: ,p_weighting_percent => hr_transaction_swi.getNumberValue(l_CommitNode,'WeightingPercent')
948: ,p_complete_percent => hr_transaction_swi.getNumberValue(l_CommitNode,'CompletePercent')
949: ,p_uom_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'UomCode')
950: ,p_measurement_style_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasurementStyleCode')
951: ,p_measure_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasureName')
952: ,p_measure_type_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasureTypeCode')
945: ,p_target_value => hr_transaction_swi.getNumberValue(l_CommitNode,'TargetValue')
946: ,p_actual_value => hr_transaction_swi.getNumberValue(l_CommitNode,'ActualValue')
947: ,p_weighting_percent => hr_transaction_swi.getNumberValue(l_CommitNode,'WeightingPercent')
948: ,p_complete_percent => hr_transaction_swi.getNumberValue(l_CommitNode,'CompletePercent')
949: ,p_uom_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'UomCode')
950: ,p_measurement_style_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasurementStyleCode')
951: ,p_measure_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasureName')
952: ,p_measure_type_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasureTypeCode')
953: ,p_measure_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasureComments')
946: ,p_actual_value => hr_transaction_swi.getNumberValue(l_CommitNode,'ActualValue')
947: ,p_weighting_percent => hr_transaction_swi.getNumberValue(l_CommitNode,'WeightingPercent')
948: ,p_complete_percent => hr_transaction_swi.getNumberValue(l_CommitNode,'CompletePercent')
949: ,p_uom_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'UomCode')
950: ,p_measurement_style_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasurementStyleCode')
951: ,p_measure_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasureName')
952: ,p_measure_type_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasureTypeCode')
953: ,p_measure_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasureComments')
954: ,p_sharing_access_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SharingAccessCode')
947: ,p_weighting_percent => hr_transaction_swi.getNumberValue(l_CommitNode,'WeightingPercent')
948: ,p_complete_percent => hr_transaction_swi.getNumberValue(l_CommitNode,'CompletePercent')
949: ,p_uom_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'UomCode')
950: ,p_measurement_style_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasurementStyleCode')
951: ,p_measure_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasureName')
952: ,p_measure_type_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasureTypeCode')
953: ,p_measure_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasureComments')
954: ,p_sharing_access_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SharingAccessCode')
955: ,p_appraisal_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AppraisalId')
948: ,p_complete_percent => hr_transaction_swi.getNumberValue(l_CommitNode,'CompletePercent')
949: ,p_uom_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'UomCode')
950: ,p_measurement_style_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasurementStyleCode')
951: ,p_measure_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasureName')
952: ,p_measure_type_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasureTypeCode')
953: ,p_measure_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasureComments')
954: ,p_sharing_access_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SharingAccessCode')
955: ,p_appraisal_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AppraisalId')
956: ,p_return_status => l_return_status
949: ,p_uom_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'UomCode')
950: ,p_measurement_style_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasurementStyleCode')
951: ,p_measure_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasureName')
952: ,p_measure_type_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasureTypeCode')
953: ,p_measure_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasureComments')
954: ,p_sharing_access_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SharingAccessCode')
955: ,p_appraisal_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AppraisalId')
956: ,p_return_status => l_return_status
957: );
950: ,p_measurement_style_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasurementStyleCode')
951: ,p_measure_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasureName')
952: ,p_measure_type_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasureTypeCode')
953: ,p_measure_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasureComments')
954: ,p_sharing_access_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SharingAccessCode')
955: ,p_appraisal_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AppraisalId')
956: ,p_return_status => l_return_status
957: );
958:
951: ,p_measure_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasureName')
952: ,p_measure_type_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasureTypeCode')
953: ,p_measure_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'MeasureComments')
954: ,p_sharing_access_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SharingAccessCode')
955: ,p_appraisal_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AppraisalId')
956: ,p_return_status => l_return_status
957: );
958:
959: elsif l_postState = '3' then
959: elsif l_postState = '3' then
960:
961: delete_objective
962: ( p_validate => p_validate
963: ,p_objective_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectiveId')
964: ,p_object_version_number => l_object_version_number
965: ,p_return_status => l_return_status
966: );
967: