eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_SP_PLACEMENT_API dependencies on HR_API

Line 219: hr_api.mandatory_arg_error

215: -- Check that all not null parameters have a variable passed in
216: --
217: hr_utility.set_location('Entering mandatory arg check', 20);
218: --
219: hr_api.mandatory_arg_error
220: (p_api_name => l_proc,
221: p_argument => 'assignment_id',
222: p_argument_value => p_assignment_id);
223: --

Line 224: hr_api.mandatory_arg_error

220: (p_api_name => l_proc,
221: p_argument => 'assignment_id',
222: p_argument_value => p_assignment_id);
223: --
224: hr_api.mandatory_arg_error
225: (p_api_name => l_proc,
226: p_argument => 'business_group_id',
227: p_argument_value => p_business_group_id);
228: --

Line 229: hr_api.mandatory_arg_error

225: (p_api_name => l_proc,
226: p_argument => 'business_group_id',
227: p_argument_value => p_business_group_id);
228: --
229: hr_api.mandatory_arg_error
230: (p_api_name => l_proc,
231: p_argument => 'effective_date',
232: p_argument_value => p_effective_date);
233: --

Line 234: hr_api.mandatory_arg_error

230: (p_api_name => l_proc,
231: p_argument => 'effective_date',
232: p_argument_value => p_effective_date);
233: --
234: hr_api.mandatory_arg_error
235: (p_api_name => l_proc,
236: p_argument => 'step_id',
237: p_argument_value => p_step_id);
238: --

Line 239: hr_api.mandatory_arg_error

235: (p_api_name => l_proc,
236: p_argument => 'step_id',
237: p_argument_value => p_step_id);
238: --
239: hr_api.mandatory_arg_error
240: (p_api_name => l_proc,
241: p_argument => 'auto_increment_flag',
242: p_argument_value => p_auto_increment_flag);
243: --

Line 245: hr_api.mandatory_arg_error

241: p_argument => 'auto_increment_flag',
242: p_argument_value => p_auto_increment_flag);
243: --
244: /*
245: hr_api.mandatory_arg_error
246: (p_api_name => l_proc,
247: p_argument => 'parent_spine_id',
248: p_argument_value => p_parent_spine_id);
249: */

Line 303: when hr_api.cannot_find_prog_unit then

299: ,p_information30 => p_information30
300: ,p_information_category => p_information_category
301: );
302: exception
303: when hr_api.cannot_find_prog_unit then
304: hr_api.cannot_find_prog_unit_error
305: (p_module_name => 'CREATE_SPINAL_POINT_PLACEMENT'
306: ,p_hook_type => 'BP'
307: );

Line 304: hr_api.cannot_find_prog_unit_error

300: ,p_information_category => p_information_category
301: );
302: exception
303: when hr_api.cannot_find_prog_unit then
304: hr_api.cannot_find_prog_unit_error
305: (p_module_name => 'CREATE_SPINAL_POINT_PLACEMENT'
306: ,p_hook_type => 'BP'
307: );
308:

Line 418: when hr_api.cannot_find_prog_unit then

414: ,p_information_category => p_information_category
415: );
416:
417: exception
418: when hr_api.cannot_find_prog_unit then
419: hr_api.cannot_find_prog_unit_error
420: (p_module_name => 'CREATE_SPINAL_POINT_PLACEMENT'
421: ,p_hook_type => 'AP'
422: );

Line 419: hr_api.cannot_find_prog_unit_error

415: );
416:
417: exception
418: when hr_api.cannot_find_prog_unit then
419: hr_api.cannot_find_prog_unit_error
420: (p_module_name => 'CREATE_SPINAL_POINT_PLACEMENT'
421: ,p_hook_type => 'AP'
422: );
423: end;

Line 439: raise hr_api.validate_enabled;

435: --
436: -- When in validation only mode raise the Validate_Enabled exception
437: --
438: if p_validate then
439: raise hr_api.validate_enabled;
440: end if;
441: --
442: -- Set all output arguments
443: --

Line 452: when hr_api.validate_enabled then

448: p_gsp_post_process_warning := l_gsp_post_process_warning;
449: --
450: hr_utility.set_location(' Leaving:'||l_proc, 70);
451: exception
452: when hr_api.validate_enabled then
453: --
454: -- As the Validate_Enabled exception has been raised
455: -- we must rollback to the savepoint
456: --

Line 492: ,p_datetrack_mode in varchar2 default hr_api.g_update

