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_UTIL dependencies on OTA_LEARNING_PATHS

Line 36: FROM ota_learning_paths lps,

32: */
33: -- Added for Bug#4052408
34: CURSOR csr_get_path_details IS
35: SELECT lps.path_source_code, lps.source_function_code, lpe.path_status_code
36: FROM ota_learning_paths lps,
37: ota_lp_enrollments lpe
38: WHERE lpe.lp_enrollment_id = p_lp_enrollment_id
39: AND lpe.learning_path_id = lps.learning_path_id;
40: -- End of code added for bug#4052408

Line 58: l_path_source_code ota_learning_paths.path_source_code%TYPE;

54: l_proc VARCHAR2(72) := g_package ||'chk_complete_path_ok';
55: l_exists Number(9);
56: l_complete Number(9);
57: l_result varchar2(3) :='F';
58: l_path_source_code ota_learning_paths.path_source_code%TYPE;
59: l_source_function_code ota_learning_paths.source_function_code%TYPE;
60: l_path_status ota_lp_enrollments.path_status_code%TYPE;
61: l_completed_course_count number := 0;
62:

Line 59: l_source_function_code ota_learning_paths.source_function_code%TYPE;

55: l_exists Number(9);
56: l_complete Number(9);
57: l_result varchar2(3) :='F';
58: l_path_source_code ota_learning_paths.path_source_code%TYPE;
59: l_source_function_code ota_learning_paths.source_function_code%TYPE;
60: l_path_status ota_lp_enrollments.path_status_code%TYPE;
61: l_completed_course_count number := 0;
62:
63: Begin

Line 142: l_person_id ota_learning_paths.person_id%TYPE;

138: FUNCTION chk_login_person(p_lp_enrollment_id IN ota_lp_enrollments.lp_enrollment_id%TYPE)
139: RETURN VARCHAR2
140: IS
141:
142: l_person_id ota_learning_paths.person_id%TYPE;
143: l_login_person ota_learning_paths.person_id%TYPE;
144: l_login_customer NUMBER;
145: l_contact_id ota_learning_paths.contact_id%TYPE;
146: l_proc VARCHAR2(72) := g_package|| 'chk_login_person';

Line 143: l_login_person ota_learning_paths.person_id%TYPE;

139: RETURN VARCHAR2
140: IS
141:
142: l_person_id ota_learning_paths.person_id%TYPE;
143: l_login_person ota_learning_paths.person_id%TYPE;
144: l_login_customer NUMBER;
145: l_contact_id ota_learning_paths.contact_id%TYPE;
146: l_proc VARCHAR2(72) := g_package|| 'chk_login_person';
147:

Line 145: l_contact_id ota_learning_paths.contact_id%TYPE;

141:
142: l_person_id ota_learning_paths.person_id%TYPE;
143: l_login_person ota_learning_paths.person_id%TYPE;
144: l_login_customer NUMBER;
145: l_contact_id ota_learning_paths.contact_id%TYPE;
146: l_proc VARCHAR2(72) := g_package|| 'chk_login_person';
147:
148: BEGIN
149:

Line 249: FUNCTION get_no_of_mandatory_courses(p_learning_path_id IN ota_learning_paths.learning_path_id%TYPE,

245: -- ----------------------------------------------------------------------------
246: -- |---------------------- -----------------------|
247: -- ----------------------------------------------------------------------------
248:
249: FUNCTION get_no_of_mandatory_courses(p_learning_path_id IN ota_learning_paths.learning_path_id%TYPE,
250: p_path_source_code IN ota_learning_paths.path_source_code%TYPE)
251: RETURN number IS
252:
253: CURSOR csr_s_lpm IS

Line 250: p_path_source_code IN ota_learning_paths.path_source_code%TYPE)

246: -- |---------------------- -----------------------|
247: -- ----------------------------------------------------------------------------
248:
249: FUNCTION get_no_of_mandatory_courses(p_learning_path_id IN ota_learning_paths.learning_path_id%TYPE,
250: p_path_source_code IN ota_learning_paths.path_source_code%TYPE)
251: RETURN number IS
252:
253: CURSOR csr_s_lpm IS
254: SELECT sum(no_of_mandatory_courses)

