APPS.HR_STARTUP_DATA_API_SUPPORT SQL Statements

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

Line: 40

  SELECT userenv('sessionid') from dual;

Line: 62

  INSERT INTO hr_owner_definitions
    (session_id
    ,product_short_name)
  VALUES
    (hr_startup_data_api_support.g_session_id
    ,p_product_shortname);

Line: 90

PROCEDURE delete_owner_definitions(p_validate IN boolean) IS
--
CURSOR csr_get_sessionid IS
  SELECT userenv('sessionid')
    FROM dual;

Line: 98

  hr_utility.trace('delete_owner_definitions');

Line: 103

  DELETE FROM hr_owner_definitions
  WHERE session_id = userenv('sessionid');

Line: 124

END delete_owner_definitions;

Line: 162

  SELECT 'Y'
    FROM hr_owner_definitions def
   WHERE def.session_id = p_session_id;