APPS.PAY_JP_CREATE_CMA_PKG dependencies on FND_SESSIONS

Line 35: insert into fnd_sessions(

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

Line 49: from fnd_sessions

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

Line 428: -- Need to populate record into fnd_sessions

424: p_reject_if_future_changes => p_reject_if_future_changes,
425: p_date_effective_changes => l_date_effective_changes);
426: --
427: -- Bug.2760646
428: -- Need to populate record into fnd_sessions
429: -- because the formula with this assignment set possibly calls
430: -- dbis which includes fnd_sessions table, e.g. PER_EMP_NUMBER.
431: -- If no records in fnd_sessions, PER_EMP_NUMBER will raise error
432: -- because FF_USER_ENTITIES.NOTFOUND_ALLOWED_FLAG is "N".

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

426: --
427: -- Bug.2760646
428: -- Need to populate record into fnd_sessions
429: -- because the formula with this assignment set possibly calls
430: -- dbis which includes fnd_sessions table, e.g. PER_EMP_NUMBER.
431: -- If no records in fnd_sessions, PER_EMP_NUMBER will raise error
432: -- because FF_USER_ENTITIES.NOTFOUND_ALLOWED_FLAG is "N".
433: -- Note FND_SESSIONS.EFFECTIVE_DATE is not changed during the processing
434: -- while the context DATE_EARNED changes for each assignment.

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

427: -- Bug.2760646
428: -- Need to populate record into fnd_sessions
429: -- because the formula with this assignment set possibly calls
430: -- dbis which includes fnd_sessions table, e.g. PER_EMP_NUMBER.
431: -- If no records in fnd_sessions, PER_EMP_NUMBER will raise error
432: -- because FF_USER_ENTITIES.NOTFOUND_ALLOWED_FLAG is "N".
433: -- Note FND_SESSIONS.EFFECTIVE_DATE is not changed during the processing
434: -- while the context DATE_EARNED changes for each assignment.
435: --

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

429: -- because the formula with this assignment set possibly calls
430: -- dbis which includes fnd_sessions table, e.g. PER_EMP_NUMBER.
431: -- If no records in fnd_sessions, PER_EMP_NUMBER will raise error
432: -- because FF_USER_ENTITIES.NOTFOUND_ALLOWED_FLAG is "N".
433: -- Note FND_SESSIONS.EFFECTIVE_DATE is not changed during the processing
434: -- while the context DATE_EARNED changes for each assignment.
435: --
436: ---- bug 4029525 ----
437: -- insert_session(l_effective_date);