[Home] [Help]
901: -- ------------------------------------------------------------------------
902: -- insert_session_row
903: --
904: -- Description:
905: -- This procedure insert a record into the fnd_sessions table so that we
906: -- may select data from date-tracked tables. It's over-loaded to accept a
907: -- date field or a varchar2 encrypted date. It also checks the user's
908: -- security
909: --
938: -- ------------------------------------------------------------------------
939: -- autonomous_commit_fnd_sess_row
940: --
941: -- Description:
942: -- This procedure inserts a record into the fnd_sessions table so that we
943: -- may select data from date-tracked tables. It also checks the user's
944: -- security.
945: -- This procedure returns an output parameter on session_id to aid debugging,
946: -- especially when the caller is a Java program.
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')
963: FROM dual;
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')
963: FROM dual;
964:
1010: l_person_id per_people_f.person_id%type;
1011: l_proc constant varchar2(100) := g_package || ' remove_session_row';
1012: BEGIN
1013: hr_utility.set_location('Entering: '|| l_proc,5);
1014: delete from fnd_sessions
1015: where session_id = userenv('sessionid');
1016: hr_utility.set_location('Leaving : ' || l_proc, 10);
1017: EXCEPTION
1018: WHEN others THEN