67: DECODE(p_object_type, FND_API.G_MISS_CHAR, NULL, p_object_type),
68: DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id),
69: DECODE(l_primary_subteam_flag, FND_API.G_MISS_CHAR, NULL, l_primary_subteam_flag),
70: sysdate,
71: fnd_global.user_id,
72: sysdate,
73: fnd_global.user_id,
74: fnd_global.login_id
75: ) RETURNING project_subteam_party_id INTO l_subteam_party_id;
69: DECODE(l_primary_subteam_flag, FND_API.G_MISS_CHAR, NULL, l_primary_subteam_flag),
70: sysdate,
71: fnd_global.user_id,
72: sysdate,
73: fnd_global.user_id,
74: fnd_global.login_id
75: ) RETURNING project_subteam_party_id INTO l_subteam_party_id;
76:
77:
70: sysdate,
71: fnd_global.user_id,
72: sysdate,
73: fnd_global.user_id,
74: fnd_global.login_id
75: ) RETURNING project_subteam_party_id INTO l_subteam_party_id;
76:
77:
78: x_project_subteam_party_id := l_subteam_party_id;
166: primary_subteam_flag = Decode(l_primary_subteam_flag, fnd_api.g_miss_char, primary_subteam_flag, l_primary_subteam_flag),
167:
168: last_update_date = sysdate,
169:
170: last_updated_by = fnd_global.user_id,
171:
172: last_update_login = fnd_global.login_id
173:
174: WHERE rowid = l_row_id
168: last_update_date = sysdate,
169:
170: last_updated_by = fnd_global.user_id,
171:
172: last_update_login = fnd_global.login_id
173:
174: WHERE rowid = l_row_id
175: AND nvl(p_record_version_number, record_version_number) = record_version_number;
176: