86: --
87: hr_utility.set_location(' Leaving:'||l_proc, 10);
88: --
89: Exception
90: When hr_api.check_integrity_violated Then
91: -- A check constraint has been violated
92: --
93: per_ssb_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
90: When hr_api.check_integrity_violated Then
91: -- A check constraint has been violated
92: --
93: per_ssb_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.parent_integrity_violated Then
96: -- Parent integrity has been violated
97: --
98: per_ssb_shd.constraint_error
91: -- A check constraint has been violated
92: --
93: per_ssb_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.parent_integrity_violated Then
96: -- Parent integrity has been violated
97: --
98: per_ssb_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.parent_integrity_violated Then
96: -- Parent integrity has been violated
97: --
98: per_ssb_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.unique_integrity_violated Then
101: -- Unique integrity has been violated
102: --
103: per_ssb_shd.constraint_error
96: -- Parent integrity has been violated
97: --
98: per_ssb_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.unique_integrity_violated Then
101: -- Unique integrity has been violated
102: --
103: per_ssb_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.unique_integrity_violated Then
101: -- Unique integrity has been violated
102: --
103: per_ssb_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When Others Then
106: --
107: Raise;
108: End update_dml;
220: );
221: --
222: exception
223: --
224: when hr_api.cannot_find_prog_unit then
225: --
226: hr_api.cannot_find_prog_unit_error
227: (p_module_name => 'PER_RI_SETUP_SUB_TASKS'
228: ,p_hook_type => 'AU');
222: exception
223: --
224: when hr_api.cannot_find_prog_unit then
225: --
226: hr_api.cannot_find_prog_unit_error
227: (p_module_name => 'PER_RI_SETUP_SUB_TASKS'
228: ,p_hook_type => 'AU');
229: --
230: end;
285: -- p_rec plsql record structure
286: -- to see if a system default is being used. If a system default
287: -- is being used then we must set to the 'current' argument value.
288: --
289: If (p_rec.setup_task_code = hr_api.g_varchar2) then
290: p_rec.setup_task_code :=
291: per_ssb_shd.g_old_rec.setup_task_code;
292: End If;
293: If (p_rec.setup_sub_task_sequence = hr_api.g_number) then
289: If (p_rec.setup_task_code = hr_api.g_varchar2) then
290: p_rec.setup_task_code :=
291: per_ssb_shd.g_old_rec.setup_task_code;
292: End If;
293: If (p_rec.setup_sub_task_sequence = hr_api.g_number) then
294: p_rec.setup_sub_task_sequence :=
295: per_ssb_shd.g_old_rec.setup_sub_task_sequence;
296: End If;
297: If (p_rec.setup_sub_task_status = hr_api.g_varchar2) then
293: If (p_rec.setup_sub_task_sequence = hr_api.g_number) then
294: p_rec.setup_sub_task_sequence :=
295: per_ssb_shd.g_old_rec.setup_sub_task_sequence;
296: End If;
297: If (p_rec.setup_sub_task_status = hr_api.g_varchar2) then
298: p_rec.setup_sub_task_status :=
299: per_ssb_shd.g_old_rec.setup_sub_task_status;
300: End If;
301: If (p_rec.setup_sub_task_type = hr_api.g_varchar2) then
297: If (p_rec.setup_sub_task_status = hr_api.g_varchar2) then
298: p_rec.setup_sub_task_status :=
299: per_ssb_shd.g_old_rec.setup_sub_task_status;
300: End If;
301: If (p_rec.setup_sub_task_type = hr_api.g_varchar2) then
302: p_rec.setup_sub_task_type :=
303: per_ssb_shd.g_old_rec.setup_sub_task_type;
304: End If;
305: If (p_rec.setup_sub_task_data_pump_link = hr_api.g_varchar2) then
301: If (p_rec.setup_sub_task_type = hr_api.g_varchar2) then
302: p_rec.setup_sub_task_type :=
303: per_ssb_shd.g_old_rec.setup_sub_task_type;
304: End If;
305: If (p_rec.setup_sub_task_data_pump_link = hr_api.g_varchar2) then
306: p_rec.setup_sub_task_data_pump_link :=
307: per_ssb_shd.g_old_rec.setup_sub_task_data_pump_link;
308: End If;
309: If (p_rec.setup_sub_task_action = hr_api.g_varchar2) then
305: If (p_rec.setup_sub_task_data_pump_link = hr_api.g_varchar2) then
306: p_rec.setup_sub_task_data_pump_link :=
307: per_ssb_shd.g_old_rec.setup_sub_task_data_pump_link;
308: End If;
309: If (p_rec.setup_sub_task_action = hr_api.g_varchar2) then
310: p_rec.setup_sub_task_action :=
311: per_ssb_shd.g_old_rec.setup_sub_task_action;
312: End If;
313: If (p_rec.setup_sub_task_creation_date = hr_api.g_date) then
309: If (p_rec.setup_sub_task_action = hr_api.g_varchar2) then
310: p_rec.setup_sub_task_action :=
311: per_ssb_shd.g_old_rec.setup_sub_task_action;
312: End If;
313: If (p_rec.setup_sub_task_creation_date = hr_api.g_date) then
314: p_rec.setup_sub_task_creation_date :=
315: per_ssb_shd.g_old_rec.setup_sub_task_creation_date;
316: End If;
317: If (p_rec.setup_sub_task_last_mod_date = hr_api.g_date) then
313: If (p_rec.setup_sub_task_creation_date = hr_api.g_date) then
314: p_rec.setup_sub_task_creation_date :=
315: per_ssb_shd.g_old_rec.setup_sub_task_creation_date;
316: End If;
317: If (p_rec.setup_sub_task_last_mod_date = hr_api.g_date) then
318: p_rec.setup_sub_task_last_mod_date :=
319: per_ssb_shd.g_old_rec.setup_sub_task_last_mod_date;
320: End If;
321: If (p_rec.legislation_code = hr_api.g_varchar2) then
317: If (p_rec.setup_sub_task_last_mod_date = hr_api.g_date) then
318: p_rec.setup_sub_task_last_mod_date :=
319: per_ssb_shd.g_old_rec.setup_sub_task_last_mod_date;
320: End If;
321: If (p_rec.legislation_code = hr_api.g_varchar2) then
322: p_rec.legislation_code := per_ssb_shd.g_old_rec.legislation_code;
323: End If;
324:
325: --
385: Procedure upd
386: (p_effective_date in date
387: ,p_setup_sub_task_code in varchar2
388: ,p_object_version_number in out nocopy number
389: ,p_setup_task_code in varchar2 default hr_api.g_varchar2
390: ,p_setup_sub_task_sequence in number default hr_api.g_number
391: ,p_setup_sub_task_data_pump_lin in varchar2 default hr_api.g_varchar2
392: ,p_setup_sub_task_status in varchar2 default hr_api.g_varchar2
393: ,p_setup_sub_task_type in varchar2 default hr_api.g_varchar2
386: (p_effective_date in date
387: ,p_setup_sub_task_code in varchar2
388: ,p_object_version_number in out nocopy number
389: ,p_setup_task_code in varchar2 default hr_api.g_varchar2
390: ,p_setup_sub_task_sequence in number default hr_api.g_number
391: ,p_setup_sub_task_data_pump_lin in varchar2 default hr_api.g_varchar2
392: ,p_setup_sub_task_status in varchar2 default hr_api.g_varchar2
393: ,p_setup_sub_task_type in varchar2 default hr_api.g_varchar2
394: ,p_setup_sub_task_action in varchar2 default hr_api.g_varchar2
387: ,p_setup_sub_task_code in varchar2
388: ,p_object_version_number in out nocopy number
389: ,p_setup_task_code in varchar2 default hr_api.g_varchar2
390: ,p_setup_sub_task_sequence in number default hr_api.g_number
391: ,p_setup_sub_task_data_pump_lin in varchar2 default hr_api.g_varchar2
392: ,p_setup_sub_task_status in varchar2 default hr_api.g_varchar2
393: ,p_setup_sub_task_type in varchar2 default hr_api.g_varchar2
394: ,p_setup_sub_task_action in varchar2 default hr_api.g_varchar2
395: ,p_setup_sub_task_creation_date in date default hr_api.g_date
388: ,p_object_version_number in out nocopy number
389: ,p_setup_task_code in varchar2 default hr_api.g_varchar2
390: ,p_setup_sub_task_sequence in number default hr_api.g_number
391: ,p_setup_sub_task_data_pump_lin in varchar2 default hr_api.g_varchar2
392: ,p_setup_sub_task_status in varchar2 default hr_api.g_varchar2
393: ,p_setup_sub_task_type in varchar2 default hr_api.g_varchar2
394: ,p_setup_sub_task_action in varchar2 default hr_api.g_varchar2
395: ,p_setup_sub_task_creation_date in date default hr_api.g_date
396: ,p_setup_sub_task_last_mod_date in date default hr_api.g_date
389: ,p_setup_task_code in varchar2 default hr_api.g_varchar2
390: ,p_setup_sub_task_sequence in number default hr_api.g_number
391: ,p_setup_sub_task_data_pump_lin in varchar2 default hr_api.g_varchar2
392: ,p_setup_sub_task_status in varchar2 default hr_api.g_varchar2
393: ,p_setup_sub_task_type in varchar2 default hr_api.g_varchar2
394: ,p_setup_sub_task_action in varchar2 default hr_api.g_varchar2
395: ,p_setup_sub_task_creation_date in date default hr_api.g_date
396: ,p_setup_sub_task_last_mod_date in date default hr_api.g_date
397: ,p_legislation_code in varchar2 default hr_api.g_varchar2
390: ,p_setup_sub_task_sequence in number default hr_api.g_number
391: ,p_setup_sub_task_data_pump_lin in varchar2 default hr_api.g_varchar2
392: ,p_setup_sub_task_status in varchar2 default hr_api.g_varchar2
393: ,p_setup_sub_task_type in varchar2 default hr_api.g_varchar2
394: ,p_setup_sub_task_action in varchar2 default hr_api.g_varchar2
395: ,p_setup_sub_task_creation_date in date default hr_api.g_date
396: ,p_setup_sub_task_last_mod_date in date default hr_api.g_date
397: ,p_legislation_code in varchar2 default hr_api.g_varchar2
398: ) is
391: ,p_setup_sub_task_data_pump_lin in varchar2 default hr_api.g_varchar2
392: ,p_setup_sub_task_status in varchar2 default hr_api.g_varchar2
393: ,p_setup_sub_task_type in varchar2 default hr_api.g_varchar2
394: ,p_setup_sub_task_action in varchar2 default hr_api.g_varchar2
395: ,p_setup_sub_task_creation_date in date default hr_api.g_date
396: ,p_setup_sub_task_last_mod_date in date default hr_api.g_date
397: ,p_legislation_code in varchar2 default hr_api.g_varchar2
398: ) is
399: --
392: ,p_setup_sub_task_status in varchar2 default hr_api.g_varchar2
393: ,p_setup_sub_task_type in varchar2 default hr_api.g_varchar2
394: ,p_setup_sub_task_action in varchar2 default hr_api.g_varchar2
395: ,p_setup_sub_task_creation_date in date default hr_api.g_date
396: ,p_setup_sub_task_last_mod_date in date default hr_api.g_date
397: ,p_legislation_code in varchar2 default hr_api.g_varchar2
398: ) is
399: --
400: l_rec per_ssb_shd.g_rec_type;
393: ,p_setup_sub_task_type in varchar2 default hr_api.g_varchar2
394: ,p_setup_sub_task_action in varchar2 default hr_api.g_varchar2
395: ,p_setup_sub_task_creation_date in date default hr_api.g_date
396: ,p_setup_sub_task_last_mod_date in date default hr_api.g_date
397: ,p_legislation_code in varchar2 default hr_api.g_varchar2
398: ) is
399: --
400: l_rec per_ssb_shd.g_rec_type;
401: l_proc varchar2(72) := g_package||'upd';