289: X_GRANT_ID => null,
290: X_SCHEDULED_FLAG => NVL(p_scheduled_flag, 'N'),
291: X_RECORD_VERSION_NUMBER => l_record_version_number,
292: X_LAST_UPDATE_DATE => sysdate,
293: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
294: X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID,
295: X_RETURN_STATUS => x_return_status);
296: if (x_return_status = 'N') then
297: if p_calling_module = 'FORM' then
290: X_SCHEDULED_FLAG => NVL(p_scheduled_flag, 'N'),
291: X_RECORD_VERSION_NUMBER => l_record_version_number,
292: X_LAST_UPDATE_DATE => sysdate,
293: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
294: X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID,
295: X_RETURN_STATUS => x_return_status);
296: if (x_return_status = 'N') then
297: if p_calling_module = 'FORM' then
298: fnd_message.set_name('FND','FORM_RECORD_CHANGED');
346: X_START_DATE_ACTIVE => trunc(p_start_date_active),
347: X_END_DATE_ACTIVE => trunc(p_end_date_active),
348: X_SCHEDULED_FLAG => NVL(p_scheduled_flag, 'N'),
349: X_GRANT_ID => l_grant_id,
350: X_CREATED_BY => FND_GLOBAL.USER_ID,
351: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
352: X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID) ;
353: end if;
354: end if;
347: X_END_DATE_ACTIVE => trunc(p_end_date_active),
348: X_SCHEDULED_FLAG => NVL(p_scheduled_flag, 'N'),
349: X_GRANT_ID => l_grant_id,
350: X_CREATED_BY => FND_GLOBAL.USER_ID,
351: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
352: X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID) ;
353: end if;
354: end if;
355:
348: X_SCHEDULED_FLAG => NVL(p_scheduled_flag, 'N'),
349: X_GRANT_ID => l_grant_id,
350: X_CREATED_BY => FND_GLOBAL.USER_ID,
351: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
352: X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID) ;
353: end if;
354: end if;
355:
356: if x_return_status = FND_API.G_RET_STS_SUCCESS and x_assignment_action = 'CREATE' and p_calling_module = 'PROJECT_MEMBER' then
781: X_SCHEDULED_FLAG => NVL(p_scheduled_flag, 'N'),
782: X_GRANT_ID => l_grant_id,
783: X_record_version_number => p_record_version_number,
784: X_LAST_UPDATE_DATE => sysdate,
785: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
786: X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID,
787: X_RETURN_STATUS => x_return_status);
788: if (x_return_status = 'N') then
789: x_return_status := FND_API.G_RET_STS_ERROR;
782: X_GRANT_ID => l_grant_id,
783: X_record_version_number => p_record_version_number,
784: X_LAST_UPDATE_DATE => sysdate,
785: X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
786: X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID,
787: X_RETURN_STATUS => x_return_status);
788: if (x_return_status = 'N') then
789: x_return_status := FND_API.G_RET_STS_ERROR;
790: if p_calling_module = 'FORM' then