APPS.AHL_VWP_TASKS_PVT dependencies on AHL_TASK_LINKS

Line 5403: SELECT COUNT(*) FROM Ahl_Task_Links L ,Ahl_Visit_Tasks_B T

5399: c_primary_rec c_primary%ROWTYPE;
5400:
5401: -- To find any task links for a deleted task
5402: CURSOR c_links (x_id IN NUMBER) IS
5403: SELECT COUNT(*) FROM Ahl_Task_Links L ,Ahl_Visit_Tasks_B T
5404: WHERE (T.VISIT_TASK_ID = L.VISIT_TASK_ID OR T.VISIT_TASK_ID = L.PARENT_TASK_ID)
5405: AND T.VISIT_TASK_ID = x_id;
5406:
5407: -- To find if WIP job is created for the Visit

Line 5603: DELETE Ahl_Task_Links

5599: -- the association must be removed.
5600: OPEN c_links (l_task_id);
5601: FETCH c_links INTO l_count;
5602: IF l_count > 0 THEN
5603: DELETE Ahl_Task_Links
5604: WHERE VISIT_TASK_ID = l_task_id
5605: OR PARENT_TASK_ID = l_task_id;
5606: END IF;
5607: CLOSE c_links;

Line 5802: SELECT COUNT(*) FROM Ahl_Task_Links L ,Ahl_Visit_Tasks_B T

5798: c_primary_rec c_primary%ROWTYPE;
5799:
5800: -- To find any task links for a deleted task
5801: CURSOR c_links (x_id IN NUMBER) IS
5802: SELECT COUNT(*) FROM Ahl_Task_Links L ,Ahl_Visit_Tasks_B T
5803: WHERE (T.VISIT_TASK_ID = L.VISIT_TASK_ID
5804: OR T.VISIT_TASK_ID = L.PARENT_TASK_ID)
5805: AND T.VISIT_TASK_ID = x_id;
5806:

Line 6054: 'Before deleting from AHL_TASK_LINKS table');

6050:
6051: IF (l_log_statement >= l_log_current_level) THEN
6052: fnd_log.string(l_log_statement,
6053: L_DEBUG_KEY,
6054: 'Before deleting from AHL_TASK_LINKS table');
6055: END IF;
6056:
6057: OPEN c_links (l_task_id);
6058: FETCH c_links INTO l_count;

Line 6060: DELETE Ahl_Task_Links

6056:
6057: OPEN c_links (l_task_id);
6058: FETCH c_links INTO l_count;
6059: IF l_count > 0 THEN
6060: DELETE Ahl_Task_Links
6061: WHERE VISIT_TASK_ID = l_task_id
6062: OR PARENT_TASK_ID = l_task_id;
6063: END IF;
6064: CLOSE c_links;

Line 6247: SELECT COUNT(*) FROM Ahl_Task_Links L ,Ahl_Visit_Tasks_B T

6243: c_primary_rec c_primary%ROWTYPE;
6244:
6245: -- To find any task links for a deleted task
6246: CURSOR c_links (x_id IN NUMBER) IS
6247: SELECT COUNT(*) FROM Ahl_Task_Links L ,Ahl_Visit_Tasks_B T
6248: WHERE (T.VISIT_TASK_ID = L.VISIT_TASK_ID
6249: OR T.VISIT_TASK_ID = L.PARENT_TASK_ID)
6250: AND T.VISIT_TASK_ID = x_id;
6251:

Line 6562: 'Before deleting from AHL_TASK_LINKS table');

6558:
6559: IF (l_log_statement >= l_log_current_level)THEN
6560: fnd_log.string(l_log_statement,
6561: L_DEBUG_KEY,
6562: 'Before deleting from AHL_TASK_LINKS table');
6563: END IF;
6564:
6565: OPEN c_links (l_task_id);
6566: FETCH c_links INTO l_count;

Line 6568: DELETE Ahl_Task_Links

6564:
6565: OPEN c_links (l_task_id);
6566: FETCH c_links INTO l_count;
6567: IF l_count > 0 THEN
6568: DELETE Ahl_Task_Links
6569: WHERE VISIT_TASK_ID = l_task_id
6570: OR PARENT_TASK_ID = l_task_id;
6571: END IF;
6572: CLOSE c_links;

Line 6776: 'Before deletion from Ahl_Task_Links table');

6772: END IF;
6773: IF (l_log_statement >= l_log_current_level) THEN
6774: fnd_log.string(l_log_statement,
6775: L_DEBUG_KEY,
6776: 'Before deletion from Ahl_Task_Links table');
6777: END IF;
6778: OPEN c_links (l_task_id);
6779: FETCH c_links INTO l_count;
6780: IF l_count > 0 THEN

Line 6781: DELETE Ahl_Task_Links

6777: END IF;
6778: OPEN c_links (l_task_id);
6779: FETCH c_links INTO l_count;
6780: IF l_count > 0 THEN
6781: DELETE Ahl_Task_Links
6782: WHERE VISIT_TASK_ID = l_task_id
6783: OR PARENT_TASK_ID = l_task_id;
6784: END IF;
6785: CLOSE c_links;