119: ,p_attribute13
120: ,p_attribute14
121: ,p_attribute15
122: ,sysdate
123: ,fnd_global.user_id
124: ,sysdate
125: ,fnd_global.user_id
126: ,fnd_global.login_id
127: )
121: ,p_attribute15
122: ,sysdate
123: ,fnd_global.user_id
124: ,sysdate
125: ,fnd_global.user_id
126: ,fnd_global.login_id
127: )
128: RETURNING action_set_id INTO x_action_set_id;
129:
122: ,sysdate
123: ,fnd_global.user_id
124: ,sysdate
125: ,fnd_global.user_id
126: ,fnd_global.login_id
127: )
128: RETURNING action_set_id INTO x_action_set_id;
129:
130:
212: ,attribute13 = decode(p_attribute13, FND_API.G_MISS_CHAR, attribute13, p_attribute13)
213: ,attribute14 = decode(p_attribute14, FND_API.G_MISS_CHAR, attribute14, p_attribute14)
214: ,attribute15 = decode(p_attribute15, FND_API.G_MISS_CHAR, attribute15, p_attribute15)
215: ,last_update_date = sysdate
216: ,last_updated_by = fnd_global.user_id
217: ,last_update_login = fnd_global.login_id
218: WHERE action_set_id = p_action_set_id
219: AND record_version_number = nvl(p_record_version_number, record_version_number);
220:
213: ,attribute14 = decode(p_attribute14, FND_API.G_MISS_CHAR, attribute14, p_attribute14)
214: ,attribute15 = decode(p_attribute15, FND_API.G_MISS_CHAR, attribute15, p_attribute15)
215: ,last_update_date = sysdate
216: ,last_updated_by = fnd_global.user_id
217: ,last_update_login = fnd_global.login_id
218: WHERE action_set_id = p_action_set_id
219: AND record_version_number = nvl(p_record_version_number, record_version_number);
220:
221: IF (SQL%NOTFOUND) THEN