8: -- ----------------------------------------------------------------------------
9: -- |--------------------------< create_chat_message >-------------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_chat_message
12: (p_validate in number default hr_api.g_false_num
13: ,p_effective_date in date
14: ,p_chat_id in number
15: ,p_person_id in number
16: ,p_contact_id in number
47: --
48: -- Convert constant values to their corresponding boolean value
49: --
50: l_validate :=
51: hr_api.constant_to_boolean
52: (p_constant_value => p_validate);
53: --
54: -- Register Surrogate ID or user key values
55: --
125: -- ----------------------------------------------------------------------------
126: -- |--------------------------< update_chat_message >-------------------------|
127: -- ----------------------------------------------------------------------------
128: PROCEDURE update_chat_message
129: (p_validate in number default hr_api.g_false_num
130: ,p_effective_date in date
131: ,p_chat_id in number
132: ,p_person_id in number default hr_api.g_number
133: ,p_contact_id in number default hr_api.g_number
128: PROCEDURE update_chat_message
129: (p_validate in number default hr_api.g_false_num
130: ,p_effective_date in date
131: ,p_chat_id in number
132: ,p_person_id in number default hr_api.g_number
133: ,p_contact_id in number default hr_api.g_number
134: ,p_target_person_id in number default hr_api.g_number
135: ,p_target_contact_id in number default hr_api.g_number
136: ,p_message_text in varchar2 default hr_api.g_varchar2
129: (p_validate in number default hr_api.g_false_num
130: ,p_effective_date in date
131: ,p_chat_id in number
132: ,p_person_id in number default hr_api.g_number
133: ,p_contact_id in number default hr_api.g_number
134: ,p_target_person_id in number default hr_api.g_number
135: ,p_target_contact_id in number default hr_api.g_number
136: ,p_message_text in varchar2 default hr_api.g_varchar2
137: ,p_business_group_id in number default hr_api.g_number
130: ,p_effective_date in date
131: ,p_chat_id in number
132: ,p_person_id in number default hr_api.g_number
133: ,p_contact_id in number default hr_api.g_number
134: ,p_target_person_id in number default hr_api.g_number
135: ,p_target_contact_id in number default hr_api.g_number
136: ,p_message_text in varchar2 default hr_api.g_varchar2
137: ,p_business_group_id in number default hr_api.g_number
138: ,p_chat_message_id in number
131: ,p_chat_id in number
132: ,p_person_id in number default hr_api.g_number
133: ,p_contact_id in number default hr_api.g_number
134: ,p_target_person_id in number default hr_api.g_number
135: ,p_target_contact_id in number default hr_api.g_number
136: ,p_message_text in varchar2 default hr_api.g_varchar2
137: ,p_business_group_id in number default hr_api.g_number
138: ,p_chat_message_id in number
139: ,p_object_version_number in out nocopy number
132: ,p_person_id in number default hr_api.g_number
133: ,p_contact_id in number default hr_api.g_number
134: ,p_target_person_id in number default hr_api.g_number
135: ,p_target_contact_id in number default hr_api.g_number
136: ,p_message_text in varchar2 default hr_api.g_varchar2
137: ,p_business_group_id in number default hr_api.g_number
138: ,p_chat_message_id in number
139: ,p_object_version_number in out nocopy number
140: ,p_return_status out nocopy varchar2
133: ,p_contact_id in number default hr_api.g_number
134: ,p_target_person_id in number default hr_api.g_number
135: ,p_target_contact_id in number default hr_api.g_number
136: ,p_message_text in varchar2 default hr_api.g_varchar2
137: ,p_business_group_id in number default hr_api.g_number
138: ,p_chat_message_id in number
139: ,p_object_version_number in out nocopy number
140: ,p_return_status out nocopy varchar2
141: ) is
166: --
167: -- Convert constant values to their corresponding boolean value
168: --
169: l_validate :=
170: hr_api.constant_to_boolean
171: (p_constant_value => p_validate);
172: --
173: -- Call API
174: --
237: -- ----------------------------------------------------------------------------
238: -- |--------------------------< delete_chat_message >-------------------------|
239: -- ----------------------------------------------------------------------------
240: PROCEDURE delete_chat_message
241: (p_validate in number default hr_api.g_false_num
242: ,p_chat_message_id in number
243: ,p_object_version_number in number
244: ,p_return_status out nocopy varchar2
245: ) is
267: --
268: -- Convert constant values to their corresponding boolean value
269: --
270: l_validate :=
271: hr_api.constant_to_boolean
272: (p_constant_value => p_validate);
273: --
274: -- Register Surrogate ID or user key values
275: --