APPS.OTA_CERT_ENROLLMENT_API dependencies on OTA_CERT_ENROLLMENTS

Line 489: from ota_cert_enrollments

485:
486:
487: CURSOR get_person_info IS
488: select person_id
489: from ota_cert_enrollments
490: where CERT_ENROLLMENT_ID = p_cert_enrollment_id;
491: --
492: -- Declare cursors and local variables
493: --

Line 654: from ota_cert_enrollments cre

650: cre.cert_enrollment_id,
651: cre.certification_id,
652: cre.object_version_number,
653: cre.certification_status_code
654: from ota_cert_enrollments cre
655: where cre.certification_id = p_certification_id
656: and (cre.person_id = p_person_id or cre.contact_id = p_contact_id);
657:
658: CURSOR csr_cert_enrl(p_cert_enrollment_id in ota_cert_enrollments.cert_enrollment_id%type) IS

Line 658: CURSOR csr_cert_enrl(p_cert_enrollment_id in ota_cert_enrollments.cert_enrollment_id%type) IS

654: from ota_cert_enrollments cre
655: where cre.certification_id = p_certification_id
656: and (cre.person_id = p_person_id or cre.contact_id = p_contact_id);
657:
658: CURSOR csr_cert_enrl(p_cert_enrollment_id in ota_cert_enrollments.cert_enrollment_id%type) IS
659: select cert_enrollment_id, certification_id, certification_status_code, object_version_number, completion_date
660: FROM ota_cert_enrollments
661: where cert_enrollment_id = p_cert_enrollment_id;
662:

Line 660: FROM ota_cert_enrollments

656: and (cre.person_id = p_person_id or cre.contact_id = p_contact_id);
657:
658: CURSOR csr_cert_enrl(p_cert_enrollment_id in ota_cert_enrollments.cert_enrollment_id%type) IS
659: select cert_enrollment_id, certification_id, certification_status_code, object_version_number, completion_date
660: FROM ota_cert_enrollments
661: where cert_enrollment_id = p_cert_enrollment_id;
662:
663: CURSOR csr_prd_enrl(p_cert_enrollment_id in ota_cert_enrollments.cert_enrollment_id%type) IS
664: select cert_prd_enrollment_id, period_status_code, object_version_number, completion_date

Line 663: CURSOR csr_prd_enrl(p_cert_enrollment_id in ota_cert_enrollments.cert_enrollment_id%type) IS

659: select cert_enrollment_id, certification_id, certification_status_code, object_version_number, completion_date
660: FROM ota_cert_enrollments
661: where cert_enrollment_id = p_cert_enrollment_id;
662:
663: CURSOR csr_prd_enrl(p_cert_enrollment_id in ota_cert_enrollments.cert_enrollment_id%type) IS
664: select cert_prd_enrollment_id, period_status_code, object_version_number, completion_date
665: FROM ota_cert_prd_enrollments
666: where cert_enrollment_id = p_cert_enrollment_id
667: and trunc(sysdate) between trunc(cert_period_start_date) and nvl(trunc(cert_period_end_date),trunc(sysdate))

Line 671: CURSOR csr_cpe_exist(p_cert_enrollment_id in ota_cert_enrollments.cert_enrollment_id%type) IS

667: and trunc(sysdate) between trunc(cert_period_start_date) and nvl(trunc(cert_period_end_date),trunc(sysdate))
668: and period_status_code = 'ACTIVE' --Bug#7705069
669: order by cert_prd_enrollment_id desc;
670:
671: CURSOR csr_cpe_exist(p_cert_enrollment_id in ota_cert_enrollments.cert_enrollment_id%type) IS
672: select cert_prd_enrollment_id
673: FROM ota_cert_prd_enrollments
674: where cert_enrollment_id = p_cert_enrollment_id;
675:

Line 687: l_certification_status_code ota_cert_enrollments.certification_status_code%type;

683: l_object_version_number1 number;
684: l_object_version_number2 number;
685:
686: l_period_status_code VARCHAR2(30);
687: l_certification_status_code ota_cert_enrollments.certification_status_code%type;
688: l_cert_enrollment_id NUMBER;
689: l_cert_prd_enrollment_id NUMBER;
690: l_cert_mbr_enrollment_id NUMBER;
691:

Line 799: ,flex_field_name => 'OTA_CERT_ENROLLMENTS'

795:
796: hr_utility.set_location(' Step:'|| l_proc, 60);
797: ota_utility.Get_Default_Value_Dff(
798: appl_short_name => 'OTA'
799: ,flex_field_name => 'OTA_CERT_ENROLLMENTS'
800: ,p_attribute_category => l_attribute_category
801: ,p_attribute1 => l_attribute1
802: ,p_attribute2 => l_attribute2
803: ,p_attribute3 => l_attribute3