1222: End If;
1223: begin
1224: select effective_date
1225: into l_effective_date
1226: from fnd_sessions
1227: where session_id = userenv('sessionid');
1228: update fnd_sessions
1229: set effective_date = p_effective_date
1230: where session_id = userenv('sessionid');
1224: select effective_date
1225: into l_effective_date
1226: from fnd_sessions
1227: where session_id = userenv('sessionid');
1228: update fnd_sessions
1229: set effective_date = p_effective_date
1230: where session_id = userenv('sessionid');
1231: exception
1232: when no_data_found then
1229: set effective_date = p_effective_date
1230: where session_id = userenv('sessionid');
1231: exception
1232: when no_data_found then
1233: insert into fnd_sessions(session_id,effective_date) values(userenv('sessionid'), p_effective_date);
1234: when others then
1235: raise;
1236: end;
1237: hr_utility.set_location('effective date set',1);