8: -- ----------------------------------------------------------------------------
9: -- |---------------------------< create_setup_task >--------------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_setup_task
12: (p_validate in number default hr_api.g_false_num
13: ,p_setup_task_code in varchar2
14: ,p_workbench_item_code in varchar2
15: ,p_setup_task_name in varchar2
16: ,p_setup_task_description in varchar2
49: --
50: -- Convert constant values to their corresponding boolean value
51: --
52: l_validate :=
53: hr_api.constant_to_boolean
54: (p_constant_value => p_validate);
55: --
56: -- Register Surrogate ID or user key values
57: --
126: -- ----------------------------------------------------------------------------
127: -- |---------------------------< delete_setup_task >--------------------------|
128: -- ----------------------------------------------------------------------------
129: PROCEDURE delete_setup_task
130: (p_validate in number default hr_api.g_false_num
131: ,p_setup_task_code in varchar2
132: ,p_object_version_number in number
133: ,p_return_status out nocopy varchar2
134: ) is
156: --
157: -- Convert constant values to their corresponding boolean value
158: --
159: l_validate :=
160: hr_api.constant_to_boolean
161: (p_constant_value => p_validate);
162: --
163: -- Register Surrogate ID or user key values
164: --
220: -- ----------------------------------------------------------------------------
221: -- |---------------------------< update_setup_task >--------------------------|
222: -- ----------------------------------------------------------------------------
223: PROCEDURE update_setup_task
224: (p_validate in number default hr_api.g_false_num
225: ,p_setup_task_code in varchar2
226: ,p_workbench_item_code in varchar2 default hr_api.g_varchar2
227: ,p_setup_task_name in varchar2 default hr_api.g_varchar2
228: ,p_setup_task_description in varchar2 default hr_api.g_varchar2
222: -- ----------------------------------------------------------------------------
223: PROCEDURE update_setup_task
224: (p_validate in number default hr_api.g_false_num
225: ,p_setup_task_code in varchar2
226: ,p_workbench_item_code in varchar2 default hr_api.g_varchar2
227: ,p_setup_task_name in varchar2 default hr_api.g_varchar2
228: ,p_setup_task_description in varchar2 default hr_api.g_varchar2
229: ,p_setup_task_sequence in number default hr_api.g_number
230: ,p_setup_task_status in varchar2 default hr_api.g_varchar2
223: PROCEDURE update_setup_task
224: (p_validate in number default hr_api.g_false_num
225: ,p_setup_task_code in varchar2
226: ,p_workbench_item_code in varchar2 default hr_api.g_varchar2
227: ,p_setup_task_name in varchar2 default hr_api.g_varchar2
228: ,p_setup_task_description in varchar2 default hr_api.g_varchar2
229: ,p_setup_task_sequence in number default hr_api.g_number
230: ,p_setup_task_status in varchar2 default hr_api.g_varchar2
231: ,p_setup_task_creation_date in date default hr_api.g_date
224: (p_validate in number default hr_api.g_false_num
225: ,p_setup_task_code in varchar2
226: ,p_workbench_item_code in varchar2 default hr_api.g_varchar2
227: ,p_setup_task_name in varchar2 default hr_api.g_varchar2
228: ,p_setup_task_description in varchar2 default hr_api.g_varchar2
229: ,p_setup_task_sequence in number default hr_api.g_number
230: ,p_setup_task_status in varchar2 default hr_api.g_varchar2
231: ,p_setup_task_creation_date in date default hr_api.g_date
232: ,p_setup_task_last_mod_date in date default hr_api.g_date
225: ,p_setup_task_code in varchar2
226: ,p_workbench_item_code in varchar2 default hr_api.g_varchar2
227: ,p_setup_task_name in varchar2 default hr_api.g_varchar2
228: ,p_setup_task_description in varchar2 default hr_api.g_varchar2
229: ,p_setup_task_sequence in number default hr_api.g_number
230: ,p_setup_task_status in varchar2 default hr_api.g_varchar2
231: ,p_setup_task_creation_date in date default hr_api.g_date
232: ,p_setup_task_last_mod_date in date default hr_api.g_date
233: ,p_setup_task_type in varchar2 default hr_api.g_varchar2
226: ,p_workbench_item_code in varchar2 default hr_api.g_varchar2
227: ,p_setup_task_name in varchar2 default hr_api.g_varchar2
228: ,p_setup_task_description in varchar2 default hr_api.g_varchar2
229: ,p_setup_task_sequence in number default hr_api.g_number
230: ,p_setup_task_status in varchar2 default hr_api.g_varchar2
231: ,p_setup_task_creation_date in date default hr_api.g_date
232: ,p_setup_task_last_mod_date in date default hr_api.g_date
233: ,p_setup_task_type in varchar2 default hr_api.g_varchar2
234: ,p_setup_task_action in varchar2 default hr_api.g_varchar2
227: ,p_setup_task_name in varchar2 default hr_api.g_varchar2
228: ,p_setup_task_description in varchar2 default hr_api.g_varchar2
229: ,p_setup_task_sequence in number default hr_api.g_number
230: ,p_setup_task_status in varchar2 default hr_api.g_varchar2
231: ,p_setup_task_creation_date in date default hr_api.g_date
232: ,p_setup_task_last_mod_date in date default hr_api.g_date
233: ,p_setup_task_type in varchar2 default hr_api.g_varchar2
234: ,p_setup_task_action in varchar2 default hr_api.g_varchar2
235: ,p_language_code in varchar2 default hr_api.g_varchar2
228: ,p_setup_task_description in varchar2 default hr_api.g_varchar2
229: ,p_setup_task_sequence in number default hr_api.g_number
230: ,p_setup_task_status in varchar2 default hr_api.g_varchar2
231: ,p_setup_task_creation_date in date default hr_api.g_date
232: ,p_setup_task_last_mod_date in date default hr_api.g_date
233: ,p_setup_task_type in varchar2 default hr_api.g_varchar2
234: ,p_setup_task_action in varchar2 default hr_api.g_varchar2
235: ,p_language_code in varchar2 default hr_api.g_varchar2
236: ,p_effective_date in date
229: ,p_setup_task_sequence in number default hr_api.g_number
230: ,p_setup_task_status in varchar2 default hr_api.g_varchar2
231: ,p_setup_task_creation_date in date default hr_api.g_date
232: ,p_setup_task_last_mod_date in date default hr_api.g_date
233: ,p_setup_task_type in varchar2 default hr_api.g_varchar2
234: ,p_setup_task_action in varchar2 default hr_api.g_varchar2
235: ,p_language_code in varchar2 default hr_api.g_varchar2
236: ,p_effective_date in date
237: ,p_object_version_number in out nocopy number
230: ,p_setup_task_status in varchar2 default hr_api.g_varchar2
231: ,p_setup_task_creation_date in date default hr_api.g_date
232: ,p_setup_task_last_mod_date in date default hr_api.g_date
233: ,p_setup_task_type in varchar2 default hr_api.g_varchar2
234: ,p_setup_task_action in varchar2 default hr_api.g_varchar2
235: ,p_language_code in varchar2 default hr_api.g_varchar2
236: ,p_effective_date in date
237: ,p_object_version_number in out nocopy number
238: ,p_return_status out nocopy varchar2
231: ,p_setup_task_creation_date in date default hr_api.g_date
232: ,p_setup_task_last_mod_date in date default hr_api.g_date
233: ,p_setup_task_type in varchar2 default hr_api.g_varchar2
234: ,p_setup_task_action in varchar2 default hr_api.g_varchar2
235: ,p_language_code in varchar2 default hr_api.g_varchar2
236: ,p_effective_date in date
237: ,p_object_version_number in out nocopy number
238: ,p_return_status out nocopy varchar2
239: ) is
263: --
264: -- Convert constant values to their corresponding boolean value
265: --
266: l_validate :=
267: hr_api.constant_to_boolean
268: (p_constant_value => p_validate);
269: --
270: -- Register Surrogate ID or user key values
271: --