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_PATH_MEMBERS

Line 38: p_activity_version_id IN ota_learning_path_members.activity_version_id%TYPE,

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;
42:

Line 73: p_activity_version_id IN ota_learning_path_members.activity_version_id%TYPE,

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,
77: p_successful_attendance_flag OUT nocopy ota_delegate_bookings.successful_attendance_flag%TYPE);

Line 109: p_learning_path_member_id IN ota_learning_path_members.learning_path_member_id%TYPE)

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:
113: -- ---------------------------------------------------------------------------

Line 417: (p_learning_path_member_id IN ota_learning_path_members.learning_path_member_id%TYPE,

413: -- |-------------------< chk_no_of_mandatory_courses >-------------------------|
414: -- ----------------------------------------------------------------------------
415: --
416: PROCEDURE chk_no_of_mandatory_courses
417: (p_learning_path_member_id IN ota_learning_path_members.learning_path_member_id%TYPE,
418: p_return_status OUT NOCOPY VARCHAR2);
419:
420: FUNCTION get_class_completion_date(p_event_id IN ota_events.event_id%type,
421: p_person_id IN NUMBER,