APPS.OTA_LO_UTILITY dependencies on OTA_ACTIVITY_VERSIONS

Line 235: ota_offerings o, ota_cert_prd_enrollments cpe, ota_activity_versions act

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
239: and cm.object_id = o.activity_version_id

Line 672: ota_activity_versions act

668: ota_offerings offr,
669: ota_learning_objects lo,
670: ota_delegate_bookings book,
671: ota_booking_status_types stype,
672: ota_activity_versions act
673: where lo.source_learning_object_id = p_lo_id and
674: lo.learning_object_id = offr.learning_object_id and
675: offr.offering_id = ev.parent_offering_id and
676: nvl(ev.course_start_date, sysdate) <= sysdate and

Line 711: ota_activity_versions act

707: ota_booking_status_types stype,
708: hz_cust_account_roles acct_role,
709: hz_relationships rel,
710: hz_cust_accounts role_acct,
711: ota_activity_versions act
712: where lo.source_learning_object_id = p_lo_id and
713: lo.learning_object_id = offr.learning_object_id and
714: offr.offering_id = ev.parent_offering_id and
715: nvl(ev.course_start_date, sysdate) <= sysdate and

Line 2485: v_rco_id ota_activity_versions.rco_id%type := null;

2481: v_solo_lo_id ota_learning_objects.learning_object_id%type := null;
2482: v_published_flag ota_learning_objects.published_flag%type := null;
2483: v_first_lo ota_learning_objects.learning_object_id%type := null;
2484: v_play_button_for_test varchar2(100) := null;
2485: v_rco_id ota_activity_versions.rco_id%type := null;
2486: v_offering_id ota_events.offering_id%type := null;
2487:
2488: l_reason number;
2489: l_sysdate date;

Line 2584: from ota_activity_versions a, ota_events e

2580: select a.rco_id
2581: ,e.offering_id
2582: into v_rco_id
2583: ,v_offering_id
2584: from ota_activity_versions a, ota_events e
2585: where a.activity_version_id = e.activity_version_id
2586: and e.event_id = p_event_id;
2587:
2588: if v_rco_id is not null and v_offering_id is not null then

Line 4691: CURSOR csr_prf_ord(p_activity_version_id in ota_activity_versions.activity_version_id%type,

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:
4691: CURSOR csr_prf_ord(p_activity_version_id in ota_activity_versions.activity_version_id%type,
4692: p_user_id in number,
4693: p_user_type in varchar2,
4694: csr_cert_prd_enrollment_id ota_cert_prd_enrollments.cert_prd_enrollment_id%type) IS
4695: SELECT prf.user_id,

Line 5242: CURSOR csr_prf_ord(p_activity_version_id in ota_activity_versions.activity_version_id%type,

5238: where lpm.LEARNING_PATH_MEMBER_ID = lme.LEARNING_PATH_MEMBER_ID
5239: and lme.lp_member_enrollment_id = p_lp_member_enrollment_id;
5240:
5241:
5242: CURSOR csr_prf_ord(p_activity_version_id in ota_activity_versions.activity_version_id%type,
5243: p_user_id in number,
5244: p_user_type in varchar2) IS
5245: SELECT prf.user_id,
5246: lo.learning_object_id,