159: begin
160: hr_utility.set_location('Entering:'||l_proc,10);
161: --
162: if ((p_rec.plan_id is not null) and (
163: nvl(per_pmp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
164: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
165: nvl(per_pmp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
166: nvl(p_rec.attribute1, hr_api.g_varchar2) or
167: nvl(per_pmp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
160: hr_utility.set_location('Entering:'||l_proc,10);
161: --
162: if ((p_rec.plan_id is not null) and (
163: nvl(per_pmp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
164: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
165: nvl(per_pmp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
166: nvl(p_rec.attribute1, hr_api.g_varchar2) or
167: nvl(per_pmp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
168: nvl(p_rec.attribute2, hr_api.g_varchar2) or
161: --
162: if ((p_rec.plan_id is not null) and (
163: nvl(per_pmp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
164: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
165: nvl(per_pmp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
166: nvl(p_rec.attribute1, hr_api.g_varchar2) or
167: nvl(per_pmp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
168: nvl(p_rec.attribute2, hr_api.g_varchar2) or
169: nvl(per_pmp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
162: if ((p_rec.plan_id is not null) and (
163: nvl(per_pmp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
164: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
165: nvl(per_pmp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
166: nvl(p_rec.attribute1, hr_api.g_varchar2) or
167: nvl(per_pmp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
168: nvl(p_rec.attribute2, hr_api.g_varchar2) or
169: nvl(per_pmp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
170: nvl(p_rec.attribute3, hr_api.g_varchar2) or
163: nvl(per_pmp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
164: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
165: nvl(per_pmp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
166: nvl(p_rec.attribute1, hr_api.g_varchar2) or
167: nvl(per_pmp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
168: nvl(p_rec.attribute2, hr_api.g_varchar2) or
169: nvl(per_pmp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
170: nvl(p_rec.attribute3, hr_api.g_varchar2) or
171: nvl(per_pmp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
164: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
165: nvl(per_pmp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
166: nvl(p_rec.attribute1, hr_api.g_varchar2) or
167: nvl(per_pmp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
168: nvl(p_rec.attribute2, hr_api.g_varchar2) or
169: nvl(per_pmp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
170: nvl(p_rec.attribute3, hr_api.g_varchar2) or
171: nvl(per_pmp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
172: nvl(p_rec.attribute4, hr_api.g_varchar2) or
165: nvl(per_pmp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
166: nvl(p_rec.attribute1, hr_api.g_varchar2) or
167: nvl(per_pmp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
168: nvl(p_rec.attribute2, hr_api.g_varchar2) or
169: nvl(per_pmp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
170: nvl(p_rec.attribute3, hr_api.g_varchar2) or
171: nvl(per_pmp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
172: nvl(p_rec.attribute4, hr_api.g_varchar2) or
173: nvl(per_pmp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
166: nvl(p_rec.attribute1, hr_api.g_varchar2) or
167: nvl(per_pmp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
168: nvl(p_rec.attribute2, hr_api.g_varchar2) or
169: nvl(per_pmp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
170: nvl(p_rec.attribute3, hr_api.g_varchar2) or
171: nvl(per_pmp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
172: nvl(p_rec.attribute4, hr_api.g_varchar2) or
173: nvl(per_pmp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
174: nvl(p_rec.attribute5, hr_api.g_varchar2) or
167: nvl(per_pmp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
168: nvl(p_rec.attribute2, hr_api.g_varchar2) or
169: nvl(per_pmp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
170: nvl(p_rec.attribute3, hr_api.g_varchar2) or
171: nvl(per_pmp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
172: nvl(p_rec.attribute4, hr_api.g_varchar2) or
173: nvl(per_pmp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
174: nvl(p_rec.attribute5, hr_api.g_varchar2) or
175: nvl(per_pmp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
168: nvl(p_rec.attribute2, hr_api.g_varchar2) or
169: nvl(per_pmp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
170: nvl(p_rec.attribute3, hr_api.g_varchar2) or
171: nvl(per_pmp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
172: nvl(p_rec.attribute4, hr_api.g_varchar2) or
173: nvl(per_pmp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
174: nvl(p_rec.attribute5, hr_api.g_varchar2) or
175: nvl(per_pmp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
176: nvl(p_rec.attribute6, hr_api.g_varchar2) or
169: nvl(per_pmp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
170: nvl(p_rec.attribute3, hr_api.g_varchar2) or
171: nvl(per_pmp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
172: nvl(p_rec.attribute4, hr_api.g_varchar2) or
173: nvl(per_pmp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
174: nvl(p_rec.attribute5, hr_api.g_varchar2) or
175: nvl(per_pmp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
176: nvl(p_rec.attribute6, hr_api.g_varchar2) or
177: nvl(per_pmp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
170: nvl(p_rec.attribute3, hr_api.g_varchar2) or
171: nvl(per_pmp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
172: nvl(p_rec.attribute4, hr_api.g_varchar2) or
173: nvl(per_pmp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
174: nvl(p_rec.attribute5, hr_api.g_varchar2) or
175: nvl(per_pmp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
176: nvl(p_rec.attribute6, hr_api.g_varchar2) or
177: nvl(per_pmp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
178: nvl(p_rec.attribute7, hr_api.g_varchar2) or
171: nvl(per_pmp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
172: nvl(p_rec.attribute4, hr_api.g_varchar2) or
173: nvl(per_pmp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
174: nvl(p_rec.attribute5, hr_api.g_varchar2) or
175: nvl(per_pmp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
176: nvl(p_rec.attribute6, hr_api.g_varchar2) or
177: nvl(per_pmp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
178: nvl(p_rec.attribute7, hr_api.g_varchar2) or
179: nvl(per_pmp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
172: nvl(p_rec.attribute4, hr_api.g_varchar2) or
173: nvl(per_pmp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
174: nvl(p_rec.attribute5, hr_api.g_varchar2) or
175: nvl(per_pmp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
176: nvl(p_rec.attribute6, hr_api.g_varchar2) or
177: nvl(per_pmp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
178: nvl(p_rec.attribute7, hr_api.g_varchar2) or
179: nvl(per_pmp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
180: nvl(p_rec.attribute8, hr_api.g_varchar2) or
173: nvl(per_pmp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
174: nvl(p_rec.attribute5, hr_api.g_varchar2) or
175: nvl(per_pmp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
176: nvl(p_rec.attribute6, hr_api.g_varchar2) or
177: nvl(per_pmp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
178: nvl(p_rec.attribute7, hr_api.g_varchar2) or
179: nvl(per_pmp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
180: nvl(p_rec.attribute8, hr_api.g_varchar2) or
181: nvl(per_pmp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
174: nvl(p_rec.attribute5, hr_api.g_varchar2) or
175: nvl(per_pmp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
176: nvl(p_rec.attribute6, hr_api.g_varchar2) or
177: nvl(per_pmp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
178: nvl(p_rec.attribute7, hr_api.g_varchar2) or
179: nvl(per_pmp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
180: nvl(p_rec.attribute8, hr_api.g_varchar2) or
181: nvl(per_pmp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
182: nvl(p_rec.attribute9, hr_api.g_varchar2) or
175: nvl(per_pmp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
176: nvl(p_rec.attribute6, hr_api.g_varchar2) or
177: nvl(per_pmp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
178: nvl(p_rec.attribute7, hr_api.g_varchar2) or
179: nvl(per_pmp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
180: nvl(p_rec.attribute8, hr_api.g_varchar2) or
181: nvl(per_pmp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
182: nvl(p_rec.attribute9, hr_api.g_varchar2) or
183: nvl(per_pmp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
176: nvl(p_rec.attribute6, hr_api.g_varchar2) or
177: nvl(per_pmp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
178: nvl(p_rec.attribute7, hr_api.g_varchar2) or
179: nvl(per_pmp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
180: nvl(p_rec.attribute8, hr_api.g_varchar2) or
181: nvl(per_pmp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
182: nvl(p_rec.attribute9, hr_api.g_varchar2) or
183: nvl(per_pmp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
184: nvl(p_rec.attribute10, hr_api.g_varchar2) or
177: nvl(per_pmp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
178: nvl(p_rec.attribute7, hr_api.g_varchar2) or
179: nvl(per_pmp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
180: nvl(p_rec.attribute8, hr_api.g_varchar2) or
181: nvl(per_pmp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
182: nvl(p_rec.attribute9, hr_api.g_varchar2) or
183: nvl(per_pmp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
184: nvl(p_rec.attribute10, hr_api.g_varchar2) or
185: nvl(per_pmp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
178: nvl(p_rec.attribute7, hr_api.g_varchar2) or
179: nvl(per_pmp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
180: nvl(p_rec.attribute8, hr_api.g_varchar2) or
181: nvl(per_pmp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
182: nvl(p_rec.attribute9, hr_api.g_varchar2) or
183: nvl(per_pmp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
184: nvl(p_rec.attribute10, hr_api.g_varchar2) or
185: nvl(per_pmp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
186: nvl(p_rec.attribute11, hr_api.g_varchar2) or
179: nvl(per_pmp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
180: nvl(p_rec.attribute8, hr_api.g_varchar2) or
181: nvl(per_pmp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
182: nvl(p_rec.attribute9, hr_api.g_varchar2) or
183: nvl(per_pmp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
184: nvl(p_rec.attribute10, hr_api.g_varchar2) or
185: nvl(per_pmp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
186: nvl(p_rec.attribute11, hr_api.g_varchar2) or
187: nvl(per_pmp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
180: nvl(p_rec.attribute8, hr_api.g_varchar2) or
181: nvl(per_pmp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
182: nvl(p_rec.attribute9, hr_api.g_varchar2) or
183: nvl(per_pmp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
184: nvl(p_rec.attribute10, hr_api.g_varchar2) or
185: nvl(per_pmp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
186: nvl(p_rec.attribute11, hr_api.g_varchar2) or
187: nvl(per_pmp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
188: nvl(p_rec.attribute12, hr_api.g_varchar2) or
181: nvl(per_pmp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
182: nvl(p_rec.attribute9, hr_api.g_varchar2) or
183: nvl(per_pmp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
184: nvl(p_rec.attribute10, hr_api.g_varchar2) or
185: nvl(per_pmp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
186: nvl(p_rec.attribute11, hr_api.g_varchar2) or
187: nvl(per_pmp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
188: nvl(p_rec.attribute12, hr_api.g_varchar2) or
189: nvl(per_pmp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
182: nvl(p_rec.attribute9, hr_api.g_varchar2) or
183: nvl(per_pmp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
184: nvl(p_rec.attribute10, hr_api.g_varchar2) or
185: nvl(per_pmp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
186: nvl(p_rec.attribute11, hr_api.g_varchar2) or
187: nvl(per_pmp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
188: nvl(p_rec.attribute12, hr_api.g_varchar2) or
189: nvl(per_pmp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
190: nvl(p_rec.attribute13, hr_api.g_varchar2) or
183: nvl(per_pmp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
184: nvl(p_rec.attribute10, hr_api.g_varchar2) or
185: nvl(per_pmp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
186: nvl(p_rec.attribute11, hr_api.g_varchar2) or
187: nvl(per_pmp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
188: nvl(p_rec.attribute12, hr_api.g_varchar2) or
189: nvl(per_pmp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
190: nvl(p_rec.attribute13, hr_api.g_varchar2) or
191: nvl(per_pmp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
184: nvl(p_rec.attribute10, hr_api.g_varchar2) or
185: nvl(per_pmp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
186: nvl(p_rec.attribute11, hr_api.g_varchar2) or
187: nvl(per_pmp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
188: nvl(p_rec.attribute12, hr_api.g_varchar2) or
189: nvl(per_pmp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
190: nvl(p_rec.attribute13, hr_api.g_varchar2) or
191: nvl(per_pmp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute14, hr_api.g_varchar2) or
185: nvl(per_pmp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
186: nvl(p_rec.attribute11, hr_api.g_varchar2) or
187: nvl(per_pmp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
188: nvl(p_rec.attribute12, hr_api.g_varchar2) or
189: nvl(per_pmp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
190: nvl(p_rec.attribute13, hr_api.g_varchar2) or
191: nvl(per_pmp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute14, hr_api.g_varchar2) or
193: nvl(per_pmp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
186: nvl(p_rec.attribute11, hr_api.g_varchar2) or
187: nvl(per_pmp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
188: nvl(p_rec.attribute12, hr_api.g_varchar2) or
189: nvl(per_pmp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
190: nvl(p_rec.attribute13, hr_api.g_varchar2) or
191: nvl(per_pmp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute14, hr_api.g_varchar2) or
193: nvl(per_pmp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute15, hr_api.g_varchar2) or
187: nvl(per_pmp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
188: nvl(p_rec.attribute12, hr_api.g_varchar2) or
189: nvl(per_pmp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
190: nvl(p_rec.attribute13, hr_api.g_varchar2) or
191: nvl(per_pmp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute14, hr_api.g_varchar2) or
193: nvl(per_pmp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute15, hr_api.g_varchar2) or
195: nvl(per_pmp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
188: nvl(p_rec.attribute12, hr_api.g_varchar2) or
189: nvl(per_pmp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
190: nvl(p_rec.attribute13, hr_api.g_varchar2) or
191: nvl(per_pmp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute14, hr_api.g_varchar2) or
193: nvl(per_pmp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute15, hr_api.g_varchar2) or
195: nvl(per_pmp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute16, hr_api.g_varchar2) or
189: nvl(per_pmp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
190: nvl(p_rec.attribute13, hr_api.g_varchar2) or
191: nvl(per_pmp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute14, hr_api.g_varchar2) or
193: nvl(per_pmp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute15, hr_api.g_varchar2) or
195: nvl(per_pmp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute16, hr_api.g_varchar2) or
197: nvl(per_pmp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
190: nvl(p_rec.attribute13, hr_api.g_varchar2) or
191: nvl(per_pmp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute14, hr_api.g_varchar2) or
193: nvl(per_pmp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute15, hr_api.g_varchar2) or
195: nvl(per_pmp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute16, hr_api.g_varchar2) or
197: nvl(per_pmp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute17, hr_api.g_varchar2) or
191: nvl(per_pmp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute14, hr_api.g_varchar2) or
193: nvl(per_pmp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute15, hr_api.g_varchar2) or
195: nvl(per_pmp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute16, hr_api.g_varchar2) or
197: nvl(per_pmp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute17, hr_api.g_varchar2) or
199: nvl(per_pmp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute14, hr_api.g_varchar2) or
193: nvl(per_pmp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute15, hr_api.g_varchar2) or
195: nvl(per_pmp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute16, hr_api.g_varchar2) or
197: nvl(per_pmp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute17, hr_api.g_varchar2) or
199: nvl(per_pmp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute18, hr_api.g_varchar2) or
193: nvl(per_pmp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute15, hr_api.g_varchar2) or
195: nvl(per_pmp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute16, hr_api.g_varchar2) or
197: nvl(per_pmp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute17, hr_api.g_varchar2) or
199: nvl(per_pmp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute18, hr_api.g_varchar2) or
201: nvl(per_pmp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute15, hr_api.g_varchar2) or
195: nvl(per_pmp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute16, hr_api.g_varchar2) or
197: nvl(per_pmp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute17, hr_api.g_varchar2) or
199: nvl(per_pmp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute18, hr_api.g_varchar2) or
201: nvl(per_pmp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute19, hr_api.g_varchar2) or
195: nvl(per_pmp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute16, hr_api.g_varchar2) or
197: nvl(per_pmp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute17, hr_api.g_varchar2) or
199: nvl(per_pmp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute18, hr_api.g_varchar2) or
201: nvl(per_pmp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute19, hr_api.g_varchar2) or
203: nvl(per_pmp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute16, hr_api.g_varchar2) or
197: nvl(per_pmp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute17, hr_api.g_varchar2) or
199: nvl(per_pmp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute18, hr_api.g_varchar2) or
201: nvl(per_pmp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute19, hr_api.g_varchar2) or
203: nvl(per_pmp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute20, hr_api.g_varchar2) or
197: nvl(per_pmp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute17, hr_api.g_varchar2) or
199: nvl(per_pmp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute18, hr_api.g_varchar2) or
201: nvl(per_pmp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute19, hr_api.g_varchar2) or
203: nvl(per_pmp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute20, hr_api.g_varchar2) or
205: nvl(per_pmp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute17, hr_api.g_varchar2) or
199: nvl(per_pmp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute18, hr_api.g_varchar2) or
201: nvl(per_pmp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute19, hr_api.g_varchar2) or
203: nvl(per_pmp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute20, hr_api.g_varchar2) or
205: nvl(per_pmp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute21, hr_api.g_varchar2) or
199: nvl(per_pmp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute18, hr_api.g_varchar2) or
201: nvl(per_pmp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute19, hr_api.g_varchar2) or
203: nvl(per_pmp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute20, hr_api.g_varchar2) or
205: nvl(per_pmp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute21, hr_api.g_varchar2) or
207: nvl(per_pmp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute18, hr_api.g_varchar2) or
201: nvl(per_pmp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute19, hr_api.g_varchar2) or
203: nvl(per_pmp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute20, hr_api.g_varchar2) or
205: nvl(per_pmp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute21, hr_api.g_varchar2) or
207: nvl(per_pmp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute22, hr_api.g_varchar2) or
201: nvl(per_pmp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute19, hr_api.g_varchar2) or
203: nvl(per_pmp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute20, hr_api.g_varchar2) or
205: nvl(per_pmp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute21, hr_api.g_varchar2) or
207: nvl(per_pmp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute22, hr_api.g_varchar2) or
209: nvl(per_pmp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute19, hr_api.g_varchar2) or
203: nvl(per_pmp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute20, hr_api.g_varchar2) or
205: nvl(per_pmp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute21, hr_api.g_varchar2) or
207: nvl(per_pmp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute22, hr_api.g_varchar2) or
209: nvl(per_pmp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute23, hr_api.g_varchar2) or
203: nvl(per_pmp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute20, hr_api.g_varchar2) or
205: nvl(per_pmp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute21, hr_api.g_varchar2) or
207: nvl(per_pmp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute22, hr_api.g_varchar2) or
209: nvl(per_pmp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute23, hr_api.g_varchar2) or
211: nvl(per_pmp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute20, hr_api.g_varchar2) or
205: nvl(per_pmp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute21, hr_api.g_varchar2) or
207: nvl(per_pmp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute22, hr_api.g_varchar2) or
209: nvl(per_pmp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute23, hr_api.g_varchar2) or
211: nvl(per_pmp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute24, hr_api.g_varchar2) or
205: nvl(per_pmp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute21, hr_api.g_varchar2) or
207: nvl(per_pmp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute22, hr_api.g_varchar2) or
209: nvl(per_pmp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute23, hr_api.g_varchar2) or
211: nvl(per_pmp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute24, hr_api.g_varchar2) or
213: nvl(per_pmp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute21, hr_api.g_varchar2) or
207: nvl(per_pmp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute22, hr_api.g_varchar2) or
209: nvl(per_pmp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute23, hr_api.g_varchar2) or
211: nvl(per_pmp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute24, hr_api.g_varchar2) or
213: nvl(per_pmp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute25, hr_api.g_varchar2) or
207: nvl(per_pmp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute22, hr_api.g_varchar2) or
209: nvl(per_pmp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute23, hr_api.g_varchar2) or
211: nvl(per_pmp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute24, hr_api.g_varchar2) or
213: nvl(per_pmp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute25, hr_api.g_varchar2) or
215: nvl(per_pmp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute22, hr_api.g_varchar2) or
209: nvl(per_pmp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute23, hr_api.g_varchar2) or
211: nvl(per_pmp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute24, hr_api.g_varchar2) or
213: nvl(per_pmp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute25, hr_api.g_varchar2) or
215: nvl(per_pmp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute26, hr_api.g_varchar2) or
209: nvl(per_pmp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute23, hr_api.g_varchar2) or
211: nvl(per_pmp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute24, hr_api.g_varchar2) or
213: nvl(per_pmp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute25, hr_api.g_varchar2) or
215: nvl(per_pmp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute26, hr_api.g_varchar2) or
217: nvl(per_pmp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute23, hr_api.g_varchar2) or
211: nvl(per_pmp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute24, hr_api.g_varchar2) or
213: nvl(per_pmp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute25, hr_api.g_varchar2) or
215: nvl(per_pmp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute26, hr_api.g_varchar2) or
217: nvl(per_pmp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute27, hr_api.g_varchar2) or
211: nvl(per_pmp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute24, hr_api.g_varchar2) or
213: nvl(per_pmp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute25, hr_api.g_varchar2) or
215: nvl(per_pmp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute26, hr_api.g_varchar2) or
217: nvl(per_pmp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute27, hr_api.g_varchar2) or
219: nvl(per_pmp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute24, hr_api.g_varchar2) or
213: nvl(per_pmp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute25, hr_api.g_varchar2) or
215: nvl(per_pmp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute26, hr_api.g_varchar2) or
217: nvl(per_pmp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute27, hr_api.g_varchar2) or
219: nvl(per_pmp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute28, hr_api.g_varchar2) or
213: nvl(per_pmp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute25, hr_api.g_varchar2) or
215: nvl(per_pmp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute26, hr_api.g_varchar2) or
217: nvl(per_pmp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute27, hr_api.g_varchar2) or
219: nvl(per_pmp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute28, hr_api.g_varchar2) or
221: nvl(per_pmp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute25, hr_api.g_varchar2) or
215: nvl(per_pmp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute26, hr_api.g_varchar2) or
217: nvl(per_pmp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute27, hr_api.g_varchar2) or
219: nvl(per_pmp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute28, hr_api.g_varchar2) or
221: nvl(per_pmp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute29, hr_api.g_varchar2) or
215: nvl(per_pmp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute26, hr_api.g_varchar2) or
217: nvl(per_pmp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute27, hr_api.g_varchar2) or
219: nvl(per_pmp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute28, hr_api.g_varchar2) or
221: nvl(per_pmp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute29, hr_api.g_varchar2) or
223: nvl(per_pmp_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute26, hr_api.g_varchar2) or
217: nvl(per_pmp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute27, hr_api.g_varchar2) or
219: nvl(per_pmp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute28, hr_api.g_varchar2) or
221: nvl(per_pmp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute29, hr_api.g_varchar2) or
223: nvl(per_pmp_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
217: nvl(per_pmp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute27, hr_api.g_varchar2) or
219: nvl(per_pmp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute28, hr_api.g_varchar2) or
221: nvl(per_pmp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute29, hr_api.g_varchar2) or
223: nvl(per_pmp_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
225: or (p_rec.plan_id is null) then
218: nvl(p_rec.attribute27, hr_api.g_varchar2) or
219: nvl(per_pmp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute28, hr_api.g_varchar2) or
221: nvl(per_pmp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute29, hr_api.g_varchar2) or
223: nvl(per_pmp_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
225: or (p_rec.plan_id is null) then
226: --
219: nvl(per_pmp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute28, hr_api.g_varchar2) or
221: nvl(per_pmp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute29, hr_api.g_varchar2) or
223: nvl(per_pmp_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
225: or (p_rec.plan_id is null) then
226: --
227: -- Only execute the validation if absolutely necessary:
220: nvl(p_rec.attribute28, hr_api.g_varchar2) or
221: nvl(per_pmp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute29, hr_api.g_varchar2) or
223: nvl(per_pmp_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
225: or (p_rec.plan_id is null) then
226: --
227: -- Only execute the validation if absolutely necessary:
228: -- a) During update, the structure column value or any
388:
389: cursor csr_plan_name is
390: select 'Y'
391: from per_perf_mgmt_plans pmp
392: where pmp.plan_id <> nvl(p_plan_id, hr_api.g_number)
393: and upper(trim(pmp.plan_name)) = upper(trim(p_plan_name))
394: and (p_start_date between pmp.start_date and pmp.end_date OR
395: pmp.start_date between p_start_date and p_end_date);
396:
404:
405: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 10); END IF;
406:
407: --
408: hr_api.mandatory_arg_error
409: (p_api_name => l_proc
410: ,p_argument => 'p_plan_name'
411: ,p_argument_value => p_plan_name
412: );
420: (p_plan_id => p_plan_id
421: ,p_object_version_number => p_object_version_number);
422: --
423: IF (l_api_updating
424: AND nvl(per_pmp_shd.g_old_rec.plan_name, hr_api.g_varchar2)
425: = nvl(p_plan_name, hr_api.g_varchar2))
426: THEN
427: RETURN;
428: END IF;
421: ,p_object_version_number => p_object_version_number);
422: --
423: IF (l_api_updating
424: AND nvl(per_pmp_shd.g_old_rec.plan_name, hr_api.g_varchar2)
425: = nvl(p_plan_name, hr_api.g_varchar2))
426: THEN
427: RETURN;
428: END IF;
429:
494:
495: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 10); END IF;
496:
497: --
498: hr_api.mandatory_arg_error
499: (p_api_name => l_proc
500: ,p_argument => 'p_administrator_person_id'
501: ,p_argument_value => p_administrator_person_id
502: );
510: (p_plan_id => p_plan_id
511: ,p_object_version_number => p_object_version_number);
512: --
513: IF (l_api_updating
514: AND nvl(per_pmp_shd.g_old_rec.administrator_person_id, hr_api.g_number)
515: = nvl(p_administrator_person_id, hr_api.g_number))
516: THEN
517: RETURN;
518: END IF;
511: ,p_object_version_number => p_object_version_number);
512: --
513: IF (l_api_updating
514: AND nvl(per_pmp_shd.g_old_rec.administrator_person_id, hr_api.g_number)
515: = nvl(p_administrator_person_id, hr_api.g_number))
516: THEN
517: RETURN;
518: END IF;
519:
585: select 'Y'
586: from per_perf_mgmt_plans pmp
587: where pmp.plan_id = p_previous_plan_id
588: and pmp.start_date < p_start_date
589: and pmp.plan_id <> nvl(p_plan_id, hr_api.g_number);
590:
591: cursor csr_plan_overlap is
592: select end_date
593: from per_perf_mgmt_plans pmp
614: (p_plan_id => p_plan_id
615: ,p_object_version_number => p_object_version_number);
616: --
617: IF (l_api_updating
618: AND nvl(per_pmp_shd.g_old_rec.previous_plan_id, hr_api.g_number)
619: = nvl(p_previous_plan_id, hr_api.g_number)
620: AND nvl(per_pmp_shd.g_old_rec.start_date, hr_api.g_date)
621: = nvl(p_start_date, hr_api.g_date))
622: THEN
615: ,p_object_version_number => p_object_version_number);
616: --
617: IF (l_api_updating
618: AND nvl(per_pmp_shd.g_old_rec.previous_plan_id, hr_api.g_number)
619: = nvl(p_previous_plan_id, hr_api.g_number)
620: AND nvl(per_pmp_shd.g_old_rec.start_date, hr_api.g_date)
621: = nvl(p_start_date, hr_api.g_date))
622: THEN
623: RETURN;
616: --
617: IF (l_api_updating
618: AND nvl(per_pmp_shd.g_old_rec.previous_plan_id, hr_api.g_number)
619: = nvl(p_previous_plan_id, hr_api.g_number)
620: AND nvl(per_pmp_shd.g_old_rec.start_date, hr_api.g_date)
621: = nvl(p_start_date, hr_api.g_date))
622: THEN
623: RETURN;
624: END IF;
617: IF (l_api_updating
618: AND nvl(per_pmp_shd.g_old_rec.previous_plan_id, hr_api.g_number)
619: = nvl(p_previous_plan_id, hr_api.g_number)
620: AND nvl(per_pmp_shd.g_old_rec.start_date, hr_api.g_date)
621: = nvl(p_start_date, hr_api.g_date))
622: THEN
623: RETURN;
624: END IF;
625:
715:
716: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 10); END IF;
717:
718: --
719: hr_api.mandatory_arg_error
720: (p_api_name => l_proc
721: ,p_argument => 'p_start_date'
722: ,p_argument_value => p_start_date
723: );
721: ,p_argument => 'p_start_date'
722: ,p_argument_value => p_start_date
723: );
724: --
725: hr_api.mandatory_arg_error
726: (p_api_name => l_proc
727: ,p_argument => 'p_end_date'
728: ,p_argument_value => p_end_date
729: );
737: (p_plan_id => p_plan_id
738: ,p_object_version_number => p_object_version_number);
739: --
740: IF (l_api_updating
741: AND nvl(per_pmp_shd.g_old_rec.start_date, hr_api.g_date)
742: = nvl(p_start_date, hr_api.g_date)
743: AND nvl(per_pmp_shd.g_old_rec.end_date, hr_api.g_date)
744: = nvl(p_end_date, hr_api.g_date))
745: THEN
738: ,p_object_version_number => p_object_version_number);
739: --
740: IF (l_api_updating
741: AND nvl(per_pmp_shd.g_old_rec.start_date, hr_api.g_date)
742: = nvl(p_start_date, hr_api.g_date)
743: AND nvl(per_pmp_shd.g_old_rec.end_date, hr_api.g_date)
744: = nvl(p_end_date, hr_api.g_date))
745: THEN
746: RETURN;
739: --
740: IF (l_api_updating
741: AND nvl(per_pmp_shd.g_old_rec.start_date, hr_api.g_date)
742: = nvl(p_start_date, hr_api.g_date)
743: AND nvl(per_pmp_shd.g_old_rec.end_date, hr_api.g_date)
744: = nvl(p_end_date, hr_api.g_date))
745: THEN
746: RETURN;
747: END IF;
740: IF (l_api_updating
741: AND nvl(per_pmp_shd.g_old_rec.start_date, hr_api.g_date)
742: = nvl(p_start_date, hr_api.g_date)
743: AND nvl(per_pmp_shd.g_old_rec.end_date, hr_api.g_date)
744: = nvl(p_end_date, hr_api.g_date))
745: THEN
746: RETURN;
747: END IF;
748:
758: --
759: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;
760: --
761: IF (l_api_updating AND p_status_code <> 'DRAFT' AND
762: nvl(per_pmp_shd.g_old_rec.start_date, hr_api.g_date)
763: <> nvl(p_start_date, hr_api.g_date))
764: THEN
765: fnd_message.set_name('PER','HR_50395_WPM_ST_DATE_UPD');
766: fnd_message.raise_error;
759: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;
760: --
761: IF (l_api_updating AND p_status_code <> 'DRAFT' AND
762: nvl(per_pmp_shd.g_old_rec.start_date, hr_api.g_date)
763: <> nvl(p_start_date, hr_api.g_date))
764: THEN
765: fnd_message.set_name('PER','HR_50395_WPM_ST_DATE_UPD');
766: fnd_message.raise_error;
767: END IF;
823:
824: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 10); END IF;
825:
826: --
827: hr_api.mandatory_arg_error
828: (p_api_name => l_proc
829: ,p_argument => 'p_status_code'
830: ,p_argument_value => p_status_code
831: );
838: (p_plan_id => p_plan_id
839: ,p_object_version_number => p_object_version_number);
840: --
841: IF (l_api_updating
842: AND nvl(per_pmp_shd.g_old_rec.status_code, hr_api.g_varchar2)
843: = nvl(p_status_code, hr_api.g_varchar2))
844: THEN
845: RETURN;
846: END IF;
839: ,p_object_version_number => p_object_version_number);
840: --
841: IF (l_api_updating
842: AND nvl(per_pmp_shd.g_old_rec.status_code, hr_api.g_varchar2)
843: = nvl(p_status_code, hr_api.g_varchar2))
844: THEN
845: RETURN;
846: END IF;
847:
849:
850: --
851: -- Checks that the status code is valid
852: --
853: IF hr_api.not_exists_in_hrstanlookups
854: (p_effective_date => p_effective_date
855: ,p_lookup_type => 'HR_WPM_PLAN_STATUS'
856: ,p_lookup_code => p_status_code
857: ) THEN
924: (p_plan_id => p_plan_id
925: ,p_object_version_number => p_object_version_number);
926: --
927: IF (l_api_updating
928: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
929: = nvl(p_hierarchy_type_code, hr_api.g_varchar2))
930: THEN
931: RETURN;
932: END IF;
925: ,p_object_version_number => p_object_version_number);
926: --
927: IF (l_api_updating
928: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
929: = nvl(p_hierarchy_type_code, hr_api.g_varchar2))
930: THEN
931: RETURN;
932: END IF;
933:
936: --
937: -- Checks that the hierarchy type is valid
938: --
939: IF (p_hierarchy_type_code IS NOT NULL) THEN
940: IF hr_api.not_exists_in_hrstanlookups
941: (p_effective_date => p_effective_date
942: ,p_lookup_type => 'HR_WPM_PLAN_HIER_TYPE'
943: ,p_lookup_code => p_hierarchy_type_code
944: ) THEN
1020: (p_plan_id => p_plan_id
1021: ,p_object_version_number => p_object_version_number);
1022: --
1023: IF (l_api_updating
1024: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
1025: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
1026: AND nvl(per_pmp_shd.g_old_rec.supervisor_id, hr_api.g_number)
1027: = nvl(p_supervisor_id, hr_api.g_number))
1028: THEN
1021: ,p_object_version_number => p_object_version_number);
1022: --
1023: IF (l_api_updating
1024: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
1025: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
1026: AND nvl(per_pmp_shd.g_old_rec.supervisor_id, hr_api.g_number)
1027: = nvl(p_supervisor_id, hr_api.g_number))
1028: THEN
1029: RETURN;
1022: --
1023: IF (l_api_updating
1024: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
1025: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
1026: AND nvl(per_pmp_shd.g_old_rec.supervisor_id, hr_api.g_number)
1027: = nvl(p_supervisor_id, hr_api.g_number))
1028: THEN
1029: RETURN;
1030: END IF;
1023: IF (l_api_updating
1024: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
1025: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
1026: AND nvl(per_pmp_shd.g_old_rec.supervisor_id, hr_api.g_number)
1027: = nvl(p_supervisor_id, hr_api.g_number))
1028: THEN
1029: RETURN;
1030: END IF;
1031:
1035: -- Validate the parameter has been entered.
1036: --
1037: IF p_hierarchy_type_code IS NOT null AND
1038: p_hierarchy_type_code = 'SUP' THEN
1039: hr_api.mandatory_arg_error
1040: (p_api_name => l_proc
1041: ,p_argument => 'p_supervisor_id'
1042: ,p_argument_value => p_supervisor_id
1043: );
1132: (p_plan_id => p_plan_id
1133: ,p_object_version_number => p_object_version_number);
1134: --
1135: IF (l_api_updating
1136: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
1137: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
1138: AND nvl(per_pmp_shd.g_old_rec.supervisor_assignment_id, hr_api.g_number)
1139: = nvl(p_supervisor_assignment_id, hr_api.g_number))
1140: THEN
1133: ,p_object_version_number => p_object_version_number);
1134: --
1135: IF (l_api_updating
1136: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
1137: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
1138: AND nvl(per_pmp_shd.g_old_rec.supervisor_assignment_id, hr_api.g_number)
1139: = nvl(p_supervisor_assignment_id, hr_api.g_number))
1140: THEN
1141: RETURN;
1134: --
1135: IF (l_api_updating
1136: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
1137: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
1138: AND nvl(per_pmp_shd.g_old_rec.supervisor_assignment_id, hr_api.g_number)
1139: = nvl(p_supervisor_assignment_id, hr_api.g_number))
1140: THEN
1141: RETURN;
1142: END IF;
1135: IF (l_api_updating
1136: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
1137: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
1138: AND nvl(per_pmp_shd.g_old_rec.supervisor_assignment_id, hr_api.g_number)
1139: = nvl(p_supervisor_assignment_id, hr_api.g_number))
1140: THEN
1141: RETURN;
1142: END IF;
1143:
1146: -- Validate the parameter has been entered.
1147: --
1148: IF p_hierarchy_type_code IS NOT null AND
1149: p_hierarchy_type_code = 'SUP_ASG' THEN
1150: hr_api.mandatory_arg_error
1151: (p_api_name => l_proc
1152: ,p_argument => 'p_supervisor_assignment_id'
1153: ,p_argument_value => p_supervisor_assignment_id
1154: );
1241: (p_plan_id => p_plan_id
1242: ,p_object_version_number => p_object_version_number);
1243: --
1244: IF (l_api_updating
1245: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
1246: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
1247: AND nvl(per_pmp_shd.g_old_rec.organization_structure_id, hr_api.g_number)
1248: = nvl(p_organization_structure_id, hr_api.g_number))
1249: THEN
1242: ,p_object_version_number => p_object_version_number);
1243: --
1244: IF (l_api_updating
1245: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
1246: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
1247: AND nvl(per_pmp_shd.g_old_rec.organization_structure_id, hr_api.g_number)
1248: = nvl(p_organization_structure_id, hr_api.g_number))
1249: THEN
1250: RETURN;
1243: --
1244: IF (l_api_updating
1245: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
1246: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
1247: AND nvl(per_pmp_shd.g_old_rec.organization_structure_id, hr_api.g_number)
1248: = nvl(p_organization_structure_id, hr_api.g_number))
1249: THEN
1250: RETURN;
1251: END IF;
1244: IF (l_api_updating
1245: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
1246: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
1247: AND nvl(per_pmp_shd.g_old_rec.organization_structure_id, hr_api.g_number)
1248: = nvl(p_organization_structure_id, hr_api.g_number))
1249: THEN
1250: RETURN;
1251: END IF;
1252:
1256: -- Validate the parameter has been entered.
1257: --
1258: IF p_hierarchy_type_code IS NOT null AND
1259: p_hierarchy_type_code = 'ORG' THEN
1260: hr_api.mandatory_arg_error
1261: (p_api_name => l_proc
1262: ,p_argument => 'p_organization_structure_id'
1263: ,p_argument_value => p_organization_structure_id
1264: );
1351: (p_plan_id => p_plan_id
1352: ,p_object_version_number => p_object_version_number);
1353: --
1354: IF (l_api_updating
1355: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
1356: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
1357: AND nvl(per_pmp_shd.g_old_rec.org_structure_version_id, hr_api.g_number)
1358: = nvl(p_org_structure_version_id, hr_api.g_number))
1359: THEN
1352: ,p_object_version_number => p_object_version_number);
1353: --
1354: IF (l_api_updating
1355: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
1356: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
1357: AND nvl(per_pmp_shd.g_old_rec.org_structure_version_id, hr_api.g_number)
1358: = nvl(p_org_structure_version_id, hr_api.g_number))
1359: THEN
1360: RETURN;
1353: --
1354: IF (l_api_updating
1355: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
1356: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
1357: AND nvl(per_pmp_shd.g_old_rec.org_structure_version_id, hr_api.g_number)
1358: = nvl(p_org_structure_version_id, hr_api.g_number))
1359: THEN
1360: RETURN;
1361: END IF;
1354: IF (l_api_updating
1355: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
1356: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
1357: AND nvl(per_pmp_shd.g_old_rec.org_structure_version_id, hr_api.g_number)
1358: = nvl(p_org_structure_version_id, hr_api.g_number))
1359: THEN
1360: RETURN;
1361: END IF;
1362:
1366: -- Validate the parameter has been entered.
1367: --
1368: IF p_hierarchy_type_code IS NOT null AND
1369: p_hierarchy_type_code = 'ORG' THEN
1370: hr_api.mandatory_arg_error
1371: (p_api_name => l_proc
1372: ,p_argument => 'p_org_structure_version_id'
1373: ,p_argument_value => p_org_structure_version_id
1374: );
1461: (p_plan_id => p_plan_id
1462: ,p_object_version_number => p_object_version_number);
1463: --
1464: IF (l_api_updating
1465: AND nvl(per_pmp_shd.g_old_rec.organization_structure_id, hr_api.g_number)
1466: = nvl(p_organization_structure_id, hr_api.g_number)
1467: AND nvl(per_pmp_shd.g_old_rec.org_structure_version_id, hr_api.g_number)
1468: = nvl(p_org_structure_version_id, hr_api.g_number))
1469: THEN
1462: ,p_object_version_number => p_object_version_number);
1463: --
1464: IF (l_api_updating
1465: AND nvl(per_pmp_shd.g_old_rec.organization_structure_id, hr_api.g_number)
1466: = nvl(p_organization_structure_id, hr_api.g_number)
1467: AND nvl(per_pmp_shd.g_old_rec.org_structure_version_id, hr_api.g_number)
1468: = nvl(p_org_structure_version_id, hr_api.g_number))
1469: THEN
1470: RETURN;
1463: --
1464: IF (l_api_updating
1465: AND nvl(per_pmp_shd.g_old_rec.organization_structure_id, hr_api.g_number)
1466: = nvl(p_organization_structure_id, hr_api.g_number)
1467: AND nvl(per_pmp_shd.g_old_rec.org_structure_version_id, hr_api.g_number)
1468: = nvl(p_org_structure_version_id, hr_api.g_number))
1469: THEN
1470: RETURN;
1471: END IF;
1464: IF (l_api_updating
1465: AND nvl(per_pmp_shd.g_old_rec.organization_structure_id, hr_api.g_number)
1466: = nvl(p_organization_structure_id, hr_api.g_number)
1467: AND nvl(per_pmp_shd.g_old_rec.org_structure_version_id, hr_api.g_number)
1468: = nvl(p_org_structure_version_id, hr_api.g_number))
1469: THEN
1470: RETURN;
1471: END IF;
1472:
1564: (p_plan_id => p_plan_id
1565: ,p_object_version_number => p_object_version_number);
1566: --
1567: IF (l_api_updating
1568: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
1569: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
1570: AND nvl(per_pmp_shd.g_old_rec.org_structure_version_id, hr_api.g_number)
1571: = nvl(p_org_structure_version_id, hr_api.g_number)
1572: AND nvl(per_pmp_shd.g_old_rec.top_organization_id, hr_api.g_number)
1565: ,p_object_version_number => p_object_version_number);
1566: --
1567: IF (l_api_updating
1568: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
1569: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
1570: AND nvl(per_pmp_shd.g_old_rec.org_structure_version_id, hr_api.g_number)
1571: = nvl(p_org_structure_version_id, hr_api.g_number)
1572: AND nvl(per_pmp_shd.g_old_rec.top_organization_id, hr_api.g_number)
1573: = nvl(p_top_organization_id, hr_api.g_number))
1566: --
1567: IF (l_api_updating
1568: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
1569: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
1570: AND nvl(per_pmp_shd.g_old_rec.org_structure_version_id, hr_api.g_number)
1571: = nvl(p_org_structure_version_id, hr_api.g_number)
1572: AND nvl(per_pmp_shd.g_old_rec.top_organization_id, hr_api.g_number)
1573: = nvl(p_top_organization_id, hr_api.g_number))
1574: THEN
1567: IF (l_api_updating
1568: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
1569: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
1570: AND nvl(per_pmp_shd.g_old_rec.org_structure_version_id, hr_api.g_number)
1571: = nvl(p_org_structure_version_id, hr_api.g_number)
1572: AND nvl(per_pmp_shd.g_old_rec.top_organization_id, hr_api.g_number)
1573: = nvl(p_top_organization_id, hr_api.g_number))
1574: THEN
1575: RETURN;
1568: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
1569: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
1570: AND nvl(per_pmp_shd.g_old_rec.org_structure_version_id, hr_api.g_number)
1571: = nvl(p_org_structure_version_id, hr_api.g_number)
1572: AND nvl(per_pmp_shd.g_old_rec.top_organization_id, hr_api.g_number)
1573: = nvl(p_top_organization_id, hr_api.g_number))
1574: THEN
1575: RETURN;
1576: END IF;
1569: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
1570: AND nvl(per_pmp_shd.g_old_rec.org_structure_version_id, hr_api.g_number)
1571: = nvl(p_org_structure_version_id, hr_api.g_number)
1572: AND nvl(per_pmp_shd.g_old_rec.top_organization_id, hr_api.g_number)
1573: = nvl(p_top_organization_id, hr_api.g_number))
1574: THEN
1575: RETURN;
1576: END IF;
1577:
1579: -- Validate the parameter has been entered.
1580: --
1581: IF p_hierarchy_type_code IS NOT null AND
1582: p_hierarchy_type_code = 'ORG' THEN
1583: hr_api.mandatory_arg_error
1584: (p_api_name => l_proc
1585: ,p_argument => 'p_top_organization_id'
1586: ,p_argument_value => p_top_organization_id
1587: );
1676: (p_plan_id => p_plan_id
1677: ,p_object_version_number => p_object_version_number);
1678: --
1679: IF (l_api_updating
1680: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
1681: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
1682: AND nvl(per_pmp_shd.g_old_rec.position_structure_id, hr_api.g_number)
1683: = nvl(p_position_structure_id, hr_api.g_number))
1684: THEN
1677: ,p_object_version_number => p_object_version_number);
1678: --
1679: IF (l_api_updating
1680: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
1681: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
1682: AND nvl(per_pmp_shd.g_old_rec.position_structure_id, hr_api.g_number)
1683: = nvl(p_position_structure_id, hr_api.g_number))
1684: THEN
1685: RETURN;
1678: --
1679: IF (l_api_updating
1680: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
1681: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
1682: AND nvl(per_pmp_shd.g_old_rec.position_structure_id, hr_api.g_number)
1683: = nvl(p_position_structure_id, hr_api.g_number))
1684: THEN
1685: RETURN;
1686: END IF;
1679: IF (l_api_updating
1680: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
1681: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
1682: AND nvl(per_pmp_shd.g_old_rec.position_structure_id, hr_api.g_number)
1683: = nvl(p_position_structure_id, hr_api.g_number))
1684: THEN
1685: RETURN;
1686: END IF;
1687:
1689: -- Validate the parameter has been entered.
1690: --
1691: IF p_hierarchy_type_code IS NOT null AND
1692: p_hierarchy_type_code = 'POS' THEN
1693: hr_api.mandatory_arg_error
1694: (p_api_name => l_proc
1695: ,p_argument => 'p_position_structure_id'
1696: ,p_argument_value => p_position_structure_id
1697: );
1786: (p_plan_id => p_plan_id
1787: ,p_object_version_number => p_object_version_number);
1788: --
1789: IF (l_api_updating
1790: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
1791: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
1792: AND nvl(per_pmp_shd.g_old_rec.pos_structure_version_id, hr_api.g_number)
1793: = nvl(p_pos_structure_version_id, hr_api.g_number))
1794: THEN
1787: ,p_object_version_number => p_object_version_number);
1788: --
1789: IF (l_api_updating
1790: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
1791: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
1792: AND nvl(per_pmp_shd.g_old_rec.pos_structure_version_id, hr_api.g_number)
1793: = nvl(p_pos_structure_version_id, hr_api.g_number))
1794: THEN
1795: RETURN;
1788: --
1789: IF (l_api_updating
1790: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
1791: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
1792: AND nvl(per_pmp_shd.g_old_rec.pos_structure_version_id, hr_api.g_number)
1793: = nvl(p_pos_structure_version_id, hr_api.g_number))
1794: THEN
1795: RETURN;
1796: END IF;
1789: IF (l_api_updating
1790: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
1791: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
1792: AND nvl(per_pmp_shd.g_old_rec.pos_structure_version_id, hr_api.g_number)
1793: = nvl(p_pos_structure_version_id, hr_api.g_number))
1794: THEN
1795: RETURN;
1796: END IF;
1797:
1801: -- Validate the parameter has been entered.
1802: --
1803: IF p_hierarchy_type_code IS NOT null AND
1804: p_hierarchy_type_code = 'POS' THEN
1805: hr_api.mandatory_arg_error
1806: (p_api_name => l_proc
1807: ,p_argument => 'p_pos_structure_version_id'
1808: ,p_argument_value => p_pos_structure_version_id
1809: );
1896: (p_plan_id => p_plan_id
1897: ,p_object_version_number => p_object_version_number);
1898: --
1899: IF (l_api_updating
1900: AND nvl(per_pmp_shd.g_old_rec.position_structure_id, hr_api.g_number)
1901: = nvl(p_position_structure_id, hr_api.g_number)
1902: AND nvl(per_pmp_shd.g_old_rec.pos_structure_version_id, hr_api.g_number)
1903: = nvl(p_pos_structure_version_id, hr_api.g_number))
1904: THEN
1897: ,p_object_version_number => p_object_version_number);
1898: --
1899: IF (l_api_updating
1900: AND nvl(per_pmp_shd.g_old_rec.position_structure_id, hr_api.g_number)
1901: = nvl(p_position_structure_id, hr_api.g_number)
1902: AND nvl(per_pmp_shd.g_old_rec.pos_structure_version_id, hr_api.g_number)
1903: = nvl(p_pos_structure_version_id, hr_api.g_number))
1904: THEN
1905: RETURN;
1898: --
1899: IF (l_api_updating
1900: AND nvl(per_pmp_shd.g_old_rec.position_structure_id, hr_api.g_number)
1901: = nvl(p_position_structure_id, hr_api.g_number)
1902: AND nvl(per_pmp_shd.g_old_rec.pos_structure_version_id, hr_api.g_number)
1903: = nvl(p_pos_structure_version_id, hr_api.g_number))
1904: THEN
1905: RETURN;
1906: END IF;
1899: IF (l_api_updating
1900: AND nvl(per_pmp_shd.g_old_rec.position_structure_id, hr_api.g_number)
1901: = nvl(p_position_structure_id, hr_api.g_number)
1902: AND nvl(per_pmp_shd.g_old_rec.pos_structure_version_id, hr_api.g_number)
1903: = nvl(p_pos_structure_version_id, hr_api.g_number))
1904: THEN
1905: RETURN;
1906: END IF;
1907:
1999: (p_plan_id => p_plan_id
2000: ,p_object_version_number => p_object_version_number);
2001: --
2002: IF (l_api_updating
2003: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
2004: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
2005: AND nvl(per_pmp_shd.g_old_rec.pos_structure_version_id, hr_api.g_number)
2006: = nvl(p_pos_structure_version_id, hr_api.g_number)
2007: AND nvl(per_pmp_shd.g_old_rec.top_position_id, hr_api.g_number)
2000: ,p_object_version_number => p_object_version_number);
2001: --
2002: IF (l_api_updating
2003: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
2004: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
2005: AND nvl(per_pmp_shd.g_old_rec.pos_structure_version_id, hr_api.g_number)
2006: = nvl(p_pos_structure_version_id, hr_api.g_number)
2007: AND nvl(per_pmp_shd.g_old_rec.top_position_id, hr_api.g_number)
2008: = nvl(p_top_position_id, hr_api.g_number))
2001: --
2002: IF (l_api_updating
2003: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
2004: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
2005: AND nvl(per_pmp_shd.g_old_rec.pos_structure_version_id, hr_api.g_number)
2006: = nvl(p_pos_structure_version_id, hr_api.g_number)
2007: AND nvl(per_pmp_shd.g_old_rec.top_position_id, hr_api.g_number)
2008: = nvl(p_top_position_id, hr_api.g_number))
2009: THEN
2002: IF (l_api_updating
2003: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
2004: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
2005: AND nvl(per_pmp_shd.g_old_rec.pos_structure_version_id, hr_api.g_number)
2006: = nvl(p_pos_structure_version_id, hr_api.g_number)
2007: AND nvl(per_pmp_shd.g_old_rec.top_position_id, hr_api.g_number)
2008: = nvl(p_top_position_id, hr_api.g_number))
2009: THEN
2010: RETURN;
2003: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
2004: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
2005: AND nvl(per_pmp_shd.g_old_rec.pos_structure_version_id, hr_api.g_number)
2006: = nvl(p_pos_structure_version_id, hr_api.g_number)
2007: AND nvl(per_pmp_shd.g_old_rec.top_position_id, hr_api.g_number)
2008: = nvl(p_top_position_id, hr_api.g_number))
2009: THEN
2010: RETURN;
2011: END IF;
2004: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
2005: AND nvl(per_pmp_shd.g_old_rec.pos_structure_version_id, hr_api.g_number)
2006: = nvl(p_pos_structure_version_id, hr_api.g_number)
2007: AND nvl(per_pmp_shd.g_old_rec.top_position_id, hr_api.g_number)
2008: = nvl(p_top_position_id, hr_api.g_number))
2009: THEN
2010: RETURN;
2011: END IF;
2012:
2016: -- Validate the parameter has been entered.
2017: --
2018: IF p_hierarchy_type_code IS NOT null AND
2019: p_hierarchy_type_code = 'POS' THEN
2020: hr_api.mandatory_arg_error
2021: (p_api_name => l_proc
2022: ,p_argument => 'p_top_position_id'
2023: ,p_argument_value => p_top_position_id
2024: );
2101: (p_plan_id => p_plan_id
2102: ,p_object_version_number => p_object_version_number);
2103: --
2104: IF (l_api_updating
2105: AND nvl(per_pmp_shd.g_old_rec.hierarchy_levels, hr_api.g_number)
2106: = nvl(p_hierarchy_levels, hr_api.g_number))
2107: THEN
2108: RETURN;
2109: END IF;
2102: ,p_object_version_number => p_object_version_number);
2103: --
2104: IF (l_api_updating
2105: AND nvl(per_pmp_shd.g_old_rec.hierarchy_levels, hr_api.g_number)
2106: = nvl(p_hierarchy_levels, hr_api.g_number))
2107: THEN
2108: RETURN;
2109: END IF;
2110:
2173: Begin
2174:
2175: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 10); END IF;
2176: --
2177: hr_api.mandatory_arg_error
2178: (p_api_name => l_proc
2179: ,p_argument => 'p_automatic_enrollment_flag'
2180: ,p_argument_value => p_automatic_enrollment_flag
2181: );
2188: (p_plan_id => p_plan_id
2189: ,p_object_version_number => p_object_version_number);
2190: --
2191: IF (l_api_updating
2192: AND nvl(per_pmp_shd.g_old_rec.automatic_enrollment_flag, hr_api.g_varchar2)
2193: = nvl(p_automatic_enrollment_flag, hr_api.g_varchar2))
2194: THEN
2195: RETURN;
2196: END IF;
2189: ,p_object_version_number => p_object_version_number);
2190: --
2191: IF (l_api_updating
2192: AND nvl(per_pmp_shd.g_old_rec.automatic_enrollment_flag, hr_api.g_varchar2)
2193: = nvl(p_automatic_enrollment_flag, hr_api.g_varchar2))
2194: THEN
2195: RETURN;
2196: END IF;
2197:
2199:
2200: --
2201: -- Checks that the status code is valid
2202: --
2203: IF hr_api.not_exists_in_hrstanlookups
2204: (p_effective_date => p_effective_date
2205: ,p_lookup_type => 'YES_NO'
2206: ,p_lookup_code => p_automatic_enrollment_flag
2207: ) THEN
2264: Begin
2265:
2266: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 10); END IF;
2267: --
2268: hr_api.mandatory_arg_error
2269: (p_api_name => l_proc
2270: ,p_argument => 'p_assignment_types_code'
2271: ,p_argument_value => p_assignment_types_code
2272: );
2279: (p_plan_id => p_plan_id
2280: ,p_object_version_number => p_object_version_number);
2281: --
2282: IF (l_api_updating
2283: AND nvl(per_pmp_shd.g_old_rec.assignment_types_code, hr_api.g_varchar2)
2284: = nvl(p_assignment_types_code, hr_api.g_varchar2))
2285: THEN
2286: RETURN;
2287: END IF;
2280: ,p_object_version_number => p_object_version_number);
2281: --
2282: IF (l_api_updating
2283: AND nvl(per_pmp_shd.g_old_rec.assignment_types_code, hr_api.g_varchar2)
2284: = nvl(p_assignment_types_code, hr_api.g_varchar2))
2285: THEN
2286: RETURN;
2287: END IF;
2288:
2290:
2291: --
2292: -- Checks that the status code is valid
2293: --
2294: IF hr_api.not_exists_in_hrstanlookups
2295: (p_effective_date => p_effective_date
2296: ,p_lookup_type => 'HR_WPM_ASSIGNMENT_TYPES'
2297: ,p_lookup_code => p_assignment_types_code
2298: ) THEN
2355: Begin
2356:
2357: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 10); END IF;
2358: --
2359: hr_api.mandatory_arg_error
2360: (p_api_name => l_proc
2361: ,p_argument => 'p_primary_asg_only_flag'
2362: ,p_argument_value => p_primary_asg_only_flag
2363: );
2370: (p_plan_id => p_plan_id
2371: ,p_object_version_number => p_object_version_number);
2372: --
2373: IF (l_api_updating
2374: AND nvl(per_pmp_shd.g_old_rec.primary_asg_only_flag, hr_api.g_varchar2)
2375: = nvl(p_primary_asg_only_flag, hr_api.g_varchar2))
2376: THEN
2377: RETURN;
2378: END IF;
2371: ,p_object_version_number => p_object_version_number);
2372: --
2373: IF (l_api_updating
2374: AND nvl(per_pmp_shd.g_old_rec.primary_asg_only_flag, hr_api.g_varchar2)
2375: = nvl(p_primary_asg_only_flag, hr_api.g_varchar2))
2376: THEN
2377: RETURN;
2378: END IF;
2379:
2381:
2382: --
2383: -- Checks that the status code is valid
2384: --
2385: IF hr_api.not_exists_in_hrstanlookups
2386: (p_effective_date => p_effective_date
2387: ,p_lookup_type => 'YES_NO'
2388: ,p_lookup_code => p_primary_asg_only_flag
2389: ) THEN
2448: Begin
2449:
2450: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 10); END IF;
2451: --
2452: hr_api.mandatory_arg_error
2453: (p_api_name => l_proc
2454: ,p_argument => 'p_primary_asg_only_flag'
2455: ,p_argument_value => p_primary_asg_only_flag
2456: );
2463: (p_plan_id => p_plan_id
2464: ,p_object_version_number => p_object_version_number);
2465: --
2466: IF (l_api_updating
2467: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
2468: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
2469: AND nvl(per_pmp_shd.g_old_rec.primary_asg_only_flag, hr_api.g_varchar2)
2470: = nvl(p_primary_asg_only_flag, hr_api.g_varchar2))
2471: THEN
2464: ,p_object_version_number => p_object_version_number);
2465: --
2466: IF (l_api_updating
2467: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
2468: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
2469: AND nvl(per_pmp_shd.g_old_rec.primary_asg_only_flag, hr_api.g_varchar2)
2470: = nvl(p_primary_asg_only_flag, hr_api.g_varchar2))
2471: THEN
2472: RETURN;
2465: --
2466: IF (l_api_updating
2467: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
2468: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
2469: AND nvl(per_pmp_shd.g_old_rec.primary_asg_only_flag, hr_api.g_varchar2)
2470: = nvl(p_primary_asg_only_flag, hr_api.g_varchar2))
2471: THEN
2472: RETURN;
2473: END IF;
2466: IF (l_api_updating
2467: AND nvl(per_pmp_shd.g_old_rec.hierarchy_type_code, hr_api.g_varchar2)
2468: = nvl(p_hierarchy_type_code, hr_api.g_varchar2)
2469: AND nvl(per_pmp_shd.g_old_rec.primary_asg_only_flag, hr_api.g_varchar2)
2470: = nvl(p_primary_asg_only_flag, hr_api.g_varchar2))
2471: THEN
2472: RETURN;
2473: END IF;
2474:
2544: Begin
2545:
2546: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 10); END IF;
2547: --
2548: hr_api.mandatory_arg_error
2549: (p_api_name => l_proc
2550: ,p_argument => 'p_include_obj_setting_flag'
2551: ,p_argument_value => p_include_obj_setting_flag
2552: );
2559: (p_plan_id => p_plan_id
2560: ,p_object_version_number => p_object_version_number);
2561: --
2562: IF (l_api_updating
2563: AND nvl(per_pmp_shd.g_old_rec.include_obj_setting_flag, hr_api.g_varchar2)
2564: = nvl(p_include_obj_setting_flag, hr_api.g_varchar2)
2565: AND nvl(per_pmp_shd.g_old_rec.obj_setting_start_date, hr_api.g_date)
2566: = nvl(p_obj_setting_start_date, hr_api.g_date)
2567: AND nvl(per_pmp_shd.g_old_rec.method_code, hr_api.g_varchar2)
2560: ,p_object_version_number => p_object_version_number);
2561: --
2562: IF (l_api_updating
2563: AND nvl(per_pmp_shd.g_old_rec.include_obj_setting_flag, hr_api.g_varchar2)
2564: = nvl(p_include_obj_setting_flag, hr_api.g_varchar2)
2565: AND nvl(per_pmp_shd.g_old_rec.obj_setting_start_date, hr_api.g_date)
2566: = nvl(p_obj_setting_start_date, hr_api.g_date)
2567: AND nvl(per_pmp_shd.g_old_rec.method_code, hr_api.g_varchar2)
2568: = nvl(p_method_code, hr_api.g_varchar2)
2561: --
2562: IF (l_api_updating
2563: AND nvl(per_pmp_shd.g_old_rec.include_obj_setting_flag, hr_api.g_varchar2)
2564: = nvl(p_include_obj_setting_flag, hr_api.g_varchar2)
2565: AND nvl(per_pmp_shd.g_old_rec.obj_setting_start_date, hr_api.g_date)
2566: = nvl(p_obj_setting_start_date, hr_api.g_date)
2567: AND nvl(per_pmp_shd.g_old_rec.method_code, hr_api.g_varchar2)
2568: = nvl(p_method_code, hr_api.g_varchar2)
2569: AND nvl(per_pmp_shd.g_old_rec.notify_population_flag, hr_api.g_varchar2)
2562: IF (l_api_updating
2563: AND nvl(per_pmp_shd.g_old_rec.include_obj_setting_flag, hr_api.g_varchar2)
2564: = nvl(p_include_obj_setting_flag, hr_api.g_varchar2)
2565: AND nvl(per_pmp_shd.g_old_rec.obj_setting_start_date, hr_api.g_date)
2566: = nvl(p_obj_setting_start_date, hr_api.g_date)
2567: AND nvl(per_pmp_shd.g_old_rec.method_code, hr_api.g_varchar2)
2568: = nvl(p_method_code, hr_api.g_varchar2)
2569: AND nvl(per_pmp_shd.g_old_rec.notify_population_flag, hr_api.g_varchar2)
2570: = nvl(p_notify_population_flag, hr_api.g_varchar2))
2563: AND nvl(per_pmp_shd.g_old_rec.include_obj_setting_flag, hr_api.g_varchar2)
2564: = nvl(p_include_obj_setting_flag, hr_api.g_varchar2)
2565: AND nvl(per_pmp_shd.g_old_rec.obj_setting_start_date, hr_api.g_date)
2566: = nvl(p_obj_setting_start_date, hr_api.g_date)
2567: AND nvl(per_pmp_shd.g_old_rec.method_code, hr_api.g_varchar2)
2568: = nvl(p_method_code, hr_api.g_varchar2)
2569: AND nvl(per_pmp_shd.g_old_rec.notify_population_flag, hr_api.g_varchar2)
2570: = nvl(p_notify_population_flag, hr_api.g_varchar2))
2571: THEN
2564: = nvl(p_include_obj_setting_flag, hr_api.g_varchar2)
2565: AND nvl(per_pmp_shd.g_old_rec.obj_setting_start_date, hr_api.g_date)
2566: = nvl(p_obj_setting_start_date, hr_api.g_date)
2567: AND nvl(per_pmp_shd.g_old_rec.method_code, hr_api.g_varchar2)
2568: = nvl(p_method_code, hr_api.g_varchar2)
2569: AND nvl(per_pmp_shd.g_old_rec.notify_population_flag, hr_api.g_varchar2)
2570: = nvl(p_notify_population_flag, hr_api.g_varchar2))
2571: THEN
2572: RETURN;
2565: AND nvl(per_pmp_shd.g_old_rec.obj_setting_start_date, hr_api.g_date)
2566: = nvl(p_obj_setting_start_date, hr_api.g_date)
2567: AND nvl(per_pmp_shd.g_old_rec.method_code, hr_api.g_varchar2)
2568: = nvl(p_method_code, hr_api.g_varchar2)
2569: AND nvl(per_pmp_shd.g_old_rec.notify_population_flag, hr_api.g_varchar2)
2570: = nvl(p_notify_population_flag, hr_api.g_varchar2))
2571: THEN
2572: RETURN;
2573: END IF;
2566: = nvl(p_obj_setting_start_date, hr_api.g_date)
2567: AND nvl(per_pmp_shd.g_old_rec.method_code, hr_api.g_varchar2)
2568: = nvl(p_method_code, hr_api.g_varchar2)
2569: AND nvl(per_pmp_shd.g_old_rec.notify_population_flag, hr_api.g_varchar2)
2570: = nvl(p_notify_population_flag, hr_api.g_varchar2))
2571: THEN
2572: RETURN;
2573: END IF;
2574:
2576:
2577: --
2578: -- Checks that the status code is valid
2579: --
2580: IF hr_api.not_exists_in_hrstanlookups
2581: (p_effective_date => p_effective_date
2582: ,p_lookup_type => 'YES_NO'
2583: ,p_lookup_code => p_include_obj_setting_flag
2584: ) THEN
2592: -- If flag is set to 'Y' , then check floowing mandatory fields are entered
2593: --
2594: IF (p_include_obj_setting_flag = 'Y') THEN
2595: --
2596: hr_api.mandatory_arg_error
2597: (p_api_name => l_proc
2598: ,p_argument => 'p_obj_setting_start_date'
2599: ,p_argument_value => p_obj_setting_start_date
2600: );
2598: ,p_argument => 'p_obj_setting_start_date'
2599: ,p_argument_value => p_obj_setting_start_date
2600: );
2601: --
2602: hr_api.mandatory_arg_error
2603: (p_api_name => l_proc
2604: ,p_argument => 'p_method_code'
2605: ,p_argument_value => p_method_code
2606: );
2604: ,p_argument => 'p_method_code'
2605: ,p_argument_value => p_method_code
2606: );
2607: --
2608: hr_api.mandatory_arg_error
2609: (p_api_name => l_proc
2610: ,p_argument => 'p_notify_population_flag'
2611: ,p_argument_value => p_notify_population_flag
2612: );
2677: (p_plan_id => p_plan_id
2678: ,p_object_version_number => p_object_version_number);
2679: --
2680: IF (l_api_updating
2681: AND nvl(per_pmp_shd.g_old_rec.obj_setting_start_date, hr_api.g_date)
2682: = nvl(p_obj_setting_start_date, hr_api.g_date)
2683: AND nvl(per_pmp_shd.g_old_rec.obj_setting_deadline, hr_api.g_date)
2684: = nvl(p_obj_setting_deadline, hr_api.g_date))
2685: THEN
2678: ,p_object_version_number => p_object_version_number);
2679: --
2680: IF (l_api_updating
2681: AND nvl(per_pmp_shd.g_old_rec.obj_setting_start_date, hr_api.g_date)
2682: = nvl(p_obj_setting_start_date, hr_api.g_date)
2683: AND nvl(per_pmp_shd.g_old_rec.obj_setting_deadline, hr_api.g_date)
2684: = nvl(p_obj_setting_deadline, hr_api.g_date))
2685: THEN
2686: RETURN;
2679: --
2680: IF (l_api_updating
2681: AND nvl(per_pmp_shd.g_old_rec.obj_setting_start_date, hr_api.g_date)
2682: = nvl(p_obj_setting_start_date, hr_api.g_date)
2683: AND nvl(per_pmp_shd.g_old_rec.obj_setting_deadline, hr_api.g_date)
2684: = nvl(p_obj_setting_deadline, hr_api.g_date))
2685: THEN
2686: RETURN;
2687: END IF;
2680: IF (l_api_updating
2681: AND nvl(per_pmp_shd.g_old_rec.obj_setting_start_date, hr_api.g_date)
2682: = nvl(p_obj_setting_start_date, hr_api.g_date)
2683: AND nvl(per_pmp_shd.g_old_rec.obj_setting_deadline, hr_api.g_date)
2684: = nvl(p_obj_setting_deadline, hr_api.g_date))
2685: THEN
2686: RETURN;
2687: END IF;
2688:
2768: (p_plan_id => p_plan_id
2769: ,p_object_version_number => p_object_version_number);
2770: --
2771: IF (l_api_updating
2772: AND nvl(per_pmp_shd.g_old_rec.obj_setting_deadline, hr_api.g_date)
2773: = nvl(p_obj_setting_deadline, hr_api.g_date)
2774: AND nvl(per_pmp_shd.g_old_rec.end_date, hr_api.g_date)
2775: = nvl(p_end_date, hr_api.g_date))
2776: THEN
2769: ,p_object_version_number => p_object_version_number);
2770: --
2771: IF (l_api_updating
2772: AND nvl(per_pmp_shd.g_old_rec.obj_setting_deadline, hr_api.g_date)
2773: = nvl(p_obj_setting_deadline, hr_api.g_date)
2774: AND nvl(per_pmp_shd.g_old_rec.end_date, hr_api.g_date)
2775: = nvl(p_end_date, hr_api.g_date))
2776: THEN
2777: RETURN;
2770: --
2771: IF (l_api_updating
2772: AND nvl(per_pmp_shd.g_old_rec.obj_setting_deadline, hr_api.g_date)
2773: = nvl(p_obj_setting_deadline, hr_api.g_date)
2774: AND nvl(per_pmp_shd.g_old_rec.end_date, hr_api.g_date)
2775: = nvl(p_end_date, hr_api.g_date))
2776: THEN
2777: RETURN;
2778: END IF;
2771: IF (l_api_updating
2772: AND nvl(per_pmp_shd.g_old_rec.obj_setting_deadline, hr_api.g_date)
2773: = nvl(p_obj_setting_deadline, hr_api.g_date)
2774: AND nvl(per_pmp_shd.g_old_rec.end_date, hr_api.g_date)
2775: = nvl(p_end_date, hr_api.g_date))
2776: THEN
2777: RETURN;
2778: END IF;
2779:
2869: (p_plan_id => p_plan_id
2870: ,p_object_version_number => p_object_version_number);
2871: --
2872: IF (l_api_updating
2873: AND nvl(per_pmp_shd.g_old_rec.obj_setting_start_date, hr_api.g_date)
2874: = nvl(p_obj_setting_start_date, hr_api.g_date)
2875: AND nvl(per_pmp_shd.g_old_rec.start_date, hr_api.g_date)
2876: = nvl(p_start_date, hr_api.g_date))
2877: THEN
2870: ,p_object_version_number => p_object_version_number);
2871: --
2872: IF (l_api_updating
2873: AND nvl(per_pmp_shd.g_old_rec.obj_setting_start_date, hr_api.g_date)
2874: = nvl(p_obj_setting_start_date, hr_api.g_date)
2875: AND nvl(per_pmp_shd.g_old_rec.start_date, hr_api.g_date)
2876: = nvl(p_start_date, hr_api.g_date))
2877: THEN
2878: RETURN;
2871: --
2872: IF (l_api_updating
2873: AND nvl(per_pmp_shd.g_old_rec.obj_setting_start_date, hr_api.g_date)
2874: = nvl(p_obj_setting_start_date, hr_api.g_date)
2875: AND nvl(per_pmp_shd.g_old_rec.start_date, hr_api.g_date)
2876: = nvl(p_start_date, hr_api.g_date))
2877: THEN
2878: RETURN;
2879: END IF;
2872: IF (l_api_updating
2873: AND nvl(per_pmp_shd.g_old_rec.obj_setting_start_date, hr_api.g_date)
2874: = nvl(p_obj_setting_start_date, hr_api.g_date)
2875: AND nvl(per_pmp_shd.g_old_rec.start_date, hr_api.g_date)
2876: = nvl(p_start_date, hr_api.g_date))
2877: THEN
2878: RETURN;
2879: END IF;
2880:
2951: Begin
2952:
2953: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 10); END IF;
2954: --
2955: hr_api.mandatory_arg_error
2956: (p_api_name => l_proc
2957: ,p_argument => 'p_obj_set_outside_period_flag'
2958: ,p_argument_value => p_obj_set_outside_period_flag
2959: );
2966: (p_plan_id => p_plan_id
2967: ,p_object_version_number => p_object_version_number);
2968: --
2969: IF (l_api_updating
2970: AND nvl(per_pmp_shd.g_old_rec.obj_set_outside_period_flag, hr_api.g_varchar2)
2971: = nvl(p_obj_set_outside_period_flag, hr_api.g_varchar2))
2972: THEN
2973: RETURN;
2974: END IF;
2967: ,p_object_version_number => p_object_version_number);
2968: --
2969: IF (l_api_updating
2970: AND nvl(per_pmp_shd.g_old_rec.obj_set_outside_period_flag, hr_api.g_varchar2)
2971: = nvl(p_obj_set_outside_period_flag, hr_api.g_varchar2))
2972: THEN
2973: RETURN;
2974: END IF;
2975:
2977:
2978: --
2979: -- Checks that the status code is valid
2980: --
2981: IF hr_api.not_exists_in_hrstanlookups
2982: (p_effective_date => p_effective_date
2983: ,p_lookup_type => 'YES_NO'
2984: ,p_lookup_code => p_obj_set_outside_period_flag
2985: ) THEN
3042: Begin
3043:
3044: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 10); END IF;
3045: --
3046: hr_api.mandatory_arg_error
3047: (p_api_name => l_proc
3048: ,p_argument => 'p_method_code'
3049: ,p_argument_value => p_method_code
3050: );
3057: (p_plan_id => p_plan_id
3058: ,p_object_version_number => p_object_version_number);
3059: --
3060: IF (l_api_updating
3061: AND nvl(per_pmp_shd.g_old_rec.method_code, hr_api.g_varchar2)
3062: = nvl(p_method_code, hr_api.g_varchar2))
3063: THEN
3064: RETURN;
3065: END IF;
3058: ,p_object_version_number => p_object_version_number);
3059: --
3060: IF (l_api_updating
3061: AND nvl(per_pmp_shd.g_old_rec.method_code, hr_api.g_varchar2)
3062: = nvl(p_method_code, hr_api.g_varchar2))
3063: THEN
3064: RETURN;
3065: END IF;
3066:
3068:
3069: --
3070: -- Checks that the status code is valid
3071: --
3072: IF hr_api.not_exists_in_hrstanlookups
3073: (p_effective_date => p_effective_date
3074: ,p_lookup_type => 'HR_WPM_PLAN_METHOD'
3075: ,p_lookup_code => p_method_code
3076: ) THEN
3133: Begin
3134:
3135: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 10); END IF;
3136: --
3137: hr_api.mandatory_arg_error
3138: (p_api_name => l_proc
3139: ,p_argument => 'p_notify_population_flag'
3140: ,p_argument_value => p_notify_population_flag
3141: );
3148: (p_plan_id => p_plan_id
3149: ,p_object_version_number => p_object_version_number);
3150: --
3151: IF (l_api_updating
3152: AND nvl(per_pmp_shd.g_old_rec.notify_population_flag, hr_api.g_varchar2)
3153: = nvl(p_notify_population_flag, hr_api.g_varchar2))
3154: THEN
3155: RETURN;
3156: END IF;
3149: ,p_object_version_number => p_object_version_number);
3150: --
3151: IF (l_api_updating
3152: AND nvl(per_pmp_shd.g_old_rec.notify_population_flag, hr_api.g_varchar2)
3153: = nvl(p_notify_population_flag, hr_api.g_varchar2))
3154: THEN
3155: RETURN;
3156: END IF;
3157:
3159:
3160: --
3161: -- Checks that the status code is valid
3162: --
3163: IF hr_api.not_exists_in_hrstanlookups
3164: (p_effective_date => p_effective_date
3165: ,p_lookup_type => 'YES_NO'
3166: ,p_lookup_code => p_notify_population_flag
3167: ) THEN
3224: Begin
3225:
3226: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 10); END IF;
3227: --
3228: hr_api.mandatory_arg_error
3229: (p_api_name => l_proc
3230: ,p_argument => 'p_automatic_allocation_flag'
3231: ,p_argument_value => p_automatic_allocation_flag
3232: );
3239: (p_plan_id => p_plan_id
3240: ,p_object_version_number => p_object_version_number);
3241: --
3242: IF (l_api_updating
3243: AND nvl(per_pmp_shd.g_old_rec.automatic_allocation_flag, hr_api.g_varchar2)
3244: = nvl(p_automatic_allocation_flag, hr_api.g_varchar2))
3245: THEN
3246: RETURN;
3247: END IF;
3240: ,p_object_version_number => p_object_version_number);
3241: --
3242: IF (l_api_updating
3243: AND nvl(per_pmp_shd.g_old_rec.automatic_allocation_flag, hr_api.g_varchar2)
3244: = nvl(p_automatic_allocation_flag, hr_api.g_varchar2))
3245: THEN
3246: RETURN;
3247: END IF;
3248:
3250:
3251: --
3252: -- Checks that the status code is valid
3253: --
3254: IF hr_api.not_exists_in_hrstanlookups
3255: (p_effective_date => p_effective_date
3256: ,p_lookup_type => 'YES_NO'
3257: ,p_lookup_code => p_automatic_allocation_flag
3258: ) THEN
3315: Begin
3316:
3317: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 10); END IF;
3318: --
3319: hr_api.mandatory_arg_error
3320: (p_api_name => l_proc
3321: ,p_argument => 'p_copy_past_objectives_flag'
3322: ,p_argument_value => p_copy_past_objectives_flag
3323: );
3330: (p_plan_id => p_plan_id
3331: ,p_object_version_number => p_object_version_number);
3332: --
3333: IF (l_api_updating
3334: AND nvl(per_pmp_shd.g_old_rec.copy_past_objectives_flag, hr_api.g_varchar2)
3335: = nvl(p_copy_past_objectives_flag, hr_api.g_varchar2))
3336: THEN
3337: RETURN;
3338: END IF;
3331: ,p_object_version_number => p_object_version_number);
3332: --
3333: IF (l_api_updating
3334: AND nvl(per_pmp_shd.g_old_rec.copy_past_objectives_flag, hr_api.g_varchar2)
3335: = nvl(p_copy_past_objectives_flag, hr_api.g_varchar2))
3336: THEN
3337: RETURN;
3338: END IF;
3339:
3341:
3342: --
3343: -- Checks that the status code is valid
3344: --
3345: IF hr_api.not_exists_in_hrstanlookups
3346: (p_effective_date => p_effective_date
3347: ,p_lookup_type => 'YES_NO'
3348: ,p_lookup_code => p_copy_past_objectives_flag
3349: ) THEN
3406: Begin
3407:
3408: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 10); END IF;
3409: --
3410: hr_api.mandatory_arg_error
3411: (p_api_name => l_proc
3412: ,p_argument => 'p_sharing_alignment_task_flag'
3413: ,p_argument_value => p_sharing_alignment_task_flag
3414: );
3421: (p_plan_id => p_plan_id
3422: ,p_object_version_number => p_object_version_number);
3423: --
3424: IF (l_api_updating
3425: AND nvl(per_pmp_shd.g_old_rec.sharing_alignment_task_flag, hr_api.g_varchar2)
3426: = nvl(p_sharing_alignment_task_flag, hr_api.g_varchar2))
3427: THEN
3428: RETURN;
3429: END IF;
3422: ,p_object_version_number => p_object_version_number);
3423: --
3424: IF (l_api_updating
3425: AND nvl(per_pmp_shd.g_old_rec.sharing_alignment_task_flag, hr_api.g_varchar2)
3426: = nvl(p_sharing_alignment_task_flag, hr_api.g_varchar2))
3427: THEN
3428: RETURN;
3429: END IF;
3430:
3432:
3433: --
3434: -- Checks that the status code is valid
3435: --
3436: IF hr_api.not_exists_in_hrstanlookups
3437: (p_effective_date => p_effective_date
3438: ,p_lookup_type => 'YES_NO'
3439: ,p_lookup_code => p_sharing_alignment_task_flag
3440: ) THEN
3497: Begin
3498:
3499: IF g_debug THEN hr_utility.set_location('Entering:'|| l_proc, 10); END IF;
3500: --
3501: hr_api.mandatory_arg_error
3502: (p_api_name => l_proc
3503: ,p_argument => 'p_include_appraisals_flag'
3504: ,p_argument_value => p_include_appraisals_flag
3505: );
3512: (p_plan_id => p_plan_id
3513: ,p_object_version_number => p_object_version_number);
3514: --
3515: IF (l_api_updating
3516: AND nvl(per_pmp_shd.g_old_rec.include_appraisals_flag, hr_api.g_varchar2)
3517: = nvl(p_include_appraisals_flag, hr_api.g_varchar2))
3518: THEN
3519: RETURN;
3520: END IF;
3513: ,p_object_version_number => p_object_version_number);
3514: --
3515: IF (l_api_updating
3516: AND nvl(per_pmp_shd.g_old_rec.include_appraisals_flag, hr_api.g_varchar2)
3517: = nvl(p_include_appraisals_flag, hr_api.g_varchar2))
3518: THEN
3519: RETURN;
3520: END IF;
3521:
3523:
3524: --
3525: -- Checks that the status code is valid
3526: --
3527: IF hr_api.not_exists_in_hrstanlookups
3528: (p_effective_date => p_effective_date
3529: ,p_lookup_type => 'YES_NO'
3530: ,p_lookup_code => p_include_appraisals_flag
3531: ) THEN