8: -- ----------------------------------------------------------------------------
9: -- |-----------------------< create_element_type_usage >----------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_element_type_usage
12: (p_validate in number default hr_api.g_false_num
13: ,p_effective_date in date
14: ,p_run_type_id in number
15: ,p_element_type_id in number
16: ,p_inclusion_flag in varchar2 default null
47: --
48: -- Convert constant values to their corresponding boolean value
49: --
50: l_validate :=
51: hr_api.constant_to_boolean
52: (p_constant_value => p_validate);
53: --
54: -- Register Surrogate ID or user key values
55: --
128: -- ----------------------------------------------------------------------------
129: -- |-----------------------< update_element_type_usage >----------------------|
130: -- ----------------------------------------------------------------------------
131: PROCEDURE update_element_type_usage
132: (p_validate in number default hr_api.g_false_num
133: ,p_effective_date in date
134: ,p_datetrack_update_mode in varchar2
135: ,p_inclusion_flag in varchar2 default hr_api.g_varchar2
136: ,p_element_type_usage_id in number
131: PROCEDURE update_element_type_usage
132: (p_validate in number default hr_api.g_false_num
133: ,p_effective_date in date
134: ,p_datetrack_update_mode in varchar2
135: ,p_inclusion_flag in varchar2 default hr_api.g_varchar2
136: ,p_element_type_usage_id in number
137: ,p_object_version_number in out nocopy number
138: ,p_business_group_id in number default hr_api.g_number
139: ,p_legislation_code in varchar2 default hr_api.g_varchar2
134: ,p_datetrack_update_mode in varchar2
135: ,p_inclusion_flag in varchar2 default hr_api.g_varchar2
136: ,p_element_type_usage_id in number
137: ,p_object_version_number in out nocopy number
138: ,p_business_group_id in number default hr_api.g_number
139: ,p_legislation_code in varchar2 default hr_api.g_varchar2
140: ,p_usage_type in varchar2 default hr_api.g_varchar2
141: ,p_effective_start_date out nocopy date
142: ,p_effective_end_date out nocopy date
135: ,p_inclusion_flag in varchar2 default hr_api.g_varchar2
136: ,p_element_type_usage_id in number
137: ,p_object_version_number in out nocopy number
138: ,p_business_group_id in number default hr_api.g_number
139: ,p_legislation_code in varchar2 default hr_api.g_varchar2
140: ,p_usage_type in varchar2 default hr_api.g_varchar2
141: ,p_effective_start_date out nocopy date
142: ,p_effective_end_date out nocopy date
143: ,p_return_status out nocopy varchar2
136: ,p_element_type_usage_id in number
137: ,p_object_version_number in out nocopy number
138: ,p_business_group_id in number default hr_api.g_number
139: ,p_legislation_code in varchar2 default hr_api.g_varchar2
140: ,p_usage_type in varchar2 default hr_api.g_varchar2
141: ,p_effective_start_date out nocopy date
142: ,p_effective_end_date out nocopy date
143: ,p_return_status out nocopy varchar2
144: ) is
168: --
169: -- Convert constant values to their corresponding boolean value
170: --
171: l_validate :=
172: hr_api.constant_to_boolean
173: (p_constant_value => p_validate);
174: --
175: -- Register Surrogate ID or user key values
176: --
246: -- ----------------------------------------------------------------------------
247: -- |-----------------------< delete_element_type_usage >----------------------|
248: -- ----------------------------------------------------------------------------
249: PROCEDURE delete_element_type_usage
250: (p_validate in number default hr_api.g_false_num
251: ,p_effective_date in date
252: ,p_datetrack_delete_mode in varchar2
253: ,p_element_type_usage_id in number
254: ,p_object_version_number in out nocopy number
251: ,p_effective_date in date
252: ,p_datetrack_delete_mode in varchar2
253: ,p_element_type_usage_id in number
254: ,p_object_version_number in out nocopy number
255: ,p_business_group_id in number default hr_api.g_number
256: ,p_legislation_code in varchar2 default hr_api.g_varchar2
257: ,p_effective_start_date out nocopy date
258: ,p_effective_end_date out nocopy date
259: ,p_return_status out nocopy varchar2
252: ,p_datetrack_delete_mode in varchar2
253: ,p_element_type_usage_id in number
254: ,p_object_version_number in out nocopy number
255: ,p_business_group_id in number default hr_api.g_number
256: ,p_legislation_code in varchar2 default hr_api.g_varchar2
257: ,p_effective_start_date out nocopy date
258: ,p_effective_end_date out nocopy date
259: ,p_return_status out nocopy varchar2
260: ) is
284: --
285: -- Convert constant values to their corresponding boolean value
286: --
287: l_validate :=
288: hr_api.constant_to_boolean
289: (p_constant_value => p_validate);
290: --
291: -- Register Surrogate ID or user key values
292: --