DBA Data[Home] [Help]

APPS.HR_DOCUMENT_TYPES_API dependencies on HR_API

Line 14: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang

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

Line 68: when hr_api.cannot_find_prog_unit then

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: );

Line 69: hr_api.cannot_find_prog_unit_error

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;

Line 86: --hr_api.validate_language_code(p_language_code => l_language_code);

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: --

Line 153: when hr_api.cannot_find_prog_unit then

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: );

Line 154: hr_api.cannot_find_prog_unit_error

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;

Line 165: raise hr_api.validate_enabled;

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

Line 170: when hr_api.validate_enabled then

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: --

Line 210: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang

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

Line 218: ,p_legislation_code in varchar2 default hr_api.g_varchar2

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

Line 220: ,p_sub_category_code in varchar2 default hr_api.g_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
223: ,p_program_application_id in number default hr_api.g_number
224: ,p_program_id in number default hr_api.g_number

Line 221: ,p_warning_period 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

Line 222: ,p_request_id in number default hr_api.g_number

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

Line 223: ,p_program_application_id in number default hr_api.g_number

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: --

Line 224: ,p_program_id in number default hr_api.g_number

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: --

Line 225: ,p_program_update_date in date default hr_api.g_date

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

Line 265: when hr_api.cannot_find_prog_unit then

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: );

Line 266: hr_api.cannot_find_prog_unit_error

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;

Line 333: when hr_api.cannot_find_prog_unit then

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: );

Line 334: hr_api.cannot_find_prog_unit_error

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;

Line 345: raise hr_api.validate_enabled;

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

Line 350: when hr_api.validate_enabled then

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: --

Line 409: when hr_api.cannot_find_prog_unit then

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: );

Line 410: hr_api.cannot_find_prog_unit_error

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;

Line 441: when hr_api.cannot_find_prog_unit then

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: );

Line 442: hr_api.cannot_find_prog_unit_error

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;

Line 453: raise hr_api.validate_enabled;

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

Line 458: when hr_api.validate_enabled then

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: --