DBA Data[Home] [Help]

APPS.OTA_UTILITY dependencies on OTA_ATTEMPTS

Line 2187: FUNCTION get_user_fullname(p_user_id IN ota_attempts.user_id%TYPE,

2183:
2184: END get_enrollment_status;
2185:
2186:
2187: FUNCTION get_user_fullname(p_user_id IN ota_attempts.user_id%TYPE,
2188: p_user_type IN ota_attempts.user_type%TYPE)
2189:
2190: RETURN VARCHAR2 IS
2191:

Line 2188: p_user_type IN ota_attempts.user_type%TYPE)

2184: END get_enrollment_status;
2185:
2186:
2187: FUNCTION get_user_fullname(p_user_id IN ota_attempts.user_id%TYPE,
2188: p_user_type IN ota_attempts.user_type%TYPE)
2189:
2190: RETURN VARCHAR2 IS
2191:
2192: CURSOR c_person_fullname IS

Line 2228: FUNCTION get_person_fullname(p_user_id IN ota_attempts.user_id%TYPE

2224: hr_utility.set_location(' Step:'|| l_proc, 20);
2225:
2226: END get_user_fullname;
2227:
2228: FUNCTION get_person_fullname(p_user_id IN ota_attempts.user_id%TYPE
2229: )RETURN VARCHAR2 IS
2230:
2231: CURSOR c_person_fullname IS
2232: select