646: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
647:
648: l_commitElement := xmldom.makeElement(l_CommitNode);
649: l_postState := xmldom.getAttribute(l_commitElement, 'PS');
650: l_object_version_number := hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectVersionNumber');
651:
652: if l_postState = '0' then
653:
654: create_appraisal
653:
654: create_appraisal
655: ( p_validate => p_validate
656: ,p_effective_date => p_effective_date
657: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',null)
658: ,p_appraisal_template_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AppraisalTemplateId',null)
659: ,p_appraisee_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AppraiseePersonId',null)
660: ,p_appraiser_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AppraiserPersonId',null)
661: ,p_appraisal_date => hr_transaction_swi.getDateValue(l_CommitNode,'AppraisalDate',null)
654: create_appraisal
655: ( p_validate => p_validate
656: ,p_effective_date => p_effective_date
657: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',null)
658: ,p_appraisal_template_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AppraisalTemplateId',null)
659: ,p_appraisee_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AppraiseePersonId',null)
660: ,p_appraiser_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AppraiserPersonId',null)
661: ,p_appraisal_date => hr_transaction_swi.getDateValue(l_CommitNode,'AppraisalDate',null)
662: ,p_appraisal_period_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'AppraisalPeriodStartDate',null)
655: ( p_validate => p_validate
656: ,p_effective_date => p_effective_date
657: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',null)
658: ,p_appraisal_template_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AppraisalTemplateId',null)
659: ,p_appraisee_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AppraiseePersonId',null)
660: ,p_appraiser_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AppraiserPersonId',null)
661: ,p_appraisal_date => hr_transaction_swi.getDateValue(l_CommitNode,'AppraisalDate',null)
662: ,p_appraisal_period_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'AppraisalPeriodStartDate',null)
663: ,p_appraisal_period_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'AppraisalPeriodEndDate',null)
656: ,p_effective_date => p_effective_date
657: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',null)
658: ,p_appraisal_template_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AppraisalTemplateId',null)
659: ,p_appraisee_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AppraiseePersonId',null)
660: ,p_appraiser_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AppraiserPersonId',null)
661: ,p_appraisal_date => hr_transaction_swi.getDateValue(l_CommitNode,'AppraisalDate',null)
662: ,p_appraisal_period_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'AppraisalPeriodStartDate',null)
663: ,p_appraisal_period_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'AppraisalPeriodEndDate',null)
664: ,p_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Type',null)
657: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',null)
658: ,p_appraisal_template_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AppraisalTemplateId',null)
659: ,p_appraisee_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AppraiseePersonId',null)
660: ,p_appraiser_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AppraiserPersonId',null)
661: ,p_appraisal_date => hr_transaction_swi.getDateValue(l_CommitNode,'AppraisalDate',null)
662: ,p_appraisal_period_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'AppraisalPeriodStartDate',null)
663: ,p_appraisal_period_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'AppraisalPeriodEndDate',null)
664: ,p_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Type',null)
665: ,p_next_appraisal_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextAppraisalDate',null)
658: ,p_appraisal_template_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AppraisalTemplateId',null)
659: ,p_appraisee_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AppraiseePersonId',null)
660: ,p_appraiser_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AppraiserPersonId',null)
661: ,p_appraisal_date => hr_transaction_swi.getDateValue(l_CommitNode,'AppraisalDate',null)
662: ,p_appraisal_period_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'AppraisalPeriodStartDate',null)
663: ,p_appraisal_period_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'AppraisalPeriodEndDate',null)
664: ,p_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Type',null)
665: ,p_next_appraisal_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextAppraisalDate',null)
666: ,p_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Status',null)
659: ,p_appraisee_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AppraiseePersonId',null)
660: ,p_appraiser_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AppraiserPersonId',null)
661: ,p_appraisal_date => hr_transaction_swi.getDateValue(l_CommitNode,'AppraisalDate',null)
662: ,p_appraisal_period_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'AppraisalPeriodStartDate',null)
663: ,p_appraisal_period_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'AppraisalPeriodEndDate',null)
664: ,p_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Type',null)
665: ,p_next_appraisal_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextAppraisalDate',null)
666: ,p_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Status',null)
667: ,p_group_date => hr_transaction_swi.getDateValue(l_CommitNode,'GroupDate',null)
660: ,p_appraiser_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AppraiserPersonId',null)
661: ,p_appraisal_date => hr_transaction_swi.getDateValue(l_CommitNode,'AppraisalDate',null)
662: ,p_appraisal_period_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'AppraisalPeriodStartDate',null)
663: ,p_appraisal_period_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'AppraisalPeriodEndDate',null)
664: ,p_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Type',null)
665: ,p_next_appraisal_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextAppraisalDate',null)
666: ,p_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Status',null)
667: ,p_group_date => hr_transaction_swi.getDateValue(l_CommitNode,'GroupDate',null)
668: ,p_group_initiator_id => hr_transaction_swi.getNumberValue(l_CommitNode,'GroupInitiatorId',null)
661: ,p_appraisal_date => hr_transaction_swi.getDateValue(l_CommitNode,'AppraisalDate',null)
662: ,p_appraisal_period_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'AppraisalPeriodStartDate',null)
663: ,p_appraisal_period_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'AppraisalPeriodEndDate',null)
664: ,p_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Type',null)
665: ,p_next_appraisal_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextAppraisalDate',null)
666: ,p_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Status',null)
667: ,p_group_date => hr_transaction_swi.getDateValue(l_CommitNode,'GroupDate',null)
668: ,p_group_initiator_id => hr_transaction_swi.getNumberValue(l_CommitNode,'GroupInitiatorId',null)
669: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
662: ,p_appraisal_period_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'AppraisalPeriodStartDate',null)
663: ,p_appraisal_period_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'AppraisalPeriodEndDate',null)
664: ,p_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Type',null)
665: ,p_next_appraisal_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextAppraisalDate',null)
666: ,p_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Status',null)
667: ,p_group_date => hr_transaction_swi.getDateValue(l_CommitNode,'GroupDate',null)
668: ,p_group_initiator_id => hr_transaction_swi.getNumberValue(l_CommitNode,'GroupInitiatorId',null)
669: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
670: ,p_overall_performance_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OverallPerformanceLevelId',null)
663: ,p_appraisal_period_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'AppraisalPeriodEndDate',null)
664: ,p_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Type',null)
665: ,p_next_appraisal_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextAppraisalDate',null)
666: ,p_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Status',null)
667: ,p_group_date => hr_transaction_swi.getDateValue(l_CommitNode,'GroupDate',null)
668: ,p_group_initiator_id => hr_transaction_swi.getNumberValue(l_CommitNode,'GroupInitiatorId',null)
669: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
670: ,p_overall_performance_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OverallPerformanceLevelId',null)
671: ,p_open => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Open',null)
664: ,p_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Type',null)
665: ,p_next_appraisal_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextAppraisalDate',null)
666: ,p_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Status',null)
667: ,p_group_date => hr_transaction_swi.getDateValue(l_CommitNode,'GroupDate',null)
668: ,p_group_initiator_id => hr_transaction_swi.getNumberValue(l_CommitNode,'GroupInitiatorId',null)
669: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
670: ,p_overall_performance_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OverallPerformanceLevelId',null)
671: ,p_open => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Open',null)
672: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
665: ,p_next_appraisal_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextAppraisalDate',null)
666: ,p_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Status',null)
667: ,p_group_date => hr_transaction_swi.getDateValue(l_CommitNode,'GroupDate',null)
668: ,p_group_initiator_id => hr_transaction_swi.getNumberValue(l_CommitNode,'GroupInitiatorId',null)
669: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
670: ,p_overall_performance_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OverallPerformanceLevelId',null)
671: ,p_open => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Open',null)
672: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
673: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
666: ,p_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Status',null)
667: ,p_group_date => hr_transaction_swi.getDateValue(l_CommitNode,'GroupDate',null)
668: ,p_group_initiator_id => hr_transaction_swi.getNumberValue(l_CommitNode,'GroupInitiatorId',null)
669: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
670: ,p_overall_performance_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OverallPerformanceLevelId',null)
671: ,p_open => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Open',null)
672: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
673: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
674: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
667: ,p_group_date => hr_transaction_swi.getDateValue(l_CommitNode,'GroupDate',null)
668: ,p_group_initiator_id => hr_transaction_swi.getNumberValue(l_CommitNode,'GroupInitiatorId',null)
669: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
670: ,p_overall_performance_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OverallPerformanceLevelId',null)
671: ,p_open => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Open',null)
672: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
673: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
674: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
675: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
668: ,p_group_initiator_id => hr_transaction_swi.getNumberValue(l_CommitNode,'GroupInitiatorId',null)
669: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
670: ,p_overall_performance_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OverallPerformanceLevelId',null)
671: ,p_open => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Open',null)
672: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
673: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
674: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
675: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
676: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
669: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
670: ,p_overall_performance_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OverallPerformanceLevelId',null)
671: ,p_open => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Open',null)
672: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
673: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
674: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
675: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
676: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
677: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
670: ,p_overall_performance_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OverallPerformanceLevelId',null)
671: ,p_open => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Open',null)
672: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
673: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
674: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
675: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
676: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
677: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
678: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
671: ,p_open => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Open',null)
672: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
673: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
674: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
675: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
676: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
677: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
678: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
679: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
672: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
673: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
674: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
675: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
676: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
677: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
678: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
679: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
680: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
673: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
674: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
675: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
676: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
677: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
678: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
679: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
680: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
681: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
674: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
675: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
676: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
677: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
678: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
679: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
680: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
681: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
682: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
675: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
676: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
677: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
678: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
679: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
680: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
681: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
682: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
683: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
676: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
677: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
678: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
679: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
680: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
681: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
682: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
683: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
684: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
677: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
678: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
679: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
680: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
681: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
682: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
683: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
684: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
685: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
678: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
679: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
680: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
681: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
682: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
683: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
684: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
685: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
686: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
679: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
680: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
681: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
682: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
683: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
684: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
685: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
686: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
687: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
680: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
681: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
682: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
683: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
684: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
685: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
686: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
687: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
688: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
681: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
682: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
683: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
684: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
685: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
686: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
687: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
688: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
689: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
682: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
683: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
684: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
685: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
686: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
687: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
688: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
689: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
690: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
683: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
684: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
685: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
686: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
687: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
688: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
689: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
690: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
691: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
684: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
685: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
686: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
687: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
688: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
689: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
690: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
691: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
692: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
685: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
686: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
687: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
688: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
689: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
690: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
691: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
692: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
693: ,p_system_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SystemType',null)
686: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
687: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
688: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
689: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
690: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
691: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
692: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
693: ,p_system_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SystemType',null)
694: ,p_system_params => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SystemParams',null)
687: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
688: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
689: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
690: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
691: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
692: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
693: ,p_system_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SystemType',null)
694: ,p_system_params => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SystemParams',null)
695: ,p_appraisee_access => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraiseeAccess',null)
688: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
689: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
690: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
691: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
692: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
693: ,p_system_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SystemType',null)
694: ,p_system_params => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SystemParams',null)
695: ,p_appraisee_access => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraiseeAccess',null)
696: ,p_main_appraiser_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MainAppraiserId',null)
689: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
690: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
691: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
692: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
693: ,p_system_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SystemType',null)
694: ,p_system_params => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SystemParams',null)
695: ,p_appraisee_access => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraiseeAccess',null)
696: ,p_main_appraiser_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MainAppraiserId',null)
697: ,p_assignment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentId',null)
690: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
691: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
692: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
693: ,p_system_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SystemType',null)
694: ,p_system_params => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SystemParams',null)
695: ,p_appraisee_access => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraiseeAccess',null)
696: ,p_main_appraiser_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MainAppraiserId',null)
697: ,p_assignment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentId',null)
698: ,p_assignment_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'AssignmentStartDate',null)
691: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
692: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
693: ,p_system_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SystemType',null)
694: ,p_system_params => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SystemParams',null)
695: ,p_appraisee_access => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraiseeAccess',null)
696: ,p_main_appraiser_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MainAppraiserId',null)
697: ,p_assignment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentId',null)
698: ,p_assignment_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'AssignmentStartDate',null)
699: ,p_asg_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AsgBusinessGroupId',null)
692: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
693: ,p_system_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SystemType',null)
694: ,p_system_params => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SystemParams',null)
695: ,p_appraisee_access => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraiseeAccess',null)
696: ,p_main_appraiser_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MainAppraiserId',null)
697: ,p_assignment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentId',null)
698: ,p_assignment_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'AssignmentStartDate',null)
699: ,p_asg_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AsgBusinessGroupId',null)
700: ,p_assignment_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentOrganizationId',null)
693: ,p_system_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SystemType',null)
694: ,p_system_params => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SystemParams',null)
695: ,p_appraisee_access => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraiseeAccess',null)
696: ,p_main_appraiser_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MainAppraiserId',null)
697: ,p_assignment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentId',null)
698: ,p_assignment_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'AssignmentStartDate',null)
699: ,p_asg_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AsgBusinessGroupId',null)
700: ,p_assignment_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentOrganizationId',null)
701: ,p_assignment_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentJobId',null)
694: ,p_system_params => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SystemParams',null)
695: ,p_appraisee_access => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraiseeAccess',null)
696: ,p_main_appraiser_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MainAppraiserId',null)
697: ,p_assignment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentId',null)
698: ,p_assignment_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'AssignmentStartDate',null)
699: ,p_asg_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AsgBusinessGroupId',null)
700: ,p_assignment_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentOrganizationId',null)
701: ,p_assignment_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentJobId',null)
702: ,p_assignment_position_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentPositionId',null)
695: ,p_appraisee_access => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraiseeAccess',null)
696: ,p_main_appraiser_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MainAppraiserId',null)
697: ,p_assignment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentId',null)
698: ,p_assignment_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'AssignmentStartDate',null)
699: ,p_asg_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AsgBusinessGroupId',null)
700: ,p_assignment_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentOrganizationId',null)
701: ,p_assignment_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentJobId',null)
702: ,p_assignment_position_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentPositionId',null)
703: ,p_assignment_grade_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentGradeId',null)
696: ,p_main_appraiser_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MainAppraiserId',null)
697: ,p_assignment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentId',null)
698: ,p_assignment_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'AssignmentStartDate',null)
699: ,p_asg_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AsgBusinessGroupId',null)
700: ,p_assignment_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentOrganizationId',null)
701: ,p_assignment_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentJobId',null)
702: ,p_assignment_position_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentPositionId',null)
703: ,p_assignment_grade_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentGradeId',null)
704: ,p_appraisal_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AppraisalId',null)
697: ,p_assignment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentId',null)
698: ,p_assignment_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'AssignmentStartDate',null)
699: ,p_asg_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AsgBusinessGroupId',null)
700: ,p_assignment_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentOrganizationId',null)
701: ,p_assignment_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentJobId',null)
702: ,p_assignment_position_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentPositionId',null)
703: ,p_assignment_grade_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentGradeId',null)
704: ,p_appraisal_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AppraisalId',null)
705: ,p_object_version_number => l_object_version_number
698: ,p_assignment_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'AssignmentStartDate',null)
699: ,p_asg_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AsgBusinessGroupId',null)
700: ,p_assignment_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentOrganizationId',null)
701: ,p_assignment_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentJobId',null)
702: ,p_assignment_position_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentPositionId',null)
703: ,p_assignment_grade_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentGradeId',null)
704: ,p_appraisal_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AppraisalId',null)
705: ,p_object_version_number => l_object_version_number
706: ,p_return_status => l_return_status
699: ,p_asg_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AsgBusinessGroupId',null)
700: ,p_assignment_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentOrganizationId',null)
701: ,p_assignment_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentJobId',null)
702: ,p_assignment_position_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentPositionId',null)
703: ,p_assignment_grade_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentGradeId',null)
704: ,p_appraisal_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AppraisalId',null)
705: ,p_object_version_number => l_object_version_number
706: ,p_return_status => l_return_status
707: ,p_appraisal_system_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraisalSystemStatus',null)
700: ,p_assignment_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentOrganizationId',null)
701: ,p_assignment_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentJobId',null)
702: ,p_assignment_position_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentPositionId',null)
703: ,p_assignment_grade_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentGradeId',null)
704: ,p_appraisal_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AppraisalId',null)
705: ,p_object_version_number => l_object_version_number
706: ,p_return_status => l_return_status
707: ,p_appraisal_system_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraisalSystemStatus',null)
708: ,p_potential_readiness_level => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialReadinessLevel',null)
703: ,p_assignment_grade_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentGradeId',null)
704: ,p_appraisal_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AppraisalId',null)
705: ,p_object_version_number => l_object_version_number
706: ,p_return_status => l_return_status
707: ,p_appraisal_system_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraisalSystemStatus',null)
708: ,p_potential_readiness_level => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialReadinessLevel',null)
709: ,p_potential_short_term_workopp => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialShortTermWorkopp',null)
710: ,p_potential_long_term_workopp => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialLongTermWorkopp',null)
711: ,p_potential_details => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialDetails',null)
704: ,p_appraisal_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AppraisalId',null)
705: ,p_object_version_number => l_object_version_number
706: ,p_return_status => l_return_status
707: ,p_appraisal_system_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraisalSystemStatus',null)
708: ,p_potential_readiness_level => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialReadinessLevel',null)
709: ,p_potential_short_term_workopp => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialShortTermWorkopp',null)
710: ,p_potential_long_term_workopp => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialLongTermWorkopp',null)
711: ,p_potential_details => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialDetails',null)
712: ,p_event_id => hr_transaction_swi.getNumberValue(l_CommitNode,'EventId',null)
705: ,p_object_version_number => l_object_version_number
706: ,p_return_status => l_return_status
707: ,p_appraisal_system_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraisalSystemStatus',null)
708: ,p_potential_readiness_level => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialReadinessLevel',null)
709: ,p_potential_short_term_workopp => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialShortTermWorkopp',null)
710: ,p_potential_long_term_workopp => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialLongTermWorkopp',null)
711: ,p_potential_details => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialDetails',null)
712: ,p_event_id => hr_transaction_swi.getNumberValue(l_CommitNode,'EventId',null)
713: ,p_show_competency_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowCompetencyRatings',null)
706: ,p_return_status => l_return_status
707: ,p_appraisal_system_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraisalSystemStatus',null)
708: ,p_potential_readiness_level => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialReadinessLevel',null)
709: ,p_potential_short_term_workopp => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialShortTermWorkopp',null)
710: ,p_potential_long_term_workopp => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialLongTermWorkopp',null)
711: ,p_potential_details => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialDetails',null)
712: ,p_event_id => hr_transaction_swi.getNumberValue(l_CommitNode,'EventId',null)
713: ,p_show_competency_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowCompetencyRatings',null)
714: ,p_show_objective_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowObjectiveRatings',null)
707: ,p_appraisal_system_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraisalSystemStatus',null)
708: ,p_potential_readiness_level => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialReadinessLevel',null)
709: ,p_potential_short_term_workopp => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialShortTermWorkopp',null)
710: ,p_potential_long_term_workopp => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialLongTermWorkopp',null)
711: ,p_potential_details => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialDetails',null)
712: ,p_event_id => hr_transaction_swi.getNumberValue(l_CommitNode,'EventId',null)
713: ,p_show_competency_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowCompetencyRatings',null)
714: ,p_show_objective_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowObjectiveRatings',null)
715: ,p_show_questionnaire_info => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowQuestionnaireInfo',null)
708: ,p_potential_readiness_level => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialReadinessLevel',null)
709: ,p_potential_short_term_workopp => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialShortTermWorkopp',null)
710: ,p_potential_long_term_workopp => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialLongTermWorkopp',null)
711: ,p_potential_details => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialDetails',null)
712: ,p_event_id => hr_transaction_swi.getNumberValue(l_CommitNode,'EventId',null)
713: ,p_show_competency_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowCompetencyRatings',null)
714: ,p_show_objective_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowObjectiveRatings',null)
715: ,p_show_questionnaire_info => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowQuestionnaireInfo',null)
716: ,p_show_participant_details => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantDetails',null)
709: ,p_potential_short_term_workopp => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialShortTermWorkopp',null)
710: ,p_potential_long_term_workopp => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialLongTermWorkopp',null)
711: ,p_potential_details => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialDetails',null)
712: ,p_event_id => hr_transaction_swi.getNumberValue(l_CommitNode,'EventId',null)
713: ,p_show_competency_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowCompetencyRatings',null)
714: ,p_show_objective_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowObjectiveRatings',null)
715: ,p_show_questionnaire_info => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowQuestionnaireInfo',null)
716: ,p_show_participant_details => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantDetails',null)
717: ,p_show_participant_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantRatings',null)
710: ,p_potential_long_term_workopp => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialLongTermWorkopp',null)
711: ,p_potential_details => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialDetails',null)
712: ,p_event_id => hr_transaction_swi.getNumberValue(l_CommitNode,'EventId',null)
713: ,p_show_competency_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowCompetencyRatings',null)
714: ,p_show_objective_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowObjectiveRatings',null)
715: ,p_show_questionnaire_info => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowQuestionnaireInfo',null)
716: ,p_show_participant_details => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantDetails',null)
717: ,p_show_participant_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantRatings',null)
718: ,p_show_participant_names => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantNames',null)
711: ,p_potential_details => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialDetails',null)
712: ,p_event_id => hr_transaction_swi.getNumberValue(l_CommitNode,'EventId',null)
713: ,p_show_competency_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowCompetencyRatings',null)
714: ,p_show_objective_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowObjectiveRatings',null)
715: ,p_show_questionnaire_info => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowQuestionnaireInfo',null)
716: ,p_show_participant_details => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantDetails',null)
717: ,p_show_participant_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantRatings',null)
718: ,p_show_participant_names => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantNames',null)
719: ,p_show_overall_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowOverallRatings',null)
712: ,p_event_id => hr_transaction_swi.getNumberValue(l_CommitNode,'EventId',null)
713: ,p_show_competency_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowCompetencyRatings',null)
714: ,p_show_objective_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowObjectiveRatings',null)
715: ,p_show_questionnaire_info => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowQuestionnaireInfo',null)
716: ,p_show_participant_details => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantDetails',null)
717: ,p_show_participant_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantRatings',null)
718: ,p_show_participant_names => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantNames',null)
719: ,p_show_overall_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowOverallRatings',null)
720: ,p_show_overall_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowOverallComments',null)
713: ,p_show_competency_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowCompetencyRatings',null)
714: ,p_show_objective_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowObjectiveRatings',null)
715: ,p_show_questionnaire_info => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowQuestionnaireInfo',null)
716: ,p_show_participant_details => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantDetails',null)
717: ,p_show_participant_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantRatings',null)
718: ,p_show_participant_names => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantNames',null)
719: ,p_show_overall_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowOverallRatings',null)
720: ,p_show_overall_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowOverallComments',null)
721: ,p_update_appraisal => hr_transaction_swi.getVarchar2Value(l_CommitNode,'UpdateAppraisal',null)
714: ,p_show_objective_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowObjectiveRatings',null)
715: ,p_show_questionnaire_info => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowQuestionnaireInfo',null)
716: ,p_show_participant_details => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantDetails',null)
717: ,p_show_participant_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantRatings',null)
718: ,p_show_participant_names => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantNames',null)
719: ,p_show_overall_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowOverallRatings',null)
720: ,p_show_overall_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowOverallComments',null)
721: ,p_update_appraisal => hr_transaction_swi.getVarchar2Value(l_CommitNode,'UpdateAppraisal',null)
722: ,p_provide_overall_feedback => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProvideOverallFeedback',null)
715: ,p_show_questionnaire_info => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowQuestionnaireInfo',null)
716: ,p_show_participant_details => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantDetails',null)
717: ,p_show_participant_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantRatings',null)
718: ,p_show_participant_names => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantNames',null)
719: ,p_show_overall_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowOverallRatings',null)
720: ,p_show_overall_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowOverallComments',null)
721: ,p_update_appraisal => hr_transaction_swi.getVarchar2Value(l_CommitNode,'UpdateAppraisal',null)
722: ,p_provide_overall_feedback => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProvideOverallFeedback',null)
723: ,p_appraisee_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraiseeComments',null)
716: ,p_show_participant_details => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantDetails',null)
717: ,p_show_participant_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantRatings',null)
718: ,p_show_participant_names => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantNames',null)
719: ,p_show_overall_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowOverallRatings',null)
720: ,p_show_overall_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowOverallComments',null)
721: ,p_update_appraisal => hr_transaction_swi.getVarchar2Value(l_CommitNode,'UpdateAppraisal',null)
722: ,p_provide_overall_feedback => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProvideOverallFeedback',null)
723: ,p_appraisee_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraiseeComments',null)
724: );
717: ,p_show_participant_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantRatings',null)
718: ,p_show_participant_names => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantNames',null)
719: ,p_show_overall_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowOverallRatings',null)
720: ,p_show_overall_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowOverallComments',null)
721: ,p_update_appraisal => hr_transaction_swi.getVarchar2Value(l_CommitNode,'UpdateAppraisal',null)
722: ,p_provide_overall_feedback => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProvideOverallFeedback',null)
723: ,p_appraisee_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraiseeComments',null)
724: );
725:
718: ,p_show_participant_names => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantNames',null)
719: ,p_show_overall_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowOverallRatings',null)
720: ,p_show_overall_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowOverallComments',null)
721: ,p_update_appraisal => hr_transaction_swi.getVarchar2Value(l_CommitNode,'UpdateAppraisal',null)
722: ,p_provide_overall_feedback => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProvideOverallFeedback',null)
723: ,p_appraisee_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraiseeComments',null)
724: );
725:
726: elsif l_postState = '2' then
719: ,p_show_overall_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowOverallRatings',null)
720: ,p_show_overall_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowOverallComments',null)
721: ,p_update_appraisal => hr_transaction_swi.getVarchar2Value(l_CommitNode,'UpdateAppraisal',null)
722: ,p_provide_overall_feedback => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProvideOverallFeedback',null)
723: ,p_appraisee_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraiseeComments',null)
724: );
725:
726: elsif l_postState = '2' then
727:
727:
728: update_appraisal
729: ( p_validate => p_validate
730: ,p_effective_date => p_effective_date
731: ,p_appraisal_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AppraisalId')
732: ,p_object_version_number => l_object_version_number
733: ,p_appraiser_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AppraiserPersonId')
734: ,p_appraisal_date => hr_transaction_swi.getDateValue(l_CommitNode,'AppraisalDate')
735: ,p_appraisal_period_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'AppraisalPeriodEndDate')
729: ( p_validate => p_validate
730: ,p_effective_date => p_effective_date
731: ,p_appraisal_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AppraisalId')
732: ,p_object_version_number => l_object_version_number
733: ,p_appraiser_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AppraiserPersonId')
734: ,p_appraisal_date => hr_transaction_swi.getDateValue(l_CommitNode,'AppraisalDate')
735: ,p_appraisal_period_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'AppraisalPeriodEndDate')
736: ,p_appraisal_period_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'AppraisalPeriodStartDate')
737: ,p_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Type')
730: ,p_effective_date => p_effective_date
731: ,p_appraisal_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AppraisalId')
732: ,p_object_version_number => l_object_version_number
733: ,p_appraiser_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AppraiserPersonId')
734: ,p_appraisal_date => hr_transaction_swi.getDateValue(l_CommitNode,'AppraisalDate')
735: ,p_appraisal_period_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'AppraisalPeriodEndDate')
736: ,p_appraisal_period_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'AppraisalPeriodStartDate')
737: ,p_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Type')
738: ,p_next_appraisal_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextAppraisalDate')
731: ,p_appraisal_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AppraisalId')
732: ,p_object_version_number => l_object_version_number
733: ,p_appraiser_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AppraiserPersonId')
734: ,p_appraisal_date => hr_transaction_swi.getDateValue(l_CommitNode,'AppraisalDate')
735: ,p_appraisal_period_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'AppraisalPeriodEndDate')
736: ,p_appraisal_period_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'AppraisalPeriodStartDate')
737: ,p_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Type')
738: ,p_next_appraisal_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextAppraisalDate')
739: ,p_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Status')
732: ,p_object_version_number => l_object_version_number
733: ,p_appraiser_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AppraiserPersonId')
734: ,p_appraisal_date => hr_transaction_swi.getDateValue(l_CommitNode,'AppraisalDate')
735: ,p_appraisal_period_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'AppraisalPeriodEndDate')
736: ,p_appraisal_period_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'AppraisalPeriodStartDate')
737: ,p_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Type')
738: ,p_next_appraisal_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextAppraisalDate')
739: ,p_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Status')
740: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
733: ,p_appraiser_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AppraiserPersonId')
734: ,p_appraisal_date => hr_transaction_swi.getDateValue(l_CommitNode,'AppraisalDate')
735: ,p_appraisal_period_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'AppraisalPeriodEndDate')
736: ,p_appraisal_period_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'AppraisalPeriodStartDate')
737: ,p_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Type')
738: ,p_next_appraisal_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextAppraisalDate')
739: ,p_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Status')
740: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
741: ,p_overall_performance_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OverallPerformanceLevelId')
734: ,p_appraisal_date => hr_transaction_swi.getDateValue(l_CommitNode,'AppraisalDate')
735: ,p_appraisal_period_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'AppraisalPeriodEndDate')
736: ,p_appraisal_period_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'AppraisalPeriodStartDate')
737: ,p_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Type')
738: ,p_next_appraisal_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextAppraisalDate')
739: ,p_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Status')
740: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
741: ,p_overall_performance_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OverallPerformanceLevelId')
742: ,p_open => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Open')
735: ,p_appraisal_period_end_date => hr_transaction_swi.getDateValue(l_CommitNode,'AppraisalPeriodEndDate')
736: ,p_appraisal_period_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'AppraisalPeriodStartDate')
737: ,p_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Type')
738: ,p_next_appraisal_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextAppraisalDate')
739: ,p_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Status')
740: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
741: ,p_overall_performance_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OverallPerformanceLevelId')
742: ,p_open => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Open')
743: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
736: ,p_appraisal_period_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'AppraisalPeriodStartDate')
737: ,p_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Type')
738: ,p_next_appraisal_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextAppraisalDate')
739: ,p_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Status')
740: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
741: ,p_overall_performance_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OverallPerformanceLevelId')
742: ,p_open => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Open')
743: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
744: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
737: ,p_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Type')
738: ,p_next_appraisal_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextAppraisalDate')
739: ,p_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Status')
740: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
741: ,p_overall_performance_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OverallPerformanceLevelId')
742: ,p_open => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Open')
743: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
744: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
745: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
738: ,p_next_appraisal_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextAppraisalDate')
739: ,p_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Status')
740: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
741: ,p_overall_performance_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OverallPerformanceLevelId')
742: ,p_open => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Open')
743: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
744: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
745: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
746: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
739: ,p_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Status')
740: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
741: ,p_overall_performance_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OverallPerformanceLevelId')
742: ,p_open => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Open')
743: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
744: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
745: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
746: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
747: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
740: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
741: ,p_overall_performance_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OverallPerformanceLevelId')
742: ,p_open => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Open')
743: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
744: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
745: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
746: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
747: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
748: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
741: ,p_overall_performance_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OverallPerformanceLevelId')
742: ,p_open => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Open')
743: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
744: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
745: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
746: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
747: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
748: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
749: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
742: ,p_open => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Open')
743: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
744: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
745: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
746: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
747: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
748: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
749: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
750: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
743: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
744: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
745: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
746: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
747: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
748: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
749: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
750: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
751: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
744: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
745: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
746: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
747: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
748: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
749: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
750: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
751: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
752: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
745: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
746: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
747: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
748: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
749: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
750: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
751: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
752: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
753: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
746: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
747: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
748: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
749: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
750: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
751: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
752: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
753: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
754: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
747: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
748: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
749: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
750: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
751: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
752: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
753: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
754: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
755: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
748: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
749: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
750: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
751: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
752: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
753: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
754: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
755: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
756: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
749: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
750: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
751: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
752: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
753: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
754: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
755: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
756: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
757: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
750: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
751: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
752: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
753: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
754: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
755: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
756: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
757: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
758: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
751: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
752: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
753: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
754: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
755: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
756: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
757: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
758: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
759: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
752: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
753: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
754: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
755: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
756: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
757: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
758: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
759: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
760: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
753: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
754: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
755: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
756: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
757: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
758: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
759: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
760: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
761: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
754: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
755: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
756: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
757: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
758: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
759: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
760: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
761: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
762: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
755: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
756: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
757: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
758: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
759: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
760: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
761: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
762: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
763: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
756: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
757: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
758: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
759: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
760: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
761: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
762: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
763: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
764: ,p_system_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SystemType')
757: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
758: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
759: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
760: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
761: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
762: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
763: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
764: ,p_system_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SystemType')
765: ,p_system_params => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SystemParams')
758: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
759: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
760: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
761: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
762: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
763: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
764: ,p_system_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SystemType')
765: ,p_system_params => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SystemParams')
766: ,p_appraisee_access => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraiseeAccess')
759: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
760: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
761: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
762: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
763: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
764: ,p_system_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SystemType')
765: ,p_system_params => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SystemParams')
766: ,p_appraisee_access => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraiseeAccess')
767: ,p_main_appraiser_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MainAppraiserId')
760: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
761: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
762: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
763: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
764: ,p_system_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SystemType')
765: ,p_system_params => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SystemParams')
766: ,p_appraisee_access => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraiseeAccess')
767: ,p_main_appraiser_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MainAppraiserId')
768: ,p_assignment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentId')
761: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
762: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
763: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
764: ,p_system_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SystemType')
765: ,p_system_params => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SystemParams')
766: ,p_appraisee_access => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraiseeAccess')
767: ,p_main_appraiser_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MainAppraiserId')
768: ,p_assignment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentId')
769: ,p_assignment_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'AssignmentStartDate')
762: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
763: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
764: ,p_system_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SystemType')
765: ,p_system_params => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SystemParams')
766: ,p_appraisee_access => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraiseeAccess')
767: ,p_main_appraiser_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MainAppraiserId')
768: ,p_assignment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentId')
769: ,p_assignment_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'AssignmentStartDate')
770: ,p_asg_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AsgBusinessGroupId')
763: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
764: ,p_system_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SystemType')
765: ,p_system_params => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SystemParams')
766: ,p_appraisee_access => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraiseeAccess')
767: ,p_main_appraiser_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MainAppraiserId')
768: ,p_assignment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentId')
769: ,p_assignment_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'AssignmentStartDate')
770: ,p_asg_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AsgBusinessGroupId')
771: ,p_assignment_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentOrganizationId')
764: ,p_system_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SystemType')
765: ,p_system_params => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SystemParams')
766: ,p_appraisee_access => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraiseeAccess')
767: ,p_main_appraiser_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MainAppraiserId')
768: ,p_assignment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentId')
769: ,p_assignment_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'AssignmentStartDate')
770: ,p_asg_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AsgBusinessGroupId')
771: ,p_assignment_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentOrganizationId')
772: ,p_assignment_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentJobId')
765: ,p_system_params => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SystemParams')
766: ,p_appraisee_access => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraiseeAccess')
767: ,p_main_appraiser_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MainAppraiserId')
768: ,p_assignment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentId')
769: ,p_assignment_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'AssignmentStartDate')
770: ,p_asg_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AsgBusinessGroupId')
771: ,p_assignment_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentOrganizationId')
772: ,p_assignment_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentJobId')
773: ,p_assignment_position_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentPositionId')
766: ,p_appraisee_access => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraiseeAccess')
767: ,p_main_appraiser_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MainAppraiserId')
768: ,p_assignment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentId')
769: ,p_assignment_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'AssignmentStartDate')
770: ,p_asg_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AsgBusinessGroupId')
771: ,p_assignment_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentOrganizationId')
772: ,p_assignment_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentJobId')
773: ,p_assignment_position_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentPositionId')
774: ,p_assignment_grade_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentGradeId')
767: ,p_main_appraiser_id => hr_transaction_swi.getNumberValue(l_CommitNode,'MainAppraiserId')
768: ,p_assignment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentId')
769: ,p_assignment_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'AssignmentStartDate')
770: ,p_asg_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AsgBusinessGroupId')
771: ,p_assignment_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentOrganizationId')
772: ,p_assignment_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentJobId')
773: ,p_assignment_position_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentPositionId')
774: ,p_assignment_grade_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentGradeId')
775: ,p_return_status => l_return_status
768: ,p_assignment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentId')
769: ,p_assignment_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'AssignmentStartDate')
770: ,p_asg_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AsgBusinessGroupId')
771: ,p_assignment_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentOrganizationId')
772: ,p_assignment_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentJobId')
773: ,p_assignment_position_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentPositionId')
774: ,p_assignment_grade_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentGradeId')
775: ,p_return_status => l_return_status
776: ,p_appraisal_system_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraisalSystemStatus')
769: ,p_assignment_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'AssignmentStartDate')
770: ,p_asg_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AsgBusinessGroupId')
771: ,p_assignment_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentOrganizationId')
772: ,p_assignment_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentJobId')
773: ,p_assignment_position_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentPositionId')
774: ,p_assignment_grade_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentGradeId')
775: ,p_return_status => l_return_status
776: ,p_appraisal_system_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraisalSystemStatus')
777: ,p_potential_readiness_level => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialReadinessLevel')
770: ,p_asg_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AsgBusinessGroupId')
771: ,p_assignment_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentOrganizationId')
772: ,p_assignment_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentJobId')
773: ,p_assignment_position_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentPositionId')
774: ,p_assignment_grade_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentGradeId')
775: ,p_return_status => l_return_status
776: ,p_appraisal_system_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraisalSystemStatus')
777: ,p_potential_readiness_level => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialReadinessLevel')
778: ,p_potential_short_term_workopp => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialShortTermWorkopp')
772: ,p_assignment_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentJobId')
773: ,p_assignment_position_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentPositionId')
774: ,p_assignment_grade_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentGradeId')
775: ,p_return_status => l_return_status
776: ,p_appraisal_system_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraisalSystemStatus')
777: ,p_potential_readiness_level => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialReadinessLevel')
778: ,p_potential_short_term_workopp => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialShortTermWorkopp')
779: ,p_potential_long_term_workopp => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialLongTermWorkopp')
780: ,p_potential_details => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialDetails')
773: ,p_assignment_position_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentPositionId')
774: ,p_assignment_grade_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentGradeId')
775: ,p_return_status => l_return_status
776: ,p_appraisal_system_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraisalSystemStatus')
777: ,p_potential_readiness_level => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialReadinessLevel')
778: ,p_potential_short_term_workopp => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialShortTermWorkopp')
779: ,p_potential_long_term_workopp => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialLongTermWorkopp')
780: ,p_potential_details => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialDetails')
781: ,p_event_id => hr_transaction_swi.getNumberValue(l_CommitNode,'EventId')
774: ,p_assignment_grade_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentGradeId')
775: ,p_return_status => l_return_status
776: ,p_appraisal_system_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraisalSystemStatus')
777: ,p_potential_readiness_level => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialReadinessLevel')
778: ,p_potential_short_term_workopp => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialShortTermWorkopp')
779: ,p_potential_long_term_workopp => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialLongTermWorkopp')
780: ,p_potential_details => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialDetails')
781: ,p_event_id => hr_transaction_swi.getNumberValue(l_CommitNode,'EventId')
782: ,p_show_competency_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowCompetencyRatings')
775: ,p_return_status => l_return_status
776: ,p_appraisal_system_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraisalSystemStatus')
777: ,p_potential_readiness_level => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialReadinessLevel')
778: ,p_potential_short_term_workopp => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialShortTermWorkopp')
779: ,p_potential_long_term_workopp => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialLongTermWorkopp')
780: ,p_potential_details => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialDetails')
781: ,p_event_id => hr_transaction_swi.getNumberValue(l_CommitNode,'EventId')
782: ,p_show_competency_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowCompetencyRatings')
783: ,p_show_objective_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowObjectiveRatings')
776: ,p_appraisal_system_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraisalSystemStatus')
777: ,p_potential_readiness_level => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialReadinessLevel')
778: ,p_potential_short_term_workopp => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialShortTermWorkopp')
779: ,p_potential_long_term_workopp => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialLongTermWorkopp')
780: ,p_potential_details => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialDetails')
781: ,p_event_id => hr_transaction_swi.getNumberValue(l_CommitNode,'EventId')
782: ,p_show_competency_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowCompetencyRatings')
783: ,p_show_objective_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowObjectiveRatings')
784: ,p_show_questionnaire_info => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowQuestionnaireInfo')
777: ,p_potential_readiness_level => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialReadinessLevel')
778: ,p_potential_short_term_workopp => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialShortTermWorkopp')
779: ,p_potential_long_term_workopp => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialLongTermWorkopp')
780: ,p_potential_details => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialDetails')
781: ,p_event_id => hr_transaction_swi.getNumberValue(l_CommitNode,'EventId')
782: ,p_show_competency_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowCompetencyRatings')
783: ,p_show_objective_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowObjectiveRatings')
784: ,p_show_questionnaire_info => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowQuestionnaireInfo')
785: ,p_show_participant_details => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantDetails')
778: ,p_potential_short_term_workopp => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialShortTermWorkopp')
779: ,p_potential_long_term_workopp => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialLongTermWorkopp')
780: ,p_potential_details => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialDetails')
781: ,p_event_id => hr_transaction_swi.getNumberValue(l_CommitNode,'EventId')
782: ,p_show_competency_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowCompetencyRatings')
783: ,p_show_objective_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowObjectiveRatings')
784: ,p_show_questionnaire_info => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowQuestionnaireInfo')
785: ,p_show_participant_details => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantDetails')
786: ,p_show_participant_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantRatings')
779: ,p_potential_long_term_workopp => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialLongTermWorkopp')
780: ,p_potential_details => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialDetails')
781: ,p_event_id => hr_transaction_swi.getNumberValue(l_CommitNode,'EventId')
782: ,p_show_competency_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowCompetencyRatings')
783: ,p_show_objective_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowObjectiveRatings')
784: ,p_show_questionnaire_info => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowQuestionnaireInfo')
785: ,p_show_participant_details => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantDetails')
786: ,p_show_participant_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantRatings')
787: ,p_show_participant_names => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantNames')
780: ,p_potential_details => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PotentialDetails')
781: ,p_event_id => hr_transaction_swi.getNumberValue(l_CommitNode,'EventId')
782: ,p_show_competency_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowCompetencyRatings')
783: ,p_show_objective_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowObjectiveRatings')
784: ,p_show_questionnaire_info => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowQuestionnaireInfo')
785: ,p_show_participant_details => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantDetails')
786: ,p_show_participant_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantRatings')
787: ,p_show_participant_names => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantNames')
788: ,p_show_overall_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowOverallRatings')
781: ,p_event_id => hr_transaction_swi.getNumberValue(l_CommitNode,'EventId')
782: ,p_show_competency_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowCompetencyRatings')
783: ,p_show_objective_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowObjectiveRatings')
784: ,p_show_questionnaire_info => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowQuestionnaireInfo')
785: ,p_show_participant_details => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantDetails')
786: ,p_show_participant_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantRatings')
787: ,p_show_participant_names => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantNames')
788: ,p_show_overall_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowOverallRatings')
789: ,p_show_overall_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowOverallComments')
782: ,p_show_competency_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowCompetencyRatings')
783: ,p_show_objective_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowObjectiveRatings')
784: ,p_show_questionnaire_info => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowQuestionnaireInfo')
785: ,p_show_participant_details => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantDetails')
786: ,p_show_participant_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantRatings')
787: ,p_show_participant_names => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantNames')
788: ,p_show_overall_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowOverallRatings')
789: ,p_show_overall_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowOverallComments')
790: ,p_update_appraisal => hr_transaction_swi.getVarchar2Value(l_CommitNode,'UpdateAppraisal')
783: ,p_show_objective_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowObjectiveRatings')
784: ,p_show_questionnaire_info => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowQuestionnaireInfo')
785: ,p_show_participant_details => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantDetails')
786: ,p_show_participant_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantRatings')
787: ,p_show_participant_names => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantNames')
788: ,p_show_overall_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowOverallRatings')
789: ,p_show_overall_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowOverallComments')
790: ,p_update_appraisal => hr_transaction_swi.getVarchar2Value(l_CommitNode,'UpdateAppraisal')
791: ,p_provide_overall_feedback => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProvideOverallFeedback')
784: ,p_show_questionnaire_info => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowQuestionnaireInfo')
785: ,p_show_participant_details => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantDetails')
786: ,p_show_participant_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantRatings')
787: ,p_show_participant_names => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantNames')
788: ,p_show_overall_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowOverallRatings')
789: ,p_show_overall_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowOverallComments')
790: ,p_update_appraisal => hr_transaction_swi.getVarchar2Value(l_CommitNode,'UpdateAppraisal')
791: ,p_provide_overall_feedback => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProvideOverallFeedback')
792: ,p_appraisee_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraiseeComments')
785: ,p_show_participant_details => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantDetails')
786: ,p_show_participant_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantRatings')
787: ,p_show_participant_names => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantNames')
788: ,p_show_overall_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowOverallRatings')
789: ,p_show_overall_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowOverallComments')
790: ,p_update_appraisal => hr_transaction_swi.getVarchar2Value(l_CommitNode,'UpdateAppraisal')
791: ,p_provide_overall_feedback => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProvideOverallFeedback')
792: ,p_appraisee_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraiseeComments')
793: );
786: ,p_show_participant_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantRatings')
787: ,p_show_participant_names => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantNames')
788: ,p_show_overall_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowOverallRatings')
789: ,p_show_overall_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowOverallComments')
790: ,p_update_appraisal => hr_transaction_swi.getVarchar2Value(l_CommitNode,'UpdateAppraisal')
791: ,p_provide_overall_feedback => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProvideOverallFeedback')
792: ,p_appraisee_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraiseeComments')
793: );
794:
787: ,p_show_participant_names => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowParticipantNames')
788: ,p_show_overall_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowOverallRatings')
789: ,p_show_overall_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowOverallComments')
790: ,p_update_appraisal => hr_transaction_swi.getVarchar2Value(l_CommitNode,'UpdateAppraisal')
791: ,p_provide_overall_feedback => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProvideOverallFeedback')
792: ,p_appraisee_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraiseeComments')
793: );
794:
795: elsif l_postState = '3' then
788: ,p_show_overall_ratings => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowOverallRatings')
789: ,p_show_overall_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ShowOverallComments')
790: ,p_update_appraisal => hr_transaction_swi.getVarchar2Value(l_CommitNode,'UpdateAppraisal')
791: ,p_provide_overall_feedback => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProvideOverallFeedback')
792: ,p_appraisee_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AppraiseeComments')
793: );
794:
795: elsif l_postState = '3' then
796:
795: elsif l_postState = '3' then
796:
797: delete_appraisal
798: ( p_validate => p_validate
799: ,p_appraisal_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AppraisalId')
800: ,p_object_version_number => l_object_version_number
801: ,p_return_status => l_return_status
802: );
803: