85: ,p_param_value10 => p_param_value10
86: );
87:
88: exception
89: when hr_api.cannot_find_prog_unit then
90: hr_api.cannot_find_prog_unit_error
91: (p_module_name => 'create_topic_integration'
92: ,p_hook_type => 'BP'
93: );
86: );
87:
88: exception
89: when hr_api.cannot_find_prog_unit then
90: hr_api.cannot_find_prog_unit_error
91: (p_module_name => 'create_topic_integration'
92: ,p_hook_type => 'BP'
93: );
94: end;
155: ,p_topic_integrations_id => l_topic_integrations_id
156: ,p_object_version_number => l_object_version_number
157: );
158: exception
159: when hr_api.cannot_find_prog_unit then
160: hr_api.cannot_find_prog_unit_error
161: (p_module_name => 'create_topic_integration'
162: ,p_hook_type => 'AP'
163: );
156: ,p_object_version_number => l_object_version_number
157: );
158: exception
159: when hr_api.cannot_find_prog_unit then
160: hr_api.cannot_find_prog_unit_error
161: (p_module_name => 'create_topic_integration'
162: ,p_hook_type => 'AP'
163: );
164: end;
165: --
166: -- When in validation only mode raise the Validate_Enabled exception
167: --
168: if p_validate then
169: raise hr_api.validate_enabled;
170: end if;
171: --
172: -- Set all IN OUT and OUT parameters with out values
173: --
176:
177: --
178: hr_utility.set_location(' Leaving:'||l_proc, 70);
179: exception
180: when hr_api.validate_enabled then
181: --
182: -- As the Validate_Enabled exception has been raised
183: -- we must rollback to the savepoint
184: --
342: procedure update_topic_integration
343: (
344: p_validate in boolean default false
345: ,p_topic_integrations_id in number
346: ,p_topic_id in number default hr_api.g_number
347: ,p_integration_id in number default hr_api.g_number
348: ,p_param_name1 in varchar2 default hr_api.g_varchar2
349: ,p_param_value1 in varchar2 default hr_api.g_varchar2
350: ,p_param_name2 in varchar2 default hr_api.g_varchar2
343: (
344: p_validate in boolean default false
345: ,p_topic_integrations_id in number
346: ,p_topic_id in number default hr_api.g_number
347: ,p_integration_id in number default hr_api.g_number
348: ,p_param_name1 in varchar2 default hr_api.g_varchar2
349: ,p_param_value1 in varchar2 default hr_api.g_varchar2
350: ,p_param_name2 in varchar2 default hr_api.g_varchar2
351: ,p_param_value2 in varchar2 default hr_api.g_varchar2
344: p_validate in boolean default false
345: ,p_topic_integrations_id in number
346: ,p_topic_id in number default hr_api.g_number
347: ,p_integration_id in number default hr_api.g_number
348: ,p_param_name1 in varchar2 default hr_api.g_varchar2
349: ,p_param_value1 in varchar2 default hr_api.g_varchar2
350: ,p_param_name2 in varchar2 default hr_api.g_varchar2
351: ,p_param_value2 in varchar2 default hr_api.g_varchar2
352: ,p_param_name3 in varchar2 default hr_api.g_varchar2
345: ,p_topic_integrations_id in number
346: ,p_topic_id in number default hr_api.g_number
347: ,p_integration_id in number default hr_api.g_number
348: ,p_param_name1 in varchar2 default hr_api.g_varchar2
349: ,p_param_value1 in varchar2 default hr_api.g_varchar2
350: ,p_param_name2 in varchar2 default hr_api.g_varchar2
351: ,p_param_value2 in varchar2 default hr_api.g_varchar2
352: ,p_param_name3 in varchar2 default hr_api.g_varchar2
353: ,p_param_value3 in varchar2 default hr_api.g_varchar2
346: ,p_topic_id in number default hr_api.g_number
347: ,p_integration_id in number default hr_api.g_number
348: ,p_param_name1 in varchar2 default hr_api.g_varchar2
349: ,p_param_value1 in varchar2 default hr_api.g_varchar2
350: ,p_param_name2 in varchar2 default hr_api.g_varchar2
351: ,p_param_value2 in varchar2 default hr_api.g_varchar2
352: ,p_param_name3 in varchar2 default hr_api.g_varchar2
353: ,p_param_value3 in varchar2 default hr_api.g_varchar2
354: ,p_param_name4 in varchar2 default hr_api.g_varchar2
347: ,p_integration_id in number default hr_api.g_number
348: ,p_param_name1 in varchar2 default hr_api.g_varchar2
349: ,p_param_value1 in varchar2 default hr_api.g_varchar2
350: ,p_param_name2 in varchar2 default hr_api.g_varchar2
351: ,p_param_value2 in varchar2 default hr_api.g_varchar2
352: ,p_param_name3 in varchar2 default hr_api.g_varchar2
353: ,p_param_value3 in varchar2 default hr_api.g_varchar2
354: ,p_param_name4 in varchar2 default hr_api.g_varchar2
355: ,p_param_value4 in varchar2 default hr_api.g_varchar2
348: ,p_param_name1 in varchar2 default hr_api.g_varchar2
349: ,p_param_value1 in varchar2 default hr_api.g_varchar2
350: ,p_param_name2 in varchar2 default hr_api.g_varchar2
351: ,p_param_value2 in varchar2 default hr_api.g_varchar2
352: ,p_param_name3 in varchar2 default hr_api.g_varchar2
353: ,p_param_value3 in varchar2 default hr_api.g_varchar2
354: ,p_param_name4 in varchar2 default hr_api.g_varchar2
355: ,p_param_value4 in varchar2 default hr_api.g_varchar2
356: ,p_param_name5 in varchar2 default hr_api.g_varchar2
349: ,p_param_value1 in varchar2 default hr_api.g_varchar2
350: ,p_param_name2 in varchar2 default hr_api.g_varchar2
351: ,p_param_value2 in varchar2 default hr_api.g_varchar2
352: ,p_param_name3 in varchar2 default hr_api.g_varchar2
353: ,p_param_value3 in varchar2 default hr_api.g_varchar2
354: ,p_param_name4 in varchar2 default hr_api.g_varchar2
355: ,p_param_value4 in varchar2 default hr_api.g_varchar2
356: ,p_param_name5 in varchar2 default hr_api.g_varchar2
357: ,p_param_value5 in varchar2 default hr_api.g_varchar2
350: ,p_param_name2 in varchar2 default hr_api.g_varchar2
351: ,p_param_value2 in varchar2 default hr_api.g_varchar2
352: ,p_param_name3 in varchar2 default hr_api.g_varchar2
353: ,p_param_value3 in varchar2 default hr_api.g_varchar2
354: ,p_param_name4 in varchar2 default hr_api.g_varchar2
355: ,p_param_value4 in varchar2 default hr_api.g_varchar2
356: ,p_param_name5 in varchar2 default hr_api.g_varchar2
357: ,p_param_value5 in varchar2 default hr_api.g_varchar2
358: ,p_param_name6 in varchar2 default hr_api.g_varchar2
351: ,p_param_value2 in varchar2 default hr_api.g_varchar2
352: ,p_param_name3 in varchar2 default hr_api.g_varchar2
353: ,p_param_value3 in varchar2 default hr_api.g_varchar2
354: ,p_param_name4 in varchar2 default hr_api.g_varchar2
355: ,p_param_value4 in varchar2 default hr_api.g_varchar2
356: ,p_param_name5 in varchar2 default hr_api.g_varchar2
357: ,p_param_value5 in varchar2 default hr_api.g_varchar2
358: ,p_param_name6 in varchar2 default hr_api.g_varchar2
359: ,p_param_value6 in varchar2 default hr_api.g_varchar2
352: ,p_param_name3 in varchar2 default hr_api.g_varchar2
353: ,p_param_value3 in varchar2 default hr_api.g_varchar2
354: ,p_param_name4 in varchar2 default hr_api.g_varchar2
355: ,p_param_value4 in varchar2 default hr_api.g_varchar2
356: ,p_param_name5 in varchar2 default hr_api.g_varchar2
357: ,p_param_value5 in varchar2 default hr_api.g_varchar2
358: ,p_param_name6 in varchar2 default hr_api.g_varchar2
359: ,p_param_value6 in varchar2 default hr_api.g_varchar2
360: ,p_param_name7 in varchar2 default hr_api.g_varchar2
353: ,p_param_value3 in varchar2 default hr_api.g_varchar2
354: ,p_param_name4 in varchar2 default hr_api.g_varchar2
355: ,p_param_value4 in varchar2 default hr_api.g_varchar2
356: ,p_param_name5 in varchar2 default hr_api.g_varchar2
357: ,p_param_value5 in varchar2 default hr_api.g_varchar2
358: ,p_param_name6 in varchar2 default hr_api.g_varchar2
359: ,p_param_value6 in varchar2 default hr_api.g_varchar2
360: ,p_param_name7 in varchar2 default hr_api.g_varchar2
361: ,p_param_value7 in varchar2 default hr_api.g_varchar2
354: ,p_param_name4 in varchar2 default hr_api.g_varchar2
355: ,p_param_value4 in varchar2 default hr_api.g_varchar2
356: ,p_param_name5 in varchar2 default hr_api.g_varchar2
357: ,p_param_value5 in varchar2 default hr_api.g_varchar2
358: ,p_param_name6 in varchar2 default hr_api.g_varchar2
359: ,p_param_value6 in varchar2 default hr_api.g_varchar2
360: ,p_param_name7 in varchar2 default hr_api.g_varchar2
361: ,p_param_value7 in varchar2 default hr_api.g_varchar2
362: ,p_param_name8 in varchar2 default hr_api.g_varchar2
355: ,p_param_value4 in varchar2 default hr_api.g_varchar2
356: ,p_param_name5 in varchar2 default hr_api.g_varchar2
357: ,p_param_value5 in varchar2 default hr_api.g_varchar2
358: ,p_param_name6 in varchar2 default hr_api.g_varchar2
359: ,p_param_value6 in varchar2 default hr_api.g_varchar2
360: ,p_param_name7 in varchar2 default hr_api.g_varchar2
361: ,p_param_value7 in varchar2 default hr_api.g_varchar2
362: ,p_param_name8 in varchar2 default hr_api.g_varchar2
363: ,p_param_value8 in varchar2 default hr_api.g_varchar2
356: ,p_param_name5 in varchar2 default hr_api.g_varchar2
357: ,p_param_value5 in varchar2 default hr_api.g_varchar2
358: ,p_param_name6 in varchar2 default hr_api.g_varchar2
359: ,p_param_value6 in varchar2 default hr_api.g_varchar2
360: ,p_param_name7 in varchar2 default hr_api.g_varchar2
361: ,p_param_value7 in varchar2 default hr_api.g_varchar2
362: ,p_param_name8 in varchar2 default hr_api.g_varchar2
363: ,p_param_value8 in varchar2 default hr_api.g_varchar2
364: ,p_param_name9 in varchar2 default hr_api.g_varchar2
357: ,p_param_value5 in varchar2 default hr_api.g_varchar2
358: ,p_param_name6 in varchar2 default hr_api.g_varchar2
359: ,p_param_value6 in varchar2 default hr_api.g_varchar2
360: ,p_param_name7 in varchar2 default hr_api.g_varchar2
361: ,p_param_value7 in varchar2 default hr_api.g_varchar2
362: ,p_param_name8 in varchar2 default hr_api.g_varchar2
363: ,p_param_value8 in varchar2 default hr_api.g_varchar2
364: ,p_param_name9 in varchar2 default hr_api.g_varchar2
365: ,p_param_value9 in varchar2 default hr_api.g_varchar2
358: ,p_param_name6 in varchar2 default hr_api.g_varchar2
359: ,p_param_value6 in varchar2 default hr_api.g_varchar2
360: ,p_param_name7 in varchar2 default hr_api.g_varchar2
361: ,p_param_value7 in varchar2 default hr_api.g_varchar2
362: ,p_param_name8 in varchar2 default hr_api.g_varchar2
363: ,p_param_value8 in varchar2 default hr_api.g_varchar2
364: ,p_param_name9 in varchar2 default hr_api.g_varchar2
365: ,p_param_value9 in varchar2 default hr_api.g_varchar2
366: ,p_param_name10 in varchar2 default hr_api.g_varchar2
359: ,p_param_value6 in varchar2 default hr_api.g_varchar2
360: ,p_param_name7 in varchar2 default hr_api.g_varchar2
361: ,p_param_value7 in varchar2 default hr_api.g_varchar2
362: ,p_param_name8 in varchar2 default hr_api.g_varchar2
363: ,p_param_value8 in varchar2 default hr_api.g_varchar2
364: ,p_param_name9 in varchar2 default hr_api.g_varchar2
365: ,p_param_value9 in varchar2 default hr_api.g_varchar2
366: ,p_param_name10 in varchar2 default hr_api.g_varchar2
367: ,p_param_value10 in varchar2 default hr_api.g_varchar2
360: ,p_param_name7 in varchar2 default hr_api.g_varchar2
361: ,p_param_value7 in varchar2 default hr_api.g_varchar2
362: ,p_param_name8 in varchar2 default hr_api.g_varchar2
363: ,p_param_value8 in varchar2 default hr_api.g_varchar2
364: ,p_param_name9 in varchar2 default hr_api.g_varchar2
365: ,p_param_value9 in varchar2 default hr_api.g_varchar2
366: ,p_param_name10 in varchar2 default hr_api.g_varchar2
367: ,p_param_value10 in varchar2 default hr_api.g_varchar2
368: ,p_object_version_number in out nocopy number
361: ,p_param_value7 in varchar2 default hr_api.g_varchar2
362: ,p_param_name8 in varchar2 default hr_api.g_varchar2
363: ,p_param_value8 in varchar2 default hr_api.g_varchar2
364: ,p_param_name9 in varchar2 default hr_api.g_varchar2
365: ,p_param_value9 in varchar2 default hr_api.g_varchar2
366: ,p_param_name10 in varchar2 default hr_api.g_varchar2
367: ,p_param_value10 in varchar2 default hr_api.g_varchar2
368: ,p_object_version_number in out nocopy number
369: ) is
362: ,p_param_name8 in varchar2 default hr_api.g_varchar2
363: ,p_param_value8 in varchar2 default hr_api.g_varchar2
364: ,p_param_name9 in varchar2 default hr_api.g_varchar2
365: ,p_param_value9 in varchar2 default hr_api.g_varchar2
366: ,p_param_name10 in varchar2 default hr_api.g_varchar2
367: ,p_param_value10 in varchar2 default hr_api.g_varchar2
368: ,p_object_version_number in out nocopy number
369: ) is
370: --
363: ,p_param_value8 in varchar2 default hr_api.g_varchar2
364: ,p_param_name9 in varchar2 default hr_api.g_varchar2
365: ,p_param_value9 in varchar2 default hr_api.g_varchar2
366: ,p_param_name10 in varchar2 default hr_api.g_varchar2
367: ,p_param_value10 in varchar2 default hr_api.g_varchar2
368: ,p_object_version_number in out nocopy number
369: ) is
370: --
371: -- Declare cursors and local variables
415: ,p_topic_integrations_id => p_topic_integrations_id
416: ,p_object_version_number => p_object_version_number
417: );
418: exception
419: when hr_api.cannot_find_prog_unit then
420: hr_api.cannot_find_prog_unit_error
421: (p_module_name => 'update_topic_integration'
422: ,p_hook_type => 'BP'
423: );
416: ,p_object_version_number => p_object_version_number
417: );
418: exception
419: when hr_api.cannot_find_prog_unit then
420: hr_api.cannot_find_prog_unit_error
421: (p_module_name => 'update_topic_integration'
422: ,p_hook_type => 'BP'
423: );
424: end;
485: ,p_topic_integrations_id => p_topic_integrations_id
486: ,p_object_version_number => p_object_version_number
487: );
488: exception
489: when hr_api.cannot_find_prog_unit then
490: hr_api.cannot_find_prog_unit_error
491: (p_module_name => 'update_topic_integration'
492: ,p_hook_type => 'AP'
493: );
486: ,p_object_version_number => p_object_version_number
487: );
488: exception
489: when hr_api.cannot_find_prog_unit then
490: hr_api.cannot_find_prog_unit_error
491: (p_module_name => 'update_topic_integration'
492: ,p_hook_type => 'AP'
493: );
494: end;
495: --
496: -- When in validation only mode raise the Validate_Enabled exception
497: --
498: if p_validate then
499: raise hr_api.validate_enabled;
500: end if;
501: --
502: -- Set all IN OUT and OUT parameters with out values
503: --
506:
507: --
508: hr_utility.set_location(' Leaving:'||l_proc, 70);
509: exception
510: when hr_api.validate_enabled then
511: --
512: -- As the Validate_Enabled exception has been raised
513: -- we must rollback to the savepoint
514: --
545: procedure update_topic_integration_key
546: (
547: p_validate in boolean default false
548: ,p_topic_integrations_id in number
549: ,p_topic_key in varchar2 default hr_api.g_varchar2
550: ,p_integration_key in varchar2 default hr_api.g_varchar2
551: ,p_param_name1 in varchar2 default hr_api.g_varchar2
552: ,p_param_value1 in varchar2 default hr_api.g_varchar2
553: ,p_param_name2 in varchar2 default hr_api.g_varchar2
546: (
547: p_validate in boolean default false
548: ,p_topic_integrations_id in number
549: ,p_topic_key in varchar2 default hr_api.g_varchar2
550: ,p_integration_key in varchar2 default hr_api.g_varchar2
551: ,p_param_name1 in varchar2 default hr_api.g_varchar2
552: ,p_param_value1 in varchar2 default hr_api.g_varchar2
553: ,p_param_name2 in varchar2 default hr_api.g_varchar2
554: ,p_param_value2 in varchar2 default hr_api.g_varchar2
547: p_validate in boolean default false
548: ,p_topic_integrations_id in number
549: ,p_topic_key in varchar2 default hr_api.g_varchar2
550: ,p_integration_key in varchar2 default hr_api.g_varchar2
551: ,p_param_name1 in varchar2 default hr_api.g_varchar2
552: ,p_param_value1 in varchar2 default hr_api.g_varchar2
553: ,p_param_name2 in varchar2 default hr_api.g_varchar2
554: ,p_param_value2 in varchar2 default hr_api.g_varchar2
555: ,p_param_name3 in varchar2 default hr_api.g_varchar2
548: ,p_topic_integrations_id in number
549: ,p_topic_key in varchar2 default hr_api.g_varchar2
550: ,p_integration_key in varchar2 default hr_api.g_varchar2
551: ,p_param_name1 in varchar2 default hr_api.g_varchar2
552: ,p_param_value1 in varchar2 default hr_api.g_varchar2
553: ,p_param_name2 in varchar2 default hr_api.g_varchar2
554: ,p_param_value2 in varchar2 default hr_api.g_varchar2
555: ,p_param_name3 in varchar2 default hr_api.g_varchar2
556: ,p_param_value3 in varchar2 default hr_api.g_varchar2
549: ,p_topic_key in varchar2 default hr_api.g_varchar2
550: ,p_integration_key in varchar2 default hr_api.g_varchar2
551: ,p_param_name1 in varchar2 default hr_api.g_varchar2
552: ,p_param_value1 in varchar2 default hr_api.g_varchar2
553: ,p_param_name2 in varchar2 default hr_api.g_varchar2
554: ,p_param_value2 in varchar2 default hr_api.g_varchar2
555: ,p_param_name3 in varchar2 default hr_api.g_varchar2
556: ,p_param_value3 in varchar2 default hr_api.g_varchar2
557: ,p_param_name4 in varchar2 default hr_api.g_varchar2
550: ,p_integration_key in varchar2 default hr_api.g_varchar2
551: ,p_param_name1 in varchar2 default hr_api.g_varchar2
552: ,p_param_value1 in varchar2 default hr_api.g_varchar2
553: ,p_param_name2 in varchar2 default hr_api.g_varchar2
554: ,p_param_value2 in varchar2 default hr_api.g_varchar2
555: ,p_param_name3 in varchar2 default hr_api.g_varchar2
556: ,p_param_value3 in varchar2 default hr_api.g_varchar2
557: ,p_param_name4 in varchar2 default hr_api.g_varchar2
558: ,p_param_value4 in varchar2 default hr_api.g_varchar2
551: ,p_param_name1 in varchar2 default hr_api.g_varchar2
552: ,p_param_value1 in varchar2 default hr_api.g_varchar2
553: ,p_param_name2 in varchar2 default hr_api.g_varchar2
554: ,p_param_value2 in varchar2 default hr_api.g_varchar2
555: ,p_param_name3 in varchar2 default hr_api.g_varchar2
556: ,p_param_value3 in varchar2 default hr_api.g_varchar2
557: ,p_param_name4 in varchar2 default hr_api.g_varchar2
558: ,p_param_value4 in varchar2 default hr_api.g_varchar2
559: ,p_param_name5 in varchar2 default hr_api.g_varchar2
552: ,p_param_value1 in varchar2 default hr_api.g_varchar2
553: ,p_param_name2 in varchar2 default hr_api.g_varchar2
554: ,p_param_value2 in varchar2 default hr_api.g_varchar2
555: ,p_param_name3 in varchar2 default hr_api.g_varchar2
556: ,p_param_value3 in varchar2 default hr_api.g_varchar2
557: ,p_param_name4 in varchar2 default hr_api.g_varchar2
558: ,p_param_value4 in varchar2 default hr_api.g_varchar2
559: ,p_param_name5 in varchar2 default hr_api.g_varchar2
560: ,p_param_value5 in varchar2 default hr_api.g_varchar2
553: ,p_param_name2 in varchar2 default hr_api.g_varchar2
554: ,p_param_value2 in varchar2 default hr_api.g_varchar2
555: ,p_param_name3 in varchar2 default hr_api.g_varchar2
556: ,p_param_value3 in varchar2 default hr_api.g_varchar2
557: ,p_param_name4 in varchar2 default hr_api.g_varchar2
558: ,p_param_value4 in varchar2 default hr_api.g_varchar2
559: ,p_param_name5 in varchar2 default hr_api.g_varchar2
560: ,p_param_value5 in varchar2 default hr_api.g_varchar2
561: ,p_param_name6 in varchar2 default hr_api.g_varchar2
554: ,p_param_value2 in varchar2 default hr_api.g_varchar2
555: ,p_param_name3 in varchar2 default hr_api.g_varchar2
556: ,p_param_value3 in varchar2 default hr_api.g_varchar2
557: ,p_param_name4 in varchar2 default hr_api.g_varchar2
558: ,p_param_value4 in varchar2 default hr_api.g_varchar2
559: ,p_param_name5 in varchar2 default hr_api.g_varchar2
560: ,p_param_value5 in varchar2 default hr_api.g_varchar2
561: ,p_param_name6 in varchar2 default hr_api.g_varchar2
562: ,p_param_value6 in varchar2 default hr_api.g_varchar2
555: ,p_param_name3 in varchar2 default hr_api.g_varchar2
556: ,p_param_value3 in varchar2 default hr_api.g_varchar2
557: ,p_param_name4 in varchar2 default hr_api.g_varchar2
558: ,p_param_value4 in varchar2 default hr_api.g_varchar2
559: ,p_param_name5 in varchar2 default hr_api.g_varchar2
560: ,p_param_value5 in varchar2 default hr_api.g_varchar2
561: ,p_param_name6 in varchar2 default hr_api.g_varchar2
562: ,p_param_value6 in varchar2 default hr_api.g_varchar2
563: ,p_param_name7 in varchar2 default hr_api.g_varchar2
556: ,p_param_value3 in varchar2 default hr_api.g_varchar2
557: ,p_param_name4 in varchar2 default hr_api.g_varchar2
558: ,p_param_value4 in varchar2 default hr_api.g_varchar2
559: ,p_param_name5 in varchar2 default hr_api.g_varchar2
560: ,p_param_value5 in varchar2 default hr_api.g_varchar2
561: ,p_param_name6 in varchar2 default hr_api.g_varchar2
562: ,p_param_value6 in varchar2 default hr_api.g_varchar2
563: ,p_param_name7 in varchar2 default hr_api.g_varchar2
564: ,p_param_value7 in varchar2 default hr_api.g_varchar2
557: ,p_param_name4 in varchar2 default hr_api.g_varchar2
558: ,p_param_value4 in varchar2 default hr_api.g_varchar2
559: ,p_param_name5 in varchar2 default hr_api.g_varchar2
560: ,p_param_value5 in varchar2 default hr_api.g_varchar2
561: ,p_param_name6 in varchar2 default hr_api.g_varchar2
562: ,p_param_value6 in varchar2 default hr_api.g_varchar2
563: ,p_param_name7 in varchar2 default hr_api.g_varchar2
564: ,p_param_value7 in varchar2 default hr_api.g_varchar2
565: ,p_param_name8 in varchar2 default hr_api.g_varchar2
558: ,p_param_value4 in varchar2 default hr_api.g_varchar2
559: ,p_param_name5 in varchar2 default hr_api.g_varchar2
560: ,p_param_value5 in varchar2 default hr_api.g_varchar2
561: ,p_param_name6 in varchar2 default hr_api.g_varchar2
562: ,p_param_value6 in varchar2 default hr_api.g_varchar2
563: ,p_param_name7 in varchar2 default hr_api.g_varchar2
564: ,p_param_value7 in varchar2 default hr_api.g_varchar2
565: ,p_param_name8 in varchar2 default hr_api.g_varchar2
566: ,p_param_value8 in varchar2 default hr_api.g_varchar2
559: ,p_param_name5 in varchar2 default hr_api.g_varchar2
560: ,p_param_value5 in varchar2 default hr_api.g_varchar2
561: ,p_param_name6 in varchar2 default hr_api.g_varchar2
562: ,p_param_value6 in varchar2 default hr_api.g_varchar2
563: ,p_param_name7 in varchar2 default hr_api.g_varchar2
564: ,p_param_value7 in varchar2 default hr_api.g_varchar2
565: ,p_param_name8 in varchar2 default hr_api.g_varchar2
566: ,p_param_value8 in varchar2 default hr_api.g_varchar2
567: ,p_param_name9 in varchar2 default hr_api.g_varchar2
560: ,p_param_value5 in varchar2 default hr_api.g_varchar2
561: ,p_param_name6 in varchar2 default hr_api.g_varchar2
562: ,p_param_value6 in varchar2 default hr_api.g_varchar2
563: ,p_param_name7 in varchar2 default hr_api.g_varchar2
564: ,p_param_value7 in varchar2 default hr_api.g_varchar2
565: ,p_param_name8 in varchar2 default hr_api.g_varchar2
566: ,p_param_value8 in varchar2 default hr_api.g_varchar2
567: ,p_param_name9 in varchar2 default hr_api.g_varchar2
568: ,p_param_value9 in varchar2 default hr_api.g_varchar2
561: ,p_param_name6 in varchar2 default hr_api.g_varchar2
562: ,p_param_value6 in varchar2 default hr_api.g_varchar2
563: ,p_param_name7 in varchar2 default hr_api.g_varchar2
564: ,p_param_value7 in varchar2 default hr_api.g_varchar2
565: ,p_param_name8 in varchar2 default hr_api.g_varchar2
566: ,p_param_value8 in varchar2 default hr_api.g_varchar2
567: ,p_param_name9 in varchar2 default hr_api.g_varchar2
568: ,p_param_value9 in varchar2 default hr_api.g_varchar2
569: ,p_param_name10 in varchar2 default hr_api.g_varchar2
562: ,p_param_value6 in varchar2 default hr_api.g_varchar2
563: ,p_param_name7 in varchar2 default hr_api.g_varchar2
564: ,p_param_value7 in varchar2 default hr_api.g_varchar2
565: ,p_param_name8 in varchar2 default hr_api.g_varchar2
566: ,p_param_value8 in varchar2 default hr_api.g_varchar2
567: ,p_param_name9 in varchar2 default hr_api.g_varchar2
568: ,p_param_value9 in varchar2 default hr_api.g_varchar2
569: ,p_param_name10 in varchar2 default hr_api.g_varchar2
570: ,p_param_value10 in varchar2 default hr_api.g_varchar2
563: ,p_param_name7 in varchar2 default hr_api.g_varchar2
564: ,p_param_value7 in varchar2 default hr_api.g_varchar2
565: ,p_param_name8 in varchar2 default hr_api.g_varchar2
566: ,p_param_value8 in varchar2 default hr_api.g_varchar2
567: ,p_param_name9 in varchar2 default hr_api.g_varchar2
568: ,p_param_value9 in varchar2 default hr_api.g_varchar2
569: ,p_param_name10 in varchar2 default hr_api.g_varchar2
570: ,p_param_value10 in varchar2 default hr_api.g_varchar2
571: ,p_object_version_number in out nocopy number
564: ,p_param_value7 in varchar2 default hr_api.g_varchar2
565: ,p_param_name8 in varchar2 default hr_api.g_varchar2
566: ,p_param_value8 in varchar2 default hr_api.g_varchar2
567: ,p_param_name9 in varchar2 default hr_api.g_varchar2
568: ,p_param_value9 in varchar2 default hr_api.g_varchar2
569: ,p_param_name10 in varchar2 default hr_api.g_varchar2
570: ,p_param_value10 in varchar2 default hr_api.g_varchar2
571: ,p_object_version_number in out nocopy number
572: ) is
565: ,p_param_name8 in varchar2 default hr_api.g_varchar2
566: ,p_param_value8 in varchar2 default hr_api.g_varchar2
567: ,p_param_name9 in varchar2 default hr_api.g_varchar2
568: ,p_param_value9 in varchar2 default hr_api.g_varchar2
569: ,p_param_name10 in varchar2 default hr_api.g_varchar2
570: ,p_param_value10 in varchar2 default hr_api.g_varchar2
571: ,p_object_version_number in out nocopy number
572: ) is
573: --
566: ,p_param_value8 in varchar2 default hr_api.g_varchar2
567: ,p_param_name9 in varchar2 default hr_api.g_varchar2
568: ,p_param_value9 in varchar2 default hr_api.g_varchar2
569: ,p_param_name10 in varchar2 default hr_api.g_varchar2
570: ,p_param_value10 in varchar2 default hr_api.g_varchar2
571: ,p_object_version_number in out nocopy number
572: ) is
573: --
574: -- Declare cursors and local variables
697: ,p_object_version_number => p_object_version_number
698:
699: );
700: exception
701: when hr_api.cannot_find_prog_unit then
702: hr_api.cannot_find_prog_unit_error
703: (p_module_name => 'delete_topic_integration'
704: ,p_hook_type => 'BP'
705: );
698:
699: );
700: exception
701: when hr_api.cannot_find_prog_unit then
702: hr_api.cannot_find_prog_unit_error
703: (p_module_name => 'delete_topic_integration'
704: ,p_hook_type => 'BP'
705: );
706: end;
725: p_topic_integrations_id => p_topic_integrations_id
726: ,p_object_version_number => p_object_version_number
727: );
728: exception
729: when hr_api.cannot_find_prog_unit then
730: hr_api.cannot_find_prog_unit_error
731: (p_module_name => 'delete_topic_integration'
732: ,p_hook_type => 'AP'
733: );
726: ,p_object_version_number => p_object_version_number
727: );
728: exception
729: when hr_api.cannot_find_prog_unit then
730: hr_api.cannot_find_prog_unit_error
731: (p_module_name => 'delete_topic_integration'
732: ,p_hook_type => 'AP'
733: );
734: end;
735: --
736: -- When in validation only mode raise the Validate_Enabled exception
737: --
738: if p_validate then
739: raise hr_api.validate_enabled;
740: end if;
741: --
742: -- Set all IN OUT and OUT parameters with out values
743: --
744:
745: --
746: hr_utility.set_location(' Leaving:'||l_proc, 70);
747: exception
748: when hr_api.validate_enabled then
749: --
750: -- As the Validate_Enabled exception has been raised
751: -- we must rollback to the savepoint
752: --