APPS.HZ_SECONDARY_TRANSFORM_PKG SQL Statements

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

Line: 5

PROCEDURE Insert_Row(
                    px_SECONDARY_TRANSFORM_ID IN OUT NOCOPY     NUMBER,
                    p_SECONDARY_ATTRIBUTE_ID            NUMBER,
                    p_FUNCTION_ID                      NUMBER,
                    p_TRANSFORMATION_WEIGHT            NUMBER,
                    p_SIMILARITY_CUTOFF                NUMBER,
                    p_ACTIVE_FLAG                      VARCHAR2,
                    p_USE_EXACT                        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_SECONDARY_TRANS_S.nextval FROM sys.dual;

Line: 31

       INSERT INTO HZ_SECONDARY_TRANS(
                SECONDARY_TRANSFORM_ID,
                SECONDARY_ATTRIBUTE_ID,
                FUNCTION_ID,
                TRANSFORMATION_WEIGHT ,
                SIMILARITY_CUTOFF ,
                ACTIVE_FLAG,
                USE_EXACT,
                CREATED_BY,
                CREATION_DATE,
                LAST_UPDATE_LOGIN,
                LAST_UPDATE_DATE,
                LAST_UPDATED_BY,
                OBJECT_VERSION_NUMBER
               )
               VALUES (
                px_SECONDARY_TRANSFORM_ID,
                decode(p_SECONDARY_ATTRIBUTE_ID , FND_API.G_MISS_NUM   , NULL, p_SECONDARY_ATTRIBUTE_ID),
                decode(p_FUNCTION_ID,             FND_API.G_MISS_NUM   , NULL, p_FUNCTION_ID),
                decode(p_TRANSFORMATION_WEIGHT,   FND_API.G_MISS_NUM   , NULL, p_TRANSFORMATION_WEIGHT),
                decode(p_SIMILARITY_CUTOFF,       FND_API.G_MISS_NUM   , NULL, p_SIMILARITY_CUTOFF),
                decode(p_ACTIVE_FLAG,             FND_API.G_MISS_CHAR  ,NULL, p_ACTIVE_FLAG),
                decode(p_USE_EXACT,             FND_API.G_MISS_CHAR  ,NULL, p_USE_EXACT),
                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: 71

                 SELECT  HZ_MATCH_RULE_SECONDARY_s.nextval
		  into  px_SECONDARY_TRANSFORM_ID FROM sys.dual;

Line: 74

                  SELECT 'Y' INTO l_dummy
                  FROM HZ_MATCH_RULE_SECONDARY
                  WHERE SECONDARY_ATTRIBUTE_ID =  px_SECONDARY_TRANSFORM_ID ;

Line: 86

End Insert_Row;

Line: 88

    PROCEDURE Update_Row(
                    p_SECONDARY_TRANSFORM_ID            NUMBER,
                    p_SECONDARY_ATTRIBUTE_ID            NUMBER,
                    p_FUNCTION_ID                     NUMBER,
                    p_TRANSFORMATION_WEIGHT            NUMBER,
                    p_SIMILARITY_CUTOFF                NUMBER,
                    p_ACTIVE_FLAG                     VARCHAR2,
                    p_USE_EXACT                       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: 109

   UPDATE hz_SECONDARY_trans
   SET
      SECONDARY_ATTRIBUTE_ID = decode(p_SECONDARY_ATTRIBUTE_ID ,FND_API.G_MISS_NUM,SECONDARY_ATTRIBUTE_ID,
                                      p_SECONDARY_ATTRIBUTE_ID),
      FUNCTION_ID            = decode(p_FUNCTION_ID             ,FND_API.G_MISS_NUM,FUNCTION_ID,
                                      p_FUNCTION_ID),
      TRANSFORMATION_WEIGHT  = decode(p_TRANSFORMATION_WEIGHT   ,FND_API.G_MISS_NUM,TRANSFORMATION_WEIGHT,
                                      p_TRANSFORMATION_WEIGHT),
      SIMILARITY_CUTOFF      = decode(p_SIMILARITY_CUTOFF       ,FND_API.G_MISS_NUM,SIMILARITY_CUTOFF,
                                      p_SIMILARITY_CUTOFF),
      ACTIVE_FLAG            = decode(p_ACTIVE_FLAG             ,FND_API.G_MISS_CHAR,ACTIVE_FLAG,
                                      p_ACTIVE_FLAG),
      USE_EXACT            = decode(p_USE_EXACT             ,FND_API.G_MISS_CHAR,USE_EXACT,
                                      p_USE_EXACT),
      -- 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 SECONDARY_TRANSFORM_ID    =  p_SECONDARY_TRANSFORM_ID;

Line: 144

 END Update_Row;

Line: 146

PROCEDURE Delete_Row(p_SECONDARY_TRANSFORM_ID NUMBER) IS
BEGIN
   DELETE FROM HZ_SECONDARY_TRANS
   WHERE SECONDARY_transform_id = p_SECONDARY_transform_id;

Line: 154

 END Delete_Row;

Line: 162

 SELECT OBJECT_VERSION_NUMBER
 FROM hz_SECONDARY_trans
 WHERE SECONDARY_TRANSFORM_ID  = p_SECONDARY_TRANSFORM_ID
 FOR UPDATE OF SECONDARY_TRANSFORM_ID NOWAIT;

Line: 172

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

Line: 184

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