eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_SPH_BUS dependencies on PER_SPH_SHD

Line 189: (p_rec in per_sph_shd.g_rec_type

185: -- Internal Row Handler Use Only.
186: --
187: -- ----------------------------------------------------------------------------
188: procedure chk_df
189: (p_rec in per_sph_shd.g_rec_type
190: ) is
191: --
192: l_proc varchar2(72) := g_package || 'chk_df';
193: --

Line 198: nvl(per_sph_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

194: begin
195: hr_utility.set_location('Entering:'||l_proc,10);
196: --
197: if ((p_rec.plan_id is not null) and (
198: nvl(per_sph_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
199: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
200: nvl(per_sph_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
201: nvl(p_rec.attribute1, hr_api.g_varchar2) or
202: nvl(per_sph_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 200: nvl(per_sph_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

196: --
197: if ((p_rec.plan_id is not null) and (
198: nvl(per_sph_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
199: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
200: nvl(per_sph_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
201: nvl(p_rec.attribute1, hr_api.g_varchar2) or
202: nvl(per_sph_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
203: nvl(p_rec.attribute2, hr_api.g_varchar2) or
204: nvl(per_sph_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 202: nvl(per_sph_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

198: nvl(per_sph_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
199: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
200: nvl(per_sph_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
201: nvl(p_rec.attribute1, hr_api.g_varchar2) or
202: nvl(per_sph_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
203: nvl(p_rec.attribute2, hr_api.g_varchar2) or
204: nvl(per_sph_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
205: nvl(p_rec.attribute3, hr_api.g_varchar2) or
206: nvl(per_sph_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 204: nvl(per_sph_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

200: nvl(per_sph_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
201: nvl(p_rec.attribute1, hr_api.g_varchar2) or
202: nvl(per_sph_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
203: nvl(p_rec.attribute2, hr_api.g_varchar2) or
204: nvl(per_sph_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
205: nvl(p_rec.attribute3, hr_api.g_varchar2) or
206: nvl(per_sph_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
207: nvl(p_rec.attribute4, hr_api.g_varchar2) or
208: nvl(per_sph_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 206: nvl(per_sph_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

202: nvl(per_sph_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
203: nvl(p_rec.attribute2, hr_api.g_varchar2) or
204: nvl(per_sph_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
205: nvl(p_rec.attribute3, hr_api.g_varchar2) or
206: nvl(per_sph_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
207: nvl(p_rec.attribute4, hr_api.g_varchar2) or
208: nvl(per_sph_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
209: nvl(p_rec.attribute5, hr_api.g_varchar2) or
210: nvl(per_sph_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 208: nvl(per_sph_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

204: nvl(per_sph_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
205: nvl(p_rec.attribute3, hr_api.g_varchar2) or
206: nvl(per_sph_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
207: nvl(p_rec.attribute4, hr_api.g_varchar2) or
208: nvl(per_sph_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
209: nvl(p_rec.attribute5, hr_api.g_varchar2) or
210: nvl(per_sph_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
211: nvl(p_rec.attribute6, hr_api.g_varchar2) or
212: nvl(per_sph_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 210: nvl(per_sph_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

206: nvl(per_sph_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
207: nvl(p_rec.attribute4, hr_api.g_varchar2) or
208: nvl(per_sph_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
209: nvl(p_rec.attribute5, hr_api.g_varchar2) or
210: nvl(per_sph_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
211: nvl(p_rec.attribute6, hr_api.g_varchar2) or
212: nvl(per_sph_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
213: nvl(p_rec.attribute7, hr_api.g_varchar2) or
214: nvl(per_sph_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 212: nvl(per_sph_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

208: nvl(per_sph_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
209: nvl(p_rec.attribute5, hr_api.g_varchar2) or
210: nvl(per_sph_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
211: nvl(p_rec.attribute6, hr_api.g_varchar2) or
212: nvl(per_sph_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
213: nvl(p_rec.attribute7, hr_api.g_varchar2) or
214: nvl(per_sph_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
215: nvl(p_rec.attribute8, hr_api.g_varchar2) or
216: nvl(per_sph_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 214: nvl(per_sph_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

210: nvl(per_sph_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
211: nvl(p_rec.attribute6, hr_api.g_varchar2) or
212: nvl(per_sph_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
213: nvl(p_rec.attribute7, hr_api.g_varchar2) or
214: nvl(per_sph_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
215: nvl(p_rec.attribute8, hr_api.g_varchar2) or
216: nvl(per_sph_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
217: nvl(p_rec.attribute9, hr_api.g_varchar2) or
218: nvl(per_sph_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 216: nvl(per_sph_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

212: nvl(per_sph_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
213: nvl(p_rec.attribute7, hr_api.g_varchar2) or
214: nvl(per_sph_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
215: nvl(p_rec.attribute8, hr_api.g_varchar2) or
216: nvl(per_sph_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
217: nvl(p_rec.attribute9, hr_api.g_varchar2) or
218: nvl(per_sph_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
219: nvl(p_rec.attribute10, hr_api.g_varchar2) or
220: nvl(per_sph_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 218: nvl(per_sph_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

214: nvl(per_sph_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
215: nvl(p_rec.attribute8, hr_api.g_varchar2) or
216: nvl(per_sph_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
217: nvl(p_rec.attribute9, hr_api.g_varchar2) or
218: nvl(per_sph_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
219: nvl(p_rec.attribute10, hr_api.g_varchar2) or
220: nvl(per_sph_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
221: nvl(p_rec.attribute11, hr_api.g_varchar2) or
222: nvl(per_sph_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 220: nvl(per_sph_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

216: nvl(per_sph_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
217: nvl(p_rec.attribute9, hr_api.g_varchar2) or
218: nvl(per_sph_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
219: nvl(p_rec.attribute10, hr_api.g_varchar2) or
220: nvl(per_sph_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
221: nvl(p_rec.attribute11, hr_api.g_varchar2) or
222: nvl(per_sph_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
223: nvl(p_rec.attribute12, hr_api.g_varchar2) or
224: nvl(per_sph_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 222: nvl(per_sph_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

218: nvl(per_sph_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
219: nvl(p_rec.attribute10, hr_api.g_varchar2) or
220: nvl(per_sph_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
221: nvl(p_rec.attribute11, hr_api.g_varchar2) or
222: nvl(per_sph_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
223: nvl(p_rec.attribute12, hr_api.g_varchar2) or
224: nvl(per_sph_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
225: nvl(p_rec.attribute13, hr_api.g_varchar2) or
226: nvl(per_sph_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 224: nvl(per_sph_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

220: nvl(per_sph_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
221: nvl(p_rec.attribute11, hr_api.g_varchar2) or
222: nvl(per_sph_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
223: nvl(p_rec.attribute12, hr_api.g_varchar2) or
224: nvl(per_sph_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
225: nvl(p_rec.attribute13, hr_api.g_varchar2) or
226: nvl(per_sph_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
227: nvl(p_rec.attribute14, hr_api.g_varchar2) or
228: nvl(per_sph_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 226: nvl(per_sph_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

222: nvl(per_sph_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
223: nvl(p_rec.attribute12, hr_api.g_varchar2) or
224: nvl(per_sph_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
225: nvl(p_rec.attribute13, hr_api.g_varchar2) or
226: nvl(per_sph_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
227: nvl(p_rec.attribute14, hr_api.g_varchar2) or
228: nvl(per_sph_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
229: nvl(p_rec.attribute15, hr_api.g_varchar2) or
230: nvl(per_sph_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 228: nvl(per_sph_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

224: nvl(per_sph_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
225: nvl(p_rec.attribute13, hr_api.g_varchar2) or
226: nvl(per_sph_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
227: nvl(p_rec.attribute14, hr_api.g_varchar2) or
228: nvl(per_sph_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
229: nvl(p_rec.attribute15, hr_api.g_varchar2) or
230: nvl(per_sph_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
231: nvl(p_rec.attribute16, hr_api.g_varchar2) or
232: nvl(per_sph_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 230: nvl(per_sph_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

226: nvl(per_sph_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
227: nvl(p_rec.attribute14, hr_api.g_varchar2) or
228: nvl(per_sph_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
229: nvl(p_rec.attribute15, hr_api.g_varchar2) or
230: nvl(per_sph_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
231: nvl(p_rec.attribute16, hr_api.g_varchar2) or
232: nvl(per_sph_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
233: nvl(p_rec.attribute17, hr_api.g_varchar2) or
234: nvl(per_sph_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 232: nvl(per_sph_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

228: nvl(per_sph_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
229: nvl(p_rec.attribute15, hr_api.g_varchar2) or
230: nvl(per_sph_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
231: nvl(p_rec.attribute16, hr_api.g_varchar2) or
232: nvl(per_sph_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
233: nvl(p_rec.attribute17, hr_api.g_varchar2) or
234: nvl(per_sph_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
235: nvl(p_rec.attribute18, hr_api.g_varchar2) or
236: nvl(per_sph_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 234: nvl(per_sph_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

230: nvl(per_sph_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
231: nvl(p_rec.attribute16, hr_api.g_varchar2) or
232: nvl(per_sph_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
233: nvl(p_rec.attribute17, hr_api.g_varchar2) or
234: nvl(per_sph_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
235: nvl(p_rec.attribute18, hr_api.g_varchar2) or
236: nvl(per_sph_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
237: nvl(p_rec.attribute19, hr_api.g_varchar2) or
238: nvl(per_sph_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 236: nvl(per_sph_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

232: nvl(per_sph_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
233: nvl(p_rec.attribute17, hr_api.g_varchar2) or
234: nvl(per_sph_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
235: nvl(p_rec.attribute18, hr_api.g_varchar2) or
236: nvl(per_sph_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
237: nvl(p_rec.attribute19, hr_api.g_varchar2) or
238: nvl(per_sph_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
239: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
240: or (p_rec.plan_id is null and p_rec.attribute_category IS NOT NULL) then

Line 238: nvl(per_sph_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

234: nvl(per_sph_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
235: nvl(p_rec.attribute18, hr_api.g_varchar2) or
236: nvl(per_sph_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
237: nvl(p_rec.attribute19, hr_api.g_varchar2) or
238: nvl(per_sph_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
239: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
240: or (p_rec.plan_id is null and p_rec.attribute_category IS NOT NULL) then
241: --
242: -- Only execute the validation if absolutely necessary:

Line 326: ,p_rec in per_sph_shd.g_rec_type

322: -- {End Of Comments}
323: -- ----------------------------------------------------------------------------
324: Procedure chk_non_updateable_args
325: (p_effective_date in date
326: ,p_rec in per_sph_shd.g_rec_type
327: ) IS
328: --
329: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
330: --

Line 336: IF NOT per_sph_shd.api_updating

332: --
333: -- Only proceed with the validation if a row exists for the current
334: -- record in the HR Schema.
335: --
336: IF NOT per_sph_shd.api_updating
337: (p_plan_id => p_rec.plan_id
338: ,p_object_version_number => p_rec.object_version_number
339: ) THEN
340: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 458: ,p_rec in per_sph_shd.g_rec_type

454: -- |---------------------------< insert_validate >----------------------------|
455: -- ----------------------------------------------------------------------------
456: Procedure insert_validate
457: (p_effective_date in date
458: ,p_rec in per_sph_shd.g_rec_type
459: ) is
460: --
461: l_proc varchar2(72) := g_package||'insert_validate';
462: --

Line 470: ,p_associated_column1 => per_sph_shd.g_tab_nam

466: -- Call all supporting business operations
467: --
468: hr_api.validate_bus_grp_id
469: (p_business_group_id => p_rec.business_group_id
470: ,p_associated_column1 => per_sph_shd.g_tab_nam
471: || '.BUSINESS_GROUP_ID');
472:
473:
474: chkMaxPlans(p_rec.successee_id, p_rec.plan_type);

Line 497: ,p_rec in per_sph_shd.g_rec_type

493: -- |---------------------------< update_validate >----------------------------|
494: -- ----------------------------------------------------------------------------
495: Procedure update_validate
496: (p_effective_date in date
497: ,p_rec in per_sph_shd.g_rec_type
498: ) is
499: --
500: l_proc varchar2(72) := g_package||'update_validate';
501: --

Line 509: ,p_associated_column1 => per_sph_shd.g_tab_nam

505: -- Call all supporting business operations
506: --
507: hr_api.validate_bus_grp_id
508: (p_business_group_id => p_rec.business_group_id
509: ,p_associated_column1 => per_sph_shd.g_tab_nam
510: || '.BUSINESS_GROUP_ID');
511:
512: chkDates(p_rec.start_date, p_rec.end_date, p_rec.next_review_date, p_rec.filled_on);
513:

Line 538: (p_rec in per_sph_shd.g_rec_type

534: -- ----------------------------------------------------------------------------
535: -- |---------------------------< delete_validate >----------------------------|
536: -- ----------------------------------------------------------------------------
537: Procedure delete_validate
538: (p_rec in per_sph_shd.g_rec_type
539: ) is
540: --
541: l_proc varchar2(72) := g_package||'delete_validate';
542: --