APPS.PY_DK_TAX_CARD dependencies on FND_SESSIONS

Line 127: /* Modified for unique constraint (APPLSYS.FND_SESSIONS_U1) violated. */

123: GROUP BY
124: et.element_type_id;
125: l_proc varchar2(72) := g_package||'insert_taxcard';
126:
127: /* Modified for unique constraint (APPLSYS.FND_SESSIONS_U1) violated. */
128:
129: CURSOR CSR_CHECK_FND_SESSION
130: is
131: select session_id

Line 132: from fnd_sessions

128:
129: CURSOR CSR_CHECK_FND_SESSION
130: is
131: select session_id
132: from fnd_sessions
133: where session_id = userenv('sessionid')
134: and effective_date = p_effective_date;
135:
136: LCSR_CHECK_FND_SESSION CSR_CHECK_FND_SESSION%ROWTYPE;

Line 143: --Insert row into fnd_Sessions table.

139:
140: if g_debug then
141: hr_utility.set_location('Entering:'|| l_proc, 1);
142: end if;
143: --Insert row into fnd_Sessions table.
144:
145: OPEN CSR_CHECK_FND_SESSION;
146: FETCH CSR_CHECK_FND_SESSION INTO LCSR_CHECK_FND_SESSION;
147:

Line 148: /* Modified for unique constraint (APPLSYS.FND_SESSIONS_U1) violated. */

144:
145: OPEN CSR_CHECK_FND_SESSION;
146: FETCH CSR_CHECK_FND_SESSION INTO LCSR_CHECK_FND_SESSION;
147:
148: /* Modified for unique constraint (APPLSYS.FND_SESSIONS_U1) violated. */
149:
150: IF CSR_CHECK_FND_SESSION%notfound THEN
151: INSERT INTO fnd_sessions(session_id,effective_date) VALUES(userenv('sessionid'), p_effective_date);
152: END IF;

Line 151: INSERT INTO fnd_sessions(session_id,effective_date) VALUES(userenv('sessionid'), p_effective_date);

147:
148: /* Modified for unique constraint (APPLSYS.FND_SESSIONS_U1) violated. */
149:
150: IF CSR_CHECK_FND_SESSION%notfound THEN
151: INSERT INTO fnd_sessions(session_id,effective_date) VALUES(userenv('sessionid'), p_effective_date);
152: END IF;
153: CLOSE CSR_CHECK_FND_SESSION;
154:
155: /* Fix for bug 6004991, ref bug fix 5951490 */