101: DECODE(p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
102: DECODE(p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
103: DECODE(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),
104: sysdate,
105: fnd_global.user_id,
106: sysdate,
107: fnd_global.user_id,
108: fnd_global.login_id
109: ) RETURNING project_subteam_id INTO l_subteam_id;
103: DECODE(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),
104: sysdate,
105: fnd_global.user_id,
106: sysdate,
107: fnd_global.user_id,
108: fnd_global.login_id
109: ) RETURNING project_subteam_id INTO l_subteam_id;
110:
111: x_new_subteam_id := l_subteam_id;
104: sysdate,
105: fnd_global.user_id,
106: sysdate,
107: fnd_global.user_id,
108: fnd_global.login_id
109: ) RETURNING project_subteam_id INTO l_subteam_id;
110:
111: x_new_subteam_id := l_subteam_id;
112:
245: attribute13 = DECODE(p_attribute13, FND_API.G_MISS_CHAR, attribute13, p_attribute13),
246: attribute14 = DECODE(p_attribute14, FND_API.G_MISS_CHAR, attribute14, p_attribute14),
247: attribute15 = DECODE(p_attribute15, FND_API.G_MISS_CHAR, attribute15, p_attribute15),
248: last_update_date = sysdate,
249: last_updated_by = fnd_global.user_id,
250: last_update_login = fnd_global.login_id
251: WHERE rowid = l_row_id
252: AND nvl(p_record_version_number, record_version_number) = record_version_number;
253: --
246: attribute14 = DECODE(p_attribute14, FND_API.G_MISS_CHAR, attribute14, p_attribute14),
247: attribute15 = DECODE(p_attribute15, FND_API.G_MISS_CHAR, attribute15, p_attribute15),
248: last_update_date = sysdate,
249: last_updated_by = fnd_global.user_id,
250: last_update_login = fnd_global.login_id
251: WHERE rowid = l_row_id
252: AND nvl(p_record_version_number, record_version_number) = record_version_number;
253: --
254: