APPS.OTA_BULK_ENROLL_UTIL dependencies on OTA_LEARNING_PATHS_TL

Line 1142: FROM ota_learning_paths_tl

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

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

1155: WHERE event_id = p_object_id
1156: AND language = USERENV('LANG');
1157:
1158: l_class_name OTA_EVENTS_TL.TITLE%TYPE := NULL;
1159: l_lp_name OTA_LEARNING_PATHS_TL.NAME%TYPE := NULL;
1160: l_cert_name OTA_CERTIFICATIONS_TL.NAME%TYPE := NULL;
1161: BEGIN
1162: IF p_object_type = 'CL' THEN
1163: OPEN csr_get_class_name;