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_VISITS_PKG SQL Statements

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

Line: 5


procedure INTERNAL_INSERT_B_ROW (
  X_ESTIMATED_PRICE in NUMBER,
  X_PRIORITY_CODE in VARCHAR2,
  X_PROJECT_TEMPLATE_ID in NUMBER,
  X_UNIT_SCHEDULE_ID in NUMBER,
  X_ACTUAL_PRICE in NUMBER,
  X_OUTSIDE_PARTY_FLAG in VARCHAR2,
  X_ANY_TASK_CHG_FLAG in VARCHAR2,
  X_PRICE_LIST_ID in NUMBER,
  X_CLOSE_DATE_TIME in DATE,
  X_SCHEDULE_DESIGNATOR in VARCHAR2,
  X_SERVICE_REQUEST_ID in NUMBER,
  X_SPACE_CATEGORY_CODE in VARCHAR2,
  X_VISIT_ID in NUMBER,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_ORGANIZATION_ID in NUMBER,
  X_DEPARTMENT_ID in NUMBER,
  X_STATUS_CODE in VARCHAR2,
  X_START_DATE_TIME in DATE,
  X_VISIT_TYPE_CODE in VARCHAR2,
  X_SIMULATION_PLAN_ID in NUMBER,
  X_ITEM_INSTANCE_ID in NUMBER,
  X_INVENTORY_ITEM_ID in NUMBER,
  X_ASSO_PRIMARY_VISIT_ID in NUMBER,
  X_SIMULATION_DELETE_FLAG in VARCHAR2,
  X_TEMPLATE_FLAG in VARCHAR2,
  X_OUT_OF_SYNC_FLAG in VARCHAR2,
  X_PROJECT_FLAG in VARCHAR2,
  X_PROJECT_ID in NUMBER,
  X_VISIT_NUMBER in NUMBER,
  X_ITEM_ORGANIZATION_ID 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_INV_LOCATOR_ID in NUMBER,  --Added by sowsubra
  X_COMP_PLANNING_LOC_ID in NUMBER,
  X_COMP_INREPAIR_LOC_ID 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_TOP_PROJECT_TASK_ID in NUMBER,   -- AVIKUKUM :: PIE :: 20-OCT-2010
  X_PAST_DATED_VISIT_FLAG in VARCHAR2, -- PRAKKUM :: VWPE :: ER 12424063 :: 01-FEB-2011
  X_FIRMED_FLAG in VARCHAR2, -- PRAKKUM :: VWPE :: ER 12424063 :: 01-FEB-2011
  X_LOCKED_FLAG in VARCHAR2, -- PRAKKUM :: VWPE :: ER 12424063 :: 01-FEB-2011
  X_AUTO_VISIT_TYPE_FLAG IN VARCHAR2 := null -- added by tchimira for ER 14015560
) is
-- SKPATHAK :: Bug #9171735 :: 20-OCT-2010
-- Added three local variables
l_count NUMBER;

Line: 79


      insert into AHL_VISITS_B (
        ESTIMATED_PRICE,
        PRIORITY_CODE,
        PROJECT_TEMPLATE_ID,
        UNIT_SCHEDULE_ID,
        ACTUAL_PRICE,
        OUTSIDE_PARTY_FLAG,
        ANY_TASK_CHG_FLAG,
        PRICE_LIST_ID,
        CLOSE_DATE_TIME,
        SCHEDULE_DESIGNATOR,
        SERVICE_REQUEST_ID,
        SPACE_CATEGORY_CODE,
        VISIT_ID,
        OBJECT_VERSION_NUMBER,
        ORGANIZATION_ID,
        DEPARTMENT_ID,
        STATUS_CODE,
        START_DATE_TIME,
        VISIT_TYPE_CODE,
        SIMULATION_PLAN_ID,
        ITEM_INSTANCE_ID,
        INVENTORY_ITEM_ID,
        ASSO_PRIMARY_VISIT_ID,
        SIMULATION_DELETE_FLAG,
        TEMPLATE_FLAG,
        OUT_OF_SYNC_FLAG,
        PROJECT_FLAG,
        PROJECT_ID,
        VISIT_NUMBER,
        ITEM_ORGANIZATION_ID,
        INV_LOCATOR_ID,  --Added by sowsubra
        COMP_PLANNING_LOC_ID,
        COMP_INREPAIR_LOC_ID,
        ATTRIBUTE_CATEGORY,
        ATTRIBUTE1,
        ATTRIBUTE2,
        ATTRIBUTE3,
        ATTRIBUTE4,
        ATTRIBUTE5,
        ATTRIBUTE6,
        ATTRIBUTE7,
        ATTRIBUTE8,
        ATTRIBUTE9,
        ATTRIBUTE10,
        ATTRIBUTE11,
        ATTRIBUTE12,
        ATTRIBUTE13,
        ATTRIBUTE14,
        ATTRIBUTE15,
        CREATION_DATE,
        CREATED_BY,
        LAST_UPDATE_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_LOGIN,
        TOP_PROJECT_TASK_ID,    -- AVIKUKUM :: PIE :: 20-OCT-2010
        PAST_DATED_VISIT_FLAG, -- PRAKKUM :: VWPE :: ER 12424063 :: 01-FEB-2011
        FIRMED_FLAG, -- PRAKKUM :: VWPE :: ER 12424063 :: 01-FEB-2011
        LOCKED_FLAG, -- PRAKKUM :: VWPE :: ER 12424063 :: 01-FEB-2011
        AUTO_VISIT_TYPE_FLAG -- added by tchimira for ER 14015560
      ) values (
        X_ESTIMATED_PRICE,
        X_PRIORITY_CODE,
        X_PROJECT_TEMPLATE_ID,
        X_UNIT_SCHEDULE_ID,
        X_ACTUAL_PRICE,
        X_OUTSIDE_PARTY_FLAG,
        X_ANY_TASK_CHG_FLAG,
        X_PRICE_LIST_ID,
        X_CLOSE_DATE_TIME,
        X_SCHEDULE_DESIGNATOR,
        X_SERVICE_REQUEST_ID,
        X_SPACE_CATEGORY_CODE,
        X_VISIT_ID,
        X_OBJECT_VERSION_NUMBER,
        X_ORGANIZATION_ID,
        X_DEPARTMENT_ID,
        X_STATUS_CODE,
        X_START_DATE_TIME,
        X_VISIT_TYPE_CODE,
        X_SIMULATION_PLAN_ID,
        X_ITEM_INSTANCE_ID,
        X_INVENTORY_ITEM_ID,
        X_ASSO_PRIMARY_VISIT_ID,
        X_SIMULATION_DELETE_FLAG,
        X_TEMPLATE_FLAG,
        X_OUT_OF_SYNC_FLAG,
        X_PROJECT_FLAG,
        X_PROJECT_ID,
        L_VISIT_NUMBER,  --Changed for bug #9171735 by skpathak
        X_ITEM_ORGANIZATION_ID,
        X_INV_LOCATOR_ID, --Added by sowsubra
        X_COMP_PLANNING_LOC_ID,
        X_COMP_INREPAIR_LOC_ID,
        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_CREATION_DATE,
        X_CREATED_BY,
        X_LAST_UPDATE_DATE,
        X_LAST_UPDATED_BY,
        X_LAST_UPDATE_LOGIN,
        X_TOP_PROJECT_TASK_ID,   -- AVIKUKUM :: PIE :: 20-OCt-2010
        X_PAST_DATED_VISIT_FLAG, -- PRAKKUM :: VWPE :: ER 12424063 :: 01-FEB-2011
        X_FIRMED_FLAG, -- PRAKKUM :: VWPE :: ER 12424063 :: 01-FEB-2011
        X_LOCKED_FLAG, -- PRAKKUM :: VWPE :: ER 12424063 :: 01-FEB-2011
        X_AUTO_VISIT_TYPE_FLAG -- added by tchimira for ER 14015560
      );

Line: 212


          select MAX(visit_number) + 1 INTO l_visit_number FROM Ahl_Visits_B;

Line: 215


END INTERNAL_INSERT_B_ROW;

Line: 219


procedure INSERT_ROW (
  X_ROWID in out nocopy VARCHAR2,
  X_VISIT_ID in NUMBER,
  X_ESTIMATED_PRICE in NUMBER,
  X_PRIORITY_CODE in VARCHAR2,
  X_PROJECT_TEMPLATE_ID in NUMBER,
  X_UNIT_SCHEDULE_ID in NUMBER,
  X_ACTUAL_PRICE in NUMBER,
  X_OUTSIDE_PARTY_FLAG in VARCHAR2,
  X_ANY_TASK_CHG_FLAG in VARCHAR2,
  X_PRICE_LIST_ID in NUMBER,
  X_CLOSE_DATE_TIME in DATE,
  X_SCHEDULE_DESIGNATOR in VARCHAR2,
  X_SERVICE_REQUEST_ID in NUMBER,
  X_SPACE_CATEGORY_CODE in VARCHAR2,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_ORGANIZATION_ID in NUMBER,
  X_DEPARTMENT_ID in NUMBER,
  X_STATUS_CODE in VARCHAR2,
  X_START_DATE_TIME in DATE,
  X_VISIT_TYPE_CODE in VARCHAR2,
  X_SIMULATION_PLAN_ID in NUMBER,
  X_ITEM_INSTANCE_ID in NUMBER,
  X_INVENTORY_ITEM_ID in NUMBER,
  X_ASSO_PRIMARY_VISIT_ID in NUMBER,
  X_SIMULATION_DELETE_FLAG in VARCHAR2,
  X_TEMPLATE_FLAG in VARCHAR2,
  X_OUT_OF_SYNC_FLAG in VARCHAR2,
  X_PROJECT_FLAG in VARCHAR2,
  X_PROJECT_ID in NUMBER,
  X_VISIT_NUMBER in NUMBER,
  X_ITEM_ORGANIZATION_ID 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_NAME in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_INV_LOCATOR_ID in NUMBER,
  X_COMP_PLANNING_LOC_ID in NUMBER,
  X_COMP_INREPAIR_LOC_ID 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_TOP_PROJECT_TASK_ID in NUMBER,   -- AVIKUKUM :: PIE :: 20-OCT-2010
  X_PAST_DATED_VISIT_FLAG in VARCHAR2, -- PRAKKUM :: VWPE :: ER 12424063 :: 01-FEB-2011
  X_FIRMED_FLAG in VARCHAR2, -- PRAKKUM :: VWPE :: ER 12424063 :: 01-FEB-2011
  X_LOCKED_FLAG in VARCHAR2, -- PRAKKUM :: VWPE :: ER 12424063 :: 01-FEB-2011
  X_AUTO_VISIT_TYPE_FLAG IN VARCHAR2 := null -- added by tchimira for ER 14015560
) is
  cursor C is select ROWID from AHL_VISITS_B
    where VISIT_ID = X_VISIT_ID
    ;

Line: 289


  INTERNAL_INSERT_B_ROW (
    X_ESTIMATED_PRICE,
    X_PRIORITY_CODE,
    X_PROJECT_TEMPLATE_ID,
    X_UNIT_SCHEDULE_ID,
    X_ACTUAL_PRICE,
    X_OUTSIDE_PARTY_FLAG,
    X_ANY_TASK_CHG_FLAG,
    X_PRICE_LIST_ID,
    X_CLOSE_DATE_TIME,
    X_SCHEDULE_DESIGNATOR,
    X_SERVICE_REQUEST_ID,
    X_SPACE_CATEGORY_CODE,
    X_VISIT_ID,
    X_OBJECT_VERSION_NUMBER,
    X_ORGANIZATION_ID,
    X_DEPARTMENT_ID,
    X_STATUS_CODE,
    X_START_DATE_TIME,
    X_VISIT_TYPE_CODE,
    X_SIMULATION_PLAN_ID,
    X_ITEM_INSTANCE_ID,
    X_INVENTORY_ITEM_ID,
    X_ASSO_PRIMARY_VISIT_ID,
    X_SIMULATION_DELETE_FLAG,
    X_TEMPLATE_FLAG,
    X_OUT_OF_SYNC_FLAG,
    X_PROJECT_FLAG,
    X_PROJECT_ID,
    X_VISIT_NUMBER,
    X_ITEM_ORGANIZATION_ID,
    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_INV_LOCATOR_ID,
    X_COMP_PLANNING_LOC_ID,
    X_COMP_INREPAIR_LOC_ID,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_TOP_PROJECT_TASK_ID,   -- AVIKUKUM :: PIE :: 20-OCT-2010
    X_PAST_DATED_VISIT_FLAG, -- PRAKKUM :: VWPE :: ER 12424063 :: 01-FEB-2011
    X_FIRMED_FLAG, -- PRAKKUM :: VWPE :: ER 12424063 :: 01-FEB-2011
    X_LOCKED_FLAG, -- PRAKKUM :: VWPE :: ER 12424063 :: 01-FEB-2011
    X_AUTO_VISIT_TYPE_FLAG -- added by tchimira for ER 14015560
  );

Line: 351


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

Line: 389


end INSERT_ROW;

Line: 415


  X_SIMULATION_DELETE_FLAG in VARCHAR2,
  X_TEMPLATE_FLAG in VARCHAR2,
  X_OUT_OF_SYNC_FLAG in VARCHAR2,
  X_PROJECT_FLAG in VARCHAR2,
  X_PROJECT_ID in NUMBER,
  X_VISIT_NUMBER in NUMBER,
  X_ITEM_ORGANIZATION_ID 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_NAME in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_INV_LOCATOR_ID in NUMBER,--Added by sowsubra
  X_COMP_PLANNING_LOC_ID in NUMBER,
  X_COMP_INREPAIR_LOC_ID in NUMBER,
  X_TOP_PROJECT_TASK_ID in NUMBER,  -- AVIKUKUM :: PIE :: 20-OCT-2010
  X_PAST_DATED_VISIT_FLAG in VARCHAR2, -- PRAKKUM :: VWPE :: ER 12424063 :: 01-FEB-2011
  X_FIRMED_FLAG in VARCHAR2, -- PRAKKUM :: VWPE :: ER 12424063 :: 01-FEB-2011
  X_LOCKED_FLAG in VARCHAR2, -- PRAKKUM :: VWPE :: ER 12424063 :: 01-FEB-2011
  X_AUTO_VISIT_TYPE_FLAG IN VARCHAR2 := null  -- added by tchimira for ER 14015560
) is
  cursor c is select
      ESTIMATED_PRICE,
      PRIORITY_CODE,
      PROJECT_TEMPLATE_ID,
      UNIT_SCHEDULE_ID,
      ACTUAL_PRICE,
      OUTSIDE_PARTY_FLAG,
      ANY_TASK_CHG_FLAG,
      PRICE_LIST_ID,
      CLOSE_DATE_TIME,
      SCHEDULE_DESIGNATOR,
      SERVICE_REQUEST_ID,
      SPACE_CATEGORY_CODE,
      OBJECT_VERSION_NUMBER,
      ORGANIZATION_ID,
      DEPARTMENT_ID,
      STATUS_CODE,
      START_DATE_TIME,
      VISIT_TYPE_CODE,
      SIMULATION_PLAN_ID,
      ITEM_INSTANCE_ID,
      INVENTORY_ITEM_ID,
      ASSO_PRIMARY_VISIT_ID,
      SIMULATION_DELETE_FLAG,
      TEMPLATE_FLAG,
      OUT_OF_SYNC_FLAG,
      PROJECT_FLAG,
      PROJECT_ID,
      VISIT_NUMBER,
      ITEM_ORGANIZATION_ID,
      INV_LOCATOR_ID,   --Added by sowsubra
      COMP_PLANNING_LOC_ID,
      COMP_INREPAIR_LOC_ID,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15
    from AHL_VISITS_B
    where VISIT_ID = X_VISIT_ID
    for update of VISIT_ID nowait;

Line: 503


  cursor c1 is select
      VISIT_NAME,
      DESCRIPTION,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from AHL_VISITS_TL
    where VISIT_ID = X_VISIT_ID
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of VISIT_ID nowait;

Line: 516


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

Line: 570


      AND ((recinfo.SIMULATION_DELETE_FLAG = X_SIMULATION_DELETE_FLAG)
           OR ((recinfo.SIMULATION_DELETE_FLAG is null) AND (X_SIMULATION_DELETE_FLAG is null)))
      AND (recinfo.TEMPLATE_FLAG = X_TEMPLATE_FLAG)
      AND ((recinfo.OUT_OF_SYNC_FLAG = X_OUT_OF_SYNC_FLAG)
           OR ((recinfo.OUT_OF_SYNC_FLAG is null) AND (X_OUT_OF_SYNC_FLAG is null)))
      AND (recinfo.PROJECT_FLAG = X_PROJECT_FLAG)
      AND ((recinfo.PROJECT_ID = X_PROJECT_ID)
           OR ((recinfo.PROJECT_ID is null) AND (X_PROJECT_ID is null)))
      AND (recinfo.VISIT_NUMBER = X_VISIT_NUMBER)
      AND ((recinfo.ITEM_ORGANIZATION_ID = X_ITEM_ORGANIZATION_ID)
           OR ((recinfo.ITEM_ORGANIZATION_ID is null) AND (X_ITEM_ORGANIZATION_ID is null)))
      AND ((recinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)
           OR ((recinfo.ATTRIBUTE_CATEGORY is null) AND (X_ATTRIBUTE_CATEGORY is null)))
      AND ((recinfo.ATTRIBUTE1 = X_ATTRIBUTE1)
           OR ((recinfo.ATTRIBUTE1 is null) AND (X_ATTRIBUTE1 is null)))
      AND ((recinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
           OR ((recinfo.ATTRIBUTE2 is null) AND (X_ATTRIBUTE2 is null)))
      AND ((recinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
           OR ((recinfo.ATTRIBUTE3 is null) AND (X_ATTRIBUTE3 is null)))
      AND ((recinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
           OR ((recinfo.ATTRIBUTE4 is null) AND (X_ATTRIBUTE4 is null)))
      AND ((recinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
           OR ((recinfo.ATTRIBUTE5 is null) AND (X_ATTRIBUTE5 is null)))
      AND ((recinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
           OR ((recinfo.ATTRIBUTE6 is null) AND (X_ATTRIBUTE6 is null)))
      AND ((recinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
           OR ((recinfo.ATTRIBUTE7 is null) AND (X_ATTRIBUTE7 is null)))
      AND ((recinfo.ATTRIBUTE8 = X_ATTRIBUTE8)
           OR ((recinfo.ATTRIBUTE8 is null) AND (X_ATTRIBUTE8 is null)))
      AND ((recinfo.ATTRIBUTE9 = X_ATTRIBUTE9)
           OR ((recinfo.ATTRIBUTE9 is null) AND (X_ATTRIBUTE9 is null)))
      AND ((recinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
           OR ((recinfo.ATTRIBUTE10 is null) AND (X_ATTRIBUTE10 is null)))
      AND ((recinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
           OR ((recinfo.ATTRIBUTE11 is null) AND (X_ATTRIBUTE11 is null)))
      AND ((recinfo.ATTRIBUTE12 = X_ATTRIBUTE12)
           OR ((recinfo.ATTRIBUTE12 is null) AND (X_ATTRIBUTE12 is null)))
      AND ((recinfo.ATTRIBUTE13 = X_ATTRIBUTE13)
           OR ((recinfo.ATTRIBUTE13 is null) AND (X_ATTRIBUTE13 is null)))
      AND ((recinfo.ATTRIBUTE14 = X_ATTRIBUTE14)
           OR ((recinfo.ATTRIBUTE14 is null) AND (X_ATTRIBUTE14 is null)))
      AND ((recinfo.ATTRIBUTE15 = X_ATTRIBUTE15)
           OR ((recinfo.ATTRIBUTE15 is null) AND (X_ATTRIBUTE15 is null)))
  ) then
    null;

Line: 637


procedure UPDATE_ROW (
  X_VISIT_ID in NUMBER,
  X_ESTIMATED_PRICE in NUMBER,
  X_PRIORITY_CODE in VARCHAR2,
  X_PROJECT_TEMPLATE_ID in NUMBER,
  X_UNIT_SCHEDULE_ID in NUMBER,
  X_ACTUAL_PRICE in NUMBER,
  X_OUTSIDE_PARTY_FLAG in VARCHAR2,
  X_ANY_TASK_CHG_FLAG in VARCHAR2,
  X_PRICE_LIST_ID in NUMBER,
  X_CLOSE_DATE_TIME in DATE,
  X_SCHEDULE_DESIGNATOR in VARCHAR2,
  X_SERVICE_REQUEST_ID in NUMBER,
  X_SPACE_CATEGORY_CODE in VARCHAR2,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_ORGANIZATION_ID in NUMBER,
  X_DEPARTMENT_ID in NUMBER,
  X_STATUS_CODE in VARCHAR2,
  X_START_DATE_TIME in DATE,
  X_VISIT_TYPE_CODE in VARCHAR2,
  X_SIMULATION_PLAN_ID in NUMBER,
  X_ITEM_INSTANCE_ID in NUMBER,
  X_INVENTORY_ITEM_ID in NUMBER,
  X_ASSO_PRIMARY_VISIT_ID in NUMBER,
  X_SIMULATION_DELETE_FLAG in VARCHAR2,
  X_TEMPLATE_FLAG in VARCHAR2,
  X_OUT_OF_SYNC_FLAG in VARCHAR2,
  X_PROJECT_FLAG in VARCHAR2,
  X_PROJECT_ID in NUMBER,
  X_VISIT_NUMBER in NUMBER,
  X_ITEM_ORGANIZATION_ID 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_NAME in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_INV_LOCATOR_ID in NUMBER,  --Added by sowsubra
  X_COMP_PLANNING_LOC_ID in NUMBER,
  X_COMP_INREPAIR_LOC_ID in NUMBER,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER,
  X_TOP_PROJECT_TASK_ID in NUMBER,  -- AVIKUKUM :: PIE :: 20-OCt-2010
  X_PAST_DATED_VISIT_FLAG in VARCHAR2, -- PRAKKUM :: VWPE :: ER 12424063 :: 01-FEB-2011
  X_FIRMED_FLAG IN VARCHAR2, -- PRAKKUM :: VWPE :: ER 12424063 :: 01-FEB-2011
  X_LOCKED_FLAG IN VARCHAR2, -- PRAKKUM :: VWPE :: ER 12424063 :: 01-FEB-2011
  X_ITEM_OWNER_FLAG IN VARCHAR2, --ARUNJK added for Marshalling
  X_AUTO_VISIT_TYPE_FLAG IN VARCHAR2 := null  -- added by tchimira for ER 14015560
) is
begin
  update AHL_VISITS_B set
    ESTIMATED_PRICE = X_ESTIMATED_PRICE,
    PRIORITY_CODE = X_PRIORITY_CODE,
    PROJECT_TEMPLATE_ID = X_PROJECT_TEMPLATE_ID,
    UNIT_SCHEDULE_ID = X_UNIT_SCHEDULE_ID,
    ACTUAL_PRICE = X_ACTUAL_PRICE,
    OUTSIDE_PARTY_FLAG = X_OUTSIDE_PARTY_FLAG,
    ANY_TASK_CHG_FLAG = X_ANY_TASK_CHG_FLAG,
    PRICE_LIST_ID = X_PRICE_LIST_ID,
    CLOSE_DATE_TIME = X_CLOSE_DATE_TIME,
    SCHEDULE_DESIGNATOR = X_SCHEDULE_DESIGNATOR,
    SERVICE_REQUEST_ID = X_SERVICE_REQUEST_ID,
    SPACE_CATEGORY_CODE = X_SPACE_CATEGORY_CODE,
    OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
    ORGANIZATION_ID = X_ORGANIZATION_ID,
    DEPARTMENT_ID = X_DEPARTMENT_ID,
    STATUS_CODE = X_STATUS_CODE,
    START_DATE_TIME = X_START_DATE_TIME,
    VISIT_TYPE_CODE = X_VISIT_TYPE_CODE,
    SIMULATION_PLAN_ID = X_SIMULATION_PLAN_ID,
    ITEM_INSTANCE_ID = X_ITEM_INSTANCE_ID,
    INVENTORY_ITEM_ID = X_INVENTORY_ITEM_ID,
    ASSO_PRIMARY_VISIT_ID = X_ASSO_PRIMARY_VISIT_ID,
    SIMULATION_DELETE_FLAG = X_SIMULATION_DELETE_FLAG,
    TEMPLATE_FLAG = X_TEMPLATE_FLAG,
    OUT_OF_SYNC_FLAG = X_OUT_OF_SYNC_FLAG,
    PROJECT_FLAG = X_PROJECT_FLAG,
    PROJECT_ID = X_PROJECT_ID,
    VISIT_NUMBER = X_VISIT_NUMBER,
    ITEM_ORGANIZATION_ID = X_ITEM_ORGANIZATION_ID,
    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,
    INV_LOCATOR_ID = X_INV_LOCATOR_ID, --Added by sowsubra
    COMP_PLANNING_LOC_ID = X_COMP_PLANNING_LOC_ID,
    COMP_INREPAIR_LOC_ID = X_COMP_INREPAIR_LOC_ID,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    TOP_PROJECT_TASK_ID = X_TOP_PROJECT_TASK_ID,  -- AVIKUKUM :: PIE :: 20-OCT-2010
    PAST_DATED_VISIT_FLAG = X_PAST_DATED_VISIT_FLAG , -- PRAKKUM :: VWPE :: ER 12424063 :: 01-FEB-2011
    FIRMED_FLAG = X_FIRMED_FLAG , -- PRAKKUM :: VWPE :: ER 12424063 :: 01-FEB-2011
    LOCKED_FLAG = X_LOCKED_FLAG, -- PRAKKUM :: VWPE :: ER 12424063 :: 01-FEB-2011
    ITEM_OWNER_FLAG = X_ITEM_OWNER_FLAG,
    AUTO_VISIT_TYPE_FLAG = X_AUTO_VISIT_TYPE_FLAG -- added by tchimira for ER 14015560
  where VISIT_ID = X_VISIT_ID;

Line: 764


  update AHL_VISITS_TL set
    VISIT_NAME = X_VISIT_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_ID = X_VISIT_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 777


end UPDATE_ROW;

Line: 779


procedure DELETE_ROW (
  X_VISIT_ID in NUMBER
) is
begin
  delete from AHL_VISITS_TL
  where VISIT_ID = X_VISIT_ID;

Line: 790


  delete from AHL_VISITS_B
  where VISIT_ID = X_VISIT_ID;

Line: 796


end DELETE_ROW;

Line: 801


  delete from AHL_VISITS_TL T
  where not exists
    (select NULL
    from AHL_VISITS_B B
    where B.VISIT_ID = T.VISIT_ID
    );

Line: 808


  update AHL_VISITS_TL T set (
      VISIT_NAME,
      DESCRIPTION
    ) = (select
      B.VISIT_NAME,
      B.DESCRIPTION
    from AHL_VISITS_TL B
    where B.VISIT_ID = T.VISIT_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.VISIT_ID,
      T.LANGUAGE
  ) in (select
      SUBT.VISIT_ID,
      SUBT.LANGUAGE
    from AHL_VISITS_TL SUBB, AHL_VISITS_TL SUBT
    where SUBB.VISIT_ID = SUBT.VISIT_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.VISIT_NAME <> SUBT.VISIT_NAME
      or (SUBB.VISIT_NAME is null and SUBT.VISIT_NAME is not null)
      or (SUBB.VISIT_NAME is not null and SUBT.VISIT_NAME is null)
      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: 834


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