DBA Data[Home] [Help]

APPS.HR_PROCESS_PHONE_NUMBERS_SS dependencies on HR_PROCESS_PERSON_SS

Line 2033: -- l_person_id := hr_process_person_ss.g_person_id;

2029: -- So the SFL specific code is not required anymore.
2030:
2031: else
2032: -- l_per_or_contact = 'PERSON'
2033: -- l_person_id := hr_process_person_ss.g_person_id;
2034: -- Adding the session id check to avoid connection pooling problems.
2035: if (( hr_process_person_ss.g_person_id is not null) and
2036: (hr_process_person_ss.g_session_id= ICX_SEC.G_SESSION_ID)) then
2037: hr_utility.set_location('hr_process_person_ss.g_person_id is not null AND hr_process_person_ss.g_session_id= ICX_SEC.G_SESSION_ID:'||l_proc,30);

Line 2035: if (( hr_process_person_ss.g_person_id is not null) and

2031: else
2032: -- l_per_or_contact = 'PERSON'
2033: -- l_person_id := hr_process_person_ss.g_person_id;
2034: -- Adding the session id check to avoid connection pooling problems.
2035: if (( hr_process_person_ss.g_person_id is not null) and
2036: (hr_process_person_ss.g_session_id= ICX_SEC.G_SESSION_ID)) then
2037: hr_utility.set_location('hr_process_person_ss.g_person_id is not null AND hr_process_person_ss.g_session_id= ICX_SEC.G_SESSION_ID:'||l_proc,30);
2038: l_person_id := hr_process_person_ss.g_person_id;
2039: end if;

Line 2036: (hr_process_person_ss.g_session_id= ICX_SEC.G_SESSION_ID)) then

2032: -- l_per_or_contact = 'PERSON'
2033: -- l_person_id := hr_process_person_ss.g_person_id;
2034: -- Adding the session id check to avoid connection pooling problems.
2035: if (( hr_process_person_ss.g_person_id is not null) and
2036: (hr_process_person_ss.g_session_id= ICX_SEC.G_SESSION_ID)) then
2037: hr_utility.set_location('hr_process_person_ss.g_person_id is not null AND hr_process_person_ss.g_session_id= ICX_SEC.G_SESSION_ID:'||l_proc,30);
2038: l_person_id := hr_process_person_ss.g_person_id;
2039: end if;
2040: end if;

Line 2037: hr_utility.set_location('hr_process_person_ss.g_person_id is not null AND hr_process_person_ss.g_session_id= ICX_SEC.G_SESSION_ID:'||l_proc,30);

2033: -- l_person_id := hr_process_person_ss.g_person_id;
2034: -- Adding the session id check to avoid connection pooling problems.
2035: if (( hr_process_person_ss.g_person_id is not null) and
2036: (hr_process_person_ss.g_session_id= ICX_SEC.G_SESSION_ID)) then
2037: hr_utility.set_location('hr_process_person_ss.g_person_id is not null AND hr_process_person_ss.g_session_id= ICX_SEC.G_SESSION_ID:'||l_proc,30);
2038: l_person_id := hr_process_person_ss.g_person_id;
2039: end if;
2040: end if;
2041: --

Line 2038: l_person_id := hr_process_person_ss.g_person_id;

2034: -- Adding the session id check to avoid connection pooling problems.
2035: if (( hr_process_person_ss.g_person_id is not null) and
2036: (hr_process_person_ss.g_session_id= ICX_SEC.G_SESSION_ID)) then
2037: hr_utility.set_location('hr_process_person_ss.g_person_id is not null AND hr_process_person_ss.g_session_id= ICX_SEC.G_SESSION_ID:'||l_proc,30);
2038: l_person_id := hr_process_person_ss.g_person_id;
2039: end if;
2040: end if;
2041: --
2042: end if;