APPS.OTA_LRNG_PATH_MEMBER_UTIL dependencies on OTA_LP_MEMBER_ENROLLMENTS

Line 39: p_lp_member_enrollment_id IN ota_lp_member_enrollments.lp_member_enrollment_id%TYPE DEFAULT NULL,

35: -- ---------------------------------------------------------------------------
36: FUNCTION get_enrollment_status(p_person_id IN ota_learning_paths.person_id%TYPE,
37: p_contact_id IN ota_learning_paths.contact_id%TYPE,
38: p_activity_version_id IN ota_learning_path_members.activity_version_id%TYPE,
39: p_lp_member_enrollment_id IN ota_lp_member_enrollments.lp_member_enrollment_id%TYPE DEFAULT NULL,
40: p_return_code IN VARCHAR2)
41: RETURN VARCHAR2;
42:
43: -- ---------------------------------------------------------------------------

Line 74: p_lp_member_enrollment_id IN ota_lp_member_enrollments.lp_member_enrollment_id%TYPE,

70: -- ----------------------------------------------------------------------------
71: PROCEDURE get_enrollment_status(p_person_id IN ota_learning_paths.person_id%TYPE,
72: p_contact_id IN ota_learning_paths.contact_id%TYPE,
73: p_activity_version_id IN ota_learning_path_members.activity_version_id%TYPE,
74: p_lp_member_enrollment_id IN ota_lp_member_enrollments.lp_member_enrollment_id%TYPE,
75: p_booking_status_type OUT nocopy ota_booking_status_types.type%TYPE,
76: p_date_status_changed OUT nocopy ota_delegate_bookings.date_status_changed%TYPE,
77: p_successful_attendance_flag OUT nocopy ota_delegate_bookings.successful_attendance_flag%TYPE);
78:

Line 211: ,p_lp_member_enrollment_id IN ota_lp_member_enrollments.lp_member_enrollment_id%TYPE

207: -- {End Of Comments}
208: -- ---------------------------------------------------------------------------
209: PROCEDURE get_valid_enroll(p_person_id IN ota_learning_paths.person_id%TYPE
210: ,p_contact_id IN ota_learning_paths.contact_id%TYPE
211: ,p_lp_member_enrollment_id IN ota_lp_member_enrollments.lp_member_enrollment_id%TYPE
212: ,p_return_status OUT nocopy varchar2);
213:
214: -- ---------------------------------------------------------------------------
215: -- |----------------------< Update_lpe_lme_change >--------------------------|

Line 243: (p_lp_member_enrollment_id ota_lp_member_enrollments.lp_member_enrollment_id%type);

239: --
240: -- {End Of Comments}
241: -- ---------------------------------------------------------------------------
242: Procedure Update_lpe_lme_change
243: (p_lp_member_enrollment_id ota_lp_member_enrollments.lp_member_enrollment_id%type);
244:
245: -- ---------------------------------------------------------------------------
246: -- |----------------------< Update_lpe_lme_change >--------------------------|
247: -- ---------------------------------------------------------------------------

Line 274: (p_lp_member_enrollment_id ota_lp_member_enrollments.lp_member_enrollment_id%type,

270: --
271: -- {End Of Comments}
272: -- ---------------------------------------------------------------------------
273: Procedure Update_lpe_lme_change
274: (p_lp_member_enrollment_id ota_lp_member_enrollments.lp_member_enrollment_id%type,
275: p_no_of_completed_courses ota_lp_enrollments.no_of_completed_courses%TYPE,
276: p_lp_enrollment_ids OUT NOCOPY varchar2);
277:
278: -- ---------------------------------------------------------------------------

Line 428: FUNCTION get_lpm_completion_date(p_lp_member_enrollment_id ota_lp_member_enrollments.lp_member_enrollment_id%TYPE,

424:
425: FUNCTION get_lp_completion_date(p_lp_enrollment_id ota_lp_enrollments.lp_enrollment_id%TYPE)
426: RETURN DATE;
427:
428: FUNCTION get_lpm_completion_date(p_lp_member_enrollment_id ota_lp_member_enrollments.lp_member_enrollment_id%TYPE,
429: p_activity_version_id ota_activity_versions.activity_version_id%TYPE,
430: p_person_id ota_lp_enrollments.person_id%TYPE,
431: p_contact_id ota_lp_enrollments.contact_id%TYPE)
432: RETURN DATE;