76: -- approval_status_type got changed to status_name and approval_status_
77: -- name respectively in 11.5.9 ENG Codeline. Also the requestor accepts
78: -- the full name of the user instead of employee number.
79: --
80: -- Bug 2731618 - ENG expects the requestor to be fnd_user name instead of the full_name
81: -- in 11.5.9 codeline. Made the changes in API to resolve this.
82: --
83: --
84: -------------------------------------------------------------------------------
123: FROM mtl_employees_current_view
124: WHERE full_name = p_requestor;
125: */
126:
127: -- Bug 2731618. Added the below cursor to fetch the fnd_user name from
128: -- the full_name of the employee.
129:
130: CURSOR emp_user IS
131: SELECT fu.user_name
128: -- the full_name of the employee.
129:
130: CURSOR emp_user IS
131: SELECT fu.user_name
132: FROM hr_employees_current_v hecv, fnd_user fu
133: WHERE hecv.employee_id = fu.employee_id
134: AND hecv.full_name = p_requestor;
135:
136:
190: CLOSE emp_num;
191: END IF;
192: */
193:
194: -- Bug 2731618. Added the below code to fetch the fnd_user name corresponding
195: -- to the requestor full_name onto l_user_name. If a corresponding fnd_user name
196: -- does not exist, assign NULL to l_user_name. kabalakr.
197:
198: IF p_requestor IS NOT NULL THEN
191: END IF;
192: */
193:
194: -- Bug 2731618. Added the below code to fetch the fnd_user name corresponding
195: -- to the requestor full_name onto l_user_name. If a corresponding fnd_user name
196: -- does not exist, assign NULL to l_user_name. kabalakr.
197:
198: IF p_requestor IS NOT NULL THEN
199: OPEN emp_user;
213: -- Bug 2717744. Remove the l_emp_num from the below function call. Instead, we are
214: -- passing the full name of the employee.
215:
216: -- Bug 2731618. Removed p_requestor from the below function call. Instead, passed
217: -- l_user_name, which contains the fnd_user_name of the employee.
218:
219: l_result := ENG_CHANGE_ORDER_INT(
220: p_change_notice,
221: p_change_type,