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_LO_UTILITY dependencies on OTA_CERT_ENROLLMENTS

Line 1469: from ota_certifications_b c, ota_cert_prd_enrollments cpe, ota_cert_enrollments ce

1465: v_cert_prd_enroll_end ota_cert_prd_enrollments.cert_period_end_date%type;
1466: begin
1467: select c.start_date_active, c.end_date_active, cpe.cert_period_start_date, cpe.cert_period_end_date
1468: into v_cert_start_date, v_cert_end_date, v_cert_prd_enroll_start, v_cert_prd_enroll_end
1469: from ota_certifications_b c, ota_cert_prd_enrollments cpe, ota_cert_enrollments ce
1470: where cpe.cert_prd_enrollment_id = p_cert_prd_enroll_id and
1471: cpe.cert_enrollment_id = ce.cert_enrollment_id and
1472: ce.certification_id = c.certification_id;
1473:

Line 1500: v_cert_unsubscribe_date ota_cert_enrollments.unenrollment_date%type;

1496: p_user_type ota_attempts.user_type%type,
1497: p_date date,
1498: p_reason out nocopy number) return boolean is
1499:
1500: v_cert_unsubscribe_date ota_cert_enrollments.unenrollment_date%type;
1501: --v_cert_enr_user_id ota_cert_enrollments.person_id%type;
1502: v_cert_enr_user_id number;
1503: l_user_id number;
1504: begin

Line 1501: --v_cert_enr_user_id ota_cert_enrollments.person_id%type;

1497: p_date date,
1498: p_reason out nocopy number) return boolean is
1499:
1500: v_cert_unsubscribe_date ota_cert_enrollments.unenrollment_date%type;
1501: --v_cert_enr_user_id ota_cert_enrollments.person_id%type;
1502: v_cert_enr_user_id number;
1503: l_user_id number;
1504: begin
1505: select ce.unenrollment_date, nvl(ce.person_id, ce.contact_id)

Line 1507: from ota_cert_prd_enrollments cpe, ota_cert_enrollments ce

1503: l_user_id number;
1504: begin
1505: select ce.unenrollment_date, nvl(ce.person_id, ce.contact_id)
1506: into v_cert_unsubscribe_date, v_cert_enr_user_id
1507: from ota_cert_prd_enrollments cpe, ota_cert_enrollments ce
1508: where cpe.cert_prd_enrollment_id = p_cert_prd_enroll_id and
1509: cpe.cert_enrollment_id = ce.cert_enrollment_id;
1510:
1511: --bug 4725513

Line 2091: p_contact_id ota_cert_enrollments.contact_id%type default null,

2087: p_course_start_date ota_events.course_start_date%type,
2088: p_course_end_date ota_events.course_end_date%type,
2089: p_enrollment_status_type ota_booking_status_types.type%TYPE DEFAULT NULL,
2090: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null,
2091: p_contact_id ota_cert_enrollments.contact_id%type default null,
2092: p_chk_active_cert_flag varchar2 default 'N') return varchar2 is
2093:
2094:
2095: v_number_of_los number(10);

Line 2117: l_person_id ota_cert_enrollments.person_id%type := null;

2113: From ota_events
2114: Where event_id = p_event_id;
2115:
2116: l_cert_prd_enrollment_ids varchar2(4000) := null;
2117: l_person_id ota_cert_enrollments.person_id%type := null;
2118:
2119: begin
2120:
2121: /*===============================================

Line 3091: l_person_id ota_cert_enrollments.person_id%type := null;

3087: -- Bug 3725560
3088: l_imported_offering ota_events.offering_id%TYPE := null;
3089:
3090: l_cert_prd_enrollment_ids varchar2(4000) := null;
3091: l_person_id ota_cert_enrollments.person_id%type := null;
3092: l_contact_id ota_cert_enrollments.contact_id%type := null;
3093:
3094:
3095: BEGIN

Line 3092: l_contact_id ota_cert_enrollments.contact_id%type := null;

3088: l_imported_offering ota_events.offering_id%TYPE := null;
3089:
3090: l_cert_prd_enrollment_ids varchar2(4000) := null;
3091: l_person_id ota_cert_enrollments.person_id%type := null;
3092: l_contact_id ota_cert_enrollments.contact_id%type := null;
3093:
3094:
3095: BEGIN
3096: hr_utility.set_location(' Step:'|| l_proc, 10);

Line 3830: FROM ota_cert_enrollments cre,

3826: AND cme.cert_mbr_enrollment_id = p_cert_mbr_enrollment_id;
3827:
3828: CURSOR csr_cert_enrl(csr_cert_prd_enrollment_id ota_cert_prd_enrollments.cert_prd_enrollment_id%type) IS
3829: SELECT cre.person_id, cre.contact_id, cpe.cert_period_start_date, cpe.cert_period_end_date
3830: FROM ota_cert_enrollments cre,
3831: ota_cert_prd_enrollments cpe
3832: where cpe.cert_prd_enrollment_id = csr_cert_prd_enrollment_id
3833: and cpe.cert_enrollment_id = cre.cert_enrollment_id;
3834:

Line 4246: FROM ota_cert_enrollments cre,

4242: AND cme.cert_mbr_enrollment_id = p_cert_mbr_enrollment_id;
4243:
4244: CURSOR csr_cert_enrl(csr_cert_prd_enrollment_id ota_cert_prd_enrollments.cert_prd_enrollment_id%type) IS
4245: SELECT cre.person_id, cre.contact_id, cpe.cert_period_start_date, cpe.cert_period_end_date
4246: FROM ota_cert_enrollments cre,
4247: ota_cert_prd_enrollments cpe
4248: where cpe.cert_prd_enrollment_id = csr_cert_prd_enrollment_id
4249: and cpe.cert_enrollment_id = cre.cert_enrollment_id;
4250:

Line 4846: p_person_id ota_cert_enrollments.contact_id%type,

4842: End get_lme_onl_evt_count;
4843:
4844: procedure get_active_cert_prds(
4845: p_event_id ota_events.event_id%type,
4846: p_person_id ota_cert_enrollments.contact_id%type,
4847: p_contact_id ota_cert_enrollments.contact_id%type,
4848: p_cert_prd_enrollment_ids OUT NOCOPY varchar2) is
4849:
4850: cursor csr_active_cert_prd is

Line 4847: p_contact_id ota_cert_enrollments.contact_id%type,

4843:
4844: procedure get_active_cert_prds(
4845: p_event_id ota_events.event_id%type,
4846: p_person_id ota_cert_enrollments.contact_id%type,
4847: p_contact_id ota_cert_enrollments.contact_id%type,
4848: p_cert_prd_enrollment_ids OUT NOCOPY varchar2) is
4849:
4850: cursor csr_active_cert_prd is
4851: SELECT cpe.cert_prd_enrollment_id

Line 4854: OTA_CERT_ENROLLMENTS cre,

4850: cursor csr_active_cert_prd is
4851: SELECT cpe.cert_prd_enrollment_id
4852: FROM
4853: OTA_CERTIFICATIONS_B crt,
4854: OTA_CERT_ENROLLMENTS cre,
4855: OTA_CERT_PRD_ENROLLMENTS cpe,
4856: OTA_CERT_MBR_ENROLLMENTS cme,
4857: OTA_CERTIFICATION_MEMBERS cmb,
4858: OTA_EVENTS evt