921:
922: -------------------------------------------------------------------
923: l_debug_mesg := 'Set user name for the collector';
924: ------------------------------------------------------------------
925: WF_DIRECTORY.GetUserName('PER',
926: l_collector_employee_id,
927: l_collector_user_name,
928: l_collector_display_name);
929:
2014: ----------------------------------------------------------------
2015: l_debug_mesg := 'Get user info for an employee';
2016: ----------------------------------------------------------------
2017:
2018: -- can not use default WF_DIRECTORY.GetUserName to get user info
2019: -- because it can get user name which is not defined in limits
2020: -- table, the reason is multiply user names have been defined for
2021: -- such employee and the first one is returned by GetUserName.
2022: -- need to write a sql function to get user info.
2137: p_item_key,
2138: 'MANAGER_ID',
2139: l_manager_user_id);
2140:
2141: WF_DIRECTORY.GetUserName('PER',
2142: to_char(l_manager_id),
2143: l_manager_user_name,
2144: l_manager_display_name);
2145: