DBA Data[Home] [Help]

APPS.PQH_PTX_EXTRA_INFO_API dependencies on HR_API

Line 154: when hr_api.cannot_find_prog_unit then

150: ,p_attribute19 => p_attribute19
151: ,p_attribute20 => p_attribute20
152: );
153: exception
154: when hr_api.cannot_find_prog_unit then
155: hr_api.cannot_find_prog_unit_error
156: (
157: p_module_name => 'CREATE_PTX_EXTRA_INFO'
158: ,p_hook_type => 'BP'

Line 155: hr_api.cannot_find_prog_unit_error

151: ,p_attribute20 => p_attribute20
152: );
153: exception
154: when hr_api.cannot_find_prog_unit then
155: hr_api.cannot_find_prog_unit_error
156: (
157: p_module_name => 'CREATE_PTX_EXTRA_INFO'
158: ,p_hook_type => 'BP'
159: );

Line 291: when hr_api.cannot_find_prog_unit then

287: ,p_attribute20 => p_attribute20
288: ,p_object_version_number => l_object_version_number
289: );
290: exception
291: when hr_api.cannot_find_prog_unit then
292: hr_api.cannot_find_prog_unit_error
293: (p_module_name => 'CREATE_PTX_EXTRA_INFO'
294: ,p_hook_type => 'AP'
295: );

Line 292: hr_api.cannot_find_prog_unit_error

288: ,p_object_version_number => l_object_version_number
289: );
290: exception
291: when hr_api.cannot_find_prog_unit then
292: hr_api.cannot_find_prog_unit_error
293: (p_module_name => 'CREATE_PTX_EXTRA_INFO'
294: ,p_hook_type => 'AP'
295: );
296: --

Line 306: raise hr_api.validate_enabled;

302: --
303: -- When in validation only mode raise the Validate_Enabled exception
304: --
305: if p_validate then
306: raise hr_api.validate_enabled;
307: end if;
308: --
309: -- Set all output arguments
310: --

Line 318: when hr_api.validate_enabled then

314: hr_utility.set_location(' Leaving:'||l_proc, 70);
315: --
316: exception
317: --
318: when hr_api.validate_enabled then
319: --
320: -- As the Validate_Enabled exception has been raised
321: -- we must rollback to the savepoint
322: --

Line 350: ,p_information_type in varchar2 default hr_api.g_varchar2

346: --
347: procedure update_ptx_extra_info
348: (p_validate in boolean default false
349: ,p_ptx_extra_info_id in number
350: ,p_information_type in varchar2 default hr_api.g_varchar2
351: ,p_position_transaction_id in number default hr_api.g_number
352: ,p_position_extra_info_id in number default hr_api.g_number
353: ,p_information_category in varchar2 default hr_api.g_varchar2
354: ,p_information1 in varchar2 default hr_api.g_varchar2

Line 351: ,p_position_transaction_id in number default hr_api.g_number

347: procedure update_ptx_extra_info
348: (p_validate in boolean default false
349: ,p_ptx_extra_info_id in number
350: ,p_information_type in varchar2 default hr_api.g_varchar2
351: ,p_position_transaction_id in number default hr_api.g_number
352: ,p_position_extra_info_id in number default hr_api.g_number
353: ,p_information_category in varchar2 default hr_api.g_varchar2
354: ,p_information1 in varchar2 default hr_api.g_varchar2
355: ,p_information2 in varchar2 default hr_api.g_varchar2

Line 352: ,p_position_extra_info_id in number default hr_api.g_number

348: (p_validate in boolean default false
349: ,p_ptx_extra_info_id in number
350: ,p_information_type in varchar2 default hr_api.g_varchar2
351: ,p_position_transaction_id in number default hr_api.g_number
352: ,p_position_extra_info_id in number default hr_api.g_number
353: ,p_information_category in varchar2 default hr_api.g_varchar2
354: ,p_information1 in varchar2 default hr_api.g_varchar2
355: ,p_information2 in varchar2 default hr_api.g_varchar2
356: ,p_information3 in varchar2 default hr_api.g_varchar2

Line 353: ,p_information_category in varchar2 default hr_api.g_varchar2

349: ,p_ptx_extra_info_id in number
350: ,p_information_type in varchar2 default hr_api.g_varchar2
351: ,p_position_transaction_id in number default hr_api.g_number
352: ,p_position_extra_info_id in number default hr_api.g_number
353: ,p_information_category in varchar2 default hr_api.g_varchar2
354: ,p_information1 in varchar2 default hr_api.g_varchar2
355: ,p_information2 in varchar2 default hr_api.g_varchar2
356: ,p_information3 in varchar2 default hr_api.g_varchar2
357: ,p_information4 in varchar2 default hr_api.g_varchar2

Line 354: ,p_information1 in varchar2 default hr_api.g_varchar2

350: ,p_information_type in varchar2 default hr_api.g_varchar2
351: ,p_position_transaction_id in number default hr_api.g_number
352: ,p_position_extra_info_id in number default hr_api.g_number
353: ,p_information_category in varchar2 default hr_api.g_varchar2
354: ,p_information1 in varchar2 default hr_api.g_varchar2
355: ,p_information2 in varchar2 default hr_api.g_varchar2
356: ,p_information3 in varchar2 default hr_api.g_varchar2
357: ,p_information4 in varchar2 default hr_api.g_varchar2
358: ,p_information5 in varchar2 default hr_api.g_varchar2

Line 355: ,p_information2 in varchar2 default hr_api.g_varchar2

351: ,p_position_transaction_id in number default hr_api.g_number
352: ,p_position_extra_info_id in number default hr_api.g_number
353: ,p_information_category in varchar2 default hr_api.g_varchar2
354: ,p_information1 in varchar2 default hr_api.g_varchar2
355: ,p_information2 in varchar2 default hr_api.g_varchar2
356: ,p_information3 in varchar2 default hr_api.g_varchar2
357: ,p_information4 in varchar2 default hr_api.g_varchar2
358: ,p_information5 in varchar2 default hr_api.g_varchar2
359: ,p_information6 in varchar2 default hr_api.g_varchar2

Line 356: ,p_information3 in varchar2 default hr_api.g_varchar2

352: ,p_position_extra_info_id in number default hr_api.g_number
353: ,p_information_category in varchar2 default hr_api.g_varchar2
354: ,p_information1 in varchar2 default hr_api.g_varchar2
355: ,p_information2 in varchar2 default hr_api.g_varchar2
356: ,p_information3 in varchar2 default hr_api.g_varchar2
357: ,p_information4 in varchar2 default hr_api.g_varchar2
358: ,p_information5 in varchar2 default hr_api.g_varchar2
359: ,p_information6 in varchar2 default hr_api.g_varchar2
360: ,p_information7 in varchar2 default hr_api.g_varchar2

Line 357: ,p_information4 in varchar2 default hr_api.g_varchar2

353: ,p_information_category in varchar2 default hr_api.g_varchar2
354: ,p_information1 in varchar2 default hr_api.g_varchar2
355: ,p_information2 in varchar2 default hr_api.g_varchar2
356: ,p_information3 in varchar2 default hr_api.g_varchar2
357: ,p_information4 in varchar2 default hr_api.g_varchar2
358: ,p_information5 in varchar2 default hr_api.g_varchar2
359: ,p_information6 in varchar2 default hr_api.g_varchar2
360: ,p_information7 in varchar2 default hr_api.g_varchar2
361: ,p_information8 in varchar2 default hr_api.g_varchar2

Line 358: ,p_information5 in varchar2 default hr_api.g_varchar2

354: ,p_information1 in varchar2 default hr_api.g_varchar2
355: ,p_information2 in varchar2 default hr_api.g_varchar2
356: ,p_information3 in varchar2 default hr_api.g_varchar2
357: ,p_information4 in varchar2 default hr_api.g_varchar2
358: ,p_information5 in varchar2 default hr_api.g_varchar2
359: ,p_information6 in varchar2 default hr_api.g_varchar2
360: ,p_information7 in varchar2 default hr_api.g_varchar2
361: ,p_information8 in varchar2 default hr_api.g_varchar2
362: ,p_information9 in varchar2 default hr_api.g_varchar2

Line 359: ,p_information6 in varchar2 default hr_api.g_varchar2

355: ,p_information2 in varchar2 default hr_api.g_varchar2
356: ,p_information3 in varchar2 default hr_api.g_varchar2
357: ,p_information4 in varchar2 default hr_api.g_varchar2
358: ,p_information5 in varchar2 default hr_api.g_varchar2
359: ,p_information6 in varchar2 default hr_api.g_varchar2
360: ,p_information7 in varchar2 default hr_api.g_varchar2
361: ,p_information8 in varchar2 default hr_api.g_varchar2
362: ,p_information9 in varchar2 default hr_api.g_varchar2
363: ,p_information10 in varchar2 default hr_api.g_varchar2

Line 360: ,p_information7 in varchar2 default hr_api.g_varchar2

356: ,p_information3 in varchar2 default hr_api.g_varchar2
357: ,p_information4 in varchar2 default hr_api.g_varchar2
358: ,p_information5 in varchar2 default hr_api.g_varchar2
359: ,p_information6 in varchar2 default hr_api.g_varchar2
360: ,p_information7 in varchar2 default hr_api.g_varchar2
361: ,p_information8 in varchar2 default hr_api.g_varchar2
362: ,p_information9 in varchar2 default hr_api.g_varchar2
363: ,p_information10 in varchar2 default hr_api.g_varchar2
364: ,p_information11 in varchar2 default hr_api.g_varchar2

Line 361: ,p_information8 in varchar2 default hr_api.g_varchar2

357: ,p_information4 in varchar2 default hr_api.g_varchar2
358: ,p_information5 in varchar2 default hr_api.g_varchar2
359: ,p_information6 in varchar2 default hr_api.g_varchar2
360: ,p_information7 in varchar2 default hr_api.g_varchar2
361: ,p_information8 in varchar2 default hr_api.g_varchar2
362: ,p_information9 in varchar2 default hr_api.g_varchar2
363: ,p_information10 in varchar2 default hr_api.g_varchar2
364: ,p_information11 in varchar2 default hr_api.g_varchar2
365: ,p_information12 in varchar2 default hr_api.g_varchar2

Line 362: ,p_information9 in varchar2 default hr_api.g_varchar2

358: ,p_information5 in varchar2 default hr_api.g_varchar2
359: ,p_information6 in varchar2 default hr_api.g_varchar2
360: ,p_information7 in varchar2 default hr_api.g_varchar2
361: ,p_information8 in varchar2 default hr_api.g_varchar2
362: ,p_information9 in varchar2 default hr_api.g_varchar2
363: ,p_information10 in varchar2 default hr_api.g_varchar2
364: ,p_information11 in varchar2 default hr_api.g_varchar2
365: ,p_information12 in varchar2 default hr_api.g_varchar2
366: ,p_information13 in varchar2 default hr_api.g_varchar2

Line 363: ,p_information10 in varchar2 default hr_api.g_varchar2

359: ,p_information6 in varchar2 default hr_api.g_varchar2
360: ,p_information7 in varchar2 default hr_api.g_varchar2
361: ,p_information8 in varchar2 default hr_api.g_varchar2
362: ,p_information9 in varchar2 default hr_api.g_varchar2
363: ,p_information10 in varchar2 default hr_api.g_varchar2
364: ,p_information11 in varchar2 default hr_api.g_varchar2
365: ,p_information12 in varchar2 default hr_api.g_varchar2
366: ,p_information13 in varchar2 default hr_api.g_varchar2
367: ,p_information14 in varchar2 default hr_api.g_varchar2

Line 364: ,p_information11 in varchar2 default hr_api.g_varchar2

360: ,p_information7 in varchar2 default hr_api.g_varchar2
361: ,p_information8 in varchar2 default hr_api.g_varchar2
362: ,p_information9 in varchar2 default hr_api.g_varchar2
363: ,p_information10 in varchar2 default hr_api.g_varchar2
364: ,p_information11 in varchar2 default hr_api.g_varchar2
365: ,p_information12 in varchar2 default hr_api.g_varchar2
366: ,p_information13 in varchar2 default hr_api.g_varchar2
367: ,p_information14 in varchar2 default hr_api.g_varchar2
368: ,p_information15 in varchar2 default hr_api.g_varchar2

Line 365: ,p_information12 in varchar2 default hr_api.g_varchar2

361: ,p_information8 in varchar2 default hr_api.g_varchar2
362: ,p_information9 in varchar2 default hr_api.g_varchar2
363: ,p_information10 in varchar2 default hr_api.g_varchar2
364: ,p_information11 in varchar2 default hr_api.g_varchar2
365: ,p_information12 in varchar2 default hr_api.g_varchar2
366: ,p_information13 in varchar2 default hr_api.g_varchar2
367: ,p_information14 in varchar2 default hr_api.g_varchar2
368: ,p_information15 in varchar2 default hr_api.g_varchar2
369: ,p_information16 in varchar2 default hr_api.g_varchar2

Line 366: ,p_information13 in varchar2 default hr_api.g_varchar2

362: ,p_information9 in varchar2 default hr_api.g_varchar2
363: ,p_information10 in varchar2 default hr_api.g_varchar2
364: ,p_information11 in varchar2 default hr_api.g_varchar2
365: ,p_information12 in varchar2 default hr_api.g_varchar2
366: ,p_information13 in varchar2 default hr_api.g_varchar2
367: ,p_information14 in varchar2 default hr_api.g_varchar2
368: ,p_information15 in varchar2 default hr_api.g_varchar2
369: ,p_information16 in varchar2 default hr_api.g_varchar2
370: ,p_information17 in varchar2 default hr_api.g_varchar2

Line 367: ,p_information14 in varchar2 default hr_api.g_varchar2

363: ,p_information10 in varchar2 default hr_api.g_varchar2
364: ,p_information11 in varchar2 default hr_api.g_varchar2
365: ,p_information12 in varchar2 default hr_api.g_varchar2
366: ,p_information13 in varchar2 default hr_api.g_varchar2
367: ,p_information14 in varchar2 default hr_api.g_varchar2
368: ,p_information15 in varchar2 default hr_api.g_varchar2
369: ,p_information16 in varchar2 default hr_api.g_varchar2
370: ,p_information17 in varchar2 default hr_api.g_varchar2
371: ,p_information18 in varchar2 default hr_api.g_varchar2

Line 368: ,p_information15 in varchar2 default hr_api.g_varchar2

364: ,p_information11 in varchar2 default hr_api.g_varchar2
365: ,p_information12 in varchar2 default hr_api.g_varchar2
366: ,p_information13 in varchar2 default hr_api.g_varchar2
367: ,p_information14 in varchar2 default hr_api.g_varchar2
368: ,p_information15 in varchar2 default hr_api.g_varchar2
369: ,p_information16 in varchar2 default hr_api.g_varchar2
370: ,p_information17 in varchar2 default hr_api.g_varchar2
371: ,p_information18 in varchar2 default hr_api.g_varchar2
372: ,p_information19 in varchar2 default hr_api.g_varchar2

Line 369: ,p_information16 in varchar2 default hr_api.g_varchar2

365: ,p_information12 in varchar2 default hr_api.g_varchar2
366: ,p_information13 in varchar2 default hr_api.g_varchar2
367: ,p_information14 in varchar2 default hr_api.g_varchar2
368: ,p_information15 in varchar2 default hr_api.g_varchar2
369: ,p_information16 in varchar2 default hr_api.g_varchar2
370: ,p_information17 in varchar2 default hr_api.g_varchar2
371: ,p_information18 in varchar2 default hr_api.g_varchar2
372: ,p_information19 in varchar2 default hr_api.g_varchar2
373: ,p_information20 in varchar2 default hr_api.g_varchar2

Line 370: ,p_information17 in varchar2 default hr_api.g_varchar2

366: ,p_information13 in varchar2 default hr_api.g_varchar2
367: ,p_information14 in varchar2 default hr_api.g_varchar2
368: ,p_information15 in varchar2 default hr_api.g_varchar2
369: ,p_information16 in varchar2 default hr_api.g_varchar2
370: ,p_information17 in varchar2 default hr_api.g_varchar2
371: ,p_information18 in varchar2 default hr_api.g_varchar2
372: ,p_information19 in varchar2 default hr_api.g_varchar2
373: ,p_information20 in varchar2 default hr_api.g_varchar2
374: ,p_information21 in varchar2 default hr_api.g_varchar2

Line 371: ,p_information18 in varchar2 default hr_api.g_varchar2

367: ,p_information14 in varchar2 default hr_api.g_varchar2
368: ,p_information15 in varchar2 default hr_api.g_varchar2
369: ,p_information16 in varchar2 default hr_api.g_varchar2
370: ,p_information17 in varchar2 default hr_api.g_varchar2
371: ,p_information18 in varchar2 default hr_api.g_varchar2
372: ,p_information19 in varchar2 default hr_api.g_varchar2
373: ,p_information20 in varchar2 default hr_api.g_varchar2
374: ,p_information21 in varchar2 default hr_api.g_varchar2
375: ,p_information22 in varchar2 default hr_api.g_varchar2

Line 372: ,p_information19 in varchar2 default hr_api.g_varchar2

368: ,p_information15 in varchar2 default hr_api.g_varchar2
369: ,p_information16 in varchar2 default hr_api.g_varchar2
370: ,p_information17 in varchar2 default hr_api.g_varchar2
371: ,p_information18 in varchar2 default hr_api.g_varchar2
372: ,p_information19 in varchar2 default hr_api.g_varchar2
373: ,p_information20 in varchar2 default hr_api.g_varchar2
374: ,p_information21 in varchar2 default hr_api.g_varchar2
375: ,p_information22 in varchar2 default hr_api.g_varchar2
376: ,p_information23 in varchar2 default hr_api.g_varchar2

Line 373: ,p_information20 in varchar2 default hr_api.g_varchar2

369: ,p_information16 in varchar2 default hr_api.g_varchar2
370: ,p_information17 in varchar2 default hr_api.g_varchar2
371: ,p_information18 in varchar2 default hr_api.g_varchar2
372: ,p_information19 in varchar2 default hr_api.g_varchar2
373: ,p_information20 in varchar2 default hr_api.g_varchar2
374: ,p_information21 in varchar2 default hr_api.g_varchar2
375: ,p_information22 in varchar2 default hr_api.g_varchar2
376: ,p_information23 in varchar2 default hr_api.g_varchar2
377: ,p_information24 in varchar2 default hr_api.g_varchar2

Line 374: ,p_information21 in varchar2 default hr_api.g_varchar2

370: ,p_information17 in varchar2 default hr_api.g_varchar2
371: ,p_information18 in varchar2 default hr_api.g_varchar2
372: ,p_information19 in varchar2 default hr_api.g_varchar2
373: ,p_information20 in varchar2 default hr_api.g_varchar2
374: ,p_information21 in varchar2 default hr_api.g_varchar2
375: ,p_information22 in varchar2 default hr_api.g_varchar2
376: ,p_information23 in varchar2 default hr_api.g_varchar2
377: ,p_information24 in varchar2 default hr_api.g_varchar2
378: ,p_information25 in varchar2 default hr_api.g_varchar2

Line 375: ,p_information22 in varchar2 default hr_api.g_varchar2

371: ,p_information18 in varchar2 default hr_api.g_varchar2
372: ,p_information19 in varchar2 default hr_api.g_varchar2
373: ,p_information20 in varchar2 default hr_api.g_varchar2
374: ,p_information21 in varchar2 default hr_api.g_varchar2
375: ,p_information22 in varchar2 default hr_api.g_varchar2
376: ,p_information23 in varchar2 default hr_api.g_varchar2
377: ,p_information24 in varchar2 default hr_api.g_varchar2
378: ,p_information25 in varchar2 default hr_api.g_varchar2
379: ,p_information26 in varchar2 default hr_api.g_varchar2

Line 376: ,p_information23 in varchar2 default hr_api.g_varchar2

372: ,p_information19 in varchar2 default hr_api.g_varchar2
373: ,p_information20 in varchar2 default hr_api.g_varchar2
374: ,p_information21 in varchar2 default hr_api.g_varchar2
375: ,p_information22 in varchar2 default hr_api.g_varchar2
376: ,p_information23 in varchar2 default hr_api.g_varchar2
377: ,p_information24 in varchar2 default hr_api.g_varchar2
378: ,p_information25 in varchar2 default hr_api.g_varchar2
379: ,p_information26 in varchar2 default hr_api.g_varchar2
380: ,p_information27 in varchar2 default hr_api.g_varchar2

Line 377: ,p_information24 in varchar2 default hr_api.g_varchar2

373: ,p_information20 in varchar2 default hr_api.g_varchar2
374: ,p_information21 in varchar2 default hr_api.g_varchar2
375: ,p_information22 in varchar2 default hr_api.g_varchar2
376: ,p_information23 in varchar2 default hr_api.g_varchar2
377: ,p_information24 in varchar2 default hr_api.g_varchar2
378: ,p_information25 in varchar2 default hr_api.g_varchar2
379: ,p_information26 in varchar2 default hr_api.g_varchar2
380: ,p_information27 in varchar2 default hr_api.g_varchar2
381: ,p_information28 in varchar2 default hr_api.g_varchar2

Line 378: ,p_information25 in varchar2 default hr_api.g_varchar2

374: ,p_information21 in varchar2 default hr_api.g_varchar2
375: ,p_information22 in varchar2 default hr_api.g_varchar2
376: ,p_information23 in varchar2 default hr_api.g_varchar2
377: ,p_information24 in varchar2 default hr_api.g_varchar2
378: ,p_information25 in varchar2 default hr_api.g_varchar2
379: ,p_information26 in varchar2 default hr_api.g_varchar2
380: ,p_information27 in varchar2 default hr_api.g_varchar2
381: ,p_information28 in varchar2 default hr_api.g_varchar2
382: ,p_information29 in varchar2 default hr_api.g_varchar2

Line 379: ,p_information26 in varchar2 default hr_api.g_varchar2

375: ,p_information22 in varchar2 default hr_api.g_varchar2
376: ,p_information23 in varchar2 default hr_api.g_varchar2
377: ,p_information24 in varchar2 default hr_api.g_varchar2
378: ,p_information25 in varchar2 default hr_api.g_varchar2
379: ,p_information26 in varchar2 default hr_api.g_varchar2
380: ,p_information27 in varchar2 default hr_api.g_varchar2
381: ,p_information28 in varchar2 default hr_api.g_varchar2
382: ,p_information29 in varchar2 default hr_api.g_varchar2
383: ,p_information30 in varchar2 default hr_api.g_varchar2

Line 380: ,p_information27 in varchar2 default hr_api.g_varchar2

376: ,p_information23 in varchar2 default hr_api.g_varchar2
377: ,p_information24 in varchar2 default hr_api.g_varchar2
378: ,p_information25 in varchar2 default hr_api.g_varchar2
379: ,p_information26 in varchar2 default hr_api.g_varchar2
380: ,p_information27 in varchar2 default hr_api.g_varchar2
381: ,p_information28 in varchar2 default hr_api.g_varchar2
382: ,p_information29 in varchar2 default hr_api.g_varchar2
383: ,p_information30 in varchar2 default hr_api.g_varchar2
384: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 381: ,p_information28 in varchar2 default hr_api.g_varchar2

377: ,p_information24 in varchar2 default hr_api.g_varchar2
378: ,p_information25 in varchar2 default hr_api.g_varchar2
379: ,p_information26 in varchar2 default hr_api.g_varchar2
380: ,p_information27 in varchar2 default hr_api.g_varchar2
381: ,p_information28 in varchar2 default hr_api.g_varchar2
382: ,p_information29 in varchar2 default hr_api.g_varchar2
383: ,p_information30 in varchar2 default hr_api.g_varchar2
384: ,p_attribute_category in varchar2 default hr_api.g_varchar2
385: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 382: ,p_information29 in varchar2 default hr_api.g_varchar2

378: ,p_information25 in varchar2 default hr_api.g_varchar2
379: ,p_information26 in varchar2 default hr_api.g_varchar2
380: ,p_information27 in varchar2 default hr_api.g_varchar2
381: ,p_information28 in varchar2 default hr_api.g_varchar2
382: ,p_information29 in varchar2 default hr_api.g_varchar2
383: ,p_information30 in varchar2 default hr_api.g_varchar2
384: ,p_attribute_category in varchar2 default hr_api.g_varchar2
385: ,p_attribute1 in varchar2 default hr_api.g_varchar2
386: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 383: ,p_information30 in varchar2 default hr_api.g_varchar2

379: ,p_information26 in varchar2 default hr_api.g_varchar2
380: ,p_information27 in varchar2 default hr_api.g_varchar2
381: ,p_information28 in varchar2 default hr_api.g_varchar2
382: ,p_information29 in varchar2 default hr_api.g_varchar2
383: ,p_information30 in varchar2 default hr_api.g_varchar2
384: ,p_attribute_category in varchar2 default hr_api.g_varchar2
385: ,p_attribute1 in varchar2 default hr_api.g_varchar2
386: ,p_attribute2 in varchar2 default hr_api.g_varchar2
387: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 384: ,p_attribute_category in varchar2 default hr_api.g_varchar2

380: ,p_information27 in varchar2 default hr_api.g_varchar2
381: ,p_information28 in varchar2 default hr_api.g_varchar2
382: ,p_information29 in varchar2 default hr_api.g_varchar2
383: ,p_information30 in varchar2 default hr_api.g_varchar2
384: ,p_attribute_category in varchar2 default hr_api.g_varchar2
385: ,p_attribute1 in varchar2 default hr_api.g_varchar2
386: ,p_attribute2 in varchar2 default hr_api.g_varchar2
387: ,p_attribute3 in varchar2 default hr_api.g_varchar2
388: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 385: ,p_attribute1 in varchar2 default hr_api.g_varchar2

381: ,p_information28 in varchar2 default hr_api.g_varchar2
382: ,p_information29 in varchar2 default hr_api.g_varchar2
383: ,p_information30 in varchar2 default hr_api.g_varchar2
384: ,p_attribute_category in varchar2 default hr_api.g_varchar2
385: ,p_attribute1 in varchar2 default hr_api.g_varchar2
386: ,p_attribute2 in varchar2 default hr_api.g_varchar2
387: ,p_attribute3 in varchar2 default hr_api.g_varchar2
388: ,p_attribute4 in varchar2 default hr_api.g_varchar2
389: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 386: ,p_attribute2 in varchar2 default hr_api.g_varchar2

382: ,p_information29 in varchar2 default hr_api.g_varchar2
383: ,p_information30 in varchar2 default hr_api.g_varchar2
384: ,p_attribute_category in varchar2 default hr_api.g_varchar2
385: ,p_attribute1 in varchar2 default hr_api.g_varchar2
386: ,p_attribute2 in varchar2 default hr_api.g_varchar2
387: ,p_attribute3 in varchar2 default hr_api.g_varchar2
388: ,p_attribute4 in varchar2 default hr_api.g_varchar2
389: ,p_attribute5 in varchar2 default hr_api.g_varchar2
390: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 387: ,p_attribute3 in varchar2 default hr_api.g_varchar2

383: ,p_information30 in varchar2 default hr_api.g_varchar2
384: ,p_attribute_category in varchar2 default hr_api.g_varchar2
385: ,p_attribute1 in varchar2 default hr_api.g_varchar2
386: ,p_attribute2 in varchar2 default hr_api.g_varchar2
387: ,p_attribute3 in varchar2 default hr_api.g_varchar2
388: ,p_attribute4 in varchar2 default hr_api.g_varchar2
389: ,p_attribute5 in varchar2 default hr_api.g_varchar2
390: ,p_attribute6 in varchar2 default hr_api.g_varchar2
391: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 388: ,p_attribute4 in varchar2 default hr_api.g_varchar2

384: ,p_attribute_category in varchar2 default hr_api.g_varchar2
385: ,p_attribute1 in varchar2 default hr_api.g_varchar2
386: ,p_attribute2 in varchar2 default hr_api.g_varchar2
387: ,p_attribute3 in varchar2 default hr_api.g_varchar2
388: ,p_attribute4 in varchar2 default hr_api.g_varchar2
389: ,p_attribute5 in varchar2 default hr_api.g_varchar2
390: ,p_attribute6 in varchar2 default hr_api.g_varchar2
391: ,p_attribute7 in varchar2 default hr_api.g_varchar2
392: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 389: ,p_attribute5 in varchar2 default hr_api.g_varchar2

385: ,p_attribute1 in varchar2 default hr_api.g_varchar2
386: ,p_attribute2 in varchar2 default hr_api.g_varchar2
387: ,p_attribute3 in varchar2 default hr_api.g_varchar2
388: ,p_attribute4 in varchar2 default hr_api.g_varchar2
389: ,p_attribute5 in varchar2 default hr_api.g_varchar2
390: ,p_attribute6 in varchar2 default hr_api.g_varchar2
391: ,p_attribute7 in varchar2 default hr_api.g_varchar2
392: ,p_attribute8 in varchar2 default hr_api.g_varchar2
393: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 390: ,p_attribute6 in varchar2 default hr_api.g_varchar2

386: ,p_attribute2 in varchar2 default hr_api.g_varchar2
387: ,p_attribute3 in varchar2 default hr_api.g_varchar2
388: ,p_attribute4 in varchar2 default hr_api.g_varchar2
389: ,p_attribute5 in varchar2 default hr_api.g_varchar2
390: ,p_attribute6 in varchar2 default hr_api.g_varchar2
391: ,p_attribute7 in varchar2 default hr_api.g_varchar2
392: ,p_attribute8 in varchar2 default hr_api.g_varchar2
393: ,p_attribute9 in varchar2 default hr_api.g_varchar2
394: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 391: ,p_attribute7 in varchar2 default hr_api.g_varchar2

387: ,p_attribute3 in varchar2 default hr_api.g_varchar2
388: ,p_attribute4 in varchar2 default hr_api.g_varchar2
389: ,p_attribute5 in varchar2 default hr_api.g_varchar2
390: ,p_attribute6 in varchar2 default hr_api.g_varchar2
391: ,p_attribute7 in varchar2 default hr_api.g_varchar2
392: ,p_attribute8 in varchar2 default hr_api.g_varchar2
393: ,p_attribute9 in varchar2 default hr_api.g_varchar2
394: ,p_attribute10 in varchar2 default hr_api.g_varchar2
395: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 392: ,p_attribute8 in varchar2 default hr_api.g_varchar2

388: ,p_attribute4 in varchar2 default hr_api.g_varchar2
389: ,p_attribute5 in varchar2 default hr_api.g_varchar2
390: ,p_attribute6 in varchar2 default hr_api.g_varchar2
391: ,p_attribute7 in varchar2 default hr_api.g_varchar2
392: ,p_attribute8 in varchar2 default hr_api.g_varchar2
393: ,p_attribute9 in varchar2 default hr_api.g_varchar2
394: ,p_attribute10 in varchar2 default hr_api.g_varchar2
395: ,p_attribute11 in varchar2 default hr_api.g_varchar2
396: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 393: ,p_attribute9 in varchar2 default hr_api.g_varchar2

389: ,p_attribute5 in varchar2 default hr_api.g_varchar2
390: ,p_attribute6 in varchar2 default hr_api.g_varchar2
391: ,p_attribute7 in varchar2 default hr_api.g_varchar2
392: ,p_attribute8 in varchar2 default hr_api.g_varchar2
393: ,p_attribute9 in varchar2 default hr_api.g_varchar2
394: ,p_attribute10 in varchar2 default hr_api.g_varchar2
395: ,p_attribute11 in varchar2 default hr_api.g_varchar2
396: ,p_attribute12 in varchar2 default hr_api.g_varchar2
397: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 394: ,p_attribute10 in varchar2 default hr_api.g_varchar2

390: ,p_attribute6 in varchar2 default hr_api.g_varchar2
391: ,p_attribute7 in varchar2 default hr_api.g_varchar2
392: ,p_attribute8 in varchar2 default hr_api.g_varchar2
393: ,p_attribute9 in varchar2 default hr_api.g_varchar2
394: ,p_attribute10 in varchar2 default hr_api.g_varchar2
395: ,p_attribute11 in varchar2 default hr_api.g_varchar2
396: ,p_attribute12 in varchar2 default hr_api.g_varchar2
397: ,p_attribute13 in varchar2 default hr_api.g_varchar2
398: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 395: ,p_attribute11 in varchar2 default hr_api.g_varchar2

391: ,p_attribute7 in varchar2 default hr_api.g_varchar2
392: ,p_attribute8 in varchar2 default hr_api.g_varchar2
393: ,p_attribute9 in varchar2 default hr_api.g_varchar2
394: ,p_attribute10 in varchar2 default hr_api.g_varchar2
395: ,p_attribute11 in varchar2 default hr_api.g_varchar2
396: ,p_attribute12 in varchar2 default hr_api.g_varchar2
397: ,p_attribute13 in varchar2 default hr_api.g_varchar2
398: ,p_attribute14 in varchar2 default hr_api.g_varchar2
399: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 396: ,p_attribute12 in varchar2 default hr_api.g_varchar2

392: ,p_attribute8 in varchar2 default hr_api.g_varchar2
393: ,p_attribute9 in varchar2 default hr_api.g_varchar2
394: ,p_attribute10 in varchar2 default hr_api.g_varchar2
395: ,p_attribute11 in varchar2 default hr_api.g_varchar2
396: ,p_attribute12 in varchar2 default hr_api.g_varchar2
397: ,p_attribute13 in varchar2 default hr_api.g_varchar2
398: ,p_attribute14 in varchar2 default hr_api.g_varchar2
399: ,p_attribute15 in varchar2 default hr_api.g_varchar2
400: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 397: ,p_attribute13 in varchar2 default hr_api.g_varchar2

393: ,p_attribute9 in varchar2 default hr_api.g_varchar2
394: ,p_attribute10 in varchar2 default hr_api.g_varchar2
395: ,p_attribute11 in varchar2 default hr_api.g_varchar2
396: ,p_attribute12 in varchar2 default hr_api.g_varchar2
397: ,p_attribute13 in varchar2 default hr_api.g_varchar2
398: ,p_attribute14 in varchar2 default hr_api.g_varchar2
399: ,p_attribute15 in varchar2 default hr_api.g_varchar2
400: ,p_attribute16 in varchar2 default hr_api.g_varchar2
401: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 398: ,p_attribute14 in varchar2 default hr_api.g_varchar2

394: ,p_attribute10 in varchar2 default hr_api.g_varchar2
395: ,p_attribute11 in varchar2 default hr_api.g_varchar2
396: ,p_attribute12 in varchar2 default hr_api.g_varchar2
397: ,p_attribute13 in varchar2 default hr_api.g_varchar2
398: ,p_attribute14 in varchar2 default hr_api.g_varchar2
399: ,p_attribute15 in varchar2 default hr_api.g_varchar2
400: ,p_attribute16 in varchar2 default hr_api.g_varchar2
401: ,p_attribute17 in varchar2 default hr_api.g_varchar2
402: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 399: ,p_attribute15 in varchar2 default hr_api.g_varchar2

395: ,p_attribute11 in varchar2 default hr_api.g_varchar2
396: ,p_attribute12 in varchar2 default hr_api.g_varchar2
397: ,p_attribute13 in varchar2 default hr_api.g_varchar2
398: ,p_attribute14 in varchar2 default hr_api.g_varchar2
399: ,p_attribute15 in varchar2 default hr_api.g_varchar2
400: ,p_attribute16 in varchar2 default hr_api.g_varchar2
401: ,p_attribute17 in varchar2 default hr_api.g_varchar2
402: ,p_attribute18 in varchar2 default hr_api.g_varchar2
403: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 400: ,p_attribute16 in varchar2 default hr_api.g_varchar2

396: ,p_attribute12 in varchar2 default hr_api.g_varchar2
397: ,p_attribute13 in varchar2 default hr_api.g_varchar2
398: ,p_attribute14 in varchar2 default hr_api.g_varchar2
399: ,p_attribute15 in varchar2 default hr_api.g_varchar2
400: ,p_attribute16 in varchar2 default hr_api.g_varchar2
401: ,p_attribute17 in varchar2 default hr_api.g_varchar2
402: ,p_attribute18 in varchar2 default hr_api.g_varchar2
403: ,p_attribute19 in varchar2 default hr_api.g_varchar2
404: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 401: ,p_attribute17 in varchar2 default hr_api.g_varchar2

397: ,p_attribute13 in varchar2 default hr_api.g_varchar2
398: ,p_attribute14 in varchar2 default hr_api.g_varchar2
399: ,p_attribute15 in varchar2 default hr_api.g_varchar2
400: ,p_attribute16 in varchar2 default hr_api.g_varchar2
401: ,p_attribute17 in varchar2 default hr_api.g_varchar2
402: ,p_attribute18 in varchar2 default hr_api.g_varchar2
403: ,p_attribute19 in varchar2 default hr_api.g_varchar2
404: ,p_attribute20 in varchar2 default hr_api.g_varchar2
405: ,p_object_version_number in out nocopy number

Line 402: ,p_attribute18 in varchar2 default hr_api.g_varchar2

398: ,p_attribute14 in varchar2 default hr_api.g_varchar2
399: ,p_attribute15 in varchar2 default hr_api.g_varchar2
400: ,p_attribute16 in varchar2 default hr_api.g_varchar2
401: ,p_attribute17 in varchar2 default hr_api.g_varchar2
402: ,p_attribute18 in varchar2 default hr_api.g_varchar2
403: ,p_attribute19 in varchar2 default hr_api.g_varchar2
404: ,p_attribute20 in varchar2 default hr_api.g_varchar2
405: ,p_object_version_number in out nocopy number
406: ) is

Line 403: ,p_attribute19 in varchar2 default hr_api.g_varchar2

399: ,p_attribute15 in varchar2 default hr_api.g_varchar2
400: ,p_attribute16 in varchar2 default hr_api.g_varchar2
401: ,p_attribute17 in varchar2 default hr_api.g_varchar2
402: ,p_attribute18 in varchar2 default hr_api.g_varchar2
403: ,p_attribute19 in varchar2 default hr_api.g_varchar2
404: ,p_attribute20 in varchar2 default hr_api.g_varchar2
405: ,p_object_version_number in out nocopy number
406: ) is
407: --

Line 404: ,p_attribute20 in varchar2 default hr_api.g_varchar2

400: ,p_attribute16 in varchar2 default hr_api.g_varchar2
401: ,p_attribute17 in varchar2 default hr_api.g_varchar2
402: ,p_attribute18 in varchar2 default hr_api.g_varchar2
403: ,p_attribute19 in varchar2 default hr_api.g_varchar2
404: ,p_attribute20 in varchar2 default hr_api.g_varchar2
405: ,p_object_version_number in out nocopy number
406: ) is
407: --
408: -- Declare cursors and local variables

Line 492: when hr_api.cannot_find_prog_unit then

488: ,p_attribute20 => p_attribute20
489: ,p_object_version_number => p_object_version_number
490: );
491: exception
492: when hr_api.cannot_find_prog_unit then
493: hr_api.cannot_find_prog_unit_error
494: (p_module_name => 'UPDATE_PTX_EXTRA_INFO'
495: ,p_hook_type => 'BP'
496: );

Line 493: hr_api.cannot_find_prog_unit_error

489: ,p_object_version_number => p_object_version_number
490: );
491: exception
492: when hr_api.cannot_find_prog_unit then
493: hr_api.cannot_find_prog_unit_error
494: (p_module_name => 'UPDATE_PTX_EXTRA_INFO'
495: ,p_hook_type => 'BP'
496: );
497: --

Line 628: when hr_api.cannot_find_prog_unit then

624: ,p_attribute20 => p_attribute20
625: ,p_object_version_number => l_object_version_number
626: );
627: exception
628: when hr_api.cannot_find_prog_unit then
629: hr_api.cannot_find_prog_unit_error
630: (p_module_name => 'UPDATE_PTX_EXTRA_INFO'
631: ,p_hook_type => 'AP'
632: );

Line 629: hr_api.cannot_find_prog_unit_error

625: ,p_object_version_number => l_object_version_number
626: );
627: exception
628: when hr_api.cannot_find_prog_unit then
629: hr_api.cannot_find_prog_unit_error
630: (p_module_name => 'UPDATE_PTX_EXTRA_INFO'
631: ,p_hook_type => 'AP'
632: );
633: --

Line 643: raise hr_api.validate_enabled;

639: --
640: -- When in validation only mode raise the Validate_Enabled exception
641: --
642: if p_validate then
643: raise hr_api.validate_enabled;
644: end if;
645: --
646: -- Set all output arguments
647: --

Line 654: when hr_api.validate_enabled then

650: hr_utility.set_location(' Leaving:'||l_proc, 70);
651: --
652: exception
653: --
654: when hr_api.validate_enabled then
655: --
656: -- As the Validate_Enabled exception has been raised
657: -- we must rollback to the savepoint
658: --

Line 716: when hr_api.cannot_find_prog_unit then

712: p_ptx_extra_info_id => p_ptx_extra_info_id
713: ,p_object_version_number => p_object_version_number
714: );
715: exception
716: when hr_api.cannot_find_prog_unit then
717: hr_api.cannot_find_prog_unit_error
718: (p_module_name => 'DELETE_PTX_EXTRA_INFO'
719: ,p_hook_type => 'BP'
720: );

Line 717: hr_api.cannot_find_prog_unit_error

713: ,p_object_version_number => p_object_version_number
714: );
715: exception
716: when hr_api.cannot_find_prog_unit then
717: hr_api.cannot_find_prog_unit_error
718: (p_module_name => 'DELETE_PTX_EXTRA_INFO'
719: ,p_hook_type => 'BP'
720: );
721: --

