178: decode(p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
179: decode(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),
180: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
181: p_creation_date),
182: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
183: NULL, FND_GLOBAL.user_id, p_created_by),
184: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
185: p_last_update_date),
186: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
179: decode(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),
180: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
181: p_creation_date),
182: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
183: NULL, FND_GLOBAL.user_id, p_created_by),
184: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
185: p_last_update_date),
186: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
187: NULL, FND_GLOBAL.user_id, p_last_updated_by),
182: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
183: NULL, FND_GLOBAL.user_id, p_created_by),
184: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
185: p_last_update_date),
186: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
187: NULL, FND_GLOBAL.user_id, p_last_updated_by),
188: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
189: NULL, FND_GLOBAL.login_id, p_last_update_login)
190: );
183: NULL, FND_GLOBAL.user_id, p_created_by),
184: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
185: p_last_update_date),
186: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
187: NULL, FND_GLOBAL.user_id, p_last_updated_by),
188: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
189: NULL, FND_GLOBAL.login_id, p_last_update_login)
190: );
191:
184: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
185: p_last_update_date),
186: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
187: NULL, FND_GLOBAL.user_id, p_last_updated_by),
188: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
189: NULL, FND_GLOBAL.login_id, p_last_update_login)
190: );
191:
192: OPEN c;
185: p_last_update_date),
186: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
187: NULL, FND_GLOBAL.user_id, p_last_updated_by),
188: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
189: NULL, FND_GLOBAL.login_id, p_last_update_login)
190: );
191:
192: OPEN c;
193: FETCH c INTO x_rowid;
324: attribute15, p_attribute15),
325: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
326: NULL, sysdate, p_last_update_date),
327: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
328: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
329: p_last_updated_by),
330: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
331: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
332: p_last_update_login)
327: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
328: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
329: p_last_updated_by),
330: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
331: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
332: p_last_update_login)
333: WHERE msite_information_id = p_msite_information_id
334: AND object_version_number = decode(p_object_version_number,
335: FND_API.G_MISS_NUM,