488: --
489: procedure update_spp
490: (p_validate in boolean default false
491: ,p_effective_date in date
492: ,p_datetrack_mode in varchar2 default hr_api.g_update
493: ,p_placement_id in number
494: ,p_object_version_number in out nocopy number
495: ,p_step_id in number default hr_api.g_number
496: ,p_auto_increment_flag in varchar2 default hr_api.g_varchar2

Line 495: ,p_step_id in number default hr_api.g_number

491: ,p_effective_date in date
492: ,p_datetrack_mode in varchar2 default hr_api.g_update
493: ,p_placement_id in number
494: ,p_object_version_number in out nocopy number
495: ,p_step_id in number default hr_api.g_number
496: ,p_auto_increment_flag in varchar2 default hr_api.g_varchar2
497: ,p_reason in varchar2 default hr_api.g_varchar2
498: ,p_request_id in number default hr_api.g_number
499: ,p_program_application_id in number default hr_api.g_number

Line 496: ,p_auto_increment_flag in varchar2 default hr_api.g_varchar2

492: ,p_datetrack_mode in varchar2 default hr_api.g_update
493: ,p_placement_id in number
494: ,p_object_version_number in out nocopy number
495: ,p_step_id in number default hr_api.g_number
496: ,p_auto_increment_flag in varchar2 default hr_api.g_varchar2
497: ,p_reason in varchar2 default hr_api.g_varchar2
498: ,p_request_id in number default hr_api.g_number
499: ,p_program_application_id in number default hr_api.g_number
500: ,p_program_id in number default hr_api.g_number

Line 497: ,p_reason in varchar2 default hr_api.g_varchar2

493: ,p_placement_id in number
494: ,p_object_version_number in out nocopy number
495: ,p_step_id in number default hr_api.g_number
496: ,p_auto_increment_flag in varchar2 default hr_api.g_varchar2
497: ,p_reason in varchar2 default hr_api.g_varchar2
498: ,p_request_id in number default hr_api.g_number
499: ,p_program_application_id in number default hr_api.g_number
500: ,p_program_id in number default hr_api.g_number
501: ,p_program_update_date in date default hr_api.g_date

Line 498: ,p_request_id in number default hr_api.g_number

494: ,p_object_version_number in out nocopy number
495: ,p_step_id in number default hr_api.g_number
496: ,p_auto_increment_flag in varchar2 default hr_api.g_varchar2
497: ,p_reason in varchar2 default hr_api.g_varchar2
498: ,p_request_id in number default hr_api.g_number
499: ,p_program_application_id in number default hr_api.g_number
500: ,p_program_id in number default hr_api.g_number
501: ,p_program_update_date in date default hr_api.g_date
502: ,p_increment_number in number default hr_api.g_number

Line 499: ,p_program_application_id in number default hr_api.g_number

495: ,p_step_id in number default hr_api.g_number
496: ,p_auto_increment_flag in varchar2 default hr_api.g_varchar2
497: ,p_reason in varchar2 default hr_api.g_varchar2
498: ,p_request_id in number default hr_api.g_number
499: ,p_program_application_id in number default hr_api.g_number
500: ,p_program_id in number default hr_api.g_number
501: ,p_program_update_date in date default hr_api.g_date
502: ,p_increment_number in number default hr_api.g_number
503: ,p_information1 in varchar2 default hr_api.g_varchar2

Line 500: ,p_program_id in number default hr_api.g_number

496: ,p_auto_increment_flag in varchar2 default hr_api.g_varchar2
497: ,p_reason in varchar2 default hr_api.g_varchar2
498: ,p_request_id in number default hr_api.g_number
499: ,p_program_application_id in number default hr_api.g_number
500: ,p_program_id in number default hr_api.g_number
501: ,p_program_update_date in date default hr_api.g_date
502: ,p_increment_number in number default hr_api.g_number
503: ,p_information1 in varchar2 default hr_api.g_varchar2
504: ,p_information2 in varchar2 default hr_api.g_varchar2

Line 501: ,p_program_update_date in date default hr_api.g_date

497: ,p_reason in varchar2 default hr_api.g_varchar2
498: ,p_request_id in number default hr_api.g_number
499: ,p_program_application_id in number default hr_api.g_number
500: ,p_program_id in number default hr_api.g_number
501: ,p_program_update_date in date default hr_api.g_date
502: ,p_increment_number in number default hr_api.g_number
503: ,p_information1 in varchar2 default hr_api.g_varchar2
504: ,p_information2 in varchar2 default hr_api.g_varchar2
505: ,p_information3 in varchar2 default hr_api.g_varchar2

Line 502: ,p_increment_number in number default hr_api.g_number

498: ,p_request_id in number default hr_api.g_number
499: ,p_program_application_id in number default hr_api.g_number
500: ,p_program_id in number default hr_api.g_number
501: ,p_program_update_date in date default hr_api.g_date
502: ,p_increment_number in number default hr_api.g_number
503: ,p_information1 in varchar2 default hr_api.g_varchar2
504: ,p_information2 in varchar2 default hr_api.g_varchar2
505: ,p_information3 in varchar2 default hr_api.g_varchar2
506: ,p_information4 in varchar2 default hr_api.g_varchar2

Line 503: ,p_information1 in varchar2 default hr_api.g_varchar2

499: ,p_program_application_id in number default hr_api.g_number
500: ,p_program_id in number default hr_api.g_number
501: ,p_program_update_date in date default hr_api.g_date
502: ,p_increment_number in number default hr_api.g_number
503: ,p_information1 in varchar2 default hr_api.g_varchar2
504: ,p_information2 in varchar2 default hr_api.g_varchar2
505: ,p_information3 in varchar2 default hr_api.g_varchar2
506: ,p_information4 in varchar2 default hr_api.g_varchar2
507: ,p_information5 in varchar2 default hr_api.g_varchar2

Line 504: ,p_information2 in varchar2 default hr_api.g_varchar2

500: ,p_program_id in number default hr_api.g_number
501: ,p_program_update_date in date default hr_api.g_date
502: ,p_increment_number in number default hr_api.g_number
503: ,p_information1 in varchar2 default hr_api.g_varchar2
504: ,p_information2 in varchar2 default hr_api.g_varchar2
505: ,p_information3 in varchar2 default hr_api.g_varchar2
506: ,p_information4 in varchar2 default hr_api.g_varchar2
507: ,p_information5 in varchar2 default hr_api.g_varchar2
508: ,p_information6 in varchar2 default hr_api.g_varchar2

Line 505: ,p_information3 in varchar2 default hr_api.g_varchar2

501: ,p_program_update_date in date default hr_api.g_date
502: ,p_increment_number in number default hr_api.g_number
503: ,p_information1 in varchar2 default hr_api.g_varchar2
504: ,p_information2 in varchar2 default hr_api.g_varchar2
505: ,p_information3 in varchar2 default hr_api.g_varchar2
506: ,p_information4 in varchar2 default hr_api.g_varchar2
507: ,p_information5 in varchar2 default hr_api.g_varchar2
508: ,p_information6 in varchar2 default hr_api.g_varchar2
509: ,p_information7 in varchar2 default hr_api.g_varchar2

Line 506: ,p_information4 in varchar2 default hr_api.g_varchar2

502: ,p_increment_number in number default hr_api.g_number
503: ,p_information1 in varchar2 default hr_api.g_varchar2
504: ,p_information2 in varchar2 default hr_api.g_varchar2
505: ,p_information3 in varchar2 default hr_api.g_varchar2
506: ,p_information4 in varchar2 default hr_api.g_varchar2
507: ,p_information5 in varchar2 default hr_api.g_varchar2
508: ,p_information6 in varchar2 default hr_api.g_varchar2
509: ,p_information7 in varchar2 default hr_api.g_varchar2
510: ,p_information8 in varchar2 default hr_api.g_varchar2

Line 507: ,p_information5 in varchar2 default hr_api.g_varchar2

503: ,p_information1 in varchar2 default hr_api.g_varchar2
504: ,p_information2 in varchar2 default hr_api.g_varchar2
505: ,p_information3 in varchar2 default hr_api.g_varchar2
506: ,p_information4 in varchar2 default hr_api.g_varchar2
507: ,p_information5 in varchar2 default hr_api.g_varchar2
508: ,p_information6 in varchar2 default hr_api.g_varchar2
509: ,p_information7 in varchar2 default hr_api.g_varchar2
510: ,p_information8 in varchar2 default hr_api.g_varchar2
511: ,p_information9 in varchar2 default hr_api.g_varchar2

Line 508: ,p_information6 in varchar2 default hr_api.g_varchar2

504: ,p_information2 in varchar2 default hr_api.g_varchar2
505: ,p_information3 in varchar2 default hr_api.g_varchar2
506: ,p_information4 in varchar2 default hr_api.g_varchar2
507: ,p_information5 in varchar2 default hr_api.g_varchar2
508: ,p_information6 in varchar2 default hr_api.g_varchar2
509: ,p_information7 in varchar2 default hr_api.g_varchar2
510: ,p_information8 in varchar2 default hr_api.g_varchar2
511: ,p_information9 in varchar2 default hr_api.g_varchar2
512: ,p_information10 in varchar2 default hr_api.g_varchar2

Line 509: ,p_information7 in varchar2 default hr_api.g_varchar2

505: ,p_information3 in varchar2 default hr_api.g_varchar2
506: ,p_information4 in varchar2 default hr_api.g_varchar2
507: ,p_information5 in varchar2 default hr_api.g_varchar2
508: ,p_information6 in varchar2 default hr_api.g_varchar2
509: ,p_information7 in varchar2 default hr_api.g_varchar2
510: ,p_information8 in varchar2 default hr_api.g_varchar2
511: ,p_information9 in varchar2 default hr_api.g_varchar2
512: ,p_information10 in varchar2 default hr_api.g_varchar2
513: ,p_information11 in varchar2 default hr_api.g_varchar2

Line 510: ,p_information8 in varchar2 default hr_api.g_varchar2

506: ,p_information4 in varchar2 default hr_api.g_varchar2
507: ,p_information5 in varchar2 default hr_api.g_varchar2
508: ,p_information6 in varchar2 default hr_api.g_varchar2
509: ,p_information7 in varchar2 default hr_api.g_varchar2
510: ,p_information8 in varchar2 default hr_api.g_varchar2
511: ,p_information9 in varchar2 default hr_api.g_varchar2
512: ,p_information10 in varchar2 default hr_api.g_varchar2
513: ,p_information11 in varchar2 default hr_api.g_varchar2
514: ,p_information12 in varchar2 default hr_api.g_varchar2

Line 511: ,p_information9 in varchar2 default hr_api.g_varchar2

507: ,p_information5 in varchar2 default hr_api.g_varchar2
508: ,p_information6 in varchar2 default hr_api.g_varchar2
509: ,p_information7 in varchar2 default hr_api.g_varchar2
510: ,p_information8 in varchar2 default hr_api.g_varchar2
511: ,p_information9 in varchar2 default hr_api.g_varchar2
512: ,p_information10 in varchar2 default hr_api.g_varchar2
513: ,p_information11 in varchar2 default hr_api.g_varchar2
514: ,p_information12 in varchar2 default hr_api.g_varchar2
515: ,p_information13 in varchar2 default hr_api.g_varchar2

Line 512: ,p_information10 in varchar2 default hr_api.g_varchar2

508: ,p_information6 in varchar2 default hr_api.g_varchar2
509: ,p_information7 in varchar2 default hr_api.g_varchar2
510: ,p_information8 in varchar2 default hr_api.g_varchar2
511: ,p_information9 in varchar2 default hr_api.g_varchar2
512: ,p_information10 in varchar2 default hr_api.g_varchar2
513: ,p_information11 in varchar2 default hr_api.g_varchar2
514: ,p_information12 in varchar2 default hr_api.g_varchar2
515: ,p_information13 in varchar2 default hr_api.g_varchar2
516: ,p_information14 in varchar2 default hr_api.g_varchar2

Line 513: ,p_information11 in varchar2 default hr_api.g_varchar2

509: ,p_information7 in varchar2 default hr_api.g_varchar2
510: ,p_information8 in varchar2 default hr_api.g_varchar2
511: ,p_information9 in varchar2 default hr_api.g_varchar2
512: ,p_information10 in varchar2 default hr_api.g_varchar2
513: ,p_information11 in varchar2 default hr_api.g_varchar2
514: ,p_information12 in varchar2 default hr_api.g_varchar2
515: ,p_information13 in varchar2 default hr_api.g_varchar2
516: ,p_information14 in varchar2 default hr_api.g_varchar2
517: ,p_information15 in varchar2 default hr_api.g_varchar2

Line 514: ,p_information12 in varchar2 default hr_api.g_varchar2

510: ,p_information8 in varchar2 default hr_api.g_varchar2
511: ,p_information9 in varchar2 default hr_api.g_varchar2
512: ,p_information10 in varchar2 default hr_api.g_varchar2
513: ,p_information11 in varchar2 default hr_api.g_varchar2
514: ,p_information12 in varchar2 default hr_api.g_varchar2
515: ,p_information13 in varchar2 default hr_api.g_varchar2
516: ,p_information14 in varchar2 default hr_api.g_varchar2
517: ,p_information15 in varchar2 default hr_api.g_varchar2
518: ,p_information16 in varchar2 default hr_api.g_varchar2

Line 515: ,p_information13 in varchar2 default hr_api.g_varchar2

511: ,p_information9 in varchar2 default hr_api.g_varchar2
512: ,p_information10 in varchar2 default hr_api.g_varchar2
513: ,p_information11 in varchar2 default hr_api.g_varchar2
514: ,p_information12 in varchar2 default hr_api.g_varchar2
515: ,p_information13 in varchar2 default hr_api.g_varchar2
516: ,p_information14 in varchar2 default hr_api.g_varchar2
517: ,p_information15 in varchar2 default hr_api.g_varchar2
518: ,p_information16 in varchar2 default hr_api.g_varchar2
519: ,p_information17 in varchar2 default hr_api.g_varchar2

Line 516: ,p_information14 in varchar2 default hr_api.g_varchar2

512: ,p_information10 in varchar2 default hr_api.g_varchar2
513: ,p_information11 in varchar2 default hr_api.g_varchar2
514: ,p_information12 in varchar2 default hr_api.g_varchar2
515: ,p_information13 in varchar2 default hr_api.g_varchar2
516: ,p_information14 in varchar2 default hr_api.g_varchar2
517: ,p_information15 in varchar2 default hr_api.g_varchar2
518: ,p_information16 in varchar2 default hr_api.g_varchar2
519: ,p_information17 in varchar2 default hr_api.g_varchar2
520: ,p_information18 in varchar2 default hr_api.g_varchar2

Line 517: ,p_information15 in varchar2 default hr_api.g_varchar2

513: ,p_information11 in varchar2 default hr_api.g_varchar2
514: ,p_information12 in varchar2 default hr_api.g_varchar2
515: ,p_information13 in varchar2 default hr_api.g_varchar2
516: ,p_information14 in varchar2 default hr_api.g_varchar2
517: ,p_information15 in varchar2 default hr_api.g_varchar2
518: ,p_information16 in varchar2 default hr_api.g_varchar2
519: ,p_information17 in varchar2 default hr_api.g_varchar2
520: ,p_information18 in varchar2 default hr_api.g_varchar2
521: ,p_information19 in varchar2 default hr_api.g_varchar2

Line 518: ,p_information16 in varchar2 default hr_api.g_varchar2

514: ,p_information12 in varchar2 default hr_api.g_varchar2
515: ,p_information13 in varchar2 default hr_api.g_varchar2
516: ,p_information14 in varchar2 default hr_api.g_varchar2
517: ,p_information15 in varchar2 default hr_api.g_varchar2
518: ,p_information16 in varchar2 default hr_api.g_varchar2
519: ,p_information17 in varchar2 default hr_api.g_varchar2
520: ,p_information18 in varchar2 default hr_api.g_varchar2
521: ,p_information19 in varchar2 default hr_api.g_varchar2
522: ,p_information20 in varchar2 default hr_api.g_varchar2

Line 519: ,p_information17 in varchar2 default hr_api.g_varchar2

515: ,p_information13 in varchar2 default hr_api.g_varchar2
516: ,p_information14 in varchar2 default hr_api.g_varchar2
517: ,p_information15 in varchar2 default hr_api.g_varchar2
518: ,p_information16 in varchar2 default hr_api.g_varchar2
519: ,p_information17 in varchar2 default hr_api.g_varchar2
520: ,p_information18 in varchar2 default hr_api.g_varchar2
521: ,p_information19 in varchar2 default hr_api.g_varchar2
522: ,p_information20 in varchar2 default hr_api.g_varchar2
523: ,p_information21 in varchar2 default hr_api.g_varchar2

Line 520: ,p_information18 in varchar2 default hr_api.g_varchar2

516: ,p_information14 in varchar2 default hr_api.g_varchar2
517: ,p_information15 in varchar2 default hr_api.g_varchar2
518: ,p_information16 in varchar2 default hr_api.g_varchar2
519: ,p_information17 in varchar2 default hr_api.g_varchar2
520: ,p_information18 in varchar2 default hr_api.g_varchar2
521: ,p_information19 in varchar2 default hr_api.g_varchar2
522: ,p_information20 in varchar2 default hr_api.g_varchar2
523: ,p_information21 in varchar2 default hr_api.g_varchar2
524: ,p_information22 in varchar2 default hr_api.g_varchar2

Line 521: ,p_information19 in varchar2 default hr_api.g_varchar2

517: ,p_information15 in varchar2 default hr_api.g_varchar2
518: ,p_information16 in varchar2 default hr_api.g_varchar2
519: ,p_information17 in varchar2 default hr_api.g_varchar2
520: ,p_information18 in varchar2 default hr_api.g_varchar2
521: ,p_information19 in varchar2 default hr_api.g_varchar2
522: ,p_information20 in varchar2 default hr_api.g_varchar2
523: ,p_information21 in varchar2 default hr_api.g_varchar2
524: ,p_information22 in varchar2 default hr_api.g_varchar2
525: ,p_information23 in varchar2 default hr_api.g_varchar2

Line 522: ,p_information20 in varchar2 default hr_api.g_varchar2

518: ,p_information16 in varchar2 default hr_api.g_varchar2
519: ,p_information17 in varchar2 default hr_api.g_varchar2
520: ,p_information18 in varchar2 default hr_api.g_varchar2
521: ,p_information19 in varchar2 default hr_api.g_varchar2
522: ,p_information20 in varchar2 default hr_api.g_varchar2
523: ,p_information21 in varchar2 default hr_api.g_varchar2
524: ,p_information22 in varchar2 default hr_api.g_varchar2
525: ,p_information23 in varchar2 default hr_api.g_varchar2
526: ,p_information24 in varchar2 default hr_api.g_varchar2

Line 523: ,p_information21 in varchar2 default hr_api.g_varchar2

519: ,p_information17 in varchar2 default hr_api.g_varchar2
520: ,p_information18 in varchar2 default hr_api.g_varchar2
521: ,p_information19 in varchar2 default hr_api.g_varchar2
522: ,p_information20 in varchar2 default hr_api.g_varchar2
523: ,p_information21 in varchar2 default hr_api.g_varchar2
524: ,p_information22 in varchar2 default hr_api.g_varchar2
525: ,p_information23 in varchar2 default hr_api.g_varchar2
526: ,p_information24 in varchar2 default hr_api.g_varchar2
527: ,p_information25 in varchar2 default hr_api.g_varchar2

Line 524: ,p_information22 in varchar2 default hr_api.g_varchar2

520: ,p_information18 in varchar2 default hr_api.g_varchar2
521: ,p_information19 in varchar2 default hr_api.g_varchar2
522: ,p_information20 in varchar2 default hr_api.g_varchar2
523: ,p_information21 in varchar2 default hr_api.g_varchar2
524: ,p_information22 in varchar2 default hr_api.g_varchar2
525: ,p_information23 in varchar2 default hr_api.g_varchar2
526: ,p_information24 in varchar2 default hr_api.g_varchar2
527: ,p_information25 in varchar2 default hr_api.g_varchar2
528: ,p_information26 in varchar2 default hr_api.g_varchar2

Line 525: ,p_information23 in varchar2 default hr_api.g_varchar2

521: ,p_information19 in varchar2 default hr_api.g_varchar2
522: ,p_information20 in varchar2 default hr_api.g_varchar2
523: ,p_information21 in varchar2 default hr_api.g_varchar2
524: ,p_information22 in varchar2 default hr_api.g_varchar2
525: ,p_information23 in varchar2 default hr_api.g_varchar2
526: ,p_information24 in varchar2 default hr_api.g_varchar2
527: ,p_information25 in varchar2 default hr_api.g_varchar2
528: ,p_information26 in varchar2 default hr_api.g_varchar2
529: ,p_information27 in varchar2 default hr_api.g_varchar2

Line 526: ,p_information24 in varchar2 default hr_api.g_varchar2

522: ,p_information20 in varchar2 default hr_api.g_varchar2
523: ,p_information21 in varchar2 default hr_api.g_varchar2
524: ,p_information22 in varchar2 default hr_api.g_varchar2
525: ,p_information23 in varchar2 default hr_api.g_varchar2
526: ,p_information24 in varchar2 default hr_api.g_varchar2
527: ,p_information25 in varchar2 default hr_api.g_varchar2
528: ,p_information26 in varchar2 default hr_api.g_varchar2
529: ,p_information27 in varchar2 default hr_api.g_varchar2
530: ,p_information28 in varchar2 default hr_api.g_varchar2

Line 527: ,p_information25 in varchar2 default hr_api.g_varchar2

523: ,p_information21 in varchar2 default hr_api.g_varchar2
524: ,p_information22 in varchar2 default hr_api.g_varchar2
525: ,p_information23 in varchar2 default hr_api.g_varchar2
526: ,p_information24 in varchar2 default hr_api.g_varchar2
527: ,p_information25 in varchar2 default hr_api.g_varchar2
528: ,p_information26 in varchar2 default hr_api.g_varchar2
529: ,p_information27 in varchar2 default hr_api.g_varchar2
530: ,p_information28 in varchar2 default hr_api.g_varchar2
531: ,p_information29 in varchar2 default hr_api.g_varchar2

Line 528: ,p_information26 in varchar2 default hr_api.g_varchar2

524: ,p_information22 in varchar2 default hr_api.g_varchar2
525: ,p_information23 in varchar2 default hr_api.g_varchar2
526: ,p_information24 in varchar2 default hr_api.g_varchar2
527: ,p_information25 in varchar2 default hr_api.g_varchar2
528: ,p_information26 in varchar2 default hr_api.g_varchar2
529: ,p_information27 in varchar2 default hr_api.g_varchar2
530: ,p_information28 in varchar2 default hr_api.g_varchar2
531: ,p_information29 in varchar2 default hr_api.g_varchar2
532: ,p_information30 in varchar2 default hr_api.g_varchar2

Line 529: ,p_information27 in varchar2 default hr_api.g_varchar2

525: ,p_information23 in varchar2 default hr_api.g_varchar2
526: ,p_information24 in varchar2 default hr_api.g_varchar2
527: ,p_information25 in varchar2 default hr_api.g_varchar2
528: ,p_information26 in varchar2 default hr_api.g_varchar2
529: ,p_information27 in varchar2 default hr_api.g_varchar2
530: ,p_information28 in varchar2 default hr_api.g_varchar2
531: ,p_information29 in varchar2 default hr_api.g_varchar2
532: ,p_information30 in varchar2 default hr_api.g_varchar2
533: ,p_information_category in varchar2 default hr_api.g_varchar2

Line 530: ,p_information28 in varchar2 default hr_api.g_varchar2

526: ,p_information24 in varchar2 default hr_api.g_varchar2
527: ,p_information25 in varchar2 default hr_api.g_varchar2
528: ,p_information26 in varchar2 default hr_api.g_varchar2
529: ,p_information27 in varchar2 default hr_api.g_varchar2
530: ,p_information28 in varchar2 default hr_api.g_varchar2
531: ,p_information29 in varchar2 default hr_api.g_varchar2
532: ,p_information30 in varchar2 default hr_api.g_varchar2
533: ,p_information_category in varchar2 default hr_api.g_varchar2
534: ,p_effective_start_date in out nocopy date

Line 531: ,p_information29 in varchar2 default hr_api.g_varchar2

527: ,p_information25 in varchar2 default hr_api.g_varchar2
528: ,p_information26 in varchar2 default hr_api.g_varchar2
529: ,p_information27 in varchar2 default hr_api.g_varchar2
530: ,p_information28 in varchar2 default hr_api.g_varchar2
531: ,p_information29 in varchar2 default hr_api.g_varchar2
532: ,p_information30 in varchar2 default hr_api.g_varchar2
533: ,p_information_category in varchar2 default hr_api.g_varchar2
534: ,p_effective_start_date in out nocopy date
535: ,p_effective_end_date in out nocopy date

Line 532: ,p_information30 in varchar2 default hr_api.g_varchar2

528: ,p_information26 in varchar2 default hr_api.g_varchar2
529: ,p_information27 in varchar2 default hr_api.g_varchar2
530: ,p_information28 in varchar2 default hr_api.g_varchar2
531: ,p_information29 in varchar2 default hr_api.g_varchar2
532: ,p_information30 in varchar2 default hr_api.g_varchar2
533: ,p_information_category in varchar2 default hr_api.g_varchar2
534: ,p_effective_start_date in out nocopy date
535: ,p_effective_end_date in out nocopy date
536: ) is

