8: -- ----------------------------------------------------------------------------
9: -- |----------------------< create_user_column_instance >---------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_user_column_instance
12: (p_validate in number default hr_api.g_false_num
13: ,p_effective_date in date
14: ,p_user_row_id in number
15: ,p_user_column_id in number
16: ,p_value in varchar2 default null
45: --
46: -- Convert constant values to their corresponding boolean value
47: --
48: l_validate :=
49: hr_api.constant_to_boolean
50: (p_constant_value => p_validate);
51: --
52: -- Register Surrogate ID or user key values
53: --
125: -- ----------------------------------------------------------------------------
126: -- |----------------------< update_user_column_instance >---------------------|
127: -- ----------------------------------------------------------------------------
128: PROCEDURE update_user_column_instance
129: (p_validate in number default hr_api.g_false_num
130: ,p_effective_date in date
131: ,p_user_column_instance_id in number
132: ,p_datetrack_update_mode in varchar2
133: ,p_value 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_user_column_instance_id in number
132: ,p_datetrack_update_mode in varchar2
133: ,p_value in varchar2 default hr_api.g_varchar2
134: ,p_object_version_number in out nocopy number
135: ,p_effective_start_date out nocopy date
136: ,p_effective_end_date out nocopy date
137: ,p_return_status out nocopy varchar2
162: --
163: -- Convert constant values to their corresponding boolean value
164: --
165: l_validate :=
166: hr_api.constant_to_boolean
167: (p_constant_value => p_validate);
168: --
169: -- Register Surrogate ID or user key values
170: --
237: -- ----------------------------------------------------------------------------
238: -- |----------------------< delete_user_column_instance >---------------------|
239: -- ----------------------------------------------------------------------------
240: PROCEDURE delete_user_column_instance
241: (p_validate in number default hr_api.g_false_num
242: ,p_effective_date in date
243: ,p_user_column_instance_id in number
244: ,p_datetrack_update_mode in varchar2
245: ,p_object_version_number in out nocopy number
273: --
274: -- Convert constant values to their corresponding boolean value
275: --
276: l_validate :=
277: hr_api.constant_to_boolean
278: (p_constant_value => p_validate);
279: --
280: -- Register Surrogate ID or user key values
281: --