32: -- Internal Development Use Only.
33: --
34: -- {End Of Comments}
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)
33: --
34: -- {End Of Comments}
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;
67: -- Internal Development Use Only.
68: --
69: -- {End Of Comments}
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,
68: --
69: -- {End Of Comments}
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,
103: -- Internal Development Use Only.
104: --
105: -- {End Of Comments}
106: -- ---------------------------------------------------------------------------
107: FUNCTION chk_enrollment_exist(p_person_id IN ota_learning_paths.person_id%TYPE,
108: p_contact_id IN ota_learning_paths.contact_id%TYPE,
109: p_learning_path_member_id IN ota_learning_path_members.learning_path_member_id%TYPE)
110: RETURN boolean;
111:
104: --
105: -- {End Of Comments}
106: -- ---------------------------------------------------------------------------
107: FUNCTION chk_enrollment_exist(p_person_id IN ota_learning_paths.person_id%TYPE,
108: p_contact_id IN ota_learning_paths.contact_id%TYPE,
109: p_learning_path_member_id IN ota_learning_path_members.learning_path_member_id%TYPE)
110: RETURN boolean;
111:
112:
173: --
174: -- {End Of Comments}
175: -- ---------------------------------------------------------------------------
176: FUNCTION get_lme_status(p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,
177: p_person_id IN ota_learning_paths.person_id%TYPE,
178: p_contact_id IN ota_learning_paths.contact_id%TYPE)
179: RETURN VARCHAR2;
180:
181: -- ----------------------------------------------------------------------------
174: -- {End Of Comments}
175: -- ---------------------------------------------------------------------------
176: FUNCTION get_lme_status(p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,
177: p_person_id IN ota_learning_paths.person_id%TYPE,
178: p_contact_id IN ota_learning_paths.contact_id%TYPE)
179: RETURN VARCHAR2;
180:
181: -- ----------------------------------------------------------------------------
182: -- ---------------------------< get_valid_enroll >-----------------------------
205: -- Internal Development Use Only.
206: --
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:
206: --
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: -- ---------------------------------------------------------------------------