53: ,p_region_code => p_region_code
54: );
55:
56: exception
57: when hr_api.cannot_find_prog_unit then
58: hr_api.cannot_find_prog_unit_error
59: (p_module_name => 'create_user_interface'
60: ,p_hook_type => 'BP'
61: );
54: );
55:
56: exception
57: when hr_api.cannot_find_prog_unit then
58: hr_api.cannot_find_prog_unit_error
59: (p_module_name => 'create_user_interface'
60: ,p_hook_type => 'BP'
61: );
62: end;
89: ,p_user_interface_id => l_user_interface_id
90: ,p_object_version_number => l_object_version_number
91: );
92: exception
93: when hr_api.cannot_find_prog_unit then
94: hr_api.cannot_find_prog_unit_error
95: (p_module_name => 'create_user_interface'
96: ,p_hook_type => 'AP'
97: );
90: ,p_object_version_number => l_object_version_number
91: );
92: exception
93: when hr_api.cannot_find_prog_unit then
94: hr_api.cannot_find_prog_unit_error
95: (p_module_name => 'create_user_interface'
96: ,p_hook_type => 'AP'
97: );
98: end;
99: --
100: -- When in validation only mode raise the Validate_Enabled exception
101: --
102: if p_validate then
103: raise hr_api.validate_enabled;
104: end if;
105: --
106: -- Set all IN OUT and OUT parameters with out values
107: --
110:
111: --
112: hr_utility.set_location(' Leaving:'||l_proc, 70);
113: exception
114: when hr_api.validate_enabled then
115: --
116: -- As the Validate_Enabled exception has been raised
117: -- we must rollback to the savepoint
118: --
153: (
154: p_validate in boolean default false
155: ,p_effective_date in date
156: ,p_user_interface_id in number
157: ,p_type in varchar2 default hr_api.g_varchar2
158: ,p_form_name in varchar2 default hr_api.g_varchar2
159: ,p_page_region_code in varchar2 default hr_api.g_varchar2
160: ,p_region_code in varchar2 default hr_api.g_varchar2
161: ,p_object_version_number in out nocopy number
154: p_validate in boolean default false
155: ,p_effective_date in date
156: ,p_user_interface_id in number
157: ,p_type in varchar2 default hr_api.g_varchar2
158: ,p_form_name in varchar2 default hr_api.g_varchar2
159: ,p_page_region_code in varchar2 default hr_api.g_varchar2
160: ,p_region_code in varchar2 default hr_api.g_varchar2
161: ,p_object_version_number in out nocopy number
162: ) is
155: ,p_effective_date in date
156: ,p_user_interface_id in number
157: ,p_type in varchar2 default hr_api.g_varchar2
158: ,p_form_name in varchar2 default hr_api.g_varchar2
159: ,p_page_region_code in varchar2 default hr_api.g_varchar2
160: ,p_region_code in varchar2 default hr_api.g_varchar2
161: ,p_object_version_number in out nocopy number
162: ) is
163: --
156: ,p_user_interface_id in number
157: ,p_type in varchar2 default hr_api.g_varchar2
158: ,p_form_name in varchar2 default hr_api.g_varchar2
159: ,p_page_region_code in varchar2 default hr_api.g_varchar2
160: ,p_region_code in varchar2 default hr_api.g_varchar2
161: ,p_object_version_number in out nocopy number
162: ) is
163: --
164: -- Declare cursors and local variables
195: ,p_object_version_number => p_object_version_number
196:
197: );
198: exception
199: when hr_api.cannot_find_prog_unit then
200: hr_api.cannot_find_prog_unit_error
201: (p_module_name => 'update_user_interface'
202: ,p_hook_type => 'BP'
203: );
196:
197: );
198: exception
199: when hr_api.cannot_find_prog_unit then
200: hr_api.cannot_find_prog_unit_error
201: (p_module_name => 'update_user_interface'
202: ,p_hook_type => 'BP'
203: );
204: end;
233: ,p_object_version_number => p_object_version_number
234:
235: );
236: exception
237: when hr_api.cannot_find_prog_unit then
238: hr_api.cannot_find_prog_unit_error
239: (p_module_name => 'update_user_interface'
240: ,p_hook_type => 'AP'
241: );
234:
235: );
236: exception
237: when hr_api.cannot_find_prog_unit then
238: hr_api.cannot_find_prog_unit_error
239: (p_module_name => 'update_user_interface'
240: ,p_hook_type => 'AP'
241: );
242: end;
243: --
244: -- When in validation only mode raise the Validate_Enabled exception
245: --
246: if p_validate then
247: raise hr_api.validate_enabled;
248: end if;
249: --
250: -- Set all IN OUT and OUT parameters with out values
251: --
254:
255: --
256: hr_utility.set_location(' Leaving:'||l_proc, 70);
257: exception
258: when hr_api.validate_enabled then
259: --
260: -- As the Validate_Enabled exception has been raised
261: -- we must rollback to the savepoint
262: --
321: ,p_object_version_number => p_object_version_number
322:
323: );
324: exception
325: when hr_api.cannot_find_prog_unit then
326: hr_api.cannot_find_prog_unit_error
327: (p_module_name => 'delete_user_interface'
328: ,p_hook_type => 'BP'
329: );
322:
323: );
324: exception
325: when hr_api.cannot_find_prog_unit then
326: hr_api.cannot_find_prog_unit_error
327: (p_module_name => 'delete_user_interface'
328: ,p_hook_type => 'BP'
329: );
330: end;
349: p_user_interface_id => p_user_interface_id
350: ,p_object_version_number => p_object_version_number
351: );
352: exception
353: when hr_api.cannot_find_prog_unit then
354: hr_api.cannot_find_prog_unit_error
355: (p_module_name => 'delete_user_interface'
356: ,p_hook_type => 'AP'
357: );
350: ,p_object_version_number => p_object_version_number
351: );
352: exception
353: when hr_api.cannot_find_prog_unit then
354: hr_api.cannot_find_prog_unit_error
355: (p_module_name => 'delete_user_interface'
356: ,p_hook_type => 'AP'
357: );
358: end;
359: --
360: -- When in validation only mode raise the Validate_Enabled exception
361: --
362: if p_validate then
363: raise hr_api.validate_enabled;
364: end if;
365: --
366: -- Set all IN OUT and OUT parameters with out values
367: --
368:
369: --
370: hr_utility.set_location(' Leaving:'||l_proc, 70);
371: exception
372: when hr_api.validate_enabled then
373: --
374: -- As the Validate_Enabled exception has been raised
375: -- we must rollback to the savepoint
376: --