8: -- ----------------------------------------------------------------------------
9: -- |----------------------------< create_user_row >---------------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_user_row
12: (p_validate in number default hr_api.g_false_num
13: ,p_effective_date in date
14: ,p_user_table_id in number
15: ,p_row_low_range_or_name in varchar2
16: ,p_display_sequence in out nocopy number
53: --
54: -- Convert constant values to their corresponding boolean value
55: --
56: l_validate :=
57: hr_api.constant_to_boolean
58: (p_constant_value => p_validate);
59: l_disable_range_overlap_check :=
60: hr_api.constant_to_boolean
61: (p_constant_value => p_disable_range_overlap_check);
56: l_validate :=
57: hr_api.constant_to_boolean
58: (p_constant_value => p_validate);
59: l_disable_range_overlap_check :=
60: hr_api.constant_to_boolean
61: (p_constant_value => p_disable_range_overlap_check);
62: l_disable_units_check :=
63: hr_api.constant_to_boolean
64: (p_constant_value => p_disable_units_check);
59: l_disable_range_overlap_check :=
60: hr_api.constant_to_boolean
61: (p_constant_value => p_disable_range_overlap_check);
62: l_disable_units_check :=
63: hr_api.constant_to_boolean
64: (p_constant_value => p_disable_units_check);
65: --
66: -- Register Surrogate ID or user key values
67: --
144: -- ----------------------------------------------------------------------------
145: -- |----------------------------< update_user_row >---------------------------|
146: -- ----------------------------------------------------------------------------
147: PROCEDURE update_user_row
148: (p_validate in number default hr_api.g_false_num
149: ,p_effective_date in date
150: ,p_datetrack_update_mode in varchar2
151: ,p_user_row_id in number
152: ,p_display_sequence in out nocopy number
150: ,p_datetrack_update_mode in varchar2
151: ,p_user_row_id in number
152: ,p_display_sequence in out nocopy number
153: ,p_object_version_number in out nocopy number
154: ,p_row_low_range_or_name in varchar2 default hr_api.g_varchar2
155: ,p_disable_range_overlap_check in number default null
156: ,p_disable_units_check in number default null
157: ,p_row_high_range in varchar2 default hr_api.g_varchar2
158: ,p_effective_start_date out nocopy date
153: ,p_object_version_number in out nocopy number
154: ,p_row_low_range_or_name in varchar2 default hr_api.g_varchar2
155: ,p_disable_range_overlap_check in number default null
156: ,p_disable_units_check in number default null
157: ,p_row_high_range in varchar2 default hr_api.g_varchar2
158: ,p_effective_start_date out nocopy date
159: ,p_effective_end_date out nocopy date
160: ,p_return_status out nocopy varchar2
161: ) is
189: --
190: -- Convert constant values to their corresponding boolean value
191: --
192: l_validate :=
193: hr_api.constant_to_boolean
194: (p_constant_value => p_validate);
195: l_disable_range_overlap_check :=
196: hr_api.constant_to_boolean
197: (p_constant_value => p_disable_range_overlap_check);
192: l_validate :=
193: hr_api.constant_to_boolean
194: (p_constant_value => p_validate);
195: l_disable_range_overlap_check :=
196: hr_api.constant_to_boolean
197: (p_constant_value => p_disable_range_overlap_check);
198: l_disable_units_check :=
199: hr_api.constant_to_boolean
200: (p_constant_value => p_disable_units_check);
195: l_disable_range_overlap_check :=
196: hr_api.constant_to_boolean
197: (p_constant_value => p_disable_range_overlap_check);
198: l_disable_units_check :=
199: hr_api.constant_to_boolean
200: (p_constant_value => p_disable_units_check);
201: --
202: -- Register Surrogate ID or user key values
203: --
276: -- ----------------------------------------------------------------------------
277: -- |----------------------------< delete_user_row >---------------------------|
278: -- ----------------------------------------------------------------------------
279: PROCEDURE delete_user_row
280: (p_validate in number default hr_api.g_false_num
281: ,p_effective_date in date
282: ,p_datetrack_update_mode in varchar2
283: ,p_user_row_id in number
284: ,p_object_version_number in out nocopy number
314: --
315: -- Convert constant values to their corresponding boolean value
316: --
317: l_validate :=
318: hr_api.constant_to_boolean
319: (p_constant_value => p_validate);
320: l_disable_range_overlap_check :=
321: hr_api.constant_to_boolean
322: (p_constant_value => p_disable_range_overlap_check);
317: l_validate :=
318: hr_api.constant_to_boolean
319: (p_constant_value => p_validate);
320: l_disable_range_overlap_check :=
321: hr_api.constant_to_boolean
322: (p_constant_value => p_disable_range_overlap_check);
323: --
324: -- Register Surrogate ID or user key values
325: --