8: -- ----------------------------------------------------------------------------
9: -- |-------------------------< create_setup_sub_task >------------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_setup_sub_task
12: (p_validate in number default hr_api.g_false_num
13: ,p_setup_sub_task_code in varchar2
14: ,p_setup_sub_task_name in varchar2
15: ,p_setup_sub_task_description in varchar2
16: ,p_setup_task_code in varchar2
51: --
52: -- Convert constant values to their corresponding boolean value
53: --
54: l_validate :=
55: hr_api.constant_to_boolean
56: (p_constant_value => p_validate);
57: --
58: -- Register Surrogate ID or user key values
59: --
130: -- ----------------------------------------------------------------------------
131: -- |-------------------------< delete_setup_sub_task >------------------------|
132: -- ----------------------------------------------------------------------------
133: PROCEDURE delete_setup_sub_task
134: (p_validate in number default hr_api.g_false_num
135: ,p_setup_sub_task_code in varchar2
136: ,p_object_version_number in number
137: ,p_return_status out nocopy varchar2
138: ) is
160: --
161: -- Convert constant values to their corresponding boolean value
162: --
163: l_validate :=
164: hr_api.constant_to_boolean
165: (p_constant_value => p_validate);
166: --
167: -- Register Surrogate ID or user key values
168: --
224: -- ----------------------------------------------------------------------------
225: -- |-------------------------< update_setup_sub_task >------------------------|
226: -- ----------------------------------------------------------------------------
227: PROCEDURE update_setup_sub_task
228: (p_validate in number default hr_api.g_false_num
229: ,p_setup_sub_task_code in varchar2
230: ,p_setup_sub_task_name in varchar2 default hr_api.g_varchar2
231: ,p_setup_sub_task_description in varchar2 default hr_api.g_varchar2
232: ,p_setup_task_code in varchar2 default hr_api.g_varchar2
226: -- ----------------------------------------------------------------------------
227: PROCEDURE update_setup_sub_task
228: (p_validate in number default hr_api.g_false_num
229: ,p_setup_sub_task_code in varchar2
230: ,p_setup_sub_task_name in varchar2 default hr_api.g_varchar2
231: ,p_setup_sub_task_description in varchar2 default hr_api.g_varchar2
232: ,p_setup_task_code in varchar2 default hr_api.g_varchar2
233: ,p_setup_sub_task_sequence in number default hr_api.g_number
234: ,p_setup_sub_task_status in varchar2 default hr_api.g_varchar2
227: PROCEDURE update_setup_sub_task
228: (p_validate in number default hr_api.g_false_num
229: ,p_setup_sub_task_code in varchar2
230: ,p_setup_sub_task_name in varchar2 default hr_api.g_varchar2
231: ,p_setup_sub_task_description in varchar2 default hr_api.g_varchar2
232: ,p_setup_task_code in varchar2 default hr_api.g_varchar2
233: ,p_setup_sub_task_sequence in number default hr_api.g_number
234: ,p_setup_sub_task_status in varchar2 default hr_api.g_varchar2
235: ,p_setup_sub_task_type in varchar2 default hr_api.g_varchar2
228: (p_validate in number default hr_api.g_false_num
229: ,p_setup_sub_task_code in varchar2
230: ,p_setup_sub_task_name in varchar2 default hr_api.g_varchar2
231: ,p_setup_sub_task_description in varchar2 default hr_api.g_varchar2
232: ,p_setup_task_code in varchar2 default hr_api.g_varchar2
233: ,p_setup_sub_task_sequence in number default hr_api.g_number
234: ,p_setup_sub_task_status in varchar2 default hr_api.g_varchar2
235: ,p_setup_sub_task_type in varchar2 default hr_api.g_varchar2
236: ,p_setup_sub_task_dp_link in varchar2 default hr_api.g_varchar2
229: ,p_setup_sub_task_code in varchar2
230: ,p_setup_sub_task_name in varchar2 default hr_api.g_varchar2
231: ,p_setup_sub_task_description in varchar2 default hr_api.g_varchar2
232: ,p_setup_task_code in varchar2 default hr_api.g_varchar2
233: ,p_setup_sub_task_sequence in number default hr_api.g_number
234: ,p_setup_sub_task_status in varchar2 default hr_api.g_varchar2
235: ,p_setup_sub_task_type in varchar2 default hr_api.g_varchar2
236: ,p_setup_sub_task_dp_link in varchar2 default hr_api.g_varchar2
237: ,p_setup_sub_task_action in varchar2 default hr_api.g_varchar2
230: ,p_setup_sub_task_name in varchar2 default hr_api.g_varchar2
231: ,p_setup_sub_task_description in varchar2 default hr_api.g_varchar2
232: ,p_setup_task_code in varchar2 default hr_api.g_varchar2
233: ,p_setup_sub_task_sequence in number default hr_api.g_number
234: ,p_setup_sub_task_status in varchar2 default hr_api.g_varchar2
235: ,p_setup_sub_task_type in varchar2 default hr_api.g_varchar2
236: ,p_setup_sub_task_dp_link in varchar2 default hr_api.g_varchar2
237: ,p_setup_sub_task_action in varchar2 default hr_api.g_varchar2
238: ,p_setup_sub_task_creation_date in date default hr_api.g_date
231: ,p_setup_sub_task_description in varchar2 default hr_api.g_varchar2
232: ,p_setup_task_code in varchar2 default hr_api.g_varchar2
233: ,p_setup_sub_task_sequence in number default hr_api.g_number
234: ,p_setup_sub_task_status in varchar2 default hr_api.g_varchar2
235: ,p_setup_sub_task_type in varchar2 default hr_api.g_varchar2
236: ,p_setup_sub_task_dp_link in varchar2 default hr_api.g_varchar2
237: ,p_setup_sub_task_action in varchar2 default hr_api.g_varchar2
238: ,p_setup_sub_task_creation_date in date default hr_api.g_date
239: ,p_setup_sub_task_last_mod_date in date default hr_api.g_date
232: ,p_setup_task_code in varchar2 default hr_api.g_varchar2
233: ,p_setup_sub_task_sequence in number default hr_api.g_number
234: ,p_setup_sub_task_status in varchar2 default hr_api.g_varchar2
235: ,p_setup_sub_task_type in varchar2 default hr_api.g_varchar2
236: ,p_setup_sub_task_dp_link in varchar2 default hr_api.g_varchar2
237: ,p_setup_sub_task_action in varchar2 default hr_api.g_varchar2
238: ,p_setup_sub_task_creation_date in date default hr_api.g_date
239: ,p_setup_sub_task_last_mod_date in date default hr_api.g_date
240: ,p_legislation_code in varchar2 default hr_api.g_varchar2
233: ,p_setup_sub_task_sequence in number default hr_api.g_number
234: ,p_setup_sub_task_status in varchar2 default hr_api.g_varchar2
235: ,p_setup_sub_task_type in varchar2 default hr_api.g_varchar2
236: ,p_setup_sub_task_dp_link in varchar2 default hr_api.g_varchar2
237: ,p_setup_sub_task_action in varchar2 default hr_api.g_varchar2
238: ,p_setup_sub_task_creation_date in date default hr_api.g_date
239: ,p_setup_sub_task_last_mod_date in date default hr_api.g_date
240: ,p_legislation_code in varchar2 default hr_api.g_varchar2
241: ,p_language_code in varchar2 default hr_api.g_varchar2
234: ,p_setup_sub_task_status in varchar2 default hr_api.g_varchar2
235: ,p_setup_sub_task_type in varchar2 default hr_api.g_varchar2
236: ,p_setup_sub_task_dp_link in varchar2 default hr_api.g_varchar2
237: ,p_setup_sub_task_action in varchar2 default hr_api.g_varchar2
238: ,p_setup_sub_task_creation_date in date default hr_api.g_date
239: ,p_setup_sub_task_last_mod_date in date default hr_api.g_date
240: ,p_legislation_code in varchar2 default hr_api.g_varchar2
241: ,p_language_code in varchar2 default hr_api.g_varchar2
242: ,p_effective_date in date
235: ,p_setup_sub_task_type in varchar2 default hr_api.g_varchar2
236: ,p_setup_sub_task_dp_link in varchar2 default hr_api.g_varchar2
237: ,p_setup_sub_task_action in varchar2 default hr_api.g_varchar2
238: ,p_setup_sub_task_creation_date in date default hr_api.g_date
239: ,p_setup_sub_task_last_mod_date in date default hr_api.g_date
240: ,p_legislation_code in varchar2 default hr_api.g_varchar2
241: ,p_language_code in varchar2 default hr_api.g_varchar2
242: ,p_effective_date in date
243: ,p_object_version_number in out nocopy number
236: ,p_setup_sub_task_dp_link in varchar2 default hr_api.g_varchar2
237: ,p_setup_sub_task_action in varchar2 default hr_api.g_varchar2
238: ,p_setup_sub_task_creation_date in date default hr_api.g_date
239: ,p_setup_sub_task_last_mod_date in date default hr_api.g_date
240: ,p_legislation_code in varchar2 default hr_api.g_varchar2
241: ,p_language_code in varchar2 default hr_api.g_varchar2
242: ,p_effective_date in date
243: ,p_object_version_number in out nocopy number
244: ,p_return_status out nocopy varchar2
237: ,p_setup_sub_task_action in varchar2 default hr_api.g_varchar2
238: ,p_setup_sub_task_creation_date in date default hr_api.g_date
239: ,p_setup_sub_task_last_mod_date in date default hr_api.g_date
240: ,p_legislation_code in varchar2 default hr_api.g_varchar2
241: ,p_language_code in varchar2 default hr_api.g_varchar2
242: ,p_effective_date in date
243: ,p_object_version_number in out nocopy number
244: ,p_return_status out nocopy varchar2
245: ) is
269: --
270: -- Convert constant values to their corresponding boolean value
271: --
272: l_validate :=
273: hr_api.constant_to_boolean
274: (p_constant_value => p_validate);
275: --
276: -- Register Surrogate ID or user key values
277: --