APPS.OTA_LRNG_PATH_MEMBER_UTIL dependencies on OTA_ACTIVITY_VERSIONS

Line 187: ota_activity_versions a,

183: IS
184: CURSOR chk_enr IS
185: SELECT NULL
186: FROM ota_events e,
187: ota_activity_versions a,
188: ota_delegate_bookings b,
189: ota_booking_status_types s,
190: ota_learning_path_members lpm
191: WHERE e.event_id = b.event_id

Line 226: PROCEDURE calculate_lme_status(p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,

222:
223: -- ---------------------------------------------------------------------------
224: -- |----------------------< calculate_lme_status >-----------------------------|
225: -- ---------------------------------------------------------------------------
226: PROCEDURE calculate_lme_status(p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,
227: p_lp_enrollment_id IN ota_lp_enrollments.lp_enrollment_id%TYPE,
228: p_member_status_code OUT nocopy VARCHAR2,
229: p_completion_date OUT nocopy DATE)
230: IS

Line 285: FUNCTION get_lme_status(p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,

281:
282: -- ---------------------------------------------------------------------------
283: -- |----------------------< get_lme_status >-----------------------------|
284: -- ---------------------------------------------------------------------------
285: FUNCTION get_lme_status(p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,
286: p_person_id IN ota_learning_paths.person_id%TYPE,
287: p_contact_id IN ota_learning_paths.contact_id%TYPE)
288: RETURN VARCHAR2
289: IS

Line 457: l_activity_version_id ota_activity_versions.activity_version_id%TYPE;

453: OR (p_contact_id IS NOT NULL AND olpe.contact_id = p_contact_id))
454: AND olpm.activity_version_id = csr_activity_version_id
455: AND olme.member_status_code <> 'CANCELLED';
456:
457: l_activity_version_id ota_activity_versions.activity_version_id%TYPE;
458: l_lp_section_id ota_lp_sections.learning_path_section_id%TYPE;
459: l_completion_type_code ota_lp_sections.completion_type_code%TYPE;
460: l_enroll_type ota_booking_status_types.type%TYPE;
461: l_member_status_code ota_lp_member_enrollments.member_status_code%TYPE;

Line 1533: p_activity_version_id ota_activity_versions.activity_version_id%TYPE,

1529:
1530: END get_lp_completion_date;
1531:
1532: FUNCTION get_lpm_completion_date(p_lp_member_enrollment_id ota_lp_member_enrollments.lp_member_enrollment_id%TYPE,
1533: p_activity_version_id ota_activity_versions.activity_version_id%TYPE,
1534: p_person_id ota_lp_enrollments.person_id%TYPE,
1535: p_contact_id ota_lp_enrollments.contact_id%TYPE)
1536: RETURN DATE IS
1537: