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_CREATE_CMA_PKG dependencies on FND_SESSIONS

Line 32: insert into fnd_sessions(

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

Line 46: from fnd_sessions

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

Line 386: -- Need to populate record into fnd_sessions

382: p_reject_if_future_changes => p_reject_if_future_changes,
383: p_date_effective_changes => l_date_effective_changes);
384: --
385: -- Bug.2760646
386: -- Need to populate record into fnd_sessions
387: -- because the formula with this assignment set possibly calls
388: -- dbis which includes fnd_sessions table, e.g. PER_EMP_NUMBER.
389: -- If no records in fnd_sessions, PER_EMP_NUMBER will raise error
390: -- because FF_USER_ENTITIES.NOTFOUND_ALLOWED_FLAG is "N".

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

384: --
385: -- Bug.2760646
386: -- Need to populate record into fnd_sessions
387: -- because the formula with this assignment set possibly calls
388: -- dbis which includes fnd_sessions table, e.g. PER_EMP_NUMBER.
389: -- If no records in fnd_sessions, PER_EMP_NUMBER will raise error
390: -- because FF_USER_ENTITIES.NOTFOUND_ALLOWED_FLAG is "N".
391: -- Note FND_SESSIONS.EFFECTIVE_DATE is not changed during the processing
392: -- while the context DATE_EARNED changes for each assignment.

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

385: -- Bug.2760646
386: -- Need to populate record into fnd_sessions
387: -- because the formula with this assignment set possibly calls
388: -- dbis which includes fnd_sessions table, e.g. PER_EMP_NUMBER.
389: -- If no records in fnd_sessions, PER_EMP_NUMBER will raise error
390: -- because FF_USER_ENTITIES.NOTFOUND_ALLOWED_FLAG is "N".
391: -- Note FND_SESSIONS.EFFECTIVE_DATE is not changed during the processing
392: -- while the context DATE_EARNED changes for each assignment.
393: --

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

387: -- because the formula with this assignment set possibly calls
388: -- dbis which includes fnd_sessions table, e.g. PER_EMP_NUMBER.
389: -- If no records in fnd_sessions, PER_EMP_NUMBER will raise error
390: -- because FF_USER_ENTITIES.NOTFOUND_ALLOWED_FLAG is "N".
391: -- Note FND_SESSIONS.EFFECTIVE_DATE is not changed during the processing
392: -- while the context DATE_EARNED changes for each assignment.
393: --
394: ---- bug 4029525 ----
395: -- insert_session(l_effective_date);