eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_PAY_APPROVAL_FLOW_PKG SQL Statements

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

Line: 15


PROCEDURE insert_row
    ( p_pay_approval_flow_rec IN PAY_APPROVAL_FLOW_REC_TYPE) IS

BEGIN

   INSERT into CN_PAY_APPROVAL_FLOW
      ( PAY_APPROVAL_FLOW_ID,
        PAYRUN_ID,
        PAYMENT_WORKSHEET_ID,
        SUBMIT_BY_RESOURCE_ID,
        SUBMIT_BY_USER_ID,
        SUBMIT_BY_EMAIL,
        SUBMIT_TO_RESOURCE_ID,
        SUBMIT_TO_USER_ID,
        SUBMIT_TO_EMAIL,
        APPROVAL_STATUS,
        UPDATED_BY_RESOURCE_ID,
        ATTRIBUTE_CATEGORY,
        ATTRIBUTE1,
        ATTRIBUTE2,
        ATTRIBUTE3,
        ATTRIBUTE4,
        ATTRIBUTE5,
        ATTRIBUTE6,
        ATTRIBUTE7,
        ATTRIBUTE8,
        ATTRIBUTE9,
        ATTRIBUTE10,
        ATTRIBUTE11,
        ATTRIBUTE12,
        ATTRIBUTE13,
        ATTRIBUTE14,
        ATTRIBUTE15,
        CREATION_DATE,
        CREATED_BY,
        LAST_UPDATE_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_LOGIN,
        OBJECT_VERSION_NUMBER,
        ORG_ID)
    select
       DECODE(p_pay_approval_flow_rec.PAY_APPROVAL_FLOW_ID, FND_API.G_MISS_NUM, NULL,
              p_pay_approval_flow_rec.PAY_APPROVAL_FLOW_ID),
       DECODE(p_pay_approval_flow_rec.PAYRUN_ID, FND_API.G_MISS_NUM, NULL,
              p_pay_approval_flow_rec.PAYRUN_ID),
       DECODE(p_pay_approval_flow_rec.PAYMENT_WORKSHEET_ID, FND_API.G_MISS_NUM, NULL,
              p_pay_approval_flow_rec.PAYMENT_WORKSHEET_ID),
       DECODE(p_pay_approval_flow_rec.SUBMIT_BY_RESOURCE_ID, FND_API.G_MISS_NUM, NULL,
              p_pay_approval_flow_rec.SUBMIT_BY_RESOURCE_ID),
       DECODE(p_pay_approval_flow_rec.SUBMIT_BY_USER_ID, FND_API.G_MISS_NUM, NULL,
              p_pay_approval_flow_rec.SUBMIT_BY_USER_ID),
       DECODE(p_pay_approval_flow_rec.SUBMIT_BY_EMAIL, FND_API.G_MISS_CHAR, NULL,
              p_pay_approval_flow_rec.SUBMIT_BY_EMAIL),
       DECODE(p_pay_approval_flow_rec.SUBMIT_TO_RESOURCE_ID, FND_API.G_MISS_NUM, NULL,
              p_pay_approval_flow_rec.SUBMIT_TO_RESOURCE_ID),
       DECODE(p_pay_approval_flow_rec.SUBMIT_TO_USER_ID, FND_API.G_MISS_NUM, NULL,
              p_pay_approval_flow_rec.SUBMIT_TO_USER_ID),
       DECODE(p_pay_approval_flow_rec.SUBMIT_TO_EMAIL, FND_API.G_MISS_CHAR, NULL,
              p_pay_approval_flow_rec.SUBMIT_TO_EMAIL),
       DECODE(p_pay_approval_flow_rec.APPROVAL_STATUS, FND_API.G_MISS_CHAR, NULL,
              p_pay_approval_flow_rec.APPROVAL_STATUS),
       DECODE(p_pay_approval_flow_rec.UPDATED_BY_RESOURCE_ID, FND_API.G_MISS_NUM, NULL,
              p_pay_approval_flow_rec.UPDATED_BY_RESOURCE_ID),
       DECODE(p_pay_approval_flow_rec.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,
              p_pay_approval_flow_rec.ATTRIBUTE_CATEGORY),
       DECODE(p_pay_approval_flow_rec.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,
              p_pay_approval_flow_rec.ATTRIBUTE1),
       DECODE(p_pay_approval_flow_rec.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,
              p_pay_approval_flow_rec.ATTRIBUTE2),
       DECODE(p_pay_approval_flow_rec.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,
              p_pay_approval_flow_rec.ATTRIBUTE3),
       DECODE(p_pay_approval_flow_rec.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,
              p_pay_approval_flow_rec.ATTRIBUTE4),
       DECODE(p_pay_approval_flow_rec.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,
              p_pay_approval_flow_rec.ATTRIBUTE5),
       DECODE(p_pay_approval_flow_rec.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,
              p_pay_approval_flow_rec.ATTRIBUTE6),
       DECODE(p_pay_approval_flow_rec.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,
              p_pay_approval_flow_rec.ATTRIBUTE7),
       DECODE(p_pay_approval_flow_rec.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,
              p_pay_approval_flow_rec.ATTRIBUTE8),
       DECODE(p_pay_approval_flow_rec.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,
              p_pay_approval_flow_rec.ATTRIBUTE9),
       DECODE(p_pay_approval_flow_rec.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,
              p_pay_approval_flow_rec.ATTRIBUTE10),
       DECODE(p_pay_approval_flow_rec.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,
              p_pay_approval_flow_rec.ATTRIBUTE11),
       DECODE(p_pay_approval_flow_rec.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,
              p_pay_approval_flow_rec.ATTRIBUTE12),
       DECODE(p_pay_approval_flow_rec.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,
              p_pay_approval_flow_rec.ATTRIBUTE13),
       DECODE(p_pay_approval_flow_rec.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL,
              p_pay_approval_flow_rec.ATTRIBUTE14),
       DECODE(p_pay_approval_flow_rec.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL,
              p_pay_approval_flow_rec.ATTRIBUTE15),
        Sysdate,
        fnd_global.user_id,
        Sysdate,
        fnd_global.user_id,
        fnd_global.login_id,
        1,
        p_pay_approval_flow_rec.org_id
   from dual;

Line: 119


END insert_row;

Line: 133


PROCEDURE update_row
    ( p_pay_approval_flow_rec IN PAY_APPROVAL_FLOW_REC_TYPE) IS

BEGIN

   UPDATE CN_PAY_APPROVAL_FLOW oldrec
      SET
         PAYRUN_ID = DECODE(p_pay_approval_flow_rec.PAYRUN_ID,
                                      FND_API.G_MISS_NUM,
                                      NULL,
                                      NULL,
                                      oldrec.PAYRUN_ID,
                                      p_pay_approval_flow_rec.PAYRUN_ID),
         PAYMENT_WORKSHEET_ID = DECODE(p_pay_approval_flow_rec.PAYMENT_WORKSHEET_ID,
                                      FND_API.G_MISS_NUM,
                                      NULL,
                                      NULL,
                                      oldrec.PAYMENT_WORKSHEET_ID,
                                      p_pay_approval_flow_rec.PAYMENT_WORKSHEET_ID),
         SUBMIT_BY_RESOURCE_ID = DECODE(p_pay_approval_flow_rec.SUBMIT_BY_RESOURCE_ID,
                                      FND_API.G_MISS_NUM,
                                      NULL,
                                      NULL,
                                      oldrec.SUBMIT_BY_RESOURCE_ID,
                                      p_pay_approval_flow_rec.SUBMIT_BY_RESOURCE_ID),
         SUBMIT_BY_USER_ID = DECODE(p_pay_approval_flow_rec.SUBMIT_BY_USER_ID,
                                      FND_API.G_MISS_NUM,
                                      NULL,
                                      NULL,
                                      oldrec.SUBMIT_BY_USER_ID,
                                      p_pay_approval_flow_rec.SUBMIT_BY_USER_ID),
         SUBMIT_BY_EMAIL = DECODE(p_pay_approval_flow_rec.SUBMIT_BY_EMAIL,
                                      FND_API.G_MISS_CHAR,
                                      NULL,
                                      NULL,
                                      oldrec.SUBMIT_BY_EMAIL,
                                      p_pay_approval_flow_rec.SUBMIT_BY_EMAIL),
         SUBMIT_TO_RESOURCE_ID = DECODE(p_pay_approval_flow_rec.SUBMIT_TO_RESOURCE_ID,
                                      FND_API.G_MISS_NUM,
                                      NULL,
                                      NULL,
                                      oldrec.SUBMIT_TO_RESOURCE_ID,
                                      p_pay_approval_flow_rec.SUBMIT_TO_RESOURCE_ID),
         SUBMIT_TO_USER_ID = DECODE(p_pay_approval_flow_rec.SUBMIT_TO_USER_ID,
                                      FND_API.G_MISS_NUM,
                                      NULL,
                                      NULL,
                                      oldrec.SUBMIT_TO_USER_ID,
                                      p_pay_approval_flow_rec.SUBMIT_TO_USER_ID),
         SUBMIT_TO_EMAIL = DECODE(p_pay_approval_flow_rec.SUBMIT_TO_EMAIL,
                                      FND_API.G_MISS_CHAR,
                                      NULL,
                                      NULL,
                                      oldrec.SUBMIT_TO_EMAIL,
                                      p_pay_approval_flow_rec.SUBMIT_TO_EMAIL),
         APPROVAL_STATUS = DECODE(p_pay_approval_flow_rec.APPROVAL_STATUS,
                                      FND_API.G_MISS_CHAR,
                                      NULL,
                                      NULL,
                                      oldrec.APPROVAL_STATUS,
                                      p_pay_approval_flow_rec.APPROVAL_STATUS),
         UPDATED_BY_RESOURCE_ID = DECODE(p_pay_approval_flow_rec.UPDATED_BY_RESOURCE_ID,
                                      FND_API.G_MISS_NUM,
                                      NULL,
                                      NULL,
                                      oldrec.UPDATED_BY_RESOURCE_ID,
                                      p_pay_approval_flow_rec.UPDATED_BY_RESOURCE_ID),
         ATTRIBUTE_CATEGORY = DECODE(p_pay_approval_flow_rec.ATTRIBUTE_CATEGORY,
                                      FND_API.G_MISS_CHAR,
                                      NULL,
                                      NULL,
                                      oldrec.ATTRIBUTE_CATEGORY,
                                      p_pay_approval_flow_rec.ATTRIBUTE_CATEGORY),
         ATTRIBUTE1 = DECODE(p_pay_approval_flow_rec.ATTRIBUTE1,
                                      FND_API.G_MISS_CHAR,
                                      NULL,
                                      NULL,
                                      oldrec.ATTRIBUTE1,
                                      p_pay_approval_flow_rec.ATTRIBUTE1),
         ATTRIBUTE2 = DECODE(p_pay_approval_flow_rec.ATTRIBUTE2,
                                      FND_API.G_MISS_CHAR,
                                      NULL,
                                      NULL,
                                      oldrec.ATTRIBUTE2,
                                      p_pay_approval_flow_rec.ATTRIBUTE2),
         ATTRIBUTE3 = DECODE(p_pay_approval_flow_rec.ATTRIBUTE3,
                                      FND_API.G_MISS_CHAR,
                                      NULL,
                                      NULL,
                                      oldrec.ATTRIBUTE3,
                                      p_pay_approval_flow_rec.ATTRIBUTE3),
         ATTRIBUTE4 = DECODE(p_pay_approval_flow_rec.ATTRIBUTE4,
                                      FND_API.G_MISS_CHAR,
                                      NULL,
                                      NULL,
                                      oldrec.ATTRIBUTE4,
                                      p_pay_approval_flow_rec.ATTRIBUTE4),
         ATTRIBUTE5 = DECODE(p_pay_approval_flow_rec.ATTRIBUTE5,
                                      FND_API.G_MISS_CHAR,
                                      NULL,
                                      NULL,
                                      oldrec.ATTRIBUTE5,
                                      p_pay_approval_flow_rec.ATTRIBUTE5),
         ATTRIBUTE6 = DECODE(p_pay_approval_flow_rec.ATTRIBUTE6,
                                      FND_API.G_MISS_CHAR,
                                      NULL,
                                      NULL,
                                      oldrec.ATTRIBUTE6,
                                      p_pay_approval_flow_rec.ATTRIBUTE6),
         ATTRIBUTE7 = DECODE(p_pay_approval_flow_rec.ATTRIBUTE7,
                                      FND_API.G_MISS_CHAR,
                                      NULL,
                                      NULL,
                                      oldrec.ATTRIBUTE7,
                                      p_pay_approval_flow_rec.ATTRIBUTE7),
         ATTRIBUTE8 = DECODE(p_pay_approval_flow_rec.ATTRIBUTE8,
                                      FND_API.G_MISS_CHAR,
                                      NULL,
                                      NULL,
                                      oldrec.ATTRIBUTE8,
                                      p_pay_approval_flow_rec.ATTRIBUTE8),
         ATTRIBUTE9 = DECODE(p_pay_approval_flow_rec.ATTRIBUTE9,
                                      FND_API.G_MISS_CHAR,
                                      NULL,
                                      NULL,
                                      oldrec.ATTRIBUTE9,
                                      p_pay_approval_flow_rec.ATTRIBUTE9),
         ATTRIBUTE10 = DECODE(p_pay_approval_flow_rec.ATTRIBUTE10,
                                      FND_API.G_MISS_CHAR,
                                      NULL,
                                      NULL,
                                      oldrec.ATTRIBUTE10,
                                      p_pay_approval_flow_rec.ATTRIBUTE10),
         ATTRIBUTE11 = DECODE(p_pay_approval_flow_rec.ATTRIBUTE11,
                                      FND_API.G_MISS_CHAR,
                                      NULL,
                                      NULL,
                                      oldrec.ATTRIBUTE11,
                                      p_pay_approval_flow_rec.ATTRIBUTE11),
         ATTRIBUTE12 = DECODE(p_pay_approval_flow_rec.ATTRIBUTE12,
                                      FND_API.G_MISS_CHAR,
                                      NULL,
                                      NULL,
                                      oldrec.ATTRIBUTE12,
                                      p_pay_approval_flow_rec.ATTRIBUTE12),
         ATTRIBUTE13 = DECODE(p_pay_approval_flow_rec.ATTRIBUTE13,
                                      FND_API.G_MISS_CHAR,
                                      NULL,
                                      NULL,
                                      oldrec.ATTRIBUTE13,
                                      p_pay_approval_flow_rec.ATTRIBUTE13),
         ATTRIBUTE14 = DECODE(p_pay_approval_flow_rec.ATTRIBUTE14,
                                      FND_API.G_MISS_CHAR,
                                      NULL,
                                      NULL,
                                      oldrec.ATTRIBUTE14,
                                      p_pay_approval_flow_rec.ATTRIBUTE14),
         ATTRIBUTE15 = DECODE(p_pay_approval_flow_rec.ATTRIBUTE15,
                                      FND_API.G_MISS_CHAR,
                                      NULL,
                                      NULL,
                                      oldrec.ATTRIBUTE15,
                                      p_pay_approval_flow_rec.ATTRIBUTE15),
         LAST_UPDATE_DATE = Sysdate,
         LAST_UPDATED_BY = fnd_global.user_id,
         LAST_UPDATE_LOGIN = fnd_global.login_id,
         OBJECT_VERSION_NUMBER = oldrec.OBJECT_VERSION_NUMBER + 1
     WHERE pay_approval_flow_id = p_pay_approval_flow_rec.pay_approval_flow_id;

Line: 306


END update_row;

Line: 320


PROCEDURE lock_update_row
    ( p_pay_approval_flow_rec IN PAY_APPROVAL_FLOW_REC_TYPE) IS

   CURSOR c IS
     SELECT object_version_number
       FROM CN_PAY_APPROVAL_FLOW
     WHERE pay_approval_flow_id = p_pay_approval_flow_rec.pay_approval_flow_id;

Line: 335


      fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 346


   UPDATE CN_PAY_APPROVAL_FLOW oldrec
      SET
         PAYRUN_ID = DECODE(p_pay_approval_flow_rec.PAYRUN_ID,
                                      FND_API.G_MISS_NUM,
                                      NULL,
                                      NULL,
                                      oldrec.PAYRUN_ID,
                                      p_pay_approval_flow_rec.PAYRUN_ID),
         PAYMENT_WORKSHEET_ID = DECODE(p_pay_approval_flow_rec.PAYMENT_WORKSHEET_ID,
                                      FND_API.G_MISS_NUM,
                                      NULL,
                                      NULL,
                                      oldrec.PAYMENT_WORKSHEET_ID,
                                      p_pay_approval_flow_rec.PAYMENT_WORKSHEET_ID),
         SUBMIT_BY_RESOURCE_ID = DECODE(p_pay_approval_flow_rec.SUBMIT_BY_RESOURCE_ID,
                                      FND_API.G_MISS_NUM,
                                      NULL,
                                      NULL,
                                      oldrec.SUBMIT_BY_RESOURCE_ID,
                                      p_pay_approval_flow_rec.SUBMIT_BY_RESOURCE_ID),
         SUBMIT_BY_USER_ID = DECODE(p_pay_approval_flow_rec.SUBMIT_BY_USER_ID,
                                      FND_API.G_MISS_NUM,
                                      NULL,
                                      NULL,
                                      oldrec.SUBMIT_BY_USER_ID,
                                      p_pay_approval_flow_rec.SUBMIT_BY_USER_ID),
         SUBMIT_BY_EMAIL = DECODE(p_pay_approval_flow_rec.SUBMIT_BY_EMAIL,
                                      FND_API.G_MISS_CHAR,
                                      NULL,
                                      NULL,
                                      oldrec.SUBMIT_BY_EMAIL,
                                      p_pay_approval_flow_rec.SUBMIT_BY_EMAIL),
         SUBMIT_TO_RESOURCE_ID = DECODE(p_pay_approval_flow_rec.SUBMIT_TO_RESOURCE_ID,
                                      FND_API.G_MISS_NUM,
                                      NULL,
                                      NULL,
                                      oldrec.SUBMIT_TO_RESOURCE_ID,
                                      p_pay_approval_flow_rec.SUBMIT_TO_RESOURCE_ID),
         SUBMIT_TO_USER_ID = DECODE(p_pay_approval_flow_rec.SUBMIT_TO_USER_ID,
                                      FND_API.G_MISS_NUM,
                                      NULL,
                                      NULL,
                                      oldrec.SUBMIT_TO_USER_ID,
                                      p_pay_approval_flow_rec.SUBMIT_TO_USER_ID),
         SUBMIT_TO_EMAIL = DECODE(p_pay_approval_flow_rec.SUBMIT_TO_EMAIL,
                                      FND_API.G_MISS_CHAR,
                                      NULL,
                                      NULL,
                                      oldrec.SUBMIT_TO_EMAIL,
                                      p_pay_approval_flow_rec.SUBMIT_TO_EMAIL),
         APPROVAL_STATUS = DECODE(p_pay_approval_flow_rec.APPROVAL_STATUS,
                                      FND_API.G_MISS_CHAR,
                                      NULL,
                                      NULL,
                                      oldrec.APPROVAL_STATUS,
                                      p_pay_approval_flow_rec.APPROVAL_STATUS),
         UPDATED_BY_RESOURCE_ID = DECODE(p_pay_approval_flow_rec.UPDATED_BY_RESOURCE_ID,
                                      FND_API.G_MISS_NUM,
                                      NULL,
                                      NULL,
                                      oldrec.UPDATED_BY_RESOURCE_ID,
                                      p_pay_approval_flow_rec.UPDATED_BY_RESOURCE_ID),
         ATTRIBUTE_CATEGORY = DECODE(p_pay_approval_flow_rec.ATTRIBUTE_CATEGORY,
                                      FND_API.G_MISS_CHAR,
                                      NULL,
                                      NULL,
                                      oldrec.ATTRIBUTE_CATEGORY,
                                      p_pay_approval_flow_rec.ATTRIBUTE_CATEGORY),
         ATTRIBUTE1 = DECODE(p_pay_approval_flow_rec.ATTRIBUTE1,
                                      FND_API.G_MISS_CHAR,
                                      NULL,
                                      NULL,
                                      oldrec.ATTRIBUTE1,
                                      p_pay_approval_flow_rec.ATTRIBUTE1),
         ATTRIBUTE2 = DECODE(p_pay_approval_flow_rec.ATTRIBUTE2,
                                      FND_API.G_MISS_CHAR,
                                      NULL,
                                      NULL,
                                      oldrec.ATTRIBUTE2,
                                      p_pay_approval_flow_rec.ATTRIBUTE2),
         ATTRIBUTE3 = DECODE(p_pay_approval_flow_rec.ATTRIBUTE3,
                                      FND_API.G_MISS_CHAR,
                                      NULL,
                                      NULL,
                                      oldrec.ATTRIBUTE3,
                                      p_pay_approval_flow_rec.ATTRIBUTE3),
         ATTRIBUTE4 = DECODE(p_pay_approval_flow_rec.ATTRIBUTE4,
                                      FND_API.G_MISS_CHAR,
                                      NULL,
                                      NULL,
                                      oldrec.ATTRIBUTE4,
                                      p_pay_approval_flow_rec.ATTRIBUTE4),
         ATTRIBUTE5 = DECODE(p_pay_approval_flow_rec.ATTRIBUTE5,
                                      FND_API.G_MISS_CHAR,
                                      NULL,
                                      NULL,
                                      oldrec.ATTRIBUTE5,
                                      p_pay_approval_flow_rec.ATTRIBUTE5),
         ATTRIBUTE6 = DECODE(p_pay_approval_flow_rec.ATTRIBUTE6,
                                      FND_API.G_MISS_CHAR,
                                      NULL,
                                      NULL,
                                      oldrec.ATTRIBUTE6,
                                      p_pay_approval_flow_rec.ATTRIBUTE6),
         ATTRIBUTE7 = DECODE(p_pay_approval_flow_rec.ATTRIBUTE7,
                                      FND_API.G_MISS_CHAR,
                                      NULL,
                                      NULL,
                                      oldrec.ATTRIBUTE7,
                                      p_pay_approval_flow_rec.ATTRIBUTE7),
         ATTRIBUTE8 = DECODE(p_pay_approval_flow_rec.ATTRIBUTE8,
                                      FND_API.G_MISS_CHAR,
                                      NULL,
                                      NULL,
                                      oldrec.ATTRIBUTE8,
                                      p_pay_approval_flow_rec.ATTRIBUTE8),
         ATTRIBUTE9 = DECODE(p_pay_approval_flow_rec.ATTRIBUTE9,
                                      FND_API.G_MISS_CHAR,
                                      NULL,
                                      NULL,
                                      oldrec.ATTRIBUTE9,
                                      p_pay_approval_flow_rec.ATTRIBUTE9),
         ATTRIBUTE10 = DECODE(p_pay_approval_flow_rec.ATTRIBUTE10,
                                      FND_API.G_MISS_CHAR,
                                      NULL,
                                      NULL,
                                      oldrec.ATTRIBUTE10,
                                      p_pay_approval_flow_rec.ATTRIBUTE10),
         ATTRIBUTE11 = DECODE(p_pay_approval_flow_rec.ATTRIBUTE11,
                                      FND_API.G_MISS_CHAR,
                                      NULL,
                                      NULL,
                                      oldrec.ATTRIBUTE11,
                                      p_pay_approval_flow_rec.ATTRIBUTE11),
         ATTRIBUTE12 = DECODE(p_pay_approval_flow_rec.ATTRIBUTE12,
                                      FND_API.G_MISS_CHAR,
                                      NULL,
                                      NULL,
                                      oldrec.ATTRIBUTE12,
                                      p_pay_approval_flow_rec.ATTRIBUTE12),
         ATTRIBUTE13 = DECODE(p_pay_approval_flow_rec.ATTRIBUTE13,
                                      FND_API.G_MISS_CHAR,
                                      NULL,
                                      NULL,
                                      oldrec.ATTRIBUTE13,
                                      p_pay_approval_flow_rec.ATTRIBUTE13),
         ATTRIBUTE14 = DECODE(p_pay_approval_flow_rec.ATTRIBUTE14,
                                      FND_API.G_MISS_CHAR,
                                      NULL,
                                      NULL,
                                      oldrec.ATTRIBUTE14,
                                      p_pay_approval_flow_rec.ATTRIBUTE14),
         ATTRIBUTE15 = DECODE(p_pay_approval_flow_rec.ATTRIBUTE15,
                                      FND_API.G_MISS_CHAR,
                                      NULL,
                                      NULL,
                                      oldrec.ATTRIBUTE15,
                                      p_pay_approval_flow_rec.ATTRIBUTE15),
         LAST_UPDATE_DATE = Sysdate,
         LAST_UPDATED_BY = fnd_global.user_id,
         LAST_UPDATE_LOGIN = fnd_global.login_id,
         OBJECT_VERSION_NUMBER = oldrec.OBJECT_VERSION_NUMBER + 1
     WHERE pay_approval_flow_id = p_pay_approval_flow_rec.pay_approval_flow_id;

Line: 514


END lock_update_row;

Line: 526


PROCEDURE delete_row
    (
      p_pay_approval_flow_id  NUMBER
    ) IS

BEGIN

   DELETE FROM CN_PAY_APPROVAL_FLOW
     WHERE pay_approval_flow_id = p_pay_approval_flow_id;

Line: 540


END Delete_row;