1887:
1888:
1889: CURSOR c_get_event_dates(l_offer_id IN NUMBER) IS
1890: SELECT event_start_date_time, event_end_date_time
1891: FROM ams_event_offers_all_b
1892: WHERE event_offer_id = l_offer_id;
1893:
1894: CURSOR c_get_event_id(id_in IN NUMBER) IS
1895: SELECT parent_id
1904: and system_status_code = 'CONFIRMED';
1905:
1906: CURSOR c_parent_status IS
1907: SELECT count(event_offer_id)
1908: FROM ams_event_offers_all_b
1909: WHERE system_status_code IN ('COMPLETED', 'CANCELLED', 'ON_HOLD','ARCHIVED','CLOSED')
1910: AND event_offer_id = p_agenda_rec.parent_id;
1911:
1912: CURSOR c_event_status IS
1910: AND event_offer_id = p_agenda_rec.parent_id;
1911:
1912: CURSOR c_event_status IS
1913: SELECT count(event_offer_id)
1914: FROM ams_event_offers_all_b
1915: WHERE system_status_code IN ('COMPLETED', 'CANCELLED', 'ON_HOLD','ARCHIVED','CLOSED')
1916: AND event_offer_id = ( SELECT parent_id
1917: FROM ams_agendas_b
1918: WHERE agenda_id = p_agenda_rec.parent_id);
2581: FETCH c_min_max_times INTO l_min_time, l_max_time;
2582: CLOSE c_min_max_times;
2583:
2584: /* Rolling up times to Event level */
2585: UPDATE ams_event_offers_all_b
2586: SET event_start_date_time = l_min_time,
2587: event_end_date_time = l_max_time,
2588: object_version_number = object_version_number + 1
2589: WHERE event_offer_id = l_parent_id;
2603: FETCH c_min_max_times INTO l_min_time, l_max_time;
2604: CLOSE c_min_max_times;
2605:
2606: /* Rolling up times to Event level */
2607: UPDATE ams_event_offers_all_b
2608: SET event_start_date_time = l_min_time,
2609: event_end_date_time = l_max_time,
2610: object_version_number = object_version_number + 1
2611: WHERE event_offer_id = l_parent_id;