APPS.OTA_LRNG_PATH_MEMBER_UTIL dependencies on OTA_LP_ENROLLMENTS

Line 141: p_lp_enrollment_id IN ota_lp_enrollments.lp_enrollment_id%TYPE,

137: --
138: -- {End Of Comments}
139: -- ---------------------------------------------------------------------------
140: PROCEDURE calculate_lme_status(p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,
141: p_lp_enrollment_id IN ota_lp_enrollments.lp_enrollment_id%TYPE,
142: p_member_status_code OUT nocopy VARCHAR2,
143: p_completion_date OUT nocopy DATE);
144:
145:

Line 274: p_no_of_completed_courses ota_lp_enrollments.no_of_completed_courses%TYPE,

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: -- ---------------------------------------------------------------------------
278: -- |----------------------< update_lme_enroll_status_chg >--------------------------|

Line 305: p_person_id IN ota_lp_enrollments.person_id%TYPE,

301: --
302: -- {End Of Comments}
303: -- ---------------------------------------------------------------------------
304: PROCEDURE update_lme_enroll_status_chg (p_event_id IN ota_events.event_id%TYPE,
305: p_person_id IN ota_lp_enrollments.person_id%TYPE,
306: p_contact_id IN ota_lp_enrollments.contact_id%TYPE,
307: p_lp_enrollment_ids OUT NOCOPY varchar2);
308:
309: -- ----------------------------------------------------------------------------

Line 306: p_contact_id IN ota_lp_enrollments.contact_id%TYPE,

302: -- {End Of Comments}
303: -- ---------------------------------------------------------------------------
304: PROCEDURE update_lme_enroll_status_chg (p_event_id IN ota_events.event_id%TYPE,
305: p_person_id IN ota_lp_enrollments.person_id%TYPE,
306: p_contact_id IN ota_lp_enrollments.contact_id%TYPE,
307: p_lp_enrollment_ids OUT NOCOPY varchar2);
308:
309: -- ----------------------------------------------------------------------------
310: -- |---------------------------------------------------|