189: ,p_attribute19 => p_attribute19
190: ,p_attribute20 => p_attribute20
191: );
192: exception
193: when hr_api.cannot_find_prog_unit then
194: hr_api.cannot_find_prog_unit_error
195: (p_module_name => 'create_position_structure'
196: ,p_hook_type => 'BP'
197: );
190: ,p_attribute20 => p_attribute20
191: );
192: exception
193: when hr_api.cannot_find_prog_unit then
194: hr_api.cannot_find_prog_unit_error
195: (p_module_name => 'create_position_structure'
196: ,p_hook_type => 'BP'
197: );
198: end;
243: --
244: -- When in validation only mode raise the Validate_Enabled exception
245: --
246: IF p_validate THEN
247: RAISE hr_api.validate_enabled;
248: END IF;
249: --
250: -- Set all output arguments
251: --
293: ,p_attribute20 => p_attribute20
294: ,p_object_version_number => p_object_version_number
295: ,p_position_structure_id => p_position_structure_id);
296: exception
297: when hr_api.cannot_find_prog_unit then
298: hr_api.cannot_find_prog_unit_error
299: (p_module_name => 'create_position_structure'
300: ,p_hook_type => 'AP'
301: );
294: ,p_object_version_number => p_object_version_number
295: ,p_position_structure_id => p_position_structure_id);
296: exception
297: when hr_api.cannot_find_prog_unit then
298: hr_api.cannot_find_prog_unit_error
299: (p_module_name => 'create_position_structure'
300: ,p_hook_type => 'AP'
301: );
302: end;
303:
304:
305: EXCEPTION
306: --
307: WHEN hr_api.validate_enabled THEN
308: --
309: -- As the Validate_Enabled exception has been raised
310: -- we must rollback to the savepoint
311: --
340: PROCEDURE update_position_structure
341: (p_validate in boolean default false
342: ,p_effective_date in date
343: ,p_position_structure_id in number
344: ,p_name in varchar2 default hr_api.g_varchar2
345: ,p_comments in varchar2 default hr_api.g_varchar2
346: ,p_primary_position_flag in varchar2 default hr_api.g_varchar2
347: ,p_request_id in number default hr_api.g_number
348: ,p_program_application_id in number default hr_api.g_number
341: (p_validate in boolean default false
342: ,p_effective_date in date
343: ,p_position_structure_id in number
344: ,p_name in varchar2 default hr_api.g_varchar2
345: ,p_comments in varchar2 default hr_api.g_varchar2
346: ,p_primary_position_flag in varchar2 default hr_api.g_varchar2
347: ,p_request_id in number default hr_api.g_number
348: ,p_program_application_id in number default hr_api.g_number
349: ,p_program_id in number default hr_api.g_number
342: ,p_effective_date in date
343: ,p_position_structure_id in number
344: ,p_name in varchar2 default hr_api.g_varchar2
345: ,p_comments in varchar2 default hr_api.g_varchar2
346: ,p_primary_position_flag in varchar2 default hr_api.g_varchar2
347: ,p_request_id in number default hr_api.g_number
348: ,p_program_application_id in number default hr_api.g_number
349: ,p_program_id in number default hr_api.g_number
350: ,p_program_update_date in date default hr_api.g_date
343: ,p_position_structure_id in number
344: ,p_name in varchar2 default hr_api.g_varchar2
345: ,p_comments in varchar2 default hr_api.g_varchar2
346: ,p_primary_position_flag in varchar2 default hr_api.g_varchar2
347: ,p_request_id in number default hr_api.g_number
348: ,p_program_application_id in number default hr_api.g_number
349: ,p_program_id in number default hr_api.g_number
350: ,p_program_update_date in date default hr_api.g_date
351: ,p_attribute_category in varchar2 default hr_api.g_varchar2
344: ,p_name in varchar2 default hr_api.g_varchar2
345: ,p_comments in varchar2 default hr_api.g_varchar2
346: ,p_primary_position_flag in varchar2 default hr_api.g_varchar2
347: ,p_request_id in number default hr_api.g_number
348: ,p_program_application_id in number default hr_api.g_number
349: ,p_program_id in number default hr_api.g_number
350: ,p_program_update_date in date default hr_api.g_date
351: ,p_attribute_category in varchar2 default hr_api.g_varchar2
352: ,p_attribute1 in varchar2 default hr_api.g_varchar2
345: ,p_comments in varchar2 default hr_api.g_varchar2
346: ,p_primary_position_flag in varchar2 default hr_api.g_varchar2
347: ,p_request_id in number default hr_api.g_number
348: ,p_program_application_id in number default hr_api.g_number
349: ,p_program_id in number default hr_api.g_number
350: ,p_program_update_date in date default hr_api.g_date
351: ,p_attribute_category in varchar2 default hr_api.g_varchar2
352: ,p_attribute1 in varchar2 default hr_api.g_varchar2
353: ,p_attribute2 in varchar2 default hr_api.g_varchar2
346: ,p_primary_position_flag in varchar2 default hr_api.g_varchar2
347: ,p_request_id in number default hr_api.g_number
348: ,p_program_application_id in number default hr_api.g_number
349: ,p_program_id in number default hr_api.g_number
350: ,p_program_update_date in date default hr_api.g_date
351: ,p_attribute_category in varchar2 default hr_api.g_varchar2
352: ,p_attribute1 in varchar2 default hr_api.g_varchar2
353: ,p_attribute2 in varchar2 default hr_api.g_varchar2
354: ,p_attribute3 in varchar2 default hr_api.g_varchar2
347: ,p_request_id in number default hr_api.g_number
348: ,p_program_application_id in number default hr_api.g_number
349: ,p_program_id in number default hr_api.g_number
350: ,p_program_update_date in date default hr_api.g_date
351: ,p_attribute_category in varchar2 default hr_api.g_varchar2
352: ,p_attribute1 in varchar2 default hr_api.g_varchar2
353: ,p_attribute2 in varchar2 default hr_api.g_varchar2
354: ,p_attribute3 in varchar2 default hr_api.g_varchar2
355: ,p_attribute4 in varchar2 default hr_api.g_varchar2
348: ,p_program_application_id in number default hr_api.g_number
349: ,p_program_id in number default hr_api.g_number
350: ,p_program_update_date in date default hr_api.g_date
351: ,p_attribute_category in varchar2 default hr_api.g_varchar2
352: ,p_attribute1 in varchar2 default hr_api.g_varchar2
353: ,p_attribute2 in varchar2 default hr_api.g_varchar2
354: ,p_attribute3 in varchar2 default hr_api.g_varchar2
355: ,p_attribute4 in varchar2 default hr_api.g_varchar2
356: ,p_attribute5 in varchar2 default hr_api.g_varchar2
349: ,p_program_id in number default hr_api.g_number
350: ,p_program_update_date in date default hr_api.g_date
351: ,p_attribute_category in varchar2 default hr_api.g_varchar2
352: ,p_attribute1 in varchar2 default hr_api.g_varchar2
353: ,p_attribute2 in varchar2 default hr_api.g_varchar2
354: ,p_attribute3 in varchar2 default hr_api.g_varchar2
355: ,p_attribute4 in varchar2 default hr_api.g_varchar2
356: ,p_attribute5 in varchar2 default hr_api.g_varchar2
357: ,p_attribute6 in varchar2 default hr_api.g_varchar2
350: ,p_program_update_date in date default hr_api.g_date
351: ,p_attribute_category in varchar2 default hr_api.g_varchar2
352: ,p_attribute1 in varchar2 default hr_api.g_varchar2
353: ,p_attribute2 in varchar2 default hr_api.g_varchar2
354: ,p_attribute3 in varchar2 default hr_api.g_varchar2
355: ,p_attribute4 in varchar2 default hr_api.g_varchar2
356: ,p_attribute5 in varchar2 default hr_api.g_varchar2
357: ,p_attribute6 in varchar2 default hr_api.g_varchar2
358: ,p_attribute7 in varchar2 default hr_api.g_varchar2
351: ,p_attribute_category in varchar2 default hr_api.g_varchar2
352: ,p_attribute1 in varchar2 default hr_api.g_varchar2
353: ,p_attribute2 in varchar2 default hr_api.g_varchar2
354: ,p_attribute3 in varchar2 default hr_api.g_varchar2
355: ,p_attribute4 in varchar2 default hr_api.g_varchar2
356: ,p_attribute5 in varchar2 default hr_api.g_varchar2
357: ,p_attribute6 in varchar2 default hr_api.g_varchar2
358: ,p_attribute7 in varchar2 default hr_api.g_varchar2
359: ,p_attribute8 in varchar2 default hr_api.g_varchar2
352: ,p_attribute1 in varchar2 default hr_api.g_varchar2
353: ,p_attribute2 in varchar2 default hr_api.g_varchar2
354: ,p_attribute3 in varchar2 default hr_api.g_varchar2
355: ,p_attribute4 in varchar2 default hr_api.g_varchar2
356: ,p_attribute5 in varchar2 default hr_api.g_varchar2
357: ,p_attribute6 in varchar2 default hr_api.g_varchar2
358: ,p_attribute7 in varchar2 default hr_api.g_varchar2
359: ,p_attribute8 in varchar2 default hr_api.g_varchar2
360: ,p_attribute9 in varchar2 default hr_api.g_varchar2
353: ,p_attribute2 in varchar2 default hr_api.g_varchar2
354: ,p_attribute3 in varchar2 default hr_api.g_varchar2
355: ,p_attribute4 in varchar2 default hr_api.g_varchar2
356: ,p_attribute5 in varchar2 default hr_api.g_varchar2
357: ,p_attribute6 in varchar2 default hr_api.g_varchar2
358: ,p_attribute7 in varchar2 default hr_api.g_varchar2
359: ,p_attribute8 in varchar2 default hr_api.g_varchar2
360: ,p_attribute9 in varchar2 default hr_api.g_varchar2
361: ,p_attribute10 in varchar2 default hr_api.g_varchar2
354: ,p_attribute3 in varchar2 default hr_api.g_varchar2
355: ,p_attribute4 in varchar2 default hr_api.g_varchar2
356: ,p_attribute5 in varchar2 default hr_api.g_varchar2
357: ,p_attribute6 in varchar2 default hr_api.g_varchar2
358: ,p_attribute7 in varchar2 default hr_api.g_varchar2
359: ,p_attribute8 in varchar2 default hr_api.g_varchar2
360: ,p_attribute9 in varchar2 default hr_api.g_varchar2
361: ,p_attribute10 in varchar2 default hr_api.g_varchar2
362: ,p_attribute11 in varchar2 default hr_api.g_varchar2
355: ,p_attribute4 in varchar2 default hr_api.g_varchar2
356: ,p_attribute5 in varchar2 default hr_api.g_varchar2
357: ,p_attribute6 in varchar2 default hr_api.g_varchar2
358: ,p_attribute7 in varchar2 default hr_api.g_varchar2
359: ,p_attribute8 in varchar2 default hr_api.g_varchar2
360: ,p_attribute9 in varchar2 default hr_api.g_varchar2
361: ,p_attribute10 in varchar2 default hr_api.g_varchar2
362: ,p_attribute11 in varchar2 default hr_api.g_varchar2
363: ,p_attribute12 in varchar2 default hr_api.g_varchar2
356: ,p_attribute5 in varchar2 default hr_api.g_varchar2
357: ,p_attribute6 in varchar2 default hr_api.g_varchar2
358: ,p_attribute7 in varchar2 default hr_api.g_varchar2
359: ,p_attribute8 in varchar2 default hr_api.g_varchar2
360: ,p_attribute9 in varchar2 default hr_api.g_varchar2
361: ,p_attribute10 in varchar2 default hr_api.g_varchar2
362: ,p_attribute11 in varchar2 default hr_api.g_varchar2
363: ,p_attribute12 in varchar2 default hr_api.g_varchar2
364: ,p_attribute13 in varchar2 default hr_api.g_varchar2
357: ,p_attribute6 in varchar2 default hr_api.g_varchar2
358: ,p_attribute7 in varchar2 default hr_api.g_varchar2
359: ,p_attribute8 in varchar2 default hr_api.g_varchar2
360: ,p_attribute9 in varchar2 default hr_api.g_varchar2
361: ,p_attribute10 in varchar2 default hr_api.g_varchar2
362: ,p_attribute11 in varchar2 default hr_api.g_varchar2
363: ,p_attribute12 in varchar2 default hr_api.g_varchar2
364: ,p_attribute13 in varchar2 default hr_api.g_varchar2
365: ,p_attribute14 in varchar2 default hr_api.g_varchar2
358: ,p_attribute7 in varchar2 default hr_api.g_varchar2
359: ,p_attribute8 in varchar2 default hr_api.g_varchar2
360: ,p_attribute9 in varchar2 default hr_api.g_varchar2
361: ,p_attribute10 in varchar2 default hr_api.g_varchar2
362: ,p_attribute11 in varchar2 default hr_api.g_varchar2
363: ,p_attribute12 in varchar2 default hr_api.g_varchar2
364: ,p_attribute13 in varchar2 default hr_api.g_varchar2
365: ,p_attribute14 in varchar2 default hr_api.g_varchar2
366: ,p_attribute15 in varchar2 default hr_api.g_varchar2
359: ,p_attribute8 in varchar2 default hr_api.g_varchar2
360: ,p_attribute9 in varchar2 default hr_api.g_varchar2
361: ,p_attribute10 in varchar2 default hr_api.g_varchar2
362: ,p_attribute11 in varchar2 default hr_api.g_varchar2
363: ,p_attribute12 in varchar2 default hr_api.g_varchar2
364: ,p_attribute13 in varchar2 default hr_api.g_varchar2
365: ,p_attribute14 in varchar2 default hr_api.g_varchar2
366: ,p_attribute15 in varchar2 default hr_api.g_varchar2
367: ,p_attribute16 in varchar2 default hr_api.g_varchar2
360: ,p_attribute9 in varchar2 default hr_api.g_varchar2
361: ,p_attribute10 in varchar2 default hr_api.g_varchar2
362: ,p_attribute11 in varchar2 default hr_api.g_varchar2
363: ,p_attribute12 in varchar2 default hr_api.g_varchar2
364: ,p_attribute13 in varchar2 default hr_api.g_varchar2
365: ,p_attribute14 in varchar2 default hr_api.g_varchar2
366: ,p_attribute15 in varchar2 default hr_api.g_varchar2
367: ,p_attribute16 in varchar2 default hr_api.g_varchar2
368: ,p_attribute17 in varchar2 default hr_api.g_varchar2
361: ,p_attribute10 in varchar2 default hr_api.g_varchar2
362: ,p_attribute11 in varchar2 default hr_api.g_varchar2
363: ,p_attribute12 in varchar2 default hr_api.g_varchar2
364: ,p_attribute13 in varchar2 default hr_api.g_varchar2
365: ,p_attribute14 in varchar2 default hr_api.g_varchar2
366: ,p_attribute15 in varchar2 default hr_api.g_varchar2
367: ,p_attribute16 in varchar2 default hr_api.g_varchar2
368: ,p_attribute17 in varchar2 default hr_api.g_varchar2
369: ,p_attribute18 in varchar2 default hr_api.g_varchar2
362: ,p_attribute11 in varchar2 default hr_api.g_varchar2
363: ,p_attribute12 in varchar2 default hr_api.g_varchar2
364: ,p_attribute13 in varchar2 default hr_api.g_varchar2
365: ,p_attribute14 in varchar2 default hr_api.g_varchar2
366: ,p_attribute15 in varchar2 default hr_api.g_varchar2
367: ,p_attribute16 in varchar2 default hr_api.g_varchar2
368: ,p_attribute17 in varchar2 default hr_api.g_varchar2
369: ,p_attribute18 in varchar2 default hr_api.g_varchar2
370: ,p_attribute19 in varchar2 default hr_api.g_varchar2
363: ,p_attribute12 in varchar2 default hr_api.g_varchar2
364: ,p_attribute13 in varchar2 default hr_api.g_varchar2
365: ,p_attribute14 in varchar2 default hr_api.g_varchar2
366: ,p_attribute15 in varchar2 default hr_api.g_varchar2
367: ,p_attribute16 in varchar2 default hr_api.g_varchar2
368: ,p_attribute17 in varchar2 default hr_api.g_varchar2
369: ,p_attribute18 in varchar2 default hr_api.g_varchar2
370: ,p_attribute19 in varchar2 default hr_api.g_varchar2
371: ,p_attribute20 in varchar2 default hr_api.g_varchar2
364: ,p_attribute13 in varchar2 default hr_api.g_varchar2
365: ,p_attribute14 in varchar2 default hr_api.g_varchar2
366: ,p_attribute15 in varchar2 default hr_api.g_varchar2
367: ,p_attribute16 in varchar2 default hr_api.g_varchar2
368: ,p_attribute17 in varchar2 default hr_api.g_varchar2
369: ,p_attribute18 in varchar2 default hr_api.g_varchar2
370: ,p_attribute19 in varchar2 default hr_api.g_varchar2
371: ,p_attribute20 in varchar2 default hr_api.g_varchar2
372: ,p_object_version_number in out nocopy number
365: ,p_attribute14 in varchar2 default hr_api.g_varchar2
366: ,p_attribute15 in varchar2 default hr_api.g_varchar2
367: ,p_attribute16 in varchar2 default hr_api.g_varchar2
368: ,p_attribute17 in varchar2 default hr_api.g_varchar2
369: ,p_attribute18 in varchar2 default hr_api.g_varchar2
370: ,p_attribute19 in varchar2 default hr_api.g_varchar2
371: ,p_attribute20 in varchar2 default hr_api.g_varchar2
372: ,p_object_version_number in out nocopy number
373: ) IS
366: ,p_attribute15 in varchar2 default hr_api.g_varchar2
367: ,p_attribute16 in varchar2 default hr_api.g_varchar2
368: ,p_attribute17 in varchar2 default hr_api.g_varchar2
369: ,p_attribute18 in varchar2 default hr_api.g_varchar2
370: ,p_attribute19 in varchar2 default hr_api.g_varchar2
371: ,p_attribute20 in varchar2 default hr_api.g_varchar2
372: ,p_object_version_number in out nocopy number
373: ) IS
374: --
367: ,p_attribute16 in varchar2 default hr_api.g_varchar2
368: ,p_attribute17 in varchar2 default hr_api.g_varchar2
369: ,p_attribute18 in varchar2 default hr_api.g_varchar2
370: ,p_attribute19 in varchar2 default hr_api.g_varchar2
371: ,p_attribute20 in varchar2 default hr_api.g_varchar2
372: ,p_object_version_number in out nocopy number
373: ) IS
374: --
375: -- Declare cursors and local variables
420: ,p_attribute20 => p_attribute20
421: );
422:
423: exception
424: when hr_api.cannot_find_prog_unit then
425: hr_api.cannot_find_prog_unit_error
426: (p_module_name => 'update_position_structure'
427: ,p_hook_type => 'BP'
428: );
421: );
422:
423: exception
424: when hr_api.cannot_find_prog_unit then
425: hr_api.cannot_find_prog_unit_error
426: (p_module_name => 'update_position_structure'
427: ,p_hook_type => 'BP'
428: );
429: end;
445: ,p_position_structure_id => p_position_structure_id
446: ,p_object_version_number => l_object_version_number
447: ,p_name => p_name
448: ,p_comments => p_comments
449: ,p_business_group_id => hr_api.g_number
450: ,p_primary_position_flag => p_primary_position_flag
451: ,p_request_id => p_request_id
452: ,p_program_application_id => p_program_application_id
453: ,p_program_id => p_program_id
482: --
483: -- When in validation only mode raise the Validate_Enabled exception
484: --
485: IF p_validate THEN
486: RAISE hr_api.validate_enabled;
487: END IF;
488: --
489: -- Set all output arguments. If p_validate was TRUE, this bit is
490: -- never reached, so p_object_version_number is passed back unchanged.
530: ,p_attribute20 => p_attribute20
531: );
532:
533: exception
534: when hr_api.cannot_find_prog_unit then
535: hr_api.cannot_find_prog_unit_error
536: (p_module_name => 'update_position_structure'
537: ,p_hook_type => 'AP'
538: );
531: );
532:
533: exception
534: when hr_api.cannot_find_prog_unit then
535: hr_api.cannot_find_prog_unit_error
536: (p_module_name => 'update_position_structure'
537: ,p_hook_type => 'AP'
538: );
539: end;
539: end;
540:
541: EXCEPTION
542: --
543: WHEN hr_api.validate_enabled THEN
544: --
545: -- As the Validate_Enabled exception has been raised
546: -- we must rollback to the savepoint
547: --
592: ,p_object_version_number => p_object_version_number
593: );
594:
595: exception
596: when hr_api.cannot_find_prog_unit then
597: hr_api.cannot_find_prog_unit_error
598: (p_module_name => 'delete_position_structure'
599: ,p_hook_type => 'BP'
600: );
593: );
594:
595: exception
596: when hr_api.cannot_find_prog_unit then
597: hr_api.cannot_find_prog_unit_error
598: (p_module_name => 'delete_position_structure'
599: ,p_hook_type => 'BP'
600: );
601: end;
618: --
619: -- When in validation only mode raise the Validate_Enabled exception
620: --
621: IF p_validate THEN
622: RAISE hr_api.validate_enabled;
623: END IF;
624: --
625: --
626: begin
630: ,p_object_version_number => p_object_version_number
631: );
632:
633: exception
634: when hr_api.cannot_find_prog_unit then
635: hr_api.cannot_find_prog_unit_error
636: (p_module_name => 'delete_position_structure'
637: ,p_hook_type => 'AP'
638: );
631: );
632:
633: exception
634: when hr_api.cannot_find_prog_unit then
635: hr_api.cannot_find_prog_unit_error
636: (p_module_name => 'delete_position_structure'
637: ,p_hook_type => 'AP'
638: );
639: end;
640:
641:
642: EXCEPTION
643: --
644: WHEN hr_api.validate_enabled THEN
645: --
646: -- As the Validate_Enabled exception has been raised
647: -- we must rollback to the savepoint
648: --