DBA Data[Home] [Help]

APPS.HR_KI_TOPIC_INTEGRATIONS_API dependencies on HR_API

Line 89: when hr_api.cannot_find_prog_unit then

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

Line 90: hr_api.cannot_find_prog_unit_error

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;

Line 159: when hr_api.cannot_find_prog_unit then

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

Line 160: hr_api.cannot_find_prog_unit_error

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;

Line 169: raise hr_api.validate_enabled;

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

Line 180: when hr_api.validate_enabled then

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

Line 346: ,p_topic_id in number default hr_api.g_number

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

Line 347: ,p_integration_id in number default hr_api.g_number

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

Line 348: ,p_param_name1 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

Line 349: ,p_param_value1 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

Line 350: ,p_param_name2 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

Line 351: ,p_param_value2 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

Line 352: ,p_param_name3 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

Line 353: ,p_param_value3 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

Line 354: ,p_param_name4 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

Line 355: ,p_param_value4 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

Line 356: ,p_param_name5 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

Line 357: ,p_param_value5 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

Line 358: ,p_param_name6 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

Line 359: ,p_param_value6 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

Line 360: ,p_param_name7 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

Line 361: ,p_param_value7 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

Line 362: ,p_param_name8 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

Line 363: ,p_param_value8 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

Line 364: ,p_param_name9 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

Line 365: ,p_param_value9 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
369: ) is

Line 366: ,p_param_name10 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
370: --

Line 367: ,p_param_value10 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: --
371: -- Declare cursors and local variables

Line 419: when hr_api.cannot_find_prog_unit then

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

Line 420: hr_api.cannot_find_prog_unit_error

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;

Line 489: when hr_api.cannot_find_prog_unit then

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

Line 490: hr_api.cannot_find_prog_unit_error

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;

Line 499: raise hr_api.validate_enabled;

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

Line 510: when hr_api.validate_enabled then

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

Line 549: ,p_topic_key in varchar2 default hr_api.g_varchar2

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

Line 550: ,p_integration_key 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

Line 551: ,p_param_name1 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

Line 552: ,p_param_value1 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

Line 553: ,p_param_name2 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

Line 554: ,p_param_value2 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

Line 555: ,p_param_name3 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

Line 556: ,p_param_value3 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

Line 557: ,p_param_name4 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

Line 558: ,p_param_value4 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

Line 559: ,p_param_name5 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

Line 560: ,p_param_value5 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

Line 561: ,p_param_name6 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

Line 562: ,p_param_value6 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

Line 563: ,p_param_name7 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

Line 564: ,p_param_value7 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

Line 565: ,p_param_name8 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

Line 566: ,p_param_value8 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

Line 567: ,p_param_name9 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

Line 568: ,p_param_value9 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
572: ) is

Line 569: ,p_param_name10 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
573: --

Line 570: ,p_param_value10 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: --
574: -- Declare cursors and local variables

Line 701: when hr_api.cannot_find_prog_unit then

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

Line 702: hr_api.cannot_find_prog_unit_error

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;

Line 729: when hr_api.cannot_find_prog_unit then

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

Line 730: hr_api.cannot_find_prog_unit_error

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;

Line 739: raise hr_api.validate_enabled;

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

Line 748: when hr_api.validate_enabled then

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