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

Line 85: When hr_api.check_integrity_violated Then

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

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

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

Line 90: When hr_api.parent_integrity_violated Then

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

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

90: When hr_api.parent_integrity_violated Then
91: -- Parent integrity has been violated
92: --
93: per_seu_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.unique_integrity_violated Then
96: -- Unique integrity has been violated
97: --
98: per_seu_shd.constraint_error

Line 95: When hr_api.unique_integrity_violated Then

91: -- Parent integrity has been violated
92: --
93: per_seu_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.unique_integrity_violated Then
96: -- Unique integrity has been violated
97: --
98: per_seu_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

95: When hr_api.unique_integrity_violated Then
96: -- Unique integrity has been violated
97: --
98: per_seu_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When Others Then
101: --
102: Raise;
103: End update_dml;

Line 200: IF NVL(per_seu_shd.g_old_rec.user_id, hr_api.g_number)

196: -- A change to the user or security profile means that
197: -- existing permissions stored in the static list are
198: -- incorrect and should be removed.
199: --
200: IF NVL(per_seu_shd.g_old_rec.user_id, hr_api.g_number)
201: <> NVL(p_rec.user_id, hr_api.g_number)
202: OR NVL(per_seu_shd.g_old_rec.security_profile_id, hr_api.g_number)
203: <> NVL(p_rec.security_profile_id, hr_api.g_number)
204: THEN

Line 201: <> NVL(p_rec.user_id, hr_api.g_number)

197: -- existing permissions stored in the static list are
198: -- incorrect and should be removed.
199: --
200: IF NVL(per_seu_shd.g_old_rec.user_id, hr_api.g_number)
201: <> NVL(p_rec.user_id, hr_api.g_number)
202: OR NVL(per_seu_shd.g_old_rec.security_profile_id, hr_api.g_number)
203: <> NVL(p_rec.security_profile_id, hr_api.g_number)
204: THEN
205: --

Line 202: OR NVL(per_seu_shd.g_old_rec.security_profile_id, hr_api.g_number)

198: -- incorrect and should be removed.
199: --
200: IF NVL(per_seu_shd.g_old_rec.user_id, hr_api.g_number)
201: <> NVL(p_rec.user_id, hr_api.g_number)
202: OR NVL(per_seu_shd.g_old_rec.security_profile_id, hr_api.g_number)
203: <> NVL(p_rec.security_profile_id, hr_api.g_number)
204: THEN
205: --
206: -- Set the warning flag to true if the user has static lists

Line 203: <> NVL(p_rec.security_profile_id, hr_api.g_number)

199: --
200: IF NVL(per_seu_shd.g_old_rec.user_id, hr_api.g_number)
201: <> NVL(p_rec.user_id, hr_api.g_number)
202: OR NVL(per_seu_shd.g_old_rec.security_profile_id, hr_api.g_number)
203: <> NVL(p_rec.security_profile_id, hr_api.g_number)
204: THEN
205: --
206: -- Set the warning flag to true if the user has static lists
207: -- and they will be deleted.

Line 255: when hr_api.cannot_find_prog_unit then

251: );
252: --
253: exception
254: --
255: when hr_api.cannot_find_prog_unit then
256: --
257: hr_api.cannot_find_prog_unit_error
258: (p_module_name => 'PER_SECURITY_USERS'
259: ,p_hook_type => 'AU');

Line 257: hr_api.cannot_find_prog_unit_error

253: exception
254: --
255: when hr_api.cannot_find_prog_unit then
256: --
257: hr_api.cannot_find_prog_unit_error
258: (p_module_name => 'PER_SECURITY_USERS'
259: ,p_hook_type => 'AU');
260: --
261: end;

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

319: -- p_rec plsql record structure
320: -- to see if a system default is being used. If a system default
321: -- is being used then we must set to the 'current' argument value.
322: --
323: If (p_rec.user_id = hr_api.g_number) then
324: p_rec.user_id :=
325: per_seu_shd.g_old_rec.user_id;
326: End If;
327: If (p_rec.security_profile_id = hr_api.g_number) then

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

323: If (p_rec.user_id = hr_api.g_number) then
324: p_rec.user_id :=
325: per_seu_shd.g_old_rec.user_id;
326: End If;
327: If (p_rec.security_profile_id = hr_api.g_number) then
328: p_rec.security_profile_id :=
329: per_seu_shd.g_old_rec.security_profile_id;
330: End If;
331: --

Line 404: ,p_user_id in number default hr_api.g_number

400: Procedure upd
401: (p_effective_date in date
402: ,p_security_user_id in number
403: ,p_object_version_number in out nocopy number
404: ,p_user_id in number default hr_api.g_number
405: ,p_security_profile_id in number default hr_api.g_number
406: ,p_process_in_next_run_flag in varchar2 default hr_api.g_varchar2
407: ,p_del_static_lists_warning out nocopy boolean
408: ) is

Line 405: ,p_security_profile_id in number default hr_api.g_number

401: (p_effective_date in date
402: ,p_security_user_id in number
403: ,p_object_version_number in out nocopy number
404: ,p_user_id in number default hr_api.g_number
405: ,p_security_profile_id in number default hr_api.g_number
406: ,p_process_in_next_run_flag in varchar2 default hr_api.g_varchar2
407: ,p_del_static_lists_warning out nocopy boolean
408: ) is
409: --

Line 406: ,p_process_in_next_run_flag in varchar2 default hr_api.g_varchar2

402: ,p_security_user_id in number
403: ,p_object_version_number in out nocopy number
404: ,p_user_id in number default hr_api.g_number
405: ,p_security_profile_id in number default hr_api.g_number
406: ,p_process_in_next_run_flag in varchar2 default hr_api.g_varchar2
407: ,p_del_static_lists_warning out nocopy boolean
408: ) is
409: --
410: l_rec per_seu_shd.g_rec_type;