APPS.HR_JP_AST_UTILITY_PKG dependencies on FND_SESSIONS

Line 382: -- savepoint/rollback to savepoint for FND_SESSIONS

378: end loop;
379: --
380: begin
381: --
382: -- savepoint/rollback to savepoint for FND_SESSIONS
383: -- will raise error ORA-14552 when this function is used in SQL.
384: -- To suppress this error when this function is used in SQL,
385: -- do not pass "true" to input parameter "p_populate_fs".
386: --

Line 395: from fnd_sessions

391: select rowid,
392: effective_date
393: into l_rowid,
394: l_effective_date
395: from fnd_sessions
396: where session_id = userenv('sessionid');
397: --
398: if l_effective_date <> p_effective_date then
399: update fnd_sessions

Line 399: update fnd_sessions

395: from fnd_sessions
396: where session_id = userenv('sessionid');
397: --
398: if l_effective_date <> p_effective_date then
399: update fnd_sessions
400: set effective_date = p_effective_date
401: where rowid = l_rowid;
402: end if;
403: exception

Line 405: insert into fnd_sessions(

401: where rowid = l_rowid;
402: end if;
403: exception
404: when no_data_found then
405: insert into fnd_sessions(
406: session_id,
407: effective_date)
408: values( userenv('sessionid'),
409: p_effective_date);