eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_VISIT_TASKS_PKG SQL Statements

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

Line: 5


procedure INTERNAL_INSERT_B_ROW (
  X_DEPARTMENT_ID in NUMBER,
  X_PRICE_LIST_ID in NUMBER,
  X_STATUS_CODE in VARCHAR2,
  X_ESTIMATED_PRICE in NUMBER,
  X_ACTUAL_PRICE in NUMBER,
  X_ACTUAL_COST in NUMBER,
  X_STAGE_ID in NUMBER,
  X_END_DATE_TIME in DATE,
  X_START_DATE_TIME in DATE,
  X_PAST_TASK_START_DATE in DATE,
  X_PAST_TASK_END_DATE in DATE,
  X_INVENTORY_ITEM_ID in NUMBER,
  X_INSTANCE_ID in NUMBER,
  X_PRIMARY_VISIT_TASK_ID in NUMBER,
  X_SUMMARY_TASK_FLAG in VARCHAR2,
  X_ORIGINATING_TASK_ID in NUMBER,
  X_VISIT_TASK_NUMBER in NUMBER,
  X_ITEM_ORGANIZATION_ID in NUMBER,
  X_SERVICE_REQUEST_ID in NUMBER,
  X_TASK_TYPE_CODE in VARCHAR2,
  -- AVIKUKUM :: FP:PIE ::15-OCT-2010 :: new SERVICE_TYPE_CODE attribute
  X_SERVICE_TYPE_CODE in VARCHAR2,
  -- SKPATHAK :: 02-MAY-2011 :: VWPE: ER:12424063  :: Added below two more parameters
  X_STAGE_TYPE_CODE IN VARCHAR2,
  X_RETURN_TO_SUPPLY_FLAG IN VARCHAR2,
  --VWPE :: tchimira :: 10-MAY -2011
  X_ORIGINATING_MR_HEADER_ID IN NUMBER,
  --MANESING::Component Maintenance Planning Project, 07-Aug-2011, added target quantity
  X_TARGET_QTY in NUMBER,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_ATTRIBUTE1 in VARCHAR2,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE3 in VARCHAR2,
  X_ATTRIBUTE4 in VARCHAR2,
  X_ATTRIBUTE5 in VARCHAR2,
  X_ATTRIBUTE6 in VARCHAR2,
  X_ATTRIBUTE7 in VARCHAR2,
  X_ATTRIBUTE8 in VARCHAR2,
  X_ATTRIBUTE9 in VARCHAR2,
  X_ATTRIBUTE10 in VARCHAR2,
  X_ATTRIBUTE11 in VARCHAR2,
  X_ATTRIBUTE12 in VARCHAR2,
  X_ATTRIBUTE13 in VARCHAR2,
  X_ATTRIBUTE14 in VARCHAR2,
  X_ATTRIBUTE15 in VARCHAR2,
  X_VISIT_TASK_ID in NUMBER,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_VISIT_ID in NUMBER,
  X_PROJECT_TASK_ID in NUMBER,
  X_COST_PARENT_ID in NUMBER,
  X_MR_ROUTE_ID in NUMBER,
  X_MR_ID in NUMBER,
  X_DURATION in NUMBER,
  X_UNIT_EFFECTIVITY_ID in NUMBER,
  X_START_FROM_HOUR in NUMBER,
  X_QUANTITY in NUMBER,
  X_CREATION_DATE in DATE,
  X_CREATED_BY in NUMBER,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER,
  X_REPAIR_BATCH_NAME in VARCHAR2 := NULL --PRAKKUM :: 11/06/2012 :: Bug 14068468
) is
l_count NUMBER;

Line: 79


  insert into AHL_VISIT_TASKS_B (
    DEPARTMENT_ID,
    PRICE_LIST_ID,
    STATUS_CODE,
    ESTIMATED_PRICE,
    ACTUAL_PRICE,
    ACTUAL_COST,
    STAGE_ID,
    END_DATE_TIME,
    START_DATE_TIME,
    PAST_TASK_START_DATE,
    PAST_TASK_END_DATE,
    INVENTORY_ITEM_ID,
    INSTANCE_ID,
    PRIMARY_VISIT_TASK_ID,
    SUMMARY_TASK_FLAG,
    ORIGINATING_TASK_ID,
    VISIT_TASK_NUMBER,
    ITEM_ORGANIZATION_ID,
    SERVICE_REQUEST_ID,
    TASK_TYPE_CODE,
    -- AVIKUKUM :: FP:PIE ::15-OCT-2010 :: new SERVICE_TYPE_CODE attribute
    SERVICE_TYPE_CODE,
    -- SKPATHAK :: 02-MAY-2011 :: VWPE: ER:12424063  :: Added below two more parameters
    STAGE_TYPE_CODE,
    RETURN_TO_SUPPLY_FLAG,
    --VWPE :: tchimira :: 10-MAY -2011
    ORIGINATING_MR_HEADER_ID,
    --MANESING::Component Maintenance Planning Project, 07-Aug-2011, added target quantity
    TARGET_QTY,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15,
    VISIT_TASK_ID,
    OBJECT_VERSION_NUMBER,
    VISIT_ID,
    PROJECT_TASK_ID,
    COST_PARENT_ID,
    MR_ROUTE_ID,
    MR_ID,
    DURATION,
    UNIT_EFFECTIVITY_ID,
    START_FROM_HOUR,
    QUANTITY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    REPAIR_BATCH_NAME  --PRAKKUM :: 11/06/2012 :: Bug 14068468
  ) values (
    X_DEPARTMENT_ID,
    X_PRICE_LIST_ID,
    X_STATUS_CODE,
    X_ESTIMATED_PRICE,
    X_ACTUAL_PRICE,
    X_ACTUAL_COST,
    X_STAGE_ID,
    X_END_DATE_TIME,
    X_START_DATE_TIME,
    X_PAST_TASK_START_DATE,
    X_PAST_TASK_END_DATE,
    X_INVENTORY_ITEM_ID,
    X_INSTANCE_ID,
    X_PRIMARY_VISIT_TASK_ID,
    X_SUMMARY_TASK_FLAG,
    X_ORIGINATING_TASK_ID,
    l_visit_task_number,
    X_ITEM_ORGANIZATION_ID,
    X_SERVICE_REQUEST_ID,
    X_TASK_TYPE_CODE,
    -- AVIKUKUM :: FP:PIE ::15-OCT-2010 :: new SERVICE_TYPE_CODE attribute
    X_SERVICE_TYPE_CODE,
    -- SKPATHAK :: 02-MAY-2011 :: VWPE: ER:12424063  :: Added below two more parameters
    X_STAGE_TYPE_CODE,
    X_RETURN_TO_SUPPLY_FLAG,
    --VWPE :: tchimira :: 10-MAY -2011
    X_ORIGINATING_MR_HEADER_ID,
    --MANESING::Component Maintenance Planning Project, 07-Aug-2011, added target quantity
    X_TARGET_QTY,
    X_ATTRIBUTE_CATEGORY,
    X_ATTRIBUTE1,
    X_ATTRIBUTE2,
    X_ATTRIBUTE3,
    X_ATTRIBUTE4,
    X_ATTRIBUTE5,
    X_ATTRIBUTE6,
    X_ATTRIBUTE7,
    X_ATTRIBUTE8,
    X_ATTRIBUTE9,
    X_ATTRIBUTE10,
    X_ATTRIBUTE11,
    X_ATTRIBUTE12,
    X_ATTRIBUTE13,
    X_ATTRIBUTE14,
    X_ATTRIBUTE15,
    X_VISIT_TASK_ID,
    X_OBJECT_VERSION_NUMBER,
    X_VISIT_ID,
    X_PROJECT_TASK_ID,
    X_COST_PARENT_ID,
    X_MR_ROUTE_ID,
    X_MR_ID,
    X_DURATION,
    X_UNIT_EFFECTIVITY_ID,
    X_START_FROM_HOUR,
    X_QUANTITY,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_REPAIR_BATCH_NAME   --PRAKKUM :: 11/06/2012 :: Bug 14068468
  );

Line: 218


        select MAX(visit_task_number) + 1 INTO l_visit_task_number FROM Ahl_Visit_Tasks_B;

Line: 222


END INTERNAL_INSERT_B_ROW;

Line: 225


