DBA Data[Home] [Help]

APPS.HR_PROCESS_ASSIGNMENT_SS dependencies on ICX_SEC

Line 6154: (hr_process_person_ss.g_session_id= ICX_SEC.G_SESSION_ID))

6150: -- We also need the latest Object version Number not the one on transaction tbl
6151:
6152: -- adding the session id check to avoid connection pooling problems.
6153: if (( hr_process_person_ss.g_assignment_id is not null) and
6154: (hr_process_person_ss.g_session_id= ICX_SEC.G_SESSION_ID))
6155: then
6156: hr_utility.set_location('session id is ICX_SEC.G_SESSION_ID:'||l_proc,15);
6157: l_assignment_rec.person_id := hr_process_person_ss.g_person_id;
6158: l_assignment_rec.assignment_id := hr_process_person_ss.g_assignment_id;

Line 6156: hr_utility.set_location('session id is ICX_SEC.G_SESSION_ID:'||l_proc,15);

6152: -- adding the session id check to avoid connection pooling problems.
6153: if (( hr_process_person_ss.g_assignment_id is not null) and
6154: (hr_process_person_ss.g_session_id= ICX_SEC.G_SESSION_ID))
6155: then
6156: hr_utility.set_location('session id is ICX_SEC.G_SESSION_ID:'||l_proc,15);
6157: l_assignment_rec.person_id := hr_process_person_ss.g_person_id;
6158: l_assignment_rec.assignment_id := hr_process_person_ss.g_assignment_id;
6159: l_assignment_rec.object_version_number:=hr_process_person_ss.g_asg_object_version_number;
6160: -- Hard code ovn to 1 for the new user registration process

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

6169: -- check if we are updating applicant, if yes we need to get the
6170: -- latest object version
6171: -- number of the applicant who has became employee in BD page
6172: if (hr_process_person_ss.g_is_applicant and
6173: (hr_process_person_ss.g_session_id= ICX_SEC.G_SESSION_ID)) then
6174: hr_utility.set_location('Applicaant ICX_SEC.G_SESSION_ID:'||l_proc,20);
6175: open asg_applicant_rec(l_assignment_rec.assignment_id, l_effective_date);
6176: fetch asg_applicant_rec into l_assignment_rec.object_version_number
6177: ,l_appl_assignment_type

Line 6174: hr_utility.set_location('Applicaant ICX_SEC.G_SESSION_ID:'||l_proc,20);

6170: -- latest object version
6171: -- number of the applicant who has became employee in BD page
6172: if (hr_process_person_ss.g_is_applicant and
6173: (hr_process_person_ss.g_session_id= ICX_SEC.G_SESSION_ID)) then
6174: hr_utility.set_location('Applicaant ICX_SEC.G_SESSION_ID:'||l_proc,20);
6175: open asg_applicant_rec(l_assignment_rec.assignment_id, l_effective_date);
6176: fetch asg_applicant_rec into l_assignment_rec.object_version_number
6177: ,l_appl_assignment_type
6178: ,l_assignment_rec.assignment_status_type_id;