APPS.AHL_VWP_VISITS_PVT dependencies on AHL_TASK_LINKS

Line 2356: FROM AHL_TASK_LINKS

2352: ATTRIBUTE12,
2353: ATTRIBUTE13,
2354: ATTRIBUTE14,
2355: ATTRIBUTE15
2356: FROM AHL_TASK_LINKS
2357: WHERE visit_task_id in ( SELECT VISIT_TASK_ID
2358: FROM AHL_VISIT_TASKS_B
2359: WHERE visit_id = x_visit_id);
2360:

Line 2642: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before inserting into AHL_TASK_LINKS');

2638: FETCH c_new_task_ID INTO l_new_parent_task_id;
2639: CLOSE c_new_task_ID;
2640:
2641: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2642: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before inserting into AHL_TASK_LINKS');
2643: END IF;
2644:
2645: -- Create task link
2646: INSERT INTO AHL_TASK_LINKS

Line 2646: INSERT INTO AHL_TASK_LINKS

2642: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before inserting into AHL_TASK_LINKS');
2643: END IF;
2644:
2645: -- Create task link
2646: INSERT INTO AHL_TASK_LINKS
2647: ( TASK_LINK_ID,
2648: OBJECT_VERSION_NUMBER,
2649: LAST_UPDATE_DATE,
2650: LAST_UPDATED_BY,

Line 2676: ahl_task_links_s.nextval,

2672: ATTRIBUTE15
2673: )
2674: VALUES
2675: (
2676: ahl_task_links_s.nextval,
2677: 1,
2678: SYSDATE,
2679: Fnd_Global.USER_ID,
2680: SYSDATE,

Line 2705: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After inserting into AHL_TASK_LINKS');

2701: l_task_link_rec.ATTRIBUTE15
2702: );
2703:
2704: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2705: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After inserting into AHL_TASK_LINKS');
2706: END IF;
2707:
2708: END LOOP;
2709: CLOSE c_visit_task_links;

Line 3914: AHL_TASK_LINKS

3910:
3911:
3912: -- Remove task links of the deleted task
3913: DELETE
3914: AHL_TASK_LINKS
3915: WHERE
3916: VISIT_TASK_ID = p_Visit_Task_Id
3917: OR
3918: PARENT_TASK_ID = p_Visit_Task_Id;