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 11: OTA_CERT_MBR_ENROLLMENTS cme,

7: SELECT cpe.cert_prd_enrollment_id
8: FROM OTA_CERTIFICATIONS_B crt,
9: OTA_CERT_ENROLLMENTS cre,
10: OTA_CERT_PRD_ENROLLMENTS cpe,
11: OTA_CERT_MBR_ENROLLMENTS cme,
12: OTA_CERTIFICATION_MEMBERS cmb,
13: OTA_EVENTS evt
14: WHERE crt.CERTIFICATION_ID = cre.CERTIFICATION_ID
15: AND crt.CERTIFICATION_ID = cmb.CERTIFICATION_ID

Line 42: OTA_CERT_MBR_ENROLLMENTS cme,

38: SELECT cpe.cert_prd_enrollment_id
39: FROM OTA_CERTIFICATIONS_B crt,
40: OTA_CERT_ENROLLMENTS cre,
41: OTA_CERT_PRD_ENROLLMENTS cpe,
42: OTA_CERT_MBR_ENROLLMENTS cme,
43: OTA_CERTIFICATION_MEMBERS cmb,
44: OTA_EVENTS evt
45: WHERE crt.CERTIFICATION_ID = cre.CERTIFICATION_ID
46: AND crt.CERTIFICATION_ID = cmb.CERTIFICATION_ID

Line 220: p_cert_prd_enroll_id ota_cert_mbr_enrollments.cert_prd_enrollment_id%type) is

216:
217: procedure update_cme_status_for_lo(
218: p_lo_id ota_learning_objects.learning_object_id%type,
219: p_date date,
220: p_cert_prd_enroll_id ota_cert_mbr_enrollments.cert_prd_enrollment_id%type) is
221:
222: -- This cursor finds all certification member records in the certification
223: -- period that area associated with this learning object.
224: cursor cert_member_enrollments(

Line 234: from ota_certification_members cm, ota_cert_mbr_enrollments cme,

230: cme.cert_member_id,
231: cme.cert_prd_enrollment_id,
232: nvl(act.eres_enabled,'N') sign_enabled,
233: cm.object_id
234: from ota_certification_members cm, ota_cert_mbr_enrollments cme,
235: ota_offerings o, ota_cert_prd_enrollments cpe, ota_activity_versions act
236: where
237: cme.cert_prd_enrollment_id = p_cert_prd_enrollment_id
238: and cme.cert_member_id = cm.certification_member_id

Line 249: l_new_mbr_status_code ota_cert_mbr_enrollments.member_status_code%TYPE;

245: and trunc(sysdate) between trunc(cpe.cert_period_start_date) and trunc(cpe.cert_period_end_date)
246: and cme.member_status_code <> 'CANCELLED'
247: and act.activity_version_id = o.activity_version_id;
248:
249: l_new_mbr_status_code ota_cert_mbr_enrollments.member_status_code%TYPE;
250: l_member_status_code ota_cert_mbr_enrollments.member_status_code%TYPE;
251: l_completion_date ota_cert_mbr_enrollments.completion_date%TYPE;
252:
253: begin

Line 250: l_member_status_code ota_cert_mbr_enrollments.member_status_code%TYPE;

246: and cme.member_status_code <> 'CANCELLED'
247: and act.activity_version_id = o.activity_version_id;
248:
249: l_new_mbr_status_code ota_cert_mbr_enrollments.member_status_code%TYPE;
250: l_member_status_code ota_cert_mbr_enrollments.member_status_code%TYPE;
251: l_completion_date ota_cert_mbr_enrollments.completion_date%TYPE;
252:
253: begin
254: l_new_mbr_status_code := 'COMPLETED';

Line 251: l_completion_date ota_cert_mbr_enrollments.completion_date%TYPE;

247: and act.activity_version_id = o.activity_version_id;
248:
249: l_new_mbr_status_code ota_cert_mbr_enrollments.member_status_code%TYPE;
250: l_member_status_code ota_cert_mbr_enrollments.member_status_code%TYPE;
251: l_completion_date ota_cert_mbr_enrollments.completion_date%TYPE;
252:
253: begin
254: l_new_mbr_status_code := 'COMPLETED';
255:

Line 745: OTA_CERT_MBR_ENROLLMENTS cme,

741: p_person_id ota_cert_enrollments.person_id%type) is
742: SELECT cre.CERTIFICATION_STATUS_CODE
743: FROM OTA_CERTIFICATIONS_B crt,
744: OTA_CERT_ENROLLMENTS cre,
745: OTA_CERT_MBR_ENROLLMENTS cme,
746: OTA_CERTIFICATION_MEMBERS cmb,
747: OTA_EVENTS evt
748: WHERE crt.CERTIFICATION_ID = cre.CERTIFICATION_ID
749: AND crt.CERTIFICATION_ID = cmb.CERTIFICATION_ID

