215: END;
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
Line 225: FROM ALL_USERS
221:
222: BEGIN
223: IF forSPXID<0 THEN
224: SELECT DISTINCT USERNAME INTO sUSER 225: FROM ALL_USERS 226: WHERE USER_ID=-forSPXID;
227: outNAME:=sUSER;
228: ELSE
229: SELECT USER_NAME INTO sFND