APPS.OTA_CPR_UTILITY dependencies on OTA_ATTEMPTS

Line 208: p_user_type in ota_attempts.user_type%type,

204: FUNCTION is_course_completed
205: (p_person_id in per_all_people_f.person_id%type,
206: p_delegate_contact_id in NUMBER,
207: p_user_id in NUMBER,
208: p_user_type in ota_attempts.user_type%type,
209: p_act_ver_id in ota_activity_versions.activity_version_id%type
210: ) RETURN varchar2 is
211:
212: Cursor c_get_classes is

Line 273: p_user_type in ota_attempts.user_type%type,

269: FUNCTION is_mandatory_prereqs_completed
270: (p_person_id in per_all_people_f.person_id%type,
271: p_delegate_contact_id in NUMBER,
272: p_user_id in NUMBER,
273: p_user_type in ota_attempts.user_type%type,
274: p_act_ver_id in ota_activity_versions.activity_version_id%type
275: ) RETURN varchar2 is
276: -- Bug 13035257
277: Cursor c_get_mandatory_courses( p_enforcement_mode in ota_course_prerequisites.enforcement_mode%TYPE) is

Line 333: p_user_type in ota_attempts.user_type%type,

329: FUNCTION is_advisory_prereqs_completed
330: (p_person_id in per_all_people_f.person_id%type,
331: p_delegate_contact_id in NUMBER,
332: p_user_id in NUMBER,
333: p_user_type in ota_attempts.user_type%type,
334: p_act_ver_id in ota_activity_versions.activity_version_id%type
335: ) RETURN varchar2 is
336:
337: Cursor c_get_advisory_courses( p_enforcement_mode in ota_course_prerequisites.enforcement_mode%TYPE) is

Line 393: p_user_type in ota_attempts.user_type%type,

389: FUNCTION get_enroll_image
390: (p_person_id in per_all_people_f.person_id%type,
391: p_delegate_contact_id in NUMBER,
392: p_user_id in NUMBER,
393: p_user_type in ota_attempts.user_type%type,
394: p_event_id in ota_events.event_id%type
395: ) RETURN varchar2 is
396:
397: Cursor c_get_act_ver_id is

Line 462: l_user_type ota_attempts.user_type%type;

458: and ACCT_ROLE.cust_account_role_id = p_delegate_contact_id;
459:
460: l_ext_lrn_party_id HZ_PARTIES.Party_Id%TYPE;
461: l_user_id number;
462: l_user_type ota_attempts.user_type%type;
463: l_act_ver_id ota_activity_versions.activity_version_id%type;
464: l_prereq_completed_status varchar2(1);
465:
466: Begin

Line 494: p_user_type in ota_attempts.user_type%type,

490: FUNCTION is_mand_crs_prereqs_completed
491: (p_person_id in per_all_people_f.person_id%type,
492: p_delegate_contact_id in NUMBER,
493: p_user_id in NUMBER,
494: p_user_type in ota_attempts.user_type%type,
495: p_act_ver_id in ota_activity_versions.activity_version_id%type
496: ) RETURN varchar2
497: IS
498:

Line 842: cursor get_dependent_courses(p_act_ver_id in ota_attempts.user_type%type,

838: FUNCTION get_all_dependent_courses
839: (p_act_ver_id in ota_activity_versions.activity_version_id%type,
840: p_pre_req_crs_end_date varchar2) RETURN varchar2 is
841: --
842: cursor get_dependent_courses(p_act_ver_id in ota_attempts.user_type%type,
843: p_pre_req_crs_end_date date) is
844: select oavt.version_name Dependant_Course_Name,
845: ocp.prerequisite_type Prerequisite_Type,
846: ocp.enforcement_mode Enforcement_Mode,