DBA Data[Home] [Help]

APPS.OTA_CME_UTIL dependencies on OTA_CERT_MBR_ENROLLMENT_API

Line 306: ota_cert_mbr_enrollment_api.update_cert_mbr_enrollment

302: l_old_member_status := rec_cme_info.member_status_code;
303:
304: IF l_old_member_status <> l_member_status_code THEN
305: --call upd cme api after lck
306: ota_cert_mbr_enrollment_api.update_cert_mbr_enrollment
307: (p_effective_date => sysdate
308: ,p_object_version_number => rec_cme_info.object_version_number
309: ,p_cert_member_id => rec_cme_info.certification_member_id
310: ,p_cert_prd_enrollment_id => rec_cme_info.cert_prd_enrollment_id

Line 496: ota_cert_mbr_enrollment_api.update_cert_mbr_enrollment

492: l_old_member_status := rec_cme_info.member_status_code;
493:
494: IF l_old_member_status <> l_member_status_code THEN
495: --call upd cme api after lck
496: ota_cert_mbr_enrollment_api.update_cert_mbr_enrollment
497: (p_effective_date => sysdate
498: ,p_object_version_number => rec_cme_info.object_version_number
499: ,p_cert_member_id => rec_cme_info.certification_member_id
500: ,p_cert_prd_enrollment_id => rec_cme_info.cert_prd_enrollment_id

Line 714: ota_cert_mbr_enrollment_api.create_cert_mbr_enrollment(

710: ,p_attribute20 => l_attribute20);
711:
712: hr_utility.set_location(' Step:'||l_proc,30);
713:
714: ota_cert_mbr_enrollment_api.create_cert_mbr_enrollment(
715: p_effective_date => trunc(sysdate)
716: ,p_cert_prd_enrollment_id => p_cert_prd_enrollment_id
717: ,p_cert_member_id => new_crs.certification_member_id
718: ,p_member_status_code => 'PLANNED'

Line 753: ota_cert_mbr_enrollment_api.update_cert_mbr_enrollment

749: --update cme_record to CANCELLED status for activities which are ended during re-cert
750: for end_crs in csr_end_crs
751: loop
752: --update cme to CANCELLED
753: ota_cert_mbr_enrollment_api.update_cert_mbr_enrollment
754: (p_effective_date => sysdate
755: ,p_object_version_number => end_crs.object_version_number
756: ,p_cert_member_id => end_crs.certification_member_id
757: ,p_cert_prd_enrollment_id => p_cert_prd_enrollment_id