APPS.GHR_SESSION dependencies on FND_SESSIONS

Line 11: ---- Make sure that there is an entry in the fnd_sessions table for the current session

7: --
8: -- ----------------------------------------------------------------------------
9: -- |-----------------------< set_session_var_for_core >------------------------|
10: -- ----------------------------------------------------------------------------
11: ---- Make sure that there is an entry in the fnd_sessions table for the current session
12:
13: Procedure set_session_var_for_core
14: (p_effective_date in date
15: )

Line 21: l_session_id fnd_sessions.session_id%type;

17:
18: l_exists boolean := FALSE;
19: l_session_var ghr_history_api.g_session_var_type;
20: l_effective_date date;
21: l_session_id fnd_sessions.session_id%type;
22:
23: Cursor c_session_id is
24: select userenv('sessionid') sessionid
25: from dual;

Line 30: from fnd_sessions

26:
27: Cursor c_session_data is
28: select effective_date,
29: session_id
30: from fnd_sessions
31: where session_id = l_session_id;
32:
33: Begin
34:

Line 48: update fnd_sessions

44:
45: If l_exists then
46:
47: If nvl(trunc(l_effective_date),hr_api.g_date) <> p_effective_date then
48: update fnd_sessions
49: set effective_date = p_effective_date
50: where session_id = l_session_id;
51: End if;
52: Else

Line 53: Insert into fnd_sessions

49: set effective_date = p_effective_date
50: where session_id = l_session_id;
51: End if;
52: Else
53: Insert into fnd_sessions
54: (session_id,effective_date)
55: values
56: (l_session_id,p_effective_date);
57: End if;

Line 72: l_session_id fnd_sessions.session_id%type;

68: --Bug # 6127620
69: Procedure set_fnd_session_date(p_effective_date in date) is
70: l_exists boolean := FALSE;
71: l_effective_date date;
72: l_session_id fnd_sessions.session_id%type;
73:
74: Cursor c_session_id is
75: select userenv('sessionid') sessionid
76: from dual;

Line 81: from fnd_sessions

77:
78: Cursor c_session_data is
79: select effective_date,
80: session_id
81: from fnd_sessions
82: where session_id = l_session_id;
83:
84: Begin
85:

Line 99: update fnd_sessions

95:
96: If l_exists then
97:
98: If nvl(trunc(l_effective_date),hr_api.g_date) <> p_effective_date then
99: update fnd_sessions
100: set effective_date = p_effective_date
101: where session_id = l_session_id;
102: End if;
103: Else

Line 104: Insert into fnd_sessions

100: set effective_date = p_effective_date
101: where session_id = l_session_id;
102: End if;
103: Else
104: Insert into fnd_sessions
105: (session_id,effective_date)
106: values
107: (l_session_id,p_effective_date);
108: End if;