324: --
325: function CHANGE_TO_WAIT_STATUS (p_business_group_id in number,
326: p_event_id in number)
327: return boolean is
328: l_booking_status_type ota_booking_status_types.type%type;
329: l_success boolean := true;
330: cursor c1 is
331: select BST.TYPE
332: FROM OTA_BOOKING_STATUS_TYPES BST ,
328: l_booking_status_type ota_booking_status_types.type%type;
329: l_success boolean := true;
330: cursor c1 is
331: select BST.TYPE
332: FROM OTA_BOOKING_STATUS_TYPES BST ,
333: PER_ALL_PEOPLE_F DEL ,
334: OTA_EVENTS EVT ,
335: OTA_DELEGATE_BOOKINGS TDB
336: where tdb.business_group_id = p_business_group_id
3263:
3264: l_event_status_changed boolean :=
3265: ota_general.value_changed (ota_evt_shd.g_old_rec.event_status,
3266: p_event_status);
3267: l_status_type ota_booking_status_types.type%type;
3268: l_old_status_type ota_booking_status_types.type%type;
3269: l_invoice_rule varchar2(80);
3270: l_exist varchar2(1);
3271: l_dynamicSqlString VARCHAR2(2000);
3264: l_event_status_changed boolean :=
3265: ota_general.value_changed (ota_evt_shd.g_old_rec.event_status,
3266: p_event_status);
3267: l_status_type ota_booking_status_types.type%type;
3268: l_old_status_type ota_booking_status_types.type%type;
3269: l_invoice_rule varchar2(80);
3270: l_exist varchar2(1);
3271: l_dynamicSqlString VARCHAR2(2000);
3272: l_ins_status VARCHAR2(1);