[Home] [Help]
51: --p_employee_id
52: -- The HR employee_id with which to record the action.
53: -- This id should correspond to PER_ALL_PEOPLE_F.person_id.
54: -- If NULL is passed, the employee_id will be retrieved
55: -- that corresponds to the current FND user (FND_USER.employee_id).
56: --Testing:
57: --
58: --End of Comments
59: -------------------------------------------------------------------------------
188: --p_employee_id
189: -- The HR employee_id with which to record the action.
190: -- This id should correspond to PER_ALL_PEOPLE_F.person_id.
191: -- If NULL is passed, the employee_id will be retrieved
192: -- that corresponds to the current FND user (FND_USER.employee_id).
193: --Testing:
194: --
195: --End of Comments
196: -------------------------------------------------------------------------------
330: -- None.
331: --Locks:
332: -- None.
333: --Function:
334: -- Retrieves the current FND user_id, login_id, and employee_id.
335: --Parameters:
336: --IN OUT:
337: --x_employee_id
338: -- If the input value is NULL, then this will be updated with
338: -- If the input value is NULL, then this will be updated with
339: -- the employee_id corresponding to the current user.
340: --OUT:
341: --x_user_id
342: -- The current FND user.
343: --x_login_id
344: -- The current FND login ID.
345: --Testing:
346: --
385: HR.employee_id
386: INTO
387: x_employee_id
388: FROM
389: FND_USER FND
390: , HR_EMPLOYEES_CURRENT_V HR
391: WHERE FND.user_id = x_user_id
392: AND FND.employee_id = HR.employee_id
393: ;
387: x_employee_id
388: FROM
389: FND_USER FND
390: , HR_EMPLOYEES_CURRENT_V HR
391: WHERE FND.user_id = x_user_id
392: AND FND.employee_id = HR.employee_id
393: ;
394:
395: l_progress := '130';