APPS.OTA_CERT_PRD_ENROLLMENT_API dependencies on OTA_CPE_UTIL

Line 593: if ('Y' = ota_cpe_util.is_cert_success_complete(p_cert_prd_enrollment_id => p_cert_prd_enrollment_id,

589: l_cert_period_end_date :=
590: ota_cpe_shd.g_old_rec.cert_period_end_date;
591: End If;
592:
593: if ('Y' = ota_cpe_util.is_cert_success_complete(p_cert_prd_enrollment_id => p_cert_prd_enrollment_id,
594: p_cert_period_start_date => l_cert_period_start_date
595: ,p_cert_period_end_date => l_cert_period_end_date,
596: p_person_id => l_cert_enrl_rec.person_id)) then
597: ota_competence_ss.create_wf_process(p_process =>'OTA_COMPETENCE_UPDATE_JSP_PRC',

Line 818: ota_cpe_util.calc_cre_dates(p_cert_enrollment_id, rec_crt.certification_id, null, l_earliest_enroll_date, l_expiration_date, p_cert_period_start_date);

814: FETCH csr_crt INTO rec_crt;
815: CLOSE csr_crt;
816:
817: if (rec_crt.renewable_flag = 'Y') then
818: ota_cpe_util.calc_cre_dates(p_cert_enrollment_id, rec_crt.certification_id, null, l_earliest_enroll_date, l_expiration_date, p_cert_period_start_date);
819: end if; --end renewal flag
820:
821: ota_cpe_util.create_cpe_rec(p_cert_enrollment_id => p_cert_enrollment_id,
822: p_expiration_date => l_expiration_date,

Line 821: ota_cpe_util.create_cpe_rec(p_cert_enrollment_id => p_cert_enrollment_id,

817: if (rec_crt.renewable_flag = 'Y') then
818: ota_cpe_util.calc_cre_dates(p_cert_enrollment_id, rec_crt.certification_id, null, l_earliest_enroll_date, l_expiration_date, p_cert_period_start_date);
819: end if; --end renewal flag
820:
821: ota_cpe_util.create_cpe_rec(p_cert_enrollment_id => p_cert_enrollment_id,
822: p_expiration_date => l_expiration_date,
823: p_cert_period_start_date => p_cert_period_start_date,
824: p_cert_prd_enrollment_id => l_cert_prd_enrollment_id,
825: p_certification_status_code => l_certification_status_code);