APPS.OTA_CPR_UTILITY dependencies on OTA_DELEGATE_BOOKINGS

Line 70: (p_person_id ota_delegate_bookings.delegate_person_id%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,
71: p_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE,
72: p_event_id ota_events.event_id%TYPE
73: );
74:

Line 71: p_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE,

67: ) RETURN varchar2;
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

Line 110: ,p_delegate_contact_id in ota_delegate_bookings.delegate_contact_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
114: ) RETURN varchar2;

Line 118: ,p_delegate_contact_id in ota_delegate_bookings.delegate_contact_id%TYPE default NULL

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
122: ) RETURN varchar2;