DBA Data[Home] [Help]

APPS.CZ_UTILS dependencies on FND_USER

Line 220: sFND FND_USER.USER_NAME%TYPE;

216: END;
217: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
218: PROCEDURE GET_USER_NAME (forSPXID IN NUMBER, outNAME OUT NOCOPY VARCHAR2) IS
219: sUSER ALL_USERS.USERNAME%TYPE;
220: sFND FND_USER.USER_NAME%TYPE;
221:
222: BEGIN
223: IF forSPXID<0 THEN
224: SELECT DISTINCT USERNAME INTO sUSER

Line 230: FROM FND_USER

226: WHERE USER_ID=-forSPXID;
227: outNAME:=sUSER;
228: ELSE
229: SELECT USER_NAME INTO sFND
230: FROM FND_USER
231: WHERE USER_ID=forSPXID;
232: outNAME:=sFND;
233: END IF;
234: EXCEPTION