APPS.OTA_BULK_ENROLL_UTIL dependencies on OTA_LEARNING_PATHS_TL

Line 1145: FROM ota_learning_paths_tl

1141: FUNCTION get_object_name(p_object_type IN VARCHAR2, p_object_id IN NUMBER)
1142: RETURN VARCHAR2 IS
1143: CURSOR csr_get_lp_name IS
1144: SELECT name
1145: FROM ota_learning_paths_tl
1146: WHERE learning_path_id = p_object_id
1147: AND language = USERENV('LANG');
1148:
1149: CURSOR csr_get_cert_name IS

Line 1162: l_lp_name OTA_LEARNING_PATHS_TL.NAME%TYPE := NULL;

1158: WHERE event_id = p_object_id
1159: AND language = USERENV('LANG');
1160:
1161: l_class_name OTA_EVENTS_TL.TITLE%TYPE := NULL;
1162: l_lp_name OTA_LEARNING_PATHS_TL.NAME%TYPE := NULL;
1163: l_cert_name OTA_CERTIFICATIONS_TL.NAME%TYPE := NULL;
1164: BEGIN
1165: IF p_object_type in ('CL','LPCL','CLU') THEN ----modified for 12426494
1166: OPEN csr_get_class_name;