[Home] [Help]
1925: order by 1 asc; /* bug 3090563 reverse display order */
1926: l_notification_id number;
1927:
1928: /* Bug 2788683 start */
1929: l_user_name fnd_user.user_name%TYPE;
1930: l_vendor_name hz_parties.party_name%TYPE;
1931: l_party_name hz_parties.party_name%TYPE;
1932: /* Bug 2788683 end */
1933:
2003: */
2004: IF l_history.employee_id IS NULL THEN
2005: SELECT fu.user_name, hp.party_name
2006: INTO l_user_name, l_party_name
2007: FROM fnd_user fu,
2008: hz_parties hp
2009: WHERE hp.party_id = fu.customer_id
2010: AND fu.user_id = l_history.created_by;
2011:
2044: */
2045: IF l_history.employee_id IS NULL THEN
2046: SELECT fu.user_name, hp.party_name
2047: INTO l_user_name, l_party_name
2048: FROM fnd_user fu,
2049: hz_parties hp
2050: WHERE hp.party_id = fu.customer_id
2051: AND fu.user_id = l_history.created_by;
2052:
2584: l_doc_string varchar2(200);
2585: l_preparer_user_name varchar2(100);
2586:
2587: -- Context setting revamp
2588: l_responder_id fnd_user.user_id%TYPE;
2589: l_session_user_id NUMBER;
2590: l_session_resp_id NUMBER;
2591: l_session_appl_id NUMBER;
2592: l_preparer_resp_id NUMBER;
2705:
2706:
2707: SELECT fu.USER_ID
2708: INTO l_responder_id
2709: FROM fnd_user fu,
2710: wf_notifications wfn
2711: WHERE wfn.notification_id = l_nid
2712: AND wfn.original_recipient = fu.user_name;
2713: