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:

Line 108: p_learning_path_member_id IN ota_learning_path_members.learning_path_member_id%TYPE)

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

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

412: -- |-------------------< chk_no_of_mandatory_courses >-------------------------|
413: -- ----------------------------------------------------------------------------
414: --
415: PROCEDURE chk_no_of_mandatory_courses
416: (p_learning_path_member_id IN ota_learning_path_members.learning_path_member_id%TYPE,
417: p_return_status OUT NOCOPY VARCHAR2);
418:
419: END ota_lrng_path_member_util;
420: