1283: function user_name return varchar2
1284: is
1285: cursor c_usr is
1286: select user_name
1287: from fnd_user_view
1288: where user_id = fnd_global.user_id;
1289: user_name fnd_user_view.user_name%type;
1290: begin
1291: user_name := null;
1285: cursor c_usr is
1286: select user_name
1287: from fnd_user_view
1288: where user_id = fnd_global.user_id;
1289: user_name fnd_user_view.user_name%type;
1290: begin
1291: user_name := null;
1292: open c_usr;
1293: fetch c_usr into user_name;