48: ,p_login_date => p_login_date
49: ,p_object_version_number => p_object_version_number
50: );
51: exception
52: when hr_api.cannot_find_prog_unit then
53: hr_api.cannot_find_prog_unit_error
54: (p_module_name => 'CREATE_CHAT_USER'
55: ,p_hook_type => 'BP'
56: );
49: ,p_object_version_number => p_object_version_number
50: );
51: exception
52: when hr_api.cannot_find_prog_unit then
53: hr_api.cannot_find_prog_unit_error
54: (p_module_name => 'CREATE_CHAT_USER'
55: ,p_hook_type => 'BP'
56: );
57: end;
87: ,p_login_date => p_login_date
88: ,p_object_version_number => p_object_version_number
89: );
90: exception
91: when hr_api.cannot_find_prog_unit then
92: hr_api.cannot_find_prog_unit_error
93: (p_module_name => 'CREATE_CHAT_USER'
94: ,p_hook_type => 'AP'
95: );
88: ,p_object_version_number => p_object_version_number
89: );
90: exception
91: when hr_api.cannot_find_prog_unit then
92: hr_api.cannot_find_prog_unit_error
93: (p_module_name => 'CREATE_CHAT_USER'
94: ,p_hook_type => 'AP'
95: );
96: 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 output arguments
107: --
109:
110:
111: hr_utility.set_location(' Leaving:'||l_proc, 70);
112: exception
113: when hr_api.validate_enabled then
114: --
115: -- As the Validate_Enabled exception has been raised
116: -- we must rollback to the savepoint
117: --
142: procedure update_chat_user (
143: p_validate in boolean default false
144: ,p_effective_date in date
145: ,p_chat_id in number
146: ,p_person_id in number default hr_api.g_number
147: ,p_contact_id in number default hr_api.g_number
148: ,p_login_date in date
149: ,p_business_group_id in number
150: ,p_object_version_number in out nocopy number) is
143: p_validate in boolean default false
144: ,p_effective_date in date
145: ,p_chat_id in number
146: ,p_person_id in number default hr_api.g_number
147: ,p_contact_id in number default hr_api.g_number
148: ,p_login_date in date
149: ,p_business_group_id in number
150: ,p_object_version_number in out nocopy number) is
151: --
174: ,p_login_date => p_login_date
175: ,p_object_version_number => l_object_version_number
176: );
177: exception
178: when hr_api.cannot_find_prog_unit then
179: hr_api.cannot_find_prog_unit_error
180: (p_module_name => 'UPDATE_CHAT_USER'
181: ,p_hook_type => 'BP'
182: );
175: ,p_object_version_number => l_object_version_number
176: );
177: exception
178: when hr_api.cannot_find_prog_unit then
179: hr_api.cannot_find_prog_unit_error
180: (p_module_name => 'UPDATE_CHAT_USER'
181: ,p_hook_type => 'BP'
182: );
183: end;
213: ,p_login_date => p_login_date
214: ,p_object_version_number => l_object_version_number
215: );
216: exception
217: when hr_api.cannot_find_prog_unit then
218: hr_api.cannot_find_prog_unit_error
219: (p_module_name => 'UPDATE_CHAT_USER'
220: ,p_hook_type => 'AP'
221: );
214: ,p_object_version_number => l_object_version_number
215: );
216: exception
217: when hr_api.cannot_find_prog_unit then
218: hr_api.cannot_find_prog_unit_error
219: (p_module_name => 'UPDATE_CHAT_USER'
220: ,p_hook_type => 'AP'
221: );
222: end;
225: --
226: -- When in validation only mode raise the Validate_Enabled exception
227: --
228: if p_validate then
229: raise hr_api.validate_enabled;
230: end if;
231: --
232:
233: hr_utility.set_location(' Leaving:'||l_proc, 70);
231: --
232:
233: hr_utility.set_location(' Leaving:'||l_proc, 70);
234: exception
235: when hr_api.validate_enabled then
236: --
237: -- As the Validate_Enabled exception has been raised
238: -- we must rollback to the savepoint
239: --
292: ,p_contact_id => p_contact_id
293: ,p_object_version_number => p_object_version_number
294: );
295: exception
296: when hr_api.cannot_find_prog_unit then
297: hr_api.cannot_find_prog_unit_error
298: (p_module_name => 'DELETE_CHAT_USER'
299: ,p_hook_type => 'BP'
300: );
293: ,p_object_version_number => p_object_version_number
294: );
295: exception
296: when hr_api.cannot_find_prog_unit then
297: hr_api.cannot_find_prog_unit_error
298: (p_module_name => 'DELETE_CHAT_USER'
299: ,p_hook_type => 'BP'
300: );
301: end;
323: ,p_contact_id => p_contact_id
324: ,p_object_version_number => p_object_version_number
325: );
326: exception
327: when hr_api.cannot_find_prog_unit then
328: hr_api.cannot_find_prog_unit_error
329: (p_module_name => 'DELETE_CHAT_USER'
330: ,p_hook_type => 'AP'
331: );
324: ,p_object_version_number => p_object_version_number
325: );
326: exception
327: when hr_api.cannot_find_prog_unit then
328: hr_api.cannot_find_prog_unit_error
329: (p_module_name => 'DELETE_CHAT_USER'
330: ,p_hook_type => 'AP'
331: );
332: end;
333: --
334: -- When in validation only mode raise the Validate_Enabled exception
335: --
336: if p_validate then
337: raise hr_api.validate_enabled;
338: end if;
339: --
340: -- Set all output arguments
341: --
341: --
342: --
343: hr_utility.set_location(' Leaving:'||l_proc, 170);
344: exception
345: when hr_api.validate_enabled then
346: --
347: -- As the Validate_Enabled exception has been raised
348: -- we must rollback to the savepoint
349: --