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_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:
78: -- ---------------------------------------------------------------------------

Line 210: ,p_lp_member_enrollment_id IN ota_lp_member_enrollments.lp_member_enrollment_id%TYPE

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: -- ---------------------------------------------------------------------------
214: -- |----------------------< Update_lpe_lme_change >--------------------------|

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

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

Line 273: (p_lp_member_enrollment_id ota_lp_member_enrollments.lp_member_enrollment_id%type,

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