70: -- Internal Table Handler Use Only.
71: --
72: -- {End Of Comments}
73: -- ----------------------------------------------------------------------------
74: Procedure insert_dml(p_rec in out nocopy per_pyp_shd.g_rec_type) is
75: --
76: l_proc varchar2(72) := g_package||'insert_dml';
77: --
78: Begin
78: Begin
79: hr_utility.set_location('Entering:'||l_proc, 5);
80: p_rec.object_version_number := 1; -- Initialise the object version
81: --
82: per_pyp_shd.g_api_dml := true; -- Set the api dml status
83: --
84: -- Insert the row into: per_pay_proposals
85: --
86: insert into per_pay_proposals
167: p_rec.multiple_components,
168: p_rec.approved
169: );
170: --
171: per_pyp_shd.g_api_dml := false; -- Unset the api dml status
172: --
173: hr_utility.set_location(' Leaving:'||l_proc, 10);
174: Exception
175: When hr_api.check_integrity_violated Then
173: hr_utility.set_location(' Leaving:'||l_proc, 10);
174: Exception
175: When hr_api.check_integrity_violated Then
176: -- A check constraint has been violated
177: per_pyp_shd.g_api_dml := false; -- Unset the api dml status
178: per_pyp_shd.constraint_error
179: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
180: When hr_api.parent_integrity_violated Then
181: -- Parent integrity has been violated
174: Exception
175: When hr_api.check_integrity_violated Then
176: -- A check constraint has been violated
177: per_pyp_shd.g_api_dml := false; -- Unset the api dml status
178: per_pyp_shd.constraint_error
179: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
180: When hr_api.parent_integrity_violated Then
181: -- Parent integrity has been violated
182: per_pyp_shd.g_api_dml := false; -- Unset the api dml status
178: per_pyp_shd.constraint_error
179: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
180: When hr_api.parent_integrity_violated Then
181: -- Parent integrity has been violated
182: per_pyp_shd.g_api_dml := false; -- Unset the api dml status
183: per_pyp_shd.constraint_error
184: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
185: When hr_api.unique_integrity_violated Then
186: -- Unique integrity has been violated
179: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
180: When hr_api.parent_integrity_violated Then
181: -- Parent integrity has been violated
182: per_pyp_shd.g_api_dml := false; -- Unset the api dml status
183: per_pyp_shd.constraint_error
184: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
185: When hr_api.unique_integrity_violated Then
186: -- Unique integrity has been violated
187: per_pyp_shd.g_api_dml := false; -- Unset the api dml status
183: per_pyp_shd.constraint_error
184: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
185: When hr_api.unique_integrity_violated Then
186: -- Unique integrity has been violated
187: per_pyp_shd.g_api_dml := false; -- Unset the api dml status
188: per_pyp_shd.constraint_error
189: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
190: When Others Then
191: per_pyp_shd.g_api_dml := false; -- Unset the api dml status
184: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
185: When hr_api.unique_integrity_violated Then
186: -- Unique integrity has been violated
187: per_pyp_shd.g_api_dml := false; -- Unset the api dml status
188: per_pyp_shd.constraint_error
189: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
190: When Others Then
191: per_pyp_shd.g_api_dml := false; -- Unset the api dml status
192: Raise;
187: per_pyp_shd.g_api_dml := false; -- Unset the api dml status
188: per_pyp_shd.constraint_error
189: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
190: When Others Then
191: per_pyp_shd.g_api_dml := false; -- Unset the api dml status
192: Raise;
193: End insert_dml;
194: --
195: -- ----------------------------------------------------------------------------
228: -- Internal Table Handler Use Only.
229: --
230: -- {End Of Comments}
231: -- ----------------------------------------------------------------------------
232: Procedure pre_insert(p_rec in out nocopy per_pyp_shd.g_rec_type) is
233: --
234: l_proc varchar2(72) := g_package||'pre_insert';
235: --
236: Cursor C_Sel1 is select per_pay_proposals_s.nextval from sys.dual;
321: --
322: -- {End Of Comments}
323: -- ----------------------------------------------------------------------------
324: Procedure post_insert
325: (p_rec in per_pyp_shd.g_rec_type,
326: p_inv_next_sal_date_warning in boolean,
327: p_proposed_salary_warning in boolean,
328: p_approved_warning in boolean,
329: p_payroll_warning in boolean
348: begin
349: --
350: -- Bug 5203589 - Set old values of PER_PAY_PROPOSAL record
351: --
352: l_old_rec.BUSINESS_GROUP_ID := per_pyp_shd.g_old_rec.BUSINESS_GROUP_ID;
353: l_old_rec.PAY_PROPOSAL_ID := per_pyp_shd.g_old_rec.PAY_PROPOSAL_ID;
354: l_old_rec.ASSIGNMENT_ID := per_pyp_shd.g_old_rec.ASSIGNMENT_ID;
355: l_old_rec.EVENT_ID := null; -- 9999 per_pyp_shd.g_old_rec.EVENT_ID;
356: l_old_rec.CHANGE_DATE := per_pyp_shd.g_old_rec.CHANGE_DATE;
349: --
350: -- Bug 5203589 - Set old values of PER_PAY_PROPOSAL record
351: --
352: l_old_rec.BUSINESS_GROUP_ID := per_pyp_shd.g_old_rec.BUSINESS_GROUP_ID;
353: l_old_rec.PAY_PROPOSAL_ID := per_pyp_shd.g_old_rec.PAY_PROPOSAL_ID;
354: l_old_rec.ASSIGNMENT_ID := per_pyp_shd.g_old_rec.ASSIGNMENT_ID;
355: l_old_rec.EVENT_ID := null; -- 9999 per_pyp_shd.g_old_rec.EVENT_ID;
356: l_old_rec.CHANGE_DATE := per_pyp_shd.g_old_rec.CHANGE_DATE;
357: l_old_rec.LAST_CHANGE_DATE := per_pyp_shd.g_old_rec.LAST_CHANGE_DATE;
350: -- Bug 5203589 - Set old values of PER_PAY_PROPOSAL record
351: --
352: l_old_rec.BUSINESS_GROUP_ID := per_pyp_shd.g_old_rec.BUSINESS_GROUP_ID;
353: l_old_rec.PAY_PROPOSAL_ID := per_pyp_shd.g_old_rec.PAY_PROPOSAL_ID;
354: l_old_rec.ASSIGNMENT_ID := per_pyp_shd.g_old_rec.ASSIGNMENT_ID;
355: l_old_rec.EVENT_ID := null; -- 9999 per_pyp_shd.g_old_rec.EVENT_ID;
356: l_old_rec.CHANGE_DATE := per_pyp_shd.g_old_rec.CHANGE_DATE;
357: l_old_rec.LAST_CHANGE_DATE := per_pyp_shd.g_old_rec.LAST_CHANGE_DATE;
358: l_old_rec.NEXT_PERF_REVIEW_DATE := null; -- 9999 per_pyp_shd.g_old_rec.NEXT_PERF_REVIEW_DATE;
351: --
352: l_old_rec.BUSINESS_GROUP_ID := per_pyp_shd.g_old_rec.BUSINESS_GROUP_ID;
353: l_old_rec.PAY_PROPOSAL_ID := per_pyp_shd.g_old_rec.PAY_PROPOSAL_ID;
354: l_old_rec.ASSIGNMENT_ID := per_pyp_shd.g_old_rec.ASSIGNMENT_ID;
355: l_old_rec.EVENT_ID := null; -- 9999 per_pyp_shd.g_old_rec.EVENT_ID;
356: l_old_rec.CHANGE_DATE := per_pyp_shd.g_old_rec.CHANGE_DATE;
357: l_old_rec.LAST_CHANGE_DATE := per_pyp_shd.g_old_rec.LAST_CHANGE_DATE;
358: l_old_rec.NEXT_PERF_REVIEW_DATE := null; -- 9999 per_pyp_shd.g_old_rec.NEXT_PERF_REVIEW_DATE;
359: l_old_rec.NEXT_SAL_REVIEW_DATE := per_pyp_shd.g_old_rec.NEXT_SAL_REVIEW_DATE;
352: l_old_rec.BUSINESS_GROUP_ID := per_pyp_shd.g_old_rec.BUSINESS_GROUP_ID;
353: l_old_rec.PAY_PROPOSAL_ID := per_pyp_shd.g_old_rec.PAY_PROPOSAL_ID;
354: l_old_rec.ASSIGNMENT_ID := per_pyp_shd.g_old_rec.ASSIGNMENT_ID;
355: l_old_rec.EVENT_ID := null; -- 9999 per_pyp_shd.g_old_rec.EVENT_ID;
356: l_old_rec.CHANGE_DATE := per_pyp_shd.g_old_rec.CHANGE_DATE;
357: l_old_rec.LAST_CHANGE_DATE := per_pyp_shd.g_old_rec.LAST_CHANGE_DATE;
358: l_old_rec.NEXT_PERF_REVIEW_DATE := null; -- 9999 per_pyp_shd.g_old_rec.NEXT_PERF_REVIEW_DATE;
359: l_old_rec.NEXT_SAL_REVIEW_DATE := per_pyp_shd.g_old_rec.NEXT_SAL_REVIEW_DATE;
360: l_old_rec.PERFORMANCE_RATING := null; -- 9999 per_pyp_shd.g_old_rec.PERFORMANCE_RATING;
353: l_old_rec.PAY_PROPOSAL_ID := per_pyp_shd.g_old_rec.PAY_PROPOSAL_ID;
354: l_old_rec.ASSIGNMENT_ID := per_pyp_shd.g_old_rec.ASSIGNMENT_ID;
355: l_old_rec.EVENT_ID := null; -- 9999 per_pyp_shd.g_old_rec.EVENT_ID;
356: l_old_rec.CHANGE_DATE := per_pyp_shd.g_old_rec.CHANGE_DATE;
357: l_old_rec.LAST_CHANGE_DATE := per_pyp_shd.g_old_rec.LAST_CHANGE_DATE;
358: l_old_rec.NEXT_PERF_REVIEW_DATE := null; -- 9999 per_pyp_shd.g_old_rec.NEXT_PERF_REVIEW_DATE;
359: l_old_rec.NEXT_SAL_REVIEW_DATE := per_pyp_shd.g_old_rec.NEXT_SAL_REVIEW_DATE;
360: l_old_rec.PERFORMANCE_RATING := null; -- 9999 per_pyp_shd.g_old_rec.PERFORMANCE_RATING;
361: l_old_rec.PROPOSAL_REASON := per_pyp_shd.g_old_rec.PROPOSAL_REASON;
354: l_old_rec.ASSIGNMENT_ID := per_pyp_shd.g_old_rec.ASSIGNMENT_ID;
355: l_old_rec.EVENT_ID := null; -- 9999 per_pyp_shd.g_old_rec.EVENT_ID;
356: l_old_rec.CHANGE_DATE := per_pyp_shd.g_old_rec.CHANGE_DATE;
357: l_old_rec.LAST_CHANGE_DATE := per_pyp_shd.g_old_rec.LAST_CHANGE_DATE;
358: l_old_rec.NEXT_PERF_REVIEW_DATE := null; -- 9999 per_pyp_shd.g_old_rec.NEXT_PERF_REVIEW_DATE;
359: l_old_rec.NEXT_SAL_REVIEW_DATE := per_pyp_shd.g_old_rec.NEXT_SAL_REVIEW_DATE;
360: l_old_rec.PERFORMANCE_RATING := null; -- 9999 per_pyp_shd.g_old_rec.PERFORMANCE_RATING;
361: l_old_rec.PROPOSAL_REASON := per_pyp_shd.g_old_rec.PROPOSAL_REASON;
362: l_old_rec.PROPOSED_SALARY_N := per_pyp_shd.g_old_rec.PROPOSED_SALARY_N;
355: l_old_rec.EVENT_ID := null; -- 9999 per_pyp_shd.g_old_rec.EVENT_ID;
356: l_old_rec.CHANGE_DATE := per_pyp_shd.g_old_rec.CHANGE_DATE;
357: l_old_rec.LAST_CHANGE_DATE := per_pyp_shd.g_old_rec.LAST_CHANGE_DATE;
358: l_old_rec.NEXT_PERF_REVIEW_DATE := null; -- 9999 per_pyp_shd.g_old_rec.NEXT_PERF_REVIEW_DATE;
359: l_old_rec.NEXT_SAL_REVIEW_DATE := per_pyp_shd.g_old_rec.NEXT_SAL_REVIEW_DATE;
360: l_old_rec.PERFORMANCE_RATING := null; -- 9999 per_pyp_shd.g_old_rec.PERFORMANCE_RATING;
361: l_old_rec.PROPOSAL_REASON := per_pyp_shd.g_old_rec.PROPOSAL_REASON;
362: l_old_rec.PROPOSED_SALARY_N := per_pyp_shd.g_old_rec.PROPOSED_SALARY_N;
363: l_old_rec.REVIEW_DATE := null; -- 9999 per_pyp_shd.g_old_rec.REVIEW_DATE;
356: l_old_rec.CHANGE_DATE := per_pyp_shd.g_old_rec.CHANGE_DATE;
357: l_old_rec.LAST_CHANGE_DATE := per_pyp_shd.g_old_rec.LAST_CHANGE_DATE;
358: l_old_rec.NEXT_PERF_REVIEW_DATE := null; -- 9999 per_pyp_shd.g_old_rec.NEXT_PERF_REVIEW_DATE;
359: l_old_rec.NEXT_SAL_REVIEW_DATE := per_pyp_shd.g_old_rec.NEXT_SAL_REVIEW_DATE;
360: l_old_rec.PERFORMANCE_RATING := null; -- 9999 per_pyp_shd.g_old_rec.PERFORMANCE_RATING;
361: l_old_rec.PROPOSAL_REASON := per_pyp_shd.g_old_rec.PROPOSAL_REASON;
362: l_old_rec.PROPOSED_SALARY_N := per_pyp_shd.g_old_rec.PROPOSED_SALARY_N;
363: l_old_rec.REVIEW_DATE := null; -- 9999 per_pyp_shd.g_old_rec.REVIEW_DATE;
364: l_old_rec.APPROVED := per_pyp_shd.g_old_rec.APPROVED;
357: l_old_rec.LAST_CHANGE_DATE := per_pyp_shd.g_old_rec.LAST_CHANGE_DATE;
358: l_old_rec.NEXT_PERF_REVIEW_DATE := null; -- 9999 per_pyp_shd.g_old_rec.NEXT_PERF_REVIEW_DATE;
359: l_old_rec.NEXT_SAL_REVIEW_DATE := per_pyp_shd.g_old_rec.NEXT_SAL_REVIEW_DATE;
360: l_old_rec.PERFORMANCE_RATING := null; -- 9999 per_pyp_shd.g_old_rec.PERFORMANCE_RATING;
361: l_old_rec.PROPOSAL_REASON := per_pyp_shd.g_old_rec.PROPOSAL_REASON;
362: l_old_rec.PROPOSED_SALARY_N := per_pyp_shd.g_old_rec.PROPOSED_SALARY_N;
363: l_old_rec.REVIEW_DATE := null; -- 9999 per_pyp_shd.g_old_rec.REVIEW_DATE;
364: l_old_rec.APPROVED := per_pyp_shd.g_old_rec.APPROVED;
365: l_old_rec.MULTIPLE_COMPONENTS := per_pyp_shd.g_old_rec.MULTIPLE_COMPONENTS;
358: l_old_rec.NEXT_PERF_REVIEW_DATE := null; -- 9999 per_pyp_shd.g_old_rec.NEXT_PERF_REVIEW_DATE;
359: l_old_rec.NEXT_SAL_REVIEW_DATE := per_pyp_shd.g_old_rec.NEXT_SAL_REVIEW_DATE;
360: l_old_rec.PERFORMANCE_RATING := null; -- 9999 per_pyp_shd.g_old_rec.PERFORMANCE_RATING;
361: l_old_rec.PROPOSAL_REASON := per_pyp_shd.g_old_rec.PROPOSAL_REASON;
362: l_old_rec.PROPOSED_SALARY_N := per_pyp_shd.g_old_rec.PROPOSED_SALARY_N;
363: l_old_rec.REVIEW_DATE := null; -- 9999 per_pyp_shd.g_old_rec.REVIEW_DATE;
364: l_old_rec.APPROVED := per_pyp_shd.g_old_rec.APPROVED;
365: l_old_rec.MULTIPLE_COMPONENTS := per_pyp_shd.g_old_rec.MULTIPLE_COMPONENTS;
366: l_old_rec.FORCED_RANKING := per_pyp_shd.g_old_rec.FORCED_RANKING;
359: l_old_rec.NEXT_SAL_REVIEW_DATE := per_pyp_shd.g_old_rec.NEXT_SAL_REVIEW_DATE;
360: l_old_rec.PERFORMANCE_RATING := null; -- 9999 per_pyp_shd.g_old_rec.PERFORMANCE_RATING;
361: l_old_rec.PROPOSAL_REASON := per_pyp_shd.g_old_rec.PROPOSAL_REASON;
362: l_old_rec.PROPOSED_SALARY_N := per_pyp_shd.g_old_rec.PROPOSED_SALARY_N;
363: l_old_rec.REVIEW_DATE := null; -- 9999 per_pyp_shd.g_old_rec.REVIEW_DATE;
364: l_old_rec.APPROVED := per_pyp_shd.g_old_rec.APPROVED;
365: l_old_rec.MULTIPLE_COMPONENTS := per_pyp_shd.g_old_rec.MULTIPLE_COMPONENTS;
366: l_old_rec.FORCED_RANKING := per_pyp_shd.g_old_rec.FORCED_RANKING;
367: l_old_rec.DATE_TO := per_pyp_shd.g_old_rec.DATE_TO;
360: l_old_rec.PERFORMANCE_RATING := null; -- 9999 per_pyp_shd.g_old_rec.PERFORMANCE_RATING;
361: l_old_rec.PROPOSAL_REASON := per_pyp_shd.g_old_rec.PROPOSAL_REASON;
362: l_old_rec.PROPOSED_SALARY_N := per_pyp_shd.g_old_rec.PROPOSED_SALARY_N;
363: l_old_rec.REVIEW_DATE := null; -- 9999 per_pyp_shd.g_old_rec.REVIEW_DATE;
364: l_old_rec.APPROVED := per_pyp_shd.g_old_rec.APPROVED;
365: l_old_rec.MULTIPLE_COMPONENTS := per_pyp_shd.g_old_rec.MULTIPLE_COMPONENTS;
366: l_old_rec.FORCED_RANKING := per_pyp_shd.g_old_rec.FORCED_RANKING;
367: l_old_rec.DATE_TO := per_pyp_shd.g_old_rec.DATE_TO;
368: l_old_rec.PERFORMANCE_REVIEW_ID := per_pyp_shd.g_old_rec.PERFORMANCE_REVIEW_ID;
361: l_old_rec.PROPOSAL_REASON := per_pyp_shd.g_old_rec.PROPOSAL_REASON;
362: l_old_rec.PROPOSED_SALARY_N := per_pyp_shd.g_old_rec.PROPOSED_SALARY_N;
363: l_old_rec.REVIEW_DATE := null; -- 9999 per_pyp_shd.g_old_rec.REVIEW_DATE;
364: l_old_rec.APPROVED := per_pyp_shd.g_old_rec.APPROVED;
365: l_old_rec.MULTIPLE_COMPONENTS := per_pyp_shd.g_old_rec.MULTIPLE_COMPONENTS;
366: l_old_rec.FORCED_RANKING := per_pyp_shd.g_old_rec.FORCED_RANKING;
367: l_old_rec.DATE_TO := per_pyp_shd.g_old_rec.DATE_TO;
368: l_old_rec.PERFORMANCE_REVIEW_ID := per_pyp_shd.g_old_rec.PERFORMANCE_REVIEW_ID;
369: l_old_rec.ATTRIBUTE1 := per_pyp_shd.g_old_rec.ATTRIBUTE1;
362: l_old_rec.PROPOSED_SALARY_N := per_pyp_shd.g_old_rec.PROPOSED_SALARY_N;
363: l_old_rec.REVIEW_DATE := null; -- 9999 per_pyp_shd.g_old_rec.REVIEW_DATE;
364: l_old_rec.APPROVED := per_pyp_shd.g_old_rec.APPROVED;
365: l_old_rec.MULTIPLE_COMPONENTS := per_pyp_shd.g_old_rec.MULTIPLE_COMPONENTS;
366: l_old_rec.FORCED_RANKING := per_pyp_shd.g_old_rec.FORCED_RANKING;
367: l_old_rec.DATE_TO := per_pyp_shd.g_old_rec.DATE_TO;
368: l_old_rec.PERFORMANCE_REVIEW_ID := per_pyp_shd.g_old_rec.PERFORMANCE_REVIEW_ID;
369: l_old_rec.ATTRIBUTE1 := per_pyp_shd.g_old_rec.ATTRIBUTE1;
370: l_old_rec.ATTRIBUTE2 := per_pyp_shd.g_old_rec.ATTRIBUTE2;
363: l_old_rec.REVIEW_DATE := null; -- 9999 per_pyp_shd.g_old_rec.REVIEW_DATE;
364: l_old_rec.APPROVED := per_pyp_shd.g_old_rec.APPROVED;
365: l_old_rec.MULTIPLE_COMPONENTS := per_pyp_shd.g_old_rec.MULTIPLE_COMPONENTS;
366: l_old_rec.FORCED_RANKING := per_pyp_shd.g_old_rec.FORCED_RANKING;
367: l_old_rec.DATE_TO := per_pyp_shd.g_old_rec.DATE_TO;
368: l_old_rec.PERFORMANCE_REVIEW_ID := per_pyp_shd.g_old_rec.PERFORMANCE_REVIEW_ID;
369: l_old_rec.ATTRIBUTE1 := per_pyp_shd.g_old_rec.ATTRIBUTE1;
370: l_old_rec.ATTRIBUTE2 := per_pyp_shd.g_old_rec.ATTRIBUTE2;
371: l_old_rec.ATTRIBUTE3 := per_pyp_shd.g_old_rec.ATTRIBUTE3;
364: l_old_rec.APPROVED := per_pyp_shd.g_old_rec.APPROVED;
365: l_old_rec.MULTIPLE_COMPONENTS := per_pyp_shd.g_old_rec.MULTIPLE_COMPONENTS;
366: l_old_rec.FORCED_RANKING := per_pyp_shd.g_old_rec.FORCED_RANKING;
367: l_old_rec.DATE_TO := per_pyp_shd.g_old_rec.DATE_TO;
368: l_old_rec.PERFORMANCE_REVIEW_ID := per_pyp_shd.g_old_rec.PERFORMANCE_REVIEW_ID;
369: l_old_rec.ATTRIBUTE1 := per_pyp_shd.g_old_rec.ATTRIBUTE1;
370: l_old_rec.ATTRIBUTE2 := per_pyp_shd.g_old_rec.ATTRIBUTE2;
371: l_old_rec.ATTRIBUTE3 := per_pyp_shd.g_old_rec.ATTRIBUTE3;
372: l_old_rec.ATTRIBUTE4 := per_pyp_shd.g_old_rec.ATTRIBUTE4;
365: l_old_rec.MULTIPLE_COMPONENTS := per_pyp_shd.g_old_rec.MULTIPLE_COMPONENTS;
366: l_old_rec.FORCED_RANKING := per_pyp_shd.g_old_rec.FORCED_RANKING;
367: l_old_rec.DATE_TO := per_pyp_shd.g_old_rec.DATE_TO;
368: l_old_rec.PERFORMANCE_REVIEW_ID := per_pyp_shd.g_old_rec.PERFORMANCE_REVIEW_ID;
369: l_old_rec.ATTRIBUTE1 := per_pyp_shd.g_old_rec.ATTRIBUTE1;
370: l_old_rec.ATTRIBUTE2 := per_pyp_shd.g_old_rec.ATTRIBUTE2;
371: l_old_rec.ATTRIBUTE3 := per_pyp_shd.g_old_rec.ATTRIBUTE3;
372: l_old_rec.ATTRIBUTE4 := per_pyp_shd.g_old_rec.ATTRIBUTE4;
373: l_old_rec.ATTRIBUTE5 := per_pyp_shd.g_old_rec.ATTRIBUTE5;
366: l_old_rec.FORCED_RANKING := per_pyp_shd.g_old_rec.FORCED_RANKING;
367: l_old_rec.DATE_TO := per_pyp_shd.g_old_rec.DATE_TO;
368: l_old_rec.PERFORMANCE_REVIEW_ID := per_pyp_shd.g_old_rec.PERFORMANCE_REVIEW_ID;
369: l_old_rec.ATTRIBUTE1 := per_pyp_shd.g_old_rec.ATTRIBUTE1;
370: l_old_rec.ATTRIBUTE2 := per_pyp_shd.g_old_rec.ATTRIBUTE2;
371: l_old_rec.ATTRIBUTE3 := per_pyp_shd.g_old_rec.ATTRIBUTE3;
372: l_old_rec.ATTRIBUTE4 := per_pyp_shd.g_old_rec.ATTRIBUTE4;
373: l_old_rec.ATTRIBUTE5 := per_pyp_shd.g_old_rec.ATTRIBUTE5;
374: l_old_rec.ATTRIBUTE6 := per_pyp_shd.g_old_rec.ATTRIBUTE6;
367: l_old_rec.DATE_TO := per_pyp_shd.g_old_rec.DATE_TO;
368: l_old_rec.PERFORMANCE_REVIEW_ID := per_pyp_shd.g_old_rec.PERFORMANCE_REVIEW_ID;
369: l_old_rec.ATTRIBUTE1 := per_pyp_shd.g_old_rec.ATTRIBUTE1;
370: l_old_rec.ATTRIBUTE2 := per_pyp_shd.g_old_rec.ATTRIBUTE2;
371: l_old_rec.ATTRIBUTE3 := per_pyp_shd.g_old_rec.ATTRIBUTE3;
372: l_old_rec.ATTRIBUTE4 := per_pyp_shd.g_old_rec.ATTRIBUTE4;
373: l_old_rec.ATTRIBUTE5 := per_pyp_shd.g_old_rec.ATTRIBUTE5;
374: l_old_rec.ATTRIBUTE6 := per_pyp_shd.g_old_rec.ATTRIBUTE6;
375: l_old_rec.ATTRIBUTE7 := per_pyp_shd.g_old_rec.ATTRIBUTE7;
368: l_old_rec.PERFORMANCE_REVIEW_ID := per_pyp_shd.g_old_rec.PERFORMANCE_REVIEW_ID;
369: l_old_rec.ATTRIBUTE1 := per_pyp_shd.g_old_rec.ATTRIBUTE1;
370: l_old_rec.ATTRIBUTE2 := per_pyp_shd.g_old_rec.ATTRIBUTE2;
371: l_old_rec.ATTRIBUTE3 := per_pyp_shd.g_old_rec.ATTRIBUTE3;
372: l_old_rec.ATTRIBUTE4 := per_pyp_shd.g_old_rec.ATTRIBUTE4;
373: l_old_rec.ATTRIBUTE5 := per_pyp_shd.g_old_rec.ATTRIBUTE5;
374: l_old_rec.ATTRIBUTE6 := per_pyp_shd.g_old_rec.ATTRIBUTE6;
375: l_old_rec.ATTRIBUTE7 := per_pyp_shd.g_old_rec.ATTRIBUTE7;
376: l_old_rec.ATTRIBUTE8 := per_pyp_shd.g_old_rec.ATTRIBUTE8;
369: l_old_rec.ATTRIBUTE1 := per_pyp_shd.g_old_rec.ATTRIBUTE1;
370: l_old_rec.ATTRIBUTE2 := per_pyp_shd.g_old_rec.ATTRIBUTE2;
371: l_old_rec.ATTRIBUTE3 := per_pyp_shd.g_old_rec.ATTRIBUTE3;
372: l_old_rec.ATTRIBUTE4 := per_pyp_shd.g_old_rec.ATTRIBUTE4;
373: l_old_rec.ATTRIBUTE5 := per_pyp_shd.g_old_rec.ATTRIBUTE5;
374: l_old_rec.ATTRIBUTE6 := per_pyp_shd.g_old_rec.ATTRIBUTE6;
375: l_old_rec.ATTRIBUTE7 := per_pyp_shd.g_old_rec.ATTRIBUTE7;
376: l_old_rec.ATTRIBUTE8 := per_pyp_shd.g_old_rec.ATTRIBUTE8;
377: l_old_rec.ATTRIBUTE9 := per_pyp_shd.g_old_rec.ATTRIBUTE9;
370: l_old_rec.ATTRIBUTE2 := per_pyp_shd.g_old_rec.ATTRIBUTE2;
371: l_old_rec.ATTRIBUTE3 := per_pyp_shd.g_old_rec.ATTRIBUTE3;
372: l_old_rec.ATTRIBUTE4 := per_pyp_shd.g_old_rec.ATTRIBUTE4;
373: l_old_rec.ATTRIBUTE5 := per_pyp_shd.g_old_rec.ATTRIBUTE5;
374: l_old_rec.ATTRIBUTE6 := per_pyp_shd.g_old_rec.ATTRIBUTE6;
375: l_old_rec.ATTRIBUTE7 := per_pyp_shd.g_old_rec.ATTRIBUTE7;
376: l_old_rec.ATTRIBUTE8 := per_pyp_shd.g_old_rec.ATTRIBUTE8;
377: l_old_rec.ATTRIBUTE9 := per_pyp_shd.g_old_rec.ATTRIBUTE9;
378: l_old_rec.ATTRIBUTE10 := per_pyp_shd.g_old_rec.ATTRIBUTE10;
371: l_old_rec.ATTRIBUTE3 := per_pyp_shd.g_old_rec.ATTRIBUTE3;
372: l_old_rec.ATTRIBUTE4 := per_pyp_shd.g_old_rec.ATTRIBUTE4;
373: l_old_rec.ATTRIBUTE5 := per_pyp_shd.g_old_rec.ATTRIBUTE5;
374: l_old_rec.ATTRIBUTE6 := per_pyp_shd.g_old_rec.ATTRIBUTE6;
375: l_old_rec.ATTRIBUTE7 := per_pyp_shd.g_old_rec.ATTRIBUTE7;
376: l_old_rec.ATTRIBUTE8 := per_pyp_shd.g_old_rec.ATTRIBUTE8;
377: l_old_rec.ATTRIBUTE9 := per_pyp_shd.g_old_rec.ATTRIBUTE9;
378: l_old_rec.ATTRIBUTE10 := per_pyp_shd.g_old_rec.ATTRIBUTE10;
379: l_old_rec.ATTRIBUTE11 := per_pyp_shd.g_old_rec.ATTRIBUTE11;
372: l_old_rec.ATTRIBUTE4 := per_pyp_shd.g_old_rec.ATTRIBUTE4;
373: l_old_rec.ATTRIBUTE5 := per_pyp_shd.g_old_rec.ATTRIBUTE5;
374: l_old_rec.ATTRIBUTE6 := per_pyp_shd.g_old_rec.ATTRIBUTE6;
375: l_old_rec.ATTRIBUTE7 := per_pyp_shd.g_old_rec.ATTRIBUTE7;
376: l_old_rec.ATTRIBUTE8 := per_pyp_shd.g_old_rec.ATTRIBUTE8;
377: l_old_rec.ATTRIBUTE9 := per_pyp_shd.g_old_rec.ATTRIBUTE9;
378: l_old_rec.ATTRIBUTE10 := per_pyp_shd.g_old_rec.ATTRIBUTE10;
379: l_old_rec.ATTRIBUTE11 := per_pyp_shd.g_old_rec.ATTRIBUTE11;
380: l_old_rec.ATTRIBUTE12 := per_pyp_shd.g_old_rec.ATTRIBUTE12;
373: l_old_rec.ATTRIBUTE5 := per_pyp_shd.g_old_rec.ATTRIBUTE5;
374: l_old_rec.ATTRIBUTE6 := per_pyp_shd.g_old_rec.ATTRIBUTE6;
375: l_old_rec.ATTRIBUTE7 := per_pyp_shd.g_old_rec.ATTRIBUTE7;
376: l_old_rec.ATTRIBUTE8 := per_pyp_shd.g_old_rec.ATTRIBUTE8;
377: l_old_rec.ATTRIBUTE9 := per_pyp_shd.g_old_rec.ATTRIBUTE9;
378: l_old_rec.ATTRIBUTE10 := per_pyp_shd.g_old_rec.ATTRIBUTE10;
379: l_old_rec.ATTRIBUTE11 := per_pyp_shd.g_old_rec.ATTRIBUTE11;
380: l_old_rec.ATTRIBUTE12 := per_pyp_shd.g_old_rec.ATTRIBUTE12;
381: l_old_rec.ATTRIBUTE13 := per_pyp_shd.g_old_rec.ATTRIBUTE13;
374: l_old_rec.ATTRIBUTE6 := per_pyp_shd.g_old_rec.ATTRIBUTE6;
375: l_old_rec.ATTRIBUTE7 := per_pyp_shd.g_old_rec.ATTRIBUTE7;
376: l_old_rec.ATTRIBUTE8 := per_pyp_shd.g_old_rec.ATTRIBUTE8;
377: l_old_rec.ATTRIBUTE9 := per_pyp_shd.g_old_rec.ATTRIBUTE9;
378: l_old_rec.ATTRIBUTE10 := per_pyp_shd.g_old_rec.ATTRIBUTE10;
379: l_old_rec.ATTRIBUTE11 := per_pyp_shd.g_old_rec.ATTRIBUTE11;
380: l_old_rec.ATTRIBUTE12 := per_pyp_shd.g_old_rec.ATTRIBUTE12;
381: l_old_rec.ATTRIBUTE13 := per_pyp_shd.g_old_rec.ATTRIBUTE13;
382: l_old_rec.ATTRIBUTE14 := per_pyp_shd.g_old_rec.ATTRIBUTE14;
375: l_old_rec.ATTRIBUTE7 := per_pyp_shd.g_old_rec.ATTRIBUTE7;
376: l_old_rec.ATTRIBUTE8 := per_pyp_shd.g_old_rec.ATTRIBUTE8;
377: l_old_rec.ATTRIBUTE9 := per_pyp_shd.g_old_rec.ATTRIBUTE9;
378: l_old_rec.ATTRIBUTE10 := per_pyp_shd.g_old_rec.ATTRIBUTE10;
379: l_old_rec.ATTRIBUTE11 := per_pyp_shd.g_old_rec.ATTRIBUTE11;
380: l_old_rec.ATTRIBUTE12 := per_pyp_shd.g_old_rec.ATTRIBUTE12;
381: l_old_rec.ATTRIBUTE13 := per_pyp_shd.g_old_rec.ATTRIBUTE13;
382: l_old_rec.ATTRIBUTE14 := per_pyp_shd.g_old_rec.ATTRIBUTE14;
383: l_old_rec.ATTRIBUTE15 := per_pyp_shd.g_old_rec.ATTRIBUTE15;
376: l_old_rec.ATTRIBUTE8 := per_pyp_shd.g_old_rec.ATTRIBUTE8;
377: l_old_rec.ATTRIBUTE9 := per_pyp_shd.g_old_rec.ATTRIBUTE9;
378: l_old_rec.ATTRIBUTE10 := per_pyp_shd.g_old_rec.ATTRIBUTE10;
379: l_old_rec.ATTRIBUTE11 := per_pyp_shd.g_old_rec.ATTRIBUTE11;
380: l_old_rec.ATTRIBUTE12 := per_pyp_shd.g_old_rec.ATTRIBUTE12;
381: l_old_rec.ATTRIBUTE13 := per_pyp_shd.g_old_rec.ATTRIBUTE13;
382: l_old_rec.ATTRIBUTE14 := per_pyp_shd.g_old_rec.ATTRIBUTE14;
383: l_old_rec.ATTRIBUTE15 := per_pyp_shd.g_old_rec.ATTRIBUTE15;
384: l_old_rec.ATTRIBUTE16 := per_pyp_shd.g_old_rec.ATTRIBUTE16;
377: l_old_rec.ATTRIBUTE9 := per_pyp_shd.g_old_rec.ATTRIBUTE9;
378: l_old_rec.ATTRIBUTE10 := per_pyp_shd.g_old_rec.ATTRIBUTE10;
379: l_old_rec.ATTRIBUTE11 := per_pyp_shd.g_old_rec.ATTRIBUTE11;
380: l_old_rec.ATTRIBUTE12 := per_pyp_shd.g_old_rec.ATTRIBUTE12;
381: l_old_rec.ATTRIBUTE13 := per_pyp_shd.g_old_rec.ATTRIBUTE13;
382: l_old_rec.ATTRIBUTE14 := per_pyp_shd.g_old_rec.ATTRIBUTE14;
383: l_old_rec.ATTRIBUTE15 := per_pyp_shd.g_old_rec.ATTRIBUTE15;
384: l_old_rec.ATTRIBUTE16 := per_pyp_shd.g_old_rec.ATTRIBUTE16;
385: l_old_rec.ATTRIBUTE17 := per_pyp_shd.g_old_rec.ATTRIBUTE17;
378: l_old_rec.ATTRIBUTE10 := per_pyp_shd.g_old_rec.ATTRIBUTE10;
379: l_old_rec.ATTRIBUTE11 := per_pyp_shd.g_old_rec.ATTRIBUTE11;
380: l_old_rec.ATTRIBUTE12 := per_pyp_shd.g_old_rec.ATTRIBUTE12;
381: l_old_rec.ATTRIBUTE13 := per_pyp_shd.g_old_rec.ATTRIBUTE13;
382: l_old_rec.ATTRIBUTE14 := per_pyp_shd.g_old_rec.ATTRIBUTE14;
383: l_old_rec.ATTRIBUTE15 := per_pyp_shd.g_old_rec.ATTRIBUTE15;
384: l_old_rec.ATTRIBUTE16 := per_pyp_shd.g_old_rec.ATTRIBUTE16;
385: l_old_rec.ATTRIBUTE17 := per_pyp_shd.g_old_rec.ATTRIBUTE17;
386: l_old_rec.ATTRIBUTE18 := per_pyp_shd.g_old_rec.ATTRIBUTE18;
379: l_old_rec.ATTRIBUTE11 := per_pyp_shd.g_old_rec.ATTRIBUTE11;
380: l_old_rec.ATTRIBUTE12 := per_pyp_shd.g_old_rec.ATTRIBUTE12;
381: l_old_rec.ATTRIBUTE13 := per_pyp_shd.g_old_rec.ATTRIBUTE13;
382: l_old_rec.ATTRIBUTE14 := per_pyp_shd.g_old_rec.ATTRIBUTE14;
383: l_old_rec.ATTRIBUTE15 := per_pyp_shd.g_old_rec.ATTRIBUTE15;
384: l_old_rec.ATTRIBUTE16 := per_pyp_shd.g_old_rec.ATTRIBUTE16;
385: l_old_rec.ATTRIBUTE17 := per_pyp_shd.g_old_rec.ATTRIBUTE17;
386: l_old_rec.ATTRIBUTE18 := per_pyp_shd.g_old_rec.ATTRIBUTE18;
387: l_old_rec.ATTRIBUTE19 := per_pyp_shd.g_old_rec.ATTRIBUTE19;
380: l_old_rec.ATTRIBUTE12 := per_pyp_shd.g_old_rec.ATTRIBUTE12;
381: l_old_rec.ATTRIBUTE13 := per_pyp_shd.g_old_rec.ATTRIBUTE13;
382: l_old_rec.ATTRIBUTE14 := per_pyp_shd.g_old_rec.ATTRIBUTE14;
383: l_old_rec.ATTRIBUTE15 := per_pyp_shd.g_old_rec.ATTRIBUTE15;
384: l_old_rec.ATTRIBUTE16 := per_pyp_shd.g_old_rec.ATTRIBUTE16;
385: l_old_rec.ATTRIBUTE17 := per_pyp_shd.g_old_rec.ATTRIBUTE17;
386: l_old_rec.ATTRIBUTE18 := per_pyp_shd.g_old_rec.ATTRIBUTE18;
387: l_old_rec.ATTRIBUTE19 := per_pyp_shd.g_old_rec.ATTRIBUTE19;
388: l_old_rec.ATTRIBUTE20 := per_pyp_shd.g_old_rec.ATTRIBUTE20;
381: l_old_rec.ATTRIBUTE13 := per_pyp_shd.g_old_rec.ATTRIBUTE13;
382: l_old_rec.ATTRIBUTE14 := per_pyp_shd.g_old_rec.ATTRIBUTE14;
383: l_old_rec.ATTRIBUTE15 := per_pyp_shd.g_old_rec.ATTRIBUTE15;
384: l_old_rec.ATTRIBUTE16 := per_pyp_shd.g_old_rec.ATTRIBUTE16;
385: l_old_rec.ATTRIBUTE17 := per_pyp_shd.g_old_rec.ATTRIBUTE17;
386: l_old_rec.ATTRIBUTE18 := per_pyp_shd.g_old_rec.ATTRIBUTE18;
387: l_old_rec.ATTRIBUTE19 := per_pyp_shd.g_old_rec.ATTRIBUTE19;
388: l_old_rec.ATTRIBUTE20 := per_pyp_shd.g_old_rec.ATTRIBUTE20;
389: l_old_rec.PROPOSED_SALARY := null; -- 9999 ben_pro_shd.g_old_rec.PROPOSED_SALARY;
382: l_old_rec.ATTRIBUTE14 := per_pyp_shd.g_old_rec.ATTRIBUTE14;
383: l_old_rec.ATTRIBUTE15 := per_pyp_shd.g_old_rec.ATTRIBUTE15;
384: l_old_rec.ATTRIBUTE16 := per_pyp_shd.g_old_rec.ATTRIBUTE16;
385: l_old_rec.ATTRIBUTE17 := per_pyp_shd.g_old_rec.ATTRIBUTE17;
386: l_old_rec.ATTRIBUTE18 := per_pyp_shd.g_old_rec.ATTRIBUTE18;
387: l_old_rec.ATTRIBUTE19 := per_pyp_shd.g_old_rec.ATTRIBUTE19;
388: l_old_rec.ATTRIBUTE20 := per_pyp_shd.g_old_rec.ATTRIBUTE20;
389: l_old_rec.PROPOSED_SALARY := null; -- 9999 ben_pro_shd.g_old_rec.PROPOSED_SALARY;
390:
383: l_old_rec.ATTRIBUTE15 := per_pyp_shd.g_old_rec.ATTRIBUTE15;
384: l_old_rec.ATTRIBUTE16 := per_pyp_shd.g_old_rec.ATTRIBUTE16;
385: l_old_rec.ATTRIBUTE17 := per_pyp_shd.g_old_rec.ATTRIBUTE17;
386: l_old_rec.ATTRIBUTE18 := per_pyp_shd.g_old_rec.ATTRIBUTE18;
387: l_old_rec.ATTRIBUTE19 := per_pyp_shd.g_old_rec.ATTRIBUTE19;
388: l_old_rec.ATTRIBUTE20 := per_pyp_shd.g_old_rec.ATTRIBUTE20;
389: l_old_rec.PROPOSED_SALARY := null; -- 9999 ben_pro_shd.g_old_rec.PROPOSED_SALARY;
390:
391: --
384: l_old_rec.ATTRIBUTE16 := per_pyp_shd.g_old_rec.ATTRIBUTE16;
385: l_old_rec.ATTRIBUTE17 := per_pyp_shd.g_old_rec.ATTRIBUTE17;
386: l_old_rec.ATTRIBUTE18 := per_pyp_shd.g_old_rec.ATTRIBUTE18;
387: l_old_rec.ATTRIBUTE19 := per_pyp_shd.g_old_rec.ATTRIBUTE19;
388: l_old_rec.ATTRIBUTE20 := per_pyp_shd.g_old_rec.ATTRIBUTE20;
389: l_old_rec.PROPOSED_SALARY := null; -- 9999 ben_pro_shd.g_old_rec.PROPOSED_SALARY;
390:
391: --
392: -- OAB Bug 1863413 : Detect potential life events when salary
556: -- |---------------------------------< ins >----------------------------------|
557: -- ----------------------------------------------------------------------------
558: Procedure ins
559: (
560: p_rec in out nocopy per_pyp_shd.g_rec_type,
561: p_validate in boolean ,
562: p_inv_next_sal_date_warning out nocopy boolean ,
563: p_proposed_salary_warning out nocopy boolean ,
564: p_approved_warning out nocopy boolean ,
680: p_approved_warning out nocopy boolean,
681: p_payroll_warning out nocopy boolean
682: ) is
683: --
684: l_rec per_pyp_shd.g_rec_type;
685: l_proc varchar2(72) := g_package||'ins';
686: --
687: Begin
688: hr_utility.set_location('Entering:'||l_proc, 5);
690: -- Call conversion function to turn arguments into the
691: -- p_rec structure.
692: --
693: l_rec :=
694: per_pyp_shd.convert_args
695: (
696: null,
697: p_assignment_id,
698: p_business_group_id,