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_PSP_BUS dependencies on PER_SPINAL_POINTS

Line 31: , per_spinal_points psp

27: cursor csr_sec_grp is
28: select pbg.security_group_id,
29: pbg.legislation_code
30: from per_business_groups_perf pbg
31: , per_spinal_points psp
32: where psp.spinal_point_id = p_spinal_point_id
33: and pbg.business_group_id = psp.business_group_id;
34: --
35: -- Declare local variables

Line 101: , per_spinal_points psp

97: --
98: cursor csr_leg_code is
99: select pbg.legislation_code
100: from per_business_groups_perf pbg
101: , per_spinal_points psp
102: where psp.spinal_point_id = p_spinal_point_id
103: and pbg.business_group_id = psp.business_group_id;
104: --
105: -- Declare local variables

Line 191: ( p_spinal_point_id in per_spinal_points.spinal_point_id%TYPE

187: --
188: -- {End Of Comments}
189: -- ----------------------------------------------------------------------------
190: Procedure chk_spinal_point_id
191: ( p_spinal_point_id in per_spinal_points.spinal_point_id%TYPE
192: ,p_object_version_number in per_spinal_points.object_version_number%TYPE
193: ) is
194: --
195: l_proc varchar2(72) := g_package||'chk_spinal_point_id';

Line 192: ,p_object_version_number in per_spinal_points.object_version_number%TYPE

188: -- {End Of Comments}
189: -- ----------------------------------------------------------------------------
190: Procedure chk_spinal_point_id
191: ( p_spinal_point_id in per_spinal_points.spinal_point_id%TYPE
192: ,p_object_version_number in per_spinal_points.object_version_number%TYPE
193: ) is
194: --
195: l_proc varchar2(72) := g_package||'chk_spinal_point_id';
196: l_api_updating boolean;

Line 212: per_psp_shd.constraint_error('PER_SPINAL_POINTS_PK');

208: <> per_psp_shd.g_old_rec.spinal_point_id) then
209: --
210: -- raise error as PK has changed
211: --
212: per_psp_shd.constraint_error('PER_SPINAL_POINTS_PK');
213: --
214: elsif not l_api_updating then
215: --
216: -- check if PK is null

Line 222: per_psp_shd.constraint_error('PER_SPINAL_POINTS_PK');

218: if p_spinal_point_id is not null then
219: --
220: -- raise error as PK is not null
221: --
222: per_psp_shd.constraint_error('PER_SPINAL_POINTS_PK');
223: --
224: end if;
225: --
226: end if;

