8: -- ----------------------------------------------------------------------------
9: -- |--------------------------< delete_level_codes >--------------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE delete_level_codes
12: (p_validate in number default hr_api.g_false_num
13: ,p_level_code_id in number
14: ,p_object_version_number in number
15: ,p_return_status out nocopy varchar2
16: ) is
38: --
39: -- Convert constant values to their corresponding boolean value
40: --
41: l_validate :=
42: hr_api.constant_to_boolean
43: (p_constant_value => p_validate);
44: --
45: -- Register Surrogate ID or user key values
46: --
102: -- ----------------------------------------------------------------------------
103: -- |--------------------------< insert_level_codes >--------------------------|
104: -- ----------------------------------------------------------------------------
105: PROCEDURE insert_level_codes
106: (p_validate in number default hr_api.g_false_num
107: ,p_effective_date in date
108: ,p_level_number_id in number
109: ,p_level_code in varchar2
110: ,p_description in varchar2
137: --
138: -- Convert constant values to their corresponding boolean value
139: --
140: l_validate :=
141: hr_api.constant_to_boolean
142: (p_constant_value => p_validate);
143: --
144: -- Register Surrogate ID or user key values
145: --
214: -- ----------------------------------------------------------------------------
215: -- |--------------------------< update_level_codes >--------------------------|
216: -- ----------------------------------------------------------------------------
217: PROCEDURE update_level_codes
218: (p_validate in number default hr_api.g_false_num
219: ,p_effective_date in date
220: ,p_level_code_id in number
221: ,p_object_version_number in out nocopy number
222: ,p_level_number_id in number default hr_api.g_number
218: (p_validate in number default hr_api.g_false_num
219: ,p_effective_date in date
220: ,p_level_code_id in number
221: ,p_object_version_number in out nocopy number
222: ,p_level_number_id in number default hr_api.g_number
223: ,p_level_code in varchar2 default hr_api.g_varchar2
224: ,p_description in varchar2 default hr_api.g_varchar2
225: ,p_gradual_value_number in number default hr_api.g_number
226: ,p_return_status out nocopy varchar2
219: ,p_effective_date in date
220: ,p_level_code_id in number
221: ,p_object_version_number in out nocopy number
222: ,p_level_number_id in number default hr_api.g_number
223: ,p_level_code in varchar2 default hr_api.g_varchar2
224: ,p_description in varchar2 default hr_api.g_varchar2
225: ,p_gradual_value_number in number default hr_api.g_number
226: ,p_return_status out nocopy varchar2
227: ) is
220: ,p_level_code_id in number
221: ,p_object_version_number in out nocopy number
222: ,p_level_number_id in number default hr_api.g_number
223: ,p_level_code in varchar2 default hr_api.g_varchar2
224: ,p_description in varchar2 default hr_api.g_varchar2
225: ,p_gradual_value_number in number default hr_api.g_number
226: ,p_return_status out nocopy varchar2
227: ) is
228: --
221: ,p_object_version_number in out nocopy number
222: ,p_level_number_id in number default hr_api.g_number
223: ,p_level_code in varchar2 default hr_api.g_varchar2
224: ,p_description in varchar2 default hr_api.g_varchar2
225: ,p_gradual_value_number in number default hr_api.g_number
226: ,p_return_status out nocopy varchar2
227: ) is
228: --
229: -- Variables for API Boolean parameters
251: --
252: -- Convert constant values to their corresponding boolean value
253: --
254: l_validate :=
255: hr_api.constant_to_boolean
256: (p_constant_value => p_validate);
257: --
258: -- Register Surrogate ID or user key values
259: --