623: IF p_sprvsr_status = 'VALID' THEN
624: x_return_status := FND_API.G_RET_STS_SUCCESS;
625:
626: l_creation_date := SYSDATE;
627: l_created_by := FND_GLOBAL.USER_ID;
628: l_last_update_date := SYSDATE;
629: l_last_updated_by := FND_GLOBAL.USER_ID;
630: l_last_update_login :=FND_GLOBAL.LOGIN_ID;
631:
625:
626: l_creation_date := SYSDATE;
627: l_created_by := FND_GLOBAL.USER_ID;
628: l_last_update_date := SYSDATE;
629: l_last_updated_by := FND_GLOBAL.USER_ID;
630: l_last_update_login :=FND_GLOBAL.LOGIN_ID;
631:
632: IF l_created_by IS NULL THEN
633: l_created_by := -1;
626: l_creation_date := SYSDATE;
627: l_created_by := FND_GLOBAL.USER_ID;
628: l_last_update_date := SYSDATE;
629: l_last_updated_by := FND_GLOBAL.USER_ID;
630: l_last_update_login :=FND_GLOBAL.LOGIN_ID;
631:
632: IF l_created_by IS NULL THEN
633: l_created_by := -1;
634: END IF;