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.EAM_ISOLATION_UTILITY_PVT SQL Statements

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

Line: 32


  SELECT iso.ISOLATION_ID ,
    iso.ISOLATION_NAME ,
    iso.ISOLATION_TYPE ,
    iso.DESCRIPTION ,
    iso.ORGANIZATION_ID ,
    iso.PENDING_FLAG ,
    iso.EFFECTIVE_START_DATE ,
    iso.EFFECTIVE_END_DATE ,
    iso.PERMIT_REQUIRED_FLAG ,
    iso.APPROVED_BY ,
    iso.USER_DEFINED_STATUS_ID ,
    iso.STATUS_TYPE ,
    iso.ATTRIBUTE_CATEGORY ,
    iso.ATTRIBUTE1 ,
    iso.ATTRIBUTE2 ,
    iso.ATTRIBUTE3 ,
    iso.ATTRIBUTE4 ,
    iso.ATTRIBUTE5 ,
    iso.ATTRIBUTE6 ,
    iso.ATTRIBUTE7 ,
    iso.ATTRIBUTE8 ,
    iso.ATTRIBUTE9 ,
    iso.ATTRIBUTE10 ,
    iso.ATTRIBUTE11 ,
    iso.ATTRIBUTE12 ,
    iso.ATTRIBUTE13 ,
    iso.ATTRIBUTE14 ,
    iso.ATTRIBUTE15 ,
    iso.ATTRIBUTE16 ,
    iso.ATTRIBUTE17 ,
    iso.ATTRIBUTE18 ,
    iso.ATTRIBUTE19 ,
    iso.ATTRIBUTE20 ,
    iso.ATTRIBUTE21 ,
    iso.ATTRIBUTE22 ,
    iso.ATTRIBUTE23 ,
    iso.ATTRIBUTE24 ,
    iso.ATTRIBUTE25 ,
    iso.ATTRIBUTE26 ,
    iso.ATTRIBUTE27 ,
    iso.ATTRIBUTE28 ,
    iso.ATTRIBUTE29 ,
    iso.ATTRIBUTE30 ,
    iso.CREATION_DATE ,
    iso.CREATED_BY
  INTO l_isolation_header_rec.ISOLATION_ID ,
    l_isolation_header_rec.ISOLATION_NAME ,
    l_isolation_header_rec.ISOLATION_TYPE ,
    l_isolation_header_rec.DESCRIPTION ,
    l_isolation_header_rec.ORGANIZATION_ID ,
    l_isolation_header_rec.PENDING_FLAG ,
    l_isolation_header_rec.EFFECTIVE_START_DATE ,
    l_isolation_header_rec.EFFECTIVE_END_DATE ,
    l_isolation_header_rec.PERMIT_REQUIRED ,
    l_isolation_header_rec.APPROVED_BY ,
    l_isolation_header_rec.USER_DEFINED_STATUS ,
    l_isolation_header_rec.SYSTEM_STATUS ,
    l_isolation_header_rec.ATTRIBUTE_CATEGORY ,
    l_isolation_header_rec.ATTRIBUTE1 ,
    l_isolation_header_rec.ATTRIBUTE2 ,
    l_isolation_header_rec.ATTRIBUTE3 ,
    l_isolation_header_rec.ATTRIBUTE4 ,
    l_isolation_header_rec.ATTRIBUTE5 ,
    l_isolation_header_rec.ATTRIBUTE6 ,
    l_isolation_header_rec.ATTRIBUTE7 ,
    l_isolation_header_rec.ATTRIBUTE8 ,
    l_isolation_header_rec.ATTRIBUTE9 ,
    l_isolation_header_rec.ATTRIBUTE10 ,
    l_isolation_header_rec.ATTRIBUTE11 ,
    l_isolation_header_rec.ATTRIBUTE12 ,
    l_isolation_header_rec.ATTRIBUTE13 ,
    l_isolation_header_rec.ATTRIBUTE14 ,
    l_isolation_header_rec.ATTRIBUTE15 ,
    l_isolation_header_rec.ATTRIBUTE16 ,
    l_isolation_header_rec.ATTRIBUTE17 ,
    l_isolation_header_rec.ATTRIBUTE18 ,
    l_isolation_header_rec.ATTRIBUTE19 ,
    l_isolation_header_rec.ATTRIBUTE20 ,
    l_isolation_header_rec.ATTRIBUTE21 ,
    l_isolation_header_rec.ATTRIBUTE22 ,
    l_isolation_header_rec.ATTRIBUTE23 ,
    l_isolation_header_rec.ATTRIBUTE24 ,
    l_isolation_header_rec.ATTRIBUTE25 ,
    l_isolation_header_rec.ATTRIBUTE26 ,
    l_isolation_header_rec.ATTRIBUTE27 ,
    l_isolation_header_rec.ATTRIBUTE28 ,
    l_isolation_header_rec.ATTRIBUTE29 ,
    l_isolation_header_rec.ATTRIBUTE30 ,
    l_isolation_header_rec.CREATION_DATE ,
    l_isolation_header_rec.CREATED_BY
  FROM EAM_ISOLATIONS iso
  WHERE iso.isolation_id  = p_isolation_id
  AND iso.organization_id = p_organization_id;

Line: 137


* Procedure     : INSERT_ROW
* Purpose       : Procedure will perfrom an insert into the table
*********************************************************************/
PROCEDURE INSERT_ROW(
    p_isolation_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type ,
    x_return_Status OUT NOCOPY VARCHAR2 )
IS
BEGIN
  IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
    EAM_ERROR_MESSAGE_PVT.Write_Debug('Writing Isolation record for ' || p_isolation_header_rec.ISOLATION_NAME);

Line: 148


  INSERT
  INTO EAM_ISOLATIONS
    (
      ISOLATION_ID ,
      ISOLATION_NAME ,
      ISOLATION_TYPE ,
      DESCRIPTION ,
      ORGANIZATION_ID ,
      PENDING_FLAG ,
      EFFECTIVE_START_DATE ,
      EFFECTIVE_END_DATE ,
      PERMIT_REQUIRED_FLAG ,
      APPROVED_BY ,
      USER_DEFINED_STATUS_ID ,
      STATUS_TYPE ,
      ATTRIBUTE_CATEGORY ,
      ATTRIBUTE1 ,
      ATTRIBUTE2 ,
      ATTRIBUTE3 ,
      ATTRIBUTE4 ,
      ATTRIBUTE5 ,
      ATTRIBUTE6 ,
      ATTRIBUTE7 ,
      ATTRIBUTE8 ,
      ATTRIBUTE9 ,
      ATTRIBUTE10 ,
      ATTRIBUTE11 ,
      ATTRIBUTE12 ,
      ATTRIBUTE13 ,
      ATTRIBUTE14 ,
      ATTRIBUTE15 ,
      ATTRIBUTE16 ,
      ATTRIBUTE17 ,
      ATTRIBUTE18 ,
      ATTRIBUTE19 ,
      ATTRIBUTE20 ,
      ATTRIBUTE21 ,
      ATTRIBUTE22 ,
      ATTRIBUTE23 ,
      ATTRIBUTE24 ,
      ATTRIBUTE25 ,
      ATTRIBUTE26 ,
      ATTRIBUTE27 ,
      ATTRIBUTE28 ,
      ATTRIBUTE29 ,
      ATTRIBUTE30 ,
      LAST_UPDATE_DATE ,
      LAST_UPDATED_BY ,
      CREATION_DATE ,
      CREATED_BY ,
      LAST_UPDATE_LOGIN
    )
    VALUES
    (
      p_isolation_header_rec.ISOLATION_ID ,
      p_isolation_header_rec.ISOLATION_NAME ,
      p_isolation_header_rec.ISOLATION_TYPE ,
      p_isolation_header_rec.DESCRIPTION ,
      p_isolation_header_rec.ORGANIZATION_ID ,
      p_isolation_header_rec.PENDING_FLAG ,
      p_isolation_header_rec.EFFECTIVE_START_DATE ,
      p_isolation_header_rec.EFFECTIVE_END_DATE ,
      p_isolation_header_rec.PERMIT_REQUIRED ,
      DECODE(p_isolation_header_rec.APPROVED_BY, FND_API.G_MISS_CHAR, NULL, p_isolation_header_rec.APPROVED_BY) ,
      p_isolation_header_rec.USER_DEFINED_STATUS ,
      p_isolation_header_rec.SYSTEM_STATUS ,
      p_isolation_header_rec.ATTRIBUTE_CATEGORY ,
      p_isolation_header_rec.ATTRIBUTE1 ,
      p_isolation_header_rec.ATTRIBUTE2 ,
      p_isolation_header_rec.ATTRIBUTE3 ,
      p_isolation_header_rec.ATTRIBUTE4 ,
      p_isolation_header_rec.ATTRIBUTE5 ,
      p_isolation_header_rec.ATTRIBUTE6 ,
      p_isolation_header_rec.ATTRIBUTE7 ,
      p_isolation_header_rec.ATTRIBUTE8 ,
      p_isolation_header_rec.ATTRIBUTE9 ,
      p_isolation_header_rec.ATTRIBUTE10 ,
      p_isolation_header_rec.ATTRIBUTE11 ,
      p_isolation_header_rec.ATTRIBUTE12 ,
      p_isolation_header_rec.ATTRIBUTE13 ,
      p_isolation_header_rec.ATTRIBUTE14 ,
      p_isolation_header_rec.ATTRIBUTE15 ,
      p_isolation_header_rec.ATTRIBUTE16 ,
      p_isolation_header_rec.ATTRIBUTE17 ,
      p_isolation_header_rec.ATTRIBUTE18 ,
      p_isolation_header_rec.ATTRIBUTE19 ,
      p_isolation_header_rec.ATTRIBUTE20 ,
      p_isolation_header_rec.ATTRIBUTE21 ,
      p_isolation_header_rec.ATTRIBUTE22 ,
      p_isolation_header_rec.ATTRIBUTE23 ,
      p_isolation_header_rec.ATTRIBUTE24 ,
      p_isolation_header_rec.ATTRIBUTE25 ,
      p_isolation_header_rec.ATTRIBUTE26 ,
      p_isolation_header_rec.ATTRIBUTE27 ,
      p_isolation_header_rec.ATTRIBUTE28 ,
      p_isolation_header_rec.ATTRIBUTE29 ,
      p_isolation_header_rec.ATTRIBUTE30 ,
      SYSDATE ,
      FND_GLOBAL.user_id ,
      SYSDATE ,
      FND_GLOBAL.user_id ,
      FND_GLOBAL.login_id
    );

Line: 255


END INSERT_ROW;

Line: 258


* Procedure     : UPDATE_ROW
* Purpose       : Procedure will perform an update on the table
*********************************************************************/
PROCEDURE UPDATE_ROW
  (
    p_isolation_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type ,
    x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type ,
    x_return_Status OUT NOCOPY VARCHAR2
  )
IS
BEGIN
  IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug ('Updating Isolation rec for ' || p_isolation_header_rec.ISOLATION_NAME);END IF;

Line: 271


  UPDATE EAM_ISOLATIONS
  SET DESCRIPTION          =p_isolation_header_rec.DESCRIPTION ,
    EFFECTIVE_START_DATE   =p_isolation_header_rec.EFFECTIVE_START_DATE ,
    EFFECTIVE_END_DATE     =p_isolation_header_rec.EFFECTIVE_END_DATE ,
    PENDING_FLAG           =p_isolation_header_rec.PENDING_FLAG ,
    PERMIT_REQUIRED_FLAG   =p_isolation_header_rec.PERMIT_REQUIRED ,
    STATUS_TYPE            =p_isolation_header_rec.SYSTEM_STATUS ,
    USER_DEFINED_STATUS_ID =p_isolation_header_rec.USER_DEFINED_STATUS ,
    ATTRIBUTE_CATEGORY     =p_isolation_header_rec.ATTRIBUTE_CATEGORY ,
    ATTRIBUTE1             =p_isolation_header_rec.ATTRIBUTE1 ,
    ATTRIBUTE2             =p_isolation_header_rec.ATTRIBUTE2 ,
    ATTRIBUTE3             =p_isolation_header_rec.ATTRIBUTE3 ,
    ATTRIBUTE4             =p_isolation_header_rec.ATTRIBUTE4 ,
    ATTRIBUTE5             =p_isolation_header_rec.ATTRIBUTE5 ,
    ATTRIBUTE6             =p_isolation_header_rec.ATTRIBUTE6 ,
    ATTRIBUTE7             =p_isolation_header_rec.ATTRIBUTE7 ,
    ATTRIBUTE8             =p_isolation_header_rec.ATTRIBUTE8 ,
    ATTRIBUTE9             =p_isolation_header_rec.ATTRIBUTE9 ,
    ATTRIBUTE10            =p_isolation_header_rec.ATTRIBUTE10 ,
    ATTRIBUTE11            =p_isolation_header_rec.ATTRIBUTE11 ,
    ATTRIBUTE12            =p_isolation_header_rec.ATTRIBUTE12 ,
    ATTRIBUTE13            =p_isolation_header_rec.ATTRIBUTE13 ,
    ATTRIBUTE14            =p_isolation_header_rec.ATTRIBUTE14 ,
    ATTRIBUTE15            =p_isolation_header_rec.ATTRIBUTE15 ,
    ATTRIBUTE16            =p_isolation_header_rec.ATTRIBUTE16 ,
    ATTRIBUTE17            =p_isolation_header_rec.ATTRIBUTE17 ,
    ATTRIBUTE18            =p_isolation_header_rec.ATTRIBUTE18 ,
    ATTRIBUTE19            =p_isolation_header_rec.ATTRIBUTE19 ,
    ATTRIBUTE20            =p_isolation_header_rec.ATTRIBUTE20 ,
    ATTRIBUTE21            =p_isolation_header_rec.ATTRIBUTE21 ,
    ATTRIBUTE22            =p_isolation_header_rec.ATTRIBUTE22 ,
    ATTRIBUTE23            =p_isolation_header_rec.ATTRIBUTE23 ,
    ATTRIBUTE24            =p_isolation_header_rec.ATTRIBUTE24 ,
    ATTRIBUTE25            =p_isolation_header_rec.ATTRIBUTE25 ,
    ATTRIBUTE26            =p_isolation_header_rec.ATTRIBUTE26 ,
    ATTRIBUTE27            =p_isolation_header_rec.ATTRIBUTE27 ,
    ATTRIBUTE28            =p_isolation_header_rec.ATTRIBUTE28 ,
    ATTRIBUTE29            =p_isolation_header_rec.ATTRIBUTE29 ,
    ATTRIBUTE30            =p_isolation_header_rec.ATTRIBUTE30 ,
    APPROVED_BY            =p_isolation_header_rec.APPROVED_BY ,
    LAST_UPDATE_DATE       =SYSDATE ,
    LAST_UPDATED_BY        =FND_GLOBAL.user_id ,
    LAST_UPDATE_LOGIN      =FND_GLOBAL.login_id
  WHERE isolation_id       = p_isolation_header_rec.isolation_id
  AND organization_id      = p_isolation_header_rec.organization_id;

Line: 320


END UPDATE_ROW;

Line: 335


    Insert_Row ( p_isolation_header_rec => p_isolation_header_rec
              , x_return_Status => l_return_status
              );

Line: 338


  ELSIF p_isolation_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE THEN
    Update_Row ( p_isolation_header_rec => p_isolation_header_rec
                , x_mesg_token_Tbl => x_mesg_token_Tbl
                , x_return_Status => l_return_status
                );

Line: 390


    EAM_ERROR_MESSAGE_PVT.Write_Debug('Update status in isolation table');

Line: 393


    UPDATE EAM_ISOLATIONS
    SET STATUS_TYPE       = l_to_status_type
    WHERE ORGANIZATION_ID = l_organization_id
    AND isolation_id      = l_isolation_id;

Line: 410


PROCEDURE INSERT_ISOLATION_HISTORY_ROW
(   p_object_id           IN NUMBER
, p_object_name         IN VARCHAR2
, p_object_type         IN NUMBER :=3
, p_event               IN VARCHAR2
, p_status              IN VARCHAR2
, p_details             IN VARCHAR2
, p_user_id             IN NUMBER
, x_mesg_token_Tbl      OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
, x_return_Status       OUT NOCOPY VARCHAR2
)IS
BEGIN
IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Inside INSERT_ISOLATION_HISTORY_ROW '); END IF;

Line: 423


END INSERT_ISOLATION_HISTORY_ROW; */