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

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

Line: 14


PROCEDURE Insert_Row(
          px_RELATED_OBJECT_ID   IN OUT NOCOPY /* file.sql.39 change */   NUMBER,
          p_CREATION_DATE    DATE,
          p_CREATED_BY    NUMBER,
          p_LAST_UPDATE_DATE    DATE,
          p_LAST_UPDATED_BY    NUMBER,
          p_LAST_UPDATE_LOGIN    NUMBER,
          p_REQUEST_ID    NUMBER,
          p_PROGRAM_APPLICATION_ID    NUMBER,
          p_PROGRAM_ID    NUMBER,
          p_PROGRAM_UPDATE_DATE    DATE,
          p_QUOTE_OBJECT_TYPE_CODE    VARCHAR2,
          p_QUOTE_OBJECT_ID    NUMBER,
          p_OBJECT_TYPE_CODE    VARCHAR2,
          p_OBJECT_ID    NUMBER,
          p_RELATIONSHIP_TYPE_CODE    VARCHAR2,
          p_RECIPROCAL_FLAG    VARCHAR2,
          p_OBJECT_VERSION_NUMBER  NUMBER
		)
       --   p_QUOTE_OBJECT_CODE    NUMBER

 IS
   CURSOR C2 IS SELECT ASO_QUOTE_RELATED_OBJECTS_S.nextval FROM sys.dual;

Line: 43


   INSERT INTO ASO_QUOTE_RELATED_OBJECTS(
           RELATED_OBJECT_ID,
           CREATION_DATE,
           CREATED_BY,
           LAST_UPDATE_DATE,
           LAST_UPDATED_BY,
           LAST_UPDATE_LOGIN,
           REQUEST_ID,
           PROGRAM_APPLICATION_ID,
           PROGRAM_ID,
           PROGRAM_UPDATE_DATE,
           QUOTE_OBJECT_TYPE_CODE,
           QUOTE_OBJECT_ID,
           OBJECT_TYPE_CODE,
           OBJECT_ID,
           RELATIONSHIP_TYPE_CODE,
           RECIPROCAL_FLAG,
           OBJECT_VERSION_NUMBER
          ) VALUES (
           px_RELATED_OBJECT_ID,
           ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
           decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
           ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
           decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
           decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
           decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
           decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
           decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
           ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_PROGRAM_UPDATE_DATE),
           decode( p_QUOTE_OBJECT_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_QUOTE_OBJECT_TYPE_CODE),
           decode( p_QUOTE_OBJECT_ID, FND_API.G_MISS_NUM, NULL, p_QUOTE_OBJECT_ID),
           decode( p_OBJECT_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_OBJECT_TYPE_CODE),
           decode( p_OBJECT_ID, FND_API.G_MISS_NUM, NULL, p_OBJECT_ID),
           decode( p_RELATIONSHIP_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_RELATIONSHIP_TYPE_CODE),
           decode( p_RECIPROCAL_FLAG, FND_API.G_MISS_CHAR, NULL, p_RECIPROCAL_FLAG),
	      decode ( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,1,NULL,1, p_OBJECT_VERSION_NUMBER));

Line: 80


End Insert_Row;

Line: 82


PROCEDURE Update_Row(
          p_RELATED_OBJECT_ID    NUMBER,
          p_CREATION_DATE    DATE,
          p_CREATED_BY    NUMBER,
          p_LAST_UPDATE_DATE    DATE,
          p_LAST_UPDATED_BY    NUMBER,
          p_LAST_UPDATE_LOGIN    NUMBER,
          p_REQUEST_ID    NUMBER,
          p_PROGRAM_APPLICATION_ID    NUMBER,
          p_PROGRAM_ID    NUMBER,
          p_PROGRAM_UPDATE_DATE    DATE,
          p_QUOTE_OBJECT_TYPE_CODE    VARCHAR2,
          p_QUOTE_OBJECT_ID    NUMBER,
          p_OBJECT_TYPE_CODE    VARCHAR2,
          p_OBJECT_ID    NUMBER,
          p_RELATIONSHIP_TYPE_CODE    VARCHAR2,
          p_RECIPROCAL_FLAG    VARCHAR2,
          p_OBJECT_VERSION_NUMBER  NUMBER
		)
 --         p_QUOTE_OBJECT_CODE    NUMBER)

 IS
 BEGIN
    Update ASO_QUOTE_RELATED_OBJECTS
    SET
              CREATION_DATE = ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
              CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
              LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
              LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
              LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
              REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
              PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
              PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
              PROGRAM_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
              QUOTE_OBJECT_TYPE_CODE = decode( p_QUOTE_OBJECT_TYPE_CODE, FND_API.G_MISS_CHAR, QUOTE_OBJECT_TYPE_CODE, p_QUOTE_OBJECT_TYPE_CODE),
              QUOTE_OBJECT_ID = decode( p_QUOTE_OBJECT_ID, FND_API.G_MISS_NUM, QUOTE_OBJECT_ID, p_QUOTE_OBJECT_ID),
              OBJECT_TYPE_CODE = decode( p_OBJECT_TYPE_CODE, FND_API.G_MISS_CHAR, OBJECT_TYPE_CODE, p_OBJECT_TYPE_CODE),
              OBJECT_ID = decode( p_OBJECT_ID, FND_API.G_MISS_NUM, OBJECT_ID, p_OBJECT_ID),
              RELATIONSHIP_TYPE_CODE = decode( p_RELATIONSHIP_TYPE_CODE, FND_API.G_MISS_CHAR, RELATIONSHIP_TYPE_CODE, p_RELATIONSHIP_TYPE_CODE),
              RECIPROCAL_FLAG = decode( p_RECIPROCAL_FLAG, FND_API.G_MISS_CHAR, RECIPROCAL_FLAG, p_RECIPROCAL_FLAG),
		    OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, nvl(OBJECT_VERSION_NUMBER,0)+1, nvl(p_OBJECT_VERSION_NUMBER, nvl(OBJECT_VERSION_NUMBER,0))+1)
    where RELATED_OBJECT_ID = p_RELATED_OBJECT_ID;

Line: 128


END Update_Row;

Line: 130


PROCEDURE Delete_Row(
    p_RELATED_OBJECT_ID  NUMBER)
 IS
 BEGIN
   DELETE FROM ASO_QUOTE_RELATED_OBJECTS
    WHERE RELATED_OBJECT_ID = p_RELATED_OBJECT_ID;

Line: 139


 END Delete_Row;

Line: 146


          p_LAST_UPDATE_DATE    DATE,
          p_LAST_UPDATED_BY    NUMBER,
          p_LAST_UPDATE_LOGIN    NUMBER,
          p_REQUEST_ID    NUMBER,
          p_PROGRAM_APPLICATION_ID    NUMBER,
          p_PROGRAM_ID    NUMBER,
          p_PROGRAM_UPDATE_DATE    DATE,
          p_QUOTE_OBJECT_TYPE_CODE    VARCHAR2,
          p_QUOTE_OBJECT_ID    NUMBER,
          p_OBJECT_TYPE_CODE    VARCHAR2,
          p_OBJECT_ID    NUMBER,
          p_RELATIONSHIP_TYPE_CODE    VARCHAR2,
          p_RECIPROCAL_FLAG    VARCHAR2)
--          p_QUOTE_OBJECT_CODE    NUMBER)

 IS
   CURSOR C IS
        SELECT RELATED_OBJECT_ID,
	   --OBJECT_VERSION_NUMBER,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
REQUEST_ID,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
QUOTE_OBJECT_TYPE_CODE,
QUOTE_OBJECT_ID,
OBJECT_TYPE_CODE,
OBJECT_ID,
RELATIONSHIP_TYPE_CODE,
RECIPROCAL_FLAG
         FROM ASO_QUOTE_RELATED_OBJECTS
        WHERE RELATED_OBJECT_ID =  p_RELATED_OBJECT_ID
        FOR UPDATE of RELATED_OBJECT_ID NOWAIT;

