eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_LRNG_PATH_MEMBER_UTIL dependencies on OTA_LEARNING_PATHS

Line 36: FUNCTION get_enrollment_status(p_person_id IN ota_learning_paths.person_id%TYPE,

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)

Line 37: p_contact_id IN ota_learning_paths.contact_id%TYPE,

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;

Line 71: PROCEDURE get_enrollment_status(p_person_id IN ota_learning_paths.person_id%TYPE,

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,

Line 72: p_contact_id IN ota_learning_paths.contact_id%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);

Line 106: FUNCTION chk_enrollment_exist(p_person_id IN ota_learning_paths.person_id%TYPE,

102: -- Internal Development Use Only.
103: --
104: -- {End Of Comments}
105: -- ---------------------------------------------------------------------------
106: FUNCTION chk_enrollment_exist(p_person_id IN ota_learning_paths.person_id%TYPE,
107: p_contact_id IN ota_learning_paths.contact_id%TYPE,
108: p_learning_path_member_id IN ota_learning_path_members.learning_path_member_id%TYPE)
109: RETURN boolean;
110:

Line 107: p_contact_id IN ota_learning_paths.contact_id%TYPE,

103: --
104: -- {End Of Comments}
105: -- ---------------------------------------------------------------------------
106: FUNCTION chk_enrollment_exist(p_person_id IN ota_learning_paths.person_id%TYPE,
107: p_contact_id IN ota_learning_paths.contact_id%TYPE,
108: p_learning_path_member_id IN ota_learning_path_members.learning_path_member_id%TYPE)
109: RETURN boolean;
110:
111:

Line 176: p_person_id IN ota_learning_paths.person_id%TYPE,

172: --
173: -- {End Of Comments}
174: -- ---------------------------------------------------------------------------
175: FUNCTION get_lme_status(p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,
176: p_person_id IN ota_learning_paths.person_id%TYPE,
177: p_contact_id IN ota_learning_paths.contact_id%TYPE)
178: RETURN VARCHAR2;
179:
180: -- ----------------------------------------------------------------------------

Line 177: p_contact_id IN ota_learning_paths.contact_id%TYPE)

173: -- {End Of Comments}
174: -- ---------------------------------------------------------------------------
175: FUNCTION get_lme_status(p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,
176: p_person_id IN ota_learning_paths.person_id%TYPE,
177: p_contact_id IN ota_learning_paths.contact_id%TYPE)
178: RETURN VARCHAR2;
179:
180: -- ----------------------------------------------------------------------------
181: -- ---------------------------< get_valid_enroll >-----------------------------

Line 208: PROCEDURE get_valid_enroll(p_person_id IN ota_learning_paths.person_id%TYPE

204: -- Internal Development Use Only.
205: --
206: -- {End Of Comments}
207: -- ---------------------------------------------------------------------------
208: PROCEDURE get_valid_enroll(p_person_id IN ota_learning_paths.person_id%TYPE
209: ,p_contact_id IN ota_learning_paths.contact_id%TYPE
210: ,p_lp_member_enrollment_id IN ota_lp_member_enrollments.lp_member_enrollment_id%TYPE
211: ,p_return_status OUT nocopy varchar2);
212:

Line 209: ,p_contact_id IN ota_learning_paths.contact_id%TYPE

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