APPS.HZ_MATCH_RULE_SECONDARY_PKG SQL Statements

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

Line: 3

PROCEDURE Insert_Row(
                    px_SECONDARY_ATTRIBUTE_ID IN OUT NOCOPY   NUMBER,
                    p_MATCH_RULE_ID                   NUMBER,
                    p_ATTRIBUTE_ID                    NUMBER,
                    p_SCORE                           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,
		    p_DISPLAY_ORDER		      NUMBER DEFAULT NULL)
 IS
  CURSOR C2 IS SELECT  HZ_MATCH_RULE_SECONDARY_s.nextval FROM sys.dual;

Line: 30

      INSERT INTO HZ_MATCH_RULE_SECONDARY(
                SECONDARY_ATTRIBUTE_ID,
                MATCH_RULE_ID,
                ATTRIBUTE_ID,
                SCORE,
                ACTIVE_FLAG,
                CREATED_BY,
                CREATION_DATE,
                LAST_UPDATE_LOGIN,
                LAST_UPDATE_DATE,
                LAST_UPDATED_BY,
                OBJECT_VERSION_NUMBER,
		DISPLAY_ORDER
               )
               VALUES (
                px_SECONDARY_ATTRIBUTE_ID,
                decode(p_MATCH_RULE_ID,    FND_API.G_MISS_NUM, NULL, p_MATCH_RULE_ID),
                decode(p_ATTRIBUTE_ID,     FND_API.G_MISS_NUM, NULL, p_ATTRIBUTE_ID),
                decode(p_SCORE,            FND_API.G_MISS_NUM, NULL, p_SCORE),
                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, 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, NULL, p_last_update_date),
                decode(p_last_updated_by,  FND_API.G_MISS_NUM,  NULL, p_last_updated_by),
                 1,
                decode(p_DISPLAY_ORDER,    FND_API.G_MISS_NUM, NULL, p_DISPLAY_ORDER)
                );

Line: 68

                 SELECT  HZ_MATCH_RULE_SECONDARY_s.nextval
		  into  px_SECONDARY_ATTRIBUTE_ID FROM sys.dual;

Line: 71

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

Line: 84

End Insert_Row;

Line: 86

    PROCEDURE Update_Row(
                    p_SECONDARY_ATTRIBUTE_ID           NUMBER,
                    p_MATCH_RULE_ID                   NUMBER,
                    p_ATTRIBUTE_ID                    NUMBER,
                    p_SCORE                           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,
		    p_DISPLAY_ORDER		      NUMBER DEFAULT NULL
     ) IS

    l_object_version_number number;

Line: 107

   UPDATE hz_match_rule_SECONDARY
   SET
      MATCH_RULE_ID       = decode(p_MATCH_RULE_ID,    FND_API.G_MISS_NUM, NULL, p_MATCH_RULE_ID),
      ATTRIBUTE_ID        = decode(p_ATTRIBUTE_ID,     FND_API.G_MISS_NUM, NULL, p_ATTRIBUTE_ID),
      SCORE               = decode(p_SCORE,            FND_API.G_MISS_CHAR, NULL, p_SCORE),
      ACTIVE_FLAG         = decode(p_ACTIVE_FLAG,      FND_API.G_MISS_CHAR, NULL, p_ACTIVE_FLAG),
      -- Bug 3032780
      /*
      CREATED_BY          = decode(p_created_by,       FND_API.G_MISS_NUM,  NULL, p_created_by),
      CREATION_DATE       = decode(p_CREATION_DATE,    FND_API.G_MISS_DATE, NULL,p_CREATION_DATE),
      */
      LAST_UPDATE_LOGIN   = decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM, NULL,p_LAST_UPDATE_LOGIN),
      LAST_UPDATE_DATE    = decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL,p_LAST_UPDATE_DATE),
      LAST_UPDATED_BY     = decode(p_LAST_UPDATED_BY,  FND_API.G_MISS_NUM, NULL,p_LAST_UPDATED_BY),
      OBJECT_VERSION_NUMBER = decode(l_OBJECT_VERSION_NUMBER,  FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER,l_object_version_number),
      DISPLAY_ORDER       = decode(p_DISPLAY_ORDER,   FND_API.G_MISS_NUM, DISPLAY_ORDER,p_DISPLAY_ORDER)
    WHERE SECONDARY_attribute_id    =  p_SECONDARY_attribute_id;

Line: 130

 END Update_Row;

Line: 132

PROCEDURE Delete_Row(p_SECONDARY_attribute_id NUMBER) IS
BEGIN
   DELETE FROM HZ_MATCH_RULE_SECONDARY
   WHERE SECONDARY_attribute_id    =  p_SECONDARY_attribute_id;

Line: 140

 END Delete_Row;

Line: 148

 SELECT OBJECT_VERSION_NUMBER
 FROM hz_match_rule_SECONDARY
 WHERE SECONDARY_attribute_id  = p_SECONDARY_attribute_id
 FOR UPDATE OF SECONDARY_attribute_id NOWAIT;

Line: 158

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

Line: 171

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