APPS.OTA_CPR_UTILITY dependencies on OTA_ATTEMPTS

Line 41: p_user_type in ota_attempts.user_type%type,

37: FUNCTION is_course_completed
38: (p_person_id in per_all_people_f.person_id%type,
39: p_delegate_contact_id in NUMBER,
40: p_user_id in NUMBER,
41: p_user_type in ota_attempts.user_type%type,
42: p_act_ver_id in ota_activity_versions.activity_version_id%type
43: ) RETURN varchar2;
44:
45: FUNCTION is_mandatory_prereqs_completed

Line 49: p_user_type in ota_attempts.user_type%type,

45: FUNCTION is_mandatory_prereqs_completed
46: (p_person_id in per_all_people_f.person_id%type,
47: p_delegate_contact_id in NUMBER,
48: p_user_id in NUMBER,
49: p_user_type in ota_attempts.user_type%type,
50: p_act_ver_id in ota_activity_versions.activity_version_id%type
51: ) RETURN varchar2;
52:
53: FUNCTION is_advisory_prereqs_completed

Line 57: p_user_type in ota_attempts.user_type%type,

53: FUNCTION is_advisory_prereqs_completed
54: (p_person_id in per_all_people_f.person_id%type,
55: p_delegate_contact_id in NUMBER,
56: p_user_id in NUMBER,
57: p_user_type in ota_attempts.user_type%type,
58: p_act_ver_id in ota_activity_versions.activity_version_id%type
59: ) RETURN varchar2;
60:
61: FUNCTION get_enroll_image

Line 65: p_user_type in ota_attempts.user_type%type,

61: FUNCTION get_enroll_image
62: (p_person_id in per_all_people_f.person_id%type,
63: p_delegate_contact_id in NUMBER,
64: p_user_id in NUMBER,
65: p_user_type in ota_attempts.user_type%type,
66: p_event_id in ota_events.event_id%type
67: ) RETURN varchar2;
68:
69: Procedure chk_mandatory_prereqs

Line 79: p_user_type in ota_attempts.user_type%type,

75: FUNCTION is_mand_crs_prereqs_completed
76: (p_person_id in per_all_people_f.person_id%type,
77: p_delegate_contact_id in NUMBER,
78: p_user_id in NUMBER,
79: p_user_type in ota_attempts.user_type%type,
80: p_act_ver_id in ota_activity_versions.activity_version_id%type
81: ) RETURN varchar2;
82:
83: FUNCTION is_mand_comp_prereqs_completed