8: -- ----------------------------------------------------------------------------
9: -- |------------------------------< create_note >-----------------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_note
12: (p_validate in number default hr_api.g_false_num
13: ,p_offer_status_history_id in number
14: ,p_note_text in varchar2
15: ,p_note_id in number
16: ,p_object_version_number out nocopy number
41: --
42: -- Convert constant values to their corresponding boolean value
43: --
44: l_validate :=
45: hr_api.constant_to_boolean
46: (p_constant_value => p_validate);
47: --
48: -- Register Surrogate ID or user key values
49: --
112: -- ----------------------------------------------------------------------------
113: -- |------------------------------< update_note >-----------------------------|
114: -- ----------------------------------------------------------------------------
115: PROCEDURE update_note
116: (p_validate in number default hr_api.g_false_num
117: ,p_note_id in number
118: ,p_offer_status_history_id in number default hr_api.g_number
119: ,p_note_text in varchar2 default hr_api.g_varchar2
120: ,p_object_version_number in out nocopy number
114: -- ----------------------------------------------------------------------------
115: PROCEDURE update_note
116: (p_validate in number default hr_api.g_false_num
117: ,p_note_id in number
118: ,p_offer_status_history_id in number default hr_api.g_number
119: ,p_note_text in varchar2 default hr_api.g_varchar2
120: ,p_object_version_number in out nocopy number
121: ,p_return_status out nocopy varchar2
122: ) is
115: PROCEDURE update_note
116: (p_validate in number default hr_api.g_false_num
117: ,p_note_id in number
118: ,p_offer_status_history_id in number default hr_api.g_number
119: ,p_note_text in varchar2 default hr_api.g_varchar2
120: ,p_object_version_number in out nocopy number
121: ,p_return_status out nocopy varchar2
122: ) is
123: --
146: --
147: -- Convert constant values to their corresponding boolean value
148: --
149: l_validate :=
150: hr_api.constant_to_boolean
151: (p_constant_value => p_validate);
152: --
153: -- Register Surrogate ID or user key values
154: --
214: -- ----------------------------------------------------------------------------
215: -- |------------------------------< delete_note >-----------------------------|
216: -- ----------------------------------------------------------------------------
217: PROCEDURE delete_note
218: (p_validate in number default hr_api.g_false_num
219: ,p_note_id in number
220: ,p_object_version_number in number
221: ,p_return_status out nocopy varchar2
222: ) is
244: --
245: -- Convert constant values to their corresponding boolean value
246: --
247: l_validate :=
248: hr_api.constant_to_boolean
249: (p_constant_value => p_validate);
250: --
251: -- Register Surrogate ID or user key values
252: --