118: ,p_program_update_date => p_program_update_date
119: ,p_topnode_pos_ctrl_enabled_fla => p_topnode_pos_ctrl_enabled_fla
120: );
121: exception
122: when hr_api.cannot_find_prog_unit then
123: hr_api.cannot_find_prog_unit_error
124: (p_module_name => 'create_org_structure_version'
125: ,p_hook_type => 'BP'
126: );
119: ,p_topnode_pos_ctrl_enabled_fla => p_topnode_pos_ctrl_enabled_fla
120: );
121: exception
122: when hr_api.cannot_find_prog_unit then
123: hr_api.cannot_find_prog_unit_error
124: (p_module_name => 'create_org_structure_version'
125: ,p_hook_type => 'BP'
126: );
127: end;
169: ,p_org_structure_version_id => l_org_structure_version_id
170: ,p_object_version_number => l_object_version_number
171: ,p_gap_warning => p_gap_warning );
172: exception
173: when hr_api.cannot_find_prog_unit then
174: hr_api.cannot_find_prog_unit_error
175: (p_module_name => 'create_org_structure_version'
176: ,p_hook_type => 'AP'
177: );
170: ,p_object_version_number => l_object_version_number
171: ,p_gap_warning => p_gap_warning );
172: exception
173: when hr_api.cannot_find_prog_unit then
174: hr_api.cannot_find_prog_unit_error
175: (p_module_name => 'create_org_structure_version'
176: ,p_hook_type => 'AP'
177: );
178: end;
204: --
205: -- When in validation only mode raise the Validate_Enabled exception
206: --
207: IF p_validate THEN
208: RAISE hr_api.validate_enabled;
209: END IF;
210: --
211: --
212: hr_utility.set_location(' Leaving:'||l_proc, 70);
213: --
214:
215: EXCEPTION
216: --
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: --
254: (p_validate in boolean default false
255: ,p_effective_date in date
256: ,p_date_from in date
257: ,p_version_number in number
258: ,p_copy_structure_version_id in number default hr_api.g_number
259: ,p_date_to in date default hr_api.g_date
260: ,p_request_id in number default hr_api.g_number
261: ,p_program_application_id in number default hr_api.g_number
262: ,p_program_id in number default hr_api.g_number
255: ,p_effective_date in date
256: ,p_date_from in date
257: ,p_version_number in number
258: ,p_copy_structure_version_id in number default hr_api.g_number
259: ,p_date_to in date default hr_api.g_date
260: ,p_request_id in number default hr_api.g_number
261: ,p_program_application_id in number default hr_api.g_number
262: ,p_program_id in number default hr_api.g_number
263: ,p_program_update_date in date default hr_api.g_date
256: ,p_date_from in date
257: ,p_version_number in number
258: ,p_copy_structure_version_id in number default hr_api.g_number
259: ,p_date_to in date default hr_api.g_date
260: ,p_request_id in number default hr_api.g_number
261: ,p_program_application_id in number default hr_api.g_number
262: ,p_program_id in number default hr_api.g_number
263: ,p_program_update_date in date default hr_api.g_date
264: ,p_topnode_pos_ctrl_enabled_fla in varchar2 default hr_api.g_varchar2
257: ,p_version_number in number
258: ,p_copy_structure_version_id in number default hr_api.g_number
259: ,p_date_to in date default hr_api.g_date
260: ,p_request_id in number default hr_api.g_number
261: ,p_program_application_id in number default hr_api.g_number
262: ,p_program_id in number default hr_api.g_number
263: ,p_program_update_date in date default hr_api.g_date
264: ,p_topnode_pos_ctrl_enabled_fla in varchar2 default hr_api.g_varchar2
265: ,p_org_structure_version_id in number
258: ,p_copy_structure_version_id in number default hr_api.g_number
259: ,p_date_to in date default hr_api.g_date
260: ,p_request_id in number default hr_api.g_number
261: ,p_program_application_id in number default hr_api.g_number
262: ,p_program_id in number default hr_api.g_number
263: ,p_program_update_date in date default hr_api.g_date
264: ,p_topnode_pos_ctrl_enabled_fla in varchar2 default hr_api.g_varchar2
265: ,p_org_structure_version_id in number
266: ,p_object_version_number in out nocopy number
259: ,p_date_to in date default hr_api.g_date
260: ,p_request_id in number default hr_api.g_number
261: ,p_program_application_id in number default hr_api.g_number
262: ,p_program_id in number default hr_api.g_number
263: ,p_program_update_date in date default hr_api.g_date
264: ,p_topnode_pos_ctrl_enabled_fla in varchar2 default hr_api.g_varchar2
265: ,p_org_structure_version_id in number
266: ,p_object_version_number in out nocopy number
267: ,p_gap_warning out nocopy boolean
260: ,p_request_id in number default hr_api.g_number
261: ,p_program_application_id in number default hr_api.g_number
262: ,p_program_id in number default hr_api.g_number
263: ,p_program_update_date in date default hr_api.g_date
264: ,p_topnode_pos_ctrl_enabled_fla in varchar2 default hr_api.g_varchar2
265: ,p_org_structure_version_id in number
266: ,p_object_version_number in out nocopy number
267: ,p_gap_warning out nocopy boolean
268: ) IS
296: ,p_object_version_number => p_object_version_number
297: );
298:
299: exception
300: when hr_api.cannot_find_prog_unit then
301: hr_api.cannot_find_prog_unit_error
302: (p_module_name => 'update_org_structure'
303: ,p_hook_type => 'BP'
304: );
297: );
298:
299: exception
300: when hr_api.cannot_find_prog_unit then
301: hr_api.cannot_find_prog_unit_error
302: (p_module_name => 'update_org_structure'
303: ,p_hook_type => 'BP'
304: );
305: end;
338: --
339: -- When in validation only mode raise the Validate_Enabled exception
340: --
341: IF p_validate THEN
342: RAISE hr_api.validate_enabled;
343: END IF;
344: --
345: -- Set all output arguments. If p_validate was TRUE, this bit is
346: -- never reached, so p_object_version_number is passed back unchanged.
367: ,p_object_version_number => p_object_version_number
368: ,p_gap_warning => p_gap_warning);
369:
370: exception
371: when hr_api.cannot_find_prog_unit then
372: hr_api.cannot_find_prog_unit_error
373: (p_module_name => 'update_org_structure_version'
374: ,p_hook_type => 'AP'
375: );
368: ,p_gap_warning => p_gap_warning);
369:
370: exception
371: when hr_api.cannot_find_prog_unit then
372: hr_api.cannot_find_prog_unit_error
373: (p_module_name => 'update_org_structure_version'
374: ,p_hook_type => 'AP'
375: );
376: end;
376: end;
377:
378: EXCEPTION
379: --
380: WHEN hr_api.validate_enabled THEN
381: --
382: -- As the Validate_Enabled exception has been raised
383: -- we must rollback to the savepoint
384: --
434: , p_object_version_number => p_object_version_number
435: );
436:
437: exception
438: when hr_api.cannot_find_prog_unit then
439: hr_api.cannot_find_prog_unit_error
440: (p_module_name => 'delete_org_structure_version'
441: ,p_hook_type => 'BP'
442: );
435: );
436:
437: exception
438: when hr_api.cannot_find_prog_unit then
439: hr_api.cannot_find_prog_unit_error
440: (p_module_name => 'delete_org_structure_version'
441: ,p_hook_type => 'BP'
442: );
443: end;
461: --
462: -- When in validation only mode raise the Validate_Enabled exception
463: --
464: IF p_validate THEN
465: RAISE hr_api.validate_enabled;
466: END IF;
467: --
468: --
469: begin
473: ,p_object_version_number => p_object_version_number
474: );
475:
476: exception
477: when hr_api.cannot_find_prog_unit then
478: hr_api.cannot_find_prog_unit_error
479: (p_module_name => 'delete_org_structure_version'
480: ,p_hook_type => 'AP'
481: );
474: );
475:
476: exception
477: when hr_api.cannot_find_prog_unit then
478: hr_api.cannot_find_prog_unit_error
479: (p_module_name => 'delete_org_structure_version'
480: ,p_hook_type => 'AP'
481: );
482: end;
483:
484:
485: EXCEPTION
486: --
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: --