8: -- ----------------------------------------------------------------------------
9: -- |-----------------------< create_chat_obj_inclusion >----------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_chat_obj_inclusion
12: (p_validate in number default hr_api.g_false_num
13: ,p_effective_date in date
14: ,p_object_id in number
15: ,p_object_type in varchar2
16: ,p_primary_flag in varchar2
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_obj_inclusion >----------------------|
127: -- ----------------------------------------------------------------------------
128: PROCEDURE update_chat_obj_inclusion
129: (p_validate in number default hr_api.g_false_num
130: ,p_effective_date in date
131: ,p_object_id in number
132: ,p_object_type in varchar2
133: ,p_primary_flag 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_object_id in number
132: ,p_object_type in varchar2
133: ,p_primary_flag in varchar2 default hr_api.g_varchar2
134: ,p_start_date_active in date default hr_api.g_date
135: ,p_end_date_active in date default hr_api.g_date
136: ,p_chat_id in number
137: ,p_object_version_number in out nocopy number
130: ,p_effective_date in date
131: ,p_object_id in number
132: ,p_object_type in varchar2
133: ,p_primary_flag in varchar2 default hr_api.g_varchar2
134: ,p_start_date_active in date default hr_api.g_date
135: ,p_end_date_active in date default hr_api.g_date
136: ,p_chat_id in number
137: ,p_object_version_number in out nocopy number
138: ,p_return_status out nocopy varchar2
131: ,p_object_id in number
132: ,p_object_type in varchar2
133: ,p_primary_flag in varchar2 default hr_api.g_varchar2
134: ,p_start_date_active in date default hr_api.g_date
135: ,p_end_date_active in date default hr_api.g_date
136: ,p_chat_id in number
137: ,p_object_version_number in out nocopy number
138: ,p_return_status out nocopy varchar2
139: ) is
168: --
169: -- Convert constant values to their corresponding boolean value
170: --
171: l_validate :=
172: hr_api.constant_to_boolean
173: (p_constant_value => p_validate);
174: --
175: -- Register Surrogate ID or user key values
176: --
240: -- ----------------------------------------------------------------------------
241: -- |-----------------------< delete_chat_obj_inclusion >----------------------|
242: -- ----------------------------------------------------------------------------
243: PROCEDURE delete_chat_obj_inclusion
244: (p_validate in number default hr_api.g_false_num
245: ,p_chat_id in number
246: ,p_object_id in number
247: ,p_object_type in varchar2
248: ,p_object_version_number in number
272: --
273: -- Convert constant values to their corresponding boolean value
274: --
275: l_validate :=
276: hr_api.constant_to_boolean
277: (p_constant_value => p_validate);
278: --
279: -- Register Surrogate ID or user key values
280: --