APPS.HZ_DUP_MERGE_PARTIES_PKG SQL Statements

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

Line: 4

PROCEDURE Insert_Row(
                      p_DUP_BATCH_ID      IN OUT          NOCOPY NUMBER,
                      p_MERGE_FROM_ID     IN OUT          NOCOPY NUMBER,
                      p_MERGE_TO_ID       IN OUT          NOCOPY NUMBER,
                      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

   INSERT INTO HZ_DUP_MERGE_PARTIES(
                DUP_BATCH_ID,
                MERGE_FROM_ID,
                MERGE_TO_ID,
                CREATED_BY,
                CREATION_DATE,
                LAST_UPDATE_LOGIN,
                LAST_UPDATE_DATE,
                LAST_UPDATED_BY
               )
               VALUES (
                p_DUP_BATCH_ID,
                p_MERGE_FROM_ID,
                p_MERGE_TO_ID,
                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: 38

End Insert_Row;

Line: 41

PROCEDURE Delete_Row(p_DUP_batch_id NUMBER,
                     p_MERGE_FROM_ID   NUMBER,
                     p_MERGE_TO_ID     NUMBER) IS
BEGIN
   DELETE FROM hz_DUP_MERGE_PARTIES
   where DUP_batch_id = p_DUP_batch_id
   AND MERGE_FROM_ID = p_MERGE_FROM_ID
   AND MERGE_TO_ID   = p_MERGE_TO_ID;

Line: 52

 END Delete_Row;

Line: 60

                      p_LAST_UPDATE_LOGIN                 NUMBER,
                      p_LAST_UPDATE_DATE                  DATE,
                      p_LAST_UPDATED_BY                   NUMBER
 ) IS

 CURSOR C IS
 SELECT *
 FROM hz_DUP_MERGE_PARTIES
 WHERE DUP_batch_id  = p_DUP_batch_id
 AND   MERGE_FROM_ID   = p_MERGE_FROM_ID
 AND  MERGE_TO_ID      = P_MERGE_TO_ID
 FOR UPDATE OF DUP_batch_id, MERGE_FROM_ID , MERGE_TO_ID NOWAIT;

Line: 78

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

Line: 99

    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: 111

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