APPS.HR_UTIL_MISC_WEB dependencies on DUAL

Line 958: -- 09/18/2001 SRAMASAMY advised to select from dual instead of

954:
955: PRAGMA AUTONOMOUS_TRANSACTION;
956: --
957:
958: -- 09/18/2001 SRAMASAMY advised to select from dual instead of
959: -- using 'select session_id from fnd_sessions where userenv('sessionid') =
960: -- FND_SESSIONS.session_id' because of the hit on fnd_sessions table.
961: CURSOR get_session_id IS
962: SELECT userenv('sessionid')

Line 963: FROM dual;

959: -- using 'select session_id from fnd_sessions where userenv('sessionid') =
960: -- FND_SESSIONS.session_id' because of the hit on fnd_sessions table.
961: CURSOR get_session_id IS
962: SELECT userenv('sessionid')
963: FROM dual;
964:
965: l_session_id number default null;
966: l_proc constant varchar2(100) := g_package || ' autonomous_commit_fnd_sess_row';
967:

Line 1438: select userenv('LANG') into l_language from dual;

1434: Begin
1435: hr_utility.set_location('Entering: '|| l_proc,5);
1436: --
1437: -- Get language
1438: select userenv('LANG') into l_language from dual;
1439: --
1440: -- Get seq num
1441: --
1442: l_seq_num := 0;

Line 1462: from sys.dual;

1458: --
1459: -- get sequence id for attached_document_id
1460: select fnd_attached_documents_s.nextval
1461: into l_attached_document_id
1462: from sys.dual;
1463:
1464: -- Insert document to fnd_documents_long_text
1465: --
1466: fnd_attached_documents_pkg.insert_row

Line 1587: select userenv('LANG') into l_language from dual;

1583: Begin
1584: hr_utility.set_location('Entering: '|| l_proc,5);
1585: --
1586: -- Get language
1587: select userenv('LANG') into l_language from dual;
1588: --
1589: -- Get the before update nullable fields which are not used by the
1590: -- Web page to ensure the values are propagated.
1591: Open csr_get_attached_doc;

Line 1886: select userenv('LANG') into l_language from dual;

1882: Begin
1883: hr_utility.set_location('Entering: '|| l_proc,5);
1884: --
1885: -- Get language
1886: select userenv('LANG') into l_language from dual;
1887: --
1888: -- -------------------------------------------------------------------------
1889: -- Retrieving a resume requires 4 steps:
1890: -- 1) Get Category ID.