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:
277: Cursor c_get_mandatory_courses( p_enforcement_mode in ota_course_prerequisites.enforcement_mode%TYPE) is

Line 330: p_user_type in ota_attempts.user_type%type,

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

Line 387: p_user_type in ota_attempts.user_type%type,

383: FUNCTION get_enroll_image
384: (p_person_id in per_all_people_f.person_id%type,
385: p_delegate_contact_id in NUMBER,
386: p_user_id in NUMBER,
387: p_user_type in ota_attempts.user_type%type,
388: p_event_id in ota_events.event_id%type
389: ) RETURN varchar2 is
390:
391: Cursor c_get_act_ver_id is

Line 456: l_user_type ota_attempts.user_type%type;

452: and ACCT_ROLE.cust_account_role_id = p_delegate_contact_id;
453:
454: l_ext_lrn_party_id HZ_PARTIES.Party_Id%TYPE;
455: l_user_id number;
456: l_user_type ota_attempts.user_type%type;
457: l_act_ver_id ota_activity_versions.activity_version_id%type;
458: l_prereq_completed_status varchar2(1);
459:
460: Begin

Line 488: p_user_type in ota_attempts.user_type%type,

484: FUNCTION is_mand_crs_prereqs_completed
485: (p_person_id in per_all_people_f.person_id%type,
486: p_delegate_contact_id in NUMBER,
487: p_user_id in NUMBER,
488: p_user_type in ota_attempts.user_type%type,
489: p_act_ver_id in ota_activity_versions.activity_version_id%type
490: ) RETURN varchar2
491: IS
492: