DBA Data[Home] [Help]

APPS.QA_SOLUTION_CAR_PKG dependencies on FND_USER

Line 80: -- Bug 2731618 - ENG expects the requestor to be fnd_user name instead of the full_name

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: -------------------------------------------------------------------------------

Line 127: -- Bug 2731618. Added the below cursor to fetch the fnd_user name from

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

Line 132: FROM hr_employees_current_v hecv, fnd_user fu

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:

Line 194: -- Bug 2731618. Added the below code to fetch the fnd_user name corresponding

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

Line 195: -- to the requestor full_name onto l_user_name. If a corresponding fnd_user name

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;

Line 217: -- l_user_name, which contains the fnd_user_name of the employee.

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,