8: -- ----------------------------------------------------------------------------
9: -- |-------------------------< create_forum_message >-------------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_forum_message
12: (p_validate in number default hr_api.g_false_num
13: ,p_effective_date in date
14: ,p_forum_id in number
15: ,p_forum_thread_id in number
16: ,p_business_group_id in number
50: --
51: -- Convert constant values to their corresponding boolean value
52: --
53: l_validate :=
54: hr_api.constant_to_boolean
55: (p_constant_value => p_validate);
56: --
57: --
58: -- Register Surrogate ID or user key values
135: -- ----------------------------------------------------------------------------
136: -- |-------------------------< update_forum_message >-------------------------|
137: -- ----------------------------------------------------------------------------
138: PROCEDURE update_forum_message
139: (p_validate in number default hr_api.g_false_num
140: ,p_effective_date in date
141: ,p_forum_id in number
142: ,p_forum_thread_id in number
143: ,p_business_group_id in number default hr_api.g_number
139: (p_validate in number default hr_api.g_false_num
140: ,p_effective_date in date
141: ,p_forum_id in number
142: ,p_forum_thread_id in number
143: ,p_business_group_id in number default hr_api.g_number
144: ,p_message_scope in varchar2 default hr_api.g_varchar2
145: ,p_message_body in varchar2 default hr_api.g_varchar2
146: ,p_parent_message_id in number default hr_api.g_number
147: ,p_person_id in number default hr_api.g_number
140: ,p_effective_date in date
141: ,p_forum_id in number
142: ,p_forum_thread_id in number
143: ,p_business_group_id in number default hr_api.g_number
144: ,p_message_scope in varchar2 default hr_api.g_varchar2
145: ,p_message_body in varchar2 default hr_api.g_varchar2
146: ,p_parent_message_id in number default hr_api.g_number
147: ,p_person_id in number default hr_api.g_number
148: ,p_contact_id in number default hr_api.g_number
141: ,p_forum_id in number
142: ,p_forum_thread_id in number
143: ,p_business_group_id in number default hr_api.g_number
144: ,p_message_scope in varchar2 default hr_api.g_varchar2
145: ,p_message_body in varchar2 default hr_api.g_varchar2
146: ,p_parent_message_id in number default hr_api.g_number
147: ,p_person_id in number default hr_api.g_number
148: ,p_contact_id in number default hr_api.g_number
149: ,p_target_person_id in number default hr_api.g_number
142: ,p_forum_thread_id in number
143: ,p_business_group_id in number default hr_api.g_number
144: ,p_message_scope in varchar2 default hr_api.g_varchar2
145: ,p_message_body in varchar2 default hr_api.g_varchar2
146: ,p_parent_message_id in number default hr_api.g_number
147: ,p_person_id in number default hr_api.g_number
148: ,p_contact_id in number default hr_api.g_number
149: ,p_target_person_id in number default hr_api.g_number
150: ,p_target_contact_id in number default hr_api.g_number
143: ,p_business_group_id in number default hr_api.g_number
144: ,p_message_scope in varchar2 default hr_api.g_varchar2
145: ,p_message_body in varchar2 default hr_api.g_varchar2
146: ,p_parent_message_id in number default hr_api.g_number
147: ,p_person_id in number default hr_api.g_number
148: ,p_contact_id in number default hr_api.g_number
149: ,p_target_person_id in number default hr_api.g_number
150: ,p_target_contact_id in number default hr_api.g_number
151: ,p_forum_message_id in number
144: ,p_message_scope in varchar2 default hr_api.g_varchar2
145: ,p_message_body in varchar2 default hr_api.g_varchar2
146: ,p_parent_message_id in number default hr_api.g_number
147: ,p_person_id in number default hr_api.g_number
148: ,p_contact_id in number default hr_api.g_number
149: ,p_target_person_id in number default hr_api.g_number
150: ,p_target_contact_id in number default hr_api.g_number
151: ,p_forum_message_id in number
152: ,p_object_version_number in out nocopy number
145: ,p_message_body in varchar2 default hr_api.g_varchar2
146: ,p_parent_message_id in number default hr_api.g_number
147: ,p_person_id in number default hr_api.g_number
148: ,p_contact_id in number default hr_api.g_number
149: ,p_target_person_id in number default hr_api.g_number
150: ,p_target_contact_id in number default hr_api.g_number
151: ,p_forum_message_id in number
152: ,p_object_version_number in out nocopy number
153: ,p_return_status out nocopy varchar2
146: ,p_parent_message_id in number default hr_api.g_number
147: ,p_person_id in number default hr_api.g_number
148: ,p_contact_id in number default hr_api.g_number
149: ,p_target_person_id in number default hr_api.g_number
150: ,p_target_contact_id in number default hr_api.g_number
151: ,p_forum_message_id in number
152: ,p_object_version_number in out nocopy number
153: ,p_return_status out nocopy varchar2
154: ) is
179: --
180: -- Convert constant values to their corresponding boolean value
181: --
182: l_validate :=
183: hr_api.constant_to_boolean
184: (p_constant_value => p_validate);
185: --
186: --
187: -- Call API
258: -- ----------------------------------------------------------------------------
259: -- |-------------------------< delete_forum_message >-------------------------|
260: -- ----------------------------------------------------------------------------
261: PROCEDURE delete_forum_message
262: (p_validate in number default hr_api.g_false_num
263: ,p_forum_message_id in number
264: ,p_object_version_number in number
265: ,p_return_status out nocopy varchar2
266: ) is
288: --
289: -- Convert constant values to their corresponding boolean value
290: --
291: l_validate :=
292: hr_api.constant_to_boolean
293: (p_constant_value => p_validate);
294: --
295: -- Register Surrogate ID or user key values
296: --