2517: l_postState := xmldom.getAttribute(l_commitElement, 'PS');
2518: --
2519: --Get the values for in/out parameters
2520: --
2521: l_offer_id := hr_transaction_swi.getNumberValue(l_CommitNode,'OfferId');
2522: --
2523: open current_offer_ovn(l_offer_id);
2524: fetch current_offer_ovn into l_object_version_number;
2525: close current_offer_ovn;
2523: open current_offer_ovn(l_offer_id);
2524: fetch current_offer_ovn into l_object_version_number;
2525: close current_offer_ovn;
2526: --
2527: l_offer_version := hr_transaction_swi.getNumberValue(l_CommitNode,'OfferVersion');
2528: l_offer_status := hr_transaction_swi.getVarchar2Value(l_CommitNode,'OfferStatus');
2529: --
2530: if p_effective_date is null
2531: then
2524: fetch current_offer_ovn into l_object_version_number;
2525: close current_offer_ovn;
2526: --
2527: l_offer_version := hr_transaction_swi.getNumberValue(l_CommitNode,'OfferVersion');
2528: l_offer_status := hr_transaction_swi.getVarchar2Value(l_CommitNode,'OfferStatus');
2529: --
2530: if p_effective_date is null
2531: then
2532: --
2543: --
2544: update_offer
2545: (p_validate => p_validate
2546: ,p_effective_date => l_effective_date
2547: ,p_offer_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'OfferStatus')
2548: ,p_discretionary_job_title => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DiscretionaryJobTitle')
2549: ,p_offer_extended_method => hr_transaction_swi.getVarchar2Value(l_CommitNode,'OfferExtendedMethod')
2550: ,p_respondent_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RespondentId')
2551: ,p_expiry_date => hr_transaction_swi.getDateValue(l_CommitNode,'ExpiryDate')
2544: update_offer
2545: (p_validate => p_validate
2546: ,p_effective_date => l_effective_date
2547: ,p_offer_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'OfferStatus')
2548: ,p_discretionary_job_title => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DiscretionaryJobTitle')
2549: ,p_offer_extended_method => hr_transaction_swi.getVarchar2Value(l_CommitNode,'OfferExtendedMethod')
2550: ,p_respondent_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RespondentId')
2551: ,p_expiry_date => hr_transaction_swi.getDateValue(l_CommitNode,'ExpiryDate')
2552: ,p_proposed_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'ProposedStartDate')
2545: (p_validate => p_validate
2546: ,p_effective_date => l_effective_date
2547: ,p_offer_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'OfferStatus')
2548: ,p_discretionary_job_title => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DiscretionaryJobTitle')
2549: ,p_offer_extended_method => hr_transaction_swi.getVarchar2Value(l_CommitNode,'OfferExtendedMethod')
2550: ,p_respondent_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RespondentId')
2551: ,p_expiry_date => hr_transaction_swi.getDateValue(l_CommitNode,'ExpiryDate')
2552: ,p_proposed_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'ProposedStartDate')
2553: ,p_offer_letter_tracking_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'OfferLetterTrackingCode')
2546: ,p_effective_date => l_effective_date
2547: ,p_offer_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'OfferStatus')
2548: ,p_discretionary_job_title => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DiscretionaryJobTitle')
2549: ,p_offer_extended_method => hr_transaction_swi.getVarchar2Value(l_CommitNode,'OfferExtendedMethod')
2550: ,p_respondent_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RespondentId')
2551: ,p_expiry_date => hr_transaction_swi.getDateValue(l_CommitNode,'ExpiryDate')
2552: ,p_proposed_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'ProposedStartDate')
2553: ,p_offer_letter_tracking_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'OfferLetterTrackingCode')
2554: ,p_offer_postal_service => hr_transaction_swi.getVarchar2Value(l_CommitNode,'OfferPostalService')
2547: ,p_offer_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'OfferStatus')
2548: ,p_discretionary_job_title => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DiscretionaryJobTitle')
2549: ,p_offer_extended_method => hr_transaction_swi.getVarchar2Value(l_CommitNode,'OfferExtendedMethod')
2550: ,p_respondent_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RespondentId')
2551: ,p_expiry_date => hr_transaction_swi.getDateValue(l_CommitNode,'ExpiryDate')
2552: ,p_proposed_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'ProposedStartDate')
2553: ,p_offer_letter_tracking_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'OfferLetterTrackingCode')
2554: ,p_offer_postal_service => hr_transaction_swi.getVarchar2Value(l_CommitNode,'OfferPostalService')
2555: ,p_offer_shipping_date => hr_transaction_swi.getDateValue(l_CommitNode,'OfferShippingDate')
2548: ,p_discretionary_job_title => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DiscretionaryJobTitle')
2549: ,p_offer_extended_method => hr_transaction_swi.getVarchar2Value(l_CommitNode,'OfferExtendedMethod')
2550: ,p_respondent_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RespondentId')
2551: ,p_expiry_date => hr_transaction_swi.getDateValue(l_CommitNode,'ExpiryDate')
2552: ,p_proposed_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'ProposedStartDate')
2553: ,p_offer_letter_tracking_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'OfferLetterTrackingCode')
2554: ,p_offer_postal_service => hr_transaction_swi.getVarchar2Value(l_CommitNode,'OfferPostalService')
2555: ,p_offer_shipping_date => hr_transaction_swi.getDateValue(l_CommitNode,'OfferShippingDate')
2556: ,p_applicant_assignment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ApplicantAssignmentId')
2549: ,p_offer_extended_method => hr_transaction_swi.getVarchar2Value(l_CommitNode,'OfferExtendedMethod')
2550: ,p_respondent_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RespondentId')
2551: ,p_expiry_date => hr_transaction_swi.getDateValue(l_CommitNode,'ExpiryDate')
2552: ,p_proposed_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'ProposedStartDate')
2553: ,p_offer_letter_tracking_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'OfferLetterTrackingCode')
2554: ,p_offer_postal_service => hr_transaction_swi.getVarchar2Value(l_CommitNode,'OfferPostalService')
2555: ,p_offer_shipping_date => hr_transaction_swi.getDateValue(l_CommitNode,'OfferShippingDate')
2556: ,p_applicant_assignment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ApplicantAssignmentId')
2557: ,p_offer_assignment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OfferAssignmentId')
2550: ,p_respondent_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RespondentId')
2551: ,p_expiry_date => hr_transaction_swi.getDateValue(l_CommitNode,'ExpiryDate')
2552: ,p_proposed_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'ProposedStartDate')
2553: ,p_offer_letter_tracking_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'OfferLetterTrackingCode')
2554: ,p_offer_postal_service => hr_transaction_swi.getVarchar2Value(l_CommitNode,'OfferPostalService')
2555: ,p_offer_shipping_date => hr_transaction_swi.getDateValue(l_CommitNode,'OfferShippingDate')
2556: ,p_applicant_assignment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ApplicantAssignmentId')
2557: ,p_offer_assignment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OfferAssignmentId')
2558: ,p_address_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AddressId')
2551: ,p_expiry_date => hr_transaction_swi.getDateValue(l_CommitNode,'ExpiryDate')
2552: ,p_proposed_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'ProposedStartDate')
2553: ,p_offer_letter_tracking_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'OfferLetterTrackingCode')
2554: ,p_offer_postal_service => hr_transaction_swi.getVarchar2Value(l_CommitNode,'OfferPostalService')
2555: ,p_offer_shipping_date => hr_transaction_swi.getDateValue(l_CommitNode,'OfferShippingDate')
2556: ,p_applicant_assignment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ApplicantAssignmentId')
2557: ,p_offer_assignment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OfferAssignmentId')
2558: ,p_address_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AddressId')
2559: ,p_template_id => hr_transaction_swi.getNumberValue(l_CommitNode,'TemplateId')
2552: ,p_proposed_start_date => hr_transaction_swi.getDateValue(l_CommitNode,'ProposedStartDate')
2553: ,p_offer_letter_tracking_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'OfferLetterTrackingCode')
2554: ,p_offer_postal_service => hr_transaction_swi.getVarchar2Value(l_CommitNode,'OfferPostalService')
2555: ,p_offer_shipping_date => hr_transaction_swi.getDateValue(l_CommitNode,'OfferShippingDate')
2556: ,p_applicant_assignment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ApplicantAssignmentId')
2557: ,p_offer_assignment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OfferAssignmentId')
2558: ,p_address_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AddressId')
2559: ,p_template_id => hr_transaction_swi.getNumberValue(l_CommitNode,'TemplateId')
2560: ,p_offer_letter_file_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'OfferLetterFileType')
2553: ,p_offer_letter_tracking_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'OfferLetterTrackingCode')
2554: ,p_offer_postal_service => hr_transaction_swi.getVarchar2Value(l_CommitNode,'OfferPostalService')
2555: ,p_offer_shipping_date => hr_transaction_swi.getDateValue(l_CommitNode,'OfferShippingDate')
2556: ,p_applicant_assignment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ApplicantAssignmentId')
2557: ,p_offer_assignment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OfferAssignmentId')
2558: ,p_address_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AddressId')
2559: ,p_template_id => hr_transaction_swi.getNumberValue(l_CommitNode,'TemplateId')
2560: ,p_offer_letter_file_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'OfferLetterFileType')
2561: ,p_offer_letter_file_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'OfferLetterFileName')
2554: ,p_offer_postal_service => hr_transaction_swi.getVarchar2Value(l_CommitNode,'OfferPostalService')
2555: ,p_offer_shipping_date => hr_transaction_swi.getDateValue(l_CommitNode,'OfferShippingDate')
2556: ,p_applicant_assignment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ApplicantAssignmentId')
2557: ,p_offer_assignment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OfferAssignmentId')
2558: ,p_address_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AddressId')
2559: ,p_template_id => hr_transaction_swi.getNumberValue(l_CommitNode,'TemplateId')
2560: ,p_offer_letter_file_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'OfferLetterFileType')
2561: ,p_offer_letter_file_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'OfferLetterFileName')
2562: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
2555: ,p_offer_shipping_date => hr_transaction_swi.getDateValue(l_CommitNode,'OfferShippingDate')
2556: ,p_applicant_assignment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ApplicantAssignmentId')
2557: ,p_offer_assignment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OfferAssignmentId')
2558: ,p_address_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AddressId')
2559: ,p_template_id => hr_transaction_swi.getNumberValue(l_CommitNode,'TemplateId')
2560: ,p_offer_letter_file_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'OfferLetterFileType')
2561: ,p_offer_letter_file_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'OfferLetterFileName')
2562: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
2563: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
2556: ,p_applicant_assignment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ApplicantAssignmentId')
2557: ,p_offer_assignment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OfferAssignmentId')
2558: ,p_address_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AddressId')
2559: ,p_template_id => hr_transaction_swi.getNumberValue(l_CommitNode,'TemplateId')
2560: ,p_offer_letter_file_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'OfferLetterFileType')
2561: ,p_offer_letter_file_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'OfferLetterFileName')
2562: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
2563: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
2564: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
2557: ,p_offer_assignment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OfferAssignmentId')
2558: ,p_address_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AddressId')
2559: ,p_template_id => hr_transaction_swi.getNumberValue(l_CommitNode,'TemplateId')
2560: ,p_offer_letter_file_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'OfferLetterFileType')
2561: ,p_offer_letter_file_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'OfferLetterFileName')
2562: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
2563: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
2564: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
2565: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
2558: ,p_address_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AddressId')
2559: ,p_template_id => hr_transaction_swi.getNumberValue(l_CommitNode,'TemplateId')
2560: ,p_offer_letter_file_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'OfferLetterFileType')
2561: ,p_offer_letter_file_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'OfferLetterFileName')
2562: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
2563: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
2564: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
2565: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
2566: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
2559: ,p_template_id => hr_transaction_swi.getNumberValue(l_CommitNode,'TemplateId')
2560: ,p_offer_letter_file_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'OfferLetterFileType')
2561: ,p_offer_letter_file_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'OfferLetterFileName')
2562: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
2563: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
2564: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
2565: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
2566: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
2567: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
2560: ,p_offer_letter_file_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'OfferLetterFileType')
2561: ,p_offer_letter_file_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'OfferLetterFileName')
2562: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
2563: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
2564: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
2565: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
2566: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
2567: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
2568: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
2561: ,p_offer_letter_file_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'OfferLetterFileName')
2562: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
2563: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
2564: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
2565: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
2566: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
2567: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
2568: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
2569: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
2562: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
2563: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
2564: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
2565: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
2566: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
2567: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
2568: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
2569: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
2570: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
2563: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
2564: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
2565: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
2566: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
2567: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
2568: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
2569: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
2570: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
2571: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
2564: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
2565: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
2566: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
2567: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
2568: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
2569: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
2570: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
2571: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
2572: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
2565: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
2566: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
2567: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
2568: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
2569: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
2570: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
2571: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
2572: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
2573: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
2566: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
2567: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
2568: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
2569: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
2570: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
2571: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
2572: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
2573: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
2574: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
2567: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
2568: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
2569: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
2570: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
2571: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
2572: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
2573: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
2574: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
2575: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
2568: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
2569: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
2570: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
2571: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
2572: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
2573: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
2574: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
2575: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
2576: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
2569: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
2570: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
2571: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
2572: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
2573: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
2574: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
2575: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
2576: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
2577: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
2570: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
2571: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
2572: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
2573: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
2574: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
2575: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
2576: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
2577: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
2578: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
2571: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
2572: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
2573: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
2574: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
2575: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
2576: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
2577: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
2578: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
2579: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
2572: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
2573: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
2574: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
2575: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
2576: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
2577: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
2578: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
2579: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
2580: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
2573: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
2574: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
2575: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
2576: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
2577: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
2578: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
2579: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
2580: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
2581: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
2574: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
2575: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
2576: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
2577: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
2578: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
2579: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
2580: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
2581: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
2582: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
2575: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
2576: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
2577: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
2578: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
2579: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
2580: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
2581: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
2582: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
2583: ,p_attribute21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute21')
2576: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
2577: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
2578: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
2579: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
2580: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
2581: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
2582: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
2583: ,p_attribute21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute21')
2584: ,p_attribute22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute22')
2577: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
2578: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
2579: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
2580: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
2581: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
2582: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
2583: ,p_attribute21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute21')
2584: ,p_attribute22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute22')
2585: ,p_attribute23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute23')
2578: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
2579: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
2580: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
2581: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
2582: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
2583: ,p_attribute21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute21')
2584: ,p_attribute22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute22')
2585: ,p_attribute23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute23')
2586: ,p_attribute24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute24')
2579: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
2580: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
2581: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
2582: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
2583: ,p_attribute21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute21')
2584: ,p_attribute22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute22')
2585: ,p_attribute23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute23')
2586: ,p_attribute24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute24')
2587: ,p_attribute25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute25')
2580: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
2581: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
2582: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
2583: ,p_attribute21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute21')
2584: ,p_attribute22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute22')
2585: ,p_attribute23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute23')
2586: ,p_attribute24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute24')
2587: ,p_attribute25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute25')
2588: ,p_attribute26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute26')
2581: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
2582: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
2583: ,p_attribute21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute21')
2584: ,p_attribute22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute22')
2585: ,p_attribute23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute23')
2586: ,p_attribute24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute24')
2587: ,p_attribute25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute25')
2588: ,p_attribute26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute26')
2589: ,p_attribute27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute27')
2582: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
2583: ,p_attribute21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute21')
2584: ,p_attribute22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute22')
2585: ,p_attribute23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute23')
2586: ,p_attribute24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute24')
2587: ,p_attribute25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute25')
2588: ,p_attribute26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute26')
2589: ,p_attribute27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute27')
2590: ,p_attribute28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute28')
2583: ,p_attribute21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute21')
2584: ,p_attribute22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute22')
2585: ,p_attribute23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute23')
2586: ,p_attribute24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute24')
2587: ,p_attribute25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute25')
2588: ,p_attribute26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute26')
2589: ,p_attribute27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute27')
2590: ,p_attribute28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute28')
2591: ,p_attribute29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute29')
2584: ,p_attribute22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute22')
2585: ,p_attribute23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute23')
2586: ,p_attribute24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute24')
2587: ,p_attribute25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute25')
2588: ,p_attribute26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute26')
2589: ,p_attribute27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute27')
2590: ,p_attribute28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute28')
2591: ,p_attribute29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute29')
2592: ,p_attribute30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute30')
2585: ,p_attribute23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute23')
2586: ,p_attribute24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute24')
2587: ,p_attribute25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute25')
2588: ,p_attribute26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute26')
2589: ,p_attribute27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute27')
2590: ,p_attribute28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute28')
2591: ,p_attribute29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute29')
2592: ,p_attribute30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute30')
2593: ,p_change_reason => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ChangeReason',null)
2586: ,p_attribute24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute24')
2587: ,p_attribute25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute25')
2588: ,p_attribute26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute26')
2589: ,p_attribute27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute27')
2590: ,p_attribute28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute28')
2591: ,p_attribute29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute29')
2592: ,p_attribute30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute30')
2593: ,p_change_reason => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ChangeReason',null)
2594: ,p_decline_reason => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DeclineReason',null)
2587: ,p_attribute25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute25')
2588: ,p_attribute26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute26')
2589: ,p_attribute27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute27')
2590: ,p_attribute28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute28')
2591: ,p_attribute29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute29')
2592: ,p_attribute30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute30')
2593: ,p_change_reason => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ChangeReason',null)
2594: ,p_decline_reason => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DeclineReason',null)
2595: ,p_note_text => hr_transaction_swi.getVarchar2Value(l_CommitNode,'NoteText',null)
2588: ,p_attribute26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute26')
2589: ,p_attribute27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute27')
2590: ,p_attribute28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute28')
2591: ,p_attribute29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute29')
2592: ,p_attribute30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute30')
2593: ,p_change_reason => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ChangeReason',null)
2594: ,p_decline_reason => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DeclineReason',null)
2595: ,p_note_text => hr_transaction_swi.getVarchar2Value(l_CommitNode,'NoteText',null)
2596: ,p_status_change_date => hr_transaction_swi.getDateValue(l_CommitNode,'StatusChangeDate',null)
2589: ,p_attribute27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute27')
2590: ,p_attribute28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute28')
2591: ,p_attribute29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute29')
2592: ,p_attribute30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute30')
2593: ,p_change_reason => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ChangeReason',null)
2594: ,p_decline_reason => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DeclineReason',null)
2595: ,p_note_text => hr_transaction_swi.getVarchar2Value(l_CommitNode,'NoteText',null)
2596: ,p_status_change_date => hr_transaction_swi.getDateValue(l_CommitNode,'StatusChangeDate',null)
2597: ,p_offer_id => l_offer_id
2590: ,p_attribute28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute28')
2591: ,p_attribute29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute29')
2592: ,p_attribute30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute30')
2593: ,p_change_reason => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ChangeReason',null)
2594: ,p_decline_reason => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DeclineReason',null)
2595: ,p_note_text => hr_transaction_swi.getVarchar2Value(l_CommitNode,'NoteText',null)
2596: ,p_status_change_date => hr_transaction_swi.getDateValue(l_CommitNode,'StatusChangeDate',null)
2597: ,p_offer_id => l_offer_id
2598: ,p_object_version_number => l_object_version_number
2591: ,p_attribute29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute29')
2592: ,p_attribute30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute30')
2593: ,p_change_reason => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ChangeReason',null)
2594: ,p_decline_reason => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DeclineReason',null)
2595: ,p_note_text => hr_transaction_swi.getVarchar2Value(l_CommitNode,'NoteText',null)
2596: ,p_status_change_date => hr_transaction_swi.getDateValue(l_CommitNode,'StatusChangeDate',null)
2597: ,p_offer_id => l_offer_id
2598: ,p_object_version_number => l_object_version_number
2599: ,p_offer_version => l_offer_version
2592: ,p_attribute30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute30')
2593: ,p_change_reason => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ChangeReason',null)
2594: ,p_decline_reason => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DeclineReason',null)
2595: ,p_note_text => hr_transaction_swi.getVarchar2Value(l_CommitNode,'NoteText',null)
2596: ,p_status_change_date => hr_transaction_swi.getDateValue(l_CommitNode,'StatusChangeDate',null)
2597: ,p_offer_id => l_offer_id
2598: ,p_object_version_number => l_object_version_number
2599: ,p_offer_version => l_offer_version
2600: ,p_return_status => l_return_status
2667: l_commitElement := xmldom.makeElement(l_CommitNode);
2668: l_postState := xmldom.getAttribute(l_commitElement, 'PS');
2669:
2670: --Get the values for in/out parameters
2671: l_assignment_id := hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentId');
2672: l_offer_id := hr_transaction_swi.getNumberValue(l_CommitNode,'OfferId');
2673: l_assignment_sequence := hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentSequence');
2674: l_assignment_number := hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentNumber', null);
2675: l_asg_object_version_number := hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectVersionNumber');
2668: l_postState := xmldom.getAttribute(l_commitElement, 'PS');
2669:
2670: --Get the values for in/out parameters
2671: l_assignment_id := hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentId');
2672: l_offer_id := hr_transaction_swi.getNumberValue(l_CommitNode,'OfferId');
2673: l_assignment_sequence := hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentSequence');
2674: l_assignment_number := hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentNumber', null);
2675: l_asg_object_version_number := hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectVersionNumber');
2676:
2669:
2670: --Get the values for in/out parameters
2671: l_assignment_id := hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentId');
2672: l_offer_id := hr_transaction_swi.getNumberValue(l_CommitNode,'OfferId');
2673: l_assignment_sequence := hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentSequence');
2674: l_assignment_number := hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentNumber', null);
2675: l_asg_object_version_number := hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectVersionNumber');
2676:
2677: if p_effective_date is null
2670: --Get the values for in/out parameters
2671: l_assignment_id := hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentId');
2672: l_offer_id := hr_transaction_swi.getNumberValue(l_CommitNode,'OfferId');
2673: l_assignment_sequence := hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentSequence');
2674: l_assignment_number := hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentNumber', null);
2675: l_asg_object_version_number := hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectVersionNumber');
2676:
2677: if p_effective_date is null
2678: then
2671: l_assignment_id := hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentId');
2672: l_offer_id := hr_transaction_swi.getNumberValue(l_CommitNode,'OfferId');
2673: l_assignment_sequence := hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentSequence');
2674: l_assignment_number := hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentNumber', null);
2675: l_asg_object_version_number := hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectVersionNumber');
2676:
2677: if p_effective_date is null
2678: then
2679: --
2693: (p_assignment_id => l_assignment_id
2694: ,p_effective_start_date => l_effective_start_date
2695: ,p_effective_end_date => l_effective_end_date
2696: ,p_business_group_id => l_business_group_id
2697: ,p_recruiter_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RecruiterId')
2698: ,p_grade_id => hr_transaction_swi.getNumberValue(l_CommitNode,'GradeId')
2699: ,p_position_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PositionId')
2700: ,p_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId')
2701: ,p_assignment_status_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentStatusTypeId')
2694: ,p_effective_start_date => l_effective_start_date
2695: ,p_effective_end_date => l_effective_end_date
2696: ,p_business_group_id => l_business_group_id
2697: ,p_recruiter_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RecruiterId')
2698: ,p_grade_id => hr_transaction_swi.getNumberValue(l_CommitNode,'GradeId')
2699: ,p_position_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PositionId')
2700: ,p_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId')
2701: ,p_assignment_status_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentStatusTypeId')
2702: ,p_payroll_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PayrollId')
2695: ,p_effective_end_date => l_effective_end_date
2696: ,p_business_group_id => l_business_group_id
2697: ,p_recruiter_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RecruiterId')
2698: ,p_grade_id => hr_transaction_swi.getNumberValue(l_CommitNode,'GradeId')
2699: ,p_position_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PositionId')
2700: ,p_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId')
2701: ,p_assignment_status_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentStatusTypeId')
2702: ,p_payroll_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PayrollId')
2703: ,p_location_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LocationId')
2696: ,p_business_group_id => l_business_group_id
2697: ,p_recruiter_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RecruiterId')
2698: ,p_grade_id => hr_transaction_swi.getNumberValue(l_CommitNode,'GradeId')
2699: ,p_position_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PositionId')
2700: ,p_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId')
2701: ,p_assignment_status_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentStatusTypeId')
2702: ,p_payroll_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PayrollId')
2703: ,p_location_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LocationId')
2704: ,p_person_referred_by_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonReferredById')
2697: ,p_recruiter_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RecruiterId')
2698: ,p_grade_id => hr_transaction_swi.getNumberValue(l_CommitNode,'GradeId')
2699: ,p_position_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PositionId')
2700: ,p_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId')
2701: ,p_assignment_status_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentStatusTypeId')
2702: ,p_payroll_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PayrollId')
2703: ,p_location_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LocationId')
2704: ,p_person_referred_by_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonReferredById')
2705: ,p_supervisor_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SupervisorId')
2698: ,p_grade_id => hr_transaction_swi.getNumberValue(l_CommitNode,'GradeId')
2699: ,p_position_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PositionId')
2700: ,p_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId')
2701: ,p_assignment_status_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentStatusTypeId')
2702: ,p_payroll_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PayrollId')
2703: ,p_location_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LocationId')
2704: ,p_person_referred_by_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonReferredById')
2705: ,p_supervisor_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SupervisorId')
2706: ,p_special_ceiling_step_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SpecialCeilingStepId')
2699: ,p_position_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PositionId')
2700: ,p_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId')
2701: ,p_assignment_status_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentStatusTypeId')
2702: ,p_payroll_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PayrollId')
2703: ,p_location_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LocationId')
2704: ,p_person_referred_by_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonReferredById')
2705: ,p_supervisor_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SupervisorId')
2706: ,p_special_ceiling_step_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SpecialCeilingStepId')
2707: ,p_recruitment_activity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RecruitmentActivityId')
2700: ,p_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId')
2701: ,p_assignment_status_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentStatusTypeId')
2702: ,p_payroll_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PayrollId')
2703: ,p_location_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LocationId')
2704: ,p_person_referred_by_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonReferredById')
2705: ,p_supervisor_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SupervisorId')
2706: ,p_special_ceiling_step_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SpecialCeilingStepId')
2707: ,p_recruitment_activity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RecruitmentActivityId')
2708: ,p_source_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SourceOrganizationId')
2701: ,p_assignment_status_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentStatusTypeId')
2702: ,p_payroll_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PayrollId')
2703: ,p_location_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LocationId')
2704: ,p_person_referred_by_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonReferredById')
2705: ,p_supervisor_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SupervisorId')
2706: ,p_special_ceiling_step_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SpecialCeilingStepId')
2707: ,p_recruitment_activity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RecruitmentActivityId')
2708: ,p_source_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SourceOrganizationId')
2709: ,p_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OrganizationId')
2702: ,p_payroll_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PayrollId')
2703: ,p_location_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LocationId')
2704: ,p_person_referred_by_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonReferredById')
2705: ,p_supervisor_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SupervisorId')
2706: ,p_special_ceiling_step_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SpecialCeilingStepId')
2707: ,p_recruitment_activity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RecruitmentActivityId')
2708: ,p_source_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SourceOrganizationId')
2709: ,p_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OrganizationId')
2710: ,p_people_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeopleGroupId')
2703: ,p_location_id => hr_transaction_swi.getNumberValue(l_CommitNode,'LocationId')
2704: ,p_person_referred_by_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonReferredById')
2705: ,p_supervisor_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SupervisorId')
2706: ,p_special_ceiling_step_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SpecialCeilingStepId')
2707: ,p_recruitment_activity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RecruitmentActivityId')
2708: ,p_source_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SourceOrganizationId')
2709: ,p_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OrganizationId')
2710: ,p_people_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeopleGroupId')
2711: ,p_soft_coding_keyflex_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SoftCodingKeyflexId')
2704: ,p_person_referred_by_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonReferredById')
2705: ,p_supervisor_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SupervisorId')
2706: ,p_special_ceiling_step_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SpecialCeilingStepId')
2707: ,p_recruitment_activity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RecruitmentActivityId')
2708: ,p_source_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SourceOrganizationId')
2709: ,p_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OrganizationId')
2710: ,p_people_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeopleGroupId')
2711: ,p_soft_coding_keyflex_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SoftCodingKeyflexId')
2712: ,p_vacancy_id => hr_transaction_swi.getNumberValue(l_CommitNode,'VacancyId')
2705: ,p_supervisor_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SupervisorId')
2706: ,p_special_ceiling_step_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SpecialCeilingStepId')
2707: ,p_recruitment_activity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RecruitmentActivityId')
2708: ,p_source_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SourceOrganizationId')
2709: ,p_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OrganizationId')
2710: ,p_people_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeopleGroupId')
2711: ,p_soft_coding_keyflex_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SoftCodingKeyflexId')
2712: ,p_vacancy_id => hr_transaction_swi.getNumberValue(l_CommitNode,'VacancyId')
2713: ,p_pay_basis_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PayBasisId')
2706: ,p_special_ceiling_step_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SpecialCeilingStepId')
2707: ,p_recruitment_activity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RecruitmentActivityId')
2708: ,p_source_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SourceOrganizationId')
2709: ,p_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OrganizationId')
2710: ,p_people_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeopleGroupId')
2711: ,p_soft_coding_keyflex_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SoftCodingKeyflexId')
2712: ,p_vacancy_id => hr_transaction_swi.getNumberValue(l_CommitNode,'VacancyId')
2713: ,p_pay_basis_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PayBasisId')
2714: ,p_assignment_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssignmentType')
2707: ,p_recruitment_activity_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RecruitmentActivityId')
2708: ,p_source_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SourceOrganizationId')
2709: ,p_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OrganizationId')
2710: ,p_people_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeopleGroupId')
2711: ,p_soft_coding_keyflex_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SoftCodingKeyflexId')
2712: ,p_vacancy_id => hr_transaction_swi.getNumberValue(l_CommitNode,'VacancyId')
2713: ,p_pay_basis_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PayBasisId')
2714: ,p_assignment_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssignmentType')
2715: ,p_primary_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PrimaryFlag')
2708: ,p_source_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SourceOrganizationId')
2709: ,p_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OrganizationId')
2710: ,p_people_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeopleGroupId')
2711: ,p_soft_coding_keyflex_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SoftCodingKeyflexId')
2712: ,p_vacancy_id => hr_transaction_swi.getNumberValue(l_CommitNode,'VacancyId')
2713: ,p_pay_basis_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PayBasisId')
2714: ,p_assignment_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssignmentType')
2715: ,p_primary_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PrimaryFlag')
2716: ,p_application_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ApplicationId')
2709: ,p_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OrganizationId')
2710: ,p_people_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeopleGroupId')
2711: ,p_soft_coding_keyflex_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SoftCodingKeyflexId')
2712: ,p_vacancy_id => hr_transaction_swi.getNumberValue(l_CommitNode,'VacancyId')
2713: ,p_pay_basis_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PayBasisId')
2714: ,p_assignment_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssignmentType')
2715: ,p_primary_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PrimaryFlag')
2716: ,p_application_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ApplicationId')
2717: ,p_assignment_number => l_assignment_number
2710: ,p_people_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeopleGroupId')
2711: ,p_soft_coding_keyflex_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SoftCodingKeyflexId')
2712: ,p_vacancy_id => hr_transaction_swi.getNumberValue(l_CommitNode,'VacancyId')
2713: ,p_pay_basis_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PayBasisId')
2714: ,p_assignment_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssignmentType')
2715: ,p_primary_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PrimaryFlag')
2716: ,p_application_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ApplicationId')
2717: ,p_assignment_number => l_assignment_number
2718: ,p_change_reason => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ChangeReason')
2711: ,p_soft_coding_keyflex_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SoftCodingKeyflexId')
2712: ,p_vacancy_id => hr_transaction_swi.getNumberValue(l_CommitNode,'VacancyId')
2713: ,p_pay_basis_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PayBasisId')
2714: ,p_assignment_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssignmentType')
2715: ,p_primary_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PrimaryFlag')
2716: ,p_application_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ApplicationId')
2717: ,p_assignment_number => l_assignment_number
2718: ,p_change_reason => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ChangeReason')
2719: ,p_comment_id => l_comment_id
2712: ,p_vacancy_id => hr_transaction_swi.getNumberValue(l_CommitNode,'VacancyId')
2713: ,p_pay_basis_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PayBasisId')
2714: ,p_assignment_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssignmentType')
2715: ,p_primary_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PrimaryFlag')
2716: ,p_application_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ApplicationId')
2717: ,p_assignment_number => l_assignment_number
2718: ,p_change_reason => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ChangeReason')
2719: ,p_comment_id => l_comment_id
2720: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
2714: ,p_assignment_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssignmentType')
2715: ,p_primary_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PrimaryFlag')
2716: ,p_application_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ApplicationId')
2717: ,p_assignment_number => l_assignment_number
2718: ,p_change_reason => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ChangeReason')
2719: ,p_comment_id => l_comment_id
2720: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
2721: ,p_date_probation_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateProbationEnd')
2722: ,p_default_code_comb_id => hr_transaction_swi.getNumberValue(l_CommitNode,'DefaultCodeCombId')
2716: ,p_application_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ApplicationId')
2717: ,p_assignment_number => l_assignment_number
2718: ,p_change_reason => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ChangeReason')
2719: ,p_comment_id => l_comment_id
2720: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
2721: ,p_date_probation_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateProbationEnd')
2722: ,p_default_code_comb_id => hr_transaction_swi.getNumberValue(l_CommitNode,'DefaultCodeCombId')
2723: ,p_employment_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EmploymentCategory')
2724: ,p_frequency => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Frequency')
2717: ,p_assignment_number => l_assignment_number
2718: ,p_change_reason => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ChangeReason')
2719: ,p_comment_id => l_comment_id
2720: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
2721: ,p_date_probation_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateProbationEnd')
2722: ,p_default_code_comb_id => hr_transaction_swi.getNumberValue(l_CommitNode,'DefaultCodeCombId')
2723: ,p_employment_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EmploymentCategory')
2724: ,p_frequency => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Frequency')
2725: ,p_internal_address_line => hr_transaction_swi.getVarchar2Value(l_CommitNode,'InternalAddressLine')
2718: ,p_change_reason => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ChangeReason')
2719: ,p_comment_id => l_comment_id
2720: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
2721: ,p_date_probation_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateProbationEnd')
2722: ,p_default_code_comb_id => hr_transaction_swi.getNumberValue(l_CommitNode,'DefaultCodeCombId')
2723: ,p_employment_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EmploymentCategory')
2724: ,p_frequency => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Frequency')
2725: ,p_internal_address_line => hr_transaction_swi.getVarchar2Value(l_CommitNode,'InternalAddressLine')
2726: ,p_manager_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ManagerFlag')
2719: ,p_comment_id => l_comment_id
2720: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
2721: ,p_date_probation_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateProbationEnd')
2722: ,p_default_code_comb_id => hr_transaction_swi.getNumberValue(l_CommitNode,'DefaultCodeCombId')
2723: ,p_employment_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EmploymentCategory')
2724: ,p_frequency => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Frequency')
2725: ,p_internal_address_line => hr_transaction_swi.getVarchar2Value(l_CommitNode,'InternalAddressLine')
2726: ,p_manager_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ManagerFlag')
2727: ,p_normal_hours => hr_transaction_swi.getNumberValue(l_CommitNode,'NormalHours')
2720: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
2721: ,p_date_probation_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateProbationEnd')
2722: ,p_default_code_comb_id => hr_transaction_swi.getNumberValue(l_CommitNode,'DefaultCodeCombId')
2723: ,p_employment_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EmploymentCategory')
2724: ,p_frequency => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Frequency')
2725: ,p_internal_address_line => hr_transaction_swi.getVarchar2Value(l_CommitNode,'InternalAddressLine')
2726: ,p_manager_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ManagerFlag')
2727: ,p_normal_hours => hr_transaction_swi.getNumberValue(l_CommitNode,'NormalHours')
2728: ,p_perf_review_period => hr_transaction_swi.getNumberValue(l_CommitNode,'PerfReviewPeriod')
2721: ,p_date_probation_end => hr_transaction_swi.getDateValue(l_CommitNode,'DateProbationEnd')
2722: ,p_default_code_comb_id => hr_transaction_swi.getNumberValue(l_CommitNode,'DefaultCodeCombId')
2723: ,p_employment_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EmploymentCategory')
2724: ,p_frequency => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Frequency')
2725: ,p_internal_address_line => hr_transaction_swi.getVarchar2Value(l_CommitNode,'InternalAddressLine')
2726: ,p_manager_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ManagerFlag')
2727: ,p_normal_hours => hr_transaction_swi.getNumberValue(l_CommitNode,'NormalHours')
2728: ,p_perf_review_period => hr_transaction_swi.getNumberValue(l_CommitNode,'PerfReviewPeriod')
2729: ,p_perf_review_period_frequency => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerfReviewPeriodFrequency')
2722: ,p_default_code_comb_id => hr_transaction_swi.getNumberValue(l_CommitNode,'DefaultCodeCombId')
2723: ,p_employment_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EmploymentCategory')
2724: ,p_frequency => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Frequency')
2725: ,p_internal_address_line => hr_transaction_swi.getVarchar2Value(l_CommitNode,'InternalAddressLine')
2726: ,p_manager_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ManagerFlag')
2727: ,p_normal_hours => hr_transaction_swi.getNumberValue(l_CommitNode,'NormalHours')
2728: ,p_perf_review_period => hr_transaction_swi.getNumberValue(l_CommitNode,'PerfReviewPeriod')
2729: ,p_perf_review_period_frequency => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerfReviewPeriodFrequency')
2730: ,p_period_of_service_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeriodOfServiceId')
2723: ,p_employment_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EmploymentCategory')
2724: ,p_frequency => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Frequency')
2725: ,p_internal_address_line => hr_transaction_swi.getVarchar2Value(l_CommitNode,'InternalAddressLine')
2726: ,p_manager_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ManagerFlag')
2727: ,p_normal_hours => hr_transaction_swi.getNumberValue(l_CommitNode,'NormalHours')
2728: ,p_perf_review_period => hr_transaction_swi.getNumberValue(l_CommitNode,'PerfReviewPeriod')
2729: ,p_perf_review_period_frequency => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerfReviewPeriodFrequency')
2730: ,p_period_of_service_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeriodOfServiceId')
2731: ,p_probation_period => hr_transaction_swi.getNumberValue(l_CommitNode,'ProbationPeriod')
2724: ,p_frequency => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Frequency')
2725: ,p_internal_address_line => hr_transaction_swi.getVarchar2Value(l_CommitNode,'InternalAddressLine')
2726: ,p_manager_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ManagerFlag')
2727: ,p_normal_hours => hr_transaction_swi.getNumberValue(l_CommitNode,'NormalHours')
2728: ,p_perf_review_period => hr_transaction_swi.getNumberValue(l_CommitNode,'PerfReviewPeriod')
2729: ,p_perf_review_period_frequency => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerfReviewPeriodFrequency')
2730: ,p_period_of_service_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeriodOfServiceId')
2731: ,p_probation_period => hr_transaction_swi.getNumberValue(l_CommitNode,'ProbationPeriod')
2732: ,p_probation_unit => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProbationUnit')
2725: ,p_internal_address_line => hr_transaction_swi.getVarchar2Value(l_CommitNode,'InternalAddressLine')
2726: ,p_manager_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ManagerFlag')
2727: ,p_normal_hours => hr_transaction_swi.getNumberValue(l_CommitNode,'NormalHours')
2728: ,p_perf_review_period => hr_transaction_swi.getNumberValue(l_CommitNode,'PerfReviewPeriod')
2729: ,p_perf_review_period_frequency => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerfReviewPeriodFrequency')
2730: ,p_period_of_service_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeriodOfServiceId')
2731: ,p_probation_period => hr_transaction_swi.getNumberValue(l_CommitNode,'ProbationPeriod')
2732: ,p_probation_unit => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProbationUnit')
2733: ,p_sal_review_period => hr_transaction_swi.getNumberValue(l_CommitNode,'SalReviewPeriod')
2726: ,p_manager_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ManagerFlag')
2727: ,p_normal_hours => hr_transaction_swi.getNumberValue(l_CommitNode,'NormalHours')
2728: ,p_perf_review_period => hr_transaction_swi.getNumberValue(l_CommitNode,'PerfReviewPeriod')
2729: ,p_perf_review_period_frequency => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerfReviewPeriodFrequency')
2730: ,p_period_of_service_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeriodOfServiceId')
2731: ,p_probation_period => hr_transaction_swi.getNumberValue(l_CommitNode,'ProbationPeriod')
2732: ,p_probation_unit => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProbationUnit')
2733: ,p_sal_review_period => hr_transaction_swi.getNumberValue(l_CommitNode,'SalReviewPeriod')
2734: ,p_sal_review_period_frequency => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SalReviewPeriodFrequency')
2727: ,p_normal_hours => hr_transaction_swi.getNumberValue(l_CommitNode,'NormalHours')
2728: ,p_perf_review_period => hr_transaction_swi.getNumberValue(l_CommitNode,'PerfReviewPeriod')
2729: ,p_perf_review_period_frequency => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerfReviewPeriodFrequency')
2730: ,p_period_of_service_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeriodOfServiceId')
2731: ,p_probation_period => hr_transaction_swi.getNumberValue(l_CommitNode,'ProbationPeriod')
2732: ,p_probation_unit => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProbationUnit')
2733: ,p_sal_review_period => hr_transaction_swi.getNumberValue(l_CommitNode,'SalReviewPeriod')
2734: ,p_sal_review_period_frequency => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SalReviewPeriodFrequency')
2735: ,p_set_of_books_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SetOfBooksId')
2728: ,p_perf_review_period => hr_transaction_swi.getNumberValue(l_CommitNode,'PerfReviewPeriod')
2729: ,p_perf_review_period_frequency => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerfReviewPeriodFrequency')
2730: ,p_period_of_service_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeriodOfServiceId')
2731: ,p_probation_period => hr_transaction_swi.getNumberValue(l_CommitNode,'ProbationPeriod')
2732: ,p_probation_unit => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProbationUnit')
2733: ,p_sal_review_period => hr_transaction_swi.getNumberValue(l_CommitNode,'SalReviewPeriod')
2734: ,p_sal_review_period_frequency => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SalReviewPeriodFrequency')
2735: ,p_set_of_books_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SetOfBooksId')
2736: ,p_source_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SourceType')
2729: ,p_perf_review_period_frequency => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerfReviewPeriodFrequency')
2730: ,p_period_of_service_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeriodOfServiceId')
2731: ,p_probation_period => hr_transaction_swi.getNumberValue(l_CommitNode,'ProbationPeriod')
2732: ,p_probation_unit => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProbationUnit')
2733: ,p_sal_review_period => hr_transaction_swi.getNumberValue(l_CommitNode,'SalReviewPeriod')
2734: ,p_sal_review_period_frequency => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SalReviewPeriodFrequency')
2735: ,p_set_of_books_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SetOfBooksId')
2736: ,p_source_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SourceType')
2737: ,p_time_normal_finish => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeNormalFinish')
2730: ,p_period_of_service_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PeriodOfServiceId')
2731: ,p_probation_period => hr_transaction_swi.getNumberValue(l_CommitNode,'ProbationPeriod')
2732: ,p_probation_unit => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProbationUnit')
2733: ,p_sal_review_period => hr_transaction_swi.getNumberValue(l_CommitNode,'SalReviewPeriod')
2734: ,p_sal_review_period_frequency => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SalReviewPeriodFrequency')
2735: ,p_set_of_books_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SetOfBooksId')
2736: ,p_source_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SourceType')
2737: ,p_time_normal_finish => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeNormalFinish')
2738: ,p_time_normal_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeNormalStart')
2731: ,p_probation_period => hr_transaction_swi.getNumberValue(l_CommitNode,'ProbationPeriod')
2732: ,p_probation_unit => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProbationUnit')
2733: ,p_sal_review_period => hr_transaction_swi.getNumberValue(l_CommitNode,'SalReviewPeriod')
2734: ,p_sal_review_period_frequency => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SalReviewPeriodFrequency')
2735: ,p_set_of_books_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SetOfBooksId')
2736: ,p_source_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SourceType')
2737: ,p_time_normal_finish => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeNormalFinish')
2738: ,p_time_normal_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeNormalStart')
2739: ,p_bargaining_unit_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'BargainingUnitCode')
2732: ,p_probation_unit => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProbationUnit')
2733: ,p_sal_review_period => hr_transaction_swi.getNumberValue(l_CommitNode,'SalReviewPeriod')
2734: ,p_sal_review_period_frequency => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SalReviewPeriodFrequency')
2735: ,p_set_of_books_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SetOfBooksId')
2736: ,p_source_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SourceType')
2737: ,p_time_normal_finish => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeNormalFinish')
2738: ,p_time_normal_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeNormalStart')
2739: ,p_bargaining_unit_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'BargainingUnitCode')
2740: ,p_labour_union_member_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'LabourUnionMemberFlag')
2733: ,p_sal_review_period => hr_transaction_swi.getNumberValue(l_CommitNode,'SalReviewPeriod')
2734: ,p_sal_review_period_frequency => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SalReviewPeriodFrequency')
2735: ,p_set_of_books_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SetOfBooksId')
2736: ,p_source_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SourceType')
2737: ,p_time_normal_finish => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeNormalFinish')
2738: ,p_time_normal_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeNormalStart')
2739: ,p_bargaining_unit_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'BargainingUnitCode')
2740: ,p_labour_union_member_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'LabourUnionMemberFlag')
2741: ,p_hourly_salaried_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'HourlySalariedCode')
2734: ,p_sal_review_period_frequency => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SalReviewPeriodFrequency')
2735: ,p_set_of_books_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SetOfBooksId')
2736: ,p_source_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SourceType')
2737: ,p_time_normal_finish => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeNormalFinish')
2738: ,p_time_normal_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeNormalStart')
2739: ,p_bargaining_unit_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'BargainingUnitCode')
2740: ,p_labour_union_member_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'LabourUnionMemberFlag')
2741: ,p_hourly_salaried_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'HourlySalariedCode')
2742: ,p_request_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RequestId')
2735: ,p_set_of_books_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SetOfBooksId')
2736: ,p_source_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SourceType')
2737: ,p_time_normal_finish => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeNormalFinish')
2738: ,p_time_normal_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeNormalStart')
2739: ,p_bargaining_unit_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'BargainingUnitCode')
2740: ,p_labour_union_member_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'LabourUnionMemberFlag')
2741: ,p_hourly_salaried_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'HourlySalariedCode')
2742: ,p_request_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RequestId')
2743: ,p_program_application_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ProgramApplicationId')
2736: ,p_source_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SourceType')
2737: ,p_time_normal_finish => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeNormalFinish')
2738: ,p_time_normal_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeNormalStart')
2739: ,p_bargaining_unit_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'BargainingUnitCode')
2740: ,p_labour_union_member_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'LabourUnionMemberFlag')
2741: ,p_hourly_salaried_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'HourlySalariedCode')
2742: ,p_request_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RequestId')
2743: ,p_program_application_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ProgramApplicationId')
2744: ,p_program_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ProgramId')
2737: ,p_time_normal_finish => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeNormalFinish')
2738: ,p_time_normal_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeNormalStart')
2739: ,p_bargaining_unit_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'BargainingUnitCode')
2740: ,p_labour_union_member_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'LabourUnionMemberFlag')
2741: ,p_hourly_salaried_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'HourlySalariedCode')
2742: ,p_request_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RequestId')
2743: ,p_program_application_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ProgramApplicationId')
2744: ,p_program_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ProgramId')
2745: ,p_program_update_date => hr_transaction_swi.getDateValue(l_CommitNode,'ProgramUpdateDate')
2738: ,p_time_normal_start => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TimeNormalStart')
2739: ,p_bargaining_unit_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'BargainingUnitCode')
2740: ,p_labour_union_member_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'LabourUnionMemberFlag')
2741: ,p_hourly_salaried_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'HourlySalariedCode')
2742: ,p_request_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RequestId')
2743: ,p_program_application_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ProgramApplicationId')
2744: ,p_program_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ProgramId')
2745: ,p_program_update_date => hr_transaction_swi.getDateValue(l_CommitNode,'ProgramUpdateDate')
2746: ,p_ass_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttributeCategory')
2739: ,p_bargaining_unit_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'BargainingUnitCode')
2740: ,p_labour_union_member_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'LabourUnionMemberFlag')
2741: ,p_hourly_salaried_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'HourlySalariedCode')
2742: ,p_request_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RequestId')
2743: ,p_program_application_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ProgramApplicationId')
2744: ,p_program_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ProgramId')
2745: ,p_program_update_date => hr_transaction_swi.getDateValue(l_CommitNode,'ProgramUpdateDate')
2746: ,p_ass_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttributeCategory')
2747: ,p_ass_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute1')
2740: ,p_labour_union_member_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'LabourUnionMemberFlag')
2741: ,p_hourly_salaried_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'HourlySalariedCode')
2742: ,p_request_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RequestId')
2743: ,p_program_application_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ProgramApplicationId')
2744: ,p_program_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ProgramId')
2745: ,p_program_update_date => hr_transaction_swi.getDateValue(l_CommitNode,'ProgramUpdateDate')
2746: ,p_ass_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttributeCategory')
2747: ,p_ass_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute1')
2748: ,p_ass_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute2')
2741: ,p_hourly_salaried_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'HourlySalariedCode')
2742: ,p_request_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RequestId')
2743: ,p_program_application_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ProgramApplicationId')
2744: ,p_program_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ProgramId')
2745: ,p_program_update_date => hr_transaction_swi.getDateValue(l_CommitNode,'ProgramUpdateDate')
2746: ,p_ass_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttributeCategory')
2747: ,p_ass_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute1')
2748: ,p_ass_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute2')
2749: ,p_ass_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute3')
2742: ,p_request_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RequestId')
2743: ,p_program_application_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ProgramApplicationId')
2744: ,p_program_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ProgramId')
2745: ,p_program_update_date => hr_transaction_swi.getDateValue(l_CommitNode,'ProgramUpdateDate')
2746: ,p_ass_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttributeCategory')
2747: ,p_ass_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute1')
2748: ,p_ass_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute2')
2749: ,p_ass_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute3')
2750: ,p_ass_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute4')
2743: ,p_program_application_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ProgramApplicationId')
2744: ,p_program_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ProgramId')
2745: ,p_program_update_date => hr_transaction_swi.getDateValue(l_CommitNode,'ProgramUpdateDate')
2746: ,p_ass_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttributeCategory')
2747: ,p_ass_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute1')
2748: ,p_ass_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute2')
2749: ,p_ass_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute3')
2750: ,p_ass_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute4')
2751: ,p_ass_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute5')
2744: ,p_program_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ProgramId')
2745: ,p_program_update_date => hr_transaction_swi.getDateValue(l_CommitNode,'ProgramUpdateDate')
2746: ,p_ass_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttributeCategory')
2747: ,p_ass_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute1')
2748: ,p_ass_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute2')
2749: ,p_ass_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute3')
2750: ,p_ass_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute4')
2751: ,p_ass_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute5')
2752: ,p_ass_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute6')
2745: ,p_program_update_date => hr_transaction_swi.getDateValue(l_CommitNode,'ProgramUpdateDate')
2746: ,p_ass_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttributeCategory')
2747: ,p_ass_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute1')
2748: ,p_ass_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute2')
2749: ,p_ass_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute3')
2750: ,p_ass_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute4')
2751: ,p_ass_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute5')
2752: ,p_ass_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute6')
2753: ,p_ass_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute7')
2746: ,p_ass_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttributeCategory')
2747: ,p_ass_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute1')
2748: ,p_ass_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute2')
2749: ,p_ass_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute3')
2750: ,p_ass_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute4')
2751: ,p_ass_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute5')
2752: ,p_ass_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute6')
2753: ,p_ass_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute7')
2754: ,p_ass_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute8')
2747: ,p_ass_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute1')
2748: ,p_ass_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute2')
2749: ,p_ass_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute3')
2750: ,p_ass_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute4')
2751: ,p_ass_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute5')
2752: ,p_ass_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute6')
2753: ,p_ass_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute7')
2754: ,p_ass_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute8')
2755: ,p_ass_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute9')
2748: ,p_ass_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute2')
2749: ,p_ass_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute3')
2750: ,p_ass_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute4')
2751: ,p_ass_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute5')
2752: ,p_ass_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute6')
2753: ,p_ass_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute7')
2754: ,p_ass_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute8')
2755: ,p_ass_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute9')
2756: ,p_ass_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute10')
2749: ,p_ass_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute3')
2750: ,p_ass_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute4')
2751: ,p_ass_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute5')
2752: ,p_ass_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute6')
2753: ,p_ass_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute7')
2754: ,p_ass_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute8')
2755: ,p_ass_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute9')
2756: ,p_ass_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute10')
2757: ,p_ass_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute11')
2750: ,p_ass_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute4')
2751: ,p_ass_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute5')
2752: ,p_ass_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute6')
2753: ,p_ass_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute7')
2754: ,p_ass_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute8')
2755: ,p_ass_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute9')
2756: ,p_ass_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute10')
2757: ,p_ass_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute11')
2758: ,p_ass_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute12')
2751: ,p_ass_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute5')
2752: ,p_ass_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute6')
2753: ,p_ass_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute7')
2754: ,p_ass_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute8')
2755: ,p_ass_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute9')
2756: ,p_ass_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute10')
2757: ,p_ass_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute11')
2758: ,p_ass_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute12')
2759: ,p_ass_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute13')
2752: ,p_ass_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute6')
2753: ,p_ass_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute7')
2754: ,p_ass_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute8')
2755: ,p_ass_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute9')
2756: ,p_ass_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute10')
2757: ,p_ass_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute11')
2758: ,p_ass_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute12')
2759: ,p_ass_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute13')
2760: ,p_ass_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute14')
2753: ,p_ass_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute7')
2754: ,p_ass_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute8')
2755: ,p_ass_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute9')
2756: ,p_ass_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute10')
2757: ,p_ass_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute11')
2758: ,p_ass_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute12')
2759: ,p_ass_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute13')
2760: ,p_ass_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute14')
2761: ,p_ass_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute15')
2754: ,p_ass_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute8')
2755: ,p_ass_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute9')
2756: ,p_ass_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute10')
2757: ,p_ass_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute11')
2758: ,p_ass_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute12')
2759: ,p_ass_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute13')
2760: ,p_ass_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute14')
2761: ,p_ass_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute15')
2762: ,p_ass_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute16')
2755: ,p_ass_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute9')
2756: ,p_ass_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute10')
2757: ,p_ass_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute11')
2758: ,p_ass_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute12')
2759: ,p_ass_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute13')
2760: ,p_ass_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute14')
2761: ,p_ass_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute15')
2762: ,p_ass_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute16')
2763: ,p_ass_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute17')
2756: ,p_ass_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute10')
2757: ,p_ass_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute11')
2758: ,p_ass_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute12')
2759: ,p_ass_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute13')
2760: ,p_ass_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute14')
2761: ,p_ass_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute15')
2762: ,p_ass_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute16')
2763: ,p_ass_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute17')
2764: ,p_ass_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute18')
2757: ,p_ass_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute11')
2758: ,p_ass_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute12')
2759: ,p_ass_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute13')
2760: ,p_ass_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute14')
2761: ,p_ass_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute15')
2762: ,p_ass_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute16')
2763: ,p_ass_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute17')
2764: ,p_ass_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute18')
2765: ,p_ass_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute19')
2758: ,p_ass_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute12')
2759: ,p_ass_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute13')
2760: ,p_ass_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute14')
2761: ,p_ass_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute15')
2762: ,p_ass_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute16')
2763: ,p_ass_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute17')
2764: ,p_ass_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute18')
2765: ,p_ass_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute19')
2766: ,p_ass_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute20')
2759: ,p_ass_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute13')
2760: ,p_ass_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute14')
2761: ,p_ass_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute15')
2762: ,p_ass_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute16')
2763: ,p_ass_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute17')
2764: ,p_ass_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute18')
2765: ,p_ass_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute19')
2766: ,p_ass_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute20')
2767: ,p_ass_attribute21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute21')
2760: ,p_ass_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute14')
2761: ,p_ass_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute15')
2762: ,p_ass_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute16')
2763: ,p_ass_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute17')
2764: ,p_ass_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute18')
2765: ,p_ass_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute19')
2766: ,p_ass_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute20')
2767: ,p_ass_attribute21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute21')
2768: ,p_ass_attribute22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute22')
2761: ,p_ass_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute15')
2762: ,p_ass_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute16')
2763: ,p_ass_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute17')
2764: ,p_ass_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute18')
2765: ,p_ass_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute19')
2766: ,p_ass_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute20')
2767: ,p_ass_attribute21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute21')
2768: ,p_ass_attribute22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute22')
2769: ,p_ass_attribute23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute23')
2762: ,p_ass_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute16')
2763: ,p_ass_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute17')
2764: ,p_ass_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute18')
2765: ,p_ass_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute19')
2766: ,p_ass_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute20')
2767: ,p_ass_attribute21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute21')
2768: ,p_ass_attribute22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute22')
2769: ,p_ass_attribute23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute23')
2770: ,p_ass_attribute24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute24')
2763: ,p_ass_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute17')
2764: ,p_ass_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute18')
2765: ,p_ass_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute19')
2766: ,p_ass_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute20')
2767: ,p_ass_attribute21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute21')
2768: ,p_ass_attribute22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute22')
2769: ,p_ass_attribute23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute23')
2770: ,p_ass_attribute24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute24')
2771: ,p_ass_attribute25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute25')
2764: ,p_ass_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute18')
2765: ,p_ass_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute19')
2766: ,p_ass_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute20')
2767: ,p_ass_attribute21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute21')
2768: ,p_ass_attribute22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute22')
2769: ,p_ass_attribute23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute23')
2770: ,p_ass_attribute24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute24')
2771: ,p_ass_attribute25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute25')
2772: ,p_ass_attribute26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute26')
2765: ,p_ass_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute19')
2766: ,p_ass_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute20')
2767: ,p_ass_attribute21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute21')
2768: ,p_ass_attribute22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute22')
2769: ,p_ass_attribute23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute23')
2770: ,p_ass_attribute24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute24')
2771: ,p_ass_attribute25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute25')
2772: ,p_ass_attribute26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute26')
2773: ,p_ass_attribute27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute27')
2766: ,p_ass_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute20')
2767: ,p_ass_attribute21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute21')
2768: ,p_ass_attribute22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute22')
2769: ,p_ass_attribute23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute23')
2770: ,p_ass_attribute24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute24')
2771: ,p_ass_attribute25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute25')
2772: ,p_ass_attribute26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute26')
2773: ,p_ass_attribute27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute27')
2774: ,p_ass_attribute28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute28')
2767: ,p_ass_attribute21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute21')
2768: ,p_ass_attribute22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute22')
2769: ,p_ass_attribute23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute23')
2770: ,p_ass_attribute24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute24')
2771: ,p_ass_attribute25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute25')
2772: ,p_ass_attribute26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute26')
2773: ,p_ass_attribute27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute27')
2774: ,p_ass_attribute28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute28')
2775: ,p_ass_attribute29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute29')
2768: ,p_ass_attribute22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute22')
2769: ,p_ass_attribute23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute23')
2770: ,p_ass_attribute24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute24')
2771: ,p_ass_attribute25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute25')
2772: ,p_ass_attribute26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute26')
2773: ,p_ass_attribute27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute27')
2774: ,p_ass_attribute28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute28')
2775: ,p_ass_attribute29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute29')
2776: ,p_ass_attribute30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute30')
2769: ,p_ass_attribute23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute23')
2770: ,p_ass_attribute24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute24')
2771: ,p_ass_attribute25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute25')
2772: ,p_ass_attribute26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute26')
2773: ,p_ass_attribute27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute27')
2774: ,p_ass_attribute28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute28')
2775: ,p_ass_attribute29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute29')
2776: ,p_ass_attribute30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute30')
2777: ,p_title => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Title')
2770: ,p_ass_attribute24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute24')
2771: ,p_ass_attribute25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute25')
2772: ,p_ass_attribute26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute26')
2773: ,p_ass_attribute27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute27')
2774: ,p_ass_attribute28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute28')
2775: ,p_ass_attribute29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute29')
2776: ,p_ass_attribute30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute30')
2777: ,p_title => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Title')
2778: ,p_contract_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ContractId')
2771: ,p_ass_attribute25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute25')
2772: ,p_ass_attribute26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute26')
2773: ,p_ass_attribute27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute27')
2774: ,p_ass_attribute28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute28')
2775: ,p_ass_attribute29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute29')
2776: ,p_ass_attribute30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute30')
2777: ,p_title => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Title')
2778: ,p_contract_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ContractId')
2779: ,p_establishment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'EstablishmentId')
2772: ,p_ass_attribute26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute26')
2773: ,p_ass_attribute27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute27')
2774: ,p_ass_attribute28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute28')
2775: ,p_ass_attribute29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute29')
2776: ,p_ass_attribute30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute30')
2777: ,p_title => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Title')
2778: ,p_contract_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ContractId')
2779: ,p_establishment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'EstablishmentId')
2780: ,p_collective_agreement_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CollectiveAgreementId')
2773: ,p_ass_attribute27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute27')
2774: ,p_ass_attribute28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute28')
2775: ,p_ass_attribute29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute29')
2776: ,p_ass_attribute30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute30')
2777: ,p_title => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Title')
2778: ,p_contract_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ContractId')
2779: ,p_establishment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'EstablishmentId')
2780: ,p_collective_agreement_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CollectiveAgreementId')
2781: ,p_cagr_grade_def_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CagrGradeDefId')
2774: ,p_ass_attribute28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute28')
2775: ,p_ass_attribute29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute29')
2776: ,p_ass_attribute30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute30')
2777: ,p_title => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Title')
2778: ,p_contract_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ContractId')
2779: ,p_establishment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'EstablishmentId')
2780: ,p_collective_agreement_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CollectiveAgreementId')
2781: ,p_cagr_grade_def_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CagrGradeDefId')
2782: ,p_cagr_id_flex_num => hr_transaction_swi.getNumberValue(l_CommitNode,'CagrIdFlexNum')
2775: ,p_ass_attribute29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute29')
2776: ,p_ass_attribute30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute30')
2777: ,p_title => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Title')
2778: ,p_contract_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ContractId')
2779: ,p_establishment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'EstablishmentId')
2780: ,p_collective_agreement_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CollectiveAgreementId')
2781: ,p_cagr_grade_def_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CagrGradeDefId')
2782: ,p_cagr_id_flex_num => hr_transaction_swi.getNumberValue(l_CommitNode,'CagrIdFlexNum')
2783: ,p_asg_object_version_number => l_asg_object_version_number
2776: ,p_ass_attribute30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssAttribute30')
2777: ,p_title => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Title')
2778: ,p_contract_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ContractId')
2779: ,p_establishment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'EstablishmentId')
2780: ,p_collective_agreement_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CollectiveAgreementId')
2781: ,p_cagr_grade_def_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CagrGradeDefId')
2782: ,p_cagr_id_flex_num => hr_transaction_swi.getNumberValue(l_CommitNode,'CagrIdFlexNum')
2783: ,p_asg_object_version_number => l_asg_object_version_number
2784: ,p_notice_period => hr_transaction_swi.getNumberValue(l_CommitNode,'NoticePeriod')
2777: ,p_title => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Title')
2778: ,p_contract_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ContractId')
2779: ,p_establishment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'EstablishmentId')
2780: ,p_collective_agreement_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CollectiveAgreementId')
2781: ,p_cagr_grade_def_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CagrGradeDefId')
2782: ,p_cagr_id_flex_num => hr_transaction_swi.getNumberValue(l_CommitNode,'CagrIdFlexNum')
2783: ,p_asg_object_version_number => l_asg_object_version_number
2784: ,p_notice_period => hr_transaction_swi.getNumberValue(l_CommitNode,'NoticePeriod')
2785: ,p_notice_period_uom => hr_transaction_swi.getVarchar2Value(l_CommitNode,'NoticePeriodUom')
2778: ,p_contract_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ContractId')
2779: ,p_establishment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'EstablishmentId')
2780: ,p_collective_agreement_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CollectiveAgreementId')
2781: ,p_cagr_grade_def_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CagrGradeDefId')
2782: ,p_cagr_id_flex_num => hr_transaction_swi.getNumberValue(l_CommitNode,'CagrIdFlexNum')
2783: ,p_asg_object_version_number => l_asg_object_version_number
2784: ,p_notice_period => hr_transaction_swi.getNumberValue(l_CommitNode,'NoticePeriod')
2785: ,p_notice_period_uom => hr_transaction_swi.getVarchar2Value(l_CommitNode,'NoticePeriodUom')
2786: ,p_employee_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EmployeeCategory')
2780: ,p_collective_agreement_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CollectiveAgreementId')
2781: ,p_cagr_grade_def_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CagrGradeDefId')
2782: ,p_cagr_id_flex_num => hr_transaction_swi.getNumberValue(l_CommitNode,'CagrIdFlexNum')
2783: ,p_asg_object_version_number => l_asg_object_version_number
2784: ,p_notice_period => hr_transaction_swi.getNumberValue(l_CommitNode,'NoticePeriod')
2785: ,p_notice_period_uom => hr_transaction_swi.getVarchar2Value(l_CommitNode,'NoticePeriodUom')
2786: ,p_employee_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EmployeeCategory')
2787: ,p_work_at_home => hr_transaction_swi.getVarchar2Value(l_CommitNode,'WorkAtHome')
2788: ,p_job_post_source_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'JobPostSourceName')
2781: ,p_cagr_grade_def_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CagrGradeDefId')
2782: ,p_cagr_id_flex_num => hr_transaction_swi.getNumberValue(l_CommitNode,'CagrIdFlexNum')
2783: ,p_asg_object_version_number => l_asg_object_version_number
2784: ,p_notice_period => hr_transaction_swi.getNumberValue(l_CommitNode,'NoticePeriod')
2785: ,p_notice_period_uom => hr_transaction_swi.getVarchar2Value(l_CommitNode,'NoticePeriodUom')
2786: ,p_employee_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EmployeeCategory')
2787: ,p_work_at_home => hr_transaction_swi.getVarchar2Value(l_CommitNode,'WorkAtHome')
2788: ,p_job_post_source_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'JobPostSourceName')
2789: ,p_posting_content_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PostingContentId')
2782: ,p_cagr_id_flex_num => hr_transaction_swi.getNumberValue(l_CommitNode,'CagrIdFlexNum')
2783: ,p_asg_object_version_number => l_asg_object_version_number
2784: ,p_notice_period => hr_transaction_swi.getNumberValue(l_CommitNode,'NoticePeriod')
2785: ,p_notice_period_uom => hr_transaction_swi.getVarchar2Value(l_CommitNode,'NoticePeriodUom')
2786: ,p_employee_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EmployeeCategory')
2787: ,p_work_at_home => hr_transaction_swi.getVarchar2Value(l_CommitNode,'WorkAtHome')
2788: ,p_job_post_source_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'JobPostSourceName')
2789: ,p_posting_content_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PostingContentId')
2790: ,p_placement_date_start => hr_transaction_swi.getDateValue(l_CommitNode,'PlacementDateStart')
2783: ,p_asg_object_version_number => l_asg_object_version_number
2784: ,p_notice_period => hr_transaction_swi.getNumberValue(l_CommitNode,'NoticePeriod')
2785: ,p_notice_period_uom => hr_transaction_swi.getVarchar2Value(l_CommitNode,'NoticePeriodUom')
2786: ,p_employee_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EmployeeCategory')
2787: ,p_work_at_home => hr_transaction_swi.getVarchar2Value(l_CommitNode,'WorkAtHome')
2788: ,p_job_post_source_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'JobPostSourceName')
2789: ,p_posting_content_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PostingContentId')
2790: ,p_placement_date_start => hr_transaction_swi.getDateValue(l_CommitNode,'PlacementDateStart')
2791: ,p_vendor_id => hr_transaction_swi.getNumberValue(l_CommitNode,'VendorId')
2784: ,p_notice_period => hr_transaction_swi.getNumberValue(l_CommitNode,'NoticePeriod')
2785: ,p_notice_period_uom => hr_transaction_swi.getVarchar2Value(l_CommitNode,'NoticePeriodUom')
2786: ,p_employee_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EmployeeCategory')
2787: ,p_work_at_home => hr_transaction_swi.getVarchar2Value(l_CommitNode,'WorkAtHome')
2788: ,p_job_post_source_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'JobPostSourceName')
2789: ,p_posting_content_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PostingContentId')
2790: ,p_placement_date_start => hr_transaction_swi.getDateValue(l_CommitNode,'PlacementDateStart')
2791: ,p_vendor_id => hr_transaction_swi.getNumberValue(l_CommitNode,'VendorId')
2792: ,p_vendor_employee_number => hr_transaction_swi.getVarchar2Value(l_CommitNode,'VendorEmployeeNumber')
2785: ,p_notice_period_uom => hr_transaction_swi.getVarchar2Value(l_CommitNode,'NoticePeriodUom')
2786: ,p_employee_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EmployeeCategory')
2787: ,p_work_at_home => hr_transaction_swi.getVarchar2Value(l_CommitNode,'WorkAtHome')
2788: ,p_job_post_source_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'JobPostSourceName')
2789: ,p_posting_content_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PostingContentId')
2790: ,p_placement_date_start => hr_transaction_swi.getDateValue(l_CommitNode,'PlacementDateStart')
2791: ,p_vendor_id => hr_transaction_swi.getNumberValue(l_CommitNode,'VendorId')
2792: ,p_vendor_employee_number => hr_transaction_swi.getVarchar2Value(l_CommitNode,'VendorEmployeeNumber')
2793: ,p_vendor_assignment_number => hr_transaction_swi.getVarchar2Value(l_CommitNode,'VendorAssignmentNumber')
2786: ,p_employee_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EmployeeCategory')
2787: ,p_work_at_home => hr_transaction_swi.getVarchar2Value(l_CommitNode,'WorkAtHome')
2788: ,p_job_post_source_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'JobPostSourceName')
2789: ,p_posting_content_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PostingContentId')
2790: ,p_placement_date_start => hr_transaction_swi.getDateValue(l_CommitNode,'PlacementDateStart')
2791: ,p_vendor_id => hr_transaction_swi.getNumberValue(l_CommitNode,'VendorId')
2792: ,p_vendor_employee_number => hr_transaction_swi.getVarchar2Value(l_CommitNode,'VendorEmployeeNumber')
2793: ,p_vendor_assignment_number => hr_transaction_swi.getVarchar2Value(l_CommitNode,'VendorAssignmentNumber')
2794: ,p_assignment_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssignmentCategory')
2787: ,p_work_at_home => hr_transaction_swi.getVarchar2Value(l_CommitNode,'WorkAtHome')
2788: ,p_job_post_source_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'JobPostSourceName')
2789: ,p_posting_content_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PostingContentId')
2790: ,p_placement_date_start => hr_transaction_swi.getDateValue(l_CommitNode,'PlacementDateStart')
2791: ,p_vendor_id => hr_transaction_swi.getNumberValue(l_CommitNode,'VendorId')
2792: ,p_vendor_employee_number => hr_transaction_swi.getVarchar2Value(l_CommitNode,'VendorEmployeeNumber')
2793: ,p_vendor_assignment_number => hr_transaction_swi.getVarchar2Value(l_CommitNode,'VendorAssignmentNumber')
2794: ,p_assignment_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssignmentCategory')
2795: ,p_project_title => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProjectTitle')
2788: ,p_job_post_source_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'JobPostSourceName')
2789: ,p_posting_content_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PostingContentId')
2790: ,p_placement_date_start => hr_transaction_swi.getDateValue(l_CommitNode,'PlacementDateStart')
2791: ,p_vendor_id => hr_transaction_swi.getNumberValue(l_CommitNode,'VendorId')
2792: ,p_vendor_employee_number => hr_transaction_swi.getVarchar2Value(l_CommitNode,'VendorEmployeeNumber')
2793: ,p_vendor_assignment_number => hr_transaction_swi.getVarchar2Value(l_CommitNode,'VendorAssignmentNumber')
2794: ,p_assignment_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssignmentCategory')
2795: ,p_project_title => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProjectTitle')
2796: ,p_applicant_rank => hr_transaction_swi.getNumberValue(l_CommitNode,'ApplicantRank')
2789: ,p_posting_content_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PostingContentId')
2790: ,p_placement_date_start => hr_transaction_swi.getDateValue(l_CommitNode,'PlacementDateStart')
2791: ,p_vendor_id => hr_transaction_swi.getNumberValue(l_CommitNode,'VendorId')
2792: ,p_vendor_employee_number => hr_transaction_swi.getVarchar2Value(l_CommitNode,'VendorEmployeeNumber')
2793: ,p_vendor_assignment_number => hr_transaction_swi.getVarchar2Value(l_CommitNode,'VendorAssignmentNumber')
2794: ,p_assignment_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssignmentCategory')
2795: ,p_project_title => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProjectTitle')
2796: ,p_applicant_rank => hr_transaction_swi.getNumberValue(l_CommitNode,'ApplicantRank')
2797: ,p_grade_ladder_pgm_id => hr_transaction_swi.getNumberValue(l_CommitNode,'GradeLadderPgmId')
2790: ,p_placement_date_start => hr_transaction_swi.getDateValue(l_CommitNode,'PlacementDateStart')
2791: ,p_vendor_id => hr_transaction_swi.getNumberValue(l_CommitNode,'VendorId')
2792: ,p_vendor_employee_number => hr_transaction_swi.getVarchar2Value(l_CommitNode,'VendorEmployeeNumber')
2793: ,p_vendor_assignment_number => hr_transaction_swi.getVarchar2Value(l_CommitNode,'VendorAssignmentNumber')
2794: ,p_assignment_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssignmentCategory')
2795: ,p_project_title => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProjectTitle')
2796: ,p_applicant_rank => hr_transaction_swi.getNumberValue(l_CommitNode,'ApplicantRank')
2797: ,p_grade_ladder_pgm_id => hr_transaction_swi.getNumberValue(l_CommitNode,'GradeLadderPgmId')
2798: ,p_supervisor_assignment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SupervisorAssignmentId')
2791: ,p_vendor_id => hr_transaction_swi.getNumberValue(l_CommitNode,'VendorId')
2792: ,p_vendor_employee_number => hr_transaction_swi.getVarchar2Value(l_CommitNode,'VendorEmployeeNumber')
2793: ,p_vendor_assignment_number => hr_transaction_swi.getVarchar2Value(l_CommitNode,'VendorAssignmentNumber')
2794: ,p_assignment_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssignmentCategory')
2795: ,p_project_title => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProjectTitle')
2796: ,p_applicant_rank => hr_transaction_swi.getNumberValue(l_CommitNode,'ApplicantRank')
2797: ,p_grade_ladder_pgm_id => hr_transaction_swi.getNumberValue(l_CommitNode,'GradeLadderPgmId')
2798: ,p_supervisor_assignment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SupervisorAssignmentId')
2799: ,p_vendor_site_id => hr_transaction_swi.getNumberValue(l_CommitNode,'VendorSiteId')
2792: ,p_vendor_employee_number => hr_transaction_swi.getVarchar2Value(l_CommitNode,'VendorEmployeeNumber')
2793: ,p_vendor_assignment_number => hr_transaction_swi.getVarchar2Value(l_CommitNode,'VendorAssignmentNumber')
2794: ,p_assignment_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssignmentCategory')
2795: ,p_project_title => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProjectTitle')
2796: ,p_applicant_rank => hr_transaction_swi.getNumberValue(l_CommitNode,'ApplicantRank')
2797: ,p_grade_ladder_pgm_id => hr_transaction_swi.getNumberValue(l_CommitNode,'GradeLadderPgmId')
2798: ,p_supervisor_assignment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SupervisorAssignmentId')
2799: ,p_vendor_site_id => hr_transaction_swi.getNumberValue(l_CommitNode,'VendorSiteId')
2800: ,p_po_header_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PoHeaderId')
2793: ,p_vendor_assignment_number => hr_transaction_swi.getVarchar2Value(l_CommitNode,'VendorAssignmentNumber')
2794: ,p_assignment_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssignmentCategory')
2795: ,p_project_title => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProjectTitle')
2796: ,p_applicant_rank => hr_transaction_swi.getNumberValue(l_CommitNode,'ApplicantRank')
2797: ,p_grade_ladder_pgm_id => hr_transaction_swi.getNumberValue(l_CommitNode,'GradeLadderPgmId')
2798: ,p_supervisor_assignment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SupervisorAssignmentId')
2799: ,p_vendor_site_id => hr_transaction_swi.getNumberValue(l_CommitNode,'VendorSiteId')
2800: ,p_po_header_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PoHeaderId')
2801: ,p_po_line_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PoLineId')
2794: ,p_assignment_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AssignmentCategory')
2795: ,p_project_title => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProjectTitle')
2796: ,p_applicant_rank => hr_transaction_swi.getNumberValue(l_CommitNode,'ApplicantRank')
2797: ,p_grade_ladder_pgm_id => hr_transaction_swi.getNumberValue(l_CommitNode,'GradeLadderPgmId')
2798: ,p_supervisor_assignment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SupervisorAssignmentId')
2799: ,p_vendor_site_id => hr_transaction_swi.getNumberValue(l_CommitNode,'VendorSiteId')
2800: ,p_po_header_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PoHeaderId')
2801: ,p_po_line_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PoLineId')
2802: ,p_projected_assignment_end => hr_transaction_swi.getDateValue(l_CommitNode,'ProjectedAssignmentEnd')
2795: ,p_project_title => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProjectTitle')
2796: ,p_applicant_rank => hr_transaction_swi.getNumberValue(l_CommitNode,'ApplicantRank')
2797: ,p_grade_ladder_pgm_id => hr_transaction_swi.getNumberValue(l_CommitNode,'GradeLadderPgmId')
2798: ,p_supervisor_assignment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SupervisorAssignmentId')
2799: ,p_vendor_site_id => hr_transaction_swi.getNumberValue(l_CommitNode,'VendorSiteId')
2800: ,p_po_header_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PoHeaderId')
2801: ,p_po_line_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PoLineId')
2802: ,p_projected_assignment_end => hr_transaction_swi.getDateValue(l_CommitNode,'ProjectedAssignmentEnd')
2803: ,p_payroll_id_updated => l_payroll_id_updated
2796: ,p_applicant_rank => hr_transaction_swi.getNumberValue(l_CommitNode,'ApplicantRank')
2797: ,p_grade_ladder_pgm_id => hr_transaction_swi.getNumberValue(l_CommitNode,'GradeLadderPgmId')
2798: ,p_supervisor_assignment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SupervisorAssignmentId')
2799: ,p_vendor_site_id => hr_transaction_swi.getNumberValue(l_CommitNode,'VendorSiteId')
2800: ,p_po_header_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PoHeaderId')
2801: ,p_po_line_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PoLineId')
2802: ,p_projected_assignment_end => hr_transaction_swi.getDateValue(l_CommitNode,'ProjectedAssignmentEnd')
2803: ,p_payroll_id_updated => l_payroll_id_updated
2804: ,p_validation_start_date => l_validation_start_date
2797: ,p_grade_ladder_pgm_id => hr_transaction_swi.getNumberValue(l_CommitNode,'GradeLadderPgmId')
2798: ,p_supervisor_assignment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SupervisorAssignmentId')
2799: ,p_vendor_site_id => hr_transaction_swi.getNumberValue(l_CommitNode,'VendorSiteId')
2800: ,p_po_header_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PoHeaderId')
2801: ,p_po_line_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PoLineId')
2802: ,p_projected_assignment_end => hr_transaction_swi.getDateValue(l_CommitNode,'ProjectedAssignmentEnd')
2803: ,p_payroll_id_updated => l_payroll_id_updated
2804: ,p_validation_start_date => l_validation_start_date
2805: ,p_validation_end_date => l_validation_end_date
2798: ,p_supervisor_assignment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SupervisorAssignmentId')
2799: ,p_vendor_site_id => hr_transaction_swi.getNumberValue(l_CommitNode,'VendorSiteId')
2800: ,p_po_header_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PoHeaderId')
2801: ,p_po_line_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PoLineId')
2802: ,p_projected_assignment_end => hr_transaction_swi.getDateValue(l_CommitNode,'ProjectedAssignmentEnd')
2803: ,p_payroll_id_updated => l_payroll_id_updated
2804: ,p_validation_start_date => l_validation_start_date
2805: ,p_validation_end_date => l_validation_end_date
2806: ,p_effective_date => l_effective_date
2803: ,p_payroll_id_updated => l_payroll_id_updated
2804: ,p_validation_start_date => l_validation_start_date
2805: ,p_validation_end_date => l_validation_end_date
2806: ,p_effective_date => l_effective_date
2807: ,p_datetrack_mode => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DatetrackMode')
2808: ,p_validate => p_validate
2809: ,p_offer_id => l_offer_id
2810: ,p_offer_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'OfferStatus',null)
2811: ,p_return_status => l_return_status
2806: ,p_effective_date => l_effective_date
2807: ,p_datetrack_mode => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DatetrackMode')
2808: ,p_validate => p_validate
2809: ,p_offer_id => l_offer_id
2810: ,p_offer_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'OfferStatus',null)
2811: ,p_return_status => l_return_status
2812: );
2813: --
2814:
2817: --
2818: delete_offer_assignment
2819: (p_validate => p_validate
2820: ,p_effective_date => l_effective_date
2821: ,p_offer_assignment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OfferAssignmentId',null)
2822: ,p_return_status => l_return_status
2823: );
2824: --
2825: end if;