120: DECODE(p_OBJECT_VALUE4,FND_API.G_MISS_CHAR,NULL,p_OBJECT_VALUE4),
121: DECODE(p_OBJECT_VALUE5,FND_API.G_MISS_CHAR,NULL,p_OBJECT_VALUE5),
122: DECODE(p_DESCRIPTION,FND_API.G_MISS_CHAR,NULL,p_DESCRIPTION),
123:
124: FND_GLOBAL.RESP_APPL_ID,
125: DECODE(P_OBJECT_STATUS,FND_API.G_MISS_CHAR,NULL,P_OBJECT_STATUS),
126: DECODE(P_INTERNAL_FLAG,FND_API.G_MISS_CHAR,NULL,P_INTERNAL_FLAG),
127: DECODE(P_MESSAGE_APPLICATION,FND_API.G_MISS_CHAR,NULL,P_MESSAGE_APPLICATION),
128: DECODE(P_MESSAGE_NAME,FND_API.G_MISS_CHAR,NULL,P_MESSAGE_NAME),
144:
145: p_OBJECT_VERSION_NUMBER,
146: DECODE(p_creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
147: p_creation_date),
148: DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
149: NULL, FND_GLOBAL.user_id, p_created_by),
150: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
151: p_last_update_date),
152: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
145: p_OBJECT_VERSION_NUMBER,
146: DECODE(p_creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
147: p_creation_date),
148: DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
149: NULL, FND_GLOBAL.user_id, p_created_by),
150: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
151: p_last_update_date),
152: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
153: NULL, FND_GLOBAL.user_id, p_last_updated_by),
148: DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
149: NULL, FND_GLOBAL.user_id, p_created_by),
150: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
151: p_last_update_date),
152: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
153: NULL, FND_GLOBAL.user_id, p_last_updated_by),
154: DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
155: NULL, FND_GLOBAL.login_id, p_last_update_login)
156: );
149: NULL, FND_GLOBAL.user_id, p_created_by),
150: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
151: p_last_update_date),
152: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
153: NULL, FND_GLOBAL.user_id, p_last_updated_by),
154: DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
155: NULL, FND_GLOBAL.login_id, p_last_update_login)
156: );
157:
150: DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
151: p_last_update_date),
152: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
153: NULL, FND_GLOBAL.user_id, p_last_updated_by),
154: DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
155: NULL, FND_GLOBAL.login_id, p_last_update_login)
156: );
157:
158:
151: p_last_update_date),
152: DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
153: NULL, FND_GLOBAL.user_id, p_last_updated_by),
154: DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
155: NULL, FND_GLOBAL.login_id, p_last_update_login)
156: );
157:
158:
159: OPEN c;
370: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
371: last_update_date = DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,
372: NULL, SYSDATE, p_last_update_date),
373: last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM,
374: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
375: p_last_updated_by),
376: last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM,
377: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
378: p_last_update_login)
373: last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM,
374: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
375: p_last_updated_by),
376: last_update_login = DECODE(p_last_update_login, FND_API.G_MISS_NUM,
377: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
378: p_last_update_login)
379:
380: WHERE AUDIT_LOG_ID = p_AUDIT_LOG_ID
381: AND object_version_number = DECODE(p_object_version_number,