APPS.HZ_DUP_EXCLUSIONS_PKG SQL Statements

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

Line: 4

PROCEDURE Insert_Row(
                      px_DUP_EXCLUSION_ID           IN OUT   NOCOPY NUMBER,
	                  p_PARTY_ID                          NUMBER,
                      p_DUP_PARTY_ID                NUMBER,
                      p_FROM_DATE                         DATE,
                      p_TO_DATE                           DATE,
 		              p_CREATED_BY                        NUMBER,
                      p_CREATION_DATE                     DATE,
                      p_LAST_UPDATE_LOGIN                 NUMBER,
                      p_LAST_UPDATE_DATE                  DATE,
                      p_LAST_UPDATED_BY                   NUMBER)
  IS
  CURSOR C2 IS SELECT  HZ_DUP_EXCLUSIONS_s.nextval FROM sys.dual;

Line: 24

   INSERT INTO HZ_DUP_EXCLUSIONS(
                DUP_EXCLUSION_ID,
                PARTY_ID,
                DUP_PARTY_ID,
                FROM_DATE,
                TO_DATE,
                CREATED_BY,
                CREATION_DATE,
                LAST_UPDATE_LOGIN,
                LAST_UPDATE_DATE,
                LAST_UPDATED_BY
               )
               VALUES (
                px_DUP_EXCLUSION_ID,
                decode(p_PARTY_ID, FND_API.G_MISS_NUM, NULL,
                                   p_PARTY_ID),
                decode(p_DUP_PARTY_ID, FND_API.G_MISS_NUM, NULL,
                                   p_DUP_PARTY_ID),
                decode(p_from_date, FND_API.G_MISS_DATE, NULL,
                                        p_from_date),
                decode(p_to_date, FND_API.G_MISS_DATE, NULL,
                                        p_to_date),
                hz_utility_v2pub.created_by,
                hz_utility_v2pub.creation_date,
                hz_utility_v2pub.last_update_login,
                hz_utility_v2pub.last_update_date,
                hz_utility_v2pub.last_updated_by
              );

Line: 53

End Insert_Row;

Line: 55

PROCEDURE Update_Row(
                      p_DUP_EXCLUSION_ID                  NUMBER,
	              p_PARTY_ID                          NUMBER,
                      p_DUP_PARTY_ID                      NUMBER,
                      p_FROM_DATE                         DATE,
                      p_TO_DATE                           DATE,
                      p_CREATED_BY                        NUMBER,
                      p_CREATION_DATE                     DATE,
                      p_LAST_UPDATE_LOGIN                 NUMBER,
                      p_LAST_UPDATE_DATE                  DATE,
                      p_LAST_UPDATED_BY                   NUMBER
   ) IS
   BEGIN
   UPDATE HZ_DUP_EXCLUSIONS
   SET
    PARTY_ID             = decode(p_PARTY_ID, FND_API.G_MISS_NUM, NULL,
                                  p_PARTY_ID),
    DUP_PARTY_ID   = decode(p_DUP_PARTY_ID, FND_API.G_MISS_NUM, NULL,
                                  p_DUP_PARTY_ID),
    FROM_DATE            = decode(p_FROM_DATE,FND_API.G_MISS_DATE, NULL,
                                  p_FROM_DATE),
    TO_DATE              = decode(p_TO_DATE,FND_API.G_MISS_DATE, NULL,
                                  p_TO_DATE),
    CREATED_BY           = created_by,
    CREATION_DATE        = CREATION_DATE,
    LAST_UPDATE_LOGIN    = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
    LAST_UPDATE_DATE       = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
    LAST_UPDATED_BY        = hz_utility_v2pub.LAST_UPDATED_BY
    where DUP_exclusion_id = p_DUP_exclusion_id;

Line: 89

 END Update_Row;

Line: 91

PROCEDURE Delete_Row(p_DUP_exclusion_id NUMBER) IS
BEGIN
   DELETE FROM hz_DUP_exclusions
   where DUP_exclusion_id = p_DUP_exclusion_id ;

Line: 99

 END Delete_Row;

Line: 109

                    p_LAST_UPDATE_LOGIN                 NUMBER,
                    p_LAST_UPDATE_DATE                  DATE,
                    p_LAST_UPDATED_BY                   NUMBER
 ) IS
 CURSOR C IS
 SELECT *
 FROM hz_DUP_exclusions
 WHERE DUP_exclusion_id  = p_DUP_exclusion_id
 FOR UPDATE OF DUP_exclusion_id NOWAIT;

Line: 124

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

Line: 151

    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.LAST_UPDATE_DATE = p_LAST_UPDATE_DATE)
             OR (     (Recinfo.LAST_UPDATE_DATE   IS NULL)
                 AND (p_LAST_UPDATE_DATE  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 )))
      ) then
       return;

Line: 163

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