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_ASP_BUS dependencies on PER_ASP_SHD

Line 46: l_api_updating := per_asp_shd.api_updating

42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := per_asp_shd.api_updating
47: (p_sec_profile_assignment_id => p_sec_profile_assignment_id,
48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating

Line 52: <> per_asp_shd.g_old_rec.sec_profile_assignment_id) then

48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating
51: and nvl(p_sec_profile_assignment_id,hr_api.g_number)
52: <> per_asp_shd.g_old_rec.sec_profile_assignment_id) then
53: --
54: -- raise error as PK has changed
55: --
56: per_asp_shd.constraint_error('PER_SEC_PROFILE_ASSIGNMENTS_PK');

Line 56: per_asp_shd.constraint_error('PER_SEC_PROFILE_ASSIGNMENTS_PK');

52: <> per_asp_shd.g_old_rec.sec_profile_assignment_id) then
53: --
54: -- raise error as PK has changed
55: --
56: per_asp_shd.constraint_error('PER_SEC_PROFILE_ASSIGNMENTS_PK');
57: --
58: elsif not l_api_updating then
59: --
60: -- check if PK is null

Line 66: per_asp_shd.constraint_error('PER_SEC_PROFILE_ASSIGNMENTS_PK');

62: if p_sec_profile_assignment_id is not null then
63: --
64: -- raise error as PK is not null
65: --
66: per_asp_shd.constraint_error('PER_SEC_PROFILE_ASSIGNMENTS_PK');
67: --
68: end if;
69: --
70: end if;

Line 118: l_api_updating := per_asp_shd.api_updating

114: Begin
115: --
116: hr_utility.set_location('Entering:'||l_proc,5);
117: --
118: l_api_updating := per_asp_shd.api_updating
119: (p_sec_profile_assignment_id => p_sec_profile_assignment_id,
120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating

Line 124: <> nvl(per_asp_shd.g_old_rec.security_profile_id,hr_api.g_number)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and nvl(p_security_profile_id,hr_api.g_number)
124: <> nvl(per_asp_shd.g_old_rec.security_profile_id,hr_api.g_number)
125: or not l_api_updating) then
126: --
127: -- check if security_profile_id value exists in per_security_profiles table
128: --

Line 139: per_asp_shd.constraint_error('PER_SEC_PROFILE_ASSIGNMENTS_FK');

135: --
136: -- raise error as FK does not relate to PK in per_security_profiles
137: -- table.
138: --
139: per_asp_shd.constraint_error('PER_SEC_PROFILE_ASSIGNMENTS_FK');
140: --
141: end if;
142: --
143: close c1;

Line 194: l_api_updating := per_asp_shd.api_updating

190: Begin
191: --
192: hr_utility.set_location('Entering:'||l_proc,5);
193: --
194: l_api_updating := per_asp_shd.api_updating
195: (p_sec_profile_assignment_id => p_sec_profile_assignment_id,
196: p_object_version_number => p_object_version_number);
197: --
198: if (l_api_updating

Line 200: <> nvl(per_asp_shd.g_old_rec.business_group_id,hr_api.g_number)

196: p_object_version_number => p_object_version_number);
197: --
198: if (l_api_updating
199: and nvl(p_business_group_id,hr_api.g_number)
200: <> nvl(per_asp_shd.g_old_rec.business_group_id,hr_api.g_number)
201: or not l_api_updating) then
202: --
203: -- check if business_group_id value exists in per_business_groups view
204: --

Line 215: per_asp_shd.constraint_error('PER_SEC_PROFILE_ASSIGNMENTS_FK');

211: --
212: -- raise error as FK does not relate to PK in per_business_groups
213: -- view
214: --
215: per_asp_shd.constraint_error('PER_SEC_PROFILE_ASSIGNMENTS_FK');
216: --
217: end if;
218: --
219: close c1;

