DBA Data[Home] [Help]

APPS.PER_PST_BUS dependencies on PER_PST_SHD

Line 379: (p_rec in per_pst_shd.g_rec_type

375: -- Internal Row Handler Use Only.
376: --
377: -- ----------------------------------------------------------------------------
378: procedure chk_df
379: (p_rec in per_pst_shd.g_rec_type
380: ) is
381: --
382: l_proc varchar2(72) := g_package || 'chk_df';
383: --

Line 388: nvl(per_pst_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

384: begin
385: hr_utility.set_location('Entering:'||l_proc,10);
386: --
387: if ((p_rec.position_structure_id is not null) and (
388: nvl(per_pst_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
389: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
390: nvl(per_pst_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
391: nvl(p_rec.attribute1, hr_api.g_varchar2) or
392: nvl(per_pst_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 390: nvl(per_pst_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

386: --
387: if ((p_rec.position_structure_id is not null) and (
388: nvl(per_pst_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
389: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
390: nvl(per_pst_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
391: nvl(p_rec.attribute1, hr_api.g_varchar2) or
392: nvl(per_pst_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
393: nvl(p_rec.attribute2, hr_api.g_varchar2) or
394: nvl(per_pst_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 392: nvl(per_pst_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

388: nvl(per_pst_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
389: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
390: nvl(per_pst_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
391: nvl(p_rec.attribute1, hr_api.g_varchar2) or
392: nvl(per_pst_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
393: nvl(p_rec.attribute2, hr_api.g_varchar2) or
394: nvl(per_pst_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
395: nvl(p_rec.attribute3, hr_api.g_varchar2) or
396: nvl(per_pst_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 394: nvl(per_pst_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

390: nvl(per_pst_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
391: nvl(p_rec.attribute1, hr_api.g_varchar2) or
392: nvl(per_pst_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
393: nvl(p_rec.attribute2, hr_api.g_varchar2) or
394: nvl(per_pst_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
395: nvl(p_rec.attribute3, hr_api.g_varchar2) or
396: nvl(per_pst_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
397: nvl(p_rec.attribute4, hr_api.g_varchar2) or
398: nvl(per_pst_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 396: nvl(per_pst_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

392: nvl(per_pst_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
393: nvl(p_rec.attribute2, hr_api.g_varchar2) or
394: nvl(per_pst_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
395: nvl(p_rec.attribute3, hr_api.g_varchar2) or
396: nvl(per_pst_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
397: nvl(p_rec.attribute4, hr_api.g_varchar2) or
398: nvl(per_pst_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
399: nvl(p_rec.attribute5, hr_api.g_varchar2) or
400: nvl(per_pst_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 398: nvl(per_pst_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

394: nvl(per_pst_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
395: nvl(p_rec.attribute3, hr_api.g_varchar2) or
396: nvl(per_pst_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
397: nvl(p_rec.attribute4, hr_api.g_varchar2) or
398: nvl(per_pst_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
399: nvl(p_rec.attribute5, hr_api.g_varchar2) or
400: nvl(per_pst_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
401: nvl(p_rec.attribute6, hr_api.g_varchar2) or
402: nvl(per_pst_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 400: nvl(per_pst_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

396: nvl(per_pst_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
397: nvl(p_rec.attribute4, hr_api.g_varchar2) or
398: nvl(per_pst_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
399: nvl(p_rec.attribute5, hr_api.g_varchar2) or
400: nvl(per_pst_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
401: nvl(p_rec.attribute6, hr_api.g_varchar2) or
402: nvl(per_pst_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
403: nvl(p_rec.attribute7, hr_api.g_varchar2) or
404: nvl(per_pst_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 402: nvl(per_pst_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

398: nvl(per_pst_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
399: nvl(p_rec.attribute5, hr_api.g_varchar2) or
400: nvl(per_pst_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
401: nvl(p_rec.attribute6, hr_api.g_varchar2) or
402: nvl(per_pst_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
403: nvl(p_rec.attribute7, hr_api.g_varchar2) or
404: nvl(per_pst_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
405: nvl(p_rec.attribute8, hr_api.g_varchar2) or
406: nvl(per_pst_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 404: nvl(per_pst_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

400: nvl(per_pst_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
401: nvl(p_rec.attribute6, hr_api.g_varchar2) or
402: nvl(per_pst_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
403: nvl(p_rec.attribute7, hr_api.g_varchar2) or
404: nvl(per_pst_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
405: nvl(p_rec.attribute8, hr_api.g_varchar2) or
406: nvl(per_pst_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
407: nvl(p_rec.attribute9, hr_api.g_varchar2) or
408: nvl(per_pst_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 406: nvl(per_pst_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

402: nvl(per_pst_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
403: nvl(p_rec.attribute7, hr_api.g_varchar2) or
404: nvl(per_pst_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
405: nvl(p_rec.attribute8, hr_api.g_varchar2) or
406: nvl(per_pst_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
407: nvl(p_rec.attribute9, hr_api.g_varchar2) or
408: nvl(per_pst_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
409: nvl(p_rec.attribute10, hr_api.g_varchar2) or
410: nvl(per_pst_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 408: nvl(per_pst_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

404: nvl(per_pst_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
405: nvl(p_rec.attribute8, hr_api.g_varchar2) or
406: nvl(per_pst_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
407: nvl(p_rec.attribute9, hr_api.g_varchar2) or
408: nvl(per_pst_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
409: nvl(p_rec.attribute10, hr_api.g_varchar2) or
410: nvl(per_pst_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
411: nvl(p_rec.attribute11, hr_api.g_varchar2) or
412: nvl(per_pst_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 410: nvl(per_pst_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

406: nvl(per_pst_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
407: nvl(p_rec.attribute9, hr_api.g_varchar2) or
408: nvl(per_pst_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
409: nvl(p_rec.attribute10, hr_api.g_varchar2) or
410: nvl(per_pst_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
411: nvl(p_rec.attribute11, hr_api.g_varchar2) or
412: nvl(per_pst_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
413: nvl(p_rec.attribute12, hr_api.g_varchar2) or
414: nvl(per_pst_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 412: nvl(per_pst_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

408: nvl(per_pst_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
409: nvl(p_rec.attribute10, hr_api.g_varchar2) or
410: nvl(per_pst_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
411: nvl(p_rec.attribute11, hr_api.g_varchar2) or
412: nvl(per_pst_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
413: nvl(p_rec.attribute12, hr_api.g_varchar2) or
414: nvl(per_pst_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
415: nvl(p_rec.attribute13, hr_api.g_varchar2) or
416: nvl(per_pst_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 414: nvl(per_pst_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

410: nvl(per_pst_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
411: nvl(p_rec.attribute11, hr_api.g_varchar2) or
412: nvl(per_pst_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
413: nvl(p_rec.attribute12, hr_api.g_varchar2) or
414: nvl(per_pst_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
415: nvl(p_rec.attribute13, hr_api.g_varchar2) or
416: nvl(per_pst_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
417: nvl(p_rec.attribute14, hr_api.g_varchar2) or
418: nvl(per_pst_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 416: nvl(per_pst_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

412: nvl(per_pst_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
413: nvl(p_rec.attribute12, hr_api.g_varchar2) or
414: nvl(per_pst_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
415: nvl(p_rec.attribute13, hr_api.g_varchar2) or
416: nvl(per_pst_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
417: nvl(p_rec.attribute14, hr_api.g_varchar2) or
418: nvl(per_pst_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
419: nvl(p_rec.attribute15, hr_api.g_varchar2) or
420: nvl(per_pst_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 418: nvl(per_pst_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

414: nvl(per_pst_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
415: nvl(p_rec.attribute13, hr_api.g_varchar2) or
416: nvl(per_pst_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
417: nvl(p_rec.attribute14, hr_api.g_varchar2) or
418: nvl(per_pst_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
419: nvl(p_rec.attribute15, hr_api.g_varchar2) or
420: nvl(per_pst_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
421: nvl(p_rec.attribute16, hr_api.g_varchar2) or
422: nvl(per_pst_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 420: nvl(per_pst_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

416: nvl(per_pst_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
417: nvl(p_rec.attribute14, hr_api.g_varchar2) or
418: nvl(per_pst_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
419: nvl(p_rec.attribute15, hr_api.g_varchar2) or
420: nvl(per_pst_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
421: nvl(p_rec.attribute16, hr_api.g_varchar2) or
422: nvl(per_pst_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
423: nvl(p_rec.attribute17, hr_api.g_varchar2) or
424: nvl(per_pst_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 422: nvl(per_pst_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

418: nvl(per_pst_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
419: nvl(p_rec.attribute15, hr_api.g_varchar2) or
420: nvl(per_pst_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
421: nvl(p_rec.attribute16, hr_api.g_varchar2) or
422: nvl(per_pst_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
423: nvl(p_rec.attribute17, hr_api.g_varchar2) or
424: nvl(per_pst_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
425: nvl(p_rec.attribute18, hr_api.g_varchar2) or
426: nvl(per_pst_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 424: nvl(per_pst_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

420: nvl(per_pst_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
421: nvl(p_rec.attribute16, hr_api.g_varchar2) or
422: nvl(per_pst_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
423: nvl(p_rec.attribute17, hr_api.g_varchar2) or
424: nvl(per_pst_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
425: nvl(p_rec.attribute18, hr_api.g_varchar2) or
426: nvl(per_pst_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
427: nvl(p_rec.attribute19, hr_api.g_varchar2) or
428: nvl(per_pst_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 426: nvl(per_pst_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

422: nvl(per_pst_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
423: nvl(p_rec.attribute17, hr_api.g_varchar2) or
424: nvl(per_pst_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
425: nvl(p_rec.attribute18, hr_api.g_varchar2) or
426: nvl(per_pst_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
427: nvl(p_rec.attribute19, hr_api.g_varchar2) or
428: nvl(per_pst_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
429: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
430: or (p_rec.position_structure_id is null) then

Line 428: nvl(per_pst_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

424: nvl(per_pst_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
425: nvl(p_rec.attribute18, hr_api.g_varchar2) or
426: nvl(per_pst_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
427: nvl(p_rec.attribute19, hr_api.g_varchar2) or
428: nvl(per_pst_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
429: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
430: or (p_rec.position_structure_id is null) then
431: --
432: -- Only execute the validation if absolutely necessary:

Line 516: ,p_rec in per_pst_shd.g_rec_type

512: -- {End Of Comments}
513: -- ----------------------------------------------------------------------------
514: Procedure chk_non_updateable_args
515: (p_effective_date in date
516: ,p_rec in per_pst_shd.g_rec_type
517: ) IS
518: --
519: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
520: l_error EXCEPTION;

Line 528: IF NOT per_pst_shd.api_updating

524: --
525: -- Only proceed with the validation if a row exists for the current
526: -- record in the HR Schema.
527: --
528: IF NOT per_pst_shd.api_updating
529: (p_position_structure_id => p_rec.position_structure_id
530: ,p_object_version_number => p_rec.object_version_number
531: ) THEN
532: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 551: ,p_rec in per_pst_shd.g_rec_type

547: -- |---------------------------< insert_validate >----------------------------|
548: -- ----------------------------------------------------------------------------
549: Procedure insert_validate
550: (p_effective_date in date
551: ,p_rec in per_pst_shd.g_rec_type
552: ) is
553: --
554: l_proc varchar2(72) := g_package||'insert_validate';
555: --

Line 592: ,p_rec in per_pst_shd.g_rec_type

588: -- |---------------------------< update_validate >----------------------------|
589: -- ----------------------------------------------------------------------------
590: Procedure update_validate
591: (p_effective_date in date
592: ,p_rec in per_pst_shd.g_rec_type
593: ) is
594: --
595: l_proc varchar2(72) := g_package||'update_validate';
596: --

Line 635: (p_rec in per_pst_shd.g_rec_type

631: -- ----------------------------------------------------------------------------
632: -- |---------------------------< delete_validate >----------------------------|
633: -- ----------------------------------------------------------------------------
634: Procedure delete_validate
635: (p_rec in per_pst_shd.g_rec_type
636: ) is
637: --
638: l_proc varchar2(72) := g_package||'delete_validate';
639: --