Line 264: (p_spinal_point_id in per_spinal_points.spinal_point_id%TYPE

260: -- {End Of Comments}
261: -- ----------------------------------------------------------------------------
262: --
263: procedure chk_parent_spine_id
264: (p_spinal_point_id in per_spinal_points.spinal_point_id%TYPE
265: ,p_parent_spine_id in per_spinal_points.parent_spine_id%TYPE
266: ,p_business_group_id in per_spinal_points.business_group_id%TYPE
267: ,p_object_version_number in per_spinal_points.object_version_number%TYPE
268: )

Line 265: ,p_parent_spine_id in per_spinal_points.parent_spine_id%TYPE

261: -- ----------------------------------------------------------------------------
262: --
263: procedure chk_parent_spine_id
264: (p_spinal_point_id in per_spinal_points.spinal_point_id%TYPE
265: ,p_parent_spine_id in per_spinal_points.parent_spine_id%TYPE
266: ,p_business_group_id in per_spinal_points.business_group_id%TYPE
267: ,p_object_version_number in per_spinal_points.object_version_number%TYPE
268: )
269: is

Line 266: ,p_business_group_id in per_spinal_points.business_group_id%TYPE

262: --
263: procedure chk_parent_spine_id
264: (p_spinal_point_id in per_spinal_points.spinal_point_id%TYPE
265: ,p_parent_spine_id in per_spinal_points.parent_spine_id%TYPE
266: ,p_business_group_id in per_spinal_points.business_group_id%TYPE
267: ,p_object_version_number in per_spinal_points.object_version_number%TYPE
268: )
269: is
270: --

Line 267: ,p_object_version_number in per_spinal_points.object_version_number%TYPE

263: procedure chk_parent_spine_id
264: (p_spinal_point_id in per_spinal_points.spinal_point_id%TYPE
265: ,p_parent_spine_id in per_spinal_points.parent_spine_id%TYPE
266: ,p_business_group_id in per_spinal_points.business_group_id%TYPE
267: ,p_object_version_number in per_spinal_points.object_version_number%TYPE
268: )
269: is
270: --
271: l_exists varchar2(1);

Line 314: per_psp_shd.constraint_error(p_constraint_name => 'PER_SPINAL_POINTS_FK2');

310: fetch csr_valid_parent_spines into l_exists;
311: if csr_valid_parent_spines%notfound then
312: close csr_valid_parent_spines;
313: --
314: per_psp_shd.constraint_error(p_constraint_name => 'PER_SPINAL_POINTS_FK2');
315: --
316: end if;
317: close csr_valid_parent_spines;
318:

Line 354: p_sequence in per_spinal_points.sequence%TYPE

350: --
351: -- {End of Comments}
352: -- ----------------------------------------------------------------------------
353: procedure chk_sequence(
354: p_sequence in per_spinal_points.sequence%TYPE
355: ,p_parent_spine_id in per_spinal_points.parent_spine_id%TYPE
356: ,p_spinal_point in per_spinal_points.spinal_point%TYPE
357: ,p_spinal_point_id in per_spinal_points.spinal_point_id%TYPE
358: ,p_object_version_number in per_spinal_points.object_version_number%TYPE

Line 355: ,p_parent_spine_id in per_spinal_points.parent_spine_id%TYPE

351: -- {End of Comments}
352: -- ----------------------------------------------------------------------------
353: procedure chk_sequence(
354: p_sequence in per_spinal_points.sequence%TYPE
355: ,p_parent_spine_id in per_spinal_points.parent_spine_id%TYPE
356: ,p_spinal_point in per_spinal_points.spinal_point%TYPE
357: ,p_spinal_point_id in per_spinal_points.spinal_point_id%TYPE
358: ,p_object_version_number in per_spinal_points.object_version_number%TYPE
359: ) IS

Line 356: ,p_spinal_point in per_spinal_points.spinal_point%TYPE

352: -- ----------------------------------------------------------------------------
353: procedure chk_sequence(
354: p_sequence in per_spinal_points.sequence%TYPE
355: ,p_parent_spine_id in per_spinal_points.parent_spine_id%TYPE
356: ,p_spinal_point in per_spinal_points.spinal_point%TYPE
357: ,p_spinal_point_id in per_spinal_points.spinal_point_id%TYPE
358: ,p_object_version_number in per_spinal_points.object_version_number%TYPE
359: ) IS
360: --

Line 357: ,p_spinal_point_id in per_spinal_points.spinal_point_id%TYPE

353: procedure chk_sequence(
354: p_sequence in per_spinal_points.sequence%TYPE
355: ,p_parent_spine_id in per_spinal_points.parent_spine_id%TYPE
356: ,p_spinal_point in per_spinal_points.spinal_point%TYPE
357: ,p_spinal_point_id in per_spinal_points.spinal_point_id%TYPE
358: ,p_object_version_number in per_spinal_points.object_version_number%TYPE
359: ) IS
360: --
361: l_proc varchar2(72) := g_package||'chk_sequence';

Line 358: ,p_object_version_number in per_spinal_points.object_version_number%TYPE

354: p_sequence in per_spinal_points.sequence%TYPE
355: ,p_parent_spine_id in per_spinal_points.parent_spine_id%TYPE
356: ,p_spinal_point in per_spinal_points.spinal_point%TYPE
357: ,p_spinal_point_id in per_spinal_points.spinal_point_id%TYPE
358: ,p_object_version_number in per_spinal_points.object_version_number%TYPE
359: ) IS
360: --
361: l_proc varchar2(72) := g_package||'chk_sequence';
362: l_exists VARCHAR2(2);

Line 367: from per_spinal_points

363: l_api_updating boolean;
364: --
365: cursor csr_unq_seq is
366: select 'x'
367: from per_spinal_points
368: where sequence = p_sequence
369: and parent_spine_id = p_parent_spine_id
370: and spinal_point = p_spinal_point;
371: --

Line 444: p_spinal_point in per_spinal_points.spinal_point%TYPE

440: --
441: -- {End of Comments}
442: -- ----------------------------------------------------------------------------
443: procedure chk_spinal_point(
444: p_spinal_point in per_spinal_points.spinal_point%TYPE
445: ,p_parent_spine_id in per_spinal_points.parent_spine_id%TYPE
446: ,p_spinal_point_id in per_spinal_points.spinal_point_id%TYPE
447: ,p_object_version_number in per_spinal_points.object_version_number%TYPE
448: ) IS

Line 445: ,p_parent_spine_id in per_spinal_points.parent_spine_id%TYPE

441: -- {End of Comments}
442: -- ----------------------------------------------------------------------------
443: procedure chk_spinal_point(
444: p_spinal_point in per_spinal_points.spinal_point%TYPE
445: ,p_parent_spine_id in per_spinal_points.parent_spine_id%TYPE
446: ,p_spinal_point_id in per_spinal_points.spinal_point_id%TYPE
447: ,p_object_version_number in per_spinal_points.object_version_number%TYPE
448: ) IS
449: --

Line 446: ,p_spinal_point_id in per_spinal_points.spinal_point_id%TYPE

442: -- ----------------------------------------------------------------------------
443: procedure chk_spinal_point(
444: p_spinal_point in per_spinal_points.spinal_point%TYPE
445: ,p_parent_spine_id in per_spinal_points.parent_spine_id%TYPE
446: ,p_spinal_point_id in per_spinal_points.spinal_point_id%TYPE
447: ,p_object_version_number in per_spinal_points.object_version_number%TYPE
448: ) IS
449: --
450: l_proc varchar2(72) := g_package||'chk_spinal_point';

Line 447: ,p_object_version_number in per_spinal_points.object_version_number%TYPE

443: procedure chk_spinal_point(
444: p_spinal_point in per_spinal_points.spinal_point%TYPE
445: ,p_parent_spine_id in per_spinal_points.parent_spine_id%TYPE
446: ,p_spinal_point_id in per_spinal_points.spinal_point_id%TYPE
447: ,p_object_version_number in per_spinal_points.object_version_number%TYPE
448: ) IS
449: --
450: l_proc varchar2(72) := g_package||'chk_spinal_point';
451: l_exists VARCHAR2(2);

Line 456: from per_spinal_points

452: l_api_updating boolean;
453: --
454: cursor csr_unq_spinal_point is
455: select 'x'
456: from per_spinal_points
457: where spinal_point = p_spinal_point
458: and parent_spine_id = p_parent_spine_id;
459: --
460: BEGIN

Line 529: p_spinal_point_id in per_spinal_points.spinal_point_id%TYPE

525: -- {End Of Comments}
526: -- ----------------------------------------------------------------------------
527: --
528: PROCEDURE chk_delete(
529: p_spinal_point_id in per_spinal_points.spinal_point_id%TYPE
530: ,p_parent_spine_id in per_spinal_points.parent_spine_id%TYPE
531: ) is
532: --
533: l_proc varchar2(72) := g_package||'chk_delete';

Line 530: ,p_parent_spine_id in per_spinal_points.parent_spine_id%TYPE

526: -- ----------------------------------------------------------------------------
527: --
528: PROCEDURE chk_delete(
529: p_spinal_point_id in per_spinal_points.spinal_point_id%TYPE
530: ,p_parent_spine_id in per_spinal_points.parent_spine_id%TYPE
531: ) is
532: --
533: l_proc varchar2(72) := g_package||'chk_delete';
534: l_exists varchar2(1);