906: --
907: v_start_date date;
908: v_end_date date;
909: v_proc varchar2(72) := g_package||'check_dates_update_evt';
910: l_obj_off varchar2(30) := ota_utility.Get_lookup_meaning('OTA_CATALOG_OBJECT_TYPE','O',810);
911: l_obj_act varchar2(30) := ota_utility.Get_lookup_meaning('OTA_CATALOG_OBJECT_TYPE','H',810);
912:
913: --
914: cursor sel_check_dates is
907: v_start_date date;
908: v_end_date date;
909: v_proc varchar2(72) := g_package||'check_dates_update_evt';
910: l_obj_off varchar2(30) := ota_utility.Get_lookup_meaning('OTA_CATALOG_OBJECT_TYPE','O',810);
911: l_obj_act varchar2(30) := ota_utility.Get_lookup_meaning('OTA_CATALOG_OBJECT_TYPE','H',810);
912:
913: --
914: cursor sel_check_dates is
915: select start_date