eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_PARTICIPANTS_SWI dependencies on HR_TRANSACTION_SWI

Line 461: l_object_version_number := hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectVersionNumber');

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

Line 468: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',null)

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)

Line 469: ,p_questionnaire_template_id => hr_transaction_swi.getNumberValue(l_CommitNode,'QuestionnaireTemplateId',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)

Line 470: ,p_participation_in_table => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ParticipationInTable',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)

Line 471: ,p_participation_in_column => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ParticipationInColumn',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)

Line 472: ,p_participation_in_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ParticipationInId',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)

Line 473: ,p_participation_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ParticipationStatus',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)

Line 474: ,p_participation_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ParticipationType',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)

Line 475: ,p_last_notified_date => hr_transaction_swi.getDateValue(l_CommitNode,'LastNotifiedDate',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)

Line 476: ,p_date_completed => hr_transaction_swi.getDateValue(l_CommitNode,'DateCompleted',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)

Line 477: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',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)

Line 478: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId',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)

Line 479: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',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)

Line 480: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',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)

Line 481: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',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)

Line 482: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',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)

Line 483: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',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)

Line 484: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',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)

Line 485: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',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)

Line 486: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',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)

Line 487: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',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)

Line 488: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',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)

Line 489: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',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)

Line 490: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',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)

Line 491: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',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)

Line 492: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',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)

Line 493: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',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)

Line 494: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',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)

Line 495: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',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)

Line 496: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',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)

Line 497: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',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

Line 498: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',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
502: ,p_return_status => l_return_status

Line 499: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',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
503: );

Line 500: ,p_participant_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ParticipantId',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: );
504:

Line 510: ,p_participant_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ParticipantId')

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')

Line 512: ,p_questionnaire_template_id => hr_transaction_swi.getNumberValue(l_CommitNode,'QuestionnaireTemplateId')

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')

Line 513: ,p_participation_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ParticipationStatus')

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')

Line 514: ,p_participation_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ParticipationType')

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')

Line 515: ,p_last_notified_date => hr_transaction_swi.getDateValue(l_CommitNode,'LastNotifiedDate')

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')

Line 516: ,p_date_completed => hr_transaction_swi.getDateValue(l_CommitNode,'DateCompleted')

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')

Line 517: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')

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')

Line 518: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId')

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')

Line 519: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')

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')

Line 520: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')

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')

Line 521: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')

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')

Line 522: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')

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')

Line 523: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')

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')

Line 524: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')

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')

Line 525: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')

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')

Line 526: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')

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')

Line 527: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')

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')

Line 528: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')

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')

Line 529: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')

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')

Line 530: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')

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')

Line 531: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')

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')

Line 532: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')

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')

Line 533: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')

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')

Line 534: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')

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')

Line 535: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')

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')

Line 536: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')

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

Line 537: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')

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: );

Line 538: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')

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:

Line 539: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')

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

Line 547: ,p_participant_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ParticipantId')

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: