629: temp number;
630:
631: CURSOR c_user IS
632: SELECT user_id
633: FROM FND_USER
634: WHERE user_id = f_resource_id;
635:
636: BEGIN
637:
667:
668: -- --------------------------------------------------------------
669: -- IS VALID USER
670: --
671: -- Used to check if the user exists in FND_USER
672: --
673: -- --------------------------------------------------------------
674: FUNCTION isValidUser(
675: f_user_id IN NUMBER
677: RETURN VARCHAR2
678: IS
679: CURSOR c_user IS
680: SELECT user_id
681: FROM FND_USER
682: WHERE user_id = f_user_id;
683: temp number;
684: BEGIN
685: if (f_user_id is not null) then