1200: l_commitElement := xmldom.makeElement(l_CommitNode);
1201: l_postState := xmldom.getAttribute(l_commitElement, 'PS');
1202:
1203: --Get in/out parameters
1204: l_pay_proposal_id := hr_transaction_swi.getNumberValue(l_CommitNode,'PayProposalId');
1205: l_element_entry_id := null;--hr_transaction_swi.getNumberValue(l_CommitNode,'ElementEntryId');
1206: l_object_version_number := hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectVersionNumber');
1207:
1208: if l_postState = '2' then
1201: l_postState := xmldom.getAttribute(l_commitElement, 'PS');
1202:
1203: --Get in/out parameters
1204: l_pay_proposal_id := hr_transaction_swi.getNumberValue(l_CommitNode,'PayProposalId');
1205: l_element_entry_id := null;--hr_transaction_swi.getNumberValue(l_CommitNode,'ElementEntryId');
1206: l_object_version_number := hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectVersionNumber');
1207:
1208: if l_postState = '2' then
1209: --
1202:
1203: --Get in/out parameters
1204: l_pay_proposal_id := hr_transaction_swi.getNumberValue(l_CommitNode,'PayProposalId');
1205: l_element_entry_id := null;--hr_transaction_swi.getNumberValue(l_CommitNode,'ElementEntryId');
1206: l_object_version_number := hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectVersionNumber');
1207:
1208: if l_postState = '2' then
1209: --
1210: hr_maintain_proposal_swi.update_salary_proposal
1208: if l_postState = '2' then
1209: --
1210: hr_maintain_proposal_swi.update_salary_proposal
1211: (p_pay_proposal_id => l_pay_proposal_id
1212: ,p_change_date => hr_transaction_swi.getDateValue(l_CommitNode,'ChangeDate')
1213: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
1214: ,p_next_sal_review_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextSalReviewDate')
1215: ,p_proposal_reason => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProposalReason')
1216: ,p_proposed_salary_n => hr_transaction_swi.getNumberValue(l_CommitNode,'ProposedSalaryN')
1209: --
1210: hr_maintain_proposal_swi.update_salary_proposal
1211: (p_pay_proposal_id => l_pay_proposal_id
1212: ,p_change_date => hr_transaction_swi.getDateValue(l_CommitNode,'ChangeDate')
1213: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
1214: ,p_next_sal_review_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextSalReviewDate')
1215: ,p_proposal_reason => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProposalReason')
1216: ,p_proposed_salary_n => hr_transaction_swi.getNumberValue(l_CommitNode,'ProposedSalaryN')
1217: ,p_forced_ranking => hr_transaction_swi.getNumberValue(l_CommitNode,'ForcedRanking')
1210: hr_maintain_proposal_swi.update_salary_proposal
1211: (p_pay_proposal_id => l_pay_proposal_id
1212: ,p_change_date => hr_transaction_swi.getDateValue(l_CommitNode,'ChangeDate')
1213: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
1214: ,p_next_sal_review_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextSalReviewDate')
1215: ,p_proposal_reason => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProposalReason')
1216: ,p_proposed_salary_n => hr_transaction_swi.getNumberValue(l_CommitNode,'ProposedSalaryN')
1217: ,p_forced_ranking => hr_transaction_swi.getNumberValue(l_CommitNode,'ForcedRanking')
1218: ,p_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'DateTo')
1211: (p_pay_proposal_id => l_pay_proposal_id
1212: ,p_change_date => hr_transaction_swi.getDateValue(l_CommitNode,'ChangeDate')
1213: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
1214: ,p_next_sal_review_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextSalReviewDate')
1215: ,p_proposal_reason => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProposalReason')
1216: ,p_proposed_salary_n => hr_transaction_swi.getNumberValue(l_CommitNode,'ProposedSalaryN')
1217: ,p_forced_ranking => hr_transaction_swi.getNumberValue(l_CommitNode,'ForcedRanking')
1218: ,p_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'DateTo')
1219: ,p_performance_review_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PerformanceReviewId')
1212: ,p_change_date => hr_transaction_swi.getDateValue(l_CommitNode,'ChangeDate')
1213: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
1214: ,p_next_sal_review_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextSalReviewDate')
1215: ,p_proposal_reason => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProposalReason')
1216: ,p_proposed_salary_n => hr_transaction_swi.getNumberValue(l_CommitNode,'ProposedSalaryN')
1217: ,p_forced_ranking => hr_transaction_swi.getNumberValue(l_CommitNode,'ForcedRanking')
1218: ,p_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'DateTo')
1219: ,p_performance_review_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PerformanceReviewId')
1220: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
1213: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
1214: ,p_next_sal_review_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextSalReviewDate')
1215: ,p_proposal_reason => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProposalReason')
1216: ,p_proposed_salary_n => hr_transaction_swi.getNumberValue(l_CommitNode,'ProposedSalaryN')
1217: ,p_forced_ranking => hr_transaction_swi.getNumberValue(l_CommitNode,'ForcedRanking')
1218: ,p_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'DateTo')
1219: ,p_performance_review_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PerformanceReviewId')
1220: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
1221: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
1214: ,p_next_sal_review_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextSalReviewDate')
1215: ,p_proposal_reason => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProposalReason')
1216: ,p_proposed_salary_n => hr_transaction_swi.getNumberValue(l_CommitNode,'ProposedSalaryN')
1217: ,p_forced_ranking => hr_transaction_swi.getNumberValue(l_CommitNode,'ForcedRanking')
1218: ,p_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'DateTo')
1219: ,p_performance_review_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PerformanceReviewId')
1220: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
1221: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
1222: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
1215: ,p_proposal_reason => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProposalReason')
1216: ,p_proposed_salary_n => hr_transaction_swi.getNumberValue(l_CommitNode,'ProposedSalaryN')
1217: ,p_forced_ranking => hr_transaction_swi.getNumberValue(l_CommitNode,'ForcedRanking')
1218: ,p_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'DateTo')
1219: ,p_performance_review_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PerformanceReviewId')
1220: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
1221: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
1222: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
1223: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
1216: ,p_proposed_salary_n => hr_transaction_swi.getNumberValue(l_CommitNode,'ProposedSalaryN')
1217: ,p_forced_ranking => hr_transaction_swi.getNumberValue(l_CommitNode,'ForcedRanking')
1218: ,p_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'DateTo')
1219: ,p_performance_review_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PerformanceReviewId')
1220: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
1221: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
1222: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
1223: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
1224: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
1217: ,p_forced_ranking => hr_transaction_swi.getNumberValue(l_CommitNode,'ForcedRanking')
1218: ,p_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'DateTo')
1219: ,p_performance_review_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PerformanceReviewId')
1220: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
1221: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
1222: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
1223: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
1224: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
1225: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
1218: ,p_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'DateTo')
1219: ,p_performance_review_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PerformanceReviewId')
1220: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
1221: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
1222: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
1223: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
1224: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
1225: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
1226: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
1219: ,p_performance_review_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PerformanceReviewId')
1220: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
1221: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
1222: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
1223: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
1224: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
1225: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
1226: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
1227: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
1220: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
1221: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
1222: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
1223: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
1224: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
1225: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
1226: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
1227: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
1228: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
1221: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
1222: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
1223: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
1224: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
1225: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
1226: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
1227: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
1228: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
1229: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
1222: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
1223: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
1224: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
1225: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
1226: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
1227: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
1228: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
1229: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
1230: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
1223: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
1224: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
1225: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
1226: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
1227: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
1228: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
1229: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
1230: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
1231: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
1224: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
1225: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
1226: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
1227: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
1228: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
1229: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
1230: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
1231: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
1232: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
1225: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
1226: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
1227: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
1228: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
1229: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
1230: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
1231: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
1232: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
1233: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
1226: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
1227: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
1228: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
1229: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
1230: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
1231: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
1232: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
1233: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
1234: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
1227: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
1228: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
1229: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
1230: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
1231: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
1232: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
1233: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
1234: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
1235: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
1228: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
1229: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
1230: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
1231: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
1232: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
1233: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
1234: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
1235: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
1236: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
1229: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
1230: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
1231: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
1232: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
1233: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
1234: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
1235: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
1236: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
1237: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
1230: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
1231: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
1232: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
1233: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
1234: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
1235: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
1236: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
1237: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
1238: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
1231: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
1232: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
1233: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
1234: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
1235: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
1236: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
1237: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
1238: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
1239: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
1232: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
1233: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
1234: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
1235: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
1236: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
1237: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
1238: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
1239: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
1240: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
1233: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
1234: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
1235: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
1236: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
1237: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
1238: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
1239: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
1240: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
1241: ,p_object_version_number => l_object_version_number
1234: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
1235: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
1236: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
1237: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
1238: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
1239: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
1240: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
1241: ,p_object_version_number => l_object_version_number
1242: ,p_multiple_components => 'N'--hr_transaction_swi.getVarchar2Value(l_CommitNode,'MultipleComponents')
1235: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
1236: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
1237: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
1238: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
1239: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
1240: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
1241: ,p_object_version_number => l_object_version_number
1242: ,p_multiple_components => 'N'--hr_transaction_swi.getVarchar2Value(l_CommitNode,'MultipleComponents')
1243: ,p_approved => 'N'--hr_transaction_swi.getVarchar2Value(l_CommitNode,'Approved')
1236: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
1237: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
1238: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
1239: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
1240: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
1241: ,p_object_version_number => l_object_version_number
1242: ,p_multiple_components => 'N'--hr_transaction_swi.getVarchar2Value(l_CommitNode,'MultipleComponents')
1243: ,p_approved => 'N'--hr_transaction_swi.getVarchar2Value(l_CommitNode,'Approved')
1244: ,p_validate => p_validate
1238: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
1239: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
1240: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
1241: ,p_object_version_number => l_object_version_number
1242: ,p_multiple_components => 'N'--hr_transaction_swi.getVarchar2Value(l_CommitNode,'MultipleComponents')
1243: ,p_approved => 'N'--hr_transaction_swi.getVarchar2Value(l_CommitNode,'Approved')
1244: ,p_validate => p_validate
1245: ,p_return_status => l_return_status
1246: );
1239: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
1240: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
1241: ,p_object_version_number => l_object_version_number
1242: ,p_multiple_components => 'N'--hr_transaction_swi.getVarchar2Value(l_CommitNode,'MultipleComponents')
1243: ,p_approved => 'N'--hr_transaction_swi.getVarchar2Value(l_CommitNode,'Approved')
1244: ,p_validate => p_validate
1245: ,p_return_status => l_return_status
1246: );
1247:
1249: elsif l_postState = '3' then
1250: -- call delete offer
1251: --
1252: hr_maintain_proposal_swi.delete_salary_proposal
1253: (p_pay_proposal_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PayProposalId')
1254: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId')
1255: ,p_object_version_number => l_object_version_number
1256: ,p_validate => p_validate
1257: ,p_return_status => l_return_status
1250: -- call delete offer
1251: --
1252: hr_maintain_proposal_swi.delete_salary_proposal
1253: (p_pay_proposal_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PayProposalId')
1254: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId')
1255: ,p_object_version_number => l_object_version_number
1256: ,p_validate => p_validate
1257: ,p_return_status => l_return_status
1258: );