8: -- ----------------------------------------------------------------------------
9: -- |-----------------------------< create_option >----------------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_option
12: (p_validate in number default hr_api.g_false_num
13: ,p_effective_date in date
14: ,p_option_type_id in number
15: ,p_option_level in number
16: ,p_option_level_id in varchar2 default null
46: --
47: -- Convert constant values to their corresponding boolean value
48: --
49: l_validate :=
50: hr_api.constant_to_boolean
51: (p_constant_value => p_validate);
52: --
53: -- Register Surrogate ID or user key values
54: --
122: -- ----------------------------------------------------------------------------
123: -- |-----------------------------< delete_option >----------------------------|
124: -- ----------------------------------------------------------------------------
125: PROCEDURE delete_option
126: (p_validate in number default hr_api.g_false_num
127: ,p_option_id in number
128: ,p_object_version_number in number
129: ,p_return_status out nocopy varchar2
130: ) is
152: --
153: -- Convert constant values to their corresponding boolean value
154: --
155: l_validate :=
156: hr_api.constant_to_boolean
157: (p_constant_value => p_validate);
158: --
159: -- Register Surrogate ID or user key values
160: --
216: -- ----------------------------------------------------------------------------
217: -- |-----------------------------< update_option >----------------------------|
218: -- ----------------------------------------------------------------------------
219: PROCEDURE update_option
220: (p_validate in number default hr_api.g_false_num
221: ,p_option_id in number
222: ,p_value in varchar2 default hr_api.g_varchar2
223: ,p_encrypted in varchar2 default hr_api.g_varchar2
224: ,p_object_version_number in out nocopy number
218: -- ----------------------------------------------------------------------------
219: PROCEDURE update_option
220: (p_validate in number default hr_api.g_false_num
221: ,p_option_id in number
222: ,p_value in varchar2 default hr_api.g_varchar2
223: ,p_encrypted in varchar2 default hr_api.g_varchar2
224: ,p_object_version_number in out nocopy number
225: ,p_return_status out nocopy varchar2
226: ) is
219: PROCEDURE update_option
220: (p_validate in number default hr_api.g_false_num
221: ,p_option_id in number
222: ,p_value in varchar2 default hr_api.g_varchar2
223: ,p_encrypted in varchar2 default hr_api.g_varchar2
224: ,p_object_version_number in out nocopy number
225: ,p_return_status out nocopy varchar2
226: ) is
227: --
250: --
251: -- Convert constant values to their corresponding boolean value
252: --
253: l_validate :=
254: hr_api.constant_to_boolean
255: (p_constant_value => p_validate);
256: --
257: -- Register Surrogate ID or user key values
258: --