DBA Data[Home] [Help]

APPS.PAY_JP_ITAX_DPNT_INTERFACE_PKG dependencies on FND_SESSIONS

Line 33: insert into fnd_sessions(

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

Line 47: from fnd_sessions

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

Line 452: -- Need to populate record into fnd_sessions

448: p_reject_if_future_changes => p_reject_if_future_changes,
449: p_date_effective_changes => l_date_effective_changes);
450: --
451: -- Bug.2760646
452: -- Need to populate record into fnd_sessions
453: -- because the formula with this assignment set possibly calls
454: -- dbis which includes fnd_sessions table, e.g. PER_EMP_NUMBER.
455: -- If no records in fnd_sessions, PER_EMP_NUMBER will raise error
456: -- because FF_USER_ENTITIES.NOTFOUND_ALLOWED_FLAG is "N".

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

450: --
451: -- Bug.2760646
452: -- Need to populate record into fnd_sessions
453: -- because the formula with this assignment set possibly calls
454: -- dbis which includes fnd_sessions table, e.g. PER_EMP_NUMBER.
455: -- If no records in fnd_sessions, PER_EMP_NUMBER will raise error
456: -- because FF_USER_ENTITIES.NOTFOUND_ALLOWED_FLAG is "N".
457: -- Note FND_SESSIONS.EFFECTIVE_DATE is not changed during the processing
458: -- while the context DATE_EARNED changes for each assignment.

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

451: -- Bug.2760646
452: -- Need to populate record into fnd_sessions
453: -- because the formula with this assignment set possibly calls
454: -- dbis which includes fnd_sessions table, e.g. PER_EMP_NUMBER.
455: -- If no records in fnd_sessions, PER_EMP_NUMBER will raise error
456: -- because FF_USER_ENTITIES.NOTFOUND_ALLOWED_FLAG is "N".
457: -- Note FND_SESSIONS.EFFECTIVE_DATE is not changed during the processing
458: -- while the context DATE_EARNED changes for each assignment.
459: --

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

453: -- because the formula with this assignment set possibly calls
454: -- dbis which includes fnd_sessions table, e.g. PER_EMP_NUMBER.
455: -- If no records in fnd_sessions, PER_EMP_NUMBER will raise error
456: -- because FF_USER_ENTITIES.NOTFOUND_ALLOWED_FLAG is "N".
457: -- Note FND_SESSIONS.EFFECTIVE_DATE is not changed during the processing
458: -- while the context DATE_EARNED changes for each assignment.
459: --
460: insert_session(l_effective_date);
461: --