50: -- Internal Table Handler Use Only.
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml(p_rec in out nocopy per_pyp_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin
61: -- Increment the object version
62: --
63: p_rec.object_version_number := p_rec.object_version_number + 1;
64: --
65: per_pyp_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the per_pay_proposals Row
68: --
69: update per_pay_proposals
106: multiple_components = p_rec.multiple_components,
107: approved = p_rec.approved
108: where pay_proposal_id = p_rec.pay_proposal_id;
109: --
110: per_pyp_shd.g_api_dml := false; -- Unset the api dml status
111: --
112: hr_utility.set_location(' Leaving:'||l_proc, 10);
113: --
114: Exception
113: --
114: Exception
115: When hr_api.check_integrity_violated Then
116: -- A check constraint has been violated
117: per_pyp_shd.g_api_dml := false; -- Unset the api dml status
118: per_pyp_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.parent_integrity_violated Then
121: -- Parent integrity has been violated
114: Exception
115: When hr_api.check_integrity_violated Then
116: -- A check constraint has been violated
117: per_pyp_shd.g_api_dml := false; -- Unset the api dml status
118: per_pyp_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.parent_integrity_violated Then
121: -- Parent integrity has been violated
122: per_pyp_shd.g_api_dml := false; -- Unset the api dml status
118: per_pyp_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.parent_integrity_violated Then
121: -- Parent integrity has been violated
122: per_pyp_shd.g_api_dml := false; -- Unset the api dml status
123: per_pyp_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: When hr_api.unique_integrity_violated Then
126: -- Unique integrity has been violated
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.parent_integrity_violated Then
121: -- Parent integrity has been violated
122: per_pyp_shd.g_api_dml := false; -- Unset the api dml status
123: per_pyp_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: When hr_api.unique_integrity_violated Then
126: -- Unique integrity has been violated
127: per_pyp_shd.g_api_dml := false; -- Unset the api dml status
123: per_pyp_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: When hr_api.unique_integrity_violated Then
126: -- Unique integrity has been violated
127: per_pyp_shd.g_api_dml := false; -- Unset the api dml status
128: per_pyp_shd.constraint_error
129: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
130: When Others Then
131: per_pyp_shd.g_api_dml := false; -- Unset the api dml status
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: When hr_api.unique_integrity_violated Then
126: -- Unique integrity has been violated
127: per_pyp_shd.g_api_dml := false; -- Unset the api dml status
128: per_pyp_shd.constraint_error
129: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
130: When Others Then
131: per_pyp_shd.g_api_dml := false; -- Unset the api dml status
132: Raise;
127: per_pyp_shd.g_api_dml := false; -- Unset the api dml status
128: per_pyp_shd.constraint_error
129: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
130: When Others Then
131: per_pyp_shd.g_api_dml := false; -- Unset the api dml status
132: Raise;
133: End update_dml;
134: --
135: -- ----------------------------------------------------------------------------
163: -- Internal Table Handler Use Only.
164: --
165: -- {End Of Comments}
166: -- ----------------------------------------------------------------------------
167: Procedure pre_update(p_rec in per_pyp_shd.g_rec_type) is
168: --
169: l_proc varchar2(72) := g_package||'pre_update';
170: --
171: Begin
206: --
207: -- {End Of Comments}
208: -- ----------------------------------------------------------------------------
209: Procedure post_update
210: (p_rec in per_pyp_shd.g_rec_type
211: ,p_inv_next_sal_date_warning in boolean
212: ,p_proposed_salary_warning in boolean
213: ,p_approved_warning in boolean
214: ,p_payroll_warning in boolean
234: --
235: -- OAB Bug 1863413 : Detect potential life events when salary
236: -- information changes
237: --
238: l_old_rec.BUSINESS_GROUP_ID := per_pyp_shd.g_old_rec.BUSINESS_GROUP_ID;
239: l_old_rec.PAY_PROPOSAL_ID := per_pyp_shd.g_old_rec.PAY_PROPOSAL_ID;
240: l_old_rec.ASSIGNMENT_ID := per_pyp_shd.g_old_rec.ASSIGNMENT_ID;
241: l_old_rec.EVENT_ID := null; -- 9999 per_pyp_shd.g_old_rec.EVENT_ID;
242: l_old_rec.CHANGE_DATE := per_pyp_shd.g_old_rec.CHANGE_DATE;
235: -- OAB Bug 1863413 : Detect potential life events when salary
236: -- information changes
237: --
238: l_old_rec.BUSINESS_GROUP_ID := per_pyp_shd.g_old_rec.BUSINESS_GROUP_ID;
239: l_old_rec.PAY_PROPOSAL_ID := per_pyp_shd.g_old_rec.PAY_PROPOSAL_ID;
240: l_old_rec.ASSIGNMENT_ID := per_pyp_shd.g_old_rec.ASSIGNMENT_ID;
241: l_old_rec.EVENT_ID := null; -- 9999 per_pyp_shd.g_old_rec.EVENT_ID;
242: l_old_rec.CHANGE_DATE := per_pyp_shd.g_old_rec.CHANGE_DATE;
243: l_old_rec.LAST_CHANGE_DATE := per_pyp_shd.g_old_rec.LAST_CHANGE_DATE;
236: -- information changes
237: --
238: l_old_rec.BUSINESS_GROUP_ID := per_pyp_shd.g_old_rec.BUSINESS_GROUP_ID;
239: l_old_rec.PAY_PROPOSAL_ID := per_pyp_shd.g_old_rec.PAY_PROPOSAL_ID;
240: l_old_rec.ASSIGNMENT_ID := per_pyp_shd.g_old_rec.ASSIGNMENT_ID;
241: l_old_rec.EVENT_ID := null; -- 9999 per_pyp_shd.g_old_rec.EVENT_ID;
242: l_old_rec.CHANGE_DATE := per_pyp_shd.g_old_rec.CHANGE_DATE;
243: l_old_rec.LAST_CHANGE_DATE := per_pyp_shd.g_old_rec.LAST_CHANGE_DATE;
244: l_old_rec.NEXT_PERF_REVIEW_DATE := null; -- 9999 per_pyp_shd.g_old_rec.NEXT_PERF_REVIEW_DATE;
237: --
238: l_old_rec.BUSINESS_GROUP_ID := per_pyp_shd.g_old_rec.BUSINESS_GROUP_ID;
239: l_old_rec.PAY_PROPOSAL_ID := per_pyp_shd.g_old_rec.PAY_PROPOSAL_ID;
240: l_old_rec.ASSIGNMENT_ID := per_pyp_shd.g_old_rec.ASSIGNMENT_ID;
241: l_old_rec.EVENT_ID := null; -- 9999 per_pyp_shd.g_old_rec.EVENT_ID;
242: l_old_rec.CHANGE_DATE := per_pyp_shd.g_old_rec.CHANGE_DATE;
243: l_old_rec.LAST_CHANGE_DATE := per_pyp_shd.g_old_rec.LAST_CHANGE_DATE;
244: l_old_rec.NEXT_PERF_REVIEW_DATE := null; -- 9999 per_pyp_shd.g_old_rec.NEXT_PERF_REVIEW_DATE;
245: l_old_rec.NEXT_SAL_REVIEW_DATE := per_pyp_shd.g_old_rec.NEXT_SAL_REVIEW_DATE;
238: l_old_rec.BUSINESS_GROUP_ID := per_pyp_shd.g_old_rec.BUSINESS_GROUP_ID;
239: l_old_rec.PAY_PROPOSAL_ID := per_pyp_shd.g_old_rec.PAY_PROPOSAL_ID;
240: l_old_rec.ASSIGNMENT_ID := per_pyp_shd.g_old_rec.ASSIGNMENT_ID;
241: l_old_rec.EVENT_ID := null; -- 9999 per_pyp_shd.g_old_rec.EVENT_ID;
242: l_old_rec.CHANGE_DATE := per_pyp_shd.g_old_rec.CHANGE_DATE;
243: l_old_rec.LAST_CHANGE_DATE := per_pyp_shd.g_old_rec.LAST_CHANGE_DATE;
244: l_old_rec.NEXT_PERF_REVIEW_DATE := null; -- 9999 per_pyp_shd.g_old_rec.NEXT_PERF_REVIEW_DATE;
245: l_old_rec.NEXT_SAL_REVIEW_DATE := per_pyp_shd.g_old_rec.NEXT_SAL_REVIEW_DATE;
246: l_old_rec.PERFORMANCE_RATING := null; -- 9999 per_pyp_shd.g_old_rec.PERFORMANCE_RATING;
239: l_old_rec.PAY_PROPOSAL_ID := per_pyp_shd.g_old_rec.PAY_PROPOSAL_ID;
240: l_old_rec.ASSIGNMENT_ID := per_pyp_shd.g_old_rec.ASSIGNMENT_ID;
241: l_old_rec.EVENT_ID := null; -- 9999 per_pyp_shd.g_old_rec.EVENT_ID;
242: l_old_rec.CHANGE_DATE := per_pyp_shd.g_old_rec.CHANGE_DATE;
243: l_old_rec.LAST_CHANGE_DATE := per_pyp_shd.g_old_rec.LAST_CHANGE_DATE;
244: l_old_rec.NEXT_PERF_REVIEW_DATE := null; -- 9999 per_pyp_shd.g_old_rec.NEXT_PERF_REVIEW_DATE;
245: l_old_rec.NEXT_SAL_REVIEW_DATE := per_pyp_shd.g_old_rec.NEXT_SAL_REVIEW_DATE;
246: l_old_rec.PERFORMANCE_RATING := null; -- 9999 per_pyp_shd.g_old_rec.PERFORMANCE_RATING;
247: l_old_rec.PROPOSAL_REASON := per_pyp_shd.g_old_rec.PROPOSAL_REASON;
240: l_old_rec.ASSIGNMENT_ID := per_pyp_shd.g_old_rec.ASSIGNMENT_ID;
241: l_old_rec.EVENT_ID := null; -- 9999 per_pyp_shd.g_old_rec.EVENT_ID;
242: l_old_rec.CHANGE_DATE := per_pyp_shd.g_old_rec.CHANGE_DATE;
243: l_old_rec.LAST_CHANGE_DATE := per_pyp_shd.g_old_rec.LAST_CHANGE_DATE;
244: l_old_rec.NEXT_PERF_REVIEW_DATE := null; -- 9999 per_pyp_shd.g_old_rec.NEXT_PERF_REVIEW_DATE;
245: l_old_rec.NEXT_SAL_REVIEW_DATE := per_pyp_shd.g_old_rec.NEXT_SAL_REVIEW_DATE;
246: l_old_rec.PERFORMANCE_RATING := null; -- 9999 per_pyp_shd.g_old_rec.PERFORMANCE_RATING;
247: l_old_rec.PROPOSAL_REASON := per_pyp_shd.g_old_rec.PROPOSAL_REASON;
248: l_old_rec.PROPOSED_SALARY_N := per_pyp_shd.g_old_rec.PROPOSED_SALARY_N;
241: l_old_rec.EVENT_ID := null; -- 9999 per_pyp_shd.g_old_rec.EVENT_ID;
242: l_old_rec.CHANGE_DATE := per_pyp_shd.g_old_rec.CHANGE_DATE;
243: l_old_rec.LAST_CHANGE_DATE := per_pyp_shd.g_old_rec.LAST_CHANGE_DATE;
244: l_old_rec.NEXT_PERF_REVIEW_DATE := null; -- 9999 per_pyp_shd.g_old_rec.NEXT_PERF_REVIEW_DATE;
245: l_old_rec.NEXT_SAL_REVIEW_DATE := per_pyp_shd.g_old_rec.NEXT_SAL_REVIEW_DATE;
246: l_old_rec.PERFORMANCE_RATING := null; -- 9999 per_pyp_shd.g_old_rec.PERFORMANCE_RATING;
247: l_old_rec.PROPOSAL_REASON := per_pyp_shd.g_old_rec.PROPOSAL_REASON;
248: l_old_rec.PROPOSED_SALARY_N := per_pyp_shd.g_old_rec.PROPOSED_SALARY_N;
249: l_old_rec.REVIEW_DATE := null; -- 9999 per_pyp_shd.g_old_rec.REVIEW_DATE;
242: l_old_rec.CHANGE_DATE := per_pyp_shd.g_old_rec.CHANGE_DATE;
243: l_old_rec.LAST_CHANGE_DATE := per_pyp_shd.g_old_rec.LAST_CHANGE_DATE;
244: l_old_rec.NEXT_PERF_REVIEW_DATE := null; -- 9999 per_pyp_shd.g_old_rec.NEXT_PERF_REVIEW_DATE;
245: l_old_rec.NEXT_SAL_REVIEW_DATE := per_pyp_shd.g_old_rec.NEXT_SAL_REVIEW_DATE;
246: l_old_rec.PERFORMANCE_RATING := null; -- 9999 per_pyp_shd.g_old_rec.PERFORMANCE_RATING;
247: l_old_rec.PROPOSAL_REASON := per_pyp_shd.g_old_rec.PROPOSAL_REASON;
248: l_old_rec.PROPOSED_SALARY_N := per_pyp_shd.g_old_rec.PROPOSED_SALARY_N;
249: l_old_rec.REVIEW_DATE := null; -- 9999 per_pyp_shd.g_old_rec.REVIEW_DATE;
250: l_old_rec.APPROVED := per_pyp_shd.g_old_rec.APPROVED;
243: l_old_rec.LAST_CHANGE_DATE := per_pyp_shd.g_old_rec.LAST_CHANGE_DATE;
244: l_old_rec.NEXT_PERF_REVIEW_DATE := null; -- 9999 per_pyp_shd.g_old_rec.NEXT_PERF_REVIEW_DATE;
245: l_old_rec.NEXT_SAL_REVIEW_DATE := per_pyp_shd.g_old_rec.NEXT_SAL_REVIEW_DATE;
246: l_old_rec.PERFORMANCE_RATING := null; -- 9999 per_pyp_shd.g_old_rec.PERFORMANCE_RATING;
247: l_old_rec.PROPOSAL_REASON := per_pyp_shd.g_old_rec.PROPOSAL_REASON;
248: l_old_rec.PROPOSED_SALARY_N := per_pyp_shd.g_old_rec.PROPOSED_SALARY_N;
249: l_old_rec.REVIEW_DATE := null; -- 9999 per_pyp_shd.g_old_rec.REVIEW_DATE;
250: l_old_rec.APPROVED := per_pyp_shd.g_old_rec.APPROVED;
251: l_old_rec.MULTIPLE_COMPONENTS := per_pyp_shd.g_old_rec.MULTIPLE_COMPONENTS;
244: l_old_rec.NEXT_PERF_REVIEW_DATE := null; -- 9999 per_pyp_shd.g_old_rec.NEXT_PERF_REVIEW_DATE;
245: l_old_rec.NEXT_SAL_REVIEW_DATE := per_pyp_shd.g_old_rec.NEXT_SAL_REVIEW_DATE;
246: l_old_rec.PERFORMANCE_RATING := null; -- 9999 per_pyp_shd.g_old_rec.PERFORMANCE_RATING;
247: l_old_rec.PROPOSAL_REASON := per_pyp_shd.g_old_rec.PROPOSAL_REASON;
248: l_old_rec.PROPOSED_SALARY_N := per_pyp_shd.g_old_rec.PROPOSED_SALARY_N;
249: l_old_rec.REVIEW_DATE := null; -- 9999 per_pyp_shd.g_old_rec.REVIEW_DATE;
250: l_old_rec.APPROVED := per_pyp_shd.g_old_rec.APPROVED;
251: l_old_rec.MULTIPLE_COMPONENTS := per_pyp_shd.g_old_rec.MULTIPLE_COMPONENTS;
252: l_old_rec.FORCED_RANKING := per_pyp_shd.g_old_rec.FORCED_RANKING;
245: l_old_rec.NEXT_SAL_REVIEW_DATE := per_pyp_shd.g_old_rec.NEXT_SAL_REVIEW_DATE;
246: l_old_rec.PERFORMANCE_RATING := null; -- 9999 per_pyp_shd.g_old_rec.PERFORMANCE_RATING;
247: l_old_rec.PROPOSAL_REASON := per_pyp_shd.g_old_rec.PROPOSAL_REASON;
248: l_old_rec.PROPOSED_SALARY_N := per_pyp_shd.g_old_rec.PROPOSED_SALARY_N;
249: l_old_rec.REVIEW_DATE := null; -- 9999 per_pyp_shd.g_old_rec.REVIEW_DATE;
250: l_old_rec.APPROVED := per_pyp_shd.g_old_rec.APPROVED;
251: l_old_rec.MULTIPLE_COMPONENTS := per_pyp_shd.g_old_rec.MULTIPLE_COMPONENTS;
252: l_old_rec.FORCED_RANKING := per_pyp_shd.g_old_rec.FORCED_RANKING;
253: l_old_rec.DATE_TO := per_pyp_shd.g_old_rec.DATE_TO;
246: l_old_rec.PERFORMANCE_RATING := null; -- 9999 per_pyp_shd.g_old_rec.PERFORMANCE_RATING;
247: l_old_rec.PROPOSAL_REASON := per_pyp_shd.g_old_rec.PROPOSAL_REASON;
248: l_old_rec.PROPOSED_SALARY_N := per_pyp_shd.g_old_rec.PROPOSED_SALARY_N;
249: l_old_rec.REVIEW_DATE := null; -- 9999 per_pyp_shd.g_old_rec.REVIEW_DATE;
250: l_old_rec.APPROVED := per_pyp_shd.g_old_rec.APPROVED;
251: l_old_rec.MULTIPLE_COMPONENTS := per_pyp_shd.g_old_rec.MULTIPLE_COMPONENTS;
252: l_old_rec.FORCED_RANKING := per_pyp_shd.g_old_rec.FORCED_RANKING;
253: l_old_rec.DATE_TO := per_pyp_shd.g_old_rec.DATE_TO;
254: l_old_rec.PERFORMANCE_REVIEW_ID := per_pyp_shd.g_old_rec.PERFORMANCE_REVIEW_ID;
247: l_old_rec.PROPOSAL_REASON := per_pyp_shd.g_old_rec.PROPOSAL_REASON;
248: l_old_rec.PROPOSED_SALARY_N := per_pyp_shd.g_old_rec.PROPOSED_SALARY_N;
249: l_old_rec.REVIEW_DATE := null; -- 9999 per_pyp_shd.g_old_rec.REVIEW_DATE;
250: l_old_rec.APPROVED := per_pyp_shd.g_old_rec.APPROVED;
251: l_old_rec.MULTIPLE_COMPONENTS := per_pyp_shd.g_old_rec.MULTIPLE_COMPONENTS;
252: l_old_rec.FORCED_RANKING := per_pyp_shd.g_old_rec.FORCED_RANKING;
253: l_old_rec.DATE_TO := per_pyp_shd.g_old_rec.DATE_TO;
254: l_old_rec.PERFORMANCE_REVIEW_ID := per_pyp_shd.g_old_rec.PERFORMANCE_REVIEW_ID;
255: l_old_rec.ATTRIBUTE1 := per_pyp_shd.g_old_rec.ATTRIBUTE1;
248: l_old_rec.PROPOSED_SALARY_N := per_pyp_shd.g_old_rec.PROPOSED_SALARY_N;
249: l_old_rec.REVIEW_DATE := null; -- 9999 per_pyp_shd.g_old_rec.REVIEW_DATE;
250: l_old_rec.APPROVED := per_pyp_shd.g_old_rec.APPROVED;
251: l_old_rec.MULTIPLE_COMPONENTS := per_pyp_shd.g_old_rec.MULTIPLE_COMPONENTS;
252: l_old_rec.FORCED_RANKING := per_pyp_shd.g_old_rec.FORCED_RANKING;
253: l_old_rec.DATE_TO := per_pyp_shd.g_old_rec.DATE_TO;
254: l_old_rec.PERFORMANCE_REVIEW_ID := per_pyp_shd.g_old_rec.PERFORMANCE_REVIEW_ID;
255: l_old_rec.ATTRIBUTE1 := per_pyp_shd.g_old_rec.ATTRIBUTE1;
256: l_old_rec.ATTRIBUTE2 := per_pyp_shd.g_old_rec.ATTRIBUTE2;
249: l_old_rec.REVIEW_DATE := null; -- 9999 per_pyp_shd.g_old_rec.REVIEW_DATE;
250: l_old_rec.APPROVED := per_pyp_shd.g_old_rec.APPROVED;
251: l_old_rec.MULTIPLE_COMPONENTS := per_pyp_shd.g_old_rec.MULTIPLE_COMPONENTS;
252: l_old_rec.FORCED_RANKING := per_pyp_shd.g_old_rec.FORCED_RANKING;
253: l_old_rec.DATE_TO := per_pyp_shd.g_old_rec.DATE_TO;
254: l_old_rec.PERFORMANCE_REVIEW_ID := per_pyp_shd.g_old_rec.PERFORMANCE_REVIEW_ID;
255: l_old_rec.ATTRIBUTE1 := per_pyp_shd.g_old_rec.ATTRIBUTE1;
256: l_old_rec.ATTRIBUTE2 := per_pyp_shd.g_old_rec.ATTRIBUTE2;
257: l_old_rec.ATTRIBUTE3 := per_pyp_shd.g_old_rec.ATTRIBUTE3;
250: l_old_rec.APPROVED := per_pyp_shd.g_old_rec.APPROVED;
251: l_old_rec.MULTIPLE_COMPONENTS := per_pyp_shd.g_old_rec.MULTIPLE_COMPONENTS;
252: l_old_rec.FORCED_RANKING := per_pyp_shd.g_old_rec.FORCED_RANKING;
253: l_old_rec.DATE_TO := per_pyp_shd.g_old_rec.DATE_TO;
254: l_old_rec.PERFORMANCE_REVIEW_ID := per_pyp_shd.g_old_rec.PERFORMANCE_REVIEW_ID;
255: l_old_rec.ATTRIBUTE1 := per_pyp_shd.g_old_rec.ATTRIBUTE1;
256: l_old_rec.ATTRIBUTE2 := per_pyp_shd.g_old_rec.ATTRIBUTE2;
257: l_old_rec.ATTRIBUTE3 := per_pyp_shd.g_old_rec.ATTRIBUTE3;
258: l_old_rec.ATTRIBUTE4 := per_pyp_shd.g_old_rec.ATTRIBUTE4;
251: l_old_rec.MULTIPLE_COMPONENTS := per_pyp_shd.g_old_rec.MULTIPLE_COMPONENTS;
252: l_old_rec.FORCED_RANKING := per_pyp_shd.g_old_rec.FORCED_RANKING;
253: l_old_rec.DATE_TO := per_pyp_shd.g_old_rec.DATE_TO;
254: l_old_rec.PERFORMANCE_REVIEW_ID := per_pyp_shd.g_old_rec.PERFORMANCE_REVIEW_ID;
255: l_old_rec.ATTRIBUTE1 := per_pyp_shd.g_old_rec.ATTRIBUTE1;
256: l_old_rec.ATTRIBUTE2 := per_pyp_shd.g_old_rec.ATTRIBUTE2;
257: l_old_rec.ATTRIBUTE3 := per_pyp_shd.g_old_rec.ATTRIBUTE3;
258: l_old_rec.ATTRIBUTE4 := per_pyp_shd.g_old_rec.ATTRIBUTE4;
259: l_old_rec.ATTRIBUTE5 := per_pyp_shd.g_old_rec.ATTRIBUTE5;
252: l_old_rec.FORCED_RANKING := per_pyp_shd.g_old_rec.FORCED_RANKING;
253: l_old_rec.DATE_TO := per_pyp_shd.g_old_rec.DATE_TO;
254: l_old_rec.PERFORMANCE_REVIEW_ID := per_pyp_shd.g_old_rec.PERFORMANCE_REVIEW_ID;
255: l_old_rec.ATTRIBUTE1 := per_pyp_shd.g_old_rec.ATTRIBUTE1;
256: l_old_rec.ATTRIBUTE2 := per_pyp_shd.g_old_rec.ATTRIBUTE2;
257: l_old_rec.ATTRIBUTE3 := per_pyp_shd.g_old_rec.ATTRIBUTE3;
258: l_old_rec.ATTRIBUTE4 := per_pyp_shd.g_old_rec.ATTRIBUTE4;
259: l_old_rec.ATTRIBUTE5 := per_pyp_shd.g_old_rec.ATTRIBUTE5;
260: l_old_rec.ATTRIBUTE6 := per_pyp_shd.g_old_rec.ATTRIBUTE6;
253: l_old_rec.DATE_TO := per_pyp_shd.g_old_rec.DATE_TO;
254: l_old_rec.PERFORMANCE_REVIEW_ID := per_pyp_shd.g_old_rec.PERFORMANCE_REVIEW_ID;
255: l_old_rec.ATTRIBUTE1 := per_pyp_shd.g_old_rec.ATTRIBUTE1;
256: l_old_rec.ATTRIBUTE2 := per_pyp_shd.g_old_rec.ATTRIBUTE2;
257: l_old_rec.ATTRIBUTE3 := per_pyp_shd.g_old_rec.ATTRIBUTE3;
258: l_old_rec.ATTRIBUTE4 := per_pyp_shd.g_old_rec.ATTRIBUTE4;
259: l_old_rec.ATTRIBUTE5 := per_pyp_shd.g_old_rec.ATTRIBUTE5;
260: l_old_rec.ATTRIBUTE6 := per_pyp_shd.g_old_rec.ATTRIBUTE6;
261: l_old_rec.ATTRIBUTE7 := per_pyp_shd.g_old_rec.ATTRIBUTE7;
254: l_old_rec.PERFORMANCE_REVIEW_ID := per_pyp_shd.g_old_rec.PERFORMANCE_REVIEW_ID;
255: l_old_rec.ATTRIBUTE1 := per_pyp_shd.g_old_rec.ATTRIBUTE1;
256: l_old_rec.ATTRIBUTE2 := per_pyp_shd.g_old_rec.ATTRIBUTE2;
257: l_old_rec.ATTRIBUTE3 := per_pyp_shd.g_old_rec.ATTRIBUTE3;
258: l_old_rec.ATTRIBUTE4 := per_pyp_shd.g_old_rec.ATTRIBUTE4;
259: l_old_rec.ATTRIBUTE5 := per_pyp_shd.g_old_rec.ATTRIBUTE5;
260: l_old_rec.ATTRIBUTE6 := per_pyp_shd.g_old_rec.ATTRIBUTE6;
261: l_old_rec.ATTRIBUTE7 := per_pyp_shd.g_old_rec.ATTRIBUTE7;
262: l_old_rec.ATTRIBUTE8 := per_pyp_shd.g_old_rec.ATTRIBUTE8;
255: l_old_rec.ATTRIBUTE1 := per_pyp_shd.g_old_rec.ATTRIBUTE1;
256: l_old_rec.ATTRIBUTE2 := per_pyp_shd.g_old_rec.ATTRIBUTE2;
257: l_old_rec.ATTRIBUTE3 := per_pyp_shd.g_old_rec.ATTRIBUTE3;
258: l_old_rec.ATTRIBUTE4 := per_pyp_shd.g_old_rec.ATTRIBUTE4;
259: l_old_rec.ATTRIBUTE5 := per_pyp_shd.g_old_rec.ATTRIBUTE5;
260: l_old_rec.ATTRIBUTE6 := per_pyp_shd.g_old_rec.ATTRIBUTE6;
261: l_old_rec.ATTRIBUTE7 := per_pyp_shd.g_old_rec.ATTRIBUTE7;
262: l_old_rec.ATTRIBUTE8 := per_pyp_shd.g_old_rec.ATTRIBUTE8;
263: l_old_rec.ATTRIBUTE9 := per_pyp_shd.g_old_rec.ATTRIBUTE9;
256: l_old_rec.ATTRIBUTE2 := per_pyp_shd.g_old_rec.ATTRIBUTE2;
257: l_old_rec.ATTRIBUTE3 := per_pyp_shd.g_old_rec.ATTRIBUTE3;
258: l_old_rec.ATTRIBUTE4 := per_pyp_shd.g_old_rec.ATTRIBUTE4;
259: l_old_rec.ATTRIBUTE5 := per_pyp_shd.g_old_rec.ATTRIBUTE5;
260: l_old_rec.ATTRIBUTE6 := per_pyp_shd.g_old_rec.ATTRIBUTE6;
261: l_old_rec.ATTRIBUTE7 := per_pyp_shd.g_old_rec.ATTRIBUTE7;
262: l_old_rec.ATTRIBUTE8 := per_pyp_shd.g_old_rec.ATTRIBUTE8;
263: l_old_rec.ATTRIBUTE9 := per_pyp_shd.g_old_rec.ATTRIBUTE9;
264: l_old_rec.ATTRIBUTE10 := per_pyp_shd.g_old_rec.ATTRIBUTE10;
257: l_old_rec.ATTRIBUTE3 := per_pyp_shd.g_old_rec.ATTRIBUTE3;
258: l_old_rec.ATTRIBUTE4 := per_pyp_shd.g_old_rec.ATTRIBUTE4;
259: l_old_rec.ATTRIBUTE5 := per_pyp_shd.g_old_rec.ATTRIBUTE5;
260: l_old_rec.ATTRIBUTE6 := per_pyp_shd.g_old_rec.ATTRIBUTE6;
261: l_old_rec.ATTRIBUTE7 := per_pyp_shd.g_old_rec.ATTRIBUTE7;
262: l_old_rec.ATTRIBUTE8 := per_pyp_shd.g_old_rec.ATTRIBUTE8;
263: l_old_rec.ATTRIBUTE9 := per_pyp_shd.g_old_rec.ATTRIBUTE9;
264: l_old_rec.ATTRIBUTE10 := per_pyp_shd.g_old_rec.ATTRIBUTE10;
265: l_old_rec.ATTRIBUTE11 := per_pyp_shd.g_old_rec.ATTRIBUTE11;
258: l_old_rec.ATTRIBUTE4 := per_pyp_shd.g_old_rec.ATTRIBUTE4;
259: l_old_rec.ATTRIBUTE5 := per_pyp_shd.g_old_rec.ATTRIBUTE5;
260: l_old_rec.ATTRIBUTE6 := per_pyp_shd.g_old_rec.ATTRIBUTE6;
261: l_old_rec.ATTRIBUTE7 := per_pyp_shd.g_old_rec.ATTRIBUTE7;
262: l_old_rec.ATTRIBUTE8 := per_pyp_shd.g_old_rec.ATTRIBUTE8;
263: l_old_rec.ATTRIBUTE9 := per_pyp_shd.g_old_rec.ATTRIBUTE9;
264: l_old_rec.ATTRIBUTE10 := per_pyp_shd.g_old_rec.ATTRIBUTE10;
265: l_old_rec.ATTRIBUTE11 := per_pyp_shd.g_old_rec.ATTRIBUTE11;
266: l_old_rec.ATTRIBUTE12 := per_pyp_shd.g_old_rec.ATTRIBUTE12;
259: l_old_rec.ATTRIBUTE5 := per_pyp_shd.g_old_rec.ATTRIBUTE5;
260: l_old_rec.ATTRIBUTE6 := per_pyp_shd.g_old_rec.ATTRIBUTE6;
261: l_old_rec.ATTRIBUTE7 := per_pyp_shd.g_old_rec.ATTRIBUTE7;
262: l_old_rec.ATTRIBUTE8 := per_pyp_shd.g_old_rec.ATTRIBUTE8;
263: l_old_rec.ATTRIBUTE9 := per_pyp_shd.g_old_rec.ATTRIBUTE9;
264: l_old_rec.ATTRIBUTE10 := per_pyp_shd.g_old_rec.ATTRIBUTE10;
265: l_old_rec.ATTRIBUTE11 := per_pyp_shd.g_old_rec.ATTRIBUTE11;
266: l_old_rec.ATTRIBUTE12 := per_pyp_shd.g_old_rec.ATTRIBUTE12;
267: l_old_rec.ATTRIBUTE13 := per_pyp_shd.g_old_rec.ATTRIBUTE13;
260: l_old_rec.ATTRIBUTE6 := per_pyp_shd.g_old_rec.ATTRIBUTE6;
261: l_old_rec.ATTRIBUTE7 := per_pyp_shd.g_old_rec.ATTRIBUTE7;
262: l_old_rec.ATTRIBUTE8 := per_pyp_shd.g_old_rec.ATTRIBUTE8;
263: l_old_rec.ATTRIBUTE9 := per_pyp_shd.g_old_rec.ATTRIBUTE9;
264: l_old_rec.ATTRIBUTE10 := per_pyp_shd.g_old_rec.ATTRIBUTE10;
265: l_old_rec.ATTRIBUTE11 := per_pyp_shd.g_old_rec.ATTRIBUTE11;
266: l_old_rec.ATTRIBUTE12 := per_pyp_shd.g_old_rec.ATTRIBUTE12;
267: l_old_rec.ATTRIBUTE13 := per_pyp_shd.g_old_rec.ATTRIBUTE13;
268: l_old_rec.ATTRIBUTE14 := per_pyp_shd.g_old_rec.ATTRIBUTE14;
261: l_old_rec.ATTRIBUTE7 := per_pyp_shd.g_old_rec.ATTRIBUTE7;
262: l_old_rec.ATTRIBUTE8 := per_pyp_shd.g_old_rec.ATTRIBUTE8;
263: l_old_rec.ATTRIBUTE9 := per_pyp_shd.g_old_rec.ATTRIBUTE9;
264: l_old_rec.ATTRIBUTE10 := per_pyp_shd.g_old_rec.ATTRIBUTE10;
265: l_old_rec.ATTRIBUTE11 := per_pyp_shd.g_old_rec.ATTRIBUTE11;
266: l_old_rec.ATTRIBUTE12 := per_pyp_shd.g_old_rec.ATTRIBUTE12;
267: l_old_rec.ATTRIBUTE13 := per_pyp_shd.g_old_rec.ATTRIBUTE13;
268: l_old_rec.ATTRIBUTE14 := per_pyp_shd.g_old_rec.ATTRIBUTE14;
269: l_old_rec.ATTRIBUTE15 := per_pyp_shd.g_old_rec.ATTRIBUTE15;
262: l_old_rec.ATTRIBUTE8 := per_pyp_shd.g_old_rec.ATTRIBUTE8;
263: l_old_rec.ATTRIBUTE9 := per_pyp_shd.g_old_rec.ATTRIBUTE9;
264: l_old_rec.ATTRIBUTE10 := per_pyp_shd.g_old_rec.ATTRIBUTE10;
265: l_old_rec.ATTRIBUTE11 := per_pyp_shd.g_old_rec.ATTRIBUTE11;
266: l_old_rec.ATTRIBUTE12 := per_pyp_shd.g_old_rec.ATTRIBUTE12;
267: l_old_rec.ATTRIBUTE13 := per_pyp_shd.g_old_rec.ATTRIBUTE13;
268: l_old_rec.ATTRIBUTE14 := per_pyp_shd.g_old_rec.ATTRIBUTE14;
269: l_old_rec.ATTRIBUTE15 := per_pyp_shd.g_old_rec.ATTRIBUTE15;
270: l_old_rec.ATTRIBUTE16 := per_pyp_shd.g_old_rec.ATTRIBUTE16;
263: l_old_rec.ATTRIBUTE9 := per_pyp_shd.g_old_rec.ATTRIBUTE9;
264: l_old_rec.ATTRIBUTE10 := per_pyp_shd.g_old_rec.ATTRIBUTE10;
265: l_old_rec.ATTRIBUTE11 := per_pyp_shd.g_old_rec.ATTRIBUTE11;
266: l_old_rec.ATTRIBUTE12 := per_pyp_shd.g_old_rec.ATTRIBUTE12;
267: l_old_rec.ATTRIBUTE13 := per_pyp_shd.g_old_rec.ATTRIBUTE13;
268: l_old_rec.ATTRIBUTE14 := per_pyp_shd.g_old_rec.ATTRIBUTE14;
269: l_old_rec.ATTRIBUTE15 := per_pyp_shd.g_old_rec.ATTRIBUTE15;
270: l_old_rec.ATTRIBUTE16 := per_pyp_shd.g_old_rec.ATTRIBUTE16;
271: l_old_rec.ATTRIBUTE17 := per_pyp_shd.g_old_rec.ATTRIBUTE17;
264: l_old_rec.ATTRIBUTE10 := per_pyp_shd.g_old_rec.ATTRIBUTE10;
265: l_old_rec.ATTRIBUTE11 := per_pyp_shd.g_old_rec.ATTRIBUTE11;
266: l_old_rec.ATTRIBUTE12 := per_pyp_shd.g_old_rec.ATTRIBUTE12;
267: l_old_rec.ATTRIBUTE13 := per_pyp_shd.g_old_rec.ATTRIBUTE13;
268: l_old_rec.ATTRIBUTE14 := per_pyp_shd.g_old_rec.ATTRIBUTE14;
269: l_old_rec.ATTRIBUTE15 := per_pyp_shd.g_old_rec.ATTRIBUTE15;
270: l_old_rec.ATTRIBUTE16 := per_pyp_shd.g_old_rec.ATTRIBUTE16;
271: l_old_rec.ATTRIBUTE17 := per_pyp_shd.g_old_rec.ATTRIBUTE17;
272: l_old_rec.ATTRIBUTE18 := per_pyp_shd.g_old_rec.ATTRIBUTE18;
265: l_old_rec.ATTRIBUTE11 := per_pyp_shd.g_old_rec.ATTRIBUTE11;
266: l_old_rec.ATTRIBUTE12 := per_pyp_shd.g_old_rec.ATTRIBUTE12;
267: l_old_rec.ATTRIBUTE13 := per_pyp_shd.g_old_rec.ATTRIBUTE13;
268: l_old_rec.ATTRIBUTE14 := per_pyp_shd.g_old_rec.ATTRIBUTE14;
269: l_old_rec.ATTRIBUTE15 := per_pyp_shd.g_old_rec.ATTRIBUTE15;
270: l_old_rec.ATTRIBUTE16 := per_pyp_shd.g_old_rec.ATTRIBUTE16;
271: l_old_rec.ATTRIBUTE17 := per_pyp_shd.g_old_rec.ATTRIBUTE17;
272: l_old_rec.ATTRIBUTE18 := per_pyp_shd.g_old_rec.ATTRIBUTE18;
273: l_old_rec.ATTRIBUTE19 := per_pyp_shd.g_old_rec.ATTRIBUTE19;
266: l_old_rec.ATTRIBUTE12 := per_pyp_shd.g_old_rec.ATTRIBUTE12;
267: l_old_rec.ATTRIBUTE13 := per_pyp_shd.g_old_rec.ATTRIBUTE13;
268: l_old_rec.ATTRIBUTE14 := per_pyp_shd.g_old_rec.ATTRIBUTE14;
269: l_old_rec.ATTRIBUTE15 := per_pyp_shd.g_old_rec.ATTRIBUTE15;
270: l_old_rec.ATTRIBUTE16 := per_pyp_shd.g_old_rec.ATTRIBUTE16;
271: l_old_rec.ATTRIBUTE17 := per_pyp_shd.g_old_rec.ATTRIBUTE17;
272: l_old_rec.ATTRIBUTE18 := per_pyp_shd.g_old_rec.ATTRIBUTE18;
273: l_old_rec.ATTRIBUTE19 := per_pyp_shd.g_old_rec.ATTRIBUTE19;
274: l_old_rec.ATTRIBUTE20 := per_pyp_shd.g_old_rec.ATTRIBUTE20;
267: l_old_rec.ATTRIBUTE13 := per_pyp_shd.g_old_rec.ATTRIBUTE13;
268: l_old_rec.ATTRIBUTE14 := per_pyp_shd.g_old_rec.ATTRIBUTE14;
269: l_old_rec.ATTRIBUTE15 := per_pyp_shd.g_old_rec.ATTRIBUTE15;
270: l_old_rec.ATTRIBUTE16 := per_pyp_shd.g_old_rec.ATTRIBUTE16;
271: l_old_rec.ATTRIBUTE17 := per_pyp_shd.g_old_rec.ATTRIBUTE17;
272: l_old_rec.ATTRIBUTE18 := per_pyp_shd.g_old_rec.ATTRIBUTE18;
273: l_old_rec.ATTRIBUTE19 := per_pyp_shd.g_old_rec.ATTRIBUTE19;
274: l_old_rec.ATTRIBUTE20 := per_pyp_shd.g_old_rec.ATTRIBUTE20;
275: l_old_rec.PROPOSED_SALARY := null; -- 9999 ben_pro_shd.g_old_rec.PROPOSED_SALARY;
268: l_old_rec.ATTRIBUTE14 := per_pyp_shd.g_old_rec.ATTRIBUTE14;
269: l_old_rec.ATTRIBUTE15 := per_pyp_shd.g_old_rec.ATTRIBUTE15;
270: l_old_rec.ATTRIBUTE16 := per_pyp_shd.g_old_rec.ATTRIBUTE16;
271: l_old_rec.ATTRIBUTE17 := per_pyp_shd.g_old_rec.ATTRIBUTE17;
272: l_old_rec.ATTRIBUTE18 := per_pyp_shd.g_old_rec.ATTRIBUTE18;
273: l_old_rec.ATTRIBUTE19 := per_pyp_shd.g_old_rec.ATTRIBUTE19;
274: l_old_rec.ATTRIBUTE20 := per_pyp_shd.g_old_rec.ATTRIBUTE20;
275: l_old_rec.PROPOSED_SALARY := null; -- 9999 ben_pro_shd.g_old_rec.PROPOSED_SALARY;
276: --
269: l_old_rec.ATTRIBUTE15 := per_pyp_shd.g_old_rec.ATTRIBUTE15;
270: l_old_rec.ATTRIBUTE16 := per_pyp_shd.g_old_rec.ATTRIBUTE16;
271: l_old_rec.ATTRIBUTE17 := per_pyp_shd.g_old_rec.ATTRIBUTE17;
272: l_old_rec.ATTRIBUTE18 := per_pyp_shd.g_old_rec.ATTRIBUTE18;
273: l_old_rec.ATTRIBUTE19 := per_pyp_shd.g_old_rec.ATTRIBUTE19;
274: l_old_rec.ATTRIBUTE20 := per_pyp_shd.g_old_rec.ATTRIBUTE20;
275: l_old_rec.PROPOSED_SALARY := null; -- 9999 ben_pro_shd.g_old_rec.PROPOSED_SALARY;
276: --
277: l_new_rec.BUSINESS_GROUP_ID := p_rec.BUSINESS_GROUP_ID;
270: l_old_rec.ATTRIBUTE16 := per_pyp_shd.g_old_rec.ATTRIBUTE16;
271: l_old_rec.ATTRIBUTE17 := per_pyp_shd.g_old_rec.ATTRIBUTE17;
272: l_old_rec.ATTRIBUTE18 := per_pyp_shd.g_old_rec.ATTRIBUTE18;
273: l_old_rec.ATTRIBUTE19 := per_pyp_shd.g_old_rec.ATTRIBUTE19;
274: l_old_rec.ATTRIBUTE20 := per_pyp_shd.g_old_rec.ATTRIBUTE20;
275: l_old_rec.PROPOSED_SALARY := null; -- 9999 ben_pro_shd.g_old_rec.PROPOSED_SALARY;
276: --
277: l_new_rec.BUSINESS_GROUP_ID := p_rec.BUSINESS_GROUP_ID;
278: l_new_rec.PAY_PROPOSAL_ID := p_rec.PAY_PROPOSAL_ID;
313: l_new_rec.ATTRIBUTE20 := p_rec.ATTRIBUTE20;
314: l_new_rec.PROPOSED_SALARY := null; -- 9999 p_rec.PROPOSED_SALARY;
315: --
316: -- extract change events
317: l_ext_old_rec.BUSINESS_GROUP_ID := per_pyp_shd.g_old_rec.BUSINESS_GROUP_ID;
318: l_ext_old_rec.PAY_PROPOSAL_ID := per_pyp_shd.g_old_rec.PAY_PROPOSAL_ID;
319: l_ext_old_rec.ASSIGNMENT_ID := per_pyp_shd.g_old_rec.ASSIGNMENT_ID;
320: --l_ext_old_rec.EVENT_ID := per_pyp_shd.g_old_rec.EVENT_ID;
321: l_ext_old_rec.CHANGE_DATE := per_pyp_shd.g_old_rec.CHANGE_DATE;
314: l_new_rec.PROPOSED_SALARY := null; -- 9999 p_rec.PROPOSED_SALARY;
315: --
316: -- extract change events
317: l_ext_old_rec.BUSINESS_GROUP_ID := per_pyp_shd.g_old_rec.BUSINESS_GROUP_ID;
318: l_ext_old_rec.PAY_PROPOSAL_ID := per_pyp_shd.g_old_rec.PAY_PROPOSAL_ID;
319: l_ext_old_rec.ASSIGNMENT_ID := per_pyp_shd.g_old_rec.ASSIGNMENT_ID;
320: --l_ext_old_rec.EVENT_ID := per_pyp_shd.g_old_rec.EVENT_ID;
321: l_ext_old_rec.CHANGE_DATE := per_pyp_shd.g_old_rec.CHANGE_DATE;
322: l_ext_old_rec.LAST_CHANGE_DATE := per_pyp_shd.g_old_rec.LAST_CHANGE_DATE;
315: --
316: -- extract change events
317: l_ext_old_rec.BUSINESS_GROUP_ID := per_pyp_shd.g_old_rec.BUSINESS_GROUP_ID;
318: l_ext_old_rec.PAY_PROPOSAL_ID := per_pyp_shd.g_old_rec.PAY_PROPOSAL_ID;
319: l_ext_old_rec.ASSIGNMENT_ID := per_pyp_shd.g_old_rec.ASSIGNMENT_ID;
320: --l_ext_old_rec.EVENT_ID := per_pyp_shd.g_old_rec.EVENT_ID;
321: l_ext_old_rec.CHANGE_DATE := per_pyp_shd.g_old_rec.CHANGE_DATE;
322: l_ext_old_rec.LAST_CHANGE_DATE := per_pyp_shd.g_old_rec.LAST_CHANGE_DATE;
323: --l_ext_old_rec.NEXT_PERF_REVIEW_DATE := per_pyp_shd.g_old_rec.NEXT_PERF_REVIEW_DATE;
316: -- extract change events
317: l_ext_old_rec.BUSINESS_GROUP_ID := per_pyp_shd.g_old_rec.BUSINESS_GROUP_ID;
318: l_ext_old_rec.PAY_PROPOSAL_ID := per_pyp_shd.g_old_rec.PAY_PROPOSAL_ID;
319: l_ext_old_rec.ASSIGNMENT_ID := per_pyp_shd.g_old_rec.ASSIGNMENT_ID;
320: --l_ext_old_rec.EVENT_ID := per_pyp_shd.g_old_rec.EVENT_ID;
321: l_ext_old_rec.CHANGE_DATE := per_pyp_shd.g_old_rec.CHANGE_DATE;
322: l_ext_old_rec.LAST_CHANGE_DATE := per_pyp_shd.g_old_rec.LAST_CHANGE_DATE;
323: --l_ext_old_rec.NEXT_PERF_REVIEW_DATE := per_pyp_shd.g_old_rec.NEXT_PERF_REVIEW_DATE;
324: l_ext_old_rec.NEXT_SAL_REVIEW_DATE := per_pyp_shd.g_old_rec.NEXT_SAL_REVIEW_DATE;
317: l_ext_old_rec.BUSINESS_GROUP_ID := per_pyp_shd.g_old_rec.BUSINESS_GROUP_ID;
318: l_ext_old_rec.PAY_PROPOSAL_ID := per_pyp_shd.g_old_rec.PAY_PROPOSAL_ID;
319: l_ext_old_rec.ASSIGNMENT_ID := per_pyp_shd.g_old_rec.ASSIGNMENT_ID;
320: --l_ext_old_rec.EVENT_ID := per_pyp_shd.g_old_rec.EVENT_ID;
321: l_ext_old_rec.CHANGE_DATE := per_pyp_shd.g_old_rec.CHANGE_DATE;
322: l_ext_old_rec.LAST_CHANGE_DATE := per_pyp_shd.g_old_rec.LAST_CHANGE_DATE;
323: --l_ext_old_rec.NEXT_PERF_REVIEW_DATE := per_pyp_shd.g_old_rec.NEXT_PERF_REVIEW_DATE;
324: l_ext_old_rec.NEXT_SAL_REVIEW_DATE := per_pyp_shd.g_old_rec.NEXT_SAL_REVIEW_DATE;
325: --l_ext_old_rec.PERFORMANCE_RATING := per_pyp_shd.g_old_rec.PERFORMANCE_RATING;
318: l_ext_old_rec.PAY_PROPOSAL_ID := per_pyp_shd.g_old_rec.PAY_PROPOSAL_ID;
319: l_ext_old_rec.ASSIGNMENT_ID := per_pyp_shd.g_old_rec.ASSIGNMENT_ID;
320: --l_ext_old_rec.EVENT_ID := per_pyp_shd.g_old_rec.EVENT_ID;
321: l_ext_old_rec.CHANGE_DATE := per_pyp_shd.g_old_rec.CHANGE_DATE;
322: l_ext_old_rec.LAST_CHANGE_DATE := per_pyp_shd.g_old_rec.LAST_CHANGE_DATE;
323: --l_ext_old_rec.NEXT_PERF_REVIEW_DATE := per_pyp_shd.g_old_rec.NEXT_PERF_REVIEW_DATE;
324: l_ext_old_rec.NEXT_SAL_REVIEW_DATE := per_pyp_shd.g_old_rec.NEXT_SAL_REVIEW_DATE;
325: --l_ext_old_rec.PERFORMANCE_RATING := per_pyp_shd.g_old_rec.PERFORMANCE_RATING;
326: l_ext_old_rec.PROPOSAL_REASON := per_pyp_shd.g_old_rec.PROPOSAL_REASON;
319: l_ext_old_rec.ASSIGNMENT_ID := per_pyp_shd.g_old_rec.ASSIGNMENT_ID;
320: --l_ext_old_rec.EVENT_ID := per_pyp_shd.g_old_rec.EVENT_ID;
321: l_ext_old_rec.CHANGE_DATE := per_pyp_shd.g_old_rec.CHANGE_DATE;
322: l_ext_old_rec.LAST_CHANGE_DATE := per_pyp_shd.g_old_rec.LAST_CHANGE_DATE;
323: --l_ext_old_rec.NEXT_PERF_REVIEW_DATE := per_pyp_shd.g_old_rec.NEXT_PERF_REVIEW_DATE;
324: l_ext_old_rec.NEXT_SAL_REVIEW_DATE := per_pyp_shd.g_old_rec.NEXT_SAL_REVIEW_DATE;
325: --l_ext_old_rec.PERFORMANCE_RATING := per_pyp_shd.g_old_rec.PERFORMANCE_RATING;
326: l_ext_old_rec.PROPOSAL_REASON := per_pyp_shd.g_old_rec.PROPOSAL_REASON;
327:
320: --l_ext_old_rec.EVENT_ID := per_pyp_shd.g_old_rec.EVENT_ID;
321: l_ext_old_rec.CHANGE_DATE := per_pyp_shd.g_old_rec.CHANGE_DATE;
322: l_ext_old_rec.LAST_CHANGE_DATE := per_pyp_shd.g_old_rec.LAST_CHANGE_DATE;
323: --l_ext_old_rec.NEXT_PERF_REVIEW_DATE := per_pyp_shd.g_old_rec.NEXT_PERF_REVIEW_DATE;
324: l_ext_old_rec.NEXT_SAL_REVIEW_DATE := per_pyp_shd.g_old_rec.NEXT_SAL_REVIEW_DATE;
325: --l_ext_old_rec.PERFORMANCE_RATING := per_pyp_shd.g_old_rec.PERFORMANCE_RATING;
326: l_ext_old_rec.PROPOSAL_REASON := per_pyp_shd.g_old_rec.PROPOSAL_REASON;
327:
328: --vkodedal 6785012 EXTRACT BUG -old salary needs to be retrieved when proposal is approved
321: l_ext_old_rec.CHANGE_DATE := per_pyp_shd.g_old_rec.CHANGE_DATE;
322: l_ext_old_rec.LAST_CHANGE_DATE := per_pyp_shd.g_old_rec.LAST_CHANGE_DATE;
323: --l_ext_old_rec.NEXT_PERF_REVIEW_DATE := per_pyp_shd.g_old_rec.NEXT_PERF_REVIEW_DATE;
324: l_ext_old_rec.NEXT_SAL_REVIEW_DATE := per_pyp_shd.g_old_rec.NEXT_SAL_REVIEW_DATE;
325: --l_ext_old_rec.PERFORMANCE_RATING := per_pyp_shd.g_old_rec.PERFORMANCE_RATING;
326: l_ext_old_rec.PROPOSAL_REASON := per_pyp_shd.g_old_rec.PROPOSAL_REASON;
327:
328: --vkodedal 6785012 EXTRACT BUG -old salary needs to be retrieved when proposal is approved
329: if(l_old_rec.proposed_salary_n = p_rec.proposed_salary_n and
322: l_ext_old_rec.LAST_CHANGE_DATE := per_pyp_shd.g_old_rec.LAST_CHANGE_DATE;
323: --l_ext_old_rec.NEXT_PERF_REVIEW_DATE := per_pyp_shd.g_old_rec.NEXT_PERF_REVIEW_DATE;
324: l_ext_old_rec.NEXT_SAL_REVIEW_DATE := per_pyp_shd.g_old_rec.NEXT_SAL_REVIEW_DATE;
325: --l_ext_old_rec.PERFORMANCE_RATING := per_pyp_shd.g_old_rec.PERFORMANCE_RATING;
326: l_ext_old_rec.PROPOSAL_REASON := per_pyp_shd.g_old_rec.PROPOSAL_REASON;
327:
328: --vkodedal 6785012 EXTRACT BUG -old salary needs to be retrieved when proposal is approved
329: if(l_old_rec.proposed_salary_n = p_rec.proposed_salary_n and
330: l_old_rec.approved = 'N' and p_rec.approved = 'Y' and
341: then
342: l_ext_old_rec.PROPOSED_SALARY_N :=null;
343: end;
344: else
345: l_ext_old_rec.PROPOSED_SALARY_N := per_pyp_shd.g_old_rec.PROPOSED_SALARY_N;
346: end if;
347:
348: --l_ext_old_rec.REVIEW_DATE := per_pyp_shd.g_old_rec.REVIEW_DATE;
349: l_ext_old_rec.APPROVED := per_pyp_shd.g_old_rec.APPROVED;
344: else
345: l_ext_old_rec.PROPOSED_SALARY_N := per_pyp_shd.g_old_rec.PROPOSED_SALARY_N;
346: end if;
347:
348: --l_ext_old_rec.REVIEW_DATE := per_pyp_shd.g_old_rec.REVIEW_DATE;
349: l_ext_old_rec.APPROVED := per_pyp_shd.g_old_rec.APPROVED;
350: l_ext_old_rec.MULTIPLE_COMPONENTS := per_pyp_shd.g_old_rec.MULTIPLE_COMPONENTS;
351: l_ext_old_rec.FORCED_RANKING := per_pyp_shd.g_old_rec.FORCED_RANKING;
352: l_ext_old_rec.DATE_TO := per_pyp_shd.g_old_rec.DATE_TO;
345: l_ext_old_rec.PROPOSED_SALARY_N := per_pyp_shd.g_old_rec.PROPOSED_SALARY_N;
346: end if;
347:
348: --l_ext_old_rec.REVIEW_DATE := per_pyp_shd.g_old_rec.REVIEW_DATE;
349: l_ext_old_rec.APPROVED := per_pyp_shd.g_old_rec.APPROVED;
350: l_ext_old_rec.MULTIPLE_COMPONENTS := per_pyp_shd.g_old_rec.MULTIPLE_COMPONENTS;
351: l_ext_old_rec.FORCED_RANKING := per_pyp_shd.g_old_rec.FORCED_RANKING;
352: l_ext_old_rec.DATE_TO := per_pyp_shd.g_old_rec.DATE_TO;
353: l_ext_old_rec.PERFORMANCE_REVIEW_ID := per_pyp_shd.g_old_rec.PERFORMANCE_REVIEW_ID;
346: end if;
347:
348: --l_ext_old_rec.REVIEW_DATE := per_pyp_shd.g_old_rec.REVIEW_DATE;
349: l_ext_old_rec.APPROVED := per_pyp_shd.g_old_rec.APPROVED;
350: l_ext_old_rec.MULTIPLE_COMPONENTS := per_pyp_shd.g_old_rec.MULTIPLE_COMPONENTS;
351: l_ext_old_rec.FORCED_RANKING := per_pyp_shd.g_old_rec.FORCED_RANKING;
352: l_ext_old_rec.DATE_TO := per_pyp_shd.g_old_rec.DATE_TO;
353: l_ext_old_rec.PERFORMANCE_REVIEW_ID := per_pyp_shd.g_old_rec.PERFORMANCE_REVIEW_ID;
354: l_ext_old_rec.ATTRIBUTE1 := per_pyp_shd.g_old_rec.ATTRIBUTE1;
347:
348: --l_ext_old_rec.REVIEW_DATE := per_pyp_shd.g_old_rec.REVIEW_DATE;
349: l_ext_old_rec.APPROVED := per_pyp_shd.g_old_rec.APPROVED;
350: l_ext_old_rec.MULTIPLE_COMPONENTS := per_pyp_shd.g_old_rec.MULTIPLE_COMPONENTS;
351: l_ext_old_rec.FORCED_RANKING := per_pyp_shd.g_old_rec.FORCED_RANKING;
352: l_ext_old_rec.DATE_TO := per_pyp_shd.g_old_rec.DATE_TO;
353: l_ext_old_rec.PERFORMANCE_REVIEW_ID := per_pyp_shd.g_old_rec.PERFORMANCE_REVIEW_ID;
354: l_ext_old_rec.ATTRIBUTE1 := per_pyp_shd.g_old_rec.ATTRIBUTE1;
355: l_ext_old_rec.ATTRIBUTE2 := per_pyp_shd.g_old_rec.ATTRIBUTE2;
348: --l_ext_old_rec.REVIEW_DATE := per_pyp_shd.g_old_rec.REVIEW_DATE;
349: l_ext_old_rec.APPROVED := per_pyp_shd.g_old_rec.APPROVED;
350: l_ext_old_rec.MULTIPLE_COMPONENTS := per_pyp_shd.g_old_rec.MULTIPLE_COMPONENTS;
351: l_ext_old_rec.FORCED_RANKING := per_pyp_shd.g_old_rec.FORCED_RANKING;
352: l_ext_old_rec.DATE_TO := per_pyp_shd.g_old_rec.DATE_TO;
353: l_ext_old_rec.PERFORMANCE_REVIEW_ID := per_pyp_shd.g_old_rec.PERFORMANCE_REVIEW_ID;
354: l_ext_old_rec.ATTRIBUTE1 := per_pyp_shd.g_old_rec.ATTRIBUTE1;
355: l_ext_old_rec.ATTRIBUTE2 := per_pyp_shd.g_old_rec.ATTRIBUTE2;
356: l_ext_old_rec.ATTRIBUTE3 := per_pyp_shd.g_old_rec.ATTRIBUTE3;
349: l_ext_old_rec.APPROVED := per_pyp_shd.g_old_rec.APPROVED;
350: l_ext_old_rec.MULTIPLE_COMPONENTS := per_pyp_shd.g_old_rec.MULTIPLE_COMPONENTS;
351: l_ext_old_rec.FORCED_RANKING := per_pyp_shd.g_old_rec.FORCED_RANKING;
352: l_ext_old_rec.DATE_TO := per_pyp_shd.g_old_rec.DATE_TO;
353: l_ext_old_rec.PERFORMANCE_REVIEW_ID := per_pyp_shd.g_old_rec.PERFORMANCE_REVIEW_ID;
354: l_ext_old_rec.ATTRIBUTE1 := per_pyp_shd.g_old_rec.ATTRIBUTE1;
355: l_ext_old_rec.ATTRIBUTE2 := per_pyp_shd.g_old_rec.ATTRIBUTE2;
356: l_ext_old_rec.ATTRIBUTE3 := per_pyp_shd.g_old_rec.ATTRIBUTE3;
357: l_ext_old_rec.ATTRIBUTE4 := per_pyp_shd.g_old_rec.ATTRIBUTE4;
350: l_ext_old_rec.MULTIPLE_COMPONENTS := per_pyp_shd.g_old_rec.MULTIPLE_COMPONENTS;
351: l_ext_old_rec.FORCED_RANKING := per_pyp_shd.g_old_rec.FORCED_RANKING;
352: l_ext_old_rec.DATE_TO := per_pyp_shd.g_old_rec.DATE_TO;
353: l_ext_old_rec.PERFORMANCE_REVIEW_ID := per_pyp_shd.g_old_rec.PERFORMANCE_REVIEW_ID;
354: l_ext_old_rec.ATTRIBUTE1 := per_pyp_shd.g_old_rec.ATTRIBUTE1;
355: l_ext_old_rec.ATTRIBUTE2 := per_pyp_shd.g_old_rec.ATTRIBUTE2;
356: l_ext_old_rec.ATTRIBUTE3 := per_pyp_shd.g_old_rec.ATTRIBUTE3;
357: l_ext_old_rec.ATTRIBUTE4 := per_pyp_shd.g_old_rec.ATTRIBUTE4;
358: l_ext_old_rec.ATTRIBUTE5 := per_pyp_shd.g_old_rec.ATTRIBUTE5;
351: l_ext_old_rec.FORCED_RANKING := per_pyp_shd.g_old_rec.FORCED_RANKING;
352: l_ext_old_rec.DATE_TO := per_pyp_shd.g_old_rec.DATE_TO;
353: l_ext_old_rec.PERFORMANCE_REVIEW_ID := per_pyp_shd.g_old_rec.PERFORMANCE_REVIEW_ID;
354: l_ext_old_rec.ATTRIBUTE1 := per_pyp_shd.g_old_rec.ATTRIBUTE1;
355: l_ext_old_rec.ATTRIBUTE2 := per_pyp_shd.g_old_rec.ATTRIBUTE2;
356: l_ext_old_rec.ATTRIBUTE3 := per_pyp_shd.g_old_rec.ATTRIBUTE3;
357: l_ext_old_rec.ATTRIBUTE4 := per_pyp_shd.g_old_rec.ATTRIBUTE4;
358: l_ext_old_rec.ATTRIBUTE5 := per_pyp_shd.g_old_rec.ATTRIBUTE5;
359: l_ext_old_rec.ATTRIBUTE6 := per_pyp_shd.g_old_rec.ATTRIBUTE6;
352: l_ext_old_rec.DATE_TO := per_pyp_shd.g_old_rec.DATE_TO;
353: l_ext_old_rec.PERFORMANCE_REVIEW_ID := per_pyp_shd.g_old_rec.PERFORMANCE_REVIEW_ID;
354: l_ext_old_rec.ATTRIBUTE1 := per_pyp_shd.g_old_rec.ATTRIBUTE1;
355: l_ext_old_rec.ATTRIBUTE2 := per_pyp_shd.g_old_rec.ATTRIBUTE2;
356: l_ext_old_rec.ATTRIBUTE3 := per_pyp_shd.g_old_rec.ATTRIBUTE3;
357: l_ext_old_rec.ATTRIBUTE4 := per_pyp_shd.g_old_rec.ATTRIBUTE4;
358: l_ext_old_rec.ATTRIBUTE5 := per_pyp_shd.g_old_rec.ATTRIBUTE5;
359: l_ext_old_rec.ATTRIBUTE6 := per_pyp_shd.g_old_rec.ATTRIBUTE6;
360: l_ext_old_rec.ATTRIBUTE7 := per_pyp_shd.g_old_rec.ATTRIBUTE7;
353: l_ext_old_rec.PERFORMANCE_REVIEW_ID := per_pyp_shd.g_old_rec.PERFORMANCE_REVIEW_ID;
354: l_ext_old_rec.ATTRIBUTE1 := per_pyp_shd.g_old_rec.ATTRIBUTE1;
355: l_ext_old_rec.ATTRIBUTE2 := per_pyp_shd.g_old_rec.ATTRIBUTE2;
356: l_ext_old_rec.ATTRIBUTE3 := per_pyp_shd.g_old_rec.ATTRIBUTE3;
357: l_ext_old_rec.ATTRIBUTE4 := per_pyp_shd.g_old_rec.ATTRIBUTE4;
358: l_ext_old_rec.ATTRIBUTE5 := per_pyp_shd.g_old_rec.ATTRIBUTE5;
359: l_ext_old_rec.ATTRIBUTE6 := per_pyp_shd.g_old_rec.ATTRIBUTE6;
360: l_ext_old_rec.ATTRIBUTE7 := per_pyp_shd.g_old_rec.ATTRIBUTE7;
361: l_ext_old_rec.ATTRIBUTE8 := per_pyp_shd.g_old_rec.ATTRIBUTE8;
354: l_ext_old_rec.ATTRIBUTE1 := per_pyp_shd.g_old_rec.ATTRIBUTE1;
355: l_ext_old_rec.ATTRIBUTE2 := per_pyp_shd.g_old_rec.ATTRIBUTE2;
356: l_ext_old_rec.ATTRIBUTE3 := per_pyp_shd.g_old_rec.ATTRIBUTE3;
357: l_ext_old_rec.ATTRIBUTE4 := per_pyp_shd.g_old_rec.ATTRIBUTE4;
358: l_ext_old_rec.ATTRIBUTE5 := per_pyp_shd.g_old_rec.ATTRIBUTE5;
359: l_ext_old_rec.ATTRIBUTE6 := per_pyp_shd.g_old_rec.ATTRIBUTE6;
360: l_ext_old_rec.ATTRIBUTE7 := per_pyp_shd.g_old_rec.ATTRIBUTE7;
361: l_ext_old_rec.ATTRIBUTE8 := per_pyp_shd.g_old_rec.ATTRIBUTE8;
362: l_ext_old_rec.ATTRIBUTE9 := per_pyp_shd.g_old_rec.ATTRIBUTE9;
355: l_ext_old_rec.ATTRIBUTE2 := per_pyp_shd.g_old_rec.ATTRIBUTE2;
356: l_ext_old_rec.ATTRIBUTE3 := per_pyp_shd.g_old_rec.ATTRIBUTE3;
357: l_ext_old_rec.ATTRIBUTE4 := per_pyp_shd.g_old_rec.ATTRIBUTE4;
358: l_ext_old_rec.ATTRIBUTE5 := per_pyp_shd.g_old_rec.ATTRIBUTE5;
359: l_ext_old_rec.ATTRIBUTE6 := per_pyp_shd.g_old_rec.ATTRIBUTE6;
360: l_ext_old_rec.ATTRIBUTE7 := per_pyp_shd.g_old_rec.ATTRIBUTE7;
361: l_ext_old_rec.ATTRIBUTE8 := per_pyp_shd.g_old_rec.ATTRIBUTE8;
362: l_ext_old_rec.ATTRIBUTE9 := per_pyp_shd.g_old_rec.ATTRIBUTE9;
363: l_ext_old_rec.ATTRIBUTE10 := per_pyp_shd.g_old_rec.ATTRIBUTE10;
356: l_ext_old_rec.ATTRIBUTE3 := per_pyp_shd.g_old_rec.ATTRIBUTE3;
357: l_ext_old_rec.ATTRIBUTE4 := per_pyp_shd.g_old_rec.ATTRIBUTE4;
358: l_ext_old_rec.ATTRIBUTE5 := per_pyp_shd.g_old_rec.ATTRIBUTE5;
359: l_ext_old_rec.ATTRIBUTE6 := per_pyp_shd.g_old_rec.ATTRIBUTE6;
360: l_ext_old_rec.ATTRIBUTE7 := per_pyp_shd.g_old_rec.ATTRIBUTE7;
361: l_ext_old_rec.ATTRIBUTE8 := per_pyp_shd.g_old_rec.ATTRIBUTE8;
362: l_ext_old_rec.ATTRIBUTE9 := per_pyp_shd.g_old_rec.ATTRIBUTE9;
363: l_ext_old_rec.ATTRIBUTE10 := per_pyp_shd.g_old_rec.ATTRIBUTE10;
364: l_ext_old_rec.ATTRIBUTE11 := per_pyp_shd.g_old_rec.ATTRIBUTE11;
357: l_ext_old_rec.ATTRIBUTE4 := per_pyp_shd.g_old_rec.ATTRIBUTE4;
358: l_ext_old_rec.ATTRIBUTE5 := per_pyp_shd.g_old_rec.ATTRIBUTE5;
359: l_ext_old_rec.ATTRIBUTE6 := per_pyp_shd.g_old_rec.ATTRIBUTE6;
360: l_ext_old_rec.ATTRIBUTE7 := per_pyp_shd.g_old_rec.ATTRIBUTE7;
361: l_ext_old_rec.ATTRIBUTE8 := per_pyp_shd.g_old_rec.ATTRIBUTE8;
362: l_ext_old_rec.ATTRIBUTE9 := per_pyp_shd.g_old_rec.ATTRIBUTE9;
363: l_ext_old_rec.ATTRIBUTE10 := per_pyp_shd.g_old_rec.ATTRIBUTE10;
364: l_ext_old_rec.ATTRIBUTE11 := per_pyp_shd.g_old_rec.ATTRIBUTE11;
365: l_ext_old_rec.ATTRIBUTE12 := per_pyp_shd.g_old_rec.ATTRIBUTE12;
358: l_ext_old_rec.ATTRIBUTE5 := per_pyp_shd.g_old_rec.ATTRIBUTE5;
359: l_ext_old_rec.ATTRIBUTE6 := per_pyp_shd.g_old_rec.ATTRIBUTE6;
360: l_ext_old_rec.ATTRIBUTE7 := per_pyp_shd.g_old_rec.ATTRIBUTE7;
361: l_ext_old_rec.ATTRIBUTE8 := per_pyp_shd.g_old_rec.ATTRIBUTE8;
362: l_ext_old_rec.ATTRIBUTE9 := per_pyp_shd.g_old_rec.ATTRIBUTE9;
363: l_ext_old_rec.ATTRIBUTE10 := per_pyp_shd.g_old_rec.ATTRIBUTE10;
364: l_ext_old_rec.ATTRIBUTE11 := per_pyp_shd.g_old_rec.ATTRIBUTE11;
365: l_ext_old_rec.ATTRIBUTE12 := per_pyp_shd.g_old_rec.ATTRIBUTE12;
366: l_ext_old_rec.ATTRIBUTE13 := per_pyp_shd.g_old_rec.ATTRIBUTE13;
359: l_ext_old_rec.ATTRIBUTE6 := per_pyp_shd.g_old_rec.ATTRIBUTE6;
360: l_ext_old_rec.ATTRIBUTE7 := per_pyp_shd.g_old_rec.ATTRIBUTE7;
361: l_ext_old_rec.ATTRIBUTE8 := per_pyp_shd.g_old_rec.ATTRIBUTE8;
362: l_ext_old_rec.ATTRIBUTE9 := per_pyp_shd.g_old_rec.ATTRIBUTE9;
363: l_ext_old_rec.ATTRIBUTE10 := per_pyp_shd.g_old_rec.ATTRIBUTE10;
364: l_ext_old_rec.ATTRIBUTE11 := per_pyp_shd.g_old_rec.ATTRIBUTE11;
365: l_ext_old_rec.ATTRIBUTE12 := per_pyp_shd.g_old_rec.ATTRIBUTE12;
366: l_ext_old_rec.ATTRIBUTE13 := per_pyp_shd.g_old_rec.ATTRIBUTE13;
367: l_ext_old_rec.ATTRIBUTE14 := per_pyp_shd.g_old_rec.ATTRIBUTE14;
360: l_ext_old_rec.ATTRIBUTE7 := per_pyp_shd.g_old_rec.ATTRIBUTE7;
361: l_ext_old_rec.ATTRIBUTE8 := per_pyp_shd.g_old_rec.ATTRIBUTE8;
362: l_ext_old_rec.ATTRIBUTE9 := per_pyp_shd.g_old_rec.ATTRIBUTE9;
363: l_ext_old_rec.ATTRIBUTE10 := per_pyp_shd.g_old_rec.ATTRIBUTE10;
364: l_ext_old_rec.ATTRIBUTE11 := per_pyp_shd.g_old_rec.ATTRIBUTE11;
365: l_ext_old_rec.ATTRIBUTE12 := per_pyp_shd.g_old_rec.ATTRIBUTE12;
366: l_ext_old_rec.ATTRIBUTE13 := per_pyp_shd.g_old_rec.ATTRIBUTE13;
367: l_ext_old_rec.ATTRIBUTE14 := per_pyp_shd.g_old_rec.ATTRIBUTE14;
368: l_ext_old_rec.ATTRIBUTE15 := per_pyp_shd.g_old_rec.ATTRIBUTE15;
361: l_ext_old_rec.ATTRIBUTE8 := per_pyp_shd.g_old_rec.ATTRIBUTE8;
362: l_ext_old_rec.ATTRIBUTE9 := per_pyp_shd.g_old_rec.ATTRIBUTE9;
363: l_ext_old_rec.ATTRIBUTE10 := per_pyp_shd.g_old_rec.ATTRIBUTE10;
364: l_ext_old_rec.ATTRIBUTE11 := per_pyp_shd.g_old_rec.ATTRIBUTE11;
365: l_ext_old_rec.ATTRIBUTE12 := per_pyp_shd.g_old_rec.ATTRIBUTE12;
366: l_ext_old_rec.ATTRIBUTE13 := per_pyp_shd.g_old_rec.ATTRIBUTE13;
367: l_ext_old_rec.ATTRIBUTE14 := per_pyp_shd.g_old_rec.ATTRIBUTE14;
368: l_ext_old_rec.ATTRIBUTE15 := per_pyp_shd.g_old_rec.ATTRIBUTE15;
369: l_ext_old_rec.ATTRIBUTE16 := per_pyp_shd.g_old_rec.ATTRIBUTE16;
362: l_ext_old_rec.ATTRIBUTE9 := per_pyp_shd.g_old_rec.ATTRIBUTE9;
363: l_ext_old_rec.ATTRIBUTE10 := per_pyp_shd.g_old_rec.ATTRIBUTE10;
364: l_ext_old_rec.ATTRIBUTE11 := per_pyp_shd.g_old_rec.ATTRIBUTE11;
365: l_ext_old_rec.ATTRIBUTE12 := per_pyp_shd.g_old_rec.ATTRIBUTE12;
366: l_ext_old_rec.ATTRIBUTE13 := per_pyp_shd.g_old_rec.ATTRIBUTE13;
367: l_ext_old_rec.ATTRIBUTE14 := per_pyp_shd.g_old_rec.ATTRIBUTE14;
368: l_ext_old_rec.ATTRIBUTE15 := per_pyp_shd.g_old_rec.ATTRIBUTE15;
369: l_ext_old_rec.ATTRIBUTE16 := per_pyp_shd.g_old_rec.ATTRIBUTE16;
370: l_ext_old_rec.ATTRIBUTE17 := per_pyp_shd.g_old_rec.ATTRIBUTE17;
363: l_ext_old_rec.ATTRIBUTE10 := per_pyp_shd.g_old_rec.ATTRIBUTE10;
364: l_ext_old_rec.ATTRIBUTE11 := per_pyp_shd.g_old_rec.ATTRIBUTE11;
365: l_ext_old_rec.ATTRIBUTE12 := per_pyp_shd.g_old_rec.ATTRIBUTE12;
366: l_ext_old_rec.ATTRIBUTE13 := per_pyp_shd.g_old_rec.ATTRIBUTE13;
367: l_ext_old_rec.ATTRIBUTE14 := per_pyp_shd.g_old_rec.ATTRIBUTE14;
368: l_ext_old_rec.ATTRIBUTE15 := per_pyp_shd.g_old_rec.ATTRIBUTE15;
369: l_ext_old_rec.ATTRIBUTE16 := per_pyp_shd.g_old_rec.ATTRIBUTE16;
370: l_ext_old_rec.ATTRIBUTE17 := per_pyp_shd.g_old_rec.ATTRIBUTE17;
371: l_ext_old_rec.ATTRIBUTE18 := per_pyp_shd.g_old_rec.ATTRIBUTE18;
364: l_ext_old_rec.ATTRIBUTE11 := per_pyp_shd.g_old_rec.ATTRIBUTE11;
365: l_ext_old_rec.ATTRIBUTE12 := per_pyp_shd.g_old_rec.ATTRIBUTE12;
366: l_ext_old_rec.ATTRIBUTE13 := per_pyp_shd.g_old_rec.ATTRIBUTE13;
367: l_ext_old_rec.ATTRIBUTE14 := per_pyp_shd.g_old_rec.ATTRIBUTE14;
368: l_ext_old_rec.ATTRIBUTE15 := per_pyp_shd.g_old_rec.ATTRIBUTE15;
369: l_ext_old_rec.ATTRIBUTE16 := per_pyp_shd.g_old_rec.ATTRIBUTE16;
370: l_ext_old_rec.ATTRIBUTE17 := per_pyp_shd.g_old_rec.ATTRIBUTE17;
371: l_ext_old_rec.ATTRIBUTE18 := per_pyp_shd.g_old_rec.ATTRIBUTE18;
372: l_ext_old_rec.ATTRIBUTE19 := per_pyp_shd.g_old_rec.ATTRIBUTE19;
365: l_ext_old_rec.ATTRIBUTE12 := per_pyp_shd.g_old_rec.ATTRIBUTE12;
366: l_ext_old_rec.ATTRIBUTE13 := per_pyp_shd.g_old_rec.ATTRIBUTE13;
367: l_ext_old_rec.ATTRIBUTE14 := per_pyp_shd.g_old_rec.ATTRIBUTE14;
368: l_ext_old_rec.ATTRIBUTE15 := per_pyp_shd.g_old_rec.ATTRIBUTE15;
369: l_ext_old_rec.ATTRIBUTE16 := per_pyp_shd.g_old_rec.ATTRIBUTE16;
370: l_ext_old_rec.ATTRIBUTE17 := per_pyp_shd.g_old_rec.ATTRIBUTE17;
371: l_ext_old_rec.ATTRIBUTE18 := per_pyp_shd.g_old_rec.ATTRIBUTE18;
372: l_ext_old_rec.ATTRIBUTE19 := per_pyp_shd.g_old_rec.ATTRIBUTE19;
373: l_ext_old_rec.ATTRIBUTE20 := per_pyp_shd.g_old_rec.ATTRIBUTE20;
366: l_ext_old_rec.ATTRIBUTE13 := per_pyp_shd.g_old_rec.ATTRIBUTE13;
367: l_ext_old_rec.ATTRIBUTE14 := per_pyp_shd.g_old_rec.ATTRIBUTE14;
368: l_ext_old_rec.ATTRIBUTE15 := per_pyp_shd.g_old_rec.ATTRIBUTE15;
369: l_ext_old_rec.ATTRIBUTE16 := per_pyp_shd.g_old_rec.ATTRIBUTE16;
370: l_ext_old_rec.ATTRIBUTE17 := per_pyp_shd.g_old_rec.ATTRIBUTE17;
371: l_ext_old_rec.ATTRIBUTE18 := per_pyp_shd.g_old_rec.ATTRIBUTE18;
372: l_ext_old_rec.ATTRIBUTE19 := per_pyp_shd.g_old_rec.ATTRIBUTE19;
373: l_ext_old_rec.ATTRIBUTE20 := per_pyp_shd.g_old_rec.ATTRIBUTE20;
374: --l_ext_old_rec.PROPOSED_SALARY := per_pro_shd.g_old_rec.PROPOSED_SALARY;
367: l_ext_old_rec.ATTRIBUTE14 := per_pyp_shd.g_old_rec.ATTRIBUTE14;
368: l_ext_old_rec.ATTRIBUTE15 := per_pyp_shd.g_old_rec.ATTRIBUTE15;
369: l_ext_old_rec.ATTRIBUTE16 := per_pyp_shd.g_old_rec.ATTRIBUTE16;
370: l_ext_old_rec.ATTRIBUTE17 := per_pyp_shd.g_old_rec.ATTRIBUTE17;
371: l_ext_old_rec.ATTRIBUTE18 := per_pyp_shd.g_old_rec.ATTRIBUTE18;
372: l_ext_old_rec.ATTRIBUTE19 := per_pyp_shd.g_old_rec.ATTRIBUTE19;
373: l_ext_old_rec.ATTRIBUTE20 := per_pyp_shd.g_old_rec.ATTRIBUTE20;
374: --l_ext_old_rec.PROPOSED_SALARY := per_pro_shd.g_old_rec.PROPOSED_SALARY;
375:
368: l_ext_old_rec.ATTRIBUTE15 := per_pyp_shd.g_old_rec.ATTRIBUTE15;
369: l_ext_old_rec.ATTRIBUTE16 := per_pyp_shd.g_old_rec.ATTRIBUTE16;
370: l_ext_old_rec.ATTRIBUTE17 := per_pyp_shd.g_old_rec.ATTRIBUTE17;
371: l_ext_old_rec.ATTRIBUTE18 := per_pyp_shd.g_old_rec.ATTRIBUTE18;
372: l_ext_old_rec.ATTRIBUTE19 := per_pyp_shd.g_old_rec.ATTRIBUTE19;
373: l_ext_old_rec.ATTRIBUTE20 := per_pyp_shd.g_old_rec.ATTRIBUTE20;
374: --l_ext_old_rec.PROPOSED_SALARY := per_pro_shd.g_old_rec.PROPOSED_SALARY;
375:
376: l_ext_new_rec.BUSINESS_GROUP_ID := p_rec.BUSINESS_GROUP_ID;
369: l_ext_old_rec.ATTRIBUTE16 := per_pyp_shd.g_old_rec.ATTRIBUTE16;
370: l_ext_old_rec.ATTRIBUTE17 := per_pyp_shd.g_old_rec.ATTRIBUTE17;
371: l_ext_old_rec.ATTRIBUTE18 := per_pyp_shd.g_old_rec.ATTRIBUTE18;
372: l_ext_old_rec.ATTRIBUTE19 := per_pyp_shd.g_old_rec.ATTRIBUTE19;
373: l_ext_old_rec.ATTRIBUTE20 := per_pyp_shd.g_old_rec.ATTRIBUTE20;
374: --l_ext_old_rec.PROPOSED_SALARY := per_pro_shd.g_old_rec.PROPOSED_SALARY;
375:
376: l_ext_new_rec.BUSINESS_GROUP_ID := p_rec.BUSINESS_GROUP_ID;
377: l_ext_new_rec.PAY_PROPOSAL_ID := p_rec.PAY_PROPOSAL_ID;
460: p_inv_next_sal_date_warning => p_inv_next_sal_date_warning,
461: p_proposed_salary_warning => p_proposed_salary_warning,
462: p_approved_warning => p_approved_warning,
463: p_payroll_warning => p_payroll_warning,
464: p_assignment_id_o => per_pyp_shd.g_old_rec.assignment_id,
465: p_business_group_id_o => per_pyp_shd.g_old_rec.business_group_id,
466: p_change_date_o => per_pyp_shd.g_old_rec.change_date,
467: p_comments_o => per_pyp_shd.g_old_rec.comments,
468: p_next_sal_review_date_o => per_pyp_shd.g_old_rec.next_sal_review_date,
461: p_proposed_salary_warning => p_proposed_salary_warning,
462: p_approved_warning => p_approved_warning,
463: p_payroll_warning => p_payroll_warning,
464: p_assignment_id_o => per_pyp_shd.g_old_rec.assignment_id,
465: p_business_group_id_o => per_pyp_shd.g_old_rec.business_group_id,
466: p_change_date_o => per_pyp_shd.g_old_rec.change_date,
467: p_comments_o => per_pyp_shd.g_old_rec.comments,
468: p_next_sal_review_date_o => per_pyp_shd.g_old_rec.next_sal_review_date,
469: p_proposal_reason_o => per_pyp_shd.g_old_rec.proposal_reason,
462: p_approved_warning => p_approved_warning,
463: p_payroll_warning => p_payroll_warning,
464: p_assignment_id_o => per_pyp_shd.g_old_rec.assignment_id,
465: p_business_group_id_o => per_pyp_shd.g_old_rec.business_group_id,
466: p_change_date_o => per_pyp_shd.g_old_rec.change_date,
467: p_comments_o => per_pyp_shd.g_old_rec.comments,
468: p_next_sal_review_date_o => per_pyp_shd.g_old_rec.next_sal_review_date,
469: p_proposal_reason_o => per_pyp_shd.g_old_rec.proposal_reason,
470: p_proposed_salary_n_o => per_pyp_shd.g_old_rec.proposed_salary_n,
463: p_payroll_warning => p_payroll_warning,
464: p_assignment_id_o => per_pyp_shd.g_old_rec.assignment_id,
465: p_business_group_id_o => per_pyp_shd.g_old_rec.business_group_id,
466: p_change_date_o => per_pyp_shd.g_old_rec.change_date,
467: p_comments_o => per_pyp_shd.g_old_rec.comments,
468: p_next_sal_review_date_o => per_pyp_shd.g_old_rec.next_sal_review_date,
469: p_proposal_reason_o => per_pyp_shd.g_old_rec.proposal_reason,
470: p_proposed_salary_n_o => per_pyp_shd.g_old_rec.proposed_salary_n,
471: p_forced_ranking_o => per_pyp_shd.g_old_rec.forced_ranking,
464: p_assignment_id_o => per_pyp_shd.g_old_rec.assignment_id,
465: p_business_group_id_o => per_pyp_shd.g_old_rec.business_group_id,
466: p_change_date_o => per_pyp_shd.g_old_rec.change_date,
467: p_comments_o => per_pyp_shd.g_old_rec.comments,
468: p_next_sal_review_date_o => per_pyp_shd.g_old_rec.next_sal_review_date,
469: p_proposal_reason_o => per_pyp_shd.g_old_rec.proposal_reason,
470: p_proposed_salary_n_o => per_pyp_shd.g_old_rec.proposed_salary_n,
471: p_forced_ranking_o => per_pyp_shd.g_old_rec.forced_ranking,
472: p_date_to_o => per_pyp_shd.g_old_rec.date_to,
465: p_business_group_id_o => per_pyp_shd.g_old_rec.business_group_id,
466: p_change_date_o => per_pyp_shd.g_old_rec.change_date,
467: p_comments_o => per_pyp_shd.g_old_rec.comments,
468: p_next_sal_review_date_o => per_pyp_shd.g_old_rec.next_sal_review_date,
469: p_proposal_reason_o => per_pyp_shd.g_old_rec.proposal_reason,
470: p_proposed_salary_n_o => per_pyp_shd.g_old_rec.proposed_salary_n,
471: p_forced_ranking_o => per_pyp_shd.g_old_rec.forced_ranking,
472: p_date_to_o => per_pyp_shd.g_old_rec.date_to,
473: p_performance_review_id_o => per_pyp_shd.g_old_rec.performance_review_id,
466: p_change_date_o => per_pyp_shd.g_old_rec.change_date,
467: p_comments_o => per_pyp_shd.g_old_rec.comments,
468: p_next_sal_review_date_o => per_pyp_shd.g_old_rec.next_sal_review_date,
469: p_proposal_reason_o => per_pyp_shd.g_old_rec.proposal_reason,
470: p_proposed_salary_n_o => per_pyp_shd.g_old_rec.proposed_salary_n,
471: p_forced_ranking_o => per_pyp_shd.g_old_rec.forced_ranking,
472: p_date_to_o => per_pyp_shd.g_old_rec.date_to,
473: p_performance_review_id_o => per_pyp_shd.g_old_rec.performance_review_id,
474: p_attribute_category_o => per_pyp_shd.g_old_rec.attribute_category,
467: p_comments_o => per_pyp_shd.g_old_rec.comments,
468: p_next_sal_review_date_o => per_pyp_shd.g_old_rec.next_sal_review_date,
469: p_proposal_reason_o => per_pyp_shd.g_old_rec.proposal_reason,
470: p_proposed_salary_n_o => per_pyp_shd.g_old_rec.proposed_salary_n,
471: p_forced_ranking_o => per_pyp_shd.g_old_rec.forced_ranking,
472: p_date_to_o => per_pyp_shd.g_old_rec.date_to,
473: p_performance_review_id_o => per_pyp_shd.g_old_rec.performance_review_id,
474: p_attribute_category_o => per_pyp_shd.g_old_rec.attribute_category,
475: p_attribute1_o => per_pyp_shd.g_old_rec.attribute1,
468: p_next_sal_review_date_o => per_pyp_shd.g_old_rec.next_sal_review_date,
469: p_proposal_reason_o => per_pyp_shd.g_old_rec.proposal_reason,
470: p_proposed_salary_n_o => per_pyp_shd.g_old_rec.proposed_salary_n,
471: p_forced_ranking_o => per_pyp_shd.g_old_rec.forced_ranking,
472: p_date_to_o => per_pyp_shd.g_old_rec.date_to,
473: p_performance_review_id_o => per_pyp_shd.g_old_rec.performance_review_id,
474: p_attribute_category_o => per_pyp_shd.g_old_rec.attribute_category,
475: p_attribute1_o => per_pyp_shd.g_old_rec.attribute1,
476: p_attribute2_o => per_pyp_shd.g_old_rec.attribute2,
469: p_proposal_reason_o => per_pyp_shd.g_old_rec.proposal_reason,
470: p_proposed_salary_n_o => per_pyp_shd.g_old_rec.proposed_salary_n,
471: p_forced_ranking_o => per_pyp_shd.g_old_rec.forced_ranking,
472: p_date_to_o => per_pyp_shd.g_old_rec.date_to,
473: p_performance_review_id_o => per_pyp_shd.g_old_rec.performance_review_id,
474: p_attribute_category_o => per_pyp_shd.g_old_rec.attribute_category,
475: p_attribute1_o => per_pyp_shd.g_old_rec.attribute1,
476: p_attribute2_o => per_pyp_shd.g_old_rec.attribute2,
477: p_attribute3_o => per_pyp_shd.g_old_rec.attribute3,
470: p_proposed_salary_n_o => per_pyp_shd.g_old_rec.proposed_salary_n,
471: p_forced_ranking_o => per_pyp_shd.g_old_rec.forced_ranking,
472: p_date_to_o => per_pyp_shd.g_old_rec.date_to,
473: p_performance_review_id_o => per_pyp_shd.g_old_rec.performance_review_id,
474: p_attribute_category_o => per_pyp_shd.g_old_rec.attribute_category,
475: p_attribute1_o => per_pyp_shd.g_old_rec.attribute1,
476: p_attribute2_o => per_pyp_shd.g_old_rec.attribute2,
477: p_attribute3_o => per_pyp_shd.g_old_rec.attribute3,
478: p_attribute4_o => per_pyp_shd.g_old_rec.attribute4,
471: p_forced_ranking_o => per_pyp_shd.g_old_rec.forced_ranking,
472: p_date_to_o => per_pyp_shd.g_old_rec.date_to,
473: p_performance_review_id_o => per_pyp_shd.g_old_rec.performance_review_id,
474: p_attribute_category_o => per_pyp_shd.g_old_rec.attribute_category,
475: p_attribute1_o => per_pyp_shd.g_old_rec.attribute1,
476: p_attribute2_o => per_pyp_shd.g_old_rec.attribute2,
477: p_attribute3_o => per_pyp_shd.g_old_rec.attribute3,
478: p_attribute4_o => per_pyp_shd.g_old_rec.attribute4,
479: p_attribute5_o => per_pyp_shd.g_old_rec.attribute5,
472: p_date_to_o => per_pyp_shd.g_old_rec.date_to,
473: p_performance_review_id_o => per_pyp_shd.g_old_rec.performance_review_id,
474: p_attribute_category_o => per_pyp_shd.g_old_rec.attribute_category,
475: p_attribute1_o => per_pyp_shd.g_old_rec.attribute1,
476: p_attribute2_o => per_pyp_shd.g_old_rec.attribute2,
477: p_attribute3_o => per_pyp_shd.g_old_rec.attribute3,
478: p_attribute4_o => per_pyp_shd.g_old_rec.attribute4,
479: p_attribute5_o => per_pyp_shd.g_old_rec.attribute5,
480: p_attribute6_o => per_pyp_shd.g_old_rec.attribute6,
473: p_performance_review_id_o => per_pyp_shd.g_old_rec.performance_review_id,
474: p_attribute_category_o => per_pyp_shd.g_old_rec.attribute_category,
475: p_attribute1_o => per_pyp_shd.g_old_rec.attribute1,
476: p_attribute2_o => per_pyp_shd.g_old_rec.attribute2,
477: p_attribute3_o => per_pyp_shd.g_old_rec.attribute3,
478: p_attribute4_o => per_pyp_shd.g_old_rec.attribute4,
479: p_attribute5_o => per_pyp_shd.g_old_rec.attribute5,
480: p_attribute6_o => per_pyp_shd.g_old_rec.attribute6,
481: p_attribute7_o => per_pyp_shd.g_old_rec.attribute7,
474: p_attribute_category_o => per_pyp_shd.g_old_rec.attribute_category,
475: p_attribute1_o => per_pyp_shd.g_old_rec.attribute1,
476: p_attribute2_o => per_pyp_shd.g_old_rec.attribute2,
477: p_attribute3_o => per_pyp_shd.g_old_rec.attribute3,
478: p_attribute4_o => per_pyp_shd.g_old_rec.attribute4,
479: p_attribute5_o => per_pyp_shd.g_old_rec.attribute5,
480: p_attribute6_o => per_pyp_shd.g_old_rec.attribute6,
481: p_attribute7_o => per_pyp_shd.g_old_rec.attribute7,
482: p_attribute8_o => per_pyp_shd.g_old_rec.attribute8,
475: p_attribute1_o => per_pyp_shd.g_old_rec.attribute1,
476: p_attribute2_o => per_pyp_shd.g_old_rec.attribute2,
477: p_attribute3_o => per_pyp_shd.g_old_rec.attribute3,
478: p_attribute4_o => per_pyp_shd.g_old_rec.attribute4,
479: p_attribute5_o => per_pyp_shd.g_old_rec.attribute5,
480: p_attribute6_o => per_pyp_shd.g_old_rec.attribute6,
481: p_attribute7_o => per_pyp_shd.g_old_rec.attribute7,
482: p_attribute8_o => per_pyp_shd.g_old_rec.attribute8,
483: p_attribute9_o => per_pyp_shd.g_old_rec.attribute9,
476: p_attribute2_o => per_pyp_shd.g_old_rec.attribute2,
477: p_attribute3_o => per_pyp_shd.g_old_rec.attribute3,
478: p_attribute4_o => per_pyp_shd.g_old_rec.attribute4,
479: p_attribute5_o => per_pyp_shd.g_old_rec.attribute5,
480: p_attribute6_o => per_pyp_shd.g_old_rec.attribute6,
481: p_attribute7_o => per_pyp_shd.g_old_rec.attribute7,
482: p_attribute8_o => per_pyp_shd.g_old_rec.attribute8,
483: p_attribute9_o => per_pyp_shd.g_old_rec.attribute9,
484: p_attribute10_o => per_pyp_shd.g_old_rec.attribute10,
477: p_attribute3_o => per_pyp_shd.g_old_rec.attribute3,
478: p_attribute4_o => per_pyp_shd.g_old_rec.attribute4,
479: p_attribute5_o => per_pyp_shd.g_old_rec.attribute5,
480: p_attribute6_o => per_pyp_shd.g_old_rec.attribute6,
481: p_attribute7_o => per_pyp_shd.g_old_rec.attribute7,
482: p_attribute8_o => per_pyp_shd.g_old_rec.attribute8,
483: p_attribute9_o => per_pyp_shd.g_old_rec.attribute9,
484: p_attribute10_o => per_pyp_shd.g_old_rec.attribute10,
485: p_attribute11_o => per_pyp_shd.g_old_rec.attribute11,
478: p_attribute4_o => per_pyp_shd.g_old_rec.attribute4,
479: p_attribute5_o => per_pyp_shd.g_old_rec.attribute5,
480: p_attribute6_o => per_pyp_shd.g_old_rec.attribute6,
481: p_attribute7_o => per_pyp_shd.g_old_rec.attribute7,
482: p_attribute8_o => per_pyp_shd.g_old_rec.attribute8,
483: p_attribute9_o => per_pyp_shd.g_old_rec.attribute9,
484: p_attribute10_o => per_pyp_shd.g_old_rec.attribute10,
485: p_attribute11_o => per_pyp_shd.g_old_rec.attribute11,
486: p_attribute12_o => per_pyp_shd.g_old_rec.attribute12,
479: p_attribute5_o => per_pyp_shd.g_old_rec.attribute5,
480: p_attribute6_o => per_pyp_shd.g_old_rec.attribute6,
481: p_attribute7_o => per_pyp_shd.g_old_rec.attribute7,
482: p_attribute8_o => per_pyp_shd.g_old_rec.attribute8,
483: p_attribute9_o => per_pyp_shd.g_old_rec.attribute9,
484: p_attribute10_o => per_pyp_shd.g_old_rec.attribute10,
485: p_attribute11_o => per_pyp_shd.g_old_rec.attribute11,
486: p_attribute12_o => per_pyp_shd.g_old_rec.attribute12,
487: p_attribute13_o => per_pyp_shd.g_old_rec.attribute13,
480: p_attribute6_o => per_pyp_shd.g_old_rec.attribute6,
481: p_attribute7_o => per_pyp_shd.g_old_rec.attribute7,
482: p_attribute8_o => per_pyp_shd.g_old_rec.attribute8,
483: p_attribute9_o => per_pyp_shd.g_old_rec.attribute9,
484: p_attribute10_o => per_pyp_shd.g_old_rec.attribute10,
485: p_attribute11_o => per_pyp_shd.g_old_rec.attribute11,
486: p_attribute12_o => per_pyp_shd.g_old_rec.attribute12,
487: p_attribute13_o => per_pyp_shd.g_old_rec.attribute13,
488: p_attribute14_o => per_pyp_shd.g_old_rec.attribute14,
481: p_attribute7_o => per_pyp_shd.g_old_rec.attribute7,
482: p_attribute8_o => per_pyp_shd.g_old_rec.attribute8,
483: p_attribute9_o => per_pyp_shd.g_old_rec.attribute9,
484: p_attribute10_o => per_pyp_shd.g_old_rec.attribute10,
485: p_attribute11_o => per_pyp_shd.g_old_rec.attribute11,
486: p_attribute12_o => per_pyp_shd.g_old_rec.attribute12,
487: p_attribute13_o => per_pyp_shd.g_old_rec.attribute13,
488: p_attribute14_o => per_pyp_shd.g_old_rec.attribute14,
489: p_attribute15_o => per_pyp_shd.g_old_rec.attribute15,
482: p_attribute8_o => per_pyp_shd.g_old_rec.attribute8,
483: p_attribute9_o => per_pyp_shd.g_old_rec.attribute9,
484: p_attribute10_o => per_pyp_shd.g_old_rec.attribute10,
485: p_attribute11_o => per_pyp_shd.g_old_rec.attribute11,
486: p_attribute12_o => per_pyp_shd.g_old_rec.attribute12,
487: p_attribute13_o => per_pyp_shd.g_old_rec.attribute13,
488: p_attribute14_o => per_pyp_shd.g_old_rec.attribute14,
489: p_attribute15_o => per_pyp_shd.g_old_rec.attribute15,
490: p_attribute16_o => per_pyp_shd.g_old_rec.attribute16,
483: p_attribute9_o => per_pyp_shd.g_old_rec.attribute9,
484: p_attribute10_o => per_pyp_shd.g_old_rec.attribute10,
485: p_attribute11_o => per_pyp_shd.g_old_rec.attribute11,
486: p_attribute12_o => per_pyp_shd.g_old_rec.attribute12,
487: p_attribute13_o => per_pyp_shd.g_old_rec.attribute13,
488: p_attribute14_o => per_pyp_shd.g_old_rec.attribute14,
489: p_attribute15_o => per_pyp_shd.g_old_rec.attribute15,
490: p_attribute16_o => per_pyp_shd.g_old_rec.attribute16,
491: p_attribute17_o => per_pyp_shd.g_old_rec.attribute17,
484: p_attribute10_o => per_pyp_shd.g_old_rec.attribute10,
485: p_attribute11_o => per_pyp_shd.g_old_rec.attribute11,
486: p_attribute12_o => per_pyp_shd.g_old_rec.attribute12,
487: p_attribute13_o => per_pyp_shd.g_old_rec.attribute13,
488: p_attribute14_o => per_pyp_shd.g_old_rec.attribute14,
489: p_attribute15_o => per_pyp_shd.g_old_rec.attribute15,
490: p_attribute16_o => per_pyp_shd.g_old_rec.attribute16,
491: p_attribute17_o => per_pyp_shd.g_old_rec.attribute17,
492: p_attribute18_o => per_pyp_shd.g_old_rec.attribute18,
485: p_attribute11_o => per_pyp_shd.g_old_rec.attribute11,
486: p_attribute12_o => per_pyp_shd.g_old_rec.attribute12,
487: p_attribute13_o => per_pyp_shd.g_old_rec.attribute13,
488: p_attribute14_o => per_pyp_shd.g_old_rec.attribute14,
489: p_attribute15_o => per_pyp_shd.g_old_rec.attribute15,
490: p_attribute16_o => per_pyp_shd.g_old_rec.attribute16,
491: p_attribute17_o => per_pyp_shd.g_old_rec.attribute17,
492: p_attribute18_o => per_pyp_shd.g_old_rec.attribute18,
493: p_attribute19_o => per_pyp_shd.g_old_rec.attribute19,
486: p_attribute12_o => per_pyp_shd.g_old_rec.attribute12,
487: p_attribute13_o => per_pyp_shd.g_old_rec.attribute13,
488: p_attribute14_o => per_pyp_shd.g_old_rec.attribute14,
489: p_attribute15_o => per_pyp_shd.g_old_rec.attribute15,
490: p_attribute16_o => per_pyp_shd.g_old_rec.attribute16,
491: p_attribute17_o => per_pyp_shd.g_old_rec.attribute17,
492: p_attribute18_o => per_pyp_shd.g_old_rec.attribute18,
493: p_attribute19_o => per_pyp_shd.g_old_rec.attribute19,
494: p_attribute20_o => per_pyp_shd.g_old_rec.attribute20,
487: p_attribute13_o => per_pyp_shd.g_old_rec.attribute13,
488: p_attribute14_o => per_pyp_shd.g_old_rec.attribute14,
489: p_attribute15_o => per_pyp_shd.g_old_rec.attribute15,
490: p_attribute16_o => per_pyp_shd.g_old_rec.attribute16,
491: p_attribute17_o => per_pyp_shd.g_old_rec.attribute17,
492: p_attribute18_o => per_pyp_shd.g_old_rec.attribute18,
493: p_attribute19_o => per_pyp_shd.g_old_rec.attribute19,
494: p_attribute20_o => per_pyp_shd.g_old_rec.attribute20,
495: p_object_version_number_o => per_pyp_shd.g_old_rec.object_version_number,
488: p_attribute14_o => per_pyp_shd.g_old_rec.attribute14,
489: p_attribute15_o => per_pyp_shd.g_old_rec.attribute15,
490: p_attribute16_o => per_pyp_shd.g_old_rec.attribute16,
491: p_attribute17_o => per_pyp_shd.g_old_rec.attribute17,
492: p_attribute18_o => per_pyp_shd.g_old_rec.attribute18,
493: p_attribute19_o => per_pyp_shd.g_old_rec.attribute19,
494: p_attribute20_o => per_pyp_shd.g_old_rec.attribute20,
495: p_object_version_number_o => per_pyp_shd.g_old_rec.object_version_number,
496: p_multiple_components_o => per_pyp_shd.g_old_rec.multiple_components,
489: p_attribute15_o => per_pyp_shd.g_old_rec.attribute15,
490: p_attribute16_o => per_pyp_shd.g_old_rec.attribute16,
491: p_attribute17_o => per_pyp_shd.g_old_rec.attribute17,
492: p_attribute18_o => per_pyp_shd.g_old_rec.attribute18,
493: p_attribute19_o => per_pyp_shd.g_old_rec.attribute19,
494: p_attribute20_o => per_pyp_shd.g_old_rec.attribute20,
495: p_object_version_number_o => per_pyp_shd.g_old_rec.object_version_number,
496: p_multiple_components_o => per_pyp_shd.g_old_rec.multiple_components,
497: p_approved_o => per_pyp_shd.g_old_rec.approved
490: p_attribute16_o => per_pyp_shd.g_old_rec.attribute16,
491: p_attribute17_o => per_pyp_shd.g_old_rec.attribute17,
492: p_attribute18_o => per_pyp_shd.g_old_rec.attribute18,
493: p_attribute19_o => per_pyp_shd.g_old_rec.attribute19,
494: p_attribute20_o => per_pyp_shd.g_old_rec.attribute20,
495: p_object_version_number_o => per_pyp_shd.g_old_rec.object_version_number,
496: p_multiple_components_o => per_pyp_shd.g_old_rec.multiple_components,
497: p_approved_o => per_pyp_shd.g_old_rec.approved
498: );
491: p_attribute17_o => per_pyp_shd.g_old_rec.attribute17,
492: p_attribute18_o => per_pyp_shd.g_old_rec.attribute18,
493: p_attribute19_o => per_pyp_shd.g_old_rec.attribute19,
494: p_attribute20_o => per_pyp_shd.g_old_rec.attribute20,
495: p_object_version_number_o => per_pyp_shd.g_old_rec.object_version_number,
496: p_multiple_components_o => per_pyp_shd.g_old_rec.multiple_components,
497: p_approved_o => per_pyp_shd.g_old_rec.approved
498: );
499: --
492: p_attribute18_o => per_pyp_shd.g_old_rec.attribute18,
493: p_attribute19_o => per_pyp_shd.g_old_rec.attribute19,
494: p_attribute20_o => per_pyp_shd.g_old_rec.attribute20,
495: p_object_version_number_o => per_pyp_shd.g_old_rec.object_version_number,
496: p_multiple_components_o => per_pyp_shd.g_old_rec.multiple_components,
497: p_approved_o => per_pyp_shd.g_old_rec.approved
498: );
499: --
500: hr_utility.set_location('DM Mode pro ' ||hr_general.g_data_migrator_mode ,379);
493: p_attribute19_o => per_pyp_shd.g_old_rec.attribute19,
494: p_attribute20_o => per_pyp_shd.g_old_rec.attribute20,
495: p_object_version_number_o => per_pyp_shd.g_old_rec.object_version_number,
496: p_multiple_components_o => per_pyp_shd.g_old_rec.multiple_components,
497: p_approved_o => per_pyp_shd.g_old_rec.approved
498: );
499: --
500: hr_utility.set_location('DM Mode pro ' ||hr_general.g_data_migrator_mode ,379);
501: --
575: -- Internal Table Handler Use Only.
576: --
577: -- {End Of Comments}
578: -- ----------------------------------------------------------------------------
579: Procedure convert_defs(p_rec in out nocopy per_pyp_shd.g_rec_type) is
580: --
581: l_proc varchar2(72) := g_package||'convert_defs';
582: --
583: Begin
590: -- is being used then we must set to the 'current' argument value.
591: --
592: If (p_rec.assignment_id = hr_api.g_number) then
593: p_rec.assignment_id :=
594: per_pyp_shd.g_old_rec.assignment_id;
595: End If;
596: If (p_rec.business_group_id = hr_api.g_number) then
597: p_rec.business_group_id :=
598: per_pyp_shd.g_old_rec.business_group_id;
594: per_pyp_shd.g_old_rec.assignment_id;
595: End If;
596: If (p_rec.business_group_id = hr_api.g_number) then
597: p_rec.business_group_id :=
598: per_pyp_shd.g_old_rec.business_group_id;
599: End If;
600: If (p_rec.change_date = hr_api.g_date) then
601: p_rec.change_date :=
602: per_pyp_shd.g_old_rec.change_date;
598: per_pyp_shd.g_old_rec.business_group_id;
599: End If;
600: If (p_rec.change_date = hr_api.g_date) then
601: p_rec.change_date :=
602: per_pyp_shd.g_old_rec.change_date;
603: End If;
604: If (p_rec.comments = hr_api.g_varchar2) then
605: p_rec.comments :=
606: per_pyp_shd.g_old_rec.comments;
602: per_pyp_shd.g_old_rec.change_date;
603: End If;
604: If (p_rec.comments = hr_api.g_varchar2) then
605: p_rec.comments :=
606: per_pyp_shd.g_old_rec.comments;
607: End If;
608: If (p_rec.last_change_date = hr_api.g_date) then
609: p_rec.last_change_date :=
610: per_pyp_shd.g_old_rec.last_change_date;
606: per_pyp_shd.g_old_rec.comments;
607: End If;
608: If (p_rec.last_change_date = hr_api.g_date) then
609: p_rec.last_change_date :=
610: per_pyp_shd.g_old_rec.last_change_date;
611: End If;
612: If (p_rec.next_sal_review_date = hr_api.g_date) then
613: p_rec.next_sal_review_date :=
614: per_pyp_shd.g_old_rec.next_sal_review_date;
610: per_pyp_shd.g_old_rec.last_change_date;
611: End If;
612: If (p_rec.next_sal_review_date = hr_api.g_date) then
613: p_rec.next_sal_review_date :=
614: per_pyp_shd.g_old_rec.next_sal_review_date;
615: End If;
616: If (p_rec.proposal_reason = hr_api.g_varchar2) then
617: p_rec.proposal_reason :=
618: per_pyp_shd.g_old_rec.proposal_reason;
614: per_pyp_shd.g_old_rec.next_sal_review_date;
615: End If;
616: If (p_rec.proposal_reason = hr_api.g_varchar2) then
617: p_rec.proposal_reason :=
618: per_pyp_shd.g_old_rec.proposal_reason;
619: End If;
620: If (p_rec.proposed_salary_n = hr_api.g_number) then
621: p_rec.proposed_salary_n :=
622: per_pyp_shd.g_old_rec.proposed_salary_n;
618: per_pyp_shd.g_old_rec.proposal_reason;
619: End If;
620: If (p_rec.proposed_salary_n = hr_api.g_number) then
621: p_rec.proposed_salary_n :=
622: per_pyp_shd.g_old_rec.proposed_salary_n;
623: End If;
624: If (p_rec.forced_ranking = hr_api.g_number) then
625: p_rec.forced_ranking :=
626: per_pyp_shd.g_old_rec.forced_ranking;
622: per_pyp_shd.g_old_rec.proposed_salary_n;
623: End If;
624: If (p_rec.forced_ranking = hr_api.g_number) then
625: p_rec.forced_ranking :=
626: per_pyp_shd.g_old_rec.forced_ranking;
627: End If;
628: If (p_rec.date_to = hr_api.g_date) then
629: p_rec.date_to :=
630: per_pyp_shd.g_old_rec.date_to;
626: per_pyp_shd.g_old_rec.forced_ranking;
627: End If;
628: If (p_rec.date_to = hr_api.g_date) then
629: p_rec.date_to :=
630: per_pyp_shd.g_old_rec.date_to;
631: End If;
632: If (p_rec.performance_review_id = hr_api.g_number) then
633: p_rec.performance_review_id :=
634: per_pyp_shd.g_old_rec.performance_review_id;
630: per_pyp_shd.g_old_rec.date_to;
631: End If;
632: If (p_rec.performance_review_id = hr_api.g_number) then
633: p_rec.performance_review_id :=
634: per_pyp_shd.g_old_rec.performance_review_id;
635: End If;
636: If (p_rec.attribute_category = hr_api.g_varchar2) then
637: p_rec.attribute_category :=
638: per_pyp_shd.g_old_rec.attribute_category;
634: per_pyp_shd.g_old_rec.performance_review_id;
635: End If;
636: If (p_rec.attribute_category = hr_api.g_varchar2) then
637: p_rec.attribute_category :=
638: per_pyp_shd.g_old_rec.attribute_category;
639: End If;
640: If (p_rec.attribute1 = hr_api.g_varchar2) then
641: p_rec.attribute1 :=
642: per_pyp_shd.g_old_rec.attribute1;
638: per_pyp_shd.g_old_rec.attribute_category;
639: End If;
640: If (p_rec.attribute1 = hr_api.g_varchar2) then
641: p_rec.attribute1 :=
642: per_pyp_shd.g_old_rec.attribute1;
643: End If;
644: If (p_rec.attribute2 = hr_api.g_varchar2) then
645: p_rec.attribute2 :=
646: per_pyp_shd.g_old_rec.attribute2;
642: per_pyp_shd.g_old_rec.attribute1;
643: End If;
644: If (p_rec.attribute2 = hr_api.g_varchar2) then
645: p_rec.attribute2 :=
646: per_pyp_shd.g_old_rec.attribute2;
647: End If;
648: If (p_rec.attribute3 = hr_api.g_varchar2) then
649: p_rec.attribute3 :=
650: per_pyp_shd.g_old_rec.attribute3;
646: per_pyp_shd.g_old_rec.attribute2;
647: End If;
648: If (p_rec.attribute3 = hr_api.g_varchar2) then
649: p_rec.attribute3 :=
650: per_pyp_shd.g_old_rec.attribute3;
651: End If;
652: If (p_rec.attribute4 = hr_api.g_varchar2) then
653: p_rec.attribute4 :=
654: per_pyp_shd.g_old_rec.attribute4;
650: per_pyp_shd.g_old_rec.attribute3;
651: End If;
652: If (p_rec.attribute4 = hr_api.g_varchar2) then
653: p_rec.attribute4 :=
654: per_pyp_shd.g_old_rec.attribute4;
655: End If;
656: If (p_rec.attribute5 = hr_api.g_varchar2) then
657: p_rec.attribute5 :=
658: per_pyp_shd.g_old_rec.attribute5;
654: per_pyp_shd.g_old_rec.attribute4;
655: End If;
656: If (p_rec.attribute5 = hr_api.g_varchar2) then
657: p_rec.attribute5 :=
658: per_pyp_shd.g_old_rec.attribute5;
659: End If;
660: If (p_rec.attribute6 = hr_api.g_varchar2) then
661: p_rec.attribute6 :=
662: per_pyp_shd.g_old_rec.attribute6;
658: per_pyp_shd.g_old_rec.attribute5;
659: End If;
660: If (p_rec.attribute6 = hr_api.g_varchar2) then
661: p_rec.attribute6 :=
662: per_pyp_shd.g_old_rec.attribute6;
663: End If;
664: If (p_rec.attribute7 = hr_api.g_varchar2) then
665: p_rec.attribute7 :=
666: per_pyp_shd.g_old_rec.attribute7;
662: per_pyp_shd.g_old_rec.attribute6;
663: End If;
664: If (p_rec.attribute7 = hr_api.g_varchar2) then
665: p_rec.attribute7 :=
666: per_pyp_shd.g_old_rec.attribute7;
667: End If;
668: If (p_rec.attribute8 = hr_api.g_varchar2) then
669: p_rec.attribute8 :=
670: per_pyp_shd.g_old_rec.attribute8;
666: per_pyp_shd.g_old_rec.attribute7;
667: End If;
668: If (p_rec.attribute8 = hr_api.g_varchar2) then
669: p_rec.attribute8 :=
670: per_pyp_shd.g_old_rec.attribute8;
671: End If;
672: If (p_rec.attribute9 = hr_api.g_varchar2) then
673: p_rec.attribute9 :=
674: per_pyp_shd.g_old_rec.attribute9;
670: per_pyp_shd.g_old_rec.attribute8;
671: End If;
672: If (p_rec.attribute9 = hr_api.g_varchar2) then
673: p_rec.attribute9 :=
674: per_pyp_shd.g_old_rec.attribute9;
675: End If;
676: If (p_rec.attribute10 = hr_api.g_varchar2) then
677: p_rec.attribute10 :=
678: per_pyp_shd.g_old_rec.attribute10;
674: per_pyp_shd.g_old_rec.attribute9;
675: End If;
676: If (p_rec.attribute10 = hr_api.g_varchar2) then
677: p_rec.attribute10 :=
678: per_pyp_shd.g_old_rec.attribute10;
679: End If;
680: If (p_rec.attribute11 = hr_api.g_varchar2) then
681: p_rec.attribute11 :=
682: per_pyp_shd.g_old_rec.attribute11;
678: per_pyp_shd.g_old_rec.attribute10;
679: End If;
680: If (p_rec.attribute11 = hr_api.g_varchar2) then
681: p_rec.attribute11 :=
682: per_pyp_shd.g_old_rec.attribute11;
683: eND iF;
684: If (p_rec.attribute12 = hr_api.g_varchar2) then
685: p_rec.attribute12 :=
686: per_pyp_shd.g_old_rec.attribute12;
682: per_pyp_shd.g_old_rec.attribute11;
683: eND iF;
684: If (p_rec.attribute12 = hr_api.g_varchar2) then
685: p_rec.attribute12 :=
686: per_pyp_shd.g_old_rec.attribute12;
687: End If;
688: If (p_rec.attribute13 = hr_api.g_varchar2) then
689: p_rec.attribute13 :=
690: per_pyp_shd.g_old_rec.attribute13;
686: per_pyp_shd.g_old_rec.attribute12;
687: End If;
688: If (p_rec.attribute13 = hr_api.g_varchar2) then
689: p_rec.attribute13 :=
690: per_pyp_shd.g_old_rec.attribute13;
691: End If;
692: If (p_rec.attribute14 = hr_api.g_varchar2) then
693: p_rec.attribute14 :=
694: per_pyp_shd.g_old_rec.attribute14;
690: per_pyp_shd.g_old_rec.attribute13;
691: End If;
692: If (p_rec.attribute14 = hr_api.g_varchar2) then
693: p_rec.attribute14 :=
694: per_pyp_shd.g_old_rec.attribute14;
695: End If;
696: If (p_rec.attribute15 = hr_api.g_varchar2) then
697: p_rec.attribute15 :=
698: per_pyp_shd.g_old_rec.attribute15;
694: per_pyp_shd.g_old_rec.attribute14;
695: End If;
696: If (p_rec.attribute15 = hr_api.g_varchar2) then
697: p_rec.attribute15 :=
698: per_pyp_shd.g_old_rec.attribute15;
699: End If;
700: If (p_rec.attribute16 = hr_api.g_varchar2) then
701: p_rec.attribute16 :=
702: per_pyp_shd.g_old_rec.attribute16;
698: per_pyp_shd.g_old_rec.attribute15;
699: End If;
700: If (p_rec.attribute16 = hr_api.g_varchar2) then
701: p_rec.attribute16 :=
702: per_pyp_shd.g_old_rec.attribute16;
703: End If;
704: If (p_rec.attribute17 = hr_api.g_varchar2) then
705: p_rec.attribute17 :=
706: per_pyp_shd.g_old_rec.attribute17;
702: per_pyp_shd.g_old_rec.attribute16;
703: End If;
704: If (p_rec.attribute17 = hr_api.g_varchar2) then
705: p_rec.attribute17 :=
706: per_pyp_shd.g_old_rec.attribute17;
707: End If;
708: If (p_rec.attribute18 = hr_api.g_varchar2) then
709: p_rec.attribute18 :=
710: per_pyp_shd.g_old_rec.attribute18;
706: per_pyp_shd.g_old_rec.attribute17;
707: End If;
708: If (p_rec.attribute18 = hr_api.g_varchar2) then
709: p_rec.attribute18 :=
710: per_pyp_shd.g_old_rec.attribute18;
711: End If;
712: If (p_rec.attribute19 = hr_api.g_varchar2) then
713: p_rec.attribute19 :=
714: per_pyp_shd.g_old_rec.attribute19;
710: per_pyp_shd.g_old_rec.attribute18;
711: End If;
712: If (p_rec.attribute19 = hr_api.g_varchar2) then
713: p_rec.attribute19 :=
714: per_pyp_shd.g_old_rec.attribute19;
715: End If;
716: If (p_rec.attribute20 = hr_api.g_varchar2) then
717: p_rec.attribute20 :=
718: per_pyp_shd.g_old_rec.attribute20;
714: per_pyp_shd.g_old_rec.attribute19;
715: End If;
716: If (p_rec.attribute20 = hr_api.g_varchar2) then
717: p_rec.attribute20 :=
718: per_pyp_shd.g_old_rec.attribute20;
719: End If;
720: If (p_rec.multiple_components = hr_api.g_varchar2) then
721: p_rec.multiple_components :=
722: per_pyp_shd.g_old_rec.multiple_components;
718: per_pyp_shd.g_old_rec.attribute20;
719: End If;
720: If (p_rec.multiple_components = hr_api.g_varchar2) then
721: p_rec.multiple_components :=
722: per_pyp_shd.g_old_rec.multiple_components;
723: End If;
724: If (p_rec.approved = hr_api.g_varchar2) then
725: p_rec.approved :=
726: per_pyp_shd.g_old_rec.approved;
722: per_pyp_shd.g_old_rec.multiple_components;
723: End If;
724: If (p_rec.approved = hr_api.g_varchar2) then
725: p_rec.approved :=
726: per_pyp_shd.g_old_rec.approved;
727: End If;
728: --
729: hr_utility.set_location(' Leaving:'||l_proc, 10);
730: --
734: -- |---------------------------------< upd >----------------------------------|
735: -- ----------------------------------------------------------------------------
736: Procedure upd
737: (
738: p_rec in out nocopy per_pyp_shd.g_rec_type,
739: p_validate in boolean ,
740: p_inv_next_sal_date_warning out nocopy boolean ,
741: p_proposed_salary_warning out nocopy boolean ,
742: p_approved_warning out nocopy boolean ,
763: End If;
764: --
765: -- We must lock the row which we need to update.
766: --
767: per_pyp_shd.lck
768: (
769: p_rec.pay_proposal_id,
770: p_rec.object_version_number
771: );
869: p_payroll_warning out nocopy boolean
870:
871: ) is
872: --
873: l_rec per_pyp_shd.g_rec_type;
874: l_proc varchar2(72) := g_package||'upd';
875: --
876: Begin
877: hr_utility.set_location('Entering:'||l_proc, 5);
880: -- Call conversion function to turn arguments into the
881: -- l_rec structure.
882: --
883: l_rec :=
884: per_pyp_shd.convert_args
885: (
886: p_pay_proposal_id,
887: hr_api.g_number,
888: hr_api.g_number,