DBA Data[Home] [Help]

APPS.OTA_CERT_ENROLLMENT_API dependencies on OTA_CPE_UTIL

Line 764: ota_cpe_util.calc_cre_dates(null, l_cert_rec.certification_id, 'I', l_earliest_enroll_date, l_expiration_date, p_enrollment_date);

760: --for renewable certs calc based on initial_completion_date, INITIAL_COMPLETION_DURATION,
761: --validity_start_type and validity_duration
762:
763: if (l_cert_rec.renewable_flag = 'Y') then
764: ota_cpe_util.calc_cre_dates(null, l_cert_rec.certification_id, 'I', l_earliest_enroll_date, l_expiration_date, p_enrollment_date);
765: end if; --end renewal flag
766:
767: hr_utility.set_location(' Step:'|| l_proc, 50);
768:

Line 863: ota_cpe_util.create_cpe_rec(p_cert_enrollment_id => l_cert_enrollment_id,

859: );
860: end if;
861:
862: --call create CPE and CME util proc
863: ota_cpe_util.create_cpe_rec(p_cert_enrollment_id => l_cert_enrollment_id,
864: p_expiration_date => l_expiration_date,
865: p_cert_period_start_date => trunc(nvl(p_enrollment_date, sysdate)),
866: p_cert_prd_enrollment_id => l_cert_prd_enrollment_id,
867: p_certification_status_code => l_certification_status_code);

Line 933: ota_cpe_util.update_cpe_status(l_cert_prd_enrollment_id,

929: --Bug 4565761
930: ota_cme_util.refresh_cme(l_cert_prd_enrollment_id);
931:
932: --calculate period and mbr enroll status for existing data and update accordingly
933: ota_cpe_util.update_cpe_status(l_cert_prd_enrollment_id,
934: p_certification_status_code => l_certification_status_code);
935:
936: hr_utility.set_location(' Step:'|| l_proc, 120);
937:

Line 965: ota_cpe_util.create_cpe_rec(p_cert_enrollment_id => l_cert_enrollment_id,

961:
962: hr_utility.set_location(' Step:'|| l_proc, 140);
963:
964: --call create CPE and CME util proc
965: ota_cpe_util.create_cpe_rec(p_cert_enrollment_id => l_cert_enrollment_id,
966: p_expiration_date => l_expiration_date,
967: p_cert_period_start_date => trunc(nvl(p_enrollment_date, sysdate)),
968: p_cert_prd_enrollment_id => l_cert_prd_enrollment_id,
969: p_certification_status_code => l_certification_status_code);