Line 107: CURSOR C2 IS SELECT pa_events_s.nextval FROM sys.dual;
103: WHERE project_id = X_Project_Id
104: AND ( (task_id = X_Task_Id)
105: or (task_id is NULL and X_Task_Id is NULL))
106: AND event_num = X_Event_Num; 107: CURSOR C2 IS SELECT pa_events_s.nextval FROM sys.dual; 108:
109: BEGIN
110: if (X_Event_Id is NULL) then
111: OPEN C2;