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 337: FUNCTION get_lpc_completed_courses(p_learning_path_section_id IN ota_lp_sections.learning_path_section_id%TYPE)

333:
334: -- ----------------------------------------------------------------------------
335: -- |----------------------< get_lpc_completed_courses >---------------------|
336: -- ---------------------------------------------------------------------------
337: FUNCTION get_lpc_completed_courses(p_learning_path_section_id IN ota_lp_sections.learning_path_section_id%TYPE)
338: RETURN NUMBER IS
339:
340: CURSOR csr_lpc_comp IS
341: SELECT count(lp_member_enrollment_id)

Line 370: FROM ota_lp_sections lpc,

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

Line 377: l_completion_type ota_lp_sections.completion_type_code%TYPE;

373: AND lpm.learning_path_member_id = p_learning_path_member_id;
374:
375: l_proc VARCHAR2(72) := g_package|| 'chk_section_completion_type';
376:
377: l_completion_type ota_lp_sections.completion_type_code%TYPE;
378:
379: BEGIN
380:
381: hr_utility.set_location(' Step:'|| l_proc, 10);

Line 458: l_lp_section_id ota_lp_sections.learning_path_section_id%TYPE;

454: AND olpm.activity_version_id = csr_activity_version_id
455: AND olme.member_status_code <> 'CANCELLED';
456:
457: l_activity_version_id ota_activity_versions.activity_version_id%TYPE;
458: l_lp_section_id ota_lp_sections.learning_path_section_id%TYPE;
459: l_completion_type_code ota_lp_sections.completion_type_code%TYPE;
460: l_enroll_type ota_booking_status_types.type%TYPE;
461: l_member_status_code ota_lp_member_enrollments.member_status_code%TYPE;
462: l_completion_date ota_lp_enrollments.completion_date%TYPE;

Line 459: l_completion_type_code ota_lp_sections.completion_type_code%TYPE;

455: AND olme.member_status_code <> 'CANCELLED';
456:
457: l_activity_version_id ota_activity_versions.activity_version_id%TYPE;
458: l_lp_section_id ota_lp_sections.learning_path_section_id%TYPE;
459: l_completion_type_code ota_lp_sections.completion_type_code%TYPE;
460: l_enroll_type ota_booking_status_types.type%TYPE;
461: l_member_status_code ota_lp_member_enrollments.member_status_code%TYPE;
462: l_completion_date ota_lp_enrollments.completion_date%TYPE;
463: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;

Line 748: l_learning_path_section_id ota_lp_sections.learning_path_section_id%TYPE;

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

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

764: l_exists boolean;
765:
766: l_proc varchar2(72) := g_package ||'create_talent_mgmt_lpm';
767: l_path_source_code ota_learning_paths.path_source_code%TYPE;
768: l_path_name ota_lp_sections_tl.name%TYPE := p_path_name;
769:
770: CURSOR csr_get_lp IS
771: SELECT lps.learning_path_id,
772: lpe.lp_enrollment_id,

Line 776: ota_lp_sections lpc

772: lpe.lp_enrollment_id,
773: lpc.learning_path_section_id
774: FROM ota_learning_paths lps,
775: ota_lp_enrollments lpe,
776: ota_lp_sections lpc
777: WHERE lps.learning_path_id = lpe.learning_path_id
778: AND lpc.learning_path_id = lps.learning_path_id
779: AND lps.path_source_code = 'TALENT_MGMT'
780: AND lps.source_function_code = p_source_function_code

Line 792: FROM ota_lp_sections

788: AND person_id = p_person_id;
789:
790: CURSOR csr_get_lpc IS
791: SELECT learning_path_section_id
792: FROM ota_lp_sections
793: WHERE learning_path_id = l_learning_path_id
794: AND completion_type_code = 'M';
795:
796: CURSOR csr_get_lpm IS

Line 1306: l_lpc_id ota_lp_sections.learning_path_section_id%TYPE;

1302: --
1303: l_proc VARCHAR2(72) := g_package|| 'chk_no_of_mandatory_courses';
1304: l_exists VARCHAR2(1);
1305: l_lpm_count NUMBER;
1306: l_lpc_id ota_lp_sections.learning_path_section_id%TYPE;
1307: l_mandatory_courses ota_lp_sections.no_of_mandatory_courses%TYPE;
1308: --
1309: CURSOR get_section_info IS
1310: SELECT lpm.learning_path_section_id,

Line 1307: l_mandatory_courses ota_lp_sections.no_of_mandatory_courses%TYPE;

1303: l_proc VARCHAR2(72) := g_package|| 'chk_no_of_mandatory_courses';
1304: l_exists VARCHAR2(1);
1305: l_lpm_count NUMBER;
1306: l_lpc_id ota_lp_sections.learning_path_section_id%TYPE;
1307: l_mandatory_courses ota_lp_sections.no_of_mandatory_courses%TYPE;
1308: --
1309: CURSOR get_section_info IS
1310: SELECT lpm.learning_path_section_id,
1311: lpc.no_of_mandatory_courses

Line 1313: ota_lp_sections lpc

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