APPS.OTA_LO_UTILITY dependencies on OTA_ACTIVITY_VERSIONS

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

2096: v_solo_lo_id ota_learning_objects.learning_object_id%type := null;
2097: v_published_flag ota_learning_objects.published_flag%type := null;
2098: v_first_lo ota_learning_objects.learning_object_id%type := null;
2099: v_play_button_for_test varchar2(100) := null;
2100: v_rco_id ota_activity_versions.rco_id%type := null;
2101: v_offering_id ota_events.offering_id%type := null;
2102:
2103: l_reason number;
2104: l_sysdate date;

Line 2191: from ota_activity_versions a, ota_events e

2187: select a.rco_id
2188: ,e.offering_id
2189: into v_rco_id
2190: ,v_offering_id
2191: from ota_activity_versions a, ota_events e
2192: where a.activity_version_id = e.activity_version_id
2193: and e.event_id = p_event_id;
2194:
2195: if v_rco_id is not null and v_offering_id is not null then

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

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

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

4662: where lpm.LEARNING_PATH_MEMBER_ID = lme.LEARNING_PATH_MEMBER_ID
4663: and lme.lp_member_enrollment_id = p_lp_member_enrollment_id;
4664:
4665:
4666: CURSOR csr_prf_ord(p_activity_version_id in ota_activity_versions.activity_version_id%type,
4667: p_user_id in number,
4668: p_user_type in varchar2) IS
4669: SELECT prf.user_id,
4670: lo.learning_object_id,