[Home] [Help]
173: p_date_status_changed ota_delegate_bookings.date_status_changed%type,
174: p_new_status varchar2,
175: p_failed varchar2) is
176:
177: v_result_object_version_number ota_finance_lines.object_version_number%type;
178: v_finance_line_id ota_finance_lines.finance_line_id%type;
179: v_booking_status_row ota_booking_status_types%rowtype;
180: v_object_version_number ota_delegate_bookings.object_version_number%type;
181: l_successful_attendance_flag varchar2(1):='N';
174: p_new_status varchar2,
175: p_failed varchar2) is
176:
177: v_result_object_version_number ota_finance_lines.object_version_number%type;
178: v_finance_line_id ota_finance_lines.finance_line_id%type;
179: v_booking_status_row ota_booking_status_types%rowtype;
180: v_object_version_number ota_delegate_bookings.object_version_number%type;
181: l_successful_attendance_flag varchar2(1):='N';
182: l_failure_reason varchar2(20);