APPS.HZ_PRIMARY_TRANSFORM_PKG SQL Statements

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

Line: 5

PROCEDURE Insert_Row(
                    px_PRIMARY_TRANSFORM_ID IN OUT NOCOPY     NUMBER,
                    p_PRIMARY_ATTRIBUTE_ID            NUMBER,
                    p_FUNCTION_ID                      NUMBER,
                    p_ACTIVE_FLAG                      VARCHAR2,
                    p_CREATED_BY                       NUMBER,
                    p_CREATION_DATE                    DATE,
                    p_LAST_UPDATE_LOGIN                NUMBER,
                    p_LAST_UPDATE_DATE                 DATE,
                    p_LAST_UPDATED_BY                  NUMBER,
                    p_OBJECT_VERSION_NUMBER           NUMBER)
 IS

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

Line: 28

      INSERT INTO HZ_PRIMARY_TRANS(
                PRIMARY_TRANSFORM_ID,
                PRIMARY_ATTRIBUTE_ID,
                FUNCTION_ID,
                ACTIVE_FLAG,
                CREATED_BY,
                CREATION_DATE,
                LAST_UPDATE_LOGIN,
                LAST_UPDATE_DATE,
                LAST_UPDATED_BY,
                OBJECT_VERSION_NUMBER
               )
               VALUES (
                px_PRIMARY_TRANSFORM_ID,
                decode(p_PRIMARY_ATTRIBUTE_ID,  FND_API.G_MISS_NUM,   NULL, p_PRIMARY_ATTRIBUTE_ID),
                decode(p_FUNCTION_ID,           FND_API.G_MISS_NUM,   NULL, p_FUNCTION_ID),
                decode(p_ACTIVE_FLAG,           FND_API.G_MISS_CHAR,  NULL, p_ACTIVE_FLAG),
                decode(p_created_by,            FND_API.G_MISS_NUM,   NULL, p_created_by),
                decode(p_creation_date,         FND_API.G_MISS_DATE,  to_date(NULL), p_creation_date),
                decode(p_last_update_login,     FND_API.G_MISS_NUM,   NULL, p_last_update_login),
                decode(p_last_update_date,      FND_API.G_MISS_DATE,  to_date(NULL), p_last_update_date),
                decode(p_last_updated_by,       FND_API.G_MISS_NUM,   NULL, p_last_updated_by),
                1
                );

Line: 62

                 SELECT  HZ_PRIMARY_TRANS_s.nextval
		  into  px_PRIMARY_TRANSFORM_ID FROM sys.dual;

Line: 65

                  SELECT 'Y' INTO l_dummy
                  FROM HZ_PRIMARY_TRANS
                  WHERE PRIMARY_TRANSFORM_ID  =  px_PRIMARY_TRANSFORM_ID ;

Line: 77

End Insert_Row;

Line: 79

    PROCEDURE Update_Row(
                    p_PRIMARY_TRANSFORM_ID            NUMBER,
                    p_PRIMARY_ATTRIBUTE_ID            NUMBER,
                    p_FUNCTION_ID                     NUMBER,
                    p_ACTIVE_FLAG                     VARCHAR2,
                    p_CREATED_BY                      NUMBER,
                    p_CREATION_DATE                   DATE,
                    p_LAST_UPDATE_LOGIN               NUMBER,
                    p_LAST_UPDATE_DATE                DATE,
                    p_LAST_UPDATED_BY                 NUMBER,
                    p_OBJECT_VERSION_NUMBER  in out NOCOPY   NUMBER
     ) IS
    l_object_version_number number;

Line: 97

   UPDATE hz_primary_trans
   SET
      PRIMARY_ATTRIBUTE_ID= decode(p_PRIMARY_ATTRIBUTE_ID,    FND_API.G_MISS_NUM, PRIMARY_ATTRIBUTE_ID,
                                   p_PRIMARY_ATTRIBUTE_ID),
      FUNCTION_ID        = decode(p_FUNCTION_ID,       FND_API.G_MISS_NUM,  FUNCTION_ID       , p_FUNCTION_ID),
      ACTIVE_FLAG         = decode(p_ACTIVE_FLAG,      FND_API.G_MISS_CHAR, ACTIVE_FLAG       , p_ACTIVE_FLAG),
      -- Bug 3032780
      /*
      CREATED_BY          = decode(p_created_by,       FND_API.G_MISS_NUM,  CREATED_BY        , p_created_by),
      CREATION_DATE       = decode(p_CREATION_DATE,    FND_API.G_MISS_DATE, CREATION_DATE     ,p_CREATION_DATE),
      */
      LAST_UPDATE_LOGIN   = decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM,  LAST_UPDATE_LOGIN ,p_LAST_UPDATE_LOGIN),
      LAST_UPDATE_DATE    = 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),
      OBJECT_VERSION_NUMBER = decode(l_OBJECT_VERSION_NUMBER,  FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER,l_object_version_number)
    WHERE PRIMARY_TRANSFORM_ID    =  p_PRIMARY_TRANSFORM_ID;

Line: 119

 END Update_Row;

Line: 121

PROCEDURE Delete_Row(p_PRIMARY_TRANSFORM_ID NUMBER) IS
BEGIN
   DELETE FROM HZ_PRIMARY_TRANS
   WHERE primary_transform_id = p_primary_transform_id;

Line: 129

 END Delete_Row;

Line: 137

 SELECT OBJECT_VERSION_NUMBER
 FROM hz_primary_trans
 WHERE PRIMARY_TRANSFORM_ID  = p_PRIMARY_TRANSFORM_ID
 FOR UPDATE OF PRIMARY_TRANSFORM_ID NOWAIT;

Line: 147

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

Line: 159

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