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 417: when hr_api.cannot_find_prog_unit then

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

Line 418: hr_api.cannot_find_prog_unit_error

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

Line 438: raise hr_api.validate_enabled;

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

Line 451: when hr_api.validate_enabled then

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

Line 491: ,p_datetrack_mode in varchar2 default hr_api.g_update

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

Line 494: ,p_step_id in number default hr_api.g_number

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

Line 495: ,p_auto_increment_flag in varchar2 default hr_api.g_varchar2

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

Line 496: ,p_reason in varchar2 default hr_api.g_varchar2

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

Line 497: ,p_request_id in number default hr_api.g_number

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

Line 498: ,p_program_application_id in number default hr_api.g_number

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

Line 499: ,p_program_id in number default hr_api.g_number

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

Line 500: ,p_program_update_date in date default hr_api.g_date

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

Line 501: ,p_increment_number in number default hr_api.g_number

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

Line 502: ,p_information1 in varchar2 default hr_api.g_varchar2

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

Line 503: ,p_information2 in varchar2 default hr_api.g_varchar2

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

Line 504: ,p_information3 in varchar2 default hr_api.g_varchar2

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

Line 505: ,p_information4 in varchar2 default hr_api.g_varchar2

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

Line 506: ,p_information5 in varchar2 default hr_api.g_varchar2

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

Line 507: ,p_information6 in varchar2 default hr_api.g_varchar2

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

Line 508: ,p_information7 in varchar2 default hr_api.g_varchar2

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

Line 509: ,p_information8 in varchar2 default hr_api.g_varchar2

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

Line 510: ,p_information9 in varchar2 default hr_api.g_varchar2

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

Line 511: ,p_information10 in varchar2 default hr_api.g_varchar2

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

Line 512: ,p_information11 in varchar2 default hr_api.g_varchar2

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

Line 513: ,p_information12 in varchar2 default hr_api.g_varchar2

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

Line 514: ,p_information13 in varchar2 default hr_api.g_varchar2

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

Line 515: ,p_information14 in varchar2 default hr_api.g_varchar2

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

Line 516: ,p_information15 in varchar2 default hr_api.g_varchar2

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

Line 517: ,p_information16 in varchar2 default hr_api.g_varchar2

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

Line 518: ,p_information17 in varchar2 default hr_api.g_varchar2

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

Line 519: ,p_information18 in varchar2 default hr_api.g_varchar2

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

Line 520: ,p_information19 in varchar2 default hr_api.g_varchar2

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

Line 521: ,p_information20 in varchar2 default hr_api.g_varchar2

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

Line 522: ,p_information21 in varchar2 default hr_api.g_varchar2

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

Line 523: ,p_information22 in varchar2 default hr_api.g_varchar2

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

Line 524: ,p_information23 in varchar2 default hr_api.g_varchar2

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

Line 525: ,p_information24 in varchar2 default hr_api.g_varchar2

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

Line 526: ,p_information25 in varchar2 default hr_api.g_varchar2

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

Line 527: ,p_information26 in varchar2 default hr_api.g_varchar2

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

Line 528: ,p_information27 in varchar2 default hr_api.g_varchar2

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

Line 529: ,p_information28 in varchar2 default hr_api.g_varchar2

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

Line 530: ,p_information29 in varchar2 default hr_api.g_varchar2

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

Line 531: ,p_information30 in varchar2 default hr_api.g_varchar2

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

Line 532: ,p_information_category in varchar2 default hr_api.g_varchar2

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

Line 639: ,p_datetrack_mode in varchar2 default hr_api.g_update

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

Line 642: ,p_step_id in number default hr_api.g_number

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

Line 643: ,p_auto_increment_flag in varchar2 default hr_api.g_varchar2

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

Line 644: ,p_reason in varchar2 default hr_api.g_varchar2

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

Line 645: ,p_request_id in number default hr_api.g_number

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

Line 646: ,p_program_application_id in number default hr_api.g_number

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

Line 647: ,p_program_id in number default hr_api.g_number

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

Line 648: ,p_program_update_date in date default hr_api.g_date

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

Line 649: ,p_increment_number in number default hr_api.g_number

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

Line 650: ,p_information1 in varchar2 default hr_api.g_varchar2

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

Line 651: ,p_information2 in varchar2 default hr_api.g_varchar2

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

Line 652: ,p_information3 in varchar2 default hr_api.g_varchar2

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

Line 653: ,p_information4 in varchar2 default hr_api.g_varchar2

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

Line 654: ,p_information5 in varchar2 default hr_api.g_varchar2

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

Line 655: ,p_information6 in varchar2 default hr_api.g_varchar2

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

Line 656: ,p_information7 in varchar2 default hr_api.g_varchar2

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

Line 657: ,p_information8 in varchar2 default hr_api.g_varchar2

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

Line 658: ,p_information9 in varchar2 default hr_api.g_varchar2

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

Line 659: ,p_information10 in varchar2 default hr_api.g_varchar2

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

Line 660: ,p_information11 in varchar2 default hr_api.g_varchar2

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

Line 661: ,p_information12 in varchar2 default hr_api.g_varchar2

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

Line 662: ,p_information13 in varchar2 default hr_api.g_varchar2

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

Line 663: ,p_information14 in varchar2 default hr_api.g_varchar2

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

Line 664: ,p_information15 in varchar2 default hr_api.g_varchar2

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

Line 665: ,p_information16 in varchar2 default hr_api.g_varchar2

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

Line 666: ,p_information17 in varchar2 default hr_api.g_varchar2

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

Line 667: ,p_information18 in varchar2 default hr_api.g_varchar2

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

Line 668: ,p_information19 in varchar2 default hr_api.g_varchar2

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

Line 669: ,p_information20 in varchar2 default hr_api.g_varchar2

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

Line 670: ,p_information21 in varchar2 default hr_api.g_varchar2

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

Line 671: ,p_information22 in varchar2 default hr_api.g_varchar2

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

Line 672: ,p_information23 in varchar2 default hr_api.g_varchar2

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

Line 673: ,p_information24 in varchar2 default hr_api.g_varchar2

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

Line 674: ,p_information25 in varchar2 default hr_api.g_varchar2

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

Line 675: ,p_information26 in varchar2 default hr_api.g_varchar2

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

Line 676: ,p_information27 in varchar2 default hr_api.g_varchar2

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

Line 677: ,p_information28 in varchar2 default hr_api.g_varchar2

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

Line 678: ,p_information29 in varchar2 default hr_api.g_varchar2

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

Line 679: ,p_information30 in varchar2 default hr_api.g_varchar2

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

Line 680: ,p_information_category in varchar2 default hr_api.g_varchar2

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

Line 725: hr_api.mandatory_arg_error

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

Line 730: hr_api.mandatory_arg_error

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

Line 735: hr_api.mandatory_arg_error

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

Line 823: when hr_api.cannot_find_prog_unit then

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

Line 824: hr_api.cannot_find_prog_unit_error

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

Line 949: when hr_api.cannot_find_prog_unit then

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

Line 950: hr_api.cannot_find_prog_unit_error

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

Line 974: raise hr_api.validate_enabled;

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

Line 983: when hr_api.validate_enabled then

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

Line 1017: ,p_datetrack_mode in varchar2 default hr_api.g_delete

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

Line 1035: hr_api.mandatory_arg_error

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

Line 1040: hr_api.mandatory_arg_error

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

Line 1069: when hr_api.cannot_find_prog_unit then

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

Line 1070: hr_api.cannot_find_prog_unit_error

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

Line 1103: when hr_api.cannot_find_prog_unit then

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

Line 1104: hr_api.cannot_find_prog_unit_error

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

Line 1119: raise hr_api.validate_enabled;

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

Line 1126: when hr_api.validate_enabled then

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