2223: SAVEPOINT create_tax_bal_adjustment;
2224:
2225: -- insert a row INTO fnd_session if there isn't one
2226: BEGIN
2227: INSERT INTO fnd_sessions(session_id, effective_date)
2228: SELECT USERENV('sessionid'), SYSDATE
2229: FROM DUAL
2230: WHERE NOT EXISTS (SELECT '1'
2231: FROM fnd_sessions
2227: INSERT INTO fnd_sessions(session_id, effective_date)
2228: SELECT USERENV('sessionid'), SYSDATE
2229: FROM DUAL
2230: WHERE NOT EXISTS (SELECT '1'
2231: FROM fnd_sessions
2232: WHERE session_id = USERENV('sessionid'));
2233:
2234: END;
2235: