263: -- Preparer User Name
264: BEGIN
265: SELECT fup.user_name
266: INTO p_cc_preparer_name
267: FROM fnd_user fup
268: WHERE fup.user_id = l_header_rec.cc_preparer_user_id;
269: EXCEPTION
270: WHEN NO_DATA_FOUND THEN
271: p_cc_preparer_name := NULL;
274: -- Owner User Name
275: BEGIN
276: SELECT fuo.user_name
277: INTO p_cc_owner_name
278: FROM fnd_user fuo
279: WHERE fuo.user_id = l_header_rec.cc_owner_user_id;
280: EXCEPTION
281: WHEN NO_DATA_FOUND THEN
282: p_cc_owner_name := NULL;