APPS.OTA_CPR_UTILITY dependencies on OTA_EVENTS

Line 66: p_event_id in ota_events.event_id%type

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
67: ) RETURN varchar2;
68:
69: Procedure chk_mandatory_prereqs
70: (p_person_id ota_delegate_bookings.delegate_person_id%TYPE,

Line 72: p_event_id ota_events.event_id%TYPE

68:
69: Procedure chk_mandatory_prereqs
70: (p_person_id ota_delegate_bookings.delegate_person_id%TYPE,
71: p_delegate_contact_id ota_delegate_bookings.delegate_contact_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,

Line 90: (p_event_id in ota_events.event_id%type,

86: ) RETURN varchar2;
87:
88:
89: FUNCTION get_prereq_met_count
90: (p_event_id in ota_events.event_id%type,
91: p_prerequisite_course_id ota_activity_versions.activity_version_id%type,
92: p_comp_id in per_competence_elements.competence_id%type,
93: p_level_id in per_competence_elements.proficiency_level_id%type
94: ) RETURN varchar2;

Line 97: (p_event_id in ota_events.event_id%type,

93: p_level_id in per_competence_elements.proficiency_level_id%type
94: ) RETURN varchar2;
95:
96: FUNCTION get_prereq_not_met_count
97: (p_event_id in ota_events.event_id%type,
98: p_prerequisite_course_id ota_activity_versions.activity_version_id%type,
99: p_comp_id in per_competence_elements.competence_id%type,
100: p_level_id in per_competence_elements.proficiency_level_id%type
101: ) RETURN varchar2;

Line 105: p_event_id in ota_events.event_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
109: (p_person_id in per_all_people_f.person_id%type

Line 113: ,p_event_id in ota_events.event_id%type

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
114: ) RETURN varchar2;
115:
116: FUNCTION is_mandatory_prereqs_comp_evt
117: (p_person_id in per_all_people_f.person_id%type

Line 121: , p_event_id in ota_events.event_id%type

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
122: ) RETURN varchar2;
123:
124: -- ----------------------------------------------------------------------------
125: -- |-------------------------< is_valid_classes_available >--------------------|