Line 533: ,p_information_category in varchar2 default hr_api.g_varchar2

529: ,p_information27 in varchar2 default hr_api.g_varchar2
530: ,p_information28 in varchar2 default hr_api.g_varchar2
531: ,p_information29 in varchar2 default hr_api.g_varchar2
532: ,p_information30 in varchar2 default hr_api.g_varchar2
533: ,p_information_category in varchar2 default hr_api.g_varchar2
534: ,p_effective_start_date in out nocopy date
535: ,p_effective_end_date in out nocopy date
536: ) is
537: --

Line 640: ,p_datetrack_mode in varchar2 default hr_api.g_update

636: --
637: procedure update_spp
638: (p_validate in boolean default false
639: ,p_effective_date in date
640: ,p_datetrack_mode in varchar2 default hr_api.g_update
641: ,p_placement_id in number
642: ,p_object_version_number in out nocopy number
643: ,p_step_id in number default hr_api.g_number
644: ,p_auto_increment_flag in varchar2 default hr_api.g_varchar2

Line 643: ,p_step_id in number default hr_api.g_number

639: ,p_effective_date in date
640: ,p_datetrack_mode in varchar2 default hr_api.g_update
641: ,p_placement_id in number
642: ,p_object_version_number in out nocopy number
643: ,p_step_id in number default hr_api.g_number
644: ,p_auto_increment_flag in varchar2 default hr_api.g_varchar2
645: ,p_reason in varchar2 default hr_api.g_varchar2
646: ,p_request_id in number default hr_api.g_number
647: ,p_program_application_id in number default hr_api.g_number

Line 644: ,p_auto_increment_flag in varchar2 default hr_api.g_varchar2

640: ,p_datetrack_mode in varchar2 default hr_api.g_update
641: ,p_placement_id in number
642: ,p_object_version_number in out nocopy number
643: ,p_step_id in number default hr_api.g_number
644: ,p_auto_increment_flag in varchar2 default hr_api.g_varchar2
645: ,p_reason in varchar2 default hr_api.g_varchar2
646: ,p_request_id in number default hr_api.g_number
647: ,p_program_application_id in number default hr_api.g_number
648: ,p_program_id in number default hr_api.g_number

Line 645: ,p_reason in varchar2 default hr_api.g_varchar2

641: ,p_placement_id in number
642: ,p_object_version_number in out nocopy number
643: ,p_step_id in number default hr_api.g_number
644: ,p_auto_increment_flag in varchar2 default hr_api.g_varchar2
645: ,p_reason in varchar2 default hr_api.g_varchar2
646: ,p_request_id in number default hr_api.g_number
647: ,p_program_application_id in number default hr_api.g_number
648: ,p_program_id in number default hr_api.g_number
649: ,p_program_update_date in date default hr_api.g_date

Line 646: ,p_request_id in number default hr_api.g_number

642: ,p_object_version_number in out nocopy number
643: ,p_step_id in number default hr_api.g_number
644: ,p_auto_increment_flag in varchar2 default hr_api.g_varchar2
645: ,p_reason in varchar2 default hr_api.g_varchar2
646: ,p_request_id in number default hr_api.g_number
647: ,p_program_application_id in number default hr_api.g_number
648: ,p_program_id in number default hr_api.g_number
649: ,p_program_update_date in date default hr_api.g_date
650: ,p_increment_number in number default hr_api.g_number

Line 647: ,p_program_application_id in number default hr_api.g_number

643: ,p_step_id in number default hr_api.g_number
644: ,p_auto_increment_flag in varchar2 default hr_api.g_varchar2
645: ,p_reason in varchar2 default hr_api.g_varchar2
646: ,p_request_id in number default hr_api.g_number
647: ,p_program_application_id in number default hr_api.g_number
648: ,p_program_id in number default hr_api.g_number
649: ,p_program_update_date in date default hr_api.g_date
650: ,p_increment_number in number default hr_api.g_number
651: ,p_information1 in varchar2 default hr_api.g_varchar2

Line 648: ,p_program_id in number default hr_api.g_number

644: ,p_auto_increment_flag in varchar2 default hr_api.g_varchar2
645: ,p_reason in varchar2 default hr_api.g_varchar2
646: ,p_request_id in number default hr_api.g_number
647: ,p_program_application_id in number default hr_api.g_number
648: ,p_program_id in number default hr_api.g_number
649: ,p_program_update_date in date default hr_api.g_date
650: ,p_increment_number in number default hr_api.g_number
651: ,p_information1 in varchar2 default hr_api.g_varchar2
652: ,p_information2 in varchar2 default hr_api.g_varchar2

Line 649: ,p_program_update_date in date default hr_api.g_date

645: ,p_reason in varchar2 default hr_api.g_varchar2
646: ,p_request_id in number default hr_api.g_number
647: ,p_program_application_id in number default hr_api.g_number
648: ,p_program_id in number default hr_api.g_number
649: ,p_program_update_date in date default hr_api.g_date
650: ,p_increment_number in number default hr_api.g_number
651: ,p_information1 in varchar2 default hr_api.g_varchar2
652: ,p_information2 in varchar2 default hr_api.g_varchar2
653: ,p_information3 in varchar2 default hr_api.g_varchar2

Line 650: ,p_increment_number in number default hr_api.g_number

646: ,p_request_id in number default hr_api.g_number
647: ,p_program_application_id in number default hr_api.g_number
648: ,p_program_id in number default hr_api.g_number
649: ,p_program_update_date in date default hr_api.g_date
650: ,p_increment_number in number default hr_api.g_number
651: ,p_information1 in varchar2 default hr_api.g_varchar2
652: ,p_information2 in varchar2 default hr_api.g_varchar2
653: ,p_information3 in varchar2 default hr_api.g_varchar2
654: ,p_information4 in varchar2 default hr_api.g_varchar2

Line 651: ,p_information1 in varchar2 default hr_api.g_varchar2

647: ,p_program_application_id in number default hr_api.g_number
648: ,p_program_id in number default hr_api.g_number
649: ,p_program_update_date in date default hr_api.g_date
650: ,p_increment_number in number default hr_api.g_number
651: ,p_information1 in varchar2 default hr_api.g_varchar2
652: ,p_information2 in varchar2 default hr_api.g_varchar2
653: ,p_information3 in varchar2 default hr_api.g_varchar2
654: ,p_information4 in varchar2 default hr_api.g_varchar2
655: ,p_information5 in varchar2 default hr_api.g_varchar2

Line 652: ,p_information2 in varchar2 default hr_api.g_varchar2

648: ,p_program_id in number default hr_api.g_number
649: ,p_program_update_date in date default hr_api.g_date
650: ,p_increment_number in number default hr_api.g_number
651: ,p_information1 in varchar2 default hr_api.g_varchar2
652: ,p_information2 in varchar2 default hr_api.g_varchar2
653: ,p_information3 in varchar2 default hr_api.g_varchar2
654: ,p_information4 in varchar2 default hr_api.g_varchar2
655: ,p_information5 in varchar2 default hr_api.g_varchar2
656: ,p_information6 in varchar2 default hr_api.g_varchar2

Line 653: ,p_information3 in varchar2 default hr_api.g_varchar2

649: ,p_program_update_date in date default hr_api.g_date
650: ,p_increment_number in number default hr_api.g_number
651: ,p_information1 in varchar2 default hr_api.g_varchar2
652: ,p_information2 in varchar2 default hr_api.g_varchar2
653: ,p_information3 in varchar2 default hr_api.g_varchar2
654: ,p_information4 in varchar2 default hr_api.g_varchar2
655: ,p_information5 in varchar2 default hr_api.g_varchar2
656: ,p_information6 in varchar2 default hr_api.g_varchar2
657: ,p_information7 in varchar2 default hr_api.g_varchar2

Line 654: ,p_information4 in varchar2 default hr_api.g_varchar2

650: ,p_increment_number in number default hr_api.g_number
651: ,p_information1 in varchar2 default hr_api.g_varchar2
652: ,p_information2 in varchar2 default hr_api.g_varchar2
653: ,p_information3 in varchar2 default hr_api.g_varchar2
654: ,p_information4 in varchar2 default hr_api.g_varchar2
655: ,p_information5 in varchar2 default hr_api.g_varchar2
656: ,p_information6 in varchar2 default hr_api.g_varchar2
657: ,p_information7 in varchar2 default hr_api.g_varchar2
658: ,p_information8 in varchar2 default hr_api.g_varchar2

Line 655: ,p_information5 in varchar2 default hr_api.g_varchar2

651: ,p_information1 in varchar2 default hr_api.g_varchar2
652: ,p_information2 in varchar2 default hr_api.g_varchar2
653: ,p_information3 in varchar2 default hr_api.g_varchar2
654: ,p_information4 in varchar2 default hr_api.g_varchar2
655: ,p_information5 in varchar2 default hr_api.g_varchar2
656: ,p_information6 in varchar2 default hr_api.g_varchar2
657: ,p_information7 in varchar2 default hr_api.g_varchar2
658: ,p_information8 in varchar2 default hr_api.g_varchar2
659: ,p_information9 in varchar2 default hr_api.g_varchar2

Line 656: ,p_information6 in varchar2 default hr_api.g_varchar2

652: ,p_information2 in varchar2 default hr_api.g_varchar2
653: ,p_information3 in varchar2 default hr_api.g_varchar2
654: ,p_information4 in varchar2 default hr_api.g_varchar2
655: ,p_information5 in varchar2 default hr_api.g_varchar2
656: ,p_information6 in varchar2 default hr_api.g_varchar2
657: ,p_information7 in varchar2 default hr_api.g_varchar2
658: ,p_information8 in varchar2 default hr_api.g_varchar2
659: ,p_information9 in varchar2 default hr_api.g_varchar2
660: ,p_information10 in varchar2 default hr_api.g_varchar2

Line 657: ,p_information7 in varchar2 default hr_api.g_varchar2

653: ,p_information3 in varchar2 default hr_api.g_varchar2
654: ,p_information4 in varchar2 default hr_api.g_varchar2
655: ,p_information5 in varchar2 default hr_api.g_varchar2
656: ,p_information6 in varchar2 default hr_api.g_varchar2
657: ,p_information7 in varchar2 default hr_api.g_varchar2
658: ,p_information8 in varchar2 default hr_api.g_varchar2
659: ,p_information9 in varchar2 default hr_api.g_varchar2
660: ,p_information10 in varchar2 default hr_api.g_varchar2
661: ,p_information11 in varchar2 default hr_api.g_varchar2

Line 658: ,p_information8 in varchar2 default hr_api.g_varchar2

654: ,p_information4 in varchar2 default hr_api.g_varchar2
655: ,p_information5 in varchar2 default hr_api.g_varchar2
656: ,p_information6 in varchar2 default hr_api.g_varchar2
657: ,p_information7 in varchar2 default hr_api.g_varchar2
658: ,p_information8 in varchar2 default hr_api.g_varchar2
659: ,p_information9 in varchar2 default hr_api.g_varchar2
660: ,p_information10 in varchar2 default hr_api.g_varchar2
661: ,p_information11 in varchar2 default hr_api.g_varchar2
662: ,p_information12 in varchar2 default hr_api.g_varchar2

Line 659: ,p_information9 in varchar2 default hr_api.g_varchar2

655: ,p_information5 in varchar2 default hr_api.g_varchar2
656: ,p_information6 in varchar2 default hr_api.g_varchar2
657: ,p_information7 in varchar2 default hr_api.g_varchar2
658: ,p_information8 in varchar2 default hr_api.g_varchar2
659: ,p_information9 in varchar2 default hr_api.g_varchar2
660: ,p_information10 in varchar2 default hr_api.g_varchar2
661: ,p_information11 in varchar2 default hr_api.g_varchar2
662: ,p_information12 in varchar2 default hr_api.g_varchar2
663: ,p_information13 in varchar2 default hr_api.g_varchar2

Line 660: ,p_information10 in varchar2 default hr_api.g_varchar2

656: ,p_information6 in varchar2 default hr_api.g_varchar2
657: ,p_information7 in varchar2 default hr_api.g_varchar2
658: ,p_information8 in varchar2 default hr_api.g_varchar2
659: ,p_information9 in varchar2 default hr_api.g_varchar2
660: ,p_information10 in varchar2 default hr_api.g_varchar2
661: ,p_information11 in varchar2 default hr_api.g_varchar2
662: ,p_information12 in varchar2 default hr_api.g_varchar2
663: ,p_information13 in varchar2 default hr_api.g_varchar2
664: ,p_information14 in varchar2 default hr_api.g_varchar2

Line 661: ,p_information11 in varchar2 default hr_api.g_varchar2

657: ,p_information7 in varchar2 default hr_api.g_varchar2
658: ,p_information8 in varchar2 default hr_api.g_varchar2
659: ,p_information9 in varchar2 default hr_api.g_varchar2
660: ,p_information10 in varchar2 default hr_api.g_varchar2
661: ,p_information11 in varchar2 default hr_api.g_varchar2
662: ,p_information12 in varchar2 default hr_api.g_varchar2
663: ,p_information13 in varchar2 default hr_api.g_varchar2
664: ,p_information14 in varchar2 default hr_api.g_varchar2
665: ,p_information15 in varchar2 default hr_api.g_varchar2

Line 662: ,p_information12 in varchar2 default hr_api.g_varchar2

658: ,p_information8 in varchar2 default hr_api.g_varchar2
659: ,p_information9 in varchar2 default hr_api.g_varchar2
660: ,p_information10 in varchar2 default hr_api.g_varchar2
661: ,p_information11 in varchar2 default hr_api.g_varchar2
662: ,p_information12 in varchar2 default hr_api.g_varchar2
663: ,p_information13 in varchar2 default hr_api.g_varchar2
664: ,p_information14 in varchar2 default hr_api.g_varchar2
665: ,p_information15 in varchar2 default hr_api.g_varchar2
666: ,p_information16 in varchar2 default hr_api.g_varchar2

Line 663: ,p_information13 in varchar2 default hr_api.g_varchar2

659: ,p_information9 in varchar2 default hr_api.g_varchar2
660: ,p_information10 in varchar2 default hr_api.g_varchar2
661: ,p_information11 in varchar2 default hr_api.g_varchar2
662: ,p_information12 in varchar2 default hr_api.g_varchar2
663: ,p_information13 in varchar2 default hr_api.g_varchar2
664: ,p_information14 in varchar2 default hr_api.g_varchar2
665: ,p_information15 in varchar2 default hr_api.g_varchar2
666: ,p_information16 in varchar2 default hr_api.g_varchar2
667: ,p_information17 in varchar2 default hr_api.g_varchar2

Line 664: ,p_information14 in varchar2 default hr_api.g_varchar2

660: ,p_information10 in varchar2 default hr_api.g_varchar2
661: ,p_information11 in varchar2 default hr_api.g_varchar2
662: ,p_information12 in varchar2 default hr_api.g_varchar2
663: ,p_information13 in varchar2 default hr_api.g_varchar2
664: ,p_information14 in varchar2 default hr_api.g_varchar2
665: ,p_information15 in varchar2 default hr_api.g_varchar2
666: ,p_information16 in varchar2 default hr_api.g_varchar2
667: ,p_information17 in varchar2 default hr_api.g_varchar2
668: ,p_information18 in varchar2 default hr_api.g_varchar2

Line 665: ,p_information15 in varchar2 default hr_api.g_varchar2

661: ,p_information11 in varchar2 default hr_api.g_varchar2
662: ,p_information12 in varchar2 default hr_api.g_varchar2
663: ,p_information13 in varchar2 default hr_api.g_varchar2
664: ,p_information14 in varchar2 default hr_api.g_varchar2
665: ,p_information15 in varchar2 default hr_api.g_varchar2
666: ,p_information16 in varchar2 default hr_api.g_varchar2
667: ,p_information17 in varchar2 default hr_api.g_varchar2
668: ,p_information18 in varchar2 default hr_api.g_varchar2
669: ,p_information19 in varchar2 default hr_api.g_varchar2

Line 666: ,p_information16 in varchar2 default hr_api.g_varchar2

662: ,p_information12 in varchar2 default hr_api.g_varchar2
663: ,p_information13 in varchar2 default hr_api.g_varchar2
664: ,p_information14 in varchar2 default hr_api.g_varchar2
665: ,p_information15 in varchar2 default hr_api.g_varchar2
666: ,p_information16 in varchar2 default hr_api.g_varchar2
667: ,p_information17 in varchar2 default hr_api.g_varchar2
668: ,p_information18 in varchar2 default hr_api.g_varchar2
669: ,p_information19 in varchar2 default hr_api.g_varchar2
670: ,p_information20 in varchar2 default hr_api.g_varchar2

Line 667: ,p_information17 in varchar2 default hr_api.g_varchar2

663: ,p_information13 in varchar2 default hr_api.g_varchar2
664: ,p_information14 in varchar2 default hr_api.g_varchar2
665: ,p_information15 in varchar2 default hr_api.g_varchar2
666: ,p_information16 in varchar2 default hr_api.g_varchar2
667: ,p_information17 in varchar2 default hr_api.g_varchar2
668: ,p_information18 in varchar2 default hr_api.g_varchar2
669: ,p_information19 in varchar2 default hr_api.g_varchar2
670: ,p_information20 in varchar2 default hr_api.g_varchar2
671: ,p_information21 in varchar2 default hr_api.g_varchar2

Line 668: ,p_information18 in varchar2 default hr_api.g_varchar2

664: ,p_information14 in varchar2 default hr_api.g_varchar2
665: ,p_information15 in varchar2 default hr_api.g_varchar2
666: ,p_information16 in varchar2 default hr_api.g_varchar2
667: ,p_information17 in varchar2 default hr_api.g_varchar2
668: ,p_information18 in varchar2 default hr_api.g_varchar2
669: ,p_information19 in varchar2 default hr_api.g_varchar2
670: ,p_information20 in varchar2 default hr_api.g_varchar2
671: ,p_information21 in varchar2 default hr_api.g_varchar2
672: ,p_information22 in varchar2 default hr_api.g_varchar2

Line 669: ,p_information19 in varchar2 default hr_api.g_varchar2

665: ,p_information15 in varchar2 default hr_api.g_varchar2
666: ,p_information16 in varchar2 default hr_api.g_varchar2
667: ,p_information17 in varchar2 default hr_api.g_varchar2
668: ,p_information18 in varchar2 default hr_api.g_varchar2
669: ,p_information19 in varchar2 default hr_api.g_varchar2
670: ,p_information20 in varchar2 default hr_api.g_varchar2
671: ,p_information21 in varchar2 default hr_api.g_varchar2
672: ,p_information22 in varchar2 default hr_api.g_varchar2
673: ,p_information23 in varchar2 default hr_api.g_varchar2

Line 670: ,p_information20 in varchar2 default hr_api.g_varchar2

666: ,p_information16 in varchar2 default hr_api.g_varchar2
667: ,p_information17 in varchar2 default hr_api.g_varchar2
668: ,p_information18 in varchar2 default hr_api.g_varchar2
669: ,p_information19 in varchar2 default hr_api.g_varchar2
670: ,p_information20 in varchar2 default hr_api.g_varchar2
671: ,p_information21 in varchar2 default hr_api.g_varchar2
672: ,p_information22 in varchar2 default hr_api.g_varchar2
673: ,p_information23 in varchar2 default hr_api.g_varchar2
674: ,p_information24 in varchar2 default hr_api.g_varchar2

Line 671: ,p_information21 in varchar2 default hr_api.g_varchar2

667: ,p_information17 in varchar2 default hr_api.g_varchar2
668: ,p_information18 in varchar2 default hr_api.g_varchar2
669: ,p_information19 in varchar2 default hr_api.g_varchar2
670: ,p_information20 in varchar2 default hr_api.g_varchar2
671: ,p_information21 in varchar2 default hr_api.g_varchar2
672: ,p_information22 in varchar2 default hr_api.g_varchar2
673: ,p_information23 in varchar2 default hr_api.g_varchar2
674: ,p_information24 in varchar2 default hr_api.g_varchar2
675: ,p_information25 in varchar2 default hr_api.g_varchar2

Line 672: ,p_information22 in varchar2 default hr_api.g_varchar2

668: ,p_information18 in varchar2 default hr_api.g_varchar2
669: ,p_information19 in varchar2 default hr_api.g_varchar2
670: ,p_information20 in varchar2 default hr_api.g_varchar2
671: ,p_information21 in varchar2 default hr_api.g_varchar2
672: ,p_information22 in varchar2 default hr_api.g_varchar2
673: ,p_information23 in varchar2 default hr_api.g_varchar2
674: ,p_information24 in varchar2 default hr_api.g_varchar2
675: ,p_information25 in varchar2 default hr_api.g_varchar2
676: ,p_information26 in varchar2 default hr_api.g_varchar2

Line 673: ,p_information23 in varchar2 default hr_api.g_varchar2

669: ,p_information19 in varchar2 default hr_api.g_varchar2
670: ,p_information20 in varchar2 default hr_api.g_varchar2
671: ,p_information21 in varchar2 default hr_api.g_varchar2
672: ,p_information22 in varchar2 default hr_api.g_varchar2
673: ,p_information23 in varchar2 default hr_api.g_varchar2
674: ,p_information24 in varchar2 default hr_api.g_varchar2
675: ,p_information25 in varchar2 default hr_api.g_varchar2
676: ,p_information26 in varchar2 default hr_api.g_varchar2
677: ,p_information27 in varchar2 default hr_api.g_varchar2

Line 674: ,p_information24 in varchar2 default hr_api.g_varchar2

670: ,p_information20 in varchar2 default hr_api.g_varchar2
671: ,p_information21 in varchar2 default hr_api.g_varchar2
672: ,p_information22 in varchar2 default hr_api.g_varchar2
673: ,p_information23 in varchar2 default hr_api.g_varchar2
674: ,p_information24 in varchar2 default hr_api.g_varchar2
675: ,p_information25 in varchar2 default hr_api.g_varchar2
676: ,p_information26 in varchar2 default hr_api.g_varchar2
677: ,p_information27 in varchar2 default hr_api.g_varchar2
678: ,p_information28 in varchar2 default hr_api.g_varchar2

Line 675: ,p_information25 in varchar2 default hr_api.g_varchar2

671: ,p_information21 in varchar2 default hr_api.g_varchar2
672: ,p_information22 in varchar2 default hr_api.g_varchar2
673: ,p_information23 in varchar2 default hr_api.g_varchar2
674: ,p_information24 in varchar2 default hr_api.g_varchar2
675: ,p_information25 in varchar2 default hr_api.g_varchar2
676: ,p_information26 in varchar2 default hr_api.g_varchar2
677: ,p_information27 in varchar2 default hr_api.g_varchar2
678: ,p_information28 in varchar2 default hr_api.g_varchar2
679: ,p_information29 in varchar2 default hr_api.g_varchar2

Line 676: ,p_information26 in varchar2 default hr_api.g_varchar2

672: ,p_information22 in varchar2 default hr_api.g_varchar2
673: ,p_information23 in varchar2 default hr_api.g_varchar2
674: ,p_information24 in varchar2 default hr_api.g_varchar2
675: ,p_information25 in varchar2 default hr_api.g_varchar2
676: ,p_information26 in varchar2 default hr_api.g_varchar2
677: ,p_information27 in varchar2 default hr_api.g_varchar2
678: ,p_information28 in varchar2 default hr_api.g_varchar2
679: ,p_information29 in varchar2 default hr_api.g_varchar2
680: ,p_information30 in varchar2 default hr_api.g_varchar2

Line 677: ,p_information27 in varchar2 default hr_api.g_varchar2

673: ,p_information23 in varchar2 default hr_api.g_varchar2
674: ,p_information24 in varchar2 default hr_api.g_varchar2
675: ,p_information25 in varchar2 default hr_api.g_varchar2
676: ,p_information26 in varchar2 default hr_api.g_varchar2
677: ,p_information27 in varchar2 default hr_api.g_varchar2
678: ,p_information28 in varchar2 default hr_api.g_varchar2
679: ,p_information29 in varchar2 default hr_api.g_varchar2
680: ,p_information30 in varchar2 default hr_api.g_varchar2
681: ,p_information_category in varchar2 default hr_api.g_varchar2

Line 678: ,p_information28 in varchar2 default hr_api.g_varchar2

674: ,p_information24 in varchar2 default hr_api.g_varchar2
675: ,p_information25 in varchar2 default hr_api.g_varchar2
676: ,p_information26 in varchar2 default hr_api.g_varchar2
677: ,p_information27 in varchar2 default hr_api.g_varchar2
678: ,p_information28 in varchar2 default hr_api.g_varchar2
679: ,p_information29 in varchar2 default hr_api.g_varchar2
680: ,p_information30 in varchar2 default hr_api.g_varchar2
681: ,p_information_category in varchar2 default hr_api.g_varchar2
682: ,p_effective_start_date in out nocopy date

Line 679: ,p_information29 in varchar2 default hr_api.g_varchar2

675: ,p_information25 in varchar2 default hr_api.g_varchar2
676: ,p_information26 in varchar2 default hr_api.g_varchar2
677: ,p_information27 in varchar2 default hr_api.g_varchar2
678: ,p_information28 in varchar2 default hr_api.g_varchar2
679: ,p_information29 in varchar2 default hr_api.g_varchar2
680: ,p_information30 in varchar2 default hr_api.g_varchar2
681: ,p_information_category in varchar2 default hr_api.g_varchar2
682: ,p_effective_start_date in out nocopy date
683: ,p_effective_end_date in out nocopy date

Line 680: ,p_information30 in varchar2 default hr_api.g_varchar2

676: ,p_information26 in varchar2 default hr_api.g_varchar2
677: ,p_information27 in varchar2 default hr_api.g_varchar2
678: ,p_information28 in varchar2 default hr_api.g_varchar2
679: ,p_information29 in varchar2 default hr_api.g_varchar2
680: ,p_information30 in varchar2 default hr_api.g_varchar2
681: ,p_information_category in varchar2 default hr_api.g_varchar2
682: ,p_effective_start_date in out nocopy date
683: ,p_effective_end_date in out nocopy date
684: ,p_gsp_post_process_warning out nocopy varchar2

Line 681: ,p_information_category in varchar2 default hr_api.g_varchar2

677: ,p_information27 in varchar2 default hr_api.g_varchar2
678: ,p_information28 in varchar2 default hr_api.g_varchar2
679: ,p_information29 in varchar2 default hr_api.g_varchar2
680: ,p_information30 in varchar2 default hr_api.g_varchar2
681: ,p_information_category in varchar2 default hr_api.g_varchar2
682: ,p_effective_start_date in out nocopy date
683: ,p_effective_end_date in out nocopy date
684: ,p_gsp_post_process_warning out nocopy varchar2
685: ) is