Line: 189


        FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');

Line: 204


	  (    ( Recinfo.LAST_UPDATE_DATE = p_LAST_UPDATE_DATE)
            OR (    ( Recinfo.LAST_UPDATE_DATE IS NULL )
                AND (  p_LAST_UPDATE_DATE IS NULL )))
/*
       AND
	   (    ( Recinfo.OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER)
	      OR (    ( Recinfo.OBJECT_VERSION_NUMBER IS NULL )
		         AND (  p_OBJECT_VERSION_NUMBER IS NULL )))
       AND (    ( Recinfo.LAST_UPDATED_BY = p_LAST_UPDATED_BY)
            OR (    ( Recinfo.LAST_UPDATED_BY IS NULL )
                AND (  p_LAST_UPDATED_BY IS NULL )))
       AND (    ( Recinfo.LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN)
            OR (    ( Recinfo.LAST_UPDATE_LOGIN IS NULL )
                AND (  p_LAST_UPDATE_LOGIN IS NULL )))
       AND (    ( Recinfo.REQUEST_ID = p_REQUEST_ID)
            OR (    ( Recinfo.REQUEST_ID IS NULL )
                AND (  p_REQUEST_ID IS NULL )))
       AND (    ( Recinfo.PROGRAM_APPLICATION_ID = p_PROGRAM_APPLICATION_ID)
            OR (    ( Recinfo.PROGRAM_APPLICATION_ID IS NULL )
                AND (  p_PROGRAM_APPLICATION_ID IS NULL )))
       AND (    ( Recinfo.PROGRAM_ID = p_PROGRAM_ID)
            OR (    ( Recinfo.PROGRAM_ID IS NULL )
                AND (  p_PROGRAM_ID IS NULL )))
       AND (    ( Recinfo.PROGRAM_UPDATE_DATE = p_PROGRAM_UPDATE_DATE)
            OR (    ( Recinfo.PROGRAM_UPDATE_DATE IS NULL )
                AND (  p_PROGRAM_UPDATE_DATE IS NULL )))
       AND (    ( Recinfo.QUOTE_OBJECT_TYPE_CODE = p_QUOTE_OBJECT_TYPE_CODE)
            OR (    ( Recinfo.QUOTE_OBJECT_TYPE_CODE IS NULL )
                AND (  p_QUOTE_OBJECT_TYPE_CODE IS NULL )))
       AND (    ( Recinfo.QUOTE_OBJECT_ID = p_QUOTE_OBJECT_ID)
            OR (    ( Recinfo.QUOTE_OBJECT_ID IS NULL )
                AND (  p_QUOTE_OBJECT_ID IS NULL )))
       AND (    ( Recinfo.OBJECT_TYPE_CODE = p_OBJECT_TYPE_CODE)
            OR (    ( Recinfo.OBJECT_TYPE_CODE IS NULL )
                AND (  p_OBJECT_TYPE_CODE IS NULL )))
       AND (    ( Recinfo.OBJECT_ID = p_OBJECT_ID)
            OR (    ( Recinfo.OBJECT_ID IS NULL )
                AND (  p_OBJECT_ID IS NULL )))
       AND (    ( Recinfo.RELATIONSHIP_TYPE_CODE = p_RELATIONSHIP_TYPE_CODE)
            OR (    ( Recinfo.RELATIONSHIP_TYPE_CODE IS NULL )
                AND (  p_RELATIONSHIP_TYPE_CODE IS NULL )))
       AND (    ( Recinfo.RECIPROCAL_FLAG = p_RECIPROCAL_FLAG)
            OR (    ( Recinfo.RECIPROCAL_FLAG IS NULL )
                AND (  p_RECIPROCAL_FLAG IS NULL )))
*/
     /*  AND (    ( Recinfo.QUOTE_OBJECT_CODE = p_QUOTE_OBJECT_CODE)
            OR (    ( Recinfo.QUOTE_OBJECT_CODE IS NULL )
                AND (  p_QUOTE_OBJECT_CODE IS NULL )))*/
       ) then
       return;