APPS.OTA_CPE_UTIL dependencies on OTA_CERT_ENROLLMENT_API

Line 375: ota_cert_enrollment_api.update_cert_enrollment

371: else
372: l_unenrollment_date := l_cert_enrl_rec.unenrollment_date;
373: end if;
374:
375: ota_cert_enrollment_api.update_cert_enrollment
376: (p_effective_date => trunc(sysdate)
377: ,p_cert_enrollment_id => l_prd_enrl_rec.cert_enrollment_id
378: ,p_certification_id => l_cert_enrl_rec.certification_id
379: ,p_object_version_number => l_cert_enrl_rec.object_version_number

Line 1569: ota_cert_enrollment_api.update_cert_enrollment

1565:
1566:
1567: --update cre only if its already CERTIFIED on renew actn
1568: -- if l_certification_status_code = 'CERTIFIED' then
1569: ota_cert_enrollment_api.update_cert_enrollment
1570: (p_effective_date => trunc(sysdate)
1571: ,p_cert_enrollment_id => p_cert_enrollment_id
1572: ,p_certification_id => l_cert_enrl_rec.certification_id
1573: ,p_object_version_number => l_cert_enrl_rec.object_version_number

Line 1740: ota_cert_enrollment_api.update_cert_enrollment

1736: OPEN csr_cert_enrl;
1737: FETCH csr_cert_enrl INTO l_cert_enrl_rec;
1738: CLOSE csr_cert_enrl;
1739:
1740: ota_cert_enrollment_api.update_cert_enrollment
1741: (p_effective_date => trunc(sysdate)
1742: ,p_cert_enrollment_id => p_cert_enrollment_id
1743: ,p_certification_id => l_cert_enrl_rec.certification_id
1744: ,p_object_version_number => l_cert_enrl_rec.object_version_number

Line 1784: ota_cert_enrollment_api.update_cert_enrollment

1780: OPEN csr_cert_enrl;
1781: FETCH csr_cert_enrl INTO l_cert_enrl_rec;
1782: CLOSE csr_cert_enrl;
1783:
1784: ota_cert_enrollment_api.update_cert_enrollment
1785: (p_effective_date => trunc(sysdate)
1786: ,p_cert_enrollment_id => p_cert_enrollment_id
1787: ,p_certification_id => l_cert_enrl_rec.certification_id
1788: ,p_object_version_number => l_cert_enrl_rec.object_version_number

Line 1838: ota_cert_enrollment_api.update_cert_enrollment

1834: OPEN csr_cert_enrl;
1835: FETCH csr_cert_enrl INTO l_cert_enrl_rec;
1836: CLOSE csr_cert_enrl;
1837:
1838: ota_cert_enrollment_api.update_cert_enrollment
1839: (p_effective_date => trunc(sysdate)
1840: ,p_cert_enrollment_id => p_cert_enrollment_id
1841: ,p_certification_id => l_cert_enrl_rec.certification_id
1842: ,p_object_version_number => l_cert_enrl_rec.object_version_number

Line 1964: ota_cert_enrollment_api.update_cert_enrollment(

1960: trunc(sysdate) > trunc(exp_records.expiration_date) )
1961: or exp_records.initial_completion_date is not null) then
1962:
1963: --Update CRE status to Expired
1964: ota_cert_enrollment_api.update_cert_enrollment(
1965: p_effective_date => trunc(sysdate),
1966: p_cert_enrollment_id => exp_records.cert_enrollment_id,
1967: p_certification_id => exp_records.certification_id,
1968: p_object_version_number => exp_records.object_version_number,

Line 2479: ota_cert_enrollment_api.update_cert_enrollment

2475: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Earliest Enroll Date = ' || l_earliest_enroll_date);
2476: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Expiration Date = ' || l_expiration_date);
2477: FND_FILE.PUT_LINE(FND_FILE.LOG, '--------------------------------------------------------');
2478:
2479: ota_cert_enrollment_api.update_cert_enrollment
2480: (p_effective_date => sysdate
2481: ,p_cert_enrollment_id => l_cert_enrl_rec.cert_enrollment_id
2482: ,p_certification_id => l_cert_enrl_rec.certification_id
2483: ,p_object_version_number => l_cert_enrl_rec.object_version_number