78: ,p_user_id => p_user_id
79: ,p_security_profile_id => p_security_profile_id
80: ,p_process_in_next_run_flag => p_process_in_next_run_flag);
81: exception
82: when hr_api.cannot_find_prog_unit then
83: hr_api.cannot_find_prog_unit_error
84: (p_module_name => 'create_security_user'
85: ,p_hook_type => 'BP'
86: );
79: ,p_security_profile_id => p_security_profile_id
80: ,p_process_in_next_run_flag => p_process_in_next_run_flag);
81: exception
82: when hr_api.cannot_find_prog_unit then
83: hr_api.cannot_find_prog_unit_error
84: (p_module_name => 'create_security_user'
85: ,p_hook_type => 'BP'
86: );
87: end;
117: ,p_security_user_id => l_security_user_id
118: ,p_process_in_next_run_flag => p_process_in_next_run_flag
119: ,p_object_version_number => l_object_version_number);
120: exception
121: when hr_api.cannot_find_prog_unit then
122: hr_api.cannot_find_prog_unit_error
123: (p_module_name => 'create_security_user'
124: ,p_hook_type => 'AP'
125: );
118: ,p_process_in_next_run_flag => p_process_in_next_run_flag
119: ,p_object_version_number => l_object_version_number);
120: exception
121: when hr_api.cannot_find_prog_unit then
122: hr_api.cannot_find_prog_unit_error
123: (p_module_name => 'create_security_user'
124: ,p_hook_type => 'AP'
125: );
126: end;
132: --
133: -- When in validation only mode raise the Validate_Enabled exception
134: --
135: if p_validate then
136: raise hr_api.validate_enabled;
137: end if;
138:
139: --
140: -- Set all output arguments
168: END IF;
169:
170: EXCEPTION
171:
172: WHEN hr_api.validate_enabled THEN
173: --
174: -- As the Validate_Enabled exception has been raised
175: -- we must rollback to the savepoint
176: --
211: PROCEDURE update_security_user
212: (p_validate in boolean default false
213: ,p_effective_date in date
214: ,p_security_user_id in number
215: ,p_user_id in number default hr_api.g_number
216: ,p_security_profile_id in number default hr_api.g_number
217: ,p_process_in_next_run_flag in varchar2 default hr_api.g_varchar2
218: ,p_object_version_number in out nocopy number
219: ,p_del_static_lists_warning out nocopy boolean
212: (p_validate in boolean default false
213: ,p_effective_date in date
214: ,p_security_user_id in number
215: ,p_user_id in number default hr_api.g_number
216: ,p_security_profile_id in number default hr_api.g_number
217: ,p_process_in_next_run_flag in varchar2 default hr_api.g_varchar2
218: ,p_object_version_number in out nocopy number
219: ,p_del_static_lists_warning out nocopy boolean
220: ) IS
213: ,p_effective_date in date
214: ,p_security_user_id in number
215: ,p_user_id in number default hr_api.g_number
216: ,p_security_profile_id in number default hr_api.g_number
217: ,p_process_in_next_run_flag in varchar2 default hr_api.g_varchar2
218: ,p_object_version_number in out nocopy number
219: ,p_del_static_lists_warning out nocopy boolean
220: ) IS
221:
283: ,p_security_profile_id => p_security_profile_id
284: ,p_process_in_next_run_flag => p_process_in_next_run_flag
285: ,p_object_version_number => l_object_version_number);
286: exception
287: when hr_api.cannot_find_prog_unit then
288: hr_api.cannot_find_prog_unit_error
289: (p_module_name => 'update_security_user'
290: ,p_hook_type => 'BP'
291: );
284: ,p_process_in_next_run_flag => p_process_in_next_run_flag
285: ,p_object_version_number => l_object_version_number);
286: exception
287: when hr_api.cannot_find_prog_unit then
288: hr_api.cannot_find_prog_unit_error
289: (p_module_name => 'update_security_user'
290: ,p_hook_type => 'BP'
291: );
292: end;
324: ,p_process_in_next_run_flag => p_process_in_next_run_flag
325: ,p_object_version_number => l_object_version_number
326: ,p_del_static_lists_warning => l_del_static_lists_warning);
327: exception
328: when hr_api.cannot_find_prog_unit then
329: hr_api.cannot_find_prog_unit_error
330: (p_module_name => 'update_security_user'
331: ,p_hook_type => 'AP'
332: );
325: ,p_object_version_number => l_object_version_number
326: ,p_del_static_lists_warning => l_del_static_lists_warning);
327: exception
328: when hr_api.cannot_find_prog_unit then
329: hr_api.cannot_find_prog_unit_error
330: (p_module_name => 'update_security_user'
331: ,p_hook_type => 'AP'
332: );
333: end;
339: --
340: -- When in validation only mode raise the Validate_Enabled exception
341: --
342: if p_validate then
343: raise hr_api.validate_enabled;
344: end if;
345:
346: --
347: -- Set all output arguments
380: END IF;
381:
382: EXCEPTION
383:
384: WHEN hr_api.validate_enabled THEN
385: --
386: -- As the Validate_Enabled exception has been raised
387: -- we must rollback to the savepoint
388: --
478: hr_security_user_bk3.delete_security_user_b
479: (p_security_user_id => p_security_user_id
480: ,p_object_version_number => p_object_version_number);
481: exception
482: when hr_api.cannot_find_prog_unit then
483: hr_api.cannot_find_prog_unit_error
484: (p_module_name => 'delete_security_user'
485: ,p_hook_type => 'BP'
486: );
479: (p_security_user_id => p_security_user_id
480: ,p_object_version_number => p_object_version_number);
481: exception
482: when hr_api.cannot_find_prog_unit then
483: hr_api.cannot_find_prog_unit_error
484: (p_module_name => 'delete_security_user'
485: ,p_hook_type => 'BP'
486: );
487: end;
511: (p_security_user_id => p_security_user_id
512: ,p_object_version_number => p_object_version_number
513: ,p_del_static_lists_warning => l_del_static_lists_warning);
514: exception
515: when hr_api.cannot_find_prog_unit then
516: hr_api.cannot_find_prog_unit_error
517: (p_module_name => 'delete_security_user'
518: ,p_hook_type => 'AP'
519: );
512: ,p_object_version_number => p_object_version_number
513: ,p_del_static_lists_warning => l_del_static_lists_warning);
514: exception
515: when hr_api.cannot_find_prog_unit then
516: hr_api.cannot_find_prog_unit_error
517: (p_module_name => 'delete_security_user'
518: ,p_hook_type => 'AP'
519: );
520: end;
526: --
527: -- When in validation only mode raise the Validate_Enabled exception
528: --
529: if p_validate then
530: raise hr_api.validate_enabled;
531: end if;
532:
533: --
534: -- Set all output arguments
562: END IF;
563:
564: EXCEPTION
565:
566: WHEN hr_api.validate_enabled THEN
567: --
568: -- As the Validate_Enabled exception has been raised
569: -- we must rollback to the savepoint
570: --