457: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
458:
459: l_commitElement := xmldom.makeElement(l_CommitNode);
460: l_postState := xmldom.getAttribute(l_commitElement, 'PS');
461: l_object_version_number := hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectVersionNumber');
462:
463: if l_postState = '0' then
464:
465: create_participant
464:
465: create_participant
466: ( p_validate => p_validate
467: ,p_effective_date => p_effective_date
468: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',null)
469: ,p_questionnaire_template_id => hr_transaction_swi.getNumberValue(l_CommitNode,'QuestionnaireTemplateId',null)
470: ,p_participation_in_table => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ParticipationInTable',null)
471: ,p_participation_in_column => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ParticipationInColumn',null)
472: ,p_participation_in_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ParticipationInId',null)
465: create_participant
466: ( p_validate => p_validate
467: ,p_effective_date => p_effective_date
468: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',null)
469: ,p_questionnaire_template_id => hr_transaction_swi.getNumberValue(l_CommitNode,'QuestionnaireTemplateId',null)
470: ,p_participation_in_table => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ParticipationInTable',null)
471: ,p_participation_in_column => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ParticipationInColumn',null)
472: ,p_participation_in_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ParticipationInId',null)
473: ,p_participation_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ParticipationStatus',null)
466: ( p_validate => p_validate
467: ,p_effective_date => p_effective_date
468: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',null)
469: ,p_questionnaire_template_id => hr_transaction_swi.getNumberValue(l_CommitNode,'QuestionnaireTemplateId',null)
470: ,p_participation_in_table => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ParticipationInTable',null)
471: ,p_participation_in_column => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ParticipationInColumn',null)
472: ,p_participation_in_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ParticipationInId',null)
473: ,p_participation_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ParticipationStatus',null)
474: ,p_participation_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ParticipationType',null)
467: ,p_effective_date => p_effective_date
468: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',null)
469: ,p_questionnaire_template_id => hr_transaction_swi.getNumberValue(l_CommitNode,'QuestionnaireTemplateId',null)
470: ,p_participation_in_table => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ParticipationInTable',null)
471: ,p_participation_in_column => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ParticipationInColumn',null)
472: ,p_participation_in_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ParticipationInId',null)
473: ,p_participation_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ParticipationStatus',null)
474: ,p_participation_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ParticipationType',null)
475: ,p_last_notified_date => hr_transaction_swi.getDateValue(l_CommitNode,'LastNotifiedDate',null)
468: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',null)
469: ,p_questionnaire_template_id => hr_transaction_swi.getNumberValue(l_CommitNode,'QuestionnaireTemplateId',null)
470: ,p_participation_in_table => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ParticipationInTable',null)
471: ,p_participation_in_column => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ParticipationInColumn',null)
472: ,p_participation_in_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ParticipationInId',null)
473: ,p_participation_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ParticipationStatus',null)
474: ,p_participation_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ParticipationType',null)
475: ,p_last_notified_date => hr_transaction_swi.getDateValue(l_CommitNode,'LastNotifiedDate',null)
476: ,p_date_completed => hr_transaction_swi.getDateValue(l_CommitNode,'DateCompleted',null)
469: ,p_questionnaire_template_id => hr_transaction_swi.getNumberValue(l_CommitNode,'QuestionnaireTemplateId',null)
470: ,p_participation_in_table => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ParticipationInTable',null)
471: ,p_participation_in_column => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ParticipationInColumn',null)
472: ,p_participation_in_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ParticipationInId',null)
473: ,p_participation_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ParticipationStatus',null)
474: ,p_participation_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ParticipationType',null)
475: ,p_last_notified_date => hr_transaction_swi.getDateValue(l_CommitNode,'LastNotifiedDate',null)
476: ,p_date_completed => hr_transaction_swi.getDateValue(l_CommitNode,'DateCompleted',null)
477: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
470: ,p_participation_in_table => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ParticipationInTable',null)
471: ,p_participation_in_column => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ParticipationInColumn',null)
472: ,p_participation_in_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ParticipationInId',null)
473: ,p_participation_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ParticipationStatus',null)
474: ,p_participation_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ParticipationType',null)
475: ,p_last_notified_date => hr_transaction_swi.getDateValue(l_CommitNode,'LastNotifiedDate',null)
476: ,p_date_completed => hr_transaction_swi.getDateValue(l_CommitNode,'DateCompleted',null)
477: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
478: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId',null)
471: ,p_participation_in_column => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ParticipationInColumn',null)
472: ,p_participation_in_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ParticipationInId',null)
473: ,p_participation_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ParticipationStatus',null)
474: ,p_participation_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ParticipationType',null)
475: ,p_last_notified_date => hr_transaction_swi.getDateValue(l_CommitNode,'LastNotifiedDate',null)
476: ,p_date_completed => hr_transaction_swi.getDateValue(l_CommitNode,'DateCompleted',null)
477: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
478: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId',null)
479: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
472: ,p_participation_in_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ParticipationInId',null)
473: ,p_participation_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ParticipationStatus',null)
474: ,p_participation_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ParticipationType',null)
475: ,p_last_notified_date => hr_transaction_swi.getDateValue(l_CommitNode,'LastNotifiedDate',null)
476: ,p_date_completed => hr_transaction_swi.getDateValue(l_CommitNode,'DateCompleted',null)
477: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
478: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId',null)
479: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
480: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
473: ,p_participation_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ParticipationStatus',null)
474: ,p_participation_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ParticipationType',null)
475: ,p_last_notified_date => hr_transaction_swi.getDateValue(l_CommitNode,'LastNotifiedDate',null)
476: ,p_date_completed => hr_transaction_swi.getDateValue(l_CommitNode,'DateCompleted',null)
477: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
478: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId',null)
479: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
480: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
481: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
474: ,p_participation_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ParticipationType',null)
475: ,p_last_notified_date => hr_transaction_swi.getDateValue(l_CommitNode,'LastNotifiedDate',null)
476: ,p_date_completed => hr_transaction_swi.getDateValue(l_CommitNode,'DateCompleted',null)
477: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
478: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId',null)
479: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
480: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
481: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
482: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
475: ,p_last_notified_date => hr_transaction_swi.getDateValue(l_CommitNode,'LastNotifiedDate',null)
476: ,p_date_completed => hr_transaction_swi.getDateValue(l_CommitNode,'DateCompleted',null)
477: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
478: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId',null)
479: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
480: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
481: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
482: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
483: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
476: ,p_date_completed => hr_transaction_swi.getDateValue(l_CommitNode,'DateCompleted',null)
477: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
478: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId',null)
479: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
480: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
481: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
482: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
483: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
484: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
477: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
478: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId',null)
479: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
480: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
481: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
482: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
483: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
484: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
485: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
478: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId',null)
479: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
480: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
481: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
482: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
483: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
484: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
485: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
486: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
479: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
480: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
481: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
482: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
483: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
484: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
485: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
486: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
487: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
480: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
481: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
482: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
483: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
484: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
485: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
486: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
487: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
488: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
481: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
482: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
483: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
484: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
485: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
486: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
487: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
488: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
489: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
482: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
483: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
484: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
485: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
486: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
487: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
488: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
489: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
490: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
483: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
484: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
485: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
486: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
487: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
488: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
489: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
490: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
491: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
484: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
485: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
486: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
487: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
488: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
489: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
490: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
491: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
492: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
485: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
486: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
487: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
488: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
489: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
490: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
491: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
492: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
493: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
486: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
487: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
488: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
489: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
490: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
491: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
492: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
493: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
494: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
487: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
488: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
489: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
490: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
491: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
492: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
493: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
494: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
495: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
488: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
489: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
490: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
491: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
492: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
493: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
494: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
495: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
496: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
489: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
490: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
491: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
492: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
493: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
494: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
495: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
496: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
497: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
490: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
491: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
492: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
493: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
494: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
495: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
496: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
497: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
498: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
491: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
492: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
493: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
494: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
495: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
496: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
497: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
498: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
499: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
492: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
493: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
494: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
495: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
496: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
497: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
498: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
499: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
500: ,p_participant_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ParticipantId',null)
493: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
494: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
495: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
496: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
497: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
498: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
499: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
500: ,p_participant_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ParticipantId',null)
501: ,p_object_version_number => l_object_version_number
494: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
495: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
496: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
497: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
498: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
499: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
500: ,p_participant_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ParticipantId',null)
501: ,p_object_version_number => l_object_version_number
502: ,p_return_status => l_return_status
495: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
496: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
497: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
498: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
499: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
500: ,p_participant_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ParticipantId',null)
501: ,p_object_version_number => l_object_version_number
502: ,p_return_status => l_return_status
503: );
496: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
497: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
498: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
499: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
500: ,p_participant_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ParticipantId',null)
501: ,p_object_version_number => l_object_version_number
502: ,p_return_status => l_return_status
503: );
504:
506:
507: update_participant
508: ( p_validate => p_validate
509: ,p_effective_date => p_effective_date
510: ,p_participant_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ParticipantId')
511: ,p_object_version_number => l_object_version_number
512: ,p_questionnaire_template_id => hr_transaction_swi.getNumberValue(l_CommitNode,'QuestionnaireTemplateId')
513: ,p_participation_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ParticipationStatus')
514: ,p_participation_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ParticipationType')
508: ( p_validate => p_validate
509: ,p_effective_date => p_effective_date
510: ,p_participant_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ParticipantId')
511: ,p_object_version_number => l_object_version_number
512: ,p_questionnaire_template_id => hr_transaction_swi.getNumberValue(l_CommitNode,'QuestionnaireTemplateId')
513: ,p_participation_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ParticipationStatus')
514: ,p_participation_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ParticipationType')
515: ,p_last_notified_date => hr_transaction_swi.getDateValue(l_CommitNode,'LastNotifiedDate')
516: ,p_date_completed => hr_transaction_swi.getDateValue(l_CommitNode,'DateCompleted')
509: ,p_effective_date => p_effective_date
510: ,p_participant_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ParticipantId')
511: ,p_object_version_number => l_object_version_number
512: ,p_questionnaire_template_id => hr_transaction_swi.getNumberValue(l_CommitNode,'QuestionnaireTemplateId')
513: ,p_participation_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ParticipationStatus')
514: ,p_participation_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ParticipationType')
515: ,p_last_notified_date => hr_transaction_swi.getDateValue(l_CommitNode,'LastNotifiedDate')
516: ,p_date_completed => hr_transaction_swi.getDateValue(l_CommitNode,'DateCompleted')
517: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
510: ,p_participant_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ParticipantId')
511: ,p_object_version_number => l_object_version_number
512: ,p_questionnaire_template_id => hr_transaction_swi.getNumberValue(l_CommitNode,'QuestionnaireTemplateId')
513: ,p_participation_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ParticipationStatus')
514: ,p_participation_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ParticipationType')
515: ,p_last_notified_date => hr_transaction_swi.getDateValue(l_CommitNode,'LastNotifiedDate')
516: ,p_date_completed => hr_transaction_swi.getDateValue(l_CommitNode,'DateCompleted')
517: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
518: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId')
511: ,p_object_version_number => l_object_version_number
512: ,p_questionnaire_template_id => hr_transaction_swi.getNumberValue(l_CommitNode,'QuestionnaireTemplateId')
513: ,p_participation_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ParticipationStatus')
514: ,p_participation_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ParticipationType')
515: ,p_last_notified_date => hr_transaction_swi.getDateValue(l_CommitNode,'LastNotifiedDate')
516: ,p_date_completed => hr_transaction_swi.getDateValue(l_CommitNode,'DateCompleted')
517: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
518: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId')
519: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
512: ,p_questionnaire_template_id => hr_transaction_swi.getNumberValue(l_CommitNode,'QuestionnaireTemplateId')
513: ,p_participation_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ParticipationStatus')
514: ,p_participation_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ParticipationType')
515: ,p_last_notified_date => hr_transaction_swi.getDateValue(l_CommitNode,'LastNotifiedDate')
516: ,p_date_completed => hr_transaction_swi.getDateValue(l_CommitNode,'DateCompleted')
517: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
518: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId')
519: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
520: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
513: ,p_participation_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ParticipationStatus')
514: ,p_participation_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ParticipationType')
515: ,p_last_notified_date => hr_transaction_swi.getDateValue(l_CommitNode,'LastNotifiedDate')
516: ,p_date_completed => hr_transaction_swi.getDateValue(l_CommitNode,'DateCompleted')
517: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
518: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId')
519: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
520: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
521: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
514: ,p_participation_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ParticipationType')
515: ,p_last_notified_date => hr_transaction_swi.getDateValue(l_CommitNode,'LastNotifiedDate')
516: ,p_date_completed => hr_transaction_swi.getDateValue(l_CommitNode,'DateCompleted')
517: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
518: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId')
519: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
520: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
521: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
522: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
515: ,p_last_notified_date => hr_transaction_swi.getDateValue(l_CommitNode,'LastNotifiedDate')
516: ,p_date_completed => hr_transaction_swi.getDateValue(l_CommitNode,'DateCompleted')
517: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
518: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId')
519: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
520: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
521: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
522: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
523: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
516: ,p_date_completed => hr_transaction_swi.getDateValue(l_CommitNode,'DateCompleted')
517: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
518: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId')
519: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
520: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
521: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
522: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
523: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
524: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
517: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
518: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId')
519: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
520: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
521: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
522: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
523: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
524: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
525: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
518: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId')
519: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
520: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
521: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
522: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
523: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
524: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
525: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
526: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
519: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
520: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
521: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
522: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
523: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
524: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
525: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
526: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
527: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
520: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
521: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
522: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
523: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
524: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
525: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
526: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
527: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
528: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
521: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
522: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
523: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
524: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
525: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
526: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
527: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
528: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
529: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
522: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
523: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
524: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
525: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
526: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
527: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
528: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
529: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
530: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
523: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
524: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
525: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
526: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
527: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
528: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
529: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
530: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
531: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
524: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
525: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
526: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
527: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
528: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
529: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
530: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
531: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
532: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
525: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
526: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
527: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
528: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
529: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
530: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
531: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
532: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
533: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
526: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
527: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
528: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
529: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
530: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
531: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
532: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
533: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
534: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
527: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
528: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
529: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
530: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
531: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
532: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
533: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
534: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
535: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
528: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
529: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
530: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
531: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
532: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
533: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
534: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
535: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
536: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
529: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
530: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
531: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
532: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
533: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
534: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
535: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
536: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
537: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
530: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
531: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
532: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
533: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
534: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
535: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
536: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
537: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
538: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
531: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
532: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
533: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
534: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
535: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
536: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
537: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
538: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
539: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
532: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
533: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
534: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
535: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
536: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
537: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
538: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
539: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
540: ,p_return_status => l_return_status
533: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
534: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
535: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
536: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
537: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
538: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
539: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
540: ,p_return_status => l_return_status
541: );
534: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
535: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
536: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
537: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
538: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
539: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
540: ,p_return_status => l_return_status
541: );
542:
535: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
536: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
537: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
538: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
539: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
540: ,p_return_status => l_return_status
541: );
542:
543: elsif l_postState = '3' then
543: elsif l_postState = '3' then
544:
545: delete_participant
546: ( p_validate => p_validate
547: ,p_participant_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ParticipantId')
548: ,p_object_version_number => l_object_version_number
549: ,p_return_status => l_return_status
550: );
551: