66:
67: cursor c_get_extra_details(p_confirmation_code VARCHAR2) is
68: select attendant_contact_id,
69: system_status_code
70: from ams_event_registrations
71: where confirmation_code = p_confirmation_code;
72:
73: BEGIN
74:
230: l_return_status VARCHAR2(1);
231:
232: cursor c_get_status_code(p_confirmation_code VARCHAR2) is
233: select system_status_code
234: from ams_event_registrations
235: where confirmation_code = p_confirmation_code;
236:
237: BEGIN
238: