APPS.OTA_CPE_UTIL dependencies on OTA_CME_UTIL

Line 301: ota_cme_util.update_cme_status(rec_mbr_enrl.cert_mbr_enrollment_id);

297:
298: if p_child_update_flag = 'Y' then
299: for rec_mbr_enrl in csr_mbr_enrl
300: loop
301: ota_cme_util.update_cme_status(rec_mbr_enrl.cert_mbr_enrollment_id);
302: end loop;
303: end if;
304:
305: --check for period completion

Line 2049: ota_cme_util.get_enrl_status_on_update(rec_acty_info.object_id,

2045: for rec_acty_info in csr_acty_info(rec_cpe_status.cert_prd_enrollment_id)
2046: loop
2047: hr_utility.set_location('Step:'||l_proc, 10.1);
2048: -- get latest class enrollment status
2049: ota_cme_util.get_enrl_status_on_update(rec_acty_info.object_id,
2050: rec_cpe_status.cert_prd_enrollment_id,
2051: l_booking_status_type,
2052: l_date_status_changed);
2053:

Line 2071: ota_cme_util.update_cme_status(rec_acty_info.cert_mbr_enrollment_id);

2067: hr_utility.set_location('Step:'||l_proc, 10.3);
2068: do_update := true;
2069: end if;
2070: if do_update then
2071: ota_cme_util.update_cme_status(rec_acty_info.cert_mbr_enrollment_id);
2072: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Updated the Certification member status for the cert_mbr_enrollment_id = ' || rec_acty_info.cert_mbr_enrollment_id);
2073: ota_cme_util.update_cpe_status(rec_acty_info.cert_mbr_enrollment_id, l_cert_prd_enrollment_id, trunc(l_date_status_changed));
2074: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Updated the Certification period status for the cert_prd_enrollment_id = ' || l_cert_prd_enrollment_id);
2075: end if;

Line 2073: ota_cme_util.update_cpe_status(rec_acty_info.cert_mbr_enrollment_id, l_cert_prd_enrollment_id, trunc(l_date_status_changed));

2069: end if;
2070: if do_update then
2071: ota_cme_util.update_cme_status(rec_acty_info.cert_mbr_enrollment_id);
2072: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Updated the Certification member status for the cert_mbr_enrollment_id = ' || rec_acty_info.cert_mbr_enrollment_id);
2073: ota_cme_util.update_cpe_status(rec_acty_info.cert_mbr_enrollment_id, l_cert_prd_enrollment_id, trunc(l_date_status_changed));
2074: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Updated the Certification period status for the cert_prd_enrollment_id = ' || l_cert_prd_enrollment_id);
2075: end if;
2076: do_update := false;
2077: end loop;