eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PY_FI_TAX_CARD dependencies on FND_SESSIONS

Line 308: from fnd_sessions

304:
305: CURSOR CSR_CHECK_FND_SESSION
306: is
307: select session_id
308: from fnd_sessions
309: where session_id = userenv('sessionid')
310: and effective_date = p_effective_date;
311: LR_CHECK_FND_SESSION CSR_CHECK_FND_SESSION%ROWTYPE;
312:

Line 319: --Insert row into fnd_Sessions table.

315: if g_debug then
316: hr_utility.set_location('Entering:'|| l_proc, 1);
317: end if;
318:
319: --Insert row into fnd_Sessions table.
320: OPEN CSR_CHECK_FND_SESSION;
321: FETCH CSR_CHECK_FND_SESSION INTO LR_CHECK_FND_SESSION;
322: IF CSR_CHECK_FND_SESSION%notfound
323: THEN

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

320: OPEN CSR_CHECK_FND_SESSION;
321: FETCH CSR_CHECK_FND_SESSION INTO LR_CHECK_FND_SESSION;
322: IF CSR_CHECK_FND_SESSION%notfound
323: THEN
324: INSERT INTO fnd_sessions(session_id, effective_date) VALUES(userenv('sessionid'), p_effective_date);
325: END IF;
326:
327: CLOSE CSR_CHECK_FND_SESSION;
328:

Line 503: from fnd_sessions

499:
500: CURSOR CSR_CHECK_FND_SESSION
501: is
502: select session_id
503: from fnd_sessions
504: where session_id = userenv('sessionid')
505: and effective_date = p_effective_date;
506: LR_CHECK_FND_SESSION CSR_CHECK_FND_SESSION%ROWTYPE;
507:

Line 538: --Insert row into fnd_Sessions table.

534: --hr_utility.trace_on(NULL,'TELL');
535: if g_debug then
536: hr_utility.set_location('Entering:'|| l_proc, 1);
537: end if;
538: --Insert row into fnd_Sessions table.
539: OPEN CSR_CHECK_FND_SESSION;
540: FETCH CSR_CHECK_FND_SESSION INTO LR_CHECK_FND_SESSION;
541: IF CSR_CHECK_FND_SESSION%notfound
542: THEN

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

539: OPEN CSR_CHECK_FND_SESSION;
540: FETCH CSR_CHECK_FND_SESSION INTO LR_CHECK_FND_SESSION;
541: IF CSR_CHECK_FND_SESSION%notfound
542: THEN
543: INSERT INTO fnd_sessions(session_id, effective_date) VALUES(userenv('sessionid'), p_effective_date);
544: END IF;
545:
546: CLOSE CSR_CHECK_FND_SESSION;
547: