APPS.AHL_VWP_TASKS_PVT dependencies on AHL_TASK_LINKS

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

6437: c_primary_rec c_primary%ROWTYPE;
6438:
6439: -- To find any task links for a deleted task
6440: CURSOR c_links (x_id IN NUMBER) IS
6441: SELECT COUNT(*) FROM Ahl_Task_Links L ,Ahl_Visit_Tasks_B T
6442: WHERE (T.VISIT_TASK_ID = L.VISIT_TASK_ID OR T.VISIT_TASK_ID = L.PARENT_TASK_ID)
6443: AND T.VISIT_TASK_ID = x_id;
6444:
6445: -- To find if WIP job is created for the Visit

Line 6642: DELETE Ahl_Task_Links

6638: -- the association must be removed.
6639: OPEN c_links (l_task_id);
6640: FETCH c_links INTO l_count;
6641: IF l_count > 0 THEN
6642: DELETE Ahl_Task_Links
6643: WHERE VISIT_TASK_ID = l_task_id
6644: OR PARENT_TASK_ID = l_task_id;
6645: END IF;
6646: CLOSE c_links;

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

6875: c_primary_rec c_primary%ROWTYPE;
6876:
6877: -- To find any task links for a deleted task
6878: CURSOR c_links (x_id IN NUMBER) IS
6879: SELECT COUNT(*) FROM Ahl_Task_Links L ,Ahl_Visit_Tasks_B T
6880: WHERE (T.VISIT_TASK_ID = L.VISIT_TASK_ID
6881: OR T.VISIT_TASK_ID = L.PARENT_TASK_ID)
6882: AND T.VISIT_TASK_ID = x_id;
6883:

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

7154:
7155: IF (l_log_statement >= l_log_current_level) THEN
7156: fnd_log.string(l_log_statement,
7157: L_DEBUG_KEY,
7158: 'Before deleting from AHL_TASK_LINKS table');
7159: END IF;
7160:
7161: OPEN c_links (l_task_id);
7162: FETCH c_links INTO l_count;

Line 7164: DELETE Ahl_Task_Links

7160:
7161: OPEN c_links (l_task_id);
7162: FETCH c_links INTO l_count;
7163: IF l_count > 0 THEN
7164: DELETE Ahl_Task_Links
7165: WHERE VISIT_TASK_ID = l_task_id
7166: OR PARENT_TASK_ID = l_task_id;
7167: END IF;
7168: CLOSE c_links;

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

7390: c_primary_rec c_primary%ROWTYPE;
7391:
7392: -- To find any task links for a deleted task
7393: CURSOR c_links (x_id IN NUMBER) IS
7394: SELECT COUNT(*) FROM Ahl_Task_Links L ,Ahl_Visit_Tasks_B T
7395: WHERE (T.VISIT_TASK_ID = L.VISIT_TASK_ID
7396: OR T.VISIT_TASK_ID = L.PARENT_TASK_ID)
7397: AND T.VISIT_TASK_ID = x_id;
7398:

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

7787:
7788: IF (l_log_statement >= l_log_current_level)THEN
7789: fnd_log.string(l_log_statement,
7790: L_DEBUG_KEY,
7791: 'Before deleting from AHL_TASK_LINKS table');
7792: END IF;
7793:
7794: OPEN c_links (l_task_id);
7795: FETCH c_links INTO l_count;

Line 7797: DELETE Ahl_Task_Links

7793:
7794: OPEN c_links (l_task_id);
7795: FETCH c_links INTO l_count;
7796: IF l_count > 0 THEN
7797: DELETE Ahl_Task_Links
7798: WHERE VISIT_TASK_ID = l_task_id
7799: OR PARENT_TASK_ID = l_task_id;
7800: END IF;
7801: CLOSE c_links;

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

8038: END IF;
8039: IF (l_log_statement >= l_log_current_level) THEN
8040: fnd_log.string(l_log_statement,
8041: L_DEBUG_KEY,
8042: 'Before deletion from Ahl_Task_Links table');
8043: END IF;
8044: OPEN c_links (l_task_id);
8045: FETCH c_links INTO l_count;
8046: IF l_count > 0 THEN

Line 8047: DELETE Ahl_Task_Links

8043: END IF;
8044: OPEN c_links (l_task_id);
8045: FETCH c_links INTO l_count;
8046: IF l_count > 0 THEN
8047: DELETE Ahl_Task_Links
8048: WHERE VISIT_TASK_ID = l_task_id
8049: OR PARENT_TASK_ID = l_task_id;
8050: END IF;
8051: CLOSE c_links;

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

10318: c_primary_rec c_primary%ROWTYPE;
10319:
10320: -- To find any task links for a deleted task
10321: CURSOR c_links (x_id IN NUMBER) IS
10322: SELECT COUNT(*) FROM Ahl_Task_Links L ,Ahl_Visit_Tasks_B T
10323: WHERE (T.VISIT_TASK_ID = L.VISIT_TASK_ID OR T.VISIT_TASK_ID = L.PARENT_TASK_ID)
10324: AND T.VISIT_TASK_ID = x_id;
10325:
10326: -- To find if WIP job is created for the Visit