DBA Data[Home] [Help]

APPS.WSH_UTIL_VALIDATE dependencies on FND_USER

Line 1299: -- COMMENT : Validates User_id and User_name against table fnd_user

1295:
1296: --========================================================================
1297: -- PROCEDURE : Validate_User
1298: --
1299: -- COMMENT : Validates User_id and User_name against table fnd_user
1300: -- If both values are specified then only User_id is used
1301: --========================================================================
1302:
1303: PROCEDURE Validate_User

Line 1310: FROM fnd_user

1306: x_return_status OUT NOCOPY VARCHAR2) IS
1307:
1308: CURSOR check_user IS
1309: SELECT user_id
1310: FROM fnd_user
1311: WHERE p_user_id IS NOT NULL AND
1312: user_id = p_user_id AND
1313: trunc(sysdate) between nvl( start_date, trunc(sysdate) )
1314: and nvl( end_date, trunc(sysdate) )

Line 1317: FROM fnd_user

1313: trunc(sysdate) between nvl( start_date, trunc(sysdate) )
1314: and nvl( end_date, trunc(sysdate) )
1315: UNION ALL
1316: SELECT user_id
1317: FROM fnd_user
1318: WHERE p_user_id IS NULL AND
1319: user_name = p_user_name AND
1320: trunc(sysdate) between nvl( start_date, trunc(sysdate) )
1321: and nvl( end_date, trunc(sysdate) );