APPS.AHL_VWP_VISITS_PVT dependencies on AHL_TASK_LINKS

Line 2901: FROM AHL_TASK_LINKS

2897: ATTRIBUTE12,
2898: ATTRIBUTE13,
2899: ATTRIBUTE14,
2900: ATTRIBUTE15
2901: FROM AHL_TASK_LINKS
2902: WHERE visit_task_id in ( SELECT VISIT_TASK_ID
2903: FROM AHL_VISIT_TASKS_B
2904: WHERE visit_id = x_visit_id);
2905:

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

3204: FETCH c_new_task_ID INTO l_new_parent_task_id;
3205: CLOSE c_new_task_ID;
3206:
3207: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3208: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before inserting into AHL_TASK_LINKS');
3209: END IF;
3210:
3211: -- Create task link
3212: INSERT INTO AHL_TASK_LINKS

Line 3212: INSERT INTO AHL_TASK_LINKS

3208: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before inserting into AHL_TASK_LINKS');
3209: END IF;
3210:
3211: -- Create task link
3212: INSERT INTO AHL_TASK_LINKS
3213: ( TASK_LINK_ID,
3214: OBJECT_VERSION_NUMBER,
3215: LAST_UPDATE_DATE,
3216: LAST_UPDATED_BY,

Line 3242: ahl_task_links_s.nextval,

3238: ATTRIBUTE15
3239: )
3240: VALUES
3241: (
3242: ahl_task_links_s.nextval,
3243: 1,
3244: SYSDATE,
3245: Fnd_Global.USER_ID,
3246: SYSDATE,

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

3267: l_task_link_rec.ATTRIBUTE15
3268: );
3269:
3270: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3271: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After inserting into AHL_TASK_LINKS');
3272: END IF;
3273:
3274: END LOOP;
3275: CLOSE c_visit_task_links;

Line 5155: AHL_TASK_LINKS

5151:
5152:
5153: -- Remove task links of the deleted task
5154: DELETE
5155: AHL_TASK_LINKS
5156: WHERE
5157: VISIT_TASK_ID = p_Visit_Task_Id
5158: OR
5159: PARENT_TASK_ID = p_Visit_Task_Id;