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_UPD dependencies on HR_API

Line 83: When hr_api.check_integrity_violated Then

79: --
80: hr_utility.set_location(' Leaving:'||l_proc, 10);
81: --
82: Exception
83: When hr_api.check_integrity_violated Then
84: -- A check constraint has been violated
85: per_asp_shd.constraint_error
86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
87: When hr_api.parent_integrity_violated Then

Line 86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

82: Exception
83: When hr_api.check_integrity_violated Then
84: -- A check constraint has been violated
85: per_asp_shd.constraint_error
86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
87: When hr_api.parent_integrity_violated Then
88: -- Parent integrity has been violated
89: per_asp_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 87: When hr_api.parent_integrity_violated Then

83: When hr_api.check_integrity_violated Then
84: -- A check constraint has been violated
85: per_asp_shd.constraint_error
86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
87: When hr_api.parent_integrity_violated Then
88: -- Parent integrity has been violated
89: per_asp_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.unique_integrity_violated Then

Line 90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
87: When hr_api.parent_integrity_violated Then
88: -- Parent integrity has been violated
89: per_asp_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.unique_integrity_violated Then
92: -- Unique integrity has been violated
93: per_asp_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 91: When hr_api.unique_integrity_violated Then

87: When hr_api.parent_integrity_violated Then
88: -- Parent integrity has been violated
89: per_asp_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.unique_integrity_violated Then
92: -- Unique integrity has been violated
93: per_asp_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When Others Then

Line 94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.unique_integrity_violated Then
92: -- Unique integrity has been violated
93: per_asp_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When Others Then
96: Raise;
97: End update_dml;
98: --

Line 222: when hr_api.cannot_find_prog_unit then

218: );
219: --
220: exception
221: --
222: when hr_api.cannot_find_prog_unit then
223: --
224: hr_api.cannot_find_prog_unit_error
225: (p_module_name => 'per_sec_profile_assignments'
226: ,p_hook_type => 'AU');

Line 224: hr_api.cannot_find_prog_unit_error

220: exception
221: --
222: when hr_api.cannot_find_prog_unit then
223: --
224: hr_api.cannot_find_prog_unit_error
225: (p_module_name => 'per_sec_profile_assignments'
226: ,p_hook_type => 'AU');
227: --
228: end;

Line 293: If (p_rec.user_id = hr_api.g_number) then

289: -- p_rec plsql record structure
290: -- to see if a system default is being used. If a system default
291: -- is being used then we must set to the 'current' argument value.
292: --
293: If (p_rec.user_id = hr_api.g_number) then
294: p_rec.user_id :=
295: per_asp_shd.g_old_rec.user_id;
296: End If;
297: If (p_rec.security_group_id = hr_api.g_number) then

Line 297: If (p_rec.security_group_id = hr_api.g_number) then

293: If (p_rec.user_id = hr_api.g_number) then
294: p_rec.user_id :=
295: per_asp_shd.g_old_rec.user_id;
296: End If;
297: If (p_rec.security_group_id = hr_api.g_number) then
298: p_rec.security_group_id :=
299: per_asp_shd.g_old_rec.security_group_id;
300: End If;
301: If (p_rec.business_group_id = hr_api.g_number) then

Line 301: If (p_rec.business_group_id = hr_api.g_number) then

297: If (p_rec.security_group_id = hr_api.g_number) then
298: p_rec.security_group_id :=
299: per_asp_shd.g_old_rec.security_group_id;
300: End If;
301: If (p_rec.business_group_id = hr_api.g_number) then
302: p_rec.business_group_id :=
303: per_asp_shd.g_old_rec.business_group_id;
304: End If;
305: If (p_rec.security_profile_id = hr_api.g_number) then

Line 305: If (p_rec.security_profile_id = hr_api.g_number) then

301: If (p_rec.business_group_id = hr_api.g_number) then
302: p_rec.business_group_id :=
303: per_asp_shd.g_old_rec.business_group_id;
304: End If;
305: If (p_rec.security_profile_id = hr_api.g_number) then
306: p_rec.security_profile_id :=
307: per_asp_shd.g_old_rec.security_profile_id;
308: End If;
309: If (p_rec.responsibility_id = hr_api.g_number) then

Line 309: If (p_rec.responsibility_id = hr_api.g_number) then

305: If (p_rec.security_profile_id = hr_api.g_number) then
306: p_rec.security_profile_id :=
307: per_asp_shd.g_old_rec.security_profile_id;
308: End If;
309: If (p_rec.responsibility_id = hr_api.g_number) then
310: p_rec.responsibility_id :=
311: per_asp_shd.g_old_rec.responsibility_id;
312: End If;
313: If (p_rec.responsibility_application_id = hr_api.g_number) then

Line 313: If (p_rec.responsibility_application_id = hr_api.g_number) then

309: If (p_rec.responsibility_id = hr_api.g_number) then
310: p_rec.responsibility_id :=
311: per_asp_shd.g_old_rec.responsibility_id;
312: End If;
313: If (p_rec.responsibility_application_id = hr_api.g_number) then
314: p_rec.responsibility_application_id :=
315: per_asp_shd.g_old_rec.responsibility_application_id;
316: End If;
317: If (p_rec.start_date = hr_api.g_date) then

Line 317: If (p_rec.start_date = hr_api.g_date) then

313: If (p_rec.responsibility_application_id = hr_api.g_number) then
314: p_rec.responsibility_application_id :=
315: per_asp_shd.g_old_rec.responsibility_application_id;
316: End If;
317: If (p_rec.start_date = hr_api.g_date) then
318: p_rec.start_date :=
319: per_asp_shd.g_old_rec.start_date;
320: End If;
321: If (p_rec.end_date = hr_api.g_date) then

Line 321: If (p_rec.end_date = hr_api.g_date) then

317: If (p_rec.start_date = hr_api.g_date) then
318: p_rec.start_date :=
319: per_asp_shd.g_old_rec.start_date;
320: End If;
321: If (p_rec.end_date = hr_api.g_date) then
322: p_rec.end_date :=
323: per_asp_shd.g_old_rec.end_date;
324: End If;
325:

Line 380: -- p_user_id in number default hr_api.g_number,

376: -- ----------------------------------------------------------------------------
377: Procedure upd
378: (
379: p_sec_profile_assignment_id in number,
380: -- p_user_id in number default hr_api.g_number,
381: -- p_security_group_id in number default hr_api.g_number,
382: -- p_security_profile_id in number default hr_api.g_number,
383: -- p_responsibility_id in number default hr_api.g_number,
384: -- p_responsibility_application_i in number default hr_api.g_number,

Line 381: -- p_security_group_id in number default hr_api.g_number,

377: Procedure upd
378: (
379: p_sec_profile_assignment_id in number,
380: -- p_user_id in number default hr_api.g_number,
381: -- p_security_group_id in number default hr_api.g_number,
382: -- p_security_profile_id in number default hr_api.g_number,
383: -- p_responsibility_id in number default hr_api.g_number,
384: -- p_responsibility_application_i in number default hr_api.g_number,
385: p_start_date in date default hr_api.g_date,

Line 382: -- p_security_profile_id in number default hr_api.g_number,

378: (
379: p_sec_profile_assignment_id in number,
380: -- p_user_id in number default hr_api.g_number,
381: -- p_security_group_id in number default hr_api.g_number,
382: -- p_security_profile_id in number default hr_api.g_number,
383: -- p_responsibility_id in number default hr_api.g_number,
384: -- p_responsibility_application_i in number default hr_api.g_number,
385: p_start_date in date default hr_api.g_date,
386: p_end_date in date default hr_api.g_date,

Line 383: -- p_responsibility_id in number default hr_api.g_number,

379: p_sec_profile_assignment_id in number,
380: -- p_user_id in number default hr_api.g_number,
381: -- p_security_group_id in number default hr_api.g_number,
382: -- p_security_profile_id in number default hr_api.g_number,
383: -- p_responsibility_id in number default hr_api.g_number,
384: -- p_responsibility_application_i in number default hr_api.g_number,
385: p_start_date in date default hr_api.g_date,
386: p_end_date in date default hr_api.g_date,
387: p_object_version_number in out nocopy number

Line 384: -- p_responsibility_application_i in number default hr_api.g_number,

380: -- p_user_id in number default hr_api.g_number,
381: -- p_security_group_id in number default hr_api.g_number,
382: -- p_security_profile_id in number default hr_api.g_number,
383: -- p_responsibility_id in number default hr_api.g_number,
384: -- p_responsibility_application_i in number default hr_api.g_number,
385: p_start_date in date default hr_api.g_date,
386: p_end_date in date default hr_api.g_date,
387: p_object_version_number in out nocopy number
388: ) is

Line 385: p_start_date in date default hr_api.g_date,

381: -- p_security_group_id in number default hr_api.g_number,
382: -- p_security_profile_id in number default hr_api.g_number,
383: -- p_responsibility_id in number default hr_api.g_number,
384: -- p_responsibility_application_i in number default hr_api.g_number,
385: p_start_date in date default hr_api.g_date,
386: p_end_date in date default hr_api.g_date,
387: p_object_version_number in out nocopy number
388: ) is
389: --

Line 386: p_end_date in date default hr_api.g_date,

382: -- p_security_profile_id in number default hr_api.g_number,
383: -- p_responsibility_id in number default hr_api.g_number,
384: -- p_responsibility_application_i in number default hr_api.g_number,
385: p_start_date in date default hr_api.g_date,
386: p_end_date in date default hr_api.g_date,
387: p_object_version_number in out nocopy number
388: ) is
389: --
390: l_rec per_asp_shd.g_rec_type;

Line 418: hr_api.g_number,

414: l_rec :=
415: per_asp_shd.convert_args
416: (
417: p_sec_profile_assignment_id,
418: hr_api.g_number,
419: hr_api.g_number,
420: hr_api.g_number,
421: hr_api.g_number,
422: hr_api.g_number,

Line 419: hr_api.g_number,

415: per_asp_shd.convert_args
416: (
417: p_sec_profile_assignment_id,
418: hr_api.g_number,
419: hr_api.g_number,
420: hr_api.g_number,
421: hr_api.g_number,
422: hr_api.g_number,
423: hr_api.g_number,

Line 420: hr_api.g_number,

416: (
417: p_sec_profile_assignment_id,
418: hr_api.g_number,
419: hr_api.g_number,
420: hr_api.g_number,
421: hr_api.g_number,
422: hr_api.g_number,
423: hr_api.g_number,
424: p_start_date,

Line 421: hr_api.g_number,

417: p_sec_profile_assignment_id,
418: hr_api.g_number,
419: hr_api.g_number,
420: hr_api.g_number,
421: hr_api.g_number,
422: hr_api.g_number,
423: hr_api.g_number,
424: p_start_date,
425: p_end_date,

Line 422: hr_api.g_number,

418: hr_api.g_number,
419: hr_api.g_number,
420: hr_api.g_number,
421: hr_api.g_number,
422: hr_api.g_number,
423: hr_api.g_number,
424: p_start_date,
425: p_end_date,
426: p_object_version_number

Line 423: hr_api.g_number,

419: hr_api.g_number,
420: hr_api.g_number,
421: hr_api.g_number,
422: hr_api.g_number,
423: hr_api.g_number,
424: p_start_date,
425: p_end_date,
426: p_object_version_number
427: );