3119: p_last_update_login := 1;
3120: end if;
3121: else
3122: -- called from user procedure
3123: p_created_by := to_number(nvl(fnd_profile.value('USER_ID'),0));
3124: p_creation_date := sysdate;
3125: p_last_updated_by := to_number(nvl(fnd_profile.value('USER_ID'),0));
3126: p_last_update_date := sysdate;
3127: p_last_update_login := to_number(
3121: else
3122: -- called from user procedure
3123: p_created_by := to_number(nvl(fnd_profile.value('USER_ID'),0));
3124: p_creation_date := sysdate;
3125: p_last_updated_by := to_number(nvl(fnd_profile.value('USER_ID'),0));
3126: p_last_update_date := sysdate;
3127: p_last_update_login := to_number(
3128: nvl(fnd_profile.value('LOGIN_ID'),0));
3129: end if;
3124: p_creation_date := sysdate;
3125: p_last_updated_by := to_number(nvl(fnd_profile.value('USER_ID'),0));
3126: p_last_update_date := sysdate;
3127: p_last_update_login := to_number(
3128: nvl(fnd_profile.value('LOGIN_ID'),0));
3129: end if;
3130:
3131: p_return_status := FND_API.G_RET_STS_SUCCESS;
3132: