DBA Data[Home] [Help]

APPS.PER_SUC_UPD dependencies on HR_API

Line 119: WHEN hr_api.check_integrity_violated

115: --
116: hr_utility.set_location (' Leaving:' || l_proc, 10);
117: --
118: EXCEPTION
119: WHEN hr_api.check_integrity_violated
120: THEN
121: -- A check constraint has been violated
122: per_suc_shd.g_api_dml := FALSE; -- Unset the api dml status
123: per_suc_shd.constraint_error (p_constraint_name => hr_api.strip_constraint_name

Line 123: per_suc_shd.constraint_error (p_constraint_name => hr_api.strip_constraint_name

119: WHEN hr_api.check_integrity_violated
120: THEN
121: -- A check constraint has been violated
122: per_suc_shd.g_api_dml := FALSE; -- Unset the api dml status
123: per_suc_shd.constraint_error (p_constraint_name => hr_api.strip_constraint_name
124: (SQLERRM));
125: WHEN hr_api.parent_integrity_violated
126: THEN
127: -- Parent integrity has been violated

Line 125: WHEN hr_api.parent_integrity_violated

121: -- A check constraint has been violated
122: per_suc_shd.g_api_dml := FALSE; -- Unset the api dml status
123: per_suc_shd.constraint_error (p_constraint_name => hr_api.strip_constraint_name
124: (SQLERRM));
125: WHEN hr_api.parent_integrity_violated
126: THEN
127: -- Parent integrity has been violated
128: per_suc_shd.g_api_dml := FALSE; -- Unset the api dml status
129: per_suc_shd.constraint_error (p_constraint_name => hr_api.strip_constraint_name

Line 129: per_suc_shd.constraint_error (p_constraint_name => hr_api.strip_constraint_name

125: WHEN hr_api.parent_integrity_violated
126: THEN
127: -- Parent integrity has been violated
128: per_suc_shd.g_api_dml := FALSE; -- Unset the api dml status
129: per_suc_shd.constraint_error (p_constraint_name => hr_api.strip_constraint_name
130: (SQLERRM));
131: WHEN hr_api.unique_integrity_violated
132: THEN
133: -- Unique integrity has been violated

Line 131: WHEN hr_api.unique_integrity_violated

127: -- Parent integrity has been violated
128: per_suc_shd.g_api_dml := FALSE; -- Unset the api dml status
129: per_suc_shd.constraint_error (p_constraint_name => hr_api.strip_constraint_name
130: (SQLERRM));
131: WHEN hr_api.unique_integrity_violated
132: THEN
133: -- Unique integrity has been violated
134: per_suc_shd.g_api_dml := FALSE; -- Unset the api dml status
135: per_suc_shd.constraint_error (p_constraint_name => hr_api.strip_constraint_name

Line 135: per_suc_shd.constraint_error (p_constraint_name => hr_api.strip_constraint_name

131: WHEN hr_api.unique_integrity_violated
132: THEN
133: -- Unique integrity has been violated
134: per_suc_shd.g_api_dml := FALSE; -- Unset the api dml status
135: per_suc_shd.constraint_error (p_constraint_name => hr_api.strip_constraint_name
136: (SQLERRM));
137: WHEN OTHERS
138: THEN
139: per_suc_shd.g_api_dml := FALSE; -- Unset the api dml status

Line 309: WHEN hr_api.cannot_find_prog_unit

305: p_plan_status_o => per_suc_shd.g_old_rec.plan_status,
306: p_readiness_percentage_o => per_suc_shd.g_old_rec.readiness_percentage
307: );
308: EXCEPTION
309: WHEN hr_api.cannot_find_prog_unit
310: THEN
311: hr_api.cannot_find_prog_unit_error (p_module_name => 'PER_SUCCESSION_PLANNING',
312: p_hook_type => 'AU'
313: );

Line 311: hr_api.cannot_find_prog_unit_error (p_module_name => 'PER_SUCCESSION_PLANNING',

307: );
308: EXCEPTION
309: WHEN hr_api.cannot_find_prog_unit
310: THEN
311: hr_api.cannot_find_prog_unit_error (p_module_name => 'PER_SUCCESSION_PLANNING',
312: p_hook_type => 'AU'
313: );
314: END;
315:

Line 382: IF (p_rec.person_id = hr_api.g_number)

378: -- p_rec plsql record structure
379: -- to see if a system default is being used. If a system default
380: -- is being used then we must set to the 'current' argument value.
381: --
382: IF (p_rec.person_id = hr_api.g_number)
383: THEN
384: p_rec.person_id := per_suc_shd.g_old_rec.person_id;
385: END IF;
386:

Line 387: IF (p_rec.position_id = hr_api.g_number)

383: THEN
384: p_rec.person_id := per_suc_shd.g_old_rec.person_id;
385: END IF;
386:
387: IF (p_rec.position_id = hr_api.g_number)
388: THEN
389: p_rec.position_id := per_suc_shd.g_old_rec.position_id;
390: END IF;
391:

Line 392: IF (p_rec.business_group_id = hr_api.g_number)

388: THEN
389: p_rec.position_id := per_suc_shd.g_old_rec.position_id;
390: END IF;
391:
392: IF (p_rec.business_group_id = hr_api.g_number)
393: THEN
394: p_rec.business_group_id := per_suc_shd.g_old_rec.business_group_id;
395: END IF;
396:

Line 397: IF (p_rec.start_date = hr_api.g_date)

393: THEN
394: p_rec.business_group_id := per_suc_shd.g_old_rec.business_group_id;
395: END IF;
396:
397: IF (p_rec.start_date = hr_api.g_date)
398: THEN
399: p_rec.start_date := per_suc_shd.g_old_rec.start_date;
400: END IF;
401:

Line 402: IF (p_rec.time_scale = hr_api.g_varchar2)

398: THEN
399: p_rec.start_date := per_suc_shd.g_old_rec.start_date;
400: END IF;
401:
402: IF (p_rec.time_scale = hr_api.g_varchar2)
403: THEN
404: p_rec.time_scale := per_suc_shd.g_old_rec.time_scale;
405: END IF;
406:

Line 407: IF (p_rec.end_date = hr_api.g_date)

403: THEN
404: p_rec.time_scale := per_suc_shd.g_old_rec.time_scale;
405: END IF;
406:
407: IF (p_rec.end_date = hr_api.g_date)
408: THEN
409: p_rec.end_date := per_suc_shd.g_old_rec.end_date;
410: END IF;
411:

Line 412: IF (p_rec.available_for_promotion = hr_api.g_varchar2)

408: THEN
409: p_rec.end_date := per_suc_shd.g_old_rec.end_date;
410: END IF;
411:
412: IF (p_rec.available_for_promotion = hr_api.g_varchar2)
413: THEN
414: p_rec.available_for_promotion := per_suc_shd.g_old_rec.available_for_promotion;
415: END IF;
416:

Line 417: IF (p_rec.manager_comments = hr_api.g_varchar2)

413: THEN
414: p_rec.available_for_promotion := per_suc_shd.g_old_rec.available_for_promotion;
415: END IF;
416:
417: IF (p_rec.manager_comments = hr_api.g_varchar2)
418: THEN
419: p_rec.manager_comments := per_suc_shd.g_old_rec.manager_comments;
420: END IF;
421:

Line 422: IF (p_rec.attribute_category = hr_api.g_varchar2)

418: THEN
419: p_rec.manager_comments := per_suc_shd.g_old_rec.manager_comments;
420: END IF;
421:
422: IF (p_rec.attribute_category = hr_api.g_varchar2)
423: THEN
424: p_rec.attribute_category := per_suc_shd.g_old_rec.attribute_category;
425: END IF;
426:

Line 427: IF (p_rec.attribute1 = hr_api.g_varchar2)

423: THEN
424: p_rec.attribute_category := per_suc_shd.g_old_rec.attribute_category;
425: END IF;
426:
427: IF (p_rec.attribute1 = hr_api.g_varchar2)
428: THEN
429: p_rec.attribute1 := per_suc_shd.g_old_rec.attribute1;
430: END IF;
431:

Line 432: IF (p_rec.attribute2 = hr_api.g_varchar2)

428: THEN
429: p_rec.attribute1 := per_suc_shd.g_old_rec.attribute1;
430: END IF;
431:
432: IF (p_rec.attribute2 = hr_api.g_varchar2)
433: THEN
434: p_rec.attribute2 := per_suc_shd.g_old_rec.attribute2;
435: END IF;
436:

Line 437: IF (p_rec.attribute3 = hr_api.g_varchar2)

433: THEN
434: p_rec.attribute2 := per_suc_shd.g_old_rec.attribute2;
435: END IF;
436:
437: IF (p_rec.attribute3 = hr_api.g_varchar2)
438: THEN
439: p_rec.attribute3 := per_suc_shd.g_old_rec.attribute3;
440: END IF;
441:

Line 442: IF (p_rec.attribute4 = hr_api.g_varchar2)

438: THEN
439: p_rec.attribute3 := per_suc_shd.g_old_rec.attribute3;
440: END IF;
441:
442: IF (p_rec.attribute4 = hr_api.g_varchar2)
443: THEN
444: p_rec.attribute4 := per_suc_shd.g_old_rec.attribute4;
445: END IF;
446:

Line 447: IF (p_rec.attribute5 = hr_api.g_varchar2)

443: THEN
444: p_rec.attribute4 := per_suc_shd.g_old_rec.attribute4;
445: END IF;
446:
447: IF (p_rec.attribute5 = hr_api.g_varchar2)
448: THEN
449: p_rec.attribute5 := per_suc_shd.g_old_rec.attribute5;
450: END IF;
451:

Line 452: IF (p_rec.attribute6 = hr_api.g_varchar2)

448: THEN
449: p_rec.attribute5 := per_suc_shd.g_old_rec.attribute5;
450: END IF;
451:
452: IF (p_rec.attribute6 = hr_api.g_varchar2)
453: THEN
454: p_rec.attribute6 := per_suc_shd.g_old_rec.attribute6;
455: END IF;
456:

Line 457: IF (p_rec.attribute7 = hr_api.g_varchar2)

453: THEN
454: p_rec.attribute6 := per_suc_shd.g_old_rec.attribute6;
455: END IF;
456:
457: IF (p_rec.attribute7 = hr_api.g_varchar2)
458: THEN
459: p_rec.attribute7 := per_suc_shd.g_old_rec.attribute7;
460: END IF;
461:

Line 462: IF (p_rec.attribute8 = hr_api.g_varchar2)

458: THEN
459: p_rec.attribute7 := per_suc_shd.g_old_rec.attribute7;
460: END IF;
461:
462: IF (p_rec.attribute8 = hr_api.g_varchar2)
463: THEN
464: p_rec.attribute8 := per_suc_shd.g_old_rec.attribute8;
465: END IF;
466:

Line 467: IF (p_rec.attribute9 = hr_api.g_varchar2)

463: THEN
464: p_rec.attribute8 := per_suc_shd.g_old_rec.attribute8;
465: END IF;
466:
467: IF (p_rec.attribute9 = hr_api.g_varchar2)
468: THEN
469: p_rec.attribute9 := per_suc_shd.g_old_rec.attribute9;
470: END IF;
471:

Line 472: IF (p_rec.attribute10 = hr_api.g_varchar2)

468: THEN
469: p_rec.attribute9 := per_suc_shd.g_old_rec.attribute9;
470: END IF;
471:
472: IF (p_rec.attribute10 = hr_api.g_varchar2)
473: THEN
474: p_rec.attribute10 := per_suc_shd.g_old_rec.attribute10;
475: END IF;
476:

Line 477: IF (p_rec.attribute11 = hr_api.g_varchar2)

473: THEN
474: p_rec.attribute10 := per_suc_shd.g_old_rec.attribute10;
475: END IF;
476:
477: IF (p_rec.attribute11 = hr_api.g_varchar2)
478: THEN
479: p_rec.attribute11 := per_suc_shd.g_old_rec.attribute11;
480: END IF;
481:

Line 482: IF (p_rec.attribute12 = hr_api.g_varchar2)

478: THEN
479: p_rec.attribute11 := per_suc_shd.g_old_rec.attribute11;
480: END IF;
481:
482: IF (p_rec.attribute12 = hr_api.g_varchar2)
483: THEN
484: p_rec.attribute12 := per_suc_shd.g_old_rec.attribute12;
485: END IF;
486:

Line 487: IF (p_rec.attribute13 = hr_api.g_varchar2)

483: THEN
484: p_rec.attribute12 := per_suc_shd.g_old_rec.attribute12;
485: END IF;
486:
487: IF (p_rec.attribute13 = hr_api.g_varchar2)
488: THEN
489: p_rec.attribute13 := per_suc_shd.g_old_rec.attribute13;
490: END IF;
491:

Line 492: IF (p_rec.attribute14 = hr_api.g_varchar2)

488: THEN
489: p_rec.attribute13 := per_suc_shd.g_old_rec.attribute13;
490: END IF;
491:
492: IF (p_rec.attribute14 = hr_api.g_varchar2)
493: THEN
494: p_rec.attribute14 := per_suc_shd.g_old_rec.attribute14;
495: END IF;
496:

Line 497: IF (p_rec.attribute15 = hr_api.g_varchar2)

493: THEN
494: p_rec.attribute14 := per_suc_shd.g_old_rec.attribute14;
495: END IF;
496:
497: IF (p_rec.attribute15 = hr_api.g_varchar2)
498: THEN
499: p_rec.attribute15 := per_suc_shd.g_old_rec.attribute15;
500: END IF;
501:

Line 502: IF (p_rec.attribute16 = hr_api.g_varchar2)

498: THEN
499: p_rec.attribute15 := per_suc_shd.g_old_rec.attribute15;
500: END IF;
501:
502: IF (p_rec.attribute16 = hr_api.g_varchar2)
503: THEN
504: p_rec.attribute16 := per_suc_shd.g_old_rec.attribute16;
505: END IF;
506:

Line 507: IF (p_rec.attribute17 = hr_api.g_varchar2)

503: THEN
504: p_rec.attribute16 := per_suc_shd.g_old_rec.attribute16;
505: END IF;
506:
507: IF (p_rec.attribute17 = hr_api.g_varchar2)
508: THEN
509: p_rec.attribute17 := per_suc_shd.g_old_rec.attribute17;
510: END IF;
511:

Line 512: IF (p_rec.attribute18 = hr_api.g_varchar2)

508: THEN
509: p_rec.attribute17 := per_suc_shd.g_old_rec.attribute17;
510: END IF;
511:
512: IF (p_rec.attribute18 = hr_api.g_varchar2)
513: THEN
514: p_rec.attribute18 := per_suc_shd.g_old_rec.attribute18;
515: END IF;
516:

Line 517: IF (p_rec.attribute19 = hr_api.g_varchar2)

513: THEN
514: p_rec.attribute18 := per_suc_shd.g_old_rec.attribute18;
515: END IF;
516:
517: IF (p_rec.attribute19 = hr_api.g_varchar2)
518: THEN
519: p_rec.attribute19 := per_suc_shd.g_old_rec.attribute19;
520: END IF;
521:

Line 522: IF (p_rec.attribute20 = hr_api.g_varchar2)

518: THEN
519: p_rec.attribute19 := per_suc_shd.g_old_rec.attribute19;
520: END IF;
521:
522: IF (p_rec.attribute20 = hr_api.g_varchar2)
523: THEN
524: p_rec.attribute20 := per_suc_shd.g_old_rec.attribute20;
525: END IF;
526:

Line 527: IF (p_rec.job_id = hr_api.g_number)

523: THEN
524: p_rec.attribute20 := per_suc_shd.g_old_rec.attribute20;
525: END IF;
526:
527: IF (p_rec.job_id = hr_api.g_number)
528: THEN
529: p_rec.job_id := per_suc_shd.g_old_rec.job_id;
530: END IF;
531:

Line 532: IF (p_rec.successee_person_id = hr_api.g_number)

528: THEN
529: p_rec.job_id := per_suc_shd.g_old_rec.job_id;
530: END IF;
531:
532: IF (p_rec.successee_person_id = hr_api.g_number)
533: THEN
534: p_rec.successee_person_id := per_suc_shd.g_old_rec.successee_person_id;
535: END IF;
536:

Line 537: IF (p_rec.person_rank = hr_api.g_number)

533: THEN
534: p_rec.successee_person_id := per_suc_shd.g_old_rec.successee_person_id;
535: END IF;
536:
537: IF (p_rec.person_rank = hr_api.g_number)
538: THEN
539: p_rec.person_rank := per_suc_shd.g_old_rec.person_rank;
540: END IF;
541:

Line 542: IF (p_rec.PERFORMANCE = hr_api.g_varchar2)

538: THEN
539: p_rec.person_rank := per_suc_shd.g_old_rec.person_rank;
540: END IF;
541:
542: IF (p_rec.PERFORMANCE = hr_api.g_varchar2)
543: THEN
544: p_rec.PERFORMANCE := per_suc_shd.g_old_rec.PERFORMANCE;
545: END IF;
546:

Line 547: IF (p_rec.plan_status = hr_api.g_varchar2)

543: THEN
544: p_rec.PERFORMANCE := per_suc_shd.g_old_rec.PERFORMANCE;
545: END IF;
546:
547: IF (p_rec.plan_status = hr_api.g_varchar2)
548: THEN
549: p_rec.plan_status := per_suc_shd.g_old_rec.plan_status;
550: END IF;
551:

Line 552: IF (p_rec.readiness_percentage = hr_api.g_number)

548: THEN
549: p_rec.plan_status := per_suc_shd.g_old_rec.plan_status;
550: END IF;
551:
552: IF (p_rec.readiness_percentage = hr_api.g_number)
553: THEN
554: p_rec.readiness_percentage := per_suc_shd.g_old_rec.readiness_percentage;
555: END IF;
556:

Line 605: p_person_id IN NUMBER DEFAULT hr_api.g_number,

601: -- |---------------------------------< upd >----------------------------------|
602: -- ----------------------------------------------------------------------------
603: PROCEDURE upd (
604: p_succession_plan_id IN NUMBER,
605: p_person_id IN NUMBER DEFAULT hr_api.g_number,
606: p_position_id IN NUMBER DEFAULT hr_api.g_number,
607: p_business_group_id IN NUMBER DEFAULT hr_api.g_number,
608: p_start_date IN DATE DEFAULT hr_api.g_date,
609: p_time_scale IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 606: p_position_id IN NUMBER DEFAULT hr_api.g_number,

602: -- ----------------------------------------------------------------------------
603: PROCEDURE upd (
604: p_succession_plan_id IN NUMBER,
605: p_person_id IN NUMBER DEFAULT hr_api.g_number,
606: p_position_id IN NUMBER DEFAULT hr_api.g_number,
607: p_business_group_id IN NUMBER DEFAULT hr_api.g_number,
608: p_start_date IN DATE DEFAULT hr_api.g_date,
609: p_time_scale IN VARCHAR2 DEFAULT hr_api.g_varchar2,
610: p_end_date IN DATE DEFAULT hr_api.g_date,

Line 607: p_business_group_id IN NUMBER DEFAULT hr_api.g_number,

603: PROCEDURE upd (
604: p_succession_plan_id IN NUMBER,
605: p_person_id IN NUMBER DEFAULT hr_api.g_number,
606: p_position_id IN NUMBER DEFAULT hr_api.g_number,
607: p_business_group_id IN NUMBER DEFAULT hr_api.g_number,
608: p_start_date IN DATE DEFAULT hr_api.g_date,
609: p_time_scale IN VARCHAR2 DEFAULT hr_api.g_varchar2,
610: p_end_date IN DATE DEFAULT hr_api.g_date,
611: p_available_for_promotion IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 608: p_start_date IN DATE DEFAULT hr_api.g_date,

604: p_succession_plan_id IN NUMBER,
605: p_person_id IN NUMBER DEFAULT hr_api.g_number,
606: p_position_id IN NUMBER DEFAULT hr_api.g_number,
607: p_business_group_id IN NUMBER DEFAULT hr_api.g_number,
608: p_start_date IN DATE DEFAULT hr_api.g_date,
609: p_time_scale IN VARCHAR2 DEFAULT hr_api.g_varchar2,
610: p_end_date IN DATE DEFAULT hr_api.g_date,
611: p_available_for_promotion IN VARCHAR2 DEFAULT hr_api.g_varchar2,
612: p_manager_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 609: p_time_scale IN VARCHAR2 DEFAULT hr_api.g_varchar2,

605: p_person_id IN NUMBER DEFAULT hr_api.g_number,
606: p_position_id IN NUMBER DEFAULT hr_api.g_number,
607: p_business_group_id IN NUMBER DEFAULT hr_api.g_number,
608: p_start_date IN DATE DEFAULT hr_api.g_date,
609: p_time_scale IN VARCHAR2 DEFAULT hr_api.g_varchar2,
610: p_end_date IN DATE DEFAULT hr_api.g_date,
611: p_available_for_promotion IN VARCHAR2 DEFAULT hr_api.g_varchar2,
612: p_manager_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2,
613: p_object_version_number IN OUT NOCOPY NUMBER,

Line 610: p_end_date IN DATE DEFAULT hr_api.g_date,

606: p_position_id IN NUMBER DEFAULT hr_api.g_number,
607: p_business_group_id IN NUMBER DEFAULT hr_api.g_number,
608: p_start_date IN DATE DEFAULT hr_api.g_date,
609: p_time_scale IN VARCHAR2 DEFAULT hr_api.g_varchar2,
610: p_end_date IN DATE DEFAULT hr_api.g_date,
611: p_available_for_promotion IN VARCHAR2 DEFAULT hr_api.g_varchar2,
612: p_manager_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2,
613: p_object_version_number IN OUT NOCOPY NUMBER,
614: p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 611: p_available_for_promotion IN VARCHAR2 DEFAULT hr_api.g_varchar2,

607: p_business_group_id IN NUMBER DEFAULT hr_api.g_number,
608: p_start_date IN DATE DEFAULT hr_api.g_date,
609: p_time_scale IN VARCHAR2 DEFAULT hr_api.g_varchar2,
610: p_end_date IN DATE DEFAULT hr_api.g_date,
611: p_available_for_promotion IN VARCHAR2 DEFAULT hr_api.g_varchar2,
612: p_manager_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2,
613: p_object_version_number IN OUT NOCOPY NUMBER,
614: p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
615: p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 612: p_manager_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2,

608: p_start_date IN DATE DEFAULT hr_api.g_date,
609: p_time_scale IN VARCHAR2 DEFAULT hr_api.g_varchar2,
610: p_end_date IN DATE DEFAULT hr_api.g_date,
611: p_available_for_promotion IN VARCHAR2 DEFAULT hr_api.g_varchar2,
612: p_manager_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2,
613: p_object_version_number IN OUT NOCOPY NUMBER,
614: p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
615: p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
616: p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 614: p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,

610: p_end_date IN DATE DEFAULT hr_api.g_date,
611: p_available_for_promotion IN VARCHAR2 DEFAULT hr_api.g_varchar2,
612: p_manager_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2,
613: p_object_version_number IN OUT NOCOPY NUMBER,
614: p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
615: p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
616: p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
617: p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
618: p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 615: p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

611: p_available_for_promotion IN VARCHAR2 DEFAULT hr_api.g_varchar2,
612: p_manager_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2,
613: p_object_version_number IN OUT NOCOPY NUMBER,
614: p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
615: p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
616: p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
617: p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
618: p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
619: p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 616: p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

612: p_manager_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2,
613: p_object_version_number IN OUT NOCOPY NUMBER,
614: p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
615: p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
616: p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
617: p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
618: p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
619: p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
620: p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 617: p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

613: p_object_version_number IN OUT NOCOPY NUMBER,
614: p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
615: p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
616: p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
617: p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
618: p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
619: p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
620: p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
621: p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 618: p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

614: p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
615: p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
616: p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
617: p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
618: p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
619: p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
620: p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
621: p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
622: p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 619: p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

615: p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
616: p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
617: p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
618: p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
619: p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
620: p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
621: p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
622: p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
623: p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 620: p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

616: p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
617: p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
618: p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
619: p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
620: p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
621: p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
622: p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
623: p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
624: p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 621: p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

617: p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
618: p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
619: p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
620: p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
621: p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
622: p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
623: p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
624: p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
625: p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 622: p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

618: p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
619: p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
620: p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
621: p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
622: p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
623: p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
624: p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
625: p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
626: p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 623: p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

619: p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
620: p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
621: p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
622: p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
623: p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
624: p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
625: p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
626: p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
627: p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 624: p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

620: p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
621: p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
622: p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
623: p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
624: p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
625: p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
626: p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
627: p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
628: p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 625: p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

621: p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
622: p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
623: p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
624: p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
625: p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
626: p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
627: p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
628: p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
629: p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 626: p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

622: p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
623: p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
624: p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
625: p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
626: p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
627: p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
628: p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
629: p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
630: p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 627: p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

623: p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
624: p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
625: p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
626: p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
627: p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
628: p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
629: p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
630: p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
631: p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 628: p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

624: p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
625: p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
626: p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
627: p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
628: p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
629: p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
630: p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
631: p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
632: p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 629: p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

625: p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
626: p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
627: p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
628: p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
629: p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
630: p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
631: p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
632: p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
633: p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 630: p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

626: p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
627: p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
628: p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
629: p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
630: p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
631: p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
632: p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
633: p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
634: p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 631: p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

627: p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
628: p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
629: p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
630: p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
631: p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
632: p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
633: p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
634: p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
635: p_effective_date IN DATE DEFAULT hr_api.g_date,

Line 632: p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

628: p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
629: p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
630: p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
631: p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
632: p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
633: p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
634: p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
635: p_effective_date IN DATE DEFAULT hr_api.g_date,
636: p_job_id IN NUMBER DEFAULT hr_api.g_number,

Line 633: p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

629: p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
630: p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
631: p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
632: p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
633: p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
634: p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
635: p_effective_date IN DATE DEFAULT hr_api.g_date,
636: p_job_id IN NUMBER DEFAULT hr_api.g_number,
637: p_successee_person_id IN NUMBER DEFAULT hr_api.g_number,

Line 634: p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

630: p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
631: p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
632: p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
633: p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
634: p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
635: p_effective_date IN DATE DEFAULT hr_api.g_date,
636: p_job_id IN NUMBER DEFAULT hr_api.g_number,
637: p_successee_person_id IN NUMBER DEFAULT hr_api.g_number,
638: p_person_rank IN NUMBER DEFAULT hr_api.g_number,

Line 635: p_effective_date IN DATE DEFAULT hr_api.g_date,

631: p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
632: p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
633: p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
634: p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
635: p_effective_date IN DATE DEFAULT hr_api.g_date,
636: p_job_id IN NUMBER DEFAULT hr_api.g_number,
637: p_successee_person_id IN NUMBER DEFAULT hr_api.g_number,
638: p_person_rank IN NUMBER DEFAULT hr_api.g_number,
639: p_performance IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 636: p_job_id IN NUMBER DEFAULT hr_api.g_number,

632: p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
633: p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
634: p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
635: p_effective_date IN DATE DEFAULT hr_api.g_date,
636: p_job_id IN NUMBER DEFAULT hr_api.g_number,
637: p_successee_person_id IN NUMBER DEFAULT hr_api.g_number,
638: p_person_rank IN NUMBER DEFAULT hr_api.g_number,
639: p_performance IN VARCHAR2 DEFAULT hr_api.g_varchar2,
640: p_plan_status IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 637: p_successee_person_id IN NUMBER DEFAULT hr_api.g_number,

633: p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
634: p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
635: p_effective_date IN DATE DEFAULT hr_api.g_date,
636: p_job_id IN NUMBER DEFAULT hr_api.g_number,
637: p_successee_person_id IN NUMBER DEFAULT hr_api.g_number,
638: p_person_rank IN NUMBER DEFAULT hr_api.g_number,
639: p_performance IN VARCHAR2 DEFAULT hr_api.g_varchar2,
640: p_plan_status IN VARCHAR2 DEFAULT hr_api.g_varchar2,
641: p_readiness_percentage IN NUMBER DEFAULT hr_api.g_number

Line 638: p_person_rank IN NUMBER DEFAULT hr_api.g_number,

634: p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
635: p_effective_date IN DATE DEFAULT hr_api.g_date,
636: p_job_id IN NUMBER DEFAULT hr_api.g_number,
637: p_successee_person_id IN NUMBER DEFAULT hr_api.g_number,
638: p_person_rank IN NUMBER DEFAULT hr_api.g_number,
639: p_performance IN VARCHAR2 DEFAULT hr_api.g_varchar2,
640: p_plan_status IN VARCHAR2 DEFAULT hr_api.g_varchar2,
641: p_readiness_percentage IN NUMBER DEFAULT hr_api.g_number
642: )

Line 639: p_performance IN VARCHAR2 DEFAULT hr_api.g_varchar2,

635: p_effective_date IN DATE DEFAULT hr_api.g_date,
636: p_job_id IN NUMBER DEFAULT hr_api.g_number,
637: p_successee_person_id IN NUMBER DEFAULT hr_api.g_number,
638: p_person_rank IN NUMBER DEFAULT hr_api.g_number,
639: p_performance IN VARCHAR2 DEFAULT hr_api.g_varchar2,
640: p_plan_status IN VARCHAR2 DEFAULT hr_api.g_varchar2,
641: p_readiness_percentage IN NUMBER DEFAULT hr_api.g_number
642: )
643: IS

Line 640: p_plan_status IN VARCHAR2 DEFAULT hr_api.g_varchar2,

636: p_job_id IN NUMBER DEFAULT hr_api.g_number,
637: p_successee_person_id IN NUMBER DEFAULT hr_api.g_number,
638: p_person_rank IN NUMBER DEFAULT hr_api.g_number,
639: p_performance IN VARCHAR2 DEFAULT hr_api.g_varchar2,
640: p_plan_status IN VARCHAR2 DEFAULT hr_api.g_varchar2,
641: p_readiness_percentage IN NUMBER DEFAULT hr_api.g_number
642: )
643: IS
644: --

Line 641: p_readiness_percentage IN NUMBER DEFAULT hr_api.g_number

637: p_successee_person_id IN NUMBER DEFAULT hr_api.g_number,
638: p_person_rank IN NUMBER DEFAULT hr_api.g_number,
639: p_performance IN VARCHAR2 DEFAULT hr_api.g_varchar2,
640: p_plan_status IN VARCHAR2 DEFAULT hr_api.g_varchar2,
641: p_readiness_percentage IN NUMBER DEFAULT hr_api.g_number
642: )
643: IS
644: --
645: l_rec per_suc_shd.g_rec_type;