APPS.OTA_LRNG_PATH_UTIL dependencies on OTA_LRNG_PATH_UTIL

Line 1: PACKAGE BODY OTA_LRNG_PATH_UTIL as

1: PACKAGE BODY OTA_LRNG_PATH_UTIL as
2: /* $Header: otlpswrs.pkb 120.6.12020000.7 2013/03/21 11:36:30 atadepal ship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

Line 8: g_package VARCHAR2(33) := 'ota_lrng_path_util.'; -- Global package name

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package VARCHAR2(33) := 'ota_lrng_path_util.'; -- Global package name
9:
10: -- ---------------------------------------------------------------------------
11: -- |----------------------< chk_complete_path_ok >--------------------------|
12: -- ---------------------------------------------------------------------------

Line 930: select sum(OTA_LRNG_PATH_UTIL.get_no_of_mand_compl_courses(ols.learning_path_section_id, ole.person_id, ole.contact_id))

926: FUNCTION get_no_of_mand_compl_courses(p_lp_enrollment_id IN ota_lp_enrollments.lp_enrollment_id%TYPE)
927: RETURN number is
928:
929: cursor get_lp_mand_completed is
930: select sum(OTA_LRNG_PATH_UTIL.get_no_of_mand_compl_courses(ols.learning_path_section_id, ole.person_id, ole.contact_id))
931: from ota_lp_enrollments ole, ota_lp_sections ols
932: where ole.learning_path_id = ols.learning_path_id
933: and ole.lp_enrollment_id = p_lp_enrollment_id;
934:

Line 1000: if(ota_lrng_path_util.is_path_successful(p_lp_enrollment_id => p_lp_enrollment_id) = 'Y') then

996: l_date_status_changed DATE;
997: l_successful_attendance_flag ota_delegate_bookings.successful_attendance_flag%type;
998:
999: begin
1000: if(ota_lrng_path_util.is_path_successful(p_lp_enrollment_id => p_lp_enrollment_id) = 'Y') then
1001: return ota_utility.get_lookup_meaning('OTA_LP_CURRENT_STATUS', 'COMPLETED', 810);
1002: else
1003: for lp_mbr_rec in lp_members loop
1004: if(lp_mbr_rec.path_status_code = 'CANCELLED') then

Line 1081: END ota_lrng_path_util;

1077: return l_lp_enrollment_id;
1078:
1079: END get_lp_enroll_id;
1080: --
1081: END ota_lrng_path_util;
1082: