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_OBJECTIVES_SWI dependencies on HR_API

Line 111: (p_validate in number default hr_api.g_false_num

107: -- ----------------------------------------------------------------------------
108: -- |---------------------------< create_objective >---------------------------|
109: -- ----------------------------------------------------------------------------
110: PROCEDURE create_objective
111: (p_validate in number default hr_api.g_false_num
112: ,p_effective_date in date
113: ,p_business_group_id in number
114: ,p_name in varchar2
115: ,p_start_date in date

Line 207: hr_api.constant_to_boolean

203: --
204: -- Convert constant values to their corresponding boolean value
205: --
206: l_validate :=
207: hr_api.constant_to_boolean
208: (p_constant_value => p_validate);
209: --
210: -- Register Surrogate ID or user key values
211: --

Line 368: (p_validate in number default hr_api.g_false_num

364: -- ----------------------------------------------------------------------------
365: -- |---------------------------< delete_objective >---------------------------|
366: -- ----------------------------------------------------------------------------
367: PROCEDURE delete_objective
368: (p_validate in number default hr_api.g_false_num
369: ,p_objective_id in number
370: ,p_object_version_number in number
371: ,p_return_status out nocopy varchar2
372: ) is

Line 404: hr_api.constant_to_boolean

400: --
401: -- Convert constant values to their corresponding boolean value
402: --
403: l_validate :=
404: hr_api.constant_to_boolean
405: (p_constant_value => p_validate);
406: --
407: -- Register Surrogate ID or user key values
408: --

Line 478: (p_validate in number default hr_api.g_false_num

474: -- ----------------------------------------------------------------------------
475: -- |---------------------------< update_objective >---------------------------|
476: -- ----------------------------------------------------------------------------
477: PROCEDURE update_objective
478: (p_validate in number default hr_api.g_false_num
479: ,p_effective_date in date
480: ,p_objective_id in number
481: ,p_object_version_number in out nocopy number
482: ,p_name in varchar2 default hr_api.g_varchar2

Line 482: ,p_name in varchar2 default hr_api.g_varchar2

478: (p_validate in number default hr_api.g_false_num
479: ,p_effective_date in date
480: ,p_objective_id in number
481: ,p_object_version_number in out nocopy number
482: ,p_name in varchar2 default hr_api.g_varchar2
483: ,p_target_date in date default hr_api.g_date
484: ,p_start_date in date default hr_api.g_date
485: ,p_achievement_date in date default hr_api.g_date
486: ,p_detail in varchar2 default hr_api.g_varchar2

Line 483: ,p_target_date in date default hr_api.g_date

479: ,p_effective_date in date
480: ,p_objective_id in number
481: ,p_object_version_number in out nocopy number
482: ,p_name in varchar2 default hr_api.g_varchar2
483: ,p_target_date in date default hr_api.g_date
484: ,p_start_date in date default hr_api.g_date
485: ,p_achievement_date in date default hr_api.g_date
486: ,p_detail in varchar2 default hr_api.g_varchar2
487: ,p_comments in varchar2 default hr_api.g_varchar2

Line 484: ,p_start_date in date default hr_api.g_date

480: ,p_objective_id in number
481: ,p_object_version_number in out nocopy number
482: ,p_name in varchar2 default hr_api.g_varchar2
483: ,p_target_date in date default hr_api.g_date
484: ,p_start_date in date default hr_api.g_date
485: ,p_achievement_date in date default hr_api.g_date
486: ,p_detail in varchar2 default hr_api.g_varchar2
487: ,p_comments in varchar2 default hr_api.g_varchar2
488: ,p_success_criteria in varchar2 default hr_api.g_varchar2

Line 485: ,p_achievement_date in date default hr_api.g_date

481: ,p_object_version_number in out nocopy number
482: ,p_name in varchar2 default hr_api.g_varchar2
483: ,p_target_date in date default hr_api.g_date
484: ,p_start_date in date default hr_api.g_date
485: ,p_achievement_date in date default hr_api.g_date
486: ,p_detail in varchar2 default hr_api.g_varchar2
487: ,p_comments in varchar2 default hr_api.g_varchar2
488: ,p_success_criteria in varchar2 default hr_api.g_varchar2
489: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 486: ,p_detail in varchar2 default hr_api.g_varchar2

482: ,p_name in varchar2 default hr_api.g_varchar2
483: ,p_target_date in date default hr_api.g_date
484: ,p_start_date in date default hr_api.g_date
485: ,p_achievement_date in date default hr_api.g_date
486: ,p_detail in varchar2 default hr_api.g_varchar2
487: ,p_comments in varchar2 default hr_api.g_varchar2
488: ,p_success_criteria in varchar2 default hr_api.g_varchar2
489: ,p_attribute_category in varchar2 default hr_api.g_varchar2
490: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 487: ,p_comments in varchar2 default hr_api.g_varchar2

483: ,p_target_date in date default hr_api.g_date
484: ,p_start_date in date default hr_api.g_date
485: ,p_achievement_date in date default hr_api.g_date
486: ,p_detail in varchar2 default hr_api.g_varchar2
487: ,p_comments in varchar2 default hr_api.g_varchar2
488: ,p_success_criteria in varchar2 default hr_api.g_varchar2
489: ,p_attribute_category in varchar2 default hr_api.g_varchar2
490: ,p_attribute1 in varchar2 default hr_api.g_varchar2
491: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 488: ,p_success_criteria in varchar2 default hr_api.g_varchar2

484: ,p_start_date in date default hr_api.g_date
485: ,p_achievement_date in date default hr_api.g_date
486: ,p_detail in varchar2 default hr_api.g_varchar2
487: ,p_comments in varchar2 default hr_api.g_varchar2
488: ,p_success_criteria in varchar2 default hr_api.g_varchar2
489: ,p_attribute_category in varchar2 default hr_api.g_varchar2
490: ,p_attribute1 in varchar2 default hr_api.g_varchar2
491: ,p_attribute2 in varchar2 default hr_api.g_varchar2
492: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 489: ,p_attribute_category in varchar2 default hr_api.g_varchar2

485: ,p_achievement_date in date default hr_api.g_date
486: ,p_detail in varchar2 default hr_api.g_varchar2
487: ,p_comments in varchar2 default hr_api.g_varchar2
488: ,p_success_criteria in varchar2 default hr_api.g_varchar2
489: ,p_attribute_category in varchar2 default hr_api.g_varchar2
490: ,p_attribute1 in varchar2 default hr_api.g_varchar2
491: ,p_attribute2 in varchar2 default hr_api.g_varchar2
492: ,p_attribute3 in varchar2 default hr_api.g_varchar2
493: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 490: ,p_attribute1 in varchar2 default hr_api.g_varchar2

486: ,p_detail in varchar2 default hr_api.g_varchar2
487: ,p_comments in varchar2 default hr_api.g_varchar2
488: ,p_success_criteria in varchar2 default hr_api.g_varchar2
489: ,p_attribute_category in varchar2 default hr_api.g_varchar2
490: ,p_attribute1 in varchar2 default hr_api.g_varchar2
491: ,p_attribute2 in varchar2 default hr_api.g_varchar2
492: ,p_attribute3 in varchar2 default hr_api.g_varchar2
493: ,p_attribute4 in varchar2 default hr_api.g_varchar2
494: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 491: ,p_attribute2 in varchar2 default hr_api.g_varchar2

487: ,p_comments in varchar2 default hr_api.g_varchar2
488: ,p_success_criteria in varchar2 default hr_api.g_varchar2
489: ,p_attribute_category in varchar2 default hr_api.g_varchar2
490: ,p_attribute1 in varchar2 default hr_api.g_varchar2
491: ,p_attribute2 in varchar2 default hr_api.g_varchar2
492: ,p_attribute3 in varchar2 default hr_api.g_varchar2
493: ,p_attribute4 in varchar2 default hr_api.g_varchar2
494: ,p_attribute5 in varchar2 default hr_api.g_varchar2
495: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 492: ,p_attribute3 in varchar2 default hr_api.g_varchar2

488: ,p_success_criteria in varchar2 default hr_api.g_varchar2
489: ,p_attribute_category in varchar2 default hr_api.g_varchar2
490: ,p_attribute1 in varchar2 default hr_api.g_varchar2
491: ,p_attribute2 in varchar2 default hr_api.g_varchar2
492: ,p_attribute3 in varchar2 default hr_api.g_varchar2
493: ,p_attribute4 in varchar2 default hr_api.g_varchar2
494: ,p_attribute5 in varchar2 default hr_api.g_varchar2
495: ,p_attribute6 in varchar2 default hr_api.g_varchar2
496: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 493: ,p_attribute4 in varchar2 default hr_api.g_varchar2

489: ,p_attribute_category in varchar2 default hr_api.g_varchar2
490: ,p_attribute1 in varchar2 default hr_api.g_varchar2
491: ,p_attribute2 in varchar2 default hr_api.g_varchar2
492: ,p_attribute3 in varchar2 default hr_api.g_varchar2
493: ,p_attribute4 in varchar2 default hr_api.g_varchar2
494: ,p_attribute5 in varchar2 default hr_api.g_varchar2
495: ,p_attribute6 in varchar2 default hr_api.g_varchar2
496: ,p_attribute7 in varchar2 default hr_api.g_varchar2
497: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 494: ,p_attribute5 in varchar2 default hr_api.g_varchar2

490: ,p_attribute1 in varchar2 default hr_api.g_varchar2
491: ,p_attribute2 in varchar2 default hr_api.g_varchar2
492: ,p_attribute3 in varchar2 default hr_api.g_varchar2
493: ,p_attribute4 in varchar2 default hr_api.g_varchar2
494: ,p_attribute5 in varchar2 default hr_api.g_varchar2
495: ,p_attribute6 in varchar2 default hr_api.g_varchar2
496: ,p_attribute7 in varchar2 default hr_api.g_varchar2
497: ,p_attribute8 in varchar2 default hr_api.g_varchar2
498: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 495: ,p_attribute6 in varchar2 default hr_api.g_varchar2

491: ,p_attribute2 in varchar2 default hr_api.g_varchar2
492: ,p_attribute3 in varchar2 default hr_api.g_varchar2
493: ,p_attribute4 in varchar2 default hr_api.g_varchar2
494: ,p_attribute5 in varchar2 default hr_api.g_varchar2
495: ,p_attribute6 in varchar2 default hr_api.g_varchar2
496: ,p_attribute7 in varchar2 default hr_api.g_varchar2
497: ,p_attribute8 in varchar2 default hr_api.g_varchar2
498: ,p_attribute9 in varchar2 default hr_api.g_varchar2
499: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 496: ,p_attribute7 in varchar2 default hr_api.g_varchar2

492: ,p_attribute3 in varchar2 default hr_api.g_varchar2
493: ,p_attribute4 in varchar2 default hr_api.g_varchar2
494: ,p_attribute5 in varchar2 default hr_api.g_varchar2
495: ,p_attribute6 in varchar2 default hr_api.g_varchar2
496: ,p_attribute7 in varchar2 default hr_api.g_varchar2
497: ,p_attribute8 in varchar2 default hr_api.g_varchar2
498: ,p_attribute9 in varchar2 default hr_api.g_varchar2
499: ,p_attribute10 in varchar2 default hr_api.g_varchar2
500: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 497: ,p_attribute8 in varchar2 default hr_api.g_varchar2

493: ,p_attribute4 in varchar2 default hr_api.g_varchar2
494: ,p_attribute5 in varchar2 default hr_api.g_varchar2
495: ,p_attribute6 in varchar2 default hr_api.g_varchar2
496: ,p_attribute7 in varchar2 default hr_api.g_varchar2
497: ,p_attribute8 in varchar2 default hr_api.g_varchar2
498: ,p_attribute9 in varchar2 default hr_api.g_varchar2
499: ,p_attribute10 in varchar2 default hr_api.g_varchar2
500: ,p_attribute11 in varchar2 default hr_api.g_varchar2
501: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 498: ,p_attribute9 in varchar2 default hr_api.g_varchar2

494: ,p_attribute5 in varchar2 default hr_api.g_varchar2
495: ,p_attribute6 in varchar2 default hr_api.g_varchar2
496: ,p_attribute7 in varchar2 default hr_api.g_varchar2
497: ,p_attribute8 in varchar2 default hr_api.g_varchar2
498: ,p_attribute9 in varchar2 default hr_api.g_varchar2
499: ,p_attribute10 in varchar2 default hr_api.g_varchar2
500: ,p_attribute11 in varchar2 default hr_api.g_varchar2
501: ,p_attribute12 in varchar2 default hr_api.g_varchar2
502: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 499: ,p_attribute10 in varchar2 default hr_api.g_varchar2

495: ,p_attribute6 in varchar2 default hr_api.g_varchar2
496: ,p_attribute7 in varchar2 default hr_api.g_varchar2
497: ,p_attribute8 in varchar2 default hr_api.g_varchar2
498: ,p_attribute9 in varchar2 default hr_api.g_varchar2
499: ,p_attribute10 in varchar2 default hr_api.g_varchar2
500: ,p_attribute11 in varchar2 default hr_api.g_varchar2
501: ,p_attribute12 in varchar2 default hr_api.g_varchar2
502: ,p_attribute13 in varchar2 default hr_api.g_varchar2
503: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 500: ,p_attribute11 in varchar2 default hr_api.g_varchar2

496: ,p_attribute7 in varchar2 default hr_api.g_varchar2
497: ,p_attribute8 in varchar2 default hr_api.g_varchar2
498: ,p_attribute9 in varchar2 default hr_api.g_varchar2
499: ,p_attribute10 in varchar2 default hr_api.g_varchar2
500: ,p_attribute11 in varchar2 default hr_api.g_varchar2
501: ,p_attribute12 in varchar2 default hr_api.g_varchar2
502: ,p_attribute13 in varchar2 default hr_api.g_varchar2
503: ,p_attribute14 in varchar2 default hr_api.g_varchar2
504: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 501: ,p_attribute12 in varchar2 default hr_api.g_varchar2

497: ,p_attribute8 in varchar2 default hr_api.g_varchar2
498: ,p_attribute9 in varchar2 default hr_api.g_varchar2
499: ,p_attribute10 in varchar2 default hr_api.g_varchar2
500: ,p_attribute11 in varchar2 default hr_api.g_varchar2
501: ,p_attribute12 in varchar2 default hr_api.g_varchar2
502: ,p_attribute13 in varchar2 default hr_api.g_varchar2
503: ,p_attribute14 in varchar2 default hr_api.g_varchar2
504: ,p_attribute15 in varchar2 default hr_api.g_varchar2
505: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 502: ,p_attribute13 in varchar2 default hr_api.g_varchar2

498: ,p_attribute9 in varchar2 default hr_api.g_varchar2
499: ,p_attribute10 in varchar2 default hr_api.g_varchar2
500: ,p_attribute11 in varchar2 default hr_api.g_varchar2
501: ,p_attribute12 in varchar2 default hr_api.g_varchar2
502: ,p_attribute13 in varchar2 default hr_api.g_varchar2
503: ,p_attribute14 in varchar2 default hr_api.g_varchar2
504: ,p_attribute15 in varchar2 default hr_api.g_varchar2
505: ,p_attribute16 in varchar2 default hr_api.g_varchar2
506: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 503: ,p_attribute14 in varchar2 default hr_api.g_varchar2

499: ,p_attribute10 in varchar2 default hr_api.g_varchar2
500: ,p_attribute11 in varchar2 default hr_api.g_varchar2
501: ,p_attribute12 in varchar2 default hr_api.g_varchar2
502: ,p_attribute13 in varchar2 default hr_api.g_varchar2
503: ,p_attribute14 in varchar2 default hr_api.g_varchar2
504: ,p_attribute15 in varchar2 default hr_api.g_varchar2
505: ,p_attribute16 in varchar2 default hr_api.g_varchar2
506: ,p_attribute17 in varchar2 default hr_api.g_varchar2
507: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 504: ,p_attribute15 in varchar2 default hr_api.g_varchar2

500: ,p_attribute11 in varchar2 default hr_api.g_varchar2
501: ,p_attribute12 in varchar2 default hr_api.g_varchar2
502: ,p_attribute13 in varchar2 default hr_api.g_varchar2
503: ,p_attribute14 in varchar2 default hr_api.g_varchar2
504: ,p_attribute15 in varchar2 default hr_api.g_varchar2
505: ,p_attribute16 in varchar2 default hr_api.g_varchar2
506: ,p_attribute17 in varchar2 default hr_api.g_varchar2
507: ,p_attribute18 in varchar2 default hr_api.g_varchar2
508: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 505: ,p_attribute16 in varchar2 default hr_api.g_varchar2

501: ,p_attribute12 in varchar2 default hr_api.g_varchar2
502: ,p_attribute13 in varchar2 default hr_api.g_varchar2
503: ,p_attribute14 in varchar2 default hr_api.g_varchar2
504: ,p_attribute15 in varchar2 default hr_api.g_varchar2
505: ,p_attribute16 in varchar2 default hr_api.g_varchar2
506: ,p_attribute17 in varchar2 default hr_api.g_varchar2
507: ,p_attribute18 in varchar2 default hr_api.g_varchar2
508: ,p_attribute19 in varchar2 default hr_api.g_varchar2
509: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 506: ,p_attribute17 in varchar2 default hr_api.g_varchar2

502: ,p_attribute13 in varchar2 default hr_api.g_varchar2
503: ,p_attribute14 in varchar2 default hr_api.g_varchar2
504: ,p_attribute15 in varchar2 default hr_api.g_varchar2
505: ,p_attribute16 in varchar2 default hr_api.g_varchar2
506: ,p_attribute17 in varchar2 default hr_api.g_varchar2
507: ,p_attribute18 in varchar2 default hr_api.g_varchar2
508: ,p_attribute19 in varchar2 default hr_api.g_varchar2
509: ,p_attribute20 in varchar2 default hr_api.g_varchar2
510:

Line 507: ,p_attribute18 in varchar2 default hr_api.g_varchar2

503: ,p_attribute14 in varchar2 default hr_api.g_varchar2
504: ,p_attribute15 in varchar2 default hr_api.g_varchar2
505: ,p_attribute16 in varchar2 default hr_api.g_varchar2
506: ,p_attribute17 in varchar2 default hr_api.g_varchar2
507: ,p_attribute18 in varchar2 default hr_api.g_varchar2
508: ,p_attribute19 in varchar2 default hr_api.g_varchar2
509: ,p_attribute20 in varchar2 default hr_api.g_varchar2
510:
511: ,p_attribute21 in varchar2 default hr_api.g_varchar2

Line 508: ,p_attribute19 in varchar2 default hr_api.g_varchar2

504: ,p_attribute15 in varchar2 default hr_api.g_varchar2
505: ,p_attribute16 in varchar2 default hr_api.g_varchar2
506: ,p_attribute17 in varchar2 default hr_api.g_varchar2
507: ,p_attribute18 in varchar2 default hr_api.g_varchar2
508: ,p_attribute19 in varchar2 default hr_api.g_varchar2
509: ,p_attribute20 in varchar2 default hr_api.g_varchar2
510:
511: ,p_attribute21 in varchar2 default hr_api.g_varchar2
512: ,p_attribute22 in varchar2 default hr_api.g_varchar2

Line 509: ,p_attribute20 in varchar2 default hr_api.g_varchar2

505: ,p_attribute16 in varchar2 default hr_api.g_varchar2
506: ,p_attribute17 in varchar2 default hr_api.g_varchar2
507: ,p_attribute18 in varchar2 default hr_api.g_varchar2
508: ,p_attribute19 in varchar2 default hr_api.g_varchar2
509: ,p_attribute20 in varchar2 default hr_api.g_varchar2
510:
511: ,p_attribute21 in varchar2 default hr_api.g_varchar2
512: ,p_attribute22 in varchar2 default hr_api.g_varchar2
513: ,p_attribute23 in varchar2 default hr_api.g_varchar2

Line 511: ,p_attribute21 in varchar2 default hr_api.g_varchar2

507: ,p_attribute18 in varchar2 default hr_api.g_varchar2
508: ,p_attribute19 in varchar2 default hr_api.g_varchar2
509: ,p_attribute20 in varchar2 default hr_api.g_varchar2
510:
511: ,p_attribute21 in varchar2 default hr_api.g_varchar2
512: ,p_attribute22 in varchar2 default hr_api.g_varchar2
513: ,p_attribute23 in varchar2 default hr_api.g_varchar2
514: ,p_attribute24 in varchar2 default hr_api.g_varchar2
515: ,p_attribute25 in varchar2 default hr_api.g_varchar2

Line 512: ,p_attribute22 in varchar2 default hr_api.g_varchar2

508: ,p_attribute19 in varchar2 default hr_api.g_varchar2
509: ,p_attribute20 in varchar2 default hr_api.g_varchar2
510:
511: ,p_attribute21 in varchar2 default hr_api.g_varchar2
512: ,p_attribute22 in varchar2 default hr_api.g_varchar2
513: ,p_attribute23 in varchar2 default hr_api.g_varchar2
514: ,p_attribute24 in varchar2 default hr_api.g_varchar2
515: ,p_attribute25 in varchar2 default hr_api.g_varchar2
516: ,p_attribute26 in varchar2 default hr_api.g_varchar2

Line 513: ,p_attribute23 in varchar2 default hr_api.g_varchar2

509: ,p_attribute20 in varchar2 default hr_api.g_varchar2
510:
511: ,p_attribute21 in varchar2 default hr_api.g_varchar2
512: ,p_attribute22 in varchar2 default hr_api.g_varchar2
513: ,p_attribute23 in varchar2 default hr_api.g_varchar2
514: ,p_attribute24 in varchar2 default hr_api.g_varchar2
515: ,p_attribute25 in varchar2 default hr_api.g_varchar2
516: ,p_attribute26 in varchar2 default hr_api.g_varchar2
517: ,p_attribute27 in varchar2 default hr_api.g_varchar2

Line 514: ,p_attribute24 in varchar2 default hr_api.g_varchar2

510:
511: ,p_attribute21 in varchar2 default hr_api.g_varchar2
512: ,p_attribute22 in varchar2 default hr_api.g_varchar2
513: ,p_attribute23 in varchar2 default hr_api.g_varchar2
514: ,p_attribute24 in varchar2 default hr_api.g_varchar2
515: ,p_attribute25 in varchar2 default hr_api.g_varchar2
516: ,p_attribute26 in varchar2 default hr_api.g_varchar2
517: ,p_attribute27 in varchar2 default hr_api.g_varchar2
518: ,p_attribute28 in varchar2 default hr_api.g_varchar2

Line 515: ,p_attribute25 in varchar2 default hr_api.g_varchar2

511: ,p_attribute21 in varchar2 default hr_api.g_varchar2
512: ,p_attribute22 in varchar2 default hr_api.g_varchar2
513: ,p_attribute23 in varchar2 default hr_api.g_varchar2
514: ,p_attribute24 in varchar2 default hr_api.g_varchar2
515: ,p_attribute25 in varchar2 default hr_api.g_varchar2
516: ,p_attribute26 in varchar2 default hr_api.g_varchar2
517: ,p_attribute27 in varchar2 default hr_api.g_varchar2
518: ,p_attribute28 in varchar2 default hr_api.g_varchar2
519: ,p_attribute29 in varchar2 default hr_api.g_varchar2

Line 516: ,p_attribute26 in varchar2 default hr_api.g_varchar2

512: ,p_attribute22 in varchar2 default hr_api.g_varchar2
513: ,p_attribute23 in varchar2 default hr_api.g_varchar2
514: ,p_attribute24 in varchar2 default hr_api.g_varchar2
515: ,p_attribute25 in varchar2 default hr_api.g_varchar2
516: ,p_attribute26 in varchar2 default hr_api.g_varchar2
517: ,p_attribute27 in varchar2 default hr_api.g_varchar2
518: ,p_attribute28 in varchar2 default hr_api.g_varchar2
519: ,p_attribute29 in varchar2 default hr_api.g_varchar2
520: ,p_attribute30 in varchar2 default hr_api.g_varchar2

Line 517: ,p_attribute27 in varchar2 default hr_api.g_varchar2

513: ,p_attribute23 in varchar2 default hr_api.g_varchar2
514: ,p_attribute24 in varchar2 default hr_api.g_varchar2
515: ,p_attribute25 in varchar2 default hr_api.g_varchar2
516: ,p_attribute26 in varchar2 default hr_api.g_varchar2
517: ,p_attribute27 in varchar2 default hr_api.g_varchar2
518: ,p_attribute28 in varchar2 default hr_api.g_varchar2
519: ,p_attribute29 in varchar2 default hr_api.g_varchar2
520: ,p_attribute30 in varchar2 default hr_api.g_varchar2
521: ,p_scorecard_id in number default hr_api.g_number

Line 518: ,p_attribute28 in varchar2 default hr_api.g_varchar2

514: ,p_attribute24 in varchar2 default hr_api.g_varchar2
515: ,p_attribute25 in varchar2 default hr_api.g_varchar2
516: ,p_attribute26 in varchar2 default hr_api.g_varchar2
517: ,p_attribute27 in varchar2 default hr_api.g_varchar2
518: ,p_attribute28 in varchar2 default hr_api.g_varchar2
519: ,p_attribute29 in varchar2 default hr_api.g_varchar2
520: ,p_attribute30 in varchar2 default hr_api.g_varchar2
521: ,p_scorecard_id in number default hr_api.g_number
522: ,p_copied_from_library_id in number default hr_api.g_number

Line 519: ,p_attribute29 in varchar2 default hr_api.g_varchar2

515: ,p_attribute25 in varchar2 default hr_api.g_varchar2
516: ,p_attribute26 in varchar2 default hr_api.g_varchar2
517: ,p_attribute27 in varchar2 default hr_api.g_varchar2
518: ,p_attribute28 in varchar2 default hr_api.g_varchar2
519: ,p_attribute29 in varchar2 default hr_api.g_varchar2
520: ,p_attribute30 in varchar2 default hr_api.g_varchar2
521: ,p_scorecard_id in number default hr_api.g_number
522: ,p_copied_from_library_id in number default hr_api.g_number
523: ,p_copied_from_objective_id in number default hr_api.g_number

Line 520: ,p_attribute30 in varchar2 default hr_api.g_varchar2

516: ,p_attribute26 in varchar2 default hr_api.g_varchar2
517: ,p_attribute27 in varchar2 default hr_api.g_varchar2
518: ,p_attribute28 in varchar2 default hr_api.g_varchar2
519: ,p_attribute29 in varchar2 default hr_api.g_varchar2
520: ,p_attribute30 in varchar2 default hr_api.g_varchar2
521: ,p_scorecard_id in number default hr_api.g_number
522: ,p_copied_from_library_id in number default hr_api.g_number
523: ,p_copied_from_objective_id in number default hr_api.g_number
524: ,p_aligned_with_objective_id in number default hr_api.g_number

Line 521: ,p_scorecard_id in number default hr_api.g_number

517: ,p_attribute27 in varchar2 default hr_api.g_varchar2
518: ,p_attribute28 in varchar2 default hr_api.g_varchar2
519: ,p_attribute29 in varchar2 default hr_api.g_varchar2
520: ,p_attribute30 in varchar2 default hr_api.g_varchar2
521: ,p_scorecard_id in number default hr_api.g_number
522: ,p_copied_from_library_id in number default hr_api.g_number
523: ,p_copied_from_objective_id in number default hr_api.g_number
524: ,p_aligned_with_objective_id in number default hr_api.g_number
525: ,p_next_review_date in date default hr_api.g_date

Line 522: ,p_copied_from_library_id in number default hr_api.g_number

518: ,p_attribute28 in varchar2 default hr_api.g_varchar2
519: ,p_attribute29 in varchar2 default hr_api.g_varchar2
520: ,p_attribute30 in varchar2 default hr_api.g_varchar2
521: ,p_scorecard_id in number default hr_api.g_number
522: ,p_copied_from_library_id in number default hr_api.g_number
523: ,p_copied_from_objective_id in number default hr_api.g_number
524: ,p_aligned_with_objective_id in number default hr_api.g_number
525: ,p_next_review_date in date default hr_api.g_date
526: ,p_group_code in varchar2 default hr_api.g_varchar2

Line 523: ,p_copied_from_objective_id in number default hr_api.g_number

519: ,p_attribute29 in varchar2 default hr_api.g_varchar2
520: ,p_attribute30 in varchar2 default hr_api.g_varchar2
521: ,p_scorecard_id in number default hr_api.g_number
522: ,p_copied_from_library_id in number default hr_api.g_number
523: ,p_copied_from_objective_id in number default hr_api.g_number
524: ,p_aligned_with_objective_id in number default hr_api.g_number
525: ,p_next_review_date in date default hr_api.g_date
526: ,p_group_code in varchar2 default hr_api.g_varchar2
527: ,p_priority_code in varchar2 default hr_api.g_varchar2

Line 524: ,p_aligned_with_objective_id in number default hr_api.g_number

520: ,p_attribute30 in varchar2 default hr_api.g_varchar2
521: ,p_scorecard_id in number default hr_api.g_number
522: ,p_copied_from_library_id in number default hr_api.g_number
523: ,p_copied_from_objective_id in number default hr_api.g_number
524: ,p_aligned_with_objective_id in number default hr_api.g_number
525: ,p_next_review_date in date default hr_api.g_date
526: ,p_group_code in varchar2 default hr_api.g_varchar2
527: ,p_priority_code in varchar2 default hr_api.g_varchar2
528: ,p_appraise_flag in varchar2 default hr_api.g_varchar2

Line 525: ,p_next_review_date in date default hr_api.g_date

521: ,p_scorecard_id in number default hr_api.g_number
522: ,p_copied_from_library_id in number default hr_api.g_number
523: ,p_copied_from_objective_id in number default hr_api.g_number
524: ,p_aligned_with_objective_id in number default hr_api.g_number
525: ,p_next_review_date in date default hr_api.g_date
526: ,p_group_code in varchar2 default hr_api.g_varchar2
527: ,p_priority_code in varchar2 default hr_api.g_varchar2
528: ,p_appraise_flag in varchar2 default hr_api.g_varchar2
529: ,p_verified_flag in varchar2 default hr_api.g_varchar2

Line 526: ,p_group_code in varchar2 default hr_api.g_varchar2

522: ,p_copied_from_library_id in number default hr_api.g_number
523: ,p_copied_from_objective_id in number default hr_api.g_number
524: ,p_aligned_with_objective_id in number default hr_api.g_number
525: ,p_next_review_date in date default hr_api.g_date
526: ,p_group_code in varchar2 default hr_api.g_varchar2
527: ,p_priority_code in varchar2 default hr_api.g_varchar2
528: ,p_appraise_flag in varchar2 default hr_api.g_varchar2
529: ,p_verified_flag in varchar2 default hr_api.g_varchar2
530: ,p_target_value in number default hr_api.g_number

Line 527: ,p_priority_code in varchar2 default hr_api.g_varchar2

523: ,p_copied_from_objective_id in number default hr_api.g_number
524: ,p_aligned_with_objective_id in number default hr_api.g_number
525: ,p_next_review_date in date default hr_api.g_date
526: ,p_group_code in varchar2 default hr_api.g_varchar2
527: ,p_priority_code in varchar2 default hr_api.g_varchar2
528: ,p_appraise_flag in varchar2 default hr_api.g_varchar2
529: ,p_verified_flag in varchar2 default hr_api.g_varchar2
530: ,p_target_value in number default hr_api.g_number
531: ,p_actual_value in number default hr_api.g_number

Line 528: ,p_appraise_flag in varchar2 default hr_api.g_varchar2

524: ,p_aligned_with_objective_id in number default hr_api.g_number
525: ,p_next_review_date in date default hr_api.g_date
526: ,p_group_code in varchar2 default hr_api.g_varchar2
527: ,p_priority_code in varchar2 default hr_api.g_varchar2
528: ,p_appraise_flag in varchar2 default hr_api.g_varchar2
529: ,p_verified_flag in varchar2 default hr_api.g_varchar2
530: ,p_target_value in number default hr_api.g_number
531: ,p_actual_value in number default hr_api.g_number
532: ,p_weighting_percent in number default hr_api.g_number

Line 529: ,p_verified_flag in varchar2 default hr_api.g_varchar2

525: ,p_next_review_date in date default hr_api.g_date
526: ,p_group_code in varchar2 default hr_api.g_varchar2
527: ,p_priority_code in varchar2 default hr_api.g_varchar2
528: ,p_appraise_flag in varchar2 default hr_api.g_varchar2
529: ,p_verified_flag in varchar2 default hr_api.g_varchar2
530: ,p_target_value in number default hr_api.g_number
531: ,p_actual_value in number default hr_api.g_number
532: ,p_weighting_percent in number default hr_api.g_number
533: ,p_complete_percent in number default hr_api.g_number

Line 530: ,p_target_value in number default hr_api.g_number

526: ,p_group_code in varchar2 default hr_api.g_varchar2
527: ,p_priority_code in varchar2 default hr_api.g_varchar2
528: ,p_appraise_flag in varchar2 default hr_api.g_varchar2
529: ,p_verified_flag in varchar2 default hr_api.g_varchar2
530: ,p_target_value in number default hr_api.g_number
531: ,p_actual_value in number default hr_api.g_number
532: ,p_weighting_percent in number default hr_api.g_number
533: ,p_complete_percent in number default hr_api.g_number
534: ,p_uom_code in varchar2 default hr_api.g_varchar2

Line 531: ,p_actual_value in number default hr_api.g_number

527: ,p_priority_code in varchar2 default hr_api.g_varchar2
528: ,p_appraise_flag in varchar2 default hr_api.g_varchar2
529: ,p_verified_flag in varchar2 default hr_api.g_varchar2
530: ,p_target_value in number default hr_api.g_number
531: ,p_actual_value in number default hr_api.g_number
532: ,p_weighting_percent in number default hr_api.g_number
533: ,p_complete_percent in number default hr_api.g_number
534: ,p_uom_code in varchar2 default hr_api.g_varchar2
535: ,p_measurement_style_code in varchar2 default hr_api.g_varchar2

Line 532: ,p_weighting_percent in number default hr_api.g_number

528: ,p_appraise_flag in varchar2 default hr_api.g_varchar2
529: ,p_verified_flag in varchar2 default hr_api.g_varchar2
530: ,p_target_value in number default hr_api.g_number
531: ,p_actual_value in number default hr_api.g_number
532: ,p_weighting_percent in number default hr_api.g_number
533: ,p_complete_percent in number default hr_api.g_number
534: ,p_uom_code in varchar2 default hr_api.g_varchar2
535: ,p_measurement_style_code in varchar2 default hr_api.g_varchar2
536: ,p_measure_name in varchar2 default hr_api.g_varchar2

Line 533: ,p_complete_percent in number default hr_api.g_number

529: ,p_verified_flag in varchar2 default hr_api.g_varchar2
530: ,p_target_value in number default hr_api.g_number
531: ,p_actual_value in number default hr_api.g_number
532: ,p_weighting_percent in number default hr_api.g_number
533: ,p_complete_percent in number default hr_api.g_number
534: ,p_uom_code in varchar2 default hr_api.g_varchar2
535: ,p_measurement_style_code in varchar2 default hr_api.g_varchar2
536: ,p_measure_name in varchar2 default hr_api.g_varchar2
537: ,p_measure_type_code in varchar2 default hr_api.g_varchar2

Line 534: ,p_uom_code in varchar2 default hr_api.g_varchar2

530: ,p_target_value in number default hr_api.g_number
531: ,p_actual_value in number default hr_api.g_number
532: ,p_weighting_percent in number default hr_api.g_number
533: ,p_complete_percent in number default hr_api.g_number
534: ,p_uom_code in varchar2 default hr_api.g_varchar2
535: ,p_measurement_style_code in varchar2 default hr_api.g_varchar2
536: ,p_measure_name in varchar2 default hr_api.g_varchar2
537: ,p_measure_type_code in varchar2 default hr_api.g_varchar2
538: ,p_measure_comments in varchar2 default hr_api.g_varchar2

Line 535: ,p_measurement_style_code in varchar2 default hr_api.g_varchar2

531: ,p_actual_value in number default hr_api.g_number
532: ,p_weighting_percent in number default hr_api.g_number
533: ,p_complete_percent in number default hr_api.g_number
534: ,p_uom_code in varchar2 default hr_api.g_varchar2
535: ,p_measurement_style_code in varchar2 default hr_api.g_varchar2
536: ,p_measure_name in varchar2 default hr_api.g_varchar2
537: ,p_measure_type_code in varchar2 default hr_api.g_varchar2
538: ,p_measure_comments in varchar2 default hr_api.g_varchar2
539: ,p_sharing_access_code in varchar2 default hr_api.g_varchar2

Line 536: ,p_measure_name in varchar2 default hr_api.g_varchar2

532: ,p_weighting_percent in number default hr_api.g_number
533: ,p_complete_percent in number default hr_api.g_number
534: ,p_uom_code in varchar2 default hr_api.g_varchar2
535: ,p_measurement_style_code in varchar2 default hr_api.g_varchar2
536: ,p_measure_name in varchar2 default hr_api.g_varchar2
537: ,p_measure_type_code in varchar2 default hr_api.g_varchar2
538: ,p_measure_comments in varchar2 default hr_api.g_varchar2
539: ,p_sharing_access_code in varchar2 default hr_api.g_varchar2
540: ,p_appraisal_id in number default hr_api.g_number

Line 537: ,p_measure_type_code in varchar2 default hr_api.g_varchar2

533: ,p_complete_percent in number default hr_api.g_number
534: ,p_uom_code in varchar2 default hr_api.g_varchar2
535: ,p_measurement_style_code in varchar2 default hr_api.g_varchar2
536: ,p_measure_name in varchar2 default hr_api.g_varchar2
537: ,p_measure_type_code in varchar2 default hr_api.g_varchar2
538: ,p_measure_comments in varchar2 default hr_api.g_varchar2
539: ,p_sharing_access_code in varchar2 default hr_api.g_varchar2
540: ,p_appraisal_id in number default hr_api.g_number
541: ,p_return_status out nocopy varchar2

Line 538: ,p_measure_comments in varchar2 default hr_api.g_varchar2

534: ,p_uom_code in varchar2 default hr_api.g_varchar2
535: ,p_measurement_style_code in varchar2 default hr_api.g_varchar2
536: ,p_measure_name in varchar2 default hr_api.g_varchar2
537: ,p_measure_type_code in varchar2 default hr_api.g_varchar2
538: ,p_measure_comments in varchar2 default hr_api.g_varchar2
539: ,p_sharing_access_code in varchar2 default hr_api.g_varchar2
540: ,p_appraisal_id in number default hr_api.g_number
541: ,p_return_status out nocopy varchar2
542: ) is

Line 539: ,p_sharing_access_code in varchar2 default hr_api.g_varchar2

535: ,p_measurement_style_code in varchar2 default hr_api.g_varchar2
536: ,p_measure_name in varchar2 default hr_api.g_varchar2
537: ,p_measure_type_code in varchar2 default hr_api.g_varchar2
538: ,p_measure_comments in varchar2 default hr_api.g_varchar2
539: ,p_sharing_access_code in varchar2 default hr_api.g_varchar2
540: ,p_appraisal_id in number default hr_api.g_number
541: ,p_return_status out nocopy varchar2
542: ) is
543: --

Line 540: ,p_appraisal_id in number default hr_api.g_number

536: ,p_measure_name in varchar2 default hr_api.g_varchar2
537: ,p_measure_type_code in varchar2 default hr_api.g_varchar2
538: ,p_measure_comments in varchar2 default hr_api.g_varchar2
539: ,p_sharing_access_code in varchar2 default hr_api.g_varchar2
540: ,p_appraisal_id in number default hr_api.g_number
541: ,p_return_status out nocopy varchar2
542: ) is
543: --
544: -- Variables for API Boolean parameters

Line 586: hr_api.constant_to_boolean

582: --
583: -- Convert constant values to their corresponding boolean value
584: --
585: l_validate :=
586: hr_api.constant_to_boolean
587: (p_constant_value => p_validate);
588: --
589: -- Register Surrogate ID or user key values
590: --

Line 603: if(p_copied_from_objective_id = hr_api.g_number) then

599: l_aligned_with_objective_id := p_aligned_with_objective_id;
600: l_scorecard_id := p_scorecard_id;
601: l_appraisal_id := p_appraisal_id;
602:
603: if(p_copied_from_objective_id = hr_api.g_number) then
604: l_copied_from_objective_id := t_copied_from_objective_id;
605: end if;
606:
607: if(p_aligned_with_objective_id = hr_api.g_number) then

Line 607: if(p_aligned_with_objective_id = hr_api.g_number) then

603: if(p_copied_from_objective_id = hr_api.g_number) then
604: l_copied_from_objective_id := t_copied_from_objective_id;
605: end if;
606:
607: if(p_aligned_with_objective_id = hr_api.g_number) then
608: l_aligned_with_objective_id := t_aligned_with_objective_id;
609: end if;
610:
611: if(p_scorecard_id = hr_api.g_number) then

Line 611: if(p_scorecard_id = hr_api.g_number) then

607: if(p_aligned_with_objective_id = hr_api.g_number) then
608: l_aligned_with_objective_id := t_aligned_with_objective_id;
609: end if;
610:
611: if(p_scorecard_id = hr_api.g_number) then
612: l_scorecard_id := t_scorecard_id;
613: end if;
614:
615: if(p_appraisal_id = hr_api.g_number) then

Line 615: if(p_appraisal_id = hr_api.g_number) then

611: if(p_scorecard_id = hr_api.g_number) then
612: l_scorecard_id := t_scorecard_id;
613: end if;
614:
615: if(p_appraisal_id = hr_api.g_number) then
616: l_appraisal_id := t_appraisal_id;
617: end if;
618:
619: --

Line 772: ,p_validate in number default hr_api.g_false_num

768:
769: Procedure process_api
770: ( p_document in CLOB
771: ,p_return_status out nocopy VARCHAR2
772: ,p_validate in number default hr_api.g_false_num
773: ,p_effective_date in date default null
774: )
775: IS
776: l_postState VARCHAR2(2);

Line 883: if( hr_transaction_swi.getNumberValue(l_CommitNode,'AlignedWithObjectiveId',null) = hr_api.g_number ) then

879: elsif l_postState = '2' then
880:
881: --7795134 check_cascade will directly process the AlignedWithObjectiveId from transaction doc.Changed the value before calling the api
882:
883: if( hr_transaction_swi.getNumberValue(l_CommitNode,'AlignedWithObjectiveId',null) = hr_api.g_number ) then
884: open chk_aligned_with_obj_id(hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectiveId'));
885: fetch chk_aligned_with_obj_id into l_aligned_with_objective_id;
886: close chk_aligned_with_obj_id;
887: end if;