APPS.FA_XLA_CMP_EXTRACT_PKG SQL Statements

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

Line: 190

                     'SQL - Select from fnd_user');

Line: 193

   SELECT  nvl(fd.user_name, 'ANONYMOUS')
     INTO  l_user_name
     FROM  fnd_user fd
    WHERE  fd.user_id = fnd_global.user_id;

Line: 234

FUNCTION InsertString(  p_InputString   IN VARCHAR2
                      , p_token         IN VARCHAR2
                      , p_value         IN VARCHAR2)
RETURN VARCHAR2 IS

  l_OutputString    VARCHAR2(2000);

Line: 240

  l_procedure_name  varchar2(80) := 'InsertString';

Line: 249

END InsertString;

Line: 287

   l_StringValue   := InsertString( p_InputString => '$pkg_name'
                                   ,p_token       => '$pkg_name'
                                   ,p_value       =>  p_package_name
                                  );

Line: 297

   l_StringValue   := InsertString(p_InputString => l_StringValue
                                  ,p_token       => '$user'
                                  ,p_value       => p_user_name
                                  );