107: p_pay_approval_flow_rec.ATTRIBUTE14),
108: DECODE(p_pay_approval_flow_rec.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL,
109: p_pay_approval_flow_rec.ATTRIBUTE15),
110: Sysdate,
111: fnd_global.user_id,
112: Sysdate,
113: fnd_global.user_id,
114: fnd_global.login_id,
115: 1,
109: p_pay_approval_flow_rec.ATTRIBUTE15),
110: Sysdate,
111: fnd_global.user_id,
112: Sysdate,
113: fnd_global.user_id,
114: fnd_global.login_id,
115: 1,
116: p_pay_approval_flow_rec.org_id
117: from dual;
110: Sysdate,
111: fnd_global.user_id,
112: Sysdate,
113: fnd_global.user_id,
114: fnd_global.login_id,
115: 1,
116: p_pay_approval_flow_rec.org_id
117: from dual;
118:
293: NULL,
294: oldrec.ATTRIBUTE15,
295: p_pay_approval_flow_rec.ATTRIBUTE15),
296: LAST_UPDATE_DATE = Sysdate,
297: LAST_UPDATED_BY = fnd_global.user_id,
298: LAST_UPDATE_LOGIN = fnd_global.login_id,
299: OBJECT_VERSION_NUMBER = oldrec.OBJECT_VERSION_NUMBER + 1
300: WHERE pay_approval_flow_id = p_pay_approval_flow_rec.pay_approval_flow_id;
301:
294: oldrec.ATTRIBUTE15,
295: p_pay_approval_flow_rec.ATTRIBUTE15),
296: LAST_UPDATE_DATE = Sysdate,
297: LAST_UPDATED_BY = fnd_global.user_id,
298: LAST_UPDATE_LOGIN = fnd_global.login_id,
299: OBJECT_VERSION_NUMBER = oldrec.OBJECT_VERSION_NUMBER + 1
300: WHERE pay_approval_flow_id = p_pay_approval_flow_rec.pay_approval_flow_id;
301:
302: IF (SQL%ROWCOUNT=0) THEN
501: NULL,
502: oldrec.ATTRIBUTE15,
503: p_pay_approval_flow_rec.ATTRIBUTE15),
504: LAST_UPDATE_DATE = Sysdate,
505: LAST_UPDATED_BY = fnd_global.user_id,
506: LAST_UPDATE_LOGIN = fnd_global.login_id,
507: OBJECT_VERSION_NUMBER = oldrec.OBJECT_VERSION_NUMBER + 1
508: WHERE pay_approval_flow_id = p_pay_approval_flow_rec.pay_approval_flow_id;
509:
502: oldrec.ATTRIBUTE15,
503: p_pay_approval_flow_rec.ATTRIBUTE15),
504: LAST_UPDATE_DATE = Sysdate,
505: LAST_UPDATED_BY = fnd_global.user_id,
506: LAST_UPDATE_LOGIN = fnd_global.login_id,
507: OBJECT_VERSION_NUMBER = oldrec.OBJECT_VERSION_NUMBER + 1
508: WHERE pay_approval_flow_id = p_pay_approval_flow_rec.pay_approval_flow_id;
509:
510: IF (SQL%ROWCOUNT=0) THEN