APPS.OTA_CPE_UTIL dependencies on OTA_CERT_PRD_ENROLLMENT_API

Line 350: ota_cert_prd_enrollment_api.update_cert_prd_enrollment

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

Line 385: ota_cert_prd_enrollment_api.update_cert_prd_enrollment

381: FETCH csr_prd_enrl INTO l_prd_enrl_rec;
382: CLOSE csr_prd_enrl;
383:
384: if (p_cert_period_end_date is not null and p_cert_period_end_date <> l_prd_enrl_rec.cert_period_end_date) then
385: ota_cert_prd_enrollment_api.update_cert_prd_enrollment
386: (p_effective_date => trunc(sysdate)
387: ,p_cert_enrollment_id => l_prd_enrl_rec.cert_enrollment_id
388: ,p_cert_prd_enrollment_id => p_cert_prd_enrollment_id
389: ,p_object_version_number => l_prd_enrl_rec.object_version_number

Line 1380: ota_cert_prd_enrollment_api.create_cert_prd_enrollment(

1376: ,p_attribute18 => l_attribute18
1377: ,p_attribute19 => l_attribute19
1378: ,p_attribute20 => l_attribute20);
1379:
1380: ota_cert_prd_enrollment_api.create_cert_prd_enrollment(
1381: p_effective_date => trunc(sysdate)
1382: ,p_cert_enrollment_id => p_cert_enrollment_id
1383: ,p_period_status_code => l_period_status_code
1384: ,p_cert_period_start_date => trunc(p_cert_period_start_date) --trunc(sysdate)

Line 1545: ota_cert_prd_enrollment_api.update_cert_prd_enrollment

1541: OPEN csr_prd_enrl(l_cert_prd_enrollment_id);
1542: FETCH csr_prd_enrl INTO l_prd_enrl_rec;
1543: CLOSE csr_prd_enrl;
1544:
1545: ota_cert_prd_enrollment_api.update_cert_prd_enrollment
1546: (p_effective_date => trunc(sysdate)
1547: ,p_cert_enrollment_id => p_cert_enrollment_id
1548: ,p_cert_prd_enrollment_id => l_cert_prd_enrollment_id
1549: ,p_object_version_number => l_prd_enrl_rec.object_version_number

Line 1733: ota_cert_prd_enrollment_api.update_cert_prd_enrollment

1729: OPEN csr_prd_enrl;
1730: FETCH csr_prd_enrl INTO l_prd_enrl_rec;
1731: CLOSE csr_prd_enrl;
1732:
1733: ota_cert_prd_enrollment_api.update_cert_prd_enrollment
1734: (p_effective_date => trunc(sysdate)
1735: ,p_cert_enrollment_id => p_cert_enrollment_id
1736: ,p_cert_prd_enrollment_id => p_cert_prd_enrollment_id
1737: ,p_object_version_number => l_prd_enrl_rec.object_version_number

Line 1778: ota_cert_prd_enrollment_api.update_cert_prd_enrollment

1774: OPEN csr_prd_enrl;
1775: FETCH csr_prd_enrl INTO l_prd_enrl_rec;
1776: CLOSE csr_prd_enrl;
1777:
1778: ota_cert_prd_enrollment_api.update_cert_prd_enrollment
1779: (p_effective_date => trunc(sysdate)
1780: ,p_cert_enrollment_id => p_cert_enrollment_id
1781: ,p_cert_prd_enrollment_id => p_cert_prd_enrollment_id
1782: ,p_object_version_number => l_prd_enrl_rec.object_version_number

Line 1896: ota_cert_prd_enrollment_api.update_cert_prd_enrollment(

1892: hr_utility.set_location('Entering:'||l_proc, 10);
1893: savepoint update_status_to_expired;
1894:
1895: --Update Period CPE status to Expired
1896: ota_cert_prd_enrollment_api.update_cert_prd_enrollment(
1897: p_effective_date => trunc(sysdate),
1898: p_cert_prd_enrollment_id => exp_sts_upd.cert_prd_enrollment_id,
1899: p_object_version_number => exp_sts_upd.object_version_number,
1900: p_cert_enrollment_id => exp_sts_upd.cert_enrollment_id,

Line 2456: ota_cert_prd_enrollment_api.update_cert_prd_enrollment

2452: OPEN csr_prd_enrl(rec_cert_details.cert_prd_enrollment_id);
2453: FETCH csr_prd_enrl INTO l_prd_enrl_rec;
2454: CLOSE csr_prd_enrl;
2455:
2456: ota_cert_prd_enrollment_api.update_cert_prd_enrollment
2457: (p_effective_date => trunc(sysdate)
2458: ,p_cert_enrollment_id => l_prd_enrl_rec.cert_enrollment_id
2459: ,p_cert_prd_enrollment_id => l_prd_enrl_rec.cert_prd_enrollment_id
2460: ,p_object_version_number => l_prd_enrl_rec.object_version_number