513: l_postState := xmldom.getAttribute(l_commitElement, 'PS');
514: --
515: --Get the values for in/out parameters
516: --
517: l_object_version_number := hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectVersionNumber');
518: l_recruitment_activity_id := hr_transaction_swi.getNumberValue(l_CommitNode,'RecruitmentActivityId');
519: --
520: if p_effective_date is null then
521: l_effective_date := trunc(sysdate);
514: --
515: --Get the values for in/out parameters
516: --
517: l_object_version_number := hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectVersionNumber');
518: l_recruitment_activity_id := hr_transaction_swi.getNumberValue(l_CommitNode,'RecruitmentActivityId');
519: --
520: if p_effective_date is null then
521: l_effective_date := trunc(sysdate);
522: else
523: l_effective_date := p_effective_date;
524: end if;
525: --
526: l_posting_date := get_posting_date
527: ( p_type_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'RecruitingSiteType',NULL)
528: , p_current_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'DateStart',NULL)
529: , p_internal_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'InternalStartDate',NULL)
530: , p_dates_editable => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DatesEditable',NULL));
531: --
524: end if;
525: --
526: l_posting_date := get_posting_date
527: ( p_type_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'RecruitingSiteType',NULL)
528: , p_current_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'DateStart',NULL)
529: , p_internal_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'InternalStartDate',NULL)
530: , p_dates_editable => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DatesEditable',NULL));
531: --
532: if l_postState = '0' then
525: --
526: l_posting_date := get_posting_date
527: ( p_type_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'RecruitingSiteType',NULL)
528: , p_current_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'DateStart',NULL)
529: , p_internal_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'InternalStartDate',NULL)
530: , p_dates_editable => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DatesEditable',NULL));
531: --
532: if l_postState = '0' then
533: --
526: l_posting_date := get_posting_date
527: ( p_type_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'RecruitingSiteType',NULL)
528: , p_current_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'DateStart',NULL)
529: , p_internal_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'InternalStartDate',NULL)
530: , p_dates_editable => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DatesEditable',NULL));
531: --
532: if l_postState = '0' then
533: --
534: hr_utility.set_location('creating :' || l_proc,30);
534: hr_utility.set_location('creating :' || l_proc,30);
535: --
536: create_recruitment_activity
537: (p_validate => p_validate
538: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',NULL)
539: ,p_date_start => l_posting_date
540: ,p_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Name',NULL)
541: ,p_date_closing => hr_transaction_swi.getDateValue(l_CommitNode,'DateClosing',NULL)
542: ,p_date_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateEnd',NULL)
536: create_recruitment_activity
537: (p_validate => p_validate
538: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',NULL)
539: ,p_date_start => l_posting_date
540: ,p_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Name',NULL)
541: ,p_date_closing => hr_transaction_swi.getDateValue(l_CommitNode,'DateClosing',NULL)
542: ,p_date_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateEnd',NULL)
543: ,p_recruiting_site_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RecruitingSiteId',NULL)
544: ,p_last_posted_date => hr_transaction_swi.getDateValue(l_CommitNode,'LastPostedDate',NULL)
537: (p_validate => p_validate
538: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',NULL)
539: ,p_date_start => l_posting_date
540: ,p_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Name',NULL)
541: ,p_date_closing => hr_transaction_swi.getDateValue(l_CommitNode,'DateClosing',NULL)
542: ,p_date_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateEnd',NULL)
543: ,p_recruiting_site_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RecruitingSiteId',NULL)
544: ,p_last_posted_date => hr_transaction_swi.getDateValue(l_CommitNode,'LastPostedDate',NULL)
545: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',NULL)
538: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',NULL)
539: ,p_date_start => l_posting_date
540: ,p_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Name',NULL)
541: ,p_date_closing => hr_transaction_swi.getDateValue(l_CommitNode,'DateClosing',NULL)
542: ,p_date_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateEnd',NULL)
543: ,p_recruiting_site_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RecruitingSiteId',NULL)
544: ,p_last_posted_date => hr_transaction_swi.getDateValue(l_CommitNode,'LastPostedDate',NULL)
545: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',NULL)
546: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',NULL)
539: ,p_date_start => l_posting_date
540: ,p_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Name',NULL)
541: ,p_date_closing => hr_transaction_swi.getDateValue(l_CommitNode,'DateClosing',NULL)
542: ,p_date_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateEnd',NULL)
543: ,p_recruiting_site_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RecruitingSiteId',NULL)
544: ,p_last_posted_date => hr_transaction_swi.getDateValue(l_CommitNode,'LastPostedDate',NULL)
545: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',NULL)
546: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',NULL)
547: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',NULL)
540: ,p_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Name',NULL)
541: ,p_date_closing => hr_transaction_swi.getDateValue(l_CommitNode,'DateClosing',NULL)
542: ,p_date_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateEnd',NULL)
543: ,p_recruiting_site_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RecruitingSiteId',NULL)
544: ,p_last_posted_date => hr_transaction_swi.getDateValue(l_CommitNode,'LastPostedDate',NULL)
545: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',NULL)
546: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',NULL)
547: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',NULL)
548: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',NULL)
541: ,p_date_closing => hr_transaction_swi.getDateValue(l_CommitNode,'DateClosing',NULL)
542: ,p_date_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateEnd',NULL)
543: ,p_recruiting_site_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RecruitingSiteId',NULL)
544: ,p_last_posted_date => hr_transaction_swi.getDateValue(l_CommitNode,'LastPostedDate',NULL)
545: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',NULL)
546: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',NULL)
547: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',NULL)
548: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',NULL)
549: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',NULL)
542: ,p_date_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateEnd',NULL)
543: ,p_recruiting_site_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RecruitingSiteId',NULL)
544: ,p_last_posted_date => hr_transaction_swi.getDateValue(l_CommitNode,'LastPostedDate',NULL)
545: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',NULL)
546: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',NULL)
547: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',NULL)
548: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',NULL)
549: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',NULL)
550: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',NULL)
543: ,p_recruiting_site_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RecruitingSiteId',NULL)
544: ,p_last_posted_date => hr_transaction_swi.getDateValue(l_CommitNode,'LastPostedDate',NULL)
545: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',NULL)
546: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',NULL)
547: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',NULL)
548: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',NULL)
549: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',NULL)
550: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',NULL)
551: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',NULL)
544: ,p_last_posted_date => hr_transaction_swi.getDateValue(l_CommitNode,'LastPostedDate',NULL)
545: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',NULL)
546: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',NULL)
547: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',NULL)
548: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',NULL)
549: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',NULL)
550: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',NULL)
551: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',NULL)
552: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',NULL)
545: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',NULL)
546: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',NULL)
547: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',NULL)
548: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',NULL)
549: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',NULL)
550: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',NULL)
551: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',NULL)
552: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',NULL)
553: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',NULL)
546: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',NULL)
547: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',NULL)
548: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',NULL)
549: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',NULL)
550: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',NULL)
551: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',NULL)
552: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',NULL)
553: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',NULL)
554: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',NULL)
547: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',NULL)
548: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',NULL)
549: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',NULL)
550: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',NULL)
551: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',NULL)
552: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',NULL)
553: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',NULL)
554: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',NULL)
555: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',NULL)
548: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',NULL)
549: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',NULL)
550: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',NULL)
551: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',NULL)
552: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',NULL)
553: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',NULL)
554: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',NULL)
555: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',NULL)
556: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',NULL)
549: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',NULL)
550: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',NULL)
551: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',NULL)
552: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',NULL)
553: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',NULL)
554: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',NULL)
555: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',NULL)
556: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',NULL)
557: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',NULL)
550: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',NULL)
551: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',NULL)
552: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',NULL)
553: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',NULL)
554: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',NULL)
555: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',NULL)
556: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',NULL)
557: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',NULL)
558: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',NULL)
551: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',NULL)
552: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',NULL)
553: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',NULL)
554: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',NULL)
555: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',NULL)
556: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',NULL)
557: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',NULL)
558: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',NULL)
559: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',NULL)
552: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',NULL)
553: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',NULL)
554: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',NULL)
555: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',NULL)
556: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',NULL)
557: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',NULL)
558: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',NULL)
559: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',NULL)
560: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',NULL)
553: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',NULL)
554: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',NULL)
555: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',NULL)
556: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',NULL)
557: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',NULL)
558: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',NULL)
559: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',NULL)
560: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',NULL)
561: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',NULL)
554: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',NULL)
555: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',NULL)
556: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',NULL)
557: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',NULL)
558: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',NULL)
559: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',NULL)
560: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',NULL)
561: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',NULL)
562: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',NULL)
555: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',NULL)
556: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',NULL)
557: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',NULL)
558: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',NULL)
559: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',NULL)
560: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',NULL)
561: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',NULL)
562: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',NULL)
563: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',NULL)
556: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',NULL)
557: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',NULL)
558: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',NULL)
559: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',NULL)
560: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',NULL)
561: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',NULL)
562: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',NULL)
563: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',NULL)
564: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',NULL)
557: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',NULL)
558: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',NULL)
559: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',NULL)
560: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',NULL)
561: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',NULL)
562: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',NULL)
563: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',NULL)
564: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',NULL)
565: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',NULL)
558: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',NULL)
559: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',NULL)
560: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',NULL)
561: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',NULL)
562: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',NULL)
563: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',NULL)
564: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',NULL)
565: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',NULL)
566: ,p_posting_content_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PostingContentId',NULL)
559: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',NULL)
560: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',NULL)
561: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',NULL)
562: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',NULL)
563: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',NULL)
564: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',NULL)
565: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',NULL)
566: ,p_posting_content_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PostingContentId',NULL)
567: ,p_recruitment_activity_id => l_recruitment_activity_id
560: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',NULL)
561: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',NULL)
562: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',NULL)
563: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',NULL)
564: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',NULL)
565: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',NULL)
566: ,p_posting_content_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PostingContentId',NULL)
567: ,p_recruitment_activity_id => l_recruitment_activity_id
568: ,p_object_version_number => l_object_version_number
561: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',NULL)
562: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',NULL)
563: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',NULL)
564: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',NULL)
565: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',NULL)
566: ,p_posting_content_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PostingContentId',NULL)
567: ,p_recruitment_activity_id => l_recruitment_activity_id
568: ,p_object_version_number => l_object_version_number
569: ,p_return_status => l_return_status
562: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',NULL)
563: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',NULL)
564: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',NULL)
565: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',NULL)
566: ,p_posting_content_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PostingContentId',NULL)
567: ,p_recruitment_activity_id => l_recruitment_activity_id
568: ,p_object_version_number => l_object_version_number
569: ,p_return_status => l_return_status
570: );
575: --
576: update_recruitment_activity
577: (p_validate => p_validate
578: ,p_recruitment_activity_id => l_recruitment_activity_id
579: ,p_authorising_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AuthorisingPersonId',NULL)
580: ,p_run_by_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RunByOrganizationId',NULL)
581: ,p_internal_contact_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'InternalContactPersonId',NULL)
582: ,p_parent_recruitment_activity => hr_transaction_swi.getNumberValue(l_CommitNode,'ParentRecruitmentActivity',NULL)
583: ,p_currency_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CurrencyCode',NULL)
576: update_recruitment_activity
577: (p_validate => p_validate
578: ,p_recruitment_activity_id => l_recruitment_activity_id
579: ,p_authorising_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AuthorisingPersonId',NULL)
580: ,p_run_by_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RunByOrganizationId',NULL)
581: ,p_internal_contact_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'InternalContactPersonId',NULL)
582: ,p_parent_recruitment_activity => hr_transaction_swi.getNumberValue(l_CommitNode,'ParentRecruitmentActivity',NULL)
583: ,p_currency_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CurrencyCode',NULL)
584: ,p_date_start => l_posting_date
577: (p_validate => p_validate
578: ,p_recruitment_activity_id => l_recruitment_activity_id
579: ,p_authorising_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AuthorisingPersonId',NULL)
580: ,p_run_by_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RunByOrganizationId',NULL)
581: ,p_internal_contact_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'InternalContactPersonId',NULL)
582: ,p_parent_recruitment_activity => hr_transaction_swi.getNumberValue(l_CommitNode,'ParentRecruitmentActivity',NULL)
583: ,p_currency_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CurrencyCode',NULL)
584: ,p_date_start => l_posting_date
585: ,p_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Name',NULL)
578: ,p_recruitment_activity_id => l_recruitment_activity_id
579: ,p_authorising_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AuthorisingPersonId',NULL)
580: ,p_run_by_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RunByOrganizationId',NULL)
581: ,p_internal_contact_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'InternalContactPersonId',NULL)
582: ,p_parent_recruitment_activity => hr_transaction_swi.getNumberValue(l_CommitNode,'ParentRecruitmentActivity',NULL)
583: ,p_currency_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CurrencyCode',NULL)
584: ,p_date_start => l_posting_date
585: ,p_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Name',NULL)
586: ,p_actual_cost => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ActualCost',NULL)
579: ,p_authorising_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AuthorisingPersonId',NULL)
580: ,p_run_by_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RunByOrganizationId',NULL)
581: ,p_internal_contact_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'InternalContactPersonId',NULL)
582: ,p_parent_recruitment_activity => hr_transaction_swi.getNumberValue(l_CommitNode,'ParentRecruitmentActivity',NULL)
583: ,p_currency_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CurrencyCode',NULL)
584: ,p_date_start => l_posting_date
585: ,p_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Name',NULL)
586: ,p_actual_cost => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ActualCost',NULL)
587: ,p_contact_telephone_number => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ContactTelephoneNumber',NULL)
581: ,p_internal_contact_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'InternalContactPersonId',NULL)
582: ,p_parent_recruitment_activity => hr_transaction_swi.getNumberValue(l_CommitNode,'ParentRecruitmentActivity',NULL)
583: ,p_currency_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CurrencyCode',NULL)
584: ,p_date_start => l_posting_date
585: ,p_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Name',NULL)
586: ,p_actual_cost => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ActualCost',NULL)
587: ,p_contact_telephone_number => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ContactTelephoneNumber',NULL)
588: ,p_date_closing => hr_transaction_swi.getDateValue(l_CommitNode,'DateClosing',NULL)
589: ,p_date_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateEnd',NULL)
582: ,p_parent_recruitment_activity => hr_transaction_swi.getNumberValue(l_CommitNode,'ParentRecruitmentActivity',NULL)
583: ,p_currency_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CurrencyCode',NULL)
584: ,p_date_start => l_posting_date
585: ,p_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Name',NULL)
586: ,p_actual_cost => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ActualCost',NULL)
587: ,p_contact_telephone_number => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ContactTelephoneNumber',NULL)
588: ,p_date_closing => hr_transaction_swi.getDateValue(l_CommitNode,'DateClosing',NULL)
589: ,p_date_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateEnd',NULL)
590: ,p_external_contact => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ExternalContact',NULL)
583: ,p_currency_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CurrencyCode',NULL)
584: ,p_date_start => l_posting_date
585: ,p_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Name',NULL)
586: ,p_actual_cost => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ActualCost',NULL)
587: ,p_contact_telephone_number => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ContactTelephoneNumber',NULL)
588: ,p_date_closing => hr_transaction_swi.getDateValue(l_CommitNode,'DateClosing',NULL)
589: ,p_date_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateEnd',NULL)
590: ,p_external_contact => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ExternalContact',NULL)
591: ,p_planned_cost => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PlannedCost',NULL)
584: ,p_date_start => l_posting_date
585: ,p_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Name',NULL)
586: ,p_actual_cost => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ActualCost',NULL)
587: ,p_contact_telephone_number => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ContactTelephoneNumber',NULL)
588: ,p_date_closing => hr_transaction_swi.getDateValue(l_CommitNode,'DateClosing',NULL)
589: ,p_date_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateEnd',NULL)
590: ,p_external_contact => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ExternalContact',NULL)
591: ,p_planned_cost => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PlannedCost',NULL)
592: ,p_recruiting_site_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RecruitingSiteId',NULL)
585: ,p_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Name',NULL)
586: ,p_actual_cost => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ActualCost',NULL)
587: ,p_contact_telephone_number => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ContactTelephoneNumber',NULL)
588: ,p_date_closing => hr_transaction_swi.getDateValue(l_CommitNode,'DateClosing',NULL)
589: ,p_date_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateEnd',NULL)
590: ,p_external_contact => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ExternalContact',NULL)
591: ,p_planned_cost => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PlannedCost',NULL)
592: ,p_recruiting_site_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RecruitingSiteId',NULL)
593: ,p_recruiting_site_response => hr_transaction_swi.getVarchar2Value(l_CommitNode,'RecruitingSiteResponse',NULL)
586: ,p_actual_cost => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ActualCost',NULL)
587: ,p_contact_telephone_number => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ContactTelephoneNumber',NULL)
588: ,p_date_closing => hr_transaction_swi.getDateValue(l_CommitNode,'DateClosing',NULL)
589: ,p_date_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateEnd',NULL)
590: ,p_external_contact => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ExternalContact',NULL)
591: ,p_planned_cost => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PlannedCost',NULL)
592: ,p_recruiting_site_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RecruitingSiteId',NULL)
593: ,p_recruiting_site_response => hr_transaction_swi.getVarchar2Value(l_CommitNode,'RecruitingSiteResponse',NULL)
594: ,p_last_posted_date => hr_transaction_swi.getDateValue(l_CommitNode,'LastPostedDate',NULL)
587: ,p_contact_telephone_number => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ContactTelephoneNumber',NULL)
588: ,p_date_closing => hr_transaction_swi.getDateValue(l_CommitNode,'DateClosing',NULL)
589: ,p_date_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateEnd',NULL)
590: ,p_external_contact => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ExternalContact',NULL)
591: ,p_planned_cost => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PlannedCost',NULL)
592: ,p_recruiting_site_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RecruitingSiteId',NULL)
593: ,p_recruiting_site_response => hr_transaction_swi.getVarchar2Value(l_CommitNode,'RecruitingSiteResponse',NULL)
594: ,p_last_posted_date => hr_transaction_swi.getDateValue(l_CommitNode,'LastPostedDate',NULL)
595: ,p_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Type',NULL)
588: ,p_date_closing => hr_transaction_swi.getDateValue(l_CommitNode,'DateClosing',NULL)
589: ,p_date_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateEnd',NULL)
590: ,p_external_contact => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ExternalContact',NULL)
591: ,p_planned_cost => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PlannedCost',NULL)
592: ,p_recruiting_site_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RecruitingSiteId',NULL)
593: ,p_recruiting_site_response => hr_transaction_swi.getVarchar2Value(l_CommitNode,'RecruitingSiteResponse',NULL)
594: ,p_last_posted_date => hr_transaction_swi.getDateValue(l_CommitNode,'LastPostedDate',NULL)
595: ,p_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Type',NULL)
596: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',NULL)
589: ,p_date_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateEnd',NULL)
590: ,p_external_contact => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ExternalContact',NULL)
591: ,p_planned_cost => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PlannedCost',NULL)
592: ,p_recruiting_site_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RecruitingSiteId',NULL)
593: ,p_recruiting_site_response => hr_transaction_swi.getVarchar2Value(l_CommitNode,'RecruitingSiteResponse',NULL)
594: ,p_last_posted_date => hr_transaction_swi.getDateValue(l_CommitNode,'LastPostedDate',NULL)
595: ,p_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Type',NULL)
596: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',NULL)
597: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',NULL)
590: ,p_external_contact => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ExternalContact',NULL)
591: ,p_planned_cost => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PlannedCost',NULL)
592: ,p_recruiting_site_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RecruitingSiteId',NULL)
593: ,p_recruiting_site_response => hr_transaction_swi.getVarchar2Value(l_CommitNode,'RecruitingSiteResponse',NULL)
594: ,p_last_posted_date => hr_transaction_swi.getDateValue(l_CommitNode,'LastPostedDate',NULL)
595: ,p_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Type',NULL)
596: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',NULL)
597: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',NULL)
598: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',NULL)
591: ,p_planned_cost => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PlannedCost',NULL)
592: ,p_recruiting_site_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RecruitingSiteId',NULL)
593: ,p_recruiting_site_response => hr_transaction_swi.getVarchar2Value(l_CommitNode,'RecruitingSiteResponse',NULL)
594: ,p_last_posted_date => hr_transaction_swi.getDateValue(l_CommitNode,'LastPostedDate',NULL)
595: ,p_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Type',NULL)
596: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',NULL)
597: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',NULL)
598: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',NULL)
599: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',NULL)
592: ,p_recruiting_site_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RecruitingSiteId',NULL)
593: ,p_recruiting_site_response => hr_transaction_swi.getVarchar2Value(l_CommitNode,'RecruitingSiteResponse',NULL)
594: ,p_last_posted_date => hr_transaction_swi.getDateValue(l_CommitNode,'LastPostedDate',NULL)
595: ,p_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Type',NULL)
596: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',NULL)
597: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',NULL)
598: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',NULL)
599: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',NULL)
600: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',NULL)
593: ,p_recruiting_site_response => hr_transaction_swi.getVarchar2Value(l_CommitNode,'RecruitingSiteResponse',NULL)
594: ,p_last_posted_date => hr_transaction_swi.getDateValue(l_CommitNode,'LastPostedDate',NULL)
595: ,p_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Type',NULL)
596: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',NULL)
597: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',NULL)
598: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',NULL)
599: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',NULL)
600: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',NULL)
601: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',NULL)
594: ,p_last_posted_date => hr_transaction_swi.getDateValue(l_CommitNode,'LastPostedDate',NULL)
595: ,p_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Type',NULL)
596: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',NULL)
597: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',NULL)
598: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',NULL)
599: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',NULL)
600: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',NULL)
601: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',NULL)
602: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',NULL)
595: ,p_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Type',NULL)
596: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',NULL)
597: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',NULL)
598: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',NULL)
599: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',NULL)
600: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',NULL)
601: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',NULL)
602: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',NULL)
603: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',NULL)
596: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',NULL)
597: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',NULL)
598: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',NULL)
599: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',NULL)
600: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',NULL)
601: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',NULL)
602: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',NULL)
603: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',NULL)
604: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',NULL)
597: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',NULL)
598: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',NULL)
599: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',NULL)
600: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',NULL)
601: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',NULL)
602: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',NULL)
603: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',NULL)
604: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',NULL)
605: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',NULL)
598: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',NULL)
599: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',NULL)
600: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',NULL)
601: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',NULL)
602: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',NULL)
603: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',NULL)
604: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',NULL)
605: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',NULL)
606: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',NULL)
599: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',NULL)
600: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',NULL)
601: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',NULL)
602: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',NULL)
603: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',NULL)
604: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',NULL)
605: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',NULL)
606: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',NULL)
607: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',NULL)
600: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',NULL)
601: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',NULL)
602: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',NULL)
603: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',NULL)
604: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',NULL)
605: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',NULL)
606: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',NULL)
607: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',NULL)
608: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',NULL)
601: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',NULL)
602: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',NULL)
603: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',NULL)
604: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',NULL)
605: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',NULL)
606: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',NULL)
607: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',NULL)
608: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',NULL)
609: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',NULL)
602: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',NULL)
603: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',NULL)
604: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',NULL)
605: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',NULL)
606: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',NULL)
607: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',NULL)
608: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',NULL)
609: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',NULL)
610: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',NULL)
603: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',NULL)
604: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',NULL)
605: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',NULL)
606: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',NULL)
607: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',NULL)
608: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',NULL)
609: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',NULL)
610: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',NULL)
611: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',NULL)
604: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',NULL)
605: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',NULL)
606: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',NULL)
607: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',NULL)
608: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',NULL)
609: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',NULL)
610: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',NULL)
611: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',NULL)
612: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',NULL)
605: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',NULL)
606: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',NULL)
607: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',NULL)
608: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',NULL)
609: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',NULL)
610: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',NULL)
611: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',NULL)
612: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',NULL)
613: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',NULL)
606: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',NULL)
607: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',NULL)
608: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',NULL)
609: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',NULL)
610: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',NULL)
611: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',NULL)
612: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',NULL)
613: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',NULL)
614: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',NULL)
607: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',NULL)
608: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',NULL)
609: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',NULL)
610: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',NULL)
611: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',NULL)
612: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',NULL)
613: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',NULL)
614: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',NULL)
615: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',NULL)
608: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',NULL)
609: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',NULL)
610: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',NULL)
611: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',NULL)
612: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',NULL)
613: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',NULL)
614: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',NULL)
615: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',NULL)
616: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',NULL)
609: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',NULL)
610: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',NULL)
611: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',NULL)
612: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',NULL)
613: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',NULL)
614: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',NULL)
615: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',NULL)
616: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',NULL)
617: ,p_posting_content_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PostingContentId',NULL)
610: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',NULL)
611: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',NULL)
612: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',NULL)
613: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',NULL)
614: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',NULL)
615: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',NULL)
616: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',NULL)
617: ,p_posting_content_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PostingContentId',NULL)
618: ,p_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Status',NULL)
611: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',NULL)
612: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',NULL)
613: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',NULL)
614: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',NULL)
615: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',NULL)
616: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',NULL)
617: ,p_posting_content_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PostingContentId',NULL)
618: ,p_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Status',NULL)
619: ,p_object_version_number => l_object_version_number
612: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',NULL)
613: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',NULL)
614: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',NULL)
615: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',NULL)
616: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',NULL)
617: ,p_posting_content_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PostingContentId',NULL)
618: ,p_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Status',NULL)
619: ,p_object_version_number => l_object_version_number
620: ,p_return_status => l_return_status
613: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',NULL)
614: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',NULL)
615: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',NULL)
616: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',NULL)
617: ,p_posting_content_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PostingContentId',NULL)
618: ,p_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Status',NULL)
619: ,p_object_version_number => l_object_version_number
620: ,p_return_status => l_return_status
621: );
614: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',NULL)
615: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',NULL)
616: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',NULL)
617: ,p_posting_content_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PostingContentId',NULL)
618: ,p_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Status',NULL)
619: ,p_object_version_number => l_object_version_number
620: ,p_return_status => l_return_status
621: );
622: --