97: ,p_attribute19 => p_attribute19
98: ,p_attribute20 => p_attribute20
99: );
100: exception
101: when hr_api.cannot_find_prog_unit then
102: hr_api.cannot_find_prog_unit_error
103: (p_module_name => 'Create_Lp_Section'
104: ,p_hook_type => 'BP'
105: );
98: ,p_attribute20 => p_attribute20
99: );
100: exception
101: when hr_api.cannot_find_prog_unit then
102: hr_api.cannot_find_prog_unit_error
103: (p_module_name => 'Create_Lp_Section'
104: ,p_hook_type => 'BP'
105: );
106: end;
193: ,p_learning_path_section_id => l_learning_path_section_id
194: ,p_object_version_number => l_object_version_number
195: );
196: exception
197: when hr_api.cannot_find_prog_unit then
198: hr_api.cannot_find_prog_unit_error
199: (p_module_name => 'Create_Lp_Section'
200: ,p_hook_type => 'AP'
201: );
194: ,p_object_version_number => l_object_version_number
195: );
196: exception
197: when hr_api.cannot_find_prog_unit then
198: hr_api.cannot_find_prog_unit_error
199: (p_module_name => 'Create_Lp_Section'
200: ,p_hook_type => 'AP'
201: );
202: end;
203: --
204: -- When in validation only mode raise the Validate_Enabled exception
205: --
206: if p_validate then
207: raise hr_api.validate_enabled;
208: end if;
209: --
210: -- Set all output arguments
211: --
213: p_object_version_number := l_object_version_number;
214: --
215: hr_utility.set_location(' Leaving:'||l_proc, 70);
216: exception
217: when hr_api.validate_enabled then
218: --
219: -- As the Validate_Enabled exception has been raised
220: -- we must rollback to the savepoint
221: --
246: (p_validate in boolean default false
247: ,p_effective_date in date
248: ,p_learning_path_section_id in number
249: ,p_section_name in varchar2
250: ,p_description in varchar2 default hr_api.g_varchar2
251: ,p_object_version_number in out nocopy number
252: ,p_section_sequence in number default hr_api.g_number
253: ,p_completion_type_code in varchar2 default hr_api.g_varchar2
254: ,p_no_of_mandatory_courses in number default hr_api.g_number
248: ,p_learning_path_section_id in number
249: ,p_section_name in varchar2
250: ,p_description in varchar2 default hr_api.g_varchar2
251: ,p_object_version_number in out nocopy number
252: ,p_section_sequence in number default hr_api.g_number
253: ,p_completion_type_code in varchar2 default hr_api.g_varchar2
254: ,p_no_of_mandatory_courses in number default hr_api.g_number
255: ,p_attribute_category in varchar2 default hr_api.g_varchar2
256: ,p_attribute1 in varchar2 default hr_api.g_varchar2
249: ,p_section_name in varchar2
250: ,p_description in varchar2 default hr_api.g_varchar2
251: ,p_object_version_number in out nocopy number
252: ,p_section_sequence in number default hr_api.g_number
253: ,p_completion_type_code in varchar2 default hr_api.g_varchar2
254: ,p_no_of_mandatory_courses in number default hr_api.g_number
255: ,p_attribute_category in varchar2 default hr_api.g_varchar2
256: ,p_attribute1 in varchar2 default hr_api.g_varchar2
257: ,p_attribute2 in varchar2 default hr_api.g_varchar2
250: ,p_description in varchar2 default hr_api.g_varchar2
251: ,p_object_version_number in out nocopy number
252: ,p_section_sequence in number default hr_api.g_number
253: ,p_completion_type_code in varchar2 default hr_api.g_varchar2
254: ,p_no_of_mandatory_courses in number default hr_api.g_number
255: ,p_attribute_category in varchar2 default hr_api.g_varchar2
256: ,p_attribute1 in varchar2 default hr_api.g_varchar2
257: ,p_attribute2 in varchar2 default hr_api.g_varchar2
258: ,p_attribute3 in varchar2 default hr_api.g_varchar2
251: ,p_object_version_number in out nocopy number
252: ,p_section_sequence in number default hr_api.g_number
253: ,p_completion_type_code in varchar2 default hr_api.g_varchar2
254: ,p_no_of_mandatory_courses in number default hr_api.g_number
255: ,p_attribute_category in varchar2 default hr_api.g_varchar2
256: ,p_attribute1 in varchar2 default hr_api.g_varchar2
257: ,p_attribute2 in varchar2 default hr_api.g_varchar2
258: ,p_attribute3 in varchar2 default hr_api.g_varchar2
259: ,p_attribute4 in varchar2 default hr_api.g_varchar2
252: ,p_section_sequence in number default hr_api.g_number
253: ,p_completion_type_code in varchar2 default hr_api.g_varchar2
254: ,p_no_of_mandatory_courses in number default hr_api.g_number
255: ,p_attribute_category in varchar2 default hr_api.g_varchar2
256: ,p_attribute1 in varchar2 default hr_api.g_varchar2
257: ,p_attribute2 in varchar2 default hr_api.g_varchar2
258: ,p_attribute3 in varchar2 default hr_api.g_varchar2
259: ,p_attribute4 in varchar2 default hr_api.g_varchar2
260: ,p_attribute5 in varchar2 default hr_api.g_varchar2
253: ,p_completion_type_code in varchar2 default hr_api.g_varchar2
254: ,p_no_of_mandatory_courses in number default hr_api.g_number
255: ,p_attribute_category in varchar2 default hr_api.g_varchar2
256: ,p_attribute1 in varchar2 default hr_api.g_varchar2
257: ,p_attribute2 in varchar2 default hr_api.g_varchar2
258: ,p_attribute3 in varchar2 default hr_api.g_varchar2
259: ,p_attribute4 in varchar2 default hr_api.g_varchar2
260: ,p_attribute5 in varchar2 default hr_api.g_varchar2
261: ,p_attribute6 in varchar2 default hr_api.g_varchar2
254: ,p_no_of_mandatory_courses in number default hr_api.g_number
255: ,p_attribute_category in varchar2 default hr_api.g_varchar2
256: ,p_attribute1 in varchar2 default hr_api.g_varchar2
257: ,p_attribute2 in varchar2 default hr_api.g_varchar2
258: ,p_attribute3 in varchar2 default hr_api.g_varchar2
259: ,p_attribute4 in varchar2 default hr_api.g_varchar2
260: ,p_attribute5 in varchar2 default hr_api.g_varchar2
261: ,p_attribute6 in varchar2 default hr_api.g_varchar2
262: ,p_attribute7 in varchar2 default hr_api.g_varchar2
255: ,p_attribute_category in varchar2 default hr_api.g_varchar2
256: ,p_attribute1 in varchar2 default hr_api.g_varchar2
257: ,p_attribute2 in varchar2 default hr_api.g_varchar2
258: ,p_attribute3 in varchar2 default hr_api.g_varchar2
259: ,p_attribute4 in varchar2 default hr_api.g_varchar2
260: ,p_attribute5 in varchar2 default hr_api.g_varchar2
261: ,p_attribute6 in varchar2 default hr_api.g_varchar2
262: ,p_attribute7 in varchar2 default hr_api.g_varchar2
263: ,p_attribute8 in varchar2 default hr_api.g_varchar2
256: ,p_attribute1 in varchar2 default hr_api.g_varchar2
257: ,p_attribute2 in varchar2 default hr_api.g_varchar2
258: ,p_attribute3 in varchar2 default hr_api.g_varchar2
259: ,p_attribute4 in varchar2 default hr_api.g_varchar2
260: ,p_attribute5 in varchar2 default hr_api.g_varchar2
261: ,p_attribute6 in varchar2 default hr_api.g_varchar2
262: ,p_attribute7 in varchar2 default hr_api.g_varchar2
263: ,p_attribute8 in varchar2 default hr_api.g_varchar2
264: ,p_attribute9 in varchar2 default hr_api.g_varchar2
257: ,p_attribute2 in varchar2 default hr_api.g_varchar2
258: ,p_attribute3 in varchar2 default hr_api.g_varchar2
259: ,p_attribute4 in varchar2 default hr_api.g_varchar2
260: ,p_attribute5 in varchar2 default hr_api.g_varchar2
261: ,p_attribute6 in varchar2 default hr_api.g_varchar2
262: ,p_attribute7 in varchar2 default hr_api.g_varchar2
263: ,p_attribute8 in varchar2 default hr_api.g_varchar2
264: ,p_attribute9 in varchar2 default hr_api.g_varchar2
265: ,p_attribute10 in varchar2 default hr_api.g_varchar2
258: ,p_attribute3 in varchar2 default hr_api.g_varchar2
259: ,p_attribute4 in varchar2 default hr_api.g_varchar2
260: ,p_attribute5 in varchar2 default hr_api.g_varchar2
261: ,p_attribute6 in varchar2 default hr_api.g_varchar2
262: ,p_attribute7 in varchar2 default hr_api.g_varchar2
263: ,p_attribute8 in varchar2 default hr_api.g_varchar2
264: ,p_attribute9 in varchar2 default hr_api.g_varchar2
265: ,p_attribute10 in varchar2 default hr_api.g_varchar2
266: ,p_attribute11 in varchar2 default hr_api.g_varchar2
259: ,p_attribute4 in varchar2 default hr_api.g_varchar2
260: ,p_attribute5 in varchar2 default hr_api.g_varchar2
261: ,p_attribute6 in varchar2 default hr_api.g_varchar2
262: ,p_attribute7 in varchar2 default hr_api.g_varchar2
263: ,p_attribute8 in varchar2 default hr_api.g_varchar2
264: ,p_attribute9 in varchar2 default hr_api.g_varchar2
265: ,p_attribute10 in varchar2 default hr_api.g_varchar2
266: ,p_attribute11 in varchar2 default hr_api.g_varchar2
267: ,p_attribute12 in varchar2 default hr_api.g_varchar2
260: ,p_attribute5 in varchar2 default hr_api.g_varchar2
261: ,p_attribute6 in varchar2 default hr_api.g_varchar2
262: ,p_attribute7 in varchar2 default hr_api.g_varchar2
263: ,p_attribute8 in varchar2 default hr_api.g_varchar2
264: ,p_attribute9 in varchar2 default hr_api.g_varchar2
265: ,p_attribute10 in varchar2 default hr_api.g_varchar2
266: ,p_attribute11 in varchar2 default hr_api.g_varchar2
267: ,p_attribute12 in varchar2 default hr_api.g_varchar2
268: ,p_attribute13 in varchar2 default hr_api.g_varchar2
261: ,p_attribute6 in varchar2 default hr_api.g_varchar2
262: ,p_attribute7 in varchar2 default hr_api.g_varchar2
263: ,p_attribute8 in varchar2 default hr_api.g_varchar2
264: ,p_attribute9 in varchar2 default hr_api.g_varchar2
265: ,p_attribute10 in varchar2 default hr_api.g_varchar2
266: ,p_attribute11 in varchar2 default hr_api.g_varchar2
267: ,p_attribute12 in varchar2 default hr_api.g_varchar2
268: ,p_attribute13 in varchar2 default hr_api.g_varchar2
269: ,p_attribute14 in varchar2 default hr_api.g_varchar2
262: ,p_attribute7 in varchar2 default hr_api.g_varchar2
263: ,p_attribute8 in varchar2 default hr_api.g_varchar2
264: ,p_attribute9 in varchar2 default hr_api.g_varchar2
265: ,p_attribute10 in varchar2 default hr_api.g_varchar2
266: ,p_attribute11 in varchar2 default hr_api.g_varchar2
267: ,p_attribute12 in varchar2 default hr_api.g_varchar2
268: ,p_attribute13 in varchar2 default hr_api.g_varchar2
269: ,p_attribute14 in varchar2 default hr_api.g_varchar2
270: ,p_attribute15 in varchar2 default hr_api.g_varchar2
263: ,p_attribute8 in varchar2 default hr_api.g_varchar2
264: ,p_attribute9 in varchar2 default hr_api.g_varchar2
265: ,p_attribute10 in varchar2 default hr_api.g_varchar2
266: ,p_attribute11 in varchar2 default hr_api.g_varchar2
267: ,p_attribute12 in varchar2 default hr_api.g_varchar2
268: ,p_attribute13 in varchar2 default hr_api.g_varchar2
269: ,p_attribute14 in varchar2 default hr_api.g_varchar2
270: ,p_attribute15 in varchar2 default hr_api.g_varchar2
271: ,p_attribute16 in varchar2 default hr_api.g_varchar2
264: ,p_attribute9 in varchar2 default hr_api.g_varchar2
265: ,p_attribute10 in varchar2 default hr_api.g_varchar2
266: ,p_attribute11 in varchar2 default hr_api.g_varchar2
267: ,p_attribute12 in varchar2 default hr_api.g_varchar2
268: ,p_attribute13 in varchar2 default hr_api.g_varchar2
269: ,p_attribute14 in varchar2 default hr_api.g_varchar2
270: ,p_attribute15 in varchar2 default hr_api.g_varchar2
271: ,p_attribute16 in varchar2 default hr_api.g_varchar2
272: ,p_attribute17 in varchar2 default hr_api.g_varchar2
265: ,p_attribute10 in varchar2 default hr_api.g_varchar2
266: ,p_attribute11 in varchar2 default hr_api.g_varchar2
267: ,p_attribute12 in varchar2 default hr_api.g_varchar2
268: ,p_attribute13 in varchar2 default hr_api.g_varchar2
269: ,p_attribute14 in varchar2 default hr_api.g_varchar2
270: ,p_attribute15 in varchar2 default hr_api.g_varchar2
271: ,p_attribute16 in varchar2 default hr_api.g_varchar2
272: ,p_attribute17 in varchar2 default hr_api.g_varchar2
273: ,p_attribute18 in varchar2 default hr_api.g_varchar2
266: ,p_attribute11 in varchar2 default hr_api.g_varchar2
267: ,p_attribute12 in varchar2 default hr_api.g_varchar2
268: ,p_attribute13 in varchar2 default hr_api.g_varchar2
269: ,p_attribute14 in varchar2 default hr_api.g_varchar2
270: ,p_attribute15 in varchar2 default hr_api.g_varchar2
271: ,p_attribute16 in varchar2 default hr_api.g_varchar2
272: ,p_attribute17 in varchar2 default hr_api.g_varchar2
273: ,p_attribute18 in varchar2 default hr_api.g_varchar2
274: ,p_attribute19 in varchar2 default hr_api.g_varchar2
267: ,p_attribute12 in varchar2 default hr_api.g_varchar2
268: ,p_attribute13 in varchar2 default hr_api.g_varchar2
269: ,p_attribute14 in varchar2 default hr_api.g_varchar2
270: ,p_attribute15 in varchar2 default hr_api.g_varchar2
271: ,p_attribute16 in varchar2 default hr_api.g_varchar2
272: ,p_attribute17 in varchar2 default hr_api.g_varchar2
273: ,p_attribute18 in varchar2 default hr_api.g_varchar2
274: ,p_attribute19 in varchar2 default hr_api.g_varchar2
275: ,p_attribute20 in varchar2 default hr_api.g_varchar2
268: ,p_attribute13 in varchar2 default hr_api.g_varchar2
269: ,p_attribute14 in varchar2 default hr_api.g_varchar2
270: ,p_attribute15 in varchar2 default hr_api.g_varchar2
271: ,p_attribute16 in varchar2 default hr_api.g_varchar2
272: ,p_attribute17 in varchar2 default hr_api.g_varchar2
273: ,p_attribute18 in varchar2 default hr_api.g_varchar2
274: ,p_attribute19 in varchar2 default hr_api.g_varchar2
275: ,p_attribute20 in varchar2 default hr_api.g_varchar2
276: ) is
269: ,p_attribute14 in varchar2 default hr_api.g_varchar2
270: ,p_attribute15 in varchar2 default hr_api.g_varchar2
271: ,p_attribute16 in varchar2 default hr_api.g_varchar2
272: ,p_attribute17 in varchar2 default hr_api.g_varchar2
273: ,p_attribute18 in varchar2 default hr_api.g_varchar2
274: ,p_attribute19 in varchar2 default hr_api.g_varchar2
275: ,p_attribute20 in varchar2 default hr_api.g_varchar2
276: ) is
277: --
270: ,p_attribute15 in varchar2 default hr_api.g_varchar2
271: ,p_attribute16 in varchar2 default hr_api.g_varchar2
272: ,p_attribute17 in varchar2 default hr_api.g_varchar2
273: ,p_attribute18 in varchar2 default hr_api.g_varchar2
274: ,p_attribute19 in varchar2 default hr_api.g_varchar2
275: ,p_attribute20 in varchar2 default hr_api.g_varchar2
276: ) is
277: --
278: -- Declare cursors and local variables
271: ,p_attribute16 in varchar2 default hr_api.g_varchar2
272: ,p_attribute17 in varchar2 default hr_api.g_varchar2
273: ,p_attribute18 in varchar2 default hr_api.g_varchar2
274: ,p_attribute19 in varchar2 default hr_api.g_varchar2
275: ,p_attribute20 in varchar2 default hr_api.g_varchar2
276: ) is
277: --
278: -- Declare cursors and local variables
279: --
357: ,p_attribute19 => p_attribute19
358: ,p_attribute20 => p_attribute20
359: );
360: exception
361: when hr_api.cannot_find_prog_unit then
362: hr_api.cannot_find_prog_unit_error
363: (p_module_name => 'Update_Lp_Section'
364: ,p_hook_type => 'BP'
365: );
358: ,p_attribute20 => p_attribute20
359: );
360: exception
361: when hr_api.cannot_find_prog_unit then
362: hr_api.cannot_find_prog_unit_error
363: (p_module_name => 'Update_Lp_Section'
364: ,p_hook_type => 'BP'
365: );
366: end;
444: ,p_attribute19 => p_attribute19
445: ,p_attribute20 => p_attribute20
446: );
447: exception
448: when hr_api.cannot_find_prog_unit then
449: hr_api.cannot_find_prog_unit_error
450: (p_module_name => 'Update_Lp_Section'
451: ,p_hook_type => 'AP'
452: );
445: ,p_attribute20 => p_attribute20
446: );
447: exception
448: when hr_api.cannot_find_prog_unit then
449: hr_api.cannot_find_prog_unit_error
450: (p_module_name => 'Update_Lp_Section'
451: ,p_hook_type => 'AP'
452: );
453: end;
474:
475: -- When in validation only mode raise the Validate_Enabled exception
476: --
477: if p_validate then
478: raise hr_api.validate_enabled;
479: end if;
480: --
481: -- Set all output arguments
482: --
483: p_object_version_number := l_object_version_number;
484: --
485: hr_utility.set_location(' Leaving:'||l_proc, 70);
486: exception
487: when hr_api.validate_enabled then
488: --
489: -- As the Validate_Enabled exception has been raised
490: -- we must rollback to the savepoint
491: --
536: (p_learning_path_section_id => p_learning_path_section_id
537: ,p_object_version_number => p_object_version_number
538: );
539: exception
540: when hr_api.cannot_find_prog_unit then
541: hr_api.cannot_find_prog_unit_error
542: (p_module_name => 'Delete_Learning_Path_Section'
543: ,p_hook_type => 'BP'
544: );
537: ,p_object_version_number => p_object_version_number
538: );
539: exception
540: when hr_api.cannot_find_prog_unit then
541: hr_api.cannot_find_prog_unit_error
542: (p_module_name => 'Delete_Learning_Path_Section'
543: ,p_hook_type => 'BP'
544: );
545: end;
561: (p_learning_path_section_id => p_learning_path_section_id
562: ,p_object_version_number => p_object_version_number
563: );
564: exception
565: when hr_api.cannot_find_prog_unit then
566: hr_api.cannot_find_prog_unit_error
567: (p_module_name => 'Delete_Lp_Section'
568: ,p_hook_type => 'AP'
569: );
562: ,p_object_version_number => p_object_version_number
563: );
564: exception
565: when hr_api.cannot_find_prog_unit then
566: hr_api.cannot_find_prog_unit_error
567: (p_module_name => 'Delete_Lp_Section'
568: ,p_hook_type => 'AP'
569: );
570: end;
571: --
572: -- When in validation only mode raise the Validate_Enabled exception
573: --
574: if p_validate then
575: raise hr_api.validate_enabled;
576: end if;
577: --
578: -- Set all output arguments
579: --
579: --
580: --
581: hr_utility.set_location(' Leaving:'||l_proc, 170);
582: exception
583: when hr_api.validate_enabled then
584: --
585: -- As the Validate_Enabled exception has been raised
586: -- we must rollback to the savepoint
587: --