Line 742: when hr_api.cannot_find_prog_unit then

738: p_ptx_extra_info_id => p_ptx_extra_info_id
739: ,p_object_version_number => l_object_version_number
740: );
741: exception
742: when hr_api.cannot_find_prog_unit then
743: hr_api.cannot_find_prog_unit_error
744: (p_module_name => 'DELETE_PTX_EXTRA_INFO'
745: ,p_hook_type => 'AP'
746: );

Line 743: hr_api.cannot_find_prog_unit_error

739: ,p_object_version_number => l_object_version_number
740: );
741: exception
742: when hr_api.cannot_find_prog_unit then
743: hr_api.cannot_find_prog_unit_error
744: (p_module_name => 'DELETE_PTX_EXTRA_INFO'
745: ,p_hook_type => 'AP'
746: );
747: --

Line 757: raise hr_api.validate_enabled;

753: --
754: -- When in validation only mode raise the Validate_Enabled exception
755: --
756: if p_validate then
757: raise hr_api.validate_enabled;
758: end if;
759: --
760: hr_utility.set_location(' Leaving:'||l_proc, 70);
761: --

Line 764: when hr_api.validate_enabled then

760: hr_utility.set_location(' Leaving:'||l_proc, 70);
761: --
762: exception
763: --
764: when hr_api.validate_enabled then
765: --
766: -- As the Validate_Enabled exception has been raised
767: -- we must rollback to the savepoint
768: --