Line 268: (p_rec IN per_asp_shd.g_rec_type

264: -- {End Of Comments}
265: -- ----------------------------------------------------------------------------
266: --
267: PROCEDURE chk_non_updateable_args
268: (p_rec IN per_asp_shd.g_rec_type
269: )
270: IS
271: --
272: l_proc VARCHAR2 (72) := g_package||'chk_non_updateable_args';

Line 282: IF NOT per_asp_shd.api_updating

278: --
279: -- Only proceed with validation if a row exists for
280: -- the current record in the HR Schema
281: --
282: IF NOT per_asp_shd.api_updating
283: (p_sec_profile_assignment_id => p_rec.sec_profile_assignment_id
284: ,p_object_version_number => p_rec.object_version_number
285: )
286: THEN

Line 295: <> per_asp_shd.g_old_rec.sec_profile_assignment_id

291: --
292: hr_utility.set_location(l_proc, 30);
293: --
294: IF p_rec.sec_profile_assignment_id
295: <> per_asp_shd.g_old_rec.sec_profile_assignment_id
296: THEN
297: --
298: l_argument := 'sec_profile_assignment_id';
299: raise l_error;

Line 306: <> per_asp_shd.g_old_rec.user_id

302: --
303: hr_utility.set_location(l_proc, 40);
304: --
305: IF p_rec.user_id
306: <> per_asp_shd.g_old_rec.user_id
307: THEN
308: --
309: l_argument := 'user_id';
310: raise l_error;

Line 317: <> per_asp_shd.g_old_rec.security_group_id

313: --
314: hr_utility.set_location(l_proc, 50);
315: --
316: IF p_rec.security_group_id
317: <> per_asp_shd.g_old_rec.security_group_id
318: THEN
319: --
320: l_argument := 'security_group_id';
321: raise l_error;

Line 328: <> per_asp_shd.g_old_rec.business_group_id

324: --
325: hr_utility.set_location(l_proc, 55);
326: --
327: IF p_rec.business_group_id
328: <> per_asp_shd.g_old_rec.business_group_id
329: THEN
330: --
331: l_argument := 'business_group_id';
332: raise l_error;

Line 339: <> per_asp_shd.g_old_rec.security_profile_id

335: --
336: hr_utility.set_location(l_proc, 60);
337: --
338: IF p_rec.security_profile_id
339: <> per_asp_shd.g_old_rec.security_profile_id
340: THEN
341: --
342: l_argument := 'security_profile_id';
343: raise l_error;

Line 350: <> per_asp_shd.g_old_rec.responsibility_id

346: --
347: hr_utility.set_location(l_proc, 70);
348: --
349: IF p_rec.responsibility_id
350: <> per_asp_shd.g_old_rec.responsibility_id
351: THEN
352: --
353: l_argument := 'responsibility_id';
354: raise l_error;

Line 361: <> per_asp_shd.g_old_rec.responsibility_application_id

357: --
358: hr_utility.set_location(l_proc, 80);
359: --
360: IF p_rec.responsibility_application_id
361: <> per_asp_shd.g_old_rec.responsibility_application_id
362: THEN
363: --
364: l_argument := 'responsibility_application_id';
365: raise l_error;

Line 869: Procedure insert_validate(p_rec in per_asp_shd.g_rec_type) is

865: --
866: -- ----------------------------------------------------------------------------
867: -- |---------------------------< insert_validate >----------------------------|
868: -- ----------------------------------------------------------------------------
869: Procedure insert_validate(p_rec in per_asp_shd.g_rec_type) is
870: --
871: l_proc varchar2(72) := g_package||'insert_validate';
872: --
873: Begin

Line 965: Procedure update_validate(p_rec in per_asp_shd.g_rec_type) is

961: --
962: -- ----------------------------------------------------------------------------
963: -- |---------------------------< update_validate >----------------------------|
964: -- ----------------------------------------------------------------------------
965: Procedure update_validate(p_rec in per_asp_shd.g_rec_type) is
966: --
967: l_proc varchar2(72) := g_package||'update_validate';
968: --
969: Begin