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_SECTIONS

Line 326: FUNCTION get_lpc_completed_courses(p_learning_path_section_id IN ota_lp_sections.learning_path_section_id%TYPE)

322:
323: -- ----------------------------------------------------------------------------
324: -- |----------------------< get_lpc_completed_courses >---------------------|
325: -- ---------------------------------------------------------------------------
326: FUNCTION get_lpc_completed_courses(p_learning_path_section_id IN ota_lp_sections.learning_path_section_id%TYPE)
327: RETURN NUMBER IS
328:
329: CURSOR csr_lpc_comp IS
330: SELECT count(lp_member_enrollment_id)

Line 359: FROM ota_lp_sections lpc,

355: RETURN VARCHAR2 IS
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:

Line 366: l_completion_type ota_lp_sections.completion_type_code%TYPE;

362: AND lpm.learning_path_member_id = p_learning_path_member_id;
363:
364: l_proc VARCHAR2(72) := g_package|| 'chk_section_completion_type';
365:
366: l_completion_type ota_lp_sections.completion_type_code%TYPE;
367:
368: BEGIN
369:
370: hr_utility.set_location(' Step:'|| l_proc, 10);

Line 446: l_lp_section_id ota_lp_sections.learning_path_section_id%TYPE;

442: AND olpm.activity_version_id = csr_activity_version_id
443: AND olme.member_status_code <> 'CANCELLED';
444:
445: l_activity_version_id ota_activity_versions.activity_version_id%TYPE;
446: l_lp_section_id ota_lp_sections.learning_path_section_id%TYPE;
447: l_completion_type_code ota_lp_sections.completion_type_code%TYPE;
448: l_enroll_type ota_booking_status_types.type%TYPE;
449: l_member_status_code ota_lp_member_enrollments.member_status_code%TYPE;
450: l_completion_date ota_lp_enrollments.completion_date%TYPE;

Line 447: l_completion_type_code ota_lp_sections.completion_type_code%TYPE;

443: AND olme.member_status_code <> 'CANCELLED';
444:
445: l_activity_version_id ota_activity_versions.activity_version_id%TYPE;
446: l_lp_section_id ota_lp_sections.learning_path_section_id%TYPE;
447: l_completion_type_code ota_lp_sections.completion_type_code%TYPE;
448: l_enroll_type ota_booking_status_types.type%TYPE;
449: l_member_status_code ota_lp_member_enrollments.member_status_code%TYPE;
450: l_completion_date ota_lp_enrollments.completion_date%TYPE;
451: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;

Line 726: l_learning_path_section_id ota_lp_sections.learning_path_section_id%TYPE;

722: --
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;

Line 746: l_path_name ota_lp_sections_tl.name%TYPE := p_path_name;

742: l_exists boolean;
743:
744: l_proc varchar2(72) := g_package ||'create_talent_mgmt_lpm';
745: l_path_source_code ota_learning_paths.path_source_code%TYPE;
746: l_path_name ota_lp_sections_tl.name%TYPE := p_path_name;
747:
748: CURSOR csr_get_lp IS
749: SELECT lps.learning_path_id,
750: lpe.lp_enrollment_id,

Line 754: ota_lp_sections lpc

750: lpe.lp_enrollment_id,
751: lpc.learning_path_section_id
752: FROM ota_learning_paths lps,
753: ota_lp_enrollments lpe,
754: ota_lp_sections lpc
755: WHERE lps.learning_path_id = lpe.learning_path_id
756: AND lpc.learning_path_id = lps.learning_path_id
757: AND lps.path_source_code = 'TALENT_MGMT'
758: AND lps.source_function_code = p_source_function_code

Line 770: FROM ota_lp_sections

766: AND person_id = p_person_id;
767:
768: CURSOR csr_get_lpc IS
769: SELECT learning_path_section_id
770: FROM ota_lp_sections
771: WHERE learning_path_id = l_learning_path_id
772: AND completion_type_code = 'M';
773:
774: CURSOR csr_get_lpm IS

Line 1284: l_lpc_id ota_lp_sections.learning_path_section_id%TYPE;

1280: --
1281: l_proc VARCHAR2(72) := g_package|| 'chk_no_of_mandatory_courses';
1282: l_exists VARCHAR2(1);
1283: l_lpm_count NUMBER;
1284: l_lpc_id ota_lp_sections.learning_path_section_id%TYPE;
1285: l_mandatory_courses ota_lp_sections.no_of_mandatory_courses%TYPE;
1286: --
1287: CURSOR get_section_info IS
1288: SELECT lpm.learning_path_section_id,

Line 1285: l_mandatory_courses ota_lp_sections.no_of_mandatory_courses%TYPE;

1281: l_proc VARCHAR2(72) := g_package|| 'chk_no_of_mandatory_courses';
1282: l_exists VARCHAR2(1);
1283: l_lpm_count NUMBER;
1284: l_lpc_id ota_lp_sections.learning_path_section_id%TYPE;
1285: l_mandatory_courses ota_lp_sections.no_of_mandatory_courses%TYPE;
1286: --
1287: CURSOR get_section_info IS
1288: SELECT lpm.learning_path_section_id,
1289: lpc.no_of_mandatory_courses

Line 1291: ota_lp_sections lpc

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;
1295: