APPS.HZ_MATCH_RULE_PRIMARY_PKG SQL Statements

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

Line: 3

PROCEDURE Insert_Row(
                    px_PRIMARY_ATTRIBUTE_ID IN OUT NOCOPY   NUMBER,
                    p_MATCH_RULE_ID                   NUMBER,
                    p_ATTRIBUTE_ID                    NUMBER,
                    p_ACTIVE_FLAG                     VARCHAR2,
                    p_FILTER_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_PRIMARY_s.nextval FROM sys.dual;

Line: 28

     INSERT INTO HZ_MATCH_RULE_PRIMARY(
                PRIMARY_ATTRIBUTE_ID,
                MATCH_RULE_ID,
                ATTRIBUTE_ID,
                ACTIVE_FLAG,
                FILTER_FLAG,
                CREATED_BY,
                CREATION_DATE,
                LAST_UPDATE_LOGIN,
                LAST_UPDATE_DATE,
                LAST_UPDATED_BY,
                OBJECT_VERSION_NUMBER,
		DISPLAY_ORDER
               )
               VALUES (
                px_PRIMARY_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_ACTIVE_FLAG,      FND_API.G_MISS_CHAR, NULL, p_ACTIVE_FLAG),
                decode(p_FILTER_FLAG,      FND_API.G_MISS_CHAR, NULL, p_FILTER_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,
		decode(p_DISPLAY_ORDER, FND_API.G_MISS_NUM, NULL, p_DISPLAY_ORDER)
                );

Line: 65

                 SELECT  HZ_MATCH_RULE_PRIMARY_s.nextval
		  into  px_PRIMARY_ATTRIBUTE_ID FROM sys.dual;

Line: 68

                  SELECT 'Y' INTO l_dummy
                  FROM HZ_MATCH_RULE_PRIMARY
                  WHERE PRIMARY_ATTRIBUTE_ID =  px_PRIMARY_ATTRIBUTE_ID;

Line: 80

End Insert_Row;

Line: 82

    PROCEDURE Update_Row(
                    p_PRIMARY_ATTRIBUTE_ID           NUMBER,
                    p_MATCH_RULE_ID                   NUMBER,
                    p_ATTRIBUTE_ID                    NUMBER,
                    p_ACTIVE_FLAG                     VARCHAR2,
                    p_FILTER_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: 103

   UPDATE hz_match_rule_primary
   SET
      MATCH_RULE_ID         = decode(p_MATCH_RULE_ID,     FND_API.G_MISS_NUM, MATCH_RULE_ID, p_MATCH_RULE_ID),
      ATTRIBUTE_ID          = decode(p_ATTRIBUTE_ID,     FND_API.G_MISS_NUM, ATTRIBUTE_ID, p_ATTRIBUTE_ID),
      ACTIVE_FLAG           = decode(p_ACTIVE_FLAG,      FND_API.G_MISS_CHAR, ACTIVE_FLAG, p_ACTIVE_FLAG),
      FILTER_FLAG           = decode(p_FILTER_FLAG,      FND_API.G_MISS_CHAR, FILTER_FLAG, p_FILTER_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),
      DISPLAY_ORDER         = decode(p_DISPLAY_ORDER,   FND_API.G_MISS_NUM, DISPLAY_ORDER, p_DISPLAY_ORDER)
      WHERE PRIMARY_ATTRIBUTE_ID = P_PRIMARY_ATTRIBUTE_ID;

Line: 126

 END Update_Row;

Line: 128

PROCEDURE Delete_Row(p_primary_attribute_id NUMBER) IS
BEGIN
   DELETE FROM HZ_MATCH_RULE_PRIMARY
   WHERE primary_attribute_id    =  p_primary_attribute_id;

Line: 136

 END Delete_Row;

Line: 144

 SELECT OBJECT_VERSION_NUMBER
 FROM hz_match_rule_primary
 WHERE primary_attribute_id  = p_primary_attribute_id
 FOR UPDATE OF primary_attribute_id NOWAIT;

Line: 154

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

Line: 167

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