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 138: l_person_id ota_learning_paths.person_id%TYPE;

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

Line 139: l_login_person ota_learning_paths.person_id%TYPE;

135: RETURN VARCHAR2
136: IS
137:
138: l_person_id ota_learning_paths.person_id%TYPE;
139: l_login_person ota_learning_paths.person_id%TYPE;
140: l_login_customer NUMBER;
141: l_contact_id ota_learning_paths.contact_id%TYPE;
142: l_proc VARCHAR2(72) := g_package|| 'chk_login_person';
143:

Line 141: l_contact_id ota_learning_paths.contact_id%TYPE;

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

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

241: -- ----------------------------------------------------------------------------
242: -- |---------------------- -----------------------|
243: -- ----------------------------------------------------------------------------
244:
245: FUNCTION get_no_of_mandatory_courses(p_learning_path_id IN ota_learning_paths.learning_path_id%TYPE,
246: p_path_source_code IN ota_learning_paths.path_source_code%TYPE)
247: RETURN number IS
248:
249: CURSOR csr_s_lpm IS

Line 246: p_path_source_code IN ota_learning_paths.path_source_code%TYPE)

242: -- |---------------------- -----------------------|
243: -- ----------------------------------------------------------------------------
244:
245: FUNCTION get_no_of_mandatory_courses(p_learning_path_id IN ota_learning_paths.learning_path_id%TYPE,
246: p_path_source_code IN ota_learning_paths.path_source_code%TYPE)
247: RETURN number IS
248:
249: CURSOR csr_s_lpm IS
250: SELECT sum(no_of_mandatory_courses)

Line 326: p_path_source_code IN ota_learning_paths.path_source_code%TYPE)

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

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

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

Line 470: FROM ota_learning_paths lps, ota_lp_enrollments lpe

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

Line 475: l_learning_path_id ota_learning_paths.learning_path_id%TYPE;

471: WHERE lps.learning_path_id = lpe.learning_path_id
472: AND lpe.lp_enrollment_id = p_lp_enrollment_id;
473:
474: l_lp_enrollment_id ota_lp_enrollments.lp_enrollment_id%TYPE;
475: l_learning_path_id ota_learning_paths.learning_path_id%TYPE;
476: l_object_version_number ota_lp_enrollments.object_version_number%type;
477: l_path_status_code ota_lp_enrollments.path_status_code%type;
478: l_no_of_completed_courses ota_lp_enrollments.no_of_completed_courses%type;
479: l_no_of_mandatory_courses ota_lp_enrollments.no_of_mandatory_courses%type;

Line 484: l_path_source_code ota_learning_paths.path_source_code%TYPE;

480: l_completion_target_date ota_lp_enrollments.completion_target_date%TYPE;
481: l_result varchar2(3) :='F';
482: l_complete Number(9);
483: l_return_status varchar2(3) :='';
484: l_path_source_code ota_learning_paths.path_source_code%TYPE;
485: l_source_function_code ota_learning_paths.source_function_code%TYPE;
486:
487:
488: BEGIN

Line 485: l_source_function_code ota_learning_paths.source_function_code%TYPE;

481: l_result varchar2(3) :='F';
482: l_complete Number(9);
483: l_return_status varchar2(3) :='';
484: l_path_source_code ota_learning_paths.path_source_code%TYPE;
485: l_source_function_code ota_learning_paths.source_function_code%TYPE;
486:
487:
488: BEGIN
489: OPEN csr_get_path_source_code;

Line 609: ,p_source_function_code IN ota_learning_paths.source_function_code%TYPE

605: -- ---------------------------------------------------------------------------
606: --
607:
608: FUNCTION get_talent_mgmt_lp(p_person_id IN ota_lp_enrollments.person_id%TYPE
609: ,p_source_function_code IN ota_learning_paths.source_function_code%TYPE
610: ,p_source_id IN ota_learning_paths.source_id%TYPE
611: ,p_assignment_id IN ota_learning_paths.assignment_id%TYPE
612: ,p_business_group_id IN NUMBER)
613: RETURN number

Line 610: ,p_source_id IN ota_learning_paths.source_id%TYPE

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

Line 611: ,p_assignment_id IN ota_learning_paths.assignment_id%TYPE

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

Line 618: FROM ota_learning_paths

614: IS
615:
616: CURSOR csr_get_lp IS
617: SELECT learning_path_id
618: FROM ota_learning_paths
619: WHERE source_function_code = p_source_function_code
620: AND business_group_id = p_business_group_id
621: AND person_id = p_person_id
622: AND (p_source_id IS NULL OR (p_source_id IS NOT NULL AND source_id = p_source_id))

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

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

Line 674: p_person_id IN ota_learning_paths.person_id%TYPE,

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

Line 675: p_contact_id IN ota_learning_paths.contact_id%TYPE)

671: -- ----------------------------------------------------------------------------
672:
673: FUNCTION get_no_of_mand_compl_courses(p_learning_path_section_id IN ota_lp_sections.learning_path_section_id%TYPE,
674: p_person_id IN ota_learning_paths.person_id%TYPE,
675: p_contact_id IN ota_learning_paths.contact_id%TYPE)
676: RETURN number
677: IS
678: CURSOR csr_lps IS
679: SELECT learning_path_id,