[Home] [Help]
1555: ATTRIBUTE12,
1556: ATTRIBUTE13,
1557: ATTRIBUTE14,
1558: ATTRIBUTE15
1559: FROM AHL_TASK_LINKS
1560: WHERE visit_task_id in (SELECT VISIT_TASK_ID
1561: FROM AHL_VISIT_TASKS_B
1562: WHERE visit_id = x_visit_id);
1563:
2234: FETCH c_new_task_ID INTO l_new_parent_task_id;
2235: CLOSE c_new_task_ID;
2236:
2237: -- Create task link
2238: INSERT INTO AHL_TASK_LINKS
2239: (
2240: TASK_LINK_ID,
2241: OBJECT_VERSION_NUMBER,
2242: LAST_UPDATE_DATE,
2265: ATTRIBUTE15
2266: )
2267: values
2268: (
2269: ahl_task_links_s.nextval,
2270: 1,
2271: SYSDATE,
2272: Fnd_Global.USER_ID,
2273: SYSDATE,
2488: WHERE visit_id = c_visit_id;
2489: --
2490: -- Added by mpothuku on 12/27/04 to find any task links for a task
2491: CURSOR c_links (x_id IN NUMBER) IS
2492: SELECT COUNT(*) FROM Ahl_Task_Links L ,Ahl_Visit_Tasks_B T
2493: WHERE (T.VISIT_TASK_ID = L.VISIT_TASK_ID OR T.VISIT_TASK_ID = L.PARENT_TASK_ID)
2494: AND T.VISIT_TASK_ID = x_id;
2495:
2496: --To check if the unplanned tasks UE is associated with any other visits other than itself before its deletion.
2561: -- the association must be removed.
2562: OPEN c_links (l_visit_task_id);
2563: FETCH c_links INTO l_count;
2564: IF l_count > 0 THEN
2565: DELETE Ahl_Task_Links
2566: WHERE VISIT_TASK_ID = l_visit_task_id
2567: OR PARENT_TASK_ID = l_visit_task_id;
2568: END IF;
2569: CLOSE c_links;
3397: --
3398: -- Added by mpothuku on 12/27/04
3399: -- To find any task links for a task
3400: CURSOR c_links (x_id IN NUMBER) IS
3401: SELECT COUNT(*) FROM Ahl_Task_Links L ,Ahl_Visit_Tasks_B T
3402: WHERE (T.VISIT_TASK_ID = L.VISIT_TASK_ID OR T.VISIT_TASK_ID = L.PARENT_TASK_ID)
3403: AND T.VISIT_TASK_ID = x_id;
3404:
3405: -- To find task link related information for a visit
3422: ATTRIBUTE12,
3423: ATTRIBUTE13,
3424: ATTRIBUTE14,
3425: ATTRIBUTE15
3426: FROM AHL_TASK_LINKS
3427: WHERE visit_task_id in ( SELECT VISIT_TASK_ID
3428: FROM AHL_VISIT_TASKS_B
3429: WHERE visit_id = x_visit_id);
3430: -- To find the coresponding task id in the new visit
4347: /* Added by mpothuku on 01/11/04 to delete the existing links */
4348: OPEN c_links (l_exist_prim_visit_task_id);
4349: FETCH c_links INTO l_count;
4350: IF l_count > 0 THEN
4351: DELETE Ahl_Task_Links
4352: WHERE VISIT_TASK_ID = l_exist_prim_visit_task_id
4353: OR PARENT_TASK_ID = l_exist_prim_visit_task_id;
4354: END IF;
4355: CLOSE c_links;
4371: FETCH c_new_primary_task INTO l_new_parent_task_id,l_new_task_number;
4372: CLOSE c_new_primary_task;
4373:
4374: -- Create task link
4375: INSERT INTO AHL_TASK_LINKS
4376: (
4377: TASK_LINK_ID,
4378: OBJECT_VERSION_NUMBER,
4379: LAST_UPDATE_DATE,
4402: ATTRIBUTE15
4403: )
4404: values
4405: (
4406: ahl_task_links_s.nextval,
4407: 1,
4408: SYSDATE,
4409: Fnd_Global.USER_ID,
4410: SYSDATE,