685:
686: -- adding the session id check to avoid connection pooling problems.
687: if (( hr_process_person_ss.g_assignment_id is not null
688: or hr_process_person_ss.g_person_id is not null) and
689: (hr_process_person_ss.g_session_id= ICX_SEC.G_SESSION_ID))
690: then
691: hr_utility.trace('AsgId<>NULL or PID<>NULL AND SESSIONID=ICX_SEC.G_SESSION_ID:'||l_proc);
692: if p_eit_type = 'PERSON' then
693: p_eit_type_id := hr_process_person_ss.g_person_id;
687: if (( hr_process_person_ss.g_assignment_id is not null
688: or hr_process_person_ss.g_person_id is not null) and
689: (hr_process_person_ss.g_session_id= ICX_SEC.G_SESSION_ID))
690: then
691: hr_utility.trace('AsgId<>NULL or PID<>NULL AND SESSIONID=ICX_SEC.G_SESSION_ID:'||l_proc);
692: if p_eit_type = 'PERSON' then
693: p_eit_type_id := hr_process_person_ss.g_person_id;
694: else
695: p_eit_type_id := hr_process_person_ss.g_assignment_id;