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_PRD_ENROLLMENTS

Line 557: p_cert_prd_enrollment_id ota_cert_prd_enrollments.cert_prd_enrollment_id%type) is

553: -- This cursor finds all certification member records in the certification
554: -- period that area associated with this learning object.
555: cursor cert_member_enrollments(
556: p_learning_object_id ota_learning_objects.learning_object_id%type,
557: p_cert_prd_enrollment_id ota_cert_prd_enrollments.cert_prd_enrollment_id%type) is
558: select distinct(cme.cert_mbr_enrollment_id),
559: cme.member_status_code,
560: cme.object_version_number,
561: cme.cert_member_id,

Line 564: ota_offerings o, ota_cert_prd_enrollments cpe

560: cme.object_version_number,
561: cme.cert_member_id,
562: cme.cert_prd_enrollment_id
563: from ota_certification_members cm, ota_cert_mbr_enrollments cme,
564: ota_offerings o, ota_cert_prd_enrollments cpe
565: where
566: cme.cert_prd_enrollment_id = p_cert_prd_enrollment_id
567: and cme.cert_member_id = cm.certification_member_id
568: and cm.object_id = o.activity_version_id

Line 1458: p_cert_prd_enroll_id ota_cert_prd_enrollments.cert_prd_enrollment_id%type,

1454: end user_can_attempt_event;
1455:
1456:
1457: function cert_is_attemptable(
1458: p_cert_prd_enroll_id ota_cert_prd_enrollments.cert_prd_enrollment_id%type,
1459: p_date date,
1460: p_reason out nocopy number) return boolean is
1461:
1462: v_cert_start_date ota_certifications_b.start_date_active%type;

Line 1464: v_cert_prd_enroll_start ota_cert_prd_enrollments.cert_period_start_date%type;

1460: p_reason out nocopy number) return boolean is
1461:
1462: v_cert_start_date ota_certifications_b.start_date_active%type;
1463: v_cert_end_date ota_certifications_b.end_date_active%type;
1464: v_cert_prd_enroll_start ota_cert_prd_enrollments.cert_period_start_date%type;
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

Line 1465: v_cert_prd_enroll_end ota_cert_prd_enrollments.cert_period_end_date%type;

1461:
1462: v_cert_start_date ota_certifications_b.start_date_active%type;
1463: v_cert_end_date ota_certifications_b.end_date_active%type;
1464: v_cert_prd_enroll_start ota_cert_prd_enrollments.cert_period_start_date%type;
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

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 1494: p_cert_prd_enroll_id ota_cert_prd_enrollments.cert_prd_enrollment_id%type,

1490: return false;
1491: end cert_is_attemptable;
1492:
1493: function user_is_enrolled_in_cert(
1494: p_cert_prd_enroll_id ota_cert_prd_enrollments.cert_prd_enrollment_id%type,
1495: p_user_id fnd_user.user_id%type,
1496: p_user_type ota_attempts.user_type%type,
1497: p_date date,
1498: p_reason out nocopy number) return boolean is

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 1534: p_cert_prd_enroll_id ota_cert_prd_enrollments.cert_prd_enrollment_id%type,

1530: return false;
1531: end user_is_enrolled_in_cert;
1532:
1533: function user_can_attempt_cert(
1534: p_cert_prd_enroll_id ota_cert_prd_enrollments.cert_prd_enrollment_id%type,
1535: p_user_id fnd_user.user_id%type,
1536: p_user_type ota_attempts.user_type%type,
1537: p_reason out nocopy number) return varchar2 is
1538:

Line 3555: p_cert_prd_enrollment_id in ota_cert_prd_enrollments.cert_prd_enrollment_id%type,

3551: p_user_type IN ota_attempts.user_type%type,
3552: p_event_id IN ota_events.event_id%TYPE,
3553: p_booking_status_type_id IN ota_booking_status_types.booking_status_type_id%TYPE,
3554: p_booking_id IN ota_delegate_bookings.booking_id%TYPE,
3555: p_cert_prd_enrollment_id in ota_cert_prd_enrollments.cert_prd_enrollment_id%type,
3556: p_mode IN number default null)
3557: RETURN VARCHAR2 IS
3558:
3559:

Line 3823: ota_cert_prd_enrollments cpe

3819: cmb.certification_member_id,
3820: cme.member_status_code
3821: FROM ota_certification_members cmb,
3822: ota_cert_mbr_enrollments cme,
3823: ota_cert_prd_enrollments cpe
3824: WHERE cpe.cert_prd_enrollment_id = cme.cert_prd_enrollment_id
3825: AND cme.cert_member_id = cmb.certification_member_id
3826: AND cme.cert_mbr_enrollment_id = p_cert_mbr_enrollment_id;
3827:

Line 3828: CURSOR csr_cert_enrl(csr_cert_prd_enrollment_id ota_cert_prd_enrollments.cert_prd_enrollment_id%type) IS

3824: WHERE cpe.cert_prd_enrollment_id = cme.cert_prd_enrollment_id
3825: AND cme.cert_member_id = cmb.certification_member_id
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

Line 3831: ota_cert_prd_enrollments cpe

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:
3835:

Line 4098: csr_cert_prd_enrollment_id ota_cert_prd_enrollments.cert_prd_enrollment_id%type) IS

4094: where cert_mbr_enrollment_id = p_cert_mbr_enrollment_id;
4095:
4096:
4097: CURSOR c_prd_lo_status(l_lo_id in ota_offerings.learning_object_id%TYPE,
4098: csr_cert_prd_enrollment_id ota_cert_prd_enrollments.cert_prd_enrollment_id%type) IS
4099: SELECT lesson_status,
4100: hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS',lesson_status)lesson_status_name
4101: FROM ota_performances
4102: WHERE user_id = p_user_id

Line 4118: csr_cert_prd_enrollment_id ota_cert_prd_enrollments.cert_prd_enrollment_id%type) IS

4114:
4115: CURSOR csr_prf_ord(p_activity_version_id in ota_activity_versions.activity_version_id%type,
4116: p_user_id in number,
4117: p_user_type in varchar2,
4118: csr_cert_prd_enrollment_id ota_cert_prd_enrollments.cert_prd_enrollment_id%type) IS
4119: SELECT prf.user_id,
4120: lo.learning_object_id,
4121: decode(prf.lesson_status, 'P', '1',
4122: 'C', '2',

Line 4145: l_cert_prd_enrollment_id ota_cert_prd_enrollments.cert_prd_enrollment_id%type;

4141: l_proc VARCHAR2(72) := g_package||'get_cert_lo_status';
4142: rec csr_event%rowtype;
4143: l_online_event_id ota_events.event_id%type;
4144:
4145: l_cert_prd_enrollment_id ota_cert_prd_enrollments.cert_prd_enrollment_id%type;
4146:
4147: l_status VARCHAR2(30) := null;
4148: l_status_name ota_booking_status_types_tl.name%TYPE := null;
4149:

Line 4239: ota_cert_prd_enrollments cpe

4235: cmb.certification_member_id,
4236: cme.member_status_code
4237: FROM ota_certification_members cmb,
4238: ota_cert_mbr_enrollments cme,
4239: ota_cert_prd_enrollments cpe
4240: WHERE cpe.cert_prd_enrollment_id = cme.cert_prd_enrollment_id
4241: AND cme.cert_member_id = cmb.certification_member_id
4242: AND cme.cert_mbr_enrollment_id = p_cert_mbr_enrollment_id;
4243:

Line 4244: CURSOR csr_cert_enrl(csr_cert_prd_enrollment_id ota_cert_prd_enrollments.cert_prd_enrollment_id%type) IS

4240: WHERE cpe.cert_prd_enrollment_id = cme.cert_prd_enrollment_id
4241: AND cme.cert_member_id = cmb.certification_member_id
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

Line 4247: ota_cert_prd_enrollments cpe

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:
4251:

Line 4855: OTA_CERT_PRD_ENROLLMENTS cpe,

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
4859: WHERE crt.CERTIFICATION_ID = cre.CERTIFICATION_ID

Line 4885: l_cert_prd_enrollment_id ota_cert_prd_enrollments.cert_prd_enrollment_id%TYPE;

4881:
4882: l_proc VARCHAR2(72) := g_package|| 'get_active_cert_prds';
4883:
4884: l_activity_version_id ota_events.activity_version_id%type;
4885: l_cert_prd_enrollment_id ota_cert_prd_enrollments.cert_prd_enrollment_id%TYPE;
4886: l_cert_prd_enrollment_ids varchar2(4000);
4887:
4888:
4889: begin