Line 726: hr_api.mandatory_arg_error

722: -- Check that all required parameters are not null
723: --
724: hr_utility.set_location('Entering mandatory arg check', 20);
725: --
726: hr_api.mandatory_arg_error
727: (p_api_name => l_proc,
728: p_argument => 'placement_id',
729: p_argument_value => p_placement_id);
730: --

Line 731: hr_api.mandatory_arg_error

727: (p_api_name => l_proc,
728: p_argument => 'placement_id',
729: p_argument_value => p_placement_id);
730: --
731: hr_api.mandatory_arg_error
732: (p_api_name => l_proc,
733: p_argument => 'effective_date',
734: p_argument_value => p_effective_date);
735: --

Line 736: hr_api.mandatory_arg_error

732: (p_api_name => l_proc,
733: p_argument => 'effective_date',
734: p_argument_value => p_effective_date);
735: --
736: hr_api.mandatory_arg_error
737: (p_api_name => l_proc,
738: p_argument => 'object_version_number',
739: p_argument_value => p_object_version_number);
740: --

Line 824: when hr_api.cannot_find_prog_unit then

820: -- ,p_effective_start_date => l_effective_start_date
821: -- ,p_effetcive_end_date => l_effective_end_date
822: );
823: exception
824: when hr_api.cannot_find_prog_unit then
825: hr_api.cannot_find_prog_unit_error
826: (p_module_name => 'UPDATE_SPINAL_POINT_PLACEMENT'
827: ,p_hook_type => 'BP'
828: );

Line 825: hr_api.cannot_find_prog_unit_error

821: -- ,p_effetcive_end_date => l_effective_end_date
822: );
823: exception
824: when hr_api.cannot_find_prog_unit then
825: hr_api.cannot_find_prog_unit_error
826: (p_module_name => 'UPDATE_SPINAL_POINT_PLACEMENT'
827: ,p_hook_type => 'BP'
828: );
829:

Line 950: when hr_api.cannot_find_prog_unit then

946: ,p_information_category => p_information_category
947: );
948:
949: exception
950: when hr_api.cannot_find_prog_unit then
951: hr_api.cannot_find_prog_unit_error
952: (p_module_name => 'UPDATE_SPINAL_POINT_PLACEMENT'
953: ,p_hook_type => 'AP'
954: );

Line 951: hr_api.cannot_find_prog_unit_error

947: );
948:
949: exception
950: when hr_api.cannot_find_prog_unit then
951: hr_api.cannot_find_prog_unit_error
952: (p_module_name => 'UPDATE_SPINAL_POINT_PLACEMENT'
953: ,p_hook_type => 'AP'
954: );
955: end;

Line 975: raise hr_api.validate_enabled;

971: --
972: -- When in validation only mode raise the Validate_Enabled exception
973: --
974: if p_validate then
975: raise hr_api.validate_enabled;
976: end if;
977: --
978: --
979: p_gsp_post_process_warning := l_gsp_post_process_warning;

