APPS.PER_SPINAL_POINT_STEPS_PKG dependencies on PER_SPINAL_POINT_STEPS_PKG

Line 1: package body PER_SPINAL_POINT_STEPS_PKG as

1: package body PER_SPINAL_POINT_STEPS_PKG as
2: /* $Header: pesps01t.pkb 120.0 2005/05/31 21:35:53 appldev noship $ */
3:
4: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
5: X_Step_Id IN OUT NOCOPY NUMBER,

Line 391: hr_utility.set_location('per_spinal_point_steps_pkg.del_chks_del',1);

387: and p_sess < effective_end_date;
388: --
389: begin
390: --
391: hr_utility.set_location('per_spinal_point_steps_pkg.del_chks_del',1);
392: --
393: open c1;
394: --
395: fetch c1 into l_exists1;

Line 404: hr_utility.set_location('per_spinal_point_steps_pkg.del_chks_del',2);

400: END IF;
401: --
402: close c1;
403: --
404: hr_utility.set_location('per_spinal_point_steps_pkg.del_chks_del',2);
405: --
406: open c2;
407: --
408: fetch c2 into l_exists2;

Line 438: hr_utility.set_location('per_spinal_point_steps_pkg.del_chks_zap',1);

434: and special_ceiling_step_id is not null;
435: --
436: begin
437: --
438: hr_utility.set_location('per_spinal_point_steps_pkg.del_chks_zap',1);
439: --
440: open c3;
441: --
442: fetch c3 into l_exists;

Line 451: hr_utility.set_location('per_spinal_point_steps_pkg.del_chks_zap',2);

447: END IF;
448: --
449: close c3;
450: --
451: hr_utility.set_location('per_spinal_point_steps_pkg.del_chks_zap',2);
452: --
453: open c4;
454: --
455: fetch c4 into l_exists2;

Line 486: hr_utility.set_location('per_spinal_point_steps_pkg.chk_unq_step_point',1);

482: and sp.step_id <> p_step_id);
483: --
484: begin
485: --
486: hr_utility.set_location('per_spinal_point_steps_pkg.chk_unq_step_point',1);
487: --
488: open c5;
489: --
490: fetch c5 into l_exists;

Line 525: hr_utility.set_location('per_spinal_point_steps_pkg.pop_flds',1);

521: l_count NUMBER;
522: --
523: begin
524: --
525: hr_utility.set_location('per_spinal_point_steps_pkg.pop_flds',1);
526: --
527: open c6;
528: --
529: fetch c6 into l_count;

Line 545: end PER_SPINAL_POINT_STEPS_PKG;

541:
542:
543:
544:
545: end PER_SPINAL_POINT_STEPS_PKG;