35: IS
36: SELECT location, dial_in, meeting_mode, meeting_url,
37: meeting_id, join_url, playback_url, chat_url, download_url,
38: is_standalone_location
39: FROM cac_view_collab_details_vl
40: WHERE task_id = p_source_task_id;
41:
42: collab_row c_collab%ROWTYPE;
43: l_seqnum NUMBER := 0;
104: IS
105: SELECT location, dial_in, meeting_mode, meeting_url,
106: meeting_id, join_url, playback_url, chat_url, download_url,
107: is_standalone_location
108: FROM cac_view_collab_details_vl
109: WHERE task_id = p_source_task_id;
110:
111: CURSOR c_collab_update
112: IS
110:
111: CURSOR c_collab_update
112: IS
113: SELECT collab_id
114: FROM cac_view_collab_details_vl
115: WHERE task_id = p_target_task_id;
116:
117: collab_row c_collab%ROWTYPE;
118: collab_update_row c_collab_update%ROWTYPE;