Line 984: when hr_api.validate_enabled then

980: --
981: --
982: hr_utility.set_location(' Leaving:'||l_proc, 70);
983: exception
984: when hr_api.validate_enabled then
985: --
986: -- As the Validate_Enabled exception has been raised
987: -- we must rollback to the savepoint
988: --

Line 1018: ,p_datetrack_mode in varchar2 default hr_api.g_delete

1014: --
1015: procedure delete_spp
1016: (p_validate in boolean default false
1017: ,p_effective_date in date
1018: ,p_datetrack_mode in varchar2 default hr_api.g_delete
1019: ,p_placement_id in number
1020: ,p_object_version_number in out nocopy number
1021: ,p_effective_start_date out nocopy date
1022: ,p_effective_end_date out nocopy date

Line 1036: hr_api.mandatory_arg_error

1032: l_temp_ovn number := p_object_version_number;
1033: --
1034: begin
1035: --
1036: hr_api.mandatory_arg_error
1037: (p_api_name => l_proc,
1038: p_argument => 'placement_id',
1039: p_argument_value => p_placement_id);
1040: --

Line 1041: hr_api.mandatory_arg_error

1037: (p_api_name => l_proc,
1038: p_argument => 'placement_id',
1039: p_argument_value => p_placement_id);
1040: --
1041: hr_api.mandatory_arg_error
1042: (p_api_name => l_proc,
1043: p_argument => 'effective_date',
1044: p_argument_value => p_effective_date);
1045: --

Line 1070: when hr_api.cannot_find_prog_unit then

1066: ,p_placement_id => p_placement_id
1067: ,p_object_version_number => p_object_version_number
1068: );
1069: exception
1070: when hr_api.cannot_find_prog_unit then
1071: hr_api.cannot_find_prog_unit_error
1072: (p_module_name => 'delete_spinal_point_placement'
1073: ,p_hook_type => 'BP'
1074: );

