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.OTA_CERT_APPROVAL_SS dependencies on OTA_CERT_ENROLLMENTS

Line 489: l_certification_id ota_cert_enrollments.certification_id%type;

485: )
486: is
487:
488:
489: l_certification_id ota_cert_enrollments.certification_id%type;
490:
491: l_attribute_category ota_cert_enrollments.attribute_category%type;
492: l_attribute1 ota_cert_enrollments.attribute1%type;
493: l_attribute2 ota_cert_enrollments.attribute1%type;

Line 491: l_attribute_category ota_cert_enrollments.attribute_category%type;

487:
488:
489: l_certification_id ota_cert_enrollments.certification_id%type;
490:
491: l_attribute_category ota_cert_enrollments.attribute_category%type;
492: l_attribute1 ota_cert_enrollments.attribute1%type;
493: l_attribute2 ota_cert_enrollments.attribute1%type;
494: l_attribute3 ota_cert_enrollments.attribute1%type;
495: l_attribute4 ota_cert_enrollments.attribute1%type;

Line 492: l_attribute1 ota_cert_enrollments.attribute1%type;

488:
489: l_certification_id ota_cert_enrollments.certification_id%type;
490:
491: l_attribute_category ota_cert_enrollments.attribute_category%type;
492: l_attribute1 ota_cert_enrollments.attribute1%type;
493: l_attribute2 ota_cert_enrollments.attribute1%type;
494: l_attribute3 ota_cert_enrollments.attribute1%type;
495: l_attribute4 ota_cert_enrollments.attribute1%type;
496: l_attribute5 ota_cert_enrollments.attribute1%type;

Line 493: l_attribute2 ota_cert_enrollments.attribute1%type;

489: l_certification_id ota_cert_enrollments.certification_id%type;
490:
491: l_attribute_category ota_cert_enrollments.attribute_category%type;
492: l_attribute1 ota_cert_enrollments.attribute1%type;
493: l_attribute2 ota_cert_enrollments.attribute1%type;
494: l_attribute3 ota_cert_enrollments.attribute1%type;
495: l_attribute4 ota_cert_enrollments.attribute1%type;
496: l_attribute5 ota_cert_enrollments.attribute1%type;
497: l_attribute6 ota_cert_enrollments.attribute1%type;

Line 494: l_attribute3 ota_cert_enrollments.attribute1%type;

490:
491: l_attribute_category ota_cert_enrollments.attribute_category%type;
492: l_attribute1 ota_cert_enrollments.attribute1%type;
493: l_attribute2 ota_cert_enrollments.attribute1%type;
494: l_attribute3 ota_cert_enrollments.attribute1%type;
495: l_attribute4 ota_cert_enrollments.attribute1%type;
496: l_attribute5 ota_cert_enrollments.attribute1%type;
497: l_attribute6 ota_cert_enrollments.attribute1%type;
498: l_attribute7 ota_cert_enrollments.attribute1%type;

Line 495: l_attribute4 ota_cert_enrollments.attribute1%type;

491: l_attribute_category ota_cert_enrollments.attribute_category%type;
492: l_attribute1 ota_cert_enrollments.attribute1%type;
493: l_attribute2 ota_cert_enrollments.attribute1%type;
494: l_attribute3 ota_cert_enrollments.attribute1%type;
495: l_attribute4 ota_cert_enrollments.attribute1%type;
496: l_attribute5 ota_cert_enrollments.attribute1%type;
497: l_attribute6 ota_cert_enrollments.attribute1%type;
498: l_attribute7 ota_cert_enrollments.attribute1%type;
499: l_attribute8 ota_cert_enrollments.attribute1%type;

Line 496: l_attribute5 ota_cert_enrollments.attribute1%type;

492: l_attribute1 ota_cert_enrollments.attribute1%type;
493: l_attribute2 ota_cert_enrollments.attribute1%type;
494: l_attribute3 ota_cert_enrollments.attribute1%type;
495: l_attribute4 ota_cert_enrollments.attribute1%type;
496: l_attribute5 ota_cert_enrollments.attribute1%type;
497: l_attribute6 ota_cert_enrollments.attribute1%type;
498: l_attribute7 ota_cert_enrollments.attribute1%type;
499: l_attribute8 ota_cert_enrollments.attribute1%type;
500: l_attribute9 ota_cert_enrollments.attribute1%type;

Line 497: l_attribute6 ota_cert_enrollments.attribute1%type;

493: l_attribute2 ota_cert_enrollments.attribute1%type;
494: l_attribute3 ota_cert_enrollments.attribute1%type;
495: l_attribute4 ota_cert_enrollments.attribute1%type;
496: l_attribute5 ota_cert_enrollments.attribute1%type;
497: l_attribute6 ota_cert_enrollments.attribute1%type;
498: l_attribute7 ota_cert_enrollments.attribute1%type;
499: l_attribute8 ota_cert_enrollments.attribute1%type;
500: l_attribute9 ota_cert_enrollments.attribute1%type;
501: l_attribute10 ota_cert_enrollments.attribute1%type;

Line 498: l_attribute7 ota_cert_enrollments.attribute1%type;

494: l_attribute3 ota_cert_enrollments.attribute1%type;
495: l_attribute4 ota_cert_enrollments.attribute1%type;
496: l_attribute5 ota_cert_enrollments.attribute1%type;
497: l_attribute6 ota_cert_enrollments.attribute1%type;
498: l_attribute7 ota_cert_enrollments.attribute1%type;
499: l_attribute8 ota_cert_enrollments.attribute1%type;
500: l_attribute9 ota_cert_enrollments.attribute1%type;
501: l_attribute10 ota_cert_enrollments.attribute1%type;
502: l_attribute11 ota_cert_enrollments.attribute1%type;

Line 499: l_attribute8 ota_cert_enrollments.attribute1%type;

495: l_attribute4 ota_cert_enrollments.attribute1%type;
496: l_attribute5 ota_cert_enrollments.attribute1%type;
497: l_attribute6 ota_cert_enrollments.attribute1%type;
498: l_attribute7 ota_cert_enrollments.attribute1%type;
499: l_attribute8 ota_cert_enrollments.attribute1%type;
500: l_attribute9 ota_cert_enrollments.attribute1%type;
501: l_attribute10 ota_cert_enrollments.attribute1%type;
502: l_attribute11 ota_cert_enrollments.attribute1%type;
503: l_attribute12 ota_cert_enrollments.attribute1%type;

Line 500: l_attribute9 ota_cert_enrollments.attribute1%type;

496: l_attribute5 ota_cert_enrollments.attribute1%type;
497: l_attribute6 ota_cert_enrollments.attribute1%type;
498: l_attribute7 ota_cert_enrollments.attribute1%type;
499: l_attribute8 ota_cert_enrollments.attribute1%type;
500: l_attribute9 ota_cert_enrollments.attribute1%type;
501: l_attribute10 ota_cert_enrollments.attribute1%type;
502: l_attribute11 ota_cert_enrollments.attribute1%type;
503: l_attribute12 ota_cert_enrollments.attribute1%type;
504: l_attribute13 ota_cert_enrollments.attribute1%type;

Line 501: l_attribute10 ota_cert_enrollments.attribute1%type;

497: l_attribute6 ota_cert_enrollments.attribute1%type;
498: l_attribute7 ota_cert_enrollments.attribute1%type;
499: l_attribute8 ota_cert_enrollments.attribute1%type;
500: l_attribute9 ota_cert_enrollments.attribute1%type;
501: l_attribute10 ota_cert_enrollments.attribute1%type;
502: l_attribute11 ota_cert_enrollments.attribute1%type;
503: l_attribute12 ota_cert_enrollments.attribute1%type;
504: l_attribute13 ota_cert_enrollments.attribute1%type;
505: l_attribute14 ota_cert_enrollments.attribute1%type;

Line 502: l_attribute11 ota_cert_enrollments.attribute1%type;

498: l_attribute7 ota_cert_enrollments.attribute1%type;
499: l_attribute8 ota_cert_enrollments.attribute1%type;
500: l_attribute9 ota_cert_enrollments.attribute1%type;
501: l_attribute10 ota_cert_enrollments.attribute1%type;
502: l_attribute11 ota_cert_enrollments.attribute1%type;
503: l_attribute12 ota_cert_enrollments.attribute1%type;
504: l_attribute13 ota_cert_enrollments.attribute1%type;
505: l_attribute14 ota_cert_enrollments.attribute1%type;
506: l_attribute15 ota_cert_enrollments.attribute1%type;

Line 503: l_attribute12 ota_cert_enrollments.attribute1%type;

499: l_attribute8 ota_cert_enrollments.attribute1%type;
500: l_attribute9 ota_cert_enrollments.attribute1%type;
501: l_attribute10 ota_cert_enrollments.attribute1%type;
502: l_attribute11 ota_cert_enrollments.attribute1%type;
503: l_attribute12 ota_cert_enrollments.attribute1%type;
504: l_attribute13 ota_cert_enrollments.attribute1%type;
505: l_attribute14 ota_cert_enrollments.attribute1%type;
506: l_attribute15 ota_cert_enrollments.attribute1%type;
507: l_attribute16 ota_cert_enrollments.attribute1%type;

Line 504: l_attribute13 ota_cert_enrollments.attribute1%type;

500: l_attribute9 ota_cert_enrollments.attribute1%type;
501: l_attribute10 ota_cert_enrollments.attribute1%type;
502: l_attribute11 ota_cert_enrollments.attribute1%type;
503: l_attribute12 ota_cert_enrollments.attribute1%type;
504: l_attribute13 ota_cert_enrollments.attribute1%type;
505: l_attribute14 ota_cert_enrollments.attribute1%type;
506: l_attribute15 ota_cert_enrollments.attribute1%type;
507: l_attribute16 ota_cert_enrollments.attribute1%type;
508: l_attribute17 ota_cert_enrollments.attribute1%type;

Line 505: l_attribute14 ota_cert_enrollments.attribute1%type;

501: l_attribute10 ota_cert_enrollments.attribute1%type;
502: l_attribute11 ota_cert_enrollments.attribute1%type;
503: l_attribute12 ota_cert_enrollments.attribute1%type;
504: l_attribute13 ota_cert_enrollments.attribute1%type;
505: l_attribute14 ota_cert_enrollments.attribute1%type;
506: l_attribute15 ota_cert_enrollments.attribute1%type;
507: l_attribute16 ota_cert_enrollments.attribute1%type;
508: l_attribute17 ota_cert_enrollments.attribute1%type;
509: l_attribute18 ota_cert_enrollments.attribute1%type;

Line 506: l_attribute15 ota_cert_enrollments.attribute1%type;

502: l_attribute11 ota_cert_enrollments.attribute1%type;
503: l_attribute12 ota_cert_enrollments.attribute1%type;
504: l_attribute13 ota_cert_enrollments.attribute1%type;
505: l_attribute14 ota_cert_enrollments.attribute1%type;
506: l_attribute15 ota_cert_enrollments.attribute1%type;
507: l_attribute16 ota_cert_enrollments.attribute1%type;
508: l_attribute17 ota_cert_enrollments.attribute1%type;
509: l_attribute18 ota_cert_enrollments.attribute1%type;
510: l_attribute19 ota_cert_enrollments.attribute1%type;

Line 507: l_attribute16 ota_cert_enrollments.attribute1%type;

503: l_attribute12 ota_cert_enrollments.attribute1%type;
504: l_attribute13 ota_cert_enrollments.attribute1%type;
505: l_attribute14 ota_cert_enrollments.attribute1%type;
506: l_attribute15 ota_cert_enrollments.attribute1%type;
507: l_attribute16 ota_cert_enrollments.attribute1%type;
508: l_attribute17 ota_cert_enrollments.attribute1%type;
509: l_attribute18 ota_cert_enrollments.attribute1%type;
510: l_attribute19 ota_cert_enrollments.attribute1%type;
511: l_attribute20 ota_cert_enrollments.attribute1%type;

Line 508: l_attribute17 ota_cert_enrollments.attribute1%type;

504: l_attribute13 ota_cert_enrollments.attribute1%type;
505: l_attribute14 ota_cert_enrollments.attribute1%type;
506: l_attribute15 ota_cert_enrollments.attribute1%type;
507: l_attribute16 ota_cert_enrollments.attribute1%type;
508: l_attribute17 ota_cert_enrollments.attribute1%type;
509: l_attribute18 ota_cert_enrollments.attribute1%type;
510: l_attribute19 ota_cert_enrollments.attribute1%type;
511: l_attribute20 ota_cert_enrollments.attribute1%type;
512:

Line 509: l_attribute18 ota_cert_enrollments.attribute1%type;

505: l_attribute14 ota_cert_enrollments.attribute1%type;
506: l_attribute15 ota_cert_enrollments.attribute1%type;
507: l_attribute16 ota_cert_enrollments.attribute1%type;
508: l_attribute17 ota_cert_enrollments.attribute1%type;
509: l_attribute18 ota_cert_enrollments.attribute1%type;
510: l_attribute19 ota_cert_enrollments.attribute1%type;
511: l_attribute20 ota_cert_enrollments.attribute1%type;
512:
513: begin

Line 510: l_attribute19 ota_cert_enrollments.attribute1%type;

506: l_attribute15 ota_cert_enrollments.attribute1%type;
507: l_attribute16 ota_cert_enrollments.attribute1%type;
508: l_attribute17 ota_cert_enrollments.attribute1%type;
509: l_attribute18 ota_cert_enrollments.attribute1%type;
510: l_attribute19 ota_cert_enrollments.attribute1%type;
511: l_attribute20 ota_cert_enrollments.attribute1%type;
512:
513: begin
514:

Line 511: l_attribute20 ota_cert_enrollments.attribute1%type;

507: l_attribute16 ota_cert_enrollments.attribute1%type;
508: l_attribute17 ota_cert_enrollments.attribute1%type;
509: l_attribute18 ota_cert_enrollments.attribute1%type;
510: l_attribute19 ota_cert_enrollments.attribute1%type;
511: l_attribute20 ota_cert_enrollments.attribute1%type;
512:
513: begin
514:
515:

Line 674: l_certification_id ota_cert_enrollments.certification_id%type;

670: l_init_comp_dur varchar2(100);
671: l_renewal_dur varchar2(100);
672: l_notif_days varchar2(100);
673: l_initial_comments ota_certifications_vl.initial_period_comments%type;
674: l_certification_id ota_cert_enrollments.certification_id%type;
675:
676: /* cursor get_certification_info(crs_Certification_id number)
677: is
678: Select name,description,objectives,purpose,

Line 732: l_certification_id ota_cert_enrollments.certification_id%type;

728: l_cert_enrollment_id number;
729: l_object_version_number number;
730: l_effective_date date := trunc(sysdate);
731:
732: l_certification_id ota_cert_enrollments.certification_id%type;
733: l_certification_status_code ota_cert_enrollments.certification_status_code%type;
734: l_IS_HISTORY_FLAG ota_cert_enrollments.is_history_flag%type;
735: l_person_id ota_cert_enrollments.person_id%type;
736: --l_contact_id

Line 733: l_certification_status_code ota_cert_enrollments.certification_status_code%type;

729: l_object_version_number number;
730: l_effective_date date := trunc(sysdate);
731:
732: l_certification_id ota_cert_enrollments.certification_id%type;
733: l_certification_status_code ota_cert_enrollments.certification_status_code%type;
734: l_IS_HISTORY_FLAG ota_cert_enrollments.is_history_flag%type;
735: l_person_id ota_cert_enrollments.person_id%type;
736: --l_contact_id
737: l_completion_date varchar2(100);

Line 734: l_IS_HISTORY_FLAG ota_cert_enrollments.is_history_flag%type;

730: l_effective_date date := trunc(sysdate);
731:
732: l_certification_id ota_cert_enrollments.certification_id%type;
733: l_certification_status_code ota_cert_enrollments.certification_status_code%type;
734: l_IS_HISTORY_FLAG ota_cert_enrollments.is_history_flag%type;
735: l_person_id ota_cert_enrollments.person_id%type;
736: --l_contact_id
737: l_completion_date varchar2(100);
738: l_business_group_id ota_cert_enrollments.business_group_id%type;

Line 735: l_person_id ota_cert_enrollments.person_id%type;

731:
732: l_certification_id ota_cert_enrollments.certification_id%type;
733: l_certification_status_code ota_cert_enrollments.certification_status_code%type;
734: l_IS_HISTORY_FLAG ota_cert_enrollments.is_history_flag%type;
735: l_person_id ota_cert_enrollments.person_id%type;
736: --l_contact_id
737: l_completion_date varchar2(100);
738: l_business_group_id ota_cert_enrollments.business_group_id%type;
739: l_UNENROLLMENT_DATE varchar2(100);

Line 738: l_business_group_id ota_cert_enrollments.business_group_id%type;

734: l_IS_HISTORY_FLAG ota_cert_enrollments.is_history_flag%type;
735: l_person_id ota_cert_enrollments.person_id%type;
736: --l_contact_id
737: l_completion_date varchar2(100);
738: l_business_group_id ota_cert_enrollments.business_group_id%type;
739: l_UNENROLLMENT_DATE varchar2(100);
740: l_EXPIRATION_DATE varchar2(100);
741: l_EARLIEST_ENROLL_DATE varchar2(100);
742: l_attribute_category ota_cert_enrollments.attribute_category%type;

Line 742: l_attribute_category ota_cert_enrollments.attribute_category%type;

738: l_business_group_id ota_cert_enrollments.business_group_id%type;
739: l_UNENROLLMENT_DATE varchar2(100);
740: l_EXPIRATION_DATE varchar2(100);
741: l_EARLIEST_ENROLL_DATE varchar2(100);
742: l_attribute_category ota_cert_enrollments.attribute_category%type;
743: l_attribute1 ota_cert_enrollments.attribute1%type;
744: l_attribute2 ota_cert_enrollments.attribute1%type;
745: l_attribute3 ota_cert_enrollments.attribute1%type;
746: l_attribute4 ota_cert_enrollments.attribute1%type;

Line 743: l_attribute1 ota_cert_enrollments.attribute1%type;

739: l_UNENROLLMENT_DATE varchar2(100);
740: l_EXPIRATION_DATE varchar2(100);
741: l_EARLIEST_ENROLL_DATE varchar2(100);
742: l_attribute_category ota_cert_enrollments.attribute_category%type;
743: l_attribute1 ota_cert_enrollments.attribute1%type;
744: l_attribute2 ota_cert_enrollments.attribute1%type;
745: l_attribute3 ota_cert_enrollments.attribute1%type;
746: l_attribute4 ota_cert_enrollments.attribute1%type;
747: l_attribute5 ota_cert_enrollments.attribute1%type;

Line 744: l_attribute2 ota_cert_enrollments.attribute1%type;

740: l_EXPIRATION_DATE varchar2(100);
741: l_EARLIEST_ENROLL_DATE varchar2(100);
742: l_attribute_category ota_cert_enrollments.attribute_category%type;
743: l_attribute1 ota_cert_enrollments.attribute1%type;
744: l_attribute2 ota_cert_enrollments.attribute1%type;
745: l_attribute3 ota_cert_enrollments.attribute1%type;
746: l_attribute4 ota_cert_enrollments.attribute1%type;
747: l_attribute5 ota_cert_enrollments.attribute1%type;
748: l_attribute6 ota_cert_enrollments.attribute1%type;

Line 745: l_attribute3 ota_cert_enrollments.attribute1%type;

741: l_EARLIEST_ENROLL_DATE varchar2(100);
742: l_attribute_category ota_cert_enrollments.attribute_category%type;
743: l_attribute1 ota_cert_enrollments.attribute1%type;
744: l_attribute2 ota_cert_enrollments.attribute1%type;
745: l_attribute3 ota_cert_enrollments.attribute1%type;
746: l_attribute4 ota_cert_enrollments.attribute1%type;
747: l_attribute5 ota_cert_enrollments.attribute1%type;
748: l_attribute6 ota_cert_enrollments.attribute1%type;
749: l_attribute7 ota_cert_enrollments.attribute1%type;

Line 746: l_attribute4 ota_cert_enrollments.attribute1%type;

742: l_attribute_category ota_cert_enrollments.attribute_category%type;
743: l_attribute1 ota_cert_enrollments.attribute1%type;
744: l_attribute2 ota_cert_enrollments.attribute1%type;
745: l_attribute3 ota_cert_enrollments.attribute1%type;
746: l_attribute4 ota_cert_enrollments.attribute1%type;
747: l_attribute5 ota_cert_enrollments.attribute1%type;
748: l_attribute6 ota_cert_enrollments.attribute1%type;
749: l_attribute7 ota_cert_enrollments.attribute1%type;
750: l_attribute8 ota_cert_enrollments.attribute1%type;

Line 747: l_attribute5 ota_cert_enrollments.attribute1%type;

743: l_attribute1 ota_cert_enrollments.attribute1%type;
744: l_attribute2 ota_cert_enrollments.attribute1%type;
745: l_attribute3 ota_cert_enrollments.attribute1%type;
746: l_attribute4 ota_cert_enrollments.attribute1%type;
747: l_attribute5 ota_cert_enrollments.attribute1%type;
748: l_attribute6 ota_cert_enrollments.attribute1%type;
749: l_attribute7 ota_cert_enrollments.attribute1%type;
750: l_attribute8 ota_cert_enrollments.attribute1%type;
751: l_attribute9 ota_cert_enrollments.attribute1%type;

Line 748: l_attribute6 ota_cert_enrollments.attribute1%type;

744: l_attribute2 ota_cert_enrollments.attribute1%type;
745: l_attribute3 ota_cert_enrollments.attribute1%type;
746: l_attribute4 ota_cert_enrollments.attribute1%type;
747: l_attribute5 ota_cert_enrollments.attribute1%type;
748: l_attribute6 ota_cert_enrollments.attribute1%type;
749: l_attribute7 ota_cert_enrollments.attribute1%type;
750: l_attribute8 ota_cert_enrollments.attribute1%type;
751: l_attribute9 ota_cert_enrollments.attribute1%type;
752: l_attribute10 ota_cert_enrollments.attribute1%type;

Line 749: l_attribute7 ota_cert_enrollments.attribute1%type;

745: l_attribute3 ota_cert_enrollments.attribute1%type;
746: l_attribute4 ota_cert_enrollments.attribute1%type;
747: l_attribute5 ota_cert_enrollments.attribute1%type;
748: l_attribute6 ota_cert_enrollments.attribute1%type;
749: l_attribute7 ota_cert_enrollments.attribute1%type;
750: l_attribute8 ota_cert_enrollments.attribute1%type;
751: l_attribute9 ota_cert_enrollments.attribute1%type;
752: l_attribute10 ota_cert_enrollments.attribute1%type;
753: l_attribute11 ota_cert_enrollments.attribute1%type;

Line 750: l_attribute8 ota_cert_enrollments.attribute1%type;

746: l_attribute4 ota_cert_enrollments.attribute1%type;
747: l_attribute5 ota_cert_enrollments.attribute1%type;
748: l_attribute6 ota_cert_enrollments.attribute1%type;
749: l_attribute7 ota_cert_enrollments.attribute1%type;
750: l_attribute8 ota_cert_enrollments.attribute1%type;
751: l_attribute9 ota_cert_enrollments.attribute1%type;
752: l_attribute10 ota_cert_enrollments.attribute1%type;
753: l_attribute11 ota_cert_enrollments.attribute1%type;
754: l_attribute12 ota_cert_enrollments.attribute1%type;

Line 751: l_attribute9 ota_cert_enrollments.attribute1%type;

747: l_attribute5 ota_cert_enrollments.attribute1%type;
748: l_attribute6 ota_cert_enrollments.attribute1%type;
749: l_attribute7 ota_cert_enrollments.attribute1%type;
750: l_attribute8 ota_cert_enrollments.attribute1%type;
751: l_attribute9 ota_cert_enrollments.attribute1%type;
752: l_attribute10 ota_cert_enrollments.attribute1%type;
753: l_attribute11 ota_cert_enrollments.attribute1%type;
754: l_attribute12 ota_cert_enrollments.attribute1%type;
755: l_attribute13 ota_cert_enrollments.attribute1%type;

Line 752: l_attribute10 ota_cert_enrollments.attribute1%type;

748: l_attribute6 ota_cert_enrollments.attribute1%type;
749: l_attribute7 ota_cert_enrollments.attribute1%type;
750: l_attribute8 ota_cert_enrollments.attribute1%type;
751: l_attribute9 ota_cert_enrollments.attribute1%type;
752: l_attribute10 ota_cert_enrollments.attribute1%type;
753: l_attribute11 ota_cert_enrollments.attribute1%type;
754: l_attribute12 ota_cert_enrollments.attribute1%type;
755: l_attribute13 ota_cert_enrollments.attribute1%type;
756: l_attribute14 ota_cert_enrollments.attribute1%type;

Line 753: l_attribute11 ota_cert_enrollments.attribute1%type;

749: l_attribute7 ota_cert_enrollments.attribute1%type;
750: l_attribute8 ota_cert_enrollments.attribute1%type;
751: l_attribute9 ota_cert_enrollments.attribute1%type;
752: l_attribute10 ota_cert_enrollments.attribute1%type;
753: l_attribute11 ota_cert_enrollments.attribute1%type;
754: l_attribute12 ota_cert_enrollments.attribute1%type;
755: l_attribute13 ota_cert_enrollments.attribute1%type;
756: l_attribute14 ota_cert_enrollments.attribute1%type;
757: l_attribute15 ota_cert_enrollments.attribute1%type;

Line 754: l_attribute12 ota_cert_enrollments.attribute1%type;

750: l_attribute8 ota_cert_enrollments.attribute1%type;
751: l_attribute9 ota_cert_enrollments.attribute1%type;
752: l_attribute10 ota_cert_enrollments.attribute1%type;
753: l_attribute11 ota_cert_enrollments.attribute1%type;
754: l_attribute12 ota_cert_enrollments.attribute1%type;
755: l_attribute13 ota_cert_enrollments.attribute1%type;
756: l_attribute14 ota_cert_enrollments.attribute1%type;
757: l_attribute15 ota_cert_enrollments.attribute1%type;
758: l_attribute16 ota_cert_enrollments.attribute1%type;

Line 755: l_attribute13 ota_cert_enrollments.attribute1%type;

751: l_attribute9 ota_cert_enrollments.attribute1%type;
752: l_attribute10 ota_cert_enrollments.attribute1%type;
753: l_attribute11 ota_cert_enrollments.attribute1%type;
754: l_attribute12 ota_cert_enrollments.attribute1%type;
755: l_attribute13 ota_cert_enrollments.attribute1%type;
756: l_attribute14 ota_cert_enrollments.attribute1%type;
757: l_attribute15 ota_cert_enrollments.attribute1%type;
758: l_attribute16 ota_cert_enrollments.attribute1%type;
759: l_attribute17 ota_cert_enrollments.attribute1%type;

Line 756: l_attribute14 ota_cert_enrollments.attribute1%type;

752: l_attribute10 ota_cert_enrollments.attribute1%type;
753: l_attribute11 ota_cert_enrollments.attribute1%type;
754: l_attribute12 ota_cert_enrollments.attribute1%type;
755: l_attribute13 ota_cert_enrollments.attribute1%type;
756: l_attribute14 ota_cert_enrollments.attribute1%type;
757: l_attribute15 ota_cert_enrollments.attribute1%type;
758: l_attribute16 ota_cert_enrollments.attribute1%type;
759: l_attribute17 ota_cert_enrollments.attribute1%type;
760: l_attribute18 ota_cert_enrollments.attribute1%type;

Line 757: l_attribute15 ota_cert_enrollments.attribute1%type;

753: l_attribute11 ota_cert_enrollments.attribute1%type;
754: l_attribute12 ota_cert_enrollments.attribute1%type;
755: l_attribute13 ota_cert_enrollments.attribute1%type;
756: l_attribute14 ota_cert_enrollments.attribute1%type;
757: l_attribute15 ota_cert_enrollments.attribute1%type;
758: l_attribute16 ota_cert_enrollments.attribute1%type;
759: l_attribute17 ota_cert_enrollments.attribute1%type;
760: l_attribute18 ota_cert_enrollments.attribute1%type;
761: l_attribute19 ota_cert_enrollments.attribute1%type;

Line 758: l_attribute16 ota_cert_enrollments.attribute1%type;

754: l_attribute12 ota_cert_enrollments.attribute1%type;
755: l_attribute13 ota_cert_enrollments.attribute1%type;
756: l_attribute14 ota_cert_enrollments.attribute1%type;
757: l_attribute15 ota_cert_enrollments.attribute1%type;
758: l_attribute16 ota_cert_enrollments.attribute1%type;
759: l_attribute17 ota_cert_enrollments.attribute1%type;
760: l_attribute18 ota_cert_enrollments.attribute1%type;
761: l_attribute19 ota_cert_enrollments.attribute1%type;
762: l_attribute20 ota_cert_enrollments.attribute1%type;

Line 759: l_attribute17 ota_cert_enrollments.attribute1%type;

755: l_attribute13 ota_cert_enrollments.attribute1%type;
756: l_attribute14 ota_cert_enrollments.attribute1%type;
757: l_attribute15 ota_cert_enrollments.attribute1%type;
758: l_attribute16 ota_cert_enrollments.attribute1%type;
759: l_attribute17 ota_cert_enrollments.attribute1%type;
760: l_attribute18 ota_cert_enrollments.attribute1%type;
761: l_attribute19 ota_cert_enrollments.attribute1%type;
762: l_attribute20 ota_cert_enrollments.attribute1%type;
763:

Line 760: l_attribute18 ota_cert_enrollments.attribute1%type;

756: l_attribute14 ota_cert_enrollments.attribute1%type;
757: l_attribute15 ota_cert_enrollments.attribute1%type;
758: l_attribute16 ota_cert_enrollments.attribute1%type;
759: l_attribute17 ota_cert_enrollments.attribute1%type;
760: l_attribute18 ota_cert_enrollments.attribute1%type;
761: l_attribute19 ota_cert_enrollments.attribute1%type;
762: l_attribute20 ota_cert_enrollments.attribute1%type;
763:
764: Cursor get_cert_name (crs_certification_id number)is

Line 761: l_attribute19 ota_cert_enrollments.attribute1%type;

757: l_attribute15 ota_cert_enrollments.attribute1%type;
758: l_attribute16 ota_cert_enrollments.attribute1%type;
759: l_attribute17 ota_cert_enrollments.attribute1%type;
760: l_attribute18 ota_cert_enrollments.attribute1%type;
761: l_attribute19 ota_cert_enrollments.attribute1%type;
762: l_attribute20 ota_cert_enrollments.attribute1%type;
763:
764: Cursor get_cert_name (crs_certification_id number)is
765: select ctl.name

Line 762: l_attribute20 ota_cert_enrollments.attribute1%type;

758: l_attribute16 ota_cert_enrollments.attribute1%type;
759: l_attribute17 ota_cert_enrollments.attribute1%type;
760: l_attribute18 ota_cert_enrollments.attribute1%type;
761: l_attribute19 ota_cert_enrollments.attribute1%type;
762: l_attribute20 ota_cert_enrollments.attribute1%type;
763:
764: Cursor get_cert_name (crs_certification_id number)is
765: select ctl.name
766: from ota_Certifications_tl ctl , ota_Certifications_b ctb

Line 956: l_certification_id ota_cert_enrollments.certification_id%type;

952: l_object_version_number number;
953: l_effective_date date := trunc(sysdate);
954: l_certification_status varchar2(100);
955:
956: l_certification_id ota_cert_enrollments.certification_id%type;
957: l_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE := itemtype;
958: l_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE := itemkey;
959: l_activity_id HR_API_TRANSACTION_STEPS.ACTIVITY_ID%TYPE;
960:

Line 961: l_IS_HISTORY_FLAG ota_cert_enrollments.is_history_flag%type;

957: l_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE := itemtype;
958: l_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE := itemkey;
959: l_activity_id HR_API_TRANSACTION_STEPS.ACTIVITY_ID%TYPE;
960:
961: l_IS_HISTORY_FLAG ota_cert_enrollments.is_history_flag%type;
962: l_person_id ota_cert_enrollments.person_id%type;
963: l_certification_status_code varchar2(100);
964: l_completion_date varchar2(100);
965: l_business_group_id ota_cert_enrollments.business_group_id%type;

Line 962: l_person_id ota_cert_enrollments.person_id%type;

958: l_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE := itemkey;
959: l_activity_id HR_API_TRANSACTION_STEPS.ACTIVITY_ID%TYPE;
960:
961: l_IS_HISTORY_FLAG ota_cert_enrollments.is_history_flag%type;
962: l_person_id ota_cert_enrollments.person_id%type;
963: l_certification_status_code varchar2(100);
964: l_completion_date varchar2(100);
965: l_business_group_id ota_cert_enrollments.business_group_id%type;
966: l_UNENROLLMENT_DATE varchar2(100);

Line 965: l_business_group_id ota_cert_enrollments.business_group_id%type;

961: l_IS_HISTORY_FLAG ota_cert_enrollments.is_history_flag%type;
962: l_person_id ota_cert_enrollments.person_id%type;
963: l_certification_status_code varchar2(100);
964: l_completion_date varchar2(100);
965: l_business_group_id ota_cert_enrollments.business_group_id%type;
966: l_UNENROLLMENT_DATE varchar2(100);
967: l_EXPIRATION_DATE varchar2(100);
968: l_EARLIEST_ENROLL_DATE varchar2(100);
969: l_attribute_category ota_cert_enrollments.attribute_category%type;

Line 969: l_attribute_category ota_cert_enrollments.attribute_category%type;

965: l_business_group_id ota_cert_enrollments.business_group_id%type;
966: l_UNENROLLMENT_DATE varchar2(100);
967: l_EXPIRATION_DATE varchar2(100);
968: l_EARLIEST_ENROLL_DATE varchar2(100);
969: l_attribute_category ota_cert_enrollments.attribute_category%type;
970: l_attribute1 ota_cert_enrollments.attribute1%type;
971: l_attribute2 ota_cert_enrollments.attribute1%type;
972: l_attribute3 ota_cert_enrollments.attribute1%type;
973: l_attribute4 ota_cert_enrollments.attribute1%type;

Line 970: l_attribute1 ota_cert_enrollments.attribute1%type;

966: l_UNENROLLMENT_DATE varchar2(100);
967: l_EXPIRATION_DATE varchar2(100);
968: l_EARLIEST_ENROLL_DATE varchar2(100);
969: l_attribute_category ota_cert_enrollments.attribute_category%type;
970: l_attribute1 ota_cert_enrollments.attribute1%type;
971: l_attribute2 ota_cert_enrollments.attribute1%type;
972: l_attribute3 ota_cert_enrollments.attribute1%type;
973: l_attribute4 ota_cert_enrollments.attribute1%type;
974: l_attribute5 ota_cert_enrollments.attribute1%type;

Line 971: l_attribute2 ota_cert_enrollments.attribute1%type;

967: l_EXPIRATION_DATE varchar2(100);
968: l_EARLIEST_ENROLL_DATE varchar2(100);
969: l_attribute_category ota_cert_enrollments.attribute_category%type;
970: l_attribute1 ota_cert_enrollments.attribute1%type;
971: l_attribute2 ota_cert_enrollments.attribute1%type;
972: l_attribute3 ota_cert_enrollments.attribute1%type;
973: l_attribute4 ota_cert_enrollments.attribute1%type;
974: l_attribute5 ota_cert_enrollments.attribute1%type;
975: l_attribute6 ota_cert_enrollments.attribute1%type;

Line 972: l_attribute3 ota_cert_enrollments.attribute1%type;

968: l_EARLIEST_ENROLL_DATE varchar2(100);
969: l_attribute_category ota_cert_enrollments.attribute_category%type;
970: l_attribute1 ota_cert_enrollments.attribute1%type;
971: l_attribute2 ota_cert_enrollments.attribute1%type;
972: l_attribute3 ota_cert_enrollments.attribute1%type;
973: l_attribute4 ota_cert_enrollments.attribute1%type;
974: l_attribute5 ota_cert_enrollments.attribute1%type;
975: l_attribute6 ota_cert_enrollments.attribute1%type;
976: l_attribute7 ota_cert_enrollments.attribute1%type;

Line 973: l_attribute4 ota_cert_enrollments.attribute1%type;

969: l_attribute_category ota_cert_enrollments.attribute_category%type;
970: l_attribute1 ota_cert_enrollments.attribute1%type;
971: l_attribute2 ota_cert_enrollments.attribute1%type;
972: l_attribute3 ota_cert_enrollments.attribute1%type;
973: l_attribute4 ota_cert_enrollments.attribute1%type;
974: l_attribute5 ota_cert_enrollments.attribute1%type;
975: l_attribute6 ota_cert_enrollments.attribute1%type;
976: l_attribute7 ota_cert_enrollments.attribute1%type;
977: l_attribute8 ota_cert_enrollments.attribute1%type;

Line 974: l_attribute5 ota_cert_enrollments.attribute1%type;

970: l_attribute1 ota_cert_enrollments.attribute1%type;
971: l_attribute2 ota_cert_enrollments.attribute1%type;
972: l_attribute3 ota_cert_enrollments.attribute1%type;
973: l_attribute4 ota_cert_enrollments.attribute1%type;
974: l_attribute5 ota_cert_enrollments.attribute1%type;
975: l_attribute6 ota_cert_enrollments.attribute1%type;
976: l_attribute7 ota_cert_enrollments.attribute1%type;
977: l_attribute8 ota_cert_enrollments.attribute1%type;
978: l_attribute9 ota_cert_enrollments.attribute1%type;

Line 975: l_attribute6 ota_cert_enrollments.attribute1%type;

971: l_attribute2 ota_cert_enrollments.attribute1%type;
972: l_attribute3 ota_cert_enrollments.attribute1%type;
973: l_attribute4 ota_cert_enrollments.attribute1%type;
974: l_attribute5 ota_cert_enrollments.attribute1%type;
975: l_attribute6 ota_cert_enrollments.attribute1%type;
976: l_attribute7 ota_cert_enrollments.attribute1%type;
977: l_attribute8 ota_cert_enrollments.attribute1%type;
978: l_attribute9 ota_cert_enrollments.attribute1%type;
979: l_attribute10 ota_cert_enrollments.attribute1%type;

Line 976: l_attribute7 ota_cert_enrollments.attribute1%type;

972: l_attribute3 ota_cert_enrollments.attribute1%type;
973: l_attribute4 ota_cert_enrollments.attribute1%type;
974: l_attribute5 ota_cert_enrollments.attribute1%type;
975: l_attribute6 ota_cert_enrollments.attribute1%type;
976: l_attribute7 ota_cert_enrollments.attribute1%type;
977: l_attribute8 ota_cert_enrollments.attribute1%type;
978: l_attribute9 ota_cert_enrollments.attribute1%type;
979: l_attribute10 ota_cert_enrollments.attribute1%type;
980: l_attribute11 ota_cert_enrollments.attribute1%type;

Line 977: l_attribute8 ota_cert_enrollments.attribute1%type;

973: l_attribute4 ota_cert_enrollments.attribute1%type;
974: l_attribute5 ota_cert_enrollments.attribute1%type;
975: l_attribute6 ota_cert_enrollments.attribute1%type;
976: l_attribute7 ota_cert_enrollments.attribute1%type;
977: l_attribute8 ota_cert_enrollments.attribute1%type;
978: l_attribute9 ota_cert_enrollments.attribute1%type;
979: l_attribute10 ota_cert_enrollments.attribute1%type;
980: l_attribute11 ota_cert_enrollments.attribute1%type;
981: l_attribute12 ota_cert_enrollments.attribute1%type;

Line 978: l_attribute9 ota_cert_enrollments.attribute1%type;

974: l_attribute5 ota_cert_enrollments.attribute1%type;
975: l_attribute6 ota_cert_enrollments.attribute1%type;
976: l_attribute7 ota_cert_enrollments.attribute1%type;
977: l_attribute8 ota_cert_enrollments.attribute1%type;
978: l_attribute9 ota_cert_enrollments.attribute1%type;
979: l_attribute10 ota_cert_enrollments.attribute1%type;
980: l_attribute11 ota_cert_enrollments.attribute1%type;
981: l_attribute12 ota_cert_enrollments.attribute1%type;
982: l_attribute13 ota_cert_enrollments.attribute1%type;

Line 979: l_attribute10 ota_cert_enrollments.attribute1%type;

975: l_attribute6 ota_cert_enrollments.attribute1%type;
976: l_attribute7 ota_cert_enrollments.attribute1%type;
977: l_attribute8 ota_cert_enrollments.attribute1%type;
978: l_attribute9 ota_cert_enrollments.attribute1%type;
979: l_attribute10 ota_cert_enrollments.attribute1%type;
980: l_attribute11 ota_cert_enrollments.attribute1%type;
981: l_attribute12 ota_cert_enrollments.attribute1%type;
982: l_attribute13 ota_cert_enrollments.attribute1%type;
983: l_attribute14 ota_cert_enrollments.attribute1%type;

Line 980: l_attribute11 ota_cert_enrollments.attribute1%type;

976: l_attribute7 ota_cert_enrollments.attribute1%type;
977: l_attribute8 ota_cert_enrollments.attribute1%type;
978: l_attribute9 ota_cert_enrollments.attribute1%type;
979: l_attribute10 ota_cert_enrollments.attribute1%type;
980: l_attribute11 ota_cert_enrollments.attribute1%type;
981: l_attribute12 ota_cert_enrollments.attribute1%type;
982: l_attribute13 ota_cert_enrollments.attribute1%type;
983: l_attribute14 ota_cert_enrollments.attribute1%type;
984: l_attribute15 ota_cert_enrollments.attribute1%type;

Line 981: l_attribute12 ota_cert_enrollments.attribute1%type;

977: l_attribute8 ota_cert_enrollments.attribute1%type;
978: l_attribute9 ota_cert_enrollments.attribute1%type;
979: l_attribute10 ota_cert_enrollments.attribute1%type;
980: l_attribute11 ota_cert_enrollments.attribute1%type;
981: l_attribute12 ota_cert_enrollments.attribute1%type;
982: l_attribute13 ota_cert_enrollments.attribute1%type;
983: l_attribute14 ota_cert_enrollments.attribute1%type;
984: l_attribute15 ota_cert_enrollments.attribute1%type;
985: l_attribute16 ota_cert_enrollments.attribute1%type;

Line 982: l_attribute13 ota_cert_enrollments.attribute1%type;

978: l_attribute9 ota_cert_enrollments.attribute1%type;
979: l_attribute10 ota_cert_enrollments.attribute1%type;
980: l_attribute11 ota_cert_enrollments.attribute1%type;
981: l_attribute12 ota_cert_enrollments.attribute1%type;
982: l_attribute13 ota_cert_enrollments.attribute1%type;
983: l_attribute14 ota_cert_enrollments.attribute1%type;
984: l_attribute15 ota_cert_enrollments.attribute1%type;
985: l_attribute16 ota_cert_enrollments.attribute1%type;
986: l_attribute17 ota_cert_enrollments.attribute1%type;

Line 983: l_attribute14 ota_cert_enrollments.attribute1%type;

979: l_attribute10 ota_cert_enrollments.attribute1%type;
980: l_attribute11 ota_cert_enrollments.attribute1%type;
981: l_attribute12 ota_cert_enrollments.attribute1%type;
982: l_attribute13 ota_cert_enrollments.attribute1%type;
983: l_attribute14 ota_cert_enrollments.attribute1%type;
984: l_attribute15 ota_cert_enrollments.attribute1%type;
985: l_attribute16 ota_cert_enrollments.attribute1%type;
986: l_attribute17 ota_cert_enrollments.attribute1%type;
987: l_attribute18 ota_cert_enrollments.attribute1%type;

Line 984: l_attribute15 ota_cert_enrollments.attribute1%type;

980: l_attribute11 ota_cert_enrollments.attribute1%type;
981: l_attribute12 ota_cert_enrollments.attribute1%type;
982: l_attribute13 ota_cert_enrollments.attribute1%type;
983: l_attribute14 ota_cert_enrollments.attribute1%type;
984: l_attribute15 ota_cert_enrollments.attribute1%type;
985: l_attribute16 ota_cert_enrollments.attribute1%type;
986: l_attribute17 ota_cert_enrollments.attribute1%type;
987: l_attribute18 ota_cert_enrollments.attribute1%type;
988: l_attribute19 ota_cert_enrollments.attribute1%type;

Line 985: l_attribute16 ota_cert_enrollments.attribute1%type;

981: l_attribute12 ota_cert_enrollments.attribute1%type;
982: l_attribute13 ota_cert_enrollments.attribute1%type;
983: l_attribute14 ota_cert_enrollments.attribute1%type;
984: l_attribute15 ota_cert_enrollments.attribute1%type;
985: l_attribute16 ota_cert_enrollments.attribute1%type;
986: l_attribute17 ota_cert_enrollments.attribute1%type;
987: l_attribute18 ota_cert_enrollments.attribute1%type;
988: l_attribute19 ota_cert_enrollments.attribute1%type;
989: l_attribute20 ota_cert_enrollments.attribute1%type;

Line 986: l_attribute17 ota_cert_enrollments.attribute1%type;

982: l_attribute13 ota_cert_enrollments.attribute1%type;
983: l_attribute14 ota_cert_enrollments.attribute1%type;
984: l_attribute15 ota_cert_enrollments.attribute1%type;
985: l_attribute16 ota_cert_enrollments.attribute1%type;
986: l_attribute17 ota_cert_enrollments.attribute1%type;
987: l_attribute18 ota_cert_enrollments.attribute1%type;
988: l_attribute19 ota_cert_enrollments.attribute1%type;
989: l_attribute20 ota_cert_enrollments.attribute1%type;
990:

Line 987: l_attribute18 ota_cert_enrollments.attribute1%type;

983: l_attribute14 ota_cert_enrollments.attribute1%type;
984: l_attribute15 ota_cert_enrollments.attribute1%type;
985: l_attribute16 ota_cert_enrollments.attribute1%type;
986: l_attribute17 ota_cert_enrollments.attribute1%type;
987: l_attribute18 ota_cert_enrollments.attribute1%type;
988: l_attribute19 ota_cert_enrollments.attribute1%type;
989: l_attribute20 ota_cert_enrollments.attribute1%type;
990:
991:

Line 988: l_attribute19 ota_cert_enrollments.attribute1%type;

984: l_attribute15 ota_cert_enrollments.attribute1%type;
985: l_attribute16 ota_cert_enrollments.attribute1%type;
986: l_attribute17 ota_cert_enrollments.attribute1%type;
987: l_attribute18 ota_cert_enrollments.attribute1%type;
988: l_attribute19 ota_cert_enrollments.attribute1%type;
989: l_attribute20 ota_cert_enrollments.attribute1%type;
990:
991:
992:

Line 989: l_attribute20 ota_cert_enrollments.attribute1%type;

985: l_attribute16 ota_cert_enrollments.attribute1%type;
986: l_attribute17 ota_cert_enrollments.attribute1%type;
987: l_attribute18 ota_cert_enrollments.attribute1%type;
988: l_attribute19 ota_cert_enrollments.attribute1%type;
989: l_attribute20 ota_cert_enrollments.attribute1%type;
990:
991:
992:
993:

Line 997: from ota_cert_enrollments

993:
994: Cursor get_cert_info(crs_Cert_enrollment_id number)
995: is
996: select certification_id, object_version_number
997: from ota_cert_enrollments
998: where cert_enrollment_id = crs_cert_enrollment_id;
999:
1000: begin
1001:

Line 1197: from ota_cert_enrollments

1193:
1194: /*cursor get_exist_cert_enroll
1195: is
1196: Select cert_enrollment_id
1197: from ota_cert_enrollments
1198: where certification_id = l_certification_id
1199: and person_id = l_person_id
1200: and business_group_id = ota_general.get_business_group_id();*/
1201: