APPS.AHL_VWP_TASKS_LINKS_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 24

                IF p_x_task_link_tbl(i).LAST_UPDATE_DATE=FND_API.G_MISS_DATE
                THEN
                p_x_task_link_tbl(i).LAST_UPDATE_DATE:=NULL;

Line: 28

                IF p_x_task_link_tbl(i).LAST_UPDATED_BY= FND_API.G_MISS_NUM
                THEN
                p_x_task_link_tbl(i).LAST_UPDATED_BY:=NULL;

Line: 40

                IF p_x_task_link_tbl(i).LAST_UPDATE_LOGIN= FND_API.G_MISS_NUM
                THEN
                p_x_task_link_tbl(i).LAST_UPDATE_LOGIN:=NULL;

Line: 149

  select count(*)
  from  AHL_TASK_LINKS
  where VISIT_TASK_ID=C_VISIT_TASK_ID
  and   PARENT_TASK_ID=C_PARENT_TASK_ID;

Line: 159

select stage_num from ahl_vwp_stages_b where stage_id = (SELECT  stage_id
FROM    ahl_visit_tasks_vl
WHERE   visit_task_id = p_child_task_id);

Line: 168

select stage_num from ahl_vwp_stages_b where stage_id = (SELECT  stage_id
FROM    ahl_visit_tasks_vl
WHERE   visit_task_id = p_parent_or_child_task_id);

Line: 178

SELECT status_code,
       confirm_failure_flag
FROM   ahl_workorders
WHERE  visit_task_id = p_visit_task_id;

Line: 186

select 'X'
FROM    ahl_visit_tasks_b
WHERE   visit_task_id = p_task_id
AND    status_code = 'RELEASED';

Line: 193

select 'X'
FROM    ahl_visit_tasks_b
WHERE   visit_task_id = p_task_id
AND    task_type_code = 'SUMMARY';

Line: 203

SELECT 'X'
FROM   ahl_task_links lin,
       ahl_visit_tasks_b vt
WHERE  lin.visit_task_id = vt.visit_task_id
AND    vt.status_code = 'RELEASED'
START WITH  lin.parent_task_id = p_parent_visit_task_id
CONNECT BY PRIOR lin.visit_task_id = lin.parent_task_id;

Line: 213

SELECT VISIT_TASK_NUMBER
FROM ahl_visit_tasks_b
where visit_task_id = p_task_id;

Line: 446

SELECT *
   FROM AHL_VISIT_TASKS_VL
   WHERE VISIT_TASK_NUMBER=C_PARENT_TASK_NUMBER
   AND SUMMARY_TASK_FLAG='N'
   AND VISIT_ID = (select visit_id
                   from AHL_VISIT_TASKS_B
                   where VISIT_TASK_ID = c_visit_task_id);

Line: 525

        SELECT COUNT(*) INTO l_counter
        FROM  AHL_TASK_LINKS A
        START WITH VISIT_TASK_ID=P_VISIT_TASK_ID
        CONNECT BY PRIOR VISIT_TASK_ID =PARENT_TASK_ID;

Line: 570

select VISIT_TASK_ID from AHL_VISIT_TASKS_B where visit_task_number = C_TASK_NUMBER and
visit_id = (select visit_id from ahl_visit_tasks_b where visit_task_id = C_TASK_ID );

Line: 642

                      INSERT INTO AHL_TASK_LINKS(
                      TASK_LINK_ID,
                      OBJECT_VERSION_NUMBER,
                      LAST_UPDATE_DATE,
                      LAST_UPDATED_BY,
                      CREATION_DATE,
                      CREATED_BY,
                      LAST_UPDATE_LOGIN,
                      VISIT_TASK_ID,
                      PARENT_TASK_ID,
                      ATTRIBUTE_CATEGORY,
                      ATTRIBUTE1,
                      ATTRIBUTE2,
                      ATTRIBUTE3,
                      ATTRIBUTE4,
                      ATTRIBUTE5,
                      ATTRIBUTE6,
                      ATTRIBUTE7,
                      ATTRIBUTE8,
                      ATTRIBUTE9,
                      ATTRIBUTE10,
                      ATTRIBUTE11,
                      ATTRIBUTE12,
                      ATTRIBUTE13,
                      ATTRIBUTE14,
                      ATTRIBUTE15)
                      values
                      (
                      ahl_task_links_s.nextval,
                      1,
                      sysdate,
                      fnd_global.user_id,
                      sysdate,
                      fnd_global.user_id,
                      fnd_global.user_id,
                      P_task_link_rec.VISIT_TASK_ID,
                      P_task_link_rec.PARENT_TASK_ID,
                      P_task_link_rec.ATTRIBUTE_CATEGORY,
                      P_task_link_rec.ATTRIBUTE1,
                      P_task_link_rec.ATTRIBUTE2,
                      P_task_link_rec.ATTRIBUTE3,
                      P_task_link_rec.ATTRIBUTE4,
                      P_task_link_rec.ATTRIBUTE5,
                      P_task_link_rec.ATTRIBUTE6,
                      P_task_link_rec.ATTRIBUTE7,
                      P_task_link_rec.ATTRIBUTE8,
                      P_task_link_rec.ATTRIBUTE9,
                      P_task_link_rec.ATTRIBUTE10,
                      P_task_link_rec.ATTRIBUTE11,
                      P_task_link_rec.ATTRIBUTE12,
                      P_task_link_rec.ATTRIBUTE13,
                      P_task_link_rec.ATTRIBUTE14,
                      P_task_link_rec.ATTRIBUTE15);

Line: 755

PROCEDURE DELETE_TASK_LINKS
 ( p_task_link_id              IN NUMBER,
   p_object_version_number     IN NUMBER)
as
--
cursor child_task_csr (p_task_link_id IN NUMBER) IS
SELECT  visit_task_id
FROM   ahl_task_links
WHERE  task_link_id = p_task_link_id;

Line: 776

	DELETE AHL_TASK_LINKS
        WHERE  TASK_LINK_ID=p_task_link_id
	AND OBJECT_VERSION_NUMBER=p_object_version_number;

Line: 817

END DELETE_TASK_LINKS;

Line: 836

 	SELECT STATUS_CODE
 	FROM AHL_VISIT_TASKS_B
 	WHERE VISIT_TASK_ID=p_task_id;

Line: 843

      SELECT Any_Task_Chg_Flag,visit_id FROM Ahl_Visits_VL
      WHERE  VISIT_ID = (
      			 SELECT visit_id FROM AHL_VISIT_TASKS_B
      			 WHERE visit_task_id = p_task_id
      			);

Line: 853

      SELECT visit_task_id FROM AHL_TASK_LINKS
      WHERE task_link_id = p_task_link_id;

Line: 1046

		DELETE_TASK_LINKS
		 (
		 p_task_link_id      => l_task_link_tbl(i).task_link_id,
		 p_object_version_number   => l_task_link_tbl(i).object_version_number
		 );

Line: 1052

/*		DELETE AHL_TASK_LINKS WHERE  TASK_LINK_ID=l_task_link_tbl(i).task_link_id
                AND OBJECT_VERSION_NUMBER=l_task_link_tbl(i).OBJECT_VERSION_NUMBER;

Line: 1109

			 AHL_VWP_RULES_PVT.update_visit_task_flag(
				 p_visit_id         =>l_visit_csr_rec.visit_id,
				 p_flag             =>'Y',
				 x_return_status    =>x_return_status);