APPS.BIS_KPILIST_WIZARD_PKG SQL Statements

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

Line: 40

  SELECT FND_FORM_FUNCTIONS_S.nextval
  INTO   x_fid
  FROM   sys.dual;

Line: 48

  FND_FORM_FUNCTIONS_PKG.INSERT_ROW
                        ( X_ROWID                      => x_rowid
                         ,X_FUNCTION_ID                => x_fid
                         ,X_WEB_HOST_NAME              => ''
                         ,X_WEB_AGENT_NAME             => ''
                         ,X_WEB_HTML_CALL              => p_web_portlet
                         ,X_WEB_ENCRYPT_PARAMETERS     => 'N'
                         ,X_WEB_SECURED                => 'N'
                         ,X_WEB_ICON                   => ''
                         ,X_OBJECT_ID                  => NULL
                         ,X_REGION_APPLICATION_ID      => NULL
                         ,X_REGION_CODE                => ''
                         ,X_FUNCTION_NAME              => p_function_name
                         ,X_APPLICATION_ID             => NULL
                         ,X_FORM_ID                    => NULL
                         ,X_PARAMETERS                 => p_param
                         ,X_TYPE                       => 'WEBPORTLET'
                         ,X_USER_FUNCTION_NAME         => p_portlet_name
                         ,X_DESCRIPTION                => p_description
                         ,X_CREATION_DATE              => sysdate
                         ,X_CREATED_BY                 => FND_GLOBAL.user_id
                         ,X_LAST_UPDATE_DATE           => sysdate
                         ,X_LAST_UPDATED_BY            => FND_GLOBAL.user_id
                         ,X_LAST_UPDATE_LOGIN          => FND_GLOBAL.user_id
                         ,X_MAINTENANCE_MODE_SUPPORT   => 'NONE'
                         ,X_CONTEXT_DEPENDENCE         => 'RESP'
                        );

Line: 81

PROCEDURE UPDATE_FUNCTION
( p_function_id        IN VARCHAR2
, p_function_name      IN VARCHAR2
, p_parameters         IN VARCHAR2
, p_user_function_name IN VARCHAR2
, p_description        IN VARCHAR2 := NULL
)

IS

  params  VARCHAR2(300);

Line: 97

  UPDATE fnd_form_functions
  SET    function_name = p_function_name,
         parameters = p_parameters
  WHERE  function_id = p_function_id;

Line: 103

  UPDATE fnd_form_functions_tl
  SET    user_function_name = p_user_function_name,
         description = p_description
  WHERE  function_id = p_function_id;

Line: 108

END UPDATE_FUNCTION;

Line: 110

PROCEDURE UPDATE_FUNCTION_PARAMETERS
( p_function_short_name   IN VARCHAR2
, p_parameters            IN VARCHAR2
, p_user_function_name    IN VARCHAR2
)
IS

fid  NUMBER;

Line: 121

  UPDATE fnd_form_functions_vl
  SET parameters = p_parameters,
      user_function_name = p_user_function_name
  WHERE function_name = p_function_short_name;

Line: 127

  SELECT function_id INTO fid
  FROM fnd_form_functions_vl
  WHERE function_name = p_function_short_name;

Line: 131

  UPDATE fnd_form_functions_tl
  SET    user_function_name = p_user_function_name
  WHERE  function_id = fid;

Line: 136

END UPDATE_FUNCTION_PARAMETERS;

Line: 140

PROCEDURE DELETE_FUNCTION
( p_function_name       IN VARCHAR2
, x_return_status       OUT NOCOPY VARCHAR2
)
IS
    l_function_id   fnd_form_functions.function_id%TYPE;

Line: 153

        SELECT function_id, created_by
        FROM fnd_form_functions
        WHERE function_name = p_function_name;

Line: 158

	SELECT menu_id, entry_sequence
	FROM fnd_menu_entries
	WHERE function_id = p_function_id;

Line: 178

  	DELETE FROM fnd_form_functions where function_name = p_function_name;

Line: 179

	DELETE FROM fnd_form_functions_tl where function_id = l_function_id;

Line: 182

    /* Also delete the menu entries corresponding to this function */
    OPEN menu_crsr(l_function_id);

Line: 187

    DELETE FROM fnd_menu_entries WHERE function_id = l_function_id;

Line: 188

    DELETE FROM fnd_menu_entries_tl WHERE menu_id = l_menu_id AND entry_sequence = l_entry_sequence;

Line: 198

END DELETE_FUNCTION;