DBA Data[Home] [Help]

APPS.OTA_OFF_UPD dependencies on OTA_EVENTS

Line 892: TYPE EventIdTab IS TABLE OF ota_events.event_id%TYPE;

888: ) is
889: --
890: v_exists varchar2(1);
891: v_proc varchar2(72) := g_package||'update_evt_when_course_changed';
892: TYPE EventIdTab IS TABLE OF ota_events.event_id%TYPE;
893: v_event_tab EventIdTab;
894: p_effective_date date := sysdate ;
895: p_object_version_number number(30);
896: --

Line 899: from ota_events evt

895: p_object_version_number number(30);
896: --
897: cursor sel_evt is
898: select event_id,object_version_number
899: from ota_events evt
900: where evt.parent_offering_id = p_offering_id ;
901: --
902: Begin
903: --