DBA Data[Home] [Help]

APPS.HR_MAINTAIN_PROPOSAL_SWI dependencies on HR_TRANSACTION_SWI

Line 1204: l_pay_proposal_id := hr_transaction_swi.getNumberValue(l_CommitNode,'PayProposalId');

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

Line 1205: l_element_entry_id := null;--hr_transaction_swi.getNumberValue(l_CommitNode,'ElementEntryId');

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

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

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

Line 1212: ,p_change_date => hr_transaction_swi.getDateValue(l_CommitNode,'ChangeDate')

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

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

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

Line 1214: ,p_next_sal_review_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextSalReviewDate')

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

Line 1215: ,p_proposal_reason => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProposalReason')

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

Line 1216: ,p_proposed_salary_n => hr_transaction_swi.getNumberValue(l_CommitNode,'ProposedSalaryN')

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

Line 1217: ,p_forced_ranking => hr_transaction_swi.getNumberValue(l_CommitNode,'ForcedRanking')

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

Line 1218: ,p_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'DateTo')

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

Line 1219: ,p_performance_review_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PerformanceReviewId')

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1242: ,p_multiple_components => 'N'--hr_transaction_swi.getVarchar2Value(l_CommitNode,'MultipleComponents')

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

Line 1243: ,p_approved => 'N'--hr_transaction_swi.getVarchar2Value(l_CommitNode,'Approved')

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:

Line 1253: (p_pay_proposal_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PayProposalId')

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

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

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