Line 1071: hr_api.cannot_find_prog_unit_error

1067: ,p_object_version_number => p_object_version_number
1068: );
1069: exception
1070: when hr_api.cannot_find_prog_unit then
1071: hr_api.cannot_find_prog_unit_error
1072: (p_module_name => 'delete_spinal_point_placement'
1073: ,p_hook_type => 'BP'
1074: );
1075: --

Line 1104: when hr_api.cannot_find_prog_unit then

1100: ,p_effective_start_date => l_effective_start_date
1101: ,p_effective_end_date => l_effective_end_date
1102: );
1103: exception
1104: when hr_api.cannot_find_prog_unit then
1105: hr_api.cannot_find_prog_unit_error
1106: (p_module_name => 'delete_spinal_point_placement'
1107: ,p_hook_type => 'AP'
1108: );

Line 1105: hr_api.cannot_find_prog_unit_error

1101: ,p_effective_end_date => l_effective_end_date
1102: );
1103: exception
1104: when hr_api.cannot_find_prog_unit then
1105: hr_api.cannot_find_prog_unit_error
1106: (p_module_name => 'delete_spinal_point_placement'
1107: ,p_hook_type => 'AP'
1108: );
1109: --

Line 1120: raise hr_api.validate_enabled;

1116: --
1117: -- When in validation only mode raise the Validate_Enabled exception
1118: --
1119: if p_validate then
1120: raise hr_api.validate_enabled;
1121: end if;
1122: --
1123: hr_utility.set_location(' Leaving:'||l_proc, 70);
1124: --

Line 1127: when hr_api.validate_enabled then

1123: hr_utility.set_location(' Leaving:'||l_proc, 70);
1124: --
1125: exception
1126: --
1127: when hr_api.validate_enabled then
1128: --
1129: -- As the Validate_Enabled exception has been raised
1130: -- we must rollback to the savepoint
1131: --