APPS.OTA_LRNG_PATH_MEMBER_UTIL dependencies on OTA_ATTEMPTS

Line 1350: p_contact_id IN ota_attempts.user_type%type)

1346: END chk_no_of_mandatory_courses;
1347:
1348: FUNCTION get_class_completion_date(p_event_id IN ota_events.event_id%type,
1349: p_person_id IN NUMBER,
1350: p_contact_id IN ota_attempts.user_type%type)
1351: RETURN DATE IS
1352:
1353: CURSOR class_type IS
1354: SELECT ocu.synchronous_flag,

Line 1364: p_user_id IN ota_attempts.user_id%type,

1360: AND ocu.category_usage_Id = ofr.delivery_mode_id
1361: AND oev.event_id = p_event_id;
1362:
1363: CURSOR get_online_compl_date_p(p_event_id IN ota_events.event_id%type,
1364: p_user_id IN ota_attempts.user_id%type,
1365: p_user_type IN ota_attempts.user_type%type) IS
1366: SELECT ota_timezone_util.get_dateDT(trunc(opf.completed_date), to_char(opf.completed_date, 'HH24:MI:SS'), ocu.Online_Flag, ota_timezone_util.get_server_timezone_code) completion_date
1367: FROM ota_events oev,
1368: ota_offerings ofr,

Line 1365: p_user_type IN ota_attempts.user_type%type) IS

1361: AND oev.event_id = p_event_id;
1362:
1363: CURSOR get_online_compl_date_p(p_event_id IN ota_events.event_id%type,
1364: p_user_id IN ota_attempts.user_id%type,
1365: p_user_type IN ota_attempts.user_type%type) IS
1366: SELECT ota_timezone_util.get_dateDT(trunc(opf.completed_date), to_char(opf.completed_date, 'HH24:MI:SS'), ocu.Online_Flag, ota_timezone_util.get_server_timezone_code) completion_date
1367: FROM ota_events oev,
1368: ota_offerings ofr,
1369: ota_performances opf,

Line 1386: p_user_id IN ota_attempts.user_id%type,

1382: AND odb.delegate_person_id = p_person_id
1383: AND oev.event_id = odb.event_id;
1384:
1385: CURSOR get_online_compl_date_c(p_event_id IN ota_events.event_id%type,
1386: p_user_id IN ota_attempts.user_id%type,
1387: p_user_type IN ota_attempts.user_type%type) IS
1388: SELECT ota_timezone_util.get_dateDT(trunc(opf.completed_date), to_char(opf.completed_date, 'HH24:MI:SS'), ocu.Online_Flag, ota_timezone_util.get_server_timezone_code) completion_date
1389: FROM ota_events oev,
1390: ota_offerings ofr,

Line 1387: p_user_type IN ota_attempts.user_type%type) IS

1383: AND oev.event_id = odb.event_id;
1384:
1385: CURSOR get_online_compl_date_c(p_event_id IN ota_events.event_id%type,
1386: p_user_id IN ota_attempts.user_id%type,
1387: p_user_type IN ota_attempts.user_type%type) IS
1388: SELECT ota_timezone_util.get_dateDT(trunc(opf.completed_date), to_char(opf.completed_date, 'HH24:MI:SS'), ocu.Online_Flag, ota_timezone_util.get_server_timezone_code) completion_date
1389: FROM ota_events oev,
1390: ota_offerings ofr,
1391: ota_performances opf,

Line 1450: l_user_id ota_attempts.user_id%type;

1446:
1447: l_sync_flag ota_category_usages.synchronous_flag%type;
1448: l_online_flag ota_category_usages.online_flag%type;
1449: l_completion_date date:= null;
1450: l_user_id ota_attempts.user_id%type;
1451: l_user_type ota_attempts.user_type%type;
1452:
1453: BEGIN
1454:

Line 1451: l_user_type ota_attempts.user_type%type;

1447: l_sync_flag ota_category_usages.synchronous_flag%type;
1448: l_online_flag ota_category_usages.online_flag%type;
1449: l_completion_date date:= null;
1450: l_user_id ota_attempts.user_id%type;
1451: l_user_type ota_attempts.user_type%type;
1452:
1453: BEGIN
1454:
1455: OPEN class_type;