171: WHERE TASK_ID = p_hold_entity_id;
172:
173: CURSOR user_value_cur IS
174: select user_name
175: from fnd_user
176: WHERE user_id = p_hold_entity_id;
177:
178: --ER#7479609 end
179:
311: END hold_name;
312:
313: ------------------
314: function user_name (
315: p_user_id IN FND_USER.USER_ID%TYPE )
316: return VARCHAR2
317: IS
318: l_user_name VARCHAR2(100) := '';
319: BEGIN
318: l_user_name VARCHAR2(100) := '';
319: BEGIN
320: select USER_NAME
321: into l_user_name
322: from fnd_user
323: where USER_ID = p_user_id;
324: return l_user_name;
325: END user_name;
326: -----------------
2142: --ER#7479609 start
2143: ELSIF p_hold_source_rec.hold_entity_code2 = 'CB' THEN
2144: SELECT 'Valid Entity'
2145: INTO l_dummy
2146: FROM fnd_user
2147: WHERE user_id = p_hold_source_rec.hold_entity_id2;
2148: ELSIF p_hold_source_rec.hold_entity_code2 = 'D' THEN
2149: SELECT 'Valid Entity'
2150: INTO l_dummy