APPS.AHL_VWP_TASKS_LINKS_PVT dependencies on AHL_TASK_LINKS

Line 150: from AHL_TASK_LINKS

146:
147: CURSOR CHECK_UNIQ(C_PARENT_TASK_ID NUMBER,C_visit_Task_id NUMBER)
148: IS
149: select count(*)
150: from AHL_TASK_LINKS
151: where VISIT_TASK_ID=C_VISIT_TASK_ID
152: and PARENT_TASK_ID=C_PARENT_TASK_ID;
153:
154: -- Changes done for Post 11.5.10 by senthil.

Line 204: FROM ahl_task_links lin,

200: -- Commented by amagrawa as user can associate only task in planning status to task hierarchy
201: /*CURSOR c_children_check_status(p_parent_visit_task_id IN NUMBER)
202: IS
203: SELECT 'X'
204: FROM ahl_task_links lin,
205: ahl_visit_tasks_b vt
206: WHERE lin.visit_task_id = vt.visit_task_id
207: AND vt.status_code = 'RELEASED'
208: START WITH lin.parent_task_id = p_parent_visit_task_id

Line 526: FROM AHL_TASK_LINKS A

522: BEGIN
523: x_return_status:=FND_API.G_RET_STS_SUCCESS;
524:
525: SELECT COUNT(*) INTO l_counter
526: FROM AHL_TASK_LINKS A
527: START WITH VISIT_TASK_ID=P_VISIT_TASK_ID
528: CONNECT BY PRIOR VISIT_TASK_ID =PARENT_TASK_ID;
529: EXCEPTION
530: WHEN l_cyclic_loop THEN

Line 583: -- Select ahl_task_links_s.nextval into l_task_link_id from dual;

579: l_visit_task_id NUMBER;
580:
581: BEGIN
582:
583: -- Select ahl_task_links_s.nextval into l_task_link_id from dual;
584: -- Validate the values entered by the user
585:
586: IF(P_task_link_rec.visit_task_number is NULL or length(trim(P_task_link_rec.visit_task_number)) = 0 )
587: THEN

Line 642: INSERT INTO AHL_TASK_LINKS(

638: P_task_link_rec.VISIT_TASK_ID:=P_task_link_rec.PARENT_TASK_ID;
639: P_task_link_rec.PARENT_TASK_ID:=l_flip_vtid;
640: END IF;
641:
642: INSERT INTO AHL_TASK_LINKS(
643: TASK_LINK_ID,
644: OBJECT_VERSION_NUMBER,
645: LAST_UPDATE_DATE,
646: LAST_UPDATED_BY,

Line 670: ahl_task_links_s.nextval,

666: ATTRIBUTE14,
667: ATTRIBUTE15)
668: values
669: (
670: ahl_task_links_s.nextval,
671: 1,
672: sysdate,
673: fnd_global.user_id,
674: sysdate,

Line 762: FROM ahl_task_links

758: as
759: --
760: cursor child_task_csr (p_task_link_id IN NUMBER) IS
761: SELECT visit_task_id
762: FROM ahl_task_links
763: WHERE task_link_id = p_task_link_id;
764: --
765: l_return_Status VARCHAR2(1);
766: l_msg_count NUMBER;

Line 776: DELETE AHL_TASK_LINKS

772: OPEN child_task_csr(p_task_link_id);
773: FETCH child_task_csr INTO l_child_task_id;
774: CLOSE child_task_csr;
775:
776: DELETE AHL_TASK_LINKS
777: WHERE TASK_LINK_ID=p_task_link_id
778: AND OBJECT_VERSION_NUMBER=p_object_version_number;
779: IF SQL%ROWCOUNT=0
780: THEN

Line 853: SELECT visit_task_id FROM AHL_TASK_LINKS

849: l_visit_csr_rec c_Visit%ROWTYPE;
850:
851: -- Cursor to find visit_task_id from task_link_id
852: CURSOR c_task_link (p_task_link_id IN NUMBER) IS
853: SELECT visit_task_id FROM AHL_TASK_LINKS
854: WHERE task_link_id = p_task_link_id;
855:
856:
857: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_TASK_LINKS';

Line 1052: /* DELETE AHL_TASK_LINKS WHERE TASK_LINK_ID=l_task_link_tbl(i).task_link_id

1048: p_task_link_id => l_task_link_tbl(i).task_link_id,
1049: p_object_version_number => l_task_link_tbl(i).object_version_number
1050: );
1051:
1052: /* DELETE AHL_TASK_LINKS WHERE TASK_LINK_ID=l_task_link_tbl(i).task_link_id
1053: AND OBJECT_VERSION_NUMBER=l_task_link_tbl(i).OBJECT_VERSION_NUMBER;
1054: IF SQL%ROWCOUNT=0
1055: THEN
1056: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');