eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_CERT_PRD_ENROLLMENT_API dependencies on OTA_CERT_PRD_ENROLLMENTS

Line 303: from ota_cert_prd_enrollments cpe,

299:
300: CURSOR csr_max_cpe_exp_dt IS
301: select
302: max(cpe.expiration_date)
303: from ota_cert_prd_enrollments cpe,
304: ota_cert_enrollments cre
305: where cpe.cert_enrollment_id = cre.cert_enrollment_id
306: and cre.cert_enrollment_id = p_cert_enrollment_id;
307:

Line 311: from ota_cert_prd_enrollments cpe

307:
308: CURSOR csr_old_cpe_exp_dt IS
309: select
310: cpe.expiration_date
311: from ota_cert_prd_enrollments cpe
312: where cpe.cert_prd_enrollment_id = p_cert_prd_enrollment_id;
313:
314: l_proc varchar2(72) := g_package||' update_cert_prd_enrollment';
315: l_object_version_number number := p_object_version_number;

Line 795: l_cert_prd_enrollment_id ota_cert_prd_enrollments.cert_prd_enrollment_id%type;

791: rec_crt csr_crt%rowtype;
792: l_cert_enrl_rec csr_cert_enrl%ROWTYPE;
793:
794: l_cert_enrollment_id ota_cert_enrollments.cert_enrollment_id%type;
795: l_cert_prd_enrollment_id ota_cert_prd_enrollments.cert_prd_enrollment_id%type;
796:
797: p_effective_date DATE;
798: p_business_group_id DATE;
799: