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