procedure INSERT_ROW (
  X_ROWID in out nocopy VARCHAR2,
  X_VISIT_TASK_ID in NUMBER,
  X_DEPARTMENT_ID in NUMBER,
  X_PRICE_LIST_ID in NUMBER,
  X_STATUS_CODE in VARCHAR2,
  X_ESTIMATED_PRICE in NUMBER,
  X_ACTUAL_PRICE in NUMBER,
  X_ACTUAL_COST in NUMBER,
  X_STAGE_ID in NUMBER,
  X_END_DATE_TIME in DATE,
  X_START_DATE_TIME in DATE,
  --SKPATHAK :: ER: 9147951 :: 11-JAN-2010 :: Add past dates too
  X_PAST_TASK_START_DATE in DATE,
  X_PAST_TASK_END_DATE in DATE,
  X_INVENTORY_ITEM_ID in NUMBER,
  X_INSTANCE_ID in NUMBER,
  X_PRIMARY_VISIT_TASK_ID in NUMBER,
  X_SUMMARY_TASK_FLAG in VARCHAR2,
  X_ORIGINATING_TASK_ID in NUMBER,
  X_VISIT_TASK_NUMBER in NUMBER,
  X_ITEM_ORGANIZATION_ID in NUMBER,
  X_SERVICE_REQUEST_ID in NUMBER,
  X_TASK_TYPE_CODE in VARCHAR2,
  -- AVIKUKUM :: FP:PIE ::15-OCT-2010 :: new SERVICE_TYPE_CODE attribute
  X_SERVICE_TYPE_CODE in VARCHAR2,
  -- SKPATHAK :: 02-MAY-2011 :: VWPE: ER:12424063  :: Added below two more parameters
  X_STAGE_TYPE_CODE IN VARCHAR2 := null,
  X_RETURN_TO_SUPPLY_FLAG IN VARCHAR2 := 'N',
  --VWPE :: tchimira :: 10-MAY -2011
  X_ORIGINATING_MR_HEADER_ID IN NUMBER := NULL,
  --MANESING::Component Maintenance Planning Project, 07-Aug-2011, added target quantity
  X_TARGET_QTY in NUMBER := null,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_ATTRIBUTE1 in VARCHAR2,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE3 in VARCHAR2,
  X_ATTRIBUTE4 in VARCHAR2,
  X_ATTRIBUTE5 in VARCHAR2,
  X_ATTRIBUTE6 in VARCHAR2,
  X_ATTRIBUTE7 in VARCHAR2,
  X_ATTRIBUTE8 in VARCHAR2,
  X_ATTRIBUTE9 in VARCHAR2,
  X_ATTRIBUTE10 in VARCHAR2,
  X_ATTRIBUTE11 in VARCHAR2,
  X_ATTRIBUTE12 in VARCHAR2,
  X_ATTRIBUTE13 in VARCHAR2,
  X_ATTRIBUTE14 in VARCHAR2,
  X_ATTRIBUTE15 in VARCHAR2,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_VISIT_ID in NUMBER,
  X_PROJECT_TASK_ID in NUMBER,
  X_COST_PARENT_ID in NUMBER,
  X_MR_ROUTE_ID in NUMBER,
  X_MR_ID in NUMBER,
  X_DURATION in NUMBER,
  X_UNIT_EFFECTIVITY_ID in NUMBER,
  X_START_FROM_HOUR in NUMBER,
  X_VISIT_TASK_NAME in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_QUANTITY in NUMBER, -- Added by rnahata for Issue 105
  X_CREATION_DATE in DATE,
  X_CREATED_BY in NUMBER,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER,
  X_REPAIR_BATCH_NAME in VARCHAR2 := NULL --PRAKKUM :: 11/06/2012 :: Bug 14068468
) is
  cursor C is select ROWID from AHL_VISIT_TASKS_B
    where VISIT_TASK_ID = X_VISIT_TASK_ID
    ;

Line: 299


  INTERNAL_INSERT_B_ROW (
    X_DEPARTMENT_ID,
    X_PRICE_LIST_ID,
    X_STATUS_CODE,
    X_ESTIMATED_PRICE,
    X_ACTUAL_PRICE,
    X_ACTUAL_COST,
    X_STAGE_ID,
    X_END_DATE_TIME,
    X_START_DATE_TIME,
    --SKPATHAK :: ER: 9147951 :: 11-JAN-2010 :: Add past dates too
    X_PAST_TASK_START_DATE,
    X_PAST_TASK_END_DATE,
    X_INVENTORY_ITEM_ID,
    X_INSTANCE_ID,
    X_PRIMARY_VISIT_TASK_ID,
    X_SUMMARY_TASK_FLAG,
    X_ORIGINATING_TASK_ID,
    X_VISIT_TASK_NUMBER,
    X_ITEM_ORGANIZATION_ID,
    X_SERVICE_REQUEST_ID,
    X_TASK_TYPE_CODE,
    -- AVIKUKUM :: FP:PIE ::15-OCT-2010 :: new SERVICE_TYPE_CODE attribute
    X_SERVICE_TYPE_CODE,
    -- SKPATHAK :: 02-MAY-2011 :: VWPE: ER:12424063  :: Added below two more parameters
    X_STAGE_TYPE_CODE,
    X_RETURN_TO_SUPPLY_FLAG,
    --VWPE :: tchimira :: 10-MAY -2011
    X_ORIGINATING_MR_HEADER_ID,
    --MANESING::Component Maintenance Planning Project, 07-Aug-2011, added target quantity
    X_TARGET_QTY,
    X_ATTRIBUTE_CATEGORY,
    X_ATTRIBUTE1,
    X_ATTRIBUTE2,
    X_ATTRIBUTE3,
    X_ATTRIBUTE4,
    X_ATTRIBUTE5,
    X_ATTRIBUTE6,
    X_ATTRIBUTE7,
    X_ATTRIBUTE8,
    X_ATTRIBUTE9,
    X_ATTRIBUTE10,
    X_ATTRIBUTE11,
    X_ATTRIBUTE12,
    X_ATTRIBUTE13,
    X_ATTRIBUTE14,
    X_ATTRIBUTE15,
    X_VISIT_TASK_ID,
    X_OBJECT_VERSION_NUMBER,
    X_VISIT_ID,
    X_PROJECT_TASK_ID,
    X_COST_PARENT_ID,
    X_MR_ROUTE_ID,
    X_MR_ID,
    X_DURATION,
    X_UNIT_EFFECTIVITY_ID,
    X_START_FROM_HOUR,
    X_QUANTITY, -- Added by rnahata for Issue 105
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_REPAIR_BATCH_NAME --PRAKKUM :: 11/06/2012 :: Bug 14068468
  );

Line: 365


  insert into AHL_VISIT_TASKS_TL (
    VISIT_TASK_ID,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_LOGIN,
    DESCRIPTION,
    VISIT_TASK_NAME,
    LANGUAGE,
    SOURCE_LANG
  ) select
    X_VISIT_TASK_ID,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_DESCRIPTION,
    X_VISIT_TASK_NAME,
    L.LANGUAGE_CODE,
    userenv('LANG')
  from FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and not exists
    (select NULL
    from AHL_VISIT_TASKS_TL T
    where T.VISIT_TASK_ID = X_VISIT_TASK_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 403


end INSERT_ROW;

Line: 461


  cursor c is select
      DEPARTMENT_ID,
      PRICE_LIST_ID,
      STATUS_CODE,
      ESTIMATED_PRICE,
      ACTUAL_PRICE,
      ACTUAL_COST,
      STAGE_ID,
      END_DATE_TIME,
      START_DATE_TIME,
      --SKPATHAK :: ER: 9147951 :: 11-JAN-2010 :: Add past dates too
      PAST_TASK_START_DATE,
      PAST_TASK_END_DATE,
      INVENTORY_ITEM_ID,
      INSTANCE_ID,
      PRIMARY_VISIT_TASK_ID,
      SUMMARY_TASK_FLAG,
      ORIGINATING_TASK_ID,
      VISIT_TASK_NUMBER,
      ITEM_ORGANIZATION_ID,
      SERVICE_REQUEST_ID,
      TASK_TYPE_CODE,
      -- AVIKUKUM :: FP:PIE ::15-OCT-2010 :: new SERVICE_TYPE_CODE attribute
      SERVICE_TYPE_CODE,
      --MANESING::Component Maintenance Planning Project, 07-Aug-2011, added target quantity
      TARGET_QTY,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      OBJECT_VERSION_NUMBER,
      VISIT_ID,
      PROJECT_TASK_ID,
      COST_PARENT_ID,
      MR_ROUTE_ID,
      MR_ID,
      DURATION,
      UNIT_EFFECTIVITY_ID,
      START_FROM_HOUR
    from AHL_VISIT_TASKS_B
    where VISIT_TASK_ID = X_VISIT_TASK_ID
    for update of VISIT_TASK_ID nowait;

Line: 517


  cursor c1 is select
      VISIT_TASK_NAME,
      DESCRIPTION,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from AHL_VISIT_TASKS_TL
    where VISIT_TASK_ID = X_VISIT_TASK_ID
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of VISIT_TASK_ID nowait;

Line: 530


    fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 649


procedure UPDATE_ROW (
  X_VISIT_TASK_ID in NUMBER,
  X_DEPARTMENT_ID in NUMBER,
  X_PRICE_LIST_ID in NUMBER,
  X_STATUS_CODE in VARCHAR2,
  X_ESTIMATED_PRICE in NUMBER,
  X_ACTUAL_PRICE in NUMBER,
  X_ACTUAL_COST in NUMBER,
  X_STAGE_ID in NUMBER,
  X_END_DATE_TIME in DATE,
  X_START_DATE_TIME in DATE,
  --SKPATHAK :: ER: 9147951 :: 11-JAN-2010 :: Add past dates too
  X_PAST_TASK_START_DATE in DATE,
  X_PAST_TASK_END_DATE in DATE,
  X_INVENTORY_ITEM_ID in NUMBER,
  X_INSTANCE_ID in NUMBER,
  X_PRIMARY_VISIT_TASK_ID in NUMBER,
  X_SUMMARY_TASK_FLAG in VARCHAR2,
  X_ORIGINATING_TASK_ID in NUMBER,
  X_VISIT_TASK_NUMBER in NUMBER,
  X_ITEM_ORGANIZATION_ID in NUMBER,
  X_SERVICE_REQUEST_ID in NUMBER,
  X_TASK_TYPE_CODE in VARCHAR2,
  -- AVIKUKUM :: FP:PIE ::15-OCT-2010 :: new SERVICE_TYPE_CODE attribute
  X_SERVICE_TYPE_CODE in VARCHAR2,
  --MANESING::Component Maintenance Planning Project, 07-Aug-2011, added target quantity
  X_TARGET_QTY in NUMBER,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_ATTRIBUTE1 in VARCHAR2,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE3 in VARCHAR2,
  X_ATTRIBUTE4 in VARCHAR2,
  X_ATTRIBUTE5 in VARCHAR2,
  X_ATTRIBUTE6 in VARCHAR2,
  X_ATTRIBUTE7 in VARCHAR2,
  X_ATTRIBUTE8 in VARCHAR2,
  X_ATTRIBUTE9 in VARCHAR2,
  X_ATTRIBUTE10 in VARCHAR2,
  X_ATTRIBUTE11 in VARCHAR2,
  X_ATTRIBUTE12 in VARCHAR2,
  X_ATTRIBUTE13 in VARCHAR2,
  X_ATTRIBUTE14 in VARCHAR2,
  X_ATTRIBUTE15 in VARCHAR2,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_VISIT_ID in NUMBER,
  X_PROJECT_TASK_ID in NUMBER,
  X_COST_PARENT_ID in NUMBER,
  X_MR_ROUTE_ID in NUMBER,
  X_MR_ID in NUMBER,
  X_DURATION in NUMBER,
  X_UNIT_EFFECTIVITY_ID in NUMBER,
  X_START_FROM_HOUR in NUMBER,
  X_VISIT_TASK_NAME in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_QUANTITY  in NUMBER, -- Added by rnahata for Issue 105
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update AHL_VISIT_TASKS_B set
    DEPARTMENT_ID = X_DEPARTMENT_ID,
    PRICE_LIST_ID = X_PRICE_LIST_ID,
    STATUS_CODE = X_STATUS_CODE,
    ESTIMATED_PRICE = X_ESTIMATED_PRICE,
    ACTUAL_PRICE = X_ACTUAL_PRICE,
    ACTUAL_COST = X_ACTUAL_COST,
    STAGE_ID = X_STAGE_ID,
    END_DATE_TIME = X_END_DATE_TIME,
    START_DATE_TIME = X_START_DATE_TIME,
    --SKPATHAK :: ER: 9147951 :: 11-JAN-2010 :: Add past dates too
    PAST_TASK_START_DATE = X_PAST_TASK_START_DATE,
    PAST_TASK_END_DATE = X_PAST_TASK_END_DATE,
    INVENTORY_ITEM_ID = X_INVENTORY_ITEM_ID,
    INSTANCE_ID = X_INSTANCE_ID,
    PRIMARY_VISIT_TASK_ID = X_PRIMARY_VISIT_TASK_ID,
    SUMMARY_TASK_FLAG = X_SUMMARY_TASK_FLAG,
    ORIGINATING_TASK_ID = X_ORIGINATING_TASK_ID,
    VISIT_TASK_NUMBER = X_VISIT_TASK_NUMBER,
    ITEM_ORGANIZATION_ID = X_ITEM_ORGANIZATION_ID,
    SERVICE_REQUEST_ID = X_SERVICE_REQUEST_ID,
    TASK_TYPE_CODE = X_TASK_TYPE_CODE,
    -- AVIKUKUM :: FP:PIE ::15-OCT-2010 :: new SERVICE_TYPE_CODE attribute
    SERVICE_TYPE_CODE = X_SERVICE_TYPE_CODE,
    --MANESING::Component Maintenance Planning Project, 07-Aug-2011, added target quantity
    TARGET_QTY = X_TARGET_QTY,
    ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
    ATTRIBUTE1 = X_ATTRIBUTE1,
    ATTRIBUTE2 = X_ATTRIBUTE2,
    ATTRIBUTE3 = X_ATTRIBUTE3,
    ATTRIBUTE4 = X_ATTRIBUTE4,
    ATTRIBUTE5 = X_ATTRIBUTE5,
    ATTRIBUTE6 = X_ATTRIBUTE6,
    ATTRIBUTE7 = X_ATTRIBUTE7,
    ATTRIBUTE8 = X_ATTRIBUTE8,
    ATTRIBUTE9 = X_ATTRIBUTE9,
    ATTRIBUTE10 = X_ATTRIBUTE10,
    ATTRIBUTE11 = X_ATTRIBUTE11,
    ATTRIBUTE12 = X_ATTRIBUTE12,
    ATTRIBUTE13 = X_ATTRIBUTE13,
    ATTRIBUTE14 = X_ATTRIBUTE14,
    ATTRIBUTE15 = X_ATTRIBUTE15,
    OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
    VISIT_ID = X_VISIT_ID,
    PROJECT_TASK_ID = X_PROJECT_TASK_ID,
    COST_PARENT_ID = X_COST_PARENT_ID,
    MR_ROUTE_ID = X_MR_ROUTE_ID,
    MR_ID = X_MR_ID,
    DURATION = X_DURATION,
    UNIT_EFFECTIVITY_ID = X_UNIT_EFFECTIVITY_ID,
    START_FROM_HOUR = X_START_FROM_HOUR,
    QUANTITY = X_QUANTITY, -- Added by rnahata for Issue 105
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where VISIT_TASK_ID = X_VISIT_TASK_ID;

Line: 770


  update AHL_VISIT_TASKS_TL set
    VISIT_TASK_NAME = X_VISIT_TASK_NAME,
    DESCRIPTION = X_DESCRIPTION,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    SOURCE_LANG = userenv('LANG')
  where VISIT_TASK_ID = X_VISIT_TASK_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 783


end UPDATE_ROW;

Line: 785


procedure DELETE_ROW (
  X_VISIT_TASK_ID in NUMBER
) is
begin
  delete from AHL_VISIT_TASKS_TL
  where VISIT_TASK_ID = X_VISIT_TASK_ID;

Line: 796


  delete from AHL_VISIT_TASKS_B
  where VISIT_TASK_ID = X_VISIT_TASK_ID;

Line: 802


end DELETE_ROW;

Line: 807


  delete from AHL_VISIT_TASKS_TL T
  where not exists
    (select NULL
    from AHL_VISIT_TASKS_B B
    where B.VISIT_TASK_ID = T.VISIT_TASK_ID
    );

Line: 814


  update AHL_VISIT_TASKS_TL T set (
      VISIT_TASK_NAME,
      DESCRIPTION
    ) = (select
      B.VISIT_TASK_NAME,
      B.DESCRIPTION
    from AHL_VISIT_TASKS_TL B
    where B.VISIT_TASK_ID = T.VISIT_TASK_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.VISIT_TASK_ID,
      T.LANGUAGE
  ) in (select
      SUBT.VISIT_TASK_ID,
      SUBT.LANGUAGE
    from AHL_VISIT_TASKS_TL SUBB, AHL_VISIT_TASKS_TL SUBT
    where SUBB.VISIT_TASK_ID = SUBT.VISIT_TASK_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.VISIT_TASK_NAME <> SUBT.VISIT_TASK_NAME
      or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
      or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
      or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
  ));

Line: 838


  insert into AHL_VISIT_TASKS_TL (
    VISIT_TASK_ID,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_LOGIN,
    DESCRIPTION,
    VISIT_TASK_NAME,
    LANGUAGE,
    SOURCE_LANG
  ) select /*+ ORDERED */
    B.VISIT_TASK_ID,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATED_BY,
    B.CREATION_DATE,
    B.CREATED_BY,
    B.LAST_UPDATE_LOGIN,
    B.DESCRIPTION,
    B.VISIT_TASK_NAME,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from AHL_VISIT_TASKS_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from AHL_VISIT_TASKS_TL T
    where T.VISIT_TASK_ID = B.VISIT_TASK_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);