Line 764: OTA_CERT_MBR_ENROLLMENTS cme,

760: p_contact_id ota_cert_enrollments.contact_id%type) is
761: SELECT cre.CERTIFICATION_STATUS_CODE
762: FROM OTA_CERTIFICATIONS_B crt,
763: OTA_CERT_ENROLLMENTS cre,
764: OTA_CERT_MBR_ENROLLMENTS cme,
765: OTA_CERTIFICATION_MEMBERS cmb,
766: OTA_EVENTS evt
767: WHERE crt.CERTIFICATION_ID = cre.CERTIFICATION_ID
768: AND crt.CERTIFICATION_ID = cmb.CERTIFICATION_ID

Line 1554: p_cert_prd_enroll_id ota_cert_mbr_enrollments.cert_prd_enrollment_id%type,

1550: return true;
1551: end user_can_attempt_lo_3;
1552:
1553: function lo_is_in_cert(
1554: p_cert_prd_enroll_id ota_cert_mbr_enrollments.cert_prd_enrollment_id%type,
1555: p_lo_id ota_learning_objects.learning_object_id%type) return boolean is
1556:
1557: cursor root_los(p_cert_prd_enroll_id ota_cert_mbr_enrollments.cert_prd_enrollment_id%type) is
1558: select o.learning_object_id

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

1553: function lo_is_in_cert(
1554: p_cert_prd_enroll_id ota_cert_mbr_enrollments.cert_prd_enrollment_id%type,
1555: p_lo_id ota_learning_objects.learning_object_id%type) return boolean is
1556:
1557: cursor root_los(p_cert_prd_enroll_id ota_cert_mbr_enrollments.cert_prd_enrollment_id%type) is
1558: select o.learning_object_id
1559: from ota_offerings o, ota_certification_members cm, ota_cert_mbr_enrollments cme
1560: where o.activity_version_id = cm.object_id
1561: and cm.certification_member_id = cme.cert_member_id

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

1555: p_lo_id ota_learning_objects.learning_object_id%type) return boolean is
1556:
1557: cursor root_los(p_cert_prd_enroll_id ota_cert_mbr_enrollments.cert_prd_enrollment_id%type) is
1558: select o.learning_object_id
1559: from ota_offerings o, ota_certification_members cm, ota_cert_mbr_enrollments cme
1560: where o.activity_version_id = cm.object_id
1561: and cm.certification_member_id = cme.cert_member_id
1562: and cme.cert_prd_enrollment_id = p_cert_prd_enroll_id;
1563:

Line 2504: l_cert_mbr_enrollment_id ota_cert_mbr_enrollments.cert_mbr_enrollment_id%type;

2500:
2501: l_cert_prd_enrollment_ids varchar2(4000) := null;
2502: l_person_id ota_cert_enrollments.person_id%type := null;
2503: l_cert_prd_enrollment_id OTA_CERT_PRD_ENROLLMENTS.cert_prd_enrollment_id%type;
2504: l_cert_mbr_enrollment_id ota_cert_mbr_enrollments.cert_mbr_enrollment_id%type;
2505: begin
2506:
2507: if p_chk_active_cert_flag = 'Y' then
2508: l_cert_mbr_enrollment_id := ota_cme_util.get_cert_mbr_enroll_id(p_event_id, p_user_id, p_contact_id);

Line 4388: p_cert_mbr_enrollment_id in ota_cert_mbr_enrollments.cert_mbr_enrollment_id%type)

4384: End get_cert_lo_title_for_tree;
4385:
4386: function get_cme_online_event_id(p_user_id in fnd_user.user_id%type,
4387: p_user_type in ota_attempts.user_type%type,
4388: p_cert_mbr_enrollment_id in ota_cert_mbr_enrollments.cert_mbr_enrollment_id%type)
4389: return varchar2 is
4390: CURSOR csr_cme_info IS
4391: SELECT cme.cert_mbr_enrollment_id,
4392: cpe.cert_prd_enrollment_id,

Line 4398: ota_cert_mbr_enrollments cme,

4394: cmb.object_id,
4395: cmb.certification_member_id,
4396: cme.member_status_code
4397: FROM ota_certification_members cmb,
4398: ota_cert_mbr_enrollments cme,
4399: ota_cert_prd_enrollments cpe
4400: WHERE cpe.cert_prd_enrollment_id = cme.cert_prd_enrollment_id
4401: AND cme.cert_member_id = cmb.certification_member_id
4402: AND cme.cert_mbr_enrollment_id = p_cert_mbr_enrollment_id;

Line 4530: p_cert_mbr_enrollment_id in ota_cert_mbr_enrollments.cert_mbr_enrollment_id%type)

4526:
4527: function get_cme_play_button(p_user_id in fnd_user.user_id%type,
4528: p_user_type in ota_attempts.user_type%type,
4529: p_is_manager in varchar2,
4530: p_cert_mbr_enrollment_id in ota_cert_mbr_enrollments.cert_mbr_enrollment_id%type)
4531: return varchar2 is
4532:
4533: CURSOR csr_event(csr_event_id ota_events.event_id%type) IS
4534: SELECT

Line 4550: from ota_cert_mbr_enrollments

4546: AND OFR.DELIVERY_MODE_ID = ocu.CATEGORY_USAGE_ID;
4547:
4548: CURSOR csr_cme is
4549: select cert_prd_enrollment_id
4550: from ota_cert_mbr_enrollments
4551: where cert_mbr_enrollment_id = p_cert_mbr_enrollment_id;
4552:
4553: l_proc VARCHAR2(72) := g_package||'get_cme_Player_Toolbar_Flag';
4554: rec csr_event%rowtype;

Line 4601: p_cert_mbr_enrollment_id in ota_cert_mbr_enrollments.cert_mbr_enrollment_id%type)

4597:
4598:
4599: function get_cme_player_toolbar_flag(p_user_id in fnd_user.user_id%type,
4600: p_user_type in ota_attempts.user_type%type,
4601: p_cert_mbr_enrollment_id in ota_cert_mbr_enrollments.cert_mbr_enrollment_id%type)
4602: return varchar2 is
4603:
4604: cursor csr_toolbar_flag(csr_event_id ota_events.event_id%type) is
4605: select ofr.player_toolbar_flag

Line 4648: p_cert_mbr_enrollment_id in ota_cert_mbr_enrollments.cert_mbr_enrollment_id%type)

4644: End get_cme_player_toolbar_flag;
4645:
4646: function get_cert_lo_status(p_user_id in fnd_user.user_id%type,
4647: p_user_type in ota_attempts.user_type%type,
4648: p_cert_mbr_enrollment_id in ota_cert_mbr_enrollments.cert_mbr_enrollment_id%type)
4649: return varchar2 is
4650:
4651: CURSOR csr_event(csr_event_id ota_events.event_id%type) IS
4652: SELECT

Line 4669: from ota_cert_mbr_enrollments

4665: AND OFR.DELIVERY_MODE_ID = ocu.CATEGORY_USAGE_ID;
4666:
4667: CURSOR csr_cme is
4668: select cert_prd_enrollment_id
4669: from ota_cert_mbr_enrollments
4670: where cert_mbr_enrollment_id = p_cert_mbr_enrollment_id;
4671:
4672:
4673: CURSOR c_prd_lo_status(l_lo_id in ota_offerings.learning_object_id%TYPE,

Line 4686: ota_cert_mbr_enrollments cme

4682:
4683: cursor csr_get_act is
4684: select cmb.object_id
4685: from ota_certification_members cmb,
4686: ota_cert_mbr_enrollments cme
4687: where cmb.certification_member_id = cme.cert_member_id
4688: and cme.cert_mbr_enrollment_id = p_cert_mbr_enrollment_id
4689: and cmb.object_type = 'H';
4690:

Line 4804: p_cert_mbr_enrollment_id in ota_cert_mbr_enrollments.cert_mbr_enrollment_id%type)

4800: End get_cert_lo_status;
4801:
4802: function get_cme_onl_evt_count(p_user_id in fnd_user.user_id%type,
4803: p_user_type in ota_attempts.user_type%type,
4804: p_cert_mbr_enrollment_id in ota_cert_mbr_enrollments.cert_mbr_enrollment_id%type)
4805: return varchar2 is
4806: CURSOR csr_cme_info IS
4807: SELECT cme.cert_mbr_enrollment_id,
4808: cpe.cert_prd_enrollment_id,

Line 4814: ota_cert_mbr_enrollments cme,

4810: cmb.object_id,
4811: cmb.certification_member_id,
4812: cme.member_status_code
4813: FROM ota_certification_members cmb,
4814: ota_cert_mbr_enrollments cme,
4815: ota_cert_prd_enrollments cpe
4816: WHERE cpe.cert_prd_enrollment_id = cme.cert_prd_enrollment_id
4817: AND cme.cert_member_id = cmb.certification_member_id
4818: AND cme.cert_mbr_enrollment_id = p_cert_mbr_enrollment_id;