1695: l_cs_html VARCHAR2(1000);
1696:
1697: CURSOR SR_Cur is
1698: Select Inc.Incident_number,Inc.Incident_id
1699: from Jtf_tasks_b Tsk, CS_incidents_all_b Inc
1700: where Tsk.Task_id=l_Task_id
1701: and Inc.Incident_Id=Tsk.source_object_id;
1702:
1703:
3479: l_Req_id number;
3480: l_Task_id NUMBER;
3481: CURSOR SR_Cur is
3482: Select Inc.Incident_id
3483: from Jtf_tasks_b Tsk, CS_incidents_all_b Inc
3484: where Tsk.Task_id=l_Task_id
3485: and Inc.Incident_Id=Tsk.source_object_id;
3486: BEGIN
3487: FOR i IN p_ieu_action_data.first.. p_ieu_action_data.last