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 16: p_activity_version_id IN ota_learning_path_members.activity_version_id%TYPE,

12: -- |----------------------< get_enrollment_status >--------------------------|
13: -- ---------------------------------------------------------------------------
14: FUNCTION get_enrollment_status(p_person_id IN ota_learning_paths.person_id%TYPE,
15: p_contact_id IN ota_learning_paths.contact_id%TYPE,
16: p_activity_version_id IN ota_learning_path_members.activity_version_id%TYPE,
17: p_lp_member_enrollment_id IN ota_lp_member_enrollments.lp_member_enrollment_id%TYPE DEFAULT NULL,
18: p_return_code IN VARCHAR2)
19: RETURN VARCHAR2 IS
20:

Line 24: FROM ota_learning_path_members lpm,

20:
21: CURSOR csr_lp_enr IS
22: SELECT DECODE(bst.type,'C','Z',bst.type) status,
23: bst.name
24: FROM ota_learning_path_members lpm,
25: ota_lp_member_enrollments lme,
26: ota_events evt,
27: ota_delegate_bookings tdb,
28: ota_booking_status_types_vl bst

Line 100: p_activity_version_id IN ota_learning_path_members.activity_version_id%TYPE,

96: -- ---------------------------------------------------------------------------
97: --
98: PROCEDURE get_enrollment_status(p_person_id IN ota_learning_paths.person_id%TYPE,
99: p_contact_id IN ota_learning_paths.contact_id%TYPE,
100: p_activity_version_id IN ota_learning_path_members.activity_version_id%TYPE,
101: p_lp_member_enrollment_id IN ota_lp_member_enrollments.lp_member_enrollment_id%TYPE,
102: p_booking_status_type OUT NOCOPY ota_booking_status_types.type%TYPE,
103: p_date_status_changed OUT NOCOPY ota_delegate_bookings.date_status_changed%TYPE,
104: p_successful_attendance_flag OUT NOCOPY ota_delegate_bookings.successful_attendance_flag%TYPE)

Line 112: FROM ota_learning_path_members lpm,

108: CURSOR csr_lp_enr IS
109: SELECT DECODE(bst.type,'C','Z',bst.type) status,
110: tdb.date_status_changed,
111: tdb.successful_attendance_flag
112: FROM ota_learning_path_members lpm,
113: ota_lp_member_enrollments lme,
114: ota_events evt,
115: ota_delegate_bookings tdb,
116: ota_booking_status_types bst

Line 181: p_learning_path_member_id IN ota_learning_path_members.learning_path_member_id%TYPE)

177: -- |----------------------< chk_enrollment_exist >--------------------------|
178: -- ---------------------------------------------------------------------------
179: FUNCTION chk_enrollment_exist(p_person_id IN ota_learning_paths.person_id%TYPE,
180: p_contact_id IN ota_learning_paths.contact_id%TYPE,
181: p_learning_path_member_id IN ota_learning_path_members.learning_path_member_id%TYPE)
182: RETURN boolean
183: IS
184: CURSOR chk_enr IS
185: SELECT NULL

Line 190: ota_learning_path_members lpm

186: FROM ota_events e,
187: ota_activity_versions a,
188: ota_delegate_bookings b,
189: ota_booking_status_types s,
190: ota_learning_path_members lpm
191: WHERE e.event_id = b.event_id
192: AND lpm.activity_version_id = a.activity_version_id
193: AND e.activity_version_id = a.activity_version_id
194: AND b.booking_status_type_id = s.booking_status_type_id

Line 365: FUNCTION chk_section_completion_type(p_learning_path_member_id IN ota_learning_path_members.learning_path_member_id%TYPE)

361:
362: -- ----------------------------------------------------------------------------
363: -- |----------------------< chk_section_completion_type >---------------------|
364: -- ---------------------------------------------------------------------------
365: FUNCTION chk_section_completion_type(p_learning_path_member_id IN ota_learning_path_members.learning_path_member_id%TYPE)
366: RETURN VARCHAR2 IS
367:
368: CURSOR csr_lpc_dtl IS
369: SELECT completion_type_code

Line 371: ota_learning_path_members lpm

367:
368: CURSOR csr_lpc_dtl IS
369: SELECT completion_type_code
370: FROM ota_lp_sections lpc,
371: ota_learning_path_members lpm
372: WHERE lpc.learning_path_section_id = lpm.learning_path_section_id
373: AND lpm.learning_path_member_id = p_learning_path_member_id;
374:
375: l_proc VARCHAR2(72) := g_package|| 'chk_section_completion_type';

Line 446: FROM ota_learning_path_members olpm,

442: olpe.no_of_completed_courses,
443: olpe.no_of_mandatory_courses,
444: olme.member_status_code,
445: olme.event_id
446: FROM ota_learning_path_members olpm,
447: ota_lp_member_enrollments olme,
448: ota_lp_enrollments olpe
449: WHERE olpe.learning_path_id = olpm.learning_path_id
450: AND olpm.learning_path_member_id = olme.learning_path_member_id

Line 749: l_learning_path_member_id ota_learning_path_members.learning_path_member_id%TYPE;

745: -- Other variables
746: l_learning_path_id ota_learning_paths.learning_path_id%TYPE := p_learning_path_id;
747: l_lp_enrollment_id ota_lp_enrollments.lp_enrollment_id%TYPE;
748: l_learning_path_section_id ota_lp_sections.learning_path_section_id%TYPE;
749: l_learning_path_member_id ota_learning_path_members.learning_path_member_id%TYPE;
750: l_lp_member_enrollment_id ota_lp_member_enrollments.lp_member_enrollment_id%TYPE;
751:
752: l_lp_ovn number;
753: l_lpe_ovn number;

Line 798: FROM ota_learning_path_members

794: AND completion_type_code = 'M';
795:
796: CURSOR csr_get_lpm IS
797: SELECT learning_path_member_id
798: FROM ota_learning_path_members
799: WHERE learning_path_section_id = l_learning_path_section_id
800: AND activity_version_id = p_activity_version_id;
801:
802: BEGIN

Line 1080: ota_learning_path_members lpm

1076: lme.object_version_number,
1077: lme.learning_path_member_id,
1078: lme.lp_enrollment_id
1079: FROM ota_lp_member_enrollments lme,
1080: ota_learning_path_members lpm
1081: WHERE lme.learning_path_member_id = lpm.learning_path_member_id
1082: AND lpm.learning_path_id = l_learning_path_id
1083: AND lme.member_status_code = 'AWAITING_APPROVAL';
1084:

Line 1089: ota_learning_path_members lpm

1085: CURSOR csr_get_cncl_lme IS
1086: SELECT lme.lp_member_enrollment_id,
1087: lme.object_version_number
1088: FROM ota_lp_member_enrollments lme,
1089: ota_learning_path_members lpm
1090: WHERE lme.learning_path_member_id = lpm.learning_path_member_id
1091: AND lpm.learning_path_id = l_learning_path_id
1092: AND lme.member_status_code <> 'CANCELLED';
1093:

Line 1299: (p_learning_path_member_id IN ota_learning_path_members.learning_path_member_id%TYPE

1295: -- |-------------------< chk_no_of_mandatory_courses >-------------------------|
1296: -- ----------------------------------------------------------------------------
1297: --
1298: PROCEDURE chk_no_of_mandatory_courses
1299: (p_learning_path_member_id IN ota_learning_path_members.learning_path_member_id%TYPE
1300: , p_return_status OUT NOCOPY VARCHAR2)
1301: IS
1302: --
1303: l_proc VARCHAR2(72) := g_package|| 'chk_no_of_mandatory_courses';

Line 1312: FROM ota_learning_path_members lpm,

1308: --
1309: CURSOR get_section_info IS
1310: SELECT lpm.learning_path_section_id,
1311: lpc.no_of_mandatory_courses
1312: FROM ota_learning_path_members lpm,
1313: ota_lp_sections lpc
1314: WHERE lpm.learning_path_section_id = lpc.learning_path_section_id
1315: AND lpc.completion_type_code = 'S'
1316: AND lpm.learning_path_member_id = p_learning_path_member_id;

Line 1320: FROM ota_learning_path_members

1316: AND lpm.learning_path_member_id = p_learning_path_member_id;
1317:
1318: CURSOR get_lpm_count IS
1319: SELECT count(learning_path_member_id)
1320: FROM ota_learning_path_members
1321: WHERE learning_path_section_id = l_lpc_id;
1322:
1323: BEGIN
1324: --

Line 1513: ota_learning_path_members lpm,

1509:
1510: CURSOR get_completion_date IS
1511: SELECT max(ota_lrng_path_member_util.get_class_completion_date(oev.event_id,lpe.person_id, lpe.contact_id)) completion_date
1512: FROM ota_lp_enrollments lpe,
1513: ota_learning_path_members lpm,
1514: ota_events oev
1515: WHERE lpe.learning_path_id = lpm.learning_path_id
1516: AND oev.activity_version_id = lpm.activity_version_id
1517: AND lpe.lp_enrollment_id = p_lp_enrollment_id;

Line 1541: ota_learning_path_members lpm,

1537:
1538: CURSOR get_lpm_completion_date IS
1539: SELECT max(ota_lrng_path_member_util.get_class_completion_date(oev.event_id,lpe.person_id, lpe.contact_id)) completion_date
1540: FROM ota_lp_enrollments lpe,
1541: ota_learning_path_members lpm,
1542: ota_lp_member_enrollments lpme,
1543: ota_events oev
1544: WHERE lpe.learning_path_id = lpm.learning_path_id
1545: AND oev.activity_version_id = lpm.activity_version_id