APPS.OTA_CPR_UTILITY dependencies on PER_ALL_PEOPLE_F

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

22: -- Public
23: -- {End of Comments}
24: ------------------------------------------------------------------
25: FUNCTION is_competency_acheived
26: (p_person_id in per_all_people_f.person_id%type,
27: p_comp_id in per_competence_elements.competence_id%type,
28: p_level_id in per_competence_elements.proficiency_level_id%type
29: ) RETURN varchar2;
30:

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

34: p_level_id in per_competence_elements.proficiency_level_id%type
35: ) RETURN varchar2;
36:
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

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

42: p_act_ver_id in ota_activity_versions.activity_version_id%type
43: ) RETURN varchar2;
44:
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

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

50: p_act_ver_id in ota_activity_versions.activity_version_id%type
51: ) RETURN varchar2;
52:
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

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

58: p_act_ver_id in ota_activity_versions.activity_version_id%type
59: ) RETURN varchar2;
60:
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

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

72: p_event_id ota_events.event_id%TYPE
73: );
74:
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

Line 84: (p_person_id in per_all_people_f.person_id%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
84: (p_person_id in per_all_people_f.person_id%type,
85: p_act_ver_id in ota_activity_versions.activity_version_id%type
86: ) RETURN varchar2;
87:
88:

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

100: p_level_id in per_competence_elements.proficiency_level_id%type
101: ) RETURN varchar2;
102:
103: FUNCTION is_mand_comp_prereqs_comp_evt
104: (p_person_id in per_all_people_f.person_id%type,
105: p_event_id in ota_events.event_id%type
106: ) RETURN varchar2;
107:
108: FUNCTION is_mand_crs_prereqs_comp_evt

Line 109: (p_person_id in per_all_people_f.person_id%type

105: p_event_id in ota_events.event_id%type
106: ) RETURN varchar2;
107:
108: FUNCTION is_mand_crs_prereqs_comp_evt
109: (p_person_id in per_all_people_f.person_id%type
110: ,p_delegate_contact_id in ota_delegate_bookings.delegate_contact_id%TYPE
111: ,p_user_id in number
112: ,p_user_type in varchar2
113: ,p_event_id in ota_events.event_id%type

Line 117: (p_person_id in per_all_people_f.person_id%type

113: ,p_event_id in ota_events.event_id%type
114: ) RETURN varchar2;
115:
116: FUNCTION is_mandatory_prereqs_comp_evt
117: (p_person_id in per_all_people_f.person_id%type
118: ,p_delegate_contact_id in ota_delegate_bookings.delegate_contact_id%TYPE default NULL
119: ,p_user_id in number default NULL
120: ,p_user_type in varchar2 default 'E'
121: , p_event_id in ota_events.event_id%type