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

Line 110: FROM ota_learning_path_members lpm,

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

Line 175: p_learning_path_member_id IN ota_learning_path_members.learning_path_member_id%TYPE)

171: -- |----------------------< chk_enrollment_exist >--------------------------|
172: -- ---------------------------------------------------------------------------
173: FUNCTION chk_enrollment_exist(p_person_id IN ota_learning_paths.person_id%TYPE,
174: p_contact_id IN ota_learning_paths.contact_id%TYPE,
175: p_learning_path_member_id IN ota_learning_path_members.learning_path_member_id%TYPE)
176: RETURN boolean
177: IS
178: CURSOR chk_enr IS
179: SELECT NULL

Line 184: ota_learning_path_members lpm

180: FROM ota_events e,
181: ota_activity_versions a,
182: ota_delegate_bookings b,
183: ota_booking_status_types s,
184: ota_learning_path_members lpm
185: WHERE e.event_id = b.event_id
186: AND lpm.activity_version_id = a.activity_version_id
187: AND e.activity_version_id = a.activity_version_id
188: AND b.booking_status_type_id = s.booking_status_type_id

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

350:
351: -- ----------------------------------------------------------------------------
352: -- |----------------------< chk_section_completion_type >---------------------|
353: -- ---------------------------------------------------------------------------
354: FUNCTION chk_section_completion_type(p_learning_path_member_id IN ota_learning_path_members.learning_path_member_id%TYPE)
355: RETURN VARCHAR2 IS
356:
357: CURSOR csr_lpc_dtl IS
358: SELECT completion_type_code

Line 360: ota_learning_path_members lpm

356:
357: CURSOR csr_lpc_dtl IS
358: SELECT completion_type_code
359: FROM ota_lp_sections lpc,
360: ota_learning_path_members lpm
361: WHERE lpc.learning_path_section_id = lpm.learning_path_section_id
362: AND lpm.learning_path_member_id = p_learning_path_member_id;
363:
364: l_proc VARCHAR2(72) := g_package|| 'chk_section_completion_type';

Line 434: FROM ota_learning_path_members olpm,

430: olpm.learning_path_member_id,
431: olpe.no_of_completed_courses,
432: olpe.no_of_mandatory_courses,
433: olme.member_status_code
434: FROM ota_learning_path_members olpm,
435: ota_lp_member_enrollments olme,
436: ota_lp_enrollments olpe
437: WHERE olpe.learning_path_id = olpm.learning_path_id
438: AND olpm.learning_path_member_id = olme.learning_path_member_id

Line 727: l_learning_path_member_id ota_learning_path_members.learning_path_member_id%TYPE;

723: -- Other variables
724: l_learning_path_id ota_learning_paths.learning_path_id%TYPE := p_learning_path_id;
725: l_lp_enrollment_id ota_lp_enrollments.lp_enrollment_id%TYPE;
726: l_learning_path_section_id ota_lp_sections.learning_path_section_id%TYPE;
727: l_learning_path_member_id ota_learning_path_members.learning_path_member_id%TYPE;
728: l_lp_member_enrollment_id ota_lp_member_enrollments.lp_member_enrollment_id%TYPE;
729:
730: l_lp_ovn number;
731: l_lpe_ovn number;

Line 776: FROM ota_learning_path_members

772: AND completion_type_code = 'M';
773:
774: CURSOR csr_get_lpm IS
775: SELECT learning_path_member_id
776: FROM ota_learning_path_members
777: WHERE learning_path_section_id = l_learning_path_section_id
778: AND activity_version_id = p_activity_version_id;
779:
780: BEGIN

Line 1058: ota_learning_path_members lpm

1054: lme.object_version_number,
1055: lme.learning_path_member_id,
1056: lme.lp_enrollment_id
1057: FROM ota_lp_member_enrollments lme,
1058: ota_learning_path_members lpm
1059: WHERE lme.learning_path_member_id = lpm.learning_path_member_id
1060: AND lpm.learning_path_id = l_learning_path_id
1061: AND lme.member_status_code = 'AWAITING_APPROVAL';
1062:

Line 1067: ota_learning_path_members lpm

1063: CURSOR csr_get_cncl_lme IS
1064: SELECT lme.lp_member_enrollment_id,
1065: lme.object_version_number
1066: FROM ota_lp_member_enrollments lme,
1067: ota_learning_path_members lpm
1068: WHERE lme.learning_path_member_id = lpm.learning_path_member_id
1069: AND lpm.learning_path_id = l_learning_path_id
1070: AND lme.member_status_code <> 'CANCELLED';
1071:

Line 1277: (p_learning_path_member_id IN ota_learning_path_members.learning_path_member_id%TYPE

1273: -- |-------------------< chk_no_of_mandatory_courses >-------------------------|
1274: -- ----------------------------------------------------------------------------
1275: --
1276: PROCEDURE chk_no_of_mandatory_courses
1277: (p_learning_path_member_id IN ota_learning_path_members.learning_path_member_id%TYPE
1278: , p_return_status OUT NOCOPY VARCHAR2)
1279: IS
1280: --
1281: l_proc VARCHAR2(72) := g_package|| 'chk_no_of_mandatory_courses';

Line 1290: FROM ota_learning_path_members lpm,

1286: --
1287: CURSOR get_section_info IS
1288: SELECT lpm.learning_path_section_id,
1289: lpc.no_of_mandatory_courses
1290: FROM ota_learning_path_members lpm,
1291: ota_lp_sections lpc
1292: WHERE lpm.learning_path_section_id = lpc.learning_path_section_id
1293: AND lpc.completion_type_code = 'S'
1294: AND lpm.learning_path_member_id = p_learning_path_member_id;

Line 1298: FROM ota_learning_path_members

1294: AND lpm.learning_path_member_id = p_learning_path_member_id;
1295:
1296: CURSOR get_lpm_count IS
1297: SELECT count(learning_path_member_id)
1298: FROM ota_learning_path_members
1299: WHERE learning_path_section_id = l_lpc_id;
1300:
1301: BEGIN
1302: --