APPS.OTA_CERT_ENROLLMENT_API dependencies on OTA_CERT_ENROLLMENTS

Line 635: from ota_cert_enrollments cre

631: cre.cert_enrollment_id,
632: cre.certification_id,
633: cre.object_version_number,
634: cre.certification_status_code
635: from ota_cert_enrollments cre
636: where cre.certification_id = p_certification_id
637: and (cre.person_id = p_person_id or cre.contact_id = p_contact_id);
638:
639: CURSOR csr_cert_enrl(p_cert_enrollment_id in ota_cert_enrollments.cert_enrollment_id%type) IS

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

635: from ota_cert_enrollments cre
636: where cre.certification_id = p_certification_id
637: and (cre.person_id = p_person_id or cre.contact_id = p_contact_id);
638:
639: CURSOR csr_cert_enrl(p_cert_enrollment_id in ota_cert_enrollments.cert_enrollment_id%type) IS
640: select cert_enrollment_id, certification_id, certification_status_code, object_version_number, completion_date
641: FROM ota_cert_enrollments
642: where cert_enrollment_id = p_cert_enrollment_id;
643:

Line 641: FROM ota_cert_enrollments

637: and (cre.person_id = p_person_id or cre.contact_id = p_contact_id);
638:
639: CURSOR csr_cert_enrl(p_cert_enrollment_id in ota_cert_enrollments.cert_enrollment_id%type) IS
640: select cert_enrollment_id, certification_id, certification_status_code, object_version_number, completion_date
641: FROM ota_cert_enrollments
642: where cert_enrollment_id = p_cert_enrollment_id;
643:
644: CURSOR csr_prd_enrl(p_cert_enrollment_id in ota_cert_enrollments.cert_enrollment_id%type) IS
645: select cert_prd_enrollment_id, period_status_code, object_version_number, completion_date

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

640: select cert_enrollment_id, certification_id, certification_status_code, object_version_number, completion_date
641: FROM ota_cert_enrollments
642: where cert_enrollment_id = p_cert_enrollment_id;
643:
644: CURSOR csr_prd_enrl(p_cert_enrollment_id in ota_cert_enrollments.cert_enrollment_id%type) IS
645: select cert_prd_enrollment_id, period_status_code, object_version_number, completion_date
646: FROM ota_cert_prd_enrollments
647: where cert_enrollment_id = p_cert_enrollment_id
648: and trunc(sysdate) between trunc(cert_period_start_date) and nvl(trunc(cert_period_end_date),trunc(sysdate))

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

647: where cert_enrollment_id = p_cert_enrollment_id
648: and trunc(sysdate) between trunc(cert_period_start_date) and nvl(trunc(cert_period_end_date),trunc(sysdate))
649: order by cert_prd_enrollment_id desc;
650:
651: CURSOR csr_cpe_exist(p_cert_enrollment_id in ota_cert_enrollments.cert_enrollment_id%type) IS
652: select cert_prd_enrollment_id
653: FROM ota_cert_prd_enrollments
654: where cert_enrollment_id = p_cert_enrollment_id;
655:

Line 667: l_certification_status_code ota_cert_enrollments.certification_status_code%type;

663: l_object_version_number1 number;
664: l_object_version_number2 number;
665:
666: l_period_status_code VARCHAR2(30);
667: l_certification_status_code ota_cert_enrollments.certification_status_code%type;
668: l_cert_enrollment_id NUMBER;
669: l_cert_prd_enrollment_id NUMBER;
670: l_cert_mbr_enrollment_id NUMBER;
671:

Line 779: ,flex_field_name => 'OTA_CERT_ENROLLMENTS'

775:
776: hr_utility.set_location(' Step:'|| l_proc, 60);
777: ota_utility.Get_Default_Value_Dff(
778: appl_short_name => 'OTA'
779: ,flex_field_name => 'OTA_CERT_ENROLLMENTS'
780: ,p_attribute_category => l_attribute_category
781: ,p_attribute1 => l_attribute1
782: ,p_attribute2 => l_attribute2
783: ,p_attribute3 => l_attribute3