10: -- ----------------------------------------------------------------------------
11: --
12: procedure create_document_type(
13: p_validate in boolean default false
14: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
15: ,p_description in varchar2 default null
16: ,p_document_type in varchar2
17: ,p_effective_date in date default sysdate
18: ,p_category_code in varchar2
64: ,p_program_id => p_program_id
65: ,p_program_update_date => p_program_update_date
66: );
67: exception
68: when hr_api.cannot_find_prog_unit then
69: hr_api.cannot_find_prog_unit_error
70: (p_module_name => 'CREATE_DOCUMENT_TYPE'
71: ,p_hook_type => 'BP'
72: );
65: ,p_program_update_date => p_program_update_date
66: );
67: exception
68: when hr_api.cannot_find_prog_unit then
69: hr_api.cannot_find_prog_unit_error
70: (p_module_name => 'CREATE_DOCUMENT_TYPE'
71: ,p_hook_type => 'BP'
72: );
73: end;
82: -- instead of p_language_code from now on, to allow an IN OUT parameter to
83: -- be passed through.
84: --
85: l_language_code := p_language_code;
86: --hr_api.validate_language_code(p_language_code => l_language_code);
87: --
88: hr_utility.set_location(l_proc, 20);
89:
90: --
149: ,p_program_update_date => p_program_update_date
150: ,p_object_version_number => l_document_type_id
151: );
152: exception
153: when hr_api.cannot_find_prog_unit then
154: hr_api.cannot_find_prog_unit_error
155: (p_module_name => 'CREATE_DOCUMENT_TYPE',
156: p_hook_type => 'BP'
157: );
150: ,p_object_version_number => l_document_type_id
151: );
152: exception
153: when hr_api.cannot_find_prog_unit then
154: hr_api.cannot_find_prog_unit_error
155: (p_module_name => 'CREATE_DOCUMENT_TYPE',
156: p_hook_type => 'BP'
157: );
158: end;
161: --
162: -- When in validation only mode raise the Validate_Enabled exception
163: --
164: if p_validate then
165: raise hr_api.validate_enabled;
166: end if;
167: --
168: hr_utility.set_location(' Leaving:'||l_proc, 11);
169: exception
166: end if;
167: --
168: hr_utility.set_location(' Leaving:'||l_proc, 11);
169: exception
170: when hr_api.validate_enabled then
171: --
172: -- As the Validate_Enabled exception has been raised
173: -- we must rollback to the savepoint
174: --
206: --
207: procedure update_document_type(
208: p_validate in boolean default false
209: ,p_effective_date in date default sysdate
210: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
211: ,p_description in varchar2
212: ,p_document_type in varchar2
213: ,p_document_type_id in number
214: ,p_object_version_number in out nocopy number
214: ,p_object_version_number in out nocopy number
215: ,p_category_code in varchar2
216: ,p_active_inactive_flag in varchar2
217: ,p_multiple_occurences_flag in varchar2
218: ,p_legislation_code in varchar2 default hr_api.g_varchar2
219: ,p_authorization_required in varchar2
220: ,p_sub_category_code in varchar2 default hr_api.g_varchar2
221: ,p_warning_period in number default hr_api.g_number
222: ,p_request_id in number default hr_api.g_number
216: ,p_active_inactive_flag in varchar2
217: ,p_multiple_occurences_flag in varchar2
218: ,p_legislation_code in varchar2 default hr_api.g_varchar2
219: ,p_authorization_required in varchar2
220: ,p_sub_category_code in varchar2 default hr_api.g_varchar2
221: ,p_warning_period in number default hr_api.g_number
222: ,p_request_id in number default hr_api.g_number
223: ,p_program_application_id in number default hr_api.g_number
224: ,p_program_id in number default hr_api.g_number
217: ,p_multiple_occurences_flag in varchar2
218: ,p_legislation_code in varchar2 default hr_api.g_varchar2
219: ,p_authorization_required in varchar2
220: ,p_sub_category_code in varchar2 default hr_api.g_varchar2
221: ,p_warning_period in number default hr_api.g_number
222: ,p_request_id in number default hr_api.g_number
223: ,p_program_application_id in number default hr_api.g_number
224: ,p_program_id in number default hr_api.g_number
225: ,p_program_update_date in date default hr_api.g_date
218: ,p_legislation_code in varchar2 default hr_api.g_varchar2
219: ,p_authorization_required in varchar2
220: ,p_sub_category_code in varchar2 default hr_api.g_varchar2
221: ,p_warning_period in number default hr_api.g_number
222: ,p_request_id in number default hr_api.g_number
223: ,p_program_application_id in number default hr_api.g_number
224: ,p_program_id in number default hr_api.g_number
225: ,p_program_update_date in date default hr_api.g_date
226: ) IS
219: ,p_authorization_required in varchar2
220: ,p_sub_category_code in varchar2 default hr_api.g_varchar2
221: ,p_warning_period in number default hr_api.g_number
222: ,p_request_id in number default hr_api.g_number
223: ,p_program_application_id in number default hr_api.g_number
224: ,p_program_id in number default hr_api.g_number
225: ,p_program_update_date in date default hr_api.g_date
226: ) IS
227: --
220: ,p_sub_category_code in varchar2 default hr_api.g_varchar2
221: ,p_warning_period in number default hr_api.g_number
222: ,p_request_id in number default hr_api.g_number
223: ,p_program_application_id in number default hr_api.g_number
224: ,p_program_id in number default hr_api.g_number
225: ,p_program_update_date in date default hr_api.g_date
226: ) IS
227: --
228: --
221: ,p_warning_period in number default hr_api.g_number
222: ,p_request_id in number default hr_api.g_number
223: ,p_program_application_id in number default hr_api.g_number
224: ,p_program_id in number default hr_api.g_number
225: ,p_program_update_date in date default hr_api.g_date
226: ) IS
227: --
228: --
229: -- Declare cursors and local variables
261: ,p_document_type_id => p_document_type_id
262: ,p_object_version_number => p_object_version_number
263: );
264: exception
265: when hr_api.cannot_find_prog_unit then
266: hr_api.cannot_find_prog_unit_error
267: (p_module_name => 'UPDATE_DOCUMENT_TYPE',
268: p_hook_type => 'BP'
269: );
262: ,p_object_version_number => p_object_version_number
263: );
264: exception
265: when hr_api.cannot_find_prog_unit then
266: hr_api.cannot_find_prog_unit_error
267: (p_module_name => 'UPDATE_DOCUMENT_TYPE',
268: p_hook_type => 'BP'
269: );
270: end;
329: ,p_document_type_id => p_document_type_id
330: ,p_object_version_number => p_object_version_number
331: );
332: exception
333: when hr_api.cannot_find_prog_unit then
334: hr_api.cannot_find_prog_unit_error
335: (p_module_name => 'UPDATE_DOCUMENT_TYPE',
336: p_hook_type => 'AP'
337: );
330: ,p_object_version_number => p_object_version_number
331: );
332: exception
333: when hr_api.cannot_find_prog_unit then
334: hr_api.cannot_find_prog_unit_error
335: (p_module_name => 'UPDATE_DOCUMENT_TYPE',
336: p_hook_type => 'AP'
337: );
338: end;
341: --
342: -- When in validation only mode raise the Validate_Enabled exception
343: --
344: if p_validate then
345: raise hr_api.validate_enabled;
346: end if;
347: --
348: hr_utility.set_location(' Leaving:'||l_proc, 11);
349: exception
346: end if;
347: --
348: hr_utility.set_location(' Leaving:'||l_proc, 11);
349: exception
350: when hr_api.validate_enabled then
351: --
352: -- As the Validate_Enabled exception has been raised
353: -- we must rollback to the savepoint
354: --
405: (p_document_type_id => p_document_type_id,
406: p_object_version_number => p_object_version_number
407: );
408: exception
409: when hr_api.cannot_find_prog_unit then
410: hr_api.cannot_find_prog_unit_error
411: (p_module_name => 'DELETE_DOCUMENT_TYPE',
412: p_hook_type => 'BP'
413: );
406: p_object_version_number => p_object_version_number
407: );
408: exception
409: when hr_api.cannot_find_prog_unit then
410: hr_api.cannot_find_prog_unit_error
411: (p_module_name => 'DELETE_DOCUMENT_TYPE',
412: p_hook_type => 'BP'
413: );
414: end;
437: (p_document_type_id => p_document_type_id,
438: p_object_version_number => p_object_version_number
439: );
440: exception
441: when hr_api.cannot_find_prog_unit then
442: hr_api.cannot_find_prog_unit_error
443: (p_module_name => 'DELETE_DOCUMENT_TYPE',
444: p_hook_type => 'AP'
445: );
438: p_object_version_number => p_object_version_number
439: );
440: exception
441: when hr_api.cannot_find_prog_unit then
442: hr_api.cannot_find_prog_unit_error
443: (p_module_name => 'DELETE_DOCUMENT_TYPE',
444: p_hook_type => 'AP'
445: );
446: end;
449: --
450: -- When in validation only mode raise the Validate_Enabled exception
451: --
452: if p_validate then
453: raise hr_api.validate_enabled;
454: end if;
455: --
456: hr_utility.set_location(' Leaving:'||l_proc, 11);
457: exception
454: end if;
455: --
456: hr_utility.set_location(' Leaving:'||l_proc, 11);
457: exception
458: when hr_api.validate_enabled then
459: --
460: -- As the Validate_Enabled exception has been raised
461: -- we must rollback to the savepoint
462: --