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.PAY_JP_ITAX_DPNT_INTERFACE_PKG dependencies on FND_SESSIONS

Line 30: insert into fnd_sessions(

26: -- ----------------------------------------------------------------------------
27: procedure insert_session(p_effective_date in date)
28: is
29: begin
30: insert into fnd_sessions(
31: session_id,
32: effective_date)
33: values( userenv('sessionid'),
34: p_effective_date);

Line 44: from fnd_sessions

40: procedure delete_session
41: is
42: begin
43: delete
44: from fnd_sessions
45: where session_id = userenv('sessionid');
46: commit;
47: end delete_session;
48: -- ----------------------------------------------------------------------------

Line 410: -- Need to populate record into fnd_sessions

406: p_reject_if_future_changes => p_reject_if_future_changes,
407: p_date_effective_changes => l_date_effective_changes);
408: --
409: -- Bug.2760646
410: -- Need to populate record into fnd_sessions
411: -- because the formula with this assignment set possibly calls
412: -- dbis which includes fnd_sessions table, e.g. PER_EMP_NUMBER.
413: -- If no records in fnd_sessions, PER_EMP_NUMBER will raise error
414: -- because FF_USER_ENTITIES.NOTFOUND_ALLOWED_FLAG is "N".

Line 412: -- dbis which includes fnd_sessions table, e.g. PER_EMP_NUMBER.

408: --
409: -- Bug.2760646
410: -- Need to populate record into fnd_sessions
411: -- because the formula with this assignment set possibly calls
412: -- dbis which includes fnd_sessions table, e.g. PER_EMP_NUMBER.
413: -- If no records in fnd_sessions, PER_EMP_NUMBER will raise error
414: -- because FF_USER_ENTITIES.NOTFOUND_ALLOWED_FLAG is "N".
415: -- Note FND_SESSIONS.EFFECTIVE_DATE is not changed during the processing
416: -- while the context DATE_EARNED changes for each assignment.

Line 413: -- If no records in fnd_sessions, PER_EMP_NUMBER will raise error

409: -- Bug.2760646
410: -- Need to populate record into fnd_sessions
411: -- because the formula with this assignment set possibly calls
412: -- dbis which includes fnd_sessions table, e.g. PER_EMP_NUMBER.
413: -- If no records in fnd_sessions, PER_EMP_NUMBER will raise error
414: -- because FF_USER_ENTITIES.NOTFOUND_ALLOWED_FLAG is "N".
415: -- Note FND_SESSIONS.EFFECTIVE_DATE is not changed during the processing
416: -- while the context DATE_EARNED changes for each assignment.
417: --

Line 415: -- Note FND_SESSIONS.EFFECTIVE_DATE is not changed during the processing

411: -- because the formula with this assignment set possibly calls
412: -- dbis which includes fnd_sessions table, e.g. PER_EMP_NUMBER.
413: -- If no records in fnd_sessions, PER_EMP_NUMBER will raise error
414: -- because FF_USER_ENTITIES.NOTFOUND_ALLOWED_FLAG is "N".
415: -- Note FND_SESSIONS.EFFECTIVE_DATE is not changed during the processing
416: -- while the context DATE_EARNED changes for each assignment.
417: --
418: insert_session(l_effective_date);
419: --