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_MBR_ENROLLMENTS

Line 551: p_cert_prd_enroll_id ota_cert_mbr_enrollments.cert_prd_enrollment_id%type) is

547:
548: procedure update_cme_status_for_lo(
549: p_lo_id ota_learning_objects.learning_object_id%type,
550: p_date date,
551: p_cert_prd_enroll_id ota_cert_mbr_enrollments.cert_prd_enrollment_id%type) is
552:
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(

Line 563: from ota_certification_members cm, ota_cert_mbr_enrollments cme,

559: cme.member_status_code,
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

Line 577: l_new_mbr_status_code ota_cert_mbr_enrollments.member_status_code%TYPE;

573: and cpe.period_status_code <> 'CANCELLED'
574: and trunc(sysdate) between trunc(cpe.cert_period_start_date) and trunc(cpe.cert_period_end_date)
575: and cme.member_status_code <> 'CANCELLED';
576:
577: l_new_mbr_status_code ota_cert_mbr_enrollments.member_status_code%TYPE;
578:
579: begin
580: l_new_mbr_status_code := 'COMPLETED';
581:

Line 1248: p_cert_prd_enroll_id ota_cert_mbr_enrollments.cert_prd_enrollment_id%type,

1244: return true;
1245: end user_can_attempt_lo_3;
1246:
1247: function lo_is_in_cert(
1248: p_cert_prd_enroll_id ota_cert_mbr_enrollments.cert_prd_enrollment_id%type,
1249: p_lo_id ota_learning_objects.learning_object_id%type) return boolean is
1250:
1251: cursor root_los(p_cert_prd_enroll_id ota_cert_mbr_enrollments.cert_prd_enrollment_id%type) is
1252: select o.learning_object_id

Line 1251: cursor root_los(p_cert_prd_enroll_id ota_cert_mbr_enrollments.cert_prd_enrollment_id%type) is

1247: function lo_is_in_cert(
1248: p_cert_prd_enroll_id ota_cert_mbr_enrollments.cert_prd_enrollment_id%type,
1249: p_lo_id ota_learning_objects.learning_object_id%type) return boolean is
1250:
1251: cursor root_los(p_cert_prd_enroll_id ota_cert_mbr_enrollments.cert_prd_enrollment_id%type) is
1252: select o.learning_object_id
1253: from ota_offerings o, ota_certification_members cm, ota_cert_mbr_enrollments cme
1254: where o.activity_version_id = cm.object_id
1255: and cm.certification_member_id = cme.cert_member_id

Line 1253: from ota_offerings o, ota_certification_members cm, ota_cert_mbr_enrollments cme

1249: p_lo_id ota_learning_objects.learning_object_id%type) return boolean is
1250:
1251: cursor root_los(p_cert_prd_enroll_id ota_cert_mbr_enrollments.cert_prd_enrollment_id%type) is
1252: select o.learning_object_id
1253: from ota_offerings o, ota_certification_members cm, ota_cert_mbr_enrollments cme
1254: where o.activity_version_id = cm.object_id
1255: and cm.certification_member_id = cme.cert_member_id
1256: and cme.cert_prd_enrollment_id = p_cert_prd_enroll_id;
1257:

Line 3812: p_cert_mbr_enrollment_id in ota_cert_mbr_enrollments.cert_mbr_enrollment_id%type)

3808: End get_cert_lo_title_for_tree;
3809:
3810: function get_cme_online_event_id(p_user_id in fnd_user.user_id%type,
3811: p_user_type in ota_attempts.user_type%type,
3812: p_cert_mbr_enrollment_id in ota_cert_mbr_enrollments.cert_mbr_enrollment_id%type)
3813: return varchar2 is
3814: CURSOR csr_cme_info IS
3815: SELECT cme.cert_mbr_enrollment_id,
3816: cpe.cert_prd_enrollment_id,

Line 3822: ota_cert_mbr_enrollments cme,

3818: cmb.object_id,
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;

Line 3954: p_cert_mbr_enrollment_id in ota_cert_mbr_enrollments.cert_mbr_enrollment_id%type)

3950:
3951: function get_cme_play_button(p_user_id in fnd_user.user_id%type,
3952: p_user_type in ota_attempts.user_type%type,
3953: p_is_manager in varchar2,
3954: p_cert_mbr_enrollment_id in ota_cert_mbr_enrollments.cert_mbr_enrollment_id%type)
3955: return varchar2 is
3956:
3957: CURSOR csr_event(csr_event_id ota_events.event_id%type) IS
3958: SELECT

Line 3974: from ota_cert_mbr_enrollments

3970: AND OFR.DELIVERY_MODE_ID = ocu.CATEGORY_USAGE_ID;
3971:
3972: CURSOR csr_cme is
3973: select cert_prd_enrollment_id
3974: from ota_cert_mbr_enrollments
3975: where cert_mbr_enrollment_id = p_cert_mbr_enrollment_id;
3976:
3977: l_proc VARCHAR2(72) := g_package||'get_cme_Player_Toolbar_Flag';
3978: rec csr_event%rowtype;

Line 4025: p_cert_mbr_enrollment_id in ota_cert_mbr_enrollments.cert_mbr_enrollment_id%type)

4021:
4022:
4023: function get_cme_player_toolbar_flag(p_user_id in fnd_user.user_id%type,
4024: p_user_type in ota_attempts.user_type%type,
4025: p_cert_mbr_enrollment_id in ota_cert_mbr_enrollments.cert_mbr_enrollment_id%type)
4026: return varchar2 is
4027:
4028: cursor csr_toolbar_flag(csr_event_id ota_events.event_id%type) is
4029: select ofr.player_toolbar_flag

Line 4072: p_cert_mbr_enrollment_id in ota_cert_mbr_enrollments.cert_mbr_enrollment_id%type)

4068: End get_cme_player_toolbar_flag;
4069:
4070: function get_cert_lo_status(p_user_id in fnd_user.user_id%type,
4071: p_user_type in ota_attempts.user_type%type,
4072: p_cert_mbr_enrollment_id in ota_cert_mbr_enrollments.cert_mbr_enrollment_id%type)
4073: return varchar2 is
4074:
4075: CURSOR csr_event(csr_event_id ota_events.event_id%type) IS
4076: SELECT

Line 4093: from ota_cert_mbr_enrollments

4089: AND OFR.DELIVERY_MODE_ID = ocu.CATEGORY_USAGE_ID;
4090:
4091: CURSOR csr_cme is
4092: select cert_prd_enrollment_id
4093: from ota_cert_mbr_enrollments
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,

Line 4110: ota_cert_mbr_enrollments cme

4106:
4107: cursor csr_get_act is
4108: select cmb.object_id
4109: from ota_certification_members cmb,
4110: ota_cert_mbr_enrollments cme
4111: where cmb.certification_member_id = cme.cert_member_id
4112: and cme.cert_mbr_enrollment_id = p_cert_mbr_enrollment_id
4113: and cmb.object_type = 'H';
4114:

Line 4228: p_cert_mbr_enrollment_id in ota_cert_mbr_enrollments.cert_mbr_enrollment_id%type)

4224: End get_cert_lo_status;
4225:
4226: function get_cme_onl_evt_count(p_user_id in fnd_user.user_id%type,
4227: p_user_type in ota_attempts.user_type%type,
4228: p_cert_mbr_enrollment_id in ota_cert_mbr_enrollments.cert_mbr_enrollment_id%type)
4229: return varchar2 is
4230: CURSOR csr_cme_info IS
4231: SELECT cme.cert_mbr_enrollment_id,
4232: cpe.cert_prd_enrollment_id,

Line 4238: ota_cert_mbr_enrollments cme,

4234: cmb.object_id,
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;

Line 4856: OTA_CERT_MBR_ENROLLMENTS cme,

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
4860: AND crt.CERTIFICATION_ID = cmb.CERTIFICATION_ID