Line 330: p_path_source_code IN ota_learning_paths.path_source_code%TYPE)

326: -- {End Of Comments}
327: -- ----------------------------------------------------------------------------
328:
329: FUNCTION get_no_of_completed_courses(p_lp_enrollment_id IN ota_lp_enrollments.lp_enrollment_id%TYPE,
330: p_path_source_code IN ota_learning_paths.path_source_code%TYPE)
331: RETURN number IS
332:
333:
334: CURSOR csr_sections IS

Line 446: --p_path_source_code IN ota_learning_paths.path_source_code%TYPE,

442: -- ---------------------------------------------------------------------------
443:
444: PROCEDURE Update_lpe_lpm_changes( p_lp_enrollment_id IN ota_lp_enrollments.lp_enrollment_id%TYPE,
445: --Modified for Bug#3891087
446: --p_path_source_code IN ota_learning_paths.path_source_code%TYPE,
447: p_completion_target_date IN ota_lp_enrollments.completion_target_date%TYPE,
448: p_return_status OUT NOCOPY VARCHAR2)
449: is
450:

Line 474: FROM ota_learning_paths lps, ota_lp_enrollments lpe

470: IS
471: -- Modified for Bug#4052408
472: --SELECT lps.path_source_code
473: SELECT lps.path_source_code, lps.source_function_code, lpe.path_status_code
474: FROM ota_learning_paths lps, ota_lp_enrollments lpe
475: WHERE lps.learning_path_id = lpe.learning_path_id
476: AND lpe.lp_enrollment_id = p_lp_enrollment_id;
477:
478: l_lp_enrollment_id ota_lp_enrollments.lp_enrollment_id%TYPE;

Line 479: l_learning_path_id ota_learning_paths.learning_path_id%TYPE;

475: WHERE lps.learning_path_id = lpe.learning_path_id
476: AND lpe.lp_enrollment_id = p_lp_enrollment_id;
477:
478: l_lp_enrollment_id ota_lp_enrollments.lp_enrollment_id%TYPE;
479: l_learning_path_id ota_learning_paths.learning_path_id%TYPE;
480: l_object_version_number ota_lp_enrollments.object_version_number%type;
481: l_path_status_code ota_lp_enrollments.path_status_code%type;
482: l_no_of_completed_courses ota_lp_enrollments.no_of_completed_courses%type;
483: l_no_of_mandatory_courses ota_lp_enrollments.no_of_mandatory_courses%type;

Line 488: l_path_source_code ota_learning_paths.path_source_code%TYPE;

484: l_completion_target_date ota_lp_enrollments.completion_target_date%TYPE;
485: l_result varchar2(3) :='F';
486: l_complete Number(9);
487: l_return_status varchar2(3) :='';
488: l_path_source_code ota_learning_paths.path_source_code%TYPE;
489: l_source_function_code ota_learning_paths.source_function_code%TYPE;
490:
491:
492: BEGIN

Line 489: l_source_function_code ota_learning_paths.source_function_code%TYPE;

485: l_result varchar2(3) :='F';
486: l_complete Number(9);
487: l_return_status varchar2(3) :='';
488: l_path_source_code ota_learning_paths.path_source_code%TYPE;
489: l_source_function_code ota_learning_paths.source_function_code%TYPE;
490:
491:
492: BEGIN
493: OPEN csr_get_path_source_code;

Line 613: ,p_source_function_code IN ota_learning_paths.source_function_code%TYPE

609: -- ---------------------------------------------------------------------------
610: --
611:
612: FUNCTION get_talent_mgmt_lp(p_person_id IN ota_lp_enrollments.person_id%TYPE
613: ,p_source_function_code IN ota_learning_paths.source_function_code%TYPE
614: ,p_source_id IN ota_learning_paths.source_id%TYPE
615: ,p_assignment_id IN ota_learning_paths.assignment_id%TYPE
616: ,p_business_group_id IN NUMBER)
617: RETURN number

Line 614: ,p_source_id IN ota_learning_paths.source_id%TYPE

610: --
611:
612: FUNCTION get_talent_mgmt_lp(p_person_id IN ota_lp_enrollments.person_id%TYPE
613: ,p_source_function_code IN ota_learning_paths.source_function_code%TYPE
614: ,p_source_id IN ota_learning_paths.source_id%TYPE
615: ,p_assignment_id IN ota_learning_paths.assignment_id%TYPE
616: ,p_business_group_id IN NUMBER)
617: RETURN number
618: IS

Line 615: ,p_assignment_id IN ota_learning_paths.assignment_id%TYPE

611:
612: FUNCTION get_talent_mgmt_lp(p_person_id IN ota_lp_enrollments.person_id%TYPE
613: ,p_source_function_code IN ota_learning_paths.source_function_code%TYPE
614: ,p_source_id IN ota_learning_paths.source_id%TYPE
615: ,p_assignment_id IN ota_learning_paths.assignment_id%TYPE
616: ,p_business_group_id IN NUMBER)
617: RETURN number
618: IS
619:

Line 622: FROM ota_learning_paths

618: IS
619:
620: CURSOR csr_get_lp IS
621: SELECT learning_path_id
622: FROM ota_learning_paths
623: WHERE source_function_code = p_source_function_code
624: AND business_group_id = p_business_group_id
625: AND person_id = p_person_id
626: AND (p_source_id IS NULL OR (p_source_id IS NOT NULL AND source_id = p_source_id))

Line 631: l_learning_path_id ota_learning_paths.learning_path_id%TYPE := 0;

627: AND (p_assignment_id IS NULL OR (p_assignment_id IS NOT NULL AND assignment_id = p_assignment_id));
628:
629: l_proc VARCHAR2(72) := g_package|| 'get_talent_mgmt_lp';
630:
631: l_learning_path_id ota_learning_paths.learning_path_id%TYPE := 0;
632:
633: BEGIN
634:
635: hr_utility.set_location(' Step:'|| l_proc, 10);

Line 678: p_person_id IN ota_learning_paths.person_id%TYPE,

674: -- {End Of Comments}
675: -- ----------------------------------------------------------------------------
676:
677: FUNCTION get_no_of_mand_compl_courses(p_learning_path_section_id IN ota_lp_sections.learning_path_section_id%TYPE,
678: p_person_id IN ota_learning_paths.person_id%TYPE,
679: p_contact_id IN ota_learning_paths.contact_id%TYPE)
680: RETURN number
681: IS
682: CURSOR csr_lps IS

Line 679: p_contact_id IN ota_learning_paths.contact_id%TYPE)

675: -- ----------------------------------------------------------------------------
676:
677: FUNCTION get_no_of_mand_compl_courses(p_learning_path_section_id IN ota_lp_sections.learning_path_section_id%TYPE,
678: p_person_id IN ota_learning_paths.person_id%TYPE,
679: p_contact_id IN ota_learning_paths.contact_id%TYPE)
680: RETURN number
681: IS
682: CURSOR csr_lps IS
683: SELECT learning_path_id,

Line 969: CURSOR enrolled_class(p_person_id IN ota_learning_paths.person_id%TYPE,

965: --AND lpe.path_status_code <> 'CANCELLED'
966: AND lpe.lp_enrollment_id = lpme.lp_enrollment_id
967: AND lpm.learning_path_member_id = lpme.learning_path_member_id ;
968:
969: CURSOR enrolled_class(p_person_id IN ota_learning_paths.person_id%TYPE,
970: p_contact_id IN ota_learning_paths.contact_id%TYPE,
971: p_activity_version_id IN ota_learning_path_members.activity_version_id%TYPE) IS
972: SELECT oav.activity_version_id,
973: evt.event_id,

Line 970: p_contact_id IN ota_learning_paths.contact_id%TYPE,

966: AND lpe.lp_enrollment_id = lpme.lp_enrollment_id
967: AND lpm.learning_path_member_id = lpme.learning_path_member_id ;
968:
969: CURSOR enrolled_class(p_person_id IN ota_learning_paths.person_id%TYPE,
970: p_contact_id IN ota_learning_paths.contact_id%TYPE,
971: p_activity_version_id IN ota_learning_path_members.activity_version_id%TYPE) IS
972: SELECT oav.activity_version_id,
973: evt.event_id,
974: evt.course_start_date,