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: 170

select link.parent_task_id from ahl_task_links link
start with link.visit_task_id = p_child_task_id
and link.parent_task_id = p_parent_task_id
connect by prior link.parent_task_id = link.visit_task_id;

Line: 178

select link.visit_task_id from ahl_task_links link
start with link.parent_task_id = p_parent_task_id
and link.visit_task_id = p_child_task_id
connect by prior link.visit_task_id = link.parent_task_id;

Line: 186

SELECT stage_id FROM ahl_visit_tasks_b
WHERE visit_task_id = p_task_id;

Line: 192

SELECT 'X' FROM ahl_stage_links
WHERE subject_id = p_child_stage_id
AND relation_type <> 'PARALLEL'
START WITH object_id = p_parent_stage_id
CONNECT BY PRIOR subject_id = object_id;

Line: 207

SELECT status_code,
       confirm_failure_flag
FROM   ahl_workorders
WHERE  visit_task_id = p_visit_task_id;

Line: 215

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

Line: 222

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

Line: 232

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: 242

SELECT VISIT_TASK_NUMBER
FROM ahl_visit_tasks_b
where visit_task_id = p_task_id;

Line: 473

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: 552

        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: 603

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: 609

select VISIT_TASK_ID from AHL_VISIT_TASKS_B
where  visit_task_id = C_TASK_ID;

Line: 667

                      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,
                      PRECEDENCE_CONSTRAINT)
                      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,
                      P_task_link_rec.HIERARCHY_INDICATOR);

Line: 797

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: 818

        DELETE AHL_TASK_LINKS
        WHERE  TASK_LINK_ID=p_task_link_id
        AND OBJECT_VERSION_NUMBER=p_object_version_number;

Line: 859

END DELETE_TASK_LINKS;

Line: 878

        SELECT STATUS_CODE
        FROM AHL_VISIT_TASKS_B
        WHERE VISIT_TASK_ID=p_task_id;

Line: 885

      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: 895

      SELECT visit_task_id FROM AHL_TASK_LINKS
      WHERE task_link_id = p_task_link_id;

Line: 1088

                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: 1094

/*              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: 1151

                         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);