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 327: (p_person_id in per_all_people_f.person_id%type,

323: RETURN l_completed_status;
324: End is_mandatory_prereqs_completed;
325:
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

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

380: RETURN l_completed_status;
381: End is_advisory_prereqs_completed;
382:
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

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

481: End If;
482: End chk_mandatory_prereqs;
483:
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

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

518: RETURN l_completed_status;
519: END is_mand_crs_prereqs_completed;
520:
521: FUNCTION is_mand_comp_prereqs_completed
522: (p_person_id in per_all_people_f.person_id%type,
523: p_act_ver_id in ota_activity_versions.activity_version_id%type
524: ) RETURN varchar2
525: IS
526: Cursor c_get_mandatory_competencies is

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

698:
699:
700: -- Added for Bug#4485646
701: FUNCTION is_mand_comp_prereqs_comp_evt
702: (p_person_id in per_all_people_f.person_id%type,
703: p_event_id in ota_events.event_id%type
704: ) RETURN varchar2
705: IS
706: CURSOR csr_get_course_id IS

Line 723: (p_person_id in per_all_people_f.person_id%type

719: ,p_act_ver_id => l_activity_version_id);
720: END is_mand_comp_prereqs_comp_evt;
721:
722: FUNCTION is_mand_crs_prereqs_comp_evt
723: (p_person_id in per_all_people_f.person_id%type
724: ,p_delegate_contact_id in ota_delegate_bookings.delegate_contact_id%TYPE
725: ,p_user_id in number
726: ,p_user_type in varchar2
727: ,p_event_id in ota_events.event_id%type

Line 750: (p_person_id in per_all_people_f.person_id%type

746: ,p_act_ver_id => l_activity_version_id);
747: END is_mand_crs_prereqs_comp_evt;
748:
749: FUNCTION is_mandatory_prereqs_comp_evt
750: (p_person_id in per_all_people_f.person_id%type
751: ,p_delegate_contact_id in ota_delegate_bookings.delegate_contact_id%TYPE default NULL
752: ,p_user_id in number default NULL
753: ,p_user_type in varchar2 default 'E'
754: , p_event_id in ota_events.event_id%type