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_ENROLLMENTS

Line 142: p_lp_enrollment_id IN ota_lp_enrollments.lp_enrollment_id%TYPE,

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

Line 275: p_no_of_completed_courses ota_lp_enrollments.no_of_completed_courses%TYPE,

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

Line 306: p_person_id IN ota_lp_enrollments.person_id%TYPE,

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

Line 307: p_contact_id IN ota_lp_enrollments.contact_id%TYPE,

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

Line 425: FUNCTION get_lp_completion_date(p_lp_enrollment_id ota_lp_enrollments.lp_enrollment_id%TYPE)

421: p_person_id IN NUMBER,
422: p_contact_id IN ota_attempts.user_type%type)
423: RETURN DATE;
424:
425: FUNCTION get_lp_completion_date(p_lp_enrollment_id ota_lp_enrollments.lp_enrollment_id%TYPE)
426: RETURN DATE;
427:
428: FUNCTION get_lpm_completion_date(p_lp_member_enrollment_id ota_lp_member_enrollments.lp_member_enrollment_id%TYPE,
429: p_activity_version_id ota_activity_versions.activity_version_id%TYPE,

Line 430: p_person_id ota_lp_enrollments.person_id%TYPE,

426: RETURN DATE;
427:
428: FUNCTION get_lpm_completion_date(p_lp_member_enrollment_id ota_lp_member_enrollments.lp_member_enrollment_id%TYPE,
429: p_activity_version_id ota_activity_versions.activity_version_id%TYPE,
430: p_person_id ota_lp_enrollments.person_id%TYPE,
431: p_contact_id ota_lp_enrollments.contact_id%TYPE)
432: RETURN DATE;
433:
434: END ota_lrng_path_member_util;

Line 431: p_contact_id ota_lp_enrollments.contact_id%TYPE)

427:
428: FUNCTION get_lpm_completion_date(p_lp_member_enrollment_id ota_lp_member_enrollments.lp_member_enrollment_id%TYPE,
429: p_activity_version_id ota_activity_versions.activity_version_id%TYPE,
430: p_person_id ota_lp_enrollments.person_id%TYPE,
431: p_contact_id ota_lp_enrollments.contact_id%TYPE)
432: RETURN DATE;
433:
434: END ota_lrng_path_member_util;
435: