DBA Data[Home] [Help]

APPS.JTF_RESOURCE_SSWA_UTL SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 9

  /* Function to check if user has update access */

Function    Validate_Update_Access( p_resource_id           number,
  			            p_resource_user_id      number default null
			          ) Return varchar2
IS
l_profile_value	     VARCHAR2(10);
Line: 27

            SELECT  nvl(user_id,0)
    	    INTO    l_resource_user_id
            FROM    jtf_rs_resource_extns
            WHERE   resource_id = p_resource_id;
Line: 52

   END Validate_Update_Access;