APPS.OTA_CPR_UTILITY dependencies on PER_ALL_PEOPLE_F

Line 7: (p_person_id in per_all_people_f.person_id%type,

3:
4: g_package varchar2(33) := ' ota_cpr_utility.'; -- Global package name
5:
6: FUNCTION is_competency_acheived
7: (p_person_id in per_all_people_f.person_id%type,
8: p_comp_id in per_competence_elements.competence_id%type,
9: p_level_id in per_competence_elements.proficiency_level_id%type
10: ) RETURN varchar2 is
11:

Line 205: (p_person_id in per_all_people_f.person_id%type,

201: End check_learner_comp_step_values;
202:
203:
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

Line 270: (p_person_id in per_all_people_f.person_id%type,

266: RETURN l_completed_status;
267: End is_course_completed;
268:
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

Line 330: (p_person_id in per_all_people_f.person_id%type,

326: RETURN l_completed_status;
327: End is_mandatory_prereqs_completed;
328:
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

Line 390: (p_person_id in per_all_people_f.person_id%type,

386: RETURN l_completed_status;
387: End is_advisory_prereqs_completed;
388:
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

Line 491: (p_person_id in per_all_people_f.person_id%type,

487: End If;
488: End chk_mandatory_prereqs;
489:
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

Line 528: (p_person_id in per_all_people_f.person_id%type,

524: RETURN l_completed_status;
525: END is_mand_crs_prereqs_completed;
526:
527: FUNCTION is_mand_comp_prereqs_completed
528: (p_person_id in per_all_people_f.person_id%type,
529: p_act_ver_id in ota_activity_versions.activity_version_id%type
530: ) RETURN varchar2
531: IS
532: Cursor c_get_mandatory_competencies is

Line 708: (p_person_id in per_all_people_f.person_id%type,

704:
705:
706: -- Added for Bug#4485646
707: FUNCTION is_mand_comp_prereqs_comp_evt
708: (p_person_id in per_all_people_f.person_id%type,
709: p_event_id in ota_events.event_id%type
710: ) RETURN varchar2
711: IS
712: CURSOR csr_get_course_id IS

Line 729: (p_person_id in per_all_people_f.person_id%type

725: ,p_act_ver_id => l_activity_version_id);
726: END is_mand_comp_prereqs_comp_evt;
727:
728: FUNCTION is_mand_crs_prereqs_comp_evt
729: (p_person_id in per_all_people_f.person_id%type
730: ,p_delegate_contact_id in ota_delegate_bookings.delegate_contact_id%TYPE
731: ,p_user_id in number
732: ,p_user_type in varchar2
733: ,p_event_id in ota_events.event_id%type

Line 756: (p_person_id in per_all_people_f.person_id%type

752: ,p_act_ver_id => l_activity_version_id);
753: END is_mand_crs_prereqs_comp_evt;
754:
755: FUNCTION is_mandatory_prereqs_comp_evt
756: (p_person_id in per_all_people_f.person_id%type
757: ,p_delegate_contact_id in ota_delegate_bookings.delegate_contact_id%TYPE default NULL
758: ,p_user_id in number default NULL
759: ,p_user_type in varchar2 default 'E'
760: , p_event_id in ota_events.event_id%type