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_PPS_BUS dependencies on PER_PARENT_SPINES

Line 31: , per_parent_spines pps

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_parent_spines pps
32: where pps.parent_spine_id = p_parent_spine_id
33: and pbg.business_group_id = pps.business_group_id;
34: --
35: -- Declare local variables

Line 101: , per_parent_spines pps

97: --
98: cursor csr_leg_code is
99: select pbg.legislation_code
100: from per_business_groups_perf pbg
101: , per_parent_spines pps
102: where pps.parent_spine_id = p_parent_spine_id
103: and pbg.business_group_id = pps.business_group_id;
104: --
105: -- Declare local variables

Line 190: ( p_parent_spine_id in per_parent_spines.parent_spine_id%TYPE

186: --
187: -- {End Of Comments}
188: -- ----------------------------------------------------------------------------
189: Procedure chk_parent_spine_id
190: ( p_parent_spine_id in per_parent_spines.parent_spine_id%TYPE
191: ,p_object_version_number in per_parent_spines.object_version_number%TYPE
192: ) is
193: --
194: l_proc varchar2(72) := g_package||'chk_parent_spine_id';

Line 191: ,p_object_version_number in per_parent_spines.object_version_number%TYPE

187: -- {End Of Comments}
188: -- ----------------------------------------------------------------------------
189: Procedure chk_parent_spine_id
190: ( p_parent_spine_id in per_parent_spines.parent_spine_id%TYPE
191: ,p_object_version_number in per_parent_spines.object_version_number%TYPE
192: ) is
193: --
194: l_proc varchar2(72) := g_package||'chk_parent_spine_id';
195: l_api_updating boolean;

Line 211: per_pps_shd.constraint_error('PER_PARENT_SPINES_PK');

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

Line 221: per_pps_shd.constraint_error('PER_PARENT_SPINES_PK');

217: if p_parent_spine_id is not null then
218: --
219: -- raise error as PK is not null
220: --
221: per_pps_shd.constraint_error('PER_PARENT_SPINES_PK');
222: --
223: end if;
224: --
225: end if;

Line 262: p_parent_spine_id in per_parent_spines.parent_spine_id%TYPE

258: --
259: -- {End Of Comments}
260: -- ----------------------------------------------------------------------------
261: Procedure chk_name(
262: p_parent_spine_id in per_parent_spines.parent_spine_id%TYPE
263: ,p_name in per_parent_spines.name%TYPE
264: ,p_business_group_id in per_parent_spines.business_group_id%TYPE
265: ,p_object_version_number in per_parent_spines.object_version_number%TYPE
266: ) is

Line 263: ,p_name in per_parent_spines.name%TYPE

259: -- {End Of Comments}
260: -- ----------------------------------------------------------------------------
261: Procedure chk_name(
262: p_parent_spine_id in per_parent_spines.parent_spine_id%TYPE
263: ,p_name in per_parent_spines.name%TYPE
264: ,p_business_group_id in per_parent_spines.business_group_id%TYPE
265: ,p_object_version_number in per_parent_spines.object_version_number%TYPE
266: ) is
267: --

Line 264: ,p_business_group_id in per_parent_spines.business_group_id%TYPE

260: -- ----------------------------------------------------------------------------
261: Procedure chk_name(
262: p_parent_spine_id in per_parent_spines.parent_spine_id%TYPE
263: ,p_name in per_parent_spines.name%TYPE
264: ,p_business_group_id in per_parent_spines.business_group_id%TYPE
265: ,p_object_version_number in per_parent_spines.object_version_number%TYPE
266: ) is
267: --
268: l_proc varchar2(72) := g_package||'chk_name';

Line 265: ,p_object_version_number in per_parent_spines.object_version_number%TYPE

261: Procedure chk_name(
262: p_parent_spine_id in per_parent_spines.parent_spine_id%TYPE
263: ,p_name in per_parent_spines.name%TYPE
264: ,p_business_group_id in per_parent_spines.business_group_id%TYPE
265: ,p_object_version_number in per_parent_spines.object_version_number%TYPE
266: ) is
267: --
268: l_proc varchar2(72) := g_package||'chk_name';
269: l_api_updating boolean;

Line 275: from per_parent_spines

271: --
272: --
273: cursor csr_unique_name is
274: select 'x'
275: from per_parent_spines
276: where p_name is not null
277: and upper(name) = upper(p_name)
278: and business_group_id + 0 = p_business_group_id
279: -- Start of 3312706

Line 323: (p_associated_column1 => 'PER_PARENT_SPINES.NAME'

319: hr_utility.set_location('Leaving:'||l_proc, 30);
320: exception
321: when app_exception.application_exception then
322: if hr_multi_message.exception_add
323: (p_associated_column1 => 'PER_PARENT_SPINES.NAME'
324: ) then
325: hr_utility.set_location(' Leaving:'||l_proc,40);
326: raise;
327: end if;

Line 362: p_parent_spine_id in per_parent_spines.parent_spine_id%TYPE

358: --
359: -- {End Of Comments}
360: -- ----------------------------------------------------------------------------
361: Procedure chk_increment_frequency(
362: p_parent_spine_id in per_parent_spines.parent_spine_id%TYPE
363: ,p_increment_frequency in per_parent_spines.increment_frequency%TYPE
364: ,p_increment_period in per_parent_spines.increment_period%TYPE
365: ,p_object_version_number in per_parent_spines.object_version_number%TYPE
366: ) is

Line 363: ,p_increment_frequency in per_parent_spines.increment_frequency%TYPE

359: -- {End Of Comments}
360: -- ----------------------------------------------------------------------------
361: Procedure chk_increment_frequency(
362: p_parent_spine_id in per_parent_spines.parent_spine_id%TYPE
363: ,p_increment_frequency in per_parent_spines.increment_frequency%TYPE
364: ,p_increment_period in per_parent_spines.increment_period%TYPE
365: ,p_object_version_number in per_parent_spines.object_version_number%TYPE
366: ) is
367: --

Line 364: ,p_increment_period in per_parent_spines.increment_period%TYPE

360: -- ----------------------------------------------------------------------------
361: Procedure chk_increment_frequency(
362: p_parent_spine_id in per_parent_spines.parent_spine_id%TYPE
363: ,p_increment_frequency in per_parent_spines.increment_frequency%TYPE
364: ,p_increment_period in per_parent_spines.increment_period%TYPE
365: ,p_object_version_number in per_parent_spines.object_version_number%TYPE
366: ) is
367: --
368: l_proc varchar2(72) := g_package||'chk_increment_frequency';

Line 365: ,p_object_version_number in per_parent_spines.object_version_number%TYPE

361: Procedure chk_increment_frequency(
362: p_parent_spine_id in per_parent_spines.parent_spine_id%TYPE
363: ,p_increment_frequency in per_parent_spines.increment_frequency%TYPE
364: ,p_increment_period in per_parent_spines.increment_period%TYPE
365: ,p_object_version_number in per_parent_spines.object_version_number%TYPE
366: ) is
367: --
368: l_proc varchar2(72) := g_package||'chk_increment_frequency';
369: l_api_updating boolean;

Line 436: p_increment_period in per_parent_spines.increment_period%TYPE

432: --
433: -- {End Of Comments}
434: -- ----------------------------------------------------------------------------
435: Procedure chk_increment_period(
436: p_increment_period in per_parent_spines.increment_period%TYPE
437: ,p_increment_frequency in per_parent_spines.increment_frequency%TYPE
438: ,p_effective_date in date
439: ) is
440: --

Line 437: ,p_increment_frequency in per_parent_spines.increment_frequency%TYPE

433: -- {End Of Comments}
434: -- ----------------------------------------------------------------------------
435: Procedure chk_increment_period(
436: p_increment_period in per_parent_spines.increment_period%TYPE
437: ,p_increment_frequency in per_parent_spines.increment_frequency%TYPE
438: ,p_effective_date in date
439: ) is
440: --
441: l_proc varchar2(72) := g_package||'chk_increment_period';

Line 505: p_last_automatic_increment_dat in per_parent_spines.last_automatic_increment_date%TYPE

501: --
502: -- {End Of Comments}
503: -- ----------------------------------------------------------------------------
504: Procedure chk_last_aut_inc_date(
505: p_last_automatic_increment_dat in per_parent_spines.last_automatic_increment_date%TYPE
506: ) is
507: --
508: l_proc varchar2(72) := g_package||'chk_last_aut_inc_date';
509: --

Line 554: p_parent_spine_id in per_parent_spines.parent_spine_id%TYPE

550: -- {End Of Comments}
551: -- ----------------------------------------------------------------------------
552: --
553: PROCEDURE chk_delete(
554: p_parent_spine_id in per_parent_spines.parent_spine_id%TYPE
555: ) is
556: --
557: l_proc varchar2(72) := g_package||'chk_delete';
558: l_exists varchar2(1);

Line 730: ,p_descflex_name => 'PER_PARENT_SPINES'

726: -- b) During insert.
727: --
728: hr_dflex_utility.ins_or_upd_descflex_attribs
729: (p_appl_short_name => 'PER'
730: ,p_descflex_name => 'PER_PARENT_SPINES'
731: ,p_attribute_category => p_rec.attribute_category
732: ,p_attribute1_name => 'ATTRIBUTE1'
733: ,p_attribute1_value => p_rec.attribute1
734: ,p_attribute2_name => 'ATTRIBUTE2'