APPS.GL_DEFAS_ACCESS_SETS_PKG SQL Statements

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

Line: 10

      SELECT GL_DEFAS_ACCESS_SETS_S.NEXTVAL
      FROM dual;

Line: 39

      SELECT GL.GL_DEFAS_DBNAME_S.NEXTVAL
      FROM dual;

Line: 71

      SELECT 'Duplicate'
      FROM   GL_DEFAS_ACCESS_SETS a
      WHERE  a.user_definition_access_set = x_name;

Line: 102

       SELECT 'Y'
       FROM DUAL
       WHERE exists (
             SELECT *
             FROM gl_defas_resp_assign
             WHERE definition_access_set_id = X_Definition_Access_Set_Id);

Line: 136

     /* Update only if force_edits is 'Y' or if user_id = 1 */
     if ( user_id = 1 or X_Force_Edits = 'Y' ) then
        UPDATE GL_DEFAS_ACCESS_SETS
        SET
           user_definition_access_set      =       X_User_Definition_Access_Set,
           description                     =       X_Description,
           last_update_date                =       sysdate,
           last_updated_by                 =       user_id,
           last_update_login               =       0
        WHERE definition_access_set = X_Definition_Access_Set
        and   userenv('LANG') IN
              ( select language_code
                from   fnd_languages
                where  installed_flag = 'B' );

Line: 195

        the creation date for update_row. */
     select creation_date
     into   v_creation_date
     from   gl_defas_access_sets
     where  definition_access_set = X_Definition_Access_Set;

Line: 205

     /* Update only if force_edits is 'Y' or if user_id = 1 */
     if ( user_id = 1 or X_Force_Edits = 'Y' ) then
        UPDATE GL_DEFAS_ACCESS_SETS
        SET
	  user_definition_access_set    = 	X_Definition_Access_Set,
     	  last_update_date		= 	sysdate,
	  last_updated_by		= 	user_id,
	  last_update_login		= 	0,
          attribute1			= 	X_Attribute1,
  	  attribute2			= 	X_Attribute2,
	  attribute3			= 	X_Attribute3,
	  attribute4			= 	X_Attribute4,
	  attribute5			= 	X_Attribute5,
          attribute6			=	X_Attribute6,
          attribute7			=	X_Attribute7,
	  attribute8			=	X_Attribute8,
          attribute9			=	X_Attribute9,
          attribute10			=	X_Attribute10,
          attribute11			=	X_Attribute11,
          attribute12			=	X_Attribute12,
          attribute13			=	X_Attribute13,
          attribute14			=	X_Attribute14,
          attribute15			=	X_Attribute15,
  	  context			= 	X_Context,
          description			=	X_Description
       WHERE definition_access_set = X_Definition_Access_Set;

Line: 238

       INSERT INTO GL_DEFAS_ACCESS_SETS
        (definition_access_set_id,
         definition_access_set,
         user_definition_access_set,
         description,
         last_update_date,
         last_updated_by,
         last_update_login,
         creation_date,
         created_by,
         context,
         attribute1,
         attribute2,
         attribute3,
         attribute4,
         attribute5,
         attribute6,
         attribute7,
         attribute8,
         attribute9,
         attribute10,
         attribute11,
         attribute12,
         attribute13,
         attribute14,
         attribute15)
       VALUES
        (gl_defas_access_sets_pkg.get_unique_id,
         X_Definition_Access_Set,
         X_User_Definition_Access_Set,
         X_Description,
         sysdate,
         user_id,
         0,
         sysdate,
         user_id,
         X_Context,
         X_Attribute1,
         X_Attribute2,
         X_Attribute3,
         X_Attribute4,
         X_Attribute5,
         X_Attribute6,
         X_Attribute7,
         X_Attribute8,
         X_Attribute9,
         X_Attribute10,
	 X_Attribute11,
	 X_Attribute12,
	 X_Attribute13,
         X_Attribute14,
	 X_Attribute15);