APPS.OTA_CPE_UTIL dependencies on OTA_CME_UTIL

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

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

Line 2010: ota_cme_util.get_enrl_status_on_update(rec_acty_info.object_id,

2006: for rec_acty_info in csr_acty_info(rec_cpe_status.cert_prd_enrollment_id)
2007: loop
2008: hr_utility.set_location('Step:'||l_proc, 10.1);
2009: -- get latest class enrollment status
2010: ota_cme_util.get_enrl_status_on_update(rec_acty_info.object_id,
2011: rec_cpe_status.cert_prd_enrollment_id,
2012: l_booking_status_type,
2013: l_date_status_changed);
2014:

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

2028: hr_utility.set_location('Step:'||l_proc, 10.3);
2029: do_update := true;
2030: end if;
2031: if do_update then
2032: ota_cme_util.update_cme_status(rec_acty_info.cert_mbr_enrollment_id);
2033: 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);
2034: ota_cme_util.update_cpe_status(rec_acty_info.cert_mbr_enrollment_id, l_cert_prd_enrollment_id, trunc(l_date_status_changed));
2035: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Updated the Certification period status for the cert_prd_enrollment_id = ' || l_cert_prd_enrollment_id);
2036: end if;

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

2030: end if;
2031: if do_update then
2032: ota_cme_util.update_cme_status(rec_acty_info.cert_mbr_enrollment_id);
2033: 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);
2034: ota_cme_util.update_cpe_status(rec_acty_info.cert_mbr_enrollment_id, l_cert_prd_enrollment_id, trunc(l_date_status_changed));
2035: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Updated the Certification period status for the cert_prd_enrollment_id = ' || l_cert_prd_enrollment_id);
2036: end if;
2037: do_update := false;
2038: end loop;