APPS.OTA_CPE_UTIL dependencies on OTA_CERT_PRD_ENROLLMENT_API

Line 351: ota_cert_prd_enrollment_api.update_cert_prd_enrollment

347: end if;
348:
349:
350:
351: ota_cert_prd_enrollment_api.update_cert_prd_enrollment
352: (p_effective_date => trunc(sysdate)
353: ,p_cert_enrollment_id => l_prd_enrl_rec.cert_enrollment_id
354: ,p_cert_prd_enrollment_id => p_cert_prd_enrollment_id
355: ,p_object_version_number => l_prd_enrl_rec.object_version_number

Line 393: ota_cert_prd_enrollment_api.update_cert_prd_enrollment

389: FETCH csr_prd_enrl INTO l_prd_enrl_rec;
390: CLOSE csr_prd_enrl;
391:
392: if (p_cert_period_end_date is not null and p_cert_period_end_date <> l_prd_enrl_rec.cert_period_end_date) then
393: ota_cert_prd_enrollment_api.update_cert_prd_enrollment
394: (p_effective_date => trunc(sysdate)
395: ,p_cert_enrollment_id => l_prd_enrl_rec.cert_enrollment_id
396: ,p_cert_prd_enrollment_id => p_cert_prd_enrollment_id
397: ,p_object_version_number => l_prd_enrl_rec.object_version_number

Line 1391: ota_cert_prd_enrollment_api.create_cert_prd_enrollment(

1387: ,p_attribute18 => l_attribute18
1388: ,p_attribute19 => l_attribute19
1389: ,p_attribute20 => l_attribute20);
1390:
1391: ota_cert_prd_enrollment_api.create_cert_prd_enrollment(
1392: p_effective_date => trunc(sysdate)
1393: ,p_cert_enrollment_id => p_cert_enrollment_id
1394: ,p_period_status_code => l_period_status_code
1395: ,p_cert_period_start_date => trunc(p_cert_period_start_date) --trunc(sysdate)

Line 1558: ota_cert_prd_enrollment_api.update_cert_prd_enrollment

1554: OPEN csr_prd_enrl(l_cert_prd_enrollment_id);
1555: FETCH csr_prd_enrl INTO l_prd_enrl_rec;
1556: CLOSE csr_prd_enrl;
1557:
1558: ota_cert_prd_enrollment_api.update_cert_prd_enrollment
1559: (p_effective_date => trunc(sysdate)
1560: ,p_cert_enrollment_id => p_cert_enrollment_id
1561: ,p_cert_prd_enrollment_id => l_cert_prd_enrollment_id
1562: ,p_object_version_number => l_prd_enrl_rec.object_version_number

Line 1752: ota_cert_prd_enrollment_api.update_cert_prd_enrollment

1748: OPEN csr_prd_enrl;
1749: FETCH csr_prd_enrl INTO l_prd_enrl_rec;
1750: CLOSE csr_prd_enrl;
1751:
1752: ota_cert_prd_enrollment_api.update_cert_prd_enrollment
1753: (p_effective_date => trunc(sysdate)
1754: ,p_cert_enrollment_id => p_cert_enrollment_id
1755: ,p_cert_prd_enrollment_id => p_cert_prd_enrollment_id
1756: ,p_object_version_number => l_prd_enrl_rec.object_version_number

Line 1803: ota_cert_prd_enrollment_api.update_cert_prd_enrollment

1799: OPEN csr_prd_enrl;
1800: FETCH csr_prd_enrl INTO l_prd_enrl_rec;
1801: CLOSE csr_prd_enrl;
1802:
1803: ota_cert_prd_enrollment_api.update_cert_prd_enrollment
1804: (p_effective_date => trunc(sysdate)
1805: ,p_cert_enrollment_id => p_cert_enrollment_id
1806: ,p_cert_prd_enrollment_id => p_cert_prd_enrollment_id
1807: ,p_object_version_number => l_prd_enrl_rec.object_version_number

Line 1935: ota_cert_prd_enrollment_api.update_cert_prd_enrollment(

1931: hr_utility.set_location('Entering:'||l_proc, 10);
1932: savepoint update_status_to_expired;
1933:
1934: --Update Period CPE status to Expired
1935: ota_cert_prd_enrollment_api.update_cert_prd_enrollment(
1936: p_effective_date => trunc(sysdate),
1937: p_cert_prd_enrollment_id => exp_sts_upd.cert_prd_enrollment_id,
1938: p_object_version_number => exp_sts_upd.object_version_number,
1939: p_cert_enrollment_id => exp_sts_upd.cert_enrollment_id,

Line 2495: ota_cert_prd_enrollment_api.update_cert_prd_enrollment

2491: OPEN csr_prd_enrl(rec_cert_details.cert_prd_enrollment_id);
2492: FETCH csr_prd_enrl INTO l_prd_enrl_rec;
2493: CLOSE csr_prd_enrl;
2494:
2495: ota_cert_prd_enrollment_api.update_cert_prd_enrollment
2496: (p_effective_date => trunc(sysdate)
2497: ,p_cert_enrollment_id => l_prd_enrl_rec.cert_enrollment_id
2498: ,p_cert_prd_enrollment_id => l_prd_enrl_rec.cert_prd_enrollment_id
2499: ,p_object_version_number => l_prd_enrl_rec.object_version_number