82: --
83: hr_utility.set_location(' Leaving:'||l_proc, 10);
84: --
85: Exception
86: When hr_api.check_integrity_violated Then
87: -- A check constraint has been violated
88: --
89: hr_dty_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
86: When hr_api.check_integrity_violated Then
87: -- A check constraint has been violated
88: --
89: hr_dty_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.parent_integrity_violated Then
92: -- Parent integrity has been violated
93: --
94: hr_dty_shd.constraint_error
87: -- A check constraint has been violated
88: --
89: hr_dty_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.parent_integrity_violated Then
92: -- Parent integrity has been violated
93: --
94: hr_dty_shd.constraint_error
95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.parent_integrity_violated Then
92: -- Parent integrity has been violated
93: --
94: hr_dty_shd.constraint_error
95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
96: When hr_api.unique_integrity_violated Then
97: -- Unique integrity has been violated
98: --
99: hr_dty_shd.constraint_error
92: -- Parent integrity has been violated
93: --
94: hr_dty_shd.constraint_error
95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
96: When hr_api.unique_integrity_violated Then
97: -- Unique integrity has been violated
98: --
99: hr_dty_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
96: When hr_api.unique_integrity_violated Then
97: -- Unique integrity has been violated
98: --
99: hr_dty_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When Others Then
102: --
103: Raise;
104: End update_dml;
245: );
246: --
247: exception
248: --
249: when hr_api.cannot_find_prog_unit then
250: --
251: hr_api.cannot_find_prog_unit_error
252: (p_module_name => 'HR_DOCUMENT_TYPES'
253: ,p_hook_type => 'AU');
247: exception
248: --
249: when hr_api.cannot_find_prog_unit then
250: --
251: hr_api.cannot_find_prog_unit_error
252: (p_module_name => 'HR_DOCUMENT_TYPES'
253: ,p_hook_type => 'AU');
254: --
255: end;
310: -- p_rec plsql record structure
311: -- to see if a system default is being used. If a system default
312: -- is being used then we must set to the 'current' argument value.
313: --
314: If (p_rec.category_code = hr_api.g_varchar2) then
315: p_rec.category_code :=
316: hr_dty_shd.g_old_rec.category_code;
317: End If;
318: If (p_rec.sub_category_code = hr_api.g_varchar2) then
314: If (p_rec.category_code = hr_api.g_varchar2) then
315: p_rec.category_code :=
316: hr_dty_shd.g_old_rec.category_code;
317: End If;
318: If (p_rec.sub_category_code = hr_api.g_varchar2) then
319: p_rec.sub_category_code :=
320: hr_dty_shd.g_old_rec.sub_category_code;
321: End If;
322: If (p_rec.active_inactive_flag = hr_api.g_varchar2) then
318: If (p_rec.sub_category_code = hr_api.g_varchar2) then
319: p_rec.sub_category_code :=
320: hr_dty_shd.g_old_rec.sub_category_code;
321: End If;
322: If (p_rec.active_inactive_flag = hr_api.g_varchar2) then
323: p_rec.active_inactive_flag :=
324: hr_dty_shd.g_old_rec.active_inactive_flag;
325: End If;
326: If (p_rec.multiple_occurences_flag = hr_api.g_varchar2) then
322: If (p_rec.active_inactive_flag = hr_api.g_varchar2) then
323: p_rec.active_inactive_flag :=
324: hr_dty_shd.g_old_rec.active_inactive_flag;
325: End If;
326: If (p_rec.multiple_occurences_flag = hr_api.g_varchar2) then
327: p_rec.multiple_occurences_flag :=
328: hr_dty_shd.g_old_rec.multiple_occurences_flag;
329: End If;
330: If (p_rec.legislation_code = hr_api.g_varchar2) then
326: If (p_rec.multiple_occurences_flag = hr_api.g_varchar2) then
327: p_rec.multiple_occurences_flag :=
328: hr_dty_shd.g_old_rec.multiple_occurences_flag;
329: End If;
330: If (p_rec.legislation_code = hr_api.g_varchar2) then
331: p_rec.legislation_code :=
332: hr_dty_shd.g_old_rec.legislation_code;
333: End If;
334: If (p_rec.authorization_required = hr_api.g_varchar2) then
330: If (p_rec.legislation_code = hr_api.g_varchar2) then
331: p_rec.legislation_code :=
332: hr_dty_shd.g_old_rec.legislation_code;
333: End If;
334: If (p_rec.authorization_required = hr_api.g_varchar2) then
335: p_rec.authorization_required :=
336: hr_dty_shd.g_old_rec.authorization_required;
337: End If;
338: If (p_rec.warning_period = hr_api.g_number) then
334: If (p_rec.authorization_required = hr_api.g_varchar2) then
335: p_rec.authorization_required :=
336: hr_dty_shd.g_old_rec.authorization_required;
337: End If;
338: If (p_rec.warning_period = hr_api.g_number) then
339: p_rec.warning_period :=
340: hr_dty_shd.g_old_rec.warning_period;
341: End If;
342: If (p_rec.request_id = hr_api.g_number) then
338: If (p_rec.warning_period = hr_api.g_number) then
339: p_rec.warning_period :=
340: hr_dty_shd.g_old_rec.warning_period;
341: End If;
342: If (p_rec.request_id = hr_api.g_number) then
343: p_rec.request_id :=
344: hr_dty_shd.g_old_rec.request_id;
345: End If;
346: If (p_rec.program_application_id = hr_api.g_number) then
342: If (p_rec.request_id = hr_api.g_number) then
343: p_rec.request_id :=
344: hr_dty_shd.g_old_rec.request_id;
345: End If;
346: If (p_rec.program_application_id = hr_api.g_number) then
347: p_rec.program_application_id :=
348: hr_dty_shd.g_old_rec.program_application_id;
349: End If;
350: If (p_rec.program_id = hr_api.g_number) then
346: If (p_rec.program_application_id = hr_api.g_number) then
347: p_rec.program_application_id :=
348: hr_dty_shd.g_old_rec.program_application_id;
349: End If;
350: If (p_rec.program_id = hr_api.g_number) then
351: p_rec.program_id :=
352: hr_dty_shd.g_old_rec.program_id;
353: End If;
354: If (p_rec.program_update_date = hr_api.g_date) then
350: If (p_rec.program_id = hr_api.g_number) then
351: p_rec.program_id :=
352: hr_dty_shd.g_old_rec.program_id;
353: End If;
354: If (p_rec.program_update_date = hr_api.g_date) then
355: p_rec.program_update_date :=
356: hr_dty_shd.g_old_rec.program_update_date;
357: End If;
358: --
423: Procedure upd
424: (p_effective_date in date
425: ,p_document_type_id in number
426: ,p_object_version_number in out nocopy number
427: ,p_category_code in varchar2 default hr_api.g_varchar2
428: ,p_active_inactive_flag in varchar2 default hr_api.g_varchar2
429: ,p_multiple_occurences_flag in varchar2 default hr_api.g_varchar2
430: ,p_legislation_code in varchar2 default hr_api.g_varchar2
431: ,p_authorization_required in varchar2 default hr_api.g_varchar2
424: (p_effective_date in date
425: ,p_document_type_id in number
426: ,p_object_version_number in out nocopy number
427: ,p_category_code in varchar2 default hr_api.g_varchar2
428: ,p_active_inactive_flag in varchar2 default hr_api.g_varchar2
429: ,p_multiple_occurences_flag in varchar2 default hr_api.g_varchar2
430: ,p_legislation_code in varchar2 default hr_api.g_varchar2
431: ,p_authorization_required in varchar2 default hr_api.g_varchar2
432: ,p_sub_category_code in varchar2 default hr_api.g_varchar2
425: ,p_document_type_id in number
426: ,p_object_version_number in out nocopy number
427: ,p_category_code in varchar2 default hr_api.g_varchar2
428: ,p_active_inactive_flag in varchar2 default hr_api.g_varchar2
429: ,p_multiple_occurences_flag in varchar2 default hr_api.g_varchar2
430: ,p_legislation_code in varchar2 default hr_api.g_varchar2
431: ,p_authorization_required in varchar2 default hr_api.g_varchar2
432: ,p_sub_category_code in varchar2 default hr_api.g_varchar2
433: ,p_warning_period in number default hr_api.g_number
426: ,p_object_version_number in out nocopy number
427: ,p_category_code in varchar2 default hr_api.g_varchar2
428: ,p_active_inactive_flag in varchar2 default hr_api.g_varchar2
429: ,p_multiple_occurences_flag in varchar2 default hr_api.g_varchar2
430: ,p_legislation_code in varchar2 default hr_api.g_varchar2
431: ,p_authorization_required in varchar2 default hr_api.g_varchar2
432: ,p_sub_category_code in varchar2 default hr_api.g_varchar2
433: ,p_warning_period in number default hr_api.g_number
434: ,p_request_id in number default hr_api.g_number
427: ,p_category_code in varchar2 default hr_api.g_varchar2
428: ,p_active_inactive_flag in varchar2 default hr_api.g_varchar2
429: ,p_multiple_occurences_flag in varchar2 default hr_api.g_varchar2
430: ,p_legislation_code in varchar2 default hr_api.g_varchar2
431: ,p_authorization_required in varchar2 default hr_api.g_varchar2
432: ,p_sub_category_code in varchar2 default hr_api.g_varchar2
433: ,p_warning_period in number default hr_api.g_number
434: ,p_request_id in number default hr_api.g_number
435: ,p_program_application_id in number default hr_api.g_number
428: ,p_active_inactive_flag in varchar2 default hr_api.g_varchar2
429: ,p_multiple_occurences_flag in varchar2 default hr_api.g_varchar2
430: ,p_legislation_code in varchar2 default hr_api.g_varchar2
431: ,p_authorization_required in varchar2 default hr_api.g_varchar2
432: ,p_sub_category_code in varchar2 default hr_api.g_varchar2
433: ,p_warning_period in number default hr_api.g_number
434: ,p_request_id in number default hr_api.g_number
435: ,p_program_application_id in number default hr_api.g_number
436: ,p_program_id in number default hr_api.g_number
429: ,p_multiple_occurences_flag in varchar2 default hr_api.g_varchar2
430: ,p_legislation_code in varchar2 default hr_api.g_varchar2
431: ,p_authorization_required in varchar2 default hr_api.g_varchar2
432: ,p_sub_category_code in varchar2 default hr_api.g_varchar2
433: ,p_warning_period in number default hr_api.g_number
434: ,p_request_id in number default hr_api.g_number
435: ,p_program_application_id in number default hr_api.g_number
436: ,p_program_id in number default hr_api.g_number
437: ,p_program_update_date in date default hr_api.g_date
430: ,p_legislation_code in varchar2 default hr_api.g_varchar2
431: ,p_authorization_required in varchar2 default hr_api.g_varchar2
432: ,p_sub_category_code in varchar2 default hr_api.g_varchar2
433: ,p_warning_period in number default hr_api.g_number
434: ,p_request_id in number default hr_api.g_number
435: ,p_program_application_id in number default hr_api.g_number
436: ,p_program_id in number default hr_api.g_number
437: ,p_program_update_date in date default hr_api.g_date
438: ) is
431: ,p_authorization_required in varchar2 default hr_api.g_varchar2
432: ,p_sub_category_code in varchar2 default hr_api.g_varchar2
433: ,p_warning_period in number default hr_api.g_number
434: ,p_request_id in number default hr_api.g_number
435: ,p_program_application_id in number default hr_api.g_number
436: ,p_program_id in number default hr_api.g_number
437: ,p_program_update_date in date default hr_api.g_date
438: ) is
439: --
432: ,p_sub_category_code in varchar2 default hr_api.g_varchar2
433: ,p_warning_period in number default hr_api.g_number
434: ,p_request_id in number default hr_api.g_number
435: ,p_program_application_id in number default hr_api.g_number
436: ,p_program_id in number default hr_api.g_number
437: ,p_program_update_date in date default hr_api.g_date
438: ) is
439: --
440: l_rec hr_dty_shd.g_rec_type;
433: ,p_warning_period in number default hr_api.g_number
434: ,p_request_id in number default hr_api.g_number
435: ,p_program_application_id in number default hr_api.g_number
436: ,p_program_id in number default hr_api.g_number
437: ,p_program_update_date in date default hr_api.g_date
438: ) is
439: --
440: l_rec hr_dty_shd.g_rec_type;
441: l_proc varchar2(72) := g_package||'upd';