DBA Data[Home] [Help]

APPS.OTA_TRAINING_RECORD dependencies on OTA_EVENTS_V

Line 17: PROCEDURE get_events(p_event_id IN ota_events_v.event_id%TYPE,

13: END IF;
14: RETURN FALSE;
15: END is_required;
16:
17: PROCEDURE get_events(p_event_id IN ota_events_v.event_id%TYPE,
18: p_activity_version_id IN ota_activity_versions_vl.activity_version_id%TYPE,
19: p_events_tbl OUT NOCOPY event_tabletype)
20: IS
21: CURSOR cur_event IS

Line 110: FROM OTA_EVENTS_V

106: timezone,
107: inventory_item_id,
108: parent_offering_id,
109: data_source
110: FROM OTA_EVENTS_V
111: WHERE ((p_event_id IS NULL) OR (p_event_id IS NOT NULL AND event_id = p_event_id))
112: AND ((p_activity_version_id IS NULL) OR (p_activity_version_id IS NOT NULL AND activity_version_id = p_activity_version_id));
113:
114: l_event_rec event_rectype;