DBA Data[Home] [Help]

APPS.PAY_MAGTAPE_EXTRACT dependencies on FND_SESSIONS

Line 166: DELETE FROM fnd_sessions WHERE session_id = userenv('SESSIONID');

162: hr_utility.set_location ('arch_initialise',3);
163: --------------------------------------------------------------------------------
164: -- Set session date from effective date
165: --------------------------------------------------------------------------------
166: DELETE FROM fnd_sessions WHERE session_id = userenv('SESSIONID');
167: INSERT INTO fnd_sessions (session_id, effective_date)
168: VALUES ( userenv('SESSIONID'),l_effective_date );
169: --
170: hr_utility.set_location ('arch_initialise',4);

Line 167: INSERT INTO fnd_sessions (session_id, effective_date)

163: --------------------------------------------------------------------------------
164: -- Set session date from effective date
165: --------------------------------------------------------------------------------
166: DELETE FROM fnd_sessions WHERE session_id = userenv('SESSIONID');
167: INSERT INTO fnd_sessions (session_id, effective_date)
168: VALUES ( userenv('SESSIONID'),l_effective_date );
169: --
170: hr_utility.set_location ('arch_initialise',4);
171: --------------------------------------------------------------------------------