113: ,DECODE(p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13)
114: ,DECODE(p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14)
115: ,DECODE(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15)
116: ,sysdate
117: ,fnd_global.user_id
118: ,sysdate
119: ,fnd_global.user_id
120: ,fnd_global.login_id
121: );
115: ,DECODE(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15)
116: ,sysdate
117: ,fnd_global.user_id
118: ,sysdate
119: ,fnd_global.user_id
120: ,fnd_global.login_id
121: );
122:
123: EXCEPTION
116: ,sysdate
117: ,fnd_global.user_id
118: ,sysdate
119: ,fnd_global.user_id
120: ,fnd_global.login_id
121: );
122:
123: EXCEPTION
124: WHEN OTHERS THEN -- catch the exceptions here
209: ,attribute13 = DECODE(p_attribute13, FND_API.G_MISS_CHAR, attribute13, p_attribute13)
210: ,attribute14 = DECODE(p_attribute14, FND_API.G_MISS_CHAR, attribute14, p_attribute14)
211: ,attribute15 = DECODE(p_attribute15, FND_API.G_MISS_CHAR, attribute15, p_attribute15)
212: ,last_update_date = sysdate
213: ,last_updated_by = fnd_global.user_id
214: ,last_update_login = fnd_global.login_id
215: WHERE team_template_id = p_team_template_id
216: AND record_version_number = p_record_version_number
217: AND nvl(workflow_in_progress_flag, 'N') <> 'Y';
210: ,attribute14 = DECODE(p_attribute14, FND_API.G_MISS_CHAR, attribute14, p_attribute14)
211: ,attribute15 = DECODE(p_attribute15, FND_API.G_MISS_CHAR, attribute15, p_attribute15)
212: ,last_update_date = sysdate
213: ,last_updated_by = fnd_global.user_id
214: ,last_update_login = fnd_global.login_id
215: WHERE team_template_id = p_team_template_id
216: AND record_version_number = p_record_version_number
217: AND nvl(workflow_in_progress_flag, 'N') <> 'Y';
218: