60: ,p_target_contact_id => p_target_contact_id
61: ,p_object_version_number => p_object_version_number
62: );
63: exception
64: when hr_api.cannot_find_prog_unit then
65: hr_api.cannot_find_prog_unit_error
66: (p_module_name => 'CREATE_FORUM_MESSAGE'
67: ,p_hook_type => 'BP'
68: );
61: ,p_object_version_number => p_object_version_number
62: );
63: exception
64: when hr_api.cannot_find_prog_unit then
65: hr_api.cannot_find_prog_unit_error
66: (p_module_name => 'CREATE_FORUM_MESSAGE'
67: ,p_hook_type => 'BP'
68: );
69: end;
113: ,p_forum_message_id => l_forum_message_id
114: ,p_object_version_number => p_object_version_number
115: );
116: exception
117: when hr_api.cannot_find_prog_unit then
118: hr_api.cannot_find_prog_unit_error
119: (p_module_name => 'CREATE_FORUM_MESSAGE'
120: ,p_hook_type => 'AP'
121: );
114: ,p_object_version_number => p_object_version_number
115: );
116: exception
117: when hr_api.cannot_find_prog_unit then
118: hr_api.cannot_find_prog_unit_error
119: (p_module_name => 'CREATE_FORUM_MESSAGE'
120: ,p_hook_type => 'AP'
121: );
122: end;
125: --
126: -- When in validation only mode raise the Validate_Enabled exception
127: --
128: if p_validate then
129: raise hr_api.validate_enabled;
130: end if;
131: --
132: -- Set all output arguments
133: --
142: end if;
143:
144: hr_utility.set_location(' Leaving:'||l_proc, 70);
145: exception
146: when hr_api.validate_enabled then
147: --
148: -- As the Validate_Enabled exception has been raised
149: -- we must rollback to the savepoint
150: --
175: --
176: procedure update_forum_message(
177: p_validate in boolean default false
178: ,p_effective_date in date
179: ,p_forum_id in number default hr_api.g_number
180: ,p_forum_thread_id in number default hr_api.g_number
181: ,p_business_group_id in number default hr_api.g_number
182: ,p_message_scope in varchar2 default hr_api.g_varchar2
183: ,p_message_body in varchar2 default hr_api.g_varchar2
176: procedure update_forum_message(
177: p_validate in boolean default false
178: ,p_effective_date in date
179: ,p_forum_id in number default hr_api.g_number
180: ,p_forum_thread_id in number default hr_api.g_number
181: ,p_business_group_id in number default hr_api.g_number
182: ,p_message_scope in varchar2 default hr_api.g_varchar2
183: ,p_message_body in varchar2 default hr_api.g_varchar2
184: ,p_parent_message_id in number default hr_api.g_number
177: p_validate in boolean default false
178: ,p_effective_date in date
179: ,p_forum_id in number default hr_api.g_number
180: ,p_forum_thread_id in number default hr_api.g_number
181: ,p_business_group_id in number default hr_api.g_number
182: ,p_message_scope in varchar2 default hr_api.g_varchar2
183: ,p_message_body in varchar2 default hr_api.g_varchar2
184: ,p_parent_message_id in number default hr_api.g_number
185: ,p_person_id in number default hr_api.g_number
178: ,p_effective_date in date
179: ,p_forum_id in number default hr_api.g_number
180: ,p_forum_thread_id in number default hr_api.g_number
181: ,p_business_group_id in number default hr_api.g_number
182: ,p_message_scope in varchar2 default hr_api.g_varchar2
183: ,p_message_body in varchar2 default hr_api.g_varchar2
184: ,p_parent_message_id in number default hr_api.g_number
185: ,p_person_id in number default hr_api.g_number
186: ,p_contact_id in number default hr_api.g_number
179: ,p_forum_id in number default hr_api.g_number
180: ,p_forum_thread_id in number default hr_api.g_number
181: ,p_business_group_id in number default hr_api.g_number
182: ,p_message_scope in varchar2 default hr_api.g_varchar2
183: ,p_message_body in varchar2 default hr_api.g_varchar2
184: ,p_parent_message_id in number default hr_api.g_number
185: ,p_person_id in number default hr_api.g_number
186: ,p_contact_id in number default hr_api.g_number
187: ,p_target_person_id in number default hr_api.g_number
180: ,p_forum_thread_id in number default hr_api.g_number
181: ,p_business_group_id in number default hr_api.g_number
182: ,p_message_scope in varchar2 default hr_api.g_varchar2
183: ,p_message_body in varchar2 default hr_api.g_varchar2
184: ,p_parent_message_id in number default hr_api.g_number
185: ,p_person_id in number default hr_api.g_number
186: ,p_contact_id in number default hr_api.g_number
187: ,p_target_person_id in number default hr_api.g_number
188: ,p_target_contact_id in number default hr_api.g_number
181: ,p_business_group_id in number default hr_api.g_number
182: ,p_message_scope in varchar2 default hr_api.g_varchar2
183: ,p_message_body in varchar2 default hr_api.g_varchar2
184: ,p_parent_message_id in number default hr_api.g_number
185: ,p_person_id in number default hr_api.g_number
186: ,p_contact_id in number default hr_api.g_number
187: ,p_target_person_id in number default hr_api.g_number
188: ,p_target_contact_id in number default hr_api.g_number
189: ,p_forum_message_id in number
182: ,p_message_scope in varchar2 default hr_api.g_varchar2
183: ,p_message_body in varchar2 default hr_api.g_varchar2
184: ,p_parent_message_id in number default hr_api.g_number
185: ,p_person_id in number default hr_api.g_number
186: ,p_contact_id in number default hr_api.g_number
187: ,p_target_person_id in number default hr_api.g_number
188: ,p_target_contact_id in number default hr_api.g_number
189: ,p_forum_message_id in number
190: ,p_object_version_number in out nocopy number) is
183: ,p_message_body in varchar2 default hr_api.g_varchar2
184: ,p_parent_message_id in number default hr_api.g_number
185: ,p_person_id in number default hr_api.g_number
186: ,p_contact_id in number default hr_api.g_number
187: ,p_target_person_id in number default hr_api.g_number
188: ,p_target_contact_id in number default hr_api.g_number
189: ,p_forum_message_id in number
190: ,p_object_version_number in out nocopy number) is
191: --
184: ,p_parent_message_id in number default hr_api.g_number
185: ,p_person_id in number default hr_api.g_number
186: ,p_contact_id in number default hr_api.g_number
187: ,p_target_person_id in number default hr_api.g_number
188: ,p_target_contact_id in number default hr_api.g_number
189: ,p_forum_message_id in number
190: ,p_object_version_number in out nocopy number) is
191: --
192: -- Declare cursors and local variables
225: ,p_forum_message_id => p_forum_message_id
226: ,p_object_version_number => l_object_version_number
227: );
228: exception
229: when hr_api.cannot_find_prog_unit then
230: hr_api.cannot_find_prog_unit_error
231: (p_module_name => 'UPDATE_FORUM_MESSAGE'
232: ,p_hook_type => 'BP'
233: );
226: ,p_object_version_number => l_object_version_number
227: );
228: exception
229: when hr_api.cannot_find_prog_unit then
230: hr_api.cannot_find_prog_unit_error
231: (p_module_name => 'UPDATE_FORUM_MESSAGE'
232: ,p_hook_type => 'BP'
233: );
234: end;
278: ,p_forum_message_id => p_forum_message_id
279: ,p_object_version_number => l_object_version_number
280: );
281: exception
282: when hr_api.cannot_find_prog_unit then
283: hr_api.cannot_find_prog_unit_error
284: (p_module_name => 'UPDATE_FORUM_MESSAGE'
285: ,p_hook_type => 'AP'
286: );
279: ,p_object_version_number => l_object_version_number
280: );
281: exception
282: when hr_api.cannot_find_prog_unit then
283: hr_api.cannot_find_prog_unit_error
284: (p_module_name => 'UPDATE_FORUM_MESSAGE'
285: ,p_hook_type => 'AP'
286: );
287: end;
290: --
291: -- When in validation only mode raise the Validate_Enabled exception
292: --
293: if p_validate then
294: raise hr_api.validate_enabled;
295: end if;
296: --
297:
298: hr_utility.set_location(' Leaving:'||l_proc, 70);
296: --
297:
298: hr_utility.set_location(' Leaving:'||l_proc, 70);
299: exception
300: when hr_api.validate_enabled then
301: --
302: -- As the Validate_Enabled exception has been raised
303: -- we must rollback to the savepoint
304: --
365: (p_forum_message_id =>p_forum_message_id
366: ,p_object_version_number =>p_object_version_number
367: );
368: exception
369: when hr_api.cannot_find_prog_unit then
370: hr_api.cannot_find_prog_unit_error
371: (p_module_name => 'DELETE_FORUM_MESSAGE'
372: ,p_hook_type => 'BP'
373: );
366: ,p_object_version_number =>p_object_version_number
367: );
368: exception
369: when hr_api.cannot_find_prog_unit then
370: hr_api.cannot_find_prog_unit_error
371: (p_module_name => 'DELETE_FORUM_MESSAGE'
372: ,p_hook_type => 'BP'
373: );
374: end;
409: (p_forum_message_id =>p_forum_message_id
410: ,p_object_version_number =>p_object_version_number
411: );
412: exception
413: when hr_api.cannot_find_prog_unit then
414: hr_api.cannot_find_prog_unit_error
415: (p_module_name => 'DELETE_FORUM_MESSAGE'
416: ,p_hook_type => 'AP'
417: );
410: ,p_object_version_number =>p_object_version_number
411: );
412: exception
413: when hr_api.cannot_find_prog_unit then
414: hr_api.cannot_find_prog_unit_error
415: (p_module_name => 'DELETE_FORUM_MESSAGE'
416: ,p_hook_type => 'AP'
417: );
418: end;
419: --
420: -- When in validation only mode raise the Validate_Enabled exception
421: --
422: if p_validate then
423: raise hr_api.validate_enabled;
424: end if;
425: --
426: -- Set all output arguments
427: --
427: --
428: --
429: hr_utility.set_location(' Leaving:'||l_proc, 170);
430: exception
431: when hr_api.validate_enabled then
432: --
433: -- As the Validate_Enabled exception has been raised
434: -- we must rollback to the savepoint
435: --