270: X_GRANT_ID => null,
271: X_SCHEDULED_FLAG => NVL(p_scheduled_flag, 'N'),
272: X_RECORD_VERSION_NUMBER => l_record_version_number,
273: X_LAST_UPDATE_DATE => sysdate,
274: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
275: X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID,
276: X_RETURN_STATUS => x_return_status);
277: if (x_return_status = 'N') then
278: if p_calling_module = 'FORM' then
271: X_SCHEDULED_FLAG => NVL(p_scheduled_flag, 'N'),
272: X_RECORD_VERSION_NUMBER => l_record_version_number,
273: X_LAST_UPDATE_DATE => sysdate,
274: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
275: X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID,
276: X_RETURN_STATUS => x_return_status);
277: if (x_return_status = 'N') then
278: if p_calling_module = 'FORM' then
279: fnd_message.set_name('FND','FORM_RECORD_CHANGED');
327: X_START_DATE_ACTIVE => trunc(p_start_date_active),
328: X_END_DATE_ACTIVE => trunc(p_end_date_active),
329: X_SCHEDULED_FLAG => NVL(p_scheduled_flag, 'N'),
330: X_GRANT_ID => l_grant_id,
331: X_CREATED_BY => FND_GLOBAL.USER_ID,
332: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
333: X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID) ;
334: end if;
335: end if;
328: X_END_DATE_ACTIVE => trunc(p_end_date_active),
329: X_SCHEDULED_FLAG => NVL(p_scheduled_flag, 'N'),
330: X_GRANT_ID => l_grant_id,
331: X_CREATED_BY => FND_GLOBAL.USER_ID,
332: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
333: X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID) ;
334: end if;
335: end if;
336:
329: X_SCHEDULED_FLAG => NVL(p_scheduled_flag, 'N'),
330: X_GRANT_ID => l_grant_id,
331: X_CREATED_BY => FND_GLOBAL.USER_ID,
332: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
333: X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID) ;
334: end if;
335: end if;
336:
337: if x_return_status = FND_API.G_RET_STS_SUCCESS and x_assignment_action = 'CREATE' and p_calling_module = 'PROJECT_MEMBER' then
744: X_SCHEDULED_FLAG => NVL(p_scheduled_flag, 'N'),
745: X_GRANT_ID => l_grant_id,
746: X_record_version_number => p_record_version_number,
747: X_LAST_UPDATE_DATE => sysdate,
748: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
749: X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID,
750: X_RETURN_STATUS => x_return_status);
751: if (x_return_status = 'N') then
752: x_return_status := FND_API.G_RET_STS_ERROR;
745: X_GRANT_ID => l_grant_id,
746: X_record_version_number => p_record_version_number,
747: X_LAST_UPDATE_DATE => sysdate,
748: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
749: X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID,
750: X_RETURN_STATUS => x_return_status);
751: if (x_return_status = 'N') then
752: x_return_status := FND_API.G_RET_STS_ERROR;
753: if p_calling_module = 'FORM' then