APPS.OTA_CPE_UTIL dependencies on OTA_CERT_ENROLLMENT_API

Line 368: ota_cert_enrollment_api.update_cert_enrollment

364: --get the recent expiration_date updated within cpe.. update api
365: l_expiration_date := l_cert_enrl_rec.expiration_date;
366: end if;
367:
368: ota_cert_enrollment_api.update_cert_enrollment
369: (p_effective_date => trunc(sysdate)
370: ,p_cert_enrollment_id => l_prd_enrl_rec.cert_enrollment_id
371: ,p_certification_id => l_cert_enrl_rec.certification_id
372: ,p_object_version_number => l_cert_enrl_rec.object_version_number

Line 1556: ota_cert_enrollment_api.update_cert_enrollment

1552:
1553:
1554: --update cre only if its already CERTIFIED on renew actn
1555: -- if l_certification_status_code = 'CERTIFIED' then
1556: ota_cert_enrollment_api.update_cert_enrollment
1557: (p_effective_date => trunc(sysdate)
1558: ,p_cert_enrollment_id => p_cert_enrollment_id
1559: ,p_certification_id => l_cert_enrl_rec.certification_id
1560: ,p_object_version_number => l_cert_enrl_rec.object_version_number

Line 1721: ota_cert_enrollment_api.update_cert_enrollment

1717: OPEN csr_cert_enrl;
1718: FETCH csr_cert_enrl INTO l_cert_enrl_rec;
1719: CLOSE csr_cert_enrl;
1720:
1721: ota_cert_enrollment_api.update_cert_enrollment
1722: (p_effective_date => trunc(sysdate)
1723: ,p_cert_enrollment_id => p_cert_enrollment_id
1724: ,p_certification_id => l_cert_enrl_rec.certification_id
1725: ,p_object_version_number => l_cert_enrl_rec.object_version_number

Line 1765: ota_cert_enrollment_api.update_cert_enrollment

1761: OPEN csr_cert_enrl;
1762: FETCH csr_cert_enrl INTO l_cert_enrl_rec;
1763: CLOSE csr_cert_enrl;
1764:
1765: ota_cert_enrollment_api.update_cert_enrollment
1766: (p_effective_date => trunc(sysdate)
1767: ,p_cert_enrollment_id => p_cert_enrollment_id
1768: ,p_certification_id => l_cert_enrl_rec.certification_id
1769: ,p_object_version_number => l_cert_enrl_rec.object_version_number

Line 1800: ota_cert_enrollment_api.update_cert_enrollment

1796: OPEN csr_cert_enrl;
1797: FETCH csr_cert_enrl INTO l_cert_enrl_rec;
1798: CLOSE csr_cert_enrl;
1799:
1800: ota_cert_enrollment_api.update_cert_enrollment
1801: (p_effective_date => trunc(sysdate)
1802: ,p_cert_enrollment_id => p_cert_enrollment_id
1803: ,p_certification_id => l_cert_enrl_rec.certification_id
1804: ,p_object_version_number => l_cert_enrl_rec.object_version_number

Line 1925: ota_cert_enrollment_api.update_cert_enrollment(

1921: trunc(sysdate) > trunc(exp_records.expiration_date) )
1922: or exp_records.initial_completion_date is not null) then
1923:
1924: --Update CRE status to Expired
1925: ota_cert_enrollment_api.update_cert_enrollment(
1926: p_effective_date => trunc(sysdate),
1927: p_cert_enrollment_id => exp_records.cert_enrollment_id,
1928: p_certification_id => exp_records.certification_id,
1929: p_object_version_number => exp_records.object_version_number,

Line 2440: ota_cert_enrollment_api.update_cert_enrollment

2436: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Earliest Enroll Date = ' || l_earliest_enroll_date);
2437: FND_FILE.PUT_LINE(FND_FILE.LOG, 'New Expiration Date = ' || l_expiration_date);
2438: FND_FILE.PUT_LINE(FND_FILE.LOG, '--------------------------------------------------------');
2439:
2440: ota_cert_enrollment_api.update_cert_enrollment
2441: (p_effective_date => sysdate
2442: ,p_cert_enrollment_id => l_cert_enrl_rec.cert_enrollment_id
2443: ,p_certification_id => l_cert_enrl_rec.certification_id
2444: ,p_object_version_number => l_cert_enrl_rec.object_version_number