APPS.OTA_LRNG_PATH_MEMBER_UTIL dependencies on OTA_LRNG_PATH_MEMBER_UTIL

Line 1: PACKAGE BODY OTA_LRNG_PATH_MEMBER_UTIL as

1: PACKAGE BODY OTA_LRNG_PATH_MEMBER_UTIL as
2: /* $Header: otlpmwrs.pkb 120.5.12020000.4 2013/03/21 07:47:25 atadepal ship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

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

Line 1511: SELECT max(ota_lrng_path_member_util.get_class_completion_date(oev.event_id,lpe.person_id, lpe.contact_id)) completion_date

1507: FUNCTION get_lp_completion_date(p_lp_enrollment_id ota_lp_enrollments.lp_enrollment_id%TYPE)
1508: RETURN DATE IS
1509:
1510: CURSOR get_completion_date IS
1511: SELECT max(ota_lrng_path_member_util.get_class_completion_date(oev.event_id,lpe.person_id, lpe.contact_id)) completion_date
1512: FROM ota_lp_enrollments lpe,
1513: ota_learning_path_members lpm,
1514: ota_events oev
1515: WHERE lpe.learning_path_id = lpm.learning_path_id

Line 1539: SELECT max(ota_lrng_path_member_util.get_class_completion_date(oev.event_id,lpe.person_id, lpe.contact_id)) completion_date

1535: p_contact_id ota_lp_enrollments.contact_id%TYPE)
1536: RETURN DATE IS
1537:
1538: CURSOR get_lpm_completion_date IS
1539: SELECT max(ota_lrng_path_member_util.get_class_completion_date(oev.event_id,lpe.person_id, lpe.contact_id)) completion_date
1540: FROM ota_lp_enrollments lpe,
1541: ota_learning_path_members lpm,
1542: ota_lp_member_enrollments lpme,
1543: ota_events oev

Line 1551: SELECT max(ota_lrng_path_member_util.get_class_completion_date(oev.event_id,p_person_id, p_contact_id)) completion_date

1547: AND lpme.learning_path_member_id = lpm.learning_path_member_id
1548: AND lpme.lp_member_enrollment_id = p_lp_member_enrollment_id;
1549:
1550: CURSOR get_crs_completion_date IS
1551: SELECT max(ota_lrng_path_member_util.get_class_completion_date(oev.event_id,p_person_id, p_contact_id)) completion_date
1552: FROM ota_events oev
1553: WHERE oev.activity_version_id = p_activity_version_id;
1554:
1555: l_completion_date date := null;

Line 1572: END ota_lrng_path_member_util;

1568: RETURN l_completion_date;
1569:
1570: END get_lpm_completion_date;
1571:
1572: END ota_lrng_path_member_util;
1573:
1574: